In FP&A in the retail industry, there is a concept of Open-to-Buy (OTB) planning. It is a challenging report to maintain in Excel and calculating it can be quite intricate.
OTB (Open-to-Buy) is a forward-looking metric based on future projections. In retail, it involves assessing current stock and estimating the exact amount of stock needed to achieve a predetermined target. It’s a blend of sales forecasting and stock planning, requiring accurate data and meticulous calculations.