In cell J36 of the PremiumCoverageLowActivity worksheet, calculate the total of costs after limit to MAX out-of-pocket. Since the values in this field are a running total, the total cost is the value in column J for the last claim. [0.5 points]
BLUEBEAM Tell me what you want to do Share File Heme Insert Page Layout Formulas Data Review View Help Assignment Assignment Tasks fx Define Name - Trace Pracadents .. Trace Dependents Remove Arrows Health Insurance Use in Formula - AutoSum Rad acehy Hinancial Logical Text Create from Selection In cell J36 of the PremiumCoverageLowActivity worksheet, calculate the total of costs after 26 limit to MAX out-of-pocket. Since the values this field are a running total, the total cost Celined Names Functicun utry is the value in column J for the last claim, [0.5 points 37 E A D H M N Maximum out pockct 6,600 12 Type Deductible Co-Pay 13 Co-Ins Primary dactor Other doctorS 14 20 A 15 4 Eiergericy room Hos 250 20% D vice 20% 18 total Premium Expense 19 Iotal Medical Payments 20 Lotal Medical Cost 21 22 Payment Cast after limit to. MAX out-of- Claim towards Potential Cost Insured 23 Month Description Amount Copayment Deductible Coinsurance Pockat 24 20 S 20 Primary Ductur 02 250 $ 10 20 S Cmergency Room & Lab tests 241 S 991 $ 26 March C 00 991 366 S April 0 S 10 S 27 Dermatologist office visit E 0 20 S Primary Doctor A S 20 545 S 40 29 Urolopist office visit May H 40 40 5 175 S 80 S 250 $ 40S 20 S 40 S 20 S 1 une o Doctor exan m 20 S 0 S 32 July Primary Docton 20 August 0 9 40 S 3 Physical Therapist office visit 40 0 S 20 $ 4 December Primary Dactor A S 20 35 3,443 Totals 1.251 Summary CalastrupheCoveragelowActivily CalastropheCoverageWithSurgery PremiumCoverageLowActivity BLUEBEAM Tell me what you want to do Share File Heme Insert Page Layout Formulas Data Review View Help Assignment Assignment Tasks fx Define Name - Trace Pracadents .. Trace Dependents Remove Arrows Health Insurance Use in Formula - AutoSum Rad acehy Hinancial Logical Text Create from Selection In cell J36 of the PremiumCoverageLowActivity worksheet, calculate the total of costs after 26 limit to MAX out-of-pocket. Since the values this field are a running total, the total cost Celined Names Functicun utry is the value in column J for the last claim, [0.5 points 37 E A D H M N Maximum out pockct 6,600 12 Type Deductible Co-Pay 13 Co-Ins Primary dactor Other doctorS 14 20 A 15 4 Eiergericy room Hos 250 20% D vice 20% 18 total Premium Expense 19 Iotal Medical Payments 20 Lotal Medical Cost 21 22 Payment Cast after limit to. MAX out-of- Claim towards Potential Cost Insured 23 Month Description Amount Copayment Deductible Coinsurance Pockat 24 20 S 20 Primary Ductur 02 250 $ 10 20 S Cmergency Room & Lab tests 241 S 991 $ 26 March C 00 991 366 S April 0 S 10 S 27 Dermatologist office visit E 0 20 S Primary Doctor A S 20 545 S 40 29 Urolopist office visit May H 40 40 5 175 S 80 S 250 $ 40S 20 S 40 S 20 S 1 une o Doctor exan m 20 S 0 S 32 July Primary Docton 20 August 0 9 40 S 3 Physical Therapist office visit 40 0 S 20 $ 4 December Primary Dactor A S 20 35 3,443 Totals 1.251 Summary CalastrupheCoveragelowActivily CalastropheCoverageWithSurgery PremiumCoverageLowActivity
