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: Innovative ICA store triples revenue
22.08.2019   #electronic shelf labels (ESL) #price labelling

Innovative ICA store triples revenue

Automatic price updates and product information at the shelf

Since ICA merchant, Jan Sikström, took over the ICA Ettan store in Sundsvall (Sweden) in 2016, he has almost tripled the turnover from SEK 15 million to SEK 40 million. Today, the store has 15 employees and approximately 5,000 different items ...

Thumbnail-Photo: POS machine market growth
27.08.2019   #epos systems #pos systems

POS machine market growth

Driver: Adoption of mobile devices for POS transaction

The number of POS machines has increased in the past four years following the introduction of chip-embedded payment cards & Personal Identification Number (PIN). Moreover, growth in the number of departmental and retail stores, which is fueling ...

Thumbnail-Photo: Mobile payments at the supermarket checkout
05.08.2019   #mobile payment #smartphone

Mobile payments at the supermarket checkout

An early adopter’s experience of mobile payments

Or: "What’s that you’re doing with your watch?“I still remember the first time I used mobile payment technology and paid for items with my smartphone at a supermarket checkout: It was October 17, 2018, exactly seven days after ...

Thumbnail-Photo: Spar: opening in Copenhagen
30.10.2019   #electronic shelf labels (ESL) #price labelling

Spar: opening in Copenhagen

International Flagship-Store opens for business in Sydhavn, in the South of Copenhagen

On August 22nd, the grocery chain Spar opened its doors to a brand new store with international concepts in the South of Copenhagen area, Sydhavn. The new store offers a modern shopping experience where it should be easy, convenient and enjoyable to ...

Thumbnail-Photo: Retail Asia Conference & Expo (RACE)
07.10.2019   #online trading #retail

Retail Asia Conference & Expo (RACE)

As the leading retail exhibition in Asia, RACE is taken place from 6 – 8 May 2020.

As the leading retail exhibition in Asia, RACE is recognised as the must-join event among the industry’s most influential retailers and customers. RACE features three focus areas: Retail technology, retail design & in-store marketing ...

Thumbnail-Photo: The iXtenso editors tested self-scanning ......
30.09.2019   #mobile payment #self-checkout systems

The iXtenso editors tested self-scanning ...

... with an app of the Hobbymarkt Knauber in Bonn, Germany

Snabble has developed a payment app that allows customers to scan their purchases in retail stores and pay online. I wondered: How does it work?The app is in use in the Bonn DIY and hobby market Knauber, among other places. Let’s make a move ...

Thumbnail-Photo: Nets and Swish partner on in-store payments pilot...
23.07.2019   #mobile payment #mobile terminals

Nets and Swish partner on in-store payments pilot

Bluetooth tech enables scalable instore payments for mobile payment app

Nets, a European payments company, and Swish, the number one payments app in Sweden, announce their collaboration on an in-store payments pilot program.Until now, Swish has mostly been used for account-to-account transactions and, more recently, ...

Thumbnail-Photo: New year brings new regulations
13.09.2019   #data management #receipt printer

New year brings new regulations

What are the big changes for German point of sales systems come 2020?

Big changes are coming to Germany’s point of sale systems starting January 1, 2020. Two terms that are tossed around in this connection are "Belegausgabepflicht" (Receipt Provision Ordinance) and ...

Thumbnail-Photo: Irma: flagship store in Copenhagen
30.10.2019   #electronic shelf labels (ESL) #price labelling

Irma: flagship store in Copenhagen

Denmark's oldest grocery chain opens a new store

At the same time Irma, a Danish grocery chain, could celebrate its 133rd birthday, the chain also opened a new flagship store at Østerport station in Copenhagen. Besides showing renewal and being able to ensure the customers updated prices ...

Thumbnail-Photo: Silver Surfers: Older adults ride the wave of mobile technology and shop...
01.08.2019   #online trading #e-commerce

Silver Surfers: Older adults ride the wave of mobile technology and shop online

The increasing importance of e-commerce for senior citizens

You are wrong if you think it’s mostly young people who spend time online. Older adults are also increasingly embracing online shopping with enthusiasm.In this interview, Spencer Hinzen, Director of Sales, Central Region, Ruckus Networks, ...

Supplier

Permaplay Media Solutions GmbH
Permaplay Media Solutions GmbH
Aschmattstr. 8
76532 Baden-Baden
Delfi Technologies GmbH
Delfi Technologies GmbH
Landgraben 75
24232 Schönkirchen
Superdata GmbH
Superdata GmbH
Ruhrstr. 90
22761 Hamburg
APG Cash Drawer
APG Cash Drawer
4 The Drove
BN9 0LA Newhaven
iXtenso - Magazin für den Einzelhandel
iXtenso - Magazin für den Einzelhandel
Celsiusstraße 43
53125 Bonn