1.Who are the top 5 TL carriers (in terms of total spent)? (5 points)

2.What are the top 5 origin-destination pairs for TL shipments? Use both total spent and frequency of shipments as two different metrics. Are the two lists the same? Why or why not? (10 points)

3.What are the top 10 origin-destination pairs for LTL shipments? Use both total spent and frequency of shipments as two different metrics. Are the two lists the same? Why or why not? (10 points)

4.How many TL carriers currently serve each of the top 5 TL origin-destination pairs? You may use any of the metrics, e.g. total spent or frequency of shipments. Do you have any suggestions for risk mitigation based on the number of carriers currently serving the top TL origin-destination pairs? (15 points)

5.What is the average shipment size and length of haul for each carrier type? Based on these averages, do you have any general suggestions?(15 points)

6.For each carrier type, calculate the averages for on-time delivery, damage-free delivery, billing accuracy and cost and comment on these numbers.(30points)

1. Based on your calculations, do you have any recommendations to improve transportation planning for Blue Star? Explain the way how these suggestions would be actualized?
2. How would you deal with billing accuracy, on time delivery and damaged goods issues?

7. Do you see any other opportunities for cost savings? Provide examples using the data and graphs. (You may focus on top origin-destination pairs) (15 points)