For more intuition, just imagine that we are analyzing operations of a restaurant. 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 600 units of A, 675 units of B, and 525 units of C. Besides, the current operations have the following: Station/Resource R1 R2 R3 R4 R5 R6 Number of workers 4.0 2.0 3.0 2.0 3.0 1.0 Processing time for A (minutes/unit/worker) 2.0 1.5 2.5 3.0 0.0 0.5 Processing time for B (minutes/unit/worker) 1.0 2.0 0.5 1.5 0.0 0.5 Processing time for C (minutes/unit/worker) 2.5 0.0 0.0 0.0 1.5 0.5 Given the assumption of a fixed product mix, you would need to construct the Extended Table in Excel with the following blocks (where cells are linked together) Block 1 - Labor and technology settings (the above table) Block 2 - Resource capacities in minutes of work, per hour and per day Block 3 - Demands in product units, workloads in minutes, and original implied utilizations Intermediate step - A separate cell for the Demand Acceptance Ratio (DAR) Block 4 - Flow rates, effective workloads, effective implied utilizations, and utilizations. In your report of this part, you need to present the following: (g) A brief proposal on how to eliminate the wastes that you find. (Hint: labor configuration) (h) A new Extended Table to show how your proposal in (g) can work. Essentially, you would do some experiment (trials and errors) with the new Extended Table in Excel where: The number of employees stays unchanged throughout your experiment. Assume that you already cross-trained the workers and now easily move them around. The number of employees at one resource can be a decimal number with 3 decimal places. You can manually accept the demand levels to serve as long as they are higher than before. . With a new labor setup, you should achieve all utilizations near and below 100%. (i) Discussion on the new outcome that you get in (h). (Note: there is no single best outcome!) For more intuition, just imagine that we are analyzing operations of a restaurant. 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 600 units of A, 675 units of B, and 525 units of C. Besides, the current operations have the following: Station/Resource R1 R2 R3 R4 R5 R6 Number of workers 4.0 2.0 3.0 2.0 3.0 1.0 Processing time for A (minutes/unit/worker) 2.0 1.5 2.5 3.0 0.0 0.5 Processing time for B (minutes/unit/worker) 1.0 2.0 0.5 1.5 0.0 0.5 Processing time for C (minutes/unit/worker) 2.5 0.0 0.0 0.0 1.5 0.5 Given the assumption of a fixed product mix, you would need to construct the Extended Table in Excel with the following blocks (where cells are linked together) Block 1 - Labor and technology settings (the above table) Block 2 - Resource capacities in minutes of work, per hour and per day Block 3 - Demands in product units, workloads in minutes, and original implied utilizations Intermediate step - A separate cell for the Demand Acceptance Ratio (DAR) Block 4 - Flow rates, effective workloads, effective implied utilizations, and utilizations. In your report of this part, you need to present the following: (g) A brief proposal on how to eliminate the wastes that you find. (Hint: labor configuration) (h) A new Extended Table to show how your proposal in (g) can work. Essentially, you would do some experiment (trials and errors) with the new Extended Table in Excel where: The number of employees stays unchanged throughout your experiment. Assume that you already cross-trained the workers and now easily move them around. The number of employees at one resource can be a decimal number with 3 decimal places. You can manually accept the demand levels to serve as long as they are higher than before. . With a new labor setup, you should achieve all utilizations near and below 100%. (i) Discussion on the new outcome that you get in (h). (Note: there is no single best outcome!)