| Station/ Resource | R1 | R2 | R3 | R4 | R5 | R6 |
| Number of workers | 5 | 3 | 3 | 2 | 3 | 4 |
| Processing time for A (minutes/unit/worker | 2.5 | 2 | 1.5 | 0 | 1 | 0 |
| Processing time for B(minutes/unit/worker | 0.5 | 1 | 2 | 1.5 | 0 | 1.5 |
| Processing time for C (minutes/unit/worker | 2 | 1.5 | 0 | 0 | 2.5 | 1 |
| Capacity |
| Capacity (minutes/hour) |
| Capacity (minutes/day) (10 hours/day) |
| Demand, Workload, & Implied Utilization |
| Demand for A (units/day) |
| Demand for B (units/day) |
| Demand for C (units/day) |
| Workload on A (minutes/day) |
| Workload on B (minutes/day) |
| Workload on C (minutes/day) |
| Total workload (minutes/day) |
| Implied utilization (%, 2 decimals) |
| Flow Rate & Utilization | | | | | | | DAR= |
| Flow Rate of A (units/day) |
| Flow Rate of B (units/day) |
| Flow Rate of C (units/day) |
| Effective workload on A (minutes/day) |
| Effective workload on B (minutes/day) |
| Effective workload on C (minutes/day) |
| Total effective workload (minutes/day) |
| Effective IU (%, 2 decimals) |
| Utilization (%, 2 decimals) |
Zoesss 
book1.xlsx
