Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet7 Report Created: 9/26/2020 10:43:05 AM Engine: Standard LP/Quadratic Objective Cell (Min) Cell Name Final Value $B$13 Obj Func AN 4135000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 variables AN 55000 0 33 7.0000001 41.0000001 $C$11 variables AO 0 7 48 1E+30 7 $D$11 variables BN 25000 0 27 8.0000001 7.0000001 $E$11 variables BO 47000 0 35 7.0000001 8.0000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 $B$19 LHS 47000 0 57500 1E+30 10500 The answers to the questions are found in this sensitivity report. Questions: Write your responses in the space provided 1. What is the range of optimality for the BN and BO variables? write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40 2. What is the range of feasibility for the constraints located on B17 and B18? 3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet7 Report Created: 9/26/2020 10:43:05 AM Engine: Standard LP/Quadratic Objective Cell (Min) Cell Name Final Value $B$13 Obj Func AN 4135000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 variables AN 55000 0 33 7.0000001 41.0000001 $C$11 variables AO 0 7 48 1E+30 7 $D$11 variables BN 25000 0 27 8.0000001 7.0000001 $E$11 variables BO 47000 0 35 7.0000001 8.0000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 $B$19 LHS 47000 0 57500 1E+30 10500 The answers to the questions are found in this sensitivity report. Questions: Write your responses in the space provided 1. What is the range of optimality for the BN and BO variables? write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40 2. What is the range of feasibility for the constraints located on B17 and B18? 3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?
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
Microsoft Excel 16.0 Sensitivity Report | |||||||
Worksheet: [Book1]Sheet7 | |||||||
Report Created: 9/26/2020 10:43:05 AM | |||||||
Engine: Standard LP/Quadratic | |||||||
Objective Cell (Min) | |||||||
Cell | Name | Final Value | |||||
$B$13 | Obj Func AN | 4135000 | |||||
Decision Variable Cells | |||||||
Final | Reduced | Objective | Allowable | Allowable | |||
Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
$B$11 | variables AN | 55000 | 0 | 33 | 7.0000001 | 41.0000001 | |
$C$11 | variables AO | 0 | 7 | 48 | 1E+30 | 7 | |
$D$11 | variables BN | 25000 | 0 | 27 | 8.0000001 | 7.0000001 | |
$E$11 | variables BO | 47000 | 0 | 35 | 7.0000001 | 8.0000001 | |
Constraints | |||||||
Final | Shadow | Constraint | Allowable | Allowable | |||
Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
$B$16 | LHS | 55000 | 41 | 55000 | 10500 | 47000 | |
$B$17 | LHS | 72000 | 35 | 72000 | 10500 | 47000 | |
$B$18 | LHS | 80000 | -8 | 80000 | 47000 | 10500 | |
$B$19 | LHS | 47000 | 0 | 57500 | 1E+30 |
10500
|
The answers to the questions are found in this sensitivity report.
Questions: Write your responses in the space provided
1. What is the range of optimality for the BN and BO variables?
write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40
2. What is the range of feasibility for the constraints located on B17 and B18?
3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.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.