Question: Solve the following LP problem by using the graphical procedure and by using Excel: Minimize cost = 4X + 7 Y Subject to the constraints

Solve the following LP problem by using the graphical procedure and by using Excel:
Minimize cost = 4X + 7 Y
Subject to the constraints
3X + 6y > 100
10X + 2y > 160
2y > 40 2X<75
x,y >0

Step by Step Solution

★★★★★

3.40 Rating (163 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 (988).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

Minimize 3x + y subject to the constraints x + y2 3 2x (x z 0, yz 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 by using the graphical procedure and by using Excel: Minimize cost = 4X + 7 Y subject to the constraints 2X + 3y > 60 4X + 2y > 80 X 0

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

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

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

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

Please solve and answer question fully. 5. 2-17 Solve the following LP problem by using the graphical procedure and by using Excel: Minimize cost = 3X +7Y subject to the constraints 9X+3Y > 36 4X +5Y...

Al, Bob and Cam form an equal partnership as a limited liability company, ABC, LLC, where they are all entitled to one-third of all income and loss from the operations of the business. The business...

Evaluate the kinetic energy of the particle with wave function given in Problem 8.18.

How can your spending habits be altered to ensure that you will be able to afford appropriate home and motor vehicle insurance coverage?

Exercise P Use the data in the previous exercise to compute the cost of the ending inventory using the LCM method applied to the total inventory.

38 The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines during the fabrication process. After fabrication,...

37 Cattle are sent to a feedlot to be grain-fed before being processed into beef. The owners of a feedlot seek to determine the amounts of cattle feed to buy so that minimum nutritional standards are...

36 The size of the yield of olives in a vineyard is greatly influenced by a process of branch pruning. If olive trees are pruned, trees can be planted more densely, and output is increased. (However,...

The Green Corporation has ending inventory of $481,060, and cost of goods sold for the year just ended was $4,016,851. What is the inventory turnover? (Do not round intermediate calculations. Round...

Value of an annuity versus a single amount Personal Finance Problem Assume that you just won the state lottery. Your priee can be taken either in the form of $96,000 at the end of each of the next 20...

A company has total assets of $549,000, current assets of $49,000, current liabilities of $101,000, long-term debt of $209,000, and net income of $61,000. What is the company's return on assets?...