Issue/Symptom/Question

Standard Crystal Report - Job Cost Summary Report

Applies To

Penta for Windows

Crystal Report - Job Cost Summary Report

Project Management

Resolution/Fix/Answer

Use the Crystal Job Cost Summary Report to review financial progress of a job. The report contains the following three blocks for each revenue category:

• Cost – Cost-by-Cost Type and Costcode.

• Revenue – Contract amount and billings by invoice line.

• Summary – Summary of costs, contract amount, and billings along with earned revenue and gross profit.

Selection

You can limit records displaying on this report by:

• Group 1 Field, Group 2 Field, Group 3 Field – You can specify subtotals on all the jobs in the report to a maximum of three subtotals. Group 3 subtotals roll into Group 2 subtotals, which roll into Group 1 subtotals. Specify subtotals on any of the following Selection Criteria:

• OU Id

• Project Manager’s Employee Id

• Project Controller’s Employee Id

• Customer Id

• Job Type Code

• Cost Type Code Summarization – You can specify that the report contain subtotals only with no detailed Costcode data for the Cost Type codes entered.

• Trans Dated Through – The report includes all transactions posted through this date. This date prints under the As of report heading.

• Trans Entered Through – The report includes all transactions entered through this date.

• OU Id

• Job Id

• Job Status Code

• Project Manager’s Employee Id

• Project Controller’s Employee Id

• Customer Id

• Job Type

Sort

Records sort in order by:

1. Job Id

1. Sort Sequence field on the Revenue Categories window
2. Cost Type
3. Costcode

Totals

(Optional) This report contains totals for each of the Group Fields specified in the Enter Parameter Values.

This report contains totals for each Job Id.

Grand totals for all jobs in the report by revenue category are on the final page.

Report Code: jc_jobCostSmy_p80_cr11.rpt

Available Parameters:

Example Report Results: 

Report Heading

As Of - This report includes transactions and entries made on or before this date. It is the Include Transactions Dated Through field in the selection criteria.

Job Heading

• Last Transaction PR Date – The Job’s last payroll distribution date that is on or before the As Of date.

• Last Transaction AP Date – The Job’s last accounts payable distribution date that is on or before the As Of date for transactions entered in the Invoice & Credit Memo Entry or Manual Payment Entry window.

Cost Section Fields

Estimate Original - The original cost estimate for the job. It is the sum of the initial cost estimates for all Costcodes assigned to this Revenue Category Code. Cost is the sum of the following:

• Lump Sum Amount

• Units * Unit Cost

• Hours * Hourly Rate

Initial costs are values entered in one of the three following windows, only if the Change Request Id and (estimate) Key are blank:

• The Current Cost Estimate on the Costcode & Estimate Entry window.

• The Review/Modify Cost Estimate window of the Costcode & Estimate Entry window.

• The Estimate Worksheet.

Estimate Revised - The revised cost estimate for the Revenue Category Code. It is the sum of all the cost estimates for all Costcodes assigned to this Revenue Category Code. Cost is the sum of the following:

• Lump Sum Amount

• Units * Unit Cost

• Hours * Hourly Rate

Revised costs are values entered in one of the three following windows:

• The Current Cost Estimate on the Costcode & Estimate Entry window.

• The Review/Modify Cost Estimate window of the Costcode & Estimate Entry window.

• The Estimate Worksheet.

If one of the following is true:

• The Change Request Id and (estimate) Key are blank (original entries).

• The Change Request Id is not blank and the Current Status on the Change Requests window is Approved (approved change requests).

• The (estimate) Key is not blank.

Actuals - The sum of the costs posted to the Costcodes assigned to this Revenue Category Code on or before the As Of report date. Actual costs include all costs charged to the job.

Forecast, Contract, and Billings Section Fields

Forecast - The sum of the Forecast Cost At Completion for the Costcodes assigned to this Revenue Category Code on or before the As Of report date. If a Costcode does not have Forecast Cost At Complete, PENTA calculates it using the Forecast Calculation Rules on the Job Type Information window.

Forecast Variance - PENTA calculates this value from previous fields as: Estimate Revised – Forecast

Contract + Apprvd Chng - PENTA calculates this value as: The sum of the contract value + Change Orders with an Approved status

Billed To Date - The total of the billings on or before the As Of report date.

Summary Section Fields

Total Original - The sum of the Estimate Original values.

Total Revised - The sum of the Estimate Revised values.

Contract Original - The value of the original contract.

Contract Revised - The value of the revised contract.

Earned Revenue - The actual earned revenue calculated by PENTA revenue recognition process.

Gross Margin

• The value in the Original column calculated as: Contract Original – Estimate Original

• The value in the Revised column calculated as: Revised Contract – Estimate Revised

• The value in the Actuals column calculated as: Original Contract – Estimate Original

• The value in the Billed To Date column calculated as: Billed To Date – Estimate Original

S, G and A - The calculated portion of sales, general, and administrative expenses attributable to the job as set up on the Sales, General and Administrative window.

Percent Complete - PENTA calculates this value as: Actuals ÷ Forecast

Total Receivables - The invoiced sum not paid by the customer.

Receivables 31 Days and Older - The sum of receivables open for 31 or more days.

Retention Receivables - The sum of open retentions.