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				$	279		$	36,310
Technician wages	$	8,500					$	8,350
Mobile lab operating expenses	$	4,800		$	33		$	9,260
Office expenses	$	2,500		$	4		$	2,910
Advertising expenses	$	1,570					$	1,640
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 $33 per job, and the actual mobile lab operating expenses for February were $9,260. The company expected to work 140 jobs in February, but actually worked 148 jobs.

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

Here we have to prepare the static budget and flexible budget.
Static budget is the total revenue and cost as per the cost formula given in question along with the planned activity i.e 140 Jobs.
Flexible budget is the total revenue and cost as per the cost formula given but for the actual activity level i.e 148 jobs.

Spending Variance = Flexible Budget - Actual budget
Activity Variance = Static budget - Flexible budget