Home / Questions / 263 6.9.6 SOLVING THE MODEL Figure 6.14 shows the Solver parameters required to solve this...
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)
Apr 13 2021 View more View Less
Briefly explain why annuities are a type of tax-sheltered investment. Do you have to give up anything to obtain this tax-favored treatment? >
May 16 2020Researchers often investigate __________, a measure of the degree to which a characteristic is related to genetic factors.
Nov 26 2019Comprehensive Problem 1 (The following information applies to the questions displayed below] On December 1, Year 1, John and Patty Driver formed a corporation called S...
Apr 07 2020Identify and describe the five most important ratios for a potential bank investment in a short-term corporate loan. Explain the reasoning for your selection. Illustrate ...
Aug 19 2020why actual overhead costs aren't traced to jobs just as direct materials and direct labor cost are traced to jobs?
Apr 13 2020Which of the following apply to oligopoly industries? Select one or more answers from the choices shown.a. A few large producers.b. Many small producers.c. Strategic beh...
Dec 05 2019Harrigan Enterprises utilizes Snoopy Systems to design and implement a cash management system. Due to Harrigan’s cash management problems, it cannot currently pay for the...
Sep 18 2020Addai Company has provided the following comparative information: You have been asked to evaluate the historical performance of the company over the last five years. Sele...
May 09 2021Which statement best illustrates the law of diminishing returns?A. The average total costof the last unit of a resource used is less than the average total cost of the pr...
Apr 20 2018The following selected accounts appear in the ledger of Parks Construction Inc. at the beginning of the current year: Preferred 2% Stock, $75 par (100,000 shares authoriz...
Apr 11 2020