《年收入最优工资分配方案模型2.0.xls》由会员分享，可在线阅读，更多相关《年收入最优工资分配方案模型2.0.xls（16页珍藏版）》请在三一文库上搜索。
1、年年收收入入120000120000最最优优工工资资模模型型 在在下下列列单单元元格格输输入入 你你的的年年收收入入总总额额 年年收收入入：1 12 20 0, ,0 00 00 0. .0 00 0最最小小税税负负5 5, ,8 88 80 0. .0 00 0 序序号号月月收收入入扣扣除除额额应应纳纳税税所所得得额额适适用用税税率率速速算算扣扣除除数数应应纳纳税税额额 13,500.003,500.00-0.03- 23,550.003,500.0050.000.03-1.50 33,600.003,500.00100.000.03-3.00 43,650.003,500.00150.00
2、0.03-4.50 53,700.003,500.00200.000.03-6.00 63,750.003,500.00250.000.03-7.50 73,800.003,500.00300.000.03-9.00 83,850.003,500.00350.000.03-10.50 93,900.003,500.00400.000.03-12.00 103,950.003,500.00450.000.03-13.50 114,000.003,500.00500.000.03-15.00 124,050.003,500.00550.000.03-16.50 134,100.003,500.00
3、600.000.03-18.00 144,150.003,500.00650.000.03-19.50 154,200.003,500.00700.000.03-21.00 164,250.003,500.00750.000.03-22.50 174,300.003,500.00800.000.03-24.00 184,350.003,500.00850.000.03-25.50 194,400.003,500.00900.000.03-27.00 204,450.003,500.00950.000.03-28.50 214,500.003,500.001,000.000.03-30.00 2
4、24,550.003,500.001,050.000.03-31.50 234,600.003,500.001,100.000.03-33.00 244,650.003,500.001,150.000.03-34.50 254,700.003,500.001,200.000.03-36.00 264,750.003,500.001,250.000.03-37.50 274,800.003,500.001,300.000.03-39.00 284,850.003,500.001,350.000.03-40.50 294,900.003,500.001,400.000.03-42.00 304,9
5、50.003,500.001,450.000.03-43.50 315,000.003,500.001,500.000.03-45.00 325,050.003,500.001,550.000.10105.0050.00 335,100.003,500.001,600.000.10105.0055.00 345,150.003,500.001,650.000.10105.0060.00 355,200.003,500.001,700.000.10105.0065.00 365,250.003,500.001,750.000.10105.0070.00 375,300.003,500.001,8
6、00.000.10105.0075.00 385,350.003,500.001,850.000.10105.0080.00 395,400.003,500.001,900.000.10105.0085.00 405,450.003,500.001,950.000.10105.0090.00 415,500.003,500.002,000.000.10105.0095.00 425,550.003,500.002,050.000.10105.00100.00 435,600.003,500.002,100.000.10105.00105.00 445,650.003,500.002,150.0
7、00.10105.00110.00 455,700.003,500.002,200.000.10105.00115.00 465,750.003,500.002,250.000.10105.00120.00 475,800.003,500.002,300.000.10105.00125.00 485,850.003,500.002,350.000.10105.00130.00 495,900.003,500.002,400.000.10105.00135.00 505,950.003,500.002,450.000.10105.00140.00 516,000.003,500.002,500.
8、000.10105.00145.00 526,050.003,500.002,550.000.10105.00150.00 536,100.003,500.002,600.000.10105.00155.00 546,150.003,500.002,650.000.10105.00160.00 556,200.003,500.002,700.000.10105.00165.00 566,250.003,500.002,750.000.10105.00170.00 576,300.003,500.002,800.000.10105.00175.00 586,350.003,500.002,850
9、.000.10105.00180.00 596,400.003,500.002,900.000.10105.00185.00 606,450.003,500.002,950.000.10105.00190.00 616,500.003,500.003,000.000.10105.00195.00 626,550.003,500.003,050.000.10105.00200.00 636,600.003,500.003,100.000.10105.00205.00 646,650.003,500.003,150.000.10105.00210.00 656,700.003,500.003,20
10、0.000.10105.00215.00 666,750.003,500.003,250.000.10105.00220.00 676,800.003,500.003,300.000.10105.00225.00 686,850.003,500.003,350.000.10105.00230.00 696,900.003,500.003,400.000.10105.00235.00 706,950.003,500.003,450.000.10105.00240.00 717,000.003,500.003,500.000.10105.00245.00 727,050.003,500.003,5
11、50.000.10105.00250.00 737,100.003,500.003,600.000.10105.00255.00 747,150.003,500.003,650.000.10105.00260.00 757,200.003,500.003,700.000.10105.00265.00 767,250.003,500.003,750.000.10105.00270.00 777,300.003,500.003,800.000.10105.00275.00 787,350.003,500.003,850.000.10105.00280.00 797,400.003,500.003,
12、900.000.10105.00285.00 807,450.003,500.003,950.000.10105.00290.00 817,500.003,500.004,000.000.10105.00295.00 827,550.003,500.004,050.000.10105.00300.00 837,600.003,500.004,100.000.10105.00305.00 847,650.003,500.004,150.000.10105.00310.00 857,700.003,500.004,200.000.10105.00315.00 867,750.003,500.004
13、,250.000.10105.00320.00 877,800.003,500.004,300.000.10105.00325.00 887,850.003,500.004,350.000.10105.00330.00 897,900.003,500.004,400.000.10105.00335.00 907,950.003,500.004,450.000.10105.00340.00 918,000.003,500.004,500.000.10105.00345.00 928,050.003,500.004,550.000.20555.00355.00 938,100.003,500.00
14、4,600.000.20555.00365.00 948,150.003,500.004,650.000.20555.00375.00 958,200.003,500.004,700.000.20555.00385.00 968,250.003,500.004,750.000.20555.00395.00 978,300.003,500.004,800.000.20555.00405.00 988,350.003,500.004,850.000.20555.00415.00 998,400.003,500.004,900.000.20555.00425.00 1008,450.003,500.
15、004,950.000.20555.00435.00 1018,500.003,500.005,000.000.20555.00445.00 1028,550.003,500.005,050.000.20555.00455.00 1038,600.003,500.005,100.000.20555.00465.00 1048,650.003,500.005,150.000.20555.00475.00 1058,700.003,500.005,200.000.20555.00485.00 1068,750.003,500.005,250.000.20555.00495.00 1078,800.
16、003,500.005,300.000.20555.00505.00 1088,850.003,500.005,350.000.20555.00515.00 1098,900.003,500.005,400.000.20555.00525.00 1108,950.003,500.005,450.000.20555.00535.00 1119,000.003,500.005,500.000.20555.00545.00 1129,050.003,500.005,550.000.20555.00555.00 1139,100.003,500.005,600.000.20555.00565.00 1
17、149,150.003,500.005,650.000.20555.00575.00 1159,200.003,500.005,700.000.20555.00585.00 1169,250.003,500.005,750.000.20555.00595.00 1179,300.003,500.005,800.000.20555.00605.00 1189,350.003,500.005,850.000.20555.00615.00 1199,400.003,500.005,900.000.20555.00625.00 1209,450.003,500.005,950.000.20555.00
18、635.00 1219,500.003,500.006,000.000.20555.00645.00 1229,550.003,500.006,050.000.20555.00655.00 1239,600.003,500.006,100.000.20555.00665.00 1249,650.003,500.006,150.000.20555.00675.00 1259,700.003,500.006,200.000.20555.00685.00 1269,750.003,500.006,250.000.20555.00695.00 1279,800.003,500.006,300.000.
19、20555.00705.00 1289,850.003,500.006,350.000.20555.00715.00 1299,900.003,500.006,400.000.20555.00725.00 1309,950.003,500.006,450.000.20555.00735.00 13110,000.003,500.006,500.000.20555.00745.00 132- 133- 134- 135- 136- 137- 138- 139- 140- 141- 142- 143- 144- 145- 146- 147- 148- 149- 150- 151- 152- 153
20、- 154- 155- 156- 157- 158- 159- 160- 161- 162- 163- 164- 165- 166- 167- 168- 169- 170- 171- 172- 173- 174- 175- 176- 177- 178- 179- 180- 181- 182- 183- 184- 185- 186- 187- 188- 189- 190- 191- 192- 193- 194- 195- 196- 197- 198- 199- 200- 201- 202- 203- 204- 205- 206- 207- 208- 209- 210- 211- 212- 213
21、- 214- 215- 216- 217- 218- 219- 220- 221- 222- 223- 224- 225- 226- 227- 228- 229- 230- 231- 232- 233- 234- 235- 236- 237- 238- 239- 240- 241- 242- 243- 244- 245- 246- 247- 248- 249- 250- 251- 252- 253- 254- 255- 256- 257- 258- 259- 260- 261- 262- 263- 264- 265- 266- 267- 268- 269- 270- 271- 272- 273
22、- 274- 275- 276- 277- 278- 279- 280- 281- 282- 283- 284- 285- 286- 287- 288- 289- 290- 291- 292- 293- 294- 295- 296- 297- 298- 299- 300- 301- 302- 303- 304- 305- 306- 307- 308- 309- 310- 311- 312- 313- 314- 315- 316- 317- 318- 319- 320- 321- 322- 323- 324- 325- 326- 327- 328- 329- 330- 331- 332- 333
23、- 334- 335- 336- 337- 338- 339- 340- 341- 342- 343- 344- 345- 346- 347- 348- 349- 350- 351- 352- 353- 354- 355- 356- 357- 358- 359- 360- 361- 362- 363- 364- 365- 366- 367- 368- 369- 370- 371- 372- 373- 374- 375- 376- 377- 378- 379- 380- 381- 382- 383- 384- 385- 386- 387- 388- 389- 390- 391- 392- 393
24、- 394- 395- 396- 397- 398- 399- 400- 401- 402- 403- 404- 405- 406- 407- 408- 409- 410- 411- 412- 413- 414- 415- 416- 417- 418- 419- 420- 421- 422- 423- 424- 425- 426- 427- 428- 429- 430- 431- 432- 433- 434- 435- 436- 437- 438- 439- 440- 年年终终奖奖 年年终终奖奖 适适用用税税率率 年年终终奖奖适适用用扣扣除除数数年年终终奖奖应应纳纳税税额额全全年年应应纳纳税税
25、额额 78,000.000.20555.0015,045.0015,045.00 77,400.000.20555.0014,925.0014,943.00 76,800.000.20555.0014,805.0014,841.00 76,200.000.20555.0014,685.0014,739.00 75,600.000.20555.0014,565.0014,637.00 75,000.000.20555.0014,445.0014,535.00 74,400.000.20555.0014,325.0014,433.00 73,800.000.20555.0014,205.0014,
26、331.00 73,200.000.20555.0014,085.0014,229.00 72,600.000.20555.0013,965.0014,127.00 72,000.000.20555.0013,845.0014,025.00 71,400.000.20555.0013,725.0013,923.00 70,800.000.20555.0013,605.0013,821.00 70,200.000.20555.0013,485.0013,719.00 69,600.000.20555.0013,365.0013,617.00 69,000.000.20555.0013,245.0
27、013,515.00 68,400.000.20555.0013,125.0013,413.00 67,800.000.20555.0013,005.0013,311.00 67,200.000.20555.0012,885.0013,209.00 66,600.000.20555.0012,765.0013,107.00 66,000.000.20555.0012,645.0013,005.00 65,400.000.20555.0012,525.0012,903.00 64,800.000.20555.0012,405.0012,801.00 64,200.000.20555.0012,2
28、85.0012,699.00 63,600.000.20555.0012,165.0012,597.00 63,000.000.20555.0012,045.0012,495.00 62,400.000.20555.0011,925.0012,393.00 61,800.000.20555.0011,805.0012,291.00 61,200.000.20555.0011,685.0012,189.00 60,600.000.20555.0011,565.0012,087.00 60,000.000.20555.0011,445.0011,985.00 59,400.000.20555.00
29、11,325.0011,925.00 58,800.000.20555.0011,205.0011,865.00 58,200.000.20555.0011,085.0011,805.00 57,600.000.20555.0010,965.0011,745.00 57,000.000.20555.0010,845.0011,685.00 56,400.000.20555.0010,725.0011,625.00 55,800.000.20555.0010,605.0011,565.00 55,200.000.20555.0010,485.0011,505.00 54,600.000.2055
30、5.0010,365.0011,445.00 54,000.000.10105.005,295.006,435.00 53,400.000.10105.005,235.006,435.00 52,800.000.10105.005,175.006,435.00 52,200.000.10105.005,115.006,435.00 51,600.000.10105.005,055.006,435.00 51,000.000.10105.004,995.006,435.00 50,400.000.10105.004,935.006,435.00 49,800.000.10105.004,875.
31、006,435.00 49,200.000.10105.004,815.006,435.00 48,600.000.10105.004,755.006,435.00 年年收收入入120000120000最最优优工工资资模模型型 48,000.000.10105.004,695.006,435.00 47,400.000.10105.004,635.006,435.00 46,800.000.10105.004,575.006,435.00 46,200.000.10105.004,515.006,435.00 45,600.000.10105.004,455.006,435.00 45,000
32、.000.10105.004,395.006,435.00 44,400.000.10105.004,335.006,435.00 43,800.000.10105.004,275.006,435.00 43,200.000.10105.004,215.006,435.00 42,600.000.10105.004,155.006,435.00 42,000.000.10105.004,095.006,435.00 41,400.000.10105.004,035.006,435.00 40,800.000.10105.003,975.006,435.00 40,200.000.10105.0
33、03,915.006,435.00 39,600.000.10105.003,855.006,435.00 39,000.000.10105.003,795.006,435.00 38,400.000.10105.003,735.006,435.00 37,800.000.10105.003,675.006,435.00 37,200.000.10105.003,615.006,435.00 36,600.000.10105.003,555.006,435.00 36,000.000.10105.003,495.006,435.00 35,400.000.10105.003,435.006,4
34、35.00 34,800.000.10105.003,375.006,435.00 34,200.000.10105.003,315.006,435.00 33,600.000.10105.003,255.006,435.00 33,000.000.10105.003,195.006,435.00 32,400.000.10105.003,135.006,435.00 31,800.000.10105.003,075.006,435.00 31,200.000.10105.003,015.006,435.00 30,600.000.10105.002,955.006,435.00 30,000
35、.000.10105.002,895.006,435.00 29,400.000.10105.002,835.006,435.00 28,800.000.10105.002,775.006,435.00 28,200.000.10105.002,715.006,435.00 27,600.000.10105.002,655.006,435.00 27,000.000.10105.002,595.006,435.00 26,400.000.10105.002,535.006,435.00 25,800.000.10105.002,475.006,435.00 25,200.000.10105.0
36、02,415.006,435.00 24,600.000.10105.002,355.006,435.00 24,000.000.10105.002,295.006,435.00 23,400.000.10105.002,235.006,495.00 22,800.000.10105.002,175.006,555.00 22,200.000.10105.002,115.006,615.00 21,600.000.10105.002,055.006,675.00 21,000.000.10105.001,995.006,735.00 20,400.000.10105.001,935.006,7
37、95.00 19,800.000.10105.001,875.006,855.00 19,200.000.10105.001,815.006,915.00 18,600.000.10105.001,755.006,975.00 18,000.000.03-540.005,880.00 17,400.000.03-522.005,982.00 16,800.000.03-504.006,084.00 16,200.000.03-486.006,186.00 15,600.000.03-468.006,288.00 15,000.000.03-450.006,390.00 14,400.000.0
38、3-432.006,492.00 13,800.000.03-414.006,594.00 13,200.000.03-396.006,696.00 12,600.000.03-378.006,798.00 12,000.000.03-360.006,900.00 11,400.000.03-342.007,002.00 10,800.000.03-324.007,104.00 10,200.000.03-306.007,206.00 9,600.000.03-288.007,308.00 9,000.000.03-270.007,410.00 8,400.000.03-252.007,512
39、.00 7,800.000.03-234.007,614.00 7,200.000.03-216.007,716.00 6,600.000.03-198.007,818.00 6,000.000.03-180.007,920.00 5,400.000.03-162.008,022.00 4,800.000.03-144.008,124.00 4,200.000.03-126.008,226.00 3,600.000.03-108.008,328.00 3,000.000.03-90.008,430.00 2,400.000.03-72.008,532.00 1,800.000.03-54.00
40、8,634.00 1,200.000.03-36.008,736.00 600.000.03-18.008,838.00 -0.03-8,940.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005
41、.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.002
42、8,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,
43、000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,0
44、05.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,995.0028,995.00 120,000.000.251,005.0028,