Connect with us

Megan Crabtree

How to Dig Deeper Inside Your Reports

These are questions you should be asking when you run your reports.

mm

Published

on

How to Dig Deeper Inside Your Reports

MANY JEWELRY RETAILERS today look at generic reports like aged inventory, top-selling SKUs or reports by vendors. While these reports are great, they only give you probably half of the big picture.

If you start looking behind this data, you’ll uncover more ways to improve your business. I will elaborate on three specific reports and how to do a deeper dive with this data.

1. Aged Inventory

Large chain retail stores consider an item to be aged when it has been in the showcase for 90 days. They believe if it hasn’t sold in 90 days, it never will — or they will never get the turn needed on the product. In the independent retail world, most buyers consider the aged product to be something that has been in the showcase over a 365-day period.

There are three additional components I want you to consider:

  • Where is the product located in the store? Look at how traffic flows in your store. Do customers walk by this case, or is it in the back corner? If it’s wedding bands, are they near other wedding bands so that the line is centrally located?
  • Is your staff fully trained and confident when selling the product? If not, that could affect the line’s performance.
  • Have these SKUs generated special orders? Just because a SKU doesn’t sell doesn’t mean you must immediately return it. Maybe it generated a multitude of special orders, and you should just swap it out for the halo shape you have seen many clients order rather than the halo shape you have in the case.

2. Top-selling SKUs

Is there a cluster earring that is selling like hotcakes? Do you have the entire suite of jewelry to upsell your customers when buying the earrings (such as the matching necklace or bracelet)? If not, call your vendor and place an order. Better yet, when the product arrives, notify the clients who bought the earrings to come in and see the new matching pendant.

Another great report to run is your special-order reports. If you see a ring that has been special ordered five times in platinum, stock it. Maybe it hits a sweet spot. Or if you see a semi-mount special ordered 20 times, consider expanding this by offering it live with a complete center or order the semi made up for your top-selling center sizes.

3. Sales by Vendor

While it is great to run reports by vendor, I suggest you look at them as a whole. Think of your showcases as pieces of real estate. You have a blueprint of the case layout, so get that out and map it out by writing the vendor’s name on the case, its product within, and your initial investment. Now check your sell-through for the year and calculate your inventory turn. Believe me, you’ll love this exercise, because it can be quite shocking.

Megan Crabtree is the founder and CEO of Crabtree Consulting. Before founding Crabtree Consulting, Megan had a successful professional career in the jewelry industry, which culminated with high-level positions at several of the top firms in the retail and manufacturing sectors. Reach her at [email protected] or visit us at www.crabtreeadvisory where you can set up a live chat or a 30-minute free consultation.

Advertisement

SPONSORED VIDEO

Maximize Every Sale with Wilkerson

When it’s time to run a sale, whether it’s a retirement, going-out-of-business, anniversary or “we’ve got too much merchandise” sale, let Wilkerson handle the details. The Diamond Galleria did just that when they selected Wilkerson to run its liquidation sale. According to Sharon, their CPA, it was the right choice. “We could have done a going-out-of-business sale ourselves and done 30 to 40 percent of what we actually sold with Wilkerson involved,” she says. Seeing the strategies that Wilkerson puts in place for every sale was something that convinced her they had made the right move. “I would highly recommend Wilkerson to anyone considering this type of sale.”

Promoted Headlines

Most Popular