|
f
<br />U
<br />•
<br />Mental Health, Developmental Disabilities & Substance Abuse Services
<br />I
<br />iscal Monitoring Re ort
<br />1
<br />SANDHILLS CENTER
<br />LME
<br />ending: December 31, 2007 1
<br />the fiscal y¢ar-====___>
<br />Wthf-
<br />August=2,...,June=12)
<br />F BUDGET VS. ACTUAL
<br />ccounting:
<br />Cash
<br />1 2
<br />-(31
<br />1 4) (5) 6
<br />(check one) I
<br />Accrual
<br />X
<br />PRIOR YEAR
<br />CURRENT YEAR
<br />2006-2007
<br />ACTUAL BALANCE ANNUALIZED
<br />TEM
<br />BUDGET ACTUAL
<br />DGET YR-TO-DATE ICOI. -4) PEK11,N1AUt'*
<br />REVENUE .
<br />Client Fees
<br />Medicaid - 'Reu lar Fea-for-Service"
<br />Medicaid-CAPIMRDD
<br />65,000 63,162
<br />6,352,184 6,294,036
<br />290,000 244,135
<br />35,000 32,475 2,525 185.57%
<br />4,161968 3,483,899 678,069 167.42%
<br />190,000 91,838 98,162 96.67%
<br />Medicare
<br />27,000 26,849
<br />30000 48,158 (18,1581 32105%
<br />Insurance
<br />72,000 70,103
<br />40,000 37,966 2,034 18983%
<br />Other Local
<br />A pro riabon of Fund Balance'
<br />Total Local Funds
<br />1,086,804 1,678,525
<br />379,100
<br />8,272,088 8,376,810
<br />980,101 769,876 210,225 157.10%
<br />1.504.813 I 1,504,813 000%
<br />6,941 882 4,464,212 2,477,670 128.62%
<br />Count Appropriations b count
<br />Moore
<br />Hoke
<br />:
<br />Count
<br />County
<br />574,015 574.015
<br />58,000 58,000
<br />574,015 287,007 287.N8 100.00%
<br />58,000 29.000 29 000 I 100.00%
<br />Anson
<br />County 1
<br />55000 55,000
<br />55,000 27,500 27,500 100.00%
<br />Richmond
<br />Coun
<br />144451 155,549
<br />144,451 75,000 69,451 10384%
<br />Montgomery
<br />Randolph
<br />Lee
<br />Harnett
<br />Total County Funds
<br />County
<br />County
<br />County
<br />County
<br />87,675 87,675
<br />1,001,565 1,001,565
<br />252,000 252,000
<br />199,679 199,679
<br />2,372,385 2,383,483
<br />87,675 43,837 43838 10000%
<br />1,001,565 420,565 581000 83.98%
<br />252,000 125,240 126.760 9940%
<br />199,679 99,840 I 99,839 100.00%
<br />2,372,385 1,107,989 1,264,396 9341%
<br />Service Mana ement Funds
<br />Service Delivery Funds
<br />All Other State/Federal Funds
<br />Total State and Federal Fu
<br />ds
<br />7,872936 7,872,936
<br />18,066,921 16,174,405
<br />6,877,652 5,728,512
<br />32,817,509 29,775,853
<br />6,400,000 3,369,513 3,030,497 10530%
<br />23,252,429 11,283,240 11969,189 97.05%
<br />1,093,038 1,093,038 20000%
<br />30,745,467 15,705 191 14 999,676 1 102.43%
<br />_
<br />RE N E
<br />43,461,982 40, 3 ,146
<br />4 ,059,134 21,317, 92 18,741,142 10643%
<br />EXPENDITURES:
<br />Service Marta ement
<br />8,262799 7,563,107
<br />8,174,676 4,321,815 3,852,861 105.74%
<br />Directly Provided Services
<br />Provider Payments
<br />All Other
<br />729,373 559,227
<br />27,592,158 23,498,785
<br />6,877,652 5 .728,512
<br />7,196,722 3,905,350 3,291,372 10853%
<br />23,595,298 10,784,669 12 810,629 91.41%
<br />1,093,038 211,074 881.964 3862%
<br />
<br />-
<br />-
<br />-
<br />-
<br />O L E P DR
<br />CHANGE IN CASH BALANCE
<br />Be inning Unrestricted Fund
<br />alance
<br />ME
<br />43461,982 37,34 ,631
<br />3,186,515
<br />W
<br />3,461,535
<br />4 ,059,7 34 19, 22.9
<br />6 95,97%
<br />20
<br />83
<br />6
<br />82
<br />2,095,084
<br />6,356,718
<br />Current cabernet nreslncted run- Balance 2703% 11,745,633 23.34% 9,350,863
<br />an percent of Du getetl expenddures _ - -
<br />Actual Yr-TO-Date
<br />""Appropriation of Fund Balance" represents the Area Program Fund Balance that has beenspecific incur orated as part of the A roved Budget.
<br />should reflect Fund Balance utilized to date and an explanation needs to be rovided (or the uses of fund.
<br />" annualized Revenue ercenta a less than 90% and Expend iture Percentages reater than 110% must be explained on the attachment and submitted with the
<br />Fiscal Monitoring Report
<br />-
<br />-
<br />Receivables net of
<br />2. CURRENT CASH POSITION:
<br />(1)
<br />(2
<br />(3) 1
<br />(4)
<br />15)
<br />Allowance for
<br />OVER
<br />Uncolledible
<br />30 bAVS
<br />60 DA
<br />90 DA
<br />90 DAYS
<br />OTAL
<br />eceivables
<br />'
<br />_
<br />ccoun s Payable (Accrual Method)
<br />Account Receivable (ACUUaI Methotl)
<br />214,833
<br />207,020
<br />1dg270
<br />-
<br />54.095
<br />$ 616,218
<br />$ 554,696
<br />I
<br />Current Cash in bank
<br />18,809,287
<br />3.
<br />SERVICE EXCEPTIONS: (
<br />Provided Based on S
<br />ystem Capability
<br />Services authorized but not billed
<br />"VJe ceNfy a th, re rt to contain accurate and complete information, (b explanations are provided for any expenditure item "than annualized expenditure rate reater than 110
<br />rate of less than 90%, and (c) a cro of this report has been provided to each county mans per in the catchment area'.
<br />and for any revenue item with an annualized race:
<br />!
<br />I
<br />Are
<br />CC: ou
<br />r
<br />r
<br />data
<br />J
<br />oun ithin catc
<br />1Area Finance ur er
<br />h Pit ea.
<br />date
<br />Area Board Chair
<br />date
<br />MI
<br />
|