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)LaborContractor Furnished Material (CFM)Extended Labor & CFMOwner Furnished Material (OFM) (total regardless of count)
UNIT NO.NAME & DESCRIPTION OF CONSTRUCTION UNIT
A1-1115 kV 3-Phase H-Frame Support Structure (Owner Furnished)21,200.002,400.00108,933.00111,333.00
A3-1115 kV Breaker Support Structure (Owner Furnished with breakers)1- 0- 0- 0
A5-1Main Power Transformer Oil Containment Grating Support Structure (Owner Furnished)1- 034,276.0034,276.00
A6-1Alt. Power Transformer Oil Containment Grating Support Structure (Owner Furnished)1- 034,276.0034,276.00
A7-1Bus Disconnect Switch Support Structure (Owner Furnished)3- 04,677.004,677.00
A8-1Diag. Bus Support Structure (Owner Furnished)1- 02,945.002,945.00
A10-1Dist Bay Support Structure (Owner Furnished)Lot- 055,045.0055,045.00
A12-1Low Side Breaker Support Structure (Owner Furnished with breakers)7- 0- 0- 0
A13-1Exp Feeder Riser Support Structure (Owner Furnished)1- 04,475.004,475.00
A13-2Alt. Feeder Riser Support Structure (Owner Furnished)2- 06,871.006,871.00
A13-3Dist. Feeder Riser Support Structure (Owner Furnished)4- 015,992.0015,992.00
A14-1Pull Box Cover (Owner Furnished)3- 04,000.004,000.00
A15-1Static Mast for Spline Ball Shielding (Owner Furnished)5- 030,970.0030,970.00
A16-1Switch Operator Platforms (Owner Furnished)7- 06,495.006,495.00
A17-1Control Buliding Support Structure (Owner Furnished)Lot- 0- 0- 0
A18-1Control Building Access Platforms (Owner Furnished)2- 02,970.002,970.00
A99-1Anchor Bolts and Templates (Owner Furnished)Lot- 09,588.009,588.00
A101/0 ACSR Conductor, Connectors, and ComponentsLot- 0- 0- 0
A25-10Insulator - 25 kV, 150 kV BIL (Owner Furnished)72- 013,348.0013,348.00
A47477 MCM ACSR Conductor, Connectors and ComponentsLot- 0- 0- 0
A611" Bus Pipe, Connectors and ComponentsLot- 0- 0- 0
A622" Bus Pipe, Connectors and ComponentsLot- 0- 0- 0
A90-10Spline Ball Ionizer9- 0- 0- 0
A96Miscellaneous 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- 09,588.009,588.00
A1591590 MCM ACSR Conductor, Connectors and ComponentsLot- 0- 0- 0
A954954 MCM ACSR Conductor, Connectors and ComponentsLot- 0- 0- 0
B15-10115 kV, 1200 Amp Vertical Break GOAB Switch (Owner Furnished)2- 029,273.0029,273.00
B25-1025 kV, 1200 Amp Bus Disconnect Loadbreak Switch (Owner Furnished)3- 044,323.0044,323.00
C15-10Surge Arrester - 8.4 kV MCOV including spares (Owner Furnished)24- 013,181.0013,181.00
C90-10Surge Arrester - 74 kV MCOV including spares (Owner Furnished)9- 017,114.0017,114.00
D10-10Switch Stick and accessories1- 0- 0- 0
D25-10Fused Disconnect Switch (Owner Furnished)4- 05,595.005,595.00
D25-11Fused Disconnect Switch Fuses 6A (Owner Furnished)2- 0418.00418.00
D25-12Fused Disconnect Switch Fuses 3A (Owner Furnished)6- 01,253.001,253.00
D25-20Vertical Mount Disconnect Switch (Owner Furnished)30- 028,427.0028,427.00
D25-21Inverted Mount Disconnect Switch (Owner Furnished)15- 014,213.0014,213.00
E1-1115 kV Main Power Circuit Breaker (Owner Furnished)1- 0155,000.00155,000.00
E1-2115 kV Alt. Power Circuit Breaker (Owner Furnished)(Future by Others)
F1-1Feeder Recloser (Owner Furnished)5- 0163,365.00163,365.00
F1-2Low Side Main Breakers (Owner Furnished)2- 077,744.0077,744.00
G1-1015 kV Voltage Transformers (Owner Furnished)3- 03,826.003,826.00
G2-1015kV Current Transformers 400/800:5 (Owner Furnished)3- 04,686.004,686.00
G2-1015kV Current Transformers 200/400:5 (Owner Furnished)12- 023,433.0023,433.00
G90-10/11Meter, Relay, & Control/SCADA Panels (Owner Furnished)Lot- 0164,000.00164,000.00
H10-10,11,12,13Main Power Transformer and Accesories (Owner Furnished)Lot- 01,663,000.001,663,000.00
H20-10Station Service Transformer and Accesories (Owner Furnished)Lot- 02,500.002,500.00

J50/21 Cable Mounting Brackets 12 - 0 - 0 - 0

J100/21 Cable Mounting Brackets 24 - 0 - 0 - 0

K1-2Conductor - Single Conductor #2 AWG CU470- 0- 0- 0
K1-40Conductor - Single Conductor 4/0 AWG CU1400- 0- 0- 0
K1-40R/BKConductor - Single Conductor 4/0 AWG DLO CU80- 0- 0- 0
K2-8Cable - Two conductor #8, Non-Shielded1020- 0- 0- 0
K2-10Cable - Two conductor #10, Non-Shielded5900- 0- 0- 0
K3-1Cable - Three conductor #1, Non-Shielded350- 0- 0- 0
K3-8Cable - Three conductor #8, Non-Shielded270- 0- 0- 0
K3-10Cable - Three conductor #10, Non-Shielded1750- 0- 0- 0
K4-101Cable - Four conductor #10, Non-Shielded7110- 0- 0- 0
K12-10Cable - Twelve conductor #10, Shielded2800- 0- 0- 0
K12-12Cable - Twelve conductor #12, Non-Shielded120- 0- 0- 0
K12-16Cable - Twelve conductor #16, Shielded3480- 0- 0- 0
K10-1Conduit - 1" Rigid Galvanized Steel200- 0- 0- 0
K20-1Conduit – 2” Rigid Galvanized Steel.800- 0- 0- 0
K20-2/3Conduit – 2" Schedule 80/40 PVC.4600- 0- 0- 0
K20-4Conduit – 2” PVC schedule 80 sweeps.130- 0- 0- 0
K25-1Conduit – 2 1/2” Rigid Galvanized Steel.10- 0- 0- 0
K25-2/3Conduit – 2 1/2" Schedule 80/40 PVC.80- 0- 0- 0
K25-4Conduit – 2 1/2” PVC schedule 80 sweeps.2- 0- 0- 0
K40-3Conduit – 4" PVC schedule 40 .920- 0- 0- 0
K40-5Conduit – 4” PVC schedule 40, sweeps40- 0- 0- 0
K50/11Mete/Main Combo and Accessories1- 0- 0- 0
K50/12Meter (Owner Furnished)1- 0200.00200.00
K50/20Junction Boxes & Accessories - Small4- 0- 0- 0
K50/30Junction Boxes & Accessories - Large6- 0- 0- 0
K60-3Conduit – 6" PVC schedule 401500- 0- 0- 0
K60-5Conduit – 6” PVC schedule 40, sweeps14- 0- 0- 0
K60-8Conduit – 6” Rigid Aluminum100- 0- 0- 0
K60-9Cable Support - 6"10- 0- 0- 0
K60-10Bottom Ventalator - 6"10- 0- 0- 0
K70Fuses, Fuse Blocks, Terminal Blocks, Shorting Blocks, test switches, ground barsLot- 0- 0- 0
K78Comm cable/componentsLot- 0- 0- 0
K80-10Yard Light - new static mast & deadend22- 0- 0- 0
K80-11Yard Light - Dusk to Dawn1- 0- 0- 0
K90-10/11Station Signage26- 0- 0- 0
K90-1Conduit Fittings and AccessoriesLot- 0- 0- 0
K90-2Cable Fittings and AccessoriesLot- 0- 0- 0
L1-1115 kV A-Frame Switch Structure Foundation4- 0- 0- 0
L3-1115 kV Breaker Foundation2- 0- 0- 0
L5-1Main Power Transformer Containment1- 0- 0- 0
L6-1Alt. Power Transformer Containmnet1- 0- 0- 0
L7-1Bus Disconnect Switch Stand Foundation3- 0- 0- 0
L8-1Diag. Bus Support Stand Foundation1- 0- 0- 0
L10-1Dist. Bay Support Foundation14- 0- 0- 0
L12-1Feeder Breaker Foundation7- 0- 0- 0
L13-1Exp. Feeder Riser Foundation1- 0- 0- 0
L13-2Alt. Feed Riser Foundation2- 0- 0- 0
L13-3Dist. Feeder Riser Foundation4- 0- 0- 0
L14-1Pull Box Foundation3- 0- 0- 0
L15-1Static Mast Foundation5- 0- 0- 0
L16-1Switch Operator Curb Sets7- 0- 0- 0
L17-1Control Building Pier Foundations13- 0- 0- 0
L18-1Control Buliding Access Stoops2- 0- 0- 0
M1-1Site Preparation & Surfacing Including removal, replacement and additional material; surfacingLot- 0- 0- 0
N1-1Site Permiter Fence, Gates and AccessoriesLot- 0- 0- 0
O1-1Grounding Conductor - 4/0 Bare, 7 Strand Tinned Copper1500- 0- 0- 0
O1-24/0 Bare, 19 Strand Tinned Copper, Soft Drawn5400- 0- 0- 0
O1-3#2 Bare Solid Tinned Copper, Soft Drawn750- 0- 0- 0
O2-1Ground Rods - stainless steel37- 0- 0- 0
O3-2 / O3-24Grounding Materials - General Terminals, Clamps, Connectors and AccessoriesLot- 0- 0- 0
O3-25Grounding Materials - Sectional Stainless Steel Threaded Ground Rods27- 0- 0- 0
O3-26 / O3-42Grounding Materials - Grounding Misc. ItemsLot- 0- 0- 0

P1 Control Building (Owner Furnished) Lot - 0 322,000.00 322,000.00

R1Battery Bank (Owner Furnished)Lot- 035,000.0035,000.00
R2Battery Charger (Owner Furnished)Lot- 07,500.007,500.00
R3Battery rack/containment (Owner Furnished)Lot- 02,500.002,500.00
R4Battery fuse enclosure/fuse blocks (Owner Furnished & Contractor Furnished Items)Lot- 02,000.002,000.00
Q1Bonding Cost for Project1- 0- 0- 0
Q2Field Acceptance TestingLot- 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 .