SOMC Performance Dashboard: Fiscal Year 2011

Indicator Goal Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun YTD
Increase Revenue GOAL JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN YTD
% Days in Accounts Receivable 100% 100 100 100 100 100 100 100 100 100 100 100 100 100
% Gross Patient Revenue/FTE 100% 95.5 96.1 97.0 99.4 92.3 96.5 96.6 91.9 100 97.5 94.1 95.2 96.3
Decrease Expenses GOAL JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN YTD
% Total Expense/CMI Adjusted Discharge 100% 100 99.0 100 100 100 100 100 97.3 100 100 100 97.3 100
% Overtime Hours/Staff Worked Hours 100% 94.4 95.2 100 100 100 88.7 100 100 100 100 100 100 100
Improve Bottom Line GOAL JUL AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUN YTD
% Operating Cash Flow Margin 100% 81.6 83.9 99.0 92.2 100 92.9 55.7 43.9 89.3 100 88.7 100 91.0
% Operating Margin Ratio 100% 0.0 18.6 43.9 20.7 46.9 21.2 0.0 0.0 19.6 43.9 0.0 100 15.2
% Annual Debt Service Coverage 100% 100 6.6 100 100 40.5 100 55.2 70.3 57.7 100 38.1 58.4 80.8
% Average age of Plant Years 100% 100 100 100 100 100 100 100 100 100 100 100 100 100
% Average Payment Period 100% 100 100 100 100 100 100 100 100 100 100 100 100 100
% Bad Debt as a Percent of Net Patient Revenue 100% 84.5 56.7 63.4 8.5 72.5 71.8 54.9 94.5 68.9 91.2 100 100 74.4
% of Capital Spending Ratio (x)
Meeting Target
100%                          
% Cash on Hand (Days)
Meeting Target
100% 100 100 100 100 100 100 100 100 100 100 100 100 100
% of Cash to Debt
Meeting Target
100% 81.0 79.2 82.1 82.2 82.8 85.8 86.9 90.4 90.3 91.7 92.0 92.3 92.3
% of Current Ratio (x)
Meeting Target
100% 67.2 70.6 72.8 76.5 80.5 78.5 76.7 70.6 74.0 75.6 73.2 73.8 73.8
% of Cushion Ratio (x)
Meeting Target
100% 80.2 78.4 81.3 81.3 82.0 84.9 86.0 88.0 87.9 89.2 89.5 89.9 89.9
% of Debt to Capitilization
Meeting Target
100% 83.5 82.9 85.0 86.0 86.0 87.1 87.3 88.8 89.0 90.0 89.9 92.0 92.0
% of Debt to Cash Flow
Meeting Target
100%                         82.1
% of Debt to Total Revenue
Meeting Target
100% 60.4 62.8 63.9 64.6 64.3 64.6 64.3 65.1 66.1 65.9 66.0 67.3 67.3
% of Excess Margin
Meeting Target
100% 100 0.0 100 100 0.0 100 38.6 94.1 44.6 100 0.0 42.6 100
% of Maximum Annual Debt Service Coverage
Meeting Target
100% 100 5.3 100 99.7 58.5 100 57.5 82.9 60.1 100 42.5 60.9 85.8
% of Return on Assets
Meeting Target
100%                         100

close

Days in Accounts Receivable

An indicator of SOMC’s ability to timely send out bills and receive/process payments for services already rendered.

Why is this important?

An indicator of how quickly we get bills out, which drives how quickly we get bills paid.

Close

close

Gross Patient Revenue/FTE

An indicator of SOMC’s overall financial and operational performance on a per employee basis.

Why is this important?

A big picture of productivity, the amount of net revenue we produce for the FTEs we have.

Close

close

Total Expense/cmi Adjusted Discharge

Driver of expenses and the bottom line.

Close

close

Overtime Hours/Staff Worked Hours

Driver of expenses and the bottom line.

Why is this important?

An indicator of cost effective use of labor resources

Close

close

Operating Cash Flow Margin

Measures the performance of the organization. Increasing values are favorable.

Close

close

Operating Margin Ratio

By excluding investment income/(loss), shows financial performance of SOMC from operations.

Why is this important?

Shows if we are making a profit from our core business

Close

close

Consolidated Total Margin Ratio

An indicator of SOMC’s total financial performance for the given time period.

Why is this important?

The bottom line including investment income

Close

close

Debt to Capitalization

Measures the long term debt in the corporation’s permanent capital structure. This is a measure of liquidity in the minds of creditors. Decreasing values are favorable.

Close

close

Days Cash on Hand

An indicator of the number of days SOMC could meet its average cash payments without collecting any revenue.

Close

close

Max Debt Service

A financial indicator that measures the Corporation’s ability to cover its debt obligations. Increasing values are favorable.

Close