Question: #3) Solve the following LP *USING EXCEL* Maximize $4x + $5y Subject to 4x + 5y 72 6x + 5y 27 -3x + 8y 0

#3) Solve the following LP *USING EXCEL* Maximize $4x + $5y Subject to 4x + 5y 72 6x + 5y 27 -3x + 8y 0 x, y 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if the profit per unit of x decreases to $1? c) What is the optimal solution and objective function value if the first constraint changes to 4x + 5y 80 d) What is the optimal solution and objective function value if the third constraint changes to -3x + 8y 0

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 Mathematics Questions!

Q:

3) Solve the following LP Maximize $4x + $5y Subject to 4x + 5y 72 6x + 5y 27 -3x + 8y 0 x, y 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution...

Q:

#2) Solve the following LP by using Excel. State the Optimal Solution and the Objective Function Value. Maximize profit = 6X + 5Y Subject to: 4X + 2Y 40 3X + 5Y 30 X 7 2X - Y 4 X, Y 0 #3) Solve the...

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:

6.14 and 6.15 help USING SPREADSHEET!! 6-14 Solve the following LP problem by using the graphi- cal procedure and by using Excel: Maximize profit = 4x + 5Y W TON AND PRUBLEMS 149 subject to the...

Q:

2-14: Solve the following LP problem by using Excel: Maximize profit = 4X + 5Y Subject to the constraints: 5X + 2Y 40 3X + 6Y 30 X 7 2X - Y 3 X, Y 0 2-18: Solve the following LP problem by using...

Q:

2-15 Solve the following LP problem by using the graphi- cal procedure and by using Excel: Maximize profit = 4X + 3Y subject to the constraints 2x + 4y = 72 3X + 6Y 2 27 -3X + 10Y > 0 X, Y 20

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:

2-14 Solve the following LP problem by using the graphi- cal procedure and by using Excel: Maximize profit = 4x + 5Y subject to the constraints 5X + 2Y = 40 3X + 6Y = 30 x = 7 2X - Y 2 3 X, Y zo

Q:

Solve the following LP problem using the graphical procedure and the Corner Point Property, NOT the level lines method. The graph and corner points coordinates are given in Excel. Please show the...

Q:

1 of 40 2.5 Points The half-life of the radioactive element krypton-91 is 10 seconds. If 16 grams of krypton-91 are initially present, how many grams are present after 10 seconds? 20 seconds? A. 10...

Q:

True or False: If there are currently 5,000 homeless people in New York City, and if the city builds housing for 1,000 people, then there will be 4,000 homeless people in New York City. (Answer...

Q:

a. You are the manager of the audit of a Platonic Limited (Platonic), an online retailer of clothing, shoes, and fashion accessories. Platonics single largest asset is inventory. Explain the purpose...

Q:

The fundamental software activities are following except one. a . Revolution b . Validation c . Specification d . Development

Q:

PLEASE ANSWER 2 & 3 1. Create a value stream map (VSM) of this supply chain. What other information is needed? 2. Where is there risk for supply chain disruptions or stoppages to the flow of...

Q:

1. Effort is important.

Q:

2. Set up two points representing the pillars of your values system. Discuss this with the others in the group.

Q:

8. Find values in the Norwegian culture that you believe have been stable over a long period. Do you feel that these values say something about your own values?