Open To Buy Spreadsheet Access

A functional OTB template typically includes the following columns or sections:

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

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 A functional OTB template typically includes the following

A calculation to ensure you aren't over-investing relative to your sales volume. Why Retailers Use OTB Spreadsheets open to buy spreadsheet

Rows for Beginning of Month (BOM) and End of Month (EOM) inventory levels.