Solved

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

Question 57

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.
 Crop  Profit per  Acre $) Yield per  Acre 1b)  Maximum  Demønd lb)  Imigation  acre ft)  Fertilizer  poundls/acre)  Corn 2,10021,000200,0002500 Pumpkin 90010,000180,0003400 Beans 1,0503,50080,0001300\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?
 Changing Cells \text { Changing Cells }
 Final  Rechiced Objective  Allowable Allowable  Cell  Name  Value  Cost  Coefficient  Increase  Decrease  $B $4  Acres of Corn 9.52021001E+30350 $C$4  Acres of Pumplin 0500.01899.99500.011E+30$D$4 Acres of Peans 107901050210375.00\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}

Correct Answer:

verifed

Verified

The allowa...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents