---
title: "The blended average that drops an option"
description: "A blended order value whose formula stops one row short leaves an option's dollars out of every total, while the shares still add up to 100%."
url: https://offersuite.io/articles/blended-average-drops-an-option
updated: 2026-10-13
---

# The blended average that drops an option

A blended order value whose formula stops one row short leaves an option's dollars out of every total, while the shares still add up to 100%.

Spreadsheet mistake 1 of 9

## The mistake

An offer with several options has no single order value. The sheet makes one by weighting each option's order value by the share of orders that take it. That blended figure then feeds everything downstream: the break-even ad cost, the revenue forecast, the comparison with last month's offer.

The weighting formula covers a range of rows. When someone adds an option below the range, or inserts one at its edge, the formula keeps its old range. The new option's orders are still in the shares, which still add up to 100%, so nothing looks wrong. Its dollars are in no total.

## A worked example

A bottle of supplements at $37.95, sold with quantity breaks: 5% off each for two, 10% for three, 15% for four, and $9.29 of shipping charged on every order. Out of 1,000 orders, 450, 300, 150, 100 take one, two, three and four bottles. The four-bottle option was added last.

Weighting all four options gives a blended order value of $76.28. The sheet's formula stops at the third row and shows $62.45, which is $13.83 too low: the fourth option's $138.33 order times its 10.0% share.

The offer's four options, and the two blended order values

| Option | Customer pays, with shipping | Share of orders | In the sheet's total |
| --- | --- | --- | --- |
| 1 unit | $47.24 | 45.0% | Yes |
| 2 units, 5% off each | $81.41 | 30.0% | Yes |
| 3 units, 10% off each | $111.77 | 15.0% | Yes |
| 4 units, 15% off each | $138.33 | 10.0% | No |
| Blended order value, as the sheet shows it | $62.45 |  |  |
| Blended order value, all four options | $76.28 |  |  |

The order's figures are computed by the margin engine in Offer Suite's own code, in whole cents. The sheet's are the same order with the mistake applied.

## What it does to the decision

The sheet reports 18.1% less revenue per order than the offer earns, and every figure built on the blended order value inherits that. The offer keeps $36.84 an order after its costs. A team that works out what it can pay for an order from the sheet's figure sets the cap too low and turns off ads that were paying.

The option that goes missing is the one added last, and here that is the largest pack, so the sheet drops the order that would have raised the average the most. The error has no fixed direction, though. If the range loses the cheapest option instead, the blended figure comes out too high and the offer looks better than it is.

## What prevents it

Offer Suite has no range to maintain. An offer's options live in one [offer document](https://offersuite.io/features/offer-documents), and every figure that blends them reads all of them from it. The margin engine's projection, which blends options by take share, refuses a mix whose shares don't add up to 1 instead of computing a number from part of the offer.

After launch the blend isn't typed at all. [Realized profit](https://offersuite.io/features/profit) counts each option's orders from the store, so the shares are observed and every order belongs to exactly one option.

A spreadsheet is still the right tool for some of this. Where it is, and where it stops: [Offer Suite vs a spreadsheet](https://offersuite.io/compare/spreadsheets).

## Where the numbers come from

The example is not a real brand's offer. The split of orders across the four options is made up. Every other input is sourced below, or marked there as an assumption.

|  |  |
| --- | --- |
| Price | $37.95, a bottle of supplements. [Nature's Sunshine homepage, read 23 September 2026](https://www.naturessunshine.com/) |
| Unit cost | $10.47. [Nature's Sunshine, fourth quarter and full year 2025 results, read 23 September 2026](https://ir.naturessunshine.com/news-events/press-releases/detail/267/natures-sunshine-reports-strong-fourth-quarter-and-full) |
| Refund reserve | 5%, Offer Suite's default assumption for consumables. NRF's all-category figure for online sales is 19.3%, but consumables are rarely returned; use your own rate. |
| Pick and pack | $3.20 per order and $0.48 for each extra item. [Fulfill.com, 3PL pricing benchmarks (The Fulfillment Advisor 2025 survey of 600+ warehouses), read 23 September 2026](https://www.fulfill.com/3pl-pricing) |
| Shipping label | USPS Ground Advantage, commercial, Zone 5, by weight rounded up to the pound: 1 lb $9.29 · 2 lb $10.50 · 3 lb $12.12 · 4 lb $13.89 · 5 lb $14.53. Packed weight is an assumption: 0.5 lb per unit. [USPS Notice 123, USPS Ground Advantage Commercial, Zone 5 (effective 4 October 2026), read 13 October 2026](https://pe.usps.com/text/dmm300/Notice123.htm) |
| Card fees | 2.9% + $0.30 per order: Shopify Payments' online rate for a standard card on the Basic plan in the United States. Higher plans pay a lower rate, and premium cards a higher one. [Shopify's pricing page for the United States, online standard card rates, read 12 October 2026](https://www.shopify.com/pricing) [Rates by plan and country](https://offersuite.io/fees/shopify-payments/united-states) |

## Related

- [Articles **Spreadsheet mistakes that misprice offers** Nine mistakes that turn up in offer spreadsheets, each worked on a sourced order: what the sheet shows, what the order earns, and what prevents the error.](https://offersuite.io/articles)
- [Calculator **Offer option calculator: profit per visitor** Compare up to three offer options on profit per visitor, margin per order times conversion, and see the conversion lift each one needs to match the best.](https://offersuite.io/calculators/offer-option-profit-per-visitor)
- [Calculator **Bundle pricing calculator: shipping, subscriptions** Price a bundle against a single unit, one-time and subscribed, with the shipping and pick costs it saves, and the conversion it can lose and still earn as much.](https://offersuite.io/calculators/bundle-pricing)
- [Comparison **Offer profit in a spreadsheet vs Offer Suite** Where a spreadsheet is the right tool for offer profit, and where it breaks: costs that change, renewals, refunds, and a price that has to match checkout.](https://offersuite.io/compare/spreadsheets)
- [Article **Averaging margin percentages instead of dollars** A blended margin that averages each option's percentage by its share of orders is wrong. Margin has to be weighted by revenue: sum the dollars, divide once.](https://offersuite.io/articles/averaging-margin-percentages)
- [Feature **Offer documents: one validated document per offer** An offer is one validated, versioned document your agent writes: tiers, bundles, subscriptions, gifts and prices, with no offer types to pick from.](https://offersuite.io/features/offer-documents)