Activity variance |
||
Revenues |
$ 660.00 |
F |
Expenses: |
||
Cleaning Supplies |
$ 40.00 |
U |
Electricity |
$ 9.00 |
U |
Maintenance |
$ 20.00 |
U |
Wages & Salaries |
$ 40.00 |
U |
Depreciation |
$ - |
None |
Rent |
$ - |
None |
Administrative expense |
$ 2.00 |
U |
Total Expenses |
$ 111.00 |
U |
Net Operating Income |
$ 549.00 |
F |
--Workings
Conceptual notes: |
#1: Flexible Budget data is based on 'budgeted rates' applied on 'actual level/output/units' |
#2: Activity Variance = Difference between 'Flexible Budget data' and 'Static/Planned Budget data'. |
* Favourable Variance in case of Revenues occurs when: |
>Flexible budget revenues are MORE than Static/Planned budget revenues [Activity Variance] |
* Unfavourable Variance in case of Revenues occurs when: |
>Flexible budget revenues are LESS than Static/Planned budget revenues [Activity Variance] |
* Favourable Variance in case of Expenses/Costs occurs when: |
>Flexible budget expenses/costs are LESS than Static/Planned budget expenses/costs [Activity Variance] |
* Unfavourable Variance in case of Expenses/Costs occurs when: |
>Flexible budget expenses/costs are MORE than Static/Planned budget expenses/costs [Activity Variance] |
WORKING COLUMNS |
Flexible Budget |
Planning Static Budget |
||||||
Cars washed |
8,200 |
8,100 |
||||||
[C = Fixed + (Var x Actual units)] |
[E= Fixed + (Var x Planned units)] |
|||||||
Fixed part |
+( |
Variable part |
x |
Actual/Planned units |
) |
|||
Revenues |
( |
$ 6.60 |
x |
8200 or 8100 |
) |
$ 54,120.00 |
$ 53,460.00 |
|
Expenses: |
||||||||
Cleaning Supplies |
$ - |
+( |
$ 0.40 |
x |
8200 or 8100 |
) |
$ 3,280.00 |
$ 3,240.00 |
Electricity |
$ 1,400.00 |
+( |
$ 0.09 |
x |
8200 or 8100 |
) |
$ 2,138.00 |
$ 2,129.00 |
Maintenance |
$ - |
+( |
$ 0.20 |
x |
8200 or 8100 |
) |
$ 1,640.00 |
$ 1,620.00 |
Wages & Salaries |
$ 4,300.00 |
+( |
$ 0.40 |
x |
8200 or 8100 |
) |
$ 7,580.00 |
$ 7,540.00 |
Depreciation |
$ 8,000.00 |
+( |
$ - |
x |
8200 or 8100 |
) |
$ 8,000.00 |
$ 8,000.00 |
Rent |
$ 1,800.00 |
+( |
$ - |
x |
8200 or 8100 |
) |
$ 1,800.00 |
$ 1,800.00 |
Administrative expense |
$ 1,500.00 |
+( |
$ 0.02 |
x |
8200 or 8100 |
) |
$ 1,664.00 |
$ 1,662.00 |
Total Expenses |
$ 17,000.00 |
+( |
$ 1.11 |
x |
8200 or 8100 |
) |
$ 26,102.00 |
$ 25,991.00 |
Net Operating Income |
$ 28,018.00 |
$ 27,469.00 |
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility...
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 $1,100 cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.40 $0.09 $0.30 $0.30 $4,000 $8,500 $2,100 $1,400 $0.04 For example, electricity costs are $1,100 per month plus $0.09 per car washed. The company expects to wash 8,400 cars in August and to...
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 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.70 $0.09 $0.20 $0.40 $1,200 $4,600 $ 8,400 $2,000 $1,400 $0.01 For example, electricity costs are $1,200 per month plus $0.09 per car washed. The company expects to wash 8100 cars in August and...
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.09 Maintenance $ 0.30 Wages and salaries $ 4,700 $ 0.40 Depreciation $ 8,200 Rent $ 1,900 Administrative expenses $ 1,700 $ 0.02 For example, electricity costs are $1,400 per month plus $0.09 per car washed. The...
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 $0.70 $0.99 $ 0.25 $0.40 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $1,100 $4,700 $8,100 $2,200 $1,400 $0.03 For example, electricity costs are $1,100 per month plus $0.09 per car washed. The company expects to wash 8,300 cars in August and...
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 $1,000 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.70 $0.06 $0.20 $0.40 $4,200 $8,000 $2,000 $1,800 $0.03 For example, electricity costs are $1,000 per month plus $0.06 per car washed. The company expects to wash 8,500 cars in August and to...
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 $ 1,400 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $ 0.50 $ 0.09 $ 0.20 $ 0.40 $ 4,900 $ 8,300 $ 1,900 $ 1,500 $ 0.05 For example, electricity costs are $1,400 per month plus $0.09 per car washed. The...
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 $0.50 $0.10 $0.20 $0.40 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $1,100 $4,600 $8,100 $1.900 $1,800 $0.01 For example, electricity costs are $1,100 per month plus $0.10 per car washed. The company expects to wash 8,300 cars in August and to...
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 $1,500 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.40 $0.09 $0.10 $0.40 $4,000 $8,100 $2.100 $1.800 $0.04 For example, electricity costs are $1,500 per month plus $0.09 per car washed. The company expects to wash 8,200 cars in August and to...
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.40 Electricity $ 1,400 $ 0.05 Maintenance $ 0.30 Wages and salaries $ 4,200 $ 0.30 Depreciation $ 8,200 Rent $ 2,100 Administrative expenses $ 1,600 $ 0.04 For example, electricity costs are $1,400 per month plus $0.05 per car washed. The...
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,200 $ 0.09 Maintenance $ 0.20 Wages and salaries $ 4,600 $ 0.30 Depreciation $ 8,200 Rent $ 2,100 Administrative expenses $ 1,500 $ 0.01 For example, electricity costs are $1,200 per month plus $0.09 per car washed. The...