Question: please solve with excel gragh 1) Use the graphical method to solve the problem: Maximize Z=10x1+20x2 subject to x1+2x215x1+x2125x1+3x245 and x10,x20. a) Plot a graph

please solve with excel gragh

1) Use the graphical method to solve the problem: Maximize Z=10x1+20x2 subject to x1+2x215x1+x2125x1+3x245 and x10,x20. a) Plot a graph and show the feasible region (manually solve). b) Use solver and find an optimal solution. 2) The following table summarizes the key facts about two products, A and B, and the resources, Q,R, and S, required to produce them. (a) Formulate a linear programming model for this problem. (b) Plot the graph manually and show feasible region. C) Solve this model using excel solver

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

Using Simplex method Question 4.1.2 By hand please PROBLEMS The symbols to the left of some of the problems for their parts) and have the following meaning: x 20. *320 D. The corresponding...

Question 4.1.2 Using complex method PROBLEMS The symbols to the left of some of the problems for their parts) and have the following meaning: x 20. *320 D. The corresponding demonstration cxample...

Using semlex method Question 4.1.2 By hand please PROBLEMS The symbols to the left of some of the problems for their parts) and have the following meaning: x 20. *320 D. The corresponding...

Set up and solve this word problem : A cat breeder has 90 ounces (oz) of tuna, 80 ounces of liver, and 50 ounces of chicken. A Siamese cat requires 2 oz of tuna, 1 oz of liver, and 1 oz of chicken...

Problem 1 : Gear Up wants to maximize their profits by determining the optimal production quantities for their two most popular backpacks: The ( H ) and the Climber ( C ) . Data: Profit per backpack:...

PLEASE SHOW ALL YOUR WORK AND GRAPH . IDENTIFY ALL VARIABLES AS WELL LINEAR PROGRAMMING EXAM-APPLICATION PROBLEMS 1) The Denver advertising agency promoting the new Breem dishwashing detergent wants...

Please show me all stpes and expalin how you get them. you need to solve this using excel.include scrren shots too. use exact "graphical method and Excel solver" 1. Linear Programming In lectures we...

Can I have help with questions 18 and 19 please!! Thank you!! this is for math modeling Brooklyn to Manhattan and $2 to ship a tablet from Brooklyn to Amityville . It cost and $2 to ship a tablet...

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

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Classical Electron Spin (a) If you treat an electron as a classical spherical object with a radius of 1.0 x 10-17m, what angular speed is necessary to produce a spin angular momentum of magnitude h?...

A 48-year-old man is admitted to hospital because of stupor. He is unkempt and homeless and lives in an encampment with other homeless people who called the authorities when he could not be easily...

Which of the following is correct? Multiple Choice The value ( in dollars ) of a call option on 5 , 0 0 0 with a strike price of $ 1 0 , 0 0 0 is equal to the value ( in dollars ) of a put option on...

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

3. Describe the three parts of an interview: opening, questions, and conclusion

1. Define the nature of interviews

2. Outline the different types of interviews