Harbourline is a demonstration company we built and run — four stores, a distribution centre, thirteen months of trading. Nothing below is a customer’s result.
November's open-to-buy
Captured on 30 October 2026 with Claude through the AlmondTill connector; the figures re-read from Harbourline’s records on the same day (every one listed below).
What Harbourline should buy for November, category by category — and what to cut from the open orders when the answer is nothing.
The assignment
“Set our open-to-buy for November by category. Plan sales at last November plus 10%, aim to end the month with eight weeks of cover, and take off what we have on hand and on order. Where are we over-bought, and what should we cut from the open orders?”
What it used
- Last November's sales by category — the units, the net sales and the cost of goods for November 2025, read as a custom window.
- Last month's sell-through by style, over 30 days — today's cover, read and not planned.
- The stock on hand today, by style.
- The styles and the categories, so every style's sales and stock land in its own category.
- Every open order with its lines, and the variant, the product and the style behind each line.
- 61 report pages, 6 list walks and 245 calls in all, every one through the connector.
The budget rule is the assistant's arithmetic, not a platform report. Planned sales are last November's units plus 10 percent. The closing stock is 8 weeks of cover at that rate — 56 days over a 30-day month. What is on hand and on order comes off. What is left is the open-to-buy, at last November's average unit cost.
The proposal
Harbourline is over-bought in every category it planned. The stock on hand already covers November's plan and the closing stock, with months to spare. The open-to-buy for November 2026 is C$0.00: buy nothing new, and cut what the desk can cut. The first example filled gaps position by position; the open-to-buy looks at each whole category, and the whole is deep.
| Category | Last November | Net sales | Average cost | Planned | Planned closing | On hand | On order | Open-to-buy units | Open-to-buy | Verdict |
|---|---|---|---|---|---|---|---|---|---|---|
| Activewear | 656 | C$43,730.25 | C$25.14 | 722 | 1,348 | 6,021 | 1 | -3,952 | -C$99,353.28 | over-bought |
| Bags | 151 | C$10,956.92 | C$28.97 | 167 | 312 | 2,188 | 4 | -1,713 | -C$49,625.61 | over-bought |
| Belts | 174 | C$9,832.46 | C$21.93 | 192 | 359 | 2,151 | 2 | -1,602 | -C$35,131.86 | over-bought |
| Boys 2-8 | 894 | C$42,070.91 | C$17.69 | 984 | 1,837 | 6,556 | 1 | -3,736 | -C$66,089.84 | over-bought |
| Dresses | 656 | C$127,696.16 | C$74.21 | 722 | 1,348 | 6,127 | 9 | -4,066 | -C$301,737.86 | over-bought |
| Girls 2-8 | 953 | C$44,949.48 | C$17.93 | 1,049 | 1,959 | 6,382 | 0 | -3,374 | -C$60,495.82 | over-bought |
| Hats | 133 | C$9,778.87 | C$27.22 | 147 | 275 | 2,125 | 0 | -1,703 | -C$46,355.66 | over-bought |
| Jewellery | 153 | C$12,923.92 | C$32.85 | 169 | 316 | 2,199 | 0 | -1,714 | -C$56,304.90 | over-bought |
| Kids' | 1,689 | C$270,025.26 | C$61.47 | 1,858 | 3,469 | 16,782 | 42 | -11,497 | -C$706,720.59 | over-bought |
| Knitwear | 1,338 | C$183,265.58 | C$52.92 | 1,472 | 2,748 | 12,039 | 12 | -7,831 | -C$414,416.52 | over-bought |
| Men's | 1,504 | C$245,714.92 | C$61.79 | 1,655 | 3,090 | 16,024 | 53 | -11,332 | -C$700,204.28 | over-bought |
| Outerwear | 1,355 | C$425,996.92 | C$118.70 | 1,491 | 2,784 | 11,643 | 0 | -7,368 | -C$874,581.60 | over-bought |
| Scarves & Gloves | 141 | C$11,771.29 | C$30.50 | 156 | 292 | 2,235 | 0 | -1,787 | -C$54,503.50 | over-bought |
| Shirts | 625 | C$54,375.52 | C$32.25 | 688 | 1,285 | 5,708 | 8 | -3,743 | -C$120,711.75 | over-bought |
| Skirts | 707 | C$49,730.47 | C$26.72 | 778 | 1,453 | 5,692 | 6 | -3,467 | -C$92,638.24 | over-bought |
| Suiting | 719 | C$230,914.78 | C$120.55 | 791 | 1,477 | 6,631 | 0 | -4,363 | -C$525,959.65 | over-bought |
| Tees | 628 | C$24,812.17 | C$15.20 | 691 | 1,290 | 5,860 | 119 | -3,998 | -C$60,769.60 | over-bought |
| Tops | 759 | C$48,199.20 | C$24.12 | 835 | 1,559 | 6,788 | 72 | -4,466 | -C$107,719.92 | over-bought |
| Trousers & Denim | 1,431 | C$165,933.25 | C$43.90 | 1,575 | 2,940 | 11,707 | 31 | -7,223 | -C$317,089.70 | over-bought |
| Women's | 1,978 | C$266,259.95 | C$51.25 | 2,176 | 4,062 | 18,358 | 0 | -12,120 | -C$621,150.00 | over-bought |
| Youth 8-14 | 964 | C$46,803.83 | C$18.07 | 1,061 | 1,981 | 6,221 | 0 | -3,179 | -C$57,444.53 | over-bought |
Three names stand twice in the catalogue — Knitwear, Outerwear and Trousers & Denim. The sales report shows one line per name, so the plan reads each pair as one row. Measured against last month's sales, the stock on hand runs from 199.8 days of cover in Youth 8-14 to 486.2 days in Bags.
What the platform can do with an open order is narrow by design. An issued order is cancelled whole, or closed short when it is received. A partly received or acknowledged order is not cancelled from the desk. A partial cut is a word with the supplier, not a platform act. There were no draft orders to trim, so no line was reduced or removed.
The orders to cancel — every line on each is over-bought stock:
| Order | Supplier | Still to arrive | Proposed |
|---|---|---|---|
| this week's order 2 — Harlow Knit Co. (Montréal) | Harlow Knit Co. (Montréal) | 32 units | cancel whole |
| this week's order 3 — Bastien Paris SARL | Bastien Paris SARL | 16 units | cancel whole |
| purchase order 5 lines | Ninety Mile Ltd. (Melbourne) | 13 units | cancel whole |
| purchase order 13 lines | Bastien Paris SARL | 32 units | cancel whole |
| purchase order 7 lines | Tanner & Sons Footwear (Leeds) | 119 units | cancel whole |
| purchase order 3 lines | Vela Activewear (Vancouver) | 18 units | cancel whole |
| purchase order 2 lines | Petit Nord Enfants (Québec) | 12 units | cancel whole |
| purchase order 4 lines | Harbourline Manufacturing (Vaughan) | 24 units | cancel whole |
| purchase order 3 lines | Port Dover Outerwear Ltd. | 8 units | cancel whole |
| purchase order 7 lines | Harlow Knit Co. (Montréal) | 29 units | cancel whole |
The orders it leaves standing — past issue, so the desk has no cancel for them:
| Order | Supplier | Status | Still to arrive |
|---|---|---|---|
| purchase order 14 lines | Harbourline Manufacturing (Vaughan) | partly received | 1 units |
| purchase order 15 lines | Harbourline Manufacturing (Vaughan) | partly received | 1 units |
| purchase order 10 lines | Harbourline Manufacturing (Vaughan) | partly received | 1 units |
| purchase order 2 lines | Harbourline Manufacturing (Vaughan) | partly received | 2 units |
| purchase order 3 lines | Lakeshore Mills (Cambridge ON) | partly received | 2 units |
| purchase order 17 lines | Harbourline Manufacturing (Vaughan) | partly received | 2 units |
| this week's order 1 — Harbourline Manufacturing (Vaughan) | Harbourline Manufacturing (Vaughan) | acknowledged by the supplier | 48 units |
In all: 10 orders to cancel and 7 left standing; 303 units that would otherwise still arrive; 0 draft lines reduced and 0 removed. Every cancel was rehearsed through the connector — 10 rehearsals, none confirmed.
The follow-ups
“Hold knitwear as planned, but trim outerwear so November's buy stays under C$40,000.”
There is nothing to trim. The buy is already C$0.00, under the C$40,000.00 cap, before any trim. The assistant trimmed 0 units from Outerwear. Its plan stands at 1,491 units and its closing stock at 2,784; its open-to-buy is -C$874,581.60, over-bought, not a buy. Knitwear is held as planned: 1,472 planned units against 12,039 on hand and 12 on order. November's buy after the follow-up is C$0.00, under the cap.
The exceptions
- Every category with sales last November was planned; no sales row was left out for its currency or its name. 0 stock rows and 0 sell-through rows matched no style; 0 styles had no category.
- No category has an open-to-buy above zero, so November's buy is C$0.00 before the follow-up and C$0.00 after it.
- 7 open orders touch over-bought stock and cannot be cancelled from the desk: they are past issue. Any cut there is a word with the supplier.
What stayed the merchant's call
The assistant wrote nothing. Every cancel above was rehearsed through the connector and shown with its confirmation token; none was confirmed. The open orders stand as they were. The open-to-buy is a recommendation, not a budget on file. The uplift, the weeks of cover and the cap are the assistant's arithmetic over the platform's figures; the merchant can change any of them. The owner's own session, with these prompts put to the assistant, follows.
Where every figure comes from
Every figure on this page is read from the run file at the render. Each one is a call’s answer by its number, or a figure derived from the answers by the formula beside it. Nothing is typed.
| Figure | Value | Read from |
|---|---|---|
| capturedAt | 30 October 2026 | the run file — the figures’ capture instant |
| company.name | Harbourline | the run file — the capture’s own record |
| derived.facts.calls | 245 | derived — every call of the run, counted |
| derived.facts.listWalks | 6 | derived — the list walks — one per operation and input without its page token, counted |
| derived.facts.pages | 61 | derived — the report pages read — the report_run calls and the run_read reportRun pages, counted |
| derived.otb.buy | C$0.00 | derived — November’s buy — the open-to-buy money over the categories where it is above zero, added |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.avgUnitCost | C$24.12 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.lastNovNet | C$48,199.20 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.lastNovUnits | 759 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.onHandUnits | 6,788 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.onOrderUnits | 72 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.otbMoney | -C$107,719.92 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.otbUnits | -4,466 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.plannedClosingUnits | 1,559 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.plannedUnits | 835 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.avgUnitCost | C$52.92 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.lastNovNet | C$183,265.58 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.lastNovUnits | 1,338 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.onHandUnits | 12,039 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.onOrderUnits | 12 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.otbMoney | -C$414,416.52 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.otbUnits | -7,831 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.plannedClosingUnits | 2,748 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.plannedUnits | 1,472 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.avgUnitCost | C$74.21 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.lastNovNet | C$127,696.16 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.lastNovUnits | 656 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.onHandUnits | 6,127 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.onOrderUnits | 9 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.otbMoney | -C$301,737.86 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.otbUnits | -4,066 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.plannedClosingUnits | 1,348 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.plannedUnits | 722 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.avgUnitCost | C$26.72 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.lastNovNet | C$49,730.47 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.lastNovUnits | 707 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.onHandUnits | 5,692 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.onOrderUnits | 6 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.otbMoney | -C$92,638.24 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.otbUnits | -3,467 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.plannedClosingUnits | 1,453 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.plannedUnits | 778 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.avgUnitCost | C$43.90 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.lastNovNet | C$165,933.25 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.lastNovUnits | 1,431 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.onHandUnits | 11,707 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.onOrderUnits | 31 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.otbMoney | -C$317,089.70 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.otbUnits | -7,223 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.plannedClosingUnits | 2,940 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.plannedUnits | 1,575 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.avgUnitCost | C$118.70 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.lastNovNet | C$425,996.92 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.lastNovUnits | 1,355 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.onHandUnits | 11,643 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.otbMoney | -C$874,581.60 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.otbUnits | -7,368 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.plannedClosingUnits | 2,784 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.plannedUnits | 1,491 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.avgUnitCost | C$25.14 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.lastNovNet | C$43,730.25 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.lastNovUnits | 656 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.onHandUnits | 6,021 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.onOrderUnits | 1 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.otbMoney | -C$99,353.28 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.otbUnits | -3,952 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.plannedClosingUnits | 1,348 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.plannedUnits | 722 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.avgUnitCost | C$32.25 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.lastNovNet | C$54,375.52 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.lastNovUnits | 625 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.onHandUnits | 5,708 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.onOrderUnits | 8 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.otbMoney | -C$120,711.75 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.otbUnits | -3,743 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.plannedClosingUnits | 1,285 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.plannedUnits | 688 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.avgUnitCost | C$15.20 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.lastNovNet | C$24,812.17 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.lastNovUnits | 628 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.onHandUnits | 5,860 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.onOrderUnits | 119 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.otbMoney | -C$60,769.60 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.otbUnits | -3,998 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.plannedClosingUnits | 1,290 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.plannedUnits | 691 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.avgUnitCost | C$120.55 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.lastNovNet | C$230,914.78 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.lastNovUnits | 719 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.onHandUnits | 6,631 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.otbMoney | -C$525,959.65 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.otbUnits | -4,363 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.plannedClosingUnits | 1,477 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.plannedUnits | 791 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.avgUnitCost | C$17.93 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.lastNovNet | C$44,949.48 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.lastNovUnits | 953 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.onHandUnits | 6,382 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.otbMoney | -C$60,495.82 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.otbUnits | -3,374 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.plannedClosingUnits | 1,959 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.plannedUnits | 1,049 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.avgUnitCost | C$17.69 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.lastNovNet | C$42,070.91 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.lastNovUnits | 894 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.onHandUnits | 6,556 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.onOrderUnits | 1 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.otbMoney | -C$66,089.84 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.otbUnits | -3,736 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.plannedClosingUnits | 1,837 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.plannedUnits | 984 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.avgUnitCost | C$18.07 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.currentCoverDays | 199.8 | derived — the units on hand divided by last month’s daily rate — on hand times last month’s days over its units sold, at one place; none when nothing sold |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.lastNovNet | C$46,803.83 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.lastNovUnits | 964 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.onHandUnits | 6,221 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.otbMoney | -C$57,444.53 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.otbUnits | -3,179 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.plannedClosingUnits | 1,981 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.plannedUnits | 1,061 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.avgUnitCost | C$30.50 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.lastNovNet | C$11,771.29 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.lastNovUnits | 141 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.onHandUnits | 2,235 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.otbMoney | -C$54,503.50 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.otbUnits | -1,787 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.plannedClosingUnits | 292 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.plannedUnits | 156 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.avgUnitCost | C$27.22 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.lastNovNet | C$9,778.87 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.lastNovUnits | 133 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.onHandUnits | 2,125 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.otbMoney | -C$46,355.66 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.otbUnits | -1,703 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.plannedClosingUnits | 275 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.plannedUnits | 147 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.avgUnitCost | C$28.97 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.currentCoverDays | 486.2 | derived — the units on hand divided by last month’s daily rate — on hand times last month’s days over its units sold, at one place; none when nothing sold |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.lastNovNet | C$10,956.92 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.lastNovUnits | 151 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.onHandUnits | 2,188 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.onOrderUnits | 4 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.otbMoney | -C$49,625.61 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.otbUnits | -1,713 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.plannedClosingUnits | 312 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.plannedUnits | 167 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.avgUnitCost | C$21.93 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.lastNovNet | C$9,832.46 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.lastNovUnits | 174 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.onHandUnits | 2,151 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.onOrderUnits | 2 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.otbMoney | -C$35,131.86 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.otbUnits | -1,602 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.plannedClosingUnits | 359 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.plannedUnits | 192 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.avgUnitCost | C$32.85 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.lastNovNet | C$12,923.92 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.lastNovUnits | 153 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.onHandUnits | 2,199 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.otbMoney | -C$56,304.90 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.otbUnits | -1,714 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.plannedClosingUnits | 316 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.plannedUnits | 169 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.avgUnitCost | C$51.25 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.lastNovNet | C$266,259.95 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.lastNovUnits | 1,978 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.onHandUnits | 18,358 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.onOrderUnits | 0 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.otbMoney | -C$621,150.00 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.otbUnits | -12,120 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.plannedClosingUnits | 4,062 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.plannedUnits | 2,176 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.avgUnitCost | C$61.79 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.lastNovNet | C$245,714.92 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.lastNovUnits | 1,504 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.onHandUnits | 16,024 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.onOrderUnits | 53 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.otbMoney | -C$700,204.28 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.otbUnits | -11,332 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.plannedClosingUnits | 3,090 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.plannedUnits | 1,655 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.avgUnitCost | C$61.47 | derived — the comparison month’s cost of goods divided by its units sold, half-up to the cent |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.lastNovNet | C$270,025.26 | derived — the net sales of the comparison month for the group — every row carrying its caption, added over the pages in cents |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.lastNovUnits | 1,689 | derived — the units sold in the comparison month — every sales-by-category row carrying the group’s caption, added over the pages |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.onHandUnits | 16,782 | derived — the stock on hand now, added over the group’s styles (the stock-on-hand rows by style caption, added over the pages) |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.onOrderUnits | 42 | derived — the ordered less the received quantity over every line of the open orders (issued, acknowledged, partly received) whose style is in the group |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.otbMoney | -C$706,720.59 | derived — the open-to-buy units times the average unit cost, in cents |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.otbUnits | -11,497 | derived — the planned units plus the planned closing units, less the units on hand, less the units on order |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.plannedClosingUnits | 3,469 | derived — the planned units divided by the month’s thirty days, times the days of cover, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.plannedUnits | 1,858 | derived — last November’s units times one plus the uplift, rounded up to a whole unit |
| derived.otb.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.verdict | over-bought | derived — over-bought when the open-to-buy units fall below zero, open-to-buy otherwise |
| derived.otb.cuts.cancelled | 10 | derived — the issued orders cancelled whole, counted |
| derived.otb.cuts.listed | 7 | derived — the open orders listed and not cut, counted |
| derived.otb.cuts.reduced | 0 | derived — the draft lines reduced, counted |
| derived.otb.cuts.removed | 0 | derived — the draft lines removed, counted |
| derived.otb.cuts.units | 303 | derived — the units taken back by every cut, added |
| derived.otb.orders.01993c4b-6c82-712a-85e0-14ae4a1ec456.outstandingUnits | 1 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01993c4b-6c82-74e5-8a95-e9e34f9b0408.outstandingUnits | 1 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01993c4b-6c82-7508-bc60-87213cbe4f2e.outstandingUnits | 1 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01993c4b-6c82-7c0d-96b7-e3f5c962ed62.outstandingUnits | 2 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.019aece1-9c82-717c-a244-c95f1da1b3d2.outstandingUnits | 2 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.019eba33-8882-7f76-adac-9d8119d7c523.outstandingUnits | 2 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a175e3-af97-7d36-8007-3827bad9c5c8.outstandingUnits | 48 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a175e3-b7f0-7701-ac16-e949cd40f967.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a175e3-b7f0-7701-ac16-e949cd40f967.outstandingUnits | 32 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a175e3-bdcf-7011-b53a-f9e4fecbdd53.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a175e3-bdcf-7011-b53a-f9e4fecbdd53.outstandingUnits | 16 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d1-6117-7c7f-975e-c8fc7a1006b7.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d1-6117-7c7f-975e-c8fc7a1006b7.outstandingUnits | 13 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-2c8a-7f6f-87a0-b1918f3b3748.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-2c8a-7f6f-87a0-b1918f3b3748.outstandingUnits | 32 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-4092-7aa3-94f1-81c5e7be32ca.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-4092-7aa3-94f1-81c5e7be32ca.outstandingUnits | 119 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-5ce6-7c0c-a80e-3320a761dfa8.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-5ce6-7c0c-a80e-3320a761dfa8.outstandingUnits | 18 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-6a4d-7ed7-8c94-649b9693929b.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-6a4d-7ed7-8c94-649b9693929b.outstandingUnits | 12 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-78a8-7267-bd84-bbbb13435cf4.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-78a8-7267-bd84-bbbb13435cf4.outstandingUnits | 24 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-8866-782e-8291-cef6a3bff715.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-8866-782e-8291-cef6a3bff715.outstandingUnits | 8 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.orders.01a186d2-9acd-7339-a9f2-3877e3ab835e.act | cancel | derived — cancel when the issued order is cut whole, none when it is listed and not a platform act, nothing otherwise |
| derived.otb.orders.01a186d2-9acd-7339-a9f2-3877e3ab835e.outstandingUnits | 29 | derived — the ordered less the received quantity over the order’s lines, added |
| derived.otb.plan.comparison | November 2025 | derived — the month the plan compares with, from the narrative definition |
| derived.otb.plan.coverDays | 56 | derived — the weeks of cover from the narrative’s caps, times seven |
| derived.otb.plan.lastMonthDays | 30 | derived — the days of last month, read from the sell-through page’s own period words |
| derived.otb.plan.monthDays | 30 | derived — the plan month’s length the daily rate divides by — thirty, by convention |
| derived.otb.rehearsals.sent | 10 | derived — the run_write rehearsals the capture sent — every one the operation’s words and a token never sent back, counted |
| derived.otb.trimmed.buyAfter | C$0.00 | derived — November’s buy after the trim |
| derived.otb.trimmed.otbMoney | -C$874,581.60 | derived — the trimmed category’s open-to-buy money after the trim |
| derived.otb.trimmed.plannedClosingUnits | 2,784 | derived — the trimmed category’s planned closing units after the trim — the same formula over the trimmed plan |
| derived.otb.trimmed.plannedUnits | 1,491 | derived — the trimmed category’s planned units after the trim |
| derived.otb.trimmed.trimmedUnits | 0 | derived — the smallest number of planned units taken off the trimmed category that brings November’s buy under the cap — its whole plan when none does |
| derived.otb.unmatched.soldKeys | 0 | derived — the sell-through row keys no walked style carries, counted |
| derived.otb.unmatched.stockKeys | 0 | derived — the stock-on-hand row keys no walked style carries, counted |
| derived.otb.unmatched.unplacedStyles | 0 | derived — the walked styles with no category placement, counted |
| names.categories.01a16b0e-be0a-7a3e-98b3-ae6f7cd87c2f.caption | Tops | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-beaf-7599-a81b-3c29cd578979.caption | Knitwear | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c009-71ec-8ed2-f553eed63bc9.caption | Dresses | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c0bf-702c-8ba3-ecfaa6f82f11.caption | Skirts | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c1aa-774c-8e71-22e2acbaaa25.caption | Trousers & Denim | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c2aa-706f-a09d-49b44d4bd7a9.caption | Outerwear | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c3a1-7970-8ebe-2c2fc843a933.caption | Activewear | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c4a2-7b01-8056-f7874e053688.caption | Shirts | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c69b-7c3e-93d2-b3f542e5566b.caption | Tees | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-c984-7a2e-bb6b-dbac5bcd4745.caption | Suiting | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-ca71-7b8e-86c2-312dbdbed45d.caption | Girls 2-8 | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-cb70-7ee3-b6ae-3c3b30980940.caption | Boys 2-8 | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-cc61-7f44-b9f1-58f1913ba77e.caption | Youth 8-14 | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-cd5e-7cef-896d-28ef8f569788.caption | Scarves & Gloves | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-ce54-7d00-a20a-3162ae44fd62.caption | Hats | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-cf50-7d99-9b33-348c6d141abd.caption | Bags | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-d06d-710b-87bb-b3923d81c3c2.caption | Belts | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-d191-759f-b982-3e3e54a6e6e7.caption | Jewellery | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-d278-71ea-b144-fd1f7aa416ad.caption | Women's | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-d33c-7fe0-8196-4731942f8a7d.caption | Men's | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.categories.01a16b0e-d485-7b2c-addc-9be77108f7c9.caption | Kids' | the run’s names — run_read categories (call 71), read 30 October 2026 |
| names.orders.01993c4b-6c82-712a-85e0-14ae4a1ec456.caption | purchase order 14 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01993c4b-6c82-74e5-8a95-e9e34f9b0408.caption | purchase order 15 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01993c4b-6c82-7508-bc60-87213cbe4f2e.caption | purchase order 10 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01993c4b-6c82-7c0d-96b7-e3f5c962ed62.caption | purchase order 2 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.019aece1-9c82-717c-a244-c95f1da1b3d2.caption | purchase order 3 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.019eba33-8882-7f76-adac-9d8119d7c523.caption | purchase order 17 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a175e3-af97-7d36-8007-3827bad9c5c8.caption | this week's order 1 — Harbourline Manufacturing (Vaughan) | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a175e3-b7f0-7701-ac16-e949cd40f967.caption | this week's order 2 — Harlow Knit Co. (Montréal) | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a175e3-bdcf-7011-b53a-f9e4fecbdd53.caption | this week's order 3 — Bastien Paris SARL | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d1-6117-7c7f-975e-c8fc7a1006b7.caption | purchase order 5 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-2c8a-7f6f-87a0-b1918f3b3748.caption | purchase order 13 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-4092-7aa3-94f1-81c5e7be32ca.caption | purchase order 7 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-5ce6-7c0c-a80e-3320a761dfa8.caption | purchase order 3 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-6a4d-7ed7-8c94-649b9693929b.caption | purchase order 2 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-78a8-7267-bd84-bbbb13435cf4.caption | purchase order 4 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-8866-782e-8291-cef6a3bff715.caption | purchase order 3 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.orders.01a186d2-9acd-7339-a9f2-3877e3ab835e.caption | purchase order 7 lines | the run’s names — the orders (get_record PurchaseOrder), read 30 October 2026 |
| names.vendors.01a16e70-d5e1-74bf-9123-da58c2929156.caption | Harbourline Manufacturing (Vaughan) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-d9f2-7034-b7a5-cfad6a13ec23.caption | Lakeshore Mills (Cambridge ON) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-de0f-7b8b-a029-2288d8c05cc1.caption | Harlow Knit Co. (Montréal) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-e217-7cfd-b20b-9c1978a2a17a.caption | Bastien Paris SARL | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-e634-7b0d-ab7a-027a3bf1ed74.caption | Ninety Mile Ltd. (Melbourne) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-f277-7191-9e22-e0bfc4b3ff18.caption | Port Dover Outerwear Ltd. | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-f696-78b0-bdfd-e47683db24af.caption | Petit Nord Enfants (Québec) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-faa9-760c-a5d4-70f386c81e7d.caption | Tanner & Sons Footwear (Leeds) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| names.vendors.01a16e70-fec3-7487-b8f2-b2bc78560d94.caption | Vela Activewear (Vancouver) | the run’s names — run_read orgVendors (call 72), read 30 October 2026 |
| narrative.assignment | Set our open-to-buy for November by category. Plan sales at last November plus 10%, aim to end the month with eight weeks of cover, and take off what we have on hand and on order. Where are we over-bought, and what should we cut from the open orders? | the narrative’s run — the operator’s session, banked beside the run file |
| narrative.caps.buyCap | C$40,000.00 | the narrative’s run — the operator’s session, banked beside the run file |
| narrative.caps.coverWeeks | 8 | the narrative’s run — the operator’s session, banked beside the run file |
| narrative.caps.uplift | 10 | the narrative’s run — the operator’s session, banked beside the run file |
| narrative.followUps.0 | Hold knitwear as planned, but trim outerwear so November's buy stays under C$40,000. | the narrative’s run — the operator’s session, banked beside the run file |
| narrative.months.plan | November 2026 | the narrative’s run — the operator’s session, banked beside the run file |
The tool calls
- whats_next — 1 call
- run_read · me — 1 call
- org_layout — 1 call
- run_read · reportRun — 13 calls
- report_run · sell_through — 28 calls
- report_run · stock_on_hand — 19 calls
- run_read · styles — 7 calls
- run_read · categories — 1 call
- run_read · orgVendors — 1 call
- report_run · open_purchase_orders — 1 call
- run_read · purchaseOrders — 4 calls
- get_record · PurchaseOrder — 17 calls
- get_record · Variant — 107 calls
- get_record · Product — 34 calls
- run_write · cancelPurchaseOrder — 10 calls