Investment KPI

Investment KPI Sum of Plant Investments and Inventory Costs. Calculation Investment = 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 = […]

Read More

Inventory Cost 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 […]

Read More

Raw Materials Cost KPI

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

Read More

WIP Inventory Cost 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

Read More

Resource Overtime Cost KPI

Resource Overtime Cost KPI The cost of all active Resources running either overtime or potential overtime shifts. Calculation Resource Overtime Cost = Sum across all Resources, Resource.OvertimeHourlyCost * Sum of all Overtime Interval Lengths on this Resource + Resource.OvertimeHourlyCost * Sum of all Potential Overtime Interval Lengths on this Resource. Significant Data Resource.OvertimeHourlyCost

Read More

Resource Online Cost KPI

Resource Online Cost The cost of all active Resources running either online or cleanout shifts. Calculation Resource Online Cost = Sum across all Resources, Resource.StandardHourlyCost * Sum of all Cleanout Interval Length on this Resource + Resource.StandardHourlyCost * Sum of all Online Interval Length on this Resource. Significant Data Resource.StandardHourlyCost

Read More

Subcontract Cost KPI

Subcontract Cost The cost of all subcontracting done for scheduled Jobs. Calculation Subcontract Cost = Sum for all Activities where Activity.Scheduled = true, (Resource.StandardHourlyCost * CapacityInterval.Duration where CapacityInterval.IntervalType = Online) + (Resource.OvertimeHourlyCost * CapacityInterval.Duration where CapacityInterval.IntervalType = Overtime OR CapacityInterval.IntervalType = Potential Overtime) if Resource.ResourceType = Subcontractor Significant Data Activity.Scheduled Resource.StandardHourlyCost Resource.OvertimeHourlyCost CapacityInterval.Duration CapacityInterval.IntervalType Resource.ResourceType

Read More

Late Jobs Revenue KPI

Late Jobs Revenue The revenue created by Jobs that are late. Calculation Late Jobs Revenue = SUM(Job.Revenue) if Job is late Significant Data Job.Revenue

Read More

Throughput (T) KPI

Throughput (T) KPI Sum of Throughputs for Jobs scheduled to end within the Planning Horizon. Calculation Throughput = SUM( Job.Revenue – Job.Material Cost – Job.Subcontract Cost – Job.Shipping Cost – Job.Expected Late Penalty ) if Job completes before the end of the Planning Horizon Significant Data Job.Revenue Job.Material Cost Job.Subcontract Cost Job.Shipping Cost Job.Expected Late Penalty  

Read More

Throughput per Drum Hour KPI

Throughput per Drum Hour Throughput of Jobs scheduled on at least one Drum Resource divided by the capacity hours used on the Drum Resources. Purpose Jobs that use more Drum Resource capacity per unit of Throughput may be financially less attractive for your business since they are consuming critical resources while contributing less Throughput per […]

Read More