Att D - Cost Proposal - rtp.xlsm

XLSM spreadsheet 95 KB Posted

Attached to
Vocational Rehabilitation Business NetworkBid Documents
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

File Type Posted
Vendor Networking Opportunities List - posted 1.15.26.xlsx XLSX spreadsheet
Att K - Scope of Work - rtp.pdf PDF
Att E - Business Proposal - rtp.docx DOCX document
Att F - Technical Proposal - rtp.docx DOCX document
Att A - MWBE - rtp.docx DOCX document
RFP Main Document - rtp.pdf PDF
Att M - VR Match Calculator.xlsx XLSX spreadsheet
Att I - Pre-proposal Network Form - rtp.docx DOCX document
Att B3 - IOT-SaaS.docx DOCX document
Att B - Sample Contract.docx DOCX document
Att L - County & VR Cases - November 2025 - rtp.csv CSV file
Infrastructure Overview.docx DOCX document
Att J - Attestation Form - rtp.docx DOCX document
Att B2 - IOT-PaaS.docx DOCX document
Att G - Q&A Template - rtp.xlsx XLSX spreadsheet
Att A1 - IVOSB - rtp.docx DOCX document
Att B1 - IOT-IaaS.docx DOCX document
Resource Usage Template.xlsx XLSX spreadsheet
Att C - Indiana Economic Impact Form.xls XLS spreadsheet
Att H - Reference Check Form -RTP.docx DOCX document
Cloud Questionnaire.xlsx XLSX spreadsheet
Att F1-AI Tech Proposal Questions - rtp.docx DOCX document
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
SectionDescriptionAmount ($) per yearAmount ($) per yearAmount ($) per yearAmount ($) per year
Year 1 (one)Year 2 (two)Year 3 (possible extension)Year 4 (possible extension)
StaffingProgram Mgrs, Case Mgrs, Support Staff100005000
Career Pathway ToolsLicensing, Platform, Integration100005000
Training & TAStaff & Partner Training, TA100005000
Reporting & EvaluationData Tools, Reporting Staff, Evaluation100005000
Total Proposed Costauto calculated sum of above -= Total Bid Amount400002000000
Total Active Cases per Countyauto input from active case count above1268126812681268
Average Cost Per Caseauto calculated31.545741324915.772870662500
Year 3 will not be used for scoring purposes but will be used for budgeting/contracting purposesYear 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:
SectionDescriptionAmount ($) per yearAmount ($) per yearAmount ($) per yearAmount ($) per year
Year 1 (one)Year 2 (two)Year 3 (possible extension)Year 4 (possible extension)
StaffingProgram Mgrs, Case Mgrs, Support Staff
Career Pathway ToolsLicensing, Platform, Integration
Training & TAStaff & Partner Training, TA
Reporting & EvaluationData Tools, Reporting Staff, Evaluation
Total Proposed Costauto calculated sum of above -= Total Bid Amount0000
Total Active Cases per Countyauto input from active case count above0000
Average Cost Per Caseauto calculatedERROR:#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 purposesYear 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:
SectionDescriptionAmount ($) per yearAmount ($) per yearAmount ($) per yearAmount ($) per year
Year 1 (one)Year 2 (two)Year 3 (possible extension)Year 4 (possible extension)
StaffingProgram Mgrs, Case Mgrs, Support Staff
Career Pathway ToolsLicensing, Platform, Integration
Training & TAStaff & Partner Training, TA
Reporting & EvaluationData Tools, Reporting Staff, Evaluation
Total Proposed Costauto calculated sum of above -= Total Bid Amount0000
Total Active Cases per Countyauto input from active case count above0000
Average Cost Per Caseauto calculatedERROR:#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 purposesYear 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:
SectionDescriptionAmount ($) per yearAmount ($) per yearAmount ($) per yearAmount ($) per year
Year 1 (one)Year 2 (two)Year 3 (possible extension)Year 4 (possible extension)
StaffingProgram Mgrs, Case Mgrs, Support Staff
Career Pathway ToolsLicensing, Platform, Integration
Training & TAStaff & Partner Training, TA
Reporting & EvaluationData Tools, Reporting Staff, Evaluation
Total Proposed Costauto calculated sum of above -= Total Bid Amount0000
Total Active Cases per Countyauto input from active case count above0000
Average Cost Per Caseauto calculatedERROR:#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 purposesYear 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 .