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 ? You may use total spent and frequency of shipments as two different metrics. Are the two lists the same? Why? (15 points) 3. How many TL carriers currently serve the top 5 TL origin-destination pairs? Do you have any suggestions for risk mitigation based on the number of carriers currently serving the top TL origindestination pairs? (15 points) 4. What is the average shipment size and length of haul for each carrier type? Based on these averages, do you have any general suggestions? (20 points) 5- For each carrier type, calculate the averages for on-time delivery, damagefree delivery, billing accuracy and cost and comment on these numbers. (30points) a. 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? b. How would you deal with billing accuracy, on time delivery and damaged goods issues? 6- Do you see any other opportunities for cost savings? Provide examples. (You may focus on top origin- destination pairs) (15 points)