Unit Price Comparison Calculator
Unit Price Comparison is evaluated from Price of Item 1, Quantity of Item 1 and Price of Item 2. The calculation reports Item 1 Price Per Unit, Item 2 Price Per Unit and Savings by Choosing Better Value.
Results
About the Unit Price Comparison Calculator
The calculator uses a multi formula configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Unit Price = Total Price / Quantity
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Unit Price = Total Price / Quantity Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: Laundry detergent: 32-oz for $3.49 vs. 64-oz for $5.99
Inputs
With Price of Item 1 = 3.49, Quantity of Item 1 = 32, Price of Item 2 = 5.99 and Quantity of Item 2 = 64 as the stated inputs, the result is Item 1 Price Per Unit = $0.1091/unit, Item 2 Price Per Unit = $0.0936/unit and Savings by Choosing Better Value = 14.18%. Each value corresponds to the declared output fields.
Example 2: Cereal: 12-oz box for $4.29 vs. 18-oz family size for $5.49
Inputs
With Price of Item 1 = 4.29, Quantity of Item 1 = 12, Price of Item 2 = 5.49 and Quantity of Item 2 = 18 as the stated inputs, the result is Item 1 Price Per Unit = $0.3575/unit, Item 2 Price Per Unit = $0.305/unit and Savings by Choosing Better Value = 14.69%. Each value corresponds to the declared output fields.
Example 3: Olive oil: 16.9 fl oz for $8.99 vs. 33.8 fl oz for $15.99
Inputs
With Price of Item 1 = 8.99, Quantity of Item 1 = 16.9, Price of Item 2 = 15.99 and Quantity of Item 2 = 33.8 as the stated inputs, the result is Item 1 Price Per Unit = $0.532/unit, Item 2 Price Per Unit = $0.4731/unit and Savings by Choosing Better Value = 11.07%. Each value corresponds to the declared output fields.
Example 4: Paper towels: 6-pack for $9.99 vs. 12-pack for $17.99 (Costco price)
Inputs
With Price of Item 1 = 9.99, Quantity of Item 1 = 6, Price of Item 2 = 17.99 and Quantity of Item 2 = 12 as the stated inputs, the result is Item 1 Price Per Unit = $1.665/unit, Item 2 Price Per Unit = $1.4992/unit and Savings by Choosing Better Value = 9.96%. Each value corresponds to the declared output fields.
Common Use Cases
- Compare grocery items by price per ounce
- Find the best deal between different package sizes
- Calculate cost per serving for food items