Documentation >
MAC-PAC Reference Library >
Manufacturing >
Requirements Planning >
Reports >
Projected Inventory Cost Summary
Projected Inventory Cost Summary
RP500C
DATE 7/15/94 ANDERSEN CONSULTING APPLICATIONS, INC PAGE 1
TIME 16:15:52 PICKING & SHIPPING INC PLANT BEL
REPORT RP-500C
PROJECTED INVENTORY COST SUMMARY
CURRENT COST IN THOUSANDS
*** SIMULATION SUPPLY/DEMAND ***
ACCOUNTING PERIOD END DAY 30
ACCOUNT NUMBER 02 PURCHASED PART
JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH APRIL MAY JUNE
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
MATERIAL
12 37 46 46 46 46 46 46 46 46 46 46
LABOR
8 25 31 31 31 31 31 31 31 31 31 31
OVERHEAD
0 0 0 0 0 0 0 0 0 0 0 0
TOTAL
20 62 77 77 77 77 77 77 77 77 77 77
ACCOUNTING TOTAL
JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH APRIL MAY JUNE
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
MATERIAL
12 37 46 46 46 46 46 46 46 46 46 46
LABOR
8 25 31 31 31 31 31 31 31 31 31 31
OVERHEAD
0 0 0 0 0 0 0 0 0 0 0 0
TOTAL
20 62 77 77 77 77 77 77 77 77 77 77
** END OF REPORT **
|
Purpose
The Projected Inventory Cost Summary Report measures either simulated or actual inventory performance of parts on the Part Master File (DE100M) for a specific plant. 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. The material, labor, and overhead costs are summarized for each account number or commodity code.
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.
Report Sequence
Accounting Code.