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.

2. develop complete algebraic and spreadsheet models to illustrate the 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.

B C E F H 1 Scenario von WN 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. Crops Required Labor (Hours/acre) Required Fertilizers (Tons/acre) Expected Profit ($/ton) 70 Beans 95 4 568 Cucumber Sweet Corn Tomatoes Watermelon 50 85 60 1.5 3.5 2 3 649 730 405 486 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 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 99 Group Details Phuset Requirement1 Requirement 2-4 DAM Q 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 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 prok woter userot 0.25 inches per day with 20 daly pumping hours for three days per week and the total average daily consumption of water in the form does not exceed 65,000 gallons 2. Develop complete algebraic and spreadsheet models to illustrate the case of Mr. Soanso. 3. Use your spreadsheet model to determine how much land (total area tripated should be devoted to each of the five crops to maximize Mr. Soanso's profit 4. Provide recommendations to Mr. Soans based on the obtained results using your own words, Submission Group submission using the Excel Template provided on Blackboard on or before the April, 25, 2021 deadline Provide your solutions to the four requirements of Phase 1 in the tabs highlighted Blue Requirement1 Requirement 2-4 + letter 1. At the sales the correge day were there wheel papieremehed here Curr w www.to OMIZABLO c. Gamed with 1 N MIR OLAN Com Carrefourmet to do wwwwwwwwwwww 10 100 90 100 100 1 d. www 100 Total 97 were 1. Poi www . prwide 11.14 2. 11. 14 wwww 1. wwwwww www wa with polo www. fx B C D E F G H Using information in the Scenario and your solution to Requirement 1: 2. Develop complete algebraic and spreadsheet models to illustrate the case of Mr. Scanso. 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. Make sure that all formulas and Solver parameters are saved in this worksheet before submission B C E F H 1 Scenario von WN 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. Crops Required Labor (Hours/acre) Required Fertilizers (Tons/acre) Expected Profit ($/ton) 70 Beans 95 4 568 Cucumber Sweet Corn Tomatoes Watermelon 50 85 60 1.5 3.5 2 3 649 730 405 486 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 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 99 Group Details Phuset Requirement1 Requirement 2-4 DAM Q 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 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 prok woter userot 0.25 inches per day with 20 daly pumping hours for three days per week and the total average daily consumption of water in the form does not exceed 65,000 gallons 2. Develop complete algebraic and spreadsheet models to illustrate the case of Mr. Soanso. 3. Use your spreadsheet model to determine how much land (total area tripated should be devoted to each of the five crops to maximize Mr. Soanso's profit 4. Provide recommendations to Mr. Soans based on the obtained results using your own words, Submission Group submission using the Excel Template provided on Blackboard on or before the April, 25, 2021 deadline Provide your solutions to the four requirements of Phase 1 in the tabs highlighted Blue Requirement1 Requirement 2-4 + letter 1. At the sales the correge day were there wheel papieremehed here Curr w www.to OMIZABLO c. Gamed with 1 N MIR OLAN Com Carrefourmet to do wwwwwwwwwwww 10 100 90 100 100 1 d. www 100 Total 97 were 1. Poi www . prwide 11.14 2. 11. 14 wwww 1. wwwwww www wa with polo www. fx B C D E F G H Using information in the Scenario and your solution to Requirement 1: 2. Develop complete algebraic and spreadsheet models to illustrate the case of Mr. Scanso. 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. Make sure that all formulas and Solver parameters are saved in this worksheet before submission