final project .xlsx - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B C D E F Dij= distance between sector and disposal site(in km Disposal site Sector 1

# final project .xlsx - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

This preview shows page 1 out of 1 page.

Dij= distance between sector and disposal site (in km): Disposal site Sector 1 2 3 4 5 1 3.4 1.4 4.9 7.4 9.3 2 2.4 2.1 8.3 9.1 8.8 3 1.4 2.9 3.7 9.4 8.6 4 2.6 3.6 4.5 8.2 8.9 5 1.5 3.1 2.1 7.9 8.8 6 4.2 4.9 6.5 7.7 6.1 7 4.8 6.2 9.9 6.2 5.7 8 5.4 6 5.2 7.6 4.9 9 3.1 4.1 6.6 7.5 7.2 10 3.2 6.5 7.1 6 8.3 Disposal site Sector 1 2 3 4 5 1 0 1 0 0 0 1 1 153 2 1 0 0 0 0 1 1 152 3 0 0 1 0 0 1 1 154 4 0 0 1 0 0 1 1 138 5 0 0 1 0 0 1 1 127 6 0 0 0 1 0 1 1 129 7 0 0 0 1 0 1 1 111 8 0 0 0 0 1 1 1 110 9 1 0 0 0 0 1 1 130 10 0 0 0 1 0 1 1 135 2 1 3 3 1 350 250 500 400 200 282 153 419 375 110 Calculation of objective function : Disposal site Sector 1 2 3 4 5 Dij*Xij*Si 1 0 1.4 0 0 0 1.4 153 214.2 2 2.4 0 0 0 0 2.4 152 364.8 3 0 0 3.7 0 0 3.7 154 569.8 4 0 0 4.5 0 0 4.5 138 621 5 0 0 2.1 0 0 2.1 127 266.7 6 0 0 0 7.7 0 7.7 129 993.3 7 0 0 0 6.2 0 6.2 111 688.2 8 0 0 0 0 4.9 4.9 110 539 9 3.1 0 0 0 0 3.1 130 403 10 0 0 0 6 0 6 135 810 Total distance 5.5 1.4 10.3 19.9 4.9 42 1339 5470 = Objective Value X ij = Binary decision variable for snow removal to disposal site: Total shipped by sector Contractual obligation constraint S i = Total maximum volume of snow expected

#### You've reached the end of your free preview.

Want to read the whole page?

• Spring '08
• Linderoth
• Harshad number, Disposal Site, Binary decision variable