Variable Cost Variance Analysis

Practice As You Learn

Follow these steps when asked to compute variable cost variances.

1) Write the column headings/formula:

AQ x AP       AQ x SP       SQ x SP

Do this for each section: material, labor, and variable overhead.
For material: do two AQ x SP in the middle,
one for actual quantity purchased and one for actual quantity used.

2) Go to the problem and find the actual information and plug it in to the AQ and AP

3) Go to the problem and find the SP information and plug it in to the SP.
This information may be described as “standard”, “budgeted”, “estimated”, or “per the cost sheet”

4) Find the actual units produced/manufactured/made and the amount that is supposed to be used to produce one product (this will be the standard) and multiply these together to get the SQ

5) Do the math and calculate the variances:
Favorable: the amount on the left is smaller because you have actually spent less (actual) than you thought you would (standard).

Variable Costs Variances – Learn as You Practice – problem 1.

KKR Company is a manufacturing company with the following data.

Standard

Materials 3 pounds at $3 per pound
Labor 5 hours at $10 per hour
Variable Overhead $7 per labor hour
Budgeted production for the year 5,000 units

Actual

Materials Purchased 15,000 pounds for $46,210
Materials Used 15,300 pounds
Direct Labor 24,860 hours at $239,500
Variable Overhead $168,600
Fixed overhead $142,600
Units produced     5,200

Calculate all variances and answer the following.

1a. The material price variance is

a. 900 favorable
b. 1,210 unfavorable
c. 0
d. 1,800 favorable

 

1.b. The material quantity variance is

a. 900 favorable
b. 0
c. 1,210 favorable
d. 1,800 favorable

 

1.c. The labor rate variance is

a. 1,400 favorable
b. 9,100 favorable
c. 6,600 favorable
d. 11,400 favorable

 

1.d. The labor efficiency variance is

a. 1,400 favorable
b. 9,100 favorable
c. 6,600 unfavorable
d. 11,400 favorable

 

1.e. The variable overhead spending variance is

a. 7,980 favorable
b. 980 favorable
c. 5,420 favorable
d. 32,000 favorable

 

1.f. The variable overhead efficiency variance is
a. 7,980 favorable
b. 980 favorable
c. 5,420 favorable
d. 32,000 favorable

Answer

a. B
b. A
c. B
d. D
e. C
f. A

Material:

AQ x AP                  AQ         x SP                 AQ         x SP                  SQ x SP
(Purchased)          Purchased                  Used                             (used)

 

$46,210                 15,000 x $3                 15,300 x $3               5,200 x 3 x $3
                                = $45,000                     = $45,900                  = $46,800

Variance            $1,210 U                                                $900 F

Labor:

AQ x AP    AQ x SP     SQ x SP
$239,500 24,860 x $10
 = $248,600
5,200 x 5 x $10
     $260,000
Variance    $9,100 F    $11,400 F

Variable Overhead:

AQ x AP    AQ x SP      SQ x SP
$168,600 24,860 x $7
= $174,020
5,200 x 5 x $7
  = $182,000
Variance   $5,420 F     $7,980 F

Important to Notice:

For variable overhead the quantities that were used were the labor quantities, because the rate is “per hour”

The budgeted production is not used for variable cost variances. It was used initially to calculate the variable manufacturing cost per hour using the predetermined overhead calculation and is not correct.

Variable Costs Variances – Practice as You Learn – Problem 2.

Follow the same 5 steps described above.

The following activity took place at Octy Manufacturing Company during this year:

Number of units produced 500 units
Actual direct labor cost per hour $10.25
Material purchased 1,600 feet
Actual machine hours used 1,246
Material used 872 feet
Actual variable overhead $ spent $11,212
Actual cost per foot for material $4
Actual fixed overhead $ spent $32,076
Direct labor hours worked 1,822

The standard cost sheet shows management estimated that 1.6 feet of material would be used for each product and materials would cost $4.20 per foot; it would take labor 4 hours to make 1 product at a cost of $10 per hour; variable overhead cost is expected to be $8.50 per machine hour used and it should take 2.2 machine hours to make one product. Fixed manufacturing overhead is expected to be $25 per machine hour. The company expected to produce 550 units during the year.

Calculate all variances and answer the following.

2a. The material price variance is

a. 320 favorable
b. 302 unfavorable
c. 4,620 unfavorable
d. 3,360 unfavorable

 

2.b. The material quantity variance is

a. 320 favorable
b. 302 unfavorable
c. 4,620 unfavorable
d. 3,360 unfavorable

 

2.c. The labor rate variance is

a. 1,780 favorable
b. 456 unfavorable
c. 3,780 unfavorable
d. 13,220 unfavorable

 

2.d. The labor efficiency variance is

a. 1,780 favorable
b. 456 unfavorable
c. 3,780 unfavorable
d. 13,220 unfavorable

 

2.e. The variable overhead spending variance is

a. 6,409 favorable
b. 306 unfavorable
c. 621 unfavorable
d. 1,241 unfavorable

 

2.f. The variable overhead efficiency variance is

a. 6,409 favorable
b. 306 unfavorable
c. 621 unfavorable
d. 1,241 unfavorable

Answer

a. A
b. B
c. B
d. A
e. C
f. D

Material:

AQ x AP                        AQ x SP                     AQ x SP                  SQ x SP
(purchased)                 Purchased               Used                      (Used)
1,600x $4                  1,600 x $4.20            872 x $4.20           500 x 1.6 x $4.20
= $6,400                     =$6,720                     = $3,662                  =$ 3,660

 

Variance              $320 F                                                 $302 U

Labor:

AQ x AP                                     AQ x SP                                SQ x SP
1,822 x $10.25                       1,822 x $10                         500 x 4 x $10
=$18,676                                 =$18,220                              =$20,000

 

Variance            $456 U                         $1,780 F

Variable Overhead:

AQ x AP                        AQ x SP                         SQ x SP
$11,212                      1,246 x $8.50                500 x 2.2 x $8.50
                                     = $10,591                      = $9,350

 

Variance             $621 U                  $1,241 U

Important to Notice:

Use Machine hour information for variable overhead because the variable overhead rate is per machine hour

The SQ is the actual units made x the standard that each one takes.

Material uses to differ AQ x SP, one for used and one for purchased.