Please answer question 1 (a-g) in excel with cell values.

I will rate!!!

On average Scenario The process of a firm is as follows. Flow units enter at the rate of 6 units per hour. 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, on average 25% go to Step D and the rest go to Step E After Step C 35% of the flow units exit. The remaining 65% go to Step D. 80% of the flow units leaving Step E go to Step F. The remainder go to Step D. All flow units leaving steps D&F exit. and exit after Step D. So there are 3 flows into Step D (Step 4, Step C, Step E) On average 0.5 units are waiting for Step A and it takes 9 minutes to do Step A. On average 0.25 units are waiting for Step B and it takes 7 minutes to do Step B On average 0.6 units are waiting for Step C and it takes 15 minutes to do Step C On average 1.1 units are waiting for Step D and it takes 14 minutes to do Step D On average 1 units are waiting for Step E and it takes 1.5 minutes to do Step E On average 0.1 units are waiting for Step F and it takes 45 minutes to do Step F A 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 include the buffers separate from the activity. B What is the theoretical flow time on the A->B->E->F-> Exit path? Texiting at F= c What is the flow efficiency for the A->B->E->F-> Exit path? Texiting at F D What is the flow efficiency of path A->B->E->F->Exit? E Flow Efficiencyexiting at F What is the takt time for the scenario above? Takt Time= hours = minutes G Briefly explain below what takt time is telling the manager of the process