1. Use the file BlubberMaid.xls and Solver in Excel to solve the problem of BlubberMaid in your class lecture notes. Interpret the solution (including slack variables), and optimal objective function value in the context of the original problem. (5 points)

blubbermaid data:

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|l|}{ Data } \\ \hline & Airtex & Extendex & Resistex & Available & \\ \hline Polymer A & 4 & 3 & 6 & 8000 & \\ \hline Polymer B & 2 & 2 & 3 & 6800 & \\ \hline Polymer C & 4 & 2 & 5 & 10400 & \\ \hline Base & 6 & 9 & 2 & 17600 & \\ \hline Profit & 7 & 7 & 6 & & \\ \hline Demand & 1000 & 500 & 400 & & \\ \hline & & & & & \\ \hline \multicolumn{6}{|l|}{ Model } \\ \hline & Airtex & Extendex & Resistex & & Profit \\ \hline Variables & 1 & 2 & 3 & & 39 \\ \hline \multirow{2}{*}{\multicolumn{6}{|c|}{ Constraints }} \\ \hline & & & & & \\ \hline & & & & & \\ \hline Resource & Ihs & rhs & & & \\ \hline Polymer A' & 28 & 8000 & & & \\ \hline Polymer B & 15 & 6800 & & & \\ \hline Polymer C & 23 & 10400 & & & \\ \hline Base & 30 & 17600 & & & \\ \hline \multirow{4}{*}{ Demand } & & & & & \\ \hline & 1 & 1000 & & & \\ \hline & 2 & 500 & & & \\ \hline & 3 & 400 & & & \\ \hline \end{tabular}