Question: i Saved ar program... Help Submit Save & Exit A farmer in Wood County has 900 acres of land. She is going to plant each

i Saved ar program... Help Submit Save & Exit A

i Saved ar program... Help Submit Save & Exit 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 "O" wherever required. Round your answer to the nearest whole number.) Acres planted with corn Acres planted with soybean Acres planted with wheat Total profit Resources Used Labor (workers) Fertilizer (tons) Acres planted

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!