The Shared Inventory Conundrom – Retail Sales & Inventory Reporting


By Jim Lewis, CEO Enhanced Retail Methods LLC

For many decades we have worked with consumers and brand names that market the very same SKUs to multiple retail stores. They share a widespread stock which can make anticipating potential desires a problem. Some vendors deliver a forecast, but most anticipate suppliers to maintain enough inventory to maintain them in business enterprise. And now with numerous brands heading direct to buyer via their very own web sites, controlling shared inventory is even a lot more of a obstacle.

Standardizing Knowledge

The vital to getting a handle on shared inventory is to establish a bottoms-up forecast by SKU by retail account. Not just what is envisioned to offer, but how much just about every retailer will need to purchase to retain their product inventory. To do that you will need POS info for each account, a seasonality profile, and any known planned promotions. Those final 2 things can be diverse dependent on the retailer’s philosophy. If sales are not accessible, you can use previous shipments. Making use of a demand from customers setting up system or your inside method, derive every month inventory requirements by retail account.


Most suppliers deliver an stock report that only presents overall units out there and does not crack it down by retail account. I have nevertheless to see an off the shelf stock method that handles the allocation or reservations by retailer agony place. Nonetheless, it wants to be completed. A ledger with out there to provide and perform in system by retail account requires to be held. Fundamentally, a reservation ledger. Reservations by SKU by retailer can be attained in Excel, using a tab with all the data and a pivot table to deliver the details and full. If I lost you there, get in touch with us and we can help you.

Wholesale Inventory

Summarizing approximated product sales or stock demands by Retailer, by SKU by Month


A different vital ingredient to taking care of shared stock is interaction. If your corporation has many salespersons, they may well every be attempting to market the very same inventory. They have to have to know what the tale is with every item. You can do that with a superior position procedure. The status can be reflective of the perspective in the direction of the stock. For case in point, “S” could suggest rigorous- reserved by account. “F” could mean adaptable, look at reservation very first, or “O” for open, denoting there are no reservations, and all can be offered. The standing can be taken care of in the stock ledger talked about higher than.

Finishing the Ledger

The ledger can be concluded by incorporating in the existing ATS (offered to promote) and factory orders aligned by thirty day period. Then you can do the math to task stock positions at the finish of just about every thirty day period. Just about every firm is various, but the thought is to crack anything down at the most affordable stage. Exception stories can be derived from the ledger- inventory that has not been taken when envisioned or projected below or about cases.


Resource link