Homework answers / question archive / Project 20: Operational Efficiencies Hoover Transportation, Inc

Project 20: Operational Efficiencies Hoover Transportation, Inc

MS Excel

Share With

Project 20: Operational Efficiencies

Hoover Transportation, Inc., is a large distribution company located in Denver, Colorado. 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 Hoover Transportation Inc., suggest that reducing the number of carriers from the Denver distribution center to warehouses in the selected states will lead to reduced costs. Brian Hoover, the CEO of Hoover Transportation, requests the number of carriers transporting products from its Denver 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 Hoover Transportation should continue to use.

1. Analyze the last 24 months of Hoover's Transportation carrier transactions found in the AYK20_ Data.xlsx data file.

2. Create a report detailing your recommendation for the top two carriers with which Hoover 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?