Exercise 9-16 (Algo) Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4]

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		$	35,890
Technician wages	$	8,200					$	8,050
Mobile lab operating expenses	$	5,000		$	34		$	9,600
Office expenses	$	2,400		$	4		$	2,810
Advertising expenses	$	1,570					$	1,640
Insurance	$	2,870					$	2,870
Miscellaneous expenses	$	950		$	1		$	395

The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $5,000 plus $34 per job, and the actual mobile lab operating expenses for February were $9,600. The company expected to work 140 jobs in February, but actually worked 148 jobs.

Required:

Prepare a flexible budget performance report showing AirQual Test Corporations 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 Flexible Results Budget Planning Budget Jobs 148 $ 35,890 Revenue Expenses Technician wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses Total expense Net operating income 8,050 9,600 2,810 1,640 2,870 395 25,365 $ 10,525