Question: table [ [ Carrier , table [ [ Previous Year On - Time ] , [ Deliveries ( % ) ] ] ,

\table[[Carrier,\table[[Previous Year On-Time],[Deliveries (%)]],\table[[Current Year On-Time],[Deliveries (%)]]],[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]]
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 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 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?
 \table[[Carrier,\table[[Previous Year On-Time],[Deliveries (%)]],\table[[Current Year On-Time],[Deliveries (%)]]],[Blue Box Shipping,88.4,94.8],[Cheetah LLC,89.3,91.8],[Granite State

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!