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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!