Grainfather vs pub vs shop costs

[GHW]

So I was bored on a conference call and the other grainfather thread got me thinking about relative costs. So to see where a GF pays for itself vs buying beer in the pub or shop I put together a chart.

Now I'm crap with Excel and couldn't fathom how to label the axis but the vertical axis is total spend in £.

The horizontal axis shows total no. of pints.

I've assumed:
£3.50 a pint in the pub
£1.50 a bottle in the shop. (I'm ignoring the size difference between a 500ml bottle and a pint.)
£600 for GF
£15 per brew on ingredients (haven't factored in utilities, give me a break)

What it shows is the GF pays for itself after roughly:
180 pints vs pub (so 5 full length brews)
520 pints vs shop (so 13 full length brews)

If anyone can be bothered to give me their equipment set up costs I can add them in.

 

[AJT]

Ha ha love it. You obviously enjoy your work!

I wish I paid £3.50 a pint!!

 

[GHW]

Ha ha love it. You obviously enjoy your work!

I wish I paid �£3.50 a pint!!

Yeah optimistic if you live around london.

 

[Bigjas]

Nice one, and like AJT above says, £3.50 a pint in a pub is good round here!! How much difference would it make it at £4 a pint?

Jas

 

[Robin54]

Great thinking GHW..mind you a good pint in Sussex costs about #4.40 and London...well that depends upon how deep you're pockets are.
Good work tho, and will bear in mind. Thanks

 

[GHW]

Nice one, and like AJT above says, ��£3.50 a pint in a pub is good round here!! How much difference would it make it at ��£4 a pint?

Jas

�£4 a pint in pub brings the figure back to 160 pints break even for GF.

This is fun!

 

[wfr42]

Hbc biab starter kit £108 (has it gone up?)
Call it £115 with the hop filter (maybe £100 as it comes with a kit).

 

[GHW]

Hbc biab starter kit �£108 (has it gone up?)
Call it �£115 with the hop filter (maybe �£100 as it comes with a kit).

You're laughing:

 

[wfr42]

Will need to swap something similar to "test" if the grain father is better.

 

[jceg316]

I do like a bit of Excel work. Interesting chart, would you be able to share the workbook? If it's alright with you, I'd like to use it as a model to see how my own costs compare.

Was in a pub in Goodge St (that's central London) and got a can of Fourpure Pils, Beavertown Neck Oil & Gamma Ray, £5.30 per can. that's the going rate in London pubs for craft beer.

 

[Wabby]

£2 per pint here in Sunny Scunny. £3 max. (Assuming drinking run of the mill piss of course).

 

[GHW]

Happy to share the workbook if anyone wants it, send me a pm with email address.

I also did a cost per pint analysis to see how quickly it goes down but haven't charted that. The data is all in there though.

It doesn't work out well for the GF - after 800 pints, including setup and ingredients you are only at 77p per pint!

 

[GHW]

Happy to share the workbook if anyone wants it, send me a pm with email address.

I also did a cost per pint analysis to see how quickly it goes down but haven't charted that. The data is all in there though.

It doesn't work out well for the GF - after 800 pints, including setup and ingredients you are only at 77p per pint!

Cost per pint for GF over no. of pints made. Using same metrics as 1st chart, ��£15 per brew on ingredients.

�£16 a pint for the first 40!

now also with Biab starter kit. V cheap!

 

[Robin54]

I do like a bit of Excel work. Interesting chart, would you be able to share the workbook? If it's alright with you, I'd like to use it as a model to see how my own costs compare.

Was in a pub in Goodge St (that's central London) and got a can of Fourpure Pils, Beavertown Neck Oil & Gamma Ray, �£5.30 per can. that's the going rate in London pubs for craft beer.

American Express..that willdo:whistle: nicely thanks.

 

[Wilfy]

Love living in the north east, can get a pint of cask for <£3 and Stella for <£3.50.

 

[stuart_A]

Remember there is a resale value of the GF. Maybe depreciate over 3 years? Then there's the time cost saving (value of time) and the non monetary costs one attaches to enjoyment of their hobbie.

Put your mortgage in versus living in a tent and you'll get something similar. Some value the luxury despite the end result being possibly the same (ie a nights kip)

 

[Robin54]

Remember there is a resale value of the GF. Maybe depreciate over 3 years? Then there's the time cost saving (value of time) and the non monetary costs one attaches to enjoyment of their hobbie.

Put your mortgage in versus living in a tent and you'll get something similar. Some value the luxury despite the end result being possibly the same (ie a nights kip)

Ah.. I see you are an accountant Stu
Lets keep this (semi) real

 

[mickthetrick]

Love living in the north east, can get a pint of cask for £3 and Stella for £3.50.

hi wilfy. were abouts are in the north east?
if im in consett wetherspoons they sell different ales for less than £2 a pint. had some nice ones too. :thumb:

 

[GHW]

Remember there is a resale value of the GF. Maybe depreciate over 3 years? Then there's the time cost saving (value of time) and the non monetary costs one attaches to enjoyment of their hobbie.

Put your mortgage in versus living in a tent and you'll get something similar. Some value the luxury despite the end result being possibly the same (ie a nights kip)

That's easy I just adjust the cost of the gf purchase. Unless you want to show its value depreciate Over time, against a certain brewing frequency...

In which case you can bugger off!

 

[nigelnorris]

Don't forget if you go adding in equiipment and utilities costs to do the same the other side. A pub pint can cost cab fares, bags of scratchings and so on.