need help with exercise 6

Exercise 6 - Manufacturing Company makes 3 products: A, B, and C. Shown below are the estimated costs and estimated production data for next year. Cost Pools Overhead Cost Driver Customer Service $180,000 Customers Design $120,000 Modifications Storage $60,000 Square feet used Ordering & Receiving $30,000 Number of orders Packaging $90,000 Number of units Supervision $60,000 Number of employees Total Estimated overhead $540,000 Prod A Prod B Prod C Total Customers 60 100 40 200 Modifications 15 25 10 Square feet used 1,000 600 400 2,000 Number of orders 60 20 160 Number of units 6,000 4,000 2,000 12,000 Number of employees 50 Estimates By Product Sales Direct materials costs Direct labor costs Prod A $1,200,000 $480,000 $300,000 Prod B $1,140,000 $300,000 $360,000 Prod C $990,000 $240,000 $540,000 Total $3,330,000 $1,020,000 $1,200,000 Calculate ABC rates for each cost pool: a) Customer Service b) Design c) Storage d) Ordering & Receiving e) Packaging f) Supervision per customer per modificaton per sq. ft. per order per unit per employee Prod C XX Calculate the overhead assigned using ABC method: Prod A Prod B g) Customer Service h) Design i) Storage i) Ordering & Receiving k) Packaging 1) Supervision m) Total Overhead Assigned Calculate total cost & net profit using ABC method: Prod A Prod B n) Total Cost (DM+DL+MO) O) Net Profit Prod C XXX per DLS X p) Calculate single plant-wide overhead rate: (assume the overhead allocation base is direct labor) Prod C Calculate the following using the single plant-wide rate: Prod A Prod B q) Total Overhead Assigned r) Total Cost s) Net Profit XXX XXX XXX