Is the money in the right shape. Category, brand and price-band composition against what actually sells, and how that gap has moved. snapshot 29-07-2026 09:00 GST from inventory_balance_daily + mix_snapshots
| Category | Units | Held % | Sold % | Drift bps | Cost AED | Retail AED | Cover d |
|---|---|---|---|---|---|---|---|
| Watches | 14,668 | 28.0% | 22.4% | +560 | 2.98M | 9.84M | 52 |
| Jewellery | 11,525 | 22.0% | 26.1% | -410 | 1.86M | 6.72M | 35 |
| Handbags | 7,858 | 15.0% | 11.8% | +320 | 2.21M | 7.10M | 61 |
| Perfume | 5,762 | 11.0% | 17.6% | -660 | 0.72M | 2.94M | 21 |
| Home | 4,715 | 9.0% | 6.2% | +280 | 0.44M | 1.52M | 78 |
| Accessories | 3,667 | 7.0% | 9.4% | -240 | 0.29M | 1.28M | 27 |
| Straps | 2,095 | 4.0% | 3.1% | +90 | 0.08M | 0.46M | 48 |
| Sunglasses | 1,048 | 2.0% | 2.2% | -20 | 0.13M | 0.72M | 33 |
| Apparel | 786 | 1.5% | 0.9% | +60 | 0.06M | 0.32M | 96 |
| Other | 263 | 0.5% | 0.3% | +20 | 0.02M | 0.10M | 88 |
| Total | 52,387 | 100% | 100% | 412 mean abs | 9.61M | 31.20M | 42 |
| Category | HQ_319 | MCC | YAS | AJM | CCZ | CONS | IN_PROD | GIT | Total |
|---|---|---|---|---|---|---|---|---|---|
| Watches | 8,91261% | 1,0247% | 8806% | 7045% | 5864% | 1461% | 1,76012% | 6564% | 14,668 |
| Jewellery | 6,68458% | 9228% | 6926% | 5765% | 4614% | 6906% | 1,26811% | 2322% | 11,525 |
| Handbags | 4,24454% | 94312% | 7079% | 5507% | 3935% | 6288% | 3154% | 781% | 7,858 |
| Perfume | 2,70847% | 80714% | 63411% | 5199% | 4037% | 1733% | 1162% | 4027% | 5,762 |
| Home | 3,34771% | 4249% | 3307% | 2365% | 1894% | 932% | 00% | 962% | 4,715 |
| Accessories | 1,79649% | 51314% | 40311% | 3309% | 2577% | 1484% | 401% | 1805% | 3,667 |
| Straps | 1,23659% | 1688% | 1266% | 1055% | 804% | 402% | 34016% | 00% | 2,095 |
| Sunglasses | 14814% | 545% | 404% | 323% | 242% | 101% | 32031% | 42040% | 1,048 |
| Apparel | 36246% | 14218% | 10213% | 719% | 476% | 628% | 00% | 00% | 786 |
| Other | 12146% | 5320% | 3413% | 239% | 176% | 156% | 00% | 00% | 263 |
| Total | 29,558 | 5,050 | 3,948 | 3,146 | 2,457 | 2,005 | 4,159 | 2,064 | 52,387 |
| Band | Units | Held % | Sold % | Drift | Cost AED | Sell-through |
|---|---|---|---|---|---|---|
| Entry | 18,336 | 35.0% | 42.0% | -700 | 1.28M | 4.1%/wk |
| Core | 15,716 | 30.0% | 31.0% | -100 | 2.35M | 3.4%/wk |
| Premium | 10,477 | 20.0% | 17.0% | +300 | 2.79M | 2.6%/wk |
| Luxury | 6,286 | 12.0% | 8.0% | +400 | 2.31M | 1.9%/wk |
| Maison | 1,572 | 3.0% | 2.0% | +100 | 0.88M | 1.1%/wk |
| Total | 52,387 | 100% | 100% | 320 mean abs | 9.61M | 3.2%/wk |
| Segment | Dimension | Units | Held % | Sold % | Drift | Drift bps | Capital at risk | Cover d | Recommended action |
|---|---|---|---|---|---|---|---|---|---|
| Perfume | category | 5,762 | 11.0% | 17.6% | -660 |
-660 | AED 0.29M | 21 | Raise PO, cover is 21d → |
| Watches | category | 14,668 | 28.0% | 22.4% | +560 |
+560 | AED 0.59M | 52 | Slow the 1,760u in production → |
| Entry band | price band | 18,336 | 35.0% | 42.0% | -700 |
-700 | AED 0.18M | 24 | Reorder the entry tier → |
| Jewellery | category | 11,525 | 22.0% | 26.1% | -410 |
-410 | AED 0.14M | 35 | Rebalance from HQ_319 → |
| Luxury band | price band | 6,286 | 12.0% | 8.0% | +400 |
+400 | AED 0.42M | 67 | Review slow movers → |
| Handbags | category | 7,858 | 15.0% | 11.8% | +320 |
+320 | AED 0.48M | 61 | 4 dead SKUs, AED 187K → |
| Premium band | price band | 10,477 | 20.0% | 17.0% | +300 |
+300 | AED 0.31M | 49 | Hold, within tolerance |
| Home | category | 4,715 | 9.0% | 6.2% | +280 |
+280 | AED 0.16M | 78 | Candle line is 312d cover → |
| Accessories | category | 3,667 | 7.0% | 9.4% | -240 |
-240 | AED 0.07M | 27 | Watch, within tolerance |
| Lulwa · Handbags | brand x category | 2,516 | 4.8% | 3.0% | +180 |
+180 | AED 0.34M | 72 | Push to consignment → |
| Straps | category | 2,095 | 4.0% | 3.1% | +90 |
+90 | AED 0.02M | 48 | Hold |
| Sunglasses | category | 1,048 | 2.0% | 2.2% | -20 |
-20 | AED 0.00M | 33 | 740u still in the pipeline → |
| Apparel | category | 786 | 1.5% | 0.9% | +60 |
+60 | AED 0.03M | 96 | Aging, review → |
| Maison band | price band | 1,572 | 3.0% | 2.0% | +100 |
+100 | AED 0.29M | 88 | Intentional, maison positioning |
| Other | category | 263 | 0.5% | 0.3% | +20 |
+20 | AED 0.00M | 88 | Hold |
Mix is a subtraction, not a forecast. Held share comes from inventory_balance_daily, sold share from the ledger's outbound rows over 90 days, and drift is one minus the other in basis points. There is no elasticity model here, and the page never predicts what a price change would do.
Composite parents are absent. Their components carry the units and are already counted in their own categories; counting a giftbox and its watch would inflate Watches by the number of giftboxes.
Mix needs at least one mix_snapshots row. The nightly job runs at 00:05 Dubai.
Mix by cost and retail needs the finance.read scope. Unit shares are visible to everyone.
Request access