Reference no: EM133039612
Boling Transportation, Inc., is a large distribution company located in Worcester, Mass. The company is currently seeking to gain operational efficiencies in its supply chain by reducing the number of transportation carriers it is using to outsource. Operational efficiencies for Boling Transportation, Inc., suggest that reducing the number of carriers from the Worcester distribution center to warehouses in the selected states will lead to reduced costs. Bo Fan, the CEO of Boling Transportation, requests the number of carriers transporting products from its Worcester distribution center to wholesalers in Arizona, Arkansas, Iowa, Missouri, Montana, Oklahoma, Oregon, and Washington be reduced from the current five carriers to two carriers.
Carrier selection should be based on the assumptions that all environmental factors are equal and historical cost trends will continue. Review the historical data from the past several years to determine your recommendation for the top two carriers that Boling Transportation should continue to use.
1. Analyze the last 24 months of Boling's Transportation carrier transactions found in the attached Excel data file.
2. Make report detailing your recommendation for the top two carriers with which Boling Transportation should continue to do business. Be sure to use PivotTables and PivotCharts in your report.
A few questions to get you started include:
- What is the average cost per carrier?
- What are the total shipping costs per state?
- What are the total shipping weights per state?
- What are the average shipping costs per pound?
- What is the average cost per carrier?