please answer 23-26 in excel with steps and explanation. once correct and fully complete I will rate with thumbs up. thanks!

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. 5 units are waiting for Step A and it takes 6 minutes to do Step A. On average 2 units are waiting for Step B and it takes 2 minutes to do Step B On average 1 units are waiting for Step C and it takes 1 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. On average 24 What is the total number of flow units in this process? I= 25 What is the average flow time of a job exiting this system? Taverage 26 What is the average flow time of a job exiting after doing step E? Taverage 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. 5 units are waiting for Step A and it takes 6 minutes to do Step A. On average 2 units are waiting for Step B and it takes 2 minutes to do Step B On average 1 units are waiting for Step C and it takes 1 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. On average 24 What is the total number of flow units in this process? I= 25 What is the average flow time of a job exiting this system? Taverage 26 What is the average flow time of a job exiting after doing step E? Taverage