A Farmer Is Planning His Spring Planting Based on the Following Analytic Solver Platform Sensitivity Output,how Much

Essay

A farmer is planning his spring planting.He has 20 acres on which he can plant a combination of Corn,Pumpkins and Beans.He wants to maximize his profit but there is a limited demand for each crop.Each crop also requires fertilizer and irrigation water both of which are in short supply.The following table summarizes the data for the problem.
$\begin{array}{r|rcccc}\text { Crop } & \begin{array}{c}\text { Profit per } \\\text { Acre } \$)\end{array} & \begin{array}{c}\text { Yield per } \\\text { Acre 1b) }\end{array} & \begin{array}{c}\text { Maximum } \\\text { Demønd lb) }\end{array} & \begin{array}{c}\text { Imigation } \\\text { acre ft) }\end{array} & \begin{array}{c}\text { Fertilizer } \\\text { poundls/acre) }\end{array} \\\hline \text { Corn } & 2,100 & 21,000 & 200,000 & 2 & 500 \\\text { Pumpkin } & 900 & 10,000 & 180,000 & 3 & 400 \\\text { Beans } & 1,050 & 3,500 & 80,000 & 1 & 300\end{array}$

Based on the following Analytic Solver Platform sensitivity output,how much can the price of Corn drop before it is no longer profitable to plant corn?
$$\text { Changing Cells }$$
$\begin{array}{rrrrrrr}&&\text { Final } & \text { Rechiced} & \text { Objective } & \text { Allowable} & \text { Allowable }\\\text { Cell } & \text { Name } & \text { Value } & \text { Cost } & \text { Coefficient } & \text { Increase } & \text { Decrease } \\\hline \text { \$B \$4 } & \text { Acres of Corn } & 9.52 & 0 & 2100 & 1 \mathrm{E}+30 & 350 \\\text { \$C\$4 } & \text { Acres of Pumplin } & 0 & -500.01 & 899.99 & 500.01 & 1 \mathrm{E}+30 \\\$ D \$ 4 & \text { Acres of Peans } & 1079 & 0 & 1050 & 210 & 375.00\end{array}$