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
METRO RTA LPA Study - Price Proposal Cost Model
This file is an Excel cost model template prepared for METRO RTA (Metropolitan Regional Transit Authority) in Ohio for a Locally Preferred Alternative (LPA) study evaluating potential Bus Rapid Transit (BRT) corridors across Summit County. The project encompasses a comprehensive analysis of ridership demand, travel time savings, capital and operating costs, land use patterns, and community impacts. The study 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/TSP & Queue Jump Analysis, Environmental Documentation (NEPA readiness-level analysis), Public & Stakeholder Engagement, Financial Analysis & Funding Strategy (FTA CIG readiness), and LPA Recommendation & Adoption Support. The model also provides for optional add services including corridor-level concept design to 15%, additional environmental analysis, additional public engagement, and grant application support. The cost model template includes a non-mandatory pre-bid meeting on August 5, 2025, with the last day for questions on August 15, 2025, at 5:00 pm, and bid opening scheduled for August 26, 2025, at 2:00 pm. The contract will be awarded as a lump sum agreement.
The pricing model contains editable labor rate schedules with hourly rates ranging from $95.00 for Admin Support to $230.00 for Principal positions, including Project Manager ($195.00), Senior Planner ($170.00), Transportation Modeler ($180.00), Engineer ($175.00), Environmental Specialist ($165.00), Public Engagement Lead ($160.00), and GIS Analyst ($135.00). Proposing firms must enter hours by task and labor category, direct expenses, and subconsultant costs to calculate base subtotals. The model allows for optional overhead rates, profit/fee rates, and contingency rates applied to the labor subtotal and final contract amount. Travel expenses are included within direct expenses, and the model is configured in U.S. dollars. The summary tab calculates total labor, direct expenses, subconsultants, and applies optional overhead, profit, and contingency calculations to arrive at the final proposed contract amount. The project is funded through METRO RTA as part of Summit County's transit improvement initiative to advance transformative transit improvements and support the FTA Capital Investment Grant program pathway.
View the file
Other files
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 .