In: Accounting
Campus Copy & Printing wants to predict copy machine repair expense at different levels of copying activity (number of copies made). The following data have been gathered:
Copy Machine
Month Repair Expense Copies Made
|
May |
$ 9,000 |
300,000 |
|
June |
13,000 |
550,000 |
|
July |
22,000 |
950,000 |
|
August |
17,000 |
750,000 |
|
September |
10,500 |
400,000 |
Required
Determine the fixed and variable components of repair expense using the high-low method. Use copies made as the measure of activity. Round cost per copy to two decimal places.
Solution
| Variable cost per employee | $ 0.02 per copy |
| Fixed cost | $ 3,000 |
Working
| Cost | No. of activities | ||
| A | High Level | $ 22,000.00 | 950000 |
| B | Low Level | $ 9,000.00 | 300000 |
| C=A-B | Difference | $ 13,000.00 | 650,000 |
| A | Cost difference | $ 13,000.00 | |
| B | No. of activities difference | 650000 | |
| C=A/B | Variable cost per unit | $ 0.02 | |
| High Level | Low Level | ||
| A | No. of activities | 950000 | 300000 |
| B | Variable cost per unit | $ 0.0200 | $ 0.0200 |
| C=AxB | Total Variable cost | $ 19,000.00 | $ 6,000.00 |
| D | Total cost | $ 22,000.00 | $ 9,000.00 |
| E=D-C | Total fixed cost | $ 3,000.00 | $ 3,000.00 |