# Problem A-10A farmer in Wood County has 900 acres of land. She is going to plant each acre with corn, soybeans, orwheat. Each acre planted with corn yields a \$2,000 profit; each with soybeans yields \$2,500 profit; andeach with wheat yields \$3,000 profit. She has 100 workers and 150 tons of fertilizer. The table below showsthe requirement per acre of each of the cropsCORN SOYBEANS WHEATLabor (workers)Fertilizer (tons)0.10.30.20.20.10.4Assuming a linear relationship, use the Excel Solver to determine the optimal planting mix of corn,soybeans, and wheat to maximize her profits. (Leave no cells blank - be certain to enter "0" whereverrequired. Round your answer to the nearest whole number.)Decision for cornDecision for soybeansDecision for wheatTotal profit\$ResourcesUsedLabor (workers)Fertilizer (tons)Acres Planted

Question
12 views
check_circle

Step 1

Determine the optimal solution:

C refers to corn, S refers to soybeans, and W refers to wheat.

Step 2

Formulae to solve the prob...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in