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{.}80$

Electricity $ $1,400$ $ $0\mathrm{.}09$

Maintenance $ $0\mathrm{.}30$

Wages and salaries $ $4,700$ $ $0\mathrm{.}40$

Depreciation $ $8,400$

Rent $ $1,900$

Administrative expenses $ $1,300$ $ $0\mathrm{.}01$

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

Required:

Prepare the company$$s planning budget for August.