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 soy-beans 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 Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize herprofits.

  • CreatedApril 09, 2014
  • Files Included
Post your question