Discussion Question 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 Cost Level of Activity (Units Produced) July $230,000 3,500 August 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 May 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? c) Based on the High-Low method, what is the total production costs if 6,500 units are produced? d) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the y-axis. e) Using the line of best-fit, determine the

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 54E: Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects...
icon
Related questions
Question

Discussion Question 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 Cost

Level of Activity (Units Produced)

July

$230,000

3,500

August

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

May

350,000

5,600

June

290,000

5,000

  1. a) Determine the variable cost per unit and the fixed cost using the high-low method.
  2. b) What is the equation of the total mixed cost function?
  3. c) Based on the High-Low method, what is the total production costs if 6,500 units are produced?
  4. d) Prepare the scatter diagram and insert the trendline or line of best-fit. Use a scale of 2 cm to represent 1,000 units on the x-axis & 2 cm to represent $50,000 on the y-axis.
  5. e) Using the line of best-fit, determine the company’s fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.)
  6. f) Which of the two methods appear more appropriate? Explain your answer.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Value Chain Analysis
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: 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
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College