A good OTB spreadsheet should include the following rows/columns: Projected revenue for the month.
Provides a robust 6-month merchandise planning template with instructions. open to buy xls
Offers a step-by-step guide to building a 6-month plan in Excel. Tips for Effective OTB Management A good OTB spreadsheet should include the following
Stock on hand at the start of the month. open to buy xls
Offers a free template to map financial targets to inventory receipts. Profits Plus: Provides a free Excel OTB calculator.
The calculated budget available for new purchases. How to Calculate OTB in Excel The foundational formula used in most spreadsheets is:
Offers a template that calculates OTB at cost.