This is a practice with complex process analysis where there are both multiple resources and multiple flow unit types. You would need to construct an Extended Table like in HW1-Q24. Hypothetically, 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,621 units of B, and 459 units of C. Besides, the current operations have the following settings: 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: (a) A copy of The Extended Table that shows numerical results with one extra cell for the DAR. (b) Another copy of the Extended Table that shows how cells are linked together. To have this: copy to have another Extended Table; highlight the area that you want to show formulas; then, go to the Formulas tab at the top panel and click on the Show Formulas button. (c) A profile (column chart) of the original implied utilizations and a brief discussion on it. (d) A profile of the effective implied utilizations and a profile of the utilizations. Explain why these two profiles look the same. Explain why there is one utilization column of exactly 100%. (e) A brief statement of how efficient the process currently is based on the U-profile. This is a practice with complex process analysis where there are both multiple resources and multiple flow unit types. You would need to construct an Extended Table like in HW1-Q24. Hypothetically, 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,621 units of B, and 459 units of C. Besides, the current operations have the following settings: 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: (a) A copy of The Extended Table that shows numerical results with one extra cell for the DAR. (b) Another copy of the Extended Table that shows how cells are linked together. To have this: copy to have another Extended Table; highlight the area that you want to show formulas; then, go to the Formulas tab at the top panel and click on the Show Formulas button. (c) A profile (column chart) of the original implied utilizations and a brief discussion on it. (d) A profile of the effective implied utilizations and a profile of the utilizations. Explain why these two profiles look the same. Explain why there is one utilization column of exactly 100%. (e) A brief statement of how efficient the process currently is based on the U-profile