Inventory Cost KPI

Financial & Inventory KPI

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