MAC-PAC Homecontact ussupport login 
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).

 

Type of Transaction

Demand Quantity

Demand Date

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.