In: Accounting
Q 21
A manufacturing company based in Tarkwa uses a standard absorption costing system in accounting for its production costs.
The standard cost of a unit of product is as follows:
Standard Quantity Standard price/rate Standard Cost
Direct materials 5 kilos 6.00 30.00
Direct labour 20 kilos 4.00 80.00
Variable production overhead 20 kilos 0.20 4.00
Fixed production overhead 20 kilos 5.00 100.00
The following data related to period 1:
Budgeted output 25,000 units
Actual output – produced 20,000 units
Units sold 15,000 units
Materials put into production 120,000 kilos
Materials purchased 200,000kilos
Direct labour hours paid 500,000hours
Due to a power failure 10,000 hours were post
Cost of materials purchased and used GHS825,000
Rate per direct labour hour GHS5
Variable production overhead GHS70,000
Fixed production overhead GHS2,100,000
Required:
| Cost card | ||||||||
| Particulars | Standard cost for actual production | Particulars | Actual cost | |||||
| Quantity & hour | Rate($/lb & $/hr) | Amount | Quantity & hour | Rate($/lb & $/hr) | Amount | |||
| Direct Material | 100000.00 | 6.00 | $ 6,00,000 | Material purchased | 2,00,000.00 | 6.88 | $ 13,75,000.00 | |
| (20,000 unit * 5 Kg) | Material used | 1,20,000.00 | 6.88 | $ 8,25,000.00 | ||||
| Closing material | 80,000.00 | $ 5,50,000.00 | ||||||
| Direct labour | 400000.00 | 4.00 | $ 16,00,000 | Direct labour | 4,90,000.00 | 5.00 | $ 24,50,000.00 | |
| (20,000 unit * 20 hr) | ||||||||
| Variable overhead | 400000.00 | 0.20 | $ 80,000 | Variable overhead | 4,90,000.00 | 0.14 | $ 70,000.00 | |
| Fixed overhead | $ 25,00,000 | Fixed overhead | $ 21,00,000.00 | |||||
| Total Standard manufacturing cost | $ 47,80,000 | |||||||
| Budgeted unit | 25,000 | |||||||
| Actual unit | 20,000 | |||||||
| Computation of variances: | ||||||||
| 1 | Material Price variance = (Standard rate - Actual rate) * Actual quantity purchase | |||||||
| Material Price variance = ($6 - $6.875) X 200000 kilos = $-175000 (Unfavourable) | ||||||||
| 2 | Material efficiency variance = (Standard Quantity - Actual Quantity used) * Standard rate | |||||||
| Material efficiency variance = (100000 kilos - 120000 kilos ) X $6 = $-120000 (Unfavourable) | ||||||||
| 3 | Labor Rate variance = (Standard rate - Actual rate) * Actual hours | |||||||
| Labor Rate variance = ($4/hr - $5/hr) X 490000 hr = $-490000 (Unfavourable) | ||||||||
| 4 | Labor efficiency variance = (Standard Hours - Actual Hours) * Standard rate | |||||||
| Labor efficiency variance = (400000 hr - 490000 hr) X $4/hr = $-360000 (Unfavourable) | ||||||||
| 5 | Variable Overhead rate variance = (Standard rate - Actual rate) * Actual hour used | |||||||
| Variable Overhead rate variance = ($0.2/hr - $0.142857142857143/hr) X 490000 hr = $28000 (Favourable) | ||||||||
| 6 | Variable overhead efficiency variance = (Standard hour - Actual hour) * Standard rate | |||||||
| Variable overhead efficiency variance = (400000 hr - 490000 hr) X $0.2/hr = $-18000 (Unfavourable) | ||||||||
| 7 | Fixed Overhead Budget variance = (Actual Fixed overhead - Budgeted Fixed overhead | |||||||
| Fixed Overhead Budget variance = ($2100000 - $2500000) = $400000 (Favourable) | ||||||||
| 8 | Fixed overhead Volume variance = (Actual output - Budgeted output) * Budgeted Overhead rate | |||||||
| Fixed overhead Volume variance = (20000 unit - 25000 unit ) X ($2500000 / 25000 unit ) = $-500000 (Unfavourable) | ||||||||
| < |