50.1K

Verified Solution

Link Copied!

1) Modify the employee scheduling model so that 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. (You can assume that each employee works eight hours per day.) PROTECTED VIEW Be carefules from the Internet can contain viruses. Unless you need to edit's safe to stay in Protected View 1 Worker scheduling model 3 Decision variables: number of employees starting their five day shift on various days 4 Mon 5 Tue 6 Wed Thu 9 Sat 10 Sun 12 Result of decisions number of employees working on various days (along top) who started their shift on various days alongside) Tue Wed Thu Fri 14 Mon 15 Tue 16 Wed 7 Thu 18 Fri 20 Sun 22 Constraint on worker availabilities 23 Employees available 25 Employees required 17 1 15 1914 16 11 27 Objective to maximize 28 Total employees Model Ready E O Type here to search Problem 1 (Workers Scheduling file) Page 327 Develop an appropriate objective function that corresponds to the weekly payroll Minimize the objective function with Solver to obtain the optimal number of workers. Is the previous optimal solution still optimal? Compare your solution of this problem with the solution provided in the example in the textbook which was 23 employees.) Figure 14.5 Modified Employee Scheduling Model 1 Employee scheduling model Decision variables: number of employees starting their five day shift on various day Range names used Employees available Employees required Employees Starting Total employees Modell$$23 SH$23 Modell$B$25 SH$25 Modell$854 $0$10 Modell$8528 12 Employees required forginal values 1 7 12 Extra required each day EREDE 14 Result of decisions number of employees working on various days (along top) who started their shift on various days (along side) Fri Sat Sun 35 Mon - --- 1 Wed Note how the original model has been modified so that the extra value in cell K12 drives all of the requirements in row 27 20 EENITTOBRE - - NOTA 24 Constraint on employee availabilities 25 Employees available 1713 16 1915 17 27 Employees required 13 Cengage Learning 15 29 Objective to maximize 30 Total employees 1) Modify the employee scheduling model so that 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. (You can assume that each employee works eight hours per day.) PROTECTED VIEW Be carefules from the Internet can contain viruses. Unless you need to edit's safe to stay in Protected View 1 Worker scheduling model 3 Decision variables: number of employees starting their five day shift on various days 4 Mon 5 Tue 6 Wed Thu 9 Sat 10 Sun 12 Result of decisions number of employees working on various days (along top) who started their shift on various days alongside) Tue Wed Thu Fri 14 Mon 15 Tue 16 Wed 7 Thu 18 Fri 20 Sun 22 Constraint on worker availabilities 23 Employees available 25 Employees required 17 1 15 1914 16 11 27 Objective to maximize 28 Total employees Model Ready E O Type here to search Problem 1 (Workers Scheduling file) Page 327 Develop an appropriate objective function that corresponds to the weekly payroll Minimize the objective function with Solver to obtain the optimal number of workers. Is the previous optimal solution still optimal? Compare your solution of this problem with the solution provided in the example in the textbook which was 23 employees.) Figure 14.5 Modified Employee Scheduling Model 1 Employee scheduling model Decision variables: number of employees starting their five day shift on various day Range names used Employees available Employees required Employees Starting Total employees Modell$$23 SH$23 Modell$B$25 SH$25 Modell$854 $0$10 Modell$8528 12 Employees required forginal values 1 7 12 Extra required each day EREDE 14 Result of decisions number of employees working on various days (along top) who started their shift on various days (along side) Fri Sat Sun 35 Mon - --- 1 Wed Note how the original model has been modified so that the extra value in cell K12 drives all of the requirements in row 27 20 EENITTOBRE - - NOTA 24 Constraint on employee availabilities 25 Employees available 1713 16 1915 17 27 Employees required 13 Cengage Learning 15 29 Objective to maximize 30 Total employees

Answer & Explanation Solved by verified expert

See Answer