| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Region | Country | Item_Type | Sales_Rep | Sales_Channel | Order_Priority | Order_Date | Ship_Date | Units_Sold | Unit_Price | Unit_Cost | Total_Revenue | Total_Cost | Total_Profit | Order_Month | Order_Year |
2 | Oceania | new Zealand | Cereals | John Smith | Offline | L | 43978.22517 | 43980.22517 | 510 | 5763.1548 | 3768216.6 | 2939208.948 | 829007.652 | 5 | 2020 | |
3 | europe | Germany | Furniture | Michael Brown | Online | H | 45167.84414 | 45171.84414 | 85 | 1702.33 | 1532.097 | 144698.05 | 130228.245 | 14469.805 | 8 | 2023 |
4 | south America | Brazil | Households | John Smith | Online | H | 43377.76941 | 43386.76941 | 563 | 2867.88 | 2036.1948 | 1614616.44 | 1146377.672 | 468238.7676 | 10 | 2018 |
5 | Sub Saharan Africa | KenyaGhana | Fruits | John Smith | Online | M | 42099.10275 | 42107.10275 | 607 | 5726.8 | 5154.12 | 3476167.6 | 3128550.84 | 347616.76 | 4 | 2015 |
6 | South America | chile | Toys | John Smith | Offline | M | 43796.67985 | 43797.67985 | 790 | 1871.1628 | 2173850.9 | 1478218.612 | 695632.288 | 11 | 2019 | |
7 | north America | Canada | Cereals | Ray Terdoo | Offline | L | 43335.31351 | 43343.31351 | 1689.86 | 1199.8006 | 15208.74 | 10798.2054 | 4410.5346 | 8 | 2018 | |
8 | Oceania | new Zealand | Snacks | Philmena Mnguember | Offline | H | 42152.05116 | 42161.05116 | 859 | 8856.13 | 5136.5554 | 7607415.67 | 4412301.089 | 3195114.581 | 5 | 2015 |
9 | North America | Jamaica | Baby Food | Dorcas Moses | Online | M | 45269.35225 | 45277.35225 | 89 | 9068.17 | 5078.1752 | 807067.13 | 451957.5928 | 355109.5372 | 12 | 2023 |
10 | South America | Columbia | Cereals | Moses Kor | Online | C | 42895.89438 | 42896.89438 | 89 | 373.35 | 328.548 | 33228.15 | 29240.772 | 3987.378 | 6 | 2017 |
11 | Europe | Portugal | Households | John Smith | Online | M | 42198.99204 | 42206.99204 | 219 | 5006.21 | 4455.5269 | 1096359.99 | 975760.3911 | 120599.5989 | 7 | 2015 |
12 | north America | Cuba | Households | Michael Brown | Online | C | 42991.10487 | 42996.10487 | 842 | 2044.75 | 1472.22 | 1721679.5 | 1239609.24 | 482070.26 | 9 | 2017 |
13 | South America | Brazil | Fruits | Philmena Mnguember | Offline | H | 43684.61844 | 43693.61844 | 350 | 8635.45 | 5267.6245 | 3022407.5 | 1843668.575 | 1178738.925 | 8 | 2019 |
14 | Europe | Spain | Toys | Philmena Mnguember | Offline | L | 43616.39252 | 43625.39252 | 891 | 4630.59 | 4074.9192 | 4125855.69 | 3630753.007 | 495102.6828 | 5 | 2019 |
15 | Europe | Sweden | Furniture | John Smith | Offline | H | 42759.94779 | 42765.94779 | 900 | 4789.79 | 3927.6278 | 4310811 | 3534865.02 | 775945.98 | 1 | 2017 |
16 | Europe | Sweden | Fruits | Clare Wuese | Online | H | 42978.7885 | 42981.7885 | 405 | 6278.45 | 3578.7165 | 2542772.25 | 1449380.182 | 1093392.068 | 8 | 2017 |
17 | Oceania | New Zealand | Fruits | John Smith | Online | H | 44797.90172 | 44804.90172 | 892 | 565.68 | 350.7216 | 504586.56 | 312843.6672 | 191742.8928 | 8 | 2022 |
18 | Asia | China | Baby Food | Clare Wuese | Offline | H | 43217.95404 | 43220.95404 | 798 | 640.855 | 1022804.58 | 511402.29 | 511402.29 | 4 | 2018 | |
19 | Sub Saharan Africa | Mali | Cosmetics | John Smith | Online | L | 44169.64818 | 44176.64818 | 161 | 4988.87 | 3641.8751 | 803208.07 | 586341.8911 | 216866.1789 | 12 | 2020 |
20 | Sub Saharan Africa | KenyaGhana | Toys | Michael Brown | Offline | M | 43369.89447 | 43377.89447 | 9667.4 | 6863.854 | 415698.2 | 295145.722 | 120552.478 | 9 | 2018 | |
21 | Sub Saharan Africa | KenyaGhana | Clothing | Clare Wuese | Online | L | 43572.70279 | 43577.70279 | 474 | 8437.62 | 4809.4434 | 3999431.88 | 2279676.172 | 1719755.708 | 4 | 2019 |
22 | Asia | Russia | Fruits | Ray Terdoo | Online | L | 42115.53491 | 42120.53491 | 758 | 8894.72 | 5692.6208 | 6742197.76 | 4315006.566 | 2427191.194 | 4 | 2015 |
23 | Sub Saharan Africa | Cameron | Cosmetics | Philmena Mnguember | Online | L | 42739.30622 | 42743.30622 | 258 | 1380.18 | 1214.5584 | 356086.44 | 313356.0672 | 42730.3728 | 1 | 2017 |
24 | Europe | Portugal | Clothing | John Smith | Online | L | 44395.41131 | 44398.41131 | 855 | 9586.65 | 7285.854 | 8196585.75 | 6229405.17 | 1967180.58 | 7 | 2021 |
25 | Asia | India | Toys | Philmena Mnguember | Online | M | 44626.52848 | 44634.52848 | 159 | 7302.63 | 6207.2355 | 1161118.17 | 986950.4445 | 174167.7255 | 3 | 2022 |
26 | North America | Canada | Electronics | John Smith | Offline | H | 43674.9266 | 43680.9266 | 132 | 3263.59 | 2741.4156 | 430793.88 | 361866.8592 | 68927.0208 | 7 | 2019 |
27 | Oceania | New Zealand | Snacks | Dorcas Moses | Offline | M | 42727.08719 | 42733.08719 | 559 | 8646.03 | 7522.0461 | 4833130.77 | 4204823.77 | 628307.0001 | 12 | 2016 |
28 | Asia | Russia | Cosmetics | Dorcas Moses | Offline | M | 43708.28418 | 43710.28418 | 852 | 7475.63 | 3887.3276 | 6369236.76 | 3312003.115 | 3057233.645 | 8 | 2019 |
29 | Europe | Luxembourg | Beverages | Alice Johnson | Online | H | 44615.89039 | 44619.89039 | 601 | 7367.73 | 4420.638 | 4428005.73 | 2656803.438 | 1771202.292 | 2 | 2022 |
30 | Europe | Turkey | Electronics | John Smith | Offline | M | 42240.72995 | 42245.72995 | 45 | 7348.86 | 4923.7362 | 330698.7 | 221568.129 | 109130.571 | 8 | 2015 |
31 | Oceania | Australia | Households | Alice Johnson | Offline | L | 45077.30525 | 45082.30525 | 8010.53 | 6088.0028 | 2571380.13 | 1954248.899 | 617131.2312 | 5 | 2023 | |
32 | Sub Saharan Africa | Cameron | Households | Moses Kor | Online | L | 45234.54388 | 45237.54388 | 194 | 9485.81 | 7019.4994 | 1840247.14 | 1361782.884 | 478464.2564 | 11 | 2023 |
33 | Oceania | Australia | Snacks | Jane Fisher | Online | H | 42165.65241 | 42170.65241 | 518 | 1377.35 | 826.41 | 713467.3 | 428080.38 | 285386.92 | 6 | 2015 |
34 | Oceania | New Zealand | Baby Food | Jane Fisher | Offline | H | 44176.88777 | 44181.88777 | 263 | 5797.2334 | 2628745.49 | 1524672.384 | 1104073.106 | 12 | 2020 | |
35 | Asia | Indinesia | Cereals | Philmena Mnguember | Offline | H | 43925.44413 | 43927.44413 | 435 | 8724.67 | 5845.5289 | 3795231.45 | 2542805.072 | 1252426.379 | 4 | 2020 |
36 | South America | Paraguay | Furniture | Clare Wuese | Offline | L | 44166.38176 | 44171.38176 | 708 | 4421.86 | 2653.116 | 3130676.88 | 1878406.128 | 1252270.752 | 12 | 2020 |
37 | Oceania | Australia | Beverages | John Smith | Offline | H | 43466.9842 | 43469.9842 | 530 | 1582.8 | 1408.692 | 838884 | 746606.76 | 92277.24 | 1 | 2019 |
38 | Europe | Italy | Baby Food | Chris Lee | Offline | M | 44835.25206 | 44838.25206 | 887 | 4043.5815 | 4029951.45 | 3586656.791 | 443294.6595 | 10 | 2022 | |
39 | Asia | China | Toys | John Smith | Online | M | 45181.68743 | 45186.68743 | 297 | 7788.33 | 4283.5815 | 2313134.01 | 1272223.706 | 1040910.304 | 9 | 2023 |
40 | South America | Paraguay | Baby Food | John Smith | Offline | C | 45192.88632 | 45201.88632 | 501 | 6028.51 | 4702.2378 | 3020283.51 | 2355821.138 | 664462.3722 | 9 | 2023 |
41 | Europe | Turkey | Cereals | Chris Lee | Offline | C | 42596.20872 | 42598.20872 | 619 | 2802.71 | 1653.5989 | 1734877.49 | 1023577.719 | 711299.7709 | 8 | 2016 |
42 | Oceania | New Zealand | Toys | Jane Fisher | Offline | H | 45106.88477 | 45115.88477 | 69 | 4073.88 | 3218.3652 | 281097.72 | 222067.1988 | 59030.5212 | 6 | 2023 |
43 | North America | Jamaica | Beverages | Alice Johnson | Offline | C | 42517.1845 | 42520.1845 | 25 | 9543.45 | 7730.1945 | 238586.25 | 193254.8625 | 45331.3875 | 5 | 2016 |
44 | Sub Saharan Africa | Mali | Cereals | Moses Kor | Offline | L | 43875.08412 | 43882.08412 | 568 | 8040.17 | 4180.8884 | 4566816.56 | 2374744.611 | 2192071.949 | 2 | 2020 |
45 | Sub Saharan Africa | South Africa | Clothing | Philmena Mnguember | Offline | L | 45212.40347 | 45213.40347 | 513 | 1249.45 | 974.571 | 640967.85 | 499954.923 | 141012.927 | 10 | 2023 |
46 | Oceania | Australia | Furniture | Jane Fisher | Online | M | 44577.39586 | 44578.39586 | 5458.47 | 4694.2842 | 5425719.18 | 4666118.495 | 759600.6852 | 1 | 2022 | |
47 | Asia | China | Beverages | Chris Lee | Online | M | 44441.39931 | 44449.39931 | 183 | 9310.54 | 5493.2186 | 1703828.82 | 1005259.004 | 698569.8162 | 9 | 2021 |
48 | South America | Chile | Clothing | John Smith | Online | C | 42473.18177 | 42482.18177 | 899 | 352.74 | 194.007 | 317113.26 | 174412.293 | 142700.967 | 4 | 2016 |
49 | Sub Saharan Africa | Mali | Snacks | Jane Fisher | Offline | C | 44943.06706 | 44946.06706 | 54 | 435.05 | 317.5865 | 23492.7 | 17149.671 | 6343.029 | 1 | 2023 |
50 | North America | Canada | Beverages | Michael Brown | Offline | L | 44634.42209 | 44640.42209 | 81 | 7170.16 | 5090.8136 | 580782.96 | 412355.9016 | 168427.0584 | 3 | 2022 |
51 | Sub Saharan Africa | Nigeria | Snacks | Dorcas Moses | Online | M | 44669.41521 | 44672.41521 | 160 | 5759.7 | 4895.745 | 921552 | 783319.2 | 138232.8 | 4 | 2022 |
52 | Oceania | New Zealand | Toys | John Smith | Offline | C | 44995.15644 | 45001.15644 | 984 | 469.53 | 319.2804 | 462017.52 | 314171.9136 | 147845.6064 | 3 | 2023 |
53 | Asia | Indinesia | Clothing | Moses Kor | Offline | L | 45016.872 | 45023.872 | 386 | 9960.2 | 6673.334 | 3844637.2 | 2575906.924 | 1268730.276 | 3 | 2023 |
54 | Oceania | Australia | Furniture | Basil Oryiman | Offline | M | 43801.25773 | 43806.25773 | 449 | 5805.15 | 4586.0685 | 2606512.35 | 2059144.757 | 547367.5935 | 12 | 2019 |
55 | Europe | UK | Cereals | Chris Lee | Online | L | 44453.76419 | 44456.76419 | 738 | 4924.38 | 2609.9214 | 3634192.44 | 1926121.993 | 1708070.447 | 9 | 2021 |
56 | Sub Saharan Africa | South Africa | Fruits | Ray Terdoo | Online | L | 42874.19426 | 42882.19426 | 264 | 4482.49 | 2330.8948 | 1183377.36 | 615356.2272 | 568021.1328 | 5 | 2017 |
57 | Sub Saharan Africa | Gambia | Baby Food | Clare Wuese | Online | M | 43789.7656 | 43794.7656 | 621 | 7009.83 | 4906.881 | 4353104.43 | 3047173.101 | 1305931.329 | 11 | 2019 |
58 | North America | Cuba | Electronics | Ray Terdoo | Offline | L | 43018.43986 | 43019.43986 | 954 | 4588.99 | 2478.0546 | 4377896.46 | 2364064.088 | 2013832.372 | 10 | 2017 |
59 | Europe | Turkey | Furniture | Jane Fisher | Online | C | 43262.17942 | 43271.17942 | 309 | 6594.18 | 5802.8784 | 2037601.62 | 1793089.426 | 244512.1944 | 6 | 2018 |
60 | Oceania | Australia | Clothing | John Smith | Online | L | 45158.22221 | 45161.22221 | 44 | 4888.46 | 3715.2296 | 215092.24 | 163470.1024 | 51622.1376 | 8 | 2023 |
61 | North America | Canada | Fruits | Clare Wuese | Online | C | 42375.39924 | 42377.39924 | 201 | 6111.07 | 4888.856 | 1228325.07 | 982660.056 | 245665.014 | 1 | 2016 |
62 | North America | Jamaica | Furniture | Clare Wuese | Offline | H | 45047.79345 | 45050.79345 | 284 | 8053.81 | 4751.7479 | 2287282.04 | 1349496.404 | 937785.6364 | 5 | 2023 |
63 | South America | Chile | Clothing | Philmena Mnguember | Online | H | 44957.1273 | 44964.1273 | 147 | 8173.51 | 5721.457 | 1201505.97 | 841054.179 | 360451.791 | 1 | 2023 |
64 | Sub Saharan Africa | KenyaGhana | Cosmetics | Ray Terdoo | Online | H | 42255.32473 | 42263.32473 | 440 | 8491.99 | 4670.5945 | 3736475.6 | 2055061.58 | 1681414.02 | 9 | 2015 |
65 | Europe | Germany | Cosmetics | John Smith | Offline | L | 42629.57262 | 42631.57262 | 404 | 2037.67 | 1181.8486 | 823218.68 | 477466.8344 | 345751.8456 | 9 | 2016 |
66 | North America | Jamaica | Snacks | Philmena Mnguember | Online | H | 44633.21361 | 44640.21361 | 711 | 620.59 | 453.0307 | 441239.49 | 322104.8277 | 119134.6623 | 3 | 2022 |
67 | Oceania | Australia | Furniture | Alice Johnson | Offline | H | 45031.595 | 45036.595 | 746 | 8363.02 | 5101.4422 | 6238812.92 | 3805675.881 | 2433137.039 | 4 | 2023 |
68 | South America | Paraguay | Cosmetics | Moses Kor | Offline | L | 44394.17255 | 44403.17255 | 184 | 432.56 | 376.3272 | 79591.04 | 69244.2048 | 10346.8352 | 7 | 2021 |
69 | Sub Saharan Africa | Mali | Clothing | Ray Terdoo | Online | M | 42498.01459 | 42505.01459 | 547 | 2142.77 | 1928.493 | 1172095.19 | 1054885.671 | 117209.519 | 5 | 2016 |
70 | Europe | Spain | Snacks | Dorcas Moses | Online | L | 45166.81807 | 45167.81807 | 915 | 5266.73 | 2633.365 | 4819057.95 | 2409528.975 | 2409528.975 | 8 | 2023 |
71 | South America | Uruguay | Clothing | Dorcas Moses | Online | C | 44541.62325 | 44542.62325 | 209 | 8555.78 | 6844.624 | 1788158.02 | 1430526.416 | 357631.604 | 12 | 2021 |
72 | North America | Cuba | Snacks | Moses Kor | Offline | L | 43031.41823 | 43037.41823 | 872 | 4932.862 | 7820828.48 | 4301455.664 | 3519372.816 | 10 | 2017 | |
73 | Asia | Japan | Furniture | Philmena Mnguember | Online | M | 44333.26662 | 44342.26662 | 575 | 6284.23 | 4587.4879 | 3613432.25 | 2637805.542 | 975626.7075 | 5 | 2021 |
74 | Sub Saharan Africa | Gambia | Fruits | Moses Kor | Online | H | 44759.76678 | 44760.76678 | 82 | 9667.92 | 5704.0728 | 792769.44 | 467733.9696 | 325035.4704 | 7 | 2022 |
75 | North America | USA | Cereals | Alice Johnson | Online | L | 44910.16922 | 44913.16922 | 263 | 7302.13 | 6498.8957 | 1920460.19 | 1709209.569 | 211250.6209 | 12 | 2022 |
76 | Asia | Philipines | Beverages | Michael Brown | Offline | H | 43143.81409 | 43148.81409 | 767 | 5281.97 | 4489.6745 | 4051270.99 | 3443580.342 | 607690.6485 | 2 | 2018 |
77 | Europe | UK | Fruits | Michael Brown | Offline | C | 43241.09367 | 43245.09367 | 1352.36 | 1000.7464 | 1248228.28 | 923688.9272 | 324539.3528 | 5 | 2018 | |
78 | Europe | Italy | Toys | Dorcas Moses | Offline | M | 42076.84362 | 42077.84362 | 39 | 4293.57 | 2447.3349 | 167449.23 | 95446.0611 | 72003.1689 | 3 | 2015 |
79 | Sub Saharan Africa | KenyaGhana | Clothing | Basil Oryiman | Online | H | 42572.98237 | 42576.98237 | 286 | 8225.19 | 6662.4039 | 2352404.34 | 1905447.515 | 446956.8246 | 7 | 2016 |
80 | North America | Jamaica | Toys | Chris Lee | Online | H | 42961.93172 | 42965.93172 | 23 | 2843.64 | 2018.9844 | 65403.72 | 46436.6412 | 18967.0788 | 8 | 2017 |
81 | North America | Mexico | Fruits | Moses Kor | Offline | H | 43690.44829 | 43694.44829 | 596 | 5786.93 | 4282.3282 | 3449010.28 | 2552267.607 | 896742.6728 | 8 | 2019 |
82 | North America | Mexico | Snacks | Chris Lee | Online | H | 45029.42755 | 45032.42755 | 919 | 9834.51 | 7769.2629 | 9037914.69 | 7139952.605 | 1897962.085 | 4 | 2023 |
83 | Sub Saharan Africa | Gambia | Beverages | Basil Oryiman | Online | L | 42005.36587 | 42012.36587 | 474 | 1752.5 | 1174.175 | 830685 | 556558.95 | 274126.05 | 1 | 2015 |
84 | Asia | India | Beverages | Philmena Mnguember | Offline | M | 42037.67753 | 42038.67753 | 303 | 1023.56 | 511.78 | 310138.68 | 155069.34 | 155069.34 | 2 | 2015 |
85 | Europe | Luxembourg | Electronics | Moses Kor | Offline | M | 44173.46654 | 44175.46654 | 206 | 7958.01 | 5172.7065 | 1639350.06 | 1065577.539 | 573772.521 | 12 | 2020 |
86 | Sub Saharan Africa | Zimbabwe | Beverages | Chris Lee | Offline | H | 44843.62378 | 44844.62378 | 432 | 258.97 | 173.5099 | 111875.04 | 74956.2768 | 36918.7632 | 10 | 2022 |
87 | Asia | Philipines | Cereals | Chris Lee | Online | M | 43460.58545 | 43464.58545 | 95 | 6436.13 | 4183.4845 | 611432.35 | 397431.0275 | 214001.3225 | 12 | 2018 |
88 | Sub Saharan Africa | Mali | Beverages | Ray Terdoo | Online | H | 45050.96691 | 45055.96691 | 475 | 3364.09 | 2792.1947 | 1597942.75 | 1326292.483 | 271650.2675 | 5 | 2023 |
89 | South America | Peru | Fruits | Ray Terdoo | Online | C | 45224.44564 | 45229.44564 | 575 | 7240.9 | 4561.767 | 4163517.5 | 2623016.025 | 1540501.475 | 10 | 2023 |
90 | Sub Saharan Africa | Cameron | Electronics | Basil Oryiman | Offline | C | 42551.40796 | 42553.40796 | 376 | 1211.33 | 811.5911 | 455460.08 | 305158.2536 | 150301.8264 | 6 | 2016 |
91 | Oceania | New Zealand | Fruits | John Smith | Offline | C | 42294.38468 | 42297.38468 | 137 | 3307.14 | 1719.7128 | 453078.18 | 235600.6536 | 217477.5264 | 10 | 2015 |
92 | Oceania | New Zealand | Fruits | Moses Kor | Online | M | 43301.04177 | 43305.04177 | 151 | 180.2 | 142.358 | 27210.2 | 21496.058 | 5714.142 | 7 | 2018 |
93 | Sub Saharan Africa | Mali | Households | Alice Johnson | Offline | H | 44613.79347 | 44619.79347 | 629 | 2358.56 | 1391.5504 | 1483534.24 | 875285.2016 | 608249.0384 | 2 | 2022 |
94 | South America | Argentina | Baby Food | Philmena Mnguember | Offline | L | 45082.56163 | 45088.56163 | 703 | 4837.75 | 2854.2725 | 3400938.25 | 2006553.568 | 1394384.682 | 6 | 2023 |
95 | South America | Paraguay | Electronics | Ray Terdoo | Online | L | 44708.7075 | 44710.7075 | 202 | 1784.36 | 1302.5828 | 360440.72 | 263121.7256 | 97318.9944 | 5 | 2022 |
96 | North America | Cuba | Fruits | Ray Terdoo | Offline | C | 43175.38748 | 43177.38748 | 943 | 6000.56 | 5340.4984 | 5658528.08 | 5036089.991 | 622438.0888 | 3 | 2018 |
97 | Europe | Italy | Baby Food | Michael Brown | Online | C | 43615.38405 | 43624.38405 | 250 | 1190.28 | 785.5848 | 297570 | 196396.2 | 101173.8 | 5 | 2019 |
98 | Sub Saharan Africa | Mali | Baby Food | Moses Kor | Offline | M | 42503.26472 | 42505.26472 | 599 | 7454.78 | 4696.5114 | 4465413.22 | 2813210.329 | 1652202.891 | 5 | 2016 |
99 | Europe | Turkey | Electronics | Alice Johnson | Online | L | 45187.5135 | 45189.5135 | 74 | 9217.43 | 4700.8893 | 682089.82 | 347865.8082 | 334224.0118 | 9 | 2023 |
100 | Asia | India | Households | Moses Kor | Offline | M | 44342.44398 | 44345.44398 | 322 | 3865.4 | 3130.974 | 1244658.8 | 1008173.628 | 236485.172 | 5 | 2021 |