Calculation guide
Use the same quantity unit for both packs. Waste is the share discarded, not consumed.
cost_a = a/(qa*(1-wa/100)); cost_b = b/(qb*(1-wb/100))
Inputs
Pack A price
Example entry 4 (in the selected currency).
Pack A quantity
Example entry 1. Minimum 1e-06.
Pack A waste
Example entry 0 %. Allowed range 0 to 100.
Pack B price
Example entry 6 (in the selected currency).
Pack B quantity
Example entry 2. Minimum 1e-06.
Pack B waste
Example entry 25 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Pack A price | 4 |
| Pack A quantity | 1 |
| Pack A waste | 0% |
| Pack B price | 6 |
| Pack B quantity | 2 |
| Pack B waste | 25% |
| Result | Value |
|---|---|
| A: cost per usable unit | 4 |
| B: cost per usable unit | 4 |
Calculation steps
A: cost per usable unit = (Pack A price ÷ (Pack A quantity × (1 − (Pack A waste ÷ 100))))
(4 ÷ (1 × (1 − (0 ÷ 100)))) = 4
B: cost per usable unit = (Pack B price ÷ (Pack B quantity × (1 − (Pack B waste ÷ 100))))
(6 ÷ (2 × (1 − (25 ÷ 100)))) = 4
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 |
|---|---|---|---|---|---|
| Pack A price | 4 | 5 | A: cost per usable unit | 4 | 5 |
| Pack A quantity | 1 | 2 | A: cost per usable unit | 4 | 2 |
| Pack A waste | 0% | 1% | A: cost per usable unit | 4 | 4.040404 |
| Pack B price | 6 | 7 | B: cost per usable unit | 4 | 4.666667 |
| Pack B quantity | 2 | 3 | B: cost per usable unit | 4 | 2.666667 |
| Pack B waste | 25% | 28% | B: cost per usable unit | 4 | 4.166667 |
