Chapter $10$: Applying Excel

Data

Exhibit $10-1$: Standard Cost Card

Direct materials

Inputs

Direct labor

Variable manufacturing overhead

Actual results:

Actual output

Actual variable manufacturing overhead cost

Actual direct materials cost

Actual direct labor cost

Enter a formula into each of the cells marked with a $?$ below

Main Example: Chapter $10$

Exhibit $10-4$: Standard Cost Variance Analysis$-$Direct Materials

Standard Quantity Allowed for the Actual Output, at Standard Price

Actual Quantity of Input, at Standard Price

Actual Quantity of Input, at Actual Price

Direct materials variances:

Materials quantity variance

Materials price variance

Materials spending variance

Exhibit $10-6$: Standard Cost Variance Analysis$-$Direct Labor

Standard Hours Allowed for the Actual Output, at Standard Rate

Actual Hours of Input, at Standard Rate

Actual Hours of Input, at Actual Rate

Direct labor variances:

Labor efficiency variance

Labor rate variance

Labor spending variance

Exhibit $10-8$: Standard Cost Variance Analysis $-$ Variable Manufacturing Overhead

Standard Hours Allowed for the Actual Output, at Standard Rate

Actual Hours of Input, at Standard Rate

Actual Hours of Input, at Actual Rate

Variable overhead variances:

Variable overhead efficiency variance

Variable overhead rate variance

Variable overhead spending variance

$?F$