智 能 薪 酬 测 算计 提 区 间 设 定序号112345说明大于等于0元，则提成点为0.05%大于等于8000元，则提成点为1%大于等于12000元，则提成点为2%大于等于15000元，则提成点为3%大于等于20000元，则提成点为5%大于等于30000元，则提成点为5.5%数量0800012000150002000030000提成0.05%1.00%2.00%3.00%5.00%5.50%对应奖金50100200250300350备注序号12345678月份11122334455567788910101112薪酬测算结果分析月份员工人数底薪合计业绩合计提成合计奖金合计提成单价123456789101112全年32223122121124500300030003000450015003000300015003000150015003300044106319131476518273269729254408212650935822657620041207801139.44718.7384.9405182.73269.7292.542041.05611.531.791612.21002.0510396003501502003001006003505035030030036503.94%3.35%1.59%2.09%2.11%2.08%6.47%3.63%1.45%3.62%6.50%6.44%3.61%环比--15.08%-52.49%31.63%0.85%-1.50%210.96%-43.94%-60.14%150.41%79.45%-0.82%-910111213141516171819202122232425262728293031323334352835927795.72236373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145测 算 表 （ 计 提 工 资 ）基本信息姓名王欢欢张丽王平冯丽雯张小杰区伟峰王欢欢张丽王平冯丽雯张小杰区伟峰王欢欢张丽王平冯丽雯张小杰王欢欢张丽王欢欢张丽王平员工编号012543012544012545012546012547012548012543012544012545012546012547012548012543012544012545012546012547012543012544012543012544012545岗位业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务业务当月上班天数2325222423.5262325222423.52625222423.5262325252224计提工资测算底薪1500150015001500150015001500150015001500150015001500150015001500150015001500150015001500业绩918715941189781998011933660181649086918710067843484719254200412078017322918735821732292542004120780提成1.00%3.00%3.00%3.00%1.00%0.05%1.00%1.00%1.00%1.00%1.00%1.00%1.00%5.00%3.00%1.00%0.05%3.00%1.00%5.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%提成91.87478.23569.34599.4119.333.300581.6490.8691.87100.6784.3484.7192.541039519.6691.871.791519.6692.5410390000000000000奖金10025025025010050100100100100100100100300300250100502501003003000000000000000工资合计1691.872228.232319.342349.401719.331553.301681.641690.861691.871700.671684.341684.711692.542802.052839.002269.661691.871551.792269.661692.542802.052839.000.000.000.000.000.000.000.000.000.000.000.000.000.005.00%1002.055.00%1002.050.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%00000000000000000000000000000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00备注
