_578-26_Pricing_Document__578Pricing__1_.xlsx
XLSX spreadsheet 81 KB Posted
- Attached to
- Competitive Selection OH|DOT57826-1
- Contract number
- DOT57826-1
- Issued by
- Ohio
About this file
The document is a pricing and cost proposal spreadsheet for a marketing-related contract with the Oregon Department of Transportation (ODOT) prepared by MurphyEpson, Inc. The spreadsheet appears to be a detailed cost proposal for a specific Request for Proposal (RFP) dated February 2021, with a proposal date of 10/2/25, covering marketing, stakeholder engagement, and website development services for transit agencies.
The contract involves three primary tasks with defined labor rates across multiple staff positions, including Principal Creative Director ($350/hour), Senior Project Manager ($200/hour), Senior Art Director ($185/hour), and others. The total known tasks encompass 566 hours with a total cost of $100,206, which includes direct labor costs ($98,410), direct costs ($1,796), and no overhead or additional fees. The proposal notes that costs reflect an average across transit agencies, with flexibility to tailor budgets specifically to ODOT Transit team needs. The document includes provisions for both known and potential future tasks, though the future tasks section is currently unpopulated.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 578-26.pdf | ||
| 578-26_Score_Sheet.xlsx | XLSX spreadsheet | |
| Signature.pdf | ||
| _578-26_Marketing_Support__Affirmation_and_Disclosure.pdf | ||
| 251002_ME_ODOT_Transit_Technical_Proposal_2.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: Marketing | COST PROPOSAL SUMMARY* | Version: | |||
| Feb 2021 | RFP: Marketing | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Marketing | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | MurphyEpson, Inc. | Consultant: | MurphyEpson, Inc. | Consultant: | MurphyEpson, Inc. | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 0.00% | Agreement No. | 0 | Mileage |
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 | Website Fees (Hosting, Domain, Insurance, Maintenance and Security | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 0.00% |
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.00% |
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 | Example | Proposal Date | 10/2/25 | Net Fee Percentage: | 0% |
tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Complete as a percentage that goes no higher than 11.0% | Proposal Date | 10/2/25 | ||||||||||||||||||||||||||||||
| Staff Position | Principal | Creative Director | Senior Project Mananger | Senior Art Director | Photographer | Deputy Project Manager | ||||||||||||||||||||||||||
| (Sharp-Point) | Web Development Manager | Contract Manager | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: | ||||||||||||||||||
| Task Description | Direct Labor Rate | $350.00 | $200.00 | $185.00 | $160.00 | $250.00 | $205.00 | $150.00 | $130.00 | Hours | Cost | Task Description | Rate | Hours | Costs | Costs | Money | Costs | Costs | Fee | Cost | Task Description | Unit Cost: | $0.58 |
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={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={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% | $1.00 | $800.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: Marketing | TOTAL Task 1 | 4 | 12 | 80 | 80 | 16 | 32 | 0 | 6 | 230 | $38,740 | Task 1: Marketing | $168.43 | 230 | $38,740 | $0 | $0.00 | $100 | $0 | $0 | $38,840.00 | Task 1: Marketing | 100 | $100.00 |
Task 2: Stakeholder Engagement TOTAL Task 2 4 12 80 40 0 50 0 6 192 $36,030 Task 2: Stakeholder Engagement $187.66 192 $36,030 $0 $0.00 $896 $0 $0 $36,926.00 Task 2: Stakeholder Engagement 1200 200 $896.00
Task 3: Website Development TOTAL Task 3 4 4 16 16 0 8 90 6 144 $23,640 Task 3: Website Development $164.17 144 $23,640 $0 $0.00 $800 $0 $0 $24,440.00 Task 3: Website Development 1 $800.00
| TOTAL Known Tasks | 12 | 28 | 176 | 136 | 16 | 90 | 90 | 18 | 0 | 0 | 0 | 566 | $98,410 | TOTAL Known Tasks | $173.87 | 566 | $98,410 | $0 | $0.00 | $1,796 | $0 | $0 | $100,206.00 | TOTAL Known Tasks | 1200 | 300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $1,796.00 |
| . | ||||||||||||||||||||||||||||||||||
| * NOTE: The cost proposal reflects the average cost per transit agency across all three tasks, with the understanding that needs may vary, so MurphyEpson will collaborate with the ODOT Transit team to tailor budgets accordingly. | ||||||||||||||||||||||||||||||||||
| 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 $173.87 566 $98,410.00 $0.00 $0.00 $1,796.00 $0.00 $0.00 $100,206.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 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. Use the amount of average hours ODOT has provided for these known tasks. | 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 | ||
| ERROR:#REF! | RFP: Marketing | |
| Consultant: | MurphyEpson, 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 | ||||||||
| $173.87 | 566 | $98,410 | $0 | $0 | $1,796 | $0 | $0 | $100,206 |
| 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 | ||||||||
| $173.87 | 566 | $98,410 | $0 | $0 | $1,796 | $0 | $0 | $100,206 |
IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED TASKS
| GRAND TOTAL |
| * NOTE: The cost proposal reflects the average cost per transit agency across all three tasks, with the understanding that needs may vary, so MurphyEpson will collaborate with the ODOT Transit team to tailor budgets accordingly. |
&"Arial,Bold"&18SUMMARY OF STEPS
&F &9&P of &N &D
Narratives
| ERROR:#REF! | RFP: Marketing | Consultant | ODOT | LPA | If-Authorized |
| Consultant: | MurphyEpson, 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 .