Auto Lavage is a Canadian company that owns and operates a large automatic carwash facility...

80.2K

Verified Solution

Question

Accounting

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 $ 2,600 0.30
Maintenance 0.50
Wages and salaries 5,800 0.60
Depreciation 9,400
Rent 3,200
Administrative expenses 2,910 0.05

For example, electricity costs are $2,600 per month plus $0.30 per car washed. The company expects to wash 9,100 cars in October and to collect an average of $8.00 per car washed.

Auto Lavages actual level of activity was 9,200 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,200
Sales $ 78,000
Variable expenses:
Cleaning supplies 8,515
Electricity 2,822
Maintenance 4,350
Wages and salaries 5,860
Administrative 510
Fixed expenses:
Electricity 2,660
Wages and salaries 5,800
Depreciation 9,400
Rent 3,200
Administrative 2,845
Total expense 45,962
Net operating income $ 32,038

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

2. Prepare a comprehensive performance report for October. Assume that the static budget for October was based on an activity level of 9,100 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

(per car) $ 78,000 $ 73,600 $ 4,400 F Sales Variable Expenses Cleaning supplies Electricity Maintenance Wages and salaries Administrative 235/U 620 8,515 2,822 4,350 5,860 510 8,280 2,760 4,600 5,520 250 F 340U 50U 460 0.00 22,057 55,943 21,620 51,980 60U Total variable expenses Contribution margin Fixed expenses: Electricity Wages and salaries Depreciation Rent Administrative 2,660 5,800 9,400 3,200 2,845 2,660 5,800 9,400 3,200 2,910 0 None 0 None 0 None 65F Total fixed expenses 23,905 23,970 28,010 Operating income $ 32,038 $ Number of cars 9,200 9,200 9,100 Variable Expenses: Total variable expenses Fixed expenses Total fixed expenses

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students