For this assignment, submit one Excel file.
1. Rename sheet to Part-1. Then use Part-1 to answer this question.
A furniture company manufactures desks and chairs. Each desk uses four units of wood and three hours of labor. Each chair uses three units of wood and one hour of labor. A desk contributes $400 to profit, and a chair contributes $250. There are at most 1,000 labor hours available. There are 2000 units of wood available.Use Solver to maximize the company's profit.
2. Insert a new sheet. Rename this sheet to Part-2. Then use Part-2 to answer this question.
A farmer in Iowa owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers, and requires two tons of fertilizer.
Each acre planted with corn yields $3000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available. Use Solver to help the farmer maximize the profit from his land.