销售提成计算分析表

销售提成计算分析表员工编号员工姓名总销售量总销售额销售业绩提成率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%张三李四刘柳陆路王五小散八士0%10%20%30%5%8%10%12%25%25%25%提成率张三李四刘柳陆路王五小散八士-10,000.0020,000.0030,000.0040,000.0050,000.0060,000.003,000.006,000.009,000.0012,000.0056,000.0023,000.0034,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%提成额张三李四刘柳陆路王五小散八士四刘柳陆路王五小散八士009,000.0012,000.0056,000.0023,000.0034,000.00销售额