Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Auditing And GRC Automation In SAP

Authors: Maxim Chuprunov

1st Edition

3642353010, 9783642353017

More Books

Students also viewed these Accounting questions

Question

Explain the role of the auditor in the financial reporting process.

Answered: 1 week ago