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

solve this linear programming problem using Solver. This 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.

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.

The sensitivity report should enable you to indicate the range of hours over which the shadow prices are valid as was discussed in class write it on the sensitivity report.

No. to make Unit prots constraints cutting nding packaging 45 H 45 total prot 4 1 2 2 used 450 180 135 180 available 180 160 180