Use EXCEL to format this and solve using solve and explain.Biggest problem is once have variables (which i have half done) issetting up in Excel.

A farmer in the Midwst haas 1,000 acres of land on which sheintends to plant corn, wheat, and soybeans. Each acre of corn costs$100 for preparation, requires 7 worker-days of labor, and yields aprofit of $30. An acre of wheat costs $120 to prepare, requires 10worker-days, and yields $40 profit. An acre of soybeans costs $70to prepare, requires 8 worker-days, and yields $20 profit. Thefarmer has taken out a loan of $80,000 for crop preparations andahs contracted with a union for 6,000 worker-days o labor. Amidwesters granary has agreed to purchase 200 acres of corn, 500acres of wheat, and 300 acres of soybeans. The farmer hasestablished the following goals, in order of their importance:

(1) Maintain good relations with the union, the labor contractmust be honored; that is, the full 6,000 worker-days of laborcontracted for must be used.

(2) Preparation costs should not exceed teh loan amount so thatadditional loans will not have to be secured.

(3) The farmer desires a profit of a least $105,000 to remain ingood financial condition.

(4) Contracting for excess labor should be avoided.

(5) The farmer would like to use as much of the availableacreage as possible.

(6) The farmer would like to meet the sales agreement with thegranary. However, the goal should be weighted according to theprofit returned by each crop.

Solve:

a) Formulate a goal programming model to determine the number ofacres of each crop the famer shoud plat to satisfy the goals in thebest possible way.

b) Solve this model using the computer (Excel and Solver)