All work
Retail & FMCG · Professional experience
Promotional Pricing & Invoice Analysis
Comparing promotional selling prices and supplier invoice costs to expose margin exposure.
Operational· pending verificationEmployer-owned — experience summary only
Publication draft: status, contribution and technical details require contributor approval. The architecture and implementation notes below are illustrative, not verified accounts of a client deployment.
Context & challenge
Promotions were priced against expected supplier costs that did not always match what was invoiced.
Objectives
- Identify promotions with unexpected margin outcomes
- Support supplier claims with evidence
Solution approach
- Joining promotional price files with invoice lines by item and period
- Variance thresholds and exception lists
Architecture
- Promo calendar
- Invoice lines
- Join & normalise
- Margin calc
- Variance report
Simplified and anonymised. No private infrastructure details are published.
Important technical decisions
- Variance measured per unit after pack normalisation
Operational considerations
- Late invoices
- Mid-promotion price changes
Results
Results pending verification. We only publish outcomes that have been confirmed.
Lessons learned
- Most 'pricing' problems are really unit-of-measure problems.