Grocery pack waste-adjusted cost · Calculation guide

Compare package prices per usable unit after waste.

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

InputValue
Pack A price4
Pack A quantity1
Pack A waste0%
Pack B price6
Pack B quantity2
Pack B waste25%
ResultValue
A: cost per usable unit4
B: cost per usable unit4

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Pack A price45A: cost per usable unit45
Pack A quantity12A: cost per usable unit42
Pack A waste0%1%A: cost per usable unit44.040404
Pack B price67B: cost per usable unit44.666667
Pack B quantity23B: cost per usable unit42.666667
Pack B waste25%28%B: cost per usable unit44.166667
Grocery pack waste-adjusted cost →