Please help me with b2, c1, and c2. Thanks! A1fxChapter 10: Applying ExcelAВCEF1 Chapter 10: Applying Excel23 Data4 Exhibit 10-1: Standard Cost CardIпрutsStandard Quantity2.9 poundsStandard Price6 Direct materials7 Direct labor8 Variable manufacturing overhead$4.00 per pound$22.00 per hour$6.00 per hour0.60 hours0.60 hours9.10 Actual results:Actual output112,000 units$7,140Actual Quantity6,500 pounds12Actual variable manufacturing overhead costActual price$3.80 per pound$21.60 per hour1314Actual direct materials cost15Actual direct labor cost1,050 hours1617 Enter a formula into each of the cells marked with a ? below18 Main Example: Chapter 101920 Exhibit 10-4: Standard Cost Variance Analysis- Direct Materials21 Standard Quantity Allowed for the Actual Output, at Standard Price22 Actual Quantity of Input, at Standard Price23 Actual Quantity of Input, at Actual Price5,800 pounds x6,500 pounds x6,500 pounds x$4.00 per pound =$4.00 per pound =$3.80 per pound =$23,200$26,000$24,70024 Direct materials variances:Materials quantity varianceMaterials price varianceMaterials spending variance$2,660 U$1,300 F$1,500 U2526272829 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor30 Standard Hours Allowed for the Actual Output, at Standard Rate31 Actual Hours of Input, at Standard Rate32 Actual Hours of Input, at Actual Rate$22.00 per hour =$22.00 per hour =$21.60 per hour =$26,400$23,100$22,6801,200 hours x1,050 hours x1,050 hours x33 Direct labor variances:Labor efficiency varianceLabor rate variance$3,300 F$420 F$3,720 F343536Labor spending variance3738 Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead39 Standard Hours Allowed for the Actual Output, at Standard Rate40 Actual Hours of Input, at Standard Rate41 Actual Hours of Input, at Actual Rate42 Variable overhead variances:1,200 hours x1,050 hours x1,050 hours x$6.00 per hour =$6.00 per hour =$6.80 per hour =$7,200$6,300$7,140$900 F$840 U$60 F43Variable overhead efficiency variance44Variable overhead rate variance45Variable overhead spending variance Requirement 2:Revise the data in your worksheet to reflect the results for the subsequent period as shown below:ABDE1 Chapter 10: Applying Excel23Data4Exhibit 10-1: Standard Cost CardInputsStandard QuantityStandard Price6.3.0 pounds4.00 per poundDirect materials7 Direct labor0.50 hours22.00 per hour8Variable manufacturing overhead0.50 hours6.00 per hour10 Actual results:11Actual output1,990 units12Actual variable manufacturing overhead cost7,018.0013Actual QuantityActual price14Actual direct materials cost6,060 pounds3.70 per pound15Actual direct labor cost1,210 hours22.10 per houra-1. What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the materials quantity variancea-2. What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the materials price varianceb-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,and "None" for no effect (i.e., zero variance)).The amount of the labor efficiency varianceb-2. What is the labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and"None" for no effect (i.e., zero variance). Round your final answer to nearest whole dollar amount.)The amount of the labor rate variancec-1. What is the variable overhead efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" forunfavorable, and "None" for no effect (i.e., zero variance)).The amount of the variable overhead efficiency variancec-2. What is the variable overhead rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" forunfavorable, and "None" for no effect (i.e., zero variance)).The amount of the variable overhead rate variance

The variance is the difference between the actual data and standard output.

Exhibit 10-1: Standard Cost Card Inputs Standard Quantity Standard Price 5 Direct materials Direct labor 3 Variable manufacturing overhead 3.0 pounds 4.00 per pound 0.50 hours 22.00 per hour 0.50 hours 6.00 per hour Actual results: 1,990 units 7,018.00 Actual output 2 Actual variable manufacturing overhead cost 3 Actual Quantity 6,060 pounds 1,210 hours Actual price 4 Actual direct materials cost 3.70 per pound 5 Actual direct labor cost 22.10 per hour . What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorabl d "None" for no effect (i.e., zero variance)).