0
<br />s
<br />•
<br />022
<br />Division of Mental Health, Developmental Disabilities 8 Substance Abuse Services
<br />I_
<br />Quarterly Fiscal Monitoring Report 1
<br />I
<br />rL
<br />M SANDFULLS CENTER
<br />LME
<br />forthe period ending: Dneember31,2007
<br />p of month in the fiscal year-====___>
<br />i
<br />(July = 1_AUgust= 2, June = 12)
<br />I
<br />_
<br />~
<br />1. REROPT OF BUDGET VS. ACTUAL
<br />-
<br />Basis of Accounting: Gash
<br />(1 (2)
<br />13)
<br />(4)
<br />(5) (6) 1
<br />1
<br />(check one) Accrual
<br />X
<br />PRIORYEAR
<br />CURR
<br />ENT YEAR
<br />1
<br />2006-2007
<br />ACTUAL
<br />BALANCEL ANNUALIZED
<br />ITEM
<br />BUOGET~P.CTUAL
<br />BUDGET YR-TO-DATE
<br />(Co I. 3-411 PERCENTAGE
<br />
<br />REVENUE
<br />I
<br />Client Fees
<br />65,000 53,162
<br />35,000 32475
<br />2,525 185.9%
<br />Medicaid 'Regular Fee-for-Service"
<br />6,352,184 5,294038
<br />4,161,968 3483,899
<br />679,0691 16742%i
<br />Medicaid-CAPCAP.DD
<br />290000 244,135
<br />190000 91838
<br />98,162 9667°bi
<br />Medicare
<br />27,000 26849
<br />30000 48,158
<br />( (18,158)1 32105%;
<br />I
<br />Insurance
<br />72,000 1 70,103
<br />40,000 37,965
<br />2,034 18_.83%'
<br />Other Lscal
<br />1,086,804 1 1,678,525
<br />980,101 769,876
<br />I 210,225 157.;0%1
<br />Appropriation of Fund Balance'
<br />319,100 -
<br />1,504813 -
<br />1 1,504813 000%
<br />_
<br />Total Local Funds
<br />8,272 088 1 3.375810
<br />5,941 882 4,454r212
<br />' 2,477,670 I 128.62% '
<br />_
<br />Cou
<br />nty Appropriations (by coun
<br />
<br />1
<br />Madre (
<br />County
<br />574015 1 574015
<br />5]4015 287007
<br />28]0081 10000%I
<br />Hake
<br />County
<br />SR 000 58 000
<br />58 000 29 000
<br />29 000 1 1D0.00 %
<br />Anson
<br />County
<br />55.000 1 55,000
<br />55,000 27.500
<br />27,500 10000%1
<br />Richmand
<br />County
<br />144451
<br />155549
<br />144451 75,000
<br />69451 10384%
<br />Montgome
<br />County
<br />_
<br />87,675 1 87,675
<br />87675 43,837
<br />43,838 10000%
<br />Randolph (
<br />County
<br />-
<br />1001565 1,001,565
<br />1,001565 420,565
<br />581000 8398%(
<br />Lee
<br />county ~
<br />252,000 252,000
<br />252,000 125,240
<br />126,760 1 9940%1
<br />_
<br />Haraed
<br />County
<br />199,679 199679
<br />199,6]9 99,840
<br />1 99,839 100
<br />_
<br />Total County Funds
<br />2,372,385 1 2,383,483
<br />2,372,385 1,107,989
<br />1 264 396 93.41 %
<br />Service Management Funds
<br />71872,936 7,872,936
<br />6,400,ODD 3,369.513
<br />3,030.487 301/,l
<br />Service Delivery Funds
<br />_
<br />18 066 921 1 16,174,405
<br />23,252,429 11 283 240
<br />11 969,189 97.05
<br />All Other State/Federal Funds
<br />6 ,B77652 5728,512
<br />1093038 1O93,03fl
<br />- 200 DO%
<br />Total State and Federal Fu
<br />nds
<br />32817509 1 29,775,853
<br />30,745,467 15745791
<br />140996761 10243%
<br />TO AL REVENUE
<br />43,461,9821 40,536,146
<br />40059,734 21317,992
<br />18741,762 10643%
<br />T
<br />-
<br />EXPENDITURES:
<br />Service Management
<br />8,262,799 7,563.107
<br />8,174,576 4,321.815
<br />3 .852,861 105 74
<br />Directly Provided Services
<br />729,373 559,227
<br />],196,]22 3,905,350
<br />3,291372 108.53%
<br />Provider Payments
<br />21592,158 23,498785
<br />23,595,298 10,784,669
<br />12810629 9141%
<br />All Other
<br />C
<br />6,87]652 5,728,512
<br />1093,038 211074
<br />881,964 3862%
<br />O AL EXPENDITURES
<br />TI
<br />4J 461,9fl2 3],349,631
<br />40,059,734 19,222,908
<br />20,836,826 9557
<br />CHANGE IN CASH BALANCE
<br />Beginning Unrestricted Fund Balance
<br />Curren[EStimated nrestricled Funtl Balance
<br />and percent of budgeted expenditures
<br />2
<br />3,186,515
<br />3,461,535
<br />=2703%1 11,745,633
<br />2,095084
<br />6,356,718
<br />2334% 9,350,863
<br />-
<br />-
<br />"'Apprepdagon of Fund Balance" represents the Area Program Fund Balance that has been incur orated Rod of the Approved Budget Actual Yf-To-Date
<br />should reflect Fund Balance utilized to dale and an explanation needs to be provided for the specific uses of fund.
<br />" annualized Revenue percentage less -than 90% and Expenditure percentages greater than 110% must be explained on the attachment and submitted with the
<br />Fiscal Morocco Report
<br />- _
<br />2. CURRENT CASH POSITION:
<br />-
<br />(1(2)
<br />- _
<br />(a)
<br />(4) (5)
<br />Receivables netof
<br />Allowance for
<br />_
<br />OVER
<br />Uncollecbble
<br />I
<br />I 30 UAY5 160 DAYS
<br />90 DAYS
<br />90 DAYS
<br />TOTAL
<br />Receivables
<br />ecounts ayaoe ccrua et o
<br />104
<br />0
<br />Account Receivable (Accrual Method)
<br />214 833 207 ,020
<br />140,270
<br />54,095
<br />$ 616,218
<br />$ 554,596
<br />I I
<br />Current Cash in Bank
<br />18,809,26]
<br />I
<br />I
<br />I
<br />3. SERVICE EXCEPTIONS: (
<br />Provided EaseIn System Capability)
<br />Services authorized but not billed
<br />"We wrEfy (a) this report to contain accurate and complete information, (b) explanations are provided (or any expenditu
<br />R
<br />re item with an annualized expenditure rate greater Nan i 10
<br />id d for any revenue item with an annualized receipt rate of less than 90%, antl (c) a cop of this report has been provided t
<br />o each county manager in the catchment area".
<br />Are
<br />CC our
<br />r
<br />dale
<br />date _ _ (Area Finance Off or
<br />sun ithin rrlchi nt. ea.
<br />Area Boartl Chair tlate
<br />0
<br />
|