In: Accounting
Contents »
X Company has the following data from 2016 and 2017:
2016 | 2017 | |
Total costs | $260,600 | $411,850 |
Units produced | 32,000 | 57,000 |
Expected production in 2018 is 43,800 units. Using the high-low
method with the 2016 and 2017 data to determine the parameters of
the cost function, what are estimated total costs in 2018?
Note - 1 |
Identification of variable cost per unit |
|||||||
Particulars |
2016 |
2017 |
Change from 2016 to 2017 |
|||||
Total Cost |
$ 2,60,600 |
$ 4,11,850 |
$ 1,51,250 |
|||||
Unit Produced |
32000 |
57000 |
25000 |
|||||
Identification of variable cost per unit = |
Change in total cost |
= |
151250 |
= |
$ 6.05 |
Per unit |
||
Change in total unit produced |
25000 |
|||||||
Note - 2 |
Identification fixed cost |
Amount |
||||||
Total Cost of 2017 |
$ 4,11,850.00 |
(a) |
||||||
Less: Variable cost (57000*6.05) |
$ 3,44,850.00 |
(b) |
||||||
Fixed Cost (a-b) |
$ 67,000.00 |
|||||||
Answer |
Estimated total cost for 2018 |
|||||||
Total expected unit produced in 2018 |
43,800 |
Unit |
||||||
Variable Cost (43800*6.05) |
$ 2,64,990.00 |
refer note - 1 |
||||||
Add: |
Fixed Cost |
$ 67,000.00 |
refer note - 2 |
|||||
Total Cost for 2018 |
$ 3,31,990.00 |