IC19.1 - Forecasts
Use this form to set up item quantity and amount forecasts for a location.
Quantity forecasts are used in IC120 (EOQ and Reorder Calculation) to
calculate the Economic Order Quantity and in DR100 (Distribution Requirements
Report) to calculate the Time-Phased Order Point.
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 (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.
Updated Files
CKPOINT - This file is used in the event of a program or system failure
to enable a batch update program to continue from where it left
off.
ICFORECAST - Primary file maintained by program.
Referenced Files
ICCOMPANY - Used to validate the existence of a company number.
ICLOCATION - Used to validate the existence of a location.
ITEMLOC - Used to validate the existence of an item at a location.
ITEMMAST - Used to validate the existence of an item.
|
