Tips for entering forecasts in work in progress (WIP) schedules

You can save time entering PM and CFO forecasts using the buttons above the grid. Select up to 100 projects at a time, and then select one of the buttons to enter forecast values for the selected projects. If there are already forecast values entered, they'll be replaced.

To customize how many WIP projects are shown in the grid, go to More actions > Table size.

Buttons for entering PM forecasts

The WIP schedule grid with the buttons for updating PM forecasts circled.

Button Description
Update PM values with project values

For each selected project, replaces the current PM forecasts with values taken from the project contract and estimates for the project.

  • PM forecast cost to complete is updated with estimated cost to complete
  • PM forecast cost at completion is updated with total revised estimate
  • PM forecast pct complete (%) is updated with estimated percentage complete
  • PM forecast contract value is updated with total contract value
Update PM values with PM values from prior period

For each selected project, replaces the current PM forecasts with the PM forecasts from the prior period's WIP schedule.

The following fields are updated:

  • PM forecast cost to complete
  • PM forecast cost at completion
  • PM forecast pct complete (%)
  • PM forecast contract value

Buttons for entering CFO forecasts

The WIP schedule grid with the buttons for updating CFO forecasts circled.

Button Description
Update CFO values with PM values

For each selected project, replaces the current CFO forecasts with the current PM forecasts.

  • CFO forecast cost to complete is updated with PM forecast cost to complete
  • CFO forecast cost at completion is updated with PM forecast cost at completion
  • CFO forecast pct complete (%) is updated with PM forecast pct complete (%)
  • CFO forecast contract value is updated with PM forecast contract value
Update CFO values with CFO values from prior period

For each selected project, replaces the current CFO forecasts with the CFO forecasts from the prior period's WIP schedule.

The following fields are updated:

  • CFO forecast cost to complete
  • CFO forecast cost at completion
  • CFO forecast pct complete (%)
  • CFO forecast contract value
Set project costs to complete (100%)

For each selected project, copies the job to date costs to CFO forecast cost at completion, which causes the CFO forecast percent complete to be calculated as 100%.

This button lets you easily update forecasts to show that a project is complete in terms of costs.
Set billings to complete (100%)

For each selected project, copies the job to date billings to CFO forecast contract value. This amount is then also shown as the amount that's been earned to date, which reduces any job to date overbilled or underbilled amounts to zero.

This button lets you easily update forecasts to show that a project is complete in terms of billings.