ESBD_514406_1778530331538_Attachment_G_Bid_Sheet_2_CLIN_AutoCalc[2].xlsx

This is a bid sheet attachment for a Texas state and local contract opportunity involving fiber optic cabling installation at Joint Base San Antonio (JBSA). The project is divided into two separate Contract Line Items (CLINs): CLIN 0001 for JBSA-Randolph West Air Traffic Control Tower (ATCT) Electromagnetic Frequency Immune and Transmitted (EFI&T) Fiber Optic Cabling Installation, and CLIN 0002 for JBSA-Randolph East ATCT EFI&T Fiber Optic Cabling Installation. Vendors must provide separate, binding pricing for each CLIN and are required to submit the bid sheet in Excel (.xlsx) format with all cost information entered into designated blue input cells. The bid sheet includes fields for estimated start and completion dates for each project, with automatic calculation of project duration.

Pricing must be all-inclusive and binding, encompassing all labor, materials, equipment, supervision, mobilization, overhead, bonding and insurance, environmental and compliance costs, and incidental expenses for each CLIN. Vendors must complete detailed cost breakdowns by category in separate tabs for Randolph West and Randolph East, with totals automatically flowing to the CLIN Pricing summary tab. The workbook contains protected formula cells and locked sheets to prevent accidental alterations to calculations. A certification section must be completed and signed by an authorized company representative before submission. No CLINs may be combined, and vendors must provide detailed cost justifications with basis and quantity information for each line item.