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, 2016, or 2019 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 (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 this for the class example (where P = 6x + 4y) and write it on the sensitivity report. You need not do this for the other two problems