Exercise 9-7 (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 data 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.50 $ 1,100 $ 0.07 $ 0.20 $ 5,000 $ 0.40 $ 8,100 $ 2,000 $ 1,500 $ 0.02 For example, electricity costs are $1,100 per month plus $0.07 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $5.90 per car washed. Required: Prepare the company's planning budget for August. Lavage Rapide Planning Budget For the Month Ended August 31 Revenue