Retail OTB (Open to Buy) Planning with PowerExcel

Aug 15, 2023

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. 

If you are work in a corporate retail scenario and handle any kind of Open-to-Buy or OTB Reporting, you are going to want to check out this new blog and video from PARIS Tech.