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:
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 some pointers for effectively handling questions during presentations.
-
How long ago was the Carboniferous?
-
a. Two balls move as shown in Figure Q27.3. What are the speed and direction of each ball in a reference frame that moves with ball 1 ? b. What are the speed and direction of each ball in a reference...
-
Camacho Chemical Company uses an average cost processing system. All materials are added at the start of the production process. Labor and overhead are added evenly at the same rate throughout the...
-
c) Compute the net quantities needed if there are 25 of the base and 75 of the clamp in stock. Base: Spring: Clamp: Housing: Handle: Casting: Bearing: Shaft: units (enter your response as a whole...
-
Jerry Stevenson is the manager of a medical clinic in Scottsdale, AZ. He wants to analyze patient data to identify high-risk patients for cardiovascular diseases. From medical literature, he learned...
-
Compare and Contrast Managerial Accounting and Financial Accounting. Be sure to discuss how managerial accounting is useful for providing information for at least one of the following management...
-
1. If a bank has a required reserve ratio of 25% and you put $500 cash that you have had in the cookie jar into a checking account at the bank, how much of that cash can the bank loan out to a...
-
9. Zach took $200,000 out of the bank and used it to start his new cookie business. The bank account pays 3 percent interest per year. During the first year of his business, Zach sold 17,000 boxes of...
-
Suppose a particular type of car is expected to lose about 7 . 1 % of its value every year.Suppose you purchased the car for $ 2 5 6 9 1 . How much would the car be worth after 7 years?
-
Listed below are transactions dealing with various stock benefit plans of Fortune-Time Corporation during the period 2024-2026. The market price of the stock is $45 at January 1, 2024. a. On January...
-
Sedki earned $180,480 in 2017. How much did he pay in Social Security taxes? In Medicare taxes? In total FICA taxes? (Hint: Don't forget the annual Social Security earnings cap.) The amount Sedki...
-
You borrowed $325000 using a 30- year fixed rate mortgage with a 5.25% interest rate: A) What is your schedule monthly payment? B) What is the amount of interest and principal paid with the first...
-
Write a paper about the Working relationship in the organization- collaboration within and outside the organization
-
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...
-
The financial records of Dunbar Inc. were destroyed by fire at the end of 2015. Fortunately, the controller had kept the following statistical data related to the income statement. 1. The beginning...
-
Maher Inc. reported income before income tax during 2015 of 790,000. Additional transactions occurring in 2015 but not considered in the 790,000 are as follows. 1. The corporation experienced an...
-
Presented below is the trial balance of Thompson Corporation at December 31, 2015. Instructions Prepare an income statement and a retained earnings statement. Assume that the only changes in retained...
Study smarter with the SolutionInn App