IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 1 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT INPATIENT 20819041 4113153.28 20819041 4113153.28 236425202 5.36 6742730.61 11638017.41 6742730.61 249828492 13403289.50 OUTPATIENT 10676226 1367358.03 10676226 1367358.03 20408041 84.07 1629336.78 1611197.74 1629336.78 128114712 107706670.67 CHILD PART HOSP 1717 0.00 1717 0.00 0 100.00 0.00 0.00 0.00 20604 20604.00 CHILD DAY TREATMENT 627 0.00 627 0.00 0 100.00 0.00 0.00 0.00 7524 7524.00 ADULT PART HOSP 1513 0.00 1513 0.00 0 100.00 0.00 0.00 0.00 18156 18156.00 ADULT DAY TREATMENT 9958 0.00 9958 0.00 0 100.00 0.00 0.00 0.00 119496 119496.00 SKILLED NURSING FACILITY 1265772 349193.35 1265772 349193.35 2770242 81.76 190009.86 219843.12 190009.86 15189264 12419021.56 IHAWP IOWA PLAN LITE 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IHAWP IOWA PLAN FULL 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IHAWP HMO 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IHAWP PCP 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 2 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT INTERMEDIATE CARE FACILITY 35376416 1921089.53 35376416 1921089.53 34232686 91.94 237326.29 1880883.40 237326.29 424516992 390284305.19 INTER CARE INT DISABLED 19282130 391926.74 19282130 391926.74 4938288 97.87 372258.13 401254.57 372258.13 231385560 226447271.93 NURSING FAC FOR MENTAL ILL 305867 0.00 305867 0.00 0 100.00 0.00 0.00 0.00 3670404 3670404.00 HOME HEALTH 6187136 1495266.61 6187136 1495266.61 25440701 65.73 2028310.14 1995098.45 2028310.14 74245632 48804931.00 LEAD INSPECTION AGENCY 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 PHYSICIAN 11249055 809813.94 11249055 809813.94 30036998 77.75 1019585.69 1693917.63 1019585.69 134988660 104951661.67 CLINIC SERVICES 2371914 6650253.99 2371914 6650253.99 46020734 61.69- 3108219.38 3727804.85 3108219.38 28462968 17557766.93- MEP CASE MANAGEMENT 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 EHR INCENTIVE PAYMENTS 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 LAB AND RADIOLOGICAL 222845 39626.36 222845 39626.36 1262646 52.78 86623.99 79081.91 86623.99 2674140 1411493.72 HABILITATION SERVICES 0 128992.74 0 128992.74 2117692 0.00 205466.36 148686.27 205466.36 0 2117692.55- IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 3 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT BEHAVIORAL HLTH INTERVENTN SVC 0 20940.92 0 20940.92 739165 0.00 37274.90 81144.28 37274.90 0 739165.88- REHAB SUPPORT SERVICES 0 2456.52 0 2456.52 89848 0.00 3684.78 3200.92 3684.78 0 89848.78- AMBULANCE SERVICES 179290 176791.01 179290 176791.01 3061830 42.31- 101911.09 87384.35 101911.09 2151480 910350.48- LOCAL EDUCATION AGENCY 0 1480263.23 0 1480263.23 190738658 0.00 1439315.05 6869232.11 1439315.05 0 190738658.40- INFANT TODDLER 0 11830.92 0 11830.92 199968 0.00 24726.94 13343.69 24726.94 0 199968.10- IHAWP WELLNESS EXAM BONUS 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 ACO VIS PAYMENTS 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 PRESCRIBED DRUGS 34493599 1477450.66 34493599 1477450.66 16069707 96.12 1395790.59 1330561.03 1395790.59 413923188 397853480.22 IOWA-PLAN-PMIC 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 DRUG CAPITATION 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 NEMT SERVICES 0 29003.57 0 29003.57 322508 0.00 21701.77 22160.22 21701.77 0 322508.26- IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 4 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT INDIAN HEALTH SERVICES 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 FAMILY PLANNING SERVICES 212942 10991.11 212942 10991.11 137790 94.61 9910.29 8762.62 9910.29 2555304 2417513.39 IOWA CARE MED HOME CAPITATION 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IOWA PLAN PROGRAM 8559304 0.00 8559304 0.00 0 100.00 0.00 0.00 0.00 102711648 102711648.00 MANAGED SUBSTANCE ABUSE 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 MENTAL HEALTH ACCESS PLAN 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 EPSDT SCREENING 852752 52359.18 852752 52359.18 1711113 83.28 96547.54 95118.28 96547.54 10233024 8521910.04 HMO SERVICES 8449879 0.00 8449879 0.00 0 100.00 0.00 0.00 0.00 101398548 101398548.00 PACE SERVICES 0 2471057.82 0 2471057.82 33163831 0.00 2682680.72 2655870.95 2682680.72 0 33163831.43- PATIENT MANAGEMENT 212227 0.00 212227 0.00 0 100.00 0.00 0.00 0.00 2546724 2546724.00 HEALTH INS PREMIUM PAYMENT 647613 443228.41 647613 443228.41 6010295 22.66 420604.00 489067.51 420604.00 7771356 1761060.93 IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 5 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT MEDICAL SUPPLIES 2788344 135563.02 2788344 135563.02 2558040 92.35 203566.86 186176.65 203566.86 33460128 30902087.98 HEALTH HOME PROVIDER 0 22366.96 0 22366.96 460691 0.00 9194.45 31411.16 9194.45 0 460691.48- TCM PAYMENTS TO IOWAPLAN 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 IHAWP QHP 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 MCO 0 486430256.25 0 486430256.25 7047927152 0.00 621097962.99 55999039.75 621097962.99 0 7047927152.85- OTHER PRACTITIONER 1175437 1168132.85 1175437 1168132.85 156237951 999.99 1285633.57 5498630.01 1285633.57 14105244 142132707.57- FAMILY CENTERED PROGRAM 2999648 0.00 2999648 0.00 0 100.00 0.00 0.00 0.00 35995776 35995776.00 FAMILY PRESERVATION 34429 0.00 34429 0.00 0 100.00 0.00 0.00 0.00 413148 413148.00 TREATMENT FOSTER FAMILY CARE 305658 0.00 305658 0.00 0 100.00 0.00 0.00 0.00 3667896 3667896.00 GROUP TREATMENT THERAPY 2641514 0.00 2641514 0.00 0 100.00 0.00 0.00 0.00 31698168 31698168.00 DENTAL 3326670 17385.89 3326670 17385.89 182209 99.54 11050.70 12371.00 11050.70 39920040 39737830.60 IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 6 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT ACCOUNTABLE CARE ORGANIZATIONS 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 OPTOMETRIST 518701 12068.93 518701 12068.93 189014 96.96 10466.57 16322.10 10466.57 6224412 6035397.14 CHIROPRACTIC 408795 7581.49 408795 7581.49 129748 97.36 11307.08 10698.68 11307.08 4905540 4775791.15 IOWA-PLAN-HAB 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 PODIATRIC 152030 6142.38 152030 6142.38 134108 92.65 9160.57 10049.77 9160.57 1824360 1690251.09 PREPAID AMBULATORY HEALTH PLAN 0 11192204.63 0 11192204.63 125459240 0.00 9791643.67 10443582.90 9791643.67 0 125459240.99- PHYSICAL DISABILITIES SVCS 243022 3624.99 243022 3624.99 502500 82.77 3361.04 3362.55 3361.04 2916264 2413763.56 BRAIN INJ WAIVER SERVICES 1092599 385512.69 1092599 385512.69 7024026 46.43 528778.25 519051.76 528778.25 13111188 6087161.01 PSYCHIATRIC 179743 47282.12 179743 47282.12 783193 63.69 49745.18 53779.68 49745.18 2156916 1373722.87 RESIDENTIAL CARE FACILITY 506997 66157.91 506997 66157.91 1374704 77.40 83281.91 85064.40 83281.91 6083964 4709259.47 ID WAIVER SERVICE 22809681 1502374.41 22809681 1502374.41 30646329 88.80 2660053.87 843971.46 2660053.87 273716172 243069842.73 IAMM4100-R002 IOWA DEPARTMENT OF HUMAN SERVICES PAGE 7 AS OF 07/31/23 MEDICAID MANAGEMENT INFORMATION SYSTEM RUN DATE 07/30/23 M E D I C A L A S S I S T A N C E F I N A N C I A L S T A T U S PROVIDER CATEGORY OF SERVICE SAME AVERAGE ******** FISCAL YEAR TO DATE ******** *** FISCAL YEAR END *** **** VARIANCE **** *** THIS MONTH *** MONTH LAST LAST YEAR PROJECTED PROJECTED OVER(-)/UNDER BUDGET ACTUAL LAST YEAR SIX MONTHS BUDGET ACTUAL TO DATE BUDGET COST DOLLARS PCT CHILDRENS MENTAL HEALTH SVC 0 17437.71 0 17437.71 244402 0.00 23700.16 17957.34 23700.16 0 244402.40- AIDS WAIVER SERVICES 46137 1237.04 46137 1237.04 17605 96.82 1237.04 1237.04 1237.04 553644 536038.58 ELDERLY WAIVER SERVICES 3231045 7416.42 3231045 7416.42 1088604 97.19 38485.39 40622.14 38485.39 38772540 37683935.54 ILL & HANDICAPPED WAIVER SVCS 1723187 624551.69 1723187 624551.69 7767117 62.44 640653.50 596491.96 640653.50 20678244 12911126.71 COUNTY OFFICE REIMBURSEMENT 0 0.00 0 0.00 0 0.00 0.00 0.00 0.00 0 0.00 MEP SERVICES 1931073 334628.00 1931073 334628.00 5253084 77.33 328103.40 374819.97 328103.40 23172876 17919791.08 UNASSIGNED 0 587058.43- 0 587058.43- 329209447 0.00 2650297.75 5469473.22 2650297.75 0 329209447.00- TOTAL ALL CATEGORIES OF SERVICE 207492533 524837914.87 207492533 524837914.87 8373087127 236.28- 661291698.85 15265744.85 661291698.85 2489910396 5883176731.77- *** END OF REPORT ***