Excel Spreadsheet — Open To Buy

Open-to-Buy=(Planned Sales+Planned Markdowns+Planned Ending Inventory)−Planned Beginning InventoryOpen-to-Buy equals open paren Planned Sales plus Planned Markdowns plus Planned Ending Inventory close paren minus Planned Beginning Inventory

Alternatively, some retailers include stock in the deduction to find the exact remaining budget: open to buy excel spreadsheet

At its core, OTB is an inventory budgeting system. It calculates the dollar amount or unit count of merchandise a retailer has available to purchase after accounting for current stock on hand and outstanding orders. The Core OTB Formula 3 Reasons to Use an OTB Spreadsheet

OTB=Projected Sales+Planned Ending Inventory−Beginning Inventory−Already on OrderOTB equals Projected Sales plus Planned Ending Inventory minus Beginning Inventory minus Already on Order Key Components of an OTB Excel Template open to buy excel spreadsheet

: Inventory that has been purchased but not yet received. 3 Reasons to Use an OTB Spreadsheet