ATTACHMENT G - Room Contents Acq Plan Template 9.21.2023.xlsx

This is an Acquisition Plan template in Microsoft Excel format designed to track and document room contents and equipment acquisitions for federal building projects. The template serves as a comprehensive acquisition planning tool that contractors utilize to enter data directly into a SharePoint system for centralized management.

The template requires contractors to input detailed information across multiple acquisition phases and categories. Key data fields include: Department Functional Area, Room Codes, Room Numbers, Room Names, Quantity per Room, New versus Re-use designation, Acquisition Code (MF, MSC, MS, VV, VC), special MEP requirements, cost per item, and total costs. The template tracks critical acquisition timelines including Projected Need by Date (typically the building acceptance date for VV items, or contractor schedule for VC items), Contracting Lead Time in days based on PALT vendor lead time, and Projected Order by Date. Additional columns capture funding appropriation information, equipment designation (yes/no), and assignment of responsibility to specific personnel for SEPG (presumably Systems Engineering Planning Group) and EER (presumably Equipment Evaluation Review) submissions with associated tracking numbers. The template includes a complete acquisition workflow section documenting market research completion, quotes from multiple vendors, IFCAP transaction details, acquisition method selection (defaulting to Full and Open Market), PO numbers, obligated amounts, award completion status, delivery status, storage location, installation completion, and comments. All rows are pre-populated with default values (quantity 0, date 12/31/99, Non-Recurring classification, Equipment Yes/No designation, and Full and Open Market acquisition method), indicating this is a blank template ready for project-specific data entry.