com sci simnet excel

profileKelly111
Xiaotong.Chen-EX2016-ChallengeYourself-5-3.xlsx

Sales

OrderDate Region Sales Person Shoe # of Pairs Price Per Pair Total Sale
10/12/16 California Howard Avone 278 $ 48.92 $ 13,599.76
8/14/16 Oregon Gill Avone 197 $ 68.99 $ 13,591.03
4/25/16 California Jarez Avone 226 $ 68.99 $ 15,591.74
4/8/16 California Jones Avone 233 $ 58.99 $ 13,744.67
3/14/16 Washington Vosburger Avone 92 $ 61.99 $ 5,703.08
9/8/16 Oregon Jardine Darla 9999 $ 48.92 $ 489,151.08
6/15/16 California Jarez Darla 110 $ 15.99 $ 1,758.90
5/12/16 Oregon Green Darla 90 $ 48.92 $ 4,402.80
3/5/16 California Jones Darla 78 $ 35.99 $ 2,807.22
3/5/16 California Jones Darla 267 $ 35.99 $ 9,609.33
1/5/16 Oregon Morgan Darla 153 $ 12.49 $ 1,910.97
1/5/16 Oregon Morgan Darla 173 $ 12.49 $ 2,160.77
12/2/16 Oregon Green Flip 212 $ 12.50 $ 2,650.00
2/17/16 Oregon Smith Flip 74 $ 12.50 $ 925.00
2/8/16 Washington Vosburger Flip 97 $ 10.35 $ 1,003.95
12/11/16 Oregon Morgan Gracie 175 $ 48.92 $ 8,561.00
12/11/16 Oregon Morgan Gracie 175 $ 48.92 $ 8,561.00
11/7/16 Washington Thompson Gracie 277 $ 61.99 $ 17,171.23
10/29/16 Oregon Gill Gracie 220 $ 29.00 $ 6,380.00
10/4/16 Oregon Andrews Gracie 72 $ 61.99 $ 4,463.28
8/31/16 Washington Vosburger Gracie 260 $ 47.34 $ 12,308.40
8/31/16 Washington Vosburger Gracie 107 $ 47.34 $ 5,065.38
7/28/16 Oregon Jardine Gracie 214 $ 48.92 $ 10,468.88
6/24/16 California Jones Gracie 145 $ 61.99 $ 8,988.55
5/29/16 Oregon Smith Gracie 88 $ 38.29 $ 3,369.52
12/28/16 California Howard Sperry 114 $ 61.99 $ 7,066.86
9/17/16 California Jones Sperry 103 $ 48.92 $ 5,038.76
8/22/16 Washington Vosburger Sperry 74 $ 68.99 $ 5,105.26
8/22/16 Washington Vosburger Sperry 74 $ 68.99 $ 5,105.26
7/19/16 Oregon Smith Sperry 82 $ 68.99 $ 5,657.18
7/11/16 Oregon Green Sperry 106 $ 68.99 $ 7,312.94
7/11/16 Oregon Green Sperry 106 $ 68.99 $ 7,312.94
7/2/16 Oregon Gill Sperry 93 $ 68.99 $ 6,416.07
6/7/16 Oregon Andrews Sperry 114 $ 48.92 $ 5,576.88
5/4/16 Oregon Jardine Sperry 156 $ 48.92 $ 7,631.52
3/31/16 Washington Thompson Sperry 124 $ 68.99 $ 8,554.76
3/22/16 Oregon Morgan Sperry 89 $ 8.99 $ 800.11
1/14/16 California Jarez Sperry 226 $ 68.99 $ 15,591.74
1/14/16 California Jarez Sperry 226 $ 68.99 $ 15,591.74

By Region

Sales by Region
Region 1 Region 2 Region 3 Region 4
Sperry $ 221,878 $ 88,774 $ 375,592 $ 622,464
Darla $ 767,155 $ 759,050 $ 558,981 $ 584,668
Avone $ 710,851 $ 104,069 $ 320,384 $ 366,123
Gracie $ 298,280 $ 588,153 $ 273,828 $ 889,863
Flip $ 742,627 $ 707,935 $ 426,957 $ 247,900

Commission

Sales $ 15,000.00 Student Loan $ 8,000.00
Minimum Commission Rate 5%
Rate Commission Commission $ 500.00
5% $ 750.00
5.50% Sales Goal $ 10,000.00
6%
6.50%
7%
7.50%
8%
8.50%
9%
9.50%
10%