Unit Price After Discounts: A Simple Worksheet for Comparing Multi-Packs and Bundles
unit pricingshopping worksheetbundle dealsprice comparisonbudget tools

Unit Price After Discounts: A Simple Worksheet for Comparing Multi-Packs and Bundles

OOne-Euro Store Editorial Team
2026-11-09
7 min read

Calculate the real cost per item, gram, or millilitre after discounts, shipping, rewards, and bundle conditions.

Compare multipacks and bundles with confidence by calculating the final cost per item, gram, millilitre, sheet, or usable set after discounts, shipping, rewards, and other checkout costs. This worksheet gives you a repeatable way to identify the best value instead of relying on a large percentage-off label.

Overview

A bundle is not automatically the cheapest option. A larger pack may have a higher price per item, while a smaller pack can become more expensive after shipping. Coupons, free-shipping thresholds, loyalty rewards, subscribe-and-save reductions, and cashback can also change the final comparison.

The basic calculation is:

Final cost = product price − immediate discounts + mandatory charges − immediate rewards

Then calculate:

Unit price = final cost ÷ comparable quantity

Use the quantity that best reflects the product. For paper towels, that may be rolls, sheets, or square metres. For beauty products, millilitres may be more useful than containers. For snacks, compare bars, packs, grams, or servings only when the contents are genuinely comparable.

Keep your comparisons consistent. If one option includes shipping and another does not, add shipping to both where applicable. If taxes vary by location or are calculated at checkout, either include them for every option or leave them out of every option and label the result as an estimate. For more guidance on evaluating a sale beyond its headline percentage, see how to tell if an online discount is really a good deal.

How to estimate

Use this six-step worksheet whenever you compare multipacks, flash deals, or unusually large bundles.

  1. Record the listed price. Write down the price for the exact quantity you would receive, not the advertised “from” price or a price for a different variation.
  2. Apply immediate discounts. Subtract a fixed coupon or calculate the reduction from a percentage promo code. If more than one discount applies, follow the retailer’s stated order. A 20% code followed by a fixed discount does not always produce the same result as applying the fixed discount first.
  3. Add unavoidable costs. Include shipping, handling, required membership charges, or a small-order fee. A free shipping code should reduce shipping to zero only when the checkout conditions are met.
  4. Subtract rewards that can be used now. Treat cashback, points, or a future voucher separately if they are delayed, conditional, or restricted. For a conservative comparison, calculate the immediate out-of-pocket cost first, then show a second result including an eligible reward.
  5. Choose the correct denominator. Divide by items, grams, millilitres, sheets, servings, or complete sets. Do not divide a mixed bundle by every object inside it if some objects are accessories or replacements rather than equivalent products.
  6. Compare the results at the same precision. Round only at the end. Showing two decimal places is usually enough for currency, but keep extra digits while calculating so close results are not distorted.

A simple worksheet can have these columns: option, quantity, listed price, discounts, shipping and fees, immediate reward, final cost, comparison unit, and cost per unit. If you regularly monitor sale deals or price drop deals, save the worksheet and update only the inputs when a new offer appears.

Inputs and assumptions

Before comparing, decide what “best value” means for the purchase. The lowest cost per item is useful only if you will use the full quantity before it expires, dries out, becomes outdated, or takes up more storage than you have available.

Product typeUseful comparison unitCheck before comparing
Household suppliesRoll, sheet, load, wipe, or litreSheet size, thickness, concentration, and number of usable loads
Beauty productsMillilitre, gram, or applicationNet contents, shade or formula, and whether the items are full size
SnacksBar, pouch, serving, gram, or kilogramNet weight, serving size, and whether flavours or formats differ
StationeryNotebook, pen, sheet, or usable setPage count, paper size, ruling, ink type, and included refills
Party suppliesPlate, cup, decoration, or complete place settingDimensions, material, quantity, and whether the bundle contains matching pieces

Do not automatically count loyalty points as cash. Include them in the main calculation only if they are immediately redeemable and you would otherwise use them. Similarly, a subscription discount may require a commitment or automatic future order. Record it as an assumption rather than treating it as a guaranteed saving.

Coupon stacking can make a meaningful difference, but eligibility varies. Check whether a store coupon, promo code, cashback offer, and free shipping code can be combined before entering them in the worksheet. These guides explain the mechanics in more detail: how to stack coupons, promo codes, cashback, and free shipping offers and the coupon stacking guide.

Worked examples

The following figures are illustrations, not current retailer prices. They show how the method works under stated assumptions.

Household supplies: compare the delivered cost

Option A contains 12 equivalent rolls for $9.60 with a 20% discount and free shipping. Its final cost is $9.60 × 0.80 = $7.68, or $0.64 per roll.

Option B contains 24 rolls for $18.00 with a 15% discount and $4 shipping. Its final cost is $18.00 × 0.85 + $4 = $19.30, or about $0.80 per roll. Option A is cheaper per roll in this example, even though Option B is the larger pack.

Beauty products: convert containers to millilitres

A three-pack of 50 ml bottles costs $21.00, receives 10% off, and has $3 shipping. The final cost is $21.00 × 0.90 + $3 = $21.90. The total quantity is 150 ml, so the cost is $0.146 per ml.

A two-pack of 100 ml bottles costs $24.00 with 15% off and free shipping. The final cost is $20.40 for 200 ml, or $0.102 per ml. The second option has the lower unit price, assuming the formulas and sizes are suitable for the same use.

Snacks: account for a fixed coupon

An eight-bar box costs $6.40, accepts a $1 coupon, and adds $2 shipping. The final cost is $6.40 − $1 + $2 = $7.40, or $0.93 per bar after rounding.

A 12-bar box costs $10.80, receives 20% off, and ships free. Its final cost is $8.64, or $0.72 per bar. The larger box is better by bar here, but only if you will use all 12 bars.

Stationery: compare like-for-like pages

A pack of three 80-page notebooks costs $12.00 with 10% off and $3 shipping. The final cost is $13.80 for 240 pages, or $0.0575 per page.

A pack of two 120-page notebooks costs $11.00 with free shipping. It provides the same 240 pages for $11.00, or about $0.0458 per page. This comparison is meaningful only if the paper size, ruling, and paper quality are comparable.

Party supplies: compare complete place settings

A bundle contains 24 plates, 24 cups, and 48 napkins for $18.00 after a discount, with $4 shipping. That is $22.00 delivered. Because the bundle makes 24 complete place settings, the cost is about $0.92 per setting.

A second offer contains 30 plates, 30 cups, and 30 napkins for $20.00 with free shipping. It makes 30 complete settings, so the cost is about $0.67 per setting. Dividing the first bundle by 96 total objects would make it look artificially cheaper; the useful denominator is the number of complete settings you can actually use.

When to recalculate

Recalculate whenever an input changes, not only when the product price changes. A new coupon code, altered shipping threshold, changed pack size, loyalty reward, subscription setting, or cashback rate can change the result. Recheck a saved comparison before placing an order if the offer is labelled a flash deal, daily deal, or limited-time offer.

It is also worth recalculating when your needs change. A larger bundle may be better for a planned event but poor value for routine shopping if some items will remain unused. For school purchases, update quantities as your supply list changes; our back-to-school deals checklist can help organize those inputs. For gifts, compare the cost of a complete usable gift rather than the number of objects in a novelty bundle; see this budget gift finder for a separate starting point.

Before checkout, run this final checklist:

  • Confirm the exact size, count, variation, and stock status.
  • Apply only discounts that the checkout accepts.
  • Add shipping and mandatory fees consistently.
  • Separate immediate savings from future points or cashback.
  • Divide by a meaningful, equivalent unit.
  • Ask whether you will use the full bundle.

Save the worksheet with the date and offer details. When another store advertises a lower price, a new coupon becomes available, or a price drop appears, replace the inputs and compare again. That small habit turns scattered online discounts into a clearer, repeatable buying decision.

Related Topics

#unit pricing#shopping worksheet#bundle deals#price comparison#budget tools
O

One-Euro Store Editorial Team

Savings and Shopping Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.