In: Accounting
Question 2 Variance analysis for Divine Denim
Helen has been using a standard cost system developed by Good Numbers and calculates the standard cost of a completed pair of RTW jeans as $72.00, as follows:
Quantity | Price $ | Unit | Cost per pair of jeans $ | |
Denim fabric meters | 2 | 10 | /metre | 20.00 |
Direct labour hours | 2 | 20 | /hour | 40.00 |
Variable factory overhead | 0.4 | 10 | /hour | 4.00 |
Fixed factory overhead | 0.4 | 20 | /hour | 8.00 |
Total standard cost | 72.00 |
The fixed overhead rate is based on an estimated 600 units per month. Direct labour is nearly a fixed cost in this business. Selling and administrative costs are $4500 per month plus $2 per pair of jeans sold. The following information is for production during April:
Units | ||
Number of pairs of jeans made | 565 | Jeans |
Purchase of 1200 metres of denim | 13,200 | metres |
Number of metres used | 1,150 | metres |
Direct labour costs (1200 hours) | 24,500 | $ |
Variable factory overhead costs | 2,750 | $ |
Fixed factory overhead costs | 4,020 | $ |
Selling and administrative costs | 3,770 | $ |
Divine Denim’s policy is to record materials price variances at the time materials are purchased. Use a spreadsheet to perform calculations.
Required:
As an accountant working for Good Numbers use a spreadsheet to:
Standard costs per units will be multiplied by 600 which is the estimated quantity
Actual | |||
Denim fabric Qty | No. of meters / actual units | =1150 / 565 | 2.04 |
Denim fabric cost per meter | Cost of fabric / qty of fabric bought | =13200/1200 | 11 |
Denim fabric cost per unit | Denim fabric Qty*Denim fabric cost per meter | =2.04*11 | 22.44 |
Denim fabric cost for 565 units | Denim fabric cost per unit * 565 | =22.44*565 | 12,678.60 |
Divine Denim
Flexible cost budget
Budget | Actual | Variance | Favourable/ Unfavourable | |
Production (units) | 600 | 565 | ||
Denim fabric cost | $ 12,000.00 | $ 12,678.60 | $ (678.60) | unfavourable |
Direct labour cost | $ 24,000.00 | $ 24,500.00 | $ (500.00) | unfavourable |
Variable factory overhead | $ 2,400.00 | $ 2,750.00 | $ (350.00) | unfavourable |
Fixed factory overhead | $ 4,800.00 | $ 4,020.00 | $ 780.00 | Favourable |
Total standard cost | $ 43,200.00 | $ 44,485.00 | $ (1,285.00) | unfavourable |
Selling and distribution | $ 5,700.00 | $ 3,770.00 | $ 1,930.00 | Favourable |
Direct cost variances | Standard Denim fabric cost + Standard Direct labour cost - Actual Denim fabric cost + Actual Direct labour cost | |||
12000+24000-12678.6-24500 | ||||
$ (1,178.60) | Unfavourable | |||
factory overhead variances. | Standard Variable factory OH + Standard fixed factory OH - Actual Variable factory OH + Actual fixed factory OH | |||
=2400+4800-2750-4020 | ||||
$ 430.00 | Favourable | |||
Selling and distribution variance | Standard S&D cost - Actual S&D cost | |||
=5700 - 3770 | ||||
$ 1,930.00 | Favourable |