Cost per bottle Excel spreadsheet or iphone app? - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > Brewing Software > Cost per bottle Excel spreadsheet or iphone app?

Reply
 
Thread Tools
Old 12-22-2011, 03:50 PM   #1
FantasticBastard
Recipes 
 
Dec 2011
Atlanta, Georgia
Posts: 38
Liked 1 Times on 1 Posts



Does anybody have an Excel spreadsheet that can calculate cost per bottle of your beer, taking into account fixed equipment costs and varying recipe costs?

Also, how do you guys manage your pipeline? How do you schedule brew and bottle days to ensure a steady flow of product?

In case it's not glaringly obvious, I'm new to this. I'm about to do my 3rd partial boil extract batch w/ specialty grains. Trying to ramp up production to a respectable volume while producing the best beer possible. No space for all grain yet but that's where I'm heading eventually.

 
Reply With Quote
Old 12-22-2011, 04:10 PM   #2
sea1961
www.wildhossbrewing.com
HBT_LIFETIMESUPPORTER.png
 
sea1961's Avatar
Recipes 
 
Mar 2011
Salt Lake City, Utah
Posts: 57
Liked 2 Times on 2 Posts


Beer Tools Pro does! You have to enter cost per unit in the database and away you go!
Click image for larger version

Name:	screen-capture-1.jpg
Views:	1148
Size:	24.2 KB
ID:	41318  

 
Reply With Quote
Old 12-22-2011, 04:14 PM   #3
Weizenwerks
Registered User
Recipes 
 
Feb 2011
, Midwest
Posts: 337
Liked 9 Times on 9 Posts


Calculating cost by amortizing your equipment is pretty easy, but very unnecessary for a hobby. For a hobby, I wouldn't worry about equipment cost, just ingredients.

For brewing management, figure how long to ferment, bottle condition, and then consume. Time it when your last 6 pack is about to be consumed, your bottle conditioning batch is done.

Not at the brewery, but at home on my homebrew system, I have one fermentor and keg my beer (bottling sucks, IMO). I keep a hefeweizen, dunkelweizen, and weizenbock on tap at my house all the time. The hefeweizen and dunkelweizen get drank the most and the weizenbock less as it's not session strength. It's about 3-4 weeks to drink one 5 gallon keg of the hefeweizen or dunkelweizen and it ferments for 10 days then is chilled and carbonated over a week in the cellering room. Usually in a week or two after that it gets brought up to my home office to serve.

Just time it out. For me I figure 3 weeks from fermentor to serving. I have a 10 gallon system at home so one brew is two months worth of beer. When I change out the keg for a fresh one, I brew that style of beer next. I have three kegs for each style so I can be serving off one keg and have two kegs in the cellar ready to go when that one is empty.

 
Reply With Quote
Old 12-22-2011, 04:50 PM   #4
FantasticBastard
Recipes 
 
Dec 2011
Atlanta, Georgia
Posts: 38
Liked 1 Times on 1 Posts


Wow that's quite the system you've got going there! Thanks for the reply.

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Brewing Spreadsheet albannach Brewing Software 7 08-22-2013 06:07 AM
Brew Log for excel brewsbrothers Brewing Software 3 10-08-2010 04:56 PM
Brew Planner Spreadsheet BA_from_GA Brewing Software 5 01-24-2010 04:33 AM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 10:50 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM


Forum Jump