Calculated measures and KPIs

This table shows the measures that are calculated in the cube:

Measure Description
Avg Order Qty Order quantity divided by the number of finished manufacturing orders
Avg Setup Hrs per MO Total setup hours of the work center divided by the number of finished manufacturing orders
Efficiency % Ratio between planned and actual hours multiplied by the ratio between manufactured and ordered quantity
Maint vs Total Down Time % Actual maintenance hours divided by the sum of maintenance and disturbance hours
Mfd vs Order Qty Var % The difference between manufactured quantity and ordered quantity divided by the ordered quantity
Stop Time vs Maint Hrs % Stop time reported divided by the maintenance hours
Utilization % Total actual time of work center divided by the total capacity in hours
Work Ctr Throughput per Hour Manufactured quantity divided by the work center's run time