Actual | Revenue/Spending Variance | Flexible | ||
Cars washed | 8,800 | 8,800 | ||
Revenue | $43,080 | $40 | U | $43,120 |
Expenses: | ||||
Cleaning supplies | $7,560 | $520 | U | $7,040 |
Electricity | $2,670 | $150 | U | $2,520 |
Maintenance | $2,260 | $500 | U | $1,760 |
Wages and salaries | $8,500 | $860 | U | $7,640 |
Depreciation | $6,000 | $0 | None | $6,000 |
Rent | $8,000 | $0 | None | $8,000 |
Administrative expenses | $4,950 | $70 | U | $4,880 |
Total expenses | $39,940 | $2,100 | U | $37,840 |
Net operating income | $3,140 | $2,140 | U | $5,280 |
Revenue or spending variance = Actual budget - Flexible budget
If Actual revenue and Net operating income is more than the flexible then it is Favorable (F). Otherwise Unfavorabel (U)
If Actual Expenses are less than the flexible then it is Favorable (F). Otherwise Unfavorable (U).
Calculations:
Flexible budget
Flexible budget (8,800 cars washed) | |||||||
Cars washed | x | Variable unit cost | = | Total variable cost (i) | Fixed cost (ii) | Total (i) + (ii) | |
Revenue | 8,800 | $4.90 | = | $43,120 | $43,120 | ||
Cleaning supplies | 8,800 | x | $0.80 | = | $7,040 | $7,040 | |
Electricity | 8,800 | x | $0.15 | = | $1,320 | $1,200 | $2,520 |
Maintenance | 8,800 | x | $0.20 | = | $1,760 | $1,760 | |
Wages and salaries | 8,800 | x | $0.30 | = | $2,640 | $5,000 | $7,640 |
Depreciation | 8,800 | x | $6,000 | $6,000 | |||
Rent | 8,800 | x | $8,000 | $8,000 | |||
Administrative expenses | 8,800 | x | $0.10 | = | $880 | $4,000 | $4,880 |
* Format Painter BIU - ab X, X A- Clipboard Font Lavage Rapide is a Canadian...
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,200 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.se $0.15 $0.20 $0.30 $5,000 $6,000 $8,000 $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...
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...
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.80 $0.15 $0.20 $0.30 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $1,200 $5,000 $6,000 $8,000 $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...
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...
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,200 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $0.80 $0.15 $0.20 $0.30 $5,000 $6,000 $ 8,000 $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...
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.06 Maintenance $ 0.15 Wages and salaries $ 4,300 $ 0.40 Depreciation $ 8,000 Rent $ 2,100 Administrative expenses $ 1,400 $ 0.01 For example, electricity costs are $1,200 per month plus $0.06 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.50 Electricity $ 1,200 $ 0.07 Maintenance $ 0.15 Wages and salaries $ 4,700 $ 0.30 Depreciation $ 8,000 Rent $ 2,100 Administrative expenses $ 1,800 $ 0.03 For example, electricity costs are $1,200 per month plus $0.07 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.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...
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.07 $ 0.15 $ 0.20 cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $1,300 $4,900 $8,000 $2,000 $1,800 $ 0.04 For example, electricity costs are $1,300 per month plus $0.07 per car washed. The company actually washed 8,500 cars...
Lavage Rapide is a Canadian company that owns and operates a large automatic carwash 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...