Question: Question 2 (13 marks). Part 1 (3 marks): In the following Excel Solver sensitivity report, some values are missing as shown below. Adjustable Cells Cell

Question 2 (13 marks). Part 1 (3 marks): In the following Excel Solver sensitivity report, some values are missing as shown below. Adjustable Cells Cell Name SBS17 Ibs used A1 (whole) $C$17lbs used A2 (juice) $D$17lbs used A3 (paste) SE $17 Ibs used B1 (whole) $F$17 lbs used B2 (juice) $G$17 Ibs used B3 (paste) Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 525000 0.0066667 1E+30 0.0148889 75000 -0.0045 0.0148889 1E+30 -0.02233 0.0048 175000 0.0066667 1E+30 0.0148889 225000 -0.0045 0.0132296 1E+30 2000000 0.0048 1E+30 0.0148833 00? OP Constraints Final Value Name Cell $B$23 SB $24 SB $25 SB $26 SB $27 SB $28 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0.01225 600000 600000 466666.67 -0.01008 2400000 466666.67 200000 ? 1000000 ? 0.014883 2000000 200000 466666.67 -0.00558 0 466666.67 600000 -0.00558 0 1400000 200000 300000 ? 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

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!

Question 2 (13 marks). Part 1 (3 marks): In the following Excel Solver sensitivity report, some values are missing as shown below. Adjustable Cells Cell Name $B$17 lbs used A1 (whole) $C$17 lbs used...

NEED HELP ASAP!! Will upvote Easter is just around the corner! Hot cross buns are traditionally eaten over the Easter religious Christian holiday to symbolise the crucifixion of Jesus on Good Friday...

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

Question 7: Sensitivity analysis (20 marks, 2 marks per subquestion) A garden store prepares various grades of pine bark for mulch: nuggets ( x 1 ), mini-nuggets ( x 2 ), and chips ( x 3 ). The...

Part II: Sensitivity analysis (10 marks, 2 marks per subquestion) A garden store prepares various grades of pine bark for mulch: muggets (x1),mini nuggets (c), and chips (x3). The production process...

For each managerial task, list the issues to solve, and those roles which will contribute the most to your restaurants success.

Describe two errors that are not counterbalanced in the following period.

what is the new value of typicals banks excess reserves on hand? lower banks' excess reserves Geoffrey Precisely. Tight money policy will lower excess reserves and therefore loans. To correct this...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...