DOT Mentoring Program Attachment J-3 to Solicitation Saved Again on July 17 2024 for PUBLISHING.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- DOT Mentoring Program
- Solicitation number
- 693JK424R500007
About this file
This document is an attachment to a federal solicitation for the DOT Mentoring Program. It provides detailed labor hour estimates for the various roles and activities required to establish and conduct the mentoring program over a base year and four option years.
The key details include the following:
- The mentoring program includes activities such as strategic and action planning, orientation/kickoff, virtual speed mentoring events, formal matching, training, ongoing support, mid-point energizers, evaluations, and an end-of-program forum and celebration.
- The labor hours are estimated for a Senior Principal, Finance Director, Training Coordinator, Training Coordinator II, and Writer/Editor, with the total estimated labor hours increasing from 355.25 in the base year to 523.25 in the fourth option year.
- The federal contract opportunity associated with this attachment has an opportunity ID of 3fc994fdb7be42649362e9ffe95ec1a5, a solicitation number of 693JK424R500007, and is being issued by the Department of Transportation.
View the file
Other files
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
Base
| Program: DOT Mentoring Program | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours | ||||||
| Description | QTY | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | |
| Establish a Mentoring Program: Strategic and Action Planning | 1.00 | 6.00 | 6.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 3.00 | 2.00 | 2.00 | 15.00 |
| Facilitate a Joint Orientation or “Kickoff Meeting” | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 2.50 | 2.50 | - 0 | - 0 | 17.00 |
| Facilitate Virtual Speed Mentoring Events | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 2.50 | 5.00 | - 0 | - 0 | 34.00 |
| Facilitate the Formal Matching Process | 3.00 | 8.00 | 24.00 | 0.25 | 0.75 | 0.50 | 1.50 | 6.00 | 18.00 | - 0 | - 0 | 44.25 |
| Dynamic Mentoring Connections Training | 3.00 | 6.00 | 18.00 | 0.50 | 1.50 | 8.00 | 24.00 | 1.00 | 3.00 | - 0 | - 0 | 46.50 |
| Provide On-Going Support | 4.00 | - 0 | 0.50 | 2.00 | 5.50 | 22.00 | 4.00 | 16.00 | - 0 | - 0 | 40.00 | |
| Mid-Point Energizer | 3.00 | 6.00 | 18.00 | 0.50 | 1.50 | 8.00 | 24.00 | 2.50 | 7.50 | - 0 | - 0 | 51.00 |
| Mid-Point Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Mentoring Forum | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 5.00 | 5.00 | - 0 | - 0 | 19.50 |
| End of Program Review & Celebration | 3.00 | 6.00 | 18.00 | 0.50 | 1.50 | 8.00 | 24.00 | 2.50 | 7.50 | - 0 | - 0 | 51.00 |
| End of Program Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Total Labor: | 114.00 | 12.25 | 135.50 | 71.50 | 22.00 | 355.25 | ||||||
| *These are estimates for each line item and role. |
OY1
| DOT Mentoring Program | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours | ||||||
| Description | QTY | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | |
| Establish a Mentoring Program: Strategic and Action Planning | 1.00 | 6.00 | 6.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 3.00 | 2.00 | 2.00 | 15.00 |
| Facilitate a Joint Orientation or “Kickoff Meeting” | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 2.50 | 2.50 | - 0 | - 0 | 17.00 |
| Facilitate Virtual Speed Mentoring Events | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 2.50 | 5.00 | - 0 | - 0 | 34.00 |
| Facilitate the Formal Matching Process | 4.00 | 8.00 | 32.00 | 0.25 | 1.00 | 0.50 | 2.00 | 6.00 | 24.00 | - 0 | - 0 | 59.00 |
| Dynamic Mentoring Connections Training | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 1.00 | 4.00 | - 0 | - 0 | 62.00 |
| Provide On-Going Support | 4.00 | - 0 | 0.50 | 2.00 | 5.50 | 22.00 | 4.00 | 16.00 | - 0 | - 0 | 40.00 | |
| Mid-Point Energizer | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 2.50 | 10.00 | - 0 | - 0 | 68.00 |
| Mid-Point Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Mentoring Forum | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 5.00 | 10.00 | - 0 | - 0 | 39.00 |
| End of Program Review & Celebration | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 2.50 | 10.00 | - 0 | - 0 | 68.00 |
| End of Program Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Total Labor: | 146.00 | 14.50 | 168.00 | 88.50 | 22.00 | 439.00 | ||||||
| *These are estimates for each line item and role. |
OY2
| DOT Mentoring Program | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours | ||||||
| Description | QTY | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | |
| Establish a Mentoring Program: Strategic and Action Planning | 1.00 | 6.00 | 6.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 3.00 | 2.00 | 2.00 | 15.00 |
| Facilitate a Joint Orientation or “Kickoff Meeting” | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 2.50 | 2.50 | - 0 | - 0 | 17.00 |
| Facilitate Virtual Speed Mentoring Events | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 2.50 | 5.00 | - 0 | - 0 | 34.00 |
| Facilitate the Formal Matching Process | 4.00 | 8.00 | 32.00 | 0.25 | 1.00 | 0.50 | 2.00 | 6.00 | 24.00 | - 0 | - 0 | 59.00 |
| Dynamic Mentoring Connections Training | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 1.00 | 4.00 | - 0 | - 0 | 62.00 |
| Provide On-Going Support | 5.00 | - 0 | 0.50 | 2.50 | 5.50 | 27.50 | 4.00 | 20.00 | - 0 | - 0 | 50.00 | |
| Mid-Point Energizer | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 2.50 | 10.00 | - 0 | - 0 | 68.00 |
| Mid-Point Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Mentoring Forum | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 5.00 | 10.00 | - 0 | - 0 | 39.00 |
| End of Program Review & Celebration | 4.00 | 6.00 | 24.00 | 0.50 | 2.00 | 8.00 | 32.00 | 2.50 | 10.00 | - 0 | - 0 | 68.00 |
| End of Program Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Total Labor: | 146.00 | 15.00 | 173.50 | 92.50 | 22.00 | 449.00 | ||||||
| *These are estimates for each line item and role. |
OY3
| DOT Mentoring Program | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours | ||||||
| Description | QTY | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | |
| Establish a Mentoring Program: Strategic and Action Planning | 1.00 | 6.00 | 6.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 3.00 | 2.00 | 2.00 | 15.00 |
| Facilitate a Joint Orientation or “Kickoff Meeting” | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 2.50 | 2.50 | - 0 | - 0 | 17.00 |
| Facilitate Virtual Speed Mentoring Events | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 2.50 | 5.00 | - 0 | - 0 | 34.00 |
| Facilitate the Formal Matching Process | 5.00 | 8.00 | 40.00 | 0.25 | 1.25 | 0.50 | 2.50 | 6.00 | 30.00 | - 0 | - 0 | 73.75 |
| Dynamic Mentoring Connections Training | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 1.00 | 5.00 | - 0 | - 0 | 77.50 |
| Provide On-Going Support | 5.00 | - 0 | 0.50 | 2.50 | 5.50 | 27.50 | 4.00 | 20.00 | - 0 | - 0 | 50.00 | |
| Mid-Point Energizer | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 2.50 | 12.50 | - 0 | - 0 | 85.00 |
| Mid-Point Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Mentoring Forum | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 5.00 | 10.00 | - 0 | - 0 | 39.00 |
| End of Program Review & Celebration | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 2.50 | 12.50 | - 0 | - 0 | 85.00 |
| End of Program Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Total Labor: | 172.00 | 16.75 | 198.00 | 104.50 | 22.00 | 513.25 | ||||||
| *These are estimates for each line item and role. |
OY4
| DOT Mentoring Program | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours | ||||||
| Description | QTY | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | Hrs per line item | Total Hours | |
| Establish a Mentoring Program: Strategic and Action Planning | 1.00 | 6.00 | 6.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 3.00 | 2.00 | 2.00 | 15.00 |
| Facilitate a Joint Orientation or “Kickoff Meeting” | 1.00 | 6.00 | 6.00 | 0.50 | 0.50 | 8.00 | 8.00 | 2.50 | 2.50 | - 0 | - 0 | 17.00 |
| Facilitate Virtual Speed Mentoring Events | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 2.50 | 5.00 | - 0 | - 0 | 34.00 |
| Facilitate the Formal Matching Process | 5.00 | 8.00 | 40.00 | 0.25 | 1.25 | 0.50 | 2.50 | 6.00 | 30.00 | - 0 | - 0 | 73.75 |
| Dynamic Mentoring Connections Training | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 1.00 | 5.00 | - 0 | - 0 | 77.50 |
| Provide On-Going Support | 6.00 | - 0 | 0.50 | 3.00 | 5.50 | 33.00 | 4.00 | 24.00 | - 0 | - 0 | 60.00 | |
| Mid-Point Energizer | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 2.50 | 12.50 | - 0 | - 0 | 85.00 |
| Mid-Point Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Mentoring Forum | 2.00 | 6.00 | 12.00 | 0.50 | 1.00 | 8.00 | 16.00 | 5.00 | 10.00 | - 0 | - 0 | 39.00 |
| End of Program Review & Celebration | 5.00 | 6.00 | 30.00 | 0.50 | 2.50 | 8.00 | 40.00 | 2.50 | 12.50 | - 0 | - 0 | 85.00 |
| End of Program Evaluation & Report | 1.00 | 3.00 | 3.00 | 0.50 | 0.50 | 3.00 | 3.00 | 2.00 | 2.00 | 10.00 | 10.00 | 18.50 |
| Total Labor: | 172.00 | 17.25 | 203.50 | 108.50 | 22.00 | 523.25 | ||||||
| *These are estimates for each line item and role. |
Summary
| Contract Year | Senior Principal | Finance Director | Training Coordinator | Training Coordinator II | Writer/Editor | Total Hours Per Contract Year |
| Base | 114.00 | 12.25 | 135.50 | 71.50 | 22.00 | 355.25 |
| Option Year 1 | 146.00 | 14.50 | 168.00 | 88.50 | 22.00 | 439.00 |
| Option Year 2 | 146.00 | 15.00 | 173.50 | 92.50 | 22.00 | 449.00 |
| Option Year 3 | 172.00 | 16.75 | 198.00 | 104.50 | 22.00 | 513.25 |
| Option Year 4 | 172.00 | 17.25 | 203.50 | 108.50 | 22.00 | 523.25 |
| Total Hours for Base + 5 | 750.00 | 75.75 | 878.50 | 465.50 | 110.00 | 2,279.75 |
File details come from the government source that posted it. Updated .