Schedule F - Provider Cost Claims Data Final.XLSX

XLSX spreadsheet 26 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 claims data file from a 2018 Michigan Central Services Commission (MCSC) Vision RFP (#180000001030) that contains detailed procedure code listings and claims volume data for FY16 and FY17. The document is structured as a data collection template where bidders are required to enter their network reimbursement rate fee schedules for various vision-related medical procedures, examinations, frames, lenses, and associated services. The template includes yellow-highlighted cells for vendors to input their rates.

The file contains extensive claims volume data across hundreds of vision-related procedure codes, including ophthalmological services, contact lens fittings, frames, various types of lenses (single vision, bifocal, trifocal), and lens enhancements. Notable volume items include frames (32,704 in FY16 and 36,974 in FY17), comprehensive eye exams (20,147 in FY16 and 21,147 in FY17), and progressive lenses (17,719 in FY16 and 21,075 in FY17). Bidders are instructed to use the total claims amounts to determine average claims costs for entry in the pricing matrix (Schedule B) and are asked to provide information about their book of business regarding in-network versus out-of-network provider usage.

View the file

Other files

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

Document Cover

2018 MCSC Vision RFP No. 180000001030
Schedule F - Cost & Claims Data

Table of Contents

Tab
1Cost & Claim Data - FY16

2 Cost & Claim Data - FY17

Cost & Claims Data - FY16

2018 MCSC Vision RFP No. 180000001030
Schedule F - Cost and Claims Data

FY16

Please enter your network reimbursement rate fee schedule for each procedure code and any applicable notes by populating the yellow highlighted cells below. Use Total Claims Amount below and on additional tab to determine average claims cost for entry in pricing matrix (Schedule B).

Note: Assume that all lens procedure codes are for two-lens prescriptions.

In your Book of Business (BOB), what percent of your members use in-network providers vs. out-of-network providers? Provide response in the box below:

Procedure CodeProcedure Code DescriptionNumber of ServicesRate per ServiceTotal Claims Amount Per CodeNotes
92002OPHTH SERV: MED EXAM & EVAL; INTERMED NEW PT580$0.00
92004OPHTH SERV: MED EXAM; COMP NEW PT 1/MORE VISITS7383$0.00
92012OPHTH SERV: MED EXAM & EVAL; INITERMED ESTAB PT951$0.00
92014OPHTH SERV: MED EXAM & EVAL; COMP ESTAB PT20147$0.00
92015DETERM REFRACTIVE STATE26419$0.00
92072Fitting CL management keratoconus20$0.00
92250FUNDUS PHOTOGRAPHY W/I&R0$0.00
92310SCRIPT & FIT CONTACT LENS; CORNEAL EX APHAKIA1977$0.00
92311SCRIPT & FIT CONTACT LENS; CORNEAL-APHAKIA-1EYE1$0.00
92312SCRIPT CONTACT LENS; CORNEAL-APHAKIA-BOTH EYES11$0.00
92313SCRIPT & FIT CONTACT LENS; CORNEOSCLERAL LENS3$0.00
92326REPLAC CONTACT LENS804$0.00
92341FITTING SPECTACLES EX APHAKIA; BIFOCAL0$0.00
92499UNLISTED OPHTH SERV/PROC7$0.00
99202OFFIC/OUTPT VISIT E&M NEW LOW-MOD SEVERITY 20MIN0$0.00
99203OFFIC/OUTPT VISIT E&M NEW MODERAT SEVERITY 3OMIN12$0.00
99204OFFIC/OUTPT VISIT E&M NEW MOD-HI SEVERITY 45 MIN8$0.00
99211OFFIC/OUTPT VISIT E&M ESTAB NO PHYS PRES 5 MIN0$0.00
99212OFFIC/OUTPT VISIT E&M EST SELF-LIMIT/MINOR 10MIN0$0.00
99213OFFIC/OUTPT VISIT E&M EST LOW-MOD SEVERITY 15MIN12$0.00
99214OFFIC/OUTPT VISIT E&M EST MOD-HI SEVERITY 25 MIN85$0.00
99215OFFIC/OUTPT VISIT E&M ESTAB MOD-HI SEVRTY 40 MIN4$0.00
S0590INTEGRAL LENS SERVICE, MISCELLANEOUS SERVICES REPO2$0.00
S0592COMPREHENSIVE CONTACT LENS EVALUATION11$0.00
S0620ROUTINE OPHTHALMOLOGICAL EXAMINATION INCLUDING REF5542$0.00
S0621ROUTINE OPHTHALMOLOGICAL EXAMINATION INCLUDING REF17933$0.00
V2020FRAMES PURCHASES32704$0.00
V2025DELUXE FRAME1181$0.00
V2100SPHERE 1VIS PLANO +/- 4.00 PER LENS4470$0.00
V2101SPHERE 1VIS +/- 4.12-7.00D PER LENS325$0.00
V2102SPHERE 1VIS +/- 7.12-20.00D PER LENS45$0.00
V2103SPHEROCYLINDER 1VIS PLANO +/-4.0S .12-2.00C EA8595$0.00
V2104SPHEROCYLINDER 1VIS PLANO +/-4.0S 2.12-4.0C EA652$0.00
V2105SPHEROCYLINDER 1VIS PLANO +/-4.0S 4.25-6.0C EA82$0.00
V2106SPHEROCYLINDER 1VIS PLANO +/-4.0S OVER 6.0C EA2$0.00
V2107SPHEROCYLINDER 1VIS +/- 4.25-7.00S .12-2.00C EA942$0.00
V2108SPHEROCYLINDER 1VIS +/- 4.25-7.00S 2.12-4.00D EA128$0.00
V2109SPHEROCYLINDER 1VIS +/- 4.25-7.00S 4.25-6.00D EA36$0.00
V2110SPHEROCYLINDER 1VIS +/- 4.25-7.00S 4.25-6.00C EA3$0.00
V2111SPHEROCYLINDER 1VIS 4.25-7.00S OVER 6.00C EA163$0.00
V2112SPHEROCYLINDER 1VIS +/- 7.25-12.0S .25-2.25C EA44$0.00
V2113SPHEROCYLINDER 1VIS +/- 7.25-12.0S 2.25-4.00C EA6$0.00
V2114SPHEROCYLINDER 1VIS SPHERE OVER +/- 12.00E EA11$0.00
V2115LENTICULAR (MYODISC) PER LENS SINGLE VIS1$0.00
V2121LENTICULAR LENS, PER LENS, SINGLE VISION1$0.00
V2199NOT OTHERWISE CLASSIFIED SINGLE VIS LENS1$0.00
V2200SPHERE BIFOC PLANO TO +/- 4.00D PER LENS1252$0.00
V2201SPHERE BIFOC +/- 4.12-7.00D PER LENS27$0.00
V2202SPHERE BIFOC +/- 7.12-20.00C PER LENS7$0.00
V2203SPHEROCYLINDER BIFOC PLANO +/- 4.0S .12-2.0C EA3839$0.00
V2204SPHEROCYLINDER BIFOC PLANO +/-4.0S 2.12=4.0C EA408$0.00
V2205SPHEROCYLINDER BIFOC PLANO +/04.0S 4.25-6.0C EA29$0.00
V2206SPHEROCYLINDER BIFOC PLANO +/-4.0S OVER 6.0C EA2$0.00
V2207SPHEROCYLINDER BIFOC +/-4.25-7.0S .12-2.00C EA181$0.00
V2208SPHEROCYLINDER BIFOC +/- 4.25-7.0S 2.12-4.00C EA46$0.00
V2209SPHEROCYLINDER BIFOC +/-4.25-7.0S 4.25-6.00C EA10$0.00
V2210SPHEROCYLINDER BIFOC +/-4.25-7.0S OVER 6.00C EA2$0.00
V2211SPHEROCYLINDER BIFOC +/-7.25-12.0S .25-2.25C EA38$0.00
V2212SPHEROCYLINDER BIFOC +/-7.25-12.0S 2.25-4.00C EA9$0.00
V2213SPHEROCYLINDER BIFOC +/-7.25-12.0S 4.25-6.00C EA2$0.00
V2214SPHEROCYLINDER BIFOC SPHERE OVER +/- 12.00 EA3$0.00
V2220BIFOCAL ADD OVER 3.25D1$0.00
V2300SPHERE TRIFOC PLANO +/-4.00D PER LENS197$0.00
V2301SPHERE TRIFOC +/- 4.12-7.00D PER LENS2$0.00
V2303SPHEROCYLINDER TRIFOC PLANO +/-4.0S .12-2.0C EA898$0.00
V2304SPHEROCYLINDER TRIFOC PLANO +/-4.0S 2.25-4.0C EA133$0.00
V2305SPHEROCYLINDER TRIFOC PLANO +/-4.0S 4.25-6.0C EA8$0.00
V2307SPHEROCYLINDER TRIFOC +/-4.25-7.0W .12-2.0C EA67$0.00
V2308SPHEROCYLINDER TRIFOC +/-4.25-7.0 S 2.12-4.0C EA7$0.00
V2309SPHEROCYLINDER TRIFOC +/-4.25-7.0S 4.25-6.0C EA1$0.00
V2311SPHEROCYLINDER TRIFOC +/-7.25-12.0S .25-2.25C EA5$0.00
V2312SPHEROCYLINDER TRIFOC +/-7.25-12.0S 2.25-4.0C EA2$0.00
V2410VARY ASPHERICITY LENS SINGLE FULL FIELD PER LENS1531$0.00
V2430VARY ASPHERICITY BIFOCAL FULL FIELD PER LENS21$0.00
V2499VARY SPHERICITY LENS OTHER TYPE13$0.00
V2500CONTACT LENS PMMA SPHERICAL PER LENS61$0.00
V2501CONTACT LENS PMMA TORIC/PRISM BALLAST PER LENS5$0.00
V2502CONTACT LENS PMMA BIFOCAL PER LENS5$0.00
V2503CONTACT LENS COLOR VISION DEFICIT PER LENS0$0.00
V2510CONTACT LENS GAS PERMEABLE SPHERICAL PER LENS168$0.00
V2511CONTACT LENS GAS PERMEABLE TORIC/PRISM PER LENS22$0.00
V2512CONTACT LENS GAS PERMEABLE BIFOCAL PER LENS41$0.00
V2513CONTACT LENS GAS PERMEABLE EXTEND WEAR PER LENS24$0.00
V2520CONTACT LENS HYDROPHILIC SPHERICAL PER LENS4159$0.00
V2521CONTACT LENS HYDROPHILIC TORIC/PRISM PER LENS1380$0.00
V2522CONTACT LENS HYDROPHILIC BIFOCAL PER LENS427$0.00
V2523CONTACT LENS HYDROPHILIC EXTENDED WEAR PER LENS208$0.00
V2530CNTCT LENS SCLERAL/GAS IMPERMBL LENS (SEE 92325)3$0.00
V2531CONTACT LENS, SCLERAL, GAS PERMEABLE, PER LENS28$0.00
V2599CONTACT LENS OTHER TYPE412$0.00
V2600HAND HELD LOW VISION/NON SPECTACLE MOUNTED AIDS6$0.00
V2610SINGLE LENS SPECTACLE MOUNT LOW VISION AID2$0.00
V2615TELESCOPIC/OTHER COMPOUND LES SYSTEM6$0.00
V2702Deluxe Lens Feature14$0.00
V2715Prism Per Lens7$0.00
V2744Tint Photochromatic Per Lens15998$0.00
V2745Tint, Any Color, Solid, Gradient, Per Lens555$0.00
V2750Anti-Reflective Coating Per Lens632$0.00
V2755U-V Lens Per Lens10$0.00
V2756Eye Glass Case0$0.00
V2760Scratch Resistant Coating Per Lens31$0.00
V2761Mirror Coating, Per Lens2$0.00
V2762Polarization, Any Lens Material, Per Lens23$0.00
V2781Progressive Lens, Per Lens17719$0.00
V2782Lens,Index 1.54-1.65plast Or1.60-1.79gls,Per Lens37$0.00
V2783Lens, Index >= 1.66 Plast Or >= 1.80 Gls, Per Lens15$0.00
V2784Lens, Polycarbonate Or Equal, Any Index, Per Lens176$0.00
V2799Vision Service Miscellaneous37$0.00
Total Claims Amount:$0.00

Cost & Claim Data - FY17

2018 MCSC Vision RFP No. 180000001030
Schedule F - Cost and Claims Data

FY17

Please enter your network reimbursement rate fee schedule for each procedure code and any applicable notes by populating the yellow highlighted cells below. Use Total Claims Amount below and on additional tab to determine average claims cost for entry in pricing matrix (Schedule B).

Note: Assume that all lens procedure codes are for two-lens prescriptions.

In your Book of Business (BOB), what percent of your members use in-network providers vs. out-of-network providers? Provide your response in box below:

Procedure CodeProcedure Code DescriptionNumber of ServicesRate Per ServiceTotal Claims Amount Per CodeNotes
92002OPHTH SERV: MED EXAM & EVAL; INTERMED NEW PT454$0.00
92004OPHTH SERV: MED EXAM; COMP NEW PT 1/MORE VISITS7595$0.00
92012OPHTH SERV: MED EXAM & EVAL; INITERMED ESTAB PT1048$0.00
92014OPHTH SERV: MED EXAM & EVAL; COMP ESTAB PT21147$0.00
92015DETERM REFRACTIVE STATE27563$0.00
92072Fitting CL management keratoconus28$0.00
92083VISUAL FIELD EXAM UNILAT/BILAT W/I&R; EXTEN1$0.00
92310SCRIPT & FIT CONTACT LENS; CORNEAL EX APHAKIA2111$0.00
92311SCRIPT & FIT CONTACT LENS; CORNEAL-APHAKIA-1EYE3$0.00
92312SCRIPT CONTACT LENS; CORNEAL-APHAKIA-BOTH EYES11$0.00
92313SCRIPT & FIT CONTACT LENS; CORNEOSCLERAL LENS8$0.00
92325MODIFICAT LENS (SEP PRO) W/MED SUPERVS ADAPTAT1$0.00
92326REPLAC CONTACT LENS648$0.00
92341FITTING SPECTACLES EX APHAKIA; BIFOCAL2$0.00
92499UNLISTED OPHTH SERV/PROC5$0.00
99201OFFIC/OUTPT VISIT E&M NEW SELF LIMIT/MINOR 10MIN0$0.00
99202OFFIC/OUTPT VISIT E&M NEW LOW-MOD SEVERITY 20MIN2$0.00
99203OFFIC/OUTPT VISIT E&M NEW MODERAT SEVERITY 3OMIN11$0.00
99204OFFIC/OUTPT VISIT E&M NEW MOD-HI SEVERITY 45 MIN16$0.00
99212OFFIC/OUTPT VISIT E&M EST SELF-LIMIT/MINOR 10MIN1$0.00
99213OFFIC/OUTPT VISIT E&M EST LOW-MOD SEVERITY 15MIN37$0.00
99214OFFIC/OUTPT VISIT E&M EST MOD-HI SEVERITY 25 MIN79$0.00
99215OFFIC/OUTPT VISIT E&M ESTAB MOD-HI SEVRTY 40 MIN0$0.00
S0500DISPOSABLE CONTACT LENS, PER LENS1$0.00
S0590INTEGRAL LENS SERVICE, MISCELLANEOUS SERVICES REPO0$0.00
S0592COMPREHENSIVE CONTACT LENS EVALUATION4$0.00
S0620ROUTINE OPHTHALMOLOGICAL EXAMINATION INCLUDING REF5319$0.00
S0621ROUTINE OPHTHALMOLOGICAL EXAMINATION INCLUDING REF17304$0.00
V2020FRAMES PURCHASES36974$0.00
V2025DELUXE FRAME1251$0.00
V2100SPHERE 1VIS PLANO +/- 4.00 PER LENS4497$0.00
V2101SPHERE 1VIS +/- 4.12-7.00D PER LENS333$0.00
V2102SPHERE 1VIS +/- 7.12-20.00D PER LENS48$0.00
V2103SPHEROCYLINDER 1VIS PLANO +/-4.0S .12-2.00C EA8592$0.00
V2104SPHEROCYLINDER 1VIS PLANO +/-4.0S 2.12-4.0C EA605$0.00
V2105SPHEROCYLINDER 1VIS PLANO +/-4.0S 4.25-6.0C EA79$0.00
V2106SPHEROCYLINDER 1VIS PLANO +/-4.0S OVER 6.0C EA4$0.00
V2107SPHEROCYLINDER 1VIS +/- 4.25-7.00S .12-2.00C EA892$0.00
V2108SPHEROCYLINDER 1VIS +/- 4.25-7.00S 2.12-4.00D EA119$0.00
V2109SPHEROCYLINDER 1VIS +/- 4.25-7.00S 4.25-6.00D EA18$0.00
V2110SPHEROCYLINDER 1VIS +/- 4.25-7.00S 4.25-6.00C EA2$0.00
V2111SPHEROCYLINDER 1VIS 4.25-7.00S OVER 6.00C EA169$0.00
V2112SPHEROCYLINDER 1VIS +/- 7.25-12.0S .25-2.25C EA36$0.00
V2113SPHEROCYLINDER 1VIS +/- 7.25-12.0S 2.25-4.00C EA8$0.00
V2114SPHEROCYLINDER 1VIS SPHERE OVER +/- 12.00E EA14$0.00
V2200SPHERE BIFOC PLANO TO +/- 4.00D PER LENS1226$0.00
V2201SPHERE BIFOC +/- 4.12-7.00D PER LENS27$0.00
V2202SPHERE BIFOC +/- 7.12-20.00C PER LENS9$0.00
V2203SPHEROCYLINDER BIFOC PLANO +/- 4.0S .12-2.0C EA3416$0.00
V2204SPHEROCYLINDER BIFOC PLANO +/-4.0S 2.12=4.0C EA404$0.00
V2205SPHEROCYLINDER BIFOC PLANO +/04.0S 4.25-6.0C EA22$0.00
V2206SPHEROCYLINDER BIFOC PLANO +/-4.0S OVER 6.0C EA2$0.00
V2207SPHEROCYLINDER BIFOC +/-4.25-7.0S .12-2.00C EA207$0.00
V2208SPHEROCYLINDER BIFOC +/- 4.25-7.0S 2.12-4.00C EA42$0.00
V2209SPHEROCYLINDER BIFOC +/-4.25-7.0S 4.25-6.00C EA6$0.00
V2210SPHEROCYLINDER BIFOC +/-4.25-7.0S OVER 6.00C EA2$0.00
V2211SPHEROCYLINDER BIFOC +/-7.25-12.0S .25-2.25C EA30$0.00
V2212SPHEROCYLINDER BIFOC +/-7.25-12.0S 2.25-4.00C EA6$0.00
V2213SPHEROCYLINDER BIFOC +/-7.25-12.0S 4.25-6.00C EA2$0.00
V2214SPHEROCYLINDER BIFOC SPHERE OVER +/- 12.00 EA5$0.00
V2220BIFOCAL ADD OVER 3.25D2$0.00
V2221LENTICULAR LENS, PER LENS, BIFOCAL VISION1$0.00
V2300SPHERE TRIFOC PLANO +/-4.00D PER LENS200$0.00
V2301SPHERE TRIFOC +/- 4.12-7.00D PER LENS5$0.00
V2303SPHEROCYLINDER TRIFOC PLANO +/-4.0S .12-2.0C EA899$0.00
V2304SPHEROCYLINDER TRIFOC PLANO +/-4.0S 2.25-4.0C EA125$0.00
V2305SPHEROCYLINDER TRIFOC PLANO +/-4.0S 4.25-6.0C EA9$0.00
V2307SPHEROCYLINDER TRIFOC +/-4.25-7.0W .12-2.0C EA49$0.00
V2308SPHEROCYLINDER TRIFOC +/-4.25-7.0 S 2.12-4.0C EA9$0.00
V2311SPHEROCYLINDER TRIFOC +/-7.25-12.0S .25-2.25C EA5$0.00
V2312SPHEROCYLINDER TRIFOC +/-7.25-12.0S 2.25-4.0C EA3$0.00
V2314SPHEROCYLINDER TRIFOC SHPERE OVER +/-12.00D EA0$0.00
V2319TRIFOCL SEG WIDTH OVER 28 MM0$0.00
V2410VARY ASPHERICITY LENS SINGLE FULL FIELD PER LENS1716$0.00
V2430VARY ASPHERICITY BIFOCAL FULL FIELD PER LENS41$0.00
V2499VARY SPHERICITY LENS OTHER TYPE142$0.00
V2500CONTACT LENS PMMA SPHERICAL PER LENS86$0.00
V2501CONTACT LENS PMMA TORIC/PRISM BALLAST PER LENS10$0.00
V2502CONTACT LENS PMMA BIFOCAL PER LENS2$0.00
V2503CONTACT LENS COLOR VISION DEFICIT PER LENS2$0.00
V2510CONTACT LENS GAS PERMEABLE SPHERICAL PER LENS127$0.00
V2511CONTACT LENS GAS PERMEABLE TORIC/PRISM PER LENS16$0.00
V2512CONTACT LENS GAS PERMEABLE BIFOCAL PER LENS44$0.00
V2513CONTACT LENS GAS PERMEABLE EXTEND WEAR PER LENS21$0.00
V2520CONTACT LENS HYDROPHILIC SPHERICAL PER LENS4366$0.00
V2521CONTACT LENS HYDROPHILIC TORIC/PRISM PER LENS1423$0.00
V2522CONTACT LENS HYDROPHILIC BIFOCAL PER LENS468$0.00
V2523CONTACT LENS HYDROPHILIC EXTENDED WEAR PER LENS165$0.00
V2530CNTCT LENS SCLERAL/GAS IMPERMBL LENS (SEE 92325)2$0.00
V2531CONTACT LENS, SCLERAL, GAS PERMEABLE, PER LENS48$0.00
V2599CONTACT LENS OTHER TYPE450$0.00
V2600HAND HELD LOW VISION/NON SPECTACLE MOUNTED AIDS4$0.00
V2615TELESCOPIC/OTHER COMPOUND LES SYSTEM3$0.00
V2715Prism Per Lens2$0.00
V2744Tint Photochromatic Per Lens17621$0.00
V2745Tint, Any Color, Solid, Gradient, Per Lens39$0.00
V2750Anti-Reflective Coating Per Lens26$0.00
V2755U-V Lens Per Lens2$0.00
V2756Eye Glass Case0$0.00
V2781Progressive Lens, Per Lens21075$0.00
V2782Lens,Index 1.54-1.65plast Or1.60-1.79gls,Per Lens8$0.00
V2799Vision Service Miscellaneous213$0.00
Total Claims Amount:$0.00

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