Assume you are the manager for the semi-trucks division at the Speedy Delivery Company. The semi-truck...
Fantastic news! We've Found the answer you've been seeking!
Question:
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2022/12/63a7e62c61b82_1671947817029.jpg)
Transcribed Image Text:
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.) 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.)
Expert Answer:
Answer rating: 100% (QA)
Answer After September the Overtime Cost increases Average Snow Fall increases and Nonc... View the full answer
Related Book For
Managerial Accounting A Focus on Ethical Decision Making
ISBN: 978-0324663853
5th edition
Authors: Steve Jackson, Roby Sawyers, Greg Jenkins
Posted Date:
Students also viewed these general management questions
-
Assume you are the manager of an LLC sole proprietorship. You have assets of $500,000 and liabilities of $300,000. Your current and quick ratios are above 1.0. You have an opportunity for your LLC...
-
Assume you are the manager for a Hard Rock Caf. Your boss has asked you to evaluate how the company is using its Web site to gather customer data. Go to the Web site for the Hard Rock (...
-
You are the manager for a product whose sales have been flat for the last five years. However, the brands market share has been declining at about 3% a year. How would you diagnose this decline?
-
In order to evaluate lim f(a+h)-f(), it is necessary to evaluate f(a + h). h xa For f(x) = x 3, f(a+h) =
-
List seven guidelines to follow in developing an organizational chart.
-
An obstruction is lodged in a 10-ft wide rectangular channel ( n = 0. 022) that has a bottom slope of 0.005. The depth of the channel just upstream of the obstruction is 5 . 0 feet. If the flow rate...
-
What is meant by refunding?
-
Stagg Construction Co. is leasing equipment from Cloud Inc. The lease calls for payments of $50,000 a year plus $3,000 a year executory costs for five years. The first payment is due on January 1,...
-
Required information [The following information applies to the questions displayed below.] Thrillville has $40.5 million in bonds payable. One of the contractual agreements in the bond is that the...
-
The Royal Seas Company runs a three-night cruise to the Caribbean from Port Canaveral. The company wants to run TV ads promoting its cruises to high-income men, high-income women, and retirees. The...
-
THE FIRST ONE WITHOUT AN IDE AND THE SECOND ONE WITH AN IDE Task Description complete a Java application to draw different shapes with the specified color and size, subject to the following...
-
Required information [The following information applies to the questions displayed below.] Arndt, Incorporated reported the following for 2024 and 2025 ($ in millions): Revenues Expenses 2024 $ 946...
-
A buyer with a $750,000 loan has a monthly principal and interest payment of $4,376.80. If $3,593.75 is interest, what is the new principal balance after the first payment is applied?
-
A bare module cost is needed for a stainless steel clad distillation column (pressure vessel) with a diameter of 10 feet and a height of 45 feet. The operating pressure is 12 barg. Determine the...
-
The Fire Safety Check sheet can be of use to develop or evaluate a fire safety management policy. Go through the checklist while you reflect on your current or previous company, and discuss the...
-
Stealth bank has deposits of $700 million. It holds reserves of $20 million and has purchased government bonds worth $350 million. The banks loans, if sold at current market value, would be worth...
-
Link to Minitab Chrome Page: (http://app.minitab.comLinks to an external site.) Use online software for this assignment. Question Set 1: Chi-Square Goodness-of-Fit. A representative sample of 66...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
The Hemp Division of West Company produces rope. One-third of the Hemp Divisions output is sold to the Hammock Products Division of West; the remainder is sold to outside customers. The Hemp...
-
It is often said that accounting is the language of business. If that statement is true, business students should be knowledgeable about that language. Consider the following terms commonly used in...
-
Tennessee Welding and Supplys controller, Tina Bynum, developed new product costs for the companys standard, deluxe, and heavy-duty model welders using activity-based costing. It was apparent that...
-
Use Laplace transforms to convert the following nonhomogeneous systems of differential equations into an algebraic system, and find the solutions of the differential equations. a. \[\begin{aligned}...
-
Consider the series circuit in Problem 2. 20 and in Figure 2. 7 with \(L=\) \(1.00 \mathrm{H}, R=1.00 \times 10^{2} \Omega, C=1.00 \times 10^{-4} \mathrm{~F}\), and \(V_{0}=1.00 \times 10^{3}...
-
Use Laplace transforms to prove \[\sum_{n=1}^{\infty} \frac{1}{(n+a)(n+b)}=\frac{1}{b-a} \int_{0}^{1} \frac{u^{a}-u^{b}}{1-u} d u\] Use this result to evaluate the following sums: a....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App