Spreadsheet: 49361d1248713993-easy-data-filtering-but-i-can-not-figure-it-out-sample-inv1
Sheet: Sheet1

AUDIO ACCESSORIES INC.  INVENTORY, AS OF July 24, 2009 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-23 00:00:00 |  | Qty. In |  | Part Number | Description | Location | Manufacturer | Manufacturer P/N | Supplier #1 | Cost #1 | Supplier #2 | Cost  #2 | Qty. In | Update | Last Count | Reorder | Total | Quantity On
Part Number | Description | Location | Manufacturer | Manufacturer P/N | Supplier #1 | Cost #1 | Supplier #2 | Cost  #2 | Qty. In | Update | Last Count | Reorder | Total | Quantity On |  | 0
WW-000-10 | 3x26 Terminal Block | IN-88 | TRIMM | /[PHONE] | TRIMM | 58.93 |  |  | 4 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 4 | 235.72
WW-000-11 | 6x26 Terminal Block | IN-88 | TRIMM | 4270032006 | TRIMM | 89.64 |  |  | 1 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 89.64 | Quote $70.07 2 weeks
WW-004-A | ADC Insertion Tool | FINAL | ADC | QB-2 | ADC | 61.62 |  |  | 0 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 3 | 0
UP3 | ADC UP3 QCP Backplate | IN-42 | ADC | /UP3 MK II | ADC | 183.87 |  |  | 11 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 11 | 2022.57
UP3C | ADC UP3C QCP Backplate | IN-43 | ADC | /UP3C MKII | ADC | 178.73 |  |  | 16 | 2009-07-13 00:00:00 | 2009-06-24 00:00:00 | 15 | 2859.68 | 5, 7/3 NB
UP3N | ADC UP3N QCP Backplate | IN-42/69 | ADC | /UP3N MKII | ADC | 186.85 |  |  | 17 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 15 | 3176.45
UP3NC | ADC UP3NC QCP Backplate | IN-45 | ADC | /UP3NC MKII | ADC | 189.28 |  |  | 15 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 15 | 2839.2
UP96 | ADC UP-96 QCP Backplate | IN-44/46 | ADC | /UP96 MKII | ADC | 243.63 |  |  | 11 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 10 | 2679.93
UP96C | ADC UP-96C QCP Backplate | IN-45 | ADC | /UP96C MKII | ADC | 248.77 |  |  | 11 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 10 | 2736.47
UP96N | ADC UP-96N QCP Backplate | IN-44/70 | ADC | /UP96N MKII | ADC | 323.13 |  |  | 12 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 8 | 3877.56
UP96NC | ADC UP-96NC QCP Backplate | IN-46 | ADC | /UP96NC MKII | ADC | 334.98 |  |  | 12 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 5 | 4019.76
UP-52 | ADC UP-52 QCP Backplate | IN-43 | ADC | /UP52 MKII | ADC | 186.85 |  |  | 13 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 5 | 2429.05
UP-52C | ADC UP-52C QCP Backplate | IN-43 | ADC | /UP52C MKII | ADC | 192.52 |  |  | 10 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 10 | 1925.2
UP-52N | ADC UP-52N QCP Backplate | IN-43 | ADC | /UP52N MKII | ADC | 209.56 |  |  | 9 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 5 | 1886.04
UP-52NC | ADC UP-52NC QCP Backplate | IN-45 | ADC | /UP52NC MKII | ADC | 215.24 |  |  | 14 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 10 | 3013.36
UP-64 | ADC UP-64 QCP Backplate | IN-44 | ADC | /UP64 MKII | ADC | 192.52 |  |  | 14 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 6 | 2695.28
UP-64C | ADC UP-64C QCP Backplate | IN-45 | ADC | /UP64C MKII | ADC | 197.93 |  |  | 25 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 10 | 4948.25
UP-104 | ADC UP-104 QCP Backplate | IN-44 | ADC | /UP104 MKII | ADC | 254.99 |  |  | 10 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 2549.9
UP-104N | ADC UP-104N QCP Backplate | IN-43 | ADC | /UP104N MKII | ADC | 325 |  |  | 1 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 325
UP3SNC | ADC UP3-SNC QCP Backplate | IN-45 | ADC | /UP3SNC MKII | ADC | 218.4 |  |  | 6 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 3 | 1310.4
UP52NSNC | ADC UP-52NSNC QCP Backplate | IN-45 | ADC | /UP52NSNC MKII | ADC | 247.52 |  |  | 2 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 495.04
I-96 | ADC I-96 Backplate | IN-45 | ADC |  | ADC | 164.71 |  |  | 0 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 0
I-48 | ADC I-48 Backplate |  | ADC |  | ADC | 142.68 |  |  | 0 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 0
I-FD | ADC IFD Backplate |  | ADC |  | ADC | 59.12 |  |  | 0 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 0
DCQCPRAM | QCP LONG DUST COVER RAMTRONIX | IN-61 | RESH | DCQCPRAM | 50, $9.75 | 9.75 |  |  | 55 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | By [NAME] | 536.25
AQCPTRAY | AUDIO QCP TRAY | L-4 | RESH / Gauthier | /AQCPTRAY | 100, $29.99 / 50 $32.45 | 32.45 |  |  | 70 | 2009-07-07 00:00:00 | 2009-06-24 00:00:00 | 25 | 2271.5 | 50, 7/6 NB
AQCPDC | AUDIO QCP DUST COVER | IN-61 | RESH / Gauthier | /AQCPDC | 100, $11.14 / 50 $11.9 | 11.99 |  |  | 60 | 2009-06-24 00:00:00 | 2009-06-24 00:00:00 | 25 | 719.4