Complete Job Cost Analysis Report

The Complete Job Cost Analysis Report is a comprehensive report which shows actual overall units, actual and estimated quantities, original, current and remaining budgets and cost and percent complete to-date. Variances for current and projected costs are shown.

This report is accessible through Job Costing Analysis Reports. To print this report, check the Complete radio button under the Report Formatting tab.

There are two possible reports available.

1.

Report Description - Complete Job Cost Analysis (Detail)

 

Report Description - Complete Job Cost Analysis (Summary)

2.

Report Sample - Complete Job Cost Analysis (Detail)

 

Report Sample - Complete Job Cost Analysis (Summary)

Report Description - Complete Job Cost Analysis Report (Detail)

Heading

The report heading consists of the report title, date, page number and company name. The limits set at the time of printing are also included.

Cost Code

This is the cost code or job phase. Following the code number is the code type (Labor, Materials, Subcontracts, Equipment or General). If a grouping code is assigned, the code is printed behind the code type.

Description

This column contains the name or description of the cost code for the job phase listed.

Estimate

This column gives the estimated quantity for the job phase. If the job phase is a subcontract, the subcontractor name and number is printed in place of the quantity.

Used To-Date

This is the recorded quantity to-date. If field reports are used to update this field, the quantity will be the information entered from the latest field report. If the system is tailored to use invoice information only, the field will contain only quantities from entered and posted invoices.

Field Report %

This is the percent complete as of the last field report. If percent complete is not entered on the field report, this field will be empty.

Calc

This is the calculated percent complete. If percent complete is to be entered on the field report and the field report is not current, this field is calculated as explained above. If cost to complete or total completion cost is entered on the field report, this field is calculated for the latest information.

Original

This is the original budget for the job phase.

Current

This is the current budget for the job phase.

Remaining

This field contains the difference between the current budget and the cost-to-date. It is the unspent portion of the budget.

Variance

This field shows the difference (in dollars) between the current costs and the costs that should have been incurred at this point in the phase.

Costs To-Date

This is the actual cost to-date as recorded through the accounting system. This would include amounts charged to the job through Accounts Payable, Payroll, General Ledger and/or other modules. Cost to-date figures are derived directly from the job cost file. In the case of costs accrued through Accounts Payable, this cost to-date field is updated every time an invoice is posted. For this reason, the cost to-date columns on this reports reflect all invoices posted, whether they are paid or not.

Projected

This field is the projected completion cost . If field reports include a total completion cost, that amount will be listed in this field. The projected cost is calculated if a percent complete or other method is used to report job progress.

Overrun

This column shows the dollar amount that each job phase is over or under budget using the projected cost versus the current budget. A negative amount means the cost phase was completed at a lower cost than currently budgeted.

Subtotals

Each group of related job or cost codes are subtotaled for budgets, variances, costs and overrun. The sub-totals are listed after the last related code.

Job Totals

Each column is totaled for budgets, variances, costs and overrun. The totals are listed at the bottom of the report.

Report Description: Complete Job Cost Analysis Report (Summary)

The Summary Format is identical to the Detail format except for three exceptions. The cost codes are not itemized, there is no cost code description and the Field Report field is empty.

Cost Code (Subtotal Titles)

The Subtotal titles for each group of cost codes are listed.

Field Report %

This field will be empty.

 

 Report Sample - Complete Job Cost Analysis Report (Detail)

Report Sample: Complete Job Cost Analysis Report (Summary)