Question: 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. 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 optional planting mix of corn, soybeans, and wheat to maximize her profit.
|
|
CORN
|
SOYBEANS
|
WHEAT
|
|
|
|
|
|
|
Labour(workers)
|
0.1
|
0.3
|
0.25
|
|
|
|
|
|
|
Fertilizer (tons)
|
0.2
|
0.1
|
0.4
|
It looks like this problem has already been solved on this website but there is no pdf attachment or excel file. Is there already one ready to give?