Shipping Ops Dashboard

1 · On-hand by SKU

snapshot history latest = 2026-06-01 (nightly cron broken since 2026-06-02 — matrix §2f; live reads unaffected)

tablet sellable definition: sellable-equivalent: Packiyo quantity_available (on_hand − allocated − reserved), floored at 0 per SKU; NEW SKUs only — USED tablets excluded (available=0 by design); NOT all-status on_hand (which would be 1073 new + 124 used)

BOM coverage (BOM completion 2026-07-17): 12 families tracked — devices, stands, bands, charger (USB-C Power Brick; the ONLY brick SKU in Packiyo, no USED/adapter variants), and 3 OSH booklets. Kit-complete is only valid once every BOM line is represented. Open BOM question: USB-C Charging Cable (avail 65 — complement of the brick, equally scarce, not summed with it). T-shirts excluded (reward program, not kit content).

2 · Knox capacity

Free-seat recompute: (a) strict per-key Σmax(0, purchased−assigned) = 1,127 — but purchased exists for 1/15 keys; 767 devices sit on active keys with NO purchased figure (1,489 more on expired keys) · (b) portal readout (PORTAL-READOUT (target_key_KLM12-G15J2; purchased-only capture)): headline free = 0 [OVERCOUNT-SUSPECT] — portal purchased 1445 (as_of 2026-07-17) − API-assigned 2201 (as_of 2026-09-07T12:02:03; includes stale device records — the subtraction over-counts usage, so this free figure is a floor) · Daily Tracker reference: 175 free @ 2026-07-15 DOCUMENTED

seat_leakage (API-assigned target − portal used): unknown — portal 'used' not captured in the 2026-07-17 readout (null); the per-key portal_seats_used 1359 is the 2026-03-26 scrape — stale, rejected as a 'used' source. Set knox_portal_readout.used from a fresh portal read to enable leakage = API-assigned − used MISSING
cross-check: DIVERGES from Daily Tracker by 175 seats (0 portal-based vs 175 tracker @ 2026-07-15) — figures kept separate, never averaged MEASURED

expiry timeline — active keys

devices on expired keys: 1,489 (KLM12-7KRBK 1,465, KLM12-FZHYR 16, KLM11-A3CWB 7, KLM11-FDB7R 1) — VERIFY vs Jul-8 E-FOTA remediation (~1,710): related but unconfirmed as the same population MEASURED

tiers: SKIP 4,176, Tier 1 2,321, Tier 2 656 · license valid: True

knox-manage-mcp exposes NO per-key expiry/seat tools (89 tools, boolean license check only). SUPERSEDED (small-add 2026-07-17): per-key expiry is now fed live from knox-license-api /overview into the expiry timeline + standing alerts — manual expiry tracking retired.

3 · Burn & runway

kit cost $308.8 CONFIG · runway = sellable ÷ burn; order-by = runout − lead time; confirmed-enroute quantities are listed but NOT credited to cover until receipt

4 · Inbound orders (POs — manual ledger)

Portal equipment requests (demand side, monthly)

5 · Outbound & carrier

packages / month

reship rate

6 · Returns & ROE

ROE rate band: ~8-12% (numerator-limited: packiyo_returns.received_at 100% NULL) DOCUMENTED
Stage-1 ask rate: 10.2% (33/324 tablets) DOCUMENTED · Stage-2 return rate: ~67-76% once a return box is sent DOCUMENTED
ROE-gate load: ~118 fires/month mature window (~4-7/day); ~7/mo are 3rd+ review-queue DOCUMENTED
Tablet lost bucket: 391 / 2,238 matured (17.5%, ≈$65,000) DOCUMENTED

defect failure modes (returned devices, round-3 audit)

engissuemonitor: 200 issues (cap 200) · severity {'P0': 179, 'P1': 8, 'None': 10, 'P2': 3} · category NULL for ~97% of issues — defect-category counts not viable from this feed yet (matrix §7b) MEASURED

7 · SIM — router — patient traceability

Granite SIMs

total 1,856 · activated 1,579 · suspended 2 · linked to routers 1,218 · linked to patients 876 · unlinked routers 638

last granite sync: 2026-09-06T12:27:31.356Z · cohort seeds: enrolled-45d 2,213 rows DOCUMENTED, disenrolled-45d 12,372 rows DOCUMENTED

8 · Intake as demand signal

milestones (all-time)