### [solution] » A farmer is planning his spring planting. He has 20 acres on which he can plant a combination of

Description

The Question

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 perAcre (\$) Yield perAcre (lb) MaximumDemand (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 Analytic Solver Platform 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.52 0 2100 1E+30 350 \$C\$4 Acres of Pumpkin 0 ?500.01 899.99 500.01 1E+30 \$D\$4 Acres of Beans 10.79 0 1050 210 375.00

#### Solution details

Solution #00070173

##### [solution] » A farmer is planning his spring planting. He has 20 acres on which he can plant a combination of .zip

This paper was answered on 21-Sep-2019

STATUS

QUALITY

Approved

Sep 21, 2019

EXPERT

Tutor

#### BEST TUTORS

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.