Blog / Article
Blog home
Case Study

Cookie Box

From constant stockouts to 95% reduction with advanced demand forecasting and inventory planning

Cookie Box case study cover

Cookie Box specializes in crochet kits across North America, selling primarily on Amazon. The business faces unique challenges including managing inventory variations, balancing production lead times across multiple regions (USA, Canada, Mexico), and navigating seasonality and promotional activities. With $5 million in annual revenue and a lean SKU count of about 20 products, efficient inventory management is critical to balancing supply and demand.

Industry
Ecommerce (Crochet Kits)
Revenue
$5M annually
Catalog
~20 SKUs
Channel
Amazon (USA, Canada, Mexico)
95% reduction in stockouts for high-demand SKUs
The Problem

Spreadsheets meant constant stockouts and overstock

Before NeonPanel, Cookie Box relied on spreadsheets to manage inventory planning. This manual approach created several critical problems:

  • Calculation errors — manually calculating production and transportation lead times, safety stock levels, and sales velocity was time-consuming and full of mistakes
  • Inaccurate demand planning — without proper forecasting, they experienced frequent stockouts for high-demand SKUs and excessive inventory for slow-moving products
  • Limited visibility — planning based only on historical data, without considering production, delivery, and customs time, led to missed opportunities or overstock
  • Fragmented tracking — managing inventory across multiple warehouses (third-party, PoS, and Amazon FBA) was unreliable
The Solution

Data-driven demand forecasting and replenishment

  • Comprehensive demand planning — automatic tracking of safety stock levels, production lead times, and sales velocity with calculated reorder points
  • Sales plan integration — planned promotional activities and seasonal demand surges combined with historical data and seasonality trends for precise forecasts
  • Efficient replenishment scheduling — inventory tracked across multiple warehouses with clear insights on when to transfer from third-party to Amazon FBA
  • Optimized capital efficiency — precise planning eliminated excessive safety stock, freeing up working capital for growth
Outcomes

Key results

95% Fewer stockouts For high-demand SKUs
40% Less overstock Drop in over-ordering
30% Lower shipping fees Reduction in last-minute shipping costs
85% Better forecast accuracy With promotional and seasonality integration
15+ Hours saved per week On inventory calculations

NeonPanel transformed how we manage our inventory. We went from constant stockouts and overstock headaches to having a clear, data-driven plan. The forecasting is spot-on, and our team has reclaimed 15 hours a week that we used to spend on spreadsheets.

Mary, CEO of Cookie Box
Mary CEO, Cookie Box

Get your numbers right. Start today

14-day free trial. No credit card. Dedicated onboarding included on every plan.

Join 200+ ecommerce teams who trust NeonPanel for their financial close.