APPLIES TO QUESTION 2 ONLY.

solve this linear programming problem using Solver. either the 2010 or 2016 version of Excel in which Solver is an add-in.

The assignment:

With Solver, rework solutions

You will need three items :

1) The spreadsheet where you set up the given data;

2) the answer report

3) the sensitivity report.

I HAVE ATTACHED THE PROBLEM AND SOLUTION I NEED THE SPREADSHEET. ANSWER REPORT. AND SENSITIVITY REPORT FOR QUESTION NUMBER 2.

PROBLEM:

LP Graphical H.W. 1. A company M industrial products, 1; and y, that require wiring and testing during the assembly process. Each unit of 3; requires 2 hours of wiring and 1 hour of testing and can he sold for a $250 prot. Each unit of y requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 prot. There are 260 hours of wiring time and 140 hours of testing time available in the next production period. To maximize prot, formulate an LP model for this problem and solve it for the optimal solution using the graphical method 2. Refer to ex. 1. What if the management of the company decides that it needs to produce at least 20 units of x and 20 units of y? Reformulate the model and solve for the optimal solution using the graphical method. 1./ MAX 250 X + 150 X, ST 2X1 +3 X, S 260 1X +2X, S 140 X, X, 20 X, T 200- 150_ increasing objective 100- 2X,+3X,=260 X,+2X2=140 (0,70) obj=10500 (100,20) 50- obj=28000 (130,0) obj = 32500 (optimal solution) 50 100 150 200 250 X 2./ MAX 250 X1 + 150 X2 ST 2X1 + 3 X2 s 260 1 X1 + 2X2 s 140 X12 20 X2 2 20 X, 1 100- X, =20 (20,60) 75- obj=14000 2X,+3X2=260 X,+2X2=140 50- (100,20) obj = 28000 (optimal solution) X,=20 25- (20,20) obj=8000 25 50 75 100 125