On this page
A basket contains products earning 5%, 8% and 12%. The campaign team wants one final reward amount, so someone averages the three rates and applies that average to the entire basket. That shortcut works only under particular weighting conditions. Different product values can make a simple average wrong.
The reliable commercial calculation assigns each approved rate to its corresponding eligible value, calculates the components and then sums them. This worksheet assumes the eligible lines and rates are already established; it does not decide which products deserve a promotion.
Assign approved rates to eligible line values
Use a fictional home-office basket with a $150 chair at 5%, an $80 lamp at 8% and a $20 cable organizer at 12%. The approved eligible merchandise total is $250. Assume these values already reflect the selected discount treatment and exclude unrelated charges.
The rate belongs to the relevant line value, not to the whole order merely because that product appears in the basket. A small item with a high rate does not automatically raise the reward rate on an expensive item with a lower rate.
Keep a rate assignment table as part of the amount specification. It should identify the approved product or rate group, the amount entering the formula and the applicable percentage. For a live program, those assignments need a source of truth established through the approved campaign design.
The RebateCardX campaign overview can frame a discussion of mixed-rate concepts. It is not evidence that every proposed rate structure is already supported. The merchant should present the actual assignments and expected results rather than asking vaguely for “different rewards on different products.”
Sum product-level reward components
Multiply each line’s base by its own rate, then combine the resulting reward amounts.
| Eligible line | Approved base | Assigned rate | Reward component |
|---|---|---|---|
| Chair | $150 | 5% | $7.50 |
| Lamp | $80 | 8% | $6.40 |
| Cable organizer | $20 | 12% | $2.40 |
| Total | $250 | No universal rate assigned | $16.30 |
The final reward is $7.50 plus $6.40 plus $2.40, or $16.30. Dividing $16.30 by the $250 base gives an effective basket rate of 6.52%. That rate describes this particular mix; it is not the campaign’s rate for every possible basket.
A simple average of 5%, 8% and 12% is approximately 8.33%. Applying that average to $250 would produce about $20.83 after rounding, overstating the correct example reward by $4.53. The error occurs because the average gives the $20 organizer the same weight as the $150 chair.
A weighted average can reproduce the correct result if it uses each line’s share of the eligible total. The chair is 60% of the base, the lamp is 32% and the organizer is 8%. Their weighted contribution is 0.60 × 5% plus 0.32 × 8% plus 0.08 × 12%, equaling 6.52%. Calculating the dollar components directly is usually easier to inspect.
Now change the basket to a $50 chair component, an $80 lamp and $120 of organizers, keeping the same respective rates. The reward becomes $2.50 plus $6.40 plus $14.40, or $23.30, on the same $250 total. The effective rate becomes 9.32%. Equal basket totals do not imply equal rewards when the mix changes.
This second basket is a useful control because it separates total spending from composition. A campaign owner who expects both $250 baskets to earn the same amount is describing a different formula. Resolve that expectation before the mixed-rate offer is approved.
A difficult case involves multiple units on one line. If three eligible organizers total $60 and share the same 12% rate, the line contributes $7.20 before any applicable rounding. The count of units matters through the approved line value; it does not justify averaging the rate again for every unit.
Explain the resulting amount without inventing a universal basket rate
A customer-facing explanation should be able to identify which included values produced the total. It need not present a complex formula in every message, but it should not claim the basket earned “12% back” merely because one line had that rate.
For the first example, an internal explanation could read: “The approved chair value contributes $7.50, the lamp contributes $6.40 and the organizer contributes $2.40. The proposed combined reward is $16.30. Each component uses its assigned rate.” This is both shorter and more accurate than inventing a single headline percentage for the entire basket.
Attach the selected rounding convention. If components can contain fractional cents, decide whether to round each line or only the total, using the rounding specification. The mixed-rate method and rounding method are separate choices, and both affect reproducibility.
Also identify any final cap explicitly. If the campaign caps the total reward, apply that approved operation at the specified point and show an example that reaches it. Do not quietly cap one high-rate component when the offer actually defines a maximum for the combined amount.
An ineligible line is another important boundary. It should not be included in the eligible control total merely to make an effective rate look lower or higher. If the customer paid $300 but only $250 enters this formula, label the denominator correctly. The rate on eligible value and the nominal reward as a share of the full checkout payment are different descriptions.
The practical deliverable is a calculation sheet with line bases, assigned rates, reward components and a matching total. It lets every reviewer trace the final amount to its inputs. Once that trace is clear, the merchant can explain a mixed-rate reward without pretending all products earn at one universal percentage.
Discuss how a mixed-product basket should translate into a single customer reward. Discuss program fit.
Source references
This guide is general information, not financial, legal, tax or regulatory advice. Eligibility, card availability, permitted use and responsibilities depend on the applicable offer and card terms.
