Question: ART 3: PROCESS ANALYSIS This is a practice with complex process analysis where there are both multiple resources and multiple flow unit types. You would

ART 3: PROCESS ANALYSIS 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 three different dishes (A, B, and C) and use different stations (R1-R6) for preparing and cooking food. 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: 4 Station/Resource R1 R2 R3 R4 R5 R6 Number of workers 5.000 5.000 4.000 2.000 2.000 2.000 Processing time for A (minutes/unit/worker) 1.5 3.0 2.5 2.0 0.0 1.0 Processing time for B (minutes/unit/worker) 1.5 2.5 1.5 0.5 0.0 1.0 Processing time for C (minutes/unit/worker) 2.5 1.0 0.0 0.0 3.0 1.0 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 by functions): Block 1 - Labor and technology settings (the above table) Block 2 - Resource capacities in minutes of work

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!