Unit_Pricing_Breakdown_with_CFM_and_OFM.CoG.New_Sunshine_Revised.xlsx
XLSX spreadsheet 67 KB Posted
- Attached to
- New Sunshine Substation Construction
- Solicitation number
- 2025/2026/02
- Issued by
- Quay County, New Mexico
About this file
The document is a Unit Pricing Breakdown spreadsheet for the New Sunshine Substation Construction project by the City of Gallup, New Mexico. The comprehensive document details a complete electrical substation construction project, itemizing 100+ components and materials, with most items designated as Owner Furnished Material (OFM). The project involves constructing a new power substation to replace an existing dated facility, including grading, access road preparation, underground and above-ground infrastructure, ground grid installation, conduits, foundations, structural steel erection, equipment installation, bus work, control cables, terminations, and testing.
The total substation cost proposal is $3,127,400, with $3,125,000 specifically allocated for Owner Furnished Materials. The project includes extensive electrical infrastructure components such as 115 kV support structures, transformers, breakers, switches, surge arresters, voltage and current transformers, cable systems, conduits, grounding materials, and a control building. The spreadsheet meticulously breaks down each component's quantity and associated costs, with most materials being owner-furnished, suggesting a collaborative approach between the city and the selected contractor. The project's primary objective is to improve the reliability and performance of the electrical distribution system in Gallup, New Mexico.
View the file
Other files
Show all 19
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
New Sunshine Substation - Construction Bid Units NUMBER OF UNITS UNIT PRICING BREAKDOWN EXTENDED PRICE -- LABOR AND CFM/OFM COSTS
| (lot quantity = 1, count or length in ft) | Labor | Contractor Furnished Material (CFM) | Extended Labor & CFM | Owner Furnished Material (OFM) (total regardless of count) | |||
| UNIT NO. | NAME & DESCRIPTION OF CONSTRUCTION UNIT | ||||||
| A1-1 | 115 kV 3-Phase H-Frame Support Structure (Owner Furnished) | 2 | 1,200.00 | 2,400.00 | 108,933.00 | 111,333.00 | |
| A3-1 | 115 kV Breaker Support Structure (Owner Furnished with breakers) | 1 | - 0 | - 0 | - 0 | ||
| A5-1 | Main Power Transformer Oil Containment Grating Support Structure (Owner Furnished) | 1 | - 0 | 34,276.00 | 34,276.00 | ||
| A6-1 | Alt. Power Transformer Oil Containment Grating Support Structure (Owner Furnished) | 1 | - 0 | 34,276.00 | 34,276.00 | ||
| A7-1 | Bus Disconnect Switch Support Structure (Owner Furnished) | 3 | - 0 | 4,677.00 | 4,677.00 | ||
| A8-1 | Diag. Bus Support Structure (Owner Furnished) | 1 | - 0 | 2,945.00 | 2,945.00 | ||
| A10-1 | Dist Bay Support Structure (Owner Furnished) | Lot | - 0 | 55,045.00 | 55,045.00 | ||
| A12-1 | Low Side Breaker Support Structure (Owner Furnished with breakers) | 7 | - 0 | - 0 | - 0 | ||
| A13-1 | Exp Feeder Riser Support Structure (Owner Furnished) | 1 | - 0 | 4,475.00 | 4,475.00 | ||
| A13-2 | Alt. Feeder Riser Support Structure (Owner Furnished) | 2 | - 0 | 6,871.00 | 6,871.00 | ||
| A13-3 | Dist. Feeder Riser Support Structure (Owner Furnished) | 4 | - 0 | 15,992.00 | 15,992.00 | ||
| A14-1 | Pull Box Cover (Owner Furnished) | 3 | - 0 | 4,000.00 | 4,000.00 | ||
| A15-1 | Static Mast for Spline Ball Shielding (Owner Furnished) | 5 | - 0 | 30,970.00 | 30,970.00 | ||
| A16-1 | Switch Operator Platforms (Owner Furnished) | 7 | - 0 | 6,495.00 | 6,495.00 | ||
| A17-1 | Control Buliding Support Structure (Owner Furnished) | Lot | - 0 | - 0 | - 0 | ||
| A18-1 | Control Building Access Platforms (Owner Furnished) | 2 | - 0 | 2,970.00 | 2,970.00 | ||
| A99-1 | Anchor Bolts and Templates (Owner Furnished) | Lot | - 0 | 9,588.00 | 9,588.00 |
| A10 | 1/0 ACSR Conductor, Connectors, and Components | Lot | - 0 | - 0 | - 0 |
| A25-10 | Insulator - 25 kV, 150 kV BIL (Owner Furnished) | 72 | - 0 | 13,348.00 | 13,348.00 |
| A47 | 477 MCM ACSR Conductor, Connectors and Components | Lot | - 0 | - 0 | - 0 |
| A61 | 1" Bus Pipe, Connectors and Components | Lot | - 0 | - 0 | - 0 |
| A62 | 2" Bus Pipe, Connectors and Components | Lot | - 0 | - 0 | - 0 |
| A90-10 | Spline Ball Ionizer | 9 | - 0 | - 0 | - 0 |
| A96 | Miscellaneous Mechanical Components/Fasteners (Contractor to supply all Project fasteners, mounting bolts and required hardware in addition to those being supplied by Owner as noted.) | Lot | - 0 | 9,588.00 | 9,588.00 |
| A159 | 1590 MCM ACSR Conductor, Connectors and Components | Lot | - 0 | - 0 | - 0 |
| A954 | 954 MCM ACSR Conductor, Connectors and Components | Lot | - 0 | - 0 | - 0 |
| B15-10 | 115 kV, 1200 Amp Vertical Break GOAB Switch (Owner Furnished) | 2 | - 0 | 29,273.00 | 29,273.00 |
| B25-10 | 25 kV, 1200 Amp Bus Disconnect Loadbreak Switch (Owner Furnished) | 3 | - 0 | 44,323.00 | 44,323.00 |
| C15-10 | Surge Arrester - 8.4 kV MCOV including spares (Owner Furnished) | 24 | - 0 | 13,181.00 | 13,181.00 |
| C90-10 | Surge Arrester - 74 kV MCOV including spares (Owner Furnished) | 9 | - 0 | 17,114.00 | 17,114.00 |
| D10-10 | Switch Stick and accessories | 1 | - 0 | - 0 | - 0 |
| D25-10 | Fused Disconnect Switch (Owner Furnished) | 4 | - 0 | 5,595.00 | 5,595.00 |
| D25-11 | Fused Disconnect Switch Fuses 6A (Owner Furnished) | 2 | - 0 | 418.00 | 418.00 |
| D25-12 | Fused Disconnect Switch Fuses 3A (Owner Furnished) | 6 | - 0 | 1,253.00 | 1,253.00 |
| D25-20 | Vertical Mount Disconnect Switch (Owner Furnished) | 30 | - 0 | 28,427.00 | 28,427.00 |
| D25-21 | Inverted Mount Disconnect Switch (Owner Furnished) | 15 | - 0 | 14,213.00 | 14,213.00 |
| E1-1 | 115 kV Main Power Circuit Breaker (Owner Furnished) | 1 | - 0 | 155,000.00 | 155,000.00 |
| E1-2 | 115 kV Alt. Power Circuit Breaker (Owner Furnished) | (Future by Others) |
| F1-1 | Feeder Recloser (Owner Furnished) | 5 | - 0 | 163,365.00 | 163,365.00 |
| F1-2 | Low Side Main Breakers (Owner Furnished) | 2 | - 0 | 77,744.00 | 77,744.00 |
| G1-10 | 15 kV Voltage Transformers (Owner Furnished) | 3 | - 0 | 3,826.00 | 3,826.00 |
| G2-10 | 15kV Current Transformers 400/800:5 (Owner Furnished) | 3 | - 0 | 4,686.00 | 4,686.00 |
| G2-10 | 15kV Current Transformers 200/400:5 (Owner Furnished) | 12 | - 0 | 23,433.00 | 23,433.00 |
| G90-10/11 | Meter, Relay, & Control/SCADA Panels (Owner Furnished) | Lot | - 0 | 164,000.00 | 164,000.00 |
| H10-10,11,12,13 | Main Power Transformer and Accesories (Owner Furnished) | Lot | - 0 | 1,663,000.00 | 1,663,000.00 |
| H20-10 | Station Service Transformer and Accesories (Owner Furnished) | Lot | - 0 | 2,500.00 | 2,500.00 |
J50/21 Cable Mounting Brackets 12 - 0 - 0 - 0
J100/21 Cable Mounting Brackets 24 - 0 - 0 - 0
| K1-2 | Conductor - Single Conductor #2 AWG CU | 470 | - 0 | - 0 | - 0 |
| K1-40 | Conductor - Single Conductor 4/0 AWG CU | 1400 | - 0 | - 0 | - 0 |
| K1-40R/BK | Conductor - Single Conductor 4/0 AWG DLO CU | 80 | - 0 | - 0 | - 0 |
| K2-8 | Cable - Two conductor #8, Non-Shielded | 1020 | - 0 | - 0 | - 0 |
| K2-10 | Cable - Two conductor #10, Non-Shielded | 5900 | - 0 | - 0 | - 0 |
| K3-1 | Cable - Three conductor #1, Non-Shielded | 350 | - 0 | - 0 | - 0 |
| K3-8 | Cable - Three conductor #8, Non-Shielded | 270 | - 0 | - 0 | - 0 |
| K3-10 | Cable - Three conductor #10, Non-Shielded | 1750 | - 0 | - 0 | - 0 |
| K4-101 | Cable - Four conductor #10, Non-Shielded | 7110 | - 0 | - 0 | - 0 |
| K12-10 | Cable - Twelve conductor #10, Shielded | 2800 | - 0 | - 0 | - 0 |
| K12-12 | Cable - Twelve conductor #12, Non-Shielded | 120 | - 0 | - 0 | - 0 |
| K12-16 | Cable - Twelve conductor #16, Shielded | 3480 | - 0 | - 0 | - 0 |
| K10-1 | Conduit - 1" Rigid Galvanized Steel | 200 | - 0 | - 0 | - 0 |
| K20-1 | Conduit – 2” Rigid Galvanized Steel. | 800 | - 0 | - 0 | - 0 |
| K20-2/3 | Conduit – 2" Schedule 80/40 PVC. | 4600 | - 0 | - 0 | - 0 |
| K20-4 | Conduit – 2” PVC schedule 80 sweeps. | 130 | - 0 | - 0 | - 0 |
| K25-1 | Conduit – 2 1/2” Rigid Galvanized Steel. | 10 | - 0 | - 0 | - 0 |
| K25-2/3 | Conduit – 2 1/2" Schedule 80/40 PVC. | 80 | - 0 | - 0 | - 0 |
| K25-4 | Conduit – 2 1/2” PVC schedule 80 sweeps. | 2 | - 0 | - 0 | - 0 |
| K40-3 | Conduit – 4" PVC schedule 40 . | 920 | - 0 | - 0 | - 0 |
| K40-5 | Conduit – 4” PVC schedule 40, sweeps | 40 | - 0 | - 0 | - 0 |
| K50/11 | Mete/Main Combo and Accessories | 1 | - 0 | - 0 | - 0 |
| K50/12 | Meter (Owner Furnished) | 1 | - 0 | 200.00 | 200.00 |
| K50/20 | Junction Boxes & Accessories - Small | 4 | - 0 | - 0 | - 0 |
| K50/30 | Junction Boxes & Accessories - Large | 6 | - 0 | - 0 | - 0 |
| K60-3 | Conduit – 6" PVC schedule 40 | 1500 | - 0 | - 0 | - 0 |
| K60-5 | Conduit – 6” PVC schedule 40, sweeps | 14 | - 0 | - 0 | - 0 |
| K60-8 | Conduit – 6” Rigid Aluminum | 100 | - 0 | - 0 | - 0 |
| K60-9 | Cable Support - 6" | 10 | - 0 | - 0 | - 0 |
| K60-10 | Bottom Ventalator - 6" | 10 | - 0 | - 0 | - 0 |
| K70 | Fuses, Fuse Blocks, Terminal Blocks, Shorting Blocks, test switches, ground bars | Lot | - 0 | - 0 | - 0 |
| K78 | Comm cable/components | Lot | - 0 | - 0 | - 0 |
| K80-10 | Yard Light - new static mast & deadend | 22 | - 0 | - 0 | - 0 |
| K80-11 | Yard Light - Dusk to Dawn | 1 | - 0 | - 0 | - 0 |
| K90-10/11 | Station Signage | 26 | - 0 | - 0 | - 0 |
| K90-1 | Conduit Fittings and Accessories | Lot | - 0 | - 0 | - 0 |
| K90-2 | Cable Fittings and Accessories | Lot | - 0 | - 0 | - 0 |
| L1-1 | 115 kV A-Frame Switch Structure Foundation | 4 | - 0 | - 0 | - 0 |
| L3-1 | 115 kV Breaker Foundation | 2 | - 0 | - 0 | - 0 |
| L5-1 | Main Power Transformer Containment | 1 | - 0 | - 0 | - 0 |
| L6-1 | Alt. Power Transformer Containmnet | 1 | - 0 | - 0 | - 0 |
| L7-1 | Bus Disconnect Switch Stand Foundation | 3 | - 0 | - 0 | - 0 |
| L8-1 | Diag. Bus Support Stand Foundation | 1 | - 0 | - 0 | - 0 |
| L10-1 | Dist. Bay Support Foundation | 14 | - 0 | - 0 | - 0 |
| L12-1 | Feeder Breaker Foundation | 7 | - 0 | - 0 | - 0 |
| L13-1 | Exp. Feeder Riser Foundation | 1 | - 0 | - 0 | - 0 |
| L13-2 | Alt. Feed Riser Foundation | 2 | - 0 | - 0 | - 0 |
| L13-3 | Dist. Feeder Riser Foundation | 4 | - 0 | - 0 | - 0 |
| L14-1 | Pull Box Foundation | 3 | - 0 | - 0 | - 0 |
| L15-1 | Static Mast Foundation | 5 | - 0 | - 0 | - 0 |
| L16-1 | Switch Operator Curb Sets | 7 | - 0 | - 0 | - 0 |
| L17-1 | Control Building Pier Foundations | 13 | - 0 | - 0 | - 0 |
| L18-1 | Control Buliding Access Stoops | 2 | - 0 | - 0 | - 0 |
| M1-1 | Site Preparation & Surfacing Including removal, replacement and additional material; surfacing | Lot | - 0 | - 0 | - 0 |
| N1-1 | Site Permiter Fence, Gates and Accessories | Lot | - 0 | - 0 | - 0 |
| O1-1 | Grounding Conductor - 4/0 Bare, 7 Strand Tinned Copper | 1500 | - 0 | - 0 | - 0 |
| O1-2 | 4/0 Bare, 19 Strand Tinned Copper, Soft Drawn | 5400 | - 0 | - 0 | - 0 |
| O1-3 | #2 Bare Solid Tinned Copper, Soft Drawn | 750 | - 0 | - 0 | - 0 |
| O2-1 | Ground Rods - stainless steel | 37 | - 0 | - 0 | - 0 |
| O3-2 / O3-24 | Grounding Materials - General Terminals, Clamps, Connectors and Accessories | Lot | - 0 | - 0 | - 0 |
| O3-25 | Grounding Materials - Sectional Stainless Steel Threaded Ground Rods | 27 | - 0 | - 0 | - 0 |
| O3-26 / O3-42 | Grounding Materials - Grounding Misc. Items | Lot | - 0 | - 0 | - 0 |
P1 Control Building (Owner Furnished) Lot - 0 322,000.00 322,000.00
| R1 | Battery Bank (Owner Furnished) | Lot | - 0 | 35,000.00 | 35,000.00 |
| R2 | Battery Charger (Owner Furnished) | Lot | - 0 | 7,500.00 | 7,500.00 |
| R3 | Battery rack/containment (Owner Furnished) | Lot | - 0 | 2,500.00 | 2,500.00 |
| R4 | Battery fuse enclosure/fuse blocks (Owner Furnished & Contractor Furnished Items) | Lot | - 0 | 2,000.00 | 2,000.00 |
| Q1 | Bonding Cost for Project | 1 | - 0 | - 0 | - 0 |
| Q2 | Field Acceptance Testing | Lot | - 0 | - 0 | - 0 |
| --- | Total OFM as listed: | $ 3,125,000.00 | |||
| Total Substation Cost Proposal including ($3,125,000 OFM) | 3,127,400.00 |
&"Arial,Bold"&14City of Gallup New Sunshine Substation - UPB
&"Arial,Bold"&12
&"Arial,Regular"UPB-&P
File details come from the government source that posted it. Updated .