Required:

1. Check your worksheet by changing the direct materials standard quantity in cell B6 to 2.9 pounds, the direct labor standard quantity in cell B7 to 0.6 hours, and the variable manufacturing overhead in cell B8 to 0.6 hours. The materials spending variance should now be $1,500 U, the labor spending variance should now be $3,720 F, and the variable overhead spending variance should now be $60 F. If you do not get these answers, find the errors in your worksheet and correct them.

17 Enter a formula into each of the cells marked with a ?elow 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 23 Actual Quantity of Input, at Actual Price ?poundsx?poundsx?poundsx?perpound=?perpound=?perpound= 24 Direct materials variances: Materials quantity variance ? Materials price variance Materials spending variance ? Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor 30 Standard Hours Allowed for the Actual Output, at Standard Rate 31 Actual Hours of Input, at Standard Rate 32 Actual Hours of Input, at Actual Rate 33 Direct labor variances ?hoursx?hoursx?hoursx?perhour=?perhour=?perhour=??? 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 Variable overhead variances: Variable overhead efficiency variance ?hoursx?hoursx?hoursx?perhour=perhour=?perhour=??? Variable overhead rate variance Variable overhead spending variance