Variable Cells Model Variable Constraints. Constraint Number 1 E S D E S 3 D M S D Name Economy Models Standard Models Deluxe Models Total Profit: $ Name Fan Motors Cooling Coils Manufacturing Time Constraints Fan motors Cooling coils Optimal Solution Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 Reduced Cost CHINISHA MECRATICA 0.000 0.000 -24.000 a. Identify the range of optimality for each objective function coefficient. If there is no lower or upper limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Objective Coefficient Range Variable lower limit upper limit E Right-Hand-Side-Range lower limit upper limit Shadow Price 31.000 32.000 0.000 Objective Coefficient 63.000 95.000 135.000 b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal solution be? 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 c. Identify the range of feasibility for the right-hand-side values. If there is no lower or upper limit, then enter the text "NA" as your answer. 120.000 320.000
Variable Cells Model Variable Constraints. Constraint Number 1 E S D E S 3 D M S D Name Economy Models Standard Models Deluxe Models Total Profit: $ Name Fan Motors Cooling Coils Manufacturing Time Constraints Fan motors Cooling coils Optimal Solution Final Value 80.000 120.000 0.000 Final Value 200.000 320.000 2080.000 Reduced Cost CHINISHA MECRATICA 0.000 0.000 -24.000 a. Identify the range of optimality for each objective function coefficient. If there is no lower or upper limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Objective Coefficient Range Variable lower limit upper limit E Right-Hand-Side-Range lower limit upper limit Shadow Price 31.000 32.000 0.000 Objective Coefficient 63.000 95.000 135.000 b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal solution be? 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 c. Identify the range of feasibility for the right-hand-side values. If there is no lower or upper limit, then enter the text "NA" as your answer. 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:Variable Cells
Model
Variable
Constraints
E
S
D
Constraint
Number
1
E
2
3
S
D
S
D
Name
Economy Models
Standard Models
Deluxe Models
Name
Total Profit: $
Fan Motors
Cooling Coils
Manufacturing Time
Optimal Solution
Constraints
Fan motors
Cooling coils
Final
Value
80.000
120.000
0.000
Final
Value
200.000
320.000
2080.000
a. Identify the range of optimality for each objective function coefficient. If there is no lower or upper limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place.
Objective Coefficient Range
Variable lower limit upper limit
E
Reduced
Cost
0.000
0.000
-24.000
Manufacturing time. AUTO
Shadow
Price
31.000
32.000
0.000
Right-Hand-Side-Range
lower limit upper limit
Objective
Coefficient
63.000
95.000
135.000
b. Suppose the profit for the economy model is increased by $6 per unit, the profit for the standard model is decreased by $2 per unit, and the profit for the deluxe model is increased by $4 per unit. What will the new optimal solution be?
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
c. Identify the range of feasibility for the right-hand-side values. If there is no lower or upper limit, then enter the text "NA" as your answer.
Expert Solution
Step 1: Define - Linear programming
Linear programming is a mathematical method used to find the best possible outcome or solution from a given set of requirements or constraints which are represented in the form of linear relationships. It is most often used in mathematics and computer science, but also widely used in business and economic situations. Linear programming can help businesses make decisions such as managing resources, production schedules, and other operational details in order to increase profits or decrease costs while maintaining a certain level of quality and production flow.
Step by step
Solved in 5 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.