a. Budgeted manufacturing overhead 60,000$
Budgeted direct labor hours (DLH) ÷ 15,000
Manufacturing overhead application rate $4 per DLH
Manufacturing overhead allocated using DLH Tabby Treat Fresh n’ Fishy
75,000 bags × 0.04 DLH per bag × $4 per DLH 12,000$
48,000 cases × 0.25 DLH per case × $4 per DLH 48,000$
b. Percent of cost driver assigned to each product line Tabby Treat Fresh n’ Fishy
Fresh n’ Fishy (30 Setups ÷ 100 Setups) 30%
Tabby Treat (42,000 Sq. Ft. ÷ 50,000 Sq. Ft.) 84%
Fresh n’ Fishy (8,000 Sq. Ft. ÷ 50,000 Sq. Ft.) 16%
Tabby Treat (3,000 DLH ÷ 15,000 DLH) 20%
Fresh n’ Fishy (12,000 DLH ÷ 15,000 DLH) 80%
Manufacturing overhead allocated using ABC Tabby Treat Fresh n’ Fishy
Utilities cost pool (using KWH as a cost driver):
Tabby Treat (80% × $26,000) 20,800$
Fresh n’ Fishy (20% × $26,000) 5,200$
Maintenance cost pool (using setups as a cost driver):
Tabby Treat (70% × $19,000) 13,300
Fresh n’ Fishy (30% × $19,000) 5,700
Depreciation cost pool (using Sq. Ft. as a cost driver):
Tabby Treat (84% × $12,000) 10,080
Fresh n’ Fishy (16% × $12,000) 1,920
Tabby Treat (20% × $3,000) 600
Total overhead allocated to each product line using ABC 44,780$ 15,220$
Tabby Treat (200,000 KWH ÷ 250,000 KWH) 80%
Fresh n’ Fishy (50,000 KWH ÷ 250,000 KWH) 20%
Machine Setups:
Tabby Treat (70 Setups ÷ 100 Setups) 70%