Chapter 9, Problem 4PB

Assume you are the manager for the semi-trucks division at the Speedy Delivery Company. The semi-truck division is a cost center and you are reviewing the driver overtime costs for the previous year, shown here:

A. Microsoft Excel or another spreadsheet application, create a line chart with markers showing the driver overtime expense. Describe your observations.

B. Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you decide to talk with the safety manager and obtained the following information:

Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the average snowfall and non-company highway accidents. Describe your observations and actions you might consider.