Reference no: EM132297012

A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers and requires two tons of fertilizer. Each acre planted with corn yields $3000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available. The farmer wants to maximize his profit from planting his land. a) Write the managerial formulation for the farmer’s problem. b) Use Solver to determine the plan that maximizes the farmer’s profit. c) If additional fertilizer became available at 600$/ton, should the farmer purchase any? (Hint: You need to generate the sensitivity report to answer that).