Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Statistics and Probability Expert

A farmer in Georgia has a 100-acre farm on which to plant watermelons and cantaloupes. Every acre planted with watermelons requires 50 gallons of water per day and must be prepared for planting with 100 pounds of fertilizer in the whole growing season. Every acre planted with cantaloupes requires 75 gallons of water per day and must be prepared for planting with 80 pounds of fertilizer in the whole growing season. The farmer estimates that it will take 2 hours of labor to harvest each acre planted with watermelons and 2.5 hours to harvest each acre planted with cantaloupes. He believes that watermelons will sell for $3 each, and cantaloupes will sell for $1 each. Every acre planted with watermelons is expected to yield 90 salable units. Every acre planted with cantaloupes is expected to yield 300 salable units. The farmer can pump about 6,000 gallons of water per day for irrigation purposes from a shallow well. He can buy as much fertilizer as he needs at a cost of $0.5 per pound. Finally, the farmer can hire laborers to harvest the fields at a rate of $15 per hour. If the farmer sells all the watermelons and cantaloupes he produces, how many acres of each crop should the farmer plant to maximize profits?

a. Formulate the LP model and generate its sensitivity report.

b. If the unit price of watermelon increases from $3 to $4, is our current solution still optimal? Use your calculation to describe.

c. If the labor cost per hour increases from $15 to $20, (unit price of water melon is still $3), is our current solution still optimal? Use your calculation to describe. (Hint: you may need to apply the 100% rule we introduced in class.)

d. Assume the unit price of watermelon and labor costs remain unchanged. The farmer is now considering planting muskmelons on the farm. If one acre planted with muskmelons requires 40 gallons of water per day and must be prepared for planting with 70 pounds of fertilizer. Each acre can yield 150 salable units at $2/unit and it takes 3 hours of labor to harvest. Would it be profitable to plant muskmelons? Use your calculation to describe. (Only use the information from your existing sensitivity report. Do not formulate a new model in the spreadsheet.)

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M998396

Have any Question? 


Related Questions in Statistics and Probability

A shipment contains 11 tvs of which two are defective a

A shipment contains 11 TV's, of which two are defective. A sample of three TV's is selected at random. In how many ways can no defective TV's be chosen?

Te height of woman ages 20-29 is normally distributed

The height of woman ages 20-29 is normally distributed , with a mean of 64.3 inches. assuming the standard diviation = 2.4 inches. are you more likely to randomly select 1 woman with a height less than 66.2 inches or are ...

What are the uses and value of statistical significance

What are the uses and value of statistical significance testing and the p-value as demonstrated in the various analytical techniques (t-tests, ANOVA, chi-square, etc.). What's the fundamental reason we apply these techni ...

A few years ago simon powell purchased a home for 250000

A few years ago, Simon Powell purchased a home for $250,000. Today, the home is worth $450,000. His remaining mortgage balance is $200,000. Assuming that Simon can borrow up to 70 percent of the market value, what is the ...

A what is the purpose of credit analysis discuss the

(a) What is the purpose of credit analysis? Discuss the importance of performing a credit analysis if you are suppliers of credit (i.e., commercial banks, non-bank private financing entities).

A 20-year canada bond with an 8 semi-annual coupon is

A 20-year Canada bond with an 8% semi-annual coupon is currently selling at par ($1,000) and the probability distribution of its yield to maturity (YTM) a year from now is as follows: State of Economy Probability YTM (%) ...

How would i calculate this to get the probability if a

How would I calculate this to get the probability. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You ...

Suppose you believe that johnson companys stock price is

Suppose you believe that Johnson Company's stock price is going to increase from its current level of $22.50 sometime during the next 6 months. For $250.30 you can buy a 6-month call option giving you the right to buy 10 ...

You are working for a large corporation and oversee a

You are working for a large corporation and oversee a marketing research project. For this study, your questionnaire length is 10 minutes and the incidence is 35%, yielding a CPI is $23.00. Your company requires all rese ...

If we are interested in job satisfactionname a variable

If we are interested in job satisfaction. Name a variable that correlates with job satisfaction but we do not have causation. Name a variable that you believe may have a casual relationship with job satisfaction. Name a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As