Spend Cube & Supplier Concentration Analyzer

The problem this kills

Leadership keeps asking the same question: "Where is our money actually going, and how exposed are we?" And every time, you rebuild the same monster spreadsheet by hand - pivoting spend by supplier, by category, by department, by quarter, then squinting to figure out which categories ride on a single supplier and what share of spend sits in your top five.

It takes a day, it's stale the moment you finish it, and nobody can slice it themselves without breaking your formulas. Worse, the scary stuff - a category that's 100% single-sourced, a "tail" of hundreds of tiny suppliers, a currency mix that quietly understates a region - is buried where it's easy to miss.

This plan gives you the spend cube as a living tool instead of a one-off file.

What you'll build

A small, private web app - just for your team - that:

• Imports your classified spend (supplier, category, department, period, amount) from a CSV or Google Sheet, with a transaction-id duplicate guard so the same line never lands twice.
• Normalizes currency to one reporting currency so totals are honest across regions.
• Slices interactively by supplier, category, department, and time - the spend cube leadership keeps asking for.
• Computes concentration metrics: % of spend in your top 5 (and top 10) suppliers, single-source categories, and a strategic-vs-tail supplier split.
• Flags risk: categories sourced from a single supplier, and over-dependency on any one vendor.
• Puts a human in charge: an analyst reviews the analysis, confirms the categorization looks right and outliers are explained, and only then publishes a snapshot.
• Shares it: a read-only dashboard for leadership, plus CSV/PDF export and a scheduled email of the latest published snapshot.

What's inside the Implementation Plan

• It starts by interviewing you about your business. Before it writes a line of code, the plan has the AI agent ask you about your current spend process, the systems and spreadsheets you pull from, your exact field names and category/supplier conventions, your typical and peak data volumes, your approval rules, and your messy edge cases. It reflects a short tailored spec back, gets your thumbs-up, and only then builds - so the tool fits how you work, not a generic template.
• A clear definition of done so you know exactly when you're finished.
• Step-by-step build instructions, each ending with a ready-to-paste prompt for your AI agent.
• A simple architecture diagram so you can see how the pieces fit.
• Built-in currency normalization, concentration math, and risk flags.
• A "No API yet?" fallback that uses a Google Sheet / CSV as the source and exports clean snapshots - so you can ship this today, with zero integration work.

The governance it includes (this is the point)

This isn't a throwaway script. The plan bakes in the controls leadership expects before they trust a number:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own spend data.
• A complete audit trail - who imported what, who edited a classification, who published which snapshot, and when.
• A human-in-the-loop approval gate - the tool drafts the analysis, but nothing reaches leadership until an analyst reviews and publishes the snapshot.
• Duplicate guards - transaction id for imported lines, and snapshot id + period for published views, so nothing is double-counted or double-published.

Who it's for

Procurement analysts and category managers who need a quick, sliceable picture of spend and supplier concentration - and who are tired of rebuilding the same pivot table every time leadership asks. If you can keep a spreadsheet, you can build this.

You've got this - paste the first prompt and let the agent interview you.