What if the total number of firefighters are limited due to turnover or other challenges in hiring?
Question:
- 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.
TranscribedTextIncome Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill