Orange County NC Website
BOH GOVERNANCE DASHBOARD Q3 FY14-15 <br />* NOTE :FY 14-15 Billing accuracy newly combines dental and medical paid claims, unpaid claims & un-claimed appointments. <br />Claims can take a quarter to realize payment - billing accuracy for all months increases with time as claims are finalized and errors are reworked. <br />188 <br />162 174 <br />228 <br />178 <br />201 <br />179 <br />210 <br />284 <br /> (50) <br /> - <br /> 50 <br /> 100 <br /> 150 <br /> 200 <br /> 250 <br /> 300 <br /> 350 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />TOTAL HEALTH DEPARTMENT REVENUE <br />vs. budget projections & prior year <br />Other State <br />Grants Environ Health <br />Dental Personal Health <br />Total OCHD Revenue (1.8M YTD)YTD Month Avg (200k/m, ~2.4M/y est) <br />FY15 Budget Projection (207k/m, 2.5M/y)Prior: FY14 Revenue - Avg (174k/m, 2.1M/y) <br />Prior: FY13 Revenue - Avg (170k/m, 2.0M/y)Prior: FY14 Revenue (2.1M/y) <br />30 28 <br />49 <br />60 58 <br />51 <br />44 <br />60 57 <br /> - <br /> 10 <br /> 20 <br /> 30 <br /> 40 <br /> 50 <br /> 60 <br /> 70 <br /> 80 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />MEDICAL (PH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />Self Pay Insurance <br />Medicaid Total PH Revenue (437k YTD) <br />YTD Month Avg (48.5k/m, ~582k/y est)Budget Projection (48k/m, 589k/y) <br />Prior: FY14 PH Revenue - Avg (44k/m, 532k/y)Prior: FY14 PH Revenue (532k/y) <br />Prior: FY13 PH Revenue - Avg (25k/m, 296k/y) <br />32 34 <br />29 <br />44 <br />34 <br />29 <br />34 36 35 <br /> - <br /> 20 <br /> 40 <br /> 60 <br /> 80 <br />J A S O N D J F M A M J <br />Th <br />o <br />u <br />s <br />a <br />n <br />d <br />s <br />DENTAL EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />Self Pay Insurance <br />Medicaid Total D Revenue (307k YTD) <br />YTD Month Avg (34k/m), ~410k/y est)Budget Projection (32k/m, 388k/y) <br />Prior: FY14 D Revenue - Avg (26k/m, 317k/y)FY14 Year Dental Revenue (317k/y) <br />Prior: FY13 D Revenue - Avg (22k/m, 269k/y) <br />84%84%80%85%80%82%82%84%81% <br />0% <br />20% <br />40% <br />60% <br />80% <br />100% <br />120% <br />J A S O N D J F M A M J <br />TOTAL BILLING ACCURACY* <br />vs. prior years & goal <br />Total FY15 Billing Accuracy (YTD avg 82%)Accuracy Target (90%) <br />M FY15 Total Accuracy (YTD avg 82%)D FY15 Total Accuracy (YTD avg 82%) <br />M FY14 Accuracy - Avg (84%)M FY13 Accuracy - Avg (73%)