QUESTION 23 (10 points) - Process Analysis with One Flow-Unit Type A business process with one flow unit type has four resources as in the table below. You do not need to fill in the shaded cells. Make sure to show equations and calculation steps. Resource & Process 1 2 3 4 Process Processing time (minutes/unit/worker) 10 5 6 8 Number of workers 7 4 A 6 Capacity (units/hour) Input = 42 units/hour & demand = 45 units/hour Input (units/hour) Demand (units/hour) Flow rate (units/hour) Utilization (%, 2 decimals) Implied utilization (%, 2 decimals) Input = 47 units/hour & demand = 38 units/hour Input (units/hour) Demand (units/hour) Flow rate (units/hour) Utilization (%, 2 decimals) Implied utilization (%, 2 decimals) (a) [1] What is the bottleneck? (shows steps) (b)[1] What is the process capacity? (explain) (c)[1] Sketch the process with four consecutive resources and their capacities. Describe it. For parts (d)-(f), assume input = 42 units/hour and demand = 45 units/hour. (d)[1] Determine what-constrained the process is. Find the flow rate. (e) [1] Find utilizations for the resources and process. Draw the U profile, and interpret. (f)[1] Find implied utilizations for the resources and process. Draw the IU profile, and interpret. For parts (g)-(i), assume input = 47 units/hour and demand = 38 units/hour. (g)[1] Determine what-constrained the process is. Find the flow rate. (h)[1] Find utilizations for the resources and process. Draw the U profile, and interpret. (i)[1] Find implied utilizations for the resources and process. Draw the IU profile, and interpret. (j)[1] Use the table structure to implement parts (a)-(b) & (d)-(i) in Excel (link cells by functions). Give printouts of the table and 4 profile charts (there is no need to show equations).Resource & Process 1 N 4 Process Processing time (minutes/unit/work 10 8 Number of workers 7 4 6 Capacity (units/hour) 42 48 40 45 40 Input (units/hour) 42 Demand (units/hour) 45 45 45 45 45 Flow rate (units/hour) 40 40 40 40 40 Utilization (%, 2 decimals) 0.9523809524 0.8333333333 1 0.8888888889 Implied utilization (%, 2 decimals) 1.071428571 0.9375 1.125 1.125 Input = 47 units/hour & demand = 38 units/hour Input (units/hour) 47 Demand (units/hour) 38 38 38 38 38 Flow rate (units/hour) 38 38 38 38 38 Utilization (%, 2 decimals) 0.9047619048 0.7916666667 0.95 0.8444444444 0.95 Implied utilization (%, 2 decimals) 0.9047619048 0.7916666667 0.95 0.8444444444 0.95