Supplies_for_12_Year_Changeou_Bid.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Meter Changeout Supplies State and local contract opportunity
- Solicitation number
- 25-046-ITB
- Issued by
- Lee County, Fort Lauderdale City, Florida
About this file
The document is an Excel spreadsheet detailing supplies for a 12-year meter changeout project for the City of Fort Myers, Florida. The project involves procuring various plumbing and PVC pipe-related supplies for meter replacements, with an estimated total of 12,000 meters to be changed out. The spreadsheet tracks multiple supply items including male adapters, elbows, couplings, pipes, fittings, and accessories such as thread compounds and sealants. The total estimated supply cost is $52,593.73, with a per changeout supply cost of $4.38, and 644 service orders already completed as of the document's date.
The pricing breakdown shows itemized costs for each supply type, with quantities ranging from 19 to 2,702 units per item. The spreadsheet includes detailed purchase dates between December 2024 and February 2025, tracking estimated quantities and unit prices for each component. Notable items include 3/4" and 1" PVC components, various adapters, elbows, couplings, and accessories needed for meter installation. The total project budget appears to be $15,000, with the current estimated supply costs slightly exceeding that at $52,593.73, suggesting potential budget adjustments or additional funding may be required to complete the full meter changeout project.
View the file
Other files for this state and local contract opportunity
Show all 45
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
estimate needed
| Supplies for 12-year Meter Changeout | Total Supplies Cost to Date | $ 2,822.53 | ||||||||||||
| Total Service Orders Completed | 644 | Estimated Total Meters | Estimated Total Cost | |||||||||||
| Supply cost per change out | $ 4.38 | 12000 | $ 52,593.73 | 19 | ||||||||||
| Item Purchased | Price | 12/19/24 | 1/3/25 | 1/5/25 | 1/9/25 | 1/16/25 | 1/17/25 | 1/24/25 | 1/31/25 | 2/4/25 | 2/5/25 | Estimated Quantity | ||
| 3/4" SCH 40 MALE ADAPTER SXMPT 35 PK | $ 13.31 | 2 | 2 | 4 | 4 | 3 | 5 | 20 | 373 | 4960.25 | ||||
| 3/4" SCH 40 90 DEG ELBOW SXS 35 PK | $ 11.91 | 1 | 2 | 2 | 1 | 2 | 4 | 12 | 224 | 2663.11 | ||||
| 3/4" SCH 40 COUPLING SXS (50 PACK) | $ 15.39 | 1 | 1 | 1 | 3 | 4 | 2 | 12 | 224 | 3441.24 | ||||
| 1" PVC MALE ADAPTER SXMPT | $ 1.17 | 15 | 7 | 22 | 410 | 479.63 | ||||||||
| HANDY PK : RED HOT BLUE GLU+PURP PRIMR | $ 8.88 | 4 | 3 | 4 | 4 | 4 | 5 | 7 | 10 | 41 | 764 | 6784.10 | ||
| 1"X2' PVC PIPE | $ 4.24 | 5 | 6 | 11 | 205 | 869.07 | ||||||||
| 1" SCH 40 90 DEGREE ELBOW 15 PACK | $ 12.57 | 2 | 3 | 1 | 3 | 1 | 10 | 186 | 2342.24 | |||||
| 1" SCH 40 COUPLING SXS 25 PACK | $ 12.97 | 1 | 2 | 2 | 4 | 2 | 11 | 205 | 2658.45 | |||||
| 1"X3/4" PVC BUSHING SPGXS | $ 1.48 | 69 | 76 | 145 | 2,702 | 3998.76 | ||||||||
| 8 OZ. 1 STEP PVC CEMENT | $ 7.94 | 3 | 1 | 4 | 75 | 591.80 | ||||||||
| 3/4" SCH 40 45 DEG ELBOW SXS 20 PK | $ 18.97 | 1 | 2 | 3 | 56 | 1060.43 | ||||||||
| 3/4"X1/2" PVC BUSHING SPGXS | $ 0.97 | 5 | 5 | 93 | 90.37 | |||||||||
| 1"X3/4" PVC MALE ADAPTER SXMPT | $ 1.81 | 5 | 8 | 13 | 242 | 438.45 | ||||||||
| 3/4" PVC STREET EL 90D SXSPG | $ 3.11 | 6 | 2 | 8 | 149 | 463.60 | ||||||||
| 1"X3/4" PVC EL 90D SXS | $ 2.59 | 5 | 4 | 9 | 168 | 434.35 | ||||||||
| 1X3/4 PVC REDUCER CPLG SXS SCH40 | $ 2.91 | 13 | 29 | 35 | 20 | 97 | 1,807 | 5259.69 | ||||||
| 1" PVC EL 45D SXS | $ 1.76 | 19 | 19 | 354 | 623.11 | |||||||||
| 3/4" X 10' PVC40 PE PIPE | $ 6.29 | 4 | 10 | 10 | 10 | 10 | 44 | 820 | 5157.02 | |||||
| MAX REFUND VALUE | $ (12.60) | 1 | 1 | 1 | 1 | 4 | 75 | -939.13 | ||||||
| 1"x10' PVC PE PIPE | $ 8.48 | 3 | 3 | 56 | 474.04 | |||||||||
| 1"X3/4" PVC BUSHING SPGXS | $ 1.48 | 90 | 50 | 140 | 2,609 | 3860.87 | ||||||||
| 3/4" SCH 40 TEE SXSXS (20 PACK) | $ 9.81 | 1 | 1 | 19 | 182.80 | |||||||||
| BLUE MONSTER THREAD COMPOUND | $ 7.36 | 4 | 2 | 6 | 112 | 822.86 | ||||||||
| 3/4" CPVC X MIP SOC ADAPTER LF | $ 8.71 | 2 | 2 | 37 | 324.60 | |||||||||
| 1" PVC TEE SXSXFPT | $ 3.33 | 1 | 1 | 19 | 62.05 | |||||||||
| 1"PVC TEE SXSXS | $ 1.97 | 3 | 3 | 56 | 110.12 | |||||||||
| 3/4 PVC/CPVC ADPTR CPLG | $ 2.48 | 27 | 27 | 503 | 1247.70 | |||||||||
| 1/2"X260" PTFE TAPE | $ 0.98 | 5 | 5 | 93 | 91.30 | |||||||||
| 1" PVC STREET EL 90D SXSPG | $ 4.17 | 2 | 2 | 37 | 155.40 | |||||||||
| 3/4" PVC FEMALE ADAPTER SXFPT | $ 1.05 | 12 | 12 | 224 | 234.78 | |||||||||
| BLUE MONSTER PTFE THREAD COMPOUND | $ 7.95 | 1 | 1 | 19 | 148.14 | |||||||||
| 1" PVC COUPLING SXS | $ 0.87 | 22 | 28 | 50 | 932 | 810.56 | ||||||||
| 1" PVC EL 45D SXS | $ 1.76 | 26 | 26 | 484 | 852.67 | |||||||||
| 4OZ THRD SEALANT NO. 5 | $ 7.97 | 7 | 7 | 130 | 1039.57 | |||||||||
| 1" PVC EL 90D SXS | $ 1.48 | 29 | 29 | 540 | 799.75 | |||||||||
| 15,000.00 | 52593.73 | |||||||||||||
| Total | $ 153.35 | $ 88.57 | $ 102.12 | $ 400.31 | $ 244.46 | $ 310.11 | $ 554.75 | $ 403.58 | $ 498.73 | $ 66.55 | ||||
| 153.35 | 88.57 | 102.12 | 400.31 | 244.46 | 310.11 | 554.75 | 403.58 | 498.73 | 66.55 | |||||
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
clean for upload Supplies for 12-year Meter Changeout
| Item Purchased | Estimated Quantity |
| 3/4" SCH 40 MALE ADAPTER SXMPT 35 PK | 373 |
| 3/4" SCH 40 90 DEG ELBOW SXS 35 PK | 224 |
| 3/4" SCH 40 COUPLING SXS (50 PACK) | 224 |
| 1" PVC MALE ADAPTER SXMPT | 410 |
| HANDY PK : RED HOT BLUE GLU+PURP PRIMR | 764 |
| 1"X2' PVC PIPE | 205 |
| 1" SCH 40 90 DEGREE ELBOW 15 PACK | 186 |
| 1" SCH 40 COUPLING SXS 25 PACK | 205 |
| 1"X3/4" PVC BUSHING SPGXS | 2702 |
| 8 OZ. 1 STEP PVC CEMENT | 75 |
| 3/4" SCH 40 45 DEG ELBOW SXS 20 PK | 56 |
| 3/4"X1/2" PVC BUSHING SPGXS | 93 |
| 1"X3/4" PVC MALE ADAPTER SXMPT | 242 |
| 3/4" PVC STREET EL 90D SXSPG | 149 |
| 1"X3/4" PVC EL 90D SXS | 168 |
| 1X3/4 PVC REDUCER CPLG SXS SCH40 | 1807 |
| 1" PVC EL 45D SXS | 354 |
| 3/4" X 10' PVC40 PE PIPE | 820 |
| 1"x10' PVC PE PIPE | 56 |
| 1"X3/4" PVC BUSHING SPGXS | 2609 |
| 3/4" SCH 40 TEE SXSXS (20 PACK) | 19 |
| BLUE MONSTER THREAD COMPOUND | 112 |
| 3/4" CPVC X MIP SOC ADAPTER LF | 37 |
| 1" PVC TEE SXSXFPT | 19 |
| 1"PVC TEE SXSXS | 56 |
| 3/4 PVC/CPVC ADPTR CPLG | 503 |
| 1/2"X260" PTFE TAPE | 93 |
| 1" PVC STREET EL 90D SXSPG | 37 |
| 3/4" PVC FEMALE ADAPTER SXFPT | 224 |
| BLUE MONSTER PTFE THREAD COMPOUND | 19 |
| 1" PVC COUPLING SXS | 932 |
| 1" PVC EL 45D SXS | 484 |
| 4OZ THRD SEALANT NO. 5 | 130 |
| 1" PVC EL 90D SXS | 540 |
| 15000 |
File details come from the government source that posted it. Updated .