How is the estimate at completion figure calculated for different user preference settings?
Let’s take a project that runs from January to December and say the current month is
August:
| Calculation
month | Use maximum of actual vs forecast | Forecast month | Calculation |
| Two months ago | Yes | – | Actuals(Jan to May)+Max(Actuals(Jun) vs Forecast(Jun)) +
Forecast(Jul to Dec) |
| Last month | Yes | – | Actuals(Jan to Jun)+Max(Actuals(Jul) vs Forecast(Jul)) +
Forecast(Aug to Dec) |
| Current month | Yes | – | Actuals(Jan to Jul)+Max(Actuals(Aug) vs Forecast(Aug)) +
Forecast(Sep to Dec) |
| Next month | Yes | – | Actuals(Jan to Aug)+Max(Actuals(Sep) vs Forecast(Sep)) +
Forecast(Oct to Dec) |
| Two months ago | No | One month before | Actuals(Jan to Jun)+Forecast(May to
Dec) |
| Two months ago | No | Same month | Actuals(Jan to Jun)+Forecast(Jun to Dec) |
| Two months ago | No | One month after | Actuals(Jan to Jun)+Forecast(Jul to Dec) |
| Last month | No | One month before | Actuals(Jan to Jul)+Forecast(Jun to
Dec) |
| Last month | No | Same month | Actuals(Jan to Jul)+Forecast(Jul to Dec) |
| Last month | No | One month after | Actuals(Jan to Jul)+Forecast(Aug to Dec) |
| Current month | No | One month before | Actuals(Jan to Aug)+Forecast(Jul to
Dec) |
| Current month | No | Same month | Actuals(Jan to Aug)+Forecast(Aug to Dec) |
| Current month | No | One month after | Actuals(Jan to Aug)+Forecast(Sep to Dec) |
| Next month | No | One month before | Actuals(Jan to Sep)+Forecast(Aug to
Dec) |
| Next month | No | Same month | Actuals(Jan to Sep)+Forecast(Sep to Dec) |
| Next month | No | One month after | Actuals(Jan to Sep)+Forecast(Oct to Dec) |
| | | |