David and Kathy have run the family farm for over thirty years. They are currently planning...

  

Transcribed Image Text:

David and Kathy have run the family farm for over thirty years. They are currently planning the mix of crops to plant on their 240-acre farm for the upcoming season. The table below gives the labor hours and fertilizer required per acre, as well as the total expected profit per acre for each of the potential crops under consideration. David, Kathy and their children can work at most 8,600 total hours during the upcoming season. They have 300 tons of fertilizer available. What mix of crops should be planted to maximize the family's total profit Crop Oats Wheat Corn Labor Required (hours per acre) 60 65 95 Fertilizer Required (tons per acre) 2 3 3.5 Expected Profit (per acre) $575 $650 $900 1. Place the appropriate data into the model Label your constraints appropriately. 2. You are sharing this file with a co-worker You need to leave at least 2 comments regarding work-flow on this worksheet 3. Using the Solver add-in, what is your maximized profit based upon the crop selection? Ensure your answers are highlighted in the yellow cells (C12, D12 and E12). 4. What is your objective? Make a comment on your Objective cell. NOTE: Acres planted should be integers. David and Kathy have run the family farm for over thirty years. They are currently planning the mix of crops to plant on their 240-acre farm for the upcoming season. The table below gives the labor hours and fertilizer required per acre, as well as the total expected profit per acre for each of the potential crops under consideration. David, Kathy and their children can work at most 8,600 total hours during the upcoming season. They have 300 tons of fertilizer available. What mix of crops should be planted to maximize the family's total profit Crop Oats Wheat Corn Labor Required (hours per acre) 60 65 95 Fertilizer Required (tons per acre) 2 3 3.5 Expected Profit (per acre) $575 $650 $900 1. Place the appropriate data into the model Label your constraints appropriately. 2. You are sharing this file with a co-worker You need to leave at least 2 comments regarding work-flow on this worksheet 3. Using the Solver add-in, what is your maximized profit based upon the crop selection? Ensure your answers are highlighted in the yellow cells (C12, D12 and E12). 4. What is your objective? Make a comment on your Objective cell. NOTE: Acres planted should be integers.

Answer rating: 100% (QA)

DESCRIPTION The above problem is identified as a resourceallocation problemThe attributes for th... View the full answer