FINGERTIP REPORT: A - PIHP MEDICAID COST SUMMARY
Period: 10/1/2006 - 9/30/2007
During Fiscal Year 2007 (October 1, 2006 -September 30, 2007) PIHP Mental Health/Developmental Disabilities Medicaid revenues totaled $1,634,037,062. Medicaid spending on services and administration totaled $1,572,001,651. Approximately seven percent of the revenue ($110,998,414) was spent on administrative costs (calculated based on costing principles established by the Encounter Data Integrity Team, see Establishing Managed Care Administrative Costs). The average Medicaid total cost per consumer was $10,998 and the average administrative cost was $777 per consumer.
			Medicaid MH/DD Total Expenditures		Medicaid Managed Care MH/DD Administration Expenditures						Lapse
PIHP	Medicaid Revenue MH/DD	Total MH/DD Medicaid Cases	Amount¹	$$/ Consumer	Amount	Percent of Total Medicaid Revenue	$$/ Consumer	Savings at Year End	Internal Services Fund (ISF)²	Lapse FY06	Lapse
Access Alliance	$ 65,428,675	6,533	$ 60,060,198	$ 9,193	$ 2,731,088	4.17%	$ 418	$ 2,719,723	$ 4,982,579
CMH Affiliation of Mid-Michigan	$ 90,077,022	8,111	$ 86,772,147	$ 10,698	$ 7,006,288	7.78%	$ 864	$ 1,960,946	$ 1,902,847
CMH for Central Michigan	$ 55,536,547	5,261	$ 54,792,414	$ 10,415	$ 3,910,475	7.04%	$ 743	$ -	$ -
Detroit-Wayne	$ 363,707,614	33,781	$ 355,984,340	$ 10,538	$ 31,123,251	8.56%	$ 921	$ -	$ 25,531,663
Genesee	$ 77,783,582	7,114	$ 78,249,051	$ 10,999	$ 4,913,673	6.32%	$ 691	$ -	$ -
Lakeshore Affiliation	$ 58,357,203	4,589	$ 55,554,508	$ 12,106	$ 4,214,982	7.22%	$ 918	$ -	$ -
Lifeways	$ 30,650,752	7,802	$ 29,794,409	$ 3,819	$ 2,877,185	9.39%	$ 369	$ -	$ 638,329
Macomb	$ 128,727,736	6,995	$ 119,297,727	$ 17,055	$ 8,050,457	6.25%	$ 1,151	$ 1,887,319	$ 6,942,482
network180	$ 77,068,897	7,064	$ 71,298,601	$ 10,093	$ 4,538,417	5.89%	$ 642	$ 3,844,839	$ 1,496,423
North Care	$ 74,116,768	7,089	$ 67,848,913	$ 9,571	$ 4,086,761	5.51%	$ 576	$ 1,807,416	$ 866,484
North Country	$ 55,365,236	5,379	$ 51,748,391	$ 9,620	$ 3,116,970	5.63%	$ 579	$ 1,237,558	$ 2,636,854
Northern Lakes	$ 45,217,213	4,875	$ 41,415,636	$ 8,496	$ 2,984,097	6.60%	$ 612	$ 1,122,425	$ 3,415,912
Oakland	$ 187,515,332	10,118	$ 188,485,237	$ 18,629	$ 11,509,395	6.14%	$ 1,138	$ -	$ 3,780,781
Saginaw	$ 31,316,037	3,002	$ 29,742,421	$ 9,908	$ 2,595,634	8.29%	$ 865	$ -	$ -
Southeast Partnership	$ 82,457,241	6,025	$ 82,313,901	$ 13,662	$ 4,743,459	5.75%	$ 787	$ -	$ -
Southwest Affiliation	$ 75,464,826	6,937	$ 68,872,650	$ 9,928	$ 5,332,082	7.07%	$ 769	$ -	$ -
Thumb Alliance³	$ 65,878,966	4,174	$ 62,312,635	$ 14,929	$ 4,054,696	6.15%	$ 971	$ 3,715,263	$ 5,001,743	########	$381,327
Venture	$ 69,367,416	8,083	$ 67,458,472	$ 8,346	$ 3,209,504	4.63%	$ 397	$ 224,977	$ 5,304,076
State Total	$ 1,634,037,062	142,932	$ 1,572,001,651	$ 10,998	$ 110,998,414	6.79%	$ 777	$ 18,520,466	$ 62,500,173	########	$381,327

	Report produced by:		MDCH, Mental Health and Substance Abuse Administration, Performance Measurement Section
	Source data:		Total Medicaid MH/DD Service Expenditures, Total Medicaid Managed Care MH/DD Admin, and Total Cases are taken from the FY 2007 Medicaid Utilization and Net Cost (MUNC) Reports. Revenue, Savings, ISF and lapse taken from FY07 financial status report (FSR) and contract reconciliation cost settlement as reported in the FSR subject to the review of MDCH accounting FY07.
		File:	G:\QMP\Fingertip Reports\Fingertip_Report_July 2008.xls
	Data extract date:		Data from MUNC updated 3/15/2008. Data from FSR dated 10/2007.
	Report Date:		6/19/2008
	Notes/Comments:		¹Medicaid MH/DD Total Expenditures excludes General Fund expenditures used for spend-down.
			²The balances for the Internal Services Funds have been calculated following any settlement for cost overruns.
			³ Thumb Alliance had a lapse of $381,327.