$2023$ EE Internal Owner Monthly Contributions

Benefit Class Medical $-$ Single Dental $-$ Single Vision $-$ Single Medical $-$ Single Dental Base $-$ Single

Barganing Unit EE premium contribution $20\%27\%17\%$

Barganing Unit ER premium contribution $80\%73\%83\%$

Medical Monthly Total $$498\mathrm{.}95$

Dental Monthly Total $$36\mathrm{.}72$

Vision Monthly Total $$12\mathrm{.}02$

$1)$ Based on the information above for the total monthly premiums for Medical, Dental, and Vision, calculate the following:

$1$a$)$ Internal Owner's Monthly Premium

$1$b$)$ Internal Owners's Weekly Premium

$1$c$)$ Northern's Monthly Premium

$1$d$)$ Northern's Weekly Premium

$**$Please note: We will be looking for correct formulas used, and how you calculated each premium.

Payment schedule for Benefit Premiums

Internal Owner Week #

Date Benefit Type Weekly Total Owed # Weeks Owed # Weeks to Catch Up Weekly Catch Up Amount Regular Weekly Amount Weekly Premium Total $1$

$4/7/2023$ Medical $52$

Dental $52$

Vision $52$

Weekly Catch$-$up Total Combined Total

Date Benefit Type Weekly Total Owed # Weeks Owed # Weeks to Catch Up Weekly Catch Up Amount Regular Weekly Amount Weekly Premium Total $2$

$4/14/2023$ Medical $52$

Dental $52$

Vision $52$

Weekly Catch$-$up Total Combined Total

$1)$ From the first exercise on Tab $1,$ please use the Internal Owner's weekly premium for the Weekly Total Owed amount and calculate the following:

$1$a$)$ Weekly Catch Up Amount

$1$b$)$ Regular Weekly Amount

$1$c$)$ Weekly Premium Total

$1$d$)$ Weekly Catch Up Total

$1$e$)$ Combine Total

$**$Please note: We will be looking for correct formulas used, and how you calculated the totals.