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

Twelve different video games showing substance use were

Twelve different video games showing substance use were observed and the duration of times of game play? (in seconds) are listed below. The design of the study justifies the assumption that the sample can be treated as a ...

Assume the probability of a male being lt 21 is 1867 the

Assume the probability of a male being 50 is 4.80%, and the probability of being female and > 50 is 8.00%. Based on this information and the information in the tables above, what is the probability that someone

Based on labornbspstatisticsnbsp12 nbspof workers in a

Based on labor? statistics, 12 % of workers in a particular profession are male. Complete parts a through e below based on a random sample of 8 workers in this profession. a.  What is the probability that exactly one wor ...

Suppose you believe that du ponts stock price is going to

Suppose you believe that Du Pont's stock price is going to decline from its current level of $82 sometime during the next 5 months. For $5.25 you could buy a 5-month put option giving you the right to sell shares at a pr ...

Suppose a sampling space has things a b and c twice draw

Suppose a sampling space has things a, b, and c. Twice draw from the sample space and replace. The possible sequence formed are {aa,ab,ac,ba,bb,bc,cacb,cc}. Now suppose there are Y different things. There are Y ways the ...

New york graduates tend to leave the state after graduating

New York graduates tend to leave the state after graduating. A study asked the students of NYU "Are you planning to stay in NY after graduation?" In the sample, only 37% answered yes. The study explained that with a 95% ...

Deyoung entertainment enterprises is considering replacing

DeYoung Entertainment Enterprises is considering replacing the latex molding machine it uses to fabricate rubber chickens with a newer, more efficient model. The old machine has a book value of $450,000 and a remaining u ...

Parents who did not finish high school have sat math scores

Parents who did not finish high school have SAT math scores X with mean 451 and standard deviation 103. Scores Y of children of parents with graduate degrees have mean 567 and standard deviation 104. Perhaps we should st ...

Would you actually build a contingency chart for this

Would you actually build a contingency chart for this question or is this just probability basics? Bob sets two battery powered alarm clocks to make sure he wakes up in time for his 8 AM accounting test. Each alarm clock ...

Monroe inc is evaluating a project the company uses 138

Monroe, Inc, is evaluating a project. The company uses 13.8 percent discount rate for this project. cost and cash flows are shown in the table. What is the NPV of the project? year. Project 0. ($11,368,000) 1. $2,187,590 ...

  • 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