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