Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Would you mind give me a little bit details on which information you need? For more intuition, just imagine that we are analyzing operations of
Would you mind give me a little bit details on which information you need?
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: (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. (f) Discussion with details on the wastes that you see in the earlier U-profile. 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: (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. (f) Discussion with details on the wastes that you see in the earlier U-profile
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started