Philip Barton and Associates

View Custom Documentation: About Demand Pull Module


Modifications to Baseline - None                                                                                             GRAPHIC EXAMPLES

 

(ZDP-00) DEMAND PULL SUB-MODULE FOR Z_CPSHM

This memo describes the ZDP-00 Module, which is designed to enable a company to utilize Custom Sales History from the Z_CPSHM Module, to load a Forecast, manipulate that Forecast as desired, and pass that directly to the DataFlo SALES-FORECAST file in a separate Business Plan account. This will enable the MPS and MRP to operate in that new account, based on prior sales history, subject to additional user modifications, in terms of percentage changes from the prior periods.

The Forecasting information, as stored and modified within the Z_CPSHM_BUDGET file, is fully integrated with the Monthly Sales History within Z_CPSHM, plus Sales Order Backlog data from Z_SO_BACKLOG. This reporting is provided for DIRECT EXCEL OUTPUT, as well as "paper" output.

I recommend the use of a BIZPLAN account, which can be preset to include "static" data, such as the files for CUSTOMER, VENDOR, PARTS, COST-VERSION, and the Sales History from SACUST, or the Z_CPSHM file provided here, which contains up to 5 years' sales history in monthly buckets, and provides an enormously flexible datamart- type approach to Sales History reporting, including Excel reporting.

This Module provides a complete what-if environment for measurement of the next year's business plan, in terms of resources such as WIP capacity, labor, and material dollars, potential supplier contracts, and excess and obsolete inventory measurement based on the MRP generation from the next year’s Forecast.

Provision is also made for a second BIZPLAY account, which can serve as a "play area", while "freezing" the BIZPLAN data.

The "LIVE", or "production" account, is NOT affected, in terms of changes to data.

 

Utilize the data from the BIZPLAN account, in order to:

Reduce Obsolete and Slow-Moving Inventory

Analyze Labor Hours, Overhead and Dollars by Month

Analyze Work Center Hours and Dollars by Month

Outside Processing Requirements at Standard Cost

Analyze Outside Processing Expenditures

Analyze Proposed Purchasing by Vendor and Product Line.

Commodity and Buyer Codes can also be used.

It would be possible to project Available Inventory in several ways, and utilize that.