(Solved) A farmer in Iowa 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
Question:
A farmer in Iowa 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 $300 profit, requires 2 workers, and requires 4 tons of fertilizer. One hundred workers and 120 tons of fertilizer are available.
Use Excel's Solver to help the farmer maximize the profit from his land.
Deliverable: Word Document 