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) |