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.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
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,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.