Question

In: Accounting

The following data were drawn from the records of Campbell Corporation. Planned volume for year (static...

The following data were drawn from the records of Campbell Corporation.

Planned volume for year (static budget) 3,900 units
Standard direct materials cost per unit 3.60 pounds @ $ 2.00 per pound
Standard direct labor cost per unit 2.80 hours @ $ 4.00 per hour
Total expected fixed overhead costs $ 21,840
Actual volume for the year (flexible budget) 4,200 units
Actual direct materials cost per unit 3.00 pounds @ $ 2.30 per pound
Actual direct labor cost per unit 3.10 hours @ $ 3.50 per hour
Total actual fixed overhead costs $ 17,640

Required

Prepare a materials variance information table showing the standard price, the actual price, the standard quantity, and the actual quantity.

Calculate the materials price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U).

Prepare a labor variance information table showing the standard price, the actual price, the standard hours, and the actual hours.

Calculate the labor price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U).

Calculate the predetermined overhead rate, assuming that Campbell uses the number of units as the allocation base.

Calculate the fixed cost spending variance. Indicate whether the variance is favorable (F) or unfavorable (U).

Calculate the fixed cost volume variance. Indicate whether the variance is favorable (F) or unfavorable (U).

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 per pound
Actual price per pound
Standard quantity for flexible budget pounds
Actual quantity used pounds

Calculate the materials price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)

Material price variance
Material usage variance


Prepare a labor variance information table showing the standard price, the actual price, the standard hours, and the actual hours. (Round "Standard price" and "Actual price" to 2 decimal places.)

Labor Variance Information Table
Standard price per hour
Actual price per hour
Standard hours for flexible budget
Actual hours used

Calculate the labor price and usage variances. Indicate whether the variances are favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)

Labor price variance
Labor usage variance


Calculate the predetermined overhead rate, assuming that Campbell uses the number of units as the allocation base. Calculate the fixed cost spending variance and the fixed cost volume variance. Indicate whether the variance is favorable (F) or unfavorable (U). (Round "Predetermined overhead rate" answer to 2 decimal places. Select "None" if there is no effect (i.e., zero variance).)

Show less

e. Predetermined overhead rate per unit
f. Fixed cost spending variance
g. Fixed cost volume variance

Solutions

Expert Solution

Solution a&b:

Materials Variance Information Table
Standard price $2.00 per pound
Actual price $2.30 per pound
Standard quantity for flexible budget 15120 pounds
Actual quantity used 12600 pounds

Material price variance = (SP - AP) * AQ = ($2 - $2.30) * 12600 = $3,780 U

Material usage variance = (SQ - AQ) * SP = (15120 - 12600) * $2 = $5,040 F

Solution c&d:

Labor Variance Information Table
Standard price $4.00 per hour
Actual price $3.50 per hour
Standard hours for flexible budget 11760
Actual hours used 13020

Labor price variance = (SP - AP) * AH = ($4 - $3.50) * 13020 = $6,510 F

Labor usage variance = (SH - AH) * SP = (11760 - 13020) * $4 = $5,040 U

Solution e, f and g:

Predetermined overhead rate = Budgeted fixed overhead / Budgeted nos of units = $21,840 /3900 = $5.60 per unit

Budgeted fixed cost = $21,840

Actual fixed costs = $17,640

Fixed cost applied = Actual nos of units * Predetermined overhead rate = 4200 * 5.60 = $23,520

Fixed cost spending variance = Budgeted fixed cost - Actual fixed cost = $21,840 - $17,640 = $4,200 F

Fixed cost volume variance = Fixed cost applied - Budgeted fixed cost = $23,520 - $21,840 = $1,680 F


Related Solutions

The following data were drawn from the records of Campbell Corporation. Planned volume for year (static...
The following data were drawn from the records of Campbell Corporation. Planned volume for year (static budget) 4,100 units Standard direct materials cost per unit 3.20 pounds @ $ 1.20 per pound Standard direct labor cost per unit 3.00 hours @ $ 3.90 per hour Total expected fixed overhead costs $ 17,630 Actual volume for the year (flexible budget) 4,300 units Actual direct materials cost per unit 2.60 pounds @ $ 1.60 per pound Actual direct labor cost per unit...
The following data were drawn from the records of Perez Corporation. Planned volume for year (static...
The following data were drawn from the records of Perez Corporation. Planned volume for year (static budget) 3,000 units Standard direct materials cost per unit 2.30 pounds @ $ 1.60 per pound Standard direct labor cost per unit 2.20 hours @ $ 3.50 per hour Total expected fixed overhead costs $ 13,200 Actual volume for the year (flexible budget) 3,200 units Actual direct materials cost per unit 1.80 pounds @ $ 2.20 per pound Actual direct labor cost per unit...
The following data were drawn from the records of Quentin Corporation: Planned volume for year (static...
The following data were drawn from the records of Quentin Corporation: Planned volume for year (static budget): 6000 Standard direct labor materials cost per unit: 3.1 pounds @ $3.00 per pound Standard direct labor cost per unit: 2 hours @ $8.00 per hour Total expected fixed overhead costs: $56400 Actual volume for the year (flexible budget): 6300 units Actual direct materials cost per unit: 2.7 pounds @ $4.00 per pound Actual direct labor cost per unit: 2.3 hours @$7.20 per...
The following data were drawn from the records of Finch Corporation. Planned volume for year (static...
The following data were drawn from the records of Finch Corporation. Planned volume for year (static budget) 4,700 units Standard direct materials cost per unit 2.40 pounds @ $ 1.70 per pound Standard direct labor cost per unit 2.80 hours @ $ 3.40 per hour Total expected fixed overhead costs $ 23,970 Actual volume for the year (flexible budget) 5,100 units Actual direct materials cost per unit 2.10 pounds @ $ 2.30 per pound Actual direct labor cost per unit...
The following data were drawn from the records of Benson Corporation. Planned volume for year (static...
The following data were drawn from the records of Benson Corporation. Planned volume for year (static budget) 3,800 units Standard direct materials cost per unit 2.70 pounds @ $ 1.50 per pound Standard direct labor cost per unit 2.50 hours @ $ 3.80 per hour Total expected fixed overhead costs $ 14,440 Actual volume for the year (flexible budget) 4,000 units Actual direct materials cost per unit 2.40 pounds @ $ 2.10 per pound Actual direct labor cost per unit...
6. The following accounts and balances were drawn from the records of Barker Company at December...
6. The following accounts and balances were drawn from the records of Barker Company at December 31, 2018: Supplies $ 820 Beginning retained earnings $ 20,000 Cash flow from investing act. (6,400 ) Cash flow from financing act. (5,300 ) Prepaid insurance 2,500 Rent expense 2,300 Service revenue 80,000 Dividends 5,200 Other operating expenses 43,000 Cash 11,900 Supplies expense 230 Accounts receivable 20,000 Insurance expense 1,000 Prepaid rent 4,800 Beginning common stock 1,000 Unearned revenue 6,400 Cash flow from operating...
The following accounts and balances were drawn from the records of Barker Company at December 31,...
The following accounts and balances were drawn from the records of Barker Company at December 31, 2018: Supplies $ 690 Beginning retained earnings $ 19,000 Cash flow from investing act. (6,400 ) Cash flow from financing act. (5,700 ) Prepaid insurance 2,600 Rent expense 2,800 Service revenue 78,000 Dividends 4,900 Other operating expenses 42,000 Cash 10,900 Supplies expense 290 Accounts receivable 19,000 Insurance expense 1,000 Prepaid rent 5,000 Beginning common stock 1,100 Unearned revenue 6,400 Cash flow from operating act....
The following accounts and balances were drawn from the records of Barker Company at December 31,...
The following accounts and balances were drawn from the records of Barker Company at December 31, 2018: Supplies $ 770 Beginning retained earnings $ 18,000 Cash flow from investing act. (6,900 ) Cash flow from financing act. (5,600 ) Prepaid insurance 2,500 Rent expense 2,600 Service revenue 85,000 Dividends 5,400 Other operating expenses 43,000 Cash 12,300 Supplies expense 240 Accounts receivable 18,000 Insurance expense 1,200 Prepaid rent 4,900 Beginning common stock 900 Unearned revenue 6,900 Cash flow from operating act....
The following data were taken from the records of Colbern Company for the fiscal year ending...
The following data were taken from the records of Colbern Company for the fiscal year ending on July 31, 2020. Raw Material Inventory 8/1/2019 $19,200 Raw Material Inventory 7/31/2020 $15,840 Finished Goods Inventory 8/1/2019 $38,400 Finished Goods Inventory 7/31/2020 $30,360 Work In Process Inventory 8/1/2019 $7,920 \ Work In Process Inventory 7/31/2020 $7,440 Direct Labor $55,700 Indirect Labor $9,784 Accounts Receivable $10,800 Factory Insurance $1,840 Factory Machinery Depreciation $6,400 Factory Utilities $11,040 Office & Admin Utilities Expense $3,460 Office &...
The following data were taken from the records of Mavericks Inc, for the calendar year ended...
The following data were taken from the records of Mavericks Inc, for the calendar year ended December 31, 2020. 1-Jan 31-Dec Raw Materials Inventory               310,000    83,000 Work in Process Inventory               161,000 103,750 Finished Goods Inventory                 22,000    57,600 Additional Information: Total Costs Raw Materials Purchases               301,250 Direct Labor               315,000 Indirect Labor                 42,750 Equipment Depreciation                 61,000 Utilities                 50,750 Other Costs                 10,500 Factory Manager's Salary                 44,000 SG&A Salary                 85,500 Insurance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT