Supply Chain Analytics

Retailers and vendors in today’s retail market face the unenviable challenge of reducing costs and maintaining margins, despite falling overall sales and slow-to-recover consumer demand. One of the areas in which retailers are pushing back onto vendors, is inventory management, which for vendors too often translates into retail partners that reduce overall inventories and require… Read more »

Calculating the cost of out of stock’s

Vendors know an out of stock or empty peg is a very bad thing, so it’s hard to understand why most vendors are not managing their retail sales at a store and item level. Here is what we calculated for a vendor this week to estimate their lost sales due to out of stocks. The… Read more »

Partnering with Walmart

There are no shortage of articles on Walmart in today’s press. Some are positive, but many are written from a viewpoint of fear. Here are some interesting facts from a recent article titled “The Elephant in the Room” by Greg Buzek, which was printed in the May 2007 RIS News. The article paints the picture… Read more »

Analyzing Walmart Retail Link POS Data

If you are a Wal-Mart vendor, you have access to a wealth of data via Retail Link.  As a service provider, we work with a lot of Wal-Mart vendors, helping them to analyze the point of sale data made available by Wal-Mart through Retail Link.   Sometimes a vendor will ask us “If I have Retail… Read more »

Calculating Price Elasticity

Show of hands, how many of you know how to calculate price elasticity? Well, if you are like me, you know the general concept but the math is a bit rusty. So, here is a quick and dirty refresher. Price elasticity is a measure of how demand for a product is influenced by price changes.… Read more »

Calculating Sell-Thru

Sell through (or sell-thru) is a very useful metric for vendors to use in evaluating item performance, because it provides a composite measure of sales and inventory. But like many business measures, there is more than one method of calculating sell through. The most common calculation is: Sell Thru % = Units Sold / (Units… Read more »

Create The Perfect Store Walk Report for Your Merchant

The strategic importance of walking a store with your retail merchant has been growing dramatically in the last several months.  Retailers like Home Depot and Wal-Mart are putting a strong emphasis on merchants spending more time in stores, so they can see firsthand the product presentation and get the pulse of what is happening at… Read more »

Even Simple Forecasting Can be High Value

Forecasting is part mathematics and part art, and due to this,  it can be extremely complex, but even simple forecasting can be very valuable.  Many vendors get too tied in a knot over the complexity of item and store level forecasting and then nothing gets done.  We encourage all vendors to start with the basics… Read more »

Vendor Managed Inventory (VMI): the Holiday Season

September 2 articles in the Wall Street Journal and the Chicago Tribune warn of potentially mild holiday buying driving inventory trends in major retailers across the country.  The chief concern cited in both: fear of too much inventory when the season ends and the resulting “frantic price slashing” (Tribune) and “discounting bloodbath” (WSJ). The Journal article cites… Read more »

Lowe’s Integrating Planning and Execution (IPE)

Back in 2011, Lowe’s announced Q2 financial results with anemic growth and flat same store sales.   To improve performance, CEO Robert Niblock and EVP merchandising Bob Gfeller are implementing Integrating Planning and Execution (IPE), which places an emphasis on putting the right product in the right store at the right quantity. This new focus got… Read more »