Examples
Examples
Try the starting example
- Consignment stock: SKU, opening units, transfer price $/unit
- A,10,2 B,20,3
- Events in order: ID, SKU, receipt/consume/return/writeoff, whole units
- E1,A,receipt,5 E2,A,consume,6 E3,A,writeoff,2 E4,B,return,5 E5,B,consume,4
- Supplied ownership-transfer trigger: consume-only or consume-and-writeoff
- consume-only
- Already settled supplier charges for these events ($)
- 10
- Units still physically held by SKU
- A: 7; B: 11
- Model supplier charge for transfer-trigger events ($)
- $24.00
- Settled charges entered ($)
- $10.00
- Supplier charge less settlements, signed ($)
- $14.00
- Remaining physical stock at supplied transfer values ($)
- $47.00
Try another scenario
- Consignment stock: SKU, opening units, transfer price $/unit
- A,10,2 B,20,3
- Events in order: ID, SKU, receipt/consume/return/writeoff, whole units
- E1,A,receipt,5 E2,A,consume,6 E3,A,writeoff,2 E4,B,return,5 E5,B,consume,4
- Supplied ownership-transfer trigger: consume-only or consume-and-writeoff
- consume-and-writeoff
- Already settled supplier charges for these events ($)
- 10
- Units still physically held by SKU
- A: 7; B: 11
- Model supplier charge for transfer-trigger events ($)
- $28.00
- Settled charges entered ($)
- $10.00
- Supplier charge less settlements, signed ($)
- $18.00
- Remaining physical stock at supplied transfer values ($)
- $47.00
Calculation method
Calculation method
Units still physically held by SKU
Apply receipts and decreases in order, rejecting a negative physical stock state.
Model supplier charge for transfer-trigger events ($)
Charge supplied unit transfer prices on consume events, and on writeoffs only in consume-and-writeoff mode.
Settled charges entered ($)
Entered settlement value.
Supplier charge less settlements, signed ($)
Model charge−settled; preserve a credit balance rather than clipping.
Remaining physical stock at supplied transfer values ($)
Remaining units×fixed supplied transfer price; no change in legal ownership is inferred.
Symbols and units
- a
- Consignment stock: SKU, opening units, transfer price $/unit
- b
- Events in order: ID, SKU, receipt/consume/return/writeoff, whole units
- c
- Supplied ownership-transfer trigger: consume-only or consume-and-writeoff
- d
- Already settled supplier charges for these events ($)
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 chronological stock/settlement model with an externally supplied ownership-transfer trigger. It does not interpret consignment law, revalue inventory or post supplier charges.
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
Background reading; this does not imply endorsement or independent review of SumFizz.