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.70 | |||
Electricity | $ | 1,400 | $ | 0.10 | |
Maintenance | $ | 0.20 | |||
Wages and salaries | $ | 4,300 | $ | 0.40 | |
Depreciation | $ | 8,000 | |||
Rent | $ | 2,200 | |||
Administrative expenses | $ | 1,800 | $ | 0.02 | |
For example, electricity costs are $1,400 per month plus $0.10 per car washed. The company expects to wash 8,500 cars in August and to collect an average of $6.60 per car washed.
Required:
Prepare the company’s planning budget for August.
|
The correct answer is :
Lavage Rapide | |
Planning Budget | |
For the Month Ended August 31 | |
Revenue | 56,100 |
Expenses: | |
Cleaning supplies | 5,950 |
Electricity | 2,250 |
Maintenance | 1,700 |
Wages and salaries | 7,700 |
Depreciation | 8,000 |
Rent | 2,200 |
Administrative expenses | 1,970 |
Total expense | 29,770 |
Net operating income |
26,330 |
Note :
Fixed
Cost per Month |
Cost per | Cars Expected to beWashed | Variable Cost Car washed * Cost Per Car washed) | Total ( Fixed + Variable) | |||
Car Washed | |||||||
Cleaning supplies | $ | 0.70 | 8,500.00 | 5,950.00 | 5,950.00 | ||
Electricity | $ | 1,400.00 | $ | 0.10 | 8,500.00 | 850.00 | 2,250.00 |
Maintenance | $ | 0.20 | 8,500.00 | 1,700.00 | 1,700.00 | ||
Wages and salaries | $ | 4,300.00 | $ | 0.40 | 8,500.00 | 3,400.00 | 7,700.00 |
Depreciation | $ | 8,000.00 | - | - | 8,000.00 | ||
Rent | $ | 2,200.00 | - | - | 2,200.00 | ||
Administrative expenses | $ | 1,800.00 | $ | 0.02 | 8,500.00 | 170.00 | 1,970.00 |
29,770.00 |