Need some assistant with completing this assignment. I seem to have some issues with my formulas.

AirQual Test Corporation provides on-site air quality testing services. The company has provided the following data concerning its operations: Revenue Technician wages Mobile lab operating expenses Office expenses Advertising expenses Insurance Miscellaneous expenses Fixed Variable Actual Component Component Total for per Month per Job February $ 276 $27,610 $ 8,300 $ 8,150 $ 4,800 $ 27 $ 7,930 $ 2,500 $ 3 $ 2,680 $ 1,580 $ 1,650 $ 2,890 $ 2,890 $ 940 $ 2 $ 465 The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,800 plus $27 per job, and the actual mobile lab operating expenses for February were $7,930. The company expected to work 110 jobs in February, but actually worked 106 jobs. Required: Complete the 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.) Solution:- Computation of the Flexible Budget Performance Report AirQual Test Corporation Flexible Budget Performance Report For the Month E nded February 28 Particulars Planning Budget Activity Variances F/ U Flexible Budget J (q) obs 110 110 Revenue ($276.00q) $ 30,360 $ (1,104) F $ 29,256 Expenses: Technician wages ($8,300) $ 8,300 $ $ 8,300 Mobile lab operating expenses ($4,800 + $27.00q) $ 7,770 $ U $ 7,770 Office expenses ($2,500 + $3.00q) $ 2,830 $ (12) U $ 2,818 Advertising expenses ($1580) $ 1,580 $ $ 1,580 Insurance ($2,890) $ 2,890 $ $ 2,890 Miscellaneous expenses ($940 + $2.00q) $ 1,160 $ (8) U $ 1,152 Total expense $ 24,530 $ (20) U $ 24,510 Net operating income $ 5,830 $ (1,084) F $ 4,746 Revenue and Spending Variances F/ UActual Results 106 $ (1,646) F $ 27,610 $ $ $ $ $ $ $ $ (150) 160 (138) 70 687 (745) (901) U F U U $ $ $ $ $ F $ U $ F $ 8,150 7,930 2,680 1,650 2,890 465 23,765 3,845 0 0 0 2 0 "_ {"":7 "_ "_ ,"N O T L ":7 "_ "_ ,"}}% 4 "_ ,":2 "_ ,"u tr":6 "_ "_ ,"Y C E R ":7 "_ "_ ,"}}9 0 :"5 7 "0 0 % 3 :"5 1 2 :{1 1 "I U O "S 6 :{5 5 2 ":"1 8 3 5 e 3 :{5 5 "N R U "C 3 :{9 2 "0 -1 "_ {"":_ ,""}:"9 7 "i1 o r:"5 0 "_ ,"~ n sv~ rev: 11_14_2014_QC_59324 Solution:- Computation of the Flexible Budget Performance Report AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Particulars Jobs (q) Revenue ($276.00q) Expenses: Technician wages ($8,300) Mobile lab operating expenses ($4,800 + $27.00q) Office expenses ($2,500 + $3.00q) Advertising expenses ($1580) Insurance ($2,890) Miscellaneous expenses ($940 + $2.00q) Total expense Net operating income Planning Budget Activity Variances F/U Flexible Budget 110 $30,360 $8,300 $7,770 $2,830 $1,580 $2,890 $1,160 $24,530 $5,830 $(1,104) F $$$(12) $$$(8) $(20) $(1,084) U U U U F 110 $29,256 $8,300 $7,770 $2,818 $1,580 $2,890 $1,152 $24,510 $4,746 Revenue and Spending Variances F/U Actual Results $(1,646) F 106 $27,610 $(150) $160 $(138) $70 $$687 $(745) $(901) $8,150 $7,930 $2,680 $1,650 $2,890 $465 $23,765 $3,845 U F U U F U F Comprehensive Variance Analysis [LO2, LO3, LO4] Miller Toy Company manufactures a plastic swimming pool at its Westwood Plant. The plant has been experiencing problems as shown by its June contribution format income statement below: Budgeted Actual Sales (15,000 pools) . . . . . . . . . . . . . . . . . . . . $450,000 $450,000 Variable expenses: Variable cost of goods sold* . . . . . . . . . . . . 180,000 196,290 Variable selling expenses . . . . . . . . . . . . . . 20,000 20,000 Total variable expenses . . . . . . . . . . . . . . . . . . 200,000 216,290 Contribution margin . . . . . . . . . . . . . . . . . . . . . 250,000 233,710 Fixed expenses: Manufacturing overhead . . . . . . . . . . . . . . . 130,000 130,000 Selling and administrative . . . . . . . . . . . . . . 84,000 84,000 Total fixed expenses . . . . . . . . . . . . . . . . . . . . 214,000 214,000 Net operating income . . . . . . . . . . . . . . . . . . . $ 36,000 $ 19,710 Janet Dunn, who has just been appointed general manager of the Westwood Plant, has been given instructions to \"get things under control.\" Upon reviewing the plant's income statement, Ms. Dunn has concluded that the major problem lies in the variable cost of goods sold. She has been provided with the following standard cost per swimming pool: Standard Quantity Standard Standard Price Standard or Hours or Rate Cost Direct materials . . . . . . . . . . . . . . . . . 3.0 pounds $2.00 per pound $ 6.00 Direct labor . . . . . . . . . . . . . . . . . . . . 0.8 hours $6.00 per hour 4.80 Variable manufacturing overhead . . . 0.4 hours* $ 3.00 per hour 1.20 Total standard cost . . . . . . . . . . . . . . $12.00 *Based on machine-hours. During June the plant produced 15,000 pools and incurred the following costs: a. Purchased 60,000 pounds of materials at a cost of $1.95 per pound. b. Used 49,200 pounds of materials in production. (Finished goods and work in process inventories are insignificant and can be ignored.) c. Worked 11,800 direct labor-hours at a cost of $7.00 per hour. d. Incurred variable manufacturing overhead cost totaling $18,290 for the month. A total of 5,900 machine-hours were recorded. It is the company's policy to close all variances to cost of goods sold on a monthly basis. Required: 1. Compute the following variances for June: a. Direct materials price and quantity variances. b. Direct labor rate and efficiency variances. c. Variable overhead rate and efficiency variances. 2. Summarize the variances that you computed in (1) above by showing the net overall favorable or unfavorable variance for the month. What impact did this figure have on the company's income statement? Show computations. 3. Pick out the two most significant variances that you computed in (1) above. Explain to Ms. Dunn possible causes of these variances. This assignment has 2 parts to it. Solution please check word document