Excel Solver linear program

Alf is this the same as the previous problem
A Dow chemical company produces three types of industrial solvents, Solvent 1, Solvent-2, and SolventS-3. The profits per thousand gallons for the three solvents are $4300, $5500, and $9800 respectively. The production process requires blending and purification. It also requires additional labor for handling the finished products. The company has 260 hours of blending, 300 hours of purification, and 160 labor hours available. The requirements for each solvent are shown in the table below:


1. Formulate a linear program that can be used to determine the optimal product mix for the chemical company. Specifically, do the following: Identify the decision variables (make sure that you specify the units for these variables). Specify the objective function and the relevant constraints.



2. The production manager uses a DSS to obtain the optimal production mix. For this optimal product mix, 250 hours of blending, 300 hours of purification, and 160 hours of labor are required. The maximum attainable profit is $62,000. Develop a simple DSS prototype to solve this production planning problem and to confirm the optimal solutions. How many gallons of Solvent 1, Solvent-2, and SolventS-3 are produced under this optimal product mix?


3. Perform sensitivity analysis to determine how much should the manager be willing to
pay for:
(a) an additional hour of blending;
(b) an additional hour of purification;
(c) an additional hour of labor.

I am stuck, will you attach the spreadsheet to help

?????

In my old post from 2010 you will find an uploaded workbook plus a walkthrough of this problem and you still say you are stuck!

If what I did and said 2010 don’t make sense to you then I hardly think that whatever I can say and do today would make more sense.

By the way maximum profits is now $72 2000 instead of $62 000 based on the “new” solvent profits. You better tell your teacher as he / she forgot to update this value.

Alf