Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Max 12X1+18X2+15X3 s.t. 5X1+4X2+3X3160 minutesMachine constraint 4X1+10X2+4X3288 hoursLabor constraint 2X1+2X2+4X3200 pounds3 constraint X216 unitsProduct 2 constraint Xi=quantity of product i to make, i=1,2,3. (Note: You

Max 12X1+18X2+15X3 s.t. 5X1+4X2+3X3160 minutesMachine constraint 4X1+10X2+4X3288 hoursLabor constraint 2X1+2X2+4X3200 pounds3 constraint X216 unitsProduct 2 constraint Xi=quantity of product i to make, i=1,2,3. (Note: You will need to use Excel Solver for this problem and copy/paste Excel parts to the Word. For the Sensitivity questions, you do not resolve the problem. You will use Sensitivity Report and explain based on the Report. Do not forget to copy/paste the Sensitivity Report to the Word when explaining). Find the optimal solution to this LP problem. Are any constraints binding? If so, which one(s)?If the profit on product 3 were changed to $22 a unit, what would the values of the decision variables be? The objective function? Explain. If the profit on product 1 were changed to $22 a unit, what would the values of the decision variables be? The objective function? Explain. If 10 hours less of labor time were available, what would the values of the decision variables be? The objective function? Explain If the manager decided that as many as 20 units of product 2 could be produced (instead of 16), how much additional profit would be generated? If profit per unit on each product increased by $1, would the optimal values of the decision variables change? Explain. What would the optimal value of the objective function be

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

General Managers In Action Policies And Strategies

Authors: Francis Joseph Aguilar

2nd Edition

0195073673, 978-0195073676

More Books

Students also viewed these General Management questions

Question

assist me with an Overview of Life Cycle Management of clay bricks

Answered: 1 week ago