1. What if the total number of firefighters are limited due to turnover or other challenges in hiring? Starting from the benchmark solution, limit the total number of firefighters by 1, 2, 3, ..., 10. To enable finding a feasible answer that covers the requirements, allow some firefighters to work "double" shifts (day and night). Double shift employees would be compensated by "time and a half" for their work on all hours over 48 hours per week. Report the implications in terms of cost.

Note 1: If the benchmark solution had 22 firefighters in total (not the actual answer), then, the goal here would be to find the best schedule with 21 firefighters, with some overtime involved. Then repeat for 20, 19, etc.

Note 2: To include shifts that allow for overtime, you may need to make some assumptions about how much overtime is permitted for a firefighter per week. How safe is it if firefighters are working too much?

Note 3: Overtime hours include 1.5 times the regular pay and benefits.

I need help with this portion. I have uploaded my benchmark solution and what I have so far for this question. I need help figuring out this portion in Excel. What I know so far is my total day employees is 26 and night is 35. I'm assuming that 10 hours is safe for overtime hours permitted. Im at a lost for what to do for this part. I had gotten help from another tutor however I still unsure of how to do the day shift and night shift portion. I don't even know if I set this up correctly. Im new to excel so I don't have a lot of knowledge and trying to figure this out with detailed steps and what formulas to plug in would be helpful. I also don't understand how I would the pay for both day and night time shifts since the pay for day is 30 per hour and night is 35 per hour how would the total cost work? How do I adjust the shift schedules to meet the staffing requirements? The day has 26 employees and night is 35 but I'm confused for the benchmark in my cell E2 I have a total of 61 what exactly would I put for F2:F11 same for G2:G11. Please help me understand and figure this out. Im more of a visual learn so if you can use an excel table like I have in the second picture explaining the steps in how to fill out my missing blanks on my excel. Im not good at understanding if its just a bunch of sentences without examples.

TranscribedText

Day Shift Day Schedule Requirements Pay $30/hour Mon Tues Wed Thurs Fri Sat Sun Salary w/out benefits $1,440 5 am-5 pm 11 11 12 18 19 18 14 Benefits Salary w/ benefits $432 $1,872 Night Shift Night Schedule Requirements Pay $35/hour Mon Tues Wed Thurs Fri Sat Sun Salary w/out benefits $1,680 5 pm-5 am 16 17 17 21 22 24 20 Benefits $504 Salary w/ benefits $2,184 Day Shift Mon Tues Wed Thurs Fri Sat Sun Employee Working 11 11 13 18 19 18 14 >= >= x= > Employee Requirements 11 11 12 18 19 18 14 #Employees Start Working 3 4 5 6 4 3 1 Total # of Day Employees Total Day Cost 26 $48,672 Night Shift Mon Tues Wed Thurs Fri Sat Sun Employee Working 17 18 18 21 22 24 20 > >= x= > >= >= >= Employee Requirements 16 17 17 21 22 24 20 #Employees Start Working 3 5 7 6 4 7 3 Total # of Night Employees Total Night Cost 35 $76,440 Overall # of Employees 61 Overall Total Cost $125,112