Attachment 5 - Inventory Spreadhseet.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 36C24126Q0744
About this file
This is an inventory spreadsheet attachment supporting a Request for Quotation (RFQ) for annual backflow inspection and repair services at the VA Maine Healthcare System Togus Medical Center. The spreadsheet details the line items and pricing structure for a base year plus two optional years of service, with specific contingency amounts allocated for repairs and replacements.
The procurement requires vendors to provide pricing for backflow device inspection and preventive maintenance services in accordance with the Statement of Work for a base year (Item 0001), followed by optional year one services including inspection/PM (Item 1001), repair contingency of $10,000 NTE (Item 1002), and replacement contingency of $5,000 NTE (Item 1003). Optional year two includes the same service structure with items 2001-2003 containing identical contingency amounts. This is a SDVOSB set-aside solicitation under NAICS code 238220 (Plumbing, Heating, and Air-Conditioning Contractors) with a small business size standard of $19 million, utilizing FSC/PSC code J045. The VA solicitation number is 36C24126Q0744, and vendors must submit quotations addressing all line items with corresponding unit prices and total amounts for the base and optional year periods.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 5 - Inventory Spreadhseet Rev 1.xlsx | XLSX spreadsheet | |
| Attachment 3 - PG-18-10 Section 4.10.pdf | ||
| 36C24126Q0744.docx | DOCX document | |
| Attachment 4 - Spec Sheet.pdf | ||
| Attachment 1 - VA BFP Testing Forms.pdf | ||
| FAR 852.219-75-Limitation on Subcontracting.pdf | ||
| Attachment 2 - Campus Map - Togus.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
EQUIPMENT
EE # Manufacturer Equipment Name Model Serial Type of BFP tc={DB278E7A-BBEF-476E-8DFD-8E78C5735BB6}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Reduced Pressure Zone Assembly (RPZ or RPZA) Double Check Valve Assembly (DCVA or DCA) Pressure Vacuum Breaker (PVB)
| Atmospheric Vacuum Breaker (AVB) | Acquisition/ Installation Date | Room | Building | Test Date | Pass | Fail | Corrective Action | PM/Work Order Number | Notes, Date Replaced/Rebuild | Tech initials | ||||
| 11478 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTOR | 575A | W29214 | E254 | 200 | 2024-03-13 | X | Rebuild or Replaced | |||||
| 16021 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6335 | 1999-06-04 | 001 | 204 | 2024-03-13 | X | |||||
| 16022 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6319 | 1999-06-04 | 001 | 204 | 2024-03-13 | X | |||||
| 16026 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6645 | 1999-06-04 | 001 | 207 | 2024-03-13 | X | Replaced | ||||
| 16027 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6556 | 1999-06-04 | 001 | 207 | 2024-03-13 | X | Replaced | ||||
| 16028 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6324 | 1999-06-04 | 001 | 206 | 2024-03-13 | X | Replaced | ||||
| 16029 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6330 | 1999-06-04 | 001 | 206 | 2024-03-13 | X | Replaced | ||||
| 34556 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G8736 | 001 | 232 | 2024-03-13 | X | Rebuild or Replaced | |||||
| 34134 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G4891 | 2009-12-01 | 001 | 232 | 2024-03-13 | X | Rebuild or Replaced | ||||
| 16023 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6334 | 1999-06-04 | 100 | 202 | 2024-03-14 | X | Replaced | ||||
| 16024 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6645 | 1999-06-04 | 001 | 201 | 2024-03-14 | X | |||||
| 16030 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6331 | 1999-06-04 | 001 | 205 | 2024-03-14 | X | |||||
| 16031 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6548 | 1999-06-04 | 001 | 205 | 2024-03-14 | X | Replaced | ||||
| ????? | 2024-03-14 | X | Replaced | |||||||||||
| 16040 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6321 | 1999-06-04 | 001A | 248 | 2024-03-14 | X | Replaced | ||||
| 34594 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G6251 | 2010-07-01 | 001 | 202 | 2024-03-14 | X | Replaced | ||||
| 16035 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6329 | 1999-06-04 | 004 | 209 | 2024-03-15 | X | |||||
| 16036 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6333 | 1999-06-04 | 004 | 209 | 2024-03-15 | X | |||||
| 16037 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6366 | 1999-06-04 | 029 | 200 | 2024-03-15 | X | Needs to be Replaced | ||||
| 16038 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6325 | 1999-06-04 | 029 | 200 | 2024-03-15 | X | Needs to be Replaced | ||||
| 16034 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6550 | 1999-06-04 | 001 | 210 | 2024-03-17 | X | Replaced | ||||
| 11479 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTOR | 575A | W29226 | E400 | 200 | 2024-03-18 | X | ||||||
| 11480 | FEBCO SALES INC. | BACKFLOW PREVENTOR | 825Y | MM3192 | 569 | 200 | 2024-03-18 | X | ||||||
| 11481 | FEBCO SALES INC. | BACKFLOW PREVENTOR | 825Y | AM3245 | 609 | 200 | 2024-03-18 | X | Rebuild or Replaced | |||||
| 11482 | FEBCO SALES INC. | BACKFLOW PREVENTOR | 825Y | AM3232 | 650 | 200 | 2024-03-18 | X | Rebuild or Replaced | |||||
| 33958 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | F3445 | 2010-05-09 | E219 | 200 | 2024-03-18 | X | Needs to be Replaced | ||||
| 34554 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | J1579 | 2010-06-10 | E400 | 200 | 2024-03-18 | X | |||||
| 40918 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | J3930 | 2012-11-11 | 329 | 200 | 2024-03-18 | X | Rebuild or Replaced | ||||
| 40919 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | J3932 | 2012-11-11 | 332B | 200 | 2024-03-18 | X | |||||
| 40920 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | J3931 | 2012-11-11 | 332B | 200 | 2024-03-18 | X | Rebuild or Replaced | ||||
| 40923 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | J3955 | 2011-09-01 | 314 | 200 | 2024-03-18 | X | |||||
| 47667 | FLOWMATIC | BACKFLOW PREVENTER | RPZE | G5360 | 2015-06-15 | 400A | 200 | 2024-03-18 | X | |||||
| 16033 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6538 | 1999-06-04 | 001 | 210 | 2024-03-19 | X | Replaced | ||||
| 32206 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4916 | 001 | BQ69 | 2024-03-19 | X | ||||||
| 32209 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G4673 | 2009-04-09 | 001 | 203 | 2024-03-19 | X | Rebuild or Replaced | ||||
| 32210 | FLOWMATIC | BACKFLOW PREVENTOR | rpze | g4665 | 2009-04-09 | 001 | 203 | 2024-03-19 | X | Rebuild or Replaced | ||||
| 34551 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | D0255 | 2010-08-08 | 001 | 232 | 2024-03-19 | X | Rebuild or Replaced | Turned in?? 03/08/2010 | |||
| 34595 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G3946 | 2010-07-01 | 001 | 235 | 2024-03-19 | X | Rebuild or Replaced | ||||
| 34596 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G3996 | 2010-07-01 | 001 | 235 | 2024-03-19 | X | |||||
| 56446 | FLOWMATIC | BACKFLOW PREVENTER | DCVE | T9400 | 2024-03-19 | X | Rebuild or Replaced | |||||||
| 34598 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | M0531\ | 109A | 232 | 2024-03-24 | X | ||||||
| 16054 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4902 | 1999-06-04 | 001 | BQ19 | 2024-04-08 | X | |||||
| 34559 | FLOWMATIC | BACKFLOW PREVENTOR | DCVE | H6562 | 001 | BQ18 | 2024-04-08 | X | Rebuild or Replaced | |||||
| 16042 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6541 | 1999-06-04 | 001 | 240 | 2024-04-10 | X | |||||
| 16043 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4883 | 1999-06-04 | 105 | 211 | 2024-04-10 | X | Rebuild or Replaced | ||||
| 51289 | WATTS | BACKFLOW PREVENTOR | LF009QT | 56052 | 2016-08-01 | 252 | 206 | 2024-04-10 | X | |||||
| 51290 | WATTS | BACKFLOW PREVENTOR | LF009M3QT | 93638 | 2016-08-01 | 402 | 206 | 2024-04-10 | X | Rebuild or Replaced | ||||
| 51291 | WATTS | BACKFLOW PREVENTOR | LF009M3QT | 88243 | 2016-08-01 | 402 | 206 | 2024-04-10 | X | |||||
| 51292 | WATTS | BACKFLOW PREVENTOR | 2F009M3QT | 93633 | 2016-08-01 | 402 | 206 | 2024-04-10 | X | Relief did not open @ 2 PSI Min | ||||
| 51293 | WATTS | BACKFLOW PREVENTOR | LF009M3QT | 89163 | 2016-08-01 | 402 | 206 | 2024-04-10 | X | Rebuild or Replaced | ||||
| 32198 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4937 | 001 | BQ20 | 2024-04-18 | X | ||||||
| 16020 | MILES LAB/AMES LAB TEK | BACKFLOW PREVENTOR | 2000SS | 2CN1229 | 1999-06-04 | 100 | 238 | 2024-07-07 | X | |||||
| 33955 | FLOWMATIC | BACKFLOW PREVENTOR | DCVE | H6974 | 2010-04-09 | 001 | BQ32 | 2024-07-09 | X | Bad first check??? | ||||
| 14732 | FLOWMATIC | BACKFLOW PREVENTER | RPZ | B5643 | 1998-01-01 | 100 | 245 | 2025-07-07 | X | |||||
| 14733 | FLOWMATIC | BACKFLOW PREVENTER | RPZ | B5457 | 1998-01-01 | 245 | 245 | 2025-07-07 | X | Rebuild or Replaced | ||||
| 16048 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4517 | 1999-06-04 | 001 | BQ15 | 2025-07-07 | X | |||||
| 16049 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4498 | 1999-06-04 | 001 | BQ16 | 2025-07-07 | X | |||||
| 16058 | WATTS REGULATOR CO | BACKFLOW PREVENTOR | 009 | 4750 | 1999-06-04 | 100 | 238 | 2025-07-07 | X | down stream valve failed - need to Replaced and retest | ||||
| 33960 | WATTS REGULATOR CO | BACKFLOW PREVENTOR | 009 | 30927 | 2010-05-09 | 100 | 238 | 2025-07-07 | X | |||||
| 33956 | AMES CONTROL | BACKFLOW PREVENTOR | DC 200 | JC-0527 | 2010-04-09 | 001 | 210 | 2025-07-08 | x | Both checks failed | ||||
| 40917 | WATTS REGULATOR CO | BACKFLOW PREVENTER | 009M2 | 304541 | 2012-11-01 | 100 | 238 | 2025-07-08 | X | |||||
| 54548 | WILKINS DIV OF ZURN INDUSTRIES | BACKFLOW PREVENTER | 975xl2 | 4594712 | 2018-08-01 | 100 | 239 | 2025-07-08 | X | |||||
| 16044 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4918 | 1999-06-04 | 001 | BQ04A | 2025-07-09 | X | |||||
| 16045 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A929 | 1999-06-04 | 001 | BQ03A | 2025-07-09 | X | Rebuild or Replaced | Bad first check?? | |||
| 32208 | AMES CONTROL | BACKFLOW PREVENTOR | 200B DC | 26235 | 001 | BQ03A | 2025-07-09 | X | ||||||
| 57134 | WILKINS DIV OF ZURN INDUSTRIES | BACKFLOW PREVENTER | 350XL | H663113 | 2019-03-01 | 001 | 203 | 2025-07-09 | X | |||||
| 16047 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4468 | 1999-06-04 | 001 | BQ01 | 2025-07-10 | X | |||||
| 32196 | FLOWMATIC | BACKFLOW PREVENTER | RPZ II | B1255 | 2025-07-10 | X | ||||||||
| 44698 | FLOWMATIC | BACKFLOW PREVENTER | RPZE | J1634 | 2011-11-01 | 001 | 206 | 2025-07-10 | X | |||||
| 52137 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTER | 975XL2 | 3979392 | 2017-01-01 | 401 | 207 | 2025-07-10 | X | |||||
| 16046 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A1607 | 1999-06-04 | 001 | BQ02 | 2025-07-11 | X | |||||
| 16050 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | 4491 | 1999-06-04 | 000 | STATION | 2025-09-17 | X | |||||
| 749 | HERSEY PRODUCTS, INC. | BACKFLOW PREVENTER | FRP11 | 9248 | 1984-01-01 | 001 | 207 | No Longer there - Remove from list | ||||||
| 835 | WATTS REGULATOR CO | BACKFLOW PREVENTER | 909 | 120328 | 1983-01-01 | 012 | 203 | No Longer there - Remove from list | ||||||
| 4282 | NEPTUNE WATER METER | BACKFLOW PREVENTER | 575 | MCB18803 | 100 | 222 | Out of Service | |||||||
| 14729 | FLOWMATIC | BACKFLOW PREVENTER | RPZ | H2888 | 1997-01-01 | 615 | 200 | |||||||
| 14731 | WATTS REGULATOR CO | BACKFLOW PREVENTER | 009 | 57086 | 1997-01-01 | 512A | 200 | |||||||
| 16041 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B6658 | 1999-06-04 | 001 | 212 | |||||||
| 16051 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4958 | 1999-06-04 | 105A | 221 | |||||||
| 16052 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | 4924 | 1999-06-04 | 001 | BQ32 | |||||||
| 16053 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | 4934 | 1999-06-04 | 001 | BQ27 | |||||||
| 16055 | FLOWMATIC | BACKFLOW PREVENTOR | DCV | A4915 | 1999-06-04 | 001 | BQ18 | No Longer there - Replaced By EE34559 | ||||||
| 16892 | FLOWMATIC | BACKFLOW PREVENTER | RPZ | B9470 | 2000-08-16 | 001 | 206 | |||||||
| 32199 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | F8351 | 2009-04-06 | 001 | 245 | No Longer In Service | ||||||
| 32200 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | D0263 | 2009-04-09 | 100 | 249 | |||||||
| 32201 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B5833 | 001 | 200 | Unable to test - Line not in service | |||||||
| 32203 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ | B5822 | 029 | 200 | Unable to test - Line not in service | |||||||
| 32205 | FLOWMATIC | BACKFLOW PREVENTOR | RPZE | G3509 | 2009-04-09 | 100 | 245 | No Longer In Service | ||||||
| 32207 | WATTS REGULATOR CO | BACKFLOW PREVENTOR | 007M2QT DC | 49782 | 131 | 209 | ||||||||
| 33957 | AMES CONTROL | BACKFLOW PREVENTOR | DC 200 | ID-1395 | 2010-04-09 | 116 | linco | |||||||
| 33961 | WATTS REGULATOR CO | BACKFLOW PREVENTOR | 009 | 31047 | 2010-04-09 | 100 | 238 | Could not test due to port issues | ||||||
| 34553 | FLOWMATIC | BACKFLOW PREVENTOR | RPZ 3/4 | J1584 | 2008-06-01 | 100 | 222 | No Longer In Service | ||||||
| 34555 | AMES COLT | BACKFLOW PREVENTOR | DC | JJ0422 | 2009-12-01 | 001 | BQ01 | |||||||
| 40915 | WATTS REGULATOR CO | BACKFLOW PREVENTER | 009M3 | 338926 | 2012-11-01 | 100 | 239 | Remove from list no longer there | ||||||
| 40916 | WATTS REGULATOR CO | BACKFLOW PREVENTER | 0093M | 360355 | 2012-11-01 | 100 | 239 | Remove from list no longer there | ||||||
| 40921 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | G9831 | 2009-06-01 | 200 | 232 | |||||||
| 40922 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | G9829 | 2009-06-01 | 200 | 232 | |||||||
| 40924 | FLOWMATIC | BACKFLOW PREVENTER | RPZII | J3927 | 2012-09-01 | 305A | 200 | Could not be tested - No water supply | ||||||
| 49430 | WILKINS DIV OF ZURN INDUSTRIES | BACKFLOW PREVENTER | 975XL2 | 4226753 | 2016-08-04 | E142 | 200 | |||||||
| 51576 | WATTS | BACKFLOW PREVENTER | LF909 | 19388 | Roof | 200 | ||||||||
| 51638 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTER | 975XL2 | 4334410 | 2017-08-01 | 620A | 200 | |||||||
| 54598 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTER | 975XL2 | 4594537 | 2018-09-01 | 100 | 239 | Could not test - Locked Out | ||||||
| 58260 | WILKINS DIV OF ZURN INDUSTRIES INC | BACKFLOW PREVENTOR | 950XLT | 4274062 | 2019-10-01 | 111 | 300 | |||||||
| 58261 | WATTS | BACKFLOW PREVENTOR RPZ | LF009M2QT | 124683 | 2019-10-01 | 111 | 300 | |||||||
| 58262 | FEBCO SALES INC. | BACKFLOW PREVENTOR | 825Y | 44131 | 2019-10-01 | 111 | 300 |
Reduced Pressure Zone Assembly (RPZ or RPZA) Double Check Valve Assembly (DCVA or DCA) Pressure Vacuum Breaker (PVB) Atmospheric Vacuum Breaker (AVB)
File details come from the government source that posted it. Updated .