52 Forecasting Review Processing Options

This chapter contains these topics:

Section 52.1, "Forecast Generation (P34650),"
Section 52.2, "Forecast Review (P34201),"
Section 52.3, "Forecast Revisions (P3460)."

52.1 Forecast Generation (P34650)

Processing Option	Processing Options Requiring Further Description
FORECASTING METHODS:
Enter a '1' by the method(s) desired:
1. Percent Over Last Year a. Enter the percentage of change over last year. For example, use 1.10 for a 10% increase, or 0.97 for a 3% decrease.
2. Calculated Percent Over Last Year a. Enter the number of periods to include in the percentage.
3. Last Year to This Year
4. Moving Average a. Enter the number of periods to include in the average.
5. Linear Approximation a. Enter the number of periods to include in the ratio.
6. Least Squares Regression a. Enter the number of periods to include in regression.
7. Second Degree Approximation a. Enter the number of periods to include.
8. Flexible Method (Percent over N periods prior.) a. Enter the number of periods prior. b. Enter the percent over the prior period.
9. Weighted Moving Average a. Enter the number of periods b. Weight for one period prior c. Weight for two periods prior d. Weight for three periods prior e. Weight for four periods prior f. Weight for five periods prior g. Weight for six periods prior h. Weight for seven periods prior i. Weight for eight periods prior j. Weight for nine periods prior k. Weight for ten periods prior l. Weight for eleven periods prior m. Weight for twelve periods prior Note: Weights must add up to 1. If weights are entered for periods greater than the number of periods to include, they will not be used. If no weight is entered for a period within the number of periods to include, a zero weight will be used for that period.
10. Linear Smoothing a. Enter the number of periods to include in smoothing average.
11. Exponential Smoothing a. Enter the number of periods to include in smoothing average. b. Enter the alpha factor. If left blank, alpha will be calculated.
12. Exponential Smoothing with Trend and Seasonality Factors a. Enter the alpha factor. If left blank, alpha will be calculated. b. Enter the beta factor. If left blank, beta will be calculated. c. Enter a '1' to include seasonality in the calculation. If left blank, seasonality will not be included.
RECORD TYPES TO USE:
13. Enter the 'Actual Type' in which the actual information is stored.
14. Enter the Forecast Type to use when creating forecasts.
SUMMARY RECORDS:
15. Enter a '1' to create summary records for large customers. (ABC type = 'A'.)
FORECAST TYPE AND RANGE:
16. Enter a '1' to specify weekly forecasts. If left blank, monthly forecasts will be generated.
17. Enter the date to start forecasts. If left blank, today's date will be used.
18. Enter the number of periods to forecast. If left blank, three periods will be used.
19. Enter the number of periods of actual data to be used to calculate the Best Fit forecast. If left blank, three periods of data will be used.
20. Enter a '1' to calculate best fit using Mean Absolute Deviation. If left blank, Percent of Accuracy will be used.
21. Enter a '1' to run the report in final mode. If left blank, the report will run in proof mode.
22. Enter a '1' to allow negative values to be written. If left blank, negative values will be written as zeroes.
FISCAL DATE PATTERN:
23. Enter the Fiscal Date Pattern Type to use for forecast dating. If left blank, the type specified for company '00000' will be used. (See Company Names-Fiscal Patterns 'P00105' for more information).
BEST FIT AMOUNTS/QUANTITIES:
24. Enter a '1' to calculate Best Fit using amounts. If left blank, quantities will be used to calculate Best Fit.

52.2 Forecast Review (P34201)

Processing Option	Processing Options Requiring Further Description
DEFAULT VALUES:
1. Enter a '1' to display the Amount format first. If left blank, the Quantity format will be displayed.
2. Forecast Type (Optional)
3. Enter the default forecast type for displaying the actual quantities and amounts.

52.3 Forecast Revisions (P3460)

Processing Option	Processing Options Requiring Further Description
DEFAULT VALUES:
1. Forecast Type (Optional)
2. Enter a '1' to default the forecast type from the heading into the detail records on an add.
3. Enter a '1' to display the Amount format first. If left blank, the Quantity format will be displayed.