please solve question 2 I just provided question 1 to give background knowledge

15 16 17 Question 2 6 pts 18 . Solve the problem using the Excel Solver. 1. Set the Objective 2. Set the Changing Variable Cells 3. Add constraints using G6-8 and and H6-8. Do not directly enter any numbers. 4. Run the solver 5. Save the "Answer" report 6. Copy and paste answer report in MS Word and convert it into PDF, then upload it. 19 20 21 22 23 24 25 28 22 28 25 30 (Your report would be similar to this: Answer Report.pdf) R 8 F Question 1 4 pts 1 V 2 3 4 5 5 6 a 7 8 9 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 plus the last two digits of your student ID number". For example, if your 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. 10 11 12 13 14 15 16 17 18 19 20 21 22 N 23 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 24 25 NNN 26 27 28 29 30 Re: B H H Values D G X -pareameter Y-pareameter Objective Funtion Objective Fuction X-pareameter Y - pareameter Cell Reference 1 1 Land Policy Time Constraint 0 500 1200 200 5 2 1 Oo 0 3 1 5 > 15 16 17 Question 2 6 pts 18 . Solve the problem using the Excel Solver. 1. Set the Objective 2. Set the Changing Variable Cells 3. Add constraints using G6-8 and and H6-8. Do not directly enter any numbers. 4. Run the solver 5. Save the "Answer" report 6. Copy and paste answer report in MS Word and convert it into PDF, then upload it. 19 20 21 22 23 24 25 28 22 28 25 30 (Your report would be similar to this: Answer Report.pdf) R 8 F Question 1 4 pts 1 V 2 3 4 5 5 6 a 7 8 9 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 plus the last two digits of your student ID number". For example, if your 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. 10 11 12 13 14 15 16 17 18 19 20 21 22 N 23 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 24 25 NNN 26 27 28 29 30 Re: B H H Values D G X -pareameter Y-pareameter Objective Funtion Objective Fuction X-pareameter Y - pareameter Cell Reference 1 1 Land Policy Time Constraint 0 500 1200 200 5 2 1 Oo 0 3 1 5 >