Membership questions? Log in issues? Email info@brewersassociation.org

« previous next »
Pages: [1] 2 3   Go Down

Author Topic: Expense calculator  (Read 3763 times)

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Expense calculator
« on: January 20, 2015, 05:41:08 pm »
Did  few google searches and came up dry, so I thought I would ask around here...

looking for a free or almost free program or calculator that will let me know what I am paying to produce a batch of beer.

Ingredient cost, labor, electricity and the like.

any one have any ideas???

Tim
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline Stevie

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 6858
Re: Expense calculator
« Reply #1 on: January 20, 2015, 05:43:46 pm »
Many of the newer (last 2 years) recipe applications can handle this for you. Costs are added when adding items to the inventory. A quick Excel sheet would work fine.
Logged

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Re: Expense calculator
« Reply #2 on: January 20, 2015, 05:50:23 pm »
+1 for Excel...I can whip one up for you if you'd like
Logged

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Re: Expense calculator
« Reply #3 on: January 20, 2015, 05:54:27 pm »
yeah, i can use, but not create spreadsheets...lol

I currently use Brewers Friend, and I am also exploring MyBrewCo as well, but they don't have the functions I am looking for.

Tim
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Re: Expense calculator
« Reply #4 on: January 20, 2015, 06:47:47 pm »
The more I think about this the deeper the rabbit hole gets...
Things I would like to add to the cost of a pint:

Grain
Hops
Water
Yeast
Finings
Man hours
Brewing equipment, a % of the total cost until the equipment has paid for itself
fermentation equipment, ferm chamber, carboys, and such
Yeast management and propagation equipment
DIY projects for the brewery
Kegs
Growlers
Bottles

see i keep getting deeper and deeper...lol

Tim
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline jaftak22

  • Assistant Brewer
  • ***
  • Posts: 230
Re: Expense calculator
« Reply #5 on: January 20, 2015, 06:58:14 pm »
It's a labor of love. Sure it might be a little cheaper to homebrew, but at the end of the day when you have a good glass a beer, nothing beats something you hand crafted. Most homebrew I've tasted here in a Colorado Springs is on par with local breweries
Logged

Offline Stevie

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 6858
Re: Expense calculator
« Reply #6 on: January 20, 2015, 08:08:51 pm »
I get a bug up my butt whenever i get close to breaking even.
Logged

Offline 69franx

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 3210
  • Bloatarian Brewing League
Re: Expense calculator
« Reply #7 on: January 20, 2015, 08:36:48 pm »
Yes, that means it's time for a new toy. Excuse me, I mean tool. Necessary tool that is!
Logged
Frank L.
Fermenting: Nothing (ugh!)
Conditioning: Nothing (UGH!)
In keg: Nothing (Double UGH!)
In the works:  House IPA, Dark Mild, Ballantine Ale clone(still trying to work this one into the schedule)

Offline ranchovillabrew

  • Brewer
  • ****
  • Posts: 321
Re: Expense calculator
« Reply #8 on: January 20, 2015, 08:45:52 pm »
Cheaper to homebrew.  Hahaha hahaha
Logged
- Charles

Offline ynotbrusum

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 4887
Re: Expense calculator
« Reply #9 on: January 20, 2015, 08:50:50 pm »
When your crew only wants your homebrew, you won't consider costs.  In the last two weeks I have had two sacks of grain given to me (Avengard and a Weyermann Floor malted Pils).  I told my guys long ago to stop bringing me commercial craft brews and never asked for a sack of grain.  Cost of friendship and beer appreciation....priceless.
Logged
Hodge Garage Brewing: "Brew with a glad heart!"

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Re: Expense calculator
« Reply #10 on: January 20, 2015, 09:34:19 pm »
It is not about making money but seeing how it works in the bottom line for my own knowledge

Jaftak22 are you in the springs?  I am in the fountain/security widefield area
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline realbeerguy

  • Brewer
  • ****
  • Posts: 319
  • Golf & drink beer with your friends
Re: Expense calculator
« Reply #11 on: January 21, 2015, 04:51:59 am »
Quote from: TMX on January 20, 2015, 06:47:47 pm
The more I think about this the deeper the rabbit hole gets...
Things I would like to add to the cost of a pint:

Grain
Hops
Water
Yeast
Finings
Man hours
Brewing equipment, a % of the total cost until the equipment has paid for itself
fermentation equipment, ferm chamber, carboys, and such
Yeast management and propagation equipment
DIY projects for the brewery
Kegs
Growlers
Bottles

see i keep getting deeper and deeper...lol

Tim

You forgot time spent on internet beer forums :)
Logged
Member Savannah Brewers League & Lowcountry MALTS

Bluffton SC

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Re: Expense calculator
« Reply #12 on: January 21, 2015, 05:22:13 am »
Word
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline breWglug

  • 1st Kit
  • *
  • Posts: 2
Re: Expense calculator
« Reply #13 on: January 21, 2015, 05:42:27 am »
Another +1 for excel. flbrewer do you want to get started?  I'd be happy to put some work into it also. Automatically this needs to keep track of the recipe so it serves that purpose too. I don't expect this to replace beersmith or anything but for the most basic stuff it could work well.
Logged

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Re: Expense calculator
« Reply #14 on: January 21, 2015, 05:44:16 am »

Quote from: breWglug on January 21, 2015, 05:42:27 am
Another +1 for excel. flbrewer do you want to get started?  I'd be happy to put some work into it also. Automatically this needs to keep track of the recipe so it serves that purpose too. I don't expect this to replace beersmith or anything but for the most basic stuff it could work well.
Sure, give me an hour and I'll share something via Dropbox.
Logged
Pages: [1] 2 3   Go Up
« previous next »