I HAVE ATTACHED THE PROBLEM AND SOLUTION I NEED THE SPREADSHEET. ANSWER REPORT. AND SENSITIVITY REPORT.

As discussed in class, there is an Excel project in which you will solve this linear programming problem 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, for PCs, click the file tab 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. For Apple computers, click on "tools" and then on add-ins at the bottom of the drop-down menu. The process after that is very similar to the above instructions to complete the installation.

The assignment:

With Solver, in the same manner as was illustrated in the class demonstration, rework solutions to my class example.

You will print out to submit 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.

PROBLEM:

1. A company M 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 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 \f