10 Exercise 9-16 (Algo) Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] oints AirQual Test Corporation...

Transcribed Image Text:

10 Exercise 9-16 (Algo) Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] oints 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 eBook Revenue per Job $ 277 Actual Total for February $ 36,030 Technician wages $ 8,200 $ 8,050 Mobile lab operating expenses $ 4,600 $ 35 $ 9,340 Office expenses $ 2,400 $ 4 $ 2,810 References Advertising expenses $ 1,550 $ 1,620 Insurance Miscellaneous expenses $ 2,900 $ 960 $ 2 $ 2,900 $ 545 Mc Graw Hill The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,600 plus $35 per job, and the actual mobile lab operating expenses for February were $9,340. The company expected to work 140 jobs in February, but actually worked 150 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.) AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Jobs Revenue Expenses: F1 Technician wages Actual Results 150 $ 36,030 8,050 Mohile lah onerating evnences a 310 @ 1 2 Q W A S F2 80 F3 a 01 F4 $ 14 #3 3 % 205 Flexible Budget Planning Budget < Prev 10 10 of 10 Next F5 F6 96 E R T Y D F G H & 87 F7 U * DII F8 8 00 9 J K Z X CV B N M H tion command A F9 F10 O < L P 4 F11 { H T command option F1 10 Exercise 9-16 (Algo) Flexible Budget Performance Report [LO9-1, LO9-2, LO9-3, LO9-4] oints 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 eBook Revenue per Job $ 277 Actual Total for February $ 36,030 Technician wages $ 8,200 $ 8,050 Mobile lab operating expenses $ 4,600 $ 35 $ 9,340 Office expenses $ 2,400 $ 4 $ 2,810 References Advertising expenses $ 1,550 $ 1,620 Insurance Miscellaneous expenses $ 2,900 $ 960 $ 2 $ 2,900 $ 545 Mc Graw Hill The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,600 plus $35 per job, and the actual mobile lab operating expenses for February were $9,340. The company expected to work 140 jobs in February, but actually worked 150 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.) AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Jobs Revenue Expenses: F1 Technician wages Actual Results 150 $ 36,030 8,050 Mohile lah onerating evnences a 310 @ 1 2 Q W A S F2 80 F3 a 01 F4 $ 14 #3 3 % 205 Flexible Budget Planning Budget < Prev 10 10 of 10 Next F5 F6 96 E R T Y D F G H & 87 F7 U * DII F8 8 00 9 J K Z X CV B N M H tion command A F9 F10 O < L P 4 F11 { H T command option F1