“Your Healthcare Costs”
The purpose of this exercise is to help you understand how healthcare plans work. You will be given a spreadsheet, and will be asked to explore different medical outcomes. This will help inform which healthcare plans would work best for you (or your future employees).
Instructions:
Read the case below and answer each question.
IF Statement Reminder:
=IF ( Condition , Value if True, Value if False )
Is D2 = “Gryffindor”?
If True, then give 10 points. If false, give 0 points
Open the Excel spreadsheet. Be mindful of the different colors.
· This color represents your healthcare plan
· This color represents your medical costs
· This color is how much you can expect to pay under your different plans
Answer the following questions.
1. Look at the formula inside the following columns. Pretend you are explaining the formulas to an Excel novice. How would you explain what the formulas in the following cells are doing?
|
Deductible Paid (B26, C26, or D26) |
|
|
Remaining Medical Expenses (B28, C28, or D28) |
|
|
Remaining Medical Expenses You Must Pay (B29, C29, or D29) |
|
|
Total Expenses (B36, C36, |
2. Experiment with the different example medical costs. Think about your own medical history. Which plan would you prefer and why?
3. Imagine you have an employee (or friend) who has a lot of frequent visits to the same in-network professional (see “Sample Plans Tab” to see different plans). Which would you recommend and why?
4. Imagine you have an employee (or friend) who requires lots of visits to different specialists (some potentially out of network; see “Sample Plans Tab” to see different plans). Which would you recommend and why?
5. Which plan would be the best if you are healthy and expect very few medical costs. Why do you think that is?
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more