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 per Month Cost per Car Washed $ 0.70 $ 0.06 $ 0.20 $ 0.20 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $1,000 $4,600 $ 8,200 $ 2,200 $ 1,700 $ 0.03 For example, electricity costs are $1,000 per month plus $0.06 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $6.60 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