Across four generic plans and three scenarios, you will gain an overview of calculating an employees medical costs. six examples are provided in the attached file, leaving you with six calculations to complete this prt of the assignment

Plan A Employee Premium $600/year Deductible-$500 Cost Share-80/20 Reasonables Customax ps for employee costs calculation Premium Any amount above R&C Deductible in network w gone Co Insurance % in nework Deductible out network until gone Co-Insurance % out network Copas Ecchesion ituation 1 500 Included expenses in network all R&C 200 Included expenses out of network RAC -300 Excluded expenses Visits 1.A 1) 5600 2) 0 3) 5600-5500 - $100 4) $100 20%-$20 3) NA 6) 5200 20% - 540 7)NIA 3) $100 Employee Cost: 31460 1A1) 23 Plan B Plan C Plan D Employee Premiam- $900/year Employee Premium - $900/year Employee Premium- Cost Share-90/10 In Network Deductible In Network-$200 $1200/year Cost Share 50/50 Out of Net Deductible Out of Net-5700 Co Pay-$20 in network RAC Cost Share-80/20 in network Cost Share -1000 in bet Cost Share40/60 out of net Cost Share 0/100 out of Co Pay-$20 per visit in net net Co Pay-$50 per visit out net No R&C No R&C 1 B 1) 5900 101) 1.D 1) 51200 2) 2) NA 3) 3) 50 4) 4) $600.05-05 3) $) 50 6 6) $200 100%-$300 7 7) 2 vit $20-$40 5) 3) $100 Employee Cost-$1740 281) 5900 201) 2.D: 1) 2) $200 above RC 2 2) 3) NA 3) 4) 55400-5700-55200 10% - 3530 5) NA 6) 14700 50% - 3350 > NA 6) I 1.300 Employee CHIO 939959959399593 4) 3) Situation 2 $S400 Included expenset in network (5200 above R&C) $4700 Included expenses out of network Call RAC) $200 Excluded expenses in network 10 Vrts Situation 3 $21200 Included expenses in network (51000 above RRC) 52500 Included expenses out of network $2.500 Excluded expenses in betwork 20 Visits 2) 3) HA1) 23 >) 4) 5) 6) 9999 JC 1) 5900 2) NA 3) 521200 $200 - $21000 4)52100 204-54200 5) $2500 5200 - 51800 6) $1100604 $1000 7) 20 vit 520 - 5400 3) 52500 Employee Cost: 59.910 401) 2) 3) 1) 3D 1) 51200 2) NA 3) NA (1) 52120000 5) NA (2) $2500 100% - 52500 7) 20* $20 - 3400 D) $25000 4A1) 2) 3) 4) 481) 2 401) 2) 3) 4) Situation 4 5501200 lecluded expenses in betwork ($1000 above RRC) $50700 Included expenses out of network ($1000 above R&C) $5000 Excluded in network expenses (5200 above R&C) 50 visits regular 30 visits specialists 939959 5 Plan A Employee Premium- $600/year Deductible--5500 Cost Share-80/20 Reasonable&Custoza Stesu forme cost calculation 1. Pre 2.Any amount ahow R&C 3. Deductible in mework until gone 4. Colerance in work 5. Deductible out onwort until gano 6. Co Insurance our network 7. Copos 8. Exchestions Situation 1 $600 Included expenses in network all R&C $200 Included expenses out of network R&C $300 Excluded expenses 2 Visits Plan B Plan C Plan D Employee Premium-500year Employee Premkim-$900 year Froployee Premiam Cost Share90/10 In Network Deductible In Network-$200 $1200/year Cost Share-50/50 Out of Net Deductible Out of Net-$700 Co Pay $20 mn network R&C Cost Share-8020 in network Cost Share -100.0 in net Cost Share-40/60 out of net Cost Share 0/100 out of Co Pay$20 per visitin net net Co Pay 550 per vitit out net No R&C No Rec 1-3: 1) 5900 1) 5900 1-D 1) 51200 2) NA 2 2) NA 3) (1) 5000 $ 3) 3) NA 4) 4) 4) (1) 560005650 5) 5) 3)NA 6 (2) $200*100% - 5200 7) 2520 - $10 ) 33) 3300 Employee Cost-$1780 2600 2C 1) 5900 2.D: 1) 51200 2) 1300 Ahora RAC NA 15400-RC-1300-50>) ) NA 5) 570030612350 14 ne 1000 Employee Expen: 54170 1-A 1) 5600 2) NA 3) (1) 5600 $500-100 4) (1) 5100 209-520 5) (2) Paid in full 6) $200 20% - 540 7) no co-pays (5) 8 $300 Employee Expense: $1460 2A1) 5600 2) $200 Above R&C 3) (1) 5600-5500 - 5100 4) (1) 5100 20% $20 3) NA 6) (2) 54700 - 20% ) 82 939 Situation 2 $5400 Included expenses in network (S200 above R&C) $4700 Included expenses out of actwork (all RAC) $200 Excluded expenses in network 10 Visits MAGAGES 999999 3.A: ) 2) 3) 3-3: 1) 2) 3) 4 Situation 3 $21200 Included expenses in network (51000 above R&C) $2500 Included expenses out of network $2.500 Excluded expenses in network 20 Visits 99999 30:1) 300 31000 30) (21200-1200) $21000 (b) 021200-1300) 21000 2016 14200 5) ) 52500-5700 51800 6) $2500 - $100 $1800 60% $100 7)(4) 2030 - 5400 052300 RAH CHIA 4.C: ) 2 3-D: 1) 51200 2) NA 3) NA 4) (1) $21.200.0% 50 3) NA 6) (2) 52500 100%-2500 7) 20 $20 - 5000 8) $2500 Employee Cost: 56600 4.D. 1) 2) 4A 1) 2) 3) 4050 2) 1000 11001 - 13000 ANA 4 (1) 501200 - 51000 500000 100- 33200 NA 4) 5) Situation 4 $501200 Included expenses in network (51000 above R&C) $50200 Included expenses out of network (51000 above R&C) $5000 Excluded in network expenses ($200 above R&C) 50 visits regular 30 valits specialists ASRORO 0700-1000 540/700- 1340 7) Nec 1) 35000 Employee 2950 Plan A Employee Premium $600/year Deductible-$500 Cost Share-80/20 Reasonables Customax ps for employee costs calculation Premium Any amount above R&C Deductible in network w gone Co Insurance % in nework Deductible out network until gone Co-Insurance % out network Copas Ecchesion ituation 1 500 Included expenses in network all R&C 200 Included expenses out of network RAC -300 Excluded expenses Visits 1.A 1) 5600 2) 0 3) 5600-5500 - $100 4) $100 20%-$20 3) NA 6) 5200 20% - 540 7)NIA 3) $100 Employee Cost: 31460 1A1) 23 Plan B Plan C Plan D Employee Premiam- $900/year Employee Premium - $900/year Employee Premium- Cost Share-90/10 In Network Deductible In Network-$200 $1200/year Cost Share 50/50 Out of Net Deductible Out of Net-5700 Co Pay-$20 in network RAC Cost Share-80/20 in network Cost Share -1000 in bet Cost Share40/60 out of net Cost Share 0/100 out of Co Pay-$20 per visit in net net Co Pay-$50 per visit out net No R&C No R&C 1 B 1) 5900 101) 1.D 1) 51200 2) 2) NA 3) 3) 50 4) 4) $600.05-05 3) $) 50 6 6) $200 100%-$300 7 7) 2 vit $20-$40 5) 3) $100 Employee Cost-$1740 281) 5900 201) 2.D: 1) 2) $200 above RC 2 2) 3) NA 3) 4) 55400-5700-55200 10% - 3530 5) NA 6) 14700 50% - 3350 > NA 6) I 1.300 Employee CHIO 939959959399593 4) 3) Situation 2 $S400 Included expenset in network (5200 above R&C) $4700 Included expenses out of network Call RAC) $200 Excluded expenses in network 10 Vrts Situation 3 $21200 Included expenses in network (51000 above RRC) 52500 Included expenses out of network $2.500 Excluded expenses in betwork 20 Visits 2) 3) HA1) 23 >) 4) 5) 6) 9999 JC 1) 5900 2) NA 3) 521200 $200 - $21000 4)52100 204-54200 5) $2500 5200 - 51800 6) $1100604 $1000 7) 20 vit 520 - 5400 3) 52500 Employee Cost: 59.910 401) 2) 3) 1) 3D 1) 51200 2) NA 3) NA (1) 52120000 5) NA (2) $2500 100% - 52500 7) 20* $20 - 3400 D) $25000 4A1) 2) 3) 4) 481) 2 401) 2) 3) 4) Situation 4 5501200 lecluded expenses in betwork ($1000 above RRC) $50700 Included expenses out of network ($1000 above R&C) $5000 Excluded in network expenses (5200 above R&C) 50 visits regular 30 visits specialists 939959 5 Plan A Employee Premium- $600/year Deductible--5500 Cost Share-80/20 Reasonable&Custoza Stesu forme cost calculation 1. Pre 2.Any amount ahow R&C 3. Deductible in mework until gone 4. Colerance in work 5. Deductible out onwort until gano 6. Co Insurance our network 7. Copos 8. Exchestions Situation 1 $600 Included expenses in network all R&C $200 Included expenses out of network R&C $300 Excluded expenses 2 Visits Plan B Plan C Plan D Employee Premium-500year Employee Premkim-$900 year Froployee Premiam Cost Share90/10 In Network Deductible In Network-$200 $1200/year Cost Share-50/50 Out of Net Deductible Out of Net-$700 Co Pay $20 mn network R&C Cost Share-8020 in network Cost Share -100.0 in net Cost Share-40/60 out of net Cost Share 0/100 out of Co Pay$20 per visitin net net Co Pay 550 per vitit out net No R&C No Rec 1-3: 1) 5900 1) 5900 1-D 1) 51200 2) NA 2 2) NA 3) (1) 5000 $ 3) 3) NA 4) 4) 4) (1) 560005650 5) 5) 3)NA 6 (2) $200*100% - 5200 7) 2520 - $10 ) 33) 3300 Employee Cost-$1780 2600 2C 1) 5900 2.D: 1) 51200 2) 1300 Ahora RAC NA 15400-RC-1300-50>) ) NA 5) 570030612350 14 ne 1000 Employee Expen: 54170 1-A 1) 5600 2) NA 3) (1) 5600 $500-100 4) (1) 5100 209-520 5) (2) Paid in full 6) $200 20% - 540 7) no co-pays (5) 8 $300 Employee Expense: $1460 2A1) 5600 2) $200 Above R&C 3) (1) 5600-5500 - 5100 4) (1) 5100 20% $20 3) NA 6) (2) 54700 - 20% ) 82 939 Situation 2 $5400 Included expenses in network (S200 above R&C) $4700 Included expenses out of actwork (all RAC) $200 Excluded expenses in network 10 Visits MAGAGES 999999 3.A: ) 2) 3) 3-3: 1) 2) 3) 4 Situation 3 $21200 Included expenses in network (51000 above R&C) $2500 Included expenses out of network $2.500 Excluded expenses in network 20 Visits 99999 30:1) 300 31000 30) (21200-1200) $21000 (b) 021200-1300) 21000 2016 14200 5) ) 52500-5700 51800 6) $2500 - $100 $1800 60% $100 7)(4) 2030 - 5400 052300 RAH CHIA 4.C: ) 2 3-D: 1) 51200 2) NA 3) NA 4) (1) $21.200.0% 50 3) NA 6) (2) 52500 100%-2500 7) 20 $20 - 5000 8) $2500 Employee Cost: 56600 4.D. 1) 2) 4A 1) 2) 3) 4050 2) 1000 11001 - 13000 ANA 4 (1) 501200 - 51000 500000 100- 33200 NA 4) 5) Situation 4 $501200 Included expenses in network (51000 above R&C) $50200 Included expenses out of network (51000 above R&C) $5000 Excluded in network expenses ($200 above R&C) 50 visits regular 30 valits specialists ASRORO 0700-1000 540/700- 1340 7) Nec 1) 35000 Employee 2950