Report • 16.02.2011

Analysis and projection automate inventory flow

Empty shelves are just as bad as non-saleable surplus. That’s why commercial enterprises place ever stronger demands on logistics. Ordering times are shortened. At the same time, retailers are trying to better forecast future demand of products by implementing analysis and forecasting software. The starting point however is a working inventory management. The goal is an automation of ordering processes as extensively as possible.“

The modernization of an existing IT landscape is not easy. This is illustrated for instance by the Lunar-project by Edeka. The members of the cooperative have already spent more than 200 million Euros for the IT standardization based on SAP. They have worked for several years on this project. Other retailers are also dealing with drawn-out IT projects.

But IT is not just a question of software and hardware. Oftentimes new IT projects are tied to drastic changes in one’s own organization. It also depends on the employees who are intended to use the new support. Today such an in-house change is called “change process“. You need to motivate your employees, so that they don’t experience this change from the familiar as an abrupt upheaval. It is about the love for learning versus the fear of something new.

Small specialty retailers have a much tougher time with this. They are experts of their products, but they are not IT specialists. But they are aware that they cannot keep up with today’s competition with their 10 or 20 year old solutions. They realize that they need to invest. They know this, but they don’t know how to do it, because for the most part they don’t have an IT department at their own store. Some have “home-made“ solutions which reach their limits.

In-house solution or standard software

Those who have their own in-house solutions depend on someone being in their store to be proficient in it. External assistants often find it difficult to see through these patterns. In light of this, it’s not surprising that lately more and more retailers choose standard software they have adapted to their store. Standard software already has interfaces to all trade relevant IT systems, so that an integrated IT landscape is created. Many retailers believe however that particularly for them some special features need to absolutely be incorporated into their software. And this works just like at a car dealership: extras cost extra.

Is it cheaper to adapt the software to a company or to adapt the company to the software? The answer is not an easy one. Programs certainly can be changed much easier. Those whose processes deviate considerably from standard solutions should ask themselves whether their own structures are still current. After all, standard solutions are not inflexible cookie-cutter offers. The service providers continuously adapt them to the conditions in the particular industry sector. The conditions – those are the average requirements of the clients.

Inventory management is the basis

Today’s customers are less loyal than in the old days. They are well informed about products and pricing like never before. They buy at local businesses, online and in the future per smartphone. Time to market becomes a key success criterion for retailers. Time to market – that’s the lead time you need until a product design finally hits the market and doesn’t just cost money, but also makes some. Time to market on the one hand means one’s own investment decisions in new hardware, software and structures. But time to market also means products you want to sell. Since many products have a shorter and shorter life time cycle, the lead time becomes more and more critical. Those that are the first ones to have a product in their store can demand higher prices. But the product that sits on the shelf today could possibly be outdated tomorrow.

Software instead of gut instinct

With a great analysis- and prognosis software, retail is on the cutting edge. Even experienced business people and managers and their gut instinct are actually frequently wrong in their ordering system. A functioning inventory management is essential as the foundation of a well-founded analysis. It needs to cover all distribution channels and generate coherent data. This requires integrated IT structures, the connection between inventory management and modern webshop systems, integrated retail management systems, planning systems or order systems.

One path through the data jungle searches for special software for Business Intelligence. BI software analyzes historical processes as well as current incidents and makes forecasting possible. It collects the required information from a multitude of data sources, edits it consistently and presents it to the decision-makers in a compressed way on a user-friendly interface.

One of the most important procedures in forecasts is time series analysis. Weather observations and stock exchange prices are typical examples of this. In retail, product sales data illustrate a time series. Every retailer wants to know: which product and how much of it needs to be on the shelf at what time? Based on the time series of previous sales figures, prognosis software deduces regularities. If a product is steadily sold over a day, a week, a month, the sales values are plotted on a straight line. However, if sales at the beginning of the week are always particularly high, but very low at the end of the week, it results in a sinus curve.

Parameters improve forecasts

Prognosis software extends the curves or straight lines into the future by extrapolation of historical sales data. But this also means: forecasts are complicated if historical data for new products is missing. Then you need to fall back on comparable cases and their courses. In addition to time series analysis, other statistical methods can be used, for instance artificial intelligence with which human intelligent behavior is meant to be recreated. Computers are meant to independently work on problems with it.

But it depends on the right parameter. Aside from the chronological sequence of historical data, many external factors also affect a time series. In retail those are holidays or vacation times. A sales promotion assists the sale of a product and reduces the sales of items that are not being advertised. Forecasts are thus only as good as the parameters that are entered in addition.

Flowers before Mother’s Day, beer and barbeque meat before a sporting event is shown on TV – those are moments where a manager’s gut instinct makes the difference. This gut instinct, this intuition can not be replaced by any software. But in everyday business, software computes more data than every manager possibly ever could.

René Schellbach, EuroCIS
 

related articles:

popular articles:

Thumbnail-Photo: Password? No need!
09.03.2020   #mobile payment #security

Password? No need!

Interview with Dr. Daniel Schellenberg, COO of IDEE GmbH

Do you have an existing user account? Did you forget your password? No doubt, those are some annoying questions when you shop online. The brains behind IDEE agree and leverage your "digital identity" to make surfing and online shopping ...

Thumbnail-Photo: Creative criminal meets intelligent security system...
28.05.2020   #security #brick and mortar retail

Creative criminal meets intelligent security system

Interview with Ralph Siegfried, Business Development Manager at Axis Communications GmbH

Stores come in different sizes, have different settings and vary in product selection. That’s also why they need a customized loss prevention and security solution. What are some options for retailers and what key elements do they need to ...

Thumbnail-Photo: Our bot is happy to assist you
31.03.2020   #consulting #customer relationship management

Our bot is happy to assist you

Chatbots and AI virtual assistants automate customer service

Chatbots and virtual assistants – some think they are creepy, others consider them a part of daily life. Either way, they patiently answer frequently asked questions related to the opening hours of the nearest supermarket.By now, some ...

Thumbnail-Photo: Promotions and new product launches
04.06.2020   #product presentation #coronavirus

Promotions and new product launches

Challenge for CPG companies in the Corona crisis

The industry is also affected by the Corona crisis, although retail store were always open and some products were allowed to experience a real boost in sales through so-called hoarding. But there are very big challenges in this time. On the one ...

Thumbnail-Photo: Shop NEXT 2020
31.03.2020   #online trading #brick and mortar retail

Shop NEXT 2020

Next shopping experience

Due to the retail industry in Southeast Asia is developing rapidly and the retail industry value has exceeded 100 billion dollars. Over 250 exhibitors and 10,000 visitors from 30 countries or regions are expected to participate in Shop Next ...

Thumbnail-Photo: Checkpoint: Commitment to the shopping experience...
19.02.2020   #customer satisfaction #brick and mortar retail

Checkpoint: Commitment to the shopping experience

Technologies for satisfied customers

Are you wondering how you can deliver a seamless shopping experience to your customers? Checkpoint's experts provide retailers with three ways to make your customers even happier. Watch the video to learn more. ...

Thumbnail-Photo: Consumer survey: social distancing is changing shopping habits...
10.04.2020   #brick and mortar retail #payment systems

Consumer survey: social distancing is changing shopping habits

Touchless or self-checkout options preferred for instore shopping during COVID-19 pandemic

Nearly two-thirds of consumers are changing their grocery shopping habits in response to the worldwide COVID-19 pandemic, according to a recent consumer survey from Shekel, pioneers in advanced weighing technologies. And 87 percent of shoppers say ...

Thumbnail-Photo: The new digital signage landscape: cloud-based...
14.04.2020   #digital signage #artificial intelligence

The new digital signage landscape: cloud-based

Using AI for automation and personalization

Big technology advancements mean digital signage systems are starting to become easier to use, to scale and to integrate, fuelling a market boom that will see the sector worth almost 30 billion dollars in five years' time.In a market that's ...

Thumbnail-Photo: Cutting through the tax jungle
25.02.2020   #online trading #e-commerce

Cutting through the tax jungle

Startup helps online retailers to be fully compliant with European VAT regulations

Anyone who sells goods online is obliged to pay value-added tax (VAT). The amount depends on the respective national regulations. But what happens if you have cross-border exports and transactions? How much VAT do sellers have to pay in this case ...

Thumbnail-Photo: Automated delivery services sprang up during China’s Covid-19 lockdown...
03.06.2020   #coronavirus #delivery

Automated delivery services sprang up during China’s Covid-19 lockdown

Retail technologies at Smart Retail Expo (SRE 2020)

In response to the Covid-19 outbreak, China’s retail giants JD.com and Meituan both deployed their smart deliver robots/vehicles in heavily locked down cities, such as Wuhan and Beijing. Insiders believe automated delivery technology will be ...

Supplier

Checkpoint Systems GmbH
Checkpoint Systems GmbH
Ersheimer Str. 69
69434 Hirschhorn a. Neckar
Delfi Technologies GmbH
Delfi Technologies GmbH
Landgraben 75
24232 Schönkirchen
APG Cash Drawer
APG Cash Drawer
4 The Drove
BN9 0LA Newhaven
Saint Gobain Sovis
Avenue de la Republique
2407 Chateau Thierry Cedex
VR Payment GmbH
VR Payment GmbH
Saonestraße 3a
60528 Frankfurt am Main
StrongPoint
StrongPoint
Isafjordsgatan 5
164 40 Kista
ROQQIO Commerce Solutions GmbH
ROQQIO Commerce Solutions GmbH
Harburger Schloßstraße 28
21079 Hamburg
Nagarro Allgeier ES GmbH
Nagarro Allgeier ES GmbH
Westerbachstr. 32
61476 Kronberg im Taunus
POS TUNING Udo Voßhenrich GmbH & Co KG
POS TUNING Udo Voßhenrich GmbH & Co KG
Am Zubringer 8
32107 Bad Salzuflen
Poindus HQ - Taiwan
Poindus HQ - Taiwan
5F., No.59, Ln. 77, Xing-Ai Rd.,Neihu Dist.
Taipei City 114