| 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 | Date | profit 2 | |||||||||||||
2 | Government | Canada | Carretera | None | 1,618.50 | $3 | 20.00 | 32,370.00 | $0.00 | 32,370.00 | 16,185.00 | 1/1/2014 | 16,185.00 | |||||||||||||
3 | Government | Germany | Carretera | None | 1,321.00 | $3 | 20.00 | 26,420.00 | $0.00 | 26,420.00 | 13,210.00 | 1/1/2014 | 13,210.00 | |||||||||||||
4 | Midmarket | France | Carretera | None | 2,178.00 | $3 | 15.00 | 32,670.00 | $0.00 | 32,670.00 | 21,780.00 | 1/6/2014 | 10,890.00 | |||||||||||||
5 | Midmarket | Germany | Carretera | None | 888.00 | $3 | 15.00 | 13,320.00 | $0.00 | 13,320.00 | 8,880.00 | 1/6/2014 | 4,440.00 | |||||||||||||
6 | Midmarket | mexico | Carretera | None | 2,470.00 | $3 | 15.00 | 37,050.00 | $0.00 | 37,050.00 | 24,700.00 | 1/6/2014 | 12,350.00 | |||||||||||||
7 | Government | Germany | Montana | None | 1,513.00 | $3 | 350.00 | 529,550.00 | $0.00 | 529,550.00 | 393,380.00 | 1/12/2014 | 136,170.00 | |||||||||||||
8 | Midmarket | Germany | Montana | None | 921.00 | $5 | 15.00 | 13,815.00 | $0.00 | 13,815.00 | 9,210.00 | 1/3/2014 | 4,605.00 | |||||||||||||
9 | Channel Partners | Canada | montana | None | 2,518.00 | $5 | 12.00 | 30,216.00 | $0.00 | 30,216.00 | 7,554.00 | 1/6/2014 | 22,662.00 | |||||||||||||
10 | Government | France | Montana | None | 1,899.00 | $5 | 20.00 | 37,980.00 | $0.00 | 37,980.00 | 18,990.00 | 1/6/2014 | 18,990.00 | |||||||||||||
11 | Channel Partners | Germany | Montana | None | 1,545.00 | $5 | 12.00 | 18,540.00 | $0.00 | 18,540.00 | 4,635.00 | 1/6/2014 | 13,905.00 | |||||||||||||
12 | Midmarket | mexico | Montana | None | 2,470.00 | $5 | 15.00 | 37,050.00 | $0.00 | 37,050.00 | 24,700.00 | 1/6/2014 | 12,350.00 | |||||||||||||
13 | Enterprise | Canada | Montana | None | 2,665.50 | $5 | 125.00 | 333,187.50 | $0.00 | 333,187.50 | 319,860.00 | 1/7/2014 | 13,327.50 | |||||||||||||
14 | Small Business | Mexico | Montana | None | 958.00 | $5 | 300.00 | 287,400.00 | $0.00 | 287,400.00 | 239,500.00 | 1/8/2014 | 47,900.00 | |||||||||||||
15 | Government | Germany | Montana | None | 2,146.00 | $5 | 7.00 | 15,022.00 | $0.00 | 15,022.00 | 10,730.00 | 1/9/2014 | 4,292.00 | |||||||||||||
16 | Enterprise | Canada | Montana | None | 345.00 | $5 | 125.00 | 43,125.00 | $0.00 | 43,125.00 | 41,400.00 | 1/10/2013 | 1,725.00 | |||||||||||||
17 | Midmarket | United States of America | Paseo | None | 615.00 | $5 | 15.00 | 9,225.00 | $0.00 | 9,225.00 | 6,150.00 | 1/12/2014 | 3,075.00 | |||||||||||||
18 | Government | Canada | Paseo | None | 292.00 | $10 | 20.00 | 5,840.00 | $0.00 | 5,840.00 | 2,920.00 | 1/2/2014 | 2,920.00 | |||||||||||||
19 | Midmarket | Mexico | Paseo | None | 974.00 | $10 | 15.00 | 14,610.00 | $0.00 | 14,610.00 | 9,740.00 | 1/2/2014 | 4,870.00 | |||||||||||||
20 | Channel Partners | Canada | Paseo | None | 2,518.00 | $10 | 12.00 | 30,216.00 | $0.00 | 30,216.00 | 7,554.00 | 1/6/2014 | 22,662.00 | |||||||||||||
21 | Government | Germany | Paseo | None | 1,006.00 | $10 | 350.00 | 352,100.00 | $0.00 | 352,100.00 | 261,560.00 | 1/6/2014 | 90,540.00 | |||||||||||||
22 | Channel Partners | Germany | Paseo | None | 367.00 | $10 | 12.00 | 4,404.00 | $0.00 | 4,404.00 | 1,101.00 | 1/7/2014 | 3,303.00 | |||||||||||||
23 | Government | Mexico | Paseo | None | 883.00 | $10 | 7.00 | 6,181.00 | $0.00 | 6,181.00 | 4,415.00 | 1/8/2014 | 1,766.00 | |||||||||||||
24 | Midmarket | France | Paseo | None | 549.00 | $10 | 15.00 | 8,235.00 | $0.00 | 8,235.00 | 5,490.00 | 1/9/2013 | 2,745.00 | |||||||||||||
25 | Small Business | Mexico | paseo | None | 788.00 | $10 | 300.00 | 236,400.00 | $0.00 | 236,400.00 | 197,000.00 | 1/9/2013 | 39,400.00 | |||||||||||||
26 | Midmarket | Mexico | Paseo | None | 2,472.00 | $10 | 15.00 | 37,080.00 | $0.00 | 37,080.00 | 24,720.00 | 1/9/2014 | 12,360.00 | |||||||||||||
27 | Government | United States of America | Paseo | None | 1,143.00 | $10 | 7.00 | 8,001.00 | $0.00 | 8,001.00 | 5,715.00 | 1/10/2014 | 2,286.00 | |||||||||||||
28 | Government | Canada | Paseo | None | 1,725.00 | $10 | 350.00 | 603,750.00 | $0.00 | 603,750.00 | 448,500.00 | 1/11/2013 | 155,250.00 | |||||||||||||
29 | Channel Partners | United States of America | Paseo | None | 912.00 | $10 | 12.00 | 10,944.00 | $0.00 | 10,944.00 | 2,736.00 | 1/11/2013 | 8,208.00 | |||||||||||||
30 | Midmarket | canada | Paseo | None | 2,152.00 | $10 | 15.00 | 32,280.00 | $0.00 | 32,280.00 | 21,520.00 | 1/12/2013 | 10,760.00 | |||||||||||||
31 | Government | Canada | Paseo | None | 1,817.00 | $10 | 20.00 | 36,340.00 | $0.00 | 36,340.00 | 18,170.00 | 1/12/2014 | 18,170.00 | |||||||||||||
32 | Government | germany | Velo | None | 1,513.00 | $10 | 350.00 | 529,550.00 | $0.00 | 529,550.00 | 393,380.00 | 1/12/2014 | 136,170.00 | |||||||||||||
33 | Government | Mexico | velo | None | 1,493.00 | $120 | 7.00 | 10,451.00 | $0.00 | 10,451.00 | 7,465.00 | 1/1/2014 | 2,986.00 | |||||||||||||
34 | Enterprise | France | Velo | None | 1,804.00 | $120 | 125.00 | 225,500.00 | $0.00 | 225,500.00 | 216,480.00 | 1/2/2014 | 9,020.00 | |||||||||||||
35 | Channel Partners | Germany | Velo | None | 2,161.00 | $120 | 12.00 | 25,932.00 | $0.00 | 25,932.00 | 6,483.00 | 1/3/2014 | 19,449.00 | |||||||||||||
36 | Government | Germany | Velo | None | 1,006.00 | $120 | 350.00 | 352,100.00 | $0.00 | 352,100.00 | 261,560.00 | 1/6/2014 | 90,540.00 | |||||||||||||
37 | Channel Partners | Germany | Velo | None | 1,545.00 | $120 | 12.00 | 18,540.00 | $0.00 | 18,540.00 | 4,635.00 | 1/6/2014 | 13,905.00 | |||||||||||||
38 | Enterprise | United States of America | Velo | None | 2,821.00 | $120 | 125.00 | 352,625.00 | $0.00 | 352,625.00 | 338,520.00 | 1/8/2014 | 14,105.00 | |||||||||||||
39 | Enterprise | Canada | VTT | None | 345.00 | $120 | 125.00 | 43,125.00 | $0.00 | 43,125.00 | 41,400.00 | 1/10/2013 | 1,725.00 | |||||||||||||
40 | Small Business | Canada | VTT | None | 2,001.00 | $250 | 300.00 | 600,300.00 | $0.00 | 600,300.00 | 500,250.00 | 1/2/2014 | 100,050.00 | |||||||||||||
41 | Channel Partners | Germany | VTT | None | 2,838.00 | $250 | 12.00 | 34,056.00 | $0.00 | 34,056.00 | 8,514.00 | 1/4/2014 | 25,542.00 | |||||||||||||
42 | Midmarket | France | VTT | None | 2,178.00 | $250 | 15.00 | 32,670.00 | $0.00 | 32,670.00 | 21,780.00 | 1/6/2014 | 10,890.00 | |||||||||||||
43 | Midmarket | Germany | VTT | None | 888.00 | $250 | 15.00 | 13,320.00 | $0.00 | 13,320.00 | 8,880.00 | 1/6/2014 | 4,440.00 | |||||||||||||
44 | Government | France | VTT | None | 1,527.00 | $250 | 350.00 | 534,450.00 | $0.00 | 534,450.00 | 397,020.00 | 1/9/2013 | 137,430.00 | |||||||||||||
45 | Small Business | France | Vtt | None | 2,151.00 | $250 | 300.00 | 645,300.00 | $0.00 | 645,300.00 | 537,750.00 | 1/9/2014 | 107,550.00 | |||||||||||||
46 | GovernmenT | Canada | Amarilla | None | 1,817.00 | $250 | 20.00 | 36,340.00 | $0.00 | 36,340.00 | 18,170.00 | 1/12/2014 | 18,170.00 | |||||||||||||
47 | Government | France | Amarilla | None | 2,750.00 | $260 | 350.00 | 962,500.00 | $0.00 | 962,500.00 | 715,000.00 | 1/2/2014 | 247,500.00 | |||||||||||||
48 | Channel Partners | United States of America | Amarilla | None | 1,953.00 | $260 | 12.00 | 23,436.00 | $0.00 | 23,436.00 | 5,859.00 | 1/4/2014 | 17,577.00 | |||||||||||||
49 | Enterprise | Germany | Amarilla | None | 4,219.50 | $260 | 125.00 | 527,437.50 | $0.00 | 527,437.50 | 506,340.00 | 1/4/2014 | 21,097.50 | |||||||||||||
50 | government | France | Amarilla | None | 1,899.00 | $260 | 20.00 | 37,980.00 | $0.00 | 37,980.00 | 18,990.00 | 1/6/2014 | 18,990.00 | |||||||||||||
51 | Government | Germany | Amarilla | None | 1,686.00 | $260 | 7.00 | 11,802.00 | $0.00 | 11,802.00 | 8,430.00 | 1/7/2014 | 3,372.00 | |||||||||||||
52 | Channel Partners | United States of America | Amarilla | None | 2,141.00 | $260 | 12.00 | 25,692.00 | $0.00 | 25,692.00 | 6,423.00 | 1/8/2014 | 19,269.00 | |||||||||||||
53 | Government | United States of America | Amarilla | None | 1,143.00 | $260 | 7.00 | 8,001.00 | $0.00 | 8,001.00 | 5,715.00 | 1/10/2014 | 2,286.00 | |||||||||||||
54 | Midmarket | United States of America | Paseo | None | 615.00 | $260 | 15.00 | 9,225.00 | $0.00 | 9,225.00 | 6,150.00 | 1/12/2014 | 3,075.00 | |||||||||||||
55 | Government | France | Paseo | Low | 3,945.00 | $10 | 7.00 | 27,615.00 | $276.15 | 27,338.85 | 19,725.00 | 1/1/2014 | 7,613.85 | |||||||||||||
56 | Midmarket | France | Paseo | Low | 2,296.00 | $10 | 15.00 | 34,440.00 | $344.40 | 34,095.60 | 22,960.00 | 1/2/2014 | 11,135.60 | |||||||||||||
57 | Government | France | Velo | Low | 1,030.00 | $10 | 7.00 | 7,210.00 | $72.10 | 7,137.90 | 5,150.00 | 1/5/2014 | 1,987.90 | |||||||||||||
58 | Government | France | VTT | Low | 639.00 | $120 | 7.00 | 4,473.00 | $44.73 | 4,428.27 | 3,195.00 | 1/11/2014 | 1,233.27 | |||||||||||||
59 | Government | Canada | Carretera | Low | 1,326.00 | $250 | 7.00 | 9,282.00 | $92.82 | 9,189.18 | 6,630.00 | 1/3/2014 | 2,559.18 | |||||||||||||
60 | Channel Partners | United States of America | Carretera | Low | 1,858.00 | $3 | 12.00 | 22,296.00 | $222.96 | 22,073.04 | 5,574.00 | 1/2/2014 | 16,499.04 | |||||||||||||
61 | Government | Mexico | Carretera | Low | 1,210.00 | $3 | 350.00 | 423,500.00 | $4,235.00 | 419,265.00 | 314,600.00 | 1/3/2014 | 104,665.00 | |||||||||||||
62 | Government | United States of America | Carretera | Low | 2,529.00 | $3 | 7.00 | 17,703.00 | $177.03 | 17,525.97 | 12,645.00 | 1/7/2014 | 4,880.97 | |||||||||||||
63 | Channel Partners | Canada | Carretera | Low | 1,445.00 | $3 | 12.00 | 17,340.00 | $173.40 | 17,166.60 | 4,335.00 | 1/9/2014 | 12,831.60 | |||||||||||||
64 | Enterprise | United States of America | Carretera | Low | 330.00 | $3 | 125.00 | 41,250.00 | $412.50 | 40,837.50 | 39,600.00 | 1/9/2013 | 1,237.50 | |||||||||||||
65 | Channel Partners | France | Carretera | Low | 2,671.00 | $3 | 12.00 | 32,052.00 | $320.52 | 31,731.48 | 8,013.00 | 1/9/2014 | 23,718.48 | |||||||||||||
66 | Channel Partners | Germany | Carretera | Low | 766.00 | $3 | 12.00 | 9,192.00 | $91.92 | 9,100.08 | 2,298.00 | 1/10/2013 | 6,802.08 | |||||||||||||
67 | Small Business | Mexico | Carretera | Low | 494.00 | $3 | 300.00 | 148,200.00 | $1,482.00 | 146,718.00 | 123,500.00 | 1/10/2013 | 23,218.00 | |||||||||||||
68 | Government | Mexico | Carretera | Low | 1,397.00 | $3 | 350.00 | 488,950.00 | $4,889.50 | 484,060.50 | 363,220.00 | 1/10/2014 | 120,840.50 | |||||||||||||
69 | Government | France | Montana | Low | 2,155.00 | $3 | 350.00 | 754,250.00 | $7,542.50 | 746,707.50 | 560,300.00 | 1/12/2014 | 186,407.50 | |||||||||||||
70 | Midmarket | Mexico | Montana | Low | 2,214.00 | $5 | 15.00 | 33,210.00 | $332.10 | 32,877.90 | 22,140.00 | 1/3/2014 | 10,737.90 | |||||||||||||
71 | Small Business | United States of America | Montana | Low | 2,301.00 | $5 | 300.00 | 690,300.00 | $6,903.00 | 683,397.00 | 575,250.00 | 1/4/2014 | 108,147.00 | |||||||||||||
72 | Government | France | Montana | Low | 1,375.50 | $5 | 20.00 | 27,510.00 | $275.10 | 27,234.90 | 13,755.00 | 1/7/2014 | 13,479.90 | |||||||||||||
73 | Government | Canada | Montana | Low | 1,830.00 | $5 | 7.00 | 12,810.00 | $128.10 | 12,681.90 | 9,150.00 | 1/8/2014 | 3,531.90 | |||||||||||||
74 | Small Business | United States of America | Montana | Low | 2,498.00 | $5 | 300.00 | 749,400.00 | $7,494.00 | 741,906.00 | 624,500.00 | 1/9/2013 | 117,406.00 | |||||||||||||
75 | Enterprise | United States of America | Paseo | Low | 663.00 | $5 | 125.00 | 82,875.00 | $828.75 | 82,046.25 | 79,560.00 | 1/10/2013 | 2,486.25 | |||||||||||||
76 | Midmarket | United States of America | Paseo | Low | 1,514.00 | $10 | 15.00 | 22,710.00 | $227.10 | 22,482.90 | 15,140.00 | 1/2/2014 | 7,342.90 | |||||||||||||
77 | Government | United States of America | Paseo | Low | 4,492.50 | $10 | 7.00 | 31,447.50 | $314.48 | 31,133.03 | 22,462.50 | 1/4/2014 | 8,670.53 | |||||||||||||
78 | Enterprise | United States of America | Paseo | Low | 727.00 | $10 | 125.00 | 90,875.00 | $908.75 | 89,966.25 | 87,240.00 | 1/6/2014 | 2,726.25 | |||||||||||||
79 | Enterprise | France | Paseo | Low | 787.00 | $10 | 125.00 | 98,375.00 | $983.75 | 97,391.25 | 94,440.00 | 1/6/2014 | 2,951.25 | |||||||||||||
80 | Enterprise | Mexico | Paseo | Low | 1,823.00 | $10 | 125.00 | 227,875.00 | $2,278.75 | 225,596.25 | 218,760.00 | 1/7/2014 | 6,836.25 | |||||||||||||
81 | Midmarket | Germany | Paseo | Low | 747.00 | $10 | 15.00 | 11,205.00 | $112.05 | 11,092.95 | 7,470.00 | 1/9/2014 | 3,622.95 | |||||||||||||
82 | Channel Partners | Germany | Paseo | Low | 766.00 | $10 | 12.00 | 9,192.00 | $91.92 | 9,100.08 | 2,298.00 | 1/10/2013 | 6,802.08 | |||||||||||||
83 | Small Business | United States of America | Paseo | Low | 2,905.00 | $10 | 300.00 | 871,500.00 | $8,715.00 | 862,785.00 | 726,250.00 | 1/11/2014 | 136,535.00 | |||||||||||||
84 | Government | France | Velo | Low | 2,155.00 | $10 | 350.00 | 754,250.00 | $7,542.50 | 746,707.50 | 560,300.00 | 1/12/2014 | 186,407.50 | |||||||||||||
85 | Government | France | Velo | Low | 3,864.00 | $120 | 20.00 | 77,280.00 | $772.80 | 76,507.20 | 38,640.00 | 1/4/2014 | 37,867.20 | |||||||||||||
86 | Government | Mexico | Velo | Low | 362.00 | $120 | 7.00 | 2,534.00 | $25.34 | 2,508.66 | 1,810.00 | 1/5/2014 | 698.66 | |||||||||||||
87 | Enterprise | Canada | Velo | Low | 923.00 | $120 | 125.00 | 115,375.00 | $1,153.75 | 114,221.25 | 110,760.00 | 1/8/2014 | 3,461.25 | |||||||||||||
88 | Enterprise | United States of America | Velo | Low | 663.00 | $120 | 125.00 | 82,875.00 | $828.75 | 82,046.25 | 79,560.00 | 1/10/2013 | 2,486.25 | |||||||||||||
89 | Government | Canada | VTT | Low | 2,092.00 | $120 | 7.00 | 14,644.00 | $146.44 | 14,497.56 | 10,460.00 | 1/11/2013 | 4,037.56 | |||||||||||||
90 | Government | Germany | VTT | Low | 263.00 | $250 | 7.00 | 1,841.00 | $18.41 | 1,822.59 | 1,315.00 | 1/3/2014 | 507.59 | |||||||||||||
91 | Government | Canada | VTT | Low | 943.50 | $250 | 350.00 | 330,225.00 | $3,302.25 | 326,922.75 | 245,310.00 | 1/4/2014 | 81,612.75 | |||||||||||||
92 | Enterprise | United States of America | VTT | Low | 727.00 | $250 | 125.00 | 90,875.00 | $908.75 | 89,966.25 | 87,240.00 | 1/6/2014 | 2,726.25 | |||||||||||||
93 | Enterprise | France | VTT | Low | 787.00 | $250 | 125.00 | 98,375.00 | $983.75 | 97,391.25 | 94,440.00 | 1/6/2014 | 2,951.25 | |||||||||||||
94 | Small Business | Germany | VTT | Low | 986.00 | $250 | 300.00 | 295,800.00 | $2,958.00 | 292,842.00 | 246,500.00 | 1/9/2014 | 46,342.00 | |||||||||||||
95 | Small Business | Mexico | VTT | Low | 494.00 | $250 | 300.00 | 148,200.00 | $1,482.00 | 146,718.00 | 123,500.00 | 1/10/2013 | 23,218.00 | |||||||||||||
96 | Government | Mexico | VTT | Low | 1,397.00 | $250 | 350.00 | 488,950.00 | $4,889.50 | 484,060.50 | 363,220.00 | 1/10/2014 | 120,840.50 | |||||||||||||
97 | Enterprise | France | Amarilla | Low | 1,744.00 | $250 | 125.00 | 218,000.00 | $2,180.00 | 215,820.00 | 209,280.00 | 1/11/2014 | 6,540.00 | |||||||||||||
98 | Channel Partners | United States of America | Amarilla | Low | 1,989.00 | $260 | 12.00 | 23,868.00 | $238.68 | 23,629.32 | 5,967.00 | 1/9/2013 | 17,662.32 | |||||||||||||
99 | Midmarket | France | Carretera | Low | 321.00 | $260 | 15.00 | 4,815.00 | $48.15 | 4,766.85 | 3,210.00 | 1/11/2013 | 1,556.85 | |||||||||||||
100 | Enterprise | Canada | Carretera | Low | 742.50 | $3 | 125.00 | 92,812.50 | $1,856.25 | 90,956.25 | 89,100.00 | 1/4/2014 | 1,856.25 |