Exercise $9-13($Algo$)$ Prepare a Flexible Budget Performance Report $[$LO$9-4]$

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

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

Maintenance $ $0\mathrm{.}25$

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

Depreciation $ $8,300$

Rent $ $2,200$

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

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

The actual operating results for August are as follows:

Lavage Rapide

Income Statement

For the Month Ended August $31$

Actual cars washed $8,500$

Revenue $ $55,020$

Expenses:

Cleaning supplies $5,540$

Electricity $2,058$

Maintenance $2,340$

Wages and salaries $6,140$

Depreciation $8,300$

Rent $2,400$

Administrative expenses $1,452$

Total expense $28,230$

Net operating income $ $26,790$

Required:

Prepare a flexible budget performance report that shows the company$$s revenue and spending variances and activity variances for August.

Note: Indicate the effect of each variance by selecting $"$F$"$ for favorable, $"$U$"$ for unfavorable, and "None" for no effect $($i$.$e$.,$ zero variance$).$ Input all amounts as positive values.