Pricing Formula: Full case cost goes into Cost. If discounted, add discounted case cost into Disc Cost. Lightspeed supplier price automatically uses Disc Price when provided. Retail price = CEILING(Cost Price × Multiplier, 0.05).
| Beer Name | Brewery | Collab With | City/Town | Country | Style | ABV (%) | Untappd ID | Extra Tags | Cost (Case) | Disc Cost | Qty/Case | Format | Size (ml) | Cost Price | Disc Price | Cost / cl | Multiplier | Retail (£) | Order Qty | Actions |
|---|
Composite Breakdown: Each keg generates 1 parent inventory item (active: 0, tracks supply cost and holds keg volume) plus 5 composite portion products (Pint, 2/3, 1/2, 1/3, Taster). Lightspeed depletes the parent keg stock proportionally with each pour.
| Container | Brewery | Collab With | Beer Name | Style | ABV (%) | City/Town | Country | Full Cost | Disc % | Multiplier | Sell (£) | GP % | Pint (£) | 2/3 (£) | 1/2 (£) | 1/3 (£) | Order Qty | Composites | Actions |
|---|
Invoice Verification: Review every line item across Small Pack and Draught before creating your Lightspeed Stock Order. You can adjust order quantities or supply prices directly in this table if your delivery invoice has price or quantity differences.
| Category | Brewery | Beer Name | Format / Size | Pack Qty | Order Qty | Unit Cost (Ex VAT) | Line Total (Ex VAT) | Line Total (Inc VAT) | Target GP | Catalog Status | Actions |
|---|
| SKU | Handle | Comp. SKU | Comp. Name | Comp. Qty | Product Name | Type | Tags | Supply Price | Retail Price | Brand | Active |
|---|
Price Curves & Multiplier Settings
Locked (Read-Only)View pricing multipliers, draught container yields, and ABV minimum pint rules. Edits are password protected to prevent accidental changes.
Matches the sheet's price-per-cl tiered markup curve. Lower cost-per-cl yields higher multipliers (up to 2.19x), higher costs step down to 1.84x.
| Cost per cl Bracket | Upper Limit (Max £/cl) | Multiplier |
|---|
Standard UK container yields used for portion fractions and inventory depletion.
| Container | Type | Pints | Default Multiplier |
|---|
VAT & Portion Rules
- UK Standard VAT: 20% (Sell = Net / 0.8333 or Sell inc VAT = Net * 1.20)
- Pint Retail Price: Rounded up to nearest 10p:
CEILING(Sell / Pints, 0.10) - 2/3 Pint:
Pint × 2/3(exact 4.80 for 7.20 pint) - 1/2 Pint:
Pint ÷ 2(exact 3.60 for 7.20 pint) - 1/3 Pint:
Pint ÷ 3(exact 2.40 for 7.20 pint) - Taster: 25ml aliquot (
(25 / 568) / Pintscomposite deduction, retail price £0.00)
Enforces minimum price per pint for Keg draught across 0.5% ABV bands. If calculated pint price falls below the band minimum, it is clamped to that minimum and portions recalculate.
| ABV Band | Upper ABV (%) | Min Pint Price (£) |
|---|
Enforces minimum price per pint for Cask draught across 0.5% ABV bands.
| ABV Band | Upper ABV (%) | Min Pint Price (£) |
|---|