Excel 2013 Skills Approach - 5.3
nklum1
-ex2013-challengeyourself-5-3.xlsx
Sales
| OrderDate | Region | Sales Person | Shoe | # of Pairs | Price Per Pair | Total Sale |
| 3/15/15 | Washington | Vosburger | Avone | 204 | $ 61.99 | $ 12,645.96 |
| 10/13/14 | California | Howard | Avone | 282 | $ 48.92 | $ 13,795.44 |
| 4/26/14 | California | Jarez | Avone | 274 | $ 68.99 | $ 18,903.26 |
| 4/9/14 | California | Jones | Avone | 190 | $ 58.99 | $ 1,708.10 |
| 8/14/13 | Oregon | Gill | Avone | 199 | $ 68.99 | $ 13,729.01 |
| 3/6/14 | California | Jones | Darla | 136 | $ 35.99 | $ 4,894.64 |
| 1/6/15 | Oregon | Morgan | Darla | 439 | $ 12.49 | $ 5,483.11 |
| 1/6/15 | Oregon | Morgan | Darla | 439 | $ 12.49 | $ 5,483.11 |
| 9/9/14 | Oregon | Jardine | Darla | 278 | $ 48.92 | $ 13,599.76 |
| 6/16/14 | California | Jarez | Darla | 253 | $ 15.99 | $ 4,045.47 |
| 5/13/14 | Oregon | Green | Darla | 304 | $ 48.92 | $ 14,871.68 |
| 3/6/14 | California | Jones | Darla | 136 | $ 35.99 | $ 4,894.64 |
| 2/9/15 | Washington | Vosburger | Flip | 390 | $ 10.35 | $ 4,036.50 |
| 12/3/14 | Oregon | Green | Flip | 229 | $ 12.50 | $ 2,862.50 |
| 2/17/14 | Oregon | Smith | Flip | 62 | $ 12.50 | $ 775.00 |
| 10/30/14 | Oregon | Gill | Gracie | 263 | $ 29.00 | $ 7,627.00 |
| 5/30/14 | Oregon | Smith | Gracie | 261 | $ 38.29 | $ 9,993.69 |
| 12/11/13 | Oregon | Morgan | Gracie | 229 | $ 48.92 | $ 11,202.68 |
| 11/7/13 | Washington | Thompson | Gracie | 242 | $ 61.99 | $ 15,001.58 |
| 10/4/13 | Oregon | Andrews | Gracie | 287 | $ 61.99 | $ 17,791.13 |
| 8/31/13 | Washington | Vosburger | Gracie | 251 | $ 47.34 | $ 11,882.34 |
| 7/28/13 | Oregon | Jardine | Gracie | 146 | $ 48.92 | $ 7,142.32 |
| 8/31/13 | Washington | Vosburger | Gracie | 251 | $ 47.34 | $ 11,882.34 |
| 6/24/13 | California | Jones | Gracie | 231 | $ 61.99 | $ 14,319.69 |
| 6/8/15 | Oregon | Andrews | Sperry | 28 | $ 48.92 | $ 1,369.76 |
| 5/5/15 | Oregon | Jardine | Sperry | 227 | $ 48.92 | $ 11,104.84 |
| 4/1/15 | Washington | Thompson | Sperry | 96 | $ 68.99 | $ 6,623.04 |
| 8/23/14 | Washington | Vosburger | Sperry | 236 | $ 68.99 | $ 16,281.64 |
| 7/20/14 | Oregon | Smith | Sperry | 237 | $ 68.99 | $ 16,350.63 |
| 7/3/14 | Oregon | Gill | Sperry | 260 | $ 68.99 | $ 17,937.40 |
| 3/23/14 | Oregon | Morgan | Sperry | 171 | $ 8.99 | $ 1,537.29 |
| 1/14/14 | California | Jarez | Sperry | 153 | $ 68.99 | $ 10,555.47 |
| 12/28/13 | California | Howard | Sperry | 226 | $ 61.99 | $ 14,009.74 |
| 9/17/13 | California | Jones | Sperry | 300 | $ 48.92 | $ 14,676.00 |
| 7/11/13 | Oregon | Green | Sperry | 149 | $ 68.99 | $ 10,279.51 |
By Region
| Q1 Sales by Region |
| | Region 1 | Region 2 | Region 3 | Region 4 |
| Sperry | $ 499,566 | $ 56,412 | $ 79,544 | $ 254,009 |
| Darla | $ 102,809 | $ 708,666 | $ 509,347 | $ 672,433 |
| Avone | $ 97,632 | $ 532,106 | $ 52,999 | $ 400,209 |
| Gracie | $ 102,966 | $ 400,309 | $ 146,943 | $ 70,321 |
| Flip | $ 16,201 | $ 79,307 | $ 92,400 | $ 899,300 |
Commission
| Sales | $ 10,000.00 | | | | Student Loan | $ 12,000.00 |
| | | | | | Minimum Commision Rate | 5% |
| Rate | Commission | | | | Commission | $ 500.00 |
| 5% | $ 500.00 |
| 5.50% | | | | | Sales Goal | $ 10,000.00 |
| 6% |
| 6.50% |
| 7% |
| 7.50% |
| 8% |
| 8.50% |
| 9% |
| 9.50% |
| 10% |
