Share
Explore BrainMass

Use excel solver to find solution for LP problems

A farmer's family is making plans for the year's planting. Its members are considering planting corn, tomatoes, potatoes, and strawberries. They have 50 acres to plant on. The aim is to determine what it costs to plant an acre of each crop, computing the yield in bushels, forecasting the revenue for a bushel of each crop, and choosing the combination of crops that will yield the most profit. The data they have collected, along with the availability of resources, is shown in the table.

a)a) Determine the best mix of crops to maximize their revenue.

b) The farmers also have the opportunity to buy a 78-acre farm adjacent to their land. They would like to narrow their selection of crops to corn, strawberries, or a combination of the two. If they acquire the land, they will be able to increase the time available to 1,800 hours for planting, 825 hours for tending, and 1,400 hours for harvesting. All these increases are from the available limits in part (a). Between the two farms, there is 510 acre-feet of water available for the season. The farmers can obtain up to 7,000 pounds of fertilizer. The new farm has not been cultivated in a while, so the farmers believe that each acre of the new farm will take an extra 4 hours of labor to plant, and an extra 2 hours per acre to tend. Because of the condition of the new farm, they expect the yields to be down from 50 to 45 bushels per acre for corn and from 56 to 50 bushels per acre for strawberries. They want to know the best combination of crops to plant on each farm, with the goal to maximize revenue from at least 75% of each farm's acreage.

Attachments

Solution Summary

The solution provides detailed explanation how to find maximal or minimal values by using excel solver.

$2.19