Exercise 9-7 Planning Budget [LO9-1]

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 companys costs:

	Fixed Cost per Month			Cost per Car Washed
Cleaning supplies				$	0.50
Electricity	$	1,100		$	0.06
Maintenance				$	0.15
Wages and salaries	$	4,700		$	0.30
Depreciation	$	8,100
Rent	$	1,800
Administrative expenses	$	1,600		$	0.02

For example, electricity costs are $1,100 per month plus $0.06 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 companys planning budget for August.

Lavage Rapide
Planning Budget
For the Month Ended August 31
Revenue
Expenses:
Cleaning supplies
Electricity
Maintenance
Wages and salaries
Depreciation
Rent
Administrative expenses
Total expense
Net operating income