Question: Consider the Linear Program: MAXIMIZE Z = 11X1+18X2 Subject to: X1+X2 >= 60 X1+3X2

Consider the Linear Program: MAXIMIZE Z = 11X1+18X2

Subject to:

X1+X2 >= 60

X1+3X2 <= 210

2X1+X2 <= 170

X1 and X2 >= 0

SOLVE THIS PROBLEM IN EXCEL AND GENERATE A SENSITIVITY REPORT.

a. Specify the slack or surplus in each of the three resource constraints at the optimal solution.

b. Specify the shadow price for each of the three constraints.

c. Specify the range of optimality for each objective function coefficient.

d. Specify the range show price validity for each of the three constraints.

MOSTLY NEED HELP WITH C AND D

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:

Consider the Linear Program: MINIMIZE Z = 10X1+15X2 Subject to: X1+X2 >= 10 2X1+4X2 >= 32 3X1+2X2 = 0 a. Calculate the slack or surplus (indicate which it is) in each of the three constraints at the...

Q:

Consider the linear program Maximize z = x1, subject to: x1 + x2 2, x1 + x2 8, x1 + x2 4, x1 0, x2 0 a) State the above in canonical form. b) Solve by the simplex method. c) Solve geometrically and...

Q:

Consider the Linear Program: MAXIMIZE Z = 7X1+10X2 Subject to: X1+2X2 >= 4 4X1+5X2

Q:

*3. Consider the Linear Program: MAXIMIZE Z = 7X1 + 11X2 Subject to: X1 + X2 2 60 X1 + 3X2 s 210 2X1 + X2 0 Solve this problem in Excel and generate a Sensitivity Report. (a) Specify the slack or...

Q:

Question 2 2. Consider the Linear Program: MINIMIZE Z = 20X+ 16X, (You solved it in Ch.7) Subject to: X1 + X2 2 10 2X1 + 4X2 2 32 3X1 + 2X2 S 36 X1 and X2 20 (a) Calculate the slack or surplus...

Q:

Consider the linear program: Maximize : Z = 5x1 + 7x2 Subject to : 2x1 + 3x2 >=42 3x1 + 4x2 >= 60 x1 + 1x2 >= 18 x1 >= 0 x2 >= 0 (a) Use the graphical method to solve this problem. Identify all the...

Q:

Consider the linear program: Maximize : Z = 5x1 + 7x2 Subject to : 2x1 + 3x2 >=42 3x1 + 4x2 >= 60 x1 + 1x2 >= 18 x1 >= 0 x2 >= 0 Describe what the simplex method does step by step to solve the...

Q:

02. GRAPHICAL LP SOLUTION (5 points) Consider a linear program maximize z = -2x + y subject to the constraints shown in the figure. Drawing the objective function using different z values, identify...

Q:

Consider the Linear Program: MAXIMIZE Z = 5X 1 + 8X 2 Subject to: X 1 + 2X 2 = 0 a. Sketch the Region of Feasible solutions and list all corner point of the...

Q:

. Consider the Linear Program: MAXIMIZE Z = 7X 1 + 10X 2 Subject to: 2X 1 + 3X 2

Q:

Consider the following chain of matrices having matrices A, B, C and D. You have to consider the digits of your Registration Number in the order of the matrix as given. Add 2 to the digit if its...

Q:

Use Norton?s theorem to find V o in the network in figure. 2 kn 4 kn 2 MA Vo4 kn 24 V (+ 2 kn

Q:

General Accounting Helix Transport purchases a new truck for $60,000. Sales tax: $3,600 Company decals painted: $1,200 - Annual license fee: $200 Safety testing before use: $400 What is the total...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...