Stock on hand at the start of the month.
Provides a robust 6-month merchandise planning template with instructions. open to buy xls
The calculated budget available for new purchases. How to Calculate OTB in Excel The foundational formula used in most spreadsheets is: Stock on hand at the start of the month
A good OTB spreadsheet should include the following rows/columns: Projected revenue for the month. signaling that you should stop ordering.
Several resources offer free OTB templates you can download immediately:
A negative number means you have overbought or sales are too slow, signaling that you should stop ordering.