Page 48 - Erlanger Health System
P. 48
ACTUARIAL
Plug and play: cost impact sample
Plug and Play: Cost Impact Sample
Sample client
This roll-up page shows multiple views of total cost, employee cost and company net cost.
You can change assumptions in the model and glance at this page to determine if you achieve a desired result.
Total / Gross Cost Employee Cost ABC Company Net Cost
% of Total % of Total
Enrollment Total PEPM Total PEPM Total PEPM
2019 Budgeted Costs 508 $6,230,000 $1,022 $1,681,000 $276 27.0% $4,549,000 $746 73.0%
2019 Year End Projected Costs 508 $6,563,000 $1,077 $1,667,000 $274 25.4% $4,895,000 $803 74.6%
2020 Projected Cost - Status Quo 440 $5,949,000 $1,127 $1,536,000 $291 25.8% $4,413,000 $836 74.2%
vs. Budget - $ Change -$281,000 $105 -$145,000 $15 -$136,000 $90 Real time
vs. Budget - % Change -4.5% 10.2% -8.6% 5.5% -3.0% 12.0% summary from
modeling plan
design &
vs. Year End Proj - $ Change -$614,000 $50 -$131,000 $17 -$482,000 $33 contribution
vs. Year End Proj - % Change -9.4% 4.7% -7.9% 6.4% -9.8% 4.1% adjustments
2020 Projected Cost 508 $6,860,000 $1,125 $1,725,000 $283 25.1% $5,136,000 $842 74.9%
vs. Budget - $ Change $630,000 $103 $44,000 $7 $587,000 $96
vs. Budget - % Change 10.1% 10.1% 2.6% 2.6% 12.9% 12.9%
vs. Year End Proj - $ Change $297,000 $49 $58,000 $9 $241,000 $39
vs. Year End Proj - % Change 4.5% 4.5% 3.5% 3.4% 4.9% 4.9%
vs. Status Quo - $ Change $911,000 -$1 $189,000 -$8 $723,000 $7
vs. Status Quo - % Change 15.3% -0.1% 12.3% -2.7% 16.4% 0.8%
3
48 Lockton Companies
Plug and play: cost impact sample
Plug and Play: Cost Impact Sample
Sample client
This roll-up page shows multiple views of total cost, employee cost and company net cost.
You can change assumptions in the model and glance at this page to determine if you achieve a desired result.
Total / Gross Cost Employee Cost ABC Company Net Cost
% of Total % of Total
Enrollment Total PEPM Total PEPM Total PEPM
2019 Budgeted Costs 508 $6,230,000 $1,022 $1,681,000 $276 27.0% $4,549,000 $746 73.0%
2019 Year End Projected Costs 508 $6,563,000 $1,077 $1,667,000 $274 25.4% $4,895,000 $803 74.6%
2020 Projected Cost - Status Quo 440 $5,949,000 $1,127 $1,536,000 $291 25.8% $4,413,000 $836 74.2%
vs. Budget - $ Change -$281,000 $105 -$145,000 $15 -$136,000 $90 Real time
vs. Budget - % Change -4.5% 10.2% -8.6% 5.5% -3.0% 12.0% summary from
modeling plan
design &
vs. Year End Proj - $ Change -$614,000 $50 -$131,000 $17 -$482,000 $33 contribution
vs. Year End Proj - % Change -9.4% 4.7% -7.9% 6.4% -9.8% 4.1% adjustments
2020 Projected Cost 508 $6,860,000 $1,125 $1,725,000 $283 25.1% $5,136,000 $842 74.9%
vs. Budget - $ Change $630,000 $103 $44,000 $7 $587,000 $96
vs. Budget - % Change 10.1% 10.1% 2.6% 2.6% 12.9% 12.9%
vs. Year End Proj - $ Change $297,000 $49 $58,000 $9 $241,000 $39
vs. Year End Proj - % Change 4.5% 4.5% 3.5% 3.4% 4.9% 4.9%
vs. Status Quo - $ Change $911,000 -$1 $189,000 -$8 $723,000 $7
vs. Status Quo - % Change 15.3% -0.1% 12.3% -2.7% 16.4% 0.8%
3
48 Lockton Companies
