Author: Chad Symens

Dollar General Opens 10,00th Store

Nothing seems to be able to slow down the discount store channel right now as Dollar General opens it’s 10,000th store.  

“Opening the doors of our 10,000th store is a meaningful day for all of us at Dollar General, and we are excited to celebrate the occasion in California,” said Rick Dreiling, Dollar General’s chairman and CEO. “This milestone reiterates our commitment to bringing unmatched convenience and value to customers across the nation.”

The need for detailed POS analytics with 10,000 stores is hard to understate but the quantity of data produced from a chain of 10,000 stores is pretty massive.  Even with a small number of SKU’s a vendor supplying to Dollar General has a large amount of data to analyze which makes exception reports critical. Working with our vendors we create inventory and sales exception reports to sort through the data quickly and make sense of it.  For example, an inventory report at a store/SKU grain which identifies any out of stock or low weeks of supply is a fantastic tool for staying on top of inventory.  We also use a sales exception report to identify any SKU/store with a large percentage change in sales over a rolling four week period.  

Exception reports are the key to managing large amounts of data quickly.  What exceptions are you monitoring?

2012 National Hardware Show

The Accelerated Analytics team will be attending The National Hardware Show® May 1-3, 2012 in Las Vegas again this year.  We have attended the show the past several years and find it is a very good opportunity to connect with our customers and network with retail buyers and vendors.    If you have not attended the show, or if you have not attended in a few years, it would be worth considering.  The National Hardware Show® has become huge in the last few years with products across categories like hardware and tools, homewares, lawn and garden, storage, plumbing and much more.  It takes several days to just walk the entire floor and check out all the booths. 

If you are planning to attend the show what are your objectives?  Find new products, new distribution for your current products, network with industry peers?

Dollar General Profits Up 33%

Dollar General reported quarterly profits were up 33% to a record $299 million for the quarter.  Total sales and same store sales were also up significantly.  

The value Dollar General offers to cost aware consumers is clearly paying off for them.  Our teams provide reporting and analytics on Dollar General EDI 852 and we have noticed strong sales as well.   When you are a vendor to a retailer like Dollar General with 9,800+ stores, using EDI 852 to closely monitor sales and inventory is critical.  Imagine if you have just 5 SKU’s at every Dollar General store – you would have about 50,000 SKU/store combinations to manage and keep an eye on.   Dollar General offers both a daily and weekly EDI 852 feed so you can get visibility into store sales performance and help partner to grow the business.

Spring Apparel, Candy to Send Easter Sales Past $16 Billion, According to NRF

Spring Apparel, Candy to Send Easter Sales Past $16 Billion, According to NRF

It seems even high prices at the pump can’t keep the Easter Bunny away this year.  According to NRF’s Easter spending survey, conducted by BIGinsight, Americans will shell out an average of $145.28 on everything from apparel and candy to food and decorations this year, up 11 percent from $131.04 last year. Total spending is expected to reach $16.8 billion.*

“Though the price of gas is on everyone’s mind, Easter is one of the few holidays some consumers are willing to stretch their budgets, especially because many children look forward to treats and new outfits on Easter morning,” said NRF President and CEO Matthew Shay. “Retailers will make sure to offer plenty of promotions on candy, apparel, food and decorations in the coming weeks for eager holiday shoppers.”

Read the entire article on NRF’s website.

Improving EDI 852 On Hand Data for Useful Inventory Reporting

Nearly all EDI 852 files report activity of SKUs or UPC’s.  While this probably seems like an obvious statement, it does create some work to create a data set which is suitable for good inventory on hand reporting.

EDI 852 activity based reporting means that a SKU which is on hand, but which did not have a sale or return in a given week, will not be reported in the EDI 852 file because there is no ‘activity’ to report.  Without some work on the data this creates null on hand records which impact the ability to do good out of stock and inventory exception reporting.

For example, a SKU might have 100 units on hand but not sell for a two week period and so the current week on hand will be null.  To improve upon the data one must carry forward the last known on hand value that was reported in the EDI 852 so that each SKU has an on hand.

The downside to this approach is that your database will grow in volume over time, and so it is also necessary to put one or more rules in place to decide when on hand for an item will no longer be carried forward.  This can be accomplished using the SKU status – for example do not carry forward the on hand for an item when it changes from ‘active’ to ‘inactive’; or you can create a rule to discontinue the on hand carry forward automatically after some number of weeks with no activity reported in the EDI 852.

Our team has implemented these types of rules to improve upon the EDI 852 for Home Depot, Macy’s and a number of other retailers and it has greatly improved our ability to produce accurate and useful inventory out of stock and exceptions reports.

February Retail Sales Increase 8.6 Percent Over Last Year

February Retail Sales Increase 8.6 Percent Over Last Year, Marking 20 Consecutive Months of Growth

With a spring in their step, retailers marked 20 consecutive months of sustained year-over-year retail sales growth in February as unseasonably warm temperatures and comparisons with weak sales in 2011 resulted in stronger-than-expected increases. According to the National Retail Federation, the world’s largest retail trade association, February retail industry sales (excluding automobiles, gas stations and restaurants) increased 0.5 percent seasonally adjusted from January, and 8.6 percent unadjusted year-over-year.

 “Though February is typically a month for consumers to stay home and wait for spring, shoppers this year took advantage of mild weather to get a head start on outdoor projects and warm-weather apparel,” NRF President and CEO Matthew R. Shay said. “While February sales certainly present continued reason for optimism, retailers are paying close attention to rising gasoline prices, which are forcing millions of our customers to spend a significant portion of disposable income filling their gas tanks.”

February retail sales, released today by the U.S. Department of Commerce, showed total retail sales (which include non-general merchandise categories such as autos, gasoline stations and restaurants) increased 1.1 percent adjusted month-to-month and 10.3 percent unadjusted year-over-year. NRF continues to forecast retail industry sales will rise 3.4 percent in 2012 to $2.53 trillion.

“Pent-up demand is turning desires into needs, which is one reason why consumers have begun opening up their wallets,” NRF Chief Economist Jack Kleinhenz said. “There is no doubt that the economy is on the upswing, certainly compared to six months ago. Stronger-than-expected February sales and an improving labor market paint a bright picture of the U.S. economy, although the impact rising gas prices will have on the economy’s momentum remains unclear.”

Other findings from February retail sales numbers include:
•    Pleasant weather lifted retail sales at sporting goods, hobby, book and music stores 1.0 percent seasonally-adjusted month-to-month and 7.4 percent unadjusted year-over-year.
•    Homeowners used the mild winter to work outdoors, which helped sales at building material, garden equipment and supplies dealers increase 1.4 percent seasonally-adjusted month-to-month and 18.2 percent unadjusted year-over-year.
•    Department stores saw increased retail sales of 1.5 percent seasonally-adjusted month-to-month and 4.8 percent unadjusted year-over-year.
•    New spring and summer fashions helped lure shoppers to clothing and clothing accessories stores, which saw retail sales increase by 1.8 percent seasonally-adjusted month-to-month and 11.6 percent unadjusted year-over-year.

For Immediate Release, NRF
Stephen E. Schatz (202) 626-8119
SchatzS@NRF.com

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%.