In: Accounting
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 $3.00 per foot $ 5.40 Actual: 1.75 feet at $3.20 per foot $ 5.60 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 $4.00 per hour 3.60 Actual: 0.95 hours at $3.60 per hour 3.42 Total cost per unit $ 23.40 $ 23.65 Excess of actual cost over standard cost per unit $ 0.25 The production superintendent was pleased when he saw this report and commented: “This $0.25 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 10,000 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. (Input all amounts as positive values. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e, zero variance).) b. Labor rate and efficiency variances. (Input all amounts as positive values. 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 rate and efficiency variances. (Input all amounts as positive values. 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.25 excess unit cost is traceable to each of the variances computed in (1) above. (Input all amounts as positive values. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your answers to 2 decimal places.) 3. How much of the $0.25 excess unit cost is traceable to apparent inefficient use of labor time? (Input all values as positive amounts. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Do not round intermediate calculations. Round your final answers to 2 decimal places.)
Solution 1a:
Material price variance = (SP - AP) * AQ = ($3 - $3.20) * (10000*1.75) = $3,500 U
Material quantity variance = (SQ - AQ) * SP = (10000*1.80 - 10000*1.75) * $3 = $1,500 F
Solution 1b:
Labor rate variance = (SR - AR) * AH = ($16 - 15.40) *(10000*0.95) = $5,700 F
Labor efficiency variance = (SH - AH) * SR = (10000*0.90 - 10000*0.95) * $16 = $8,000 U
Solution 1c:
Variable overhead rate variance = (SR - AR) * AH = ($4 - $3.60) * (10000*0.95) = $3,800 F
Variable overhead efficiency variance = (10000*0.90 - 10000*0.95) * $14 = $2,000 U
Solution 2:
Statement showing Excess unit cost traceable to variance - Koontz Company | ||||
Variance | ||||
Materials: | ||||
Price Variance | $3,500.00 | U | ||
Quantity Variance | $1,500.00 | F | $2,000.00 | U |
Labor: | ||||
Rate variance | $5,700.00 | F | ||
Efficiency variance | $8,000.00 | U | $2,300.00 | U |
Variable overhead: | ||||
Rate variance | $3,800.00 | F | ||
Efficiency variance | $2,000.00 | U | $1,800.00 | F |
Excess of actual cost over standard cost per unit | $2,500.00 | U |
Solution 3:
Statement showing Excess unit cost traceable to variance | ||||
Variance | ||||
Excess of actual over standard cost per unit | $2,500.00 | U | ||
Less: Portion attributable to labor efficiency: | ||||
Labor Efficiency variance | $8,000.00 | U | ||
Variable overhead Efficiency variance | $2,000.00 | U | $10,000.00 | U |
Portion due to other variances | $7,500.00 | F |