Procurement open-order cancellation calculator

Calculate original open merchandise commitment and entered cancellation fees with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use original open merchandise commitment and entered cancellation fees to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Cancellation scenarios: line, open units, units supplier agrees to cancel, contract unit price $, cancellation fee on cancelled value %, explicit cash recovery $
A,70,50,10,20,80
Original open merchandise commitment ($)
$700.00
Entered cancellation fees ($)
$100.00
Remaining purchase plus fees less recovery ($)
$220.00
Net cash reduction under entered scenario ($)
$480.00
Scenario net remaining cash by line ($)
A: 220.00

Try another scenario

Cancellation scenarios: line, open units, units supplier agrees to cancel, contract unit price $, cancellation fee on cancelled value %, explicit cash recovery $
A,70,0,10,20,0
Original open merchandise commitment ($)
$700.00
Entered cancellation fees ($)
$0.00
Remaining purchase plus fees less recovery ($)
$700.00
Net cash reduction under entered scenario ($)
$0.00
Scenario net remaining cash by line ($)
A: 700.00
Calculation method

Calculation method

Original open merchandise commitment ($)

Sum original open units×unit price.

Entered cancellation fees ($)

Round cancelled units×unit price×supplied fee percentage, separately per line.

Remaining purchase plus fees less recovery ($)

Uncancelled units×price+entered cancellation fee−explicit recovery.

Net cash reduction under entered scenario ($)

Original open commitment−scenario net remaining cash.

Scenario net remaining cash by line ($)

Show each signed line result without deciding whether cancellation or recovery is legally available.

Symbols and units
a
Cancellation scenarios: line, open units, units supplier agrees to cancel, contract unit price $, cancellation fee on cancelled value %, explicit cash recovery $

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 agreed-cancellation cash scenario. It does not establish cancellation rights, supplier acceptance, recoverability or actually cancel an order.
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

OECD: procurement performance and contract-record background; calculations follow the displayed rules ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.