Job Cost Analysis Report : Committed Cost

This report shows committed costs, actual costs and percent complete to-date. Variances for current and projected costs are shown. NOTE: This is the only report that reflects costs that have been committed through purchase orders.

This report is accessible through Job Costing Analysis Reports.

To print this report, check the Committed Costs radio button under the Report Formatting tab.

see Print Change Order Detail for Current Budget
 see New Page for Each New Job
 see Print Order
 see Detail Level
 see Orientation Level

There are two possible reports available.

1.

Report Description - Committed Cost Report (Detail)

 

Report Sample - Committed Cost Report (Detail)

2.

Report Description - Committed Cost Report (Summary)

 

Report Sample - Committed Cost Report (Summary)

Report Description (Detail Format)

Heading

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

Cost Code Description

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

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.

C/O

This is the Change Order for this cost code or job phase. Following the change order is a description of the change order and the cost.

Reported Percent Complete (RPT)

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

Calculated Percent Complete (CLC)

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.

Committed Percent Complete (CMT)

This column shows the calculated percent complete using the total actual and committed costs. It is calculated in the same manner as % complete but using the total actual cost added to committed costs.

Original Budget

This is the original budget for the job phase.

Current Budget

This is the current budget for the job phase.

Actual Costs

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.

Committed Costs

This field contains the total of expected or committed costs that are due to open purchase orders. When a purchase order is reconciled with an A/P invoice, costs are removed from this column. Be aware that this means that between the time the purchase order is reconciled and the A/P invoice is posted, the cost is essentially lost from this report. Normally, this is not a problem since invoices are usually posted soon after the reconciliation when the purchase order is complete. Be advised that this condition does exist.

Total Costs

This is the sum of the actual costs and the committed costs.

Actual Remaining Budget

This field contains the difference between the current budget and the actual costs. It is the unspent portion of the budget.

Uncommitted Remaining Budget

This field contains the difference between the current budget and the total costs. It is the uncommitted unspent portion of the budget.

Projected Overrun

This column shows the percent that each job phase is over or under budget. A negative amount means that the cost phase is at a cost less than currently budgeted.

Phase Subtotals

Each group of related job phases is subtotaled for budgets, variances, costs and overrun. The sub-totals are listed after the last related phase 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 (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 (Detail Format)

Report Sample (Summary Format)