Loading...
HomeMy WebLinkAboutResolutions - 1997.12.11 - 24991MISCELLANEOUS RESOLUTION #97277 December 11, 1997 BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 1997 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 Fiscal Year (FY) 1997; and WHEREAS Restatement #1 of the Governmental Accounting, Auditing and Financial Reporting Standards requires that encumbrances and appropriations carried-forward be treated as a reserved 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 the Department of Information Technology has a number of projects which must be completed to either maintain the information base or improve service to county departments and their constituents, specifically the implementation of the Integrated Justice System, continued conversion of data codes for the year 2000, and completion of the new Human Resources Financial Information System; 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, specifically through develop of electronic base maps and Geographic Information Systems (G.I.S.) and the upgrade of the Court Law Enforcement Management Information System (CLEMIS) system; and WHEREAS pursuant to M.R. #97203, the Board of Commissioners approved a $3,341,347 loan from the Delinquent Tax Revolving Fund to purchase an enterprise wide lan-based imaging system, FY 1997 fund balance can be used to purchase the system negating the need for the loan; and WHEREAS pursuant to M.R. #89283 the Board of Commissioners established a Designated Fund for Operational Improvements, which makes available a source of funds departments can use to support innovative programs, providing the Board approves the use of the fund balance and the requesting department commits to a pay-back within six (6) years of the original allocation; and WHEREAS the arbitrator, conducting the hearing involving the County and the Oakland County Command Officers' Association, has determined that the factor used to calculate Association members' retirement benefits should be increased to 2.5, should that determination be upheld additional funding will be required to cover the increased retirement cost; and WHEREAS state statue requires that 50% of the funds received by the County through the State Convention Facility tax be allocated to the Health Division for substance abuse prevention programs, a portion of the undesignated fund balance reflects an increased revenue from this source which must be reallocated to the Health Division; and WHEREAS the Board of Commissioners has authorized the use of $375,000 from the FY 1998 Designated Fund Balance to support a professional services contract designing Phase I of a new assessment and property tax system; and WHEREAS the Board of Commissioners has authorized the use of $662,758 in the FY 1998 Designated Fund Balance to purchase a single mainframe processor; and WHEREAS the Board of Commissioners has authorized the use of $6,382,384 in the FY 1997 Designated Fund Balance to replace the Court and Law Enforcement Management Information System (CLEMIS); and WHEREAS funds are required to implement a well code policy including the development of a map and proper testing procedures; and WHEREAS due to delays in implementing a well code policy, the County may experience a loss of state health cost sharing funds; and WHEREAS the FY 1998 Non-Departmental Contingency account has been depleted, funds are available in the undesignated fund balance to restore the account until the FY 1998 First Quarter Financial Forecast is completed; and WHEREAS the Circuit Court, due to a recent retirement, has the opportunity to modify a courtroom for video equipment, funding is available in the Equipment Fund balance to cover the cost of said equipment and modifications. NOW THEREFORE BE IT RESOLVED that the report of operations, for Fiscal Year 1997, 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 various line items in the FY 1998 Budget be amended to include $210,174.64 for outstanding purchase orders ($202,888.83 - General Fund) and $6,651,828.56 for appropriations carried forward ($5,710,513.99 - General Fund) as detailed in the attached schedules. BE IT FURTHER RESOLVED adjustments to the fund balance be approved as follows: Balance Before Adjustments (result of FY 1997 activity) $ 15,219,731.26 Add to General Fund Balance: Repayment of Advance for Bunny Run Lake Level 12,000.00 Long Lake Aug. Well 56,000.00 C.O.S.D.S. Pontiac Twp. Ext. 3 306,807.50 Emergency Salaries Fund Balance 150,000.00 Information Technology Projects Fund Balance 4,664,561.00 Retiree's Health Care Cost Fund Balance 2,000,000.00 Adjusted Total Including Additions $ 22,409,099.76 Deduct from General Fund Balance: CLEMIS $( 6,400,000.00) Imaging Loan Payoff ( 3,400,000.00) Integrated Justice System ( 3,250,000.00) Year 2000 Conversion ( 2,500,000.00) G.I.S. ( 1,591,253.00) Operational Improvements ( 1,464,555.00) Command Officers' Arbitration Finding ( 955,000.00) Mainframe Replacement ( 700,000.00) Financial System ( 650,000.00) Well Code Study ( 500,000.00) Equalization System ( 375,000.00) Grant Reductions ( 300,000.00) Health Satellite Centers ( 200,000.00) Gypsy Moth Program 55,000.00) Increase Petty Cash 10,410.00) Adjusted Total Including Additions/Subtractions $ 57,881.76 Undesignated Fund Balance At Beginning of Year Undesignated Fund Balance At the End of Year 784,115.62 BE IT FURTHER RESOLVED that $197,539 from the FY 1997 Designated Fund Balance for Health Satellite Centers be appropriated to the Health Division, Satellite Centers account (416-261200-75000-3544) to increase substance abuse prevention programs pursuant to state statue as follows: Revenue 90-190000-14000-1582 Prior Years Balance $197,539 Expenditures 16-261200-75000-3544 Satellite Centers $197,539 726,233.86 BE IT FURTHER RESOLVED that the $375,000 from the Designated Fund Balance for the Replacement Equalization System be appropriated to the Department of Information Technology, as specified below, to cover the professional services contract developing phase I of this projects: General Fund Revenue 90-190000-14000-1582 Prior Years Balance Expenditures 18-101113-10000-8001 Operating Trans. - Out $375,000 $375,000 0 Information Technology Fund Revenue 18-636113-10000-1701 Operating Trans. - In $375,000 Expenditure 18-636122-15000-3348 Professional Services $375,000 0 BE IT FURTHER RESOLVED that the $662,758 from the Designated Fund Balance for the Mainframe Replacement be appropriated to the Department of Information Technology, as specified below, to cover the purchase of a single Mainframe Processor: General Fund Revenue 90-190000-14000-1582 Prior Years Balance Expenditures 18-101113-10000-8001 Operating Trans. - Out Information Technology Fund Revenue 18-636113-10000-1701 Operating Trans. - In Expenditure 18-636113-10000-8005 Est. Change in Equity $662,758 $662,758 0 $662,758 $662,758 0 BE IT FURTHER RESOLVED that $6,382,384 from the FY 1997 Designated Fund Balance for CLEMIS appropriated to a non-departmental account to replace the CLEMIS system: Revenue 90-190000-14000-1582 Prior Years Balance $6,382,384 Expenditures 90-210000-21000-6362 CLEMIS $6,382,384 BE IT FURTHER RESOLVED that $150,000 from the FY 1997 Undesignated Fund Balance be designated to restore the Non-Departmental Contingency account and be appropriated to that account as specified below: Revenue 90-190000-14000-1582 Prior Years Balance $150,000 Expenditures 90-290000-25000-2564 Contingency $150,000 BE IT FURTHER RESOLVED that $68,000 from the Equipment Fund fund balance be used to purchase and install video equipment for the Circuit Court. Chairperson, on behalf of the Finance and Personnel Committee, I move adoption of the foregoing resolution. FINANCE AND PERSONNEL COMMITTEE n:\budget\forecast\95yeared.mr 2,534.00 2,534.00 Total Reimbursement - Administration $0.00 $2,534.00 $2,534.00 127-01-00-3128 Professional Services OAKLAND COUNTY, MICHIGAN OUTSTANDING PURCHASE ORDERS AND CARRY FORWARDS September 30, 1997 Outstanding Purchase Carry- Orders Forward Total General Fund 4-10100 Executive - Admin. - Auditing 112-01-00-3347 Expendable Equipment 112-01-00-9998 Capital Outlay Total Executive - Admin. - Auditing Fiscal Services - Administration $5,148.29 $5,148.29 $1,660.50 $1,660.50 $6,808.79 $0.00 $6,808.79 126-01-00-3128 Professional, Services 121,500.00 $121,500.00 Fiscal Services - Administration $0.00 $121,500.00 $121,500.00 Reimbursement - Administration Personnel - Human Resources 154-01-00-3347 Expendable Equipment 1,473.06 1,473.06 154-01-00-3653 Recruitment Expense 2,950.05 2,950.05 Total Personnel - Human Resources $4,423.11 $0.00 $4,423.11 Personnel- Employee Relations 155-01-00-4898 Office Supplies 800.15 800.15 Total Personnel - Employee Relations $800.15 $0.00 $800.15 Human Services - Administration 161-01-00-3128 Professional Services 30,000.00 30,000.00 • Total Human Services - Administration $0.00 $30,000.00 $30,000.00 Human Services - Medical Examiner 169-01-00-4875 Laboratory Supplies 673.44 673.44 Total Human Services - Medical Examiner $673.44 $0.00 $673.44 Public Services - Veterans Services 173-01-00-9998 Capital Outlay $697.50 697.50 — Total Public Services - Veterans Services $697.50 $0.00 $697.50 Public Services - MSU Extension 175-01-01-3128 Professional Services $962.54 962.54 175-01-01-4898 Office Supplies $1,501.05 1,501.05 Total Public Services - MSU Extension $2,463.59 $0.00 $2,463.59 Development and Planning - Admin. 192-01-00-3302 Data Processing 3,546.50 3,546.50 192-01-00-3347 Expendable Equipment 780.00 780.00 192-01-00-9998 Capital Outlay 8,000.00 8,000.00 Total Development and Planning - Admin. $0.00 $12,326.50 $12,326.50 Equalization - Administration 194-01-00-3129 Professional Services 991,307.75 991,307.75 194-01-00-3347 Expendable Equipment 297.90 297.90 194-01-00-9998 Capital Outlay 4,126.32 4,126.32 Total Equalization - Administration $4,424.22 $991,307.75 $995,731.97 Clerk/Register of Deeds 211-01-00-3586 Printing Cty. Directory 18,230.75 18,230.75 211-01-00-9998 Capital Outlay 1,269.97 1,269.97 Total Clerk/Register of Deeds $19,500.72 $19,500.72 Treasurer 221-01-00-3128 Professional Services 92,452.86 92,452.86 221-01-00-4898 Office Supplies 2,085.00 2,085.00 Total Treasurer $2,085.00 $92,452.86 $94,537.86 Circuit Court - Administration 311-01-00-3127 Budgeted Projects 7,858.00 7,858.00 311-01-00-3128 Professional Services 154,369.77 154,369.77 311-01-00-3342 Equip. Repairs & Maint. 2,077.00 2,077.00 311-01-00-3347 Expendable Equip. 29,747.59 29,747.59 311-01-00-9998 Misc. Capital Outlay 8,736.42 62,003.00 70,739.42 -- --- Total Circuit Court -Administration $38,484.01 $226,307.77 $264,791.78 Circuit Court - Judicial 311-05-00-3347 Expendable Equipment 8,939.52 8,939.52 311-05-00-9998 Capital Outlay 8,816.00 8,816.00 Total Circuit Court - Judicial $17,755.52 $0.00 $17,755.52 A° Probate Court - Judicial 341-01-00-9998 Capital Outlay 1,820.25 1,820.25 Total Probate Court - Judicial - Admin. $1,820.25 $0.00 $1,820.25 Probate Court - Judicial Support 344-01-00-3347 Expendable Equipment 247.50 247.50 344-01-00-9998 Capital Outlay 4,283.25 4,283.25 Total Probate Court - Administration $4,530.75 $0.00 $4,530.75 Probate Court - Court Services 347-01-00-3347 Testing Materials 5,358.60 5,358.60 — Total Probate Court - Court Services $5,358.60 $0.00 $5,358.60 Prosecuting Attorney 411-01-00-3347 Expendable Equipment 6,718.98 $6,718.98 411-01-00-3582 Printing 3,245.00 30,000.00 $33,245.00 411-01-00-4898 Office Supplies 9,605.00 $9,605.00 411-01-00-9998 Capital Outlay 1,020.06 $1,020.06 Total Prosecuting Attorney $20,589.04 $30,000.00 $50,589.04 Sheriff - Corrective Services 433-10-00-9998 Capital Outlay 549.00 549.00 Total Sheriff - Corrective Services $549.00 $0.00 $549.00 Sheriff - Pre-Trial Housing 434-10-00-3452 Laundry & Cleaning 8,137.40 8,137.40 Total Sheriff - Pre-Trial Housing $8,137.40 $0.00 $8,137.40 Sheriff - Technical Services 439-10-00-4820 Deputy Supplies 61,829.04 61,829.04 439-10-00-4875 Laboratory Supplies 1,000.00 1,000.00 439-10-00-9998 Misc. Capital Outlay 958.70 958.70 Total Sheriff - Technical Services $63,787.74 $0.00 $63,787.74 Board of Commissioners - Administration 511-01-00-9998 Capital Outlay 17,062.59 17,062.59 Total Board of Commissioners - Administration $0.00 $17,062.59 $17,062.59 Board of Comm. - Program Evaluation $0.00 $6,117.18 $6,117.18 Total 1,010,633.13 2,917,735.21 1,010,633.13 2,917,735.21 Other County Appropriations - County Operation $0.00 $3,928,368.34 $3,928,368.34 Total 252,537.00 252,537.00 Non-Departmental - Reserve For Transfer $0.00 $252,537.00 $252,537.00 Total 3,794.50 $3,794.50 240,224.00 643,749.57 $883,973.57 740.00 $740.00 2,751.31 ------ $2,751.31 $891,259.38 3,794.50 $3,794.50 $0.00 240,224.00 643,749.57 $0.00 $883,973.57 740.00 $740.00 $0.00 2,751.31 $2,751.31 $0.00 $7,285.81 $883,973.57 Board of Comm. 511-02-00-3128 511-02-00-3456 - Program Evaluation Professional Services Legal Expense 5,117.18 1,000.00 5,117.18 1,000.00 Other County Appropriations - County Operations 901-01-00-9917 Remonumentation 901-01-00-3357 Financial System Non-Departmental - Reserve For Transfer 909-01-00-9920 Office Automation TOTAL GENERAL FUND $202.888.83 ail 15.12,22 $5.. 9 1 3 2.1i 2 Health Fund 4-22100 Emergency Medical Services 141-30-00-3278 Communications Total Emergency Medical Services Human- Services 162-01-00-3528 Miscellaneous 162-01-00-3682 Satellite Centers Total Human Services Field Nursing 162-36-00-3347 Expendable Equipment Total Field Nursing Animal Control 178-01-00-4934 Tax Collection Supplies Total Animal Control TOTAL HEALTH FUND 22,500.00 32,841.00 $55,341.00 2,000.00 CRIMP Fund 4-26900 431-01-00-8101 General Fund - Sheriff 611-01-00-8101 General Fund - Drain Comm. TOTAL CRIMP FUND Children's Village Fund 4-29230 165-01-00-9998 Capital Outlay TOTAL CHILDREN'S VILLAGE FUND TOTAL GOVERNMENTAL FUNDS Prepared by: Management and Budget 22,500.00 32,841.00 $0.00 $55,341.00 2,000.00 $2,0110M $2 -MUM $ 2 12.1/4._64 $6.6J1.828.56 S6.8_62.09120 11/24/97 In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 11th day t14005ece 199 . et'A. 064 LynA D. Allen, County Clerk Resolution #97277 December 11, 1997 Moved by Douglas supported by Amos the resolution be adopted. AYES: Jensen, Johnson, Kingzett, Law, McCulloch, McPherson, Millard, Moffitt, Obrecht, Palmer, Powers, Schmid, Taub, Wolf, Amos, Coleman, Dingeldey, Douglas, Fracassi, Garfield, Holbert, Huntoon, Jacobs. (23) NAYS: None. (0) A sufficient majority having voted therefor, the resolution was adopted. L Br E THE FOREGOING RESOLUTION P/4?-1 Patterson, County Executive Date 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 December 11, 1997 with the original record thereof now remaining in my office.