Inventory KPIs

Consolidation of Inventory KPIs

  • WIP Inventory Cost KPI
  • Inventory Cost KPI
  • Raw Material Inventory Cost KPI
  • (T/I) Investment Turns KPI

 

WIP Inventory Cost KPI

Sum of On-hand Inventory Cost for Items of Type Intermediate or SubAssembly.

Calculation

WIP Inventory Cost = For all Warehouses, for all Inventory in Warehouses, SUM(Inventory.OnHandQty * Item.Cost) if Item.ItemType = Intermediate or Item.ItemType = Subassembly

Significant Data

  • Inventory.OnHandQty
  • Item.Cost
  • Item.ItemType

 

Inventory Cost KPI

Sum of Job Raw Material and On-hand Raw Material, WIP and Finished Goods Inventory costs.

Calculation

Inventory Cost KPI = For all scheduled Jobs, SUM(MaterialRequirement.TotalRequiredQty * Item.Cost) + For all Warehouses, for all Inventory in Warehouses, SUM(Inventory.OnHandQty * Item.Cost) if Item.ItemType = Raw Material + For all Warehouses, for all Inventory in Warehouses, SUM(Inventory.OnHandQty * Item.Cost) if Item.ItemType = Intermediate or Item.ItemType = Subassembly + For all Warehouses, for all Inventory in Warehouses, SUM(Inventory.OnHandQty * Item.Cost) if Item.ItemType = Finished Good

Significant Data

  • MaterialRequirement.TotalRequiredQty
  • Item.Cost
  • Inventory.OnHandQty
  • Item.ItemType
 

Raw Material Inventory Cost KPI

Sum of On-hand Inventory Cost for Items of Type Raw Material.

Calculation

Raw Material Inventory Cost = For all Warehouses, for all Inventory in Warehouses, SUM(Inventory.OnHandQty * Item.Cost) if Item.ItemType = Raw Material

Significant Data

  • Inventory.OnHandQty
  • Item.Cost
  • Item.ItemType

 

(T/I) Investment Turns KPI

Throughput divided Investment.

Calculation

(T/I) Investment Turns KPI = (T) Throughput / (I) Investment

Significant Data

  • (T) Throughput
  • (I) Investment