Finance AI Skill

Spend Analysis

Analyze organizational spending patterns by category, supplier, department, and business unit to identify savings opportunities, maverick spend, and consolidation potential. Use when performing spend cube analysis, categorizing spend, identifying supplier c...

Spend Analysis

Comprehensive analysis of organizational spending to drive procurement optimization, cost savings, and supplier strategy.

Workflow

Spend Analysis Process

Trigger: Quarterly deep analysis; monthly incremental updates; ad-hoc for specific categories:

  1. Data collection: Extract from ERP, P-Cards, procurement system, contract database. Include PO-based, non-PO, P-Card, travel, professional services. Normalize supplier names; standardize GL mappings; convert currency.
  2. Spend categorization: Apply taxonomy (UNSPSC or custom); 3-level hierarchy; AI-assisted categorization; manual review of low-confidence items.
  3. Spend cube analysis: Build multi-dimensional view (category × supplier × department × region × time). Identify top suppliers, categories, and spend concentrations.
  4. Savings opportunity identification: Consolidation, renegotiation, substitution, process improvement, tail spend rationalization.
  5. Maverick spend detection: Identify purchases outside contracted suppliers or approved catalogs. Flag by department and category.
  6. Benchmarking: Compare spend ratios to industry benchmarks; identify outliers and improvement opportunities.
  7. Action planning: Prioritize opportunities by savings potential, implementation effort, and strategic alignment.
  8. Monitoring: Track spend under management, savings realization, maverick spend reduction over time.

Spend Data Collection Framework

SPEND DATA SOURCES AND COVERAGE
=================================

Data Sources:
  Purchase Orders (ERP):
    Coverage: 60–80% of total spend (organized procurement)
    Quality: High (structured data, supplier master, GL codes)
    Fields: Supplier, PO number, line items, quantities, prices, delivery dates
    Limitation: Excludes non-PO purchases, P-cards, informal orders

  Purchase Cards (P-Card):
    Coverage: 5–15% of total spend (convenience, low-value)
    Quality: Medium (merchant name, amount, date; limited line-item detail)
    Fields: Cardholder, merchant, amount, date, category (auto-coded)
    Limitation: Merchant names need normalization; no PO matching

  Invoice Data (AP):
    Coverage: 80–100% of total spend (all invoiced purchases)
    Quality: High (full invoice detail, supplier, amounts, GL codes)
    Fields: Supplier, invoice number, line items, amounts, tax, PO reference
    Limitation: May include non-procurement invoices (customer credits, refunds)

  Travel and Expense (T&E):
    Coverage: 2–8% of total spend (travel, meals, incidentals)
    Quality: Medium (receipt data, category, business purpose)
    Fields: Vendor, amount, date, category, business justification
    Limitation: Receipt quality varies; policy compliance issues

  Contract Database:
    Coverage: Complementary (contract value vs. actual spend)
    Quality: High (negotiated rates, terms, volume commitments)
    Fields: Supplier, contract value, terms, renewal dates, volume targets
    Limitation: May not reflect actual spend; contract compliance tracking needed

  Other Sources:
    - Professional services (consulting, legal, accounting)
    - Real estate (lease payments, facilities management)
    - IT infrastructure (cloud, software licenses, hardware)
    - Marketing and advertising (agency spend, media buys)
    - Insurance (premiums, claims)

Target: > 95% of total spend captured and categorized
Reality: 85–95% achievable; 5–15% "dark spend" (uncaptured, misclassified)

Spend Categorization Taxonomy

SPEND CATEGORY HIERARCHY (Custom Taxonomy)
============================================

Level 1: Direct Spend (typically 40–70% of total)
  1.1 Raw Materials
    1.1.1 Metals and Alloys
    1.1.2 Chemicals and Polymers
    1.1.3 Electronic Components
    1.1.4 Packaging Materials
  1.2 Components and Subassemblies
    1.2.1 Mechanical Components
    1.2.2 Electrical Components
    1.2.3 Software Components (for product)
  1.3 Contract Manufacturing
    1.3.1 EMS (Electronic Manufacturing Services)
    1.3.2 Contract Assembly
    1.3.3 Packaging and Kitting

Level 2: Indirect Spend (typically 30–60% of total)
  2.1 IT and Technology
    2.1.1 Hardware (servers, laptops, networking)
    2.1.2 Software Licenses (SaaS, perpetual, maintenance)
    2.1.3 Cloud Infrastructure (AWS, Azure, GCP)
    2.1.4 IT Services (managed services, consulting, support)
  2.2 Professional Services
    2.2.1 Consulting (strategy, operations, IT)
    2.2.2 Legal (outside counsel, IP, compliance)
    2.2.3 Accounting and Audit (external audit, tax advisory)
    2.2.4 Recruitment and Staffing (agency, temp labor)
  2.3 Facilities and Operations
    2.3.1 Office Supplies and Furniture
    2.3.2 Maintenance and Repair (MRO)
    2.3.3 Utilities (electricity, water, gas, internet)
    2.3.4 Janitorial and Building Services
  2.4 Marketing and Advertising
    2.4.1 Digital Advertising (Google, Meta, LinkedIn)
    2.4.2 Traditional Media (TV, radio, print)
    2.4.3 Events and Conferences
    2.4.4 Creative and Design Services
  2.5 Travel and Entertainment
    2.5.1 Air Travel
    2.5.2 Hotels and Lodging
    2.5.3 Ground Transportation
    2.5.4 Meals and Entertainment
  2.6 Insurance
    2.6.1 Property and Casualty
    2.6.2 D&O and E&O
    2.6.3 Cyber Insurance
    2.6.4 Workers' Compensation

Level 3: Tail Spend
  - Individual suppliers < $10,000 annual spend
  - Typically 5,000–20,000 suppliers representing 10–20% of spend
  - High management cost relative to spend value
  - Consolidation opportunity: Preferred supplier programs, catalog buying

Spend Analytics and Savings

Spend Under Management Framework

SPEND UNDER MANAGEMENT METRICS
================================

Spend Under Management (SUM):
  Definition: Spend routed through formal procurement process
  (PO-based, contracted, or managed category)

  Target: > 85% of total spend
  Industry benchmark: 70–90% (mature procurement organizations)

  Calculation:
    SUM = (PO-based spend + Contracted non-PO spend + Managed categories) / Total spend

  By maturity level:
    Developing:  50–65% SUM (ad-hoc procurement, limited contracts)
    Maturing:    65–80% SUM (category management, some contracts)
    Mature:      80–90% SUM (comprehensive category management)
    Leading:     90%+ SUM   (full procurement integration, automated)

Maverick Spend:
  Definition: Spend outside contracted suppliers or approved processes
  Target: < 5% of total spend
  Causes: Urgent needs, lack of awareness, poor contract coverage, system barriers

  Detection methods:
    - PO matching: Non-PO invoices = potential maverick spend
    - Supplier matching: Invoice supplier ≠ contracted supplier for category
    - P-card analysis: Merchant not in approved vendor list
    - GL code analysis: GL codes typically procured through contracts

  Reduction strategies:
    - Expand contracted category coverage (identify gaps)
    - Simplify procurement process (reduce friction)
    - P-card program with approved merchant lists
    - Manager training and accountability
    - System enforcement: Purchase requisition required for amounts > $500

Savings Tracking:
  Types of savings:
    Hard savings: Direct cost reduction (price negotiation, consolidation)
    Soft savings: Avoided cost increases, process efficiency, risk reduction
    Strategic savings: Innovation, supplier development, sustainability

  Calculation:
    Hard savings = (Old price − New price) × Actual volume
    Avoided cost = (Market increase % − Contract increase %) × Volume

  Tracking:
    - Savings pipeline: Identified but not yet realized
    - Savings realized: Contracted and spend occurring at new rate
    - Savings at risk: Volume not achieving contracted rate; contract expiring
    - Annual report: Total savings as % of total spend (target: 3–8%)

Supplier Consolidation Opportunities

SUPPLIER CONSOLIDATION ANALYSIS
=================================

Step 1: Identify consolidation candidates
  - Top 20 suppliers by spend (typically 60–80% of total spend — Pareto principle)
  - Multiple suppliers for same category (e.g., 5 laptop vendors → 1 preferred)
  - Suppliers with overlapping capabilities
  - High transaction cost suppliers (small orders, frequent POs)

Step 2: Evaluate consolidation feasibility
  Criteria:
    - Volume leverage: Combined spend with remaining suppliers
    - Service capability: Can consolidated supplier meet all requirements?
    - Geographic coverage: Can serve all locations/regions?
    - Risk concentration: Avoid single-source dependency for critical categories
    - Contract terms: Existing contracts, renewal dates, termination clauses

Step 3: Calculate savings potential
  Price leverage:
    - Volume discount: 5–15% savings from combined volume
    - Negotiation power: 3–8% from improved bargaining position
  Process efficiency:
    - Reduced PO processing: 10–20% fewer transactions
    - Reduced AP processing: Fewer invoices, fewer suppliers to reconcile
    - Reduced management time: Fewer supplier relationships to manage

Step 4: Implementation plan
  - Transition timeline: 30–90 days (depending on complexity)
  - Dual-sourcing period: 30 days overlap (risk mitigation)
  - Communication: Department heads notified; end-users trained
  - System updates: Supplier master, approved vendor lists, catalog updates
  - Monitoring: Post-consolidation spend tracked for 90 days

Spend Benchmarking

SPEND BENCHMARKS BY COMPANY SIZE
==================================

As % of Total Revenue:

  IT and Technology:
    Startup (<$5M revenue):    15–25% (heavy tech investment)
    SMB ($5M–$50M):            8–15%
    Mid-market ($50M–$500M):   5–10%
    Enterprise ($500M+):        3–7%

  Professional Services:
    Startup:                    8–15%
    SMB:                        5–10%
    Mid-market:                 3–7%
    Enterprise:                 2–5%

  Marketing and Advertising:
    Startup:                    10–20%
    SMB:                        8–15%
    Mid-market:                 5–10%
    Enterprise:                 3–8%

  Travel and Entertainment:
    Startup:                    3–8%
    SMB:                        2–5%
    Mid-market:                 1.5–4%
    Enterprise:                 1–3%

  Facilities and Operations:
    Startup:                    2–5%
    SMB:                        1.5–4%
    Mid-market:                 1–3%
    Enterprise:                 0.5–2%

  Total Indirect Spend:
    Startup:                    30–50% of revenue
    SMB:                        20–35% of revenue
    Mid-market:                 12–25% of revenue
    Enterprise:                 8–15% of revenue

Savings potential by category:
  IT hardware/software:     10–20% (through consolidation, enterprise agreements)
  Professional services:    15–25% (rate negotiation, statement of work optimization)
  Travel:                   10–15% (corporate rates, booking compliance)
  Office supplies:          15–25% (catalog consolidation, volume pricing)
  Marketing/media:          5–10% (agency negotiation, media buying optimization)
  Insurance:                10–15% (broker competition, risk engineering)

Edge Cases

Integration Points