An assembly line currently has five workstations, and the time required for each is shown in the figure below.
Workstation	1	2	3	4	5
Time required (Seconds)	46	35	50	37	32
Required:
Note: Use cell A2 to F5 from the given information to complete this question.
a. What is the efficiency of the current process? Hint: Identify the bottleneck work station.
Note: Use cell A13 to B14 from the given information to complete this question. Round up your answer to the next whole number.
Bottleneck station	50
Number of stations	5
Efficiency
b. Customer demand is 80 units per hour. What is the hourly production rate of the current process?
Note: Use cell A21 to B22 from the given information to complete this question.
Minutes per Hour	60
Seconds per Minute	60
Current hourly production
c. What does the takt time need to be able to meet demand?
Note: Use row 29 from the given information to complete this question.
Demand (units/hour)	80
Takt time needed (seconds/station)