RFI - OIT Inventory and Warehouse Mgmt Requirements.xlsx

This is a Requirements Document for an Inventory and Warehouse Management System for the Executive Office for Immigration Review (EOIR), a component of the Department of Justice. The document outlines functional and technical requirements organized across nine primary categories that prospective vendors must address.

The system must support unified inventory management for both accountable and non-accountable items with comprehensive item master data including SKUs, descriptions, units, and multi-location assignment across courts and stockrooms. Key functional areas include mobile inventory capabilities with barcode scanning and serialized validation; receiving and putaway processes with PO matching and bin location tracking; fulfillment and shipping with carrier integration (FedEx/UPS), pick/pack workflows, and multi-location shipment planning; and inventory controls including min/max levels, cycle counts, variance reconciliation, and obselescence tracking. The system must incorporate role-based access controls, approval workflows for key actions, SLA/turnaround time tracking, and reburbishment and vendor return workflows. Analytics and reporting capabilities must include standard inventory dashboards, KPI monitoring, aging/slow mover identification, inventory turn calculations, demand forecasting, and real-time customizable report generation. Integration requirements include APM, UFMS, and RFID/automated scanning devices via API capability. Additionally, the system must support asset management functionality including software license tracking, serial number assignment to courts or individuals, and graphical interfaces for asset visibility by user or court location, with the ability to manage nested subassemblies, bill of materials, and kit tracking with audit trails and compliance reporting.