Check 4 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: 25 points Fixed Cost per Month Cost per Car Washed $0.60 0.20 0.40 0.50 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $ 3,250 eBook 6,400 10,000 3,800 3,520 0.05 Print For example, electricity costs are $3,250 per month plus $0.20 per car washed. The company expects to wash 9,700 cars in October and to collect an average of $7.60 per car washed. References o Auto Lavage's actual level of activity was 9,800 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,800 Sales $ 77,600 Variable expenses: Cleaning supplies 6,600 Electricity 2,035 Maintenance 3,500 Wages and salaries 5,102 Administrative 580 Fixed expenses: Electricity 3,320 Wages and salaries 6,400 Depreciation 10,000 Rent 3,800 Administrative 3,445 Total expense 44,782 Net operating income $32,818 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).) eBook AUTO LAVAGE INC. Flexible Budget Performance Report For the Month Ended October 31 Print Cost Formula (per car) Actual Flexible Budget Flexible Budget Variance References Variable Expenses: Total variable expenses Fixed expenses: Total fixed expenses 25 points 2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 9,700 cars. (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 eBook Actual Flexible Budget Variance Static Budget Flexible Sales Volume Variance Budget 9,800 Print Number of cars 9,800 9,700 References Variable Expenses: Total variable expenses Fixed expenses Total fixed expenses