| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | Sales Rep | Base Salary | Commissions | Net Salary | ||||
8 | ||||||||
9 | SR1 | $4,000.00 | $1,508.00 | $5,508.00 | ||||
10 | SR2 | $4,500.00 | $1,824.00 | $6,324.00 | ||||
11 | SR3 | $3,500.00 | $1,155.00 | $4,655.00 | Commission Rate Table | |||
12 | SR4 | $3,000.00 | $1,361.00 | $4,361.00 | ||||
13 | SR5 | $4,000.00 | $1,212.00 | $5,212.00 | From | To | Rate | |
14 | SR6 | $4,500.00 | $991.00 | $5,491.00 | $0 | $100 | 0.0% | |
15 | SR7 | $3,500.00 | $1,687.00 | $5,187.00 | $101 | $399 | 5.0% | |
16 | SR8 | $3,000.00 | $1,838.00 | $4,838.00 | $400 | $699 | 7.0% | |
17 | SR9 | $4,000.00 | $840.00 | $4,840.00 | $700 | $999 | 10.0% | |
18 | SR10 | $4,500.00 | $814.00 | $5,314.00 | $1,000 | $9,999,999 | 12.0% | |
19 | Total | $13,230.00 | $51,730.00 | |||||
20 | ||||||||
33 | Date | Order # | Sales Rep | Revenue | Cost | Commission | ||
34 | Rate | Amount | ||||||
35 | SR1 | $100.00 | $11.32 | 0.0% | $0.00 | |||
36 | SR1 | $200.00 | $14.42 | 5.0% | $10.00 | |||
37 | SR2 | $300.00 | $13.03 | 5.0% | $15.00 | |||
38 | SR3 | $400.00 | $6.94 | 5.0% | $20.00 | |||
39 | SR2 | $500.00 | $7.63 | 7.0% | $35.00 | |||
40 | SR4 | $600.00 | $12.68 | 7.0% | $42.00 | |||
41 | SR5 | $700.00 | $11.95 | 7.0% | $49.00 | |||
42 | SR1 | $800.00 | $24.41 | 10.0% | $80.00 | |||
43 | SR6 | $900.00 | $42.03 | 10.0% | $90.00 | |||
44 | SR7 | $1,000.00 | $39.95 | 10.0% | $100.00 | |||
45 | SR8 | $100.00 | $15.49 | 0.0% | $0.00 | |||
46 | SR9 | $200.00 | $8.92 | 5.0% | $10.00 | |||
47 | SR10 | $300.00 | $9.94 | 5.0% | $15.00 | |||
48 | SR1 | $400.00 | $7.49 | 5.0% | $20.00 | |||
49 | SR7 | $500.00 | $5.04 | 7.0% | $35.00 | |||
50 | SR4 | $600.00 | $12.45 | 7.0% | $42.00 | |||
51 | SR8 | $700.00 | $11.32 | 7.0% | $49.00 | |||
52 | SR2 | $800.00 | $14.42 | 10.0% | $80.00 | |||
53 | SR5 | $900.00 | $13.03 | 10.0% | $90.00 | |||
54 | SR1 | $1,000.00 | $6.94 | 10.0% | $100.00 | |||
55 | SR1 | $100.00 | $7.63 | 0.0% | $0.00 | |||
56 | SR6 | $200.00 | $12.68 | 5.0% | $10.00 | |||
57 | SR6 | $300.00 | $11.95 | 5.0% | $15.00 | |||
58 | SR4 | $400.00 | $24.41 | 5.0% | $20.00 | |||
59 | SR3 | $500.00 | $42.03 | 7.0% | $35.00 | |||
60 | SR8 | $600.00 | $39.95 | 7.0% | $42.00 | |||
61 | SR3 | $700.00 | $15.49 | 7.0% | $49.00 | |||
62 | SR6 | $800.00 | $8.92 | 10.0% | $80.00 | |||
63 | SR6 | $900.00 | $9.94 | 10.0% | $90.00 | |||
64 | SR2 | $1,000.00 | $7.49 | 10.0% | $100.00 | |||
65 | SR6 | $100.00 | $5.04 | 0.0% | $0.00 | |||
66 | SR7 | $200.00 | $12.45 | 5.0% | $10.00 | |||
67 | SR2 | $300.00 | $11.32 | 5.0% | $15.00 | |||
68 | SR7 | $400.00 | $14.42 | 5.0% | $20.00 | |||
69 | SR3 | $500.00 | $13.03 | 7.0% | $35.00 | |||
70 | SR8 | $600.00 | $6.94 | 7.0% | $42.00 | |||
71 | SR4 | $700.00 | $7.63 | 7.0% | $49.00 | |||
72 | SR2 | $800.00 | $12.68 | 10.0% | $80.00 | |||
73 | SR3 | $900.00 | $11.95 | 10.0% | $90.00 | |||
74 | SR1 | $1,000.00 | $24.41 | 10.0% | $100.00 | |||
75 | SR6 | $100.00 | $42.03 | 0.0% | $0.00 | |||
76 | SR4 | $200.00 | $39.95 | 5.0% | $10.00 | |||
77 | SR3 | $300.00 | $15.49 | 5.0% | $15.00 | |||
78 | SR7 | $400.00 | $8.92 | 5.0% | $20.00 | |||
79 | SR7 | $500.00 | $9.94 | 7.0% | $35.00 | |||
80 | SR7 | $600.00 | $7.49 | 7.0% | $42.00 | |||
81 | SR8 | $700.00 | $5.04 | 7.0% | $49.00 | |||
82 | SR1 | $800.00 | $12.45 | 10.0% | $80.00 | |||
83 | SR6 | $900.00 | $11.32 | 10.0% | $90.00 | |||
84 | SR4 | $1,000.00 | $14.42 | 10.0% | $100.00 | |||
85 | SR7 | $100.00 | $13.03 | 0.0% | $0.00 | |||
86 | SR6 | $200.00 | $6.94 | 5.0% | $10.00 | |||
87 | SR1 | $300.00 | $7.63 | 5.0% | $15.00 | |||
88 | SR1 | $400.00 | $12.68 | 5.0% | $20.00 | |||
89 | SR8 | $500.00 | $11.95 | 7.0% | $35.00 | |||
90 | SR1 | $600.00 | $24.41 | 7.0% | $42.00 | |||
91 | SR1 | $700.00 | $42.03 | 7.0% | $49.00 | |||
92 | SR8 | $800.00 | $39.95 | 10.0% | $80.00 | |||
93 | SR9 | $900.00 | $15.49 | 10.0% | $90.00 | |||
94 | SR5 | $1,000.00 | $8.92 | 10.0% | $100.00 | |||
95 | SR10 | $100.00 | $9.94 | 0.0% | $0.00 | |||
96 | SR3 | $200.00 | $7.49 | 5.0% | $10.00 | |||
97 | SR4 | $300.00 | $5.04 | 5.0% | $15.00 | |||
98 | SR9 | $400.00 | $12.45 | 5.0% | $20.00 | |||
99 | SR4 | $500.00 | $11.32 | 7.0% | $35.00 | |||
100 | SR10 | $600.00 | $14.42 | 7.0% | $42.00 | |||
101 | SR4 | $700.00 | $13.03 | 7.0% | $49.00 | |||
102 | SR2 | $800.00 | $6.94 | 10.0% | $80.00 | |||
103 | SR6 | $900.00 | $7.63 | 10.0% | $90.00 | |||
104 | SR2 | $1,000.00 | $12.68 | 10.0% | $100.00 | |||
105 | SR10 | $100.00 | $11.95 | 0.0% | $0.00 | |||
106 | SR6 | $200.00 | $24.41 | 5.0% | $10.00 | |||
107 | SR8 | $300.00 | $42.03 | 5.0% | $15.00 | |||
108 | SR8 | $400.00 | $39.95 | 5.0% | $20.00 | |||
109 | SR6 | $500.00 | $15.49 | 7.0% | $35.00 | |||
110 | SR2 | $600.00 | $8.92 | 7.0% | $42.00 | |||
111 | SR3 | $700.00 | $9.94 | 7.0% | $49.00 | |||
112 | SR1 | $800.00 | $7.49 | 10.0% | $80.00 | |||