The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Total Production Costs $230,000 Level of Activity (Units Produced) 3500 Month July August September October 250,000 3.750 260,000 220,000 3400 November 340,000 S800 December 330,000 5500 January February 200,000 2,900 3.300 3.600 5.900 210,000 March 240,000 April May June 350,000 350,000 5600 290,000 5000 a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? e) Prepare the scatter diagram, clearly showing any outliers. O Using the line of best-fit, determine the company's fixed cost per month and the variable cost per unit. (eo50o0 lts) e) In view of the department's cost behaviour patterm, which of the two methods appear more appropriate? Explain your answer.

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter7: Variable Costing For Management analysis
Section: Chapter Questions
Problem 1CMA
icon
Related questions
Question

Can you please help me with d and c. Please dont give me back whats on the site and work it out correctly

The table below shows monthly data collected on production costs and on the number of
units produced over a twelve month period.
Month
Total Production
Level of Activity
(Units Produced)
Costs
July
August
$230,000
3.500
250,000
3-750
September
260,000
3.800
October
220,000
3.400
November
340,000
5,800
December
330,000
5-500
January
200,000
2,900
February
210,000
3.300
March
240,000
3,600
April
380,000
5.900
Мay
350,000
5,600
June
290,000
5,000
a) Determine the variable cost per unit and the fixed cost using the high-low
method.
b) What is the equation of the total mixed cost function?
e) Prepare the scatter diagram, clearly showing any outliers.
) Using the line of best-fit, determine the company's fixed cost per month and the
variable cost per unit. (ee o55000 nlts.)
e) In view of the department's cost behaviour patterm, which of the two methods
appear more appropriate? Explain your answer.
Transcribed Image Text:The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Month Total Production Level of Activity (Units Produced) Costs July August $230,000 3.500 250,000 3-750 September 260,000 3.800 October 220,000 3.400 November 340,000 5,800 December 330,000 5-500 January 200,000 2,900 February 210,000 3.300 March 240,000 3,600 April 380,000 5.900 Мay 350,000 5,600 June 290,000 5,000 a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? e) Prepare the scatter diagram, clearly showing any outliers. ) Using the line of best-fit, determine the company's fixed cost per month and the variable cost per unit. (ee o55000 nlts.) e) In view of the department's cost behaviour patterm, which of the two methods appear more appropriate? Explain your answer.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Database management system (DBMS)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning