Bulk purchase break-even after storage · Calculation guide

Find how much of a bulk purchase must be used to recover its full cost.

Calculation guide

Compare the full bulk purchase plus storage with buying only the units used at regular price. A threshold above the pack size cannot be reached.

threshold = ceil((bulk+storage)/regular); all_used = units*regular-bulk-storage

Inputs

Bulk pack price

Example entry 70 (in the selected currency).

Storage cost over holding period

Example entry 10 (in the selected currency).

Units in bulk pack

Example entry 100. Allowed range 1 to 1000000. Use whole numbers.

Regular unit price

Example entry 1 (in the selected currency). Minimum 1e-06.

Worked example

InputValue
Bulk pack price70
Storage cost over holding period10
Units in bulk pack100
Regular unit price1
ResultValue
Units needed to break even80
Saving if all units used20

Calculation steps

Units needed to break even = round up(((Bulk pack price + Storage cost over holding period) ÷ Regular unit price))

round up(((70 + 10) ÷ 1)) = 80

Saving if all units used = (((Units in bulk pack × Regular unit price) − Bulk pack price) − Storage cost over holding period)

(((100 × 1) − 70) − 10) = 20

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Bulk pack price7077Units needed to break even8087
Storage cost over holding period1011Units needed to break even8081
Units in bulk pack100110Saving if all units used2030
Regular unit price12Units needed to break even8040
Bulk purchase break-even after storage →