| 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 | COGS | Profit | Date | Month Number | Month Name | Year | |||||||||||
2 | Government | Canada | Carretera | None | 1618 | $ 3 | $ 20 | $ 32,360 | $ - | $ 16,185 | $ 16,175 | 1/1/2019 | 1 | Jan | 2019 | |||||||||||
3 | Government | Germany | Carretera | None | 1321 | $ 3 | $ 20 | $ 26,420 | $ - | $ 13,210 | $ 13,210 | 1/1/2019 | 1 | Jan | 2019 | |||||||||||
4 | Midmarket | France | Carretera | None | 2178 | $ 3 | $ 15 | $ 32,670 | $ - | $ 21,780 | $ 10,890 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
5 | Midmarket | Germany | Carretera | None | 888 | $ 3 | $ 15 | $ 13,320 | $ - | $ 8,880 | $ 4,440 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
6 | Midmarket | Mexico | Carretera | None | 2470 | $ 3 | $ 15 | $ 37,050 | $ - | $ 24,700 | $ 12,350 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
7 | Government | Brazil | Carretera | None | 1513 | $ 3 | $ 350 | $ 529,550 | $ - | $ 393,380 | $ 136,170 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
8 | Midmarket | Germany | Montana | None | 921 | $ 5 | $ 15 | $ 13,815 | $ - | $ 9,210 | $ 4,605 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
9 | Channel Partners | Canada | Montana | None | 2518 | $ 5 | $ 12 | $ 30,216 | $ - | $ 7,554 | $ 22,662 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
10 | Government | China | Montana | None | 1899 | $ 5 | $ 20 | $ 37,980 | $ - | $ 18,990 | $ 18,990 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
11 | Channel Partners | Germany | Montana | None | 1545 | $ 5 | $ 12 | $ 18,540 | $ - | $ 4,635 | $ 13,905 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
12 | Midmarket | Brazil | Montana | None | 2470 | $ 5 | $ 15 | $ 37,050 | $ - | $ 24,700 | $ 12,350 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
13 | Enterprise | Canada | Montana | None | 2665 | $ 5 | $ 125 | $ 333,125 | $ - | $ 319,860 | $ 13,265 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
14 | Small Business | Mexico | Montana | None | 958 | $ 5 | $ 300 | $ 287,400 | $ - | $ 239,500 | $ 47,900 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
15 | Government | Germany | Montana | None | 2146 | $ 5 | $ 7 | $ 15,022 | $ - | $ 10,730 | $ 4,292 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
16 | Enterprise | Canada | Montana | None | 345 | $ 5 | $ 125 | $ 43,125 | $ - | $ 41,400 | $ 1,725 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
17 | Midmarket | USA | Montana | None | 615 | $ 5 | $ 15 | $ 9,225 | $ - | $ 6,150 | $ 3,075 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
18 | Government | Canada | Paseo | None | 292 | $ 10 | $ 20 | $ 5,840 | $ - | $ 2,920 | $ 2,920 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
19 | Midmarket | China | Paseo | None | 974 | $ 10 | $ 15 | $ 14,610 | $ - | $ 9,740 | $ 4,870 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
20 | Channel Partners | Canada | Paseo | None | 2518 | $ 10 | $ 12 | $ 30,216 | $ - | $ 7,554 | $ 22,662 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
21 | Government | Germany | Paseo | None | 1006 | $ 10 | $ 350 | $ 352,100 | $ - | $ 261,560 | $ 90,540 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
22 | Channel Partners | Germany | Paseo | None | 367 | $ 10 | $ 12 | $ 4,404 | $ - | $ 1,101 | $ 3,303 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
23 | Government | Mexico | Paseo | None | 883 | $ 10 | $ 7 | $ 6,181 | $ - | $ 4,415 | $ 1,766 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
24 | Midmarket | Brazil | Paseo | None | 549 | $ 10 | $ 15 | $ 8,235 | $ - | $ 5,490 | $ 2,745 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
25 | Small Business | Mexico | Paseo | None | 788 | $ 10 | $ 300 | $ 236,400 | $ - | $ 197,000 | $ 39,400 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
26 | Midmarket | Mexico | Paseo | None | 2472 | $ 10 | $ 15 | $ 37,080 | $ - | $ 24,720 | $ 12,360 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
27 | Government | USA | Paseo | None | 1143 | $ 10 | $ 7 | $ 8,001 | $ - | $ 5,715 | $ 2,286 | 10/1/2019 | 10 | Oct | 2019 | |||||||||||
28 | Government | Canada | Paseo | None | 1725 | $ 10 | $ 350 | $ 603,750 | $ - | $ 448,500 | $ 155,250 | 11/1/2018 | 11 | Nov | 2018 | |||||||||||
29 | Channel Partners | USA | Paseo | None | 912 | $ 10 | $ 12 | $ 10,944 | $ - | $ 2,736 | $ 8,208 | 11/1/2018 | 11 | Nov | 2018 | |||||||||||
30 | Midmarket | Canada | Paseo | None | 2152 | $ 10 | $ 15 | $ 32,280 | $ - | $ 21,520 | $ 10,760 | 12/1/2018 | 12 | Dec | 2018 | |||||||||||
31 | Government | Canada | Paseo | None | 1817 | $ 10 | $ 20 | $ 36,340 | $ - | $ 18,170 | $ 18,170 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
32 | Government | Germany | Paseo | None | 1513 | $ 10 | $ 350 | $ 529,550 | $ - | $ 393,380 | $ 136,170 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
33 | Government | China | Velo | None | 1493 | $ 120 | $ 7 | $ 10,451 | $ - | $ 7,465 | $ 2,986 | 1/1/2019 | 1 | Jan | 2019 | |||||||||||
34 | Enterprise | France | Velo | None | 1804 | $ 120 | $ 125 | $ 225,500 | $ - | $ 216,480 | $ 9,020 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
35 | Channel Partners | Germany | Velo | None | 2161 | $ 120 | $ 12 | $ 25,932 | $ - | $ 6,483 | $ 19,449 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
36 | Government | Germany | Velo | None | 1006 | $ 120 | $ 350 | $ 352,100 | $ - | $ 261,560 | $ 90,540 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
37 | Channel Partners | China | Velo | None | 1545 | $ 120 | $ 12 | $ 18,540 | $ - | $ 4,635 | $ 13,905 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
38 | Enterprise | USA | Velo | None | 2821 | $ 120 | $ 125 | $ 352,625 | $ - | $ 338,520 | $ 14,105 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
39 | Enterprise | Canada | Velo | None | 345 | $ 120 | $ 125 | $ 43,125 | $ - | $ 41,400 | $ 1,725 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
40 | Small Business | Canada | VTT | None | 2001 | $ 250 | $ 300 | $ 600,300 | $ - | $ 500,250 | $ 100,050 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
41 | Channel Partners | Germany | VTT | None | 2838 | $ 250 | $ 12 | $ 34,056 | $ - | $ 8,514 | $ 25,542 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
42 | Midmarket | China | VTT | None | 2178 | $ 250 | $ 15 | $ 32,670 | $ - | $ 21,780 | $ 10,890 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
43 | Midmarket | Germany | VTT | None | 888 | $ 250 | $ 15 | $ 13,320 | $ - | $ 8,880 | $ 4,440 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
44 | Government | France | VTT | None | 1527 | $ 250 | $ 350 | $ 534,450 | $ - | $ 397,020 | $ 137,430 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
45 | Small Business | France | VTT | None | 2151 | $ 250 | $ 300 | $ 645,300 | $ - | $ 537,750 | $ 107,550 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
46 | Government | Canada | VTT | None | 1817 | $ 250 | $ 20 | $ 36,340 | $ - | $ 18,170 | $ 18,170 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
47 | Government | France | Amarilla | None | 2750 | $ 260 | $ 350 | $ 962,500 | $ - | $ 715,000 | $ 247,500 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
48 | Channel Partners | USA | Amarilla | None | 1953 | $ 260 | $ 12 | $ 23,436 | $ - | $ 5,859 | $ 17,577 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
49 | Enterprise | Germany | Amarilla | None | 4219 | $ 260 | $ 125 | $ 527,375 | $ - | $ 506,340 | $ 21,035 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
50 | Government | Brazil | Amarilla | None | 1899 | $ 260 | $ 20 | $ 37,980 | $ - | $ 18,990 | $ 18,990 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
51 | Government | Germany | Amarilla | None | 1686 | $ 260 | $ 7 | $ 11,802 | $ - | $ 8,430 | $ 3,372 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
52 | Channel Partners | USA | Amarilla | None | 2141 | $ 260 | $ 12 | $ 25,692 | $ - | $ 6,423 | $ 19,269 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
53 | Government | USA | Amarilla | None | 1143 | $ 260 | $ 7 | $ 8,001 | $ - | $ 5,715 | $ 2,286 | 10/1/2019 | 10 | Oct | 2019 | |||||||||||
54 | Midmarket | USA | Amarilla | None | 615 | $ 260 | $ 15 | $ 9,225 | $ - | $ 6,150 | $ 3,075 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
55 | Government | China | Paseo | Low | 3945 | $ 10 | $ 7 | $ 27,615 | $ 276 | $ 19,725 | $ 7,614 | 1/1/2019 | 1 | Jan | 2019 | |||||||||||
56 | Midmarket | France | Paseo | Low | 2296 | $ 10 | $ 15 | $ 34,440 | $ 344 | $ 22,960 | $ 11,136 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
57 | Government | France | Paseo | Low | 1030 | $ 10 | $ 7 | $ 7,210 | $ 72 | $ 5,150 | $ 1,988 | 5/1/2019 | 5 | May | 2019 | |||||||||||
58 | Government | France | Velo | Low | 639 | $ 120 | $ 7 | $ 4,473 | $ 45 | $ 3,195 | $ 1,233 | 11/1/2019 | 11 | Nov | 2019 | |||||||||||
59 | Government | China | VTT | Low | 1326 | $ 250 | $ 7 | $ 9,282 | $ 93 | $ 6,630 | $ 2,559 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
60 | Channel Partners | USA | Carretera | Low | 1858 | $ 3 | $ 12 | $ 22,296 | $ 223 | $ 5,574 | $ 16,499 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
61 | Government | Mexico | Carretera | Low | 1210 | $ 3 | $ 350 | $ 423,500 | $ 4,235 | $ 314,600 | $ 104,665 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
62 | Government | USA | Carretera | Low | 2529 | $ 3 | $ 7 | $ 17,703 | $ 177 | $ 12,645 | $ 4,881 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
63 | Channel Partners | Canada | Carretera | Low | 1445 | $ 3 | $ 12 | $ 17,340 | $ 173 | $ 4,335 | $ 12,832 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
64 | Enterprise | USA | Carretera | Low | 330 | $ 3 | $ 125 | $ 41,250 | $ 413 | $ 39,600 | $ 1,238 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
65 | Channel Partners | France | Carretera | Low | 2671 | $ 3 | $ 12 | $ 32,052 | $ 321 | $ 8,013 | $ 23,718 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
66 | Channel Partners | Germany | Carretera | Low | 766 | $ 3 | $ 12 | $ 9,192 | $ 92 | $ 2,298 | $ 6,802 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
67 | Small Business | Mexico | Carretera | Low | 494 | $ 3 | $ 300 | $ 148,200 | $ 1,482 | $ 123,500 | $ 23,218 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
68 | Government | Mexico | Carretera | Low | 1397 | $ 3 | $ 350 | $ 488,950 | $ 4,890 | $ 363,220 | $ 120,841 | 10/1/2019 | 10 | Oct | 2019 | |||||||||||
69 | Government | France | Carretera | Low | 2155 | $ 3 | $ 350 | $ 754,250 | $ 7,543 | $ 560,300 | $ 186,408 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
70 | Midmarket | Mexico | Montana | Low | 2214 | $ 5 | $ 15 | $ 33,210 | $ 332 | $ 22,140 | $ 10,738 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
71 | Small Business | Brazil | Montana | Low | 2301 | $ 5 | $ 300 | $ 690,300 | $ 6,903 | $ 575,250 | $ 108,147 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
72 | Government | France | Montana | Low | 1375 | $ 5 | $ 20 | $ 27,500 | $ 275 | $ 13,755 | $ 13,470 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
73 | Government | Canada | Montana | Low | 1830 | $ 5 | $ 7 | $ 12,810 | $ 128 | $ 9,150 | $ 3,532 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
74 | Small Business | USA | Montana | Low | 2498 | $ 5 | $ 300 | $ 749,400 | $ 7,494 | $ 624,500 | $ 117,406 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
75 | Enterprise | USA | Montana | Low | 663 | $ 5 | $ 125 | $ 82,875 | $ 829 | $ 79,560 | $ 2,486 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
76 | Midmarket | USA | Paseo | Low | 1514 | $ 10 | $ 15 | $ 22,710 | $ 227 | $ 15,140 | $ 7,343 | 2/1/2019 | 2 | Feb | 2019 | |||||||||||
77 | Government | Brazil | Paseo | Low | 4492 | $ 10 | $ 7 | $ 31,444 | $ 314 | $ 22,463 | $ 8,667 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
78 | Enterprise | Brazil | Paseo | Low | 727 | $ 10 | $ 125 | $ 90,875 | $ 909 | $ 87,240 | $ 2,726 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
79 | Enterprise | France | Paseo | Low | 787 | $ 10 | $ 125 | $ 98,375 | $ 984 | $ 94,440 | $ 2,951 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
80 | Enterprise | Mexico | Paseo | Low | 1823 | $ 10 | $ 125 | $ 227,875 | $ 2,279 | $ 218,760 | $ 6,836 | 7/1/2019 | 7 | Jul | 2019 | |||||||||||
81 | Midmarket | Germany | Paseo | Low | 747 | $ 10 | $ 15 | $ 11,205 | $ 112 | $ 7,470 | $ 3,623 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
82 | Channel Partners | Germany | Paseo | Low | 766 | $ 10 | $ 12 | $ 9,192 | $ 92 | $ 2,298 | $ 6,802 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
83 | Small Business | China | Paseo | Low | 2905 | $ 10 | $ 300 | $ 871,500 | $ 8,715 | $ 726,250 | $ 136,535 | 11/1/2019 | 11 | Nov | 2019 | |||||||||||
84 | Government | France | Paseo | Low | 2155 | $ 10 | $ 350 | $ 754,250 | $ 7,543 | $ 560,300 | $ 186,408 | 12/1/2019 | 12 | Dec | 2019 | |||||||||||
85 | Government | France | Velo | Low | 3864 | $ 120 | $ 20 | $ 77,280 | $ 773 | $ 38,640 | $ 37,867 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
86 | Government | Mexico | Velo | Low | 362 | $ 120 | $ 7 | $ 2,534 | $ 25 | $ 1,810 | $ 699 | 5/1/2019 | 5 | May | 2019 | |||||||||||
87 | Enterprise | Canada | Velo | Low | 923 | $ 120 | $ 125 | $ 115,375 | $ 1,154 | $ 110,760 | $ 3,461 | 8/1/2019 | 8 | Aug | 2019 | |||||||||||
88 | Enterprise | USA | Velo | Low | 663 | $ 120 | $ 125 | $ 82,875 | $ 829 | $ 79,560 | $ 2,486 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
89 | Government | Canada | Velo | Low | 2092 | $ 120 | $ 7 | $ 14,644 | $ 146 | $ 10,460 | $ 4,038 | 11/1/2018 | 11 | Nov | 2018 | |||||||||||
90 | Government | Germany | VTT | Low | 263 | $ 250 | $ 7 | $ 1,841 | $ 18 | $ 1,315 | $ 508 | 3/1/2019 | 3 | Mar | 2019 | |||||||||||
91 | Government | Canada | VTT | Low | 943 | $ 250 | $ 350 | $ 330,050 | $ 3,302 | $ 245,310 | $ 81,438 | 4/1/2019 | 4 | Apr | 2019 | |||||||||||
92 | Enterprise | USA | VTT | Low | 727 | $ 250 | $ 125 | $ 90,875 | $ 909 | $ 87,240 | $ 2,726 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
93 | Enterprise | France | VTT | Low | 787 | $ 250 | $ 125 | $ 98,375 | $ 984 | $ 94,440 | $ 2,951 | 6/1/2019 | 6 | Jun | 2019 | |||||||||||
94 | Small Business | Brazil | VTT | Low | 986 | $ 250 | $ 300 | $ 295,800 | $ 2,958 | $ 246,500 | $ 46,342 | 9/1/2019 | 9 | Sep | 2019 | |||||||||||
95 | Small Business | Mexico | VTT | Low | 494 | $ 250 | $ 300 | $ 148,200 | $ 1,482 | $ 123,500 | $ 23,218 | 10/1/2018 | 10 | Oct | 2018 | |||||||||||
96 | Government | Mexico | VTT | Low | 1397 | $ 250 | $ 350 | $ 488,950 | $ 4,890 | $ 363,220 | $ 120,841 | 10/1/2019 | 10 | Oct | 2019 | |||||||||||
97 | Enterprise | France | VTT | Low | 1744 | $ 250 | $ 125 | $ 218,000 | $ 2,180 | $ 209,280 | $ 6,540 | 11/1/2019 | 11 | Nov | 2019 | |||||||||||
98 | Channel Partners | USA | Amarilla | Low | 1989 | $ 260 | $ 12 | $ 23,868 | $ 239 | $ 5,967 | $ 17,662 | 9/1/2018 | 9 | Sep | 2018 | |||||||||||
99 | Midmarket | Brazil | Amarilla | Low | 321 | $ 260 | $ 15 | $ 4,815 | $ 48 | $ 3,210 | $ 1,557 | 11/1/2018 | 11 | Nov | 2018 | |||||||||||
100 | Enterprise | Canada | Carretera | Low | 742 | $ 3 | $ 125 | $ 92,750 | $ 1,856 | $ 89,100 | $ 1,794 | 4/1/2019 | 4 | Apr | 2019 |