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,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 following table 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 her profits. Labor (workers) Fertilizer (tons) Corn 0.1 0.2 Soybeans 0.3 0.1 Wheat 0.2 0.4

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,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 following table 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 her profits. Labor (workers) Fertilizer (tons) Corn 0.1 0.2 Soybeans 0.3 0.1 Wheat 0.2 0.4

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 23EQ: 23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes...

See similar textbooks