Flagship 03 · Decision infrastructure
Commercial Intelligence
Two locally built applications for the economics of the business - because the logic is the asset, and renting it from SaaS buys neither flexibility nor understanding.
Measured
Forecast versus actual generated net revenue. Quarterly forecasts landed ~6% below actual.
Benchmark of the invoice-ingestion pipeline.
Cost, VAT, shipping, price and advertising context per SKU.
Context
The economics lived in spreadsheets
Pricing decisions ran on scattered information: supplier invoices in PDFs, advertising performance inside disconnected Google platforms, margin math in spreadsheets that drifted out of date. Revenue planning was intuition dressed up as a forecast.
The business didn't lack data. It lacked one place where cost, price, margin and cash expectations meet.
Decision
Build local, own the logic
The obvious answer was a SaaS BI stack. The chosen answer was two locally deployed internal applications. The data is sensitive, the logic is the competitive asset, and the scale is modest - ongoing rent for generic tooling buys neither flexibility nor understanding. Complexity should be earned; here, a local application is the simpler system that fully fits the problem.
System
Not dashboards - decision infrastructure
A dashboard shows you a number. These systems hold the logic that produces the number - inspectable, testable, and validated against what actually happened.
- Input
- Processing
- Application
- Scenario gate
- Human judgment
Margin & Pricing Intelligence
Parses supplier PDF invoices at scale, computes current margin per SKU, recommends prices, and models pricing and margin scenarios with advertising-spend context. Mathematical optimization runs operationally. Inspect the system →
Revenue & Cash-Flow Intelligence
Mathematical forecasting for revenue planning, seasonal expectations, cash-flow thinking and scenario analysis - validated against actual subsequent net revenue. A natural-language querying layer exists as an MVP. Inspect the system →
Ownership
Who owns what
I owned
- Both applications designed & built end to end
- Data ingestion
- Modeling
- Application & deployment
AI / system executed
- Mathematical optimization runs operationally
- Invoice parsing & normalization
Outcome
What changed, measured
Measured: the forecasting system's full-year prediction landed approximately 2.1% below actual generated net revenue; quarterly forecasts landed approximately 6% below actual. The pricing system has informed real pricing decisions and contributed to improved margins.
Not claimed: no invented margin percentage. The pricing claim is stated without a number because an honest one doesn't exist.
Reflection
Why this architecture holds
The value was never the interface; it was forcing the economics of 1,153 SKUs into explicit, inspectable logic. A forecast that is 2.1% off for a full year is useful precisely because you can see how it reasons. The natural-language layer stays an MVP until it earns more - the same discipline described in Complexity should be earned.
Related