The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable components of its monthly manufacturing overhead costs. The company wishes to use machine hours as its measure of activity and has gathered the following data: Machine Hours Overhead Costs 2018 January 21,000 $84,000 February 25,000 $100,000 March 22,000 $89,500 April 23,000 $90,000 May 20,500 $81,500 June 19,000 $75,500 July August September 14,000 S70,500 10,000 $6,500 12,000 $69,000 October 17,000 S75,000 November 16,000 $71,500 December 2019 January 18,500 21,000 $77,000 $86,000 February 24,000 $93,000 March 23,000 $93,000 April 22,000 $87,000 May 20.000 $78,000 June 18,000 $76,500 July 12,000 $67,500 August 13,000 $71,000 September 15,000 $73,500 October 17,000 $72,500 November 15,000 $71,000 December 18,000 $75,000 The company leases all of its manufacturing equipment. The lease arrangement calls for a flat monthly fee up to 19,500 machine hours. If the machine hours used exceeds 19,500, the monthly fee becomes strictly varlable with respect to the total number of machine hours consumed during the month. Lease expense Is a major element of overhead costs. Required: (a) Prepare a scatterplot using the above data. Change the x-axis range to 8,000-26,000 and the y-axis range to 60,000-110,000. (b) Using the high-low method, estimate the cost equation for manufacturing overhead costs using all of the data polnts glven. Do you have any concerns about the accuracy of the cost equation estimated using the high-low method? What are your concerns? (c) Based on the lease arrangement described above, divide the data points Into two relevant ranges. State the two relevant ranges. Estimate the cost equation for each relevant range using the high-low method. (d) Assume that the company uses 22,500 machine hours durlng a month. Based on your results In (C). estimate the total manufacturing overhead costs that would be Incurred. The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable components of its monthly manufacturing overhead costs. The company wishes to use machine hours as its measure of activity and has gathered the following data: Machine Hours Overhead Costs 2018 January 21,000 $84,000 February 25,000 $100,000 March 22,000 $89,500 April 23,000 $90,000 May 20,500 $81,500 June 19,000 $75,500 July August September 14,000 S70,500 10,000 $6,500 12,000 $69,000 October 17,000 S75,000 November 16,000 $71,500 December 2019 January 18,500 21,000 $77,000 $86,000 February 24,000 $93,000 March 23,000 $93,000 April 22,000 $87,000 May 20.000 $78,000 June 18,000 $76,500 July 12,000 $67,500 August 13,000 $71,000 September 15,000 $73,500 October 17,000 $72,500 November 15,000 $71,000 December 18,000 $75,000 The company leases all of its manufacturing equipment. The lease arrangement calls for a flat monthly fee up to 19,500 machine hours. If the machine hours used exceeds 19,500, the monthly fee becomes strictly varlable with respect to the total number of machine hours consumed during the month. Lease expense Is a major element of overhead costs. Required: (a) Prepare a scatterplot using the above data. Change the x-axis range to 8,000-26,000 and the y-axis range to 60,000-110,000. (b) Using the high-low method, estimate the cost equation for manufacturing overhead costs using all of the data polnts glven. Do you have any concerns about the accuracy of the cost equation estimated using the high-low method? What are your concerns? (c) Based on the lease arrangement described above, divide the data points Into two relevant ranges. State the two relevant ranges. Estimate the cost equation for each relevant range using the high-low method. (d) Assume that the company uses 22,500 machine hours durlng a month. Based on your results In (C). estimate the total manufacturing overhead costs that would be Incurred. The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable components of its monthly manufacturing overhead costs. The company wishes to use machine hours as its measure of activity and has gathered the following data: Machine Hours Overhead Costs 2018 January 21,000 $84,000 February 25,000 $100,000 March 22,000 $89,500 April 23,000 $90,000 May 20,500 $81,500 June 19,000 $75,500 July August September 14,000 S70,500 10,000 $6,500 12,000 $69,000 October 17,000 S75,000 November 16,000 $71,500 December 2019 January 18,500 21,000 $77,000 $86,000 February 24,000 $93,000 March 23,000 $93,000 April 22,000 $87,000 May 20.000 $78,000 June 18,000 $76,500 July 12,000 $67,500 August 13,000 $71,000 September 15,000 $73,500 October 17,000 $72,500 November 15,000 $71,000 December 18,000 $75,000 The company leases all of its manufacturing equipment. The lease arrangement calls for a flat monthly fee up to 19,500 machine hours. If the machine hours used exceeds 19,500, the monthly fee becomes strictly varlable with respect to the total number of machine hours consumed during the month. Lease expense Is a major element of overhead costs. Required: (a) Prepare a scatterplot using the above data. Change the x-axis range to 8,000-26,000 and the y-axis range to 60,000-110,000. (b) Using the high-low method, estimate the cost equation for manufacturing overhead costs using all of the data polnts glven. Do you have any concerns about the accuracy of the cost equation estimated using the high-low method? What are your concerns? (c) Based on the lease arrangement described above, divide the data points Into two relevant ranges. State the two relevant ranges. Estimate the cost equation for each relevant range using the high-low method. (d) Assume that the company uses 22,500 machine hours durlng a month. Based on your results In (C). estimate the total manufacturing overhead costs that would be Incurred. The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable components of its monthly manufacturing overhead costs. The company wishes to use machine hours as its measure of activity and has gathered the following data: Machine Hours Overhead Costs 2018 January 21,000 $84,000 February 25,000 $100,000 March 22,000 $89,500 April 23,000 $90,000 May 20,500 $81,500 June 19,000 $75,500 July August September 14,000 S70,500 10,000 $6,500 12,000 $69,000 October 17,000 S75,000 November 16,000 $71,500 December 2019 January 18,500 21,000 $77,000 $86,000 February 24,000 $93,000 March 23,000 $93,000 April 22,000 $87,000 May 20.000 $78,000 June 18,000 $76,500 July 12,000 $67,500 August 13,000 $71,000 September 15,000 $73,500 October 17,000 $72,500 November 15,000 $71,000 December 18,000 $75,000 The company leases all of its manufacturing equipment. The lease arrangement calls for a flat monthly fee up to 19,500 machine hours. If the machine hours used exceeds 19,500, the monthly fee becomes strictly varlable with respect to the total number of machine hours consumed during the month. Lease expense Is a major element of overhead costs. Required: (a) Prepare a scatterplot using the above data. Change the x-axis range to 8,000-26,000 and the y-axis range to 60,000-110,000. (b) Using the high-low method, estimate the cost equation for manufacturing overhead costs using all of the data polnts glven. Do you have any concerns about the accuracy of the cost equation estimated using the high-low method? What are your concerns? (c) Based on the lease arrangement described above, divide the data points Into two relevant ranges. State the two relevant ranges. Estimate the cost equation for each relevant range using the high-low method. (d) Assume that the company uses 22,500 machine hours durlng a month. Based on your results In (C). estimate the total manufacturing overhead costs that would be Incurred.
Expert Answer:
Answer rating: 100% (QA)
b For HighLow method Variable cost is Variable cost Highest Activity Cost Lowest Activity CostHighes... View the full answer
Related Book For
Making Hard Decisions with decision tools
ISBN: 978-0538797573
3rd edition
Authors: Robert Clemen, Terence Reilly
Posted Date:
Students also viewed these accounting questions
-
A medium-sized automobile insurance company is interested in developing a regression model to help predict the monthly collision claims of its policyholders. A company analyst has proposed modeling...
-
The Roakes Company is interested in developing a cost equation to estimate the fixed and varlable components of its monthly manufacturing overhead costs. The company wishes to use machine hours as...
-
A home appliance company is interested in marketing an innovative new product. The company must decide whether to manufacture this product in house or employ a subcontractor to manufacture it. The...
-
Determine the length of the hydrogen bonds between: TYR41H and GLU37O ALA39H and MET35O GLU38H and ILE34O THR36H and ARG32O ARG32H and TYR28O by using PyMOL And identify the residues located at...
-
The stock of East/West Maps is currently selling for $122.40, which equates to a P/E ratio of 24. a. Using the P/E ratio, compute the current EPS of East/West. b. Assume that earnings next year...
-
Refer to the opening feature about Heritage Link Brands. Assume that Selena and Khary Cuffe report current annual sales at approximately $10 million and disclose the following income statement....
-
Sea Explor manufactures deep-sea diving suits. The company records manufacturing costs by job number and uses a factory overhead applied rate to charge overhead costs to its products. Sea Explor...
-
Erik Co. elects to use the percentage-of-sales basis in 2012 to record bad debts expense. It estimates that 2% of net credit sales will become uncollectible. Sales revenues are $800,000 for 2012,...
-
REQUIRED Calculate the following variances from the information provided below. In each case also state whether the variance is favourable or unfavourable. 1.4.1 Labour rate variance 1.4.2 Labour...
-
Lowes Companies, Inc., is a home improvement company offering a range of products for maintenance, repair, remodeling, and decorating. During the recovery phase since the financial crisis of 2008,...
-
The Bapson Company started the month of April with no inventory. During the month, it produced 80,000 units but only sold 60,000 units. Costs incurred were: Direct materials $20,000 Direct labor...
-
Nurses have a duty to question discharge.
-
Corporate negligence A corporation itself owes duties to the general public and to its patients. Duties arise from statutes, regulations, principles of law developed by the courts, and the internal...
-
EMS lawsuits involving paramedics include, for example, the wrong dosage of drugs administered, inability to diagnose a patients extent of injury, and failure to transport a patient.
-
In cases where a medical staff members credentials are not screened properly, the healthcare organization can be held liable for injuries to patients as a result of the lack of investigation.
-
Describe the four common levels of EMS personnel: emergency medical responder, emergency medical technician, advanced emergency medical technician, and paramedic.
-
Plastic Queen Manufacturing Company produces a plastic toy in a two-stage molding and finishing operation. The company uses the weighted average method of process costing. During June, the following...
-
Record the following selected transactions for March in a two-column journal, identifying each entry by letter: (a) Received $10,000 from Shirley Knowles, owner. (b) Purchased equipment for $35,000,...
-
Again referring to Figure 7.16, suppose the decision maker has not yet assessed P (Dry) for Site 2 or P(Dome) for Site 1. Let P(Dry) = p and P(Dome) = q . Construct a two-way sensitivity analysis...
-
Modify the influence diagram in Figure 3.11 (the hurricane-forecast example) so that it contains nodes for each of the two objectives (maximize safety and minimize cost). Cost has a natural attribute...
-
Use PrecisionTree to create and solve the influence diagram for the umbrella problem shown in Figure 4.10. Al S8 SO 027/L A2 S15 $4 $10 0 55 SO
-
The following information is available for Banner Company: Calculate the following: a. 2019 debt-to-equity ratio. b. 2019 times-interest-earned ratio. c. 2019...
-
Morgan Corporation has only common stock outstanding. The firm reported earnings per share of \(\$ 6.00\) for the year. During the year, Morgan paid dividends of \(\$ 2.10\) per share. At year end...
-
The notes to financial statements present information on significant accounting policies, complex or special transactions, details of reported amounts, commitments, contingencies, segments, quarterly...
Study smarter with the SolutionInn App