answer a,b,c,d,e

PLEASE USE EXCEL

Show all work

Agent Smith, operations manager at the Matrix franchise, faces assembly line balancing problems. He has been told that the firm needs to assemble 1200 agents per day. There are 420 minutes of productive time in each working day. The assembly line activities are given below: a) Determine the maximum and minimum cycle times. b) Determine the required cycle time to produce 1200 agents per day. c) What is the minimum number of stations needed? d) Draw a precedence diagram. Use the cells in Excel to enter the durations and add arrows to indicate the precedence relationships. e) Assign tasks to stations in order of most following tasks first, if there is a tie, use the task with the longest processing time first. f) Determine the average utilization and the percentage idle time of the assembly line