Several resources offer free OTB templates you can download immediately:
Target stock remaining at month-end. Planned Markdowns: Expected discounts or promotions. On Order: Inventory already purchased but not yet received. open to buy xls
Deduct a safety margin (e.g., 5-10%) to account for uncertainty. Several resources offer free OTB templates you can
The calculated budget available for new purchases. How to Calculate OTB in Excel The foundational formula used in most spreadsheets is: Deduct a safety margin (e
Planned Sales+Planned Markdowns+EOM Inventory−BOM Inventory−On Order=Open to BuyPlanned Sales plus Planned Markdowns plus EOM Inventory minus BOM Inventory minus On Order equals Open to Buy If you plan to sell in EOM inventory, have in BOM inventory, and have in markdowns, the formula is available to buy. Where to Find Open to Buy Excel Templates
If you tell me what kind of you have (e.g., clothing, gift shop, or boutique) and whether you prefer to plan in units or dollars , I can help you tailor the formula to your specific needs. Creating an Open-to-Buy Template For Retail
Provides a robust 6-month merchandise planning template with instructions.