薪酬回歸曲線

專題：薪酬回歸曲線級(jí)別薪資股票（“F拿完）PS15W-25W無P620W-35W無P7

30W-50W

2400股P8

45W-80W

6400股P980W-100W16000股PlO公司級(jí)別級(jí)別級(jí)別Base(months)Bonus(months)阿里巴巴P7P8P9l33~6百度T6T7T8+122.6+騰訊T2.3-T3.lT3.2-T3.3T4+141~3，具體看業(yè)務(wù)線寬帶薪酬的幾種情況高度重疊部分重疊無重疊混合重疊AnalysisTY

vs

LYATC

MIDATC

MIDPr'ssionRangeP25

vs

P50P50

vs

P75P25

vs

P75薪資級(jí)別

MIN

MID

MAX

幅寬

重疊率

級(jí)間距-9%34%25%67%-8%21%33%25%67%59021,128

1,35450%-8%21%33%26%67%-7%21%32%26%66%-7%21%31%26%66%671,03

1,294

1,555

31,19

1,490

1,782

850%50%62%61%15%15%-6%21%31%26%66%-6%21%30%27%65%-5%21%30%27%65%-4%21%29%27%64%-4%21%29%27%64%-3%21%28%27%64%891,36

1,701

2,041

11,67

2,099

2,519

950%50%63%43%14%23%-3%21%28%28%63%-2%21%28%28%63%-2%21%27%28%63%-1%21%27%28%63%0%21%26%28%62%0%21%26%29%62%1%21%25%29%62%1%21%25%29%61%2%21%25%29%61%3%21%24%29%61%3%21%24%30%61%21%24%30%60%Latest

Market

Raw

DataMarketGradeAnnual

Basic

Salary

(ABS)Annual

Guaranteed

Cash

(AGC)Annual

Total

Cash

(ATC)P25P50P75P25P50P75P25P50P754010,78615,15019,44011,79515,80819,99414,54519,45324,3554113,10618,27523,40814,29719,08824,13917,61023,44729,4154215,92222,04528,18717,32923,04729,14321,31828,26235,5244319,34026,59233,94321,00127,82835,18525,80434,06542,9004423,48932,07840,87625,44933,60042,47831,23241,05951,8064528,52338,69549,22730,83740,57051,28537,79849,49062,5584634,63046,67659,28737,36348,98561,91645,74059,65375,5394742,04056,30571,40445,26759,14774,75355,34671,90191,2094851,02867,91986,00154,83871,41690,25066,96486,665110,1274961,93181,930103,58666,42986,230108,96081,015104,461132,9635075,15398,830124,77080,464104,117131,55098,007125,910160,5285191,187119,216150,29097,459125,714158,824118,553151,764193,80352110,629143,808181,036118,036151,791191,752143,397182,927233,96753134,203173,473218,077142,950183,278231,508173,436220,488282,44754162,782209,256262,704173,112221,296279,506209,754265,762340,96255197,428252,422316,471209,626267,200337,456253,662320,333411,58856239,423304,491381,251253,830322,626407,422306,742386,108496,83057290,325367,301459,303307,339389,550491,895370,909465,390599,71158352,016443,067553,346372,110470,356593,883448,473560,951723,87759426,779534,462666,659450,511567,924717,018542,228676,134873,73060517,377644,711803,193545,405685,731865,685655,550814,9691,054,58061627,155777,701967,709660,259827,9751,045,177792,515982,3111,272,83562760,165938,1241,165,945799,265999,7251,261,887958,0501,184,0141,536,227一個(gè)優(yōu)秀的寬帶薪酬曲線050,000100,000150,000200,000250,000300,000350,000400,000450,000123456789101112131、平滑曲線2、級(jí)別越高越陡（高級(jí)別級(jí)差大）3、級(jí)別越高級(jí)別跨度越大4、級(jí)別間有重疊5、R方值合適各職級(jí)薪酬中點(diǎn)值取樣與調(diào)整序號(hào)崗位名稱評(píng)估得分職級(jí)取樣調(diào)整1文員1301300041002出納2122636749003行政專員21624經(jīng)理助理22025商務(wù)文案2613674457006系統(tǒng)支持崗27137成本會(huì)計(jì)27438軟件工程師2984657467009人事管理崗305410主管會(huì)計(jì)34157250800011辦事處主任347512客戶經(jīng)理350513服務(wù)部副經(jīng)理386610112940014人事經(jīng)理4257112051100015技術(shù)部經(jīng)理436717服務(wù)部經(jīng)理439718營銷部經(jīng)理4738119141300019…………………………各職級(jí)薪酬中點(diǎn)值取樣與調(diào)整（續(xù)）Y的值=3498.7*exp（0.1642*X）y

=34R928.=7e0.1642x0.83491400012000100008000600040002000

00

0圈中數(shù)據(jù)——點(diǎn)擊插入散點(diǎn)圖（第一個(gè)）——點(diǎn)中圖中散點(diǎn)——添加趨勢(shì)線——選擇線性/指數(shù)——勾選顯示公式、顯示R平方值123456789指數(shù)線職級(jí)取樣中點(diǎn)值線性調(diào)整1：Y=1159.1*X+2679.6指數(shù)調(diào)整2：Y=3498.7*（e~0.1642*X）取整（=round（待取整數(shù)值/100，0）*100130003838.74123.042954100263674997.84858.7998894900367446156.95725.85263957004657473166747.6309376700572508475.17951.74555380006101129634.29370.7344940071120510793.311042.941781100081191411952.413013.5545413000y

=1159.1x

+2679R.62

=0.91311400012000100008000600040002000

0123456789線性線檔差設(shè)計(jì)——寬帶薪酬設(shè)計(jì)（一）取整公式=ROUND(A÷10,0)×10不等比的檔差檔差比：

8%比例型檔差設(shè)計(jì)：等比的檔差檔差比：

10%薪檔123456789檔差比工資4190452548875278570061566648718077558%取整419045204890528057006160665071807750薪檔123456789檔差比工資41904525488752785700627068977586.78345.37檔差設(shè)計(jì)——寬帶薪酬設(shè)計(jì)（二）檔差的設(shè)計(jì)取決于檔差的數(shù)量、檔差、職級(jí)薪酬的最大值和最小值：差額檔差、比例檔差差額型檔差設(shè)計(jì)：等額的檔差1、等級(jí)的最小值=中點(diǎn)值÷（1+寬幅/2）2、等級(jí)的最大值=最小值×（1+寬幅）檔差額：

407檔差額：

500不等額的檔差3、檔差=（最大值-最小值）/（檔位數(shù)-1）薪檔123456789寬幅工資4071447948865293570061076514692173290.8薪檔123456789寬幅工資407144794886529357006200670072007700薪酬矩陣表（等級(jí)工資表）示例1檔2檔3檔4檔5檔6檔7檔8擋9檔1級(jí)1900222525502875320035253850417545002級(jí)2600300034003800420046005000540058003級(jí)3900430047005100550059006300670071004級(jí)5000550060006500700075008000850090005級(jí)5600640072008000880096001040011200120006級(jí)7800860094001020011000118001260013400142007級(jí)920010400116001280014000152001640017600188008級(jí)1100012500140001550017000185002000021500230009級(jí)138001560017400182002100022800246002640028200寬帶薪酬設(shè)計(jì)中重要相關(guān)術(shù)語acbdfeg政策線或薪酬線a:

某等級(jí)最大值b:

某等級(jí)最小值a-b:

帶寬/層寬c-d:

相鄰等級(jí)的重疊e,f,g:

某等級(jí)中位值薪酬幅寬代表了在該等級(jí)上，員工薪酬變動(dòng)的范圍公式：（該等級(jí)薪酬最高值－該等級(jí)最低值）/該等級(jí)最低值一般來說，薪酬等級(jí)越高的薪酬幅寬越大。因?yàn)檩^高等級(jí)的職位晉升難度加大，需要較大的薪酬變動(dòng)幅度來認(rèn)可員工的貢獻(xiàn)等級(jí)(相對(duì)崗位價(jià)值)相鄰兩個(gè)薪資等級(jí)的重疊情況。主要是由每一薪等基準(zhǔn)崗位之市場(chǎng)水平所決定的。重疊度從某種程度上能夠反映公司的薪資戰(zhàn)略及價(jià)值取向。一般說來，低等級(jí)之間重疊度較高，等級(jí)越高重疊度越低中位值級(jí)差：反映了等級(jí)遞進(jìn)的增加率。一般說來，低等級(jí)之間級(jí)差較小，等級(jí)越高級(jí)差越大；公式:(f-e)/e薪資(貨幣價(jià)值)等級(jí)(相對(duì)崗位價(jià)值)靈活的薪酬體系計(jì)提比例檔差薪酬區(qū)間固定、浮動(dòng)部分比例級(jí)差薪值寬帶薪酬通過以下六大調(diào)控工具來激勵(lì)和引導(dǎo)員工共同實(shí)現(xiàn)企業(yè)的戰(zhàn)略目標(biāo)薪酬矩陣圖將形象的解釋企業(yè)薪酬理念崗位差異能力差異績(jī)效差異市場(chǎng)差異薪酬政級(jí)別市場(chǎng)參照級(jí)差帶寬重疊度1檔2檔3檔4檔5檔6檔7檔績(jī)效比例人數(shù)1475P28%86%61%619,280707,750796,220884,690973,1601,061,6301,150,1004：611375P28%86%61%482,780551,750620,720689,690758,660827,620896,5905：631275P28%86%61%376,370430,130483,900537,670591,430645,200698,9705：511175P28%86%61%293,410335,320377,240419,150461,070502,980544,9005：521050P28%86%61%228,730261,410294,090326,760359,440392,120424,7906：49950P28%86%61%178,320203,790229,260254,740280,210305,690331,1606：498750P50P28%28%86%86%61%61%139,010108,370158,870123,850178,730139,330198,590154,820218,450170,300238,310185,780258,170201,2607：37：339650P28%86%61%84,48096,550108,620120,690132,760144,830156,9007：34525P28%86%61%65,86075,27084,68094,090103,500112,910