13097 Form A2.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- 13097-0-2025-BP
- Issued by
- Dane County, Mattoon Village, Wisconsin
About this file
The document is a Form A2 Excel spreadsheet for the City of Madison's Bus Rapid Transit (BRT) TIFIA project, specifically an Asset Scan template designed to capture workforce allocation and hourly rates across different professional categories. The form provides a structured method for detailing staffing percentages and associated costs for administrative, real estate, site layout and programming, finance, and support technician roles, though in this instance the form appears to be largely incomplete with most sections showing zero values.
While the spreadsheet appears to be a planning or budgeting tool for the Madison Bus Rapid Transit project, the current version lacks specific personnel details or hourly rate information. The form's structure suggests it is intended to help document workforce composition and labor costs for a potential TIFIA (Transportation Infrastructure Finance and Innovation Act) funded transportation infrastructure project, but no substantive data has been entered to provide meaningful insights into the actual staffing plan or budget allocation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 13097 Addendum 2.pdf | ||
| 13097 Evaluation Report.pdf | ||
| 13097 Addendum 1.pdf | ||
| 13097-0-2025-BP RFP.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
Sheet1
| City of Madison |
| 13097-0-2025-BP |
| Madison Bus Rapid Transit TIFIA Putting Assets to Work Asset Scan |
| Form A2 |
| Directions: Please enter in the position title, percentage of work that position will do for the category, and hourly rate. |
| Example |
| Position Title | Percentage of Work for Administrative | Hourly Rate | Weighted Total |
| Account Executive | 40% | $ 100.00 | $ 40.00 |
| Director | 35% | $ 125.00 | $ 43.75 |
| Partner | 20% | $ 150.00 | $ 30.00 |
| Sr. Partner | 5% | $ 200.00 | $ 10.00 |
| 0% | $ - 0 | $ - 0 | |
| Total | 100% | $ 123.75 | |
| Administrative | |||
| Position Title | Percentage of Work for Administrative | Hourly Rate | Weighted Total |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| Total | $ - 0 |
| Real Estate Professional | |||
| Position Title | Percentage of Work for Real Estate Professional | Hourly Rate | Weighted Total |
| 50% | $ - 0 | $ - 0 | |
| 25% | $ - 0 | $ - 0 | |
| 25% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| Total | $ - 0 | ||
| Site Layout and Programming Professional | |||
| Position Title | Percentage of Work for Site Layoutand Programming Professional | Hourly Rate | Weighted Total |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| Weighted Total | $ - 0 | ||
| Finance Professional | |||
| Position Title | Percentage of Work for Finance Professional | Hourly Rate | Weighted Total |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| Total | $ - 0 | ||
| Support Technician | |||
| Position Title | Percentage of Work for Support Technician | Hourly Rate | Weighted Total |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| 0% | $ - 0 | $ - 0 | |
| Total | $ - 0 |
File details come from the government source that posted it. Updated .