Project Cost and Forecast

For Costing and Forecasting, first and foremost refer to the Costing and Forecasting Course for how to forecast.  The following items have been prepared in order to establish a set of rules or ‘tips and tricks’ to be implemented or followed on a monthly basis when preparing your cost reports.  

For any of the below that needs further review or explanation, please direct questions to your Construction Manager. The following is presented in no particular order. Costing and forecasting on a project is essential for understanding the project financials, a true and accurate Project Cost and Forecast Report is critical for the company to predict company financial outlook and manage budget for the ongoing and upcoming fiscal year. This page explains the idea and reason behind the costing and forecasting on projects. For general guide-lines on How-To of the Project Cost and Forecast in Viewpoint Job Cost: Cost Projection, navigate to here.

Typical Monthly Forecasting Notes

Predicted cost

Predicted cost is typically "Actual to Date + Open Commitment + Forecast to Complete = Projected Total"

For projects in Maestro with an Excel print out, DO NOT modify formulas.  Adjustments within the forecast to predict a final cost can be done through forecasting in the M, S, L columns or by working with accounting to correct poor budget entries or excess open PO.

In most instances, there are to be NO negative forecast to completes.  This is largely as work is not to proceed without a change order, and a negative forecast to complete would typically mean costs to come.  A few instances where a negative forecast to complete is appropriate are:

1. Where we have paid a deposit and we anticipate having the money returned.
2. Where the client has instructed work to proceed under a change directive, with final costs to be reconciled after work is completed.
3. Where we have performed work on a trades behalf (backcharge) and the work has not yet been reconciled (refer to backcharge section).

Once again, in all instances, work for the client cannot proceed without a change order or change directive.

Best Practices

Below is the best practice when doing forecasting:

• When forecasting material or Subtrade costs to be incurred, the project manager is to ensure the entries are done in the proper M&S columns of the forecast.
• Further / similar to the above, the project manager is to ensure costs are also forecasted on the correct material, subcontractor or labour lines of the forecast.  You cannot forecast different cost types on the same line.  If the proper cost type does not exist, the cost type is to be opened, and reforecasted.
• Often, costs are incurred in a cost report but against the wrong cost type.  If this should happen, the project manager is to work with their project accountant to reallocate the costs or move budget to the proper cost type line.
• PM’s are to ensure that all budgets not currently contracted/awarded are allocated to the proper cost type in the CTC.  For instance, if final clean is intended to be a trade, the budget should be entered as a subcontract cost type.  Alternatively, if you intend on buying wood direct from a supplier, the costs should be carried as a material code, not subcontractor code. This will help with the ability to review forecasts on a monthly basis and assess percentage of trades bought out, left to award etc. 
• For every projection, proper notes are to be included in the CTC report to allow the reviewer to understand the cost projections and to assist in month over month forecasting. 
• As a project progresses, proper reconciliation of open commitments is required as work scopes are complete.  For instance, at the completion of the concrete structure), formwork, reinforcing steel, concrete supply commitments should be reviewed and rationalised for any remaining costs.  These scopes also get cleaned up.

• For any items that are miscoded, they are to be reconciled monthly.

1. As the PM completes the forecast monthly, they are required to drill down into each cost and confirm proper cost code, and cost type (L,M,S).  For any miscoded items, these are to be sent as part of the forecasting review period to the project accountant to be reconciled.  Verification of completeness is to be done once complete, not in the next billing cycle.
2. Best practice is to also review all items and coding during the monthly billing cycle.  Most miscoded material items can be caught at billing time, making the forecasting cycle much easier.  

• Moving Budgets should only be done in a limited number of instances such as

1. correcting an error in budget upload.
2. moving money to or from the contingency on approved contingency expenditures/reallocations.
3. revision to planned execution.
4. Consolidation of costs codes based on trade award.
5. Budgets should not be modified to fix variance on a line by line basis.

• Cost code creation – only the Project Manager on the job can authorize the creation of a new cost code.  This means a superintendent, or the project accountant cannot open a new code.  When a code is created by the project accountant, it would be expected that the proper steps associated with the code creation has been taken. This can include

1. Creating the proper Change Order or Expenditure authorization to fund the line.
2. Conduct the proper budget reallocation to fund the line.
3. Communication with the client as appropriate.
4. Communication with the project team of the new cost code.

• It is okay to have a variance on a given labour or material line item.  We should never have a variance on a subtrade cost code.  

Report

The project cost and forecast (PCF) report is a document that contains confidential information of the project's financial status. Check the Project Cost and Forecast Report for Detail on how to generate and read it.

ONLY DRAFT BELOW

Typical step-by-step procedure

Progress Tracking and Entering

Project cost and forecasting relies on accurate field record tracking. Although this module will function without complete this, it is still recommended to do the quantity tracking as a good habit. The quantity tracking module can be found in Job Cost Section called "JC Progress Entry". Check the Quantity Tracking in Viewpoint for how to.

Once all the progress has been entered, go to progress batch, and commit this batch to the month of which the work was completed.

Reviewing Project Cost and Forecast to End of Project

First, go to Viewpoint, and locate the JC - Cost Projection.

Double click it, it will show a Form with title of "Batch Selection for {your company name}".

If you have previously opened batches, they will be displayed in the Unposted Batches section.

When initiating a batch, it's crucial to note the Batch Month field. This should correspond to the month being reported on, not the month the report is being submitted. For instance, if you're submitting a Project Cost and Forecast report for July, even if the report is being submitted in August, make sure to select July as the Batch Month.

After clicking 'OK', the 'Cost and Forecast' window will appear. While the columns you see might differ from the default view, we'll guide you on how to adjust them shortly.

In this form, there are four primary sections:

1. Orange-highlighted Area: This displays the Batch Month, Batch #, Date, and Job #. Use the 'Job' textbox to select different projects for PCF.
2. Green-highlighted Area: This section presents the fundamental contract information.
3. Red-highlighted Area: Here, you'll see all the cost codes related to your project. This includes inactive codes as well as codes without a budget or cost.
4. Indigo-highlighted Area: This area showcases all the specific data for the chosen cost code. The buttons situated at the bottom offer additional functionalities and serve as shortcuts to related forms for a more in-depth look.

A project permits only one person to conduct PCF at a given time and can exist in just one batch simultaneously. If you mistakenly open someone else's project, you have two options: either submit all your current changes or cancel your existing batch and restart the process.

You can adjust what columns to see and adjust the orders in Projection Options, follow GIF below:

the Columns I recommend you select and set in order are below:

As stated in the Morley Hopner - Costing and Forecasting Fundamentals, the Project Manager or Acting PM should go through Cost Report line by line when performing cost forecast. Below I will demonstrate with 2 examples, to showcase Labour and material/Subcontract cost and forecasting.

Labour Cost Lines

Material/Subcontract Cost Lines

Demonstrate the actual vs remaining, this is tied with the field progress tracking we did previously. Try change the remaining units, or hours, or cost directly. or change the over/under.

The Project Cost and Forecast module can be found under Job Cost section, it is called "JC Cost Projection".

• If there is no open batches exist, you can create a new batch by select "Create a new batch", then select the Month of the Cost Occurred, then click "OK".
• If there is open batch you previously, select the batch, and click "Ok".

insert <gif>

After doing this the window for Project Cost and Forecast will appear. For new batch, you will need to input the project number and select a date. This date determines the cut off date for the cost, typically you can set it to the last work day of the month your batch is opened at. The window will have the layout as below. the columns order on your screw might be different from what's shown here. insert <pic>