please help with excel

263 6.9.6 SOLVING THE MODEL Figure 6.14 shows the Solver parameters required to solve this problem. The optimal solution is shown in Figure 6.15. FIGURE 6.14 Solor settings and option for the Air-Express scheduling Selver Senings: Objective: J12 Mini Variable colls: 15111 Constraints B12H12 >=313H13 15:111 integer 15:111 >=0 Selver Options: Standard LP/Quadratic Engine Simples LP Integer Tolerance FIGURE 6:15 Optimal solution to the Air-Express employee schelling problem Share B Solver Options and Model Contrato con Shift 1 2 3 4 9 10 $ 11 7 12 Available 13 Required 14 15 Air-Express Days On 1. Days On Worlar Wages per Sun Mon Tue Wed Thu Fri Sat Scheduled Worker 0 0 1 1 1 1 + S680 1 0 1 1 1 1 . 5705 1 1 0 1 1 1 7 5705 1 1 0 0 1 1 1 1 1 1 0 1 $705 1 1 1 1 1 0 0 5 5680 0 1 1 1 1 1 0 3655 27 26 27 19 Total 522540 27 22 25 20 10 3019 17 18 19 20 21 Model Dance Schilling 6.9.7 ANALYZING THE SOLUTION The solution shown in Figure 6.15 ensures that the available number of employees is at least as great as the required number of employees for each day. The minimum total wage expense associated with this solution is $22,540. There are alternate optimal solutions to this problem.) 253 An EmployScheduling Problem 6.9.6 SOLVING THE MODEL Figure 6.14 shows the Solver parameters required to solve this problem. The optimal solution is shown in Figure 6.15. FIGURE 6.14 Selver settings and prints for the Air Express sching problem Solver Settings Objective: J12 (Min) Variable calls: 15.111 Constraints: 312.12 > 813 H13 15.111 - integer 5:11 > 0 Solver Options: Standard LP/Quadratic Engine Simplex LP) Integer Tolerance - 0 FIGURE 6:15 Optimal solution to the Air-Express employee scheduling problem SRS Solver Options and Model B Hurmat Femme A A B F G 1 2 Air-Express 3 Days On-1, Days Off- Workers Wages per Shift Sun Mon Tue Wed Thur Fri Sat Scheduled Worker 5 1 0 0 1 1 1 1 1 $680 2 1 0 0 1 1 1 1 0 5705 2 3 1 1 0 0 1 1 1 7 $705 4 1 1 1 0 0 1 1 $705 9 5 1 1 1 1 0 1 5 $705 10 6 1 + 1 1 1 0 $680 11 7 1 1 1 1 1 O 9 $655 12 Available 1822 25 20 27 19 Total 522540 13 Required 18 27 22 26 25 21 19 14 15 16 17 18 19 20 21 Scheduling Report 09 hede 6.9.7 ANALYZING THE SOLUTION The tion shown in Figure 6.15 ensures that the available number of employees is at least as great as the required number of employees for each day. The minimum total wage expense associated with this solution is $22,540. (There are alternate optimal solutions to thus problem)