In: Accounting
Relevant Range and High-Low Method
The following selected data relate to the major cost categories
experienced by Shaw Company at varying levels of operating volumes.
Assuming that all operating volumes are within the relevant range,
calculate the appropriate costs in each column in which blanks
appear:
Total Cost (@ 3,000 Units) | Total Cost (@ 4,000 units) | Variable Cost per Unit | Total Fixed Cost | Total Cost (@ 5,000 units) | |
---|---|---|---|---|---|
Direct labor (variable) | $51,000 | $68,000 | Answer | Answer | Answer |
Factory supervision (semi-variable) | 50,000 | 65,000 | Answer | Answer | Answer |
Factory depreciation (fixed) | 21,000 | 21,000 | Answer | Answer | Answer |
Units |
Cost |
||
High Level |
4,000 |
$ 65,000.00 |
|
Low Level |
3,000 |
$ 50,000.00 |
|
Difference |
1,000 |
$ 15,000.00 |
|
A |
Difference in Cost |
$ 15,000.00 |
|
B |
Difference in units |
1,000 |
|
C = A/B |
Variable cost per unit |
$ 15.00 |
|
Working |
High Level |
Low Level |
|
A |
Total Cost |
$ 65,000.00 |
$ 50,000.00 |
B |
Total Units |
4000 |
3000 |
C |
Variable cost per unit |
$ 15.00 |
$ 15.00 |
D = B x C |
Total Variable cost |
$ 60,000.00 |
$ 45,000.00 |
E = A - D |
Total Fixed Cost |
$ 5,000.00 |
$ 5,000.00 |
Total Cost (@ 3,000 Units) |
Total Cost (@ 4,000 units) |
Variable Cost per Unit |
Total Fixed Cost |
Total Cost (@ 5,000 units) |
|
Direct labor (variable) |
$51,000 |
$68,000 |
$17 |
$0 |
$85,000 |
Factory supervision (semi-variable) |
$50,000 |
$65,000 |
$15 |
$5,000 |
$80,000 |
Factory depreciation (fixed) |
$21,000 |
$21,000 |
$0 |
$21,000 |
$21,000 |