10 A farmer in Wood County has 900 acres of land. She is going to plant each acre with com, soy- beans, or wheat. Each acre planted with com yields a $2,000 profit; each with soybeans yields $2,500 profit; and each with wheat yields $3,000 profit. She has 100 workers and 150 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Assuming a lin- ear relationship, use Excel solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits.

Transcribed Image Text:

Labor (workers) Fertilizer(tons) CORN SOYBEANS WHEAT 2 0.1 03 0.2 02 1 04