File Name: Forecasting – Forecasting Manual Computations
Location: Modeling Toolkit | Forecasting | Forecasting Manual Computations
Brief Description: Illustrates how to use Risk Simulator for running optimization to determine the optimal forecasting parameters in several time-series decomposition models
Requirements: Modeling Toolkit, Risk Simulator
This example model shows the manual computations of the eight time-series decomposition and forecasting techniques in Risk Simulator and how the computations are done. We illustrate the step-by-step computations of backcast and forecast values, plus use Risk Simulator’s optimization routines to find the best and optimal forecast parameters (e.g., Alpha, Beta, and Gamma) that yield the lowest error. The eight methods covered in this model are shown in Figure 83.1.
Figure 83.1: The eight time-series forecasting models
The manual computations are shown in each of the worksheets in the model. In some of the methods, optimization is required to find the best input parameters to backcast-fit and forecast-fit the data going forward. In each method requiring optimization (six of the eight methods, excluding the Single Moving Average and Double Moving Average approaches), a new profile has already been created and the relevant objectives and decision variables have been set up. To run the model, follow these steps:
To recreate the optimization, follow these steps instead: