In: Operations Management
Farming
You operate three farms in Colorado. The acreage and irrigation water available for the three farms are shown below:
Water Available
Farm Acreage (acre feet)
1 400 1500
2 600 2000
3 300 900
Three crops can be grown. However, the maximum acreage that can be grown of each crop is limited by the amount of appropriate harvesting equipment available. The three crops are described below:
Total
Harvesting Water Expected
Capacity Requirements Profit
Crop (in acres) (in acre-feet/acre) (in $/acre)
Milo 700 6 400
Cotton 800 4 300
Wheat 300 2 100
If any combination of crops can be grown on each farm (within the constraints) then what should you plant on each farm? What will the resulting profit be?
Please show and explain using excel
Below is the screenshot of the LP table -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the result obtained -