In previous posts we introduced you to the daily lives of Penny the brewery accountant and Bruno the brew master. This segment focuses on the life of the brewery inventory manager through the eyes of Peter. Peter’s story embodies the brewery inventory persona and the constraints encountered due to multiple systems. Even the best system of spreadsheets have to be constantly updated manually to reflect activities in production.
Peter is the Inventory Mgr at Bill’s Brewery. As the keeper of the brewery’s inventory spreadsheets, Peter’s responsible for a lot of moving parts in the brewery and works closely with Bruno, the brew master.
Peter uses a variety of tools like spreadsheets, web apps and hand-written notes to keep track of the materials coming in and going out. He also relies heavily on data from other departments, including Bruno’s weekly brew logs.
Bruno is a rock star in the brew house, but he often doesn’t record what he uses for their “Good Ish” Beer that has become so popular. Peter has to track him down in order to keep his spreadsheets up to date.
“Hey Bruno, how many hops did you use last week?”
“50 pounds… I think”
Peter inputs Bruno’s data into his spreadsheets but the numbers don’t line up. Peter knows that when you want a job done right you just have to do it yourself. So Peter begins to hand count the remaining inventory to get what he needs for his spreadsheets. As soon as Peter finished updating his records, he gets an email from Bruno with a completely new set of data. Peter tries to make the necessary adjustments, but somehow the numbers still didn’t line up!
Peter’s breaking point
Peter takes his frustrations to Bill the brewery owner. Peter says that he couldn’t do his job with their current inefficient processes and that Bruno needed better tools to communicate what’s happening in production and what materials are being consumed.
The Brewery Problem Explained
After hearing Peter’s story, Bill dives into researching brewery production systems. Sometime later he meets with Peter to share his findings. Turns out that “the problem” wasn’t an isolated issue for any one person or department, or even a brewery production software problem. The problem occurred across every department in the brewery. “The problem” was the inability to connect the dots between the various spreadsheets, bookkeeping software, web apps, proprietary knowledge, and handwritten notes. It was the same problem Penny and Bruno were experiencing.
Accurate, forward-looking brewery inventory with OBeer
Bill explains that Peter’s entire inventory cycle could be managed in one system, from purchasing & receiving, to sales and shipments and everything in between. Bruno can update Peter’s inventory records with what was used in production in real time using an iPad on the brewery floor.
Not only can Peter be rest assured knowing that all his inventory levels were accurate and in real time, but he can also get better forward-looking inventory insights based off of planned production schedules and order commitments at a future date.