A chemical company manufactures three chemicals: A.B, and C. These chemicals are produced via two production process: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 units of C. Running process 2 for an hour costs $100 and yields 100 units of A and 100 units of B. To meet customer demand, at least 1000 units of A, 500 units of B, and 300 units of C must be produced daily.
a. Use Solver to determine a daily production plan that minimizes the cost of meeting the company’s daily demands.
A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 2000 units of wood available.
a. Use Solver to maximize the company’s profit.
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.
a. Use Solver to help the farmer maximize the profit from his land.
- This solution has not purchased yet.
- Submitted On 22 Jun, 2017 02:46:27