In: Accounting
"Wonderful! Not only did our salespeople do a good job in meeting the sales budget this year, but our production people did a good job in controlling costs as well,” said Kim Clark, president of Martell Company. “Our $63,400 overall manufacturing cost variance is only 2.0% of the $3,170,000 standard cost of products made during the year. That's well within the 3% parameter set by management for acceptable variances. It looks like everyone will be in line for a bonus this year."
The company produces and sells a single product. The standard cost card for the product follows:
Inputs | (1) Standard Quantity or Hours |
(2) Standard Price or Rate |
Standard Cost (1) × (2) |
||||
Direct materials | 5.00 feet | $ | 3.50 | per foot | $ | 17.50 | |
Direct labor | 2.4 hours | $ | 15 | per hour | 36.00 | ||
Variable overhead | 2.4 hours | $ | 1.50 | per hour | 3.60 | ||
Fixed overhead | 2.4 hours | $ | 7.50 | per hour | 18.00 | ||
Total standard cost per unit | $ | 75.10 | |||||
The following additional information is available for the year just completed:
Denominator activity level (direct labor-hours) | 70,000 | |
Budgeted fixed overhead costs | $ | 525,000 |
Actual variable overhead costs incurred | $ | 120,000 |
Actual fixed overhead costs incurred | $ | 521,500 |
Required:
1. Compute the materials price and quantity variances for the year.
2. Compute the labor rate and efficiency variances for the year.
3. For manufacturing overhead compute:
a. The variable overhead rate and efficiency variances for the year.
b. The fixed overhead budget and volume variances for the year.
(For all requirements, indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Actual DATA for |
30000 |
units |
|
Quantity (AQ) |
Rate (AR) |
Actual Cost |
|
Direct Material |
147000 |
$ 3.70 |
$ 543,900.00 |
Direct labor |
75000 |
$ 14.80 |
$ 1,110,000.00 |
Variable Overhead |
75000 |
$ 1.60 |
$ 120,000.00 |
Standard DATA for |
30000 |
units |
|
Quantity (SQ) |
Rate (SR) |
Standard Cost |
|
[A] |
[B] |
[A x B] |
|
Direct Material |
( 5 feet x 30000 units)=150000 feet |
$ 3.50 |
$ 525,000.00 |
Direct labor |
( 2.4 hours x 30000 units)=72000 hours |
$ 15.00 |
$ 1,080,000.00 |
Variable Overhead |
( 2.4 hours x 30000 units)=72000 hours |
$ 1.50 |
$ 108,000.00 |
Hrs |
Rate |
Amount |
|
Budgeted Fixed Overhead |
70000 |
$ 7.50 |
$ 525,000.00 |
Standard Fixed Overhead or Fixed Overhead absorbed |
72000 |
$ 7.50 |
$ 540,000.00 |
Actual Fixed Overhead incurred |
75000 |
6.953333333 |
$ 521,500.00 |
Material Price Variance |
||||||
( |
Standard Rate |
- |
Actual Rate |
) |
x |
Actual Quantity |
( |
$ 3.50 |
- |
$ 3.70 |
) |
x |
147000 |
-29400 |
||||||
Variance |
$ 29,400.00 |
Unfavourable-U |
||||
Material Quantity Variance |
||||||
( |
Standard Quantity |
- |
Actual Quantity |
) |
x |
Standard Rate |
( |
150000 |
- |
147000 |
) |
x |
$ 3.50 |
10500 |
||||||
Variance |
$ 10,500.00 |
Favourable-F |
Labor Rate Variance |
||||||
( |
Standard Rate |
- |
Actual Rate |
) |
x |
Actual Labor Hours |
( |
$ 15.00 |
- |
$ 14.80 |
) |
x |
75000 |
15000 |
||||||
Variance |
$ 15,000.00 |
Favourable-F |
||||
Labour Efficiency Variance |
||||||
( |
Standard Hours |
- |
Actual Hours |
) |
x |
Standard Rate |
( |
72000 |
- |
75000 |
) |
x |
$ 15.00 |
-45000 |
||||||
Variance |
$ 45,000.00 |
Unfavourable-U |
Variable Overhead Rate Variance |
||||||
( |
Standard Rate |
- |
Actual Rate |
) |
x |
Actual Labor Hours |
( |
$ 1.50 |
- |
$ 1.60 |
) |
x |
75000 |
-7500 |
||||||
Variance |
$ 7,500.00 |
Unfavourable-U |
||||
Variable Overhead Efficiency Variance |
||||||
( |
Standard Hours |
- |
Actual Hours |
) |
x |
Standard Rate |
( |
72000 |
- |
75000 |
) |
x |
$ 1.50 |
-4500 |
||||||
Variance |
$ 4,500.00 |
Unfavourable-U |
Fixed Overhead Production Budget Variance |
||||||
( |
Budgeted Fixed Overhead |
- |
Actual Fixed Overhead incurred |
) |
||
( |
$ 525,000.00 |
- |
$ 521,500.00 |
) |
||
3500 |
||||||
Variance |
$ 3,500.00 |
Favourable-F |
Fixed Overhead Production Volume Variance |
||||||
( |
Standard Fixed Overhead or Fixed Overhead absorbed |
- |
Budgeted Fixed Overhead |
) |
||
( |
$ 540,000.00 |
- |
$ 525,000.00 |
) |
||
15000 |
||||||
Variance |
$ 15,000.00 |
Favourable-F |