Explore BrainMass

# Linear Programming: Maximize Planting

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A farmer in Lowa owns 45 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields \$200 profit, requires 3 workers, and requires 2 tons of fertilizer; each with corn yields a \$300 profit, requires 2 workers, and requires 4 tons of fertilizer. One hundred workers and 120 tons of fertilizer are available. Use solver to help the farmer maximize the profit from his land.

#### Solution Preview

See the Excel file attached for proper formatting.

Let W= Acres land planted with Wheat
C= ...

#### Solution Summary

This solution uses Excel to solve this maximization problem and the Excel document is attached to this posting. By clicking directly onto the cells of the spreadsheet, it clearly indicates how the derived value has been reached.

\$2.49