Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

fill in the rest of blanks Double-check the accuracy of yourself before sending this answer to me Auto Lavage is a Canadian company that owns

image text in transcribedimage text in transcribedimage text in transcribed

fill in the rest of blanks\

Double-check the accuracy of yourself before sending this answer to me

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 $ 3,850 $ 0.90 0.30 0.50 0.62 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses 6,288 9,808 3,600 3,300 0.89 For example, electricity costs are $3,050 per month plus $0.30 per car washed. The company expects to wash 9,500 cars in October and to collect an average of $7.40 per car washed. Auto Lavage's actual level of activity was 9,600 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,600 Sales $73,480 8,850 2,965 4,600 6,105 910 wariable expenses: Cleaning supplies Electricity Maintenance Wages and salaries Administrative Fixed expenses: Electricity Wages and salaries Depreciation Rent Administrative 3,188 6,200 9,800 3,600 3,245 Total expense 49,375 Net operating income $ 24,025 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 Actual Flexible Flexible Budget Budget Variance (per car) S 7.40 $ 73,400 $ 71,040 S 2.360 F 8,640 210 IU 0.90 3050+0.3 0.50 6200+0.6 135/ 200 F 345 U 8,850 6.065 4,600 12,305 9,800 3,600 4.155 49,375 9,800.00 Sales Variable Expenses Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative Total variable expenses Contribution margin Fixed expenses Electricity Wages and salaries Depreciation Rent 5.930 4,800 11,960 9,800 3.600 4,164 48.894 0 None O None 9F 3,600 3300+0.09 13,401.40 -13394 481 24,025 22,146 1,879 F Administrative 0 0 Total fixed expenses Operating income S 24.025 S 22,146 2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 9,500 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 Flexible Budget Flexible Actual Variance Budget Sales Volume Variance Static Budget 9,600 $ 73,400 s 9,600 $ 71,040 9,500 $ 70,300 2,360 F S 740 F 900 210 135 30 Number of cars Sales Variable Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative Total variable expenses 200 F 50 U 60 8,850 6.065 4,600 12,305 9,800 3,600 4.155 49.375 24.025 3450 0 None 8,640 5.930 4.800 11,960 9,800 3,600 4,164 48,894 22.146 8,550 5.900 4,750 11.900 9.800 3,600 4,155: 0 None 9F 0 None 0 None 91U 481 0 2390 48,655 21,645 Fixed expenses: Total fixed expenses 0 0 0 S 21,645 S 24,025 $ 22,146

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Brinks Modern Internal Auditing A Common Body Of Knowledge

Authors: Robert R. Moeller

8th Edition

9781119016984

More Books

Students also viewed these Accounting questions

Question

=+nk so that p( B(k)) Answered: 1 week ago

Answered: 1 week ago