Ohio Logistics manages the logistical activities for firms by matching companies thatneed products shipped with carriers that can provide the best rates and best service for thecompanies. Ohio Logistics is very concerned that it uses carriers that get their customers’material delivered on time, so it carefully monitors its carriers’ on-time percentage of deliveries.The following table contains a list of the carriers used by Ohio Logistics and thecorresponding on-time percentages for the current and previous year.CarrierPrevious Year On-TimePercentage (%)Current Year On-TimePercentage (%)Blue Box Shipping 88.4 94.8Cheetah LLC 89.3 91.8Granite State Carriers 81.8 87.6Honsin Limited 74.2 80.1Jones Brothers 68.9 82.8Minuteman Company 91.0 84.2Rapid Response 78.8 70.9Smith Logistics 84.3 88.7Super Freight 92.1 86.8 Sort the carriers in descending order by their current year’s on-time percentage. Whichcarrier is providing the best service in the current year? Which carrier is providing theworst service in the current year?b. Calculate the change in on-time percentage from the previous to the current year foreach carrier. Use Excel’s conditional formatting to highlight the carriers whose ontimepercentage 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-timepercentage 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?
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 it uses carriers that get their customers’
material delivered on time, so it carefully monitors its carriers’ on-time percentage of 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 year.
Carrier
Previous Year On-Time
Percentage (%)
Current Year On-Time
Percentage (%)
Blue Box Shipping 88.4 94.8
Cheetah LLC 89.3 91.8
Granite State Carriers 81.8 87.6
Honsin Limited 74.2 80.1
Jones Brothers 68.9 82.8
Minuteman Company 91.0 84.2
Rapid Response 78.8 70.9
Smith Logistics 84.3 88.7
Super Freight 92.1 86.8
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 ontime
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?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
