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 Medicaid revenues totaled $1,684,590,157 .  Medicaid spending on services and administration totaled $120,151,207. Approximately 7 percent of the total Medicaid revenue was used for administrative costs.
      Medicaid MH/DDTotal Expenditures  Medicaid Managed Care MH/DD
Administration Expenditures
PIHP Medicaid Revenue
MH/DD		 Total
MH/DD
Medicaid Cases		 Amount1 $$/
Consumer		 Amount Percent of Total Medicaid Revenue $$/
Consumer
Access Alliance  $             70,177,229 7,320  $        66,067,391  $           9,026  $            3,095,133 4.41%  $             423
CMH Affiliation of Mid-MI  $             90,712,925 6,887  $        88,846,893  $        12,901  $            7,072,931 7.80%  $          1,027
CMH for Central Michigan  $             57,041,155 5,240  $        54,765,185  $        10,451  $            3,891,297 6.82%  $             743
Detroit-Wayne  $          360,924,282 36,567  $     386,152,201  $        10,560  $          35,509,674 9.84%  $             971
Genesee  $             86,357,678 7,374  $        82,449,788  $        11,181  $            6,036,911 6.99%  $             819
Lakeshore Affiliation  $             59,369,098 4,682  $        57,407,518  $        12,261  $            3,822,391 6.44%  $             816
Lifeways  $             32,114,971 4,036  $        31,452,627  $           7,793  $            3,693,834 11.50%  $             915
Macomb  $          129,770,112 7,752  $     124,638,509  $        16,078  $            7,837,267 6.04%  $          1,011
network180  $             79,888,181 7,539  $        77,922,068  $        10,336  $            5,612,771 7.03%  $             744
NorthCare  $             76,590,927 4,278  $        68,682,089  $        16,055  $            4,095,329 5.35%  $             957
North Country  $             55,046,778 5,201  $        53,915,479  $        10,366  $            3,344,925 6.08%  $             643
Northwest  $             44,360,625 5,302  $        44,488,128  $           8,391  $            3,079,507 6.94%  $             581
Oakland  $          201,217,341 10,492  $     193,422,922  $        18,435  $          11,069,218 5.50%  $          1,055
Saginaw  $             36,655,685 3,001  $        35,052,545  $        11,680  $            2,695,534 7.35%  $             898
Southeast Partnership  $             91,738,348 5,931  $        86,353,965  $        14,560  $            5,691,707 6.20%  $             960
Southwest Affiliation  $             77,149,266 6,756  $        70,709,964  $        10,466  $            5,933,155 7.69%  $             878
Thumb Alliance  $             65,538,980 4,076  $        63,590,065  $        15,601  $            3,749,183 5.72%  $             920
Venture  $             69,936,576 8,317  $        67,226,859  $           8,083  $            3,920,440 5.61%  $             471
State Total  $       1,684,590,157 140,751  $  1,653,144,195  $        11,745  $       120,151,207 7.13%  $             854
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 2008 Medicaid Utilization and Net Cost (MUNC) Reports. Revenue 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: 9/8/2009
Notes/Comments: 1Medicaid MH/DD Total Expenditures includes General Fund expenditures used for spend-down for certain PIHPs.