How To Know If You Have Too Much Inventory

Steve Bailey
Steve Bailey

As owners and managers began the wind-down to the hot summer season when customer count dwindles, many were thinking the same thing as they gazed at the sales yard: Why do we still have so much inventory?

This is a common — and correct — reaction. But before you determine your garden center has too much inventory, let’s first take a look at the possible causes. Several things, big and small, assisted in this gradual buildup.

High Sales Masks High Inventory

The 1990s and early 2000s were an era of increasing revenues. It was easy for garden retailers to, as the popular phrase goes, set ’em down and let the customers pick ’em up. And pick them up they did, with increasing annual customer counts and increased revenue each year.

It wasn’t difficult for Owners/Managers/Buyers to argue that the sales yard and building had to be full all the time or the customer would go elsewhere.

This was an easy route to take due to one of our most reliable retail ratios (margin percentage) lying, telling us our margins were increasing during this period, while the truth was that the higher ending inventory was falsely inflating the attained margin in the Cost of Goods Sold formula. So margins were good, while the customers were not picking up as many as centers sat down. Inventory accumulated.

Garden centers floated along for years, relying on margin data to show they were holding their own in margin, while profit remained stable or slightly declined.

Profit decline was not enough to throw up red flags, although it should have, and so little was done to combat increasing/aging inventory.

Then came 2008. The lack of a solid buying budget or plan was evident as the dark cloud on the horizon did little to curb excess buying. While the majority of lawn and garden retailers began cutting inventory, garden centers continued to buy as if the boom was still on. Or if they did cut back, they cut back in areas that were actually prospering and overbought in favorite areas that were sacred cows to their center.

As the economic crunch deepened, the inventory situation worsened. Now it was easy to see the effect of excess inventory. Revenues continued to decline, while operating and Wage & Wage Beneifts expenses — AKA, the carrying cost of inventory — increased in order to care for the same or more inventory. This imbalance showed up on the profit line and began a slide in equity on the balance sheet. Less profit usually translates into less wealth.

How To Know If You Have Too Much

Let’s examine a few methods that will give you a glimpse into your inventory situation.

1. Simply look around. The first step is pretty easy — just look around and use the seat-of-the-pants approach described at the beginning of this article. If the warehouse and sales yard are full of inventory, sales are declining, customer count is dwindling, labor costs for maintaining the inventory are high and you are faced with holding that inventory for another six months to a year before selling it, you’ve got a problem.

Even if you think you don’t have an over-inventoried issue, move on to the next steps and know for sure.

2. Do a simple check of past inventory levels. Begin by charting your annual beginning and ending inventory at cost for the past 10 years. It’s easy to do if your accounting systems are set up properly.

3. Apply an easy formula. In order to determine if inventory values affected your attained margin, subtract beginning inventory from ending inventory and divide that number by revenue:

(Ending Inventory – Beginning Inventory) ÷ Revenue.

A positive number shows how much your inventory overstates your attained margin. An increase in ending inventory is justified only if the amount of increase is in scale to revenues rising. And, of course, if your inventory is already under control.

If the number is negative, that’s the decrease in attained margin due to a lower ending inventory. And when you think about that, it makes sense due to the nature of lowering inventory — sale events, drastic reductions or just plain throwing away inventory. Reducing ending inventory is usually a good sign if you are over-inventoried, but it will only occur for the first two to three years after inventory control is initiated.

4. Create a stock-to-sales ratio. The next step is the most eye-opening. This method involves calculating and charting the stock-to-sales ratio, a ratio you probably have not heard of. So before you begin that process you will need to know how to calculate it and what the resulting value means.

The stock-to-sales ratio is the relationship between the amount of inventory on hand vs. the amount of inventory sold — both at cost. In other words, how much you sold while you had goods in stock.

Retail wisdom says a retailer should have an annual ratio of 2.5 or lower. Note I said annual, since the ebb and flow of revenue and inventory will move that ratio around significantly on a monthly basis. For example, monthly values for an annual 2.5 stock-to-sales ratio might range from 0.7 to 9.0. Also note that the ratio usually does not dip below a 1 to 1 ratio, unless the inventory moves in and out very fast.

Examine Inventory By Product Category, Not Department

My recommendation is to calculate the annual stock-to-sales ratio on a category basis. A total store stock-to-sales ratio lacks the detail needed if you identify a problem, and most of you will have one.

Even a department value lacks the detail of a category measurement. A category stock-to-sales ratio will be a huge determining indicator of a problem, but will also tell you where to concentrate your efforts for improvement — or elimination.

To calculate the category stock-to-sales ratio, construct a spreadsheet in which you input 12 month’s values for both inventory sold at cost and the amount of inventory on hand at cost.

The date range can be a calendar year or any 12-month period. I prefer to use the last 12 months that includes the busy spring season and allows for planning the next 12 months.

Sum both rows or columns and divide that value for the amount of inventory on hand by the amount of inventory sold. The formula will look like: (12 Months Of Inventory On Hand At Cost) ÷ (12 Months Of Inventory Sold At Cost). The resulting value is the stock-to-sales ratio.

The 2.5 ratio is a beginning point for determining good or not-so-good performance. Take this one step further and construct a chart in your spreadsheet graphically showing the relationship between the numbers. If your stock-to-sales ratio is high, the chart will look something like this:

 

This graph shows a typical inventory-on-hand (red area) to actual sales (blue area) ratio.

Here, the annual stock-to-sales ratio is 9.4. At a glance, you see a large amount of inventory is on hand even when revenues are not being generated (and there’s no need for inventory).

As I said, this is a great tool to use with owners and staff as it graphically shows the inequity of revenue to inventory. Although the category here is hardgoods, it could be plants or goods of any type.

Compare that chart to the same category that has been managed much more efficiently. The inflow and outflow of inventory matches the revenue curve by season. Of particular note is the amount of inventory on hand, $160,000 maximum compared to $400,000 in the previous example — with the same revenue.

And this graph demonstrates a financially healthy ratio of inventory-on-hand (red area) to sales (blue area).

 

In this case, the stock-to-sales ratio is 2.4, with inventory peaking at or slightly before the revenue peak, declining in-between seasons and minimal at the end of the year measured. Also, at no time is the garden center totally out of inventory since new inventory is arriving for the next season, while the inventory from the current season is declining.

As good as your stock-to-sales ratio is, it can be better. Begin with tying in inventory turns and margins to measure and improve total inventory performance. We’ll bring in those steps in the next two issues. Now, get out there and start plotting what you would do if all of the value of your inventory on hand were in the bank instead of being moved, dusted and watered!

Leave a Reply

One comment on “How To Know If You Have Too Much Inventory

More From Retailing...

August 22, 2016

How Bad Plant Pricing Can Hurt A Good Retailer

Greenhouse Grower RETAILING's pricing survey finds that the most profitable pricing method is used by only 8% of plant retailers.

Read More

August 22, 2016

IGC Chicago Scores Big With Attendees And Exhibitors

The 10th anniversary of the annual event at Chicago’s Navy Pier drew a record number of first-time attendees, while exhibitors reported higher sales than ever.

Read More

August 16, 2016

Products Making Their Summer Debut At Farwest

Heading to Portland to attending Farwest? Then make sure you check out these new products that will be on display!

Read More
Latest Stories

August 22, 2016

How Bad Plant Pricing Can Hurt A Good Retailer

Greenhouse Grower RETAILING's pricing survey finds that the most profitable pricing method is used by only 8% of plant retailers.

Read More

August 22, 2016

IGC Chicago Scores Big With Attendees And Exhibitors

The 10th anniversary of the annual event at Chicago’s Navy Pier drew a record number of first-time attendees, while exhibitors reported higher sales than ever.

Read More

August 16, 2016

Products Making Their Summer Debut At Farwest

Heading to Portland to attending Farwest? Then make sure you check out these new products that will be on display!

Read More
Summerwinds Proven Winners display FEATURE

August 16, 2016

Summerwinds Breaks The Price Barrier

In 2012, Summerwinds participated in our 10% Project and raised its priced on three plant brands. What they learned changed the staff culture on plant prices.

Read More
Woman holding vegetable harvest Stock photo FEATURE

August 16, 2016

Gardening Is Enjoying A Sharp Increase, National Garden…

There were 6 million more gardeners in 2015, and 5 million of them were 18 to 34 years old.

Read More
Farwest Trade Show Floor

August 8, 2016

What Garden Retailers Need To Know About The 2016 Farwe…

Farwest continues to strengthen its retail products focus on the show floor to help hard good buyers discover new suppliers and round out product offerings.

Read More
IGC Chicago Trade Show Floor

August 8, 2016

9 Things You Need To Know About IGC Chicago

Before you head to the Windy City for IGC Chicago’s 10th anniversary celebration, be sure to plan ahead for the education, new products, and entertainment that have become hallmarks of the show.

Read More
'Edith's Darling' from Weeks Roses Downton Abbey Garden Rose Collection

August 8, 2016

New Products You Can Check Out At The IGC Show Chicago

We asked suppliers which new products they planned to bring to the Chicago show on August 16 to 18. Here are some of the products you haven't seen yet!

Read More
Plant Pricing

August 6, 2016

Why Don’t We Know More About Pricing Plants?

Preliminary results are in from the industry's first plant pricing survey.

Read More

August 2, 2016

12 Must-See Events At Nursery/Landscape Expo

Heading to Houston to attend the Nursery/Landscape Expo on August 18 to 20? Then make sure you check out these 12 must-see events. First, you should know a little about Nursery/Landscape Expo. The trade show takes place on seven acres of exhibition space and there will be more than 1,000 exhibiting booths. There will also be more than 32 learning sessions and two notable keynote presentations. Stuff You’ll Want To Do New! TNLA Water Smart Innovations. Become Water Smart display on the show floor features the latest water smart conservation products in this new action-packed area. Newcomers Shindig is a fun gathering for first-time attendees and exhibitors to kick-off their EXPO experience, and is free with trade show admission. Attendees get a complimentary drink ticket at the TNLA Honky Tonk Lounge, as well as a behind-the-scenes tour of the trade show. Second Annual Women’s Wine and Tapas Get Together will feature keynote presenter Dan’L […]

Read More
Bundle Pricing sign at Farmington Gardens

August 2, 2016

Pricing Tricks Proven By Research

Although there have been very few studies conducted about plant pricing, pricing in general has been studied in just every imaginable way possible. We’ve sifted through some of the most important studies for you. Most of these you’re already using, but some of the other studies may surprise you. The Magic Of 9 Cents This pricing strategy is one of the most famous. We humans tend to pay a lot more attention to the numbers at the left, but not so much to those on the right. So a $3.99 plant next to a $4.00 plant feels less expensive. And since the right numbers don’t register that much, why in the world wouldn’t you get the most pennies you can? If you price your plants at $3.98 or $3.85, consumers don’t care that deeply that they’re less expensive than $3.99. In fact, studies show they’re more likely to buy plants […]

Read More
New verbena for 2017 from Selecta FEATURE

August 1, 2016

New & Improved: Old-Fashioned Buzzwords Still Motiv…

Connecting with today’s time-starved consumer can be challenging. More things are competing for people’s time, attention and income than ever before. How can you break through all of these distractions to drive sales in your store? The answer may be surprising. It’s simple, it doesn’t cost much in time or money, and the results can contribute significantly to your bottom line. It’s two little words: “new” and “improved.” In a recent Greenhouse Grower column, Dr. Allan Armitage wrote, “’New’ is our lifeline. We had better understand that newness is the horse under our saddle. If it stops moving, so do we.” The idea may seem old-fashioned, but we shouldn’t turn our backs on the power of the words “new” and “improved” in our selling strategies. Even in today’s market, the consumer has a love affair with these important words. Look at Apple, and the platform they’ve built with each next-generation […]

Read More

July 26, 2016

How Your Retail Plant Sales Practices Compare

Editor’s note: Greenhouse Grower RETAILING asked growers and retailers to share their pricing methods in a survey sent out in mid June 2016. Of the 362 responses, 202 arefrom those whose primary business is garden retail. We will be sharing the results of what we learned throughout July, August, and September 2016.   Discounting plants is a finely wielded weapon for plant retailers, Greenhouse Grower RETAILING‘s Plant Pricing Survey shows. It will come as no surprise that just about everyone holds sales at some point (93%). And so it makes sense that some expertise is shown. Take this first graph as an example. The most perishable plants — small annuals and vegetables — are the most likely to be placed on sale. That seems counter-intuitive. Why place the fastest turning inventory on sale? But when we took a closer look, we found that these sales are being used to lure […]

Read More
IGC 2016 Valley Forge Casino Resort

July 25, 2016

New Products You Can See At EIGC

With all exhibitor booths sold out at both EIGC and IGC Chicago, there will be plenty of new products for attendees to check out.

Read More

July 19, 2016

Are You Bar Coding Your Plants Like Other Garden Retail…

We asked garden retailers how they bar code several plant categories. Take a look at our results and learn how in sync are you with your peers.

Read More
Sid Raisch

July 19, 2016

What Sid Raisch’s New Role At Bower & Branch …

The garden industry consultant answers questions about his new role in an e-commerce oriented company.

Read More

July 19, 2016

First Five Plants To Win 2017 All-America Selections An…

All-America Selections (AAS) has announced its first five winning plants for 2017. Three of the five are national winners, and two are regional winners. And of the five, one is an ornamental plant, while the other four are edibles. A panel of independent judges selected these plants after reviewing trial performances. AAS says all these plants are available for immediate purchase. Here’s the list of winners: Celosia ‘Asian Garden’ (2017 Ornamental From Seed National Winner). This celosia winning in North America’s trial sites makes it the first ever AAS Winner from Japanese breeding company Murakami Seed. The judges gave this entry high marks in the greenhouse for the good branching, almost bushy growth habit, and early-to-bloom flower spikes. In the garden, ‘Asian Garden’ celosia continued to bloom on sturdy stems, keeping the bright pink color all summer long, holding up even through some of the first frosts of the season. The AAS judges commented on […]

Read More

July 19, 2016

Home Depot Sues Credit Card Companies For Weakening EMV…

Home Depot has decided enough is enough. The mass merchant is suing MasterCard and Visa for colluding on interchange rates, which it claims it enforces through a monopoly, and for watering down the effectiveness of EMV chips by not requiring PINs in the U.S. In the lawsuit (read a PDF of the 140 page document), Home Depot’s lawyers state: “For years, Visa and MasterCard have been more concerned with protecting their own inflated profits and their dominant market positions than with the security of the payment cards used by American consumers and the health of the United States economy. Visa and MasterCard have pushed consumers to use payment card technology that Visa and MasterCard know is defective and subject to fraud and have colluded with each other and with the banks that issue debit and credit cards to do so. They have also unlawfully fixed at high levels the so-called […]

Read More
[gravityform id="35" title="false" description="false"]