1. A peasant in Zimbabwe has 1000 acres of land. She is going to plant each ac

1. A peasant in Zimbabwe has 1000 acres of land. She is going to plant
each acre with tomatoes zucchini or wheat. Each acre planted with tomatoes yields a $2000 profit; each with zucchini yields $2500 profit; and each with
wheat yields $3200 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 tomatoes zucchini and wheat to maximize her profits. Make sure you do a
sensitivity analysis using the examples provided in class.

TOMATOES

ZUCCHINI

WHEAT

Labor (workers)

0.1

0.3

0.2

Fertilizer (tons)

0.2

0.1

0.4