Question: Can anyone explain this question? I don't understand. 2) You are giving the following process flow diagram. Use the Excel file, hwl_q1.xlsx, to provide your

Can anyone explain this question? I don't understand. Can anyone explain this question? I don't
Can anyone explain this question? I don't
2) You are giving the following process flow diagram. Use the Excel file, hwl_q1.xlsx, to provide your answers to the following questions. Workstation B Task time 10 min Workstation A Task time = 8 min Workstation D Task time = 12 Workstation Task time = 6 min a) Create a Gantt chart showing the production of first three pieces. For the following parts, perform your calculations in the yellow cells provided in Excel. Whenever possible use an Excel formula to make the calculation rather than simply writing the result. Answers with only the final result will not be accepted. b) What is the fastest that a rush order can go through this process? c) What is the system cycle time? d) In'steady state, what is the 8-hour capacity of this process? e) Assuming one worker is working at each station, calculate the utilization of each worker, as well as, the overall labor utilization. Perform your calculations in the yellow cells. Whenever possible use an Excel formula to make the calculation rather than simply writing the result. Answers with only the final result will not be accepted. a) Prepare the Gantt chart for the first three units produced. Each cell represents 2 minutes. A B C D 2 6 10 14 18 22 26 30 34 38 42 46 50 54 W] HUM 304 -2-- Westment X x . x]

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!