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

Hero Swish Reverse

The global demand for mature spirits has experienced a steady increase over the years. However that doesn’t mean that unforeseen circumstances can result in there being disruptions in the industry and supply chains across the globe, which may result in market uncertainty regarding both supply and demand.

There are, of course, localised examples of spirit production shortages, the result, in many cases, of a combination of external influences and a limited ability to respond to changing market stimulus.

The shortage of premium Japanese Whiskies serves as a prime example. The quality of Japanese Whisky has entered the consciousness of collectors and connoisseurs around the globe; these distilleries now face the challenge of servicing an increase in demand, demonstrating how production capacity decisions made as many as 15 years ago can haunt today’s ability to meet market requirements.

Similarly, the bourbon industry has not been left unscathed; the exponential growth in the global demand for the product compounded by a barrel shortage experienced in 2013 left many in the industry struggling to catch up. Impacting many producers within the industry, a variety of remedial efforts were made to extend product and brand lines including price increases and proof dilution.

Harlen Wheatley, the master distiller at Buffalo Trace, verbalised the challenges experienced during this time by stating that it was a race for supply to catch up with demand even as production levels continue to increase year on year.

While spikes in demand fuel the boom experienced by the spirit sector, it is not always the sole factor in supply shortfalls. Interruptions to the production process are likely to have a more significant influence on the ability to meet future demand.

For example, as the global climate crisis becomes ever more of a concern, its potential impact on one of Scotland’s key industries hasn’t gone unnoticed.

The prolonged heat and extended dry spell experienced in the summer of 2018 meant that even Scotland – known for soggy and temperate summers – experienced drought. As water levels fell so too did the production of Scotch in several distilleries up and down the highlands. The four-week pause in that year saw the production levels in some distilleries fall by as much as 300,000 litres.

The exact consequences of this water shortage in the Scotch industry are unknown and are unlikely to truly be felt for at least another year or so. But while it seems that the Scotch industry came through 2018 relatively unharmed, some environmentalists predict that similar heatwaves could arise every other year by 2050. If this came to pass, it would result in an environment change with significant implications for the Scotch industry.

These individual threats to spirit production are only compounded when the industry begins to consider the long-term implications of the disruptions caused by COVID-19.

With production currently scaled back or halted for many distilleries, and no clear end in sight, it becomes imperative that spirit producers consider the knock-on effects of the global pandemic to the planning and production requirements of the future.

 

Effective Planning Hinges on a Distillers Responsiveness to Changing Market Demands

 

Meeting the demand of today and seizing the opportunities of tomorrow is a significant challenge given the inbuilt delay in production caused by that most vital element of the process; barrel maturation. The outputs of today’s distillation efforts must spend years in barrels ageing to perfection before being ready for market.

It is easy to see why the endpoint of a barrel’s journey may be unknown when it is first filled and moved into a warehouse. Product lines change in response to market demands, so spirit destined for one product at initial distillation may find itself used for something else entirely when the warehouse doors are thrown open some years later.

This disconnect between the volume and types of spirits being produced and those that will ultimately be required for blending and bottling makes effective planning extremely difficult. Involving multiple business functions, the intrinsic complexities and high stakes of long-term planning leave little room for error, as the perfect co-ordination of distillation, wood selection, warehousing, blending, bottling and ultimately, distribution must be achieved.

Bridging this gap to ensure the most effective utilisation of each inventory item requires the analysis of three key data points:

  1. Current spirit inventory
  2. Forecast demand for each end product
  3. The spirit composition of those end products

Add to this an innate understanding of the impact of evaporation loss on maturing inventory, and it becomes possible to answer the two most important questions asked of any planner. The first, the volume of spirit required to be produced or purchased to satisfy end-product demands. The second, how inventory position and warehouse capacity will change over time as spirits are produced and consumed.

 

Making Advancements in Long-Term Planning

 

Spreadsheets have been a cornerstone of distillery data management and analytics for years, and for many distilleries, they continue to be an essential resource in the analysis of demand forecasts and spirit supply. To those not ‘in the know’, the complex spreadsheets used to support this analysis can seem like an art form mixed with black magic.

Using spreadsheets for this type of complex analysis can be a time-consuming yet ultimately limited approach, over-simplifying the modelling of supply vs demand, while risking costly data entry errors and creating a noticeable skill gap when an experienced staff member departs.

To combat these challenges, distilleries need technology systems which are specifically designed to perform this complex long-term analysis; accurately informing the decisions taken today to safeguard supply years into the future. The DRAMS Long-Term Planning module has been designed to do just that.

 

 Download the DRAMS Long-Term Planning brochure for a complete overview of the modules features and benefits. 

 

Key Benefits of Long-Term Planning with DRAMS

 

Leveraging the detailed spirit inventory and blend recipe (BOM) data contained within the system, DRAMS Long-Term Planning factors in constraints on production and warehousing capacity to provide a nuanced view of a distillery’s ability to meet future demand. The resulting reports equip the planner with the data – and confidence – needed to make high-stakes decisions, in some cases involving significant capital investment, and potentially altering the course of the business:

 

  • Adapt Production Plans: Understand precisely when and how much of each type of spirit must be produced to become of age exactly as it is required for bottling.
  • Adjust Product Recipes: Identify down to the month when inventory levels of a specific spirit type become inadequate to meet bottling requirements and make short-term changes to the product recipe to target spirits in surplus.
  • Quantify Purchase Requirements: Accurately identify the number of barrels and volume of third-party spirit required; enter into purchase agreements secure in the knowledge that you are neither under or overstocking.
  • Agree Sales Contracts: Identify and sell maturing spirit in surplus to generate revenue and free up much-needed warehouse space; sell future new make spirit to take full advantage of excess production capacity.
  • Rent Out Warehouse Space: See exactly how and when warehouse utilisation will change over time, and generate revenue by renting our excess storage capacity.
  • Justify Capex Funding: Validate the amount – and timing – of capital investment by identifying the exact point at which spirit production or warehouse capacity will be insufficient to meet future demand.
  • Redeploy Marketing Spend: When forecast demand simply cannot be met, change the demand; advise the business to redirect its marketing spend to shift the demand profile towards sustainable end products.

 

Providing a month-by-month holistic view of changing inventory positions in line with forecast demand, DRAMS long-term planning allows users to effectively manage inventory and plant utilisation across a horizon extending anywhere from 2 to 20 years or more.

Using a sandbox environment to run multiple data models, users can configure and adapt blend recipes and spirit selection rules, applying date effective changes designed to best utilise the available spirit and minimise costs. This flexibility enables users to address scenarios where a recipe will become unsustainable in future years as a result of a shortfall in component spirits.

Conversely, the system also identifies inventory currently in storage without a defined use-case. This spirit will continue to decrease in volume due to evaporation loss while simultaneously attracting warehousing costs. With this spirit identified, the business is then able to consider all possible options for its use, which can include the creation of a new product line or its sale to a third party, both of which would generate additional revenue and free up warehousing space.

When it comes to future production, the detailed insight into future spirit requirements provided by the Long-Term Planning module ensures that users are equipped to adapt production plans to meet future demand. For example, if the system identifies a need for greater volumes of five-year-old spirit seven years from now, the business may choose to begin investing in increased production capacity over the next two years, allowing production to increase in line with requirements.

This correlation between today’s production decisions and the ability of the business to meet far longer-term strategic goals is especially crucial for distilleries looking to incorporate more premium brand lines into their offering. Typically, this premiumisation is contingent on spirit age which means that distillers are required to lengthen the gap between initial spirit production and final bottling, narrowing the window of opportunity to remedy any inventory shortfalls.

Ultimately, DRAMS Long-Term Planning gives the user vastly improved visibility into the effects of changing demand and product lines on maturing inventory position over time, guiding and enabling proactive decision making. As production or storage capacities approach saturation, distilleries are armed with the insights required to support a business case for the commissioning of either new production facilities or warehousing. Alternatively, any periods of underutilisation are also revealed, allowing distillers the opportunity to sell any excess production capacity or warehouse space, consequently maximising all revenue streams.

 

Request a demo to learn more about the DRAMS Long-Term Planning module and how it can be used to support your future growth plans.

 

Request a Demo

Upcoming Webinar: Business Intelligence for Warehousing

Join us, as we discuss how you can harness data that informs your warehouse management and highlights your team’s performance.

Find out more
Agave Boom & Bust Cycle

Agave on the Clock: Overcoming Challenges in Tequila Production Planning 

Navigate the complexities of the agave boom and bust cycle can be a challenge. Learn how the DRAMS Long-Term Planning system can play a supporting role under these circumstances.

Find out more
Long Term Planning for Bourbon Distilleries

Driving Industry Growth: Long-Term Inventory Planning in the Bourbon Industry

Explore the rapid growth of the Bourbon industry and the crucial role of long-term inventory planning in meeting rising demand. Discover how advanced solutions like DRAMS Long-Term Planning revolutionise spirit inventory management, optimising operations and driving sustained growth for distilleries.

Find out more
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

Webinar Recording: 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
Titanic Distillers

The Awakening of Irish Whiskey’s Long Time Sleeping Giant

Discover the historic opening of Titanic Distillers, Belfast’s first whiskey distillery in nearly 90 years, at Thompson Dock. Explore the city’s rich whiskey heritage, the revival of iconic brands like Dunville, and the promising future of Irish whiskey production, fueled by significant investments and a growing market.

Find out more
Custom ERP Functionality

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

It is undeniable that an ERP system is an invaluable platform for managing the various processes which are essential to running a business. But that’s just it; an ERP handles the processes which are critical to ‘a’ business; but not the specific requirements of the matured spirits industry.

Find out more
Long-Term-Planning

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

Meeting the demand of today and seizing the opportunities of tomorrow is a significant challenge given the inbuilt delay in spirit production process production caused by that most vital element of the process; barrel maturation

Find out more
Benefits of Scanning Solutions

Benefits of Scanning Solutions for Distillery Barrel Management and Warehousing

Distilleries are embracing technology to enhance efficiency and streamline operations. Barrel Scanning solutions are one such technology solution which is growing in popularity, simplifying barrel management processes whilst allowing for greater flexibility and accuracy.

Find out more
Angels Share

Managing the Angels’ Share

As any whisky distiller knows, calculating maturation loss – the so-called angels’ share – is a delicate and complex task but fortunately, DRAMS has been designed with the ability to calculate this loss built in.

Find out more
Overdependance on Spreadsheets

The Challenges of an Overdependence on Spreadsheets in Distillery Reporting

In spirit production and distillery industries the versatility of the humble spreadsheets has proven invaluable when recording key distillery data either as a sole solution or in conjunction with another system. Yet despite the undeniable value they provide, they are not without their flaws.

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
Frank McNeil Q&A

Introducing DRAMS Service Delivery Manager

Meet Frank McNeil, DRAMS’ new Service Delivery Manager. In this Q&A, Frank shares insights about his experience so far, plans for the Professional Services team, and his approach to enhancing customer relationships. Learn more about his role and the team’s commitment to delivering exceptional service.

Find out more
Irish Whiskey Industry Growth

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

2010-2020 has been a decade of growth and revival for the Irish whiskey industry, but it hasn’t been without it’s challenges.

Find out more
Kentucky Bourbon

10 Million Barrels of Bourbon Ageing in Kentucky

95% of the world’s supply of bourbon originates in Kentucky, and as of 2021, the number of bourbon barrels currently ageing in distillery warehouses across the state surpassed 10 million.

Find out more
ERP is not enough

ERP alone is not enough!

ERP systems of course have their place, but they are no substitute for a specialised bulk inventory and distillery warehouse management solution.

Find out more
DRAMS Print

DRAMSPrint Label Printing: Available Now!

We are delighted to formally release our new DRAMSPrint module, which offers barcode label printing directly from within the DRAMS system.

Find out more
DRAMS COVID 19

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

It is undeniable that the first few months of 2020 have been bleak, however, the quick reactions of distilleries around the globe are a positive light in these dark times.

Find out more
Production of Denatured Spirit

Using DRAMS to Support the Production of Denatured Spirit

Learn more about how our Customer Care team have been working with customers to adapt their installation to support the production of Denatured Spirit.

Find out more
Guide to Labelling

The DRAMS Guide to Cask Scanning and Labelling

If you are looking into which cask scanning and labelling system (barcodes, QR codes or RFID) best suits your needs then this guide to cask scanning and labelling will point you in the right direction.

Find out more
How to manage spirit recipes and ingredients

Key Question: How to manage spirit recipes and ingredients

In this Key Question we look at how to manage spirit recipes and ingredients in order to to consistently meet targets that are in line with long-term production plans.

Find out more
How to manage distillery cask movements

Key Question: How to manage distillery cask movements

In this Key Question we look at how managers can manage distillery cask movements efficiently and effectively in order to run effective and profitable businesses.

Find out more
DRAMS Business Intelligence

Introducing the latest DRAMS Module: DRAMS Business Intelligence

Bringing advance analytics and real-time reporting to the distillery industry, we’re launching DRAMS Business Intelligence. The DRAMS BI module is a new report writing and dashboarding tool which integrates directly with the DRAMS system.

Find out more
Hayley McMinn Q&A

Introducing DRAMS New Product Manager

Introducing Hayley McMinn, the new DRAMS Product Manager. Recently promoted from within the DRAMS team, Hayley has a clear vision for the future of the DRAMS system and the ongoing development of our product range. Having settled into her new role, Hayley shares some details of her experiences with the company, along with her views on the direction of the DRAMS product range in a Q&A session.

Find out more
DRAMS Long-Term Planning

Effective long-term planning in the distillery industry

In this article we summarise the challenges associated with long-term planning in the distillery industry, and explain technology’s role in helping to meet them.

Find out more

The hidden costs of in-house developed distillery systems

It may seen counter intuitive but in-house developed maturing stock management systems are often more expensive than those bought from a 3rd party. In this article, we explain why that might be the case.

Find out more
DRAMS solution sheet

The DRAMS Solution Sheet

The DRAMS Solution Sheet is where you will find many of the features and benefits of using the DRAMS software system. System features looks at how DRAMS is used for warehouse management, blending and reporting for regulatory compliance.

Find out more
Questions for Cask Scanning Suppliers

5 Questions for Cask Scanning Suppliers

Cask scanning is a hot topic right now, but there are many ways to approach it. The answer you hear to these questions may help you find the right cask scanning supplier.

Find out more
Guide to Cask Scanner Hardware

The DRAMS Guide to Cask Scanner Hardware

If you are considering implementing a cask scanning solution, you may be wondering about the type of cask scanner to adopt. In this guide we discuss the different options available to you, and outline which we feel are best suited for a cask scanning operation.

Find out more
The Modern Master Blender

The Modern Master Blender

Brendan Flood, Director of Distillery Systems at DRAMS, explores the changing role of master blenders in today’s competitive market

Find out more
How to keep track of distillery stocks

Key Question: How to keep track of distillery stocks

In order for producers of spirits to consistently produce high-quality spirits, managers must be able to track distillery stocks and effectively handle the holding of all cased stock from its initial filling or receipt until it is removed from the warehouse or distillery site.

Find out more
Gamification

Gamification: A growing trend in warehousing industries

Automation and AI are undeniably driving results in warehousing and logistics. But how do you improve productivity without breaking the bank?

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

2019 DRAMS User Group

Our 2019 DRAMS User Group will took place in Glasgow on 6th June. Huge thanks to Whyte & Mackay for generously offering to host this event.

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