8-Appendix C- Pricing Workbook.xlsx

92 KB Posted

Attached to
CRC Correctional Staff Mental Health Services - REISSUE
Solicitation number
RFP-2025-014
Issued by
Milwaukee County, Mattoon Village, Wisconsin

About this file

Written by GovTribe AI ·

This is a Pricing Workbook (Appendix C) for Milwaukee County's solicitation for Correctional Staff Mental Health Services. The county is seeking a vendor to provide comprehensive mental health services to correctional staff, with the goal of helping staff manage work-related stress, prevent burnout, and promote overall well-being. The contract is structured for an initial three-year term with up to two additional one-year optional renewals. This reissued Request for Proposal (RFP-2025-000) replaces a previously cancelled solicitation (RFP-2025-007).

The pricing workbook is a detailed Excel spreadsheet that requires vendors to input pricing across multiple service categories, including direct clinical and non-clinical services, support services, supply costs, and overhead costs. The document instructs vendors to use specific formatting, complete all worksheets, and guarantees pricing validity until December 31, 2025. Vendors must enter unit costs, estimated volumes, and provide assumptions for various service types such as workshops, training sessions, emergency responses, program management, and case coordination. The pricing structure allows for potential annual increases and optional discounts, with a comprehensive breakdown of costs across five potential contract years.

View the file

Other files

File Type Posted
11-2025 RFP Request for Exceptions Form.pdf PDF
23-Attendance Report RFP-2025-014 Pre-Proposal Conference.xlsx XLSX spreadsheet
16-Exhibit E - Targeted Business Enterprise Forms.pdf PDF
4-PRE-PR~1.MP4 MP4 file
12-2025 PROC-1 Countys Vision of Achieving Racial Equity.pdf PDF
21-RFP-2025-014 CRC Correctional Staff Mental Health Services (REISSUE).docx DOCX document
22-RFP-2025-014 Addendum 1 - Updated Pre-Proposal Conference Date.pdf PDF
20-Exhibit C - Information Technology Policies for Vendors.pdf PDF
13-2025 RFP Sworn Statement of Offeror Form.pdf PDF
3-Pre-Proposal Conference (RFP-2025-007 CRC Correctional Staff Mental Health Services).docx DOCX document
7-RFP-2025-014 CRC Correctional Staff Mental Health Services (REISSUE).pdf PDF
14-Appendix D - CRC Organizational Chart and Role Information.pdf PDF
1-RFP-2025-007 CRC Correctional Staff Mental Health Services FINAL.pdf PDF
17-Exhibit A - Sample Contract.pdf PDF
26-Transcript RFP-2025-014 Pre-Proposal Conference.pdf PDF
32-Appendix C - Pricing Workbook CORRECTED 8.13.25.xlsx XLSX spreadsheet
27-RFP-2025-014 Pre-Proposal Conference Presentation.pdf PDF
10-2025 RFP Proprietary Information Disclosure Form.pdf PDF
25-Transcript RFP-2025-014 Pre-Proposal Conference.docx DOCX document
15-Appendix E - 2019 Milwaukee County Service Inventory - PDF.pdf PDF
19-Exhibit B - Insurance Requirements.pdf PDF
5-Appendix B - Sample Proposal Content Formatting.pdf PDF
30-RFP-2025-014 Addendum 2 - Pre-Proposal Conference Documentation.pdf PDF
6-Appendix A - Optional Proposal Content Template RFP-2025-014.docx DOCX document
18-Appendix E - 2019 Milwaukee County Service Inventory - Excel.xlsx XLSX spreadsheet
28-RFP-2025-014 Pre-Proposal Conference Presentation.pptx PPTX presentation
9-2025 EEOC Compliance Certificate.pdf PDF
2-RFP-2025-007 Pre-Proposal Conference Presentation.pptx PPTX presentation
24-Attendance Report RFP-2025-014 Pre-Proposal Conference.pdf PDF
31-RFP-2025-014 Addendum 3 - Corrected Pricing Workbook .pdf PDF
29-Recording RFP-2025-014 Pre-Proposal Conference.mp4 MP4 file
33-RFP-2025-014 Addendum 4 - Questions Answers Digest.pdf PDF
Show all 32

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Total Contract Cost

Appendix P: Pricing WorkbookNote: Do NOT enter any information on this tab.
Cells are automatically populated

Offeror: insert here

Total CostsAdult MealsJuvenile MealsCommon Fare & Religious Meals
Regular Adult MealsTherapeutic Adult MealsSack Meals - AdultSnacks - AdultSub TotalsRegular Juvenile MealsTherapeutic Juvenile MealsSack Meals - JuvenileSnacks - JuvenileSub TotalsCommon Fare MealsKosher MealsHalal MealsOther Religious MealsSub TotalsGrandTotals
Service PricingRelease PlanningAssessmentsSub TotalsCourt RemindersPretrial Case ManagementRepeat Intoxicated DriverGPS Case ManagementSub TotalsDiversion & DeferredTAD ProgramDrug Treatment Court Case ManagVeterans Treatment Court CaseSub TotalsGrandTotals

Estimated Annual Meals ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

A. Labor and Labor-Related Costs ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

B. Consumables Costs ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

C. Technology Costs ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

D. Overhead Costs ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Sum of A-D$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Profit$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Year 1 Total:ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Annual Price Per Meal0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Year 2 TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Annual Price Per Meal0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

2-Year Base Contract Total ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Year 3 TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Annual Price Per Meal0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Option Year 4 TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Annual Price Per Meal$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Option Year 5 TotalERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Annual Price Per Meal0ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

Contract Total, Option Years Included $ - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

Table of Contents #'Table%20of%20Contents'!A1Instructions #Instructions!A1 Instructions Appendix C: Milwaukee County Pricing Workbook

Pricing Workbook Instructions
AssumptionsInstructions
The County assumes that pricing submitted in an Offeror's Proposal is sufficient to cover all specifications, terms and conditions, including items such as insurance.Use MS EXCEL version 2003 or later. Do NOT submit as PDF.
Milwaukee County assumes that the prices listed in the Offeror's proposal are the most competitive quotes it can offer, both at the outset of the relationship and on an ongoing basis. Offerors must guarantee the validity of their proposed pricing until December 31, 2025.Only complete those cells with blue font. All other cells are generated by automatic formulas.
Milwaukee County assumes that Offerors have not submitted caveats to pricing, pricing that deviates from the requested format, or additional charges other than thoes indicated in this Pricing Workbook for that Offeror's Proposal. Substantial irregularities in your submission may result in rejection of your Proposal. Caveats to pricing not stated in this Workbook may cause the County to rescind your award under this RFP during the contract negotiation process.Complete ALL WORKSHEETS. The Pricing Workbook will become the basis for pricing in any awarded contract.
Appendix C: Milwaukee County Pricing Workbook
Table of Contents
Total Contract CostInstructions
Total Contract Cost WorksheetInstructions to Offerors
Service Pricing
1Service Pricing
2Pricing Assumptions
3Miscellaneous Pricing

Instructions #Instructions!A1 Service Pricing Appendix C: Milwaukee County Pricing Workbook

Offeror Name: insert here

Service Pricing

A. Service Costs
Service CategoryDescriptionUnit TypeEst. VolumeUnit CostTotal CostVolume AssumptionsOther Assumptions / Notes
Direct Services - ClinicalWorkshop or Training (Group)Session0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - ClinicalFormal Session (One-on-One)Session0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - ClinicalEmergency / Event Response (One-on-One)Hour0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - ClinicalEmergency / Event Response (Group)Hour0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - ClinicalEnter DescriptionOther0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - Non-ClinicalInformal Session (One-on-One)Session0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - Non-ClinicalWorkshop or Training (Group)Session0.00$ - 0$ - 0Enter here.Enter here.
Direct Services - Non-ClinicalEnter DescriptionOther0.00$ - 0$ - 0Enter here.Enter here.
Support ServicesProgram ManagementHour0.00$ - 0$ - 0Enter here.Enter here.
Support ServicesCase Management / CoordinationHour0.00$ - 0$ - 0Enter here.Enter here.
Support ServicesOther AdministrativeHour0.00$ - 0$ - 0Enter here.Enter here.
Support ServicesEnter DescriptionOther0.00$ - 0$ - 0Enter here.Enter here.
Other (If Applicable)Enter DescriptionOther0.00$ - 0$ - 0Enter here.Enter here.
Other (If Applicable)Enter DescriptionOther0.00$ - 0$ - 0Enter here.Enter here.
Service Costs - Subtotal$ - 0
B. Supply Costs
CategoryEnter DescriptionUnit TypeEst. VolumeUnit CostTotal CostVolume AssumptionsOther Assumptions / Notes
Technology (Software)Software NameType0.00$ - 0$ - 0
Technology (Hardware)Hardware Type (i.e., laptop, cell phone)Each0.00$ - 0$ - 0
Office SuppliesSupply Type (i.e., paper, pens, folders)Type0.00$ - 0$ - 0
TravelMileage ReimbursementMile0.00$ - 0$ - 0
Other Subcategory (If Applicable)Other (If Applicable)Type0.00$ - 0$ - 0
Other Subcategory (If Applicable)Other (If Applicable)Type0.00$ - 0$ - 0
Supply Costs - Subtotal$ - 0
C. Overhead Costs
CategoryDescriptionUnit TypeEst. VolumeUnit CostTotal CostVolume AssumptionsOther Assumptions / Notes
Fiscal Staff CostsEnter DescriptionType0.00$ - 0$ - 0
HR Staff CostsEnter DescriptionType0.00$ - 0$ - 0
Admin Staff CostsEnter DescriptionType0.00$ - 0$ - 0
Insurance CostsEnter DescriptionType0.00$ - 0$ - 0
Training CostsEnter DescriptionType0.00$ - 0$ - 0
Background ChecksEnter DescriptionType0.00$ - 0$ - 0
Other Subcategory (If Applicable)Enter DescriptionType0.00$ - 0$ - 0
Other Subcategory (If Applicable)Enter DescriptionType0.00$ - 0$ - 0
Other Subcategory (If Applicable)Enter DescriptionType0.00$ - 0$ - 0
Administrative Costs - Subtotal$ - 0
Sum of A-C Above$ - 0
Annual Increase0%
Discount (if offered)$ - 0

Year 1 Price 0

Annual Increase$ - 0
Discount (if offered)$ - 0$ - 0
Year 2 Price0
Annual Increase$ - 0
Discount (if offered)$ - 0$ - 0
Year 3 Price0
Annual Increase$ - 0
Discount (if offered)$ - 0$ - 0
Year 4 Price0
Annual Increase$ - 0
Discount (if offered)$ - 0$ - 0
Year 5 Price0

Total Cost $ - 0

#'Table%20of%20Contents'!A1 Pricing Assumptions Appendix C: Milwaukee County Pricing Workbook

Bidder: insert here

Pricing Assumptions
Instructions: In the spaces below, please list all pricing assumptions that apply to this bid.
#1
#2
#3
#4
#5
#6
#7
#8
#9
#10
#11
#12
#13
#14
#15

Table of Contents #'Table%20of%20Contents'!A1 Misc. Pricing

Appendix C: Milwaukee County Pricing Workbook
Instructions: only enter pricing data into cells with blue font on this tab.
Offeror Name:insert here
Miscellaneous Pricing
Year 1Year 2Year 3Option Year 4Option Year 5
Provide your annual cost increase by percentage.0.00%0.00%0.00%0.00%0.00%
Miscellanous Pricing Values
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Item Description$ - 0$ - 0$ - 0$ - 0$ - 0
Annual Subtotal:$ - 0$ - 0$ - 0$ - 0$ - 0

Annual Total with Price Increase: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Table of Contents #'Table%20of%20Contents'!A1 image1.jpeg

File details come from the government source that posted it. Updated .