Using Excel Solver please

broken into a southeast sector, north sector, north- garet Black's family owns five parcels of farmland west sector, west sector, and southwest sector. Mar- garet is involved primarily in growing wheat, alfalfa, and barley crops and is currently preparing her pro- duction plan for next year. The Pennsylvania Water Authority has just announced its yearly water allot- ment, with the Black farm receiving 7,400 acre-feet. er. What is the best S: 8-15 (Agricultural product nal minute of time device 2? Test de etronics add more h equipment? =) South Central august I opening its Baton Rouge, ts personnel de- rmine how many and trained over Each parcel can only tolerate a specified amount of irrigation per growing season, as specified in the fol. lowing table: 50 fully trained wing personnel NEEDED PARCEL AREA (ACRES) Southeast 2.000 North 2,300 Northwest West 1,100 Southwest 500 WATER IRRIGATION LIMIT (ACRE-FEET) 3,200 3.400 800 500 600 600 Each of Margaret's crops needs a minimum amount of water per acre, and there is a projected limit on sales of each crop. Crop data follow: CROP bloyee can ac- s per month for check-in daily radia- ntral Utilities zable in those erstaffed. So, able than are WATER NEEDED PER ACRE (ACRE-FEET) Wheat MAXIMUM SALES 110,000 bushels 1.800 tons 2.200 tons Alfalfa Barley 1.6 2.9 3.5 Margaret's best estimate is that she can sell wheat at a net profit of $2 per bushel, alfalfa at $40 per ton, and barley at $50 per ton. One acre of land yields an average of 1.5 tons of alfalfa and 2.2 tons of barley. The wheat yield is approximately 50 bush- els per acre. (a) Formulate Margaret's production plan. (b) What should the crop plan be, and what profit will it yield? (c) The Water Authority informs Margaret that for a special fee of $6,000 this year, her farm will qualify for an additional allotment of 600 acre- feet of water. How should she respond? complete X-ray equi Mt. Sinai 90-bed ac rently use that the la are not need to The add how ma staff fou cal staf TH