FINGERTIP REPORT: A - PIHP MEDICAID COST SUMMARY
Period: 10/1/2004 - 9/30/2005

During Fiscal Year 2005 (October 1, 2004 -September 30, 2005) PIHP Mental Health/Developmental Disabilities Medicaid revenues totaled $1,426,220,154. Medicaid spending on services and administration totaled $1,429,710,805. Approximately eight percent of the revenue ($112,091,589) 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 $11,358 and the average administrative cost was $891 per consumer.
			Medicaid MH/DD Total Expenditures		Medicaid Managed Care MH/DD Administration Expenditures
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
Access Alliance	$ 58,599,645	6,737	$ 57,605,812	$ 8,551	$ 2,984,315	5.09%	$ 443	$ 1,832,825	$ 4,461,112
CMH Affiliation of Mid-Michigan	$ 77,875,987	7,460	$ 77,093,102	$ 10,334	$ 5,732,689	7.36%	$ 768	$ 2,764,975	$ 1,740,301
CMH for Central Michigan	$ 48,846,068	5,254	$ 49,719,532	$ 9,463	$ 3,976,880	8.14%	$ 757	$ 43,155	$ 904,478
Detroit-Wayne	$ 340,573,031	29,886	$ 327,160,014	$ 10,947	$ 38,097,317	11.19%	$ 1,275	$ 14,552,294	$ 25,548,537
Genesee	$ 69,928,922	5,747	$ 69,577,436	$ 12,107	$ 4,789,224	6.85%	$ 833	$ 2,046,612	$ 4,134,381
Lakeshore Affiliation	$ 50,111,531	4,839	$ 50,445,167	$ 10,425	$ 3,401,969	6.79%	$ 703	$ 1,887,944	$ 3,624,497
Lifeways	$ 28,330,951	2,949	$ 29,664,529	$ 10,059	$ 2,838,323	10.02%	$ 962	$ 133,056	$ 1,658,036
Macomb	$ 97,883,085	6,183	$ 101,755,804	$ 16,457	$ 6,943,811	7.09%	$ 1,123	$ -	$ -
network180	$ 64,250,942	7,448	$ 63,762,546	$ 8,561	$ 4,882,733	7.60%	$ 656	$ -	$ 1,365,389
North Care	$ 64,328,795	5,131	$ 63,559,514	$ 12,387	$ 2,868,634	4.46%	$ 559	$ 171,856	$ 763,086
North Country	$ 46,887,877	5,031	$ 45,616,110	$ 9,067	$ 2,954,285	6.30%	$ 587	$ 17,568	$ 2,420,786
Northern Lakes	$ 34,002,467	5,065	$ 36,335,184	$ 7,174	$ 2,345,104	6.90%	$ 463	$ -	$ 2,164,288
Oakland	$ 158,398,688	8,489	$ 172,488,428	$ 20,319	$ 10,179,924	6.43%	$ 1,199	$ -	$ 3,406,503
Saginaw	$ 31,234,055	2,802	$ 31,480,764	$ 11,235	$ 2,654,548	8.50%	$ 947	$ 846,278	$ 1,492,999
Southeast Partnership	$ 76,070,627	5,461	$ 76,901,503	$ 14,082	$ 4,991,488	6.56%	$ 914	$ 2,522,009	$ 1,366,280
Southwest Affiliation	$ 65,502,679	6,019	$ 65,812,970	$ 10,934	$ 4,687,475	7.16%	$ 779	$ -	$ 2,554,386
Thumb Alliance³	$ 56,290,974	3,762	$ 53,067,175	$ 14,106	$ 4,579,161	8.13%	$ 1,217	$ 4,252,332	$ 4,274,322	$ 1,404,256
Venture	$ 57,103,830	7,611	$ 57,665,215	$ 7,577	$ 3,183,709	5.58%	$ 418	$ 1,915,762	$ 4,284,725
State Total	$ 1,426,220,154	125,874	$ 1,429,710,805	$ 11,358	$ 112,091,589	7.86%	$ 891	$ 32,986,666	$ 66,092,815	$ 1,404,256

	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 2005 Medicaid Utilization and Net Cost (MUNC) Reports. Revenue, Savings, ISF and lapse taken from FY05 financial status report (FSR) and contract reconciliation cost settlement as reported in the FSR subject to the review of MDCH accounting FY06.
		File:	G:\QMP\Fingertip Reports\Fingertip_Report_August 2007.xls
	Data extract date:		Data from MUNC updated 6/21/ 2006. Data from FSR dated 2/4/2007.
	Report Date:		2/21/2007
	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.
			³During FY05, Thumb Alliance had a lapse of $1,404,256