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				$	276		$	33,130
Technician wages	$	8,300					$	8,150
Mobile lab operating expenses	$	4,900		$	34		$	9,160
Office expenses	$	2,300		$	4		$	2,670
Advertising expenses	$	1,560					$	1,630
Insurance	$	2,860					$	2,860
Miscellaneous expenses	$	950		$	1		$	385

The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,900 plus $34 per job, and the actual mobile lab operating expenses for February were $9,160. The company expected to work 130 jobs in February, but actually worked 138 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.)

AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Actual Results Flexible Budget Planning Budget Jobs 138 Revenue $ 33,130 Expenses Technician wages Mobile lab operating Office expenses Advertising expenses Insurance Miscellaneous expenses 8,150 9,160 2,670 1,630 2,860 385 24,855 $ 8,275 expenses Total expense Net operating income

Answer 1

Solution:

AirQual Test Corporation
Flexible Budget Performance Report
For the month Ended February 28
Particulars	Actual results	Revenue and spending variances		Flexible Budget	Activity Variances		Planning Budget
Flights	138			138			130
Revenue	$33,130.00	$4,958.00	U	$38,088.00	$2,208.00	F	$35,880.00
Expenses:
Technical wages	$8,150.00	$150.00	F	$8,300.00	$0.00	None	$8,300.00
Mobile lab operating expenses	$9,160.00	$432.00	F	$9,592.00	$272.00	U	$9,320.00
Office Expenses	$2,670.00	$182.00	F	$2,852.00	$32.00	U	$2,820.00
Advertising Expense	$1,630.00	$70.00	U	$1,560.00	$0.00	None	$1,560.00
Insurance	$2,860.00	$0.00	None	$2,860.00	$0.00	None	$2,860.00
Miscellaneous Expenses	$385.00	$703.00	F	$1,088.00	$8.00	U	$1,080.00
Total expense	$24,855.00	$1,397.00	F	$26,252.00	$312.00	U	$25,940.00
Net Operating Income	$8,275.00	$3,561.00	U	$11,836.00	$1,896.00	F	$9,940.00