Exercise 6 Manufacturing Company makes 3 products: A, B, and C. Shown below are
ID: 2338520 • Letter: E
Question
Exercise 6 Manufacturing Company makes 3 products: A, B, and C. Shown below are the estimated costs and estimated production data for next vear. Customer Service Design Storage Ordering & Receiving Packaging Supervision Total Estimated overhead $120,000 Customers $80,000 Modifications $40,000 Square feet used $20,000Number of orders $60,000 Number of units $40.000Number of employees $360,000 Customers Modifications Square feet used Number of orders Number of units Number of employees 60 15 1,000 60 6,000 Prod B 100 25 600 80 4,000 Prod C 40 10 400 20 2,000 Total 200 50 2,000 160 12,000 5 ProdA $800,000 $320,000 $200,000 ProdB $760,000 $200,000 $240,000 Total $660,000 $2,220,000 $160,000 $360,000 Sales $680,000 $800,000 Direct materials costs Direct labor costs Calculate ABC rates for each cost pool: a) Customer Service blDes1 c)lStorage d) Ordering & Receivirn e) Packaging f) Supervision $600.00per customer $1,600.00per modificaton $20.00per sq. ft. $125.00per order $5.00 $8,000.00per employee per unitExplanation / Answer
Answer
Working
Prod A
Prod B
Prod C
A [calculated by you in 'p']
Single Plant Wide overhead rate per DL $
$ 0.45
$ 0.45
$ 0.45
B [given]
Amount of $ Direct Labor cost
$ 200,000.00
$ 240,000.00
$ 360,000.00
C = A x B
Total Overhead assigned ( 'q' )
$ 90,000.00
$ 108,000.00
$ 162,000.00
D [given]
Direct Material costs
$ 320,000.00
$ 200,000.00
$ 160,000.00
E = B+C+D
Total Cost ( 'r')
$ 610,000.00
$ 548,000.00
$ 682,000.00
F [given]
Sales
$ 800,000.00
$ 760,000.00
$ 660,000.00
G = F - E
Net Profit ( 's' )
$ 190,000.00
$ 212,000.00
$ (22,000.00)
Working
Prod A
Prod B
Prod C
A [calculated by you in 'p']
Single Plant Wide overhead rate per DL $
$ 0.45
$ 0.45
$ 0.45
B [given]
Amount of $ Direct Labor cost
$ 200,000.00
$ 240,000.00
$ 360,000.00
C = A x B
Total Overhead assigned ( 'q' )
$ 90,000.00
$ 108,000.00
$ 162,000.00
D [given]
Direct Material costs
$ 320,000.00
$ 200,000.00
$ 160,000.00
E = B+C+D
Total Cost ( 'r')
$ 610,000.00
$ 548,000.00
$ 682,000.00
F [given]
Sales
$ 800,000.00
$ 760,000.00
$ 660,000.00
G = F - E
Net Profit ( 's' )
$ 190,000.00
$ 212,000.00
$ (22,000.00)