Question

AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 277 $ 36,030 Technician wages $ 8,200 $ 8,050 Mobile lab operating expenses $ 4,800 $ 31 $ 8,980 Office expenses $ 2,600 $ 2 $ 2,730 Advertising expenses $ 1,550 $ 1,620 Insurance $ 2,890 $ 2,890 Miscellaneous expenses $ 980 $ 1 $ 425 The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,800 plus $31 per job, and the actual mobile lab operating expenses for February were $8,980. The company expected to work 140 jobs in February, but actually worked 144 jobs. Required: Prepare a flexible budget performance report showing AirQual Test Corporation’s revenue and spending variances and activity variances for February. (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

Flexible Budget Performance Report
	Actual results	Revenue and spending variance		Flexible budget	Activity variance		Planning budget
Jobs	144			144			140
Revenue	$36,030	$3,858	U	$39,888 (144*$277)	$1,108	F	$38,780 (140*$277)
Expenses
Technician wages	8,050	150	F	8,200	0	None	8,200
Mobile lab operating expenses	8,980	284	F	9,264 [(144*$31)+4,800]	124	U	9,140 [(140*$31)+4,800]
Office expenses	2,730	158	F	2,888 [(144*$2)+2,600]	8	U	2,880 [(140*$2)+2,600]
Advertising expenses	1,620	70	U	1,550	0	None	1,550
Insurance	2,890	0	None	2,890	0	None	2,890
Miscellaneous expenses	425	699	F	1,124 [(144*$1)+980]	4	U	1,120 [(140*$1)+980]
Total expenses	24,695	1,221	F	25,916	136	U	25,780
Net operating income	$11,335	$2,637	U	$13,972	$972	F	$13,000