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 |