Question: Question 6 (6 marks): In the following Excel Solver sensitivity report, some values are missing as shown below. Determine the values of ONLY those missing

Question 6 (6 marks): In the following Excel Solver sensitivity report, some values are missing as shown below.

Question 6 (6 marks): In the following Excel

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:

A B 1 Adjustable Cells C D E F G H Cell $B$17 $C$17 $D$17 $E$17 $F$17 $G$17 6 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 5250000 ? 0.00666667 1E+30 0.014888889 75000 -0.0045 0.014888889 1E+30 ? -0.022333 0.0048 ? 175000 0.00666667 1E+30 0.014888889 225000 -0.0045 0.01322963 1E+30 2000000 0.0048 1E+30 0.014883333 Name lbs used A1 (whole) lbs used A2 (juice) lbs used A3 (paste) lbs used B1 (whole) lbs used B2 (juice) lbs used B3 (paste) 7 8 9 10 Name Final Value @? 11 Constraints 12 13 Cell 14 $B$23 15 $B$24 16 $B$25 17 $B$26 18 $B$27 $B$28 20 300000 Shadow Price 0.01225 -0.010083 ? 0.0148833 -0.005583 -0.005583 Constraint Allowable Allowable R.H. Side Increase Decrease 600000 600000 466666.6667 2400000 466666.6667 200000 1000000 ? 2000000 200000 466666.6667 0466666.6667 600000 0 1400000 200000 19

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!

Part I ( 3 marks): In the following Excel Solver sensitivity report, some values are missing as shown below. labeled by a circled number and a question mark. riease m. ........ space provided below

In the following Excel Solver sensitivity report, some values are missing as shown below. Determine the values of ONLY those missing items which are shaded in grey AND labeled by a circled number and...

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...

A business student is working on a product-mix question, and he employed a linear programming model to maximize the total profit of producing a portfolio of products 1, 2, 3, and 4. In the following...

Can you help me in Business Decision Analytics? Can you show me how to calculate it in excel if necessary. We know about a linear programming problem that all three of its variables are non-negative...

Question 2. Consider the LP model in Question 1, and answer the following sensitivity analysis related questions based on the graphical representation and optimal solution you obtained. You can use...

Question 1 Optimizing Inventory and Maximizing Profits at Revolution Bikes Revolution Bikes keeps an inventory of high-quality bike frames on hand for all their custom jobs and would like to minimize...

Which of the following material events occurring subsequent to the balance sheet date would require an adjustment to the financial statements before they could be issued? options: Sale of long-term...

Question 7 6 of 9 1 All of the following policies are exempt from the illustration regulations EXCEPT A . Variable life. B . Credit life. C . Group annuities. D . Individual life insurance policies...

There are two types of options (based on exercise dates), European and American. When can an American-style option be exercised? Question 8 options: Only at the expiry date Any time after the expiry...