Please do not give solution in image format thanku Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following tableprovides data concerning the company's costs:Cleaning suppliesElectricityMaintenanceWages and salariesDepreciationRentAdministrativeexpensesFixed Cost perMonth$ 1,100$ 4,500$ 8,400$ 2,100Cost per CarWashed$ 0.60$ 0.09$ 0.30$ 0.20$ 1,300$ 0.02For example, electricity costs are $1,100 per month plus $0.09 per car washed. The company expects to wash 8,100 cars in August andto collect an average of $6.00 per car washed.Required:Prepare the company's planning budget for August.

Planning budget is based on Budgeted level of activity volume. It includes revenues and costs based…

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: Cleaning supplies Fixed Cost per Month Rent Administrative expenses $1,100 Cost per Car Washed $ 0.60 $ 0.09 $ 0.30 $0.20 Electricity Maintenance Wages and salaries $4,500 Depreciation $ 8,400 $2,100 $ 1,300 $ 0.02 For example, electricity costs are $1,100 per month plus $0.09 per car washed. The company expects to wash 8,100 cars in August and to collect an average of $6.00 per car washed. Required: Prepare the company's planning budget for August.