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. Suppose 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. Carrier Previous Year On-Time Deliveries (%) Current Year On- Time Deliveries (%) Blue Box Shipping 94.9 Cheetah LLC 89.4 91.7 Granite State Carriers 81.9 87.5 Honsin Limited 74.1 80.2 Jones Brothers 69,0 82.7 Minutemen Company 90.9 84.3 Rapid Response 78.7 71.0 Smith Logistics 84.4 88.6 Super Freight 92.0 86.9 (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? -. Blue Box Shipping Cheetah LLC Granite State Carriers OHonsin Limited Ojones Brothers OMinutemen Company ORapid Response OSmith Logistics OSuper Freight Which carrier is providing the worst service in the current year? OBlue Box Shipping Cheetah LLC Granite State Carriers OHonsin Limited Ojones Brothers O Minuteren Company Rapid Response OSmith Logistics OSuper Freight (b) Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Indicate whether or not a carrier's on-time percentage decreased from the previous year to the current year. (Use current previous.) Carrier Change in On- Time Percentage Increase/ Decrease Blue Box Shipping % ---Select--- V Cheetah LLC % ---Select--- V Granite State Carriers % ---Select--- V Honsin Limited % ---Select--- V Jones Brothers % ---Select--- Minutemen Company % ---Select--- V Rapid Response % ---Select--- V Smith Logistics % ---Select--- V Super Freight % ---Select--- V (c) Use Excel's conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part (b). Choose the appropriate bar chart that summarizes your results. % Change from % Change from % Change from % Change from Previous Year to Current Previous Year to Current Previous Year to Current Previous Year to Current 1 1 1 - 10 10 . - 15 10 10 BBS BBS BBS BBS CLLC CLLC CLLC CLLC GSC GSC GSC GSC HL HL HL HL | JB JB JB JB MC MC MC MC RR RR RR RR SL SL SL SL SF SF SF SF (d) Which carriers should Ohio Logistics try to use in the future? Why? They should use Super Freight, Minutemen Company, and Cheetah LLC since they have the three highest on-time delivery percentages in the current year. They should use Super Freight, Minutemen Company, and Rapid Response since they have the three highest increases in on-time percentage from the previous year to the current year. They should use Jones Brothers, Blue Box Shipping, and Honsin Limited since they have the three highest increases in on-time percentage from the current year to the previous year. They should use Minutemen Company, Rapid Response, and Jones Brothers since they have the three highest changes in on-time percentage from the previous year to the current year. O They should use Blue Box Shipping, Cheetah LLC, and Smith Logistics since they have the three highest on-time delivery percentages in the current year. 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. Suppose 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. Carrier Previous Year On-Time Deliveries (%) Current Year On- Time Deliveries (%) Blue Box Shipping 94.9 Cheetah LLC 89.4 91.7 Granite State Carriers 81.9 87.5 Honsin Limited 74.1 80.2 Jones Brothers 69,0 82.7 Minutemen Company 90.9 84.3 Rapid Response 78.7 71.0 Smith Logistics 84.4 88.6 Super Freight 92.0 86.9 (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? -. Blue Box Shipping Cheetah LLC Granite State Carriers OHonsin Limited Ojones Brothers OMinutemen Company ORapid Response OSmith Logistics OSuper Freight Which carrier is providing the worst service in the current year? OBlue Box Shipping Cheetah LLC Granite State Carriers OHonsin Limited Ojones Brothers O Minuteren Company Rapid Response OSmith Logistics OSuper Freight (b) Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Indicate whether or not a carrier's on-time percentage decreased from the previous year to the current year. (Use current previous.) Carrier Change in On- Time Percentage Increase/ Decrease Blue Box Shipping % ---Select--- V Cheetah LLC % ---Select--- V Granite State Carriers % ---Select--- V Honsin Limited % ---Select--- V Jones Brothers % ---Select--- Minutemen Company % ---Select--- V Rapid Response % ---Select--- V Smith Logistics % ---Select--- V Super Freight % ---Select--- V (c) Use Excel's conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part (b). Choose the appropriate bar chart that summarizes your results. % Change from % Change from % Change from % Change from Previous Year to Current Previous Year to Current Previous Year to Current Previous Year to Current 1 1 1 - 10 10 . - 15 10 10 BBS BBS BBS BBS CLLC CLLC CLLC CLLC GSC GSC GSC GSC HL HL HL HL | JB JB JB JB MC MC MC MC RR RR RR RR SL SL SL SL SF SF SF SF (d) Which carriers should Ohio Logistics try to use in the future? Why? They should use Super Freight, Minutemen Company, and Cheetah LLC since they have the three highest on-time delivery percentages in the current year. They should use Super Freight, Minutemen Company, and Rapid Response since they have the three highest increases in on-time percentage from the previous year to the current year. They should use Jones Brothers, Blue Box Shipping, and Honsin Limited since they have the three highest increases in on-time percentage from the current year to the previous year. They should use Minutemen Company, Rapid Response, and Jones Brothers since they have the three highest changes in on-time percentage from the previous year to the current year. O They should use Blue Box Shipping, Cheetah LLC, and Smith Logistics since they have the three highest on-time delivery percentages in the current year