Author Topic: BROP software for a 1bbl brewery  (Read 2003 times)

Offline micsager

  • Senior Brewmaster
  • ******
  • Posts: 1000
    • View Profile
BROP software for a 1bbl brewery
« on: April 12, 2013, 08:08:35 AM »
Anyone know of a reasonable software product for a tiny brewery?  The Orchastratedbeer looks cool, but way too much for us. 

(or if someone has an excel spreadsheet to share...........)

Offline kylekohlmorgen

  • Senior Brewmaster
  • ******
  • Posts: 1163
    • View Profile
    • The South House Pilot Brewery
Re: BROP software for a 1bbl brewery
« Reply #1 on: April 12, 2013, 10:09:18 AM »
The sample they have on the website gives you a good road map for making your own spreadsheet.

http://www.ttb.gov/beer/brewer_report.shtml

I would start by re-creating the form in Excel, and then linking the cells as it shows on the sample. If you're using Excel for Inventory Management, just add a tap to your existing workbook. Then you can pull in the info rather than manually entering it / risking a typo.
@southhousebrew

Indianapolis, IN

Recipes, Brett/Bacteria Experiments:
http://southhousepilotbrewery.blogspot.com/

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2162
  • Aachen, DE
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #2 on: April 12, 2013, 12:27:16 PM »
Then you can pull in the info rather than manually entering it / risking a typo.

+1. You should be able to set up your Excel sheets with (ideally) a single page of inputs. The more you have to change, the less useful/flexible your sheet is, and the more likely you'll make mistakes.
In der Kürze liegt die Würze.

Offline Thirsty_Monk

  • Senior Brewmaster
  • ******
  • Posts: 1835
  • Eau Claire WI
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #3 on: April 12, 2013, 06:17:33 PM »
Beer Run Software:
http://www.beerrunsoftware.com/

I think this is Quick Books AdOn.
I do not know the pricing thou.

If you find out, Let me know.
Na Zdravie

On Tap At The TapRoom:
Bohemian Pilsner
Bohemian Dark Lager
Smoked Bock
MaiBock
American Brown Ale
Marzen
Root beer

Offline anthony

  • Assistant Brewer
  • ***
  • Posts: 234
  • Hoppy to help!
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #4 on: April 13, 2013, 11:44:24 PM »
I have Beer Run pricing from the CBC.

Not sure if it is cool to post the exact details in the forum or not. But for less than 1000 BBLs a year, it is ultimately about $4k a year to use.

Offline Thirsty_Monk

  • Senior Brewmaster
  • ******
  • Posts: 1835
  • Eau Claire WI
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #5 on: April 14, 2013, 07:22:06 AM »
Thank you.
Na Zdravie

On Tap At The TapRoom:
Bohemian Pilsner
Bohemian Dark Lager
Smoked Bock
MaiBock
American Brown Ale
Marzen
Root beer

Offline kylekohlmorgen

  • Senior Brewmaster
  • ******
  • Posts: 1163
    • View Profile
    • The South House Pilot Brewery
Re: BROP software for a 1bbl brewery
« Reply #6 on: April 16, 2013, 04:22:31 AM »
$4000/year?

I guess it depends on your size, but I feel like a fairly small brewery might put this cash to better use on a bright tank or more hops.
@southhousebrew

Indianapolis, IN

Recipes, Brett/Bacteria Experiments:
http://southhousepilotbrewery.blogspot.com/

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2162
  • Aachen, DE
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #7 on: April 16, 2013, 06:17:35 AM »
$4000/year?

I guess it depends on your size, but I feel like a fairly small brewery might put this cash to better use on a bright tank or more hops.

Excel can do everything you need, if you have a strong grasp of accounting. The more heavy-lifting a program does, the less knowledge you need. You really, really need to keep close track of your finances if you're a small brewery on a tight budget. I'd say if you really have no idea how accounting is done in manufacturing, Orchestrated Beer is worth the money.
In der Kürze liegt die Würze.

Offline micsager

  • Senior Brewmaster
  • ******
  • Posts: 1000
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #8 on: April 16, 2013, 07:32:35 AM »
$4000/year?

I guess it depends on your size, but I feel like a fairly small brewery might put this cash to better use on a bright tank or more hops.

Excel can do everything you need, if you have a strong grasp of accounting. The more heavy-lifting a program does, the less knowledge you need. You really, really need to keep close track of your finances if you're a small brewery on a tight budget. I'd say if you really have no idea how accounting is done in manufacturing, Orchestrated Beer is worth the money.

But, one must be fairly proficient in excel.  I do OK, but certainly not well enough to suit my needs.  One reason I was hoping someone would share a spreadsheet they ahve created.  I have some friends int he accounting department at work, and two guys seem very willing to help.  Of course it will cost me a couple growlers.  But really, that's a good deal.  They are coming over this weekend, to take my haphazard spreadsheets, and turn them into one cohesive product. 

I love brewing beer, and I love it when a complete strangers orders a second of the beer we brew.  But, the business side of this is not for me.  Probably why we will never grow past our 1bbl system. 

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2162
  • Aachen, DE
    • View Profile
Re: BROP software for a 1bbl brewery
« Reply #9 on: April 16, 2013, 08:30:08 AM »
I could help you out with spreadsheets as well, if you need more help.
In der Kürze liegt die Würze.