0 Replies Latest reply: Dec 5, 2012 3:34 AM by 978078 RSS

    Planned Inventory Turns KPI


      I am trying to calculate Planned Inventory Turns KPI.

      I got the formula for the same as below.

      [Cost of Total Demand in the Period * (365 / Number of Days in Period)] / Cost of Average Inventory for the Period

      To calculate the Average Inventory, for inventory on hand at the end of the period(running total), i am deriving the Initial On hand and Current Schedule Receipt quantity from MSC_Supplies table and Daily demand quantity from MSC_Demands table. And i am struck in linking the supplies and demands table to calculate the formula as ( Initial On hand + Current Schedule Receipt quantity - Daily demand quantity).

      Any pointers on the same will eb helpful.