Required information [The following information applies to the questions displayed below.] Alden Co's monthly unit sales and total cost data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs. Month Units Sold Total Cost Month Units Sold Total Cost 364, 500 265,500 76,900 145, 500 89,500 95,500 $311,084 147, 250 69,500 126,125 89,500 86,150 1 $153,000 315,500 160,500 260,500 200,500 285,500 185,500 2. 96,750 201,100 95,500 197,000 107,500 8 3 4 10 5 11 12 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.) High-Low method - Calculation of Variable Cost per unit Change in cost Cost at high point minus cost at low point Change in volume Volume at low point minus volume at high point High-Low method - Calculation of Fixed Costs Total cost at the high point $ 311,084.00 Variable costs at the high point Volume at the high point: 364,500 units sold Variable cost per unit Total variable costs at the high point Total fixed costs Total cost at the low point Variable costs at the low point Volume at the low point: Variable cost per unit Total variable costs at the low point Total fixed costs

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter10: Inventory
Section: Chapter Questions
Problem 1PB: When prices are falling (deflation), which costing method would produce the highest gross margin for...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Required information

Skip to question

 

[The following information applies to the questions displayed below.]
 
Alden Co.’s monthly unit sales and total cost data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs.
 

Month Units Sold   Total Cost   Month   Units Sold   Total Cost
1     315,500     $ 153,000     7       364,500       $ 311,084  
2     160,500       96,750     8       265,500         147,250  
3     260,500       201,100     9       76,900         69,500  
4     200,500       95,500     10       145,500         126,125  
5     285,500       197,000     11       89,500         89,500  
6     185,500       107,500     12       95,500         86,150  
 

 

1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.)

 

 

SEE PICTURE

Required information
[The following information applies to the questions displayed below.]
Alden Co.'s monthly unit sales and total cost data for its operating activities of the past year follow. Management wants to
use these data to predict future fixed and variable costs.
Month
Units Sold
Total Cost
Month
Units Sold
Total Cost
1.
$153,000
364,500
$311,084
315,500
160,500
260,500
7
2
96,750
201,100
8
265, 500
147, 250
3.
76,900
69,500
4
200,500
95,500
10
145, 500
126, 125
285,500
185,500
197,000
107,500
11
89,500
89,500
12
95,500
86,150
1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate
calculations.)
High-Low method - Calculation of Variable Cost per unit
Change in cost
Cost at high point minus cost at low point
Change in volume
Volume at low point minus volume at high point
High-Low method - Calculation of Fixed Costs
Total cost at the high point
$ 311,084.00
Variable costs at the high point:
Volume at the high point:
364,500 units sold
Variable cost per unit
Total variable costs at the high point
Total fixed costs
Total cost at the low point
Variable costs at the low point:
Volume at the low point:
Variable cost per unit
Total variable costs at the low point
Total fixed costs
Transcribed Image Text:Required information [The following information applies to the questions displayed below.] Alden Co.'s monthly unit sales and total cost data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs. Month Units Sold Total Cost Month Units Sold Total Cost 1. $153,000 364,500 $311,084 315,500 160,500 260,500 7 2 96,750 201,100 8 265, 500 147, 250 3. 76,900 69,500 4 200,500 95,500 10 145, 500 126, 125 285,500 185,500 197,000 107,500 11 89,500 89,500 12 95,500 86,150 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.) High-Low method - Calculation of Variable Cost per unit Change in cost Cost at high point minus cost at low point Change in volume Volume at low point minus volume at high point High-Low method - Calculation of Fixed Costs Total cost at the high point $ 311,084.00 Variable costs at the high point: Volume at the high point: 364,500 units sold Variable cost per unit Total variable costs at the high point Total fixed costs Total cost at the low point Variable costs at the low point: Volume at the low point: Variable cost per unit Total variable costs at the low point Total fixed costs
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Costing Systems
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
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
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,
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College