As discussed in class, there is an Excel project in which you will solve three linear programming problems using Solver. This discussion refers to either the 2010 or 2016 version of Excel in which Solver is an add-in.

To access the standard Solver add-in that comes with Excel, you may have to load it from a list of available add-ins. If this has been done already, then just click on the Data tab at the top and Solver should appear on the right side in a box referring to Analysis.

To load the Solver add-in if necessary, click the circular button (or file tab on the 2010 version) in the upper left corner. Then click on Excel options at the bottom of that window. Then click on Add-ins on the left side. Then click "go" at the bottom. Check the box next to the Solver add-in at the bottom of the list of available add-ins by clicking on it. Then click ok. If prompted, click yes to install it.

The assignment:

With Solver, in the same manner as was illustrated in the class demonstration, rework solutions to my class example (where P = 6x + 4y), and the two homework problems we did previously using the graphical method.

You will print out to submit three items for each of the three problems: 1/ The spreadsheet where you set up the given data; 2/ the answer report; and 3/ the sensitivity report.

The sensitivity report should enable you to indicate the range of hours over which the shadow prices are valid as was discussed in class. Please do for the class example (where P = 6x + 4y) and write it on the sensitivity report. You need not do for the other two problems.

x No. to make Unit profits constraints cutting finding packaging y 45 6 45 total profit 4 450 used 3 1 2 1 2 2 available 180 180 135 160 180 180 given constraints cutting finding packaging x y 3 1 2 max capacity constraints 1 180 3x+y180 2 160 x+2y160 2 180 2x+2y180 x0 y0 P=6x+4y LP Graphical H.W. 1. A company produces two industrial products, x and y, that require wiring and testing during the assembly process. Each unit of x requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each unit of y requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next production period. To maximize profit, 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 ST 250 X1 + 150 X2 2 X1 + 3 X2 260 1 X1 + 2 X2 140 X1, X2 0 MAX ST 250 X1 + 150 X2 2 X1 + 3 X2 260 1 X1 + 2 X2 140 X1 20 X2 20 2./