please answer in excel and word form

Scenario Mr. Soanso and his family have a 100-acre farm which they use for growing various crops. The family is planning to plant a mix of five crops (Beans, Cucumber, Sweet Corn, Tomatoes, and Watermelon) for the upcoming season, aiming for a high yield goal with 90% assurance level. Mr. Soanso is not planning to hire any external labor during the upcoming season - he will be making use of 2,000 hours of his own and another 5,000 hours of labor available from his family. There are sufficient amount of seeds and 300 tons of fertilizer available to utilize during the upcoming season. The table below provides details about the labor-hours and tons of fertilizer required per acre, as well as the total expected profit per ton for each of the potential crops under consideration 95 4 568 50 1.5 649 85 3.5 Tomatoes 60 2 405 70 3 Crops Beans Cucumber Sweet Corn Watermelon Required Labor (hours/acre) Required Fertilizers (tons/acre) Expected Profit (5/ton) 730 486 Mr.Soanso wishes to use a low-pressure spray method for irrigating the crops and would need to meet peak irrigation water demand as per the following: The peak water use rate is 0.25 inches per day with 20 daily pumping hours for three days per week. The total average daily consumption of water in the farm does not exceed 65,000 gallons. In addition, Mr. Soanso has the following demand considerations for the upcoming season: At least 10 acres of cucumbers should be planted The total planted acres of beans and corn should be at least 20 acres The total planted acres of beans, cucumber, and tomatoes should be at least 30 acres The total planted acres of cucumber and tomatoes should not exceed the total planted acres of beans, sweet corn, and watermelon Phase I- Requirements 1. Refer to the Irrigation Fact Sheet to estimate the average daily water requirement for each crop using the provided worksheet on page 4. Also determine the expected quantity of the five crops to be produced. Assume Total Acres irrigated (item 6) is 500 acres (100 acres per crop) when completing your worksheet. Crops Beans Cucumber Sweet Corn Tomatoes Watermelon Average daily water required (gallons/day) Quantity to be produced (tons/acre) Recall that the peak water use rate : 0.25 inches per day with 20 daily pumping hours for three days per week and the total average daily consumption of water in the form does not exceed 65.000 galons. 2. Develop complete algebraic and spreadsheet models to illustrate the above case of Mr. Soanso. 3. Use your spreadsheet model to determine how much land (total area irrigated) should be devoted to each of the five crops to maximize Mr. Soanso's profit. 4. Provide recommendations to Mr. Soanso based on the obtained results using your own words. Scenario Mr. Soanso and his family have a 100-acre farm which they use for growing various crops. The family is planning to plant a mix of five crops (Beans, Cucumber, Sweet Corn, Tomatoes, and Watermelon) for the upcoming season, aiming for a high yield goal with 90% assurance level. Mr. Soanso is not planning to hire any external labor during the upcoming season - he will be making use of 2,000 hours of his own and another 5,000 hours of labor available from his family. There are sufficient amount of seeds and 300 tons of fertilizer available to utilize during the upcoming season. The table below provides details about the labor-hours and tons of fertilizer required per acre, as well as the total expected profit per ton for each of the potential crops under consideration 95 4 568 50 1.5 649 85 3.5 Tomatoes 60 2 405 70 3 Crops Beans Cucumber Sweet Corn Watermelon Required Labor (hours/acre) Required Fertilizers (tons/acre) Expected Profit (5/ton) 730 486 Mr.Soanso wishes to use a low-pressure spray method for irrigating the crops and would need to meet peak irrigation water demand as per the following: The peak water use rate is 0.25 inches per day with 20 daily pumping hours for three days per week. The total average daily consumption of water in the farm does not exceed 65,000 gallons. In addition, Mr. Soanso has the following demand considerations for the upcoming season: At least 10 acres of cucumbers should be planted The total planted acres of beans and corn should be at least 20 acres The total planted acres of beans, cucumber, and tomatoes should be at least 30 acres The total planted acres of cucumber and tomatoes should not exceed the total planted acres of beans, sweet corn, and watermelon Phase I- Requirements 1. Refer to the Irrigation Fact Sheet to estimate the average daily water requirement for each crop using the provided worksheet on page 4. Also determine the expected quantity of the five crops to be produced. Assume Total Acres irrigated (item 6) is 500 acres (100 acres per crop) when completing your worksheet. Crops Beans Cucumber Sweet Corn Tomatoes Watermelon Average daily water required (gallons/day) Quantity to be produced (tons/acre) Recall that the peak water use rate : 0.25 inches per day with 20 daily pumping hours for three days per week and the total average daily consumption of water in the form does not exceed 65.000 galons. 2. Develop complete algebraic and spreadsheet models to illustrate the above case of Mr. Soanso. 3. Use your spreadsheet model to determine how much land (total area irrigated) should be devoted to each of the five crops to maximize Mr. Soanso's profit. 4. Provide recommendations to Mr. Soanso based on the obtained results using your own words