HomeMy WebLinkAboutResolutions - 1992.11.19 - 21041November 19, •1992
MISCELLANEOUS RESOLUTION #92264
BY: FINANCE COMMITTEE, DR. G. WILLIAM CADDELL, CHAIRPERSON
IN RE: MANAGEMENT & BUDGET - 1992 THIRD QUARTER 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 & Budget indicates the County will end 1992 with a
Governmental Fund balance of $2,414,095 (favorable revenue of
$229,495 and favorable expenditure of $2,184,600); and
WHEREAS the Third Quarter Forecast estimates unfavorable
revenue variances in Investment Income, 52nd District Courts,
Children's Village and Community Mental Health partially offset by
favorable variances in Clerk/Register of Deeds, Treasurer, Child
Care Subsidy, and Sheriff; and
WHEREAS the Third Quarter Forecast estimates favorable
expenditure variances in Community Mental Health, Health Division,
Future Space Requirements, Social Services and 52nd District Courts
partially offset by unfavorable variance in Probate Court and Tax
Tribunal Appeals; and
WHEREAS the 1992 General Appropriations Act, Section 16,
states 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 the Circuit Court, Prosecutor's Office, Drain
Commissioner, Facilities Engineering, Health Division and Computer
Services expenditure budgets are projected to be within total
budget appropriation at year end but not within the control
category appropriation, thus requiring a transfer of funds between
categories in order to comply with the General Appropriations Act
(see Schedule A); and
WHEREAS the Probate Court and Institutional & Human Services
Administration are projected to exceed the total expenditure
appropriation at year end and have requested additional funding
(see Schedule A); and
WHEREAS the Sheriff, Treasurer, Reference Library, Solid Waste
Management expenditure budgets are, projected to exceed the total
appropriation at year end and which is offset by favorable revenue
(see Schedule A); and
WHEREAS unfavorable revenues in Children's Village are offset
by favorable revenues in Child Care subsidy (see Schedule A); and
1
WHEREAS favorable revenues in the Clerk/Register of Deeds and
the Medical Care Facility which are partially offset by unfavorable
expenditures (see Schedule A); and
WHEREAS Tax Tribunal Appeals are projected to exceed the total
expenditure appropriation at year end and require additional
funding (see Schedule A); and
WHEREAS in previous years, Miscellaneous Resolution #90242
approved $75,000 for the Drain revolving fund which is recorded in
the General Fund as a designated fund which would more appropri-
ately be recorded in the Fund Balance of the Drain Revolving Fund;
and
WHEREAS the 1992 Adopted Budget included $200,000 in non-
departmental funds for funding of unemployment costs for extension
of the benefit period of which $91,000 is recommended to be
transferred; and
WHEREAS Emergency Salaries are forecasted to exceed appropria-
tion which is offset by favorable Rate & Classification Change; and
WHEREAS the Computer Services Operations Budget should be
adjusted based on actual charges anticipated through the year (see
Schedule B); and
WHEREAS the Adopted Budget did not identify the funding to
cover the cost of furniture for civil mediation which is available
in account 1-10100-201-011.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners approves amendments increasing the 1992 Governmental
Fund Revenue and Expenditure Budget $2,720,925 and increasing the
1992 Special Revenue Fund Revenue and Expenditure Budget $338,906
for a total increase in the 1992 Budget of $3,059,831 as listed on
Schedule A.
BE IT FURTHER RESOLVED that the Oakland County Board of
Commissioners approves amendments to the 1992 Computer Service
Operations line-item Budgets as listed on Schedule B.
BE IT FURTHER RESOLVED that $88,720 available in Circuit Court
Civil Mediation Fund Balance (Account # 1-10100-201-011) be
transferred consistent with the 1992 Revenue Budget and the $75,000
approved for the Drain Revolving Fund currently in the General Fund
Designated Fund Long-term Advance - Lake Improvements (#1-10100-
492-036) be recorded as prior years revenue and as an appropria-
tion.
Mr. Chairperson, on behalf of the Finance Committee, I move
the adoption of the foregoing resolution.
FINANCE COMMITTEE FINANCE COMMITTEE
HEREBY APPROVE THE FOREGO, G RESOttMO
r. mo IrAD A_A !I !I nKII-4.110` Daniel T. 'it) r ov.C u xCpjtive r 41, ate
(-111(1441.—
2
Resolution # 92264 November 19, 1992
Moved by Caddell supported by Ferrens the resolution be adopted.
AYES: Jensen, Johnson, Krause, Law, McConnell, McCulloch, McPherson,
Oaks, Obrecht, Olsen, Palmer, Pappageorge, Pernick, Price, Schmid, Serra,
Skarritt, Wolf, Aaron, Bishop, Caddell, Crake, Ferrens, Gosling, Huntoon. (25)
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 November 19, 1992
with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County
of Oakland at Pontiac, Michigan this 19th day 9f) Noyember 1992
Lynri,(1). Allen, County C erk
*
OAKLAND COUNTY, MICHIGAN
1992 Third Quarter Forecast
Table of Contents
Page Numbers
Miscellaneous Resolution 1 - 7
1992 Third Quarter Forecast and Budget Amendments
Third Quarter Revenue & Expenditure Forecast Report
Summary 8
Revenue Forecast 9 - 12
Expenditure Forecast 13 - 19
Budget Division report of forecasted revenues and
expenditures by department as compared to the 1992
Budget as amended for the eight months ended August
31, 1992.
Statement of Receipts 20 - 24
Accounting Division report of receipts (revenues) by
department as compared to the 1992 Revenue Budget as
amended for the eight months ended August 31, 1992
Statement of Expenditures 25 - 31
Accounting Division report of expenditures by de-
partment as compared to the 1992 Expenditure Budget
as amended for the eight months ended August 31,
1992.
Budget Amendments 32 - 33
List of Miscellaneous Resolutions which authorized
amendments to the All Funds Budget.
Internal Service Funds Reports 34 - 46
Summary of revenue and expenditures with explana-
tions of variances form budget.
Microfilm Fund
Drain Equipment Fund
County Building and Liability Insurance Fund
Fringe Benefit Funds
Office Equipment and Convenience Copier Funds
Parks & Recreation, Aviation, Materials Management Funds
Printing & Mailing, Radio Communications Funds
Motorpool Fund
Facilities Maintenance, Pontiac Market, Royal Oak Market
Telephone Communications Fund
Water & Sewer Equipment Fund
Solid Waste Management
Computer Services Funds
$81,100
65,500
575,000
505,000
270,000
26,700
$1,523,300
$1,284
$1,284
$3,861
$3,861
$0
$0
332,580
$332,580
6,500
75,000
65,500
40,000
27,700
15,000
$229,700
1,000
284
$1,284
3,861
$3,861
($10,900)
(69,100)
(87,000)
10,200
13,300
23,000
30,300
7,300
82,900
$0
($15,300)
(2,570)
15,000
1,050
1,000
820
$0
332,580
$332,580
Schedule A
Page 2 of 4
OAKLAND COUNTY, MICHIGAN
Third Quarter Forecast Amendments
Revenue Expenditure
Account Number Account Description Amendment Amendment
Clerk/Register of Deeds
3-10100-212-01-00-2145 Forefeiture of Bonds
3-10100-213-01-00-2591 Reimb.-Special Elections
3-10100-214-01-00-2343 Mortgages
3-10100-214-01-00-2463 Recording Fees
3-10100-214-01-00-9203 Land Transfer Tax
3-10100-244-01-00-2093 Deeds
4-10100-212-10-00-1002 Overtime
4-10100-214-01-00-1002 Overtime
4-10100-213-01-00-4838 Election Supplies
4-10100-212-10-00-4898 Office Supplies
4-10100-214-01-00-4909 Postage
4-10100-215-01-00-4909 Postage
Treasurer
3-10100-221-01-00-2087 Delinquent Pers. Prop. Tax
4-10100-221-01-00-3525 Outside Microfilm
4-10100-221-01-00-6640 Equipment Rental
Reference Library
3-10100-513-01-00-2351 Reimbursement of Salaries
4-10100-513-01-00-3571 Books & Periodicals
Drain Commissioner
4-10100-611-04-00-1001 Salaries - Regular
4-10100-611-10-00-1001 Salaries - Regular
4-10100-611-16-00-1001 Salaries - Regular
4-10100-611-01-00-1001 Overtime
4-10100-611-04-00-1001 Overtime
4-10100-611-05-00-1001 Overtime
4-10100-611-06-00-1001 Overtime
4-10100-611-10-00-1001 Overtime
4-10100-611-16-00-1001 Overtime
Facilities Engineering
4-10100-148-01-00-1001 Salaries - Regular
4-10100-148-01-00-2078 Fringe Benefits - Hospitalization
4-10100-148-01-00-3128 Professional Services
4-10100-148-01-00-3464 Licenses & Permits
4-10100-148-01-00-4909 Postage
4-10100- 148-01 -00-6610 Leased Vehicles
Solid Waste Management
3-10100-906-01-00-2233 Investment Income
4-10100-101-01-00-8330 Operating Transfer to Solid Waste
Prepared By: Budget Division 4 10-Nov-92
$0
$332,580
($138,400)
60,000
78,400
(70,000)
70,000
349,700
115,000
(80,000)
(384,700)
$0 $0
Schedule A
Page 4 of 4
OAKLAND COUNTY, MICHIGAN
Third Quarter Forecast Amendments
Revenue Expenditure
Account Number Account Description Amendment Amendment
SPECIAL REVENUE & PROPRIETARY FUND AMENDMENTS
Printing & Mailing Fund
3-66700-138-20-00-2334 Metered Postage
3-66700-138-20-00-2405 Postage Presort
3-66700-138-20-00-3961 Cost of Sales-Meter Postage
$138,368
(13,346)
(125,022)
Solid Waste Management Fund
3-83300-101-01-00-8330 Oper Transfer from Gen. Fund
4-83300-101-01-00-3418 Interest Expense 332,580
$332,580 $332,580
Computer Services Fund
3-63600-181-01-00-2207 Imaging Operations
3-63600-181-01-00-2208 Imaging Development
3-63600-181-01-00-8101 Operating Transfer In
4-63600-182-01-00-1001 Salaries
4-63600-182-01-00-3128 Professional Services
4-63600-184-01-00-3299 Data Transmission Installation
4-63600-184-01-00-4905 Parts and Accessories
4-63600-184-01-00-3304 Depreciation
1-63600-455-001 Revenue Over(Under) Expenditures
Skillman Trust Fund
3-70580-347-12-00-8101 Oper Transfer from Gen. Fund* $6,326
4-70580-347-12-00-1001 Salaries - Regular 6,326
$6,326 $6,326
TOTAL SPECIAL REV & PROPRIETARY FUND AMENDMENTS $338,906 $338,906
TOTAL ALL FUNDS $3,059,831 $3,059,831
* Actual Skillman Trust Fund Transfer will be $6,326.38 to close the Fund.
Prepared Hy: Budget Division 6 10-Nov-92
REVENUE
Governmental Funds
Special Revenue and
Proprietary Funds
TOTAL REVENUE
EXPENDITURES
Governmental Funds
Special Revenue and
Proprietary Funds
Equity & Operating Transfers
2,414,095
(340,000)
COUNTY OF OAKLAND
THIRD QUARTERLY FORECAST
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL,
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR THE YEAR ENDED DECEMBER 31, 1992
BUDGET BUDGET TOTAL AMOUNT
AS AS REVENUE/ FAVORABLE/
ADOPTED ADJUSTED EXPENDITURE (UNFAVORABLE) PERCENT
248,543,276 255,705,692 255,935,187 229,495 0.09%
83,384,477 84,889,860 83,903,023 (986,837) -1.16%
$331,927,753 $340,595,552 $339,838,210 ($757,342) -0.22%
249,293,276 255,705,692 253,525,092 2,184,600 0.85%
81,555,479 83,060,862 82,414,025 646,837 0.78%
1,828,998 1,828,998 1,828,998
$332,677,753 $340,595,552 $337,768,115 $2,831,437 0.83%
EXCESS REVENUES OVER/
(UNDER) EXPENDITURES
Governmental Funds
Special Revenue and
Proprietary Funds
TOTAL $2,074,095
Prepared by: Budget Division 8 10-Nov-92
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
REVENUES OTHER FUNDS
STATE AND FEDERAL
Health-State Subsidy
Disaster Control
Child Care Subsidy
Community Mental Health
Social Services-Foster Care
CHARGES FOR SERVICES
Friend of the Court
Health
Emergency Medical Service
Animal Control
Planning
Clerk/Register of Deeds
Board of Commissioners
Library Board
Drain Commissioner
COUNTY OF OAKLAND
1992 THIRD QUARTER FORECAST
REVENUES
BUDGET BUDGET 1992 AMOUNT
AS AS ESTIMATED FAVORABLE
ADOPTED ADJUSTED REVENUE (UNFAVORABLE) PERCENT EXPLANATION
201,800 201,800 178,745 (23,055) -11.42% -Due to decline in sale of property description maps
7,767,800 7,767,800 9,362,300 1,594,500 20.53% -1,120,000 fav Mortgage & Recording fees as a result of increased
refinance activity and 270,000 fay land transfer tax partially offset
by unfav Impact on expenditures); also 81,000 fall Bond Forfeitures,
58,000 fay Jury, Motion & Bond fees, 65,500 fav reimbursement from
State for Presidential Primary Election (fully offset by unfav
expenditures)
4,490,381 4,557,464 5,083,464 526,000 11.54% -Tax abatement recoveries fay 155,000, Tax statement fay 80,000 due to
increased refinancing activity, May Tax Sale fav. 135,000, and
collection fees fav 26,000; Inheritance tax for 110,000:
2,837,720 2,837,720 2,837,720 other revenues favor 20,000.
5,986,625 5,986,625 6,101,625 115,000 1.92% -Performance incentive award fav 167,300; Partially offset by
regular incentive unfavorable (52,300) due to low January
collections
2,109,909 2,109,909 1,975,409 (134,500) -6.37% -Local municipalities for Div. I, II, III, & IV reflect a decline
958,293 958,293 885,093 (73,200) -7.64% in traffic tickets; New Garnishment Guidelines reduced anticipated
2,587,877 2,587,877 2,165,577 (422,300) -16.32% revenue by aprox. 50%; Decline in State Law Filings rev. offset by
1,392,000 1,392,000 1,310,100 (81,900) -5.88% Improvement In Probation Revenue Collections
815,350 829,037 895,037 66,000 7.96% -Increased Defense Attorney reimbursement and probation service fees,
partially offset by reduced Court tees - Traffic
96,055 96,055 136,055 40,000 41.64% -Victim Rights Program reimbursement from State for prior years
11,720,337 11,757,701 12,119,701 362,000 3.08% -Increase in OUIL (Operating Under the Influence of Liquor) 3rd
offense revenue 245,000, Board & Care 57,000; and Overtime
reimbursement 105,000; offset by unfav. NET confiscated property
revenue (44,000); Overtime reimbursement offset by Overtime Expense
20,500 20,500 20,500
86,771 86,771 86,771
2,917,261 2,927,450 2,927,450
$45,444,972 $45,617,515 $47,608,310
2,165,774 2,165,774 2,165,774
19,315 19,315 20,415
3,600,000 3,600,000 4,023,700
24,050,103 23,110,940 22,722,540
24,000 24,000 16,000
S29,859,192 $28,920,029 $28,948,429
$1,990,795 4.36%
1,100 5.70% -Federal supplement for prior year
423,700 11.77% -Increase in State allocation
(308,400) -1.68% -Revenue reduction corresponds to anticipated expenditure limit
(8,000) -33.33% -Revenue reduction corresponds to anticipated favorable expenditure
$28,400 0.10%
435,481 435,481 435,481
1,434,100 1,434,100 1,679,100
181,617 181,617 185,917
770,661 770,661 700,061
Children's Village 3,390,249
245,000 17.08% -Increased Laboratory fees, food services licenses and solid
waste management
4,300 2.37%
(78,600) -10.09% -Decline in sale of license activity; reduction in Pound Fees and
Service Fees due to reduction In number of animals brought In,
as well as the average number of boarding days
(407,800) -12.03% -Decreased outside revenue due to full facility 3,390,248 2,902,448
10 10-Nov-92 Prepared by: Budget Division
COUNTY OF OAKLAND
1992 THIRD QUARTER FORECAST
REVENUES
BUDGET BUDGET 1992 AMOUNT
AS AS ESTIMATED FAVORABLE
ADOPTED ADJUSTED REVENUE (UNFAVORABLE) PERCENT EXPLANATION
Prosecutor-Anti -Drug
Substance Abuse Coord.
Sheriff N.E.T.
Criminal Justice Training
CNN Homeless Assist
CMH Adoptive Services
HIV Survey Grant
MIC/IHP Local
Veteran's Trust
Circuit Court Judicial Support
IHS We Care
Prenatal Coordination
114,301 114,301 114,301
502,578 502,578 502,578
56,050 56,050 56,050
232,487 232,487 232,487
33,769 33,769 (33,769) -100.00% -Grant discontinued
92,360 79,074 79,074
99,161 99,161 99,161
319,350 319,350 319,350
17,940 17,940
50,000 50,000
68,000 68,000 68,000
$23,205,851 $24,711,234 $24,377,091 ($334,143) -1.35%
CHARGES FOR SERVICES
Parks and Recreation
Library Board
*Telephone Communications
*Maintenance & Operations
*Markets
*Leased Vehicle Operations
*Microfilm & Reproductions
*Print Shop
*Radio Communications
Water & Sewer - Equipment
*Materials Management
*Computer Services
*Equipment Fund
Commissary Fund
Water & Sewer
Drain Commissioner
Aviation
Solid Waste
TOTAL CHARGES FOR SERVICES
TOTAL SPECIAL REVENUE
AND PROPRIETARY FUNDS
GRAND TOTAL RESOURCES
AVAILABLE ALL FUNDS
w:\rena\revenue3.wkl
(395,859) -8.17% -Revenues unfavorable for swimming, golf and camping due to
poor weather conditions
65,760 65,760 65,760
227,174 227,174 302,174 75,000 33.01% -Increased Public Telephone Commission revenue
1,544,974 1,544,974 1,506,474 (38,500) -2.49% -See report on Facilities Maintenance & Operations
267,050 265,050 283,050 18,000 6.79% -Increased stall rental revenues
191,000 191,000 238,355 47.355 24.79% -Favorable revenues from Camp Oakland due to increased use
117,500 117,500 130,200 12,700 10.81% -Fay, film purchase due to mortgage refinancing activity
52,400 52,400 52,400
1,000 1,000 28,500 27,500 2750.00% -Increased Township repairs revenue
738,111 738,111 738,111
204,840 204,840 200,100 (4,740) -2.31% -Reduced sales of paper products to Municipalities and
outside agencies.
1,458,000 1,458,000 1,637,000 179,000 12.28% -133,000 fay reimbursement for services to outside agencies and
and 46,000 fav. for in-car terminals
1,313 1,313 -Rental to outside agencies
347,842 347,842 347,842 •
23,928,346 23,928,346 23,758,346 (170,000) -0.71% -Increased sewage flow
17,520,330 17,520,330 17,720,330 200,000 1.14% -Increased pollution control services
1,941,599 1,941,599 2,038,899 97,300 5.01% -Favorable revenue for fuel 45,200, T-Hanger rental 84,800 and
land lease 95,000 offset by Investment income (127,000) due to
lower interest rates
726,940 726,940 (726,940) -100.00% -Sale of bonds not anticipated; see report on Solid Waste
$54,174,626 $54,174,626 $53,496,755 ($677,871) -1.25%
$83,384,477 $84,889,860 $83,903,023 ($986,837) -1.16%
$331,927,753 $340,595,552 $339,838,210 (5757,342) -0.22%
4,843,760 4,843,760 4,447,901
Prepared by: Budget Division 12 10-Nov-92
SOLID WASTE SERVICES
Administration $245,000 $245,000 $245,000 0.00%
1.51% -Professional Services less than anticipated
989,897 992,381 977,581 14,800
607,479 614,598 614,598
84,991 90,284 94,484
89,458 89,058 90,558
1,134,137 1,143,364 1,132,364
82,553 82,553 82,553
124,541 158,095 165,795
COUNTY EXECUTIVE
Administration
Auditing
Comm. & Minority Affairs
Public Information
Corporation Counsel
State & Federal Aid Coord.
Cultural Affairs
(4,200) -4.45% -Special projects, photographic supplies and print shop
(1,500) -1.66% -Printing of County Newsletter
11,000 0.97% -Lower than anticipated use for apprisal services, depositions, and
leased vehicle
(7,700) -4.64% -Art Council Regranting Program offset by increased revenue
MANAGEMENT AND BUDGET
Administration
Budget Division
Accounting Division
202,182 192,947 192,947
877,184 905,286 894,786 10,500
5,289,745 5,429,839 5,302,839 127,000
Purchasing Division
Equalization Division
Reimbursement
599,236 628,334 597,834 30,500
3,889,421 3,969,626 3,834,626 135,000
1,210,578 1,270,400 1,270,400
CENTRAL SERVICES
Administration
Materials Management
Support Services
PUBLIC WORKS
Administration
Water & Sewage Operations
Facilities Engineering Div.
3,098 20,598 20,598
1,174,819 1,182,921 1,182,921
$1,544,139 $1,590,312 $1,568,712 $21,600
$12,068,346 $12,396,432 $12,093,432 $303,000
118,713 121,813 121,813
213,044 213,044 213,044
1,238,944 1,911,897 1,901,897 10,000 0.53% -Cost of equipment repairs for Cafeteria less than anticipated
$1,570,701 $2,246,754 $2,236,754 $10,000
2.51%
0.45%
366,222 386,793 365,193 21,600 5.91% -Turnover fav. 1,600; operating fav. 20,000 for outside Microfilming
COUNTY OF OAKLAND
1992 THIRD QUARTER FORECAST
EXPENDITURES
BUDGET BUDGET
AS AS
ADOPTED ADJUSTED
1992 AMOUNT
ESTIMATED FAVORABLE PERCENT
EXPENDITURE (UNFAVORABLE) SPENT
$3,113,056 $3,170,334 $3,157,934 $12,400
1.17% -Turnover
2.39% -Turnover fav 191,500; offset by overtime unfav. (11,000) due to
year end closing activity; operating unfav for bank charges (57,000)
due to interest rate decrease & postage (11,000) due to increased
mailings offset by indirect costs 14,500 due to rate reduction
5.10% -Turnover
3.52% -Turnover fay. 143,000; offset by personal mileage (8,000)
due to increased appraisal activities
-Turnover fav. offset by Professional Services cost for
preliminary project planning
1.38%
Prepared by: Budget Division 14 10-Nov-92
500,000 -West Wing Expansion payments begin in 1993
(5,200) -11.26%
COUNTY OF OAKLAND
1992 THIRD QUARTER FORECAST
EXPENDITURES
COMPUTER SERVICES
BUDGET BUDGET 1992 AMOUNT
AS AS ESTIMATED FAVORABLE PERCENT
ADOPTED ADJUSTED EXPENDITURE (UNFAVORABLE) SPENT
3,804,161 3,142,248 3,142,248
COMMUNITY & ECONOMIC DEVELOPMENT
Administration 161,639 170,865 145,865 25,000 17.14% -Fav. Grant Match due to 2010 Strategic Plan grant did not start as
Economic Development 1,095,154 1,117,388 1,117,388 anticipated
Planning Division 1,283,491 1,319,823 1,287,623 32,200 2.50% -Operating expenses reflect savings in Prof. Svs. 7,900; Drafting
Supplies 9,000; Photographic Supplies 13,000 due to usage of
supplies and
Community Development 40,000 40,000 0 40,000 -Grant match waived for New Home Investment Partnership Act grant
(M.R.#92121)
2,580,284 2,648,076 2,550,976 97,200 3.81%
TOTAL COUNTY EXECUTIVE $110,075,270 $110,862,375 $108,361,675 $2,500,700 2.31%
TOTAL DEPT. & INSTITUTIONS $228,184,277 $230,455,609 $228,260,809 $2,194,800 0.96%
NON-DEPART. APPROPRIATIONS
Doctors/Hospitals
Budgeted Projects
State Inst./Juvenile Waivers
Parks & Recreation
Project Work Orders
Building Fund
Capital Program - Utilities
Building Authority
Radio Communications
Worker's Compensation
Ambulance
Insurance & Surety Bonds
Road Improvements
Current Drain Assessment
Tax Tribunal Appeals
Economic Development
Road Comm. - Drain Assess.
wTE Contract Termination
Misc. Capital Outlay
Future Space Requirement
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 Breau
Traffic Improvement Assoc.
3,550,000 3,550,000 3,550,000
50,000 0
175,000 175,000 250,000
15,000 15,000 15,000
1,237,000 1,237,000
750,000 750,000 750,000
500,000 500,000 500,000
3,533,858 3,533,858 3,533,858
12,314 12.314
3,433,656 3,433,656
12,000 12,000 12,000
64,415 64,415 64,415
1,000,000 2,555,729 2,555,728
630,500 0
250,000 250,000 1,000,000
85,000 85,000 85,000
1,362,264 1,362,264
1,125,908 1,125,908
25,000 25,000
2,800,000 500,000 0
2,358,834 2,157,799 2,157,799
319,108 319,108 319,108
41,000 41,000 46,200
17,023 17,023 17,023
36,900 36,900 36,900
15,000 15,000 15,000
3,000 3,000 3,000
19,000 19,000 19,000
49,500 49,500 49,500
25,000 25,000 25,000
50,000 -Carry forward for 1993 Courthouse Security
(75,000) -30.00% -Increased board/care rates and lengths of stay
(750,000) -75.00% -Includes multiple years settlements and backlog
Prepared by: Budget Division 16 10-Nov-92
1,067,337 1,067,337 1,067,337
666,964 667,522 667,522
701,555 701,555 701,555
165,055 165,055 165,055
114,301 114,301 114,301
56,050 56,050 56,050
352,277 352,277 352,277
502,578 502,576 502,578
346,062 346,062 146,062
$3,972,179 $3,972,737 $3,972,737 $0 0.00%
17,520,330 17,520,330 17,720,330 (200,000) -1.13% -Increased pollution control services
117,500 117,500 130,200 (12,700) -9.75% -See revenue note
65,760 65,760 65,760
$17,703,590 $17,703,590 $17,916,290 ($212,700) -1.19%
1,313 (1,313) -100.00% -Corresponds to revenue; see report on Equipment Fund
9,040,339 9,040,339 8,669,657 370,682 4.28% -Corresponds to revenue; see report on Parks & Recreation
1,925,674 1,925,674 2,022,974 (97,300) -4.81% -Corresponds to revenue; see report on Aviation
204,840 204,840 200,100 4,740 2.37% -Corresponds to revenue; see report on Materials Management
191,000 191,000 238,355 (47,355) -19.87% -Corresponds to revenue; see report on Leased Vehicles
52,400 52,400 52,400
1,000 1,000 28,500 (27,500) -96.49% -Corresponds to revenue; see report on Radio Communications
$11,415,253 $11,415,253 $11,211,986 $203,267 1.81%
1,544,974 1,544,974 1,506,474 38,500 2.56% -Corresponds to revenue; see report on EM&O
227,174 227,174 302,174 (75,000) -24.82% -Corresponds to revenue; See report on Telephone Communications
261,178 261,178 279,178 (18,000) -6.45% -Corresponds to revenue; see report on Markets
23,928,346 23,928,346 24,098,346 (170,000) -0.71% -Corresponds to revenue
738,111 738,111 738,111
826,699,783 $26,699,783 826,924,283 ($224,500) -0.83%
$726,940 ;726,940 $0 $726,940 -Corresponds to revenue; see report on Solid Waste Management fund
COUNTY OF OAKLAND
1992 THIRD QUARTER FORECAST
EXPENDITURES
BUDGET BUDGET 1992 AMOUNT
AS AS ESTIMATED FAVORABLE PERCENT
ADOPTED ADJUSTED EXPENDITURE (UNFAVORABLE) SPENT
LAW ENFORCEMENT
Prosetutor-Cooperative Reimb.
Secondary Road Patrol
Auto Theft Prey-Sheriff
Auto Theft Prev.-Prosecutor
Inmate Substance Abuse
Criminal Justice Training
Narcotics Task Force
Sheriff N.E.T
Commissary Fund
GENERAL GOVERNMENT
Drain Commissioner
*Microfilm & Reproduction
Library Board
MANAGEMENT & BUDGET
*Equipment Fund
CENTRAL SERVICES
Parks & Recreation
Aviation Division
*Materials Management
*Leased Vehicles
*Print Shop
*Radio Communications
PUBLIC WORKS
*Maintenance & Operations
*Telephone Communications
•Markets
Water & Sewer Operations
Water & Sewer - Equipment
SOLID WASTE MANAGEMENT
Prepared by: Budget Division 18 10-Nov-92
BUDGET
ADJUSTMENTS
BUDGET
AS
ADOPTED
BUDGET
AS
ADJUSTED
91.30% . $ 125,866,166.00
(1,300.000.00)
(40,000.00)
(800,000.00)
$ 10,946,672.59
(1,300,000.00)
(40,000.00) .
(B00,000.0(1)
92.88% $ 123,726,166.00 $123,726,166.00 T 114,919,493.41 5 8,006,672.59
8.517,384.74 (.8,517,384.74)
$123,726.166.00 123,436,878.15 $ 289,287.85 • 99.77% $ 123,726,166.00
64.07%
70.28%-
215,593.84
26,449.00
600,000.00
89,000.00
PROPERTY TAXES
1992 TAX LEVY
LESS: ALLOWANCE FOR TIFA
ALLOWANCE FOR LorA
DELINQUENT
rAX IRIBUNAL APPEALS
CURRENT COLLECTIONS
DELINQUENT TAX REVOLVING
NET CURRENT PROPERTY TAX
OTHER TAXES
DELINQUENT lAXES PRIOR YEARS
TRAILER TAX
$125,866,166.00 $ 114,919,493.41
(1,300,000.00)
(40,000.00)
(800,000.00)
• 600,000.00 $ 384,406.16
89.000.00 62.551.00
689,000.00 • 689,000.00 5 446.957.16 242.042.84 64.87%
--
$
99.57%*
COUNTY OE
STATEMENT OF RECEIPTS
FOR THE EIGHT MONTHS
AKLAND
UNTY ORATING FUNDS
ED AUGUST 31. 1992
BALANCE
COLLECTIONS or ESTIMATE
TO TO BE
8/31/92 COLLECTED
% OF YEAR
ELAPSED
66.66%
PERCENTAGE
COLLECTED
TOTAL PROPERTY AND OTHER TAXES $
0
124,415,166.00 $124,415,166.00 $ 123,883,835.31 $ 531,330.69
BUDGETED RECEIPTS
OTHER THAN TAXES
GENERAL FUND
STATE AND FEDERAL
CIRCUIT JUDGES SALARIES
PROBATE JUDGES SALARIES
DISTRICT JUDGES SALARIES
MARINE SAFETY
STATE INCOME TAX
STATE REIMB. - P.A. 228
CONVENTION FAC TAX PA 106/07
CIGARETTE TAX DISTRB.
INDIRECT COST RECOVERY
• 562,000.00
333,900.00
364,900.00
190,000.00
14,000,000.00
2,181,700.00
493,661.00 $
2,115.930.00
974,147.00
$ 21,216,238.00 $
• 562,000.00 $ 413,030.82 $
333.900.00 250,455.00
364,900.00 273,67.00
190,000.00 14,866.10
14,000,000.00 6.899.103.66
2,181,700.00 2,181,718.04
465,043.00 465,042.85
2,115,930.00 736,019.76
974,147.00 535,874.02
(20,618.00)5 21,187,620.00 $ 11.769,786.05 $
148,969.18
03,445.00
91.225.00
175,133.90
7,100,896.34
(16.84 )
0.15
1,379.910.24
438,272.9E1
9,417,833.95
73.49%
75.01%
75.00%
7.82%
49.28%
100.00%
100.00%
34.78%
55.01%
55.55%
(28.618.00)
PREPARED BY ACCAHNTING DIVISION
SEPTEMBER, 17. 1992 PAGE 1
COUNTY 0
STATEMENT OF RECEIPTS
FOR THE EIGHT MONTHS
KLAND
OUNTY OPERATING FUNDS
DED AUGUST 31. 1992
BUDGET
AS
ADOPTED
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
COLLECTIONS
TO
0/31/92
55,000.00 $ 12,372,026.00 $
(884,163.00) $ 41,292,055.00 $
• 351,682.00 $ 351,682.00
6,057,341.79 9,096,341.79 9,096,341.79
6.057,341.79 1 9,448.023.79 5 9,440,023.79
7,162,415.79 $255,705,691.79 $ 206,848,232.31
11,500,000.00 11,500,000.00
400,000.00 5 1,845,312.00 2,245.312.00
3,421,153.44
2,114,049.27
$ :2.0J/0,046.56
131,262.73
5 11,900,000.00 5 1.845,312.00 $ 13,745,312.00 $ 5,535.202.71 . $ 0,210,109.29
BALANCE
OF ESTIMATE
TO BE
COLLECTED
% OF YEAR
ELAPSED
66.66%
PERCENTAGE
COLLECTED
REVENUES
OTHER FUNDS
STATE AND FEDERAL
HEALTH-STATE SUBSIDY
DISASTER CONTROL
CHILD CARE SUBSIDY
COMMUNITY MENTAL HEALTH
SOCIAL SERVICES-FOST. CARE
$ 2.165,774.00
19,315.00
3,600,000.00
24,050,103.00 T
24,000.00
$ 2.165,774.00
19,315.00
3.600.000.00
(939,163.00) 23,110,940.00
24,000.00
719,544.00 $ 1,446,230.00 .
21,M36.63 (2,571.63) 113.
▪
31%
3,511,253.05 66.746.95 97.53% .
14,H09,030.90 8,:101,909.10 64.08%
10,503.35 13,496.65 43.76%
$ 29,859,392.00 $ (939,163.00) $ 26,920,029.00 $ 19,072.217.93 5 9.047.811.07 65.95%
55,000.00
CHARGES FOR SERVICES
FRIEND OF 1HE COURT
HEALTH
EMERGENCY MEDICAL SERVICE
ANIMAL CONTROL
CHILDREN'S VILLAGE
SOC SVCS-HOSPITALIZATION
JUVENILE MAINTENANCE
MEDICAL CARE FACILITY
MISCELLANEOUS REVENUE
INVESTMENT INCOME
SUNDRY
RESOURCES CARRIED FORWARD
BUDGETED PROJECTS
PRIOR YEAR'S BALANCE
TO1AL AVAILABLE RESOURCES
GOVERNMENTAL FUNDS
• 435,481.00
1,434,100.00
181,617.00
776,661.00
3,390,246.00
5,000.00
554,000.00
5,537,919.00
$ r2,317.,.026.00
$ 42,176,218.00 $
• 351,682.00
3,039,000.00 $
$ 3,390,602.00 $
$ 248,543.276.00 $
• 435,461.00 S
1,434,100.00
161,617.00
778,661.00
3,390.248.00
5,000.00
609,000.00
5,537,919.00
400,501.95
1,050.313.10
124.076.15
414,043.09
1,369.983.42
0,222.07
A01,372.37
3,610,058.91
7,378,571.14
26,450,789.07
• 34,979.05
383,706.02 •
57.540.85
364.617.91
2,020,264.58
(3,222.07)
207,627.63
1,927.860.09
$ 4,993,454.06
$ 14.841,265.93
$ 46,857.459.48
91.97%
66.32%
53.17%
40.41%
164.44%
65.91%
65.19%
59.64%.'
64.06%
94.1
▪
5%
40.27% .
100.00% .
100.00%
80.89%
PREPARED BY ACCOUNTINUutON PAGE 3
$ 30,033,423.62 64-62%.
COUNTY OF OAKLAND
STATEMENT OF RECEIPTSlirpUNTY OPERATING FUNDS
FOR THE EIGHT MONTHS OED AUGUST 31. 1992
BUDGET
AS
ADOPTED
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
COLLECTIONS
TO
8/31/92
BALANCE
OF ESTIMATE
TO BE
COLLECTED
% OF YEAR
ELAPSED ,
66.66%
PERCEN1AGE
COLLECTED
CHARGES FOR SERVICES
PARKS & RECREATION
REFERENCE LIBRARY
*TELEPHONE COMMUNICATIONS
xmAINTENANCE & OPERATIONS
xmARKETS
*LEASED VEHICLE OPERATIONS
*MICROFILM & REPRODUCTIONS
*PRINT SHOP
*RADIO COMMUNICATIONS
*WATER & SEWER EQUIPMENT
xmATERIALS MANAGEMENT
*COMPUTER SERVICES
xEQUIPmENT
COmmI ,_;SARY FUND
WATER & SEWER
. DRAIN COMMISSIONER
AVIATION
SOLID WASTE
$ 4,843,760.00
65,760.00
227,174.00
1,544,974.00
265.050.00
191,000.00
117,500.00
52,400.00
1,000.00
730,111.00
204,840.00
1,458,000.00
:147,642.00
23,928,346.00
17,520,330.00
1,941,599.00
726,940.00
• 4,843,760.00 $
65,760.00
227,174.00
1,544,974.00
265,050.00
191,000.00
117,500.00
52,400.00
1,000.00
738,111.00
204,840.00
1,456,000.00
347,042.00
23,928,246.00
17,520,330.00
1,941,599.00
726,940.00
3,667,543.68 $
12,296.55
977.98E3.89
1,027,117.90
194,97,
213,308.42
00.668.25
29,636.23
19,133.02
473,945.02
130,444.57
1,149,326.95
2,476.05
197,77%,.!A
15,279 ,100.25
11,210,992.92
1.304,930.28
458.95
1,176.216.12
53,533.45
(50,811.82)
517.056.02
70,051.67
(22,368.42)
36,831.75
22,713.77
(10,133.02)
244,165.98
66,395.43
308,673.05
(2,476.05)
150,046.46
8.656.245.75
6,309,337.00
636,668.72
726,481.05
75.72%
18.59%
122.37%
66.48%
73.57% -
111.72%
68.65%
56.65%
1913.30%
66.92%
67.59%
78.83%
5A.067.
63.112%
63.99%
67.21%'
0.06%
• 54,174,626.00 s 35.293,219.81 $ 18,861,406.19 65.15%-, TOTAL CHARGES FOR SERVICES
TOTAL-SPECIAL REVENUE
N.) AND PROPRIETARY FUNDS
GRANO TOTAL RESOURCES
AVAILABLE-ALL FUNDS
$ 54,174,626.00
$ 83,384,477.00
$ 331,927,753.00 $
1,505,383.00 S 84,889,060.00 $ 54,056,436.38
8,667,798.79 1340.595,551.79 5 261,/04,660.70 5 7:.!,90.rJ03.09 /6.04%
*INTERNAL SERVICE FUNDS -
REVENUE FROM OUTSIDE SOURCES
PREPARED PAGE 5
20,571.44 $
17,500.00
8,102.34
386,793.44 S
20,598.00
1,182,921.34
230,699.31
17,500.00
830,806.80
156,094.13
3,098.00
352,114.54
59.64%
84.96% •
70.23%
1,544,139.00 $ 46,173.78 $ 1,590,312.78 $ 1,079,006.11 5 511,306.67
1:3
NJ
)
67.85%
1..sn
COUNTY el OAKLAND
STATEMENT OF. EXPENDITURES INCLUDING ENCUMBRANCES
COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1992
MANAGEMENT & BUDGET
ADMINISTRATION
BUDGET DIVISION
ACCOUNTING DIVISION
PURCHASING DIVISION
EQUALIZATION DIVISION
REIMBURSEMENT DIVISION
BUDGET
AS
ADOPTED
202,182.00 $
877,184.00
5,289,745.00
599,236.00
3,889,421.00
1,210,578.00
BUDGET
ADJUSTMENTS
(9,235.00) $
28,102.02
140,093.61
29,098.88
80,205.46
59,821.77
BUDGET
AS
ADJUSTED
192,947.00 $
905,286.02
5,429,838.61
628,334.88
3,969,626.46
1,270,399.77
EXPENDITURES
AND
TRANSFERS
85,415.62 $
582,691.22
3,568,494.60
382,523.17
2,458,250.35
837,420.89
UNENCUMBERED
BALANCE
107,531.38
322,594.80
1,861,344.01
245,811.71
1,511,376.11
432,978.88
% OF YEAR
ELAPSED
66.66%
PERCENTAGE
SPENT
44.27%
64.37%
65.72%
60.88%
61.93%
65.92%
S 12,068,346.00 $ 328,086.74 $ 12,396,432.74 $ 7,914,795.85 $ 4,481,636.89 63.85%
CENTRAL SERVICES
ADMINISTRATION
MATERIALS MANAGEMENT
SUPPORT SERVICES
118,713.00 $
213,044.00
1,238,944.00
3,100.00 $ 121,813.00 $
213,044.00
1,911,897.08
81,199.73 $
140,540.19
1,436,028.33
40,613.27
72,503.81 -
475,868.75
588,985.83
66.66%
65.97%
75.11%
73.79%
672,953.08
$ 1,570,701.00 $ 676,053.08 $ 2,246,754.08 $ 1,657,768.25 $
PUBLIC WORKS
ADMINISTRATION 366,222.00 $
WATER & SEWER OPERATIONS 3,098.00
FACILITIES ENGINEERING DIV 1,174,819.00
PERSONNEL
ADMINISTRATION
HUMAN RESOURCES
EMPLOYEE RELATIONS
121,697.00 $
1,446,568.00
1,514,028.00
55,484.99 $ 177,181.99 $
32,682.20 1,479,250.20
26,233.00 1,540,261.00
138,069.49 $
932,941.89
997,739.52
39,112.50
546,308.31
542,521.48
77.93%
63.07%
64.78%
$ 3,082,293.00 $ 114,400.19 $ 3,196,693.19 $ 2,068,750.90 $ 1,127,942.29
INSTITUTIONAL HUMAN SER.
ADMINISTRATION
HEALTH DIVISION
MEDICAL CARE FACILITY
CHILDREN'S VILLAGE
COMMUNITY MENTAL HEALTH
HUMAN SERVICES AGENCY
SOCIAL SERVICES
MEDICAL EXAMINER
$ 2,248,398.00 $
20,384,320.00
7,401,843.00
10,901,831.00
32,101,355.00
756,460.00
1,375,900.00
1,536,522.00
$ 76,706,629.00 $
1,484.40 $ 2,249,882.40
699,782.63 21,084,102.63
28,056.61 7,429,899.61
190,697.49 11,092,528.49
(930,335.62) 31,171,019.38
756,460.00
1,375,900.00
68,552.60 1,605,074.60
58,238.11 $ 76,764,867.11
$ 1,547,009.19
13,190,536.44
4,938,296.95
6,951,145.01
19,548,366.43
553,582.00
399,627.41
1,060,554.30
$ 48,189,117.73
702,873.21
7,893,566.19
2,491,602.66
4,141,383.48
11,622,652.95
202,878.00
976,272.59
544,520.30
$ 23,575,749.38
64.72%
68.76%
62.56%
66.47%
62.67%
62.71%
73.18%
29.04%
66.08%
62.77%
PREPARED BY ACCOUNTING DIVISION PAGE 7
17,023.00
36,900.00
15,000.00
3,000.00
19,000.00
49,500.00
25,000.00
38,850.00
1,000.00
1,000,00
9,888.00
1,000.00
14,000.00
5,000.00
1,000.00
60,000.00
200,000.00
31,000.00
17,023.00
36,900.00
15,000.00
3,000.00
19,000.00
49,500.00
25,000.00
38,850.00
1,000.00
1,000.00
9,888.00
1,000.00
14,000.00
5,000.00
1,000.00
60,000.00
215,000.00
31,000.00
17,023.00
3,673.60
3,000.00
14,250.00
37,125.00
18,750.00
19,425.00
1,000.00
1,000.00
7,416.00
1,000.00
7,000.00
3,750.00
1,000.00
45,000.00
443,473.22
25,244.68
36,900.00
11,326.40
4,750.00
12,375.00
6,250.00
19,425.00
2,472.00
7,000.00
1,250.00
15,000.00
(228,473.22)
5,755.32
100.00%
24.49%
100.00%
75.00%
75.00%
75.00%
50.00%
100.00%
100.00%
75.00%
100.00%
50.00%
75.00%
100.00%
75.00%
206-27%
81.43%
75.42%
15,000.00
$ 15,862,876.00 $ 6,435,332.35 $ 22,298,208.35 $ 16,816,468.25 $ 5,481,740.10
$ 2,100,000.00
740,315.00 $ (607,081.43)
2,547.00
(18,138.00)
(16,529.00)
(444,000.00)
(327,619.00)
(79,069.00)
60,350.00
(114,711.84)
423,235.89
(423,235.89)
117,257.00
75,000.00
444,000.00
430,000.00
206,549.00
158,002.00
50,000.00
175,000.00
890,000.00
(890,000.00)
$ 2,100,000.00
133,233.57
2,547.00
99,119.00
58,471.00
102,381.00
206,549.00
78,933.00
110,350.00
60,288.16
1,313,235.89
(1,313,235.89)
$ 2,100,000.00
133,233.57
2,547.00
99,119.00
58,471.00_,
102,381.00
206,549.00
78,933.00
110,350.00
60,288.16
1,313,235.89
(1,313,235.89)
$248,543,276.00 $ 7,162,415.79 $255,705,691.79 $163,664,872.77 S 92,040,819.02 64.01%
$ 4,496,123.00 5 (1,544,251.27) $ 2,951,871.73 $ 2,951,871.73
TOTAL NON-DEPT APPROPRIATIONS $ 20,358,999.00 $ 4,891,081.08 $ 25,250,080.08 $ 16,816,468.25 S 8,433,611.83 66.60%
PREPARED BY ACCOUNTING DIVIS1 PAGE 9
COUNTY OF LAND
-
YA
STATEMENT OF EXPENDITURES -:1'CLUDING ENCUMBRANCES
COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1992
BUDGET
AS
ADOPTED
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
EXPENDITURES
AND
TRANSFERS
% OF YEAR
ELAPSED
66.66%
UNENCUMBERED PERCENTAGE
BALANCE SPENT
NON-DEPT APPROPRIATIONS CONT'D
NATIONAL ASSOC. OF COUNTIES
MICHIGAN ASSOC. OF COUNTIES
SANCTUARY
4-H PREMIUMS
HISTORICAL SOCIETY
TOURIST & CONVENTION BUREAU
TRAFFIC IMPROVEMENT ASSOC.
AREA AGENCY ON AGING
CLINTON RIVER WATERSHED
HURON RIVER WATERSHED
SOIL CONSERVATION
ROUGE RIVER WATERSHED
OAKLAND COUNTY 4C COUNCIL
RETIRED SENIOR VOL. PROGRAM
VETERANS CONVENTION
CHILD ABUSE & NEGLECT
SUNDRY
EMP, DEFERRED COMPENSATION
RESERVED FOR TRANSFERS
m TRANSFER TO RESERVE
CONTINGENCY
SALARY ADJUSTMENT
CLASSIFICATION & RATE CHANGE
OVERTIME
SUMMER EMPLOYMENT
EMERGENCY SALARIES
FRINGE BENEFIT ADJ.
OFFICE AUTOMATION
FEDERAL/STATE PROJECT MATCH
CAPITAL OUTLAY
DISABILITY INSURANCE
DISABILITY RESERVE
TOTAL GOVERNMENTAL FUNDS
0.00 458.95 $ 726,481.05 SOLID WASTE 726,940.00 726,940.00
6,741.00
(13,286.00)
20,426.00
319,350.00 $
(7,985.00) 39,914.00
95,000.00
73,128.00
50,000.00 50,000.00
17,940.00 17,940.00
6,605,805.00
282,083.64
15,374.45
39,513.10
48,636.77
4,219,413.94
37,266.36
24,539.55
95,000.00
33,614.90
1,363.23
17,940.00
2,386,391.06
88.33%
38.52%
54.03%
97.27%
63.87%
63.95%
78.83%
-
COUNTY OF ''(LAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES
COMPARED WITH APPROPRIATIONS ENDED AUGUST 31, 1992
BUDGET
AS
ADOPTED
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
EXPENDITURES
AND
TRANSFERS
% OF YEAR
ELAPSED
66.66%
UNENCUMBERED PERCENTAGE
BALANCE SPENT
PUBLIC WORKS
*MAINTENANCE 6 OPERATIONS
*TELEPHONE COMMUNICATION
*MARKETS
WATER 6 SEWER OPERATIONS
*WATER & SEWER-EQUIPMENT
$ 1,544,974.00
227,174.00
261,178.00
23,928,346.00
738,111.00
$ 26,699,783.00
5 1,544,974.00 $ 1,027,117.98 $
227,174.00 277,985.82
261,178.00 175,976.42
23,928,346.00 15,272,100.25
738,111.00 493,945.02
$ 26,699,783.00 $ 17,247,125.49 $ 9,452,657.51
517,856.02
(50,811.82)
85,201.58
8,656,245.75
244,165.98
66.48%
122.37%
67.38%
63.82%
66.92%
64.60%
INSTITUTIONAL & HUMAN SERV.
MEDICAID SCREENING
FAMILY PLANNING GRANT
W.I.C. GRANT
M.D.P.H. 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
HEALTH MINORITY PLANNING
MICH. HEALTH INITIATIVE
HOMELESS ASSISTANCE
925,936.00
423,746.00
718,888.00
4,132,565.00
74,741.00
249,826.00
161,500.00
43,802.00 $
131,136.00
211,978.00
92,360.00
99,161.00
68,000.00
33,769.00
15,000.00
4,300.00
232,487.00
5 7,619,195.00 $
$ 925,936.00 $ 413,942.54 S 511,993.46
423,746.00 192,222.52 231,523.48
718,888.00 549,223.43 169,664.57
4,132,565.00 1,554,456.32 2,578,108.68
74,741.00 49,368.24 25,372.76
249,826.00 168,571.29 81,254.71
161,500.00 95,175.31 66,324.69
50,543.00 29,328.64 21,214.36
131,136.00 87,725.74 43,410.26
211,978.00 128,254.28 83,723.72
79,074.00 30,411.50 48,662.50
99,161.00 82,386.51 16,774.49
68,000.00 24,438.50 43,561.50
33,769.00 33,769.00
35,426.00 14,146.52 21,279.48
4,300.00 4,300.00
232,487.00 119,428.55 113,058.45
13,881.00 $ 7,633,076.00 $ 3,539,079.89 $ 4,093,996.11
44.71%
45.36%
76.40%
37.61%
66105%
67.48%
58.93% '
58.03%
66.90%
60.50% ,
38.46%
83.08%
35.94%
39.93%
51.37%
46.37%
PUBLIC SERVICES
VETERAN'S TRUST 319,350.00
PROBATION ENHANCEMENT 47,899.00 $
PROBATION ENH. DIS. GRANT 95,000.00
PROBATION COMM. CORRECTION 73,128.00
I.R.S. WE CARE
CIR. CT. JUDICIAL SUPPORT
JOB TRNG. PARTNERSHIP ACT 6,605,805.00
*COMPUTER SERVICES
OPERATIONS
$ 7,141,182.00 $
$ 1,458,000.00
59,955.00 S 7,201,137.00 $ 4,605,021.90 $ 2,596,115.10
$ 1,458,000.00 5 1,149,326.95 $ 308,673.05
PREPARED BY ACCOUNTING DIVIS101't PAGE 11
GOVERNMENTAL SPECIAL REVENUE &
FUNDS PROPRIETARY FUNDS
$248,543,276.00 883,384,477.00
22,420.W
2,400.00
136,372.00
(108,641.00)
42,146.05
(28,618.00)
3,651,955.00
2,049,971.00
88,031.00
209,304.00
(6,000.00)
6,741.00
50,000.00
4,900.00
15,934.74
94,989.00
1992
BUDGET AMENDMENTS
(13,286.00)
67,083.00
1992 BUDGET AS ADOPTED 12/12/91
BUDGET AMENDMENTS:
M. R. #91I72 - 8/22/91
HEALTH - HIV SEROPREVALENCE GRANT
AMENDMENT #1
M. R. #92035 - 315192
CULTURAL AFFAIRS - MICH COUNCIL OF THE ARTS
REGRANT1NG PROGRAM ACCEPTANCE
M. R. #92036 - 3/5/92
CULTURAL AFFAIRS - MICH COUNCIL OF THE ARTS
GRANT ACCEPTANCE
M. R. #92043 - 4/2/92
SHERIFF - PATROL SERVICES CONTRACTS
SPRINGFIELD & COMMERCE TWPS.
M. R. #91044 - 4/2/92
SHERIFF - PATROL SERVICES CONTRACTS
INDEPENDENCE & ORION TWPS.
PRIOR YEARS BALANCE
M. R. #92046 - 3/19/92
SHERIFF - CRIMINAL JUSTICE GRANT - TECH. ADJ.
M. R. #92062 - 412/92
CONVENTION FAC TAX PA 106/07
ADJUSTMENT FOR ACTUAL RELEWIS
PRIOR YEARS BALANCE
M. R. #92062 - 4/2/92
ENCUMBRANCES:
CARRIED FORWARD:
M. R. #92063 - 4/2/92
COMPUTERIZATION OF DISTRICT COURTS
M. R. #92063 - 412/92
COMPUTER AIDED DISPATCH FOR SHERIFF
M. R. #92071 - 4/16192
COMM. DEV. - EMERGENCY SHELTER GRANT 92/93
M. R. #92026 - 3/5192
HEALTH - T.B. OUTREACH GRANT
M. R. #91227 - 10/24192
HEALTH - IHS WE CARE GRANT
M.R. #92107 - 5/21/92
ECONOMIC DEVELOPMENT - BUSINESS
ENTERPRISE DEV. CENTER CONSULTATION SERVICES
M.R. #92087 - 5/7/92
TREASURER
CREATION OF ADDITIONAL POSITIONS
PRIOR YEARS BALANCE
M.R. #92097 - 5/21/92
F.M.&0 COMPUTER AIDED DESIGN
M. R. #92088 - 5/7/92
COMM. DEVELOPMENT BLOCK GRANT ACLEY1ANCE
TOTAL
FUNDS
$331,927,753.00
(13,286.00)
22,420.00
2,400.00
136,372.00
(108,641.00)
42,146.05
(28,618.00)
3,651,955.00
2,049,971.00
88,031.00
209,304.00
(6,000.00)
6,741.00
50,000.00
4,900.00
67,083.00
15,934.74
94,989.00
Prepared by Budget Division -32- 10-Nov-92
REVENUES:
Outside
Inside
Total Revenues
OPERATING EXPENSES
REVENUE OVER (UNDER)
EXPENDITURES
$117,500 $117,500 $130,200
434,523 434,523 432,823
$552,023 $552,023 $563,023
$554,651 $554,651 $502,851
($2,628) ($2,628) $60,172
$12,700
(1,700)
$11,000
$51,800
$62,800
OAKLAND COUNTY INTERNAL SERVICES
CLERK/REGISTER OF DEEDS
1992 THIRD QUARTER FORECAST
ADOPTED
BUDGET
AMENDED
BUDGET
1992
PROJECTED
VARIANCE
FAV/(UNFAV) COMMENTS
MICROFILM FUND
-Outside Revenue: 41,500 favorable film purchases by
title companies due to increased mortgage refinancing
partially offset by (28,800) for loss of contract
with title company for daily paper copies.
-Favorable turnover 23,100 partially offset by
unfavorable overtime (5,200); operating favorable
33,900 primarily in purchase of film (price decrease
and less film usage from shift in type of work
caused by increased mortgage refinance activity).
Prepared by Budget Division - LV 12-Oct-92
EXPENSES
OAKLAND COUNTY
RISK MANAGEMENT
1992 THIRD QUARTER REPORT
ADOPTED AMENDED 1992 VARIANCE
BUDGET BUDGET ESTIMATE FAVPUNFAV)
COUNTY BUILDING & LIABILITY INSURANCE FUND (73530)
COMMENTS
REVENUE $2,403,839 $2,403,839 $2,421,347 $17,508 -REFUND OF PRIOR YEARS EXPENDITURES FOR REIMBURSEMENT
OF CLAIMS PAID
OPERATING EXPENSE $377,557 $377,557 $369,557 8,000
PREMIUM 165,000 165,000 168,461 (3,461) PROPERTY PREMIUM POLICY
CLAIMS PAID & RESERVES 1,861,282 1,861,282 1,883,329 (22,047)
EXPENSES $2,403,839 $2,403,839 $2,421,347 ($17,508)
NET REVENUES OVER/(UNDER) $0 $0 $0 $O
LYND\FORINS3.WK1
OAKLAND COUNTY INTERNAL SERVICES
DEPARTMENT OF MANAGEMENT AND BUDGET
1992 THIRD QUARTER REPORT
ADOPTED AMENDED 1992 VARIANCE
BUDGET BUDGET ESTIMATE FAV/(UNFAV) COMMENTS
3
OFFICE EQUIPMENT FUND (66400)
OPERATING REVENUE
OPERATING EXPENSE
OPERATING INCOME
NET NON-OPERATING REV (EXP)
NET REVENUES OVER/(UNDER)
EXPENSES
981,379 981,379 938,579 (42,800)Revenues unfavorable due to delayed purchases of addditional
976,190 976,190 712,500 263,690 equipment. Operating expenses favorable due to
depreciation and savings in maintenance contracts.
$5,189 $5,189 $226,079 $220,890
(6,000) (6,000) (6,000)
($011) ($811) $220,079 $220,890
CONVENIENCE COPIER FUND (66410)
OPERATING REVENUE
OPERATING EXPENSE
OPERATING REVENUE (LOSS)
NET NON-OPERATING REV (EXP)
NET REVENUE OVER/(UNDER)
EXPENSES
$478,500 $478,500 $530,400 51,900 Favorable revenue for increased copies for Sheriff, Probate
478,500 478,500 488,600 (10,100)Court, County Clerk, and Computer Services.
Unfavorable operating for depreciation ($25,000), equipment
$0 $0 $41,800 $41,800 repairs ($27,000) not covered by maintenance contracts, and
(8,500) (8,500) interest expense not budgeted, offset by favorable copier
machine rental $20,400, maintenance contracts $15,000 and
$0 $0 $33,300 $33,300 stationery stock $6,500 for volume purchases.
7. X
Prepared by: Budget Division-cam 22-Oct-92
$52,400 $52,400 $52,400
1,069,530 1,069,530 1,221,830
1,121,930 1,121,930 1,274,230
749,160 749,160 874,300
372,770 372,770 399,930
360,552 360,552 367,540
$12,218 $12,218 $32,390
(6,797) (6,797) (6,797)
$5,421 $5,421 $25,593
PRINTING AND MAILING (66700)
REVENUES-OUTSIDE
REVENUES-INSIDE
TOTAL
COST OF SALES
GROSS MARGIN
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NET NON-OPERATING REV (EXP)
NET REVENUES OVER/(UNDER)
EXPENSES*
$0 Mailing-Favorable revenues offset by unfavorable cost of
152,300 sales $125,022 due to higher than anticipated postage costs.
An amendment will be recommended Third Quarter.
152,300 Printing-Increased revenues & cost of sales for Circuit
(125,140)Court and District Court for letterhead changes due to
turnover and Post Office requirements, Community Development
27,160 for annual report, and an unanticipated increase in the
(6,988)cost of maintenance contracts.
Printing expenses unfavorable due to change in
$20,172 depreciation schedule of fixed asset.
$20,172
OAKLAND COUNTY INTERNAL SERVICES
DEPARTMENT OF CENTRAL SERVICES
1992 THIRD QUARTER REPORT
ADOPTED
BUDGET
AMENDED 1992 VARIANCE
BUDGET ESTIMATE FAV/(UNFAV) COMMENTS
.P 0
* Adopted budget includes Equity transfer of $7,314 for computer system
RADIO COMMUNICATIONS (66000)
REVENUES - OUTSIDE
REVENUES - INSIDE
TOTAL
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NET NON-OPERATING REV (EXP)
INCOME(LOSS) BEFORE TRANSFERS
NET OPERATING TRF IN/(OUT)
NET INCOME (LOSS)
$1,000 $1,000 $28,500
1,149,259 524,631 545,500
1,150,259 525,631 574,000
665,952 693,509 509,550
484,307 (167,878) 64,450
(521,627) (521,627) (354,300)
($37,320) ($689,505) ($289,850)
639,762 639,762
($37,320) ($49,743) $349,912
$27,500 Favorable for Township Repairs
20,869 Increased installations of alarm systems for various
departments.
48,369
183,959 Favorable for turnover $8,400 offset by unfavorable
overtime ($8,000) for system change over. Operating
232,328 unfavorable for consultants ($21,160) which was budgeted in
167,327 1991 offset by favorable interest expense $25,827 due to
renegotiated financing agreement, depreciation $162,400
$399,655 due to system completion later than anticipated,
0 and loss on sale of equipment $141,500 to Road Commission
$399,655
Prepared by: Budget Division-cam 22-Oct-92
REVENUES - OUTSIDE
EXPENSES
$191,300
185,839
17,600 5,461
NET PROFIT (LOSS)
BEFORE TRANSFERS
OPERATING TRF-IN
OPERATING TRF-OUT
5,461 23,061
OAKLAND COUNTY DEPARTMENT OF PUBLIC WORKS
INTERNAL SERVICES
1992 THIRD QUARTER FORECAST
ADOPTED AMENDED 1992 VARIANCE
BUDGET BUDGET ESTIMATE FAV/(UNFAv) COMMENTS
FACILITIES MAINTENANCE & OPERATioNS
REVENUES - OUTSIDE
REVENUES - INSIDE
TOTAL
EXPENSES
NET PROFIT (LOSS)
BEFORE TRANSFERS
OPERATING TRF-IN
OPERATING TRF-OUT
REVENUES OVER!
(UNDER) EXPENSES
PONTIAc MARKET
REVENUES - OUTSIDE
EXPENSES
N.)
NET PROFIT (LOSS)
BEFORE TRANSFERS
OPERATING TRF-IN
OPERATING TRF-OUT
REVENUE OVER!
(UNDER) EXPENSES
ROYAL OAK MARKET
$1,544,974 $1,544,974 $1,506,474 ($38,500) -LOWER REVENUE FOR MAINTENANCE DEPT.CHARGES AND OUTSIDE
15,756,536 15,756,536 15,795,036 $38,500 AGENCIES OFFSET BY HIGHER REVENUE FOR SPECIAL PROJECTS
17,301,510 17,301,510 17,301,510 0
16,660,071 16,662,311 16,358,411 303,900 -OPERATING EXPENSES FAVORABLE FOR TURNOVER, NATURAL
GAS AND FUEL OIL COSTS, COMPUTER SERVICES DEVELOPMENT
AND LEASED VEHICLES; PARTIALLY OFFSET BY HIGHER COSTS
641,439 639,199 943,099 303,900 FOR ELECTRIC UTILITIES AND MAINTENANCE SUPPLIES.
(1,000,000) (1,000,000) (1,000,000)
(358,561) (360,801) (56,901) 303,900
$73,750 $73,750 $83,750 $10,000 -INCREASED DAILY STALL RENTAL.
75,339 75,339 80,439 (5,100) -HIGHER SALARY AND HOUSEKEEPING SUPPLIES COSTS.
(1,589) (1,589) 3,311 4,900
3,020 3,020 3,020
1,431 1,431 6,331 4,900
$191,300 $199,300
185,839 176,239
$8,000 -INCREASED DAILY STALL REVENUE.
9,600 -FAVORABLE SALARY AND OVERTIME cosT PARTIALLY
OFFSET By HIGHER MAINTENANCE DEPARTMENT CHARGES.
REVENUE OVER/
(UNDER) EXPENSES
TOTAL MARKETS
5,461 5,461
6,892 6,892
23,061 17,600
29,392 22,500
Prepared by Budget Division FM&OFORE
$700,854
221,000
$740,000
417,300
921,854 1,157,300
959,111 1,042,257
OAKLAND COUNTY INTERNAL SERVICES
DEPARTMENT OF PUBLIC WORKS
1992 THIRD QUARTER REPORT
ADOPTED AMENDED 1992 VARIANCE
BUDGET BUDGET ESTIMATE FAV/(UNFAV) COMMENTS
WATER AND SEWER EQUIPMENT FUND (#63800)
$700,854
221,000
921,854
959,111
(37,257)
37,257
$0
$39,146
196,300
--....—n -- .2[Wifa.
REVENUES - OUTSIDE
REVENUES - INSIDE
TOTAL
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NET NON-OPERATING REV (EXP)
NET REVENUES OVER/(UNDER)
EXPENSES
Favorable reimbursement from county
departments & municipalities for work
done & increased rental of computers,
235,446 generators and misc. equipment.
(83,146) Unfavorbale salary expenses are offset
by revenue. Income from investments
(37,257) 115,043 152,300 is unfavorable due to lower interest
37,257 10,557 (26,700) rates. Excess revenues over expendi-
tures will be used for equipment
$0 $125,600 $125,600 replacement
.= = .. .
NANC\QTRFORE.WK1 10/26/92
OPERATING REVENUES:
Outside
Inside
Total
OPERATING EXPENSES
$1,458,000 $1,458,000
9,394,177 9,500,685
$10,852,177 $10,958,685
$10,842,929
$1,637,000
9,375,685
$11,012,685
$179,000
(125,000)
$54,000
($466,200) $10,949,437 $11,415,637
OPERATING INCOME (LOSS)
NET NON-OPERATING REV (EXP)
NET REVENUES OVER (UNDER)
EXPENSES*
$9,248
(178,221)
($168,973)
$9,248
(178,221)
($168,973)
($402,952) ($412,200)
(178,221)
($581,173) ($412,200)
*Equity transfers to Computer Services in the amount of $365,931 approved
through August 31 are not included in this statement.
**Funds were transferred to Computer Services in 1991 for fiber optics, and
the Budget was based on the fiber optics being capitalized and depreciated.
However, in conformance with the recently-issued depreciation policy,
infrastructure is to be expensed. Thus, the total fiber optics project will be
expensed in 1992, partially offset by the depreciation portion that was
anticipated in the budget. A budget amendment is recommended.
OAKLAND COUNTY INTERNAL SERVICES
COMPUTER SERVICES
1992 THIRD QUARTER FORECAST
ADOPTED
BUDGET
COMPUTER SERVICES FUNDS
AMENDED
BUDGET
1992
PROJECTED
VARIANCE
FAV/(UNFAV) COMMENTS
-outside Revenue: 133,000 favorable reimbursement
for services to outside agencies; 46,000
favorable in-car terminals.
Inside Revenue: lower than estimated imaging
operations revenue due to delay in implementation
and rate adjustment for costs not recoverable
from the state (budget amendment recommended).
-Turnover favorable 116,000; overtime unfavorable
(11,000). Computer operations unfavorable
(543,700) as follows: fiber optics installation
(349,700) and parts & accessories (115,000) due
to change lu accounting depreciation policy
(**see note below); communications (135,000)
and telephones (20,000)***; equipment repairs
and maintenance (65,000); copies (7,000);
partially offset by favorable equipment rental
58,000; depreciation 80,000 for change in
accounting policy; and training 10,000.
Also, in-car terminals unfavorable (27,500) due
to additional terminals for outside agencies (see
revenue note above) and development to access
LEIN and CLEMIS systems.
***Increased communication and telephone expense is for the following reasons:
1) wiring of County buildings to accommodate automated office systems (one-time costs),
2) conversion from analog to digital data lines (one-time costs), and 3) additional
data lines due to increased customer base (see offsetting revenue above).
Prepared by Budget Division - LV 02-Nov-92