Key Performance Indicators widget

Widget SQL Statement

Due to the complexity of this widget, the SQL had to be added to the Nightly Compile. Any meaningful SQL cannot be provided.

Gross Average Daily Revenue (MTD)

The Gross Average Daily Revenue (MTD) widget displays a numerical value of the calculated month-to-date gross average daily revenue.

The calculation shall be:

Gross Charges Entered
----------------------------------------------------------
# of Days Elapsed in Current Month

Gross Charges Entered should be calculated as the Gross Charges dropped/entered during the current month.

Expected Average Daily Revenue (MTD)

The Expected Average Daily Revenue (MTD) widget displays a numerical value of the calculated month-to-date average daily revenue based upon expected revenue.

The calculation shall be 

Expected Payment
----------------------------------------------------------
# of Days Elapsed in Current Month

Expected Payment should be calculated as the total expected payment for the charges dropped/entered during the current month.

Gross Average Daily Revenue (YTD)

The Gross Average Daily Revenue (YTD) widget displays a numerical value of the calculated year-to-date average daily revenue.

The calculation shall be 

Gross Charges Entered
----------------------------------------------------------
# of Days Elapsed in Current Year

Gross Charges Entered should be calculated as the Gross Charges dropped/entered during the current month.

Expected Average Daily Revenue (YTD)

The Expected Average Daily Revenue (YTD) widget displays a numerical value of the calculated year-to-date average daily revenue based upon expected revenue.

The calculation shall be 

Expected Payment
----------------------------------------------------------
# of Days Elapsed in Current Year

Expected Payment should be calculated as the total expected payment for the charges dropped/entered during the current month.

Days in Receivables Outstanding (DRO)

The Days in Receivables Outstanding (DRO) widget displays the current average number of days in A/R.

The best overall indicator of billing performance, DRO must be measured consistently in order to be meaningful. Calculate DRO by adding your current total receivables outstanding and the sum of your credit balances (adjusting for credits is important, as credits offset receivables, thus masking performance.) Divide that figure by your average daily charge. You can calculate your average daily charge by taking the previous three months' worth of charges and dividing by 90. Although you can determine the average daily charge based on 365 days, using 90 days accounts for seasonality, growth and other fluctuations in business.

• Best practice of 45-50 days should be notated in the widget.
• Any value below 50 days should be displayed in green.
• Any value between 50 and 60 days should be displayed in yellow.
• Any value above 60 days should be displayed in red.

Receivables Outstanding > 90 Days

The Receivables Outstanding > 90 Days widget displays the percentage of all claims with an A/R balance where the A/R balance is above 90 days. The calculation should be done as follows:

Calculate by adding your current total receivables outstanding over and sum of your credit balances over 90 days outstanding (adjusting for credits is important, as credits offset receivables, thus masking performance). Divide that figure total accounts receivable adjusting for credits.

• Best practice of 20% should be notated in the widget.
• Any value of 20% or less should be displayed in green,
• Any value between 20% and 25% should be displayed in yellow.
• Any value of 25% or more should be displayed in red.