Scheduled Loads for the Kansas City MO Distribution Center
Inbound Loads		Outbound Loads
Origin City	Weight	Arrival Date		Destination	Weight	Delivery Date
Baltimore MD	8,770	5/7		Allentown PA	31,229	5/9
Los Angeles CA	17,285	5/11		Dallas TX	4,241	5/13
Flagstaff AZ	15,948	5/6		Ogden UT	8,594	5/9
Detroit MI	8,677	5/12		Baltimore MD	19,188	5/11
Carson City NV	12,152	5/11		Kokomo IN	6,557	5/9
South Bend IN	12,317	5/12		Albany NY	13,499	5/12
Portland OR	12,392	5/12		Richmond VA	23,156	5/15
Gary IN	25,251	5/9		Scranton PA	13,751	5/5
St. Louis MO	12,060	5/11		Boston MA	10,037	5/11
Toledo OH	10,085	5/13		Olympia WA	16,881	5/12
Ann Arbor MI	13,863	5/7		Kansas City MO	13,898	5/5
St. Louis MO	17,807	5/5		Kokomo IN	12,748	5/15
Boca Raton FL	16,701	5/9		Wilmington DE	10,925	5/10
Flagstaff AZ	10,537	5/15		Canton OH	16,052	5/6
Birmingham AL	7,999	5/15		Billings MT	14,472	5/15
Elkhart IN	21,575	5/12		Wilmington DE	11,804	5/5
Akron OH	18,950	5/8		Palo Alto CA	13,458	5/12
Cleveland OH	12,228	5/5		Philadelphia PA	22,004	5/10
Saginaw MI	16,682	5/10		Elkhart IN	16,628	5/6
Cary NC	14,098	5/10		Dallas TX	8,534	5/14

For each of the (15) consolidated shipments, use the Freight Rate Calculator to estimate the cost of the consolidated shipment, along with the savings realized through consolidation. 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.

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 10% surcharge for each additional stop.For inbound/outbound consolidation, use a discount of 50% of the shortest original run.

For each consolidation, explain why that consolidation is feasible and within required conditions.

For both vehicle and inbound/outbound consolidation, identify an example that appears feasible, but violates one or more of the required conditions.