final project_snow case.pdf - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B 23 24 25 26 27 28 29 30 D E F G H I J 5 9.3 8.8 8.6 8.9 8.8 6.1 5.7 4.9 7.2

final project_snow case.pdf - A 1 2 3 4 5 6 7 8 9 10 11 12...

This preview shows page 1 out of 1 page.

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647ABCDEFGHIJSector1234513.41.44.97.49.322.42.18.39.18.831.42.93.79.48.642.63.64.58.28.951.53.12.17.98.864.24.96.57.76.174.86.29.96.25.785.465.27.64.993.14.16.67.57.2103.26.57.168.3Sector12345Total shipped by sectorContractual obligation constraint Si= Total maximum volume of snow expected in sector i 101000111532100001115230010011154400100111385001001112760001011129700010111118000011111091000011130100001011135Total shipped to disposal site 21331Cj= Capacity of disposal site 350250500400200Total volume of Snow by Site (=SUMPRODUCT(B19:B28,$I$19:$I$28))282153419375110Sector12345Total distance from sector to disposal site (Dij*Xij) in km Si= Total maximum volume of snow expected in sector i Dij*Xij*Si101.40001.4153214.222.400002.4152364.83003.7003.7154
Background image

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture