Forecasts (IC19.1)
Use Forecasts (IC19.1) to set up item quantity and amount forecasts for a location. Quantity forecasts are used in IC120 (Economic Order Quantity and Reorder Calculation) to calculate the Economic Order Quantity and in DR100 (Distribution Requirements Report) to calculate the Time-Phased Order Point.
More Information
This form lets you set up item forecasts for up to 14 periods at a time. The number of periods you set up depends on the number of periods defined in IC01.2 (Period End Dates). For example, if 12 monthly periods are set up, you set up item forecasts for 12 periods, each period representing one month. If 52 weekly periods are set up, you set up item forecasts by the quarter (1, 2, 3 or 4) one at a time. Each quarter represents 13 weekly periods. For leap year only, you can set up the fourth quarter with 14 weekly periods.
- First quarter (1-13).
- Second quarter (14-26)
- Third quarter (27-39).
- Fourth quarter (40-52).*
*For leap year only, the fourth quarter uses periods 40 through 53.
Use action codes to speed the process of entering item forecasts. Select the Spread action to evenly divide first period totals into 12 monthly periods or 13 weekly periods. (If the totals are not evenly divisible, remainders are added to the last period.) Select the Duplicate action to copy period field values to blank period field(s). New field values are copied as they are encountered. This process continues until all period fields are filled.