Dallas_supplies_update_MAR_2026.xlsx

This is a supplies inventory update document for the Dallas facilities, listing safety equipment and personal protective equipment (PPE) maintained across multiple warehouse locations as of March 2026. The Kenton County Airport Board (KCAB) in Kentucky has issued a bid opportunity for Safety Supplies, and this spreadsheet appears to serve as a reference inventory for the types and quantities of safety products currently stocked. The inventory encompasses over 120 line items including safety glasses, gloves (work, disposable, and protective), hard hats, respirators, hearing protection, safety vests, first aid supplies, masks, and various other PPE categories. Items are tracked by part description, unit of measure, quantity on hand, storage location, bin assignment, average price, and extended price value. The document indicates last transaction dates ranging from 2020 through March 2026, with most recent activity concentrated in February and March 2026, suggesting active procurement and usage cycles.

Pricing in the inventory ranges from less than one dollar for items such as first aid bandages to over $160 for full-face respirators, with average unit prices typically between $5 and $40 for most PPE items. Stock levels are managed using reorder level and maximum level parameters, with most items designated under either "On demand" or "Reorder level" stock methods. Total quantities on hand for high-volume items such as disposable nitrile gloves exceed 300 units across various sizes, while specialty items like arc-rated safety vests maintain lower stock levels. Suppliers include major vendors such as Federal Supply LLC, WW Grainger Inc., Safety Smart Gear Inc., and others, with cost codes consistently assigned to account 100.815.900.5310.0350.000.000 for most safety supplies. Daily run rates and annual usage data are tracked for most items to inform inventory management decisions, though some entries contain data errors indicated by "#VALUE!" notations in the spreadsheet.