A Farmer Is Planning His Spring Planting Based on the Following Risk Solver Platform (RSP) Sensitivity Output
Question 43
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 Carm pumplin Beans Profitper Acre ( 2,1009001,050 Yied per Acre (lb) 21,00010,0003,500 Meximum Denand (lb) 200,000180,00080,000 Irripation (acreft) 231 Fetilize (pounds/are) 500400300 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 $8$4 $C$4 D$4 Name Acres of Carm Acres of Pumplan Acres of Beans Final Value 9.52010.79 Reduced Cost 0−500.010 Objective Caefficiant 2100899.991050 Allowable Inerease 1E+30500.01210 Allowable Decrease 3501E+30375.00
Correct Answer:
Verified
The allowa...
View Answer
Unlock this answer now Get Access to more Verified Answers free of charge