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 | $ | 277 | $ | 33,260 | |||||
Technician wages | $ | 8,600 | $ | 8,450 | |||||
Mobile lab operating expenses | $ | 4,500 | $ | 34 | $ | 8,760 | |||
Office expenses | $ | 2,400 | $ | 3 | $ | 2,640 | |||
Advertising expenses | $ | 1,550 | $ | 1,620 | |||||
Insurance | $ | 2,860 | $ | 2,860 | |||||
Miscellaneous expenses | $ | 930 | $ | 2 | $ | 495 | |||
The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,500 plus $34 per job, and the actual mobile lab operating expenses for February were $8,760. 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.)
Flexible budget performance report | |||||||||
Actual | Revenue & spending | Flexible | Activity variance | Static budget | |||||
budget | variance | budget | |||||||
no of jobs | 138 | 138 | 130 | ||||||
Revenue | 33,260 | 4,966 | U | 38226 | 2216 | F | 36010 | ||
less:Exoenses | |||||||||
Technicial wages | 8,450 | 150 | F | 8,600 | 0 | N | 8,600 | ||
mobile lab operating expense | 8,760 | 432 | F | 9192 | 272 | U | 8920 | ||
office expense | 2,640 | 174 | F | 2814 | 24 | U | 2790 | ||
advertising expense | 1,620 | 70 | U | 1,550 | 0 | N | 1,550 | ||
insurance | 2,860 | 0 | N | 2,860 | 0 | N | 2,860 | ||
miscellaneous expense | 495 | 711 | F | 1,206 | 16 | U | 1,190 | ||
total expense | 24,825 | 1,397 | F | 26,222 | 312 | U | 25,910 | ||
net operating income | 8,435 | 3,569 | U | 12,004 | 1,904 | F | 10,100 | ||
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...
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
$...
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 Revenue Technician wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses $ 8,600 $ 4,500 $ 2,500 1,570 2,860 $ 960 Variable Actual Total Component per Job for February $ 277 $ 36,030 $ 8,450 $ 34 $ 9, 100 $ 3 $ 2,770 $ 1,640 $ 2,860...
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 Actual Total Component per Job for February 30,730 7,950 8,680 $ 2,910 1,690 $ 2,880 Variable $ 279 Revenue Technician wages Mobile lab operating expenses office expenses Advertising expenses 8,100 5,000 2,700 32 $ 3 1,620 2,880 960 Insurance Miscellaneous expenses $ 2 505 The company uses the number of jobs...
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: Revenue Technician wages Mobile lab operating expenses office expenses Advertising expenses Insurance Miscellaneous expenses Variable Fixed Component Component per Actual Total per Month Job for February $ 280 $ 39,250 $ 8,100 $ 7,950 $ 5,000 $ 33 $ 9,790 $ 2,500 $ 3 $ 2,800 $ 1,580 $ 1,650 $ 2,860 $ 2,860 $...
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 Revenue Technician wages Mobile lab operating expenses office expenses Advertising expenses Insurance Miscellaneous expenses Variable Fixed Component component per Actual Total per Month Job for February $ 277 $ 33,260 | 0 $ 3,150 $4,600 $ 30 $ 8, 340 $ 2,200 $ 3 $ 2,440 $1,600 $ 1.670 $ 2,860 $ 2,860 $ 1...
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: Variable Fixed Component Component per Actual Tota.l per Month Job $278 Revenue Technician wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses $ 8,000 $4,900 $ 2,400 $ 1,610 $ 2,850 $ 950 for February $30,610 $ 7,850 $ 8,460 $ 2,730 $ 1,680 $ 2,850 $ 375 $ 31 The company...
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: Variable Fixed Component Component per Actual Total for February Job per Month $27,610 $8,350 $8,170 $ 2,780 $ 1,660 $ 2,850 $ $276 Revenue Technician wages Mobile lab operating expenses Office expenses Advertising expenses $ 8,500 $4,700 $ 2,600 $1,590 $2,850 $ $33 $ 3 Insurance Miscellaneous expenses $ 960 1 375 The company uses...
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: Actual Total Component per Job for February Variable $280 $ 30 Fixed Component per Month Revenue Technician wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses 串 8,600 串 4,700 $ 2,800 $ 1,560 $ 2,890 $ 950 33,650 8,450 8,440 3,040 1,630 2,890 $385 The company uses the number of jobs...
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: Pixed Component Component per Actual Total bruar Job 276 $35,890 7,950 $ 8,780 $ 2,670 s 1,630 s 2,880 5 565 Technician vages Mobile lab operating expenses office expenses Advertising expenses Insurance Miscellaneous expenses $ 8,100 4,600 $ 2,400 1,560 2,880 $ 980 s 31 eBook References The company uses the number of jobs as...
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 Variable Fixed Component Component per Actual Total per Month Job Revenue Technieian wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses 8,400 S4,500 2,300 1,610 2,850 $ 970 for February S33,520 $ 8,250 $ 8,630 2,670 1,680 2,850 S 33 405 The company uses the number of jobs as its measure of...