I need help with the red x's please.

Draw with Touch Ink to Shape Ink to Math Ink Replay Drawing Tools Touch Convert Replay E45 G H I A B D E F Exercise 6 - Manufacturing Company makes 3 products: A, B, and C. Shown below are the 3 estimated costs and estimated production data for next year. 5 Cost Pools Overhead Cost Driver 6 Customer Service $150,000 Customers 7 Design $100,000 Modifications 8 Storage $50,000 Square feet used 9 Ordering & Receiving $25,000 Number of orders 10 Packaging $75,000 Number of units 11 Supervision $50,000 Number of employees 12 Total Estimated overhead $450,000 13 74 Prod A Prod B Prod C Total 15 Customers 60 100 40 200 16 Modifications 15 25 10 50 17 Square feet used 1,000 600 400 2,000 18 Number of orders 60 80 20 160 79 Number of units 6,000 4,000 2,000 12,000 20 Number of employees 3 1 1 5 27 22 Estimates By Product Prod A Prod B Prod C Total 23 Sales $1,000,000 $950,000 $825,000 $2,775,000 24 Direct materials costs $400,000 $250,000 $200,000 $850,000 Direct labor costs $250,000 $300,000 $450,000 $1,000,000 Calculate ABC rates for each cost pool: 29 a) Customer Service $750.00 30 b) Design $2,000.00 31 c) Storage $25.00 32 d) Ordering & Receiving $156.25 33 el Packaging $625 1-3 4-5 6 DO QS EX PR In-class Problem per customer per modificaton per sq. ft. per order ner unit Class Notes Ready Type here to search Drawing Tools Touch Convert Replay E45 fx E F G H I Y Prod C $30,000.00 $20,000.00 $10,000.00 $3,125.00 $12,500.00 $10,000.00 $85,625.00 A B C D 33 e) Packaging $6.25 per unit 34 f) Supervision $10,000.00 per employee 35 36 Calculate the overhead assigned using ABC method: 37 Prod A Prod B 38 g) Customer Service $45,000.00 $75,000.00 39 h) Design $30,000.00 $50,000.00 40 i) Storage $25,000.00 $15,000.00 41 i) Ordering & Receiving $9,375.00 $12,500.00 42 k) Packaging $37,500.00 $25,000.00 43 1) Supervision $30,000.00 $10,000.00 44 m) Total Overhead Assigned $176,875.00 $187,500.00 45 46 Calculate total cost & net profit using ABC method: 47 Prod A Prod B 48 n) Total Cost (DM+DL+MO) 49 o) Net Profit 50 51 p) Calculate single plant-wide overhead rate: 52 (assume the overhead allocation base is direct labor) 53 54 Calculate the following using the single plant-wide rate: 55 Prod A Prod B 56 g) Total Overhead Assigned 57 r) Total Cost 58 s Net Profit 1-3 4-5 6 DQ OS EX PR In-class Problem Class Notes Prod C X X X X X X per DL $ X Prod C X X X X X X Ready Type here to search CH Draw with Touch Ink to Shape Ink to Math Ink Replay Drawing Tools Touch Convert Replay E45 E F G H I Y Prod C X X X X X X per DL $ X Prod C A B D 45 46 Calculate total cost & net profit using ABC method: 47 Prod A Prod B 48 n) Total Cost (DM+DL+MO) 490) Net Profit 50 51 p) Calculate single plant-wide overhead rate: 52 (assume the overhead allocation base is direct labor) 53 54 Calculate the following using the single plant-wide rate: 55 Prod A Prod B 56 m) Total Overhead Assigned 57 r) Total Cost 58 s Net Profit 59 60 61 62 63 64 65 66 67 68 X X X X X X X X X 69 70 1 DOO y