Bob Jones has 600 acres of land for planting soybeans and flax. The profit is $179 per acre for flax and $252 per acre for soybeans. It takes Bob 3 days to fertilize an acre of soybeans and 2 days to fertilize an acre of flax, and there are 312 days per year available for fertilizing. In addition, it takes Bob 0.5 days to harvest an acre of soybeans and 0.3 days to harvest an acre of flax, and there are 60 days per year available for picking.
• Model the problem on an Excel spreadsheet using best practices discussed in class
• Express the model in algebraic form on the spreadsheet.
• Identify the type of linear programming model represented by this problem
• Use Solver to find the optimal solution.