Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers
Question:
The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous year.
a. Sort the carriers in descending order by their current year€™s on-time percentage. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year?
b. Calculate the change in on-time percentage from the previous to the current year for each carrier. Use Excel€™s conditional formatting to highlight the carriers whose on time percentage decreased from the previous year to the current year.
c. Use Excel€™s conditional formatting tool to create data bars for the change in on-time percentage from the previous year to the current year for each carrier calculated in part b.
d. Which carriers should Ohio Logistics try to use in the future? Why?
Step by Step Answer:
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams