sales-commissions-fixed-revenue.xlsx

	A	B	C	D	E	F	G	H	I
1	Date	Customer	Order #	Revenue	Sales Rep	Commission Rate	Commission Amount	Deductions	Payout
2	1/1/2019	Alpha Software	i-100001	$202.33	Jimena Carrillo	4%	$8.09	$0.00	$8.09
3	1/2/2019	Soul Solutions	i-100002	$592.22	Emma Ford	4%	$23.69	$0.00	$23.69
4	1/3/2019	Ironavigation	i-100003	$59.44	Lily Grant	6%	$3.57	$0.00	$3.57
5	1/4/2019	Ironavigation	i-100004	$283.33	Jamie Webb	5%	$14.17	$0.00	$14.17
6	1/5/2019	Soul Solutions	i-100005	$19.00	Jamie Webb	4.50%	$0.86	$0.00	$0.86
7	1/6/2019	Alpire	i-100006	$43.03	Emma Ford	5%	$2.15	$0.00	$2.15
8	1/7/2019	Oystertainment	i-100007	$23.34	Jimena Carrillo	5%	$1.17	$0.00	$1.17
9	1/8/2019	Titanium Systems	i-100008	$230.30	Lily Grant	6%	$13.82	$0.00	$13.82
10	1/9/2019	Surprise Media	i-100009	$430.33	Lily Grant	4%	$17.21	$5.25	$11.96
11	1/10/2019	Apexshow	i-100010	$492.32	Emma Ford	4%	$19.69	$0.00	$19.69
12	1/11/2019	Oystertainment	i-100011	$230.23	Lily Grant	4%	$9.21	$0.00	$9.21
13	1/12/2019	Rush Inc.	i-100012	$85.44	Jimena Carrillo	6%	$5.13	$0.00	$5.13
14	1/13/2019	Titanium Systems	i-100013	$79.92	Emma Ford	5%	$4.00	$0.00	$4.00
15	1/14/2019	Apexshow	i-100014	$82.99	Jimena Carrillo	5%	$4.15	$0.00	$4.15
16	1/15/2019	Ironavigation	i-100015	$72.02	Lily Grant	5%	$3.60	$0.00	$3.60
17	1/16/2019	Oystertainment	i-100016	$84.95	Emma Ford	4.50%	$3.82	$0.00	$3.82
18
19
20						Sales Rep	Sum of Payout
21						Emma Ford	$53.35
22						Jamie Webb	$15.02
23						Jimena Carrillo	$18.54
24						Lily Grant	$42.16
25						Grand Total	$129.07
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100