• Home
  • Diver BI Group
    • Diver | BI
    • Customer Commendations
    • Videos
    • Case Studies
    • Documents and Brochures
    • Diver BI Group Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
    • Ask Anthony
  • The Team
    • Key Experts
    • Members
      • Dynamic Business Informatics
      • Envisage
      • Chartwell IT
      • Cloud-Works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pharma IT
      • Pinnula
      • Formell
      • IBI
    • Partners
      • Dimensional Insight US
      • Dimensional Insight EU
      • Dimensional Insight Asia
      • DI Panama
      • ID Technology (Brazil)
      • Infotool (Nordic Countries)
      • BIMAXIS – DI France
      • Vision IT
      • KDE Group (Israel)
      • Zight -Partner for Transport
      • 24/7 Uptime
  • Applications
    • Property
      • Property Prices Portal
    • Supply Chain
      • Retail
      • Distributor
      • Wholesale
      • Manufacturing
      • Produce
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • Autoparts
      • Transport
      • Public Transport
      • DI Program Advisor
    • Healthcare
      • Healthcare
      • DI Surgery Advisor
      • DI Physician Performance Advisor
      • Pharma BI Applications of Diver
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile & SaaS
      • Diver BI SaaS
      • SaaS for Sales Gap Analysis
      • BI designed for Tablet
      • DiveTab – Mobile BI
    • Diversity
      • Travel & Tourism
      • Colleges & Universities
      • Waste Management
      • Parking
      • Telecom Brokerage
      • Economic Trends
      • Maps
      • Smart Meters
      • Carbon Emissions Management
  • Workbench
  • Contact
    • Free Consultation with One of Our Experts
    • Add a New Revenue Stream as a Partner

DiverBIGroup

Business Intelligence Experts

Diver BI Group Blog Stocking for Seasonality – Core Availability

Stocking for Seasonality – Core Availability

14th August 2017

When your stock runs into thousands of SKUs (Stock Keeping Units) you often resort to blanket business rules and statistical methods that work for some items but not for others – intermittent demand items for example. One area of inventory management that affects many businesses we work with is seasonality.

To be really on top of your stock and hit that sweet spot of not holding too much inventory, and at the same time being able to meet demand, fulfil customer satisfaction levels and not lose out to the competition, you need to be constantly reviewing and amending your inventory accordingly.

One measure used by a number of our clients is to calculate “weeks’ cover” by taking the historical sales quantities from a previous relevant sales period and deriving a weekly sales average over that sales period – which you then divide into your Stock on Hand figure. But if you have seasonality in your product range you need to be very careful when choosing the historical sales period upon which you are basing your weeks’ cover calculation.
plants for shipping

Whilst training some users in the Market Gardening sector recently I noticed that it was hugely more complex when it came to varieties of Summer Bedding Plants or hedging. Even within a relatively small category there were variations of seasonality that could make a huge difference to determining stock availability based only on weeks’ cover for the category as a whole, using the same sales period for all products in that category as the basis for the calculation.

When products are so seasonal and perishable (must be planted after a certain date due to frost or before another date for best root formation) it can make huge differences to the bottom line if you have to throw out stocks of pot bound plants or packets of spring bulbs.

WHERE DO YOU START?

Well our advice is that you begin by putting the most effort into setting up key reports that analyse as accurately as possible the Core Products that give you the most profit year on year. Typically we know from experience that the products that give you say 50% of your profit might only comprise 10 or 20 % of your product list.  If you can get this part right, then the less profitable and possibly the biggest part of your inventory can be analysed with more generic methods.

USING THE EXPERTS IN YOUR BUSINESS

With seasonal products especially it makes a lot of sense to call upon the product experts that you already have within your organisation – the people who have experience in managing product categories and meeting the demand for products from your customers in their areas of expertise. This knowledge, when used in conjunction with some automated techniques that have been developed for breaking down large inventory lists into groupings, is crucial for a business when beginning to design automated routines.

expert giving advice

ABC ANALYSIS ON PROFITABILITY

Using a technique such as “ABC analysis on profitability” as a starting point, you can divide your data into key products and the rest (there are a number of ways of doing this – ABC analysis on profitability is just one).  ABC analysis looks at sales history of your products over a defined period of time, sorts them high to low on profit delivered and categorises the products into groupings or bands A, B, C, D,  Z and New. These bands come from predefined thresholds of the % of total profit each band has delivered in that sales period – often 12 – 18 months. So for example, the top 20% of profit could have been delivered by 10 products (Band A), the next 30 % by 200 products (Band B) and so on. Z Class delivered no profit in the historical sales period – typically this could be one of the biggest classes, and New would be the latest products with little history.   It is important that the results of a first pass at this automated routine should be sense checked by someone (or a number of people) with knowledge of their respective category(s).

Once a core range has been defined, then within only that core range start focusing on the data that is seasonal currently or will become so – i.e. well in advance of the lead time.  You can then set up rules for lead times and calculations of weeks’ cover based on the correct seasonal historical sales period so that your averages are based on a like-for-like period.

This ABC analysis itself could be set up so that it runs against seasons if your business is extremely seasonal.

You can also look at the average number of sales units of a particular product by transaction to get a feel for e.g. what are the number of plants purchased for an average hedge.

magnifying glass

By using your in-house experts and walking through the steps of how a category manager would manually proceed to work out seasonal stock requirements you can incorporate these steps as business rules in your reports – and these will probably be distinct for the different types of products you sell.

So by putting in the effort at the point of grouping your data into Core Products and within those, the seasonal products, you can begin to define much more accurate and focused reporting which, once set up, can be run automatically and used regularly at the appropriate time of your sales year.

Of course there may be ongoing variations and tweaks to be made, depending on local knowledge about events and external influences such as weather or competition, but you will have a foundation on which to build. You can incorporate other data sets into your analytics (using an integration tool such as the Diver BI Visual Integrator within Workbench) that will help you to build a more complete seasonal picture. This will allow you to look for correlations in events, weather patterns and sales peaks or troughs that your internal experts might be able to pick out as causations for sales, thereby creating further reliable rules for future patterning.

Even with specialist forecasting software that takes into account seasonality and slow moving products it always takes human involvement and expert product knowledge to manage the first pass of the forecasting algorithms and tweak the results regularly.

EXPERT REPORTING

The key aim of this type of report is to create analysis based on both the type of number crunching that only computers are capable of; and incorporate the expertise, the sense checking and context definitions that only someone with experience of your business has the knowledge to include.  This type of “Expert Reporting” is the best way to achieve winning results.

We have seen that where companies have made this effort they are reaping the rewards with increased sales.

See the recent related blog on the importance of understanding the context of data by Kathy Sucich from DI. http://www.dimins.com/blog/2017/08/07/the-downside-of-data-science/

About Debbie Lonsdale

Debbie Lonsdale
Debbie Lonsdale has been working with the Diver Solution as a BI Consultant at Dynamic Business Informatics since 2008. Her previous experience includes computer programming, analytical and technical roles, team management, account management, sales and marketing in a variety of market sectors, including the Travel Industry and Distribution. She combines this experience as an all round ICT professional in the BI sector.

Tags: diver bi sales, diver bi stock, inventory management, seasonality, stock control

Articles

  • News
  • Accolades
  • Blog
  • Ask Anthony
  • Diver | BI
  • Customer Commendations
  • Videos
  • Case Studies
  • Documents and Brochures
  • Diver BI Group Privacy Policy

Dynamic Business Informatics Ltd

Distributors of The Diver Solution & Diver Platform, providing business consultancy services, products and applications derived from the Diver Solution & Diver Platform.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. See our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

Accolades

  • Dimensional Insight Named an Overall Leader by Dresner Advisory Services in 2022 Industry Excellence Awards
  • Dresner Wisdom of Crowds 2022 – Best in Class Results
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Earns Top Marks in 2021 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2021

Copyright © 2023 Diver BI Group · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT