563pricing_OTAP_563-26_RLS_Team.xlsx
XLSX spreadsheet 225 KB Posted
- Attached to
- Competitive Selection OH|DOT56326-1
- Contract number
- DOT56326-1
- Issued by
- Ohio
About this file
This document is a cost proposal summary for Transit Support Services, prepared by multiple consultants including RLS & Associates, Inc., Unicorn, Schweiger Consulting LLC, and AECOM for the Ohio Department of Transportation (ODOT). The proposal is version February 2021 and covers an indefinite delivery vehicle contract for various transit-related support services across multiple tasks and subtasks.
The contract encompasses six primary task areas: Section 5311 Staff Support, Drug & Alcohol Program Reviews, Subrecipient On-Site Technical Assistance, Subrecipient Reviews Support, Section 5310 Staff Support, and RTAP Training Workshops & Program. The total known tasks for RLS & Associates amount to 5,563 hours with a total cost of $685,189.57, including labor, overhead, and direct costs. The pricing structure includes varying hourly rates for different staff positions ranging from $32.92 to $185.56, with overhead rates between 84.24% and 159.98%. The contract appears to be structured with known tasks, potential unknown tasks, and future task sections, suggesting flexibility for additional work scopes. Direct costs include categories such as mileage, air travel, lodging, printing, and rental car expenses, with a net fee percentage capped at 11%.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| OTAP_563-26RLS_Team_Combined_Resumes.pdf | ||
| OTAP_563-26_RLS_Team_Forms_Combined.pdf | ||
| Affirmation_and_Disclosure_Form_2025_-_RLS_Signed__1_.pdf | ||
| Signature.pdf | ||
| 563-26.pdf | ||
| 563-26_Score_Sheet.xlsx | XLSX spreadsheet | |
| OTAP_563-26_final__Proposal_I__II__III_sections_RLS_Team.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
RLS
| RFP: Transit Support Services | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Support Services | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Support Services | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | RLS & Associates, Inc. | Consultant: | RLS & Asssociates, Inc. | Consultant: | RLS & Associates, Inc. | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | 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.) | Subsistance | Air Travel | Lodging | Survey Monkey | Webinars | Printing and Postage | Rental Car | Rental Car Fuel | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 84.24% |
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.14% |
tc={953A55F2-FC43-4D27-9524-DAD905EC8290}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 11% |
tc={D90B5E0A-388E-47A3-B38C-07D51FC3F9BE}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Complete as a percentage that goes no higher than 11.0% | Proposal Date | ||
| Staff Position | Contract Manager |
tc={375C69B9-5530-4600-9629-661986A5ABA9}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.) | Principal | Subject Matter Expert | Senior Associate/ PM | Associate III | Associate II | Associate I | Support | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: |
| Task Description | Direct Labor Rate | $70.91 |
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 $185.56 $108.46 $70.91 $62.00 $46.35 $38.70 $32.92 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={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% | $68.00 | $620.00 | $110.00 | $110.00 | $100.00 | $32.00 | $76.00 | $35.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: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | ||||||||||||||||||||||||||||||||||
| Subtask 1: | 85 | 6 | 1700 | 1791 | $85,936 | Subtask 1: | 0 | $47.98 | 1791 | $85,935.71 | $72,392.24 | $120.31 | $2,314.00 | $0.00 | $24,575.72 | $185,337.98 | Subtask 1: | 1000 | 6 | 6 | 6 | 6 | $2,314.00 | |||||||||||||
| Subtask 2: | 0 | $0 | Subtask 2: | 0 | 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: | 0 | 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 | 85 | 6 | 0 | 0 | 0 | 1700 | 0 | 0 | 0 | 0 | 1791 | $85,936 | TOTAL Task 1 | $47.98 | 1791 | $85,936 | $72,392 | $120 | $2,314 | $0 | $24,576 | $185,337.98 | TOTAL Task 1 | 1000 | 6 | 0 | 6 | 0 | 0 | 0 | 6 | 6 | $2,314.00 |
| Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | |||||||||||||||||||||||||||||||||
| Subtask 1: | 176 | 0 | 271 | 447 | $22,968 | Subtask 1: | $51.38 | 447 | $22,967.86 | $19,348.13 | $32.16 | $3,591.20 | $0.00 | $6,568.30 | $52,507.64 | Subtask 1: | 1440 | 8 | 8 | 12 | 12 | $3,591.20 | |||||||||||||
| Subtask 2: | 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 | 176 | 0 | 0 | 271 | 0 | 0 | 0 | 447 | $22,968 | TOTAL Task 2 | $51.38 | 447 | $22,967.86 | $19,348.13 | $32.16 | $3,591.20 | $0.00 | $6,568.30 | $52,507.64 | TOTAL Task 2 | 1440 | 8 | 0 | 8 | 0 | 0 | 0 | 12 | 12 | $3,591.20 |
| Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 4 | 280 | 34 | 318 | $22,705 | Subtask 1: | $71.40 | 318 | $22,705.04 | $19,126.73 | $31.79 | $4,502.00 | $0.00 | $6,493.14 | $52,858.69 | Subtask 1: | 1400 | 12 | 12 | 14 | 14 | $4,502.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 | 4 | 0 | 280 | 34 | 0 | 0 | 0 | 0 | 0 | 318 | $22,705 | TOTAL Task 3 | $71.40 | 318 | $22,705.04 | $19,126.73 | $31.79 | $4,502.00 | $0.00 | $6,493.14 | $52,858.69 | TOTAL Task 3 | 1400 | 12 | 0 | 12 | 0 | 0 | 0 | 14 | 14 | $4,502.00 |
| Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 8 | 6 | 80 | 400 | 520 | 25 | 1039 | $71,929 | Subtask 1: | $69.23 | 1039 | $71,928.94 | $60,592.94 | $100.70 | $3,442.00 | $0.00 | $20,570.09 | $156,634.67 | Subtask 1: | 800 | 2 | 2 | 24 | 2 | 2 | $3,442.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 | 8 | 6 | 80 | 400 | 520 | 0 | 25 | 0 | 0 | 0 | 1039 | $71,929 | TOTAL Task 4 | $69.23 | 1039 | $71,928.94 | $60,592.94 | $100.70 | $3,442.00 | $0.00 | $20,570.09 | $156,634.67 | TOTAL Task 4 | 800 | 2 | 0 | 2 | 0 | 24 | 0 | 2 | 2 | $3,442.00 |
| Task 5: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | ||||||||||||||||||||||||||||||||
| Subtask 1: | 80 | 200 | 264 | 544 | $30,309 | Subtask 1: | $55.72 | 544 | $30,309.20 | $25,532.47 | $42.43 | $1,160.00 | $0.00 | $8,667.76 | $65,711.87 | Subtask 1: | 2000 | $1,160.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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||
| TOTAL Task 5 | 0 | 0 | 0 | 80 | 200 | 264 | 0 | 0 | 0 | 0 | 544 | $30,309 | TOTAL Task 5 | $55.72 | 544 | $30,309.20 | $25,532.47 | $42.43 | $1,160.00 | $0.00 | $8,667.76 | $65,711.87 | TOTAL Task 5 | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $1,160.00 |
| Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | 8 | 88 | 240 | 280 | 48 | 340 | 420 | 1424 | $74,617 | Subtask 1: | $52.40 | 1424 | $74,616.56 | $62,856.99 | $104.46 | $13,222.00 | $0.00 | $21,338.69 | $172,138.71 | Subtask 1: | 3200 | 24 | 2 | 16 | 1 | 48 | 24 | $13,222.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 6 | 0 | 8 | 88 | 240 | 280 | 48 | 340 | 420 | 0 | 0 | 1424 | $74,617 | TOTAL Task 6 | $52.40 | 1424 | $74,616.56 | $62,856.99 | $104.46 | $13,222.00 | $0.00 | $21,338.69 | $172,138.71 | TOTAL Task 6 | 3200 | 24 | 2 | 16 | 1 | 48 | 0 | 24 | 0 | $13,222.00 |
TOTAL Known Tasks 93 24 168 1176 1034 2012 636 420 0 0 5563 $308,463.31 TOTAL Known Tasks $55.45 5563 $308,463.31 $259,849.49 $431.85 $28,231.20 $0.00 $88,213.72 $685,189.57 TOTAL Known Tasks 9840 52 2 44 1 72 0 58 34 $28,231.20
| 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 $55.45 5563 $308,463.31 $259,849.49 $431.85 $28,231.20 $0.00 $88,213.72 $685,189.57
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
UNICORN
| RFP: Transit Support Services | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Support Services | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Support Services | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | Unicorn | Consultant: | Unicorn | Consultant: | Unicorn | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Mileage |
tc={E92F1BAE-17FA-4BBD-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.) | Subsistance | Air Travel | Lodging | Survey Monkey | Webinars | Printing and Postage | Rental Car | Rental Car Fuel | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 163.11% |
tc={5F176C5F-5E77-4D5D-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-4D28-9524-DAD905EC8290}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 8% |
tc={D90B5E0A-388E-47A4-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 | ||
| Staff Position | Project Manager |
tc={375C69B9-5530-4601-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 | $77.00 |
tc={ADC08D57-F31B-447C-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 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.58 tc={4D6A823F-DE15-4A69-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-4601-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-4D5D-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-447C-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-4D28-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-47A4-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% | $68.00 | $620.00 | $110.00 | $110.00 | $100.00 | $32.00 | $76.00 | $35.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: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | ||||||||||||||||||||||||||||||||||
| Subtask 1: | 0 | $0 | Subtask 1: | 0 | ERROR:#DIV/0! | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | Subtask 1: | $0.00 | |||||||||||||||||||||
| Subtask 2: | 120 | 120 | $9,240 | Subtask 2: | 0 | $77.00 | 120 | $9,240.00 | $15,071.36 | $0.00 | $0.00 | $0.00 | $1,921.77 | $26,233.14 | Subtask 2: | $0.00 | ||||||||||||||||||||
| Subtask 3: | 0 | $0 | Subtask 3: | 0 | 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 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 120 | $9,240 | TOTAL Task 1 | $77.00 | 120 | $9,240 | $15,071 | $0 | $0 | $0 | $1,922 | $26,233.14 | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | |||||||||||||||||||||||||||||||||
| 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 | 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: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | |||||||||||||||||||||||||||||||
| 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: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | |||||||||||||||||||||||||||||||
| 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: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | ||||||||||||||||||||||||||||||||
| 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||
| TOTAL Task 5 | 0 | 0 | 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 |
| Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 420 | 420 | $0 | Subtask 1: | $0.00 | 420 | $0.00 | $0.00 | $0.00 | $13,222.00 | $0.00 | $0.00 | $13,222.00 | Subtask 1: | 3200 | 24 | 2 | 16 | 1 | 48 | 24 | $13,222.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 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 420 | 0 | 0 | 420 | $0 | TOTAL Task 6 | $0.00 | 420 | $0.00 | $0.00 | $0.00 | $13,222.00 | $0.00 | $0.00 | $13,222.00 | TOTAL Task 6 | 3200 | 24 | 2 | 16 | 1 | 48 | 0 | 24 | 0 | $13,222.00 |
TOTAL Known Tasks 120 0 0 0 0 0 0 420 0 0 540 $9,240.00 TOTAL Known Tasks $17.11 540 $9,240.00 $15,071.36 $0.00 $13,222.00 $0.00 $1,921.77 $39,455.14 TOTAL Known Tasks 3200 24 2 16 1 48 0 24 0 $13,222.00
| 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 $17.11 540 $9,240.00 $15,071.36 $0.00 $13,222.00 $0.00 $1,921.77 $39,455.14
IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS: IF-AUTHORIZED TASKS:
TOTAL IF-AUTHORIZED PARTS TOTAL IF-AUTHORIZED PARTS
GRAND TOTAL GRAND TOTAL
SCHWEIGER
| RFP: Transit Support Services | COST PROPOSAL SUMMARY | Version: | |||
| Feb 2021 | RFP: Transit Support Services | PROPOSAL COST SUMMARY | Version: | ||
| Feb 2021 | RFP: Transit Support Services | DIRECT COSTS | Version: |
Feb 2021
| Consultant: | Schweiger Consulting LLC | Consultant: | Schweiger Consulting LLC | Consultant: | Schweiger Consulting LLC | |||
| Agreement No. | Agreement No. | 0 | State Average Overhead Rate | 159.98% | Agreement No. | 0 | Mileage |
tc={E92F1BAE-17FA-4BBE-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.) | Subsistance | Air Travel | Lodging | Survey Monkey | Webinars | Printing and Postage | Rental Car | Rental Car Fuel | Total | ||||
| Modification No. | Modification No. | 0 | Consultant Overhead Rate: | 100.00% |
tc={5F176C5F-5E77-4D5E-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-4D29-9524-DAD905EC8290}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Complete as a percentage rate, for example 0.08% | PID No. | 0 | |||||||
| Proposal Date | 5/14/25 | Example | Proposal Date | 5/14/25 | Net Fee Percentage: | 10% |
tc={D90B5E0A-388E-47A5-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 | ||
| Staff Position | Contract Manager |
tc={375C69B9-5530-4602-9629-661986A5ABA9}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Insert employee category (e.g.: Principal, Senior Associate, Project Manager, Associate, etc.) | Principal | Subject Matter Expert | Senior Associate/ PM | Associate III | Associate II | Associate I | Support | Total | No. of Units | Average Hourly | Total | Labor | Overhead | Cost of | Direct | Subcon | Net | Total | Direct Cost Category: |
| Task Description | Direct Labor Rate |
tc={ADC08D57-F31B-447D-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 $100.32 Hours Cost Task Description Rate Hours Costs Costs Money Costs Costs Fee Cost Task Description Unit Cost: $0.58 tc={4D6A823F-DE15-4A6A-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-4602-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-4D5E-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-447D-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-4D29-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-47A5-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% | $68.00 | $620.00 | $110.00 | $110.00 | $100.00 | $32.00 | $76.00 | $35.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: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | Task 1: Section 5311 Staff Support (3-year average of 2,051 hours per year) | ||||||||||||||||||||||||||||||||||
| Subtask 1: | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 80 | ERROR:#VALUE! | Subtask 1: | 0 | ERROR:#VALUE! | 80 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | |||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | 0 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | 0 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80 | ERROR:#VALUE! | TOTAL Task 1 | ERROR:#VALUE! | 80 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0 | $0 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | Task 2: Drug & Alcohol Program Reviews (3-year average of 447 hours per year) | |||||||||||||||||||||||||||||||||
| Subtask 1: | 0 | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | ||||||||||||||||||||
| Subtask 2: | 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 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||||
| TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 2 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | Task 3: Subrecipient On-Site Tech. Asst. (3-year average of 318 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 3 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | Task 4: Subrecipient Reviews Support (3-year average 1039 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 4 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 5: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | Task 5: Section 5310 Staff Support (average 684 hours per year) | ||||||||||||||||||||||||||||||||
| Subtask 1: | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | ||||||||||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | ||||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | |||||||||||
| TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 5 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | Task 6: RTAP Training Workshops & Program (average 1,424 hours per year) | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $13,222.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | 3200 | 24 | 2 | 16 | 1 | 48 | 24 | $13,222.00 | |||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 6 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $13,222.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 6 | 3200 | 24 | 2 | 16 | 1 | 48 | 0 | 24 | 0 | $13,222.00 |
TOTAL Known Tasks 0 0 80 0 0 0 0 0 0 0 80 ERROR:#VALUE! TOTAL Known Tasks ERROR:#VALUE! 80 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! $13,222.00 $0.00 ERROR:#VALUE! ERROR:#VALUE! TOTAL Known Tasks 3200 24 2 16 1 48 0 24 0 $13,222.00
| Unknown Tasks | Unknown Tasks | Unknown Tasks | |||||||||||||||||||||||||||||||
| Task 1: | Task 1: | Task 1: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 | |||||||||||||||||||
| TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ERROR:#VALUE! | TOTAL Task 1 | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | TOTAL Task 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 |
| Task 2: | Task 2: | Task 2: | |||||||||||||||||||||||||||||||
| Subtask 1: | 0 | ERROR:#VALUE! | Subtask 1: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 1: | $0.00 | |||||||||||||||||||
| Subtask 2: | 0 | ERROR:#VALUE! | Subtask 2: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 2: | $0.00 | |||||||||||||||||||
| Subtask 3: | 0 | ERROR:#VALUE! | Subtask 3: | ERROR:#VALUE! | 0 | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | $0.00 | $0.00 | ERROR:#VALUE! | ERROR:#VALUE! | Subtask 3: | $0.00 |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .