Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 $ amount in MB ? -0.045 0.085 ? ? $C$11
Adjustable Cells | |||||||
Final | Reduced | Objective | Allowable | Allowable | |||
Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
$B$11 | $ amount in MB | ? | -0.045 | 0.085 | ? | ? | |
$C$11 | $ amount in CD | 0 | ? | 0.05 | 0.015 | 1E+30 | |
$D$11 | $ amount in TB | 38181.82 | ? | 0.065 | 0.065 | 0.015 | |
$E$11 | $ amount in GS | 31818.18 | 0 | 0.13 | 1E+30 | 0.045 | |
Constraints | |||||||
Final | Shadow | Constraint | Allowable | Allowable | |||
Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
$B$18 | Fund LHS | ? | 0.094545 | 70000 | 1E+30 | 31500 | |
$B$19 | MB LHS | ? | 0 | 14000 | ? | 14000 | |
$B$20 | CD & others LHS | -70000 | ? | 0 | ? | ? | |
$B$21 | CD & TB LHS | 38181.82 | ? | 21000 | ? | ? | |
$B$22 | Ratio LHS | ? | -0.02955 | 0 | 70000 | 37800 | |
For the constraints, find the following question marks with justification.
- Final value of FUND (constraint).
- Final value of MB (constraint).
- Allowable Increase of MB (constraint).
Shadow Price of CD& others (constraint).
- Allowable Increase of CD& others (constraint).
- Allowable Decrease of CD& others (constraint).
- Shadow price of CD& TB (constraint).
- Allowable Increase of CD& TB (constraint).
- Allowable Decrease of CD& TB (constraint).
- Final value of Ratio (constraint).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started