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:

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 table 1 and 2 information? (In your answer, describe at least three actions.)

Here is the type of graph requested.

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