Exercise $9-7($Algo$)$ Planning Budget $[$LO$9-1]$

Lavage Rapide owns and eperates a large automalic car wash near Montreal. The lotlowing table provides data concerning the company's conta:

$\backslash$table$[[,$Fixed Cost per nonth,Cost per Car waitned$],[$Cleaning supplies,,$30\mathrm{.}40],[$Electricity$,(1),2200,40\mathrm{.}47],[$Maintenance$,,14\mathrm{.}15],[$Wapes and salaries,$14\mathrm{.}490,54\mathrm{.}38],[$Depreciation$,8,308,],[$Rest$,1)1,$ wee,$],[$Administrative exphoss,$ $1,200,5\mathrm{.}6\mathrm{.}44]]$

For example, electricity costs me $$7\mathrm{.}200$ per month plun $$0\mathrm{.}07$ per car wathed.

The company plans to wash R$,400$ cars in August and to collect an awerage of $$5\mathrm{.}30$ per car washed. This mumber of cars should be used for the initial planning$/$static budget below:

Required:

Prepare the company's planning budget for kuguit.

$\backslash$table$[[$Lavage Raplit$],[$Flanning Buslget$],[$Fer the Menth Finded Auguar $21],[,],[$Revenue$,],[$Expenses:$,],[$Cleaving supply,$],[$Electivity$,],[$Maintenavice$,],[$Wapes and salaries,$],[$Despreciation$,],[$Reve$,],[,]]$

Lavage Rapide owns and operates a large automatic car wash near Montreal. The following table provides data concerning the company's costs:

$\backslash$table$[[,$Fixed Cost Cost per,$],[,$Per Month Car Washed,$],[$Cleaning supplies,,$$0\mathrm{.}60$