Dynamics ERP for Craft Beer Production

Craft brewers have a number of system requirements that are typical of many manufacturers looking to deploy an ERP system: material planning, cradle to grave lot traceability, bar-codes for materials handling, production scheduling, etc. However, there are many business processes that are very unique to this burgeoning industry. As breweries begin to grow in size and sophistication, they encounter an increasing need to start managing and controlling their unique processes within the ERP system, as opposed to relying on manual and home-grown systems.

With eight years of experience working in this arena, Tridea has partnered with our clients to solve a number of these unique challenges by utilizing tools available within the Dynamics ERP software systems.  Below are a few examples of requirements that craft brewers may face, along with the solutions to those challenges. 

Tracking Barrel Aged Beer

Small batches of special beer creations are often aged in barrels, which may be stored in a warehouse for extended periods of time and even transferred to different locations prior to being packaged and made available for sale. As the size of a “barrel program” grows, it can be challenging to keep track of:

1) What beer is currently stored in which types of barrels?

2) Where the barrels are located?

3) What types of beer have passed through a given barrel in the past? (thus establishing a “flavor profile”)

With Dynamics AX, we have used the concept of “License Plate Numbers” (LPNs) to assign a unique ID to each of these barrels. We can then track the beer that is assigned to an LPN, track the location and movements of the LPN, and also see a history of how many times a barrel has been used and what types of beers were stored in the barrel.

 

Blending of Batches in a bright tank (“brite tank”)

Bright tanks are where clarified beer is stored after it has been filtered and before it gets bottled or placed in a keg / cask.  It is not uncommon for a quantity of beer from one production batch to remain in a bright tank when a new production batch is added to the tank. As a result, two separate batches of beer that would ordinarily be tracked with two distinct lot numbers, have now effectively become blended into a single “combined” batch, which is then packaged and sold to customers. We have developed an automated routine to merge these batch numbers to reflect the blending of the beer in the bright tank, allowing for a more accurate and true lot traceability.

 

Batch Processing Resulting in the Production of Both Filtered Beer and Unfiltered Beer

In some cases, during the course of producing a filtered beer, a quantity of unfiltered beer is taken out of the tank prior to filtering. Sometimes, this might even be a last-minute decision that is made after the production order has been started. This unfiltered beer might then be barrel-aged or have special ingredients added to it in order to produce a batch of a special limited offering product. Because the process manufacturing functionality within Dynamics AX allows for the creation of co-products on a single production order, we can easily use one production order to produce both the unfiltered and filtered beer, and accurately track them as two distinct products.

 

Integration to Brewing Systems

Because brewers need to swiftly make decisions about which brew systems, fermentation vessels, and bright tanks to use, it is important for them to interact directly with the ERP system if we are to maintain timely and accurate information about the production process. Leveraging MS Dynamics’ strong integration tools, we have been able to build integration points that can take direct feeds from the brewing system (example: quantities of malt that flow into the brew system from a silo can feed directly to the ERP production order, quantities of filtered beer flowing through a filter outlet into a bright tank are fed directly to the production order). We have also built touch-points allowing for brewers to manually record transactions in the brewery floor systems that then get integrated to the ERP system.

 

This article was written by Matthew Boese, Partner at Tridea Partners, a Gold Certified Microsoft Dynamics Partner serving Southern California.