How to connect wine list, stock, sales and margin
List, stock, sales and margin are four pieces of the same puzzle. When connected, decisions become clear.
Contents
- 1.The silo problem
- 2.The 4 pieces and how they connect
- 3.List โ Stock
- 4.Stock โ Sales
- 5.Sales โ Margin
- 6.The complete cycle
1. The silo problem
The list in a design doc, stock in a spreadsheet, sales in the POS and margin in the controller's report.
The list is designed without sales data.
Stock is managed without rotation data.
Sales are viewed without margin data.
Cost of this disconnection: 5-15% of wine revenue.
2. The 4 pieces and how they connect
The list defines what you sell.
List โ Stock: design considering what you can stock.
Stock โ List: if you can't replenish, don't feature it.
Sales โ List: data tells you what works.
Margin โ Purchasing: guides what to buy and how much.
3. List โ Stock: the purchasing flow
Every reference is a stock commitment.
Calculate minimum stock for 60-90 days.
Calculate total cellar capital needed.
Prioritize reliable suppliers with frequent deliveries.
Is your wine list performing as it should?
We'll analyse your list and show you concrete improvement opportunities in margin, rotation and average ticket.
4. Stock โ Sales: rotation as the bridge
Stock is a financial resource that must generate return.
Rotation target: 8-12 per year.
Rotation < 4: evaluate whether it should stay.
Wines with most stock should be in visible positions.
Inventory should be reviewed alongside sales data.
5. Sales โ Margin: real profitability
High revenue doesn't guarantee profitability.
Calculate real margin monthly.
Compare with theoretical margin: > 5% gap = investigate.
Analyse margin by reference, not just overall.
Margin contribution: unit margin ร units sold.
6. The complete cycle: integrated management
Step 1: Review monthly scorecard.
Step 2: Identify anomalies.
Step 3: Decide actions.
Step 4: Execute changes.
Step 5: Measure impact in next scorecard.
Related tools
Related guides
Frequently asked questions
Next step
Connect everything with Winerim
Winerim integrates list, stock, sales and margin in a single panel.
Diagnosis with real improvement opportunities. No cost.