In: Accounting
The following data is given for the XYZ Company:
Budgeted production 26,000 units
Actual production 27,500 units
Materials:
Standard price per ounce $6.50
Standard ounces per completed unit 8
Actual ounces purchased and used in production 228,000
Actual price paid for materials $1,504,800
Labor:
Standard hourly labor rate $22 per hour
Standard hours allowed per completed unit 6.6
Actual labor hours worked 183,000
Actual total labor costs $4,016,850
Required:
a. Calculate the materials variances and indicate whether they are favorable or unfavorable
b. Calculate the labor variances and indicate whether they are favorable or unfavorable
| Budgeted | Standard | Actual | ||||||||||
| Quantity/Hrs | Rate | Amount | Quantity/Hrs | Rate | Amount | Quantity/Hrs | Rate | Amount | ||||
| Material | 8 | 6.5 | 52 | 220000 | 6.5 | 1430000 | 228000 | 6.6 | 1504800 | |||
| Labour | 6.6 | 22 | 145.2 | 181500 | 22 | 3993000 | 183000 | 21.95 | 4016850 | |||
| a) | Material cos variance = Standard material cost - actual material cost | |||||||||||
| =1430000 - 1504800 | ||||||||||||
| 74,800 | Unfavorable | |||||||||||
| Material Price Variance = (Standard Price - Actual Price ) Actual Quantity Purchased | ||||||||||||
| = (6.5 - 6.6 ) *228000 | ||||||||||||
| 22,800 | Unfavorable | |||||||||||
| Material Quantity Variance = (Standard quantity - Actual Quantity ) Standard Price | ||||||||||||
| = (220000 -228000 )*6.5 | ||||||||||||
| 52,000 | Unfavorable | |||||||||||
| b) | Labor cost variance = standard labor cost - actual labor cost | |||||||||||
| =3993000 - 4016850 | ||||||||||||
| 23,850 | Unfavorable | |||||||||||
| Labour Rate Variance = (Standard Rate - Actual Rate) Actual Hrs Worked | ||||||||||||
| = (22 - 21.95)* 183000 | ||||||||||||
| 9,150 | Favorable | |||||||||||
| Labour Efficiency Variance = (Standard Hrs. - Actual Hrs) Standard Rate | ||||||||||||
| = (181500 - 183000 )*22 | ||||||||||||
| 33,000 | Unfavorable |