Committed Cost Report

Top  Previous  Next

The Committed Cost Report is perhaps the most import report in the system for tracking costs against projected budgets and identifying budget overruns in a timely manner.  The committed cost report shows estimate and cost variances much like the job cost capsheet report except that the committed cost report can project budget overruns long before costs are posted to the job by taking into account the 'committed costs' (ie. purchase orders, subcontractor order and subcontractor payment sheets).

 

Once a cost commitment is entered to a job via a purchase order, subcontract order or subcontractor payment sheet, the committed cost will be used in the formula to project the final revised cost of the project.  This final revised cost is then compared to the estimated cost to see if an overrun exists.  In contrast, the job cost capsheet report will only project overruns once all the costs are entered into the system which may be too late to make any adjustments to help rectify the overrun situation.

 

The committed cost report has several options from basic one line summary per job to a full detail with supporting cost and commitment transactions.

 

Job Only
One line summary per job.
 
Job & Phase
Job and phase totals
 
Job, Phase, & Vendor
Job and phase totals with vendor subtotals for each phase
 
Job, Phase, Vendor, & CC
Job, phase, and vendor totals with further breakdown of each committed cost (purchase order or subcontractor payment sheet)
 
Full Detail
Same as preceding report with detail of all cost transactions.
 
Full Detail & Contract Items
Same as the Full Detail option with itemized listing of all committed cost entries for purchase orders and subcontracts.

 

Special Note on the Committed Cost Report:

 

The committed cost report is not a standard accounting report but rather a project management report which is used specifically for isolating cost line items on a job that are running over budget. In this report only, the calculations in the report headings are computed on each line individually, including the job totals and report totals lines. The totals are computed this way in order to look at the totals in four different ways:

 

Job Only – one line summary per job

Job & Phase – job and phase totals (as shown in AccuBuild Features Brochure)

Job, Phase, & Vendor – job and phase totals with vendor subtotals under each phase.

Job, Phase, Vendor, & CC – job, phase, and vendor totals with further breakdown of each committed cost (purchase order / subcontract)

 

The best way to detect problems with cost overruns is at the detail level (Job, Phase, Vendor, & CC option). This is where you will uncover the overruns.  The reason why each line total is computed individually is because in a lot of cases, budgets have been covered under one line item, but the costs end up on another line item due to improper coding of a vendor invoice, employee time card etc. This is very common when field labor is not reported accurately.

 

For example, a concrete contractor might have 3 labor codes on a job for the following tasks:

 

 10.10 – Concrete Forms

 10.20 – Concrete Finishing

 10.30 – Concrete Flatwork

 

If the vendor invoices are properly coded to each line item but the labor costs are all lumped into 10.10 Concrete Forms, then this cost line item will show Projected Costs in Excess of Estimate on line 10.10 but there is NO real cost overrun because the estimates are covered under the 10.20 & 10.30 phases.

 

With the AccuBuild Committed Cost Report, the project manager can run the job with a partial phase option on these three phases only, and the totals will give a true analysis of whether or not the labor items in total have an overrun.

 

MAR Version Only - The user datapipe called ClientAddressList which contains all the vendor/customer names and addresses can be added and linked on the Data Tab of the Committed Cost Report in order to incorporate the client information on the report. (Version 8.5.0.2 Red)