Month | Units | Total Costs |
---|---|---|
January | 3,560 | $242,400 |
February | 3,800 | $252,000 |
March | 4,000 | $260,000 |
April | 3,600 | $244,000 |
May | 3,200 | $228,000 |
June | 3,040 | $221,600 |
Step 1: determine variable cost
Variable cost per unit = (highest cost – lowest cost) / (highest activity – lowest activity)
= (260,000 – 221,600) / (4,000 – 3,040)
= 38,400 / 960
=$40 per unit
Step 2: determine fixed cost
Fixed cost = highest cost – (highest activity * variable cost per unit)
= 260,000 – (4,000 * 40)
= 260,000 – 160,000
= 100,000
Therefore, the cost function will be as follows
Cost = 100,000 + 40x
Where x is the number of units produced.