工资表.xlsx

工 资 表序号人数部门姓名应出勤天数实际出勤天数基本保底工资一天 工资计件总工资/总工时计件 工资应发 工资加班工时加班天数补贴项补贴 汇总请假工时请假天数扣款项扣款汇总实发 工资备注加班 工资餐费补贴工龄补贴其他请假工资社保水电费旷工其他11装配王XX30303200106.67计件 总工资5088.25088.210005088车间总和分摊工资22装配李XX30283200106.674803.264803.261203030477333装配张XX30303200106.67150005108.555108.551103503504759440总工时000005500000066073700000770单位 工时000008800000099020.35278200000流水线工资小计960015000.0115000.01000000350300038010069171后勤谢XX2828.55500196.4355000.598.2298.22003503505248管理后勤计时工资182后勤陈XX28275000178.57500000011791794821193000000000后勤工资小计1050001050098.2200098.22117935000052910069271包装潘XX282935001253500331640.63640.630004141车间计时工资28200000000包装工资小计35003500640.63000640.6300000004141311计件方XX28283000107.145500550003503505150保底计件工资322计件白XX28283000107.142500300000300033300000计件车间工资小计6000800085000000003500003508150391门卫李XX350003500003500固定工资40200000门卫工资小计35003500000000000003500总计3310023000.0141000.01738.85000738.8517910503000125935929