Question Details

[solution] »

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


Description

Answer Download


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 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 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

  • © 2016 Microsoft
  • Terms
  • Privacy & cookies
  • Developers
  • English (United States)

 

 


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

Uploaded by: Tutor

Answer rating:

This paper was answered on 21-Sep-2019

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 21, 2019

EXPERT

Tutor

ANSWER RATING

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.

STUCK WITH YOUR PAPER?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now