40%(5)2 out of 5 people found this document helpful
This preview shows page 1 out of 1 page.
SCM-476, Spring 2018-Sections 1 and 2BlueStar Office Supply CompanyRead the pdf file and use the data in the Excel file to answer the questions below. Ignore the questions at the endof the case study pdf file.Write a concise report. Using bullet points in the answer is acceptable but your answers need to be complete andcoherent, not requiring further explanation. The write-up should be prepared in MS Word or equivalent. Youmay use MS Excel or Access to do the analysis. In Excel, you should use pivot tables since it will make your jobvery easy.Questions1.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)