Assume you are the manager of 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:

Instructions

1. Use Microsoft Excel to create a line chart with markerLinks to an external site showing the driver overtime expense (table 1). Describe your observations of Table 1.

2. Use Microsoft Excel to create individual line charts with markersLinks to an external site. Showing the average snowfall and non-company highway accidents (table 2). Describe your observations of Table 2. (Hint: Create a line chart individually for average snowfall and a separate one for non-company highway accidents.)

3. As a manager of this cost center, what actions would you consider after viewing the line graphs from Tables 1 and 2 information? (In your answer, describe at least three actions.)

Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you dec to talk with the safety manager and obtained the following information: Table 2: Snowfall-Accident Relationship Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you dec to talk with the safety manager and obtained the following information: Table 2: Snowfall-Accident Relationship