Ending stock (ES, closing stock)
Stock on the last day of a period per the books, including goods in transit if the company does so.
Formula
ES = BS + receipts − sales − write-offs ± transfers; cover = ES ÷ average weekly sales
How to read
Compare the calculated ES with the book and physical counts: the gap is losses and accounting errors. Stock at price and at cost differ: do not add them. In your company it may be named differently: check the reference book of your accounting system.
Where it is discussed
Topics
- Stock and turnover
- Buying budget and cash
- Season, price and discounts
- Markdown and exit price
- The planning calendar
- Data quality and data owners
Calculations
- Inventory write-down: cost against net realizable value
- Open-to-buy (OTB) for the season
- Buying budget by category and weeks of supply
- Opening stock: stock-to-sales and the monthly buying budget
- Weekly markdown ladder: discount steps and an ending-stock goal
- Buying plan adherence: receipts, sales and stock
- Stock roll-forward reconciliation: beginning + receipts − outflows = end