Open To Buy Spreadsheet Apr 2026

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

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

An spreadsheet is a vital retail inventory planning tool that tells you exactly how much budget is available to purchase new merchandise for a specific period. It serves as a financial roadmap, helping you balance your sales goals with current stock levels to avoid tying up cash in stagnant inventory or losing sales due to stockouts. The Core OTB Formula open to buy spreadsheet

The amount of stock you want to have left over at the end of the month to start the next period.

A calculation to ensure you aren't over-investing relative to your sales volume. Why Retailers Use OTB Spreadsheets A functional OTB template typically includes the following

A column for inventory that has already been purchased but has not yet arrived.

Expected discounts or price reductions to move older stock. A calculation to ensure you aren't over-investing relative

At its most basic level, your spreadsheet uses this logic to determine your available budget: