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 PDF
557-26.pdf PDF
Signature_-_2025-07-11T102708.869.pdf PDF
HDR_ODOT_557-26_Planning_and_Research.pdf 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 ResearchCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchDIRECT COSTSVersion:

Feb 2021

Consultant:HDRConsultant:HDRConsultant:HDR
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Milage

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.)AirfarePrinting/CopiesHotelMeals and Travel IncidentalsTotal
Modification No.Modification No.0Consultant 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 rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost 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 Date5/14/25ExampleProposal Date5/14/25Net 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 Date5/14/25
Staff PositionProject 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.)PrincipalQA/QC LeadSenior Transit/Environmental PlannerTransit Planner 2Transit PlannerSenior Project EngineerEngineerGIS TechnicianClericalTotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect 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 TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Contract ManagementTask 1: Contract ManagementTask 1: Contract Management
Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements120402082262$20,880Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements$79.69262$20,880$32,978$94$1,050$0$5,971$60,974Subtask 1: Management - biweekly meetings, invoicing, subconsults, agreements1500$1,050
TOTAL Task 1120402082000000262$20,880TOTAL Task 1$79.69262$20,880$32,978$94$1,050$0$5,971$60,974TOTAL Task 1150000000000$1,050
Task 2: ResearchTask 2: ResearchTask 2: Research
Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach5084656565161604293$17,648Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach$60.23293$17,648$27,874$80$2,690$55,685$5,047$109,025Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach1500224$2,690
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 25084656565161604293$17,648TOTAL Task 2$60.23293$17,648$27,874$80$2,690$55,685$5,047$109,025TOTAL Task 2150020240000$2,690
Task 3: PlanningTask 3: PlanningTask 3: Planning
Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations120889011012044168488$28,462Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations$58.32488$28,462$44,952$129$2,472$0$8,139$84,154Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations2000110023$2,472
Subtask 2: Regional Transit Plan - Service Operations Planning00000000000$0Subtask 2: Regional Transit Plan - Service Operations PlanningERROR:#DIV/0!0$0$0$0$0$50,907$0$50,907Subtask 2: Regional Transit Plan - Service Operations Planning$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 3120889011012044168488$28,462TOTAL Task 3$58.32488$28,462$44,952$129$2,472$50,907$8,139$135,061TOTAL Task 320001100230000$2,472
Task 4: Alternative Fuels OperationsTask 4: Alternative Fuels OperationsTask 4: Alternative Fuels Operations
Subtask 1: Implementation Plan for Electric Vehicle Replacement120164100120401212416552$33,995Subtask 1: Implementation Plan for Electric Vehicle Replacement$61.59552$33,995$53,692$154$1,760$0$9,722$99,324Subtask 1: Implementation Plan for Electric Vehicle Replacement1000123$1,760
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 41201641001204012124016552$33,995TOTAL Task 4$61.59552$33,995$53,692$154$1,760$0$9,722$99,324TOTAL Task 4100010230000$1,760
Task 5: Data and ReportingTask 5: Data and ReportingTask 5: Data and Reporting
Subtask 1: GTFS Development for 3 Transit Agencies12020240000442$2,428Subtask 1: GTFS Development for 3 Transit Agencies$57.8142$2,428$3,835$11$0$35,903$694$42,871Subtask 1: GTFS Development for 3 Transit Agencies$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 512020240000442$2,428TOTAL Task 5$57.8142$2,428$3,835$11$0$35,903$694$42,871TOTAL Task 5000000000$0
Task 6: Project ManagementTask 6: Project ManagementTask 6: Project Management
Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency5048130604016848328$20,195Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency$61.57328$20,195$31,895$91$0$0$5,775$57,956Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency$0
Subtask 2: Section 106 & Cultural Resources16282080301684184$10,613Subtask 2: Section 106 & Cultural Resources$57.68184$10,613$16,762$48$1,180$0$3,035$31,638Subtask 2: Section 106 & Cultural Resources100022$1,180
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 66661615014070321688512$30,808TOTAL Task 6$60.17512$30,808$48,657$139$1,180$0$8,810$89,595TOTAL Task 6100000220000$1,180
Task 7: Governors Apportionment SupportTask 7: Governors Apportionment SupportTask 7: Governors Apportionment Support
Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy60168100100100448400$23,139Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy$57.85400$23,139$36,546$105$860$17,685$6,617$84,952Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy10002$860
TOTAL Task 7601681001001004408400$23,139TOTAL Task 7$57.85400$23,139$36,546$105$860$17,685$6,617$84,952TOTAL Task 7100000020000$860
TOTAL Known Tasks54894625875593956816424482549$157,360TOTAL Known Tasks$61.73$2,549$157,360$248,535$712$10,012$160,180$45,002$621,800TOTAL Known Tasks800041008140000$10,012
.
Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3:Task 3:Task 3:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 3000000000$0.00
Task 4:Task 4:Task 4:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 4000000000$0.00
Task 5:Task 5:Task 5:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 50000000000TOTAL Task 5ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 5000000000$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 SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$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 SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$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 ResearchCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchDIRECT COSTSVersion:

Feb 2021

Consultant:Four Nines TechnologiesConsultant:Four Nines TechnologiesConsultant:Four Nines Technologies
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Milage

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.)AirfarePrinting/CopiesHotelMeals and Travel IncidentalsTotal
Modification No.Modification No.0Consultant 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 rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost 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 Date5/14/25ExampleProposal Date5/14/25Net 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 Date5/14/25
Staff PositionProject 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 ManagerPrincipalTotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect 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 TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Contract ManagementTask 1: Contract ManagementTask 1: Contract Management
Subtask 1: Management0$0Subtask 1: ManagementERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Management$0
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 1000000000$0
Task 2: ResearchTask 2: ResearchTask 2: Research
Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach4018040260$19,520Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach$75.08260$19,520$30,553$30$0$0$5,582$55,685Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 240180400000000260$19,520TOTAL Task 2$75.08260$19,520$30,553$30$0$0$5,582$55,685TOTAL Task 2000000000$0
Task 3: PlanningTask 3: PlanningTask 3: Planning
Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations0$0Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and RecommendationsERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations$0
Subtask 2: Regional Transit Plan - Service Operations Planning0$0Subtask 2: Regional Transit Plan - Service Operations PlanningERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 2: Regional Transit Plan - Service Operations Planning$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 3000000000$0
Task 4: Alternative Fuels OperationsTask 4: Alternative Fuels OperationsTask 4: Alternative Fuels Operations
Subtask 1: Implementation Plan for Electric Vehicle Replacement0$0Subtask 1: Implementation Plan for Electric Vehicle ReplacementERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Implementation Plan for Electric Vehicle Replacement$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 4000000000$0
Task 5: Data and ReportingTask 5: Data and ReportingTask 5: Data and Reporting
Subtask 1: GTFS Development for 3 Transit Agencies0$0Subtask 1: GTFS Development for 3 Transit Agencies0$0$0$0$0$0$0$0Subtask 1: GTFS Development for 3 Transit Agencies$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 500000000000$0TOTAL Task 5ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 5000000000$0
Task 6: Project ManagementTask 6: Project ManagementTask 6: Project Management
Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency0$0Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit AgencyERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency$0
Subtask 2: Section 106 & Cultural Resources0$0Subtask 2: Section 106 & Cultural ResourcesERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 2: Section 106 & Cultural Resources$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 600000000000$0TOTAL Task 6ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 6000000000$0
Task 7: Governors Apportionment SupportTask 7: Governors Apportionment SupportTask 7: Governors Apportionment Support
Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy24401680$6,199Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy$77.4980$6,199$9,703$10$0$0$1,773$17,685Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy$0
TOTAL Task 7244016000000080$6,199TOTAL Task 7$77.4980$6,199$9,703$10$0$0$1,773$17,685TOTAL Task 7000000000$0
TOTAL Known Tasks64220560000000340$25,719TOTAL Known Tasks$75.65$340$25,719$40,256$40$0$0$7,355$73,371TOTAL Known Tasks000000000$0
.
Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3:Task 3:Task 3:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 300000000000$0TOTAL Task 3ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 3000000000$0.00
Task 4:Task 4:Task 4:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 4000000000$0.00
Task 5:Task 5:Task 5:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 50000000000TOTAL Task 5ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 5000000000$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 SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$0.00
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$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 SectionFuture Tasks SectionFuture Tasks Section
Task NameTask NameTask Name
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL00000000000$0TOTALERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL000000000$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 ResearchCOST PROPOSAL SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchPROPOSAL COST SUMMARYVersion:
Feb 2021RFP: Transit Planning and ResearchDIRECT COSTSVersion:

Feb 2021

Consultant:Foursquare ITPConsultant:Foursquare ITPConsultant:Foursquare ITP
Agreement No.Agreement No.0State Average Overhead Rate159.98%Agreement No.0Milage

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.)AirfarePrinting/CopiesHotelMeals and Travel IncidentalsTotal
Modification No.Modification No.0Consultant 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 rateModification No.0
PID No.Assigned Staff Positions & Associated RatesPID No.0Cost 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 Date5/14/25ExampleProposal Date5/14/25Net 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 Date5/14/25
Staff PositionSenior 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 ManagerPrincipalQA/QC LeadSenior Project EngineerSenior Transit PlannerTransportation Planner 2Senior Planner / Data ScientistPlanner / Data ScientistJunior Planner / Data ScientistTotalNo. of UnitsAverage HourlyTotalLaborOverheadCost ofDirectSubconNetTotalDirect Cost Category:
Task DescriptionDirect 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 TasksKnown TasksKnown Tasks
Staff HoursUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnitsUnits$
Task 1: Contract ManagementTask 1: Contract ManagementTask 1: Contract Management
Subtask 1: Management00000000000$0Subtask 1: ManagementERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Management$0
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 1000000000$0
Task 2: ResearchTask 2: ResearchTask 2: Research
Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach0$0Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreachERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Best Practices Report Transit Technology and Applications for rural transit agencies, including engagement and outreach$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 2000000000$0
Task 3: PlanningTask 3: PlanningTask 3: Planning
Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations0$0Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and RecommendationsERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Regional Transit Plan - Stakeholder Engagement, Financial Plan, Operations, and Recommendations0000$0
Subtask 2: Regional Transit Plan - Service Operations Planning408860608000208284$18,775Subtask 2: Regional Transit Plan - Service Operations Planning$66.11284$18,775$26,743$19$0$0$5,369$50,907Subtask 2: Regional Transit Plan - Service Operations Planning$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 3408860608000208284$18,775TOTAL Task 3$66.11284$18,775$26,743$19$0$0$5,369$50,907TOTAL Task 3000000000$0
Task 4: Alternative Fuels OperationsTask 4: Alternative Fuels OperationsTask 4: Alternative Fuels Operations
Subtask 1: Implementation Plan for Electric Vehicle Replacement0$0Subtask 1: Implementation Plan for Electric Vehicle ReplacementERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: Implementation Plan for Electric Vehicle Replacement$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 400000000000$0TOTAL Task 4ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 4000000000$0
Task 5: Data and ReportingTask 5: Data and ReportingTask 5: Data and Reporting
Subtask 1: GTFS Development for 3 Transit Agencies40884040350084183$13,242Subtask 1: GTFS Development for 3 Transit Agencies$72.36183$13,242$18,861$13$0$0$3,787$35,903Subtask 1: GTFS Development for 3 Transit Agencies$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 540884040350084183$13,242TOTAL Task 5$72.36183$13,242$18,861$13$0$0$3,787$35,903TOTAL Task 5000000000$0
Task 6: Project ManagementTask 6: Project ManagementTask 6: Project Management
Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency0$0Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit AgencyERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: NEPA/Section 106 and FTA Coordination for 1 Transit Agency$0
Subtask 2: Section 106 & Cultural Resources0$0Subtask 2: Section 106 & Cultural ResourcesERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 2: Section 106 & Cultural Resources$0
0$00ERROR:#DIV/0!0$0$0$0$0$0$0$00$0
TOTAL Task 600000000000$0TOTAL Task 6ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 6000000000$0
Task 7: Governors Apportionment SupportTask 7: Governors Apportionment SupportTask 7: Governors Apportionment Support
Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy0$0Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policyERROR:#DIV/0!0$0$0$0$0$0$0$0Subtask 1: FTA Compliant Procurement for scheduling and dispatching software and compliant procurement policy$0
TOTAL Task 700000000000$0TOTAL Task 7ERROR:#DIV/0!0$0$0$0$0$0$0$0TOTAL Task 7000000000$0
TOTAL Known Tasks801616100100115002812467$32,017TOTAL Known Tasks$68.56$467$32,017$45,605$32$0$0$9,156$86,809TOTAL Known Tasks000000000$0
.
Unknown TasksUnknown TasksUnknown Tasks
Task 1:Task 1:Task 1:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 100000000000$0TOTAL Task 1ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 1000000000$0.00
Task 2:Task 2:Task 2:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 3:$0.00
TOTAL Task 200000000000$0TOTAL Task 2ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00TOTAL Task 2000000000$0.00
Task 3:Task 3:Task 3:
Subtask 1:0$0Subtask 1:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 1:$0.00
Subtask 2:0$0Subtask 2:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 2:$0.00
Subtask 3:0$0Subtask 3:ERROR:#DIV/0!0$0.00$0.00$0.00$0.00$0.00$0.00$0.00Subtask 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 .