Question

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 its measure of activity. For example, mobile lab operating expenses should be $4 600 plus $31 per job, and the actual mobile lab operating expenses for February were $8,780. The company expected to work 140 jobs in February, but actually worked 142 jobs Required: variances for February. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "Npne" for no effect (i.e., zero variance). Input all amounts as positive values.) AirQual Test C Flexible Budget Performance Report For the Month Ended February 28 Planning Flexible Actual 142 Jobs S 35,890 Revenue Expenses 7.950 Technician wages Mobile lab operating 1of 3lE Next> MacBook Ar

Answer 1

G H AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Actual Revenue and Flexible Activity Palnning Results spending variances Budget variance Budget 4 5 Jobs 142 142 140 3,302 U 7 Revenues 8 Expenses: 9 Technician wages 10 Mobile lab operating expenses 11 loffice expense 12 Advertising expense 13 Insurance 14 Miscellaneous expense 15 Total expense 16 Net operating income 35,890 39192 552 F 38640 7,950 8,780 2,670 1,630 2,880 565 24,475 11,415 8,100 9002 2826 1560 2880 1264 1,157F 25,632 2,145 UI 13,560 150 F 222F 156 F 70 U 8,100 8940 2820 1560 2880 1260 72 U 25,560 13,080 62|U 699 F 4 U 480 F

AirQual Test Corporation Flexible Budget Performance Report For the Month Ended Februarv 28 Revenue and Activity Actual Results Flexible Budget Palnning Budget spendin 4 variance 142 142 5 Jobs 140 7 Revenues 8 Expenses: 9 Technician wages 10 Mobile lab operating expenses 8780 11 office e 12 Advertising expense 13 Insurance 14 Miscellaneous expense 15 Total expense 16 Net operating income -+E7-H7 F +H5 276 35890 7950 -+E9-B9 F 8100 -+E10-B10 F +E11-B11 F +B12-E12 U 1560 HE13-B13 IN 2880 +E14-B14 F -+H9-E9 N 8100 31*H5 3*H5 3 E5 2670 1630 2880 565 SUM (B9:B14)+E15-B15 F +87-B15 +E11-H11 U +E12-H12 IN 1560 =+E13-H13N 2880 +E14-H14 U xpense 2*E5 2*H5 -SUM(E9:E14 E15-H15 U SUM(H9:H14 +E16-H16 F +H7-H15