Show All Work

Vivian is involved primarily in growing wheat, alfalfa, and barley crops, and needs your help in preparing its production plan for the next year. Each of Vivian's crop needs a minimum amount of water per acre, and there is a projected limit on sales of each crop as given below: 4. Agricultural Production Planning: Vivian Farmer owns five parcels of farmland. The parcels, their area, and water irrigation limits are stated in the following table. The state's water authority has recently announced its water allotment with the Vivian's farm receiving 7,400 feet-acre. Each parcel can only tolerate a certain amount of irrigation per growing season as specified in the following table: Vivian is involved primarily in growing wheat, alfalfa, and barley crops, and needs your help in preparing its production plan for the next year. Each of Vivian's crop needs a minimum amount of water per acre, and there is a projected limit on sales of each crop as given below: Vivian'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. Complete (a) to (d) for this problem. a. Define the decision variables for this problem, write the objective function and constraints. (10) b. Set up an Excel worksheet and save it as an Initial worksheet. (10) c. Complete the solver parameters, solve the problem, save the final worksheet and the answer report. (5) d. Write the quantity of wood products and the maximized profit