Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Auto Lavage is a Canadian company that owns and operates a large automatic carwash facility near Quebec. The following table provides data concerning the companys

Auto Lavage is a Canadian company that owns and operates a large automatic carwash facility near Quebec. The following table provides data concerning the companys expected costs:

Fixed Cost per Month Cost per Car Washed
Cleaning supplies $ 0.90
Electricity $ 3,550 0.30
Maintenance 0.50
Wages and salaries 6,700 0.60
Depreciation 10,300
Rent 4,100
Administrative expenses 3,850 0.08

For example, electricity costs are $3,550 per month plus $0.30 per car washed. The company expects to wash 10,000 cars in October and to collect an average of $7.90 per car washed.

Auto Lavages actual level of activity was 10,100 cars. The actual revenues and expenses for October are given below:

Auto Lavage Income Statement For the Month Ended October 31
Actual cars washed 10,100
Sales $ 82,000
Variable expenses:
Cleaning supplies 9,950
Electricity 3,099
Maintenance 4,528
Wages and salaries 6,350
Administrative 890
Fixed expenses:
Electricity 3,650
Wages and salaries 6,700
Depreciation 10,300
Rent 4,100
Administrative 3,745
Total expense 53,312
Net operating income $ 28,688

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).)

image text in transcribed

2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 10,000 cars. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance).)

image text in transcribed

Varia 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 Flexible Formula Actual Budget (per car) $ 7.90 $ 82,000 $ 79,790 Flexible Budget Variance Sales $ 2,210 F 0.90 9,950 9,090 860 IU Variable Expenses: Cleaning supplies Electricity Maintenance 0.30 3,099 69 U 3,030 5,050 0.50 4,528 (522) F Wages and salaries 0.60 6,3 6,060 290 U Administrative 0.08 890 808 82 1U 2.38 24,038 779 U 24,817 57,183 5.52 55,752 1,431F Total variable expenses Contribution margin Fixed expenses: Electricity Wages and salaries Depreciation 3,550 6,700 10,300 4,100 Rent Administrative Total fixed expenses 0 24,650 $ 32,533 Operating income $ 55,752 AUTO LAVAGE INC. Comprehensive Performance Report For the Month Ended October 31 Actual Flexible Budget Variance Flexible Budget Sales Volume Variance Static Budget Number of cars 10,100 10,100 10,000 Sales Variable Expenses: Total variable expenses 0 0 0 0 0 0 Fixed expenses: Total fixed expenses 0 0 $ 0 $ 0 $ 0

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

Financial Accounting Reporting Analysis And Decision Making

Authors: Shirley Carlon, Rosina Mcalpine, Chrisann Lee, Lorena Mitrione, Ngaire Kirk, Lily Wong

7th Edition

0730395294, 978-0730395294

More Books

Students also viewed these Accounting questions