Operations Management Appendix A

Question 3 Part 2

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,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 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 answers to the nearest whole number.) Answer is complete and correct