# FORECAST.REPORT

The FORECAST.REPORT program produces a standard report of a forecast created using the FORECAST command.

The report shows the parameters of the forecast, including the forecast formula and Mean Absolute Percent Error, followed by a display of the forecasted values.

Syntax

FORECAST.REPORT

Examples

Example 9-140 Report of Forecast Using the EXPONENTIAL Method

Assume that you have performed the forecast illustrated in Example 9-138, "Using the EXPONENTIAL Method". Running the FORECAST.REPORT program for that forecast produces the following report.

```                     Forecasting Analysis
====================

Variable to Forecast: SALES
Forecast dimension: MONTH
Forecast method: EXPONENTIAL
Mean absolute percent error: 16.64%

Forecast Equation: SALES = 87718.0009541883 *
(1.00553383457899 ** MONTH)

MONTH                   Actual Value    Fitted Value
--------------------    ------------    ------------
Jan95                      72,123.47       88,203.42
Feb95                      80,071.75       88,691.52
Mar95                      78,812.69       89,182.33
Apr95                      97,413.26       89,675.85
May95                      94,406.65       90,172.10
...                        ...               ...
Dec96                      72,095.02      100,140.38
...                        ...               ...
```

Example 9-141 Report of Forecast Using the WINTERS Method

Assume that you have performed the forecast illustrated in Example 9-139, "Using the WINTERS Method". Running the FORECAST.REPORT program for that forecast produces the following report.

```                     Forecasting Analysis
====================

Variable to Forecast: SALES
Forecast dimension: MONTH
Forecast method: WINTERS
Alpha: 0.50
Beta: 0.50
Gamma: 0.50
Periodicity: 12
Mean absolute percent error: 0.20%

MONTH                   Actual Value    Fitted Value
--------------------    ------------    ------------
Jan95                      72,123.47       72,154.67
Feb95                      80,071.75       80,027.51
Mar95                      78,812.69       79,171.08
Apr95                      97,413.26       97,200.81
May95                      94,406.65       94,464.71
....                         ...             ...
Dec97                                      77,867.23
```