Exercise 9-7 Planning Budget (LO9-1] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed cost Cost per per Month $ 1,200 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Car Washed $ 0.60 $ 0.10 $ 0.30 $ 0.30 $ 4,300 $ 8,000 $ 1,800 $ 1,300 $ 0.02 For example, electricity costs are $1,200 per month plus $0.10 per car washed. The company expects to wash 8,400 cars in August and to collect an average of $6.00 per car washed. Required: Prepare the company's planning budget for August. X Answer is not complete. Lavage Rapide Planning Budget For the Month Ended August 31 Budgeted cars washed 8,400 Revenue $ 50,400 5,040 960 x 840 x Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses 2,520 X 8,000 1,800