Question: Use the Solver sensitivity report to answer the question: What is the optimal value for X1 and X2? Sensitivity Report Changing Cells Reduced Objective Coefficient

Use the Solver sensitivity report to answer the

Use the Solver sensitivity report to answer the question: What is the optimal value for X1 and X2? Sensitivity Report Changing Cells Reduced Objective Coefficient Cost Cell $B$12 SC$12 Name Variables Variable 1 Variables Variable 2 Final Value 8.461538462 4.615384615 Allowable Increase 7 8.5 Allowable Decrease 3.4 2.333333333 S 0 0 4 Constraints Final Allowable Decrease Value Cell SB$15 SB$16 Name constraint 1 Used constraint 2 Used constraint 3 Used 40 Shadow Price 0.538461538 1.307692308 0 Constraint R.H. Side 40 30 Allowable Increase 110 30 1.076923077 30 4.666666667 1E+30 SB$17 13.07692308 12 a. 40, 30. O b.5, 4 O c.0.54, 1.31 O d. 8.46, 4.61

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!

Next Page Question 1 (0.4 points) Use the Solver sensitivity report to answer the following question. What's the maximum value of the coefficient of Variable 2 that can be increased without change...

Use the Solver sensitivity report to answer the following question. What's the maximum value of the coefficient of Variable 2 that can be increased without change the optimal solution? Sensitivity...

Use the Solver sensitivity report to answer the question: which constraint(s) is (are) binding? Sensitivity Report Changing Cells Reduced Cost Objective Coefficient Cell $B$12 SC$12 Name Variables...

A business student has $ 3 5 0 0 available from a summer job and has identified three potential stocks in which to invest. To find an optimal solution to maximize, the Excel add - in Solver was used....

Thanks for your time A real estate developer is planning to build an office complex. Currently, there are three office sizes under consideration: small, medium, and large. Small offices can be rented...

Microbrewers Inc. makes four beers: Light, Dark, Ale, and Premium. Making each type of beers needs a different mix of Malt, Hops and Yeast. Currently, Microbrewers orders and receives 50,000 pounds...

Use the following sensitivity report to answer the questions. Choose the correct answer in the dropdown box. Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase...

1. The Excel Sensitivity Report for Feed problem where the objective is minimization of cost is provided below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

The Excel Sensitivity Report for Feed problem where the objective is minimization of cost is provided below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost...

Oil enters a circular tube (3mm diameter) at 0 degree C that is surrounded by a heating fluid at 100 degree C. Assume the Nu outside the tube is 1 and the thermal conductivity of the heating fluid is...

The Springdale computer database exercise of Chapter 2 listed 30 shopping-related questions asked of 150 respondents in the community of Springdale. The data are in file SHOPPING. The coding key for...

How many years can unused foreign tax credits be carried forward? a . 5 years b . 7 years c . 1 5 years d . 1 0 years

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...