Question: In the following Excel Solver sensitivity report, some values are missing as shown below. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost
In the following Excel Solver sensitivity report, some values are missing as shown below.
| Adjustable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$17 | lbs used A1 (whole) | 525000 | 0.006667 | 1E+30 | 0.0148889 | ||
| $C$17 | lbs used A2 (juice) | 75000 | -0.0045 | 0.0148889 | 1E+30 | ||
| $D$17 | lbs used A3 (paste) | j? | -0.02233 | 0.0048 | l? | ||
| $E$17 | lbs used B1 (whole) | 175000 | k? | 0.006667 | 1E+30 | 0.0148889 | |
| $F$17 | lbs used B2 (juice) | 225000 | -0.0045 | 0.0132296 | 1E+30 | ||
| $G$17 | lbs used B3 (paste) | 2000000 | 0.0048 | 1E+30 | 0.0148833 | ||
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $B$23 | 0.01225 | 600000 | 600000 | 466666.67 | |||
| $B$24 | -0.01008 | 2400000 | 466666.67 | 200000 | |||
| $B$25 | 300000 | n? | 1000000 | o? | |||
| $B$26 | 0.014883 | 2000000 | 200000 | 466666.67 | |||
| $B$27 | m? | -0.00558 | 0 | 466666.67 | 600000 | ||
| $B$28 | -0.00558 | 0 | 1400000 | 200000 | |||
Determine the values of ONLY those missing items which are shaded in grey AND labeled by a circled number and a question mark. Please fill in correct values in the space provided below:
1.
2.
3.
4.
5.
6.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
