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.50 Electricity $ 1,400 $ 0.06 Maintenance $ 0.25 Wages and salaries $ 4,200 $ 0.40 Depreciation $ 8,100 Rent $ 2,000 Administrative expenses $ 1,300 $ 0.01 For example, electricity costs should be $1,400 per month plus $0.06 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.80 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 $ 59,220

Expenses:
Cleaning supplies		4,700
Electricity		1,874
Maintenance		2,340
Wages and salaries		7,920
Depreciation		8,100
Rent		2,200
Administrative expenses		1,284
Total expense		28,418
Net operating income	$	30,802

Required:

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

If you could provide some calculations, I would really appreciate the effort. (same layout but completely different and wrong numbers in the example picture above, just the formatting is correct).

Lavage Rapide Flexible Budget Performance Report For the Month Ended August 31 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Cars washed } & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{|r|} \begin{tabular}{l} Actual \\ Results \end{tabular} \\ 8,500 \\ \end{tabular}}} & \multicolumn{3}{|c|}{\begin{tabular}{l} Revenue and \\ Spending \\ Variances \end{tabular}} & & \multirow{2}{*}{\begin{tabular}{l} \begin{tabular}{c} Flexible \\ Budget \end{tabular} \\ 8,400 \end{tabular}} & \multicolumn{2}{|c|}{ Activity Variances } & \multirow{2}{*}{\begin{tabular}{|c} \begin{tabular}{c} Planning \\ Budget \end{tabular} \\ 8,100 \end{tabular}} \\ \hline & & & & & & & & & & \\ \hline Revenue & $ & 59,220 & $ & 2,100 & F & 2 & $57,120 & $2,040 & & $55,080 \\ \hline \multicolumn{11}{|l|}{ Expenses: } \\ \hline Cleaning supplies & & 5,540 & & 500 & U & 2 & 5,040 & 180 & & 4,860 \\ \hline Electricity & & 1,874 & & 30 & F & ( & 1,904 & 18 & & 1,886 \\ \hline Maintenance & & 1,920 & & 240 & U & & 1,680 & 60 & & 1,620 \\ \hline Wages and salaries & & 7,580 & & 360 & U & & 7,220 & 90 & & 7,130 \\ \hline Depreciation & & 8,200 & & 0 & None & & 8,200 & 0 & None & 8,200 \\ \hline Rent & & 2,100 & & 200 & U & & 1,900 & 0 & None & 1,900 \\ \hline Administrative expenses & & 1,568 & & 100 & F & ( & 1,668 & 6 & & 1,662 \\ \hline Total expense & & 28,782 & & 1,170 & U & & 27,612 & 354 & & 27,258 \\ \hline Net operating income & $ & 30,438 & $ & 930 & F & & $29,508 & $1,686 & & $27,822 \\ \hline \end{tabular}