Loading...
HomeMy WebLinkAboutResolutions - 1998.09.03 - 25554MISCELLANEOUS RESOLUTION #98200 September 3, 1998 By: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIR2ERSON IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - FISCAL YEAR 1998 THIRD QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County 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) 1998 Third Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS Forfeiture of Bond revenue is lower than anticipated in the County Clerk Division; and WHEREAS the Prosecuting Attorney's Office is requesting the use of $22,000 from the Prosecutor's Law Enforcement Account (41-231000-10000-2853-60054) which has a current balance of $80,510.92; and WHEREAS $21,000 will be used for the Middle School Anti-Drug Initiative Program" which encourages an effective means of drug awareness at the middle school level; and WHEREAS $1,000 will be used for services as provided by the Troy Community Coalition to combat efforts to legalize marijuana; and WHEREAS funding is available in the Sheriff's Law Enforcement Enhancement account to cover the grant match required for the Law Enforcement Block Grant; and WHEREAS Computer Research Fee revenue is unfavorable in the Law Library as a result of lower customer on-line needs due to the advent of CD Rom devices; and WHEREAS unfavorability exists in the Law Library Continuations line due to an increase in costs for books, statutes, rules and regulation that are government mandated; and WHEREAS favorability exists in the Board of Commissioner's County Annual Audit line due to expenses being less than buddeted; and WHEREAS an increase in activity has expanded the use of a PTE position in Auditing causing unfavorability in Salaries and Fringe Benefits; and WHEREAS an oversight in carry forwarcs for the Regranting Program expenditures has caused unfavorability in the Office of Arts, Culture and Film; and WHEREAS favorability exists in Corporation Counsel's Salaries and Fringe Benefits due to a lag between funding and hiring new attorneys; and WHEREAS additional revenue generated as a result of transferring positions from CMH to Reimbursement per MR 497036 is collected in the Circuit Court rather than Reimbursement, thus requesting the estimatEd revenue budget be transferred to Circuit Court; and WHEREAS the Health Division reflects unfavorability in Postage due to State shifting responsibility to the County for transporting specimens to be tested; and WHEREAS the Health Division's Licenses and Permits are unfavorable due to lab inspections occurring earlier than anticipated; and WHEREAS a redistribution of Salaries and Fringe Benefits for the Health Division units is necessary to reflect actual usage for CPBC budget presentation to the State for auditing purposes; and WHEREAS favorability in the Teacher Services and Expense from the Children's Village School, due to contract modifications, can be used within the Department of Human Services to offset the increased contracted Autopsy cost in the Medical Examiner's office related to increased demand; and FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. WHEREAS responsibility for quality assurance of base maps converted to outside vendors has been transferred to the DISC Division of the Information Technology Department, requiring the transfer of appropriate resources; and WHEREAS Equalization's contractual obligations are resulting in unfavorable mileage and postage expenditures; and WHEREAS the specifications for digital camera equipment for the Equalization Division is nearing completion, and an amendment to fund the purchase of said equipment is recommended; and WHEREAS the funding is available from Equalization Division's salary favorability; and WHEREAS the State of Michigan has provided a supplementary allocation from the State Court Equity Fund, for the balance of FY 1998; and WHEREAS state revenue sharing is also anticipated to increase for the final quarter of FY 1998, these additional allocations can be used to offset additional non-departmental expenditures required to complete implementation of the Human Resources Financial Information System and to supplement the Contingency appropriation which will be reduced due to a need for the Prosecuting Attorney to contract with a fraud expert in an attempt to obtain forfeited drug monies; and WHEREAS due to continued efforts by Corporation Counsel and the Equalization Division, expenditures to defend Tax Tribunal Appeals will be less than budgeted, this favorability can be used to offset increased demands for Office Automation expenditures as well as for Miscellaneous Capital Outlay; and WHEREAS the Clerk/Register of Deeds is experiencing a substantial increase in Recording Fees, Mortgages, and Land Transfer Taxes due to an increase in activity, these revenue increases can be used to offset unfavorabilities in other areas; and WHEREAS revenue collection in the Treasurer's Industrial Facilities Tax and the TIFA/DDA Recovery IFT is less than anticipated; and WHEREAS an adjustment to Fiscal Services' Reimbursement of Salaries is needed for accounting services charged to the various internal services; and WHEREAS the Health Division's revenue is projected to be unfavorable primarily due to changes in managed care; and WHEREAS the Health Division also needs an adjustment due to overstated revenue, which was included during the FY 1998/FY 1999 Biennial Budget process related to the requested fee schedule adjustment, but was not approved; and WHEREAS the Department of Environmental Quality has issued an amendment to the Health Division's DEQ Agreement, which reflects an increase in revenue reimbursement and expenditures (OT, Training, Computer Equipment); and WHEREAS through May, the State of Michigan has continued to reimburse Oakland County for 50% of allowable Child Care Fund expenditures, even though the County has exceeded the "capped" level; and WHEREAS the Sheriff is projected to be unfavorable in Overtime due to continued high activity, and unfavorable hospitalization, insurance and medical supplies due to increase in the complexity of prisoner illnesses; and WHEREAS the Clerk's Administration unit reflects favorability in Printing County Directory as this is not anticipated to be expended during FY 1998; and WHEREAS the County Clerk is projected to be favorable in Salaries and Fringe Benefits due to turnover; and WHEREAS the Treasurer's Office Supply line is unfavorable due to ordering of employee checks, which was previously handled by Information Technology; and WHEREAS the Board of Commissioners reflects favorable Salaries and Fringe Benefits due to turnover, less than anticipated usage of Legal Services, and County Annual Audit services; and WHEREAS CMH is not anticipated to come under full authority during FY 1998, thereby foregoing the need to appropriate the required fund match (listed as an Operating Transfer Out)for this fiscal period and utilizing these funds as resources to offset unfavorability in other areas; and WHEREAS favorability exists in Corporation Counsel's Legal Expense line due to the dismissal of a lawsuit against the County Commissioners; and WHEREAS Professional Services expenses for HRFIS consultants has not been charged to Fiscal Services as appropriated but to the Non-Departmental budget; and FINANcE COMMITTEE WHEREAS the Health Division and Childrer's Village have favorability in Salaries and Fringe Benefits due to turnover, favorable operating due to fewer cases of TB and Children's Village Teacher Services and Expenses due to contract modifications, which can be used to offset unfavorable variances in other areas; and WHEREAS due to increased demand for Information Technology services additional funding is required to cover Development Charges and approved Office Automation Projects; and WHEREAS various amendments are required to the Information Technology Fund budget for Operations to more accurately reflect actual activity (see Schedule B); and WHEREAS Office Automation projects were approved by the Board of Commissioners per MR #98143. However the amendments necessary to appropriate the funds for the projects were not included and are being submitted as part of the FY 1998 Third Quarter Forecast (see Schedule C); and WHEREAS Section 25 of the FY 1997 General Appropriations Act (M.R. #96270) requires that the Board of Commissioners receive a quarterly report regarding adjustments made to Inmate Accounts on transactions billed in excess of ability to pay; and WHEREAS the General Appropriations Act requires that the Board of Commissioners approve all cancellation or write offs of debts owed the County in amounts of $1,000 or greater, a request for debt cancellation has been made by the Fiscal Services Division (Schedule D). NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 1998 Third Quarter Financial Forecast. BE IT FURTHER RESOLVED the Board authorizes amendments to the FY 1998 Budget as detailed on attached Schedules A, B, and C. BE IT FURTHER RESOLVED that the Board approves the cancellation of the debt owed the County as outlined in Schedule D. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. ACCOUNT NUMBER ACCOUNT NAME FY 1998 AMENDMENT Schedule A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 1998 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES GF/GP OPERATIONS - SELF BALANCING AMENDMENTS County Clerk Revenues 21-120100-01000-0529 21-140100-01000-0705 Prosecutor Revenue 41-110000-30000-2340 Expenditure 41-213000-30000-3348 Sheriff Revenue 43-013101-10001-0701 Expenditure 43-023101-20001-2872 Board of Commissioners Revenue 51-132000-53300-0389 21-140100-01000-0705 Expenditures 51-232000-53300-3076 51-212000-11000-2600 County Executive Expenditures 11-250100-20000-2001 11-250100-20000-2075 11-220100-10000-2001 11-220100-10000-2075 11-210200-01000-3460 Reimbursement Expertditures 12-705211-70535-0367 31-101100-21000-0367 County Clerk - Forfeiture of Bonds Clerk Reg. of Deeds - Mortgages Misc. Revenue Professional Services Miscellaneous Grant Match Law Library - Computer Research Fees Clerk Reg. of Deeds - Mortgages Law Library - Library Continuations Board of Comm. - County Annual Audit Corp. Counsel Salaries Corp. Counsel Fringe Benefits Auditing Salaries Auditing Fringe Benefits Arts, Culture and Film - Regrant. Prog. Reimb. - Co-op Reimb. Program Contra Cir. Ct. - Co-op Reimb. Program Contra ($37,000) 37,000 $22,000 22.000 $76,309 $76,309 ($4,100) 4.100 $60,000 (60.000) ($12,300) (5,100) 9,200 3,200 amo so_ ($36,073) 36,013_ Health Division EAKElditures 16-201200-10000-4248 16-212200-60002-3088 16-201200-10000-2001 16-201200-10000-2075 16-912000-15000-3156 16-235200-80000-3680 16-211200-10000-2001 16-211200-10000-2075 16-214200-10000-2001 16-214200-10000-2075 16-233200-70000-2001 16-233200-70000-2075 16-234200-80000-2001 16-234200-80000-2075 16-240200-80000-2001 16-240200-80000-2075 16-283200-80000-2001 16-283200-80000-2075 16-501200-10000-3684 GIS 18-101122-95000-3348 19-240000-40016-2001 19-240000-40016-2075 Equalization Expenditures 19-240000-40016-2001 19-240000-40016-3292 19-240000-40016-4284 19-240000-40016-3940 19-240000-40016-4100 Non-Departmental seven e 90-130000-12000-0231 90-130000-12000-0233 Exp_enditures 90-210000-21000-2836 90-210000-21000-9099 90-290000-25000-2564 90-290000-25000-9066 90-290000-25000-9169 Administration - Postage Lab. - Licenses and Permits Administration - Salaries Administration - Fringe Benefits Med Exam - Medical Svcs - Autopsies TB Cases - Outside Central Support - Salaries Central Support - Fringe Benefits Central Health Svcs. - Salaries Central Health Svcs. - Fringe Benefits HENS - Salaries HENS - Fringe Benefits Clinic - Salaries Clinic - Fringe Benefits MSS/ISS - Salaries MSS/ISS - Fringe Benefits VD Control - Salaries VD Control - Fringe Benefits CV - Teachers Services & Expense IT - Pro Services - DISC Equalization - Salaries Equalization - Fringe Benefits Salaries Personal Mileage Postage Refund of Prior Years' Revenue Expendable Equip. Exp. State Court Fund State Income Tax (Revenue Sharing) Financial System Tax Appeals Contingency Office Automation Misc. Capital Outlay $8,000 5,000 248,000 83,600 22,000 (13,000) (100,000) (33,500) (7,000) (2,500) (52,000) (17,500) (53,000) (17,600) (25,000) (8.400) (11,000) (4,100) (22.000) so $48,926 (31,696) (17,2301 so ($62,537) 15,500 24,000 15,037 so $311,600 60.000 $371.600 $311,600 (300,000) 60,000 200,000 100.000 $371.600 $9 GF/GP OPERATIONS - GENERAL AMENDMENTS Revenue Register of Deeds 21-140100-01000-0841 21-140100-01000-0705 21-140100-01000-0625 Treasurer 22-221110-01000-0587 22-221110-01000-1059 Fiscal Services 12-601100-10001-0907 Human Services 16-220100-65000-0255 16-220100-65000-0525 16-220100-65000-0645 16-233100-70000-0727 16-234100-80000-0515 16-240100-80000-0669 16-501100-10000-0755 Non-Departmental 90-132000-12000-0159 Total Revenue Expenditures Sheriff 43-23201-20002-2002 43-23201-20002-3780 43-23201-20002-3784 43-23210-10001-2002 43-23301-20003-2002 43-23310-20021-2004 43-23310-20021-2920 43-23310-20021-2976 43-23310-20021-4040 43-23310-20021-4100 43-23310-20021-4240 43-23311-20021-2002 43-23311-20021-2004 43-23311-20021-2075 43-23314-20021-2004 43-23318-20028-2002 43-23320-20029-2002 43-23335-10001-2002 43-23401-20003-2002 43-23410-20027-2002 43-23410-20024-2004 43-23410-20024-2075 Recording Fees Mortgages Land Transfer Tax Treasurer - Industrial Facilities Tax Treasurer - TIFA/DDA Recovery IFT Reimbursement of Salaries EH - 2B Non-Community Water Supply EH - Food Service Licenses EH - On-Site Sewerage Permits HENS - Nutrition Internship Clinic - Flu - 3rd Party MSS/ISS - Maternal Support CV - Out County Board & Care Child Care Subsidy Admin. - OT Admin. - Uniform Cleaning Admin. - Uniforms Training - OT Corr. Svcs. Admin. - OT Detention - Holiday OT Detention - Hosp./Prison. Detention - Insurance Detention - Data Process Supplies Detention - Expendable Equip. Exp. Detention - Medical Supplies Detention (South) - OT Detention (South) - Holiday OT Detention (South) - Fringe Benefits Visiting - Holiday OT Classifications - OT Inmate Services. - OT Food Services - OT Corr. Services Satellite - OT Pretrial - OT Pretrial - Holiday OT Pretrial - Fringe Benefits 265,000 318,900 6_83-00 $1,268,900 ($200,000) (35.000) ($235.000) $60,600 58,400 (46,000) (24,000) (5,000) (38,000) (75,000) 286.000 $156,400 $1,000,000 $212504 900 $15,000 16,600 13,200 4,000 1,400 28,100 670,000 45,500 10,000 18,500 140,000 82,300 35,400 30,700 5,100 18,600 10,600 3,300 1,000 112,000 19,600 95,200 43-23412-20022-2004 43-23415-20026-2002 43-23415-20026-2004 43-23417-20023-2002 43-23417-20023-2004 43-23425-20025-2002 43-23425-20025-2004 43-23430-20024-2004 43-23430-20024-4100 43-23601-20004-9196 43-23617-30001-2004 43-23617-30001-2075 43-23618-30003-2004 43-23618-30003-2075 43-23630-20006-2002 43-23630-20006-2075 43-23910-10001-4044 43-23910-10001-4156 43-23915-20013-2002 43-23915-20013-2075 43-23920-20014-2002 43-23920-20014-2075 Clerk - Admin. 21-210100-01000-3328 County Clerk 21-221000-01000-2001 21-221000-01000-2075 Treasurer 22-221120-01000-4252 Board of Commissioners 51-211000-10000-2001 51-211000-10000-2075 51-212000-11000-3060 51-212000-11000-2600 51-211000-10000-8001 Corporation Couasel 11-250100-20000-3060 Fis_ at Services 12-601200-10001-3348 Human Se rvice_s 16-201200-10000-2001 16-201200-10000-2075 16-220200-65000-2002 16-220200-65000-3704 Court Detention - Holiday OT Trusty Camp - OT Trusty Camp - Holiday OT L Bldg. -OT L Bldg. - Holiday Ot Southfield - OT Southfield - Holiday OT Work Release Exp. - Holiday OT Work Release - Expendable Equip. Exp. Protection Services - Misc. Cap. Outlay C P Roch. Hills - Holiday OT C P Roch. Hills - Fringe Benefits Contract Patrol - Holiday OT Contract Patrol - Fringe Benefits Traffic Exp. -OT Traffic Exp. - Fringe Benefits Operations - Deputy Supplies Operations - Lab Supplies Special Teams - OT Special Teams - Fringe Benefits NET Exp. -OT NET Exp. - Fringe Benefits Printing County Directory Salaries Fringe Benefits Treasurer - Office Supplies Salaries Fringe Benefits Legal Services County Annual Audit Operating Transfer Out Corp. Counsel - Legal Expenses Professional Services Health Admin. - Salaries Health Admin. - Fringe Benefits EH - Overtime EH-Training 2,100 20,400 12,800 64,700 10,100 7,800 2,800 2,000 10,500 23,000 28,100 16,300 48,800 28,300 109,600 64,300 21,000 5,000 21,000 10,000 24,400 14.400 $1,923,500 ($14,000) ($57,700) (17,300) ($75,000) $36,000 ($34,600) (10,400) (20,000) (40,000) (1.042.300) ($1,147,300) ($36,000) ($130,000) ($29,700) (9,900) $9,700 3,600 16-220200-65000-4100 16-235200-80000-4072 16-261200-75000-3544 16-501200-10000-2001 16-501200-10000-2075 16-501200-10000-3684 InformationZlestio_gy 18-101112-10000-6030 Total Expenditures TOTAL GF/GP OPERATIONS EH - Expendable Equip. Exp. TB Control - Drugs Sub. Abuse Control - Satellite Centers CV - Salaries CV - Fringe Benefits CV - Teachers Services & Exp. Information Technology - Development 5,300 (40,000) (2,300) (115,500) (34,500) (50.000) ($263,300) 1,957,000 $22511.9110 so Prepared by: Fiscal Services 08118/98 ADJUSTMENTS 89,356 131,170 112,557 137,730 5,400 22,384 8,100 7,189 17,307 27,922 3,098 42,879 116,603 385,260 54,919 2,352 3,423 (61,591) (212,719) 499,505 733,247 565,287 213,266 351,777 524,177 1,617,577 734,636 14,710 7,973 120,783 20,170 285,098 4,284 (77,846) 168,803 40,189 39,197 0 0 6,669 765 54,277 6,072 34,277 251,894 (36,471) 30,157 25,222 5,495 5,200 (5,200) 1,101 (1,101) 786 (786) 22,330 (22,330) 160 (160) 2,589 (2,589) 2,910 (2,910) 12,123 4,077 (13,559) 3,000 (3,000) 2,142 2,530 (2,641) 9,396 THIRD QUARTER INFO. TECH. ADJUSTMENTS INFORMA TION TECHNOLOGY - OPERATIONS (6636) Adopted 1st Qtr. 2nd Qtr. 3rd Qtr. Budget Amendment Amendment Amendment Amended Budget Amended Budget minus 4th Qtr. 4th Qtr. Expensed Balance Projection Projection 220,393 0 6,669 765 94,626 215,423 32,687 30,717 0 0 0 9,396 0 0 0 0 2,142 0 42,771 (41,898) (108,980) 21-221000-01000-6636 Clerk Legal Records 410,149 19-240000-40016-6636 Master Appraisal 602,077 12-601200-10001-6636 Fiscal Serv. Adm. 441,532 12-401200-40010-6636 Purchasing 170,387 12-701200-70130-6636 Reimbursement 235,174 22-221120-1000-6636 Treas. Office 524,177 43-023310-20021-6636 Sheriff-Corrective Serv. 1,232,317 16-201200-10000-6636 Health Div 541,987 32-205200-20006-6636 D.C. Probation 12,358 32-305200-20006-6636 52/2 Probation 7,973 51-211000-10000-6636 Board of Commissioners 89,576 32-405200-20006-6636 52/3 Probation 20,170 17-300200-21000-6636 Veterans Serv. 285,098 15-402200-10001-6636 Personnel 302,367 (279,263) 34-101200-40001-6636Probate-Juv 73,032 41-211000-10000-6636 Prosecutor 381,522 11-220100-10000-6636 Auditing 33,000 16-555200-10000-6636 Children's Village School 39,197 17-901200-97500-66360 C.C. Probation 21-230100-01000-6636 Elections Admin. 21-250100-01000-6666 Jury Commission 21-220500-01000-6666 Clerk Vital Stets. 21-240100-01000-6636 Register of Deeds 128,164 47,000 19-697402-60006-6636 Comm. Dev-Housing Coun. 11-210500,01000 6636 Comm Min Cultural Affairs 17-502200-55000-6636 Co-op Ext.-Gypsy Moth 11-210100-01000-6636 County Executive 19-221000-10000-6636 Development & Planning 14-213000-60000-6636 EMS 14-211000-3000-6636 Fac. Mgmt. 12-622222-62323-6636 Health Acctg. 16-234200-80000-6636 Health Clinic 16-232200-80000-6636 Health Dental 16-220200-65000-6636 Health Environmental 16-236200-80000-6636 Health Field Nursing 16-215200-80000-6636 Health - Jail 31-1200-10002-6636 Drug Mgmt. 16-912000-15000-6636 Medical Examiner 17-402220-97000-6636 Pretrial Serv. 17-302202-21000-6636 Pretrial Serv. - Grant 21,881 477,624 29,175 (470,330) 18,028 715,219 24,037 (709,210) 240,362 324,925 320,483 (244,804) 44,762 168,504 59,683 (153,583) 176,329 175,448 235,105 (116,672) 171,208 352,969 228,277 (295,900) 1,075,798 541,779 1,434,397 (183,180) 477,812 256,824 637,083 (97,553) 3,715 10,995 4,953 (9,757) 6624 2,349 7,499 (474) 89,179 31,604 118,905 (1,878) 14,480 5,690 19,307 (250) 159,372 125,726 212,496 (72,602) (2,356,193) 205,570 (201,286) 274,093 269,809 169,789 (247,635) 226,385 304,231 317,506 (148,703) 423,341 254,538 49,531 (9,342) 66,041 25,852 76,710 (37,513) 102,280 63,083 59,639 (59,639) 79,519 79,519 26,980 (26,980) 35,973 35,973 10,376 (10,376) 13,835 13,835 15,446 (15,446) 20,595 20,595 323,181 (102,788) 430,908 210,515 4,132 (4,132) 5,509 5,509 9,818 (3,149) 13,091 6,422 4,826 (4,061) 6,435 5,670 73,925 20,701 98,567 3,941 185,449 29,974 247,265 31,842 29,050 3,637 38,733 6,046 41,191 (10,474) 54,921 24,204 1,024 (1,024) 1,365 1,365 2,294 (2,294) 3,059 3,059 1,820 (1,820) 2,427 2,427 49,439 (40,043) 65,919 56,523 12,330 (12,330) 16,440 16,440 11,908 (11,908) 15,877 15,877 642 (642) 856 856 23,284 (23,284) 31,045 31,045 12,498 (10,356) 16,664 14,522 11,427 (11,427) 15,236 15,236 tn C. c wk4 1 08/12198 THIRD QUARTER INFO. TECH. ADJUSTMENTS INFORMATION TECHNOLOGY - OPERATIONS (6636) Amended Budget minus Adopted 1st Qtr. 2nd Qtr. 3rd Qtr. Amended 4th Qtr. 4th Qtr. Budget Amendment Amendment Amendment Budget Expensed Balance Projection Projection 13-667302-10-6636 Print Shop 0 9,746 (9,746) 12,995 12,995 19 240000-40016-6636 Equalization 69,149 69,149 299,048 (229,899) 398,731 329,582 13-660200-10-6636 Radio 5,388 5,388 13,917 (8,529) 18,556 13,168 13-138203-10-6636 Record Retention 10,965 2,389 13,354 16,695 (3,341) 22,260 8,906 51-233000-53500-6636 Research Library 131,044 50,840 181,884 141,350 40,534 188,467 6,583 14-211000-30000-6636 Solid Waste 25,222 5,495 30,717 43,682 (12,965) 58,243 27,526 13-138201-10-6636 Support Serv.-Mail Room 2,752 2,752 9,987 (7,235) 13,316 10,564 12-705212-70535-6033 FOC Child Supp. Imaging 67,249 67,249 72,553 (5,304) 96,737 29,488 31-201200-10004-6033 FOC Imaging 397,303 397,303 468,447 (71,144) 624,596 227,293 21-221000-1000-6033 Clerk - Imaging 32,589 32,589 152,807 (120,218) 203,743 171,154 2,356,193 (0) adj3q wk4 2 08/12/98 FY199/3 FY1 996 402,264 226.574 zam $236,574 5402.264 Expenoitures Generai Fund11011 90-290000-25000-9066 Office Automation 0 510Q MOD - SCHEDULE C INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - THIRD QUARTER. F.Y. 1998 GOVERNME.NIALELLIDZ 3rd Quarter Transfer Revemie Total Revenue 32-501200-20001-6636 51-211000-10000-6636 31-101200-10001-6636 17-901200-97500-6636 11-250100-20000-6636 11-210100-01000-6636 19-221000-10000-6636 61-211001-10000-6636 19-240000-40016-6636 12-601200-10001-6636 15-402200-10001-6636 17-402220-97000-6636 34-401200-40001-6636 41-211000-10000-6636 12-401200-40010-6636 12-701200-70130-6636 51-223000-53500-6636 43-022310-20021-6636 13-138201-00010-6536 22-221120-01000-6636 Information Technology Operations: Department District Court Board of Commissioners Circuit Court Circuit Court County Executive County Executive Community & Economic Development Drain Commissioner Management & Budget Management & Budget Personnel Public Services Probate Court Prosecutor Management & Budget Management & Budget Board of Commissioners Sheriff Central Services Treasurer Division 5214 District Court Troy Board of Commissioners Circuit Court Circuit Court Probation Corporation Counsel County Executive Development & Planning Drain Commissioner Equalization Fiscal Services - Admin Personnel Pre-Trial Services - County Probate Juvenile Prosecutor Purchasing Reimbursement Research Library Sheriff Support Services Treasurer Sub-Total General Fund Childrens Village Sub-Total Fund 293 4.514 8.568 2.752 4,284 1,221 0 2.142 4.284 624 1,248 23.580 47,160 1,494 2,988 4.284 8,568 11.424 17,964 2.142 4,284 4,284 8,568 2.142 4,284 19.356 1,248 3.892 5.220 2.142 4,284 9.192 18.384 3.390 6.780 55.403 104,064 2.752 4.284 10.710 21 420 $167.440 $277,884 i6.94 6,644 Chtldrens Village Fund 12931 16-501200-10000-6636 Childrens Village Health Fund [221] 14-213000-60000-6636 16-201200-10000-6636 16-220200-65000-6636 Facilities Management Human Services Human Services EMS Health Health - Environmental Sub-Total Fund 221 2.142 50.652 9.196 62.190 4.284 101.304 18.792 124.380 Total Governmental Funds 07(08198 c:n123wkskjobacctg\oa-amendQFY913-0A.WK4 NONmGOVERNMENTALELMS ParksARecte.ation Fund [2081 INFORMATION 'TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - THIRD QUARTER, F.Y. 1998 C.MH Fund 97-98 [2221 Parks & Recreation - Admin 4284 Sub-Total Fund 208 4.284 8.568 CMH - Administration 29,262 55.764 CMH - DD South 2.142 tilfg Sub-Total Fund 222 31,404 60.048 MeclicaLCKe Facility Fund1521] Medical Care Facility 1.248 Sub-Total Fund 521 1.248 2.496 Fa_dities Maintenance & Operations Fund [6311 FM&O 21.420 42.840 Sub-Total Fund 631 21,420 42.840 Mailing. Cony. Copier & Printing Fund16671 Print Shop 2,142 Sub-Total Fund 567 2,142 4.284 Information Technology [6361 Revenue 18-636111-10000-0737 Governmental Operations $236,574 $402.264 18-636111-10000-0717 Non-governmental Operations 60.498 118.238 Sub-Total $297.072 $520.50Q Expenses 18.436162-15000-3900 Depreciation $50,804 $101,609 18-636162-15000-2776 Equipment Repairs & Maint 10,486 20,971 18-636162-15000-3596 Software 1,350 18-636162-15000-4260 Parts & Accessories 66,743 18-636122-15000-3348 Professional Services 0 Sub-Total $129.383 8122.580 18-636113-10000-8005 Revenue Over (Under) Expense 1.1E-6112 8397 920 cA123wks\jobacctgkoa-amend\3FY98-0A.WK4 07/08/98 interoffice MEMORANDUM to: Timothy Soave from: Raleigh C. Parrott subject: Write Off of Uncollectable Account date: August 5, 1998 In compliance with Miscellaneous Resolution #93135, the following amount needs to be presented to the Board of Commissioners as part of the quarterly financial report: There were two vendors on the Accounting System in 1995 with the name IMP Printing, one located in Pontiac and one in Walled Lake. The 52/1 District Court received printing orders from I.M.P. Printing in Walled Lake during the period of February - June 1995 amounting to $1,991.08. The invoices for these orders were approved and forwarded to Accounting for processing, and unfortunately the payments were processed to IMP Printing in Pontiac. In time, I.M.P. Printing of Walled Lake inquired about non-payment of their invoices, and after investigation, payment was made to the correct vendor in April. 1996. This amount was paid from an Accounts Receivable account, and attempts were made to contact the wrong vendor about the payment error. Of course, they claimed to have a new owner, and the previous owner must have received and cashed the checks. The matter was referred to the Auditing Division, and subsequently went to Corporation Counsel. Attempts were made to collect through District Court, and even though a lawsuit was filed against the owners, collection was never possible. As of July 1997, IMP Printing of Pontiac as a corp- oration has been disolved. This amount of $1,991.08 is therefore uncollectable. and should be written off. Details of the preceeding are on file in this office. • • HE FORMOING RES L Brooks Pattyrion, County Executhts Dais ,twarealooMo., .e Resolution #98200 September 3, 1998 Moved by Douglas supported by Law the resolution be adopted. AYES: Dingeldey, Douglas, Garfield, Gregory, Hoffman, Holbert, Huntoon, Jacobs, Jensen, Johnson, Kaczmar, Kingzett, Law, McCulloch, McPherson, Moffitt, Obrecht, Palmer, Schmid, Taub, Amos, Coleman. (22) 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 September 3, 1998 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 3rd day olf _49-pte 19A. ......111113- Lynn D. Allen, County Clerk