a. Sort the carriers in descending order by their current year’s percentage of on-time deliveries. 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 the percentage of on-time deliveries 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 the percentage of on-time deliveries 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?
| Carrier | Previous Year On-time Percentage | Current Year On-time Percentage |
| Blue Box Shipping | 88.4% | 86.8% |
| Cheetah LLC | 89.3% | 86.8% |
| Granite State Carriers | 81.8% | 86.8% |
| Honsin Limited | 74.2% | 86.8% |
| Jones Brothers | 68.9% | 86.8% |
| Minuteman Company | 91.0% | 86.8% |
| Rapid Response | 78.8% | 86.8% |
| Smith Logistics | 84.3% | 86.8% |
| Super Freight | 92.1% | 86.8% |
Ohio Logistics manages the logistical activities for firms by matching companies that
need products shipped with carriers that can provide the best rates and best service for
the companies. Ohio Logistics is very concerned that its carriers deliver their customers’
material on time, so it carefully monitors the percentage of on-time deliveries. The
following table contains a list of the carriers used by Ohio Logistics and the
corresponding on-time percentages for the current and previous years. (Please refer to
the Carriers Data file)
a. Sort the carriers in descending order by their current year’s percentage of on-time
deliveries. 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 the percentage of on-time deliveries 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 the percentage
of on-time deliveries 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?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
