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.