Question: Consider the linear programming formulation below. Minimize cost = 5X + 4Y subject to the constraints 5X + 4Y 200 4X + 6Y

Consider the linear programming formulation below.

Minimize cost = 5X + 4Y
subject to the constraints

5X + 4Y ≥ 200
4X + 6Y ≥ 360
8X + 4Y ≤ 160
X            ≥ 20
Y            ≤ 50
X, Y        ≥ 0

(a) Try to solve the problem in Excel. What error message do you get?

(b) The error can be eliminated by removing one of the constraints. Remove that constraint and resolve the model. What is the optimal solution?

Step by Step Solution

★★★★★

3.32 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a To solve this LP problem in Excel you would need to set up the problem in a spreadsheet using the ... View full answer

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 Managerial Decision Modeling Business Analytics With Spreadsheet Questions!

Q:

Consider the linear programming model for player 1 given near the end of Sec. 15.5 for variation 3 of the political campaign problem (see Table 15.6). Verify the optimal mixed strategies for both...

Q:

Consider the linear programming model for the general assignment problem given in Sec. 9.3. Construct the table of constraint coefficients for this model. Compare this table with the one for the...

Q:

Consider the linear programming formulation below. Maximize profit = 50X + 42Y subject to the constraints 5X 4Y 200 X 60 Y 10 X, Y 0 (a) Try to solve the problem in Excel. What error message do...

Q:

MATH 106 Week 8 LEO Discussion Topic Exercises Version: 2015-1 Linear Programming 1. Graphically solve the following: Maximize , subject to: f 6x y 2. x y 8 3x y 0 y 0 Solve the given linear...

Q:

Q1. Solve the equation 3 x = 81. a. {27} b. {5} c. {4} d. {3} Q2. Write log 2 ( 7 m 3 n)/k 2 as the sum and/or difference of logarithms. Express powers as factors. a. (1/7) log 2 m + (1/3) log 2 n -...

Q:

Use the simplex method to solve the linear programming problem. Maximize z = 500x, + 300x2 + 200x3 subject to X1 + X2 + X3 5 120 2x1 +3x2 +4X3 5 360 2 x1 + x2 + X3 5 160 x1 20, X2 20, X3 20. Select...

Q:

1. Solve the equation log a. {-7} 4 (x + 2) = -1 b. {-7/4} c. {9/4} d. {9} Q2. Use the horizontal line test to determine whether the function is one-to-one. a. Yes b. No Q3. The half-life of...

Q:

3/10/2017 MATH 105 Exam 3 MATH 105 Exam 3 40 Unanswered Please be sure to save at least once every 15 minutes. If you leave this page without saving, or if your session times out, any answers you...

Q:

9/14/10 12:39 PM Page 381 Chapter dug84356_ch06a.qxd 6 Rational Expressions Advanced technical developments have made sports equipment faster, lighter, and more responsive to the human body. Behind...

Q:

| 4 | | | | 5 | | | | | | | | 1. For the constraints given below, please show the feasible solution space (or area) in the graph. (1) X1 + X2 5, (2) 2X1 + 2X2 6, (3) 3X1 + 5X2 15 2. What combination...

Q:

1. A change in demand causes a ____ (movement along/shift of) the demand curve. A change in quantity demanded causes a ______ (movement along/ shift of ) the demand curve. 2. Circle the variables...

Q:

A painting company has determined that for the company to expand globally over the next several years, its executives must be aware of any political and economic concerns that may arise during the...

Q:

1 . do the adjusting entries for 2 0 2 3 2 . produce a balance sheet for 2 0 2 3 3 . carry the 2 0 2 3 adjustments to 2 0 2 4 to update the opening balance 4 . complete the financial statement a ....

Q:

5. When average total cost is U-shaped, the bottom of the U is the level of output at which average total cost is minimized, the point of minimum-cost output. This is also the point at which the...

Q:

16 A hospital is planning an $8 million addition to its existing facility. The architect has been asked to consider the following design parameters: (1) There should be at least 10 and no more than...

Q:

12 Which of the following are NLP models, and why? Are any of these quadratic programming models? (a) Maximize profit = 3X1 + 5X2 + 99X3 subject to the contraints X1 10 X2 5 X3 18 (b) Maximize...

Q:

11 What does the term quadratic programming mean?

Q:

Please answer all the questions what is asked in number 1-6 ma'am/sir. Thank you! 1. Do social robots walk or roll? According to the United 2. Beach erosional hotspots. Beaches that exhibit high ero-...

Q:

example of ids 1 0 5 module five

Q:

Adapted AICPA Task-Based Simulation Youu are involved with the audit of Jelco Company for year 1 and have been asked to consider the confirmation reply results indicated below. For each confirmation...