Spreadsheet: 477397d1472271723-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: PM_multiple suppliers

 | SKU | Suppliers | Spend (in Cr) | Price per Unit | Qty Procured | Spend at lowest cost procurement [NAME]) | Saving at lowest cost procurement
 | Bottle - Pantaloon 200ml Round |  | 0.051986 |  |  | 0.04742400000000001 | 0.004561999999999997
 |  | [NAME] | 0.006006 | 5.46 | 11000
 |  | Weener Empire Plastics | 0.01235 | 4.94 | 25000
 |  | Weener Empire Plastics Ltd | 0.03363 | 5.605 | 60000
 | Bottle New Body Lotion350ml |  | 0.05733907504 |  |  | 0.05296327504 | 0.004375799999999999
 |  | Eon Plast Industries | 0.02167804704 | 8.507200000000001 | 25482
 |  | [NAME] | 0.004168528 | 8.507200000000001 | 4900
 |  | [NAME] | 0.0314925 | 9.88 | 31875
 | CFB [NAME] Pcs 5ply |  | 0.006573138 |  |  | 0.006466954 | 0.0001061840000000005
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.001105884 | 36.14000000000001 | 306
 |  | Harsh Beautycare & Packaging | 0.0019059508 | 37.74160000000001 | 505
 |  | [NAME] | 0.0035613032 | 35.828 | 994
 | CFB [NAME] Range50gtube72pcs |  | 0.0214387212 |  |  | 0.0213685732 | 7.014800000000598e-05
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0137769788 | 19.396 | 7103
 |  | Harsh Beautycare & Packaging | 0.005303188800000001 | 19.656 | 2698
 |  | [NAME] | 0.0023585536 | 19.396 | 1216
 | CFB-AllPur.Crm 150ml |  | 0.01488582264 |  |  | 0.0102619348 | 0.00462388784
 |  | Ankur Paper Agency | 0.0007454085600000001 | 14.3624 | 519
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.01118471328 | 21.3408 | 5241
 |  | Harsh Beautycare & Packaging | 0.0029557008 | 21.3408 | 1385
 | Inner 100ml - Tube |  | 0.03341637104000001 |  |  | 0.03212532543999999 | 0.001291045600000019
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.008121318399999999 | 1.9136 | 42440
 |  | Harsh Beautycare & Packaging | 0.02504628464000001 | 2.017599999999999 | 124139
 |  | [NAME] | 0.000248768 | 1.9136 | 1300
 | Inner- 120x90x150 (I.D) |  | 0.0410474844 |  |  | 0.03945085144 | 0.001596632960000004
 |  | Ankur Paper Agency | 0.002129556 | 1.9448 | 10950
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.004687722 | 2.028 | 23115
 |  | Harsh Beautycare & Packaging | 0.0342302064 | 2.028 | 168788
 | Inner 5 ply facial combo home |  | 0.05893230720000001 |  |  | 0.053714752 | 0.005217555200000008
 |  | Ankur Paper Agency | 0.0005905536 | 5.824 | 1014
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0203130564 | 6.396 | 31759
 |  | [NAME] | 0.03802869720000001 | 6.396 | 59457
 | Inner 50 gm Tube Mass Range |  | 0.0176669896 |  |  | 0.0171535936 | 0.0005133959999999993
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.009504352 | 2.288 | 41540
 |  | Harsh Beautycare & Packaging | 0.006788236 | 2.4752 | 27425
 |  | [NAME] | 0.0013744016 | 2.288 | 6007
 | Inner Gold & Diamond combo kit |  | 0.1038945856 |  |  | 0.0295256 | 0.0743689856
 |  | Ankur Paper Agency | 0.00050752 | 5.2 | 976
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0296348416 | 5.823999999999999 | 50884
 |  | Harsh Beautycare & Packaging | 0.002865408 | 5.824 | 4920
 |  | [NAME] | 0.070886816 | 5.823999999999998 | 121715
 | [NAME] |  | 0.02542018232 |  |  | 0.02503839 | 0.0003817923199999976
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.00530309 | 4.94 | 10735
 |  | Harsh Beautycare & Packaging | 0.01409823792 | 5.054400000000001 | 27893
 |  | [NAME] | 0.0060188544 | 4.992 | 12057
 | [NAME]/HerbalRetail Pack |  | 0.08535365279999999 |  |  | 0.08417019 | 0.001183462799999979
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.008471112 | 4.94 | 17148
 |  | Harsh Beautycare & Packaging | 0.0313170624 | 5.054400000000001 | 61960
 |  | [NAME] | 0.04556547839999999 | 4.992 | 91277
 | Inner PVC/Saloon Kit |  | 0.01719643432 |  |  | 0.01637380056 | 0.0008226337600000001
 |  | Ankur Paper Agency | 0.007247419920000001 | 7.082400000000002 | 10233
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0084394336 | 7.696000000000001 | 10966
 |  | Harsh Beautycare & Packaging | 0.0015095808 | 7.8624 | 1920
 | Inner PVC/Saloon Kit315X225X163 |  | 0.06284180864000001 |  |  | 0.05889015599999999 | 0.003951652640000018
 |  | Ankur Paper Agency | 0.005291969279999999 | 7.0824 | 7472
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0113408256 | 7.696 | 14736
 |  | Harsh Beautycare & Packaging | 0.03834661376 | 7.527504565976994 | 50942
 |  | [NAME] | 0.0078624 | 7.862399999999998 | 10000
 | New Outer Home shope facial co |  | 0.0417319552 |  |  | 0.03919755008 | 0.002534405120000006
 |  | Ankur Paper Agency | 0.0008755967999999999 | 18.2416 | 480
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.012232792 | 19.448 | 6290
 |  | [NAME] | 0.0286235664 | 19.448 | 14718
 | Outer 100ml - Tube Packing |  | 0.0273794976 |  |  | 0.0269253504 | 0.0004541472000000012
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.008346411840000002 | 22.6928 | 3678
 |  | Harsh Beautycare & Packaging | 0.01774365216 | 22.9424 | 7734
 |  | [NAME] | 0.0012894336 | 22.464 | 574
 | Outer Antitan [NAME] |  | 0.08836976199999999 |  |  | 0.08374167672 | 0.004628085279999986
 |  | Ankur Paper Agency | 0.00658996936 | 15.7768 | 4177
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.05988912384 | 16.72319999999999 | 35812
 |  | [NAME] | 0.0218906688 | 16.7232 | 13090
 | Outer for Lip Balm 4g |  | 0.02127550464 |  |  | 0.0203506992 | 0.0009248054400000025
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0046015632 | 21.996 | 2092
 |  | Harsh Beautycare & Packaging | 0.01370888064 | 23.58720000000001 | 5812
 |  | [NAME] | 0.0029650608 | 21.996 | 1348
 | outer Gold & Diamond combo kit |  | 0.07699760640000003 |  |  | 0.0692376776 | 0.007759928800000024
 |  | Ankur Paper Agency | 0.001224184 | 15.496 | 790
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0254488624 | 17.264 | 14741
 |  | [NAME] | 0.05032456000000002 | 17.264 | 29150
 | [NAME] |  | 0.0155668136 |  |  | 0.015124824 | 0.0004419896000000031
 |  | Ankur Paper Agency | 0.008729864 | 37.18 | 2348
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.00407109456 | 39.8736 | 1021
 |  | Harsh Beautycare & Packaging | 0.00014567904 | 40.46639999999999 | 36
 |  | [NAME] | 0.002620176 | 39.52 | 663
 | Outer Insta Glow Gold/HerbalRetail Pack |  | 0.06074977271999999 |  |  | 0.060382608 | 0.0003671647199999933
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.01225714464 | 39.8736 | 3074
 |  | Harsh Beautycare & Packaging | 0.02060731608 | 40.02197723829869 | 5149
 |  | [NAME] | 0.027885312 | 39.52 | 7056
 | Outer new Lipshield Export 144 |  | 0.01125391072 |  |  | 0.01049515168 | 0.000758759040000001
 |  | Ankur Paper Agency | 0.00110656 | 36.40000000000001 | 304
 |  | Harsh Beautycare & Packaging | 0.005001513920000001 | 34.9024 | 1433
 |  | [NAME] | 0.0051458368 | 40.5184 | 1270
 | Outer PVC/Premium Saloon Kit |  | 0.12513157488 |  |  | 0.11239064616 | 0.01274092871999997
 |  | Ankur Paper Agency | 0.00832496392 | 24.2216 | 3437
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.017398784 | 27.1856 | 6400
 |  | Harsh Beautycare & Packaging | 0.07426639895999998 | 27.4664 | 27039
 |  | [NAME] | 0.025141428 | 26.3952 | 9525
 | Outer100 ml Bottle 410X375X177 |  | 0.00335439312 |  |  | 0.003262896 | 9.149712000000023e-05
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0009191624 | 29.6504 | 310
 |  | Harsh Beautycare & Packaging | 0.00073919872 | 29.8064 | 248
 |  | [NAME] | 0.001696032 | 28.08 | 604
 | Outer100ml -385x200x320(I.D) |  | 0.0393615248 |  |  | 0.03562011856 | 0.003741406240000002
 |  | Ankur Paper Agency | 0.0005469359999999999 | 18.2312 | 300
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0052740064 | 20.176 | 2614
 |  | Harsh Beautycare & Packaging | 0.0335405824 | 20.176 | 16624
 | Outer-380x193x270(I.D) |  | 0.0205209576 |  |  | 0.0205209576 | 0
 |  | Gargi Coated Papers  Pvt. Ltd. | 0.0142681032 | 17.78400000000001 | 8023
 |  | Harsh Beautycare & Packaging | 0.0018975528 | 17.784 | 1067
 |  | [NAME] | 0.0043553016 | 17.784 | 2449
 | Plate Gold/Herbal Saloon Pack |  | 0.00081641664 |  |  | 0.00075950784 | 5.690879999999999e-05
 |  | Gargi Coated Papers  Pvt. Ltd. | 7.042464e-05 | 3.369600000000001 | 209
 |  | Harsh Beautycare & Packaging | 0.000569088 | 3.744 | 1520
 |  | [NAME] | 0.000176904 | 3.3696 | 525
 | PVC shrink for new Star cj |  | 0.03364728639999999 |  |  | 0.02441192 | 0.00923536639999999
 |  | Anant Overseas | 0.0049131264 | 1.3832 | 35520
 |  | Balaji Packaging Industries | 0.02805711999999999 | 1.456 | 192700
 |  | DIVINE | 0.00067704 | 1.04 | 6510
 | [NAME] |  | 0.1086384 |  |  | 0.104832 | 0.003806400000000043
 |  | Eon Plast Industries | 0.04045599999999999 | 0.2079999999999999 | 1945000
 |  | [NAME] | 0.039 | 0.208 | 1875000
 |  | [NAME] | 0.0291824 | 0.2392 | 1220000
 | Strap Roll (Printed) |  | 0.01367808 |  |  | 0.0121264 | 0.001551679999999998
 |  | Avi International PackagingCo. | 0.0082472 | 676 | 122
 |  | Balaji Packaging Industries | 0.00286 | 572 | 50
 |  | DIVINE | 0.00257088 | 642.72 | 40
 | While Color bottle 100ml |  | 0.19588030668 |  |  | 0.1914689506637112 | 0.004411356016288837
 |  | Plast Minds India | 0.016511976 | 4.055999999999999 | 40710
 |  | Weener Empire Plastics | 0.10576462 | 3.552128295549958 | 297750
 |  | Weener Empire Plastics Ltd | 0.07360371068 | 3.669800000000001 | 200566
 | white [NAME] with Silver Ring 50g |  | 0.170415024 |  |  | 0.1650379545065376 | 0.00537706949346245
 |  | Eon Plast Industries | 0.080511704 | 2.548 | 315980
 |  | Indian Extrusions | 0.0395616 | 2.560621359223301 | 154500
 |  | [NAME] | 0.05034172000000001 | 2.43785569007264 | 206500
 | White Jar 50g |  | 0.581342008 |  |  | 0.5327412194421622 | 0.04860078855783778
 |  | Eon Plast Industries | 0.206222848 | 6.655999999999997 | 309830
 |  | Indian Extrusions (Unit 2nd ) | 0.17860232 | 7.317368076040644 | 244080
 |  | [NAME] | 6.070018223938225 | 323750
 | Total Saving