Ecommerce bundle stock capacity calculator

Calculate each bundle capacity in isolation and requested bundle units in total with your own figures.

Your numbers

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

Use each bundle capacity in isolation and requested bundle units in total to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Components: SKU, stock units, reserved standalone units
A,10,2 B,6,0 C,5,1
Recipes: bundle name, SKU:units joined by |
X,A:2|B:1 Y,A:1|C:2
Requested bundle quantities: name, units
X,3 Y,2
Each bundle capacity in isolation
X: 4; Y: 2
Requested bundle units in total
5
Component units remaining after all requests
A: 0; B: 3; C: 0
Component shortages
None
Joint request status
Feasible under entered stock

Try another scenario

Components: SKU, stock units, reserved standalone units
A,10,2 B,6,0 C,5,1
Recipes: bundle name, SKU:units joined by |
X,A:2|B:1 Y,A:1|C:2
Requested bundle quantities: name, units
X,4 Y,2
Each bundle capacity in isolation
X: 4; Y: 2
Requested bundle units in total
6
Component units remaining after all requests
A: -2; B: 2; C: 0
Component shortages
A: 2
Joint request status
Infeasible joint request
Calculation method

Calculation method

Each bundle capacity in isolation

For each recipe independently take min(floor(unreserved component stock/required component units)). These individual capacities cannot generally be added.

Requested bundle units in total

Sum requested bundle counts.

Component units remaining after all requests

Unreserved component stock−joint recipe consumption; preserve negative shortages.

Component shortages

List magnitudes of negative component remainders.

Joint request status

Feasible exactly when all component remainders are non-negative.

Symbols and units
a
Components: SKU, stock units, reserved standalone units
b
Recipes: bundle name, SKU:units joined by |
c
Requested bundle quantities: name, units

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 component-stock check against entered reservations and recipes. It does not reserve products, infer substitution, split physical items or promise future availability.
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.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.