History Bookmarks Window Help ezto.mheducation.com A-App: Linear Programming Pro

Question

History Bookmarks Window Help ezto.mheducation.com A-App: Linear Programming Problem A-10 A farmer in Wood County has 960 acres of land. She is going to plant each acre with corn, soybeans, or wheat. Each acre planted with com yields a $2,300 profit, each with soybeans yields $2,400 profit; and each with wheat yieids $3,100 proft. She has 196 workers and 126 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Labor (workers) Fertilizer (tons) CORN SOYBEANS WHEAT 0.1 0.2 0.2 0.1 0.4 0.3 Assuming a linear relationship, use Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. In formulating your linear program, do NOT restrict the three decision variables to integer values. (Howover, round the final values of these decision variables to the nearest whole number when entering those answers. Use these rounded decision variable values to compute "Total Profit" and enter that answer to the nearest whole number. Lastly, also use the rounded decision variable values to compute the three "Resources Used" answers and enter them to the nearest whole number. Leave no cells blank-be certain to enter "" wherever required.) Decision for corn Decision for soybeans Decision for wheat Total proft Used Labor (workers) Fertlizor ttons) Acres Planted 21

Explanation / Answer

I Part

Decision for Corn = 745 acres

Decision for Soybean = 130 acres

Decision for Wheat = 85 acres

Total profit = $1713500 + $312000 + $263500 = $2289000

II Part

Total Labour used = 196

Total fertilizers used = 126 tons

Total acres planted = 960

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.