к 3:49 Module 2 Problem Set September 116 55 61 72,668 October 120 81 39 71,700 November 120 30 90 74,200 December 72 18 54 54,900 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: Yes 33,910 982 x X Il 5G 31 [+ 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 is 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: Yes 2,872 x +$622 The results are strikingly different from those obtained in part a. The vertical axis intercept is much higher while the slope is flatter 2 L7 nder the Dala tato click on Data analysis
к 3:49 Module 2 Problem Set September 116 55 61 72,668 October 120 81 39 71,700 November 120 30 90 74,200 December 72 18 54 54,900 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: Yes 33,910 982 x X Il 5G 31 [+ 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 is 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: Yes 2,872 x +$622 The results are strikingly different from those obtained in part a. The vertical axis intercept is much higher while the slope is flatter 2 L7 nder the Dala tato click on Data analysis
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:к
3:49
Module 2 Problem Set
September
116
55
61
72,668
October
120
81
39
71,700
November
120
30
90
74,200
December
72
18
54
54,900
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: Yes 33,910
982
x X
Il 5G 31
[+
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 is 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: Yes 2,872
x +$622
The results are strikingly different from
those obtained in part a. The vertical axis intercept is much higher
while the slope is flatter
2
L7
nder the Dala tato click on Data analysis
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education