最佳薪酬分配方案模型zcf_xls

1、最佳薪酬分配方案模型月工資扣除數所得額稅率 速算扣除數稅額年月稅總額年終獎/12個月稅率扣除數稅額總稅負3,5003,50003%00018,0001,5003%05405403,5503,500503%021817,4001,4503%05225403,6003,5001003%033616,8001,4003%05045403,6503,5001503%055416,2001,3503%04865403,7003,5002003%067215,6001,3003%04685403,7503,5002503%089015,0001,2503%04505403,8003,5003003%091

2、0814,4001,2003%04325403,8503,5003503%01112613,8001,1503%04145403,9003,5004003%01214413,2001,1003%03965403,9503,5004503%01416212,6001,0503%03785404,0003,5005003%01518012,0001,0003%03605404,0503,5005503%01719811,4009503%03425404,1003,5006003%01821610,8009003%03245404,1503,5006503%02023410,2008503%0306

3、5404,2003,5007003%0212529,6008003%02885404,2503,5007503%0232709,0007503%02705404,3003,5008003%0242888,4007003%02525404,3503,5008503%0263067,8006503%02345404,4003,5009003%0273247,2006003%02165404,4503,5009503%0293426,6005503%01985404,5003,5001,0003%0303606,0005003%01805404,5503,5001,0503%0323785,4004

4、503%01625404,6003,5001,1003%0333964,8004003%01445404,6503,5001,1503%0354144,2003503%01265404,7003,5001,2003%0364323,6003003%01085404,7503,5001,2503%0384503,0002503%0905404,8003,5001,3003%0394682,4002003%0725404,8503,5001,3503%0414861,8001503%0545404,9003,5001,4003%0425041,2001003%0365404,9503,5001,4

5、503%044522600503%0185405,0003,5001,5003%045540003%005405,0503,5001,55010%10550600003%006005,1003,5001,60010%10555660003%006605,1503,5001,65010%10560720003%007205,2003,5001,70010%10565780003%007805,2503,5001,75010%10570840003%008405,3003,5001,80010%10575900003%009005,3503,5001,85010%10580960003%00960

6、5,4003,5001,90010%105851,020003%001,0205,4503,5001,95010%105901,080003%001,0805,5003,5002,00010%105951,140003%001,1405,5503,5002,05010%1051001,200003%001,2005,6003,5002,10010%1051051,260003%001,2605,6503,5002,15010%1051101,320003%001,3205,7003,5002,20010%1051151,380003%001,3805,7503,5002,25010%10512

7、01,440003%001,4405,8003,5002,30010%1051251,500003%001,5005,8503,5002,35010%1051301,560003%001,5605,9003,5002,40010%1051351,620003%001,6205,9503,5002,45010%1051401,680003%001,6806,0003,5002,50010%1051451,740003%001,7406,0503,5002,55010%1051501,800003%001,8006,1003,5002,60010%1051551,860003%001,8606,1

8、503,5002,65010%1051601,920003%001,9206,2003,5002,70010%1051651,980003%001,9806,2503,5002,75010%1051702,040003%002,0406,3003,5002,80010%1051752,100003%002,1006,3503,5002,85010%1051802,160003%002,1606,4003,5002,90010%1051852,220003%002,2206,4503,5002,95010%1051902,280003%002,2806,5003,5003,00010%10519

9、52,340003%002,3406,5503,5003,05010%1052002,400003%002,4006,6003,5003,10010%1052052,460003%002,4606,6503,5003,15010%1052102,520003%002,5206,7003,5003,20010%1052152,580003%002,5806,7503,5003,25010%1052202,640003%002,6406,8003,5003,30010%1052252,700003%002,7006,8503,5003,35010%1052302,760003%002,7606,9

10、003,5003,40010%1052352,820003%002,8206,9503,5003,45010%1052402,880003%002,8807,0003,5003,50010%1052452,940003%002,9407,0503,5003,55010%1052503,000003%003,0007,1003,5003,60010%1052553,060003%003,0607,1503,5003,65010%1052603,120003%003,1207,2003,5003,70010%1052653,180003%003,1807,2503,5003,75010%10527

11、03,240003%003,2407,3003,5003,80010%1052753,300003%003,3007,3503,5003,85010%1052803,360003%003,3607,4003,5003,90010%1052853,420003%003,4207,4503,5003,95010%1052903,480003%003,4807,5003,5004,00010%1052953,540003%003,5407,5503,5004,05010%1053003,600003%003,6007,6003,5004,10010%1053053,660003%003,6607,6

12、503,5004,15010%1053103,720003%003,7207,7003,5004,20010%1053153,780003%003,7807,7503,5004,25010%1053203,840003%003,8407,8003,5004,30010%1053253,900003%003,9007,8503,5004,35010%1053303,960003%003,9607,9003,5004,40010%1053354,020003%004,0207,9503,5004,45010%1053404,080003%004,0808,0003,5004,50010%10534

13、54,140003%004,1408,0503,5004,55020%5553554,260003%004,2608,1003,5004,60020%5553654,380003%004,3808,1503,5004,65020%5553754,500003%004,5008,2003,5004,70020%5553854,620003%004,6208,2503,5004,75020%5553954,740003%004,7408,3003,5004,80020%5554054,860003%004,8608,3503,5004,85020%5554154,980003%004,9808,4

14、003,5004,90020%5554255,100003%005,1008,4503,5004,95020%5554355,220003%005,2208,5003,5005,00020%5554455,340003%005,3408,5503,5005,05020%5554555,460003%005,4608,6003,5005,10020%5554655,580003%005,5808,6503,5005,15020%5554755,700003%005,7008,7003,5005,20020%5554855,820003%005,8208,7503,5005,25020%55549

15、55,940003%005,9408,8003,5005,30020%5555056,060003%006,0608,8503,5005,35020%5555156,180003%006,1808,9003,5005,40020%5555256,300003%006,3008,9503,5005,45020%5555356,420003%006,4209,0003,5005,50020%5555456,540003%006,5409,0503,5005,55020%5555556,660003%006,6609,1003,5005,60020%5555656,780003%006,7809,1

16、503,5005,65020%5555756,900003%006,9009,2003,5005,70020%5555857,020003%007,0209,2503,5005,75020%5555957,140003%007,1409,3003,5005,80020%5556057,260003%007,2609,3503,5005,85020%5556157,380003%007,3809,4003,5005,90020%5556257,500003%007,5009,4503,5005,95020%5556357,620003%007,6209,5003,5006,00020%55564

17、57,740003%007,7409,5503,5006,05020%5556557,860003%007,8609,6003,5006,10020%5556657,980003%007,9809,6503,5006,15020%5556758,100003%008,1009,7003,5006,20020%5556858,220003%008,2209,7503,5006,25020%5556958,340003%008,3409,8003,5006,30020%5557058,460003%008,4609,8503,5006,35020%5557158,580003%008,5809,9

18、003,5006,40020%5557258,700003%008,7009,9503,5006,45020%5557358,820003%008,82010,0003,5006,50020%5557458,940003%008,94010,0503,5006,55020%5557559,060003%009,06010,1003,5006,60020%5557659,180003%009,18010,1503,5006,65020%5557759,300003%009,30010,2003,5006,70020%5557859,420003%009,42010,2503,5006,75020

19、%5557959,540003%009,54010,3003,5006,80020%5558059,660003%009,66010,3503,5006,85020%5558159,780003%009,78010,4003,5006,90020%5558259,900003%009,90010,4503,5006,95020%55583510,020003%0010,02010,5003,5007,00020%55584510,140003%0010,14010,5503,5007,05020%55585510,260003%0010,26010,6003,5007,10020%555865

20、10,380003%0010,38010,6503,5007,15020%55587510,500003%0010,50010,7003,5007,20020%55588510,620003%0010,62010,7503,5007,25020%55589510,740003%0010,74010,8003,5007,30020%55590510,860003%0010,86010,8503,5007,35020%55591510,980003%0010,98010,9003,5007,40020%55592511,100003%0011,10010,9503,5007,45020%55593

21、511,220003%0011,22011,0003,5007,50020%55594511,340003%0011,34011,0503,5007,55020%55595511,460003%0011,46011,1003,5007,60020%55596511,580003%0011,58011,1503,5007,65020%55597511,700003%0011,70011,2003,5007,70020%55598511,820003%0011,82011,2503,5007,75020%55599511,940003%0011,94011,3003,5007,80020%5551

22、,00512,060003%0012,06011,3503,5007,85020%5551,01512,180003%0012,18011,4003,5007,90020%5551,02512,300003%0012,30011,4503,5007,95020%5551,03512,420003%0012,42011,5003,5008,00020%5551,04512,540003%0012,54011,5503,5008,05020%5551,05512,660003%0012,66011,6003,5008,10020%5551,06512,780003%0012,78011,6503,

23、5008,15020%5551,07512,900003%0012,90011,7003,5008,20020%5551,08513,020003%0013,02011,7503,5008,25020%5551,09513,140003%0013,14011,8003,5008,30020%5551,10513,260003%0013,26011,8503,5008,35020%5551,11513,380003%0013,38011,9003,5008,40020%5551,12513,500003%0013,50011,9503,5008,45020%5551,13513,620003%0

24、013,62012,0003,5008,50020%5551,14513,740003%0013,74012,0503,5008,55020%5551,15513,860003%0013,86012,1003,5008,60020%5551,16513,980003%0013,98012,1503,5008,65020%5551,17514,100003%0014,10012,2003,5008,70020%5551,18514,220003%0014,22012,2503,5008,75020%5551,19514,340003%0014,34012,3003,5008,80020%5551

25、,20514,460003%0014,46012,3503,5008,85020%5551,21514,580003%0014,58012,4003,5008,90020%5551,22514,700003%0014,70012,4503,5008,95020%5551,23514,820003%0014,82012,5003,5009,00020%5551,24514,940003%0014,94012,5503,5009,05025%1,0051,25815,090003%0015,09012,6003,5009,10025%1,0051,27015,240003%0015,24012,6

26、503,5009,15025%1,0051,28315,390003%0015,39012,7003,5009,20025%1,0051,29515,540003%0015,54012,7503,5009,25025%1,0051,30815,690003%0015,69012,8003,5009,30025%1,0051,32015,840003%0015,84012,8503,5009,35025%1,0051,33315,990003%0015,99012,9003,5009,40025%1,0051,34516,140003%0016,14012,9503,5009,45025%1,0

27、051,35816,290003%0016,29013,0003,5009,50025%1,0051,37016,440003%0016,44013,0503,5009,55025%1,0051,38316,590003%0016,59013,1003,5009,60025%1,0051,39516,740003%0016,74013,1503,5009,65025%1,0051,40816,890003%0016,89013,2003,5009,70025%1,0051,42017,040003%0017,04013,2503,5009,75025%1,0051,43317,190003%0

28、017,19013,3003,5009,80025%1,0051,44517,340003%0017,34013,3503,5009,85025%1,0051,45817,490003%0017,49013,4003,5009,90025%1,0051,47017,640003%0017,64013,4503,5009,95025%1,0051,48317,790003%0017,79013,5003,50010,00025%1,0051,49517,940003%0017,94013,5503,50010,05025%1,0051,50818,090003%0018,09013,6003,5

29、0010,10025%1,0051,52018,240003%0018,24013,6503,50010,15025%1,0051,53318,390003%0018,39013,7003,50010,20025%1,0051,54518,540003%0018,54013,7503,50010,25025%1,0051,55818,690003%0018,69013,8003,50010,30025%1,0051,57018,840003%0018,84013,8503,50010,35025%1,0051,58318,990003%0018,99013,9003,50010,40025%1

30、,0051,59519,140003%0019,14013,9503,50010,45025%1,0051,60819,290003%0019,29014,0003,50010,50025%1,0051,62019,440003%0019,44014,0503,50010,55025%1,0051,63319,590003%0019,59014,1003,50010,60025%1,0051,64519,740003%0019,74014,1503,50010,65025%1,0051,65819,890003%0019,89014,2003,50010,70025%1,0051,67020,

31、040003%0020,04014,2503,50010,75025%1,0051,68320,190003%0020,19014,3003,50010,80025%1,0051,69520,340003%0020,34014,3503,50010,85025%1,0051,70820,490003%0020,49014,4003,50010,90025%1,0051,72020,640003%0020,64014,4503,50010,95025%1,0051,73320,790003%0020,79014,5003,50011,00025%1,0051,74520,940003%0020,

32、94014,5503,50011,05025%1,0051,75821,090003%0021,09014,6003,50011,10025%1,0051,77021,240003%0021,24014,6503,50011,15025%1,0051,78321,390003%0021,39014,7003,50011,20025%1,0051,79521,540003%0021,54014,7503,50011,25025%1,0051,80821,690003%0021,69014,8003,50011,30025%1,0051,82021,840003%0021,84014,8503,5

33、0011,35025%1,0051,83321,990003%0021,99014,9003,50011,40025%1,0051,84522,140003%0022,14014,9503,50011,45025%1,0051,85822,290003%0022,29015,0003,50011,50025%1,0051,87022,440003%0022,44015,0503,50011,55025%1,0051,88322,590003%0022,59015,1003,50011,60025%1,0051,89522,740003%0022,74015,1503,50011,65025%1

34、,0051,90822,890003%0022,89015,2003,50011,70025%1,0051,92023,040003%0023,04015,2503,50011,75025%1,0051,93323,190003%0023,19015,3003,50011,80025%1,0051,94523,340003%0023,34015,3503,50011,85025%1,0051,95823,490003%0023,49015,4003,50011,90025%1,0051,97023,640003%0023,64015,4503,50011,95025%1,0051,98323,

35、790003%0023,79015,5003,50012,00025%1,0051,99523,940003%0023,94015,5503,50012,05025%1,0052,00824,090003%0024,09015,6003,50012,10025%1,0052,02024,240003%0024,24015,6503,50012,15025%1,0052,03324,390003%0024,39015,7003,50012,20025%1,0052,04524,540003%0024,54015,7503,50012,25025%1,0052,05824,690003%0024,

36、69015,8003,50012,30025%1,0052,07024,840003%0024,84015,8503,50012,35025%1,0052,08324,990003%0024,99015,9003,50012,40025%1,0052,09525,140003%0025,14015,9503,50012,45025%1,0052,10825,290003%0025,29016,0003,50012,50025%1,0052,12025,440003%0025,44016,0503,50012,55025%1,0052,13325,590003%0025,59016,1003,5

37、0012,60025%1,0052,14525,740003%0025,74016,1503,50012,65025%1,0052,15825,890003%0025,89016,2003,50012,70025%1,0052,17026,040003%0026,04016,2503,50012,75025%1,0052,18326,190003%0026,19016,3003,50012,80025%1,0052,19526,340003%0026,34016,3503,50012,85025%1,0052,20826,490003%0026,49016,4003,50012,90025%1

38、,0052,22026,640003%0026,64016,4503,50012,95025%1,0052,23326,790003%0026,79016,5003,50013,00025%1,0052,24526,940003%0026,94016,5503,50013,05025%1,0052,25827,090003%0027,09016,6003,50013,10025%1,0052,27027,240003%0027,24016,6503,50013,15025%1,0052,28327,390003%0027,39016,7003,50013,20025%1,0052,29527,

39、540003%0027,54016,7503,50013,25025%1,0052,30827,690003%0027,69016,8003,50013,30025%1,0052,32027,840003%0027,84016,8503,50013,35025%1,0052,33327,990003%0027,99016,9003,50013,40025%1,0052,34528,140003%0028,14016,9503,50013,45025%1,0052,35828,290003%0028,29017,0003,50013,50025%1,0052,37028,440003%0028,

40、44017,0503,50013,55025%1,0052,38328,590003%0028,59017,1003,50013,60025%1,0052,39528,740003%0028,74017,1503,50013,65025%1,0052,40828,890003%0028,89017,2003,50013,70025%1,0052,42029,040003%0029,04017,2503,50013,75025%1,0052,43329,190003%0029,19017,3003,50013,80025%1,0052,44529,340003%0029,34017,3503,5

41、0013,85025%1,0052,45829,490003%0029,49017,4003,50013,90025%1,0052,47029,640003%0029,64017,4503,50013,95025%1,0052,48329,790003%0029,79017,5003,50014,00025%1,0052,49529,940003%0029,94017,5503,50014,05025%1,0052,50830,090003%0030,09017,6003,50014,10025%1,0052,52030,240003%0030,24017,6503,50014,15025%1

42、,0052,53330,390003%0030,39017,7003,50014,20025%1,0052,54530,540003%0030,54017,7503,50014,25025%1,0052,55830,690003%0030,69017,8003,50014,30025%1,0052,57030,840003%0030,84017,8503,50014,35025%1,0052,58330,990003%0030,99017,9003,50014,40025%1,0052,59531,140003%0031,14017,9503,50014,45025%1,0052,60831,

43、290003%0031,29018,0003,50014,50025%1,0052,62031,440003%0031,44018,0503,50014,55025%1,0052,63331,590003%0031,59018,1003,50014,60025%1,0052,64531,740003%0031,74018,1503,50014,65025%1,0052,65831,890003%0031,89018,2003,50014,70025%1,0052,67032,040003%0032,04018,2503,50014,75025%1,0052,68332,190003%0032,

44、19018,3003,50014,80025%1,0052,69532,340003%0032,34018,3503,50014,85025%1,0052,70832,490003%0032,49018,4003,50014,90025%1,0052,72032,640003%0032,64018,4503,50014,95025%1,0052,73332,790003%0032,79018,5003,50015,00025%1,0052,74532,940003%0032,94018,5503,50015,05025%1,0052,75833,090003%0033,09018,6003,5

45、0015,10025%1,0052,77033,240003%0033,24018,6503,50015,15025%1,0052,78333,390003%0033,39018,7003,50015,20025%1,0052,79533,540003%0033,54018,7503,50015,25025%1,0052,80833,690003%0033,69018,8003,50015,30025%1,0052,82033,840003%0033,84018,8503,50015,35025%1,0052,83333,990003%0033,99018,9003,50015,40025%1

46、,0052,84534,140003%0034,14018,9503,50015,45025%1,0052,85834,290003%0034,29019,0003,50015,50025%1,0052,87034,440003%0034,44019,0503,50015,55025%1,0052,88334,590003%0034,59019,1003,50015,60025%1,0052,89534,740003%0034,74019,1503,50015,65025%1,0052,90834,890003%0034,89019,2003,50015,70025%1,0052,92035,

47、040003%0035,04019,2503,50015,75025%1,0052,93335,190003%0035,19019,3003,50015,80025%1,0052,94535,340003%0035,34019,3503,50015,85025%1,0052,95835,490003%0035,49019,4003,50015,90025%1,0052,97035,640003%0035,64019,4503,50015,95025%1,0052,98335,790003%0035,79019,5003,50016,00025%1,0052,99535,940003%0035,

48、94019,5503,50016,05025%1,0053,00836,090003%0036,09019,6003,50016,10025%1,0053,02036,240003%0036,24019,6503,50016,15025%1,0053,03336,390003%0036,39019,7003,50016,20025%1,0053,04536,540003%0036,54019,7503,50016,25025%1,0053,05836,690003%0036,69019,8003,50016,30025%1,0053,07036,840003%0036,84019,8503,5

49、0016,35025%1,0053,08336,990003%0036,99019,9003,50016,40025%1,0053,09537,140003%0037,14019,9503,50016,45025%1,0053,10837,290003%0037,29020,0003,50016,50025%1,0053,12037,440003%0037,44020,0503,50016,55025%1,0053,13337,590003%0037,59020,1003,50016,60025%1,0053,14537,740003%0037,74020,1503,50016,65025%1

50、,0053,15837,890003%0037,89020,2003,50016,70025%1,0053,17038,040003%0038,04020,2503,50016,75025%1,0053,18338,190003%0038,19020,3003,50016,80025%1,0053,19538,340003%0038,34020,3503,50016,85025%1,0053,20838,490003%0038,49020,4003,50016,90025%1,0053,22038,640003%0038,64020,4503,50016,95025%1,0053,23338,

51、790003%0038,79020,5003,50017,00025%1,0053,24538,940003%0038,94020,5503,50017,05025%1,0053,25839,090003%0039,09020,6003,50017,10025%1,0053,27039,240003%0039,24020,6503,50017,15025%1,0053,28339,390003%0039,39020,7003,50017,20025%1,0053,29539,540003%0039,54020,7503,50017,25025%1,0053,30839,690003%0039,

52、69020,8003,50017,30025%1,0053,32039,840003%0039,84020,8503,50017,35025%1,0053,33339,990003%0039,99020,9003,50017,40025%1,0053,34540,140003%0040,14020,9503,50017,45025%1,0053,35840,290003%0040,29021,0003,50017,50025%1,0053,37040,440003%0040,44021,0503,50017,55025%1,0053,38340,590003%0040,59021,1003,5

53、0017,60025%1,0053,39540,740003%0040,74021,1503,50017,65025%1,0053,40840,890003%0040,89021,2003,50017,70025%1,0053,42041,040003%0041,04021,2503,50017,75025%1,0053,43341,190003%0041,19021,3003,50017,80025%1,0053,44541,340003%0041,34021,3503,50017,85025%1,0053,45841,490003%0041,49021,4003,50017,90025%1

54、,0053,47041,640003%0041,64021,4503,50017,95025%1,0053,48341,790003%0041,79021,5003,50018,00025%1,0053,49541,940003%0041,94021,5503,50018,05025%1,0053,50842,090003%0042,09021,6003,50018,10025%1,0053,52042,240003%0042,24021,6503,50018,15025%1,0053,53342,390003%0042,39021,7003,50018,20025%1,0053,54542,

55、540003%0042,54021,7503,50018,25025%1,0053,55842,690003%0042,69021,8003,50018,30025%1,0053,57042,840003%0042,84021,8503,50018,35025%1,0053,58342,990003%0042,99021,9003,50018,40025%1,0053,59543,140003%0043,14021,9503,50018,45025%1,0053,60843,290003%0043,29022,0003,50018,50025%1,0053,62043,440003%0043,

56、44022,0503,50018,55025%1,0053,63343,590003%0043,59022,1003,50018,60025%1,0053,64543,740003%0043,74022,1503,50018,65025%1,0053,65843,890003%0043,89022,2003,50018,70025%1,0053,67044,040003%0044,04022,2503,50018,75025%1,0053,68344,190003%0044,19022,3003,50018,80025%1,0053,69544,340003%0044,34022,3503,5

57、0018,85025%1,0053,70844,490003%0044,49022,4003,50018,90025%1,0053,72044,640003%0044,64022,4503,50018,95025%1,0053,73344,790003%0044,79022,5003,50019,00025%1,0053,74544,940003%0044,94022,5503,50019,05025%1,0053,75845,090003%0045,09022,6003,50019,10025%1,0053,77045,240003%0045,24022,6503,50019,15025%1

58、,0053,78345,390003%0045,39022,7003,50019,20025%1,0053,79545,540003%0045,54022,7503,50019,25025%1,0053,80845,690003%0045,69022,8003,50019,30025%1,0053,82045,840003%0045,84022,8503,50019,35025%1,0053,83345,990003%0045,99022,9003,50019,40025%1,0053,84546,140003%0046,14022,9503,50019,45025%1,0053,85846,

59、290003%0046,29023,0003,50019,50025%1,0053,87046,440003%0046,44023,0503,50019,55025%1,0053,88346,590003%0046,59023,1003,50019,60025%1,0053,89546,740003%0046,74023,1503,50019,65025%1,0053,90846,890003%0046,89023,2003,50019,70025%1,0053,92047,040003%0047,04023,2503,50019,75025%1,0053,93347,190003%0047,

60、19023,3003,50019,80025%1,0053,94547,340003%0047,34023,3503,50019,85025%1,0053,95847,490003%0047,49023,4003,50019,90025%1,0053,97047,640003%0047,64023,4503,50019,95025%1,0053,98347,790003%0047,79023,5003,50020,00025%1,0053,99547,940003%0047,94023,5503,50020,05025%1,0054,00848,090003%0048,09023,6003,5