【薪酬福利管理工具】薪酬等级设计及工资标准计算工具（更新）1.xlsx

人力资源管理工具薪酬福利薪酬等级设计及工资标准计算工具（可任意设置参数）说明：本工具可以用来灵活设计薪酬等级并进行工资标准计算，包括各薪酬等级薪点值设置及计算、月薪计算、年薪计算。内含自动函数公式，只需要在空白处及黄色标注处填入数据即可，其他颜色标注的数据为全自动生成。注：1.工具中标准值是以“等级六”第1序列中数值为基准的，序差、级差比例目前设置的增长梯度为5%（设置了自动计算，另外序1与序2之间比例差是20%）；2.级差是以等级6为固定基准值，序差是依次递增式增长，当然企业也可根据实际情况调整序差、级差比例；3.可以任意灵活修改标准参数值（黄色标注处），得到你想要的薪酬等级及工资标准。表一：各岗位对应薪酬等级的薪点值等级/序序差比例100%120%125%130%135%140%级差比例序1序2序3序4序5序6等级10120%360.00432.00540.00702.00947.701326.78等级9115%345.00414.00517.50672.75908.211271.50等级8110%330.00396.00495.00643.50868.731216.22等级7105%315.00378.00472.50614.25829.241160.93等级6100%300.00360.00450.00585.00789.751105.65等级595%285.00342.00427.50555.75750.261050.37等级490%270.00324.00405.00526.50710.78995.09等级385%255.00306.00382.50497.25671.29939.80等级280%240.00288.00360.00468.00631.80884.52等级175%225.00270.00337.50438.75592.31829.24表二：各岗位对应的月薪薪点值工资标准￥6.50即：6.5元/点/月等级/序级差比例序1序2序3序4序5序6等级10120%2340.002808.003510.004563.006160.058624.07等级9115%2242.502691.003363.754372.885903.388264.73等级8110%2145.002574.003217.504182.755646.717905.40等级7105%2047.502457.003071.253992.635390.047546.06等级6100%1950.002340.002925.003802.505133.387186.73等级595%1852.502223.002778.753612.384876.716827.39等级490%1755.002106.002632.503422.254620.046468.05等级385%1657.501989.002486.253232.134363.376108.72等级280%1560.001872.002340.003042.004106.705749.38等级175%1462.501755.002193.752851.883850.035390.04表三：各岗位对应的年薪薪点值工资标准￥6.50全年月数12等级/序级差比例序1序2序3序4序5序6等级10120%28080.0033696.0042120.0054756.0073920.60103488.84等级9115%26910.0032292.0040365.0052474.5070840.5899176.81等级8110%25740.0030888.0038610.0050193.0067760.5594864.77等级7105%24570.0029484.0036855.0047911.5064680.5390552.74等级6100%23400.0028080.0035100.0045630.0061600.5086240.70等级595%22230.0026676.0033345.0043348.5058520.4881928.67等级490%21060.0025272.0031590.0041067.0055440.4577616.63等级385%19890.0023868.0029835.0038785.5052360.4373304.60等级280%18720.0022464.0028080.0036504.0049280.4068992.56等级175%17550.0021060.0026325.0034222.5046200.3864680.53版权所有：北京未名潮管理顾问有限公司145%150%155%160%序7序8序9序101923.832885.754472.917156.651843.672765.514286.546858.461763.512645.274100.166560.261683.352525.033913.796262.071603.192404.793727.425963.881523.032284.553541.055665.681442.872164.313354.685367.491362.712044.073168.315069.291282.551923.832981.944771.101202.391803.592795.574472.91序7序8序9序1012504.9018757.3529073.9046518.2311983.8617975.8027862.4844579.9711462.8317194.2426651.0742641.7110941.7916412.6825439.6640703.4510420.7515631.1324228.2538765.199899.7114849.5723016.8336826.939378.6814068.0121805.4234888.688857.6413286.4620594.0132950.42薪酬等级设计及工资标准计算工具（可任意设置参数）说明：本工具可以用来灵活设计薪酬等级并进行工资标准计算，包括各薪酬等级薪点值设置及计算、月薪计算、年薪计算。内含自动函数公式，只需要在空白处及黄色标注处填入数据即可，其他颜色标注的数据为全自动生成。注：1.工具中标准值是以“等级六”第1序列中数值为基准的，序差、级差比例目前设置的增长梯度为5%（设置了自动计算，另外序1与序2之间比例差是20%）；2.级差是以等级6为固定基准值，序差是依次递增式增长，当然企业也可根据实际情况调整序差、级差比例；3.可以任意灵活修改标准参数值（黄色标注处），得到你想要的薪酬等级及工资标准。8336.6012504.9019382.6031012.167815.5611723.3518171.1829073.90序7序8序9序10150058.82225088.23348886.75558218.80143806.37215709.55334349.80534959.69137553.92206330.87319812.86511700.57131301.47196952.20305275.91488441.45125049.02187573.52290738.96465182.34118796.56178194.85276202.01441923.22112544.11168816.17261665.06418664.10106291.66159437.49247128.12395404.99100039.21150058.82232591.17372145.8793786.76140680.14218054.22348886.75