Question: The question is to fill in this Excel Solver with given info, to eventually fill in the blanks. The last 2 numbers of my student

The question is to fill in this Excel Solver with given info, to eventually fill in the blanks. The last 2 numbers of my student ID are 27 so K=200+27. PLEASE HELP!The question is to fill in this Excel Solver withThe question is to fill in this Excel Solver with

X -pareameter/Y - pareameter Objective Funtion 1 Decision Variables Values 2x 3 Y Objective Fuction X -pareameter Y - pareameter Cell Reference 0 Constraint 500 Bodvou Land Policy Time 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: The value in E6 is The value in F7 is o The value in F8 is o The value in H8 is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!