Question

Jake’s Roof Repair has provided the following data concerning its costs:

	Fixed Cost per Month			Cost per Repair-Hour
Wages and salaries	$	20,900		$	15.00
Parts and supplies				$	7.60
Equipment depreciation	$	2,760		$	0.40
Truck operating expenses	$	5,710		$	1.80
Rent	$	4,660
Administrative expenses	$	3,890		$	0.80

For example, wages and salaries should be $20,900 plus $15.00 per repair-hour. The company expected to work 2,600 repair-hours in May, but actually worked 2,500 repair-hours. The company expects its sales to be $52.00 per repair-hour.

Required:

Compute the company’s activity variances for May. (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.)

Answer 1

Answers

• Requirement: Activity Variances

	Activity variance
Revenues	$            5,200.00	U
Expenses:
Wages & Salaries	$            1,500.00	F
Parts and Supplies	$                760.00	F
Equipment depreciation	$                  40.00	F
Truck Operating Expenses	$                180.00	F
Rent	$                         -	None
Administrative	$                  80.00	F
Total Expenses	$            2,560.00	F
Net Operating Income	$            2,640.00	U

• Workings

		WORKING COLUMNS				Flexible Budget	Activity variance		Planning Static Budget
Repair Hours						2,500			2,600
Revenues				$    52.00		$ 130,000.00	$            5,200.00	U	$        135,200.00
Expenses:
Wages & Salaries	(	$ 20,900.00	)	$    15.00	x 2500 or 2600	$    58,400.00	$            1,500.00	F	$          59,900.00
Oarts and Supplies	(	$                 -	+	$      7.60	x 2500 or 2600	$    19,000.00	$                760.00	F	$          19,760.00
Equipment depreciation	(	$    2,760.00	+	$      0.40	x 2500 or 2600	$      3,760.00	$                  40.00	F	$             3,800.00
Truck Operating Expenses	(	$    5,710.00	+	$      1.80	x 2500 or 2600	$    10,210.00	$                180.00	F	$          10,390.00
Rent	(	$    4,660.00	)	$           -	x 2500 or 2600	$      4,660.00	$                         -	None	$             4,660.00
Administrative	(	$    3,890.00	+	$      0.80	x 2500 or 2600	$      5,890.00	$                  80.00	F	$             5,970.00
Total Expenses		$ 37,920.00		$    25.60		$ 101,920.00	$            2,560.00	F	$        104,480.00
Net Operating Income						$    28,080.00	$            2,640.00	U	$          30,720.00