Documentation >
MAC-PAC Reference Library >
Manufacturing >
Requirements Planning >
Reports >
Projected Inventory Cost Detail
Projected Inventory Cost Detail
RP500B
DATE 7/15/94 ANDERSEN CONSULTING APPLICATIONS, INC PAGE 1
TIME 16:15:52 PICKING & SHIPPING INC PLANT BEL
REPORT RP-500B
PROJECTED INVENTORY COST DETAIL
CURRENT COST IN THOUSANDS
*** SIMULATION SUPPLY/DEMAND ***
ACCOUNTING PERIOD END DAY 30
ACCOUNT NUMBER 02 PURCHASED PART
COMMODITY CODE MKT MARKET DEMAND COMMODITY
PART NUMBER PART DESCRIPTION
JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH APRIL MAY JUNE
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
BICYCLE 10-SPEED BICYCLE
20 62 77 77 77 77 77 77 77 77 77 77
TOTAL ORD
31 62 77 77 77 77 77 77 77 77 77 77
TOTAL REQ
11 0 0 0 0 0 0 0 0 0 0 0
COMMODITY CODE TOTAL MKT MARKET DEMAND COMMODITY
20 62 77 77 77 77 77 77 77 77 77 77
TOTAL ORD
31 62 77 77 77 77 77 77 77 77 77 77
TOTAL REQ
11 0 0 0 0 0 0 0 0 0 0 0
ACCOUNT NUMBER TOTAL 02 PURCHASED PART
20 62 77 77 77 77 77 77 77 77 77 77
TOTAL ORD
31 62 77 77 77 77 77 77 77 77 77 77
TOTAL REQ
11 0 0 0 0 0 0 0 0 0 0 0
** END OF REPORT **
|
Purpose
The Projected Inventory Cost Detail Report measures inventory performance for parts on the Part Master File (DE100M). The projected inventory balances for each part over a twelve-month period are determined (the beginning balance is adjusted by time-phasing all requirements and orders for the part). The resulting monthly inventory balances are then converted to dollar amounts based on the specified cost type. Depending on the specified parameter, the report prints the detail information for all parts, or only those parts with a specified commodity or accounting code. The report can be generated to reflect either simulated inventory costs or actual inventory costs, based upon either actual supply and demand or simulated supply and demand.
Costs are rounded to the nearest thousand. However, line totals are summed prior to rounding of detail lines. Due to this, rounded cost figures may not add up to the total cost figure. Parts with no inventory costs are not printed.
Depending on the specified parameter, one of the following headings will appear on the report:
¾ "Simulated Cost in Thousands"
¾ "Standard Cost in Thousands"
¾ "Current Cost in Thousands"
The heading "Simulation Trial ID" appears on the report only when a simulated cost report is printed. Also, a heading of "***Simulation Supply/Demand***" appears when you base projected inventory on simulated supply and demand.
Report Sequence
Accounting Code, Commodity Code, Part Number.