A C D G H J K L M N 0 P Q R 1 Analyze the data provided along with mileages, identifying 10 consolidation opportunities not all will work, that's ok! 2 For each of the consolidated shipments, use the rates below the map link to estimate the cost of the consolidated shipment, along with the savings realized through consolidation. 3 Assume that all delivery dates are flexible 3 days, and a fully loaded trailer can carry 40,000 pounds, and measures 8' W, 9' H, 53' L. - see notes below S 4 5 For this assignment, use the average of the high and low prices. To determine the cost for a consolidated shipment, use the cost for the longest distance, and add a $90 surcharge for each additional stop. 6 For each consolidation, explain why that consolidation is feasible and within required conditions. 7 For both vehicle and inbound/outbound consolidation, identify an example that appears feasible, but violates one or more of the required conditions. 8 9 This map of the U.S. Interstate Highway System may be helpful: 10 http://www.interstate-guide.com/wp-content/uploads/main/interstate-system-map-1974.jpg 11 12 FOR THIS ASSIGNMENT: 13 Use $1.50 per mile for shipments under 300 miles 14 Use $1.35 per miles for shipments over 300 but under 400 15 Use $1.30 for all over 400 miles 16 17 How to complete this assignment- F18 On the "Loads" tab, there are two tables. Inbound and oubtound. You are assuming the role of Logistics Specialist for a distribution facility (crossdocking/consolidating/shipping back out). 19 You have 10 days of inbound and outbound shipments on your books, it is your job to combine them for ease of receiving and shipping. 20 21 Using geographical knowledge and the mileage dropdowns provided, create 15 consolidations. 22 This means: 23 build multistop TL routes to cut down the number of deliveries 24 flex dates (plus or minus 3 days) to combine shipments to or from the same location (IE - one shipment from Smallville, TN on 6/1 is bumped back to 6/3, and another is pulled forward from 6/5 to 6/3 so they can ride to 25 flex dates to create multi-stop routes to maximize weight and lower miles 26 If your consolidation ends up being more expensive, it still counts for this assignment, just show the work you used to find out the cost! 27 Show your work and decide which of the ten attempted consolidations you want to keep and share the totals savings (Formulas below) 28 That's it - you'll be ready to break into the world of freight! 29 30 Original Route 31 3000 miles Mileage Savings =(3000-2100)/3000 30.0% New Route 2100 miles 32 33 Original Cost New Cost 34 $1,700 $800 Cost Savings =(1700-800)/1700 52.9% 35 36 Original Cost Per Mile New Cost Per Mile 37 =1700/3000 38 $ 0.57 =800/1200 $ 0.67 39 40 AA AB AC AD AE AU 1 Gary IN 369.49 5 7 6 778.93 1311.97 9 1380.73 1664.17 1281.42 2779.43 16 17 79.32 18 2133.26 19 20 0 536.74 525.66 135.80 21 135.82 561.44 22 2413.92 1971.19 2453.53 0 735.43 1076.82 835.69 24 2553.10 2302.48 0 25 2776.25 26 870.84 27 2447.00 28 825.57 1203.08 29 269.03 790.36 30 31 757.10 64.36 1233.31 707.28 585.69 88.70 32 327.26 246.98 350.56 2110.47 1414.77 33 230.64 706.84 180.82 2635.36 1636.22 2816.74 2998.33 665.30 2711.23 34 873.22 1349.42 823.40 2942.80 2278.80 3459.33 3305.77 28.85 3353.81 Kansas City Kokomo IN Los Angele Ogden UT Olympia W Palo Alto C Philadelph Portland ORichmond Saginaw M Scranton P South Ben St. Louis M Toledo OH Wilmington DI 845.69 319.67 2733.15 1775.07 2955.59 3096.12 585.84 2850.08 489.17 297.89 459.82 633.58 B 835.50 1311.70 785.68 3240.22 2241.08 3421.61 3603.19 246.23 3316.09 487.14 619.95 173.81 771.44 1099.59 4 826.28 1302.48 776.46 2962.60 2231.86 3412.39 3325.57 58.98 3306.87 294.40 754.68 73.78 762.22 1090.37 220.77 742.10 226.45 2680.99 1626.35 2806.88 3043.96 717.78 2701.36 682.69 92.79 591.76 157.47 529.99 1255.13 610.18 2870.08 3336.65 3365.04 3233.05 98.56 3259.52 150.93 707.33 209.09 714.88 1043.02 1061.35 1445.81 1339.22 606.58 1239.91 1288.03 2192.55 1134.40 2140.31 1475.19 2066.53 1374.56 1486.24 8 670.98 1002.54 571.68 2154.75 2621.33 3454.74 2517.72 1086.95 3349.22 866.39 748.82 729.25 1258.40 617.31 3246.00 4079.41 3142.40 1152.15 3973.89 907.28 1576.14 1267.12 1438.99 1327.06 10 1104.09 1580.29 1054.27 3347.43 2509.67 3690.19 3710.40 356.64 3584.68 597.56 1032.49 366.16 1040.03 1368.18 887.50 11 380.01 822.39 296.37 2711.44 1785.60 2966.12 3074.41 598.52 2860.61 442.71 294.75 472.50 315.96 610.28 149.76 12 2380.25 1592.08 2514.08 438.48 579.86 688.90 238.84 3360.40 577.22 3177.01 2543.47 3511.97 2442.84 2484.51 2987.78 13 810.30 1187.81 711.00 2790.16 3256.74 4090.14 3153.13 462.85 3984.63 217.98 823.19 577.82 868.57 926.72 684.19 14 338.01 814.21 288.19 2742.73 1743.59 2924.11 3105.70 544.54 2818.60 512.38 266.41 15 967.85 525.13 1007.47 1445.39 1911.97 2745.38 1808.36 1542.62 2639.86 1359.23 1233.52 1694.19 1030.44 666.73 262.34 764.27 238.25 2692.79 1667.93 2848.45 3055.76 718.84 2742.94 683.75 105.03 592.82 199.05 552.16 600.65 108.01 2477.04 1484.90 2665.43 2840.01 803.66 2559.91 732.38 242.94 677.64 15.08 388.54 2172.87 1690.53 476.87 549.32 1382.73 757.72 2708.02 1277.21 2524.64 2398.92 2859.60 2195.85 1832.13 2335.41 1409.92 2402.06 2590.44 2765.03 881.85 2484.93 830.31 266.94 755.83 63.86 313.55 0 560.03 1984.61 1161.13 1994.53 2347.58 1388.07 1889.02 1206.27 802.40 1262.05 599.33 246.73 2437.83 1544.85 2725.38 2800.80 831.67 2619.86 730.11 313.64 705.65 88.74 349.33 358.35 2988.68 965.14 2805.29 2679.58 3140.25 2476.50 2112.79 23 1918.28 1159.41 2052.11 733.27 0 2798.85 797.53 730.17 3269.39 2081.50 2672.84 1980.87 2092.55 2148.65 1076.62 896.87 776.46 113.32 3433.68 3381.44 0 2686.94 2716.32 3307.66 2615.69 2727.37 2783.48 3435.90 2333.52 2815.86 775.39 3351.02 663.71 3167.63 3041.92 357.71 3502.59 798.42 2838.84 2475.13 2978.41 3306.02 3334.91 1347.04 3456.95 821.02 0 3351.43 2971.94 246.02 2276.42 799.24 122.00 806.79 1134.94 654.25 28.95 663.73 3327.57 2610.22 2196.37 2580.83 3275.34 2509.59 963.88 2621.27 790.76 113.15 3201.56 2677.37 3329.80 648.77 2805.43 3999.90 0 4105.42 815.84 3168.40 361.26 670.85 3272.01 246.30 752.35 218.32 942.00 2749.62 775.14 313.40 2666.75 1674.61 684.21 2855.14 3029.72 810.22 122.53 3161.82 3237.69 2162.68 3343.21 3524.79 2462.08 1469.94 2650.47 2825.05 819.59 2544.95 2633.80 2473.44 1178.59 2528.29 B C D E F G H K L M 305.43 152.90 588.06 618.91 609.69 274.92 69.12 0 196.18 52.12 720.00 251.32 671,10 661.88 562.34 70.58 1542.35 2194.77 734.22 1041.96 1443.96 1124.18 0 418.52 273.95 602.10 231.65 737.87 181.46 385.33 408.50 3315.40 434.87 121.42 546.76 1170.01 1497.63 58.64 721.06 153.46 805.88 2663.03 884.07 1390.29 0 833.89 2616.07 2943.69 2801.08 2748.75 0 0 229.90 578.25 493.54 486.47 144.56 812.45 297.84 763.20 363.22 685.50 0 693.05 1021.20 540.51 160.99 454.40 171.71 885.67 941.24 217.84 229.62 693.57 0 373.58 592.93 1052.57 389.85 0 528.39 630.21 145.36 539.28 166.58 494.73 801.62 160.24 809.17 1137.31 656.63 169.39 821.81 307.21 1180.81 0 667.52 0 666.21 152.92 425.81 2136.72 3383.57 2771.55 3324.98 3022.98 58.95 706.44 3277.47 2665.44 4390.39 3184.99 293.09 723.04 150.95 2175.11 909.03 760.12 869.61 91.86 667.64 1026.96 1615.11 1580.84 74.47 592.70 210.39 2103.18 1112.72 1268.97 357.79 772.57 769.49 156.85 677.01 724.09 1410.44 1435.32 1036.33 1131.57 1128.49 572.97 973.34 1393.77 614.90 1326.12 1395.33 618.27 615.20 52.56 522.71 1576.71 737.03 1448.26 882.04 274.80 68.97 708.82 69.67 2219.30 1049.99 1123.59 379.95 2656.27 607.60 2629.47 1242.42 3867.38 3291.09 1288.13 2527.70 3156.82 3232.74 97.85 2216.92 1151.77 1079.14 1136.32 3761.27 761.60 Akron OH Albany NY Allentown Ann Arbor Baltimore Billings MT Birminghai Boca Rator Boston MA Canton OH Carson City Cary NC 0 538.82 535.74 205.09 381.67 1715.57 840.35 1212.15 802.58 23.27 3092.65 532.80 338.97 2181.58 1341.89 1392.89 168.78 541.20 3599.72 523.58 0 141.57 2172.36 1069.80 1200.15 356.47 399.58 3322.10 205.40 670.76 667.68 0 575.20 1566.85 782.66 1493.89 934.52 234.40 3040.49 385.03 338.73 140.91 614.53 2125.01 977.28 1056.68 443.88 1680.17 2145.52 2142.44 1530.42 2049.96 0 2626.25 3255.37 2409.29 1735.81 1068.55 2126.53 1649.24 1902.78 830.65 1337.39 1060.92 778.79 968.67 2616.35 0 730.92 1601.16 808.36 2514.25 610.04 841.11 708.68 792.97 1193.45 1392.33 1198.95 1488.54 1056.81 3241.02 727.84 1497.48 1171.23 3138.92 768.50 1396.44 1333.35 1502.72 801.39 168.08 362.67 939.69 449.39 2450.16 1454.63 1503.30 0 809.79 3706.93 812.17 766.73 1901.35 940.27 1025.47 24.02 551.49 548.41 201.95 335.21 1726.09 818.63 1190.99 815.26 0 3070.93 555.57 89.21 1265.36 202.53 301.40 3125.61 3590.96 3334.36 2598.69 3242.11 1069.57 2537.08 3166.20 0 3163.22 3094.67 1813.61 3046.54 2457.75 696.74 577.81 703.03 509.64 730.39 367.50 2159.83 622.17 769.60 3149.66 0 682.13 1344.08 742.95 823.14 2509.71 34.43 497.51 494.43 173.61 404.88 1684.08 844.40 1265.52 3102.22 643.96 0 1296.65 174.19 259.39 2462.28 1307.83 1773.18 1516.59 1214.59 1424.34 1906.99 719.31 1348.43 2036.95 1804.89 1345.44 1276.90 206.46 671.81 668.73 3052.29 745.93 175.53 1246.71 291.28 756.63 753.55 2836.54 834.95 260.35 1030.96 183.02 2473.23 2938.59 2681.99 369.47 834.82 1341.04 875.69 319.29 784.64 2753.89 3219.25 2286.48 2751.83 2921.30 3386.65 3116.23 3581.58 430.35 245.20 2815.20 3280.55 N O P Q R Cleveland Dallas TX Detroit MI Elkhart IN Flagstaff 576.73 701.76 34.09 498.14 1287.07 205.67 1794.14 671.68 290.87 756.88 2452.70 2959.77 509.01 488.92 1516.52 662.46 747.66 2682.15 728.43 372.05 3229.58 365.54 441.57 174.47 1234.91 42.95 142.91 2400.54 1424.00 615.11 700.32 2589.63 1571.09 1389.47 1318.56 683.81 1874.31 1393.56 2498.98 3066.98 2430.99 3854.73 3081.80 808.18 555.59 761.28 89.87 1264.03 0 1228.77 1045.35 1164.95 43.80 576.25 1608.42 794.46 1505.69 935.58 235.45 142.34 661.07 1425.40 687.16 1398.39 1020.40 320.27 2379.99 2589.74 1154.64 1884.71 2513.83 3202.35 2429.43 696.95 2510.85 2442.30 1161.24 2394.17 2210.75 831.75 219.72 739.26 1350.41 668.74 1379.96 1098.59 398.47 2761.55 816.52 338.54 260.40 78.77 2121.61 1337.96 782.45 1182.82 1060.99 1026.87 1722.74 1604.81 850.04 1592.21 1192.48 844.76 538.54 796.62 614.24 1704.17 781.56 226.04 626.41 1485.35 568.53 1279.76 1048.41 293.64 2797.33 716.32 288.35 991.75 240.22 108.00 2157.38 2962.65 2660.65 2870.40 1340.75 2165.37 2794.49 3483.01 2710.09 438.97 2791.51 2722.96 1441.90 2674.83 2491.41 483.35 3258.58 3015.59 2342.12 578.04 3255.60 2255.54 1906.00 21.40 1995.78 547.52 4496.50 3650.42 2976.94 689.29 3367.66 2890.37 3143.91 2812.23 2630.60 1443.76 3845.35 3072.43 243.40 3153.84 3085.30 1804.23 3037.16 2853.75 756.64 350.35 408.93 3331.44 460.63 533.49 1525.87 707.02 792.23 2691.50 3544.31 2870.84 576.55 3261.55 2784.26 3037.80 2706.12 2524.50 1337.66 591.62 480.56 217.90 550.08 1359.35 723.62 737.79 2524.98 3026.25 326.84 266.91 1017.40 2386.30 462.81 3521.32 419.75 593.28 577.84 2881.37 336.21 2821.58 871.88 276.28 1016.01 197.53 2181.63 640.56 2469.97 927.46 635.28 664.39 587.15 404.76 1830.02 181.91 2994.86 682.06 121.99 1189.28 60.16 152.02 2354.91 404.39 3302.29 432.45 535.86 1496.72 709.40 794.61 2662.35 0 184.49 2412.34 0 2196.59 0 955.98 3164.93 1220.67 1715.74 242.67 158.18 678.49 15.03 35 D E H T Scheduled Loads for the Kansas City MO Distribution Center Inbound Loads Outbound Loads Origin City Weight Arrival Date St. Louis MO 17,807 5/5 Destination Scranton PA Weight Delivery Date K L M N Mileage dropdowns Location 1 Ann Arbor MI Location 2 Allentown PA 13,751 5/5 Cleveland OH 12,228 5/5 Kansas City MO 13,898 5/5 Flagstaff AZ 15,948 5/6 Wilmington DE 11,804 5/5 Baltimore MD 8,770 5/7 Canton OH 16,052 5/6 Ann Arbor MI 13,863 Miles: Location 1 Location 2 5/7 Elkhart IN 16,628 5/6 Akron OH 18,950 5/8 Allentown PA 31,229 5/9 Gary IN 25,251 5/9 Ogden UT 8,594 5/9 Boca Raton FL Miles: 16,701 5/9 Kokomo IN 6,557 5/9 Saginaw MI 16,682 5/10 Wilmington DE 10,925 5/10 Location 1 Location 2 Cary NC 14,098 5/10 Philadelphia PA 22,004 5/10 Los Angeles CA 17,285 5/11 Baltimore MD 19,188 5/11 Carson City NV 12,152 5/11 Boston MA 10,037 5/11 Miles: St. Louis MO 12,060 5/11 Albany NY 13,499 5/12 Detroit MI 8,677 5/12 Olympia WA 16,881 5/12 Location 1 Location 2 South Bend IN 12,317 5/12 Palo Alto CA 13,458 5/12 Portland OR 12,392 5/12 Dallas TX 4,241 5/13 Elkhart IN 21,575 5/12 Dallas TX 8,534 5/14 Miles: Toledo OH 10,085 5/13 Richmond VA 23,156 5/15 Flagstaff AZ 10,537 5/15 Kokomo IN 12,748 5/15 Location 1 Location 2 Birmingham AL 7,999 5/15 Billings MT 14,472 5/15 Miles: Location 1 Location 2 Miles: