Attachment 2 SOI_RRRSSprinklers REVISED 7Apr2026.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- 127EAX26Q0054
- Issued by
-
Department of Agriculture Forest Service
About this file
This file is a pricing template and Schedule of Items (SOI) for the Red Rock Ranger Station Fire Sprinkler System Repairs project at Coconino National Forest in Arizona. The template establishes the structure for contractor pricing across multiple project phases, including a base bid for diagnosis and design assessment, followed by optional and alternative repair/replacement approaches. The base bid encompasses mobilization for diagnosis (Pay Item 016010(01)) and diagnosis and design services (Pay Item 211300(01)), with both items measured as lump sum (LS) quantities. Option #1 includes mobilization for repairs, selective demolition, and sprinkler system repair work. Alternative #1 provides a replacement pathway with mobilization for replacement, selective demolition, and complete sprinkler system replacement. Option #2 addresses the fire supply line with separate mobilization, selective demo, and fire supply line replacement line items. All work items are priced on a lump sum basis with unit quantities of one. The template includes cumulative total calculations for various bid combinations (Option #1 and Option #2 together, Alternative #1 and Option #2 together, and base bid combined with options). The document contains formatting errors in the SOI section, including a #REF! error indicating broken cell references in the pricing calculations. Contractors are expected to complete the pricing template by entering unit prices for each line item, with the template automatically calculating subtotals and total project costs based on selected bid combinations.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 7 RFI Log 001-005 127EAX26Q0054.docx | DOCX document | |
| Attachment 9 PreBid_Attendance Sheet.doc | DOC document | |
| 127EAX26Q0054 0001.pdf | ||
| Attachment 8 Picture of Assumed Blow Off Assembly.pdf | ||
| Attachment 10 Red Rock Visitors Center Inspections.pdf | ||
| Attachment 11 WD AZ20260043 Mod 1.pdf | ||
| C04 Attachment 6 Wage Determination AZ20260043.pdf | ||
| C04 Attachment 1 Statement of Work RRRSSprinklers.docx | DOCX document | |
| C04 Attachment 5 COF Industrial Fire Plan Guidelines 2025.docx | DOCX document | |
| C04 Attachment 4 Specs - RRRSSprinklers.docx | DOCX document | |
| C04 Attachment 2 Schedule of Items.xlsx | XLSX spreadsheet | |
| C04 127EAX26Q0054 1442.pdf | ||
| C04 Attachment 3 Drawings_Modified.pdf |
Show all 13
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
IGCE
| COCONINO NATIONAL FOREST |
| RED ROCK RANGER DISTRICT |
| RED ROCK RANGER STATION FIRE SPRINKLER SYSTEM REPAIRS |
| BASE BID - RRRS FIRE SPRINKLER SYSTEM ASSESSMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(01) | MOBILIZATION - DIAGNOSIS | LSQ | LS | 1 | $0.00 | |
| 211300(01) | RRRS DIAGNOSIS AND DESIGN | LSQ | LS | 1 | $0.00 | |
| SUBTOTAL FOR BASE BID = | $0.00 |
| OPTION #1 - RRRS FIRE SPRINKLER SYSTEM REPAIRS | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(02) | MOBILIZATION - REPAIRS | LSQ | LS | 1 | $0.00 | |
| 024119(01) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | $0.00 | |
| 211300(02) | RRRS SPRINKLER SYSTEM REPAIRS | LSQ | LS | 1 | $0.00 | |
| SUBTOTAL FOR OPTION #1 = | $0.00 |
| ALTERNATIVE #1 - RRRS FIRE SPRINKLER SYSTEM REPLACEMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(03) | MOBILIZATION - REPLACEMENT | LSQ | LS | 1 | $0.00 | |
| 024119(02) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | $0.00 | |
| 211300(03) | RRRS SPRINKLER SYSTEM REPLACEMENT | LSQ | LS | 1 | $0.00 | |
| SUBTOTAL FOR ALTERNATIVE #1 = | $0.00 |
| OPTION #2 - RRRS FIRE SUPPLY LINE REPLACEMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(04) | MOBILIZATION - FIRE SUPPLY LINE | LSQ | LS | 1 | $0.00 | |
| 024119(03) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | $0.00 | |
| 210800(01) | RRRS FIRE SUPPLY LINE REPLACEMENT | LSQ | LS | 1 | $0.00 | |
| SUBTOTAL FOR OPTION #2 = | $0.00 |
| TOTAL FOR OPTION #1 AND OPTION #2 = | $0.00 |
| TOTAL FOR ALTERNATIVE #1 AND OPTION #2 = | $0.00 |
| TOTAL FOR BASE BID + OPTION #1 AND OPTION #2 = | $0.00 |
| TOTAL FOR BASE BID + ALTERNATIVE #1 AND OPTION #2 = | $0.00 |
SOI
| SCHEDULE OF ITEMS |
| COCONINO NATIONAL FOREST |
| RED ROCK RANGER DISTRICT |
| RED ROCK RANGER STATION FIRE SPRINKLER SYSTEM REPAIRS |
| BASE BID - RRRS FIRE SPRINKLER SYSTEM ASSESSMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(01) | MOBILIZATION - DIAGNOSIS | LSQ | LS | 1 | |
| 211300(01) | RRRS DIAGNOSIS AND DESIGN | LSQ | LS | 1 | |
| ERROR:#REF! | |||||
| SUBTOTAL FOR BASE BID = |
| OPTION #1 - RRRS FIRE SPRINKLER SYSTEM REPAIRS | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(02) | MOBILIZATION - REPAIRS | LSQ | LS | 1 | |
| 024119(01) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | |
| 211300(02) | RRRS SPRINKLER SYSTEM REPAIRS | LSQ | LS | 1 | |
| SUBTOTAL FOR OPTION #1 = |
| ALTERNATIVE #1 - RRRS FIRE SPRINKLER SYSTEM REPLACEMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(03) | MOBILIZATION - REPLACEMENT | LSQ | LS | 1 | |
| 024119(02) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | |
| 211300(03) | RRRS SPRINKLER SYSTEM REPLACEMENT | LSQ | LS | 1 | |
| SUBTOTAL FOR ALTERNATIVE #1 = |
| OPTION #2 - RRRS FIRE SUPPLY LINE REPLACEMENT | ||||||
| Pay Item | Description | Method of Meas | Unit | Quantity | Price | Total |
| 016010(04) | MOBILIZATION - FIRE SUPPLY LINE | LSQ | LS | 1 | |
| 024119(03) | RRRS SELECTIVE DEMO | LSQ | LS | 1 | |
| 210800(01) | RRRS FIRE SUPPLY LINE REPLACEMENT | LSQ | LS | 1 | |
| SUBTOTAL FOR OPTION #2 = |
| TOTAL FOR OPTION #1 AND OPTION #2 = |
| TOTAL FOR ALTERNATIVE #1 AND OPTION #2 = |
| TOTAL FOR BASE BID + OPTION #1 AND OPTION #2 = |
| TOTAL FOR BASE BID + ALTERNATIVE #1 AND OPTION #2 = |
File details come from the government source that posted it. Updated .