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) 5.0 1.5 4.8 3.0 V77 Number of workers 3 1 3 2 Capacity (units/hour) Input = 40 units/hour & demand = 42 units/hour 1 Input (units/hour) Demand (units/hour) Flow rate (units/hour) Utilization (%, 2 decimals) Implied utilization (%, 2 decimals) Input = 45 units/hour & demand = 32 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 = 40 units/hour and demand = 42 units/hour. (d)[1] Determine what-constrained the process 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 = 45 units/hour and demand = 32 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. 0[1] Find implied utilizations for the resources and process. Draw the IU profile, and interpret. 6)[1] Use the table structure to implement parts (a)-(b) & (d)-(i) in Excel (link cells by functions)