PO calculator

Recommended quantities for the next aligned-stockout cycle. Formula: PO_qty = backlog + (lead_time + buffer) × forward_rate − on_hand − incoming.

SKU	Live stock	On-hand for PO	Backlog	Forward /d	Lead	Buffer	PO qty	Rounded to MOQ
Vol 1	3174	3174	0	137	14d	14d	665	2000
backlog=0 + (14d lead + 14d buffer = 28d) × 137/d − on_hand=3174 − incoming=0 = 665
Vol 2	558	558	0	95	14d	14d	2108	2500
backlog=0 + (14d lead + 14d buffer = 28d) × 95/d − on_hand=558 − incoming=0 = 2108
STAA	-971	0	971	60	14d	14d	2648	3000
backlog=971 + (14d lead + 14d buffer = 28d) × 60/d − on_hand=0 − incoming=0 = 2648
Enoch	-368	0	368	16	14d	30d	1076	2000
backlog=368 + (14d lead + 30d buffer = 44d) × 16/d − on_hand=0 − incoming=0 = 1076
Three Books	-44	0	44	3	21d	45d	216	2000
backlog=44 + (21d lead + 45d buffer = 66d) × 3/d − on_hand=0 − incoming=0 = 216
Sacred Geometry Codex	-109	0	109	13	21d	30d	762	2000
backlog=109 + (21d lead + 30d buffer = 51d) × 13/d − on_hand=0 − incoming=0 = 762

Message draft for Chingnam

Hi Chingnam,

Please confirm new PO with the following SKUs:

- Vol 1: 2000 units
- Vol 2: 2500 units
- STAA: 3000 units
- Enoch: 2000 units
- Three Books: 2000 units
- Sacred Geometry Codex: 2000 units

Total: 13500 units.

Could you confirm: production start date, expected delivery, and that pricing/quality specs match the latest agreement?

Thanks,
Aaron