Please FOLLOW THE INSTRUCTIONS.

Please show your LP standard (mathematical) model in its correct and complete format. Please copy and paste the relevant Excel LP modeling steps and results into your analysis report!

Problem:

A farmer owns 45 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $200 profit, requires 3 workers and 2 tons of fertilizer. Each acre with corn yields $300 profit, requires 2 workers and 4 tons of fertilizer. The farmer has 100 workers and 120 tons of fertilizer available.

(a). Structure the problem in a standard LP model (you must write down your model)

(b). Using Excel Solver, find the optimal solutions for the problem.