1.5 Inventory Control, Margin Analysis & Wine List Corrections

Inventory Control, Margin Analysis & Wine List Corrections

A Certified Sommelier is expected to possess, in CMS-A's own words, "basic financial wine program management and costing competencies." Section 1.4 covered the arithmetic. This section covers the judgement: reading an inventory situation, diagnosing a margin problem, and auditing a wine list for errors — the last of which appears on the Theory exam under the explicit heading wine list mistake correction.

1. Inventory: The Three Systems

The two are used together: the perpetual system tells you what should be there, the physical count tells you what is there, and the gap is shrinkage — breakage, theft, over-pouring, unrecorded comps and spillage.

Key operational vocabulary

• Par level — the baseline quantity of a given wine kept on hand; anything below par triggers a purchase order.
• FIFO (First In, First Out) — rotate older stock forward so nothing ages past its window; essential for by-the-glass whites, rosés and beer.
• Dead stock — bottles that have not sold in a defined period. Dead stock ties up cash and inflates ending inventory, flattering your COGS while quietly destroying cash flow.
• Depletion — the rate at which a SKU sells; drives purchasing decisions far more reliably than intuition.
• Provenance — the ownership and storage history of a bottle. CMS-A Service Standards require a sommelier buying older wine to ask how bottles were stored, when they left the winery's cellar, how many times they have been sold or shipped, and to inspect for label damage, leakage and ullage (the air gap below the cork).

2. How Inventory Errors Distort COGS

Because $\text{COGS} = (\text{BI} + \text{P}) - \text{EI}$, every inventory error moves reported cost in a predictable direction. Learn the direction, not a list of scenarios.

[!TIP] The examiner's favourite phrasing is "appears to lower" or "appears to improve." That word appears is the whole question. It signals that the reported number moved for a bookkeeping reason, not because the business actually got healthier. A program whose COGS "improved" because someone double-counted the cellar has not saved a single dollar.

3. Margin Analysis — and Why It Is Not Cost Percentage

Cost percentage looks at cost as a share of sales. Margin looks at what is left over.

$\text{Gross Profit (Margin \$)} = \text{Sales} - \text{COGS} \qquad \text{Margin \%} = \frac{\text{Sales} - \text{COGS}}{\text{Sales}}$

Cost percentage and margin percentage always sum to 100%. A 30% cost is a 70% margin.

But the two behave very differently in practice, and this is where scenario questions bite. Consider two wines:

Wine A has the better cost percentage. Wine B puts nearly four times as many dollars in the till. This is why sophisticated wine programs price on sliding scale — applying a lower multiple to expensive bottles — rather than a flat multiplier. A flat 4× would price Wine B at $360 and it would never sell; nobody deposits a percentage in the bank.

What actually destroys margin

• Revenue understatement. A point-of-sale entry missing digits — a $1,500 bottle rung as $1.50 — collapses margin instantly. The wine left the cellar at full cost and returned almost nothing.
• Unbilled consumption. A server charging a private party for 12 bottles when 22 were poured means ten bottles of cost with zero revenue.
• Over-pouring. A 6-ounce pour on a list priced for 5 ounces silently converts one glass in six into a giveaway.
• Mis-invoicing in your favour is not a win. If a distributor invoices a Musigny as generic Bourgogne AOC, your book cost is understated and margin looks excellent — until the corrected invoice arrives, or the auditor does.

4. Wine List Mistake Correction

CMS-A names three categories of beverage-list error that a Certified Sommelier must catch, and the Theory exam presents them as wine list mistake correction items.

(a) Misspellings of producers and regions

These are the most common and the easiest to miss because they look almost right. Learn the correct orthography of names you will print:

(b) Miscategorised or mismatched beverages

A wine placed under the wrong heading is a factual error on your list. Classic examples:

• Sancerre listed under "Chardonnay" — Sancerre is Sauvignon Blanc (and its reds and rosés are Pinot Noir).
• Chablis listed under "Unoaked Whites — New World." Chablis is Burgundy, France.
• Vouvray listed as "dry" without qualification — Vouvray spans sec, demi-sec, moelleux and sparkling.
• Champagne grouped with "Sparkling — Prosecco & Cava" when the list separates by method, since Champagne and Cava are traditional method and Prosecco is tank method.
• Amarone listed among dessert wines. Amarone della Valpolicella is a dry wine; Recioto della Valpolicella is the sweet one.
• A Rioja Gran Reserva shown with a vintage younger than the ageing requirement allows.

(c) Incorrect pricing

• A by-the-glass price that is higher than one-quarter of the bottle price on the same list.
• A vertical where the older vintage is cheaper than the younger with no explanation.
• Half bottles priced at more than the full bottle.
• A price inconsistent with the rest of its category — usually a transposition ($89 printed as $98, or a missing digit).

[!NOTE] CMS-A Service Standards open the mise en place checklist with the requirement that "wine lists are clean, correct, current, and easy to read." List accuracy is therefore assessed twice: as a Theory question, and as a professional standard underpinning the Service practical.