Welcome!

Agile Computing Authors: Pat Romanski, Liz McMillan, Elizabeth White, Jason Bloomberg, Larry Alton

Related Topics: Agile Computing, Cognitive Computing

Agile Computing: Article

Strategies for Inventory Optimization

Sensing and predicting lucrative inventory-driven opportunities in the marketplace are some of the best ways to expand sales

I live close to a metro grocery store, a multitude of them have sprung up in the UK over the past few years, replacing the corner store independent retailer. In the US they would be akin to the convenience store but they're actually bigger and better than a convenience store and roughly twice the size. Every day, 3 ton delivery trucks arrive early in the morning and deliver fresh bread, chilled and frozen products and ambient inventory.

This metro supermarket does a brisk trade, the nearest competitors are all classic corner stores. The metro competes on brand, price and diversity. Having an ATM bolted into the wall helps too. Replenishment of the shelves is an ongoing battle. The community I live in is relatively diverse but constantly changing.  Almost all of the people work in the City so the weekend trade, early morning trade and early evening trade are brisk, and is open unsurprisingly from 7 to 11.

In recent years, supermarket retail has injected some significant cash into information systems. This store runs 4 manned cash registers and 4 self-checkouts. The self-checkouts are the busiest, in part because the only manned register is usually not working. The staff are almost all multi-skilled, doing everything from shelf packing and inventory rotation to checkout. Although they're part of a major supermarket chain, their operational concept is local.

The amount of information generated by their information systems is extraordinary, it has to be. When you're dealing with a volatile community and a lot of perishable inventory, you cannot afford to be stocking the wrong things.  This is probably why the independent grocer has such a tough time competing. Corner stores are synonymous with a lot of aging dusty ambient and dry goods; many of them have resorted to stocking mostly alcohol as a means to survive. These metro supermarkets conversely only have a small but diverse liquor section and spend most of their real estate on fresh produce and convenience foods that are perishable.

Yesterday, I went in to buy my ‘regular' supply of carbonated mineral water but because the store had recently been reorganized, it wasn't where I expected it to be. I asked an assistant and he scouted around and said that they appeared to be out. My choices were simple, go without, pick a superior more expensive brand or go for a cheaper alternative - soda water. Fortunately they also stock soda water, so I went for that. Although the net effect was the same, in reality they probably lost some margin because the carbonated mineral water I would have bought is their own brand.

Herein lies the challenge. Sensing and predicting lucrative inventory-driven opportunities in the marketplace are some of the best ways to expand sales volumes. I am a wholly unpredictable customer (or at least I like to think that I'm unique). On the one hand, I like to think of myself as fully representative. I use a loyalty card at this store and I spend more grocery money at this store than at any of the other stores in this chain. Their view of my buying profile should be pretty clear. But I don't shop for the same things regularly. If I did, I would be buying milk, bananas, bread or eggs or mineral water regularly. I don't, because sometimes their stocks are depleted and so I need to buy things in more than ‘just for now' quantities in order to avoid missing them when I really want them. You'd think this would be easy to address: the stock-outs, but it seems it isn't. So I thought I would pound out some ideas on inventory management exercises that I wish my supermarket would implement.

Analytics Granularity
For most retailers the largest asset on the balance sheet is inventory. And while executives often say that they know they are hurting their cash flow by carrying too much inventory, they also do not know how to reduce it without creating painful out-of-stock situations. The Bullwhip effect, also known as the Forrester effect describes how the further you are from the front line of retail, the more exaggerated the impact of stock outs. The remedy often adopted, is to implement safety stock numbers. But this is not really an appropriate approach when you're only working with relatively small numbers of inventory.

A more appropriate approach might be to consider moving more granular transactional information to the decision makers by given them the details rather than summary information. This is best achieved with the actual Point of Sale (POS) data rather than aggregated data. If you're running a loyalty card program then you should be making some attempt to perform cross analysis of your loyalty card results with your POS data.  My choice to shop at a different branch of the same chain may be because it was convenient. However if you see me shopping at two different branches on the same day and purchasing different profiles of products and you then determine that some of those products were not available at the first store, that tells you that you might have lost an opportunity to sell me more.

Data Quality
Even if you use the concept of safety stock, what are the guarantees that your fulfillment and stocking plans are using the same data that your macro planners are using? If you're using one system as the source of truth, such as SAP, and not using a number of systems then this problem is a little less pertinent. However, many organizations use a warehouse system, a POS system and an ERP system that all function independently of one another. In such circumstances, keeping the data consistent can be a challenge. If there are duplications of records this situation is made even worse.

Try to identify the duplicates and where they could be coming from.  If you don't have an approach to managing your master records it may well be time to get started on one and part of this approach could be the use of a product suite like that offered by Winshuttle, one that allows you to build custom workflows outside of your Inventory system but which give you flexibility to integrate the data after all the necessary data hygiene checks and balances have been made. It's essential that you figure out how to implement a company-wide effort to create a single version of the truth. Without it, your inventory goals will be much harder to achieve. This won't affect my personal experience as a shopper but it is interesting that I noted the other day that two items that were the same to me, as a consumer but which had slightly different packaging as a result of manufacturer rebranding, appeared as two separate items on my cash register slip and were charged at different prices.

Skinny Inventory
Only when you have good inventory master data and sound granular reporting on all drivers in your inventory chain can you accurately determine how lean your inventory should be.

In principle, the number of days that inventory is held measures the average numbers of days it takes to sell the average inventory held. It is calculated by dividing the average inventory holding by the average daily cost of sales. Average inventory can be calculated the same way that it is calculated for inventory turnover by simply adding the beginning inventory balance to the ending inventory balance and dividing by two.

In order to arrive at an average cost of sales, take the cost of sales figure and divide it by 365. For example, cost of goods sold at the end of the year is $3650; therefore average daily cost of goods sold is $10 ($3650/365). If the average inventory is $50 and the average daily cost of goods sold is $10 the number of days inventory is held is 5 days ($50/$10).

From an efficiency perspective, a low number of "days of inventory held" indicates efficient inventory management. The faster stock is sold the less cash is tied up in inventory. If the value is too low this could indicate under-stocking which can lead to loss of sales and revenue. Peer comparison and self-comparison to previous years and similar firms would be useful in assessing overall inventory management. Your local APICS chapter can probably help you with getting some metrics to compare your values with.

In the perishable grocery segment a low days of inventory held is key but for more durable products something with a longer tail is likely to be normal. This metric is however something that should be constantly under scrutiny and review. As a consumer I am not really fussed about how much your inventory is costing you, what I am concerned about is availability and price. If I have to pay a bit of a premium for a relatively infrequent buy then so be it, but I expect your high volume products to be very competitively priced especially when I compare them with the prices of the "mom and pop" up the road.

Partner Enablement
The world of retail is pretty cut-throat. One only has to look at how retailers gouge manufacturers and compete aggressively with one another to realize that it is wise in particular to re-evaluate strategic partners on a regular basis to ensure that they are creating and not slowing your business down. The better partners are those who are able to communicate effectively with you and have modern systems so that you can gain visibility into their inventories, manufacturing plans and distribution networks.

As a manufacturer, exposing my inventory to you comes at a price and I will expect the same inventory visibility and market information from you - all without even considering vendor managed inventory. This enablement should be considered a minimum these days. While this might sound somewhat risky and scary, the good news is that enabling and building these types of integration with industry-standard data structures and application program interfaces (APIs) is relatively easy and not extraordinarily expensive. If they are well designed, you can expose select dimensions of data to business partners for mutual benefit.

As a consumer, this is not so useful however for the retailer, your ability to tell me when I can expect restocking of a stock-out can help in promoting your brand to me and somewhat assure you that I will be back in your shop again.

Additional reading
http://www.sciencedirect.com/science/article/pii/S0305048303000288
http://merchantos.com/retaileasy/2011/05/turn-turn-turn-whats-your-inventory-turnover/
http://scm.ncsu.edu/scm-articles/article/background-an-analysis-of-supplier-evaluation

More Stories By Clinton Jones

Clinton Jones is a Product Manager at Winshuttle. He is experienced in international technology and business process with a focus on integrated business technologies. Clinton also services a technical consultant on technology and quality management as it relates to data and process management and governance. Before coming to Winshuttle, Clinton served as a Technical Quality Manager at SAP. Twitter @winshuttle

@ThingsExpo Stories
SYS-CON Events announced today that Enroute Lab will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enroute Lab is an industrial design, research and development company of unmanned robotic vehicle system. For more information, please visit http://elab.co.jp/.
SYS-CON Events announced today that Mobile Create USA will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Mobile Create USA Inc. is an MVNO-based business model that uses portable communication devices and cellular-based infrastructure in the development, sales, operation and mobile communications systems incorporating GPS capabi...
SYS-CON Events announced today that Interface Corporation will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Interface Corporation is a company developing, manufacturing and marketing high quality and wide variety of industrial computers and interface modules such as PCIs and PCI express. For more information, visit http://www.i...
SYS-CON Events announced today that Ryobi Systems will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Ryobi Systems Co., Ltd., as an information service company, specialized in business support for local governments and medical industry. We are challenging to achive the precision farming with AI. For more information, visit http:...
SYS-CON Events announced today that N3N will exhibit at SYS-CON's @ThingsExpo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. N3N’s solutions increase the effectiveness of operations and control centers, increase the value of IoT investments, and facilitate real-time operational decision making. N3N enables operations teams with a four dimensional digital “big board” that consolidates real-time live video feeds alongside IoT sensor data a...
Internet of @ThingsExpo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...
Mobile device usage has increased exponentially during the past several years, as consumers rely on handhelds for everything from news and weather to banking and purchases. What can we expect in the next few years? The way in which we interact with our devices will fundamentally change, as businesses leverage Artificial Intelligence. We already see this taking shape as businesses leverage AI for cost savings and customer responsiveness. This trend will continue, as AI is used for more sophistica...
SYS-CON Events announced today that SourceForge has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. SourceForge is the largest, most trusted destination for Open Source Software development, collaboration, discovery and download on the web serving over 32 million viewers, 150 million downloads and over 460,000 active development projects each and every month.
SYS-CON Events announced today that mruby Forum will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. mruby is the lightweight implementation of the Ruby language. We introduce mruby and the mruby IoT framework that enhances development productivity. For more information, visit http://forum.mruby.org/.
In his session at @ThingsExpo, Greg Gorman is the Director, IoT Developer Ecosystem, Watson IoT, will provide a short tutorial on Node-RED, a Node.js-based programming tool for wiring together hardware devices, APIs and online services in new and interesting ways. It provides a browser-based editor that makes it easy to wire together flows using a wide range of nodes in the palette that can be deployed to its runtime in a single-click. There is a large library of contributed nodes that help so...
What is the best strategy for selecting the right offshore company for your business? In his session at 21st Cloud Expo, Alan Winters, U.S. Head of Business Development at MobiDev, will discuss the things to look for - positive and negative - in evaluating your options. He will also discuss how to maximize productivity with your offshore developers. Before you start your search, clearly understand your business needs and how that impacts software choices.
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings the mainstream adoption of containers for production workloads. In his session at 21st Cloud Expo, Ben McCormack, VP of Operations at Evernote, will discuss how data centers of the future will be managed, how th...
There is huge complexity in implementing a successful digital business that requires efficient on-premise and cloud back-end infrastructure, IT and Internet of Things (IoT) data, analytics, Machine Learning, Artificial Intelligence (AI) and Digital Applications. In the data center alone, there are physical and virtual infrastructures, multiple operating systems, multiple applications and new and emerging business and technological paradigms such as cloud computing and XaaS. And then there are pe...
SYS-CON Events announced today that MIRAI Inc. will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MIRAI Inc. are IT consultants from the public sector whose mission is to solve social issues by technology and innovation and to create a meaningful future for people.
SYS-CON Events announced today that Keisoku Research Consultant Co. will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Keisoku Research Consultant, Co. offers research and consulting in a wide range of civil engineering-related fields from information construction to preservation of cultural properties. For more information, vi...
SYS-CON Events announced today that Massive Networks, that helps your business operate seamlessly with fast, reliable, and secure internet and network solutions, has been named "Exhibitor" of SYS-CON's 21st International Cloud Expo ®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. As a premier telecommunications provider, Massive Networks is headquartered out of Louisville, Colorado. With years of experience under their belt, their team of...
Real IoT production deployments running at scale are collecting sensor data from hundreds / thousands / millions of devices. The goal is to take business-critical actions on the real-time data and find insights from stored datasets. In his session at @ThingsExpo, John Walicki, Watson IoT Developer Advocate at IBM Cloud, will provide a fast-paced developer journey that follows the IoT sensor data from generation, to edge gateway, to edge analytics, to encryption, to the IBM Bluemix cloud, to Wa...
SYS-CON Events announced today that Fusic will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Fusic Co. provides mocks as virtual IoT devices. You can customize mocks, and get any amount of data at any time in your test. For more information, visit https://fusic.co.jp/english/.
SYS-CON Events announced today that B2Cloud will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. B2Cloud specializes in IoT devices for preventive and predictive maintenance in any kind of equipment retrieving data like Energy consumption, working time, temperature, humidity, pressure, etc.
SYS-CON Events announced today that NetApp has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. NetApp is the data authority for hybrid cloud. NetApp provides a full range of hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. Together with their partners, NetApp em...