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 | $ | 38,800 | |||||
Technician wages | $ | 8,500 | $ | 8,350 | |||||
Mobile lab operating expenses | $ | 4,700 | $ | 31 | $ | 9,190 | |||
Office expenses | $ | 2,600 | $ | 3 | $ | 2,900 | |||
Advertising expenses | $ | 1,560 | $ | 1,630 | |||||
Insurance | $ | 2,900 | $ | 2,900 | |||||
Miscellaneous expenses | $ | 930 | $ | 2 | $ | 535 | |||
The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,700 plus $31 per job, and the actual mobile lab operating expenses for February were $9,190. The company expected to work 150 jobs in February, but actually worked 160 jobs.
Required:
Prepare a flexible budget performance report showing AirQual Test Corporation’s revenue and spending variances and activity variances for February.
Solution:
AirQual Test Corporation | |||||||
Flexible Budget Performance Report | |||||||
For the month Ended February 28 | |||||||
Particulars | Actual results | Revenue and spending variances | Flexible Budget | Activity Variances | Planning Budget | ||
Flights | 160 | 160 | 150 | ||||
Revenue | $38,800.00 | $5,520.00 | U | $44,320.00 | $2,770.00 | F | $41,550.00 |
Expenses: | |||||||
Technical wages | $8,350.00 | $150.00 | F | $8,500.00 | $0.00 | None | $8,500.00 |
Mobile lab operating expenses | $9,190.00 | $470.00 | F | $9,660.00 | $310.00 | U | $9,350.00 |
Office Expenses | $2,900.00 | $180.00 | F | $3,080.00 | $30.00 | U | $3,050.00 |
Advertising Expense | $1,630.00 | $70.00 | U | $1,560.00 | $0.00 | None | $1,560.00 |
Insurance | $2,900.00 | $0.00 | None | $2,900.00 | $0.00 | None | $2,900.00 |
Miscellaneous Expenses | $535.00 | $715.00 | F | $1,250.00 | $20.00 | U | $1,230.00 |
Total expense | $25,505.00 | $1,445.00 | F | $26,950.00 | $360.00 | U | $26,590.00 |
Net Operating Income | $13,295.00 | $4,075.00 | U | $17,370.00 | $2,410.00 | F | $14,960.00 |
AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost...
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: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 277 $ 36,030 Technician wages $ 8,100 $ 7,950 Mobile lab operating expenses $ 4,700 $ 31 $ 8,880 Office expenses $ 2,400 $ 2 $ 2,530 Advertising expenses $ 1,610 $ 1,680 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: 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: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 275 $ 33,000 Technician wages $ 8,500 $ 8,350 Mobile lab operating expenses $ 4,700 $ 33 $ 8,830 Office expenses $ 2,800 $ 3 $ 3,040 Advertising expenses $ 1,610 $ 1,680 Insurance $ 2,880 $ 2,880 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 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 Variable Component per Job Actual Total for February Revenue $ 277 $ 36,030 Technician wages $ 8,100 $ 7,950 Mobile lab operating expenses $ 4,700 $ 33 $ 9,160 Office expenses $ 2,600 $ 2 $ 2,730 Advertising expenses $ 1,570 $ 1,640 Insurance $ 2,870 $ 2,870 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 Variable Component per Job Actual Total for February Revenue $ 277 $ 30,490 Technician wages $ 8,300 $ 8,150 Mobile lab operating expenses $ 4,900 $ 31 $ 8,460 Office expenses $ 2,300 $ 4 $ 2,630 Advertising expenses $ 1,610 $ 1,680 Insurance $ 2,870 $ 2,870 Miscellaneous expenses $...
8. 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,900 $ 31 $ 8,770 Office expenses $ 2,400 $ 3 $ 2,640 Advertising expenses $ 1,550 $ 1,620 Insurance $ 2,880 $ 2,880 Miscellaneous expenses...
8. 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,900 $ 31 $ 8,770 Office expenses $ 2,400 $ 3 $ 2,640 Advertising expenses $ 1,550 $ 1,620 Insurance $ 2,880 $ 2,880 Miscellaneous expenses...
irQual 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 $ 30,490 Technician wages $ 8,500 $ 8,350 Mobile lab operating expenses $ 4,700 $ 33 $ 8,500 Office expenses $ 2,300 $ 4 $ 2,630 Advertising expenses $ 1,550 $ 1,620 Insurance $ 2,880 $ 2,880 Miscellaneous expenses $...