LP/Quadratic Objective Cell (Min) Final Cell Name Value Obj $B$13 4135000 Func AN 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 variables $C$11 0 7 48 1E+30 7 AO $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 variables $E$11 47000 0 35 7.0000001 8.0000001 BO 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 10500 $B$19 LHS 47000 0 57500 1E+30 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?
LP/Quadratic Objective Cell (Min) Final Cell Name Value Obj $B$13 4135000 Func AN 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 variables $C$11 0 7 48 1E+30 7 AO $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 variables $E$11 47000 0 35 7.0000001 8.0000001 BO 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 10500 $B$19 LHS 47000 0 57500 1E+30 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
Transcribed Image Text:LP/Quadratic
Objective Cell
(Min)
Final
Cell
Name
Value
Obj
$B$13
4135000
Func AN
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
variables
$C$11
0
7
48
1E+30
7
AO
$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
Transcribed Image Text:variables
$E$11
47000 0
35
7.0000001 8.0000001
BO
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
10500
$B$19 LHS
47000 0
57500
1E+30
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?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
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.