Question: Use Excel Solver to solve the following LP problem, and generate the sensitivity report. Min 8X 1 +12X 2 st. x 1 +3X 2 >=9

Use Excel Solver to solve the following LP problem, and generate the sensitivity report.

Min 8X1+12X2

st. x1+3X2>=9

2X1+2X2>=10

6X1+2X2>=18

X1>=0

X2>=0

What is the range of optimality of X1 coefficient?

Assume the objective function coefficient for X1 changes from 8 to 13, does the optimal solution changes?

Assume the objective function coefficient for X1 changes from 8 to 5, does the optimal solution changes?

What is the range of optimality of X2 coefficient?

Assume the objective function coefficient for X2 changes from 12 to 22, does the optimal solution changes?

Assume the objective function coefficient for X2 changes from 12 to 7, does the optimal solution changes?

Please submit your Excel Worksheet with the sensitivity report and clearly mark your answer to the above questions in your submission as well.

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!

Q:

Use Excel Solver to solve the following linear programming problem. Generate the answer report and sensitivity report after the LP is solved. Submit the Excel file with the model and reports....

Q:

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

Q:

Consider the following LP problem: MIN: 5X, + 3X, + 4X, Subject to: X,+ X,+2X, =2 5X, + 3X, + 2X, = 1 XX, X;=0 Use slack variables to rewrite this problem so that all its constraints are equal-to...

Q:

Consider the following problem: Min 6 x 1 + 9 x 2 ($ cost) s.t. x 1 + 2 x 2 30 x 2 > 2 x 1 , x 2 > 0 Use Excel Solver to solve the problem and generate the Sensitivity Report....

Q:

Solve the following LP problem using excel solver and indicate the optimal solution. Maximize profit = $3X + $2Y subject to: 2X + Y

Q:

Solve the following LP problem using excel solver and indicate the optimal solution. Maximize profit = $3X + $2Y subject to: 2X + Y

Q:

Consider the following problem: Min 6x1 + 9x2 ($ cost) s.t. X1+ 2x2 30 X2 > 2 X1, X2 > 0 1. Use Excel Solver to solve the problem and generate the Sensitivity Report. You need to submit your Excel...

Q:

QUESTIONS Smyrna industry is a firm that produces two products, Product A and Product B, in a single factory. The process to produce these two products are similar and the same two machines are being...

Q:

Parker's Golf Associates (PGA) produces two types of golf bags. The standard (S) bag generates a profit of $10 per bag and the deluxe (D) bag generates a profit of $9 per bag. Each type of bag must...

Q:

Parkers Golf Associates (PGA) produces two types of golf bags. The standard (S) bag generates a profit of $10 per bag and the deluxe (D) bag generates a profit of $9 per bag. Each type of bag must go...

Q:

This spreadsheet is set up so that green cells contain numbers and white cells contain formulas. Follow the steps below to prepare proformas for 2015, assuming that New England Corp. will make up any...

Q:

On October 27, 2011, a freak snowstorm destroyed the work-in-process of the company, who promptly filed a claim with their insurance company for the lost work-in-process inventory, and raw materials...

Q:

Drections: Select the best response, and select SUBMIT. If an IMA member encounters unethical issues or behavior, the IMA Statement of Ethical Professional Practice indicates what action? Actively...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...