AirQual Test Corporation provides on-site air quality testing services. The company has provided the following data concerning its operations:



Fixed
Component
per Month	Variable
Component
per Job	Actual
Total for
February
  Revenue		  	$	280     	$	28,050
  Technician wages	$	8,400      		    	$	8,250
  Mobile lab operating expenses	$	4,700      	$	29     	$	8,050
  Office expenses	$	2,600      	$	3     	$	2,780
  Advertising expenses	$	1,610      			$	1,680
  Insurance	$	2,900      			$	2,900
  Miscellaneous expenses	$	920      	$	1     	$	335


The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,700 plus $29 per job, and the actual mobile lab operating expenses for February were $8,050.

     The company expected to work 110 jobs in February, but actually worked 106 jobs.


Required:
Complete the 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.)

Expert Answer
Anonymous
Anonymous answered this Was this answer helpful?
0
0
1,631 answers
Column	1	2 ( 3-1)	3	4 (5-3)	5	6 (5-1)
Actual	Rate Variance	Flexible	Efficiency Variance	Budget	Spending Variance
No of Jobs	106	0	106	4 units U	110	4 units U
Revenue	28050	1630 U	29680	1120 U	30800	2750 U
Cost:
Technician wages	8250	150 F	8400	0 F	8400	150 F
Mobile Lab Operating	8050	276 U	7774	116 F	7890	160 U
Office Expenses	2780	138 F	2918	12 F	2930	150 F
Advertising Expenses	1680	70 U	1610	0 F	1610	70 U
Insurance	2900	0 F	2900	0 F	2900	0 F
Miscellaneous Expenses	335	691 F	1026	4 F	1030	695 F
Total Cost	23995	633 F	24628	132 F	24760	765 F
Net Income	4055	997 U	5052	988 U	6040	1985 U
Revenue rate variance = Actual Revenue-Flexible budget Revenue
Revenue Efficiency Variance = Flexible Budget Revenue - Budgeted Revenue.
Rate variance for expenses = Flexible Budget Expense - Actual Expenses
Efficiency Variance fior expenses = Budgeted Expenses - Flexible Budget Expense	Comment