Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 1990.12.13 - 16864
December 13, 1990 MISCELLANEOUS RESOLUTION # 902E6 BY: FINANCE COMMITTEE, DR. G. WILLIAM CADDELL, CHAIRPERSON IN RE: MANAGEMENT AND BUDGET - 1990 THIRD FORECAST AND BUDGET AMENDMENTS TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Mr. Chairperson, Ladies and Gentlemen: WHEREAS the Third Quarter Forecast prepared by the Department of Management and Budget indicates the County will end 1990 with a Governmental Funds balance estimated at $1,669,763 (revenue favorablity of $1,003,134 and expenditure favorablity of $666,629); and WHEREAS the Third Quarter Forecast estimates favorable revenue variances for Investment Income and State Income Tax partially offset by unrealized revenues for the Sheriff's Department and Drain Commissioner; and WHEREAS the Third Quarter Forecast estimates favorable expenditure variance for Health Division, INS/Administration, Private Institutions, Equalization and Accounting Division partially offset by unfavorable variance for expenditures in Sheriff's Department, Social Services Hospitalization, Circuit Court, and Children's Village; and WHEREAS the 1990 General Appropriations Act, Section 16, states that expenses will be controlled within the categories of Salaries and Fringe Benefits, Overtime, and Operating, and at no time shall the net expenditures exceed the total appropriations for such categories; and WHEREAS certain department budgets are projected to be within budget appropriation at year-end but not within control category appropriation, thus requiring a transfer of funds between categories in order to comply with the General Appropriations Act (see Attachment A); and WHEREAS certain departments are expected to be overbudget at year end for expenditures and have requested additional funding as indicated on attachment 'A' as follows: Circuit Court Public Information Circuit Court Probation Non-Dept. Insurance Non-Dept. Area Wide Water Quality Non-Dept. Michigan Association of Counties WHEREAS District Court Division I (Walled Lake) has favorable revenues to offset increased expenditures and proposes to amend both revenue and expenditure budgets by $81,500 per attachment 'A'; and ( WHEREAS revenue for Community Mental Health is unfavorable due to program reduction and is more than offset by expenditure favorability; and WHEREAS unfavorable expenditures for Medical Care Facility are partially offset by favorable revenues for Medical Care Facility due to accounting change in the occupational therapy services contract; and WHEREAS actual usage of Computer Sevices-Operations varies from budget Attachment 'B' proposes to adjust Budgets accordingly. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners approves amendments to the 1990 Budget per attachment 'A' and attachment Mr. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE NF7/oc9052mr Resolution # 90286 December 13, 1990 . Moved by Caddell supported by Pappageorge the resolution be adopted. AYES: Huntoon. Jensen, Johnson, R. Kuhn, Law, Luxon, McConnell, McCulloch, McPherson, Moffitt, Oaks, Olsen, Pappageorge, Pernick, Price, Rewold, Skarritt, Aaron, Caddell, Calandro, Chester, Crake, Ferrens. (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 December 13_1990 with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set py hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 13th dayA) _J)ecember, 199.0_ Lynn- D. AlTei-T, County Clerk COUNTY OF OAKLAND THIRD QUARTER REPORT - SUMMARY STATEMENT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL, SPECIAL REVENUE 6 PROPRIETARY FUNDS FOR THE YEAR ENDED DECEMBER 31, 1950 BUDGET BUDGET TOTAL AMOUNT AS AS REVENUE/ FAVORABLE/ ADOPTED ADJUSTED EXPENDITURE (UNFAV) PERCENT REVENUE GOVERNMENTAL FUNDS SPECIAL REVENUE AND PROPRIETARY FUNDS TOTAL REVENUE EXPENDITURES GOVERNMENTAL FUNDS SPECIAL REVENUE AND PROPRIETARY FONDS EXCESS REVENUES OVER/ (UNDER) EXPENDITURES GOVERNMENTAL FUNDS SPECIAL REVENUE AND PROPRIETARY FUNDS TOTAL EXCESS REVENUES OVER/ (UNDER) EXPENDITURES $218,852,821 $223,925,440 $224,928,574 $1,003,134 0.4% 77,624,969 78,545,753 78,411,353 (134,400) -0,2% $296,477,790 $302,471,193 $303,339,927 . $868,734 0.2% $218,852,821 $223,925,440 $223,258,811 $666,629 0.3% 77,624,969 78,545,753 78,411,353 134,400 0.2% , $296,477,790 $302,471,193 $301,670,164 $801,029 0.3% $1,669,763 0.7% $1,669,763 0fl6% -n TOTAL EXPENDITURES BUDGETTHREE:MSUMMARYFOR PREPARED BY BUDGET DIVISION 11/05/90 PROPERTY TAXES 1990 TAX LEVY LESS: ALLOWANCE FOR TIEN ALLOWANCE FOR LDFA DELINQUENT TAXES TAX TRIBUNAL APPEALS NET CURRENT PROPERTY TAY OTHER TAXES -.:.. DELINQUENT TAXES PRIOR YEARS s TRAILER TAX $577,000 $577,000 $500,810 8(77,100) -13.3% 88,000 88,000 88,000 22,600 3.3% -INCREASED CASELOADS (12,800) -58.7% -EPA GRANT WAS TO PP A PASS-THROUGH BUT WILL BE PAID nIRECTLY TO 55,000 32,201 47,500 46,000 14,000 654,714 162,750 129,941 628,625 21,800 55,000 32,200 47,500 46,000 14,000 654,714 162,750 129,941 699,994 9,000 55,000 32,210 47,500 46,000 14,000 654,714 162,750 129,911 677,394 21,800 MINTY no OAKLAND 1990 THIRD 171 FT 11100.35 P. REVENULS MIDGET BUDGET 1990 AIOUNT AS AS REVENUE FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT $108,533,618 8100,533,613 $108,533,618 (1,153,500) (1,131,001) (1,150,950) (20,950) 1.9% (23,501) (23,613) (113) 0.5% (825,100) (825,000) (680,700) 144,300 -17,51 (150,000) (150,000) (150,000) $106,405,118 $106,405,118 $106,523,355 $123,237 0.1% EXPLANATION OF MAJOR VARIANCES TOTAL OTHER TAXES $665,000 $665,000 $588,000 8(77,000) -11,6% TOTAL PROPERTY AND OTHER TAXES $107,270,118 $107,070,118 $107,116,355 $46,237 0.0% BUDGETED RECEIPTS-GENERAL FUND STATE AND FEDERAL CULTURAL COUNCIL GRANTS CIRCUIT JUDGES SALARIES PROBATE JUDGES SALARIES DISTRICT JUDGES SALARIES MARINE SAFETY STATE INCOME TAX STATE RENE. - P,A. 228 CONVENTION FAC TAX-PA106/7 CIGARETTE TAX DISTRIBUTION STATE INSTITUTIONS INDIRECT COST RECOVERY $14,200 $14,200 $6,000 491,000 491,000 491,000 334,800 334,810 334,801 364,780 364,700 364,700 180,000 180,000 197,047 12,877,081 12,877,000 13,082,000 2,213,700 2,213,720 2,213,700 785,120 285,100 748,400 2,238,600 2,238,600 2,274,900 2,000 2,000 2,000 301,500 301,500 301,500 $(8,200) -57,7% - GRANT. AWARD LESS THAN BUDGET 17,347 7.1% -REIMBURSEMENT FOR CERTIFICATION OF ADDITIONAL STUDENTS IN MARINE SAFETY EDUCATION PROGRAM 205,000 1.6% -PER THE STATE OF MICHIGAN'S ESTIMATE (36,700) -12.9% -DECREASE 181 CROSS RECEIPTS 36,300 1.6% -REVISED STATE ESTIMATE ON CIGARETTE SALES $19,302,600 $19,302,600 $19,511,847 8209,247 1.1% CHARGES FOR SERVICES AUDITING CULTURAL AFFAIRS ECONOMIC DEVELOPMENT ACCOUNTING MATERIALS MGT-COUNTY AUCTION EQUALIZATION REIMBURSEMENT SAFETY DIVISION PROBATION - DISTRICT COURT COOPERATIVE EXTENSION AMOUNT FAvoRABLE/ EXPLANATION (UNFAVORABLE) PERCENT OF MAJOR VARIANCES BUDGET AS ADJUSTED 1990 REVENUE FORECAST BUDGET AS ADOPTED FACILITIES ENGINEERING SOLID WASTE PUBLIC WORKS - ADMIN. PLANNING EMPLOYEE RELATIONS MEDICAL EXAMINER PUBLIC SERVICES CLERK/REGISTER OF DEEDS TREASURER CIRCUIT COURT FRIEND OF THE COURT DIVISION I (WALLED LAKE) DIVISION II (cLARKSTON) DIVISION III (Rod. HILLS) DIVISION IV (TROY) BOARD OF COMMISSIONERS LIBRARY BOARD DRAIN COMMISSIONER 15,000 15,001 18,000 49,000 49,615 185,215 74,750 74,750 74,750 190,400 190,000 155,000 7,801 7,800 7,800 70,600 24,600 26,100 14,500 14,501 9,300 7,300,000 7,300,000 7,613,900 $2,182,877 18,600 4,096,175 22,1.'7 445 $2,238,377 16,000 4,096,125 22,756,945 82,238,377 16,000 4,096,125 24,540,273 $(55,500) -2.5% -DUE TO ANTICIPATED DNDEREXPENDITURES IN THE HEALTH DIV. 2,600 16,3% -REVENUE FROM THIRD QUARTER 1981 FROM STATE (614,510) -2.7% -REDUCED STATE MATCH, CoRRESPONDING REDUCTION IN EXPENDITURES HEALTH- STATE SUBSIDY DISASTER CONTROL CHILD CARE SUMIDY COMMUNITY MENTAL HEALTH COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST REVENUES PROBATE COURT PROSECUTING ATTORNEY SHERIFF HSU FOR EPA WASTE REDUCTION PROJECT. NOTE: FAVORABLE EXPENSES 3,000 20.0% -SALE OF ADDITION BID SPECIFICATIONS 135,600 273,31 -PRIOR YEAR REVENUE FROM THE STATE FOR IMPLEMENTATION OF WASTE - TO ENERGY FACILITY, FOR EXPENSES RECOVERABLE FROM THE SALE OF BONDS (35,000) -18.4% -LOWER HAP SALES 5,500 26,7% -INCREASED DEMAND FOR REPORTS, ETC. (5,200) -35,9% -BASED ON LESS ACTUAL HOURS SPENT FOR EMPLOYMENT & TRAINING AWN 313,900 4,3% -FAVORABLE 250,000 FORFEITURE OF BOND; 56,800 REIMBURSEMENT FROM„ STATE FOR PRIOR 7BA:S SPECIAL ELECTION; 45,100 VARIOUS CLERK PEES PARTIALLY OFFSET BY (32,000) UNFAVORABLE REGISTER OF DEEDS REVENUE. Fol..FEtTE6E OF BONDS FAVORAELE DUE TO EFFORT BY CIRCUIT CODEI 2,162,384 2,162,324 2,312,484 150,111 6,9% -FAVORABLE 73310 EM MAY TAX SALE: 30,010 FOR COLLECTION FEES; 25,050 FOR INHERITANCE TAX; 15,000 FOR TAX STATEMENTS; 7,300 FOR 1,725,270 1,948,476 1,948,476 TAX REVERTED LAND; 4,500 FOR ELECTION FILING FEES RESULTING FROM 5,697,498 5,697,498 5,697,498 A LAW CHANGE; PARTIALLY OFFSET BY UNFAVORABLE TIFA/DDA RECOVERY 1,186,000 1,753,236 1,457,436 204,200 16,3% -INCREASE IN CASELOAD AND ACTIVITY 600,000 600,110 663,510 63,500 10.61 -INCREASE IN ACTIVITY 1,431,593 1,431,593 1,550,993 119,400 8.3% -INCREASE 18 ACTIVITY 1,303,730 1,303,733 1,236,980 (66 ,750 ) -5,1% -BUDGET INCLUDES INCREASE FOR ADDITIONAL MAGISTRATE HOURS WHICH WERE NOT APPROVED; ORDINANCE COSTS AND FINES ARE DOWN DUE TO REDUCTION IN TRAFFIC TICKETS ISSUED BY TROY POLICE DEPT. EXPECTED TO RETURN TO NORMAL IN 1911. -1,4% -LOWER BOARD & CARE FOR OUTSIDE-COUNTY PRISONER HOUSING DUE TO HIGHER THAN EXPECTED JAIL POPULATION; AND LOWER THAN ANTICIPATED CONFISCATED PROPERTY REVENUE FROM N.E.T,; PARTIALLY OFFSET BY HIGHER REVENUE PON DIVERTED OFFENDER HOORAH AND REIMBURSEMENT FOR OVERTIME WORKED FOR MINI CONTRACTS AND PATROL SERVICES CONTRACTS, (NOTE: SHERIFF'S REVENUE BUDGET HAS BEEN AMENDED BY 3155,369 FOR NEW SERGEANT LAW ENFORCENENT PATROL SERVICES 20,500 20,500 20,500 CONTRACTS FOR OAKLAND AND BRANDON TOWNSHIPS AND PATROL 77,402 77,402 77,402 INVESTIGATOR CONTRACTS FOR INDEPENDENCE AND HIGHLAND TOWNSUIPS,) 1,926,669 2,061,074 1,991,174 (72,900) -3,5% -UNFAVORABLE REIMBURSEMENT FOR SALARIES (7,500) THROUGH THIRD QUARTER DUE TO TURNOVER (OFFSET BY FAVORABLE SALARIES EXPEND- 766,962 766,962 766,962 92,000 101,360 101,360 10,644,867 10,127,265 10,574,665 (152,600) 37,099,055 37,667,044 38,339,594 BUDGETED RECEIPTS - OTHER GOVT FUNDS STATE AND FEDERAL 672,550 1,8% ITURES); (67,000) SOIL EROSION FEES; PENDING: ADDITIONAL REVENUE FROM REIMBURSEMENT FOR OVERTIME; FAVORABLE 1,600 IN MISCELLANEOUS FEES AMOUNT FAVORABLE/ EXPLANATION (UNFAVORABLE) PERCENT OF MAJOR VARIANCES BUDGET AS ADJUSTED 1990 REVENUE FORECAST BUDGET AS ADOPTED 44,100 44,000 COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST REVENUES SOCIAL SERVICES- ROST, CARE 44,000 $30,934,775 $29,151,441 $28,184,047 1(667,400) -2,31 CHARGES FOR SERVICES FRIEND OF TUE COURT HEALTH EMERGENCY MEDICAL SERVICE ANIMAL CONTROL LAND SALES CHILDREN'S VILLAGE SOCIAL SERVICES-HOSP. JUVENILE MAINTENANCE MEDICAL CARE FACILITY MISCELLANEOUS REVENUE INVESTMENT INCOME BUDGETED PROJECTS SUNDRY $438,500 $138,500 $438,500 1,484,960 1,522,680 1,597,680 183,750 181,750 183,750 661,902 661,802 661,802 2,253 2,253 2,253 2,009,914 1,741,844 1,122,344 - 4,000 4,000 3,000 702,264 702,264 679,264 4,518,800 4,518,802 4,737,900 110,016,273 89,783,813 $10,026,393 $11,420,000 $11,470,010 $11,970,000 470,000 586,000 596,700 350,000 350,010 350,000 75,000 4,9% -INCREASED LABORATORY CHARGE, FOOD SERVICE LICENSES, FOOD PLAN REVIEWS & CANCER DETECTION REIMBURSEMENT (27,500) -1.6% -REDUCED STATE AID DUE TO LOWER ELEMENTARY POPULATION (1,000) -25,0% -REDUCED REIMBURSEMENT FROM RECEPIENTS (23,000) -3,3% -REDUCED GOVERNMENTAL BOARD 6 CARE REIMBURSEMENT 219,000 4.8% -INCREASED DAILY PATIENT REVENUE PARTIALLY DUE TO ACCOUNTING CHANGE,(NOTE INCREASED EXPENSES) 6 PRIOR YEARS REVENUE FROM 2.5% MEDICAID AUDIT 8500,000 4,4% -INCREASED VOLUME OF INVESTABLE FUNDS $242,500 812,210,000 $12,356,000 $12,856,000 $510,000 RESOURCES CARRIED FORWARD PRIOR YEAR'S BALANCE TOTAL AVAILABLE RESOURCES GOVERNMENTAL FUNDS SPECIAL REVENUE AND PROPRIETARY FUNDS PROPERTY TAX PARKS AND RECREATION INTERGOVERNMENTAL REVENUE COMM, DEV, BLOCK GRANT COMM. DER, ENER, SHELTER COMM. DEV, RENTAL REHAB, $2,200,000 $8,594,318 $8,594,338 $218,852,821 $223,125,440 $224,928,574 11,003,134 $5,170,000 $5,170,000 $5,267,000 $97,000 1.9% -BUDGET BASED ON ESTIMATED SEV $8,959,101 $8,959,101 $8,959,101 51,000 51,000 51,000 324,781 324,781 324,781 BUDGET AS ADJUSTED BUDGET AS ADOPTED - 54,760 274,166 1,204,797 245,448 54,760 274,166 1,204,797 245,448 172,200 131,922 42,200 247,500 146,122 42,200 172,200 131,922 42,200 COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST REVENUES 1990 AMOUNT REVENUE FAVORABLE/ EXPLANATION FORECAST (UNFAVORABLE) PERCENT OF MAJOR VARIANCES PROBATION ENHANCEMENT PROBATION DISCRETIONARY HEALTH-TAKILY PLANNING HEALTH-11CH BLOCK GRANT HEALTH-WIC HEALTH-S.I.D.S. GRANT . HEALTH-M.D.P.H.O,S.A.S. HEALTH-INFANT HEALTH FROG. HEALTH-HYPERTENSION HEALTH-E.P.S.D,T, HEALTH-INFANT HEALTH MO HEALTH-T. B. OUTREACH GRANT HEALTH-PRENATAL COORD. HEALTH-111.0.'1,H,I.P. PROSECUTOR-COOP. REIM, SECONDARY ROAD PATROL JOBS TRAINING PARTNERSHIP ACT SKILLMAN TRUST SMALL BUSINESS CENTER AREA DEVELOPMENT OFFICE AUTO THEFT PREVENTION-SHERIFF AUTO THEFT PREVENTION-PROSECU AIDS TESTING PROGRAM PROSECUTOR-ANTI DRUG SHERIFF- ANTI DRUG CMH-HOMELESS ASSIST CMH-ADOPTIVE SERVICES MICHIGAN BICYCLE HELMET PROBATION COMM CORRECTIONS HIV SURVEY GRANT VETERANS TRUST 67,000 96,000 374,561 151,270 696,665 8,000 2,529,898 232,973 85,571 910,507 249,825 38,609 81,692 111,255 916,119 766,448 6,605,549 162,000 118,550 113,150 761,942 149,703 271,541 172,158 69,378 174,491 33,769 34,346 319,645 67,000 96,000 374,561 151,270 696,665 8,000 3,461,222 232,973 85,571 910,507 249,825 37,252 81,692 111,255 982,456 766,448 6,605,549 162,000 105,000 96,000 661,696 155,140 211,978 172,170 64,331 236,666 33,769 12,412 40,000 34,346 319,645 67,000 96,000 374,561 151,270 696,665 8,000 3,461,227 232,973 85,571 910,507 249,375 37,252 81,692 111,255 932,456 166,148 6,605,549 162,000 105,400 96,000 661,696 155,140 211,971 172,170 64,331 216,666 33,769 12,412 40,000 34,346 319,645 -GRANT ENDED 6/30/90, TOTAL INTERGOVT'L REVENUE CHARGES FOR SERVICES PARKS & RECREATION SOLID HASTE LIBRARY BOARD *TELEPHONE COMMUNICATIONS *MAINTENANCE & OPERATIONS *MARKETS *LEASED VEHICLE OPERATIONS *MICROFILM A REPRODUCTIONS *PRINT SHOP $25,637,497 826,558,281 $26,558,281 $4,569,040 $4,569,040 $1,617,210 848,700 1,1% -REVENUE FROM OPERATIONS- COLT AND PARTS 100,000 36.51 -INCREASED REVENUE FROM PAY PHONE SALES PER REVISED CONTRACT 40,00 3,3% -INCREASED CONTRACTED SERVICES FOR MAINTENANCE AND CUSTODIAL 239,448 (6,000) -2.4% -BUDGET INCLUDES INTERNAL SOURCE REVENUE, OUTSIDE REVENUE IS EXPECTED TO BE FAVORABLE 75,300 43,75 -CAIN ON SALE OF VEHICLES 14,200 10,8% -INCREASED SERVICE TO TITLE COMPANIES . 4 54,760 374,166 1,244,797 BUDGET AS ADJUSTED 1990 REVENUE FORECAST AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT EXPLANATION OF MAJOR VARIANCES BUDGET AS ADOPTED *COMPUTER SERVICES TOTAL CHARGES FOR SERVICES $48,817,472 $46,817,472 $46,586,172 $(231,400)- -0,5% TOTAL-SPECIAL REVENUE AND PROPRIETARY FUNDS GRAND TOTAL RESOURCES AVAILABLE -ALL FUNDS $296,477,790 $302,471,193 $303,339,927 $868,734 0.3% *INTERNAL SERVICE FUNDS - REVENUE FROM OUTSIDE SOURCES PREPARED BY BUDGET DIVISION NOVEMBER 5, 1990 *RADIO COMMUNICATIONS FOOD SERVICES COMMISSARY FUND *EQUIPMENT FUND *MATERIALS MANAGEMENT AVIATION WATER 6 SEWER *WATER 6 SEWER EQUIPMENT FUND DRAIN COMMISSIONER $77,624,969 $78,545,753 $72,411,353 $(134,400) -0,2% 7,750 7,750 4,750 (3,001) -38,71 -REDUCED REPAIR SERVICES TO TOWNSHIPS 264,912 264,912 254,512 (10,101) -3.99 -REDUCED SALES 243,087 243,087 270,587 27,500 11.3% -INCREASED SALES TO INMATES 3,300 3,300 3,300 211,980 211,980 222,180 10,200 4.8% -INCREASED SALES TO CAMP OAKLAND 1,815,951 1,815,951 1,843,051 27,100 1.5% -INCREASED REVENUES FOR LAND LEASE AND RESTAURANT CONCESSION 19,402,009 19,408,009 19,408,009 540,000 540,001 -REVENUE FROM WATER SEWER TRUST FUNDS FOR EQUIPMENT RENTAL 17,078,889 17,078,889 15,895,889 (1,183,000) -6,9% -LOWER THAN ESTIMATED POLLUTION CONTROL A SEWAGE DISPOSAL SERVICE FEES 1,089,061 1,089,061 1,177,061 88,000 8.1% -INCREASED OUTSIDE AGENCIES AND DEFERRED LAND FILE TAX BILLS COUNTY OF OAKLAND 1991 THIRD QUARTER FORECAST REVENUES FORECAST BUDGET AS ADJUSTED 1990 AMOUNT EXPENDITURE FAVORABLE/ FORECAST (UNFAVORABLE) PERCENT EXPLANATION BUDGET AS ADOPTED 991,966 1,772,008 1,391,455 12,300 8,300 4,040 806,266 1,780,308 1,395,455 762,807 1,692,497 1,353,307 1.5% 0.5% 0,3% -INCREASE IN DEFENSE ATTORNEY FEES DOE TO CASELOAD INCREASE, OFFSET ED A DECREASE IN PROFESSIONAL SERVICES USAGE DIVISION II (CLARKSTON) DIV III (ROCHESTER HILLS) E DIVISION IV (TROY) PROBATE COURT TOTAL ADMIN. OF JUSTICE PROSECUTING ATTORNEY SHERIFF TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT CLERK/REGISTER OF DEED COUNTY TREASURER BOARD OF COMMISSIONERS LIBRARY BOARD DRAIN COMMISSIONER COUNTY OF OAELAND 1990 THIRD QUARTER FORECAST EXPENDITURES DEPARTMENTS 6 INSTITUTIONS ADMINISTRATION OF JUSTICE CIRCUIT COURT ADMINISTRATION FRIEND OF THE COURT DISTRICT COURT DIVISION I (WALLED LAKE) $8,760,878 $9,103,434 $9,431,734 $(328,300) -3,6% -UNFAVORABLE DEFENSE ATTORNEY FEES (300,000) DUE TO APPOINTMENT INCREASE AND EXTRAORDINARY FEES; TRANSCRIPTS ON APPEALS (140,000) DUE TO INCREASE IN APPELLATE CASELOAD, PROFESSEMNAL SERVICES (30,000) DUE TO EXTRAORDINARY CASES, VISITING JUDGES (10,000) 6 SUBSTITUTE COURT REPORTERS (10,001), PARTIALLY OFFSET BY TURNOVER FAVORABILITY 51,700 AND 78,000 OTHER 5,433,169 5,489,294 5,408,994 80,300 1,5% -TURNOVER FAVORABLE 82,204 A INDIRECT COST FAVORABLE 6,670 DUE TO TURNOVER; PARTIALLY OFFSET BY OVERTIME OF COURT SERVICE OFFICERS . $14,194,047 $14,592,728 $14,840,728 $(248,010) -1,7% UNFAVORABLE (6,350) 6 PROFESSIONAL SERVICES UNFAVORABLE (2,250) DUE TO FULL IMPLEMENTATION OF CREDIT CHECK PROGRAM $1 ,50 3 (005 $1,576,522 $1,658,022 0(81,500) -5.2% -INCREASE IN OVERTIME USAGE 6 DEFENSE ATTORNEY FEES DUE TO BACK- LOG A INCREASE IN CRIMINAL CASES $5,311,616 $5,558,551 $5,615,451 $(56,900) -1.0% $15,510,265 $15,620,122 $15,620,122 -TURNOVER FAVORABLE 65,500 OVERTIME PAM 2,011; OPERATING (67,500) UNFAV DUE TO INCREASED STATE INSTITUTIONS COST RELATED $35,015,928 $35,771,401 $36,076,301 $(304,930) -0,9% TO JUVENILE WAIVERS $7,929,019 $8,063,153 $7,973,853 $89,300 1.1% -TURNOVER 231,100 FAVORABLE; OVERTIME (40,610) UNFAVORABLE DUE TO INCREASED CASELOAD; UNFAVORABLE FOR EXTRADITIONS (70,040 DUE TO INCREASED NUMBER A HIGHER AIRFARE; AND INCREASED COPIER USAGE PARTIALLY OFFSET BY FAVORABILITY IN OUTSIDE PRINTING 42,515,153 43,018,440 43,726,540 (708,110) -1.6% -TURNOVER 655,710 FAVORABLE; OVERTIME (953,600) UNFAVORABLE FOR COVERAGE DUE TO TRAINING, COURT TIME, HOSPITAL WATCHES A IN- $50,444,172 $51,081,593 $51,700,393 $(618,800) -1,2% CREASED TWP, CONTRACT ACTIVITY; (rTE: REIMBURSEMENT FOR OVERTIME IS FAVORABLE 190,300); OPERATING (410,200) UNFAVORABLE FOR PROVISIONS (193,501), HOUSEKEEPING SUPPLIES (50 ,000), RADIO ComMURICATIoNs (39,200), LEASED ,'15,000) AND EQUIPMENT REPAIR (25,000) $5,642,102 $5,741,616 $5,658,316 $83,300 1.5% -TURNOVER FAR 105,942 & OPERATING FAV 8,010 PARTIALLY OFFSET BY OVERTIME (30,601) FOR REGISTER OF DEEDS AND LEGAL RECORDS FOR COURT FILES 2,265,335 2,324,551 2,283,251 41,300 1.8% -TURNOVER 1,812,138 1,887,922 1,848,922 39,000 2.1% -TURNOVER FAV 45,500 & 6,100 FAV PERSONAL MILEAGE, PRINT SHOP, STATIONERY SUPPLIES, .5 LEASED VEHICLES PARTIALLY OFFSET BY uNFAV TRAVEL A CONFERENCE (10,000) & COPIER (2,600) 1,209,024 1,212,710 1,206,110 6,600 0.5% -TURNOVER 3,660,936 3,837,748 3,761,748 76,000 2,0% -TURNOVER FAVORABILITY 209,100 OFFSET BY OVERTIME UNFAVORABILITY (117,900) DUE TO INCREASED NUMBER OF RECOVERABLE PROJECTS AND COUNTY EXECUTIVE ADMINISTRATION AUDITING $917,875 $917,875 542,949 555,737 535,737 20,000 3.6% -TURNOVER $905,320 85,418 94,384 1,084,794 75,822 151,669 86,408 96,984 1,054,694 75,822 151,669 80,878 94,384 1,071,021 75,822 138,143 (1,000) -1.2% -TRAVEL AND CONFERENCE & PHOTOGRAPHIC SUPPLIES (2,600 -2,8% -PRINTING COSTS OF COUNTY NEWSLETTER 30,100 2.8% -FAURABLE SALARIES & FRINGES 10,000 FOR TURNOVER, OPERATING FAVORABLE FOR LEGAL EXPENSES 21,004 COMM A MINORITY AFFAIRS PUBLIC INFORMATION CORPORATION COUNSEL STATE 5 FEDERAL AID COOED, CULTURAL AFFAIRS COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST EXPENDITURES BUDGET BUDGET 1990 AMOUNT AS AS EXPENDITURE FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION TOTAL GENERAL GOVERNMENT . $14,589,535 $15,004,547 $14,758,347 $246,200 1,6% (15,200) UNFAVORABLE OPERATING DUE TO DRAIN EQUIPMENT CHARGES TO GENERAL FUND, POSTAGE, COPIER, ENGINEERING SUPPLIES, STATIONERY SOLID WASTE SERVICES AND PRINTING ADMINISTRATION $167,865 $2,972,190 $2,972,190 $2,908,517 $2,965,689 $2,919,189 $46,500 1.6% MANAGEMENT 5 BUDGET ADMINISTRATION BUDGET DIVISION ACCOUNTING DIVISION PURCHASING DIVISION EQUALIZATION DIVISION REIMBURSEMENT DIVISION CENTRAL SERVICES ADMINISTRATION SAFETY DIVISION MATERIALS MANAGEMENT $218,590 $218,590 $218,590 795,213 837,239 031,939 5,400 0.6% -TURNOVER FAVORABLE 6,410, OFFSET BY INCREASED USAGE OF OVERTIME FOR 1991 BUDGET PREPARATION 4,805,410 4,905,263 4,775,663 129,609 2.6% -TURNOVER FAY 126,400 AS WELL AS PAY INDIRECT COSTS 13,790 DUE TO A PERCENTAGE. RATE DEDUCTION AND SAVINGS IN PRINTING 4,900, OFFSET BY INCREASED POSTAGE USAGE (7,500) IN ALIMONY AND BANK CHARGES (10,540) DUE TO LOWER INTEREST RATES 524,636 571,695 540,895 30,800 5.4% -TURNOVER 3,380,659 3,644,082 3,486,982 157,100 4.3% -TURNOVER FAVORABLE 150,900 OFFSET BY UNFAVORABLE OVERTIME (1,900) DUE TO 1990 LOCAL APPORTIONMENT PREPARATION 953,170 1,047,167 1,055,667 (8,500) -0,81 -OVERTIME UNFAVORABLE DUE TO INPUT BACK LOG ON NEW COMPUTER SYSTEM $10,677,668 $11,224,036 $10,909,636 $114,400 2.8% $734,785 $748,753 $751,653 $(2,900) -0.1% -1NREASED RATES FOR MAILROOM LEASED VEHICLES 1,513,742 1,524,400 1,524,100 177,750 183,157 177,757 5,400 2.9% -APPRAISAL SERVICES LESS THAN EXPECTED $2,426,277 $2,456,310 $2,453,810 $2,500 0,1% PUBLIC WORKS ADMINISTRATION $354,299 $368,076 5365,076 $3,000 0,8% -TURNOVER PARTIALLY OFFSET BY MICROFILM EXPENSES FACILITIES ENGINEERING DIV 1,077,429 1,103,170 1,947,170 56,000 5.1% -TURNOVER PARTIALLY OFFSET BY OVERTIME USED TO INSPECT CONSTRUCTION OF COMPUTER CENTER RHO OTHER PROJECTS WATER & SEWER OPERATIONS 56,980 71,980 (15,000) -26.3% -ADDITIONAL COST TO PURCHASE TRUCK AND CRANE APPROVED PER MR 190155 $1,431,728 $1,528,226 $1,484,226 $44,000 2.9% PERSONNEL ADMINISTRATION EMPLOYEE RELATIONS HUMAN RESOURCES $213,525 1,211,112 1,191,392 $254,286 1,228,191 1,262,261 $254,986 1,225,191 1,256,761 INSTITUTIONAL & HUMAN SER, ADMINISTRATION HEALTH DIVISION MEDICAL CARE FACILITY COMMUNITY MENTAL HEALTH HUMAN SERVICES AGENCY SOCIAL SERVICES MEDICAL EXAMINER PUBLIC SERVICES ADMINISTRATION VETERANS SERVICES DISTRICT COURT PROBATION COOPERATIVE EXTENSION EMS A DISASTER CONTROL COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST EXPENDITURES BUDGET BUDGET 1990 AMOUNT AS AS EXPENDITURE FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION -0.3% -COPIER FUND AND COMMUNICATIONS 5,501 0.41 -TURNOVER FAVORABLE $5,501; FAVORABLE IN-SERVICE TRAINING OFFSET BY TUITION REIMBURSEMENT. A REQUEST FOR INTERN $(7 00 $2,616,029 $2,744,738 $2,739,931 $4,200 0.2% PROGRAM OF (15,010) FOR ADDITIONAL BUDGETED HOURS TO RE FUNDED BY EMERGENCY SALARIES AND RATE & CLASSIFICATION EXPENSES. A BUDGET AMENDMENT IS REQUESTED. CHILDREN'S VILLAGE ANIMAL CONTROL $1,804,054 $1,864,774 $1,669,374 $195,410 11.5% -PRIVATE INSTITUTION FAV, DUE TO CAMP OAKLAND WORK ED PROGRAM . 18,454,359 11,916,152 18,194,452 711,700 3,8% -FAVORABLE TURNOVER 682,800 & OVERTIME 4,411; OPERATING FAVORABLE 24,500 DUE TO PROFESSIONAL SEAR., PERSONAL MILEAGE & MED SUPPLY 6,476,735 6,546,343 6,788,543 (242,211) -3,7% -TURNOVER 200,000 FAVORABLE; OVERTIME (61,000)UNFAV DUE TO NURSING SHORTAGE; OPERATING (381,281) UNFAV DUE TO PROFESS- IONAL SERVICES OCCUPATIONAL THERAPY (DUE TO ACCOUNTING CHANGE), NURSING CONTRACT & MEDICAL SUPPLIES (NOTE OFFSETTING INCREASED REVENUE) 9,551,301 9,873,200 10,132,200 (259,810) -2.6% -TURNOVER 125,000 FAVORABLE; OVERTIME UNFAVORABLE (95,000) DUE TO TURNOVER ON 24-HOUR OPERATION; OPERATING UNFAVORABLE (289,000) DUE TO INCREASED PROFESSIONAL SERVICES, (15,310) CENTRAL SERVICES (12,000) I, PRIOR YEARS WATERFORD SCHOOLS CONTRACT SETTLEMENT (261,313) 32,020,056 30,258,449 29,265,549 992,901 3,3% -TURNOVER 991,301 FAVORABLE DUE TO VACANCIES NOT BEING FILLED; 717,453 717,453 717,453 OVERTIME (8,000) UNFAV OPERATING 9,601 FAN DUE TO UNDER EXPENDITURE IN APPROPRIATION CONTINGENCY PARTIALLY OFFSET BY NIGHER CONTRACTED EXPENDITURES 3,420,653 3,420,653 4,256,453 (835.800) -24,4% -EFFECT OF INDIGENT HOSPITALIZATION COST PRIOR TO 4/1/91 COST CHANGE, SINCE 4/1/90 COST PER DAY HAS BEEN REDUCED 16% 1,400,178 1,406,304 1,353,704 52,600 3,7% -TURNOVER FAVORABLE 39,201; OPERATING 13,480 FAVORABLE DUE TO DEPUTY MEDICAL EXAMINER CONTRACT, PARTIALLY OFFSET BY INCREASED 673,144,789 $72,993,327 $72,377,727 $615,600 0,8% USE OF ON-CALL PHYSICIANS $116,752 $116,752 $116,752 1,221,451 1,226,914 1,179,614 47,300 3,9% -TURNOVER FAVORABLE 22,600; SOLDIER BURIAL FAV 24,700 DUE TO LOVER DEATH RATE 918,767 982,452 963,752 11,700 1.9% -TURN(VER HAM 29,708 OFFSET BY UNFAV OVERTIME (11,001) DUE TO INCREASED CASELOAD I, BACKLOG 604,225 636,821 627,521 9,000 1.4% -TURNOVER FAR 2,981; PROFESSIONAL SVCS, PAM AS EXTENSION AGENT POSITION WAS FILLED LATE. NOTE: OFFSETTING UNFAVORABLE REVENUES 852,570 906,209 907,209 (1,100) -0,11 -TURNOVER FAD 5,218 OFFSET BY EQUIP. RENTA.. (WU (3,120) DUE TO ADDITION OF VCR, MONITOR, AND VIDEO CPFRA IN EQUIPMENT FUND AND INCREASED POSTAGE USAGE (1 0 100) FC. :N.T7ASED MAILINGS OF TORNADO WARNING PAMENLETS 1,306,942 1,347,926 1,365,726 (17,500) -1.3% -TURNOVER FAV 8,300, OFFSET BY URFAV OVNTHE (14,700) AS ANTICI- 1990 AMOUNT EXPENDITURE FAVORABLE/ FORECAST (UNFAVORABLE) PERCENT EXPLANATION BUDGET AS ADJUSTED BUDGET AS ADOPTED COMMUNITY & ECONOMIC DEVELOPMENT ADMINISTRATION ECONOMIC DEVELOPMENT PLANNING DIVISION $193,061 1,010,579 1,203,405 $193,061 1,024,705 1,290,309 $193,063 1,024,705 1,247,209 3.3% -TURNOVER 43,100 TOTAL COUNTY EXECUTIVE TOTAL DEPT. & INSTITUTIONS $10,000 $380,000 3,168,638 41,800 67,000 100,000 766,438 685,677 1,933,184 263,800 41,000 14,441 32,725 15,000 3,000 15,500 49,500 25,000 35,750 1,000 1,000 9,200 1,000 $10,000 $380,000 2,980,338 41,800 72,000 100,000 766,430 685,677 1,930,184 264,800 43,675 14,441 67,821 15,000 1,000 15,500 49,500 25,000 35,750 1,000 1,000 9,200 1,000 $10,000 $380,000 3,418,638 41,800 67,000 100,000 383,219 685,677 2,154,971 263,800 41,000 14,441 32,725 15,000 3,000 15,500 49,500 25,000 35,750 1,0 1,000 9,200 1,000 NON-DEPT. APPROPRIATIONS AMBULANCE BUDGETED PROJECTS BUILDING AUTHORITY DISTRICT COURT WITNESS FEES INSURANCE I. SURETY BONDS YOUTH ACTIVITY CENTER ECONOMIC DEVELOPMENT CURRENT DRAIN ASSESSMENT COUNTY BUILDINGS COUNCIL OF GOVERNMENTS AREA WIDE WATER QUALITY BD NATIONAL ASSOC.OF COUNTIES MICHIGAN ASsoC.OF COUNTIES SANCTUARY 4-H FAIR PREMIUMS HISTORICAL SOCIETY TOURIST & CONVENTION BUREAU TRAFFIC IMPROVEMENT ASSOC. AREA AGENCY ON AGING CLINTON RIVER WATERSHED HURON RIVER WATERSHED SOIL CONSERVATION ROUGE RIVER WATERSHED 188,300 5.91 -PAYMENTS OFFSET BY INTEREST EARNINGS (5,000) -7,5% -INCREASE IN PROPERTY PREMIUM DUE TO INCREASED VALUATION; A BUDGET ADJUSTMENT IS RECOMMENDED 3,000 1.1% -MEMBERSHIP RASED ON SEV AND LOCAL MEMBERSHIP (2,675) -6.5% -ACTUAL AMOUNT BASED ON SEWAGE FLOWS; A BUDGET ADJUSTMENT IS RECOMMENDED (35,096 ) -107.2% -ACTUAL CHARGE REFLECTS EXPENSES FOR JULY 1909 - JUNE 1991; A BUDGET ADJUSTMENT IS RECOMMENDED FOR THIS ONE-TIME CATCH-UP COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST EXPENDITURES CIRCUIT COURT PRORATION COMPUTER SERVICES FATED REDUCTION IN CALLS HAS NOT OCCURED. ANNUAL CENSUS FEES FAVORABLE 7,000 ;DUE TO LESS USAGE THAN ANTICIPATED. SAVINGS IN DAMAGE BY DOGS 1,600 OFFSET BY UNFAV CHARGES IN LEASED VEHICLES (20,000) DUE TO RATE INCREASE 388,855 396,163 410,163 (14,000) -3.5% -DRUG TESTING COSTS UNFAV (12,000) DUE TO INCREASE CASELOAD AND RATE INCREASE; CONVENIENCE COPIER ENEAV $5,409,562 $5,613,237 $5,571,037 $42,200 0.8% (2,000 ALSO DUE TO CASELOAD INCREASE $4,607,333 $3,701,472 $3,701,172 $2,415,047 $2,508,077 $2,464,977 $43,100 1.7% $106,336,950 $105,735,114 $104,622,014 $1,113,100 1.1% $206,554,450 8210,561,845 $210,129,245 $435,600 , 1.2% 1,000 14,000 258,000 30,000 500,000 1,000,000 5,000 1,000 1,000 14,000 14,000 250,000 250,000 31,000 30,003 21,000 21,000 4,030 4,000 8,746 8,746 500,000 500,000 1,236,243 1,236,243 43,000 43,011 5,000 5,000 2,091,629 2,091,629 5,000 5,000 FRIENDS OF THE ROUGE RIVER 0,C, 4C COUNCIL SUNDRY EMPLOYEE'S DEFERRED COMP. CETA AUDIT LEGAL EXPENSE CETA AUDIT-MISC. EXPENSE MISCELLANEOUS-CAPITAL OUTLAY CAPITAL IMPROVEMENT PROGRAM ROAD IMPROVEMENTS PROJECT WORK ORDERS PURPLE HEART OF U.S.A. SPECIAL CONTINGENCY 'RETIRED SENIORS VOL. FROG, COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST EXPENDITURES BUDGET BUDGET 1990 AMOUNT AS AS EXPENDITURE FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION $9,549,228 $11,867,271 $11,718,742 $148,529 1.3% RESERVED FOR TRANSFERS -., CAPITAL IMPROVEMENT PROGRAM 250,001 250,000 -.. CONTINGENCY 1,407,624 783,235 783,235 - CLASSIFICATION 6 RATE CHANCE 110,000 79,357 4,357 75,000 94.5% -ESTIMATED FUNDS AVAILABLE AFTER APPROVAL OF SALARY ADMIN. - OVERTIME 75,001 41,561 41,561 QUARTERLY REPORTS SUMMER EMPLOYMENT 387,100 16 16 EMERGENCY SALARIES 440,000 122,775 115,275 7,500 6.1% -FUNDS AVAILABLE FOR TRANSFER TO INTERN PROGRAM ADMIN, CONTINGENCY 100,000 50,320 50,320 FEDERAL/STATE PROJECT MATCH 49,519 58,408 38,408 . CAPITAL OUTLAY 180,000 177,651 127,651 . DISABILITY INSURANCE 850,000 850,001 850,000 ' DISABILITY RESERVE (850,000) (850,000) (850,000) $2,749,143 $1,493,323 $1,410,823 $82,500 5.5% TOTAL NON-DEPT APPROPRIATIONS $12,299,571 $13,360,594 $13,129,565 $231,029 1.7% ........... m ..... TOTAL GOVERNMENTAL FUNDS $218,057,821 $273,925,440 $225,258,811 $666,679 0.3% PROPRIETARY & SPEC REV, FUNDS ADMINISTRATION OF JUSTICE SKILLMAN FOUNDATION TOTAL ADMIN. OF JUSTICE $162,000 $162,000 6162,000 $162,000 $162,000 $162,000 LAW ENFORCEMENT PROSECUTOR-COOPERATIVE REIM $916,119 $982,456 $982,456 PROSECUTOR-ANTI DRUG 172,158 172,170 172,170 SHERIFF-ANTI DRUG 69,378 64,331 64,331 -GRANT ENDED 6/30/91. 766,448 661,696 155,140 243,007 766,448 661,696 155,140 270,587 766,448 761,942 149,703 243,087 SECONDARY ROAD PATROL AUTO THEFT PREV.-SHERIFF AUTO THEFT PREV.-PROSECUTOR COMMISSARY FUND (27,500) -11.3% -INCREASED EXPENSES RELATED To HIGHER SALES MANAGEMENT A BUDGET *EQUIPmENT FUND $3,300 $3,300 $3,300 COUNTY OF OAKLAND 1991 THIRD QUARTER FORECAST EXPENDITURES BUDGET BUDGET 1990 MONT As AS EXPENDITURE FAVoRAUE! ADOPTED AMSTED FORECAST (uNFAVORABLE) PERCENT EXPLANATION TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT DRAIN COMMISSIONED *MICROFILM & REPRODUCTIONS LIBRARY BOARD $3,078,835 $3,045,328 $3,072,028 0(77,500) -0.9% $17,070,889 $17,078,099 $15,095,889 $1,183,000 6.9% -SEE REVENUE NOTE 131,922 131,922 146,122 (14,200) -10,8% -SEE REVENUE NOTE 54,760 54,760 54,760 TOTAL GENERAL GOVERNMENT $17,265,571 $17,265,571 $16,096,771 $1,168,810 6.0% SOLID WASTE $3,300 $3,300 $3,300 CENTRAL SERVICES PARKS 6 RECREATION $9,739,040 $9,739,040 $9,884,740 $(145 0 701) -1.5% -ADDIITIoNAL CAPITAL IMPROVEMENTS DUE ADDITIONAL FUNDING AVIATION 1,815,951 1,815,951 1,943,051 (27,100) -1,5% -SEE REVENUE NOTE *MATERIALS MANAGEMENT 211,900 211,980 222,100 (10,200) -4.3% -SEE RUENuE'NoTE *LEASED VEHICLES 172,200 172,200 247,500 (75,300) -43,7% -SEE REVENUE NOTE *PRINT SHOP 42,200 42,200 42,200 *RADIO COMMUNICATIONS 7,750 7,750 4,750 3,800 38,7% -SEE REVENUE NOTE FOOD SERVICES 264,912 264,912 254,512 10,400 3.9% -SEE REVENUE NOTE $12,254,033 $12,254,033 $12,490,933 $(244,900) -2,0% PUBLIC WORKS *MAINTENANCE 6 OPERATIONS $1,204,797 $1,204,797 $1,244,797 $(40,010) -3.3% *TELEPHONE cOmmUNICATIONS 274,166 274,166 374,166 (100,002) -36.51 -SEE TELEPHONE COMMUNICATION FUND WORKSHEET *HARKETs 245,448 245,448 239,418 6,000 2,4% -SEE REVENUE NOTE *WATER 6 SEWER EQUIPMENT 540,000 (540,000) -SEE REVENUE NOTE WATER 6 SEWER OPERATIONS 19,408,009 19,408,009 19,408,009 021,132,420 $21,132,420 021,906,420 0(674,000) -3.2% INSTITUTIONAL A HUMAN SERV. MEDICAID SCREENING FAMILY PLANNING GRANT W.I,C, GRANT S.1.D. SYNDROME GRANT 81.0.8.8. 0.5.A.S. GRANT $910,507 $910,507 $910,507 374,561 374,561 374,561 696,665 696,665 696,665 8,000 0,000 8,000 2,529,891 3,461,222 3,461,222 COUNTY OF OAKLAND 1990 THIRD QUARTER FORECAST EXPENDITURES BUDGET BUDGET 1990 AMOUNT AS AS EXPENDITURE FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT EXPLANATION INFANT HEALTH PROMOTION HYPERTENSION GRANT CHILDREN'S HEALTH SVS INFANT MORTALITY T.B. OUTREACH HUH BLOCK GRANT AIDS TESTING PROGRAM HIV SURVEY GRANT MIG/HIP PRENATAL COORDINATION ADOPTIVE SERVICES HOMELESS ASSISTANCE MICHIGAN BICYCLE HELMET PRENATAL POST PARTUM -, PUBLIC SERVICES . VETERAN'S TRUST - PROBATION ENHANCEMENT PROBATION ENH, DIS. GRANT PROBATION COMM, CORRECTION JOB TRNG, PARTNERSHIP ACT COMPUTER SERVICES *OPERATIONS COMMUNITY 6 ECONOMIC REVEL. COMMUNITY DEVELOPMENT SHALL BUSINESS CENTER AREA DEVELOPMENT OFFICE TOTAL SPECIAL REVENUE AND PROPRIETARY FUNDS GRAND TOTAL - ALL FUNDS PREPARED BY BUDGET DIVISION NOVEMBER 5, 1990 INTERNAL SERVICES FUNDS WITH * REVENUE FROM OUTSIDE SOURCES 85,571 85,571 05,571 232,973 232,973 232,973 249,825 249,825 249,825 38,609 37,252 37,252 151,270 151,270 151,270 271,541 211,978 211,978 34,346 34,346 34,146 111,255 111,255 111,255 81,692 81,692 81,692 33,769 33,769 33,769 174,491 236,666 216,666 12,412 12,412 $5,984,973 $6,929,964 $6,929,964 $319,645 $319,645 $319,645 67,000 67,000 67,000 96,000 96,000 96,000 40,000 40,000 6,605,549 6,605,549 6,605,549 $7,088,194 $7,128,194 $7,128,194 $1,089,061 $1,089,061 $1,177,061 $(88,000) -8.1% -SEE REVENUE NOTE $1,089,061 $1,089,061 $1,177,061 8(08,000) -8.1% 09,314,082 $9,314,802 89,314,882 118,551 105,000 105,000 113,150 96,000 96,000 $9,566,582 $9,535,882 $9,535,082 $77,624,969 $78,545,753 $78,411,353 $134,400 0.2% $296,477,790 $302,471,193 $301,670,164 8801,029 0.31 MICROFILM FUND REVENUES: OUTSIDE INSIDE OAKLAND COUNTY CLERK/REGISTER INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED AMENDED 1990 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) COMMENTS $ 131,922 $ 131,922 $ 146,122 $ 14,200 -INCREASED SERVICES TO TITLE COMPANIES. 385,551 385,551 370,151 (15,400) -DECREASE IN PRODUCTION DUE TO TURNOVER. TOTAL REVENUES $ 517,473 $ 517,473 $ 516,273 $ (1,200) OPERATING EXPENSES 516,428 516,428 552,028 (35,600) -(10,600) FOR PRIOR YEAR'S EQUIPMENT MAINTENANCE ------------ ------------ ------- ----------------- AND (35,000) FOR DUPLICATION OF DAMAGED CLERK'S NET PROFIT(LOSS) $ 1,045 $ 1,045 $ (35,755) $ (36,800) RECORDS (ALLOCATED IN 1989 AND AVAILABLE IN ----- ------- --------- - ----------- ----- FUND BALANCE) PARTIALLY OFFSET BY 10,000 FAVORABILITY IN SALARIES AND FRINGES. PREPARED BY BUDGET DIVISION 10/22/90 C. OAKLAND COUNTY DRAIN COMMISSIONER INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED AMENDED 1990 VARIANCE DRAIN EQUIPMENT FUND ' BUDGET BUDGET FORECAST FAV/(UNFAV) COMMENTS REVENUES: INSIDE $ 256,506 $ 256,506 $ 277,806 $ 21,300 -INCREASE IN VEHICLE RENTAL AND SALE OF SOIL EROSION ------ ------------ --------- - ----- MANUALS TO MUNICIPALITIES. TOTAL REVENUES $ 256,506 $ 256,506 $ 277,806 $ 21,300 OPERATING EXPENSES 256,506 256,506 255,206 1,300 ------------ ----- ----- ----- -- NET PROFIT(LOSS) $ 0 $ 0 $ 22,600 $ 22,600 PREPARED BY BUDGET DIVISION 10/18/90 1-\ ( $ 2,376,844 $ 2,387,765 $ 400,155 400,155 163,600 174,521 1,813,089 1,813,089 INSURANCE FUND (1990 CLAIMS) REVENUE $ 2,376,844 OPERATING EXPENSES 400,155 PREMIUM 163,600 CLAIMS PAID & RESERVES 1,813,089 10,921 -INCREASED PREMIUM COSTS FOR PROPERTY, BOILER & MACHINERY, AND MONEY G SECURITIES POLICIES (10,921) WHICH WERE REBILLED TO DEPARTMENTS. 0 0 $ 0 $ OAKLAND COUNTY RISK MANAGEMENT COUNTY BUILDING AND LIABILITY INSURANCE FUND 1990 THIRD QUARTER FORECAST ADOPTED BUDGET AMENDED BUDGET 1990 VARIANCE FORECAST FAV./(UNFAV) COMMENTS NET PROFIT (LOSS) 0 $ LIABFORECAST BUDGETTHREE PREPARED BY BUDGET DIVISION OCTOBER 24, 1990 OAKLAND COUNTY DEPARTMENT INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED AMENDED 1990 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) COMMENTS FRINGE BENEFITS REVENUES RETIREMENT-HOSP RETIREMENT-ADMIN RETIREMENT-CONTRB GROUP LIFE HOSPITALIZATION SOCIAL SECURITY DENTAL OPTICAL DISABILITY PERSONNEL TURNOVER WORKER'S COMP UNEMPLOYMENT REFUND PRIOR YEAR TOTAL REVENUES $ 3,775,728 $ 8,163,913 $ 8,672,913 $ 509,000 REVENUES ARE UNFAVORABLE DUE TO THE DELAY IN FILLING OF 825,000 825,000 789,000 (36,000) NEW POSITIONS & TURNOVER. FAVORABILITY ALSO IS REFLECTED 15,763,501 11,375,316 10,976,316 (399,000) IN DEPARTMENTAL BUDGETS. WITHIN THE FRINGE BENEFIT FUNDS, 398,577 398,577 399,577 1,000 EXPENDITURES ARE REDUCED DUE TO TURNOVER. HOSPITALIZATION (506,000) IS FAVORABLE DUE TO THE SELF-INSURED PROGRAM. LIFE (142,000) INSURANCE PREMIUM RATES INCREASED JANUARY 1990 DUE TO THE (39,000) COUNTY'S EXPERIENCE RATING, 690,000 2,006,532 (167,000) 112,440 (12,000) 28,400 28,400 ------------ ------------ - --------- ----- ------- 46,557,206 46,557,206 45,444,606 (1,112,600) 11,768,710 8,251,739 1,542,507 234,379 849,085 850,000 2,173,532 124,448 11,768,710 11,182,710 8,251,739 8,109,739 1,542,507 1,503,507 234,379 221,379 849,085 752,085 850,000 2,173,532 124,440 (13,000) (97,000) (160,000) EXPENSES S/A LEAVE CASH-IN S/A RESERVE RETIREES' HOSP RETIREMENT ADMIN RETIREMENT CONTRB GROUP LIFE HOSPITALIZATION SOCIAL SECURITY DENTAL OPTICAL DISABILITY WORKERS' COMP UNEMPLOYMENT $748,000 $743,000 $818,000 3,775,728 8,163,913 8,672,913 825,000 825,000 904,000 15,763,501 11,375,316 10,471,316 398,577 398,577 504,577 11,768,710 11,768,730 10,044,710 8,251,739 8,251,739 8,109,739 1,542,507 1,542,507 1,475,507 234,379 234,379 155,379 1,699,085 1,699,005 1,697,085 2,173,532 2,173,532 2,006,532 124,448 124,448 110,448 $(70,000) (509,000) (79,000) 904,000 (106,000) 1,724,000 142,000 67,000 79,000 2,000 167,000 14,000 TOTAL EXPENSES NET INCOME (LOSS) 47,305,206 47,305,206 44,970,206 2,335,000 $ (748,000) $ (748,000) 474,400 1,222,400 PREPARED BY BUDGET DIVISION- 612,600 604 ,600 0,000 -------- ---------- $612,600 $612,600 $606,560 $0 $O $160,740 590,560 ' 0,000 OAKLAND COUNTY MANAGEMENT AND BUDGET INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED BUDGET 1990 AMENDED ESTIMATED VARIANCE BUDGET ACTUAL FAVAUNFAV) EXPLANATION CONVENIENCE COPIER FUND: REVENUES - INSIDE EXPENSES - NET PROFIT (LOSS) ' EQUIPMENT FUND: REVENUES - OUTSIDE REVENUES - INSIDE REVENUES - NON-OPERATING TOTAL REVENUES EXPENSES EXPENSES - NON-OPERATING TOTAL EXPENSES NET PROFIT (LOSS) BEFORE OPERATING TRANSFER OPERATING TRANSFER IN NET PROFIT (LOSS) :MOFCOPEQUIP3 PREPARED BY: BUDGET DIVISION 10/24/90 $477,800 $477,000 $551,600 $73,800 REVENUE FAVORABLE DUE TO INCREASED USAGE. 477,000 477,000 496,900 (19,100) OPERATING EXPENSES UNFAV DUE INCREASED NUMBER OF COPIER RENTALS AND STATIONARY $0 $0 $54,700 $54,700 USAGE, OFFSET BY SAVINGS IN DEPRECIATION DUE TO FEWER PURCHASES OF COPIERS. $0 REVENUES FAVORABLE DUE TO INCREASE IN 154,700 PURCHASE OF NEW EQUIPMENT. OPERATING $0 EXPENSES FAVORABLE DUE TO SAVINGS IN MAINTENANCE CONTRACTS AND LOSS ON STOLEN $612,600 $612,600 $767,300 $154,700 EDUTPMENT, OFFSET BY INCREASE IN DEPRECIATION, OPERATING TRANSFER IS FOR THE NEW VIES VIDEO 6,040 EQUIPMENT IN THE SHERIFF'S DEPT. $0 $6,040 $160,740 0 0 103,413 103,413 $0 $0 $264,153 $264,153 $3,300 $3,300 $3,300 609,300 594,300 749,000 15,000 15,000 ADOPTED BUDGET AMENDED BUDGET 26,290 29,594 (39,440) 164,780 0 (149,169) 108,030 0 OAKLAND COUNTY CENTRAL SERVICES INTERNAL SERVICES 1990 THIRD QUARTER REPORT 1990 VARIANCE FORECAST FAV/(UNFAV) COMMENTS PRINTING AND MAILING REVENUES-OUTSIDE $ 42,200 $ 42,200 $ 42,200 REVENUES-INSIDE 925,822 ' 925,822 1,073,606 147,784 -MAILROOM-INCREASED REVENUES OFFSET BY INCREASED --------- COST OF SALES TOTAL 968,022 968,022 1,115,806 147,784 -PRINT SHOP-INCREASED REVENUES AND COST OF SALES DUE COST OF SALES 647,000 647,000 735,816 (88,816) TO INCREASED PAPER COSTS; OVERTIME UNFAVORABLE DUE TO UPDATING LEGAL LITERATURE, INCREASED REVENUES AND GROSS MARGIN 321,022 321,022 379,990 58,968 ASSOCIATED EXPENSES FOR TRIAL PERIOD OF NEW MACHINE. OPERATING EXPENSES 322,002 322,002 340,490 (18,488) (980) $ NET PROFIT (LOSS) $ (900) $ 39,500 $ 40,480 MOTOR POOL GARAGE: ---- ' REVENUES - OUTSIDE $ 0 $ 0 $ 0 $ 0 -FAVORABLE REVENUES PARTIALLY OFFSET BY COST OF SALES 'REVENUES - INSIDE 1,384,300 1,384,300 1,540,318 156,018 FOR GAS, OIL, AND GREASE, LABOR-BUMP, AND TIRE & TUBES; FAVORABLE OPERATING FOR TURNOVER TOTAL 1,384,300 1,384,300 1,540,318 156,018 COST OF SALES 889,325 889,325 1,019,053 (129 0 728) 1,540,318 1,019,053 GROSS MARGIN 494,975 OPERATING EXPENSES 596,710 494,975 521,265 596,710 567,116 NET PROFIT (LOSS) BEFORE TRANSFERS OPERATING TEE-IN (101,735) (45,851) 76,540 (3,304) 76,540 (101,735) NET PROFIT (LOSS) $ (101,735) $ (101,735) $ 30,689 $ 73,236 LEASED VEHICLES: ----- ----- REVENUES - OUTSIDE $ 172,200 REVENUES - INSIDE 3,211,919 $ 172,200 $ 247,543 $ 75,343 -FAVORABLE REVENUES FOR INCREASED MILEAGE; 3,211,919 3,330,374 118,455 NET INCOME TO BE USED FOR INCREASED VEHICLE REPLACEMENT COSTS TOTAL 3,384,119 COST OF SALES 3,092,387 3,384,119 3,577,917 3,092,387 3,418,630 193,798 (326,243) GROSS MARGIN $ 291,732 $ 291,732 $ 159,287 $ (132,445) OPERATING EXPENSE 182,003 182,003 198,727 (16,724) NET PROFIT (LOSS) BEFORE TRANSFERS 109,729 109,729 OPERATING TRF-IN 56,700 56,700 ' OPERATING TEE-OUT 0 NET PROFIT (LOSS) $ 166,429 $ 166,429 $ 125,340 $ (41,039) TOTAL MOTOR POOL $ 64,694 $ 64,694 $ 156,029 $ 32,147 7 OAKLAND COUNTY CENTRAL SERVICES INTERNAL SERVICES 1990 THIRD QUARTER REPORT FOOD SERVICES: REVENUE - OUTSIDE $ 274,200 $ 274,200 $ 263,795 $ (10,405) -DECREASE IN REVENUES ASSOCIATED WITH REDUCED COST OF SALES $ 80,863 $ 80,863 $ 75,205 $ 5,658 SALES; UNFAVORABLE SALARIES FOR ADDITIONAL HOURS WORKED GROSS MARGIN $ 193,337 $ 193,337 $ 183,590 $ (4,747) OPERATING EXPENSES 258,797 258,797 269,476 (10,679) NET PROFIT (LOSS) BEFORE TRANSFERS (65,460) (65,460) (80,886) (15,426) OPERATING TRF-IN 65,460 65,460 65,460 0 OPERATING TEE-OUT ' 0 0 0 0 NET PROFIT (LOSS) $ 0 $ 0 $ (15,426) $ (15,426) . ' RADIO , REVENUES - OUTSIDE $ 7,750 $ 7,750 $ 4,714 $ (3,036) -INCREASED REVENUES DUE TO EQUIPMENT ADDITIONS FOR REVENUES - INSIDE 435,410 435,410 504,264 68,854 SHERIFF CONTRACTED POSITIONS APPROVED BY H.R. PARTIALLY OFFSET BY CORRESPONDING EXPENSES TOTAL 443,160 443,160 508,978 65,818 EXPENSES 441,848 441,848 481,274 (39,426) NET PROFIT (LOSS) BEFORE TRANSFERS 1,312 1,312 27,704 26,392 OPERATING TRF-IN 12,540 12,540 34,570 22,030 NET INCOME (LOSS) $ 13,852 $ 13,852 $ 62,274 $. 48,422 MATERIALS MANAGEMENT REVENUES - OUTSIDE $ 211,980 $ 211,980 $ 222,180 $ 10,200 -INCREASED SALE TO CAMP OAKLAND AND SHERIFF REVENUES - INSIDE 2,665,882 2,665,882 2,834,658 168,776 DEPARTMENT FOR PROVISIONS, SALE OF PAPER To copIER FUND, AND HOUSEKEEPING SUPPLIES FOR TOTAL 2,877,862 2,877,862 3,056,838 178,976 CHILDRENS' VILLAGE AND SHERIFF COST OF SALES 2,504,866 2,504,866 2,610,369 (105,503) GROSS MARGIN 372,996 372,996 446,469 73,473 OPERATING EXPENSE 454,015 454,015 423,018 30,997 ----- - ----- - ------- ----- ------------ ------------ NET INCOME (LOSS) $ (81,019) $ (81,019) $ 23,451 $ 104,470 $ 1,572,500 1,525,671 ------ -- 46,829 0 243,451 0 290,280 $ 1,572,500 1,525,671 ------ -- 46,829 0 243,451 0 290,280 $ 5,170,000 $ 5,266,930 $ 4,569,040 4,617,788 PARKS AND RECREATION PROPERTY TAX $ 5,170,000 OPERATING REVENUE 4,569,040 96,930 -REVENUES FAVORABLEFROM PRIOR YEARS' MILLAGE 40,748 COLLECTED IN 1990, $ 96,930 AND PARKS OPERATIONS, $48,748. TOTAL 9,739,040 9,739,040 OPERATING EXPENSE 8,191,965 9,739,040 9,884,710 145,678 9,739,040 0 OAKLAND COUNTY CENTRAL SERVICES INTERNAL SERVICES 1990 THIRD QUARTER REPORT AVIATION AND TRANSPORTAION OPERATING REVENUE OPERATING EXPENSES NET PROFIT (LOSS) BEFORE TRANSFER-IN INTEREST INCOME OPERATING TRF-IN DEPRECIATION FUNDS AVAILABLE FOR CAPITAL IMPROVEMENT $ 0 $ 73,904 27,075 0 243,451 0 0 290,280 0 $ 27,075 $ 27,075 $ 1,599,575 $ 27,075 -FAVORABLE REVENUES FOR LAND LEASE-PONTIAC, $16,625, 1,525,671 0 AND RESTAURANT CONCESSION, $10,450 FUNDS AVAILABLE FOR CAPITAL IMPROVEMENT $ 1,547,075 $ 0 $ 145,678 $ 145,678 PREPARED BY BUDGET DIVISION :MSUMMARY90 9 OCT 1990 NET PROFIT (LOSS) $ ? 775 $ 15,395,138 15,395,138 15,435,138 40,000 14,396,193 14,416,521 14,348,021 68,500 TOTAL EXPENSES 61,904 $ 77,604 53,104 $ 75,104 53,104 $ 75,104 (22,000) 22,000 (15,700) 30,000 8,000 0 $ 6,300 $ (22,000) 22,000 0 0 $ PONTIAC MARKET REVENUES - OUTSIDE $ EXPENSES NET PROFIT (LOSS) BEFORE TRANSFERS OPERATING TRF-IN OPERATING TEE-OUT NET PROFIT (LOSS) $ 8,800 -INCREASED REVENUES ANTICIPATED DUE TO RATE INCREASE (2,500) WHICH WILL OFFSET PRIOR YEARS LOSSES. FUNDING OF PROJECTS FOR ALTERING OF RESTROOMS TO ACCOMODATE HANDICAPPED, 6,300 8,000 (8,000) 6,300 OAKLAND COUNTY DEPARTMENT OF PUBLIC WORKS INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED BUDGET TELEPHONE COMMUNICATIONS AMENDED BUDGET 1990 VARIANCE FORECAST FAV/(UNFAV) COMMENTS REVENUES-OUTSIDE $ 274,166 $ 274,166 $ 374,166 $ 100,000 -PAY PHONE REVENUE FAVORABLE DUE TO NEW CONTRACT, REVENUES-INSIDE 2,012,415 2,012,415 2,065,415 53,000 -REVENUES AND COST OF SALES ARE HIGHER THAN EXPECTED DUE TO DELAY IN COST REDUCTION REPORTING SYSTEM, TOTAL COST OF SALES 2,286,581 2,286,581 2,439,581 153,000 2,026,683 2,026,683 2,107,883 (81,200) GROSS MARGIN OPERATING EXPENSES OPERATING TEE IN OPERATING TR (OUT) • 259,898 259,898 259,123 259,123 331,698 71,800 334,923 (75,800) -UNFAVORABLE DUE TO START UT COSTS FOR VOICE MAIL. 9,360 9,360 -TRANSFER FOR NEW CELLULAR PHONES. (92,519) 92,519 -TRANSFER FOR ONGOING COMMUNICATIONS UPGRADE PROJECT WHICH WAS FUNDED IN 1988. 775 $ (86,384) $ (87,159) FACILITIES, MAINTENANCE & OPERATIONS REVENUES - OUTSIDE $ 1,204,797 $ 1,204,797 $ 1,244,797 $ REVENUES - INSIDE 14,190,341 14,190,341 14,190,341 -FAVORABLE SALARIES AND FRINGE BENEFITS DUE TO 40,000 TURNOVER PARTIALLY OFFSET BY LEASED VEHICLES (DUE TO RATE INCREASE) NET PROFIT (LOSS) BEFORE TRANSFERS $ 998,945 $ 978,617 $ 1,087,117 $ 108,500 OPERATING TRF-IN $ 85,500 $ 85,500 $ 85,500 OPERATING TRF-OUT $ 1,000,000 $ 1,000,000 $ 1,000,000 NET INCOME (LOSS) $ 84,445 $ 64,117 $ 172,617 $ 108,500 OAKLAND COUNTY DEPARTMENT OF PUBLIC WORKS INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED AMENDED 1990 VARIANCE BUDGET BUDGET FORECAST FAVRUNFAV) COMMENTS ROYAL OAK MARKET REVENUE - OUTSIDE $ 170,344 $ 170,344 $ 177,344 $ 7,000 -INCREASED REVENUES ANTICIPATED (DUE TO RATE OPERATING EXPENSES 170,344 170,344 166,344 4,000 INCREASE) WILL BE USED FOR CAPITAL IMPROVEMENTS. NET PROFIT (LOSS) BEFORE TRANSFERS 11,000 11,000 OPERATING TRF-OUT NET PROFIT (LOSS) $ 0 $ 0 $ 11,000 $ 11,000 TOTAL MARKETS, 0 $ 0 $ 17,300 $ 17,300 D.P.W. WATER t, SEWER EQUIPMENT FUND REVENUES - OUTSIDE $ 540,000 $ 540,000 -ACTUAL REFLECTS REVENUE FROM WATER AND SEWER REVENUES - INSIDE $ 823,000 $ 823,000 $ 300,000 $ (523,000) TRUST FUNDS AS FROM AN OUTSIDE SOURCE. EXPENSES TOTAL $ 823,000 $ 823,000 $ 840,000 $ 823,000 823,000 840,000 17,000 (17,000) NET PROFIT (LOSS) $ FORECAST 90 BUDGETTHREE PREPARED BY BUDGET DIVISION 0 $ 0 $ 0 $ OAKLAND COUNTY COMPUTER SERVICES DEPARTMENT INTERNAL SERVICES 1990 THIRD QUARTER FORECAST ADOPTED AMENDED 1990 VARIANCE BUDGET BUDGET FORECAST FAVRUNFAV) COMMENTS COMPUTER SERVICES FUNDS: REVENUES: OUTSIDE INSIDE $ 1,089,061 $ 1,089,061 $ 1,177,061 $ 88,000 -INCREASED SERVICE TO OUTSIDE AGENCIES. 8,380,655 8,430,227 7,802,727 (627,500) -RATE REDUCTION TO OFFSET OPERATING FAVORABILITY. TOTAL REVENUES $ 9,469,716 $ 9,519,288 $ 8,979,788 $ (539,500) OPERATING EXPENSES 9,469,716 9,482,499 8,828,399 654,100 -FAVORABILITY IN OPERATING PRIMARILY DUE TO -------- ------------ -------------------- TURNOVER OF $488,400; EQUIPMENT AND SOFTWARE NET PROFIT(LOSS) $ 0 $ 36,789 $ 151,389 $ 114,600 RENTAL OF $298,000; AND COMPUTER SERVICES --------- ------- ------- ----- ------ OPERATIONS OF $59,100. PARTIALLY OFFSET BY . UNFAVORABLE MAINTENANCE DEPARTMENT CHARGES ($52,000), DATA PROCESSING SUPPLIES ($41,400), REFUND OF PRIOR YEARS' REVENUE ($35,500), INTEREST EXPENSE ($30,500), COMPUTER SERVICES DEVELOPMENT ($22,000), AND SERVICE PREPARED BY BUREAU EXPENSE ($10,000). BUDGET DIVISION 10/22/90 ( BUDGET AS ADOPTED BUDGET ADJUSTMENTS BUDGET AS ADJUSTED COLLECTIONS TO 8/31/90 ' BALANCE OF ESTIMATE TO BE COLLECTED % OF YEAR ELAPSED 66.66% PERCENTAGE COLLECTED $ 106,405,118.00 $106,405.118.00 $106,405.118.00 CURRENT COLLECTIONS DELINQUENT TAX REVOLVING NET CURRENT PROPERTY TAX $ 106,405,118.00 $ 99,696,970.07 6,789,620.02 $106,405,118.00 $ 106,486,590.09 $ OTHER TAXES DELINQUENT TAXES PRIOR YEARS $ TRAILER TAX 577,000.00 00,000.00 • 577,000.00 %$ 80 ,000.0D • 665,000.00 $ 373,511.25 $ 57,954.00 431,465.25 • 665,000.00 TOTAL PROPERTY AND OTHER TAXES $ 107,070,118.00 $107,070,118.00 $ 106,918,055.34 $ 14,200.00 491,000.00 334.000.00 364,700.00 180,000.00 12,077,000.00 2,213,700.00 285,100.00 2,238,600.00 2,000.00 301,500.00 41.13% , 75.02% 74.81% 75.04% 107.14% 47.19% 100.00% 87.14% 33.42% 121.04% 55.66% 'COUNTY OF OAKLAND STATEMENT OF RECEIPTS - COUNTY -OPERATING FUNDS FOR THE EIGHT MONTHS ENDED AUGUST 31, 1990 PROPERTY- TAXES 1990=T AX LEVY LESS: ALLOWANCE FOR TIFA ALLOWANCE FOR LDFA DELINQUENT TAX TRIBUNAL APPEALS $ 108,533,618.00 (1,153,500.00) $ (825,000.00) (150,000.00) $100,533,618.00 23,500.00 (1,130,000.00) (23,500.00) (23,500.00) (825,000.00) (150,000.00) $108,533,618.00 (1,130,000.00) (23,500.00) (825,000.00) (150,000.00). BUDGETED RECEIPTS OTHER THAN TAXES GENERAL FUND STATE AND FEDERAL CULTURAL COUNCIL GRANTS CIRCUIT JUDGES SALARIES PROBATE JUDGES SALARIES DISTRICT JUDGES SALARIES MARINE SAFETY STATE INCOME TAX STATE REIMB. - P.A. 228 FEDERAL REVENUE SHARING CONVENTION FAO TAX PA 106/07 CIGARETTE TAX DISTR8. STATE INSTITUTIONS INDIRECT COST RECOVERY $ 19,302,600.00 • 14,200.00 $ 491,000.00 334,000.00 ,364,700.00 100,000.00 12,077,000.00 2,213,700.00 285,100.00 2,238,600.00 2,000.00 301,500.00 $ 19,302,600.00 $ 5,840.00" $ 368,362.50' 250,455.00" 273,675.00' 192,947.93/ 6,076,560.75/ 2 ,213 ,730 .38 •." 248,440.69 / 748,195.50," 364,920.71'' 10,743,036.46 $ (6.789,620.02) (81,472.09) 03,498.75 . 30,046.00 233,534.75 152,062.66 8,360.00 122,637.50 84,345.00 91,025.00 (12,847.93) 6,000,439.25 (38.38) 36,659.31 1,490,404.50 2.000.00 (63,420.71) 8,559,563.54 100.08% ------- 64.73% 65.86% 64.88% ------- 99.86% PREPARED BY ACCOUNTING DIVISION PAGE 1 CHARGES FOR SERVICES AUDITING COUNTY EXECUTIVE CORPORATION COUNSEL CULTURAL AFFAIRS ECONOMIC DEVELOPMENT ACCOUNTING AUCTION REVENUE • EQUALIZATION REIMBURSEMENT SAFETY DIVISION. PUBLIC WORKS-SOLID WASTE PUBLIC WORKS-ADMIN. FACILITIES ENGINEERING PERSONNEL-EMPLOYEES RELATION MEDICAL EXAMINER PUBLIC SERVICES DISTRICT COURT PROBATION COOPERATIVE EXTENSION PLANNING CLERK/REGISTER OF DEEDS TREASURER CIRCUIT COURT FRIEND OF THE COURT DISTRICT CT. I WALLED LAKE DISTRICT CT. II CLARKSTON DISTRICT CT. III ROCH. HILLS DISTRICT CT. IV TROY PROBATE COURT PROSECUTING ATTORNEY SHERIFF BOARD OF COMMISSIONERS LIBRARY BOARD DRAIN COMMISSIONER 55,000.00 32,200.00 47,500.00 46,000.00 14,000.00 654,714.00 162,750.00 129,941.00 49,000.00 74,750.00 15,000.00 7,800.00 20,600.00 14,500.00 628,625.00 21,800.00 190,000.00 7,300,000.00 2,162,384.00 1.725,270.00 5,697,498.00 1,186,000.00 600,000.00 1,431,593.00 1,303,730.00 766,962.00 92,000.00 10,644,867.00 20,500.00 77,402.00 1,926,669.00 $ 37,099,055.00 $ 615.00 $40,769.00 223,206.00 67,236.00 9,360.00 82,398.00 136,405.00 567,989.00 COUNTY OF OAKLAND STATEMENT OF RECEIPTS - COUNTY OPERATING FUNDS FOR THE EIGHT MONTHS ENDED AUGUST 31, 1990 BUDGET AS ADOPTED BUDGET ADJUSTMENTS BUDGET AS ADJUSTED COLLECTIONS TO 8/31/90 BALANCE OF ESTIMATE TO BE COLLECTED % OF YEAR ELAPSED 66.66% PERCENTAGE COLLECTED 55,000.00 $ 32,200.00 47,500.00 46,000.00 14,000.00 654,714.00 162.750.00 129,941.00 49,615.00 74,750.00 15,000.00 7,800.00 20,600.00 14,500.00 677,394.00 21,600.00 190,000.00 7,300,000.00 2,162,394.00 1,948,476.00 5,697,498.00 1,253,236.00 600,000.00 1,431,593.00 1,303,730.00 766,962.00 101,360.00 10;727,265.00 20,500.00 77,402.00 2,063,074.00 $ 37,667,044.00 22,000.00 4'$ 210.00e 22,778.00, 35,161.68/ 19,702.91, 9,272.99! 548,177.51' 109,950.68/. 59,304 .52-! 721.57'' 14,963.83 ," 403.75 17,266 .50-" 3,989.38 , 476,117.13-0 12.40" 100,547.53'. 5,141,669.32". 2,138,626.98 .-- 1,221,024.49". 3,431,241.54 ," 869,309.92, 357,447.70, 922,439.26` 717,484.25! 496,589.29 . 15,155.00, 7,012,524.12' 12,940.00" 47,020.90' 1,210,677.94/ 25,032,736.07 $ 33 0 000.00 (210.00). 9,422.00 12,338.32 27,297.09 4,727.01 106,536.49 53,799.32 70,636.48 48,893.43 . 74,750.00 36.17 7,391.25 3,333.50 10,510.62 201,276.87 21,787.60 89,452.47 2,156,330.68 23,757.12 727,451.51 2,266,256.46 393,926.08 242,552.30 509,153.74 596,245.75 270.372.71 86,205.00 3,714,740.98 7,560.00 30,381.02 652,396.06 12,634,307.93 40.00% 70.74% 74.02% 40.66% 66.24% 83.73% 66.94% 45.64% 1.45% 99.76% 5.24% 83.82% 27.51% 70.29% 0.06% 52.92% _ 70.43% -98.90% -.62.67% -60.22% 69.37% 59.57% 64.43% 55.03% • 64.75% 14.95% 65.37% • 63.12% 60.75% 58.68% -------- 66.46% PREPARED BY ACCOUNTING DIVISION PAGE 2 BUDGET ADJUSTMENTS BUDGET AS ADJUSTED COLLECTIONS TO 6/31/90 BALANCE OF ESTIMATE TO OE COLLECTED % OF YEAR ELAPSED 66.66% PERCENTAGE COLLECTED 635,000.26 / $ 1,602,568.74 16,610.98" (2,610.98) 2,976,631.352/ 1,119,493.65 14,715,104.21' 8,041,840.79 10,392.02e 33,607.98 28.40% 116.32% 72.67% 64.66% 23.62% (1,783,328.00) $ 29,151,447.00 $ 18,356,546.82 $ 10,794,900.18 62.97% 211,423.27 418,463.90 64,026.25 200,511.95 834.94 597,429.75 (4,581.30) 283,319.71 . ,219,143.99 COUNTY OF OAKLAND STATEMENT OF RECEIPTS — COUNTY OPERATING FUNDS FOR THE EIGHT MONTHS ENDED AUGUST 31, 1990 BUDGET AS ADOPTED REVENUES OTHER FUNDS STATE AND FEDERAL HEALTH—STATE SUBSIDY DISASTER CONTROL CHILD CARE SUBSIDY COMMUNITY MENTAL HEALTH SOCIAL SERVICES—FOST. CARE $ 30,934,775.00 $ CHARGES FOR SERVICES $ 2,238,377.00 $ -2,238,377.00 16,000.00 16,000.00 4,096,125_00 4,096,125.00 24,540,273.00 $ (1,783,328.00) 22,756,945.00 44,000.00 44.000.00 FRIEND OF THE COURT HEALTH EMERGENCY MEDICAL SERVICE ANIMAL CONTROL LAND SALES CAMP OAKLAND CHILDREN'S VILLAGE SOC SVCS—HOSPITALIZATION JUVENILE MAINTENANCE MEDICAL CARE FACILITY 430,500.00 1,484,960.00 $ 183,750.00 661,802.00 2,253.00 2,009,944.00 4,000.00 702,264.00 4,518,000.00 438,500.00 37,720.00 1,522,680.00 103,750.00 661,802.00. 2,253.00 1,749,044.00 4,000.00 • 702,264.00 -4,518,000.00 227,076.73 /$ 1,104,216.10/ 118,923.75 / 461,290.05' 1,418.06/ 1,152,414.25" 8,501.30 / 410,944.294/ 3,299,656.01/ 1 51.78% 72.52% 64.72% 69.70% 62.94% 65.86% 214.53% . 59.66% • 73.02% (260,100.00) $ 10,006,273.00 $ (222,300.00) $ 9,703,093.00 $ 6,792,520.54 $ 2,991,372.46 69.43% $ 40,941,048.00 $ (2,005,700.00) $ 30,935,340.00 $ 25,149,067.36 $ 13,786,272.64 64.59% MISCELLANEOUS REVENUE BUDGETED PROJECTS INVESTMENT INCOME SUNDRY RESOURCES CARRIED FORWARD PRIOR YEAR'S BALANCE 470,000.00 $ 11,420,000.00 350,000.00 12,240,000.00 $ $ 2,200,000.00 $ 116,000.00 $ 586,000.00 11,420,000.00 . '350,000.00 116,000.00 $ 12,356,000.00 $ 6,394,338.44 $ 8,594,338.44 $ 506,000.00 6,656,095.73 / $ 4,763,104.27 200,038.27/ 149,961.73 7,442,934.00 $ 4,913,066.00 8,594,338.44 '100.00% 58.29% 57.15% 60.24% 100.00% TOTAL AVAILABLE RESOURCES GOVERNMENTAL FUNDS $ 218,852,821.00 $ 5,072,619.44 $223,925,440.44 $ 103,000,167.67 $ 40,045,272.77 82.12% PREPARED BY ACCOUNTING DIVISION PAGE 3 5,170,000.00 9,334,882.00 67,000.00 96,000.00 374,561.00 151,270.00 696,665.00 8,000.00 2,529,898.00 $ 85,571.00 232,973.00 910,507.00 249,825.00 38,609.00 916,119.00 766,448.00 6,605,549.00 162,000.00 118,550.00 113,150.00 761,942.00 149,703.00 271,541.00 172,158.00 69,378.00 174,491.00 33,769.00 34,346.00' 111,255.00 191,692.00 319,645.00 931,324.00 (1,357.00) 66,337.00 (13,550.00) (17,150.00) (100,246.00) 5,437.00 (59,563.00) 12.00 (5,047.00) 62,175.00 12,412.00 40,000.00 5,233,094.72 $ (63,094.72)' 101;225 2,567,333.21 $ 6,767,548.79 33,053.68 33,946.32 76,064.46 19,935.54 193,113.59 181,447.41 85,510.39 65,759.61 443,414.23 253,250.77 4,092.00 3,908.00 1,856,939.32 1,604,282.68 . 47,959.78 37,611.22 153,228.64 79,744.36 551,898.76 358,608.24 116,659.42 133,165.58 23,912.60 13,339.40 631,711.71 350,744.29 316,820.82 449,627.18 3,162,607.01 27.501 49.335 79,235 51.562 56.535 63.655 51.155 53.655 56.055 65.775 60.615 46.705 64.195 64.305 41.34% 3,442,941.99 -.47.885 162,000.00 30,491.27 "-70.965 74,508.73 71,733.76 358,927.16 82,581.11 94,438.49 85,087.68 34,641.09 77,168.59 927.34 11,187.50 54,678.66 56,219.45 44,815.54 280,507.33 24,266.24 202,768.84 72,558.89 117,539.51 87,082.32 29,689.91 159,497.41 32,841.66 1,224.50 40,000.00 (20,332.66) 55,035.55 36,876.46 39,137.67 74.722 54.245 53.235 44.555 . 49.425 53.855 32.615 2.755 90.135 159.205 50.535 54.865 87.765 COUNTY OF OAKLAND STATEMENT OF RECEIPTS - COUNTY OPERATING FUNDS FOR THE EIGHT MONTHS ENDED AUGUST 31, 1990 BUDGET AS ADOPTED BUDGET ADJUSTMENTS BUDGET AS ADJUSTED COLLECTIONS TO 8/31/90 , BALANCE OF ESTIMATE TO BE COLLECTED X'OF YEAR ELAPSED 66.66X PERCENTAGE COLLECTED SPECIAL REVENUE AND PROPRIETARY FUNDS PROPERTY TAX PARKS AND RECREATION INTERGOVERNMENTAL REVENUE COMMUNITY DEVELOPMENT PROBATION ENHANCEMENT PROBATION ENH. DIS. GRANT FAMILY PLANNING MCH BLOCK GRANT W.I.C. GRANT S.I.D. SYNDROME GRANT HYPERTENSION GRANT CHILDREN'S HEALTH SERVICES MEDICAID SCREENING INFANT MORTALITY T.B. OUTREACH GRANT PROSECUTOR COOP. REIMS. SECONDARY ROAD PATROL JOBS TRAINING PARTNERSHIP ACT SKILLMAN TRUST SMALL BUSINESS CENTER AREA DEVELOP OFFICE AUTO THEFT PREVENTION-SHERIFF AUTO THEFT PREVENTION-PROSECU AIDS TESTING PROSECUTOR-ANTI DRUG SHERIFF-ANTI DRUG CMH HOMELESS ASSIST CMH ADOPTIVE SERVICES MICHIGAN BICYCLE HELMET PROBATION COMM CORRECTIONS HIV SURVEY GRANT MIC/IHIP LOCAL PRENATAL COORDINATION VETERANS' TRUST $ 5,170,000.00 $ $ 9,334,802.00 $ 67,000.00 96,000.00 374,561.00 151,270.00 696,665.00 8,000.00 3,461,222.00 85,571.00 2 32,973.00 910,507.00 249,825.00 37,252.00 982,456.00 766,448.00 . 6,605,549.00 162,000.00 105,000.00 96,000.00 661,696.00 155,140.00 211,978.00 172,170.00 64,331.00 '236,666.00 33,769.00 12,412.00 40,000.00 34,346.00 111,255.00 81,692.00 319,645.00 • $ 25,637,497.00 $ 920,784.00 $ 26,558,281.00 $ 11,591,742.05 $ 14,966,538.95 43.655 PREPARED BY ACCOUNTING DIVISION PAGE 4 $ 4,569,040.00 $ 54,760.00 274,166.00 1,204,797.00 245,448.00 172,200.00 131.922.00 42,200.00 7,750.00 264,912.00 243,087.00 3,300.00 211,980.00 1.815,951.00 19,400,009.00 , 17,078,889.00 1,089,061.00 $ 46,817,472.00 3,584,743.54 $ 21,939.88 220,867.91 893,483.10 200,185.39 141,905.99 98,452.05 37,077.50 9,784.88 176,871.16 189.440.59 2.689.90 149,090.71 1,266,030.53 11,741,124.02 361,513.79 10,502,678.09 928.022.76 984,296.46 32,820.12 45,298.09 311,313.90 45,262.61 30,294.01 33,469.95 5,122.50 (2,034.88) 88,040.84 ,53,646.41 610.10 62,881.29 549.920.47 7,666,004.98 (361.513.79) 6,496,210.91 160,238.24 30,614,709.79 $ 16,202,762.21 920,704.00 $ 78,545,753.00 $ 47,439.546.56 $ 31,106.206.44 BALANCE OF ESTIMATE TO BE COLLECTED COLLECTIONS TO 8/31/90 ' BUDGET AS ADJUSTED BUDGET ADJUSTMENTS $ 46,817,472.00 $ 77,624,969.00 $ COUNTY OF OAKUAtb STATEMENT OF RECEIPTS - COUNTY OPERATING FUNDS FOR THE EIGHT MONTHS ENDED AUGUST 31, 1990 $ 296,477,790.00 $ 5,993,403,44 $302,471,193.44 $ 231,319.714.23 $ 71,151.479.21 BUDGET AS ADOPTED CHARGES FOR SERVICES PARKS & RECREATION $ 4,569.040.00 REFERENCE LIBRARY 54.760.00 %TELEPHONE COMMUNICATIONS 274,166.00 XMAINTENANCE & OPERATIONS 1,204,79700 )(MARKETS 245,440.00 LEASED VEHICLE OPERATIONS 172,200.00 )(MICROFILM & REPRODUCTIONS 131.922.00 )(PRINT SHOP 42,200.00 )(RADIO COMMUNICATIONS 7,750.00 FOOD SERVICES 264,912.00 COMMISSARY FUND 243,007.00 )(EQUIPMENT FUND 3.300.00 )EMATERIALS MANAGEMENT 211,900.00 AVIATION 1,815,951.00 WATER & SEWER 19,408,009.00 WATER & SEWER - EQUIPMENT DRAIN COMMISSIONER , 17.078,889.00 )(COMPUTER SERVICES 1,089,061.00 TREASURER-DELINQUENT TAX TOTAL CHARGES FOR SERVICES TOTAL-SPECIAL REVENUE AND PROPRIETARY FUNDS GRAND TOTAL RESOURCES AVAILABLE-ALL FUNDS % OF YEAR ELAPSED 66.66% PER COLLECTED 78.46% 40.07% 83.48% 74.16% 81.56% 82.41% 74.63% 87.86% 126.26% 66.77% 77.93% 81.51% 70.34% 69.72% 60.50% 61.96% 85.29% 65.39% 76.48% MINTERNAL SERVICE FUNDS ••-• REVENUE FROM OUTSIDE SOURCES PAGE 5 0 PREPARED BY ACCOUNTING DIVISION BUDGET AS ADOPTED BUDGET AS ADJUSTED EXPENDITURES AND UNENCUMBERED TRANSFERS BALANCE % OF YEAR ELAPSED 66.66% PERCENTAGE SPENT BUDGET ADJUSTMENTS $342,556.33 $9,103,434.33 56,124.80 5,409,293.80 $5,302,430.11 $3,721,004.22 1,997,330.17 3,491,963.63 $398,661.13 $14,592,720.13 $0,074,393.74 $5,718,334.39 $73,516.90 43,459.00 07,011.37 42,147.91 $1,576,521.90 806,266.00 _ 1,780,308.37 1,395,454.91 $99,514.30 59,216.15 75,703.55 3,686.08 176,011.66 $5,741,616.38 ,1,807,921.55 1,212,710.08 _3,837,747.66 $12,555.20 12,708.16 4,530.14 13,772.60 13.525.83 .$917,875.20 555,737.16 85,400.14 94,304.00 1,084,793.60 75,822.00 151,668.03 $57,171.93 $2,965,600.93 $167,865.00 $2,004,325.45 $2,972,190.45 $2,973,839.08 $246,935.10 $5,558,551.10 $3,095,600.89 $1,662,950.29 109,856.81 15,620,121.01 9,740,632.31 5,879,289.50 $755,473.12 $35,771,401.12 $22,510,026.94 $13,260 0 574.18 $134,134.09 503,287.32 $8,063,150.09 $5,416,066.27 43,016,440.32 29,109,996.91 $2,647,086.82 13,908,443.41 $637,421.41 $51.,081,593.41 $04,526,063.16 $16,555.530.23 COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 01, 1990 DEPARTMENTS & INSTITUTIONS ADMINISTRATION OF JUSTICE CIRCUIT COURT ADMINISTRATION FRIEND OF THE COURT DISTRICT COURT DIVISION I (WALLED LAKE) DIVISION II (CLARKSTON) DIV III (ROCHESTER HILLS) DIVISION IV (TROY) PROBATE COURT TOTAL ADMIN. OF JUSTICE LAW ENFORCEMENT PROSECUTING ATTORNEY SHERIFF TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT CLERK/REGISTER OF DEEDS COUNTY TREASURER BOARD OF COMMISSIONERS LIBRARY BOARD DRAIN COMMISSIONER TOTAL GENERAL GOVERNMENT SOLID WASTE SERVICES. ADMINISTRATION COUNTY EXECUTIVE ADMINISTRATION AUDITING COMM Z., MINORITY AFFAIRS PUBLIC INFORMATION CORPORATION COUNSEL STATE & FEDERAL AID COORD. CULTURAL AFFAIRS $8,760,079.00 5,433,169.00 $14,194,047.00 $1,503,005.00 762,007.00 1,692,497.00 1,053,307,00 $5,311,616.00 15,510,265.00 $35,015,920.00 $7,929,019.00 42,515,153.00 $50,444,172.00 $5,642,102.00 2,265,335.00 1,012,130,00 1,209,024.00 3,660,936.00 $14,589,535.00 $905,320.00 542,949.00 80,670.00 94,004.00 1,071,021.00 75,822.00 138,143.00 $2,900,517.00 $1,171,977.51 551,573.10 1,208,039.40 964,010.88 $3,380,255.60 1,547,326.00 1,152,042.97 050,273.64 2,382,152.61 $606,887.20 350,189.59 60,251.04 66,149.76 707,669.31 47,129.11 86,997.09 $404,544.39 254,692.90 572,268.97 431,444.03 $2,361,260.75 777,225.07 735,078.58 354.436.44 1,455,595.05 $(1,649.63) $310,998.00' 205,547.57 25,157.10 20,235.24 377,124.29 29,692.09 64,670.94 59.13% 63.61% 60.81% 74.34% 68.41% 67.86% 69.08% -------- 70.00% 62.36% -------- '062.90% -------- 67,17% 67.67% -------- 6.7.59% -------- 50_87% 66.56% 61.06% 70.77% 62.07% -------- 62.12% -------- 100.06% -------- 66.12% 63.01% 70.54% 70.00% 65.24% 62.16% 57.36% 64.92% $415,011.02 $15,004.546.82 $9,320,950.93 $5,683,595.09 $1,925,272.90 $1,040,416.03 PREPARED BY ACCOUNTING DIVISION PAGE 6 BUDGET ADJUSTMENTS UNENCUMBERED BALANCE % OF YEAR ELAPSED 66.66% PERCENTAGE SPENT BUDGET AS ADJUSTED EXPENDITURES AND TRANSFERS BUDGET AS ADOPTED $1,745,608.91 $999,129.42 $991,030.31 $872,943.69 ' 11,566,591.73 , 7239,559.95 4,401,239.30 -.2145:103.31 6,149,306,44 ,..131,7,23,693.30 19,435,849.69 ;A%#2.2.599.31 525,457.50 CP4,?95-50 1,893,735.14' 856,760.38 ; !"79,535.34 , $45,320,778.49 $27,672,546.26 PREPARED BY ACCOUNTING DIVISION PAGE 7 COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 MANAGEMENT & BUDGET ADMINISTRATION BUDGET DIVISION ACCOUNTING DIVISION PURCHASING DIVISION EQUALIZATION DIVISION REIMBURSEMENT DIVISION CENTRAL SERVICES ADMINISTRATION SAFETY DIVISION MATERIALS MANAGEMENT PUBLIC WORKS ADMINISTRATION FACILITIES ENGINEERING DIV WATER & SEWAGE OPERATIONS PERSONNEL ADMINISTRATION EMPLOYEE RELATIONS HUMAN RESOURCES INSTITUTIONAL & HUMAN SER. ADMINISTRATION HEALTH DIVISION MEDICAL CARE FACILITY CHILDREN'S VILLAGE COMMUNITY MENTAL HEALTH • HUMAN SERVICES AGENCY SOCIAL SERVICES MEDICAL EXAMINER $218,590.00 795,213.00 4,605,400.00 524,636.00 3,380,659.00 953,170.00 $10,677,668.00 $734,785.00 1,513,742.00 177,750.00 $2,426,277.00 $354,299.00 1,077,429.00 $1,431,728.00 $213,525,00 1,211,112.00 1,191,392.00 $2,616,029.00 $1,804,054.00 18,454,359.00 6,476,735.00 9,551,301.00 32,020,056.00 717,453.00 3,420,653.00 1,400,178.00 $73,844,789.00 $42,026,45 99,662.62 47,058.96 263,423.34 93,997.21 $546,368.58 $13,968.03 10,658.36 5,407.00 $30,033.39 $13,776.04 25,741.40 56,980.00 $96,498.24 $40,761.33 17,079.00 70,869.00 $1 28,7 09-33 $60,720.00 451,792.68 69,607.61 321,898.74 (1,761,607.00) 6,125.72 $216,590.00 837,239.45 4,905,262.62 571,694.96 3,644,082.34 1,047,167.21 $11,224,036.58 $748,753.03 1,524,400.36 163,157.00 $2,456,310.39 $360,075.04 1,103,170.40 56,980.00 $1,528,226.24 $254,206.33 1,228,191.00 1,262,261.00 $2,744,738.33 $1,064,774.00 10,906,151.68 6,546.342.61 9,873,199.74 30,250,449.00 717,453.00 3.420,653.00 1,406,303.72 $76,388.00 593,073.33 3,203,065.99 366,094.45 2,296,516.18 735,561.46 $7,280,699.41 $497,629.89 1,013,262.90 112,332.08 $1,623,224.95 $224,822.09 710,752.10 56,980.00 $992,554.19 $180,874.42 015,500.50 749,233.99 $142,202.00 254,166.12 1,702,196.63 185,600.51 1,347,566.16 311,605.75 $3,943,337.17 $251,123.14 511,137.38 70,824.92 $833,085.44 $143,253.75 392,418.30 $535,672,05 $73,411.91 412 ,,690.50 513,027.01 34.95% 69.64% 65.30% 67.54% 63.02% 70.24% ------- 64.67% ------- 66.46% 66.47% 61.33% 66.08% ------- 61.08% 64.43% 100.00% ------- 6,4.95% 71.13% 66.40% 59.36% ------- 63.60% ------- 53.19% 61.18% 67.23% 62.28% 64.23% 73.24% 40.74% 60.92% ------- 62.09% $(851,462.25) $72,993,326.75 $10.000.00 $5,158.14 300,000.00 380,000.00 3,168,638.00 1,360,404.75 41,000.00 27,335.50 67,000.00 71,738.75 100,000.00 766,430.00 383,219.00 685,677.00 644,952.01 1,930,184.06 . 1,312,719.00 263,800.00 65,190.25 41,000.00 21,837.50 14,441.00 14,441.00 32,725.00 670821.00 $4,841.86 1 0 808,233.25 14,464.50 (4,738.75) 100,000.00 383,219.00 40,724.99 617,465.06 198,609.75 19,162.50 (35,096.00) $(250,000.00) 15,000.00 10,091.40 3,000.00 15,500.00 11,625.00 49,500.00 37,125.00 25,000.00 ' 18,750.00 35,750.00 17,075.00 1,000.00 1,000.00 1,000.00 1,000.00 4,908.60 ° 3,000.00. 3,875.00 12,375.00 6,250.00 17,875.00 383,219.00 (2240793.94) 193,063.00 $ $6,126.37 1,024,705.37 86,903.99 ,1,290,308.99 128,129.70 $ 611,821.57 735,043.13 64,933.22 4 12,803.80 554,465.86 1,032,282.08 $40,487,769.17 $75,985,820.84 $ 2,415,047.00 $ 93,030.36 $ 2,500,077.36 $ 1,475,794.48 $106,336,950.00 $(601,835.93) $105,735,114.07 $65,247,344.90 $206,554,450.00 $4,010,395.87 $210,564,845.87 $134,579,025.03 COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 % OF YEAR ELAPSED 66.66% UNENCUMBERED PERCENTAGE BALANCE SPENT PUBLIC SERVICES ADMINISTRATION VETERANS SERVICES DISTRICT COURT PROBATION COOPERATIVE EXTENSION EMS & DISASTER CONTROL ANIMAL CONTROL CIRCUIT COURT PROBATION COMPUTER SERVICES BUDGET AS ADOPTED $116,752.00 1,221,451.00 918,767.00 604,225.00 852,570.00 1,306,942.00 388,855.00 $5,409,562.00 BUDGET ADJUSTMENTS $5,462.89 63,685.28 32,596.18 53,638.93 40,904.43 7,307.72 $203,675.43 BUDGET AS ADJUSTED $116.752.00 1,226,913.89 982,452.20 636,921.18 906,203.93 1,347,926.43 396,162.72 EXPENDITURES AND TRANSFERS $70,613.66 782,347.19 643,128.94 404,671.14 559,899.82 937,355.16 286,465.10 $38,138.34 444,566.70 339,323.34 232,150.04 346,309.11 410,571.27 109,697.62 $1,920,756.42 $2,510,541.50 67.33% 63.77% 65.46% 63.55% 61.78% 69.54% 72.31% 65.78% 32.17% $5,613,237.43 $3,692,481.01 $4,607,333.00 .$(905,860.94) $3,701,472.06 $1,190,930.56 COMMUNITY & ECONOMIC DEV. ADMINISTRATION 193,063.00 - ECONOMIC DEVELOPMENT 1,018,579.00 -PLANNING DIVISION 1,203,405.00 TOTAL COUNTY EXECUTIVE TOTAL DEPT. & INSTITUTIONS • NON-DEPT. APPROPRIATIONS • AMBULANCE $10,000.00 BUDGETED PROJECTS 380,000.00 BUILDING AUTHORITY 3,418,638.00 DISTRICT COURT WITNESS FEES 41,800.00 INSURANCE & SURETY BONDS 67,000.00 YOUTH ACTIVITY CENTER 100,000.00 ECONOMIC DEVELOPMENT 383,219.00 CURRENT DRAIN ASSESSMENT 685,677.00 COUNTY BUILDINGS 2,154,978.00 COUNCIL OF GOVERNMENTS 263,800.00 AREA WIDE WATER DUALITY BD 41,000.00 NATIONAL ASSOC.OF COUNTIES 14,441.00 MICHIGAN ASSOC.OF COUNTIES 32,725.00 UNITED COUNTY OFFICERS ASSOC SANCTUARY 150000.00 4-H FAIR PREMIUMS 3,000.00 HISTORICAL SOCIETY 15,500.00 TOURIST & CONVENTION BUREAU 49,500.00 TRAFFIC IMPROVEMENT ASSOC. 25,000.00 AREA AGENCY ON AGING 35,750.00 CLINTON RIVER WATERSHED 1,000.00 HURON RIVER WATERSHED 1,000.00 66.37% 59.71% 57.03% -------- 58.84% -------- 61.71% -------- 63.91% 51.58% 100.00% 42.93% 65.40% 107.07% 50.00% 94.06% 68.01% 24.71% 53.26% 100.00% 207.25% 67.28% 75.00% 75.00% 75.00% 50.00% 100.00% 100.00% PREPARED BY ACCOUNTING DIVISION PAGE 8 NON-DEPT APPROPRIATIONS-CONT'D SOIL CONSERVATION ROUGE RIVER WATERSHED FRIENDS OF THE ROUGE RIVER OAKLAND COUNTY 4C COUNCIL SUNDRY EMPLOYEE'S DEFERRED COMP. CETA AUDIT-LEGAL EXPENSE CETA AUDIT-MISC. EXPENSE MISCELLANEOUS-CAPITAL OUTLAY CAPITAL IMPROVEMENT PROGRAM ROAD IMPROVEMENTS PROJECT WORK ORDERS PURPLE HEART OF U.S.A. SPECIAL CONTINGENCY RETIRED SENIORS VOL. PROG. RESERVED FOR TRANSFERS CAPITAL IMPROVEMENT PROGRAM CONTINGENCY SALARY ADJUSTMENT CLASSIFICATION & RATE CHANGE OVERTIME SUMMER EMPLOYMENT EMERGENCY SALARIES ADMIN. CONTINGENCY FEDERAL/STATE PROJECT MATCH CAPITAL OUTLAY DISABILITY INSURANCE . DISABILITY RESERVE 6,900.00 1,000.00 1,000.00 10,500.00 575,982.22 16,706.68 14,982.04 500,000.00 1,225,853,00 43,000.00 5,000.00 3,750.00 TOTAL GOVERNMENTAL FUNDS $218,852,921.00 $5,072,619.44 $223,925,440.44 $141,435,983.07 $6,856,950.04 $11,867,271.37 $5,010,313.33 75.00% 100.00% 100.00% 75.00% 230.39% 55.69% 71.35% 100.00% 99.16% 100.00% 100.00% 75.00% 57.70% 51,32% 63.16% COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 EXPENDITURES AND TRANSFERS % OF YEAR ELAPSED 66.66% UNENCUMBERED PERCENTAGE BALANCE SPENT $6,056,950.04 BUDGET AS ADOPTED 9.200.00 1,000.00 1,000.00 14,000.00 250,000.00 30,000.00 . 1,000,000.00 5,000.00 . $9,049,228.00 $500.000.00 1,407,624.00 110,000.00 75,000.00 387,000.00 440,000.00 100,000.00 49,519.00 1E40,000.00 850,000.00 (850,000.00) $3,249,143.00 BUDGET ADJUSTMENTS 21,000.00 4,000.00 8,746.00 500,000.00 236,243.00 43,000.00 5,000.00 2,091,629.31 $2,818,043.37 $(250,000.00) (624,389.00) (30,643.00) (33,438.80) (206,984.00) (317,225.00) (49,680.00) ( 11,111.00 ) -(52,349,00) $1,062,223.57 BUDGET AS ADJUSTED 9,200.00 1,000.00 1,000.00 14,000.00 250,000.00 30,000.00 21,000,00 4,000.00 . 8,746.00 500,000.00 1,236,243.00 43,000.00 5,000.00 2,091,629.31 5,000.00 $250,000.00 783,235.00 . 79,357.00 . 41,561.20 16.00 122,775.00 50,320 .0O 30,408.00 127.651.00 850,000.00 (850,000.00) $13,360,594.57 2,300.00 3,500,00 (325,982.22) 13,293.32 6,017.16 4,000.00 8,746.00 10,390.00 2,091,629.31 1,250.00 $250,000.00 783,235.00 79,357.00 41,561.20 16.00 122,775.00 50,320.00 38,408.00 127,651.00 850,000.00 (850,000.00) $1,493,323.20 $6,503,636.53 $82,489,457.37 TOTAL NON-DEPT APPROPRIATIONS $12,290,371.00 $(1,755,019.00) $1,493,323.20 PREPARED BY ACCOUNTING DIVISION PAGE 9 $12,254,033.00 $12,254,033.00 COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 % OF YEAR ELAPSED 66.66% UNENCUMBERED PERCENTAGE BALANCE SPENT PROPRIETARY & SPEC REV. FUNDS ADMINISTRATION OF JUSTICE SKILLMAN FOUNDATION TOTAL ADMIN. OF JUSTICE LAW ENFORCEMENT PROSECUTOR-COOPERATIVE REIN PROSECUTOR-ANTI DRUG SHERIFF-ANTI DRUG SECONDARY ROAD PATROL AUTO THEFT PREV.-SHERIFF AUTO THEFT PREV.-PROSECUTOR COMMISSARY FUND TOTAL LAW ENFORCEMENT GENERAL GOVERNMENT DRAIN COMMISSIONER MICROFILM & REPRODUCTIONS LIBRARY BOARD TOTAL GENERAL GOVERNMENT BUDGET AS ADOPTED $162,000.00 $162,000.00 $916,119.00 172,158.00 69,378.00 766,448.00 761,942.00 149,703.00 243,087.00 $3,078,835.00 $17,078,089.00 131,922.00 54,760.00 $17,265,571.00 BUDGET ADJUSTMENTS $66,337.00 12.00 (5,047.00) (100,246.00) 5,437.00 $(33,507.00) BUDGET AS ADJUSTED $162,000.00 $162,000.00 $982,456 .00"°. 172,170.00 64,331.00 766,446.00 661,696.00 155,140.00 243,087.00 $3,045,328.00 $17,078,089.00 131,922.00 54,760.00 $17,265,571.00 EXPENDITURES AND TRANSFERS $92,173.36 $92,173.36 $631,711.71 e5,087.68 34,641.09 316,820.82 358,927.16 02,581.11 155,743.24 $1,665,512.01. $10,582,678.09 37,077.50 1,922.40 $10,621,677.99 $69,826.64 $69,826.64 $350,744.29 87,002.32 29,689.91 449,627.18, 302,760.04 72,558.89 87,343.76 .$1,379,015.19 $6,496,210.91 94,044.50 52,837.60 56.90% 56.90% • 64.30% 49.42% 53.85% 41.34% 54.24% 53.23% 64.07% 54.69% 61.96% 28.11% ,3.51% $6,643,893.01 61.52% MANAGEMENT & BUDGET )(EQUIPMENT FUND CENTRAL SERVICES PARKS & RECREATION AVIATION DIVISION )(MATERIALS MANAGEMENT XLEASED VEHICLES )(PRINT SHOP NRADIO COMMUNICATIONS FOOD SERVICES $3,300.00 $9,739,040.00 1,815,951.00 211,980.00 172,200.00 42,200.00 7,750.00 264,912.00 $3,300.00 $9,739,040.00 1,815,951.00 211,980.00 172,200.00 42,200.00 7,750.00 264,912.00 $2,689.90 $5,604,060.91 1,035,067.03 149,098.71 141,905.99 37,077.50 9,784.88 183,104.12 $7,160,099.14 $610.10 $4,134,179.09 780,803.97 62,881.29 30,294.01 5,122.50 (2,03488) - 81,807.88' $5,093,133.86 81.51% 57.55% 57.00% 70.34% 82.41% 87.86% 126.26% 69.12% 50.44% PREPARED BY ACCOUNTING DIVISION PAGE 10 DUD GET • ADJUSTMENTS COMPUTER SERVICES )(OPERATIONS TOTAL COMPUTER SERVICES COUNTY OF OAKLAND' STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 PUBLIC WORKS )(MAINTENANCE & OPERATIONS )(TELEPHONE COMMUNICATION )(MARKETS WATER & SEWER EQUIPMENT FO. WATER & SEWER OPERATIONS BUDGET AS ADOPTED $1,204,797.00 274,166.00 245,448.00 19,408,009,00 BUDGET AS ADJUSTED $1,204,797.00 274,166.00 245,448.00 19,408,009.00 EXPENDITURES AND TRANSFERS $893,483.10 226,867.91 158,995.93 361,513.79 11,741,124.02 % OF YEAR ELAPSED 66.66% UNENCUMBERED PERCENTAGE BALANCE SPENT $311,313.90 74.16% 45,290.09 83.46% 86,552.07 64.74% (361,513.79) 7.666,884.98 60.50% $21,132,420.00 $21,132,420.00 $13,383,864.75 $7,748,535.25 63.33% - INSTITUTIONAL & HUMAN SERV. MEDICAID SCREENING FAMILY PLANNING GRANT W.I.C. GRANT 5.1.0. SYNDROME GRANT 0.S.A.S. GRANT . HYPERTENSION GRANT CHILDREN'S HEALTH SERVICES ' INFANT MORTALITY T.B. OUTREACH GRANT MCH BLOCK GRANT AIDS TESTING HIV SURVEY GRANT MIC/IHIP LOCAL PRENATAL COORDINATION ADOPTIVE SERVICES HOMELESS ASSISTANCE MICHIGAN BICYCLE HELMET PUBLIC SERVICES VETERAN'S TRUST PROBATION ENHANCEMENT PROBATION END-I. DIS. GRANT PROBATION COMM. CORRECTION JOB TRNG. PARTNERSHIP ACT $910,507.00 374,561.00 696,665.00 8,000.00 2,529,898.00 85,571.00 232,973.00 249,825.00 38,609.00 151,270.00 271,541.00 34,346.00 111,255.00 01,692.00 33,769.00 174,491.00 $5,984,973.00 $319,645.00 67,000.00 96,000.00 6,605,549.00 $931,324.00 (1,357.00) (59,563.00) 62,175.00 12,412.00 $40,000.00 $910,507.00 374,561.00 696,665.00 8,000.00 3,461,222.00 85,571.00 232,973.00 249,825.00 37,252.00 151,270.00 211,978.00 , 34,346.00 111,255.00 01,692.00 33,769.00 236,666.00 12,412.00 $319,645.00 67,000.00 96,000.00 40,000.00 6,605,549.00 $551,898.76 193,113.59 443,414.23 4,092.00 1,856,939.32 47,959.78 153.228.64 116,659.42 23,912.60 95,510.39 94,438.49 54,678.66 56,219.45 44,915.54 927.34 77,168.59 11,187.50 $3,816,164.30 . $241,849.20 33,053.60 76,064.46 3,162,607.01 $358,608.24 181,447.41 253,250.77 3,908.00 1,604,282.68 37,611.22 79,744.36 133,165.56 13,339.40 65,759.61 117,539.51 (20,332.66) 55,035.55 36,976.46 32,041.66 159,497.41 1,224.50 $3,113,799.70 $77,795.80 33,946.32 19,935.54 40,000.00 9,442,94 1-99 ' 60.61% 51.56% 63.65% 51.15% 53.65% 56.05% 65.77% 46.70% 64.19% 56.53% 44.55% 159.20% 50.53% ' 54.86% '2.75% 32.61% 90.13% 55.07% 75.66% . 49.33% 79.23% 47.66% $944,991.00 $6,929,964.00 $7,088,194.00 $1,089,061.00 $1,089,061.00 $40,000.00 $7,128,194.00 $1,089,061.00 $1,089,061.00 $3,513,574.35 $926,622.76 $920,822.76 $3,614,619.65 $160,238.24 $160,239.24 49.29% 85.29% 85.29% PREPARED BY ACCOUNTING DIVISION PAGE 11 BUDGET AS ADOPTED BUDGET ADJUSTMENTS PREPARED BY ACCOUNTING DIVISION PAGE 12 COUNTY OF OAKLAND STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1990 % OF YEAR ELAPSED BUDGET EXPENDITURES 66.66% AS AND UNENCUMBERED PERCENTAGE ADJUSTED TRANSFERS BALANCE SPENT COMMUNITY & ECONOMIC DEV. COMMUNITY DEVELOPMENT SMALL BUSINESS CENTER AREA DEVELOPMENT OFFICE $ 9,334,802.00 $ 9,334,882.00 $ 2,567,333.21 $ 6,767,548.79 27.50% 118,550.00 $(13,550.00) 105,000.00 74,500.73 30,491.27 70.96% 113,150.00 (17,150.00) 96,000.00 71,733.76 24,266.24 74.72% $9,566,582.00 $(30,700.00) $9,535,682.00 $2,713,575.70 • $6,822,306.30 28.46% TOTAL SPECIAL REVENUE AND PROPRIETARY FUNDS $77,624,969.00 $920,784.00 $78,545,753.00 $43,898,975.06 $34,646,777.94 55.89% GRAND TOTAL - ALL FUNDS *INTERNAL SERVICE FUNDS- NON-COUNTY EXPENDITURES ,$296,477,790.00 $5,993,403.44 $302,471,193.44 $185,334,958.13 $117,136,235.31 61.27% 9,360.00 100,000.00 51,678.00 448.00 2,634.00 9,360.00 100,000.00 51,678.00 (17,150.00) 5,437,00 448.00 2,634.00 (17,150.00) 5,437.00 1990 BUDGET AMENDMENTS GOVERNMENTAL SPECIAL REVENUE TOTAL FUNDS FUNDS FUNDS $77,624,969,00 $296,477,790.00 (1,357.00) (1,357.00) 12.00 12.00 (59,563.00) (59,563.00) (5,047.00) (5,047.00) 1990 ADOPTED BUDGET $218,852,821.00 BUDGET AMENDMENTS: H.R. 189239 - DATED 9/28/89 HEALTH - TB OUTREACH GRANT ACCEPTANCE H.R. #89272 - DATED 10/26/89 PROSECUTOR - ANTI-DRUG GRANT ACCEPTANCE H.R. 189299 - 11/30/89 HEALTH - AIDS TESTING GRANT ACCEPTANCE MR. #89288 - 21/30/8 9 SHERIFF - SOUTHEAST MICHIGAN MAJOR DRUG CONSPIRACY GRANT ACCEPTANCE H.R. 189320 - 12/14/8 9 COLDIUNITY MENTAL HEALTH - HOMELESS ASSISTANCE GRANT ACCEPTANCE 62,175.00 62,175.00 H.R. #90008 - DATED 7/8/90 PROSECUTING ATTORNEY - USE OF FORFEITED FUNDS H.R. 190002 - DATED 2/8/90 COMMUNITY MENTAL HEALTH - ARAB/ CuALDEAN PROGRAM ACCEPTANCE H.R. 189320 - DATED 17/14/89 SHERIFF'S DEPT. - ONE ADDITIONAL DEPUTY POSITION - LAw ENFORCEMENT PATROL SERVICES - OAKLAND TOWNSHIP H.R. 190009 - DATED 2/8/90 ECONOMIC DEVELOPMENT - AREA DEVELOPMENT OFFICE ACCEPTANCE H.R. #90007 - DATED 2/8/90 PROSECUTING ATTORNEY - AUTO THEFT PREVENTION GRANT ACCEPTANCE H.R. 190028 - DATED 2/22/90 HEALTH - DNR SOLID WASTE REIMBURSE- MENT AGREEMENT H.R. 190029 - DATED 2/22/90 HEALTH - DNR HAZARDOUS HASTE REIM- BURSEMENT AGREEMENT M.R. 190030 - DATED 2/22/90 HEALTH - BICYCLE HELMET PROJECT ACCEPTANCE 12,412.00 12,412.00 (13,550,00) (13,550.00) 66,117.00 66,337.00 (67,971.00) 615.00 (67,971.00) 615.00 1,546,206.00 3,546,206.00 40,709.00 40,709.00 (2,147,678.00) (2,147,678.00) 2,809,094.00 34,452.00 (100,246.00) 34,590.00 37,206.00 (100,246.00) 34,590.00 37,206.00 2,809,094.00 34,452.00 1990 BUDGET AMENDMENTS GOVERNMENTAL SPECIAL REVENUE TOTAL FUNDS FUNDS FUNDS 81.R.190042 - DATED 3/8/90 SHERIFF'S DEPT. - CONTRACT FOR PARKS PATROL M.R. 190014 - 2/22/90 SOLID WASTE - ACT 641 SOLID WASTE PLANNING GRANT ACCEPTANCE H.R. 190031 - 2/22/90 ECONOMIC DEVELOPMENT - SMALL BUSINESS DEV GRANT ACCEPTANCE M.R. 490033 - 7/22/90 PROSECUTOR - COOPERATIVE REIMBURSEMENT CONTRACT ACCEPTANCE H.R. 190058 - DATED 3/72/90 1989 CARRY FORWARD AND ENCUMBRANCES M.R. 190060 - DATED 1/22/90 DRAIN COMM. - ADDITIONAL CIVIL ENGINEER H.R. 190045 - DATED 3/22/90 COMMUNITY MENTAL HEALTH - REDUCTION IN STATE APPROPRIATION M.R. 190058 - DATED 3/22/90 1989 CARRY FORWARD FOR SPECIAL CONTINGENCY H.R. 189320 - DATED 12/14/89 SHERIFF - ONE ADDITIONAL DEPUTY POSITION - LAW ENFORCEMENT PATROL SERVICES-BRANDON TWP. M.R. 190064 - DATED 4/5/90 SHERIFF - AUTO THEFT PREVENTION GRANT ACCEPTANCE M.A. 189328 - DATED 12/14/89 SHERIFF - ONE ADDITIONAL DEPUTY POSITION - LAW ENFORCEMENT PATROL SERVICES - INDEPENDENCE TWP. M.R. 190074 - DATED 4/26/90 REIMBURSEMENT DIVISION - TWO 14,995.00 (1,767.00) 40,000.00 14,995.00 (1,767.00) 40,000.00 933,324.00 128,526.00 25,000.00 (260,100.00) 178,526.00 25,000,00 (260,100.00) 931,324.00 116,000.00 3,042.00 105,315,00 116,000,00 3,042.00 105,3)5.00 13,851.00 13,851.00 16,658.00 16,658,00 1990 BUDGET AMENDMENTS GOVERNMENTAL SPECIAL REVENUE TOTAL FUNDS FUNDS FUNDS ADDITIONAL POSITIONS H.R. 190072 - DATED 4/26/90 . SHERIFF - VIDEO INCIDENT CAPTURE H.R. 190110 - DATED 5/24/90 DRAIN COMMISSIONER - REORGANIZATION MR. 190088 - DATED 5/24/90 COMMUNITY RENTAL HEALTH - CAMBRIDGE HOUSE H.R. 190087 - DATED 5/24/90 COMMUNITY MENTAL HEALTH - TRANSFER OF SUPPORTIVE EMPLOYMENT SERVICES H.R. 190105 - DATED 6/14/90 COMMUNITY MENTAL HEALTH - AMENDMENT TO SPECIALIZED SUPP. INDEPENDENCE H.R. 190114 - DATED 6/14/90 52911 DISTRICT COURT - ADDITION OF TWO DISTRICT COURT CLERKS, TWO CERTIFIED ELECTRONIC OPERATORS AND INCREASED HOURS FOR THO MAGISTRATES H.R. 190128 - DATED 6/14/90 HEALTH DIVISION - REIMBURSEMENT FOR VENEREAL DISEASE TESTING 190129 - DATED 6/14/90 HEALTH DIVISION - REIMBURSEMENT FROM MICH, DEPT OF SOCIAL SERVICES FOR FOSTER HOMES SERVICES M.R. 190143 - DATED 6/28/90 CIRCUIT COURT PROBATION - ACCEPTANCE OF TECHNICAL ASSISTANCE FUNDING H.R. 190172 DATED 7/19/90 COMMUNITY MENTAL HEALTH - CHAMBERLAIN HOUSE PROGRAM H.R. 190169 - DATED 7/19/90 PRIOR YEARS RESOURCES CETA AUDIT LEGAL FEES H.R. 190191 - DATED 7/19/90 CHILDREN'S VILLAGE - 1990/91 WATERFORD SCHOOL DISTRICT CONTRACT H.R. 090176 - DATED 7/19/90 67,236.00 67,236.00 21,410.00 21,420.00 48,769.00 48,769,00 186,000,00 186,000.00 13,746.00 13,746.00 92,654.00 92,654.00 1990 BUDGET AMENDMENTS GOVERNMENTAL SPECIAL REVENUE TOTAL FUNDS FUNDS FUNDS HEALTH DIVISION - 1989/90 SUBSTANCE ABUSE AMENDMENT M.P. 189328 - DATED 12/14/89 SHERIFF -ONE ADDITIONAL DEPUTY TI POSITION - LAW ENFORCEMENT PATROL SERVICES - HIGHLAND TM?. M.R. 190188 DATED 8/9(90 HEALTH DIVISION - COMPLIANCE AUDIT FUNDING MA 190111 - DATED 8/9/90 . DISTRICT COURT PROBATION - ADDITION OF TWO PROBATION OFFICERS AND ONE TYPIST POSITION H.R. 190177 - DATED 8/9/90 CIRCUIT COURT - CIVIL MEDIATION M.R. /90187 - DATED 8/9/90 PRIOR YEARS RESOURCES - BUDGET DIVISION OFFICE SYSTEM M.R. 190197 - DATED 8/30/90 DRAIN COMMISSIONER - ADDITION OF TEN CONSTRUCTION INSPECTOR POSITIONS M.R. 190 - DATED 6/30/90 PRIOR YEAR RESOURCES - HEALTH DIVISION OFFICE SYSTEM 29,649.00 29,649.00 212.00 212.00 AMENDED BUDGET AS OF 8/31190 $223,925,440.00 $78,545,753.00 $302,471,193.00 PREPARED BY BUDGET DIVISION BUDGETTHREE AMENDMENT 90 SEPTEMBER 11, 1990 210,631.00 27,702,00 5,510.00 210,531.00 27,702.00 5,510.00 5,760.00 5,760.00 100,000.00 72,259.00 61,947,00 (67,045,00) 51,108.00 23,400.00 56,510,00 72,259.00 100,000.00 72,259.00 61,947.00 (67,045,00) 51,100.00 23,400.00 •56,510.00 72,259.00 1991 BUDGET AMENDMENTS GOVERNMENTAL SPECIAL REVENUE TOTAL FUNDS FUNDS FUNDS 1991 ADOPTED BUDGET $232,183,645.00 BUDGET AMENDMENTS: 900,946,007.00 9313,130,452,00 H.R. 890000 - DATED 7/8/90 PROSECUTING ATTORNEY - USE OF FORFEITED FUNDS H.R. 190007 - DATED 2/8/90 COMMUNITY MENTAL PEALTH - ARAB/ CHALDEAN PROGRAM ACCEPTANCE M.R. 889328 - DATED 12/14/89 SHERIFF - ONE ADDITIONAL SERGEANT POSITION - LAW ENFORCEMENT PATROL SERVICES - OAKLAND TM?. H.R. 109328 - DATED 12/14/89 SHERIFF - ONE ADDITIONAL DEPUTY POSITION - LAW ENFORCEMENT PATROL SERVICES - INDEPENDENCE TWP. H.R. 190042 - DATED 3/8/90 SHERIFF - CONTRACT FOR PARKS PATROL M.R. 189328 - DATED 4/26/90 REIMBURSEMENT DIVISION - Two ADDTIONAL POSITIONS 11.0, #90072 - DATED 4/26/90 SHERIFF - VIDEO INCIDENT CAPTURE M.R. 190060 - DATED 3/22/90 DRAIN COMMISSIONER - ADDITIONAL CIVIL ENGINEER H.R. 189328 - DATED 12/14/89 SHERIFF - ONE ADDITIONAL SERGEANT POSITION - LAW ENFORCEMENT PATROL SERVICES - BRANDON TWP, M.R. 190008 - DATED 5/74/90 COMMUNITY MENTAL HEALTH - CAMBRIDGE HOUSE M.R. 190087 -DATED 5/24/90 COMMUNITY MENTAL HEALTH - TRANSFER OF SUPPORTIVE EMPLOYMENT SERVICES M.R. 190110 - DATED 5/24/90 DRAIN COMMISSIONER - REORGANIZATION 28,557.00 125,347.00 128,526.00 90,919.00 21,410.00 548,00 289,364,00 61,947.00 495,000,00 636,00 28,557.00 125,347.00 39,364.00 128,526.00 90,919.00 1991 BUDGET AMENDMENTS covERNmENTAL spEcIAL REvENHE TOTAL Funs FUNDS FUNDS 11.8. 190105 - DATED 6/14/90 commuNiTy MENTAL HEALTH - AMENDMENT TO SPECIALIZED SUER. INDEPENDENCE H.R. 190114 - DATED 6/14/90 52ND DISTRICT COURT - ADDITION OF TWO DISTRICT COURT CLERKS, TWO CERTIFIED ELECTRONIC OPERATORS AND INCREASED HOURS FOR Two MAGISTRATES H.R. 190113 - DATED 6/14/90 JAIL comMISSARY FUND - ADDITION OF COMMISSARY SUPERVISOR POSITION MR 190172 - DATED 7/19/90 COMMUNITY MENTAL HEALTH - crAmBERLAIN rousE PROGRAM M.R. 190111 - DATED 8/9/90 DISTRICT COURT PROBATION -ADDITION OF TWO PROBATION OFFICERS AND ONE TYPIST M.R. #90I88 - DATED 8/9/90 HEALTH DIVISION - COMPLIANCE AUDIT FUNDING H.R. 190187 - DATED 6/9/90 PRIOR YEAR RESOURCES FOR BUDGET Dlv H.R. 190 - DATED 8/30/90 DRAIN COMMISSIONER -ADDITION OF TEN CONSTRUCTION INSPECTOR POSITIONS H.R. 189328 - DATED 6/26/90 SHERIFF - ONE ADDITIONAL DEPUTY II POSITION - LAW ENFORCEMENT PATROL SERVICES - HIGHLAND TRp. H.R. 190177 - DATED 8/14/900 CIRCUIT COURT MEDIATION H.R. 19090 - DATED 8/30/90 PRIOR YEAR RESOURCES - HEALTH DIVISION OFFICE SYSTEM 39,364.00 548.00 289,364.00 61,947.00 495,000.00 636.00 21,410.00 PREPARED By BUDGET DIVISION suDGETTHREE AHENDmENT91 SEPTEMBER II,. 1990 AMENDED BUDGET AS OF 8/31/^0 6234,045,940.00 $80,986 ,1 7 1.00 8315,07,2,111.00 OAKLAND COUNTY, MICHIGAN 1990 THIRD QUARTER AMENDMENTS ATTACHMENT 'A' 4-10100-311-01-00-6540 4-10100-214-01-00-6540 CIRCUIT COURT - ADM-MICROFILM REGITER OF DEEDS-MICROFILM 14,600 11,000 324,665 (12,000) 1,600 137,665 9,500 32,500 23,000 -rNrrIvormnLr. our TO PACKLOG AND INCREASE IN CRIMINAL CASELOAD 60,000 112,500 50,500 -INCREASE DUE TO CASELOAD INCREASE 91,500 OVERTIME DEFENSE ATTORNEY FEES LINE-ITEM NUMBER REVENUES 1990 AMENDED BUDGET pRoonsro nrrNoco BUDGET ADJUSTMENT COMMENTS ACCOUNT NAME 3-10100-903-01-00-9306 3-10100-906-31-00-2233 3-10100-322-01-00-2366 EXPENDITURES CIRCUIT COURT 4-10100-311-05-00-1001 4-10100-31LT:05-00-2074 4-10100-31105-00-3050 4-10100-311-05-001175 TOTAL CIRCUIT COURT STATE INCOME TAX INVESTMENT INCOME DISTRICT COuRT-WALLED LAKE TOTAL REVENUE SAIARIES • FRINGES DEFENSE ATTORNEY FEES TRANSCRIPTS ON APPEALS 12,877,000 13,077,003 11,420,000 11,606,924 001,336 002,836 200,003 -BASED ON STATE DEPT. OF TREASURY ESTIMATES 106,024 -INCREASED VOLUME OE INVESTABLE FUNDS 81,500 -INCREASED CASELOAD AND ACTIVITY $460,324 320,300 2,109,761 2,167,761 (21,000) -INCREASED OPERATING DUE TO cAsELonn INCREASE 796,745 701,045 (15,700) PARTIALLY OfFSET nr TURNOVER 170,000 470,000 300,000 95,600 160,600 65,000 0 DISTRICT COURTS DIVISION I-UALLED LAKE 4-10100-322-01-03-1002 4-10100-322-01-00-3050 TOTAL DISTRICT COURTS PROSECUTING ATTY, 4-10100-411-01-03-1031 4-10100-411-01-00-1002 4-10100-411-01-00-3140 4-10100-411-01-00-3297 4-10100-411-01-00-3340 4-10100-411-01 -00-3151 4-10103-411-01-00-3752 TOTAL PROSECUTING'ATTOONEY SALARIES OVERTIME EXTRADITION EXPENSE conRT TRANSCRIPTS FOHIPNINT RFNTAT(OuTSIDE) TITLING FEES TRAwL & coNFERENCrx 4,490,273 4,342,473 50,000 90,600 135,000 205,000 45,375 59,075 41,000 52,300 11,500 19,500 21,930 26,930 (1 4 7,900) -TURNOVER OFFSET BY EXTRADITION RELATED EXPENSES. 40,600 NuNITER OF EXTRADITIONS INCREASED 19% AND AVERAGE 70,000 cov PER EXTRADITION INCREASED 74/ OVER vro. 13,700 10,500 0,000 5,000 $0 xTRANSFER REQUESTED BY DEPARTMENT ny ffmo OAKLAND COUNTY, MICHIGAN 1990 THIRD QUARTER AMENDMENTS 1990 prornRED AMENDER AMENDED LINE-ITEM NUMBER ACCOUNT NAME BUDGET nmDGET ADJUSTMENT COMMENTS DRAIN COMMISSIONER 4-10100-611-01-00-1001 SALARIES 2,346,955 2,229,955 (119,000) -SALARIES FAVORABLE DUE TO TURNOVER 4-10100-611-01-00-1002 OVERTIME 60,000 170,000 112,000 -MRTIME UNFAVORARII:. DUE TO VACANT POSITIONS TOTAL DRAIN COMMISSIONER $0 COUNTY EXECUTIVE 4-10110-111-01-00-3746 TRANSPORTATION 0 5,100 5,101 -FAVORABLE TURNOVER OFFSET PY LEASED VEHICLE 4-10100-111-05-00-1001 SALARIES 196,424 192,924 (3,600) EXPENSES 4-10100-111-05-00-2074 FRINGES 139,014 87,514 ( I ,500) PUBLIC INFORMATION 4-10100-114701-00-3502 CONTRACTUAL PRINTING . 5,120 6,073 1,753 -DUE TO ADDITIONAL PAGES FOR COUNTY NEWSLETTER TOTAL COUNTY EXECUTIVE 1,753 PUBLIC WORKS 4-10100-141-01-00-3525 DPW/ABM-MICROFILM 5,650 32,650 27,fm -14 & 5 EQUIPMENT FAVORABLE DUE TO PROJECTS 4-10100-141-10-00-6300 DPW/W&S EQUIPMENT 0 (27,000) (I!!.00o: OFFSET 91 MICROFILMING -w., ,;.,m 4-10100-142-01-00 -0665 W & 5 TRANSFER OUT-MOTORPOOL 52,600 67,600 15,'P0 -cliN05 AVAILABLE IN FACILITIES ENGINEERING 4-10100-149-01-00-1001 ENGINEERING SALARIES 52,680 37,600 (15,1m) 3ALARILIS OFFSETS BALANCE CF FUNDS NEEDED TO PURCHASE TRUCK AND CRANE APPROVED PER TOTAL PUBLIC WORKS $0 M.1(.1190105 PERSONNEL 4-10100-155-01-00-3423 INTERN PROGRAM 100,010 115,000 15,000 -A REQUEST FOR THE INTERN PROGRAM WILL DE OFFSET 4-10100-909-01-00-9905 EMERGENCY SALARIES 90,320 90,920 (7,500) nY FAVORABILITY IN EMERGENCY SALARIES AND RATE 4-10100-909-01-00-9902 RATE & CLASSIFICATION 79,357 71,057 (7,500) AND CLASSIFICATION CHANGE TOTAL PERSONNEL $0 PUBLIC SERVICES CIRCUIT COURT PROBATION 4-10100-179-01-00-3728 TRAINING & PSY, TESTING 22,000 26,001 14,000 -INCREASE DRUG TESTING COSTS CUE TO CASELOAD INCREASE AND RATE INCRTA7. TOTAL PUBLIC SERVICES 14,000 LINE-ITEM NUMBER NON-DEPARTMENTAL 4-10100-901-01-00-9104 4-10100-903-01-00-9302 4-10100-903-01-00-9334 TOTAL NON-DEPARTMENTAL TOTAL EXPENDITURES x NEW ACCOUNT ACCOUNT NAME INSURANCE & SURETY OOND AREA WIDE WATER QUALITY BOARD MICHIGAN ASSOC. OF COUNTIES OAKLAND COUNTY, MICHIGAN 1990 THIRD QUARTER AMENDMENTS ...... ,,,,,, 1990 PROPOSED AMENDED AMENDED BUDGET nunGET ADJUSTMENT COMMENTS 67,000 72,000 5,000 -UNFAVORABLE DUE TO INCREASE IN PROPERTY INSURANCE PREMIUM DUE TO INCREASED VALUATION 41,000 43,675 2,675 -ACTUAL BILLING INCREASE RAGED ON INCREASED SEWAGE FLOWS 32,725 67,021 35,096 -PAYMENT INCLUDES TWO YEARS MEMBERSHIP 1909-1993 42,771 $460,324 MIDGET II MTHIRDAMEND NOVEMBER 5 0 1990 ATTACHMENT 'B' COMPUTER SERVICES OPERATIONS' ;;; 1990 THIRD QUARTER BUDGET ADJUSTMENT ACCOUNT NUMBER DEPT./DIVISION 41010011101006360 COUNTY EXECUTIVE 41010011201006360 AUDITING 41010011501006360 CORPORATION COUNSEL 41010011801006360 CULTURAL AFFAIRS 41010012201006360 BUDGET DIVISION 41010012301006360 ACCOUNTING 41010012401006360 PURCHASING 41010012501006360 EQUALIZATION 41010012701006360 REIMBURSEMENT 41010013201006360 BUILDING SAFETY 41010013850006360 MATERIALS MANAGEMENT 41010014101306360 DPW ADMINISTRATION 41010014801006360 FACILITIES ENGINEERING 41010015401006360 PERSONNEL-HUM. RES. 41210015501036360 PERSONNEL-EMP. REL. 41010016901006360 MEDICAL EXAMINER 41010017301006360 VETERANS SERVICES 41010017401006360 DIST. COURT PROBATION 41010017501006360 COOP. EXTENSION SERVICE 41010017901006360 CIRCUIT COURT PROBATION 41010018101006362 COMP. SERV.-CLEMIS OPER. 41010019101006360 COMM. & ECON. DEV. ADM. 41010019201006360 ECONOMIC DEVELOPMENT 41010019501006360 PLANNING DIVISION 41010021210006360 COUNTY CLERK 41010021301006360 ELECTIONS 4 1010021501006360 JURY COMMISSION 41010022101006360 TREASURER 41010031101006360 CIRCUIT COURT ADM. 41010032201006360 DISTRICT COURT DIV. I 41010032301006360 DISTRICT COURT DIV. II 41010032401006360 DISTRICT COURT DIV. III 41010032501006360 DISTRICT COURT DIV. IV 41010034122006360 PROBATE COURT 41010034401006360 PROBATE COURT 41010041101006360 PROSECUTING ATTORNEY 41010043310006360 SHERIFF 41010051101006260 BOARD OF COMMISSIONERS 41010051102006360 BD. OF COMM. PROG. DIAL. 41010051301006360 REFERENCE LIBRARY 41010051302006360 LAW LIBRARY 41010061101006360 DRAIN COMMISSIONER 42150012355006360 ALIMONY ACCOUNTING 42150031201006360 FRIEND OF THE COURT 42210016201006360 HEALTH DIVISION 42210017701006360 EMS 42210017801006360 ANIMAL CONTROL 42923016501006360 CHILDREN'S VILLAGE 42923016555006360 CHILDREN'S VILL. SCHOOL 45210016301006360 MEDICAL CARE FACILITY BUDGET ADJUSTMENT ---------- $ (11,126) 9,378 1,120 238 26,556 (11,717) 2 3,909 (27,489) 63,926 (5,852) (5,000) 356 (14,000) 6,778 13,947 (735) (4,671) 2,133 3,115 (10,849) (35,104) (300) (4,905) 75 (64,829) (1,950) (10,554) 31,342 13,790 46,616 22 ,621 49,448 35,371 (2,500) (25,388) 111,884 (34,956) 1,562 (112) (889) (7,200) 8,527 6,593 (64,342) (123,253) 3,086 (654) (7,751) 278 607 TOTAL 0