IFB 92-25 Delivery Projections.xlsx

The file IFB 92-25 Delivery Projections.xlsx is an Invitation for Bid (IFB) spreadsheet detailing gas delivery requirements for multiple Massachusetts Bay Transportation Authority (MBTA) rail and yard locations. The document specifies monthly stock level projections for various industrial gases including oxygen, acetylene, propane, argon, carbon dioxide, nitrogen, liquid oxygen, liquid nitrogen, and a tri-gas mixture at five distinct MBTA transportation facilities: Charlestown Rail Shop, Green Line Reservoir Yard, Red Line Cabot Yard, Orange Line Wellington Yard, and Blue Line Orient Heights Yard. Delivery hours are consistently set from 7:00 AM to 1:00 PM, with each location requiring 20 units of oxygen, 15 units of acetylene, and 20 units of propane at the end of each month.

The spreadsheet appears to be a comprehensive inventory management and replenishment planning document, indicating a structured approach to gas supply for MBTA's maintenance and operational needs. Each location maintains identical stock levels across different gas types, suggesting standardized requirements across the transportation network. The precise tracking of gas quantities at these strategic locations implies a just-in-time inventory management strategy designed to ensure continuous supply without excess stockpiling, which could potentially optimize procurement costs and reduce waste.