Ex 9-14 Name:
Enter the appropriate amounts in the shaded cells in columns B, D, F, H, J, and L.
1) Material variances:
AQ xAP AQ xSP SQ xSP
x x x
MPV MUV
2) Labor variances:
AH xAR AH xSR SH xSR
x x x
LRV LEV
Enter the appropriate account titles in the shaded cells in columns B and D.
Enter the appropriate amounts in the shaded cells in columns F and H.
3) Journal entries:
Materials
Labor
Ex 9-14 Name:
Work in Process
Direct Materials Usage Variance
Direct Labor Rate Variance
Direct Labor Efficiency Variance
Wages Payable
Work in Process
Materials Inventory
Enter the appropriate amounts in the shaded cells in columns B, D, F, H, J, and L.
1) Material variances:
AQ xAP AQ xSP SQ xSP
901,200 x 0.210$ 901,200 x 0.200$ 900,900 x 0.200$
189,252$ 180,240$ 180,180$
9,012$ U 60$ U
MPV MUV
3) Journal entries:
Materials
180,240
9,012
189,252
Direct Materials Price Variance
SOLUTION
Materials Inventory
Accounts Payable
Ex 9-15 Name:
Enter the appropriate amounts in the shaded cells in columns B, F, H, J, and L.
1) Fixed overhead variances:
Actual fixed overhead Budgeted fixed overhead SH xSR
x
Spending Volume
2) Variable overhead variances:
Actual variable overhead AH xSR SH xSR
x x
Spending Efficiency
Ex 9-15 Name: SOLUTION
Enter the appropriate amounts in the shaded cells in columns B, F, H, J, and L.
1) Fixed overhead variances:
Actual fixed overhead Budgeted fixed overhead SH xSR
477,600 x 1.160$
556,250$ 556,800$ 554,016$
Ex 9-19 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, G, I, and K.
Use the pull down menus in cells F21 and N28 to indicate the variance condition.
1)
2)
3) Direct labor yield variance = (Std. Yield
–Actual yield) x Std. cost of yield
= (
–) x
=
4) Direct labor mix variance:
Direct Labor Type AH SM AH-SM SP (AH – SM)SP
Fabricating
Assembly
Direct labor mix variance
Yield ratio =
=
Standard cost =
=
per unit of yield
Ex 9-19 Name:
Enter the appropriate amounts in the shaded cells in columns C, E, G, I, and K.
Use the pull down menus in cells F21 and N28 to indicate the variance condition.
1)
25
5
3) Direct labor yield variance = (Std. Yield
–Actual yield) x Std. cost of yield
= ( 325,000
–320,000 ) x $3.04
=$15,200 U
SOLUTION
Yield ratio =
=
5
=
Prob 9-29 Name:
Enter the appropriate amounts in the shaded cells in columns B, D, E, F, G, H, J, and L.
1)
Standard fixed overhead rate =
Projected volume x Hours per unit
=
x
= per DLH
Standard variable overhead rate =
Projected volume x Hours per unit
=
x
= per DLH
2)
Applied fixed overhead = x DLR/unit x Fixed OH rate
x x
Applied variable overhead = x DLR/unit x Fixed OH rate
x x
–
–
–
–
3) Fixed Overhead Variances:
Actual Fixed Overhead DH xSR SH xSR
x x
Spending Volume
4) Variable Overhead Variances:
Actual Variable Overhead AH xSR SH xSR
x x
=
Total variable overhead variance =
Actual variable OH
Applied variable OH
=
=
=
=
Total fixed overhead variance =
Actual fixed OH
Applied fixed OH
=
Units produced
=
Applied Overhead
Units produced
=
Budgeted variable overhead
Overhead rates
Budgeted fixed overhead
Spending Efficiency
5)
6) Journal Entries Debit Credit
Three-Variance Analysis
Volume variance:
Variable OH efficiency variance:
Spending variance:
Prob 9-29 Name:
97,000
=
=
$430,680
=
Underapplied
=
Enter the appropriate amounts in the shaded cells in columns B, D, E, F, G, H, J, and L.
1)
Standard fixed overhead rate =
Projected volume x Hours per unit
Standard variable overhead rate =
Projected volume x Hours per unit
2)
Applied fixed overhead = x DLR/unit x Fixed OH rate
x 2 x $3.85
Applied variable overhead = x DLR/unit x Fixed OH rate
3) Fixed Overhead Variances:
Actual Fixed Overhead DH xSR SH xSR
200,000 x 3.85$ 194,000 x 3.85$
780,000$ 770,000$ 746,900$
10,000$ U 23,100$ U
Spending Volume
Budgeted variable overhead
SOLUTION
Budgeted fixed overhead
Units produced
97,000
Overhead rates
Applied Overhead
$746,900
=
=
Units produced
Miscellaneous Accounts
Fixed Overhead Control
Variable Overhead Control
Fixed Overhead Control
Fixed Overhead Spending Variance
Variable Overhead Efficiency Variance
Variable Overhead Efficiency Variance
Cost of Goods Sold
Fixed Overhead Volume Variance
Variable Overhead Spending Variance
Fixed Overhead Spending Variance
Fixed Overhead Volume Variance
Variable Overhead Spending Variance
480$ U 4,440$ U
Spending Efficiency
5)
$23,100 U
6) Journal Entries Debit Credit
1,177,580
430,680
746,900
Three-Variance Analysis
Volume variance:
Work in Process
Variable Overhead Control
Fixed Overhead Control
Spending variance:
Variable OH efficiency variance: