please answer 1-7 in excel

The process of a firm is as follows. Flow units enter at the rate of 6 units per minute. All units wait in line for Step A and then do Step A. Then 100% go to wait in line for step B. When flow units finish Step B, 60% go to Step C, about 25% go to Step D and the rest go to Step E After Step C, 25% of the flow units exit. The remaining 75% go to Step D. On average 80% of the flow units that go to Step E exit when finishing Step E. The remainder go to Step D. All flow units leaving step D exit. and exit after Step D. So there are 3 flows into Step D (Step A, Step C, Step E) On average 2 units are waiting for Step A and it takes 3 minutes to do Step A On average 1 units are waiting for Step B and it takes 10 minutes to do Step B On average 3 units are waiting for Step Cand it takes 3 minutes to do Step C On average 1 units are waiting for Step Dand it takes 6 minutes to do Step D On average 1 units are waiting for Step E and it takes 1.5 minutes to do Step E Create a process flow diagram of the above scenario in the space below. Be sure to label cach Activity (A, B etc) Be sure to include the buffers separate from the activity. 1 2 What is the total number of flow units in the system? 3 What is the average flow time of flow units exiting after Step E?? 4 What is the average flow time of ALL flow units through the system? 5 What is the theoretical flow time on the A->B->C-> Exit path? 6 What is the flow efficiency for the A->B->C-> Exit path? 7 What is the flow efficiency of path A->B->D->Exit