Ss Brewing Technologies Giveaway!

Home Brew Forums > Home Brewing Beer > Brewing Software > Cost per bottle Excel spreadsheet or iphone app?
Reply
 
LinkBack Thread Tools
Old 12-22-2011, 02:50 PM   #1
FantasticBastard
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2011
Location: Atlanta, Georgia
Posts: 38
Liked 1 Times on 1 Posts
Likes Given: 1

Default Cost per bottle Excel spreadsheet or iphone app?

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.

__________________
FantasticBastard is offline
 
Reply With Quote Quick reply to this message
Old 12-22-2011, 03:10 PM   #2
sea1961
www.wildhossbrewing.com
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
sea1961's Avatar
Recipes 
 
Join Date: Mar 2011
Location: Austin, Texas
Posts: 58
Liked 2 Times on 2 Posts

Default

Beer Tools Pro does! You have to enter cost per unit in the database and away you go!

screen-capture-1.jpg  
__________________
sea1961 is offline
 
Reply With Quote Quick reply to this message
Old 12-22-2011, 03:14 PM   #3
Weizenwerks
Registered User
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2011
Location: , Midwest
Posts: 337
Liked 8 Times on 8 Posts
Likes Given: 2

Default

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.

__________________
Weizenwerks is offline
 
Reply With Quote Quick reply to this message
Old 12-22-2011, 03:50 PM   #4
FantasticBastard
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2011
Location: Atlanta, Georgia
Posts: 38
Liked 1 Times on 1 Posts
Likes Given: 1

Default

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

__________________
FantasticBastard is offline
 
Reply With Quote Quick reply to this message
Reply



Quick Reply
Message:
Options
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 03: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