The URL can be used to link to this page

Home My WebLink AboutResolutions - 2006.09.21 - 283114 MISCELLANEOUS RESOLUTION 106175 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2006 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 Section 22, which authorizes budget amendments budgeted revenue and actual revenue, and Section amendments for variance between estimated revenue amendments are required; and WHEREAS the Fiscal Year (FY) 2006 Third Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS the 52'd District Courts have requested budget amendments to reappropriate funds from the FA Expendable Equipment Expense account to the Expendable Equipment account to more accurately record equipment purchases under $5000; and WHEREAS the Prosecuting Attorney has requested an amendment to reappropriate $4,000 from the Membership Dues line-item to the Periodicals Books Publications Subscription line-item and reappropriate $20,000 from Witness Fees and Mileage to Expert Witness Fee and Mileage to more accurately account for these expenses; and WHEREAS an amendment is recommended to the Sheriff's Department budget to reappropriate $296,224 from the Administration Division Equipment Rental to Patrol Services Division Equipment Rental to record the budget within the division where the expenses are incurred; and WHEREAS an amendment is recommended to the Sheriff's Department budget to transfer $370,611 from the Prisoner Housing-Out County line-item to the Jail Population Management Fund (#21130) to cover expenses related to tracking the cost of jail overcrowding and expansion; and WHEREAS the Library Board is requesting a reappropriation of $86,772 in Salaries ($56,170) and Fringes Benefits ($30,602) from Research Jail Libraries to Research-Research Administration to properly account for a Library Supervisor position, and an amendment is requested to reappropriate funding for Information Technology Operations ($2,325) and Expendable Equipment Expense ($1,750) to other programs within the division to record budget where the expenses are incurred; and WHEREAS the Drain Commissioner is requesting a budget amendment in the amount of $115,000 to reduce revenues and expenditures in the Environmental Unit due to a reduction in 2006 grant funding and expenditures not expected to be incurred during FY 2006; and WHEREAS a budget amendment is recommended recognize favorable revenue of $17,700 in the Purchasing Division from an increased number of contract rebates with Office Max to offset anticipated unfavorability in Overtime due to an increase in demand for services and PeopleSoft implementation; and WHEREAS a budget amendment of $8,500 is requested to reappropriate Fringe Benefits from Facilities Engineering, which is reflecting favorable hospitalization costs to Facilities Management Administration, which is experiencing higher hospitalization costs than budgeted; and FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Coulter absent. September 21, 2006 General Appropriations Act for variances between the 23, which authorizes budget and projected expenditures, WHEREAS the Planning and Economic Development Division is requesting a budget amendment to reappropriate $30,000 within its budget for the Emerging Sectors Program to provide for development of additional marketing materials; and WHEREAS a budget amendment in the amount of $20,000 is recommended in the Animal Control Division budget due to increased expenses for in-house sterilizations and medical needs for the animals in the shelter, and additional revenue of $20,000 is available in the Animal Population and Education Fund (#21315) and $23,750 within General Fund Salaries and Fringe Benefit projected favorability to cover the expenses; and WHEREAS revenue from Income from Investments is reflecting a substantial favorability and the Facilities Management Administration Division is requesting an appropriation of $7,500 for an appraisal of potential sites for construction of the future 52-2 District Courthouse and for County property adjacent to the Southfield Health Center; and WHEREAS due to increased cost of gas, a loss is forecasted for the Motorpool Fund and therefore an appropriation is recommended in the amount of $510,000 to keep the fund out of deficit; and WHEREAS the FY 2006 Adopted Budget for the General Fund included a transfer to the Revenue Sharing Reserve fund of $77,153,076; State mandates allow only $75,861,063, which is $1,292,013 less than the adopted budget. The additional funds should therefore be transferred directly to the Capital Cooperative Initiatives Revolving Fund (CCIRF); and WHEREAS an appropriation of $950,000 is recommended in the Human Services Administration budget due to increased cost incurred for care of neglected and abused wards of the court and there is a substantial favorability projected in Child Care Subsidy revenue to cover the costs; and WHEREAS County Auditors have recommended that departmental "grant match" expenditures be reported as "transfer out" to individual grants and it is necessary to reappropriate the budget for the Friend of the Court, Circuit Court and the 52 nd District Courts to reflect this accounting change; and WHEREAS the Delinquent Tax Revolving Fund is projecting favorable revenue in Income from Investments $3,500,000 and Premium on Bonds Sold $11,000, and a budget amendment is requested to recognize the additional revenue to offset expenses for Administrative Overhead, Legal Services and Printing, for which there is no budget appropriation; and WHEREAS the Drain Commissioner is requesting a budget amendment to transfer $81,448 from the Drain Equipment Fund to the Motor Pool Fund and budget $9,000 in Vehicle Rental Revenue and Motor Pool Expense for the replacement of three owned vehicles with three leased vehicles; and WHEREAS the Health and Human Services Department is requesting $60,000 for laboratory renovations at Golden Oaks, which is required to accommodate new bio-hazard testing equipment, with funding available from the Bioterrorism Grant; and WHEREAS the Health Division requests to transfer $80,894 from the Health Bio-terrorism grant to the Information Technology fund to develop and implement a web application that will allow for the public to pre-register for flu shots prior to the 10/21/06 flu clinics. The project includes 821 IT development hours to develop a database, prepare equipment, and provide technical support to all clinic sites on October 21, 2006, as well as help the Health Division properly staff flu clinic locations; and WHEREAS the Information Technology Department is requesting to use $17,080 in funds from Information Technology Net Assets - Unrestricted for additional cameras for the building interior to provide adequate security as part of continuing efforts of the Facility Security Project; and Planned Use of Fund Balance Transfer Out to Info Tech Fund Total General Fund $845,000 $845,000 0 WHEREAS as part of the initiation of the Wellness Program, a budget amendment in the amount of $3,900 within the Fringe Benefit Fund, is recommended to host a Wellness Fair to be held September 15, 2006, which will be recovered in fees charged for lunches and materials; and WHEREAS a budget amendment in the amount of $45,309 is required in the Central Services Aviation and Transportation Division to correct budget amendment per MR #06123 (as approved by the Board July 20, 2006), which overstated funding for replacement of contracted services with PTNE positions; and WHEREAS the following amendments are recommended to the Information Technology Fund: $219,300 - To appropriately reflect software and Professional Services needs of the implementation of the IT Service Center. $562,702 - To appropriate funds from IT-Net Assets Unrestricted- Designated to continue implementation of BS&A Tax Migration, Central Services Datebase Upgrage, and Jury System Upgrade projects through 9/30/06. $479,757 - To appropriate funds from IT Fund Equity to Professional Services line-item relating to resources for the PeopleSoft Phase II, BS&A and eHealth projects; professional services offset by revenue billable to the project. $337,733 - To appropriate funds for equipment replacement purchases completed after the FY 2005 appropriation per M.R. #05218; funding is available in the IT Fund Net Assets-Designated for Projects; and WHEREAS a budget amendment is recommended to reappropriate allocations for Information Technology Operations (Schedule C), Telephone Communications (Schedule D) and Radio Communications (Schedule E) to various departments based on projected annualized actuals; and WHEREAS an amendment is recommended to the Information Technology Fund to appropriate funds in the amount of $845,000 for workstation replacements necessary for the XP upgrades and mainframe replacement to ensure functionality for operations, and funding is available in the General Fund Designated Fund Balance (#371448), which was originally designated $3,500,000 for FY 2006; and WHEREAS a transfer in the amount of $223,012 is requested to the Information Technology Fund from the Major Departmental Project Fund to cover costs incurred for technical resources committed to support the PeopleSoft and OutlookSoft environment through the end of 9/30/06. WHEREAS Section 25 of the General Appropriations Act requires that the Board of Commissioners receive a quarterly report regarding adjustments made to Inmate Accounts on transactions billed in excess of ability to pay. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2006 Third Quarter Financial Report. BE IT FURTHER RESOLVED that the budget amendments detailed on attached Schedule A, B, C, D, and E are approved. BE IT FURTHER RESOLVED that $845,000 from the Future Technology Replacement Designated Fund Balance account be appropriated as follows: GENERAL FUND (#10100) Revenue 9010101-196030-665885 Expenditure 9010101-989999-788001-63600 Planned Use of Fund Balance $223,012 Transfer Out to Info Tech Fund $223,012 INFORMATION TECHNOLOGY FUND (#63600) Revenue 1080101-989999-695500-10100 Transfer In from General Fund Expenditure 1080601-152010-750154 Expendable Equipment Expense Total Info Tech Fund $845,000 $845,000 $_ BE IT FURTHER RESOLVED that $223,012 from the Major Departmental Project Fund be appropriated to the Information Technology Fund as follows: MAJOR DEPARTMENTAL PROJECT FUND (#42000) Revenue 9016001-152130-665882 Expenditure 9016001-989999-788001-63600 Total Major Dept'l Proj Fund $ 0 INFORMATION TECHNOLOGY FUND Revenue 1080101-989999-695500-42000 Expenditures 1080601-152010-731458 1080701-152020-731458 (#63600) Transfer In-Major Dept'l Proj Fund $223,012 Professional Services Professional Services Total Expenditures Total Info Tech Fund $103,012 120,000 $223,012 0 Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE 2,A COUNTY MICHIGAN DEPARTMENT OF MANAGEMENT AND BUDGET Laurie Van Pelt, Director Wm. Art Holdsworth, Deputy Director (if COAKLAND; L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE TO: Members of the Finance Committee FROM: Laurie Van Pelt, Director, Management and Budget Art Holdsworth, Deputy Director, Management and Budget Tim Soave, Manager, Fiscal Services Nancy Fournier, Chief, Fiscal Services LaVerne Smith, Supervisor of Fiscal Services SUBJECT: Letter of Transmittal - Fiscal Year 2006 Third Quarter ForEcast Report DATE: August 17, 2006 FY 2006 FORECAST Attached please find the Fiscal Year (FY) 2006 Third Quarter Forecast Report. In total, Fiscal Services forecasts -that the County will complete Fiscal Year 2006 with overall favorability of $10,243,583 in General Fund! General Purpose (GF/GP) operations. GF/GP includes all operations except grants, enterprise funds and internal service funds. This overall favorability is split between receiving $4,313,617 more revenue than anticipated and expending $5,929,966 less than budgeted. Due to the large number of amendments that were approved by the Board of Commissioners on July 20, 2006, this letter will address restated variances (the 8th column on the Summary by Department schedule). Please note that the backup worksheets tie to the June 30, 2006 financial statements (5 th column on the Summary by Department schedule.) which do not include the 2" quarter forecast amendments. REVENUES Forecasted GF/GP revenues are estimated to be 0.91% more than budget or $4,313,617. The majority of the favorability is the result of the following events: A. GENERAL FUND — INVESTMENT INCOME - Favorable: $1,338,749 (restated from $4,117,000) • Increase in investment earnings due to interest rates and investment base. Original forecast of $4,117,000 has been updated to include amendment of S2,778,251 for a revised forecasted favorability of $1,338,749. B. GENERAL FUND —CHARGES FOR SERVICES —Favorable: $1,985,103 (restated from $2,045,703) • Revenue received by District Courts is expected to be favorable a total of $927,800 mostly due to Ordinance and Fines and Drug Treatment fees and Probation Fees due to increased cases. • Charges for Services revenue is forecasted to be favorable $1,075,000 in the Clerk's/Register of Deeds Office from a continuance of activity and increased value of properties affecting Land Transfer Tax, which will be favorable $1,000,000 and Forfeiture of Surety bonds which will be favorable $190,000, misc, other favorability partially offset by unfavorability of ($100,000) for recording fees. • The Treasurer's Office anticipates favorability of $342,700 mostly due to fees collected for management of investments. • Overall forecast of Sheriff's revenue is expected to be favorable $4,500. This is the net result of favorability in numerous programs such as Bullet proof vest grant - $200,000, board and care regarding state parole detainers — $80,000, reimbursement of deputy salaries — $50,000, Social Security incentive payments - $40,000, adjustment of prior year's charges, SCAAP grant and gun permits which is basically offset by unfavorable board and care revenue at satellite facilities (475,000). Several other areas report favorable and unfavorable variances. EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC MI 48341-0409 • (248) 858-2163 • FAX (248) 858-9172 1 • Revenue for environmental programs at the Drain Commissioner's office is forecasted to be unfavorable ($128,155). A budget amendment is recommended to reduce the revenue budget and offsetting expenditure budget. • Children's Village revenue is forecasted as unfavorable ($300,000) due to overestimation of placement of wards from other Michigan counties. • Although Economic Development revenue for the No HAZ program is expected to be unfavorable ($100,000), it will be offset by favorable expenses. C. GENERAL FUND — STATE GRANTS - Favorable: $714,685 (restated from $1,494,665) • The Child Care Subsidy from the State is expected to be favorable $920,000 due to the significant number of State ward cases. This is partially offset by some unfavorability in expenses for private institutions. A budget amendment was approved with the 2n d quarter forecast which was not posted by 6/30/06 to recognize $780,000 in additional revenue. Another amendment is recommended. Funding for the Health Division is expected to be unfavorable $205,335 at year end for Public Health programs. D. GENERAL FUND — INTERGOVERNMENTAL GENERAL REIMBURSEMENT - Favorable: $597,000 • Distribution from the State for Cigarette Tax is higher than anticipated, $28,000. Also, State court reimbursement is favorable $569,000: the budget anticipated an decrease in funding by the state which did not materialize. EXPENDITURES In total, expenditures are estimated to be 1.24% less than budget or ($5,929,966), mostly as a result of personnel turnover in numerous departments. This is partly offset by unfavorable contractual expenses. The only department that is projected to be unfavorable at the end of the fiscal year (barring any amendments) is: Public Services. A. PUBLIC SERVICES — linfavorability of ($19,750) is forecasted mostly the result of additional operating costs in Animal Control for medical supplies due to caseload increase. A budget amendment is recommended to transfer $20,000 from Population Control and Education fund to help cover sterilization costs. Prosecuting Attorney Expenditures 4010101 122050 4010101 122050 4010101 122050 4010101 122050 Sheriff Department Expenditures 4030201 112580 4030601 110000 4030301 112620 4030301 989999 731213 731339 732158 730688 772618 722618 731402 788001 BOC / Library Board Expenditures 5010301 165000 5010301 165000 5010301 165000 5010302 165020 5010301 112690 5010301 112690 5010301 112690 5010301 165020 702010 722740 774636 750154 702010 722740 774636 750168 $ (4,000.00) 4,000.00 (20,000.00) 20,000.00 $ (296,224.00) 296,224.00 (370,611.00) 370,611.00 56,170.00 30,602.00 2,325.00 1,750.00 (56,170.00) (30,602.00) (2,325.00) (1,750.00) SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2006 AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct 52-4 District Court Expenditures 3020201 121020 750168 3020201 121020 750154 3020201 113290 750168 3020201 113290 750154 3020301 121020 750168 3020301 121020 750154 3020401 121020 750168 3020401 121020 750154 3020501 121020 750168 3020501 121020 750154 Fund Aff. Account Name 52 -1 FA Expendable Equipment Expense $ (2,217.00) 52 -1 Expendable Equipment Expense 2,217.00 52 -1 FA Expendable Equipment Expense (739.00) 52 -1 Expendable Equipment Expense 739.00 52-2 FA Expendable Equipment Expense (4,101.69) 52-2 Expendable Equipment Expense 4,101.69 52 - 3 FA Expendable Equipment Expense (4,000.00) 52 - 3 Expendable Equipment Expense 4,000.00 52 - 4 FA Expendable Equipment Expense (1,500.00) 52 -4 Expendable Equipment Expense 1,500.00 Total Expenditures Membership Dues Periodicals Books Publications Subs Witness Fees and Mileage Expert Witness Fee and Mileage Total Expenditures Admin - Equipment Rental Patrol Svcs - Equipment Rental Prisoner Housing-Out 21130 Transfer Out to Jail Pop. Fund Total Expenditures Salaries Fringes Information Technology Operations Expendable Equipment Expense Salaries Fringes Information Technology Operations FA Expendable Equipment Expense Total Expenditures Drain Commissioner Revenue 6010101 174450 631827 Expenditures 6010101 6010101 6010101 6010101 6010101 6010101 174450 174450 174450 174450 174450 174450 730373 731213 750294 750567 732137 732144 Salaries Regular Medical Supplies Construction Equipment Maintenance Printing Professional Services Custodial Supplies Housekeeping & Janitor Uniforms 114000 702010 114000 750301 114000 730352 114000 730646 114000 731388 114000 731458 114000 750063 114000 750231 114000 750581 $ 17,700.00 $ 17,700.00 $ (8,500.00) 8,500.00 $ (30,000.00) 25,000.00 5,000.00 $ 20,000.00 $ (23,750.00) 18,900.00 5,000.00 500.00 5,000.00 9,600.00 2,000.00 2,000.00 750.00 $ 20,000.00 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GE/GP) FY 2006 AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS Reimbursement General Contracted Services Membership Dues Material and Supplies Training - Educational Supplies Rouge River Watershed Council PNTRSP for Saginaw River WSD Total Expenditures $ (115,000.00) $ (20,000.00) (31,792.00) (28,755.00) (30,000.00) (2,177.00) (2,276.00) $ (115,000.00) M & B - Purchasing Division Revenue 1020401 182090 631743 Refunds Miscellaneous Expenditure 1020401 182090 712020 Overtime Total Facilities Management-Admin / Facilities Engineering Expenditures 1040801 148020 722740 1040101 140000 722740 Economic Development & Community Affairs - PEDS Expenditures 1090201 171115 730205 1090201 171115 731458 1090201 171000 750119 Public Services - Animal Control Division Revenue 1070801 989999 695500 21315 Transfer In from Animal Pop. and Ed. Fund Expenditures 1070801 1070801 1070801 1070801 1070801 1070801 1070801 1070801 1070801 Total Expenditures Facilities Engineering - Fringe Benefits Facilities Management Admin - Fringe Ben. Total Expenditures PEDS - Business Recruitment PEDS - Professional Svcs. PEDS - Dry Goods & Clothing Total Expenditures SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2006 AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Revenues 9010101 196020 955385 Expenditures 1040101 140000 730093 Non-Department - income from Investments $ 7,500.00 Facilities Mgmt Admin - Appraisal Fees $ 7,500.00 Total Expenditures $ 7,500.00 GENERAL PURPOSE Child Care Fund (#20293) Revenue 9010101 196020 615359 Child Care Subsidy $ 950,000.00 Expenditures 1060102 135000 730919 Human Svcs Admin Independent Living $ 170,984.00 1060102 135000 731409 Human Svcs Admin - Priv. Inst. Foster Care 585,001.00 1060102 135000 731416 Human Svcs Admin - Priv. Inst. Residential 194,015.00 Total Expenditures $ 950,000.00 FY 2006 AMENDMENTS $ 5,487,441.00 (5,487,441.00) $ 54,382.00 (54,382.00) $ 79,832.00 (79,832.00) $ 1,334.00 (1,334.00) Transfer In from General Fund Grant Match Total Revenues 695500 10100 620467 $ 3,500,000.00 11,000.00 $ 3,511,000.00 Income From Investments Premium on Bond Sales Total Revenues Transfer In from General Fund Contingency Total $ 370,611.00 370,611.00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Friend of the Court - Fund #27100 Revenues 3010404 989999 695500 10100 3010404 121100 620467 Total Revenues Circuit Court Adult Drug Court - SCAO - Fund #27130 Revenues 3010301 989999 695500 10100 3010301 121200 620467 Circuit Court -Juvenile Drug Court - SCAO - Fund #27140 Revenues 3010402 989999 695500 10100 3010402 121200 620467 695500 10100 Transfer In from General Fund 615571 Grants State Total Revenues Drug Court - SCAO - Fund #27160 Transfer In from General Fund Grant Match Transfer in from General Fund Grant Match Total Revenues Transfer in from General Fund Grant Match Total Revenues 52-1 District Court - Drug Court - SCAO - Fund #27150 Revenues 3020201 989999 3020201 121050 52-4 District Court - Revenues 3020301 989999 3020301 121050 $ 94,466.00 (94,466.00) Jail Population Fund (#21130) Revenue 4030301 989999 695500 10100 Expenditure 4030301 112620 730359 Delinquent Tax Revolving Fund (#51600) Revenue 7010110 186050 655385 7010110 186050 697219 Expenditures 7010110 186050 7010110 186050 7010110 186050 730065 731073 731388 Administrative Overhead Legal Services Printing Total Expenditures Change in Fund Equity $ 15,000.00 50,000.00 1,200.00 $ 66,200.00 $ 3,444,800.00 FY 2006 AMENDMENTS j SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER IPROPRIFTARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Drain Equipment Fund (#63900) Revenues 6010201 149750 632401 Expenditures 6010201 149750 776661 6010201 989999 788001 Motor Pool Fund (#66100) Revenues 1030811 184010 631071 1030811 989999 695500 26466 Vehicle Rental Total Revenue 26466 Motor Pool 66100 26466 Transfer Out to Motor Pool Total Expenditures Change in Fund Equity Leased Equipment 63900 Transfer in from Drain Equip. Fund Total Revenues $ 9,000.00 $ 9,000.00 $ 9,000.00 81,448.00 $ 90,448.00 $ (81,448.00) $ 9,000.00 81,448.00 $ 90,448.00 Expenditure 1030811 184010 761156 Depreciation Vehicles $ 9,000.00 Change in Fund Equity $ 81,448.00 Health Bioterrorism Fund (#28605) - Grant #gr0000000277 Expenditures 1060290 115140 730373 Contracted Services $ (140,894.00) 1060290 989999 788001 63900 Transfer Out to IT Fund 80,894.00 1060290 989999 788001 40400 Transfer Out to Project Wrk Order 60,000.00 Total Expenditures - Project Work Order Fund (#40400) - Project #100000000918 Revenue 1040101 989999 695500 Change in Fund Equity $ 60,000.00 Information Technology Fund (#63600) Expenditure 1080101 989999 788001 40400 Transfer Out to Project Wrk Order $ 17,080.00 Change in Fund Equity $ (17,080.00) Project Work Order Fund (#40400) - Project #100000000439 Revenue 1040101 989999 695500 63600 Transfer in from Info Tech Fund $ 17,080.00 Change in Fund Equity 17,080.00 28605 Transfer in from Bioterrorism Fund $ 60,000.00 Fringe Benefits Fund (#67800) Revenue 9011501 183192 535860 Expenditures 9011501 183192 731458 9011501 183192 732165 9011501 183192 775667 9011501 183192 776666 Gen FB Rev - Ext. Wellness Rev. $ 3,900.00 Wellness Program - Profess. Svcs Wellness Program - Wrkshops & Mtgs Wellness Program - Mailroom Wellness Program - Print Shop Total Expenditures 2,000.00 700.00 500.00 700.00 $ 3,900.00 $ 45,309.00 (41,428.00) (3,881.00) County Airport Fund (#56500) Expenditures 1030701 154010 731171 1030701 154010 702010 1030701 154010 722740 Management Services Salaries Regular Fringe Benefits Total Expenditures $ 80,894.00 $ 80,894.00 $ 219,300.00 (219,300.00) 532,386.00 14,080.00 15,595.00 641.00 411,089.00 68,668.00 337,733.00 $ 1,380,192.00 $ (1,299,298.00) SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2006 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2006 AMENDMENTS ACCOUNT NUMBER PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Information Technology Fund (#63600) Expenditures 1080101 989999 695500 28605 1080101 152010 731458 1080101 152010 731773 1080201 152010 731458 1080201 152010 731773 1080201 152010 750154 1080201 152010 750413 1080201 152010 731458 1080701 152030 731458 1080601 152010 750154 Transfer from Bioterrism Grant Total Revenues Professional Services Professional Services Professional Services Software Purchases Expendable Equipment Expense Parts and Accessories Professional Services Professional Services Expendable Equipment Expense Total Expenditures Change in Fund Equity Page 1 of 2 • 63600 InfoTech 774636 ISF monthly charges 3QFY06 Reallocation1.xls SCHEDULE C Fund Acct Affiliate Info Tech Operatio 774636 ISF Charges Budget to Actuals by Fund: GF/GP Fund Dept Dept Title 10100 1010101 County Executive Admin 10100 1010105 County Executive Exec Support 10100 1010115 Emer Response and Preparedness 10100 1010201 Auditing Administration 10100 1010501 Corporation Counsel 10100 1020401 Purchasing Administration 10100 1020501 Equalization Administration 10100 1020501 Equalization Administration 10100 1020601 Fiscal Services Administration 10100 1020701 Reimbursement 10100 1030803 Supp Svc Record Retention Mail 10100 1030803 Supp Svc Record Retention Mail 10100 1030850 Supp Svc Mats Mgt and Printing 10100 1040101 Facilities Management Admin 10100 1040801 Facilities Engineering Admin 10100 1050401 Human Resources General Admin 10100 1070301 Veterans Services Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070401 Community Corrections Admin 10100 1070501 MSU Extension Administration 10100 1070510 MSU Ext Natural Sciences 10100 1070601 Medical Examiner Admin 10100 1070801 Animal Control Administration 10100 1070901 Circuit Court Probation 10100 1070901 Circuit Court Probation 10100 1090101 Economic Dev and Comm Affairs 10100 1090101 Economic Dev and Comm Affairs 10100 1090105 Econ Dev Waste Resource Mgt 10100 1090201 Planning and Econ Dev Admin 10100 1090204 Ping Economic Dev Planning 10100 1090701 Workforce Development Admin 10100 2010201 County Clerk Administration 10100 2010201 County Clerk Administration 10100 2010205 County Clerk Vital Statistics 10100 2010210 County Clerk Legal Records 10100 2010301 Elections Administration 10100 2010401 Register of Deeds Admin 10100 2010501 Jury Commission Administration 10100 3010101 Circuit Court Judicial Admin 10100 3010201 Circuit Court Court Business 10100 3010201 Circuit Court Court Business 10100 3010301 Circuit Court Civil Criminal 10100 3010301 Circuit Court Civil Criminal 10100 3010301 Circuit Court Civil Criminal 10100 3010301 Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Family Div Admin Circuit Court Family Div Admin Circuit Court Family Div Admin Circuit Court Family Court Srv Circuit Court Family Court Srv Program Program Title 181000 General Executive Services 774636 181000 General Executive Services 774636 115090 Emergency PreparednessERP 774636 181010 General Audit Services 774636 181020 County Legal Services 774636 182090 General Procurement 774636 173010 Contract Assessor Support 774636 173020 RP-Leave Time 774636 182020 Fiscal Services Admin 774636 126020 Reimbursement Admin 774636 184020 Mail Room Operations 774636 184030 General Support Services 774636 184030 General Support Services 774636 140000 Fac Mgmt Administration 774636 148020 Project Mgmt-Engineering 774636 183010 HR Administration 774636 132050 Client Services 774636 113000 Community Corrections Admin 774636 113010 PTS Adm 774636 113020 PTS Supervision 774636 113050 Community Based Prog Adm 774636 113060 WAM 774636 113080 Step Forward Admin 774636 113140 SF Results 774636 174000 MSU Administrative Services 774636 174160 Master Gardener 0/H 774636 132030 Medical Examiner Services 774636 114000 Animal Control Aaministrative 774636 113270 Pontiac Supervision 774636 113280 Troy Supervision 774636 171000 CD Administrative Services 774636 171070 Automation Alley 774636 174230 Solid Waste Planning 774636 171000 CD Administrative Services 774636 172040 CD Community Consultations 774636 170010 Contract Administration 774636 125000 Court Records Management 774636 180000 Clerk ROD Administration 774636 132300 General Services 774636 125000 Court Records Management 774636 185010 Election Services 774636 172190 Land Records Management 774636 125000 Court Records Management 774636 121100 Circuit Ct Administration 774636 121100 Circuit Ct Administration 774636 121110 JIMS 774636 121110 JIMS 774636 121120 General Judges 774636 121130 General Support Staff 774636 121140 Assignment 774636 121160 Criminal Case Support 774636 121180 Jury Operations 774636 121190 Legal 774636 121220 Cir Ct Family Support Staff 774636 121100 Circuit Ct Administration 774636 121210 Circuit Ct Family Judges 774636 121220 Cir Ct Family Support Staff 774636 111000 Youth Assistance 774636 121100 Circuit Ct Administration 774636 Proposed Account Title Amendment Info Tech Op 0.00 Info Tech Op 4,200.00 Info Tech Op 0.00 Info Tech Op (3,640.00) Info Tech Op (15,438.00) Info Tech Op (1,885.00) Info Tech Op 0.00 Info Tech Op (791.00) Info Tech Op 0.00 Info Tech Op 0.00 Info Tech Op (1,567.00) Info Tech Op (2,663.00) Info Tech Op (2,552.00) Info Tech Op (6,881.00) Info Tech Op (1,695.00) Info Tech Op (20,976.00) Info Tech Op (4,206.00) Info Tech Op 9,892.00 Info Tech Op 3,506.00 Info Tech Op 254.00 Info Tech Op (9,170.00) Info Tech Op (6,319.00) Info Tech Op 9,372.00 Info Tech Op (3,987.00) Info Tech Op (17,354.00) Info Tech Op (11,779.00) Info Tech Op (14.413.00) Info Tech Op (2,512.00) Info Tech Op 0.00 Info Tech Op (2,247.00) Info Tech Op (26,344.00) Info Tech Op (19,875.00) Info Tech Op (4,650.00) Info Tech Op 10,828.00 Info Tech Op (2,426.00) Info Tech Op 211.00 Info Tech Op (75,374.00) Info Tech Op 7,836.00 Info Tech Op 31,214.00 Info Tech Op 11,612.00 Info Tech Op (5,659.00) Info Tech Op 43,508.00 Info Tech Op (2,043.00) Info Tech Op 2,440.00 Info Tech Op (38,495.00) Info Tech Op (5,986.00) Info Tech Op (2,197.00) Info Tech Op (8,655.00) Info Tech Op (25,775.00) Info Tech Op (1,900.00) Info Tech Op (3,304.00) Info Tech Op 95.00 Info Tech Op (5,544.00) Info Tech Op 98,184.00 Info Tech Op (2,789.00) Info Tech Op (8,883.00) Info Tech Op (5,851.00) Info Tech Op (3,904,00) Info Tech Op 455.00 Dept 1010101 1010105 1010115 1010201 1010501 1020401 1020501 1020501 1020601 1020701 1030803 1030803 1030850 1040101 1040801 1050401 1070301 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070501 1070510 1070601 1070801 1070901 1070901 1090101 1090101 1090105 1090201 1090204 1090701 2010201 2010201 2010205 2010210 2010301 2010401 2010501 3010101 3010201 3010201 3010301 3010301 3010301 3010301 10100 3010301 10100 3010301 10100 3010301 10100 3010301 10100 3010401 10100 3010401 10100 3010401 10100 3010402 10100 3010402 Prepared by Fiscal Svcs. 08/14/06 Dept 3010402 3010402 3010402 3010403 3010403 3010403 3010403 3010403 3010403 3020201 3020205 3020301 3020305 3020401 3020405 3020501 3020505 3040101 3040101 3040101 3040403 3040403 3040403 4010101 4010101 4030101 4030301 5010101 5010301 5010301 5010301 5010302 5010303 6010101 7010101 9010101 9010101 9090101 Fund 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 20221 1060201 Health Administration 20221 1060211 Health Central Support 20221 1060220 Health Environmental Health 20221 1060231 Health Personal and Preventive 20221 1060233 Health CHPIS 20221 1060234 Health Clinic 20221 1060236 Health Field Nursing Total Public Health Exp 20221 9090101 Transfer from General Fund Change in Fund Equity 133150 Health Administration 774636 133150 Health Administration 774636 134390 General Environmental Health 774636 133150 Health Administration 774636 133390 General Health Promotion 774636 133990 General Clinic Services 774636 133390 General Health Promotion 774636 989999 transfers Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op 695500 10100 Transfers In Page 2 of 2 63600 InfoTech 774636 ISF monthly charges 3QFY06 Reallocationtxls Info Tech Operatio 774636 ISF Charges Budget to Actuals by Fund: GF/GP Program 135060 135070 135080 121100 121200 121230 121240 121250 135080 121020 113290 121020 113290 121020 113290 121020 113290 121060 121070 121080 121080 124010 135050 122050 135170 112580 112590 180010 112690 165000 165010 165020 165040 155010 186040 989999 989999 196030 Account Title Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech OP Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op Info Tech Op 20221 Transfers Out 20293 Transfers Out Contingency Dept Title Circuit Court Family Court Srv Circuit Court Family Court Srv Circuit Court Family Court Srv CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support District Court I Admin District Court I Probation District Court II Admin District Court II Probation District Court III Admin District Court III Probation District Court IV Admin District Court IV Probation Probate Court Administration Probate Court Administration Probate Court Administration Probate Estates and Mental Hth Probate Estates and Mental Hth Probate Estates and Mental Hth Prosecuting Attorney Admin Prosecuting Attorney Admin Sheriff Sheriffs Staff Sheriff Corrective Serv Admin Board of Commissioners Admin Library Board Research Library Library Board Research Library Library Board Research Library BOC Library Bd Law Library Library Board Administration Drain Commissioner Admin Treasurer Administration Transfer to Public Health Transfer to Child Care Fund Non Dept Transfers Total General Fund Expenditures Fund Program Title Acct Affiliate Casework Services 774636 Clinical Services 774636 Adoptions 774636 Circuit Ct Administration 774636 Circuit Ct Drug Court 774636 Juvenile Referee Services 774636 Juvenile SUp10011 Services 774636 PPO Services 774636 Adoptions 774636 District Court Operations 774636 Probation 774636 District Court Operations 774636 Probation 774636 District Court Operations 774636 Probation 774636 District Court Operations 774636 Probation 774636 Prob Ct Family Judges 774636 Prob Ct Family Support Staff 774636 Pr Ct Administrative Services 774636 Pr Ct Administrative Services 774636 Probate Services-Estates 774636 Probate Services-Guardianshp 774636 General Prosecution Victim Services Sheriff Administration Corrections Admin Board Administration Jail Library Research Library LVPI Law Library Library Administration Drain Administration Trees Administrative services transfers transfers non dept contingency Proposed Amendment (7,856.00) (7,580.00) 163.00 (27,357.00) 2233.00 (1,673.00) (9280.00) (123.00) (7,280.00) (49,699.00) (2,049.00) 12,662.00 (3,564.00) (40,199.00) (1,246.00) (2,491.00) (9,994,00) 40,149.00 (17,332.00) (7,338.00) 193,533.00 (113,380.00) (24.00) (36,291.00) (252.00) 589.00 0.00 (1,239.00) 0.00 0.00 0.00 0.00 0.00 0,00 52,388.00 4,820.00 (10,071.00) 195,903.00 0.00 36,363.00 (59.00) (28,250.00) (1,754.00) (1,372.00) (34.00) (74.00) 4,820.00 4,820.00 0.00 774636 774636 774636 774636 774636 774636 774636 774636 774636 774636 774636 774636 788001 788001 730359 20293 1060501 20293 9090101 Childrens Village Admin Transfer from General Fund Change in Fund Equity 112090 General CV Operations 989999 transfers 774636 Info Tech Op 695500 10100 Transfers In (10,071.00) (10,071.00) 0.00 Prepared by Fiscal Svcs. 08/14/06 SCHEDULE D sage 1 of 3 67500 Telephone 778675 ISF monthly charges 3C)FY06 Reallocationtxls Telephone Commt 778675 ISF Charges Budget to Actuals by Fund: GF/GP Fund 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 Dept 1010101 1010115 1010201 1010501 1020101 1020401 1020501 1020501 1020601 1020601 1020701 1030101 1030802 1030803 1030803 1030850 1040801 1050401 1050501 1060101 1070301 1070401 1070401 1070401 1070401 1070501 1070601 1070801 1070801 1070801 1070901 1070901 1090101 1090101 1090105 1090105 1090108 1090201 1090701 2010101 2010101 2010201 2010201 2010301 2010401 3010101 3010201 3010201 3010201 3010301 3010301 3010301 3010301 3010301 3010301 3010301 Dept Title County Executive Admin Emer Response and Preparedness Auditing Administration Corporation Counsel Management and Budget Admin Purchasing Administration Equalization Administration Equalization Administration Fiscal Services Administration Fiscal Services Administration Reimbursement Central Services Admin Support Services Food Svc Supp Svc Record Retention Mail Supp Svc Record Retention Mail Supp Svc Mats Mgt and Printing Facilities Engineering Admin Human Resources General Admin HR Compensation and Benefits Health and Human Svc Admin Veterans Services Admin Community Corrections Admin Community Corrections Admin Community Corrections Admin Community Corrections Admin MSU Extension Administration Medical Examiner Admin Animal Control Administration Animal Control Administration Animal Control Administration Circuit Court Probation Circuit Court Probation Economic Dev and Comm Affairs Economic Dev and Comm Affairs Econ Dev Waste Resource Mgt Econ Dev Waste Resource Mgt Econ Dev Marketing and Comm Planning and Econ Day Admin Workforce Development Admin Clerk Register of Deeds Admin Clerk Register of Deeds Admin County Clerk Administration County Clerk Administration Elections Administration Register of Deeds Admin Circuit Court Judicial Acimin Circuit Court Court Business Circuit Court Court Business Circuit Court Court Business Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Program 181000 115090 181010 181020 182010 182090 173020 186030 182020 182040 126020 184000 184030 184020 184030 184030 148020 183010 183010 133150 132050 113000 113010 113050 113080 174000 132030 114000 114090 132020 113270 113280 171000 171070 174230 174240 171030 171000 170010 125000 180000 125000 180000 185010 172190 121100 121100 121110 121240 121100 121110 121120 121130 121140 121150 121160 Program Title General Executive Services Emergency PreparednessERP GF- County Legal Services Mgmt Bdgt Administrative Srv General Procurement RP - Leave Time Central Support Fiscal Services Admin Financial Planning Reimbursement Admin CS Administrative Services General Support Services Mail Room Operations General Support Services General Support Services Project Mgmt-Engineering HR Administration HR Administration Health Administration Client Services Community Corrections Admin PIS Adm Community Based Prog Adm Step Forward Admin MSU Administrative Services Medical Examiner Services Animal Control Administrative Kennel Operations PS Administrative Services Pontiac Supervision Troy Supervision CD Administrative Services Automation Alley Solid Waste Planning No Haz ED Marketing Services CD Administrative Services Contract Administration Court Records Management Clerk ROD Administration Court Records Management Clerk ROD Administration Election Services Land Records Management Circuit Ct Administration Circuit Ct Administration JIMS Juvenile Support Services Circuit Ct Administration JIMS General Judges General Support Staff Assignment Mediation Criminal Case Support Account 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 Account Title Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Prepared by Fi Proposed Amendment (15,242.00) (10,849.00) 2,130.00 2,220.00 633.00 968.00 (380.00) 17,105.00 6,467.00 70.00 2,556.00 492.00 61.00 (491.00) 324.00 (123.00) 6,215.00 2,897.00 599.00 26.00 944.00 (26,383.00) 3,430.00 6,441.00 16,126.00 4,861.00 4,648.00 480.00 66.00 16.00 7,878.00 6.00 607.00 48.00 958.00 65.00 1,201.00 (7,769.00) 109.00 80,808.00 (73,746.00) (1,668.00) 1,439.00 1,025.00 45.00 5,043.00 2,968.00 (222.00) 132.00 2,105.00 41.00 9,553.00 2,198.00 1,732.00 (361.00) 44,00 -15- scal Svcs. 08/14/06 Telephone Commt 778675 ISF Charges Budget to Actuals by Fund: GF/GP Fund Dept Dept Title 10100 3010301 10100 3010301 10100 3010301 10100 3010401 10100 3010401 10100 3010401 10100 3010402 10100 3010402 10100 3010402 10100 3010402 10100 3010402 10100 3010402 10100 3010403 10100 3010403 10100 3010403 10100 3010403 10100 3010403 10100 3010403 10100 3020201 10100 3020301 10100 3020401 10100 3020501 10100 3040101 10100 3040101 10100 3040403 10100 4010101 10100 4010101 10100 4010101 10100 4010101 10100 4010201 10100 4010201 10100 4030101 10100 4030201 10100 4030201 10100 4030301 10100 4030301 10100 4030301 10100 4030350 10100 4030401 10100 4030401 10100 4030401 10100 4030401 10100 4030401 10100 4030505 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 Program 121180 121190 121200 121100 121210 121220 111000 121100 121200 135060 135070 135080 121100 121140 121230 121240 121250 135080 121020 121020 121020 121020 121060 121090 124010 122000 122030 122050 135170 122020 122080 112580 112580 112680 112590 112620 112630 112630 112590 112660 113370 113380 121280 116230 110000 110010 110020 116180 116181 116200 110010 110040 110060 110090 112580 116240 Program Title Jury Operations Legal Circuit Ct Drug Court Circuit Ct Administration Circuit Ct Family Judges Cir Ct Family Support Staff Youth Assistance Circuit Ct Administration Circuit Ct Drug Court Casework Services Clinical Services Adoptions Circuit Cl Administration Assignment Juvenile Referee Services Juvenile Support Services PPO Services Adoptions District Court Operations District Court Operations District Court Operations District Court Operations Prob Ct Family Judges Judicial Services Probate Services-Estates Prosecutor Administration Criminal Sexual Assault General Prosecution Victim Services Prosecutor Auto Theft Pros Narcotic Enforcement Sheriff Administration Sheriff Administration Sheriff Records Management Corrections Admin Main Jail Housing Jail Clinic Jail Clinic Corrections Admin Court Detention Trusty Camp Work Release Court Security Emergency Communications Law Enforcement Admin Traffic Control Alcohol Enforcement Contract Enforcement Parks Marine Safety Traffic Control LE Support Serv Admin General Investigations Sheriff Narcotics Enforcement Sheriff Administration Laboratory Analysis Account 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Civil Criminal Circuit Court Family Div Admin Circuit Court Family Div Admin Circuit Court Family Div Admin Circuit Court Family Court Srv Circuit Court Family Court Srv Circuit Court Family Court Srv Circuit Court Family Court Srv Circuit Court Family Court Srv Circuit Court Family Court Srv CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support CC Family Crt Judicial Support District Court I Admin District Court II Admin District Court III Admin District Court IV Admin Probate Court Administration Probate Court Administration Probate Estates and Mental Hth Prosecuting Attorney Admin Prosecuting Attorney Admin Prosecuting Attorney Admin Prosecuting Attorney Admin Prosecuting Atty Litigation Prosecuting Atty Litigation Sheriff Sheriffs Staff Sheriff Admin Serv Admin Sheriff Admin Serv Admin Sheriff Corrective Serv Admin Sheriff Corrective Serv Admin Sheriff Corrective Serv Admin Sheriff Jail Health Program Sheriff Corr Ser Sat Adm Sheriff Corr Ser Sat Adm Sheriff Corr Ser Sat Adm Sheriff Corr Ser Sat Adm Sheriff Corr Ser Sat Adm Sheriff SEPTC Training Sheriff Patrol Services Sheriff Patrol Services Sheriff Patrol Services Sheriff Patrol Services Sheriff Patrol Services Sheriff Patrol Services Sheriff Technical Svc Admin Sheriff Technical Svc Admin Sheriff Technical Svc Admin Sheriff Technical Svc Admin Sheriff Technical Svc Admin Sheriff Technical Svc Admin Page 2 of 3 67500 Telephone 778675 ISF monthly charges 3QFY06 Reallocation txls Account Title Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Prepared by Fis Proposed Amendment 1,048.00 639.00 6.00 1,533.00 (488.00) 1,902.00 2,512.00 11.00 33.00 5,256.00 2,946.00 740.00 (722.00) 33.00 (278.00) 1,713.00 62.00 99.00 3.393.00 (226,00) 8,695.00 3,296,00 33.00 (321.00) 818.00 8,700.00 21.00 1,369.00 512.00 326.00 (466.00) 489.00 2,785.00 262.00 4,616.00 322.00 320.00 235.00 (708.00) 448.00 437.00 931.00 327.00 (2,137.00) 282.00 (3,901.00) 67.00 (25,994.00) 195.00 (1,313.00) 33.00 71,123.00 3,419.00 4,628.00 34.00 1,691,00 cal Svcs. -16- 08/14/06 Program 110070 180010 165000 165020 155010 174250 186060 989999 989999 196030 Program Title Foc Investigations Board Administration Research Library Law Library Drain Administration Soil Erosion Program Personal Property Non Dept Operations Non Dept Operations Non Dept Transfers Account 778675 778675 778675 778675 778675 778675 778675 788001 788001 730359 Account Title Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm 20221 Transfers Out 20293 Transfers Out contingency Proposed Amendment 0.00 886.00 154.00 786.00 180.00 3,442.00 3,225.00 20,345.00 4,553.00 (195,903.00) 0.00 133150 133150 133120 133130 133150 134390 133150 134850 133370 133390 133990 133970 133150 133190 133200 133390 133300 133310 133290 133330 134410 134790 Health Administration Health Administration Lab X-Ray Health Administration General Environmental Health Health Administration Dental Community Nutrition General Health Promotion General Clinic Services TB Health Administration Maternal Infant Support Serv Infant Mortality Reduction General Health Promotion Hearing Vision Child Health Conference Services to the Aging MaternalChild Outreach_Enr SA Admin - Treatment 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 778675 Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm Telephone Comm 989999 Non Dept Transfers 695500 10100 Transfer In 112090 General CV Operations 112210 CV School Services 113310 Intensive Probation 778675 778675 778675 Telephone Comm Telephone Comm Telephone Comm 989999 Non Dept Transfers 695500 10100 Transfer In Page 3 of 3 67500 Telephone 778675 ISF monthly charges 3QFY06 Reallocationl .xls Telephone Commt 778675 ISF Charges Budget to Actuals by Fund: GF/GP Fund Dept Dept Title 10100 4030925 Sheriff FOC 10100 5010101 Board of Commissioners Admin 10100 5010301 Library Board Research Library 10100 5010302 BOC Library Bd Law Library 10100 6010101 Drain Commissioner AdmIn 10100 6010301 Drain Comm Engineering 10100 7010101 Treasurer Administration 10100 9010101 Transfer to Public Health 10100 9010101 Transfer to Child Care 10100 9090101 Contingency Total General Fund Expenditures 20221 1060201 Health Administration 20221 1060211 Health Central Support 20221 1060212 Health Laboratory 20221 1060213 Health X Ray 20221 1060214 Health Central Health Services 20221 1060220 Health Environmental Health 20221 1060231 Health Personal and Preventive 20221 1060232 Health Dental 20221 1060233 Health CHPIS 20221 1060233 Health CHPIS 20221 1060234 Health Clinic 20221 1060235 Health TB Control 20221 1060236 Health Field Nursing 20221 1060236 Health Field Nursing 20221 1060236 Health Field Nursing 20221 1060236 Health Field Nursing 20221 1060237 Health Hearing and Vision 20221 1060237 Health Hearing and Vision 20221 1060238 Health Outreach 20221 1060239 Health Svc to Aging 20221 1060245 Health Assurance and Advocacy 20221 1060261 Health Substance Abuse Total Public Health Expenditures 20221 9090101 Transfer from General Fund Change in Fund Equity 20293 1060501 Childrens Village Admin 20293 1060555 Child rens Village School 20293 3010402 Circuit Court Family Court Srv Total Child Care Expenditures 20293 9090101 Transfer from General Fund Change in Fund Equity 2,469.00 1,604.00 182.00 64.00 30.00 (924.00) 222.00 45.00 (724.00) 777.00 4,888.00 391.00 (153.00) (80,955.00) (1,720.00) 94,205.00 133.00 67.00 1,200.00 (667.00) (1278.00) 489.00 20,345.00 20,345.00 0.00 2,904.00 498.00 1,151,00 4,553.00 4,553.00 0.00 Prepared by Fiscal Svcs. 08/14/06 -17- SCHEDULE E Radio Communic4 777560 ISF Charges Budget Actuate by Fund: GF/GP Fund Dept Dept Title 10100 1010115 Emer Response and Preparedness 10100 1070801 Animal Control Administration 10100 3010403 CC Family Crt Judicial Support 10100 4010101 Prosecuting Attorney Admin 10100 4010201 Prosecuting Atty Litigation 10100 4010201 Prosecuting Atty Litigation 10100 4030201 Sheriff Admin Serv Admin 10100 4030301 Sheriff Corrective Serv Admin 10100 4030401 Sheriff Corr Ser Sat Adm 10100 4030510 Sheriff SEPTC Communications 10100 4030601 Sheriff Patrol Services 10100 4030601 Sheriff Patrol Services 10100 4030901 Sheriff Technical Svc Admin 10100 4030901 Sheriff Technical Svc Admin 10100 9010101 Non Dept Transfer to Public Health 10100 9010101 Non Dept Transfer to Child Care Total General Fund Expenditures Program Program Title 115090 Emergency PreparednessERP 114100 Animal Control Road Patrol 121240 Juvenile Support Services 122050 General Prosecution 122030 Criminal Sexual Assault 122040 Domestic Violence 112580 Sheriff Administration 112620 Main Jail Housing 121280 Court Security 116230 Emergency Communications 110000 Law Enforcement Admin 116200 Marine Safety 110040 LE Support Serv Admin 110090 Sheriff Narcotics Enforcement 989999 Transfers 989999 Transfers Fund Account Affiliate 777560 777560 777560 777560 777560 777560 777560 777560 777560 777560 777560 777560 777560 777560 788001 20221 788001 20293 Proposed Account Title Amendment Radio Communications 19,576.00 Radio Communications 17,348.00 Radio Communications 826.00 Radio Communications 4,579.00 Radio Communications 377.00 Radio Communications 377.00 Radio Communications (11,329.00) Radio Communications 7,202.00 Radio Communications (2,920.00) Radio Communications 16,384.00 Radio Communications (22,022.00) Radio Communications (3533.00) Radio Communications (63,636.00) Radio Communications (10,635.00) Transfers out 10,520.00 Transfers out 36,886.00 0,00 20221 1060220 Health Environmental Health 20221 9090101 non dept transfer from GF Change in Fund Equity 134390 General Environmental Health 777560 989999 Transfers Radio Communications 10,520.00 10.520.00 0.00 695500 10100 Transfers in Radio Communications 20293 1060501 Childrens Village Admin 20293 9090101 non dent transfer from GF Change in Fund Equity Net change 112090 General CV Operations 989999 Transfers 777560 695500 10100 Transfers in 36,886.00 36.886.00 0.00 0.00 FY 2008 FORECAST AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT MAJOR AMENDMENTS RESTATED POSTED AFTER VARIANCES 6/30/2006 FAVAUNFAV) PLANNED USE OF FUND BALANCE (1) 681,515 00 TOTAL GF/GP FUNDS $ 468,311,447.00 $ 6,618,364.21 $ 6,618,364.21 476,322,660.21 $ 485,015,128.21 $0.00 0.00% 1.82% $ $0.00 4,378,851.00 $ 4,313,617.00 8,692,468.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT FY 2006 ADOPTED BUDGET REVENUES GENERAL FUND Taxes $ 314,648,160.00 Special Assessments 110,000.00 Federal Grants 570,713.00 State Grants 14,479,430.00 Intergovernmental General Reimbursement 9,118,000.00 Charges for Services 89,493,480.00 Indirect Cost Recovery 9,000,000.00 Investment Income 2,012,000.00 Other Revenues 28,198,149.00 SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 467,629,932 00 BUDGET AS AMENDED $ 314,648,160.00 110,000.00 535,523.00 14,641,246.00 9,342,627.00 89,704,380.00 9,000,000 00 2,145,661.00 29,576,799.00 $ 469,704,296.00 $ 314,948,160,00 $ 300,000.00 0.10% $ 300,000.00 174,600.00 64,600.00 58.73% 64,600.00 586,523.00 50,000.00 9.34% 50,000.00 16,135,911.00 1,494,665.00 10.21% 780,000.00 714,665.00 9,939,527.00 597,000.00 6.39% 597,000.00 91,750,083.00 2,046,703.00 2.28% 60,600.00 1,985,103.00 9,000,000.00 - 0.00% - 6,262,661.00 4,117,000.00 191.88% 2,778,251.00 1,338,749.00 29,500,299.00 23,500.00 0.08% 760,000.00 (736,500.00) $ 478,396,764.00 $ 8,692,468.00 1.85% $ 4,378,851.00 $ 4,313,617.00 $ 46,338,692.00 $ 50,504,266.67 16,376,938.00 16,636,895.03 5,851,916.00 5,916,212.17 $ 68,567,544.00 $ 73,057,373.87 17,629,909.00 117,510,229.00 $ 135,140,138.09 18,337,069.68 119,362,299.77 $ 137,699,369.45 $ 836,235.00 $ (485,100.00) 203,100.00 179,400.00 $ (102,600.00) 379,135.00 457,100.00 18,716,204.68 119,819,399.77 $ 138,535.604 45 $ 50,989,366.67 16,433,795.03 5,736,812.17 $ 73,159,973.87 122.473,561.00 $ 114,520,333.89 $ 468,311,447.00 $ 476,322,660.21 $ 474,771,545.21 $ 1 551 115 00 0.33% $ 4 378 851.00 $ 5 929 966.00 $ ..nnn/ General Fund/General Purpose Favorable/(Unfavorable) 10,243,5133.00 $ 10 243 583.00 $ 10,243 583.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT FY 2006 ADOPTED BUDGET BUDGET AS AMENDED FY 2906 FORECAST AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT MAJOR AMENDMENTS RESTATED POSTED AFTER VARIANCES 6/30/2006 FAVAUNFAV) EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN. OF JUSTICE LAW ENFORCEMENT Prosecuting Attorney Sheriff TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Drain Commissioner TOTAL GENERAL GOVERNMENT COUNTY EXECUTIVE County Executive Minn. Management and Budget Central Services Facilities Management Human Resources Health and Human Services Public Services Economic Dew. and Comm Affairs TOTAL COUNTY EXECUTIVE TOTAL DEPARTMENTS NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS TOTAL GOVERNMENTAL EXPENDITURES 11,205,962.00 3,448,592.00 2,894,239.00 2,521,558.00 5,014,410.00 25,084,761.00 8,055,084.00 20,324,301.00 2,419,153.00 1,587,507 00 4,368,446.00 57,825,204.00 15,635,112.00 6,830,536.00 $ 117,045,343.00 $ 345,837,786.00 11,657,676.54 3,682,435.68 2,986,079.45 2,531,923.86 6,167,913.77 $ 27,026,029.30 $ 8,015,400 02 21,549,164.54 2,523,642.60 1,587,721.47 4,679,302.56 60,105,635.31 16,704,859.42 8,017,592.78 123,183,318.70 361,802,326.32 11,099,176.54 3,591,835 68 2,877,379.45 2,520,023.86 6,091,724.77 $ 26,180,140.30 $ 7,998,900.02 21,103,364.54 2,519,342.60 1,511,621.47 4,649,002.56 60,003,135.31 16,795,209.42 7,201,892.78 $ 121,782,468.70 $ 358,821,952.32 $ 115,949,592.89 558,500.00 90,600.00 108,700.00 11,900.00 76,189.00 845,889.00 16,500.00 445,800 00 4,300.00 76,100.00 30,300.00 102,500.00 (90,350.00) .815,700.00 1,400,850.00 2,980,374.00 -0.96% $ 1.22% 3.03% -0.14% $ 2.03% 0.38% 0.60% $ 4.79% 2.46% 3.64% 0.47% 1.24% 3.13% $ 0.21% $ 2.07% 0,17% 4.79% 0.85% 0.17% -0.54% 10.17% 1.14% 0.82% $ 805,000.00 $ 319,900.00 203,100.00 60,000.00 239,400.00 865,000.00 $ 762,400.00 379,135.00 457,100.00 $ 836,235 00 8,600.00 567,100.00 90,600.00 108,700.00 11,900.00 76,189.00 8,600.00 $ 854,489.00 18,000.00 $ 34,500 00 (8,000.00) 437,800.00 4,300.00 76,100 00 30,300.00 102,500.00 70,600.00 (19,750.00) 20,000.00 835,700,00 100,600.00 $ 1,501,450.00 974,200.00 $ 3,954,574.00 3,404,651.00 $ 1,975,392.00 $ (1,429,259.00) -1.25% $ (1) Note that report forecasts Planned Use of Fund Balance with a zero variance in order to show a balanced budget. No revenue will actually be received. Amended Budget FY 2006 Forecast Amount Favorable (unfavorable) Percent Explanation of Significant Variances $ 237,365,584.00 $ 77,153,076.00 328,000.00 101,500.00 101500.00 $ 314,648,160,00 $ 314,948,160.00 0.00% 0.00% 1071_43% Reflects actual collections of taxes, interest on taxes, tax adjustments, tax sale and proceeds from auction. 0.00% 0.10% 300,000.00 $ 300,000.00 $ 237,365,584.00 77,153,076.00 28,000.40 0.00% 0.00% Superbowl $1,325 and Hurricane Katrina $2,508 reimbursement. -4.30% Reduction of State public health funding (LPHO) of $205,335.0ffset by decreased expenditures.* 17.53% Based on increased expenditures in recent years. Cap is $13.7 mil. Partially offset by increase in experiditures.* 10,21% Cigarette Tax distribution based on actual sales. State court reimb. did not decrease as anticipated. $ 161,739.00 3,833.00 4,775,674.00 9,700,000.00 $ 161,739.00 3,833.00 4,570,339.00 11,400,000.00 - $ (205,335.00) 1,700,000.00 $ 14,641,246.00 $ 16,135,911.00 $ 1,494,665.00 $ 9,342,527.00 $ 9,939,527.00 $ 597,000.00 174,600.00 $ 64,600.00 58.73% Fay due to rising volume of Payment in Lieu of Taxes, 174,600.00 $ 64,600.00 68,000.00 $ 0.00% 51,984.00 $ 0.00% 50,464.00 0.00% (Uri fav.) ($9,000) due to reduction in Emergency Management Program Grant offset by additional funding from the Hazardous Materials Emergency Planning Grant from the State for off-site response plan approved by the MSP, plus supplemental funding ($140 for each plan) based upon remaining state funds Fay. $9,000. 120,075.00 0.00% 295,000.00 50,000.00 20.41% Favorable Refund-School Meals due to higher population count which is currently at 86% capacity vs one year ago the population was 77%. 585,523.00 $ 50,000.00 9.34% 110,000.00 $ 110,000.00 $ 150,000.00 $ 49,000.00 110,000.00 $ 110,000.00 68,000.00 $ 51,984.00 $ 50,464.00 126,713.00 245,000.00 120,075.00 245,000.00 570,713.00 $ 535,523.00 $ Total Intergov't Gen. Reimb. Rev. g BARGES FOR SERVICES (625000-635999) Administration of Justice Circuit Court - Civil/Criminal $ 9,118,000.00 $ 9,342,527.00 $ 9,939,527.00 $ 597,000.00 3,322,190.00 $ 3,322,190.00 $ 3,514,690.00 $ 192,500.00 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT TAXES (601000-601999) Property Taxes - 2005 Tax Levy Property Taxes - Revenue Sharing Other Taxes - Delinquent Tax - Prior Years Other Taxes - Trailer Tax Total Taxes SPECIAL ASSESSMENTS (605000-605999) Treasurer Total Special Assessments FEDERAL GRANTS (610000-610999) Sheriff - Patrol Sheriff - Corrective Services County Executive - EHP Health Division Children's Village Total Federal Grants STATE GRANTS (615000-615999) Sheriff - Patrol County Executive - ERP Health Division Outside Agencies - Child Care Subsidy Total State Grants INTERGOVT GEN. REIMB. REV. (620000-620999) Non-Departmental Adopted Budget $ 237,365,584.00 77,153,076.00 28,000.00 101,500.00 $ 314,648,160.00 $ 4,779,430.00 9,700,000.00 $ 14,479,430.00 $ 9,118,000.00 5.79% Fay $63,100 in Paid Defense Atty. Fee revenue due to increasing caseload. better collections and collection recovery percentage; and $500 collection of unbudgeted Reimbursement of Court Services; $75,000 increase in Jury Fee reimbursement collections due to higher volume of jurors used to reduce backlog in untried cases; $60,000 in Costs revenue due to increase in volume of cases heard; $1,200 in DNA Testing; partially offset by ($7,300) reduction in Video Copying requests. • Revenue variance is partially offset by an expenditure variance. District Court - Division IV Probate Court - Judicial Support Total Administration of Justice Law Enforcement Prosecuting Attorney Sheriffs Office Sheriff - Administrative Services COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT Amount Adopted Amended FY 2006 Favorable Budget Budget Forecast funfavorablel Percent Explanation of Significant Variances Circuit Court - Family Division 1,700,050.00 1,700,050.00 1,867,950.00 167,900.00 9.88% Fay $86,800 due to increased receipt of Board and Care revenues attributable to Increased caseloads of children as County wards; $85,100 Refund of Paid Defense Attorney Fee due to better collections and increase in court appointed attorney's; partially offset by ($4,000) reduction in number of DNA Testings ordered. District Court - Division I 3,728,600.00 3,730,933.00 3,950,933.00 220,000.00 5.90% Fay $149,100 Ordinance Fines and Costs; $60,000 Filing Fees DCU; $6,100 Garnishment Fees; $20,000 Forfeiture of Bonds; $5,000 Drug Treatment Court Fee; $4,200 Drunk Driving Caseflow/DDCAF; Drug Case Management $900; and Marriage Fees of $900, all due to increasing caseload and volume of activity; partially offset by lower No Proof of Insurance Fee ($3,200); License Reinstatement Fees ($10,300), and Probations Fees of ($12,700) also based on recent volume of activity. District Court - Division ll 1,808,785.00 1,821,838.00 2,311,238.00 489,400.00 26.86% Fav in multiple line items all due to increasing caseload and recent expansion of jurisdiction (White Lake, and Rose Twp.) and rising volume of activity. The largest favorability is occurring in Probation Fees $194,000 State Law Cost of $128,000 Ordinance Fines and Costs of $75,000 Refund Paid Def. Atty. Fees of $49,600 Filing Fees/DCLI of $25,000 Assessments & PSI $7,000 Late Penalty of $5,000 Drunk Driving Caseflow/DDCAF of $7,000 Garnishment Fees of $4,000 late Penalty of $5,000; partially offset by Court Cost Sobriety of ($17,100). District Court - Division III 4,345,476_00 4,364,476.00 4,430,376.00 65,900.00 1.51% Fay $18,800 in Filing Fees/DCU; Late Penalty's of $14,500; State Law Cost of $22,100; Drunk Driving Casellow of $7,800; Bond Fees 10% of $1,700 and Court Cost Sobriety of $1,000 due to rising caseload and filings. 2,141,860.00 2,145,985.00 2,298,485.00 152,500.00 7.11% Fav $100,000 Ordinance Fines and Costs; $21,000 Miscellaneous; $10,500 Drunk Driving Caseflow (see res. #06150 adjusting amended budget and eliminating Drug Treatment Court Fee variance); Drug Treatment Court Fee of $50,000; No Proof of Insurance Fee of $6,000; Partially offset by Filing Fees/DCU of ($35,000), all variances are due to increasing caseload, recent experience and volume of activity. 525,300.00 525,300.00 567,100.00 41,800.00 7.96% Fay $30,000 Certified Copies due to increasing volume of certified documents; $400 Objections, $100 Marriage Ceremony, and $900 CVR County Portion;$10,000 Gross Estate Fees; $5,000 Refund Fees PD Def Atty; $1,500 Statement & Proof of Claim; $1,000 Will Deposits; and Motion Fees of $600; Application & Admin. Fee of $300 all due to increasing volume of caseload activity. Partially offset ($4,000) Account Filings Probate, ($4,000) Misc. Petitions. $ 17,572,261.00 $ 17,610,772.00 $ 18,940,772.00 $ 1,330,000.00 213,700.00 $ 213,700.00 $ 209,800.00 $ (3,900.00) -1.82% Unfavorable Welfare Fraud Case Review due to the reduction of cases received from the State. 81,600.00 81,600.00 134,6013.00 53,000.00 64.95% Favorable $40,000 from Social Security Incentive Payments due to an increase in the reporting of inmates receiving social security from the federal government, $8,000 from Misc. Fee receipts and $5,000 from County Auction proceeds due to higher than anticipated activity. 10,000.00 75,100.00 85,600.00 10,500.00 13.98% Favorable $15,000 in Fingerprint Revenue due to an increase in the number of Gun Permits being requested, $1,000 in Registration Fees due to a new state law requiring sex offenders to pay a fee to register with local law enforcement and $500 from Misc. revenue. Partially offset by ($6,000) unfavorable in Photostats due to report/document requests being less than anticipated. • Revenue variance is partially offset by an expenditure variance. Sheriff - Corrective Services Sheriff - Corrective Services Satellites Sheriff - Emer. Prep. Training & Communication Sheriff - Patrol Services Sheriff - Technical Services Total Law Enforcement COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT Amount Adopted Amended FY 2006 Favorable Budget Budget Forecast funfavorablel Percent Explanation of Significant Variances 3,352,129.00 2,953,000.00 3,139,500.00 186,500.00 6.32% Favorable $80,000 in Board and Care due to State payment for Parole Detainers being higher than anticipated, $50,000 in Reimb Salaries from Deputies being assigned to work on reimbursed contracts, $20,000 in Clinic Charges due to higher than anticipated recovery. $30,000 in Grants Federal due to SCAAP Reimbursement being higher than anticipated, Miscellaneous Fees $2,000, Transportation of Prisoners $2,000 due to higher than anticipated cost recovery and OUIL Third Offense $15,000 as the result of an increase in drunk driving arrests. Partially offset by ($1,500) in Dental Service Fees and ($8,000) in Hospital Cost Recovery from a change in State Law that places restitution recovery from inmates before these items. Fee Income ($3,000) is less than anticipated. 2,061,864.00 2,510,958.00 1,995,958 00 (515,000.00) -20.51% Unfavorable ($475,000) in Board and Care from inmates in the satellite facilities lacking the ability to pay as well as the facilities not being at capacity and ($40,000) in Reimb Court Services from an overestimate in contract revenue during the budget process. 300,000.00 300,000.00 300,000.00 0.00% 29,687,624.00 29,649,864.00 29,855,864.00 206,000.00 0.69% Favorable $2,500 from Inspection of Boat Livery due to an increase in the number of requested inspections, $3,000 in Federal Operating Grants due to higher than budgeted funding from the Bullet Proof Vest Grant, $200,000 in Reimb Salaries due to Overtime billed under patrol contracts with CVT's and $500 from Donations. 201,000.00 181,291.00 244,791.00 63,500.00 35.03% Favorable $19,000 in Refund Prior Years Exp. from a credit in Overtime and Radio expenses charged to the General Fund rather than the FOC Fund, $67,000 in Reimb Salaries due to additional NE t Overtime Reimbursement, $1,000 in Miscellaneous from restitution recovered from offenders and $1,000 from Refunds NET due to drug "buy" money being fully utilized. Partially offset by unfavorable ($10,000) from Refund Forensic Lab Fees due to state reimbursement payments being less than anticipated, ($14,000) in Gun Registrations from a decline in gun permits being issued at the end of the fiscal year and ($500) in Confiscated Property. $ 35,907,917.00 $ 35,965,513.00 $ 35,966,113.00 $ 600.00 General Government Clerk - County Clerk $ 2,471,500.00 2,485,420.00 $ 2,652,420.00 $ 167,000.00 6.72% Favorable $190,000 from Forfeiture of Surety Bonds due to one large bond being forfeited, $11,000 from Gun Permits as a result of the annual renewal processing fee, $22,000 from Marriage Waivers due to a change in law that permits a waiver (for a fee) to the 3 day waiting period, $22,000 in Photographs from the increase in Gun Permits and Passports, $25,000 in Photostats and $56,000 in Certified Copies due loan increase in the number of requested copies and $6,000 in Passport Fees due to an anticipated change in Federal Law requiring passports for travel to Canada and Mexico. Offset by an unfavorable ($135,000) in Forfeiture of Bonds, ($15,000) in Assumed Names, ($13,000) in Marriage Licenses and ($2,000) in Co Partnership New Fees. • Revenue variance is partially offset by an expenditure variance. Adopted Budget 128,475.00 Amended FY 2006 Budget Forecast 180,975.00 214,975.00 14,004,000.00 14,004,000.00 14,878,000.00 3,037,280 00 3,037,280 00 3,379,980.00 8,000.00 8,000.00 7,200.00 31,80(100 31,800.00 38,500.00 1,876,928,00 1876,928.00 1,748,773.00 Treasurer Board of Commissioners Library Board Drain Commissioner fetal General Government County Executive County Exec - Administration County Exec - ERP County Exec - Auditing M&B - Purchasing Division M&B - Equalization Division M&B - Reimbursement Central Services - Support Services Human Resource Human Services - Health Division 75,150.00 2,498,701.00 421,000.00 184,000.00 18,800.00 2,646,537.00 151,500.00 68,500.00 35,500.00 $ 21,557,983.00 50,150 00 2,389,028.00 343,500.00 165,000.00 18,800.00 2,610,879 00 151,500.00 $ 68,500.00 35,500.00 $ 21,624,403.00 $ 50,150.00 2,427,401.00 343,500.00 165,000.00 18,800.00 2,610,879,00 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT Clerk - Elections Clerk - Register of Deeds Amount Favorable (unfavorable) Percent Explanation of Significant Variances 34,000.00 18.79% Favorable $10,000 from Board of Canvasser Service Fee due to the May School Election, August Primary and the addition of canvassing for West Bloomfield Township, $4,000 in Voter Registration Application due to an increase in the number of voter registrations processed that are eligible for state reimbursement, $19,000 from Nominating Filing Forfeitures due to an increase in the number of candidates paying the filing fee rather than circulating petitions and $1,000 in Photostats due to a larger volume of document requests. 874,000.00 6.24% Favorable $1,000,000 in Land Transfer Tax from an increase in the value of properties being sold in the county, $8,000 in Chattel Mortgages due to an Increase in the number of property foreclosures, $10,000 in Photostats due to an increase in the number of copies being requested. Partially offset by an unfavorable ($100,000) in Recording Fees due to a decrease in refinancing activity and ($4,000) in Plat Service Fees due to an increase in site condominiums versus platted subdivisions, ($20,000) in Tract Index Fees due to an increased use of Access Oakland to obtain the information and ($20,000) in Fed Tax Liens due to a delay in payment from the Federal Government. 342,700.00 (800.00) 6,700.00 (128,155.00) 11.28% Fav $335,000 Administration Fees collected for mgmt. of investments for other county funds; and $8,800 Alternate Energy receipts; $3,000 Supplemental Warrants; Obsolete Property of $700; partially offset by unfav ($4,800) May Tax Sale receipts replaced by PA 123. -10.00% Lower than anticipated Per Diems in Revenue. A direct offset to Per Diem Expenditures 21.07% Fav. $Misc Revenue $12,100 (Copies made from Computer using a debit card), offset by Unfav, Copier Machine Charges ($5,400). -6.83% Unfav - Plat Service Fees ($2,500) decrease in business activity resulting in less fees being collected. Unfav - Reimb. General ($115,000) decrease in Environmental Unit revenue to be offset by expense items based on third quarter Budget Amendment. Unfav - Reimbursement Personal Mileage ($12,500) but offset by favorable personal mileage expense. 22,919,848.00 $ 1,295,445.00 151,500.00 $ 68,000.00 62,000.00 0.00% (500.00) -0.73% (Unfav.) due to instructors providing their own airway bags and supplies. 26,500.00 74.65% Favorable $25,000 in Reimb Salaries for audit of COBG grant. At budget time this grant was not expected to continue and $1,500 in Class Fees due to higher than anticipated participation. 25,000.00 49.85% Fay. Refund Revenue from vendors. 71,300.00 2.94% Actual Billings for work performed for FY 2006. 77,500.00 22.56% Fay. Board/Care $41,000, Reimb Contracts $6,800, Filing Fees $1,400 and Tax Intercept Fees $30,300. All this due to a concerted effort to collect on open accounts receivable. 19,000.00 11.52% Increased vending sales 0.00% 35,658.00 1.37% (Unfav.) Laboratory Charges ($146,000), due to loss of the OC Jail Account and MCF being 3/4 full. Also, (Unfav.) in On-site Sewage ($88,650), Subdivision Control Plats ($6,685) and Well Permits Type II ($111,118), due to slow construction this spring and summer offset by Favorable Flu-3rd Party $319,637 and Flu Vaccine Fees $61,789. • Revenue variance is partially offset by an expenditure variance. Amount Adopted Amended FY 2006 Favorable Budget Budget Forecast (unfavorable) 2,664,942.00 2,664,942.00 2,364,942_00 (300,000.00) 380,000.00 380,000.00 500,000.00 120,000.00 Human Services - Children's Village Public Services - Community Corrections Public Services - MSU Extension 64,100.00 64,100.00 51,100.00 (13,000.00) Public Services - Medical Examiner 910,200 00 920,200.00 983,800.00 662,385.00 662,385.00 311,625 00 311,625.00 INVESTMENT INCOME (655000-6559991 District Courts (Div. 1- IV) Clerk/Register of Deeds Non-Departmental Total Investment Income OTHER REVENUES 1670000-6955001 Prosecuting Attorney Sheriff Office $ 10,000.00 $ 10,000.00 $ 15,000.00 $ 5,000.00 2,000.00 2,000.00 114,000.00 112,000.00 2,000,000.00 2,133,661.00 6,133,661.00 4,000,000.00 $ 2,012,000.00 $ 2,145,661.00 $ 6,262,661.00 $ 4,117,000.00 132,839.00 135,839.00 $ 135,839.00 $ 31,000.00 615,650.00 635,650.00 20,000.00 32,000.00 32,000.00 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT Percent Explanation of $1gnificant Variances -11.26% (Unfav.) Out County Board and Care due to wards of other counties not being placed at Children's Village as estimated. 31_58% Increase in Testing Fee revenues as a result of referral of former clients back Into the program. Increased revenue of $120,000, more than offsets the increase in expenditures of $42,000." Budget amendment approved MR06150 not yet posted. -20.28% Unfav. Reimb Postage ($4,000) due to a reduction in postage reimbursement from Michigan State University. Also, Unfav. in Reimbursement General ($9,000) due to the Master Woodland Training not being offered because it was offered on campus at MSU and the Master Gardener Public/Info not offered this year because of program restructuring. 63,600 00 6.91% Fay. Cremation Revenues $3,000 due to increased caseload. A budget amendment per the FY 2006 2nd quarter Financial Forecast to appropriate $60,600 to the MEO Laboratory Fees account, and offsetting MED revenue increase was not posted as of the closing for month 9. Public Services - Animal Control Economic Dev. & Comm. Affairs - Administration Economic Dor. & Comm. Affairs - PEDS Total County Executive Non-Departmental Non-Dept - Charges for Services - Sundry Nun-Dept - Intergov't Frog Rev - Judges Salaries Total Non-Departmental Total Charges for Services INDIRECT COST RECOVERY (1140100) 682,385 00 20,000.00 3.02% Fay. Transfer of revenue from the Animal Population and Education Fund (21315) into the General Fund. See Expenditure offset • 130,025.00 (181,600.00) -58.28% Unfav. Reimbursement of costs for NO HAZ recycling program ($100,000) reflecting consolidation of collection events. This is offset by program costs (mostly Professional Services) which will be less than budget.* Unfav. Reimbursement of Salaries of Automation Alley Coordinator position ($81,600), which no longer provides services to AA (unfav. is largely offset by fay. Salaries). Reduced Sale of Maps caused by local economic downturn. $ 11,026,109.00 $ 11,074,482.00 $ 10,961,440.00 $ (113,042.00) $ 1,400,000,00 $ 1,400,000.00 $ 1,000,000.00 $ (400,000.00) -28.57% Less Sundry revenue than previous years 2,029,210.00 2,029,210.00 1,961,910.00 (67,300.00) -3.32% $ 3,429,210.00 $ 3,429,210.00 $ 2,961,910.00 $ (467,300.00) $ 89,493,480.00 $ 89,704,380.00 $ 91,750,083.00 $ 2,045,703.00 2.28% $ 9,000,000.00 $ 9,000,000.00 $ 9,000,000.00 $ • 0.00% 200,000.00 200,000.00 123,500.00 (76,500.00) -38.25% 50.00% Fay due to rising interest rates on investments. 5600.00% Favorable due to several years of accumulated interest being credited this fiscal year. 187.47% Higher than anticipated interest rates. Budget amendment approved per MR 06150 not yet posted. Another budget amendment is recommended for FY 2006. 191.88% 0.00% 3.25% Favorable $20,000 in Enhancement Funds due to fund transfers being higher than anticipated. Enhancement funds cover canine program, forensic lab and one time projects. Non-Dept - Donations • Revenue variance is partially offset by an expenditure variance. COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2006 THIRD QUARTER REPORT Amount Adopted Amended FY 2006 Favorable Budget Budget Forecast (unfavorable' Percent Explanation of Significant Variances Treasurer 2,353,101.00 2,353,101.00 2,353,101.00 - 0.00% Emergency Response and Preparedness 5,000,00 5,000.00 12,000.00 7,000.00 140.00% Favorable due to sale of thunderbolt sirens. Support Services - Materials Management 8,000.00 6,000.00 2,500.00 (3,500.00) -58.33% Based on auction revenue credited to Support Services. All other revenues received from auction is credited to various participating departments. Library Board Non-Dept - Sundry Total Other Revenues 27,209.00 27,209.00 27,209.00 0.00% 25,843,000.00 26,402,000.00 26,402,000.00 0.00% Transfers in from other funds. $ 28,198,149.00 29,576,799.00 29,600,299.00 $ 23,500.00 0.08% PLANNED USE OF FUND BALANCE (665000-665999) General Fund - Prior Years Balance 681,515.00 Total Planned Use of Fund Balance $ 681,515.00 6,618,364.21 $ 6,618,364.21 $ 6,618,364.21 6,618,364.21 0.00% Budget transition, carry forwards and encumbrances and projects funded by designations. 0.00% TOTAL GEN. FUND! GEN. PURPOSE REVENUE $ 468,311,447.00 $ 476,322,660.21 $ 485,015,128.21 $ 8,692,468.00 1.82% • Revenue variance is partially offset by an expenditure variance. $ 8,147,009.00 $ 8,187,565.55 $ 8,167,165.56 $ 20,400.00 0.25% Turnover. 37,216.00 169,017.47 144,917.47 24,100.00 1426% Fav. Expendable Equipment Expense $20,000 and Office Supplies reflective of recent history of expenditures. 184,474.00 289,310.99 291,610.99 (2,300.00) -0.79% Unfav. due to Print Shop reflective of the cost of computer and copier $ 8,368,699.00 $ 8,645,894.01 $ 8,603,694.01 $ 42,200.00 0.49% $ 1,975,165.00 $ 1,965,084.08 $ 1,965,084.08 $ 0.00% 29,500.00 33,791.66 30,291.66 3,500.00 10.36% Fav Data Processing Developing $1,600 reflective of reduced need for this service, now done by in house computers, and Equipment Repairs and Maintenance $2,300 required on an as needed basis, repairs have been negligible over the last four years; partially offset by Personal 313,636.00 334,836.69 334,836.69 0.00% $ 2,318,301.00 $ 2,333,712.43 $ 2,330,212.43 $ $ 2,307,857.00 $ 2,297,217.00 $ 2,291,517 00 $ 5,988,171.00 5,876,231.15 5,700,331.15 2,076,465.00 6,029,543.00 6,029,543.00 0.00% $ 10,372,493.00 $ 14,202,991.15 $ 14,021,391.15 $ 181,600.00 1.28% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Civil / Criminal Division Personnel Expenditures Operating Expenditures Internal Support Expenditures 3,500.00 0.15% 5,700.00 0.25% Turnover. 175,900.00 2.99% Fav due to continued decrease in Attorney Fees Mediation $125,000, Court Transcripts $5,000 Defense Atty Fees $5,000, Transcripts on Appeal $20,000, Expert Witness Fees & Mileage $13,000, Visiting Judge $29,700 services not required; partially offset by increased use of Interpreter Fees ($10,000), unbudgeted refund of Prior Yrs. Rev. ($2,800), Equipment Repairs & Maintenance ($4,000), and mail See related revenue offset. 8716/2006 $ 25,259,279,00 16,765,498.00 4,313,915.00 $ 46,338,692.00 $ 25,279,199.00 $ 12,829,248.00 $ 12,807,061.34 $ 12,603,861.34 $ 10,710,611.00 10,714,970.88 11,630,570.88 1,739,340.00 $ 50,504,266.67 $ 25,256,927.97 16,794,011.16 8,453,327.54 $ 25,321,669.08 1,799,636.86 1,799,636.86 0.00% _ $ 26,034,069.08 $ (712,400.00) -2.81% $ 25,027,627.97 $ 229,300.00 0.91% 17,506,111.16 (712,100.00) -4.24% 8,455,621.54 (2,300.00) -0.03% $ 50,989,366.67 $ (485,100.00) -0.96% 203,200.00 (915,600.00) 1.59% Turnover. -8.55% Unfav. due to increased use of private institutions ($600,000) to house children declared wards of the County by Family Court; and Indirect Cost ($180,000) assessed by the State of Michigan on Child Care Fund reimbursement billings. A budget amendment was approved with the 2nd Qtr. Fcst., ref. resolution #06150. Prof. Svcs. of ($90,500) for child psychological evaluations ordered by judges, Interpreter Fees of ($16,000) due to increase need reflective of changing demographics, Fees Guardian Ad-Litem of ($60,000) due to increased number of children declared wards of the County by Family Court needing a court Budget amendments were approved July 20 by BOC and posted after the close of June business. * COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2006 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures 8/16/2006 * See related revenue offset. 50.02% 7.80% 0.00% 87,600.00 4,900.00 Division 1 - Novi Personnel Expenditures Operating Expenditures $ 3,785,379.00 $ 3,785,986.29 $ 3,726,786.29 $ 993,357.00 991,024.00 991,624.00 Internal Support Expenditures 494,733 00 533,727.70 533,727.70 Total Division 1 - Novi $ 5,273,469 00 $ 5,310,737.99 $ 5,252,137.99 $ Division 2 - Clarkston Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 1,690,071.00 $ 1,697,553.49 $ 1,607,653.49 $ 586,304.00 551,390.69 551,390.69 195,031.00 317,273.57 318,073.57 000% 28,400.00 7.07% Division 3- Rochester Hills Personnel Expenditures Operating Expenditures $ 3,685,141.00 $ 3,689,092.84 $ 3,689,092.84 $ 374,423.00 401,646.26 373,246.26 Fay due to lower demand for Defense Atty. Fees for court appointed attorneys, partially offset by increased use of Juror Fees & Mileage, Training Psych.& Med. Exams, Charge Card Fees. -2.05% 2.03% -1.30% -0.03% 1.22% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures $ 175,143.00 $ 175,143.00 $ 87543.00 $ Operating Expenditures 62,800.00 62,800.00 57,900.00 Internal Support Expenditures - Fay due to Magistrate position. Budget based on incorrect authorized hours. Fay. due to reduced use of Visiting Judge expense. $ 237,943.00 $ 237,943.00 $ 145,4.43.00 $ 92,500.00 38.87% 59,200.00 1.56% - Turnover. (600,00) -0.06% - Unfav due to Increased need for interpreter fees, and drug testing reflective of changing demographics in Novi, and need for drug testing. 0.00% 58,600.00 1.10% 89,900.00 5.30% - Turnover. 0.00% - (800.00) Unfav due to Equipment Rental of new mail machine not included in original -0.25% budget. Total Division 2 - Clarkston $ 2,471,406.00 $ 2,566,217.75 $ 2,477,117.75 $ 89,100.00 3.47% Internal Support Expenditures 1,190,577.00 1,240,560.56 1,240,560.56 0.00% Division 4 - Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures internal Support Expenditures $ 5,250,141.00 $ 5,331,299.66 $ 5,302,899.66 $ $ 2,279,674.00 $ 2,289,799.65 $ 2,289,799.65 $ 514,713.00 514,713.00 580,213.00 $ 3,143,977.00 $ 3,190,696.63 $ 3,256,196.63 $ $ 11.615,408.00 $ 11,637,575.27 $ 11,400,875.27 $ 2,531,597.00 2,521,573.95 2,554,373.95 2.229,931.00 2,477,745.81 2,478,545.81 $ 16,376,936.00 $ 16,638,895.03 $ 16,433,795.03 $ 28,400.00 0.53% - 0.00% - (65,500.00) -12.73% - Untay, due to increased cost of utilities, use of interpreter fees due to changing demographics in Troy area, charge card fees due to use of credit cards to pay fees and fines, residual cost of Training Psych. & Med. Exams incurred during transition from contracted services to services performed by County employees; partially offset by lower Drug Testing expense, due to start up. (65,500.00) 236,700.00 (32,800 00) (800.00) 203,100.00 349,590.00 386,183.98 386,183.98 0.00% 8/15/2006 $2,160,357.00 $2,171,443.08 $2,171,443.08 $ 826,374.00 835,192.46 787,292.46 454,610.06 454,610.06 $3,413,345.60 $ 47,900.00 1.38% $3,461,245.60 $4,355,896.08 800,815.46 759,500.63 $4,224,396.08 $ 752,915.46 759,500.63 $5,916,212.17 $5,736,812.17 $ 179,400.00 3.03% 427,922.00 ----------- $ 3,414,653.00 $4,344,810.00 784,245.00 722,861.00 $5,851,916.00 Estates/Mental Health Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 0.00% 5.74% - Fav. due to reduced use of Medical Svcs Probate Exams $10,600 and Fees Guardian Ad Litem $30,000 as judges are ordering fewer guardians (reflective of caseload mix) and Special Projects $7,800 to be carried forward to FY 2007(project not expected to be completed in FY 2006); partially offset by Office Supplies of ($500). 0.00% - 3.02% 5.98% 0.00% 47,900.00 131,500.00 47.900.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT ADOPTED AMENDED BUDGET BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Controllable Personnel Controllable Operating Non-Controllable Operating $ 2,184,453.00 (42,129.00) 294,939.00 $ 2,437,263.00 $2,184,453.00 (34,377.00) 304,890.57 $2,454,966.57 $2,052,953.00 $ (34,377.00) 304,890.57 $2,323,466.57 $ 131,500.00 6.02% - Turnover 0.00% 0.00% - 5.36% 131,500.00 8/15/2006 Administration Personnel Expenditures Operating Expenditures $ 2,433,776.00 $ 2,440,365.16 $ 2,440,365.16 827,019.00 841,715.20 778,715.20 63,000.00 Internal Support Expenditures 1,792,982.00 1,891,694.43 1,906,994,43 (15,300.00) Transfers 11,201.00 11,201.00 0.00% Litigation Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Warrants Personnel Expenditures Operating Expenditures Internal Support Expenditures Appellate Personnel Expenditures Operating Expenditures Internal Support Expenditures 47,700.00 0.92% 250,000.00 2.90% Turnover 0.00% 0.00% 250,000.00 2.59% 20,000.00 0.89% Turnover 0.00% (565.00) 0.00% Unfavorable Radio Communications, charges incurred to date are higher than anticipated. 19,435.00 0.86% 60,000.00 2,000.00 3.74% Turnover 27.43% 0.00% Favorable Personal Mileage due to less than anticipated usage. COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 7.48% Favorable Filing Fees $10,000, Microfilming and Reproduction $10,000, Professional Services $30,000 and Special Prosecuting Attorneys $10,000 due to case requirements. Favorable external Printing $15,000 due to the increased use of the Print Shop, which is partially offset by unfavorable Office Supplies ($12,000). -0.81% Unfavorable Radio Communications ($3,400) and Telephone Communications ($7,900). Charges incurred to date are higher than anticipated. Unfavorable Motor Pool ($4,000) due to the increased use of a daily rental to deliver subpoenas for the Juvenile Division. $ 5,053,777.00 $ 5,184,975.79 $ 5,137,275.79 $ $ 8,524,294.00 $ 8,612,175.89 $ 8,362,175.89 $ 49,824.00 972,162.00 972,162.00 4,703.00 4,703.00 4,703.00 71,371.00 71,371.00 $ 8,578,821.00 $ 9,660,411.89 $ 9,410,411.89 $ $ 2,387,088.00 $ 2,258,547.00 $ 2,238,547.00 $ 2,758.00 2,758.00 2,758.00 565.00 $ 2,389,846.00 $ 2,261,305.00 $ 2,241,870.00 $ $ 1,600,174.00 $ 1,602,221.00 $ 1,542,221.00 $ 7,291.00 7,291.00 5,291.00 $ 1,607,465.00 $ 1,609,512.00 $ 1,547,512.00 $ ciA) 62,000.00 3.85% 8/16/2006 AMOUNT FAVORABLE (UNFAVORABLE) 330,000.00 65,000.00 (15,865.00) 379,135.00 PERCENT 2.21% 3.56% -0.84% 0.00% 2.03% EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out ADOPTED BUDGET $ 14,945,332.00 886,892.00 1,797,685.00 $ 17,629,909.00 AMENDED FY 2006 BUDGET FORECAST $ 14,913,309.05 $ 14,583,309.05 1,823,926.20 1,758,926.20 1,896,397.43 1,912,262.43 82,572.00 82,572.00 $ 18,716,204.68 $ 18,337,069.68 $ 8/16/2006 Sheriffs Office Personnel Expenditures 1,520,888.00 $ 1,524,557.66 0.00% 0.00% 0.00% 0.00% 0.92% $ 756,659.00 614,443.00 619,021.00 $ 1,630,301.00 527,120.49 664,366.00 $ 1,630,301.00 527,120.49 668,256.00 6,100.00 Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Favorable $6,100 in Micrographics & Reproductions due to a reduction in the volume of sheriffs records being sent for rnicrofilrning. Corrective Services Personnel Expenditures Operating Expenditures $ 28,329,317.00 $ 28,479,358 79 8,261,995.00 8,283,923,22 0.00% 0.00% 1.59% 16,085,709.00 571,176,36 0.00% (54,000.00) -10.44% 1,204,722.68 0.00% 0.00% Patrol Services Personnel Expenditures Operating Expenditures $ 33,375,820.00 $ 33,450,741.00 234,536.00 621,916.49 $ 33,450,741.00 0.00% 656,916.49 (35,000.00) -5.63% 0.00% 0.00% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 1,513,557.66 $ 11,000.00 0.72% Fay. due to turnover, partially offset by unfavorability in Overtime ($10,000) due to vacancy. Operating Expenditures Internal Support Expenditures 59,100.00 51,740.00 1,586,907.00 1,586,362.00 51,740.00 1,586,362.00 $ 3,166,895.00 $ 3,162,659.66 $ 3,151,659.66 $ 11,000.00 0.35% $ 1,890,123.00 $ 2,821,777.49 $ 2,815,677.49 6100.00 0.22% $ 28,479,358.79 0.00% 8.45% Favorable $450,000 in Drugs due to a change in vendors from the Medical Care Facility to an outside supplier for inmate medications and $250,000 in Hospitalization of Prisoners due to utilizing NOMC Contract rather than BCBS for Prisoner medical care. 7,583,923.22 700.000,00 Internal Support Expenditures Transfers 6,776,294.00 7,140,149.47 7,140,149.47 115,975.00 115,975.00 $ 43,367,606.00 $ 44,019,406.48 $ 43,319,406.48 $ 700,000.00 Corrective Services-Satellites Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 16,042,247.00 364,971.00 1,198,365.00 $ 16,085,709.00 $ 517,176.36 1,204,722.68 Unfavorable ($32,000) in Dry Goods and Clothing, ($15,000) in Bedding and Linen and ($7,000) in Provisions due to purchases being higher than anticipated. -0.30% $ 17,605,583.00 $ 17,807,608.04 $ 17,861,608.04 $ (54,000.00) Unfavorable Office Supplies ($35,000) due to purchases being higher than anticipated and ($40,000) K-9 Progran due to costs being higher than anticipated. A transfer from Enhancement Funds at fiscal year end will cover the total cost of the K-9 program. Internal Support Expenditures Transfers 4,461,813.00 4,565,002.23 4,565,002.23 122,176.00 122,176.00 $ 38,072,169.00 $ 38,759,835.72 $ 38,794,835.72 $ (35,000.00) -0.09% 8/16/2006 1,362,636.00 1,362,576.16 146,991.00 $ 4,242,779.00 $ 4,238,073.00 $ 4,238,073.00 $ 0.00% $ 117,510,229.00 $ 119,819,399.77 $ 119,362,299.77 $ 457,100.00 0.38% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Technical Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 7,113,628.00 $ 6,235,243.00 $ 6,235,243.00 688,910.00 1,265,229.22 1,311,229.22 1,487,576.16 (125,000.00) 146,991.00 0.00% -3.64% Unfavorable Laboratory Supplies ($46,000) due to equipment and chemical purchases being higher than anticipated. More local Police Departments are utilizing the Sheriffs Crime Lab rather than the State Police lab. -9.17% Unfavorable due to Motor Pool Charges. 0.00% (46,000.00) $ 9,165,074.00 $ Emergency Prep., Training & Comm. 9,010,039.38 $ 9,181,039.38 $ (171,000.00) -1.90% 0.00% 0.00% 0.00% 0.00% Personnel Expenditures Operating Expenditures internal Support Expenditures Transfers $ 3,981,938,00 114,920.00 145,921 00 $ 3,978,470.00 117,920.00 141,683.00 $ 3,978,470.00 117,920.00 141,683.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 91 ,120 ,497,00 10,238,875.00 16,150,857.00 $ 91,384,380.45 $ 11,385,025.78 $ 16,664,851.54 $ 385,142.00 $ 91,373,380.45 $ 11,000.00 $ 10,820,025.78 565,000.00 $ 16,783,751.54 (118,900.00) 385,142.00 0.01% 4.96% -0.71% 0.00% 8/16/2006 Internal Support Expenditures Transfers County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,203,994.00 $ 3,194,921.00 $ 3,194,921.00 Operating Expenditures 278,875 00 297,420.40 302,420.40 0.00% (5,000.00) -1,68% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 15,500.00 27.75% Favorable $15,000 in Binding Expense due to an anticipated project that will not be completed this fiscal year and $5,000 in Travel and Conference due to a reduction in travel. Partially offset by unfavorable ($1,500) in Membership Dues and ($3,000) in Office Supplies. Usage higher than anticipated. 227,919.10 221,919.10 6,000.00 2.63% Favorable $6,000 in Print Shop expenses. The amount of stationary, paper, envelopes, etc, ordered was less than anticipated. 0.00% $ 939,604 00 $ 968,203.31 $ 946,703.31 $ 21,500.00 2.22% Administration Personnel Expenditures $ 684,438.00 $ 684,438,00 $ 684,438.00 0.00% Operating Expenditures 56,350.00 55,846.21 40,346.21 198,816.00 Favorable in Travel and Conference $6,000 and $39,000 in Professional Services due to an e-filing project not being completed this fiscal year. Partially offset by unfavorability ($42,000) from Printing due to a large purchase of court document folders which is made every three years, ($4,000) in Office Supplies, ($3,000) in Freight and Express and ($1,000) in Personal Mileage due to higher than anticipated use. 909,496 74 0.00% 0.00% Internal Support Expenditures Transfers 609,584.00 909,496.74 -0.11% $ 4,092,453.00 $ 4,401,838.14 $ 4,406,838.14 $ (5,000 00) (1,000.00) 0.00% 0.00% -0.71% 52,500.00 52,500.00 0.00% Elections Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 593,866.00 $ 593,866.00 $ 593,666.00 714,075.00 724,715.81 724,715.81 111,473.00 140,108.00 141,108.00 Unfavorable $1,000 in Telephone Communications due to additional phone lines allocated to the Elections Division for modem communication with CVrs. $ 1,419,414.00 $ 1,511,189.81 $ 1,512,169.81 $ (1,000.00) -0.07% 01 8/16/2006 ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST 35,000 00 981,606.40 Jury Commission Personnel Expenditures Operating Expenditures Internal Support Expenditures COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 3.44% 0.00% 11.75% 0.00% 508,000.00 40.18% Register of Deeds Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 2,354,990.00 $ 2,341,296.00 $ 2,341,296.00 1,264,320.00 1,264,320.00 756,320.00 1,005,109.00 1,016,606.40 $ 4,624,419.00 $ 4,622,222.40 $ 4,079,222.40 $ 543,000.00 Favorable $500,000 in Professional Services related to a reduction in recording volume and the settlement of the ACS Lawsuit. The budget is based on pre-settlement rates. The post-settlement rates are lower, $8,000 in Office Supplies due to a lower than anticipated need. Favorable $10,000 in Mail Room and $25,000 in Micrographics and Reproductions due to a reduction in recording volume. 131,906.81 12,991.07 $ 9,325.00 $ 14,730.00 $ 14,991.07 $ 2,350.00 5,825.00 112,992.00 133,406.81 $ 130,072.00 $ 154,222.88 $ 2,000.00 13.34% Favorable due to turnover. (3,500.00) -60.09% Unfavorable ($1,500) in Professional Services and ($1,000) in Office Supplies due to the purchase of Scantmn Jury Questionnaire's to automate response processing. ($3,000) in Metered Postage due to items mailed directly from the US post office, which is offset by a reduction in Mail Room charges. Partially offset by favorable $2,000 in Personal Mileage. 1,500.00 1.12% Favorable $3,000 in Mail Room charges due to some postage being purchased directly from the Post Office. Partially offset by unfavorable ($1,500) in Print Shop charges due to higher than anticipated volume. 154,222.88 $ 0.00% $ 6,852,018.00 2,315,970.00 2,037,974.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 6,829,512.07 $ 2,348,127.42 2,427,537.05 52,500.00 6,827,512 07 $ 2,000.00 1,833,127.42 515,000.00 2,386,037.05 41,500.00 52,500.00 0.03% 21.93% 1.71% 0.00% $ 11,205,962.00 $ 11,657,676.54 $ 11,099,176.54 $ 558,500.00 4.79% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures 85,000.00 5,600.00 $ 2,645,027.00 $ 2,645,027.00 $ 2,560,027.00 $ 203,990.00 207,967.02 202,367.02 Internal Support Expenditure: 599,575.00 829,441.66 829,441.66 3.21% - Turnover. 2.69% - Fav. due to Data Processing and Office Supplies reflective of recent years expenditures. Partially offset by unfav. Charge Card Fees due to increasing number of people paying taxes and service fees with credit cards. 0.00% - Division Total $ 3,448,592.00 $ 3,682,435.68 $ 3,591,835.68 $ 90,600.00 2.46% Department Total $ 3,448,592.00 $ 3,682,435.68 $ 3,591,835.68 $ 90,600.00 2.46% 8/15/2006 Administration Personnel Expenditures Operating Expenditures $ 2,196,181.00 $ 2,177,681.00 $ 2,131,181.00 $ 433,606.00 527,388.29 475,388.29 46,500.00 52,000.00 Internal Support Expenditures 264,452.00 281,010.16 270,810.16 10,200_00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2006 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 2.14% - Fav. Fringes 9.86% - Fay Membership, Dues $1,500, Legislative Expense $8,600,Outside Printing $1,000, Travel $30,000, Workshops $15,000 (Conscious effort to maintain costs), Equipment $4,000, Groceries $2,000 and Outside Postage $10,000 offset by Unfav. Legal Expense ($2,200), County Audit ($4,000) additional work requested and performed, Public information ($13,900) actual invoices were higher than anticipated. All variances are based upon actual expenditures through June 30, 2006 and estimates for the final quarter. 3.63% Fay. Copier $2,300, Info Tech Oper $1,800, Print Shop $7,000 offset by Unfav. Telephone ($900). Copier costs reflect instituting code in copier to make copies at the Commissioners office. Print Shop reflects charging costs to the appropriate Department All other variances are a reflection of actual use. Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 2,894,239.00 $ 2,196,181.00 433,606.00 264,452.00 $ 2,894,239.00 $ 2,986,079.45 $ 2,177,681.00 527,388.29 281,010.16 $ 2,986,079.45 $ 2,877,379_45 $ $ 2,131,181.00 $ 475,388.29 270,810.16 $ 2,877,379.45 $ 108,700.00 3.64% 46,500.00 2.14% 52,000 00 9.86% 10,200.00 3_63% 108,700.00 3.64% 8/14/2006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES LIBRARY BOARD ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2006 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Department Total Operating Expenditures Internal Support Expenditures Transfers Transfer Out $ 989,625.00 676,080.00 850,853.00 5,000.00 $ 2,521,558.00 $ 996,190.16 $ 986,390.16 $ 676,080.00 674,880.00 854,653.70 853,753.70 5,000.00 5,000.00 $ 2,531,923.86 $ 2,520,023.86 $ 9,800,00 0.98% 1,200.00 0,18% 900.00 0.11% 0.00% 11,900.00 0.47% 11,900.00 0.47% $ 2,521,558.00 $ 2,531,923.86 $ 2,520,023.86 $ $ 989,625.00 $ 996,190.16 $ 986,390.16 $ 9,800.00 0,98% 676,080.00 676,080,00 674,880.00 1,200.00 0.18% 850,853.00 854,653.70 853,753.70 900.00 0.11% 5,000.00 5,000.00 5,000.00 - 0.00% Turnover Fay. Travel $600 and Mileage $600 due to conscious effort by department to maintain costs. Fay Telephone $900 due to lower than anticipated usage. 8/14/2006 Drain Commissioner Controllable Personnel Controllable Operating $ 3,393,334.00 $ 3,356,217.00 $ 3,356,217.00 $ 481,002.00 1,447,568 65 1,310,889.65 136,679_00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES DRAIN COMMISSIONER FY 2006 FORECAST ADOPTED AMENDED BUDGET BUDGET AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 9.44% Fav - Contracted Services $20,000, Material and Supplies $28,755 and Training- Educational Supplies $30,000 the result of the Environmental Unit charge outs to the Airport, Health and FM & 0 not taking place. Unfav - Engineering Services ($1,770) for ETC meeting on grants for the Environmental Unit. Fay - Laundry & Cleaning $2,500 for less than anticipated cleaning needs of Soil Erosion staff uniforms. Fay - Membership Dues $31,792 the effect of less memberships being establish for the Environmental Unit. Fay - Personal Mileage $16,200 is the consequence of the Systems being charged directly. Unfav - Prof SVC-Consultants ($4,413) used for Environmental Unit Phase ll to develop watershed management planning services. Fay Publishing Legal Notices $5000 and Recording Fees $12,500 because of less Chapter 4 Drains being dissolved less public notice ads and liens to be recorded at register of Deeds Office. Fay - Training $5,600 due to less required training needs. Unfav - Travel and Conference ($3,100) because budget estimate lower then anticipated needs to maintain knowledge of drain and water issues. Unfav - Expendable Equipment Exp ($6,600) due to an increase in replacement items costing under the capitalization threshold. Unfav - Uniforms ($2,250) for new jackets and overalls for uniform program. Fav - Rouge River Watershed Council $2,177 and PNTRSP For Saginaw River WSD $2,276 the result of the Environmental Unit membership not being established for these programs. -4.62% Unfav - Drain Equipment ($60,490) the result of capturing the assignment of employee's equipment. 0.00% Non-Controllable Operating 1,083,909.00 1,307,963.12 1,368,453.12 (60,490.00) Transfers 56,165.00 56,165.00 56,165.00 Total $ 5,014,410.00 $ 6,167,913.77 $ 6,091,724.77 $ 76,189.00 1.24% Department Total $ 5,014,410.00 $ 6,167,913.77 $ 6,091,724.77 $ 16,189.00 1.24% 8/15/2006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED ry 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel $ 2.179,874.00 $ 2,039,605.38 $ 2,039,605.38 0.00% Controllable Operating 218,665.00 213,779.70 213,779.70 0.00% Non-Controllable Operating 487,864.00 488,744.25 475,744.25 13,000.00 2.66% Favorable $13,000 in Telephone Communications due to an allocation for a capital purchase that was completed last fiscal year. $ 2,886,203,00 $ 2,742,129.33 $ 2,729,129.33 $ 13,000,00 0.47% Emergency Response & Preparedness Controllable Personnel $ 702,515.00 $ 706,402.04 $ 706,402.04 0.00% Controllable Operating 340,090.00 440,243.00 440,243.00 0.00% Non-Controllable Operating 477,498.00 493,832.55 493,832.55 0.00% Transfers Out $ 1,520,103.00 $ 1,640,477.59 $ 1,640,477.59 $.. 0.00% Auditing Controllable Personnel $ 1,173,123.00 $ 1,177,193.14 $ 1,177,193 14 0.00% Controllable Operating 26,180.00 26,180.00 26,180 00 0.40% Non-Controllable Operating 167,333 00 167,943.00 169,943.00 (2,000.00) -1.19% Unfavorable ($2,000) due to Telephone Communications. Charges incurred this fiscal year are higher than anticipated. $ 1,366,636.00 $ 1,371,316.14 $ 1,373,318 14 $ (2,000.00) -0.15% Corporation Counsel Controllable Personnel $ 2,005,447.00 $ 1,980,261.03 $ 1,980,261.03 $ - 0.00% Controllable Operating 48,908.00 48,908.00 43,408.00 5,500.00 11.25% Favorable $1,500 in Court Costs from a reduction in the amount of filing fees paid, $1.000 in Reporter and Steno Services due to a reduction in usage this fiscal year, $2,000 in Personal Mileage and $1,500 in Travel and Conference due to off-campus travel being less than anticipated. Partially offset by ($500) in Periodicals Books due to higher publication and subscription costs. Non-Controllable Operating 227,787.00 232,307.93 232,307.93 - 0.00% $ 2,282,142.00 $ 2,261,476.96 $ 2,255,976.96 $ 5,500.00 0.24% Department Total Controllable Personnel $ 6,060,959.00 $ 5,903,461.59 $ 5,903,461.59 $ - 0.00% Controllable Operating 633,843.00 729,110.70 723,610.70 5,500.00 0.75% Non-Controllable Operating 1,360,282.00 1,382,827.73 1,371,827.73 11,000.00 0.80% Transfers Out 0 0 0 - $ 8,055,084.00 $ 8,015,400.02 $ 7,998,900.02 $ 16,500.00 0.21% 8114/2006 0.00% 0.00% 0.00% 0.00% 41,323.00 125,925 00 72,013 00 128,037.00 72,013.00 130,137.00 0.00% 2,100.00 1,61% Fav. Mail Room $3,000 offset by Unfav. Telephone ($900). Both variances based upon actual usage. Operating Expenditures Internal Support Expenditures Equalization Personnel Expenditures Operating Expenditures Internal Support Expenditures Fiscal Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Purchasing Personnel Expenditures COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $ 344.609.00 $ 344,609 00 $ 344,609.00 $ 8,725.00 8,725.00 8,725.00 8,422.00 8,422.00 8,422.00 $ 361,756.00 $ 361,756.00 $ 361,756.00 $ EXPLANATION OF SIGNIFICANT VARIANCES $ 1,018,651.00 $ 1,049,756.07 $ 1,067,456.07 $ (17,700.00) -1.69% Overtime is expected to be unfavorable due to the implementation of financial system. Revenue favorability offsets expenditure unfavorability. A budget amendment is recommended. * $ 1,185,899.00 $ 1,251,906.07 $ 1,267,506.07 $ (15,600.00) -1.25% $ 7,249,310.00 $ 7,244,007.00 $ 6,834,107.00 $ 409,900,00 5.66% Fav. Salary $248,900, Fringes $188,300 and OT $6,700 offset by Short Term Disability ($34,000).New positions have been added with contracts to Municipalities. 222,590.00 301,771.32 289,771.32 12,000.00 3.98% Fay. Personal Mileage. Work assignments located close to personal residence. 1,457,197.00 1,743,452.59 1,756,852.59 (13,400.00) -0.77% Unfav. Print Shop ($5,100) and Telephone ($8,300). Many forms previously done out-county have been brought inside. Telephone is based upon actual usage. Transfers 1,735.00 1,735.00 0.00% $8,929,097.00 $9,290,965.91 $ 8,882,465.91 $408,500.00 4.40% $ 5,332,806.00 $ 5,422,470.40 $ 5,372,670.40 $ 49,800.00 0.92% Fay. Salary $97,800, Fringes $51,700 offset by Unfav. OT ($18,700) and unexpected Short Term Disability Costs ($81,000). Unfav OT is due to implementation of new PeopleSoft Financial System. 137,700.00 137,964.00 132,464.00 5,500,00 3.99% Fay. Mileage $1,200 and Office Supplies $4,300 based upon actual usage and consolidation of order points within the Division. 1,495,916.00 2,134,128.42 2,122,028.42 12,100.00 0.57% Fay. Mail Room $15,100 offset by Unfav. Telephone ($3,000). Division has made a concerted effort that vendors receive payment through direct deposit rather than mail. Telephone is based upon actual usage. $ 6,966,422.00 $ 7,694,562.82 $ 7,627,162.82 $ 67,400.00 0.88% 8/15/2006 $ 2,237,502.00 $ 2,265,964.42 $ 2,276,464.42 $ 87,366.00 87,366.00 88,866.00 (10,500.00) (1,500.00) 596,643.32 599,143.32 556,259.00 Reimbursement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers -0.46% Unfav. Short Term Disability Costs ($10,500) not anticipated. -1.72% Unfav. Charge Card Fees ($1,500). Increased use of credit cards by Inmate to pay fees (after release from jail.) (2,500.00) -0.42% Unfav. Telephone ($2,500). Division utilizes a phone list to contact former inmates and family for payment of outstanding balances. This phone list has been very useful in the generation of additional revenues for the Division. COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 2,881,127.00 $ 2,949,973.74 $ 2,964,473.74 $ (14,500,00) -0.49% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 16,182,878.00 497,704.00 3,643,719.00 $ 16,326,806.89 607,839 32 4,612,783.33 1,735.00 $ 15,895,306.89 $ 591,839.32 4,614,483.33 1,735.00 431,500.00 2.64% 16,000.00 2.63% (1,700.00) -0.04% 0.00% $ 20,324,301.00 $ 21,549,164.54 $ 21,103,364.54 $ 445,800.00 2.07% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2006 THIRD QUARTERLY REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures Operating Expenditures internal Support Expenditures Transfers $ 189,131.00 $ 189,131.00 $ 189,131.00 $ 2,600.00 2,600.00 2,600.00 13,356.00 17,201.15 17,201.15 $ 205,087.00 $ 208,932 15 $ 208,932.15 $ - 0.00% $ 1,178,970.00 $ 1,193,184.57 $ 1,188,884.57 $ 4,300.00 0.36% Turnover. Operating Expenditures 38,270.00 38,270.00 38,270.00 0.00% Internal Support Expenditures 996,826.00 1,083,255.88 1,083,255.88 - 0.00% Trans fer s - 0.00% Support Services Personnel Expenditures $ 2.214,06600 $ 2,314,710 45 $ 2,310,410.45 $ 4,300 00 0 19% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers 0.31% 0.00% 0.00% 0.31% $ 1,368,101.00 $ 1,382,315.57 $ 1,378,015.57 $ 40,870.00 40,870.00 40,870.00 1,010,182.00 1,100,457.03 1,100,457.03 2,419,153.00 $ 2,523,642.60 $ 2,519,342.60 $ 4,300.00 4,300.00 0.17% 8/14/2006 $ 363,029.00 $ 363,029.00 $ 371,529.00 $ 4,500.00 4,500.00 12,000.00 50,511.00 50,511_00 50511_00 $ 418,040.00 $ 418,040.00 $ 434,040.00 $ $ 960,842.00 $ 960,842.00 $ 864,042.00 $ 96,800.00 10.07% 116,600.00 116,600.00 116,600 00 0.00% 92,025.00 92,239.47 96,939.47 (4,700.00) -5.10% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures - A budget amendment is recommended to fund higher Fringe Benefit costs for hospitalization. - A budget amendment is recommended to fund Appraisal Fees required for appraisal of potential property sites for construction of the future 52-2 District Courthouse and for County property adjacent to the Southfield Health Center. Facilities Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures (8,500.00) -2.34% (7,500.00) -166.67% 0.00% (16,000.00) -3.83% - Fay. Salaries, Overtime and Fringe Benefits for productive time charged to the Airport T-Hangar Capital Project. - Unfav. Telephone Communications cost based on project activity. COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT FY 2006 FORECAST ADOPTED AMENDED BUDGET BUDGET AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 1,169,467.00 $ 1,169,681.47 $ 1,077,581.47 $ 92,100.00 7.87% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 1,323,871.00 $ 1,323,871.00 $ 121,100.00 121,100.00 142,536.00 142,750.47 1,235,571.00 $ 128,600 00 147,450.47 88,300.00 6.67% (7,500.00) -6.19% (4,700 .00) -3.29% $ 1,587,507.00 $1,587,721.47 $ 1,511,621.47 $ 76,100.00 4.79% 8/14/2006 Operating Expenditures 193,150.00 193,150.00 185,750.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Human Resources - General Personnel Expenditures $ 611,443.00 $ 611,443.00 $ 536,443 00 $ 75,000.00 12.27% Turnover. 301,030.00 323,998.30 389,998.30 (66,000.00) -20.37% Primarily unfavorable due to continued high volume of legal actions filed by the Deputy Sheriffs Union, Budget amendment per FY 2006 2nd Quarter Financial Forecast to transfer $70,000 from Designated Fund Blanca to HR-Adminstration Legal Services account no posted as of closing for month 9. 6,265.00 64,326.32 10,226.32 54,100.00 84.10% Budget amendment per FY 2006 2nd Quarter Financial Forecast to reallocate 655,378.62 from HR- Administration IT - Development account to HR - General IT Development account not posted as of closing for month 9. $ 918,738.00 $ 999,767.62 $ 936,667.62 $ 63,100.00 6.31% $ 1,462,110.00 $ 1,489,338.39 $ 1,489,338.39 $ 0.1)0% 7,400 00 3.83% Lower than anticipated use of Examination materials $4,000, FA Proprietary Equipment $1,000 and cost for Employee Medical Exams $2,000 and Equipment Maintenance $600. Internal Support Expenditures 488,292.00 685,245.98 716,045.98 (30,800.00) -4.49% Budget amendment per FY 2006 2nd Quarter Financial Forecast to reallocate $55,378.62 from HR- Administration IT - Development account to HR - General IT Development account not posted as of closing for month 9. Unfav. Variance offset by projected fay. IT-Operating expense $21,000 due to quarterly charges less than anticipated. $ 2,143,552.00 $ 2,367,734.37 $ 2,391,134.37 $ (23,400.00) -0.90% Compensation & Benefits Personnel Expenditures $ 888,941.00 $ 885,072.00 $ 900,672.00 $ (15,600.00) -1.76% Adjustment during FY 2006 Budget Process to transfer Employee's Benefit unit from General Fund to Fringe Benefit Fund overstated. Operating Expenditures 219,501.00 220,014.57 215,914.57 4,100.00 1.86% Projected tower usage of FA Proprietary Equipment Expense $2,000 and Membership, Dues and Publications $2,100. Internal Support Expenditures 197,714.00 206,714.00 204,614,00 2,100.00 1.02% Projected lower usage of Convenience Copier $2,800 and Mail Room $325, offset by higher usage of Print Shop ($400) and Telephone Communications ($600) than anticipated. $ 1,306,156.00 $ 1,311,800.57 $ 1,321,200.57 $ (9,400.00) -0.72% Department Total Personnel Expenditures $ 2,962,494.00 $ 2,985,853.39 $ 2,926,453.39 $ 59,400.00 1.99% Operating Expenditures 713,681.00 737,162.87 791,662.87 (54,500.00) -7.39% Internal Support Expenditures 692,271.00 956,286.30 930,886.30 25,400.00 2.66% $ 4,368,446.00 $ 4,679,302.56 $ 4,649,002.56 $ 30,300.00 0.65% 8/14/2006 $ 8,779,846.00 7,591.00 7,591.00 $ 8,806,496.00 $ 24,038,451.00 $ 22,751,994.15 $ 1,240,000.00 $ 23,991,994.15 4,916,581.16 4,331,418.00 4,916,581.16 5.17% Favorable turnover partially offset by (Unfav.) overtime for Environmental Health ($62,000), Central Health Svs. ($5,100) and Field Nursing ($13,600) due to high 0.00% Interpreter Fees (Unfav.) ($240,000) due to requirement for all agencies which receive federal funding that materials be interpreted into the top 5 most common non-English languages. Offset by favorable medical supplies $220,000 and misc 3,163,900.00 4,325,048 38 4,325,048.38 0.00% internal Support Expenditures Health Personnel Expenditures Operating Expenditures Internal Support Expenditures 7,591.00 0.00% $ 9,756,496.00 $ (950,000.00) -10.79% -1.16% 0.00% -1.92% (140,000.00) (47,500.00) COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 194,384.00 $ 194,384.00 $ 194,384.00 0.00% -11.04% Private Institutions (Mich. Department of Human Services) is projected to be (Unfavorable) ($950,000). The costs incurred are for the care of neglected and abused wards of the court and payment is state mandated. Costs are based on caseload, difficulty of care, and treatment of services (counseling, drug screening etc.) ordered by the Court. Note offsetting revenue favorability for Child Care 8,577,871.00 8,604,521.00 9,554,521.00 (950,000.00) $ 31,533,769.00 $33,233,623.69 $ 31,993,623.69 $ 1,240,000.00 3.73% Children's Village Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 11,713,274.00 $ 12,109,272.43 $ 12,249,272.43 $ 3,417,423.00 3,485,275.72 3,485,275.72 2,380,892.00 2,470,967.47 2,518,467.47 (Unfavorable) Fringe Benefit costs due to emergency salaries. (Unfavorable) Telephone Communication ($3,500), Radio ($37,000) and I.T. CLEMIS ($7,000) due to under appropriated allocation. $ 18,253,015.62 $ (187,500.00) -1.04% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating See related Revenue offset $ 17,511,589.00 $ 35,946,109.00 16,326,712.00 5,552,383.00 $ 57,825,204.00 $ 18,065,515.62 $ 36,295,650.58 17,006,377.88 6,803,606.85 $ 60,105,635.31 $ 35,195,650 58 $ 17,956,377.88 6,851,106.85 1,100,000.00 (950,000.00) (47,500.00) 3.03% -5.59% -0.70% $ 60,003,135.31 $ 102,500.00 0.17% -IL -•11 8/15/2006 MSU Ext. - Oakland County Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 757,165.00 $ 92,506.00 379,578.00 750,634.00 $ 750,634.00 $ 92,506.00 92,506.00 384,929.66 395,129.66 0.00% 0.00% -2.55% (10,200.00) COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Public Services - Admin. Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 173,436.00 $ 173,436.00 $ 4,800.00 4,800.00 6,150.00 6,150.00 $ 184,386.00 $ 184,386.00 $ 173,436.00 $ 4,800.00 6,150.00 184,386.00 $ 0.00% 0.00% 0.00% 0.00% 1,519,976.00 $ 256,661.00 254,215.21 Veterans' Services Personnel Expenditures Operating Expenditures internal Support Expenditures Transfers $ 1,521,510.00 $ 1,519,976.00 $ 250,187.00 256,661.00 253,175,00 253,415.21 $ 2,024,872.00 $ 2,030,052.21 $ 0.00% - 0.00% (800.00) -0.32% - LInfav. Mail Room ($800). Increase in client base for mailing information as well as postage increase. 0.00% 2,030,852.21 $ (800.00) -0.04% Community Corrections Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 3,284,377.00 691,887.00 498,642,00 $ 4,474,906.00 $ 3,279,745.00 $ 3.227,745.00 $ 52,000.00 927,468.92 969,468.92 (42,000.00) 687,767.71 687,767.71 127,274.00 127,274.00 1.59% - Turnover -4.53% - Unfav. Testing Materials expenditures ($42,000) offset by Fay. Testing revenues $170,000.* 0.00% 0.00% $ 5,022,255.63 $ 5,012,255.63 $ 10,000.00 0.20% Unfav. Telephone Communications ($4,200) due to 3 additional telephones and modems that were installed during first quarter and Convenience Copier ($6,000) as a result of additional MSU funded staff and offering new programs. $ 1,229,249.00 $ 1,228,069.66 $ 1,238,269.66 $ (10,200.00) -0.83% * See related revenue offset ai1512006 774,715.00 1,021,822,16 $ 4,579,696.00 $ 4,872,015.59 $ 4,932,615.59 $ (60,600.00) -1.24% 1,744,382.00 $ 144,266.70 25,000.00 (53,750.00) $ 861,469.00 $ 863,740.47 $ 863,740.47 $ 0.00% $ 10,708,757.76 2,050,351.81 3,818,475.85 127,274.00 $ 10,631,757.76 2,206,701_81 3,829,475_85 127,274.00 $ 77,000.00 (156,350.00) (11,000.00) 0.72% -7.63% -0.29% CD • See related revenue offset 8/15/2006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES ADOPTED AMENDED FY 2006 BUDGET BUDGET FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Medical Examiner Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 3,175,170.00 $ 3,215,584,76 $ 3,215,584.76 $ 629,811.00 634,608.67 695,208.67 1,021,822.16 0.00% - (60,600.00) -9.55% - A budget amendment per the FY 2006 2nd quarter forecast to transfer $60,600 from MEO Autopsies revenue account to the Laboratory Fees account, was not posted as of the closing for month 9. See Revenue offset.* 0,00% 644,441.16 Animal Control Personnel Expenditures Operating Expenditures Internal Support Expenditures 505,045.00 $ 1,769382.00 $ 90,516 70 644,441.16 1.41% - Turnover -59.38% Unfav. Construction ($5,000) due to gazebo and dog run construction; Custodial Supplies ($2,000) and Housekeeping & Janitor ($2,000) for products to kill germs and prevent diseases at the Shelter; Printing ($5,000) for pre-printed control and receipt forms, Uniforms ($750) due to changing the uniforms for Shelter Attendants; Medical Supplies ($28,900) due to an increase in sterilization and medical needs; Equip. Maint. ($500) for fixing existing equipment and Professional Services ($9,600) due to an increase in the use of temporary Veterinarians and livestock pickups, boarding and care. A budget amendment was approved per MR #06150 to transfer $10,000 from the AC Legacy fund to the AC Professional Services account, was not posted as of the dosing for month 9. A budget amendment is recommended with the 3rd Quarter forecast to transfer additional funding of $20,000 from AC Population Control to help pay for sterilization costs. 0.00% See Revenue offset*. $ 1,693,882.00 81,607.00 $ 2,280,534.00 $ 2,504,339.86 $ 2,533,089.86 $ (28,750.00) -1.15% Circuit Court Probation Personnel Expenditures Operating Expenditures Internal Support Expenditures - .43,412.00 818,057.00 43,790.52 819,949.95 - $ 43,790.52 819,949.95 0.00% 0.00% 0.00% Department Total Personnel Expenditures $ 10,605,540.00 Operating Expenditures 1,794,210.00 Internal Support Expenditures 3,235,362.00 Transfers $ 15,635,112.00 $ 16,704,859.42 $ 16,795,209.42 $ (90,350.00) -0.54% ADOPTED BUDGET AMENDED BUDGET Workforce Development Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 35,000.00 $ 35,000.00 $ 35,000.00 0.00% 0.00% 7.08% 22.51% 3.51% 0.00% 10.17% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT FY 2006 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 1,299,622.00 $ 1,310,432.90 $ 1,151,632.90 $ 158,800.00 12.12% Operating Expenditures 574,319.00 589,941.00 287,141.00 302,800.00 51.33% Internal Support Expenditures 206,058.00 216,377.69 179,777.69 36,600.00 16.91% $ 2,079,999 00 $ 2,116,751.59 $ 1,618,651.59 $ 498,200.00 23 54% Planning and Economic Development Services Personnel Expenditures $ 3,111,083.00 $ 3,260,584.82 $ 3,093,084.82 $ 167,500.00 5.14% Operating Expenditures 868,690.00 1,421,891.76 1,271,891.76 150,000.00 10.55% Internal Support Expenditures 735,764.00 827,753.61 827,753.61 0.00% $ 4,715,537.00 $ 5,510,230.19 $ 5,192,730.19 $ 317,500.00 5.76% - Fay. Salaries and Fringe Benefits due to turnover and underfilied Automation Alley Coordinator position, which no longer provides services to Automation Alley. Reimbursement of position costs will also no longer be made by Automation Alley. * - Fav. Operating costs, primarily Professional Services, for the North Oakland County Household Hazardous Waste recycling program (NO F1AZ) $135,600 reflecting consolidation of collection events (reimbursement of program costs from participating communities will also be less than budget). * Additionally, fay. Operating costs, primarily Professional Services, for the Solid Waste Management Plan update, $147,200 due to pending reformatting of plan guidelines by State and for South Oakland County liaison costs currently being provided on a ptne basis $20,000. - Fav. Print Shop for the Solid Waste Management Plan update and NO HAZ Program. (see above) - Turnover, primarily for 2 vacant Senior Business Development Representative positions, created by M.R. #05307, and anticipated to be filled by September. - Fay. Professional Services The Capital & Cooperative Initiative Revolving Fund (CCIRF) will be charged $150,000 for the Main Street Program, which is budgeted in the Planning & Economic Development Services Division budget. Community and Home Improvement Personnel Expenditures - $ Operating Expenditures Transfers - $ 355,611.00 355,611 00 - $ 355,611 00 5 355,611 00 $ Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 35,000.00 $ 35,000.00 $ 35,000.00 $ $ 4,445,705.00 $ 4,606,017.72 $ 4,279,717.72 $ 326,300.00 1,443,009.00 2,011,832.76 1,559,032.76 452,800.00 941,822.00 1,044,131.30 1,007,531 30 36,600.00 355,611.00 355,611.00 – — $ 6,830,536.00 $ 8,017,592.78 $ 7,201,892 78 $ 815,700.00 8/1472006 * See related revenue offset 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Budget was Increased based on anticipated rate Increase. Less new participants. Year-to-date rate changes are less than anticipated. Due to increased 2006 Federal Incentive payments in Friend of the Court, less grant match Is required for FY 2006. Based on recent quarterly charges. COUNTY OF OAKLAND FY 2008 THIRD QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET BUDGET AMOUNT AS AS FY 2008 FAVORABLE ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION INON-DEPARTARTMENT APPROPRIATIONS I COUNTY OPERATIONS County Expenditures (210000) Ambulance $ 35,000.00 $ - $ - $ - Insurance Fund 201,184.00 201,184.00 151,184.00 50,000.00 24.85% Insurance Surety Bonds 16,400.00 16,400.00 15.400 00 1,000.00 6.10% Road CommIssiorfiCurrent Drain Assessment 1,300,000.00 1,300,000.00 1,300,000.00 - 0.00% Road Commission \Tri Party Agreement 1,500,000.00 3,608,667.00 3,506,667.00 - 0.00% Senior Citizen Prescriptions 150,000.00 150,000.00 50,000.00 100,000.00 66.67% Transfer to CMHA 9,620,616.00 9,620,616 00 9,620,616.00 - 0.00% Total $ 12,523,200.00 $ 14,894,867.00 $ 14,743,867.00 $ 151,000.00 1.01% COUNTY BUILDINGS (220000/320000) $ 3,400,335.00 $ 2,931,741.01 $ 2,931,741.01 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS (230000) Area Wide Water Quality $ 55,000.00 $ 55,000.00 $ 55,000.00 $ Assoc of Metro Sewage Agencies 1,700.00 1,700.00 $ 1,700.00 Michigan Assoc. of Counties 70,700.00 70,700.00 $ 70,700 00 National Assoc. of Counties 23,000.00 23,000.00 $ 23,000.00 S.E.M.C.O.G. 579,000.00 579,000.00 $ 579,000.00 Traffic Improvement Association 30,000.00 30,000.00 30,000.00 Total $ 759,400.00 $ 759,400.00 $ 759,400.00 $ 300,000.40 $ 300,000.00 $ 795,000.00 $ (495,000.00) -165.00% DTRF Loan Repayment (offset by reduction of reserved funds) and adjustment of prior years revenues and expenses. SUNDRY EXPENSE (2400001210000) RESERVED FOR TRANSFERS (290000) Expenditures Administrative Leave $ (300,000.00) $ 259,392.00 $ - $ 259,392.00 100.00% Budget was reduced from previous years budgets in anticipation of reduced usage which has failed to appear. Budget Task Classification and Rate Change Contingency Emergency Salaries Grant Match - - 197,277.00 161,798,00 11,798.00 150,000.00 340,486.00 307,932.00 307,932.00 .. 1,305,500.00 266,576 45 266,576.45 - 7,300,000.00 1,734,089.00 43.4,089.00 1,300,000.00 Info Tech Development 6,164,400.00 1,436,005.43 1,576,005.43 Legislative Expense 180,500.00 180,500.00 180,500.00 Misc. Capital Outlay 75,000.00 58,370.00 58,370.00 Overtime Appropriation 53,000.00 53,000.00 53,000.00 Workshops and Meetings 4,000.00 4,000.00 4,000.00 Salary Adjustment 442,787.00 442,787.00 442,787.00 Summer Employees Salary Appropriation 376,500.00 376,500.00 376,500.00 Total $ 16,139,450.00 $ 5,280,949.88 $ 3,711,557.88 $ 92.71% 0.00% 0.00% 74,97% (140,000.00) -9.75% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1,669,392.00 29.72% 90.xls 8/14/2006 COUNTY OF OAKLAND FY 2008 THIRD QUARTER REPORT EXPENDITURES NON-DEPARTMENTAL BUDGET BUDGET AMOUNT AS AS FY 2006 FAVORABLE ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION (2,654,651.00) (2,654,651 00) Transfers to Other Funds Operating Transfers Total TOTAL NON-DEPT. APPROPRIATIONS Transfer to Medical Care Facility approved per MR06150 not yet posted as (0.03) 6/30/2006 -2.94% 89,051,276 00 $ 89,651,276.00 90,353,376.00 93,008,027.00 $90,353,376.00 $93,008,027.00 .$ $ 122,473,661.00 $ 114,520,333.89 $ 115,949,59289 $ (1,429.259.00J -1.25% TRANSFER TO GENERAL PURPOSE FUNDS (310000) Health Fund Juvenile Maintenance Fund Social Welfare Fund $ 24,016,747.00 $ 25,622,979.50 20,928,134.00 21.408,898.90 2,000.00 2,000.00 $44,946,881.00 $47,033,878.40 25,622,979.50 $ 21,408,898.90 2,000 00 $47,033,878.40 $ 0.00% 0.00% 0 00% 0 00% TOTAL EXPENDITURES $ 167,420,542.00 $ 161,554,212 29 $ 162,983,47129 $ (1,429,259.00) -0.88% 90.xls 8/1412006 FY 2006 BUDGET AMENDMENTS FY 2006 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 468,311,447.00 BUDGET AMENDMENTS M.R. #05255 - 10127/2005 Sheriff - ORV Safety Education Grant Acceptance M.R. #05263 - 11/10/2005 Management & Budget - Equalization Contract w/City of Royal Oak M.R. #05268 - 11/10/2005 Health - MDEQ Contract M.R. #05260 - 11/10/2005 Sheriff - Contract w/Springfield Twp. for 2004-2008 12,000.00 13,005.00 $ (14,994.00) $ 81,749.00 M.R. #05281 - 12/08/2005 $ 5,020,582.21 FY 2005 Year End Report Carry Forwards S 3,533,397.00 Encumbrances 1,487,185.21 2,700.00 4,125.00 78,124.00 87,354.00 $ 49,965.00 M.R. #05275 -12(08/2005 Sheriff - Acceptance of Armored Vehicle from AT Systems M.R. #05293 - 12-08-2005 52nd -4 District Court - 2006 Drug Court Grant M.R. #05301 -12/08/2005 Sheriff - Contract Amendment w/lndependence Twp. M.R. #05302 - 12/08/2005 Sheriff - Contract Amendment w/City of Rochester Hills M.R. #05303 12/0812005 Sheriff - Security Contract for 43rd District Court TOTAL AMENDED BUDGET AS OF 12131/2005 (1ST QUARTER) $ 473,646,057.21 2,333.00 13,053.00 52,500.00 3,000.00 $ (30,016.00) $ 106,667.00 M.R. #05291 -1210812005 52nd - 1 - District Court - Drug Court M.R. #05292 - 12/08/2005 52nd 2 - District Court - Drug Court M.R. #05306 - 1/1912006 Clerk - Elections Room M.R. #05312 - 1/19/2006 Prosecuting Attorney - Forfeited Funds M.R. #06008 - 1/19/2006 Sheriff - SCAAP Reimbursement M.R. #05305 - 1/19/2006 Veteran's Services - Veteran's Cemetery Road Project FY 2006 BUDGET AMENDMENTS M.R. #06012 - 2/0212006 $ (256,483.00) Sheriff - Contract Amendment w/Royai Oak Twp. $ (73,574.00) 3,297.00 1,325.00 3,811.00 11,215.00 $ 132,524.00 6,000.00 1,464.00 $ 718,499.00 $ 581,950.00 M.R. #06013 - 2/02/2006 Sheriff- Contract Amendment w/Oxford Twp. M.R. #06030 - 3/09/2006 Health - Superbowl Grant M.R. #06033 - 3/09/2006 Emerg Response and Preparedness - Superbowl Grant M.R. #06034 - 3/0912006 Emerg Response and Preparedness - Katrina Grant M.R. #06037 - 3/0912006 Sheriff - MLB All Star Game Grant M.R. #06038 - 3109/2006 Sheriff - Superbowl Grant M.R. #06039 - 3/09/2006 Sheriff - Commercial Vehicle Funding M.R. #06044 - 3109/2006 Emerg Response and Preparedness - Hazardous Materials Grant M.R. #06052 - 3/23/2006 FY 2006 1St Quarter Forecast M.R. #06046 - 3/23/2006 Sheriff - Forfeited Funds TOTAL AMENDED BUDGET AS OF 03/31/2006 (2ND QUARTER) $ 474,923,622.21 M.R. #06076 - 4/06/2006 Medical Examiner DEA contract M.R. #06077 - 4/27/2006 Sheriff - Patrol Contract Amendment w/Oakland Twp. M.R. #06082 - 4/27/2006 Management and Budget - E Financial System M.R. #06090 5/25/2006 Equalization Divison - Contract with Holly Twp. New Appraiser position M.R. #06094 - 5125/2006 52nd - 3 - District Court - Sobriety Court M.R. #06096 - 5125/2006 Criminal Justice Coordinating Council Funding of Jail and Process Improvements 10,000.00 44,070.00 $ 541,600.00 25,368.00 19,000.00 $ 759,000.00 TOTAL AMENDED BUDGET AS OF 06/30/2006 (3RD QUARTER) $ 476,322,660.21 !SHERIFF AVIATION #68000 OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue COUNTY OF OAKLAND FY 2006 THIRD QUARTER FORECAST INTERNAL SERVICE FUNDS SHERIFF'S OFFICE ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES --- – — --- $0.00 $0.00 $0.00 $0.00 0.00% $ 1,803,511.00 $ 1825,193.00 $ 1,809,793.00 $ (15,400.001 -0.84% - Actual anticipated revenues based upon costs. $1,803,511.00 $1,825,193.00 $1,809,793.00 ($15,400.00) -0.84% OPERATING EXPENSES $1,366,011.00 $1 .387,693.00 $1,372,293.00 $ 15,400.00 Fav. Turnover $12,300 and Training $36,800 offset by unfav. Depreciation Expense ($8,100), Interest Expense ($13,600) and indirect Costs ($12,000) as a result of exchanging camera systems, Interest Expense and Indirect Cost 1.11% - Rate changes. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $437,500.00 $437,500.00 $437,500.00 $ - 0.00% NON-OPERATING REVENUE $0.00 $0.00 0.00 $ - 0.00% OPERATING 1RANSFERS IN $0.00 $0.00 $0.00 $ - 0.00% NET REVENUES OVER(UNDER) EXPENSES $437,500;00 $437,500.00 $437,500.00 $ - 0,00% Total Net Assets - Beginning $1,712,500.00 Total Net Assets - Ending $2,150,000.00 8/14/2006 C.71 ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST $201,000.00 $21,000.00 ($180,000.00) 404,881.00 351,381.00 (53,500.00) -89.55% - Unfavorable ($180,000) in External Microfilming due to the loss of agreements with title companies who purchased Microfilm. The information is now available via AccessOakland. There is also a decrease in volume from the Road Commission for Oakland County. -13.21% - Favorable $5,000 from Microfilming due to the Register of Deeds now being charged for all work performed. This offset by unfavorability in Laminating ($1,000), Copier Charges ($3,500), and Photostats ($54,000) due to a decrease in volume from other county departments. $605,881.00 $372,381.00 ($233,500.00) 1,033,699.00 953,099.00 25,000.00 5,000.00 $201,000.00 404,881.00 $605,881,00 1,033,699.00 5,000.00 !MICROGRAPHICS FUND (#65400) REVENUES Outside Inside Total Revenues OPERATING EXPENSES NET NON-OPERATING REV 80,600.00 7.80% - Favorable $101,700 due to the elimination of part-time clerical staff (Pos. #09843, 09844, 09845 and 09846), $4,900 in office supplies and $4,700 in maintenance deptment charges, $1,000 in Equipment Maintenance and $1,500 in Travel and Conference. This is partially offset by an increase in the cost of the equipment maintenance contracts ($15,000), ($1,000) in Freight and Express due to a flood that required Microfilm to be shipped to Kodak for cleaning and preservation, ($16,000) from Indirect Costs and ($1,200) from Depreciation Furniture. 20,000.00 400.00% - Favorable $20,000 due to the continued gradual increase in interest rates. COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND CLERK/REGISTER OF DEEDS VARIANCE FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES REVENUE OVER (UNDER) EXPENDITURES Total Net Assets - Beginning Total Net Assets - Ending (print "selection";1;9999;1;1) ($422,818.00) ($422,818.00) ($555,718.00) ($132,900.00) $934,757.10 $379,039.10 MICROGRAPHICS,xls 8/14/2006 DTRF FUND 51600 REVENUES Charges for Services Other Revenues $10,500,000.00 2,625,596.00 $10,500,000.00 2,625,596.00 $10,650,000.00 5,325,396,00 $150,000.00 2,699,800.00 Total Revenues OPERATING EXPENSES Administrative Expenses Indirect Costs Transfer Out to Other Funds: General Fund - Collection Fees GF Other Debt Svc RCOC Tr-Party Agreement Work Release Facility Debt Svc Office Bldg Renovation Debt Svc 52-3 District Court Debt Service Total Transfer Out to Other Funds Total Operating Expenses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -1.18% $13,125,596.00 $ 575,596.00 550,000.00 $13125596.00 $ 575,596.00 550,000.00 $15,975,396.00 $ 486,696.00 483,800.00 $2,849,800.00 $ (88,900.00) (66,200.00) 3,300,000.00 3,300,000.00 3,300,000.00 0.00 2,000,000.00 2,000,000.00 2,000,000.00 0.00 1,500,000.00 1,500,000.00 1,500,000.00 0.00 1,900,000.00 1,900,000.00 1,900,000.00 0.00 1,900,000.00 1,900,000.00 1,900,000.00 0.00 1,400,000.00 1,400,000.00 1,400,000.00 0.00 12,000,000.00 12,000,000.00 12,000,000.00 0.00 $ 13,125,596.00 $ 13,125,596.00 $ 12,970,496.00 $ (155,100,00) Unfav. ($100,000) due to projected Interest Expense over budget, due to rising interest rates. This was partially offset by Fav. Personnel cost of $11,100 due to turnover. Unfav. ($66,200) due to unbudgeted Administrative Overhead, Legal Services and Printing charges incured. These are yearly cost a budget amendment is recommended. 21.71% -15.44% -12.04% REVENUE OVER (UNDER) EXPENDITURES $3,004,900.00 $2,694,700.00 $0.00 $0.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT DELINQUENT TAX REVOLVING FUND ENTERPRISE FUND TREASURERS OFFICE ADOPTED AMENDED BUDGET BUDGET FY 2006 VARIANCE FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1.43% Fav. Collection Fees due to increased volume of collections. 102.83% Fav. Income From Investments due to increasing ROI reflective of rising interest rates on investments; a budget amendment is recommended to recognize the additional revenue, which will help to offset overage in expenditures. See details below. $93,958,353.88 96,808,511.88 8,322.827.80 $199,089,693.56 $201,784,393.56 Designated - Debt Service Designated - Delinq Taxes Receivable Designated - Collection Fees Total Net Assets - Beginning Total Net Assets - Ending {print "selection"; i ;9999;1;1} 8/16/2006 DTRF #51600 Quarterly Forecast.xls COUNTY FY 2006 THIRD ENTER PARKS & OF OAKLAND QUARTER REPORT PRISE FUND RECREATION $0.00 0.00 0.00 $0.00 $0.00 0.00 0,00 $0.00 ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST VARIANCE FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION (50800) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFER IN CAPITAL CON I RIBUTION TOTAL NET INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $9,246,018.00 $9,256,000.00 $22,707,663.00 $22,707,663,00 $21,851,963.00 ($13,461,645.00) ($13,461,645.00) ($12,595,963,00) $ 13,461,645.00 $ 13,461,645.00 $ 14,222,422.00 0.00 0.00 $1,626,459.00 $ 78,161,020.00 $79,787,479.00 $9,982.00 0.11% $855,700.00 3.77% $865,682.00 -6.43% $760,777.00 5.65% 0.00 0.00% $0.00 0.00% $1,626,459.00 Actual Revenue at June 30, 2006, plus averaged estimate for fourth quarter based upon historical data along with revenues collected for July Actual Expenditures at August 15, 2006 plus averaged estimate for fourth quarter based upon historical data. Includes Property taxes, contributions, interest revenue, interest expense, paying agent fees and gain (loss) on sale of property and equipment are non-operating revenues according to enterprise fund reporting requirements. Based upon actuals at June 30, 2006, plus averaged estimate for fourth quarter based upon historical data. $9,246,018.00 $ 1,626,459.00 $1,626,459.00 8/16/2006 'DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND DRAIN COMMISSIONER ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $2,494,074.00 $2,500,074.00 $3,370,817.00 $870,743.00 34.83% Fay. - Equipment Rental $404,966 due to increase from Mapping Operations Unit equipment. Fay. - Rebilled Charges $14,000 for increase in rebills to Internal Departments. Fay - Reimbursement Building Space Cost $92,600 as a new rate increase was implemented for the pump maintenance building. Fay. - Reimb General $350,000 increase is revenue from the Mapping Operations Unit allocation_ Fay. - Vehicle Rental $9,000 due to third quarter budget amendment to replace 3 owned vehicles to leased vehicles. Outside 698,230.00 698,230.00 698,23000 $0.00 0.00% Total Revenue 3,192,304.00 3,198,304_00 4,069,047.00 870,743.00 27.23% OPERATING EXPENSES 3,255,204.00 3,261,204.00 4,215,735.00 (954,531.00) -29.27% Unfav - Salaries ($335,846), Overtime ($49,616) and Fringes($129,117) the result of increased time and labor for the Mapping Operations Unit. Fay - Administration $8,350 the result of charging the systems directly for these administrative people. Unfav - Electric Service ($2,700) increased for new storage buildings at Pump Maintenance. (inlay - Equipment Maintenance ($7,500) based on under estimated budget forecast compared to actual spending. Unfav - Equip. Repair Motor Vehicle ($57,300) the result of using outside vendor for repairs because inside mechanic on family leave. Unfav - Natural Gas ($1,600) increased for two new storage buildings at Pump Maintenance and an on-site drain Equipment Building. Unfav - Protective Clothing and Equipment ($15,000) gas detectors and sensors being replaced along with charges for preventive maintenance. Unfav - Software Rental Lease Purchase($4,924) for DTL Solutions subscription upgrade renewals. Fay - Shop Supplies $11,000 and Small Tools $5,700 based on over estimated budget forecast compared to actual spending. Unfav - Drain Equipment ($69,000) the result of Mapping Operations Unit Equipment offset by favorable Equipment Rental revenue. Unfav - Motor Pool ($303,150) budget not set to actual historical usage and does not reflect change in replacement vehicles from department owned to leased vehicles. NET INCOME (LOSS) BEFORE (62,900.00) (62,900.00) (146,688.00) (83,788.00) 133.21% 8/1612006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND DRAIN COMMISSIONER ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT ----- ---- NON-OPERATING REVENUE/(EXPENSE) 87,900.00 87,900.00 66,382.00 (21,518.00) -24.48% EXPLANATION OF SIGNIFICANT VARIANCES Unfav - Income from Investments ($20,000) the result of account not earning any return due to the negative cash balance from the purchase of capital equipment. 0.00 (81,448.00) $0-Q°6_,a4,‘012$186 754.00 TRANSFER IN TRANSFERS (OUT) NET REVENUES OVER(UNDER) EXPENSES 0.00 0.00 0.00 25,000.00 119,890.00 201,338.00 0.00% -67.94% Unfav - Transfer Out ($81,448) for the replacement cost of 3 owned vehicles to leased vehicles based on recommended budget amendment. TOTAL NET ASSETS - FiEGINNING 3,910,425.00 TOTAL NET ASSETS - ENDING $3,628,781.00 8/16/2006 TOTAL NET ASSE IS - BEGINNING TOTAL NET ASSETS - ENDING 7,904,385 00 9,521,585.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAVALINFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue - $ - $ 446,900 00 $ 446,900.00 - Fay. due to settlement of lawsuits. Reimbursment is a partial offset to prior year expenses. Inside Revenue 4,047,364.00 4,047,364.00 4,042,364.00 (5,000.00) -0.12% Total Operating Revenue $ 4,047,364.00 $ 4,047,364.00 $ 4,489,264.00 $ 441,900.00 10.92% OPERATING EXPENSE 2,510,328.00 2,510,328.00 2,635,028.00 (124,700 00) -4.97% - Unfav. due to increase of ($45,000) indirect costs and startup costs for respirator program to cover initial exams ($87,000). CLAIMS PAID 1,937,036.00 1,937,036.00 1,937,036.00 0.00% A budget amendment was approved to transfer $1 mil from General Fund/ Fund Balance for Claims. Forecasted expenses includes liability for outstanding claims. See transfer offset. TOTAL OPERATING EXPENSES 4,447,364.00 4,447,364.00 4,572,064.00 (124,700.00) -2.80% OPERATING INCOME (LOSS) (400,000.00) (400,000.00) (82,800.00) $ 317,200.00 -79.30% INTEREST REVENUE 400,000.00 400,000.00 700,000.00 300,000.00 75.00% - Favorable interest rates as compared to budget and previous years. INCOME (LOSS) BEFORE TRANSFERS 0.00 0.00 617,200.00 617,200.00 AND CONTRIBUTIONS TRANSFERS IN $0.00 $0.00 $1,000,000.00 $ 1,000,000.00 Transfer from General Fund, which was designated in the General Fund - fund balance with the FY 2005 Year End Report The transfer was approved by board resolution on July 20, 2006 and not yet posted as of 6130/2006. NET REVENUES OVERAUNDER) EXPENSES - $ - $ 1,617,200.00 $ 1,617,200.00 8/14/2006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND MANAGEMENT AND BUDGET ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES IOFFICE EQUIPMENT FUND 66400 I OPERATING REVENUE - INSIDE $ 595,514_00 $ 597,131.00 597,131.00 $ 0.00% OPERATING EXPENSE 635,714.00 667,563.00 1,127,533.00 $ (460,000.00) -68.91% !inlay. Due to higher than expected indirect costs ($174,500) and increase in depredation due to purchases of Medical Examiner Dental equipment, FOG Courtroom equipment, District Court Mailing Equipment, and Health Division Lektrlever ($285,500). OPERATING INCOME (LOSS) (40,200.00) (70,432.00) $ (530,402 00) (460,000.00) NON-OPERATING REVENUE (EXPENSE) 40,200.00 40,200.00 80,100.00 39,900.00 99.25% Fay based on third quarter actuals for income on investments and interest from municipalities. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN 0_00 (30,232.00) (450,302.00) (420,100.00) 0.00 47,557.00 47,557.00 $ 0.00% NET REVENUE OVEPJ(UNDER) EXPENSES $0.00 $17,325.00 (402,745.00) ($420,100.00) TOTAL NET ASSETS - BEGINNING 3,641,100.00 TOTAL NET ASSETS - ENDING , $3,238,355.00 8/16/2006 ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FRINGE BENEFITS FUND 67800 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND OPERATING REVENUE RETIREES MEDICAL - VEBA 34,535,100 34,535,100 33,775,400 (759,700) -2.20% RETIREMENT ADMINISTRATION 1,626,941 1,626,941 1,569,941 (57,000) -3.50% TUITION REIMBURSEMEN r 360,000 360,000 341,600 (18,400) -5.11% EMPLOYEES DEFERRED COMP ADMIN 51,300 51,300 46,300 (5,000) -9.75% EMPLOYEES DEFERRED COMP COUNTY 800,000 800,000 815,000 15,000 1.88% EMPLOYEE 1N-SERVICE TRAINING 1,501,945 1,501,945 1,461,945 (40,000) -2.66% DEFINED CONTRIBUTION PLAN 14,416,300 14,416,300 13,995,800 (420,500) -2.92% GROUP LIFE 680,000 680,000 628,100 (51,900) -7.63% 30,083,200 31,223,100 1,139,900 3.79% - Based on use of Blue Cross illustrative rates and actual premium for Health MEDICAL INSURANCE 30,083,200 Alliance Plan. SOCIAL SECURITY 16,441,630 16,441,630 16,211,630 (230,000) -1.40% DENIAL INSURANCE 3,154,800 3,154,800 3,039,100 (115,700) -3.67% - Based on use of Delta Dental illustrative rates. OPTICAL INSURANCE 349,600 349,600 319,900 (29,700) -850% - Based on use of Blue Cross illustrative rates. DISABILITY INSURANCE 876,000 876,000 898,900 22,900 2.61% SHORT-TERM DISABILITY 1,763,500 1,763,500 1,671,200 (92,300) -5.23% FRINGE BENEFITS 515,176 515,176 503,976 (11,200) -2.17% WORKERS COMPENSATION 2,495,666 2,495,666 2,575,666 80,000 3.21% UNEMPLOYMENT COMPENSATION 378,100 378,100 387,800 9,700 2.57% SICK AND ANNUAL LEAVE CASH-OUT 821,390 821,390 802,390 (19,000) -2.31% EXT - FLEX BENEFIT DEDUCTIONS 387,158 387,158 459,858 72,700 18.78% EXT - FLEX BEN MEDICAL DEDUCTIONS 1,600,000 1,600,000 1,676,000 76,000 4.75% EXT - MEDICAL INSURANCE 200,000 200,000 289,700 89,700 44.85% EXT - DENTAL INSURANCE 20,000 20,000 24,000 4,000 20.00% EXT - OPTICAL INSURANCE 2,000 2,000 2,600 600 30.00% EXT - FORFEITURES 10,000 10,000 17,600 7,600 76.00% INVESTMENT INCOME 519,428 519,428 1,698,528 1,179,100 227.00% - Favorable interest rates as compared to budget TOTAL REVENUE 113,589,234 113,589,234 114,436,034 846,800 0.75% 8/14/2006 FRINGE BENEFITS.xls Ci) ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FRINGE BENEFITS FUND 67800 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 22,414,372 20,188,872 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND OPERATING EXPENSE RETIREES VEBA - GENERAL COUNTY 28,586,069 28,586,069 28,586,069 0 0.00% RETIREES VEBA - COMMAND OFFICERS 1,775,452 1,776,452 1,775,452 0 0.00% RETIREES VEBA - DEPUTIES 7,126,479 7,126,479 7,126,479 0 0.00% RETIREMENT ADMINISTRATION 1,626,941 1,626,941 1,591,341 35,600 2.19% SICK AND ANNUAL LEAVE CASH-OUT 821,390 821,390 881,390 (60,000) -7.30% TUITION REIMBURSEMENT 360,000 360,000 349,900 10,100 2.81% EMPLOYEES DEFERRED COMP ADMIN 51,300 51,300 51,300 0 0.00% EMPLOYEES DEFERRED COMP COUNTY 800,000 800,000 785,700 14,300 1.79% EMPLOYEE IN-SERVICE TRAINING 1,151,945 1,151,945 998,045 153,900 13.36% - Reflects lower demand for training within the County than anticipated. IN-SERVICE TRAINING - INFO TECH 350,000 350,000 341,000 9,000 2.57% DEFINED CONTRIBUTION PLAN 14,416,300 14,416,300 14,216,300 200,000 1.39% GROUP LIFE 680,000 680,000 698,000 (18,000) -2.65% MEDICAL INSURANCE 31,883,200 31,883,200 32,183,200 (300,000) -0.94% SOCIAL SECURITY 16,441,630 16,441,630 16,641,630 (200,000) -1.22% DENTAL INSURANCE 3,174,800 3,174,800 3,159,200 15,600 0.49% OPTICAL INSURANCE 351,600 351,600 338,400 13,200 3.75% DISABILITY INSURANCE 2,639.500 2,639,500 2,639,500 0 0.00% FLEXIBLE BENEFIT PAYMENTS 251,000 251,000 234,000 17,000 6.77% PROFESSIONAL SERVICES 140,000 140,000 129,000 11,000 7.86% WORKERS COMPENSATION 2,495,666 2,495,666 2,495,666 0 0.00% UNEMPLOYMENT COMPENSATION 378,100 378,100 409,400 (31,300) -8.28% ACCOUNTING SERVICES 101,977 101,977 103,877 (1,900) -1.86% CHILD CARE FACILITY 174,935 174,935 168,835 6,100 3.49% EMPLOYEE BENEFITS UNIT 413,199 413,199 407,199 6,000 1.45% INDIRECT COSTS 350,651 350,651 350,651 0 0.00% TOTAL EXPENSE 116,542,134 116,542,134 116,661,534 (119,4001 -0.10% NET REVENUE OVER/(UNDER) EXPENSE (2,952,900) (2,952,900) (2,225,500) 727,400 FRINGE BENEFITS.xls 8114/2006 OPERATING REVENUE $5,384,579.00 $5,384,579.00 $5,541,579.00 $157,000.00 OPERATING EXPENSE $5,552,434.00 $5,552,434.00 $5,642,434.00 ($90,000.00) $67,000.00 ($100,855.00) $0.00 0.00 0.00 $0.00 $0.00 0.00 0.00 $0.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2006 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) 2.92% - Fav. Aviation Gas $50,000 due to Increased number of landings and departures. Fay. Reimb US Customs Service $100,000 due to rate increase and service to larger aircraft. Fay. Car Rental Concessions $7,000 due to a slight increase in car rentals. -1.62% - Unfav. Professional Services ($80,000) due to environmental consultant issues on the airfield and Gas, Oil and Grease ($10,000) due to increase in price. -39.92% NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFER IN CAPITAL CONTRIBUTION TOTAL NET INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING ($167,855.00) ($167,855.00) $ 167,855 00 $ 167,855.00 $ 167,855.00 $ 67,000.00 $67,000.00 0.00 0.00 0.00 $67,000.00 $67,000.00 $ 62,167,057.85 $62,234,057.85 0.00% 0.00% 0.00% 8/14/2006 01 !MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue $ 126,486.00 $ 126,486.00 $ 128,986.00 $2,500.00 1.98% Fav due to increase in external parts & accessories $2,500 5,536,820.00 5,554,359.00 5,577,659.00 Inside Revenue OPERATING EXPENSE 6,895,333.00 6,927,163.00 7,454,563.00 477,453.00 0.00 0.00% AMENDED BUDGET CI ADOPTED BUDGET COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES FY 2006 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Total Revenue 23,300.00 0.42% Fav due to increase in sublet repairs $14,300 and leased equipment $9,000 (527,400.00) -7.61% Unfav due to purchase of new software ($91,000), increase in sublet repairs ($60,000), increase in depreciation -vehicles ($9,000), increase in gas ($313,300), increase in Info Tech Development ($52,000) and increase in radio communications ($2,100) $ 5,663,306.00 $ 5,680,845.00 $ 5,706,645.00 $ 25,800.00 OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN NET REVENUE OVER/(UNDER) EXPENSES $ (1,232,027.00) $ (1,246,318 00) $ (1,747,918.00) $ (501,600.00) -40.25% 477,453.00 477,453.00 $ (754,574.00) $ (768,865.00) $ (1,270,465.00) $ (501,600.00) -65.24% 25,000.00 254,284.00 335,684.00 81,400.00 $ (729,574.00) $ (514,581.00) $ (934,781.00) $ (420,200.00) Unfav. due to vehicle purchases and additions for Drain Commissioner ($81,400). A budget amendment is recommended. TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 6,585,363.00 $ 5,650,611.00 8/16/2006 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1MAILING, CONVENIENCE COPIER AND PRINTING FUND 66700 OPERATING REVENUE: Outside Revenue $ 410,500.00 $ 410,500.00 $ 481,200.00 $70,700.00 17.22% Fay. External Standard Mail revenue reflecting increased CVT mailings. Inside Revenue 2,943,013.00 2,943,013.00 2,919,613.00 (23,400.00) -0.80% County mailings marginally reduced based on FY 2006 activity ($68,400) plus reduced Supplies revenue due to discontinuation of desktop paper delivery to departments Total Revenue $ 3,353,513.00 $ 3,353,513.00 $ 3,400,813.00 $ 47,300.00 ($25,000); partially offset by fay. Printing revenue $35,000 and Copier revenue $35,000 for County Departments. OPERATING EXPENSE 3,444,842.00 3,444,842.00 3,593,042.00 (148,200.00) -4.30% Unfav. Indirect Costs due to determination of charge subsequent to budget formulation ($63,200); increased Convenience Copier Machine Rental charges based on demand ($35,000); Mail Handling - Postage Services for permit mailings OPERATING INCOME (LOSS) $ (91,329.00) $ (91,329.00) $ (192,229.00) $ (100,900.00) ($70,000); and Stationery Stock costs ($20,000) based on demand; partially offset by fay, Paper Printing $22,500 due to discontinuation of desktop paper delivery and fay. Printing Supplies $17,500 NON-OPERATING REVENUE (EXPENSE) 4,000.00 4,000.00 7,500.00 3,500.00 87.50% Higher interest rates. NET REVENUE OVER/(UNDER) EXPENSES 87 329.00 $ ..87,329.00) $ (184,729.00) $ (97 400.00) -111.53% TOTAL NET ASSETS- BEGINNING $ 718,663.00 TOTAL NET ASSETS - ENDING $ 533,934.00 8/16/2006 --.1 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $9,985,662.68 $9 643,362.68 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND I ENTERPRISE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ----- 'FACILITIES MAINTENANCE & OPERATIONS (#63100) OPERATING REVENUES: Outside Revenue $248,000.00 $248,000.00 $ 248,000.00 0.00 0.00% - Inside Revenue 24,245,656.00 24,245,656.00 24,100,056.00 (145,600.00) -0.60% - Reduced Office Space Rental revenue as per lease agreement for office space charges for the O.C. Road Commission at the Information Technology Center ($45,600) and reduced Maintenance Department Charges to Departments based on requests for services through June ($100,000) due, in part, to reduced activity pending departmental relocations as a result of the opening of new Executive Office Building (former Oakland Schools Administration Building). - Transfer of $400,000 to the Project Work Order Fund for maintenance projects will Prior Year Balance $400,000.00 $400,000.00 $0.00 ($400,000.00) -100.00% reduce fund balance. Total Revenue $24,893,656.00 $24,893,656.00 $24,348,056.00 ($545,600.00) -2.19% OPERATING EXPENSES $24,674,156.00 $24,674,156.00 $24,595,856.00 $78,300.00 0.32% - Fay. Indirect Cost Charges $849,600 due to determination of indirect cost charge subsequent to budget ferrnulation: fav. Turnover $355,300; fay. Depreciation $40,000 based on current depreciation schedule; and fay. Garage & Rubbish Disposal $25,000 and Water & Sewage Charges $50,000 due, in part, to delayed opening of new Executive Office Building and Sheriff's Administration Building. ravorability is largely offset by unfav. Electrical Service costs ($125,000) based on higher costs to generate electricity to producers horn gas fired plants; Fuel Oil and Natural Gas costs ($650,000) due to commodity price increases; Sublet Repair costs ($250,000) and Maintenance and Grounds Supplies ($50,000), both based on supplies cost increases and demand; Software costs ($10,200) for key and alarm system upgrade; Motor Pool ($15,000), Telephone Communications ($27,500), Information Technology Operations ($31,000), Drain Eguip.($10,000) and Radio Communication ($10,900) based on projection of current usage; and Overtime ($60,000) based on snowplowing and custodial demands. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $219,500.00 $219,500.00 ($247,800.00) ($467,300.00) NON-OPERATING REVENUE $180,500.00 $180,500.00 $ 305,500.00 125,000.00 69.25% - Higher Investment Income based on increasing interest rates. TRANSFERS IN TRANSFERS OUT ($400,000.00) ($400,000.00) ($400,000.001 - 0.00% - Transfers to Project Work Order Fund for Maintenance Projects $400,000 NET REVENUES OVER(UNDER) EXPENSES $0.00 $0.00 j$3100.00 ($342,300.001 FACILITIES INTERNAL FORE.xls 8/16/2006 ICI [AL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $4,238.02 $4,238.02 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUND / ENTERPRISE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES I PONTIAC MARKET (#56100) j OPERATING REVENUES - OUTSIDE $147,623.00 $147,623.00 $147,623.00 $0.00 0.00% OPERATING EXPENSES $147,623.00 $147,623.00 $147,623.00 $0.00 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $0.00 $0.00 $0.00 $0.00 0.00% TRANSFERS IN - - 0.00% TRANSFERS OUT NET REVENUES OVER(UNDER) 0 EXPENSES $.00 $0,00 $0.00 $0.00 0.00% CO FACILITIES INTERNAL FORE.xls 8/16/2006 Golden Oaks Medical Care Facility 52100 OPERATING REVENUE $11,481,373.00 $11,481,373.00 $6,910,358.00 ($4,571,015.00) OPERATING EXPENSE $11,481,373.00 $11,481,373.00 $9,286,807.00 $2,194,566.00 $0.00 TOTAL NET INCOME (LOSS) $0.00 $278,202.00 , $278,202.00 0 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT ENTERPRISE FUND HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2006 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -39.81% - (Unfav.) due to lower than anticipated pharmacy and patient census. Daily Patient Services should be amended ($1,816,499) due to decrease in patient census Including unfavorable medicaid reimbursement per patient rate/per day. Pharmacy Revenue (Unfav.) ($612,000), is based on physician orders and IV Therapy is included in Daily Patient Services ($145,000). Medicare Audit ($200,000) is based on the Medicare Cost Report Audit findings. (Unfav.) Reimbursement of Pharmacy Services ($1,797,516), due to MCF no longer providing pharmacy services to Sheriff's Dept. see expenditure offset. 19.11% - Favorable Operating Expenses related to the closing of the Pharmacy which reduced prescription drugs, $995,374, is partially offset by write-off of Uncollectible Accounts Receivable for activity prior to 2003 ($350,000), Fines ($42,000), Nursing Pool ($15,000), and Nurse Consultant ($25,000). Favorability exists in Personnel $850,000. Professional Services, Fav. $700,100, which includes a change in contract provider for Food Service, Medical Director and minimal use of Medical Record consultant including one- time charge of Michigan Peer Review Organization offset by Therapy Services ($40,000) for months May/June 2006. Additional favorability exists in operating expenses approximately $121,092, due to lower patient census. NET OPERATING INCOME (LOSS) $0.00 $0.00 ($2,376,449,00) ($2,376,449.00) NON-OPERATING REVENUE - TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS $0.00 $0.00 $ (2,376,449.00) ($2,376,449.00) TRANSFER IN 0.00 0.00 2,654,651.00 $2,654,651.00 0.00% A budget amendment was approved per MR #06150 to transfer $2,654,651 to . eliminate deficit, TOTAL NET ASSETS - BEGINNING $ 634,608.94 TOTAL NET ASSETS - ENDING $912,810.94 8/14/2006 OPERATING REVENUES: Outside $1,198,23a00 $1,198,233.00 $1,715,033.00 $516,800.00 25,034,656.00 24,935,975.00 24,329,975.00 (606,000.00) Inside OPERATING TRANSFERS IN 2,550,000.00 3,314,400.00 3,314,400.00 0.00 TOTAL OPERATING REVENUES OPERATING EXPENSES 28,782,889.00 29,448,608.00 29,359,408.00 (89,200.00) -0.30% 34,190,293.00 34,473,324.00 32,845,524.00 1,627,800.00 4.72% COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Operations (63600) AMENDED BUDGET FY 2006 VARIANCE FORECAST FAVOINFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 43.13% - Fav. primarily due to increase in Interest Income $634,000 from improved returns and higher than anticipated cash balance; increase in ©ccess Oakland customer usage $287,600. Fay. offset by unfavorable Deferred Land File Tax & Reimb Equalization Svcs ($169,200) from change in billing procedures due to BSA technology. Unfav. ($235,600) Outside Agencies due to less than projected estimate of external customers requests. -2.43% - Tinley due to decrease in charges to OC Dept Oper & Dev ($1,220,500); Imaging Oper & Dev ($155,400) & Non-Govt'l Oper ($102 200). Unfav. partially offset by favorable Non-Govi'l Development $872,100 due to increase in projects requested by Non-General Fund Depts. 0.00% Budgeted Transfer from General Fund for OAKNet Support and qtrly transfers for capital equipment replacement needs. Favorability primarily due to Depredation $2,423,400 for IT projects in progress not fully operational; Salary & FB $766,300 vacancies & turnover, Fay. $570,300 equipment maintenance & software maint $376,000 due to replacement of aging network equipment; $303,500 decrease in printing Supplies due to printing locally. Fay. partially offset by unfavorable Expendable Equip ($1,542,200); Professional Svcs ($1,182,700) for timing of implementation of projects; ($86,800) Indirect Cost subsequent to budget projection. Budget amendments requested 2nd qtr FY 06 $730,000 Expendable Equip and $1,001,100 Prof Svcs were not posted as of 3rd qtr close. A budget amendment will be requested for 3rd qtr for GF appropr $850,000 Expendable Equip for XP Upgrade equip and IT equity $720,000 for continued implementation of previously approved IT projects. OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 0.00 250.00 250.00 0.00 0.00% Per MR # 06041 dated 3/23/2006, which transferred $250 from Info Tech, fund to Telephone Communications. 11101,401010 5 02/... j=66.00 ($3,486,366.00) $1,538,600.00 30,698,161.00 A27211,2100 OPERATING REVENUES: Outside Inside OPERA I ING TRANSFERS IN TOTAL OPERATING REVENUES OPERATING EXPENSES $34,747_00 $34,747.00 3,961,470.00 3,966,435.00 0.00 1,075.00 3,996,217.00 4,002,257.00 3,996,217.00 4,002,022.00 OPERATING INCOME (LOSS) $0.00 $235.00 0.00 0.00 0.00% 539,735.00 $539,500.00. OPERATING TRANSFERS (OUT) 0.00 0.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 4,017,887.00 4 557 622 oo COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS/ ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Telephone Communications (67500) AMENDED FY 2006 VARIANCE BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 86,947.00 $52,200.00 150.23% Favorable Interest income $69,200 due to improved returns and higher cash balance; offset by decreased usage by external customers ($17,000). 4,257,435.00 291,000.00 7.34% Favorable due to increased Telephone Service usage $294,000 including re- billed Expendable equipment, slightly offset by decreased Leased Equipment revenue from pagers ($3,000). 1,075.00 0.00 0.00% Operating Transfers per Res. 05307, 06041 and 06090 for telephone equipment related to new positions approved for various departments. 4,345,457.00 343,200.00 8.58% 3,805,722.00 196,300.00 4.91% Favorable Salaries and FR $73,500 due to unfilled position. Favorable Communication expense $195,000 due to rate reduction. Fay. Contracted Svcs $10,500, Equipment Repairs $32,500, Sublet Repairs $44,300 and Mileage $1,000 due to decreased service calls. Unfav. Disposal cost ($500) for unanticipated auction charges. Unfav. Maintenance Equip. ($35,000) and Software Support ($5,000) offset by fav. Voice Mail $46,500 due to change in equipment service contracts. Favorable Professional Svcs $14,000 due to decreased use of software assistance Fav. Software Rental/Lease Purchase $51,000 due to timing of projects. Favorable lower Charges $24,600 due to decreased Pager usage. Favorable Travel $2,500 due to cost-cutting. Unfav. Expendable equipment expense ($167,300) offset by rebilled revenue Unfav. Depreciation ($27,900) due to acquisition of equipment after adoption of budget. Fay. Indirect Cost $4,500 less than budget estimate. Unfav. IT Operations ($59,500), Maintenance Dept charges ($8,000) and Motor Pool ($300) due to increased usage. 'Information Technology. CLEMIS (53500) 1 OPERATING REVENUES: Outside Inside $1,987,450,00 $1,987,450.00 1,860,084.00 1,861,494.00 8.38% Favorable due to Increased CLEMIS membership & 24x7 remote monitoring to agencies outside Oakland County $211,890; Fay. Maint Contr. $130,915 due to new Mugshot Capture Station Maint provided to Interested agencies & $101,030 reflects 3% increase In-Car Terminals Ext.; Fay. Interest Income $62,490. $2,493,750.00 $506,300.00 1,280,894 00 (580,600.00) 53.20% Unfav. primarily due to less than projected use of COPSMORE funding for acquisition of equipment recognized in the CLEMIS fund. OPERATING TRANSFERS IN 1,756,100.00 1,770,500.00 1,770,500.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2008 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00 0.00% Budgeted Transfer from Radio for CLEMIS suppt & General Fund for Operational Suppt and E911 equipment maintenance to CVTs. TOTAL OPERATING REVENUES OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 5,603,634.00 5,619,444.00 5,545,144.00 (74,300.00) 8.39% 8,123,216.00 8,124,626.00 8,236,628.00 (112,000.00) -2.43% Unfavorable primarily due to expendable equipment for technology upgrade ($135,000); increase in Depreciation to include Project Mgmt costs ($161,758); ISF Info Tech Development ($245,796) due to additional assistance for Records Mgmt System. Partially offset by favorable software maintenance $430,000 due to delayed maintenance payment to vendor on computer aided dispatch system which was included in budget projection. 0.00 0.00 0.00 0.00 0.00% ($2,519,582.00) ($2,505,182.00) ($2,691,482.00) ($186,300.00) 16,662,578.00 $13,971,096.00 OPERATING REVENUES Outside Inside OPERATING TRANSFERS IN TOTAL OPERATING REVENUES OPERATING EXPENSES COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET !Information Technology - Radio Communications (536001 AMENDED FY 2006 VARIANCE BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $7,625,000.00 $7,625,000.00 7,738,000.00 $113,000.00 1.48% Unfavorable E911 Surcharge ($225,000) due to slower growth in land line fees designated for new Radio system. Favorable interest income $525,000 due to improved returns and higher than anticipated cash balance. Favorable Outside Agency revenue $313,000 due to continued billing for legacy system pending start-up of new system. Unfav. Gain on Equipment Sale ($500,000) due to delay in sale of existing system, now anticipated for FY2007 140,000.00 140,591.00 949,091.00 808,500.00 575.07% Favorable Internal revenue for Leased Equipment $645,000 and Parts & Accessories $170,000 and continued billing for legacy system, offset by unfav, Productive Labor ($6,500) due to fewer repairs in house. 0.00 11,374.00 11,374.00 0.00 0.00% Operating Transfers per MR #05302 and #06077 for OCSD radio equipment. 7,765,000.00 7,776,965.00 8,698,465.00 921,500.00 576.55% 6,357,390.00 6,357,981.00 2,246,981.00 4,111,000.00 64.66% Unfav. Overtime ($10,000) and On Call ($1,000) offset by fay. Emergency Salary and FO $28,800 for unfilled position. Unfav. Communication ($220,000) due to tower connectivity prior to startup. Unfav. Equip Repair ($115,000), Parts & Access. ($100,000) and Shop Supplies ($10,300) to maintain old system. Maint. Contract ($20,000) unfav, due to coverage during testing. Fay. Tower Charges $112,000 due to lower lease costs Utilities $50,000 (av, due to lower demand. Prof. Services $105,000 fay. due to capitalizing cost of new system. Fay. Freight $1,200, Dry Goods $800 and Small Tools $13,500 due to decreased usage. Office Supply ($2,500) unfav. due to new system expense. Indirect Cost unfav. ($29,200) as final allocation exceeded estimate. Fay. Depreciation $3,998,500 due to delayed start of new system. Interest expense $300,000 fav, as no debt incurred for new system. Fay. Maint. Dept. charges $33,000 due to lower usage. Unfav. ISF charges for IT Operations ($29,000) and Telephone ($3,000) due to implementing new system. Fay. Print Shop $8,000 due to timing. OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 150,000.00 150,000.00 150,000.00 0.00 0.00% $1,257,610.00 $1,268,984.00 6,301,484.00 $5,032,500.00 37,452,021.00 43.753.505.00 1FIre Records Management ( 53109.1 OPERATING REVENUES: Outside 395,700.00 571,200.00 COUNTY OF OAKLAND FY 2006 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2006 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING TRANSFERS IN FOTAL OPERATING REVENUES OPERATING EXPENSES $175,500.00 $175,500.00 $156,100.00 ($19,400.00) -11.05% Unfavorable Outside Agencies revenue ($7,800) due to timing of addition of new member agencies. Unfavorable Rebilled Charges ($15,600) offset by favorable Communication Cost. Favorable Interest income $4,000 due to improved returns and higher cash balance. 395,700.00 357,800.00 (37,900.00) -9.58% Operating Trans. for budgeted GF support based on decreased revenue. 571,200.00 513,900.00 (57,300.00) -10.03% 644,550.00 644,550.00 668,250.00 (23,700.00) -3.68% Favorable Overtime & On Call salaries $19,300 due to fewer service calls by member agencies; offset by unfavorable Fringe Benefits ($7,200). Favorable Communication cost $16,000 offset by unfav. Rebilled Charges. Favorable Equipment Repairs $15,000 due to decreased maintenance costs, offset by unfavorable Professional Services ($3,504) due to unanticipated training cost and Software Purchase ($13,500) for additional licenses. Favorable Mileage $1,000 due to decreased service calls. Fav. Travel $2,000 due to cost cutting. Unfav. Software Support ($16,000) due to additional licenses. Unfavorable Expendable equipment ($22,100) due to necessary workstation replacement for member agencies. Favorable Indirect Cost $9,500 less than original budget estimate Unfavorable Info Tech Development ($16,700) and Operations ($7,000) and Telephone Communications ($500) due to increased usage. OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 0.00 0.00 0.00 0.00 0.00% ($154,350.00) , ($81,900.00), 350,335.00 $195,985.00 ($73,350.00) ($73,350.00) Resolution #06175 September 21, 2006 Moved by Moss supported by Gregory the resolutions (with fiscal notes attached) on the Consent Agenda, be adopted. AYES: Coleman, Coulter, Crawford, Douglas, Gershenson, Gregory, Hatchett, Jamian, KowaII, Long, Melton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Rogers, Scott, Suarez, Wilson, Woodward, Zack, Bullard. (24) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda, were adopted. STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Ruth Johnson, 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 21, 2006, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 21st day of September, 2006. Ruth Johnson, County Clerk