Hello, I am struggling to complete the practise management accounting assignment for my upcoming midterm.

If you could please answer these two questions on an excel file, that would be greatly appreciated.

Many thanks.

Exercise 9-9 Flexible Budget Performance Report [L03, L04] Auto Lavage is a Canadian company that owns and operates a large automatic carwash facility near Quebec. The following table provides data concerning the company's expected costs: Fixed Cost Cost per per Month Car Washed Cleaning supplies $0.70 Electricity $2,800 0.10 Maintenance 0.30 Wages and salaries 6,000 0.40 Depreciation 9,600 Rent 3,400 Administrative expenses 3,130 0.07 For example, electricity costs are $2,800 per month plus $0.10 per car washed. The company expects to wash 9300 cars in October and to collect an average of $7.20 per car washed. Auto Lavage's actual level of activity was 9,400 cars. The actual revenues and expenses for October are given below: Auto Lavage Income Statement For the Month Ended October 31 Actual cars washed 9,400 Sales $70,900 Variable expenses: Cleaning supplies 7,350 Electricity 1,018 Maintenance 2,458 Wages and salaries 4,140 Administrative 710 Fixed expenses: Electricity 2,880 Wages and salaries 6,000 Depreciation 9,600 Rent 3,400 Administrative 3,045 Total expense 40,601 Net operating income $29,399 Required: 1. Prepare a flexible budget performance report for October. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).) AUTO LAVAGE INC. Flexible Budget Performance Report For the Month Ended October 31 Cost Formula Actual Flexible Flexible Budget (per car) Budget Variance Sales $ 7.20 $ 70,000 Variable Expenses: Cleaning supplies 0.70 Electricity Maintenance Wages and salaries Administrative Total variable expenses 0.70 0 0 Contribution margin 6.5 70,000 0 Fixed expenses Electricity Wages and salaries Depreciation Rent Administrative Total fixed expenses 0 Operating income $ 70,000 $ 02. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 9,300 ca rst (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).) AUTO LAVAGE INC. Comprehensive Performance Report For the Month Ended October 31 Actual Flexible Budget Flexible Variance Budget Sales Volume Variance Static Budget Number of cars 9,400 9,400 9,300 Sales Variable Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Administrative Total variable expenses 0 0 0 of 0 Fixed expenses: Total fixed expenses 0 0 Operating income $ $ 0 $ 0