4820 Summary.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Pipe Repair Clamps
- Solicitation number
- 4820-0-2019-BO
- Issued by
- Wisconsin
About this file
This is an RFQ award summary for Pipe Repair Clamps (RFQ #4820-0-2019-BO) issued by a Wisconsin state or local government entity. The procurement encompasses eighteen main line items and multiple additional items featuring various sizes and configurations of pipe repair clamps, with quantities ranging from one to one hundred units. The main items include clamps in sizes from 3" x 8" through 20" x 20", manufactured by suppliers such as Smith Blair (models 261, 262, and 264) and Ford (models FS1, FS2, and FS3). Additional specialty items include clamps with varying thicknesses (3/4", 1", and 1.5") in sizes ranging from 4" x 12" through 8" x 12". The award was granted to ETNA First Supply LLC.
The pricing analysis compared three bidders: ETNA (local vendor), Core & Main (non-local vendor), and Smith Blair 261/262/264 (local vendor). ETNA's total bid was $13,231.00, Core & Main's total was $14,386.45, and Smith Blair's total was $13,017.95. When applying local vendor preferences, ETNA's local vendor total was $13,098.69 and Smith Blair's was $12,887.77. ETNA was selected as the awardee despite not having the lowest total price, indicating the local vendor preference affected the award decision. Individual line item pricing varied significantly based on product size and manufacturer, with unit prices ranging from approximately $33.62 to $475.80. The summary notes that Item 3 (3" x 24") lacked pricing from ETNA, affecting the total cost calculation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFQ 4820.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
| Awarded to: ETNA | RFQ #4820-0-2019-BO | |||||||||||||
| Core & Main | ETNA | First Supply LLC | ||||||||||||
| Item | QTY | Description | Manufacturer & Model | Unit Price | Volume Discount | Extended Price | Manufacturer & Model | Unit Price | Volume Discount | Extended Price | Manufacturer & Model | Unit Price | Volume Discount | Extended Price |
| 1 | 2 | 3” x 8” | Smith Blair 261 | $34.00 | $68.00 | Ford FS1 | $35.25 | $70.50 | Smith Blair 261 | $33.62 | $67.24 | |||
| 2 | 2 | 3” x 12” | $52.00 | $104.00 | Ford FS1 | $51.00 | $102.00 | Smith Blair 261 | $51.45 | $102.90 | ||||
| 3 | 2 | 3” x 24” | N/B | N/B | N/B | Ford FS1 | $115.95 | $231.90 | Smith Blair 261 | N/B | N/B | |||
| 4 | 5 | 4” x 8” | $39.00 | $195.00 | Ford FS1 | $37.10 | $185.50 | Smith Blair 261 | $38.51 | $192.55 | ||||
| 5 | 2 | 4” x 12” | $60.00 | $120.00 | Ford FS1 | $59.35 | $118.70 | Smith Blair 261 | $60.00 | $120.00 | ||||
| 6 | 4 | 4” x 24” | $150.00 | $600.00 | Ford FS1 | $133.50 | $534.20 | Smith Blair 261 | $148.12 | $592.48 | ||||
| 7 | 100 | 6” x 8” | $43.50 | $4,350.00 | Ford FS1 | $44.65 | $4,465.00 | Smith Blair 261 | $42.37 | $4,237.00 | ||||
| 8 | 20 | 6” x 12” | $67.50 | $1,350.00 | Ford FS1 | $71.35 | $1,427.00 | Smith Blair 261 | $66.64 | $1,332.80 | ||||
| 9 | 10 | 6” x 20” | $115.75 | $1,157.50 | Ford FS1 | $161.45 | $1,614.50 | Smith Blair 261 | $114.40 | $1,144.00 | ||||
| 10 | 10 | 8” x 8” | $48.80 | $488.00 | Ford FS1 | $52.35 | $523.50 | Smith Blair 261 | $48.25 | $482.50 | ||||
| 11 | 5 | 8” x 12” | $78.00 | $390.00 | Ford FS1 | $83.90 | $419.50 | Smith Blair 261 | $77.08 | $385.40 | ||||
| 12 | 3 | 8” x 24” | $174.00 | $522.00 | Ford FS1 | $175.40 | $526.20 | Smith Blair 261 | $172.08 | $516.24 | ||||
| 13 | 10 | 10” x 12” | $99.50 | $995.00 | Ford FS1 | $113.15 | $1,131.50 | Smith Blair 261 | $98.31 | $983.10 | ||||
| 14 | 2 | 10” x 20” | $158.50 | $317.00 | Ford FS1 | $173.85 | $347.70 | Smith Blair 261 | $156.81 | $313.62 | ||||
| 15 | 2 | 12” x 12” | $120.50 | $241.00 | Ford FS1 | $131.05 | $262.10 | Smith Blair 261 | $119.05 | $238.10 | ||||
| 16 | 1 | 14” x 24” | 262 | $432.50 | $432.50 | Ford FS2 | $397.35 | $397.35 | Smith Blair 262 | $432.18 | $432.10 | |||
| 17 | 2 | 16” x 12” | 262 | $217.00 | $434.00 | Ford FS2 | $235.70 | $471.40 | Smith Blair 262 | $214.72 | $429.44 | |||
| 18 | 1 | 20” x 20” | 262 | $448.00 | $448.00 | Ford FS3 | $475.80 | $475.80 | Smith Blair 262 | $443.38 | $443.38 | |||
| 4” x 12” x 3/4” | 264 | $72.50 | $72.50 | Ford FS1 | $73.90 | $73.90 | Smith Blair 264 | $71.89 | $71.89 | |||||
| 4” x 12” x 1” | $73.50 | $73.50 | Ford FS1 | $73.90 | $73.90 | Smith Blair 264 | $72.25 | $72.25 | ||||||
| 4” x 12” x 1.5” | $79.50 | $79.50 | Ford FS1 | $84.95 | $84.95 | Smith Blair 264 | $78.65 | $78.65 | ||||||
| 4” x 24” x 3/4" | $156.50 | $156.50 | Ford FS1 | $140.90 | $140.90 | Smith Blair 264 | $154.88 | $154.88 | ||||||
| 6” x 8” x 1” | $57.00 | $57.00 | Ford FS1 | $65.25 | $65.25 | Smith Blair 264 | $56.29 | $56.29 | ||||||
| 6” x 12” x 3/4" | $82.00 | $82.00 | Ford FS1 | $92.00 | $92.00 | Smith Blair 264 | $81.15 | $81.15 | ||||||
| 6” x 12” x 1” | $82.00 | $82.00 | Ford FS1 | $92.00 | $92.00 | Smith Blair 264 | $81.15 | $81.15 | ||||||
| 6” x 24” x 1” | $166.00 | $166.00 | Ford FS1 | $177.15 | $177.15 | Smith Blair 264 | $164.15 | $164.15 | ||||||
| 8” x 8” x 1” | $64.00 | $64.00 | Ford FS1 | $72.95 | $72.95 | Smith Blair 264 | $63.27 | $63.27 | ||||||
| 8” x 12” x 3/4” | $93.00 | $93.00 | Ford FS1 | $104.55 | $104.55 | Smith Blair 264 | $92.10 | $92.10 | ||||||
| 8” x 12” x 1” | $93.00 | $93.00 | Ford FS1 | $104.55 | $104.55 | Smith Blair 264 | $89.32 | $89.32 | ||||||
| Local Vendor | Yes | Local Vendor | No | Local Vendor | Yes | |||||||||
| TOTAL: | $13,231.00 | TOTAL: | $14,386.45 | TOTAL: | $13,017.95 | |||||||||
| LOCAL VENDOR GRAND TOTAL | $13,098.69 | LOCAL VENDOR GRAND TOTAL | LOCAL VENDOR GRAND TOTAL | $12,887.77 | ||||||||||
| ** Total with no pricing for Item 3 | **Total with no pricing for Item 3 |
File details come from the government source that posted it. Updated .