Question: please answer 23-26 in excel with explanation SCENARIO: The process of a firm is as follows. Flow units enter at the rate of 12 units

please answer 23-26 in excel with explanation

please answer 23-26 in excel with explanation SCENARIO: The process of a

SCENARIO: The process of a firm is as follows. Flow units enter at the rate of 12 units per minute. All units wait in line for Step A and then do Step A. Then about 55% go to wait in line for step B. When flow units finish Step B, 65% exit. The remaining 35% go to Step C. About 20% of the units leaving Step A go to Step C. So, Step C has two flows into it (from B and from A) The remaining units leaving step A go to Step D. After Step C, 65% of the flow units that went through Step C exit. The rest go to Step D. All flow units going to Step D go to Step E. So there are 2 flows into Step D (Step A, Step C) 100% of units going to Step E exit after Step E. On average 5 units are waiting for Step A and it takes minutes to do Step A. On average units are waiting for Step B and it takes -NO minutes to do Step B - N On average units are waiting for Step C and it takes minutes to do Step C On average 2 units are waiting for Step D and it takes 3 minutes to do Step D On average 0.5 units are waiting for Step E and it takes 5 minutes to do Step E 23 Create a process flow diagram of the above scenario in the space below. Be sure to label each Activity (A, B etc) Be sure to show I, R and T for each activity. 24 What is the total number of flow units in this process? 25 What is the average flow time of a job exiting this system? T average 26 What is the average flow time of a job exiting after doing step E? T average

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!