Plz help me with the question. It needs to be performed in excel.?

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
Annual Premium
Deductible Co-insurance 1-Person 2-Pe...
Option 1 $1,500/$2,500 None $1,825 $3,651 $4,92...
Option 2 500/1,000 20% 2,016 4,032 5,444
Option 3 250/500 20% 2,245 4,491 6.063
Option 4 100/200 10% 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鈥檚 expenses and the spouse鈥檚 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.

sorry, i am confused!!