Author Topic: Expense calculator  (Read 1485 times)

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • View Profile
    • TxBrewing
Expense calculator
« on: January 21, 2015, 12:41:08 AM »
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
"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.
  • *
  • Posts: 6858
    • View Profile
Re: Expense calculator
« Reply #1 on: January 21, 2015, 12:43:46 AM »
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.

Offline flbrewer

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

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • View Profile
    • TxBrewing
Re: Expense calculator
« Reply #3 on: January 21, 2015, 12:54:27 AM »
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
"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
    • View Profile
    • TxBrewing
Re: Expense calculator
« Reply #4 on: January 21, 2015, 01:47:47 AM »
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
"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
    • View Profile
Re: Expense calculator
« Reply #5 on: January 21, 2015, 01:58:14 AM »
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

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Expense calculator
« Reply #6 on: January 21, 2015, 03:08:51 AM »
I get a bug up my butt whenever i get close to breaking even.

Offline 69franx

  • Official Poobah of No Life.
  • *
  • Posts: 3125
  • Bloatarian Brewing League
    • View Profile
Re: Expense calculator
« Reply #7 on: January 21, 2015, 03:36:48 AM »
Yes, that means it's time for a new toy. Excuse me, I mean tool. Necessary tool that is!
Frank L.
Fermenting:
Conditioning:
In keg: Märzen
In Bottles:  
In the works:

Offline ranchovillabrew

  • Brewer
  • ****
  • Posts: 320
    • View Profile
Re: Expense calculator
« Reply #8 on: January 21, 2015, 03:45:52 AM »
Cheaper to homebrew.  Hahaha hahaha
- Charles

Offline ynotbrusum

  • I spend way too much time on the AHA forum
  • ********
  • Posts: 2930
    • View Profile
Re: Expense calculator
« Reply #9 on: January 21, 2015, 03:50:50 AM »
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.
Hodge Garage Brewing: "Brew with a glad heart!"

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • View Profile
    • TxBrewing
Re: Expense calculator
« Reply #10 on: January 21, 2015, 04:34:19 AM »
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
"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
    • View Profile
Re: Expense calculator
« Reply #11 on: January 21, 2015, 11:51:59 AM »
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 :)
Member Savannah Brewers League & Lowcountry MALTS

Bluffton SC

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • View Profile
    • TxBrewing
Re: Expense calculator
« Reply #12 on: January 21, 2015, 12:22:13 PM »
Word
"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
    • View Profile
Re: Expense calculator
« Reply #13 on: January 21, 2015, 12:42:27 PM »
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.

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
    • View Profile
Re: Expense calculator
« Reply #14 on: January 21, 2015, 12:44:16 PM »

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.