Question: Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4X + 3y Subject to the constraints 2X

Solve the following LP problem by using the graphical procedure and by using Excel:
Maximize profit = 4X + 3y
Subject to the constraints
2X + 4y <72 3X +
6y > 27
—3x + ioy > 0
x,y >0

Step by Step Solution

★★★★★

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

718-M-S-L-P (985).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Solve the following LP problem using level curves. MAX: 4X1 + 5X2 Subject to: 2X1 + 3X2 120 4X1 + 3X2 140 X1 + X2 80 X1, X2 0

Solve the following LP problem graphically: Minimize cost = 24X + 15Y Subject to: 7X + 11Y 77 16X + 4Y 80 X,Y 0

Maximize x + 3y subject to the constraints Solve the linear programming problem by the simplex method. x+ ys7 x+ 2y s 10 x2 0, y 20.

solve 16. Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit =4X+5Y subject to the constraints 5X+2Y403X+6Y30X72XY3X,Y0 -17. Solve the following LP...

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...

Please make sure to show Excel calculations and graph. Thank you. 2. 2-14 Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4x + 5Y subject to the...

Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4x + 5Y subject to the constraints 5X+ 2Y

please solve by HAND. the answer is (x=12, y=20) with minimized cost $188. but i would like to know where the 12 comes from as well. Thanks! 6. 2-18 Solve the following LP problem by using the...

6. 2-18 Solve the following LP problem by using the graphical procedure and by using Excel: Minimize cost = 4X + 7Y subject to the constraints 3X + 6Y > 100 10X + 2Y > 160 2Y > 40 2X 0

How to solve 2 - 1 6 . ( MAKE SURE IT IS IN EXCEL AND WITH EXPLICATION OF ALL STEP ) Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4 x + 5 Y...

Identify three fundamental uses for an executive support system.

Repeat Exercise 9 using Algorithm 6.3 in Maple with Digits:= 10. In Exercise 9 a. 0.03x 1 + 58.9x 2 = 59.2, 5.31x 1 6.10x 2 = 47.0. Actual solution [10, 1] b. 3.03x 1 12.1x 2 + 14x 3 = 119, 3.03x 1...

The physical fitness score for a population of police officers at a local police station is 73 with an SD of 8 on a 100point physical endurance scale Suppose the police chief selects a sample of 64...

Exercise S Victoria Falls Company, Inc., records show the following account balances for the year ending 2010 December 31: Cost Retail Beginning inventory USD 42,000 USD 57,500 Purchases 25000 37500...

2. Understand major business application areas for LP problems, including manufacturing, marketing, finance, employee staffing, transportation, blending, and multiperiod planning.

1. Model a wide variety of linear programming (LP) problems.

2. Solve by using Excel to find the best solution. Kenneth and Patricia Golding spent a career as a husband-andwife real estate investment partnership in Washington, DC. When they finally retired to...

Freight Train Construction is analyzing a proposed project. The company expects to sell 1 , 4 0 0 units, + - 2 percent. The expected variable cost per unit is $ 2 1 0 and the expected fixed costs are...

A research institute reports that 69% of workers reported that theyand/or their spouse had saved some money for retirement. Complete parts a and b below. a.If a random sample of 40 workers istaken,...

Werth Company produces tie racks. The estimated fixed costs for the year are $288,000, and the estimated variable costs per unit are $14. Werth expects to produce and sell 60,000 units at a price of...