North British Distillery Case Study – DRAMS

Hero Swish Reverse

The North British Distillery is one of the largest Scotch Grain Whisky producers in Scotland, managing around 1m casks in total. Operations are spread across various sites that include a distillery in Edinburgh; and warehousing facilities in Edinburgh, Muirhall, Livingston, Broxburn, Paisley, and East Kilbride. The Muirhall site is the main warehousing facility.

Ensuring this vast and disparate operation remains effective are two constants: Dave Smith (pictured right) who, as Stock Controller, is responsible for managing this produce; and the DRAMS system he relies on to do so.

 

 

Given that managing casks across multiple locations is an increasingly common challenge (“As everyone is aware, warehouse space is at a premium,” says Dave), we spoke with Dave to find out how he does it.

Dave Smith has worked at North British for more than 40 years and is a well-known figure within the industry. While his official title is Stock Controller, to the DRAMS team he fulfils another crucial role: we tend to refer to him as a ‘Superuser’ – that is, someone who knows the DRAMS system inside out; using this knowledge to improve operations and feeding into future product developments.

North British adopted DRAMS in 2008, replacing an AS 400 system that was becoming difficult to support. “Before we took on DRAMS we were of course all used to the AS 400 system functionality and there were a few concerns relating to the ability of DRAMS to access detailed data quickly enough. This proved to be totally unfounded,” says Dave. “In DRAMS it is easier to slice, dice and pull information. We have access to data in a way that was impossible before – and the ability to produce spreadsheets is done easily in a way that was not possible on the old system.”

“There are a number of excellent facilities on DRAMS but one of the most important elements that is used regularly is the palletised warehouse overview,” Dave continues. “We have a large amount of palletised stock, and DRAMS offers a graphical overhead view, so you can drill down to see exactly what’s in each pallet. This is vital for us: we have 10 DRAMS user licences across the business and most people will be using this view regularly.”

Interestingly, this feature was developed through collaboration between the DRAMS team and North British, says Dave: “We actually got this feature added to the system, and I would say it has been just as much of a benefit to the DRAMS team and other customers as it has to us.”

 

 

From a DRAMS point of view this is an extremely positive message to hear. After all, working closely with clients to build new functionality – and then passing new developments to other clients as part of the expanding core product – is a central part of the DRAMS product roadmap, and wider strategy to help our customers become successful.

But let’s return to Dave and his Superuser status for a moment. We wondered if Dave recognises the term and what it means to him. “Well, I did kick off DRAMS here and I’m the person here who knows the most about it. I am currently passing on this knowledge to my immediate team and the other DRAMS users to create the super users of the future!” he says.

“DRAMS is very powerful; people don’t realise the vast level of detail it holds, and it’s good to be able to bolt on additional modules where needed,” Dave continues. “DRAMS is central to everything we do and we’d be at a loss without it. If it stopped working tomorrow I’m sure we could survive for a little while with the paperwork – but there wouldn’t be many happy people here!” he jokes.

As Stock Controller, Dave has a team of three people: two are responsible for the day to day running of the Stock Control Department, and the third is a stock checker responsible for checking stock on a continual basis. “We used to do a random 10% check over a three-year period, but we are now doing a 100% stock check every year,” Dave reveals.

Clearly this is a significant – and impressive undertaking. “This provides comfort and reassurance to HMRC and to our customers,” says Dave, referring to the fact that North British manage casks for a number of customers. “Through this process we can demonstrate that our stock records are completely accurate and compliant.”

This level of commitment has very obvious benefits for North British: “Part of my job is to manage orders; when a customer needs a cask, we know exactly where it is, so we can find it and remove it. It’s accurate and saves a lot of time,” Dave concludes.

 

 

Clearly the DRAMS system – and of course Dave’s extensive product knowledge – is central to this process, but it goes further: “We also manage the buying and selling of stock; as well as producing  invoices for warehouse rent for each customer. All this is managed through DRAMS and the system holds complete audit trails for all transactions,” Dave says.

Another big element of DRAMS is the communication with customers: “We have various interfaces with customers, from sending stock details to individual cask details to customers,” Dave explains. “We also have a bespoke interface with a major customer: We send the customer filling/ individual cask details and rent invoices as well as various stock reconciliation position details. The customer is able to input this data into their stock system allowing them to see the position of their stock in our warehouses. This helps them with the ability to manage their stock held by North British.”

“The interfaces with this customer have been in place for a number of years and have been enhanced at various times in line with changes to business requirements. These interfaces work very well and are of benefit to us as well as our customer,” Dave concludes.

This is another example of the DRAMS team delivering functionality to meet customers’ specific requirements: “As with anything we’ve asked the team for, the system they have put in has worked well,” finishes Dave.

Speaking to Dave, it is clear that the relationship he has with the DRAMS team is built on trust and respect. “The relationship is very good,” agrees Dave. “The DRAMS team know what we are looking for; they know what a warehouse looks like and what happens there! – so the system isn’t built only from a developer’s point of view. That was a big bonus when we chose DRAMS and remains the case today.”

Looking ahead, that relationship is set to further improve, given than North British have offered to host the 2015 DRAMS User Group. “We’re one of the major DRAMS clients and we are delighted to host the event,” says Dave. “After all, DRAMS is all about Stock Control and warehousing and we certainly have the warehouses and lots of stock in them!”

Features of a Distillery Software Solution

Features to Look for in a Distillery Management Solution

Selecting the right distillery management solution is crucial for efficiency, compliance, and profitability. Learn what features you should expect your chosen solution to offer you to operate to the highest standard.

Find out more

Webinar Recording: Best Practices for Implementing Barrel Scanning

Access an exclusive 40 minute webinar recording that delves into the best practice of implementing Barrel Scanning software. Originally hosted live in April 2023.

Find out more
Webinar: Long-term Planning

Upcoming Webinar: Long-Term Inventory Planning

Register for our webinar on long-term spirit inventory planning, hosted by Brendan Flood of DRAMS. Gain valuable insights and receive a recording if you can’t attend live. Sign up today!

Find out more
Long-Term Planning Brochure

DRAMS Long-Term Planning Brochure

Download the DRAMS Long-Term Planning Brochure now and equip your team with the tools they need to make strategic decisions that will drive your business forward and join the ranks of successful spirit producers who trust DRAMS for their long-term planning needs.

Find out more
Wood Management Use Case

DRAMS Wood Management Use Case

In this Use Case we explore how a fictional distillery utilised DRAMS Wood Management to cut their annual cask purchase budget by 15%.

Find out more
DRAMS ERP Integration

DRAMS ERP Integration Process

At DRAMS, we understand the critical importance of seamless integration with your ERP systems. Download our brochure to learn more about how DRAMS enables you to have a smooth integration of our software alongside your current ERP solution.

Find out more
Core DRAMS Product Guide

Core DRAMS Product Guide

Download our core product guide to discover how DRAMS can streamline your operations, enhance compliance, and drive efficiency.

Find out more
Basics of Distillery Management Software

FAQ’s – The Basics of Distillery Management Software

Navigating distillery management software can be daunting. Learn how this specialised system benefits spirit producers by optimising operations, ensuring regulatory compliance, and improving batch quality.

Find out more

DRAMS Services Brochure

Understand the various additional training courses available with DRAMS by downloading our Services Brochure.

Find out more
DRAMS BI Use Case - Rejected Barrels

DRAMS Business Intelligence Use Case – Rejected Barrels

Take a look at a situational use case relating to rejected barrels and how DRAMS’ BI module can play a more informative role in the matter.

Find out more
DRAMS BI Use Case - Anticipating future spirit shortfalls and surpluses.

DRAMS Business Intelligence Use Case – Forecasting Future Spirit Production

Take a look at a situational use case relating to future spirit demand and how DRAMS’ BI module can help address this issue.

Find out more
DRAMS BI Use Case - Hours of resource re-deployed to identify and locate missing barrels

DRAMS Business Intelligence Use Case – Lost Inventory

Take a look at a situational use case relating to lost inventory and how DRAMS’ BI module can provide a real-time view to resolve the problem.

Find out more
DRAMS BI Use Case - Lack of inventory visibility leads to missing finishing casks

DRAMS Business Intelligence Use Case – Missing Finishing Casks

Take a look at a situational use case relating to lack of finishing casks and how DRAMS’ BI module can help prevent this issue.

Find out more
DRAMS Product Brochure Cover

DRAMS Product Brochure

For a complete guide on what DRAMS offers and the benefits we can provide to your barrel inventory management, download our Product Brochure.

Find out more
DRAMS Business Intelligence

DRAMS Business Intelligence Product Guide

For a more information into how you could boost operational efficiency and discover growth opportunities with DRAMS BI, download our comprehensive product guide.

Find out more
Tequila Transformation

Tequila’s Transformation: From Party Spirit to Premium Beverage

Tequila has undergone a remarkable transformation in redefining it’s image in recent years. One contributing factor to this growth is a seismic shift towards premiumisation.

Find out more
Barrel/Cask Wood Management

Wood Management: Enhancing Maturation and Operational Efficiency

DRAMS Wood Management is tailored to maximise the potential of every barrel. Gain control over performance by tracking each cask’s lifecycle from receipt to retirement, including dump and fill cycles and repairs.

Find out more
Navigating Change for Seamless Transitions

Mastering Evolution: Navigating Change for Seamless Transitions

Navigating change involves transparent communication, strategic implementation, ensuring employees are engaged and supported throughout the process for optimal adoption and success.

Find out more
Barcode Scanner

Barrel Scanning: Overcoming Implementation Challenges

Being able to overcome challenges in implementing scanning solutions for distilleries ensures streamlined operations and enhanced product traceability in the dynamic distillery landscape.

Find out more

The Awakening of Irish Whiskey’s Long Time Sleeping Giant

Find out more

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

Find out more

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

Find out more

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

Find out more

Managing the Angels’ Share – DRAMS

Find out more

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

Find out more
DRAMS Scan Cask Management

Video: DRAMScan – Revolutionising Cask Management

DRAMScan: a cask scanning module for the DRAMS distillery management system that dramatically simplifies the process of recording cask locations and movements. DRAMScan can vastly improve your warehouse management with an integrated barcoding system.

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

10 Million Barrels of Bourbon Ageing in Kentucky

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

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

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

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

Find out more

Gamification: A growing trend in warehousing industries – 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

DRAMS Scan Solution Sheet

Find out more

An Interview with… Christine Leggat, Inver House Distillers – 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 Gillian, DRAMS Implementation Consultant

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

Creeping towards a technology cliff – DRAMS

Find out more

An Interview with… Ron Welsh, Beam Suntory – DRAMS

Find out more

Innovation Live! The DRAMS Ideas Factory – DRAMS

Find out more

2019 DRAMS User Group

Find out more

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

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
Rab Sorman
I know where every spirit is, how it’s maturing, and how it fits into the bigger picture… this plays a crucial role in future blends
Whisky Stocks and Blending Manager, Glenmorangie
Alistair Paton
It does make such a difference talking to knowledgeable people who have years of experience dealing with our specialised industry and who are always prepared to go the extra mile.
Project Manager, The Tomatin Distillery Co.
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