Announcement

Collapse
No announcement yet.

Raw Material inventory management

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

  • #16
    Inventory Spread Sheet

    Would you mind sharing that spreadsheet with me as well? I have been trying to manage my raw materials inventory for future orders and I am striking out on the efficiency of my system.

    Comment


    • #17
      Originally posted by mswebb View Post
      need an email address so I can share the template with you
      Would you mind sharing with me?
      kevin@coelacanth.com
      :::::::::::::::::
      Kevin Erskine
      Founder
      Coelacanth Brewing Company
      Norfolk, VA

      Comment


      • #18
        The Best System

        Originally posted by jnhargrove21 View Post
        Would you mind sharing that spreadsheet with me as well? I have been trying to manage my raw materials inventory for future orders and I am striking out on the efficiency of my system.
        Back in the mid 1980s I worked for a very Successful Restaurant Corporation that later underwent a hostile takeover.
        They inventoried everything in the house EVERY DAY, all the way down to operating supplies, china, and glassware.
        I worked for other outfits and took this method with me, as it was the best in the trade.
        It was made quite simple by perfect organization.
        The Stock room, and all storage in the entire operation was perfectly organized and layed out where an inventory could be done quickly of EVERYTHING.
        The Control Forms ran exactly in the order of the shelves, so essentially it was right down the line and easy.
        No matter what you are going to input into a computer,the necessity of this scheme cannot be understated.
        The failure of most people to be able to engage inventories, is the fact that they are not organized and do not understand the necessity of high levels of order with respect to business.
        Everything is in perfect order and contains all necessary data regarding each entry on the control form.
        The control forms in this case were regenrated monthly. The Spreadsheet in itself does not make things easier in real terms.
        Its starts with the basics.
        Warren Turner
        Industrial Engineering Technician
        HVACR-Electrical Systems Specialist
        Moab Brewery
        The Thought Police are Attempting to Suppress Free Speech and Sugar coat everything. This is both Cowardice and Treason given to their own kind.

        Comment


        • #19
          Originally posted by mswebb View Post
          need an email address so I can share the template with you
          Would I be able to see a copy? dave@bannermanbrewing.com

          Comment


          • #20
            spreadsheet

            Originally posted by mswebb View Post
            need an email address so I can share the template with you
            I'd love to see the template too! diana@bootleggersbrewingco.com

            Comment


            • #21
              Would love to get a that spreadsheet if you still have it on hand

              Originally posted by mswebb View Post
              need an email address so I can share the template with you
              Sorry I know this might be an old feed but that spreadsheet sounds helpful. My email is ramosfd@gmail.com

              Thanks!

              Comment


              • #22
                Spreadsheet Share Request

                Originally posted by mswebb View Post
                My spreadsheet is in Google Sheets which means it isn't easy to just upload here. I'm working on cleaning it up a little and adding some notes on intended use and then I'll save a snapshot of it and give folks access. Don't know an easy way without just sharing out to individual emails (which could get tedious fast).

                It's really a simple spreadsheet with ingredients listed in the first column; starting inventory, brew days and deliveries in subsequent columns (grouped by section for incoming and outgoing). It's a simple matter to calculate total ingredient used or total ingredient delivered. It's also a simple matter to then calculate on hand inventory (starting inventory + delivered - used). I've thrown in some columns for physical counts as an auditing mechanism as well as a section for planning (enter what you need for a given recipe and how many times you'd like to brew it and it will compare that your on hand inventory).

                It's a bit chaotic with several redundant columns but it works.

                If anyone can point out a good way to share from Google, let me know.
                I know this might be an old feed but that spreadsheet/Google Sheet sounds really helpful! If you're willing and able to share, my email is neforster@gmail.com. Thanks, cheers!

                Comment


                • #23
                  Im sorry, but I'm way late to the party. I would like a link to this spreadsheet.

                  Comment


                  • #24
                    If you're still looking for an inventory tracking solution, we just released our PRO version which includes inventory and raw material management. It is all integrated behind the scenes of our scheduling dashboard so one quick glance can tell you if you need to order more raw materials. Check out www.brewplanner.com/plans to learn more.

                    Comment

                    Working...
                    X