第2题 工资核算表 参考效果

工号,姓名,部门,员工类别,基础工资,岗位工资,入职日期,工龄工资,津贴福利,奖金,缺勤扣款,应发工资,五险一金,代缴个税,实发工资

GS033,朵雷,财务部,经理人员,5800,1800,2012/3/1,450,300,,60,8290,1243.50,61.40,8228.61

GS029,王颖,仓储部,经理人员,3850,1800,2008/12/1,600,200,,25,6425,963.75,13.84,6411.16

GS014,庄秋言,质检部,经理人员,3850,1800,2000/4/3,1050,200,700,,7600,1140.00,43.80,7556.20

GS011,白如雪,总经办,经理人员,6800,1800,2000/2/1,1050,200,,,9850,1477.50,127.25,9722.75

GS002,乔昭宁,总经办,经理人员,6800,1800,1999/4/3,1100,100,,25,9775,1466.25,120.88,9654.13

GS006,连敏原,仓储部,管理人员,3850,1500,2008/12/1,600,200,,,6150,922.50,6.83,6143.18

GS039,杨增华,仓储部,管理人员,3850,1500,2007/4/3,700,400,100,,6550,982.50,17.03,6532.98

GS013,柳千佑,生产部,管理人员,3850,1500,2009/5/12,600,100,,,6050,907.50,4.28,6045.73

GS010,明与雁,质检部,管理人员,3850,1500,2010/2/1,550,200,,,6100,915.00,5.55,6094.45

GS001,简知秋,安监部,普通员工,3850,1000,2020/3/1,50,200,,,5100,765.00,0.00,5100.00

GS032,周赵荣,安监部,普通员工,3850,1000,2012/3/1,450,200,,,5500,825.00,0.00,5500.00

GS007,辛涵若,财务部,普通员工,5800,1000,2012/3/1,450,300,,40,7510,1126.50,41.51,7468.50

GS009,尤沙秀,仓储部,普通员工,3850,1000,2009/5/12,600,400,,,5850,877.50,0.00,5850.00

GS003,乔沐枫,仓储部,普通员工,3850,1000,2007/4/3,700,400,100,,6050,907.50,4.28,6045.73

GS042,汪云福,仓储部,普通员工,3850,1000,2009/5/12,600,400,,,5850,877.50,0.00,5850.00

GS012,杜郎清,生产部,普通员工,3850,1000,2013/2/28,400,200,,50,5400,810.00,0.00,5400.00

GS046,赵德所,生产部,普通员工,3850,1000,2013/2/28,400,200,,30,5420,813.00,0.00,5420.00

GS004,柳笙絮,销售部,普通员工,5800,1000,2009/5/12,600,200,,,7600,1140.00,43.80,7556.20

G