Why compensation decisions require modelling before execution

A compensation cycle touches every employee simultaneously. A 4% merit increase applied to 200 employees has a total cost that is straightforward to calculate in the abstract but conceals significant variation in practice: the impact on pay equity across different levels, the effect on compression ratios, the degree to which it maintains the organisation's competitive position versus the external market, and the question of whether a uniform percentage is the right distribution mechanism or whether band-position-based differentiation would produce better outcomes at the same cost.

HR leaders who approach leadership with a single proposal — "we recommend a 4% merit increase across the board" — frequently discover that the conversation that follows is not a decision but a negotiation. Leadership asks: what happens if we do 3%? What if we do 5% for critical roles only? Can we focus the budget on retention risks? Each of these questions requires new calculations, and without prepared scenarios, the meeting ends without a decision, with HR sent back to model alternatives and schedule a follow-up.

Scenario planning changes the structure of the conversation. When HR presents three prepared scenarios — conservative, target and stretch — with the full cost, equity and retention impact of each quantified, leadership can make a real choice rather than a negotiation. The discussion moves from "what should we do" to "which of these options best fits our priorities given the budget available." This is a more productive conversation that produces decisions, not deferrals.

The modelling rigour required for scenario planning also improves the quality of the compensation decisions themselves. When HR teams are required to quantify the equity impact of each scenario, they discover compression problems that a uniform percentage increase would preserve. When they calculate the retention risk concentration — which roles and which employees are most exposed under each scenario — they can build targeted differentiation into the preferred scenario rather than discovering the retention problem six months after the cycle closes.

The Three Scenario Minimum Rule

Always model at least three scenarios: conservative, target and stretch. Single-scenario modelling systematically underestimates cost in one critical respect: it presents only the scenario HR thinks is right, which means leadership has no reference point for the trade-offs involved. Without a conservative scenario, they cannot evaluate what is given up by spending less. Without a stretch scenario, they cannot understand what additional investment would buy. The three-scenario structure forces clarity on what each additional percentage point of merit budget achieves in terms of equity correction, retention risk reduction and competitive positioning — making the cost-benefit calculation concrete rather than abstract.

Types of scenarios: merit increase, market adjustment and promotion

Compensation scenarios are not limited to merit increase modelling. A complete compensation cycle may involve three distinct types of adjustments, each of which should be modelled separately before being combined into an integrated proposal.

Merit increase scenarios model the cost and impact of different percentage increase guidelines applied to the base salary population. The most useful approach differentiates merit increases by two variables: band position (where the employee sits within their salary band) and performance rating (their most recent performance tier). Employees in the lower part of their band who are high performers should receive the highest merit increases; employees at or above the band midpoint with standard performance should receive the lowest. This differentiated approach improves equity outcomes compared to uniform percentages, often at the same or lower total cost.

Market adjustment scenarios address employees whose salaries are below the external market rate regardless of their performance. These are not merit increases — they are corrections to ensure the organisation remains competitive. A market adjustment scenario models which employees require an off-cycle or additional-to-merit adjustment to bring them to a defined competitive position, and what the total cost of that correction would be. Market adjustment and merit can be modelled separately and then combined, or modelled as a single integrated adjustment, depending on whether the organisation communicates the two components separately to employees.

Promotion scenarios model the cost of approved promotions in the upcoming cycle. Promotions involve both a level change and a salary adjustment, and the two interact: the new level's salary band may be significantly above the employee's current salary, and the promotion adjustment needs to place the employee at an appropriate point within the new band rather than simply applying a fixed percentage. Promotion cost is frequently underestimated in compensation planning because it is treated as a separate HR workflow rather than integrated into the total compensation budget model.

Building a compensation scenario in your HR system

Building a compensation scenario requires four inputs: the employee population in scope, their current salaries and band positions, their performance ratings, and the scenario parameters — what merit guidelines will be applied by band position and performance tier. With these inputs, a well-designed HR compensation module calculates the total cost of the scenario, the resulting band positions of all employees, and the equity metrics before and after the adjustment.

The scenario parameters themselves require deliberate design. A common starting structure for a merit increase scenario is a matrix: rows represent performance tiers (typically three to five), columns represent band position quartiles, and each cell contains the merit increase guideline for that combination. The highest merit percentages are in the cell combining the highest performance tier with the lowest band position quartile. The lowest merit percentages are in the cell combining the standard performance tier with the above-midpoint band position. This structure ensures that merit investment is concentrated where it creates the most value: developing high performers toward competitive pay, while managing cost for employees whose compensation is already market-competitive.

Once the scenario parameters are defined, the system applies them across the employee population and calculates: the total annual cost increase; the per-employee increase amounts and resulting new salaries; the new band position for each employee; the number of employees who would be brought within the target band range; and the compression ratios before and after the adjustment. This output is the foundation for both internal review and leadership presentation.

Compensation Scenario Builder in Treegarden

Treegarden's compensation module allows HR leaders to build multiple pay scenarios simultaneously, with real-time cost impact calculations and equity gap analysis. Scenarios are built using configurable merit matrices — by performance tier and band position — and applied instantly across the employee population. As parameters are adjusted, the total cost and equity metrics update in real time, enabling rapid iteration without rebuilding spreadsheets. Up to three scenarios can be built in parallel and compared side-by-side before any are presented to leadership or submitted for approval.

Comparing scenarios: cost, equity and retention impact

The value of building multiple scenarios is realised in the comparison. Three dimensions of comparison are most useful for leadership decision-making: total cost, equity improvement and retention risk reduction.

Total cost comparison is the most straightforward: each scenario has an annual cost increase expressed as a percentage of the total salary base and as an absolute monetary figure. The marginal cost of moving from the conservative to the target scenario, and from the target to the stretch scenario, reveals the price of each additional outcome objective. Leadership often does not have an intuitive sense of how much a half-percentage-point difference in merit rates costs across the organisation; presenting it concretely makes the trade-off clear.

Equity improvement comparison measures the change in equity metrics under each scenario. Key metrics include: the number of employees below the band minimum who would be brought into range; the change in compression ratios across critical role pairs; the change in the pay gap between demographic groups identified in the equity analysis; and the number of employees at or below the first quartile of their band who would move above the first quartile through the increase. A scenario that costs 0.5% more but resolves twice as many compression cases and closes a gender pay gap may represent better value than the cheaper option.

Retention risk comparison assesses each scenario's impact on the employees identified as highest flight risks. This requires cross-referencing the compensation scenario outputs with retention risk scores — combining performance data, compensation band position, tenure and recent engagement signals. Scenarios that specifically address the salary position of high-retention-risk employees provide a measurable reduction in expected turnover cost, which can be quantified and presented to leadership alongside the direct salary cost.

Budget Impact Forecasting in Treegarden

Treegarden's budget impact forecasting tool breaks down the cost of each compensation scenario by department, role type and seniority level, enabling department heads and finance partners to see their specific allocation within the overall budget. This granularity is critical for organisations where budget authority is distributed across business units: each department leader needs to see not just the total cost but their department's share. The forecast includes annualised cost, quarterly cost phasing and the full-year impact accounting for employees who will join or leave during the year.

Presenting scenarios to leadership and finance

The scenario presentation to leadership should be structured as a decision-enabling document, not an advocacy document. HR's role is to present the options clearly and recommend one, with the data to support the recommendation, rather than to present only the option HR wants approved.

The presentation structure that works best in practice covers: the context (what is happening in the external market, what the current equity position looks like, what the retention risk profile is); the three scenarios with their parameters, total costs and key outcomes; a clear recommendation with the rationale; and the implementation plan for the recommended scenario. The recommendation section should include an honest acknowledgement of what the recommended scenario does not achieve — which compression cases it leaves unresolved, which employees remain below market — so that leadership understands the residual risk they are accepting along with the budget.

Finance alignment before the presentation is essential. A compensation scenario that has not been reviewed by Finance before the leadership meeting frequently fails because Finance raises a budget objection that HR had not anticipated. The pre-meeting alignment with Finance should cover: the total cost of the recommended scenario; whether it fits within the approved headcount budget envelope; the cash flow impact by quarter; and whether any accounting treatment questions arise from the approach. Finance sign-off on the numbers before the meeting means the leadership discussion can focus on strategic priorities rather than financial feasibility.

Involve Finance Before You Present to Leadership

Finance alignment on budget feasibility before the executive presentation prevents scenarios from being rejected on cost grounds alone. When Finance has not seen the scenarios before the leadership meeting, the most common outcome is a challenge to the cost assumptions, a request for revised modelling and a delayed decision. When Finance has reviewed and validated the numbers in advance — even if they have pushed back and required adjustments to the scenarios — the leadership meeting can focus on the strategic choice between approved options rather than reopening the financial modelling. This single process change converts compensation presentations from multi-round negotiations into single-meeting decisions.

Moving from approved scenario to implementation

Once a scenario is approved, the implementation phase converts the modelled increases into individual employee actions. This transition requires care: the approved scenario sets parameters, but individual increases are applied at the employee level and reviewed by managers before communication.

The standard implementation workflow begins with system-generated increase proposals: for each employee in scope, the approved merit matrix generates a proposed increase based on their performance tier and band position. Managers review and adjust within defined guard rails — typically able to move an employee's increase up or down within a specified percentage of the matrix-generated proposal, subject to staying within budget. This manager review step introduces informed local knowledge (individual contributions, upcoming role changes, particular retention risks) without allowing unlimited discretion that would undermine the equity objectives of the scenario.

HR reviews the adjusted proposals in aggregate before they are finalised, checking that the total cost remains within the approved budget and that manager adjustments have not systematically re-introduced the equity problems the scenario was designed to address. Where manager adjustments cluster — for example, if one department's manager has systematically reduced increases for a particular demographic — this is a signal requiring investigation before the cycle closes.

Scenario Comparison View in Treegarden

Treegarden's scenario comparison view presents up to three compensation scenarios side by side, with equity, cost and retention risk metrics displayed in a consistent format that makes the differences immediately legible. HR leaders can see at a glance: the total cost differential between scenarios; which compression cases are resolved under each option; and how each scenario changes the overall distribution of employees within their salary bands. The comparison view is designed to be usable as a direct presentation tool in leadership meetings, removing the need to export data to separate presentation materials.

Making scenario planning an ongoing process

In most organisations, compensation scenario planning is treated as an annual event aligned to the merit review cycle. This episodic approach misses a significant opportunity: the conditions that inform compensation decisions — market rates, retention risk, equity position, budget availability — change continuously throughout the year. An organisation that only models compensation scenarios once annually is making decisions with data that is already twelve months old by the time the cycle closes.

A more effective approach treats scenario planning as a continuous discipline with formal annual milestones. Throughout the year, HR maintains a live view of the equity and compression position, monitors the retention risk profile of critical employees and tracks how the organisation's compensation positioning compares to market benchmarks. When these indicators reach defined thresholds — for example, when compression ratios in a critical department exceed the risk threshold — an off-cycle scenario analysis is triggered to assess whether an immediate targeted adjustment is warranted.

This continuous approach also improves the quality of the annual merit cycle. When HR enters the annual cycle with a clear picture of the equity position, the retention risk concentration and the market positioning — because they have been monitoring it continuously — the scenario building process is faster and the scenarios are more targeted. The annual cycle becomes a structured moment to formalise and implement a compensation philosophy that has been continuously maintained rather than a once-a-year attempt to understand the current state before making decisions.

Frequently asked questions about compensation scenario planning

What is compensation scenario planning in HR?

Compensation scenario planning is the process of modelling multiple possible salary adjustment approaches — with their associated costs, equity outcomes and retention implications — before committing to a specific course of action. Rather than deciding on a uniform merit increase percentage and implementing it, scenario planning builds at least three alternatives (conservative, target and stretch), calculates the full budget impact of each, analyses how each affects pay equity and compression, and presents the options to leadership with supporting data. The goal is to make the decision based on evidence rather than instinct, and to avoid the common failure mode of underestimating the true cost of a compensation change.

How many scenarios should HR model for an annual merit review?

The minimum is three: a conservative scenario that achieves essential equity corrections within a tight budget, a target scenario that represents the organisation's intended compensation philosophy applied consistently, and a stretch scenario that demonstrates the cost and impact of a more competitive compensation position. More than five scenarios typically generates more confusion than insight. The value of multiple scenarios is not in the variety itself but in revealing the marginal cost of each additional percentage point of investment, allowing leadership to make an informed trade-off between budget and outcomes rather than simply approving or rejecting a single proposal.

Who should be involved in compensation scenario planning?

Compensation scenario planning is fundamentally a collaboration between HR, Finance and senior leadership. HR brings the workforce data, the compensation philosophy and the equity analysis. Finance brings the budget envelope, the cash flow constraints and the multi-year cost projection. Senior leadership brings the strategic priorities — which teams are critical to retain, which roles are most at risk, and how compensation investment aligns with business goals. Excluding Finance from the modelling phase is the most common mistake: scenarios that are built without finance input frequently fail to survive contact with budget reality, requiring the entire modelling exercise to be repeated with tighter constraints.

What data does HR need to build a compensation scenario model?

A complete compensation scenario model requires: current base salary for every employee in scope; role, level and seniority classification for each employee; current band position (where each employee sits within their defined salary band); performance rating or tier from the most recent review cycle; location and any applicable cost-of-living adjustments; and the total budget envelope approved by finance. With these inputs, the scenario model can calculate the cost of applying different merit increase guidelines by band position and performance tier, the resulting band position after the increase, and the equity impact on compression ratios. Market benchmark data, if available, adds a further dimension by showing how each scenario positions the organisation relative to external competition.