| ← Back to
Dashboard |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
ASSUMPTIONS & CONFIGURATION |
|
|
|
|
|
|
| |
Model Parameters, Risk Weights & Thresholds |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
GENERAL MODEL PARAMETERS |
|
ATTRITION COST PARAMETERS |
| |
Parameter |
Value |
Unit |
|
Cost Component |
Value |
Basis |
| |
Analysis Date |
2026-02-12 |
Date |
|
DIRECT COSTS |
|
|
| |
Fiscal Year Start Month |
1 |
Month (1-12) |
|
Recruitment
Advertising |
$4,500 |
$ per hire |
| |
Total Headcount |
500 |
Employees |
|
Agency Fees (if
applicable) |
20.0% |
% of salary |
| |
Average Annual Salary |
$85,000 |
$ |
|
Interview &
Selection Costs |
$3,200 |
$ per hire |
| |
Average Benefits Cost (% of Salary) |
30.0% |
% |
|
Background Check &
Screening |
$500 |
$ per hire |
| |
Annual Voluntary Turnover Rate (Current) |
14.2% |
% |
|
Relocation Assistance |
$5,000 |
$ per hire |
| |
Annual Involuntary Turnover Rate |
3.8% |
% |
|
Onboarding &
Training |
$6,500 |
$ per hire |
| |
Target Voluntary Turnover Rate |
8.0% |
% |
|
INDIRECT COSTS |
|
|
| |
Industry Benchmark Turnover Rate |
12.0% |
% |
|
Lost Productivity
(Departing) |
0.50x |
x monthly salary |
| |
Average Time to Fill (Days) |
45 |
Days |
|
Lost Productivity
(Vacant Role) |
0.75x |
x monthly salary |
| |
New Hire Ramp-Up Period |
90 |
Days |
|
Lost Productivity (New
Hire Ramp) |
0.25x |
x salary (ramp) |
| |
Engagement Survey Frequency |
4 |
Times/Year |
|
Knowledge Transfer
Loss |
10.0% |
x annual salary |
| |
|
|
|
|
Team Morale Impact |
5.0% |
x team salary |
| |
TURNOVER RISK SCORING WEIGHTS |
|
Overtime for Coverage |
$2,500 |
$ per departure |
| |
Risk Factor |
Weight |
Max Score |
|
|
|
|
| |
Engagement Score |
20.0% |
100 |
|
ENGAGEMENT SCORING CONFIGURATION |
| |
Compensation Competitiveness |
15.0% |
100 |
|
Engagement Dimension |
Weight |
Scale |
| |
Manager Relationship |
15.0% |
100 |
|
Job Satisfaction |
20.0% |
5-Jan |
| |
Career Development Opportunity |
12.0% |
100 |
|
Organizational Commitment |
15.0% |
5-Jan |
| |
Work-Life Balance |
10.0% |
100 |
|
Manager Effectiveness |
15.0% |
5-Jan |
| |
Tenure Risk (Flight Risk Window) |
8.0% |
100 |
|
Growth & Development |
15.0% |
5-Jan |
| |
Performance Rating Trend |
7.0% |
100 |
|
Compensation Fairness |
10.0% |
5-Jan |
| |
Promotion Recency |
5.0% |
100 |
|
Work Environment |
10.0% |
5-Jan |
| |
Team/Peer Satisfaction |
5.0% |
100 |
|
Recognition & Rewards |
8.0% |
5-Jan |
| |
External Market Demand |
3.0% |
100 |
|
Team Collaboration |
7.0% |
5-Jan |
| |
Total Weight (must = 100%) |
100.0% |
✓ Valid |
|
Total Weight (must = 100%) |
100.0% |
✓ Valid |
| |
|
|
|
|
|
|
|
| |
RISK CLASSIFICATION THRESHOLDS |
|
DEPARTMENT COST MULTIPLIERS |
| |
Risk Level |
Min Score |
Max Score |
|
Department |
Cost Multiplier |
Notes |
| |
Critical (Immediate Action) |
0 |
35 |
|
Engineering |
1.5x |
High replacement difficulty |
| |
High (Monitor Closely) |
36 |
55 |
|
Sales |
1.3x |
Revenue impact + ramp time |
| |
Medium (Standard Review) |
56 |
75 |
|
Marketing |
1.1x |
Moderate specialization |
| |
Low (Stable) |
76 |
100 |
|
Finance |
1.2x |
Regulatory knowledge |
| |
|
|
|
|
Human Resources |
1.0x |
Baseline cost |
| |
NOTES |
|
|
|
Operations |
1.1x |
Process knowledge |
| |
- Blue text indicates user-editable input cells |
|
|
|
Legal |
1.4x |
Specialized + long ramp |
| |
- All weights should sum
to 100% (validated automatically) |
|
|
Customer Success |
1.2x |
Client relationships |
| |
- Risk scores range from
0 (highest risk) to 100 (lowest risk) |
|
|
|
|
|
| |
- Cost multipliers
adjust replacement cost by department difficulty |
|
|
|
|
|
| |
- Sample data provided;
replace with actual organizational data |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|