Average stock
The average balance of goods over a period, calculated from several dates rather than one.
Formula
Average stock = Σ month-end balances ÷ number of months
How to read
For a seasonal business a one-date balance misleads; use the average by month or by week.
Where it is discussed
Topics
- Revenue, profit and costs
- Stock and turnover
- Buying budget and cash
- Season, price and discounts
- Collection and range
- Wholesale terms and credit
- Cash and working capital
- Markdown and exit price
- Range: width, depth and price tiers
- Warehouse, fulfillment and the last mile
- Scenarios and plan stress test
Calculations
- Quick business check: two periods
- Average stock for the year and turnover
- Days of inventory and excess stock
- GMROI: gross profit per unit of stock
- GMROI: margin and turnover levers
- Inventory carrying cost rate
- The six-month plan and model stock: stock = sales × coverage + safety, purchases by month
- Clearance scenarios compared by goal
- A brand inside a multi-brand retailer: share of space and sales, margin and a decision
- Warehouse capacity for the peak: places, area, utilization