Please do not give solution in image format thanku Lavage Rapide owns and operates a large automatic car wash facility near Montreal. The following table provides estimatesconcerning the company's costs:Cleaning suppliesElectricityMaintenanceWages and salariesDepreciationAdministrative expensesRentRevenueExpenses:FixedCost perMonthCleaning suppliesElectricityMaintenanceWages and salariesDepreciationRent$ 1,400$ 4,800$ 8,000$ 2,100$1,600For example, electricity costs should be $1,400 per month plus $0.07 per car washed. The company expects to wash 8,500 cars inAugust and to collect an average of $6.30 per car washed.Lavage RapidePlanning BudgetFor the Month Ended August 31Required:Prepare the company's planning budget for August.Administrative expensesTotal expensesNet operating incomeCost perCar Washed$ 0.60$ 0.07$ 0.20$ 0.20$ 0.04

The planning budget is a fixed budget and it can not be changed on the basis of change in production…

Lavage Rapide owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company's costs: Cleaning supplies Electricity Maintenance Wages and salaries. Depreciation Administrative expenses Rent Fixed Cost per Month $ 1,400 $4,800 $ 8,000 $2,100 $1,600 Cost per Car Washed $ 0.60 $ 0.07 $0.20 $ 0.20 $ 0.04 For example, electricity costs should be $1,400 per month plus $0.07 per car washed. The company expects to wash 8,500 cars in August and to collect an average of $6.30 per car washed. Required: Prepare the company's planning budget for August.