The task
Translate sales history and current inventory information into a practical view of future requirements and shipment planning.
My approach
- Use Amazon’s Restock Inventory Report and the previous six months of Business Reports sales data.
- Organize product and pack information alongside stock and sales history.
- Prepare six-month demand forecasts and calculate stock requirements.
- Keep growth, safety stock, and other planning assumptions separate from actual account figures.
What the plan covers
The worksheet brings together available stock, sales, days of cover, forecast demand, safety stock, and requirements in both packs and individual units.
A clear view of what to plan for.
The worksheet is a planning model. Forecasts and safety-stock settings are assumptions, and the six-month requirement is not an immediate shipment quantity.