Author: Helen Thomas

U.S. retail sales rose 1.1 percent in February

MARTIN CRUTSINGER

Published: Associated Press 3/13/12

February retail sales rose 1.1 percent, biggest gain in 5 months, with autos showing strength. (AP Photo/Pat Wellenbach) WASHINGTON (AP) – Americans stepped up spending on retail goods in February, evidence that a stronger job market is boosting the economy.

Consumers bought more autos, clothes and appliances. They also paid higher prices for gas.

Retail sales increased 1.1 percent last month, the Commerce Department said Tuesday. It was the biggest gain since September. The government also revised up the previous two months.

Some economists noted that the February increase and the revisions could lead to faster economic growth. It could also put pressure on Chairman Ben Bernanke and the Federal Reserve to rethink its plan to hold interest rates at record lows until at least late 2014.

The Fed is holding a one-day policy meeting Tuesday.

“We believe that the consumer is in better shape than recent downbeat commentary from Fed Chairman Bernanke,” said John Ryding and Conrad DeQuadros, analysts with RDQ Economics, in a note to clients.

A separate Commerce report showed U.S. companies restocked at a faster pace in January, a sign that businesses expect stronger job growth to fuel more sales. Business stockpiles rose 0.7 percent in January, while sales increased 0.4 percent.

One factor driving the retail sales increase was a 3.3 percent rise in gasoline sales last month. It was the biggest increase in nearly a year and reflected a surge in gas prices.

Still, retail sales increased a solid 0.8 percent after excluding gas station sales.

Auto sales rose 1.6 percent. Department stores increased 1.5 percent, the largest gain since November 2010. And sales at appliance and electronics stores climbed 1 percent.

The February gain pushed total sales to a record $407.8 billion. That’s 20.1 percent higher than the recession low hit in March 2009.

The increase comes after the best three months of hiring in two years. The economy has gained 734,000 jobs since December. That’s lowered the unemployment rate to 8.3 percent.

“Retail sales picked up considerably in January and February,” said Joshua Shapiro, chief U.S. economist at MFR Inc.

The government report reflected private data released earlier in the month. U.S. automakers reported having the best annual sales pace in four years in February, despite the surge in gas prices.

Retail merchants reported a 6.7 percent increase in sales in February compared with the same month a year ago, according to the International Council of Shopping Center’s tally of 21 retailers.

An unusually mild winter had depressed sales of cold weather items during the holiday season. But that turned out to be beneficial in February because it helped to lift spending on spring merchandise.

Economists are concerned that consumers could limit spending this year if their wages continue to lag inflation. And rising gas prices could put further strains on household budgets.

The average price for a gallon of gas was $3.80 ($1 a liter) Monday. That’s 30 cents more than consumers paid one month ago.

The overall economy grew at an annual rate of 3 percent in the final three months of last year. But part of that growth came from businesses rebuilding their inventories. That is expected to slow in the current January-March quarter and many economists expect slower growth from the fourth quarter pace.

For all of 2012, analysts at JPMorgan Chase forecast growth of 2.2 percent, an improvement from the 1.7 percent growth seen in 2011.

© 2012 The Associated Press. All Rights Reserved.

Consumer confidence up in February

Consumer confidence in February shot up from last month to the highest level since a year ago, according to The Conference Board. The group’s Consumer Confidence Index now stands at 70.8, up from a revised 61.5 in January, buoyed by consumers’ more positive assessment of the job market.

“Consumers are considerably less pessimistic about current business and labor market conditions than they were in January,” said Lynn Franco, director of The Conference Board Consumer Research Center. “Despite further increases in gas prices, they are more optimistic about the short-term outlook for the economy, job prospects and their financial situation.

Consumers’ assessment of current conditions was more favorable in February. Those claiming business conditions are “good” increased slightly to 13.3% from 13.2%, while those claiming business conditions are “bad” decreased to 31.2% from 38.3%.

Consumers’ appraisal of the labor market was also less pessimistic. Those stating jobs are “plentiful” increased to 6.6% from 6.2% while those saying jobs are “hard to get” decreased to 38.7% from 43.3%.

Source: retailingtoday.com

Tractor Supply Poised for Additional Growth

Tractor Supply announced this week an increase to its long term operating margin target and that it plans to open additional stores.   Tractor Supply Company (NASDAQ: TSCO) has carved out a niche in the market and appears to be exploiting that niche very effectively. 

The recent press release included this statement from their Chairman and CEO.

Jim Wright, Chairman and Chief Executive Officer, added, “Over the past four years, we have effectively tested and validated the viability of the Tractor Supply store model in small markets.  We are pleased that we are able to generate a comparable rate of return on investment in these markets, which opens up additional growth opportunities for Tractor Supply stores. We believe we have a long runway of growth ahead of us.  In working toward our expanded goal of 2,100 stores, we will continue to target square footage growth of approximately 8% annually, which has been a very manageable growth rate for the Company.”

Is your company supplying to Tractor Supply?  We’d like to hear your thoughts on their merchandising strategy and their status with regards to sharing retail point of sale data with vendors.

Lowe’s Net up 13%

Lowe’s reported a 13% increase in earnings for the fiscal fourth quarter and same store sales were up 3.4%.  The second largest home improvement retailer has been closing stores and reshaping its operations in an effort to increase profits and compete with rival Home Depot.   For 2012, Lowe’s forecasts a total sales increase of 1% to 2% with same store sales increasing 1% to 3%.  

Sears to Unload Stores

Hedge fund manager Edward Lampert announced Thursday he intends to sell off some 1,200 Sears stores in an effort to raise $770 million in cash.   Some are looking at this as the start of a breakup and a reversal on the past seven years spent trying to integrate Kmart and pull the company out of the doldrums.   Sears plans to sell off 11 full line stores to General Growth Properties, 1,061 hometown stores, 116 outlet stores and 96 hardware stores.

The 126 year old brand has been losing market share to Wal-Mart, Macy’s and Home Depot for many years as it struggled to find an identity in a competitive market and seemed to confuse consumers with its marketing messages.   But Sears still has some very strong brands like Craftsman, so it’s not impossible to think with a cash infusion and some improved merchandising and marketing, they can turn it around.  Among our customers who we provide Sears POS reporting for, they are in some cases realizing strong sales, in particular hardware and apparel basics.

So what are your thoughts?  Beginning of the end or can Sears turn it around?

U.S. retail sales rise solid 0.4% in January

Is it just me or does the economy seem to be inching back?   Retail sales are rising and are significantly up from the recessionary lows.  See details at retailingtoday.com article “U.S. retail sales rise a solid 0.4% in January”.  We have also noticed an increase in the number of new customers signing up for our POS reporting services as they seek to make strategic investments to drive their business.  Investment is a great sign – it means business leaders are feeling more confident in the economic outlook.  Inventory management and protecting margins are still a challenge and accurate and timely POS reporting can help with both objectives.

What is your economic outlook?

Weather Analytics and Retail Sales

After crunching the numbers, the National Climatic Data Center (NCDC) has found that January 2012 was the fourth warmest January on record across the contiguous United States. This is also the mildest January since 2006, which was the warmest in records dating back to 1895.

States with a top 10 warmest January (9 total) – AZ, KS, MO, MN, ND, NE, OK, SD, WY

Weather can have a significant impact on retail sales.  Consumer’s behavior changes, distribution can be impacted, regular seasonal selling can shift, etc.   Our team has recently completed analytical projects with customers using precipitation, temperature, humidity, and many more weather data points to understand retail sales patterns and then use that understanding to create forecast models.  This is the beauty of store / UPC grain retail sales data.  Combining retail point of sale (EDI 852) demand data with weather data, you can identify fascinating and very useful insights.  Some things to keep in mind….

Useful weather analytics almost always requires day grain retail data.  Week grain data is useful for some weather analytics but there are significant limitations.  EDI 852 is often weekly grain, but sometimes day grain is available.  Portals like Retail Link can provide daily grain (or lower if you want) retail sales reports so target your project to your retail customers that provide day grain retail sales data.

Studying the data carefully to identify statistical significance is critical.  Antidotal or observational research is helpful to inform your statistics but be careful about over simplifying what you see (e.g. it rained and sales are up) until you have run the numbers.

Do apply your industry and product knowledge.  If you sell a product that conventional wisdom says is impacted by precipitation or temperature, then use that as a starting point for building the model.  If the output of the model challenges the conventional wisdom, then dig into the model and look for holes until you are satisfied with the accuracy of the results.

A quality weather analytics project is not an inexpensive project, so be prepared to make an investment.  But on the flipside, we have seen these investments provide huge returns for highly weather dependent product categories.  

Getting Your Buyer to Agree to A Test

Getting your buyer to agree to push order recommendations, modular changes, SKU assortment changes, etc can be a challenge.  Here is some practical experience on how to make it happen.

Running a test with your buyer can be a very effective way to ‘sell them’ on new ideas.  Many times our clients want to use our forecasting tools to push recommended orders to replenishment managers, but the replenishment manager is not receptive to adding extra work to their day and they certainly don’t want to risk overloading stores with too much inventory.   Many times our clients want to change the modular assigned to a store or SKU assortment within an existing modular, but again, the buyer is reluctant to make a change that could have negative results.  Proposing a test is a good way to limit their risk and overcome their concerns.  If the test is properly designed and the control group is selected to provide a proper comparison, your idea should receive a fair vetting.

I spent considerable time today helping a client build a list of stores for a modular test at Wal-Mart.  My client has modulars at Wal-Mart in the following widths: 40’, 36’, 32’, 20’ and 12’.  The SKU assortment grows based on the width of the modular, so a 20’ modular has all the SKUs of a 12’ modular plus some extras.  They have gained the agreement of their buyer to test 25 stores with a larger modular than the store would otherwise qualify for to see if the demand for their products is deserving of more square feet.   The test stores were identified by the buyer and are in close proximity to my client’s office, so they can easily visit the stores.  The test stores have all been promoted to 36’ modulars, which is larger than they had in 2009 and larger than they would otherwise be traited for based on their profile.  The task today was to identify 25 control stores so we can test the sales lift over an 18 week period.  To identify the control stores, the following information was pulled out of Retail Link: 2009 total units sold by store for all stores in my client’s home state.  The first thing we did was calculate the minimum, maximum, average, and median 2009 unit sales for the test stores.  We then eliminated all potential control stores which were not within the min/max, and then further narrowed our list by looking for stores that were +/- 20% of the median 2009 test store group unit sales.  All stores in the test group are Supercenters, so we then eliminated all stores under consideration for the control group that were not Supercenters.   The next consideration was the demographics of the test store group compared to the potential control stores.  We pulled a list of demographics for the test store group, using the store zip code for each of the 25 test stores, and looked at the following traits:  population density, median income, dominate race, and median age.   We created a profile using the averages for these traits.  We then cross referenced the possible control stores demographics along the same traits to identify the closest matches. 

The key is that by using UPC/store level EDI 852 or Retail Link data, the vendor is often in a better position to analyze the demand of individual stores and make recommendations to a buyer on things like orders, modulars and SKU assortment.  Store level planning is the holy grail of maximizing sales, but I’ve not met a buyer yet that has the time or resources to do that.   So the responsibility falls on the vendor to make it happen and proposing a test is often the way to get the ball rolling.

Vendor Questions on EDI 852

Frequently Asked Questions


Vendors are working hard to understand how to best use retail POS and inventory data, which is made available via EDI 852 or a web portal. Here are five very common questions vendors ask as they work with our team to put a data analysis solution in place.

What is the difference between EDI 852 and data available on my retail customers web site? The most obvious difference is the format of the data. EDI 852 is a standard document template but it is encoded using line identifiers and other language necessary for computers to make sense of the data. EDI 852 must be parsed and translated to be of any use to a business user. Data available in a retail portal is typically either presented on screen or saved into a text or spreadsheet format. These files do not require translation and can be opened in a variety of Windows programs. A second difference is the level of detail available. An EDI 852 document always includes units sold by UPC, but it may not include on-hand data. And receiving store level EDI 852 data is often an additional selection and cost. Most retail portals will provide detailed store level data files, or presentation of detailed data on the screen. Finally, and most importantly, EDI 852 values for each UPC can be different than the values reported in a file available on the portal. This can be due to different reporting periods, different source and/or additional source system data, or a different method of handling of returns.

If I can choose between EDI 852 and a file from my retailers’ portal which one should I choose? This decision comes down to a few factors. First, does the retailer charge a fee for sending data via EDI as opposed to accessing the data on the portal. Second, does the EDI 852 data provide less information than the portal. For example, as noted above, some EDI 852 files do not include on-hand or store level data.  Finally, research the data accuracy of the two sources and choose the one which will best support your decision making process.

What types of reports should I be using? There are three reports that form the backbone of retail POS data analysis: item sell-thru by store, inventory on-hand by item and store, and top selling items. From these three reports you can create a library of very useful decision support tools segmented by geographic region, product category, and by retail partner.

Why should I consider an outsourced service for POS data analysis? For most vendors, working with POS data falls outside their IT organization’s typical scope of expertise and tools. Simply put, there is a fairly large volume of data which requires translation, scrubbing, and organization into a sophisticated data warehouse. The data does not fit into most organization’s ERP, forecasting, or accounting system, so the IT department is faced with building a custom application. Then, end users need a simple and quick tool to access the data for analysis and decision making. An outsourced service can deliver the necessary engineering and software tools in a very short period of time without an expensive investment. And outsourcing provides a cost effective monthly expenditure which aligns with your cash flow instead of a large capital expense.

Why can’t I just use a spreadsheet for analyzing POS data? Spreadsheets have many limitations when it comes to analyzing POS data, not the least of which is simple row and column limitations. But more importantly, there is a significant amount of work required each day or week to accept, transform, format, and analyze data in an Excel spreadsheet. Time which your staff can avoid all together by using more sophisticated tools and/or an outsourced service. In addition, spreadsheets are generally not well suited for team based collaboration on data. Each time a spreadsheet is opened, the user has the opportunity to change/edit data which can rapidly deteriorate the quality of the data and cause significant duplication of effort.


Related Posts:

Understanding EDI 852 Data                POS Analysis & Reporting Made Easy                  Whitepaper: SKU Analysis

Managing Inventory: The Highs and Lows

When vendors think about managing inventory, quite often they immediately think of those stores with insufficient inventory and how to resolve that.  Of course, this is a natural and valuable consideration, and a correspondingly considerable effort is made to eliminate inventory outages and prevent lost sales.   
 
But what of the flip side of that coin?  A June 26th article in the Wall Street Journal, titled “Retailers Cut Back on Variety, Once the Spice of Marketing,” cites Walgreen Co., Wal-Mart Stores, and Kroger Co. as examples of how retailers are concerned about too much inventory in addition to their concern about too little.  The article goes on, “these and a few of the other largest retailers are expected to slice the assortment of products in their stores by at least 15%, industry executives and analysts say.”
 
The difficulty for vendors, then, is how to manage both the highs and lows of their inventory throughout their supply chain.  Indeed, inventory ought to be managed at an item by store level, which in and of itself is a vast amount of data.  This is further complicated by the use of third party distributors and the various distribution facilities and warehouse networks used by each different retailer.  Simply getting the raw shipping and inventory information from each retailer and/or distributor is often a substantial task, and making use of the disparate types and formats of data is more often than not the task of a whole team of analysts, who in turn rarely do any analyzing, spending the majority of their time collating and standardizing formatting.  As a result, by the time the inventory situation is discerned, it’s often stale data and virtually useless.
  
This need for accurate, rapid, actionable inventory information has caused vendors to turn to third party partners like Accelerated Analytics to quickly identify those items that are both under-stocked and overstocked.  The Accelerated Analytics® Inventory On Hand Exceptions report continues to be one of our most popular reports because it allows you, the manufacturer, to define any inventory exception you might be interested in and get a report for every item at every store that falls into that category.  Accelerated Analytics integrated use of data received from a vendor, its retail partners, and its distributors, allows our clients to see what the current inventory situation is as recently as the current Week to Date.  But more than the one-dimensional EDI files, Accelerated Analytics® provides a multi-layered inventory look incorporating your own warehoused, shipping history, your distributors’ warehouses and shipping history, and your retail partners’ warehouses and receipts, so you don’t push a new order to a store that is low today. but will be receiving a shipment tomorrow of several new cases for the same item.  Using this type of exception report, in addition to Accelerated Analytics unique Sales Velocity Analysis reports, your analysts can actually analyze your information and pinpoint the items and stores that need your immediate attention in time to do something about it.  This, in turn, will increase your sell-thru, which just might keep your item(s) on the shelf at Wal-Mart, Walgreens, or Kroger!