Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2001.06.14 - 26434
MIS4ELLANEOUS RESOLUTION #01160 June 14, 2001 A • By: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - FISCAL YEAR 2001 SECOND QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget adjustments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget adjustments for variances between estimated revenue and projected expenditures, adjustments are required; and WHEREAS the Fiscal Year (FY) 2001 Second Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS adjustments are required to the Circuit Court budget to properly reflect the new Family Court reorganization, these adjustments include a redistribution of Building Space Cost and a shifting of the State Institution allocation; and WHEREAS the 52 nd District Court has experienced an increase in the Visiting Judge expenses due to an unexpected medical leave absence in Division IV (Troy); and WHEREAS additional Refund of Defense Attorney and State Law cost revenue from Division IV can be used to offset the increased Visiting Judge cost; and WHEREAS the Sheriff Department has experienced increased cost in his food service Contractual service account due to an increase in jail population and the charging of FY 2000 expenditures to FY 2001, as well as increased Medical Supply cost as the jail health program treats more prisoners in-house as opposed to a hospital setting; and WHEREAS the Sheriff Department, along with Management and Budget, have been able to secure additional Deferred Offender revenue which can offset the additional expenditures in the Sheriff Department as well as other areas of the County; and WHEREAS annual payments to the Jury Board in the Clerk's office was underbudgeted, additional Mortgage revenue from the Register of Deeds office can be used to cover this miscalculation; and WHEREAS the Drain Commissioner needs to transfer funds, from within his budget, to the Licenses and Permits account in order to pay permit fees to the State of Michigan; and WHEREAS postage cost to the Fiscal Services Division has increased due to special arrangements made with the post office for the mailing of Finance Committee packets; and WHEREAS pursuant to M.R. #01086, the Purchasing Division was authorized to pursue electronic bidding, an additional allocation is required to complete the process; and WHEREAS a budgeted operating transfer in the Equalization Division is no longer required, these resources can be used to cover the expenditure issues in the Department of Management and Budget; and WHEREAS Emergency Management desires to have all expenditures related to tornado sirens budgeted into one account; and WHEREAS the State payment from the Convention Facility and Liquor Tax distribution has increased above budget, one-half of these funds must be used for substance abuse prevention programs in the Health Division, the remainder may be used to cover expenditure short-falls in other areas; and WHEREAS the Health Division has received reimbursement under the Michigan Nutrition Network, pursuant to M.R. #01019, for their efforts to enhance nutrition among county citizens; and WHEREAS the Library Board - Research Library inadvertently was not budgeted for Information Technology Operation expenditures, an amendment is required to cover this activity; and FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Dingeldey absent. ) WHEREAS Management and Budgel has verified the third year of CRIMP 4 savings for the Health Division's privatization of the Dental Services program (20% of total savings), and has also verified the first year of CRIMP savings from the cessation of the Breast and Cervical Cancer program (60% of total savings); by policy these funds must be allocated to the Health Division; and WHEREAS pursuant to M.R. #01097, an additional $4,651 needs to be allocated to the Health Division to complete their carry forward of committed but unspent FY 2000 funds; and WHEREAS expansion of the Health Division laboratory and increased space in the Executive Office Building for the Health Division requires an additional appropriation; and WHEREAS due to increased activity, the non-departmental Contingency, Emergency Salaries, and Miscellaneous Capital Outlay accounts require an additional appropriation to maintain a positive balance through the remainder of the fiscal year; and WHEREAS pursuant to M.R. #00264, the Board of Commissioners authorized the "Senior Citizen Resident Prescription Discount Program" with $240,000 in funding located in a Designated Fund balance. The appropriation of that fund balance is now required. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2001 Second Quarter Financial Forecast. BE IT FURTHER RESOLVED that the Board authorizes amendments to the FY 2001 Budget as detailed on attached Schedule A. BE IT FURTHER RESOLVED that the FY 2001 Budget be amended, as specified below, to utilize the $240,000 Designated Fund Balance for the Senior Citizen Prescription Program: Revenue 90-190000-14000-1582 Prior Years Balance $240,000 Expenditures 11-250207-30000-4072 Drugs Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. $240,000 0 E COMMITTO AL tali; tz.0 FIN ACCOUNT NUMBER ACCOUNT NAME FY 2001 AMENDMENT Schedule A 4 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2001 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES GF/GP OPERATIONS - SELF BALANCING AMENDMENTS Circuit Court - Space Reallocation 35-210000-11000-6631 Judicial Administration - Previous $ (1,936,285) 35-242000-11000-6631 Court Services - Previous (23,707) 35-243000-33000-6631 Judicial Support - Previous (128,632) 35-242000-41000-6631 Court Services - Previous (197,926) 35-242000-42000-6631 Court Services - Previous (47,965) 35-242000-43000-6631 Court Services - Previous (97,857) 35-210000-11000-6631 Judicial Administration 188,483 35-220000-11000-6631 Business Operations 146,625 35-230000-21100-6631 General Judges 1,125,037 35-230000-22100-6631 Assignment 64,634 35-230000-24000-6631 Jury Operations 130,674 35-242000-41000-6631 Casework Services 217,210 35-242000-42000-6631 Clinical Services 47,965 35-242000-43000-6631 Youth Assistance 97,857 35-243000-33000-6631 Juvenile Support 124,465 35-244000-31100-6631 Family Judges 289,422 Total $ - Circuit Court - State Institutions 35-243000-34000-3640 State Institutions - Previous $ (797,000) 35-242293-52000-3640 State Institutions - New 797,000 Total $ 52nd District Court Revenue 32-501100-20001-0849 52/4 - Refund Defense Attorney Fees $ 15,000 32-501100-20001-1013 52/4 - State Law Cost 10,000 25,000 Expenditures 32-101200-20001-3800 Administration - Visiting Judge 25,000 Total $ Deferred Offender Contracted Services Medical Supplies Mortgages Jury Commission Salaries Jury Commission Fringes Operating Transfer Out Licenses and Permits / $ $ Total $ $ $ $ Total $ $ Total $ 669,100 229,800 439,300 669,100 7,043 6,414 629 7,043 (13,000) 13,000 Equalization - Operating Transfer Out $ Fiscal Services - Postage Purchasing - Professional Services Total $ (21,200) 20,000 1,200 Tornado Siren Equipment Tornado Equipment $ (437,500) 437,500 Total $ A‘ Sheriff Department' Revenue 43-13301-20000-0431 Expenditures 43-023335-22000-2572 43-023301-21400-4240 County Clerk/Register of Deeds Revenue 21-140100-11000-0705 Expenditures 21-250100-01000-2001 21-250100-01000-2075 Drain Commissioner 61-311001-10000-8001 61-211001-10000-3088 Management and Budget 12-340000-10001-8001 12-601200-10001-4284 12-401200-40010-3348 Emergency Management 23-221112-65001-9152 23-221112-65001-9102 GF/GP OPERATIONS - GENERAL AMENDMENTS Revenues Non-Departmental 90-130000-12000-0211 Non-Dept. - Convention Facility Tax $ 873,476 Health Division 16-2331 00-451 00-0901 Reimbursement of Contracts $ 16,737 $ 100,000 $ 93,400 25,000 $ 218,400 $ 1,187,277 $ I 4 1 a i4 Sheriff Department 43-13301-20000-0431 Deferred Offender $ 313,801 Total Revenue $ 1,187,277 Expenditures Library Board - Research Library 51-23100-53000-6636 Information Technology Operations $168,900 Health Division 16-261200-72500-3544 Satellite Centers $436,738 16-201200-33100-2448 Budgeted Projects 131,988 16-201200-33100-3196 Miscellaneous Expense 4,651 16-201200-33100-6631 Building Space Cost 226,600 $ 799,977 Non-Departmental Accounts 90-290000-25000-2564 Contingency 90-290000-25000-9078 Emergency Salaries 90-290000-25000-9169 Misc. Capital Outlay Total Expenditures TOTAL GF/GP OPERATIONS Prepared by: Fiscal Services 06/07/01 2001 SECOND QUARTER FORECAST REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY Y DEPARTMENT FY 2001 BUDGET AMOUNT ADOPTED AS FY 2001 FAVORABLE/ BUDGET AMENDED FORECAST (UNFAVORABLE) PERCENT REVENUES GENERAL FUND Taxes $178,099,500.00 $178,099,500.00 $178,099,500.00 $0.00 0.00% Intergovernmental 37,176,100.00 37 A39,283.00 42,039,283.00 4,600,000.00 12.29% Charges for Services 66,970,305.00 70,633,191.00 72,547,691.00 1,914,500.00 2.71% Miscellaneous Revenue 22,361,008.00 27,516,616.35 22,361,016.35 (5,155,600.00) -18.74% SUB-TOTAL GENERAL FUND $304,606,913.00 $313,688,590.35 $315,047,490.35 $1,358,900.00 0.43% GENERAL PURPOSE FUNDS Intergovernmental $13,540,000.00 $13,540,000.00 $13,540,000.00 $0.00 0.00% Charges for Services 6,019,545.00 6,066,795.00 6,540,695.00 473,900.00 7.81% SUB-TOTAL GP FUNDS $19,559,545.00 $19,606,795.00 $20,080,695.00 $473,900.00 2.42% ADD BACK USE OF FUND BALANCE $0.00 $0.00 $5,155,600.00 5,155,600.00 TOTAL GF/GP FUNDS $324,166,4511.00 $333,295,385.35 $340,283,785.35 $6,988,400.00 2.10% 4 EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN. OF JUSTICE $48,709,327.00 $48,197,619.58 $47,737,619.58 $460,000.00 0.95% 11,741,508.00 11,926,980.62 11,990,980.62 ($64,000.00) -0.54% 2,799,734.00 4,748,750.03 4,708,750.03 $40,000.00 0.84% $63,250,569.00 $64,873,350.23 $64,437,350.23 $436,000.00 0.67% LAW ENFORCEMENT Prosecuting Attorney $15,635,790.00 $15,773,652.57 $15,305,052.57 $468,600.00 2.97% Sheriff 80,980,500.00 82,518,552.90 83,067,752.90 (549,200.00) -0.67% TOTAL LAW ENFORCEMENT $96,616,290.00 $98,292,205.47 $98,372,805.47 ($80,600.00) -0.08% GENERAL GOVERNMENT Clerk/Register of Deeds $9,404,341.00 $10,974,989.09 $10,974,989.09 $0.00 0.00% Treasurer 3,132,197.00 3,269,304.41 3,269,304.41 0.00 0.00% Board of Commissioners 2,546,707.00 2,566,317.95 2,375,717.95 190,600.00 7.43% Library Board 2,690,199.00 2,691,604.59 2,860,504.59 (168,900.00) -6.28% Drain Commissioner 2,891,815.00 2,924,409.93 2,924,409.93 0.00 0.00% TOTAL GENERAL GOVERNMENT $20,665,259.00 $22,426,625.97 $22,404,925.97 $21,700.00 0.10% COUNTY EXECUTIVE County Executive Admn. $5,741,233.00 $5,752,267.47 $5,752,267.47 $0.00 0.00% Management and Budget $17,815,763.00 $18,452,657.87 $18,390,967.87 61,690.00 0.33% Central Services $2,032,358.00 $2,179,177.72 $2,148,077.72 31,100.00 1.43% Facilities Management $1.783,144.00 $1.792,935.85 $1,736,035.85 56,900.00 3.17% Personnel $4,236,204.00 $4,490,423.65 $4,490,423.65 0.00 0.00% Human Svs. $56,172,076.00 $56,868,460.89 $55,961,460.89 907,000.00 1.59% Public Services $8,283,770.00 $9,170,654.78 $9,070,654.78 100,000.00 1.09% IT- Clemis & EMS Comm. $845,088.00 $1,065,255.75 $1,009,555.75 55,700.00 5.23% Community & Economic Dev. $4,970,778.00 $5,113,350.25 $5,307,350.25 (194,000.00) -3.79% Workforce Development $1,049,775.00 $1,049,775.00 $1,049,775.00 0.00 0.00% TOTAL COUNTY EXECUTIVE $102,930,189.00 $105,934,959.23 $104,916,569.23 $1,018,390.00 0.96% TOTAL DEPARTMENTS $283,462,307.00 $291,527,140.90 $290,131,650.90 $1,395,490,00 0.48% NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS $40,704,151.00 $41,768,244.45 $41,905,844.45 ($137,600.00) -0.33% TOTAL GOVERNMENTAL EXPENDITURES 6324,166,458.00 $333,295,385.36 $332,037,495.35 $1,257,890.00 0.38% General Fund/General Purpose Favorable/(Unfavorable) $8,246,290 $8,246,290 COUNTY OF OAKLAND" FY 2001 SECOND QUARTER FORECAST REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS - FOR YEAR ENDING SEPTEMBER 30, 2001. ' BUDGET BUDGET AMOUNT AS AS FY 2001 FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT ,.., PROPERTY TAXES 2000 Tax Levy $177,404,500.00 $177,404,500.00 $177,404,500.00 $0.00 0.00% NET CURRENT PROPERTY TAX $177,404,500.00 $177,404,500.00 $177,404,500.00 $0.00 0.00% OTHER TAXES Other Taxes $695,000.00 $695,000 BO $695,000.00 $0.00 0.00% 695,000.00 695,000.00 695,000.00 0.00 0.00% TOTAL PROPERTY AND OTHER TAXES $178,099,500 00 $178,099,500.00 $178,099,500.00 $0.00 0.00% BUDGETED RECEIPTS OTHER THAN TAXES GENERAL FUND STATE AND FEDERAL Outside Agencies TOTAL BUDGETED RECEIPTS GENERAL FUND STATE AND FEDERAL $37,176,100.00 $37,439,263.00 $42,039,283.00 $37,176,100.00 $37,439,283.00 $42,039,283.00 $4,600,000.00 12.29% Increased Convention Facility tax distribution and State Revenue sharing, due to census changes; as well as increased Indirect Cost revenue due to expanded $4,600,000.00 12.29% charges for the Friend of the Court CRP contract. CHARGES FOR SERVICES County Executive Administration $250 00 $250.00 $450.00 $200.00 80.00% Reimbursement to Directors for attendance at P&R and Bldg. Authority meetings. Auditing 79,000.00 79,000 00 79,000.00 0.00 0.00% Corporation Counsel 132,387.00 132,387.00 132,387.00 0.00 0_00% Fiscal Services 322,605.00 322,605.00 322,605.00 0.00 0.00% Equalization 2,142,536.00 2,142,536.00 2,176,436.00 33,900.00 1.58% Increase based on summary of billing to CVTs Reimbursement Division 270,000.00 270,000.00 270,000.00 0.00 0.00% Materials Management - Auction 2,000.00 2,000.00 3,000.00 1,000.00 0.00% Revenue from County Auction Support Services - Admin (Vending/Cafeteria) 58,800.00 58,800.00 58,800.00 0.00 0.00% Facilities Mgt. - Admin. 53,560.00 53,560.00 53,560.00 0.00 0.00% Facilities Engineering 16,470.00 16,470.00 16,470.00 0.00 0.00% Personnel 9,706.00 9,706.00 9,706.00 0.00 0.00% Human Services Admin - FIA an oo . 500.00 500.00 0.00 0.00% Medical Examiner 83,500.00 84,500.00 112,000.00 , 27,500.00 32.54% Fav due to increased revenue from autopsies Public Services 11,300.00 0.00 - 0.00 0.00% . Animal Control 819,800.00 819,800.00 819,800.00 0.00 0.00% MSU Extension- Oakland County 243,500.00 158,480.00 158,480.00 • 0.00 0.00% 1 05/23/2001 FIRSTREV.xls 40,000.00 0.00 1,663,800.00 137,400.00 0.00 0.00 (1,500.00) 0.00 0.00 20,000.00 TOTAL CHARGES FOR SERVICES GENERAL FUND $66,970,305.00 $70,633,191.00 $72,547,691.00 $1,914,500.00 271% 1,310.00 1,880,535 00 427,200.00 3,710,500.00 48,560.00 1,880,535.00 427,200 00 3,710,500.00 ($60000) 468.200 00 000 6,30000 $473,900.00 -1.24% Billable Educational Training Rev lower than anticipated. 24.90% Fay due to increased activity in water supply inspections and flu vac. 0.00% 0.17% Fay in refund for school meals due to increased population which increases revenue received from the State of Michigan 7.81% FIRSTREV.xls 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30. 2001 BUDGET BUDGET AS AS FY 2001 ADOPTED ADJUSTED FORECAST AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT Community Court Services 195,000.00 363,030.00 343,630.00 (19,400.00) -5.34% - FaV. Fees & Collections $35,300 due to the high success rate of the alternative programs; offset by Charges for Services ($54,700) due to late start of tether program. 000 (90,000.00) 0.00 50,000.00 6,000 00 0 00 0.00 (2,000 00) 0.00 0.00 40,000.00 7,600.00 Community and Economic Development Administration Development & Planning C&E Dev/Workforce Development County Clerk Elections Register of Deeds Treasurer Circuit Court - Gen. Jurisdiction FOC/Family Division District Court Probate Court Prosecutor Sheriffs Office Administrative Services Corrective Services Corrective Services - Satellites Patrol Services Technical Services Board of Commissioners Library Board Drain Administration Engineering & Construction 0.00 11,300.00 11,300.00 692,600.00 692,600.00 602,600.00 1,049,775.00 1,049,775.00 1,049,775.00 1.866,100.00 1,866,100.00 1,916,100.00 16,500.00 16,500.00 22,500.00 10,949,991 00 12,349,558.00 12,349,558.00 4,235,304.00 4,235,304. 00 4,235,304.00 3,017,475.00 3,058.862.00 3,056,862.00 7,293,700 00 7,362,091.00 7,362,091.00 8,956,997.00 8,981,997.00 8,981,997.00 512,300.00 512,300.00 552,300.00 142,700.00 229,700.00 237,300.00 183,300.00 208,300.00 248,300.00 1,000.00 1,000.00 1,000.00 3,076,000.00 4,053,909.00 5,717,709.00 1.436,950.00 1,436,950.00 1,574,350.00 18,030,777.00 18:345,607.00 18,345,607.00 380,183.00 1,019,975 00 1,019,975.00 8,000.00 8,000.00 6,500.00 157,161.00 157,161.00 157,161.00 133,478.00 133,478.00 133,478.00 389,100.00 389,100.00 409,100.00 0.00% -12.99% Declining revenues attributable to aged aerial photography products and the transition from hard-copy products to flexible digital products - Favorable due to increased recovery of bond forfeitures (Creation of Bond Committee) - Favorable due to an increase in late election filing fees (Presidential Election Year) - Unfavorable due to a reduction in defendants eligible for state reimbursement - Favorable due to Gross Estate Fees (Increase in Filings) -Unbudgeted 5% Forensic Lab. Fees. Microfilming, Ptogram Income, and Welfare Fraud Case Review reflect favoribility. 19.20% -Fav. Social Security Incetive Payments 0.00% 41.04% -Fay. SCCAP Grant $238,800, Deferred Offenders $573,677 due to agreesive billing proceedures and additional payment by State of $851,349 for FY2000 received FY2001, Board and Care $35,675 additional revenues detainer billings. 9.56% -Fait Board and Care Work Release 0.00% 0.00% -18.75% -Unfavorable due to lower than anticipated Per Diem collections. 0.00% 0.00% 5.14% -Fav. Soil Erosion Fees due to high level of construction activity. 0.00% 2 68% 36.36% 0.00% 0 00% -0_07% 0.00% 0.00% 7.81% 3.31% BUDGETED RECEIPTS - GENERAL PURPOSE GOVT STATE AND FEDERAL Outside Agencies TOTAL BUDGETED RECEIPTS - GEN. PURPOSE GOVT STATE AND FEDERAL CHARGES FOR SERVICES Emergency Management Services Health Division Friend of the Court Children's Village $13,540,000.00 $13,540,000.00 $13,540,000.00 513,540,000.00 $13,540,000.00 $13,540,000.00 $47,960.00 2,348,735.00 427,20000 3,716,800.00 $6,019,545.00 $6,066795.00 $6.540,695.00 $0. 00 0.00% $0.00 0.00% MISCELLANEOUS REVENUE COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL, SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30, 2001 BUDGET BUDGET AMOUNT AS AS FY 2001 FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT Sundry $400,000.00 $400,000.00 $400,000.00 $0.00 0.00% Investment Income 20,867,258.00 20,867,258.00 20,867,258.00 0.00 0.00% Prior Year's Balance 1,093,750.00 6,249,358.35 1093,758.35 (5,155,600D0) -82.50% Reflects use of General Fund fund balance. See "add back" below. $22,361,008.00 $27,516,616.35 $22,361,016.35 ($5,155,600.00) -18.74% OPERATING TRANSFERS $51,880,022.00 $52,361,381.04 $52,361,381.04 $0.00 0 00% ADD BACK USE OF FUND BALANCE 0 0 5,155,600 5,155,600.00 TOTAL AVAILABLE RESOURCES GENERAL FUND/GENERAL PURPOSE $376,046,480.00 $385,656,766.39 $392,645,166.39 $6,988,400.00 1.81% Less Operating Transfers ($51,880,022.00) ($52,361,381.04) ($52,361,381.04) $0.00 0.00% NET GF/GP RESOURCES 8324,166,458.00 6333,295,385.35 6340,283,785.35 $6,988,400.00 2.10% FIRSTREV.xls 3 05/23/2001 $2,161,071.00 $2,008,042.00 $2,048,042.00 ($40,000.00) -1.99% $0.00 0.00 0.00 0.00% 0.00% 0.00% 0.00% 3.33% 0.00% 0.95% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES CIRCUIT COURT Judicial Administration Controllable Personnel Controllable Operating Non-Controllable Operating AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT $5,289,826.00 $5,289,826.00 $5,289,826.00 $0.00 0.00% 15,706.00 201,460.00 201,460.00 0.00 0.00% 160,900.00 1,957,059.70 1,957,059.70 0.00 0.00% $5,466,432.00 $7,448,345.70 $7,448,345.70 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES $0.00 0.00 (40,000.00) $1,463,803.00 $1,466,456.00 $1,466,456.00 $0.00 6,403,107.00 6,469,494.00 5,969,494.00 500,000.00 1,778,960.00 684,740.11 684,740.11 0.00 Business Division Controllable Personnel Controllable Operating Non-Controllable Operating General Jurisdiction Division Controllable Personnel Controllable Operating Non-Controllable Operating $1,734,545.00 $1,731,516.00 $1,731,516.00 27,386.00 27,386.00 27,386.00 399,140.00 249,140.00 289,140.00 0.00% 0.00% -16.06% - Unfavorable due to higher than anticipated use of Convenience Copier and Stationery Stock. 0.00% 7.73% - Defense Attorney Fees favorable due to an unusually static caseload. 0.00% $9,645,870.00 $8,620,690.11 $8,120,690.11 Family Division/FOC/Juvenile Maint Controllable Personnel $19,298,878.00 $18,617,126.00 $18,617,126.00 Controllable Operating 8,095,588.00 8,315,632.00 8,315,632.00 Non-Controllable Operating 4,041,488.00 3,187,783.77 3,187,783.77 $31,435,954.00 $30,120,541.77 $30,120,541.77 $500,000.00 5.80% $0.00 0.00% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $27,787,052.00 $27,104,924.00 $27,104,924.00 14,541,787.00 15,013,972.00 14,513,972.00 6,380,488.00 6,078,723.58 6,118,723.58 $48,709,327.00 $48,197,619.58 $47,737,619.58 $0.00 500,000.00 (40,000.00) ---- $460,000.00 05/16/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT District Court Administration Controllable Personnel $81,199.00 $81,199.00 $81,199.00 $0.00 0.00% Controllable Operating 33,240.00 58,240.00 83,240.00 (25,000.00) -42.93% Non-Controllable Operating 0.00 0.00 0.00 0.00 0.00% $114,439.00 $139,439.00 $164,439.00 ($25,000.00) -17.93% EXPLANATION OF SIGNIFICANT VARIANCES $25,000 reflects the use of a visiting judge to cover for a judge's unexpected medical leave. Division 1 - Novi Controllable Personnel $2,797,665.00 $2,797,665.00 $2,797,665.00 $0.00 0.00% Controllable Operating 788,714.00 805,870.68 831,870.68 (26,000.00) -3.23% - $6,000 in outside printing costs reflect the production of the Court's Annual Report. $20,000 reflect increased defense attorney fee payments. Non-Controllable Operating 300,784.00 317,300.66 317,300.66 0.00 0.00% $3,887,163.00 $3,920,836.34 $3,946,836.34 ($26,000.00) -0.66% Division 2 - Clarkston Controllable Personnel $1,000,983.00 $1,000,983.00 $1,000,983.00 $0.00 0.00% Controllable Operating 321,491.00 323,780.95 323,780.95 0.00 0.00% Non-Controllable Operating 182,581.00 205,165.35 205,165.35 0.00 0.00% $1,505,055.00 $1,529,929.30 $1,529,929.30 $0.00 0.00% Division 3 - Rochester Hills Controllable Personnel $2,411,990.00 $2,415,358.00 $2,415,358.00 $0.00 0.00% Controllable Operating 713,294.00 756,701.26 756,701.26 0.00 0.00% Non-Controllable Operating 395,760.00 427,814.25 427,814.25 0.00 0.00% $3,521,044.00 $3,599,873.51 $3,599,873.51 $0.00 0.00% Division 4- Troy Controllable Personnel $1,854,244.00 $1,854,244.00 $1,854,244.00 $0.00 0.00% Controllable Operating 457,153.00 466,773.49 479,773.49 (13,000.00) -2.79% - $2,000 reflects greater than anticipated use in court reporter services to cover employee leave. $11,000 in increased psych./med. examinations of defendants. Non-Controllable Operating 402,410.00 415,884.98 415,884.98 0.00 0.00% $2,713,807.00 $2,736,902.47 $2,749,902.47 ($13,000.00) -0.47% Department Total Controllable Personnel $8,146,081.00 $8,149,449.00 $8,149,449.00 $0.00 0.00% Controllable Operating 2,313,892.00 2,411,366.38 2,475,366.38 (64,000.00) -2.65% Non-Controllable Operating 1,281,535.00 1,366,165.24 1,366,165.24 0.00 0.00% $11,741,508.00 $11,926,980.62 $11,990,980.62 ($64,000.00) -0.54% 05/10/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Judicial/Administration Controllable Personnel $1,595,394.00 $1,595,394.00 $1,595,394.00 $0.00 0.00% Controllable Operating 63,728.00 64,528.00 64,528.00 0.00 0.00% Non-Controllable Operating 574,510.00 438,484.17 438,484.17 0.00 0.00% $2,233,632.00 $2,098,406.17 $2,098,406.17 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Judicial Support Controllable Personnel $535,102.00 $1,311,571.00 $1,311,571.00 $0.00 0.00% Controllable Operating 31,000.00 620,882.00 580,882.00 40,000.00 6.44% - Favorability reflects lower than anticipated defense attorney fee payments. Non-controllable Operating 0.00 717,890.86 717,890.86 0.00 0.00% $566,102.00 $2,650,343.86 $2,610,343.86 $40,000.00 1.51% Department Total Controllable Personnel $2,130,496.00 $2,906,965.00 $2,906,965.00 $0.00 0.00% Controllable Operating 94,728.00 685,410.00 645,410.00 40,000.00 5.84% Non-Controllable Operating 574,510.00 1,156,375.03 1,156,375.03 0.00 0.00% $2,799,734.00 $4,748,750.03 $4,708,750.03 $40,000.00 0.84% 05/09/2001 Controllable Operating 2,758.00 Non-Controllable Operating 0.00 $1,874,860.00 2,758.00 0.00 $1,874,860.00 2,758.00 0.00% 0.00 0.00% $48,000.00 2.56% $1,826,860.00 1.06% - Fav. Salary $10,000 and Fringe $5,000 due to turnover. 0.00% 0.00% 1.05% 3.61% 2.16% 0.00% COUNTY OF OAKLAND PROSECUTING ATTORNEY FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $1,957,550.00 $1,957,550.00 $1,872,550.00 1,693,827.00 1,811,024.80 1,770,424.80 2,026,480.00 2,047,144.77 2,047,144.77 0.00 4.34% - Turnover reflects Salaries fay. $52,000 and Fringe Benefits fav. $33,000 2.24% - Fav. Expert Wit. Fee & Mileage $6,400 and fav. Extradition Exp. $42,200 reflects weaker demand on resources; partially offset by unfav. Special Pros. Atty. ($8,000) due to greater than anticipated Attorney's being ordered to serve as Special Prosecutors in accordance with State law. 0.00% - $85,000.00 40,600.00 $5,677,857.00 $5,815,719.57 $5,690,119.57 $125,600.00 2.16% Litigation Controllable Personnel Controllable Operating Non-Controllable Operating $6,603,410.00 $6,603,410.00 $6,323,410.00 $280,000.00 4.24% - Fav. Salary $200,000 and Fringe $80,000 due to turnover. 56,492.00 56,492.00 $56,492.00 0.00% 0.00 0.00 $0.00 0.00% -------- $6,659,902.00 $6,659,902.00 $6,379,902.00 $280,000.00 4.20% Warrants Controllable Personnel $1,872,102.00 $1,872,102.00 $1,824,102.00 $48,000.00 2.56% - Fav. Salary $45,000 and Fringe $10,000 due to turnover; partially offset by unfav. Overtime ($7,000). Appellate Controllable Personnel Controllable Operating Non-Controllable Operating Department Controllable Personnel Controllable Operating Non-Controllable Operating $1,416,286.00 $1,416,286.00 $1,401,286.00 $15,000.00 6,885.00 6,885.00 6,885.00 0.00 0.00 0.00 $1,423,171.00 $1,423,171.00 $1,408,171.00 $15,000.00 $11,849,348.00 $11,849,348.00 $11,421,348.00 $428,000.00 1,759,962.00 1,877,159.80 1,836,559.80 40,600.00 2,026,480.00 2,047,144.77 2,047,144.77 0.00 $15,635,790.00 $15,773,652.57 $15,305,052.57 $468,600.00 2.97% 05/22/2001 143,819.75 1,026,346.00 133,600.00 1,026,346.00 $0.00 ($20,400.00) $143,819.75 $1,046,746.00 Controllable Operating Non-Controllable Operating 0.00% -1.99% -Unfav. Copier ($400) and Housekeeping ($20,000) due to increased useage $155,532.00 2,150,235.00 $0.00 ($9,400.00) $0.00 $380,910.12 $2,187,253.00 $55,548.00 $380,910.12 2,177,853.00 55,548.00 Controllable Operating Non-Controllable Operating Operating Transfer Out 0.00% -0.43% -Unfav. Info Tech Rental ($8,000) and Telephone Commun. ($1,400) due to increased useage -Fay. Salaries $87,000 and fringes $59,800 due to turover offset by unfav. Overtime ($59,000) -Unfav. Radio Rental ($4,800), Copier ($4,700). COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES SHERIFF'S DEPARTMENT ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2001 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Controllable Personnel Controllable Operating Non-Controllable Operating $966,409.00 $969,993.00 $969,993.00 364,817.00 419,245.48 $419,245.48 1,356,000.00 1,363,500.00 $1 423,400.00 $0.00 0.00% 0.00% ($59,900.00) -4.39% -Unfav. Radio Rental ($33,700) and Leased Vehicles ($26,200) due to increased useage $2,687,226.00 $2,752,738.48 $2,812,638.48 ($59,900.00) -2.18% $914,592.00 627,406.00 427,622.00 Administrative Services Controllable Personnel Controllable Operating Non-Controllable Operating $914,592.00 $914,592.00 $0.00 685,162.63 $685,162.63 $0.00 427,622.00 $434,122.00 ($6,500.00) 0.00% 0.00% -1.52% -Unfav. Radio Rental ($5,500) and Copier Costs ($1,000) due to increased useage $1,969,620 00 $2,027,376.63 $2,033,876.63 ($6,500.00) -0.32% Corrective Services Controllable Personnel Controllable Operating Non-Controllable Operating $17,682,945.00 $17,386,020.00 $17,339,320.00 5,514,237.00 5,561,139.29 $6,230,239.29 6,347,390.00 6,529,719.05 $6,594,719.05 ($65,000.00) 0.27% -Fav. salaries $332,100 and fringes $67,400 due to turnover partially offset by unfav. overtime ($352,800) -12.03% -Unfav. Contract Serv. ($229,800) due to difference between FY2001 budget and vendor contract ($129,400) and charges billed to FY2001 ($100,400) in Food Services. Unfav. Medical Supplies ($439,300) due to increased cost of drugs and other supplies.Budget amendments are recommended -1.00% -Unfav. Radio Rental ($59,200) and Copier ($5,800) due to increased useage $46,700.00 ($669,100.00) $29,544,572.00 $29,476,878.34 $30,164,278.34 ($687,400.00) -2.33% Corrective Services-Satellites Controllable Personnel 0.91% -Fay. Overtime $84,000 and fringes $63,600 due to turnover partially offset by unfav. salaries ($37,900) $11,772,340.00 $12,069,265.00 $11,959,565.00 $109,700.00 Patrol Services Controllable Personnel $12,932,286.00 $13,239,430.75 $13,150,130.75 $89,300.00 0.67% $22,155,485.00 $22,414,560.00 $22,368,160.00 $46,400.00 0.21% -Fav. salaries $240,400 and fringes $36,300 due to turnover offset by unfav. overtime ($230,300) due to patrol contracts offset by revenue. $24,461,252.00 $25,028,871.12 $24,991,871.12 $37,000.00 0.15% Technical Services Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out $7,817,975.00 $7,946,149.00 $7,858,349.00 670,816.00 774,261.89 $774,261.89 896,753.00 1,024,846.69 $1,034,346.69 248,000.00 $248,000.00 $9,385,544.00 $9,993,257.58 $9,914,957.58 $61,309,746.00 $61,700,579.00 $61,409,979.00 7,466,408.00 7,964,539.16 8,633,639.16 12,204,346.00 12,549,886.74 12,720,586.74 303,548.00 303,548.00 $87,800.00 ,. $0.00 ($9,500.00) $0.00 $78,300.00 0.78% $290,600.00 (669,100.00) (170,700.00) 0.00 1.10% 0.00% -0.93% 0.47% -8.40% -1.36% $80,980,500.00 $82,518,552.90 $83,067,752.90 ($549,200.00) -0.67% 05/23/2001 0.00% 0.00% 0.00% 0.00% Administration Controllable Personnel Controllable Operating Non-Controllable Operating County Clerk Controllable Personnel Controllable Operating Non-Controllable Operating Elections Controllable Personnel Controllable Operating Non-Controllable Operating $393,710.00 495,595.00 110,055.00 $393,710.00 581,991.47 168,600.00 $393,710.00 $581,991.47 168,600.00 0.00% - 0.00% 0.00% $0.00 0.00 0.00 $0.00 0.00 0.00 0.00% 0.00% 0.00% Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $388,861.00 80,340.00 122,235.00 $591,436.00 $388,861.00 388,861.00 $0.00 755,506.84 755,506.84 0.00 130,764.83 130,764.83 0.00 $1,275,132.67 $1,275,132.67 $0.00 $3,292,307.00 $3,313,642.00 $3,313,642.00 274,214.00 280,587.13 280,587.13 583,250.00 629,821.73 629,821.73 $4,149,771.00 $4,224,050.86 $4,224,050.86 $0.00 0.00 0.00 0.00% 0.00% 0.00% $0.00 0.00% Register of Deeds Controllable Personnel Controllable Operating Non-Controllable Operating $999,360.00 $1,144,301.47 $1,144,301.47 $1,839,104.00 $1,842,677.00 $1,842,677.00 909,344.00 1,562,773.50 1,562,773.50 797,810.00 801,623.56 801,623.56 $3,546,258.00 $4,207,074.06 $4,207,074.06 $0.00 0.00% $0.00 0.00% Jury Commission Controllable Personnel $7,503.00 $7,503.00 7,503.00 $0.00 0.00% 44,363.00 44,363.00 44,363.00 0.00 65,650.00 72,564.03 72,564.03 0.00 _________ $117,516.00 $124,430.03 $124,430.03 $0.00 $5,921,485.00 $5,946,393.00 $5,946,393.00 $0.00 1,803,856.00 3,225,221.94 3,225,221.94 0.00 1,679,000.00 1,803,374.15 1,803,374.15 0.00 $9,404,341.00 $10,974,989.09 $10,974,989.09 $0.00 05/22/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES COUNTY TREASURER ADOPTED BUDGET Administration Controllable Personnel Controllable Operating Non-Controllable Operatin 496,013.00 Division Total $3,132,197.00 Department Total $3,132,197.00 AMENDED BUDGET $2,407,547.00 295,598.00 566,159.41 $3,269,304.41 $3,269,304.41 FY 2001 FORECAST $2,407,547.00 $295,598.00 $566,159.41 $3,269,304.41 $3,269,304.41 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT $0.00 0.00% 0.00 0.00% 0.00 0.00% $0.00 0.00% $0.00 0.00% $2,407,547.00 228,637.00 EXPLANATION OF SIGNIFICANT VARIANCES 05/23/2001 Info. Tech. Operations unfav. Budget amend. Recommended. 0.00% 0.00% -17.61% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES BOARD OF COMMISSIONERS ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2001 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $1,678,976.00 $1,696,806.00 $1,628,306.00 418,040.00 418,040.00 $329,540.00 449,691.00 451,471.95 $417,871.95 33,600.00 4.04% - Fav.due to turnover. 21.17% - Fav. Legal Expense $28,000,Legislative Expense $4,400, Prof. Serv. $7,600,Pub. Info. $35,000,Travel $25,000 lesser demand on resources. Unfav. Advertising ($2,000), Comm. ($1,500), Work Shop ($8,000) due to heavy usage. 7.44% - Fav. Info Tech Oper.$32,700, Printing $4,000, Provis $2,000 lesser demand on resources. Unfav. Vehicles ($1,100), Copier ($4,000), due to heavy usage. $68,500.00 88,500.00 $2,546,707.00 $2,566,317.95 $2,375,717.95 $190,600.00 7.43% Library Board Controllable Personnel Controllable Operating Non-Controllable Operating $882,471.00 850,278.00 957,450.00 $882,471.00 850,283.04 958,850.55 $882,471.00 $850,283.04 $1,127,750.55 $0.00 0.00 (168,900.00) $2,690,199.00 $2,691,604.59 $2,860,504.59 ($168,900.00) -6.28% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $2,561,447.00 $2,579,277.00 $2,510,777.00 $68,500.00 1,268,318.00 1,268,323.04 1,179,823.04 88,500.00 1,407,141.00 1,410,322.50 1,545,622.50 (135,300.00) 2.66% 6.98% -9.59% $5,236,906.00 $5,257,922.54 $5,236,222.54 $21,700.00 0.41% 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES DRAIN COMMISSIONER AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT Drain Commissioner Controllable Personnel $1,972,457.00 $1,967,964.00 $1,967,964.00 $0.00 0.00% Controllable Operating 224,327.00 224,460.00 224,460.00 0.00 0.00% Non-Controllable Operating 695,031.00 731,985.93 731,985.93 0.00 0.00% Total $2,891,815.00 $2,924,409.93 $2,924,409.93 $0.00 0.00% Department Total $2,891,815.00 $2,924409.93 $2,924,409.93 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Prepared by: Budget Division 05/23/2001 $1,164,569.00 26,044.00 195,681.61 $0.00 0.00% 0.00 0.00% 0.00 0.00% $1,535,165.00 33,301.00 277,287.84 $0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00% 0.00% 0.00% - $0.00 0.00 0.00 COUNTY OF OAKLAND FY 2001 SECOND FORECAST REPORT EXPENDITURES COUNTY EXECUTIVE ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2001 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $1,853,096.00 $1,854,517.00 $1,854,517.00 262,386.00 267,906.96 267,906.96 396,914.00 397,795.06 397,795.06 $2,512,396.00 $2,520,219.02 $2,520,219.02 $0.00 0.00% 0.00 0.00% 0.00 0.00% ------- $0.00 0.00% Auditing Controllable Personnel $1,164,569.00 $1,164,569.00 Controllable Operating 26,044.00 26,044.00 Non-Controllable Operating 195,637.00 195,681.61 Corporation Counsel Controllable Personnel $1,535,165.00 $1,535,165.00 Controllable Operating 33,301.00 33,301.00 Non-Controllable Operating 274,121.00 277,287.84 $0.00 0.00% $0.00 0.00% $1,386,250.00 $1,386,294.61 $1,386,294.61 $1,842,587.00 $1,845,753.84 $1,845,753.84 Department Total Controllable Personnel $4,552,830.00 Controllable Operating 321,731.00 Non-Controllable Operating 866,672.00 $4,554,251.00 $4,554,251.00 327,251.96 327,251.96 870,764.51 870,764.51 $5,741,233.00 $5,752,267.47 $5,752,267.47 $0.00 0.00% 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Controllable Personnel $279,898.00 $279,898.00 $279,898.00 $0.00 0.00% Controllable Operating 11,093.00 11,093.00 11,093.00 0.00 0.00% Non-Controllable Operating 10,771.00 10,771.00 10,771.00 0.00 0.00% $301,762.00 $301,762.00 $301,762.00 $0.00 0.00% Purchasing Controllable Personnel $794,465.00 $794,465.00 $794,465.00 $0.00 0.00% Controllable Operating 28,348.00 42,188.46 42,188.46 0.00 0.00% Non-Controllable Operating 137,702.00 138,306.69 138,306.69 0.00 0.00% $960,515.00 $974,960.15 $974,960.15 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Equalization Controllable Personnel $6,169,663.00 $6,302,877.00 $6,302,877.00 $0.00 0.00% Controllable Operating 389,350.00 463,358.76 463,358.76 0.00 0.00% Non-Controllable Operating 1,041,883.00 1,194,334.46 1,194,334.46 0.00 0.00% Transfers Out 81,690.00 81,690.00 0.00 81,690.00 0.00% Fav. IT transfer: Misc. Res. #98309 for FY 1999 and FY 2000, not required in FY 2001. $7,682,586.00 $8,042,260.22 $7,960,570.22 $81,690.00 1.02% Fiscal Services Controllable Personnel $3,889,665.00 $3,889,665.00 $3,889,665.00 $0.00 0.00% Controllable Operating 163,534.00 166,003.68 186,003.68 (20,000.00) -12.05% Unf. Postage due to Finance Committee mailings, Budget Amendment recommended Non-Controllable Operating 752,446.00 981,467.05 981,467.05 0.00 0.00% $4,805,645.00 $5,037,135.73 $5,057,135.73 ($20,000.00) -0.40% Reimbursement Controllable Personnel $2,972,169.00 $2,981,075.00 $2,981,075.00 0.00 0.00% Controllable Operating 349,416.00 358,324.82 358,324.82 0.00 0.00% Non-Controllable Operating 743,670.00 757,139.95 757,139.95 0.00 0.00% $4,065,255.00 $4,096,539.77 $4,096,539.77 $0.00 0.00% Department Total Controllable Personnel $14,105,860.00 $14,247,980.00 $14,247,980.00 • $0.00 0.00% Controllable Operating 941,741.00 1,040,968.72 1,060,968.72 (20,000.00) -1.92% Non-Controllable Operating 2,686,472.00 3,082,019.15 3,082,019.15 0.00 0.00% Transfers Out 81,690.00 81,690.00 0.00 81,690.00 100.00% $17,815,763.00 $18,452,657.87 $18,390,967.87 $61,690.00 0.33% 05/23/2001 $152,076.00 $152,076.00 $152,076.00 2,016.00 2,016.00 216.00 11,338.00 11,338.00 11,338.00 $165,430.00 $165,430.00 $163,630.00 $923,432.00 34,342.14 995,158.58 31,515.00 Administrative Controllable Personnel Controllable Operating Non-Controllable Operating $0.00 1,800.00 - Fay. due to minimal mileage and travel & conference. 0.00 Support Services Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer out $1,800.00 $51.200.00 - Fav. due to unfilled PTNE positions and vacant Clerk II position. 18,300.00 - Fay. due to delay in delivery of shelving for record retention (40,200.00) - (Unfay) I.T. Operations, Convenience Copier, Micrographics & Reproduction. 0.00 $895,176 00 50.531 00 921,221 00 0 00 $974,632.00 52.642 14 954.958 58 31,515.00 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) EXPLANATION OF SIGNIFICANT VARIANCES $1,866,928.00 $2,013,747.72 $1,984,447.72 $29,300.00 Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer $1,047,252.00 $1,126,708.00 $1,075,508.00 52,547.00 54,658.14 34,558.14 932,559.00 966,296.58 1,006,496.58 0.00 31,515.00 31,515.00 $51,200.00 20,100.00 (40,200.00) 0.00 $2,032,358.00 $2,179,177.72 $2,148,077.72 $31,100.00 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES FACILITIES MANAGEMENT Administration Controllable Personnel Controllable Operating Non-Controllable Operating Facilities Engineering Controllable Personnel Controllable Operating Non-Controllable Operating AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $435,560.00 $435,560.00 $408,360.00 $27,200.00 6.24% - Turnover 14,875.00 24,055.00 24,055.00 0.00 0.00% 63,369.00 63,369.00 61,869.00 1,500.00 2.37% - Fav. Copier costs $513,804.00 $522,984.00 $494,284.00 $28,700.00 5.49% $898,106.00 $898,106.00 $869,906.00 $28,200.00 3.14% - Turnover and fav. Overtime 254,775.00 254,786.37 254,786.37 0.00 0.00% 116,459.00 117,059.48 117,059.48 0.00 0.00% $1,269,340.00 $1,269,951.85 $1,241,751.85 $28,200.00 2.22% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $1,333,666.00 $1,333,666.00 $1,278,266.00 $55,400.00 4.15% 269,650.00 278,841.37 278,841.37 0.00 0.00% 179,828.00 180,428.48 178,928.48 1,500.00 0.83% $1,783,144.00 $1,792,935.85 $1,736,035.85 $56,900.00 3.17% 05/14/2001 $273,924.00 9,919.00 10,518.00 $273,924.00 10,722.42 19,516.11 $273,924.00 10,722.42 19,516.11 $0.00 $0.00 $0.00 $0.00 0.00% $0.00 0.00 0.00 0.00% 0.00% 0.00% $0.00 0.00 0.00 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES PERSONNEL ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2001 FAVORABLE FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $294,361.00 $304,162.53 $304,162.53 $0.00 0.00% 0.00% 0.00% 0.00% Human Resources Controllable Personnel Controllable Operating Non-Controllable Operating Employee Relations Controllable Personnel Controllable Operating Non-Controllable Operating $1,908,413.00 $191210600 $1,912,106.00 436,501 00 487,186 18 487,186.18 515,538.00 604,949 95 604,949.95 $2,860,452.00 $3,004,242.13 $3,004,242.13 $677,604.00 $677,604.00 $677,604.00 232,869.00 333,496.99 333,496.99 170,918.00 170,918.00 170,918.00 $0.00 $0.00 $0.00 0.00% 0.00% 0.00% $1,081,391.00 $1,182,018.99 $1,182,018.99 $0.00 0.00% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $2,859,941.00 $2,863,634.00 679,289.00 831,405.59 696,974.00 795,384.06 $2,863,634.00 831,405.59 795,384.06 $4,236,204.00 $4,490,423.65 $4,490,423.65 $0.00 0.00% 05/23/2001 Administration Controllable Personnel Controllable Operating Non-Controllable Operating $154,879.00 9,895,034.00 12,639.00 $154,879.00 9,965,034.00 12,639.00 $154,879.00 9,965,034.00 12,639.00 $0.00 0.00 0.00 0.00% 0.00% 0.00% Non-Controllable Operating 2,141,231.00 2,180,851.83 2,180,851.83 $13,782,558.00 $13,845,188.28 $13,497,788.28 Medical Examiner Controllable Personnel $2,004,153.00 $2,005,820.00 $2,019,820.00 Controllable Operating 470,526.00 471,538.80 568,138.80 3.81% -0.54% -4.30% 1.59% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $10,062,552.00 $10,132,552.00 $10,132,552.00 $0.00 0.00% Health Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out $22,029,775.00 $22,030,699.00 $21,115,699.00 $915,000.00 3,734,599.00 4,143,591.62 4,122,391.62 21,200.00 2,841,746.00 2,944,591.45 3,210,591.45 (266,000.00) 243,917.00 243,917.00 243,917.00 0.00 $28,850,037.00 $29,362,799.07 $28,692,599.07 $670,200.00 4.15% - Fav due to staff turnover and vacancies 0.51% - Fav due to less than anticipated use of outside contractors. -9.03% - (Unfav) Bldg. Space (unbudgeted) and Convenience Copier. 0.00% A budget amendment is recommended. 2.28% Children's Village Controllable Personnel Controllable Operating $9,012,355.00 $9,027,261.00 $8,661,561.00 2,628,972.00 2,637,075.45 2,655,375.45 $365,700.00 4.05% - Fav due to filling (7) eligible positions with PINE positions (18,300.00) -0.69% - (Unfav) Culinary Supplies and Provisions due louse of safe security silverware, dishes and paper products for (A South Girls) Security Detention and (J Bldg Boys). 0.00 0.00% $347,400.00 2.51% ($14,000.00) -0.70% - (Unfav) Overtime due to increased workload for death scene investigations. (96,600.00) -20.49% - (Unfav) due to contractual rate increase for body transport and increased workload for Medical Services Autopsies. Non-Controllable Operating 1,002,250.00 1,050,562.74 1,050,562.74 0.00 0.00% $3,476,929.00 $3,527,921.54 $3,638,521.54 ($110,600.00) -3.13% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out $33,201,162.00 $33,218,659.00 $31,951,959.00 $1,266,700.00 16,729,131.00 17,217,239.87 17,310,939.87 (93,700.00) 5,997,866.00 6,188,645.02 6,454,645.02 (266,000.00) 243,917.00 243,917.00 243,917.00 0.00 $56,172,076.00 $56,868,460.89 $55,961,460.89 $907,000.00 05/23/2001 $0.00 0.00 0.00 0.00% 0.00% 0.00% Public Services - Admin. Controllable Personnel Controllable Operating Non-Controllable Operating Veteran's Services Controllable Personnel Controllable Operating Non-Controllable Operating Community Corrections Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out $0.00 0.00% $0.00 0.00% 4.94% - Fay. Salaries & Fringes $100,000 due to vacant positions and late start of tether program. 0.00% 0.00% $100,000.00 0.00 0.00 0.00 $0.00 0.00 0.00 0.00% 0.00% 0.00% MSU Ext. - Oakland County Controllable Personnel Controllable Operating Non-Controllable Operating $625,775.00 $694,463.00 341,374.00 350,842.98 243,832.00 244,921.57 $694,463.00 350,842.98 244,921.57 $0.00 0.00 0.00 0.00% 0.00% 0.00% $0.00 0.00 0.00 0.00% 0.00% 0.00% Circuit Court Probation Controllable Personnel Controllable Operating Non-Controllable Operating $0.00 49,525.00 798,103.00 $0.00 50,595.70 803,172.66 $0.00 50,595.70 803,172.66 0.00 0.00 0.00 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT $140,047.00 $140,047.00 $140,047.00 4,660.00 4,660.00 4,660.00 7,293.00 7,293.00 7,293.00 EXPLANATION OF SIGNIFICANT VARIANCES $152,000.00 $152,000.00 $152,000.00 $1,237,208.00 $1,237,208.00 $1,237,208.00 290,907.00 293,272.07 293,272.07 266,784.00 266,911.90 266,911.90 $1,794,899.00 $1,797,391.97 $1,797,391.97 $1,744,609.00 $2,024,585.00 $1,924,585.00 301,075.00 637,293.00 637,293.00 254,376.00 364,950.00 364,950.00 66,000.00 66,000.00 $2,300,060.00 $3,092,828.00 $2,992,828.00 $100,000.00 3.23% Animal Control Controllable Personnel Controllable Operating Non-Controllable Operating $1,210,981.00 $1,290,227.55 $1,290,227.55 $1,352,314.00 $1,352,314.00 $1,352,314.00 115,759.00 119,703.07 119,703.07 510,129.00 512,421.83 512,421.83 $1,978,202.00 $1,984,438.90 $1,984,438.90 $0.00 0.00% $0.00 0.00% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer Out $847,628.00 $853,768.36 $853,768.36 $5,099,953.00 $5,448,617.00 $5,348,617.00 1,103,300.00 1,456,366.82 1,456,366.82 2,080,517.00 2,199,670.96 2,199,670.96 0.00 66,000.00 66,000.00 $0.00 0.00% $100,000.00 0.00 0.00 0.00 1.84% 0.00% 0.00% $8,283,770.00 $9,170,654.78 $9,070,654.78 $100,000.00 1.09% 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES CLEMIS AND EMERGENCY MANAGEMENT AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Emergency Management Controllable Personnel $381,329.00 $381,329.00 $325,629.00 $55,700.00 14.61% Fay. Overtime and turnover. Controllable Operating Non-Controllable Operating Division Total Department Total 230,895 00 451,063 00 8451,063.00 0.00 0.00% 232.864 00 232.863 75 $232,863.75 0.00 0.00% $845.088 00 $1 065,255 75 $1.009.555 75 $55,700.00 5.23% $845.088 00 81.065.255 75 $1.009,555.75 $55,700 00 5.23% 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENT AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel $505,387.00 $505,387.00 $505,387.00 $0.00 0.00% - Controllable Operating 203,650.00 209,818.00 $403,818.00 ($194,000.00) -92.46% - Unbudgeted expenditure for Resource Cycling Systems contract. Non-Controllable Operating 94,530.00 96,055.00 $96,055.00 $0.00 0.00% $803,567.00 $811260.00 $1,005,260.00 ($194,000.00) -23.91% Planning and Economic Development Services Controllable Personnel $2,488,188.00 $2,490,862.00 $2,490,862.00 $0.00 0.00% - Controllable Operating 708,135.00 839,566.00 $839,566.00 $0.00 0.00% - Non-Controllable Operating 671,638.00 672,412.25 $672,412.25 $0.00 0.00% $3,867,961.00 $4,002,840.25 $4,002,840.25 $0.00 0.00% Community and Home Improvement Controllable Personnel Controllable Operating 299,250.00 299,250.00 $299,250.00 0.00 0.00% Non-Controllable Operating $299,250.00 $299,250.00 $299,250.00 $0.00 0.00% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer $2,993,575.00 $2,996,249.00 $2,996,249.00 $0.00 0.00% 1,211,035.00 1,348,634.00 1,542,634.00 (194,000.00) -14.38% 766,168.00 768,467.25 768,467.25 0.00 0.00% 0.00 0.00 0.00 0.00 0.00% $4,970,778.00 $5,113,350.25 $5,307,350.25 ($194,000.00) -3.79% 05/23/2001 $0 00 0 00 0 00 0.00 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES COMMUNITY AND ECONOMIC DEVELOPMENTNVORKFORCE DEVELOPMENT AMOUNT ADOPTED AMENDED FY 2001 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Workforce Development Controllable Personnel $689,039.00 $689,039.00 $689,039.00 $0.00 0.00% - Controllable Operating 239,621.00 239,621.00 $239,621.00 $0.00 0.00% - Non-Controllable Operating 121,115.00 121,115.00 $121,115.00 $0.00 0.00% $1,049.775 00 $1,049,775 00 $1.049,775.00 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Department Total Controllable Personnel Controllable Operating Non-Controllable Operating Operating Transfer $689.039 00 239.621 00 121,115 00 0.00 $689,039 00 239,621 00 121,115.00 0.00 $689,039.00 239.621.00 121,115.00 0.00 $1,049,775.00 $1,049,775.00 $1,049,775.00 $0.00 0.00% 05/23/2001 COUNTY OF OAKLAND FY 2001 SECOND QUARTER FORECAST REPORT EXPENDITURES BUDGET BUDGET AMOUNT AS AS FY 2001 FAVORABLE ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION INON-DEPART. APPROPRIATIONS I COUNTY OPERATIONS Financial System $0.00 $0.00 $0.00 0.00% State Institutions 800,000.00 - _ 0.00% Transition Expenses - 15,000.00 16,100,00 (1,100.00) -7.33% Higher operating cost than anticipated. Ambulance 19,800.00 19,800.00 25,000.00 (5,200.00) -26.26% Increased demand for service in the first six months of the fiscal year. Doctors/ Hospitals - 110,000.00 110,000.00 0.00% Insurance and Surety Bonds 89,145.00 89,145.00 92,045.00 (2,900.00) -3.25% Road Commission - Drain Assessment 1,200,000.00 1,200,000.00 1,200,000.00 0.00% Road Commission - Tr-Party Agreement 1,250,000.00 1,250,000.00 1,250,000.00 0.00% Remonumentation - - - 0.00% Tax Tribunal - 100,000.00 100,000.00 0.00% MAN/WAN 3,300,000.00 3,300,000.00 3,300,000.00 0.00% Information Technology - CLEMIS 1,408,000.00 - - 0.00% Mental Health Authority 9,620,616.00 9,620,616.00 9,620,616.00 0.00% Grant Match - 924,000.00 924,000.00 0.00% GIS Automation - 137,544.70 137,544.70 0.00% $17,687,561.00 $16,766,105.70 $16,775,305.70 ($9,200.00) -0.05% CHILD CARE CENTER Office Supplies Professional Services Screening and Background Checks Postage Materials Management - Misc. Stationery Stock Information Technology - Operations Print Shop Convenience Copier Telephone Communications COUNTY BUILDINGS COUNTY ASSOCIATIONS S.E.M.C.O.G. Association of Metro Sewage Groups Area Wide Water Quality Clinton River Watershed Council Huron River Watershed Council Partnership for Saginaw River Watershed Rouge River Watershed Council National Assoc. of Counties Michigan Assoc. of Counties BU.xl5 $500.00 $500.00 $500.00 0.00% Budget amendment recommended to move all cost associated with the Child Care - - - 0.00% Facility to the Fringe Benefit Fund. - _ - 0.00% - - - 0.00% - - - 0.00% - - - 0.00% 20,000.00 20,000.00 20,000.00 0.00% - - - 0.00% - _ - 0.00% 2,217.00 2,217.00 2,217.00 0.00% $22,717.00 $22,717.00 $22,717.00 $0.00 0.00% $2,686,858.00 $2,379,939.28 $2,379,939.28 0.00% $432,600.00 $432,600.00 $432,600.00 0.00% - - 1,700.00 (1,700.00) 0.00% Expenses not budgeted. 54,000.00 54,000.00 51,000.00 3,000.00 5.56% Actual dues. 5,141.00 5,141.00 5,141.00 0.00% 2,706.00 2,706.00 2,706.00 0.00% 2,276.00 2,276.00 2,276.00 0.00% 2,177.00 2,177.00 2,177.00 0.00% 20,200.00 20,200.00 20,200.00 0.00% 58,000.00 58,000.00 60,700.00 (2,700.00) -4.66% Actual dues. 1 05/23/2001 Traffic Improvement Association 23,000.00 23,000.00 30,000.00 (7,000.00) -30.43% Actual dues. $600,100.00 $600,100.00 $608,500.00 ($8,400.00) -1.40% SUNDRY $300,000.00 $300,000.00 $300,000.00 0.00% RESERVED FOR TRANSFERS Expenditures Contingency $300,000.00 $217,895.00 Defense Attorney Fees 52,000.00 52,000.00 Infrastructure Improvements - Jury Fees and Mileage 200,000.00 200,000.00 Salary Adjustment - Legislative Expense 193,628.00 175,798.00 Oakland County Court Reapportionment 10,000.00 10,000.00 Info Tech Development 2,500,000.00 1,286,585.47 Classification & Rate Change 175,592.00 107,705.00 Overtime 53,000.00 53,000.00 Summer Employment 441,168.00 441,168.00 Emergency Salaries 846,560.00 846,560.00 Fringe Benefit Adjustments Land Acquisition - 880,000.00 Capital Outlay 75,000.00 4,313.00 Office Automation 280,381.00 280,381.00 $317,895.00 ($100,000.00) -45.89% Increased usage. Budget amendment recommended. 52,000.00 0.00% 0.00% 200,000.00 0.00% 0.00% 175,798.00 0.00% 10,000.00 0.00% 1,286,585.47 0.00% 107,705.00 0.00% 53,000.00 0.00% 441,168.00 0.00% 846,560.00 0.00% 0.00% 880,000.00 0.00% 24,313.00 (20,000.00) -463.71% Increased demand due to existence of older furniture. A budget amendment is 280,381.00 0.00% recommended. $5,127,329.00 $4,555,405.47 $4,675,405.47 ($120,000.00) -2.63% Transfers to Other Funds General Activities $0.00 $1,297,665.00 $1,297,665.00 0.00% Information Technology Fund 56,531.00 215,257.00 215,257.00 0.00% Sheriff Aviation Fund 1,693,720.00 1,693,720.00 1,693,720.00 0.00% Environmental Infrastructure 5,000,000.00 5,000,000.00 5,000,000.00 0.00% Building Fund 5,750,000.00 5,750,000.00 5,750,000.00 0.00% Building Authority 1,723,650.00 1,723,650.00 1,723,650.00 0.00% CLEMIS . 1,408,000.00 1,408,000.00 0.00% Oak, Enhancement-Community Partnership 55,685.00 55,685.00 55,685.00 0.00% $14,279,586.00 $17,143,977.00 $17,143,977.00 $0.00 0.00% TOTAL NON-DEPT. APPROPRIATIONS $40,704,151.00 $41,768,244.45 $41,905,844.45 ($137,600.00) -0.33% TRANSFER TO GENERAL PURPOSE FUNDS Friend of the Court $11,093,343.00 $11,328,517.86 $11,328,517.86 0.00% Health Fund 23,597,421.00 23,730,862.45 23,730,862.45 0.00% Juvenile Maintenance Fund 12,200,789.00 12,257,000.73 12,257,000.73 0.00% Social Welfare Fund 45,000.00 45,000.00 45,000.00 0.00% CRIMP Fund - - - 0.00% $46,936,553.00 $47,361,381.04 $47,361,381.04 $0.00 0.00% 90.xls 2 05/23/2001 FY 2001 BUDGET AMENDMENTS FY 2001 BUDGET AT ADOPTED 324,166,458.00 BUDGET AMENDMENTS M.R. #00257 - 10/19/2000 Prosecuting Attorney - Forfeited Funds for Substance Abuse M.R. #00258 - 10/19/2000 Prosecuting Attorney - Forfeited Funds for Drug Awareness Calendars KR. #00271 - 10/19/2000 Facilities Management - Purchase of Clinton Valley Property M.R. #00273 - 10/19/2000 Circuit Court - Use of Mediation Funds M.R. #00265 - 11/02/2000 Clerk/Register - Receipting, Indexing, and Imaging System M.R. #00274 -1110212000 Sheriff Department - Use of Forfeited Funds M.R. #00290 - 11/02/2000 LLEBG Grant Match M.R. #00292 - 11/30/2000 Sheriff Department - Rochester Hills Contract Amendment M.R. #00298 - 11/30/2000 52nd District Court - Alternative Dispute Resolution Program M.R. #00299 - 11/30/2000 Information Technology - Unfunded Mandates M.R. #00306 - 12/14/2000 Community Corrections - GPS Stepdown Work Program M.R. #00307 - 12/14/2000 Sheriff Department - Continuation of Oakland County Narcotics Enforce. Team KR. #00308 - 12/14/2000 Sheriff Department - Rochester Hills Contract Amendment M.R. #00309 - 1211412000 Sheriff Department - Oxford Township Contract Amendment 54,000.00 33,000.00 880,000.00 20,000.00 675,000.00 25,000.00 21,387.00 69,739.00 25,000.00 153,183.00 421,183.00 22,207.00 58,747.00 61,616.00 M.R. #00310 - 12114/2000 Sheriff Department - Springfield Township Contract Amendment M.R. #00314 - 12/14/2000 Drain Commissioner - Automation of Drain Records M.R. #00320 - 12/14/2000 Management & Budget / Equalization - Digital Photography Project M.R. #00321 - 12/14/2000 Management & Budget - Utility Multiplier Lawsuit M.R. #00333 - 12/1412000 Management & Budget - FY 2000 Year End Report M.R. #00337 - 12/14/2000 Sheriff Department - Oakland Township Contract Amendment M.R. #01018 - 02/01/2001 Management & Budget - Circuit Court and Health Carry Forward M.R. #01024 -02/01/2001 Sheriff Department - NET Agreement and Additional Vehicles M.R. #01029 - 02/22/2001 Sheriff Department - Use of Automobile Theft Prevention Funds M.R. #01031 - 02/22/2001 Management and Budget - CLEMIS Match M.R. #01044 - 03/08/2001 Emergency Management - Oakland Township Tornado Sirens M.R. #01047 - 03/08/2001 Circuit Court / Management & Budget - New Positions M.R. #01056 - 03/08/2001 Management and Budget - Carry Forward for Treasurer M.R. #01057 - 03/08/2001 Management and Budget - FY 2001 First Quarter Forecast M.R. #01068 -03108/2001 Risk Management - Strategic Planning of Senior Health Care Program M.R. #01071 - 03/22/2001 Central Services - Three Vans for Community Corrections 62,364.00 1,000,000.00 145,608.00 100,000.00 1,441,960.35 62,364.00 281,207.00 376,000.00 17,585.00 1,000,000.00 47,250 68,391 40,000.00 1,618,456 110,000 3,780 M.R. #01078 - 03/22/2001 Sheriff Department - Use of Forfeited Funds M.R. #01079 - 03/22/2001 Sheriff Department - Fire Dispatch for Commerce Township 203,000 21,000 M.R. #01086 - 03/22/2001 9,900 Management & Budget / Purchasing - On Line Service for Vendors AMENDED BUDGET AS OF 03/31/2001 1.....___I33,295,385a FY 2001 SECOND QUARTER FORECAST REPORT INTERNAL SERVICE FUNDS DEPARTMENT OF CLERK/REGISTER OF DEEDS ADOPTED AMENDED FY 2001 VARIANCE BUDGET BUDGET ACTUAL FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES 'MICROGRAPHICS FUND #654 REVENUES Outside $170,468 $170,468 $170,468 $0 Inside 548,231 548,231 600,231 52,000 - Favorable due to requests from Record Retention and County Clerk Total Revenues $718,699 $718,699 $770,699 $52,000 OPERATING EXPENSES $725,699 $725,699 $675,699 $50,000 - Favorable due to position vacancies lasting several months NET NON-OPERATING REV $7,000 $7,000 $45,000 $38,000 - Favorable due to a more aggressive investment strategy REVENUE OVER (UNDER) EXPENDITURES $0 $0 $140,000 $140,000 MICROGRF.xls 05/06/2001 OAKLAND COUNTY, MICHIGAN DRAIN COMMISSIONER FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED FY 2001 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) COMMENTS Drain Equipment Fund - (#639) OPERATING REVENUES: Outside 2,104,958.00 2,104,958.00 2,104,958.00 0.00 Inside 89,600.00 89,600.00 89,600.00 0.00 Operating Transfer In 1,000,000.00 1,000,000.00 0.00 Total 2,194,558.00 3,194,558 00 3,194,558.00 0.00 OPERATING EXPENSES 2,165,842.00 2,165,842.00 3,165,842.00 (1,000,000.00) Expenditures will be amended at the third quarter forecast OPERATING TRANSFERS (OUT) 28,716.00 28,716.00 28,716.00 0.00 OPERATING INCOME (LOSS) 0.00 1,000,000.00 0.00 (1,000,000.00) DRAN2001 xls 05/23/2001 $3,646,091.00 $3,646,091.00 $3,800,991.00 $154,900.00 Fay. Investment Income ($170,000.00) (Unfav) due to misappropriation of budget in salaries and fringes. A budget amendment is recommended. $2,749,233.00 $2,749,233.00 $777,033.00 $1,972,200.00 Fay. claims costs indicates potential favorability thru March 2001, pending fiscal analysis of claims reserve $3,646,091.00 $1,843,891.00 $1,802,200.00 $0.00 $1,957,100.00 $1,957,100.00 $2,749,233.00 $3,646,091.00 $0.00 $2,749,233.00 $777,033.00 $896,858.00 $896,858.00 $1,066,858.00 RISK MANAGEMENT INTERNAL SERVICE FUND FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED BUDGET BUDGET FY 2001 VARIANCE FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND (#677) REVENUE OPERATING EXPENSE CLAIMS PAID TOTAL EXPENSES NET REVENUES OVER/(UNDER) EXPENSES INSURE.xls 05/23/2001 FRINGE BENEFIT FUND INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST 'FRINGE BENEFIT FUND (#678) I REVENUE ADOPTED AMENDED FY 2001 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES RETIREES HOSPITALIZATION RETIREMENT ADMINISTRATION TUITION REIMBURSEMENT EMPL. DEFERRED COMP. ADMIN. EMPL. DEFERRED COMP. COUNTY EMPLOYEE IN-SERVICE TRAINING DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION ADMIN. GROUP LIFE HOSPITALIZATION SOCIAL SECURITY DENTAL INSURANCE OPTICAL INSURANCE DISABILITY INSURANCE SHORT-TERM DISABILITY FORFEITURES WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION FLEXIBLE BENEFIT DEDUCTIONS INVESTMENT INCOME OPERATING TRANSFER IN TOTAL REVENUE EXPENSE RETIREES HOSPITALIZATION RETIREMENT ADMINISTRATION SICK/ANNUAL LEAVE CASH-IN TUITION REIMBURSEMENT EMPL. DEFERRED COMP. ADMIN. EMPL. DEFERRED COMP. COUNTY EMPLOYEE IN-SERVICE TRAINING IN-SERVICE TRAINING - INFO TECH DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION ADMIN. GROUP LIFE HOSPITALIZATION SOCIAL SECURITY DENTAL INSURANCE OPTICAL INSURANCE DISABILITY INSURANCE FLEXIBLE BENEFIT PAYMENTS PROFESSIONAL SERVICES WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION ACCOUNTING SERVICES TOTAL EXPENSE $12,885,500 $12,885,500 $12,990,400 3,586,600 3,588,600 3,633,800 333,000 333,000 338,200 41,800 41,800 43,600 690,000 690,000 0 1,095,100 1,095,100 1,107,600 8,950,200 8,950,200 9,008,500 32,800 32,800 32,600 882,000 882,000 831,800 22,031,400 22,031,400 21,970,000 14,070,400 14,070,400 13,961,400 2,758,200 2,758,200 2,666,600 346,800 346,800 337,200 632,600 632,600 623,800 1,292,300 1,292,300 1,131,000 212,500 212,500 465,000 2,290,800 2,290,800 2,346,400 225,000 225,000 229,800 0 0 330,500 2,050,000 2,050,000 2,000,000 0 45,000 45,000 $74,407,000 $74,452,000 $74,093,200 $12,885,500 $12,885,500 $16,182,500 3,819,586 3,819,586 3,552,286 1,250,000 1,250,000 1,250,000 333,000 333,000 290,900 41,800 41,800 41,800 690,000 690,000 840,000 790,525 852,427 918,427 550,000 550,000 485,100 8,950,200 8,950,200 9,143,900 32,800 32,800 31,800 882,000 882,000 809,500 22,031,400 22,031,400 21,970,000 14,162,500 14,162,500 13,972,500 2,758,200 2,758,200 2,850,200 346,800 346,800 364,000 1,924,900 1,924,900 1,748,100 0 0 344,000 134,100 134,100 112,500 2,290,800 2,290,800 1,990,400 225,000 225,000 156,200 75,400 75,400 81,300 $74,174,511 $74,236,413 $77,115,413 $104,900 47,200 5,200 1,800 (690,000) Deferred Compensation Benefit Match costs will be absorbed by the Fringe Benefit Fund as 12,500 approved by the Budget. 58,300 (200) (50,200) (61,400) (109,000) (91,600) (9,600) (8,800) (161,300) -Departmerts are charged for actual short-term disability costs. 252,500 -Return of DC Plan contributions from ICMA for employees who separated from County service prior 55,600 to vesting and forfeiture of unused deposits for health & dependent care reimbursement accounts. 4,800 330,500 -Payments received from employees for enhanced coverage in the Flexible Benefits Program. (50,000) 0 ($358,800) ($3,297,000) -Budget was established prior to receipt of latest actuarial calculation. Fringe Benefit Fund will absorb increase. 267,300 0 42,100 0 (150,000) (66,000) 84,900 (193,700) 1,000 72,500 61,400 '190,000 (92,000) (17,200) 176,800 (344,000) -Payments to employees for reduced coverage in the Flexible Benefits Program. 21,600 300,400 -Adjustment of Workers Compensation claim-year reserves will be determined by fiscal 68,800 year-end analysis of claims and reserve requirements. (5,900) ($2,879,000) REVENUE OVER/(UNDER) EXPENSE $232,489 $215,587 ($3,022,213) ($3,237,800) FRINGES.xls 05/09/2001 DEPARTMENT OF MANAGEMENT AND BUDGET INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED P1 2001 2001 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES OFFICE EQUIPMENT FUND (664) OPERATING REVENUE-Inside OPERATING EXPENSE OPERATING INCOME NET NON-OPERATING REV (EXP) $500,355.00 $570,571.00 $506,000.00 ($64,600.00) $575,855.00 $611,003.00 $569,000.00 $42,000.00 ($75,500.00) ($40,432.00) ($63,000.00) ($22,600.00) $75,500.00 $75,500.00 $95,000.00 $19,500.00 Unfavorable due to CMH equipment and other various equipment being turned in and not replaced. Favorable due to not cost effective maintenance contracts being cancelled and less repairs needed. Favorable due to more aggressive investing INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN OPERATING TRANSFERS OUT $0.00 $35,068.00 $31,968.00 ($3,100.00) $0.00 $158,165.00 $158,165.00 $0.00 $0.00 $0.00 $0.00 $0.00 NET REVENUES OVER/(UNDER) $0.00 $193,233.00 $190,133.00 ($3,100.00) EXPENSES EQUP1Q01.xls 05/09/2001 [MOTOR POOL FUND 661 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN NET INCOME (LOSS) [MATERIALS MANAGEMENT FUND 633 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME(LOSS) NON-OPERATING REVENUE(EXPENSE) NET INCOME (LOSS) DEPARTMENT OF CENTRAL SERVICES INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED FY 2001 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES $5,009,760.00 $5,164,431.00 $4,895,631.00 ($268,800.00) Leased Vehicle rates are not sufficient to meet the increased revenue projections. Management looking into a possible rate adjustment midyear. 5,350,731.00 5,760,955.00 6,054,555.00 (293,600.00) Unfavorable due to increased cost of gasoline and rising insurance premiums. ($340,971.00) ($596,524.00) ($1,158,924.00) ($562,400.00) 565,000.00 565,000.00 625,000.00 60,000.00 Favorable due to increased gain of sale of vehicles. 224,029.00 (31,524.00) (533,924.00) (502,400.00) 100,000.00 444,546.00 444,546.00 0.00 324,029.00 413,022.00 (89,378.00) (502,400.00) $3,310,175.00 $3,310,175.00 $1,641,575.00 ($1,668,600.00) Unfavorable due to Sheriff decrease in demand for groceries & meat revenue, which is now being provided by an outside vendor. 3,316,675.00 3,316,675.00 1,897,375.00 1,419,300.00 Favorable due to lower groceries & meat purchases. (6,500.00) (6,500.00) (255,800.00) (249,300.00) 6,500.00 6,500.00 6,500.00 0.00 $0.00 $0.00 ($249,300.00). ($249,300.00), MAILING, CONVENIENCE COPIER AND PRINTING FUND 667 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME(LOSS) NON-OPERATING REVENUE(EXPENSE) NET INCOME (LOSS) $2,470,480.00 $2,470,480.00 $2,550,580.00 $80,100.00 2,545,627.00 2,545,627.00 2,512,927.00 32,700.00 (75,147.00) (75,147.00) 37,653.00 112,800.00 0.00 0.00 0.00 0.00 ($75,147.00) ($75,147.00) $37,653.00 $112,800.00 ..,,,=,.......,,.... .....,=.....:... ,.. Favorable due to increased revenue for Conv.Copier charging monthly minimums on machines making less than required copies. This is also helping to offset Printing Rev. unfavorability of (135,000), the decrease in demand is due partly to Internet availability, & fewer brochures are being requested. Favorable due to Salaries and Fringes = 2 positions currently vacant. MATMGT.xls 05/12/2001 ADOPTED BUDGET AMENDED BUDGET FY 2001 FORECAST VARIANCE FAV/(UNFAV) EXPLANATION OF SIGNIFICANT VARIANCES $1,643,410.00 21,770,479.00 $23,413,889.00 $21,238,616.00 $2,175,273.00 $200,000.00 $54,000.00 ($2,410,000.00) $19,273.00 $23,413,889.00 $21,238,616.00 $2,175,273.00 $200,000.00 $54,000.00 ($2,410,000.00) $1,643,410.00 21,770,479.00 $19,273.00 $1,437,510.00 $1,559,673.00 130,000.00 $54,000.00 ($2,410,000.00) ($205,900.00) - Unfav. Natural Gas and Fuel Oil costs (471,500) caused by higher energy rates: Indirect Costs (294,600) based on charges for the fourth quarter; and unfav. Telephone Comm; partially offset by fav. Overtime 75,000, Summer Help 40,000, Electrical Service 40,000, Sublet Repairs 100,000, Water & Sewage Charges 50,000, and Depreciation 41,400 based ($615,600.00) on current expenditure levels. ($70,000.00) - Investment Income variance due to lower than anticipated investment base and interest rates. $0.00 $0.00 21,821,479.00 51,000.00 $23,258,989.00 ($154,900.00) $21,699,316.00 ($460,700.00) - Variance based on lease agreement with Oakland County Road Commission for space leased in Information Technology facility (108,600) and reduced charges to Oakland Schools for custodial services. - Fay. Maintenance Department Charges to departments based on anticipated requests. ($666,327.00) ($685,600.00) - Facilities Maintenance & Operations Fund balance is sufficient to cover this forecasted variance OPERATING REVENUES - OUTSIDE OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $116,772.00 $116,772.00 $0.00 $116,772.00 $116,772.00 $0.00 $116,772.00 $116,772.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 NET REVENUES OVER(UNDER) EXPENSES $0.00 $0.00 DEPARTMENT OF FACILITIES MANAGEMENT INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST !FACILITIES MAINTENANCE & OPERATIONS (#631) OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE OPERATING TRANSFERS IN OPERATING TRANSFERS (OUT) NET REVENUES OVER(UNDER) EXPENSES PONTIAC MARKET (#261) OPERATING TRANSFERS IN OPERATING TRANSFERS (OUT) FM0FORE.xls 05/14/2001 Information Technology - Operations (636) Outside Inside Prior Years Balance OPERATING TRANSFERS IN Total OPERATING EXPENSES VARIANCE FAV/(UNFAV) Total Fund: COMMENTS ($76,500.00) - Unfav outside rev, due largely to shift in billing to Equalization, now inside revenue. 599,500.00 Fav. IT Develop't rev, of due to conservative est. of billable rev., & shift from outside to inside also, increase in billing rates for equip. & labor. 21,700.00 - Var. reflects balancing of revenues to expenditures offset to Prior Yrs. Balance. 0.00 - OPERATING TRANSFERS (OUT) 56,531.00 0.00 0.00 0.00 - $1,305,100.00 $1,305,100.00 $1,236,600.00 3,000,658.00 3,000,658.00 3,993,158.00 0.00 0.00 0.00 4,305,758.00 4,305,758.00 5,229,758.00 3,786,851.00 3,786,851.00 4,659,351.00 535,000.00 535,000.00 535,000.00 ($16,093.00) ($16,093.00) $35,407.00 $51,500.00 OPERATING REVENUES: Outside Inside OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) Total Fund: ($68,500.00) - Unfav ($119,300) delay in negot. of rate incr. w MCI, offset by invest income $49,000 due to delay in PBX incr funds avail, to invest & small fav of $558 Extnl. Phone & sale scrap $1,200. 992,500.00 - Interl phone svc. fav. $1,729,225 due to delay of PBX & assoc. incr billing., offset by Prior 0.00 yrs bal of ($736,708) no longer needed to offset to fund balance. 924,000.00 (872,500.00) - Unfav. contractual svcs. ($1,210,235) largely due to higher phone line charges caused by PBX delay. Offset by Sal & frg fav. $67,948 due to turnover & vacancies; commod. ($105,788) due to PBX cutover (cabling & other) also, internal service fav. $1,915 lease veh, & IT cost 0.00 also, writeoff of depreication lower that expected $373,705 PBX delay not being depreciated. DEPARTMENT OF INFORMATION TECHNOLOGY INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED FY 2001 BUDGET BUDGET FORECAST OPERATING REVENUES: $2,077,920.00 $2,077,920.00 $2,001,420.00 20,082,169.00 20,082,169.00 20,681,669.00 9,826,531.00 9,826,531.00 9,848,231.00 56,531.00 346,947.00 346,947.00 33,666,842.00 32,154,995.00 32,878,224.00 (723,200.00) - Unfav. largely due to contracted svcs ($866,442) reflects incr. proj. activity, & internal svcs. of ($166,534) due largely to delay in PBX implementation. Partially offset by sal & frgs. Of $284,006 due to vacancies, & fav. Commodities of $25,741 reflect low use of part & access. 32,043,151.00 32,333,567.00 32,878,267.00 544,700.00 OPERATING INCOME (LOSS) ($1,680,222.00) $178,572.00 $0.00 ($178,500.00) Information Technology - Telephone Communications (675) Information Technology - CLEMIS (636) OPERATING REVENUES: Outside $945,200.00 $1,016,150.00 $1,071,950.00 Total Fund: Unfav due to In-car term. of ($110,000) delay MDC equip not aped, ($17,535) Outside Op $55,800.00 - offset fav. Outside agencies $3,424, invest, income fav. $205,000 held back Ameritech funds also, unfav. Supplies of ($1,500) & Maint. Contracts ($23,650) Livescan maint. not started. IT1QTR01.xls 1 05/23/2001 $471,400.00 7,146,219.00 7,617,619.00 3,611,408.00 4,006,211.00 40,000.00 4,046,211.00 Inside OPERATING TRANSFERS IN Total OPERATING EXPENSES 134,550.00 134,550.00 0.00 76,000.00 179,333.00 255,333.00 179,333.00 186,933.00 125,850.00 76,000.00 238,833.00 238,833.00 DEPARTMENT OF INFORMATION TECHNOLOGY INTERNAL SERVICE FUNDS FY 2001 SECOND QUARTER FORECAST REPORT ADOPTED AMENDED FY 2001 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) COMMENTS Inside 1,584,244.00 177,477.00 109,977.00 (67,500.00) - In-Car Term. Bud. unfav ($67,477) due to delay in installation and billing of patrol car devices. OPERATING TRANSFERS IN 0.00 1,412,900.00 1,412,900.00 0.00 - Total 2,529,444.00 2,606,527.00 2,594,827.00 (11,700.00) OPERATING EXPENSES 10,036,391.00 10,193,074.00 5,892,474.00 4,300,600.00 - Unfav. due to proj'd OT, On Call & Sal. ($54,498), & Commod ($3,000), offset by Depreciation $4,269,757, Internal Svc $6,080, & $82,240 in Contracted Svcs delay in contracts issued. OPERATING INCOME (LOSS) ($7,506,947.00) ($7,586,547.00) ($3,297,647.00) $4,288,900.00 Information Technology - Radio Communications (660) OPERATING REVENUES - OUTSIDE OPERATING REVENUES - INSIDE TOTAL OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN $471,400.00 557,100.00 85,700.00 Fav. due largely to higher than expected Outside Agencies $90,600 & Service Fees $20,000 offset by lower Antenna Site Mgt. ($25,000), Sale of Scrap $100. 7,154,969.00 7,582,025.00 427,000.00 Fav. due to E-911 surcharge rev., revised leased equip rates. & service fees, parts & access. 7,626,369.00 8,139,125.00 512,700.00 3,624,238.00 3,492,757.00 131,500.00 Fav. largely due to position vacancies, & lower parts & accessories, contracted svcs. 4,002,131.00 4,646,368.00 644,200.00 40,000.00 112,000.00 72,000.00 Fav. due to investment of E-911Surcharge revenue. 4,042,131.00 4,758,368.00 716,200.00 0.00 56,670.00 56,670.00 0.00 NET INCOME (LOSS) $4,046,211 00 $4,098,801.00 $4,815,038.00 $716,200.00 Fire Records Management - Fund 531 OPERATING REVENUES: Total Fund: $44,783.00 $44,783.00 $36,983.00 ($7,800.00) - Unfav.($29,783) due to projected rates for fire agencies, offset by fav. invest, income of $22,000 Outside (8,700.00) - Unfav. prior years balance due to oper. transfer in, which reduced negative effect on fund bal. 0.00 (16,500.00) (51,900.00) - Unfav. ($52,420) largely due to on-call pay, underbudgeted sal & frg., unfav. expendable equip. of ($15,000), higher equip write-offs ($12,400), internal svc. ($32); offset by fav cont. svc. $27.973. OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) 0.00 0.00 $0.00 $68,400.00 0.00 0.00 $0.00 ($68,400.00) IT1QTR01.xls 2 05/23/2001 Interoffice MEMORANDUM to: Tim Soave, Fiscal Services cc: Claudia Martell°, Reimbursement from: Nancy L Wagner, Reimbursement rU2X)1/4) re: Inmate Waived Report date: April 30, 2001 Submitted for your review is the Inmate Report for 2001 for the Months of January, February, and March. Number of Accounts Amount Waived January 01 028390 CZ 118 $ 269,616.60 February 01 029139 CZ 92 $ 178,765.74 March 01 029912 CZ 105 $ 212,572.93 TOTAL 315 $ 660,955.27 From the desk of .... Nancy R. Wagner Reimbursement 1200 N Telegraph Road Pontiac, Michigan 48343 te1:248-858-1459 fax:248-975-4288 Resolution #01160 June 14, 2001 Moved by Dingeldey supported by Obrecht the resolution be adopted. AYES: Buckley, Causey-Mitchell, Crawford, Dingeldey, Galloway, Garfield, Gregory, Law, Melton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever, Suarez, Taub, Webster, Amos, Appel, Brian. (21) NAYS: None. (0) A sufficient majority having voted therefor, the resolution was adopted. .72:F?0/ 040 AMA County btecutive Date STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 14, 2001 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 14'hA,day o7June, 2001. G. William Caddell, County Clerk