Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 2, Problem 3P
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 years.
- 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?
Expert Solution & Answer
Trending nowThis is a popular solution!
Chapter 2 Solutions
Essentials Of Business Analytics
Ch. 2 - A Wall Street Journal subscriber survey asked 46...Ch. 2 - The following table contains a partial list of...Ch. 2 - Ohio Logistics manages the logistical activities...Ch. 2 - A partial relative frequency distribution is...Ch. 2 - In a recent report, the top five syndicated...Ch. 2 - In a study of how chief executive officers (CEOs)...Ch. 2 - Consumer complaints are frequently reported to the...Ch. 2 - Reports have found that many U.S. adults would...Ch. 2 - Consider the following data: a. Develop a...Ch. 2 - Consider the following frequency distribution....
Ch. 2 - The owner of an automobile repair shop studied the...Ch. 2 - Approximately 1.65 million high school students...Ch. 2 - Consider a sample with data values of 10, 20, 12,...Ch. 2 - Consider a sample with data values of 27, 25, 20,...Ch. 2 - Consider a sample with data values of 53, 55, 70,...Ch. 2 - If an asset declines in value from 5,000 to 3,500...Ch. 2 - Suppose that you initially invested 10,000 in the...Ch. 2 - The average time that Americans commute to work is...Ch. 2 - Suppose that the average waiting time for a...Ch. 2 - According to the National Education Association...Ch. 2 - Return to the waiting times given for the...Ch. 2 - The results of a national survey showed that on...Ch. 2 - Suppose that the national average for the math...Ch. 2 - Five observations taken for two variables follow....Ch. 2 - The scatter chart in the following figure was...Ch. 2 - The economic downturn in 20082009 resulted in the...Ch. 2 - Heavenly Chocolates manufactures and sells quality...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY