Announcement

Collapse
No announcement yet.

BREWER'S REPORT OF OPERATIONS-spreadsheet?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • BREWER'S REPORT OF OPERATIONS-spreadsheet?

    Howdy Hi all,
    Has anyone created a spreadsheet that eases the agony of completing the TTB Brewer's Report of Operations? If so, are you willing to share?!?! PLEASE!!!!!!

    Thanks anyway,
    Dave
    Glacier Brewing Company
    406-883-2595
    info@glacierbrewing.com

    "who said what now?"

  • #2
    Hi,

    I used to have a great one that was built using Quatro Pro, when I was Head Brewer at Alcatraz in Indianapolis. If you send me your e-mail, I'll see if I can locate it and forward it to you, if you have access to that software.

    Mike

    Comment


    • #3
      TTB Forms

      Check out www.ttb.gov and pay.gov
      Forms 5130.9 & 5000.24 can both be done online.
      It even checks your math for you.

      Steffan
      Aldergrove Brewery
      Tulalip WA USA

      Comment


      • #4
        Brewers Report of Operations

        I have an Excel spread sheet that has Brewers Report as well as State of Massachusetts state filings calculated from production and sales figures. The spreadsheet requires lots of explanation, but I am happy to share with anyone interested. Just send me a PM, and I'll give the details.

        Cheers,
        Mike
        Michael Labbe
        Brewery Engineer / Director of Operations
        Lord Hobo Brewing Company
        5 Draper Street
        Woburn, MA 01801

        Comment


        • #5
          Brewers Quarterly Report

          Hi Dave, I have an excel program for this report. I just got it from a brewery I used to work at, it is on a floppy disc. I haven't gotten a chance to use it yet, but I am assuming it still works- just plug in the numbers and it does the rest. Give us a call, and I'll try to remember to check it out in the meantime.....

          Paul Thomas
          Bitter Root Brewing
          Paul Thomas
          Brewer
          Sockeye Brewing
          www.sockeyebrew.com

          Comment


          • #6
            Bro

            Hey Dave,
            I have one I made in Wordperfect if you are interested.
            Michael

            Comment


            • #7
              Any one still interesting in sharing their spreadsheet? I don't like ours and I am no good at creating spreadsheets. Thanks in advance!
              COAST Brewing Company

              Comment


              • #8
                Bump. Would like someone's spreadsheet. brewops at gmail.com

                Comment


                • #9
                  I forgot all about mine. It is buried in a box somewhere from my last desk. If I ever find it, I'll see about getting to a CD. So I am not a good source for this at the moment.
                  Paul Thomas
                  Brewer
                  Sockeye Brewing
                  www.sockeyebrew.com

                  Comment


                  • #10
                    Report of Operations

                    I know this has been posted before and maybe in this exact phrashing, but does anyone have an excel sheet to help ease the pain of filling out the Brewers Report of Operations? It would be greatly appreciated! Thank you!

                    Cheers
                    ~Matt
                    Cheers,

                    Matt Whalen
                    www.goodnaturebrewing.com

                    Comment


                    • #11
                      send me your e-mail and I will share teh one i made.

                      Comment


                      • #12
                        Originally posted by Ray Hodge
                        send me your e-mail and I will share teh one i made.
                        tannnick at gmail dot com

                        Thank you!
                        Nick Tanner
                        Head Brewer/Founder
                        Cherry Street Brewing Cooperative
                        Cumming, GA
                        www.cherrystreetbrewing.com

                        Comment


                        • #13
                          Hi Ray,

                          Not sure if you are still giving out a spreadsheet to help do the Brewers Report of Operations but if you do, I'd be extremely grateful if you could forward a copy of that to me. First time filling it out and it's a bear. Send me your address and I'll mail you a pint glass for the help .

                          kasksakiabrewingcompany @ gmail dot com
                          Kaskaskia Brewing Company

                          Comment


                          • #14
                            Spreadsheet? Why not just fill it out online at pay.gov or ttb.gov (i forget where I do that right now, long day)? You just fill it out like a spreadsheet and it shows errors, foolproof and easy.

                            Comment


                            • #15
                              I was struggling with the online form because it seems to be adding up some of the columns and showing I produced way more than I actually did and the wording on this thing is horrible. For example, I only produced 4 barrels of beer and kegged off 2 of those barrels (yes I know, tiny amount but it's our first test batches). In 2b, I put 4 barrels produced by fermentation. 2 of those barrels we transferred to brite tanks and then kegged so I put 2 under 6c (beer recieved from cellar - bulk) and 2 under 9d (Racked to keg). So then it adds up my total to 8 bbls instead of the 4 I produced. I remember reading in another post about this same exact issue I'm having so I was hoping somebody had a spreadsheet that could make this a bit less painless. I am actually starting to think I need to get rid of the 2 under 6c but at this point, I will probably just call the ttb and ask them to explain the definitions.

                              Cheers,
                              Kaskaskia Brewing Company

                              Comment

                              Working...
                              X