Schedule I Sample Validation Report.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 file is a Schedule I Sample Validation Report Excel spreadsheet for Request for Proposal No. 250000003097, which appears to be an informational document for a healthcare or insurance claims validation project. The spreadsheet provides detailed monthly enrollment, medical claims, and pharmacy claims data from January 2022 through December 2024, tracking variations between data warehouse and vendor-sourced information for a single carrier.
The report demonstrates consistent tracking of member enrollment numbers and associated medical/pharmacy claim costs, with month-to-month and 12-month variance calculations. The data shows slight fluctuations in enrollment, typically ranging between 24,000-26,000 members, and claim amounts varying from approximately $1.9 million to $3.6 million monthly. Notable observations include generally negative variances in the earlier years (2022-2023) trending towards more balanced or positive variances in later periods (2024), with some months showing 0% or even positive 3-9% variations between data sources.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Schedule B - Healthcare Database.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 | |
| 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 F1- Data Feed-ORS.xls | XLS 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
| Request for Proposal No. 250000003097 | ||||||||||||||
| Informational only. No bidder action required. Bidders do not submit with proposal. | ||||||||||||||
| Eligibility Validation - Enrollment Month | Medical Claims Validation - Paid Basis | Pharmacy Claims Validation - Paid Basis | ||||||||||||
| Data Warehouse Sourced | Vendor Sourced | Data Warehouse Sourced | Vendor Sourced | Data Warehouse Sourced | Vendor Sourced | |||||||||
| Month-Year | Carrier 1 | Carrier 1 | Month-to-Month Variance | 12-Month Variance | Month-Year | Carrier 1 | Carrier 1 | Month-to-Month Variance | 12-Month Variance | Month-Year | Carrier 1 | Carrier 1 | Month-to-Month Variance | 12-Month Variance |
| January 2022 | 26,755 | 27,221 | -2% | January 2022 | $1,924,789 | $2,185,841 | -12% | January 2022 | $1,924,789 | $2,185,841 | -12% | |||
| February 2022 | 26,940 | 27,036 | -0% | February 2022 | $2,131,667 | $2,313,573 | -8% | February 2022 | $2,131,667 | $2,313,573 | -8% | |||
| March 2022 | 26,859 | 26,665 | 1% | March 2022 | $2,586,351 | $2,770,999 | -7% | March 2022 | $2,586,351 | $2,770,999 | -7% | |||
| April 2022 | 26,380 | 26,323 | 0% | April 2022 | $2,664,011 | $2,708,518 | -2% | April 2022 | $2,664,011 | $2,708,518 | -2% | |||
| May 2022 | 26,153 | 26,121 | 0% | May 2022 | $2,924,926 | $3,019,010 | -3% | May 2022 | $2,924,926 | $3,019,010 | -3% | |||
| June 2022 | 26,041 | 25,974 | 0% | June 2022 | $2,738,515 | $2,955,846 | -7% | June 2022 | $2,738,515 | $2,955,846 | -7% | |||
| July 2022 | 24,992 | 24,825 | 1% | July 2022 | $2,937,893 | $3,040,842 | -3% | July 2022 | $2,937,893 | $3,040,842 | -3% | |||
| August 2022 | 24,848 | 24,752 | 0% | August 2022 | $3,180,757 | $3,330,158 | -4% | August 2022 | $3,180,757 | $3,330,158 | -4% | |||
| September 2022 | 24,656 | 24,616 | 0% | September 2022 | $3,004,190 | $3,115,504 | -4% | September 2022 | $3,004,190 | $3,115,504 | -4% | |||
| October 2022 | 24,355 | 24,306 | 0% | October 2022 | $3,058,075 | $3,174,611 | -4% | October 2022 | $3,058,075 | $3,174,611 | -4% | |||
| November 2022 | 24,241 | 24,222 | 0% | November 2022 | $3,193,819 | $3,262,486 | -2% | November 2022 | $3,193,819 | $3,262,486 | -2% | |||
| December 2022 | 24,226 | 24,260 | -0% | 0% | December 2022 | $3,294,526 | $3,458,223 | -5% | -5% | December 2022 | $3,294,526 | $3,458,223 | -5% | -5% |
| January 2023 | 24,762 | 24,908 | -1% | January 2023 | $1,954,652 | $2,013,779 | -3% | January 2023 | $1,954,652 | $2,013,779 | -3% | |||
| February 2023 | 24,927 | 24,830 | 0% | February 2023 | $2,204,490 | $2,402,139 | -8% | February 2023 | $2,204,490 | $2,402,139 | -8% | |||
| March 2023 | 25,011 | 24,810 | 1% | March 2023 | $2,893,246 | $2,956,255 | -2% | March 2023 | $2,893,246 | $2,956,255 | -2% | |||
| April 2023 | 24,911 | 24,706 | 1% | April 2023 | $2,618,551 | $2,854,119 | -8% | April 2023 | $2,618,551 | $2,854,119 | -8% | |||
| May 2023 | 24,835 | 24,700 | 1% | May 2023 | $3,001,805 | $3,291,185 | -9% | May 2023 | $3,001,805 | $3,291,185 | -9% | |||
| June 2023 | 24,728 | 24,533 | 1% | June 2023 | $3,132,921 | $3,220,369 | -3% | June 2023 | $3,132,921 | $3,220,369 | -3% | |||
| July 2023 | 24,635 | 24,496 | 1% | July 2023 | $3,023,650 | $3,124,249 | -3% | July 2023 | $3,023,650 | $3,124,249 | -3% | |||
| August 2023 | 24,594 | 24,436 | 1% | August 2023 | $3,165,414 | $3,328,977 | -5% | August 2023 | $3,165,414 | $3,328,977 | -5% | |||
| September 2023 | 24,503 | 24,367 | 1% | September 2023 | $3,229,481 | $3,324,972 | -3% | September 2023 | $3,229,481 | $3,324,972 | -3% | |||
| October 2023 | 24,467 | 24,270 | 1% | October 2023 | $3,655,202 | $3,646,269 | 0% | October 2023 | $3,655,202 | $3,646,269 | 0% | |||
| November 2023 | 24,346 | 24,176 | 1% | November 2023 | $3,589,838 | $3,654,727 | -2% | November 2023 | $3,589,838 | $3,654,727 | -2% | |||
| December 2023 | 24,291 | 24,225 | 0% | 1% | December 2023 | $3,581,499 | $3,694,355 | -3% | -4% | December 2023 | $3,581,499 | $3,694,355 | -3% | -4% |
| January 2024 | 25,000 | 25,108 | -0% | January 2024 | $2,388,737 | $2,545,559 | -6% | January 2024 | $2,388,737 | $2,545,559 | -6% | |||
| February 2024 | 25,181 | 25,095 | 0% | February 2024 | $2,495,491 | $2,529,847 | -1% | February 2024 | $2,495,491 | $2,529,847 | -1% | |||
| March 2024 | 25,189 | 25,056 | 1% | March 2024 | $2,783,112 | $2,886,009 | -4% | March 2024 | $2,783,112 | $2,886,009 | -4% | |||
| April 2024 | 25,144 | 24,920 | 1% | April 2024 | $2,818,965 | $2,899,748 | -3% | April 2024 | $2,818,965 | $2,899,748 | -3% | |||
| May 2024 | 25,058 | 24,879 | 1% | May 2024 | $3,095,289 | $3,160,192 | -2% | May 2024 | $3,095,289 | $3,160,192 | -2% | |||
| June 2024 | 24,923 | 24,730 | 1% | June 2024 | $3,014,857 | $3,003,229 | 0% | June 2024 | $3,014,857 | $3,003,229 | 0% | |||
| July 2024 | 24,823 | 24,694 | 1% | July 2024 | $3,092,942 | $3,014,360 | 3% | July 2024 | $3,092,942 | $3,014,360 | 3% | |||
| August 2024 | 24,727 | 24,645 | 0% | August 2024 | $3,388,444 | $3,479,350 | -3% | August 2024 | $3,388,444 | $3,479,350 | -3% | |||
| September 2024 | 24,587 | 24,476 | 0% | September 2024 | $3,241,355 | $3,345,507 | -3% | September 2024 | $3,241,355 | $3,345,507 | -3% | |||
| October 2024 | 24,514 | 24,524 | -0% | October 2024 | $3,654,354 | $3,345,507 | 9% | October 2024 | $3,654,354 | $3,345,507 | 9% | |||
| November 2024 | 24,362 | 24,372 | -0% | November 2024 | $3,545,433 | $3,545,433 | 0% | November 2024 | $3,545,433 | $3,545,433 | 0% | |||
| December 2024 | 24,362 | 24,372 | -0% | 0% | December 2024 | $3,545,433 | $3,545,433 | 0% | -1% | December 2024 | $3,545,433 | $3,545,433 | 0% | -1% |
File details come from the government source that posted it. Updated .