Category Sourcing Plan Template

1. Category overview

• Category name: (e.g., Fresh produce — leafy greens)
• Category owner: (name & role)
• Scope: products included / excluded, geographies, formats
• Business drivers: cost reduction, improved quality, reduced stockouts, supplier consolidation, sustainability goals
• Review frequency: quarterly / biannual / annual

2. Spend history & baseline

Collect the last 12 months (preferably 24) of data and calculate trends.

• Total annual spend: $______
• Spend by supplier (last 12 months):
  1. Supplier A — $______ (% of category)
  2. Supplier B — $______
  3. Supplier C — $______
• Volume & price trends: note major price spikes, volume seasonality, and any one-off events
• Current contract status: active / expiring date / auto-renewal / notice period
• Current average unit cost: $______ (and variance)
• Key cost drivers: raw material, freight, packaging, duties, waste)

3. Supplier map & concentration analysis

Map suppliers by percent spend and criticality. Identify single-source risks and top concentration points.

• Top 3 suppliers by spend: ______, ______, ______
• Percent spend with single supplier: ____%
• Critical suppliers (where failure causes major disruption): list and why
• Supplier dependency heatmap (qualitative): High / Medium / Low

4. Supplier tiering & target relationship model

Define clear tiers and what behavior you expect from each.

• Strategic / Preferred: long-term partnership, joint improvement programs, forecast sharing, better pricing in exchange for volume/commitment
• Approved / Core: reliable performance, contracted terms, regular review
• Tactical / Spot: used for short-term buys, high flexibility, limited commitment
• Disqualified: suppliers not meeting minimum standards

Assign current suppliers to tiers and the target tier for the next 12 months.

5. Supplier scorecard (sample)

Use consistent scoring (e.g., 1–5) and weights to compare suppliers objectively.

1. Cost competitiveness (weight 25%) — price vs market
2. Quality & specification compliance (20%) — defect rate, complaints
3. On-time delivery / lead time (15%)
4. Capacity & scalability (10%)
5. Supply continuity & single-source risk (10%)
6. Responsiveness & communication (10%)
7. Compliance & certifications (5%) — food safety, traceability
8. Sustainability / ethics (5%)

Example scoring row to copy into your spreadsheet:

Interpretation: higher score = better strategic fit. Use scores plus commercial levers to set actions.

6. Alternative sourcing & mitigation options

List practical alternatives to reduce risk and cost variability.

• Dual sourcing: identify potential second suppliers and lead time to onboard
• Local sourcing alternatives (reduce freight and supply chain risk)
• Ingredient substitutions with equivalent quality / cost
• Inventory buffers / safety stock levels and their cost trade-offs
• Forward purchase contracts, hedging, or longer-term fixed-price agreements
• Supplier consolidation where buying power improves pricing

7. Seasonality & risk assessment

Identify timing and likelihood of supply interruptions and seasonal price moves.

• Seasonal peak months: list
• Key supply chain risks: weather, crop cycles, shipping, labor strikes, geopolitical
• Supplier financial health indicators: payment terms, recent ownership changes
• Regulatory or compliance risk: label changes, import restrictions
• Risk mitigation rating (High / Medium / Low) and responsible owner

8. Target KPIs

Define a small set of measurable KPIs tied to outcomes. Attach baseline and target values.

• Target annual cost savings (%): baseline ____ → target ____
• Supplier fill rate (on-time, complete): baseline ____% → target ____%
• Quality defect rate (per 1,000 units or deliveries): baseline ____ → target ____
• Days of inventory (or days cover): baseline ____ → target ____
• Number of strategic suppliers (consolidation target): baseline ____ → target ____
• Time to onboard alternate supplier: baseline ____ days → target ____ days

9. Sourcing timeline and actions (12 months)

List concrete actions, owners, milestones and target dates. Example layout:

1. Data validation: confirm spend & contract dates — Owner: Procurement Analyst — Due: YYYY-MM-DD
2. Supplier scorecard assessments completed — Owner: Category Manager — Due: YYYY-MM-DD
3. Issue RFI / RFP for key bundles — Owner: Sourcing Lead — Due: YYYY-MM-DD
4. Negotiate strategic agreements with Supplier A — Owner: Procurement Director — Due: YYYY-MM-DD
5. Onboard secondary supplier for critical SKU — Owner: Operations Manager — Due: YYYY-MM-DD
6. Implement monthly supplier performance reviews — Owner: Category Owner — Start: YYYY-MM

10. Implementation checklist & governance

• Executive sponsor assigned: ______
• Category owner approval: ______
• Cross-functional stakeholders briefed (Ops, Culinary, Finance): list
• Contract review with legal for new terms: done / pending
• Onboarding plan for new suppliers including quality tests: attached / planned
• Monthly review cadence and escalation path for supplier issues

11. Appendix — practical artifacts

Supplier interview / RFI questions (examples)

• What are your minimum lead times for order sizes of X, Y, Z?
• What is your usual fill rate over the past 12 months?
• Describe your food safety certifications and traceability capabilities.
• How would you support us in a surge or supply disruption?
• What price protection or volume discount options do you offer?

Data sources & definitions

• Spend data = AP ledger + PO matching. Exclude one-off capital items unless they are part of recurring category spend.
• On-time delivery = deliveries meeting agreed delivery window and quantities.
• Quality defect rate = rejects or remakes attributable to supplier per 1,000 units.

Sample scoring weight matrix

Adjust weights to reflect category priorities (e.g., quality-heavy categories should weight quality more).

12. Notes & versioning

Version: 1.0 — Created: YYYY-MM-DD — Last updated: YYYY-MM-DD — Owner: ______