Spreadsheet: 182465d1348496393-vlookup-problem-category-summaries
Sheet: Overview

3rd Party Spend by Commodity
PLASTIC |  |  |  |  | PACKAGING |  |  |  |  | METALS |  |  |  |  | OTHER
Spend Total: |  | $ |  |  | Spend Total: |  | $ |  |  | Spend Total: |  | $15,438,907 |  |  | Spend Total: |  | $
# of parts Total: |  |  |  |  | # of parts Total: |  |  |  |  | # of parts Total: |  | 201 |  |  | # of parts Total:
Top 5 Suppliers by Spend: |  |  |  |  | Top 5 Suppliers by Spend: |  |  |  |  | Top 5 Suppliers by Spend: |  |  |  |  | Top 5 Suppliers by Spend:
Name: | Strategic: | Location | Spend: |  | Name: | Strategic: | Location | Spend: |  | Name: | Strategic: | Location | Spend: |  | Name: | Strategic: | Location | Spend:
 |  |  |  |  | CHESAPEAKE | Strategic: | Ireland |  |  | FORT WAYNE METALS IRELAND LTD | Strategic | Ireland | 4330931.625645424
 |  |  |  |  | PERFECSEAL LIMITED | Strategic: | Ireland |  |  | CREGANNA - TACTX MEDICAL | Strategic | Ireland | 3786110.185000001
 |  |  |  |  | MEADWESTVACO HEALTHCARE PACKAG | Strategic: | Ireland |  |  | ACCELLENT CARDIOLOGY GALWAY | Strategic | Ireland | 3480026.613921001
 |  |  |  |  | AMCOR FLEXIBLES SLIGO LIMITED | Strategic: | Ireland |  |  | ACCELLENT CARDIOLOGY/SALEM | Strategic | USA | 1827557.462731
 |  |  |  |  | YORK TAPE & LABEL LLC | Strategic: | USA |  |  | CARAGH PRECISION | Site Managed | Ireland | 520053.2766
Top 10 parts by Spend: |  |  |  |  | Top 10 parts by Spend: |  |  |  |  | Top 10 parts by Spend: |  |  |  |  | Top 10 parts by Spend:
Part # | Description | Annual Qty | Unit Cost |  | Part # | Description | Annual Qty | Unit Cost |  | Part # | Description | Annual Qty | Unit Cost |  | Part # | Description | Annual Qty | Unit Cost
 |  |  |  |  |  |  |  |  |  | 90149907-03 | .0070" Composite [NAME] | 540000 | 4.394189799999999
 |  |  |  |  |  |  |  |  |  | 90044246-04 | Hypotube 2.0F | 1000000 | 1.3585
 |  |  |  |  |  |  |  |  |  | 90149907-02 | .0072" Composite [NAME] | 291875.16 | 4.6365319
 |  |  |  |  |  |  |  |  |  | 90087920-01 | WIRE, GROUND | 1390000 | 0.7707700000000001
 |  |  |  |  |  |  |  |  |  | 308177-01 | VIVA PTFE COATED HYPOTUBE | 350000 | 2.002
 |  |  |  |  |  |  |  |  |  | 90658464-04 | OFFROAD MICRO-CATHETER LANCET | 2510 | 199.6995
 |  |  |  |  |  |  |  |  |  | 90149907-01 | .0060" Composite [NAME] | 137961.256 | 3.2150118
 |  |  |  |  |  |  |  |  |  | 90048793-01 | Stiffening Mandrel | 61020 | 6.1204
 |  |  |  |  |  |  |  |  |  | 90044246-03 | Hypotube 1.8F | 260000 | 1.3585
 |  |  |  |  |  |  |  |  |  | 90240108-01 | BAND, MARKER, PLATINUM | 2080600 | 0.1674673
Top 5 Sub-Commodities by Spend: |  |  |  |  | Top 5 Sub-Commodities by Spend: |  |  |  |  | Top 5 Sub-Commodities by Spend: |  |  |  |  | Top 5 Sub-Commodities by Spend:
Family Name | # of Parts | # of Suppliers | Total Spend |  | Family Name | # of Parts | # of Suppliers | Total Spend |  | Family Name | # of Parts | # of Suppliers | Total Spend |  | Family Name | # of Parts | # of Suppliers | Total Spend
 |  |  |  |  |  |  |  |  |  | Wire | 34 | 8 | 6011907.398246135
 |  |  |  |  |  |  |  |  |  | Tubing | 16 | 3 | 3101428
 |  |  |  |  |  |  |  |  |  | Markerbands | 36 | 2 | 1884543.379894524
 |  |  |  |  |  |  |  |  |  | Coated mandrels | 37 | 7 | 980758.5072109523
 |  |  |  |  |  |  |  |  |  | Remainder | 78 | Multiple | 3460270