| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Segment | Country | Product | Discount Band | Units Sold | Manufacturing Price | Sale Price | Gross Sales | Discounts | Sales | COGS | Profit | Date | Month Number | Month Name | Year | helper | |||||||||
2 | Government | Germany | Carretera | None | 1513 | 3 | 350 | 529550 | 0 | 529550 | 393380 | 136170 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
3 | Government | Germany | Paseo | None | 1006 | 10 | 350 | 352100 | 0 | 352100 | 261560 | 90540 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
4 | Government | Canada | Paseo | None | 1725 | 10 | 350 | 603750 | 0 | 603750 | 448500 | 155250 | 1-Nov-13 | 11 | November | 2013 | 20 | |||||||||
5 | Government | Germany | Paseo | None | 1513 | 10 | 350 | 529550 | 0 | 529550 | 393380 | 136170 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
6 | Government | Germany | Velo | None | 1006 | 120 | 350 | 352100 | 0 | 352100 | 261560 | 90540 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
7 | Government | France | VTT | None | 1527 | 250 | 350 | 534450 | 0 | 534450 | 397020 | 137430 | 1-Sep-13 | 9 | September | 2013 | 20 | |||||||||
8 | Government | France | Amarilla | None | 2750 | 260 | 350 | 962500 | 0 | 962500 | 715000 | 247500 | 1-Feb-14 | 2 | February | 2014 | 20 | |||||||||
9 | Government | Mexico | Carretera | Low | 1210 | 3 | 350 | 423500 | 4235 | 419265 | 314600 | 104665 | 1-Mar-14 | 3 | March | 2014 | 20 | |||||||||
10 | Government | Mexico | Carretera | Low | 1397 | 3 | 350 | 488950 | 4889.5 | 484060.5 | 363220 | 120840.5 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
11 | Government | France | Carretera | Low | 2155 | 3 | 350 | 754250 | 7542.5 | 746707.5 | 560300 | 186407.5 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
12 | Government | France | Paseo | Low | 2155 | 10 | 350 | 754250 | 7542.5 | 746707.5 | 560300 | 186407.5 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
13 | Government | Canada | VTT | Low | 943.5 | 250 | 350 | 330225 | 3302.25 | 326922.75 | 245310 | 81612.75 | 1-Apr-14 | 4 | April | 2014 | 20 | |||||||||
14 | Government | Mexico | VTT | Low | 1397 | 250 | 350 | 488950 | 4889.5 | 484060.5 | 363220 | 120840.5 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
15 | Government | Canada | Carretera | Low | 2852 | 3 | 350 | 998200 | 19964 | 978236 | 741520 | 236716 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
16 | Government | Canada | Paseo | Low | 2852 | 10 | 350 | 998200 | 19964 | 978236 | 741520 | 236716 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
17 | Government | Germany | Velo | Low | 2966 | 120 | 350 | 1038100 | 20762 | 1017338 | 771160 | 246178 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
18 | Government | Germany | Velo | Low | 2877 | 120 | 350 | 1006950 | 20139 | 986811 | 748020 | 238791 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
19 | Government | Germany | VTT | Low | 2877 | 250 | 350 | 1006950 | 20139 | 986811 | 748020 | 238791 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
20 | Government | United States of America | VTT | Low | 266 | 250 | 350 | 93100 | 1862 | 91238 | 69160 | 22078 | 1-Dec-13 | 12 | December | 2013 | 20 | |||||||||
21 | Government | Mexico | VTT | Low | 1940 | 250 | 350 | 679000 | 13580 | 665420 | 504400 | 161020 | 1-Dec-13 | 12 | December | 2013 | 20 | |||||||||
22 | Government | Germany | Amarilla | Low | 2966 | 260 | 350 | 1038100 | 20762 | 1017338 | 771160 | 246178 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
23 | Government | Germany | Montana | Low | 1797 | 5 | 350 | 628950 | 18868.5 | 610081.5 | 467220 | 142861.5 | 1-Sep-13 | 9 | September | 2013 | 20 | |||||||||
24 | Government | Mexico | VTT | Low | 1642 | 250 | 350 | 574700 | 17241 | 557459 | 426920 | 130539 | 1-Aug-14 | 8 | August | 2014 | 20 | |||||||||
25 | Government | United States of America | Carretera | Low | 274 | 3 | 350 | 95900 | 3836 | 92064 | 71240 | 20824 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
26 | Government | United States of America | Paseo | Low | 3450 | 10 | 350 | 1207500 | 48300 | 1159200 | 897000 | 262200 | 1-Jul-14 | 7 | July | 2014 | 20 | |||||||||
27 | Government | United States of America | Paseo | Low | 274 | 10 | 350 | 95900 | 3836 | 92064 | 71240 | 20824 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
28 | Government | France | Velo | Low | 2177 | 120 | 350 | 761950 | 30478 | 731472 | 566020 | 165452 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
29 | Government | United States of America | VTT | Low | 349 | 250 | 350 | 122150 | 4886 | 117264 | 90740 | 26524 | 1-Sep-13 | 9 | September | 2013 | 20 | |||||||||
30 | Government | France | VTT | Low | 2177 | 250 | 350 | 761950 | 30478 | 731472 | 566020 | 165452 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
31 | Government | Mexico | Amarilla | Low | 1865 | 260 | 350 | 652750 | 26110 | 626640 | 484900 | 141740 | 1-Feb-14 | 2 | February | 2014 | 20 | |||||||||
32 | Government | Germany | Amarilla | Low | 1907 | 260 | 350 | 667450 | 26698 | 640752 | 495820 | 144932 | 1-Sep-14 | 9 | September | 2014 | 20 | |||||||||
33 | Government | Canada | Amarilla | Low | 1778 | 260 | 350 | 622300 | 24892 | 597408 | 462280 | 135128 | 1-Dec-13 | 12 | December | 2013 | 20 | |||||||||
34 | Government | France | Montana | Medium | 1384.5 | 5 | 350 | 484575 | 24228.75 | 460346.25 | 359970 | 100376.25 | 1-Jan-14 | 1 | January | 2014 | 20 | |||||||||
35 | Government | Mexico | Montana | Medium | 720 | 5 | 350 | 252000 | 12600 | 239400 | 187200 | 52200 | 1-Sep-13 | 9 | September | 2013 | 20 | |||||||||
36 | Government | United States of America | Paseo | Medium | 602 | 10 | 350 | 210700 | 10535 | 200165 | 156520 | 43645 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
37 | Government | Canada | Paseo | Medium | 1228 | 10 | 350 | 429800 | 21490 | 408310 | 319280 | 89030 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
38 | Government | United States of America | Velo | Medium | 602 | 120 | 350 | 210700 | 10535 | 200165 | 156520 | 43645 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
39 | Government | Germany | Amarilla | Medium | 1350 | 260 | 350 | 472500 | 23625 | 448875 | 351000 | 97875 | 1-Feb-14 | 2 | February | 2014 | 20 | |||||||||
40 | Government | Canada | Amarilla | Medium | 552 | 260 | 350 | 193200 | 9660 | 183540 | 143520 | 40020 | 1-Aug-14 | 8 | August | 2014 | 20 | |||||||||
41 | Government | Canada | Amarilla | Medium | 1228 | 260 | 350 | 429800 | 21490 | 408310 | 319280 | 89030 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
42 | Government | Mexico | Montana | Medium | 980 | 5 | 350 | 343000 | 20580 | 322420 | 254800 | 67620 | 1-Apr-14 | 4 | April | 2014 | 20 | |||||||||
43 | Government | Germany | Montana | Medium | 1460 | 5 | 350 | 511000 | 30660 | 480340 | 379600 | 100740 | 1-May-14 | 5 | May | 2014 | 20 | |||||||||
44 | Government | France | Paseo | Medium | 1496 | 10 | 350 | 523600 | 31416 | 492184 | 388960 | 103224 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
45 | Government | United States of America | Paseo | Medium | 727 | 10 | 350 | 254450 | 15267 | 239183 | 189020 | 50163 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
46 | Government | France | Velo | Medium | 1496 | 120 | 350 | 523600 | 31416 | 492184 | 388960 | 103224 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
47 | Government | France | Velo | Medium | 2076 | 120 | 350 | 726600 | 43596 | 683004 | 539760 | 143244 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
48 | Government | Mexico | Amarilla | Medium | 1679 | 260 | 350 | 587650 | 35259 | 552391 | 436540 | 115851 | 1-Sep-14 | 9 | September | 2014 | 20 | |||||||||
49 | Government | United States of America | Amarilla | Medium | 727 | 260 | 350 | 254450 | 15267 | 239183 | 189020 | 50163 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
50 | Government | France | Amarilla | Medium | 2076 | 260 | 350 | 726600 | 43596 | 683004 | 539760 | 143244 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
51 | Government | United States of America | Carretera | Medium | 1761 | 3 | 350 | 616350 | 43144.5 | 573205.5 | 457860 | 115345.5 | 1-Mar-14 | 3 | March | 2014 | 20 | |||||||||
52 | Government | France | Amarilla | Medium | 2876 | 260 | 350 | 1006600 | 70462 | 936138 | 747760 | 188378 | 1-Sep-14 | 9 | September | 2014 | 20 | |||||||||
53 | Government | Mexico | Carretera | Medium | 1362 | 3 | 350 | 476700 | 38136 | 438564 | 354120 | 84444 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
54 | Government | Germany | Paseo | Medium | 2146 | 10 | 350 | 751100 | 60088 | 691012 | 557960 | 133052 | 1-Nov-13 | 11 | November | 2013 | 20 | |||||||||
55 | Government | Mexico | Paseo | Medium | 1362 | 10 | 350 | 476700 | 38136 | 438564 | 354120 | 84444 | 1-Dec-14 | 12 | December | 2014 | 20 | |||||||||
56 | Government | France | VTT | Medium | 574.5 | 250 | 350 | 201075 | 16086 | 184989 | 149370 | 35619 | 1-Apr-14 | 4 | April | 2014 | 20 | |||||||||
57 | Government | France | VTT | Medium | 381 | 250 | 350 | 133350 | 10668 | 122682 | 99060 | 23622 | 1-Aug-14 | 8 | August | 2014 | 20 | |||||||||
58 | Government | Germany | VTT | Medium | 422 | 250 | 350 | 147700 | 11816 | 135884 | 109720 | 26164 | 1-Aug-14 | 8 | August | 2014 | 20 | |||||||||
59 | Government | France | Montana | Medium | 1666 | 5 | 350 | 583100 | 52479 | 530621 | 433160 | 97461 | 1-May-14 | 5 | May | 2014 | 20 | |||||||||
60 | Government | Mexico | Paseo | Medium | 2417 | 10 | 350 | 845950 | 76135.5 | 769814.5 | 628420 | 141394.5 | 1-Jan-14 | 1 | January | 2014 | 20 | |||||||||
61 | Government | Germany | Velo | Medium | 1307 | 120 | 350 | 457450 | 41170.5 | 416279.5 | 339820 | 76459.5 | 1-Jul-14 | 7 | July | 2014 | 20 | |||||||||
62 | Government | Canada | Velo | Medium | 1269 | 120 | 350 | 444150 | 39973.5 | 404176.5 | 329940 | 74236.5 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
63 | Government | United States of America | VTT | Medium | 1351.5 | 250 | 350 | 473025 | 42572.25 | 430452.75 | 351390 | 79062.75 | 1-Apr-14 | 4 | April | 2014 | 20 | |||||||||
64 | Government | United States of America | Amarilla | Medium | 2071 | 260 | 350 | 724850 | 65236.5 | 659613.5 | 538460 | 121153.5 | 1-Sep-14 | 9 | September | 2014 | 20 | |||||||||
65 | Government | Canada | Amarilla | Medium | 1269 | 260 | 350 | 444150 | 39973.5 | 404176.5 | 329940 | 74236.5 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
66 | Government | United States of America | Montana | High | 2313 | 5 | 350 | 809550 | 80955 | 728595 | 601380 | 127215 | 1-May-14 | 5 | May | 2014 | 20 | |||||||||
67 | Government | France | Velo | High | 639 | 120 | 350 | 223650 | 22365 | 201285 | 166140 | 35145 | 1-Jul-14 | 7 | July | 2014 | 20 | |||||||||
68 | Government | United States of America | VTT | High | 2807 | 250 | 350 | 982450 | 98245 | 884205 | 729820 | 154385 | 1-Aug-14 | 8 | August | 2014 | 20 | |||||||||
69 | Government | Germany | VTT | High | 1870 | 250 | 350 | 654500 | 65450 | 589050 | 486200 | 102850 | 1-Dec-13 | 12 | December | 2013 | 20 | |||||||||
70 | Government | Canada | Amarilla | High | 2240 | 260 | 350 | 784000 | 78400 | 705600 | 582400 | 123200 | 1-Feb-14 | 2 | February | 2014 | 20 | |||||||||
71 | Government | Canada | Amarilla | High | 707 | 260 | 350 | 247450 | 24745 | 222705 | 183820 | 38885 | 1-Sep-14 | 9 | September | 2014 | 20 | |||||||||
72 | Government | Germany | Carretera | High | 792 | 3 | 350 | 277200 | 30492 | 246708 | 205920 | 40788 | 1-Mar-14 | 3 | March | 2014 | 20 | |||||||||
73 | Government | Germany | Montana | High | 766 | 5 | 350 | 268100 | 29491 | 238609 | 199160 | 39449 | 1-Jan-14 | 1 | January | 2014 | 20 | |||||||||
74 | Government | Canada | Paseo | High | 2104.5 | 10 | 350 | 736575 | 81023.25 | 655551.75 | 547170 | 108381.75 | 1-Jul-14 | 7 | July | 2014 | 20 | |||||||||
75 | Government | Mexico | Velo | High | 344 | 120 | 350 | 120400 | 13244 | 107156 | 89440 | 17716 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
76 | Government | Mexico | Amarilla | High | 344 | 260 | 350 | 120400 | 13244 | 107156 | 89440 | 17716 | 1-Oct-13 | 10 | October | 2013 | 20 | |||||||||
77 | Government | Mexico | Carretera | High | 886 | 3 | 350 | 310100 | 37212 | 272888 | 230360 | 42528 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
78 | Government | Mexico | Paseo | High | 886 | 10 | 350 | 310100 | 37212 | 272888 | 230360 | 42528 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
79 | Government | France | Paseo | High | 1594 | 10 | 350 | 557900 | 66948 | 490952 | 414440 | 76512 | 1-Nov-14 | 11 | November | 2014 | 20 | |||||||||
80 | Government | Mexico | Paseo | High | 1197 | 10 | 350 | 418950 | 50274 | 368676 | 311220 | 57456 | 1-Nov-14 | 11 | November | 2014 | 20 | |||||||||
81 | Government | Mexico | Velo | High | 1395 | 120 | 350 | 488250 | 58590 | 429660 | 362700 | 66960 | 1-Jul-14 | 7 | July | 2014 | 20 | |||||||||
82 | Government | United States of America | Velo | High | 986 | 120 | 350 | 345100 | 41412 | 303688 | 256360 | 47328 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
83 | Government | Canada | VTT | High | 623 | 250 | 350 | 218050 | 26166 | 191884 | 161980 | 29904 | 1-Sep-13 | 9 | September | 2013 | 20 | |||||||||
84 | Government | United States of America | VTT | High | 986 | 250 | 350 | 345100 | 41412 | 303688 | 256360 | 47328 | 1-Oct-14 | 10 | October | 2014 | 20 | |||||||||
85 | Government | United States of America | Amarilla | High | 270 | 260 | 350 | 94500 | 11340 | 83160 | 70200 | 12960 | 1-Feb-14 | 2 | February | 2014 | 20 | |||||||||
86 | Government | Canada | Carretera | High | 923 | 3 | 350 | 323050 | 41996.5 | 281053.5 | 239980 | 41073.5 | 1-Mar-14 | 3 | March | 2014 | 20 | |||||||||
87 | Government | France | Carretera | High | 1790 | 3 | 350 | 626500 | 81445 | 545055 | 465400 | 79655 | 1-Mar-14 | 3 | March | 2014 | 20 | |||||||||
88 | Government | United States of America | Montana | High | 982.5 | 5 | 350 | 343875 | 44703.75 | 299171.25 | 255450 | 43721.25 | 1-Jan-14 | 1 | January | 2014 | 20 | |||||||||
89 | Government | Canada | Paseo | High | 2632 | 10 | 350 | 921200 | 119756 | 801444 | 684320 | 117124 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
90 | Government | Germany | Paseo | High | 357 | 10 | 350 | 124950 | 16243.5 | 108706.5 | 92820 | 15886.5 | 1-Nov-14 | 11 | November | 2014 | 20 | |||||||||
91 | Government | Canada | Velo | High | 2632 | 120 | 350 | 921200 | 119756 | 801444 | 684320 | 117124 | 1-Jun-14 | 6 | June | 2014 | 20 | |||||||||
92 | Government | Canada | Montana | High | 2227.5 | 5 | 350 | 779625 | 109147.5 | 670477.5 | 579150 | 91327.5 | 1-Jan-14 | 1 | January | 2014 | 20 | |||||||||
93 | Government | Germany | Montana | High | 1199 | 5 | 350 | 419650 | 58751 | 360899 | 311740 | 49159 | 1-Apr-14 | 4 | April | 2014 | 20 | |||||||||
94 | Government | Canada | Montana | High | 200 | 5 | 350 | 70000 | 9800 | 60200 | 52000 | 8200 | 1-May-14 | 5 | May | 2014 | 20 | |||||||||
95 | Government | Canada | Paseo | High | 700 | 10 | 350 | 245000 | 34300 | 210700 | 182000 | 28700 | 1-Nov-14 | 11 | November | 2014 | 20 | |||||||||
96 | Government | United States of America | Paseo | High | 1177 | 10 | 350 | 411950 | 57673 | 354277 | 306020 | 48257 | 1-Nov-14 | 11 | November | 2014 | 20 | |||||||||
97 | Government | France | Paseo | High | 1922 | 10 | 350 | 672700 | 94178 | 578522 | 499720 | 78802 | 1-Nov-13 | 11 | November | 2013 | 20 | |||||||||
98 | Government | France | VTT | High | 1281 | 250 | 350 | 448350 | 62769 | 385581 | 333060 | 52521 | 1-Dec-13 | 12 | December | 2013 | 20 | |||||||||
99 | Government | Mexico | Paseo | High | 2851 | 10 | 350 | 997850 | 149677.5 | 848172.5 | 741260 | 106912.5 | 1-May-14 | 5 | May | 2014 | 20 | |||||||||
100 | Government | United States of America | Paseo | High | 2007 | 10 | 350 | 702450 | 105367.5 | 597082.5 | 521820 | 75262.5 | 1-Nov-13 | 11 | November | 2013 | 20 |