Consider the sensitivity report below that shows the solution of a linear program with 3 decision variables, 3 constraints with sign and a Maranisation objective action f the profit of economy models was increased to 70 and the proft for standand models was increased to 120. Which of following scenarios will happen Variable Cells Model Variable E S D Constraints Constraint Number 1 2 3 Name Economy Models Standard Models Deluxe Models Name: Fan Motors Cooling Coils Manufacturing Time Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 Select one O The optimal soubin will remain the same and the objective function o be equal to 25000 be equal to 16440 Ob The optimal solution will change and the objective function v Oe None of the above O The optimal solution will remain the came and the objective funcion wit memain the same O The optimal solution will change Of The optimal solution will remain the same the objective function will be equal to 10440 Reduced Cost 0.000 0.000 -24.000 Shadow Price 31.000 32.000 0.000 Objective Coefficient 63.000 95.000 135.000 Constraint R.H. Side 200,000 320.000 2400.000 Allowable Increase 12.000 31.000 24.000 Allowable Increase 80,000 80.000 IE+30 Allowable Decrease 15.500 8.000 IE+30 Allowable Decrease 40.000 120.000 320.000
Consider the sensitivity report below that shows the solution of a linear program with 3 decision variables, 3 constraints with sign and a Maranisation objective action f the profit of economy models was increased to 70 and the proft for standand models was increased to 120. Which of following scenarios will happen Variable Cells Model Variable E S D Constraints Constraint Number 1 2 3 Name Economy Models Standard Models Deluxe Models Name: Fan Motors Cooling Coils Manufacturing Time Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 Select one O The optimal soubin will remain the same and the objective function o be equal to 25000 be equal to 16440 Ob The optimal solution will change and the objective function v Oe None of the above O The optimal solution will remain the came and the objective funcion wit memain the same O The optimal solution will change Of The optimal solution will remain the same the objective function will be equal to 10440 Reduced Cost 0.000 0.000 -24.000 Shadow Price 31.000 32.000 0.000 Objective Coefficient 63.000 95.000 135.000 Constraint R.H. Side 200,000 320.000 2400.000 Allowable Increase 12.000 31.000 24.000 Allowable Increase 80,000 80.000 IE+30 Allowable Decrease 15.500 8.000 IE+30 Allowable Decrease 40.000 120.000 320.000
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:Consider the sensitivity report below that shows the solution of a linear program with 3 decision variables, 3 constraints with sign and a Manisation objective action f
the profit of economy models was increased to 70 and the proft for standard models was increased to 120. Which of the following scenarios will happen
Variable Cells
Model
Variable
E
S
D
Constraints
Constraint
Number
2
3
Name
Economy Models
Standard Models
Deluxe Models
Name
Fan Motors
Cooling Coils
Manufacturing Time
Final
Value
80.000
120.000
0.000
Final
Value
200.000
320.000
2080.000
Select one
O a The optimal solubin will remain the same and the objective function will be equal to 25000
O
The optimal solution will change and the objective function will be equal to 16440
None of the above
O
O
The optimal solution will remain the same and the objective function will remain the same
O The optimal solution will change
Of The optimal solution will remain the same and the objective function will be equal to 16440
Reduced
Cost
0,000
0.000
-24.000
Shadow
Price
31.000
32.000
0.000
Objective
Coefficient
63.000
95.000
135.000
Constraint
R.H. Side
200.000
320.000
2400.000
Allowable
Increase
12.000
31.000
24.000
Allowable
Increase
80,000
80,000
IE+30
Allowable
Decrease
15.500
8.000
IE+30
Allowable
Decrease
40.000
120.000
320.000
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 3 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.