A farmer is planning his spring planting. He has 20 acres on which he can plant a combination of Corn, Pumpkins and Beans. He wants to maximize his profit but there is a limited demand for each crop. Each crop also requires fertilizer and irrigation water which are in short supply. The following table summarizes the data for the problem. What are the key formulas in cells F5 and E8 for this Excel spreadsheet implementation of the following formulation?

Question

A farmer is planning his spring planting. He has 20 acres on which he can plant a combination of Corn, Pumpkins and Beans. He wants to maximize his profit but there is a limited demand for each crop. Each crop also requires fertilizer and irrigation water which are in short supply. The following table summarizes the data for the problem.  What are the key formulas in cells F5 and E8 for this Excel spreadsheet implementation of the following formulation?  ​

Quizplus · Accepted Answer

The Answer of A farmer is planning his spring planting. He has 20 acres on which he can plant a combination of Corn, Pumpkins and Beans. He wants to maximize his profit but there is a limited demand for each crop. Each crop also requires fertilizer and irrigation water which are in short supply. The following table summarizes the data for the problem.  What are the key formulas in cells F5 and E8 for this Excel spreadsheet implementation of the following formulation?  ​

A Farmer Is Planning His Spring Planting