《销售提成计算分析表.xlsx》由会员分享,可在线阅读,更多相关《销售提成计算分析表.xlsx(2页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、销售提成计算分析表员工编号员工姓名总销售量总销售额销售业绩提成率NQ0001张三3003,000.005%NQ0002李四6006,000.008%NQ0003刘柳9009,000.0010%NQ0004陆路120012,000.0012%NQ0005王五560056,000.0025%NQ0006小散230023,000.0025%NQ0007八士340034,000.0025%5%8%10%12%25%25%25%提成率张三李四刘柳陆路王五小散八士0%5%10%15%20%25%30%3,000.006,000.009,000.0012,000.0056,000.0023,000.0034
2、,000.00销售额张三李四刘柳陆路王五小散八士-10,000.00 20,000.00 30,000.00 40,000.00 50,000.00 60,000.00 提成额销售金额区间提成率150.00-3,000.005%480.003,001.006,000.008%900.006,001.009,000.0010%1,440.009,001.0012,000.0012%14,000.0012,001.0015,000.0015%5,750.0015,001.0018,000.0020%8,500.0018,001.0025%0%2%3%5%45%18%27%提成额张三李四刘柳陆路王五小散八士销售提成计算分析表3,000.006,000.009,000.0012,000.0056,000.0023,000.0034,000.00销售额张三李四刘柳陆路王五小散八士-10,000.00 20,000.00 30,000.00 40,000.00 50,000.00 60,000.00