Rienzi Farms grows sugar cane and soybeans on its 500 acres of land. An acre of soybeans brings a $1000 contribution to overhead and profit; an acre of sugar cane has a contribution of $2000. Because of a government program, no more than K acres may be planted in soybeans, where K equals to 200+last two digits of your student ID acres (e.g. if you ID is 1234567, then K=200+67=267). During the planting season, 1200 hours of planting time will be available. Each acre of soybeans requires 2 hours, while each acre of sugar cane requires 5 hours. The company seeks maximum contribution (profit) from its planting decision.

1. Formulate the linear programming problem using the excel template.
   • Set up the objective function using two variables: X1 and X2
     • Set the parameters for X1 and X2in E2 and F2 cells.
     • Set the objective function in G2 (Hint: the equation includes E2, F2, $B$2, and $B$3)
   • Set up the government policy and time constraints (Hint: see the land constraint)
     • Set the parameters for X1 and X2 in E6-7 and F6-7 cells.
     • Enter the formula for cell references in G6 (Hint: the equation includes E6, F6, $B$2, and $B$3
     • Enter the formula for cell references in G8 (Hint: the equation includes E7, F7, $B$2, and $B$3
     • Set the constraints in H6-7
2. Solve the problem using Excel Solver.
   • Set the Objective
   • Set the Changing Variable Cells
   • Add constraints using G6-7 and H6-7. Do not directly enter any numbers.
   • Run the solver
   • Save the Answer report

Submission requirement: 1)create a pdf file, 2) include the answer report (5 points), 3) interpret the answer report (5 points).