Protection Mix Contest Budget Calculator

Single-file calculator using your method: allocate total plans across performance tiers, convert to plan retail dollars, then apply an incentive rate per $1,000 of plan retail. Edit inputs and tier assumptions to instantly see budget impact.

Dollars-only metric Transparent math Dealer co-fund supported
v1

Inputs

Model note: “Tier share %” is treated as % of total plan volume allocated to each performance tier (your method). Use “Normalize tier % to 100%” if you change tier shares.

Summary KPIs

Total plan retail ($)
$0
Total incentives pool ($)
$0
RAP incentive cost ($)
$0
RAP cost per plan ($)
$0
Incentives as % of RAP net
0%
Reminder: We divide plan retail by 1,000 because incentive rates are expressed as $ per $1,000 of plan retail.

Tiers & Math (editable)

Tier Mean mix %
(context)
Tier share %
(of plan volume)
Plans sold
(units)
Avg plan retail Plan retail ($)
units × retail
÷ 1,000 Incentive rate
$ per $1,000
Incentive earned ($)
thousands × rate
Totals
Weighted incentive rate shown above is computed as: Total incentives ÷ (Total plan retail ÷ 1,000).

RAP / Dealer Split (fully shown)

Party Net / Plan ($) Total plans Total net / retail ($) Incentive share % Incentive share ($) After incentives ($) Incentive % of net
RAP
Dealer