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
2X + 3y > 60 4X +
2y > 80 X <24
x,y >0

Step by Step Solution

★★★★★

3.50 Rating (170 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 (986).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Consider a two-phase system that consists of liquid water in equilibrium with water vapour kept in a constant temperature bath. The volume of the system is increased reversibly, holding T and P...

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

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

219. 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 > 40 X-Y 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...

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

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

Does a monopolistic competitor produce more or less output as compared to an efficient level of production? Explain. What are the benefits and drawbacks of this? Should the government intervene to...

Potter Corporation is a private enterprise and has elected to use the immediate recognition approach to account for its defined benefit pension plan. The following information (in hundreds of...

Develop a general - purpose spreadsheet to calculate the balance due, principal payment, and interest payment for each payment period of a loan, assuming compounded monthly. The user inputs to the...

Exercise R Ryan Company takes a physical inventory at the end of each calendar-year accounting period. Its financial statements for the past few years indicate an average gross margin on net sales of...

1. Formulate an LP problem to determine what blend of the four chemicals will allow Golding to minimize the cost of a 50-pound bag of the fertilizer.Kenneth and Patricia Golding spent a career as a...

3. Discuss the plant layout.Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any technical knowledge about the manufacturing...

2. Discuss the need for temporary workers in the drawing department.Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any...

A Government of Canada bond has a 6 percent coupon which pays semi-annually and matures in 11 years. If the yield for similar bonds is 5.4 percent, what should be the price for this bond? (Assume...

What does the following code output? What hnec the followine rnde nuthut? abcd edcb ed edc

Convergence and the Conceptual Framework As an accounting professional, it is important to understand the historic development of accounting standards and specifically topics that are affected by the...