Question: Need help with question 4 what is the formulation in excel foru question 4 Question 3: Solve the formulation given below by using Excel Solver.
Need help with question 4
what is the formulation in excel
foru question 4
Question 3: Solve the formulation given below by using Excel Solver. Upload your Excel file to the Final folder on D2L. (10 points) Minimize cost=$12C + $20T+$35W Subject to 4C + 3T+3W 1200 3C +6T+4W > 1200 5C +12T 1000 C,T,W20 Question 4. Rienzi Farms grows sugarcane and soybeans on its 6000 acres of land. An acre of soybeans brings a $1000 profit and an acre of sugarcane has a contribution of $2500 profit. Because of a government program no more than 3000 acres may be planted in soybeans. During the planting season 12000 hours of planting time will be available. Each acre of soybeans requires 2 hours, while each acre of sugarcane requires 5 hours. The company seeks maximum contribution (profit) from its planting decision. Formulate the problem as a linear program (definition of decision variables, objective function, and constraints). (10 points) Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
