B
C
D
E
F
G
H
4
Ann Sales
Comm
Delta
5
$ 0
1.00%
1.00%
 D5: =C5 - N(C4)
6
$ 1,045,000
2.25%
1.25%
7
$ 1,567,500
3.50%
1.25%
8
$ 1,881,000
5.66%
2.16%
9
$ 2,090,001
7.36%
1.70%
10
11
Month
Sales
Cumu Sales
Comm
Eff Rate
12
Apr
$ 171,000
$ 171,000
$ 1,710
1.00%
 D12: =N(D11)+C12
13
May
$ 1,800,000
$ 1,971,000
$ 36,563
2.03%
 E12: =SUMPRODUCT( (D12 > $B$5:$B$9) * (D12 - $B$5:$B$9) * $D$5:$D$9) - SUM(E$11:E11)
14
Jun
$ 180,000
$ 2,151,000
$ 11,225
6.24%
 F12: =E12/C12
15
Jul
$ 1,800,000
$ 3,951,000
$ 132,480
7.36%
16
Aug
$ 186,010
$ 4,137,010
$ 13,690
7.36%
17
Sep
$ 179,740
$ 4,316,750
$ 13,229
7.36%
18
Oct
$ 177,650
$ 4,494,400
$ 13,075
7.36%
19
Nov
$ 163,020
$ 4,657,420
$ 11,998
7.36%
20
Dec
$ 169,290
$ 4,826,710
$ 12,460
7.36%
21
Jan
$ 175,560
$ 5,002,270
$ 12,921
7.36%
22
Feb
$ 177,650
$ 5,179,920
$ 13,075
7.36%
23
Mar
$ 612,730
$ 5,792,650
$ 45,097
7.36%
24
Total:
$ 317,523