Please show formulas used.

Inbound Transportation Problem You are a logistics analyst for a major third party logistics company which is the lead provider (LLP) for an assembly plant located in Detroit, Michigan. Your job is to design the most efficient truck routes possible for parts inbound daily to the assembly plant. The truck routes begin and end at the plant. The routes that you design must minimize the total distance traveled and the number of trucks used while complying with the U.S. Department of Transportation rules concerning the hours that drivers can be behind the wheel as presented in Figure 1. The plant must receive enough parts to meet its daily demand over a five day week. All of the trailers are 98 inches wide, 110 inches high and 53 feet long. The weight capacity of each trailer is 45,000 pounds. The truck travels at an average rate of speed of 1.25 minutes per mile and each stop to load parts and unload empty, returned containers takes 30 minutes. Figure 2 presents data on each of the parts coming from each supplier. For example, part AB is coming from a supplier located in Bowling Green, Ohio in a container called a standard pack, which holds 28 units. The container is 70 inches long, 39 inches wide, 45 inches high, weighs 480 pounds when full and can be stacked two high (one on the floor and one on top) but no higher. The plant requires 275 units of this part each day and it goes to zone three in the plant. The miles from and to all 16 points and Detroit are presented in Table 1. Assume that the parts are delivered to one central receiving point at the plant. MILES ROYAL CITY FENTON DETROIT HOWELL CHAND FINDLAY OTTAWA DEHLER OREGON KAPIDS FUNT THOY ONEA TOLEDO BOWLING GREEN JACKSON LIVONIA PINNOT RVO : 70 DETROIT 53 30 39 25 110 At 14 130 2 10 INTRE 28 71 0 11 40 101 125 150 10 ORI SI 71 18 TINTON 11 154 1 WS 125 55 35 10 ISOWELL 80 100 125 18 SI 06 103 10 45 OF THOS 25 41 56 9 30 . 19 90 113 10 100 115 (6 150 130 3 333 = ROVALOAN 11 55 35 ST 13 0 VE 96 132 160 127 120 19 TOLEDO ty TOS 25 10 71 23 05 . SEL BOWLING GREEN 123 100 11 96 35 0 30 47 26 30 200 195 E HINDLAS 110 ON 100 SEI 140 122 50 oc :: SES 0 CE 24 13 OCE 202 OCE 110 185 VIVE 130 170 145 160 OPI F & 23 30 72 210 11 130 OR! NIIN 140 115 151 123 33 26 PE 33 2201 195 10 ORGON 65 SIL 100 05 13 73 10 33 72 0 200 15 19 GRAND 133 115 125 105 145 200 310 210 330 200 110 130 ! RAPID 145 VINDE IH RS 100 RO 16 120 155 173 200 IM 1 123 VIL MIN 18 TH 11 30 35 100 110 1 TH EH! VINOVE 20 1 ST 32 310 110 4 190 122 01 PELTH MF SL 24 OS 10 SH 114 30 = elelele 56 Sort Stops by distance and build routes - Use mileage charts (Load in computer routing model and save the headache) 57 Truck starts at Detroit location and first pick up should be farthest away. Have the driver work his way back. 58 Pick up all the stops % of Trailer based Pallets on per day Max availabl Round Weight Window 59 Route City/Stop State e Cube UP per day Floor Positions Window Minutes Miles 60 RT.1 Detroit MI 6:00 61 Stop 1 30.0 62 Stop 2 63 Stop 3 0.0 64 Stop 4 0.0 65 Stop 5 0.0 66 Stop 6 0.0 67 Stop 7 Detroit 0% 0 Miles 0 68 Stop 8 O Drive Time (min) 69 Stop 9 Total Minutes Time 30.0 0.5 Hours 70 RT.2 Detroit MI 71 Stop 1 0 72 Stop 2 0 73 Stop 3 0 74 0 75 0 76 0 77 Detroit MI 0% 0 Miles 0 78 Drive Time (min) 0 79 Total Minutes Time 0.0 0.0 Hours 80 RT 3 Detroit MI 81 Stop 1 0.0 82 Stop 2 0.0 83 Stop 3 0.0 84 0.0 85 0.0 86 0.0 87 Detroit MI 0% Miles 0 88 Drive Time (min) 0 89 Total Minutes Time 0.0 0.0 Hours Shant1 CL olol Inbound Transportation Problem You are a logistics analyst for a major third party logistics company which is the lead provider (LLP) for an assembly plant located in Detroit, Michigan. Your job is to design the most efficient truck routes possible for parts inbound daily to the assembly plant. The truck routes begin and end at the plant. The routes that you design must minimize the total distance traveled and the number of trucks used while complying with the U.S. Department of Transportation rules concerning the hours that drivers can be behind the wheel as presented in Figure 1. The plant must receive enough parts to meet its daily demand over a five day week. All of the trailers are 98 inches wide, 110 inches high and 53 feet long. The weight capacity of each trailer is 45,000 pounds. The truck travels at an average rate of speed of 1.25 minutes per mile and each stop to load parts and unload empty, returned containers takes 30 minutes. Figure 2 presents data on each of the parts coming from each supplier. For example, part AB is coming from a supplier located in Bowling Green, Ohio in a container called a standard pack, which holds 28 units. The container is 70 inches long, 39 inches wide, 45 inches high, weighs 480 pounds when full and can be stacked two high (one on the floor and one on top) but no higher. The plant requires 275 units of this part each day and it goes to zone three in the plant. The miles from and to all 16 points and Detroit are presented in Table 1. Assume that the parts are delivered to one central receiving point at the plant. MILES ROYAL CITY FENTON DETROIT HOWELL CHAND FINDLAY OTTAWA DEHLER OREGON KAPIDS FUNT THOY ONEA TOLEDO BOWLING GREEN JACKSON LIVONIA PINNOT RVO : 70 DETROIT 53 30 39 25 110 At 14 130 2 10 INTRE 28 71 0 11 40 101 125 150 10 ORI SI 71 18 TINTON 11 154 1 WS 125 55 35 10 ISOWELL 80 100 125 18 SI 06 103 10 45 OF THOS 25 41 56 9 30 . 19 90 113 10 100 115 (6 150 130 3 333 = ROVALOAN 11 55 35 ST 13 0 VE 96 132 160 127 120 19 TOLEDO ty TOS 25 10 71 23 05 . SEL BOWLING GREEN 123 100 11 96 35 0 30 47 26 30 200 195 E HINDLAS 110 ON 100 SEI 140 122 50 oc :: SES 0 CE 24 13 OCE 202 OCE 110 185 VIVE 130 170 145 160 OPI F & 23 30 72 210 11 130 OR! NIIN 140 115 151 123 33 26 PE 33 2201 195 10 ORGON 65 SIL 100 05 13 73 10 33 72 0 200 15 19 GRAND 133 115 125 105 145 200 310 210 330 200 110 130 ! RAPID 145 VINDE IH RS 100 RO 16 120 155 173 200 IM 1 123 VIL MIN 18 TH 11 30 35 100 110 1 TH EH! VINOVE 20 1 ST 32 310 110 4 190 122 01 PELTH MF SL 24 OS 10 SH 114 30 = elelele 56 Sort Stops by distance and build routes - Use mileage charts (Load in computer routing model and save the headache) 57 Truck starts at Detroit location and first pick up should be farthest away. Have the driver work his way back. 58 Pick up all the stops % of Trailer based Pallets on per day Max availabl Round Weight Window 59 Route City/Stop State e Cube UP per day Floor Positions Window Minutes Miles 60 RT.1 Detroit MI 6:00 61 Stop 1 30.0 62 Stop 2 63 Stop 3 0.0 64 Stop 4 0.0 65 Stop 5 0.0 66 Stop 6 0.0 67 Stop 7 Detroit 0% 0 Miles 0 68 Stop 8 O Drive Time (min) 69 Stop 9 Total Minutes Time 30.0 0.5 Hours 70 RT.2 Detroit MI 71 Stop 1 0 72 Stop 2 0 73 Stop 3 0 74 0 75 0 76 0 77 Detroit MI 0% 0 Miles 0 78 Drive Time (min) 0 79 Total Minutes Time 0.0 0.0 Hours 80 RT 3 Detroit MI 81 Stop 1 0.0 82 Stop 2 0.0 83 Stop 3 0.0 84 0.0 85 0.0 86 0.0 87 Detroit MI 0% Miles 0 88 Drive Time (min) 0 89 Total Minutes Time 0.0 0.0 Hours Shant1 CL olol