Calculation notes
Rules into a working engine
A file that evaluates new-CIF eligibility, applies defined incentive rules, checks input quality, and calculates payouts.
Rules
Below 100% KPI → no incentive.
Payout = 1,000 × incentive rate.
| Record | New CIF | KPI | Incentive | Payout |
|---|---|---|---|---|
| AKPI below 100% | Yes | 80% | — | Excluded |
| B100–<150% KPI tier | Yes | 120% | 30% | 300 |
| CExisting CIF | No | 150% | — | Excluded |
| D150%+ KPI tier | Yes | 150% | 36% | 360 |
| E150%+ KPI tier | Yes | 180% | 36% | 360 |
Follow the rules from eligibility to payout.
Rules, decisions, outputs
In my MIS Support role at Hong Leong Bank Vietnam, I developed a rules-based FX broker payout calculator. The useful part was encoding how decisions should be made: which records qualify, which incentive applies, and when the calculation should stop for review.
The file carries that logic. Its format is the interface to the engine, rather than the main outcome.
Follow the example
The illustration uses five example records and a tiered rule: new CIFs only, no incentive below 100% KPI, 30% from 100% to below 150%, and 36% from 150% upwards.
Each payout base is 1,000 units. A reaches 80% and receives no incentive. B reaches 120% and receives 300. C reaches 150% but is excluded because it is an existing CIF. D at 150% and E at 180% each receive 360. Total: 1,020 units.
Checks beyond the SOP
A procedure may describe the incentive without describing every way input data can be wrong. I check phone formatting, missing record IDs, and duplicates as a separate validation layer.
For example, a phone number that is too short or a missing record ID should hold the payout for review even when the KPI qualifies. Duplicate IDs also need review before a record can be paid twice. These checks sit alongside the incentive logic; the homepage illustration focuses on eligibility and KPI tiers.
The example normalizes spaces, punctuation, and +84 notation in phone numbers. It uses a fictional CIF-0000 record-ID convention, not a national identity-document rule.
Each row retains the reason for its result. A review hold should be visible to the person checking the payout.
These are synthetic values and illustrative rules, not an employer’s commission policy or transaction records.