darikwaOpen to buy
Enter each category's opening stock, orders placed, sales forecast and the closing cover you want to see the open to buy in units and at cost, the cover each category will close on, and a flag for stock-outs and overbought categories.
- 1.How many more units to buy in each category, and what that costs.
- 2.Which categories are overbought, and by how much.
- 3.The weeks of cover each category will close on.
- 4.Which categories run out before the period ends.
| # | Category | Open to buy (units) | At cost | Closing cover (wks) | Status | Weekly rate | Supply | Projected closing | Opening stock (units) | On order (units) | Forecast sales (units) | Weeks in period | Target closing cover (weeks) | Average unit cost (£) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 576 | £12,099 | -2.3 | Stock-out | 55.8 | 1,320 | -130 | ||||||||
| 152 | £2,803 | 5.4 | Low | 57.7 | 1,810 | 310 | ||||||||
| -580 | -£15,660 | 21.6 | Overbought | 50.0 | 2,380 | 1,080 | ||||||||
| 368 | £5,883 | -8.9 | Stock-out | 24.6 | 420 | -220 | ||||||||
| 40 | £480 | 6.0 | Low | 20.0 | 640 | 120 | ||||||||
| -504 | -£3,779 | 24.6 | Overbought | 34.6 | 1,750 | 850 | ||||||||
| 0 | £0 | 8.0 | Adequate | 10.0 | 340 | 80 | ||||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings (cover bands) · Categories (open to buy) · Summary.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.