8 4 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 Number of workers 7 4 6 Capacity (units/hour) Input = 45 units/hour & demand = 50 units/hour Input (units/hour) Demand (units/hour) Flow rate (units/hour) Utilization (%, 2 decimals) Implied utilization (%, 2 decimals) Input = 52 units/hour & demand = 36 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 = 45 units/hour and demand = 50 units/hour. (d)[1] Determine what-constrained the process is. Find the flow rate. (e)[1] Find utilizations (U) for the resources and process. Draw and interpret the U profile. (f)[1] Find implied utilizations for the resources and process. Draw and interpret the IU profile. For parts (g)-(i), assume input = 52 units/hour and demand = 36 units/hour. (g)[1] Determine what-constrained the process is. Find the flow rate. (h)[1] Find utilizations (U) for the resources and process. Draw and interpret the U profile. (i)[1] Find implied utilizations for the resources and process. Draw and interpret the IU profile. (1)[1] Use the table structure to implement parts (a)-(b) & (d)-(i) in Excel (link cells by functions). Copy the table and 4 profile charts into your answer file (there is no need to show equations)