FY 2018 Funding Formula Booklet 2_21_18

MISSISSIPPI PUBLIC COMMUNITY AND JUNIOR COLLEGS HEALTH AND LIFE INSURANCE S.B. 2964 FY 2018

FY 2017 Est. (July 2016 - June 2017

Life and Health Life and Health Total Life and Insurance from Insurance from Health from

Percentage of Life and Health Costs to Total

PROJECTED PROJECTED Total Projected

Avg. No.) HEALTH FY 2018 COST PER INSURANCE PARTICIPANT PARTICIPANTS PER YEAR

COST OF COST OF LIFE

Cost of Life

the General

the Carryover

General and

DISTRICT

HEALTH INS INSURANCE & Health Ins.

Fund

Fund

Carryover Funds

Life & Health Costs

356

COAHOMA

165.0 275.0 214.0 288.0 965.0 365.0 381.0 345.0 289.0 240.0 648.0 260.0 510.0 360.0 195.0

4,272

704,880 1,174,800 914,208 1,230,336 4,122,480 1,559,280 1,627,632 1,473,840 1,234,608 1,025,280 2,768,256 1,110,720 2,178,720 1,537,920 833,040 23,496,000

14,644 21,360 14,368 25,723 84,281 21,985 25,046 27,620 19,471 19,845 57,957 21,081 42,870 28,724 15,025

719,524 1,196,160 928,576 1,256,059 4,206,761 1,581,265 1,652,678 1,501,460 1,254,079 1,045,125 2,826,213 1,131,801 2,221,590 1,566,644 848,065

3.01% 719,524 5.00% 1,196,160 3.88% 928,576 5.25% 1,256,059 17.58% 3,826,761 6.61% 1,581,265 6.90% 1,652,678 6.27% 1,501,460 5.24% 1,254,079 4.37% 1,045,125 11.81% 2,826,213 4.73% 1,131,801 9.28% 2,221,590 6.55% 1,566,644 3.54% 848,065 100.00% 23,556,000

0 0 0 0 0 0 0 0 0 0 0 0 0 0

719,524 1,196,160 928,576 1,256,059 4,206,761 1,581,265 1,652,678 1,501,460 1,254,079 1,045,125 2,826,213 1,131,801 2,221,590 1,566,644 848,065 23,936,000

COPIAH-LINCOLN EAST CENTRAL EAST MISSISSIPPI

HINDS

380,000

HOLMES ITAWAMBA MERIDIAN MISS. DELTA JONES

MISS. GULF COAST NORTHEAST MISS NORTHWEST MISS

PEARL RIVER

SOUTHWEST MISS

TOTAL

5500.0

4,272

440,000 23,936,000.00

380,000

2/20/2018F:\18ftefundingformula_final_8_11_17

31