13.3 Spend Analysis for Category Strategies (Task 1-F-3)

Spend Analysis for Category Strategies (Task 1-F-3)

Exam focus: ISM Task 1-F-3 asks you to conduct spend analysis to determine strategies for specific categories. Expect roughly five scored questions on data cleansing and classification, Pareto concentration, addressable vs. non-addressable spend, and how spend profiles drive strategy—linking back to cost programs (1-F-1) and forward to savings tracking (1-F-4).

Spend analysis turns purchasing history into actionable intelligence: who we buy from, what we buy, how much we pay, where variance exists, and which levers can change outcomes. For category strategy, the output is not a pretty dashboard—it is a prioritized set of strategies matched to evidence.

Cleanse and Classify Before You Strategize

Raw ERP extracts lie in predictable ways. Before drawing strategy conclusions, cleanse and classify:

Cleansing typically includes:

• Normalizing supplier names (ABC Inc., ABC Incorporated, A.B.C. → one parent)
• Removing or flagging voids, credits, intercompany noise, and obvious duplicates
• Standardizing units of measure and currencies
• Fixing or flagging missing descriptions and mis-coded GL accounts
• Aligning ship-to / business-unit fields for site-level views

Classification maps transactions into a taxonomy (category → subcategory → item family) that matches how markets and suppliers work—not only how accounting coded them years ago. Poor classification creates fake “fragmentation” (one real category split across five GL buckets) or hides maverick spend inside “miscellaneous.”

Document cleansing rules and residual data quality so stakeholders trust the strategy narrative.

Pareto and Other Concentration Views

Pareto analysis (often the 80/20 rule) ranks suppliers, items, categories, or sites by spend and shows how much of the total sits in the top slice. Classic uses:

1. Top suppliers — candidates for strategic relationships, volume leverage, or risk reviews
2. Top items / SKUs — candidates for should-cost, spec standardization, or targeted RFPs
3. Tail spend — many small suppliers; candidates for catalogs, P-cards, spot-buy controls, or aggregator contracts
4. Sites / BUs — where price variance or maverick behavior concentrates

Pareto is a spotlight, not a strategy. The top 20% of suppliers by spend may include a strategic sole source that needs partnership—not a reverse auction. The tail may include critical safety specialists that should not be blindly consolidated.

Complement Pareto with:

• Price variance analysis on like items
• Contract coverage vs. off-contract share
• Number of suppliers per subcategory
• Demand trend and forecast reliability
• Landed-cost overlays for import-heavy categories

Addressable vs. Non-Addressable Spend

Addressable spend is spend that supply management can materially influence through sourcing, negotiation, demand management, specification, or process change within a planning horizon.

Non-addressable spend (sometimes called non-influencable in a given period) includes pools that cannot realistically be moved with normal supply levers—examples often cited in practice:

• Certain taxes, regulatory fees, or mandated payments
• Pass-through customer-directed buys with no substitution rights
• True one-time anomalies already completed
• Some intercompany charges outside category control

Organizations debate gray areas (e.g., utilities, rent, unique professional services). The exam point is conceptual: do not set cost-reduction targets on spend you cannot address, and do not inflate “opportunity” by counting non-addressable dollars as if an RFP will capture them. Revisit classification when policy or market conditions change—what was non-addressable may become addressable after a regulation or contract expires.

Matching Strategy to Spend Profile

Spend analysis informs category strategy; it does not replace market and risk analysis. Typical profile-to-strategy patterns:

• High spend, many capable suppliers, standardized specs → competitive leverage, price analysis heavy, catalog enablement, possible reverse auction
• High spend, few suppliers, high switching cost → cost analysis / should-cost, long-term agreements, joint cost reduction, design-to-cost
• Low spend, high transaction count (tail) → process simplification, preferred distributors, guided buying—not a full strategic negotiation for every PO
• Volatile commodity content → indexation, hedging coordination with finance, cost avoidance programs, inventory policy
• High quality/risk impact regardless of spend → dual source, qualification rigor, TCO over unit price

Use Kraljic-style thinking (value impact vs. supply risk) as a framing aid: leverage, strategic, bottleneck, and non-critical profiles suggest different plays. Pair with TCO: a “cheap” tail supplier that causes frequent expedites may be expensive in landed and process cost.

From Analysis to Category Strategy Decisions

A Task 1-F-3 work product typically answers:

1. How large is the category, and what share is addressable?
2. Where is concentration (Pareto) and where is harmful fragmentation?
3. What price variance and off-contract leakage exist?
4. Which subcategories need competition vs. collaboration vs. demand control?
5. What data gaps remain, and how will they be closed?

Scenario: Facilities MRO shows $14M spend across 90 suppliers. After cleansing, 12 legal entities collapse to 4 corporate parents. Pareto: top 8 suppliers = 70% of spend; 60 suppliers share the bottom 8%. Classification reveals “safety PPE” mixed with “janitorial.” Addressable run-rate is $12.2M after excluding mandated inspection fees. Strategy: national dual award on gloves/glasses (leverage + risk), aggregator catalog for true tail, should-cost workshop on a high-variance filter SKU, and a cost-avoidance track for an announced resin-driven price increase on trash liners.

Exam tip: if the stem says opportunity looks huge but data is unclean, the first move is cleanse/classify—not launch RFPs. If leadership wants a savings target on tax pass-throughs, flag non-addressable spend. If unit prices look fine but inbound costs differ by plant, bring landed cost into the strategy view.