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.
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
| Input | Value |
|---|---|
| Bulk pack price | 70 |
| Storage cost over holding period | 10 |
| Units in bulk pack | 100 |
| Regular unit price | 1 |
| Result | Value |
|---|---|
| Units needed to break even | 80 |
| Saving if all units used | 20 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Bulk pack price | 70 | 77 | Units needed to break even | 80 | 87 |
| Storage cost over holding period | 10 | 11 | Units needed to break even | 80 | 81 |
| Units in bulk pack | 100 | 110 | Saving if all units used | 20 | 30 |
| Regular unit price | 1 | 2 | Units needed to break even | 80 | 40 |
