Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2004.03.17 - 27565
MISCELLANEOUS RESOLUTION 104072 March 18, 2004 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2004 FIRST QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENT TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the Adopted Budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget adjustments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, adjustments are required; and WHEREAS the Fiscal Year (FY) 2004 First Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS a budget amendment is recommended to transfer $8,000 from the Board of Commissioners' Salaries to Per Diems to more accurately reflect the budget and a transfer of $85,000 is requested from the Non-Departmental Legislative Expense account to the Board of Commissioners' Public Information account for the publication of the Board of Commissioner's Annual Report; and WHEREAS the Drain Commissioner is requesting to transfer $9,000 from Educational Supplies to Contracted Services to better reflect the services to be provided by SEMCOG to complete a comprehensive public education survey; and WHEREAS the Community Corrections Division is requesting an amendment to increase revenue and expenditure budgets in the amount of $117,000 as the result of an increase in activity for the drug testing program; and WHEREAS a new organization is recommended for Non-Departmental accounts to distinguish Use of Prior Years Funds (Use of Fund Balance), which totals $10,714,752 for FY 2004 and that budgets already approved should be transferred to this new category; and WHEREAS the Sheriff's Office has new contract rates in effect beginning January 1, 2004, which will increase revenues estimated at $757,000, and a budget amendment is recommended to increase the Sheriff's revenue budget and increase expenditure budget to offset a projected unfavorable variance in the amount of $868,000 for Outside County Prisoner Housing; and WHEREAS the Probate Court is projected to be unfavorable in the amount of $50,000 for Guardian Ad Litem Fees in FY 2004 and FY 2005, based on increased activity in caseload; and WHEREAS sufficient funds are available in the Non-Departmental Basic Adjustment account to offset the variance for Guardian Ad Litem Fees and Out County Prisoner Housing; and WHEREAS per M.R. #03326 an appropriation of $554,222 was authorized to cover a portion of Phase I of the Integrated E-Financial System Implementation Project Cost and a budget amendment is necessary to recognize the transfer to Major Department Support Projects Fund; and WHEREAS several amendments are recommended totaling $231,212 for both the FY 2004 and FY 2005 Budgets, to transfer funds within Departments from Motor Pool allocations to Building Liability Fund allocations, to more accurately reflect insurance charges for department owned vehicles; and WHEREAS a budget amendment of $209,382 for FY 2004 and $ 212,687 for FY 2005 is necessary to reflect an increase in Employee In-Service Training revenue and expenditures for personnel changes per M.R. #03139 (Human Resources Reorganization); and FINANCE COMMITTEE Motion carried unanimously on a roll call vote. Prior Year Balance Transfer to CLEMIS WHEREAS a budget amendment for FY 2004 and FY 2005 is recommended to transfer funds in the amount of $45,000 from the Fringe Benefit Fund Employee's In-Service Training account to In-Service Training - Info Tech account to centralize expense associated with PeopleSoft training under Information Technology; and WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2004 Special Revenue Budget for the Oakland Enhancement Fund (230) in the amount of $53,000, which is $7,000 less than the amount budgeted in the FY 2004 Adopted Budget; a budget amendment is recommended to reflect the amount as approved by the EDC Board; and WHEREAS Children's Village is requesting an upgrade to their Mugshot System to convert the current TFP/Printrak application to the new Dynamic Imaging application; and WHEREAS the general Mugshot System acquired by the COPS MORE Grant Fund has a requirement of deployment of police officers which will not be obtained from the Children's Village Mugshot System, and a budget amendment is requested to transfer $11,254 from the FY 2004 CLEMIS Match for COPS MORE Designated Fund Balance to purchase upgrade for the system; and WHEREAS $2,287,419 of previously unspent General Fund/General Purpose funds, designated for carry forwards, is requested to be appropriated to departments for use (Fund 101 - General Ledger Account 49407-079000), as reviewed and recommended by the Department of Management and Budget; and NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2004 First Quarter Financial Forecast. BE IT FURTHER RESOLVED that $2,287,419 from the FY 2004 Designated Fund Balance for Carry Forwards be appropriated as specified below: GENERAL FUND Revenue 90-150000-14000-1582 Prior Years Balance $ 2,287,419 Expenditures 12-24 000 0-4 1600-334 8 16-121000-10000-3348 19-221000-10000-3348 35-210000- 12 000-3 62 0 41-211000-41700-9169 43-023601-20000-9157 90-210000-95200-9007 HEALTH FUND Expenditures 16-233200-46000-4101 Equalization - Professional Svcs Human Services - Professional Svcs Planning & Econ Dev - Prof. Svc. Circuit Court - Special Projects Prosecutor - Misc. Capital Sheriff - Capital Outlay Equipment Non-Dept - Road Comm.- Northwestern Highway Extension Total General Fund Health Div. - Expend. Equip. Exp Total Health Fund Grand Total $ 40,000 71,250 31,000 8,369 3,500 129,500 2,000,000 $ 2,283,619 3,800 3,800 $ 2,287,419 BE IT FURTHER RESOLVED that $11,234 from the FY 2004 Designated Fund Balance for CLEMIS Match be appropriated as follows: GENERAL FUND Revenue 90-150000-14000-1582 Expenditure 90-310000-98278-8001 11,254 11,254 0 CLEMIS FUND (#635) Revenue 23-278113-98101-1701 IT - Transfer In Expenditure 23-278215-35001-9154 IT- Cap. Outlay - Comp. Equip. $ 11,254 $ 11,254 3 BE IT FURTHER RESOLVED that the Board authorizes the amendments to the FY 2004 and FY 2005 Budget as detailed in attached Schedule A (General Fund Activity) and Schedule B (Proprietary / Special Revenue Funds Activity). Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE OAKLAND* COUNTY MICHIGAN DEPARTMENT OF MANAGEMENT AND BUDGET irei4 11 Laurie Van Pelt, Director Wm. Art Holdsworth, Deputy Director L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE TO: Members of the Finance Committee FROM: Laurie Van Pelt, Director, Management and Budget Art Holdsworth, Deputy Director, Management and Budget Tim Soave, Manager, Fiscal Services Nancy Fournier, Chief, Fiscal Services LaVerne Smith, Supervisor of Fiscal Services SUBJECT: Letter of Transmittal - Fiscal Year 2004 First Quarter Report DATE: February 26, 2004 FY 2004 FORECAST Attached please find the Fiscal Year (FY) 2004 First Quarter Forecast Report. In total, Fiscal Services forecasts that the County will complete Fiscal Year 2004 with overall favorability of $5,169,408 in General Fund / General Purpose (GF/GP) operations. GF/GP includes all operations except grants, enterprise funds and internal service funds. This overall favorability is split between receiving $4,212,145 more revenue than anticipated, and expending $957,263 less than budgeted. REVENUES Actual GF/GP revenues are 1.15% more than budget or $4,212,145. The majority of the favorability is the result of the following events: A. GENERAL FUND — INTERGOVERNMENTAL - Favorable: $3,143,600 State Shared Revenue is estimated to be favorable by $3,000,000 based on State calculations dated January 2004. Estimates could be downwardly adjusted at the next Revenue Estimating conference in May. Community Corrections fees are expected to be favorable $117,000, but this is offset by drug testing expenses. B. GENERAL FUND - CHARGES FOR SERVICES - Favorable: $3,492,345 This favorability primarily results from an unanticipated continuance of activity regarding new mortgages and refinancing as reflected in the Clerk's revenue. The result is $1,887,800 favorability. Favorability in the Sheriff's Office of $757,000, is due to the updating of Deputy Patrol Rates and $300,000 for Diverted Felon. District Court revenues are favorable due to caseload increases for Division II - $520,400 and Division III - $149,500. C. GENERAL FUND — INVESTMENT INCOME — Unfavorable: $2,212,800 This unfavorability results from the continued low interest rates. D. GENERAL PURPOSE FUNDS — CHARGES FOR SERVICES - Unfavorable: $320,000 Less than anticipated Out County Board and Care due to delay in startup of Secure Detention facility. EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-2163 • FAX (248) 858-9172 EXPENDITURES In total, expenditures are estimated to be 0.26% below budget or $957,263. The favorability is related to the hiring freeze which was in affect for all of first quarter which is partially offset by costs related to housing of prisoners. Favorability, which is due to vacant positions and under filled positions, is referred to as "Turnover". The hiring freeze was cancelled in second quarter. In addition to the hiring freeze, capital purchases and travel were also frozen. The only Department that experienced overall unfavorability was the Sheriff's Office. The unfavorability is the result of prisoner housing costs. It has been necessary to house prisoners at other county jails to avoid overcrowding and early release. Please note that this unfavorability is nearly matched by revenue favorability in the Sheriff's Office due to the approved rate change for patrol contracts. A budget amendment has been recommended to recognize the increase in revenue and the increase in out county prisoner housing. $ 20,000.00 $ 20,000.00 97,000.00 68,000.00 $ 117,000.00 $ 88,000.00 117,000.00 88,000.00 117,000.00 $ 88,000.00 - $ $ (10,714,752.00) 10,714,752.00 $ 757,000.00 $ 757,000.00 $ (161,000.00) 50,000.00 (50,000.00) 50,000.00 bUlitUULt A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) ACCOUNT NUMBER ACCOUNT NAME FY 2004 FY 2005 AMENDMENT AMENDMENT GF/GP OPERATIONS -SELF BALANCING AMENDMENTS Board of Commissioners Expenditures 51-211000-20000-2011 51-211000-20000-2001 51-211000-20000-3372 90-290000-25000-3064 Per Diem Salaries Public Information Legistlative Expense Total Expenditures 8,000.00 (8,000.00) 85,000.00 (85,000.00) Drain Commissioner Expenditures 61-231001-70100-4080 Educational Supplies 61-231001-70100-2572 Contracted Services Total Expenditures Public Services - Community Corrections Revenues 17-401100-70211-0209 WAM 17-401100-70310-0209 Step Forward Total Revenue Expenditures 17-402200-70310-4336 Testing Material Total Expenditure Non-Departmental Transfers 3-90-190000-14000-1582 Prior Year Balance 3-90-150000-14000-1582 Prior Year Balance Total Transfers (9,000.00) 9,000.00 I GF/GP OPERATIONS - Revenues 43-013601-30000-0985 Expenditures 90-290000-25000-2404 34-403200-40001-2816 GENERAL AMENDMENTS Sheriff Special Deputy Total Revenue Basic Adjustment Fees Guardian Ad. Litem UAKLANU t;UUN I Y, 11111e.:111ttl FISCAL YEAR 2004 FIRST QUARTER EUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) ACCOUNT NUMBER ACCOUNT NAME 43-023301-214000-3268 Outside Co. Prisoner Housing Total Expenditures FY 2004 AMENDMENT 868,000.00 $ 757,000.00 $ (746.50) $ (746.50) 746.50 746.50 (16,030.25) (16,030.25) 16,030.25 16,030.25 (2,093.21) (2,093.21) 2,093.21 2,093.21 (595.87) (595.87) 595.87 595.87 (1,840.03) (1,840.03) 1,840.03 1,840.03 (2,383.46) (2,383.46) 2,383.46 2,383.46 (19,172.60) (19,172.60) 19,172.60 19,172.60 (3,396.40) (3,396.40) 3,396.40 3,396.40 (595.87) (595.87) 595.87 595.87 (18,653.45) (18,653.45) OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUND ACTIVITIES SCHEDULE B FY 2004 FY 2005 AMENDMENT AMENDMENT ACCOUNT NUMBER ACCOUNT NAME 1PROPRIETARY FUNDS - SELF BALANCING AMENDMENTS Information Technology Fund (636) Expenditures 18-636113-98436-8001 Tmfers to Major Dept Suppt Proj Fund $ 554,222.00 $ 554,222.00 Changes in Fund Equity Motor Pool Fund (661) Revenue 13-661001-00010-0639 Liability Insurance Total Revenues (231,212.00) $ (231,212.00) (231,212.00) (231,212.00) Expenditures 13-661002-00010-2976 Insurance Total Expenditures Change in Fund Equity Building Liability Fund (677) Revenues 95-150107-01000-0818 Expenditures 11-250207-30000-2976 Insurance Total Expenditures Change in Fund Equity Motor Pool Fund / Building Liability Fund Allocations Expenditures 11-101112-70001-6661 ERP - Motor Pool 11-101112-70001-6677 ERP Insurance 13-137201-30000-6661 OC/Pontiac Airport - Motor Pool 13-137201-30000-6677 OC/Pontiac Airport - Insurance 14-275000-30599-6661 FM&O/Grounds - Motor Pool 14-275000-30599-6677 . FM&O/Grounds - Insurance 16-220200-67000-6661 Health/Envir. - Motor Pool 16-220200-67000-6677 Health/Envir. - Insurance 43-023101-10000-6661 Sheriff/Admin - Motor Pool 43-023101-10000-6677 Sheriff/Admin - Insurance 43-023301-20000-6661 Sheriff/Corr Svcs - Motor Pool 43-023301-20000-6677 Sheriff/Corr Svcs - Insurance 43-023601-30000-6661 Sheriff/Protect Svcs - Motor Pool 43-023601-30000-6677 Sheriff/Protect Svcs - Insurance 43-023901-40000-6661 Sheriff/Tech Svcs - Motor Pool 43-023901-40000-6677 Sheriff/Tech Svcs - Insurance 43-480600-44600-6661 Sheriff/NET Grant - Motor Pool 43-480600-44600-6677 Sheriff/NET Grant - Insurance 53-201000-10001-6661 Parks and Rec - Motor Pool Property Insurance Billings Total Revenues (231,212.00) (231,212.00) (231,212.00) (231,212.00) - $ $ 132,498.66 $ 132,498.66 $ 132,498.66 $ 132,498.66 $ 132,498.66 $ 132,498.66 $ 132,498.66 $ 132,498.66 - $ 18,653.45 (37,854.32) 37,854.32 (5,362.80) 5,362.80 (23,773.90) 23,773.90 18,653.45 (37,854.32) 37,854.32 (5,362.80) 5,362.80 (23,773.90) 23,773.90 Fringe Benefit Fund (678) Revenue 91-150100-10000-0471 Employee In-Service Training . Total Revenue Human Resources - Organizational Training & Development Expenditures 15-525678-53000-2001 Salaries 15-525678-53000-2074 Fringe Benefits Total Expenditures Fringe Benefit Fund (678) Expenditures 91-250100-10000-2948 91-250100-10000-2742 In-Service Training - Info Tech Employees In-Service Training Total Expenditures 1SPECIAL REVENUE FUND - SELF BALANCING AMENDMENTS Oakland Enhancement Fund (230) Revenues 19-123100-16020-0257 2nd Administration Fee 19-123100-16020-0259 3rd Administration Fee 19-123100-16020-0365 • Closing Fees 16-123100-16020-1505 Investment Income Total Revenues Expenditures 19-223100-16020-2704 19-223100-16020-2820 19-223100-16020-3196 Educational Conference Fees / Per Diem Miscellaneous OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 FIRST QUARTER tilUDGE'T AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUND ACTIVITIES ACCOUNT NUMBER ACCOUNT NAME FY 2004 FY 2005 AMENDMENT AMENDMENT 53-201000-10001-6677 61-227317-46500-6661 61-227317-46500-6677 61-227317-46600-6661 61-227317-46600-6677 61-227317-46900-6661 61-227317-46900-6677 Parks and Rec - Insurance Drain Comm/Admin - Motor Pool Drain Comm/Admin - Insurance Drain Comm/VV & S - Motor Pool Drain CommNV & S Insurance Drain Comm/Op & Mnt - Motor Pool Drain Comm/Op & Mnt - Insurance Total $ 209,382.00 $ 212,687.00 $ 209,382.00 $ 212,687.00 $ 148,532.00 $ 151,121.00 60,850.00 61,566.00 $ 209,382.00 $ 212,687.00 $ 45,000.00 45,000.00 (45,000.00) (45,000.00) - $ (500.00) (500.00) (5,000.00) (1,000.00) $ (7,000.00) (5,000.00) (1,500.00) (500.00) (7,000.00) 9 RADIO COMMUNICATIONS PROJECT - COST / CASH FLOW PROJECTIONS - (In Thousands) OAKLAND COUNTY, MICHIGAN September 30, 2003 (In Thousands) Fiscal Year - Sept. 30, 2005 FY 2004 1st Quarter Report Attachment C Fiscal Year - Sept. 30, 2006 FY2007 Description st-Q 2nd-Q 3rd-Q 4th-Q lst-Q 2nd:Q 3rd-Q 4th-Q st-.Q MiA COM Components: Central components V $ 1,782 $ - $ - $ V - $ - $ - $ - . $ - $ Mob. / Cons./Radios V 4,000 5,791 . - - . - - Total M/A COM 5,782 .5,791 , - - - V- ' Other needs: , Towers / shelt. / equip. 415 - - - - - Network upgrades - - - - - - Project consultants - - - -V V- M/A COM V V 147 - - - - - All other 75 40 - - - - V-Tac units 50 50 50 50 - - Contingency 150 100 100. 75 75 62 Total Other 637 190 150 125 75 62 Grand Total V $ 6,619 ,$ 5,981 $• 150 ' $ 125 $ 75 $ 62 $ - $ - $ 0 Cash Position - Begin. Cash inflow Interest expense Borrowing Repayments Expenditures for period Cash Position - Ending Cumulative Debt Outstanding $ 685 $ 542 $ 524 $ 528 $ 572 $ 536 $ 525 $ 537 $ 511 1,376 1,377 1,376 - 1,377 1,033 1,034 1,034 1,034 1,034 (64) (122) (108) (94) (83) (72) (60) (48) 6,100 4,650 " . - (1,100) (1,100) (900) (900) (950) (1,000) (1,000) (6,619) (5,981) (150) V (125) (75) (62) $ 542 $ 524 $ 528 $ 572 $ 536 $ 525 $ ,537 $ 511 $ 497 $ 5,100 $ 9,750 8,650 $ 7,550 $ 6,650 $ 5,750 $ 4,800 $ .3,800 $ 2,800 Cash Position Begin.• Cash inflow Borrowing Interest expense Expenditures for period Cash Position .- Ending - _ • (998) (4,673) (7,897) (7,322) $ 15,082 $ 15,707 $ 12,657 $ 6,383. $ 685 $ 15,082 $ 15,707 $ 12,657 $ 6,383 1,623 1,623 1,623 1,624 Cumulative Debt Outstanding $ $ - $ - $ $ . FY 2004 1st Quarter Report Attachment C RADIO COMMUNICATIONS PROJECT - COST I CASH FLOW PROJECTIONS - (In Thousands) OAKLAND COUNTY, MICHIGAN September 30, 2003 (In Thousands) As of • Sept. 30, Fiscal Year - Sept. 30, 2003 Fiscal Year - Sept. 30, 2004 " Description Cost 2003 1st-Q 2 nd-Q 3rd-Q 4th-Q 1st-Q 2nd-Q 3rd-Q 4th-Q M/A COM Components: Central components $ 12,532 $ 7,200 $ 100 $ 700 $ 1,400 $ 1,400 Mob. I Cons./Radios 20,918 127 1,500 4,750. 4,750 • Total MIA COM 33,450 7,327 100 2,200 6,150 6,150 Other needs: Towers / sheit. / equip. 3,500 185 400 1,200 800 500 Network upgrades 1,000 - 250 550 200 - Project consultants: • • M/A COlvl 1,419 682 148 148 147 147 All other 500 135 50 50 75 75 V-Tac units 500 - - - . 50 200 Facility renovation 300 - - 75 225 - Generators 600 - - 350 150 100 Contingency 1,000 38 60 • . 100 100 150 , Total Other 8,819 1,040 . 0 ' 898 2,473 1,747 1,172 Grand Total $ 42,269 $ .. 8,367 $ 998 $ 4,673 $ 7,897 $ 7,322 ii AMOUNT FY 2004 FAVORABLE/ FORECAST (UNFAVORABLE I PERCENT $ 214,129,000.00 $ 1,257.532.00 (180.000.00) 32,709,032.00 3,143,600.00 7,614,054.00 250,000.00 74,644.710.00 3,492,345.00 3,820,400.00 (2,212,800.00) 394,139.00 39,000.00 6,047,322.00 $ 340,616,189.00 $ 4,532,145.00 0.00% 10.63% 4.91% 10.98% 1.35% 1.02% 2.17% 3.01% 1.45% LAW ENFORCEMENT Prosecuting Attorney Sheriff TOTAL LAW ENFORCEMENT 16,599,189.00 104,275,832.00 $ 120,875,021.00 17,499,553.53 104,965,949.67 $ 122,465,503.20 17,342,553.53 105,787,949.67 $ 123,130,503.20 157,000.00 0.90% (822,00o.00 $ (685,000.00) -0.54% -0.78% $ 24,151,218.00 TOTAL GENERAL GOVERNMENT 11,711,544.01 3,313,889.16 2,808,756.48 2,476,458.25 3,556,234.74 24,168,882.84 108,300.00 129,253.00 5,100.00 $ 242,653.00 $ 7,588,312.35 $ 19,528,942.72 2,378,835.96 1,538,892.87 4,593,840.18 56,574,626.14 13,947,415.52 6,000,452.70 1,106,880.00 72,410.00 5,000.00 13,800.00 250,000.00 37,000.00 65,000.00 0.00% 0.37% 0.00% 0.32% 0.30% 0.44% 0.26% 1.07% 0,00% 113,255,908.44 $ 324,479,559.63 $ 443,210.00 958,383.00 $ 39,903,335.37 $ .11,100.001 0.00% 0.92% 3.75% 0.18% 0.00% 0.00% 0.99% 0.39% 0.29% $ General Fund/General Purpose Favorable/(Unfavorable) $ 5,189,448.00 $ 6,169,408.00 JO COUNTY OF OAKLAND Pt 2004 FIKST QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT REVENUES GENERAL FUND Taxes Federal Grants Intergovernmental Indirect Cost Recovery Charges for Services Investment Income Other Revenues Transfers SUB-TOTAL GENERAL FUND GENERAL PURPOSE FUNDS Intergovernmental Charges for Services SUB-TOTAL GENERAL PURPOSE FUND PLANNED USE OF FUND BALANCE TOTAL GF/GP FUNDS EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN, OF JUSTICE FY 2004 ADOPTED BUDGET $ 214,129,000.00 1,400,532.00 29,565,432.00 7,364,054.00 70,987,459.00 6,033,200.00 330,139.00 6,047,322.00 $ 335,857,138.00 $ 13,597,419.00 7,485,685.00 $21,083,104.00 $ 3,503,694.00 $ 360,4.43,936.00 5 41,191,679.00 14,673,407.00 5 290 394 00 $ 81,155,460.00 BUDGET AS AMENDED $ 214,129,000.00 1,437,532.01 29,585,432.00 7,384,054.00 71,152,365.00 6,033,200.00 355,139.00 6,047,322.00 $ 336,084,044.00 $ 13,597,419.00 7,553,619.00 $21,151,038,00 $ 8,105,076.00 $ 44,808,312.40 14,733,129.19 5,322.233.76 $ 64,863.675.35 $ 13,597,419.00 7,233,619.00 $20,831,038.00 $ 8,105,076.00 $ 44,350,912.40 14,413,429.19 $ 63,926,175.35 $ 0.00% 1320,000.001 -4.24% (3320,000.00) -1.51% $0.00 0.00% $ 457,400.00 319,700.00 . 160,400.00 $ 937,500.00 $ 3640_ 389,552,303.00 $ 4,212,145.00 1.15% GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Comrnissioners Library Board Drain Commissioner COUNTY EXECUTIVE County Executive Admn. Management and Budget Central Services Facilities Management Personnel Human Svs. Public Services Community & Economic Dev. Workforce Development TOTAL COUNTY EXECUTIVE TOTAL DEPARTMENTS NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS TOTAL GOVERNMENTAL EXPENDITURES 11,655,734.00 3,395,174.00 2,813,741.00 2,478,445.00 3,810,124.00 $ 7,551,492.00 19,182,120.00 2,356,802.00 1,543,838.00 4,559,427.00 56,638,500.00 13,943,818.00 6,026,104.00 1,106,880.00 $ _112,908,979.00 $ 319,090,698.00 41,313,238.00 11 A19,844.01 3,443,142.16 2,813.856.48 2,476,458.25 3,856,234.74 $ 24,409.535.64 7,588.312.35 19,601.352.72 2,376,835.96 1,543,892.87 4,607,440.18 56,824,626.14 13,984,415.52 8,065,452.70 1,106,880.00 $ 113,699,208.44 325,437,922.63 $ 39,902,235.37 380,443,936.00 $ 365,340,158.00 $ 364,382,895.00 $ .957,263.00 0.28% $ 213,209,000.00 $ 213,209,000.00 $213,209,000.00 $ 825,000.00 825,000.00 825,000.00 95,000.00 95,000.00 95,000.00 $ 214,129,000.00 $ 214,129,000.00 $214,129,000.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% $ 43,652.00 $ 80,652.00 $ 1,106,880.00 1,106,880.00 250,000.00 250,000.00 0.00% 0.00% (180,000.00) -72,00% Reduction in % reimbursed by Federal Government for care of Illegal Alien Prisoners - 1130.00% 80,652.00 1,106,880.00 70,000.00 1,400,532.00 $ 1,437,532.00 $ 1,257,532.00 $ (180,000.00) -12.52% 0.00% 43.01% Fay. WAM and Step Forward revenues increase due to Increased fees and offenders in drug related programs to be offset by Testing Material. -74.65% Unfav due to discontinuation of State Inmate Reimbursement, 0.00% 16.67% Increase in Federal Social Security Incentive Payments 0.00% 11.15% Fay. Revenue Sharing based on current projections. 10.63% 3.39% Increased revenue the result of additional collections from grants 0.00% 0.00% 0.00% 0.00% 0.00% 11,400.00 3.51% Fay. Tax Intercept Fees offset by (Unfav.) filing fees due to Increase in volume. 117,000.00 (13,400.00) 40,000.00 3,000,000.00 3,143,600.00 250,000.00 $ 109,900.00 272,000.00 17,950.00 2,755.00 240,000.00 2,005,827.00 26,917,000.00 $ 29,565,432.00 $ 7,364,064.00 151,500.00 $ 151,500.00 $ 151,500.00 3,000.00 3,000.00 3,000.00 74,000.00 74,000.00 74,000.00 2,350,918.00 2,350,918.00 2,350,918.00 14,800.00 14,800.00 14,800.00 325,000.00 325,000.00 336,400.00 $ 109,900.00 $ 109,900.00 $ 272,000.00 389,000.00 17,950.00 2,755,00 240,000.00 2,005,827.00 26,917,000.00 $ 29,565,432.00 $ 7,364,054.00 4,550.00 2,755.00 280,000.00 2,005,827.00 29,917,000.00 $ 32,709,032.00 $ 7,614,054.00 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT RECEIPTS FOR GOVERNMENTAL FUNDS Budget As Adopted Budget As Amended FY 2004 Forecast Amount Favorable unfavorable) Percent Explanation GENERAL FUND TAXES Property Taxes - 2003 Tax Levy Delinquent Tax - Prior Years Trailer Tax Special Assessment Total Property and Other Taxes FEDERAL GRANTS Emergency Response and Preparedness Workforce Development - Admin Sheriff Library Board Total General Fund - Federal Grants INTERGOVERMENTAL REVENUES Governmental Program Revenues Emergency Response & Preparedness Community Corrections - Admin Circuit Court - Gen. Jurisdiction District Courts Sheriff Non-Departmental - Judges Salaries General Reimb. Revenues (Non-Dept) Total General Fund - Intergovernmental Revenue INDIRECT COST RECOVERY CHARGES FOR SERVICES County Executive Administration Emergency Response & Preparedness Auditing Equalization Purchasing Reimbursment asaISSO. Support Services Facilities Engineering Human Resources Community Corrections - Administration MSU Extension Animal Control Medical Examiner Community & Economic Development - Admin Planning & Economic Development Svcs. Clerk - County Clerk Clerk - Elections Clerk - Register of Deeds Treasurer Circuit Court - General Jurisdiction Circuit Court - Court Services Circuit Court - Judicial Support District Court - Division I District Court - Division II District Court - Division III District Court - Division IV Probate Court Prosecutor (10,000.00) (147,400.00) 55,200.00 - (93,600.00) 3,100.00 1,887,800.00 3,300.00 171,700.00 (30,000.00) (1,000.00) 63,100.00 Budget As Amended 138,000.00 800.00 74,000.00 783,795.00 138,000.00 419,259.00 150,000.00 2,262,900.00 17,800.00 11,872,573.00 FY 2004 Forecast 138,000.00 800.00 64,000.00 636,395,00 193,200.00 419,259.00 150,000.00 2,169,300.00 20,900.00 13,760,373.00 2,951,381.00 2,954,681.00 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REP RECEIPTS FOR GOVERNMENTAL ORT FUNDS Amount Favorable (unfavorable) 520,400.00 149,500.00 40,900.00 Budget As Adopted 138,000.00 800.00 74,000.00 833,385.00 138,000.00 419,259.00 150,000.00 2,262,900.00 17,800.00 11,872,573.00 2,951,381.00 2,824,090.00 2,824,090.00 2,905,790.00 310,000.00 310,000.00 280,000.00 418,700.00 418,700.00 417,700,00 3,700,133.00 3,700,133.00 3,763,233.00 1,142,944.00 1,142,944.00 1,663,344,00 4,117,863.00 4,117,863.00 4,267,363.00 2,255,352.00 2,255,362.00 2,296,252.00 524,100.00 524,100.00 524,100.00 207,500.00 207,500.00 207,500.00 Percent Explanation 0.00% 0.00% 0.00% 100.00% -13.51% Unfav. Master Gardener Training due to smaller class size as a result of limited space for current programs. -18.81% Unfav. Due to lower contracted services requested by CVT's and lower than anticipated Dog Licenses. 40.00% Fay. Due to increased fees MR # 03369 February 4, 2004. 0.00% 0.00% -4.14% Unfav due to lower anticipated volume of activity for Jury Fees and Passports. 17.42% Fay due to fee increase for Board of Canvasser Service Fee. 15.90% Fay due to favorable interest rates resulting in increased mortgage and real estate refinancing activity. 0.11% Fay due to rising taxable value of property increasing the number of Tax Statements sold to escrow agents, also, favorable Supplemental Warrants also due to increasing taxable value. Partially offset by decreasing level of industrial development activity affecting TIFFA/DDA recovery. 6.08% Fay due to more effective in-housb collection efforts of Court Costs. -9.68% Unfavorable due to reduction in number of probation cases, partially offset by increase in Reimb. Clinical Evals. due to fee increase. -0,24% Unfav due. to decreasing number of Psychological Testing & Evaluations ordered. 1.71% Fay due largely to incr Sobriety Ct fee, Filing Fee/DCU, Garnishment Fees, and Late Penalty revenue related to incr in caseload activity. This was partially offset by decreasing Probation Fee revenues. 45.53% Fay in almost all revenue line items due to rising caseload, fee increases, and addition of new judge and two new townships. 3.63% Fay due to increases to sundry fee revenues, and rising caseload activity. 1.81% Fay due to increases to sundry fee revenues, and rising caseload activity. 0.00% 0.00% vlo Sheriffs Office Sheriff - Administration Sheriff - Corrective Services Sheriff - Corrective Services Satellite Sheriff - Patrol Services Sheriff - Technical Services Board of Commissioners Library Board Drain Commissioner Non-Departmental Total General Fund - Charges for Services FY 2004 Forecast 10,800.00 4,000.00 2,669,276.00 2,357,900.00 26,254,304.00 623,822.00 8,000.00 31,800.00 1,154,000.00 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT RECEIPTS FOR GOVERNMENTAL FUNDS Budget Budget As As Adopted Amended 10,800.00 10,800.00 1,000.00 1,000.00 2,369,276.00 2,369,276.00 2,357,900.00 2,357,900.00 25,282,808.00 25,497,304.00 623,822.00 623,822.00 8,000.00 8,000.00 73,855.00 73,855,00 1,304,000.00 1,304,000.00 1,678,000.00 1,678,000.00 $ 70,987,459.00 $ 71,152,365.00 Amount Favorable unfavorable] percent Explanation 0.00% 3,000 00 300.00% Reimbursement for mileage has increased. 300,000 00 12.66% Aggressive billing of recoverable costs from State. - 0.00% 757,000.00 2.97% Per new deputy contracts. A budget amendment is recommended. 0.00% 0.00% (42,055.00) -56.94% Reimbursement for Library For The Blind Position has ceased. (150,000.00) -11.50% Unfav - Soil Erosion Fees (150,000) decrease in building activity/permits 1,678,000.00 0.00% $ 74,644,710.00 $ 3,492,345.00 4.91% INVESTMENT INCOME District Courts Clerk/Register of Deeds Non-Departmental Total General Fund - Investment Income OTHER REVENUES Emergency Response & Preparedness Support Services - Materials Mgmt Clerk - Register of Deeds District Court Treasurer Circuit Court Sheriff Total General Fund - Other Revenues TRANSFERS Treasurer Library Board Non-Departmental - Investments Total General Fund - Transfers SUB-TOTAL GENERAL FUND GENERAL PURPOSE FUNDS $ 29,500.00 $ 29,500.00 $ 16,700.00 $ (12,800.00) -43.39% Unfav due to continued low interest rates 3,700.00 3,700.00 3,700.00 0.00% 6,000,000.00 6,000,000.00 3.800,000.00 (2,200,000.00) -36.67% Unfav due to continued low interest rates. $ 6,033,200.00 $ 6,033,200.00 $ 3,820,400.00 $ (2,212,800.00) -38.68% I $ 15,000.00 5 15,000.00 $ 15,000.00 $ - 0.00% 6,000.00 6,000.00 6,000.00 - 0.00% - - 36,500.00 36,500.00 100.00% Fay adjustment of prior years revenue. - - 1,000.00 1,000.00 100.00% Fav due to Donation revenue received. 1,000.00 1,000.00 1,000.00 - 0.00% - ' - 1,500.00 1,500.00 100.00% Fav adjustment of prior years revenue. 308,139.00 333,139.00 333,139.00 - 0.00% $ 330,139.00 $ 355,139.00 $ 394,139.00 $ 39,000.00 10.98% $ 2,352,101.00 $ 2,352.101.00 $ 2,352,101.00 $ 95,221.00 95,221.00 95,221.00 3.600,000.00 $ 3,600,000.00 $ 3,600,000.00 $ 6,047,322.00 $ 6,047,322.00 $ 6,047,322.00 $ $ 335,857,138.00 $336,084,044.00 $340,616,189.00 $ 4,632,146.00 1.35% 0.00% 0.00% 0.00% 0.00% 0.00% -0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% CHARGES FOR SERVICES Health Fund Health Division Total Health Fund $ 3,126,248.00 $ 3,194,182.00 5 3,194,182.00 $ - 0.00% 5 3,126,248.00 $ 3,194,182.00 $ 3,194,182.00 $ 0.00% Juvenile Maintenance Fund Circuit Court Children's Village $ 1,030,000.00 $ 3,329,437.00 1,030,000.00 $ 910,000.00 3,329,437.00 3,129,437.00 (320,000.00) -7.34% (320,000.00) -4.24% (320,000.00) -1.51% Less: Non-Departmental Transfers In (Out) $ (41,530,867.00) $ (41,649,059.14) $ (41,649,059.14) $ 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT RECEIPTS FOR GOVERNMENTAL FUNDS INTERGOVERNMENTAL Health Fund Health State Subsidy Health Grant - State Reimbursement Total Health Fund Juvenile Maintenance Fund Children's Village - Refund School Meals Non-Department - Child Care Subsidy Total Juvenile Maintenance Fund Social Welfare Fund Foster Care - State Match Total Social Welfare Fund Total General Purpose - Intergovernmental Budget As Adopted $ 3,532,923.00 $ 109,696.00 3,642,619.00 $ $ 239,800.00 $ 9,700,000.00 $ 9,939,800.00 $ $ 15,000.00 $ $ 15,000.00 $ $ 13,597,419.00 $ Budget As Amended 3,532,923.00 $ 109,696.00 3,642,619.00 $ 239,800.00 $ 9,700,000.00 9,939,800.00 $ 15,000.00 $ 15,000.00 $ 13,597,419.00 $ Amount FY 2004 Favorable Forecast . (unfavorable) Percent 3,532,923.00 $ 109,696.00 3,642,619.00 $ 239,800.00 $ 9,700,000.00 9,939,800.00 $ 15,000.00 $ 15,000 00 $ 13,597,419.00 $ Explanation $ (120,000.00) -11.65% Unfav due to reduction in State allocation. (200,000.00) -6.01% (Unfav.) due to delay in construction of Secure Detention Facility. Total Juvenile Maintenance Fund Total General Purpose - Charges for Services SUB-TOTAL GENERAL PURPOSE FUNDS TRANSFERS (In) Non-Department - Health Fund Non-Department - Juvenile Maintenance Fund Non-Department - Social Welfare Fund Total General Purpose - Transfers In (Out) $ 4,359,437.00 $ 4,359,437.00 $ 7,485,685.00 $ 7,653,619.00 $ 21,083,104.00 $ 21,151,038.00 $ $ 25,526,822.00 $ 25,615,809.16 $ 16,989,045.00 16,018,249.98 15,000,00 15,000.00 $ 41,530,867.00 $ 41,649,059.14 $ 4,039,437.00 7,233,619.00 20,931,038.00 25,615,809.16 $ 16,018,249.98 15,000.00 41,649,059.14 $ 0.00% 0.00% 0.00% 0.00% PLANNED USE OF FUND BALANCE General Fund - Encumbrances & Carried Forwards COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT RECEIPTS FOR GOVERNMENTAL FUNDS Budget Budget Amount As As FY 2004 Favorable Adopted Amended Forecast 'unfavorable) Percent General Fund - Prior Years Balance 3,503,694.00 8,105,076.00 8,105,076.00 - 0.00% General Purpose - Encumbs & Carried Fwds - Public Health - - - 0.00% General Purpose - Encumbs & Carried Fwds - Jul./. Maint. - - - - 0.00% Total Planned Use of Fund Balance $ 3,503,694.00 $ 8,105,076.00 $ 8,105,076.00 $ - 0.00% TOTAL GOVERNMENTAL RESOURCES $ 360 443,936.00 $365,340,158.00 $369,552,303.00 $ 4,212,145.00 1.15% Explanation #.77. COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial Administration Controllable Personnel Controllable Operating Non-Controllable Operating Business Division Controllable Personnel Controllable Operating Non-Controllable Operating General Jurisdiction Division Controllable Personnel Controllable Operating Non-Controllable Operating Family Division/Juvenile MainL Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 6,677,364.00 $ 6,677,364.00 $ 6,570,164.00 $ 45,067.00 45,067.00 45,067.00 179,014.00 189,611.64 189,611.64 $ 6,901,445.00 $ 6,912,042.64 $ 6,804,842.64 $ $ 2,161,255.00 $ 2,181,255.00 $ 2,054,955.00 $ 43,200.00 43,200.00 43,200.00 331,046.00 334,355.76 334,355.76 $ 2,535,501.00 $ 2,538,810.76 $ 2,432,510.78 $ $ 2,016,386.00 $ 2,016,386.00 $ 1,998,386.00 $ 5,700,871.00 9,230,480.00 9,248,460.00 2,169,799.00 2,234,146.00 2,234,146.00 $ 9,887,058.00 $13,480,992.00 $13,480,992.00 $ 11,822,079.00 $11,822,079.00 $11,576,979.00 $ 8,401,014.00 8,401,014.00 8,402,214.00 1,644,584.00 1,653,374.00 1,653,374.00 $ 21,867,677,00 $21,876,467.00 $21,832,567.00 $ $ 22,677,084.00 $22,677,084.00 $22,200,484.00 $ 14,190,152.00 17,719,741.00 17,738,941.00 4,324,443.00 4,411,487.40 4,411,487.40 $ 41,191,679.00 $44,808,312.40 $44,350,912.40 $ 107,200.00 1.61% Turnover. 0.00% 0.00% 107,200.00 1.55% 106,300.00 4.92% Turnover. 0.00% 0.00% 106,300.00 4.19% 18,000.00 0.89% Turnover. (18,000.00) -0.20% Unfav. due to Court Reported Services, Refund of Prior Yrs. Rev.,and Postage. 0.00% 0.00% 245,100.00 2.07% Turnover. (1,200.00) -0.01% Unfav. due largely to Refund of Prior Yrs. Rev, partially offset by fav. Court Reporter Svc. 0.00% 243,900.00 1.11% 476,600.00 2.10% (19,200.00) -0.11% • 0.00% 457,400.00 1.02% 2/23/2004 53,200.00 Division 3 - Rochester Hills Controllable Personnel Controllable Operating Non-Controllable Operating Division 4 - Troy Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 76,600.00 2,000.00 (1,900.00) 2.41% - Turnover. 0.32% - Fay. due to Tmg Psych & Med Exam -0.25% - Unfav. due to Convenience Copier. 76,700.00 1.68% 55,600.00" 2.63% - Turnover. (4,400.00) -0.83% - Unfav. due to Defense Atty Fees, and Heat light and Gas. 0.00% 51,200.00 1.72% 311,400.00 10,200.00 (1,900.00) 319,700.00 2.17% 3.02% 0.38% -0.11% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT ADOPTED BUDGET AMOUNT AMENDED FY 2004 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Controllable Personnel Controllable Operating Non-Controllable Operating 38.51% - Turnover. 0.00% 0.00% $ 138,161.00 ; 138,161.00 $ 70,300.00 70,300.00 84,961.00 $ 70,300.00 208,461.00 $ , 208,461.00 $ 155,261.00 $ 53,200.00 25.52% Division 1 - Novi Controllable Personnel Controllable Operating Non-Controllable Operating Total Division 1 - Novi Division 2 Clarkston Controllable Personnel Controllable Operating Non-Controllable Operating Total Division 2- Clarkston $ 3,449,260.00 $ 3,449,260.00 $ 3,356,760.00 $ 918,675.00 918,675.00 908,075.00 440,639.00 452,477.45 452,477.45 $ 4,808,574.00 $ 4,820,412.45 $ 4,717,312.45 $ $ 1,440,193.00 $ 1,440,193,00 $ 1,406,693.00 $ 534,851.00 534,851.00 532,851,00 161,365.00 178,977.71 178,977.71 $ 2,136,409.00 $ 2,154,021.71 $ 2,118,521.71 $ 02,500.00 2.68% - Turnover. 10,600.00 1.15% - Fay. due Largely to office supplies, and Juror Fees and Mileage. 0.00% 103,100.00 2.14% 33,500.00 2.33% - Turnover. 2,000.00 0.37% - Fay. due largely to Juror Fees and Mileage, partially offset by increased postage. 0.00% 35,500.00 1.65% $ 3,183,545 00 $ 3,183,545.00 $ 3,106,945.00 $ 624,015.00 624,015.00 622,015.00 748,121.00 767,546.60 769,446.60 $ 4,555,681.00 $ 4,575,106.60 $ 4,498,406.60 $ $ Z110,635 00 $ 2,110,635.00 $ 2,055,035,00 $ 529,558.00 529,558.00 533,958.00 324,089.00 334,934.43 334,934.43 $ 2964,282.00 $ 2,975,127.43 5 2,923,927.43 5 $ 10,321,794.00 $ 10,321,794.00 5 10,010,394.00 $ 2,677,399.00 2,677,399.00 2,667,199.00 1,674,214 00 1,733,936.19 1,735,836.19 $ 14,673,407.00 $ 14,733,129.19 $ 14,413,429.19 $ 02/23/2004 Estates/Mental Health Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Judicial/Administration Controllable Personnel $1,912,681.00 $1,912,681.00 $1,867,981.00 $ 44,700.00 2.34% - Turnover. Controllable Operating -. - - - - 0.00% Non-Controllable Operating 289 206.00 316,441.76 316,441.76 , 0.00% - $2,201,887.00 $2,229,122.76 $2,184,422.76 $ 44,700.00 2.01% EXPLANATION OF SIGNIFICANT VARIANCES Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,022,690.00 $ 2,022,690.00 $ 1,859,990.00 $ 162,700.00 8.04% - Turnover. 654,981.00 654,981.00 700,081.00 (45,100.00) -6.89% - Unfav. Due to Guardian Ad !item, and Guardian Review/Adult. A budget amendment is recommended. 410,836.00 415,440.00 417,340.00 (1,900.00) -0.46% - Unfav. due to Print Shop. $3,088,507.00 $3,093,111.00 $2,977,411.00 $ 115,700.00 3.74% $3,935,371.00 $3,935,371.00 $3,727,971.00 $ 207,400.00 5.27% 654,981.00 654,981.00 700,081.00 (45,100.00) -6.89% 700,042.00 731,881.76 733,781.76 (1,900.00) -0.26% $5,290,394.00 $5,322,233.76 $5,161,833.76 $ 160,400.00 3.01% OWN, trS) 2/23/2004 ADOPTED BUDGET FY 2004 FORECAST AMENDED BUDGET Administrative Services Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,491,819.00 805,929.00 550,110.00 $ 2,491,819.00 $ 808,944.00 550,242.00 2,491,619.00 $ 806,944.00 550,242.00 0.00% 0.00% 0.00% $ 3,847,858.00 $ 3,848,805.00 $ 3,848,805.00 0.00% ; 22,466,655.00 $ 22777,555.00 $ 22,466,655.00 6,888,118.00 6,408,166.67 $ (310,900.00) (868,000.00) 7,738,118.00 6,408,166.67 6,882,221.00 6,288,328.00 Corrective Services Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out -1.38% - Fay. Salary $203,500 offset by Unfelt. OT ($314,100), Hof OT ($167,600) and Fringes ($32,700). -12.64% - Unfav. Outside County Prisoner Housing. A budget amendment recommended. 0.00% 0.00% $ 35,817,204.00 $ 35,742,939.67 $ 36,921,839.67 $ (1,178,900.00) -3.30% $ 16,158,183.00 $ 16,158,183.00 $ 18,158,183.00 $ $ 29,169,096.00 $ 29,356,922.00 $ 29,231,022.00 $ 225,536.00 225,538.00 225,536.00 4,411,617.00 4,459,641.00 4,459,641.00 65,536.00 65,536.00 33,806,249.00 $ 34,107,635.00 $ 33,981,735.00 $ $ 10,130,728.00 $ 10,139,886.00 $ 9,898,186.00 $ 689,908.00 915,715.00 915,715.00 1,388,263.00 1,388,263.00 1,388,263.00 Corrective Services-Satellites Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 14,794,398.00 383,868.00 999,917.00 $ 14,794,398.00 383,888.00 999,917.00 $ 14,704,398.00 363,888.00 999,917.00 Patrol Services Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out Technical Services Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out 0.00% 2,36% - Fay. Salary $67,000, Hot OT $145,100, Fringes $41,800 offset by Unfav. OT ($12,200). 0.00% 0.00% 0.00% 125,900.00 0.37% 241,700.00 0.00% 0.00% 0.00% 0.00% Fay. Salary $58,300, OT $194,700 offset by Unfav. Hol OT ($123,000) and Fringes ($4,100). 125,900.00 4_ 0.43% 0.00% 0.00% 0.00% 5104,275,832.00 $ 104,985,949.87 $ 105,787,949.67 $ (822,000.00) -0.78% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriff's Office Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,442,003.00 $ 1,442,003.00 it 1,452,703.00 $ (10,700.00) -0.74% - Vacant positions filled by longer term employees. 87,074.00 112,074.00 112,074.00 0.00% 1,110,582.00 1,112,446.00 1,112,446.00 0.00% 2,839,839.00 5 2,666,523.00 $ 2,677,223.00 5 (10,700.00) -0.40% $ 12,206,899.00 $ 12,441,864.00 $ 12,200,164.00 $ 241,700.00 1.94% $ 80,494,499 00 9,034,536.00 14,746,797.00 Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 80,691,483.00 9,292,255.00 14,916,875.67 85,538.00 $ 80,645,483.00 10,160,255.00 14,916,675.67 65,538.00 48,000.00 0.08% (868,000.00) -9.34% 0.00% 0.00% 2/23/2004 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel $ 2,632,802.00 . $ 2,632,802.00 $ 2,582,802.00 $ 50,000.00 1.90% Fav. Turnover! Hiring Freeze Controllable Operating 812,561.00 1,677,882.00 1,677,882.00 - 0,00% Non-Controllable Operating 1,785,467.00 1,820,510.53 1,820,510.53 - 0.00% Transfer Out - - - - 0.00% $ 5,230,830.00 $ 6,131,194.53 $ 6,081,194.53 $ 50,000.00 0.82% Litigation Controllable Personnel Controllable Operating Non-Controllable Operating $ 7,626,900.00 $ 7,626,900.00 $ 7,526,900.00 $ 49,824.00 49,824.00 42,824.00 1,048.00 1,048.00 1,048.00 $ 7,677,772.04 $ 7,677,772.00 $ 7,570,772.00 $ 100,000.00 7,000.00 - 107,000.00 1.31% - Fay. Turnover! Hiring Freeze 14.05% - Fav. Personal Mileage 0.00% 1.39% Warrants Controllable Personnel $ 2,241,498.00 $ 2,241,498.00 $ 2,241,498.00 $ - 0.00% Controllable Operating 2,758.00 2,758.00 2,758.00 - 0.00% Non-Controllable Operating - - - - 0.00% - $ 2,244,256.00 $ 2,244,256.00 $ 2,244,256.00 $1 0.00% Appellate Controllable Personnel $ 1,439,040.00 $ 1,439,040.00 $ 1,439,040,00 $ - 0.00% Controllable Operating 7,291.00 7,291.00 7,291.00 - 0,00% , Non-Controllable Operating - - 0.00% $ 1,446,331.00 $ 1,446,331.00 $ 1,446,331.00 $ 0.00% Department Controllable Personnel $ 13,940,240.00 $ 13,940,240.00 $ 13,790,240.00 $ 150,000.00 1.08% Controllable Operating 872,434.00 1,737,755:00 1,730,755.00 7,000.00 0.40% Non-Controllable Operating 1,786,515.00 1,821,558.53 1,821,558.53 - 0.00% Transfer Out - - - - 0.00% $ 16,599,189.00 $ 17,499,553.53 $ 17,342,553.53 $ 157,000.00 0.90% 02/20/2004 236,896.00 Rees) $ 4,257,976.00 198,578.00 568,806.00 $ 854,508.31 $ 851,508.31 $ 4,257,976.00 $ 4,154,776.00 198,578.00 204,278.00 693,210.00 693,210.00 $ 5,025,360.00 $ 5,149,764.00 $ 5,052,264.00 $ 97,500.00 $ 464,097.00 $ 464,097.00 $ 464,097.00 3 585,300.00 588,929.00 588,929.00 108,728.00 112,998.00 112,998.00 0.00 1.89% 0.00% 0.00% 0.00% 0.00% -5.86% 1.83% -1.38% 0.00% 0.00% 0.92% $ 11,655,734.00 $11,819,844.01 $11,711,544.01 $ 108,300.00 9-- 2. Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDM.IRES CLERK/REGISTER OF DEEDS ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 614,076.00 $ 614,076.00 $ 603,576.00 $ 52,350.00 52,350.00 59,850.00 184,545.00 188,082.31 188,082.31 10,500.00 (7,500.00) - - ---- $ 3,000.00 $ 103,200.00 (5,700.00) Administration Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out County Clerk (Vital Slats & Legal Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out Elections Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out 1.71% Turnover. -14.33% 0.00% 0.00% 0.35% 2.42% Turnover. -2.87% 0.00% 0.00% Carry forward capital expenditure for furniture and fixtures. Untav. Office supplies and equipment repairs and maintenance. $ 1,158,125.00 $ 1,166,024.00 $ 1,166,024.00 $ 0.00% Register of Deeds Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out $ 2,238,528.00 $ 2,238,528.00 $ 2,213,528.00 $ 25,000.00 1,354,371.00 1,354,371.00 1,364,971.00 (10,600.00) 933,509.00 944,109.00 944,109.00 1.12% Turnover. -0.78% Remonumentation. 0.00% 0.00% $ 4,526,408.00 $ 4,537,008.00 $ 4,522,608.00 $ 14,400.00 0.32% Jury Commission Controllable Personnel Controllable Operating Non-Controllable Operating $ 14,551.00 $ 14,551.00 $ 14,551.00 $ 2,384.00 2,384.00 8,984.00 77,934.00 95,604.70 95,604.70 0.00% (6,600.00) -276.85% 0.00% Postage and professional services. $ 94,869.00 $ 112.539.70 $ 119,139.70 $ (6,600.00) $ 7,589,228.00 $ 7,589,228.00 $ 7,450,528.00 $ 138,700.00 2,192,983.00 2,196,612.00 2,227,012.00 (30,400.00) 1,873,523.00 2,034.004.01 2,034,004.01 2/23/2004 ADOPTED BUDGET AMENDED BUDGET Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,563,469.00' 183,215.00 648,490.00 $ 2,563,469.00 183,215.00 696,458.16 Division Total $ 3,395,174.00 Department Total $ 3,395,174.00 $ 3,443,142.16 $ 3,313,889.16 $ $ 3,443,142.16 $ 3,313,889.16 $ 02/23/2004 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 2,431,969.00 $ 185,462.00 696,458.16 ==== 131,500.00 5.13% Turnover. (2,247.00) -1.23% Unfav. Due to Twp & City Treas. Bonds cost increase. 0.00% 129,253.00 3.75% 129,253.00 3.75% Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,090,349.00 $2,096,349.00 430,606.00 286,786.00 430,606.00 286,901.48 4.30% - Turnover fay. $98,100. A budget amendment is requested to appropriate $8,000 for Per Diem. 0.00% - -29.63% A budget amendment is requested to transfer $65,000 from the Non-Departmental Leg istlative Expense account to the Board of Commissioners Budget for Public Information expense. $ 2,813,741.00 $ 2,813,856.48 $ 2,808,756.48 $ 5,100.00 0.18% $ 2,006,249.00 $ 90,100.00 430,606.00 371,901.48 (85,000.00) COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,096,349.00 $ 2,096,349.00 $ 2,006,249.00 $ 430,606.00 430,606.00 430,606.00 286,786.40 286,901.48 371,901.48 90,100.00 4.30% 0.00% (85,000.00) -29.63% $ 2,813,741.00 $ 2,813,856.48 $ 2,808,756.48 $ 5,100.00 0.18% 02/20/2004 Library Board Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES LIBRARY BOARD ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE ACTUAL (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ON•11•nn•nn•.n $ 969,666.00 $ 969,666.00 $ 969,666.00 637,275.00 637,275.00 637,275.00 869,504.00 869,517.25 869,517.25 $ 2,476,445.00 $ 2,476,458.25 $ 2,476,458,25 $ $ 969,666.00 $ 969,666.00 $ 969,666.00 $ 637,275.00 637,275.00 637,275.00 869,504.00 869,517.25 869,517.25 $ 2,476,445.00 $ 2,476,458.25 $ 2,476,458.25 $ 02/20/2004 Drain Commissioner Controllable Personnel Controllable Operating $ 2,668,091.00 $ 2,668,091.00 $ 165,998.00 • 165,998.00 2,668,091.00 165,998.00 0.00% 0.00% - $ 3,810,124.00 $ 3,856,234.74 $ 3,856,234.74 $ 0.00% Total COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES DRAIN COMMISSIONER ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2004 FAVORABLE FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Non-Controllable Operating Transfer Out 919,870.00 56,165.00 985,980.74 56,165.00 965,980.74 56,165.00 0.00% - 0,00% Department Total $ 3,810,124.00 $ 3,856,234.74 $ 3,856,234.74 $ 0.00% === 02123/2004 ADOPTED BUDGET Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,995,080.00 301,954.00 438,618.00 $ 2,733,652.00 2,735,253.48 $ 2,735,253.48 $ 0.00% $ 594,034.00 478,413.00 346,843.30 $1,419,290.30 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% nnnn COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT AMENDED FY 2004 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT $ 1,995,080.00 $ 1,995,080.00 $ 301,954.00 301,954.00 438,219.48 438,219.48 0.00% 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Emergency Response & Preparedness Controllable Personnel Controllable Operating Non-Controllable Operating Auditing Controllable Personnel Controllable Operating Non-Controllable Operating S 586,075.00 $ 594,034.00 475,150.00 478,413.00 325,659.00 346,843.30 $ 1,386,884.00 $1,419,290.30 $ 1,093,380.00 $ 1,093,380.00 $ 1,093,380.00 $ 28,180.00 28,180.00 26,180.00 167,795.00 168,105.04 168,105.04 1,287,885.04 $ 1,287,865.04 $ 0.00% Corporation Counsel Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,287,355.00 $ $ 1,873,933.00 $ 45,943.00 223,725.00 2,143,601.00 $ 1,873,933.00 $ 1,873,933.00 $ 45,943.00 45,943.00 228,227.53 228,227.53 2,146,103.53 $ 2,146,103.53 $ Department Total Controllable Personnel Controllable Operating Non-Controllable Operating • $ 5,548,468.00 $ 5,556,427.00 849,227.00 852,490.00 1,153,797.00 1,179,395.35 $ 7,551,492.00 $ $ 5,556,427.00 $ 852,490.00 1,179,395.35 0.00% 0.00% 0.00% 0.00% 7,588,312.35 $ 7,588,312.35 $ 02/23/2004 $ 1,099,966.00 $ 1,104,102.22 $ 1,089,102.22 $ 15,000.00 1.36% $ 6,950,457.00 $ 6,950,457.00 $ 6,950,457.00 266,265.00 266,265.00 266,265.00 1,257,811.00 1,451,892.20 1,451,892.20 0.00% 0.00% 0.00% 0.00% Non-Controllable Operating Transfer Out 523,871.00 540,817.20 540,817.20 0.00% ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Purchasing Controllable Personnel Controllable Operating Non-Controllable Operating Equalization Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 325,909,00 $ 325,909.00 $ 325,909.00 $- 0.00% 7,900.00 7,900.00 7,900.00 - 0.00% 7,497:00 , 7,497.00 7,497.00 - 0.00% $ 341,306.00 $ 341,306.00 $ 341,306.00 $- 0.00% $ 930,023.00 $ 930,023.00 $ 915,023.00 $ 15,600.00 31,742.00 31,742.00 31,742.00 138,201.00 142,337.22 142,337.22 1.61% - Turnover 0.00% 0.00% $8,474,533,00 $8,668,614.20 $8,668,614.20 $0.00 0.00% Fiscal Services Controllable Personnel Controllable Operating Non-Controllable Operating $ 5,132176.00 149,665.00 1,251,813.00 $ 5,132,176.00 149,665.00 1,455,882.10 $ 5,066,766.00 $ 149,665.00 1,455,882.10 65,410.00 1.27% Turnover 0.00% 0.00% $ 6,533,654.00 $ 6,737,723.10 $ 6,672,313.10 $ 65,410.00 0.97% Reimbursement Controllable Personnel Controllable Operating $ 2,139,463.00 $ 2,139,463.00 $ 2,139,463.00 $ 69,327.00 69,327.00 77,327.00 0.00% (8,000 00) -11.54% - (Unfav.) due to increase in volume of filing fees offset by favorable revenue for tax intercepts $ 2,732,661.00 $ 2,749,607.20 $ 2,757,607.20 $ (8,000.00) -0.29% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out 41A 3 15,478,028.00 $15,478,028.00 $15,397,618.00 $ 524,899.00 524,899.00 532,899.00 3,179,193.00 3,598,425.72 3,598,425.72 $ 19,182,120.00 $19,601,352.72' $19,528,942.72 $ 80,410.00 (8,000 00) 72,410.00 0.37% 0.52% -1.52% 0.00% 0.00% 02/18/2004 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Controllable Personnel $ 178,341.00 $ 178,341.00 $ 178,341.00 $ Controllable Operating 2,800.00 2,800.00 2,800.00 Non-Controllable Operating • 13,570.00 14,918.69 14,918.69 $ 194,711.00 $ 198,059.69 $ 198,059.69 $ Support Services Controllable Personnel $ 1,168,887.00 $ 1.166,887.00 $ 1,168,887.00 $ Controllable Operating 33,353.00 33,353 00 33,353.00 . Non-Controllable Operating 961,851.00 980,536.27 980,538.27 Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,182,091.00 $ 2,180,776.27 $ 2,180,778.27 $ 0.00% $ 1,345,228.00 $ 1,345,228.00 $ 1,345,228.00 $ 38,153.00 36,153.00 38,153.00 975,421.00 995,454.96 996,454.98 $ 2,356,802.00 $ 2,378,835.98 $ 2,378,835.98 $ 0.00% 0.00% 0.00% 0.00% 02/23/2004 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT Administration Controllable Personnel Controllable Operating Non-Controllable Operating AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 341,449.00 $ 341,449.00 $ 341,449.00 $ 2,525.00 , 2,525.00 2,525.00 36,541.00 36,541.00 36,541.00 $ 380,515.00 $ 380,515.00 $ 380,515.00 $ EXPLANATION OF SIGNIFICANT VARIANCES Facilities Engineering Controllable Personnel $ 904,017.00 $ 904,017.00 $ 899,017.00 $ 5,000.00 0.55% - Fay. Overtime based on anticipated project activity. Controllable Operating 107,400.00 107,400.00 107,400.00 . 0.00% . Non-Controllable Operating 97,906.00 97,960.87 97,960.87 - 0.00% Transfers Out 54,000.00 54,000.00 54,000.00 - 0.00% $1,163,323.00 $1,163,377.87 $ 1,158,377.87 $ 5,000.00 0.43% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out $1,245,466.00 $1,245,466.00 $ 1,240,466.00 $ 5,000.00 0.40% 109,925.00 109,925.00 109,925.00 - 0.00% 134,447.00 134,501.87 134,501.87 - 0.00% 54,000.00 54,000.00 54,000,00 - 0.00% $1,543,838.00 $1,543,892.87 $ 1,538,892.87 $ 5,000.00 0.32% 02/23/2004 $ 289,929.00 10,219.00 9,602.88 $ 289,929.00 $ 10,219.00 9,602.88 0,00% 0.00% 0.00% Controllable Operating 406,678.00 406,678.00 393,478.00 Non-Controllable Operating 498,914.00 546,295.30 545,695.30 600.00 $ 3,210,698.00 $ 628,975.00 753,967.18 0.00% 13,200.00 2.06% 600.00 0.08% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES HUMAN RESOURCES ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel $ 289,929.00 Controllable Operating 10,219.00 Non-Controllable Operating 8,971.00 Human Resources Controllable Personnel $ 309,119.00 $ 309,750.88 $ 2,230,083.00 $ 2,230,083.00 $ 309,750.88 $ 0.00% $ 2,230,083.00 $ 0.00% - 13,200.00 3.25% - Anticipated reduction in usage of Travel and Conference $2,500, Personal Mileage $400, Office Supplies $5,500, Equipment Repairs & Maintenance $1,100, Membership, Dues and Publications $400 and Data Processing Supplies $3,300. 0.11% - Favorability anticipated in Mailroom expense $3,600 offset by unfavorable expense in Print Shop ($3,000) based on historical usage. Employee Relations Controllable Personnel Controllable Operating Non-Controllable Operating $ 3,135,675.00 $ 3,183,056.30 $ 3,169,256.30 $ 13,800.00 0,43% $ 690,686.00 $ 690,686.00 $ 690,686.00 $ 225,278.00 225,278.00 225,278.00 198,669.00 198,669.00 198,669.00 0.00% 0.00% 0.00% $ 1,114,633.00 $ 1,114,633.00 $ 1,114,633.00 $ 0.00% Department Total Controllable Personnel $ 3,210,698.00 $ 3,210,698.00 Controllable Operating 642,175.00 642,175.00 Non-Controllable Operating 706,554.00 754,567.18 $ 4,559,427.00 $ 4,607,440.18 $ 4,593,640.18 5 13,800.00 0.30% 0 02/17/2004 0.00% 0.00% 0.00% $ 7,673,812.00 $ 7,673,812.00 $ 7,673,812.00 $ Health Controllable Personnel $ 25,081,135.00 $ 25,081,135.00 $ 24,781,135.00 $ Controllable Operating Non-Controllable Operating Transfer Out 4,197,974.00 3,016,580.00 4,199,214.00 3,172,261.16 4,199,214.00 3,172,261.16 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES HUMAN SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 183,434.00 $ 183,434.00 $ 183,434.00 $ 7,476,673.00 7,476,673.00 7,476,673.00 13,705.00 13,705.00 13,705.00 0.00% 300,000.00 1.20% - Favorable due to staff turnover offset by (Unfav.) overtime from high activity in Environmental Health ($112,000). Children's Village Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 32,295,689.00 $ 32,452,610.18 $ 32,152,610.16 $ 300,000.60 0.92% $ 10,931,521.00 $ 10,931,521,00 $ 10,931,521.00 $ 0.00% 3,443,916.00 3,446,673.00 3,496,673.00 (50,000.00) -1.45% (Unfav.) due to increase of prescription cost. 2,293,562.00 2,320,009.98 2,320,009.98 0.00% 0.00% $ 16,668,999.00 $ 16,698,203.98 $ 16,748,203.98 $ (50,000.00) -0.30% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 36,196,090.00 15,118,563.00 5,323,847.00 $ 36,196,090.00 $ 35,896,090.00 $ 15,122,560.00 15,172,560.00 5,505,978.14 5,505,976.14 300,000.00 (50,000.00) • 0.83% -0.33% 0.00% 0.00% $ 56,638,500.00 $ 56,824,626.14 $ 56,574,626.14 $ 250,000.00 0.44% 02/18/2004 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES PUBUC SERVICES Public Services - Admin. Controllable Personnel Controllable Operating Non-Controllable Operating AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 163,502.00 $ 163,502.00 163,502.00 7,800 00 7,800.00 7,800.00 6,582.00 6,582.00 6,582.00 0.00% 0.00% 0.00% EXPLANATION OF SIGNIFICANT VARIANCES 177,884.00 $ 177,884.00 $ 177,884.00 $ 0.00% Veteran's Services Controllable Personnel $ 1,318,308.03 $ 1,318.306.00 $ 1,318.306.00 $ - . 0.00% Controllable Operating 253,379.00 253,379.00 229,379.00 24,000.00 9.47% - Fay. Soldier Burial $24,000 due to lower than anticipated number of qualifying soldier deaths. Variance assumes additional expense associated enactment of PA 290 of 2003. Non-Controllable Operating 229,818.00 230,170 05 230,170,05 0.00% 1,801,503.00 $ 1,801,855.05 $ 1,777,855.05 $ 24,000.00 1.33% Community Corrections Controllable Personnel $ 2,839,850.00 $ 2,839,850.00 $ '2,789,850.00 $ 50,000.00 1.76% - Fay. Turnover. . Controllable Operating 511,998.00 549,894.00 666,894.00 (117,000.00) -21.28% - Unfav. Testing Material ($117,000) due to Increased drug testing offset by increase in revenues. Non-Controllable Operating 493,101.00 520,565.60 520,565.60 0.00% Transfer Out - - - 0.00% $ 3,044,949.00 $ 3,910,309.60 $ 3,977,309 60 $ (57,000.00) -1.71% MSU Ext. - Oakland County . Controllable Personnel $ 882,566.00 $ 682,566.00 $ 652,568.00 $ 30,000.00 4.40% - Fay. Turnover Controllable Operating 104,978.00 104,978.00 104,978.00 - 0.00% Non-Controllable Operating 353,834.00 354,251.85 345,251.85 9,000.00 2.54% - Fay. Telephone Communication $9,000 lower than anticipated. $ 1,141,380.00 $ 1,141797,85 $ 1,102,797.85 $ 39,000.00 3.42% Medical Examiner . Controllable Personnel $ 2,652,948.00 $ 2,652,948.00 $ 2,632,948.00 $ 20,000.00 0.75% - Fay. Turnover. Controllable Operating 451,912.00 451,912.00 471,912.00 (20,000.00) . -4.43% - Unfav. Transporting Services ($10,000) and Film & Processing ($10,000). Non-Controllable Operating 849,034.00 858,243.98 858,243.98 0.00% $ 3,953,894.00 $ 3,963,103.98 $ 3,963,103.98 $- 0.00% Animal Control Controllable Personnel $ 1,566,985.00 $ 1,546,720.00 $ 1,496,720.00 $ 50,000.00 3.23% - Fay. Turnover. Controllable Operating 95,896.00 75,958 00 76,958,00 0.00% Non-Controllable Operating 524,397.00 52E3,572.39 552,572.39 (24,000.00) 4.54% - Unfav. Motor Pool ($21,000); Telephone Communications ($3,000) higher than budgeted. $ 2,187,278.00 $ 2,152,250.39 $ 2,126,250.39 5 26,000.00 1.21% Circuit Court Probation Controllable Personnel $ - $ - $ - $- 0.00% Controllable Operating 42,539.00 42,539.00 42,539.00 - 0.00% - Non-Controllable Operating 794,389.00 794,675.65 779,675.65 15,000.00 1.89% - Fav. Telephone Communications lower than budgeted. $ 835,928.00 5 837,214.55 822,214.65 5 15,000.00 1.79% 02/20/2004 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Department Total Controllable Personnel $ 9,224,159.00 $ 9,203,894.00 $ 9,053,894.00 $ 150,000.00 1.63% Controllable Operating 1,468,502.00 1,487,460.00 1,600,460.00 (113,000.00) -7.60% Non-Controllable Operating 3,251,155,00 3,293,061.52 3,293,061.52 0.00% Operating Transfer Out . - $ 13,943,816.00 $ 13,984,415.52 $ 13,947,415.52 $ 37,000.00 0.26% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENT AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Controllable Personnel $ 789,074.00 $ 789,074.00 5 776,574.00 $ 12,500.00 1.58% - Turnover Controllable Operating 744,845.00 . 778,427.00 778,427.00 _ 0.00% Non-Controllable Operating 129,154.00 134,740.03 134,740.03 - 0.00% 5 1,663,073.00 $ 1,702,241.03 $ 1,889,741.03 $ 12,500.00 0.73% Planning and Economic Development Services Controllable Personnel $ 3,036,948.00 $ 3,036,948.00 5 2984,448.00 $ 52,500.00 1.73% - Turnover Controllable Operating 465,800.00 465,800.00 465,800.00 - 0.00% Non-Controllable Operating 860,283.00 860,463.67 860,463.67 - 0.00% $ 4,363,031.00 $ 4,363,211.67 $ 4,310,711.67 $ 52,500.00 1.20% Department Total Controllable Personnel $ 3,826,022.00 $ 3,826,022.00 5 3,761,022.00 5 65,000.00 1.70% Controllable Operating 1,210,645.00 1,244,227.00 1,244,2.27.00 - 0.00% Non-Controllable Operating 989,437.00 995,203.70 995,203.70 - 0.00% Transfer Out - - - - 0.00% 6,026,104.00 $ 8,065,452.70 $ 6,000,452.70 $ 65,000.00 107% (4) EXPLANATION OF SIGNIFICANT VARIANCES 02/23/2004 Workforce Development Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENT/WORKFORCE DEVELOPMENT ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT ••••n•nn••••n••n•.....* EXPLANATION OF SIGNIFICANT VARIANCES $ 687,508.00 $ 687,508.00 $ 687,508.00 $ 328,717.00 328,717.00 328,717.00 90,655.00 90,655.00 90,655.00 $ 1,106,880.00 $ 1,106,880.00 $ 1,106,880.00 $ $ 687,508.00 $ 687,508.00 $ 687,508.00 $ 328,717.00 328,717.00 328,717.00 90,655.00 90,655.00 90,655.00 • $ 1,106,880.00 $ 1,106,880.00 $ 1,106,880.00 $ 02/23/2004 BUDGET AS ADJUSTED FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 55,000.00 $ 55,000,00 $ 1,700.00 1,700.00 $ 65,000.00 65,000.00 65,000.00 $ 20,800.00 20,800.00 21,900.00 $ 579,000.00 579,000.00 579,000,00 $ 30,000.00 30,000.00 30,000.00 $ $ 751,500.00 $ 751,500.00 $ 752,600,00 STATE AND FEDERAL - COUNTY ASSOCIATIONS (230000) Area Wide Water Quality 55,000.00 Assoc of Metro Sewage Agencies 1,700.00 Michigan Assoc. of Counties National Assoc. of Counties S,E M,C.O.G. Traffic Improvement Association Total SUNDRY EXPENSE (2400001270000) $ 300,000.00 $ 300,000.00 300,000.00 $ 0.00% 75,000.00 58,186.00 58,186,00 - 53,000.00 53,000.00 53,000.00 - 4,000.00 4,000.00 4,000.00 - 365,128.00 352,634.00 352,634.00 - $ 15,719,843.00 $ 9,814,105.78 $ 9,814,105.78 $ 1,117,870.00 0.00% 0.00% 0.00% 11.39% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET AS ADOPTED INON-DEPARTARTMENT APPROPRIATIONS V-- COUNTY OPERATIONS County Expenditure* (210000) Ambulance 19,800.00 $ Insurance Fund - Insurance Surety Bonds 15,000.00 Road Commiss1on1Current Drain Assessment 1,233,733.00 Road CommissionWri Party Agreement 1,500,iD00.00 Senior Citizen Prescriptions 150,000.00 Transfer to Component Unit 9,620,616.00 Total $ 12,539,149.00 19,800.00 $ 19,800,00 $ 166,298.00 $ 166,298,00 $ 15,000.00 $ 15,000.00 $ 1,233,733.00 $ 1,233,733.00 $ 1,500,000.00 $ 1,500,000,00 $ 150,000.00 $ 150,000.00 $ 9,620,616.00 9,620,616.00 $ $ 12,705,447.00 $12,705,447,00 $ (1,100.00) (1,100.00) COUNTY BUILDINGS (220000/320000) $ 3,630,327.00 $ 3,309,881.59 $ 3,309,881.59 $ 0.00% 0.00% 0.00% -5.29% - Reflects actual fees. 0.00% -0.15% (600,000.00) 209,382.00 820,554.00 225,000.00 200,000.00 1,267,500.00 6,755,409.00 6,164375.00 180,495.00 RESERVED FOR TRANSFERS (290000) Expenditures Administrative Leave Basic Readjustment Budget Task Classification and Rate Change Contingency Emergency Salaries Grant Match Info Tech Development Legislative Expense Misc. Capital Outlay Overtime Appropriation Workshops and Meetings Summer Employees Salary Appropriation Total (600,000.00) (600,000:00) $ 209,382.00 209,382.00 908,488.00 908,488.00 219,148.00 219,148.00 97,592.00 97,592.00 1,267,500.00 1,267,500,00 2,088,862.00 2,088,862.00 4,974,818.78 4,974,818,78 180,495.00 180,495.00 0.00% 209,382.00 100.00% A Budget amendment Is pending. 908,488.00 100,00% Funds will be used for Budget Transition. 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% - A budget amendment Is requested to transfer funds ($85,000) to the Board of Commissioners for Public Information expense. 90.xls 1 2123/2004 iiiiii=XWM====..= 2.80% $ 39,902,235.37 $ 41,353,238.00 $ 39,903,335.37 $ . 1,116,770.00 TOTAL. NON-DEPT. APPROPRIATIONS COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET AS ADOPTED BUDGET AS ADJUSTED FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION Transfers to Other Funds (3100001 Bldg Authority (Debt) Bldg Fund (Capital Improvement Pro9.) CLEMIS Information Technology Motor Pool Oak. Enhancement-Community Partnership Total $1,555,919.00 2,350,000.00 1,950,800.00 2,500,000.00 55,71)0.00 $ 8,412,419.00 $1,555,919.00 6,745,812.00 1,950,300.00 2,705,570.00 7,500.00 55 700.00 313,021.301.00 $1,555,919.00 $ 6,745,812.00 1,950,800.00 2,705,570.00 7,500.00 55,700.00 $13,021,301.00 $ 0.00% 0.00% 0.00% 1100% 0.00% 0.00% 0.00% TRANSFER TO GENERAL PURPOSE FUNDS Health Fund Juvenile Maintenance Fund Social Welfare Fund (310000) $ 25,526,822.00 15,989,045.00 15,000.00 3,41,530,867.00 $ 25,615,809.16 16,013,249.98 15,000.00 $41,649,059.14 $ 25,615.809.16 $ 16,018,249.98 15,000.00 $41,649,059.14 $ 0.00% 0.00% 0.1./31 0.00% 1.37% TOTAL EXPENDITURES $ 82,834,105.00 $ 81,551,294.51 $ 81,552,394.51 1,116,770.00 (41 90.)ds 2 ',II-A(1(111S COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS SHERIFF'S OFFICE ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV4UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ---- IIHERIFF AVIATION #680 OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES $ 2,066,692.00 $ 2,066,692.00 $ 2,066,692.00 • - 0.00% - 52,066.692.00 52.066,692.00 52,066.692.00 $ ' - 0.00% 51,629,192.00 51,629,192.00 $1,629,192.00 $ - 0.00% - NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $437,500.00 $437,500.00 $437,500.00 $ 0.00% NON OPERATING REVENUE $0.00 $0.00 0.00 $- 0.00% OPERATING TRANSFERS IN $0.00 $0.00 $0.00 $- 0.00% NET REVENUES OVER(UNDER) EXPENSES $437,500.00 $437,500.00 $437 - ,500.00 $ 0.00% ••J*1 02/23/2004 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUND DEPARTMENT OF CLERKIREGISTER OF DEEDS ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MICROGRAPHICS FUND (6541 REVENUES Outside Inside Total Revenues $414,556 $414,556.00 $414,556.00 $0.00 0.00% - 329,104 $329,104.00 $329,104.00 $0.00 0.00% $743,660 $743,660.00 $743,660.00 . $0.00 0.00% OPERATING EXPENSES $984,739 $1,104,376.00 $1,003,776.00 $100,600.00 9,11% - Pay due to turnover, lower depreciation, indirect cost, and Info Tech Oper. NET NON-OPERATING REV $23,000 $23,000.00 $23,000.00 goo atm% - REVENUE OVER (UNDER) EXPENDITURES ($218,079) ($337,716.00) ($237,116.00) $100,600.00 ‘3115 door MICROGRAPHICS.xls 2/19/2004 $2,131,508.00 $2,131,508.00 $2,131,550.29 $0.00 0.00% 738,230.00 738,230.00 738,230.00 $0.00 0.00% 2,869,738.00 2,869,738.00 2,869,780.29 0.00 0.00% -4.30% - Unfav - Indirect Costs (22,409) increase in cost due to rate change. Unfav - Adjustment Prior Years Exp. (41,574) for payroll and voucher correction from FY 2003. Unfav - FA Expendable Equipment Expense ($24,589) zero acount - out by capitalizing items at year end. Way - Shop Supplies ($4,397) due to greater expense than anticipated. Unfav Insurance Fund ($66,991) as item use to be charged in Motor Pool combined accounts reflecting unfavorability. 653.11.% 'DRAIN EQUIPMENT FUND ( 639) OPERATING REVENUES: Inside Outside Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE 2,888,736.00 2,888,736.00 3,012,814.20 (124.078.20) (18,998.00) (18,998.00) (143,033.91) (124,078.20) COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUND DRAIN COMMISSIONER ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET ACTUAL FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES NON-OPERATING REVENUE/(EXPENSE) 77,182.00 77,182.00 77,182.00 0.00 0.00% r TRANSFER IN 0.00 0.00 0.00 0.00 0.00% TRANSFERS (OUT) 118,034.,00 118,034.00 118,034.00 0.00 0.00% ($59,850,00) ($59,850.00) ($183,885.91) ($124,078.20) NET REVENUES OVER(UNDER) EXPENSES 02/23/2004 LIABILITY INSURANCE FUND 677 OPERATING REVENUE COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $2,716,833.00 $2,716,833.00 $2,849,333.00 $132,500.00 4.88% - Fay, due to billing for department owned vehicle insurance, offset by expense. A budget amendment is recommended. OPERATING EXPENSE 2,146,229.00 2,146,229.00 2,278,729.00 (132,500.00) -6.17% - Unfav, due to paying for department owned vehicles insurance, offset by revenue. A budget amendment is recommended. CLAIMS PAID 1500,000.00 1,500,000.00 1,500,000.00 0.00 0.00% TOTAL OPERATING EXPENSES 3,646,229.00 3,846.229.00 3,778,729.00 (132,500.00) -3.63% OPERATING INCOME (LOSS) (929,396.00) (929,396.00) (929,396.00) 0.00 0.00% NON-OPERATING REVENUE (EXPENSE) 400,000.00 400,000.00 400,000.00 0.00 0.00% NET REVENUES OVER/(UNDER) EXPENSES ($529,398.00) ($529,396.00) ($529,396.00) $0.00 000. 02/23/2004 'OFFICE EQUIPMENT FUND 664 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME (LOSS) NET REVENUES OVER/(UNDER) EXPENSES $129,740.36 $ 129,700.00 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUND MANAGEMENT AND BUDGET ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT - EXPLANATION OF SIGNIFICANT VARIANCES ----r-----z ------- ------- ---- $658,345.00 $656,345.00 $638,177.16 $ (20,200.00) -3.07% - Unfav, due to equipment replaced under the one time replacement plan $689,651.00 $689,651.00 $539,742.80 $ 149,900.00 21,74% - Fay. due to hold on purchase of equipment $ (31,306.00) $ (31,306.00) $ 98,434.36 $ 129,700.00 -414.30% NET NON-OPERATING REV (EXP) $ 31,306.00 $ 31,306 00 $ 31,306.00 $ 0.00% - 02/23/2004 !FRINGE BENEFITS FUND 678 0.00% 0.78% 0.00% 1.49% 40.00% 80.00% ' 3.94% 14.12% 10.80% 0.03% 1.59% 1.61% -0.60% 2,74% 7.62% 4.19% 19.49% 16.00% 0,00% 14.66% 1.96% 0.00% 1.02% COUNTY OF OAKLAND EY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUND FRINGE BENEFITS FUND ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES REVENUE RETIREES HOSPITALIZATION $27,194,338 $27,194,338 $27,196,338 $2,000 0.01% RETIREMENT ADMINISTRATION 1,126,800 1,126,800 1,120,000 (6,800) -0.60% TUITION REIMBURSEMENT 335,000 335,000 332,000 (3,000) -0.90% EMPL. DEFERRED COMP. ADMIN. 1,500 1,500 1,400 (100) -6.67% EMPL. DEFERRED COMP. COUNTY 723,500 723,500 718,000 (5,500) -0.76% EMPLOYEE IN-SERVICE TRAINING 1,582,400 1,562,400 1,542,500 (19,900) -1.27% DEFINED CONTRIBUTION PLAN 14.433,800 .14,433,800 14,433,000 (800) -0.01% GROUP LIFE 660,000 660,000 660,000 0 0.00% HOSPITALIZATION 26,132,000 26,132,000 25,990,000 (142,000) -0.54% SOCIAL SECURITY 14,317,000 14,317,000 14,335,000 18,000 0.13% DENTAL INSURANCE 2,983,900 2,983,900 2,980,000 (3,900) -0,13% OPTICAL INSURANCE 343,000 343,000 343,000 0 0.00% DISABILITY INSURANCE 861,600 861,600 861,1000 (600) -0.07% SHORT-TERM DISABILITY 1,420,800 1,420,800 1,420,800 0 0.00% FRINGE BENEFITS 705,261 705,261 705,261 0 0.00% WORKERS COMPENSATION 2,290,800 2,290,800 2,299,800 9,000 0.39% UNEMPLOYMENT COMPENSATION 350,000 350,000 360,000 10,000 2.86% SICK AND ANNUAL LEAVE CASH-OUT 500,000 500,000 503,000 3,000 0.60% FLEXIBLE BENEFIT DEDUCTIONS 131,675 131,675 226,975 95,300 72.38% EXT - FLEX BENEFIT HOSPITAL 1,600,000 1,600,000 1,560,000 (40,000) -2.50% EXT - HOSPITALIZATION INSURANCE 400,000 400,000 360,000 (40,000) -10.00% EXT - DENTAL INSURANCE 75,000 75,000 62,000 (13,000) -1733% EXT - OPTICAL INSURANCE 2,000 2,000 1,500 (500) -25.00% EXT - FORFEITURES 10,000 10,000 10,000 0 0.00% INVESTMENT INCOME 540,410 540,410 364,610 (175,800) -32.53% - Continued low Investment rates. TOTAL REVENUE $98,700,784 $98,700,784 $98,388,184 ($314,600) -0.32% EXPENSE RETIREES HOSPITALIZATION $27,194,338 $27,194,338 $27,194,338 $0 RETIREMENT ADMINISTRATION 1,125,800 1,126,800 1,118,000 8,800 SICK AND ANNUAL LEAVE CASH-OUT 500,000 500,000 500,000 0 TUITION REIMBURSEMENT 335,000 335,000 330,000 5,000 EMPL. DEFERRED COMP. ADMIN. 1,000 1,000 800 400 EMPL. DEFERRED COMP. PRINTING 500 500 100 400 EMPL, DEFERRED COMP. COUNTY 723,500 723,500 695,000 28,500 EMPLOYEE IN-SERVICE TRAINING 1,162,400 1,162,400 998,300 164,100 IN-SERVICE TRAINING - INFO TECH 400,000 400,000 356,800 43,200 DEFINED CONTRIBUTION PLAN 14,433,800 14,433,800 14,430,000 3,800 GROUP LIFE 660,000 660,000 649.500 10,500 HOSPITALIZATION 28,132,000 28,132,000 27,680,000 452,000 SOCIAL SECURITY 14.317.000 14,317,000 14,403,000 (86,000) DENTAL INSURANCE 3,058,900 3,058,900 2,975,000 83,900 OPTICAL INSURANCE 345,000 345,000 318.700 26,300 DISABILITY INSURANCE 2,282,400 2,282,400 2,186,800 95,600 FLEXIBLE BENEFIT PAYMENTS 421,675 421,675 339,475 82,200 PROFESSIONAL SERVICES 200,000 200,000 168,000 32,000 WORKERS COMPENSATION 2,290,800 2,290,800 2,290,800 0 UNEMPLOYMENT COMPENSATION 350,000 350,000 298,700 51,300 ACCOUNTING SERVICES 95,761 95,761 96,561 (800) CHILD CARE FACILITY 260,410 260,410 255,310 5,100 INDIRECT COSTS 409,500 409,500 409,500 0 TOTAL EXPENSE $98,700,784 $98300,784 697,69/1,484 $1,006,300 $0 $0 $691,700 $691,700 REVENUE OVER/(UNDER) EXPENSE FRINGE BENEFITS.xIs $4,236,285.00 $4,236,285.00 $4,253,086.00 $16,800.00 0.40% - Fay. Landing Fee Concessions $10,000 due to higher than anticipated revenue; Refund Prior Year Expenditures $6,000; Gain on Sale of Equipment $33,800. Unfav Car Rental Concessions ($12,000) due to lower than anticipated revenue; Landing Fees ($21,000). $4,508,080.00 $4,508,080.00 $5,007,680.00 ($499,600.00) -11.08% - Unfav. Indirect Costs ($41,000) higher than budgeted; Depreciation ($433,600) , which Includes additional reporting of local and state Grants as required by GASS 34. Insurance ($25,000) higher than anticipated. COUNTY OF OAKLAND P12004 FIRST QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED FY 2004 VARIANCE BUDGET FORECAST FAVAUNFAV) PERCENT - --- -- EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (681) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) ($271,795.00) ($271,795.00) ($754,595.00) ($482,800.00) 177.63% NON-OPERATING REVENUE 271,795.00 271,795.00 271,795.00 0.00 0.00% TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFER IN CAPITAL CONTRIBUTION $0.00 $0.00 ($482,800.00) ($482,800.00) 0.00 0.00 0.00 0,00 0.00% 0.00 0.00 10.00 0.00 0.00% TOTAL NET INCOME (LOSS) $0.00 $0.00 ($482,800.00) ($482,800.00), 02120/2004 ADOPTED BUDGET AMENDED BUDGET !MOTOR POOL FUND 661 5,138,460.00 OPERATING REVENUE OPERATING TRANSFERS IN 113,850.00 162,896.00 162,896.00 0.00 0.00% COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES FY 2004 VARIANCE FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 5,150,720.00 4,457,000,00 ($693,700.00) -13.47% - Unfav. due to decrease in lease rate. - Unfav. due to changes in billing for insurance on vehicles. Offset by expense. A budget amendment is recommended. 537,300.00 (156,400.00) 0.00 OPERATING EXPENSE OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS 5,929,888.00 5,942,148.00 5,404,811.00 (791,428.00) (791,428.00) (947,811.00) 430,000.00 430,000.00 430,000.00 9.04% - Fay, due to decrease in gas and oil expense. -19,76% - Unfav. due to changes in billing for insurance on vehicles Offset by revenue. A budget amendment is recommended. 0.00% (361,428.00) (361,428.00) (517,811.00) (156,400_00) -43.27% NET REVENUE OVER/(UNDER) EXPENSES (247,578.00) (198,532.00) (354,915.00) (156,400.00) 78.78% MAILING, CONVENIENCE COPIER AND PRINTING FUND 667 $3,356,393.92 3,165,321.24 191,072.68 2,000.00 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) $3,101,258.00 $3,101,258.00 3,145,615.00 3,145,615.00 (44,357_00) (44,357.00) 2,000.00 2,000.00 $255,100.00 8.23% - Fay. due to increase in printing by departments and increase in outside mailing. (19,700.00), -0.63% - Unfav. due to increase of indirect costs. 235,400.00 530.69% 0.00 0.00% NET REVENUE OVER/(UNDER) EXPENSES $447.:OZ. ($44,357.00) $193,072.68 $235,400.00 530.69% 46, 02/23/2004 (3119,000.00) ($119,000.00) $65,000.00 $65,000.00 654,000.00 354,000.00 $0.00 $144,127.00 $144,127.00 $0.00 $182,800.00 $301,900.00 $75,000.00 10,000.00 $54,000.00 $0.00 $311,800.00 $311,800.00 $144,127.00 30,00 3144,127.00 30.00 $0.00 $0.00 $0.00 $144,127.00 $144,127.00 $0.00 NET REVENUES OVER(UNDER) EXPENSES $0.00 EIVIMG====12 $0.00 0.00% $0.00 $0.00 C. FACILITIES INTERNAL FORE.xls 02/23/2004 ADOPTED BUDGET AMENDED BUDGET FY 2004 FORECAST COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FACILITIES MANAGEMENT VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FACILITIES MAINTENANCE & OPERATIONS (#631) $283,200.00 $283,200.00 $332,000.00 348,800.00 21950,839.00 • 23,950,839.00 23,603,939.00 (348,900.00) 324,234,039.00 324,234,039.00 323,935,939.00 ($298,100.00) $24,353,039.00 $24,353,039 00 $23,753,139.00 5599,900.00 OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN NET REVENUES OVER(UNDER) EXPENSES PONTIAC MARKET (#261) OPERATING REVENUES - OUTSIDE OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS TRANSFERS IN TRANSFERS OUT 17.23% - Fay, for lease payments from CMH Authority at CMH Center and State of Michigan (Jobs Commission) at Oakland Pointe due to occupancy beyond original lease term estimates. -1.45% - Reduced Office Space Rental due to proposed demolition of former Work Release Facility and scheduled move to new 52-3 Rochester Hills District Courthouse in March/April (6 months into FY 2004). The - -1,23% reduced Office Space Rental will be offset by reduced expenditures required to operate and maintain the facilities. 2.46% - Fay. Salaries and Fringe Benefits due to turnover $157,500; fay. Overtime $65,000 based on snow- plowing activity; fav. Sublet Repairs $200,000, Maintenance Supplies & Materials $150,000; Natural Gas $100,000; and Electrical Service $75.000 (contracted rate reduction). The favorable operating variances reflect reduced project activity in the first quarter due to the temporary freeze on project activity, as well as reduced operating and maintenance costs required for the former Work Release Facility and partial year occupation of the new 52-3 Rochester Hills District Courthouse. FavorablIky Is partially offset by Indirect Costs ($94,000) due loan updating of the Indirect Cost charge 253.61% subsequent to budget formulation; Grounds Supplies (336,300); and Telephone Communications ($12,500) based on usage In the first quarter. 15.38% - Fay. Investment Income due to higher investment base. 0.00% 0.00% - 0.00% - 0.00% 0.00% ADOPTED BUDGET AMENDED BUDGET 22,824,395.00 22,829,281.00 21,773,681.00 (1,055,600.00) 0.42% - Favorabillty primarily due to Salaries & Fringe $581,500 turnover; $78,700 Communications for continuing to identify and eliminate low use connections. Favorabiiity partially offset by ($511,800) Increase Indirect Cost rate subsequent to budget projection. 0.00 0.00 0.00 0.00 0.00% ($7,160,610.00) ($7,206,990.00) (5 )300,490.00) 2 550 000.00 2,755,570.00 2,755,570.00 0,00 0.00% 26,777,739.00 27,014,775.00 25,776,475.00 (1,238,300.00) -4.58% 33,938,349.00 34,221,765.00 134,076,965.00 144,800.00 -4.62% - Unfav due to decrease in charges to OC Depts Development ($1,745,100) and Imaging Operations ($12,900). CC Dept* Development Is subject to change pending completion of rate Study_ Unfavorability Is partially offset by hay. Imaging Dev $65,200; Non-Govt Dev & Oper $574,800; CC Dept Oper $83,800 based on equip & was provided to requesting depts. OPERATING REVENUES: Outside $1.649,759.00 $1,649,759.00 $1,771,659.00 $122,100.00' 7.40% - Fey, due to Increased Mtn usage $44,400 and inc of CLEWS membership $98,600. Fey offset by ($20,900) less than anticipated egerldes PaniciPaling In UveScao Maint 51.37% - Fay, due to Increased Contributions from COPS MORE grant recognized in the CLEMIS Fund $110,800; Sheriff Cont Svcs $30,400 including non-contributing agencies such as 52/2s, Reimb., Circuit Ct & Pres.; Increase $5,050 in MDC usage by Sheriff. OPERATING TRANSFERS IN TOTAL OPERATING REVENUES OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) 1.577.000.00 1,589.616.00 1,589,616.00 0.00 0.00% 3,524,659.00 1537,592.00 3.812,892.00 275,300.00 7.78% 10,941,688.00 10,941,985.00 11,034,585.00 (92.600.00) 0.00 0.00 0.00 0.00 0.00% ($7,417009-001 (17,404,393.00) (57,221,693.00) 5182,700.00 , -0.85% - Unfav Communications ($136,100) for inc in CDPD usage for add1 agendas; ($140,700) Professional Svcs proles:had for work on Records Memt System; ($25,600) Indirect Cast rate increase; ($20,800) Non controllable Internal Svc digs. Unfavorabllity is partially offset by favorable Software purchases $150,000 as licensing will be covered under and previously paid under Printrak contract: $74,400 Equip, Repairs & Mahe lower than anticipated costs under Valcom for premise equip; $6,300 tav Commodities for less than anticipated supplies needed for CLEMIS activities inchicing LiveScan equipment repairs. [Information Technology - Radio Communications (MI 297,900.00 298,217.00 451,417.00 153,200.00 Inside $7,517,987.00 $7,517.967.00 57,757,867.00 Fay. primarily due to E-911 Surcharge revenue $188,000 which is designated for new radio system. $239,900.00 3.19% - Antenna site rent Is slightly favorable $1,500. External agency revenue is favorable $72,400 due to increased usage and billing for replacement equipment OPERATING REVENUES: 1%0 Outside COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY FY 2004 VARIANCE FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'Information Technology - Operations (636) OPERATING REVENUES: Outside Inside OPERATING TRANSFERS IN TOTAL OPERATING REVENUES OPERATING EXPENSES $1,403,344.00 $1,429,924.00 $1,247,224.00 ($182,700.00) -1178% • Unfavorability due to less than projected estimate of Access Oakland usage ($182,700) for on-Inc usage of new products offered through access Oakland program.. $29,647.00 4,035,612.00 0.00 4,085,159.00 3,688,080.00 0.001 OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) 'information Technology - Telephone Communications (675) OPERATING REVENUES: Outside Inside OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) IInformation Technology - CLEMIS (635) $34,747.00 $34,747.00 3,807,840.00 3,829,312.00 0_00 0_00 3,8.42.587.00 3,864,059.00 3,795,608.00 3,817,080.00 0.00 0.00 $46,979.00 $46,979.00 5.20% Salary & fringes $30,500 fay, due to timing of increases. Contractual favorable overall: Communications 129,000.00 3.38% - $245,600 improved rate plans from vendors; Sublet repair $5,000 decreased usage; Voice mail $17,300 lower than anticipated maint contract rate; Tower charges $17,300 decreased usage. Partially 0,00 0.00% offset by unfavorable: non-controllable Indirect cost ($58,200); Maim, equip ($32,300) high repair volume Software Purchase ($6,100) upgrade; Prior years expense ($7,700) delayed bilUngs. Equipment unfav. ($81,300) partially offset by Wing to users. Internal services favorable: Info Tech $3,900 decreased use (5,100.00) -14.68% - Unfavorable ($5,800) due to decreased telephone usage by external customers; offset $500 by sale of used equipment at cocinty auction. 208,200.00 5.38% - Favorable $202,000 due to Increased telephone usage and Implementing poky of billing users for new and upgraded equipment Pager usage also Increased, favorable $4,200. 0.00 0.00% 201,100.00 $377 079 00 $330 100 00 COUNTY OF OAKLAND FY 2004 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FA1N(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Inside 1,013,003.00 1,013,924.00 961,024.00 (52,900.00) -5.22% - Unfav. leased equipment ($33,800) and Labor ($20,400) due to decreased usage and repairs; sfightly offset by favorable Paris $1,300. OPERATING TRANSFERS IN 0.00 11,374.00 11,374.00 0.00 0.00% TOTAL OPERATING REVENUES 8,530.970.00 8,543,285.00 8,730,265.00 187,000.00 2.19% Salary & fringes $187,000 (ay. due to vacant positions. Contractual favorable overall: non-controllable • OPERATING EXPENSES 3,724,888.00 3,725,807.00 3,500.007.00 226,800.00 6.06% Indirect cost $55,300; Laundry $1,500 decreased usage; MainL contract $5,000 lower than anticipated. Depredation is favorable $4,100 due to budget amendments. Non-controllable Internal services are OPERATING TRANSFERS OUT 50,000.00 50,000.00 50,000.00 0.00 0.00% - unfavorable overall ($27,100): Maint. charges ($12,600); Info Tech $7,100; Motor pool ($11,500); Print Shop $2,000; Telephone ($13,100); Insurance $1,000. OPERATING INCOME (LOSS) , $4,758,084.00 , 14,767,458.00 $5,180,258.00 , $412,800.00 , - See attachment C for long term radio project Coats I Fire Records Management (531k OPERATING REVENUES: Outside OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) $130,000.00 1130.000.00 $130,000.00 $0.00 0.00% - 373600.00 469,500.00 469,600.00 0.00 0.00% 503,800.00 599,500.00 599,500.00 0.00 0.00% Salary & fringes $28,900 favorable due to timing of budgeted increase. Contractual ($23,400) 557,342.00 557,342.00 551,842.00 5,500.00 0.99% - unfavorable overall: Non-controllable Indirect cost ($5,900); Software rent/lease ($19,000) unfav. due to delay in 2003 budgeted purchase; Personal mileage 11,500 fav, lower than anticipated site visits. 0.00 000 0.00 0.00 0.00% (153,542.001 142,158.00 :41,2E192_ $5,500.00 FY 2004 BUDGET AMENDMENTS $ 360,443,936.00 $ 67,934.00 $ 20,00(100 FY 2004 BUDGET AS ADOPTED BUDGET AMENDMENTS M.R. #03306 - 10130/2003 Human Services - MIDEQ Reimbursement Acceptance M.R. #03324 - 11/20/2003 County Executive - ERP - 2003 ODP Homeland Security Assessment & Strategy Application / Acceptance Grant M.R. #03339 - 12111/2003 Sheriff Use of Forfeited Funds for DARE, Internet and Drug Awareness M.R. #03356 - 12111/2003 County Executive - ERP - 2003 ODP Homeland Security Exercise Grant M.R. #03357 - 1211112093 Public Services / Animal Control - Reorganization 25,000.00 $ 17,000.00 $ (49,590.00) M.R. #03326 - 12/11/2003 $ 4,395,812.00 Department of Management & Budget - E - Financial System - Phase I $ 205,570,00 $ 144,032.00 $ 70,464.00 M.R. #03358 - 12/11/2003 Treasurer - e-Tax @ccess Project M.R. #03367 - 12/11/2003 Sheriff Patrol Contract with Independence Township M.R. #03368 - 12/11/2003 Sheriff - Patrol Contract with Oxford Township TOTAL AMENDED BUDGET AS OF 12/31/2003 (1ST QUARTER) $ 365,340,158.00 - (AP\ Page 1 of 1 TOTAL 243 $ 646,101.00 Interoffice MEMORANDUM to: Nancy Fournier, Fiscal Services cc: Judi Lockhart, Reimbursement from: Joyce Raczka, Reimbursement re: Inmate Waived Report date: February 5,2004 Submitted for your review is the Inmate Report for 2003 for the Months of Oct. Nov and Dec. Number of Amount Waived Accounts ' Oct 03 053095 CZ 94 $ 188,406.00 Nov 03 053857 CZ 645 * $ 234,657.00 Dec 03 054528 CZ 44 $ 223,038.00 From the desk at—. Joyce Racz ka Reimbursement 1200 N Telegraph Road Pontiac, Michigan 48343 COUNTY MICHIGAN OFFICE OF THE MEDICAL EXAMINED L.J Dragovic, M.D., Chief Medical Examiner K. Virani, M.D., Deputy Chief Medical Examiner B. Peons, M.D., Deputy Medical Examiner R. Ortiz-Reyes, M.D., Deputy Medical Examiner V. Alexandrov, M.D., Deputy Medical Examiner L Brooks Patterson, Oakland County Executive Public Services R. Gerds, Administrator TO: Tim Soave, Chief - Fiscal Servi From: Robert Gerds, Administrato Subject: Gift Donation Date: January 6, 2004 Pursuant to Miscellaneous Resolution # 83154, be advised that Dr. Thomas Petinga, Jr. donated to the Medical Examiner's Office a check for $1000.00 for enhancements for educational resources and growth of the Medical Examiner's Office Library. There are no financial implications for Oakland County as a result of accepting the above gift. RG/ph cc: Michael Zehnder, Director Public Services 5k 1200 N TELEGRAPH RD DEPT 438 BUILDING 28 EAST • PONTIAC MI 48341-0438 • (248) 858-5097 • FAX (248) 452-9173 1 1 HEREBY APPROVE THE FORMS RESOLUTION /72_ /07 G. William Caddell, County Clerk Resolution #04072 March 18, 2004 Moved by Moss supported by Zack the resolution be adopted. AYES: Coulter, Crawford, Douglas, Gregory, Hatchett, Jamian, Knollenberg, KowaII, Law, Long, McMillin, Middleton, Moffitt, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Webster, Wilson, Zack, Bullard, Coleman. (25) NAYS: None. (0) A sufficient majority having voted therefore, the resolution was adopted. "WM STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 18, 2004 with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 18th day of March, 2004,