Support Central
Set the forecast calculation method at the control element level in your worksheet.
Note: Some forecast and percent complete methods are incompatible. For a detailed list see Compatible Forecast and Percent Methods for more information.
Forecasts are calculated in the Cost worksheet based on forecast methods applied to control elements.
You may need to use the scroll bar at the bottom of the table data grid to get to the relevant forecast fields in your cost worksheet.
Changes to forecast options and defaults can be made at the organization data, project data and at the control account level. Keep in mind that Organization level settings will cascade down to all new projects and project level settings.
Project options define whether forecasts can be edited and adjusted manually, or if project changes are required in order to manually adjust the forecasts.
In the following table:
| Estimate to Complete | Description | Affected by Productivity | Edits |
|---|---|---|---|
| ETC 1: ETC = User controlled value + (automated system adjustments) | User enters ETC in control elements and forecast is calculated as ETC + commitments. ETC is automatically reduced as commitments are made | Manual | |
| ETC 2: ETC = Efficiency Factor x (Approved Budget - Earned Value) | ETC = Remaining effort x productivity | Yes | Change Management |
| ETC 3: ETC = Approved Budget - All Commitments | ETC = Approved Budget - Commitments (with negative ETC if commitments exceed budget) | Change Management | |
| ETC 4: ETC = Manually entered value | User enters ETC in control elements and forecast is calculated as ETC + commitments ETC is not automatically reduced as commitments are made | Manual | |
| Estimate to Complete | Description | Affected by Productivity | Edits |
| EAC 1: EAC = User controlled value + (automated system adjustments) | User enters forecast in control elements and ETC is calculated as EAC – commitments ETC is automatically adjusted down as commitments are made | Manual | |
| EAC 2: EAC = Approved Budget / CPI | Forecast = approved budget divided by productivity e.g. 100,000 / 0.8 = 125,000 | Yes | Change Management |
| EAC 3: EAC = All Actuals + (Approved Budget - Earned to Date) | Forecast based on measured progress (earned value) and all actuals to date from direct actuals and payment applications relative to the approved budget. | Change Management | |
| EAC 4: EAC = All Actuals + (Approved Budget - Earned to Date)/CPI x SPI | As above / CPI x SPI CPI could be 1.5 (productive) SPI could be 0.8 (behind schedule) 1.5 x 0.7 = 1.05 175,000 / 1.05 = 166,667 | Manual | |
| EAC 5: EAC = Manually entered value | User enters in manual forecast in control elements and ETC is calculated from that (EAC - commitments), ETC is not automatically adjusted down as commitments are made | Manual |
The forecast method selected at the control element level determines which method is used. Changing the control account or project, after the control element is created, will not override the control element setting.
Note FCC and FFC used in Australia in place of ETC, EAC.
If the project settings allow changes to be entered manually, you can edit the forecasts in the cost worksheet against each control element.
Note: you cannot manually update control element forecast data unless this is authorized in the change management settings.
The selected forecast method will determine which forecast column you are able to edit.
