amswer requirements a-c

Required information The Chapter 10 Form worksheet is to be used to create your own worksheet version of the main example in the box 15 Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below ook B C D E P Heferences Standard Quantity 3.0 pounds 0.50 hours 0.50 hours 5 5 $ Standard Price 4.00 per pound 22.Dolor hour 6.00 per hour 1 Chapter 10: Applying Excel 2 3 Data Exhibit 10-1: Standard Cost Card 5 6 Direct materials 7 Direct labor B Variable manufacturing over read 9. 10 Actual results 11 Actual output 12 Actual variable manufacturing overhead cost 13 14 Actul direct materials CO 15 Actual direct labor cost $ 1,080 unts 6,012.00 Actual unity 5.945 pounds 1.000 hours 5 $ Act price 380 per pound 2230 per hour Oasiy Required information 15 - What is the materials quantity variance? (indicate the effect of each variance by selecting "F* for favorable. "U" for unfavorable and "None" for no effecte, ero variancell The amount of the material quantity variance a-2. What is the materials price variance? Indicate the effect of each variance by selecting "Ffor favorable, "U" for unfavorable, and "None" for no effect ... zero variance The amount of the material price rance Check Required information 15 b-1. What is the labor efficiency variance? (Indicate the effect of each variance by selecting for favorable. "U" for unfavorable and "None" for no effect ile.. mere variancell The amount of the labor e claroy verlance P b 2. What is the labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "u"Por unfavorable, and "None" for no effectezero variance). Round your final answer to nearest whole dollar amount) The amount of the laborate one Ch 10 Excel Het Ceny 1 Required information 15 1. What is the variable overhead efficiency variance indicate the effect of each variance by selecting for everal for untavorable, and "None for newffectiero variancell The most of the variable define vince D -2. What is the variable overhead rate variance indicate the effect of each variance by selecting Portavorable "U" for unfavorable, and "None" for no effectie ero variancell The amount of the variable de variance