~/sajjad $ cat projects/beer-range
← cd ../projects
Data & reporting
Draught range & pricing review
Delivered Nov 2026+£5.5k a year modelled
Which beers should be on the bar, and at what price? I costed every keg on the brewery’s tied list per pint, ran them against the venue’s real till volumes and local pint prices, and modelled a six-line and an eight-line bar. Six won: about £105 a week more gross profit on the same pints.
The maths
- Cost per pint = keg price without VAT ÷ pints in the keg (88 in a 50-litre keg). GP is checked at three selling prices for every keg on the list.
- Profit per line = (price without VAT − cost per pint) × the pints that line really sells, taken from three weeks of till data and reconciled to the draught yield baseline.
- Pounds of profit per pint matter more than GP%: a premium local lager has a lower GP% than the mainstream brand but earns more on every pint.
What it changed
- Three lines swapped and five prices moved, benchmarked against national and regional pint-price surveys. One craft keg was ruled out at about 35% GP.
- The “worst seller” was tested properly: taking it off breaks even at best, so it stays.
- The discounted local price was costing about £88 a week, which was nearly as much as the whole line-up change was worth.
Result
Keg gross profit modelled from about £935 to £1,041 a week, roughly £5,500 a year, with no new equipment. Eight lines adds only £22 a week more, and most of that relies on an assumed new line. Even if volume fell 5% after the price rises, the six-line bar still comes out ahead.