Problem $1(30\%)$: Chapter $1$ Question $9.$ Recall the Top$-$Humid Company question. The LP model can be found in the solution to HW$1.$

$$ Implement the LP model for the Top$-$Humid company in Excel with well$-$defined data table, decision variables, constraints, and objective function.

$$ Use Solver to solve the LP model and generate an Answer Report and Sensitivity Report.

$$ What is the optimal solution and what is the optimal value? Put this in a textbox.