Kpi dashboard in excel | Operations Management homework help
A running dashboard that will be updated monthly with new data. KPI for medical billing Net Collection Rate (Internal Benchmark >97%-Industry Benchmark >95%)(Payments- Credits)/(Charges-contractual adjustments)X100 Days in AR (Internal Benchmark < 40 days-Industry Benchmark < 45 Days) Divide Total AR by Average Daily Charges AR % over 120 days (Internal Benchmark <20% of Total […]
