Question: Can you solve by excel solver? 3. Formulate a model and make the calculation for the problem. On farms 1, 2 and 3, with an
3. Formulate a model and make the calculation for the problem. On farms 1, 2 and 3, with an area of 200, 400 and 600 hectares respectively, three crops are planned to be grown: rice, soybeans and maize, each requiring a minimum harvest of 3740kg,1300kg and 7600kg respectively. The estimated yields for each of the three crops grown on each plot are shown below. Table Unit yields of the three crops on different arable land (in kg/hm2 ) If the crop sells for $1.1/kg for rice, $1.95/kg for soybeans and $0.95/kg for maize, what is the planting plan to maximize total revenue
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
