销售提成计算分析表员工编号员工姓名总销售量总销售额销售业绩提成率NQ0001张三300 3,000.00 5%NQ0002李四600 6,000.00 8%NQ0003刘柳900 9,000.00 10%NQ0004陆路1200 12,000.00 12%NQ0005王五5600 56,000.00 25%NQ0006小散2300 23,000.00 25%NQ0007八士3400 34,000.00 25%张三李四刘柳陆路王五小散八士0%10%20%30%5%8%10%12%25%25%25%提成率张三李四刘柳陆路王五小散八士 - 10,000.00 20,000.00 30,000.00 40,000.00 50,000.00 60,000.00 3,000.00 6,000.00 9,000.00 12,000.00 56,000.00 23,000.00 34,000.00 销售额销售提成计算分析表 提成额 销售金额区间 提成率 150.00 - 3,000.00 5% 480.00 3,001.00 6,000.00 8% 900.00 6,001.00 9,000.00 10% 1,440.00 9,001.00 12,000.00 12% 14,000.00 12,001.00 15,000.00 15% 5,750.00 15,001.00 18,000.00 20% 8,500.00 18,001.00 25%0%2%3%5%45%18%27%提成额张三李四刘柳陆路王五小散八士张三李四刘柳陆路王五小散八士 - 10,000.00 20,000.00 30,000.00 40,000.00 50,000.00 60,000.00 3,000.00 6,000.00 9,000.00 12,000.00 56,000.00 23,000.00 34,000.00 销售额