Q2 (10 marks). An electronics assembly facility operates 24-hours a day, 7 days a week. Shifts are 8 hours long and can start at 3:00 am/pm, 7:00 am/pm, and 11:00 am/pm. Below are the shift requirements for the employees. Employees Requirement 8 27 Shift Start 3:00 am 7:00 am 11:00am 3:00pm 7:00 pm 11:00pm 12 23 29 23 a) Assuming all employees get paid the same hourly wage, what is the minimum number of employees scheduled that will satisfy the facility requirements? Use a spreadsheet solver to obtain your answer. b) Now assume that a new union agreement has been reached. Employees will now get paid $16/hour during 9:00am-9:00pm and 35% overtime bonus for hours worked outside these hours. Assume the same total number of employees from a) are to be scheduled. What schedule assignment will result in minimizing the cost of employees? Use a separate sheet to provide your