John Dewar and Sons Case Study – DRAMS

Hero Swish Reverse

The Challenge:

The challenge for Bacardi’s John Dewar & Sons Ltd (JDSL) was a slightly unusual one, in that it involved the replacement of a system which was functioning very well. JDSL were managing operations using a system which had been built in-house and tailored to their specific requirements over a number of years. It was a system that they liked, and which did everything they needed it to. There was just one problem: Bacardi had made the decision to implement a new ERP system across its business for greater integration and control. Despite the many benefits of this approach, it was clear from the outset that an ERP system would not be capable of managing the complexities of bulk stocks of maturing inventory. Bacardi required a dedicated system for bulk stock control with a data interface to SAP – but not only at JDSL for Scotch whisky. In addition to matching the functionality of JDSL’s previous system, the new system also needed to be capable of handling bulk stocks of other maturing spirits (such as rum and tequila) at Bacardi production sites worldwide. Furthermore, Bacardi wanted to make use of modern technology and to work with an experienced supplier that could deliver the functionality they required across the business – and provide long term support of the solution once in place.

The Solution:

JDSL were already aware of Trapeze’s DRAMS system having seen the solution in action at other sites within the industry. Feedback from system users was positive, and initial meetings with Trapeze gave JDSL confidence that they were dealing with a supplier that not only understood the intricate workings of the whisky business, but also had a proven track record of adapting a system to meet exacting customer requirements JDSL Bulk Planner John Kerr: “DRAMS covered most of our requirements off the shelf and Trapeze worked with us to identify and bridge the gaps. Their willingness to adapt the product to our way of working, coupled with the knowledge of the DRAMS consultants – both of their product and of bulk stock processing as a whole – gave us a solid platform to work from.” Assistant Blender Keith Geddes was particularly impressed with the Trapeze approach: “The gap analysis and functional specification stage of the project were carried out in a very structured manner which ultimately proved to be very successful.” Real time scanning, a real time interface to JDSL’s cask filling system, and long and short term planning functions were identified as key areas for development. Stephanie Macleod, Master Blender explains: “We wanted a one stop shop, with everything done from within DRAMS. Operating practices change over time, and we knew that this approach would give us greater flexibility to adapt our systems to meet the needs of the business.” The new functionality was specified and incorporated into the development and implementation project plan along with the required interfaces to SAP. Keith Geddes says the implementation went smoothly: “Trapeze consultants made themselves available to spend days on site with us at each delivery stage, going through the testing process and making sure we were happy with the functionality that was delivered. That generated a lot of confidence in the system amongst the people carrying out the testing – who ultimately became the end users of the system.”

The Results:

Keith Geddes explains: “A good interface to SAP was one of the main drivers behind the move to a new system, but it was essential that we didn’t lose system functionality or control over our operational processes. Trapeze adapted DRAMS to our requirements; it now provides all of the functionality covered by our old system – and some additional benefits as well.” The new elements have been implemented using the latest technology; these include a web-based bar coding module which runs on existing scanner hardware and provides real time updates and enquiries on DRAMS data, and the new DRAMSFlow module which uses web services to interface between DRAMS and JDSL’s cask filling system. Keith Geddes highlights the benefits that DRAMSFlow has brought to the JDSL cask filling process: “The new system is far more stable, and we have better management over the cask filling process than we had before. DRAMSFlow does what it’s supposed to do, and it does it well”. Another area of improvement is long term planning, as Stephanie Macleod explains: “We had a very good planning tool within our old system, and that was identified at the gap analysis stage as a key feature missing from DRAMS. Trapeze worked with us to define the process and to make some improvements on the model we had used previously. The result has been a far more structured approach to long term planning and a planning process that is far quicker to execute.” Keith Geddes adds: “Trapeze has built on the long term planning process since our initial implementation, and it continues to evolve. Additional analysis tools are now being made available to us and we are sure that there are still further benefits to be gained.” Following a successful implementation, Trapeze has continued to work closely with JDSL to support the system. John Kerr: “Trapeze’s post-implementation support has been very good. When we raise an issue with the Aberdeen support team they are very helpful. When the issue has been addressed they send an explanation of what the problem was, how it was corrected, and how we can avoid it in future. Keith Geddes agrees: “After care and ongoing support has been great. The product is continually evolving. The annual user group event is excellent; it gives us an opportunity to share ideas with the rest of the DRAMS community, to see what future developments are coming, and to provide input regarding the product roadmap.”

System Overview

DRAMS Bulk Stock Control SystemApache Tomcat
DRAMScan Bar Code Scanning SystemMicrosoft IIS
DRAMSFlow Cask Filling ServiceBartech MC9090 / Windows Mobile 5
DRAMS Long Term Planning ModuleOpera Mobile
OpenEdge RDBMSWindows Server 2008 R2 VM Cloud
OpenEdge AppServer

2019 DRAMS User Group

Find out more

DRAMSPrint: barcode printing directly from DRAMS – DRAMS

Find out more

DRAMScan: Revolutionising Cask Management – DRAMS

Find out more

Ron Welsh on Long Term Planning – DRAMS

Find out more

Innovation: The More the Merrier – DRAMS

Find out more

Farewell to Graham Waddell, Whyte & Mackay – DRAMS

Find out more

Interview with Alistair Paton of Tomatin Distillery Co. Ltd – DRAMS

Find out more

Future proofing innovation in distillery software – DRAMS

Find out more

It’s here! Welcome to the new DRAMS website – DRAMS

Find out more

Creeping towards a technology cliff – DRAMS

Find out more

ERP alone is not enough! – DRAMS

Find out more

DRAMSPrint Label Printing: Available Now! – DRAMS

Find out more

Battling COVID-19: A Community Effort From Distillers Around The World – DRAMS

Find out more

Managing the Angels’ Share – DRAMS

Find out more

Innovation Live! The DRAMS Ideas Factory – DRAMS

Find out more

Using DRAMS to Support the Production of Denatured Spirit – DRAMS

Find out more

The DRAMS Guide to Cask Scanning and Labelling – DRAMS

Find out more

Key Question: How to manage spirit recipes and ingredients – DRAMS

Find out more

Key Question: How to manage distillery cask movements – DRAMS

Find out more

The Awakening of Irish Whiskey’s Long Time Sleeping Giant

Find out more

Introducing the latest DRAMS Module: DRAMS Business Intelligence – DRAMS

Find out more

Introducing DRAMS New Product Manager

Find out more

Effective long-term planning in the distillery industry – DRAMS

Find out more

2021 User Group Announcement: Updated Features in Core DRAMS – DRAMS

Find out more

The hidden costs of in-house developed distillery systems – DRAMS

Find out more

The DRAMS Solution Sheet – DRAMS

Find out more

5 Questions for Cask Scanning Suppliers – DRAMS

Find out more

The DRAMS Guide to Cask Scanner Hardware – DRAMS

Find out more

The Modern Master Blender – DRAMS

Find out more

An Interview with… Ron Welsh, Beam Suntory – DRAMS

Find out more

Key Question: How to keep track of distillery stocks – DRAMS

Find out more

Gamification: A growing trend in warehousing industries – DRAMS

Find out more

Custom ERP functionality for Distillery Management: Is it worth it? – DRAMS

Find out more

The Innovation Myth – DRAMS

Find out more

Key Question: How to find the right distillery software supplier – DRAMS

Find out more

Is RFID the future for distillery barrel management? – DRAMS

Find out more

Benefits of Scanning Solutions for Distillery Barrel Management and Warehousing – DRAMS

Find out more

Video: Updates to DRAMS TTB Reporting Features – DRAMS

Find out more

DRAMScan Solution Sheet – DRAMS

Find out more

Long-Term Planning: Balancing Today’s Inventory with Tomorrow’s Forecast – DRAMS

Find out more

An Interview with… Christine Leggat, Inver House Distillers – DRAMS

Find out more

The DRAMS Guide to Cask Scanning and Labelling – DRAMS

Find out more

Effective long-term planning in the distillery industry – DRAMS

Find out more

The Challenges of an Overdependence on Spreadsheets in Distillery Reporting – DRAMS

Find out more

Key Question: How to keep track of distillery stocks – DRAMS

Find out more

Wild Turkey Case Study – DRAMS

Find out more

North British Distillery Case Study – DRAMS

Find out more

John Dewar and Sons Case Study – DRAMS

Find out more

Glenmorangie: Distilling a Modern Success Story

Find out more

Introducing DRAMS Service Delivery Manager

Find out more

2010-2020: A Decade of Growth, Challenge and Opportunity for Irish Whiskey

Find out more

Mastering Evolution: Navigating Change for Seamless Transitions

Find out more

10 Million Barrels of Bourbon Ageing in Kentucky

Find out more

Barrel Scanning: Overcoming Implementation Challenges

Find out more

Introducing Gillian, DRAMS Implementation Consultant

Find out more

The Role of DRAMS in a Modern Distillery

Find out more

DRAMS is 100% focused on bulk stocks and distillery management. We understand that the movement and maturation of spirit is a unique process that demands a truly dedicated software solution. That’s why we first created DRAMS over 50 years ago – and we’ve been improving and expanding it ever since.

 

For more information about DRAMS and all our products and services, complete the form to speak to a consultant or arrange a demo.

 
 
Testimonials

What our clients say…

Whether your distillery is large or small, near or far, one thing remains the same: our clients love our software and support. But don’t take our word for it; here’s what
they have to say…

Branding Dots
Ron Welsh
DRAMS is a great inventory management system. It allows me to quickly analyse the stocks we have and what we can use it for; and allows us to easily allocate to future blends.
Master Blender and Strategic Inventory Manager, Beam Suntory
Christine Leggat
Every piece of spirit that moves within the business is captured within DRAMS.
Stock Controller, Inver House Distillers
John Kerr
The knowledge of DRAMS’ consultants – both of their product and of bulk stock processing as a whole – gave us a solid platform to work from.
Bulk Planner, John Dewar & Sons
Ron Welsh
You need to know exactly what you have and when it becomes of age to put into bottle. For this you require granularity of month by month data.
Master Blender and Strategic Inventory Manager, Beam Suntory
David Jordan
For any warehouse, any floor, rick and level, I can see what stock is there and how much space I have at the push of a button.
Maturing Inventory Manager, Wild Turkey