Requirement 2 Revise the data in your worksheet to reflect the results for the subsequent period as shown below. B D E 1 Chapter 10: Applying Excel 2 3 Data Exhibit 10-1 Standard Cosr Card 5 Inputs 6 Direct materials Direct labor 7 Variable manufacturing overhead B 9 Actual results 10 Actual output 11 Actual variable manufacturing overhead cost 12 13 Actual direct materials cost 14 Actual direct labor cost 15 Standard Quantity 3.0 pounds 0.50 hours 0 50 hours 5 $ $ Standard Price 4.00 per pound 22.00 per hour 8.00 per hour 5 2 130 units 5.800.00 Actual Quantity 8.230 pounds 876 hours 5 Actual price 430 per pound 22.40 per hour $ 2-1. What is the materiais quantity variance Indicate the effect of each variance by selecting "F" for favorable. "U" for unfavorable. and "None" for no effectie, zero variance)) The mount of tra mera's quantity Vance a-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 (l.e., zero varlance)). The amount of the materials price variance b.1. Wnete the cor efficiency yarance indicate the effect of each vartance by selecting "Efor favorable. U" for unfavorable. and "None" for no effect (ezero variance The storientace b-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 (le, zero variance): Round your final answer to nearest whole dollar amount.) The amount of the labor rate variance C-1. What is the variable overhead officiency variance? Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None for no effect e zero vanance) The amount of the vale overhead afficiency variance C-2 What is the variable overhead rate variance? (Indicate the effect of each vartance by selecting "F" for favorable. "U" for unfavorable, and "None" for no effect (Le.. zero varlance)). The amount of the variable overhead rate variance Requirement 2 Revise the data in your worksheet to reflect the results for the subsequent period as shown below. B D E A 1 Chapter 10: Applying Excel 2 3 Data 4 Exhibir 10-1: Standard Cost Card 5 Inputs 6 Direct materials 7 Direct tibor Variable manufacturing overhead 9 Actual results 10 Actual output 11 Actual variable manufacturing overhead cost 12 13 Actual direct materials cos! 14 Actual direct sbor cost 15 Standard Quantty 3.0 pounds 0.50 hours 0.50 hours $ $ $ Standard Price 4.00 per pound 22.00 per hour 0.00 per hour $ 2.130 units 3.600.00 Actual Quantity 0.230 pounds 878 hours $ $ Actual price 430 per pound 22 40 per hour 8-1. What is the materials quantity variance? Undicate the effect of each variance by selecting "F" for favorable. "U" for unfavorable, and "None" for no effect (Le., zero variance) The amount of the materials quantity wariance
