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
- Grand Traverse County, Lansing City, Michigan
About this file
This is a quarterly usage report spreadsheet showing vision plan data for computer and safety glasses across fiscal year 2017. The report breaks down the number of members who received computer glasses, safety glasses, or both types of glasses across each fiscal quarter, along with the total amount paid.
Over the full fiscal year, 796 total members participated, with 642 receiving computer glasses, 115 receiving safety glasses, and 39 receiving both types. The total expenditure for the program was $102,909.35, with the highest spending occurring in Q2 2017 at $41,931.59. Utilization peaked in Q2 with 284 members served, while Q1 had the lowest participation with 72 members.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Schedule A - Final.docx | DOCX document | |
| Schedule C - Plan Design Final.docx | DOCX document | |
| Schedule E - HIPAA 834 File Layouts Final.pdf | ||
| Schedule D - GeoAccess Data Final_Rev 2-28-18.xlsx | XLSX spreadsheet | |
| Standard Contract Terms Final.docx | DOCX document | |
| Vision RPF Q&A #28.xlsx | XLSX spreadsheet | |
| RFP 180000001030 Questions and Answers Final.docx | DOCX document | |
| Schedule F - Provider Cost Claims Data Final.XLSX | XLSX spreadsheet | |
| Schedule J Safeguard Requirements of Confidential Data Final.docx | DOCX document | |
| Proposal Instructions and Vendor Questions Worksheet Final.docx | DOCX document | |
| Schedule B - Pricing Matrix Final.xlsx | XLSX spreadsheet | |
| 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 | |
| Schedule I - SLA Reporting Format Final.pdf |
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 .