Ask Question, Ask an Expert

+61-413 786 465

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

1 three experiments investigating the relation between need

1. Three experiments investigating the relation between need for cognitive closure and persuasion were performed. Part of the study involved administering a "need for closure scale" to a group of students enrolled in an ...

At a college 66 of courses have final exams and 56nbsp of

At a college, 66 % of courses have final exams and 56 % of courses require research papers. Suppose that 45 % of courses have a research paper and a final exam.  Find the probability that a course has NONE of these two r ...

A researcher is working on a study that examines the

A researcher is working on a study that examines the wellbeing of older adults. She has an interest in finding if there is a difference in life satisfaction scores (measured on a multi-item Likert scale) by ethnicity (Af ...

Explain how the company newmans own brand fulfills the

Explain how the company Newman's Own brand fulfills the definition of a business for profit and a non-profit business at the same time. Consider in the response the functions of business, entrepreneurship and production ...

Approximately once a month cars are shipped from rotterdam

Approximately once a month cars are shipped from Rotterdam, Holland to Lagos, Nigeria. The past data collection indicates that the weight of a car is normally distributed with the mean of 1,070 kg and the  standard devia ...

Fifty-seven percent of employees make judgements about

Fifty-seven percent of employees make judgements about their co-workers based on the cleanliness of their desk. You randomly select 8 employees and ask them if they judge co-workers based on this criterion. The random va ...

Jen and barry perform a survey of consumers about home meal

Jen and Barry perform a survey of consumers about home meal salad preferences ("fresh" or "fast"). 395 consumers said they prefer to make fresh salad. 426 said they prefer to make salad fast (out of a bag). 331 said they ...

Calculate the rate of return available to shareholders for

Calculate the rate of return available to shareholders for a company financing $1 million of assets with the following three arrangements: i. all equity ii. 50 percent equity and 50 percent debt at an interest rate of 12 ...

Let a random sample be taken of size n 64 from a

Let a random sample be taken of size n = 64 from a population with a known standard deviation of 15. Suppose that the mean of the sample is 40. Find the 99% confidence interval for the mean of the population from which t ...

Given a trendline of y 5832x 135799 where the variable x

Given a trendline of y = 5832x + 135799, where the variable x represents the age of a home (in years) and the variable y represents its current market value (in dollars), use this trendline to predict the current market ...

  • 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