The Shared Inventory Conundrom – Retail Sales & Inventory Reporting3 min read
By Jim Lewis, CEO Enhanced Retail Remedies LLC
For many years we have labored with clients and models that sell the identical SKUs to multiple retail shops. They share a popular stock which can make anticipating upcoming needs a problem. Some stores offer a forecast, but most hope suppliers to retain ample inventory to retain them in business enterprise. And now with lots of brands going direct to buyer through their very own internet sites, running shared inventory is even extra of a obstacle.
The essential to obtaining a deal with on shared stock is to construct a bottoms-up forecast by SKU by retail account. Not just what is anticipated to offer, but how much every single retailer will require to acquire to manage their model stock. To do that you will need POS info for each and every account, a seasonality profile, and any identified planned promotions. Those people past 2 components can be different dependent on the retailer’s philosophy. If revenue are not obtainable, you can use previous shipments. Using a demand setting up program or your inside procedure, derive regular stock demands by retail account.
Most suppliers produce an inventory report that only gives whole units offered and doesn’t crack it down by retail account. I have still to see an off the shelf inventory method that handles the allocation or reservations by retailer suffering place. However, it desires to be done. A ledger with out there to market and operate in method by retail account demands to be held. Basically, a reservation ledger. Reservations by SKU by retailer can be completed in Excel, making use of a tab with all the info and a pivot table to give the aspects and full. If I misplaced you there, get in touch with us and we can support you.
An additional important factor to managing shared stock is interaction. If your business has a number of salespersons, they may possibly every be seeking to market the similar inventory. They want to know what the tale is with every item. You can do that with a excellent standing method. The standing can be reflective of the frame of mind in direction of the inventory. For instance, “S” could imply strict- reserved by account. “F” could necessarily mean adaptable, test reservation very first, or “O” for open up, denoting there are no reservations, and all can be bought. The status can be maintained in the stock ledger mentioned previously mentioned.
Finishing the Ledger
The ledger can be done by adding in the existing ATS (out there to market) and manufacturing unit orders aligned by month. Then you can do the math to task inventory positions at the finish of every single month. Every single organization is unique, but the principle is to break every thing down at the most affordable degree. Exception reviews can be derived from the ledger- inventory that hasn’t been taken when predicted or projected less than or above predicaments.