ATTACHMENT G - Room Contents Acq Plan Template 9.21.2023.xlsx

This is an Acquisition Plan template attachment document designed to organize and track room contents acquisition data for a federal facility project. The spreadsheet serves as a centralized planning tool where contractors must enter detailed information about items required for specific rooms, with actual data entry to be completed in a SharePoint system rather than the Excel file itself.

The template requires contractors to document comprehensive acquisition details including: room identification (functional area, room codes, room numbers, room names, and quantity of rooms); item specifications (JSN item numbers, quantities per room, total quantities, and new versus re-use designations); acquisition methodology (acquisition codes and special MEP requirements); cost information (cost per item and total costs); projected timelines (need-by dates, contracting lead times in days, and projected order dates); funding and classification (appropriation, non-recurring versus recurring designation, and equipment designation); approval workflows (SEPG and EER submission requirements with associated dates and reference numbers); vendor quotes (three quote options with associated costs and vendor names); market research documentation; and procurement execution tracking (FCP person responsible, IFCAP transaction numbers, FORCE entry assignments, PO information, obligation amounts, award status, delivery status, storage locations, installation dates, and completion tracking). All VV (Verse in Verification) and VC (Verse in Conduct) items require associated costs and projected need dates, with VV items typically tied to building acceptance dates and VC items based on contractor schedules. The template includes calculated fields for total costs and order dates based on lead times, with dropdown menus for standardized choices such as "Full and Open Market" acquisition methods and "Non-Recurring" classifications as defaults.