（本科）項(xiàng)目七 應(yīng)用Excel管理工資薪金

1月份工資統(tǒng)計(jì)表,,,,,,,,,,,,,,

編號(hào),姓名,所屬部門,基本工資,績(jī)效,,,扣款,應(yīng)發(fā)工資,保險(xiǎn)扣款,,,,應(yīng)交個(gè)人所得稅,實(shí)發(fā)工資

,,,,工齡工資,績(jī)效獎(jiǎng),滿勤獎(jiǎng),,,養(yǎng)老保險(xiǎn),醫(yī)療保險(xiǎn),住房公積金,保險(xiǎn)扣除合計(jì),,

001,李剛,銷售部,"6,000.00",0.00,"6,924.80",0.00,280.00,"12,644.80","1,011.58",252.90,"1,264.48","2,528.96",63.48,"10,052.36"

002,陳明遠(yuǎn),財(cái)務(wù)部,"7,600.00",100.00,0.00,300.00,0.00,"8,000.00",640.00,160.00,800.00,"1,600.00",12.00,"6,388.00"

003,蘇運(yùn)成,銷售部,"5,500.00",0.00,"8,152.00",300.00,0.00,"13,952.00","1,116.16",279.04,"1,395.20","2,790.40",184.85,"10,976.75"

004,周洋洋,銷售部,"6,500.00",200.00,"8,440.00",300.00,0.00,"15,440.00","1,235.20",308.80,"1,544.00","3,088.00",190.56,"12,161.44"

005,林瑞,工程部,"4,000.00",200.00,0.00,0.00,0.00,"4,200.00",336.00,84.00,420.00,840.00,0.00,"3,360.00"

006,鄒長(zhǎng)陽(yáng),行政部,"9,500.00",400.00,0.00,300.00,0.00,"10,200.00",816.00,204.00,"1,020.00","2,040.00",64.80,"8,095.20"

007,張景源,銷售部,"2,500.00",100.00,"6,606.40",0.00,20.00,"9,186.40",734.91,183.73,918.64,"1,837.28",70.47,"7,278.65"

008,蘇敏瑞,財(cái)務(wù)部,"9,000.00",400.00,0.00,0.00,20.00,"9,380.00",750.40,187.60,938.00,"1,876.00",0.00,"7,504.00"

009,丁平,銷售部,"8,000.00",0.00,"5,168.00",0.00,40.00,"13,128.00","1,050.24",262.56,"1,312.80","2,625.60",135.07,"10,367.33"

010,何艷紅,銷售部,"5,000.00",400.00,"5,836.80",300.00,40.00,"11,496.80",919.74,229.94,"1,149.68","2,299.36",95.92,"9,101.52"

011,胡歌,行政部,"9,000.00",400.00,0.00,300.00,0.00,"9,700.00",776.00,194.00,970.00,"1,940.00",52.80,"7,707.20"

012,何江成,銷售部,"4,500.00",0.00,"1,600.00",0.00,90.00,"6,010.00",480.80,120.20,601.00,"1,202.00",0.00,"4,808.00"

013,李蘇明,工程部,"7,000.00",300.00,0.00,0.00,60.00,"7,240.00",579.20,144.80,724.00,"1,448.00",0.00,"5,792.00"

014,余欣燕,銷售部,"1,200.00",300.00,"1,345.00",300.00,0.00,"3,145.00",251.60,62.90,314.50,629.00,0.00,"2,516.00"

015,張杰,工程部,"8,000.00",400.00,0.00,300.00,20.00,"8,680.00",694.40,173.60,868.00,"1,736.00",0.00,"6,944.00"

016,王明杰,銷售部,"6,000.00",300.00,"2,031.00",0.00,400.00,"7,931.00",634.48,158.62,793.10,"1,586.20",10.34,"6,334.46"

017,李萍萍,銷售部,"8,000.00",0.00,"2,300.00",0.00,30.00,"10,270.00",821.60,205.40,"1,027.00","2,054.00",66.48,"8,149.52"

018,張麗麗,財(cái)務(wù)部,"7,000.00",0.00,0.00,300.00,0.00,"7,300.00",584.00,146.00,730.00,"1,460.00",0.00,"5,840.00"

019,楊瑞瑞,工程部,"8,700.00",400.00,0.00,300.00,0.00,"9,400.00",752.00,188.00,940.00,"1,880.00",45.60,"7,474.40"

020,肖陽(yáng),銷售部,"5,000.00",400.00,"1,293.50",300.00,0.00,"6,993.50",559.48,139.87,699.35,"1,398.70",0.00,"5,594.80"

021,胡明霞,行政部,"20,000.00",400.00,0.00,300