Attachment 2 SOI_RRRSSprinklers REVISED 7Apr2026.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Red Rock Ranger Station (RRRS) Fire Sprinkler System Repairs - Coconino NF, AZ
Solicitation number
127EAX26Q0054
Issued by

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

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 ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(01)MOBILIZATION - DIAGNOSISLSQLS1$0.00
211300(01)RRRS DIAGNOSIS AND DESIGNLSQLS1$0.00
SUBTOTAL FOR BASE BID =$0.00
OPTION #1 - RRRS FIRE SPRINKLER SYSTEM REPAIRS
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(02)MOBILIZATION - REPAIRSLSQLS1$0.00
024119(01)RRRS SELECTIVE DEMOLSQLS1$0.00
211300(02)RRRS SPRINKLER SYSTEM REPAIRSLSQLS1$0.00
SUBTOTAL FOR OPTION #1 =$0.00
ALTERNATIVE #1 - RRRS FIRE SPRINKLER SYSTEM REPLACEMENT
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(03)MOBILIZATION - REPLACEMENTLSQLS1$0.00
024119(02)RRRS SELECTIVE DEMOLSQLS1$0.00
211300(03)RRRS SPRINKLER SYSTEM REPLACEMENTLSQLS1$0.00
SUBTOTAL FOR ALTERNATIVE #1 =$0.00
OPTION #2 - RRRS FIRE SUPPLY LINE REPLACEMENT
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(04)MOBILIZATION - FIRE SUPPLY LINELSQLS1$0.00
024119(03)RRRS SELECTIVE DEMOLSQLS1$0.00
210800(01)RRRS FIRE SUPPLY LINE REPLACEMENTLSQLS1$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 ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(01)MOBILIZATION - DIAGNOSISLSQLS1
211300(01)RRRS DIAGNOSIS AND DESIGNLSQLS1
ERROR:#REF!
SUBTOTAL FOR BASE BID =
OPTION #1 - RRRS FIRE SPRINKLER SYSTEM REPAIRS
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(02)MOBILIZATION - REPAIRSLSQLS1
024119(01)RRRS SELECTIVE DEMOLSQLS1
211300(02)RRRS SPRINKLER SYSTEM REPAIRSLSQLS1
SUBTOTAL FOR OPTION #1 =
ALTERNATIVE #1 - RRRS FIRE SPRINKLER SYSTEM REPLACEMENT
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(03)MOBILIZATION - REPLACEMENTLSQLS1
024119(02)RRRS SELECTIVE DEMOLSQLS1
211300(03)RRRS SPRINKLER SYSTEM REPLACEMENTLSQLS1
SUBTOTAL FOR ALTERNATIVE #1 =
OPTION #2 - RRRS FIRE SUPPLY LINE REPLACEMENT
Pay ItemDescriptionMethod of MeasUnitQuantityPriceTotal
016010(04)MOBILIZATION - FIRE SUPPLY LINELSQLS1
024119(03)RRRS SELECTIVE DEMOLSQLS1
210800(01)RRRS FIRE SUPPLY LINE REPLACEMENTLSQLS1
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 .