ATTACHMENT G - Room Contents Acq Plan Template 9.21.2023.xlsx

This file is an Acquisition Plan template attachment for room contents procurement related to the Martinsburg, WV Warehouse IOTA project. The spreadsheet template is designed for contractors to enter required data directly into a SharePoint system and serves as a planning document for acquiring furniture and equipment for designated building spaces. Key data fields include room identification information (functional area, room code, room numbers, room names, and quantity of rooms), item specifications (JSN item number, quantity per room, total quantity, and new versus reused status), acquisition codes, MEP requirements, cost details (cost per item and total cost), and projected need-by dates based on building acceptance timelines for Vendor-Verified (VV) items or contractor schedules for Vendor-Coordinated (VC) items. Additional required fields track contracting lead times in days based on PALT vendor lead times, projected order-by dates, funding appropriation sources, recurring versus non-recurring classifications, equipment designation status, and subject matter expert (SME) submission requirements. The template also captures procurement process information including market research completion, Federal Certification of Procurement (FCP) form submission, IFCAP transaction numbers and committed amounts, FORCE system entry, acquisition methods, purchase order numbers, obligated amounts, award and delivery status, storage location assignments, installation schedules, and completion dates. All cost-related and date-related fields for VV and VC items are mandatory, with acquisition method defaulting to "Full and Open Market" competition. This template standardizes data collection for comprehensive furniture and equipment acquisition planning throughout the building outfitting process.