Question

In: Accounting

Exercise 9-9 Prepare a Report Showing Revenue and Spending Variances [LO9-2] Lavage Rapide is a Canadian...

Exercise 9-9 Prepare a Report Showing Revenue and Spending Variances [LO9-2]

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:

Fixed Cost
per Month
Cost per
Car Washed
Cleaning supplies $ 0.80
Electricity $ 1,200 $ 0.15
Maintenance $ 0.20
Wages and salaries $ 5,000 $ 0.30
Depreciation $ 6,000
Rent $ 8,000
Administrative expenses $ 4,000 $ 0.10

For example, electricity costs are $1,200 per month plus $0.15 per car washed. The company expects to wash 9,000 cars in August and to collect an average of $4.90 per car washed.

The actual operating results for August are as follows:

Lavage Rapide
Income Statement
For the Month Ended August 31
Actual cars washed 8,800
Revenue $ 43,080
Expenses:
Cleaning supplies 7,560
Electricity 2,670
Maintenance 2,260
Wages and salaries 8,500
Depreciation 6,000
Rent 8,000
Administrative expenses 4,950
Total expense 39,940
Net operating income $ 3,140

Required:

Calculate the company's revenue and spending variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values. Do not round intermediate calculations.)

Solutions

Expert Solution

  • Requirement

Actual Result

Revenue & Spending Variance

Flexible Budget

Cars washed

                     8,800

                                               8,800

[A]

[B = Difference between A & C]

[C = Fixed + (Var x Actual units)]

Revenues

$          43,080.00

$                        40.00

U

$                                   43,120.00

Expenses:

Cleaning Supplies

$            7,560.00

$                     520.00

U

$                                     7,040.00

Electricity

$            2,670.00

$                     150.00

U

$                                     2,520.00

Maintenance

$            2,260.00

$                     500.00

U

$                                     1,760.00

Wages & Salaries

$            8,500.00

$                     860.00

U

$                                     7,640.00

Depreciation

$            6,000.00

$                               -  

N

$                                     6,000.00

Rent

$            8,000.00

$                               -  

U

$                                     8,000.00

Administrative expense

$            4,950.00

$                        70.00

U

$                                     4,880.00

Total Expenses

$          39,940.00

$                  2,100.00

U

$                                   37,840.00

Net Operating Income

$            3,140.00

$                  2,140.00

U

$                                     5,280.00

--

Fixed part

+(

Variable part

x

Actual units

Revenues

(

$                  4.90

x

8800

Expenses:

Cleaning Supplies

$                      -  

+(

$                  0.80

x

8800

Electricity

$         1,200.00

+(

$                  0.15

x

8800

Maintenance

$                      -  

+(

$                  0.20

x

8800

Wages & Salaries

$         5,000.00

+(

$                  0.30

x

8800

Depreciation

$         6,000.00

+(

$                      -  

x

8800

Rent

$         8,000.00

+(

$                      -  

x

8800

Administrative expense

$         4,000.00

+(

$                  0.10

x

8800

Total Expenses

$      24,200.00

+(

$                  1.55

x

8800

Conceptual notes:

#1: Flexible Budget data is based on 'budgeted rates' applied on 'actual level/output/units'

#2: Spending Variance = Difference between 'Actual data' and 'Flexible Budget data'

#3: Activity Variance = Difference between 'Flexible Budget data' and 'Static/Planned Budget data'.

* Favourable Variance in case of Revenues occurs when:

>Actual revenues are MORE than Flexible budget revenues [Spending Variance]

>Flexible budget revenues are MORE than Static/Planned budget revenues [Activity Variance]

* Unfavourable Variance in case of Revenues occurs when:

>Actual revenues are LESS than Flexible budget revenues [Spending Variance]

>Flexible budget revenues are LESS than Static/Planned budget revenues [Activity Variance]

* Favourable Variance in case of Expenses/Costs occurs when:

>Actual expenses/costs are LESS than Flexible budget expense/costs [Spending Variance]

>Flexible budget expenses/costs are LESS than Static/Planned budget expenses/costs [Activity Variance]

* Unfavourable Variance in case of Expenses/Costs occurs when:

>Actual expenses/costs are MORE than Flexible budget expense/costs [Spending Variance]

>Flexible budget expenses/costs are MORE than Static/Planned budget expenses/costs [Activity Variance]


Related Solutions

Exercise 9-13 Revenue and Spending Variances [LO9-3] Lavage Rapide is a Canadian company that owns and...
Exercise 9-13 Revenue and Spending Variances [LO9-3] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.60 Electricity $ 1,100 $ 0.07 Maintenance $ 0.20 Wages and salaries $ 4,400 $ 0.40 Depreciation $ 8,200 Rent $ 2,000 Administrative expenses $ 1,700 $ 0.05 For example, electricity costs are $1,100 per...
Exercise 9-13 Revenue and Spending Variances [LO9-3] Lavage Rapide is a Canadian company that owns and...
Exercise 9-13 Revenue and Spending Variances [LO9-3] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.50 Electricity $ 1,000 $ 0.09 Maintenance $ 0.25 Wages and salaries $ 4,300 $ 0.20 Depreciation $ 8,500 Rent $ 1,900 Administrative expenses $ 1,600 $ 0.03 For example, electricity costs are $1,000 per...
Exercise 9-2 Prepare a Report Showing Revenue and Spending Variances [LO9-2] Quilcene Oysteria farms and sells...
Exercise 9-2 Prepare a Report Showing Revenue and Spending Variances [LO9-2] Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,900 pounds of oysters in August. The company’s flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) 7,900 Revenue ($4.10q) $ 32,390 Expenses: Packing supplies ($0.30q) 2,370 Oyster bed maintenance ($3,300) 3,300 Wages and salaries ($2,000 + $0.30q) 4,370 Shipping ($0.60q) 4,740 Utilities ($1,220)...
Exercise 9-12 Activity Variances [LO9-2] Lavage Rapide is a Canadian company that owns and operates a...
Exercise 9-12 Activity Variances [LO9-2] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.70 Electricity $ 1,000 $ 0.10 Maintenance $ 0.15 Wages and salaries $ 4,100 $ 0.20 Depreciation $ 8,100 Rent $ 1,800 Administrative expenses $ 1,500 $ 0.02 For example, electricity costs are $1,000 per month plus...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that...
Exercise 9-14 Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.80 Electricity $ 1,200 $ 0.09 Maintenance $ 0.15 Wages and salaries $ 4,500 $ 0.40 Depreciation $ 8,200 Rent $ 1,800 Administrative expenses $ 1,600 $ 0.02 For example, electricity costs are...
Exercise 9-14 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company...
Exercise 9-14 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.60 Electricity $ 1,100 $ 0.10 Maintenance $ 0.15 Wages and salaries $ 4,900 $ 0.30 Depreciation $ 8,100 Rent $ 2,200 Administrative expenses $ 1,800 $ 0.03 For example, electricity costs...
Exercise 9-11 Flexible Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a...
Exercise 9-11 Flexible Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.70 Electricity $ 1,400 $ 0.07 Maintenance $ 0.10 Wages and salaries $ 4,000 $ 0.30 Depreciation $ 8,400 Rent $ 1,900 Administrative expenses $ 1,800 $ 0.04 For example, electricity costs are $1,400 per month plus...
Exercise 9-10 Planning Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a...
Exercise 9-10 Planning Budget [LO9-1] Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs: Fixed Cost per Month Cost per Car Washed Cleaning supplies $ 0.80 Electricity $ 1,400 $ 0.08 Maintenance $ 0.25 Wages and salaries $ 4,500 $ 0.40 Depreciation $ 8,300 Rent $ 2,100 Administrative expenses $ 1,400 $ 0.02 For example, electricity costs are $1,400 per month plus...
Exercise 9-16 Flexible Budgets and Revenue and Spending Variances [LO9-1, LO9-3] Via Gelato is a popular...
Exercise 9-16 Flexible Budgets and Revenue and Spending Variances [LO9-1, LO9-3] Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per Month Variable Element per Liter Actual Total for June Revenue $ 12.00 $ 71,540 Raw materials $ 4.65 $ 29,230 Wages $ 5,600 $ 1.40 $ 13,860 Utilities $ 1,630 $ 0.20 $ 3,270 Rent $ 2,600 $ 2,600 Insurance $ 1,350...
Problem 9-22 Critique a Report; Prepare a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4, LO9-6] TipTop Flight...
Problem 9-22 Critique a Report; Prepare a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4, LO9-6] TipTop Flight School offers flying lessons at a small municipal airport. The school’s owner and manager has been attempting to evaluate performance and control costs using a variance report that compares the planning budget to actual results. A recent variance report appears below: TipTop Flight School Variance Report For the Month Ended July 31 Actual Results Planning Budget Variances Lessons 225 220 Revenue $ 60,400 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT