OPTION (27) Modifications to Baseline - Minimal GRAPHIC EXAMPLE
(MSO-Z3-00) INVOICE DOLLARS AND PROFIT BY MONTH/PERIOD
This memorandum details the functionality of the Custom
Z_CPSHM File Structure, indicating the data stored, and
the wide variety of reports which can be tailored for
individual customer requirements.
Z_CPSHM File ID = Sell-To Customer * Part Number * Ship
-From Inventory * DI/CI * RMA Type
Field 1 = Sell-To Customer Number on the AR-INVOICE
Field 2 = Part Number from ARLI Line Item
Field 3 = Ship-From Inventory Code on the ARLI
Field 4 = DI for Debit (Sale) or CI for Credit
Field 5 = RMA TYPE, if AR-INVOICE due to RMA ACTIVITY
per AR-INVOICE(76)
The Z_CPSHM file contains Sixty Months of Data for
Invoice Dollars, Cost of Goods Sold, and Quantity
Shipped. Gross Profit = Invoice Dollars less Cost of
Goods Sold. Cost elements (Material, Labor, Overhead,
and Outside Processing) are stored individually.
Specialized reports can be readily prepared, such as:
For the period April through October, report sales of
a specific Part Product Code, or Customer Region, in
descending dollars by Code (or Region), by Customer
Name.
Numerous translation attributes, for Part and Customer,
have been provided in the dictionary, which the customer
may want to utilize in additional reports.
An additional file, Z_SO_BACKLOG, is included, so that
information on Open Sales Orders can be included.
File Z_CPSHM_BUDGET allows entry of Forecasts by
Fiscal Month for the current, and 12 future months,
for the following, simultaneously:
Customer Number * Part Number.
Customer Number
Part Number
Additional fields for Materials, Labor, Overhead, and
Outside Process Cost Elements are activated with the
purchase of Custom Module MLO-00.
A large variety of Dictionary Items have been provided,
to allow the customer to create different reports, as
required. Examples of some provided items:
FYTD2000D = Fiscal Year 2000 Total Dollars
FYTD2001Q = Fiscal Year 2001 Total Quantity
FYTD2001P = Fiscal Year 2001 Total Gross Profit
LAST12D = Last 12 Months' Total Dollars
LAST6AVG = Average Monthly Quantity for Last 6 Months
M082000D = Month 08 of Fiscal Year 2000 Dollars
M062001Q = Month 06 of Fiscal Year 2001 Quantity
FY2000Q3D = 3rd Quarter of Fiscal 2000 Dollars
FY2001Q1Q = 1st Quarter of Fiscal 2001 Quantity
M062001C (Cost)
M062001D (Dollars)
M062001L (Labor)
M062001M (Materials)
M062001O (Overhead)
M062001OSP (Outside Processing)
M062001P (Gross Profit)
M062001Q (Quantity)
M062001UP (Unit Price)
The Z_SO_BACKLOG File has information on Open Sales
Orders by Fiscal Month, Quarter, and Year, and can be
rebuilt in the Custom Nightly Process Stream. These are
samples of Dictionary Items supplied which translate to
Backlog data, to allow inclusion on History reports ...
Z_BO_W1Q Week 1 (Current Week) Quantity
Z_BO_W24Q Week 24 (Current Week + 23) Quantity
Z_BO_W1D Week 1 (Current Week) Dollars
Z_BO_W24D Week 24 (Current Week + 23) Dollars
Z_BO_M0Q Past Due Quantity
Z_BO_M1Q Month 1 (Current Month) Quantity
Z_BO_M24Q Month 24 (Current Month + 23) Quantity
Z_BO_M0D Past Due Dollars
Z_BO_M1D Month 1 (Current Month) Dollars
Z_BO_M24D Month 24 (Current Month + 23) Dollars
Z_BO_PASTQ Current Quarter including Past Due Quantity
Z_BO_Q1Q Quarter 1 (Next Quarter) Quantity
Z_BO_Q8Q Quarter 8 (Next Quarter + 7) Quantity
Z_BO_PASTD Current Quarter including Past Due Dollars
Z_BO_Q1D Quarter 1 (Next Quarter) Dollars
Z_BO_Q8D Quarter 8 (Next Quarter + 7) Dollars
Z_BO_Y1Q Year 1 (Current Year) Quantity
Z_BO_Y2Q Year 2 (Current Year + 1) Quantity
Z_BO_Y3Q Year 3 (Current Year + 2) Quantity
Z_BO_Y1D Year 1 (Current Year) Dollars
Z_BO_Y2D Year 2 (Current Year + 1) Dollars
Z_BO_Y3D Year 3 (Current Year + 2) Dollars
The Z_CPSHM_BUDGET File allows entry of Forecasts for
future Fiscal Months, by:
Customer Number * Part Number.
Customer Number
Part Number
There are examples of Z_CPSHM Dictionary Items supplied,
which translate to Z_CPSHM_BUDGET, to allow inclusion
on reports.
Z_BUDGET_M0Q Current Month Forecast Quantity
Z_BUDGET_M2D Month 2 Forecast Dollars
Z_BUDGET_Q0D Current Quarter Forecast Dollars
Z_BUDGET_Q0Q Current Quarter Forecast Quantity
Z_BUDGET_Q1D Quarter 1 (Next Quarter) Forecast Dollars
Z_BUDGET_Q1Q Quarter 1 (Next Quarter) Forecaast Quantity
While several reports are provided on the left side of
the Menu, there are a large variety of reports which
could be built, to customer specifications, in terms of
which months, or periods, should be printed
Data can be gathered and sent directly to Excel, or the
MITS OLAP/Data Warehouse product can be utilized as a
True Data Warehouse. Excel, or a third-part forecast
Tool, can be added for User Entry or calculation of a
Forecast, and the data passed back, via Excel, to Data-
Flo, into the Sales Forecast Module, and utilized by MPS
And MRP.
One interesting approach is to set up a Business Plan
Account, with ability to utilize the Parts and Customer
Files, as well as BOM (Bill of Materials), but to contain
Separate files for SALES-FORECAST, INV, MPS, and MRP,
and to take advantage of a total simulation environment.