In this tutorial, I'll show you exactly how to use the SCMDOJO Spend Analytics Tool. A ready-to-use Excel template that turns your raw procurement data into a fully structured spend dashboard in minutes.
Whether you're a procurement manager preparing for a supplier negotiation, a CPO presenting to the board, or a consultant running a rapid spend diagnostic, this tool gives you instant visibility across suppliers, categories, regions, buyers, and delivery performance.
📥 Download the Spend Analytics Tool here:
─────────────────────────────
WHAT YOU'LL LEARN IN THIS VIDEO
─────────────────────────────
✅ How to prepare and paste your ERP/PO data into the template
✅ How to extend the pre-built formulas to match your data
✅ How to set a custom date range and refresh the entire workbook
✅ How to read the supplier spend, category, and regional dashboards
✅ How to use the OTD KPI sheet before a supplier negotiation
✅ How to use the payment terms analysis for working capital insight
✅ How to customise the dashboard with your company name and logo
─────────────────────────────
WHAT'S INSIDE THE TOOL
─────────────────────────────
📊 12 pre-built dashboard sheets
🏭 Spend by Supplier, Category, Region & Buyer
🚚 On-Time Delivery (OTD) KPI tracker — early, late, on-time
💳 Payment Terms analysis
🏆 Supplier Scorecard pivot
📅 Custom date range filter
📋 Step-by-step instruction sheet
🎨 Fully customisable — add your logo and company name
Works with SAP, Oracle, and any ERP that exports to Excel or CSV.
─────────────────────────────
WHO THIS IS FOR
─────────────────────────────
→ Procurement Managers & Category Managers
→ VP / Head of Procurement / CPO
→ Supply Chain Analysts
→ Procurement Consultants
─────────────────────────────
ABOUT DR. MUDDASSIR AHMED
─────────────────────────────
I'm the Founder & CEO of SCMDOJO — the world's largest independent supply chain learning platform — and a supply chain practitioner with 19+ years of experience at Eaton, Volvo Cars, and Bridgestone across the UK, EMEA, and Southeast Asia.
Ranked as a Top 10 Global Supply Chain Influencer by Supply Chain Digital.
PhD in Management Science, Lancaster University. Six Sigma Black Belt.
─────────────────────────────
TIMESTAMPS
─────────────────────────────
0:00 — Introduction
0:45 — Overview of the 12 dashboard sheets
2:00 — How to prepare and paste your data
3:30 — Setting the date range filter
4:15 — Navigating the supplier spend dashboard
5:30 — Reading the category and regional breakdown
6:45 — Using the OTD KPI tracker
8:00 — Payment terms and supplier scorecard
9:15 — Customising for your organisation
10:00 — Final tips and where to download
─────────────────────────────
#SpendAnalytics #ProcurementTools #SupplyChain #ExcelTemplate #ProcurementAnalytics #SCMDOJO #SpendAnalysisTool #CPO #ProcurementManager #SupplyChainManagement
─────────────────────────────
Join this channel to get access to perks:
Visit :