第2題 工資核算表 參考效果

工號,姓名,部門,員工類別,基礎工資,崗位工資,入職日期,工齡工資,津貼福利,獎金,缺勤扣款,應發(fā)工資,五險一金,代繳個稅,實發(fā)工資

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,簡知秋,安監(jiān)部,普通員工,3850,1000,2020/3/1,50,200,,,5100,765.00,0.00,5100.00

GS032,周趙榮,安監(jiān)部,普通員工,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