人力资源,人事,HR报表大全42-分级分类分岗工资测算表

表-1. 级差薪酬自动测算表

工龄基本工资级别66543325444335355434321543341215412154334638.14638.14 607.75 578.81 551.25 551.25 525.00 4,090.35 607.75 578.81 578.81 578.81 551.25 551.25 607.75 551.25 4,605.69 607.75 607.75 578.81 551.25 578.8167899445555551334555职位工资 12,500.00 10,260.77 10,260.77 9,227.27 8,251.20 8,251.20 8,251.20 67,002.39 9,227.27 9,227.27 8,251.20 8,251.20 8,251.20 8,251.20 8,251.20 8,251.20 67,961.72 7,332.54 6,471.29 5,667.46 4,921.05 4,921.05 4,232.06 4,232.06 4,232.06 42,009.57678999 7,332.54 6,471.29 5,667.46 4,921.05 4,921.05 4,232.06 4,921.05 4,232.06 42,698.56699 7,332.54 4,921.05 4,232.06 4,921.05 4,232.06 25,638.7667899 7,332.54 6,471.29 5,667.46 4,921.05 4,921.05绩效提成绩效工资0.060% 5,100.000.020% 1,700.00福利补贴薪酬总额人数11111117111111118111111118112345611456111234薪酬合计 18,429.58 12,790.35 12,750.84 11,254.73 9,987.82 9,987.82 9,953.70 85,154.84 11,292.35 11,254.73 10,023.65 10,023.65 9,987.82 9,987.82 10,061.28 9,987.82 82,619.12 8,972.61 7,989.94 7,057.42 6,204.34 6,240.18 5,458.68 5,424.56 5,392.06 52,739.79 8,972.61 7,952.32 14,043.18 18,613.03 24,960.70 26,960.29 37,021.32 5,392.06######### 8,972.61 24,960.70 26,960.29 37,021.32 5,392.06######### 8,972.61 7,952.32 14,043.18 18,613.03 24,960.701总裁生产副总裁营运副总裁财务总监行政总监IT总监总裁助理191.44 18,429.58191.44 12,790.35部门No.职 位总裁办A类2345670.020% 1,700.00 182.33 12,750.840.015% 1,275.00 173.64 11,254.730.012% 1,020.00 165.38 9,987.820.012% 1,020.00 165.38 9,987.820.012% 1,020.00 157.50 9,953.700.151% 12,835.00 1,227.10 85,154.840.015% 1,275.00 182.33 11,292.350.015% 1,275.00 173.64 11,254.730.012% 1,020.00 173.64 10,023.650.012% 1,020.00 173.64 10,023.650.012% 1,020.00 165.38 9,987.820.012% 1,020.00 165.38 9,987.820.012% 1,020.00 182.33 10,061.280.012% 1,020.00 165.38 9,987.820.102% 8,670.00 1,381.71 82,619.120.010% 850.00 182.33 8,972.610.009% 728.57 182.33 7,989.940.008% 637.50 173.64 7,057.420.007% 566.67 165.38 6,204.340.007% 566.67 173.64 6,240.180.006% 510.00 165.38 5,458.680.006% 510.00 157.50 5,424.560.006% 510.00 150.00 5,392.060.057% 4,879.40 1,350.19 52,739.790.010% 850.00 182.33 8,972.610.009% 728.57 173.64 7,952.320.008% 637.50 165.38 7,021.590.007% 566.67 165.38 6,204.340.007% 566.67 173.64 6,240.180.006% 510.00 150.00 5,392.060.007% 566.67 157.50 6,170.220.006% 510.00 150.00 5,392.060.010% 850.00 182.33 8,972.610.007% 566.67 173.64 6,240.180.006% 510.00 150.00 5,392.060.007% 566.67 157.50 6,170.220.006% 510.00 150.00 5,392.060.010% 850.00 182.33 8,972.610.009% 728.57 173.64 7,952.320.008% 637.50 165.38 7,021.590.007% 566.67 165.38 6,204.340.007% 566.67 173.64 6,240.18 总裁办合计8高级经理发展部A类9新业务开发经理10战略推进经理11新业务技术主管12再循环业务主管13投融资主管14技术工艺工程师15战略推进助理发展部合计 16高级经理采购部B类17行业采购经理18园区采购经理19区域采购经理20采购资讯主管21采购助理经理22采购助理23信息员 采购部合计24高级经理销售部B类25废料销售经理26铜产品销售经理27其他产品销售经28理销售资讯主管29信息员30销售助理经理31销售代表 总部销售部合计区域销售B32区域经理33采购代表34销售代表35区域出纳统计员36区域储运专员37高级经理生产部B38生产计划主管39生产作业主管40生产管理主管41计划统计员 551.2510 525.0010 500.0010 4,500.63 607.75 578.81 551.25 551.25 578.81 525.00 4,392.88 607.75 578.81 525.00 2,711.57 607.75 578.81 551.25 551.25 578.81 500.0010 500.00100.058% 4,936.07 1,317.86 53,345.3823 500.0010 500.0010类 分部销售部合计0.035% 3,003.33 813.47 32,167.1217###

类表-1. 级差薪酬自动测算表

工龄基本工资级别2154334242133322125443323332212333221185 525.00 3,892.88 607.7511 578.8112 551.2513 551.2513 578.8114 525.0014 578.8115 525.0015 500.0015 3,810.13 551.2511 551.2512 551.2513 525.0014 525.0015 500.0015 525.0015 3,728.75 607.7511 578.8111 578.8112 551.2512 551.2512 525.0013 3,392.88 551.2511 551.2512 551.2512 525.0013 525.0014 500.0014 525.0014 551.2514 4,280.00 551.2511 551.2512 525.0012 525.0013 500.0014 500.0014 3,152.50 703.5516 607.75169 500.0010职位工资 4,921.05 4,232.06 38,466.51 3,600.48 3,026.32 2,509.57 2,509.57 2,050.24 2,050.24 1,648.33 1,648.33 1,648.33 14,064.59 3,600.48 3,026.32 2,509.57 2,050.24 1,648.33 1,648.33 1,648.33 16,131.58 3,600.48 3,600.48 3,026.32 3,026.32 3,026.32 2,509.57 18,789.47 3,600.48 3,026.32 3,026.32 2,509.57 2,050.24 2,050.24 2,050.24 2,050.24 20,363.64 3,600.48 3,026.32 3,026.32 2,509.57 2,050.24 2,050.24 16,263.16 1,303.83 1,303.83绩效提成绩效工资福利补贴薪酬总额人数6111234646123456789薪酬合计 37,021.32 5,392.06######### 4,854.19 4,203.77 7,237.00 10,855.51 12,667.92 18,582.15 10,963.13 16,024.95 2,638.33 78,968.99 9,561.48 12,503.82 14,474.01 15,485.12 16,024.95 18,468.28 21,366.60######### 43,687.75 48,165.71 46,241.49 50,015.29 54,183.23 50,181.28######### 9,561.48 12,503.82 16,671.76 17,921.89 18,582.15 21,451.67 24,776.20 28,180.35######### 4,780.74 4,167.94 4,133.82 3,584.38 3,064.52 3,064.52 22,795.92 2,537.19 2,412.6642生产管理员43作业班长 生产部合计44高级经理0.007% 566.67 157.50 6,170.220.006% 510.00 150.00 5,392.060.005% 463.64 182.33 4,854.190.005% 425.00 173.64 4,203.770.005% 392.31 165.38 3,618.500.005% 392.31 165.38 3,618.500.004% 364.29 173.64 3,166.980.004% 364.29 157.50 3,097.020.004% 340.00 173.64 2,740.780.004% 340.00 157.50 2,670.830.004% 340.00 150.00 2,638.330.005% 463.64 165.38 4,780.740.005% 425.00 165.38 4,167.940.005% 392.31 165.38 3,618.500.004% 364.29 157.50 3,097.020.004% 340.00 157.50 2,670.830.004% 340.00 150.00 2,638.330.004% 340.00 157.50 2,670.830.005% 463.64 182.33 4,854.19部门No.职 位0.052% 4,426.07 1,167.86 47,953.3218储运部C类45收发货主管46仓储主管47装卸主管48跟单员49储运协调员50库管员51叉车工52铲车工 储运部合计53高级经理0.030% 2,533.19 1,143.04 21,550.9426质检部C类54品质主管55体系主管56质量统计员57体系管理员58安全环保员59质检员 质检部合计60高级经理0.031% 2,665.23 1,118.63 23,644.18350.005% 463.64 173.64 4,816.57100.005% 425.00 173.64 4,203.77110.005% 425.00 165.38 4,167.94120.005% 425.00 165.38 4,167.94130.005% 392.31 157.50 3,584.38140.031% 2,594.58 1,017.86 25,794.80690.005% 463.64 165.38 4,780.740.005% 425.00 165.38 4,167.940.005% 425.00 165.38 4,167.940.005% 392.31 157.50 3,584.380.004% 364.29 157.50 3,097.020.004% 364.29 150.00 3,064.520.004% 364.29 157.50 3,097.020.004% 364.29 165.38 3,131.150.005% 463.64 165.38 4,780.740.005% 425.00 165.38 4,167.940.005% 425.00 157.50 4,133.820.005% 392.31 157.50 3,584.380.004% 364.29 150.00 3,064.520.004% 364.29 150.00 3,064.520.029% 2,434.52 945.75 22,795.920.004% 318.75 211.07 2,537.190.004% 318.75 182.33 2,412.6623456789111111611估价部C类61采购估价主管62销售估价主管63价格信息主管64估价师65信息分析员 估价部合计66高级经理67设备工程主管设备部C类68机电工务主管69设备工程师70维修技师71机电工程师72电工技师73锅炉技师 设备部合计74高级经理0.037% 3,163.09 1,284.00 29,090.7244信息部C类75应用系统主管76设施维护主管77ERP项目经理78程序员79系统维护员 信息部合计80财务经理81会计经理###

表-1. 级差薪酬自动测算表

工龄基本工资级别5444344445333222533334321111 607.7517 578.8117 578.8117 578.8117 551.2518 578.8118 578.8118 578.8118 578.8118 6,521.99 607.7516 551.2517 551.2517 551.2517 525.0018 525.0018 525.0018 3,836.50 607.7516 551.2517 551.2517 551.2518 551.2518 578.8118 551.2518 525.0019 500.0020 500.0020 500.0020 500.0020 6,467.82 21,892.7职位工资 1,016.75 1,016.75 1,016.75 1,016.75 787.08 787.08 787.08 787.08 787.08 10,610.05 1,303.83 1,016.75 1,016.75 1,016.75 787.08 787.08 787.08 6,715.31 1,303.83 1,016.75 1,016.75 787.08 787.08 787.08 787.08 614.83 500.00 500.00 500.00 500.00 9,100.48 311,937.8绩效提成绩效工资福利补贴薪酬总额人数11111111111111117111111111111薪酬合计 2,106.83 2,069.20 2,069.20 2,069.20 1,787.04 1,822.87 1,822.87 1,822.87 1,822.87 22,342.81 2,412.66 2,033.37 2,033.37 2,033.37 1,752.91 1,752.91 1,752.91 13,771.52 2,412.66 2,033.37 2,033.37 1,787.04 1,787.04 1,822.87 1,787.04 1,565.75 1,405.00 1,405.00 1,405.00 1,405.00 20,849.1482现金主管0.004% 300.00 182.33 2,106.830.004% 300.00 173.64 2,069.200.004% 300.00 173.64 2,069.200.004% 300.00 173.64 2,069.200.003% 283.33 165.38 1,787.040.003% 283.33 173.64 1,822.870.003% 283.33 173.64 1,822.870.003% 283.33 173.64 1,822.870.003% 283.33 173.64 1,822.870.004% 318.75 182.33 2,412.660.004% 300.00 165.38 2,033.370.004% 300.00 165.38 2,033.370.004% 300.00 165.38 2,033.370.003% 283.33 157.50 1,752.910.003% 283.33 157.50 1,752.910.003% 283.33 157.50 1,752.910.024% 2,068.75 1,150.95 13,771.520.004% 318.75 182.33 2,412.660.004% 300.00 165.38 2,033.370.004% 300.00 165.38 2,033.370.003% 283.33 165.38 1,787.040.003% 283.33 165.38 1,787.040.003% 283.33 173.64 1,822.870.003% 283.33 165.38 1,787.040.003% 268.42 157.50 1,565.750.003% 255.00 150.00 1,405.000.003% 255.00 150.00 1,405.000.003% 255.00 150.00 1,405.000.003% 255.00 150.00 1,405.00 47,889.4 6,567.8 388,287.7部门No.职 位财务部C类83信用风险主管84管会主管85财会主管86出纳87预算分析会计88成本费用会计89应收应付会计90总账会计 财务部合计91高级经理人事部C类92人事招聘主管93培训主管94绩效薪酬主管95人事招聘专员96培训专员97薪资专员 人事部合计98高级经理行政后勤部C类99公关经理100总务行政经理101安全保卫主管102行政主管103总务后勤主管104法务主管105行政助理106前台107综合管理员108驾驶员109门卫巡查 行政后勤部合计总计0.038% 3,254.17 1,956.60 22,342.81110.039% 3,340.50 1,940.34 20,849.1412工资结构说明：基本工资：取决于工龄、学历、资质职位工资：取决于职位以及奖励晋级绩效工资：取决于当期经营效益贡献福利工资：取决于各项福利费、补助

四步曲、四要素：1、根据分工协作、技能要求和工作量定岗定编；2、根据职位评价和市场行情定各岗位薪酬范围；3、根据管理、考核和激励的需要设计薪酬结构；4、根据成本对效益的边际效应来调整经营指标；

计算公式：

基本工资 = 起步工资 x （ 1 + 年递增率 ）^ 工龄年数职务工资 = 最高工资级别 - 级差

绩效工资 = 当月营业额 x 该部门最高提成比例 / 级别福利补贴 = 基本工资 x 福利补贴比率

部门类别

A类：高层决策管理人员，对公司发展起重要作用B类：生产销售一线人员，是产生效益的关键部门C类：生产销售辅助人员，对生产效益有重要影响D类：后勤和辅助管理人员，维持经营的正常运行