need answers to question marks and formulas to get them

F G H K Chapter 7: Applying Excel Da Wages & Salaries 5 Other Overtread Costs Total Overhead Costs $300,000 $100,000 $400,000 Other Tot 40% 10% 40% 100% 100% B Acavity Cost Pool Activity Measure Total Activity for the Year 9 Supporting direct labor Number of direct labor hours 20,000 DLHS 10 Order processing Number of customer orders 400 orden 11 Customer support Number of customers 200 otomers 12 Other 13 14 Distribution of Resources Consumption across Activities 15 Supporting Direct Labor Order Processing Customer Support 16 Wages and sales 30% 20% 17 Omeroved costs 30% 40% 20% 18 19 Shernen Enterprise Order Info 20 Quantity Duration 21 Unts Ordered 10 22 Direct Labor Hours 2 23 Selling Price $300 24 Direct Material $180 25 Direct Labor Hours $50 26 27 First Stage Allocation Oirect Labor Order Customer 28 Support Processing Support Total 29 Wages and Salanes $120.000 12 51120.000 30 Omer Overhead Costs 50 31 Total Costs $120.000 50 $0 $120,000 33 SE 33 Activity Rate Per Cost Pool Total Costs Total ACM Activity Rate 35 Orect Labor Support 120000 20,000 36 Oster Processing 12 VALUES 37 Customer Support 2 EVALUE A B D E ABC Costs 120 #VALUE! #VALUE! $3,000 ? ? ? ? ? 39 Activity Cost Pool & ABC Costs 40 41 42 Direct Labor Support 43 Order Processing 44 Customer Support 45 46 47 Customer Margin 48 49 Sales 50 51 Costs: 52 Direct Materials 53 Direct Labor 54 Direct Labor Support 55 Order Processing 56 Customer Support 57 Total Costs 58 59 Customer Margin 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 $0 $3,000