Schedule B - Healthcare Database.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Health Insurance Database Management System
Solicitation number
RFP-171-250000003097-2
Issued by
Michigan

About this file

This document is a Schedule B Pricing form for a Request for Proposal (RFP No. 250000003097) issued by the State of Michigan for a Health Insurance Database Management System for the Office of Retirement Services. The contract term spans six years, from July 1, 2026, to June 30, 2032, with pricing options for annual rates and a fixed rate across the entire contract period. The document outlines detailed pricing requirements for base services and additional services, with the contractor required to complete only the yellow-shaded areas of the spreadsheet.

The pricing schedule allows for flexible fee structures, including monthly administration fees and rates for various additional services not included in the base contract. Contractors must specify pricing mechanisms for supplemental services such as establishing vendor files, creating data subsets, providing analytic and technical support, and generating ad hoc reports. The Plan Sponsor is not obligated to incorporate all listed services, providing flexibility in service selection. The document emphasizes precise pricing documentation, with instructions that contractors must not alter non-yellow cells and must provide clear, structured pricing information for each potential service offering.

View the file

Other files

File Type Posted
Schedule F1- Data Feed-ORS.xls XLS spreadsheet
RFP 250000003097 - Bidder Question and Answer Response.xlsx XLSX spreadsheet
Schedule F4- Data Feed- Non-Medicare Lab.csv CSV file
Schedule G Service Availability.xlsx XLSX spreadsheet
Schedule I Sample Validation Report.xlsx XLSX spreadsheet
Schedule F2-Data Feed Non-Medicare Medical.csv CSV file
Schedule F5- Data Feed-Medicare Lab.csv CSV file
Schedule F8- Data Feed- Medicare Pharmacy.xls XLS spreadsheet
Schedule J Software Table.xlsx XLSX spreadsheet
250000003097 - Health Insurance Database Management System RFP.docx DOCX document
Schedule F10- Data Feed- Vision.xlsx XLSX spreadsheet
Schedule F3- Data Feed-Medicare Medical.csv CSV file
Schedule F6- Data Feed-Hearing.xlsx XLSX spreadsheet
Schedule F7- Data Feed- Non Medicare Pharmacy.xlsx XLSX spreadsheet
Schedule F9- Data Feed-Dental.xls XLS spreadsheet
Schedule H Quarterly Vendor Reconciliation Report.xlsx XLSX spreadsheet
Show all 16

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

Sheet1

SCHEDULE B PRICING
STATE OF MICHIGAN
Request for Proposal No. 250000003097
Health Insurance Database Management System for the Office of Retirement Services
Instructions
1. The Contractor must provide a pricing schedule for the Proposed Contract Activities identified in Schedule A using the tables included in this Schedule B for the State's choosing.
2. The Contractor must complete only areas shaded in yellow and must not alter data or formulas in cells that are not shaded yellow.
3. Table 1 - Enter the Administration Fees for the rate types listed.
4. Follow the instructions specific to tables 2.A.- 2.C to enter the pricing structure and rate for each of the proposed Contract Activities or indicate that a particular service is not offered.
1. Base Services. Contractor's fixed monthly fee must include, at minimum, all of Schedule A, with the exception of Schedule A Section 1.4 Additional Services. If services listed in Section 1.4 are included in the Base Services fee, note that in Table 2.A below.
1.A. Annual Rate Pricing (rates for each individual contract year)7/1/2026-6/30/20277/1/2027-6/30/20287/1/2028-6/30/20297/1/2029-6/30/20307/1/2030-6/30/20317/1/2031-6/30/2032
Per Month Administration Fee
Estimated 1-year total$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Estimated Contract Total$ - 0
1.B. Fixed Rate Pricing (flat rate for the six year Contract Term)7/1/2026-6/30/2032
Per Month Administration Fee
Estimated 1-year total$ - 0
Estimated Contract Total$ - 0
2. Additional Services. Schedule A Section 1.4, Services beyond the scope of the Base Services in Schedule A, and Services not defined in Contract.
2.A. Additional Services defined in Schedule A Section 1.4. If Contractor offers the following services, please add fee details in the yellow shaded spaces below. If a service is not offered by Contractor, place an "X" in the Not Offered column. If a service is included in the Base Services, enter "Included in monthly fixed fee" in the Pricing Structure column. Responses in this Schedule B must match responses entered in Schedule A Statement of Work. Plan Sponsor is not obligated to incorporate and pay for any of the services or elements addressed in this section.
Schedule A Section NumberPricing Structure (As determined by Bidder- hourly, per project, etc. )RateNot Offered
1.4.1
1.4.2
1.4.3
1.4.4
1.4.5
1.4.6
1.4.7
1.4.8
1.4.9
1.4.10
1.4.11
1.4.12
1.4.13
1.4.14
1.4.15
1.4.16

2.B. Services beyond the scope of the Base Services in Schedule A. If there are services required in Schedule A (excluding Schedule A Section 1.4) that extend beyond Contractor's Base Services pricing, please add fee details in the yellow shaded spaces below. If a service is included in the Base Services enter "Included in monthly fixed fee" in the Pricing Structure column. Responses in this Schedule B must match responses entered in Schedule A Statement of Work. Plan Sponsor is not obligated to incorporate and pay for any of the services or elements addressed in this section.

Schedule A Section NumberService DescriptionPricing Structure (As determined by Bidder- hourly, per project, etc. )RateNotes
1.2.1.9Establishing additional vendor files
1.2.4.3.6Creating data subsets
4.7.2.4Analytic support
4.7.3.4Technical support
5.5.5Ad hoc reporting

2.C. Additional Services not listed in Schedule A. If Contractor offers additional optional products or services not already listed in Schedule A, describe them below. This may include services that would be available to the Plan Sponsor at no additional cost to the Plan Sponsor or those offered for an additional cost. If a service is included in the Base Services enter "Included in monthly fixed fee" in the Pricing Structure column. If no additional services are offered, enter "not offered" in the first row of the table. Plan Sponsor is not obligated to incorporate and pay for any of the services or elements addressed in this section

Service NameService DescriptionPricing Structure (As determined by Bidder- hourly, per project, etc. )RateNotes
[Bidder insert fields as needed]

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