What the package is made of

Base is only part of the promise. The mix report puts base and target variable side by side, by department: Sales carries fifteen percent of base at risk, Support five, and the company’s target cash bill is 51,821,890.00 a year.

RuleState the mix on targets, and keep target separate from actual. The mix is a design decision; the payout is a performance outcome; one report per question.

Neveraverage mix percentages across departments. Sum the money, then divide. Averages of ratios mislead wherever headcount differs.

Design on the left, promise on the right. What was actually paid against the variable lives on the payout report.

◆ The mix, by departmentbase and target variable, side by side.

Department	Annual base bill	Target variable	Variable as % of base	Target cash
Sales	21,879,000.00	3,281,850.00	15.0	25,160,850.00
Technology Delivery	15,444,800.00	1,544,480.00	10.0	16,989,280.00
Support	9,211,200.00	460,560.00	5.0	9,671,760.00
All departments	46,535,000.00	5,286,890.00	11.4	51,821,890.00

Sales carries the most pay at risk by design; Support the least. The company’s promise, base plus target variable, is 51,821,890.00 a year, and every row is base bill times the department’s target rate, to the cent. Sample values are illustrative, never client data.

◆ The boundary this report keepstargets here, payouts elsewhere.

Everything above is a promise: what the plan says pay looks like when performance hits target. What was actually paid against these targets is a different number with a different owner, and it lives on the bonus payout report: 5,096,030.50 against this page’s 5,286,890.00, a 96.4 percent year.

Mixing the two in one table is how a mix report quietly becomes a performance report. Keep the design on this page and the outcome on that one, and let each argue its own case.

◆ The owned answerthe mix from the same snapshot the ratios use.

Base comes from the daily pay snapshot; target variable comes from plan assignments on the same worker keys. One query, grouped by department, money summed before any ratio is taken.

Schema, grain, and joins live on the compensation star; this report is a straightforward read of those tables.

Use case

Problem

Pay mix is quoted as averaged percentages that disagree between decks, and target and actual variable blur into one unexplainable number.

What we build

Base and target variable summed from the snapshot by department, ratios taken after the money is summed, with actual payouts kept on their own report.

What you get

A mix you can govern: the at-risk design stated in money and percent, consistent across every deck, with the payout story cleanly separated.

Does every deck quote a different pay mix?

We build the mix from the snapshot, money first, one number per question.

Talk to us

Terms on this page

pay mix: The split of the package between base and variable, stated on targets.
target variable: The bonus promised at on-target performance.
at risk: The share of the package that depends on performance.
target cash: Base plus target variable; the plan’s whole cash promise.
payout ratio: Actual paid over target; lives on the payout report, not here.
plan assignment: The record tying a worker to a bonus plan and a target.