Sales Target Cascade & Incentive Calculation for FMCG Field Teams: A Practical Guide

Quick answer: A sales target cascade splits a national target down the hierarchy, from NSM to RSM, ASM, sales officer, distributor and order-booking salesperson, so everyone carries a share of one number. Incentives are paid on a weighted scorecard: each KPI's weight × its slab multiplier, times a base amount, plus bonuses and minus overdue deductions.

Key takeaways

• Set targets once at the top (national anchors) and cascade them. Don't build separate spreadsheets for each region.

• Lock a target as soon as achievement starts, so goalposts cannot move mid-month.

• Phase monthly targets into weekly bands to stop month-end loading.

• Publish the incentive formula. Reps who can calculate their own payout stop arguing about it.

What is a sales target cascade?

In most FMCG companies the annual plan becomes a monthly national number, which then has to be split across regions, areas, territories, distributors and finally the people booking orders at outlets. A cascade is that split, done inside the system instead of in a chain of Excel files.

In SalesPort, the national targets are called anchors. Anchors are uploaded per cycle, target type, channel, product or category and packaging level. Each manager then distributes their share to the people below them in the reporting tree, and distributors distribute theirs to the retail order-booking salespeople (ROBS) assigned to them.

Which target types should you set?

Volume and value alone reward pushing stock. A balanced target sheet for FMCG field teams usually mixes:

• Sales volume (cartons) and sales value.

• Focus product volume or value, for launches and priority SKUs.

• Outlet creation: new outlets approved, often paid on first billing.

• ECO (effective call outlets): outlets that actually placed an order above a bill-cut threshold.

• Line-per-sales (LPS) and GTM multi-SKU targets, which push range width at each outlet.

• Collection amount and overdue clearance by ageing bucket (31–45, 46–60 and 60+ days).

• Sales target phasing: how evenly the month's sales were spread across weeks.

How does a target cascade work?

1. Create the cycle. Weekly and monthly cycles can run in parallel. A cycle moves from draft to active to locked to closed, and can be cloned from last month with an uplift.

2. Load national anchors from Excel and assign them to top-level managers.

3. Distribute down the tree. Each manager splits their target among direct reports. Under-allocation is allowed, so a manager can hold back a share, but over-allocation is not.

4. Distribute to ROBS. Distributors pass their targets to the order-booking salespeople working under them. External recipients get their own rates.

5. Lock on first achievement. The moment a sale counts towards a target, that assignment and everything above it lock. Changes after that need an admin override with a written reason, and every distribution is audited.

How does weekly phasing stop month-end loading?

A monthly target with no weekly shape invites the same pattern every month: a slow first three weeks, then a rush of primary orders in the last five days. Weekly phasing splits each monthly target into weekly (or fortnightly) phases with lower and upper bands and a weekly cap, so a burst of sales in one week cannot make up for the whole month. Each person's phasing compliance is tracked week by week, and dealer phasing compliance rolls up to their managers. It pairs naturally with DRR-based stock replenishment.

Compute achievement live, never store it

Disputes start when achievement is a number someone typed into a sheet. In SalesPort, achievement is computed live from paid orders, approved outlets, collections, overdue positions and bill cuts, and is never stored as a separate figure. The rep's app, the manager's dashboard and the finance report therefore always show the same number.

How is a sales incentive calculated?

Incentive calculation in SalesPort (Incentives v2) uses a transparent three-part formula:

• Weighted score = Σ (KPI weight × slab multiplier for that KPI's achievement)

• Scorecard payout = base amount for the role × weighted score

• Net payout = (scorecard payout + new-outlet bonus) × (1 − ageing deduction) + overdue clearance bonus

KPI weights are set per position and must add up to 100%. Payout slabs map an achievement range to a multiplier, for example 90–99% → 0.9, 100–109% → 1.1, and can be global, per KPI or per position. Every rule is effective-dated, so a change in April never rewrites March.

Worked example: an ASM's monthly incentive

The slabs below are illustrative. An Area Sales Manager has a base incentive of ₹10,000 and four KPIs:

• Secondary sales value: weight 40%, achievement 105%, multiplier 1.1 → 0.440

• Focus product volume: weight 20%, achievement 92%, multiplier 0.9 → 0.180

• Outlet creation: weight 15%, achievement 80%, multiplier 0.5 → 0.075

• Collection amount: weight 25%, achievement 100%, multiplier 1.0 → 0.250

1. Weighted score = 0.440 + 0.180 + 0.075 + 0.250 = 0.945

2. Scorecard payout = ₹10,000 × 0.945 = ₹9,450

3. New-outlet bonus: 6 outlets billed for the first time × ₹150 = ₹900 → ₹10,350

4. Ageing deduction of 5% for overdue in the 60+ bucket → ₹10,350 × 0.95 = ₹9,832.50

5. Overdue clearance bonus of ₹500 → net payout ₹10,332.50

The ASM can see every one of these lines in the My Incentive scorecard, and can use the what-if simulator to see what an extra 5% on focus products would be worth before the month ends.

Still calculating incentives in Excel? Book a 30-minute walkthrough to see the scorecard and what-if simulator on your own hierarchy.

From calculation to payout

An incentive period moves through draft → open → calculated → under review → approved → locked → paid. Per-KPI adjustments go through maker-checker approval, and payouts are recorded as a credit note, cash discount, bank transfer, cheque or ERP posting. A management dashboard shows incentive liability, trends, payout by role and at-risk entities before the period closes, not after.

Common mistakes

• Too many KPIs. Four to six per role is enough. With twelve, nobody knows what to focus on.

• Paying on primary sales only. This rewards loading. Weight secondary sales, phasing and collections.

• Editable targets. If a target can change after the first sale, every review becomes a negotiation.

• Hidden formulas. If reps cannot reproduce their payout, they will assume it is wrong.

Run targets and incentives in your DMS

Targets and incentives in SalesPort read directly from the orders, outlets and collections captured in the distributor management system and the field Sales App, so achievement is never re-keyed. Schedule a walkthrough to see the cascade and scorecard on your own hierarchy.