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

Saving On 300 Cr Business Volume |  |  |  |  |  |  |  |  |  |  |  |  |  | Saving On 500 Cr Business Volume
Group | Catgeory | [NAME] | Total no. of SKUs being procured | Business value FY16 (INR Lacs) | New Vendor/ Existing Vendor | EBITDA impact (INR Lacs) |  | Remarks | Closed date | Remarks |  | Group | Catgeory | [NAME] | Total no. of SKUs being procured | Business value FY16 (INR Lacs) | New Vendor/ Existing Vendor | EBITDA impact (INR Lacs) |  | Remarks | Closed date | Remarks | Vendor Consolidation | Volume discount
Raw Material | Negotiation On Existing RM | Continental Chemicals | 1 | 15 | Continental Chemicals | 0.25 |  | Negotiation | Before 18th july |  |  | Raw Material | Negotiation On Existing RM | Continental Chemicals | 1 | 15 | Continental Chemicals | 0.39 |  | Negotiation | Before 25th july
 |  | RP Global Ventures | 2 | 28 | RP Global Ventures | 0.3 |  | Negotiation | Before 18th july |  |  |  |  | RP Global Ventures | 2 | 28 | RP Global Ventures | 0.55 |  | Negotiation | Before 25th july
 |  | RP Global Ventures |  |  | Atishey Speciality | 1.8 |  | Make is same | Before 18th july |  |  |  |  | RP Global Ventures |  |  | Atishey Speciality | 5.8 |  | Negotiation | Before 25th july
 |  | Katyani Exports | 60 | 100 | Parmanand Prem Prakash & Co. | 2.35 |  | Make is same only one item is shifting | Before 18th july |  |  |  |  | Katyani Exports | 60 | 100 | Parmanand Prem Prakash & Co. | 4.5 |  | Negotiation | Before 25th july
 |  | MARS HEALTHCARE PVT LTD | 8 | 16 | Connell Bros. Company (India) | 1.22 |  | Make is same | Before 18th july |  |  |  |  | MARS HEALTHCARE PVT LTD | 8 | 16 | Connell Bros. Company (India) | 2.2 |  | Negotiation | Before 25th july
 |  | [NAME] | 4 | 25 | Pankaj Chemical Company | 1 |  | Make is same - Only one item to be shift on new vendor | Before 18th july |  |  |  |  | [NAME] | 4 | 25 | Pankaj Chemical Company | 1.77 |  | Negotiation | Before 25th july
 |  | Gangwal Chemicals Private Ltd. | 2 | 36 | Gangwal Chemicals Private Ltd. | 0.95 |  | Negotiation | Before 18th july |  |  |  |  | Gangwal Chemicals Private Ltd. | 2 | 36 | Gangwal Chemicals Private Ltd. | 1.71 |  | Negotiation | Before 25th july
 |  | J.B.Fragrances & Flavours | 17 | 25 | J.B.Fragrances & Flavours | 0.31 |  | Negotiation | Before 18th july |  |  |  |  | J.B.Fragrances & Flavours | 17 | 25 | J.B.Fragrances & Flavours | 0.56 |  | Negotiation | Before 25th july
 |  | Pioma Chemicals | 1 | 6 | Pioma Chemicals | 0.09 |  | Negotiation | Before 18th july |  |  |  |  | Pioma Chemicals | 1 | 6 | Pioma Chemicals | 0.16 |  | Negotiation | Before 25th july
 |  | DKSH India Private Limited | 6 | 100 | [NAME] | 0.78 |  | Make is same only two item is being shift | Before 18th july |  |  |  |  | DKSH India Private Limited | 6 | 100 | [NAME] | 1.41 |  | Negotiation | Before 25th july
 |  | [NAME] | 10 | 70 | [NAME] | 6 |  |  |  |  |  |  |  | Brentage Ingredients | 10 | 70 | Brentage Ingredients | 8
 |  | Total |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  | Total
 | Consolidation at Local Haridwar and Delhi vendor | Orga Chemie Agencies | 3 | 15 | RP Global Ventures | 0.5 |  | Need R&D support to do alternate against Orga item |  |  |  |  | Consolidation at Local Haridwar and Delhi vendor | Orga Chemie Agencies | 3 | 15 | RP Global Ventures | 0.63 |  | Need R&D support to do alternate against Orga item
 |  | VMA Enterprises | 5 | 25 | VMA Enterprises | 0.25 |  | Need R&D support to do alternate against VMA item |  |  |  |  |  | VMA Enterprises | 5 | 25 | VMA Enterprises | 0.37 |  | Need R&D support to do alternate against VMA item
 |  | Vikas Chemicals Agencies | 3 | 17 | RP Global Ventures | 0.22 |  | make same | Before 18th july |  |  |  |  | Vikas Chemicals Agencies | 3 | 17 | RP Global Ventures | 0.22 |  | make same
 |  | SATGURU PHARMA CHEM | 1 | 2 |  |  |  | make same | Before 18th july |  |  |  |  | SATGURU PHARMA CHEM | 1 | 2 |  |  |  | make same
 |  | RP Global Ventures | 7 | 30 |  |  |  | make same | Before 18th july |  |  |  |  | RP Global Ventures | 7 | 30 |  |  |  | make same
 |  | MARS HEALTHCARE PVT LTD | 1 | 16 | [NAME] | 0.2 |  | make same | Before 18th july |  |  |  |  | MARS HEALTHCARE PVT LTD | 1 | 16 | [NAME] | 4.02 |  | make same
 |  | [NAME] | 4 | 2 | [NAME] |  |  | make same | Before 18th july |  |  |  |  | [NAME] | 4 | 2 | [NAME] |  |  | make same
 | Perfume Vendor Consolidation | 11 Vendor | 12 | 20 | JB Frangrance | 2 |  |  |  |  |  |  | Perfume Vendor Consolidation | 11 Vendor | 12 | 20 | J.B.Fragrances & Flavours | 4
 |  | Total |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  | Total
Packing Material | MonoCartoon | B.P. Lipeds | 48 | 144 | B.P. Lipeds / Decorpack |  |  | 50% business to be shift to decorpack; stop procurement from B.P.Lipeds after 3 months | Before 25th July | vendor reduce from 6 to 4 |  | Packing Material | MonoCartoon | B.P. Lipeds | 48 | 144 | B.P. Lipeds / Decorpack |  |  | 50% business to be shift to decorpack; stop procurement from B.P.Lipeds after 3 months | Before 25th July | vendor reduce from 6 to 4
 |  | Creative Graphix | 46 | 57 | Decorpack India Pvt Ltd |  |  |  | Before 25th July |  |  |  |  | Creative Graphix | 46 | 57 | Decorpack India Pvt Ltd |  |  |  | Before 25th July
 |  | Nutech Packaging | 16 | 53 | Decorpack India Pvt Ltd |  |  |  | Before 25th July |  |  |  |  | Nutech Packaging | 16 | 53 | Decorpack India Pvt Ltd |  |  |  | Before 25th July
 |  | Parksons Packaging Ltd. | 21 | 72 | Parksons Packaging Ltd. |  |  |  | Before 25th July |  |  |  |  | Parksons Packaging Ltd. | 21 | 72 | Parksons Packaging Ltd. |  |  |  | Before 25th July
 |  | Temple Packaging Pvt Ltd | 25 | 225 | Temple Packaging Pvt Ltd | 15 |  |  | Before 25th July |  |  |  |  | Temple Packaging Pvt Ltd | 25 | 225 | Temple Packaging Pvt Ltd | 15 |  |  | Before 25th July
 |  | Edelmann Packaging India Pvt. | 4 | 27 | Temple Packaging Pvt Ltd |  |  |  | Before 25th July |  |  |  |  | Edelmann Packaging India Pvt. | 4 | 27 | Temple Packaging Pvt Ltd |  |  |  | Before 25th July
 |  | Total |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  | Total
 | Tube | APT Packaging Ltd | 55 | 373 | APT Packaging Ltd | 35 |  |  | Before 25th July | Vendors to be reduced from 6 to 3 |  |  | Tube | APT Packaging Ltd | 55 | 373 | APT Packaging Ltd | 74.47 |  |  | Before 25th July | Vendors to be reduced from 6 to 3
 |  | Prabhat Rotopack (P) Ltd | 21 | 12 | APT Packaging Ltd |  |  |  | Before 25th July |  |  |  |  | Prabhat Rotopack (P) Ltd | 21 | 12 | APT Packaging Ltd |  |  |  | Before 25th July
 |  | Creative Stylo Packs Pvt. Ltd. | 74 | 359 | Creative Stylo Packs Pvt. Ltd. | 30 |  |  | Before 25th July |  |  |  |  | Creative Stylo Packs Pvt. Ltd. | 74 | 359 | Creative Stylo Packs Pvt. Ltd. | 17 |  |  | Before 25th July
 |  | 3D Technopack Ltd | 4 | 40 | Creative Stylo Packs Pvt. Ltd. |  |  |  | Before 25th July |  |  |  |  | 3D Technopack Ltd | 4 | 40 | Creative Stylo Packs Pvt. Ltd. |  |  |  | Before 25th July
 |  | Essel Propack Limited | 13 | 159 | Creative Stylo Packs Pvt. Ltd. |  |  |  | Before 25th July |  |  |  |  | Essel Propack Limited | 13 | 159 | Creative Stylo Packs Pvt. Ltd. |  |  |  | Before 25th July
 |  | Printo Tech Global Ltd | 21 | 5 | Printo Tech Global Ltd | 0 |  |  | Before 25th July |  |  |  |  | Printo Tech Global Ltd | 21 | 5 | Printo Tech Global Ltd | 0 |  |  | Before 25th July
 |  | Total |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  | Total
 | CFB | Ankur Paper Agency | 184 | 12 | Ankur Paper Agency | 15 |  |  | Closed | Vendors to be reduced from 4 to 3 |  |  | CFB | Ankur Paper Agency | 184 | 12 | Ankur Paper Agency | 25 |  |  | Closed | Vendors to be reduced from 4 to 3
 |  | Harsh Beautycare & Packaging |  | 63 | Ankur Paper Agency |  |  |  | Closed |  |  |  |  | Harsh Beautycare & Packaging |  | 63 | Ankur Paper Agency |  |  |  | Closed
 |  | Gargi Coated Papers  Pvt. Ltd. |  | 72 | Gargi Coated Papers  Pvt. Ltd. | 6.5 |  |  | Closed |  |  |  |  | Gargi Coated Papers  Pvt. Ltd. |  | 72 | Gargi Coated Papers  Pvt. Ltd. | 11 |  |  | Closed
 |  | [NAME] |  | 73 | Gargi Coated Papers  Pvt. Ltd. | 6.5 |  |  | Closed |  |  |  |  | [NAME] |  | 73 |  | 11 |  |  | Closed
 |  | Total |  |  | Total |  |  |  |  |  |  |  | Total |  |  |  | Total
 | Jar ,bottle and [NAME] | Bhim Engineering Works | 2 | 1 | [NAME] /Eon packaging |  |  |  | Before 25th July |  |  |  | Single Facial Kit M/c with Pinch off tube | Temple Packaging Pvt Ltd | 7 |  | Temple Packaging Pvt Ltd | 32 |  |  | Before 25th July
 |  | [NAME] | 11 | 100 | [NAME] /Eon packaging | 25 |  |  | Before 25th July |  |  |  |  | Creative Stylo Packs Pvt. Ltd. | 1 |  | Creative Stylo Packs Pvt. Ltd. | 15 |  |  | Before 25th July
 |  | [NAME] | 3 |  | Poonam Packaging | 6 |  |  | Before 25th July |  |  |  |  |  |  |  | Total |  |  |  | Before 25th July
 |  | Vishwakarma Industries | 1 | 3.9 | Acme Plast shape | 0.5 |  |  | Before 25th July |  |  |  | Jar ,bottle and [NAME] | Bhim Engineering Works | 2 | 1 | [NAME] packaging (sister concern of Eon Plast) |  |  |  | Before 25th July
 |  | Vishwakarma Industries | 2 |  | Eon Plast | 0.5 |  |  | Before 25th July |  |  |  |  | [NAME] | 11 | 100 | [NAME] packaging (sister concern of Eon Plast) | 29 |  |  | Before 25th July
 |  | Total |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 3 |  | Poonam Packaging | 9
 | Shrink | Indian Plastics | 5 | 0.5 | Divine | 0 |  |  | Before 25th July |  |  |  |  | Vishwakarma Industries | 2 | 3.9 | Eon Plast | 0.5 |  |  | Before 25th July
 |  | Total |  |  | Total
 | Grand total |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Shrink | Indian Plastics | 5 | 0.5 | Divine | 0
 |  |  |  | Total Saving in RM and PM (annual) |  |  |  |  |  |  |  |  |  | Total |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand total