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: Table 1: Overtime Costs Driver overtime SPEEDY DELIVERY COMPANY Cost Center Data-Semi-Truck Division Jan. $150,000 July $91,165 Feb. $172,500 Average snowfall (inches) Non-company highway accidents Aug. $82,048 Jan. 15 128 Mar. $103,500 July 0 78 Apr. $104,535 Oct. Nov. Sep. $69,741 $87,177 $135,124 Driver overtime 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: Table 2: Snowfall-Accident Relationship Feb. 12 70 Aug. 0 83 Mar. 2 42 Sep. 0 53 May $106,626 Apr. 0 38 Oct. 2 35 May 0 35 June $95,963 Nov. 35 208 Dec. $243,222 June 0 56 Dec. 62 423 Average snowfall (inches) Non-company highway accidents Instructions 1. Use Microsoft Excel to create a line chart with markeres showing the driver overtime expense (table 1). Describe your observations of table 1. 2. Use Microsoft Excel to create individual line charts with markers e 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.)