Examples
Examples
Try the starting example
- Authorized blanket ceiling ($)
- 1000
- Release commitments: release ID, amount $
- R1,600 R2,400
- Invoices: invoice ID, release ID, amount $
- I1,R1,300 I2,R2,100
- Cash already paid against these releases ($)
- 200
- Released commitments ($)
- $1,000.00
- Ceiling less commitments, signed ($)
- $0.00
- Commitments less recorded invoices, signed ($)
- $600.00
- Recorded invoices less cash paid, signed ($)
- $200.00
- Ceiling less cash paid, signed ($)
- $800.00
Try another scenario
- Authorized blanket ceiling ($)
- 1200
- Release commitments: release ID, amount $
- R1,600 R2,400
- Invoices: invoice ID, release ID, amount $
- I1,R1,300 I2,R2,100
- Cash already paid against these releases ($)
- 200
- Released commitments ($)
- $1,000.00
- Ceiling less commitments, signed ($)
- $200.00
- Commitments less recorded invoices, signed ($)
- $600.00
- Recorded invoices less cash paid, signed ($)
- $200.00
- Ceiling less cash paid, signed ($)
- $1,000.00
Calculation method
Calculation method
Released commitments ($)
Sum unique release amounts.
Ceiling less commitments, signed ($)
Authorized ceiling−release commitments; negative exposes overcommitment.
Commitments less recorded invoices, signed ($)
Release commitments−matched invoice amounts; negative exposes invoicing beyond the supplied commitment total.
Recorded invoices less cash paid, signed ($)
Invoice total−entered cash paid; a negative value can represent an advance rather than an unpaid amount.
Ceiling less cash paid, signed ($)
Ceiling−cash paid, kept separate from uncommitted budget.
Symbols and units
- a
- Authorized blanket ceiling ($)
- b
- Release commitments: release ID, amount $
- c
- Invoices: invoice ID, release ID, amount $
- d
- Cash already paid against these releases ($)
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
- Separates authorization, commitment, invoicing and cash under supplied records. It does not post orders, invoices or payments or determine whether overspending is permitted.
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.