Open-to-buy calculator
A working OTB workbook: planned sales, inventory, on-order and receipts in one place, with the OTB number computed live. The reference for how a healthy OTB should be structured before it's worth automating.
This is the OTB the way it should be set up before the spreadsheet becomes the bottleneck — a clear planned sales line, a clear ending-stock target, a receipts plan and the OTB falling out of the math.
What's in it
Category-level OTB by month, with sales, EOM stock, on-order, receipts and the OTB figure linked. A working sheet you can paste a real category into.
Where it gets stuck
As soon as the bottom-up forecast moves mid-season, or supplier slips arrive, or a channel mix shifts, the workbook needs reworking by hand. The OTB shown is true on Friday and stale by Wednesday. Modern planning systems take that work over.