Challenge your self 5-3 (EXCEL)
1 17 19 20 23 30 31 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
A B C D E F G H I OrderDate Region Sales Person Shoe # of Pairs Price Per Pair Total Sale
7/19/2016 Oregon Smith Sperry 82 68.99$ 5,657.18$ 7/11/2016 Oregon Green Sperry 106 68.99$ 7,312.94$ 7/2/2016 Oregon Gill Sperry 93 68.99$ 6,416.07$ 6/7/2016 Oregon Andrews Sperry 114 48.92$ 5,576.88$ 5/4/2016 Oregon Jardine Sperry 156 48.92$ 7,631.52$
3/22/2016 Oregon Morgan Sperry 89 8.99$ 800.11$ Total 106.666667 52.30$ 33,394.70$
Shoe
Avone
Darla
Flip
Gracie
Sperry
$‐
$10,000.00
3/22/2016 4/22/2016 5/22/2016 6/22/2016
Total SaleSOLUTION SAMPLE
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
A B C D E F G H I J
Row Labels Average of Price Per Pair California 50.68$
Avone 58.97$ Darla 29.32$ Gracie 61.99$ Sperry 59.97$
Oregon 42.10$ Avone 68.99$ Darla 30.71$ Flip 12.50$ Gracie 45.42$ Sperry 52.30$
Washington 52.43$ Avone 61.99$ Flip 10.35$ Gracie 52.22$ Sperry 68.99$
Grand Total 46.61$
$‐
$10.00
$20.00
$30.00
$40.00
$50.00
$60.00
$70.00
$80.00
Avone Darla GracieSperryAvone Darla Flip GracieSperryAvone Flip GracieSperry
California Oregon Washington
Region Shoe
Average of Price Per Pair
SOLUTION SAMPLE
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
A B C D E F
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$
Sales by Region
Region 1 17%
Region 2 7%
Region 3 29%
Region 4 47%
SperrySOLUTION SAMPLE
1 2 3 4 5 6 7 8 9 10 11 12 13 14
A B C D E F G Sales 15,000.00$ Student Loan 8,000.00$
Minimum Commission Rate 5% Rate Commission Commission 8,000.00$ 5% 750.00$
5.50% 825.00$ Sales Goal 160,000.00$ 6% 900.00$
6.50% 975.00$ 7% 1,050.00$
7.50% 1,125.00$ 8% 1,200.00$
8.50% 1,275.00$ 9% 1,350.00$
9.50% 1,425.00$ 10% 1,500.00$ SOLUTION SAMPLE