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

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Managerial Decision Modeling Business Analytics With Spreadsheet

ISBN: 9781501515101

4th Edition

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

See More Books

Question Posted: Aug 25, 2021 02:27 AM

See More Questions

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...
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...
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...
Find the distance between the given pairs of points. (32, 18) and (50, 8)
For the reaction carried out at some fixed temperature, the equilibrium constant is 2.0. a. Which of the following pictures correctly depicts the reaction mixture at equilibrium? b. For the pictures...
Frank and Liz are married. During 2011, Frank has $2,800 in state income taxes withheld from his paycheck, and Liz makes estimated tax payments totaling $2,200. In May 2011, they receive a state tax...
The magnetic flux through a conducting loop increases at a rate of $3.0 \mathrm{~T} \cdot \mathrm{m}^{2} / \mathrm{s}$. What is the magnitude of the induced emf in the loop?
Sales budget data for Paige Company are given in BE23-2. Management desires to have an ending finished goods inventory equal to 25% of the next quarters expected unit sales. Prepare a production...
4. In doubly linked lists, traversal can be performed?4 a) Only in forward direction b) Only in reverse direction c) In both directions d) None
Unemployment is escalating from 24,728 in 2010 to 48,100 in recent years. In its effort to encourage young Malaysians to be self-employed, Small and Medium Enterprise Malaysia (SME Corp, Malaysia) is...
Solve the following LP problem by using the graphical procedure and by using Excel: Maximize 40X + 50Y subject to the constraints X + 2Y 80 4X + 3Y 240 X 51 X, Y 0
Consider the linear programming formulation below, where X and Y represent units of production of two different products. As currently written, the formulation is infeasible. The formulation can...
Why is the exercise of power necessary for organizations to operate effectively? What are some of the ways in which people gain power in organizations?
The elementary step reversible reaction shown below occurs in the liquid phase in a plug flow reactor. The feed contains only A at a concentration of 5 mol/L at a volumetric rate of 40 L/h. The...
Which sources of INTERNATIONAL LAW are the best in helping to control the covid 19, the pandemic. Give reasons and examples for the particular sources. (Sources of international law: Treaty,...
Treaties are an important element of international law give two reasons why this is the case when compared to other sources of international law
Argue why there is relationship of human right and international law. Integrate international law and human rights ties with divine providence in the argument.
Despite considerable emphasis by some international law scholars on court cases and precedents, can an argument be made that treaty law is the most important source of international law? Why?
(a) Find all solutions to the matrix equation AX = B when and (b) Find all solutions to XA = B. Are they the same?
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
Roger Corporation operates in two states, as indicated below. This year's operations generated $400,000 of apportionable income. Compute Roger's State A taxable income assuming that State A...
State E applies a throwback rule to sales, while State F does not. State G has not adopted an income tax to date. Clay Corporation, headquartered in E, reported the following sales for the year. All...
Quinn Corporation is subject to tax in States G, H, and I. Quinns compensation expense includes the following. Officers' salaries are included in the payroll factor for G and I, but not for H....
A force of F = 13 kips is applied as shown in the figure below. If the diameter of the bolt is d = 1.4 inches, find the maximum average shear stress in the bolt. Report your value in units of psi to...
A heat exchanger connects two pieces of machinery. The right end of the exchanger (x = 0), is held at a constant temperature, Tref. The left end is insulated. Along the exchanger's length, heat is...
The simply supported beam AE carries a uniformly distributed load with an intensity of 20 kN/m from A to B, and a concentrated load of 10 kN at point D, as shown in Figure Q2(a). The beam has the...

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

Question:

Step by Step Answer:

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

Managerial Decision Modeling Business Analytics With Spreadsheet

Students also viewed these Business questions