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...
The Kelly and Kelly Wrecking Company, a partnership, operates a general demolition business. Ownership of the company is divided among the partners, Mike Kelly, Kim Kelly, Larry Dennis, and Jim...
(e) Obtain estimates of the variance components for the same model terms and for the residual term, from the anova. Confirm your answers from the mixed modelling results.
Kase Company can invest in each of three cheese-making projects: C1, C2, and C3. Each project requires an initial investment of $190,000 and would yield the following annual cash flows. (1) Assuming...
Sanders Company purchased the following on January 1, 2019: Office equipment at a cost of $50,000 with an estimated useful life to the company of three years and a residual value of $15,000. The...
Obtain the Target Corporations annual report for its 2018 fiscal year (year ended February 2, 2019) at http://investors.target.com using the instructions in Appendix A, and use it to answer the...
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...
The Sherman Act prohibits the use of ____ power to create an anticompetitive market in a particular industry. a. Horizontal b. Vertical c. Structural d. Monopoly
Q.9 Prepare a cash flow statement using the indirect method based on the following information: - Net Income: $150,000 - Depreciation Expense: $20,000 - Increase in Accounts Receivable: $10,000...
3.11 (a) Find the order of the elements 2, 7, 10 and 12 in F17. (b) Find the order of the elements a, a, a + 1 and a3 + 1 in F16, where a is a root of 1+x+x4.
You have been recently hired to lead a Project to relocate your main Distribution Centre (DC) from Calgary, Alberta to St. John's, Newfoundland. As the Project Manager, try to complete a project plan...
Males Mean: 69.6 Standard Deviation: 11.3 For males, find P90, which is the pulse rate separating the bottom 90% from the top 10%.
Statistics Assignments Using Excel Assignment #4: Measures of Variability Part I Below are ACT composite scores from 20 randomly selected college students. 15 33 20 25 21 24 17 16 20 25 26 21 21 17...
Presented below are three independent revenue arrangements for Colbert Company. The company follows IFRS. Instructions Respond to the requirements related to each revenue arrangement. a. Colbert...
7. FALSE DILEMMA 8. GANDWAGON Definition: Fallacy example: How to revise argument: Definition: Fallacy example: How to revise argument:
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....
Product Weight Sales Additional Processing Costs P 300,000 lbs. $ 245,000 $ 200,000 Q 100,000 lbs. 30,000 -0- R 100,000 lbs. 175,000 100,000 If joint costs are allocated based on relative weight of...
The projected benefit obligation was $380 million at the beginning of the year. Service cost for the year was $21 million. At the end of the year, pension benefits paid by the trustee were $17...
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on...

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