In: Accounting
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:
|
Fixed Cost per Month |
Cost per Car Washed |
||||||
| Cleaning supplies | $ | 0.40 | |||||
| Electricity | $ | 1,300 | $ | 0.10 | |||
| Maintenance | $ | 0.25 | |||||
| Wages and salaries | $ | 5,000 | $ | 0.40 | |||
| Depreciation | $ | 8,200 | |||||
| Rent | $ | 1,900 | |||||
| Administrative expenses | $ | 1,600 | $ | 0.03 | |||
For example, electricity costs are $1,300 per month plus $0.10 per car washed. The company expects to wash 8,200 cars in August and to collect an average of $6.30 per car washed.
The actual operating results for August appear below.
| Lavage Rapide | ||
| Income Statement | ||
| For the Month Ended August 31 | ||
| Actual cars washed | 8,300 | |
| Revenue | $ | 53,760 |
| Expenses: | ||
| Cleaning supplies | 3,780 | |
| Electricity | 2,090 | |
| Maintenance | 2,290 | |
| Wages and salaries | 8,640 | |
| Depreciation | 8,200 | |
| Rent | 2,100 | |
| Administrative expenses | 1,746 | |
| Total expense | 28,846 | |
| Net operating income | $ | 24,914 |
| Activity variance = Flxexible budget - planned budget | ||||||||||
| where | Flexible budget = fixed cost per month + 8,300*cost per car washed | |||||||||
| Planned budget = fixed cost per month +8,200*cost per cash washed | ||||||||||
| fixed cost | cost per | 8,300 | 8,200 | |||||||
| per monht | car washed | Flexible | planned | Activity variance | ||||||
| Revenue | 6.3 | 52290 | 51660 | 630 | F | |||||
| Expenses | ||||||||||
| Cleaning supplies | 0.4 | 3320 | 3280 | 40 | U | |||||
| Electricity | 1,300 | 0.1 | 2130 | 2120 | 10 | U | ||||
| Maintenance | 0.25 | 2075 | 2050 | 25 | U | |||||
| Wages and salaries | 5,000 | 0.4 | 8320 | 8280 | 40 | U | ||||
| Depreciation | 8,200 | 8,200 | 8,200 | 0 | N | |||||
| Rent | 1,900 | 1,900 | 1,900 | 0 | N | |||||
| Administrative expenses | 1,600 | 0.03 | 1,849 | 1,846 | 3 | N | ||||
| total expense | 18000 | 1.18 | 27794 | 27676 | 118 | U | ||||
| net operating income | 24496 | 23984 | 512 | F | ||||||
| Revenue and Spending variance | ||||||||||
| Actual | Flexible | Revenue & spending | ||||||||
| Result | budget | variance | ||||||||
| Revenue | 53,760 | 52290 | 1,470 | F | ||||||
| Expenses | ||||||||||
| Cleaning supplies | 3,780 | 3320 | 460 | U | ||||||
| Electricity | 2,090 | 2130 | 40 | F | ||||||
| Maintenance | 2,290 | 2075 | 215 | U | ||||||
| Wages and salaries | 8,640 | 8320 | 320 | U | ||||||
| Depreciation | 8,200 | 8,200 | 0 | N | ||||||
| Rent | 2,100 | 1,900 | 200 | U | ||||||
| Administrative expenses | 1,746 | 1,849 | 103 | F | ||||||
| total expense | 28,846 | 27,794 | 1,052 | U | ||||||
| net operating income | 24,914 | 24,496 | 418 | F | ||||||
| Flexible budget variance | ||||||||||
| Actual | Revenue and spending | Flexible | Activity variance | planned | ||||||
| Result | variance | budget | budget | |||||||
| Cars washed | 8,300 | 8,300 | 8,200 | |||||||
| Revenue | 53,760 | 1,470 | F | 52290 | 630 | F | 51660 | |||
| Expenses | ||||||||||
| Cleaning supplies | 3,780 | 460 | U | 3320 | 40 | U | 3280 | |||
| Electricity | 2,090 | 40 | F | 2130 | 10 | U | 2120 | |||
| Maintenance | 2,290 | 215 | U | 2075 | 25 | U | 2050 | |||
| Wages and salaries | 8,640 | 320 | U | 8320 | 40 | U | 8280 | |||
| Depreciation | 8,200 | 0 | N | 8,200 | 0 | N | 8,200 | |||
| Rent | 2,100 | 200 | N | 1,900 | 0 | N | 1,900 | |||
| Administrative expenses | 1,746 | 103 | F | 1,849 | 3 | N | 1,846 | |||
| total expense | 28,846 | 1,052 | U | 27,794 | 118 | U | 27,676 | |||
| net operating income | 24,914 | 418 | F | 24,496 | 512 | F | 23,984 | |||