the K value would be 234

the k value will be 234

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, E7, $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: The value in E6 is The value in F7 is The value in F8 is The value in H8 is Interpret the answer report and write down a brief business memo with your recommendation. UTM 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 Minimize File Preview Decision Variables Values X Objective Fuction -parameter Y pareameter objective Funtion X.pareameter Land1 y pareameter Cell Reference 1 Constraint 500