If profit contribution for G increases by 12, from 5 to 17, Since the optimal solution will change, I need to re-run SOLVER Optimal solution will change, new total profit 1165.83 Both optimal solution and total profit will remain the same Optimal solution remains the same, new total profit = 1165.83 %3D
If profit contribution for G increases by 12, from 5 to 17, Since the optimal solution will change, I need to re-run SOLVER Optimal solution will change, new total profit 1165.83 Both optimal solution and total profit will remain the same Optimal solution remains the same, new total profit = 1165.83 %3D
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:If profit contribution for G increases by 12, from 5 to 17,
Since the optimal solution will change, I need to re-run SOLVER
O Optimal solution will change, new total profit = 1165.83
Both optimal solution and total profit will remain the same
Optimal solution remains the same, new total profit = 1165.83
%3D

Transcribed Image Text:Georgia Electronics produce two calculators: Graphic (G) and Financial (F). The model
is given below:
Max Total Profit = 5'G + 10'F
%3!
S.T.:
Contract w/supplier 30*G + 15'F>= 600
Production Ratio
4*G - 8*F >= 50
Capacity
Non-negativity
12'G + 6*F <= 800
G.F >= 0
The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivity
report below.
%3D
Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
SB$9 G
55.83333333
15
10
$C$9 F
21.66666667
10
1E+30
7.5
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
SB$14 Contract w/supplier LHS
2000
600
1400
1E+30
$8$15 Production Ratio LHS
50
-0.75
50 216.6666667 1116.666667
$B$16 Capacity LHS
800 0.666666667
560
800
1E+30
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.