Finding Percentage
 

I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12


Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it. Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

--
Thank you,
Eric Vogel

Finding Percentage
 

But the price for the Family has come down, so this will reduce the
overall percentage increase.

Pete

On Apr 19, 3:24 pm, "Eric C. Vogel [Win Live! MVP]"
wrote:
I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12

Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it. Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

--
Thank you,
Eric Vogel

Finding Percentage
 

When comparing percentages, you have to look at the base as well as the
percent change.

A 15% increase on a $350 base is $52

A 12% decrease on a $750 base is -$90.

So the net change for one family plan and two individual employee plans
is nearly a wash.




In article ,
"Eric C. Vogel [Win Live! MVP]" wrote:

I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12


Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it. Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

Finding Percentage
 

Thanks thats it. That was the Employee + 2 childs I am not used to this
carrier. I needed Employee + Spouse + 1 Child. We only do 3-4 tears in our
spreadsheets and this one has 8 tiers. Up to 14.3% change.

--
Thank you,
Eric Vogel ~Windows Live! MVP~
http://www.msmvps.com/shelluser
http://shelluser.mvps.org
http://msn.mvps.org
"Pete_UK" wrote in message
oups.com...
But the price for the Family has come down, so this will reduce the
overall percentage increase.

Pete

On Apr 19, 3:24 pm, "Eric C. Vogel [Win Live! MVP]"
wrote:
I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12

Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it.
Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

--
Thank you,
Eric Vogel

Finding Percentage
 

You're welcome - thanks for feeding back.

Pete

On Apr 19, 7:11 pm, "Eric C. Vogel [Win Live! MVP]"
wrote:
Thanks thats it. That was the Employee + 2 childs I am not used to this
carrier. I needed Employee + Spouse + 1 Child. We only do 3-4 tears in our
spreadsheets and this one has 8 tiers. Up to 14.3% change.

--
Thank you,
Eric Vogel ~Windows Live! MVP~http://www.msmvps.com/shelluserhttp://shelluser.mvps.orghttp://msn.mvps.org"Pete_UK" wrote in message

oups.com...



But the price for the Family has come down, so this will reduce the
overall percentage increase.

Pete

On Apr 19, 3:24 pm, "Eric C. Vogel [Win Live! MVP]"
wrote:
I have tried and tried.

If you look at the cost of these two plans there is a 13-14% increase

Plan 2006 rates
Employee 345.31
Employee and Spouse 685.22
Employee and Child 464.01
Family 747.27

Plan 2007 rates
Employee 396.47
Employee and Spouse 775.97
Employee and Child 530.30
Family 659.12

Employees = 3
Emp and child = 2
Family = 1

Rate is (employee rate * employee count) + (Employee & spouse rate *
count).... and so on to get the medical.

then the totoal is medical + rx (Not listed cause they do not have it.
Then
is * by 12 to get the annual which is the figure below.

The annual cost for 2006 comes out to (B62) 32,535 and 2007 (D72) 34,982

I converted to just deviding then /100 to
=IF(B48=0,0,(B62-D62)/ABS(B62))
I still get a ~8% figure

Look at the individual costs between the years for employee and such and
there is a higher ~ 13-15% difference.

--
Thank you,
Eric Vogel- Hide quoted text -

- Show quoted text -