How to use Forecasting module for ‘Total costs to complete’

This addresses the functionality in the Forecasting module to facilitate the ‘Total Cost to Complete’ scenario, as used predominately by Commercial Builders, resulting in the Job Performance Analysis report.

 

Note the user requires prior knowledge of the Job Costing module, and functionality surrounding the setting up of a job. Should you require assistance, please contact your training representative.

 

1.   Open the Job Costing module

2.   Create a Job

3.   Create a Job Budget (original)

4.   Save the job, and exit the Job Costing module.

5.   Open the Forecasting Module

6.   Find and highlight the Job code for the job created in step 2

7.   Press New

8.   On the Forecast window –

9.   In field Forecast, type in an appropriate name

10. Tick Current check box

11. Set Last Actual to expected end of job

12. Set Last Forecast to any period after step c

13. Click Refresh

14. Press BAL. All and select Yes to the prompt

15. Use the forecast window to expand / collapse trades to locate each cost centre you wish to adjust the total cost to complete forecast figure.

16. Once the cost centre has been found, double click to bring up the Maintaining Forecast window

17. In the Forecast section of the window, note the date of the forecast, change remarks and value.

18. The Date should be set near expected end of project

19. Change Remarks can be clicked into and any notes made (i.e. April07 Forecast)

20. Value should be the expected Total Cost to complete value.

21. Repeat from step 10 until all cost centres desired to be forecasted has been complete.

22. Save the forecast and exit the Forecasting module.

23. On the next update of the forecast, you can now use proper Last Actual and Last Forecast periods. The setting of step 8 is to ensure that the forecasted total cost to complete value does not expire throughout the life of the project.

24. Following is an explanation of the columns in the report.

 

Column

Description

Original Budget

As the name suggests

Variations

Approved or Unapproved variations

Total Budget

The sum of the Original Budget + Variations

Budget Committed (Order/Contract)

Purchase Orders and Contracts Raised Value for Job (inclusive figure from the Costs to Date – Invoiced with Commitments)

Budget Committed (Other Budget Used)

Vouchers, disbursements, timesheets and unlinked invoices entered against the job (inclusive of the Costs to Date – Other Budget Used)

Budget Committed (Total Committed)

The sum of the two former Budget Committed columns – Order/Contract and Other Budget Used.

Cost to Date (Invoiced With Commitments)

Invoices that have been entered against the job that has links to a purchase order or contract (Budget Committed – Order/Contract)

Cost to Date (Other Budget Used)

Disbursements, timesheets and unlinked invoices entered against the job

Costs to Date (Total Costs)

The sum of the previous Costs to Date (Invoiced with Commitments and Other Budget Used)

Costs to Complete

Forecasted value less either the Budget Committed (Total Commitments) total or Total Costs to Date as selected on the report options window.

Future Forecast

Forecasted value for the cost centre as defined in the forecasting module as at expected end of project - total cost to complete (refer to the FAQ for Total Cost to Complete in Forecasting.

Overrun

Difference between Total Budget and Future Forecast where the forecast is more than the total budget

Underrun

Difference between Total Budget and Future Forecast where total budget is more than the future forecast.