Attachment D- Summary Report.xlsx
XLSX spreadsheet 106 KB Posted
- Solicitation number
- 36C26025Q0039
About this file
This document is an attachment, Attachment D - Summary Report, related to a federal contract opportunity for an Annual Wall-to-Wall Inventory at multiple locations within the Department of Veterans Affairs' Veterans Integrated Service Network (VISN) 20 in the Pacific Northwest region.
The attachment provides details on the inventory conducted by a third-party contractor, including the total equipment data from the AEMS/MERS system, equipment that was in-scope for the inventory, equipment that was reconciled and scanned, and equipment that was not found. It also includes data on the contractor-applied labels, missing door tags, and a breakdown of the inventory completion percentage. The related federal contract opportunity is a Blanket Purchase Agreement for the annual wall-to-wall inventory, with a base year from 11/21/2024 to 11/20/2025 and up to 5 option years. The solicitation is set aside 100% for Service-Disabled Veteran Owned Small Businesses, and responses are due by 1PM EST on 11/07/2024.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Number 27 W2W VENDOR AUDIT FILE - Redacted.xlsx | XLSX spreadsheet | |
| 36C26025Q0039_3.docx | DOCX document | |
| 36C26025Q0039 0002.pdf | ||
| Attachment F Price Cost Schedule.xlsx | XLSX spreadsheet | |
| Number 26 DATA FILE TO VENDOR.xlsx | XLSX spreadsheet | |
| Number 27 W2W VENDOR AUDIT FILE.xlsx | XLSX spreadsheet | |
| 36C26025Q0039_2.docx | DOCX document | |
| 36C26025Q0039 0001.pdf | ||
| Attachment C- Equipment NOT in Scope.xlsx | XLSX spreadsheet | |
| Attachment B- Equipment IN Scope.xlsx | XLSX spreadsheet | |
| Attachment A - VISN 20 Network Facilities.pdf | ||
| Solicitation 36C26025Q0039.pdf | ||
| 36C26025Q0039_1.docx | DOCX document |
Show all 13
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
Summary Report
EE TAGS IN-USE
This is the file that will upload into AEMS/MERS Any comment with "Regenerate barcode" requires a new VA barcode for the piece of equipment
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
EE TAGS NOT IN-USE
This file requires follow-up. EE entries were not "IN-USE" when SSI received the data file.
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
NEW SSI TAGS
This file contains all SSI tags scanned with captured data.
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
OLD SSI TAGS
This file contains all Old SSI tags scanned with captured data. SSI will charge at the rate of scanning "EE Tags" for these items.
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
NOT IN DATABASE
This file contains all items found that were not in the database that was provided prior to the start of the project. These items are not billed to the VA.
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
SCANNED BY VA
This file contains all items found that were scanned/or information was provided by VA personnel. These items are not billed to the VA.
Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
EIL Breakdown
| Percentage of items found by EIL | |||
| EIL | Total Found | Total Assigned to EIL | % Found |
| EIL Percent Complete |
| 0-69% |
| 70% to 79% |
| 80% to 89% |
| 90% to 100% |
Room Comments
| These rooms need new barcodes generated | |
| Door Barcodes | Comments |
Audit Data Auditor Audit Date Site Location Barcode Serial_No Description Manufacturer Model_No Inuse Status Match_Type Comments
Microsoft_Word_Document.docx VAMC Facility Equipment Inventory Initiative
Attachment D
Wall-to-Wall inventory conducted by a third-party contractor that specializes in equipment management.
VAMC Facility Name
Inventory Start Date
Inventory End Date
Number of Days Start to Finish
Number of Contracted Personnel Performing Inventory
Number of Inventory Teams
Number of VA Personnel accompanying Contractor Inventory Teams
AEMS/MERS EQUIPMENT DATA
AEMS/MERS Electronic Download Totals - AEMS/MERS Electronic Equipment Data (pre-inventory). This number includes all of the records in AEMS/MERS regardless of the use status.
Equipment NOT IN SCOPE - equipment with a use status of Lost or Storeroom or Turned-In in the AEMS/MERS electronic Equipment Data (pre-inventory).
Total Equipment IN SCOPE- equipment "In Use”, “Loaned”, or “Out of Service” in the AEMS/MERS electronic Equipment Data (pre-inventory). (Includes items without EIL, equipment at locations not inventoried, BSE and expendable equipment) (Pre-Inventory)
Required Inventory of IN SCOPE ITEMS- Equipment with “In Use”, “Loaned”, or “Out of Service” status, requiring inventory (items with EIL, In Use, Loaned, or Out of service, non-expendable)
Reconciled equipment - equipment scanned. Equipment had an "In Use", “Loaned”, or “Out of Service” status in the AEMS/MERS electronic Equipment Data (pre-inventory). Scanned “in scope” items, by both SSI and VA personnel
Required: Not Reconciled equipment- Equipment with “In Use”, “Loaned”, or “Out of Service” not found Requiring inventory
Scanned Inventory Data
SSI Scanned Inventory Download Totals - equipment scanned during the physical inventory. (includes all items except SSI Tags)
Scanned equipment Not in Scope - equipment physically scanned that had a use status of Lost or Storeroom or Turned In, in AEMS/MERS (pre-inventory)
Reconciled Scanned equipment that had a use status of "In Use" in AEMS/MERS (pre-inventory). (includes items without EIL and BSE)
Scanned By VA during inventory (not charged)
Not in database (not charged)
Contractor Applied Labels - equipment missing VA Barcode Labels or VA Barcode Labels that would not scan or VA Barcode Labels that were illegible. (New SSI Tags)
Contractor Applied Labels-Old SSI tags (rate charged is same as EE tags)
Door Tags Missing- Door barcodes were missing or unreadable image1.emf
File details come from the government source that posted it. Updated .