ACCT 222 Problems Excel Template 8, Fall 2014

Name: Section: When totals and variances are correct the cell will change to green. Exercise 8-15 Fixed overhead Variable overhead ($1.50 per unit) Total Month 1 Month 2 Budget Actual Variance Budget Actual Variance $ - Calculation of factory overhead allowed: Standard 8,000 Units Month 1 7,400 Units Month 2 8,200 Units Name: Section: When differences and variances are correct the cell will change to green. Problem 8-3 Difference Variance 1. Materials quantity variance: Surge gal. gal. /gal. Empty drums drums drums /drum 3. Labor efficiency variance hrs. hrs. /hr. Difference Variance 2. Materials purchase price variance: Surge /gal. /gal. gal. Empty drums /drum /drum drums 4. Labor rate variance /hr. /hr. hours Standard Quantity or Hours Actual Quantity or Hours Standard Cost Standard Cost Actual Cost Actual Quantity or Hours Variance Variance Name: Section: When differences and variances are correct the cell will change to green. Problem 8-4 Difference Variance 1. Materials quantity variance lbs. lbs. /lb. 3. Labor efficiency variance hrs. hrs. /hr. Difference Variance 2. Materials purchase price variance /lb. /lb. lbs. 4. Labor rate variance /hr. /hr. hrs. Standard Quantity or Hours Actual Quantity or Hours Standard Cost Standard Cost Actual Cost Actual Quantity or Hours Name: Section: When differences and variances are correct the cell will change to green. Problem 8-5 Difference Variance Materials quantity variance: 1. Class ft. ft. /ft. 2. Chic ft. ft. /ft. 5. Labor efficiency variance hrs. hrs. /hr. Difference Variance Materials purchase price variance: 3. Class /ft. /ft. ft. 4. Chic /ft. /ft. ft. 6. Labor rate variance /hr. /hr. hrs. Standard Quantity or Hours Actual Quantity or Hours Standard Cost Standard Cost Actual Cost Actual Quantity or Hours Name: Section: When differences and variances are correct the cell will change to green. Problem 8-6 Difference Variance Materials quantity variance: Aluminum lbs. lbs. /lb. Plastic lbs. lbs. /lb. Labor efficiency variance hrs. hrs. /hr. Difference Variance Materials purchase price variance: Aluminum /lb. /lb. lbs. Plastic - regular gade /lb. /lb. lbs. Plastic - low grade /lb. /lb. lbs. Labor rate variance /hr. /hr. hrs. Standard Quantity or Hours Actual Quantity or Hours Standard Cost Standard Cost Actual Cost Actual Quantity or Hours