16 Apr we are analyzing operations of a restaurant with 20 workers. This restaurant serves different dishes (A, B, and C) and use different sta
we are analyzing operations of a restaurant with 20 workers. This restaurant serves different dishes (A, B, and C) and use different stations (R1-R6) for cooking. The restaurant is open for 10 hours a day. And, the daily demand is 540 units of A, 576 units of B, and 696 units of C. Besides, the current operations have the following settings:
Sheet1
| 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) |
