LP Problem - Blood Shipments - Student

Flows To City Atlanta Charleston Louisville Mobile Raleigh Richmond From City City Code X1 X2 X3 X4 X5 X6 Atlanta X1 X.1-4 Charleston X2 X.2-5 Louisville X3 X.3-4 X.3-6 Mobile X4 X.4-3 Raleigh X5 X.5-1 X.5-2 X.5-3 Richmond X6 X.6-2 X.6-3 Costs City Atlanta Charleston Louisville Mobile Raleigh Richmond City City Code X1 X2 X3 X4 X5 X6 Atlanta X1 $17.00 Charleston X2 $20.00 Louisville X3 $30.00 $25.00 Mobile X4 $30.00 Raleigh X5 $15.00 $20.00 $20.00 Richmond X6 $27.00 $25.00 Route Cost X.1-4 $17.00 X.2-5 $20.00 X.3-4 $30.00 X.3-6 $25.00 X.4-3 $30.00 X.5-1 $15.00 X.5-2 $20.00 X.5-3 $20.00 X.6-2 $27.00 X.6-3 $25.00 Route X.1-4 X.2-5 X.3-4 X.3-6 X.4-3 X.5-1 X.5-2 X.5-3 X.6-2 Cost $17.00 $20.00 $30.00 $25.00 $30.00 $15.00 $20.00 $20.00 $27.00

Microsoft Excel 16.77 Sensitivity Report Worksheet: [LP Problem - Blood Shipments - Student.xlsx]Sheet1 Report Created: 10/5/23 2:30:02 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease Max Min $C$3 Units Shipped X.1-4 100 0 17 18 22 35 -5 $D$3 Units Shipped X.2-5 150 0 20 1E+030 20 1E+030 0 $E$3 Units Shipped X.3-4 30 0 30 22 18 52 12 $F$3 Units Shipped X.3-6 70 0 25 1E+030 47 1E+030 -22 $G$3 Units Shipped X.4-3 0 60 30 1E+030 60 1E+030 -30 $H$3 Units Shipped X.5-1 275 0 15 18 22 33 -7 $I$3 Units Shipped X.5-2 0 40 20 1E+030 40 1E+030 -20 $J$3 Units Shipped X.5-3 0 18 20 1E+030 18 1E+030 2 $K$3 Units Shipped X.6-2 0 74 27 1E+030 74 1E+030 -47 $L$3 Units Shipped X.6-3 0 50 25 1E+030 50 1E+030 -25 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $M$5 Atlanta 175 35 175 10 150 Atlanta has its demand of $M$6 Charleston -150 0 -160 10 1E+030 Charlston is left with 10 un $M$7 Louisville -100 22 -100 10 100 Louiville shipped all of its u $M$8 Mobile 130 52 130 10 100 Mobile has met its deman $M$9 Raleigh -125 20 -125 10 150 Raleigh has shipped all its $M$10 Richmond 70 47 70 10 70 Richmond has met all its d