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 Cleaning supplies per Month Car Washed Electricity $0.60 $1,720 0.10 Maintenance 0.30 Wages and salaries 5,000 0.40 Depreciation 8,600 Rent 2,400 Administrative expenses 2. 130 0.88 For example, electricity costs are $1.720 per month plus $0.10 per car washed. The company expects to wash 8.300 cars in October and to collect an average of $6.20 per car washed, Auto Lavage's actual level of activity was 8,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 8,40 Sales 555,600 5, 250 800 2. 200 3,702 756 Variable expenses Cleaning supplies Electricity Maintenance Wages and salaries Adelinistrative Fixed expenses Electricity wiges and salaries Depreciation mont Adeinistrative 1,780 5.080 3,000 2.400 2.045 Total expense 12, 713 For example, electricity costs are $1720 per month plus $0.90 per car washed. The company expects to wash 8,200 cars in October and to collect an average of $6.20 per car washed. Auto Lavage's actual level of activity was 8,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 $ 55,600 8,400 Sales 5, 250 890 2,290 3, 702 Variable expenses Cleaning Supplies Electricity Maintenance Wages and salaries Administrative Fixed expenses Electricity Wages and salaries Depreciation Rent Administrative 756 1.750 5,000 8,600 2,400 2,045 Total expense 32, 713 Net operating income 522.87 Required: 1. Prepare a flexible budget performance report for October (Indicate the effect of each variance by selecting for favourable, u for unfavourable, and "None for no effect is zero variances) AUTO LAVAGE INC Required: 1. Prepare a flexible budget performance report for October. (Indicate the effect of each variance by selecting "P" 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 CON Formula Actu Flexible Hexible Budget (per can Budget Variante Variable Expenses Total variable expenses Fixed expenses Tucated axpenses 2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 8,300 cars. Indicate the effect of each variance by selecting "P" for favourable, "U" for unfavourable, and "None" for no effect f.e, zero variances AUTO LAVAGE INC Comprehensive Performance Repon For the Month Ended October Ach Flexible Variance thudget 2.400 1.400 Variance Number of cars 300 Varat Expenses Total penses expenses 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 Cleaning supplies per Month Car Washed Electricity $0.60 $1,720 0.10 Maintenance 0.30 Wages and salaries 5,000 0.40 Depreciation 8,600 Rent 2,400 Administrative expenses 2. 130 0.88 For example, electricity costs are $1.720 per month plus $0.10 per car washed. The company expects to wash 8.300 cars in October and to collect an average of $6.20 per car washed, Auto Lavage's actual level of activity was 8,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 8,40 Sales 555,600 5, 250 800 2. 200 3,702 756 Variable expenses Cleaning supplies Electricity Maintenance Wages and salaries Adelinistrative Fixed expenses Electricity wiges and salaries Depreciation mont Adeinistrative 1,780 5.080 3,000 2.400 2.045 Total expense 12, 713 For example, electricity costs are $1720 per month plus $0.90 per car washed. The company expects to wash 8,200 cars in October and to collect an average of $6.20 per car washed. Auto Lavage's actual level of activity was 8,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 $ 55,600 8,400 Sales 5, 250 890 2,290 3, 702 Variable expenses Cleaning Supplies Electricity Maintenance Wages and salaries Administrative Fixed expenses Electricity Wages and salaries Depreciation Rent Administrative 756 1.750 5,000 8,600 2,400 2,045 Total expense 32, 713 Net operating income 522.87 Required: 1. Prepare a flexible budget performance report for October (Indicate the effect of each variance by selecting for favourable, u for unfavourable, and "None for no effect is zero variances) AUTO LAVAGE INC Required: 1. Prepare a flexible budget performance report for October. (Indicate the effect of each variance by selecting "P" 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 CON Formula Actu Flexible Hexible Budget (per can Budget Variante Variable Expenses Total variable expenses Fixed expenses Tucated axpenses 2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 8,300 cars. Indicate the effect of each variance by selecting "P" for favourable, "U" for unfavourable, and "None" for no effect f.e, zero variances AUTO LAVAGE INC Comprehensive Performance Repon For the Month Ended October Ach Flexible Variance thudget 2.400 1.400 Variance Number of cars 300 Varat Expenses Total penses expenses