SCMANA Practical Workbooks
Use these Excel workbooks alongside the related SCMANA guides to practise calculations, scoring, KPI analysis and operational decision-making. Start with the relevant learning path, read the guide, then download the workbook from the article.
Start with the SCMANA Learning Paths →
Procurement & Sourcing
- Supplier Performance Scorecard
- Supplier Risk Assessment Workbook
- Supplier Lead-Time & Reliability Workbook
- TCO Supplier Comparison
- Procurement Savings Calculator
- P2P KPI Calculator
Inventory & Planning
- Demand Forecasting Calculator
- S&OP Reconciliation Workbook
- Inventory KPI Calculator
- EOQ & Holding Cost Calculator
- FSN Inventory Analysis
- Inventory Aging & Slow-Moving Stock Dashboard
- ABC + VED/VEN Inventory Analysis
- Safety Stock & Reorder Point Calculator
- Bullwhip Effect Calculator
Logistics & International Trade
- Transport Mode Comparison Workbook
- Freight Cost Calculator
- Landed Cost Calculator
- Import Customs Pre-Arrival Checklist
- Demurrage, Detention & Storage Tracker
Operations & Warehousing
- Warehouse Capacity & Productivity Workbook
- Cross-Docking Suitability Score
- Supply Chain Cycle Time Calculator
- OTIF & Perfect Order KPI Calculator
- Warehouse Location Weighted Scoring
- Reverse Logistics Cost & Recovery Workbook
Risk, Resilience & Sustainability
Process, Quality & Improvement
- Pareto Analysis Calculator
- SIPOC + Constraints & Measures Template
- A3 Root Cause Problem-Solving Workbook
- VOC to CTQ Template
- Kano Model Classification Workbook
- Variation Analysis Calculator
- SPC Control Chart Calculator
- FMEA RPN Template
Each linked guide contains its workbook download section and explains how to use the calculation, framework or KPI in context.
