FINGERTIP REPORT: A -  PIHP MEDICAID COST SUMMARY
Period: 10/1/2007 - 9/30/2008
During Fiscal Year 2008 (October 1, 2007 -September 30, 2008) PIHP Mental Health/Developmental Disabilities/Substance Abuse Medicaid revenues totaled $1,723,525,743.  Medicaid spending on services and administration totaled $1,682,971,496. Approximately 7 percent of the total Medicaid expenditures was administrative costs.  For revenue and expenditure information for mental health and developmental disability (MH/DD) only, click here.
			Medicaid MH/DD/SA Total Expenditures		Medicaid Managed Care MH/DD/SA Administration Expenditures					Lapse3
PIHP	Medicaid Revenue MH/DD/SA	Total MH/DD/SA Medicaid Cases	Amount1	$$/ Consumer	Amount	Percent of Total Medicaid Revenue	$$/ Consumer	Savings at Year End	Internal Services Fund (ISF)2
Access Alliance	$       71,581,675	7,320	$        67,435,083	$           9,212	$         3,362,271	4.70%	$         459	$    2,855,765	$     5,370,155
CMH Affiliation of Mid-MI	$       92,146,332	8,246	$        90,139,455	$        10,931	$         7,194,881	7.81%	$         873	$                     -	$     1,781,830
CMH for Central Michigan	$       57,961,044	6,418	$        55,412,077	$           8,634	$         3,991,243	6.89%	$         622	$                     -	$                      -
Detroit-Wayne	$    372,492,556	40,997	$     398,058,049	$           9,709	$       36,662,720	9.84%	$         894	$                     -	$     8,231,013
Genesee	$       89,455,711	8,412	$        84,392,435	$        10,032	$         6,179,150	6.91%	$         735	$                     -	$         639,897
Lakeshore Affiliation	$       60,597,252	5,637	$        58,337,681	$        10,349	$         3,922,489	6.47%	$         696	$                     -	$     3,454,387
Lifeways	$       32,832,573	4,648	$        32,110,142	$           6,908	$         3,815,710	11.62%	$         821	$    1,429,092	$         687,142
Macomb	$    132,890,231	9,210	$     126,463,294	$        13,731	$         8,090,467	6.09%	$         878	$                     -	$     8,203,187
network180	$       81,839,171	8,227	$        79,826,729	$           9,703	$         5,959,664	7.28%	$         724	$    1,765,016	$     1,810,903
NorthCare	$       77,483,326	4,900	$        69,441,336	$        14,172	$         4,233,144	5.46%	$         864	$    3,753,902	$     3,815,188
Northern Affiliation	$       56,278,180	5,836	$        54,792,223	$           9,389	$         3,481,777	6.19%	$         597	$                     -	$     2,207,389
Northwest	$       45,214,728	5,806	$        45,234,891	$           7,791	$         3,199,929	7.08%	$         551	$                     -	$     2,593,089
Oakland	$    204,470,960	11,339	$     195,326,802	$        17,226	$       11,277,652	5.52%	$         995	$                     -	$     6,252,161
Saginaw	$       38,000,722	3,449	$        36,248,006	$        10,510	$         2,695,534	7.09%	$         782	$                     -	$                      -
Southeast Partnership	$       93,321,417	6,683	$        87,691,556	$        13,122	$         5,764,833	6.18%	$         863	$                     -	$         216,783
Southwest Affiliation	$       78,865,475	7,804	$        71,908,446	$           9,214	$         6,239,992	7.91%	$         800	$    2,011,492	$     5,917,252
Thumb Alliance	$       66,549,468	4,522	$        64,394,600	$        14,240	$         3,900,341	5.86%	$         863	$    2,393,910	$     4,987,465
Venture	$       71,544,922	9,328	$        68,297,373	$           7,322	$         4,103,189	5.74%	$         440	$                     -	$     4,593,221
State Total	$ 1,723,525,743	158,782	$  1,685,510,178	$        10,615	$     124,074,985	7.20%	$         781	$  14,209,177	$   60,761,062	$               -
	Report produced by:		MDCH, Mental Health and Substance Abuse Administration, Performance Measurement Section
	Source data:		Total Medicaid MH/DD/SA Service Expenditures, Total Medicaid Managed Care MH/DD/SA Admin, and Total Cases are taken from the FY 2008 Medicaid Utilization and Net Cost (MUNC) Reports. Revenue, Savings, ISF and lapse taken from FY08 financial status report (FSR)
		File:	G:\QMP\Fingertip Reports\Fingertip Report August 2009.xls
	Data extract date:		Data from MUNC updated as of 8/6/2009.  Data from FSR dated 3/2009.
	Report Date:		8/11/2009
	Notes/Comments:		1Medicaid MH/DD/SA Total Expenditures includes General Fund expenditures used for spend-down for certain PIHPs.
			2The balances for the Internal Services Funds have been calculated following any settlement for cost overruns.
			3 There were no lapses for FY08 as of this report date.