uestion Review the Excel spreadsheet below for Bill Farms which planning for the upcoming growing season, Bill will grow wheat, corn, oats, and soybeans. Micinsol! I xcel the 1' J Blo Ede You Theert Format Aris 10 BP FARMS What Com Sawbeanal Acres 42.8571 142.8571 0 14 28571 Profit 622 690 231 684 197200 5 3 10 1428,571 1800 Labor Expenses 50 75 30 60 18714.29 25000 1200 Water IN 1200 Min Wheat 210 30000 30000 Min Com 300 42857.14 30000 Max Oats 180 0 25000 Acres 300 300 14 C G H Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$4 Acres Wheat 142.8571429 622 56 1E+30 SD54 Acres Com 142.8571429 690 56 6 GES4 Acres Oats -444 231 444 1E+30 $F$4 Acres Soybeans 14.20571429 684 6 28 KIDMAN 14 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SG$7 Labor Total 428.571429 180 E+30 371.4285714 SG$8 Expenses Total 18714.2857 25000 E+30 6285.714286 SG$9 Water Total 1200 1200 28.57142857 85.71428571 $G$10 Min Wheat Total 30000 -0.265666667 30000 1500 7090.909091 $G$11 Min Corn Total 42857.14286 0 30000 12857.14286 18+30 SG$12 Max Oats Total 0 0 25000 1E+30 25000 SG$13 Acres Total 300 672 300 18.57142857 4.7619047621. What is the optimal number of acres of each crop Bill should plant in order to maximize his total expected return from the harvested crops and what the expected return? (1 point) 2. If the Bill decided to grow 10 acres of oats, how this will affect the expected return? (1 point) 14. 285 3. If an additional 10 acres made available to grow, how this will affect the profit? (1 point) (6 X b. 1. SAMBA bank has $1,000,000 to invest in four stocks and three bonds. X1, X2, X3, and X4 denote the amounts invested in each of the stocks, and Y1, Y2, and Y3 equal the amounts invested in each of the three bonds. Which of the following shows that at most 30% of the total investment must be in stock2? (0.5 point) a. )X2 =0, X2 + X3 + X4-A =0 b. X1 - .4A>=0, [X1 + X2 + X3 + X4 -A = 0 c. X1 - .4A - .4B = 0, A+ B= 1,000,000