Question: 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

Q2 (10 marks). An electronics assembly facility

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!