Cafe milk alternative inventory calculator

Calculate required milk by type and shortfall by type with your own figures.

Your numbers

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

Use required milk by type and shortfall by type to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Drink counts by milk type
10,20
Average milk per drink by type (mL)
200,150
Current stock by milk type (L)
1,5
Pack sizes by milk type (L)
1,2
Required milk by type (L)
2, 3
Shortfall by type (L)
1, 0
Packs to buy by type
1, 0
Total packs to buy
1

Try another scenario

Drink counts by milk type
4
Average milk per drink by type (mL)
250
Current stock by milk type (L)
0
Pack sizes by milk type (L)
0.75
Required milk by type (L)
1
Shortfall by type (L)
1
Packs to buy by type
2
Total packs to buy
2
Calculation method

Calculation method

Required milk by type (L)

For each matched milk type: drinks × average mL per drink / 1000.

Shortfall by type (L)

Maximum of zero and required litres minus current stock.

Packs to buy by type

Round up shortfall / pack size for each type.

Total packs to buy

Add pack counts across types.

Symbols and units
a
Drink counts by milk type
b
Average milk per drink by type (mL)
c
Current stock by milk type (L)
d
Pack sizes by milk type (L)

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

  • Enter matching rows for your chosen milk types and measured average recipes. Milk types are never substituted. Waste, expiry, refrigeration, substitutions and demand uncertainty require separate planning.
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

OpenStax: ratios, percentages and rectangular geometry ↗

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.