so adding on to above just needing help with abc portion not understanding pools.

Bad Normal Conditional Format as Check Cell Formatting Table Norma Explanator Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Calibri - 11-AA === Wrap Text General Copy Format Painter BIU A 3 Merge & Center - $ % , *8.99 pboard Font Alignment E Number Xf IBI c C D E F G H I K Traditional Allocation by Direct Labor hours Instructions: Complete the yellow-shaded cells. The data needed to complete these cells can be found on Worksheets 2 and 3. Be sure to use the Variable overhead from the Variable Costing (Contribution Margin) Income Statement. L M M INI Allocation rate = = = $ 3.36 Total Variable Overhead Total Direct Labor Hours $ 43,550 12,950 Variable Overhead total DL hours hour Estate 3,000 $ 3.36 = Blend 5,000 * $ 3.36 Table 4,950 * $ 3.36 12,950 product $ 10,080 $ 16,815 $ 16,632 $ 43,527 "ALB Activity-Based Costing Instructions: Complete the yellow-shaded cells. Data for this page can be found in the Case study write-up and worksheet 1 of this project. Step 1 Identity Cost Objects quantity Sal Cost Object Estate Blend Generic 11 Step 2 12 Identity Costs to Allocate Indirect Cost process Sales commissions Recycled Scrap Grapes 17. Step 3 Cost Driver Activity Cost Pool Cost Group Activites into Pools Activity Pools Pool #1 (Winemaking) Recycled Scrap Grapes # of varietals Pool 2 (Customer Orders) Sales commissions Pool #3 Product Support) proces 31 Step 4 Determine the the Activity rate for each Pool costs Expected Activity assigned to Pool Activity rate SIS Activity Pools Winemaking Customer Orders Production Support Cost Driver of varietals of pallets Mig hours #DIV/01 dWS WS5 - ABC WS 6V Part ... ws 8 - Dropws Ws 4 - Trad. OH Ready Step 5 Activity Consumed Activity Consumed Allocate Indirect Cost to Product Estate Activity Cost Pool Consumed Pool # 1 (Winemakine) Pool 2 (Customer Orders) Pool #3 (Production *** 8760 hours x sales mix Activity rate IS T $ - #DIV/0! Activity cost allocated S - S . #DIV/0! Blend Activity rate 5 S . #DIV/0! Activity cost allocated - S . #DIV/0! Table Activity rate - S - #DIV/0! Activity cost allocated totals S .S OS #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! BIU - A E = = 2 Merge & Center $ % 1000 Formattir Format Painter Clipboard Font Alignment Number Variable Cost Computation Instructions: Complete the yellow-shaded cells. The data needed to complete this worksheet can be found on worksheets 3 - Contribution Margin Income Statement, and workseet 4 - Traditional OH Estate Blend Table Variable Cost Direct Materials Direct Labor Variable overhead (use Traditional method) Total Variable Costs #bottles sold Variable Cost per bottle lonca H23 DE Instructions: Complete the yellow-shaded cells. The data needed to complete this worksheet can be found on worksheets 3 and 6 of this project. Contribution Margin Computation mtoa Retail Price/bottle Variable Cost/bottle Total Lbs of grapes per CM per bottle bottle CM per lb of grapes Estate Blend Table 9.78 Neno Bad Normal Conditional Format as Check Cell Formatting Table Norma Explanator Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Calibri - 11-AA === Wrap Text General Copy Format Painter BIU A 3 Merge & Center - $ % , *8.99 pboard Font Alignment E Number Xf IBI c C D E F G H I K Traditional Allocation by Direct Labor hours Instructions: Complete the yellow-shaded cells. The data needed to complete these cells can be found on Worksheets 2 and 3. Be sure to use the Variable overhead from the Variable Costing (Contribution Margin) Income Statement. L M M INI Allocation rate = = = $ 3.36 Total Variable Overhead Total Direct Labor Hours $ 43,550 12,950 Variable Overhead total DL hours hour Estate 3,000 $ 3.36 = Blend 5,000 * $ 3.36 Table 4,950 * $ 3.36 12,950 product $ 10,080 $ 16,815 $ 16,632 $ 43,527 "ALB Activity-Based Costing Instructions: Complete the yellow-shaded cells. Data for this page can be found in the Case study write-up and worksheet 1 of this project. Step 1 Identity Cost Objects quantity Sal Cost Object Estate Blend Generic 11 Step 2 12 Identity Costs to Allocate Indirect Cost process Sales commissions Recycled Scrap Grapes 17. Step 3 Cost Driver Activity Cost Pool Cost Group Activites into Pools Activity Pools Pool #1 (Winemaking) Recycled Scrap Grapes # of varietals Pool 2 (Customer Orders) Sales commissions Pool #3 Product Support) proces 31 Step 4 Determine the the Activity rate for each Pool costs Expected Activity assigned to Pool Activity rate SIS Activity Pools Winemaking Customer Orders Production Support Cost Driver of varietals of pallets Mig hours #DIV/01 dWS WS5 - ABC WS 6V Part ... ws 8 - Dropws Ws 4 - Trad. OH Ready Step 5 Activity Consumed Activity Consumed Allocate Indirect Cost to Product Estate Activity Cost Pool Consumed Pool # 1 (Winemakine) Pool 2 (Customer Orders) Pool #3 (Production *** 8760 hours x sales mix Activity rate IS T $ - #DIV/0! Activity cost allocated S - S . #DIV/0! Blend Activity rate 5 S . #DIV/0! Activity cost allocated - S . #DIV/0! Table Activity rate - S - #DIV/0! Activity cost allocated totals S .S OS #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! BIU - A E = = 2 Merge & Center $ % 1000 Formattir Format Painter Clipboard Font Alignment Number Variable Cost Computation Instructions: Complete the yellow-shaded cells. The data needed to complete this worksheet can be found on worksheets 3 - Contribution Margin Income Statement, and workseet 4 - Traditional OH Estate Blend Table Variable Cost Direct Materials Direct Labor Variable overhead (use Traditional method) Total Variable Costs #bottles sold Variable Cost per bottle lonca H23 DE Instructions: Complete the yellow-shaded cells. The data needed to complete this worksheet can be found on worksheets 3 and 6 of this project. Contribution Margin Computation mtoa Retail Price/bottle Variable Cost/bottle Total Lbs of grapes per CM per bottle bottle CM per lb of grapes Estate Blend Table 9.78 Neno