Designing a Tiered Sales Commission Structure

A retail company's sales team sells 3 product lines with very different margins. The VP of Sales proposed a flat 4% commission on all revenue. The analyst must design a tiered structure that rewards high-margin sales — and manually trace it through 5 sample reps to verify the incentives work as intended.

# Aplly.xyz Case Study Submission

## Title
Designing a Tiered Sales Commission Structure

## Type
Data Analytics

## Difficulty
Intermediate

## Estimated Time
60 minutes

## Overview
A retail company's sales team sells 3 product lines with very different margins. The VP of Sales proposed a flat 4% commission on all revenue. The analyst must design a tiered structure that rewards high-margin sales — and manually trace it through 5 sample reps to verify the incentives work as intended.

## Case Details

Function Focus: Rule-based incentive design, manual calculation trace, behavioural incentive verification

Scenario:
SynergyMart sells 3 product lines: Enterprise Software (high margin, hard to sell), SaaS Subscriptions (medium margin, recurring), and IT Hardware (low margin, easy to sell). The VP of Sales wants a single flat 4% commission on all revenue — simple, easy to administer. The analyst knows this will incentivize reps to push low-margin hardware (which sells itself) instead of high-margin software (which requires effort). She must design a tiered commission structure with a bonus multiplier for high-margin mix, then manually compute commissions for 5 sample reps with different selling behaviours to prove the structure works before it goes to the board.

Proposed Commission Algorithm:
1. Base Commission: 3% of total monthly revenue
2. High-Margin Mix Bonus: If Enterprise Software share ≥ 40% of total revenue, multiply base commission by 1.5×. If ≥ 25% but < 40%, multiply by 1.25×. Otherwise, no multiplier (1.0×).
3. Cap: Total commission capped at ₹2,00,000 per rep per month
4. Rounding: Round final commission to nearest rupee

Tasks:
1. Before computing, read the proposed algorithm and identify any edge case that isn't handled (e.g., what if revenue share crosses a threshold exactly? what if base × multiplier exceeds the cap?)
2. Manually compute the total commission for Rep A (Priya) — show every step: total revenue, Product X share %, multiplier determination, base commission, multiplier application, cap check, final payout
3. Compute commissions for the remaining 4 reps (Raj, Meena, Arun, Sita) — you may create a table but each rep's arithmetic must be shown, not just the final number
4. Based on the 5 results, state whether the tiered structure successfully incentivizes high-margin selling compared to the flat 4% proposal — compute what each rep would earn under the flat 4% and compare
5. Only after completing all manual calculations, re-derive the 5 commissions using a spreadsheet or AI tool and report any discrepancies

Expected Output:
A one-page incentive memo containing: (a) edge-case analysis of the proposed algorithm, (b) per-rep commission calculation with full arithmetic, (c) a comparison table of tiered vs flat 4% earnings for all 5 reps, (d) a conclusion on whether the tiered structure fixes the incentive problem, and (e) a round-trip discrepancy note.

Evaluation Criteria:
Correct application of tier logic (share threshold → multiplier mapping), correct cap application, complete arithmetic for all 5 reps (not just final numbers), meaningful comparison against flat 4% baseline, and honest discrepancy reporting between manual and computed results.

## Data Sources

Product Lines:
| Product Line | Gross Margin | Commission Tier Category | Typical Deal Size |
|---|---|---|---|
| Enterprise Software (X) | 40% | High-margin | ₹8–15 lakh |
| SaaS Subscription (Y) | 25% | Medium-margin | ₹2–5 lakh |
| IT Hardware (Z) | 10% | Low-margin | ₹50k–2 lakh |

Monthly Sales Data — 5 Reps:
| Rep | Product | Units Sold | Revenue per Unit (₹) | Total Revenue (₹) |
|---|---|---|---|---|
| Priya (A) | Software X | 3 | 12,00,000 | 36,00,000 |
| Priya (A) | SaaS Y | 5 | 3,00,000 | 15,00,000 |
| Priya (A) | Hardware Z | 2 | 1,50,000 | 3,00,000 |
| Priya Total | | | | 54,00,000 |
| | | | | |
| Raj (B) | Software X | 1 | 10,00,000 | 10,00,000 |
| Raj (B) | SaaS Y | 8 | 2,50,000 | 20,00,000 |
| Raj (B) | Hardware Z | 15 | 1,00,000 | 15,00,000 |
| Raj Total | | | | 45,00,000 |
| | | | | |
| Meena (C) | Software X | 0 | — | 0 |
| Meena (C) | SaaS Y | 3 | 4,00,000 | 12,00,000 |
| Meena (C) | Hardware Z | 25 | 1,20,000 | 30,00,000 |
| Meena Total | | | | 42,00,000 |
| | | | | |
| Arun (D) | Software X | 5 | 11,00,000 | 55,00,000 |
| Arun (D) | SaaS Y | 2 | 3,50,000 | 7,00,000 |
| Arun (D) | Hardware Z | 0 | — | 0 |
| Arun Total | | | | 62,00,000 |
| | | | | |
| Sita (E) | Software X | 2 | 9,00,000 | 18,00,000 |
| Sita (E) | SaaS Y | 4 | 3,00,000 | 12,00,000 |
| Sita (E) | Hardware Z | 10 | 1,50,000 | 15,00,000 |
| Sita Total | | | | 45,00,000 |

Product X Share of Total Revenue for Each Rep:
| Rep | X Revenue | Total Revenue | X Share % |
|---|---|---|---|
| Priya | 36,00,000 | 54,00,000 | 66.7% |
| Raj | 10,00,000 | 45,00,000 | 22.2% |
| Meena | 0 | 42,00,000 | 0% |
| Arun | 55,00,000 | 62,00,000 | 88.7% |
| Sita | 18,00,000 | 45,00,000 | 40.0% |

## Solution Frameworks
Rule-based incentive design, tier-threshold logic, behavioural incentive analysis, round-trip verification

## Solver Guidance & Tutorials
Link to: "Incentive Structure Design and Verification" tutorial

## What You'll Learn
- Designing commission structures that align incentives with company goals
- Manual trace verification before policy rollout
- Edge-case analysis in threshold-based rules
- Comparing incentive structures quantitatively

## Tags
sales commission, incentive design, tiered pricing, business analytics, compensation structure

## Registration Links
- Register as Solver
- Register as Evaluator

Product Lines:
| Product Line | Gross Margin | Commission Tier Category | Typical Deal Size |
|---|---|---|---|
| Enterprise Software (X) | 40% | High-margin | ₹8–15 lakh |
| SaaS Subscription (Y) | 25% | Medium-margin | ₹2–5 lakh |
| IT Hardware (Z) | 10% | Low-margin | ₹50k–2 lakh |

Monthly Sales Data — 5 Reps:
| Rep | Product | Units Sold | Revenue per Unit (₹) | Total Revenue (₹) |
|---|---|---|---|---|
| Priya (A) | Software X | 3 | 12,00,000 | 36,00,000 |
| Priya (A) | SaaS Y | 5 | 3,00,000 | 15,00,000 |
| Priya (A) | Hardware Z | 2 | 1,50,000 | 3,00,000 |
| Priya Total | | | | 54,00,000 |
| | | | | |
| Raj (B) | Software X | 1 | 10,00,000 | 10,00,000 |
| Raj (B) | SaaS Y | 8 | 2,50,000 | 20,00,000 |
| Raj (B) | Hardware Z | 15 | 1,00,000 | 15,00,000 |
| Raj Total | | | | 45,00,000 |
| | | | | |
| Meena (C) | Software X | 0 | — | 0 |
| Meena (C) | SaaS Y | 3 | 4,00,000 | 12,00,000 |
| Meena (C) | Hardware Z | 25 | 1,20,000 | 30,00,000 |
| Meena Total | | | | 42,00,000 |
| | | | | |
| Arun (D) | Software X | 5 | 11,00,000 | 55,00,000 |
| Arun (D) | SaaS Y | 2 | 3,50,000 | 7,00,000 |
| Arun (D) | Hardware Z | 0 | — | 0 |
| Arun Total | | | | 62,00,000 |
| | | | | |
| Sita (E) | Software X | 2 | 9,00,000 | 18,00,000 |
| Sita (E) | SaaS Y | 4 | 3,00,000 | 12,00,000 |
| Sita (E) | Hardware Z | 10 | 1,50,000 | 15,00,000 |
| Sita Total | | | | 45,00,000 |

Product X Share of Total Revenue for Each Rep:
| Rep | X Revenue | Total Revenue | X Share % |
|---|---|---|---|
| Priya | 36,00,000 | 54,00,000 | 66.7% |
| Raj | 10,00,000 | 45,00,000 | 22.2% |
| Meena | 0 | 42,00,000 | 0% |
| Arun | 55,00,000 | 62,00,000 | 88.7% |
| Sita | 18,00,000 | 45,00,000 | 40.0% |

Rule-based incentive design, tier-threshold logic, behavioural incentive analysis, round-trip verification