Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the formula? Use a VLOOKUP function in cell F25 of the CatastropheCoverageLowActivity worksheet to determine the appropriate Copayment for the first visit to
What is the formula? Use a VLOOKUP function in cell F25 of the CatastropheCoverageLowActivity worksheet to determine the appropriate Copayment for the first visit to a Primary Doctor. The Type in cell D25 is one of the parameters. Use absolute and relative references when appropriate
UnitedHealthcare Catastrophic Compass Plus 6600 Single Adult Age 22 -Monthly prenium $160-Deductible $6,600-0ut-ol-pocket maximum $6,600 Copayment Primary doctor-$50 Copayment Specialist Dactor $100 Ernergency Room No charge after deductible Hospital Services No charge after deductible Lab Services No chargeafter doductible Assignment Tasks Health Insurance Monthly premium Maximum out-ofpocket 5 160 6,500 Use a VLOOKUP function in cell F25 of the CatastrophrCoveragclowActivity worksheet to determine the appropriate Copayment for the first visit to a Primary Doctor. The "Type" in cell D25 is one of the 12 13 14 1 Type Deductible Co-Pay arameters. Use absolute and relative references when a rlate [1 Primary doctor Other doctors Emergency ropm 16 17 C $ 6,600$ 19 Total Premium Expense Total Medical Payments 21 al Medical Cost Cost after limit to MAX out of Potential Cost M 23 24 25 26 27 28 Descriptian Type Amount Capayment Deductible Coinsurance to Insured January Primary Doctor Emergency Room & Lab tests Dermatologist officevisit Primary Doctor Uralogist office visit Primary Doctor Eye Doctor exam Primary Doctor Physical Therapist affice visit G24 C $ 1,707 $ 366 B $545 B S175 B 250 April 31 August Drcembe Primary Doctor Totals 37 38
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started