Shipping Ops Dashboard

1 · On-hand by SKU

family	sellable (new)	on-hand new	used pool	BOM/kit	unmatched SKUs
tablet	1,188	1,606	297	1.00	—
tablet_stand	1,369	1,390	0	1.00	—
bp_cuff	156	185	19	1.00	—
pulse_ox	1,321	1,343	0	1.00	—
router	3,029	3,056	21	0.17	—
scale	238	264	4	1.00	—
loop_bands	2,483	2,500	2	1.00	—
therabands	2,495	2,512	7	1.00	—
charger	121	138	0	1.00	—
booklet_1	769	788	0	1.00	—
booklet_2	762	778	0	1.00	—
booklet_3	782	798	0	1.00	—

MEASURED computed from per_sku × sku_families config · as of 2026-10-26T05:30:02

per-SKU detail (35 tracked SKUs)

SKU	name	on-hand	allocated	available	backordered
Ans-1001-ResB	PhysicalDevice Resistance Bands	2,512	17	2,495	0
Ans-1002-LoopB	PhysicalDevice Loop Resistance Bands	2,500	17	2,483	0
Ans-1007-TabStand	PhysicalDevice Tablet Stand	1,390	17	1,369	0
Kit C	Kit C Router Only	1,379	4	1,375	0
Ans-1016-POx	AOJ -70D	1,342	17	1,321	0
KIT A	Kit A Tablet + Router	967	2	955	0
KIT A	Kit A Tablet + Router	967	2	955	0
Ansible OSH Booklet 3	Ansible OSH Booklet 3	798	16	782	0
Ansible OSH Booklet 1	Ansible OSH Booklet 1	788	16	769	0
Ansible OSH Booklet 2	Ansible OSH Booklet 2	778	16	762	0
KIT B	Kit B Tablet Only	639	9	233	0
Spitz Router GL-X750 V2	Spitz Router GL-X750 V2	473	4	466	0
USED-TABLET-A9	USED SAMSUNG GALAXY TAB A9+	295	0	0	0
Ans-1011-WScale	Bodyweight Scale GBS-2012-B	264	18	238	0
Router: Opal WiFi	Router: Opal WiFi	237	3	233	0
BP Cuff BB2284	BP Cuff BB2284	140	17	119	0
USB-C Power Brick	USB-C Power Brick	138	17	121	0
BP Cuff VHC 210-2110B	BP Cuff VHC 210-2110B	44	1	37	0
Used BloodPressureCuff TMB-2084-A	Used BloodPressureCuff TMB-2084-A	19	0	0	0
USED-ROUTER-SPITZ	USED GL-X750V2 SPITZ ROUTER	18	0	0	0
USEDPhysicalDevice Resistance Bands	USEDPhysicalDevice Resistance Bands	7	0	0	0
USEDBodyweight Scale GBS-2012-B	USEDBodyweight Scale GBS-2012-B	4	0	0	0
USED-ROUTER-OPAL	USED GL-SFT1200 OPAL ROUTER	3	0	0	0
USEDPhysicalDevice Loop Resistance Bands	USEDPhysicalDevice Loop Resistance Bands	2	0	0	0
USED-Tablet-A8	USED SAMSUNG GALAXY TAB A8	1	0	0	0
USED-Tablet-A7	USED SAMSUNG GALAXY TAB A7	1	0	0	0
Ans-1010-BPCuff	BloodPressureCuff TMB-2084-A	1	0	0	0
Ans-1009-POx	PulseOx PC-60FW	1	0	0	0
A9+ Galaxy Tablet	A9+ Galaxy Tablet	0	0	0	1
Tablet Stand UGREEN ABS	Tablet Stand UGREEN ABS	0	0	0	0
USEDPhysicalDevice Tablet Stand	USEDPhysicalDevice Tablet Stand	0	0	0	0
USED-BPC-VHC 210-2110B	USED BP Cuff VHC 210-2110B	0	0	0	0
USED 1010-BPCUFF	USED 1010-BPCUFF	0	0	0	0
USEDPulseOx PC-60FW	USED PULSE OX	0	0	0	0
WScale Nutrifit IF-B7	Bodyweight Scale Nutrifit IF-B7	0	0	0	0

MEASURED orbit-mcp search_products per configured SKU (live Packiyo; backordered/inbound from products.json 2026-07-16T06:24:55; unmatched SKUs: none) · as of 2026-10-26T05:30:02

warehouse category totals

category	on-hand	available	products
tablets	677	254	3
tabletAccessories	5,254	5,182	9
rpmDevices	2,554	2,498	9
exerciseEquipment	6,059	6,007	8
usedUnrecycled	1,111	698	21
other	4,931	4,847	40

MEASURED orbit-mcp get_inventory_summary (live Packiyo) · as of 2026-10-26T05:30:02

snapshot history latest = 2026-10-18 (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 1606 new + 297 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 seats — [OVERCOUNT-SUSPECT]
DIVERGES from Daily Tracker by 175 seats (0 portal-based vs 175 tracker @ 2026-07-15) — figures kept separate, never averaged

■ zone DATA-QUALITY

7,916

devices tracked

3,328

seats purchased (target key, stale)

1,668

seats used (API)

MEASURED knox-license-api /overview seat_optimization (portal_seats figure stale 2026-03-26T13:40:45.122Z) · as of 2026-10-26T05:30:02

Free-seat recompute: (a) strict per-key Σmax(0, purchased−assigned) = 1,660 — but purchased exists for 1/15 keys; 237 devices sit on active keys with NO purchased figure (239 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 1668 (as_of 2026-10-26T12:02:21; 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

key	expiry	purchased	assigned	free (strict)	portal used	status
KLM12-G15J2 ★	2027-03-11	3,328	1,668	1,660	1,359 (scrape 2026-03-26 — stale)	active
KLM12-UA68Z	2026-12-11	unknown	83	unknown	unknown	expiring
KLM12-DDZUO	2026-12-22	unknown	82	unknown	unknown	expiring
KLM12-GGLMN	2027-02-07	unknown	71	unknown	unknown	active
KLM12-3727U	2027-01-22	unknown	62	unknown	unknown	expiring
KLM12-UM26R	2027-03-26	unknown	37	unknown	unknown	active
KLM12-MKJU6	2027-02-24	unknown	33	unknown	unknown	active
KLM12-GNINS	2027-03-09	unknown	31	unknown	unknown	active
KLM12-5ZV1V	2027-04-28	unknown	31	unknown	unknown	active
KLM12-MV6WX	2027-03-24	unknown	17	unknown	unknown	active
KLM12-6XF8F	2027-05-07	unknown	17	unknown	unknown	active
KLM11-A3CWB	2025-03-26	unknown	7	unknown	unknown	expired
KLM12-FZHYR	2026-07-08	unknown	3	unknown	unknown	expired
KLM11-FDB7R	2025-04-15	unknown	1	unknown	unknown	expired
KLM12-7KRBK	2026-03-25	unknown	1	unknown	unknown	expired

MEASURED knox-license-api /overview (per-key expiry; prefixes only) · as of 2026-10-26T05:30:02

expiry timeline — active keys

key	expiry	days to expiry	assigned
KLM12-GGLMN	2027-02-07	104	71
KLM12-MKJU6	2027-02-24	121	33
KLM12-GNINS	2027-03-09	134	31
KLM12-G15J2 ★	2027-03-11	136	1,668
KLM12-MV6WX	2027-03-24	149	17
KLM12-UM26R	2027-03-26	151	37
KLM12-5ZV1V	2027-04-28	184	31
KLM12-6XF8F	2027-05-07	193	17

MEASURED knox-license-api /overview per-key expiry (active keys, assigned via Knox API sync) · as of 2026-10-26T05:30:02

devices on expired keys: 239 (KLM12-UA68Z 83, KLM12-DDZUO 82, KLM12-3727U 62, KLM11-A3CWB 7, KLM12-FZHYR 3, KLM11-FDB7R 1, KLM12-7KRBK 1) — VERIFY vs Jul-8 E-FOTA remediation (~1,710): related but unconfirmed as the same population MEASURED

tiers: SKIP 5,226, Tier 1 1,988, Tier 2 702 · 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

family	sellable	burn/day	days of cover	runout	order-by	enroute (confirmed)	backup vendor
tablet	1,188	14.7	80.6d	2027-01-14	2026-12-08 lead 7d + buf 30d	0	Samsung Direct (~8h emergency) ⚡
tablet_stand	1,369	14.7	92.9d	2027-01-26	2026-09-23 lead 95d + buf 30d	0	NONE
bp_cuff	156	14.8	10.5d	2026-11-05	2026-05-24 lead 135d + buf 30d	0	Veridian (US, 5-7d) ⚡
pulse_ox	1,321	15.1	87.6d	2027-01-21	2026-10-08 lead 75d + buf 30d	0	Shenzhen Creative (20-30d) ⚡
router	3,029	4.4	691.6d	2028-09-16	2028-06-01 lead 77d + buf 30d	0	Amazon (small-qty only)
scale	238	14.7	16.1d	2026-11-11	2026-05-30 lead 135d + buf 30d	2,000	NONE
loop_bands	2,483	14.7	168.5d	2027-04-12	2027-01-12 lead 60d + buf 30d	0	NONE
therabands	2,495	14.7	169.3d	2027-04-13	2027-01-13 lead 60d + buf 30d	0	NONE
charger	121	15.0	8.1d	2026-11-03	2026-09-27 lead 7d + buf 30d	0	any retail channel (days) ⚡
booklet_1	769	14.7	52.2d	2026-12-17	2026-11-17 lead UNKNOWN_PRINT + buf 30d	0	NONE
booklet_2	762	14.7	51.7d	2026-12-16	2026-11-16 lead UNKNOWN_PRINT + buf 30d	0	NONE
booklet_3	782	14.7	53.1d	2026-12-18	2026-11-18 lead UNKNOWN_PRINT + buf 30d	0	NONE

MEASURED computed: live sellable (Panel 1) ÷ burn baseline (DOCUMENTED CSVs); order_by = runout − lead − safety_buffer (June model's method); lead times CONFIG validated (Inventory_Order_Schedule_FINAL 2026-06-17 + Shipping SSOT vendor matrix) · as of 2026-10-26T05:30:02

DOCUMENTED phase6_denominator/shipped_by_device_month.csv (replica package_ledger, prior session); charger from the validated 90d pick-history query (inventory-model.md §b) — NOT inherited from the kit rate · as of 2026-06-01T14:50:16

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)

vendor	item	qty	ref	payment	eta	verified	source
GL.iNet	Spitz X750V2 router	500	PI-202606241236	payment in flight (~2026-07-15)	unknown	2026-07-17	DOCUMENTED-from-email
Granite	SIM cards (ship to GL.iNet for pre-install)	500	—	unknown	needed-by 2026-07-23; ship unconfirmed	2026-07-17	DOCUMENTED-from-email
Transtek	Bodyweight scales	2,000	—	unknown	enroute — Chicago customs, clearance date unconfirmed	2026-07-17	DOCUMENTED-from-email
TBD	Loop bands	unknown	—	VERIFY_IF_PLACED	unknown	2026-07-17	DOCUMENTED-from-email (placement unconfirmed)
TBD	Therabands	unknown	—	VERIFY_IF_PLACED	unknown	2026-07-17	DOCUMENTED-from-email (placement unconfirmed)
TBD	Tablet stands	unknown	—	VERIFY_IF_PLACED	unknown	2026-07-17	DOCUMENTED-from-email (placement unconfirmed)

DOCUMENTED dashboard/open_orders.yaml (DOCUMENTED-from-email, manual) · as of 2026-10-26T05:30:02

Portal equipment requests (demand side, monthly)

month	requests	Tablet	BP	PulseOx	Scale	Router	tracked
2026-08	5,868	517	523	530	491	182	5,770
2026-09	5,715	491	509	510	481	146	5,444
2026-10	3,907	340	355	358	329	111	3,453

MEASURED logistics-mcp get_device_request_counts (replica dsr) (devicetype names corrected to replica map — logistics-mcp enrichment is stale, matrix §2f) · as of 2026-10-26T05:30:02

5 · Outbound & carrier

packages / month

reship rate

MEASURED shipping-dashboard /api/shipping-ops/metrics (replica-backed, 60s cache) · as of 2026-10-26T12:33:47

carrier substatus — last full month 2026-09

substatus	shipments
delivered	600
information_received	11
return_to_sender	4
package_arrived	1

MEASURED logistics-mcp get_tracking_status_counts (replica trackings) · as of 2026-10-26T05:30:02

exceptions (6-mo window)

signal	packages → outcome
total	3,824
any	203
not_home	106 pkgs → 93 delivered · 10 returned · 0 lost · 3 in transit
address	72 pkgs → 61 delivered · 11 returned · 0 lost · 0 in transit
rts	60

MEASURED shipping-dashboard /api/shipping-v2/metrics (replica-backed, 10min cache) · as of 2026-10-26T12:33:49

recall seeds

aged-outbound recall candidates: 989 DOCUMENTED
aged-flag data-bug cases: 99 DOCUMENTED

6 · Returns & ROE

1,143

return packages (ledger)

78.1%

with receipt evidence (ledger)

442

units recovered (items)

MEASURED shipping-dashboard /api/shipping-v2/metrics (replica-backed, 10min cache) · as of 2026-10-26T12:33:49

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)

failure mode	all	tablet	BP	pulse-ox	router
physical_damage	7	2	2	2	1
battery_corrosion_leak	14	0	0	14	0
battery_drain_intermittent	6	3	1	2	0
kiosk_provisioning_software	40	40	0	0	0
wont_power_or_charge	59	33	6	19	1
bp_error_no_inflation	29	0	28	1	0
wont_pair_or_sync	38	3	25	9	1
connectivity_offline	14	6	0	0	8
sensor_no_readings	7	0	1	6	0
remote_access_support	3	3	0	0	0
freeze_unresponsive	1	1	0	0	0
other_unspecified_defect	15	5	2	7	1
TOTAL	233	96	65	60	12

DOCUMENTED analysis-outputs/2026-06-28_tablet_defect_failure_modes.csv (round-3 DD audit aggregate) · as of 2026-06-28T20:29:08

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

7 · SIM — router — patient traceability

3,120

routers in GoodCloud

540

online

1,084

offline

1,496

deactivated — recall pool

MEASURED goodcloud-mcp REST /api/call get-router-stats (6-hourly scrape) · as of 2026-10-26T05:30:02

MEASURED goodcloud get-router-stats deactivated count (recall pool) · as of 2026-10-26T05:30:02

Granite SIMs

total 2,481 · activated 2,380 · suspended 101 · linked to routers 1,765 · linked to patients 1,393 · unlinked routers 716

MEASURED inventorychecker /api/granite-sims/summary (aggregates only) · as of 2026-10-26T05:30:02

last granite sync: 2026-10-26T05:27:09.873Z · cohort seeds: enrolled-45d 2,213 rows DOCUMENTED, disenrolled-45d 12,372 rows DOCUMENTED

8 · Intake as demand signal

20,026

patients in OSH funnel

1,363

recent referrals

3,099

active

1,034

consented (pre-equipment)

MEASURED osh-mcp osh_dashboard_stats · as of 2026-10-26T05:30:02

status	patients
Active	3,099
AnsibleDeclined	5
Completed	787
Consented	1,034
Deceased	300
Disenrolled	1,104
Eligible	912
Engaged	1
ExclusionByOSH	3,772
Identified	1
Onboarding	8
OutReachInProgress	4,456
PatientDeclined	2,241
ReferralWithDrawn	73
RemovedFromOSHRosterFile	14
UnableToReach	1,752
UnderReview	331
Unknown	136

milestones (all-time)

milestone	patients
consent_signed	6,695
techcall_completed	4,661
intake_completed	5,499
first_session_completed	3,454
sixth_session_completed	2,243
twelfth_session_completed	1,805
twentyfourth_session_completed	1,211
thirtysixth_session_completed	862
total_patients	15,474
excluded_patients	16,995
referred_patients	32,469

MEASURED osh-mcp osh_get_milestone_stats · as of 2026-10-26T05:30:02