Answer:
AirQual Test Corporation
Flexible Budget:
Fixed Variable Actual Flexible Variance
Revenue $276 $35,890 $41,400 ($5,510) U
Technician wages $8,600 $8,450 8,600 150 F
Mobile lab operating exp. $4,600 $34 $9,200 9,700 500 F
Office expenses $2,800 $3 $3,070 3,250 180 F
Advertising expenses $1,580 $1,650 1,580 (70) U
Insurance $2,890 $2,890 2,890 0 N/A
Miscellaneous expenses $930 $1 $375 1,080 705 F
Total $10,255 $14,300 $4,045 U
Explanation:
a) Data and Calculations:
Fixed Variable Actual
Revenue $276 $35,890
Technician wages $8,600 $8,450
Mobile lab operating exp. $4,600 $34 $9,200
Office expenses $2,800 $3 $3,070
Advertising expenses $1,580 $1,650
Insurance $2,890 $2,890
Miscellaneous expenses $930 $1 $375
Expected number of jobs to be worked = 140
Actual number of jobs worked = 150
Flexible costs:
Revenue = $276 * 150 = $41,400
Mobile lab operating expense:
Fixed element = $4,600
Variable element = $34 * 150 = $5,100
Total flexible budget = $9,700
Office Expenses:
Fixed element = $2,800
Variable element = $3 * 150 = $450
Total flexible budget = $3,250
Miscellaneous expenses:
Fixed element = $930
Variable element = $1 * 150 = $150
Total flexible budget = $1,080
Spending Variances:
Technician wages $8,600 $8,450 8,600 150 F
Advertising expenses $1,580 $1,650 1,580 (70) U
Insurance $2,890 $2,890 2,890 0 N/A
Spending variances = $80 F
Activity Variances:
Mobile lab operating exp. $4,600 $34 $9,200 9,700 500 F
Office expenses $2,800 $3 $3,070 3,250 180 F
Miscellaneous expenses $930 $1 $375 1,080 705 F
Total activity variances = $1,385 F