Orange County NC Website
BOH GOVERNANCE DASHBOARD Q2 FY18-19 <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 />* NOTE :FY18-19 Billing Accuracy has not been calculated for the quarter. Because of the switch from Patagonia to EPIC we are not able to create this part of the dashboard at the present time. <br />209 218 <br />192 <br />223 223 <br />195 <br />0 <br />50 <br />100 <br />150 <br />200 <br />250 <br />300 <br />350 <br />400 <br />450 <br />500 <br />J A S O N D J F M A M JThousandsTOTAL HEALTH DEPARTMENT REVENUE <br />vs. budget projections & prior year <br />State Personal Health <br />Other Grants <br />Environ Health Dental <br />Total OCHD Revenue ($1.3M YTD)YTD Month Avg ($210k/m, ~$2.5M/y) <br />FY18-19 Budget Projection ($289k/m, $3.5M/y)Prior: FY17-18 Total OCHD Revenue ($3.5M/y) <br />Prior: FY17-18 Revenue - Avg ($289k/m, $3.5M/y) <br />43 <br />49 <br />33 <br />53 <br />39 <br />29 <br />0 <br />10 <br />20 <br />30 <br />40 <br />50 <br />60 <br />J A S O N D J F M A M JThousandsDENTAL EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />MEDICAID INSURANCE <br />SELF PAY Total Earned Revenue ($246k YTD) <br />Budget Projection ($45k/m, $542k/y)YTD Month Avg ($41.k/m, ~$492k/y est) <br />FY17-18 D Revenue ($511k/y)FY17-18 D Revenue - Avg ($42.6k/m) <br />39 <br />23 23 <br />33 <br />36 <br />20 <br />0 <br />10 <br />20 <br />30 <br />40 <br />50 <br />60 <br />70 <br />80 <br />90 <br />J A S O N D J F M A M JThousandsMEDICAL (PH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />MEDICAID INSURANCE <br />SELF PAY Total Earned Revenue ($174k YTD) <br />Budget Projection ($55.6k/m, $668k/y)YTD Month Avg ($29.1k/m, ~$349k/y est) <br />FY17-18 M Revenue ($618k/y)FY17-18 M Revenue - Avg ($51.5k/m) <br />48 <br />53 <br />31 <br />46 <br />54 <br />32 <br />0 <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 JThousandsENVIRONMENTAL (EH) EARNED REVENUE BY SOURCE <br />vs. budget projection & prior year <br />Fees Food & Lodging <br />Public Pools Samples <br />Septic Tattoo Parlor <br />Wells Total Earned Revenue ($264k YTD) <br />Budget Projection ($53k/m, $637k/y)YTD Month Avg ($44.1k/m, ~$529k/y est) <br />FY17-18 M Revenue ($625k/y)FY17-18 M Revenue - Avg ($52k/m)