ADOPTED-APRIL 29, 2003

Agenda Item No. 10

Introduced by the Finance Committee of the:



INGHAM COUNTY BOARD OF COMMISSIONERS



RESOLUTION AUTHORIZING ADJUSTMENTS TO THE 2003 INGHAM COUNTY BUDGET



RESOLUTION #03-111



WHEREAS, the Board of Commissioners adopted the 2003 Budget on October 22, 2002 and has authorized certain amendments since that time, and it is now necessary to make some adjustments as a result of updated revenue and expenditure projections, fund transfers, reappropriations, accounting and contractual changes, errors and omissions, and additional appropriation needs; and



WHEREAS, the Liaison Committees and the Finance Committee have reviewed the proposed budget adjustments prepared by the Controller's staff and have made adjustments where necessary; and



WHEREAS, Public Act 621 of 1978 requires that local units of government maintain a balanced budget and periodically adjust the budget to reflect revised revenue and expenditure levels.



THEREFORE BE IT RESOLVED, that the Ingham County Board of Commissioners hereby directs the Controller to make the necessary transfers to adjust revenues and expenditures in the following funds, according to the attached schedules:



2003 BUDGET PROPOSED PROPOSED

FUND DESCRIPTION 03/25/03 CHANGES BUDGET



101* General Fund $66,692,963 $270,433 $66,963,396

208 Parks 1,883,731 43,500 1,927,231

221 Health 29,179,996 6,135 29,186,131

230 Hotel/Motel 1,900,000 16,740 1,916,740

245 Public Improvement 145,897 483,765 629,662

265 Drug Law Enforcement 5,000 36,017 41,017

285 Justice Training Grant 0 6,327 6,327

292 Family Division Child Care 6,624,659 40,160 6,664,819

508 Parks Enterprise 239,752 13,892 253,644

561 Fair 1,021,619 23,615 1,045,234

636 MIS Fund 2,621,907 48,679 2,670,586

645 Intergovernmental Services 696,295 1,186 697,481

664 Mach. & Equip. Revolving 361,051 114,261 475,312

675 Telephone 928,289 20,853 949,142



* Does not include funds associated with the sale of Ingham Medical Center.



FINANCE: Yeas: Grebner, Swope, Dedden, Thomas, Minter

Nays: None Absent: Hertel Approved 4/23/03



GENERAL FUND REVENUES



2003 Budget - 3/25/03 Proposed Changes 2003 Proposed Budget
Tax Revenues
County Property Tax 37,492,141 37,492,141
Property Tax Adjustments (150,000) (150,000)
Delinquent Real Property Tax 12,000 12,000
Unpaid Personally Property Tax 25,000 25,000
PILT/IFT/CFT 469,000 469,000
Trailer Fee Tax 20,000 20,000
Intergovernmental Transfers
Single Business Tax 895,139 895,139
State Revenue Sharing 5,182,086 5,182,086
Convention/Tourism Tax - Liquor 1,384,489 1,384,489
Health and Safety Fund 230,000 230,000
Use of Fund Balance 129,994 115,790 245,784
Department Generated Revenue
Animal Control 346,315 346,315
Circuit Court - Family Division 441,824 441,824
Circuit Court - Friend of the Court 976,183 976,183
Circuit Crt - General Trial 1,488,328 1,488,328
Cooperative Extension 160,497 49,698 210,195
County Clerk 319,888 319,888
District Court 2,039,116 2,039,116
Drain Commissioner/Drain Tax 335,485 335,485
Economic Development 74,669 81,805 156,474
Elections 40,000 40,000
Emergency Operations 49,385 49,385
Equalization /Tax Services 30,800 30,800
Probate Court 252,932 252,932
Prosecuting Attorney 696,560 696,560
Purchasing 46,858 46,858
Register of Deeds 2,286,607 2,286,607
Remonumentation Grant 80,338 80,338
Sheriff 5,292,630 23,140 5,315,770
Treasurer 5,868,725 5,868,725
Tri-County Regional Planning 36,186 36,186
Veteran Affairs 139,788 139,788
Total General Fund Revenues 66,692,963 270,433 66,963,396


GENERAL FUND EXPENDITURES



2003 Budget - 3/25/03 Proposed Changes 2003 Proposed Budget
Board of Commissioners 472,353 472,353
Circuit Court - General Trial 5,860,369 21,960 5,882,329
District Court 1,617,304 1,617,304
Circuit Court - Friend of the Court 1,276,735 1,276,735
Jury Board 1,208 1,208
Probate Court 1,189,487 1,189,487
Circuit Court - Family Division 6,452,144 6,452,144
Jury Selection 60,117 60,117
Elections 174,252 174,252
Financial Services 596,180 596,180
County Attorney 373,623 373,623
County Clerk 663,366 663,366
Controller 763,915 763,915
Equalization/Tax Services 583,192 583,192
Human Resources 671,063 671,063
Prosecuting Attorney 5,048,016 5,048,016
Purchasing 231,448 231,448
Facilities 1,398,908 1,398,908
Register of Deeds 656,170 656,170
Remonumentation Grant 80,338 80,338
Treasurer 572,097 572,097
Drain Commissioner 786,926 786,926
Economic Development 152,871 101,914 254,785
Community Agencies 199,371 199,371
Women's Commission 2,000 3,940 5,940
Environmental Affairs Comm 500 500
FOC Advisory Committee 2,000 2,000
Historical Commission 500 500
Tri-County Regional Planning 60,310 60,310
Jail Maintenance 205,120 205,120
Sheriff 18,566,901 24,679 18,591,580
Community Corrections 90,231 90,231
Animal Control 1,118,860 1,118,860
Emergency Operations 158,312 42,427 200,739
Board of Public Works 960 960
Drain Tax at Large 117,000 117,000
Health Department 7,690,809 7,690,809
Medical Examiner 231,531 231,531
Substance Abuse 696,379 696,379
Community Mental Health 1,755,402 1,755,402
Family Independence Agency 915,288 915,288
Tri-County Aging 66,890 66,890
Veterans Affairs 319,055 319,055
Cooperative Extension 774,858 61,321 836,179
Parks and Recreation 1,706,520 1,706,520
Contingency Reserves 557,244 (21,960) 535,284
Capital Area Rail Council 2,350 2,350
Capital Improvements 1,772,490 36,152 1,808,642
Total General Fund Expenditures 66,692,963 270,433 66,963,396




General Fund Revenues



Economic Development Increase revenue budget $81,805 for Michigan Regional Telecommunications Planning Program grant authorized by R02-42.



Cooperative Extension Carry over $11,734 in revenue from Lansing School District as approved in R02-171. Carry over $30,000 in revenue from City of Lansing for Citywide Network Center support per R02-258. Increase transfer from Health Fund $7,964 for Community Voices Grant.



Sheriff Increase insurance proceeds revenue $23,140 from totaled Sheriff vehicles. Proceeds will be used toward the purchase of new vehicles.



Use of Fund Balance Increase use of fund balance $115,790 for various reappropriations.



General Fund Expenditures



Circuit Court Increase budget $21,960 for service agreements for technology equipment at Veterans Memorial Courthouse. These costs were not included in the budget.



Cooperative Extension Reappropriate $11,734 in temporary salaries and supplies from Lansing School District as approved by R02-171. Reappropriate $2,309 in temporary salaries and supplies for Ingham County Youth Commission as approved by R01-283. Reappropriate $35,314 for Citywide Network Center support per R02-258. Reappropriate $1,416 in supplies and travel from Robert Wood Johnson Foundation grant. Reappropriate $2,584 in supplies for Capital Regional Community Fund anti-smoking grant. Reappropriate $7,964 in temporary salaries, travel and special projects for Community Voices Grant. Reduce various expenses totaling $10,000 in order to restore contractual service budget for horticulturist contract. The 2003 budget recommended that this $10,000 be paid for by the development of a fee structure for this service. As an alterative to this, Cooperative Extension has agreed to reduce its expenses by this amount.



Economic Development Reappropriate $101,914 in unspent funds from Michigan Regional Telecommunications Planning Program grant authorized by R02-42.



Em Ops/HAZMAT Reappropriate $42,427 in unspent HAZMAT contributions from previous years.

Sheriff Reappropriate unspent balance of $1,539 from the Dart Foundation grant as approved by R02-145. Increase vehicle budget $23,140 to replace totaled Sheriff vehicles.



Women's Commission Reappropriate unspent 2002 balance of $3,940.



Contingency Decrease contingency fund $21,960 for unbudgeted Veterans Memorial Courthouse technology service agreements.



Capital Improvements Reappropriate $36,152 for video arraignment project per 2000 CIP budget.



Non-General Fund Adjustments



Parks Increase use of fund balance and decrease parking

F208 revenue, due to revenue overestimate ($30,000). Increase use of fund balance to cover additional cost of office renovation ($13,500).



Health Increase budget to remodel area servicing

F221 Bioterrorism/Public Health Preparedness staff. Project cost totals $19,003. Funding for the project will come from $7,200 in excess funds from remodeling the Children's Special Health Care Services area per R03-17, $5,668 in excess funds from remodeling the administrative unit per the 2003 CIP budget, and a $6,135 increase in state grant revenue to reimburse the County for expenditures related to smallpox vaccination and preparedness activities. The net increase to the Health Fund is $6,135.



Hotel/Motel Reappropriate unspent hotel/motel funds from 2002 CIP

F230 Budget for building repair and maintenance ($11,908) and surfacing and landscaping ($4,832) at Fair.

Public Improvement Reappropriate funds for the following capital improvement

F245 projects: fire alarm system at Jail ($30,000) per 1997 CIP Budget, county-wide floor replacement ($22,539), Jail heater covers ($15,000) and county-wide parking lot repair ($52,889) per 1999 CIP budget, video arraignment project ($50,930) and remodel Youth Center control room ($7,120) per 2000 CIP budget, repair monument at Mason Courthouse ($7,000), replace broken sidewalk ($16,646), Circuit Court file storage project ($12,553), and new stack for Hilliard Building ($35,000) per 2001 CIP budget, replace Mason Courthouse fire alarm system ($30,000), electrical upgrade for picnic shelters ($10,900), token gate at GPB visitor lot ($20,000), stainless steel doors at Jail ($5,000), air conditioning for Jail Chapel/meeting room ($10,000), seal all jail shower floors ($50,000), Youth Center lock and control system ($90,000), carpeting for Willow Plaza ($1,450), Jail ceiling tile replacement ($3,510), replace heating units at Jail ($9,750), and Parks ADA modifications ($3,478) per 2002 CIP budget.



Drug Law Enforcement Reappropriate unspent Sheriff drug forfeiture funds

F265 ($36,017).



Justice Training Grant Reappropriate previous years' unspent Act 302 training

F285 funds. ($6,327)



Family Court Child Care Reappropriate unspent funds from Thoman Foundation

F292 Grant. ($40,160)

Parks Enterprise Reappropriate funds for Hawk Island rental equipment per

F508 2001 CIP budget. ($13,892)



Fair Reappropriate unspent hotel/motel funds from 2002 CIP

F561 Budget for building repair and maintenance ($11,908) and surfacing and landscaping ($4,832). Increase use of retained earnings to purchase new mower ($6,875).

MIS Increase use of fund balance to replace Kellogg Server

F636 ($7,679). Reappropriate funds for fire suppression system per 2002 CIP budget ($41,000).



Intergovernmental Services Increase revenues and expenses to replace PC and monitor

F645 in the Printshop. ($1,186).



Equipment Revolving Increase trade-in revenue and vehicle expense for Parks

F664 ($9,000). Reappropriate unspent Parks CIP funds from 2002 to purchase MIS equipment ($8,002). Increase CIP upgrade funds to purchase a replacement PC and monitor for the Sheriff ($1,126), to cover additional cost of budgeted Circuit Court printer ($100), to cover additional cost of budgeted replacement of 5 PCs and monitors for Animal Control ($593), and replacement of one PC and monitor for Economic Development ($1,186). Reappropriate funding for the following CIP projects: furniture for Treasurer ($2,171), Register of Deeds microfilm conversion ($62,683) and electroseal stamps for Circuit Court ($6,400) per 2002 CIP budget, and dog license software ($23,000) per R02-313.

Telephone Fund Increase telephone fund for Willow Clinic phone upgrade.

F675 ($20,853). This will be added to the upgrade of the overall telephone system as approved by R02-266.



2003 CONTINGENCY



Adopted Contingency Amount $553,414
R03-55: 4% Budget Reductions $3,830
Proposed 1st Quarter Adjustment ($21,960)
Current Contingency Amount $535,284