ATTACHMENT G - Room Contents Acq Plan Template 9.21.2023.xlsx

This file is an Acquisition Plan template in Excel format designed to document room contents and related procurement information for a federal construction or renovation project. The template serves as a planning tool for contractors to enter data directly into a SharePoint system and tracks the acquisition lifecycle for items assigned to specific rooms within a facility.

The template requires contractors to document comprehensive procurement details for each item, including: department, functional area, room codes and numbers, room names, quantity per room and total quantity, new versus reuse designation, acquisition code (MF, MSC, MS, VV, or VC), special MEP (mechanical, electrical, plumbing) requirements, and cost information. The template also tracks critical project timelines such as projected need-by dates, contracting lead times in days, projected order dates, and installation schedules. For equipment items, the form requires identification of subject matter experts (SME) and documentation of approval processes through SEPG (Systems Engineering Planning Group) and EER (Engineering Evaluation Record) gates, with corresponding submission dates and reference numbers. Additional procurement tracking fields include market research completion status, three vendor quotes with pricing, acquisition method selection (defaulting to Full and Open Market), Purchase Order (PO) numbers, IFCAP transaction and commitment amounts, FORCE system entry, Acquisition Plan reference numbers, obligation amounts, award completion status, delivery status, storage location, installation completion status, and general comments. The template defaults to non-recurring items and includes calculated fields for total costs and projected order dates based on vendor lead times and contracting timelines.