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.

Formulate the linear programming problem using the excel template.

Set up the objective function using two variables: X$1$ and X$2$

Set the parameters for X$1$ and X$2$in E$2$ and F$2$ cells.

Set the objective function in G$2($Hint: the equation includes E$2,$ F$2,$ $B$$2,$ and $B$$3)$

Set up the government policy and time constraints $($Hint: see the land constraint$)$

Set the parameters for X$1$ and X$2$ in E$6-7$ and F$6-7$ cells.

Enter the formula for cell references in G$6($Hint: the equation includes E$6,$ F$6,$ $B$$2,$ and $B$$3$

Enter the formula for cell references in G$8($Hint: the equation includes E$7,$ F$7,$ $B$$2,$ and $B$$3$

Set the constraints in H$6-7$

Solve the problem using Excel Solver.

Set the Objective

Set the Changing Variable Cells

Add constraints using G$6-7$ and H$6-7.$ Do not directly enter any numbers.

Run the solver

Save the $$Answer$$ report K$=263$