This preview shows pages 1–3. Sign up to view the full content.
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.
from his land.
*Data Needed
Wheat:
Corn:
Profit:
200
Profit:
300
Resources
Worker:
3
Worker:
2
Wheat
Corn
Fertilizer:
2
Fertilizer:
4
Worker
3
2
Acre:
20
Acre:
20
Fertilizer
2
4
*Limitations:
Acre
20
20
Worker:
100
Fertilizer:
120
Constraints on Resources
Acre:
45
Actual
Allowed
Worker
100
<=
100
Fertilizer
120
<=
120
Acre
40
>=
45
Profits Maximized
Profits =
$10,000.00
28.
A farmer in Iowa owns 45 acres of land. He is going to
a.
Use Solver to help the farmer maximize the profit
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentMicrosoft Excel 12.0 Answer Report
Worksheet: [Module 6 HW.xls]Problem# 28
Report Created: 9/12/2011 7:34:51 PM
Target Cell (Max)
Cell
Name
Original Value
Final Value
$K$33
Profit
$10,000.00
$10,000.00
Adjustable Cells
Cell
Name
Original Value
Final Value
$K$20
Wheat Acre
20
20
$L$20
Corn Acre
20
20
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '11
 PaulShriver

Click to edit the document details