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

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

3X + 6 y < 32 7X+ Y 3 XY >0

Step by Step Solution

★★★★★

3.42 Rating (158 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 (983).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

Solve the following LP problem graphically using level curves. MIN: 2X1 + 3X2 Subject to: 2X1 + 1X2 3 4X1 + 5X2 20 2X1 + 8X2 16 5X1 + 6X2 60 X1, X2 0

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

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

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

Solve the following LP problem by using the graphical procedure and by using excel: Maximize Profit = 2X+Y Subject to the constraints 3X+6Y = = 3 X,Y >= 0 Only do the graphical...

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

-16. Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit =4X+5Y subject to the constraints 5X+2Y3X+6YX2XYX,Y4030730

Find the center, the vertices, and the foci of the ellipse. Then draw the graph. a. 9x2 + 16y2 = 144 b. (x + 1)2/4 + (y - 2)2/9 = 1

The nucleoside vidarabine (ara-A) shows promise as an antiviral agent. Its structure is identical with that of adenosine (Section 27.24) except the D-arabinose replaces D-ribose as the carbohydrate...

Let the number of phone calls received by a switchboard during a 5-minute interval be a random variable X with probability function f(x) = e22x x! , for x = 0, 1, 2,.... (a) Determine the probability...

Problem B An examination of the financial records of Lanal Company on 2009 December 31, disclosed the following with regard to merchandise inventory for 2009 and prior years: 2005 December 31,...

6 An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic testing equipment, as shown in the...

5 A furniture maker sells three different styles of cabinets, including an Italian model, a French Country model, and a Caribbean model. Each cabinet produced must go through three departments:...

3 A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than...

You have taken a job as an entry-level analyst, and your boss has asked you to find the expected value of Dual Purposes Products Co.'s stock. As you were doing your research, you found out that Dual...

1. Which of the following is NOT a deep level diversity characteristic? Select one: a. Honesty b. Relational listening style c. Narcissism d. Tolerance for ambiguity e. Age 2. Faultline strength has...

Determine the monthly payment and interest payment for a 1 5 - year mortgage when the amount financed is 9 5 0 0 0 amd the annaul percentage rate is 8 . 0 percent The monthy prinicple and interest...