572pricing.xlsx
XLSX spreadsheet 85 KB Posted
- Attached to
- 572-26 Transit Development Plans
- Solicitation number
- SRC0000033698
- Issued by
- Allen County, Ohio
About this file
This is an Excel-based cost proposal spreadsheet for Transit Development Plans (TDP) prepared for the Ohio Department of Transportation (ODOT) in February 2021. The document covers four specific transit development plan projects: South East Area Transit (rural), Morrow County Area Transit (rural), Lima Allen County Regional Transit Authority (urban), and a contract management task. The spreadsheet is designed to capture labor rates, direct costs, overhead, and fee calculations for consultants bidding on transit planning services.
The cost proposal template includes provisions for tracking labor rates with a state average overhead rate of 159.98%, and allows for direct cost categories such as mileage, airfare, printing, and rental car expenses. The document provides detailed instructions for consultants to complete the cost proposal, including inputting staff positions, labor rates, task hours, overhead rates, cost of money, and net fee (capped at 11%). While the specific spreadsheet appears to be a blank template with no actual cost data filled in, it provides a structured framework for consultants to develop and submit comprehensive pricing proposals for transit development planning projects.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 572-26.pdf | ||
| Exhibit F - NTD data.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: | Consultant: | 0 | Consultant: | 0 | ||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 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.) | Total | ||||||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | Modification No. | 0 | ||||
| PID No. | Assigned Staff Positions & Associated Rates | PID No. | 0 | Cost of Money: | PID No. | 0 | |||
| Proposal Date | Example | Proposal Date | 12/31/99 | Net Fee Percentage: | Proposal Date | 12/31/99 | |||
| 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.) | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: | |||
| Task Description | Direct Labor Rate | $50.00 |
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 $50.00 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost:
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% | 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: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: | $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: 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: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: | $0 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: | $0 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 3: | $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: 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: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: | $0 | ||||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: | $0 | ||||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 3: | $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: 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: | 0 | $0 | Subtask 1: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 1: | $0 | |||||||||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 2: | $0 | |||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | Subtask 3: | $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 |
| TOTAL Known Tasks | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0 | TOTAL Known Tasks | ERROR:#DIV/0! | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | 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 ERROR:#DIV/0! 0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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.)
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 category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.)
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: | 0 | |
| Agreement No. | 0 | |
| Modification No. | 0 | |
| PID No. | 0 | |
| Proposal Date | 12/31/99 |
| Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total |
| Rate | Hours | Costs | Costs | Money | Costs | Costs | Fee | Cost |
| AUTHORIZED TASKS: | ||||||||
| Known Tasks | ||||||||
| ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| 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 | ||||||||
| ERROR:#DIV/0! | 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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: | 0 | ||||
| Agreement No. | 0 | ||||
| Modification No. | 0 | ||||
| PID No. | 0 | ||||
| Proposal Date | 12/31/99 |
| 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 .