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.09.09 - 27746
A 4 A MISCELLANEOUS RESOLUTION 404246 September 9, 2004 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2004 THIRD QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS 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 amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2004 Third Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS an amendment is requested in the 52=0 District Court - Division III budget to re-appropriate projected favorability from Salaries and Fringe Benefits in the amount of $25,000 to Rent due to delay in move to new facility and Convenience Copier due to increase in activity; and WHEREAS an amendment is requested in the Probate Court - Estates and Mental Health budget to re-appropriate favorable Salaries and Fringe Benefits in the amount of $17,600 to Guardian Review / Adult and IT-CLEMIS due to increase in activity; and WHEREAS an amendment is requested in the Prosecuting Attorney's Office to re-appropriate funds from favorable Outside Printing in the amount of $16,000 to Expendable Equipment Expense for the replacement of worn furniture; and WHEREAS an amendment to the Prosecuting Attorney's Cooperative Reimbursement Grant for Indirect Costs requires an increase in the General Fund Grant Match portion in the amount of $30,479; and WHEREAS due to financial difficulties, HAVEN is unable to reimburse partial funding of a Prosecuting Attorney position, which requires an increase in the General Fund Grant Match portion in the amount of $20,000; and WHEREAS a budget amendment in the amount of $80,000 is requested for the Board of Commissioners' budget to transfer Non-Departmental Legislative Expense funding to cover costs associated with the Board's Annual Report; and WHEREAS an amendment is requested in the Drain Commissioner's budget to re-appropriate budgeted Transfer funds in the amount of $28,734 to various operating expense accounts projected to be unfavorable due to an increase in activity; and WHEREAS a budget amendment is recommended to appropriate $79,900 of reserved funds for the Health Division Budget for Satellite Centers which were accrued in 2003, are currently unspent and are available for 2004; and WHEREAS a budget adjustment is recommended within the Animal Control Division to re-appropriate $39,000 from the Professional Services account to the IT - Development account to more accurately reflect actual account charges for implementation of Thin Client computers; and WHEREAS the Community Corrections Division is experiencing an excess in charges for PRC (Probation Residential Centers) contracts not funded by the State by $100,000 and a budget amendment is recommended; and FINANCE COMMITTEE: Motion carried unanimously on a roll call vote. WHEREAS the Medical Examiner is projected to be favorable $60,000 in revenue due to an increase in fees per M.R. 403369 and $37,000 should be appropriated to cover increased Professional Services and Transport Services; and WHEREAS the Solid Waste Management Unit is projected to be favorable in Professional Services and an amendment in the amount of $16,500 is requested to transfer funds to various Non-Controllable Operating accounts to offset anticipated unfavorable variances; and WHEREAS funding for development and production of the Oakland County Street Map and Atlas Project of $42,950 within the Planning Division a budget amendment is recommended to re-appropriate funds within the division for this purpose; and WHEREAS the Sheriff's Office, Clerk's Office and Equalization Division are projected to have significant favorability in revenues; and WHEREAS a budget amendment is recommended to recognize the increase in revenues to offset an increase in various departmental accounts as follows: Circuit Court - $1,300,000 due to significant increase in costs and use of Private Institutions - Residential, State Institutions, and Professional Services Children's Village - $35,885 due to purchase of 14 new radios Health Division - $13,370 for Jail Clinic furniture replacement Clerk's Office - $564,600 due to increase in mortgage and refinancing activity and election activity. Sheriff's Office - $1,278,000 primarily due to jail overcrowding and outside prisoner housing costs. Equalization Division - $50,000 due to higher volume of tax notices mailed out. Record Retention - $110,000 due to additional shelving needed for Circuit Court documents maintained by the County Clerk. Planning & Economic Development - $107,052 for costs associated with implementation of Emerging Sectors Program; and WHEREAS an adjustment is recommended for the Micrographics Fund budget to move budget of $110,054 from Micrographics & Reproductions expense to Materials and Supplies expense to more accurately reflect actual costs; and WHEREAS the Drain Commissioner is requesting an amendment in the amount of $277,002 to the Drain Equipment Fund budget due to a decrease in actual cost for five budgeted vehicles and the replacement of eleven owned vehicles with eleven leased vehicles; and WHEREAS an adjustment to the Motor Pool Fund Budget is recommended to re-appropriate $40,000 from the Insurance Reserve Revenue budget to External - Other Revenue budget as subrogation payments are an external revenue; and WHEREAS an adjustment to the Printing, Mailing and Convenience Copier Fund budget is requested to re-appropriate $35,000 from External - Other Revenue account to the External - Metered Postage Revenue account to identify external revenue received as metered postage, and $123,000 from the Sublet Repairs account to the Re-billable Charges account to more accurately reflect services rendered; and WHEREAS an amendment for $25,575 is requested to fund the cost of miscellaneous computer equipment as requested by the department users, which i BE IT FURTHER RESOLVED that $255,000 from the FY 2004 Designated Fund Balance for Geographic Information System Enhancements (GL #9407-10000) be appropriated to the Information Technology Fund for enhancements to the G.I.S. information base as follows: GENERAL FUND (101) Revenue 90-190000-14000-1582 Prior Years Balance Expenditure 90-310000-98636-8001 Transfer Out to Info. Tech Total $255,000 $255,000 $ 0 INFORMATION TECHNOLOGY FUND (636) Revenue 18-636113-98101-1701 Expenditures 18-636172-95901-3348 18-636172-95901-3596 18-636172-95901-4101 18-636113-10000-8005 Transfer In from GF $255,000 Professional Services $200,000 Software Rental/Purchase 45,000 Software Expend. Equip. Exp. 10,000 Changes to Fund Equity 255,000 Total $ 0 BE IT FURTHER RESOLVED that $2,431 from the FY 2004 Designated Fund Balance for CRIMP (GL #9407-08000) be appropriated to the Purchasing Division budget for the purchase of file cabinets as follows: GENERAL FUND (101) Revenue 90-190000-14000-1582 Expenditure 12-401200-40010-4100 Prior Years Balance Purchasing - Expend. Equip. Exp. Total $2,431 $2,431 $ 0 Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE sonnowwwwwwsn ammiessigam• OAKLW L. BROOKS PATTERSDN, OAKLAND COUNTY EXECUTIVE COUNTY MICHIGAN DEPARTMENT OF MANAGEMENT AND BUDGET Laurie Van Pelt, Director Wm. Art Holdsworth, Deputy Director a'.J V kLIGLI TO: Members of the Finance Committee Laurie Van Pelt, Director, Management and Budget Art Holdswortb, 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 Third Quarter Report DATE: August 12, 2004 FROM: FY 2004 FORECAST Attached please find the Fiscal Year (FY) 2004 Third Quarter Forecast Report. In total, Fiscal Services forecasts that the County will complete Fiscal Year 2004 with overall favorability of $13,319,910 in General Fund / General Purpose (GF/GP) operations. GF/GP includes all operations except gants, enterprise funds, and internal service funds. This overall favorability, is split between receiving $10759,210 more revenue than anticipated, and expending $2,560,700 less than budgeted. REVENUES Actual GF/GP revenues are 2.87% more than budget or $10,759,210. The majority of the favorability is the result of the following events: GENERAL FUND — INTERGOVERNMENTAL - Favorable: $2,762,700 State Shared Revenue is estimated to be favorable. Revenue sharing is favorable by $3,000,000 partially offset by unfavorable Cigarette Tax Distribution ($181,800) and Sales Tax Inventory Reimbursement ($203,600). Additional Revenue Sharing will be designated for capital projects. GENERAL FUND - CHARGES FOR SERVICES - Favorable: $11,965,710 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 $8,453,800 favorability. Favorability in the Sheriff's Office of $757,000, is due to the • updating of Deputy Patrol Rates and $1,200,000 from the State for housing of Diverted Felons. This is partially offset by unfavorability in revenues ($500,000) from Work Release prisoners. District Court revenues are favorable due to caseload increases for Division U - $502,400 and Division I - $319,500. C. GENERAL FUND — INVESTMENT INCOME — Unfavorable: $4,816,700 This unfavorability results from the continued low interest rates. D. GENERAL FUND —INDIRECT COST RECOVERY — Favorable: $1,750,000 Projected favorability is the result of charges to Grants and Proprietary Funds. EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-2163 • FAX (248) 858-9172 • E. GENERAL PORPOSE'FUNDS — CHARGES FOR SERVICES - Unfv(irable: 1810,000 Less than anticipated Out County Board and Care due to the !delay in startup of the Secure Detention facility and reduced state funds for child care. EXPENDITURES In total, expenditures are estimated to be 0.68% less than budget or $2,560,700. The favorability is related to turnover as a result of the hiring freeze, which was in effect for the first quarter of FY 2004: The hiring freeze was cancelled in the second quarter. In addition to the hiring freeze, capital purchases and travel were also frozen. Favorability is expected due to the administrative leave program. Favorability from turnover is partially offset by increased costs Professional Services at the Cleric/Register . of Deeds related to mortgage activity and costs related to housing of prisoners. The increase in revenue sharing will be designated for capital improvements. Those departments which are projected to be unfavorable at the end of the fiscal year (barring any amendments) include the Sheriff's Office, Clerk/Register of Deeds, and the Non-departmental Appropriations category: A. SHERIFF'S OFFICE — Unfavombility ($1,278,000) is partly due to prisoner housing costs. It has been necessary to house prisoners at other county jails to avoid overcrowding and early release. Also, projected to be unfavorable is the Personnel Controllable category due to recalculations of overtime needs and revised settlement costs for union contract. Please note that this unfavorability is more than offset by revenue favorability in the Sheriff's Office due to the approved rate change for patrol contracts and diverted felon revenue. Amendments are recommended. B. CLERK/REGISTER OF DEEDS —The majority of unfavorabilhy ($351,100) stems from the continued high volume of activity within the Clerk/Registered of Deeds Office, in spite of the current decline in the economy. The professional services contract for document processing is expected to be ($323,000) over budget. Also, internal services are expected to be unfavorable due to increased microfilming ($125,000). Total Salaries and Fringe Benefits are expected to be favorable although overtime is expected to be over budget ($176,000) due to increased number of transactions. Total favorability from Clerk's ' revenue of $8,453,800 more than offsets the unfavorability from expenditures. Amendments are recommended. C. NON-DEPARTMENTAL APPROPRIATION - Unfavorability ($1,154,300) is mostly due to the administrative leave account ($600,000). Favorability from use of administrative leave is still appearing within individual department budgets. Also unfavorable is DTRF Loan Repayment account ($522,000) which is not budgeted. However, funds were reserved in the General Fund in FY 2003 for this purpose. Additional funds will be set aside at year-end close for capital improvements due to the increase in State Revenue Sharing provided no more cuts are made to Revenue Sharing. Dept. Prosecutor - Grant Match Prosecutor - Grant Match Prosecutor - Printing Prosecutor - FA Expend. Equip. Exp. Non-Dept. Grant Match Total 20,000.00 30,479.00 (16,000.00) 16,000.00 (50,479.00) 1.....11CUULC A • OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2004 AMENDMENT ACCOUNT NUMBER ACCOUNT NAME 52nd District Court/Div. IV (Roch. Hills) Expenditures 32-401200-20001-2001 Salaries 32-401200-20001-2074 Fringe Benefits 32-401200-20001-3476 Rent 32-401200-20001-6667 Convenience Copier Total $ (16,400.00) (8,600.00) 23,000.00 2,000.00 IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS I Probate Court-Estates & Mental Health Expenditures 34-403200-40005-2001 Salaries $ (11,600.00) 34-403200-40005-2074 Fringe Benefits (6,000.00) 34-403200-40005-2884 Guardian Review/Adult 7,100.00 34-1n 1 wIn-it000i -6024 IT - CLEMIS I O. 5 0 0 on Total Prosecuting Attorney / Non- Expenditures 41-211000-41600-2872 41-211000-43200-2872 41-211000-41100-3324 41-211000-41700-4100 90-290000-25000-2872 Board of Commissioners / Non-Dept. Expenditures 51-211000-20000-3372 90-290000-25000-3064 $ 80,000.00 (80,000.00) BOC - Public Information Non-Dept. - Legislative Expense Total Drain Commissioner Expenditures 61-211001-10000-3052 61-211001-10000-3088 61-211001-10000-3172 61-211001-10000-3660 61-211001-10000-4172 61-211001-10000-4252 61-311001-98250-8001 Laundry & Cleaning 8,892.00 Licenses & Permits 2,800.00 Membership Dues & Pub. 5,000.00 Stream Gage Program 4,200.00 Materials & Supplies 4,400.00 Office Supplies 3,442.00 Transfer Out (28,734.00) Total REVISED ok.incuuLc REVISED k.k./UPT 1 T onnoniukum FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS , GENERAL FUND/GENERAL PURPOSE (GF/GP) ACCOUNT NUMBER ACCOUNT NAME [GF/GP OPERATIONS - SELF BALANCING AMENDMENTS Clerk / Non-Dept / Children's Village General Fund Revenue 21-140100-11000-0705 Clerk / ROD - Mortgages Expenditure 90-310000-98293-8001 Transfer Out to Juv. Maint. Juvenile Maintenance Fund (293) Revenue 90-430000-98101-1701 Transfer In from GF Expenditure 16-501300-98660-8001 Transfer Out to Radio Comm. Fund General Fund Revenue '- 21-140100-11000-0705 Expenditure 90-310000-98221-8001 Health Fund 90-430000-98101-1701 Transfer In to Health Fund Expenditure 16-215200-75110-4101 Expend. Equip. Exp. . FY 2004 AMENDMENT $ 35,885.00 $ 35,885.00 $ 35,885.00 $ 35,885.00 $ 13,370.00 $ 13,370.00 $ 13,370.00 $ 13,370.00 Clerk / ROD - Mortgages Transfer Out to Health Fund GF/GP OPERATIONS - SELF BALANCING AMENDMENTS Health Fund (221) Revenue 16-201100-33100-1583 Expenditure 16-261200-72500-3544 Public Services Expenditures 17-302200-32500-3604 17-901200-90001-6667 17-802200-80001-3348 17-802200-80001-6039 Prior Years Adj. Health Division - Satellite Centers Total Veterans Svcs - Soldiers' Burial Circuit Court Prob. - Convenience Copier Animal Control - Professional Services Animal Control - IT - Development Total $ 79,900.00 $ 79,900.00 (4,000.00) 4,000.00 (39,000.00) 39,000.00 ACCOUNT NUMBER ACCOUNT NAME , OAKLAND COUNTY, MICHIGAN SCHEDULE A FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2004 AMENDMENT 1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS I Expenditures 35-293-242293-51400-3640 35-293-242293-51400-3344 35-293-242293-62000-3348 16-293-501200-23000-4101 21-210100-10000-6664 21-220100-01000-4252 21-230100-01000-6664 21-240100-11000-3348 21-240100-11000-4252 21-240100-11000-6654 21-240100-11000-6664 21-250100-01000-6664 43-023201-10000-2024 43-023201-10000-2014 43-023301-21400-2024 43-023301-21400-2074 43-023301-21400-3268 43-023301-21400-2002 43-023335-22000-2572 43-023901-44200-2872 12-240000-44200-6664 13-138203-15100-9169 19-221000-10000-2624 19-221000-10000-3292 19-221000-10000-3324 19-221000-10000-3348 19-221000-10000-3844 19-221000-10000-4100 19-221000-10000-6636 19-221000-10000-6675 Circuit Court - State Institutions $ 970,000.00 Circuit Court - Private Institutions - Res. 300,000.00 Circuit Court - Professional Svcs. 30,000.00 Children's Village - Expend. Equip. Exp. 35,885.00 Clerk Admin - Mailroom 6,500.00 County Clerk - Office Supplies 38,900.00 Elections - Mailroom 4,200.00 Clerk/ROD - Professional Svcs. 320,000.00 Clerk/ROD - Office Supplies 10,000.00 Clerk/ROD - Micrographics & Reprod. 125,000.00 Clerk/ROD - Mailroom 60,000.00 Clerk/Jury Commission - Mailroom 30,400.00 Sheriff / Admin. - Salary Adjustments (951,600.00) Snei if{ Adrnil -Fringe Benefits (349,300.00) Sheriff / Corr. Svcs. - Salary Adjustments 951,600.00 Sheriff / Corr. Svcs. - Fringe Benefits 349,300.00 Sheriff / Corr. Svcs. -Outside Co. Pris.Hsing 164,700.00 Sheriff / Corr. Svcs. - Overtime 958,300.00 Sheriff / Corr. Svcs. (Food Svc) - Cont. Svcs. 20,000.00 Sheriff / Tech. Svcs. - Grant Match 135,000.00 Equalization-- Mailroom 50,000.00 Record Retention - Misc. Capt. Outlay 110,000.00 PEDS - Emerg. Sects - Data Proc. Dev. 10,000.00 PEDS - Emerg. Sects. - Personal Mileage 1,500.00 PEDS , Emerg. Sects. - Printing 6,000.00 PEDS - Emerg. Sects. - Professional Svcs 59,500.00 PEDS - Emerg. Sects. - Wrkshps & Mtgs 2,500.00 PEDS - Emerg. Sects. - Expend. Equip. Exp. 20,000.00 PEDS - Emerg. Sects. - IT-Operations 7,232.00 PEDS - Emerg. Sects. - Telephone Comm. 320.00 Total $ 3,475,937.00 SCHEDULE B Expenditures 61-227317-46500-6661 61-311317-98661-8001 Leased Vehicles Transfer Out $ 33,000.00 244,002.00 $ (40,000.00) 40,000.00 $ 33,000.00 244,002.00 $ 277,002.00 $ 33,000.00 244,002.00 $ 277,002.00. OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUND ACTIVITIES ACCOUNT NUMBER ACCOUNT NAME FY 2004 AMENDMENT 'PROPRIETARY FUNDS - SELF BALANCING AMENDMENTS Micrographic Fund (654) Expenditures 21-260100-11000-3184 21-2601 00-1 1000-4172 Drain Equipment Fund (639) Revenues 61-111317-46500-1103 61-111317-46500-8005 Microfilming & Reproductions Materials & Supplies Total Expenditures Vehicle Rental Change in Fund Equity Total Revenue $ (110,054.00) 110,054.00 $ 33,000.00 244,002.00 $ 277,002.00 Motorpool Fund (661) Revenues 13-661001-00010-0595 13-661001-00010-1822 Revenues 13-661001-00010-0635 13-661003-98639-1701 Expenditures 13-661002-00010-3903 13-661002-00010-8005 Printing, Mailing and Conveni Revenues 13-667201-15200-1822 13-667201-15200-1813 13-667301-1 5100-1 029 13-667301-15100-0839 Information Technology Fund Revenues 18-636111-10000-0717 18-636111-10000-0737 Insurance Reserve Revenue Ext. Other Revenue Total Revenues Leased Equipment Transfer In from Drain Equip. Fund Total Revenues Depreciation Change in Fund Equity Total Expenditures ence Copier Fund (667) Ext. - Other Revenue Ext. - Metered Postage Revenue Sublet Repairs Rebill Charges Change in Fund Equity (636) Non-Govt Operations OC Dept. Operations Total $ (35,000.00) 35,000.00 (123,000.00) 123,000.00 3,924.00 21,651.00 $ 25,575.00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUND ACTIVITIES IF • ACCOUNT NUMBER ACCOUNT NAME • FY 2004 AMENDMENT 1PR0PRIETARY FUNDS - SELF BALANCING AMENDMENTS Expenditure 18-636142-15000-4101 Expendable Equipment Total 25,575.00 Expenditures 18-636172-25100-3596 18-636172-25100-3597 18-636113-10000-8005. License Fee Software Support/Maintenance Changes to Fund Equity Total $ 35,928.00 7,186.00 (43,114.00) Expenditures 18-636122-15000-3348 18-636172-24000-3348 18-636113-10000-8005 Professional SenArses -- - Professional Services Changes to Fund Equity Total 250.00 179,000.00 (179,250.00) Info Tech Operations 0L3: 6636 Dept OCA PCA General Fund/General Purpose: Information Technology - Fund 636 Third Quarter FY2004 Amendment SCHEDULE, C_ Current Amended YTD Amended OCA Title Budget Expenditure Annualization Amendment Budget Fund 101 - General Fund 11 101112 65001 Emergency Response & Preparedness Exp $132,550 $112,547 $150,062 $17,512 $150,062 11 210100 01000 County Exec Admin Exp 119,630 90,080 120,106 476 120,106 11 210500 01000 Executive Support Exp. 15,453 . 11,178 14,904 (549) 14,904 11 220100 10000 Auditing Admin Exp 86,849 65,219 86,959 110 86,959 11 250100 20000 Corporation Counsel Exp 86,102 , 65,655 87,540 .- 1,438 87,540 12 240000 41000 Equalization Admin Exp 883,244 ' 708,843 945,124 61,880 945,124 12 401200 40010 Purchasing Admin Exp 49,662 37,871 50,494 832 50,494 12 601200 10001 Fiscal Services Admin Exp 891,509 791,472 1,055,296 163,787 1,055,296 12 701200 34000 Reimbursement Exp 297,645 219,659 292,879 (4,766) 292,879 13 138201 15100 Support Svs Admin Exp 8,454 0 0 (8,454) 0 13 138203 12000 Record Retention & Mail Exp 33,855 26,193 34,924 1,069 34,924 13 138203 15100 Record Retention & Mail Exp 2,389 5,234 6,979 4,590 6,979 13 138502 15100 Materials Mgmt GF Exp 8,436 7,254 9,672 1,236 9,672 14 210000 10000 Facilities Mgt Admin GF Exp 18,684 48,150 64,200 45,516 64,200 14 280000 80003 Facilities Engineering GF Exp 22,856 14,229 18,972 (3,884) 18,972 15 402200 10001 Human Resources Admin Exp 283,346 228,681 304,908 21,562 304,908 17 302200 30001 Veterans Services Admin Exp 59,420 44,696 59,595 175 , 59,595 17 402200 70001 Comm Corrections Admin,F.xp , 0 0 0 0 0 17 402200 70111 Comm Corrections Admin Exp 89,655 75,615 100,820 11,165 100,820 17 ..:11,1-,‘ . 70114 Comm Corrections Admin Exp 17,867 . 21,177 '40 902 11 r115 30,902 17 402200 70200 Comm Corrections Admin Exp 22,512 17,067 22,756 244 22,756 17 402200 70211 Comm Corrections Admin Exp 7;167 - - - 1,11U 10,372 3,205 10,372 17 402200 70221 Comm Corrections Admin Exp 0 0 0 0 0 17 402200 70231 Comm Corrections Admin Exp 9,556 0 0 (9,556) - 0 17 402200 70234 Comm Corrections Admin Exp 31,313 0 0 (31,313) 0 17 402200 70310 Comm Corrections Admin Exp 47,649 . 39,418 52,558 4,909 52,558 17 402200 70317 Comm Corrections Admin Exp 0 5,560 7,414 7,414 7,414 17 501200 50000 MSU Ext OC Admin Exp 120,494 94,623 126,164 5,670 126,164 17 501200 50001 MSU Ext OC Admirj_Exp 0 0 ,, r • 0 - 0 0 17 510200 50219 Natural Science Program 0 0 0 0 0. 17 510200 50249 Natural Science Program 4,778 12,456 16,608 11,830 16,608 17 802200 80001 Animal Control Admin Exp 43,174 33,666 44,888 1,714 44,888 17 901200 , 90001 Circuit Court Probation Exp 61,518. 43,810 58,413 (3,105) 58,413 17 901200 90002 Circuit Court Probation Exp 43,436 30,591 40,788 (2,648) 40,788 17 912000 15000 Med Examiner Exp 137,480 96,067 128,090 (9,390) 128,090 19 210000 10000 Comm & Econ Dev Adm Exp 0 8,028 . 10,704 10,704 10,704 19 210000 11060 Comm & Econ Dev Adm Exp ' 25,046 18,117 24,156 (890) 24,156 19 215000 13500 Waste Resource Expense 25,714 13,077 17,436 (8,278) 17,436 19 221000 10000 Dev & Planning Exp 481,554 319,667 426,222 (55,332) 426,222 19 223000 14062 Marketing & Research Exp 32,879 0 0 (32,879) 0 19 224000 12020 Planning Exp 2,389 1,728 2,304 (85) 2,304 20 200000 11000 Workforce Dev Admin Exp 34,560 146 195 (34,365) 195 21 220100 10000 County Clerk Admin Expenditu 17,834 9,286 12,381 (5,453) 12,381 21 220500 40000 Clerk Vital Statistics Exp 31,418 36,069 48,092 16,674 48,092 21 221000 01000 Clerk Legal Records Exp 21,234 12,845 17,127 (4,107) 17,127 21 230100 31000 Elections Admin Exp 45,009 31,497 41,996 (3,013) 41,996 21 240100 11000 Register of Deeds Admin Exp 455,335 344,840 459,787 4,452 459,787 21 250100 01000 Jury Commission Exp 24,872 17,991 23,988 (884) 23,988 22 221120 01000 Treasurer Admin Exp 392,585 257,085 342,780 (49,805) 342,780 32 201200 20001 DC Div I Admin Exp 299,108 220,316 293,754 (5,354) 293,754 32 205200 20006 DC Div I Probation Exp 11,646 8,424 11,232 (414) 11,232 32 301200 20001 DC Div II Admin Exp 114,971 89,700 119,600 4,629 119,600 32 305200 20006 DC Div ll Probation Exp 6,993 4,188 5,584 (1,409) 5,584 32 401200 20001 . DC Div III Admin Exp 255,659 187,461 249,948 (5,711) 249,948 32 405200 20006 DC Div III Probation Exp 3,401 2,460 3,280 (121) 3,280 32 501200 20001 DC Div IV Admin Exp 218,753 165,563 220,751 1,998 . 220,751 32 505200 20006 DC Div IV Probation Exp 28,567 20,772 27,696 (871) 27,696 34 101200 31100 PC Judicial/ Admin Exp 21,412 24,876 33,168 11,756 33,168 34 101200 31200 PC Judicial/ Admin Exp 41,967 30,357 40,476 (1,491) 40,476 34 101200 40001 PC Judicial/ Admin Exp 9,556 6,612 8,816 (740) . 8,816 34 403200 40001 PC Estates/Mental Hlth Exp 7,295 8,385 11,180 3,885 11,180 34 403200 40005 PC Estates/Mental Hlth Exp 154,001 109,882 146,509 (7,492) 146,509 34 403200 40006 PC Estates/Mental Hlth Exp 1,145 828 1,104 (41) 1,104 35 210000 11000 Judiciai/Admin Exp 9,064 3,455 4,607 (4,457) 4,607 35 220000 11000 Business Oper Exp 101,178 94,127 125,503 24,325 125,503 35 220000 12000 Business Oper Exp 14,931 6,690 8,920 (6,011) 8,920 35 230000 12000 Gen Jurisdiction Exp 9,477 5,991 7,988 (1,489) 7,988 35 230000 21100 Gen Jurisdiction Exp 74,361 54,497 72,663 (1,698) 72,663 Page 1 of 2 - 1.7 Yki General Fund/General Purpose: Info Tech Operations 0L3: 6636 Information Technology - Fund 636 Third Quarter FY2004 Amendment SCHEDULE r. Current Amended YTD • Budget Expenditure 176,483 - 125,254 41,594 30,087 9,456 9,412 4,778 3,456 50,602 35,987 92,072 73,551 - 39,160 , 28,326 61,385 42,923 36,878 26,676 70,141 65,928 12,990 9,396 121,435 88,644 11,845 7,416 31,022 22,440 75,881 59,416 2,389 1,728 7,167 5,184 5,037 4,860 47,554 46,422 44,671 31,699 624,499 440,322 0 3,558 1,111 _2,532 132 6 2,625,408 1,957,268 120 0 92,609 53,981 70,879 52,309 19,804 17,578 4,749 2,842 77,608 55,757 8,183 7,899 176,460 168,622 2,514 0 $148,775 $148,775 $138,521 $138,521 $184,694 535.919 $184,694 $35,919 $35,919 $35,919 $184,694 Dept 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 35 41 4 i 43 43 43 43 51 51 51 51 51 51 61 61 . 90 90 90 OCA Title Gen Jurisdiction Exp Gen Jurisdiction Exp Gen Jurisdiction Exp Gen Jurisdiction Exp Gen Jurisdiction Exp Gen Jurisdiction Exp Court Services Exp Court Services Exp Court Services Exp Court Services Exp Court Services Exp Judicial Support Exp Judicial Support Exp Judicial Support Exp Judicial Support Exp Judicial Support Exp Judicial Support Exp Family Div Admin Exp Family Div Admin Exp Family Div Admin Exp Prosecutor Admin Exp Fiusecutor Admin Exp Sheriffs Office Adm Exp Admin Services Exp Corrective Sys Adm Exp Corrective Sys Satellites al) Commissioners & Admin Exp Research Library Exp Research Library Exp Research Library Exp Law Library Exp Library Board GF Exp General Fund Admin Exp General Fund EC Exp 06030 Information Technology Development 08001 Due to Health Fund 08001 Due to Juvenile Maintenance Fund Amended Annualization Amendment Budget (9,478) 167,005 (1,478) 40,116 3,093 12,549 (170) 4,808 (2,619) 47,983 5,996 98,068 (1,392) 37,768 (4,154) 57,231 (1,310) 35,568 17,763 87,904 (462) 12,528 (3,243) 118,192 (1,957) 9,888 (1,102) 29,920 3,340 79,221 (85) 2,304 (255) 6,912 1,443 6,480 14,342 61,896 (2,406) 42,265 (37,403) 587,096 4,744 2,265 3,376 (132) 0 (15,717) 2,609,691 (120) 0 (20,635) 71,974 (1,134) 69,745 3,633 23,437 (960) 3,789 (3,265) 74,343 2,349 10,532 48,369 224,829 (2,514) 0 (204,468) 21,465 35,919 OCA PCA 230000 21200 230000 22100 230000 23100 230000 24000 230000 25000 230000 31200 242000 11000 242000 41000 242000 42000 242000 43000 242000 44000 243000 11000 243000 28000 243000 32000 243000 33000 243000 ammo 243000 44000 244000 11000 244000 31100 244000 31200 211000 41700 4.r1 23101 10000 23201 20000 23301 20000 23401 42300 211000 10000 231000 53000 231000 53100 231000 53200 232000 53300 233000 53500 211001 10000 231001 35200 290000 25000 310000 98221 310000 98295 Total Fund 101 - General Fund 167,005 40,116 12,549 4,608 47,983 98,068 37,768 57,231 35,568 87,904 12,528 118,192 9,888 29,920 79,221 2,304 6,912 6,480 61,896 42,265 587,096 1,714 3,376 0 2,609,691 0 71,974 69,745 23,437 3,789 74,343 10,532 224,1329 • 0 $11,257,213 68,653,223 $11,404,297 Fund 221 - Health Fund 16 201200 33100 Health Div Admin Exp 16 211200 33100 Health Central Support Exp 16 215200 75110 Jail Health Program Exp 16 220200 67000 Environmental Health Exp 16 231200 33100 Personal & Prey Health Exp 16 233200 46000 C1-(PIS Exp 16 234200 54600 Clinic Exp 16 236200 46000 Field Nursing Exp Total Fund 221 - Health Fund Expenditures 90 430000 98101 01701 Due From General Fund Total Fund 221 - Health Fund Revenues $917,677 $710,812 $947,750 $30,073 $947,750 1,145 828 1,104 . (41) 1,104 1,145 828 1,104 (41) 1,104 103,009 71,825 95,767 (7,242) 95,767 9,556 5,760 7,680 (1,876) 7,680 2,459 2,355 3,140 681 3,140 668 483 644 (24) 644 1,812 . 1,311 1,748 (64) 1,748 $1,034,991 $794,202 51,058,936 $21,465 $1,058,936 21,465 $21,465 Fund 293 - Juvenile Maintenance Fund 16 501200 25001 Childrens Village Admin Exp Total Fund 293 - Juvenile Maintence Fund Expenditure 90 470000 98101 01701 Due from General Fund Total Fund 293 - Juvenile Maintence Fund Revenue Note: Community Corrections programs deleted as of January,2004'. Adjustments for 14 qtr actuals to be completed by journal voucher for 4th qtr FY 04. Page 2 of 2 $43,636 $5,750 $43,636 61,789 (1,271) 61,789 18,552 2,352 18,552 80,487 13,326 80,487 14,543 1,761 . 14,543 47,674 4,431 47,674 1,427 1,427 1,427 22,728 1,808 22,728 2,479 (1,347) 2,479 19,299 (4,402) 19,299 32,243 4,599 32,243 . 19,290 1,349 19,290 18,797 (2,629) 18,797 0 (2,856) 0 19,696 15,034 19,696 11,412 11,412 11,412 3,997 3,885 3,997 4,671 4,671 4,671 0 (67,185) 0 0 (1,539) r, 21,249 21,133 21,249 7,799 7,799 . 7,•99 36,264 (11,588) 36,264 9,803 - 1,479 9,803 1,206 1,206 1,206 123,911 (17,326) 123,911 38,929 2,807 38,929 6,832 6,832 6, 832 o - (1;934) • 0 1,069 (1,431) 1,069 75 (12,501) 75 82,367 6,948 82,367 . 1,233 . 1,233 1,233 13,619 2,177 13,619 0 (28,475) 0 32,014 32,014 32,014 69,984 (17,145) 69,984 23,548 8,523 23,548 47,754 6,531 , 47,754 35,172 (2,507) 35,172 19,565 1,596 19,565 , 41,492. 5,054 41,492 11,750 2,291 11,750 4,619 (2,167) 4,619 13,990 1,366 13,990 72,319 8,129 72,319 39,053 (8,822) 39,053 12,064 (3,187) 12,064 48,385 10,442 48,385 . 28,838 1,819 28,838 4,405 2,041 , 4,405 23,550 4,042 23,550 12,964 1,671 12,964 146,266 (2,317) 146,266 1,698 1,698 1,698 1,380 3,380 3,380 7,694 7,694 7,694 13,897 (3,781) 13,897 25,306 (3,150) . 25,306 - 2,528 ' 2,528 2,528 8,879 8,879 8,879 4,031 - 1,133 4,031 21,917 21,917 21,917 5,913 5,086 5,913 9,627 2,138 9,627 433,796 14,907 433,796 4,417 4,417 . 4,417 General Fund/General Purpose: Information Technology - Telephone Communications Fund 675 Third Quarter FY2004 Amendment SCHEDULE iephone Communications 0L3: 6675 current - Amended YTD Final Amended Dept OCA PCA OCA Title Budget Expenditure Annualization Amendment Budg_et Fund 101 - General Fund 11 101112 65001 Emergency Response & Preparednesr $37,886 $32,727 11 210100 01000 County Exec Admin Exp 63,060 46,342 11 250100 20000 Corporation Counsel Exp 16,200 13,914 12 240000 44200 Equalization Admin Exp 67,161 60,365 12 401200 40010 Purchasing Admin Exp 12,782 10,907 12 601200 10001 Fiscal Services Admin Exp 43,243 35,756 12 601200 26003 Fiscal Services Admin Exp 0 1,071 • 12 701200 34000 Reimbursement Exp 20,920 17,046 13 138502 15100 Materials Mgmt GF Exp 3,826 1,859 14 280000 80003 Facilities Engineering GF Exp 23,701 14,474 15 402200 10001 Human Resources Admin Exp 27,644 . 24,182 15 501200 10001 Empl Relations Admin Exp 17,941 14,468 17 302200 30001 Veterans Services Admin Exp 21,426 14,098 17 402200 70001 Comm Corrections Admin Exp 2,856 0 17 402200 70111 Comm Corrections Admin Exp . 4,662 14,772 17 402200 70114 Comm Corrections Admin Exp 0 8,559 17 402200 70200 Comm Corrections Admin Exp 112 2,998 17 402200 70211 Comm Corrections Admin Exp 0 3,503 17 402200 70231 Comm Corrections Admin Exp 67,185 0 17 4022015- 73234 1.:ditim C.orreclioAdniiii E.4.,----------,- - -1,539 0 _ _ 17 _ 402200_ ,J031()..c.ornm Corrections Admin Exp - 116 15,936 17 402200 70317 Comm Corrections Admin Exp 0 5,849 17 501200 50000 MSU Ext OC Admin Exp 47,852 27,198 17 802200 80001 Animal Control Admin Exp 8,324 7,352 17 802200 80340 Animal Control Admin Exp 0 904 17 901200 90001 Circuit Court Probation Exp 141,237 , 92,933 17 912000 15000 Med Examiner Exp 36,122 29,196 19 210000 13500 Comm & Econ Dev Adm Exp 0 5,124 19 215000 13500 Waste Resource Expense- 1,934 0 19. 215000 13600 Waste Resource Expense 2,500 802 20 200000 11000 Workforce Dev Admin Exp 12,576 - 57 21 210100 01000 Clerk/Reg of Deeds Admin Exp 75,419 61,775 21 240100 11000 Register of Deeds Admin Exp 0 925 21 250100 01000 Jury Commission Exp 11,442 10,214 22 221120 01000 Treasurer Admin Exp 28,475 0 22 221120 10000 Treasurer Admin Exp 0 24,011 32 201200 20001 DC Div I Admin Exp 87,129 52,488 32 301200 20001 DC Div ll Admin Exp 15,025 17,661 32 401200 20001 DC Div III Admin Exp 41,223 35,815 32 501200 20001 DC Div IV Admin Exp 37,679 26,379 34 101200 40002 PC Judicial/ Admin Exp 17,969 14,674 34 403200 40005 PC Estates/Mental Hlth Exp 36,438 31,119 35 220000 11000 Business Oper Exp 9,459 8,813 35 220000 12000 Business Oper Exp 6,786 3,464 35 230000 11000 Gen Jurisdiction Exp 12,624 10,492 35 230000 21100 Gen Jurisdiction Exp 64,190 54,239 35 242000 41000 Court Services Exp 47,875 29,290 35 242000 42000 Court Services Exp 15,251 9,048 35 242000 43000 Court Services Exp 37,943 36,289 35 243000 33000 Judicial Support Exp 27,019 21,628 35 244000 11000 Family Div Admin Exp 2,364 3,304 35 244000 31100 Family Div Admin Exp 19,508 17,663 . 35 244000 31200 Family Div Admin Exp 11,293 9,723 41 211000 41100 Prosecutor Admin Exp 148,583 109,699 41 211000 41400 Prosecutor Admin Exp 0 1,274 41 211000 41900 Prosecutor Admin Exp 0 2,535 41 211000 44100 Prosecutor Admin Exp 0 5,770 43 23101 10000 Sheriffs Office Adm Exp 17,678 10,422 43 23201 10000 Admin Services Exp 28,456 18,979 43 23301 21400 Corrective Sys Adm Exp 0 1,896 43 23401 21700 Corrective Svs Satellites Exp 0 6,659 43 23601 30000 Patrol Services Exp 2,898 3,023 43 23601 31190 Patrol Services Exp 0 16,438 43 23601 32100 Patrol Services Exp 827 4,434 43 23601 33000 Patrol Services Exp 7,489 7,220 43 23901 40000 Technical Sys Adm Exp 418,889 325,347 43 23901 41000 Technical Sys Adm Exp 0 3,313 Page 1 of 2 Dept OCA PCA OCA Title 43 23901 43100 Technical Sys Mm Exp 43 23901 44600 Technical Sys Adm Exp 43 23901 45000 Technical Sys Adm Exp 51 211000 10000 Commissioners & Admin Exp 51 231000 53000 Research Library Exp 51 232000 53300 Law Library Exp 61 211001 10000 General Fund Admin Exp 61 231001 35200 General Fund EC'Exp Total Fund 101 - General Fund Fund 221 - Health Fund 16 201200 33100 Health Div Admin Exp 16 211200 33100 Health Central Support Exp 16 212200 32100 Health Laboratory Eq) 16 213200 32200 Health X-Ray Exp 16 214200 33100 Central Health Services Exp 16 220200 67000 Environmental Health Exp 16 231200 33100 Personal & Prey Health Exp 16 232200 74000 Dental Services Exp 16 233200 46000 CHPIS Exp 16 234200 54600 Clinic Exp • 16 235200 54406 -TB ControfEiu --- 16 236200 41100-Field 16 237200 42300 Hearing & Vision Exp 16 237200 42400 Hearing & Vision Exp 16 239200 43100 Services to the Aging Exp 16 245200 71200 Assurance and Advocacy 16 261200 72500 Substance Control Ecp Total Fund 221 • Health Fund $84.291 84,291 General Fund/General Purpose: information Technology - Telephone Communications Fund 675 Third Quarter FY2004 Amendment 131 ephone Communications 0L3: 6675 SCHEDULED _ current Amended YTD Final Amended •Budget Expenditure Annualization Amendment Budget 0 7,706 _ 10,275 10,275 10,275 33,249 30,617 40,822 7,573 40,822 205 1,007 1,343 1,138 1,343 21,733 15,379 20,505 (1,228) 20,505 11,563 9,856 13,141 1,578 13,141 11,916 10,524 14,031 2,115 14,031 46,188 40,526 , 54,034 7,846 54,034 1,440 0 ' 0 (1,440) 0 $2,039,030 $1,614,030 $2,152,040 $113,010 $2,152,040 $373,365 $30,813 $41,084 ($332,281) $41,084 0 16,937 22,583 22,583 22,583 0 4,757 6,342 6,342 6,342 0 1,544 2,059 2,059 2,059 0 1,033 1,377 1,377 1,377 0 68,752 91,669 91,669 91,669 0 3,999 5,332 5,332 5,332 0 1,549 2,066 2,066 2,066 0 15,332 20,442 20,442 20,442 0 23,197 30,930 30,930 30,930 - 0 3,992 5,323 5,323 5,323 0 64,847 86,463 86,463 86,463 0 2,265 3,021 3,021 3,021 0 1,022 1,362 1,362 1,362 0 2,550 3,400 3,400 3,400 0 1,549 2,066 2,066 2,066 0 2,486 3,315 3,315 3,315 $373,366 $246,626 $328,834 ($44,531) $328,834 Fund 293 - Juvenile Maintenance Fund 16 501200 25001 Childrens Village Admin Exp Total Fund 293 - Juvenile Maintence Fund Total Telephone Communications 6675 $70,033 $63,218 $84,291 $14,258 $70,033 $63,218 $84,291 $14,258 $2,482428 $1,923,873 $2,565 165 82 737 . Note: Community Corrections programs deleted as of January,2004. Adjustments for 1-3 qtr actuals to be completed by journal voucher for 4th qtr FY 04. Page 2 of 2 ACCOUNT NUMBER ACCOUNT NAME SCHEDULE E FY2004 AMENDMENT OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS , GENERAL FUND ACTIVITIES !GENERAL FUND - SELF BALANCING AMENDMENTS Fund 101 Printing 6666 Expense 11-101112-65001-6666 12-240000-44100-6666 12-615200-28000-6666 12-622200-26003-6666 12-701200-34000-6666 13-131002-00001-6666 13-138203-15100-6666 15-402220-41300-6666 16-121000-10000-6666 17-402200-70310-6666 17-501200-50000-6666 17-501200-50400-6666 17-501200-50800-6666 17-510200-50224-6666 17-802200-80001-6666 17-802200-80400-6666 17-901200-10001-6666 17-901200-90001-6666 19-215000-13500-6666 19-221000-10000-6666 19-222000-10000-6666 19-225000-10000-6666 21-210100-01000-6666 21-220500-01000-6666 22-221120-01000-6666 32-201200-20001-6666 32-205200-20006-6666 32-405200-20006-6666 35-210000-11000-6666 35-220000-11000-6666 35-230000-11000-6666 35-230000-21100-6666 35-230000-22100-6666 35-230000-24000-6666 35-230000-31100-6666 Emergency Response & Preparedness Adm. Equalization Adm. M iutii iay Fiscal Servigeb-Cantral*Services - Reporting Fiscal Services Central Services - Planing Reimbursement - Adm. Central Services - Adm. Record Retention & Mail Room Selection & Placement - General Staffing Human Service Adm. Community Corrections Adm. - Step Forward MSU Extention Adm. MSU Extention Adm. - 4-H Youth MSU Extension Adm. - Ground Water Natural Science Program - Master Woodland Animal Control Adm. Animal Control Adm. - Road Patrol Circuit Court Probation Adm. Circuit Court Probation - Pontiac Supervision Waste Resource - Solid Waste Development & Planning - Adm. Economic Dev Financial Services - Adm. Business Development Adm. Clerk Register of Deeds Adm. - Court Records Clerk Vital Statistics - Court Records Treasurer Adm. District Court Division I Adm. District Court Division I - Probation District Court Probation Judicial Adm. Business Operations Adm. General Jurisdiction Adm. General Jurisdiction - General Judges General Jurisdiction - Assignment General Jurisdiction - Jury Operations General Jurisdiction - Family Judges $ (19,634.00) (7,786.00) (5,967.00) (5,412.00) (13,305.00) (1,180.00) (1,784.00) (7,385.00) (3,708.00) (3,909.00) (867.00) (4,653.00) (759.00) (1,420.00) (1,083.00) (608.00) (3,764.00) (1,260.00) (850.00) (851.00) (555.00) (1,659.00) (3,666.00) (822.00) (900.00) (870.00) (721.00) (1,956.00) (1,877.00) (4,695.00) (4,360.00) (5,630.00) (10,776.00) (8,889.00) (612.00) 91° ACCOUNT NUMBER ACCOUNT NAME SCHEDULE E FY2004 AMENDMENT OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND ACTIVITIES !GENERAL FUND - SELF BALANCING AMENDMENTS Fund 101 35-242000-41000-6666 35-242000-43000-6666 35-243000-11000-6666 35-243000-44000-6666 43-023201-10000-6666 51-211000-10000-6666 51-233000-53500-6666 61-211001-10000-6666 61-211001-35200-6666 11-210100-01000-6666 11-210500-01000-6666 12-101200-10001-6666 12-240000-44200-6666 12-601200-10001-6666 12-622200-10001-6666 12-701200-30000-6666 12-701200-31000-6666 14-210000-10000-6666 15-402200-10001-6666 15-501200-53500-6666 15-520200-53500-6666 17-402200-70001-6666 17-402200-70111-6666 17-501200-50320-6666 17-501200-50500-6666 17-901200-90002-6666 19-224000-10000-6666 21-210100-11000-6666 21-221000-01000-6666 21-230100-01000-6666 21-240100-11000-6666 21-250100-01000-6666 21-250100-40000-6666 22-221120-24000-6666 Court Services - Casework Court Services - Youth Assistance Judicial Support Adm. Judicial Support - Adoptions - - Sheriff - Adm.-Services- — — --- Commissioners - Board Adm. Library Board Adm. General Fund Adm. - Drain Adm. General Fund - Drain Adm.- Soil Erosion County Executive Adm. Executive Support - General Exp. Management & Budget Adm. Equalization Adm. Central Support Fiscal Services Adm. Fiscal Services Central Services Adm. Reimbursement - Circuit Court Reimbursement - Family Court Facilities Management Adm. Human Resources Adm. Employee Relations Benefits Employee Benefits Community Corrections Adm. Community Corrections PTS Adm. MSU Adm.- General Horticulture MSU Adm. Food & Nutrition Circuit Court Probation - Troy Supervision Planning - Adm. Clerk Register of Deeds Adm. - Land Records Clerk Legal Records - Court Records Management Elections Adm - Court Records Management Register of Deeds Mm - Land Records Management Jury Commission - Court Records Management Jury Commission - General Services Treasurer Adm. - Investments (1,302.00) (1,600.00) (2,179.00) (744.00) (8,874.00) (1,433.00) (2,805.00) (5,106.00) (859.00) (159,075.00) 2,190.00 21,546.00 1,214.00 7,776.00 6,995.00 3,776.00 11,058.00 3,393.00 2,088.00 1,007.00 1,856.00 10,727.00 1,952.00 1,107.00 1,304.00 1,133.00 1,245.00 3,919.00 1,896.00 2,837.00 2,938.00 7,985.00 9,740.00 1,459.00 2,107.00 ACCOUNT NUMBER ACCOUNT NAME SCHEDULE E FY2004 AMENDMENT OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2004 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND ACTIVITIES )GENERAL FUND - SELF BALANCING AMENDMENTS Fund 101 32-301200-20001-6666 32-401200-20001-6666 32-501200-20001-6666 41-6u52G0-20606-G666 34-403200-40005-6666 35-242000-11000-6666 35-243000-33000-6666 35-244000-11000-6666 35-244000-31100-6666 41-211000-41100-6666 41-211000-41700-6666 41-211000-45000-6666 District Court Division II - Adm. District Court Division ill - Adm. District Court Division IV - Adm. District Court Division IV - Probation Probate Court/Mental Health - Probate Services Court Services - Adm. Judicial Support - Juvenile Support Services Family Division - Adm. Family Division - Family Judicial Prosecutor Adm. Prosecutor Adm. - General Prosecution Prosecutor Adm. - Case Records 1,585.00 2,947.00 2,080.00 9,681.00 5,045.00 2,779.00 3,649.00 1,096.00 6,950.00 6,254.00 2,310.00 159,075.00 Change in Fund Equity 0.00 KZ V OF OAKLAND QUARTER REPORT OSE REVENUE AND BY DEPARTMENT COUNTY FY 2004 THIRD GENERAL FUNDIGENERAL PURP SUMMARY EXPENDITURES FY 2004 ADOPTED BUDGET BUDGET AS AMENDED FY 2004 FORECAST AMOUNT FAVORABLE/ fUNFAVORABLE 1 PERCENT SUB-TOTAL GENERAL FUND $ 335,857,138.00 $ 338,199,795.31 $ 349,769,005.31 $ 11,569,210.00 3.42% $ 13,597,419.00 7,485,685.00 0.00 ..$21,083,104.00 $ 3,503,694.00 $ 13,597,419.00 $ 13,597,419.00 5 0.00% 7,553,619.00 6,743,619.00 (810,000.00) -10.72% 0.00 0.00 0.00% _ $21t151,038:00 ..$20,341,038:00 _ ($810,000.0) -3.83% $ 15,056,742.84 $ 15,056,742.84 $0.00 0.00% 5_374,407,576.15 $ 385,166,786.15 $ 10,759,210.00_ 2.87% 41,191,879.00 14,673,407.00 5,290,394.00 $ 61,155,480.00 $ 45,409,306.73 15,007,993.40 5,439,183.38 $ 85,856,483.51 $ 45,112,006.73 14,495,393.40 5,124,383.38 64,731,783.51, $ 297,300.00 512,600.00 314,800.00 $ 1,124,700.00 0.65% 3.42% 5.79% 1.71% LAW ENFORCEMENT Prosecuting Attorney Sheriff TOTAL LAW ENFORCEMENT 4.`• 16,599,189.00 _104,275,832.00 $ 120,875,021.00 17,647,731.88 107 405 801 39 $ 125,053,533.27 17,115,731.88 532,000.00 108,683,801.39 (1,278,000.001 $ 125,799,533.27 $ (748,000.00) -0.60% 3.01% -1.19% 0.86% 5.57% 0.00% 0.20% 4.64% 2.10% 1.04% 6.86% 0.00% 277% 1.11% REVENUES GENERAL FUND Taxes Federal Grants Intergovernmental Indirect Cost Recovery Charges for Services Investment Income Other Revenues Transfers $ 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 $ 214,129,000.00 1,420,532.00 29,590,812.00 7,364,054.00 72,633,721.00 6,033,200.00 581,354.31 $ 214,129,000.00 $ 1,278,132.00 32,353,312.00 9,114,054.00 84,599,431.00 1,216,500.00 631,254.31 8,447,322.00 (142,400.00) 2,762,700.00 1,750,000.00 11,985,710.00 (4,816,700.00) 49,900.00 6,047,322.00 6,447,322.00 0.00% 9.34% 16.47% 8.58% GENERAL PURPOSE FUNDS Intergovernmental Charges for Services Other Revenues 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 GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Drain Commissioner TOTAL GENERAL GOVERNMENT 11,655,734.00 12,089,045.02 3,395,174.00 3,584,181.00 2,813,741.00 2,873,018.21 2,476,445.00 2,508,958.95 3,810,124.00 5,874,108.06 $ 24,151,218.00 26,909,309.24 12,440,145.02 (351,100.00) -2.90% 3,326,981.00 237,200.00 6.66% 2,719,616.21 153,400.00 5.34% 2,480,558.95 48,400.00 1.93% 5,874,108.06 - 0.00% $ 26,821,409.24 $ 87,900.00 0.33% COUNTY EXECUTIVE County Executive Admn. Management and Budget Central Services Facilities Management Human Resources Human Services Public Services Community & Economic Day. Workforce Development TOTAL COUNTY EXECUTIVE TOTAL DEPARTMENTS NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS TOTAL GOVERNMENTAL EXPENDITURES $ 7,551,492.00 19,182,120.00 2,358,802.00 1,543,838.00 4,559,427.00 56,638,500.00 13,943,816.00 6,028,104.00 1,106,880.00 $ 112,908,979.00 $ 319,090,698.00 $ 41,353,238.00 $ 360,443,936.00 7,607,787.83 $ 7,557,787.83 $ 50,000.00 20,698,329.92 19,544,529.92 1,153,800.00 2,428,513.49 2428,513.49 1,552,962.89 1,549,862.89 3,100.00 4,882,462.29 4,855,762.29 226,700.00 57,805,049.60 56,593,049.60 1,212,000.00 14,394,588.00 14,245,289.00 149,300.00 8,812,439.36 6,158,939.36 453,500.00 1,106,880.00 1,106,880.00 _ • $ 117,088,994.38 $ 113,840,694.38 $ 3,248,400.00 $ 334,908,320.40 5 331,193,320.40 $ 3,715,000.00 $ 39,499,255.75 $ 40,653,555.75 5(1,154.300.00) -2.92% $ 374,407,576.15 $ 371,846,876.15 $ 2,560,700.00 0.68% General Fund/General Purpose Favorable/(Unfavorable) 13 319 910.00 13,319 910.00 0) COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT REVISED $ 6,677,364.00 $ 6,677,364.00 $ 45,067.00 161,462.51 179,014.00 211,178.11 ------- ---------- — $ 6,901,445.00 $ 7,050,004.62 $ 6,379,964.00 $ 90,662.51 199,078.11 ------- -- 8,669,704.82 $ 297,400.00 4.45% Turnover. 70,800.00 43.85% Fav special projects discontinued, Professional Svcs, Personal Mileage, Expendable Equipment, and Office Supplies. 12,100.00 5.73% Fay. CLEMIS. 380,300.00 5.39% $ 2,535,501.00 $ 2,590,677.57 $ 2,192,277.57 $ General Jurisdiction Division Controllable Personnel Controllable Operating $ 2,016,386.00 $ 2,036,359.00 $ 5,700,871.00 9,287,393.61 1,992,059.00 $ 9,237,393.61 Non-Controllable Operating 2,169,799.00 2,333,982.60 2,333,962.60 0.00% $21,867,677.00 $ 22,110,909.33 $ 22,685,709.33 $ (574,800.00) -2.60% $22,677,084.00 $ 22,726,591.00 $ 21,155,391.00 $ 1,571,200.00 ., 14,190,152.00 17,900,534.43 19,181,534.43 (1,281,000.00) 4,324,443.00 4,782,181.30 4,775,081.30 7,100.00 8.91% -7.18% 0.15% 08/18/2004 ADOPTED BUDGET -------------- Judicial Administration Controllable Personnel Controllable Operating Non-Controllable Operating AMOUNT AMENDED FY 2004 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Business Division Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,161,255.00 $ 2,161,255.00 $ 43,200.00 46,013.68 331,046.00 383,408.89 1,787,455.00 $ 21,413.68 383,408.89 373,800.00 24,600.00 17.30% Turnover. 53.48% Fav equip. repairs & mairt, and office supplies. 0.00% 398,400.00 15.38% 43,400.00 2.13% Turnover. 50,000.00 0.54% Fay, primarily due to Atty. Fees Mediation, Defense Atty Fees, Court Transcripts, paritally offset ,by increased Juror Fees & Mileage, Increased use of court reported services, and postage mailing permit. $ 9,887,056.00 $ 13,657,715.21 $ 13,564,315.21 $ 93,400.00 0.68% Family Division/Juvenile Maint Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $11,822,079.00 $ 11,851,613.00 $ 10,995,013.00 $ 8,401,014.00 8,405,664.63 9,832,064.83 1,644,584.00 1,853,631.70 1,858,631.70 (5,000.00) 7.23% Turnover. ; -18.97% Unfav. prirnarily due to increasing cost of Private Institutions - Residential ($300,000) and State InstIt'Alons ($970,000), Professional Svcs. Of ($79,800), as well as Fees - Guardian Ad Litem ($120,000) . A budget amendment is recommended, -0.27% Unfav. dut, to increased usage in Convenience Copier. 856,600.00 (1,426,400.00) $41,191,879.00 $ 45,409,308.73 $ 45,112,008.73 $ 297,300.00 0.65% Non-Controllable Operating 440,639.00 482,986.76 482,986.76 0.00% 175,800.00 (70,800.00) (1,600.00) 90,000,00 6.04% - Turnover. (18,900.00) -3.52% - Unfav. due largely to Property Taxes increased, Defense Atty Fees, & Interpreter Fees, offset by fay juror fees & mileage, and Heat, Light, Gas, & Water. A budget amendment is recommended. Unfav print shop and copier due to increasing case load and new twsps. A budget (1,000.00) -0.46% amendment is recommended. 70,100.00 3.12% 08/18/2004 REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 78,061.00 $ 54,300.00 District Court Administration Controllable Personnel Controllable Operating Non-Controllable Operating 60,100.00 43.50% - Turnover. 16,000.00 22.76% Fay. Due to visiting judge, court reporter svcs, and travel and conference. 0.00% $ 138,161.00 $ 138,161.00 $ 70,300.00 70,300.00 $ 208,461.00 $ 208,461.00 $ 132,361.00 $ 76,100.00 36.51% Division 1 - Novi Controllable Personnel Controllable Operating $ 3,449,260.00 $ 3,449,260.00 $ 3,284,960.00 918,675.00 919,082.43 887,882.43 164,300.00 4.76% - Turnover. 31,200.00 3.39% - Fav. due largely to Bank Charges, Training & Psych & Med Exam, Office Supplies, and Juror Fees and Mileage. $ 4,808,574.00 $ 4,851,329,19 8 4,655,829.19 8 195,500.00 1 4.03% Total Division 1 - Novi Division 2 - Clarkston Controllable Personnel Controllable Operating Non-Controllable Operating Total Division 2- Clarkston Division 3 - Rochester Hills Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,440,193.00 $ 1,491,012.00 $ 1,401,012.00 $ 534,851.00 536,831.79 655,731.79 218,222.97 161,365.00 217,222.97 2,136,409.00 $ 2,245,088.76 $ 2,174,968.76 $ $ 3,183,545.00 $ 3,266,772.00 $ 3,090,972.00 $ .624,015.00 629,363.00 700,163.00 748,121.00 810,328.13 811,928.13 • 5.38% - Turnover:i. -11.25% - Unfav. di, a to largely to Rent, Defense Atty. Fees, Utilities, & Juror Fees & Mileage, paritially offset by Travel & Conference, & Office Supplies. A budget amendment is recommended. -0.20% - Unfav. duct to Convenience Copier. A budget amendment is recommended. $ 4,555,681.00 $ 4,706,463.13 4,603,063.13 $ 103,400.00 2.20% Division 4- Troy Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,110,835.00 $ 2,110,835.00 $ 2,063,035.00 8 • 529,558.00 630,052.59 510,152.59 324,089.00 355,985.73 355,985.73 47,600.00 2.26% - Turnover' 19,900.00 - Fay. due lo Training Psych & Med. Exam, Office Supplies, partially offset by Juror Fees & _ 3.76% Mileage, and Defense Ally Fees. 0.00% 2.25% $ 2,984,282.00 $ 2,996,673.32 $ 2,929,173.32 $ 87,500.00 Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 10,321,794.00 $ 10,455,840.00 $ 9,918,040.00 2,877,399.00 2,885,829.01 2,708,229.81 1,674,214.00 1,888,523.59 1,869,123.59 14,873,407.00 $ 15,007,993.40 $ 14,495,393.40 $ 537,800.00 4 5.14% (22,600.00) -0.84% (2,600.00) -0.14% 512,600.00 3.42% Ic- $1,912,681.00 $1,912,681.00 $1,809,981.00 $ 16,134.45 16,534.45 102,700.00 (400.00) (10,500.00) 289,206.00 362,247.59 372,747.59 11.36% - Turnover. -0.96% - Unfav. Due to Guardian Review/Adult. Med. Svcs. Guardianship, and Med. Svcs. Probate Exams. A budget amendment is recommended. $2,201,887.00 $2,291,063.04 $2,199,263.04 $ 91,800.00 4.01% $2,022,690.00 $2,022,690.00 $1,792,990.00 $ 229,700.00 654,981.00 695,542.52 702,242.52 (6,700.00) 410,836.00 429,887.82 429,887.82 0.00% - Judicial/Administration Controllable Personnel Controllable Operating Non-Controllable Operating Estates/Mental Health Controllable Personnel Controllable Operating Non-Controllable Operating 5.37% - Turnover. 0.00% Unfav due largely to Membership Dues & Publications, and Personal Mileage. A budget amendment is recommended. -2.90% - Unfav due largely to CLEMIS charges. A budget amendment is recommended. REVISED ; v ' f COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT +. EXPLANATION OF SIGNIFICANT VARIANCES $3,088,507.00 $3,148,120.34 $2,925,120.34 $ 223,000.00 7.08% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $3,935,371.00 $3,935,371.00 $3,602,971.00 $ 332,400.00 654,981.00 711,676.97 718,776.97 (7,100.00) 700,042.00 792,135.41 802,635.41 (10,500.00) 8.45% -1.00% -1.33% $5,290,394.00 $5,439,183.38 $5,124,383.38 $ 314,800.00 5.79% 08/18/2004 47 ADOPTED BUDGET AMENDED BUDGET FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating $ 2,632,802.00 $ 2,632,802.00 $ 812,561.00 1,783,384.29 2,532,802.00 $ 1,651,384.29 100,000.00 132,000.00 Non-Controllable Operating Transfer Out 1,785,467.00 1,863,186.59 1,863,186.59 0.00% 0.00% $ 5,230,830.00 $ 6,279,372.88 $ 6,047,372.88 $ 232,000.b0 3.69% $ 7,677,772.00 $ 7,677,772.00 $ 7,407,772.00 $ 270,000.00 3.52% Warrants Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,241,498.00 $ 2,758.00 2,241,498.00 $ 2,758.00 2,241,498.00 $ 2,758.00 0.00% 0.00% 0.00% Appellate Controllable Personnel Controllable Operating Non-Controllable Operating Department Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out 0.00% 2.08% 0.00% 0.00% 2.07% 2.80% 7.70% 0.00% 0.00% Turnover REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY 010.0.n•••n••••nn*•••nn•••••n••.•n•••••n•••n•n•••••••••nn 3.80% Turn6ver 7.40% Fav. Court Transcripts $6,000, Expert Witness Fees & Mileage $10,000, Extradition Expense $50,000, Filing Fees $10,000, Microfilming & Reproduction $10,000 and Witness Fees and Mileage $20,000 due to case requirements: Litigation Controllable Personnel Controllable Operating Non-Controllable Operating $ 7,626,900.00 $ 49,824.00 1,048.00 7,626,900.00 $ 49,824.00 1,048.00 7,366,900.00 $ 260,000.00 39,824.00 10,000.00 1,048.00 3.41% 20.07% 0.00% Turnover Fay. Personal Mileage $ 2,244,256.00 $ $ 1,439,040.00 $ 7,291.00 $ 1,446,331.00 $ $ 13,940,240.00 $ 872,434.00 1,786,515.00 2,244,256.00 $ 1,439,040.00 $ 7,291.00 1,446,331.00 $ 13,940,240.00 $ 1,843,257.29 1,864,234.59 2,244,256.00 $ 1,409,040.00 $ 30,000.00 7,291.00 1,416,331.00 $ 30,000.90 13,550,240.00 $ 390,000.00 1,701,257.29 142,000.00 1,864,234.59 $ 16,599,189.00 $ 17,647,731.88 $ 17,115,731.88 $ 532,000.00 3.01% ==== 08/18/2004 ? COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE REVISED Corrective Services Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 3,847,658.00 $ 22,466,655.00 6,862,221.00 6,288,328.00 $ 35,617,204.00 $ 3,852,014.38 $ 22,699,072.00 7,752,335.48 . 6,679,320.33 8,295.00 $ 37,139,022.81 $ 23,480,072.00 $ (781,000.00) 7,937,035.48 (184,700.00) 0.00% 0.00% $ 14,794,398.00 363,868.00 999,917.00 $ 16,158,183.00 $ 29,169,096.00 $ 14,828,824.00 404,684.34 1,003,060.00 $ 16,236,568.34 29,370,362.00 Controllable Operating Non-Controllable Operating Transfer Out 225,536.00 4,411,617.00 722,187.94 4,527,960.07 92,825.00 722,187.94 4,404,160.07 92,825.00 0.00% 2:73% 0.00% 123,800.00 Fay. charges from Sheriff Aviation Fund 221,800.00 2.19% - Fay. Salaries $171,800, Fringes $166,200 and Hot OT $2,800 offset by Unfav. OT ($119,000). (135,000.00) -10.65% Unfav. Grant Match Line Item..A budget amendment is requested. 0.00% 0.00% 08/18/2004 AP -1.43% -2.19% 0.81% 0.00% ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriff's Office Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,442,003.00 87,074.00 1,110,562.00 $ 1,442,003.00 114,373.78 1,112,446.00 $ 1,516,803.00 $ (74,800.00) 114,373.78 1,112,446.00 -5.19% - Vacant positions filled by longer term employees. 0.00% 0.00% Administrative Services Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,639,639.00 $ 2,491,619.00 805,929.00 550,110.00 $ 2,668,822.78 $ 2,491,619.00 810,153.38 550,242.00 $ 2,743,622.78 $ (74,800.00) -2.80% $ 2,473,419.00 $ 18,200.00 810,153.38 550,242.00 0.73% 0.00% 0.00% Fay. Salary: $ 3,833,814.38 $ 18,200.00 0.47% -3.44% - Fay. Salary $43,100 offset by Unfav. OT ($964,100), Hot OT ($186,300) and Fringes($68,700 as a result of Jail overcrowing. Forecast assumes a reallocation of retroactive salary appropriation (Union Settlements). -2.38% - Unfav. Outside County Prisoner Housing ($164,700) and Contracted Services (Prisoners Meals $20,008). A bud,.tet amendment is requested. 6,679,320.33 8,295.00 38,104,722.81 $ (965,700.00) -2.60% Corrective Services-Satellites Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out Patrol Services Controllable Personnel $ 16,003,724.00 $ (1,174,900.00) 327,484.34 1,003,060.00 $ 28,738,962.00 $ 631,400.00 -7.92% Unfav. Salary & Fringes ($1,056,400), Hol OT ($81,400) and OT ($37,100) offset by Revenues from Southfield $515,900 and Board and Care Work Release $1,291,200. Fay. Equip. Repairs $34,400, Custodial Supplies $32,200. 2.15% - Fay. Salaries $228,400, Fringes $73,800 and OT $401,200 offset by Unfav. Ho!. OT ($72,000). 77,200.00 19.08% 0.00% 0.00% $ 17,334,268.34 $ (1,097,700.00) -6.76% 33,958,135.01 $ 755,200.00 2.18% Technical Services Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 33,806,249.00 $ 10,130,728.00 689,908.00 1,386,263.00 $ 12,206,899.00 $ 80,494,499.00 9,034,636.00 14,746,797.00 $ 34,713,335.01 $ 10,142,671.00 1,267,104.07 1,386,263.00 12,796,038.07 80,974,551.00 11,070,838.99 15,259,291.40 101,120.00 $ 9,920,871.00 $ 1,402,104.07 1,386,263.00 $ 82,133,851.00 $ 11,313,338.99 15,135,491.40 101,120.00 (1,159,300.00) (242,500.00) 123,800.00 $ 12,709,238.07 $ 86,800.00 0.68% COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 104,275,832.00 $ 107,405,801.39 $ 108,883,801.39 $ (1,278,000.00) -1.19% 1 08/18/2004 REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE: PERCENT EXPLANAMN OF SIGNIFICANT VARIANCES Administration Controllable Personnel $ 614,076.00 $ 614,076.00 $ 605,276.00 $ 8,800.00 1.43% Turnover. Controllable Operating 52,350.00 52,394.24 46,594.24 5,800.00 11.07% Fay. Due to discontinuation of Binding expense, and reduced Travel and Conference, partially offset by printing County Directory. Non-Controllable Operating 184,546.00 191,843.77 198,343.77 (6,500.00) -3.39% Unfav. mail room due to increased volume of business activity. A budget amendment Is recommended. • Transfers Out - - - - 0.00% $ 850,972.00 $ 858,314.01 $ 850,214.01 $ 8,100.00 0.94% County Clerk (Vital Slats & Legal Rees) Controllable Personnel $ 4,257,976.00 $ 4,257,976.00 $ 3,938,576.00 $ 319,400.00 7.50% Turnover. Controllable Operating 198,578.00 199,180.74 238,080.74 (38,900.00) -19.53% Unfav. primarily due to increased usage of office supplies, and Equipment 1 Repairs and Maintenance, partially offset by reduction in use of Court Transcripts. A budget amendment is recommended. Non-Controllable Operating 568,808.00 869,453.25 873,253.25 (3,800.00) -0.44% Unfav. due to Convenience Copier. A budget amendment is recommended. Transfers Out - - - . - 0.00% $ 5,025,360.00 $ 5,328,609.99 $ 5,049,909.99 $ 276,700.00 5.19% Elections Controllable Personnel $ 464,097.00 $ 464,097.00 5 459,997.00 $ 4,100.00 0.88% Turnover. Controllable Operating 585,300.00 589,224.00 578,824.00 10,400.00 1.77% Fav. due to Election Supplies, and Fees Per Diem, partially offset by office supplies. Non-Controllable Operating 108,728.00 - 169,411.60 173,611.60 (4,200.00) -2.48% Untav. Mall Room In relation to election year activity. A budget amendment is recommended. , Transfers Out 0.00 - - - . 0.00% $ 1,158,125.00 1,22.2,732.60 $ 1,212,432.60 $ 10,300.00 0.84% Register of Deeds Controllable Personnel $ 2,238,528.00 $ 2,238,528.00 $ 2,327,028.00 $ (88,500.00) -3.95% Overtime due to !net-Laser filings. A budget amendment is recommended': Controllable Operating 1354,371.00 1,354,371.00 1,683,571.00 (329,200.00) -24.31% Professional Svcs. h nr optical scanning related to mortgage and refinance activity. See revenue offs,it. A budget amendment is recommended. Non-Controllable Operating . 933,509.00 957,808.00 1,149,606.00 (191,800.00) -20.02% Unfav. Micrographics-and Nall Room, both related to increased mortgages, & refinanue at:Ilvity. A budget amendment Is recommended. Transfers Out - - - - 0.00% $ 4,528,408.00 $ 4,550,705.00 $ 5,160,205.00 $ (609,500.00) -13.39% Jury Commission Controllable Personnel Controllable Operating Non-Controllable Operating $ 14,551.00 $ 14,551.00 5 11,151.00 $ 3,400.00 23.37% Turnover. 2,384.00 2,384.00 12,084.00 (9,700.00) -406.88% Unfav Postage on return questionnaires, and professional services. A budget amendment is recimmended. 77,934.00 113,748.42 144,148.42 (30,400.00) -26.73% Unfav Mail Room tor surv.ys that were Issued. A budget amendment Is • recommended. 94,869.00 $ 130,683.42 $ 167,383.42 $ (36,700.00) -28.08%' Department Total Controllable Personnel $ 7,589,228.00 $ 7,589,228.00 $ 7,342,028.00 $ 247,200.00 3.26% Controllable Operating 2,192,883.00 2,197,553.98 2,559,153.98 (361,600.00) -16.45% Non-Controllable Operating 1,873,523.00 2,302,263.04 2,538,983.04 (238,700.00) -10.28% Transfers Out - - - 0.00% $ 11,655,734.00 $12,089,045.02 $12,440,145.02 $ (351,100.00) -2.90% 08/18/2004 fltaflflflfl .1.50127.2.1MOMSCL= Administration Controllable Personnel Controllable Operating $ 2,096,349.00 $ 2,069,851.00 $ 1,972,051.00 $ 430,606.00 515,771.24 460,171.24 97,800.00 55,600.00 97,800.00 55,600.00 4.72% 10.78% 0.00% COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS ADOPTED BUDGET AMENDED BUDGET FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 4.72% - Turnover 10.78% - Fay. Legislative $7,900, Professional Services $9,300, Travel and Conference $40,000, Workshops & Meeting $24,000, Groceries $2,000, and Postage $9,900 due to lower than anticipated use. Unfav. County Annual Audit ($37,500) due to GASB audit requirements. 287,393.97 287,393.97 0.00% -------- $ 2,873,016.21 $ 2,719,616.21 $ 153,400.00 5.34% Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating , 286,786.00 $ 2,813,741.00 $ 2,096,349.00 430,606.00 286,786.00 $ 2,069,851.00 $ 1,972,051.00 $ 515,771.24 460,171.24 287,393.97 287,393.97 $ 2,813,741.00 $ 2,873,016.21 $ 2,719,616.21 $ 153,400.00 5.34% C;"" 08118/2004 0)/ COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES LIBRARY BOARD ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 969,666.00 637,275.00 869,504.00 $ 2,476,445.00 $ 969,666.00 $ 921,266.00 637,690.79 637,690.79 871,602.16 871,602.16 30,000.00 30,000.00 $ 48,400.00 4.99% Turnover. 0.00% 0.00% 0.00% $ 2,508,956.95 $ 2,460,558.95 $ 443,400.00 1.93% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 969,666.00 $ 969,666.00 $ 921,266.00 $ 637,275.00 637,690.79 637,690.79 869,504.00 871,602.16 871,602.16 30,000.00 30,000.00 $ 2,476,445.00 $ 2,508,958.95 $ 2,460,558.95 $ 48,400.00 48,400.00 1.93% 4.99% 0.00% 0.00% 0.00% - 08/18/2004 cD'A Department Total $ 3,810,124.00 $ 5,874,108.06 $ 5,874,108.06 $ 0.00% COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES DRAIN COMMISSIONER ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Drain Commissioner Controllable Personnel Controllable Operating $ 2,668,091.00 $ 2,984,786.00 $ 2,984,786.00 0.00% 165,998:00 1,773,808.65 1,802,542.65 (28,734.00) -1.62% - Unfav = Landry & Cleaning ($8,892) new uniform program for Soil Erosion staff. Fay - Legal Services $5,600, Unfav - Licenses and Permits ($2,800) substantial increase in _ bill from Mi.!...higan Dept. of Environmental Quality. Unfav - Membership, Dues & Publication ($5,000) general inflationary increase. Fay - Personal Mileage $5,965 less than anticlifated employee personal car travel. Unfav - Paper Printing ($4,383) spending on letterhead and envelopes. Unfav - Stream Gage Program ($4,200) State - of Michigan DEQ bill increased. Unfav - Material and Supplies ($4,400) invoice for _ printing colored Soil Erosion pamphlet guide. Unfav - Office Supplies ($6,457) for letterhead. Unfav - Printing Supplies ($4,500) ordering of business cards for staff. A budget ammdment is recommended. Non-Controllable Operating Transfer Out 919,870.00 56,165.00 1,059,348.41 56,165.00 1,059,348.41 27,431.00 0.00% 28,734.00 51.16% To offset projected unfavorability in operating. Total $ 3,810,124.00 $ 5,874,108.06 $ 5,874,108.06 $ 0.00% ====nS 08/18/2004 Auditing Controllable Personnel Controllable Operating Non-Controllable Operating REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED rif 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES --------- ------- Administration Controllable Personnel Controllable Operating Non-Controllable Operating Emergency Response & Preparedness Controllable Personnel Controllable Operating Non-Controllable Operating Corporation Counsel Controllable Personnel Controllable Operating Non-Controllable Operating $ 1,995,080.00 $ 1,995,080.00 $ 1,995,080.00 $ - 0.00% 301,954.00 302,598.04 267,596.04 35,000.00 11.57% - Favorability reflects cost containment measures by executive staff for Travel & Conference. 436,618.00 442,873.99 442,873.99 0.00% - $ 2,733,652.00 $ 2,740,660.03 $ 2,705,560.03 $ 35,000.00 1.28% $ 586,075.00 $ 594,034.00 $ 694,034.00 0.00% 475,150.00 478,413.00 478,413.00 - 0.00% 325,859.00 355,678.54 355,678.54 0.00% - $ 1,386,884.00 $1,428,125.54 $1.428,125.54 $ 0.00% $ 1,093,380.00 $ 1,093,380.00 $ 1,093,380.00 0.00% 26,180.00 26,180.00, 14,180.00 12,000.00 45.84% - Favorable Travel & Conference, $10,000 and Personal Mileage $1,000 due to budget constraints. 187,795.00 168,105.04 188,105.04 0.00% - . $ 1,287,355.00 $ 1,287,665.04 ,275,665.04 $ 12,000.00 0.93% ' 1,873,933.00 $ 1,873,933.00, $ 1,873,933.00 0.00% 45,943.00 46,078.07 43,078.07 3,000.00 6.51% - Favorable Travel & Conference due to cost containment measures. 223,725.00 231,436.15 231,436.15 0.00% $ 2,143,601.00 $ 2,151,447.22 $ 2,148,447.22 3,000.00 0.14% Department Total Controllable Personnel $ 5,548,468.00 $ 5,556,427.00 $ 5,556,427.00 $ 0.00% Controllable Operating 849,227.00 853,267.11 803,267.11 t0,000.00 5.86% Non-Controllable Operating 1,153,797.00 1,198,093.72 1,198,093.72 0.00% $ 7,551,492.00 $ 7,607,787.83 $ 7,557,787.83 $ 50,000.00 0.66% 1 08/18/2004 v ADOPTED BUDGET AMENDED BUDGET 0.00% 0.00% 0.00% 0.00% $ 930,023.00 $ 930,28C.00 31,742.00 31 ,742.00 138,201.00 156,884.55 Purchasing Controllable Personnel Controllable Operating Non-Controllable Operating Equalization Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out Fiscal Services Controllable Personnel Controllable Operating Non-Controllable Operating $ 895,280.00 $ 35,000.00 29,742.00 2,000.00 156,884.55 3.76% - Turnover. 6.30% - Favorable due to limited Travel & Conference. 0.00% 8.63% - Turnover. 64.90% - Favorable due to job reassignments within the division. -2.66% - (Unfav.) due to mailing of taxpayer notices. A budget amendment is recommended. 0.00% - Office renovation per resolution #040520. 5.85% - Turnover. 0.00% 0.00% $ 6,950,457.00 266,265.00 1,257,811.00 $ 6,950,457.00 308,149.25 1,882,521.50 $ 6,350,457.00 $ 108,149.25 1,932,521.50 600,000.00 200,000.00 (50,000.00) 89,388.00 89,388.00 5,132,176.00 $ 5,132,176.00 $ 4,832,176.00 $ 300,000.00 149,665.00 152,263.72 152,263.72 - . 1,251,813.00 1,913,071.30 1,913,071.30 $ 1,099,966.00 $ 1,118,906.55 $ 1,081,906.55 $ 37,000.00 3.31% $8,474,533.00 $9,230,515,75 $8,480,515.75 $750,000.00 8.13% ,810,090.60 $ 2,743,290.60 $ 66,800.00 2.38% $ 2,732,661.00 $ 2 $ 15,478,028.00 $ 15 524,899.00 3,179,193.00 4 1,010,000.00 193,800.00 (50,006.00) Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out 6.52% 34.04% -1.10% 0.00% ,484,832.00 $ 14,474,832.00 $ 569,392.99 375,592.99 ,554,716.93 4,804,716.93 89,338.00 89,388.00 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT P12004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 325,909.00 $ 7,900.00 7,497.00 S. 341,306.00 $ 325,90E.00 $ 7,90C.00 7,49',.00 341,300.60 . $ 325,909.00 $ 7,900.00 7,497.00 341,306.00 $ $ 6,533,654.00 $ 7,197,511.02 $ 6,897,511.02 $ 300,000.00 4.17% 75,000:00 (8,200.00) $ 2,071,010.00 $ 77,538.02 Reimbursement Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 2,139,463.00 $ 2,146,010.00 69,327.00 69,338.02 594,742.58 594,742.58 3.49% - Turnover. - -11.83% - (Unfav.) due to increase in volume of filing fees offset by favorable revenue for tax Intercepts. 0.00% 523,871.00 $ 19,182,120.00 $ 20,698,329.92 $ 19,544,529.92 $ 1,153,800.00 5.57% 08/18/2004 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Administrative Controllable Personnel Controllable Operating Non-Controllable Operating Support Services Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 178,341.00 $ 178,341.00 $ 178,341.00 $ 2,800.00 2,800.00 2,800.00 13,570.00 13,570.00 13,570.00 • $ 194,711.00 $ 194,711.00 $ 194,711.00 $ $ 1,168,887.00 $ 1,188,887.00 $ 1,158,887.00 $ 33,353.00 38,353.00 38,353.00 961,851.00 1,030,582.49 1,030,562.49 $ 2,162,091.00 $ 2,233,802.49 1 2,233,802.49 $ EXPLANATION OF SIGNIFICANT VARIANCES $ 1,345,228.00 $ 1,345,228.00 $ 1,345,228.00 $ 36,153.00 39,153.00 39,153.00 975,421.00 1,044,132.49 1,044,132.49 $ 2,358,802.00 $ 2,428,513.49 $ 2,428,513.49 $ 0.00% === 08/1812004 3,100.00 0.34% 0.00% 0.00% 0.00% REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT FY 2004 FORECAST ADOPTED AMENDED BUDGET BUDGET AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 341,449.00 $ 341,449.00 $ 2,525.00 2,525.00 36,541.00 36,541.00 341,449.00 $ 2,525.00 36,541.00 0.00% 0.00% 0.00% $ 380,515.00 $ 380,515.00 $ 380,515.00 $ 0.00% Facilities Engineering Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out $ 904,017.00 $ 904,017.00 $ 107,400.00 116,164.00 97,906.00 98,268.89 54,000.00 54,000.00 900,917.00 $ 116,164.00 98,266.69 54,000.00 -Fay. Holiday Overtime costs based on usage through June. $ 1,163,323.00 $ 1,172,447.89 $ 1,169,347.89 $ 3,100.00 0.26% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfers Out $ 1,245,466.00 109,925.00 134,447.00 54,000.00 1,245,466.00 $ 1,242,366.00 $ 3,100.00 118,689.00 116,689.00 - 134,807.89 134,807.89 54,000.00 54,000.00 0.25% 0.00% 0.00% 0.00% $ 1,543,838.00 $ 1,552,962.69 1,549,662.69 $ = 3,100.00 0.20% 08/16/2004 0)77 Controllable Operating 10,219.00 10,219.00 Non-Controllable Operating , 8,971.00 28,446.75 28,446.75 0.00% Human Resources Controllable Personnel Controllable Operating Employee Relations Controllable Personnel Controllable Operating Non-Controllable Operating 198,669.00 226,669.00 226,669.00 0.00% 08/18/2004 REVISED COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES ADOPTED BUDGET AMOUNT AMENDED FY 2004 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration COntrollable Personnel $ 289,929.00 $ 289,929.00 $ 285,229.00 $ 4,700.00 1.62% Turnover. 6,419.00 3,800.00 37.19% Savings attributed to lower use of Personal Mileage $250, Outside Printing $1,000, Travel and Conference $,1000 and purchase of Office Supplies $850. Non-Controllable Operating $ 309,119.00 $ 328,594.75 $ 320,094.75 $ $ 2,230,083.00 $ 2,230,083.00 $ 2,125,183.00 $ 406,678.00 436,678.00 381,778.00 498,914.00 744,473.54 744,473.54 $ 3,135,675.00 $ 3,411,234.54 5:3,251,434.54 $ $ 690,686.00 $ 690,686.00 $ 225,278.00 225,278.00 188,378.00 8,500.00 2.59% 104,900.00 4.70% - Turnover. 54,900.00 12.57% - Anticipated reduction in usage of Data Processing Supplies $4,800 and Office Supplies $5,000; Recruitment Expense fay. $40,000 based on hiring freeze earlier in the fiscal year; Identification Supplies will be favorable $5,500 as the operation for Issuing County badges is now under Facilities Management. 0.00% - 159,800.00 4.68% 21,500.00 3.11% Turnover. 36,900.00 16.38% Anticipated reduction in the need for Service Mementos $27,000 and Employee Med 669,186.00 $ Exams Returning $10,600. $ 1,114,633.00 $ 1,142,633.00 $ 1,084,233.00 $ 58,400.00 '5.11% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $ 3,210,698.00 $ 3,210,698.00 642,175.00 672,175.00 706,554.00 999,589.29 $ 4,559,427.00 $ 4,882,462.29 $ 3,079,598.00 $ 131,100.00 4.08% 576,575.00 95,600.00 14.22% 999,589.29 0.00% $ 4,655,762.29 $ 226,700.00 4.64% ....17==== 0.00% 13,705.00 13,705.00 13,705.00 Non-Controllable Operating $32,295,689.00 $ 33,282,751.20 $ 31,502,751.20 $ 1,780,000.00 5.35% 300,000.00 2.74% - Turnover. 0.00% 0.00% 0.00% 300,000.00 1.79% 08/18/2004 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES HUMAN SERVICES ADOPTED AMENDED FY 2004 BUDGET BUDGET FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating $ 183,434.00 $ 183,434.00 $ 183,434.00 $ 7,476,673.00 7,547,923.00 8,415,923.00 0.00% (868,000.00) -11.50% - (Unfav) unexpected increased costs for Family Independent Agency managed programs for neglected, abused, and delinquents. $ 7,673,812.00 $ 7,745,062.00 $ 8,613,062.00 $ (868,000.00) -11.21% $23,428,679.00 $ 1,700,000.00 80,000.00 Health Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $25,081,135.00 $ 25,128,679.00 4,702,086.16 4,622,088.16 3,377,857.04 3,377,857.04 74,129.00 74,129.00 6.77% - Fay turnover, partially offset by (unfav) overtime due to high activity in Environmental Health ($138,000), and the Jail Health ($117,425). 1.70% - Favorable Professional Services due to procedural changes In dental services. 0.00% 0.00% 4,197,974.00 3,016,580.00 ChIldren's Village Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 10,931,521.00 $ 3,443,916.00 2,293,562.00 $ 16,668,999.00 $ 10,931,295.00 $ 10,631,295.00 $ 3,484,712.71 3,484,712.71 2,361,228.69 2,361,228.69 16,777,236.40 $ 16,477,236.40 $ Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 36,196,090.00 $ 36,243,408.00 15,118,563.00 15,734,721.87 5,323,847.00 5,752,790.73 74,129.00 $ 34,243,408.00 $ 2,000,000.00 16,522,721.87 (788,000.00) 5,752,790.73 74,129.00 5.52% -5.01% 0.00% 0.00% 2.10% $ 56,638,500.00 $ 57,805,049.60 $ 56,593,049.60 $ 1,212,000.00 AMENDED BUDGET FY 2004 FORECAST 163,502.00 $ 163,502.00 $ 7,800.00 7,800.00 6,582.00 6,582.00 177,884.00 $ 177,884.00 $ 0.00% 0.00% 0.00% 0.00% Veteran's Services Controllable Personnel Controllable Operating $ 1,318,306.00 $ 1,318,306.00 253,379.00 253,379.00 $ 1,298,306.00 $ 20,000.00 200,379.00 53,000.00 Non-Controllable Operating 229,818.00 230,507.20 230,507.20 0.00% Medical Examiner Controllable Personnel $ 2,652,948.00 $ 2,652,948.00 $ 2,652,948.00 $ Controllable Operating 451,912.00 457,178.78 549,878.78 Non-Controllable Operating 849,034.00 883,617.41 883,617.41 0.00% 08/1812004 Public Services - Admin. Controllable Personnel Controllable Operating Non-Controllable Operating ADOPTED BUDGET $ 163,502.00 $ 7,800.00 6,582.00 $ 177,884.00 $ COUNTY OF OAKLAND FY 2004 THAID QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1.52% Turnover. 20.92% - Fay. Soldier Burial $50,000 as number of qualifying deaths is lower than anticipated; Use of Service Mementos $3,000 lower than anticipated. $ 1,801,503.00 $ 1,802,192.20 $ ,729,192.20 $ 73,00b.00 4.05% Community Corrections Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out $ 2,839,850.00 $ 2,839,850.00 $ 2,729,850.00 $ 110,000.00 511,998.00 681,334.28 781,334.28 (100,000.00) 611,773.21 613,773.21 (2,000.00) 3.87% - Turnover. -14.68% - Unfav. Contractedl Services ($100,000) increase in PRC due to reduced State funding, which impacts the General Fund because of higher usage as an alternate to incarceration. A Budget amendment is recommended. -0.33% Unfav. Convenience Copier ($2,000). 0.00% 493,101.00 3,844,949.00 $ 4,132,957,49 $ 4,124,957.49 $ 8,000.00 0.19% MSU Ext. - Oakland County Controllable Personnel Controllable Operating Non-Controllable Operating $ 682,568.00 $ 682,568,00 $ 622,568.00 104,978.00 209,700.65 209,700.65 353,834.00 355,259.87 355,259.87 $ 1,141,380.00 $ 1,247,528.52 $ 1,187,528.52 $ 60,000.00 8.79% 0.00% 0.00% $ 60,000.00 4.81% Turnover 0.00% - Fav. Turnover $60,000. Unfav. Overtime ($60,000) due to increase case load from Genesee County. A budget amendment is recommended for Overtime offset by increased revenue. (92,700.00) -20.28% - Unfav. Professional Services ($40,000), Film and Processing ($9,000), Medical Supplies (10,000), and Laboratory Supplies ($13,700) due to increased autopsies caseload for Genesee County. A budget amendment is recommended to be offset by revenues. Unfav. Transport Service ($20,000). Animal Control Controllable Personnel Controllable Operating Non-Controllable Operating 4,086,444.19 $ (92,700.00) -2.32% 100,000.00 3,000.00 $ 3,953,894.00 $ 3,993,744.19 $ $ 1,566,985.00 $ 1,546,720.00 $ 1,446,720.00 95,896.00 116,608.10 118,608.10 524,397.00 537,340.14 534,340.14 6.47% - Turnover. 0.00% 0.56% - Fav.Radio Communication $3,000. ( 08/18/2004 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2004 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 2,187,278.00 $ 2,200,668.24 $ 2,(.97,668.24 $ 103,000.00 4.68% Circuit Court Probation n Controllable Personnel $ • - $ - $ - $ - 0.00% Controllable Operating 42,539.00 42,539.00 .39 539 00 . . 3,000.00 7.05% - Fav. Office Supplies $6,000 as usage is lower than anticipated. Unfav. Interpreter Fees ($3,000), as this was not included in the budget. Non-Controllable Operating 794,389.00 797,055.36 802,055.36 (5,000.00) -0.63% - Unfav. Conveniencce Copier ($5,000). A budget amendment is recommended. $ 836,928.00 $ 839,594.38 $ 641,594.36 $ (2,000.00) -0.24% Department Total Controllable Personnel 9,224,159.00 $ 9,203,894.00 $ 8,913,894.00 $ 290,000.00 3.15% Controllable Operating 1,468,502.00 1,768,539.81 1,905,239.81 (136,700.00) -7.73% Non-Controllable Operating 3,251,165.00 3,422,135.19 3,428,135.19 (4,000.00) -0.12% Operating Transfer Out - $13,943,816.00 $14,394,569.00 $ 14,245,269.00 $ 149,300.00 1.04% I. ADOPTED BUDGET FY ;004 FORECAST AMENDED BUDGET Administration Controllable Personnel Controllable Operating Non-Controllable Operating Controllable Personnel Controllable Operating Non-Controllable Operating $ 3,036,948.00 465,800.00 880,283.00 $ 3,036,948.00 $ 2,871,948.00 753,280.89 753,280.89 880,902.97 860,902.97 288,500.00 17.66% 165,000.00 5.43% - Turnover 0.00% 0.00% 0.00% 0.00% 230,300.00 237,300.00 (14,100.00) 453,500.00 8.03% 13.55% -1.35% 0.00% 8.88% 08/18/2004 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 789,074.00 $ 782,718.00 $ 717,418.00 $ 65,300.00 744,845.00 689,943.79 432643.79 237,300.00 129,154.00 180,584,71 194,684.71 $ 1,663,073.00 $ 1,633,248.50 $ 1,344,746.50 Planning and Economic Development Services 8.34% - Turnover • 35.42% - Fay. Professional Services 95,000 for the NO HAZ Program based on the anticipated level of program events in FY 2004 (reimbursement of program costs from participating communities will also be less than budget). Also, fay. Professional Services 100,000; Legal Services 12,500; Advertising 12,500; and Printing 20,000 for the Solid Waste Resource Management Program based on the expected level of program activity. -7.81% - Unfav. Mall Room costs. A budget amendment Is recommended. (14,100.00) $ 4,363,031.00 $ 4,651,131.86 $ 4,486,131.86 $ 165,000.00 3.55% Community and Home Improvement Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Transfer Out - $ - $ 328,081.00 328,061.00 - $ 328,081.00 $ 328,081.00 $ $ 3,826,022.00 $ 3,818,666.00 $ 3,589,366.00 1,210,645.00 1,751,285.68 1,513,985.68 989,437.00 1,041,487.68 1,055,687.68 $ 8,026,104.00 $ 6,612,439.36 $ 8,158,939.36 0.00% 0.00% 0.00% 0.00% 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% COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENTIWORKFORCE DEVELOPMENT ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2004 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 687,508.00 $ 328,717.00 90,655.00 -- $ 1,106,880.00 $ 687,508.00 $ 328,717.00 90,655.00 -------- 1,106,880.00 $ 687,508.00 $ 328,717.00 90,655.00 ------- — 1,106,880.00 $ $ 687,508.00 $ 328,717.00 90,655.00 $ 1,106,880.00 $ 687,508.00 $ 328,717.00 90,655.00 1 ,106,680.00 $ 687,508.00 $ 328,717.00 90,655.00 1,106,880.00 $ • • 08/1812004 2. NON-DEPARTARTMENT APPROPRIATIONS COUNTY OPERATIONS County Expenditures (210000) Ambulance GIS Automation Insurance Fund Insurance Surety Bonds Miscellaneous Road Commissionteurrent Drain Assessment Road Commission1Tri Party Agreement Senior Citizen Prescriptions West Nile Virus Transfer to Component Unit Total COUNTY BUILDINGS (2200001320000) 1,233,733.00 1,500,000.00 150,000.00 9,620,616.00 $ 12,539,149.00 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET AS ADOPTED BUDGET AS ADJUSTED FY 2004 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION 19,800.00 $ - $ 19,800.00 $ 19,800.00 $ 24,373.63 $ 24,373.63 $ 166,298.00 $ 166,298.00 $ 15,000.00 . 15,000.00 $ 15,000.00 $ 400,000.00 $ 400,000.00 1,233,733.00 $ 1,233,733.00 3,500,003.00 $ 3,500,000.00 $ 150,000.00 $ 150,000.00 $ 500,000.00 $ 500,000.00 9,620,618.00 9,620,616.00 $ $ 15,629 820.63 $15,629,820.63 $ $ 3,630,327.00 $ 3,285613.41 $ 3,285,613.41 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Includes funding for NorthWestem Highway Extension 0.00% 0.00% 0.00% 0.00% STATE AND FEDERAL-COUNTY ASSOCIATIONS (290000) Area Wide Water Quality Assoc of Metro Sewage Agencies Michigan Assoc. of Counties National Assoc. of Counties S.E.M.C.O.G. Traffic Improvement Association Total SUNDRY EXPENSE (2400001270000) $ 55,000.00 $ 1,700.00 65,000.00 20,800.00 579,000.00 30,000.00 $ 751,500.00 $ 55,000.00 $ 55,000.00 $ - 1.700.00 1,700.00 $ - 65,000.00 65,000.00 $ - 20,800.00 21,900.00 $ (1,100.00) 57L 3100.00 579,000.00 $ - 30,000.00 30,000.00 $ - 751,500.00 $ 752,600.00 (1,100.00) 0.00% 0.00% 0.00% -5.29% - Reflects actual fees. 0.00% 0.00% -0.15%, -183.91% Unfav. DTRF Loan Payback, ($522,000) which Is reserved in fund balance though not budgeted. A Budget amendment is recommended. $ 300,000.00 $ 30( ,795,60 853,995.60 $ (553,200.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 Salary Adjustment Summer Employees Salary Appropriation Total (600,000.00) 209,382.00 820,554.00 225,000.00 200,000.00 1,267,500.00 6,755,409.00 6,184,375.00 180,495.00 75,000.00 53,000.00 4,000.00 0.00 365,128.00 $ 15,719,843.00 (600,000.00) 46,38203 860,944.00 210,728.00 42,002.31 1,267,500.00 1,521,974.00 2,355,093.80 121,993.00 13,674.00 53,000.00 4,000.00 1,348.00 352,634.00 $ 6,253,271.11 (600,000.00) 48,382.00 860,944.00 210,726.00 42,002.31 1,287,500.00 1,521,974.00 2,355,093.80 121,993.00 13,674.00 53,000.00 4,000.00 1,348.00 352,634.00 $ 6,853,271.11 5 (600,000.00) 0.00% 0.00% 0.00% - Funds will be used for Budget Transition. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - 0.00% 0.00% 0.00% 0.004 -9.59% Favorability Is reflected within Departments. Amendment is pending. 08/1 A/2 DU 3`1 90.xls Transfers to Other Funds (3100001 Bldg Authority (Debt) Bldg Fund (Capital Improvement Prog.) CLEMIS Cops More Grant Information Technology Fire Records Management Motor Pool Oak. Enhancement-Community Partnership Total AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION No appropriation is recommended for the current year. Additional Revenue Sharing funds will be designated for capital improvements at year end. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -2,92% TOTAL NON-DEPT. APPROPRIATIONS $ 41,353,238.00 $ 39,49P,255.75 $ 40,653,555.75 $ (1,154,300.00) TOTAL EXPENDITURES $ 82,084,105.00 $ 81,484,993,48 82,639,293.48 $ (1,154,300.00) -1.42% c..rN COUNTY OF OAKLAND P1 2004 THIRD QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET AS ADOPTED $1,555,919.00 2,350,000.00 1,950,800.00 2,500,000.00 55,700.00 $ 8,412,419.00 BUDGET AS ADJUSTED $1,445 981.00 6,395812.00 1,950 800.00 11 254.00 3,315,508.00 95,700.00 7500.00 5,700.00 $13,27,255.00 FY 2004 FORECAST $1,445,981.00 $ 6,395,812.00 $ 1.950,800.00 $ 11,254.00 $ 3,315,508.00 .4 95,700.00 $ 7,500.00 $ 55 700.00 _ $13,278,255.00 $ 7:16nMii...1117Z .11.11MS1751.3. 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 441,530,867.00 25,911 ,495.04 $ 25,911,495.04 $ 16,059,242.69 16,059,242.69 15,000,00 15,000.00 , $41,985,737.73 $41,985,737.73 $ 0.00% 0.00% 0.00% 0.00% 90.xls 08/18/2004 FY 2004 BUDGET AMENDMENTS Page 1 of 3 FY 2004 BUDGET AS ADOPTED $ 360,443,936.00 BUDGET AMENDMENTS M.R. #03306 - 10/30/2003 Human Services - MDEQ Reimbursement Acceptance M.R. #03324 - 11120/2003 . County Executive - ERP - 2003 OOP Homeland Security Assessment & Strategy Application / Acceptance Grant M.R. #03339 - 12/11/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 - 1211112003 Public Services / Animal Control - Reorganization M.R. #03326 - 1211112003 Department of Management & Budget - E - Financial System - Phase I M.R. #03367 - 12/11/2003 Sheriff - Patrol Contract with Independence Township $ 67,934.00 $ 20,000.00 $ 25,000.00 $ 17,000.00 $ (49,590.00) $ 4,395,812.00 144,032.00 M.R. #03368 - 12111/2003 $ 70,464.00 Sheriff - Patrol Contract with Oxford Township TOTAL AMENDED BUDGET AS OF 12131/2003 (1ST QUARTER) $ 365,134,588.00 M.R. #03358 - 12/11/2003 $ 205,570.00 Treasurer - e-Tax access Project - $ 107,860.00 M.R. #03370 - 01/22/2004 Circuit Court - Use of Mediation Funds M.R. #04012 - 0112212004 Drain Commissioner - Watershed Management Human Services - Renovations @ Health South CLEMIS & Emergency Communications - Fire Records Mgmt BOC - Library Computers • Drain Commissioner - Water and Sewer Master Plan M & B - FY 2003 Encumbrance for Purchase Orders. M.R. #04013 - 02/05/2004 Information Technology - Emergency Response Tech. Improvement 432,479.00 51,497.00 95,700.00 30,000.00 $ 1,500,000.00 $ 1,356,929.84 $ 250,000.00 44-e (N $ 250,000.00 5,000.00 $ (109,000.00) $ 55,250.00 2,450.00 $ 80,769.00 $ 152,000.00 $ 89,388.00 $ 2,287,419.00 11,254.00 $ 117,000:00 $ 757,000.00 $ 57,750.00 $ 13,440.00." - $ 372,934,343.84 $ 400,000.00 16,923.00 $ 162.00 Page 2 of 3 MA. #04014 - 02/05/2004 Information Technology - Comstat / Crime View Web Site MR.. #04023 - 02/05/2004 Circuit Court - Attorney Appointment Program • M.R. #04022 - 02105/2004 Division of Waste Resources - Interlocal HazNVaste M.R. #03369 - 0210512004 Public Services - Medical Examiner Fee Adjustments M.R. #04049 - 03/04/2004 Sheriff - FY 200412005 Automotive Theft Prevention Grant MA. #04036 - 03/04/2004 52nd District Court - Rochester Hills - Add Staff in Probation Unit M.R. #04037 - 0310412004 Sheriff Use of Forfeited Funds for Equipment M.R. #04052 -03/04/2004 M & B Equalization - IT Contract for BS & A Software M.R. #04072 - 03/18/2004 M & B - FY 2003 Carry Forwards - CLEMIS & Emergency Communications - COPS More Grant Public Services - Community Corrections - Drug Testing Sheriff - Special Deputy - Outside Prisoner Housing MA. #04063 - 03/18/2004 52nd District Court - Additional Staff in Probation Unit M_R_ n04064 - 03/18/2004 Sheriff - Law Enforcement Services with Parks and Recreation TOTAL AMENDED BUDGET AS OF 03131/2003 (2ND QUARTER) MA. #04068 -04/2212004 Road Commission One Time Funding for Road Projects M.R. #04103 - 05/06/2004 Clerk/Register of Deeds - New Notary Application Fees M.R. #04104 -0510612004 Clerk/Register of Deeds - New Notary Service Charge Fees /17'‘ Page 3 of 3 ocl (IN M.R. #04110 -05106/2004 County Executive - Emergency Response - Power Outage Grant M.R. #04118 -.05/06/2004 Public Works - 2004 Gypsy Moth Suppression Spray Contracts M.R. #04137 - 06/03/2004 Planning & Development - Trade Mission Community Corrections - IT Development Health - West Nile Virus Program Clerk/Register of Deeds - Civil Action Fees Emergency Response and Prep (ERP) - Federal Grants Health - Convention Facility/Liquor Tax Sheriff - Capital Equipment Human Resources - Intem/Print Shop Public Services - Animal Control Total $ 71,765.31 $ 104,422.00 $ 65,000.00 $ 32,000.00 $ 500,000.00 $ 215,000.00 $ (17,000.00) $ (91,820.00) $ 40,000.00 $ 79,000.00 $ 39,000.00 $ 861,180.00 M.R. #04143 - 06/17/2004 • 17,250.00 Sheriff - Increase in Fees for the Records Unit TOTAL AMENDED BUDGET AS OF 06/30/2004 (3rd QUARTER) $ 374,407,576.15 Total Revenue OPERATING EXPENSES 08/11/2004 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS SHERIFF'S OFFICE ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1SHERIFF AVIATION #680 OPERATING REVENUES: Outside Revenue Inside Revenue $0.00 $0.00 $0.00 ,. $0.00 0.00% $ 2,066,692.00 $ 2,066,692.00 $ 1,942,892.00 $ (12.5,800.00) -5.99% - Billing to Sheriffs GF budget for actual expenditures and principal payments for operating year. 52.066.692.00 $2,066,692.00 $1,942,892.00 $ (121.800.001 -5.99% $1,629,192.00 $1,629,192.00 $1,505,392.00 $ 123,800.00 7.60% - Fair. Salary $22,500, Fringes $18,800, Depreciation Expense $82,500. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $437,500.00 5437,500.00 3437,500.00 $ - 0.00% NON-OPERATING REVENUE $0.00 $0.00 0.00 $ - 0.001 OPERATING TRANSFERS IN $0.00 $0.00 . $0.00 $ - NET REVENUES OVER(UNDER) EXPENSES $437,500.00 $437,500.00 $437,500.00 $0.00% _ — 15.28% - Fay. due to turnover, lower depreciation, use of office supplies, materials, - copier and Info Tech Operations, partially offset by higher Indirect Costs. - -72.17% - Unfav. due to lower returns of investments. COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUND DEPARTMENT OF CLERK/REGISTER OF DEEDS ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MICROGRAPHICS FUND (654) REVENUES Outside Inside Total Revenues $ 414,556.00 $414,556.00 $336,256.00 ($78,300.00) $ 329,104.00 $329,104.00 $455,004.00 $425,900,00 $ 743,660.00 $743,660.00 $791,260.00 $47,600.00 -18.89% - Unfav. due to decline In number of customers for film duplicating. 38.26% - Fay. Microfilming and photostat volume due to new project activity. 6.40% OPERXTING EXPENSES $ 984,739.00 $1,104,376.00 $935,576.00 $168,800.00 NET NON-OPERATING REV $ 23,000.00 $23.000.00 $6,400.00 ($16,600.00) REVENUE OVER (UNDER) EXPENDITURES $(218,079.00) (q337,716.00) .uu276211221 $199,800.00 08/11/2004 ip MICROGRAPHICS.xls Total Revenue OPERATING EXPENSES COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUND DRAIN COMMISSIONER ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET ACTUAL FAVAUNFAV) PERCENT -- ----- ------- ------- --...-- 'DRAIN EQUIPMENT FUND ( 639) EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Inside Outside NET INCOME (LOSS) BEFORE $2,131,508.00 $2,131,508.00 $1,994,889.95 ($136,618 05), -6.41% Untav - Equipment Rental ($149,622) due to over estimate of billable equipment charges. Fey - RebIlled Charges $11,000 for increase in rebills to 4 Internal Departments. Fee - Prior Year Expenditure $1,875 for Michigan FEMA assistance money for power black out. 738,230.00 738,230.00 403,354.00 ($334,876.00) -45.36% Fav - EXT Dispatch Services $2,176 per projected actual SCADA dispatch services to be billed to Non Operations and Maintenance CVT's. Unfav - • External Equipment Rental ($40,000) because project to convert microfilm to computer disk wit not occur in year 2004. Unfav - External Rob}lied Charges Revenue (6299,000) Is offset by favorable 8300K variance In Contracted Services expense. 2,868,738.00 2,869,738.00 2,398,243.85 (471,494.05) -16.43% 2,888,736.00 2,888,736.00 3,040,363.63 (151,627.63) -5.25% - Fey - Contracted Services $300,000 because of decrease In rebillable repairs. FilV - Equipment Repair & Wird $33,500 because Of Increase in leased vehicles. Unfav - Indirect Costs ($22,408) Increase In cost due to Maximus . allocation rate change. -Fay - Maintenance Vehicles $26,500 due to Increase in leased vehicles. Fey - Microfilming & Reproductions $40,000 because project to convert microfilm to computer disk will not occur in year 2004. Unfav - Protective Clothing & Equip. ($11,600) purchased gas detectors. Fay - Uniforms $51,670, Dry Goods and Clothing $14,760, and Employee Footware $9,570 items being charged direct versus being part of Drain Equipment Fund charges. Unfav - Expendable Equipment Expense ($37,400) due to increased capitalization threshold. - - Way - Materials and Supplies ($75,000) due to Increases in the following programs, Sewage Metering, Administrative, Miscellaneous Equipment and TV Vans. Unfav - Shop Supplies ($24,000) under estimated budget forecast compared to actual spending. Unfav - Maintenance Depart Charges ($14,500) for SCADA dispatch charges from facilities. Unfav - Info Tech Operations - - ($2i6,185) due to increased leased computers, printers and software from IT. Unfav - Motor Pool ($204,811) due to replacement and additional new leased vehicles. (18,998.00) (18,998.00) (642,119.68) (623,121.68) 3279.93% NON-OPERATING REVENUEAEXPENSE) 77,182.00 77,182.00 117,392.52 40,210.52 52.10% Fm, - Income from Investments $7,518 higher than anticipated investment robyn. Fav - Accrued Interest Acqustment $1,693 accrued booking adjustment for hwestment Income. Fav - Gain on Sale of Vehicles $31,000 for sale of user 0Wr ad vehicles at spring 2004 Auction. TRANSFER IN TRANSFERS (OUT) 000 0.00 0.00 0.00 - 0.00% 118,034.00 118,034.00 357,852.00 (239818.00) -203.18% Unluv - Transfer (Out) ($239,8113) for the replacement cost of 11 owned vehicles to leased vehicles a Budget Amendment is recommended. NET REVENUES OVER(UNDER) ($59,850.00) ($59,850.00) ($882,579.16) ($822,729.16) EXPENSES 08/11/2004 ( OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSE CLAIMS PAID TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) $ 200.00 - $ 200.00 $ 0.00% " 68,800.00' 3.02% - Fay. due to decrease in indirect costs. 0.00% 68,800.00 1.82% 69,000.00 -7.42% 0.00% $ (529,396.00) $ J529,396.00), NET REVENUES OVERAUNDER) EXPENSES $ 1460,369.00) $ 69,000.00 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED BUDGET AMENDED BUDGET FY 2004 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'LIABILITY INSURANCE FUND 677 - $ 2,716,833.00 $ 2,716,833.00 $ 2,146,229.00 $ 1,500,000.00 $ 3,646,229.00 $ (929,396.00) $ 400,000.00 - $2,850,331.66 $2,850,331.66 $2,279,727.66 $ 1,500,000.00 $3,779,727.66 $ (929,396.00) $ 400,000.00 197.00 $ 2,850,332.00 $ 2,850,529.00 $2,210,898.00 $ 1,500,000.00 $ 3,710,898.00 $ (860.369.00) $ 400,000.00 NON-OPERATING REVENUE (EXPENSE) $ 400,000.00 08/11/2004 r' COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUND MANAGEMENT AND BUDGET ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'OFFICE EQUIPMENT FUND 864 OPERATING REVENUE - INSIDE $658,345.00 $656,345.00 $646,200.00 $ (12,145.00) $689,651.00 $689,851.00 $645,859.00 $ 43,792.00 -1.84% - Unfav, d..ie to equipment replaced under the one time replacement plan 6.35% - Fay. duel to less items depreciated because of change in threshold amount. OPERATING EXPENSE 1 OPERATING INCOME (LOSS) $ (31,306.00) $ (31,308.00) $ 341.00 $ 31,647.00 NET NON-OPERATING REV (EXP) $ 31,308.00 $ 31,306.00 $ 31,306.00 $ - NET REVENUES OVER/(UNDER) EXPENSES - $ - $ 31,647.00 $ 31,647.00 0,00% 0811112004 143 :FRINGE BENEFITS FUND 678 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION or SIGNIFICANT VARIANCES .1 • REVENUE RETIREES HOSPITALIZATION . 827,194,338 $27,194,338 $27,209,738 • 115,400 0.06% RETIREMENT ADMINISTRATION . 1,126,800 1,126.800 1,123,000 (3,800) -0.34% TUITION REIMBURSEMENT 335,000 335,000 334,500 (500) -0.15% EMPL. DEFERRED COMP. ADMIN. 1,500 1,500 1,500 0 0.00% EMPL. DEFERRED COMP. COUNTY 723,500 723,500 720,500 (3,000) -0.41% , EMPLOYEE IN-SERVICE TRAINING 1,562,400 1,771,782 1,562,782 (209,000) -11.80% DEFINED CONTRIBUTION PLAN . 14,433,800 14,433,800 14,423,800 (10,000) -0.07% . GROUP LIFE 660,000 660,000 660,000 0 0.00% HOSPITALIZATION 26,132,000 26,132,000 25,310,100 (821,900) -3.15% - Unfav. Hospitalization contracts decreased by 150 due to FY2003 retirement incentive, turnover and hiring freeze. SOCIAL SECURITY 14,317,000 14,317,000 14,685.000 368,000 2.57% DENTAL INSURANCE 2,983,900 2,983,900 2,983,900 0 0.00% ''' • OPTICAL INSURANCE 343,000 343,000 359,000 16,000 4.66% .. DISABILITY INSURANCE 861,600 861,600 861,000 (600) -0.07% • SHORT-TERM DISABILITY 1,420,800 1,420,800 1,460,800 40,000 2.82% FRINGE BENEFITS 705,261 705,261 705,261 0 0.00% . WORKERS COMPENSATION 2,290,800 2,290,800 2,475,400 184,600 8.06% 1 UNEMPLOYMENT COMPENSATION 350,000 350,000 351,000 1,000 • '0.29% SICK AND ANNUAL LEAVE CASH-OUT . 500,000 500,000 503,000 3,000 0.60% EXT - FLEX BENEFIT DEDUCTIONS 131,675. 131,675 398,500 266,825 202.64% EXT - FLEX BEN HOSPITAL DEDUCTIONS 1,600,000 1,600,000 1,462,600 (137,400) -8.59% EXT - HOSPITALIZATION INSURANCE 400,000 400,000 320,000 (80,000) -20.00% EXT - DENTAL INSURANCE 75,000 75,000 37,000 (38,000) -sa 67% • , EXT - OPTICAL INSURANCE 2,090 2,000 2,000 0 a 00% EXT - FORFEITURES , 10,000 10,000 3,000 (7,000) -70.00% EXT - CHILD CARE FACILITY 0 0 14,800 14,800 0.00% . . . INVESTMENT INCOME 540,410 540,410 364,610 (175,800) -32.63% - Unfav. Continued low Investment rates. TOTAL REVENUE 698,700,784 898,910,166 • 898,332,791 ($577,375) -0.58% EXPENSE $27,194,338 $27,194,338 $27,194,338 $0 0.00% The Fringe Benefit Fund is eiperiencIng a favorable Impact as a result of the FY 2003 retirement incentive; hospitalization' RETIREES HOSPITALIZATION 6985,600 and defined contribution $331,500 as well as policy changes , recommended by the Administration and apprc••ed by the Board of Commissioners. RETIREMENT ADMINISTRATION 1,126,800 1,126,800 , 1,118,000 8,800 0.78% SICK AND ANNUAL LEAVE CASH-OUT 500,000 500,000 573,000 (73,000) -14.60% TUITION REIMBURSEMENT 335,000 335,000 335,000 0 0.00% EMPL. DEFERRED COMP. ADMIN. 1,000 1,000 2,800 (1,800) -180.00% EMPL. DEFERRED, COMP. PRINTING 500 500 100 400 80.00% EMPL. DEFERRED COMP. COUNTY 723,500 723,600 ' 723,500 0 0.00% EMPLOYEE IN-SERVICE TRAINING 1,162,400 1,326,782 1,171,782 155,000 11.68% IN-SERVICE TRAINING - INFO TECH 400,000 445,000 318,000 129,000 28.99% DEFINED CONTRIBUTION PLAN . 14,433,800 14,433,800 14,102,300 331,500 2.30% GROUP LIFE 660,000 ' 660,000 649,500 10,500 1.59% HOSPITALIZATION . • ..i. 28,132,000 28,132,000 27,146,400 985,600 3.50% SOCIAL SECURITY 14.317,000 14,317,000 14,691,900 (374,900) -2.62% DENTAL INSURANCE . 3,058,900 3,058,900 3,068,900 (10,000) -0.33% OPTICAL INSURANCE 345,000 345,000 345,000 0 0.00% DISABILITY INSURANCE 2,282,400 2,282400 2,323,800 (41,400) -1.81% FLEXIBLE BENEFIT PAYMENTS 421,675 421,675 332,075 89,600 21.25% PROFESSIONAL SERVICES 200,000 200,000 153,000 47,000 23.50% WORKERS COMPENSATION 2,203,800 2,290,800 2,106,200 182,800 7.97% UNEMPLOYMENT COMPENSATION 350,000 350,000 298,700 51,300 14.66% ACCOUNTING SERVICES 95,761 . 95,761 96,861 (1,100) -1.15% CHILD CARE FACILITY 260,410 260,410 255,310 5,100 1.96% INDIRECT COSTS 409,500 409,500 309,500 100,000 24.42% TOTAL EXPENSE $98,700,784 $98,910,166 $97,315,966 11,594,200 1.61% • REVENUE OVERAUNDER) EXPENSE $0 $0 $1,016,825 $1,016,825 FRINGE BENEFITS.xis nTur- 08/1112004 COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES t ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES IMOTOR POOL FUND 661 OPERATING REVENUE: 73,930.00 73,930.00 77,300.00 $3,400.00 4.60% - Fav. due to increase in work perfomed on vehicles from outside agencies. 5,064,530.00 4,847,863.00 4,686,980.00 ($160,900,00) -3.32% - Unfav. due to reduction in lease rates. 5,138,460.00 4,921,793,00 4,764,280.00 (157,500.00) 3.20% 5,929,888.00 5,713,221.00 5,093,438.00 619,800.00 10.85% - Fay. reduction in Salaries and FB due to 2 mechanics on short term disability, $56,929, decrease in professional services, $17,500, decrease In purchases of expendable equipment, $10,000, and decrease in depreciation due to less purchased patrol vehicles put into service than anticipated, $712,920. Unfav, due to increase In indirect costs ($47,047), increase in gas charges ($74,013) and increase in sublet repairs ($38,000). OPERATING INCOME (LOSS) (791,428.00) (791,428.00) (329,158.00) 462,300.00 58.41% • NON-OPERATING REVENUE (EXPENSE) 430,000.00 430,000,00 473,026.00 43,026.00 10.01% - Fay. due to gain on sale of vehicles. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (361,428.00) (361,428.00) 143,868.00 505,300.00 -139.81% OPERATING TRANSFERS IN 113,850.00 . 184,498.00 184,498.00 0.00 0.00% NET REVENUE OVER/(UNDER) EXPENSES _1247,578.00) A176,930.00) 328,366.00 505,300.00 -285.59% jL owaii t Wet -66PIEreAriliiiiiiiii-MTUR511/11 OPERATING REVENUES: . " Outside Revenue . $135,035.00 $135,035.00 6296,658.00 $181,600.00.. 119.67% - Fa". due to increase of use of mail room by municipalities. _ Inside Revenue 2,966,223.00 2,966,223.00 3,073,743.00 107,500.00 ' . 3.620/D - Fir:.. due to increase in printing, added and updated copiers, and increase of paper used by departments. _ Total Revenue $3,101,258.00 $3,101,258.00 $3,370,401.00 $269,100.00 . OPERATING EXPENSE 3,145,615.00 3,145,615.00 3,406,528.00 (260,900.00) -8.29% - Un4v. due to Increase of indirect costs of ($84,161), copier machine rental includes 4th quarter invoice for FY2003 in the amount of ($143,251) and increase of standard mail and metered postage offset by revenue. OPERATING INCOME (LOSS) (44,357.00) (44,357.00) (36,127.00) . 8,200.00 ' NON-OPERATING REVENUE (EXPENSE) 2,000.00 2,000.00 1,986.00. 0.00 NET REVENUE OVERAUNDER) EXPENSES • ($42,357.00) ($42,357.00) ($34,141.00) $8,200.00 Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSE 0811112004 96° 0.00% 0.00% COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES - ADOPTED AMENDED FY 2004 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT' EXPLANATION OF SIGNIFICANT VARIANCES MOOM.011.1 OAKLAND COUNTY INTERNATIONAL AIRPORT (581) 4. OPERATING REVENUE $4,238,285.00 $4,236,285.00 $4,281,285.00 $45,000.00 1.06% - Fay. Landing Fee Concessions $10,000 due to increase in activity; T-Hangar Rental $15,000 due to rate increase; Refund Prior Year Expenditures • $2,600; Gain on Sale of Equipment $8,400; Reimb US Customs Service , . $80,000 due to rate Increase and service to larger aircraft. Unfav. Aviation - '1 Gas ($30,000), Car Rental Concessions ($20,000) and Landing Fees ($21,000) unfav. due to lower usage than anticipated. OPERATING EXPENSE $4,508,080.00 $4,508,080.00 $5,072,680.00 ($564,600.00) -12.52% - Fav. Salary $15,000 due to turnover. Unfav. Indirect Costs ($41,000) due to rate increase; US Custom Services ($38,000) unfav. due increase in Inspector charges to Oakland County; Depreciation ($475,600) unfav., which Includes additional reporting of local and state depreciation as required by GASB 34. Insurance ($25,000) unfav. due to rate increase. NET OPERATING INCOME (LOSS) ($271,795.00) ($271,795.00) ($791,395.00) ($519,600.00) 191.17% NON-OPERATING REVENUE $ 271,795.00 $ 271,795.00 $ 161,795.00 $ (110,000.00) -40.47% Unfav, Income from Investments lower than anticipated investment returns. TOTAL INCOME BEFORE . CONTRIBUTIONS AND TRANSFERS $0.00 $0.00 ($629,600.00) ($629,600.00) TRANSFER IN 0.00 0.00 0.00 0.00 CAPITAL CONTRIBUTION 0.00 0.00 0.00 0.00' TOTAL NET INCOME (LOSS) $0.00 $0.00 a ($629,600.00) ($629,600.00) 08/11/2004 L14) FY 2004 FORECAST AMENDED BUDGET COUNTY OF OAKLAND FY 2004 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FACILITIES MANAGEMENT VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED BUDGET ------- 22.79% -2.11% -1.80% 2.27% $294,450.00 $361,550.00 667,100.00 23,950,839.00 23,448,639.00 (504,200.00) $24,245,289.00 $23,808,189.00 ($437,100.00) $24,384,289.00 $23,810,389.00 6553,900.00 ($2,200.00) 6116,800.00 98.15% 678,400.00 11,400.00 17.54% $54,000.00 ($119,000.00) ($119,000.00) $65,000.013 $65,000.00 $54,000.00 654,000.00 $0.00 0.00% $0.00 $0.00 $128,200.00 $128,200.00 FACILITIES MAINTENANCE & OPERATIONS (#8311 1 OPERATING REVENUES: Outside Revenue $283,200,00 Inside Revenue 23,950,839.00 Total Revenue $24,234,039.00 OPERATING EXPENSES $24,353,039.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN NET REVENUES OVER(UNDER) EXPENSES - Fay. for lease payments from CMH Authority at CMH Center and Stale of Michigan (Jobs Commission). at Oakland Pointe due to occupancy beyond original lease terms, - Reduced Office Space Rental revenue due to demolition of former Work Release Facility and later than anticipated occupancy of new 52-3 Rochester Hills 'District Courthouse (9 months into FY 2004). Reduced Office Space Rental revenue will be offset by reduced expenditures required to operate and maintain - the facilities. Pay. Maintenance Department Charges $75,000 partially offset this variance. - Fay. Salaries and Fringe Benefits due to turnover $375,000; fay. Overtime $98,400 based on reduced snowplowing ectivfty; fav. Sublet Repairs $475,000, Maintenance Supplies & Materials $300,000; and Electrical Service $250,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 (demolished) and the new 52-3 Rochester Hills District Courthouse (partial year occupation).' Favorabillty Is partially offset by Indirect Costs ($94,000) due to determination of Indirect Cost charges subsequent to budget formulation; Grounds Supplies ($95,000) due to reclassification of supply costs; Depreciation.($616,400) for a one-time depreciation adjustment due to reclassification of certain assets; IT Operations ($63,800) due, In part, to pc replacements; Telephone Communications ($35,006) based on usage; and Software Lease/Purchase ($40,000) for software upgrade. - Fay. investment Income due to higher Investment base, 1144,127.00 $144,127.00 $0.00 $144,127.00 $144,127.00 $0.00 6144.127.00 $144,127.00 $0.00 nnn• [PONTIAC MARKET (#281) OPERATING REVENUES - OUTSIDE OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS TRANSFERS IN TRANSFERS OUT $0.00 0.00% $0.00 0.00% $0.00 0.00% 0.00% NET REVENUES OVER(UNDER) EXPENSES $0.00 $0.00 $0.00 $0.00 0.00% Mil /2'004 Lfl FACILITIES INTERNAL FORE.xls • COUNTY OF OAKLAND OFFICE OF THE SHERIFF' MICHAEL J. BOUCHARD May 10, 2004 Ms. Kelly Hayward The Wilson Group • 10555 Newkirk, #500 Dallas, TX 75220 Dear Ms. Hayward: Thanks to you, the Kroger Co., and Milk-Bone, the Oakland County Sheriffs Office is able to purchase a new, hid-ay-trained police dog for our K-9 Unit. We are so pleased to accept your $5000 contribution. Your donation can be sent to: The Oakland County Sheriffs Office, Attn: Mandy Ford, 1201 North Telegraph Road, Pontiac, MI 48341.. The check should be made payable to "Oakland Police Academy". - Again, thank you. We look forward to seeing you at the June 9 event at the Kroger store in Bloomfield Hills, MI. Michael J. Bouchird OAKLAND COUNTY SHERIFF 1201 N TELEGRAPH RD * PONTIAC MI 48341-1044 * 248/858-5008 • • 1, I Number of Accounts Amount Waived Interoffice MEMORANDUM to: Nancy Fournier, Fiscal Services cc: Judi Lockhart, Reimbursement from: Joyce Raczka, Reimbursement re: Inmate Waived Report date: June 28, 2004 Submitted for your review is the Inmate Report for 2004 for the Months of Jan, Feb and Mar. JAN 04 055182 CZ 85 $ 144,564.00 FEB 04 055849 CZ 94 : $ 177,316.0a: MAR 04 056541 CZ 112 $ 227,217.00' TOTAL 291 $ 549,097.00 From the desk of.... Joyce Raczka Reimbursement 1200 N Telegraph Road Pontiac, Michigan 48343 Tel:248-858-7368 fax:248-975-4288 TOTAL 260 $ 477,533.00 Interoffice MEMORANDUM to: Nancy Fournier, Fiscal Services cc: Judi Lockhart, Reimbursement from: Joyce Raczka, Reimbursement re: Inmate Waived Report'. date: July 1, 2004 Submitted for your review is the Inmate Report for 2004 for the Months of Apr, May and Jun. Nwmbcr of Amount Waived Accounts APR MAY JUN 04 057280 CZ 94 $ 185,455.00 04 058026 CZ 86 $ 155,919.0Q 04 058730 CZ 80 $ 136,159.00 From the desk of.... Joyce Raczka Reimbursement 1200 N Telegraph Road Pontiac, Michigan 48343 Te1:248-858-7368 fax:248-975-4288 50 //7 /1 In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 9th day of September, 2004. AG. li///e4 William Caddell, County Clerk I v Resolution #04246 September 9, 2004 Moved by Moss supported by Bullard the resolution be adopted. AYES: Douglas, Gregory, Jamian, Knollenberg, KowaII, Law, Long, McMillin, Middleton, Moss, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Webster, Wilson, Zack, Bullard, Coulter, Crawford. (22) NAYS: None. (0) A sufficient majority having voted therefore, the resolution was adopted. I HEREBY APPROVE THE FOREGOING RESOLUTION 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 September 9th, 2004 with the original record thereof now remaining in my office.