Question

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. 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.

SEE BELOW to reference the data.

Carrier	Previous Year On-Time Deliveries (%)	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 and answer the following questions.
	Which carrier is providing the best service in the current year?
	- Select your answer -Blue Box ShippingCheetah LLCGranite State CarriersHonsin LimitedJones BrothersMinuteman CompanyRapid ResponseSmith LogisticsSuper FreightItem 1
	Which carrier is providing the worst service in the current year?
	- Select your answer -Blue Box ShippingCheetah LLCGranite State CarriersHonsin LimitedJones BrothersMinuteman CompanyRapid ResponseSmith LogisticsSuper FreightItem 2
(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 carrier whose on-time percentage decreased from the previous year to the current year.
	(i) Carrier Jones Brothers Minuteman Company Smith Logistics (ii) Carrier Rapid Response Minuteman Company Super Freight (iii) Carrier Honsin Limited Granite State Carriers Super Freight Rapid Response (iv) Carrier Minuteman Company Granite State Carriers Super Freight Cheetah LLC
	- Select your answer -List (i)List (ii)List (iii)List (iv)Item 3
(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.
	(i) Carrier Jones Brothers Minuteman Company Smith Logistics (ii) Carrier Rapid Response Minuteman Company Super Freight (iii) Carrier Honsin Limited Granite State Carriers Super Freight (iv) Carrier Jones Brothers Blue Box Shipping Honsin Limited
	- Select your answer -List (i)List (ii)List (iii)List (iv)Item 4
(d)	Which carriers should Ohio Logistics try to use in the future? Why?
	The input in the box below will not be graded, but may be reviewed and considered by your instructor.
	DATA: 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%

Answer 1

a.

Select the Data in excel worksheet. Then select Sort. A dialog box will appear. Update the 'sort by; under heading ''column'' and 'order as ''largest to smallest'' The screenshot is givens :

The table below shows that Box shipping offer best current year on time Delivery.

Carrier	Previous Year On-Time Deliveries (%)	Current Year On-Time Deliveries (%)
Blue Box Shipping	88.4	94.8
Cheetah LLC	89.3	91.8
Smith Logistics	84.3	88.7
Granite State Carriers	81.8	87.6
Super Freight	92.1	86.8
Minuteman Company	91	84.2
Jones Brothers	68.9	82.8
Honsin Limited	74.2	80.1
Rapid Response	78.8	70.9

Above table shows Rapid response providing the worst service in the current year.

b) List 2 is the answer. Teh pic below highlights whose ontime delivey increased. and whose decreased.

c) From the above not colured figures we have: List (iv) is the answer

d) Answer is Blue Box Shipping.

Ohio logistics should use Blue Boxshipping as they got the highest in time delivery currently. Their on time delivery is at 94.8%, ,which is the highest of the lot.

Hope this will be helpful. Thanks and God Bless You :)