Exercise 9-9 (Algo) 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 estimates concerning the companys costs:

	Fixed Cost per Month	Cost per Car Washed
Cleaning supplies		$ 0.60
Electricity	$ 1,500	$ 0.08
Maintenance		$ 0.25
Wages and salaries	$ 4,300	$ 0.20
Depreciation	$ 8,200
Rent	$ 2,000
Administrative expenses	$ 1,400	$ 0.01

For example, electricity costs should be $1,500 per month plus $0.08 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.30 per car washed.

Required:

Prepare the companys planning budget for August.

Lavage Rapide Planning Budget For the Month Ended August 31 \begin{tabular}{|l|l|} \hline & \\ \hline Revenue & \\ \hline Expenses: & \\ \hline Cleaning supplies & \\ \hline Electricity & \\ \hline Maintenance & \\ \hline Wages and salaries \\ \hline Depreciation & \\ \hline Rent & \\ \hline Administrative expenses & \\ \hline Total expense & \\ \hline Net operating income \\ \hline \end{tabular}