plzzzz help me with this hard assignment.?
A company health plan offers four alternatives for coverage, from a low-cost plan with a high deductible to a high-cost plan with a low deductible. The details of coverage are given in the following table.
Plan Options and Costs
Option 1$ 1,500/$ 2,500None$ 1,825$ 3,651$ 4,929
Option 2500/1,00020% 2,016 4,032 5,444
Option 3250/50020% 2,245 4,491 6.063
Option 4100/20010% 2,577 5,154 6,959
The Human Resources Department would like to develop a means to help any employee, whether single or married, small family or large, low medical expenses or high, to compare these plan alternatives.
The deductible amount is paid by the employee. The first figure applies to an individual; the second applies to two-person or family coverage. In the case of Option 1, for example, this means that the insurance coverage takes effect once an individual has paid for $ 1,500 worth of expenses. (This limit holds for any individual under two-person or family coverage, as well as for an individual with one-person coverage.) In the case of two-person or family coverage, the insurance also takes effect once the household has incurred $ 2,500 worth of expenses.
The co-insurance is the percentage of expenses that must be paid by the employee when the insurance coverage takes effect. In the case of Option 2, for example, this means that the insurance covers 80 percent of all expenses after the deductible amount has been reached.
The Annual Premium is the cost of the insurance to the employee.
a. Consider the case of a single employee with estimated annual expenses of $ 400. What plan is the cheapest? What is the total annual cost associated with this plan?
b. For the analysis in (a), construct a table to show the best plan and the associated cost for annual expenses ranging from $ 100 to $ 1,200 in steps of $ 100.
c. Consider the case of a married employee with estimated annual expenses of $ 1,000 and an equal amount for the spouse. What plan is the cheapest? What is the total annual cost associated with this plan?
d. For the analysis in (c), construct a table to show the best plan and the associated cost for annual expenses ranging from $ 100 to $ 1,500 in steps of $ 100 for the employee assuming that the employee’s expenses and the spouse’s expenses as they change are the same.
e. For the analysis in (d), find the level of expenses at which the cost is the same under Plan1 and Plan 2.