In: Accounting
Given the information below, What is the total variance in the actual and static budget?
DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division transfers the completed frames to the assembly division at the budgeted standard cost of a frame. The budgeted units of production for the framing division is 1,000, all of which will be transferred to the assembly division at the standard full absorption cost.
The budgeted costs for the framing division are as follows:
Direct Materials per unit: 10 layers of carbon-fiber at $20/layer | $200.00 |
Direct Labor per unit: 8 hours at $12/hour | $96.00 |
1. Standard variable overhead is applied to products on the basis of direct labor hours at a rate of $4/unit produced.
Budgeted Fixed Overhead is $30,000 and the standard fixed cost per unit is based on the budgeted units of production.
Actual data for the period relating to the costs are as follows:
The actual number of units produced was | 800 |
Actual Fixed Overhead costs were | $32,000 |
Actual Variable Overhead costs | $4,000 |
2. The framing division worked 7,500 direct labor hours during the year at a total cost of $93,750.
3. A total of 9,000 carbon-fiber layers were purchased and used in production during the year at a total cost of $171,000
4. Total Budgeted cost for the framing department was $330,000. The total actual cost was $300,750
(Note that all the questions on variance are with respect to the framing department.)
Solution:
Standard qty of material per unit = 10 layer
Standard rate of material = $20 per layer
Budgeted prodcution = 1000 units
Actual production = 800 units
Standard Qty of direct material = 800*10 = 8000 layers
Actual Qty of direct material = 9000 layers
Actual cost of direct material = $171,000
Actual rate of direct material = $171,000 / 9000 =$19 per layer
Material Price Variance = (SP - AP)* AQ = (20-19)*9000 = $9000F
Material Qty variance = (SQ - AQ) * SR = (8000 - 9000)*20 = $20,000U
Material Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit
= (1000 - 800) *200 = $40000F
Total material variance = Budgeted cost of direct material - Actual cost of direct material
= 200*1000 - $171,000 = $29000F
Standard hours of labor per unit = 8 hours
Standard rate of labor = $12 per hour
Budgeted prodcution = 1000 units
Actual production = 800 units
Standard Hrs of direct labor = 800*8 = 6400 hours
Actual hrs of direct labor = 7500 hours
Actual cost of direct labor = $93,750
Actual rate of direct labor = $93,750 / 7500 =$12.50 per hour
Labor Rate Variance = (SR - AR)* AH = (12-12.50)*7500 = $3,750U
Labor efficiency variance = (SH - AH) * SR = (6400 - 7500)*12 = $13,200U
Labor Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit
= (1000 - 800) *96 = $19200F
Total labor variance = Budgeted cost of direct labor - Actual cost of direct labor
= 96*1000 - $93,750 = $2,250F
Standard hours of labor per unit = 8 hours
Standard variable overhead per unit = $4
Standard variable overhead rate per hour = 4/8 = $0.50 per hour
Standard Hrs of direct labor = 800*8 = 6400 hours
Actual hrs of direct labor = 7500 hours
Actual variable overhead cost = $4,000
Actual rate of variable overhead = $4,000 / 7500 =$0.533 per hour
Variable Overhead Rate Variance = (SR - AR)* AH = (0.50-0.53333333)*7500 = $250U
Variable overhead efficiency variance = (SH - AH) * SR = (6400 - 7500)*0.50 = $550U
Variable Overhead Volume Variance = (budgeted production - Standard production) * Budgeted rate per unit
= (1000 - 800) *4 = $800 F
Total Variable overhead variance = Budgeted cost of variable overhead - Actual cost of variable overhad
= $4,000 - $4,000 = 0
Budget fixed overhead = $30,000
Actual fixed overhead = $32,000
Aborsption rate = Buegetec fixed overhead / Budgeted units = $30,000/1000 = $30 per unit
Applied overhead = $30 * 800 = $24,000 per unit
Fixed overhead price variance = Budgeted Overhead - Fixed Overhead = $30,000 - $32,000 = $2000 U
Fixed overhead volume variance = Budgeted fixed manufacturing Cost - Applied fixed manufacturing cost
=$30,000 - $24,000 = $6,000U
Total Fixed overhead budget variance = Actual fixed overhead - Applied fixed overhead = $32,000 - $24,000 = $8000U