Sensitivity Report

Answer Two Parts: Explain your reasoning referencing shadow price, reduced cost, range of feasibility, range of optimality, etc. if/when appropriate.

a) Two more acres of the 12 acres can be converted to produce peppers at a cost of $20,000. Should they make the conversion?

b) The nearby community college wants to rent a 2-acre greenhouse for $35,000 per year. Should they do it? Why or why not?

Adustable Cells \begin{tabular}{ccrrrrrr} \hline Cell & Name & FinalValue & ReducedCost & ObjectiveCoefficient & AllowableAllowableIncrease & AllocreaseDecres \\ \hline SBS9 & Acres Planted Peppers & 4 & & 0 & 30000 & 10000 & 10000 \\ \hline SC59 & Acres Planted Tomotoes & 8 & & 0 & 40000 & 20000 & 10000 \\ \hline \end{tabular} Constraints \begin{tabular}{lrrrrrr} \hline Cell & Name & FinalValue & ShadowPrice & ConstraintR.H.Side & AllowableAllowableIncrease \\ \hline SBS14 Land LHS & 12 & 20000 & 12 & 1 & 2 \\ DB515 Labor LHS & 30 & 6665.666667 & 30 & 6 & 3 \\ \hline SB516 Max Pepper LHS & 4 & 0 & 6 & 1E+30 & 2 \\ \hline \end{tabular}