Question: table [ [ Carrier , table [ [ Previous Year On - Time ] , [ Deliveries ( % ) ] ] ,
tableCarriertablePrevious Year OnTimeDeliveries tableCurrent Year OnTimeDeliveries Blue Box Shipping,Cheetah LLCGranite State Carriers,Honsin Limited,Jones Brothers,Minuteman Company,Rapid Response,Smith Logistics,Super Freight,
a Sort the carriers in descending order by their current year's percentage of ontime 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 ontime deliveries 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 percentage of ontime 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?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
