trampjuice.myfastforum.org

John Barleycorn · Posted: Mon Aug 04, 2008 11:53 am Post subject: Jakeynomics

About a year ago, Tesco Super was 8.6% abv, and retailed at a world-beating 65p for a 440ml can.

It's now sunk to 7.9% abv and sells for over £1 a can.

Has anyone else noticed this?

And can someone tell me what is the optimum abv to sterling ratio of supermarket superlagers?

lee spoons · Farmhouse boy Joined: 24 Aug 2008 Posts: 6

If you have Microsoft Excel (or the OpenOffice.org equivalent, which is what I use) it's easy enough to work out a 'price per unit' converter:

Column 1: how much alcohol is in the can/bottle, in ml
Column 2: the ABV in %, as listed on the can/bottle
Column 3: =(Column 1 * Column 2)/1000 (this gives the number of units for each can/bottle)
Column 4: price per can (if you're buying four-packs at 3.79 or something then put what you paid for 4 cans and then /4)
Column 5: =(Column 4/Column 3) and this gives you the price per unit.

So if you have, say, a pack of Tesco Super Strength (which my local Tesco doesn't bloody sell) then type the following (assuming the first line of your Excel spreadsheet has the headings "ml, abv, units, price, price per unit"):

Column 1: 440
Column 2: 8.6
Column 3: =(A2*B2)/1000
Column 4: (whatever a pack of Tesco Super Strength costs, in quid)
Column 5: =(D2/C2)

et voila. This works for ANY alcohol... not just tramp juice. For the record, the cheapest way of getting you there round my way is Skol Super. 500ml/9%=4.5 units per can at £1.19 per can, which gives you a price per unit or "booze quotient" of 0.264 recurring. By comparison, Heineken Export bought from the same shop gives you a booze quotient of 0.476... but after a couple of Skol Supers you'll probably want to calm down a bit anyway.