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 projects (for best performance, select fewer than 500 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 forecasts 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 forecasts with PM forecasts 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
Update PM forecasts based on primary forecast estimate

For each selected project, replaces the current PM forecasts (except PM forecast contract value) with values based on the project's primary forecast estimate.

  • PM forecast cost at completion is calculated based on estimate entries in the project's primary forecast estimate. Estimate entries are included if they have a workflow type of original, revision, or approved change.

    If a project does not have a primary forecast estimate, the PM forecast cost at completion is set to zero.

  • PM forecast cost to complete is calculated based on the PM forecast cost at completion
  • PM forecast pct complete (%) is calculated based on the PM forecast cost at completion

Buttons for entering CFO forecasts

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

Button Description
Update CFO forecasts with PM forecasts

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 forecasts with CFO forecasts 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