《简约蓝销售奖金提成计算(1).xlsx》由会员分享，可在线阅读，更多相关《简约蓝销售奖金提成计算(1).xlsx（12页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、首页计算业绩设置奖金提成计算表提提成成计计算算销销售售业业绩绩说明# 22:36:09提提成成设设置置使使用用说说明明提提成成计计算算销销售售业业绩绩首页业绩设置说明工资计算表员工编号员工姓名基本薪资目标完成率350000贾图4,800.00122.8%350001张三11,000.0079.3%350002李四6,200.00174.9%350003王五8,100.0066.7%350004任六5,000.0055.1%350005孙七3,000.00106.8%350006郑八7,500.0086.1%350007李九5,500.0085.3%350008武十4,200.00112.4%3
2、50009司马一6,300.0071.4%350010东方二9,700.00118.1%350011张二11,300.0066.3%350012令狐四5,700.0049.3%350013周一6,900.0094.7%350014刘三10,800.00123.6%350015欧阳五5,700.00165.9%350016宋七3,200.00107.6%350017彭十三3,200.00144.4%350018关雨6,000.0083.9%350019曹方3,400.00165.5%350020诸葛八5,400.00147.0%350021朱加6,600.00174.9%350022唐一5,80
3、0.00131.2%350023牛六8,300.0042.5%350024邓五6,200.00174.2%350025吴雨6,600.00116.7%350026徐师10,600.00144.0%350027郭达10,700.0044.6%350028王如4,100.0059.7%350029杨静8,600.0068.3%350030昂清9,500.0090.0%提成奖金其他奖金业绩考核扣款薪资合计（税前）2,736.6017.00264.007,817.60-207.49257.0024.0011,073.5120,225.7086.0024.0026,535.70-666.806.00-6
4、6.007,373.20-1,346.16-103.00-57.003,493.84410.82-89.00-200.003,121.820.0043.00-80.007,463.000.00121.00-18.005,603.001,114.9252.00107.005,473.92-285.5312.00-145.005,881.471,625.76220.00-200.0011,345.76-674.62103.00134.0010,862.38-2,026.04294.00162.004,129.96157.83293.00-155.007,195.832,830.56186.00-2
5、.0013,814.5615,806.88-82.0058.0021,482.88456.84164.00128.003,948.847,983.18-84.00-113.0010,986.180.00-136.00257.006,121.0015,716.64133.0029.0019,278.648,460.90217.00-5.0014,072.9020,215.71-131.00-5.0026,679.714,678.95-60.00150.0010,568.95-2,300.8410.00159.006,168.1620,026.17-12.00113.0026,327.171,50
6、2.28-106.00268.008,264.287,918.2088.00226.0018,832.20-2,214.6065.00100.008,650.40-1,209.30-28.0030.002,892.70-633.4655.00-130.007,891.54299.58-142.00-75.009,582.58工资计算表首页计算设置说明销售业绩员工编号员工姓名销售目标实际销售350000贾图100000122805350001张三10000079251350002李四100000174910350003王五10000066660350004任六10000055128350005孙
7、七100000106847350006郑八10000086135350007李九10000085295350008武十100000112388350009司马一10000071447350010东方二100000118064350011张二10000066269350012令狐四10000049349350013周一10000094739350014刘三100000123588350015欧阳五100000165862350016宋七100000107614350017彭十三100000144351350018关雨10000083866350019曹方100000165486350020诸葛八
8、100000147005350021朱加100000174873350022唐一100000131193350023牛六10000042479350024邓五100000174171350025吴雨100000116692350026徐师100000143990350027郭达10000044635350028王如10000059690350029杨静10000068327350030昂清10000090014目标完成率122.8%79.3%174.9%66.7%55.1%106.8%86.1%85.3%112.4%71.4%118.1%66.3%49.3%94.7%123.6%165.9%1
9、07.6%144.4%83.9%165.5%147.0%174.9%131.2%42.5%174.2%116.7%144.0%44.6%59.7%68.3%90.0%首页计算业绩说明提成分档目标完成率提成比例(超出部分)10%-7%20%-6%30%-5%40%-4%50%-3%60%-2%70%-1%80%0%90%3%100%6%110%9%120%12%130%15%140%18%150%21%160%24%170%27%180%30%190%33%200%36%210%39%首页计算业绩设置使用说明提成计算员工编号员工姓名基本薪资目标完成率请输入请输入请输入自动索引销售业绩员工编号员工姓名销售目标实际销售请输入请输入请输入请输入提成设置目标完成率提成比例(超出部分)请设置请设置说明：设置目标完成率以及相应的提成比例。默认10%为一档，若改变，请改变表“提成计算”中的计算方式。提成奖金其他奖金业绩考核扣款薪资合计（税前）自动计算请输入请输入自动计算目标完成率自动计算说明：提成分档设置：不要更改每10%一档，若改变，则相应改变提成奖金的计算方式；说明：添加员工信息时，保证和表“提成计算”中信息一致更新。使用说明