Subjects cost accounting

Variance Calculations

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Variance Calculations


1. **Problem Statement:** Calculate variances for materials, labour, overheads, and idle time for Bwana Furniture Ltd. based on given standard and actual data. 2. **Material X (Timber) Variances:** - Standard price per kg = 150 - Standard quantity for 9,500 desks = 3.0 kg/desk \times 9,500 = 28,500 kg - Actual quantity = 29,700 kg - Actual cost = 4,500,000 - Actual price per kg = \frac{4,500,000}{29,700} = 151.52 **Material Price Variance (MPV):** $$MPV = (Standard\ Price - Actual\ Price) \times Actual\ Quantity = (150 - 151.52) \times 29,700 = -44,944$$ (Adverse) **Material Usage Variance (MUV):** $$MUV = (Standard\ Quantity - Actual\ Quantity) \times Standard\ Price = (28,500 - 29,700) \times 150 = -180,000$$ (Adverse) 3. **Material Y (Varnish) Variances:** - Standard price per litre = 300 - Standard quantity for 9,500 desks = 0.5 \times 9,500 = 4,750 litres - Actual quantity = 5,200 litres - Actual cost = 1,584,000 - Actual price per litre = \frac{1,584,000}{5,200} = 304.62 **Material Price Variance:** $$MPV = (300 - 304.62) \times 5,200 = -24,024$$ (Adverse) **Material Usage Variance:** $$MUV = (4,750 - 5,200) \times 300 = -135,000$$ (Adverse) 4. **Labour Variances:** - Standard labour hours = 4.0 \times 9,500 = 38,000 hours - Actual labour hours = 40,200 - Actual labour cost = 3,360,000 - Actual labour rate = \frac{3,360,000}{40,200} = 83.58 **Labour Rate Variance (LRV):** $$LRV = (Standard\ Rate - Actual\ Rate) \times Actual\ Hours = (80 - 83.58) \times 40,200 = -143,316$$ (Adverse) **Labour Efficiency Variance (LEV):** $$LEV = (Standard\ Hours - Actual\ Hours) \times Standard\ Rate = (38,000 - 40,200) \times 80 = -176,000$$ (Adverse) 5. **Idle Time Variance:** - Idle time hours = 1,200 - Idle time variance = Idle hours \times Standard rate $$Idle\ Time\ Variance = 1,200 \times 80 = 96,000$$ (Adverse) 6. **Variable Overhead Variances:** - Standard variable overhead rate = 60 per direct labour hour - Standard hours = 40,200 (actual labour hours) - Actual variable overhead = 2,640,000 - Standard variable overhead = 40,200 \times 60 = 2,412,000 **Variable Overhead Spending Variance:** $$VOSV = Actual\ VO - (Standard\ Rate \times Actual\ Hours) = 2,640,000 - 2,412,000 = 228,000$$ (Adverse) **Variable Overhead Efficiency Variance:** $$VOEV = (Standard\ Hours - Actual\ Hours) \times Standard\ Rate = (38,000 - 40,200) \times 60 = -132,000$$ (Adverse) 7. **Fixed Overhead Variances:** - Budgeted fixed overhead = 480,000 - Actual fixed overhead = 430,000 - Budgeted production = 10,000 desks - Actual production = 9,500 desks - Fixed overhead rate per desk = \frac{480,000}{10,000} = 48 **Fixed Overhead Budget (Spending) Variance:** $$FOBV = Budgeted\ FO - Actual\ FO = 480,000 - 430,000 = 50,000$$ (Favorable) **Fixed Overhead Volume Variance:** $$FOVV = (Budgeted\ Production - Actual\ Production) \times FO\ Rate = (10,000 - 9,500) \times 48 = 24,000$$ (Adverse) 8. **Causes and Corrective Actions:** - **Materials:** - Causes: Poor quality control leading to wastage; price increases from suppliers. - Corrective Actions: Improve supplier negotiation and quality checks. - **Labour:** - Cause: Inefficient work methods causing overtime and idle time. - Corrective Action: Train workers and optimize scheduling to reduce idle time. **Final answers:** - Timber MPV = -44,944 (Adverse), MUV = -180,000 (Adverse) - Varnish MPV = -24,024 (Adverse), MUV = -135,000 (Adverse) - Labour Rate Variance = -143,316 (Adverse), Labour Efficiency Variance = -176,000 (Adverse) - Idle Time Variance = 96,000 (Adverse) - Variable Overhead Spending Variance = 228,000 (Adverse), Efficiency Variance = -132,000 (Adverse) - Fixed Overhead Budget Variance = 50,000 (Favorable), Volume Variance = 24,000 (Adverse)