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).