Winerim
Management guide

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. 1.The silo problem
  2. 2.The 4 pieces and how they connect
  3. 3.List โ†’ Stock
  4. 4.Stock โ†’ Sales
  5. 5.Sales โ†’ Margin
  6. 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.

Without crossing data, decisions are partial.

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.

Stock supports the list. Sales are the result. Margin is the consequence.

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 on the list implies a purchasing decision and financial commitment.

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.

Analyse my list for free

4. Stock โ†’ Sales: rotation as the bridge

Stock is a financial resource that must generate return.

Rotation connects stock to sales.

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.

What matters is real margin.

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

When the four pieces connect, management shifts from reactive to proactive.

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.