Motor Racer Pty Ltd is a manufacturer of timing components for speedways. The company's accountant, Casey...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Motor Racer Pty Ltd is a manufacturer of timing components for speedways. The company's accountant, Casey Stoner is concerned with maintenance technician costs and has recently compiled the costs for the firm's Maintenance Department. He used the technician hours to quantify the Department's activity. Casey presents the following data for analysis. Month July August September October November December January February March April May June Technician hours 1,200 1,600 1,800 1,330 1,700 1,600 1,400 1,350 1,460 1,660 1,700 1,500 Maintenance costs $62,500 $78,150 $83,000 $65,800 $79,900 $72,250 $66,600 $63,550 $69,110 $73,800 $79,500 $70,250 Required: Note all calculations are to be rounded to nearest cents 1. Using the high-low method, calculate; a. Determine the highest point, the lowest point and the maintenance costs at theses points b. The variable cost per unit of cost driver, c. The fixed cost, and d. Write the cost equation based on high-low method. 2. Casey wants to predict next month's maintenance cost using the high low cost equation. How much will be the maintenance costs when technician hours total 1,550. 3. Construct an Excel® spreadsheet and use least squares regression analysis to estimate the Maintenance Department's: a. Variable cost per unit of cost driver b. Fixed cost, and c. Cost equation for the department's costs. d. When is multiple regression required to explain cost behaviour? 4. What if Casey wants to use regression analysis cost formulae in Part 3 (c) to estimate maintenance cost for next month when he expects technician's hours to be 1,550. How much will be the estimated maintenance cost? 5. Explain the significance of the coefficient of determination measures for cost formulas. Why should these measures be considered when using the method of least squares? 6. Describe the method of least square. Why does the cost prediction estimate using the high-low and regression methods differ? Which method would you recommend? Justify your answer. Motor Racer Pty Ltd is a manufacturer of timing components for speedways. The company's accountant, Casey Stoner is concerned with maintenance technician costs and has recently compiled the costs for the firm's Maintenance Department. He used the technician hours to quantify the Department's activity. Casey presents the following data for analysis. Month July August September October November December January February March April May June Technician hours 1,200 1,600 1,800 1,330 1,700 1,600 1,400 1,350 1,460 1,660 1,700 1,500 Maintenance costs $62,500 $78,150 $83,000 $65,800 $79,900 $72,250 $66,600 $63,550 $69,110 $73,800 $79,500 $70,250 Required: Note all calculations are to be rounded to nearest cents 1. Using the high-low method, calculate; a. Determine the highest point, the lowest point and the maintenance costs at theses points b. The variable cost per unit of cost driver, c. The fixed cost, and d. Write the cost equation based on high-low method. 2. Casey wants to predict next month's maintenance cost using the high low cost equation. How much will be the maintenance costs when technician hours total 1,550. 3. Construct an Excel® spreadsheet and use least squares regression analysis to estimate the Maintenance Department's: a. Variable cost per unit of cost driver b. Fixed cost, and c. Cost equation for the department's costs. d. When is multiple regression required to explain cost behaviour? 4. What if Casey wants to use regression analysis cost formulae in Part 3 (c) to estimate maintenance cost for next month when he expects technician's hours to be 1,550. How much will be the estimated maintenance cost? 5. Explain the significance of the coefficient of determination measures for cost formulas. Why should these measures be considered when using the method of least squares? 6. Describe the method of least square. Why does the cost prediction estimate using the high-low and regression methods differ? Which method would you recommend? Justify your answer.
Expert Answer:
Answer rating: 100% (QA)
Using the highlow method a To determine the highest and lowest points we look at the technician hours and maintenance costs provided Highest point Technician hours 1800 Maintenance costs 83000 Lowest ... View the full answer
Related Book For
Financial Theory and Corporate Policy
ISBN: 978-0321127211
4th edition
Authors: Thomas E. Copeland, J. Fred Weston, Kuldeep Shastri
Posted Date:
Students also viewed these accounting questions
-
The Jordan Corporation is a manufacturer of heavy-duty trucks. Because of a low internal profitability rate and lack of favorable investment opportunities in the existing line of business, Jordan is...
-
Marshall Manufacturing Ltd is a manufacturer of fuel injection systems for the automotive industry. At the beginning of the current financial year, Marshall Manufacturing Ltd entered an agreement...
-
Farm Fresh Ltd is a manufacturer of farm equipment that is sold by a network of distributors across Australia and New Zealand. The Service Division manufactures spare parts for the various models of...
-
Suppose there are 50 companies in a commercial building. Initially there is no automatic fire sprinkler system in the public area of the building. Each company has identical individual demand curve...
-
A company financed a plant expansion of $750 000 at 9% compounded annually. The financing agreement requires annual payments of interest and the funding of the debt through equal annual payments for...
-
Presented below is an aging schedule for Halleran Company. At December 31, 2014, the unadjusted balance in Allowance for Doubtful Accounts is a credit of $12,000. Instructions (a) Journalize and post...
-
True or False: The following annual cash flows in years 1 thru 7, respectively, have a single real positive-valued root: \(-\$ 100,+\$ 15,-\$ 25,+\$ 75,-\$ 10,+\$ 50\), \(+\$ 50\).
-
Christie Levine is the manager of the Instant Paper Clip Office Supply Company in Louisville. The company attempts to gain an advantage over its competitors by providing quality customer service,...
-
A. Find the value of x. B. 1. 2. 61 = x ( mod 7) 71 = x ( mod 8) 3. 78 x 3 (mod 5) 4. 89 = (x+3)( mod 4) 1. What is the remainder when 2021 2021 2020? is divided by
-
Chumpy Lighting Limited manufactures a wide variety of light bulbs which it sells to lighting shops and builders merchants through wholesale distributors. It also sells direct to the big UK...
-
Emmett is a 32 year old Caucasian man. He has been referred to a psychologist by his GP. His current problems seemed to start a few months ago. About six months ago, Emmett got a promotion in his job...
-
The interior of a Boeing 737-800 can be modeled as a 32-m-long,3.7-m-diameter cylinder. The air inside, at cruising altitude, is20 o C at a pressure of 82 kPa. What volume of outside air, at -40 o C...
-
Explain how definite integral work using two simple examples and a brief explanation of why is important to our daily lives.
-
A family is on a road trip. The speed limit during the first 160 miles of the trip is 60 mph, and the speed limit during the last 245 miles is 75 mph. How many miles per hour over the speed limits...
-
Consider a single-output, non-preemptive queueing system. It has three queues connected to the single output, and packets in the queues are handled based on a strict-priority order. The three queues...
-
Find a set where differentiability is guaranteed and explain why.
-
There is much open access to the Hudson River, and GE in the past poured dangerous pollutants (PCV's) into the River. Which of the following options describe both the transaction and free rider costs...
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
A project runs for two periods and then is sold at a fair price. Its present value without flexibility is $30 million, and the initial investment is $20 million. The annual volatility of the...
-
Calculate the internal rate of return on the following set of cash flows, according to the economic interpretation of internal rate of return near the end of Section F.3. Assume that the opportunity...
-
Graphically analyze the effect of an exogenous decrease in the interest rate on (a) The utility of borrowers and lenders (b) The present wealth of borrowers and lenders (c) The investment in real...
-
What is the difference between short-term and long-term capital?
-
A business is considering two type of containers to package its product, one made of plastic and the other of biodegradable cardboard with native wild flower seeds embedded in the packaging, designed...
-
Complete the crossword puzzle below: Clues Across 2 Amount of uncertainty that exists about the future operations of a business 4 The V in CVP analysis 6 The amount provided by the sale of a product...
Study smarter with the SolutionInn App