Exercise 9-9 (Algo) 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 estimates concerning the company's costs: Cost per Car Washed Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Fixed Cost per Month $ 0.60 $ 1,300 $ 0.07 $ 0.25 $ 4,400 $ 0.30 $ 8,400 $ 2,000 $ 1,500 $ 0.03 For example, electricity costs should be $1,300 per month plus $0.07 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $6.40 per car washed. Required: Prepare the company's planning budget for August. Lavage Rapide Planning Budget For the Month Ended August 31 Revenue Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Total expense Net operating income 0 $ 0