In: Accounting
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company’s costs:
Fixed Cost per Month |
Cost per Car Washed |
||||
Cleaning supplies | $ | 0.70 | |||
Electricity | $ | 1,400 | $ | 0.08 | |
Maintenance | $ | 0.10 | |||
Wages and salaries | $ | 4,100 | $ | 0.40 | |
Depreciation | $ | 8,300 | |||
Rent | $ | 2,200 | |||
Administrative expenses | $ | 1,700 | $ | 0.05 | |
For example, electricity costs should be $1,400 per month plus $0.08 per car washed. The company actually washed 8,200 cars in August and collected an average of $6.50 per car washed.
Required:
Prepare the company’s flexible budget for August.
Answer | |
Explanation : | |
Lavage Rapide | |
Flexible Budget | |
Company’s flexible budget for August | |
Actual cars washed | 8,200 |
Revenue (8,200 cars x $6.50 per car) | $ 53,300 |
Expenses: | |
Cleaning supplies (8,200 cars x $0.70 per car) | $ 5,740 |
Electricity ($1,400 + 8,200 cars x $0.08 per car) | $ 2,056 |
Maintenance (8,200 cars x $0.10 per car) | $ 820 |
Wages and salaries ($4,100 + 8,600 cars x $0.30 per car) | $ 7,540 |
Depreciation | $ 8,300 |
Rent | $ 2,200 |
Administrative expenses ($1,700 + 8,200 cars x $0.05 per car) | $ 2,110 |
Total expense | $ 28,766 |
Net operating income (Revenue - Total expense) | $ 24,534 |