Issue/Symptom/Question

Standard Crystal Report - Job Cost Allocation

Applies To

Penta for Windows

Crystal Report - Job Cost Allocation

Project Management

Resolution/Fix/Answer

Use the Job Cost and Allocation report to calculate overhead cost allocations to jobs as part of the month end close process.

Before running this report, you should:

Establish a separate Cost Type/Costcode for each overhead category you wish to track.

Establish an estimate and forecast for each overhead category at the start of the job.

Each month, calculate the cost to allocate to the job—based on the percentage of labor complete (Actual labor cost ÷ Forecast labor cost).

Report Code: jc_jobCostAlloc_p141_cr11.rpt

Available Parameters:

Example Report Results:

Report Fields

Job ID - ID of the job with allocated cost.

Job Name - Name of the job.

Labor Forecast @ Compl - The sum of forecast at complete entries as of the report through date for the Job’s Costcodes where the Cost Type category is Labor or Overtime Labor.

JTD Labor Cost - The job to date cost as of the report through date for the Job’s Costcodes where the Cost Type category is Labor or Overtime Labor.

% Complete - PENTA calculates this as: Job to date labor cost ÷ Labor forecast at complete

Alloc Cost Type - The type of cost you are making the allocation to.

Alloc Costcode - The Costcode you are making the allocation to.

Alloc Forecast @ Compl - The current forecast at complete for the Cost Type/Costcode allocation as of the report through date.

JTD Alloc - The job to date allocation. PENTA calculates this as: Forecast at complete * % complete

Prev JTD Alloc - PENTA calculates this as: Current forecast at complete for the allocation Cost Type/Costcode * (Job to date labor cost ÷ Labor forecast at complete). This uses amounts as of the most recent accounting period end date that are less than the report through date.

Current Month Alloc - PENTA calculates this as: JTD Allocation – Previous JTD Allocation.