HDR_557pricing_2025.xlsx
XLSX spreadsheet 191 KB Posted
- Attached to
- Competitive Selection OH|DOT55726-1
- Contract number
- DOT55726-1
- Issued by
- Ohio
About this file
This document is a cost proposal summary for a Transit Planning and Research Request for Proposal (RFP), involving multiple consulting firms including HDR, Four Nines Technologies, and Foursquare ITP. The proposal appears to be for a state-level transportation planning project, likely for the Ohio Department of Transportation (ODOT), with a proposal date of May 14, 2025.
The contract encompasses seven primary task areas: Contract Management, Research, Planning, Alternative Fuels Operations, Data and Reporting, Project Management, and Governors Apportionment Support. The total authorized cost for the project is $621,800, with HDR presenting the most comprehensive proposal. Key pricing components include direct labor rates ranging from $36.73 to $112.19 per hour, overhead rates between 142.44% and 159.98%, and a net fee percentage capped at 11%. The proposal includes detailed cost breakdowns for tasks such as developing best practices reports for rural transit technology, regional transit planning, electric vehicle replacement implementation, GTFS development for transit agencies, and FTA-compliant procurement support.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 557-26_Score_Sheet.xlsx | XLSX spreadsheet | |
| HDR_Affirmation_and_Disclosure.pdf | ||
| 557-26.pdf | ||
| Signature_-_2025-07-11T102708.869.pdf | ||
| HDR_ODOT_557-26_Planning_and_Research.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
Labor Rates_HDR_Cost Proposal
| RFP: Transit Planning and Research | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Planning and Research | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Planning and Research | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | HDR | Consultant: | HDR | Consultant: | HDR | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Milage |
tc={E92F1BAE-17FA-4BBC-AC43-CE0423209E15}: [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:
| Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.) | Airfare | Printing/Copies | Hotel | Meals and Travel Incidentals | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 157.94% |
tc={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [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:
| Complete as a percentage rate | Modification No. | 0 | ||||||
| PID No. | Assigned Staff Positions & Associated Rates | PID No. | 0 | Cost of Money: | 0.45% |
tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [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:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 11% |
tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [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:
| Complete as a percentage that goes no higher than 11.0% | Proposal Date | 5/14/25 | ||
| Staff Position | Project Manager |
tc={375C69B9-5530-4600-9629-661986A5ABA9}: [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:
| Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.) | Principal | QA/QC Lead | Senior Transit/Environmental Planner | Transit Planner 2 | Transit Planner | Senior Project Engineer | Engineer | GIS Technician | Clerical | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: |
| Task Description | Direct Labor Rate | $82.10 |
tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [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:
Insert employee's labor rate excluding overhead rate $112.19 $72.00 $62.20 $48.00 $39.00 $103.06 $54.00 $41.00 $36.73 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.70 tc={4D6A823F-DE15-4A68-80CC-679AC9DC9756}: [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:
Insert unit cost related to the direct cost category tc={375C69B9-5530-4600-9629-661986A5ABA9}: [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:
Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)
tc={5F176C5F-5E77-4D5C-8040-05720EA7F21B}: [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:
Complete as a percentage rate tc={ADC08D57-F31B-447B-91CD-2E0A0644D19B}: [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:
Insert employee's labor rate excluding overhead rate tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [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:
Complete as a percentage rate, for example 0.08% tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [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:
| Complete as a percentage that goes no higher than 11.0% | $500.00 | $0.12 | $160.00 | $80.00 | ||||||||||||||||||||||||||||||
| AUTHORIZED TASKS: | AUTHORIZED TASKS: | AUTHORIZED TASKS: | ||||||||||||||||||||||||||||||||
| Known Tasks | Known Tasks | Known Tasks | ||||||||||||||||||||||||||||||||
| Staff Hours | Units | Units | Units | Units | Units | Units | Units | Units | Units | $ | ||||||||||||||||||||||||
| Task 1: Contract Management | Task 1: Contract Management | Task 1: Contract Management | ||||||||||||||||||||||||||||||||
| Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements | 120 | 40 | 20 | 82 | 262 | $20,880 | Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements | $79.69 | 262 | $20,880 | $32,978 | $94 | $1,050 | $0 | $5,971 | $60,974 | Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements | 1500 | $1,050 | |||||||||||||||
| TOTAL Task 1 | 120 | 40 | 20 | 82 | 0 | 0 | 0 | 0 | 0 | 0 | 262 | $20,880 | TOTAL Task 1 | $79.69 | 262 | $20,880 | $32,978 | $94 | $1,050 | $0 | $5,971 | $60,974 | TOTAL Task 1 | 1500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $1,050 |
| Task 2: Research | Task 2: Research | Task 2: Research | |||||||||||||||||||||||||||||||
| Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | 50 | 8 | 4 | 65 | 65 | 65 | 16 | 16 | 0 | 4 | 293 | $17,648 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | $60.23 | 293 | $17,648 | $27,874 | $80 | $2,690 | $55,685 | $5,047 | $109,025 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | 1500 | 2 | 2 | 4 | $2,690 | |||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 2 | 50 | 8 | 4 | 65 | 65 | 65 | 16 | 16 | 0 | 4 | 293 | $17,648 | TOTAL Task 2 | $60.23 | 293 | $17,648 | $27,874 | $80 | $2,690 | $55,685 | $5,047 | $109,025 | TOTAL Task 2 | 1500 | 2 | 0 | 2 | 4 | 0 | 0 | 0 | 0 | $2,690 |
| Task 3: Planning | Task 3: Planning | Task 3: Planning | ||||||||||||||||||||||||||||||||
| Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | 120 | 8 | 8 | 90 | 110 | 120 | 4 | 4 | 16 | 8 | 488 | $28,462 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | $58.32 | 488 | $28,462 | $44,952 | $129 | $2,472 | $0 | $8,139 | $84,154 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | 2000 | 1 | 100 | 2 | 3 | $2,472 | |||||
| Subtask 2: Regional Transit Plan - Service Operations Planning | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | Subtask 2: Regional Transit Plan - Service Operations Planning | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $50,907 | $0 | $50,907 | Subtask 2: Regional Transit Plan - Service Operations Planning | $0 | ||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 3 | 120 | 8 | 8 | 90 | 110 | 120 | 4 | 4 | 16 | 8 | 488 | $28,462 | TOTAL Task 3 | $58.32 | 488 | $28,462 | $44,952 | $129 | $2,472 | $50,907 | $8,139 | $135,061 | TOTAL Task 3 | 2000 | 1 | 100 | 2 | 3 | 0 | 0 | 0 | 0 | $2,472 |
| Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | |||||||||||||||||||||||||||||||
| Subtask 1: Implementation Plan for Electric Vehicle Replacement | 120 | 16 | 4 | 100 | 120 | 40 | 12 | 124 | 16 | 552 | $33,995 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | $61.59 | 552 | $33,995 | $53,692 | $154 | $1,760 | $0 | $9,722 | $99,324 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | 1000 | 1 | 2 | 3 | $1,760 | ||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 4 | 120 | 16 | 4 | 100 | 120 | 40 | 12 | 124 | 0 | 16 | 552 | $33,995 | TOTAL Task 4 | $61.59 | 552 | $33,995 | $53,692 | $154 | $1,760 | $0 | $9,722 | $99,324 | TOTAL Task 4 | 1000 | 1 | 0 | 2 | 3 | 0 | 0 | 0 | 0 | $1,760 |
| Task 5: Data and Reporting | Task 5: Data and Reporting | Task 5: Data and Reporting | |||||||||||||||||||||||||||||||
| Subtask 1: GTFS Development for 3 Transit Agencies | 12 | 0 | 2 | 0 | 24 | 0 | 0 | 0 | 0 | 4 | 42 | $2,428 | Subtask 1: GTFS Development for 3 Transit Agencies | $57.81 | 42 | $2,428 | $3,835 | $11 | $0 | $35,903 | $694 | $42,871 | Subtask 1: GTFS Development for 3 Transit Agencies | $0 | |||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 5 | 12 | 0 | 2 | 0 | 24 | 0 | 0 | 0 | 0 | 4 | 42 | $2,428 | TOTAL Task 5 | $57.81 | 42 | $2,428 | $3,835 | $11 | $0 | $35,903 | $694 | $42,871 | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 6: Project Management | Task 6: Project Management | Task 6: Project Management | ||||||||||||||||||||||||||||||||
| Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | 50 | 4 | 8 | 130 | 60 | 40 | 16 | 8 | 4 | 8 | 328 | $20,195 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | $61.57 | 328 | $20,195 | $31,895 | $91 | $0 | $0 | $5,775 | $57,956 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | $0 | ||||||||||
| Subtask 2: Section 106 & Cultural Resources | 16 | 2 | 8 | 20 | 80 | 30 | 16 | 8 | 4 | 184 | $10,613 | Subtask 2: Section 106 & Cultural Resources | $57.68 | 184 | $10,613 | $16,762 | $48 | $1,180 | $0 | $3,035 | $31,638 | Subtask 2: Section 106 & Cultural Resources | 1000 | 2 | 2 | $1,180 | ||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 6 | 66 | 6 | 16 | 150 | 140 | 70 | 32 | 16 | 8 | 8 | 512 | $30,808 | TOTAL Task 6 | $60.17 | 512 | $30,808 | $48,657 | $139 | $1,180 | $0 | $8,810 | $89,595 | TOTAL Task 6 | 1000 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | $1,180 |
| Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | |||||||||||||||||||||||||||||||
| Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | 60 | 16 | 8 | 100 | 100 | 100 | 4 | 4 | 8 | 400 | $23,139 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | $57.85 | 400 | $23,139 | $36,546 | $105 | $860 | $17,685 | $6,617 | $84,952 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | 1000 | 2 | $860 | ||||||||
| TOTAL Task 7 | 60 | 16 | 8 | 100 | 100 | 100 | 4 | 4 | 0 | 8 | 400 | $23,139 | TOTAL Task 7 | $57.85 | 400 | $23,139 | $36,546 | $105 | $860 | $17,685 | $6,617 | $84,952 | TOTAL Task 7 | 1000 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | $860 |
| TOTAL Known Tasks | 548 | 94 | 62 | 587 | 559 | 395 | 68 | 164 | 24 | 48 | 2549 | $157,360 | TOTAL Known Tasks | $61.73 | $2,549 | $157,360 | $248,535 | $712 | $10,012 | $160,180 | $45,002 | $621,800 | TOTAL Known Tasks | 8000 | 4 | 100 | 8 | 14 | 0 | 0 | 0 | 0 | $10,012 |
| . |
| Unknown Tasks | Unknown Tasks | Unknown Tasks | |||||||||||||||||||||||||||||||
| Task 1: | Task 1: | Task 1: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 1 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: | Task 2: | Task 2: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 2 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 3: | Task 3: | Task 3: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 3 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 4: | Task 4: | Task 4: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 4 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 5: | Task 5: | Task 5: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TOTAL Task 5 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Unknown Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 $0.00
| Future Tasks Section | Future Tasks Section | Future Tasks Section | |||||||||||||||||||||||||||||||
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00
| Future Tasks Section | Future Tasks Section | Future Tasks Section | |||||||||||||||||||||||||||||||
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00
TOTAL AUTHORIZED PARTS TOTAL AUTHORIZED PARTS $61.73 2549 $157,360.18 $248,534.67 $712.05 $10,012.00 $160,179.97 $45,001.55 $621,800.42
IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS
GRAND TOTAL GRAND TOTAL
&9&P of &N
FourNines_Costs
| RFP: Transit Planning and Research | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Planning and Research | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Planning and Research | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | Four Nines Technologies | Consultant: | Four Nines Technologies | Consultant: | Four Nines Technologies | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Milage |
tc={B275337C-3163-4598-8114-F49E06A3ACFC}: [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:
| Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.) | Airfare | Printing/Copies | Hotel | Meals and Travel Incidentals | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 156.52% |
tc={F170F91B-08A3-4E18-A46D-C44516DA32F6}: [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:
| Complete as a percentage rate | Modification No. | 0 | ||||||
| PID No. | Assigned Staff Positions & Associated Rates | PID No. | 0 | Cost of Money: | 0.16% |
tc={EBFF8EC0-5C77-4165-A954-FB1BAD2CEC33}: [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:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 11% |
tc={2847D6EA-33D9-420B-BA7C-57A35B19BE62}: [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:
| Complete as a percentage that goes no higher than 11.0% | Proposal Date | 5/14/25 | ||
| Staff Position | Project Manager |
tc={DDC6EEB8-645D-4EE8-A2C9-41F54E24524F}: [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:
| Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.) | Deputy Project Manager | Principal | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: | ||
| Task Description | Direct Labor Rate | $74.04 |
tc={C563293C-89D3-48C8-9B4B-51CBD518B6C0}: [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:
Insert employee's labor rate excluding overhead rate $68.78 $104.45 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.70 tc={2FFA0F67-0930-4691-87F7-B421EE763168}: [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:
Insert unit cost related to the direct cost category tc={DDC6EEB8-645D-4EE8-A2C9-41F54E24524F}: [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:
Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)
tc={F170F91B-08A3-4E18-A46D-C44516DA32F6}: [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:
Complete as a percentage rate tc={C563293C-89D3-48C8-9B4B-51CBD518B6C0}: [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:
Insert employee's labor rate excluding overhead rate tc={EBFF8EC0-5C77-4165-A954-FB1BAD2CEC33}: [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:
Complete as a percentage rate, for example 0.08% tc={2847D6EA-33D9-420B-BA7C-57A35B19BE62}: [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:
| Complete as a percentage that goes no higher than 11.0% | $500.00 | $0.12 | $160.00 | $80.00 | ||||||||||||||||||||||||||||||
| AUTHORIZED TASKS: | AUTHORIZED TASKS: | AUTHORIZED TASKS: | ||||||||||||||||||||||||||||||||
| Known Tasks | Known Tasks | Known Tasks | ||||||||||||||||||||||||||||||||
| Staff Hours | Units | Units | Units | Units | Units | Units | Units | Units | Units | $ | ||||||||||||||||||||||||
| Task 1: Contract Management | Task 1: Contract Management | Task 1: Contract Management | ||||||||||||||||||||||||||||||||
| Subtask 1: Management | 0 | $0 | Subtask 1: Management | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Management | $0 | ||||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 1 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 2: Research | Task 2: Research | Task 2: Research | |||||||||||||||||||||||||||||||
| Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | 40 | 180 | 40 | 260 | $19,520 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | $75.08 | 260 | $19,520 | $30,553 | $30 | $0 | $0 | $5,582 | $55,685 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | $0 | ||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 2 | 40 | 180 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 260 | $19,520 | TOTAL Task 2 | $75.08 | 260 | $19,520 | $30,553 | $30 | $0 | $0 | $5,582 | $55,685 | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 3: Planning | Task 3: Planning | Task 3: Planning | ||||||||||||||||||||||||||||||||
| Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | 0 | $0 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | $0 | ||||||||||||||||||||
| Subtask 2: Regional Transit Plan - Service Operations Planning | 0 | $0 | Subtask 2: Regional Transit Plan - Service Operations Planning | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: Regional Transit Plan - Service Operations Planning | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 3 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | |||||||||||||||||||||||||||||||
| Subtask 1: Implementation Plan for Electric Vehicle Replacement | 0 | $0 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | $0 | |||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 4 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 5: Data and Reporting | Task 5: Data and Reporting | Task 5: Data and Reporting | |||||||||||||||||||||||||||||||
| Subtask 1: GTFS Development for 3 Transit Agencies | 0 | $0 | Subtask 1: GTFS Development for 3 Transit Agencies | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: GTFS Development for 3 Transit Agencies | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 5 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 6: Project Management | Task 6: Project Management | Task 6: Project Management | ||||||||||||||||||||||||||||||||
| Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | 0 | $0 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | $0 | ||||||||||||||||||||
| Subtask 2: Section 106 & Cultural Resources | 0 | $0 | Subtask 2: Section 106 & Cultural Resources | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: Section 106 & Cultural Resources | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 6 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | |||||||||||||||||||||||||||||||
| Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | 24 | 40 | 16 | 80 | $6,199 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | $77.49 | 80 | $6,199 | $9,703 | $10 | $0 | $0 | $1,773 | $17,685 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | $0 | ||||||||||||||||
| TOTAL Task 7 | 24 | 40 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80 | $6,199 | TOTAL Task 7 | $77.49 | 80 | $6,199 | $9,703 | $10 | $0 | $0 | $1,773 | $17,685 | TOTAL Task 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| TOTAL Known Tasks | 64 | 220 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 340 | $25,719 | TOTAL Known Tasks | $75.65 | $340 | $25,719 | $40,256 | $40 | $0 | $0 | $7,355 | $73,371 | TOTAL Known Tasks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| . |
| Unknown Tasks | Unknown Tasks | Unknown Tasks | |||||||||||||||||||||||||||||||
| Task 1: | Task 1: | Task 1: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 1 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: | Task 2: | Task 2: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 2 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 3: | Task 3: | Task 3: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 3 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 4: | Task 4: | Task 4: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 4 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 5: | Task 5: | Task 5: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TOTAL Task 5 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Unknown Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Unknown Tasks 0 0 0 0 0 0 0 0 0 $0.00
| Future Tasks Section | Future Tasks Section | Future Tasks Section | |||||||||||||||||||||||||||||||
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00
| Future Tasks Section | Future Tasks Section | Future Tasks Section | |||||||||||||||||||||||||||||||
| Task Name | Task Name | Task Name | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
Total - Future Tasks 0 0 0 0 0 0 0 0 0 0 0 $0.00 Total - Future Tasks ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total - Future Tasks 0 0 0 0 0 0 0 0 0 $0.00
TOTAL AUTHORIZED PARTS TOTAL AUTHORIZED PARTS $75.65 340 $25,719.36 $40,255.94 $40.12 $0.00 $0.00 $7,355.17 $73,370.60
IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS
GRAND TOTAL GRAND TOTAL
&9&P of &N
Foursquare_Costs
| RFP: Transit Planning and Research | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Planning and Research | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Planning and Research | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | Foursquare ITP | Consultant: | Foursquare ITP | Consultant: | Foursquare ITP | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Milage |
tc={AA6BC96F-B2CC-4996-AD86-338C49CC6B41}: [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:
| Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.) | Airfare | Printing/Copies | Hotel | Meals and Travel Incidentals | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 142.44% |
tc={0FB72B70-9C97-4EEC-B8FB-F6F041E639AA}: [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:
| Complete as a percentage rate | Modification No. | 0 | ||||||
| PID No. | Assigned Staff Positions & Associated Rates | PID No. | 0 | Cost of Money: | 0.10% |
tc={D3917E88-0B0C-481A-8F7B-E5C3A0449E6F}: [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:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 11% |
tc={FE9D4A1C-B169-490E-834F-82B6511D8F07}: [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:
| Complete as a percentage that goes no higher than 11.0% | Proposal Date | 5/14/25 | ||
| Staff Position | Senior Advisor |
tc={CCBB5DC5-0F66-4B2B-86DD-69EB063A9671}: [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:
| Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.) | Deputy Project Manager | Principal | QA/QC Lead | Senior Project Engineer | Senior Transit Planner | Transportation Planner 2 | Senior Planner / Data Scientist | Planner / Data Scientist | Junior Planner / Data Scientist | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: |
| Task Description | Direct Labor Rate | $120.19 |
tc={CD5CB978-EC04-4D02-8838-FBDB11AEE082}: [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:
Insert employee's labor rate excluding overhead rate $80.10 $69.70 $67.20 $54.20 $46.10 $37.80 $85.10 $66.30 $58.90 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.70 tc={32B21C9A-513A-4E4B-A214-970E6F966BFD}: [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:
Insert unit cost related to the direct cost category tc={CCBB5DC5-0F66-4B2B-86DD-69EB063A9671}: [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:
Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)
tc={0FB72B70-9C97-4EEC-B8FB-F6F041E639AA}: [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:
Complete as a percentage rate tc={CD5CB978-EC04-4D02-8838-FBDB11AEE082}: [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:
Insert employee's labor rate excluding overhead rate tc={D3917E88-0B0C-481A-8F7B-E5C3A0449E6F}: [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:
Complete as a percentage rate, for example 0.08% tc={FE9D4A1C-B169-490E-834F-82B6511D8F07}: [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:
| Complete as a percentage that goes no higher than 11.0% | $500.00 | $0.12 | $160.00 | $80.00 | ||||||||||||||||||||||||||||||
| AUTHORIZED TASKS: | AUTHORIZED TASKS: | AUTHORIZED TASKS: | ||||||||||||||||||||||||||||||||
| Known Tasks | Known Tasks | Known Tasks | ||||||||||||||||||||||||||||||||
| Staff Hours | Units | Units | Units | Units | Units | Units | Units | Units | Units | $ | ||||||||||||||||||||||||
| Task 1: Contract Management | Task 1: Contract Management | Task 1: Contract Management | ||||||||||||||||||||||||||||||||
| Subtask 1: Management | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | Subtask 1: Management | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Management | $0 | ||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 1 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 2: Research | Task 2: Research | Task 2: Research | |||||||||||||||||||||||||||||||
| Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | 0 | $0 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach | $0 | |||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 2 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 3: Planning | Task 3: Planning | Task 3: Planning | ||||||||||||||||||||||||||||||||
| Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | 0 | $0 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations | 0 | 0 | 0 | 0 | $0 | ||||||||||||||||
| Subtask 2: Regional Transit Plan - Service Operations Planning | 40 | 8 | 8 | 60 | 60 | 80 | 0 | 0 | 20 | 8 | 284 | $18,775 | Subtask 2: Regional Transit Plan - Service Operations Planning | $66.11 | 284 | $18,775 | $26,743 | $19 | $0 | $0 | $5,369 | $50,907 | Subtask 2: Regional Transit Plan - Service Operations Planning | $0 | ||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 3 | 40 | 8 | 8 | 60 | 60 | 80 | 0 | 0 | 20 | 8 | 284 | $18,775 | TOTAL Task 3 | $66.11 | 284 | $18,775 | $26,743 | $19 | $0 | $0 | $5,369 | $50,907 | TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | Task 4: Alternative Fuels Operations | |||||||||||||||||||||||||||||||
| Subtask 1: Implementation Plan for Electric Vehicle Replacement | 0 | $0 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: Implementation Plan for Electric Vehicle Replacement | $0 | |||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 4 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 5: Data and Reporting | Task 5: Data and Reporting | Task 5: Data and Reporting | |||||||||||||||||||||||||||||||
| Subtask 1: GTFS Development for 3 Transit Agencies | 40 | 8 | 8 | 40 | 40 | 35 | 0 | 0 | 8 | 4 | 183 | $13,242 | Subtask 1: GTFS Development for 3 Transit Agencies | $72.36 | 183 | $13,242 | $18,861 | $13 | $0 | $0 | $3,787 | $35,903 | Subtask 1: GTFS Development for 3 Transit Agencies | $0 | |||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | ||||||||||||||||||||
| TOTAL Task 5 | 40 | 8 | 8 | 40 | 40 | 35 | 0 | 0 | 8 | 4 | 183 | $13,242 | TOTAL Task 5 | $72.36 | 183 | $13,242 | $18,861 | $13 | $0 | $0 | $3,787 | $35,903 | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 6: Project Management | Task 6: Project Management | Task 6: Project Management | ||||||||||||||||||||||||||||||||
| Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | 0 | $0 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency | $0 | ||||||||||||||||||||
| Subtask 2: Section 106 & Cultural Resources | 0 | $0 | Subtask 2: Section 106 & Cultural Resources | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: Section 106 & Cultural Resources | $0 | ||||||||||||||||||||
| 0 | $0 | 0 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||||||||||||||
| TOTAL Task 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 6 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | Task 7: Governors Apportionment Support | |||||||||||||||||||||||||||||||
| Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | 0 | $0 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy | $0 | |||||||||||||||||||
| TOTAL Task 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 7 | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | TOTAL Task 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| TOTAL Known Tasks | 80 | 16 | 16 | 100 | 100 | 115 | 0 | 0 | 28 | 12 | 467 | $32,017 | TOTAL Known Tasks | $68.56 | $467 | $32,017 | $45,605 | $32 | $0 | $0 | $9,156 | $86,809 | TOTAL Known Tasks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| . |
| Unknown Tasks | Unknown Tasks | Unknown Tasks | |||||||||||||||||||||||||||||||
| Task 1: | Task 1: | Task 1: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 1 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: | Task 2: | Task 2: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Task 2 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 3: | Task 3: | Task 3: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 3: | $0.00 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .