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 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