Attachment 1 Schedule of Supplies.xlsx

This is a pricing schedule template for a firm fixed-price battery supply contract with the U.S. Coast Guard for lead acid batteries supporting patrol boat operations. Vendors must propose fixed unit costs for 14 distinct battery types identified by NSN and OEM/part number across five one-year ordering periods. Battery types include products from manufacturers such as East Penn, Enersys, Nova Power, Powersonic, and Powerstar, with estimated annual demand quantities ranging from 2 to 375 units per battery type. The vendor's proposed pricing must account for routine battery delivery and pickup/disposal of old batteries within their identified service areas, with all costs included in the firm fixed price per unit.

The contract structure includes automatic cost escalation provisions, requiring vendors to account for material, labor, and inflation cost increases across the five-year performance period. Government-reimbursed shipping costs for deliveries outside the vendor's service area and emergency shipments are excluded from the firm fixed price and estimated at $100,000 annually in period one, escalating to $140,000 by period five. The total estimated 5-year contract value is $1,200,000 including reimbursable shipping costs. Vendors must complete the pricing template by entering proposed unit costs in column E for all battery line items across all five ordering periods to establish the contract's total estimated value.