Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Health - Disability
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Meet the Employees of DW Simpson
Patty Jacobsen Simpson, Bob Morand, Kristyn Sakelaris, Sean Loboda, KC Cho, Maureen Matous, Ellen Page
Aaron Benton, Becki Tobia, Kimberly Skora, Margit Vogele, Barclay Burns, Jason Blundy, Dan Karrow, Tom Troceen
Valorie Mulder, Marianne Westphal, Carol Lee, Jennifer Retford, Kieran Welsh-Phillips, Lindsey Nelson, Emily Paxton
Angie Wachholz, Derek Mulder, Julie Garwood, Caitlin Cunningham, David Benton, Dave Retford, Sarah Cleveland, Rhonda Glick
Genevieve Shannon, Meghan Bautista, Carol Datu, Barb Rave, Jesus Perez, Dan Kane, Chris Zdenek, Scott Simon, Kriss Wells


Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2003, 10:03 AM
josie josie is offline
Member
 
Join Date: Sep 2001
Posts: 51
Default IBNR Calculation Software - Medical

Does anyone know of any good commercially available software package for calculating the IBNR for Medical Health Insurance (Indemnity, Managed Care, Dental, RX)?
Reply With Quote
  #2  
Old 01-29-2003, 10:18 AM
Maine-iac's Avatar
Maine-iac Maine-iac is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Location: The Silver State
Favorite beer: Wine
Posts: 29,874
Default

In my health days we had a pretty good package we bought from Milliman. Expensive, but flexible.
Reply With Quote
  #3  
Old 01-29-2003, 10:59 AM
PAC PAC is offline
Member
 
Join Date: Jan 2003
Posts: 215
Default

Ditto Maine-iac's comments on Milliman reserving package, assuming it's the same one.

We used it to review a relatively large volume of reserving lines relatively quickly.
Reply With Quote
  #4  
Old 01-29-2003, 12:29 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 59,085
Default

MS Excel. Do it yourself.
There's no possible way that a package will be as reliable, since in the end it's all an educated guess.
Reply With Quote
  #5  
Old 01-29-2003, 12:43 PM
sb_jim sb_jim is offline
Member
 
Join Date: Dec 2001
Location: Where the surf meets the turf
Posts: 490
Default

APL works great if you have some time to do the programing yourself. Ernst & Young used to sell a system that used Excel.
Reply With Quote
  #6  
Old 01-29-2003, 12:47 PM
Patience's Avatar
Patience Patience is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: a kinder, gentler place
Favorite beer: Yogi
Posts: 39,919
Default

I agree with DTNF. The hard part is capuring the data. If you have that it is easy to build & maintain.

We actually do ours in Access, which automatically downloads into an Excel for more flexibility & scenario testing
__________________
"I've been through the desert on a horse with no name...
In the desert you can remember your name
'Cause there ain't no one for to give you no pain"
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 06:32 PM.


Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.24595 seconds with 7 queries