Documentation >
MAC-PAC Reference Library >
Manufacturing >
Forecasting Interface >
Key Concepts and Procedures >
Monthly Download >
Considerations
Considerations
Forecasting Date
Demand history information is retrieved for the month immediately previous to the forecasting date entered on by the user. The forecasting date is the period into which customer orders are currently being placed (that is, the period for which the demand history is not known). Normally, this is the current date.
Selective Download
Monthly Download File records can be created selectively for:
· Warehouse (only parts belonging to a certain company and warehouse)
· Part (a selected individual part)
· Planner (all parts belonging to a certain company and planner)
· All parts for the company (when no selection is made)
Also, a combination of these selections can be used (for example, all parts belonging to a certain planner for a certain warehouse).
Part/Warehouse Combination
The Monthly Download File record is created for each part within each warehouse. Therefore, the key used in this file is part number/warehouse number combination.
Please note that company number is not used as a key in the record. This means that the data belonging to different companies should be downloaded to different PCs or to different directories on the same PC (please refer to PC DOS user manuals for how to use directories). Each PC (or each directory of one PC) should contain the forecasting application programs and the database pertaining to one company.
If warehouse numbers are unique among companies, a single copy of the forecasting application programs and data base can be used.
Master Scheduled and Service Parts Planning
Monthly Download File records are created for standard master scheduled, daily master scheduled, and service parts only (demand type = M, D, or S).
Demand History Calculation
The demand is calculated for each item within each warehouse. (Note that bundled items are not included: the demand for each item in the bundle is accumulated for that item.) Demand from sales orders, blanket orders, cash sales, and postbilling transactions for an item are summed to determine the total demand for that item. The figure below details how the system determines the demand quantity and demand date for various types of transactions.
The demand is only included in the totals if the demand date occurred in the past month. In all cases, the sourcing warehouse for the transaction is used to accumulate the demand quantities by warehouse. If parts were ordered or shipped in selling units, the demand quantity is converted to the part's stockkeeping unit of measure (which is defined on the Part Master File).
|
|
|
Sales orders and blanket order releases that have been fully shipped
|
Shipped quantity
|
Requested date
|
Sales orders and blanket order releases that have not been shipped (line status = open or released)
|
Requested quantity
|
Requested date
|
Sales orders that have been partially shipped
|
Shipped quantity from any related backorders
Plus
Unshipped quantity for line
|
Requested date
|
Cash Sales
|
Shipped quantity
|
Shipment date
|
Postbilling Transactions
|
Shipped quantity
|
Shipment date
|
How Demand Quantities and Dates Are Determined.