HomeMy WebLinkAboutResolutions - 1996.03.20 - 24810MISCELLANEOUS RESOLUTION #96063 March 21, 1996
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - 1995 YEAR-END REPORT AND BUDGET
AMENDMENTS
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all accounts have been posted and final adjustments made for
1995; and
WHEREAS Restatement #1 of the Governmental Accounting, Auditing and
Financial Reporting Standards requires that encumbrances and appropriations
carried-forward be treated as a designated fund balance at the year-end and
that such amounts be reappropriated in the subsequent year in order to be
available for expenditure; and
WHEREAS the results of operation after consideration of expenditures,
accruals, encumbrances, appropriations carried forward, transfers,
adjustments, and closing entries produces an excess available resources over
total charges as reflected in the attached schedule; and
WHEREAS pursuant to M.R. #95301, the Board authorized the use of
$2,475,201.00 to retire certain Delinquent Tax Revolving Fund loans; and
WHEREAS one-time year-end favorability allows the County to retire three
(3) additional Delinquent Tax Revolving Fund loans, specifically for the
purchase of Oakland Pointe ($3,851,535.34), Radio Communications refinancing
($1,000,743.00), and expansion of the 800 MHz system ($2,355,439.00); and
WHEREAS pursuant to M.R. #95300, the Board authorized the set aside of
$2,500,000 from fund balance to implement a new financial system; and
WHEREAS the implementation of a new financial system may require the
incorporation of a new personnel/payroll system, with an estimated cost of
$1,500,000 which would provide labor distribution resulting in improved cost
allocation for enhanced decision making and cost recovery; and
WHEREAS the County continues to pursue implementation of additional new
technologies to enhance the efficiency of not only Oakland County Government,
but municipal government, so as to improve services to citizens, specifically
a Geographic Information System (G.I.S.)and a Warrant Teleconferencing System;
and
WHEREAS the Board of Commissioners has engaged in a strategic planning
system, with the Administration, which requires funding to develop a strategic
planning model and implement innovative programs; and
WHEREAS as strategic planning efforts lead to possible reorganizations,
improved funding of the emergency salary program will allow elected officials
to maintain services in the midst of change.
NOW THEREFORE BE IT RESOLVED that the report of operations, for calendar
year 199, is accepted and the results of operations by line-item after
inclusion of expenditures, accruals, encumbrances, appropriations carried-
forward, transfers, adjustments, and closing entries is apprOved.
BE IT FURTHER RESOLVED that var .1ous line items in the 1996 Budget be
amended to include $325,082.55 for outstanding purchase orders and
$2,785,250.54 for appropriations carried forward as detailed in the attached
schedules.
F ANCE AND PERSONNEL COMMITTEE
Ii
PE IT FURTHER RESOLVED adjustments to the fund balance be approved as
follows:
Balance Before Adjustments $ 13,155,264.79
Add to General Fund Balatee!
Repayment of Advance for
Lake Charwood 20,305.69
Bunny Run Lake Level 20,000.00
Undesignated Future Operation Requirements* 2,538,396.00
Loss - Disallow. Ind. Cost to CETA 61,489.00
Special Contingency - Friend of the Court 351,682.15
Future Retirement Increase 750,000.00
Designated for Special Purpose 1,500.000.W
Adjusted Total Including Additions $ 18,697,137.63
Deduct from General Fund Balance:
Advance to Housing & Community Development $ ( 50,000.00)
:ncrease Petty Cash Fund 235.00)
Retire Delinquent Tax Revolving Loans** ( 2,475,201.00)
Financial System ( 2,500,000.00)
G.I.S. ( 750,000.00)
Strategic Planning ( 395,000.00)
Operational Improvements ( 1,253,151.31)
Oakland Pointe Debt ( 3,851,535.34)
Radio Debt ( 3,356,182.00)
Emergency Salaries ( 150,000.00)
Warrant Teleconferencing ( 500,000.00)
Personnel/Payroll System ( 1,500,000.00)
AdjuSted Total Including AdditiOns/Subtractions $ 1,915,832.78
Undesignated Fund Balance At Beginning of Year 0.00
Undesignated Fund Balance At the End of Year 1215.832.78
(* approved per M.R. #95042)
(** approved per M.R. #95301)
BE IT FURTHER RESOLVED that $1,000,000 from the undesignated fund
balance be transferred to the Millage Reduction and Stabilization Fund.
BE IT FURTHER RESOLVED the Board accepts the Accounting Report on bad
debt write offs and approved those in excess of $1,000.
Chairperson, on behalf of the Finance and Personnel Committee, I move
adoption of the foregoing resolution.
OAKLAND COUNTY, MICHIGAN
OUTSTANDING PURCHASE ORDERS
AND CARRY FORWARDS
1995
Outstanding
Purchase Carry-
Orders Forward
General Fund 4-1 01 00
Total
Executive Administration
111-01-00-3347 Expendable Equipment $6,776.75 $6,776.75
111-01-00-3752 Travel & Conference 4,000.00 4,000.00
111-01-00-9998 Capital Outlay 1,843.75 1,843.75
Total Executive Administration $8,620.50 $4,000.00 $12,620.50
Budget
122-01-00-3347 Expendable Equipment 1,548.90 1,548.90
Total Budget $1,548.90 $0.00 $1,548.90
Accounting
123-01-00-3128 Professional Services 69,720.00 69,720.00
123-01-00-3347 Expendable Equipment 2,819.91 2,819.91
Total Accounting $2,819.91 $69,720.00 $72,539.91
Purchasing
124-01-00-3204 Advertising 1,489.13 1,489.13
Total Purchasing $1,489.13 $0.00 $1,489.13
Record Retention & Mail Room
138-03-00-3347 Expendable Equipment 4,220.96 4,220.96
Total Record Retention $4,220.96 $0.00 $4,220.96
Human Resources
154-01-00-3423 Intern Program 14,137.00 14,137.00
154-01-00-3553 Recruitment Expense 1,426.10 1,426.10
Total Human Resources $1,426.10 $14,137.00 $15,563.10
Employee Relations
155-01-00-3334 Emp. In-Service Training 16,006.00 16,006.00
Total Employee Relations $0.00 $16,006.00 $16,006.00
Circuit Court Probation .
179-01-00-9998 Misc. Capital Outlay 2,248.20 2,248,20
Total Circuit Court Probation $2,248.20 $0.00 $2,248.20
Community and Economic Dev. - Administration
191-01-00-3752 Travel and Conference 4,000.00 4,000.00
Total Comm. & Econ. Dv, - Admin. $0.00 $4,000.00 $4,000.00
Development and Planning
192-01-00-3128 Professional Services 3,327.00 4,800.00 8,127.00
192-01-00-3204 Advertising 28,968.13 28,968.13
192-01-00-3752 Travel and Conference 160.00 160.00
192-01-00-4827 Drafting Supplies 970.56 970.56
Total Development and Planning $4,297.56 $33,928.13 $38,225.69
Equalization
194-01-00-1001 Salaries 5,000.00 5,000.00
194-01-00-3347 Expendable Equipment 1,576.80 1,576.80
194-01-00-3582 Printing 7,327.72 7,327.72
Total Equalization $8,904.52 $5,000.00 $13,904.52
Clerk/Register of Deeds - Administration
211-01-00-3347 Expendable Equipment 3,841.65 3,841.65
211-01-00-3586 Print, County Directory 12,538.00 12,538.00
211-01-00-9998 Misc. Capital Outlay 1,610_55 1,610.55
Total Clerk/Register - Admin. $17,990.20 $0.00 $17,990.20
County Clerk
212-01-00-4898 Office Supplies 1,200.00 1,200.00
Total County Clerk $1,200.00 $0.00 $1,200.00
Elections
213-01-00-4838 Elections Supplies 994.00 994.00
Total Elections $994.00 $0.00 $994.00
Treasurer
212-01-00-3347 Expendable Equipment 1,416.15 1,416.15
212-01-00-9998 Misc. Capital Outlay 1,300.50 1,300.50
Total Treasurer $2,716.65 $0.00 $2.716.65
• -Circuit Court - Administration
311-01-00-3380 Grant Match 58,466.46 58,466.46
311-01-00-9998 Misc, Capital Outlay 3,034.96 3.034.96
Total Circuit Court -Administration $0.00 $61,501.42 $61,501.42
Circuit Court - Judicial
311-05-00-3347 Expendable Equipment 32,281.77 32,281.77
311-05-00-9998 Misc. Capital Outlay 10,044.41 46,522.80 56,567.21
Total Circuit Court - Judicial $42,326.18 $46,522.80 $88,848.98
District Court - Novi
322-01-00-3347 Expendable Equipment 4,251.25 4,251.25
322-01-00-9998 Misc. Capital Outlay 3,017.30 11,423.60 14,440.90
Total District Court - Novi $7,268.55 $11,423.60 $18,692.15
District Court - Rochester Hills
324-01-00-3127 Budgeted Projects 15,726.65 25,900.00 41,626.65
Total District Court - Rochester Hills $15,726.65 $25,900.00 $41,626.65
District Court - Troy
325-01-00-3347 Expendable Equipment 4,007.35 4,007.35
325-01-00-9998 Misc. Capital Outlay 732.00 732.00
Total District Court - Troy $4,739.35 $0.00 $4,739,35
Prosecuting Attorney
411-01-00-3347 Expendable Equipment 11,748.44 11,748.44
411-01-00-9998 Misc. Capital Outlay 6,601.00 6,601.00
•••n•n•=4Mli MiMmm.m.
Total Prosecuting Attorney $18,349.44 $0.00 $18,349.44
Sheriff - Administrative Services
432-01-00-3347 Expendable Equipment 579.60 579.60
432-01-00-3774 Uniform Replacement 12,624.00 12.624.00
432-01-00-4898 Office Supplies 1,717.15 1,717.15
Total Sheriff - Administrative Svs. $2,296.75 $12,624.00 $14,920.75
Sheriff - Detention Facilities
433-10-00-4806 Bedding and Linen 2,433.00 2.433.00
433-10-00-4832 Dry Goods & Clothing 914.55 914.55
433-10-00-9998 Misc. Capital Outlay 2,572.00 2,572.00
Total Detention Facilities $3,486.55 $2,433.00 $5,919.55
Sheriff - Pre-Trial Housing . .
434-10-00-3347 Expendable Equipment 25,166.82 26,166.82
434-10-00-9998 Misc. Capital Outlay 21,093.73 29,832.27 50,926.00
Total Pre-Trial Housing $47,260.55 $29.832.27 $77,092.82
Sheriff - Patrol
436-15-00-3347 Expendable Equipment 579.60 579.60
Total Patrol $579.60 $0.00 $579.60
Sheriff - Operations Unit
439-10-00-3347 Expendable Equipment 281.65 281.65
439-10-00-4820 Deputy Supplies 20.638.00 9,022.70 29,660.70
Total Operations Unit $20,919.65 $9,022.70 $29,942.35
Sheriff - Specia) Teams Unit
439-15-00-9998 Misc, Capital Outlay 7,195.00 7,195.00
Total Special Teams Unit $7,195.00 $0.00 $7,195.00
Sheriff - NET Unit
439-20-00-3347 Expendable Equipment 1,086.30 1,086.30
Total NET Unit $1,086.30 $0.00 $1,086.30
Board of Commissioners - Administration
511-01-00-3048 Historical Commission 187.66 187.66
511-01-00-3790 Workshops & Meetings 10,800.00 10,800.00
Total Board of Comm. - Admin. $0.00 $10,987.66 $10,987.66
Board of Commissioners - Program Evaluation
511-02-00-3128 Professional Services 40,000.00 40,000.00
511-02-00-3456 Legal Expense 14,000.00 14,000.00
-----
Total Board of Comm. - Prg. Eval. $0.00 $54,000.00 $54,000.00
Board of Commissioners - Law Library
513-02-00-3342 Equip. Repairs & Maintenance 1,972.00 1,972.00
Total Board of Comm. - Law Library $0.00 $1,972.00 $1,972.00
Non-Departmental - Other County Operations
901-01-00-9121 Current Drain Assessments 175,875.43 175,876.43
901-01-00-9916 Future Space Requirements 327,500.00 327,500.00
ME%
Total Other County Operations $0.00 $503,376.43 $503,376.43
28,800.00 28,800.00
$0.00 $28,800.00 $28.80000
683,664.00 683,664.00
11•1•1111••••
$0.00 $683,664.00 $683,664.00
sisasatai it858_5.62.21
79,000.00 79,000.00
73,476.00 73,476.00
$0.00 $152,476.00 $152,476.00
300,447.00
240,224.00
280,443.74
300,447.00
240,224.00
280,443.74
Non-Departmental County Buildings/Space Allocations
902-01-00-9225 Vacant Space
Total County Buildings/Space Alloc.
Non-Departmental Reserve for Transfer
909-01-00-9920 Office Automation
Total Reserve for Transfer
TOTAL GENERAL FUND
Friend of the Court Fund 4-21500
Friend of the Court Administration
312-01-00-3347 Expendable Equipment
312-01-00-9998 Misc. Capital Outlay
Total Administration
Counseling, Inv. & Mediation
312-05-00-3128 Professional Services
312-05-004898 Office Supplies
312-05-00-6672 Print Shop
101,550.00 101,650.00
3,117.79 3,117,79
7,200.00 7,200,00
Total Counseling, Inv. & Mediation $0.00 $111,967.79 $111,967.79
TOTAL FRIEND OF THE COURT FUND $,UR S264.44319 $2E4_44172
Health Fund 4-22100
Health Division - Administration
162-01-00-3127 Budgeted Projects
162-01-00-3528 Miscellaneous
162-01-00-3682 Satellite Centers
Total Administration $0.00 $821,114.74 $821,114.74
Health Division - Laboratory
162-12-00-9998 Misc. Capital Outlay 15,500.00 15,500.00
Total Laboratory $0.00 $15,500.00 $15,500.00
Health Division - Education & Nutrition Services
162-33-00-3322 Educational Programs 8,891.00 8,891.00
$0.00 $8,891.00 Total Education & Nutrition Services $8,891.00
2,064.50 2,064.50
$2,064.50 $0.00 $2,064.50
TO-0,255-5n
Prepared by: Management and Budget 01/26/96
Animal Control
1 78-01 -00-4909 Postage
Total Animal Control
TOTAL HEALTH FUND
I =CRIMP Fund 4-26900
431-01-00-8101 General Fund - Sheriff
611-01-00-8101 General Fund - Drain Comm.
22,500.00
32,841.00
22,500.00
32,841.00
TOTAL CRIMP FUND TICIM 14.E.34LOCL =,Z=LCU
1Children's Village Fund 4-29230
165-01-00-3347 Expendable Equipment
165-01-00-9998 Misc. Capital Outlay
78,080.00
4,169.00
78,080.00
4,169,00
TOTAL CHILDREN'S VILLAGE FUND $.82249aQ $.D.M $87.249-011
Medical Care Facility fund 4-52100
163-60-00-3347 Expendable Equipment
163-60-00-9998 Misc. Capital Outlay
1,539.86
626.99
1,539.86
626.99
TOTAL MEDICAL CARE FAC. FUND $2.1.66.13.5, SLIM $2.1.66,35
TOTAL GOVERNMENTAL FUNDS E2A.8L51 fai_MAMM 173,11Q3.3.3-0.9.
100.00
RECEIVABLE ADJUSTMENTS
INFORMATION TECHNOLOGY FUND (#63600)
DEBIT ADJUSTMENT TO RECEIVABLES:
FARMINGTON HILLS CITY
Monies received prior 1993
BRANDON TOWNSHIP
December 1994 Invoice included a credit
error, should have been billed
LAND DATA TECHNOLOGIES
Write off a credit balance from 1994
(not a regular customer)
1,417.26
306.89
TOTAL DEBIT ADJUSTMENT S 1,821,15
CREDIT ADJUSTMENT TO RECEIVABLES:
MILFORD VILLAGE
December 1993 54.96
Billed July 1994 in error 81.96
LAKE ORION
1993 monies not received 65.00
WATERFORD TOWNSHIP
Double tilling September 1994
Monies not received prior 1994
220.00
631.94
WHITE LAKE TOWNSHIP
Monies not received prior 1993 134.00
BIRMINGHAM CITY
July 1994 monies not received 25.00
DRUG ENFORCEMENT AGENCY
Double billing January 1994
MSP CIS LIVONIA
September 1993 monies not received
375.00
375.00
SOUTHFIELD CITY
Monies not received prior 1993 230.53
OAK PARK CITY
Net of an non-payment for November 1993 and
an overpayment for March 1994 5.02
PONTIAC CITY
May 1994 monies not received 60.00
FARMINGTON CITY
1993 monies not received 210.00
FBI-WM EDWARDS
Monies not received prior 1993 389.51
WALLED LAKE CITY
1993 monies not received 130.00
ORCHARD LAKE VILLAGE CITY
1993 monies not received 50.24
SOUTHFIELD CITY POLICE DEPARTMENT
Credit adjustment given which did not get
recorded, but should have 144.00
SOUTHFIELD TOWNSHIP
Receivable adjustment 0.06
FEDERAL DISTRICT COURT
Over billed in 1994 225.00
BUTLER & MODELSKI, P.C.
1993 monies not received
WDIV-TV
Monies paid in 1993 but not recorded
U•S. DISTRICT COURT
Adjustment of monies billed in 1993 & 1994
per credits form information technology
120.00
150.00
15,641.50
LANDMARK TITLE SERVICE
1994 monies not received, bring account current 875.00
OAKLAND TITLE COMPANY
1394 monies not received, company out of
business 4,975.00
PROSECURE SERVICES
1992/1994 monies not received 1,8C0.00
$26,968.72
( 1.894
TOTAL CREDIT ADJUSTMENT
LESS: debit adjustment to receivable
NET CREDIT TO RECEIVABLE
HE FOREGOfNG RESOLUTION
A -Z
Date
HERE'S
L. Brooks tteraon—. Co----unty Executive
March 21, 1996 Resolution #96063
Moved by Douglas supported by Amos the resolution be adopted.
AYES: Garfield, Holbert, Jacobs, Jensen, Johnson, Kaczmar, Kingzett, Law,
McCulloch, Moffitt, Obrecht, Palmer, Pen -lick, Powers, Quarles, Schmid, Taub,
Wolf, Amos, Crake, Devine, Dingeldey, Douglas. (23)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on March 21, 1996 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 March 1996.
Qc
15. Allen, County Clerk