V < > O O Mail - Alesia LeSane - Outlook Business Course NO Nut mybusinesscourse.com Module 2 Problem Set [myBusiness Cour... MBC Module 2 Problem Set | ACCT 6318 (Fall... N. kendrick anderson furniture maker llc cre... ChatGPT Return to course Course Content / ASSIGNMENTS / Module 2 Problem Set Confect Module 2 Problem Set e + O Cost Estimation, Interpretation, and Analysis Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information (also included at this link) on production volume and manufacturing costs since the company started operations. Month Total Tables Dining Total Room Tables Manufacturing Produced Living Room Tables Produced Produced Costs June 110 25 85 $71,000 July 90 45 45 57,500 August 130 15 115 79,724 September 95 36 59 64,250 October 76 24 52 57,300 November 92 48 44 60,900 December 105 24 81 62,700 January 110 50 60 70,130 February 102 March 81 April 142 102 May 125 2222 20 82 68,400 25 56 57,400 40 105,790 103 74,750 June 115 15 100 74,290 July 106 18 88 66,500 August 85 28 57 49,888 September 116 55 61 72,668 October 120 November 120 December 222 81 39 71,700 30 90 74,200 72 18 54 54,900 Required otal tables produced. Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs driven by total tables produced. Note: Round answers to the nearest whole dollar. Cost estimating equation: Y= $ X + $ X X b. In Excel, create a scatter graph of total manufacturing costs and total tables produced. Use the graph to identify any unusual observations. Hint: Highlight the data to be included in the chart. Open the insert tab and select the Scatter chart in the Charts group. Unusual observation: April, Year 2 c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results from requirement (a). Note: Round answers to the nearest whole dollar. Cost estimating equation: Y= $ X + X X The results are → strikingly different from those obtained in part a. The vertical axis intercept is much higher ✰ ✔while the slope is flatter MacBook Air 80 a < DII esc F1 F2 F3 F4 F5 F6 F7 F8 DD 8 4411 F9 F10 F11 F12

V < > O O Mail - Alesia LeSane - Outlook Business Course NO Nut mybusinesscourse.com Module 2 Problem Set [myBusiness Cour... MBC Module 2 Problem Set | ACCT 6318 (Fall... N. kendrick anderson furniture maker llc cre... ChatGPT Return to course Course Content / ASSIGNMENTS / Module 2 Problem Set Confect Module 2 Problem Set e + O Cost Estimation, Interpretation, and Analysis Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information (also included at this link) on production volume and manufacturing costs since the company started operations. Month Total Tables Dining Total Room Tables Manufacturing Produced Living Room Tables Produced Produced Costs June 110 25 85 $71,000 July 90 45 45 57,500 August 130 15 115 79,724 September 95 36 59 64,250 October 76 24 52 57,300 November 92 48 44 60,900 December 105 24 81 62,700 January 110 50 60 70,130 February 102 March 81 April 142 102 May 125 2222 20 82 68,400 25 56 57,400 40 105,790 103 74,750 June 115 15 100 74,290 July 106 18 88 66,500 August 85 28 57 49,888 September 116 55 61 72,668 October 120 November 120 December 222 81 39 71,700 30 90 74,200 72 18 54 54,900 Required otal tables produced. Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs driven by total tables produced. Note: Round answers to the nearest whole dollar. Cost estimating equation: Y= $ X + $ X X b. In Excel, create a scatter graph of total manufacturing costs and total tables produced. Use the graph to identify any unusual observations. Hint: Highlight the data to be included in the chart. Open the insert tab and select the Scatter chart in the Charts group. Unusual observation: April, Year 2 c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results from requirement (a). Note: Round answers to the nearest whole dollar. Cost estimating equation: Y= $ X + X X The results are → strikingly different from those obtained in part a. The vertical axis intercept is much higher ✰ ✔while the slope is flatter MacBook Air 80 a < DII esc F1 F2 F3 F4 F5 F6 F7 F8 DD 8 4411 F9 F10 F11 F12

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter19: Variable Costing (varcost)

Section: Chapter Questions

Problem 5R: Click the Chart sheet tab. This chart is based on the problem data and the two income statements....

See similar textbooks