PLEASE SHOW ALL WORK STEP BY STEP. SHOW FORMULAS CLEARLY.

Problem 2 Modify the employee scheduling model in Chapter 4 so that each worker works 10 hours a day in four consecutive days and then rest for three days in any 7-day cycle. Employees are paid $10 per hour on weekdays and $15 per hour on weekends. Change the objective so that you now minimize the weekly payroll. a) Modify the model formulation accordingly in Excel. b) Use Solver to determine the new optimal scheduling strategy. c) Is the previous solution in the chapter 4 slides still optimal? A small business requires different numbers of fulltime employees on different days of the week. The number of full-time employees required each day is given in the table below. Minimum Number of Employees Day of Week Required Mon 17 Tue 13 Wed 15 Thu 19 Fri 14 Sat 16 Sun 11