Home > Retail Analytics Dashboard > In Stock
RAD - In Stock
In Stock Opportunity measures annual sales increase potential if your store never ran out of what it sells (Ace SKUs only). For example, if your metric is 1.1% then your store would see an increase of 1.1% in annual sales if it never sold out of inventory. This metric is highly actionable through your Retail Analytics Dashboard as it lists the SKU-level detail that makes up this metric. Increasing inventory levels for these items will likely increase sales for a minimal inventory investment. SKU lists (and metric) exclude outs caused by RSC (retail support center), special orders, in/out promotional items and other noise. This is an easy level to achieve, but it takes some time for your In Stock percentage to move: persistence and patience are the key to this level. Steps to improve your In Stock: Log into Acenet and select Retail Analytics Dashboard from the Find it Fast menu. Under the In Stock section, find and click the Current % hyperlink for Mango In-Stock Opportunity. A grid will load and populate SKUs that need higher minimum order points (suggested MIN OP column). You can accept these MIN OP recommendation by clicking the button in the Change Minimum Order Point column. Once you have selected the MIN OPs you'd like to accept, click Submit in the upper right hand corner. Within 30 minutes, the order point and minimum order point will increase to the suggested MIN OP level. Additional Information It is our recommendation that you accept all the suggested MIN OPs from the grid. This is a surgical list of SKUs selling out in your store, not caused by the warehouse, and now the ball is in your court to improve the In Stock on these SKUs. The budget tool in the upper left can be a nice way to manage cash flow while still improving In Stock. Total Inventory Increase at the bottom of the grid displays the cash flow impact of accepting the suggested MIN OPs. The Suggested MIN OP value can be overridden using the far right column. While the feature is there, it is against our recommendation to change the suggested MIN OP. Which SKUs are excluded from this listing? To measure In Stock Opportunity consistently we need to exclude many SKUs that sold to zero where In Stock was not desired or controllable. With this type of noise excluded, you can take a close look at each SKU, its shelf space and order point to see if additional inventory is a good idea. If this listing is showing SKUs that should be excluded in your store then please let us know! Zeros likely caused by retail support center (RSC) service level (the warehouse was out) Special orders In/out promotional items Bagged goods Bulk Store supplies Column Definitions SKU: Item Number Description: Product Description from Acenet Location: Primary Location of the SKU Change Minimum Order Point (MIN OP): Accept Yes / No Suggested MIN OP: What Mango is recommending for the new MIN OP Current MIN OP: Current MIN OP value as of the first of the month Store Order Point: Current Order Point value of the first of the month Inventory Increase: Resulting dollar change with new MIN OP in place. QOH: Quantity on Hand QOO: Quantity on Order OM: Order Multiple Days Zero TTM: the number of days at zero over the last twelve trailing months Times Zero TTM: Number of time the item has sold out in the last twelve trailing months TTM Sales Units: Number of unit sold in the last twelve trailing months Product Group: the SKUs fineline / product group Override Suggested Qty: selecting this allows you to change the value of "Suggested MIN OP" before submitting the SKU
In Stock Opportunity measures annual sales increase potential if your store never ran out of what it sells (Ace SKUs only). For example, if your metric is 1.1% then your store would see an increase of 1.1% in annual sales if it never sold out of inventory. This metric is highly actionable through your Retail Analytics Dashboard as it lists the SKU-level detail that makes up this metric. Increasing inventory levels for these items will likely increase sales for a minimal inventory investment. SKU lists (and metric) exclude outs caused by RSC (retail support center), special orders, in/out promotional items and other noise. This is an easy level to achieve, but it takes some time for your In Stock percentage to move: persistence and patience are the key to this level.
Additional Information
To measure In Stock Opportunity consistently we need to exclude many SKUs that sold to zero where In Stock was not desired or controllable. With this type of noise excluded, you can take a close look at each SKU, its shelf space and order point to see if additional inventory is a good idea. If this listing is showing SKUs that should be excluded in your store then please let us know!
SKU: Item Number
Description: Product Description from Acenet
Location: Primary Location of the SKU
Change Minimum Order Point (MIN OP): Accept Yes / No
Suggested MIN OP: What Mango is recommending for the new MIN OP
Current MIN OP: Current MIN OP value as of the first of the month
Store Order Point: Current Order Point value of the first of the month
Inventory Increase: Resulting dollar change with new MIN OP in place.
QOH: Quantity on Hand
QOO: Quantity on Order
OM: Order Multiple
Days Zero TTM: the number of days at zero over the last twelve trailing months
Times Zero TTM: Number of time the item has sold out in the last twelve trailing months TTM Sales Units: Number of unit sold in the last twelve trailing months
Product Group: the SKUs fineline / product group
Override Suggested Qty: selecting this allows you to change the value of "Suggested MIN OP" before submitting the SKU