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:

$\backslash$table$[[,$A$,,$B $-2-20-2,$C$,,$D$,$E$],[1,$Chapter $09$: Applying Excel,,,,,,$],[2,,,,,,,],[3,$Data,,,,,,$],[4,$Exhibit $9-9$: Standard Cost Card,,,,,,$],[5,$Inputs,Standard Quantity,Standard Price$],[6,$Direct materials,,$3\mathrm{.}0,$pounds,$$,4\mathrm{.}00,$per pound$],[7,$Direct labor,,$0\mathrm{.}50,$hours,$$,22\mathrm{.}00,$per hour$],[8,$Variable manufacturing overhead,,$0\mathrm{.}50,$hours,$$,6\mathrm{.}00,$per hour$],[9],[10,$Actual results:,,,,,,$],[11,$Actual output,,$1,980,$units,,,$],[12,$Actual variable manufacturing overhead cost,$$,5,858\mathrm{.}00,,,,],[13,,$Actual Quantity,Actual price$],[14,$Actual direct materials cost,,$6,065,$pounds,$$,,$per pound$],[15,$Actual direct labor cost,,$1,010,$hours,$$,21\mathrm{.}90,$per hour$]]$

$!$

Required information

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

The amount of the materials quantity 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$)).$

$\backslash$table$[[$The amount of the materials price 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$)).$

The amount of the labor efficiency variance

b$-2.$ What is the labor rate variance? $($Indicate the effect of each variance by selecting $"I^{?}$ 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 variance

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

The amount of the variable overhead efficiency 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$)).$