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