TRACKS €2.3M IN ANNUAL SAVINGS PROCUREMENT EXCEL

Procurement Savings Tracker

Excel-based tracker that quantifies, classifies, and reports procurement savings initiatives — hard savings, soft savings, and cost avoidance — with RAG status, initiative pipeline stages, and a cumulative waterfall against annual target.

Project Overview

⚑ Problem

Fragmented Savings Reporting

Procurement teams log negotiated discounts, specification changes, and demand reductions in disconnected spreadsheets — one per category, per owner, or per quarter. Finance cannot reconcile savings to the P&L, and CPOs cannot report a credible annual number to the CFO without a three-week data-gathering exercise.

⚙ Solution

Unified Excel Savings Tracker

A structured Excel workbook with standardised savings classification (hard/soft/cost avoidance), initiative pipeline stages (Identified → In Progress → Realised → At Risk), category breakdown, owner assignment, quarterly phasing, and a cumulative waterfall visualisation. Finance-ready with verified/unverified flags and CFO sign-off tracking.

✓ Findings

€2.3M Realised, €890K In Pipeline

40 initiatives tracked across 6 categories. €2.31M in verified savings realised against a €2.5M annual target (92% attainment). Logistics (€620K) and Packaging (€510K) are the top-performing categories. 8 initiatives totalling €890K remain In Progress — on track to exceed target by Q4.

Savings Initiative Pipeline

Dataset Explorer

Savings Analysis Charts

Cumulative Savings Waterfall — Initiatives

Savings by Category (€K)

Savings Type Breakdown

Quarterly Savings vs Target (€K)

Realised vs Pipeline by Category

Saving % by Initiative

Initiative Register

INITIATIVE	CATEGORY	TYPE	BASELINE (€K)	NEGOTIATED (€K)	SAVING (€K)	SAVING %	STATUS	OWNER	QUARTER	RAG	VERIFIED

Annual Savings Forecast

Cumulative Savings vs €2.5M Annual Target — 12-Month View

Company Advice

💡 Recommendations for Procurement Leaders

Hard savings need CFO sign-off and a clear baseline to be P&L-credible. Agree the baseline calculation methodology with Finance before negotiation starts — not after — to avoid disputes at reporting time.
Soft savings (process improvement, specification changes) need methodology agreement upfront. Without a signed-off calculation basis, Finance will reject them at year-end. Document the counterfactual explicitly.
Never mix cost avoidance with hard savings in the headline number. Avoidance is real value but it doesn't appear in the P&L — treating them the same destroys credibility with CFOs and auditors.
Run a monthly pipeline review: move stalled "In Progress" initiatives to "At Risk" within 6 weeks of no progress. A bloated In Progress column is a lagging indicator of a savings programme losing momentum.
Assign every initiative an owner and a due date — savings with no owner close at a 3× lower rate. Track owner-level performance as a procurement team KPI, not just a project metric.
Build the tracker in Excel using structured tables and named ranges so Finance can pull data directly via Power Query — this removes the manual consolidation step that costs 2+ days every reporting cycle.

Key Takeaway: A procurement savings tracker is only as credible as its classification discipline. One misclassified cost avoidance in the hard savings column erodes trust in the entire programme — rigour in methodology is the foundation of a savings culture.