In: Accounting
Landers Company manufactures a number of products. The standards relating to one of these products are shown below, along with actual cost data for May.
Standard Cost per Unit Actual Cost per Unit
Direct materials:
Standard: 1.80 feet at $3.00 per foot$5.40
Actual: 1.75 feet at $3.20 per foot $5.60
Direct labor:
Standard: 1.00 hours at $16.00 per hour 16.00
Actual: 1.05 hours at $15.40 per hour 16.17
Variable overhead:
Standard: 1.00 hours at $4.00 per hour 4.00
Actual: 1.05 hours at $3.60 per hour 3.78
Total cost per unit$25.40 $25.55
Excess of actual cost over standard cost per unit $0.15
The production superintendent was pleased when he saw this report and commented: "This $0.15 excess cost is well within the 2 percent limit management has set for acceptable variances. It's obvious that there's not much to worry about with this product."
Actual production for the month was 14,000 units. Variable overhead cost is assigned to products on the basis of direct labour-hours. There were no beginning or ending inventories of materials.
Required:
1.Compute the following variances for May:
a.
Materials quantity and price variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
b.
Labour efficiency and rate variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
c.
Variable overhead efficiency and rate variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
2.
How much of the $0.15 excess unit cost is traceable to each of the variances computed in (1) above. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
3.
How much of the $0.15 excess unit cost is traceable to apparent inefficient use of labour time? (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your final answers to 2 decimal places. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
Material Price Variance = (Standard Price – Actual Price)*Actual Quantity
= (3-3.2)*14000*1.75
= $4,900 U
Material Quantity Variance = (Standard Quantity – Actual Quantity)*Standard Price
= (1.80-1.75)*14,000*3
= $2,100 F
b.Labor Rate variance = (Standard Rate – Actual Rate)*Actual Hours
= (16-15.40)*1.05*14000
= $8,820 F
Efficiency = (Standard Hours – Actual Hours)*Standard Rate
= (1-1.05)*14,000*16
= $11,200 U
c.Variable overhead Rate Variance = (Standard Rate – Actual Rate)*Actual Hours
=(4-3.60)*14,000*1.05
= $5,880 F
Efficiency = (1-1.05)*14000*4
= $2800 U
2.Direct Material Price = 4900/14000 = $0.35 U
Quantity = $0.15 F
Total = 0.20 U
Labor Rate = 0.63 F
Efficiency = 0.8 U
Total = 0.17 U
Variable overhead Rate = 0.42 F
Efficiency= 0.2 U
Total = 0.22 F
3.
Excess of actual over standard = 0.15
portion due to inefficiency
Labor efficiency variance = 0.8 U
Variable overhead efficiency variance = 0.2 U
Total = 1 U
Portion due to other variances = 0.85 F