宽带薪酬设计工具.xls

宽带薪酬设计工具.xls

《宽带薪酬设计工具.xls》由会员分享，可在线阅读，更多相关《宽带薪酬设计工具.xls（80页珍藏版）》请在冰豆网上搜索。

薪酬体系设计方案1、2、3、4、5、6、7、8、9、岗位列表市场薪酬数据企业薪酬数据薪酬构成薪酬设计方案套档模型套档测算员工个体薪酬对比公司总体薪酬测算薪酬体系设计方案岗位列表部门岗位职级职位序列总经理18职能序列规划工程部总工程师16技术序列土建工程师9技术序列营销策划部营销策划总监15业务序列招商经理12业务序列人力行政部人力资源主管10职能序列行政专员4职能序列行业市场年度现金收入总额职位等级10%分位25%分位中位数75%分位90%分位12320129381391275120662336227059342364598160141733093315583989254036706368621343680546482635038296310138854292554161746279744011923565006263109877011144441402237583857353510306513441416490686809385684121120157870193933979414998391423391854192280701092618116333167274217775268216111080181355521965782557783154281212597715794723101530041237095113146923184041271485352835436247141713522144453190454144065130361519984224987337493648672160334216233069291154440619571655709544172718203392555178086714118344411831701439530260852078857498132119369723460608715123926183115405720431196536704840400108780513571972150288962537198762512776301596095层级基本收入:

变动收入总监层0.59:

0.41经理层0.68:

0.32主管层0.69:

0.31员工层0.74:

0.26XX公司员工薪酬数据岗位信息补贴（现金）编号姓名岗位名称月度基本薪酬年度交通补贴年度车辆补贴年度膳食补贴年度通讯补贴1张三总经理50,00024,0003,6006,0002李四总工程师25,00024,0003,6004,8003孙六土建工程师12,0002,4003,6002,4004张四营销策划总监25,00024,0003,6004,8005李五招商经理15,0002,4003,6002,4006王六人力资源主管12,0002,4003,6002,4007赵八行政专员2,5002,4003,6002,400年终奖年度固定现金收入年度现金总收入200,000633,600833,600120,000332,400452,40050,000152,400202,400110,000332,400442,40060,000188,400248,40035,000152,400187,400600038,40044400部门岗位职级职位序列lnlnslopeslopeinterceptintercept总经理18职能序列83360083360013.6335113.633510.1909150.19091510.1573910.15739规划工程部总工程师16技术序列45240045240013.0223213.02232土建工程师9技术序列20240020240012.21812.218营销策划部营销策划总监15业务序列44240044240012.9999712.99997招商经理12业务序列24840024840012.422812.4228人力行政部人力资源主管10职能序列18740018740012.14112.141行政专员4职能序列444004440010.7009910.70099职职级级expexp1131204.0831204.082237768.0637768.063345712.8345712.834455328.8355328.835566967.6266967.626681054.7181054.717798105.1198105.1188118742.2118742.299143720.4143720.410101739531739531111210545.1210545.11212254834.7254834.71313308440.9308440.91414373323.5373323.51515451854.6451854.61616546905.3546905.31717661950.5661950.51818801196.3801196.31919969733.3969733.3202011737231173723212114206241420624薪酬构成（设计）原有薪酬构成:

月薪+补贴+年终奖名称各项目含义年度现金总收入公司每年向在岗者提供的全部现金报酬，包括基本工资、绩效工资、年终奖金奖和各项现金补贴基本工资在岗者获得的基本收入,每月固定发放,属于固定收入的一部分补贴在岗者获得的现金福利待遇,如通讯补贴等,属于固定收入的一部分年终奖根据公司和个体业绩而年度发放的变动收入基本工资年度现金总收入固定收入补贴变动收入年终奖金公司每年向在岗者提供的全部现金报酬，包括基本工资、绩效工资、年终奖金奖和各项现金补贴年度现金总收入表1：

XX年XX地区房地产行业年度现金收入总额比较表5：

设计年度变动收入总额表2：

设计年度现金收入总额薪酬曲线表6：

设计月度固定现金收入总额表3：

设计年度现金收入总额表7：

设计月度变动现金收入总额表4：

设计年度固定现金收入总额表1：

XX年XX地区房地产行业年度现金收入总额比较职位等级10%分位25%分位中位数75%分位90%分位123201293813912751206623362270593423645981601417330933155839892540367063686213436805464826350382963101388542925541617462797440119235650062631098770111444414022375838573535103065134414164906868093856841211201578701939339794149983914233918541922807010926181163331672742177752682161110801813555219657825577831542812125977157947231015300412370951131469231840412714853528354362471417135221444531904541440651303615199842249873374936486721603342162330692911544406195716557095441727182033925551780867141183444118317014395302608520788574981321193697234606087151239261831154057123456789101112131415161718192021020000040000060000080000010000001200000140000016000001800000最小值（年度）散点设计薪酬水平薪酬回归年度现金收入总额回归（设计中位值）市场90分位市场75分位市场50分位市场25分位20431196536704840400108780513571972150288962537198762512776301596095表2：

序列设计年度现金收入总额薪酬曲线等级市场10分位市场25分位市场50分位市场75分位市场90分位选取分位各级选取分位值LN斜率截距年度现金收入总额回归（设计中位值）123201293813912751206623367551,20610.840.1610.6851206227059342364598160141733097560,14111.0060141331558398925403670636862137570,63611.17706364368054648263503829631013887582,96311.33829635429255416174627974401192357597,44011.4997440650062631098770111444414022375114,44411.651144437583857353510306513441416490675134,41411.811344148680938568412112015787019393375157,87011.971578709794149983914233918541922807075185,41912.13185419109261811633316727421777526821675217,77512.292177751110801813555219657825577831542875255,77812.452557781212597715794723101530041237095175300,41212.613004121314692318404127148535283543624775352,83512.773528351417135221444531904541440651303675414,40612.934144061519984224987337493648672160334275486,72113.104867211623306929115444061957165570954475571,65513.265716551727182033925551780867141183444175671,41113.426714111831701439530260852078857498132175788,57413.5878857519369723460608715123926183115405775926,18313.74926184123456789101112131415161718192021020000040000060000080000010000001200000140000016000001800000最小值（年度）散点设计薪酬水平薪酬回归年度现金收入总额回归（设计中位值）市场90分位市场75分位市场50分位市场25分位2043119653670484040010878051357197751,087,80513.9010878062150288962537198762512776301596095751,277,63014.061277632表3：

X序列设计年度现金收入总额等级第一档第二档第三档第四档第五档第六档第七档档差同级最大与最小值差上下级中值差固定收入占比140965443784779251206546205803361447341420482893680%2481135212356132601416415168160721704009240571049580%3565096121865927706367534580055847644709282551232680%4663707190177432829638849394024995555531331851447780%5779528444890944974401039361104321169286496389761700480%69155599184106814