最佳薪酬分配方案.xls

最佳薪酬分配方案模型之120000元
月工资扣除数所得额税率速算扣除数税额年月税总额年终奖税率扣除数税额总税负
3,500 3,500 0 3% 0 0 0 (38,500) 20% 555 (8,255) (8,255)
3,550 3,500 50 3% 0 2 18 77,400 20% 555 14,925 14,943
3,600 3,500 100 3% 0 3 36 76,800 20% 555 14,805 14,841
3,650 3,500 150 3% 0 5 54 76,200 20% 555 14,685 14,739
3,700 3,500 200 3% 0 6 72 75,600 20% 555 14,565 14,637
3,750 3,500 250 3% 0 8 90 75,000 20% 555 14,445 14,535
3,800 3,500 300 3% 0 9 108 74,400 20% 555 14,325 14,433
3,850 3,500 350 3% 0 11 126 73,800 20% 555 14,205 14,331
3,900 3,500 400 3% 0 12 144 73,200 20% 555 14,085 14,229
3,950 3,500 450 3% 0 14 162 72,600 20% 555 13,965 14,127
4,000 3,500 500 3% 0 15 180 72,000 20% 555 13,845 14,025
4,050 3,500 550 3% 0 17 198 71,400 20% 555 13,725 13,923
4,100 3,500 600 3% 0 18 216 70,800 20% 555 13,605 13,821
4,150 3,500 650 3% 0 20 234 70,200 20% 555 13,485 13,719
4,200 3,500 700 3% 0 21 252 69,600 20% 555 13,365 13,617
4,250 3,500 750 3% 0 23 270 69,000 20% 555 13,245 13,515
4,300 3,500 800 3% 0 24 288 68,400 20% 555 13,125 13,413
4,350 3,500 850 3% 0 26 306 67,800 20% 555 13,005 13,311
4,400 3,500 900 3% 0 27 324 67,200 20% 555 12,885 13,209
4,450 3,500 950 3% 0 29 342 66,600 20% 555 12,765 13,107
4,500 3,500 1,000 3% 0 30 360 66,000 20% 555 12,645 13,005
4,550 3,500 1,050 3% 0 32 378 65,400 20% 555 12,525 12,903
4,600 3,500 1,100 3% 0 33 396 64,800 20% 555 12,405 1