Open To Buy Spreadsheet Direct

Your forecast of how much you expect to sell during the month.

The actual or estimated stock on hand at the start of the month. Essential Spreadsheet Components open to buy spreadsheet

A calculation to ensure you aren't over-investing relative to your sales volume. Why Retailers Use OTB Spreadsheets Your forecast of how much you expect to

Planned OTB=Planned Ending Inventory+Planned Sales+Planned Markdowns−Planned Beginning InventoryPlanned OTB equals Planned Ending Inventory plus Planned Sales plus Planned Markdowns minus Planned Beginning Inventory open to buy spreadsheet