Question: Answer for total profit please. Problem A-10 A farmer in Wood County has 900 acres of land. She is going to plant each acre with

Answer for total profit please.

Answer for total profit please. Problem A-10 A

Problem A-10 A farmer in Wood County has 900 acres of land. She is going to plant each acre with corn, soybeans, or wheat. Each acre planted with corn yields a $2,050 profit; each with soybeans yields $2,400 profit; and each with wheat yields $2,800 profit. She has 292 workers and 107 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Labor (workers) Fertilizer (tons) CORN SOYBEANS WHEAT 0.4 0.1 0.1 0.1 0.2 0.3 Assuming 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" wherever required. Round your answer to the nearest whole number.) 681 189 Acres planted with corn Acres planted with soybean Acres planted with wheat Total profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!