Chapter $09$: Applying Excel: Exercise $($Part $2$ of $2)$

Requirement $2$:

Revise the data in your worksheet to reflect the results for the subsequent period as shown below:

a$-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$)).$

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 $($i$.$e$.,$ zero variance$)).$

b$-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$)).$

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 $($i$.$e$.,$ zero variance$).$ Round your final answer to nearest whole dollar amount.$)$

c$-1.$ What is the variable overhead 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$)).$

c$-2.$ What is the variable overhead 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$)).$