Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economics Of The Industrial Revolution Internet, Artificial Intelligence And Blockchain

Authors: Nicholas Johnson, Brendan Markey Towler

1st Edition

042977169X, 9780429771699

More Books

Students also viewed these General Management questions

Question

=+a) Is this an experiment or observational study? Explain.

Answered: 1 week ago

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago