The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivity report below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$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 $B$14 Contract w/supplier LHS 2000 600 1400 1E+30 SB$15 Production Ratio LHS 50 -0.75 50 216.6666667 1116.666667 $B$16 Capacity LHS 800 0.666666667 800 1E+30 560 If Capacity RHS increases by 10, from 800 to 810.. Total profit will remain the same The shadow price will change, I have to re-run SOLVER Total profit will increase by 0.67 Total profit will increase by 6.67
The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivity report below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$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 $B$14 Contract w/supplier LHS 2000 600 1400 1E+30 SB$15 Production Ratio LHS 50 -0.75 50 216.6666667 1116.666667 $B$16 Capacity LHS 800 0.666666667 800 1E+30 560 If Capacity RHS increases by 10, from 800 to 810.. Total profit will remain the same The shadow price will change, I have to re-run SOLVER Total profit will increase by 0.67 Total profit will increase by 6.67
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
Related questions
Question
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 with 2 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,