17 Detail Forecasts Processing Options

This chapter contains these topics:

• Section 17.1, "Supply/Demand Inclusion Rules (P34004),"

• Section 17.2, "Extract Sales Order History (P3465),"

• Section 17.3, "Forecast Generation (P34650),"

• Section 17.4, "Forecast Review (P34201),"

• Section 17.5, "Forecast Revisions (P3460)."

17.1 Supply/Demand Inclusion Rules (P34004)

Processing Option	Processing Options Requiring Further Description
DOCUMENT TYPES:
1. Enter the Document Types for Work Order and Rate you want to setup Inclusion Rules for. The document types can be stacked one after the other for multiple document types. If left blank, 'WOSC' will be used.

17.2 Extract Sales Order History (P3465)

Processing Option	Processing Options Requiring Further Description
PROCESS CONTROL:
1. Enter the Forecast Type for creating actuals.
2. Enter the date range for creating actuals and summarized forecasts: a. From Date (Required) b. Thru Date (Optional)
3. Enter the version of Supply/Demand Inclusion Rules to be used for processing.
4. Enter a '1' to specify weekly buckets. If left blank, monthly buckets will be used.
5. Enter a '1' to extract sales orders from F4211 as well as F42119. If left blank, sales orders are extracted from only the sales order history file (F42119).
SUMMARY RECORDS:
6. Enter a '1' to create summary records for large customers (ABC Type = 'A').
7. Enter a '1' to base the large customer summary on the 'Ship To' address. If left blank, the 'Sold To' address will be used.
SUMMARY FORECASTS:
8. Enter a '1' to create summarized forecast records as well as detail forecast records or a '2' to create only the summarized forecast records. If left blank, only the detail forecast records will be created.
9. Enter the Summary Code to be used to create summarized forecasts.
10. Enter a '1' if you want the Address Book number from the Forecast File to be used to retrieve the Address Book Category Codes. If left blank, the Cost Center will be used to determine which Address Book number to use to retrieve the Category Codes.
FISCAL PATTERN:
11. Enter the Fiscal Date Pattern to use for creating actuals. If left blank, the pattern specified for company '00000' will be used. The Fiscal Patterns must include a 'Begin Date'. For best results, the pattern must extend to include the last Sales Order History date.
INTERBRANCH SALES ORDERS:
12. Enter a '1' to use sales branch instead of supply branch for interbranch sales orders.
13. Enter the interbranch order type(s). To specify more than one order type, type them one after the other along this field. (e.g. 'SIS1S2')

17.3 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.

17.4 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.

17.5 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.