Question

In: Accounting

Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB...

Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3]

You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control.

After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:

Cost Formula Actual Cost in March
Utilities $16,400 plus $0.18 per machine-hour $ 21,080
Maintenance $38,600 plus $2.10 per machine-hour $ 66,000
Supplies $0.80 per machine-hour $ 12,600
Indirect labor $94,900 plus $2.00 per machine-hour $ 127,800
Depreciation $68,400 $ 70,100

During March, the company worked 14,000 machine-hours and produced 8,000 units. The company had originally planned to work 16,000 machine-hours during March.

Required:

1. Calculate the activity variances for March.

2. Calculate the spending variances for March.

Solutions

Expert Solution

1. Activity Variance

FAB Corporation

Activity Variances

For the Month ended March 31

Utilities

$360

F

Maintenance

$4,200

F

Supplies

$1,600

F

Indirect Labor

$4,000

F

Depreciation

None

Total

$10,160

F

2. Spending Variances

FAB Corporation

Spending Variances

For the Month ended March 31

Utilities

$2,160

U

Maintenance

$2,000

F

Supplies

$1,400

U

Indirect Labor

$4,900

U

Depreciation

$1,700

U

Total

$8,160

U

Explanation:

1 Activity Variances

FAB Corporation

Activity Variances

For the month ended March 31

Flexible Budget

Planning Budget

Activity Variances

Machine Hours (q)

14,000

16,000

Utilities ($16,400+$0.18q)

$18,920

$19,280

$360 F

Maintenance ($38,600+$2.10q)

$68,000

$72,200

$4,200 F

Supplies ($0.80q)

$11,200

$12,800

$1,600 F

Indirect labor ($94,900+$2.00q)

$122,900

$126,900

$4,000 F

Depreciation ($68,400)

$68,400

$68,400

None

Total

$289,420

$299,580

$10,160 F

2. Spending Variances

FAB Corporation

Spending Variances

For the month ended March 31

Actual Result

Flexible Budget

Spending Variances

Machine Hours (q)

14,000

14,000

Utilities ($16,400+$0.18q)

$21,080

$18,920

$2,160 U

Maintenance ($38,600+$2.10q)

$66,000

$68,000

$2,000 F

Supplies ($0.80q)

$12,600

$11,200

$1,400 U

Indirect labor ($94,900+$2.00q)

$127,800

$122,900

$4,900 U

Depreciation ($68,400)

$70,100

$68,400

$1,700 U

Total

$297,580

$289,420

$8,160 U

"It would be appreciated if you give your feedback"


Related Solutions

Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB...
Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in...
Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB...
Problem 9-20 Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in...
Problem 9-18 (Algo) Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by...
Problem 9-18 (Algo) Activity and Spending Variances [LO9-1, LO9-2, LO9-3] You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step...
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...
Item 3 Item 3 You have just been hired by FAB Corporation, the manufacturer of a...
Item 3 Item 3 You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control. After...
Problem 9-20 (Algo) Critique a Report; Prepare a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] TipTop Flight...
Problem 9-20 (Algo) Critique a Report; Prepare a Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] 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 145 140 Revenue $ 33,110 $...
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...
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)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT