097Apricing_Eggeman.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Competitive Selection OH|DOT097A23-2
Contract number
DOT097A23-2
Issued by
Ohio

About this file

This document is an Invitation to Bid (ITB 097-23a) for General Services for Traffic Counting, specifically a pricing matrix for Eggeman Engineering & Consulting, LLC. The contract covers traffic counting services across multiple districts, specifically Districts 1, 2, 7, 8, 3, 6, 9, 10, 5, 11, 4, and 12, with pricing structured across six different regional zones.

The contract includes comprehensive traffic counting services with detailed pricing for various count types, including counter/road tube spot counts (1-4 lanes and greater than 4 lanes), video turning movement counts, non-intrusive spot counts, and specialized services. Pricing varies by region, with costs ranging from $60 to $856.25 per unit depending on the specific type of count, such as 24-hour volume counts, axle classification, highway ramp volumes, and video/radar-based counts. Optional services include pole-mounted video turning movement counts, radar and video counts, non-motorized trail counts, and provisions for law enforcement officer support at a flat rate of $60 per hour. The contract appears to be an indefinite delivery vehicle allowing flexible traffic data collection services across multiple geographic regions.

View the file

Other files

Show all 11

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 ITB 097-23a GENERAL SERVICES FOR TRAFFIC COUNTING tc={35C95618-A385-4BEF-9483-015165381310}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

IS this "097-19" something we need to update?

COST PER COUNT MATRIX
Contractor:Eggeman Engineering & Consulting, LLCDistricts:1 & 27 & 83 & 69 & 105 & 114 & 12
Pricing for Region:123456
ItemType of CountUnitUnit CostUnit CostUnit CostUnit CostUnit CostUnit Cost
Item A1-A10 and B1-B6 are required for at least 1 regionA - Counter/Road Tube Spot Count - 1 - 4 lanes.
A124-hr. volume total floweach$72.25$72.25$83.50$83.50$72.25$83.50
A224-hr. volume, by direction (will be used for 2 lane roadways)each$111.00$111.00$128.00$128.00$111.00$128.00
A324-hr. volume, by laneeach$139.00$139.00$155.75$155.75$139.00$155.75
A448-hr. volume, by laneeach$278.00$278.00$305.75$305.75$278.00$305.75
A524-hr. axle classification, by laneeach$250.00$250.00$278.00$278.00$250.00$278.00
A648-hr. axle classification, by laneeach$390.00$390.00$428.00$428.00$390.00$428.00
A724-hr. Highway Ramp volumeeach$111.00$111.00$128.00$128.00$111.00$128.00
A848-hr. Highway Ramp volumeeach$166.75$166.75$183.50$183.50$166.75$183.50
A924-hr. Highway Ramp axle classificationeach$166.75$166.75$189.00$189.00$166.75$189.00
A1048-hr. Highway Ramp axle classificationeach$222.50$222.50$244.75$244.75$222.50$244.75
B - Counter/Road Tube Spot Count - Greater than 4 lanes.
B124-hr. volume total floweach$83.50$83.50$94.50$94.50$83.50$94.50
B224-hr. volume, by directioneach$278.00$278.00$305.75$305.75$278.00$305.75
B324-hr. volume, by laneeach$333.50$333.50$367.00$367.00$333.50$367.00
B448-hr. volume, by laneeach$556.00$556.00$611.50$611.50$556.00$611.50
B524-hr. axle classification, by laneeach$500.50$500.50$550.75$550.75$500.50$550.75
B648-hr. axle classification, by laneeach$778.25$778.25$856.25$856.25$778.25$856.25
C - Video Turning Movement Count - optional
C1aPole mounted video turning movementhourly rate$94.50$94.50$116.75$116.75$94.50$116.75
C1bPole mounted video turning movementdaily rate$1,556.50$1,556.50$1,667.75$1,667.75$1,556.50$1,667.75
C2aPole mounted video turning movement - roundabouthourly rate$151.75$151.75$174.00$174.00$151.75$174.00
C2bPole mounted video turning movement - roundaboutdaily rate$2,550.00$2,550.00$2,925.00$2,925.00$2,550.00$2,925.00
D - Non-Intrusive Spot Count - optional
D1aTrailer mounted radarhourly rate
D1bTrailer mounted radardaily rate
D1cTrailer mounted radarweekly rate
D1dTrailer mounted radarmonthly rate
D2aPole mounted radarhourly rate$60.00$60.00$65.00$65.00$60.00$65.00
D2bPole mounted radardaily rate$725.00$725.00$730.00$730.00$725.00$730.00
D2cPole mounted radarweekly rate$2,550.00$2,550.00$2,600.00$2,600.00$2,550.00$2,600.00
D2dPole mounted radarmonthly rate$5,100.00$5,100.00$5,200.00$5,200.00$5,100.00$5,200.00
D3aTrailer mounted videohourly rate
D3bTrailer mounted videodaily rate
D3cTrailer mounted videoweekly rate
D3dTrailer mounted videomonthly rate
D4aPole mounted videohourly rate$75.00$75.00$85.00$85.00$75.00$85.00
D4bPole mounted videodaily rate$1,025.00$1,025.00$1,125.00$1,125.00$1,025.00$1,125.00
D4cPole mounted videoweekly rate$3,950.00$3,950.00$4,325.00$4,325.00$3,950.00$4,325.00
D4dPole mounted videomonthly rate$8,700.00$8,700.00$9,525.00$9,525.00$8,700.00$9,525.00
D5aVideo count without processing - one camera setuphourly rate
D5bVideo count without processing - one camera setupdaily rate
D5cVideo count without processing - one camera setupweekly rate
D5dVideo count without processing - one camera setupmonthly rate
D6aNon-motorized trail or spot counthourly rate$71.50$71.50$81.75$81.75$71.50$81.75
D6bNon-motorized trail or spot countdaily rate$1,025.00$1,025.00$1,125.00$1,125.00$1,025.00$1,125.00
D6cNon-motorized trail or spot countweekly rate$2,550.00$2,550.00$2,750.00$2,750.00$2,550.00$2,750.00
D6dNon-motorized trail or spot countmonthly rate$6,125.00$6,125.00$6,325.00$6,325.00$6,125.00$6,325.00
E - AI/Machine Learning Count Count - optional
E1aAI/Machine Learning Counthourly rate
E1bAI/Machine Learning Countdaily rate
E1cAI/Machine Learning Countweekly rate
E1dAI/Machine Learning Countmonthly rate
E1aNon-motorized trail or spot counthourly rate
E1bNon-motorized trail or spot countdaily rate
E1cNon-motorized trail or spot countweekly rate
E1dNon-motorized trail or spot countmonthly rate
E2aNon-motorized intersection/turning movement counthourly rate
E2bNon-motorized intersection/turning movement countdaily rate
E2cNon-motorized intersection/turning movement countweekly rate
E2dNon-motorized intersection/turning movement countmonthly rate
F - LEO
F1Law Enforcement Officerhourly rate$60.00$60.00$60.00$60.00$60.00$60.00
G - Special Services (add additional lines if needed) - optional
G1(enter name of special service)(Enter unit)
G2(enter name of special service)(Enter unit)
G3(enter name of special service)(Enter unit)

IS this "097-19" something we need to update?

PID 108445

File details come from the government source that posted it. Updated .