Question: I need homework help! Im not sure Im doing this right. To do the assignment, first you have to calculate the optimal solution and minimum

I need homework help! Im not sure Im doing this right. I need homework help! Im not sure Im doing this

To do the assignment, first you have to calculate the optimal solution and minimum cost for the example problem The Chapter 85 example problem is no longer in the book, but you can find the numbers for the input costs in the Chapter 89 lecture on Slide 8. The lecture slides are on Canvas under Modules/Chapter8S Transportation Problem/Chapter 85 Slides.ppt. Your input table for the costs, demand and supply should look like this: A B D SUPPLY 1 4 7 7 1 100 2 12 3 8 8 200 3 8 10 16 5 150 DEMAND 80 90 120 160 then determine the optimal solution in Excel using template on Canvas (when running Excel solver, click on "answer" and "sensitivity" for those reports, don't need limits) The assignment: 1. what is the optimal solution? 2. from 'answer report': tell me what a binding constraint is (one sentence) and which constraints are binding? 3. from 'sensitivity report': what does allowable increase mean, and how much increase is allowed for cell $E$15? what does the shadow price for Cell $D$17 mean? You should be able to print this from Excel on ONE sheet of paper. You can type your answers at the bottom of the Excel spreadsheet and print it on one page

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!