Consider the Union Airways problem presented in Sec- tion 3.3, including the spreadsheet in Figure 3.5 showing its for- mulation and optimal solution. Management is about to begin negotiations on a new contract with the union that represents the company's customer service agents. This might result in some small changes in the daily costs per agent given in Table 3.5 for the various shifts. Several possible changes listed below are being considered separately. In each case, management would like to know whether the change might result in the solution in Figure 3.5 no longer being opti- mal. Answer this question in parts a to e by using the spread- sheet and Solver directly. If the optimal solution changes, record the new solution. a. The daily cost per agent for shift 2 changes from $160 to $165. c. The changes in parts a and b both occur. d. The daily cost per agent increases by $4 for shifts 2, 4, and 5, but decreases by $4 for shifts 1 and 3. e. The daily cost per agent increases by 2 percent for each shift. f. Use Solver to generate the sensitivity report for this problem. Suppose that the above changes are being considered later without having the spreadsheet model immediately available on a computer. Show in each case how the sensitivity report can be used to check whether the original optimal solution must still be optimal. . For each of the five shifts in turn, use a parameter AS analysis report to systematically generate the opti- mal solution and total çost when the only
Consider the Union Airways problem presented in Sec- tion 3.3, including the spreadsheet in Figure 3.5 showing its for- mulation and optimal solution. Management is about to begin negotiations on a new contract with the union that represents the company's customer service agents. This might result in some small changes in the daily costs per agent given in Table 3.5 for the various shifts. Several possible changes listed below are being considered separately. In each case, management would like to know whether the change might result in the solution in Figure 3.5 no longer being opti- mal. Answer this question in parts a to e by using the spread- sheet and Solver directly. If the optimal solution changes, record the new solution. a. The daily cost per agent for shift 2 changes from $160 to $165. c. The changes in parts a and b both occur. d. The daily cost per agent increases by $4 for shifts 2, 4, and 5, but decreases by $4 for shifts 1 and 3. e. The daily cost per agent increases by 2 percent for each shift. f. Use Solver to generate the sensitivity report for this problem. Suppose that the above changes are being considered later without having the spreadsheet model immediately available on a computer. Show in each case how the sensitivity report can be used to check whether the original optimal solution must still be optimal. . For each of the five shifts in turn, use a parameter AS analysis report to systematically generate the opti- mal solution and total çost when the only
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 30P
Related questions
Question
D ,e and f
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 9 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning