Carrier Previous Year On-Time Current Year On-Time Deliveries (%) Deliveries (%) Blue Box Shipping 88.4 94.8 Cheetah LLC 89.3 92.8 Granite State Carriers 81.8 87.6 Honsin United 74,2 80.1 Jones Brothers 68.9 828 Minuteman Company 910 842 Rapid Response 76,5 70.9 Smith Logistics 84.3 882 Super Freight 921 86.8 (a) Sort the carriers in descending order by their current year's percentage of on-time deliveries and answer the following questions Which carrier is providing the best service in the current year? Select your answer Which carrier is providing the worst service in the current year? Select your answer (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 tool to choose the correct list of care whose on-time percentage decreased from the previous year to the current year Carrier (8) Carrier Jones Brothers Rapid Response Minuteman Company Minuman Company Smith Logistics Super Freight AZ (iv) (151) Carrier Carrier Monsin United Minuman Company Granite State Carriers Granite State Cane Super Freight Super FM Rapid Response Chetan LC Select your answer (c) Use the conditional format to create dita sort for the percentage of on-time deliveriet from the previous year to the current year for each camere part Choose the core of top laers whose on time percentage increased from the previous year to the current year Carrier Carrier Isones brothers Bad Hes teman Company Minuman Carro Superrt (10) ( Carrier (iv) Carrier your answer (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 correct list of top 3 carriers whose on-time percentage increased from the previous year to the current year (0) Carrier (li) Carrier Jones Brothers Rapid Response Minuteman Company Minuteman Company Smith Logistics Super Freight (10 Carrier (iv) Carrier Hansin Limited Jones Brothers Granite State Carriers Blue Box Shipping Super Freight Hon Limited - Select your answer. (d) Which carriers should hologists try to use the ture? WWW They should use - Select your answer percentages in the current year since they have the three Nighesto time delivery Chede My work remaining A