# LP Problem - Blood Shipments - Student

.xlsx
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
X.6-3 \$25.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