Can you guys help me out I trying to calculate the insurance PREMIUM base upon the following information.
Fulltime employees pay $88 per period
Part-time employees are not eligible for insurance, so they pay nothing.
Retired employees who are eligible for Medicare pay nothing but otherwise they pay $32 per period.
Name BirthDate Sex Status Medicare Eligible Health Plan Insurance Premium
Sally 5/15/1968 F FT N HMO
Susan 4/16/1957 F R N PPO
Mohad 2/5/1988 M PT N HMO
Listera 6/30/1999 F FT N PPO
Jill 12/17/1978 F PT N PPO
Joe 3/18/1972 M R Y HMO
Sam 2/2/1948 M R Y HMO
TOTAL $ -