: Inventory that has been purchased but not yet received. 3 Reasons to Use an OTB 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 open to buy excel 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 : Inventory that has been purchased but not yet received
: The retail value of stock on hand at the start of the period. open to buy excel spreadsheet