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. |
|
|
|
2. |
|
|
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.