Central Florida Behavioral Health Network, Inc. DATA ANALYTICS AND - - PowerPoint PPT Presentation

▶
central florida behavioral health network inc
SMART_READER_LITE
LIVE PREVIEW

Central Florida Behavioral Health Network, Inc. DATA ANALYTICS AND - - PowerPoint PPT Presentation

Feb 07, 2023 245 likes •434 views

Central Florida Behavioral Health Network, Inc. DATA ANALYTICS AND BENCHMARKING FISCAL YEAR ENDED JUNE 30, 2017 APRIL 27, 2018 3 Managing Entities Surveyed Central Florida Behavioral Health Network, Inc. (CFBHN) Big Bend Community Based

slide-1
SLIDE 1

Central Florida Behavioral Health Network, Inc.

DATA ANALYTICS AND BENCHMARKING FISCAL YEAR ENDED JUNE 30, 2017 APRIL 27, 2018

3

slide-2
SLIDE 2

Managing Entities Surveyed

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 2

  • Central Florida Behavioral Health Network, Inc. (CFBHN)
  • Big Bend Community Based Care, Inc. (BBCBC)
  • Broward Behavioral Health Coalition, Inc. (BBHC)
  • Central Florida Cares Health System, Inc. (CFCHS)
  • Lutheran Services Florida, Inc. (LSF)
  • Southeast Florida Behavioral Health Network, Inc.

(SEFBHN)

  • South Florida Behavioral Health Network, Inc. (SFBHN)

MHM

4

slide-3
SLIDE 3

Cost Comparison and Population Served

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 3 MHM

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health Network, Inc. Total Direct Expenses 174,130,895 $ 88,960,133 $ 50,533,140 $ 68,279,072 $ 104,776,328 $ 53,838,682 $ 80,642,977 $ Total Administrative Expenses (Direct and Indirect) 6,186,170 $ 2,337,052 $ 2,735,582 $ 2,611,273 $ 3,886,981 $ 3,061,901 $ 3,978,989 $ 180,317,065 $ 91,297,185 $ 53,268,722 $ 70,890,345 $ 108,663,309 $ 56,900,583 $ 84,621,966 $ Administrative Cost Rate 3.43% 2.56% 5.14% 3.68% 3.58% 5.38% 4.70% Program Efficiency 96.57% 97.44% 94.86% 96.32% 96.42% 94.62% 95.30% Number of Clients Served - 2017 114,944 40,319 23,572 36,271 50,349 28,600 39,857 Administrative Dollars Per Client Served 53.82 $ 57.96 $ 116.05 $ 71.99 $ 77.20 $ 107.06 $ 99.83 $ % of Mental Health Clients 69.80% 67.94% 55.02% 60.79% 63.88% 76.70% 50.22% % of Substance Abuse Clients 30.20% 32.06% 44.98% 39.21% 36.12% 23.30% 49.78% % of Adults Served 76.98% 76.42% 84.43% 80.46% 81.98% 76.70% 83.24% % of Children Served 23.02% 23.58% 15.57% 19.54% 18.02% 23.30% 16.76%

5

slide-4
SLIDE 4

Cost Comparison and Population Served

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 4 MHM Managing Entity Administrative Cost Per Client % of Mental Health Clients % of Substance Abuse Clients % of Adults Served % of Children Served CFBHN 53.82 $ 69.80% 30.20% 76.98% 23.02% BBCBC 57.96 $ 67.94% 32.06% 76.42% 23.58% BBHC 116.05 $ 55.02% 44.98% 84.43% 15.57% CFCHS 71.99 $ 60.79% 39.21% 80.46% 19.54% LSF 77.20 $ 63.88% 36.12% 81.98% 18.02% SEFBHN 107.06 $ 67.01% 32.99% 76.70% 23.30% SFBHN 99.83 $ 50.22% 49.78% 83.24% 16.76%

6

slide-5
SLIDE 5

Clients Served

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 5 MHM

  • 20,000

40,000 60,000 80,000 100,000 120,000 140,000 Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health Florida, Inc. Number of Clients Served - 2017 114,944 40,319 23,572 36,271 50,349 28,600 39,857 Number of Clients Served - 2016 110,034 42,166 25,103 37,275 45,234 29,089 37,434 Number of Clients Served - 2015 124,584 45,123 33,441 38,758 48,264 30,074 37,229 Number of Clients

7

slide-6
SLIDE 6

Average Administrative Rate vs Clients Served

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 6 MHM

334 326 357 $74.26 $68.32 58.32 100 200 300 400

2017 2016 2015

Clients Served (1000's) Service Rate 8

slide-7
SLIDE 7

Program vs Administrative Cost per Client

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 7 MHM

CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Administrative Costs Per Client $54 $58 $116 $72 $77 $107 $100 Program Costs Per Client $1,515 $2,206 $2,144 $1,882 $2,081 $1,882 $2,023 $- $500 $1,000 $1,500 $2,000 $2,500 9

slide-8
SLIDE 8

Program Efficiency

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 8 MHM

92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 100.00% CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

96.57% 97.44% 94.86% 96.32% 96.42% 94.62% 95.30% 96.76% 97.43% 93.76% 96.40% 96.43% 95.33% 95.96% 96.71% 97.68% 95.10% 96.28% 96.43% 95.29% 95.59%

2017 2016 2015

% of costs dedicated to programming

10

slide-9
SLIDE 9

Operating Reliance

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 9 MHM

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health Network, Inc. Unrestricted Program Revenue 180,138,124 $ 91,229,147 $ 53,268,722 $ 70,797,040 $ 110,399,525 $ 56,923,310 $ 84,602,766 $ Total Expenses 180,317,065 $ 91,297,185 $ 53,268,722 $ 70,890,345 $ 108,663,309 $ 56,900,583 $ 84,621,966 $ Operating Reliance 99.90% 99.93% 100.00% 99.87% 101.60% 100.04% 99.98%

11

slide-10
SLIDE 10

Working Capital and Liquidity

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 10 MHM

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health Network, Inc. Total Current Assets 19,367,814 $ 12,175,457 $ 7,607,231 $ 8,911,667 $ 12,786,874 $ 5,384,839 $ 14,589,718 $ Total Current Liabilities 17,519,560 $ 15,698,707 $ 7,590,230 $ 8,802,022 $ 3,945,632 $ 5,353,056 $ 13,661,443 $ Current Ratio 1.11 0.78 1.00 1.01 3.24 1.01 1.07 Cash + Total Receivables 19,322,596 $ 11,645,603 $ 7,532,487 $ 8,826,216 $ 12,786,874 $ 5,366,564 $ 14,431,041 $ Total Current Liabilities 17,519,560 $ 15,698,707 $ 7,590,230 $ 8,802,022 $ 3,945,632 $ 5,353,056 $ 13,661,443 $ Quick Ratio 1.10 0.74 0.99 1.00 3.24 1.00 1.06

12

slide-11
SLIDE 11

Receivables, Payables & Cash Position

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 11 MHM

Central Florida Behavioral Health Network, Inc. Big Bend Community Based Care, Inc. Broward Behavioral Health Coalition, Inc. Central Florida Cares Health System, Inc. Lutheran Services Florida, Inc. Southeast Florida Behavioral Health Network, Inc. South Florida Behavioral Health Network, Inc. Total Receivables 8,933,500 $ 5,335,182 $ 4,193,963 $ 5,219,138 $ 8,064,016 $ 4,287,256 $ 6,212,895 $ Total Revenue (less in-kind) 179,995,547 $ 91,229,147 $ 53,268,722 $ 70,797,040 $ 110,399,525 $ 56,923,310 $ 84,602,766 $ Receivable Days 18 21.35 29 27 27 27 27 Payables 17,519,560 $ 9,631,729 $ 7,590,230 $ 6,283,163 $ 3,945,632 $ 4,900,713 $ 9,578,027 $ Total Expenditures (less depreciation & in-kind plus capital) 180,208,657 $ 90,763,326 $ 53,261,918 $ 70,815,365 $ 108,651,525 $ 56,906,735 $ 84,601,111 $ Payable Days 35 39 52 32 13 31 41 Unrestricted Cash 10,389,096 $ 6,310,421 $ 3,338,524 $ 3,607,078 $ 4,722,858 $ 1,079,308 $ 8,218,146 $ Total Expenses (less depreciation & in-kind) 180,208,657 $ 90,763,326 $ 53,261,918 $ 70,815,365 $ 108,651,525 $ 56,906,735 $ 84,601,111 $ Days Cash Reserve 21 25 23 19 16 7 35

13

slide-12
SLIDE 12

Number of Days Revenue in AR

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 12 MHM 18 21 29 27 27 27 27 23 4 28 15 30 25 33 21 13 22 38 23 25 20 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2017 2016 2015

14

slide-13
SLIDE 13

Number of Days Expenses in AP

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 13 MHM 35 39 52 32 13 31 41 38 41 52 38 40 43 53 40 39 43 42 36 35 42 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2017 2016 2015

15

slide-14
SLIDE 14

Days Cash Reserve

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 14 MHM 21 25 23 19 16 7 35 19 34 23 24 7 18 32 24 24 21 3 10 9 26 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN

2017 2016 2015

16

slide-15
SLIDE 15

2017, 2016, and 2015

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance

15

2017

  • 10

20 30 40 50 60 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

2016

  • 10

20 30 40 50 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

  • 10

20 30 40 50 60 CFBHN BBCBC BBHC CFCHS LSF SEFBHN SFBHN Number of Days in Accounts Receivable Number of Days Expenses in AP Number of Days in Cash Reserve

2015

17

slide-16
SLIDE 16

Ratio Explanations

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 16 MHM

Ratio Expla lanation

  • Administrative Cost

Rate

  • Direct and indirect administrative expenses as a percentage of total entity
  • expenses. Measures efficiency of administrative function in relation to total

costs.

  • Program Efficiency
  • Total direct expenses as a percentage of total entity expenses. The inverse
  • f the administrative cost rate. Measures the efficiency of $ used for

programmatic purposes in relation to total costs.

  • Administrative

Dollars/Cost Per Client

  • Total administrative expenses divided by the # of clients served by the

ME and its provider agencies.

  • Operating Reliance
  • Unrestricted program revenue divided by total expenses. Indicates how

able a NFP entity is to fund costs from program revenue alone. The ratio for ME’s is expected to be near 100%.

18

slide-17
SLIDE 17

Ratio Explanations - Continued

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 17 MHM

Ratio Expla lanation

  • Current Ratio
  • Current assets divided by current liabilities. Measures the overall liquidity

position of an organization.

  • Quick Ratio
  • Cash plus total receivables divided by current liabilities. Also a liquidity

measure but focuses on cash and receivables.

  • Receivable Days
  • Accounts receivable divided by total revenue (excluding in-kind) with

the result multiplied by 365. The resulting number reflects the length

  • f time it takes to collect receivables.
  • Payable Days
  • Payables divided by total expenses (excluding in-kind and

depreciation) plus capital expenditures with the result multiplied by

  • 365. Rough measure of how timely an organization is in meeting

payment obligations.

  • Days Cash Reserve
  • Unrestricted cash divided by total expenses (excluding in-kind and

depreciation) with the result multiplied by 365. Measures the amount of cash on hand to meet future expenses. Expectation for ME with no other programming activity is generally very low given the nature of operations.

19

slide-18
SLIDE 18

?

QUESTIONS

? ? ?

Solely for the use of Central Florida Behavioral Health Network, Inc. including Management and those charged with Governance 18 MHM

20