darikwaMarkdown planner
Enter the lines you are thinking of marking down, with stock, cost, prices and recent rate of sale. Try a markdown on each to see the units it should clear, the cash it releases at cost, the margin it gives up, and which lines would sell below cost.
- 1.How many units each line should sell over the sale.
- 2.The cash released at cost, and the margin given up.
- 3.Which lines clear, which only partly clear, and which sell below cost.
- 4.The blended margin of the sale.
| # | Style | New price | Units sold | Cleared | Status | Cash released at cost | Margin given up | New margin | Description | Stock (units) | Unit cost (£) | Full price inc VAT (£) | Current price inc VAT (£) | Weekly rate of sale (units) | Markdown % off full price |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| £66.50 | 64 | 100% | Clears | £1,343 | £1,519 | 62.1% | |||||||||
| £59.25 | 90 | 44% | Partial | £1,665 | £0 | 62.5% | |||||||||
| £39.00 | 59 | 54% | Partial | £945 | £1,279 | 50.8% | |||||||||
| £34.30 | 39 | 98% | Clears | £472 | £154 | 58.0% | |||||||||
| £96.00 | 119 | 99% | Clears | £3,222 | £2,387 | 66.3% | |||||||||
| £17.50 | 24 | 15% | Partial | £228 | £350 | 34.9% | |||||||||
| £48.00 | 6 | 21% | Below cost | £268 | £335 | -20.0% | |||||||||
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 (sale rule) · Lines (projection) · Sale 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.