Orange County NC Website
TOTAL HEALTH DEPARTMENT REVENUE <br />vs. budget projections & prior year <br />450 <br />386 <br />` 400 <br />s 350 <br />H <br />300 <br />250 ......................... �# ... vni <br />zoo <br />1 <br />150 <br />100 <br />50 <br />•221 ................. ../........1................... <br />J A s O N D 1 F M A M J <br />(50) <br />Personal Health Dental <br />Environ Health Grants <br />J1 State Other <br />• Total OCHD Revenue ($1.4M YTD) -YTD Month Avg ($236k/m, - $2.8M /y) <br />•••••• FY15 -16 Budget Projection ($260k /m, $3.1M /y) - Prior: FY14 -15 Total OCHD Revenue ($2.6M /y) <br />Prior: FY14 -15 Revenue - Avg ($218k /m, $2.61VI/y) <br />DENTAL EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />60 <br />v <br />c <br />'o <br />L <br />F- <br />40 <br />20 <br />43 A2 <br />Medical Billing Accuracy* <br />vs previous year & goal <br />92% 90% 89% 91% 84% <br />58% <br />J A s O N D 1 F M A M J <br />M FY16 Total Accuracy (YTD avg 86%) - M FY15 Avg Accuracy (92 %) ...... Accuracy Target (90 %) <br />Dental Billing Accuracy* <br />vs previous year & goal <br />1 A s O N D 1 F M A M J <br />D FY16 Total Accuracy (YTD avg 97%) - D FY1S Accuracy - Avg (94%) ...... Accuracy Target (90 %) <br />MEDICAL (PH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />80 <br />-o <br />c <br />0 <br />0 <br />60 <br />40 <br />20 <br />54 <br />0 0 <br />J A s O N D J F M A M J 1 A s O N D J F M A M J <br />MEDICAID INSURANCE MEDICAID INSURANCE <br />SELF PAY • Total Earned Revenue ($235k YTD) SELF PAY • Total Earned Revenue ($271k YTD) <br />• • • • • • Budget Projection ($45k /m, $537k /y) -YTD Month Avg ($39k /m, - $471k /y est) ...... Budget Projection ($50k /m, $600k /y) -YTD Month Avg ($45k /m, - $542k/y est) <br />FY14 -15 D Revenue($428k /y) - FY14 -15 D Revenue - Avg ($36k /m) - FY14 -15 M Revenue($598k /y) - FY14 -15 M Revenue - Avg ($50k /m) <br />* NOTE : FY15 -16 Billing Accuracy no longer combines dental and medical paid claims & unpaid claims. Because two different accounting systems are being used (Medical: Accrual; Dental: Cash) the two clinics are shown separately. <br />Billing Accuracy Formulas: Medical = Paid claims /(# encounters minus no charge claims). Un- claimed appointments are no longer factored in; Dental = Paid Claims /# kept 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 />