智能薪酬测算表（计提工资）.xlsx

智 能 薪 酬 测 算 表 （ 计 提 工 资 ）计 提 区 间 设 定序号月份基本信息当月上班天数计提工资测算序号说明数量提成对应奖金备注姓名员工编号岗位底薪业绩提成提成奖金工资合计备注1大于等于0元，则提成点为0.05%00.05%5011王欢欢012543业务23150091871.00%91.871001691.87 1大于等于8000元，则提成点为1%80001.00%10021张丽012544业务251500159413.00%478.232502228.23 2大于等于12000元，则提成点为2%120002.00%20031王平012545业务221500189783.00%569.342502319.34 3大于等于15000元，则提成点为3%150003.00%25042冯丽雯012546业务241500199803.00%599.42502349.40 4大于等于20000元，则提成点为5%200005.00%30052张小杰012547业务23.51500119331.00%119.331001719.33 5大于等于30000元，则提成点为5.5%300005.50%35063区伟峰012548业务26150066010.05%3.3005501553.30 73王欢欢012543业务23150081641.00%81.641001681.64 薪酬测算结果分析84张丽012544业务25150090861.00%90.861001690.86 月份员工人数底薪合计业绩合计提成合计奖金合计提成单价环比94王平012545业务22150091871.00%91.871001691.87 134500441061139.446003.94%-105冯丽雯012546业务241500100671.00%100.671001700.67 22300031913718.733503.35%-15.08%115张小杰012547业务23.5150084341.00%84.341001684.34 3230001476584.94051501.59%-52.49%125区伟峰012548业务26150084711.00%84.711001684.71 42300018273182.732002.09%31.63%136王欢欢012543业务25150092541.00%92.541001692.54 53450026972269.723002.11%0.85%147张丽012544业务221500200415.00%1002.053002802.05 611500925492.541002.08%-1.50%157王平012545业务241500207805.00%10393002839.00 723000408212041.056006.47%210.96%168冯丽雯012546业务23.51500173223.00%519.662502269.66 82300026509611.533503.63%-43.94%178张小杰012547业务26150091871.00%91.871001691.87 91150035821.791501.45%-60.14%189王欢欢012543业务23150035820.05%1.791501551.79 102300026576612.23503.62%150.41%1910张丽012544业务251500173223.00%519.662502269.66 1111500200411002.053006.50%79.45%2010王欢欢012543业务25150092541.00%92.541001692.54 12115002078010393006.44%-0.82%2111张丽012544业务221500200415.00%1002.053002802.05 全年2 330002835927795.72236503.61%-2212王平012545业务241500207805.00%10393002839.00