alings Review View ABCDE AaBbCcDc Heading 1 Normal No Spacing company A is determining how many acres of Corn, Tomatoes, Potatoes, and Okra its members should plant this year. It is using an LP "Product Mix" optimization to do this for a typical 80-acre farm. Revenue and Operating Costs vary by type of vegetable planted. It estimates that a typical farmer can spend up to 2000 hours of planting time, and has 6000 barrels of water and 5000 pounds (lbs) of fertilizer available. The Excel spreadsheet with Solver's solution that optimizes Operating Margin(-Revenue Operating Costs) is shown below. The financials are expressed in thousands of dollars (SK). B C D E F G H Okra Com Tomatoes Potatoes 6020 0 3 Acres Planted 3.4 0.7 $ $ 265 0.5 2.5 0.3 $ 5 Revenue (SK/acre) $ 2.8 16 Operating Cost (SK/acre) $ 04 5 Operating Margin = Revenue Minus 7 Operating costs (SK/acre) | $ 241 $ 2.7 $ 2.1 $ 2.2 198.0 1 9 Constraints: LHS Sign RHS 10 Total acreage 1 1 80 cm 80 11 Planting time (hours/acre) 20 40 50 2000 2000 12 Water (barrelsacre) 50E70 4 5 60 4400