Issue/Symptom/Question

Standard Crystal Report - Job P&L and Forecast - Detail Report

Applies To

Penta for Windows

Crystal Report - Job P&L and Forecast - Detail Report

Project Management

Resolution/Fix/Answer

Use the Job Project/Loss & Forecast – Detail report to compare estimates, actual costs, and forecast for a job. Each job has three distinct sections:

Estimates, actuals, and forecasts by Costcode/Cost Type.

Estimate, forecast, and actual information on billing, labor, material, gross margin, and markup.

Cash Planning Information – Cash received, cash disbursed, current receivables and payables, deferred (retention), and contract status (original contract, change orders, current contract, billing job-to-date, and remaining billings).

Estimates, actuals, and forecasts by Costcode/Cost Type are included as the first part of the report for the job, and all three parts of the report, as listed above, are included in the report.

Selection

You can limit records displaying on this report by:

Detail or summary report – Use Detail.

Period Begin Date – Use the Period Begin Date and Period Ending Date fields to specify the period for which the report is valid. The report includes transactions posted during this period.

Period Ending Date

Ending Date – Use the Ending Date field to specify the date through which the report is valid. The report includes transactions entered through this date.

Job Id

OU Id

Customer Id

Job Status

Costcode

Cost Type

Job Type

Project Manager

Sales Person Id

Sort

Records sort in order by:

Job Id
Cost Type
Costcode

Grouped By

This report contains sub-totals for each Cost Type and Job Id. Grand totals for all jobs in the report are on a separate final page.

Page Breaks

Each Job Id begins on a new page.

Report Code: jc_jobPLTcstDtl_enhcd_p65_cr11.rpt

Available Parameters:

Example Report Results:

Row Headings and Estimate - There are two lines for estimates. The top line is the current estimate through the Ending Date in the selection criteria. The second line is the original estimate through the Ending Date in the selection criteria.

Costcode - Id of the Job’s Costcode.

CC Description - Description of the Job’s Costcode.

Cost Type - The Job’s Cost Type.

Commit To Date - The sum of subcontracts and purchase orders to date.

Remain Commit - These are open commitments, which are subcontract and purchase order committed amounts less amounts invoiced to date.

Units UM - The Units and Unit of Measure entered in the estimate for the Costcode and Cost Type, if any.

Per Unit - This is one of the following:

The Unit Cost entered in the estimate for the Costcode and Cost Type, if any.

The calculated value is: Lump Sum Amount ÷ Units

Cost - This is one of the following:

The Lump Sum Amount entered in the estimate for the Costcode and Cost Type, if any.

The calculated amount is: Estimated Units ÷ Estimated Unit Cost

Hours - The number of Hours entered in the estimate for the Costcode and Cost Type, if any.

Actual Fields - This block contains costs charged to the job through the Ending Date in the selection criteria. There are two lines for actual costs. The top line is the actual cost posted to the Cost Type and Costcode through the Ending Date in the selection criteria. The second line is the actual cost posted to the Cost Type and Costcode for the period of Period Begin Date through Period Ending Date in the selection criteria.

Units - The number of units entered, if any.

Per Unit - PENTA calculates this value as: Actual Cost ÷ Actual Units

Cost - The sum of the actual costs posted to this Cost Type and Costcode.

Hours - The number of Hours entered, if any.

Forecast Fields - This block contains data on the forecast through the Ending Date in the selection criteria.

Units - Per Unit - The top line is the number of units in the forecast at completion. The second line is the Per Unit cost.

F-T-C

F-A-C

The top line is the Forecast to Complete in your currency. The second line is the Forecast at Complete in your currency.

Penta Knowledge Base