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

Yixuan is building a tower out of lego pieces for the

Yixuan is building a tower out of Lego pieces. For the bottom layer of the tower, he has 12 large Lego blocks to choose from. Each of these large blocks is a different color and he has decided to use 5 of them for the bo ...

Suppose you are a statistics consultant hired to study

Suppose you are a statistics consultant, hired to study whether a tax on alcohol has decreased average alcohol consumption in Australia. For a given sample of randomly selected individuals, you are able to obtain the dif ...

David currently has 500 in an account that earns 10 apr

David currently has $500 in an account that earns 10% APR, compounded monthly. Assuming he doesn't withdraw any of the funds, how much will his balance be in 6 years?

The average height of young adult males has a normal

The average height of young adult males has a normal distribution with standard deviation of 2.5 inches. You want to estimate the mean height of students at your college or university to within 0.6 inch with 93% confiden ...

A light bulb manufacturer guarantees that the mean life of

A light bulb manufacturer guarantees that the mean life of a certain type of light bulb is at least 720 hours. A random sample of 51 light bulbs as a mean of 710.3 hours with a standard deviation of 62 hours. At an α=0.0 ...

Suppose metal shafts produced have a standard deviation of

Suppose metal shafts produced have a standard deviation of 2.8 and a mean diameter of 210 inches. If 84 shafts are sampled at random, what is the probability that the mean diameter of the sample shafts would be less than ...

Follow up -lock box systems or regional collection

Follow Up -Lock Box Systems or Regional Collection Centers One way a business can speed up collections is Lock Box Systems or Regional Collection Centers. Explain how these can be used to speed up collections.

According to a study in a previous year 570 of households

According to a study in a previous year, 57.0% of households nationwide used natural gas for heating during a year. Recently, a survey of 2,700 randomly selected households showed that 58.0% used natural gas. Use a 0.05 ...

The statistical and regression questions are listed

The statistical and regression questions are listed below: What is the value of the simple correlation between TICKETS and COST? If you are able to determine the answer, is showing the film in more theatres associated wi ...

A random sample of 87 eighth grade students scores on a

A random sample of 87 eighth grade? students' scores on a national mathematics assessment test has a mean score of 278. This test result prompts a state school administrator to declare that the mean score for the? state' ...

  • 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