Examples
Examples
Try the starting example
- Receipt cohorts: name, receipt date, received units, shipped units, returned units, returned units restocked
- A,2026-10-01,100,60,5,3 B,2026-10-10,50,20,0,0
- As-of date
- 2026-10-20
- Net kept-unit sell-through by cohort (%)
- A: 55; B: 40
- Remaining physical stock by cohort
- A: 43; B: 30
- Net kept units / all received units (%)
- 50
- Returned units not restocked
- 2
- Receipt-cohort age in calendar days
- A: 19; B: 10
Try another scenario
- Receipt cohorts: name, receipt date, received units, shipped units, returned units, returned units restocked
- A,2026-10-01,100,60,5,5 B,2026-10-10,50,20,0,0
- As-of date
- 2026-10-20
- Net kept-unit sell-through by cohort (%)
- A: 55; B: 40
- Remaining physical stock by cohort
- A: 45; B: 30
- Net kept units / all received units (%)
- 50
- Returned units not restocked
- 0
- Receipt-cohort age in calendar days
- A: 19; B: 10
Calculation method
Calculation method
Net kept-unit sell-through by cohort (%)
(Shipped−returned)/received×100; undefined for zero receipts.
Remaining physical stock by cohort
Received−shipped+restocked. The data must reconcile to non-negative physical stock.
Net kept units / all received units (%)
Sum kept units/sum received×100, avoiding an unweighted average of cohort rates.
Returned units not restocked
Sum returned−restocked; this reconciles received=kept+remaining stock+nonrestocked returns.
Receipt-cohort age in calendar days
As-of date−receipt date; future receipt records are rejected.
Symbols and units
- a
- Receipt cohorts: name, receipt date, received units, shipped units, returned units, returned units restocked
- b
- As-of date
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A supplied delivery-cohort unit reconciliation. Sales and returns must already be assigned to the correct cohort; no retailer records are linked automatically.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.