A huge part of retail success is having the right product in the right place at the right time for the right price. There’s nothing more upsetting than being out of stock when a customer is ready to buy. My last post has you working on your inventory system so let’s take a deeper dive into Inventory Turn.
Inventory Turnover tells you how many times during a specific period you sell and replace (turnover) your inventory. It tells you if you are over or under stocked. Controlling your inventory turnover helps you keep your shelves stocked so you don’t miss sales. It keeps the cash flowing. In general a higher turn indicates merchandise is moving and business is good.
In general you will need to have 25-45% more items in inventory that you would need to meet your sales goal. For example, if you need to sell 10 hoof picks to meet your hoof pick sales goal this month, you will need to have 25-45% more hoof picks (roughly 13 - 15 total hoof picks) to meet this goal.
You can calculate your inventory turn by total company (all stores if you have multiple locations), individual store, category, brand and/or item. Depending on what you want to know you can select one of these calculations or a group.
Inventory Turnover = COGS (cost of goods sold)/Average Inventory
COGS = Beginning Inventory + Purchases – Ending Inventory (NOTE: Use wholesale costs plus any shipping and handling you have paid. Subtract any cost of lost, stolen on unsalable items.)
Average Inventory = Beginning Inventory + Ending Inventory/2
Days Inventory Held = Days in the Accounting Period/Inventory Turnover Ratio
Here’s an easy example for a store in a 30-day period using the following figures:
Beginning Inventory: $10,000
Ending Inventory: $20,000
Additional Purchases: $50,000
Days in period: 30
COGS: 10,000 + 50,000 – 20,000 = 40,000
Average Inventory: 10,000 + 20,000/2 = 15,000
Inventory Turnover Ratio: 40,000/15,000 = 2.67
Average Days held in Inventory: 30/2.67 = 11.24
With these numbers, you have an inventory turnover ratio of 2.67 and are holding your inventory for about 11 days.
Let’s see what happens when we increase our Additional Purchases to $70,000
COGS: 10,000 + 70,000 – 20,000 = 60,000
Average Inventory: 10,000 + 20,000/2 = 15,000
Inventory Turnover Ratio: 60,000/15,000 = 4
Average Days held in Inventory: 30/4 = 7.5
You can see the higher inventory rate decreases the average number of days that items are in store, ie. you are selling items faster.
Let’s also take a look at the simple hoof pick example from above using these numbers:
Beginning Inventory: $50 (10 picks @ $5/ea.)
Ending Inventory: $15 (3 picks @ $5/ea.)
Additional Purchases: $25 (5 picks @ $5/ea) NOTE - Assume you have purchased 45% more than you need which is 14.5, or rounded up 5 more picks to sell 10.
Days in period: 30
COGS: 50 + 25 – 15 = 60
Average Inventory: 50 + 15/2 = 32.50
Inventory Turnover Ratio: 60/32.50 = 1.8
Average Days held in Inventory: 30/1.8 = 16.66 or 17 days
Knowing how quickly you are selling individual key items will allow you to order enough stock and keep the deliveries on track to make sure you always have them in stock.
Need help with Inventory Turnover? Contact: Anne Cecil, ONO made in the 191, firstname.lastname@example.org
Inventory is likely the most expensive asset you have. Are you sure your current inventory is accurate? Summer is a great time to reclaim your inventory control system. Let’s get your investment in order before holiday sets in.
Out with the old
When was the last time you reviewed and updated your inventory? Start the process by removing all items you no longer sell from your inventory control system. Check for any stray units. Clear them out of the store and the system. You will be left with an accurate current product assortment and remove the possibility that new inventory will be received as an incorrect item.
Something’s just not right
Inventory issues often arise from human error - a product is not listed in inventory correctly, is placed in an incorrect category or marked as a different product when received, an incorrect item was sent, etc. Run a complete inventory report and look for items with “0”inventory, sales that stopped suddenly or negative inventory. Review each item, investigate and make changes accordingly.
What’s in a name?
Create a unique name for each item in your inventory that has even a minor difference from another. For example, don’t receive all fly spray at the same price point under fly spray. Receive each into the individual brand/type of fly spray. You will know EXACTLY what your customer prefers, so you can provide it. Now you have a clean current in-store inventory of items on hand.
What’s on order?
Next, review your orders to determine what is coming in and add these items to the system so they are accurately characterized when they arrive.
Switch from Annual to Perpetual on hand counts
Instead of one annual physical inventory count, consider doing smaller counts each week or month. Categories rotate throughout the year. The job is more manageable and reduces disruption of sales.
Your POS system is an integral part of your inventory control. Review what your system can and can’t do. Check to see if there is a new version or update. See what other options might be a better fit.
If your system doesn’t allow you to scan your inventory it’s time to make that happen. You’ll still need to set up the system as noted, but when set up properly scanning items as they are received, counted and sold saves significant time and money, removing most of the human error.
Need help with Inventory? Contact: Anne Cecil, ONO made in the 191, email@example.com
Did you know that a shopping journey that begins in store and ends online results in a 64% larger shop at check out?
Did you know an online shopping journey yields a 25% higher purchase at checkout than in-store?
Leverage this data as you integrate your in-store and online business into a Customer First shopping experience using these 4 simple steps.
1. Encourage your customer to complete their purchase online. You can do this with some computer stations in-store, by offering free wifi and by incentivizing them with bonus loyalty points, a percentage off, a coupon for their next visit, etc. That gets them to your site where you can show more product and keep them shopping with both hands free!
2. Incentivize add on to the purchase by offering Free Shipping with a minimum $ amount. Determine your average $ sale and average $ price of your “impulse” items to find the sweet spot free shipping minimum for your customer.
3. Make sure your site is set for suggestive cross sells, up sells and customers who bought this also bought… just like Amazon. Amazon is successful is because they make online shopping easy.
4. Consider a special deal for you page before checkout. Shoedazzle shows a page of items about 10-15% off to build share of wallet before the customer gets to checkout page. You could also promote online only merchandise or items you need to move. Customers do not have to select anything, but the opportunity is there.
Hire a website professional to set these options up for you and train your staff to maintain the process. It will be well worth the investment. Do it right and you will be well on your way to the integrated shopping experience your customer will love.
Need help with this strategy? Contact: Anne Cecil, ONO made in the 191, firstname.lastname@example.org
About 83% of shopping journeys are for repeat purchases, even in the so-called “Fashion” categories. That’s a huge percentage of trips to your store. Instead of chasing a whole lot of what’s new, put your customer first and think about how you can easily service their replenishment needs.
The single most important thing to do is make sure your POS system is accurately tracking your customer’s online & in-store activity. Your overall goal will be to integrate your website and physical store into ONE customer focused entity.
Your replenishment strategy will leverage an increase in the share of wallet you are getting from current customers and as we know, that is much less costly than using new, trend items to cultivate new customers.
Use your integrated POS system (or your separate systems if that is what you have) and then tie into your loyalty program to create comprehensive current data in your customer profiles. Use these profiles to determine which customers repeat purchase and what it is they continually buy.
Then make it easy for your customer to repurchase! Here are some ideas to get you going:
Run promotions. Offer discounts, two-fers, introductory offers for similar products, bundles, etc. based on item, brand or category driven purchases.
Run tailored ads to drive traffic in the same way. Always consider the item, brand or category driven customer as you create and target these ads.
Send out reminders when it is likely your customer will need to replenish. If the average replenishment on underpants in your store is 8 months, you could send out a reminder coupled with a promo or tailored ad to this customer every 8 months. You might consider sending several offers (the same or different) at month 7, month 8, month 9.
Consider a subscription service. Are there related items purchased on a similar schedule? If so, create a subscription price and timeframe for these items for the customer. I buy 3 daily supplements for my dog on a 90-day basis. You could offer me 10% off my total purchase, free shipping and a 90-day cycle guaranteed if I subscribe. The 10% off and free shipping offers a solid savings over the year AND I don’t have to remember to order. This truly puts your customer first.
About 83% of your sales are repeat purchases. Integrating your available technology, collecting current data and using it effectively to drive a CUSTOMER FIRST store is a win for your customer and a win for you.
Need help with this strategy? Contact: Anne Cecil, ONO made in the 191, email@example.com.
Being sustainable CAN help your bottom line and you are doing good at the same time. Save money and boost your brand story with these 5 tips.
1. Use found objects, items in the donation pile, packing materials, etc. in your window and in-store displays. You can even move them around and use them in different ways over several display cycles.
2. Bring in some positive energy with some live plants. Strategically placed, these can help draw your customers through your store. Make sure you are up for the commitment. Nothing says "I don't care" more than dying or dead plants.
3. Leverage natural light wherever possible and invest in LED bulbs for the rest. LEDs are more expensive up front, but they last a long time. For further savings install motion sensors on lights that turn on and off in your offices, store rooms and warehouse. Consider adding programmable thermostats to keep your space warm or cool as necessary.
4. Go paperless with email receipts. It's a great way to add new customers to your database and it helps to keep your brand top of mind. You can always add a special offer, coupon, or other incentive on the email only receipts.
5. Yes everyone is doing them, but a reusable branded shopping bag does save you money on bags and promotes your brand. Remember, a person will remember a brand after they have seen it 7 times. Get them out there and working for you. Consider offering a small incentive like a small percentage off, or a small donation to a charity to encourage use.
Tell everyone when you implement each of these. Good for the planet, loved by your customers and good for your bottom line. There's no downside. Implement today.
Anne Cecil, ONO made in the 191, firstname.lastname@example.org