The Shared Inventory Conundrom – Retail Sales & Inventory Reporting


By Jim Lewis, CEO Increased Retail Solutions LLC

For lots of yrs we have worked with consumers and makes that market the very same SKUs to many retail shops. They share a typical inventory which can make anticipating future needs a challenge. Some shops supply a forecast, but most be expecting suppliers to manage ample stock to keep them in organization. And now with lots of makes likely direct to client through their very own internet sites, running shared stock is even much more of a problem.

Standardizing Information

The critical to having a take care of on shared stock is to construct a bottoms-up forecast by SKU by retail account. Not just what is anticipated to promote, but how much every single retailer will have to have to invest in to maintain their design stock. To do that you’ll want POS knowledge for each individual account, a seasonality profile, and any recognised prepared promotions. Those very last 2 factors can be various relying on the retailer’s philosophy. If income are not accessible, you can use previous shipments. Using a desire arranging program or your inside method, derive regular monthly stock necessities by retail account.


Most suppliers generate an stock report that only gives complete models out there and doesn’t break it down by retail account. I have but to see an off the shelf inventory system that handles the allocation or reservations by retailer ache issue. Even now, it requirements to be completed. A ledger with available to sell and do the job in course of action by retail account requires to be stored. Fundamentally, a reservation ledger. Reservations by SKU by retailer can be accomplished in Excel, working with a tab with all the info and a pivot table to deliver the specifics and overall. If I shed you there, contact us and we can enable you.

Wholesale Inventory

Summarizing approximated profits or stock requirements by Retailer, by SKU by Thirty day period


An additional crucial element to taking care of shared stock is communication. If your business has numerous salespersons, they may possibly each be attempting to sell the same inventory. They need to know what the tale is with each individual merchandise. You can do that with a excellent status process. The standing can be reflective of the perspective toward the stock. For illustration, “S” could suggest demanding- reserved by account. “F” could mean adaptable, check out reservation very first, or “O” for open, denoting there are no reservations, and all can be sold. The standing can be maintained in the inventory ledger described over.

Finishing the Ledger

The ledger can be done by introducing in the present-day ATS (available to provide) and manufacturing facility orders aligned by thirty day period. Then you can do the math to venture stock positions at the close of every single thirty day period. Each and every group is distinct, but the idea is to break everything down at the least expensive level. Exception studies can be derived from the ledger- inventory that has not been taken when anticipated or projected less than or in excess of scenarios.


Resource link