Submitting an SSO (store specific order) is one of the quickest ways to solve stores that are facing unexpected out of stocks. It's not a permanent fix but as one RM described it, "a way to stop the bleeding." Unfortunately, gathering all the necessary data, doing the analysis, and accounting for breakpacks is incredibly tedious and time-consuming.
The SupplyPike SSO Generator does the analysis and breakpack round for you - just configure the inputs based on your requirements and we'll generate a template complete with store distribution in under a minute!
- Select the product(s) to be included in the SSO. If you're not sure which products might need an SSO, just select All Products, Run Report, and see all item-store combinations that meet the criteria.
- The Stock Stores By input allows you to allocate inventory to stores based on a target weeks of supply (i.e. send enough inventory so that each store has 2.5 weeks of supply) OR a target number of warehouse packs (i.e. send enough inventory so that each store has 2 warehouse packs on hand).
- Choose stores to be considered for an SSO - either all stores that have GRS forecast for next 4 weeks OR stores that have had at least one sale in the last 28 days. Choose “All Stores with L28D POS” to consider stores that may not be traited but are actively selling.
- Limit the amount of inventory that gets sent to any individual store by choosing Yes. This can be helpful when you want to use a Target WOS but don’t want to send an exorbitant number of units to high performing stores. 4a) If you choose Yes, you will get another input for Max Whse Packs to Single Store. It defaults to 5 but you can adjust it up or down.
- Available Units input is where you put the total number of units that you have available to ship via SSO. This input is only available if a single product is selected. If you have multiple products selected, the tool assumes there is an unlimited number of available units.
- WOS Calculation - if you have Target WOS selected, then you can choose between using Average Next 4 Weeks Forecast or Average Last 4 Weeks POS for the weeks of supply calculation. Note that we use last 28 days and not last 4 walmart weeks. N4W Fcst WOS = (store on hand + store in transit + store in warehouse + store on order) / (sum of next 4 weeks GRS forecast / 4). L4W POS WOS = (store on hand + store in transit + store in warehouse + store on order) / (sum of last 28 days POS units / 4)
Once you have the settings configured, click Run Report. Review the results and if everything looks good, export the output directly into the SSO Template form by clicking on the Download icon in the top right corner.
How it works:
- Using inventory, sales, and forecast data, we compute how many weeks of supply each store has, and how much inventory is needed to get to the target weeks of supply.
- Stores are then prioritized based on their potential unit sales in the upcoming weeks (based on the Stock Stores By input) and the individual stores are selected in priority order given the constraint of units available to ship.
- We attempt to fully ship to the highest demand stores. If we are unable to, we prioritize as many stores as possible to maximize the potential retail impact.
- We optimize warehouse shipping by calculating breakpack and rounding, adding or removing warehouse packs to stores as necessary.
- Finally, we do a pass over the data confirming our calculations, and transforming it for both the required template and for display.