| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Retailer | Retailer ID | Invoice Date | Month | Region | State | City | Product | Price per Unit | Units Sold | Total Sales | Operating Profit | Operating Margin | Sales Method |
2 | Foot Locker | 1185732 | 01/01/2020 | 2020-1 | Northeast | New York | New York | Men's Street Footwear | $50.00 | 1,200 | $600,000 | $100,000 | 50% | In-store |
3 | Foot Locker | 1185732 | 02/01/2020 | 2020-1 | Northeast | New York | New York | Men's Athletic Footwear | $50.00 | 1,000 | $500,000 | $150,000 | 30% | In-store |
4 | Foot Locker | 1185732 | 03/01/2020 | 2020-1 | Northeast | New York | New York | Women's Street Footwear | $40.00 | 1,000 | $400,000 | $140,000 | 35% | In-store |
5 | Foot Locker | 1185732 | 04/01/2020 | 2020-1 | Northeast | New York | New York | Women's Athletic Footwear | $45.00 | 850 | $382,500 | $133,875 | 35% | In-store |
6 | Foot Locker | 1185732 | 05/01/2020 | 2020-1 | Northeast | New York | New York | Men's Apparel | $60.00 | 900 | $540,000 | $162,000 | 30% | In-store |
7 | Foot Locker | 1185732 | 06/01/2020 | 2020-1 | Northeast | New York | New York | Women's Apparel | $50.00 | 1,000 | $500,000 | $125,000 | 25% | In-store |
8 | Foot Locker | 1185732 | 07/01/2020 | 2020-1 | Northeast | New York | New York | Men's Street Footwear | $50.00 | 1,250 | $625,000 | $312,500 | 50% | In-store |
9 | Foot Locker | 1185732 | 08/01/2020 | 2020-1 | Northeast | New York | New York | Men's Athletic Footwear | $50.00 | 900 | $450,000 | $135,000 | 30% | Outlet |
10 | Foot Locker | 1185732 | 21/01/2020 | 2020-1 | Northeast | New York | New York | Women's Street Footwear | $40.00 | 950 | $380,000 | $133,000 | 35% | Outlet |
11 | Foot Locker | 1185732 | 22/01/2020 | 2020-1 | Northeast | New York | New York | Women's Athletic Footwear | $45.00 | 825 | $371,250 | $129,938 | 35% | Outlet |
12 | Foot Locker | 1185732 | 23/01/2020 | 2020-1 | Northeast | New York | New York | Men's Apparel | $60.00 | 900 | $540,000 | $162,000 | 30% | Outlet |
13 | Foot Locker | 1185732 | 24/01/2020 | 2020-1 | Northeast | New York | New York | Women's Apparel | $50.00 | 1,000 | $500,000 | $125,000 | 25% | Outlet |
14 | Foot Locker | 1185732 | 25/01/2020 | 2020-1 | Northeast | New York | New York | Men's Street Footwear | $50.00 | 1,220 | $610,000 | $305,000 | 50% | Outlet |
15 | Foot Locker | 1185732 | 26/01/2020 | 2020-1 | Northeast | New York | New York | Men's Athletic Footwear | $50.00 | 925 | $462,500 | $138,750 | 30% | Outlet |
16 | Foot Locker | 1185732 | 27/01/2020 | 2020-1 | Northeast | New York | New York | Women's Street Footwear | $40.00 | 950 | $380,000 | $133,000 | 35% | Outlet |
17 | Foot Locker | 1185732 | 28/01/2020 | 2020-1 | Northeast | New York | New York | Women's Athletic Footwear | $45.00 | 800 | $360,000 | $126,000 | 35% | Outlet |
18 | Foot Locker | 1185732 | 29/01/2020 | 2020-1 | Northeast | New York | New York | Men's Apparel | $60.00 | 850 | $510,000 | $153,000 | 30% | Outlet |
19 | Foot Locker | 1185732 | 30/01/2020 | 2020-1 | Northeast | New York | New York | Women's Apparel | $50.00 | 950 | $475,000 | $118,750 | 25% | Outlet |
20 | Foot Locker | 1185732 | 31/01/2020 | 2020-1 | Northeast | New York | New York | Men's Street Footwear | $50.00 | 1,200 | $600,000 | $300,000 | 50% | Outlet |
21 | Foot Locker | 1185732 | 01/02/2020 | 2020-2 | Northeast | New York | New York | Men's Athletic Footwear | $50.00 | 900 | $450,000 | $135,000 | 30% | Outlet |
22 | Foot Locker | 1185732 | 02/02/2020 | 2020-2 | Northeast | New York | New York | Women's Street Footwear | $40.00 | 900 | $360,000 | $126,000 | 35% | Outlet |
23 | Foot Locker | 1185732 | 03/02/2020 | 2020-2 | Northeast | New York | New York | Women's Athletic Footwear | $45.00 | 825 | $371,250 | $129,938 | 35% | Outlet |
24 | Foot Locker | 1185732 | 04/02/2020 | 2020-2 | Northeast | New York | New York | Men's Apparel | $60.00 | 825 | $495,000 | $148,500 | 30% | Outlet |
25 | Foot Locker | 1185732 | 05/02/2020 | 2020-2 | Northeast | New York | New York | Women's Apparel | $50.00 | 950 | $475,000 | $118,750 | 25% | Outlet |
26 | Foot Locker | 1185732 | 06/02/2020 | 2020-2 | Northeast | New York | New York | Men's Street Footwear | $60.00 | 1,220 | $732,000 | $366,000 | 50% | Outlet |
27 | Foot Locker | 1185732 | 07/02/2020 | 2020-2 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 925 | $508,750 | $152,625 | 30% | Outlet |
28 | Foot Locker | 1185732 | 08/02/2020 | 2020-2 | Northeast | New York | New York | Women's Street Footwear | $50.00 | 900 | $450,000 | $157,500 | 35% | Outlet |
29 | Foot Locker | 1185732 | 09/02/2020 | 2020-2 | Northeast | New York | New York | Women's Athletic Footwear | $50.00 | 850 | $425,000 | $148,750 | 35% | Outlet |
30 | Foot Locker | 1185732 | 10/02/2020 | 2020-2 | Northeast | New York | New York | Men's Apparel | $60.00 | 875 | $525,000 | $157,500 | 30% | Outlet |
31 | Foot Locker | 1185732 | 03/03/2020 | 2020-3 | Northeast | New York | New York | Women's Apparel | $65.00 | 1,000 | $650,000 | $162,500 | 25% | Outlet |
32 | Foot Locker | 1185732 | 04/03/2020 | 2020-3 | Northeast | New York | New York | Men's Street Footwear | $60.00 | 1,250 | $750,000 | $375,000 | 50% | Outlet |
33 | Foot Locker | 1185732 | 05/03/2020 | 2020-3 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 1,000 | $550,000 | $165,000 | 30% | Outlet |
34 | Foot Locker | 1185732 | 06/03/2020 | 2020-3 | Northeast | New York | New York | Women's Street Footwear | $50.00 | 925 | $462,500 | $161,875 | 35% | Outlet |
35 | Foot Locker | 1185732 | 07/03/2020 | 2020-3 | Northeast | New York | New York | Women's Athletic Footwear | $50.00 | 900 | $450,000 | $157,500 | 35% | Outlet |
36 | Foot Locker | 1185732 | 08/03/2020 | 2020-3 | Northeast | New York | New York | Men's Apparel | $60.00 | 900 | $540,000 | $162,000 | 30% | Outlet |
37 | Foot Locker | 1185732 | 09/03/2020 | 2020-3 | Northeast | New York | New York | Women's Apparel | $65.00 | 1,050 | $682,500 | $170,625 | 25% | Outlet |
38 | Foot Locker | 1185732 | 10/03/2020 | 2020-3 | Northeast | New York | New York | Men's Street Footwear | $60.00 | 1,275 | $765,000 | $382,500 | 50% | Outlet |
39 | Foot Locker | 1185732 | 11/03/2020 | 2020-3 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 1,025 | $563,750 | $169,125 | 30% | Outlet |
40 | Foot Locker | 1185732 | 12/03/2020 | 2020-3 | Northeast | New York | New York | Women's Street Footwear | $50.00 | 950 | $475,000 | $166,250 | 35% | Outlet |
41 | Foot Locker | 1185732 | 13/03/2020 | 2020-3 | Northeast | New York | New York | Women's Athletic Footwear | $50.00 | 900 | $450,000 | $157,500 | 35% | Outlet |
42 | Foot Locker | 1185732 | 14/03/2020 | 2020-3 | Northeast | New York | New York | Men's Apparel | $60.00 | 925 | $555,000 | $166,500 | 30% | Outlet |
43 | Foot Locker | 1185732 | 15/03/2020 | 2020-3 | Northeast | New York | New York | Women's Apparel | $65.00 | 1,100 | $715,000 | $178,750 | 25% | Outlet |
44 | Foot Locker | 1185732 | 16/03/2020 | 2020-3 | Northeast | New York | New York | Men's Street Footwear | $60.00 | 1,250 | $750,000 | $375,000 | 50% | Outlet |
45 | Foot Locker | 1185732 | 17/03/2020 | 2020-3 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 1,025 | $563,750 | $169,125 | 30% | Outlet |
46 | Foot Locker | 1185732 | 18/03/2020 | 2020-3 | Northeast | New York | New York | Women's Street Footwear | $50.00 | 950 | $475,000 | $166,250 | 35% | Outlet |
47 | Foot Locker | 1185732 | 31/03/2020 | 2020-3 | Northeast | New York | New York | Women's Athletic Footwear | $50.00 | 925 | $462,500 | $161,875 | 35% | Outlet |
48 | Walmart | 1185732 | 17/04/2020 | 2020-4 | Northeast | New York | New York | Men's Apparel | $60.00 | 900 | $540,000 | $162,000 | 30% | Outlet |
49 | Walmart | 1185732 | 18/04/2020 | 2020-4 | Northeast | New York | New York | Women's Apparel | $65.00 | 1,075 | $698,750 | $174,688 | 25% | Outlet |
50 | Walmart | 1185732 | 19/04/2020 | 2020-4 | Northeast | New York | New York | Men's Street Footwear | $60.00 | 1,200 | $720,000 | $360,000 | 50% | Outlet |
51 | Walmart | 1185732 | 20/04/2020 | 2020-4 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 1,000 | $550,000 | $165,000 | 30% | Outlet |
52 | Walmart | 1185732 | 21/04/2020 | 2020-4 | Northeast | New York | New York | Women's Street Footwear | $50.00 | 925 | $462,500 | $161,875 | 35% | Outlet |
53 | Walmart | 1185732 | 22/04/2020 | 2020-4 | Northeast | New York | New York | Women's Athletic Footwear | $50.00 | 900 | $450,000 | $157,500 | 35% | Outlet |
54 | Walmart | 1185732 | 23/04/2020 | 2020-4 | Northeast | New York | New York | Men's Apparel | $60.00 | 900 | $540,000 | $162,000 | 30% | Outlet |
55 | Walmart | 1185732 | 24/04/2020 | 2020-4 | Northeast | New York | New York | Women's Apparel | $65.00 | 1,000 | $650,000 | $162,500 | 25% | Outlet |
56 | Walmart | 1185732 | 25/04/2020 | 2020-4 | Northeast | New York | New York | Men's Apparel | $65.00 | 875 | $568,750 | $170,625 | 30% | Outlet |
57 | Walmart | 1185732 | 26/04/2020 | 2020-4 | Northeast | New York | New York | Women's Apparel | $70.00 | 1,000 | $700,000 | $175,000 | 25% | Outlet |
58 | Walmart | 1185732 | 27/04/2020 | 2020-4 | Northeast | New York | New York | Men's Street Footwear | $65.00 | 1,150 | $747,500 | $373,750 | 50% | Outlet |
59 | Walmart | 1185732 | 28/04/2020 | 2020-4 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 975 | $536,250 | $160,875 | 30% | Outlet |
60 | Walmart | 1185732 | 29/04/2020 | 2020-4 | Northeast | New York | New York | Women's Street Footwear | $55.00 | 920 | $506,000 | $177,100 | 35% | Outlet |
61 | Walmart | 1185732 | 30/04/2020 | 2020-4 | Northeast | New York | New York | Women's Athletic Footwear | $55.00 | 900 | $495,000 | $173,250 | 35% | Outlet |
62 | Walmart | 1185732 | 01/05/2020 | 2020-5 | Northeast | New York | New York | Men's Apparel | $65.00 | 875 | $568,750 | $170,625 | 30% | Outlet |
63 | Walmart | 1185732 | 02/05/2020 | 2020-5 | Northeast | New York | New York | Women's Apparel | $70.00 | 975 | $682,500 | $170,625 | 25% | Outlet |
64 | Walmart | 1185732 | 03/05/2020 | 2020-5 | Northeast | New York | New York | Men's Street Footwear | $65.00 | 1,200 | $780,000 | $390,000 | 50% | Outlet |
65 | Walmart | 1185732 | 04/05/2020 | 2020-5 | Northeast | New York | New York | Men's Athletic Footwear | $55.00 | 1,000 | $550,000 | $165,000 | 30% | Outlet |
66 | Walmart | 1185732 | 05/05/2020 | 2020-5 | Northeast | New York | New York | Women's Street Footwear | $55.00 | 950 | $522,500 | $182,875 | 35% | Outlet |
67 | Walmart | 1185732 | 06/05/2020 | 2020-5 | Northeast | New York | New York | Women's Athletic Footwear | $55.00 | 900 | $495,000 | $173,250 | 35% | Outlet |
68 | Walmart | 1185732 | 07/05/2020 | 2020-5 | Northeast | New York | New York | Men's Apparel | $65.00 | 900 | $585,000 | $175,500 | 30% | Outlet |
69 | Walmart | 1185732 | 18/07/2020 | 2020-7 | Northeast | New York | New York | Women's Apparel | $70.00 | 1,000 | $700,000 | $175,000 | 25% | Outlet |
70 | Sports Direct | 1197831 | 19/07/2020 | 2020-7 | Northeast | New York | New York | Men's Street Footwear | $25.00 | 900 | $225,000 | $78,750 | 35% | Outlet |
71 | Sports Direct | 1197831 | 20/07/2020 | 2020-7 | Northeast | New York | New York | Men's Athletic Footwear | $35.00 | 900 | $315,000 | $110,250 | 35% | Outlet |
72 | Sports Direct | 1197831 | 21/07/2020 | 2020-7 | Northeast | New York | New York | Women's Street Footwear | $35.00 | 700 | $245,000 | $85,750 | 35% | Outlet |
73 | Sports Direct | 1197831 | 22/07/2020 | 2020-7 | Northeast | New York | New York | Women's Athletic Footwear | $35.00 | 700 | $245,000 | $110,250 | 45% | Outlet |
74 | Sports Direct | 1197831 | 23/07/2020 | 2020-7 | South | Texas | Houston | Men's Apparel | $40.00 | 550 | $220,000 | $66,000 | 30% | Outlet |
75 | Sports Direct | 1197831 | 24/07/2020 | 2020-7 | South | Texas | Houston | Women's Apparel | $35.00 | 700 | $245,000 | $122,500 | 50% | Outlet |
76 | Sports Direct | 1197831 | 25/07/2020 | 2020-7 | South | Texas | Houston | Men's Street Footwear | $25.00 | 850 | $212,500 | $74,375 | 35% | Outlet |
77 | Sports Direct | 1197831 | 26/07/2020 | 2020-7 | South | Texas | Houston | Men's Athletic Footwear | $35.00 | 850 | $297,500 | $104,125 | 35% | Outlet |
78 | Sports Direct | 1197831 | 27/07/2020 | 2020-7 | South | Texas | Houston | Women's Street Footwear | $35.00 | 675 | $236,250 | $82,688 | 35% | Outlet |
79 | Sports Direct | 1197831 | 28/07/2020 | 2020-7 | South | Texas | Houston | Women's Athletic Footwear | $35.00 | 625 | $218,750 | $98,438 | 45% | Outlet |
80 | Sports Direct | 1197831 | 29/07/2020 | 2020-7 | South | Texas | Houston | Men's Apparel | $40.00 | 500 | $200,000 | $60,000 | 30% | Outlet |
81 | Sports Direct | 1197831 | 30/07/2020 | 2020-7 | South | Texas | Houston | Women's Apparel | $35.00 | 700 | $245,000 | $122,500 | 50% | Outlet |
82 | Sports Direct | 1197831 | 31/07/2020 | 2020-7 | South | Texas | Houston | Men's Street Footwear | $30.00 | 875 | $262,500 | $91,875 | 35% | Outlet |
83 | Sports Direct | 1197831 | 01/08/2020 | 2020-8 | South | Texas | Houston | Men's Athletic Footwear | $40.00 | 875 | $350,000 | $122,500 | 35% | Outlet |
84 | Sports Direct | 1197831 | 02/08/2020 | 2020-8 | South | Texas | Houston | Women's Street Footwear | $35.00 | 700 | $245,000 | $85,750 | 35% | Outlet |
85 | Sports Direct | 1197831 | 03/08/2020 | 2020-8 | South | Texas | Houston | Women's Athletic Footwear | $40.00 | 600 | $240,000 | $108,000 | 45% | Outlet |
86 | Sports Direct | 1197831 | 04/08/2020 | 2020-8 | South | Texas | Houston | Men's Apparel | $45.00 | 500 | $225,000 | $67,500 | 30% | Outlet |
87 | Sports Direct | 1197831 | 05/08/2020 | 2020-8 | South | Texas | Houston | Women's Apparel | $40.00 | 650 | $260,000 | $130,000 | 50% | Outlet |
88 | Sports Direct | 1197831 | 06/08/2020 | 2020-8 | South | Texas | Houston | Men's Street Footwear | $30.00 | 900 | $270,000 | $94,500 | 35% | Outlet |
89 | Sports Direct | 1197831 | 07/08/2020 | 2020-8 | South | Texas | Houston | Men's Athletic Footwear | $40.00 | 900 | $360,000 | $126,000 | 35% | Outlet |
90 | Sports Direct | 1197831 | 08/08/2020 | 2020-8 | South | Texas | Houston | Women's Street Footwear | $35.00 | 725 | $253,750 | $88,813 | 35% | Outlet |
91 | Sports Direct | 1197831 | 09/08/2020 | 2020-8 | South | Texas | Houston | Women's Athletic Footwear | $40.00 | 625 | $250,000 | $112,500 | 45% | Outlet |
92 | Walmart | 1197831 | 10/08/2020 | 2020-8 | South | Texas | Houston | Men's Apparel | $45.00 | 525 | $236,250 | $70,875 | 30% | Outlet |
93 | Walmart | 1197831 | 11/08/2020 | 2020-8 | South | Texas | Houston | Women's Apparel | $40.00 | 800 | $320,000 | $160,000 | 50% | Outlet |
94 | Walmart | 1197831 | 12/08/2020 | 2020-8 | South | Texas | Houston | Men's Street Footwear | $30.00 | 925 | $277,500 | $97,125 | 35% | Outlet |
95 | Walmart | 1197831 | 13/08/2020 | 2020-8 | South | Texas | Houston | Men's Athletic Footwear | $40.00 | 925 | $370,000 | $129,500 | 35% | Outlet |
96 | Walmart | 1197831 | 14/08/2020 | 2020-8 | South | Texas | Houston | Women's Street Footwear | $35.00 | 775 | $271,250 | $94,938 | 35% | Outlet |
97 | Walmart | 1197831 | 15/08/2020 | 2020-8 | South | Texas | Houston | Women's Athletic Footwear | $40.00 | 700 | $280,000 | $126,000 | 45% | Outlet |
98 | Walmart | 1197831 | 16/08/2020 | 2020-8 | South | Texas | Houston | Men's Apparel | $45.00 | 600 | $270,000 | $81,000 | 30% | Outlet |
99 | Walmart | 1197831 | 17/08/2020 | 2020-8 | South | Texas | Houston | Women's Apparel | $40.00 | 950 | $380,000 | $190,000 | 50% | Outlet |
100 | Walmart | 1197831 | 18/08/2020 | 2020-8 | South | Texas | Houston | Men's Street Footwear | $40.00 | 950 | $380,000 | $133,000 | 35% | Outlet |