智 能 薪 酬 测 算 表 ( 计 时 工 资 )计 提 区 间 设 定序号月份基本信息当月上班天数计提工资测算序号说明工时时长时薪对应奖金备注姓名员工编号岗位底薪工时时薪提成奖金工资合计月度占比1大于等于0小时,则时薪为10元/小时010011王欢欢012543包装工2312001751017500295032.26%1大于等于180小时,则时薪为11元/小时180113021张丽012544包装工25120019511214530337536.91%2大于等于200小时,则时薪为12元/小时200125031王平012545包装工2212001621016200282030.84%3大于等于210小时,则时薪为13元/小时210138042冯丽雯012546包装工241200168.91016890288944.06%4大于等于240小时,则时薪为14元/小时2401410052张小杰012547包装工23.51200201.512241850366855.94%5大于等于250小时,则时薪为15元/小时2501515063区伟峰012548包装工26120021313276980404943.19%73王欢欢012543包装工231200265153975150532556.81%薪酬测算结果分析84张丽012544包装工251200268154020150537056.86%月份员工人数底薪合计工时合计提成合计奖金合计时薪均价环比94王平012545包装工22120021513279580407543.14%13360053255153017.19 -105冯丽雯012546包装工24120023313302980430931.17%222400370.441075017.70 2.98%115张小杰012547包装工23.5120022413291280419230.32%322400478674423019.61 10.78%125区伟峰012548包装工261200265153975150532538.51%422400483681523019.55 -0.29%136王欢欢012543包装工2512002951544251505775100.00%533600722991631019.15 -2.07%147张丽012544包装工221200215132795804075100.00%611200295442515019.58 2.23%158王平012545包装工24120023013299080427053.51%71120021527958018.95 -3.18%168冯丽雯012546包装工23.5120020512246050371046.49%822400435545013018.34 -3.21%179张小杰012547包装工26120021713282180410154.61%922400415499911018.09 -1.37%189王欢欢012543包装工23120019811217830340845.39%1022400409.54924.511018.16 0.34%1910张丽012544包装工251200199.5112194.5303424.546.06%1111200211.52749.58019.05 4.94%2010王平012545包装工22120021013273080401053.94%121120023530558018.45 -3.18%2111冯丽雯012546包装工23.51200211.5132749.5804029.5100.00%全年2 264004801.461495159018.65 -2212区伟峰012548包装工261200235133055804335100.00%