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. Fixed cost 25 Donits per Month $ 3,360 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car hashed $0.70 0.10 8.30 0.40 eBook 6,500 10,100 3,900 3,630 0.06 Print For example, electricity costs are $3,360 per month plus $010 per car washed. The company expects to wash 9,800 cars in October and to collect an average of $770 per car washed. References Auto Lavage's actual level of activity was 9,900 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,900 Sales $78,500 Variable expenses: Cleaning supplies 7,250 Electricity 1,085 Maintenance 2,645 Wages and salaries 4,350 Administrative Fixed expenses: Electricity 3,430 Wages and salaries 6,500 Depreciation 10,100 Rent 3,900 Administrative 3,545 Total expense 43,495 Net operating income $35,005 690 Required: 1. Prepare a flexible budget performance report for October. (Indicate the effect of each variance by selecting "F" for favourable orionca) 4. Required: 1. Prepare a flexible budget performance report for October (Indicate the effect of each variance by selecting "F* for favourable. "U" for unfovourable, and "None" for no effect (i.e., zero variance).) 25 points AUTO LAVAGE INC. Flexible Budget Performance Report For the Month Ended October 31 Cost Formula (per car) Flexible Budget eBook Actual Flexible Budget Variance Print Variable Expenses: References 0.00 0 0 Total variable expenses 0 0 0 Fixed expenses 0 0 Total fixed expenses $ 0 $ 2 Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 9,800 cars. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfovourable, and "None" for no effect (i.e., zero variance).) AUTO LAVAGE INC. Comprehensive Performance Report For the Month Ended October 31 Flexible Budget Variance Static Budget Flexible Budget Actual Sales Volume Variance 9,800 9,900 9,900 Number of cars Variable Expenses: 0 0 0 0 01 Total variable expenses 0 Fixed expenses 0 0 $ 0 0 0 Total fixed expenses $ 0 Next Prey 4 of 7