Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have just been hired by XZU's financial planning department. Your first job is to help XZU determine how much money XZU should accrue on

image text in transcribed
image text in transcribed
image text in transcribed
You have just been hired by XZU's financial planning department. Your first job is to help XZU determine how much money XZU should accrue on a monthly basis to pay for its employees' health insurance claims. As a large multi-campus private university, it is self-insured, which means that it pays health insurance claims with its own money (although it contracts with BC/BS to handle the administrative details of processing claims and handling checks). The money XZU uses to pay claims comes from two sources: employee contributions (or premiums deducted from employees' paychecks), and university funds (XZU must pay whatever costs are not covered by employee contributions). Each employee who is covered by the health plan contributes $475 per month; however, the number of employees covered changes from month to month as employees are hired, fired, quit, or simply drop health insurance coverage. Historically, the month to month change in covered employees is given in the table below: A total of 22,000 employees are currently covered by the plan. The average monthly health claim per covered employee is normally distributed with a mean of $625 and a standard deviation of $20. Determine within a margin of error of 1% the average amount of money XZU should set aside each month to cover the balance of employee health cost claims. XZU prefers to plan a fixed monthly amount to set aside each month with the expectation that at the end of the year they will have covered their health care liabilities. [HINT: set up a simulation table with each row representing a month. Assume that during the first month of the simulation you have 22,000 employees covered. The last column should contain the net amount that XYZ will have to pay that month (EMPLOYEE CONTRIBUTIONS HEALTH COST CLAIMS, which is a negative number). Then estimate the true average of that amount within 1% ]. For a sample of 60 , what is the confidence level (in \$) in the estimate of the true average difference between employee contributions and claims (positive number)? (Do not use \$symbol and round answer to two decimal places) For a sample of 60 , what is the amount that XYZ will not have to exceed in payments in any given month with a probability of 2.5% ? (Do not use $ symbol and round answer to two decimal places) You have just been hired by XZU's financial planning department. Your first job is to help XZU determine how much money XZU should accrue on a monthly basis to pay for its employees' health insurance claims. As a large multi-campus private university, it is self-insured, which means that it pays health insurance claims with its own money (although it contracts with BC/BS to handle the administrative details of processing claims and handling checks). The money XZU uses to pay claims comes from two sources: employee contributions (or premiums deducted from employees' paychecks), and university funds (XZU must pay whatever costs are not covered by employee contributions). Each employee who is covered by the health plan contributes $475 per month; however, the number of employees covered changes from month to month as employees are hired, fired, quit, or simply drop health insurance coverage. Historically, the month to month change in covered employees is given in the table below: A total of 22,000 employees are currently covered by the plan. The average monthly health claim per covered employee is normally distributed with a mean of $625 and a standard deviation of $20. Determine within a margin of error of 1% the average amount of money XZU should set aside each month to cover the balance of employee health cost claims. XZU prefers to plan a fixed monthly amount to set aside each month with the expectation that at the end of the year they will have covered their health care liabilities. [HINT: set up a simulation table with each row representing a month. Assume that during the first month of the simulation you have 22,000 employees covered. The last column should contain the net amount that XYZ will have to pay that month (EMPLOYEE CONTRIBUTIONS HEALTH COST CLAIMS, which is a negative number). Then estimate the true average of that amount within 1% ]. For a sample of 60 , what is the confidence level (in \$) in the estimate of the true average difference between employee contributions and claims (positive number)? (Do not use \$symbol and round answer to two decimal places) For a sample of 60 , what is the amount that XYZ will not have to exceed in payments in any given month with a probability of 2.5% ? (Do not use $ symbol and round answer to two decimal places)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Fiscal Impact Handbook

Authors: David Listokin

1st Edition

1138535672, 978-1138535671

More Books

Students also viewed these Finance questions

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago