Retail

Retail supply chain software for enhanced supply chain efficiency, encompassing warehouse & transportation solutions, inventory control, and strategic/planning modules.

Four steps to achieving successful demand forecasting

Forecasting remains one of the top three issues suppliers face

26-Jun-2019
Four steps to achieving successful demand forecasting
The Grocery Code Adjudicator states that suppliers to UK grocery retailers deserve to receive timely and accurate forecasts. Its GSCOP code of practice defines what is expected, and its latest annual report[1] states that all regulated retailers achieved compliance.

Despite this, forecasting remains one of the top three issues suppliers face. The report highlights suppliers reporting poor forecasts from retailers, significant variations between forecasts and orders, and penalties for failing to meet service levels.

In part, the problem lies in the lack of definition of ‘a forecast’; even GSCOP does not make clear what it means. Consider the following forecasts:

  • An annual prediction of the volume of every product which will be purchased from a supplier (a joint business plan?)
  • A 3-month prediction of weekly product sales in store (a seasonal forecast?)
  • A 6-week aggregate weekly order prediction
  • A 14-day daily prediction of short-term product sales, allowing for weather and promotions
  • A 7-day demand forecast (not the same as a sales forecast, and more important to a supplier). Is this by depot?
  • An order, for delivery tomorrow

Which of these is the ‘forecast’ that GSCOP requires retailers to share with suppliers? Which of these is the most useful to the supplier? Which should be measured against actual orders to determine ‘forecast accuracy’?

Furthermore, the GCA June 2018 publication states that: “It was found that retailers adopted a range of approaches, and used the word “forecast” in a variety of ways. Some made a clear distinction between a forecast and an order; others did not see forecasting as a discrete activity but rather, as an integral part of supply chain management, often proceeding close to real time;”

So how can retailers and suppliers move forward?

The GCA’s Best Practice Guide [2] makes 17 recommendations to improve the current process. These include:

  • Closer collaboration between retailers and their suppliers
  • Regularly reviewing forecasting performance
  • Ensuring that suppliers are able to get access to supply chain or buying teams to share intelligence and discuss forecasts or orders
  • Ensuring that retailers have adequate systems and processes which learn from and take account of known or past issues
  • Ensuring that suppliers are able to access adequate sales data

The 17 recommendations in the GCA Best Practice Guide are all achievable - only if both sides can make better use of available data, and are willing to share and discuss insights in an easily accessible way.

As such, there are four critical elements to accurate demand forecasting that will help retailers not only comply with GSCOP and the GCA recommendations but, as a result, help transform supply chain efficiency, availability and waste.

Data at a granular level

A forecast’s purpose is to help ensure suppliers meet order expectations, therefore it is important they receive forecast order volume at a granular level of detail: · By product (not by category, and not a total) · By day (important for short-life goods and/or just-in-time logistics) · By depot (essential for appropriate inventory in the right part of the country)

Without this, any other ‘forecast’ is at best a guide to what might be required and when, but won’t help the supplier ensure that appropriate inventory is in the right location at the right time so that orders can be fulfilled to high service-level targets (typically 98% or above).

The ability to quickly interpret data

Some suppliers have hundreds (even thousands) of products going into multiple depots each day. Not only do they need accurate data, but they need to be proactively alerted to changes in forecast.

Analysing changes is time consuming and opportunities can easily be missed. Instead, suppliers need to be able to react quickly to rectify predicted stock-outs, poorly performing promotions and despatch issues.

The data that is supplied by retailers on a daily basis does not include alerts, analysis or trends. As a result, many suppliers have developed complex spreadsheets to extract the data and provide some analysis, but generally this relies on the knowledge of one or a few people at the supplier. Those complex spreadsheets, by their very nature, are open to error.

Data warehouse or BI software provides an alternative to spreadsheets, but the views of the data have to be specified, built and maintained, and often the knowledge is - again - held by one or a select few people in the supplier’s business. A system in place whereby state-of -the art visual analytics are presented, daily for anyone in the business to see and interact with, allows key interventions to be made with confidence and ease.

Consistency of definition

Forecasting at SKU level by location is critical to most suppliers, but forecasting at the category level may be enough for some retailers. Even those who forecast to SKU level often don’t distinguish between locations or even channels, so a forecast to a retail buyer may simply be a quantity over time, whereas a “good” forecast for suppliers is much more granular.

Retailers and suppliers may use different coding for the same SKU. Suppliers may supply in different units of measure to that used at the retail end. (Cartons instead of units, for example). Suppliers and retailers could even give different names to the delivery depots and branches. All of which make comparing retailer data difficult - both across retailers, and also with your own internal metrics and reports.

It’s really important, therefore, to be able to transform the data provided by retailer into a format that is clear to the supplier. It is only then that the business can make smart and informed decisions that will impact their business.

The ability to challenge forecasts and collaborate

Suppliers can be subject to penalties for not providing the right goods at the right time to the right place. But if the retailer forecast is so short-term or inaccurate that the supplier cannot react, then both parties have an issue. It is imperative that suppliers and retailers forge trusted partnerships which encourage mutually beneficial collaboration.

Similarly, under GSCOP rules, the “retailer must fully compensate the supplier for any cost incurred by the Supplier as a result of any forecasting error in relation to Grocery products”.

So, how should that collaboration take place?

In order for any discussions to take place between retailers and suppliers, there first has to be a trusted source of common data from which to work. In addition, that data should be “humanised” – in other words be presented in a format that is easily understood by both parties. Finally, there has to be a means of sharing that data online as the retail buyer and supplier are likely to be in different locations, which would ensure both parties are ‘singing from the same hymn sheet’.

With this shared view of the data, the supplier can help the retailer to: · Make tactical proactive decisions and interventions on orders and stock levels · Plan and optimise promotions · Review forecasts based on accurate analysis

The net result of this can be seen as: · Fewer stock-outs, improved sales for both parties · More accurate forecasting leading to less waste for both (particularly fresh produce) · Improved service levels and availability

Conclusion

When it comes to achieving successful demand forecasting, we need to eradicate the concept of the supplier vs the retailer. Taking a step back and looking at the bigger picture, both need to realise that it is only through fostering a mentality of genuine collaboration, that everyone can benefit. A platform which both supplier and retailer have full visibility of SKUs and access to key daily information with ease is a must. In doing so, genuine relationships can be built and changes in forecast reacted to with minimal disruption.

By using best-practice visual analytics tools and techniques, supply-chain and sales data can be blended to highlight indicators for demand (such as sales spikes, low-depot stocks etc.), and provide an easily understood picture of recent and historic sales patterns.

In an increasingly competitive retail environment, those retailers that can provide accurate forecasts to their suppliers, will benefit from more efficient supply chains, lower costs, better availability, and happier customers (and a happier Grocery Code Adjudicator).

Replenishment As A Service (RaaS): A New Approach To Customer Retention

Research shows that acquiring new clients is six to seven times more expensive than retaining the ones you have.

Figures reveal mobile pallet could release 600,000 staff hours into UK convenience stores

The figure is revealed in CHEP UK & Ireland’s new guide which assesses the current challenges facing the sector.

Half of UK CIOs & CTOs invest in in-store digital capabilities to replicate the convenience of online services

New research by REPL Group reveals UK retail CIOs & CTOs are investing in up-to-date pricing and quicker payment options in-store.

REPL Creates Workforce Management Function in Microsoft Teams to Drive Employee Engagement

REPL integrate JDA Workforce Management with the Microsoft Teams interface to allow access to almost real-time employee information

Coop Sweden to Improve Availability and Reduce Waste with JDA

Leading Swedish grocery retailer to deploy JDA’s Category Management solutions to allocate space & localize planograms across 800+ grocery stores

Eco-conscious shoppers expect retailers to foot the bill for greener deliveries

Most British shoppers want eco-friendly online deliveries, but six in ten (62%) will not pay any extra for them

Cover Genius delivers for ShipStation’s global merchant network

ShipStation partners with global insurtech to offer merchants customer-centric insurance solutions

Honeywell Helps Apparel Logistics Group Triple Daily Output from its E-Commerce Distribution Center

Honeywell announced agreement to help the retail supply chain services provider via automated material handling solutions.

Bureau Veritas Advises the Food Industry to Lead On Sustainable Procurement As Demand Grows

Record numbers of consumers turn away from firms with a negative environmental and social impact

Boxing smart to slash carriage costs

Over-sized boxes often distresses consumers and at the same time shippers pay excessive charges to ship fresh air.

LC Waikiki Leads the Fashion Pack with Infor

Global Fashion Retailer Invests in Infor CloudSuite PLM for Fashion to Boost Agility and Drive Rapid Growth

Manhattan Associates and Newmine Partner to Advance Unified Commerce

Newmine joins the Manhattan Value Partner (MVP) program of leading supply chain and logistics, inventory, and omnichannel commerce providers.

Meyer adopts new HMRC Customs Declaration Service with Descartes

Meyer, the UK's largest kitchenware supplier and importer, has been one of the first retailers to successfully transition to the new HRMC (CDS)

Atos to migrate the infrastructure of international retailer Damart to the cloud with Google Cloud

A 6-year contract for digital transformation combining Google Cloud Platform (GCP) and Atos’ Digital Private Cloud platform/

REPL supports BP to drive a global Retail Site transformation programme

New cutting-edge head office, back office and stock management system to operate in thousands of BP retail stores globally

Manhattan Associates and BRP Consulting Work Together to Deliver Next-Generation Unified Commerce Platform

The new partnership to deliver next-generation omnichannel and point-of-sale solutions that aid seamless, holistic shopping experience

Imagination Park Acquires Key Patents for the Augmented Reality Industry

Patent Portfolio Covers Augmented Reality and Location Based Games

IBM comes to offline retailers’ rescue with smart mirror technology in India

IBM is working on smart mirror technology to enhance the shopping experience and facilitate informed decision making for offline retailers

Retail Technology Firm Wins Queen’s Award for International Trade

REPL Group has today been announced as a winner of the prestigious Queen’s Award for Enterprise in the International Trade category.

Zorro Abarrotero Optimizes Space Plans with JDA

Leading Mexican retailer implements JDA Space Planning to enhance information processing and customer experience

Wincanton wins eFulfilment brief for Homebase

Full carrier management service to drive positive customer experience

JDA and Panasonic to Establish Joint Venture Company in Japan

Strategic agreement aims to expand provision of companies’ joint solutions to optimize factory, warehouse and retail digital supply chain operations

Ubamarket partners with Henderson Technology bringing in-store innovation to retailers and shoppers

Ubamarket has announced an innovative partnership with Henderson Technology

Ardene's Store Expansion Supported by Connected Retail Technology

Sensormatic Solutions offers wide range of loss prevention options and insights to address varied needs in more than 375 fast-fashion retail locations

Delivering the Future: FedEx Unveils Autonomous Delivery Robot

FedEx SameDay Bot is an Evolution for Same-Day, Last-Mile E-Commerce Deliveries

Mixed Place integrates Mixed Reality content at two of Europe’s largest retail chains

After completing projects with Billa and Ahold-Delhaize, the company is now preparing to raise $7 million to market its technology globally

Spotlight on traders in retail: AEB hosts global trade business lunch at Retail Week’s LIVE

VIP Business Lunch on Wednesday, March 27, 12.40 – 1.40pm: “Dynamic global trade environments – what’s the key to success?”

Ryder Disrupts E-Commerce Industry by Enabling Manufacturers to Go Direct to Online Consumers

Ryder’s alternative to third-party marketplaces delivers 270% volume increase with 99.9% on-time delivery in peak season for a global manufacturer

What impact has technology had on the way we shop?

Technology and the internet have already drastically changed the shopping industry, but what does the future hold?

Retail spending bounces back in December but UK retailers faced a tough festive period

Retail spending bounced back in the UK in December 2018 after a tough November as GlobalData’s total retail index rose by 11.5 points

What’s in Store for Retail in 2019? Manhattan Associates Makes its Top 5 Predictions

Shoppers becoming ever more demanding and retailers under pressure to deliver the seamless service experience consumers crave

New JDA Survey Finds Retail C-Suite Embracing AI and Edge Technologies to Improve Customer Experience

New JDA Survey Finds Retail C-Suite Embracing Artificial Intelligence and Edge Technologies to Improve Customer Experience

Manhattan Associates Elevates In-Store Customer Service with Expanded Customer Engagement Solution

New Enhancements Give Store Associates the Tools They Need to Deliver a Consistently Outstanding Customer Experience

Theatro and Honeywell to Develop Enterprise Wide Mobile SaaS Solutions to Empower the In-Store Workforce

Honeywell to resell Theatro SaaS Services to provide a seamless service experience across Honeywell’s Mobility EdgeTM devices and Theatro’s IoT

Tinyclues Leads AI-first Transformation of Retail Marketing

Retailers using AI have measured on average 79% higher campaign revenue and a 51% increase in customer engagement

Zebra’s Mobility DNA Suite Achieves Oracle Validated Integration with Oracle Retail Store Inventory Management

Unified solutions streamline staff communications, device manageability and improve in-store associate productivity

Showcasing Leading AI and ML Solutions, JDA Predicts “What’s Next in Retail”

JDA will showcase how AI/ML helps retailers reimagine customer experiences featuring RaceTrac, bonprix and Morrisons

PR Agency One appointed to help Dutch retail software expand in UK market

Manchester's PR Agency One has just been appointed to help Omnia Retail, a pricing software for retailers, to launch itself within the UK.

Retailers must 'go the extra mile' to overcome inefficient and unprofitable delivery models

Capgemini global study finds 3 in 4 customers would increase spend and be more willing to try new offerings in return for satisfactory online grocery

JDA and InContext Solutions Partner to Provide the Next Generation Retail Merchandising

Combination of InContext’s mixed reality solutions and JDA’s category management solutions empowers in-store retailers

Christy Sports Selects Jesta I.S.’ Foundational Omnichannel Platform to Support Its Growth

One of the largest winter sports specialty retailers in the U.S. implemented Phase One of Jesta I.S.'s end-to-end foundational retail suite

itim presents its pricing and promotions software for retailers

UK retail software vendor, itim, is launching new cloud-based pricing and promotions software in 2019.

Atheon Analytics announces SKUtrak Developer: custom visual data analytics service package

SKUtrak® Developer unlocks advanced business insight by combining retailer and supplier data sources delivered through best-practice visual analytics

Simple driverless transport for quick retail returns

An online retailer’s profitability will stand or fall on having time- and cost-effective returns management.

Retail Stores Still Important for Holiday Shopping Experience

In-store shopper numbers for Black Friday week saw year-over-year improvement

Retail supply chain management and the rise of fast fashion

From the incredible pace of turnover in style trends to the excess waste it produces, today’s fast fashion phenomenon is a controversial topic

Discerning shopping tastes of younger generation around Black Friday revealed

69% of younger shoppers expect customer service to improve during the period, highlighting a desire for a positive experience

Christmas From the Couch: Why Retailers Should Pay Attention to ‘Sofa Sunday’

The Day Before Cyber Monday Plays an Important Role in Influencing Consumers’ Holiday Shopping Behavior