Cost_Proposal_-_572-26_Transit_Development_Plans_-_NelsonNygaard_Submittal.xlsx
XLSX spreadsheet 92 KB Posted
- Attached to
- Competitive Selection OH|DOT57226-1
- Contract number
- DOT57226-1
- Issued by
- Ohio
About this file
This document is a cost proposal spreadsheet from Nelson\Nygaard Consulting Associates, Inc. for Transit Development Plans (TDP) involving multiple transit authorities in Ohio, specifically for South East Area Transit (rural), Morrow County Area Transit (rural), and Lima Allen County Regional Transit Authority (urban). The proposal is for the Ohio Department of Transportation (ODOT) and involves a collaborative effort among multiple consulting firms including SRF, MurphyEpson, Sharp Point, and Nelson\Nygaard as the prime consultant.
The cost proposal details four primary tasks with associated subtasks, including contract management, community and stakeholder outreach, existing system and service review, and developing transit development recommendations. The total known tasks cost is $299,547, with a total of 1,604 proposed labor hours across various staff positions ranging from Project Accountant to Senior Principal. Direct costs include $19,000 in subconsultant expenses, primarily for stakeholder outreach ($16,000 across three transit authority projects). The proposal uses a consultant overhead rate of 166.32%, a cost of money rate of 0.07%, and a net fee percentage of 10%. Labor rates vary by position, ranging from $44.36 to $119.44 per hour, with the proposal dated 10/2/25.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Affirmation_and_Disclosure_NN.pdf | ||
| Technical_Proposal_-_572-26_Transit_Development_Plans_-_NelsonNygaard_Submittal.pdf | ||
| 572-26.pdf | ||
| 572-26_Score_Sheet.xlsx | XLSX spreadsheet | |
| Signature.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_Cost Proposal
| RFP: Transit Development Plans | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Development Plans | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Development Plans | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | Nelson\Nygaard Consulting Associates, Inc. | Consultant: | Nelson\Nygaard Consulting Associates, Inc. | Consultant: | Nelson\Nygaard Consulting Associates, Inc. | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Travel Expenses |
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.) | Printing and Miscellaneous Expenses | Total | |||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: |
tc={42F990B2-D1C6-4F24-BB4C-6775B4B1792E}: [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:
Consultant overhead rate and cost of money are based on Nelson\Nygaard’s overhead. Base labor rates for subs assume NN’s overhead for proposal purposes, but would be unique to each subconsultant if awarded and contracted. 166.32% 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.07% |
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 | 10/2/25 | Nelson\Nygaard | SRF | MurphyEpson | Sharp Point | Proposal Date | 10/2/25 | Net Fee Percentage: | 10% |
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% 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.) | Proposal Date | 10/2/25 | ||||||||||||||||||||||||||||||||
| Staff Position | Senior Principal | Principal | Associate Principal | Senior Associate 2 | Senior Associate 1 | Associate 3 | Associate 2 | Associate 1 | Project Accountant | Professional VII | Professional V | Professional II | Professional II | Principal | Senior Media Content Manager | Senior Art Director | Project Manager | Contract Manager | Owner | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: | |||
| Task Description | Direct Labor Rate | $93.55 |
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 $74.19 $69.35 $61.29 $54.84 $51.61 $48.39 $41.94 $51.61 77.22 $71.38 $45.80 $44.95 $119.44 $63.13 $54.60 $51.19 $44.36 $69.96 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $1.00 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 | $1.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: Contract Management | 8 | 24 | 24 | 8 | 24 | 24 | 8 | 24 | 144 | $9,413 | Subtask 1: Contract Management | $65.36 | 144 | $9,413 | $15,655 | $7 | $0 | $0 | $2,447 | $27,521 | Subtask 1: Contract Management | $0 | |||||||||||||||||||||
| TOTAL Task 1 | 8 | 0 | 24 | 24 | 0 | 0 | 0 | 0 | 8 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 8 | 24 | 144 | $9,413 | TOTAL Task 1 | $65.36 | 144 | $9,413 | $15,655 | $7 | $0 | $0 | $2,447 | $27,521 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 |
| Task 2: TDP for South East Area Transit (rural) | Task 2: TDP for South East Area Transit (rural) | Task 2: TDP for South East Area Transit (rural) | ||||||||||||||||||||||||||||||||||||||||
| Subtask 1: Community and Stakeholder Outreach | 8 | 60 | 60 | 60 | 24 | 212 | $12,497 | Subtask 1: Community and Stakeholder Outreach | $58.95 | 212 | $12,497 | $20,785 | $9 | $7,000 | $0 | $3,249 | $43,539 | Subtask 1: Community and Stakeholder Outreach | 6000 | 1000 | $7,000 | |||||||||||||||||||||
| Subtask 2: Existing System and Service Review | 8 | 24 | 40 | 32 | 24 | 128 | $7,419 | Subtask 2: Existing System and Service Review | $57.96 | 128 | $7,419 | $12,340 | $5 | $0 | $0 | $1,929 | $21,693 | Subtask 2: Existing System and Service Review | $0 | |||||||||||||||||||||||
| Subtask 3: Developing TDP Recommendations | 8 | 40 | 40 | 32 | 24 | 144 | $8,529 | Subtask 3: Developing TDP Recommendations | $59.23 | 144 | $8,529 | $14,185 | $6 | $0 | $0 | $2,217 | $24,938 | Subtask 3: Developing TDP Recommendations | $0 | |||||||||||||||||||||||
| TOTAL Task 2 | 24 | 0 | 124 | 140 | 0 | 0 | 124 | 72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 484 | $28,445 | TOTAL Task 2 | $58.77 | 484 | $28,445 | $47,310 | $20 | $7,000 | $0 | $7,395 | $90,170 | TOTAL Task 2 | 6000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $7,000 |
| Task 3: TDP for Morrow County Area Transit (rural) | Task 3: TDP for Morrow County Area Transit (rural) | Task 3: TDP for Morrow County Area Transit (rural) | |||||||||||||||||||||||||||||||||||||||||
| Subtask 1: Community and Stakeholder Outreach | 8 | 16 | 32 | 32 | 32 | 120 | $6,979 | Subtask 1: Community and Stakeholder Outreach | $58.15 | 120 | $6,979 | $11,607 | $5 | $5,000 | $0 | $1,814 | $25,404 | Subtask 1: Community and Stakeholder Outreach | 4000 | 1000 | $5,000 | ||||||||||||||||||||||
| Subtask 2: Existing System and Service Review | 8 | 16 | 40 | 40 | 40 | 144 | $8,276 | Subtask 2: Existing System and Service Review | $57.47 | 144 | $8,276 | $13,764 | $6 | $0 | $0 | $2,151 | $24,197 | Subtask 2: Existing System and Service Review | $0 | ||||||||||||||||||||||||
| Subtask 3: Developing TDP Recommendations | 8 | 16 | 48 | 48 | 48 | 168 | $9,573 | Subtask 3: Developing TDP Recommendations | $56.98 | 168 | $9,573 | $15,921 | $7 | $0 | $0 | $2,489 | $27,989 | Subtask 3: Developing TDP Recommendations | $0 | ||||||||||||||||||||||||
| TOTAL Task 3 | 0 | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 120 | 120 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 432 | $24,827 | TOTAL Task 3 | $57.47 | 432 | $24,827 | $41,292 | $17 | $5,000 | $0 | $6,454 | $77,590 | TOTAL Task 3 | 4000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $5,000 |
| Task 4: TDP for Lima Allen County Regional Transit Authority (urban) | Task 4: TDP for Lima Allen County Regional Transit Authority (urban) | Task 4: TDP for Lima Allen County Regional Transit Authority (urban) | ||||||||||||||||||||||||||||||||||||||||
| Subtask 1: Community and Stakeholder Outreach | 8 | 60 | 16 | 16 | 8 | 16 | 8 | 60 | 192 | $12,429 | Subtask 1: Community and Stakeholder Outreach | $64.73 | 192 | $12,429 | $20,671 | $9 | $7,000 | $0 | $3,231 | $43,340 | Subtask 1: Community and Stakeholder Outreach | 6000 | 1000 | $7,000 | ||||||||||||||||||
| Subtask 2: Existing System and Service Review | 8 | 24 | 40 | 40 | 40 | 152 | $8,594 | Subtask 2: Existing System and Service Review | $56.54 | 152 | $8,594 | $14,293 | $6 | $0 | $0 | $2,234 | $25,127 | Subtask 2: Existing System and Service Review | $0 | |||||||||||||||||||||||
| Subtask 3: Developing TDP Recommendations | 8 | 40 | 40 | 40 | 32 | 40 | 200 | $12,244 | Subtask 3: Developing TDP Recommendations | $61.22 | 200 | $12,244 | $20,363 | $9 | $0 | $0 | $3,183 | $35,799 | Subtask 3: Developing TDP Recommendations | $0 | ||||||||||||||||||||||
| TOTAL Task 4 | 24 | 124 | 0 | 96 | 0 | 0 | 96 | 72 | 0 | 0 | 0 | 0 | 0 | 8 | 16 | 8 | 60 | 0 | 40 | 544 | $33,266 | TOTAL Task 4 | $61.15 | 544 | $33,266 | $55,328 | $23 | $7,000 | $0 | $8,648 | $104,265 | TOTAL Task 4 | 6000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $7,000 |
| TOTAL Known Tasks | 56 | 124 | 172 | 260 | 0 | 0 | 220 | 144 | 8 | 72 | 120 | 120 | 120 | 8 | 16 | 8 | 84 | 8 | 64 | 1604 | $95,950 | TOTAL Known Tasks | $59.82 | $1,604 | $95,950 | $159,584 | $67 | $19,000 | $0 | $24,945 | $299,547 | TOTAL Known Tasks | 16000 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $19,000 |
| . |
| 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 $59.82 1604 $95,950.11 $159,584.21 $67.17 $19,000.00 $0.00 $24,945.11 $299,546.59
IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS
GRAND TOTAL GRAND TOTAL
Insert direct cost category (e.g.: mileage, airfare, printing/copies, rental car, etc.)
Consultant overhead rate and cost of money are based on Nelson\Nygaard’s overhead. Base labor rates for subs assume NN’s overhead for proposal purposes, but would be unique to each subconsultant if awarded and contracted.
Complete as a percentage rate
Complete as a percentage rate, for example 0.08%
Complete as a percentage that goes no higher than 11.0%
Insert employee's labor rate excluding overhead rate
Insert unit cost related to the direct cost category
&9&P of &N
Instructions for Completion Instructions for Completing the Cost Proposal Summary
| Steps | Description | Notes |
| Step 1: | Input prime consultant firm's name in the highlighted B2 cell - Consultant | |
| Step 2: | In the highlighted cells D7 through M7, input the prime consultant's staff position names who would be participating in the contract should the consultant be selected. Any important subconsultant staff positions may be included. Additional columns may be added as necessary. | |
| Step 3: | In the highlighted cells D8 through M8, input the prime consultant's staff position direct labor rate associated with the position name directly above. Any important subconsultant staff position's direct labor rate may be included and additional columns may be added as necessary. | IMPORTANT: The direct labor rates proposed will be binding with the selected consultant. |
| Step 4: | Complete the Known Tasks with proposed task hours per staff position from the prime consultant's firm or team of firms. | The Known Tasks are comprised of the tasks ODOT expects to include in the contract. The task amounts proposed by the consultant will be used for comparison purposes only and will not be final task orders with the selected contractor. |
| Step 5: | In the highlighted X4 cell, input the prime consultant's overhead rate expressed as a percentage. | |
| Step 6: | In the highlighted X5 cell, input the prime consultant's cost of money rate expressed as a percentage. | |
| Step 7: | In the highlighted X6 cell, input the prime consultant's net fee (profit) rate expressed as a percentage. | The net fee has been set as a maximum of 11% for this contract. |
| Step 8: | In the highlighted cells AF3 through AN3, input the prime consultant's direct cost category name (ex: airfare, mileage, printing/copies, rental car, etc.) | |
| Step 9: | In the highlighted cells AF8 through AN8, input the prime consultant's unit cost rate associated with the direct cost category directly above. | |
| Step 10: | Complete the Direct Costs with proposed amounts per category from the prime consultant's firm or team of firms. |
Information for use Version: Sept. 2016
SUMMARY OF STEPS
| SUMMARY OF STEPS | ||
| $0.00 | RFP: Transit Development Plans | |
| Consultant: | Nelson\Nygaard Consulting Associates, Inc. | |
| Agreement No. | 0 | |
| Modification No. | 0 | |
| PID No. | 0 | |
| Proposal Date | 10/2/25 |
| Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total |
| Rate | Hours | Costs | Costs | Money | Costs | Costs | Fee | Cost |
| AUTHORIZED TASKS: | ||||||||
| Known Tasks | ||||||||
| $59.82 | 1604 | $95,950 | $159,584 | $67 | $19,000 | $0 | $24,945 | $299,547 |
| Unknown Tasks | ||||||||
| ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Future Tasks | ||||||||
| ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Future Tasks | ||||||||
| ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| TOTAL AUTHORIZED TASKS | ||||||||
| $59.82 | 1604 | $95,950 | $159,584 | $67 | $19,000 | $0 | $24,945 | $299,547 |
IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED TASKS
GRAND TOTAL
&"Arial,Bold"&18SUMMARY OF STEPS
&F &9&P of &N &D
Narratives
| 0 | RFP: Transit Development Plans | Consultant | ODOT | LPA | If-Authorized |
| Consultant: | Nelson\Nygaard Consulting Associates, Inc. | ||||
| Agreement No. | 0 | ||||
| Modification No. | 0 | ||||
| PID No. | 0 | ||||
| Proposal Date | 10/2/25 |
| Task Description | Narrative | ||||
| Copy task in scope from the Labor Rates_Cost Proposal Tab | X | X | X | X | Add Narratives as needed here |
Microsoft_Word_97_-_2003_Document.doc Information for Use of Spreadsheet
The intent of the spreadsheet(s) is to help guide ODOT and a Consultant in the development of a fair and reasonable fee for a specific project Scope of Services. The generic list was generated from items as outlined in the PDP process (may not be all inclusive). The list can be altered by adding additional activities as needed to comply with the Scope, but do not re-numbered tasks from this list.
Comments have been provided for most tasks in the Labor Rates_Cost Proposal tab describing the work typically required for that task. View the comments by hovering on the name of the task in column A/B. For further information on the work to be included in the proposed hours, also see the ODOT “Consultant Fee Estimation Guidance”.
The Narratives tab is to be used to provide additional detail on the work to be included in each task specific to the project such as number of sheets, plan scales, number of meetings, etc. An “X” should be placed in the ODOT/Consultant/LPA column based on who is responsible, and if the task is if-authorized. The intent of this tab is for it to be included as an attachment to the Scope of Services document.
Sample formulas have been provided in Section 1.1 of the Labor Rates_Cost Proposal tab for information only. ODOT does not warrant the formulas of the spreadsheet. It is the Consultant’s responsibility to check and verify all cells for accuracy (both in content and formula).
image1.emf
File details come from the government source that posted it. Updated .