Spreadsheet: 132741d1323898990-pulling-top-10-to-a-new-sheet-sales
Sheet: Data

Supplier | Sales | Cost | # of Units | Margin | % Margin | Total % of Sales | unique rank of %sales
PAR020 | 16845115.79 | 9795284.04 | 539095 | 7049831.750000003 | 0.4185089516680611 | 0.2062663028529496 | 97
UNI015 | 10927095 | 7189326.329999998 | 57208 | 3737768.67 | 0.3420642604461663 | 0.1093608687158366 | 96
GIO073 | 8045572 | 5613013.7 | 314571 | 2432558.3 | 0.3023474651646892 | 0.07117259316369583 | 95
REM016 | 8359482 | 6650951.179999999 | 29898 | 1708530.82 | 0.204382379195266 | 0.04998875832061073 | 92
BAC028 | 7738299 | 5747317.680000002 | 96753 | 1990981.32 | 0.2572892724874033 | 0.05825278822089409 | 94
UNI010 | 5457543 | 3692676.37 | 27453 | 1764866.63 | 0.3233811680457671 | 0.0516370500329521 | 93
JIM019 | 6489411 | 5028298.52 | 29090 | 1461112.48 | 0.2251533274745582 | 0.04274971091358373 | 91
PAR370 | 3383078.71 | 2210141.62 | 93737 | 1172937.09 | 0.3467070058207427 | 0.03431818029322435 | 90
GIO076 | 10276047.05 | 9116727.620000001 | 155483 | 1159319.43 | 0.11281764518585 | 0.0339197503049188 | 89
DFC003 | 18245311 | 17259269.54 | 105266 | 986041.4600000005 | 0.05404355453299758 | 0.02884992629986163 | 88
LAN094 | 4593287.5 | 3645004.1 | 203087 | 948283.4 | 0.2064498248803281 | 0.02774518852521901 | 87
GIO074 | 3116166.5 | 2399647.429999999 | 116548 | 716519.07 | 0.2299360672801019 | 0.02096415130652354 | 83
EST001 | 4569323.25 | 3838428.159999998 | 199910 | 730895.09 | 0.1599569673692926 | 0.02138476964186752 | 84
[NAME] | 2877952 | 2122345.77 | 22464 | 755606.23 | 0.2625499765110745 | 0.02210777632739325 | 85
UNI036 | 1680354 | 871661.3699999998 | 7472 | 808692.63 | 0.4812632516719693 | 0.02366099573007941 | 86
PER014 | 5135797 | 4541641.070000002 | 41251 | 594155.93 | 0.1156891384141546 | 0.01738401019276182 | 82
MOE053 | 1274795 | 718171.5400000002 | 2687 | 556623.46 | 0.4366376240885789 | 0.01628587280475404 | 81
VSB101 | 2466307.75 | 1951273.45 | 539741 | 515034.3 | 0.2088280750851146 | 0.01506904344255547 | 80
BRO040 | 2578604 | 2162418.64 | 23463 | 416185.36 | 0.1613994859233911 | 0.01217688854896768 | 79
UNI018 | 624088 | 261527.47 | 1453 | 362560.53 | 0.5809445623053159 | 0.0106079155837309 | 78
KEN134 | 1951134 | 1590329.27 | 62151 | 360804.73 | 0.1849205282671513 | 0.01055654380814927 | 77
DFASSL | 1430760 | 1108190.59 | 22845 | 322569.41 | 0.2254531927087702 | 0.009437842202994026 | 76
MOE072 | 975062 | 686769.17 | 2304 | 288292.83 | 0.2956661525113276 | 0.00843496671861905 | 75
YSL170 | 1541205 | 1276576.81 | 60516 | 264628.19 | 0.1717021356665726 | 0.007742578875299803 | 74
BET045 | 1755916 | 1508641.33 | 80013 | 247274.67 | 0.1408237466940332 | 0.007234843862774902 | 73
LOC206 | 1097504 | 853148.64 | 51178 | 244355.36 | 0.2226464413797125 | 0.007149429727808966 | 72
CLA035 | 1043857.95 | 822291.1100000001 | 45975 | 221566.84 | 0.2122576544059467 | 0.006482675692453369 | 71
PAR380 | 578114.51 | 367015.6299999999 | 16079 | 211098.88 | 0.3651506342575625 | 0.006176400665731978 | 70
COT053 | 1465891.5 | 1281943.74 | 59383 | 183947.76 | 0.1254852490788029 | 0.005382004240495763 | 69
CHR113 | 948092.7 | 786755.0800000003 | 35355 | 161337.62 | 0.1701707227573844 | 0.00472046930602196 | 68
BPI104 | 902967.5 | 753858.4300000002 | 34105 | 149109.07 | 0.1651322666651901 | 0.004362682356318879 | 67
PER053 | 696197 | 571262.1500000003 | 1993 | 124934.85 | 0.179453301292594 | 0.003655385053265679 | 66
BAC030 | 433406 | 321703.52 | 6849 | 111702.48 | 0.2577317342168775 | 0.003268228006874849 | 65
SCE053 | 1261439 | 1159435.5 | 50543 | 102003.5 | 0.080862808268969 | 0.002984452050655085 | 63
BAC027 | 741870 | 633907.1900000002 | 9247 | 107962.81 | 0.1455279361613221 | 0.003158811508418686 | 64
SHI101 | 1136916.7 | 1047358.4 | 43113 | 89558.3 | 0.07877296551277678 | 0.002620326283786177 | 62
ESS045 | 431059 | 352613.12 | 16379 | 78445.88 | 0.1819840903449412 | 0.002295195433798279 | 61
LAN096 | 407603 | 334098.35 | 17259 | 73504.65 | 0.1803339278660854 | 0.002150623296506339 | 60
CLA053 | 565461.5 | 493014.73 | 23327 | 72446.77 | 0.1281197216786643 | 0.002119671494505947 | 59
BAC031 | 316965 | 245703 | 4101 | 71262 | 0.2248260848989636 | 0.002085007103028648 | 58
REMY16 | 669156 | 600792.42 | 3728 | 68363.58 | 0.1021638900346108 | 0.002000204174573647 | 57
PUR013 | 500344 | 435165.22 | 18431 | 65178.78 | 0.1302679356602658 | 0.001907022245611148 | 56
CAMUS | 239650 | 178152.5 | 650 | 61497.5 | 0.256613811808888 | 0.001799314141035956 | 55
STR001 | 427281.6 | 368506.6 | 14440 | 58775 | 0.137555654163437 | 0.001719658337971272 | 54
DFS032 | 270077 | 236080.3 | 9365 | 33996.7 | 0.1258778052185117 | 0.0009946866630116196 | 46
PERN14 | 558164 | 502689.79 | 6461 | 55474.21 | 0.09938693645595201 | 0.001623082735327424 | 53
GIO053 | 280068 | 234339.08 | 11152 | 45728.92 | 0.1632779182198609 | 0.001337951825851489 | 52
LAN095 | 581858.5 | 536970.53 | 24019 | 44887.97 | 0.07714585247100454 | 0.001313347033349287 | 51
PRA101 | 425547 | 384108.8 | 8592 | 41438.2 | 0.09737631800952658 | 0.001212412524721755 | 50
PAR360 | 132661.5 | 95542.48000000003 | 4357 | 37119.02 | 0.2798025048714208 | 0.001086040531523988 | 49
RIC101 | 449975 | 413212.8 | 15402 | 36762.2 | 0.08169831657314296 | 0.001075600574260613 | 48
YSL171 | 296841 | 262597.26 | 8800 | 34243.74 | 0.1153605465552266 | 0.001001914640822125 | 47
CHR114 | 423786 | 389998.9099999999 | 12066 | 33787.09 | 0.07972677247478681 | 0.0009885538244880612 | 45
GIV111 | 392676 | 360016.1699999999 | 19102 | 32659.83 | 0.08317246279375363 | 0.0009555720795614512 | 44
LOC053 | 179450 | 149483.94 | 7834 | 29966.06 | 0.1669883533017553 | 0.0008767568683138651 | 43
CUE011 | 403412 | 373519.05 | 5409 | 29892.95 | 0.07410029944572794 | 0.000874617791817241 | 42
BUL152 | 242773 | 223205.81 | 10306 | 19567.19 | 0.08059870743451704 | 0.0005725032996030303 | 41
WIL100 | 110183 | 90782.32999999999 | 1543 | 19400.67 | 0.1760767995062759 | 0.0005676312025134686 | 40
CUP155 | 139440 | 123404.4 | 4648 | 16035.6 | 0.115 | 0.0004691748744257275 | 39
LPR053 | 264045 | 248111.9 | 4610 | 15933.1 | 0.060342365884603 | 0.0004661758956142931 | 38
ESS046 | 134837.3 | 120244.29 | 4867 | 14593.01 | 0.1082268037108426 | 0.0004269671003419507 | 37
GIV118 | 99141 | 85517.99000000002 | 4490 | 13623.01 | 0.1374104558154547 | 0.0003985865203703278 | 36
BUL154 | 122198.1 | 111021.02 | 5491 | 11177.08 | 0.0914668886013776 | 0.0003270226935971407 | 35
CLA033 | 203931.5 | 193237 | 5974 | 10694.5 | 0.05244162868414147 | 0.0003129032087696089 | 34
PATR59 | 45775 | 37548.25 | 237 | 8226.75 | 0.1797214636810486 | 0.0002407009652387097 | 33
EST053 | 27795 | 19883.22 | 1137 | 7911.78 | 0.2846475984889368 | 0.0002314854690802952 | 32
BPI105 | 104610 | 96820.26999999999 | 4021 | 7789.73 | 0.07446448714272057 | 0.0002279144899199482 | 31
PUR012 | 47286 | 41643.2 | 1924 | 5642.8 | 0.1193334179249672 | 0.0001650989037771892 | 30
KEN135 | 129533.4 | 124520.88 | 5538 | 5012.52 | 0.03869673767537948 | 0.0001466579636282052 | 29
RIC202 | 80544.5 | 76841.29999999999 | 2639 | 3703.2 | 0.04597706857699781 | 0.0001083494471658905 | 28
BPI053 | 23200 | 19520 | 800 | 3680 | 0.1586206896551724 | 0.000107670653912961 | 27
MOET72 | 14400 | 12117.6 | 120 | 2282.4 | 0.1585 | 6.677921208992993e-05 | 26
ILL001 | 24930 | 22793 | 236 | 2137 | 0.0857200160449258 | 6.252505092717326e-05 | 25
ALE006 | 39896 | 38295.22 | 1579 | 1600.78 | 0.04012382193703627 | 4.683614928554064e-05 | 24
MBC051 | 14009.6 | 12700.16 | 1408 | 1309.44 | 0.09346733668341708 | 3.831202746189881e-05 | 23
MON200 | 30865.7 | 30031.9 | 2267 | 833.8 | 0.02701380496797416 | 2.43955954436486e-05 | 22
WHY041 | 4872 | 4502.5 | 18 | 369.5 | 0.0758415435139573 | 1.081095288609758e-05 | 21
[NAME] | 2730 | 2372.24 | 26 | 357.76 | 0.1310476190476191 | 1.046746009345134e-05 | 20
PAT159 | 675 | 498.09 | 3 | 176.91 | 0.2620888888888889 | 5.176091136886393e-06 | 19
50 | 3500 | 6656.63 | 160 | -3156.63 | -0.9018942857142858 | -9.235772181012772e-05 | 4
CAR110 | 209 | 176 | 11 | 33 | 0.1578947368421053 | 9.655248856325306e-07 | 18
MVC204 | 1728 | 1713.6 | 108 | 14.4 | 0.008333333333333333 | 4.213199500941951e-07 | 17
ZAM042 | 90 | 83.47 | 1 | 6.53 | 0.07255555555555555 | 1.910568940357704e-07 | 16
GMP230 | 2591.61 | 2591.61 | 147 | 0 | 0 | 0 | 15
CHA007 | 320 | 372.08 | 4 | -52.08 | -0.16275 | -1.523773819507339e-06 | 13
DFASS | 2078.75 | 2158.66 | 115 | -79.91 | -0.03844137101623572 | -2.338033139724106e-06 | 12
MAX015 | 32007 | 32098.37 | 586 | -91.36999999999989 | -0.002854688036991905 | -2.6733336000074e-06 | 11
WEB077 | 1025 | 1202.83 | 22 | -177.83 | -0.1734926829268293 | -5.203008800364633e-06 | 10
CAR109 | 10762 | 11121.22 | 446 | -359.22 | -0.03337855417208697 | -1.051017725505811e-05 | 9
INT216 | 1740 | 2171.52 | 174 | -431.52 | -0.248 | -1.262555450448938e-05 | 8
BAC029 | 1100 | 1816.98 | 22 | -716.98 | -0.6518 | -2.097763734850945e-05 | 7
BUL153 | 0 | 0 | 0 | 0 | - | 0 | 14
CHA004 | 3240 | 4793.4 | 30 | -1553.4 | -0.4794444444444445 | -4.54498896164113e-05 | 6
PRL175 | 3479 | 5591.25 | 497 | -2112.25 | -0.6071428571428571 | -6.180090726294886e-05 | 5
VIC054 | 6868 | 10717.6 | 920 | -3849.6 | -0.5605125218404194 | -0.0001126328666585148 | 3
PAC236 | 9674 | 19146.48 | 1050 | -9472.48 | -0.9791689063469092 | -0.0002771489445047404 | 2
EST002 | 162163 | 199003.6599999999 | 11766 | -36840.66 | -0.2271828962217028 | -0.001077896182822028 | 1
Total | 152746245.97 | 118567945.14 | 3499094 | 34178300.83000003 | 0.2237586960841761 | 0.9999999999999983