Question

In: Accounting

Koontz Company manufactures a number of products. The standards relating to one of these products are...

Koontz 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 $1.20 per foot $

2.16

Actual: 1.75 feet at $1.60 per foot $ 2.80
Direct labor:
Standard: 0.90 hours at $16.00 per hour

14.40

Actual: 0.95 hours at $15.40 per hour 14.63
Variable overhead:
Standard: 0.90 hours at $5.60 per hour 5.04
Actual: 0.95 hours at $5.00 per hour 4.75
Total cost per unit $

21.60

$ 22.18
Excess of actual cost over standard cost per unit $ 0.58

The production superintendent was pleased when he saw this report and commented: “This $0.58 excess cost is well within the 5 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 10,500 units. Variable overhead cost is assigned to products on the basis of direct labor-hours. There were no beginning or ending inventories of materials.

Required:

1. Compute the following variances for May:

a. Materials price and quantity variances.

b. Labor rate and efficiency variances.

c. Variable overhead rate and efficiency variances.

2. How much of the $0.58 excess unit cost is traceable to each of the variances computed in (1) above.

3. How much of the $0.58 excess unit cost is traceable to apparent inefficient use of labor time?

Solutions

Expert Solution

Solution

Part 1(a) Material Price Variance

Material Price Variance is the variance arises in the material cost due to difference in actual material purchase price from standard material price. Mathematically, it is calculated as below:

Material Price Variance = Actual Quantity (Standard Price – Actual Price)

Note --- Here actual quantity means actual quantity of material PURCHASED. If the question does not provide the information about material purchase, it is taken as equal to material consumed.

Direct Material Price Variance

Actual Price

$1.60

Per Foot

Standard Price

$1.20

Per Foot

Variance or Difference in Price

$0.40

Per Foot

x Actual Quantity PURCHASED (10,500*1.75)

18375

Foot

Material Price Variance

$7,350

Unfavorable

Material Quantity/Efficiency/Usage Variance

Material Efficiency (Usage) Variance measures variance in material cost due to usage/consumption of materials. It is calculated as below:

Material Quantity Variance = Standard Price (Standard Quantity for Actual Production – Actual Quantity USED)

Note --- Here actual quantity means actual quantity of material CONSUMED/USED

Direct Material Quantity Variance

Standard Quantity Allowed for actual production:

Actual Production/Activity

10500

Units

x Allowed Standard Quantity Per Unit

1.8

Foot

Total Standard Quantity Allowed for actual production (SQAP)

18900

Foot

Actual Quantity USED (AQU)

18375

Foot

Variance or Difference in Quantity

525

Foot

x Standard Price (SP)

$1.20

Per Foot

Material Quantity Variance

$630

Favorable

Part 1(b) -- Labor Rate/Price Variance

Labor Price Variance – It arises due to difference in actual rate paid from standard rate. It is calculated as below:

Labor Price Variance = Actual Time (Standard Rate per hour – Actual Rate per hour)

Here, actual time means time for which wage has been paid.

Labor Rate Variance

Actual Hourly Rate

$15.40

Per Hour

Standard Hourly Rate

$16.00

Per Hour

Variance or Difference in Rate

$0.60

Per Hour

x Actual Labor Hours worked (10500*0.95)

9975

Hours

Labor Rate Variance

$5,985

Favorable

Labor Quantity Variance

Labor Efficiency Variance – It arises due to variation in the working hours from the set standard.

Labor Quantity / Efficiency Variance

Standard Hours Allowed for actual production:

Actual Production

10500

Units

x Allowed Standard Hours Per Unit

0.9

hours

Total Standard Hours Allowed for actual production (SHAP)

9450

hours

Actual Labor Hours Worked (AH)

9975

hours

Variance or Difference in Hours

525

hours

x Standard Hourly Rate (SHR)

$16.00

per hour

Labor Efficiency Variance

$8,400

Unfavorable

Part 1© --

Variable Overhead Spending/Rate Variance

Actual Hourly Variable Overhead Rate

5.00

Per Hour

Standard Hourly Variable Overhead Rate

5.60

Per Hour

Variance or Difference in Rate

0.60

Per Hour

x Actual Direct Labor Hours Worked

9975

Hours

Variable Overhead Rate Variance

$5,985

Favorable

Variable Overhead Efficiency/Quantity Variance

Standard Hours Allowed for actual production:

Actual Production

10,500

Pools

x Allowed Standard Hours Per Unit

0.9

MHs

Total Standard Hours Allowed for actual production (SHAP)

9450

hours

Actual Hours Worked (AH)

9975

Hours

Variance or Difference in Hours

525

hours

x Standard Hourly Variable Overhead Rate

$5.60

per hour

Variable Overhead Efficiency Variance

$2,940

Unfavorable

Part 2 --- How much of the $0.58 excess unit cost is traceable to each of the variances computed in (1) above.

$$

Direct material price variance

7350

U

Direct labor rate variance

5985

F

Variable Overhead Rate Variance

5985

F

Total Variance

4620

F

Total Produced Units

10500

Units

Variance Per Unit due to Rate

($4620 / 10500)

0.44

F

Part 3 --- How much of the $0.58 excess unit cost is traceable to apparent inefficient use of labor time?

$$

Direct material usage Variance

$630

F

Direct labor efficiency Variance

$8,400

U

Variable Overhead Efficiency Variance

$2,940

U

Total Variance due to labor time

$10,710

U

Total Produced Units

10500

Units

Variance Per Unit due to Labor Time

($10,710 / 10,500)

$1.02

U

Total Variance Per Unit = Variance due to rate or price $0.44 F + Variance due to time $1.20 U = $0.58 U

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

Pls ask separate question for remaining parts


Related Solutions

Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $4.00 per foot $ 7.60 Actual: 1.85 feet at $4.40 per foot $ 8.14 Direct labor: Standard: 1.10 hours at $16.00 per hour 17.60 Actual: 1.15 hours at $15.40 per hour 17.71 Variable overhead: Standard: 1.10 hours at $9.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $4.40 per foot $ 8.36 Actual: 1.85 feet at $4.80 per foot $ 8.88 Direct labor: Standard: 0.95 hours at $18.00 per hour 17.10 Actual: 1.00 hours at $17.50 per hour 17.50 Variable overhead: Standard: 0.95 hours at $6.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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 $2.20 per foot $ 3.96 Actual: 1.75 feet at $2.40 per foot $ 4.20 Direct labor: Standard: 0.90 hours at $14.00 per hour 12.60 Actual: 0.95 hours at $13.40 per hour 12.73 Variable overhead: Standard: 0.90 hours at $5.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $4.80 per foot $ 9.12 Actual: 1.85 feet at $5.20 per foot $ 9.62 Direct labor: Standard: 1.45 hours at $20.00 per hour 29.00 Actual: 1.50 hours at $19.50 per hour 29.25 Variable overhead: Standard: 1.45 hours at $10.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $4.40 per foot $ 8.36 Actual: 1.85 feet at $4.80 per foot $ 8.88 Direct labor: Standard: 0.95 hours at $18.00 per hour 17.10 Actual: 1.00 hours at $17.50 per hour 17.50 Variable overhead: Standard: 0.95 hours at $6.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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 $1.20 per foot $ 2.16 Actual: 1.75 feet at $1.60 per foot $ 2.80 Direct labor: Standard: 0.90 hours at $16.00 per hour 14.40 Actual: 0.95 hours at $15.40 per hour 14.63 Variable overhead: Standard: 0.90 hours at $5.60 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $3.00 per foot $ 5.70 Actual: 1.85 feet at $3.40 per foot $ 6.29 Direct labor: Standard: 1.00 hours at $18.00 per hour 18.00 Actual: 1.05 hours at $17.40 per hour 18.27 Variable overhead: Standard: 1.00 hours at $8.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $3.20 per foot $ 6.08 Actual: 1.85 feet at $3.60 per foot $ 6.66 Direct labor: Standard: 1.00 hours at $19.00 per hour 19.00 Actual: 1.05 hours at $18.40 per hour 19.32 Variable overhead: Standard: 1.00 hours at $8.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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 $2.40 per foot $ 4.32 Actual: 1.75 feet at $2.60 per foot $ 4.55 Direct labor: Standard: 0.90 hours at $15.00 per hour 13.50 Actual: 0.95 hours at $14.40 per hour 13.68 Variable overhead: Standard: 0.90 hours at $7.00 per hour...
Koontz Company manufactures a number of products. The standards relating to one of these products are...
Koontz 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.90 feet at $4.60 per foot $ 8.74 Actual: 1.85 feet at $5.00 per foot $ 9.25 Direct labor: Standard: 0.95 hours at $19.00 per hour 18.05 Actual: 1.00 hours at $18.50 per hour 18.50 Variable overhead: Standard: 0.95 hours at $7.00 per hour...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT