A scheduler has to assign workforce to a specific task for the next week. The task requires the following staffing levels for each day of the week: 14, 12, 14, 18, 20, 8, 4. The scheduler can assign both full-time workers and part-time workers to the task. Full-time workers work 5 consecutive days a week and earn $1,000 a week. Part-time workers work 3 consecutive days a week and earn $500 a week. Part-time workers cannot be more than 10.
A) Create a spreadsheet with the 14 possible work shifts, find the total cost and minimize it with Solver while satisfying all the constraints.
B) Saturday and Sunday are paid $50 extra each per worker (full-time and part-time). Find the new optimal solution for this case.