01
Associated Wholesale GrocersPracticum · Remote, USAAug 2025 – Dec 2025
Pricing & cost pass-through
Data analytics practicum for Associated Wholesale Grocers
Problem
This practicum for a $1.9B wholesaler covered two questions: where mispriced SKUs put sales at risk, and how supplier cost changes flow through to prices.
Approach
- Python price-gap model on 4,800+ item-quarter observations, with price elasticity measured across 91 SKUs.
- Cost pass-through model on 2,300+ supplier cost changes, split by private-label and national brands.
- Tariff-exposure overlay on import-sensitive categories.
Impact
- Flagged $21.4M in at-risk sales from mispriced SKUs.
- Private-label brands absorbed 74–89% of cost shocks; national brands passed them through nearly in full.
- Quantified a 6% cost spike in import-sensitive categories.
Trade-off
The private-label result is a range (74–89%) and the national-brand result is qualitative (near-full pass-through), so the analysis shows the direction of the gap, not a single precise figure.
- Python
- Pandas
- Price Elasticity Modeling
- Power BI
- Excel
Share of supplier cost shocks absorbed
2,300+ supplier cost changes. Select a row for detail.
Absorbed 74–89% of cost shocks across 2,300+ supplier cost changes.
The national-brand band shows direction only, not a measured value.
$21.4M
at-risk sales flagged
6%
cost spike, import-sensitive categories
91
SKUs with measured elasticity




































