The following data is provided for Alvarado Company:

DATA

Standard direct labor hours per unit $3$

Standard hourly rate $$21\mathrm{.}00$

Units produced $15,100$

Actual labor hours used $61,400$

Actual hourly rate $$19\mathrm{.}60$

REQUIRED:

What is the direct labor $($a$)$ rate variance, $($b$)$ time variance, and $($c$)$ cost variance?

"Using formulas and cell references from the problem data, perform the required analysis.

Formulas entered in the green cells show in the orange cells. Select the corresponding type of variance in the dropdowns in cells D$15$:D$17.$ Transfer amounts to CNOWv$2$ for grading. $"$

Amount Formulas

Direct labor rate variance

Direct labor time variance

Direct labor cost variance