--- name: activity-based-costing description: Implement Activity-Based Costing (ABC) to accurately allocate overhead and indirect costs to products, services, customers, or channels based on the actual activities that consume resources. Use when users want to move beyond traditional volume-based allocation, understand true product profitability, identify cost drivers, optimize resource consumption, set data-driven prices, or eliminate unprofitable products/customers. Triggers on phrases like "activity based costing", "ABC costing", "cost driver analysis", "overhead allocation", "true product cost", "resource consumption", "profitability by product", "cost pool", "cost allocation base", "ABC implementation", "indirect cost allocation", or related ABC queries. --- # Activity-Based Costing (ABC) Implement Activity-Based Costing to accurately trace indirect and overhead costs to products, services, customers, and channels based on actual resource consumption — replacing arbitrary allocation bases with data-driven cost driver analysis. ## Workflow 1. **Assess Current Costing Methodology and Identify Gaps** - Diagnose limitations of existing allocation approach: ``` CURRENT COSTING DIAGNOSTIC ════════════════════════════════════════ Traditional Allocation (e.g., plant-wide overhead rate): → Single allocation base: Direct labor hours, machine hours, or revenue % → Assumption: All products consume overhead proportionally to one volume measure → Distortion: Complex products get under-costed; simple/high-volume products get over-costed Symptoms of Cost Distortion: → Product margins don't match market reality → "Cash cow" products appear profitable but cash flow is weak → New product pricing decisions feel arbitrary → Customer profitability varies wildly within same product line → Overhead is growing but allocation rates are flat ABC Readiness Assessment: → Is overhead >30% of total cost? (ABC justified if YES) → Is there diversity in products, processes, or customers? (ABC justified if YES) → Is management ready to act on costing insights? (critical for ROI) ``` 2. **Identify Activities and Build Activity Dictionary** - Map all resource-consuming activities: ``` ACTIVITY DICTIONARY TEMPLATE ════════════════════════════════════════ Activity Name: Production Setup Description: Machine setup and calibration for production runs Activity Driver: Number of setups Responsible Manager: Production Supervisor Resource Consumption: Labor hours, machine downtime, setup materials Activity Name: Quality Inspection Description: In-process and final quality checks Activity Driver: Number of inspections Responsible Manager: Quality Manager Resource Consumption: Inspector labor, testing equipment Activity Name: Order Processing Description: Receive, validate, and enter customer orders Activity Driver: Number of orders Responsible Manager: Order Management Resource Consumption: Staff time, system costs Activity Name: Customer Support Description: Respond to customer inquiries and issues Activity Driver: Number of support interactions Responsible Manager: Customer Support Resource Consumption: Support staff labor, CRM system Activity Name: Material Handling Description: Receiving, storing, and moving raw materials Activity Driver: Number of material moves / purchase orders Responsible Manager: Warehouse Manager Resource Consumption: Forklift labor, warehouse space, utilities Activity Name: Shipping Description: Pick, pack, and ship finished goods Activity Driver: Number of shipments Responsible Manager: Distribution Manager Resource Consumption: Labor, packaging, freight Target: 30-50 distinct activities (not too granular, not too aggregated) ``` 3. **Assign Resource Costs to Activity Cost Pools** - Trace resource costs to activities: ``` RESOURCE-TO-ACTIVITY ALLOCATION ════════════════════════════════════════ Step 1: Identify all resource costs → Direct labor by department → Indirect labor (supervisors, engineers, quality) → Facility costs (rent, utilities, insurance, property tax) → Equipment costs (depreciation, maintenance, operating) → IT costs (systems, software, support) → Administrative costs (HR, finance, legal) Step 2: Allocate resources to activities using resource drivers → Interview managers: "What % of your team's time goes to each activity?" → Use time-driven estimates or actual time studies → Cross-validate with historical data where available Example Resource Allocation: ════════════════════════════════════════ Resource Pool | Setup | Production | Quality | Shipping | Admin ──────────────────────┼───────┼────────────┼─────────┼──────────┼────── Production Labor | 15% | 65% | 10% | 10% | — Indirect Labor | 20% | 30% | 25% | 15% | 10% Equipment Depreciation | 10% | 70% | 10% | 5% | 5% Facility (rent/util) | 5% | 40% | 15% | 20% | 20% IT Systems | 10% | 30% | 15% | 15% | 30% ──────────────────────┼───────┼────────────┼─────────┼──────────┼────── Total per Activity | $X | $Y | $Z | $W | $V Result: Activity cost pools (total cost consumed by each activity) ``` 4. **Determine Cost Driver Quantities and Calculate Rates** - Calculate activity cost driver rates: ``` ACTIVITY COST DRIVER RATES ════════════════════════════════════════ Formula: Activity Cost Pool ÷ Total Driver Quantity = Driver Rate Example: ════════════════════════════════════════ Activity | Cost Pool | Total Driver Qty | Driver Rate ──────────────────┼────────────┼──────────────────┼───────────── Production Setup | $480,000 | 1,200 setups | $400 / setup Quality Inspection| $360,000 | 6,000 inspections| $60 / inspection Order Processing | $240,000 | 8,000 orders | $30 / order Customer Support | $300,000 | 15,000 calls | $20 / call Material Handling | $200,000 | 4,000 POs | $50 / PO Shipping | $500,000 | 5,000 shipments | $100 / shipment Validation: → Sum of allocated costs should equal total overhead → Driver rates should be stable period-over-period (flag >20% swings) → Cross-check with industry benchmarks where available ``` 5. **Assign Activity Costs to Cost Objects** - Trace activity consumption to products, customers, or channels: ``` PRODUCT COSTING EXAMPLE ════════════════════════════════════════ Product A (Complex, Low Volume): → Direct materials: $50/unit → Direct labor: $20/unit → Activity consumption: · Setups: 2 per batch, 100 units/batch → 0.02 setups/unit × $400 = $8/unit · Inspections: 3 per unit → 3 × $60 = $180/unit ← flag: review frequency · Orders: 0.01 orders/unit → 0.01 × $30 = $0.30/unit · Shipments: 0.002 shipments/unit (bulk) → 0.002 × $100 = $0.20/unit → Total ABC overhead: $8.20/unit (example simplified) → Total cost: $50 + $20 + $8.20 = $78.20/unit Product B (Simple, High Volume): → Direct materials: $30/unit → Direct labor: $10/unit → Activity consumption: · Setups: 1 per batch, 5,000 units/batch → 0.0002 setups/unit × $400 = $0.08/unit · Inspections: 0.5 per unit → 0.5 × $60 = $30/unit · Orders: 0.001 orders/unit → 0.001 × $30 = $0.03/unit · Shipments: 0.05 shipments/unit (small parcels) → 0.05 × $100 = $5/unit → Total ABC overhead: $35.11/unit → Total cost: $30 + $10 + $35.11 = $75.11/unit Traditional costing might allocate $45/unit of overhead to BOTH products, masking the true cost difference driven by complexity and setup frequency. ``` 6. **Analyze Results and Drive Decisions** - Use ABC insights for strategic actions: ``` ABC DECISION FRAMEWORK ════════════════════════════════════════ Product Decisions: → Raise prices on under-costed products (where market supports) → Redesign high-overhead products to reduce activity consumption → Discontinue products where price < ABC cost (true loss-makers) → Simplify product variants (reduce SKU proliferation cost) Customer Decisions: → Identify hidden-champion customers (low support, large orders) → Surcharge or restructure terms for high-cost customers (frequent small orders, high support volume, custom requirements) → Negotiate minimum order quantities to reduce per-unit overhead Process Decisions: → Target high-cost activities for automation or elimination → Reallocate resources from low-value to high-value activities → Redesign processes to reduce driver quantities (fewer setups, fewer rework inspections, fewer order changes) Pricing Decisions: → Set floor prices based on ABC full cost → Use ABC margins for discount authority guidelines → Build activity cost into quote-to-approval workflow ``` 7. **Implement Time-Driven ABC (TDABC) — Optional Advanced Approach** - Simplified ABC using time equations: ``` TIME-DRIVEN ABC (TDABC) ════════════════════════════════════════ Advantage: No need for manager interviews estimating capacity % Step 1: Calculate capacity cost rate → Total operational capacity cost: $10,000,000 / year → Practical capacity time: 500,000 hours / year → Capacity cost rate: $20 / hour Step 2: Build time equations for each process → Order processing time = 10 min base + 2 min per line item → Setup time = 30 min standard + 5 min per part number → Quality inspection = 5 min per unit + 15 min per batch Step 3: Measure actual time consumption → Product A order: 10 + (2 × 5 lines) = 20 min → $6.67 → Product B order: 10 + (2 × 1 line) = 12 min → $4.00 Step 4: Unused capacity = Total capacity - Used capacity → Quantify waste: Unused capacity × cost rate = cost of excess capacity ``` 8. **Maintain and Update ABC Model** - Establish governance: ``` ABC MAINTENANCE SCHEDULE ════════════════════════════════════════ Monthly: → Update activity driver quantities (from operational systems) → Recalculate driver rates → Run product/customer profitability reports Quarterly: → Validate resource allocation percentages → Review activity dictionary (add/remove activities) → Benchmark ABC costs against traditional costing Annually: → Full ABC model review → Update resource costs and capacity → Re-calibrate time estimates (spot-check with time studies) → Report ABC insights to senior management ``` ## Integration Points - **ERP/Accounting**: SAP (CO-PA module), Oracle, NetSuite (advanced cost management), Microsoft Dynamics - **Cost Accounting Software**: Costo, Xero Cost Tracker, ABC-specific platforms - **ERP Modules**: Production, inventory, procurement, sales (driver data sources) - **CRM**: Customer activity data (support calls, orders, account size) - **BI/Analytics**: Power BI, Tableau, Qlik (profitability dashboards) - **Spreadsheet Tools**: Excel (model building and sensitivity analysis) - **Time Tracking**: Time studies, IoT sensor data, system timestamps ## Edge Cases & Handling ``` EDGE CASES ═══════════════════════════════════════ 1. Service-Intensive Environments (Consulting, Healthcare, Education) → Activities are knowledge-based, not production-based → Time-driven ABC (TDABC) preferred over traditional ABC → Focus on client engagement activities, proposal writing, delivery → Cost objects = engagements, clients, service lines 2. Joint Costs / By-Products → Single process produces multiple outputs → Allocate using physical measure, market value, or NRV method → ABC can identify true cost of by-product handling and disposal 3. Seasonal / Cyclical Variations → Driver volumes vary significantly by season → Use annual rates to smooth, or quarterly rates if material → Flag unused capacity during low-demand periods 4. Multi-Facility Operations → Separate activity pools per facility → Compare driver rates across facilities for benchmarking → Consolidate ABC model for group-level reporting 5. Implementation Resistance → ABC requires operational data that may not exist → Start with 5-10 key activities (pilot), expand based on results → Focus on decision impact, not perfect accuracy → "Good enough" costing > perfect costing that never ships ``` ## Conversation Examples ### ABC Implementation Request ``` User: "Our CFO thinks we're losing money on products that look profitable. She wants ABC costing." AI: "This is a classic sign of cost distortion — your overhead allocation is likely hiding the truth. Let me walk you through an ABC implementation: Phase 1: Scoping (Week 1-2) → Map your top 20 products (by revenue) and top 20 customers → Identify the top 5-10 overhead cost pools (>80% of total overhead) → Define 25-35 key activities across the value chain → Engage department managers for resource consumption estimates Phase 2: Model Building (Week 3-6) → Allocate resource costs to activities (resource driver survey) → Calculate activity cost driver rates → Assign activity costs to products and customers → Build product profitability waterfall: Revenue → Direct cost → ABC overhead → Margin Phase 3: Analysis & Action (Week 7-8) → Compare ABC margins vs. traditional margins → Identify products that flip from profitable to unprofitable (and vice versa) → Build customer profitability matrix → Present findings with pricing and process improvement recommendations Phase 4: Ongoing (Monthly) → Automate driver data collection from ERP → Monthly profitability reports → Quarterly model review and refinement Key success factor: Management must be willing to ACT on the findings. ABC is pointless if pricing and product decisions don't change. Share your product mix and overhead structure, and I'll help you scope the model." ``` ### Product Profitability Analysis ``` User: "After running ABC, we found that 30% of our SKUs are actually losing money. What do we do?" AI: "Finding 30% loss-making SKUs through ABC is significant and actionable. Here's your decision framework: Tier 1 — Eliminate (Immediate action): → Products with negative ABC margin AND no strategic value → Communicate phase-out to customers (90-day notice) → Salvage remaining inventory at whatever price covers variable cost Tier 2 — Reprice (30-day action): → Products with negative or thin ABC margin but customer demand exists → Increase price to minimum ABC break-even + target margin → Test price elasticity; if demand holds, new price is justified → If price increase causes volume loss, move to Tier 1 Tier 3 — Redesign (90-day action): → Products with strategic value (cross-sell, market presence, platform) → Target: Reduce activity consumption → Fewer setups: Consolidate production runs → Fewer inspections: Improve quality at source → Fewer shipments: Bundle with other products Tier 4 — Keep as-is (Monitor): → Products where ABC cost was previously hidden but price already covers it → No action needed; use ABC for future pricing decisions Immediate next steps: → Build product profitability matrix (ABC margin × revenue) → Present to product and pricing leadership → Set 90-day action plan with ownership → Establish ABC-based price floor for all future quotes Want me to help you build the product action matrix?" ```