In: Accounting
"Wonderful! Not only did our salespeople do a good job in meeting the sales budget this year, but our production people did a good job in controlling costs as well,” said Kim Clark, president of Martell Company. “Our $41,000 overall manufacturing cost variance is only 2.5% of the $1,640,000 standard cost of products made during the year. That's well within the 3% parameter set by management for acceptable variances. It looks like everyone will be in line for a bonus this year." The company produces and sells a single product. The standard cost card for the product follows: Inputs (1) Standard Quantity or Hours (2) Standard Price or Rate Standard Cost (1) × (2) Direct materials 4.00 feet $ 4.50 per foot $ 18.00 Direct labor 1.6 hours $ 14 per hour 22.40 Variable overhead 1.6 hours $ 2.10 per hour 3.36 Fixed overhead 1.6 hours $ 7.00 per hour 11.20 Total standard cost per unit $ 54.96 The following additional information is available for the year just completed: The company manufactured 20,000 units of product during the year. A total of 77,000 feet of material was purchased during the year at a cost of $4.70 per foot. All of this material was used to manufacture the 20,000 units produced. There were no beginning or ending inventories for the year. The company worked 34,000 direct labor-hours during the year at a direct labor cost of $13.80 per hour. Overhead is applied to products on the basis of standard direct labor-hours. Data relating to manufacturing overhead costs follow: Denominator activity level (direct labor-hours) 30,000 Budgeted fixed overhead costs $ 210,000 Actual variable overhead costs incurred $ 74,800 Actual fixed overhead costs incurred $ 207,300 Required: 1. Compute the materials price and quantity variances for the year. 2. Compute the labor rate and efficiency variances for the year. 3. For manufacturing overhead compute: a. The variable overhead rate and efficiency variances for the year. b. The fixed overhead budget and volume variances for the year. (For all requirements, indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
1.Direct material Price Variance = (Standard Price – Actual Price)*Actual Quantity
=(4.5 – 4.70)*77,000
= 15,400 U
Direct material Quantity variance = (Standard Quantity – Actual Quantity)*Standard Price
= (4*20,000 – 77,000)*4.5
=13, 500 F
2. Labor Rate variance = (Standard Rate – Actual Rate)*Actual Hours
= (14 – 13.80)*34,000
= 6,800 F
Labor Efficiency Variance = (Standard Hours – Actual Hours)*Standard Rate
= (1.6*20,000 – 34,000)*14
= 28,000 U
3. Variable overhead rate Variance = (Standard Rate – Actual Rate)*Actual Hours
= (2.10-2.2)*34,000
=3,400 U
Note: Actual rate = Actual cost/actual hours
= 74,800/34,000 = 2.2
Variable overhead efficiency variance = = (Standard Hours – Actual Hours)*Standard Rate
= (32,000-34,000)*2.1
= 4,200 U
b. Fixed Overhead Budget Variance = Budgeted Overheads – Standard Overheads
= 210,000-11.20*20,000 = 14,000 U
Fixed Overhead Volume Variance = Budgeted Overheads – Actual Overheads
= 210,000-207,300 = 2,700 F