年收入最优工资分配方案模型.xls

年收入72000最优工资模型
在下列单元格输入
你的年收入总额
年收入: 72, 最小税负
序号月收入扣除额应纳税所得额适用税率速算扣除数应纳税额
1 3, 3, - - -
2 3, 3, -
3 3, 3, -
4 3, 3, -
5 3, 3, -
6 3, 3, -
7 3, 3, -
8 3, 3, -
9 3, 3, -
10 3, 3, -
11 4, 3, -
12 4, 3, -
13 4, 3, -
14 4, 3, -
15 4, 3, -
16 4, 3, -
17 4, 3, -
18 4, 3, -
19 4, 3, -
20 4, 3, -
21 4, 3, 1, -
22 4, 3, 1, -
23 4, 3, 1, -
24 4, 3, 1, -
25 4, 3, 1, -
26 4, 3, 1, -
27 4, 3, 1, -
28 4, 3, 1, -
29 4, 3, 1, -
30 4, 3, 1, -
31 5, 3, 1, -
32 5, 3, 1,
33 5, 3, 1,
34 5, 3, 1,
35 5, 3, 1,
36 5, 3, 1,
37 5, 3, 1,
38 5, 3, 1,
39 5, 3, 1,
40 5, 3, 1,
41 5, 3, 2,
42 5, 3, 2,
43 5, 3, 2,100