Procurement supplier allocation resilience calculator

Calculate maximum fulfilled units by scenario and total shortfall by scenario with your own figures.

Your numbers

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

Use maximum fulfilled units by scenario and total shortfall by scenario to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Required product units: SKU, units
X,60 Y,60
Suppliers: name, shared total unit capacity, approved SKUs joined by |
A,60,X|Y B,60,X
Capacity-loss scenarios: name, failed supplier names joined by | or none
Normal,none LoseB,B
Maximum fulfilled units by scenario
Normal: 120; LoseB: 60
Total shortfall by scenario
Normal: 0; LoseB: 60
Largest supplied-scenario shortfall
60
Total required units
120
Worst supplied-scenario fulfilment share (%)
50
One maximum-flow shortfall mix by scenario
Normal: None; LoseB: Y: 60

Try another scenario

Required product units: SKU, units
X,60 Y,60
Suppliers: name, shared total unit capacity, approved SKUs joined by |
A,60,X|Y B,30,X
Capacity-loss scenarios: name, failed supplier names joined by | or none
Normal,none LoseB,B
Maximum fulfilled units by scenario
Normal: 90; LoseB: 60
Total shortfall by scenario
Normal: 30; LoseB: 60
Largest supplied-scenario shortfall
60
Total required units
120
Worst supplied-scenario fulfilment share (%)
50
One maximum-flow shortfall mix by scenario
Normal: Y: 30; LoseB: Y: 60
Calculation method

Calculation method

Maximum fulfilled units by scenario

Remove explicitly failed suppliers, then solve maximum flow from surviving shared capacities through approved SKU links to demand. Each supplier unit can serve only one SKU.

Total shortfall by scenario

Total demand−maximum feasible fulfilled units.

Largest supplied-scenario shortfall

Maximum of supplied scenario shortfalls; no probability is inferred.

Total required units

Sum required product units.

Worst supplied-scenario fulfilment share (%)

100×(demand−largest gap)/demand, undefined for zero demand.

One maximum-flow shortfall mix by scenario

Report the remaining SKU demands from one deterministic max-flow solution; other equally optimal mixes can exist.

Symbols and units
a
Required product units: SKU, units
b
Suppliers: name, shared total unit capacity, approved SKUs joined by |
c
Capacity-loss scenarios: name, failed supplier names joined by | or none

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

  • An exact shared-unit capacity scenario under supplied SKU qualifications. Assumes one unit of any approved SKU consumes one capacity unit; it does not assess supplier quality, outage likelihood or real substitution approval.
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.