Please check if correct. Explain how Y is found, then use Solver for answer sheet

Question 1 5 pts ABC 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+ the last two digits of your student ID number". For example, if you student 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. Download the Excel template file: Template.xlsx Formulate the linear programming problem using the attached excel spread sheet as a template. 1. Set up the objective function using two variables: X and Y 1. Set the parameters for X and Y in E2 and F2 cells. 2. Set the objective function in G2 (Hint: the equation includes E2, F2, $B$2, and $B$3) 2. Set up the government policy and time constraints (Hint: see the land constraint) 1. Set the parameters for X and Y in E7-8 and F7-8 cells. 2. Enter the formula for cell references in G7 (Hint: the equations includes E7, F7, $B$2, and $B$3 3. Enter the formula for cell references in G7 and G8 (Hint: the equation includes E8, F8, $B$2, and $B$3 4. Set the constraints in H7-8 Save your file and answer to the following questions: o The value in E6 is 1 o The value in F7 is 0 o The value in F8 is 5 o The value in H8 is 1200 B D H 1 Decision Variables Values 2 3 Y 4 X -pareameter Objective Fuction 1000 Y - pareameter Objective Funtion 2000 522800 214) 154.4 5 6 X -pareameter Y - pareameter Cell Reference Constraint 1 1 368.4 500 214 0 214) 214 2 5 12001 1200 Land Policy Time 7 8 9 10 11 12