Skip to content

virbahu/procurement-spend-analyzer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

1 Commit
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🀝 Procurement Spend Analyzer

Python 3.9+ MIT License procurement Production Ready PRs Welcome

Procurement spend analysis with category classification and savings ID

A Quantisage Open Source Project β€” Enterprise-grade supply chain intelligence


πŸ“‹ Table of Contents


πŸ“‹ Overview

Procurement Spend Analyzer addresses a critical challenge in modern supply chain management. This implementation combines rigorous academic methodology with production-ready Python code designed for enterprise deployment.

Based on: Professor Robert Monczka, Arizona State

Procurement spend analysis with category classification and savings ID. In today's volatile supply chain environment β€” marked by geopolitical disruptions, climate risks, demand volatility, and rapid digitization β€” organizations need tools that go beyond traditional spreadsheet-based analysis.

✨ Key Capabilities

  • Production-ready Python implementation with clean, extensible architecture
  • Academically grounded methodology from world-class research institutions
  • Configurable parameters for enterprise-scale operations (1K to 100K+ SKUs)
  • Comprehensive output metrics with sensitivity analysis and trade-off curves
  • API-ready design for integration with ERP, WMS, TMS, and planning systems
  • Fully transparent algorithms β€” no black boxes, every decision is explainable

πŸ—οΈ Architecture

flowchart LR A[πŸ“₯ Input Data] --> B[βš™οΈ Processing] B --> C[πŸ”’ Optimization] C --> D[πŸ“Š Results] D --> E[πŸ“‹ Actions] style C fill:#fff9c4 style E fill:#c8e6c9 
Loading

Process Flow

graph LR A[Input] --> B[Analyze] B --> C[Optimize] C --> D[Execute] D --> E[Monitor] E -->|Feedback| B style C fill:#fff9c4 
Loading

❗ Problem Statement

The Challenge

Supply chain procurement is a persistent operational challenge with direct impact on cost, service, and resilience:

Impact Area Without Optimization With Optimization Improvement
Cost Baseline 15-30% reduction Significant
Service Level 85-90% 96-99% +6-14 pts
Working Capital Over-invested Right-sized 20-40% freed
Decision Speed Days/weeks Minutes/hours 10-50x faster
Risk Exposure Reactive Proactive 60-80% fewer disruptions

The complexity compounds when you consider:

  • Scale: Thousands of SKUs Γ— hundreds of locations Γ— 365 days = millions of decisions per year
  • Uncertainty: Demand volatility, supply disruptions, lead time variability, price fluctuations
  • Dependencies: Upstream and downstream ripple effects across multi-tier networks
  • Constraints: Capacity limits, budget constraints, regulatory requirements, sustainability targets

"Supply chains compete, not companies. The supply chain that can sense, plan, and respond fastest β€” wins."


βœ… Solution Deep Dive

Methodology

This implementation follows a structured six-phase approach:

  1. Data Ingestion & Validation β€” Load operational data, validate completeness, handle missing values, detect outliers
  2. Exploratory Analysis β€” Statistical profiling, distribution analysis, correlation identification, pattern detection
  3. Model Construction β€” Build the core analytical model with configurable parameters and business rule constraints
  4. Solution Computation β€” Execute the algorithm with convergence monitoring and solution quality metrics
  5. Sensitivity Analysis β€” Systematic parameter variation to understand solution robustness and critical drivers
  6. Results & Deployment β€” Generate actionable outputs with clear recommendations and expected impact quantification

πŸš€ Quick Start

Prerequisites

Requirement Version Purpose
Python 3.9+ Runtime
pip Latest Package management
Git 2.0+ Version control

Installation

# Clone the repository git clone https://github.com/virbahu/procurement-spend-analyzer.git cd procurement-spend-analyzer # Create virtual environment (recommended) python -m venv .venv source .venv/bin/activate # Linux/Mac # .venv\Scripts\activate # Windows # Install dependencies pip install -r requirements.txt # Run python spend_analyzer.py

πŸ’» Code Examples

Basic Usage

from procurement_spend_analyzer import * # Run with default parameters result = main() print(result)

Advanced Configuration

# Customize for your environment # See source code docstrings for full parameter reference

πŸ“¦ Dependencies

numpy pandas 

πŸ“š Academic Foundation

Based on: Professor Robert Monczka, Arizona State



πŸ‘€ About the Author

Virbahu Jain β€” Founder & CEO, Quantisage

Building the AI Operating System for Scope 3 emissions management and supply chain decarbonization.

πŸŽ“ Education MBA, Kellogg School of Management, Northwestern University
🏭 Experience 20+ years across manufacturing, life sciences, energy & public sector
🌍 Global Reach Supply chain operations across five continents
πŸ“ Research Peer-reviewed publications on AI in sustainable supply chains

πŸ“„ License

MIT License β€” see LICENSE for details.

Part of the Quantisage Open Source Initiative | AI Γ— Supply Chain Γ— Climate

About

Procurement spend analysis with category classification and savings ID

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages