Question: Formulate a linear programming model and solve with Solver. SHOW ANSWER USING EXCEL AND SOLVER ONLY. A farm consists of 600 acres of land, of
Formulate a linear programming model and solve with Solver. SHOW ANSWER USING EXCEL AND SOLVER ONLY.
- A farm consists of 600 acres of land, of which 500 acres will be planted with corn, soybeans, and wheat, according to these conditions:
- At least half of the planted acreage should be corn.
- No more than 200 acres should be soybeans
- The ratio of corn to wheat planted should be 2:1
It costs $20 an acre to plant corn, $15 an acre to plant soybeans, and $ 12 an acre to plant wheat.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
