CA HMO Commercial Premium Rate Survey
The CA HMO Commercial Premium Rate Survey provides avg. premium rates by tier, benefit level and group size by county by plan, based on current agent and employer survey information, provided in Microsoft Access format with a MCOL software application that provides standard queries, reports and file extraction for each of the major data categories, as well as county wide averages. 18,009 sets of rates were received and compiled for the CA HMO Rate 2001 survey, representing effective dates between January 1, 2001 and May 1, 2001.
Enhancements to the CA HMO Rate 2001 Commercial Premium Rate Survey include provision of the historical 1999 and 2000 commercial HMO rate survey databases, plus additional by-county pre-set 2001 survey excel reports for selected counties.
Want more detailed information?
A sample of detailed data is provided below (% premium increases are provided in the pre-set reports and not in the database) :
Plan |
County |
|
|
|
Single |
Couple |
|
Family |
Responses |
John Doe Health Plan |
Sacramento |
Mid |
All |
High |
$138.56 |
$277.12 |
$263.26 |
$332.54 |
7 |
John Doe Health Plan |
Sacramento |
Mid |
All |
Medium |
$127.64 |
$255.28 |
$242.52 |
$306.34 |
12 |
John Doe Health Plan |
Sacramento |
Large |
All |
Low |
$118.97 |
$237.94 |
$226.04 |
$285.53 |
9 |
John Doe Health Plan |
Sacramento |
Small |
60-64 |
High |
$232.45 |
$464.90 |
$441.66 |
$557.88 |
13 |
John Doe Health Plan |
Sacramento |
Small |
55-59 |
High |
$212.57 |
$425.14 |
$403.88 |
$510.17 |
13 |
John Doe Health Plan |
Sacramento |
Small |
50-54 |
High |
$201.35 |
$402.70 |
$382.57 |
$483.24 |
13 |
 |
While you can directly use the Access file as desired, you can save considerable programming and analysis time using the pre-set Excel summary reports, or the MCOL Survey Report Software Application provided that produces powerful and easy to use detailed average premium rate queries, reports or file extractions set to your selection criteria, as well as key actuarial reports including average rate ratios, location factors or age group factors. By using the Survey Report software, you can run your query in the application, and then go to Access where only the data resulting from your query will be included in your applicable Access table. |
Return to CA HMO Rate 2001 Main Page
|
MCOL positioning you for a new kind of healthcare |
||
| E Mail: mcare@mcol.com | Phone: 209.577.4888 | Fax: 209.577.3557 |
| Write: MCOL 1101 Standiford Ave., Suite C-3, Modesto, CA 95350 | ||
© Copyright 2003,MCOL. All rights reserved.
