The URL can be used to link to this page

2004-73-Minutes for Meeting January 16,2004 Recorded 1/21/2004DESCHUTES COUNTY OFFICIAL RECORDS CJ 1004'13 NANCY BLANKENSHIP, COUNTY CLERK COMMISSIONERS' JOURNAL 01/21/2004 04;59;04 PM III i I I I IIII II IIII II II II III 2 0 -73 DESCHUTES COUNTY CLERK CERTIFICATE PAGE This page must be included if document is re-recorded. Do Not remove from original document. Deschutes County Board of Commissioners 1130 NW Harriman St., Bend, OR 97701-1947 (541) 388-6570 - Fax (541) 388-4752 - www.deschutes.org MINUTES OF FULL BUDGET COMMITTEE MEETING DESCHUTES COUNTY BOARD OF COMMISSIONERS FRIDAY, JANUARY 16, 2004 The Board Room, Bend Golf & Country Club, Bend Present were Commissioners Dennis R. Luke, Tom DeWolf and Michael M. Daly. Also present were Mike Maier, County Administrator; Susan Ross, Commissioners' Office; Les Stiles, Sheriff; Marty Wynne, Finance Director; Budget Committee Members Lee Smith, Lauri Miller and Larry Kimmel; and, for a portion of the meeting, Norm Garrett of Z-21 TV. No other citizens were present. The meeting began at 11:50 a.m. 1. Welcome and Opening Remarks. Budget Officer Tom DeWolf opened the meeting. 2. Health Benefits Trust Fund. Marty Wynne gave an overview of this item, and explained the methodology used to arrive at the various figures. (A copy of a document showing the data is attached as Exhibit A) 3. Status of Labor Contracts. At this time, the group adjourned into executive session under ORS 192.660(1)(d), union labor negotiations. (Media representative Norm Garrett left the room to make phone calls) Minutes of Meeting of Full Budget Committee Friday, January 16, 2004 Page 1 of 4 Pages 4. PERS Discussion. Marty Wynne presented a document showing PERS departmental charges (attached as Exhibit B), and gave an overview of the assumptions made. He said the County was wise in not spending the excess PERS dollars from 2001. Commissioner Luke pointed out that the State and school districts spent theirs, and now regret that action. Mr. Wynne indicated that the prudent thing to do is to continue setting aside dollars at the higher rate as a buffer. 5. Ballot Measure 30. Mike Maier said that the departments that would be the most impacted by a failure of the February passage of Measure 30 are Health, Mental Health, the Commission on Children and Families, the Sheriffs Office, Juvenile Community Justice and Parole and Probation. Nothing can be built into the budget until the facts are known. Sheriff Stiles pointed out that if whenever there is a cut in Mental Health funding, many individuals end up either in the jail or at the hospital emergency room. He added that about 15% of the jail population has mental health issues. 6. Sheriffs Levy. At this time the group went over the two-page spreadsheet that the Sheriffs Office developed, showing the impacts of the passage and failure of the proposed Sheriffs tax levy. (A copy is attached as Exhibit C.) The Sheriff stated that if the levy fails, there would be no patrol division and only one investigator. Ten to twenty jail positions will be lost, and the jail capacity will be reduced to 108, requiring heavy use of the matrix system. There will be no court security except during prisoner transport. In essence, the department's budget would go from $18.11 million that is needed to sustain current levels of service to about $6.6 million. Minutes of Meeting of Full Budget Committee Friday, January 16, 2004 Page 2 of 4 Pages The Sheriff also stated that all reserves were used up during the past three years to sustain services, and those reserves are all but gone. Such a severe cut in Sheriffs services will also impact public safety in the cities and will negatively impact the quality of life of the area. He added that he will be distributing layoff notices to employees even before the election, since if the levy fails he has to have already given the correct advance notice of layoff to his employees. The group agreed how critical it is to have this levy pass, and how important it is to get permanent funding in place as soon as possible. 7. Budget Status Reports. Marty Wynne distributed a Statement of Financial Operating Data for the six months ended December 31, 2003. (A copy is attached as Exhibit D) He went over in detail some of the figures that were hard to forecast, such as those for the Clerk's Office (primarily due to numerous refinances and property transfers). He added that others are challenging because of various factors (the Sheriffs Office because of the levy, and Parole & Probation because it relies so heavily on State funding). He stated that as a rule, budgets came in fairly close. 8. Budget Instructions for 2004-05. The group then discussed the instructions given to the departments to be used in the building of their budgets; in particular, personnel cost assumptions. (A copy of the reference document is attached as Exhibit E.) 9. Budget Calendar. Susan Ross distributed a proposed Budget Committee calendar, and asked the members to let her know as soon as possible if the any of the dates scheduled for meetings and presentations present a problem for any of the members. (A copy of the schedule is attached as Exhibit F.) Being no further discussion or items brought before the group, the meeting adjourned at 1:20 p.m. Minutes of Meeting of Full Budget Committee Friday, January 16, 2004 Page 3 of 4 Pages DATED this 16th Day of January 2004 for the Deschutes County Board of Commissioners. KfichaWN4. Daly hair Dennis R. Luke, Commissioner ATTEST: Tom DeWolf, Co ssioner Recording Secretary Minutes of Meeting of Full Budget Committee Friday, January 16, 2004 Page 4 of 4 Pages RESOURCES Beg. Net Working Capital Revenues: Internal Premium Charges PIT Emp - Addl Prem Employee Prem Contribution COIL Retiree / COBRA Co -Pay Interest Miscellaneous Total Revenues TOTAL RESOURCES REQUIREMENTS Expenditures: Personal Services Materials & Services Conferences and Seminars Claims Paid Insurance Expense State Assessments Administrators West Willowbrook Insurance PPO Fee Printing Program Expense/Supplies Computer/Peripherals Other Total Materials & Services Capital Outlay Contingency TOTAL REQUIREMENTS Health Benefits Trust Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Revised Year End Budget Actual Variance 7FY % Coll. % Budget Projection Variance $ 1,883,881 $1,883,881 $ 3,253,113 64,800 197,934 273,630 173,502 11,000 3,973,979 3,319,115 70,967 213,350 280,399 178,933 14,643 29,145 4,106,552 66,002 6,167 15,416 6,769 5,431 3,643 29,145 132,573 100% 100% $1,883,881 50% 51% '.:" . 6,506,226 50% 55% - 129,600 50% 54% 395,868 50% 51% 547,260 50% 52%.n ,f 347,003 50% 67% 22,000 50% n/a " a) 50% 52%, +�` .`;,:' 7,947,957 5,857,860 5,990,433 132,573 50% 61% 50,538 46,769 3,769 50% 46% 1,500 795 705 3,913,609 2,603,563 1,310,046 130,170 129,484 686 15,178 12,874 2,304 77,709 77,782 (73) - 7,439 (7,439) 14,381 14,507 (126) 10,823 5,706 5,117 7,592 - 7,592 1,295 - 1,295 1,856 5,875 (4,019) 4,174,113 2,858,025 1,316,088 50 - 50 1,302,438 - 1,302,438 5,527,139 2,904,794 2,622,345 NET (Resources - Requirements) 330,721 3,085,639 2,754,918 " Unappropriated Ending Fund Balance a) Subrogation refunds b) 27 weeks of claims. Annualized: $5,035,120 $1,883,881 $ 6,506,226 129,600 395,868 547,260 347,003 22,000 29,145 7,977,102 9,831,838 9,860,983 101,076 101,076 29,145 29,145 29,145 50% 27%3,000 3,000 50% 33% b)`,'' 7,827,218 5,035,120 2,792,098 50% 50% 260,340 260,340 _ 50% 42% 30,356 30,356 _ 50% 50% 155,417 155,417 _ 50% n/a - 7,439 (7,439) 50% 50% 28,762 28,762 _ 50% 26% 21,646 21,646 _ 50% 0% 15,183 15,183 _ 50% 0% 2,590 2,590 - 50% 158% 3,712 5,875 (2,163) 50% 34% 8,348,224 5,565,728 2,782,496 50% 0% 100 100 - 50% 0%.- 1,302,438 - 1,302,438 50% 30% 9,751,838 5,666,904 4,084,934 80,000 4,194,079 4,114,079 xhibit A ?age ---L- of / Deschutes County (including 911 and Extension) PERS Departmental Charges FY 03-04 Departmental PERS Charges Use of Departmental PERS Charges Payment to PERS Employer Rate Employee Rate TOTAL Payment to PERS To PERS Reserve for Debt Service To PERS Reserve for future years Total 19.59% 33,839,678.41 6,629,193 6.58% 2,226,651 6.00% 2,030,381 4,257,032 0.98% 331,629 6.03% 2,040,533 6,629,193 Exhibit, 15 ?age ( of f Budgeted PERS PERS FY 03-04 Payroll covered Budgeted Rate by PERS Expenditures 19.59% 33,839,678.41 6,629,193 6.58% 2,226,651 6.00% 2,030,381 4,257,032 0.98% 331,629 6.03% 2,040,533 6,629,193 Exhibit, 15 ?age ( of f 0 January 6, 2004 Exhibit ?age / of -)- Deschutes Countv Sheriffs Office Financial and Operational Scenarios Levy Rates at $.82 and $1.60 1 LeVY Rates at $.78 and $1.12 Tax Levy Fails Resources $18,118,521 $16,100,301 $6,161,846 Requ mmerrts O ratin $18118,521 $16,100,301 $6,161,84 Non -Funded Employee Liability $75,481 $421,10 FTE Funded 171 152 59 Sheriffs Staff Sworn Positions Captain & Undersheritf 10aptain & Undersheriff Captain & Undersheriff Non Swom Position Six staff working 5 day weeks lReduce Staff Reduce Staff & Work Days Automotive Communications FTE Mana er/Mechanicffechnician Man r/Mechanieffechnician Man erlrechnician Number of new vehicles purchased Thirteen Eight None Investigations/Evidence Captain 60% Code, 40% Investigations and Management 60% Code, 40% Investigations and Management 60% CODE, 40% Evidence/Civil Detectives Six Six None Sergeants TWO TWO Forensic Sgt only who also handles evidence CODE Detectives TWO Limited, if detective positions cut None Ma or CriMesRape, Robbery,Homicide [Rape. Robbery, Homicide Patrol responsibility if available Evidence Handling & Storage Two Technicians ITwo Technicians Captain & Forensic Sgt PatroUCivIUTraffIc Patrol Teams Four Teams with 11 Deputies per Team 24 hours per Day Four Teams with 9 Deputies per Team 24 hours per Day. Reduction in Patrol hours. 4 Staff Sisters, 6 Staff other areas working 16 hours per day civil duties and emergency response if available Response Time 30 minutes or less Significantly Reduced I Emergency calls only, response time unknown K-9 Four Deputies lFour Deputies None Civil Service One Full time Tech & Deputies Deputies only Captain Lieutenants & Sgts Traffic Team Four deputies one sergeant Four deputies, one sergeant None Code Enforcement One Law Enforecment Tech One Law Enforecment Tech None Animal Control Four Law Enforecment Tech None, No response to calls None, No response to calls SRO's Four Deputies None, no longer partici to None no longer participate Substations LaPine Sisters, Terrebone LaPine, Sisters, Terrebone Closed Records Office Assistants Ten positions ITen Dositions Two positions, Bend station only Adult JailrrmnsportfCourt Security Total Beds 228 228 108 Corrections Deputies Four Teams with ten Deputies, one Sergeant & One Program Deputy Four Teams with ten Deputies & one . No Program Deputy Four Teams with 5 Deputies and one Sgt `(see note) Transport/Court Security Four Deputies Four Deputies None, Transport perfomed by Mgmt (Undersheriff/Captain Inmate Programs Limited Limited I Religious required, Reduce NA, AA & GED Inmate Transport As Requested and Deputies available As Requested and Deputies available Limited, done by Undrsherrff/Capt, Medical emergency reduced Increases risk of litigation Kitchen Services Contract with Aramark Contract with Aramark Aramark may opt out of contract requiring remaining staff to provide services Inmate Release Increase use of Matrix due to overcrowding in Jail Increase use of Matrix due to overcrowding in Jail Focus will be to lodge most serious criminals. Estimate arrestees from local law enforcement agecies for lodging maybe booked and relased when jail population reaches 98 inmates depending on classification of inmates Impact of other Law Enforcement Agencies None None Longer waiting period booking inmates Inmate Work P ram Laundry,cleaning etc Laundry, cleaning etcNo inmate work program Jail Maintenance Control Room Upgrade Limited maintenanceA(High No capital improvements "(note)This does not assume any further reductions of S81145 funds Risk January 6, 2004 Exhibit ?age / of -)- J ...1 0 0 January 6, 2004 Exhibit Page of 7— Deschutes County Shedfrs Office Financial and Operational Scenarios LevyRates at $.82 and $1.60 Levy Rates at $.78 and $1.12 Tax Levy Fails Eme en Services Emergency Manager (Grant Funded) Funded IFunded Funded S ial Services/SAR Sergeant (50% Title III Funded) Funded Funded Forest Service and SAR Office Assistant 80% Title III Funded Funded Funded SAR Operational Operational Severely limited operations Marine Patrol & USFS patrol Two Deputies Two Deputies Not Performed unless services contracted Training Training Sergeant Funded Funded No Programs, Sergeant moves to I Adult Jail Notes: Jail population is estimate only Aramark Contract status is unknown Could have impact on Juvenile Immate worker program changes need to be defined January 6, 2004 Exhibit Page of 7— Deschutes County Budget Fiscal Year 2004-05 Personnel Cost Assumptions 1. Budget officer is proposing a 2% cost -of -living -adjustment (COLA) into the payroll calculations. 2. Those departments currently on a reduced work week will budget to remain so. Other salaries will be calculated based on 172.67 hours per month for employees in those departments that are currently less than 173.33. This assumes that employees will take one unpaid leave day -- the day after Thanksgiving. All departments/employees currently operating at the full 173.33 hours will remain so. 3. PERS is calculated at the 6% employee portion and 13.59% employer portion. 4. Health/Dental benefits is calculated with a 15% increase over current year. Exhibit "age F of l DESCHUTES COUNTY BUDGET FISCAL YEAR 2004-05 BUDGET COMMITTEE CALENDAR Friday, May 7, 2004 Friday, May 14, 1 — 5 p.m. Monday, May 17, 1 — 5 p.m. Tu es ay, May 18, 1 — 5 p.m. Wednesday, May 19,11:30 a.m. Wednesday, May 19, 1 — 5 p.m. Thursday, May 20, 1 — 5 p.m. Friday, May 21, 1 — 5 p.m. Budget Notebooks Delivered First Budget Committee Meeting Departmental Budget Presentations Departmental Budget Presentations Elected Officials Comp Committee Departmental Budget Presentations Departmental Budget Presentations Budget Approval Exhibit F ?age of RESOURCES: Beg. Net Working Capital Revenues Property Taxes Gen. Rev. - excl. Taxes Assessor County Clerk BOPTA BOCC District Attorney Finance/Tax Veterans Property Management Surveyor Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Assessor County Clerk BOPTA BOCC District Attorney Finance/Tax Veterans Property Management Surveyor Non -Departmental Contingency Transfers Out TOTAL REQUIREMENTS GENERALFUND Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Annual Year End $ % Budget Actual I Variance IFY % I Coll. % Budget Projection Variance Variance $ 4,000,000 $ 4,315,712 $ 315,712 100% 108% " : '. $ 4,000,000 $ 4,315,712 $ 315,712 8% 6,616,500 11,726,634 5,110,134 50% 89%' '" 13,233,000 13,233,000 - 0% 807,626 1,095,748 288,122 50% 68%,;i, ,,< 1,615,252 1,615,252 _ 0% 508,359 652,483 144,124 50% 64%1;,,;° 1,016,718 1,292,796 276,078 27% 690,500 1,252,443 561,943 50% 91% " 1,381,000 1,828,713 447,713 32% 6,993 9,389 2,396 50% 67% 13,986 18,713 4,727 34% - 29,528 29,528 50% n/a - 29,528 29,528 n/a 102,767 78,574 (24,193) 50% 38% 205,533 205,533 - 0% 107,725 146,800 39,075 50% 68% 215,450 286,924 71,474 33% 4,900 3,877 (1,023) 50% 40%111 9,800 9,800 - 0% 45,500 45,504 4 50% 50% 91,000 91,000 - 0% 86,000 115,562 29,562 50% 67% 172,000 172,000 - 0% 8,976,870 15,156,542 6,179,672 50% 84% .,.. 17,953,739 18,783,259 829,520 5% 12,976,870 19,472,254 6,495,384 50% 89%•„ 21,9539739 23,098,971 1,145,232 5% Exp. % _ . 1,491,549 1,449,865 41,684 50% 49% 2,983,097 2,983,097 - 0% 523,370 417,260 106,110 50% 40% 1,046,740 1,046,740 - 0% 24,948 17,384 7,564 50% 35%'e,-,'49,895 49,895 - 0% 239,621 244,222 (4,601) 50% 51% ` 479,242 479,242 - 0% 1,491,695 1,405,749 85,946 50% 47% "• " 2,983,389 2,983,389 - 0% 341,058 342,495 (1,437) 50% 50% ', 682,115 682,115 - 0% 69,819 66,819 3,000 50% 48% 139,637 139,637 - 0% 60,108 52,631 7,477 50% 44%• .. 120,215 120,215 - 0% 66,051 58,501 7,550 50% 44% :' 132,102 132,102 - 0% 375,577 429,213 (53,636) 50% 57% 751,153 751,153 - 0% 2,034,834 - 2,034,834 50% n/a 2,034,834 - 2,034,834 100% 6,718,630 4,484,139 2,234,491 50% 39%, 11,402,419 9,367,585 2,034,834 18% 4,924,177 4,637,064 287,113 50% 47% 9,848,354 9,848,354 - 0% 11,642,807 9,121,203 2,521,604 50% 43% 21,250,773 19,215,939 2,034,834 10% NET (Resources - Requirements) 1,334,063 10,351,051 9,016,988 Transfer of Appropriation to Public Safety Reserve (Fund 221) ' Unappropriated Ending Fund Balance (2,966) 700,000 Exhibit 7) Page of ! Z COMM JUSTICE -JUVENILE Statement of Financial Operating Data Six Months Ended December 31, 2003 NET (Resources - Requirements) 37,061 314,743 277,682 ' Unappropriated Ending Fund Balance a) Contract extended through November 30, 2003. Final bill of $18,333.34 sent Mid -November to Florida Atlantic University. b) JCP costs reimbursed quarterly for Maplestar, a Treatment Foster Care provider. First quarter payment received in November. c) Billings through November total $19,000. d) WellSpring (BRS) billing for October of $27,532 and November of $20,624 pending. Reimbursement waiting period is over six weeks. e) Year End Projection revised to reflect vacancy by Meadowlark and waived Kemple Dental Clinic fees. f) Revenue for graffiti cleanup unanticipated and not budgeted. g) Transfers from CCF and Public Safety Reserve complete as a result of CYIP closeout. h) Youth Diversion Program billed quarterly. Exhibit 1'o Page --?- of / Year to Date Year End Budget I Actual Variance FY % I Coll. % Budget Projection Variance RESOURCES: Beg. Net Working Capital $ 10,000 $ 121,802 $ 111,802 100% n/a>t $ 10,000 $ 121,802 $ 111,802 Revenues Federal Grants 80,101 71,904 (8,197) 50% 45% `a) ° 160,202 160,202 - SB #1065 -Court Assess. 18,000 21,406 3,406 50% 59% 36,000 36,000 - Discovery Fee 1,750 2,854 1,104 50% 82% , >:~ 3,500 3,500 - Food Subsidy 15,500 12,531 (2,969) 50% 40% 31,000 31,000 - Juvenile Crime Prevention 114,970 57,485 (57,485) 50% 25%,`'b).' 229,939 229,939 - Inmate/Prisoner Housing 25,000 28,500 3,500 50% 57% jc)' 50,000 50,000 - Inmate Commissary Fees 500 524 24 50% 52% 1,0001,000 - Contract Payments 102,286 28,379 (73,907) 50% 14% .`d)"i 204,572 204,572 - Miscellaneous 32,909 30,892 (2,017) 50% 47% : • 65,818 65,818 - MIP Diversion Fees 250 900 650 50% 180% 500 1,000 500 Interest on Investments 1,500 2,088 588 50% 70%, 3,000 3,000 - Leases 4,178 2,657 (1,521) 50% 32%."e)n 8,355 5,693 (2,662) Grants -Private - 1,000 1,000 50% n/a f), - 1,000 1,000 Total Revenues 396,944 261,120 (135,824) 50% 33% .: , E 793,886 792,724 (1,162) Transfers In -General Fund 2,216,169 2,216,169 - 50% 50%' 4,432,338 4,432,338 - Transfers In -CCF (CYIP) 105,000 230,017 125,017 50% 110%,•;g}: 210,000 230,017 20,017 Transfers In -Sheriff 30,000 30,000 - 50% 50%' h) ;' 60,000 60,000 - Transfers In -Pub Safety Rsv 45,000 92,966 47,966 50% 103%"g): 90,000 92,966 2,966 TOTAL RESOURCES 2,803,113 2,952,074 148,961 50% 53%;""5,596,224 5,729,847 133,623 REQUIREMENTS: Exp Expenditures Juv Community Justice 1,602,347 1,537,309 65,038 50% 48% 3,204,692 3,204,692 - Juv Resource Center 1,077,828 1,100,022 (22,194) 50% 51% 2,155,655 2,155,655 - Contingency 85,877 - 85,877 50% 0% 85,877 - 85,877 TOTAL REQUIREMENTS 2,766,052 2,637,331 128,721 50% 48% '- 5,446,224 5,360,347 85,877 NET (Resources - Requirements) 37,061 314,743 277,682 ' Unappropriated Ending Fund Balance a) Contract extended through November 30, 2003. Final bill of $18,333.34 sent Mid -November to Florida Atlantic University. b) JCP costs reimbursed quarterly for Maplestar, a Treatment Foster Care provider. First quarter payment received in November. c) Billings through November total $19,000. d) WellSpring (BRS) billing for October of $27,532 and November of $20,624 pending. Reimbursement waiting period is over six weeks. e) Year End Projection revised to reflect vacancy by Meadowlark and waived Kemple Dental Clinic fees. f) Revenue for graffiti cleanup unanticipated and not budgeted. g) Transfers from CCF and Public Safety Reserve complete as a result of CYIP closeout. h) Youth Diversion Program billed quarterly. Exhibit 1'o Page --?- of / SHERIFF Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection Variance RESOURCES: _ Beg. Net Working Capital $1,649,770 $1,960,788 $ 311,018 100% 119% $1,649,770 $1,960,788 $ 311,018 Revenues Tax Revenues - Current 4,605,048 8,186,594 3,581,546 50% 89% . 9,210,095 9,260,000 49,905 Tax Revenues - Prior 150,000 247,106 97,106 50% 82%'._ 300,000 380,000 80,000 Federal Grants 5,243 23,161 17,918 50% 221% a)= 10,486 85,651 75,165 U.S. Forest Service 36,000 48,000 12,000 50% 67%„b)° 72,000 72,000 - State Grant 247,036 89,211 (157,825) 50% 18% ,e)' 494,072 431,572 (62,500) SB #1065 -Court Assess. 17,500 21,406 3,906 50% 61%, 35,000 35,000 Marine Board Lic. Fee 43,835 - (43,835) 50% 0%; d)` 87,670 67,501 (20,169) Narcotic Task Force Grt. 55,000 55,000 - 50% 50% ,=; 110,000 110,000 Transp. of State Wards 3,875 (125) (4,000) 50% -2% 7,750 7,750 SB 1145 643,500 780,106 136,606 50% 61% e)= 1,287,000 1,287,000 - City of Redmond - 5,000 5,000 50% n/a. f), - 5,000 5,000 City of Sisters 155,853 155,853 - 50% 50%' 311,705 311,705 - Sale Map Photo or Copies - 53 53 50% n/a - 53 53 Fingerprinting Fees - 70 70 50% n/a - 70 70 Security & Traffic Reimb 32,500 211,388 178,888 50% 325%I g}• 65,000 184,144 119,144 Seat Belt Program 1,750 3,025 1,275 50% 86%`;. -.• 3,500 3,500 - Inmate/Prisoner Housing - 1,645 1,645 50% n/a, :; - 1,645 1,645 Contract Payments 500 20,395 19,895 50% 2040%; h};; 1,000 27,869 26,869 Inmate Commissary Fees 29,500 27,679 (1,821) 50% 47% 59,000 59,000 - Soc Sec Incentive -Fed 2,000 800 (1,200) 50% 20%.,:4,000 4,000 Miscellaneous 11,500 10,081 (1,419) 50% 44%' 23,000 23,000 Medical Services Reimb 3,000 5,084 2,084 50% 85%1... 6,000 6,000 - Restitution 300 2,883 2,583 50% 481%<-,, 600 5,766 5,166 Sheriff Fees 73,500 72,169 (1,331) 50% 49%` 147,000 147,000 - Court Fines and Fees 47,500 44,027 (3,473) 50% 46%;= <`. 95,000 95,000 Impound Fees 18,500 18,450 (50) 50% 50%,; 37,000 37,000 Interest 19,300 11,889 (7,411) 50% 31%°' 38,600 38,600 - Interest on Unsegregated 1,570 1,372 (198) 50% 44% .:> 3,140 3,140 Rentals 21,667 21,974 307 50% 51%'> ::,' 43,333 43,333 Interfund Contract 204,248 113,537 (90,711) 50% 28%' i) 408,495 308,495 (100,000) Transport Reimbursements - 3,918 3,918 50% n/a` - 3,918 3,918 Total Revenues 6,430,225 10,181,751 3,751,526 50% 79% 12,860,446 13,044,712 184,266 Transfers In 1,419,000 1,045,411 (373,589) 50% 37%`' 2,838,000 2,838,000 TOTAL RESOURCES 9,498,995 13,187,950 3,688,955 50% 76% 17,348,216 17,843,500 495,284 REQUIREMENTS: Exp. % ,# EXPENDITURES & TRANSFERS Sheriffs Division 627,130 609,143 17,987 50% 49% j) 1,254,259 1,471,898 (217,639) Automotive/Communications 534,798 575,348 (40,550) 50% 54%'k), 1,069,596 1,069,596 Investigations Division 709,167 687,654 21,513 50% 48% . ±; 1,418,334 1,418,334 Patrol Safety Division 3,011,681 3,104,562 (92,881) 50% 52% I); 6,023,361 6,117,000 (93,639) Records 266,705 233,331 33,374 50% 44% ` 533,410 533,410 Corrections (Jail) Div. 2,871,818 2,756,461 115,357 50% 48% tn) 5,743,635 5,743,635 - Transport/Court Security 80,550 74,853 5,697 50% 46% 161,100 161,100 - Emergency Services 90,549 86,465 4,084 50% 48%> 181,097 181,097 - Special Services Division 202,375 146,816 55,559 50% 36% n) 404,749 404,749 - r( Training Division 82,419 62,085 20,334 50% 38%'o): 164,838 164,838 - Contingency 183,837 183,837 50% 0% 183,837 - 183,837 Transfers Out 105,000 30,000 75,000 50% 14% - 210,000 210,000 - _ o M TOTAL REQUIREMENTS 8,766,029 8,366,718 399,311 50% 48% 17,348,216 17,475,657 (127,441) NET (Resources - Requirements) 732,966 4,821,232 4,088,266 - 367,843 367,843 Sheriff Notes Statement of Financial Operating Data Six Months Ended December 31, 2003 a) New federal grant of $62,500 from Department of Health and Human Services for Children of Prisoners program appropriated under State Grant Revenue. Unbudgeted payments for prior year programs received in current year contribute to favorable Budget to Projection variance. b) Year to date variance attributed to timing of US Forest Service payments of $6,000 per month. c) Year to date variance due to the Domestic Preparedness Equipment grant of $302,250. Reimbursement for equipment will be requested when purchases occur in the third quarter. d) First semi-annual billing for Marine Patrol, estimated at $35,000, to occur in January. State Marine Board funding for FY 03-04 reduced to $67,501. e) S131 145 annual payments may exceed budget depending on outcome of tax surcharge measure. f) Payment for software maintenance. g) US Forest Service reimbursement payment for July's Davis fire ($50,989), Link fire ($49,173) and B & B fire ($67,757) partially offsets over budget expenditures in Patrol. h) Unplanned reimbursement from Bend and Redmond for use of multiple agency mug shot system. i) Year to Date Variance and Year End Projection reflect timing of Title III billings. Carryover to next fiscal year anticipated to be $100,000. j) Year to Date Variance is a result of salary savings for unfilled secretary position (August -November). Year End Projection includes unplanned expenses for legal, citizen survey and uniforms. Contingency of $183,837 included in projected expenditures. k) Year to Date Variance is a result of timing on capital purchases funded by Emergency Preparedness Grant of $302,250. Payments should occur in the third quarter. l) Year to Date Variance is a result of timing on purchase for patrol vehicles. Overtime will exceed budget for the year by atleast $70,000 due, in large part, to fire patrol (reimburseable from USFS- see footnote g). Expenses for relocation of La Pine substation not budgeted. m) Salary savings on unfilled positions and timing of inmate medical services and board contribute to the Year to Date Variance. Year End Projection includes $35,026 for Children of Prisoners program expense. n) Year to Date Variance due to timing of purchase of SAR laptops for $32,122 (Title III reimburseable expenditure). o) Year to Date Variance due to timing of $37,565 payment for System 3000 training equipment. Exhibit Page cam- � _ of RESOURCES: Beg. Net Working Capital Revenues State Grant Child Dev & Rehab Center State Miscellaneous STARS Foundation HMO Oregon OMAP Family Planning Exp Proj School Districts Contract Payments/ESD Miscellaneous Patient Insurance Fees Health Dept/Patient Fees Vital Records -Birth Vital Records -Death Interest on Investments Donations Interfund Contract Administrative Fee Total Revenues HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual I Variance I FY % Coll. % Budget Projection Variance $ 540,000 $ 674,097 $ 134,097 100% 125% 554,263 555,107 844 15,895 17,658 1,763 31,138 39,410 8,272 7,675 15,350 7,675 5,225 3,280 (1,945) 79,850 65,359 (14,491) 251,000 188,962 (62,038) 4,300 1,035 (3,265) 7,538 14,679 7,141 - 340 340 31,510 23,395 (8,115) 44,175 71,472 27,297 8,250 9,476 1,226 31,125 26,853 (4,272) 6,500 4,577 (1,923) 4,650 19,231 14,581 28,405 12,453 (15,952) - 3,498 3,498 1,111,499 1,072,135 (39,364) 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 56% 63% 100% 31% 41% 38% 12% 97% n/a 37% 81% 57% 43%' 35%' 207% 22%, n/a 48%' Transfers In -General Fund 921,906 921,906 - 50% 50% TOTAL RESOURCES 2,573,405 2,668,138 94,733 50% 58% REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency $ 540,000 $ 674,097 $ 134,097 1)`^^ 1,108,525 1,190,371 81,846 31,790 31,790 - },, 62,276 86,378 24,102 15,350 15,350 - }j 10,450 10,450 - 159,700 159,700 - 502,000 495,000 (7,000) 8,600 8,600 - 15,075 15,075 - - 340 340 63,020 52,926 (10,094) 88,350 135,586 47,236 16,500 16,500 - 62,250 62,250 - 13,000 9,154 (3,846) 9,300 32,800 23,500 56,810 49,810 (7,000) - 3,498 3,498 2,222,996 2,375,578 152,582 Yt 1,843,812 1,843,812 - 4,606,808 4,893,487 286,679 1,496,018 1,474,344 21,674 50% 49% 2,992,036 2,967,000 25,036 516,113 467,932 48,181 50% 45% .- 1,032,225 1,032,225 - 27,169 10,287 16,882 50% 19%' 54,338 54,338 - 75,000 75,000 - 50% 50%: , " 150,000 150,000 - 78,209 - 78,209 50% n/a,,".-,"' 78,209 - 78,209 TOTAL REQUIREMENTS 2,192,509 2,027,563 164,946 50% 47% NET (Resources - Requirements) 380,896 640,575 259,679 ' Unappropriated Ending Fund Balance 4,306,808 4,203,563 103,245 300,000 689,924 389,924 a) Projections reflect revised state grant contract totals. The new grant dollars require additional costs in Personnel and Materials & Services. b) Fiscal Year 03-04 contract increased to $86,378. c) In October OMAP changed coding and funding due to HIPPA requirements and funding level changes (Oregon Health Plan changes). The State has experienced technical difficulties and payments on new codes have not been made. This two month delay has been partially resolved. d) Payment rates for Family Planning will decrease on 1/1/04. Revenue was budgeted conservatively reducing the full impact of the decrease. Year to Date revenue reflects payments for services through November 6th. Payments are typically received one month in arrears. e) The State has discouraged private insurance billing on immunizations. Health Department has emphasized fee collection to compensate for this billing issue and it is anticipated all combined patient billing will exceed budget by year end. I RESOURCES: Beg. Net Working Capital Revenues Marriage Licenses Divorce Filing Fees State Grant State Miscellaneous ABHA-Inpatient Title 19 Liquor Revenue ABHA Client Support Funds ABHA Quality Assurance School Districts Mental Health Jail Comp Miscellaneous Patient Insurance Fees Patient Fees Interest on Investments Rentals Donation Administrative Fee MENTAL HEALTH Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual I Variance FY % Coll. % ` Budget I Projection I Variance $1,350,646 $ 1,623,085 $ 272,439 100% 120%;,',',1-"!'-"i'$1,350,646 $1,623,085 $ 272,439 2,750 3,115 365 50% 57%_., 47%`' ` , 5,500 6,230 730 52,500 52,467 (33) 50% 50%. 50%'; ` 105,000 104,934 (66) 4,203,190 4,040,453 (162,737) 50% 48% a} 8,406,379 7,574,936 (831,443) 142,273 95,495 (46,778) 50% 34% b)"':284,546 284,546 - 65,368 99,726 34,358 50% 76%, C} 130,736 165,094 34,358 156,000 89,665 (66,335) 50% 29%; d) 312,000 200,000 (112,000) 43,000 42,485 (515) 50% 49% 86,000 86,000 - 4,000 10,417 6,417 50% 130% a?), 8,000 20,834 12,834 19,500 - (19,500) 50% 0%'; f) 39,000 - (39,000) 121,500 72,750 (48,750) 50% 30% 10,000 243,000 243,000 243,000 - 3,600 3,930 330 50% 55%j b) 7,200 9,180 1,980 53,734 32,039 (21,695) 50% 30%.b).< - 107,467 107,467 - 52,500 43,314 (9,186) 50% 41%; s 105,000 86,628 (18,372) 5,150 9,200 4,050 50% 89%3' 10,300 14,350 4,050 15,000 16,261 1,261 50% 54%' 2,093,323 30,000 32,522 2,522 3,150 6,540 3,390 50% 104% h)_ 6,300 13,000 6,700 - 100 100 50% n/a'; ; - 150 150 1,090,258 1,090,260 2 50% 50%'' , 2,180,516 2,180,516 - Total Revenues 6,033,473 5,708,217 (325,256) 50% 47%`' ` , 12,066,944 11,129,387 (937,557) Transfers In -General Fund 562,147 562,146 (1) 50% 50%'; ` 1,124,293 1,124,293 Transfers In -Other 110,911 110,910 (1) 50% 50%'W = 221,821 221,821 - TOTAL RESOURCES 8,057,177 8,004,358 (52,819) 50% 54%' - 14,763,704 14,098,586 (665,118) REQUIREMENTS: EXp. °io r Expenditures Personal Services 2,484,684 2,468,120 16,564 50% 50% 4,969,368 4,936,240 33,128 Materials and Services 4,436,156 3,367,915 1,068,241 50% 38%' a) 8,872,312 7,518,830 1,353,482 Capital Outlay 5,000 - 5,000 50% 0% " 10,000 10,000 - Transfers Out 75,000 75,000 - 50% 50% 150,000 150,000 - Contingency 762,024 - 762,024 50% n/a, 762,024 - 762,024 TOTAL REQUIREMENTS 7,762,864 5,911,035 1,851,829 50% 40%',t;,, ,,' 14,763,704 12,615,070 2,148,634 NET (Resources - Requirements) 294,313 2,093,323 1,799,010 - 1,483,516 1,483,516 a) Budgeted third party pass-through funds (revenues and expenditures) reduced by nearly 15% to reflect final State figures. Budgeted CRC expenditures of approximately $600,000 have not yet occurred. b) Billings to other government entities prepared in arrears. c) In addition to Park Place occupancy running at capacity, a larger ratio of OHP clients has increased payments from OMAP. d) Reflects partial loss of mental health benefits for this population. e) Revenue is expected to exceed budget due to a change in the ration of ABHA categories (County Consumer and Individual Consumer). County Consumer ratio has increased and is the category credited directly to Mental Health (Fund 275). f) Contract terminated at beginning of current fiscal year. g) Services to school districts commence on 9/15/03 and are billed quarterly in arrears. h) Rental revenue anticipated to exceed budget. RESOURCES: Beg. Net Working Capital Revenues Admin -Operations Admin -GIS Admin -Code Enforcement Building Safety Electrical Contract Services Env Health -On Site Prog Env Health-Lic Facilities Env Health -Grant Env Health - Drinking H2O Planning -Current Planning -Long Range COMMUNITY DEVELOPMENT Statement of Financial Operating Data Six Months Ended December 31, 2003 Total Revenues 2,873,214 3,033,658 160,444 50% 53% Transfers In -CDD Reserve 50 - (50) 0% 0% TOTAL RESOURCES 3,074,469 3,180,489 106,020 50% 53% REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Division Year to Date 884,209 224,041 Admin -GIS Division J 79,424 Year End Admin -Code Enforcement Budget Actual Variance FY % Coll. % {I (559) Budget � Projection Variance (3,969) Contract Services 136,499 135,314 1,185 Env Health -On Site Pgm 192,029 $ 201,205 $ 146,831 (54,374) 100% n/a ;-," $ 201,205 $ 146,831 (54,374) 21,453 29,640 8,187 50% 69% a) 42,905 50,000 7,095 7,663 6,399 (1,264) 50% 42% ti)'' 15,325 15,325 - 107,525 125,179 17,654 50% 58% c)` 215,050 215,050 - 872,100 958,831 86,731 50% 55% c)''. 1,744,200 1,744,200 - 231,163 255,703 24,540 50% 55% 'c} 1 462,325 462,325 - 230,000 352,155 122,155 50% 77% d) ; 460,000 600,000 140,000 363,300 356,999 (6,301) 50% 49%;; ,, . 726,600 726,600 - 194,745 214,472 19,727 50% 55% e) 389,490 389,490 - 181,473 26,665 (154,808) 50% 7% f),. 362,945 347,000 (15,945) 25,025 29,414 4,389 50% 59% c) 50,050 50,050 - 419,688 420,393 705 50% 50%;" 839,375 839,375 - 219,079 257,808 38,729 50% 59% 9);° 438,157 438,157 - Total Revenues 2,873,214 3,033,658 160,444 50% 53% Transfers In -CDD Reserve 50 - (50) 0% 0% TOTAL RESOURCES 3,074,469 3,180,489 106,020 50% 53% REQUIREMENTS: EXPENDITURES & TRANSFERS Admin -Operations Division 1,108,250 884,209 224,041 Admin -GIS Division 81,144 79,424 1,720 Admin -Code Enforcement 70,068 72,618 (2,550) Building Safety Division 413,492 414,051 (559) Electrical Division 161,564 165,533 (3,969) Contract Services 136,499 135,314 1,185 Env Health -On Site Pgm 192,029 143,988 48,041 Env Health-Lic Facilities 140,479 131,451 9,028 Env Health -Grant Division 112,675 71,357 41,318 Env Health - Drinking H2O 19,867 17,390 2,477 Planning -Current Division 342,821 336,631 6,190 Planning -Long Range Div 194,978 210,965 (15,987) TOTAL REQUIREMENTS 2,973,866 2,662,931 5,746,422 100 5,947,727 5,877,572 131,150 100 - 6,024,503 76,776 50% 40% fi `' 2,216,500 2,162,126 50% 49%-`.. ' 162,288 162,288 50% 52%.,h), 140,136 140,136 50% 50%11"" 826,983 826,983 50% 51% i), 323,127 323,127 50% 50% ; .' 272,997 272,997 50% 37% 384,058 384,058 375,000 50% 47% ;"j) 280,958 275,000 50% 32% j) 225,350 210,000 50% 44% j) 39,733 37,000 50% 49% " " : 685,642 685,642 50% 54% i) 389,955 389,955 310,935 50% NET (Resources - Requirements) 100,603 517,558 416,955 54,374 9,058 5,958 15,350 2,733 45% " 5,947,727 5,860,254 87,473 164,249 164,249 a) Several miscellaneous revenue sources are higher than expected for this point in the fiscal year. b) Budgeted Title III grant of $5,000 has not been received. Payment anticipated by fiscal year end. c) Revenue fluctuates by season. The period of July to October is typically a high activity period. d) Projection adjusted for Redmond contract which is expected to exceed budget estimates. e) Licensed Facility revenue is received primarily in December, January & February after annual license renewals are mailed. f) Environmental Health -Grant revenue lags 2-3 months because of the state grant billing process. g) Long range planning revenue includes a $42,000 National Fire Plan grant. h) Code Enforcement expenses include payouts/reserves associated with the retirement of the Code Enforcement Technician. i) Personnel Services (extra help) increased to cover position while employee was on leave in Electrical Division. Long Range Planning had two grant funded interns June -August. j) Environmental Health expenditures low due to salary savings on unfilled full time Environmental Health Director position. Exhibit T, Page -_ of ( Z ROAD Statement of Financial Operating Data Six Months Ended December 31, 2003 REQUIREMENTS: I Exp. % Expenditures Personal Services 2,015,610 Year to Date 51,185 50% 49% 4,031,220 Year End Materials and Services 2,794,991 Budget Actual Variance FY % Coll. % 5,589,982 Budget Projection Variance RESOURCES: 50% 11% ;i}.,', 3,034,000 3,034,000 - Transfers Out 412,500 805,000 (392,500) Beg. Net Working Capital $ 3,772,974 $ 3,767,888 $ (5,086) 100% 100% $ 3,772,974 $ 3,767,888 $ (5,086) Revenues 700,576 - 700,576 Federal Mineral Leases - 19,947 19,947 50% n/aFa).z - 19,947 19,947 Forest Receipts 1,465,000 2,928,117 1,463,117 50% 100% a)... 2,930,000 2,928,117 (1,883) State Grant 165,902 332,304 166,402 50% 100% b}:� 331,804 332,304 500 State Miscellaneous - 112,977 112,977 50% n/a - 112,977 112,977 Motor Vehicle Revenue 3,000,000 3,427,723 427,723 50% 57% 6,000,000 6,000,000 - City of Bend 25,000 29,633 4,633 50% 59% c}` 50,000 50,000 - City of Redmond 50,000 158,827 108,827 50% 159% ";c), 100,000 158,827 58,827 Miscellaneous 16,000 20,898 4,898 50% 65% ',,, 32,000 32,000 - Road Vacations 1,500 - (1,500) 50% 0% 3,000 3,000 - Interest on Investments 35,000 24,053 (10,947) 50% 34%.__ 70,000 70,000 - Equipment Repairs 100,000 78,276 (21,724) 50% 39% .d) 200,000 200,000 - Vehicle Repairs 32,500 - (32,500) 50% 0% e),,! 65,000 65,000 - LID Construction 37,500 - (37,500) 50% 0% 75,000 75,000 - Vegetation Management 25,000 - (25,000) 50% „fy, 0%� g)' 50,000 50,000 - Land Sale Revenue 125,000 - (125,000) 50% 0% h) :' 250,000 250,000 - Sale of Eqp & Material 125,000 118,726 (6,274) 50% 47% ;. '; 250,000 250,000 Sale of Public Lands 500 225 (275) 50% 23% 1,000 1,000 - Total Revenues 5,203,902 7,251,706 2,047,804 50% 70% 10,407,804 10,598,172 190,368 TOTAL RESOURCES 8,976,876 11,019,594 2,042,718 50% 63% 14,180,778 14,366,060 185,282 REQUIREMENTS: I Exp. % Expenditures Personal Services 2,015,610 1,964,425 51,185 50% 49% 4,031,220 4,031,220 - Materials and Services 2,794,991 2,165,839 629,152 50% 39% 5,589,982 5,589,982 Capital Outlay 1,517,000 326,491 1,190,509 50% 11% ;i}.,', 3,034,000 3,034,000 - Transfers Out 412,500 805,000 (392,500) 50% 98% j}: , 825,000 825,000 - Contingency 700,576 - 700,576 50% n/a 700,576 - 700,576 TOTAL REQUIREMENTS 7,440,677 5,261,755 2,178,922 50% 37% NET (Resources - Requirements) 1,536,199 5,757,839 4,221,640 a) Annual payments received in November (Mineral Leases) and December (Forest Receipts). b) Project has not been started. Bills to be submitted as work is completed. c) Bills to be issued upon completion of work. d) County departments billed monthly in arrears. e) Revenue to be received in June from Fund 340. f) Revenue to be received in June from Fund 430. g) Revenue to be received in June from Fund 326. h) Receipt of $62,595 recorded in January for sale of La Pine property. i) Capital Projects will be paid at completion. j) Total budgeted transfer to Road Building & Equipment Fund completed in November. 14,180,778 13,480,202 700,576 Exhibit P Page of / Z- RESOURCES: Beg. Net Working Capital Revenues State Grant State Miscellaneous Probation Work Crew Fees Alcohol and Drug Treatment Miscellaneous Electronic Monitoring Fee Probation Superv. Fees Cognitive Program Sex Offender Treatment Fees Day Reporting Fees Misdemeanor Probation Fee Interest on Investments Leases Sale of Eqp & Material Total Revenues Transfers In -General Fund TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Contingency TOTAL REQUIREMENTS NET (Resources - Requirements) ADULT PAROLE & PROBATION Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual I Variance FY % Coll. % Budget Projection Variance $ 123,110 $ 61,812 $ (61,298) 100% 50%' :. $ 123,110 $ 61,812 $ (61,298) 786,701 953,463 166,762 50% 61% a), 1,573,402 1,573,402 - 4,946 5,334 388 50% 54% ., a);`. 9,891 9,891 - 5,000 5,930 930 50% 59% �b) ' 10,000 13,000 3,000 238 403 165 50% 85% C),_475 156,598 700 225 1,050 1,766 716 50% 84% d) ' 2,100 1,766 (334) 80,000 91,971 11,971 50% 57% 160,000 190,000 30,000 116,500 86,083 (30,417) 50% 37% e) 233,000 233,000 - - 30 30 50% n/a - 30 30 2,650 995 (1,655) 50% 19% f) 5,300 2,000 (3,300) 210 - (210) 50% 0% 420 100 (320) - 585 585 50% n/a - 585 585 4,850 1,839 (3,011) 50% 19% g} 9,700 3,700 (6,000) 1,500 2,250 750 50% 75%E h) ° 3,000 4,500 1,500 500 - (500) 50% 0% 011, 1,000 - (1,000) 1,004,145 1,150,649 146,504 50% 57% 2,008,288 2,032,674 24,386 86,112 86,112 1,213,367 1,298,573 - 50% 50% 85,206 50% 56% 172,223 172,223 2,303,621 2,266,709 (36,912) 826,982 841,283 (14,301) 50% 51%.;:`; 1,653,964 1,653,964 - 246,480 209,558 36,922 50% 43% 492,959 450,000 42,959 50 - 50 50% 0% 100 100 - 156,598 - 156,598 50% n/a, 156,598 - 156,598 1,230,110 1,050,841 179,269 50% 46% 2,303,621 2,104,064 199,557 (16,743) 247,732 264,475 - 162,645 162,645 a) Budget approved by State Legislature larger than expected. Defeat of Measure 30 in February election will reduce amount allocated significantly. b) Court imposing work crew community service more often than anticipated. c) Offenders with positive drug testing being charged more consistently. d) Video sales, witness and subpoena fees higher than anticipated. e) Revenue lower than anticipated. Full amount budgeted may still be received. f) Therapist is facilitating group and collecting offender fees directly as payment. g) Revenue lower than anticipated. h) Leasing more space than anticipated. Exhibit 1�p Page f of ( Z SOLID WASTE Statement of Financial Operating Data Six Months Ended December 31, 2003 Exhibit T Page /U of / Z Year to Date Year End Budget Actual Variance FY % Coll. % Budget Projection r Variance RESOURCES: Beg. Net Working Capital $ 887,997 $ 1,064,193 $ 176,196 100% 120%",- $ 887,997 $ 1,064,193 $ 176,196 Revenues State Grant 7,500 - (7,500) 50% 0%`_ _' 15,000 15,000 - Miscellaneous 9,475 11,000 1,525 50% 58% 18,950 18,950 - Franchise 3% Fees 60,000 26,160 (33,840) 50% 22% a)<; 120,000 120,000 - Commercial Disp. Fees 375,000 420,400 45,400 50% 56% 750,000 750,000 - Private Disposal Fees 787,500 811,384 23,884 50% 52% . 1,575,000 1,575,000 - Franchise Disposal Fees 1,750,000 1,936,471 186,471 50% 55%t; . 3,500,000 3,500,000 - Yard Debris 15,500 17,181 1,681 50% 55% b) 31,000 31,000 - Special Waste 17,500 12,496 (5,004) 50% 36% c), 35,000 35,000 - Interest 15,000 13,931 (1,069) 50% 46% 30,000 30,000 - Sale of Equip & Material 1,000 3,573 2,573 50% 179%;;d)-! 2,000 3,573 1,573 Total Revenues 3,038,475 3,252,596 214,121 50% 54%1 6,076,950 6,078,523 1,573 TOTAL RESOURCES 3,926,472 4,316,789 390,317 50% 62% , 6,964,947 7,142,716 177,769 REQUIREMENTS Exp. % .• Expenditures Personal Services 609,314 572,983 36,331 50% 47%..F.;, 1,218,628 1,218,628 - Materials and Services 1,466,161 878,290 587,871 50% 30% 2,932,322 2,932,322 - Capital Outlay 16,500 21,453 (4,953) 50% 65% "' 33,000 33,000 - Transfers Out 1,119,372 207,109 912,263 50% 9% 2,238,744 2,238,744 - Contingency 542,253 - 542,253 50% n/a, 542,253 - 542,253 TOTAL REQUIREMENTS 3,753,600 1,679,835 2,073,765 50% 24% 6,964,947 6,422,694 542,253 NET (Resources - Requirements) 172,872 2,636,954 2,464,082 - 720,022 720,022 a) Franchise payments are due April 15th. b) Revenue is seasonal. c) Revenue derived from clean-up projects and is unpredictable. d) Unanticpated revenue from sale of recyclables. Exhibit T Page /U of / Z RESOURCES: Beg. Net Working Capital Revenues Property Taxes - Current Property Taxes - Prior State Reimbursement Telephone User Tax Data Network Reimb. Jefferson County Alarm Monitoring Fees User Fee Miscellaneous Interest Interest on Unsegregated Tax Total Revenues TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfers Out Contingency DESCHUTES COUNTY 911 Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual I Variance I % of FY % Coll. I Budget Projection I Variance $ 548,000 $ 561,483 $ 13,483 100% 102% ' <;: $ 548,000 $ 561,483 $ 13,483 1,225,000 2,307,296 1,082,296 50% 94% 2,450,000 2,450,000 - 30,000 42,609 12,609 50% 71% '.;=; 60,000 60,000 - 2,850 1,478 (1,372) 50% 26%- 5,700 5,700 - 218,500 121,350 (97,150) 50% 28%':,,a,) 437,000 437,000 - 15,000 - (15,000) 50% 0% b), 30,000 30,000 - 10,000 11,578 1,578 50% 58%" 20,000 20,000 - 3,000 6,480 3,480 50% 108% >' 6,000 6,480 480 10,000 2,156 (7,844) 50% 11% `'c) 20,000 20,000 - 3,000 11,680 8,680 50% 195%. 6,000 11,680 5,680 7,500 4,246 (3,254) 50% 28%..`, 15,000 15,000 - 350 375 25 50% 54%'a 700 700 - 1,525,200 2,509,248 984,048 50% 82% - 3,050,400 3,056,560 6,160 2,073,200 3,070,731 997,531 50% 85%< 3,598,400 3,618,043 19,643 1,035,475 979,320 56,155 218,751 203,095 15,656 325,527 104,085 221,442 32,500 - 32,500 373,897 - 373,897 TOTAL REQUIREMENTS 1,986,150 1,286,500 699,650 NET (Resources - Requirements) 87,050 1,784,231 1,697,181 a) Revenue received quarterly in arrears. b) Billing for Data Network charges are pending Eboard review. c) Budgeted revenues are expected to be received in full. 50% 50% 50% 50% 50% 50% 47%'', 2,070,949 2,070,949 46% ,-� 437,501 437,501 - 16%'`"' 651,053 651,053 - 0% 65,000 65,000 - n/a 373,897 - 373,897 36% - ! 3,598,400 3,224,503 373,897 - 393,540 393,540 Exhibit Page _ T) l of / 2 - RESOURCES: Beg. Net Working Capital Revenues Federal Grants Title IV - Family Sup/Pres HealthyStart Medicaid Child Care Block Grant Level 7 Services Juvenile Crime Prevention State Prevention Funds HealthyStart /R -S -G OCCF Grant Miscellaneous Interest on Investments Grants -Private Total Revenues Comm. on Children & Families Statement of Financial Operating Data Six Months Ended December 31, 2003 Year to Date Year End Budget Actual I Variance IFY % I Coll. % Budget Projection Variance $ 776,691 $ 809,069 $ 32,378 100% 104% $ 776,691 $ 809,069 $ 32,378 52,899 80,605 27,706 50% 76%= 19,635 23,529 3,894 50% 60% 119,070 48,901 (70,169) 50% 21%. 24,098 3,331 (20,767) 50% 7% 60,690 84,766 24,076 50% 70% 196,639 185,233 (11,406) 50% 47%f, 38,503 37,150 (1,353) 50% 48% 80,735 348,150 267,415 50% 216%;, 190,845 311,748 120,903 50% 82% 1,000 4,285 3,285 50% 214%;` 7,500 6,794 (706) 50% 45%!: 13,000 575 (12,425) 50% 2% 804,614 1,135,067 330,453 Trans from General Fund 110,506 221,011 110,505 50% 100%' Trans from Other 67,000 134,000 67,000 50% 100%> Total Transfers In 177,506 355,011 177,505 5o% 1oo%' TOTAL RESOURCES REQUIREMENTS: Expenditures Personal Services Materials and Services Capital Outlay Transfer to Juvenile Contingency 105,797 172,207 66,410 39,270 31,372 (7,898) 238,140 198,901 (39,239) 48,195 53,393 5,198 121,380 109,122 (12,258) 393,278 355,587 (37,691) 77,005 77,005 - 161,469 348,150 186,681 381,689 311,748 (69,941) 2,000 3,785 1,785 15,000 14,250 (750) 26,000 26,000 - 1,609,223 1,701,520 92,297 221,011 221,011 - 134,000 134,000 - 355,011 355,011 1,758,811 2,299,147 540,336 50% 84% 2,740,925 2,865,600 124,675 191,587 189,036 2,551 50% 49%' '. 383,174 383,174 868,250 481,622 386,628 50% 28%'- 1,736,500 1,782,682 50 - 50 50% 0%,, , ' 100 100 115,009 230,017 (115,008) 50% 100%` 230,017 230,017 391,134 - 391,134 50% n/a 391,134 - (46,182) 391,134 TOTAL REQUIREMENTS 1,566,030 900,675 665,355 50% 33%'. 2,740,925 2,395,973 344,952 NET (Resources - Requirements) 192,781 1,398,472 1,205,691 - 469,627 469,627 a) Grants through OCCF adjusted to current State levels in projection column; Materials and Services adjusted accordingly. b) Year End Projection of Juvenile Crime Prevention funds reduced to current State level. Exhibit Page 12- of 12--