Question: (covered up my personal info) please use excel solver to solve question 1 and show any formulas! please show work and formulas for question 2

(covered up my personal info) please use excel
(covered up my personal info) please use excel solver to solve question 1 and show any formulas! please show work and formulas for question 2 as well :)
Question 1. Solve the formulation given below by using Excel Solver. Uptonte the Minimize cost=$120C + $200T+$300W Subject to 4C + 3T+3W > 12000 30 + 6T+4W > 12000 SC + 12T> 10000 C, T. W 20 Question 2. Rienzi Farms grows sugarcane and soybeans on its 600 acres of land. An acre of soybeans brings a $1000 profit and an acre of sugarcane has a contribution of $2000 profit. Because of a government program no more than 300 acres may be planted in soybeans. During the planting season 1200 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)

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!