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 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.