Vision RPF Q&A #33.xlsx
XLSX spreadsheet 9 KB Posted
- Attached to
- Vision Insurance Plan Administration for CSC
- Solicitation number
- RFP 171 180000001030 4
- Issued by
- Michigan
About this file
This is a fiscal year 2017 data report for a State Vision Plan covering computer and safety glasses benefits. The document provides quarterly utilization and claims data tracking member enrollment and glasses distribution across four fiscal quarters spanning October 2016 through September 2017. The plan administered benefits for computer glasses, safety glasses, and combined computer and safety glasses, with a total of 796 members served during the fiscal year. Computer glasses represented the primary product distributed with 642 units, followed by safety glasses at 115 units, and 39 members receiving both types of glasses.
The report demonstrates consistent utilization across all four quarters, with second quarter (January through March) showing the highest enrollment at 284 members and highest total paid claims at $41,931.59, while fourth quarter (July through September) recorded the lowest enrollment at 183 members with $25,106.35 in total paid claims. Aggregate claims for the full fiscal year totaled $102,909.35, reflecting an average cost per member of approximately $129.41. The data indicates steady program participation and benefit distribution across the state vision plan's covered population, with no material fluctuation suggesting stable demand for both computer and safety eyewear benefits.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP 180000001030 Questions and Answers Final.docx | DOCX document | |
| Standard Contract Terms Final.docx | DOCX document | |
| Schedule A - Final.docx | DOCX document | |
| Schedule E - HIPAA 834 File Layouts Final.pdf | ||
| Proposal Instructions and Vendor Questions Worksheet Final.docx | DOCX document | |
| Schedule B - Pricing Matrix Final.xlsx | XLSX spreadsheet | |
| Schedule J Safeguard Requirements of Confidential Data Final.docx | DOCX document | |
| Schedule G - Provider Location Data for Disruption Analysis Final_Rev 2-28-18.xlsx | XLSX spreadsheet | |
| Schedule H - Sample Claims Report and Invoice Format Final.xlsx | XLSX spreadsheet | |
| Vision RPF Q&A #28.xlsx | XLSX spreadsheet | |
| Schedule C - Plan Design Final.docx | DOCX document | |
| Schedule D - GeoAccess Data Final_Rev 2-28-18.xlsx | XLSX spreadsheet | |
| Schedule I - SLA Reporting Format Final.pdf | ||
| Schedule F - Provider Cost Claims Data Final.XLSX | XLSX spreadsheet |
Show all 14
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
FY17 Comp & Safety Glasses State Vision Plan - Computer and Safety Glasses
FY17
| Fiscal | ||||||
| Quarters | Total Members | Number of Computer Glasses | Number of Safety Glasses | Number of Computer and Safety Glasses | Total Paid | |
| 1Q17 | ||||||
| (Oct - Dec) | 72 | 53 | 13 | 6 | $9,618.26 | |
| 2Q17 | ||||||
| (Jan - Mar) | 284 | 231 | 40 | 13 | $41,931.59 | |
| 3Q17 | ||||||
| (Apr - Jun) | 257 | 204 | 42 | 11 | $26,253.15 | |
| 4Q17 | ||||||
| (Jul - Sept) | 183 | 154 | 20 | 9 | $25,106.35 | |
| Grand Totals | 796 | 642 | 115 | 39 | $102,909.35 |
File details come from the government source that posted it. Updated .