Resale supply chain & inventory analytics
Complete · 554 sales, 92 days
My Depop business buys used clothing in 100-piece bulk lots and resells it item by item, so it runs on the same questions as any distribution operation: how much demand to expect, how fast stock turns, and when to place the next order. I took a full quarter of sales data and built the analysis in Excel. The model measures how much daily demand varies and backtests a moving-average forecast. It then sets a reorder point with safety stock, sized for a supplier that takes anywhere from 7 to 14 days to deliver.
The main result is a reorder point of 90 sellable units at a 95% service level. A 7-day moving average beat a naive forecast by 13% on mean absolute error. Inventory turns quickly: the median item sold 4 days after listing, but about 10% sat for more than a month, and that's the stock to mark down.
- Data
- 554 item-level sales, Mar to Jun 2026
- Methods
- Demand forecasting, reorder point, safety stock
- Lead time
- 7 to 14 days, modeled as variable
- Tools
- Excel model and dashboard
- Reorder point
- 90 units95% service
- Avg demand
- 6.0 / daySD 3.1
- Median time to sell
- 4 days
- Landed cost
- $2.67per item
Summary dashboard. Click for full size. Buyer data removed.