Exercise $9-9($Algo$)$ Planning Budget $[$LO$9-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 company$$s costs:

Fixed Cost per Month Cost per Car Washed

Cleaning supplies $ $0\mathrm{.}40$

Electricity $ $1,300$ $ $0\mathrm{.}07$

Maintenance $ $0\mathrm{.}25$

Wages and salaries $ $4,200$ $ $0\mathrm{.}20$

Depreciation $ $8,100$

Rent $ $2,000$

Administrative expenses $ $1,700$ $ $0\mathrm{.}04$

For example, electricity costs should be $$1,300$ per month plus $$0\mathrm{.}07$ per car washed. The company expects to wash $8,200$ cars in August and to collect an average of $$6\mathrm{.}50$ per car washed.

Required:

Prepare the company$$s planning budget for August.