Question: PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD ALSO GREATLY APPRECIATE IT IF YOU COULD SHOW WHAT FORMULAS TO USE. David and

PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULDPLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD

PLEASE SHOW ME HOW TO DO THIS IN EXCEL. I WOULD ALSO GREATLY APPRECIATE IT IF YOU COULD SHOW WHAT FORMULAS TO USE.

David and Kathy have run the family farm for over thirty years. They are currently planning the mix of crops to plant on their 140 -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,400 total hours during the upcoming season. They have 360 tons of fertilizer available. What mix of crops should be planted to maximize the family's total profit. 1. Place the appropriate data into the model. Label your constraints appropriately. 2. You are sharing this file with a co-worker 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!