Specialist retail demand and assortment analytics system
The Product Manager evaluates sales along with searches and consultation issues. This helps to spot an unmet need and review a specialized range.
Rare sales, seasonality and long supply terms make planning of individual goods difficult. Orders not received during a shortage are not reflected in the sales history, and technically appropriate alternatives are not always valued. Capital remains in low demand, at which point the buyer needs the product to wait.
How the solution works
- The planner distinguishes between regular merchandise sales and rare and seasonal purchases.
- Sales history is supplemented by recorded flaws, delivery terms and reasonable alternatives.
- Comparable amounts of replenishment and capital requirements under different demand.
- Confirmed orders are monitored by actual sales, shortage cases and value of remaining stock.
Key challenges
- The addition of categories is based on over general forecasts
Solution capabilities
Signals of unmet need
The category guide compares sales to captured unreceived orders, searches and consultation topics.
Product alternatives tested
Only specialist approved connections are used for planning when the available item can meet the same need.
Choice of Supplement
The quantity offered is based on demand uncertainty, supply term, minimum order and stocks already available.
Slow-selling stocks
The manager sees goods whose need for storage is worth reviewing, considering capital, acceptable customer waiting and the possibility of supply.
Business context
- The addition of categories is based on over general forecasts
- Rare sales, seasonality and long supply terms make planning of individual goods difficult. Orders not received during a shortage are not reflected in the sales history, and technically appropriate alternatives are not always valued. Capital remains in low demand, at which point the buyer needs the product to wait.
- The range is shaped by an unmet need
- Sales data alone does not show the goods that customers were looking for, but did not find. Search and consultation signals help to spot such gaps. The product manager may reasonably consider adding assortments and suitable alternatives, while also checking the risk of slow-selling stocks.
Core features
- Signals of unmet need
- Product alternatives tested
- Choice of Supplement
- Slow-selling stocks
Key integrations
- POS / ERP
- Sales, returns, cost and stock history by SKU and location.
- E-commerce search
- Search, filtering, and undetected results signals that add to the rare history of sales.
- Adviser workspace
- Recurring demand themes and cases where the right product was not in the range.
- Supply data
- The supplier's term, minimum quantity and other limitations on the addition of a niche range.
Potential impact (%)
The ranges indicate an illustrative relative change in the metric under the stated assumptions. Results depend on the starting position and actual use of the solution. Percentages for different metrics must not be added together.
Share of need cases that fail to meet due to lack of a suitable product
2–12%Decreasing
This illustrative scenario assumes that 10-30% of the metric is attributable to addressable planning and execution shortcomings. That share is assumed to fall by 20-40%. Company data is needed to verify both the addressable share and the resulting change.
Consultations and digital channels mark cases where a suitable product has not been found in the range or was unavailable within an acceptable deadline. The percentage is calculated on the total number of specific purchase needs registered.
Share of slow-moving niche stock
2–12%Decreasing
This illustrative scenario assumes that 10-30% of the metric is attributable to addressable planning and execution shortcomings. That share is assumed to fall by 20-40%. Company data is needed to verify both the addressable share and the resulting change.
The part of the stock that exceeds the threshold for turnover or days agreed for the category is assessed, together with monitoring the rate of lost demand. The percentage is calculated on the value of the total stock in the category being checked.
Conditional calculation scenarios. The assumptions have not been validated against client measurements.
When this solution is relevant
- Niche demand, events, season, community trends, and interchangeability of specific products are underestimated
- There is a shortage of popular goods, and low demand products take up capital for too long
Implementation requirements
Assortment analysis checks sales, confirmed unreceived orders, and delivery deadlines. Search and consultation signals are separated from proven demand to prevent rare sales from automatically being considered an unnecessary item.
Further development options
- Comparison of order on demand and permanent balance
- Assessment of the impact of supply term on lost sales