Paste Format C57 GH I Exercise6-Manufacturing Company makes 3 products: A, B, and C. Shown below are the estimated costs and estimated production data for next vear $240,000 Customers $160,000 Modifications $80,000 Square feet used $40,000Number of orders $120,000 Number of units $80,000 Number of employees 6 Customer Service 7Design 9 Ordering & Receiving 10Pacaging 11 Supervision 12Total Estimated overhead Prod B 15 Customers 16 Moditications 17Square teetused Total zu0 bU 40 15 25 40U Number ot ordens 16u 19 Number ot units 20 Number ot employees 4,000 Prod B $480,000 b,o00 ProdA Prod C Total 23 Sales 24 Direct materials costs 25 Direct labor costs $1,600,000 $1,520,000$1.320,000 $4440,000 $640,000 $400,000 $320,000 $1,360,000 400,000 S720,000$1,600,000 27 Calculate ABC rates for each cost pool: 29 a) Custorner Service 30 b) Design 31 c) 32 d) Ordering & Receiving 33 e) Packaging 34,Supervision per customer per modificaton per sq ft per order per unit per employee 35 36 Calculate the overhead assigned using ABC method: Prod A Prod B Prod C 38 g) Customer Service 39 h) Design 40 i) Stora 41 | )|Ordering& Receiving 42 k) Packagin x x X x x X | I Supervision 44 m) Total Overhead Assignedm x x X x X X 46 Calculate total cost & net profit using ABC method Prod A Prod B 48 n) Total Cost (DM DL.MO 49 o) Net Profit x x X 51 p) 52 Calculate single plant-wide overhead rate (assume the overhead allocation base is direct labor) per DL $ 4 Calculate the following using the single plant-wide rate Prod A Prod B Prod C 56 gllTotal Overhead Assigned 57 r) Total Cost 58 s) INet Profit x X X x X X