Document_00110_attach_C4_-_Project_Worksheet.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Indefinite Delivery Indefinite Quantity for Plumbing and Mechanical Related Work at Various Locations, State of Hawaii
Solicitation number
N6247819R4040
Issued by

About this file

This document contains a project worksheet for a federal construction contract opportunity. The worksheet includes pre-priced line items for various construction materials, labor, and equipment for a plumbing and mechanical project. Line items include structural concrete, piping and insulation materials, plumbing fixtures, HVAC equipment, ductwork, controls, and electrical components. The total estimated cost is $58,749.34 including city cost index and sales tax adjustments. A separate section includes non-pre-priced line items for duct collars.

The related federal contract opportunity is a solicitation for an Indefinite Delivery Indefinite Quantity contract for plumbing and mechanical work at various locations in Hawaii. The scope of work includes repairs, alterations, and new construction services with no design requirements. The contract term is one base year plus four option years not exceeding 60 months total. The NAICS code is 238220 and the small business size standard is $15,000,000. The maximum value is $48,000,000 over five years. Task order minimum and maximum values are $5,000 and $1,000,000 respectively. Proposals are due approximately mid-June 2019.

Attachment C4 - Project Worksheet

View the file

Other files

File Type Posted
Amd2.pdf PDF
Amendment_No._0001.pdf PDF
Document_00110_attach_C1_(Amend_0001).docx DOCX document
Document_00110_attach_C1.docx DOCX document
Document_00110_attach_C3_COEFFICIENT_WORKSHEET.xlsx XLSX spreadsheet
N62478-19-R-4040_RFP.pdf PDF

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

ATTACHMENT C4 - PROJECT WORKSHEET
PRE-PRICED ITEM DESCRIPTIONMEANS ITEM #QTY #QTY UNITNATIONAL AVERAGE MATERIAL (MATL) UNIT COSTMATL TOTAL COSTNATIONAL AVERAGE LABOR UNIT COSTLABOR TOTAL COSTNATIONAL AVERAGE EQUIPMENT (EQUIP) UNIT COSTEQUIP TOTAL COSTOTHER COSTOTHER TOTAL COST
Selective demolition, rubbish handling, dumpster, 6 C.Y., 2 ton capacity, weekly rental, includes one dump per week, cost to be added to demolition cost02411 919 06002.000Week$ 415.00$ 830.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Structural concrete, in place, equipment pad (3000 psi), 4' x 4' x 6", includes forms(4 uses), Grade 60 rebar, concrete (Portland cement Type I), placing and finishing03305 340 35501.000Ea.$ 69.00$ 69.00$ 79.00$ 79.00$ 0.85$ 0.85$ - 0$ - 0
Concrete core drilling, core, reinforced concrete slab, 1" diameter, up to 6" thick slab, includes bit cost, layout and set up time03821 310 01002.000Ea.$ 0.18$ 0.36$ 43.50$ 87.00$ 6.60$ 13.20$ - 0$ - 0
Water heater, residential appliances, electric, glass lined, 30 gallon, maximum11301 523 69501.000Ea.$ 1,250.00$ 1,250.00$ 320.00$ 320.00$ - 0$ - 0$ - 0$ - 0
Labor adjustment factor (mechanical), general, 10' to 14.5' high, add to labor for elevated installation (above floor level), for Division 21, 22 and 23 only22010 220 10800.000$ - 0$ - 010.0%$ - 0$ - 0$ - 0$ - 0$ - 0
Fixture, lavatory, wall hung, selective demolition, includes 10' piping22050 510 12001.000Ea.$ - 0$ - 0$ 49.50$ 49.50$ - 0$ - 0$ - 0$ - 0
Fixture, water closet, floor mounted, selective demolition, includes 10' piping22050 510 14001.000Ea.$ - 0$ - 0$ 62.00$ 62.00$ - 0$ - 0$ - 0$ - 0
Pipe fittings with a single connection, up thru 1-1/2" diameter, selective demolition22050 510 190012.000Ea.$ - 0$ - 0$ 16.55$ 198.60$ - 0$ - 0$ - 0$ - 0
Pipe, metal pipe, to 1-1/2" diam., selective demolition22050 510 200020.000L.F.$ - 0$ - 0$ 2.74$ 54.78$ - 0$ - 0$ - 0$ - 0
Valves or strainers and similar, metal, up thru 1-1/2" diameter, selective demolition22050 510 91002.000Ea.$ - 0$ - 0$ 18.00$ 36.00$ - 0$ - 0$ - 0$ - 0
Valves, bronze, angle, rising stem, threaded or soldered same price, 150 lb., 1/2"22052 320 10605.000Ea.$ 137.00$ 685.00$ 22.50$ 112.50$ - 0$ - 0$ - 0$ - 0
Valves, bronze, relief, pressure & temperature, self-closing, threaded, 3/4", ASME22052 320 56401.000Ea.$ 209.00$ 209.00$ 17.75$ 17.75$ - 0$ - 0$ - 0$ - 0
Pipe hanger / support, C-clamp, 3/8" threaded rod size, for mounting on steel beam flange, type number 23 per MSS-SP58, includes locknut22052 910 032010.000Ea.$ 3.93$ 39.30$ 3.42$ 34.21$ - 0$ - 0$ - 0$ - 0
Vibration absorber, mounts, spring flex, 260 lb. capacity22054 840 11404.000Ea.$ 78.50$ 314.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vibration absorber, mounts, neoprene, 250-1,100 lb capacity22054 840 10204.000Ea.$ 60.00$ 240.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insulation, pipe (price copper tube one size less than I.P.S.), cellular glass, closed cell foam, all service jacket, sealant, 0 water vapor transmission, working temperature (-450 Deg.F to +900 Deg.F), 1" wall, 1/2" iron pipe size, includes sealant22071 910 042840.000L.F.$ 8.50$ 340.00$ 6.75$ 270.00$ - 0$ - 0$ - 0$ - 0
Insulation, pipe (price copper tube one size less than I.P.S.), cellular glass, closed cell foam, all service jacket, sealant, 0 water vapor transmission, working temperature (-450 Deg.F to +900 Deg.F), 1-1/2" wall, 1" iron pipe size, includes sealant22071 910 043070.000L.F.$ 10.00$ 700.00$ 7.70$ 539.00$ - 0$ - 0$ - 0$ - 0
Pipe, copper, tubing, solder, 1/2" diameter, type K, includes coupling & clevis hanger assembly 10' OC22111 323 114055.000L.F.$ 5.20$ 286.00$ 6.98$ 384.17$ - 0$ - 0$ - 0$ - 0
Elbow, 90 Deg., copper, wrought, copper x copper, 1/2"22111 325 010010.000Ea.$ 1.13$ 11.30$ 27.50$ 275.00$ - 0$ - 0$ - 0$ - 0
Pipe, plastic, PVC, 3" diameter, schedule 40, includes couplings 10' OC, and hangers 3 per 10'22111 374 193015.000L.F.$ 12.90$ 193.50$ 16.90$ 253.50$ - 0$ - 0$ - 0$ - 0
Pipe, plastic, PVC, 3/4" diameter, schedule 80, includes couplings 10' OC, and hangers 3 per 10'22111 374 247070.000L.F.$ 5.75$ 402.50$ 10.60$ 742.00$ - 0$ - 0$ - 0$ - 0
Flexible metal hose, bronze braided, bronze ends, threaded, 1/2" diameter x 12"22111 914 01401.000Ea.$ 25.50$ 25.50$ 21.00$ 21.00$ - 0$ - 0$ - 0$ - 0
Flexible metal hose, bronze braided, bronze ends, threaded, 1-1/2" diameter x 18"22111 914 02001.000Ea.$ 60.00$ 60.00$ 39.00$ 39.00$ - 0$ - 0$ - 0$ - 0
Water closet, tank type, vitreous china, floor mounted, close coupled, dual flush, two piece, includes seat, supply pipe with stop22411 313 11101.000Ea.$ 320.00$ 320.00$ 169.00$ 169.00$ - 0$ - 0$ - 0$ - 0
Lavatory, vanity top, vitreous china, white, single bowl, 20" x 16", includes trim22411 613 29001.000Ea.$ 213.00$ 213.00$ 166.00$ 166.00$ - 0$ - 0$ - 0$ - 0
Window air conditioner, selective demolition23050 510 84001.000Ea.$ - 0$ - 0$ 25.50$ 25.50$ - 0$ - 0$ - 0$ - 0
Balancing, air conditioning equipment, central station, built-up low pressure unit, (Subcontractor's quote including material & labor)23059 310 21001.000Ea.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Balancing, air conditioning equipment, supply, return, exhaust, registers and diffusers, average ceiling height, (Subcontractor's quote including material & labor)23059 310 300012.000Ea.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Duct thermal insulation, sheet insulation, polyolefin foam, closed cell, UV stabilized, standard temperature, (-90 Deg.F to +212 Deg.F), 1-1/2" thick23071 310 3776400.000S.F.$ 9.30$ 3,720.00$ 2.25$ 900.00$ - 0$ - 0$ - 0$ - 0
Control component, thermostats, automatic, clock, 24 hour23095 310 52001.000Ea.$ 235.00$ 235.00$ 60.00$ 60.00$ - 0$ - 0$ - 0$ - 0
Control component, thermostats, electric, low voltage, 2 wire23095 310 52201.000Ea.$ 62.00$ 62.00$ 36.00$ 36.00$ - 0$ - 0$ - 0$ - 0
Pump, condensate removal system, pump with 1 Gal. ABS tank, 115 V, 1/50 HP, 200 GPH23212 910 01201.000Ea.$ 187.00$ 187.00$ 42.00$ 42.00$ - 0$ - 0$ - 0$ - 0
Refrigeration specialties, valve, thermostatic, flange/solder, 4 - 5 ton, 1/2" x 7/8"23231 310 88141.000Ea.$ 150.00$ 150.00$ 72.00$ 72.00$ - 0$ - 0$ - 0$ - 0
Refrigerant line sets, insulated copper supply and return tubes, 1/2" and 1-1/8" tubes, 1/2" insulation, 20' long23231 616 21204.000Ea.$ 188.00$ 752.00$ 29.50$ 118.00$ - 0$ - 0$ - 0$ - 0
Refrigeration specialties, refrigerant, R-410A, 25 lb. disposable cylinder23232 320 44501.000Lb.$ 13.40$ 13.40$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Metal ductwork, fabricated rectangular, galvanized steel, 1000 to 2000 lb., incl fittings, joints, supports & allow for a flexible connections field sketches, excludes as-built drawings and insulation23311 313 05601,100.000Lb.$ 0.54$ 594.00$ 7.07$ 7,777.00$ - 0$ - 0$ - 0$ - 0
Metal ductwork, fabricated rectangular, for 40% fittings, add, for 40% fittings, add23311 313 12240.000Lb.$ - 0$ - 034.0%$ - 0$ - 0$ - 0$ - 0$ - 0
Duct accessories, fabrics for flexible connections, with metal edge23311 319 2000144.000L.F.$ 3.66$ 527.04$ 4.78$ 688.32$ - 0$ - 0$ - 0$ - 0
Duct accessories, multi-blade dampers, opposed blade, 8" x 6"23331 313 59902.000Ea.$ 29.00$ 58.00$ 19.95$ 39.90$ - 0$ - 0$ - 0$ - 0
Duct accessories, multi-blade dampers, opposed blade, 8" x 8"23331 313 59941.000Ea.$ 30.00$ 30.00$ 22.00$ 22.00$ - 0$ - 0$ - 0$ - 0
Duct accessories, multi-blade dampers, opposed blade, 10" x 10"23331 313 59966.000Ea.$ 35.50$ 213.00$ 23.00$ 138.00$ - 0$ - 0$ - 0$ - 0
Duct accessories, multi-blade dampers, opposed blade, 12" x 12"23331 313 60002.000Ea.$ 39.50$ 79.00$ 23.00$ 46.00$ - 0$ - 0$ - 0$ - 0
Duct accessories, variable volume modulating motorized damper, 10" x 10", includes electric motor23331 313 75101.000Ea.$ 163.00$ 163.00$ 37.00$ 37.00$ - 0$ - 0$ - 0$ - 0
Duct accessories, turning vane components, turning vane rail23332 313 941010.000L.F.$ 0.76$ 7.60$ 2.99$ 29.90$ - 0$ - 0$ - 0$ - 0
Ductwork, flexible coated fiberglass fabric on corrosion resistant metal helix, non-insulated, 8" diameter, pressure to 12"(WG) UL-18123334 610 16005.000L.F.$ 2.02$ 10.10$ 4.31$ 21.55$ - 0$ - 0$ - 0$ - 0
Ductwork, flexible coated fiberglass fabric on corrosion resistant metal helix, non-insulated, 10" diameter, pressure to 12"(WG) UL-18123334 610 164020.000L.F.$ 2.61$ 52.20$ 5.40$ 108.00$ - 0$ - 0$ - 0$ - 0
Ductwork, flexible coated fiberglass fabric on corrosion resistant metal helix, non-insulated, 12" diameter, pressure to 12"(WG) UL-18123334 610 16605.000L.F.$ 3.10$ 15.50$ 7.20$ 36.00$ - 0$ - 0$ - 0$ - 0
Diffuser, aluminum, ceiling, perforated, 24" x 24" lay-in panel size, 24" x 24", includes opposed blade damper23371 310 06205.000Ea.$ 250.00$ 1,250.00$ 53.00$ 265.00$ - 0$ - 0$ - 0$ - 0
Diffuser, aluminum, ceiling, rectangular, 1 to 4 way blow, 18" x 18", includes opposed blade damper23371 310 11506.000Ea.$ 114.00$ 684.00$ 53.00$ 318.00$ - 0$ - 0$ - 0$ - 0
Louver, aluminum, extruded, with screen, mill finish, fixed blade, continuous line, stormproof23371 540 32000.555S.F.$ 44.00$ 24.42$ 17.10$ 9.49$ - 0$ - 0$ - 0$ - 0
Air filter, mechanical media filtration unit, throwaway glass or paper media type, 12" x 36" x 1"23411 310 55002.000Ea.$ 2.39$ 4.78$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Condensing unit, air cooled, compressor, 4 ton, includes standard controls23621 310 04001.000Ea.$ 1,775.00$ 1,775.00$ 1,000.00$ 1,000.00$ - 0$ - 0$ - 0$ - 0
Central station air handling unit, packaged indoor, constant volume, 2,000 CFM, cooling coils may be chilled water or DX, heating coils may be hot water, steam or electric23731 320 12001.000Ea.$ 10,900.00$ 10,900.00$ 825.00$ 825.00$ - 0$ - 0$ - 0$ - 0
Wire, copper, solid, 600 volt, #12, type THWN-THHN, normal installation conditions in wireway, conduit, cable tray26051 990 09402.000C.L.F.$ 9.60$ 19.20$ 42.50$ 85.00$ - 0$ - 0$ - 0$ - 0
Wire, copper, solid, 600 volt, #10, type XHHW, normal installation conditions in wireway, conduit, cable tray26051 990 29408.000C.L.F.$ 28.50$ 228.00$ 46.50$ 372.00$ - 0$ - 0$ - 0$ - 0
Electric metallic tubing (EMT), 3/4" diameter, to 10' high, incl 2 terminations, 2 field bend elbows, 11 beam clamps, and 11 couplings per 100 LF26053 313 50205.000L.F.$ 1.13$ 5.65$ 3.58$ 17.90$ - 0$ - 0$ - 0$ - 0
Electric metallic tubing (EMT), 1" diameter, to 10' high, incl 2 terminations, 2 elbows, 11 beam clamps, and 11 couplings per 100 LF26053 313 50403.000L.F.$ 1.84$ 5.52$ 4.05$ 12.15$ - 0$ - 0$ - 0$ - 0
Rigid galvanized steel conduit, 1" diameter, to 10' high, includes 11 couplings per 100'26053 314 05402.000L.F.$ 6.10$ 12.20$ 5.00$ 10.00$ - 0$ - 0$ - 0$ - 0
Outlet boxes, pressed steel, 4" square26053 316 015025.000Ea.$ 5.25$ 131.25$ 23.50$ 587.50$ - 0$ - 0$ - 0$ - 0
Circuit breakers, bolt-on, 10 k A I.C., 1 pole, 120 volt, 15-50 amp26241 620 01001.000Ea.$ 19.20$ 19.20$ 46.50$ 46.50$ - 0$ - 0$ - 0$ - 0
Circuit breakers, bolt-on, 10 k A I.C., 2 pole, 240 volt, 15-50 amp26241 620 04001.000Ea.$ 51.00$ 51.00$ 58.00$ 58.00$ - 0$ - 0$ - 0$ - 0
Circuit breakers, bolt-on, 10 k A I.C., 3 pole, 240 volt, 15-60 amp26241 620 07001.000Ea.$ 140.00$ 140.00$ 75.00$ 75.00$ - 0$ - 0$ - 0$ - 0
Toggle switch, quiet type, single pole, 20 amp26272 620 05001.000Ea.$ 2.91$ 2.91$ 17.25$ 17.25$ - 0$ - 0$ - 0$ - 0
Fuses, high capacity, dual element, 250 V, 30 amp, class RK126281 310 18001.000Ea.$ 7.70$ 7.70$ 9.30$ 9.30$ - 0$ - 0$ - 0$ - 0
Fuses, high capacity, dual element, 250 V, 60 amp, class RK126281 310 18501.000Ea.$ 14.00$ 14.00$ 9.30$ 9.30$ - 0$ - 0$ - 0$ - 0
Safety switches, general duty, 3 pole, fusible, 240 volt, 30 amp, NEMA 126281 620 01001.000Ea.$ 55.50$ 55.50$ 146.00$ 146.00$ - 0$ - 0$ - 0$ - 0
Safety switches, 3 pole, fusible, 600 volt, 30 amp, NEMA 426281 620 83101.000Ea.$ 660.00$ 660.00$ 155.00$ 155.00$ - 0$ - 0$ - 0$ - 0
TOTALS$ 29,047.63$ 18,125.58$ 14.05$ - 0
NON-PRE-PRICED ITEM DESCRIPTIONQTY #QTY UNITMATERIAL (MATL) UNIT COSTMATL TOTAL COSTLABOR UNIT COSTLABOR TOTAL COSTEQUIPMENT (EQUIP) UNIT COSTEQUIP TOTAL COSTOTHER COSTOTHER TOTAL COST
Duct collar, spin-in type, round, excludes damper6Ea.$ 5.55$ 33.30$ 24.00$ 144.00$ - 0$ - 0$ - 0$ - 0
PREPRICED LINE TOTALS (MATERIALS + LABOR + EQUIPMENT + OTHER)$47,187.26
CITY COST INDEX 968 (1.189 WEIGHTED AVERAGE)1.189
SUBTOTAL (PREPRICED LINE TOTALS + CCI)$56,105.65
APPLICABLE SALES TAX ON MATERIALS AND EQUIPMENT 4.0712%$2,643.70
SUBTOTAL (PREPRICED LINE ITEMS + CCI + SALES TAX)$58,749.34
PRE-PRICED COEFFICIENT (FROM ATTACHMENT C3 WORKSHEET)DO NOT CHANGE THE UNIT PRICING. COMPLETE THE CALCULATIONS AND RETURN.
TOTAL (PRE-PRICED LINE ITEMS + CCI + SALES TAX, LINE 78) x PRE-PRICED COEFFICIENT ADJUSTMENT (LINE 78 X LINE 79)$0.00
NON PRE-PRICED LINE TOTALS (MATERIALS + LABOR + EQUIPMENT + OTHER)$144.00
APPLICABLE SALES TAX ON MATERIALS AND EQUIPMENT _4.0712%_________$6.79
SUBTOTAL$150.79
NON-PRE-PRICED COEFFICIENT (FROM ATTACHMENT C3 WORKSHEET)
TOTAL (NON PRE-PRICED LINE ITEMS + SALES TAX, LINE 64) x NON-PRE-PRICED COEFFICIENT ADJUSTMENT (LINE 84 X LINE 85)$0.00

TOTAL TASK ORDER PRICE (LINE 80 + LINE 86) $0.00

NOTE: USE OF THIS FORM IS MANDATORY. ANY MODIFICATION OF THIS FORM BY THE OFFEROR WILL RESULT IN THE OFFER BEING REJECTED AS NON-RESPONSIVE. IF AN OFFEROR BELIEVES THERE ARE PROBLEMS WITH THIS FORM, IT IS THE OFFEROR'S RESPONSIBILITY TO PROVIDE DOCUMENTATION OR EVIDENCE PRIOR TO SUBMISSION OF PROPOSALS TO ALLOW FOR GOVERNMENT REVIEW. THIS WILL BE THE BASIC FORMAT FOR ALL TASK ORDER PROPOSALS AFTER AWARD.

File details come from the government source that posted it. Updated .