18 Summary Forecasts Processing Options

This chapter contains these topics:

18.1 Summary Constants (P4091)

Processing Option Processing Options Requiring Further Description
PROCESSING CONTROL :  
1. Enter a '1' next to the type of Category Code Key Positions you would like to see first.

If both categories are left blank then the Item format will display first.

Address Book . . . . . . .

Item . . . . . . . . . . .

 

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

 

18.3 Forecast Summary (P34600)

Processing Option Processing Options Requiring Further Description
PROCESSING CONTROL:  
1. Enter the Summary Code.  
2. Enter the Forecast Type.  
3. Enter the Date Range:

a. From Date

b. Thru Date

 
4. Enter a '1' to use the Address Book Number from the Forecast file (F3460) to retrieve Category Codes.

If left blank, the Address Book Number from the Cost Center will be used.

 

18.4 Forecast Summary Inquiry (P34200)

Processing Option Processing Options Requiring Further Description
DEFAULT INFORMATION:  
1. Summary Code  
2. Enter Forecast Types for the following:

a. Forecast

b. Actual

 
3. Enter a '1' to display the Quantity format first.

If left blank, the Amount format will be displayed.

 
DREAM WRITER VERSIONS:

Enter the version for each program.

If left blank, 'ZJDE0001' will be used.

 
4. Summary Revisions (P3400)  
5. Detail Revisions (P3460)  

18.5 Forecast Forcing (P34610)

Processing Option Processing Options Requiring Further Description
PROCESSING CONTROL:  
1. Enter a code to indicate which direction to force changes.

1 = Up the hierarchy

2 = Down the hierarchy

If left blank, changes will be forced in both directions.

 
2. Enter a '1' to reset the Revised flag on the records in the file.

If left blank, the flag will only be reset if option 1 is blank.