Forecasting Time Periods

Time Periods used in Forecasting

Forecast Year To Date

The data recorded in Actuals is stored period by period in the Forecast scenario. Forecast Year To Date provides a sub-total for this data. Expanding the sub-total will display each of the periods to date.

Forecast Year Remaining Periods

The forecast for the remaining periods is stored and sub-totalled here, to be added to the Year To Date info. Expanding the sub-total will display each of the remaining periods.

Forecast Year Total

This amount totals the Forecast Year To Date plus the Forecast Year Remaining Periods.

Entering Data

Data may be entered

1. To the individual time periods - sub-total for Remaining Periods and Forecast Year Total will be updated;
2. To the Forecast Year Remaining Periods. The amount will be spread over each of the remaining periods and Forecast Year Total will be updated;
3. To the Forecast Year Total. {Forecast Year Total - Forecast Year To Date} will be spread over the remaining periods.

Demo

A demo of (opens in a new window)forecasting data entry and time periods is available here.