Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started