Solved

A Farmer Is Planning His Spring Planting Based on the Following Risk Solver Platform (RSP) Sensitivity Output

Question 43

Short Answer

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.
 Crap  Profitper  Acre (  Yied per  Acre (lb)  Meximum  Denand (lb)  Irripation  (acreft)  Fetilize  (pounds/are)  Carm 2,10021,000200,0002500 pumplin 90010,000180,0003400 Beans 1,0503,50080,0001300\begin{array} { l | c c c c c } \text { Crap } & \begin{array} { c } \text { Profitper } \\\text { Acre ( }\end{array} & \begin{array} { c } \text { Yied per } \\\text { Acre (lb) }\end{array} & \begin{array} { c } \text { Meximum } \\\text { Denand (lb) }\end{array} & \begin{array} { c } \text { Irripation } \\\text { (acreft) }\end{array} & \begin{array} { c } \text { Fetilize } \\\text { (pounds/are) }\end{array} \\\hline \text { Carm } & 2,100 & 21,000 & 200,000 & 2 & 500 \\\text { pumplin } & 900 & 10,000 & 180,000 & 3 & 400 \\\text { Beans } & 1,050 & 3,500 & 80,000 & 1 & 300\end{array} 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 Calls  Cell  Name  Final  Value  Reduced  Cost  Objective  Caefficiant  Allowable  Inerease  Allowable  Decrease  $8$4  Acres of Carm 9.52021001E+30350$C$4 Acres of Pumplan 0500.01899.99500.011E+30 D$4  Acres of Beans 10.7901050210375.00\begin{array}{l}\text { Changing Calls }\\\begin{array} { l l r r r r r } \text { Cell } & \text { Name } & \begin{array} { r } \text { Final } \\\text { Value }\end{array} & \begin{array} { r } \text { Reduced } \\\text { Cost }\end{array} & \begin{array} { r } \text { Objective } \\\text { Caefficiant }\end{array} & \begin{array} { r } \text { Allowable } \\\text { Inerease }\end{array} & \begin{array} { r } \text { Allowable } \\\text { Decrease }\end{array} \\\hline \text { \$8\$4 } & \text { Acres of Carm } & 9.52 & 0 & 2100 & 1 \mathrm { E } + 30 & 350 \\\mathbf { \$ C \$ 4 } & \text { Acres of Pumplan } &0& - 500.01 & 899.99 & 500.01 & 1 \mathrm { E } + 30 \\\text { D\$4 } & \text { Acres of Beans } & 10.79 &0 & 1050 & 210 & 375.00\end{array}\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