Stuck on this homework in Managerial Accounting 220 if anyone can help I would greatly appreciate it!

these are the three wuestions to be answered. The rest of the excel is the given data. The cut out part says 'need to compute total # of hours'

1. Compute activity pools & cost per activity unit

2. customer BBB in the period placed for [in total] bought 100 product A & 120 product B find profit for customer BBB using FAC and ABC (activity based costing)

3. find profit by product and total company using variable and activity based costing

Income Statement {FAC) Variable Selling Expense[not Shipping] Variable Shipping Direct tracable to Product A or B Variable Mfg. OH Variable Selling Expense[not Shipping] Variable Shipping Sales $75,000 10,000 traced 12,000 640 18.75 64 traced 15.62 Direct Materials $20,000 Direct Labor $10,000 Variable Mfg. OH $12,000 Through ABCFixed. Mfg. OH $13,000 Total COGS $55,000 materials per unit below spread this based on Hours [computed with info below] spread this based on Hours (computed with info below] use DL hrs for Fxd. Mfg. OH to product under FAC traced Gross Profit $20,000 traced Sum 7,000 % of sales 9.33% traced Variable Selling Expense[not Shipping] $3,000 Variable Shipping $4,000 Through ABC Fixed Selling & Admin & R&D $11,000 Total Operating Expense $18,000 Operating Income 2,000 Toital $ Direct Labor total QTY Variable Mfg. OH Rate Hrs QTY sold COGS & Expenses Direct Direct Materials 20,000 Direct Labor 10,000 Variable Mfg. OH 12,000 Fixed. Mfg. OH Variable Selling Expense[not Shipping) 3,000 Variable shipping! Fixed Selling & Admin & R&D Indirect Traced through Cost System to products Traced through Cost System to products 10,000 13,000 12,000 sum of both 13,000 4,000 35,000 11,000 7,000 Sales $ Only two products so all of sales/Cogs ARE THESE TWO PRODUCTS Product A sell price each = $ 30.00 DL Hrs. unit 0.20 Units sold 1,100 $ 33,000.00 220.00 2 $ 33,000.00 220.00 Units sold Materials per unit = # orders $ 1,100 5.00 70 Total hrs. 1 2 3 Product B 1 5 sell price each = DL Hrs. unit Units sold Materials per unit = #orders $ 40.00 0.40 1,050 $ 13.81 40 S 42,000.00 $ 75,000.00 Total hrs. 420.00 640.00 Total company Hrs. 10,000 640.00 15.63 5 7 3 12,000 2 Shipping & Variable selling is % of sales $s of sales $ 9.33% 7,000 640.00 18.75 2 3 Cost per DL Hr. = customers = 40 #projects = 100 [compute] 40 100 5 5 7 3 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 1 2 3 1 5 5 7 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Activities Order Processing # of Orders Products DL Hrs Total Departments 3 e Production Dept. ZZZ For Production Dept. QQQ Selling Admin 10% 20% 20% 10% 15% . [per customer) ClassCo Maintain Sustaining Projects Customer General # of # of Unallocated Projects Customers 15% 10% 5% 10% 10% 10% 20% 25% 15% 20% 10% 35% 35% 10% 15% 60% 50% 20% 25% 25% 100% 100% 100% 100% 100% 2 3 R&D 1 5 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Order Activities Processing PL Hrs Total Departments # of Orders Production Dept. ZZZ For Production Dept. QQQ Selling Admin R&D 10% 20% 20% 10% 15% [per customer] ClassCo Maintain Products Projects Sustaining Customer General # of # of Unallocated Projects Customers 60% 15% 10% 5% 50% 10% 10% 10% 20% 20% 25% 15% 25% 20% 10% 35% 25% 35% 10% 15% 100% 100% 100% 100% 100% TO DO: A. B. Compute activity pools amounts & Cost per activity Unit [need to compute total # of Hrs.] Customer BBB in the period placed two orders for (in total] bought 100 Product A& 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC C. Compute activity pools amounts & Cost per activity Unit [need to compute Customer BBB in the period placed two orders for (in total] bought 100 Product A & 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC HW Ch.7 ABC For Both AEC P&L AND for Var.. Cost P&L Direct Materia Traced Direct Labor Direct Mat Variable Me OH Direct Lbb Variable Sellin Expenses Shipping Variable Variable Shipping Variable si Direct tracable to Product ACB Variable si Income Statement (FACH Sales $75,000 traced traced traced Direct Materials $20,000 materials per unit below Direct Labor $10,000 spread this based on Hours (computed with info below] Variable Mfg. OH $12,000 spread this based on Hours (computed with info below] Through ABEixed. Mfg. OH $13,000 use DL hrs for Fxd. Mfg. OH to product under FAC Total CGS $55,000 Gross Profil $20,000 Sum % of sales 7,000 9.33% traced exced Variable Selling Expensenot Shipping] $3,000 Variable Shipping $4,000 Through ABEixed Selling & Admin & R&D $11,000 Total Operating Expense $18,000 Operating Income 2.000 Indirect COGS & Expenses Direct Direct Materials 20,000 Direct Labor 10,000 Variable MfgOH 12.000 Fixed. Mig OH Variable Selling Expense not Shipping 3,000 Variable Shipping Fixed Selling & Admin & R&D Traced through Cost System to products Traced through Cost System to products 10.000 12.000 Sum of both 13.000 7,000 35.000 13,000 4,000 11,000 Sales 5 Only two products so all of sales/Cogs ARE THESE TWO PRODUCTS Product Asell price cach 30 DL Hranit 0.2 Units sold 1.100 Materials per unit 5 Wonders 70 33.000 220 Totalhes Product B sell price each DL Hunt Units sold Materials per unit #orders 40 0.4 1,050 13.81 40 0 42.000 75.000 Totalhes 420 640 Total company Hirs of sales Shipping & Variable selling is oor sales 9.33% 7,000 Cost per DL HE (compute customers 40 #projects - 100 100 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Total (per customer) ClassCo Maintain Order Activities Products Projects Customer Processing Departments DL Hrs # of # of # of Orders Projects Customers Production Dept. zzz 10% 60% 15% 10% For Production Dept. QQQ 20% 50% 10% 10% Selling 20% 20% 20% 25% Admin 10% 25% 20% 10% R&D 15% 25% 35% 10% Sustaining General Unallocated 5% 10% 15% 35% 15% 100% 100% 100% 100% 100% TO DO: B Compute activity pools amounts & Cost per activity Unit [need to compute total # of Hrs.) Customer BBB in the period placed two orders for (in total] bought 100 Product A & 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC C. 1. Compute activity pools &cost per activity unit 2. customer bbb in the period placed two orders for [in total] bought 100 product A & 120 product B. Profit for customer BBB using FAC & ABC costing 3. Profit by product & total company using Variable & ABC Income Statement {FAC) Variable Selling Expense[not Shipping] Variable Shipping Direct tracable to Product A or B Variable Mfg. OH Variable Selling Expense[not Shipping] Variable Shipping Sales $75,000 10,000 traced 12,000 640 18.75 64 traced 15.62 Direct Materials $20,000 Direct Labor $10,000 Variable Mfg. OH $12,000 Through ABCFixed. Mfg. OH $13,000 Total COGS $55,000 materials per unit below spread this based on Hours [computed with info below] spread this based on Hours (computed with info below] use DL hrs for Fxd. Mfg. OH to product under FAC traced Gross Profit $20,000 traced Sum 7,000 % of sales 9.33% traced Variable Selling Expense[not Shipping] $3,000 Variable Shipping $4,000 Through ABC Fixed Selling & Admin & R&D $11,000 Total Operating Expense $18,000 Operating Income 2,000 Toital $ Direct Labor total QTY Variable Mfg. OH Rate Hrs QTY sold COGS & Expenses Direct Direct Materials 20,000 Direct Labor 10,000 Variable Mfg. OH 12,000 Fixed. Mfg. OH Variable Selling Expense[not Shipping) 3,000 Variable shipping! Fixed Selling & Admin & R&D Indirect Traced through Cost System to products Traced through Cost System to products 10,000 13,000 12,000 sum of both 13,000 4,000 35,000 11,000 7,000 Sales $ Only two products so all of sales/Cogs ARE THESE TWO PRODUCTS Product A sell price each = $ 30.00 DL Hrs. unit 0.20 Units sold 1,100 $ 33,000.00 220.00 2 $ 33,000.00 220.00 Units sold Materials per unit = # orders $ 1,100 5.00 70 Total hrs. 1 2 3 Product B 1 5 sell price each = DL Hrs. unit Units sold Materials per unit = #orders $ 40.00 0.40 1,050 $ 13.81 40 S 42,000.00 $ 75,000.00 Total hrs. 420.00 640.00 Total company Hrs. 10,000 640.00 15.63 5 7 3 12,000 2 Shipping & Variable selling is % of sales $s of sales $ 9.33% 7,000 640.00 18.75 2 3 Cost per DL Hr. = customers = 40 #projects = 100 [compute] 40 100 5 5 7 3 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 1 2 3 1 5 5 7 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Activities Order Processing # of Orders Products DL Hrs Total Departments 3 e Production Dept. ZZZ For Production Dept. QQQ Selling Admin 10% 20% 20% 10% 15% . [per customer) ClassCo Maintain Sustaining Projects Customer General # of # of Unallocated Projects Customers 15% 10% 5% 10% 10% 10% 20% 25% 15% 20% 10% 35% 35% 10% 15% 60% 50% 20% 25% 25% 100% 100% 100% 100% 100% 2 3 R&D 1 5 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Order Activities Processing PL Hrs Total Departments # of Orders Production Dept. ZZZ For Production Dept. QQQ Selling Admin R&D 10% 20% 20% 10% 15% [per customer] ClassCo Maintain Products Projects Sustaining Customer General # of # of Unallocated Projects Customers 60% 15% 10% 5% 50% 10% 10% 10% 20% 20% 25% 15% 25% 20% 10% 35% 25% 35% 10% 15% 100% 100% 100% 100% 100% TO DO: A. B. Compute activity pools amounts & Cost per activity Unit [need to compute total # of Hrs.] Customer BBB in the period placed two orders for (in total] bought 100 Product A& 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC C. Compute activity pools amounts & Cost per activity Unit [need to compute Customer BBB in the period placed two orders for (in total] bought 100 Product A & 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC HW Ch.7 ABC For Both AEC P&L AND for Var.. Cost P&L Direct Materia Traced Direct Labor Direct Mat Variable Me OH Direct Lbb Variable Sellin Expenses Shipping Variable Variable Shipping Variable si Direct tracable to Product ACB Variable si Income Statement (FACH Sales $75,000 traced traced traced Direct Materials $20,000 materials per unit below Direct Labor $10,000 spread this based on Hours (computed with info below] Variable Mfg. OH $12,000 spread this based on Hours (computed with info below] Through ABEixed. Mfg. OH $13,000 use DL hrs for Fxd. Mfg. OH to product under FAC Total CGS $55,000 Gross Profil $20,000 Sum % of sales 7,000 9.33% traced exced Variable Selling Expensenot Shipping] $3,000 Variable Shipping $4,000 Through ABEixed Selling & Admin & R&D $11,000 Total Operating Expense $18,000 Operating Income 2.000 Indirect COGS & Expenses Direct Direct Materials 20,000 Direct Labor 10,000 Variable MfgOH 12.000 Fixed. Mig OH Variable Selling Expense not Shipping 3,000 Variable Shipping Fixed Selling & Admin & R&D Traced through Cost System to products Traced through Cost System to products 10.000 12.000 Sum of both 13.000 7,000 35.000 13,000 4,000 11,000 Sales 5 Only two products so all of sales/Cogs ARE THESE TWO PRODUCTS Product Asell price cach 30 DL Hranit 0.2 Units sold 1.100 Materials per unit 5 Wonders 70 33.000 220 Totalhes Product B sell price each DL Hunt Units sold Materials per unit #orders 40 0.4 1,050 13.81 40 0 42.000 75.000 Totalhes 420 640 Total company Hirs of sales Shipping & Variable selling is oor sales 9.33% 7,000 Cost per DL HE (compute customers 40 #projects - 100 100 Departments of Indirect Overhead Fixed. Mfg. OH For Production Dept. ZZZ For Production Dept. QQQ 6,000 7,000 13,000 Fixed Selling & Admin & R&D Selling Admin R&D 3400 4000 3600 11000 Total (per customer) ClassCo Maintain Order Activities Products Projects Customer Processing Departments DL Hrs # of # of # of Orders Projects Customers Production Dept. zzz 10% 60% 15% 10% For Production Dept. QQQ 20% 50% 10% 10% Selling 20% 20% 20% 25% Admin 10% 25% 20% 10% R&D 15% 25% 35% 10% Sustaining General Unallocated 5% 10% 15% 35% 15% 100% 100% 100% 100% 100% TO DO: B Compute activity pools amounts & Cost per activity Unit [need to compute total # of Hrs.) Customer BBB in the period placed two orders for (in total] bought 100 Product A & 120 Product B Profit for Cust. BBB using FAC & ABC costing Profit by product & Total company using, Variable & ABC C. 1. Compute activity pools &cost per activity unit 2. customer bbb in the period placed two orders for [in total] bought 100 product A & 120 product B. Profit for customer BBB using FAC & ABC costing 3. Profit by product & total company using Variable & ABC