METRO_RTA_LPA.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- Locally Preferred Alternative (LPA)
- Solicitation number
- 2026-05
- Issued by
- Summit County, Akron City, Ohio
About this file
This is a cost model template for METRO RTA's Locally Preferred Alternative (LPA) Study for Bus Rapid Transit (BRT) corridors in Summit County, Ohio. The study will evaluate potential BRT investments across the region to identify corridors with the greatest impact on travel times, reliability, and access to opportunity. The comprehensive analysis will encompass ridership demand forecasting, travel time savings evaluation, capital and operating cost estimation, land use pattern analysis, and community impact assessment. The project includes eleven primary tasks: Project Management & Administration, Data Collection & Existing Conditions Analysis, Ridership Forecasting & Travel Demand Modeling, Alternatives Development & Screening, Capital & Operating Cost Estimates, Land Use/Equity & Community Impact Analysis, Traffic Operations and Queue Jump Analysis, Environmental Documentation (NEPA readiness-level analysis), Public & Stakeholder Engagement, Financial Analysis & Funding Strategy (FTA CIG readiness), and LPA Recommendation & Adoption Support. Additional optional services are available, including corridor-level concept design to 15%, additional environmental analysis, enhanced public engagement, and grant application support. The deliverable will result in formal adoption of a Locally Preferred Alternative identifying the recommended corridor and defining the scope of initial BRT investment to support subsequent project development phases including environmental review, detailed design, and federal FTA Capital Investment Grant applications.
The cost model is structured as a task-based Excel template with editable labor rate inputs and hourly billing by nine labor categories: Principal ($230/hour), Project Manager ($195/hour), Senior Planner ($170/hour), Transportation Modeler ($180/hour), Engineer ($175/hour), Environmental Specialist ($165/hour), Public Engagement Lead ($160/hour), GIS Analyst ($135/hour), and Admin Support ($95/hour). The model allows for input of direct expenses and subconsultant costs by task, with optional fields for overhead rate, profit/fee rate, and contingency rate calculations. The fee structure is declared as a lump sum contract type. This pricing proposal template enables responding firms to develop comprehensive cost estimates for the LPA study scope, with all costs presented in USD. The project is designed to establish technical justification and regional consensus needed for transformative transit improvements that strengthen the regional economy, support workforce access, and enhance quality of life for Summit County residents.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Locally_Preferred_Alternative_(LPA).pdf | ||
| METRO_RTA_LPA.xlsx | XLSX spreadsheet | |
| EX24059_Nelson_Nygaard_East_Colfax_final.doc.pdf | ||
| Ice_form_-_LPA.pdf | ||
| ICE_2025_Arterial_BRT_Plan_Update_Planning_Support_-_signed.pdf | ||
| Davis-SL_Env_Des_Req_ICE_030123.pdf | ||
| Ice_form.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
Cover
| METRO RTA – LPA Study (BRT Corridors) – Price Proposal Cost Model |
| Excel cost model template (task-based) with formulas. Blue text cells are editable inputs. |
| Firm Name: | |
| Prepared By: | |
| Date: | 2026-02-25 |
| Instructions: |
| 1) Enter/adjust hourly rates on the 'Rates' tab. |
| 2) Enter hours by task and labor category on 'Task Budget'. |
| 3) Enter direct expenses and subconsultant costs per task (if any). |
| 4) Review totals and fee calculations on 'Summary'. |
Inputs Model Inputs / Assumptions
| Assumption | Value | Units/Notes | Source/Comment |
| Overhead rate | 0.0% | Applied to labor subtotal (optional) | |
| Profit / fee rate | 0.0% | Applied after overhead (optional) | |
| Contingency rate | 0.0% | Applied to subtotal before final total (optional) | |
| Travel included in Direct Expenses? | Yes | Yes/No (informational) | |
| Currency | USD | Model currency |
Rates
| Labor Rate Schedule (Editable) | |||
| Labor Category | Hourly Rate | Notes | Billing Unit |
| Principal | $230.00 | Hour | |
| Project Manager | $195.00 | Hour | |
| Senior Planner | $170.00 | Hour | |
| Transportation Modeler | $180.00 | Hour | |
| Engineer | $175.00 | Hour | |
| Environmental Specialist | $165.00 | Hour | |
| Public Engagement Lead | $160.00 | Hour | |
| GIS Analyst | $135.00 | Hour | |
| Admin Support | $95.00 | Hour | |
| TOTAL LABOR (calculated on Summary tab) |
Task Budget
| Task No. | Task Description | Principal | Project Manager | Senior Planner | Transportation Modeler | Engineer | Environmental Specialist | Public Engagement Lead | GIS Analyst | Admin Support | Labor Cost | Direct Expenses | Subconsultants | Total Task Cost |
| Hourly Rate | ||||||||||||||
| 1 | Project Management & Administration | |||||||||||||
| 2 | Data Collection & Existing Conditions Analysis | |||||||||||||
| 3 | Ridership Forecasting & Travel Demand Modeling | |||||||||||||
| 4 | Alternatives Development & Screening | |||||||||||||
| 5 | Capital & Operating Cost Estimates | |||||||||||||
| 6 | Land Use, Equity & Community Impact Analysis | |||||||||||||
| 7 | Traffic Operations, TSP & Queue Jump Analysis | |||||||||||||
| 8 | Environmental Documentation (NEPA readiness-level analysis) | |||||||||||||
| 9 | Public & Stakeholder Engagement | |||||||||||||
| 10 | Financial Analysis & Funding Strategy (FTA CIG readiness) | |||||||||||||
| 11 | LPA Recommendation & Adoption Support | |||||||||||||
| TOTAL |
Optional
| Optional Add Services (Enter costs only if proposing) | ||||
| Optional Service | Description | Labor Cost | Direct Expenses | Total Optional Cost |
| Corridor-level Concept Design to ~15% | - | - | - | |
| Additional Environmental Analysis | - | - | - | |
| Additional Public Engagement | - | - | - | |
| Grant Application Support | - | - | - | |
| Other | - | - | - | |
| TOTAL OPTIONAL | - |
Summary
| Cost Summary | ||
| Category | Amount | Notes |
| Total Labor | - | From Task Budget |
| Total Direct Expenses | - | From Task Budget |
| Total Subconsultants | - | From Task Budget |
| Base Subtotal (Tasks) | - | Labor + Direct + Subconsultants |
| Optional Services (if any) | - | From Optional tab |
| Subtotal (Base + Optional) | - | Used for fee/contingency |
| Overhead | - | Overhead rate from Inputs |
| Profit / Fee | - | Profit rate from Inputs |
| Subtotal incl. OH + Fee | - | |
| Contingency | - | Contingency rate from Inputs |
| TOTAL PROPOSED CONTRACT AMOUNT | - | Final total |
| Fee Structure Declaration | ||
| Fee Type | Select | |
| Contract Type | Lump Sum |
File details come from the government source that posted it. Updated .