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.

Crop

Profit per

Acre $($$$)$

Yield per

Acre $($lb$)$

Maximum

Demand $($lb$)$

Irrigation

$($acre ft$)$

Fertilizer

$($pounds$/$acre$)$

Corn

$2,100$

$21,000$

$200,000$

$2$

$500$

Pumpkin

$900$

$10,000$

$180,000$

$3$

$400$

Beans

$1,050$

$3,500$

$80,000$

$1$

$300$

Based on the following Risk Solver Platform $($RSP$)$ sensitivity output, how much can the price of Corn drop before it is no longer profitable to plant corn?

Changing Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$B$$4$

Acres of Corn

$9\mathrm{.}52$

$0$

$2100$

$1$E$+30$

$350$

$C$$4$

Acres of Pumpkin

$0$

$500\mathrm{.}01$

$899\mathrm{.}99$

$500\mathrm{.}01$

$1$E$+30$

$D$$4$

Acres of Beans

$10\mathrm{.}79$

$0$

$1050$

$210$

$375\mathrm{.}00$

$350$

$1750$

$2000$

$0$