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 per Month Cost per Car Washed $0.90 $0.30 $0.50 $0.60 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $ 1.600 $4.900 $8,500 $2,300 $2,020 $0.07 For example, electricity costs are $1,600 per month plus $0,30 per car washed. The company expects to wash 8,200 cars in October and to collect an average of $6.10 per car washed. Auto Lavage's actual level of activity was 8,300 cars. The actual revenues and expenses for October are given below: Auto Lavage Income Statement For the Month Ended October 31 Actual cars washed 8,300 Sales $54,300 Variable expenses Cleaning supplies Electricity Maintenance Wages and salaries Administrative Fixed expenses Electricity Wages and salaries Depreciation Rent Administrative 7,800 2,560 3,640 5.250 656 1670 4,900 8,500 2.300 1945 Total expense 39.221 Net operating income $ 15,079 Required: Prepare a flexible budget performance report for October, (Indicate the effect of 1. each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (.e., zero variance).) AUTO LAVAGE INC. Flexible Budget Performance Report For the Month Ended October 31 Cost Formula Actual Flexible (per car) Budget $ 6.10 $ 54,300 Flexible Budget Variance 10 Sales Vanable Expenses Cleaning supplies Electricity Maintenance Wages and salaries Administrative 0.00 0 54,300 0 6.1 0 Total variable expenses Contribution margin Fored expenses Electricity Wages and sales Depreciation Rent Administrative Total foxed expenses 2. Prepare a comprehensive performance report for October using. Assume that the static budget for October was based on an activity level of 8,200 cars. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (.e., zero varionce).) AUTO LAVAGE INC. Comprehensive Performance Report For the Month Ended October 31 Actual cars Flexible Budget Flexible Variance Budget cars 8,300 8,300 Sales Volume Variance Static Budget cars 8.200 Sales Variable Expenses Cleaning Supplies Electricity Maintenance Wages and salaries Administrative Total vanable expenses Contribution mingin Fixed expenses Electricity Wages and salanes