Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please wirte the full solution and write it carefully, especially the cost formula in 1 Auto Lavage is a Canadian company that owns and operates
Please wirte the full solution and write it carefully, especially the cost formula in 1
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.70 Cleaning supplies Electricity $1,800 0.10 Maintenance 0.30 5, 100 0.40 Wages and salaries Depreciation 8,700 Rent 2,500 Administrative expenses 2, 240 0.09 For example, electricity costs are $1,800 per month plus $0.10 per car washed. The company expects to wash 8,400 cars in October and to collect an average of $6.30 per car washed. Auto Lavage's actual level of activity was 8,500 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, 500 Sales $56, 300 6, 475 Variable expenses: Cleaning supplies Electricity Maintenance 910 2, 075 Wages and salaries 3, 802 Administrative 856 Fixed expenses: Electricity 1, 890 Wages and salaries 5, 100 Depreciation 8, 700 Rent 2,500 Administrative 2, 145 Administrative Total expense 2, 145 34, 453 $21,847 Net operating income. 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 (per car) Actual Flexible Budget Flexible Budget Variance Sales Variable Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Administrative Total variable expenses Contribution margin 0.00 0 $ 53,550 6,475 910 2,075 3,802 856 14,118 39,432 0 Total variable expenses Contribution margin Fixed expenses: Electricity Wages and salaries Depreciation Rent Administrative Total fixed expenses Operating income 0.00 0 14,118 39,432 0 $ 39,432 $ 0 0 0 0 2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 8,400 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 Actual Flexible Budget Variance Sales Volume Variance Static Budget Number of cars Variable Expenses: Total variable expenses Fixed expenses: 8,500 0 0 Flexible Budget 8,500 0 0 8,400 0 0 Total variable expenses Fixed expenses: Total fixed expenses $ 0 0 0 0 $ 0 0 0 0 $ 0 0 0 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started