Att D - Cost Proposal - rtp.xlsm
XLSM spreadsheet 95 KB Posted
- Solicitation number
- 26-85961
- Issued by
- Hamilton County, Indiana
About this file
This is a Cost Proposal template for a state and local contract opportunity involving Vocational Rehabilitation (VR) services across multiple counties. Respondents must complete cost proposals for each county they are bidding on, with the option to bid on up to three or more counties by adding additional tabs. The contract structure includes an initial two-year period with optional extensions for two additional one-year periods (Years 3 and 4). Cost proposals must cover four service components: Staffing (Program Managers, Case Managers, Support Staff), Career Pathway Tools (Licensing, Platform, Integration), Training and Technical Assistance (Staff and Partner Training), and Reporting and Evaluation (Data Tools, Reporting Staff, Evaluation). All costs must be submitted on an annual basis for each year and must be all-inclusive with no additional costs accepted by the state.
Evaluation of cost proposals will be based on the average cost per case calculated over the two-year initial contract period, which is automatically derived by dividing the total bid amount by the total active VR case count for each county. Active case counts must be obtained from Attachment L (County & VR Cases - November 2025). Respondents must populate all yellow-shaded cells in the template without altering formatting or adding caveats, as doing so may result in disqualification. Years 3 and 4 pricing will not be used for scoring purposes but will be used for budgeting and contracting purposes. The template includes an example using Marion County with 1,268 active cases and total proposed costs of $40,000 for Year 1 and $20,000 for Year 2, resulting in a two-year average cost per case of $47.32. For MBE/WBE subcontractor commitments, respondents should calculate commitment percentages based on the Total Bid Amount in the designated cell.
View the file
Other files
Show all 22
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
Instructions
RESPONDENT NAME
| (Initial 2-year Contract Period) |
| Please populate ALL cells shaded in YELLOW. Please do NOT alter the formatting of the cells or add caveats to your pricing or to the cells -- as this may potentially put your cost score at risk of disqualification. The AVERAGE COST PER CASE will be the (cell E23) sum on which your cost proposal will be evaluated. This amount will be automatically calculated based on the amounts entered in the previous cells. Please do not alter or enter any information on this tab. |
| To obtain the total Active VR Case count, please use Attachment L; County & VR Cases - November 2025 |
| Cost must be submitted for all components. |
| You will complete one tab per county. If you are bidding on more than 3 counties, you may add additional Tabs using the Example tab as your Base outline. |
| Listed cost must be all-inclusive. No additional costs will be accepted by the State. |
| Cost Proposals will be evaluated based on the two-year initial term, resulting in cost per case. Please also provide pricing for optional two (2) one-year extensions. |
| For MBE/WBE Subcontractor commitments, Respondents should use the Total Bid Amount in cell E21 when figuring the commitment percentage. |
Example - Marion
| County: | Example - Marion |
| Total Active Cases: | 1268 |
| Section | Description | Amount ($) per year | Amount ($) per year | Amount ($) per year | Amount ($) per year |
| Year 1 (one) | Year 2 (two) | Year 3 (possible extension) | Year 4 (possible extension) | ||
| Staffing | Program Mgrs, Case Mgrs, Support Staff | 10000 | 5000 | ||
| Career Pathway Tools | Licensing, Platform, Integration | 10000 | 5000 | ||
| Training & TA | Staff & Partner Training, TA | 10000 | 5000 | ||
| Reporting & Evaluation | Data Tools, Reporting Staff, Evaluation | 10000 | 5000 | ||
| Total Proposed Cost | auto calculated sum of above -= Total Bid Amount | 40000 | 20000 | 0 | 0 |
| Total Active Cases per County | auto input from active case count above | 1268 | 1268 | 1268 | 1268 |
| Average Cost Per Case | auto calculated | 31.5457413249 | 15.7728706625 | 0 | 0 |
| Year 3 will not be used for scoring purposes but will be used for budgeting/contracting purposes | Year 4 will not be used for scoring purposes but will be used for budgeting/contracting purposes |
| Total Proposed Cost over 2 year(s): | 60000 |
| Active Case per county: | 1268 |
| Average Cost Per Case for a 2 year average: | 47.3186119874 |
Sheet3
| County: |
| Total Active Cases: |
| Section | Description | Amount ($) per year | Amount ($) per year | Amount ($) per year | Amount ($) per year |
| Year 1 (one) | Year 2 (two) | Year 3 (possible extension) | Year 4 (possible extension) | ||
| Staffing | Program Mgrs, Case Mgrs, Support Staff | ||||
| Career Pathway Tools | Licensing, Platform, Integration | ||||
| Training & TA | Staff & Partner Training, TA | ||||
| Reporting & Evaluation | Data Tools, Reporting Staff, Evaluation | ||||
| Total Proposed Cost | auto calculated sum of above -= Total Bid Amount | 0 | 0 | 0 | 0 |
| Total Active Cases per County | auto input from active case count above | 0 | 0 | 0 | 0 |
| Average Cost Per Case | auto calculated | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Year 3 will not be used for scoring purposes but will be used for budgeting/contracting purposes | Year 4 will not be used for scoring purposes but will be used for budgeting/contracting purposes |
| Total Cost per Active Case for a 2 year average: | 0 |
| Active Case per county: | 0 |
| Average Cost Per Case for a 2 year average: | ERROR:#DIV/0! |
Sheet4
| County: |
| Total Active Cases: |
| Section | Description | Amount ($) per year | Amount ($) per year | Amount ($) per year | Amount ($) per year |
| Year 1 (one) | Year 2 (two) | Year 3 (possible extension) | Year 4 (possible extension) | ||
| Staffing | Program Mgrs, Case Mgrs, Support Staff | ||||
| Career Pathway Tools | Licensing, Platform, Integration | ||||
| Training & TA | Staff & Partner Training, TA | ||||
| Reporting & Evaluation | Data Tools, Reporting Staff, Evaluation | ||||
| Total Proposed Cost | auto calculated sum of above -= Total Bid Amount | 0 | 0 | 0 | 0 |
| Total Active Cases per County | auto input from active case count above | 0 | 0 | 0 | 0 |
| Average Cost Per Case | auto calculated | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Year 3 will not be used for scoring purposes but will be used for budgeting/contracting purposes | Year 4 will not be used for scoring purposes but will be used for budgeting/contracting purposes |
| Total Cost per Active Case for a 2 year average: | 0 |
| Active Case per county: | 0 |
| Average Cost Per Case for a 2 year average: | ERROR:#DIV/0! |
Sheet5
| County: |
| Total Active Cases: |
| Section | Description | Amount ($) per year | Amount ($) per year | Amount ($) per year | Amount ($) per year |
| Year 1 (one) | Year 2 (two) | Year 3 (possible extension) | Year 4 (possible extension) | ||
| Staffing | Program Mgrs, Case Mgrs, Support Staff | ||||
| Career Pathway Tools | Licensing, Platform, Integration | ||||
| Training & TA | Staff & Partner Training, TA | ||||
| Reporting & Evaluation | Data Tools, Reporting Staff, Evaluation | ||||
| Total Proposed Cost | auto calculated sum of above -= Total Bid Amount | 0 | 0 | 0 | 0 |
| Total Active Cases per County | auto input from active case count above | 0 | 0 | 0 | 0 |
| Average Cost Per Case | auto calculated | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Year 3 will not be used for scoring purposes but will be used for budgeting/contracting purposes | Year 4 will not be used for scoring purposes but will be used for budgeting/contracting purposes |
| Total Cost per Active Case for a 2 year average: | 0 |
| Active Case per county: | 0 |
| Average Cost Per Case for a 2 year average: | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .