PDA

View Full Version : Anybody working on the EOM exercise

clueless
03-03-2012, 04:34 PM
Is anyone having trouble with the prescription drug calculations for the supplemental plan?

mwhidden
03-21-2012, 10:47 AM
Are you still working on the EOM exercise?

EA4ME
04-06-2012, 08:56 AM
I'm working on this now. Doesn't seem too bad, but will discuss if anyone else is working on it too.

meliche
04-12-2012, 01:51 PM
I will be working on it beginning May. If you are still at that point, let me know!

meliche
04-27-2012, 07:38 PM
So I have started working on the module exercise and am stumped with modelling the prescription drug portion for the preferred plan.

I have basically done something similar as for the hospital portion of task 2:

(average claim - 10)x number of events x number of claimants. The sum of this would be the total cost to the employer and then over 1,000,000 (the number of claimants), would result in the cost per employee. What am I missing here? Any help is appreciated!

And also note that I am doing this for an employee where medicare has not kicked in yet.

jred1979
05-01-2012, 05:07 PM
So I have started working on the module exercise and am stumped with modelling the prescription drug portion for the preferred plan.

I have basically done something similar as for the hospital portion of task 2:

(average claim - 10)x number of events x number of claimants. The sum of this would be the total cost to the employer and then over 1,000,000 (the number of claimants), would result in the cost per employee. What am I missing here? Any help is appreciated!

And also note that I am doing this for an employee where medicare has not kicked in yet.

For an employee, the plan cost is total cost - (10 x number of events), then adjust by the claimaints over 1 million.

Medicare and supplemental are more complex.

meliche
05-01-2012, 07:29 PM

EA4ME
05-04-2012, 09:31 AM
So I have started working on the module exercise and am stumped with modelling the prescription drug portion for the preferred plan.

I have basically done something similar as for the hospital portion of task 2:

(average claim - 10)x number of events x number of claimants. The sum of this would be the total cost to the employer and then over 1,000,000 (the number of claimants), would result in the cost per employee. What am I missing here? Any help is appreciated!

And also note that I am doing this for an employee where medicare has not kicked in yet.

I think you just have an order of operations issue. I'm using: (average claim - (# of events x 10)) x # of claimants. Adding this up and dividing by 1,000,000 gets the \$720 cost of benefit.

rmandel
10-22-2012, 09:09 AM
Anyone working on it now?

almostdone2
12-04-2012, 12:53 PM
I am starting this today. Would like to be done by the end of the year. Please PM me if you want to discuss.