roundabouts.detail.opc

Record · Cost estimates (OPC)

roundabouts.detail.opc

roundabouts.detail

[verified]

estimate_template

estimator Tetra Tech (RJS, checked AMD)
date 2025-07-11
basis CONCEPTUAL
contingency_rate 0.25
sections
- ROADWAY
- EROSION_CONTROL
- DRAINAGE
- PAVEMENT
- WATER_WORK
- LIGHTING
- TRAFFIC_CONTROL
- LANDSCAPING
- RIGHT_OF_WAY
- INCIDENTALS
- DESIGN_SURVEY_INSPECTION

page_319_diller

title Cole Street / Diller Road Roundabout
pdf_page 319
work_description Roundabout at Cole/Diller intersection (North Cole & West Diller)
construction_subtotal 1228174
contingency_and_inflation_25pct 307044
total 1535218
line_items
- ROADWAY
  - items
    - - item_no 201E11000
      - description Clearing and grubbing
      - quantity 1
      - unit LS
      - unit_amount 20000
      - total_amount 20000
    - - item_no 203E10000
      - description Excavation, as per plan
      - quantity ~2490
      - unit CY
      - unit_amount ~17.0
      - total_amount ~42315
      - note qty/rate est. from total; Diller-specific geometry
    - - item_no 203E20001
      - description Embankment, as per plan
      - quantity ~3100
      - unit CY
      - unit_amount ~1.0
      - total_amount ~3100
    - - item_no 204E10001
      - description Subgrade compaction, as per plan
      - quantity ~6200
      - unit SY
      - unit_amount ~1.0
      - total_amount ~6200
    - - item_no 623E38500
      - description Monument assembly, Type C
      - quantity 3
      - unit EACH
      - unit_amount 500
      - total_amount 1500
    - - item_no 653E10001
      - description Topsoil furnished and placed, as per plan
      - quantity ~290
      - unit CY
      - unit_amount ~50.0
      - total_amount ~14500
      - note splitter island preparation
    - - item_no custom_walk
      - description Decorative plain concrete walk, 6" thick (splitter island), as per plan
      - quantity ~2650
      - unit SF
      - unit_amount ~10.0
      - total_amount ~26500
  - subtotal ~109307
- EROSION_CONTROL
  - items —
  - subtotal ~85000
  - note Line-item detail not fully legible; typically silt fence, inlet protection, etc.
- DRAINAGE
  - items
    - - item_no 605E11111
      - description 6" shallow pipe underdrains with geotextile fabric, as per plan
      - quantity ~2044
      - unit FT
      - unit_amount 10
      - total_amount ~20440
    - - item_no custom_drain_ls
      - description Drainage improvements
      - quantity 1
      - unit LS
      - unit_amount 100000
      - total_amount 100000
  - subtotal ~120440
- PAVEMENT
  - items
    - - item_no 301E56000
      - description Asphalt concrete base, PG64-22 (449)
      - quantity ~841
      - unit CY
      - unit_amount ~145.0
      - total_amount ~121945
    - - item_no 304E20000
      - description Aggregate base
      - quantity ~841
      - unit CY
      - unit_amount ~50.0
      - total_amount ~42050
    - - item_no 407E10000
      - description Tack coat
      - quantity ~456
      - unit GAL
      - unit_amount 2
      - total_amount ~912
    - - item_no 442E22100
      - description Asphalt concrete surface course, 12.5mm, Type A (449)
      - quantity ~173
      - unit CY
      - unit_amount ~185.0
      - total_amount ~31995
    - - item_no 442E22400
      - description Asphalt concrete intermediate course, 19mm, Type A (449)
      - quantity ~269
      - unit CY
      - unit_amount ~200.0
      - total_amount ~53800
    - - item_no 609E12001
      - description Combination curb and gutter, Type 2, as per plan
      - quantity ~717
      - unit FT
      - unit_amount ~35.0
      - total_amount ~25095
    - - item_no 609E31000
      - description Combination curb and gutter, Type 9
      - quantity ~280
      - unit FT
      - unit_amount ~30.0
      - total_amount ~8400
    - - item_no 609E26000
      - description Curb, Type 6
      - quantity ~779
      - unit FT
      - unit_amount ~20.0
      - total_amount ~15580
    - - item_no custom_pavement
      - description Decorative reinforced concrete pavement, 8" thick (truck apron), as per plan
      - quantity ~240
      - unit SY
      - unit_amount ~80.0
      - total_amount ~19200
  - subtotal ~302631
- WATER_WORK
  - items —
  - subtotal ~50000
  - note Line-item detail not fully legible; typically water main connections, drainage structures
- LIGHTING
  - items —
  - subtotal ~100000
  - note Traffic signal and pedestrian lighting; LS or unit costs not separately itemized in OCR
- TRAFFIC_CONTROL
  - items
    - - item_no custom_tc
      - description Traffic control devices and signage
      - quantity 1
      - unit LS
      - unit_amount 75000
      - total_amount 75000
  - subtotal ~75000
- LANDSCAPING
  - items —
  - subtotal ~20000
  - note Typical seeding, sod, planting per site plan; lump-sum estimate
- RIGHT_OF_WAY
  - items
    - - item_no custom_ag_land
      - description Agricultural land
      - quantity ~0.26
      - unit AC
      - unit_amount 20000
      - total_amount ~5200
    - - item_no custom_res_land
      - description Residential land
      - quantity ~0.07
      - unit AC
      - unit_amount 40000
      - total_amount ~2800
    - - item_no custom_row_contingency
      - description Right-of-way contingency / easements
      - quantity 1
      - unit LS
      - unit_amount 161
      - total_amount ~161
  - subtotal ~8161
- INCIDENTALS
  - items
    - - item_no 614E11000
      - description Maintaining traffic
      - quantity 1
      - unit LS
      - unit_amount 50000
      - total_amount 50000
    - - item_no 623E10000
      - description Construction layout stakes and surveying
      - quantity 1
      - unit LS
      - unit_amount 20000
      - total_amount 20000
    - - item_no 624E10000
      - description Mobilization
      - quantity 1
      - unit LS
      - unit_amount 50000
      - total_amount 50000
  - subtotal 120000
- DESIGN_SURVEY_INSPECTION
  - items
    - - item_no design_15pct
      - description Design (15% of construction subtotal)
      - quantity 1
      - unit LS
      - unit_amount ~192633
      - total_amount ~192633
    - - item_no survey
      - description Survey
      - quantity 1
      - unit LS
      - unit_amount 20000
      - total_amount 20000
    - - item_no ca_inspection
      - description Construction admin & inspection
      - quantity 1
      - unit LS
      - unit_amount 60000
      - total_amount 60000
  - subtotal ~272633

extraction_notes

confidence_levels
- dollar_totals HIGH - directly read from printed summary and rollup pages
- section_subtotals HIGH - summed from itemized costs on each estimate page
- unit_costs MEDIUM-HIGH - some read, some derived by reverse calculation
- quantities MEDIUM - extracted from 300 DPI scan with OCR degradation on small numbers
- item_descriptions HIGH - ODOT standard items or clearly labeled custom items
data_quality_issues
- Quantities are best-effort; verify against Tetra Tech native .xlsx for final precision
- Some LS items show in OCR with no unit cost or quantity; cost is the total
- Decorative/custom items not in standard ODOT tables may have slightly different labeling across pages
- Corridors omit RIGHT_OF_WAY, LIGHTING, TRAFFIC_CONTROL, LANDSCAPING sections
- Small-text unit rates (e.g., $2/gal) less reliable than large-text subtotals
recommended_next_steps
- Cross-check high-quantity items (excavation, asphalt CY) against actual site survey
- Verify Design cost is actually 12-15% (vs. fixed fee) in original spreadsheet
- Confirm whether decorative pavement (truck apron) appears on all roundabouts or is site-specific
- Clarify whether DRAINAGE LS items ($100k-$150k) include detention basin or are just site drainage
- Obtain original Tetra Tech .xlsx for definitive line-item costs; this YAML is investigative/analytical extraction

Where it connects

recordsCost estimates (OPC)

aedg/roundabouts.detail.opc.yaml · — · aedg

✎ Suggest a correction