Project Title University Logo Sponsor Logo Project Project

Project Title University Logo Sponsor Logo Project # Project Team Principal Investigator Co-Principal Investigator Graduate Assistant Undergraduate Assistant Motivation (Problem that motivated the research – words or pictures. ) name (s) Expected Results (Easy to understand description of the key results – words or pictures. ) n n Provides DC manager with information on LTL loads to consolidate for TL shipment Only creates loads that TL carriers will accept Deliveries meet customer requirements Interfaces with order entry system so no manual data entry required Transportation costs for frequent deliveries from a DC to customers can be dramatically reduced by optimized mode selection and load consolidation. Some Details (… not just a bunch of equations) n n n Tool runs in Excel Algorithm-based for good but not necessarily optimal solutions Includes customer constraints n Days and time of day deliveries can be made Includes constraints of TL carriers n No more than 2 stops n Stops < 50 miles apart Interfaces with order entry system so data automatically collected Broader Applicability (Where the results can the be used; keys to adapting) n n n Can be used if multiple shipments are sent LTL or parcel each day from a single location Requires distances between all customers be determined an input file created Model must be given the order information