Question: Consider the linear programming formulation below. Maximize profit = 50X + 42Y subject to the constraints 5X 4Y 200 X 60 Y

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 you get?

(b) Add a single constraint that would eliminate the error message. What constraint did you add, and what is the value of the optimal solution?

Step by Step Solution

★★★★★

3.47 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a The error message received is Solver could not f... 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 problem given by Maximize Z=8x,-4X2+4X3 subject to -2x, +X2+3x3 2 11, X1-X2+2X32 6, X1,X2;X3 20. Prepare problem for a dual simplex method and solve.

Q:

What is Cp, and why is a value of 0.80 not good? How about a value of 1.00? 1.3?

Q:

B.2 Solve the following linear programming problem graphically: Maximize profit 4X + 6 Y Subject to: X + 2Y = 8 5X + 4y = 20 X, Y >0 PX B.3 Solve the following linear programming problem graphically:...

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:

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:

The Optimization Case Study corresponds to concepts taught in Module 2 (Optimization -Part 1) and Module 3 (Optimization - Part 2). This is a team assignment. The instructions require you to complete...

Q:

please write step by step on how to imput in excel a B.3 Solve the following linear programming problem graphically: Maximize profit = X + 10 Y Subject to: 4X + 3Y S 36 2x + 4y = 40 Y = 3 X, Y Z 0PX...

Q:

Introduction to management ( MG305) book problem 16, pg 151 LINEAR PROGRAMMING SENSITI 16 Consider the Insider the following LP problem, in which X and enote the number of units of products X and Y...

Q:

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Q:

A mortgage contract for $43,000 written 10 years ago is just at the end of its second five-year term. The interest rates were 8% compounded semiannually for the first term and 6% compounded...

Q:

Two people of equal mass attempt a tug-of-war with a 12-m rope while standing on frictionless ice. When they pull on the rope, each of them slides toward the other. How do their accelerations...

Q:

9. LO.5 What are the important concepts to be considered when U.S. assets are transferred outside the country to be used in starting a new business?

Q:

6. In the long run, a producer can change its fixed input and its level of fixed cost. By accepting higher fixed cost, a firm can lower its variable cost for any given output level, and vice versa....

Q:

19 Porter Investments needs to develop an investment portfolio for Mrs. Singh from the following list of possible investments: INVESTMENT COST EXPECTED RETURN A $ 10,000 $ 700 B $ 12,000 $ 1,000 C $...

Q:

18 Stockbroker Susan Drexler has advised her client as shown in the following table. INVESTMENT COST (thousands) EXPECTED RETURN (thousands) Andover municipal bonds $ 400 $ 35 Hamilton city bonds...

Q:

17 A vending machine is programmed to count out the correct change for each transaction. Formulate and solve an IP model that will determine how change is to be made for a purchase of $4.43, when a...

Q:

Level of significance, null and alternate hypotheses, P-value, comparison and will you reject or fail to reject, conclusion in the context of the application Teacher ratings: Grades -Professor Stone...

Q:

What is the capacity for the container below 30cm 15cm 20 cm give answer in nearest tenth of a liter

Q:

1. The Fort Stockton Furniture Co. has the following financial data. Prepare an income statement in good accounting order and compute earnings per share. Sales Depreciation expense Debt (11% interest...