The following data were drawn from the records of Campbell C

The following data were drawn from the records of Campbell Corporation Planned volume for year (static budget) Standard direct materials cost per unit Standard direct labor cost per unit Total expected fixed overhead costs Actual volume for the year (flexible budget) Actual direct materials cost per unit Actual direct labor cost per unit Total actual fixed overhead costs 3,700 units 2.90 pounds $1.90 per pound 2.70 hours * $3.90 per hour $19,240 4,100 units 2.50 pounds $2.20 per pound 3.20 hours $3.50 per hour $14,840 Required a. Prepare a materials variance information table showing the standard price, the actual price, the standard quantity, and the actual quantity. b. Calculate the materials price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U) c. Prepare a labor variance information table showing the standard price, the actual price, the standard hours, and the actual hours d. Calculate the labor price and usage variances. Indicate whether the variances are favorable (F or unfavorable (U) e. Calculate the predetermined overhead rate, assuming that Campbell uses the number of units as the allocation base f. Calculate the fixed cost spending variance. Indicate whether the variance is favorable (F) or unfavorable (U) g. Calculate the fixed cost volume variance. Indicate whether the variance is favorable (F) or unfavorable (U) Complete this question by entering your answers in the tabs below Req A Req B Req D Req E to G Prepare a materials variance information table showing the standard price, the actual price, the standard quantity, and the actual quantity. (Round \"Standard price\" and \"Actual price\" to 2 decimal places.) Materials Variance Information Table Standard price Actual price Standard quantity for flexible budget Actual quantity used per pound per pound pounds pounds Req A Req B >

Solution

(A) Material Variance information Table :-

Standard Price

1.90 Per pound

Actual Price

2.20 Per pound

Std Qty for flexible budget

(4100 * 2.90)

=11890 Pounds

Actual Qty used

(4100 * 2.50)

=10250 Pounds

(B)

Material Price Variance

3075 (U)

Material Usage Variance

3116 (F)

Material Price variance = (SP – AP) * Actual Qty

                   = (1.90 – 2.20) * 10250 = 3075 (U)

Material Usage variance = (Std Qty – Actual Qty) * SP

                  = (11890 – 10250) * 1.90 = 3116 (F)

(C) Labour Variance information Table :-

Standard Price

3.90 Per Hr

Actual Price

3.50 Per Hr

Std Hrs for flexible budget

(4100 * 2.70)

=11070 Hrs

Actual Hrs used

(4100 * 3.20)

=13120 Hrs

(D)

Labour Price Variance

5248 (F)

Labour Usage Variance

7995 (U)

Labour Price variance = (SP – AP) * Actual Hrs

                   = (3.90 – 3.50) * 13120= 5248 (F)

Labour Usage variance = (Std Hrs – Actual Hrs) * SP

                  = (11070 – 13120) * 3.90 = 7995 (U)

(E to G)

E

Predetermined O/H Rate

$ 5.2

F

Fixed cost spending variance

4400 (F)

G

Fixed cost volume variance

2080 (F)

Predetermined O/H rate = 19240/3700 units = $ 5.2 per unit

Fixed cost volume variance = Budget Fixed O/H – Absorbed Fixed O/H

Budget Fixed O/H = 19240

Absorbed = 4100 units * $ 5.2 = 21320

= 19240 – 21320 = 2080 (F)

Fixed O/H spending variance = Actual Fixed O/H – Budgeted Fixed O/H

Actual Fixed O/H = 14840

= 14840 – 19240 = 4400 (F)

Standard Price	1.90 Per pound
Actual Price	2.20 Per pound
Std Qty for flexible budget	(4100 * 2.90) =11890 Pounds
Actual Qty used	(4100 * 2.50) =10250 Pounds