Method 1-3

These processing options specify which forecast types that the system uses when calculating the best fit forecast. You can also specify whether the system creates detail forecasts for the selected forecast method.

Enter 1 to use the forecast method when calculating the best fit. The system does not create detail forecasts for the method. If you enter zero before the forecast, for example, 01 for Method 1: Percent Over Last Year, the system uses the forecast method when calculating the best fit and creates the forecast method in the Forecast File table (F3460). If you leave the field blank, the system does not use the forecast method when calculating the best fit and does not create detail forecasts for the method.

A period is defined as a week or month, depending on the pattern that is selected from the Date Fiscal Patterns table (F0008). For weekly forecasts, verify that you have established 52 period dates.

1. Percent Over Last Year

Specify which type of forecast to run. This forecast method uses the Percent Over Last Year formula to multiply each forecast period by a percentage increase or decrease that you specify in a processing option. This method requires the periods for the best fit plus one year of sales history. This method is useful for seasonal items with growth or decline. Values are:

Blank: Does not use this method.

1: Calculates the best fit forecast.

01: Uses the Percent Over Last Year formula to create detail forecasts.

2. Percent

Specify the percent of increase or decrease used to multiply by the sales history from last year. For example, type 110 for a 10 percent increase or type 97 for a 3 percent decrease. Values are any percent amount, however, the amount cannot be a negative amount. Enter an amount to use or select it from the Calculator.

3. Calculated Percent Over Last Year

Specify which type to run. This forecast method uses the Calculated Percent Over Last Year formula to compare the periods specified of past sales to the same periods of past sales of the previous year. The system determines a percentage increase or decrease, then multiplies each period by the percentage to determine the forecast. This method requires the periods of sales order history indicated in the processing option plus one year of sales history. This method is useful for short term demand forecasts of seasonal items with growth or decline. Values are:

Blank: Does not use this method.

1: Calculates the best fit forecast.

02: Uses the Calculated Percent Over Last Year formula to create detail forecasts.

4. Number of Periods

Specify the number of periods to include when calculating the percentage increase or decrease. Enter a number to use or select a number from the Calculator.

5. Last Year to This Year

Specify which type of forecast to run. This forecast method uses Last Year to This Year formula which uses last year's sales for the year's forecast. This method uses the periods best fit plus one year of sales order history. This method is useful for mature products with level demand or seasonal demand without a trend. Values are:

Blank: Does not use this method.

1: Calculates the best fit forecast.

03: Uses the Last Year to This Year formula to create detail forecasts.