HomeMy WebLinkAboutResolutions - 1999.09.09 - 25898MISCELLANEOUS RESOLUTION 1/99228 September 9, 1999
By: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - FISCAL YEAR 1999 THIRD QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act
for Local Units of Government, provides for adjustments to the adopted budget;
and
WHEREAS in accordance with Oakland County General Appropriations Act
Section 22, which authorizes budget adjustments for variances between the
budgeted revenue and actual revenue, and Section 23, which authorizes budget
adjustments for variances between estimated revenue and projected expenditures,
adjustments are required; and
WHEREAS the Fiscal Year (FY) 1999 Third Quarter Financial Forecast Report
has identified several variances and budget amendments are recommended; and
WHEREAS the County has committed the General Fund equity of $36.0 million
as of September 30, 1998 and has appropriated the following amounts:
Millions
General Fund Equity Balance as of 9/30/99 $36.0
Appropriated During FY 1999 18.6
Net General Fund Equity as of 8/19/99 $17.4
Favorable Variance Per FY 1999 Third Quarter $13.1
Forecast - Restoration to General Fund Equity
PROJECTED GENERAL FUND EQUITY 9/30/99 $30. ; and
WHEREAS governmental financial management standards state that not less
than an amount equal to 10% of the General Fund budget should be retained in
equity, this standard would require a General Fund equity of $32.8 million, $2.3
million above the FY 1999 projections; and
WHEREAS the 52nd District Court has experienced additional expenditures due
to increased use of testing material (Division I), a new defense attorney payment
schedule (Division II), unplanned leaves of absence (Division III); however the
District Court has' generated additional revenue to offset these expenditures; and
WHEREAS Probate Court commitments to State institutions are projected to
exceed the budget, however additional Board and Care revenue and decreased
defense attorney expenditures can be used to offset the projected overage; and
WHEREAS the Office of the Prosecuting Attorney has incurred favorability
partially due to operational improvements, a portion of which is requested to be
used for a one-time purchase of technical equipment; and
WHEREAS the Register of Deeds is experiencing an increase in costs for
Micrographics and Reproductions due to high real estate activity, however due to
delay in start of the imaging program, there is favorable Professional Services
which can be used to offset this variance,; and
WHEREAS the Treasurer's Office has turnover favorability which can be used
to offset the cost of the high volume of tax statement mailings; and
WHEREAS Facilities Engineering is in need of new furniture to accommodate
positions that have experienced increased office assignments as opposed to field
assignments, there are sufficient overtime savings to cover the furniture cost;
and
WHEREAS no revenue has been generated for Hospital Administration Charges
in Human Services Administration; and
WHEREAS the Senior Public Health Sanitarian created for the City of
Southfield Sanitarian Service was not filled until January of FY 1999, which
resulted into a favorable variance in salaries and fringe benefits and an
unfavorable variance in reimbursement revenue; and
WHEREAS the Medical Examiner's Office is projected to have unfavorable
expenditure variances due to a high usage of contracted assistance for Medical
Services - Autopsies, use of Professional Services, and IT-Operations due to
actual charges being higher than budgeted; and
WHEREAS Children's Village has experienced a decrease in their professional
services needs for FY 1999 which can be used to offset the increased Medical
Examiner's expenditures; and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Amos absent.
ANCE COMMITTEE
WHEREAS the Sheriff's Department is experiencing unplanned Overtime cost
due to the necessity of filling the Royal Oak patrol contract with current
employees until new employees are hired; and
WHEREAS an additional capital outlay appropriation is required to fund the
remaining security equipment in the main jail as recommended by the Corrections
Staffing Study Committee; and
WHEREAS Library Continuations is projected to be unfavorable based on the
assessment of the need to purchase additional publications; and
WHEREAS the County Executive Administration Division has need for
additional appropriation for travel for the trade mission to Europe, Professional
Services to support the lobbying function, membership in the County Executives
of America Association, and Office Supplies due to expanded use of the Staple's
contract; and
WHEREAS the Second Quarter Forecast amended Corporation Counsel's Salaries
budget in anticipation of delayed hire of new personnel, however, Corporation
Counsel and Personnel were able to identify and hire staff earlier than
anticipated; in addition, furniture costs have exceeded original estimated; and
WHEREAS the Support Services Division of Central Services requires
additional Micrographics work to streamline their inventory and report systems;
and
WHEREAS an amendment is necessary in Travel and Conference for Personnel
Administration in order to fully train the staff in the proper use of the
PeopleSoft Human Resource System; and
WHEREAS Circuit Court Probation is projected to be unfavorable in Training
and Psychological and Medical Exams due to outstanding invoice from previous year
that had been audited and determined to be the County's responsibility; and
WHEREAS the Community Corrections Division of the Department of Public
Services requires an additional appropriation to fund the acquisition and
operation of an aditional vehicle and equipment for the Weekend Alternative for
Misdemeanants (WAN) Program; and
WHEREAS the FY 1999 non-departmental accounts for Contingency, Rate and
Classification Change, Office Automation, and Summer Help, require additional
appropriations to cover their increased utilization this fiscal year; and
WHEREAS an additional appropriation is necessary for Information Technology
- Operations, in various departments, to cover the increased costs due to the
success of the Information Technology Leadership; and
WHEREAS the Register of Deeds continues to generate additional revenue due
to the high real estate activity, this revenue can be used to offset additional
expenditures in other departments; and
WHEREAS Section 25 of the General Appropriations Act requires that the
Board of Commissioners receive a quarterly report regarding adjustments made to
Inmate Accounts on transactions billed in excess of ability to pay, as well as
approve the write-off of any bad debt in excess of $1,000; and
WHEREAS with the Second Quarter the Department of Management and Budget
requested write-off of $4,123.20 in unpaid debt due for payment made to a private
institution for a ward of the State of Tennessee; and
WHEREAS at the request of the Finance Committee, the Department attempted
several methods to collect this debt and suggests that further efforts would cost
more than the amount of the debt.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the
Fiscal Year 1999 Third Quarter Financial Forecast.
BE IT FURTHER RESOLVED the Board authorizes amendments to the FY 1999
Budget as detailed on attached Schedules A and B.
BE IT FURTHER RESOLVED that the Board authorizes the expansion of the
County Vehicle Fleet by one vehicle to be assigned to the Community Corrections
Division for the Weekend Alternative for Misdemeanants (WAN) Program.
BE IT FURTHER RESOLVED in accordance with Section 25 of the General
Appropriations Act, the Board of Commissioners approves the write off the debt
in the amount of $4,123.20 for payment for a ward of the State of Tennessee.
Chairperson, on behalf of the Finance Committee, I move the adoption of the
foregoing resolution.
10
14
37
40
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FINANCIAL FORECAST
TABLE OF CONTENTS
PAGE
1
3
TRANSMITTAL LETTER
SUGGESTED RESOLUTION (including amendments)
SUMMARY OF GENERAL FUND/GENERAL PURPOSE REVENUES 9
AND EXPENDITURES BY DEPARTMENT
FY 1999 THIRD QUARTER REVENUE EXPLANATIONS
Detailed sheets for each Department/Division showing
variances for general fund/general purpose revenue with
explanation of variance.
FY 1999 THIRD QUARTER EXPENDITURE EXPLANATIONS
Detailed sheets for each Department/Division showing
variances for general fund/general purpose expenditures,
with explanation of variance.
BUDGET AMENDMENTS
List of Miscellaneous Resolutions authorizing amendments
to the Adopted Budget.
INTERNAL SERVICE FUND REPORTS
Summary of Revenues and Expenses with explanation of
variances from Budget.
INMATE WAVIER REPORT 48
COUNTY MICHIGAN
DEPARTMENT OF MANAGEMENT AND BUDGET Robert J. Daddow, Director
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
TO:
FROM:
SUBJECT:
DATE:
Members of the Finance Committee
Robert J. Daddow, Director, Management and Budget
Letter of Transmittal - Fiscal Year (FY) 1999 Third Quarter Financial Forecast
August 19, 1999
Attached please find the FY 1999 Third Quarter Financial Forecast. In total, the County is
forecasted to have, by the end of FY 1999, a $13,088,538.79 favorability in the General
Fund/General Purpose operations. This project amount equals 4.07% of the FY 1999 General
Fund/General Purpose Amended Budget. The overall favorability includes receiving an
estimated $6,823,974 more revenue than budgeted (2.12%), and expending $6,264,564.79 less
than budgeted (1.95%).
REVENUES
General Fund/General Purpose revenues are estimated to be 2.12% above budget or
$6,823,974.00. This favorability reflects a number of events:
A. GENERAL FUND - INTERGOVERNMENTAL REVENUE (fay. $1,098,800)
This favoarability results from the same areas reported in the second quarter:
increased state payments for Cigarette Tax and the Court Equity Fund, and well as
booking of the indirect cost payment from Community Mental Health for FY
1998.
B. GENERAL FUND - CHARGES FOR SERVICES (fav. $4,954,774)
The primary vehicle for favorability remains the high real estate activity as
evidenced in increased revenue for the Register of Deeds for Mortgages and
Recording Fees (approximately $2.4 million). In addition, however, revenue from
the State for diverted felons is $1.1 million higher than anticipated due to active
invoicing by Fiscal Services staff of prisoners who's offenses were committed
prior to 1999. The new sentencing guidelines are not yet effective for offenders
currently being processed by the courts. It was anticipated that this processing
would begin in April 1999. however this delay simply increases County revenues.
Finally the 52nd District Court is also projected to experience approximately $1.0
million in favorable revenue due to increased probation activity and bond
forfeiture revenue.
C. GENERAL PURPOSE FUNDS - INTERGOVERNMENTAL (fav. $1,000,000)
This recognizes the continued 50% reimbursement received from the state for the
Child Care Fund. The amount reflects what has been received and what has been
invoiced so far this year.
EXECUTIVE OFFICE BUILDING 34 EAST • 1200 N TELEGRAPH RD DEPT 409 • PONTIAC Mt 48341-0409 • (248) 858-0490 • FAX (248) 452-9215
D. GENERAL PURPOSE FUNDS - CHARGES FOR SERVICES (fav. $470,400)
The favorability is due to the previously reported favorable settlement of prior
years' Waterford Schools revenue (additional state payments) as well as increased
Board and Care revenue for wards of the Probate Court.
The forecast also projects that Miscellaneous Revenue will fall $700,000 below budget. This
reflects the fact that Interest Income is not as high as originally projected, as the Internal Service
funds capture their share of revenue and the full impact of the loss of the CMH advances is felt.
EXPENDITURES
In total, expenditures are estimated to be 1.95% below budget or $6,264,564.79. Almost the
entire amount of favorability is related to vacant and underfilled positions (known as turnover).
It is important to note, however, that the level of turnover favorability continues to
decrease from previous years.
At this time, only the Board of Commissioners - Library Board is projected to be over budget.
This over expenditure is due to the need to purchase additional legal materials for judges and
prosecutors. A budget amendment is recommended. The projected favorability, however, masks
a variety of concerns in specific departments. Budget amendments are recommended to make
certain controllable categories whole.
FUND BALANCE
Please note the fourth and fifth "WHEREAS" paragraphs on the first page of the resolution. This
references the fact that, although $13.1 million seems to be a large favorability, this amount
when added to the current fund balance will simply restore the General Fund equity close to
the recommended standard for this fund balance.
Please review the attached. Should you have any questions, please feel free to contact me, the
Financial Analyst involved with the Department, or our committee staff liaison, Tim Soave.
Schedule A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 1999 THIRD QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES
ACCOUNT NUMBER ACCOUNT NAME
FY 1999
AMENDMENT
1GF/GP OPERATIONS - SELF BALANCING AMENDMENTS
District Courts
Revenue
32-201100-20001-2097
32-301100-20001-0753
32-401100-20001-0813
Expenditures
32-201200-20001-3764
32-301200-20001-2640
32-401200-20001-2001
32-401200-20001-2002
Probate Court
Revenue
32-301100-40009-0315
32-301100-40009-0539
Expenditures
34-401200-40001-2640
34-301200-40009-3640
Prosecutor
Expenditures
41-211000-10000-2548
41-211000-10000-2612
41-211000-10000-2792
41-211000-10000-2808
41-211000-10000-2828
41-211000-10000-3624
41-211000-10000-3720
41-211000-10000-3836
41-211000-10000-4100
Div. I - PSI & Alcohol Assess.
Div. ll - Ord., Fines and Costs
Div. III - Probation Fees
Div. I - Training & Medical Exams
Div. II - Attorney Fees
Div. III - Salaries
Div. III - Fringe Benefits
Board and Care
Govt. Benefit Board and Care
Defense Attorney Fees
State Institutions
Computer Research
Court Transcripts
Expert Witness Fees
Extradition Expense
Filing Fees
Special Prosecuting Attorney
Transcripts on Appeals
Witness Fees and Mileage
Expendable Equipment Exp.
$20,000
7,000
10,000
$37,000
$20,000
7,000
4,000
$37,000 so
$120,000
100,000
$220,000
($180,000)
400,000
$220,000 so
($10,000)
(15,000)
(5,000)
(10,000)
(20,000)
(6,875)
(2,000)
(20,000)
88,875 so
($20,000)
20,000 so
Salaries
Postage
($7,000)
_TWO
so
Overtime
Equipment Replacement
($500)
MOW so
($33,000)
($24,000)
(9,000)
($33,000) so
($100,000)
Hospital Admin. Charges
Travel and Conference
Reimbursement Contract
Salaries
Fringe Benefits
Professional Services
Medical Services - Autopsies
Professional Services
Info Tech. - Operations
$41,000
20,000
39.000
$100,000 so
Clerk /Register of Deeds
Expenditures
21-240100-01000-3348
21-240100-01000-6654
Professional Services
Micrographics & Reproduction
($48,500)
48,500
so
Treasurer
Expenditures
22-221120-01000-2001
22-221120-01000-4248
Facilities Engineering
Expenditures
14-280000-10000-2002
14-280000-10000-2780
Department of Human Services
Administration
Revenue
16-111000-10000-0567
Expenditures
16-121000-10000-3756
Health Division
Revenues
16-220100-62201-0901
Expenditures
16-220200-62201-2001
16-220200-62201-2075
Children's Village
Expenditures
16-201200-10000-3348
Medical Examiner
Expenditures
16-912000-15000-3156
16-912000-15000-3348
16-912000-15000-6636
GF/GP OPERATIONS - GENERAL AMENDMENTS
Revenues
Clerk/Register of Deeds
21-140100-01000-0625 Land Transfer Tax $744,388
Total Revenue $744,388
Overtime
Misc. Capital Outlay
Library Continuations
Membership, Dues and Pub.
Professional Services
Travel and Conference
Office Supplies
Salaries
Expendable Equipment Exp.
Micrographics
Leased Vehicles
Professional Services
Travel and Conference
Training, Psych, & Med. Exams
Op.Trans. - Vehicle
$100,000
136,000
$236,000
$48,300
$10,800
32,000
17,000
5,000
$64,800
$7,500
4,9_Ck
$12,400
$42,000
1,900
(8,000)
$35,900
$2,500
$18,100
$50,000
Expenditures
Sheriff Department
43-023618-30003-2002
43-023601-20004-9169
Library Board
51-232000-53300-3076
C E)t_c
11-210100-01000-3172
11-210100-01000-3348
11-210100-01000-3756
11-210100-01000-4252
Corporation Counsel
11-250100-20000-2001
11-250100-20000-4100
Central Services
13-138203-00010-6654
13-131002-00001-6661
13-131002-00001-3348
Personnel
15-101200-10001-3756
Circuit Court Probation
17-901200-90001-3764
Community Corrections
17-403200-70211-8001
Non-Departmental
90-290000-25000-2564
90-290000-25000-9021
90-290000-25000-9066
90-290000-25000-9084
Schedule B Information Tech.
Total Expenditures
;TOTAL GF/GP OPERATIONS
Contingency
Rate & Classification Changes
Office Automation
Summer Help
$40,000
27,000
85,000
121,000
$273,000
$3,388
$744,388
so
Information Technology
1999 3rd Quarter LT. Operations
Schedule B
DEPT/OCA/PCA/Object
6636
18-636111-10000-0737 Budgeted Depts.-Oper.
MO FY 1999
Customer
Number
1999 3rd Qtr
Approp. 3rd Qtr. 3rd Oh r 1999 Amended
Budget E2tpend itu re Balance Forecast Budget
15 11-210100-01000-6636
620 11-220100-10000-6636
690 12-401200-40010-6636
660 12-601200-10001-6636
650 12-701200-10001-6636
400 12-705212-10001-6636
445 13-138201-10-6636
637 13-138203-10-6636
643 13-667302-10-6636
6130 15-402200-10001-6636
840 16-201200-10000-6636
845 16-234200-80000-6636
872 16-912000-15000-6636
450 17-901200-90001-6636
775 19-221000-10000-6636
720 21-240100-1000-6636
723 21-220500-1000-6636
470 31-201200-10004-6636
481 34-101200-40001-6636
480 34-401200-40001-6636
145 41-211000-10000-6636
826 51-231000-53000-6636
827 51-231000-53200-6636
828 51-231000-53100-6636
824 51-232000-53300-6636
907 51-233000-53500-6636
730 61-211001-10000-6636
County Executive
Auditing
Purchasing
Fiscal Services-Admun
Reimbursement
Reimb.-Child Support/FOC/Reimb.
Support Services
Record Retention
Print Shop
Personnel-Human Res. Div.
Health
Health-Clinic
Medical Examiner
Circuit Court Probation
Development 6. Planning
Clerk/Reg of Deeds Admin
Clerk-Vital Statistics
Friend of the Court
Probate-Juvenile
Probate Court
Prosecutors Office
Research Library
Library-Jail
Library for the Blind
Law Library
Library-Admin.
Drain Commissioner
170,660 124.021 46,639 164,000 (6.660)
92,429 69,322 23,107 93,100 671
75,570 57,630 17,941 75,390 (180)
406,150 311.701 94,450 423,000 16,850
302,162 226,938 75,224 302.900 738
107,086 79.489 27,597 105.489 (1.697)
31,236 20.813 10.423 27,935 (3.301)
32.898 25,957 6.941 35,465 2,567
14.000 14,481 (481) 19,308 5,306
386,558 290,764 95,794 388,250 1,692
953.573 706,267 247.306 941,900 (11,673)
1,492 756 736 3,024 1,532
32,968 11,404 21,564 50,000 17,032
87,208 65,016 22,192 45,845 (41,363)
344.668 258,581 86,287 352.581 7,713
556,350 417,352 138,998 557,352 1,002
24,954 17,333 7,621 23,133 (1,821)
399.918 271,721 128,197 365,000 (34.918)
396,831 292,753 104,078 388.000 (8,831)
527,406 401.807 125,599 540,807 13,401
908,692 679,549 229,143 907.549 (1.143)
145044 134,079 10.965 145,464 420
4.221 4,221 5,628 5,628
20,885 27.820
96520 72,866 23,654 97,866 1,346
17,640 12.617 5,023 16,414 (1,226)
52,978 44,959 8,019 65,359 12,381
3,388
3ADJ.WK4 08/10/99
5280,719.905.00
29,532,915.50
8.993.970.24
218.526.585 74
1299.246,790.74
TOTAL GOVERNMENTAL RESOURCES $293711502.00 5321,308.374.05 .=====i=2..= ==.2132===== *328,132.34805 36.823,974.00 =========amm.: 2.12%
4.18%
0.91%
TOTAL LAW ENFORCEMENT $86.943,763.00 390.516,669.26 289.208.169.26 $1,308,500.00 1.45%
TOTAL GENERAL GOVERNMENT 532.384,161.00 529,719.804 42 529.345.373 89 $374,430.53 1.26%
TOTAL COUNTY EXECUTIVE 295 614 759 00 5105,296.071.88 $102 894 237 52 22.401.834.26 2.29%
TOTAL DEPARTMENTS 2271 094 753 00 2283,670,433 13 2277 808,668 34 55 861.764 79 2,07%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS $22,615,749.00 537,637,940 92 237.235,140 92 4.39% $402,800.00
TOTAL GOVERNMENTAL EXPENDITURES $293,71 1 , 502. 00 2321,308,374,05
=============
5315.043.809 26 $6,264,564.79 =======xxx=====
1.95%
General Fund/General Purpose
Favorable/(Unfavorable) $O ========: st $13,088,538.78 S13.488,538.79 20
FY 1999 THIRD QUARTER FINANCIAL REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 1999
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 1999
FORECAST
AMOUNT
FAVORABLE(
(UNFAVORABLEI PERCENT
REVENUE
GENERAL FUND
Taxes
Intergovernmental
Charges fOr Services
Miscellaneous Revenue
SUB-TOTAL GENERAL FUND
GENERAL PURPOSE FUNDS
Intergovemniental
Charges for Services
SUB-TOTAL GP FUNDS
TOTAL GF/GP FUNDS
Resources carned forward
2158,040,000.00 5158.040.000.00
32,287.800.00 33.687.334 00
64,335.132.00 68,640,871.00
20,351,700.00 20.351,700.00
5275.014.432.00
57.340,000.00
6.923.620.00
$14263,620.00
5289.278.052.00
122,081,583,31
2158.040.000.00
34,786,134.00
73,595.645.00
19,651.700 00
2288,073,479 00
210.532,915.50
9,464.370.24
$19,997,285.74
$308,070,764.74
222.051,583.31
$0.00 0.00%
1,098.800.00 3.26%
4,054,774.00 7.22%
(700,000.00) -344%
S5,353,574.00 1.91%
51,000.000.00 10.49%
470,400.00 5.23%
51,470,400.00 7.94%
*6.523,97400 2.28%
S0.00 0.00% 24,433,450.00
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL AOMIN OF JUSTICE
523.649.573 00 $24,885,823,87 523,740.423 57 $1,145,430.00 4.80%
10,667.826.00 10,983,871.97 10,701,671 97 282,000.00 2.57%
21.834.871 00 22,268.391.73 21.918.791.73 349.600.00 1.57%
556.152,070.00 $58,137,887.57 556.360,887.57 21,777,000.00 3.08%
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
214.380,666.00 514,997,138.64 214,372,638.64 2624,500.00
72,563.097.00 75,519,530.62 74.835.530.62 684,000.00
GENERAL GOVERNMENT
ClerviRegister of Deeds
Treasurer --(Library Board of commissioners Board )
Drain Commissioner
$8,576,971.00 29,234,972.17 29 045,072 17 5189.800.00
2,905.811.00 3,198.255 18 3.159,25518 39,000.00
14,279.255.00 14,383,348 54 14.431.598 54 (48,250,00)
6.622,124 00 2,903.328.53 2.709.445 00 193,880.53
2.06%
1.22% ,„., -(Library Brd.
4'7'1 Lego I Mat I ' s . 6.88%
COUNTY EXECUTIVE
County Executive Admn
Management and Budget
Central Services
Facilities Management
Personnes
Hurnar Sys
Public Services
Information Technology
Community & Economic Dev
$4,322.834 00 54,603,730.99 $4.595.930 99 $7,800.00
15 704,533.00 13.993.486.66 13,770.814 56 222,672.00
1,655,206 00 1.738,431 59 1 707,63'. 59 30,800,00
2,760.063 00 1,971,259.56 1.816.991 00 154,268.56
3,746 646 00 4,008.055.08 3.976,655 Oa 31,400.00
51.377.389 00 54,669,456.14 53.168,056 14 1.501,400.00
7,019,17200 7.412,541 09 7.100.641 09 311,900.00
5,006.808.00 8.895,141.34 8.758.975.64 136.165.70
4,022.288 00 8,003,969 43 7.998.54' 43 5,428.00
0.17%
1.59%
1.77%
7.83%
0.78%
2.75%
4,21%
1.53%
,07%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
MeNIMMIIMININKMell
REVENUE
PROPERTY TAXES
1997 Tex Levy
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
6157,345.00000 $157,345,000 00 $157,345,000 00 $000 0 00%
NET CURRENT PROPERTY TAX $15734500000 $15734500000 8157.345,00000 *0 00 000%
OTHER TAXES
Other Imes $695.000 00 8695,000.00 $695,00000 *0 00 000%
.....
695,00003 695,000.00 695,00000 000 0.00%
TOTAL PROPERTY AND OTHER TAXES 8158,040.000 00 $158,040,000 00 8158.040,00000 $0.00 000%
BUDGETED RECEIPTS OTHER THAN TAXES
GENERAL FUND STATE AND FEDERAL
Outside Agencies
TOTAL BUDGETED RECEIPTS
GENERAL FUND STATE AND FEDERAL
$32,297,600.00 $33,687,334 00 $34,788,134.00 $1098,80000 326% Increased Cigarette Tax and Court Equity Fund fund payments (already received) as well as
..... - --------- - increased Indirect Coat revenue due to payment from CMH for FY 1998
$32,287,600.00 133.687,33400 $34,786,134 00 $1,098,80000 326%
CHARGES FOR SERVICES
County Executive Administration $3170000 831,700 00 831,700 CO $0 00 0 00%
Auditing 117,40000 303,759 00 303,759.00 000 000%
Corporation Counsel 235.60700 128.607 00 128,607.00 000 000%
Fiscal Services 418.000 00 418,000 00 419,000.00 0 00 000%
Reimbursement Division 220.000 00 220.000 00 250,700.00 30,700 00 13 95% -Fav due to receipt of unbudgeted Civit Action Entry Fees $4,500, Misr $7,900 and Tax
Intercept Fees of 819.300
Central Services Administration 000 000 140 00 14000 Fay due to receipt of unbudgeted Per Diem revenue for Parks and Rec. Board attendance.
Materials Management 13,000 00 13,000 00 1,00000 (12,000 00) 000% -Most suction revenue credited to supplying departments, less general auction revenue.
Support Services 71,800 00 71.800 00 58.800.00 (13,000 00) -18 it % -Contract change for Oakland Room set-vices reduced anticipated revenue.
Facilities Mgt - Admin 416.01000 295.19300 295,193.00 000 000%
Facilities Engineering 16,47000 16.47000 16.47000 000 000%
Personnel 12.257 00 12.25700 23,158 00 10,901 00 88 94% -Fay Misc Rev. $14,300 due to unbudgeted funds to pay for Student Intern for Cira.ot Cl
and Private pay, partially offset by unfav Hosp Admin Chgs ($3,399) due to reimbursement
of Cobra charges revenue being recognized in the Fringe Benefit Fund A budget amendment
is recommended
Family Independent Agency. 50000 500 00 000 (500 00) -100 00% -Historically has declined, no revenue anticipated for FY 1999 based on lest nine months
A budget amendment is recommended
Medical Examiner 77,800 00 77,800 03 77,900 00 000 000%
0811719911:12 AMFIRSTREV.WK4 1 08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE(
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
REVENUE
Public Services 11,300.00 11.30000 000 (11,300.00) -100 00% Employment & Training Reimbursement of Salaries moved to Dept of Community &
Economic Development. A budget amendment is recommended.
MSU Extension- Oakland County 349,934 00 349,934.00 349,934.00 000 000%
Community Court Services 109,694 00 122,244 00 139,244 00 17,000.00 1391% -Fay due to increased fees from WAM. expansion of the Step Forward program and receipt of
unbudgeted Forfeiture of Bonds. Donations, and Rebates on Purchases
Development & Planning 831,000 00 751,817 00 651,817 00 (100.000 00) -1330% -Map sales not as high as anticipated.
Equalization 1,650,041.00 1,730,081 00 1,733,981.00 3,90000 0.23% Receipt of unbudgeted revenue for Educational Training $1,000 and Misc $2.900
COUrIty C1Ofit 1,774,160.00 1,781,760 00 2,223,760.00 442,000.00 2481% -Fay. Forfeiture of Bonds $364,500 and Certified Copies due to increased activity.
Elections 10.400.00 10,400 00 20,400.00 10,000 00 9015% -Fay Board of Canvasser Service Fees based on electionactiyity
Register of Deeds 8,099,593 00 11,282.793.00 13,702,193.00 2.419,40000 21 44% - Farr. Mortgages $556,500, Land Transfer Tax $1.173,700. Recording Fees $558.900,
Deeds $94.100, and Photostats due to high real estate activity
Treasurer 4,580.865 00 4,580,865 00 4,636,065 00 55,20000 1 21% -Fay. Tax Statement fees due to high real estate activity
Circuit Court 3,070,550 00 3,281,000 00 3,258,200.00 (22.800 00) -0.69% Fay. Defense Att. Refunds $45,000 reflects increased collections Unfay. Mediation
Fines, 0136,2000 and Psychological Testing and Evaluation Fees ($7,600) due to
reduced aCtiyily which is also reflected in decreased expenditure Fay. Court Costs revenue,
576,000 is historically supported and reflects increased activity.
Friend of the Court 7,094,500 00 7,094,500.00 7.540.000 00 445,500 00 6 28% - Unfav. Miscellaneous (847.2001 due to change in recording fees, Unfav Federal
Incentive payments ($269,300) reflects reduced rates and caseload Fax CRP Contract
$700.000 is historically supported, Fav Alimony Service Fees. $62,000 reflects
increased activity
District Court 7,929.097 00 7.981,39700 8,964,297 00 982,900 00 12.31% -Fax. PSI/Alcohol assessments 876,300 and Probation Fees. $314,800: due to increased
probation caseload Fax Ordinance Fines & Costs $387,200, Bond Forfeiture 8111,800.
Late Penalty $56,500, Filing Fees $20,400. and No Proof of Insurance Fee $34.500,
reflect increased activity Attorney Fee reimbursement is fay 89.100 State Law Costs
are urrfav (827,700) due to fewer tickets being issued on state laws
Probate Court 1,160.800 00 1,153,200.00 1,162,000 00 8,800.00 076% Fax Clinic Evaluations 815.200 due to increased activity., Fay Bond Forfeits $7,000 is a
new revenue. Unfav Certified Copies, (825,800), and WWI Deposits (86.900) Sr. due to
reduced demand Fay Photostats, $5.500 reflect increased use Fay Probation Fees,
$13.800 felled, increased use and collection efforts
Prosecutor 177,622 00 205,622 00 205.622 00 000 000% .
Sheriffs Office 10.80000 185,800 00 231.800 00 46,000 00 24 76% -Fay $26,030 SS Incentive Payments. Shared Bench Warrants arid $20,000 NET Refunds
Administrative Services 1.50000 1.50000 1,50000 000 000%
Corrective Services 3.298.700 00 3,438,043 00 4,538,04300 1,100.000 00 31 99% -Fay 8100.000 Inmate Board and Care. and $1,000,000 Diverted Felons underestimated
Corrective Services - Satellites 1.375.27500 1.375.725 00 1.375,72500 000 000%
Protective Services 16.230.672 00 17,380.418 00 17.380.41800 000 000%
Technical Services 256.600 00 286.60000 271,100 00 14.500 00 565% -Fay $14,500 reimb NET salaries underestimated
08117/9911:12 AMFIRSTREVNVIC4 2 08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30, 1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE/
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
REVENUE
Board of Commissioners 20.500 00 10.500 00 10,500 00 000 0 00%
Library Board 184.482 00 178.214 00 164,714 00 (13.500 00) -7 58% -Unfav Computer Research Fees (54.500) and Copy Machine Charges ($9,000) due to
increased utilization of CD Rom products A budget amendment is recommended.
Sundry 0 00 3,000,000 00 3,000.000 00 0 00 0 00%
Drain Administration 501,78400 408,322 00 100.000 00 (308,322 00) -75.51% Unfav. due to reduced administration salary expense invoiced to other funds, as well as
Operations & Maintenance 770,456 00 000 000 000 000% lower grant revenue
Engineering & Construction
TOTAL CHARGES FOR SERVICES
GENERAL FUND
3,434.263 00 479,750 00 329.005 00 (150,745 00) -31,42% Unfav, due to reduced administration salary expense invoiced to other funds
$6433513200 $68640871 00 $73,595,645 00 $495477400 7 22%
BUDGETED RECEIPTS - GENERAL PURPOSE
GOV'T STATE AND FEDERAL
Outside Agencies 57.340.000 00 $953291550 $10,532,915.50
TOTAL BUDGETED RECEIPTS - GEN. PURPOSE $7,340,000 00 $9,532.915 50 510,532,91550
GOV'T STATE AND FEDERAL
$1000000 00 10.49% Recognition of scr% Child Care Fund reimbursement already received and requested
$100000000 1049%
CHARGES FOR SERVICES
Facilities Management Admin. 2,21000 2.21000 1,81000 (400.00) -18 10%
Health Division 2,173.91000 3,483.344 73 3.523,644 73 40,300 00 1 16% Fair primarily reflects high volume of vaccinations and immunizations administered
Children's Village 2.680.50000 2.680.50000 2,861.400 00 180,900 00 675% -Fey reflects receipt and adjustment of prior years revenue
AnYwal Control 819,800 00 819.800 00 819.800 DO 000 000% ..
Friend of the Court 437,200 00 437.20000 393,20000 (44,000 00) .10 06% -Stale Incentive unfav ($34.000) due to formula change and reduced caseload Utley FOC
Filing Fees ($10,000) retects reduced activity and is historically supported
Probate Court 810,000 00 810,00000 1.103,60000 293,600 00 3625% -Fax Board and Cafe, $166.900, and Gov't Board and Care, $126,7013 reflect increased
activity and collection efforts
Non-Departmental 0 760,916 760.915 51 0 000%
$692362000 $899397024 $946437024 S470,400 00 523%
08/1719911:12 AMFIRSTREV.WK4 3 08/17/99
TOTAL AVAILABLE RESOURCES
GENERAL FUND/GENERAL PURPOSE $346,033.268 00 3371,797,670 68 $379.621,644 68
OPERATING TRANSFERS $52,321,766.00 550,489,296 63 550.489,29663
54,433.450 00 522,061,583 31 522.061.58331 $000 000%
30 .00 000%
$6.823,974 00 1 94%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER REPORT
RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL
SPECIAL REVENUE AND PROPRIETARY FUNDS
FOR YEAR ENDING SEPTEMBER 30,1999
BUDGET BUDGET AMOUNT
AS AS FY 1999 FAVORABLE]
ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT
REVENUE
MISCELLANEOUS REVENUE
Sundry $1.050,00000 $1050000 00 $1,050.000.00 $0.00 000%
Investment Income 19,301,700 00 19,301,700 00 $1860170000 (700,00000) -363% Decrease in investment income due to interest credited to other funds
520,351,700 00 520.351,70000 519.651.700 00 ($700,000 00) -344%
RESOURCES CARRIED FORWARD
Prior Year's Balance 54.433,45000 $22.061 583 31 $2206158331 $0 00 000%
Less Operating Transfers (552,321,766 013) ($5048929663) (550.489.296 63) $000 000%
NET GWGP RESOURCES 5293,711,502,00 5321,308,374.05 $328,132,348.05 $8,923,974.00 2.12%
08/17/9911:12 AMFIRSTREV.VVK4 4 08/17/99
064%
6.25%
$39,600.00
435,700.00
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
CIRCUIT COURT
ADOPTED AMENDED
BUDGET BUDGET
Aar
AMOUNT
1999 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Friend of the Court
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$6,176A03 00 96,220,321.00 $6,180,721.00
6,551,488.00 6,976,575.31 6,540,575.31
2,290,374.00 2,602,057.40 2,566,957.40 35,100.00 1.35%
-----------------------------------------------------
$15,018,265.00 $15,798,953.71 $15,288,553 71 $510,400.00 3.23%
$6,598,798.00 $6,641,233.00 $6,474,033.00 $167,200.00 2.52%
584,513.00 585,083.54 461,983.54 123,100 00 21.04%
1,447,997 00 1,860.553.62 1,515,853 62 344,700.00 18.53%
$8,631,308.00 $9,086,870.16 $8,451,870.16 $635.000.00 6.99%
912,775,201 00 912.861,554 00 $12,654,754.00 $206,800.00 1 61%
7,136,001.00 7,561,658 85 7,002,858.85 558,800.00 7.39%
3,738.371 00 4,462,611.02 4,082,811.02 379,800 00 0.00%
Salary and fringe fav. $39,600 due to turnover.
Fav attorney fees-mediator $245,000 due to reduced activity. Fay. transcripts, $60,000,
reflect reduced demand. Psychological testing fay. $25,000, and juror fees, $116,100
are due to reduced demand and are historically supported Fay. interpreter fees,
$10,000; and publishing court calendar $25,000 are a result of decreased demand.
Visiting judges unfav. ($54,400) due to increased use.
Information tech.-operations fay. $30,000 is due to the second quarter adjustment. Print
shop unfav. ($9,900) due to increased use. Telephone fay. $14,200 reflects the billing.
Salary and fringe fay. $172,000 due to turnover. Overtime fav. $9,700. On call overtime
unfav ($14,500).
Fav. indirect costs, $62,400 reflects salary fav. Fay. professional services, $35,700 due
to changes in billing practices. Postage fay. $25,000 reflects reduced demand.
Information tech imaging-operations fay. $263,500 and information tech -operations lay.
$37,600 due to reduced billing Print shop fay. $10.900 results from reduced usage.
Fay, leased vehicles. $9,000 and telephone communications, $23,700 result from
reduced billings.
923.649,573 00 $24,885,823 87 $23,740,423.87 $1,145,400 00 4 60%
08/17/99
District Court Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division I - Novi
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Non Controllable Operating
Division 4- Troy
Controllable Personnel
Controllable Operating
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
....
EXPLANATION OF SIGNIFICANT VARIANCES
Division 2 - Clarkston
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division 3 - Rochester Hills
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$110,881 00 $110,881.00 $30.981 00 $79,900 CIO 72 06% Fay due to reduced demand on pail time staff.
50,545 00 5054500 1954500 31,000.00 61.33% Fay court reporters $9,000. and visiting judges $22,000, due to reduced demand.
000 0.00 000 0.00
$161,428.00 $161,426.00 $50,526.00 $110,900.00 68.70%
$2,520,468.00 $2,528,183.00 $2469,383.00 $58,800.00 2.33% Salary and fringe lay. $74,700 due to turnover. Overtime unfav. ($15,900)
878,620.00 888,818.89 896,016.89 (7,200.00) -0.81% Bank charges unfav. ($9,200) reflect rate increase. Training psyc. & med. exam untav.
($25,200) reflects Increased usage and is offset by increased revenue. Fay. juror fees
$6,300 is historically supported. Rent lay $20.900 is also historically supported
401,637 00 477,951 68 456,251 68 21,700.00 4.54% Information technology-operations fay. $21,700 is a result of second quarter adjustment
$380072500 $3,894,951.57 $3,821,651.57 $73,300.00 1.88%
$936,463 00 $941,011 00 $927,011 00 $14,000.00 1.49% Salary and fringe fay. $10,700. Overtime fay. $3,300.
292,798.00 306,236 98 310,638.98 (4,400 00) -1.44% Attorney fees unfav. ($10,200) due to new schedule. Custodial services fay $5,400 is due
to reduced demand. Juror fees fay. $3,600; and training psyc. and medical exam fay.
$2,100 reflects decreased usage. Bank charges unfav. ($2,700) due to rate increase.
Postage unfav. ($2,600) due to increased use.
174,377.00 231,836 52 218,536 52 13,300.00 5.74% Information tech.-operations fay. $15,100 due to second quarter adjustment. Radio
communications unfav. ($1,800) due to installation of new equipment.
91,403,836.00 $1,479,084.50 $1,456,184.50 $22,900.00 1.55%
$2,164,863.00 $2,189,411.00 $2,197,211 DO ($7,800.00) -0 36% Unfav salary and overtime due to unplanned leaves of absence. Amendment requested.
631,164 00 651.164.00 645,164.00 6,000,00 0.92% Unfav, bank charges ($8.500) reflects rate increase. Fay. custodial services $19,000 due
to billing change. Attorney fees unfav. ($5,400) due to new schedule; Court reporters fay.
$4,000 and postage fay $10,000 reflect reduced usage. Interpreter fees unfav. ($4,000);
training psyc. & medical exam unfav. ($4,000), and professional services unfav ($4,300)
are due to increased demand for services.
373,809 00 417,702.99 379,402.99 38,300.00 9 17% Info. tech. - operations fay. $29,600 and telephone communications fay. $8,700 are due
to reduced billing.
$3,169,838.00 $3,258,277.99 $3,221,777.99 $38,500.00 1.12%
$1,558,902 00 $1,561,640.00 $1,544,340.00 $17,300.00 111,4 Fay salary and fringes $17,300 due to turnover and unfilled position.
307,753.00 307,812.20 306,412 20 1,400.00 0.45% Unfav, bank charges ($9,300) reflects rate increase. Fay. rent $7,100 is historically
supported. Fay. juror fees, $2,600; mileage, $7,500; and office supplies, $5,000 reflect
demand. Unfav, training, psyc. & medical exams ($9,000) and court reporters ($2,500)
due to increased usage.
265,548.00 320,479.71 300.779.71 19,700.013 8.15% Fay. stationary stores $4,000 reflects reduced usage. Fay information tech. - operations
_ ......... _____ ............ ..„...._ ...... .......... ................ __________ $6,000 reflects the second quarter amendment Telephone fay. $9,700 due to reduced
$2,132,203.00 $2,189,931 91 $2,151,531.91 $38,400.00 1.75% billing
$7,291,577 00 $7.331,126 00 $7,188,928 00 $162.200.00 2.21%
2,160,878 00 2.204.575 07 2,177,775 07 28,80000 1.22%
1,215,371.00 1,447,970.90 1,354,970.90 93,000.00 642%
910,867,826.00 $10,983,871 97 910,701,671.97 $282,000.00 2.57%
08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Judicial/Administration
ConlinRible Personnel $2,339,401.00 $2,341,941.00 $2,313,741.00 $28.200.00 1.20% Salary and fringe fay. $22,700 due to turnover. Overtime fay. $5,500
COntrollable Operating 66,118.00 68,066.76 64,366.76 3,700.00 5.44% Fey. visiting judges, $11,000; and postage, $3,500 due to reduced demand. Unfav. office
supplies, ($7,100) and computer research ($3,700) reflect increased usage
Non-Controllable Operating 552,331.00 808,245.99 790,145.99 18,100.00 2.24% information tech.-operations fav. $6,500 reflects budget adjustment. Telephone fay. $5,900,
and stationary stores fay. $8,800 reflect reduced billing. Equipment rental unfelt. ($3,100) is
due to billing Increases.
$2,957,850.00 $3,218,253.75 $3,168,253.75 $50,000.00 1.55%
Anrentle Maintenance
Controllable Personnel $0.00 $0.00 $0.00 0.00%
Controllable Operating 4,095,973.00 4,095,973.00 4,489,173.00 (393,200.00) -9.60% Fey, foster boarding homes, $11,900; and pre adoptive care, $13,000 are historically
supported. Fey. Sanctuary, $33,000 and wraparound services, $41,000 are new programs
Non-Controllable Operating 33.00 33.00 33.00 0.00% not yet fully employed. Private care residential fay. $29,300 and state institutions unfav.
($521,500) are both due to the amount of placements.
$4.096,006.00 $409600600 $4,489,206.00 ($393,200.00) -9.60%
Judicial Support
Controllable Personnel $4,563,908.00 $4.563,908.00 $4,414,408.00 1149,500 00 3.28% Fay, salary and fringe $151,500 due to turnover, Overtime unfav. ($2,000)
Controllable Operating 1,754,951.00 1,771,148.71 1,413,948.71 357,200.00 20.17% Fey, court reporters and transcripts, $17,300; witness fees, $12,700; and defense and
guardian fees, $307,100 reflect the demand. Fey, medical services, $33,300 Is historically
supported. Urdav, office supplies ($18,700) reflects an adjustment. Postage fey. $5,500.
Non-controllable Operating 799,704.00 949,444.21 948,744.21 700.00 0.07% Unfay. Intimation tech-openttions ($8,300); and telephone communications ($9,400)
reflect reduced billing Micrographs fay. $6,900 due to reduced use. Stationary stores fay.
$7,118,563 00 $7,284,500 92 $6,777,100.92 1507,40010 6.97% $11,500 reflects expenditure adjustments.
Court Services
Controllable Personnel $6,920,642 00 $6,920,642 00 $6,765,242.00 $155,400.00 2 25% Salary and fringe fey $155,400 due to turnover. Overtime fay. $5,700.
Controllable Operating 341,819.00 342,182.70 321,382.70 20,800.00 6.08% Fey. personal mileage, $13,000; student employment, $4,300; and training, $3,500 due to
reduced usage.
Non-Controllable Operating 399,79100 406,806.36 397,606.36 9,200.00 2.26% Telephone communications fay. $9,200 due to reduced billing.
$7,662,252.00 17,669631.06 $7,484,231.06 $185,400.00 242%
Department Total
Controllable Personnel $13,823,951.00 $13,826,491.00 $13,493,391.00 $333,100.00 2.41%
Controllable Operating 6,258,861 00 8.271,37117 6.288,871.17 (11,500.00) -0.18%
Non-Controllable Operating 1,751859.00 2,164,529.56 2,136,529.56 28,000.00 1.29%
$21,834,671.00 $22.268,391.73 121,918,791.73 $349,600.00 1.57%
1.11Z.
Administration
Controllable Personnel
Controllable Operating
$1,771,646.00 $1,771,646.00 $1,736,046.00
1,633.190.00 1,754,001.18 1,629.001.18
$5,971,043.00 $5,971,043.00 $5,810,143.00 $160,900.00 2.69%
$1,722,901.00 $1,722,901.00 $1,604,901.00 $118,000.00 6.85% Fay, due to underlined positions and turnover.
2,75800 3,124.90 3,124.90 0.00 0.00%
000 0.00 0.00 000%
$1,725,659.00 $1,726,025.90 $1,608,025.90 $118,000.00 6.84%
$1,479.827 00 $1,479,827 00 $1,329.827.00 $150,000.00 10.14% Fay due to underfilled positions and turnover.
6,885.00 6,88500 6,885 00 0.00 0 00%
0 00 0.00 0.00 0.00 0.00%
3.99%
8.51%
1.53%
4 16%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Non-Controllable Operating 1.792,416.00 2,287,710.56 2,252,710.56
$35,600.00 2.01% Fay due to underfilled positions.
125,000.00 7.13% Fay, Witness Fees, 20,000; Special Prosec. Att'y, 6,800; Filing Fees, 20,000; Court
Transcripts, 15,000, Extradition Expense, 10,000; Expert Witness, 5,000; and
and various other operating; partially offset by unfav Travel and Conference, ($15,000)
mainly due to changes in office operations; Maintenance Vehicles fay. $30,000 due
posting error. Amendment recommended to reverse error. Also, an amendment is
recommended to use $88,785 in operating favorability for a one-time purchase of
technical equipment.
35,000.00 1.53% Fay in Leased Vehicles, $15,000; Radio Communications, $10,000 and Copier,
$10,000. attributed to continuing operational changes and improvements.
$5.197,252.00 $5,813,357.74 $5,617,757.74 $195,600.00 3.36%
$130,900 00
30,000.00
0.00
Litigation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Warrants
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Appellate
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$5,914,551.00 $5,914,551 00 $5,783,651 00
56,492.00 56,492 00 26,492.00
0.00 0.00 0.00
2 21% lay, due to undorfilled positions.
0 00% Personal Mileage fay due to continuing operational changes and improvements
0.00%
$148671200 $1,486,712.00 $1,336,712.00 $150,000.00 1009%
Department
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$10,888,925 GO $10,888,925.00 $10,454,425.00
1,699,325.00 1,820.503 08 1,665.503.08
1,792,416.00 2,287,710.56 2,252,710.56
$14,380,666.00 $14,997,138.64 $14,372,638 64
$434,500.00
155,000.00
35,000.00
------
$624,500.00
08/17/99
Corrective Services
Controllable Personnel
Controllable Operating
Protective Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Technical Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
COUNTY OF OAKLAND
1999 THIRD QUARTER FORECAST
EXPENDITURES
SHERIFF DEPARTMENT
Sheriffs Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Administrative Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Non-Controllable Operating
Corrective Services-Satellites
Controllable Personnel
Controllable Operating
Non-Controllable Operating
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$725,718 00 $725,718.00 $720.718.00 $5,000.00
232,586.00 273,217.17 $304,217.17 (31,000.00)
1,330,039 00 1,369,137.00 61,369,137.00 0.00
$2,238,343.00 $2,368,072.17 52,394,072 17 (526.000.00) -1.10%
$1,035,021 00 $1,035,021.00 $1,015,021.00 $20,000.00 1.93%
469,730.00 496,752 86 $583,752 86 (87,000.00) -17 51%
394,039.00 394,462 00 $334.462.00 60,000.00 15.21%
$1,1598,790.00 $1,926,235.86 $1,933,235.86 ($7,000.00) -0.36%
$17,316,574.00 $17,553,217.00 $17,618,217 00 ($65,000.00) -0.37%
5,173,189 00 5,796,946.56 $4,596,946 56 1,200,000 00 20.70%
7,178,631.00 7,543,563.65 $7,843,563.65 (300,000.00) -3.98%
$29,668,394.00 $30,893,727.21 $30,058,727.21 $835,000.00 2.70%
$9,772,116.00 $9,808,070 00 $10,004,070.00 ($196,000 00) -2.00%
157,308.00 181,442 56 6146,942.56 34,500.00 19.01%
1,018,164.00 1,018,164.00 $1,018,164.00 0.00 0.00%
610,947,588.00 $11,007,676.56 $11,169,176.56 ($161,500.00) -1.47%
$1744757000 $18,146.348.00 618,071,348.00 $75,000.00 0.41%
152,555.00 724,750.56 $704,750.56 20,000.00 2.76%
1,776,190.00 1,854,310 00 $1,854,310.00 0.00 0.00%
$19,376,315 00 $20,725,408.56 $20,630,408.56 $95,000.00 0.46%
$6,824,764.00 66,859,028 00 $6,884,028.00 ($25,000.00) -0.36%
583,647.00 763,786.90 6790286.90 (26,500.00) -3.47%
975,256.00 975,595.36 5975.595 36 0.00 0 00%
$8.383.667.00 $8,598,410 26 $8,649,910 26 (651,500.00) -0.60%
$53,121,763.00 *54,127,40200 $54,313,402.00 ($186,000 00) -034%
6,769,01500 8,236,896.61 7,126,896 61 1,110,000 00 1348%
EXPLANATION OF SIGNIFICANT VARIANCES
-Fay salaries, fringes and overtime $20,000 due to staffing changes.
-Unfav. training exp ($7,000) due to extra training per deputy contract, office
supplies ($80,000) partially offset by fav. stationery stock, $60,000
-Fay. salaries $390,000 and fringes 645,000 due to turnover offset by unfav.
overtime ($500,000).
-Fay. laundry & cleaning 630,000 due to laundry being done by inmates, fay
hosp of inmates $900,000 due to fewer hospitalizations, dry goods $30,000,
out-county prisoner housing $600,000 due to decrease use of other facilities offset by
unfav, data processing supplies (130,000) due to new identification system, medical
med. supplies ($300,000) due to Health Dept. invoicing and expend. equip ($30,000).
-Unfav. provisions ($300,000) due to change from privatization.
-Fay. salaries $35,000 offset by unfav overtime ($200,000) and fringes ($31,000)
-Fav. laundry & cleaning $30,000 due to laundry being done by inmates, bedding
$4,500, dry goods 620,000. offset by unfav. equip repairs ($20,000).
-Fay salaries $350,000 and fringes $50,000 due to turnover offset by unfav.
overtime (6325,000) due to mini-contracts and no-fill postings.
-Fay, expendable equipment $8,000, equip repair $12.000
-Fay salaries $66,000 and fringes $4,000 offset by uhfav. overtime ($95,000)
-Fay prof services $20,000, microfilm 616,000. extradition $5.000, equip repair
$5,000. offset by unfav equip rental ($17,500), expend equip ($8,000). and
tab supplies ($45,000)
-Overtime overage primarily due to cover Royal Oak Township contract, as well as
the additional training need for the new officers
0.69% -Fay salaries & fringes $12,000 due to turnover offset by unfav. overtime ($7,000).
-11.35% -Unfav. transition costs ($19,000), communications ($2,000), and expendable
0.00% equipment ($10,000).
08117/99
Non-Controllable Operating 12,672,319 00 13,155,232 01 13,395,232 01 (240,000 00) -1 82%
$72,563,097.00 $75,519,530.62 $74,835,530.62 $684,000.00 0.91%
08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
County Clark
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Elections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Register of Deeds
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Jury Commission
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$362,252.00 $362252.00 $362,252.00 $0.00 0.00%
82,655.00 82,777.44 82,777.44 0.00 0.00%
106,950.00 137,917.02 137,917.02 0.00 0.00%
—
$551,857.00 $582,946.46 $582,946.46 $0.00 0.00%
$2,997,422.00 $2,997,422.00 $2,939,922.00 $57,500.00 1.92% Turnover partial/1r offset by Overtime costs.
266,477.00 378,881.07 378,881.07 0.00 0.00%
519,248.00 587,607.72 499,607.72 88,000.00 14.98% Fay. IT Imaging Operations due to decreased billings and Stationery Stock costs.
$3,783,147.00 $3,963,910.79 $3,818,410.79 $145,500.00 3.67%
$379,968.00 $380,620.00 $363,120.00 $17,500.00 4.60% Turnover
441,944.00 575,618.08 575,618.08 0.00 0.00%
79,368.00 144,216.00 144,216.00 0.00 0.00%
$901,280.00 $1,100,454.08 $1,082,954,08 $17,500.00 1.59%
$1,481,233.00 $1,616,233.00 $1,616,233.00 $0.00 0.00% Turnover offset by Overtime costs for increased document recording & mortgage refinancing.
859,119.00 859,119.00 802,819.00 56,300.00 6.55% Fay. Professional Services due to a delay in implementing the imaging program.
851,238.00 1,000,113.50 1,048,613.50 (48,500.00) -4.85% Unfav. Micrographics 8 Reproduction due to high real estate activity, partially offset by fav .
Stationery Stock. A budget amendment Is recommended.
$3,191,590.00 $3,475,465.50 $3,467,665.50 $7,800.00 0.22%
$14,454.00 $14,454.00 $14,454.00 $0.00 0 00%
52,363.00 52,363.00 33,363.00 19,000.00 36.29% Favorable Postage due to decreased mailing activity.
82,280.00 45,278.34 45,278.34 0.00 0.00%
$149,097.00 $112,095.34 $93,095.34 $19,000.00 16.95%
$5,235,329.00 $5,370,981.00 $5,295,981.00 $75,000.00
1,702,55800 1,948,758.59 1,873,458.59 75,300.00
1.639,084.00 1,915,132.58 1,875,632.58 39,500.00
$8,576,971.00 $9,234,872.17 $9,045,072.17 $189,800.00 2.06%
-
1.40%
3.86%
2.06%
Administration
Controllable Personnel
Controlable Operating
Non-Controllable Operating
Division Total
Department Total
$2,274,295.00 $2,274,295.00
236,573.00 307,007.05
394,943.00 616,953.13
$2.905,811.00 $3,198,255.18
$2,905,811.00 $3,198255.18
$2,215,295.00
$327,007.05
616,953.13
$3,159,255.18
;3,159,255.18
==.38 =1¢S=11.32,=!..?..
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
TREASURER
ADOPTED
BUDGET
AMOUNT
AMENDED FY 1999 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$59,000.00 2.59% Turnover
(20,000.00) -6.51% Unfav. Postage due to high volume of tax statement mailings. A budget amendment
is recommended.
0.00%
$39,000.00 1.22%
$39,000.00 1.22%
857,153.00 927,256.43 927,256.43 0.00 0.00%
$2,440,644.00 $2,518,074.77 $2,566,324.77 ($48,250.00) -1.92%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
BOARD OF COMMISSIONERS
ADOPTED AMENDED
BUDGET BUDGET
AMOUNT
FY 1999 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,510,957.00 $1,510,957.00 $1,510,957.00 $0.00
415,636.00 416,082.67 416,082.67 0.00
9,912,018.00 9,938,234.10 9,938234.10 0.00
0.00%
0.00%
0.00%
$11,838,611.00 $11,865,273.77 $11,865,273.77 $0.00 0.00%
$0.00 0.00%
Library Board
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$780,533.00 $787,765.00 $787,765.00
802,958.00 803,053.34 651,303.34 (48,250.00)
$2,291,490.00 $2,298,722.00 $2,298,722.00 $0.00
1,218,594.00 1,219,136.01 1,267,386.01 (48,250.00)
10,769,171.00 10,865,490.53 10,865,490.53 0.00
-6.01% Budget amendment is recommended for Library Continuations,
based on revised assessment documenting for the additional
funding to purchase necessary publications.
0.00%
-3.96%
0.00%
$14,279,255.00 $14,383,348.54 $14,431,598.54 ($48,250,00) -0.34%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER REVIEW REPORT
EXPENDITURES
DRAIN COMMISSIONER
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST RffifFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Drain Commissioner
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Division Total
Department Total
$5,639,993.00 $1,851,562 00 $1,902,250.00 (950,688 00) -2 74% (Intim due to Engineering a Construction deed labor charge. budget understated General Fund portion
418,011.00 372,163.00 148,851 00 223,332.00 60 01% Fey due to consukants, books 5 pubs not ordered, end lower personal mileage
586,120.00 879,583.53 658,347.00 21,236.53 3 12% Unfav due to increased maint. dept charges, computer secs , and drain equipment charges
$6,622,124.00 $2,903,328.53 $2,709,446.00 $193,880.53 6 68%
$6,622,124.00 $2,903,329.53 $2,709,448 00 $193,880.53 6 68%
Prepared by: Budget Division 08/17/99
ADOPTED
BUDGET
$1,319,702.00
193,221.00
337,245.00
AMENDED
BUDGET
$1,319,702.00
225,521.00
402,670.86
$1,850,168.00 $1,947,893.86
$891,914.00 $1,057,762.00
13,496.00 19,871.00
130,632.00 173,857.09
$1,036,042.00
$1,224,548.00
26,741.00
185,135.00
$1,436,424.00
$1,251,490.09
$1,149,548.00
32,940.60
221,858.44
$1,404,347.04
$3,436,164.00
233,458.00
653,012.00
$3,527,012.00
278,332.60
798,386.39
EXPLANATION OF SIGNIFICANT VARIANCES
Travel & Conference costs for trade mission (17,000), Professional Services to
support lobbying function (32,000), Membership & Dues for County Executives of
America Assn dues (10,800), and Office Supplies (5,000). A budget
amendment is recommended
Turnover
Unfav. Salaries (7,500). Second Ouarter Forecast amended the Salaries budget
in anticipation of delayed hiring of new personnel Positions were filled earlier
than expected causing variance. A budget amendment is recommended.
Unfav. Expendable Equipment Expense. A budget amendment Is recommended.
$4,322,634.00 $4,603,730.99 $4,595,930.99 $7,800.00 0.17%
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
COUNTY EXECUTIVE
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Auditing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Corporation Counsel
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
FY 1999
FORECAST
$1,319,702.00
290,321.00
402,670.86
$2,012,693.86
$972,762.00
19,871.00
173,857.09
---------
$1,166,490.09
$1,157,048.00
37,840.60
221,858.44
$1,416,747.04
$3,449,512.00
348,032.60
798,386.39
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT
$0.00 0.00%
(64,800.00) -28.73%
0.00 0.00%
--------
($64,800.00) -3.33%
$85,000.00 8.04%
0.00 0.00%
0.00 0.00%
------------
$85,000.00 6.79%
($7,500,00) -0.65%
(4,900.00) -14.88%
0.00 0.00%
($12,400.00) -0.88%
$77,500.00 2.20%
(69,700.00) -25.04%
0.00 0.00%
$641,628.00
26,295.00
$641,826.00
27,316.20
$640,826.00
27,916.20
185,802 00 152,323.48 154,223,46
$80000
(600.00)
(1,900.00)
• ----------
($1,700.00)
$146,000 00
$6,600 00
Fiscal Services
Controllable Personnel
Controllable Operating
$3,499,347.00 $3,499,347.00 $3,449,347.00
121,556 00 143,147.05 140,047.05
$50,000 00
3,100 00
Non-Controllable Operating 645,859 00 1,001,172.19 1,000,372.19 800 00
COUNTY OF OAKLAND
1999 THIRD QUARTER FORECAST
EXPENDITURES
MANAGEMENT AND BUDGET
ADOPTED
BUDGET
AMENDED 1999
BUDGET FORECAST
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$244,731.00 $244,731.00 $244,731.00
1460.00 7,480.00 6,830.00
9,086.00 9,086.00 9,586.00
$261,297.00 $261,297.00 $261,147.00
$000
650 00
(500.00) -5.50%
$150.00 0.06%
- Fay. Personal Mileage $150 and Data Processing Supplies $1,000 reflects lower than
anticipated usage; partially offset by unfav. h4em. Dues & Pub. ($350) and Postage ($150) due to
higher consumption.
- Unfav. Convenience Copier reflects greater usage
000%
8.69%
Purchasing
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$853,723.00 $821,285.66 $822,965.66
Equalization
Controllable Personnel $5,244.263.00 $3,131,294.00 $2,985,294.00
Controllable Operating 220,049.00 $552,091.00 545.491 00
Non-Controllable Operating
$8,492,424.00 $4,398.721.54 $4,245,521.54 $153,200.00
0.12% - Fay. Overtime $800.
-2.20% - Personnel Mileage $300 and Postage $2,000 and Data Processing Supplies $400 fay. being
offset by unfav. Expendable Equip. Exp. ($2,800) and Travel & Conference ($500) due to annual
system conferences.
-1.25% - Print Shop fay. $800 and Convenience Copier fay. $500 due to lesser demand.
Unfav. Telephone Comm. ($3,200) due to retroactive chg representing 15% increase for PBX
-0.21%
4 66% - Fay. Salary & Fringe $150,000 due to vacancies and underfilled positions; partially offset by
unfav. Overtime ($4,000) due to heavy workload.
1 20% - Fay. Printing $6,000, and Data Processing $1,000 Due to fewer requirements, offset by
unbudgeted Communications ($400).
0.08% - Fair Print Shop $2,000 reflects less than anticipated usage, countered by unfav. Leased Vehicles
($300) and unbudgeted Radio Communications ($100).
3.48%
1,028,112 00 $715,336.54 714.736 54 $50000
1.43% - Fait due lo turnover
2 17% - No outside rented equipment reflects Fay. Equip. Rental $600, Equip. Repairs & Maint fav. $400
do to replacement of aging equipment. Data Processing Supplies fav. $1,000 offset by
unbudgeted Software Rental/Lease Purchases ($400) Travel & Conference unfav. ($500) due to
HRFIS conferences. Memb., Dues & Pub fav. $2,000 due to fewer requirements.
0.08% - Decline in usage in Print Shop fav. $3,000 and Convenience Copier fay $1,000.
Unfav. Telephone Comm. ($3,200) due to retroactive chg. representing 15% increase for PBX.
$4,266,762 00 $4,643.666.24 $4.589,766.24
$2,731,887.00 $2,731,887.00 $2,731,887.00
371,813.00 381,191 65 369,195.65
Non-Controllable Operating 726,827.00 755,457.57 750,331 57
93,830,327 00 $3,868,538.22 $3,851,414.22
$53,900.00 1.16%
$000 000%
11,996 00 3 15% - Lower Bank Charges fay. $10,000. Fay. Indirect Costs $5,000 reflects reduced fringe rate.
Fay Personal Mileage $1,500, Printing $4,000 and Data Processing Supplies $700 reflects
decline in usage. Unfav Equipment Rental ($2,300) reflects rental of Image Receipting Camera
unbudgeted. Unfav. Filing Fees ($2.300) reflects more billings offset in revenue.
Unfav. unbudgeted Ad) Prior Year Exp. ($3,100), Refund Prior Year Rev ($734). and Reimb.
of Cash Shortage ($770) reflect FY 1998 corrections.
5,126.00 0.68% - Return of car used by Service Officer to Leased Vehicles.
$17,122.00 0.44%
Reimbursement
Controllable Personnel
Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$12,361,854.00 $10,248,8135.00 $10.052,085 00
747,193.00 1,111,225.90 1.089,479.90
2,595,486.00 2,633,375.76 2,629,249 78
915,704,533.00 913,993,486.66 913,770,614.66
$19680000 192%
$21,746.00 1.96%
$4,128.00 0.16%
$222,672.00 1 59%
nfl
08/17/99
0 00%
76 03%
-17.42%
3 74%
$1,500,166.00 $1,575,168.75 $1,550,468.75
$1,022,541.00 $1,022,541.00 $955,841.00
29,205.00 70,085,54 62,085.54
603,460.00 645,805.05 689,705.05
Support Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$66,700.00
0.00
(42,000.00)
7.57% Fay. due to vacant position and underfilled position.
0.00%
-6.62% Unfav. in Micrographics due to high activity of information transfer in Record Retention
Amendment recommended to cover unfav.
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$24,700.00 1.57%
$66,700.00
8,000.00
(43,900.00)
6.52%
11.41%
-6.80%
$880,707.00
26,663.00
592,776.00
$880,707.00
59,563.54
634,898.21
$814,007.00
59,563.54
676,898.21
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administrative
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$141,83400 $141,83400 $14183400 $000
2,522.00 10,522.00 2,522.00 8,000.00
10,684.00 10,906.84 12,806.84 (1,900.00)
$155,040 00 $163,262,84 $157,162.84 $6,100.00
Fey due to prior year encumbrance not released
Unfav Leased Vehicle due to underestimate of funding needed for vehicle assigned to
Exec Offices. Amendment recommended for both variances.
$1,655,206.00 $1,738,431.59 $1,707,631.59
nfl =====Z=.... $30,800.00 1.77%
Facilities Engineering
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$832,555.00
126,327.00
151,082,00
$1,109,964.00
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
FACILITIES MANAGEMENT
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
nn•••n•••n•n••
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$988,436.00 $576,307.00 $49403400 $82,273.00
315,902.00 124,297.00 116,669.00 7,628.00
345,781.00 130,754.00 131,797.00 (1,043.00)
14.28% Salaries &Fringes are favorable due to vacancies in Tech. Supt & Admin staff
6.14% Overall Cont ()per is fay. largely due to adjustment of prior years expenditures
-0.80% Non-Control (Ver is unfav largely due to higher Print Shop, possible mischarged
$1,650,119.00 $831,358,00 $742,500.00 $88,858.00 10.69%
$832,555 00 $762,527.00 $70,028.00 8.41% Salaries 8 Fringes are favorable due to position turnover. & vacancies
146,416.36 147,775.00 (1,358.64) -0.93% Unfav largely due to travel 8 cool office supplies, training IS dues
180,930.20 184,189.00 (3,258.80) -202% Non-Control °per is unfav largely due to Info-Tech oper . Maint Dept. 8 Stationery Stock
$1,139,901.56 $1,074,491.00 $65,410.56 5.74%
Deportment Total
Controllable Personnel
Controllable Operating
Non-Controllable Operaling
$162099100 $140886200
442,229.00 270,713.36
496,863.00 291,684.20
$2,760,083.00 $1,971,259.56
$1,256,561.00 $152,301.00 1081%
264,444 00 6,26935 2.32%
295,986.00 (4,301.80) -1.47%
$1,816,991.00 $154,268.56 7.83%
• Nine Month Budget 08/17/99
Administration
Controllable Personnel
Controllable Operating
$252,109.00 $252,109.00 $252,109.00
4,025.00 4,02500 6,325.00
0.00%
($2,300.00) -0.84%
Human Resources
Controllable Personnel
Controllable Operating
$1,709,147.00 $1,712,655.00 $1,682,655.00
350,887.00 353,610.25 345,710.25
Non-Controllable 507,206.00 712,965 64 712,965.64
$30,000.00
7,900.00
1.75% -
2.23% -
- Overtime unfav. ($8,000) due to heavy workload.
- Fav. Court Reporter Svs. $1.000. Fees/per Diems $1,000, Data
Processing Sup. $500, and Postage $500 reflects slightly lower usage
than normal. Unfav. Travel & Conference ($200) due to two Peoplesoft
conferences being held in same fiscal year.
- Convenience Copier fav. $1,000 due to fewer copies made. 1,000 00 0.87%
($4,200.00) -0.44%
$22,000.00
8,400.00
1,000.00
--------
$31,400.00
($8,000.00)
2,800.00
-1.27%
1.33%
0.85%
1.47%
0.12%
0.78%
COUNTY OF OAKLAND
1999 THIRD QUARTER FORECAST
EXPENDITURES
PERSONNEL
ADOPTED
BUDGET
AMOUNT
AMENDED 1999 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
••••nn••••••••nnnn••
0.00%
(2,300.00) -57.14% - Unfav. Travel & Conference ($2,500) due to two annual Peoplesoft
conferences being held in same fiscal year. Money is budgeted in
the Fringe Benefit fund. A budget amendment is recommended.
Unbudgeted Postage unfav. ($500) partially offset by fay. Data.
Processing Supplies $400, Personal Mileage $100 and
Communications $200 due to lower usage.
Non-Conrollable Operating 6,359.00 16,063.09 16,063.09
$262,493.00 $272,197.09 $274,497.09
0.00 0.00%
Favorable turnover
Fay. Equip. Repair & Maint. $2,000, Exam Material $5,000
Employee Med. Exams. $4,000, Printing $2,000 and Postage $5,000
reflects decrease in demand; partially offset by unfav. Recruitment
Expense ($5,000) due to advertising efforts to attract personnel in a low
unemployment environment. Unfav. Travel & Conference ($2,000) due
to two Peoplesoft conferences being held in same fiscal year,
Office Supplies unfav. ($1,600) reflects usage of high speed printer
to print bi-weekly reports that previously was done by Info-Tech.
Unfav. Expendable Equipment Expense ($1,500) due to higher than
anticipated furniture purchases.
$37,900.00 1.36% $2,567,240.00 $2,779,230.89 $2,741,330.89
$618,341.00 $627,776.00 $635,776.00
183,480.00 213,759.10 210,959.10
Non-Controllable Operating 115,092.00 115,092.00 114,092.00
$916,913.00 $956,627.10 $960,827.10
Department Total
Controllable Personnel $2,579,597.00 $2,592,540.00 $2,570,540.00
Controllable Operating 538,392.00 571,394.35 562,994.35
Non-Controllable Operating 628,657.00 844,120.73 643,120.73
$3,746,646.00 $4,008,055.08 $3,976,655.08
Employee Relations
Controllable Personnel
Controllable Operating
08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
HUMAN SERVICES
Administration
Controlled, Personnel
AMOUNT
ADOPTED AMENDED FY 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$148.277.00 8148,277.00 8148277 00 $0.00 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Controlled, Operating 9,278,945.00 9,304.945.00 9,034,845.00 270,100 00 2 90% Use of Travel and Conference and Personal Mileage lower than anticipated $5,300:
Independent Living fav. 198,400, Private Institutions fav. $100,000, Foster Boarding Homes
fay. $18,800, Foster Care (HA) lay. $32,400 and Dry Goods and Clothing fey. 811,100.
Recent history, as well as current usage reflects actual usage to be lower than budgeted.
These accounts have been adjusted for the FY 2000 and FY 2001 Executive
Recommendation.
Non-CoritroNable Operating
Health
Controllable Personnel
7.272.00 7,272.00 7,772.00 (500.00) -6.88% Printing material for recent implementation of Human Service Coordinating Council unit higher
than budgeted. Cost was not originally induded in the budget.
$9,434,494.00 $9,480.494.00 *9,190,894.00 8289,600 00 285%
$2020263600 920,435,259.00 $19,993,559.00 $441,700 00 2.16% Fey. 1545,800 due to turnover; Offset by unfav. Overtime $(103,900) due to continued high
activity in Jail Health, with greater turnover of staff; Central Support unit reflects high usage
of Overtime due to large volume of data entry done for the new well code system. Also, the
Sanitarian position for Southfield was not filled until the second quarter. The revenue was
incorrectly posted as Salaries Reimbursement. A budget amendment is recommended to
make the correction, redudng Salaries, Fringe Benefits and Reimbursement Contracts under
revenues.
Controllable Operating 3.863,067.00 6,075.055.38 5.625,455.38 249,600.00 4.11% Professional Services fair. $179,000 primarily due to lenthy (1 to 2 months) 'lime frame Involved
between the billing process and making the actual payment. Invoice is not issued until the
services are completed, which In some cases has taken several months. Also with the
anticipated dosing of the Breast & Cervical Cancer Screening Program, and the continued
decrease in TB cases, supplies are fay. $60,400.
Non-Controllable Operating 2,305,342.00 2,821,530.36 2,851,430.38 170,200.00 8.03% Health Division Building Space Cost was adjusted due to grant being incorrectly charged to
Health Fund instead of the grant fund $99,400; Equipment Rental charges are less than
anticipated $10.900, Stationery Stock fay. $51,400 due to purchases through Office Supplies
(Office Supplies unfav. $38,900); Telephone billing less than anticipated $8,900.
$2837104500 $29,331,944.74 826,470,444.74 $861,500.00 2.94%
Chfidren's Maim
Contrdlable Personnel $8,348.827.00 98.359.364.00 $8,008.964.00 8350,400.00 4 19% Salaries and Fringe Benefits fay. 8455,500, while Overtime unlav ($105,400) due to high
turnover of staff, particularly for secured buildings.
Controllable Operating 2,666,847.00 2,857,498.50 2,605,998.50 51,500.00 1.94% Fay. $145,500 for Teachers Services & Expense for Children's Village School due to
greater efficiencies; offset by unfav. Drugs ($13,000) due to substantial increase in number
of juveniles requiring psychiatric care; Laundry and Cleaning urtfav. $(47,600) due to change
in policy to increase the numbers of days laundry is done; Dry Goods and Clothing unfav.
$(12,900), Provisions unfav. $(14,000) due to Increase in number of juveniles in need of clothes
end other various items when brought to the facility; Office Supplies unfav. $(10,700) as more
purchases are made through Office Supplies than Stationery Stock. There is an offset of fey .
In Stationery Stock.
Non-Controllable Operating 1,833,248.00 2,045.838.13 1,980,738,13 65,100.00 3.29% information Technology Operations is projected to be fair. $150,000 as cost operating costs
for new computers less than anticipated; offset by unfav. Materials Management Provisions
$(33,800), Toilet Articles $(12,300), arid Culinary $(11,800) due to increase in usage Also,
812.848,922.00 $13,062.700.63 $12,595,700,83 8467,000.00 3 58% Radio Communications unfav. (819,500) as FY 1998 project to purchase and install security
cameras in the Children's Village buildings was not Implemented until the beginning of
FY 1999 No funds were carried forward to cover project.
08/17/99
McNeal Examiner
Controllable Personnel $1,750,097.00 $1,750,097.00 51,738.097.00 512,000.00 0.69% Due to delay in hire of Forensic Pathologist and Typist I position approved in FY 1999 Budget,
Salaries and Fringe Benefits fay. $31,400, whie Overtime unfav. ($19,400).
Controllable Operating 381,738.00 396,739.00 457,838 00 (61,100.00) -15 40% Contracted assistance for Medical Services - Autopsies continued to be high during the first
four (4) months of FY 1999. The need for these services has tamed off and is expected to
remain lower the duration of this fiscal period. Professional Services is also unfav. $(20,200)
due to the increase in workload.
Non-Cordrollable Operating 591,093.00 667,481 77 715,081.77 (47,600.00) -7.13% Information Technology Operations is projected to be unfav. $(39,400) base on the increase
In operation costs for the new computers; Also, Leased Vehicles unfav. $(7,200) due to
increased usage.
$2,722,928.00 $2,814,316.77 $2,911,016.77 ($96,700.00) -3.44%
Department Total
Contra/Able Personnel 530,449,837.00 530,692,997.00 529.888,897.00 5804,100.00 262%
Controllable Operating 16,190,597.00 18,434,238.88 17,924,138.88 510,100.00 2.77%
Non-Controllable Operating 4,736,955 00 5,542,222.26 5,355,022.26 187,200.00 3.38%
$51,377,389.00 $54,669,456.14 $53,168,056.14 51,501,40000 2 75%
IIC=231.1Cat WWWWWWW .....-==L7SWit,-MMLI,
08/17/99
$1,164,911.00 $1,164,911.00 $1,124,911.00 $40,000.00 3.43% - Turnover
303,442.00 308,134.51 253,034.51 55,100.00 17 88% - Fay. Equip. Repair & Maint. $300, Fees & Mileage $200, Mem. Dues & Pub. $400 and Misc. $400
due to decreased need. Soldier Burial fay. $50,000 partially due to eligibility requirements
Transport Service fay. $200, Travel & Conference $1,300, Data Pros. Sup. $1,000 and Postage
$2,500 reflect fewer demands on resources, partially offset by unfav unbudgeted Advertising
($400) and Office Supplies ($800) due to ordering folders for new filing system.
221,819 00 240,649.45 235,649.45 5,000.00 2.08% - Fay. Leased Vehicles $4.000 and Print Shop $1,000 due to reduced need.
$1,690,172.00 $1,713,694.96 $1,613,594.96 $100,100.00 5.84%
COUNTY OF OAKLAND
1999 THIRD QUARTER FORECAST
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Controllable Personnel $129,653 00 $129,653.00 $129,653.00 0.00%
Controllable Operating 1,743.00 1,743.00 5,743.00 (4,000.00) -229.49% - Unfav. Communications ($600) due to charges higher than anticipated. Unfav. Membership, Dues
and Pub. ($400): Service Momentos ($1,800) and Soldier Burial ($300) due to unbudgeted line
items and items purchased to enhance new Troy office. Travel & Conference and Workshops &
Meetings unfav. ($1,300) is the result of unscheduled conferences. Fay. Office Supplies $500
partially offset by unfav. Postage ($100) due to higher usage.
A budget amendment is recommended.
Non-Controllable Operating 11,117.00 11,117.00 13,917.00 (2,800.00) -25.19% - Unfav. Leased Vehicles ($200) and Print Shop ($2,600) due to greater demand on resources.
$142,513.00 $142,513.00 $149,313.00 ($6,800.00) -4.77%
Veterans Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Community Corrections
Controllable Personnel
Controllable Operating
Non-Controllable Operating
MSLI Ext. - Oakland County
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1,302,470.00 $1,516,474.57 $1,346,074.57 $170,400.00
$1,152,153.00 $1,274,375.00 $1,135,175.00 $139,200.00
74,833 00 116,515 57 76,315 57
75,484.00 125,584.00 134,584.00 (9,000.00)
40,200.00
10.92% - Salary & Fringe fay. $150,000 due to delay in tilling new positions, partially offset by unfav.
Overtime ($10,800) due to rapid expansion of Alternative Programs.
34.50% - Grant Match fay. $48,000; partially offset by unfav. Mem. Dues & Pub. ($500), Travel & Conference
($1,500) Material & Supply ($5,900), Office Supplies ($3,000) and Postage ($600) due to additional
program demands. Fay. Tmg. & Phschofog. & Med. Exam. $3,700 represents delayed testing
-7.17% Unfav. unbudgeted Radio Communications ($3,000). Leased Vehicles ($5,000) as no money was
added to budget when extra van was authorized. Unfav. ($1,000) in Convenience Copier reflects
11.24% higher than anticipated usage connected with expanding programs.
651,604.00 655,991.00 640,991.00 15,000.00 2.29% - Fay. Salaries & Fringes due to turnover $20,000, partially offset by unfav. Overtime ($5,000).
338,638.00 348,906.85 337,006.85 11,900.00 3.41% - Fay. Personal Mileage $12,000 and Professional Services $35,000 partially due to charges made
in unbudgeted line items to reflect spending pattern: Unfav. Car Allowance ($12,000), Field Trips
($3,600), Workshops & Meetings ($18,800) and Groceries ($700).
208,435.00 252,963.55 254,663.55 (1,700,00) -0.67% Higher usage reflects unfav. Leased Vehicles.
$1,198,677.00 $1,257,861.40 $1,232,661.40 $25,200.00 2.00%
08/17/99
Circuit Court Probation
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
COUNTY OF OAKLAND
1999 THIRD QUARTER FORECAST
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE} PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Animal Control
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$1.227,214.00 $1,227,214.00 $1,229,214.00 ($2,000 00) -0.16% - Heavier workload reflected in unfav. Overtime.
107,089.00 107,490.00 105,490.00 2,000.00 1.86% - Fay. Damage by Dogs $1,000, Hem. Dues & Pub. $200 Personal Mileage $400, Travel &
Conference $500, Uniform Replacement $500, Data Pros. Supplies $1,000, Deputy Supplies
$500 and Medical Supplies 82,000 reflects lesser needs in these areas; partially offset by unfav.
Equipment Repairs & Maint ($2,000) due to cash register being reprogrammed to accept HRFIS
accounts.
480,897.00 492,282.31 491,282.31 1,000.00 0.20% Fay. Print Shop $600 and Convenience Copier $500 results in fewer requirements.
$1,815,200.00 $1,826,986.90 $1,825,986.31 $1,000.00 0.05%
$0.00 $0.00 $0.00 0.00%
31,055.00 108,425.00 93,425.00 15,000.00 0.00% - Fav. Data Processing Supplies $5,000 and Office Supplies/Stationary Stock $10,000 due to
lower volume.
839,085.00 846 ,585 .85 839,585.85 7,000.00 0.83% Lower usage in Convenience Copier.
$870,140.00 $955,010.85 $933,010.85 $22,000,00 2.30%
$4,325,535.00 $4,452,144.00 $4,259,944.00 $192,200.00 4.32%
856,800.00 991,214.93 871,014.93 120,200.00 12.13%
1,836,837.00 1,969,182.16 1,969,682.16 (500.00) -0,03%
$7,019,172,00 $7,412,541.09 $7,100,641.09 $311,900.00 4.21%
08/17/99
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
INFORMATION TECHNOLOGY
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology
Controllable Personnel
Controllable Operating Expenses
Non-Controllable Operating Expenses
Division Total
SO $354,265.00 $349,939.37
155,808.00 213,239.42 113,773.47
4,851,000.00 8,327,636.92 8,295,262.80
$5,006.808.00 $8,895,141.34 58,758,975.64
4,325.63 1.22% - Turnover
99,465.95 46.65% - Delay in Professional Services use in DISC
32,374.12 0.39%
$136,165 70 1.53%
Department Total $500680800 $8,895,141.34 $8,758,975.64 $136,165 70 1.53%
08117/99
Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$142,402.00
88,779.00
43,521.00
$274.702.00
$19565300
144,702 00
68,285.46
$195,653.00
144,702.00
68,285 46
$408,640.46 $408,640 46
0.00%
0.00%
0.00%
$0.00 0.00%
0.00%
0.00%
0.00%
0 00%
Equalization
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Community Development
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
L..
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
EXPENDITURES
COMMUNITY AND ECONOMIC DEVELOPMENT
AMOUNT
ADOPTED AMENDED 1999 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
— — —
Planning and Economic Development
Controllable Personnel
Controllable Operating
Non-Controllable Operating
12,283.494.00
647,752.00
545,412.00
----------
$3,476,658.00
$2,284,609.00 $2.284,609 00
673,622.71 673,622.71
713,691.09 713,691.09
$387192280 $3,671,922.80 $0.00
$0.00 $2,218.085.00 2,218,085.00
000 375,957.00 375,957.00
0.00 1,024,911.17 1,024,911.17
$0.00 $3,618,953.17 $3,618,953 17 $0.00
270,928.00 304,453.00 299,025.00 5,428.00 1.78% Actual match required less than expected
$270,928.00 $304,453.00 $299,025.00 $5,428.00 1 78%
$2,425,896.00 $4,698,347.00 $4,698,347.00 $0 00 0 00%
1,007,459 00 1.498,734.71 1,493,306 71 5,428.00 0 36%
588,933.00 1,806,887 72 1,806,887 72 0.00 0.00%
$4,022,288.00 $8,003,969.43 $7,998,541 43 $5,428.00 0.07%
08/17199
fAV'i 14; ;
COUNTY OF OAKLAND
• FT.1999 THIRD QUARTER REPORT;
:EXPENDITURES
..1.f).
r ,IVS: 4.?"""! - •
„. zaAb
INON-DEPART. APPROPRIATIONS
COUNTY OPERATIONS
Financial System
Stale Institutions
Ambulance
Insurance and Surety Bonds
Tax Tribunal Appeals
Road Commission - Drain Assessment
Road Commission - Tri-Party Agreement
Remonumentation
MANAAIAN
Grant Match
COUNTY BUILDINGS
COUNTY ASSOCtATIONS
S.E.M.C.O.G.
Association of Metro Sewage Groups
Area Wide Water Quality
National Assoc. of Counties
Michigan Assoc. of Counties
Traffic Improvement Association
SUNDRY
BUDGET BUDGET
AS AS FY 1999
ADOPTED ADJUSTED FORECAST
$000 $498,860.00 $49886000
635,300.00 635,300.00 535,300.00
19,800 00 19,800.00 14,800.00
85,100 00 85,100.00 85,100.00
702,900.00 702,900 00 50,300 00
1,116,300.00 1,116,300.00 1,216,300.00
1,250,000 00 1,250,000.00 1,330,133.00
0.00 1,129,755.55 1,129,755.55
0.00 0.00 0.00
0.00 6,844,384.00 6,844,384 00
$3,809,400 00 $12,282,399.55 $11.704,932.55
93,115,587.00 $2,735,749.62 $2,735,749.82
$415,000.00 $415,000.00 $420,300 00
0.00 0.00 1,500.00
57,200.00 57,200.00 52,200.00
19,000.00 19.000.00 19.100.00
50,000.00 50,000.00 50,000.00
22,300.00 22,300.00 22,300.00
$563,500.00 $563,500.00 $565,400.00
$674,300.00 $1,367,305.00 $1,367,305 00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
$0.00
100,000.00
5,000 00
0 00
652,600.00
(100,000 00)
(80,133 00)
000
000
0.00
$577,467 00 4.70%
$0.00 0.00%
($5,300.00)
(1,500.00)
5,000.00
(100.00)
0.00
0.00
($1.900.00) -0.34%
$0.00 0.00%
-1.28% Actual dues.
-100 00% Actual dues.
8 74% Actual dues.
-0.53% Actual dues.
0.00%
0.00%
0.00%
1574% Reduced use of state facilities for County wards, ordered into custody by the Circuit Court
25.25% Reduced usage
000%
9284% Line item no longer used (Expenditure reflects amendment approved in July)
-8.96% Increased road work requiring additional work on easements
-6.41% Final payment for FY 1998 charged to FY 1999 due to timing difficulty.
0.00%
0.00%
0 00°/.
RESERVED FOR TRANSFERS
Expenditures
Contingency
Infrastructure Improvements
Salary Adjustment
Classification & Rate Change
Overtime
Summer Employment
Emergency Salaries
Fringe Benefit Adjustments
Capital Outlay
Clinton River Watershed Council
Huron River Watershed Council
Partnership for Saginaw River Watershed
Rouge River Watershed Council
Office Automation
$234,983.00 $72,143.00 $92,143.00 (20,000.00)
0.00 3,000,000.00 3,000,000 00 0.00
000 0.00 000 0.00
84,627.00 (26,920.00) 0.00 (26,920.00)
53,000.00 20,780.00 20,780 00 0.00
424,200.00 424,200.00 545,200.00 (121,000 00)
636,300.00 790,000.00 790,000.00 0.00
0.00 0.00 000 0.00
75,000.00 26,816.75 26,616.75 0.00
5,141.00 5,141.00 5.141.00 0.00
2,70600 2,706.00 2,706.00 0.00
2,276.00 2,276.00 2,276.00 0.00
2,177.00 2,177.00 2,177.00 0.00
1,200,000.00 353,895.00 438,432.00 (84,537.00)
-27.72% Anticipated items in the last quarter of FY 1999.
0 00%
0.00%
100 00% Increased number of successful classification reviews
0.00%
-28.52% Increased demand due to tight labor market for full time staff
0.00% Increased demand due to light labor market for full time staff
0.00%
0.00%
0 00%
0.00%
0.00%
0.00%
-23.89% Demand higher than anticipated in budget.
$2,720,410 00 $4,673,014.75 $4,925,471.75 ($252,457.00) -5.40%
1 08/11/99 Prepared by: Budget Division
$0.00
000
0 00
000
0 00
0.00%
0.00%
0.00%
0.00%
0.00%
Transfers to Other Funds
General Activities
Environmental Infrastructure
Building Fund
Building Authority
TOTAL NON-DEPT. APPROPRIATIONS
BUDGET
AS
ADOPTED
$0.00
5,000,000.00
3,242,911.00
3,490,661 00
BUDGET
AS
ADJUSTED
$4,282,400.00
5,000,000.00
4,789,272.00
1,944,300.00
FY 1999
FORECAST
$4,282,400 00
5,000,000 00
4,789,272 00
1,864,610.00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION
$000
000
000
79,690.00
0.00%
0.00%
0.00%
4.10%
$11,733,572.00 $16,015,972.00 $15,936,282 00 $79,690.00 0.50%
$22,616,749.00 $37,637,940.92 $37,235,140.92 $402,800.00 1.07%
TRANSFER TO GENERAL PURPOSE FUNDS
Friend of the Court Fund $9,852,993 00 $10,247,274.34
Health Fund 23,364,748.00 22,854,944.29
Juvenile Maintenance Fund 14,036,647.00 13,558,784 49
Social Welfare Fund 67,378.00 87,378.00
CRIMP Fund 0.00 0.00
$47,321,766 00 $46,728,381.12 $46,728,381.12
$10,247,274.34
22,854,944.29
13,558,784.49
67,378.00
0 00
$0.00 0.00%
2 08/11/99 Prepared by: Budget Division
FY 1999 BUDGET AMENDMENTS
General Fund
General Purpose
FY 1999 BUDGET AS ADOPTED $293,711,502.00
BUDGET AMENDMENTS
M.R. #98233 - 10/15198 $77,477.00
Sheriff Department - Law Enforcement Contract
Amendment for Highland Township
M.R. #98242 - 10/15/98 552,500.00
Information Technology - Enhancement of County's
Assessing, Equalization and Tax Billing and
Collection System
M.R. #98258 - 10/29/98
Sheriff Department - Law Enforcement Contract
Amendment for Addison Township
M.R. #98258 = 10/29/98
Central Services - Temporary Fleet Expansion
for Community Corrections
M.R. #98271 .11/19/98
Health Division - Partnership Agreement with
the City of Southfield
M.R. #98281 - 11/19/98
Circuit Court - Local Law Enforcement Block Grant
Match
83,526.00
9,000.00
73,843.00
17,674.00
M.R. #98282 - 12/10/98 114,179.00
Circuit Court - Use of Mediation Funds
M.R. #98295 - 12/10/98 60,214.00
Sheriff Department - Law Enforcement Contract
Amendment for Oakland Township
68,110.00 M.R. #98296 = 12/10/98
Sheriff Department - Law Enforcement Contract
Amendment for Springfield Township
M.R. #98325 - 12/10/98
Sheriff Department - Law Enforcement Contract
Amendment for Commerce Township
M.R. #98294 - 12/10/98
Sheriff Department - Contract for Court Security at
the 48 th District Court - Bloomfield Township
M.R. #98289 - 12/10/98
Drain Commissioner - Implementation of Labor
Distribution System, Miscellaneous Accounting
Policy Changes and Organizational Changes
48,611.00
13,923.00
($3,788,431.00)
M.R. #98313 - 12/10/98 $100,000.00
Clerk/Register of Deeds - Remonumentation Grant
MA. #98315 - 12110/98 $7,232.00
Library Board - LBPH - Creation of One GF/GP
Clerk I Position and the Deletion of Two PTNE
General Clerical Positions
M.R. #98328 - 12/10/98 $11,706,764.05
Management and Budget - FY 1998 Year End
Report and Budget Amendments
M.R. #98339 - 12/10/98 $233,807.00
Personnel Actions Related to the Transition of
Community Mental Health to an Authority
M.R. #99005 - 1/25/99 $350,000.00
Medical Examiner - Case Management System
M.R. #99043 - 2/25/99 $89,195.00
Sheriff - FY 1998 State Criminal Alien Assistance
Grant Acceptance
MA. #99031 - 2/25/99 $126,505.00
Community Corrections - Program Expansion
M.R. #99042 - 3/18/99 $2,700.00
Sheriff Department - Processing Fee Increase
M.R. #99049 - 3/18/99 $28,000.00
Prosecutors Office - Fleet Expansion
MA. #99050 - 3/18/99 $1,494,259.00
Health Division - Acceptance of FY 1998/1999
CPBC Contract
M.R. #99056 - 3/18199
Equalization Division - Digital Photography Project
M.R. #99060 - 3/18/99
Management and Budget - FY 1999 First Quarter
Financial Forecast and Budget Amendments
M.R. #99057 - 4115199
Management and Budget/ Equalization -
Reorganization
MA. #99065 - 4115199
Sheriff Department - Law Enforcement Contract
Amendment for Orion Township
MA. #99066 - 4/15/99
Sheriff Department - Law Enforcement Contract
Amendment for Oakland Township
M.R. #99068 -4115199
Sheriff Department - Use of DARE Vehicle
$97,794.00
$3,826,200.00
$22,521.00
$36,898.00
$48,693.00
$4,000.00
M.R. #99070 - 4/29/99 $78,597.00
Circuit Court - Use of Mediation Funds
M.R. #99071 -4/29/99 $165,088.00
Sheriff Department - Use of Forfeited Funds
M.R. #99105 - 4/29/99 $20,000.00
52-3 District Court - Additional Lease Space
M.R #99114 - 6127/99 $197,332.00
Sheriffs Department - Use of Forfeited Funds for
K-9 Program
M.R. #99133 - 5/27/99 $339,874.00
Sheriff Department - Law Enforcement Contract
for Royal Oak Township
M.R. #99123 - 5/27/99 $693,005.00
Information Technology - Appropriation for
Unfunded Mandates
M.R. #99130 - 6/10/99 $3,000,000.00
I-75/M-59 Technology Park Improvements
M.R. #99140 - 6/10/99 $232,000.00
Information Technology - MAN/WAN
M.R. #99136 - 6/10199 $77,519.00
Management and Budget - Equalization - Commerce
Township Contract
$7,288,263.00 M.R. #99141 - 6/10/99
Management and Budget - FY 1999 Second Quarter
Financial Forecast
Total Amendments $27,596,872.05
Amended Budget 6/30/99 $321.31111.17A-05
Prepared by: Fiscal Services Division 08/09/99
$125,100.00
400,986,00
$526,086.00
$526,086.00
$125,100.00
400,986,00
$526,086.00
$526.086.00
COUNTY OF OAKLAND
FY 1999 THIRD QUARTER FORECAST
INTERNAL SERVICE FUNDS
DEPARTMENT OF CLERK/REGISTER OF DEEDS
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV) EXPLANATION OF SIGNIFICANT VARIANCES
[MICROGRAPHICS FUND (#654)
REVENUES
Outside
Inside
Total Revenues
OPERATING EXPENSES
267,300.00 $142,200.00 Title company orders reflect the high real estate activity.
513,786,00 112,800.00 Fav. due to increase in internal department demand.
$781,086.00 $255,000.00
$526.086.00 $0,00
REVENUE OVER (UNDER)
EXPENDITURES $0.00 $0.00 $255,000,00 $255,000.00
08/13/99
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
DEPARTMENT OF DRAIN COMMISSIONER
INTERNAL. SERVICE FUNDS
1999 THIRD QUARTER REVIEW REPORT
ADOPTED AMENDED 1999 VARIANCE
BUDGET BUDGET THIRD OTR, REV. FAV/(UNFAV)
11-3RAIN EQUIPMENT FUNDAB839)
COMMENTS
OPERATING EXPENSES
$2,058,161.00 $1,958,140.00 $2,070,375.00 $112,235.00 Favorable due largely to increase in vehicle rental revenue.
86.898.00 86,898.00 86.898.00 0.00
$2.145,059.00 $2.045,038.00 $2,157,273.00 $112,235.00
$2,538.232.00 $2,438,211.00 $2.120,005.00 $318,206.00 Favorable due largely to position vacancies, savings to contracted svcs, & leased veh. expense
OPERATING INCOME (LOSS) ($393,173.00) ($393,173.00) $37,268.00 ($205,971.00)
NET NON-OPERATING REVENUE (EXP) $40,022.00 $4002200 $43,906.00 $3,884.00 Favorable due to gain on sales of vehicles 8 equip. offset by lower returns on investments.
NET REVENUES OVER(UNDER)
EXPENSES , ($35%i51.0) 14.t.opi ___ _ S81,174.00 .1$20Z0870)
1 FOREPRNT1A4(4141:13datat123wksldraint 08/14/9901:11 PM
RISK MANAGEMENT
INTERNAL SERVICE FUND
FY 1999 THIRD QUARTER REPORT
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET FORECAST FAVOUNFAV1 COMMENTS
ELIABIUTY INSURANCE FUND 0677)
REVENUE $3,596,728 $3,596,728 $3,759,428 $162,700 - Fav. Investment Income 275,000 due to higher than expected interest
rates and investment base, partially offset by reduced Liability
Insurance revenue due to Community Mental Health's transfer to
authority status (87,300) and Rebilled Charges (25,000).
OPERATING EXPENSE $807,561 $807,561 $785,161 $22,400 -Fav. Insurance premium costs 36,500, turnover 32,500, insurance
appraisal, vaccines, and training supplies costs partially offset by
unfav. Legal Services charges (22,800) for preparation for potential
legal suit and Information Technology Operations costs (35,900).
CLAIMS PAID 2,789,167 2,789,167 2,289,167 500,000 -Liability Insurance claims costs will be determined by fiscal year-end
analysis of claims costs, claims estimates and reserve requirements.
TOTAL EXPENSES $3,596,728 $3,596,728 $3,074.328 $522,400 Forecast is based on claims costs incurred through June 1999.
NET REVENUES OVER/(UNDER) $0 t685000 W35,100
EXPENSES
[FRINGE BENEFIT FUND (#678)
AMENDED FY 1999 VARIANCE
BUDGET FORECAST FAV/(UNFAV) COMMENTS
ADOPTED
BUDGET
FRINGE BENEFIT FUND
INTERNAL SERVICE FUNDS
FY 1999 THIRD QUARTER REPORT
{ REVENUE
DEFINED BENEFIT CONTRIBUTION
RETIREES HOSPITALIZATION
RETIREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE IN-SERVICE TRAINING
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
FLEXIBLE BENEFITS DEDUCTIONS
FORFEITURES
WORKERS' COMPENSATION
UNEMPLOYMENT COMPENSATION
INVESTMENT INCOME
TOTAL REVENUE
[ EXPENSE ..IT 11111
DEFINED BENEFIT CONTRIBUTION
RETIREES' HOSPITALIZATION
RETIREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE IN-SERVICE TRAINING
IN-SERVICE TRAINING - INFO TECH
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
FLEXIBLE BENEFIT PAYMENTS
PROFESSIONAL SERVICES
WORKERS' COMPENSATION
UNEMPLOYMENT COMPENSATION
ACCOUNTING SERVICES
OPERATING TRANSFER OUT
TOTAL EXPENDITURES
$1,534.100 $1.534,100
12,681,100 12,681,100
2.986,100 2,986,100
750,000 750,000
300,000 300,000
39,800 39,800
845,100 845,100
6,744,400 6,744,400
458,400 458,400
794,400 794,400
18,207,700 18,207,700
13,538.400 13,538,400
2,310,000 2,310.000
315,600 315,600
615,000 815,000
1,262.300 1.262,300
206,500 206,500
185,000 185,000
3,210,500 3,210,500
225.000 225,000
750,000 750,000
$67,959,400 $67,959,400
$1.448,300 ($85,800)-Approximately 946% of Retirement revenue allocations are anticipated to be recovered in
11,981.700 (699,400) FY 1999, based on recovery through June 1999. The deletion of Community Menial
2,821.900 (164,200) Health positions, effective 1-1-99, reduced both revenue and expenditure to the Fringe
709,200 (40,800) Benefit Fund beginning in January 1999.
283,700 (16.300)
66,600 26.800 -Includes transfer of interest earned in Deferred Compensation Fund (now closed).
796,300 (48,800)
6,372,800 (371,600)
433,000 (25,400)
767,700 (26,700)
18.098,400 (109,300)-CMH separation reduces revenue.
12,367,900 (1,170,500)-Social Security (FICA) revenue follows FICA expenditure; CMH separation reduces revenue.
2.358,700 48,700
317.700 2.100
590,500 (24,500)
1,212,300 (50.000)-Departments are charged for actual short-term disability costs
0 (206,500)-Payment from employees for enhanced coverages in Flex Benefit Program am now netted
against payments paid to employees for enhanced coverages, eliminating this revenue.
252.500 67.500 -Return of DC Plan contributions from ICMA for employees who separated from County service
3,320.019 109,519 prior to vesting and health & dependent care forfeiture of unused deposits.
214,000 (11.000)
1.785,000 1,035,000 -Interest rates and investment base higher than expected.
$66,1982219 A1.761,189
$1,534,100 $1.534,100 $0 $1,534,100 -Budget established prior to receipt of latest actuarial calculation. Contribution to Retirement
Fund not required for General County employees as per actuarial report.
12,681,100 12,681,100 12.345,000 336,100 -Budget established prior to receipt of latest actuarial calculation.
2,986,100 2,986,100 3,139,800 (153,700)-Financial education seminars for County employees 106,900 plus investment counsel fees.
750,000 750,000 675,000 75,000 -Payments for accumulated A/L and S/L days to employees separating from County service.
300,000 300,000 242,500 57.500 -Cost reflects current level of participation in the Tuition Reimbursement Program.
39,800 39,800 39,800 0
485,100 485,100 568,500 (83.400)-PeopleSoft training costs.
360,000 360,000 450.000 (90.000)-Estimate reflects current level of IT training.
6,744,400 6,744,400 6,011.000 733.400 -Est based on current level of County contributions to ICMA for the Defined Contribution Plan;
458,400 458.400 483,400 (25,000) CMH separation reduces cost.
794.400 794,400 749,400 45,000 -Variance reflects the separation of CMH employees 111199.
18,207.700 18.207,700 18.207.700 0 -Estimated cost based on projection of current usage.
-Costs include actual claims costs, administration and stop/loss charges from BC/BS and HMO
premiums. Costs will be Credited 835,000 for adjustment of Fiealth IBNR reserve.
13,627,000 13,827,000 12,461,400 1,165,600 -FICA rate applied against actual salaries cost; CMH separation reduces cost
2,310,000 2.310,000 2.245,000 65,000 -Cost based on actual claims and administration fee paid to Delta Dental beg. January 1999
315,600 315,600 280.600 35,000 CMH separation reduces cost.
1,877,300 1,877,300 1,792,300 85,000 -Short-term disability claims (recovered by charges to departments).
364,500 364.500 41,600 322,900 -Payments to employees for reduced coverages (including hospitalization opt-outs) in Flexible
Benefits Program are now netted against payments received from employees for enhanced
132,300 132,300 132,300 0 coverages, reducing both Program expense and revenue.
3,210,500 3,210,500 2.460,500 750,000 -Adjustment of Workers' Compensation claim-year reserves will be determined by fiscal
225,000 225,000 175,000 50.000 year-end analysis of claims. Forecast is based on claims costs through June 1999.
67,800 (67,800)-Charge for accounting services to Fringe Benefit Fund implemented subsequent to budget.
1.600,000
-
_0,600,0014-Transfer to Capital Improvement Fund for capital costs of on-site child care facility - MR098329.
$67,403,i-00 te„403,300 S64,168,600 $3,234,700
REVENUE OVERAUNDER) EXPENSE $556 100 $556 100 $2 029 619 $1 473 519
FRINGE BENEFIT FUND
INTERNAL SERVICE FUNDS
FY 1999 THIRD QUARTER REPORT
ADOPTED
BUDGET
I-FRINGE BENEFIT FUND (111678)
AMENDED FY 1999 VARIANCE
BUDGET FORECAST FAV/(UNFAV) COMMENTS
REVENUE
DEFINED BENEFIT CONTRIBUTION
RETIREES HOSPITALIZATION
RETIREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE IN-SERVICE TRAINING
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
SHORT-TERM DISABILITY
FLEXIBLE BENEFITS DEDUCTIONS
FORFEITURES
VVORKERS' COMPENSATION
UNEMPLOYMENT COMPENSATION
INVESTMENT INCOME
TOTAL REVENUE
EXPENSE
$1,534,100 $1,534,100 91,448.300
12,681,100 12,681,100 11,981.700
2,986,100 2,986,100 2,821.900
750,000 750.000 709,200
300,000 300,000 283,700
39.800 39.800 66,600
845,100 845,100 796,300
8.744,400 6,744,400 6,372,800
458,400 458.400 433,000
794,400 794,400 767,700
18,207.700 18,207,700 18,098,400
13,538,400 13,538,400 12,367,900
2,310,000 2,310,000 2,358,700
315,600 315,600 317,700
615,000 615,000 590,500
1,262,300 1,262,300 1.212,300
206,500 206,500
185,000 185,000 252,500
3,210.500 3,210,500 3,320.019
225,000 225,000 214,000
750,000 750,000 1,785,000
$67,959,400 $67,959,400 $66,198,219
($85,800)-Approximately 946% of Retirement revenue allocations are anticipated to be recovered in
(699,400) FY 1999. based on recovery through June 1999 The deletion ot Community Mental
(164,200) Health positions, effective 1-1-99, reduced both revenue and expenditure to the Fringe
(40,800) Benefit Fund beginning in January 1999
(16,300)
26.800 -Includes transfer of interest earned in Deferred Compensation Fund (now closed).
(48,800)
(371,600)
(25,400)
(26,700)
(109,300)-CMH separation reduces revenue.
(1,170,500)-Social Security (FICA) revenue follows FICA expenditure„ CMH separation reduces revenue
48,700
2,100
(24,500)
(50,000)-Departments are charged for actual short-term disability costs.
(206,500)-Payment from employees for enhanced coverages in Flex Benefit Program are now netted
against payments paid to employees for enhanced coverages, eliminating this revenue
67,500 -Return of DC Plan contributions from ICMA for employees who separated from County service
109,519 prior to vesting and health & dependent care forfeiture of unused deposits.
(11,000)
1,035,000 -Interest rates and investment base higher than expected
j$1,7611,1911)
DEFINED BENEFIT CONTRIBUTION
RETIREES' HOSPITALIZATION
RETIREMENT ADMINISTRATION
COMPENSATED ABSENCES
TUITION REIMBURSEMENT
EMPL. DEFERRED COMP. ADMIN.
EMPLOYEE IN-SERVICE TRAINING
IN-SERVICE TRAINING - INFO TECH
DEFINED CONTRIBUTION PLAN
DEFINED CONTRIBUTION ADMIN.
GROUP LIFE
HOSPITALIZATION
SOCIAL SECURITY
DENTAL INSURANCE
OPTICAL INSURANCE
DISABILITY INSURANCE
FLEXIBLE BENEFIT PAYMENTS
PROFESSIONAL SERVICES
WORKERS' COMPENSATION
UNEMPLOYMENT COMPENSATION
ACCOUNTING SERVICES
OPERATING TRANSFER OUT
TOTAL EXPENDITURES
$1,534,100 $1,534,100 $0 $1,534,100 -Budget established prior to receipt of latest actuarial calculation Contribution to Retirement
Fund not required for General County employees as per actuarial report
12,681.100 12,681,100 12,345,000 336,100 -Budget established prior to receipt of latest actuarial calculation
2,986,100 2,988,100 3,139.800 (153.700)-Financial education seminars for County employees 106.900 plus investment counsel fees.
750,000 750,000 675,000 75,000 -Payments for accumulated A/L and Sit days to employees separating from County service
300,000 300,000 242,500 57,500 -Cost reflects current level of participation in the Tuition Reimbursement Program
39,800 39.800 39,800 o
485,100 485,100 568,500 (83,400)-PeopieSoft training costs.
360,000 360,000 450,000 (90,000)-Estimate reflects current level of IT training.
8,744,400 6,744,400 6,011,000 733,400 -Est, based on current level of County contributions to ICMA for the Defined Contribution Plan;
458,400 458,400 483,400 (25,000) CMH separation reduces cost.
794,400 794,400 749,400 45,000 -Variance reflects the separation of CMH employees 1/1/99.
18,207,700 18,207,700 18,207,700 0 -Estimated cost based on projection of current usage.
-Costs indude actual claims costs, administration and stopaoss charges from BC/BS and HMO
premiums. Costs will be credited 835,000 for adjustment of Health IBNR reserve.
13,821,000 13,627,000 12,461,400 1,165,600 -FICA rate applied against actual salaries cost; CMH separation reduces cost.
2,310,000 2,310,000 2,245,000 65,000 -Cost based on actual claims arid administration fee paid to Delta Dental beg. January 1999
315,600 315,600 200,600 35,000 CMH separation reduces cost
1,877,300 1.877,300 1,792,300 85,000 -Short-term disability claims (recovered by charges to departments).
364,500 364,500 41,600 322,900 -Payments to employees for reduced coverages (including hospitalization opt-outs) in Flexible
Benefits Program are now netted against payments received from employees for enhanced
132,300 132,300 132,300 0 Coverages, reducing both Program expense and revenue
3,210,500 3,210,500 2,460,500 750,000 -Adjustment of Workers' Compensation claim-year reserves will be determined by fiscal
225.000 225,000 175,000 50,000 year-end analysis of claims. Forecast is based on claims costs through June 1999.
67,800 (67,800)-Charge for accounting services to Fringe Benefit Fund implemented subsequent to budget.
1,600,000 (1,600,000)-Transfer to Capital Improvement Fund for capital costs of on-site child care facility - MR*98329
887,403,300 167,403,300 $64.168.600 $3,234200
._V 0Q s558 loo $2 on 619 _f1 473 519 REVENUE OVERAUNDER) EXPENSE
DEPARTMENT OF MANAGEMENT AND BUDGET
INTERNAL SERVICE FUNDS
FY 1999 THIRD QUARTER FORECAST
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAV)
OFFICE EQUIPMENT FUND (66400)
OPERATING REVENUE-Inside
OPERATING EXPENSE
OPERATING INCOME
NET NON-OPERATING REV (EXP)
INCOME (LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS OUT
NET REVENUES OVER/(UNDER)
EXPENSES
514,101 514,101 359,572 (154,529) -
624,364 624,364 505,750 118,614 -
($110,263) ($110,263) ($146,177) ($35,914)
110,263 110,263 62,650
$0 $0 $0 $11,698
0 (215,000) (215,000)
$0 $0 ($215,000) ($203,301)
Reduced revenue reflects equipment written off
year-end 1998 and Prior Year Revenue ($105,025)
Favoribility in Equipment Repairs & Maint. $25,357,
Equipment Replacement $28,406 and Maint. Cont.
$40,272 reflect reduced inventory. Favorable
Depreciation $15,954 from equip. write off.
47,613 - Revenue projection low in Income from Investments
fay. $49,360 and Gain/Loss on sale of Equipment
fay. $2,870. Over projected Interest from Municipalities
unfav. ($7,589.33). Unbudgeted Prior Years Adjustment
fay. $2,974.
08/17/99
$906,122.00
21,426,779.00
$906,122.00
21,426,779.00
$906,122.00
20,271,414.00
$22,332,901.00 $22,332,901.00 $21,177,536.00
$19,848,402.00 $21,470,996.00 $21,470,885.00
$1,329,134.00
$212,144.00
$54,000.00
($2,350,000.00)
$862,016.00
$200,000.00
$54,000.00
1$2,350,000.00)
$861,905,00
$200,000.00
$54,000.00
A$2,350,000.00)
($754222:00) 1S1,233,944.90) 1$134,095.0(1)
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUEJ(EXPENSE)
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
NET REVENUES OVER(UNDER)
EXPENSES
$0.00
A1,155.365.00) Main!. Dept. Charges budget realigned, & Special Conhads cost now direct charged to contracts.
($1,155,365.00)
$1,622,594.00 Fey, due to position vac. & turnover, lower OT, lower sublet repairs, elect and gas util and lower supplies usage.
Partially offset Dy higher Internal Svcs compute( oper. and leased veh
$467,229.00
$12,144.00 Fav. due to gain on sale of equip not budgeted, and higher invested assets generating higher Income
$0.00
$0.00
,_t479,373,00
$107,562.00 $107,562.00
$107,562.00 $107,562.00
$0.00 $0.00
$107,562.00
$107,562.00
$0.00
$0.00
$0.00
$0.00
DEPARTMENT OF FACIUTIES MANAGEMENT
INTERNAL SERVICE FUNDS
1999 THIRD QUARTER REVIEW REPORT
FACIUTIES MAINTENANCE & OPERATIONS
ADOPTED
BUDGET
j1131)
AMENDED
BUDGET
1999
THIRD QTR. REV.
VARIANCE
FAV(UNFAV) COMMENTS
--:"ONTIAC MARKET (55100)(261)
OPERATING REVENUES - OUTSIDE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS (OUT)
NET REVENUES OVER(UNDER)
EXPENSES _$0.00 _10,00
1 FM0FORE.INK4i, 08/13/9904:59 PM
Information Technology - Operations (636)
OPERATING REVENUES.
Outside
Inside
Prior Years Balance
VARIANCE
FAV/(UNFAV)
Total Fund
COMMENTS
412,852.10 - Fay. due to revised Equalization User Rate Structure
(685,738.31)- (Unfav) due to decrease of Information Technology User Rate Structure
0.00
155,808.00
19,452,380.00
211,652.00
60,686.00
272,338.00
157,333 00
0.00
115,005.00
281,153.00 316,982 17
1,435,000.00 1,435,000.00
2,700,000.00 2,700,000.00
281,153.00
1,435,000.00
1,716,153.00
1,716,153.00
0.00
4,416,153.00 4,451,982.17
2,931,916.00 2,769,380.93
1,484,237 00 1,682,601 24
Information Technology - CLEMIS (635)
OPERATING REVENUES:
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING INCOME (LOSS)
Total Fund
35,829.17 - CLEMIS Outside Operations Fav due to (3) additional outside customers
0.00 Sheriff Dept. Contracted Services of $27,000 , plus County Countribution of 1,408,000
0.00 - E-911 call taking equipment
35,829.17
162,535.07 - Fay. due to minimum operating expenses
198,364 24
OAKLAND COUNTY INTERNAL SERVICES
INFORMATION TECHNOLOGY
FY99 THIRD QUARTER FORECAST
ADOPTED
BUDGET
2,173,181.00
15,581,104.00
1,542,307.00
AMENDED
BUDGET
1,684,209.00
17,538,135.00
1,542,307.00
FY 1999
FORECAST
2,097,061.10
16,852,396.69
1,542,307.00
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
5,998,983 00 5,998,983 00
26,763,634.00 26,490,747.79
19,452,380.00 21,422,499.00 23,272,987.26
0.00
0.00 5,341,135.00 3,217,760.53
0.00 - Data Warehouse Res. 097136, $155,808---Transfer positions from Comm. & Econ.
Dev. to Disc. Res. 098309, $81,690--- Enhancements to Equal & Tax Billing Sys Res
Res. 098242, $552,500 Res 099005 Med Examiner Case Mgmt Sys. $279,115.,
Res. 099123 unfunded state mandates $693,005 , $99141 DTRF Imaging loan payoff
$2,671,100., 099140 ManNVan $1,533,721, 099141 GIS $182,000
$5,852. Law Library SCSI CD Drives
(1,850,488.26)- Professional Services unfav due to 12K contractors
- Software unfav. due to replacement of non-compliant pc suites
0.00
(2,123,374.47)
(272,866.21)
Information Technology In-Car Terminals (637)
OPERATING REVENUES.
Outside
Inside
OPERATING TRANSFERS IN
Total
OPERATING EXPENSES
OPERATING TRANSFERS (OUT)
OPERATING INCOME (LOSS)
211,652.00 251,742.62
65,443.00 60,686.00
39850.00 39,850.00
316,945.00 352,278.62
162,090.00 138,652.61
000 0.00
154,855 00 213,626 01
Total Fund:
40,090.62
(4757.00)-
0.00 - Sheriffs Dept. Contract with Addison, Highland,Springtield, Orion, Oakland & R 0. Twp
3533362 - Revenue's Fav, due to Income from Investments
23,437.39 - Far,. due to minimum operating expenses
0.00
58.771,01
Prepared by Fiscal Services, Linda Pearson 1 08/18/99
OAKLAND COUNTY INTERNAL SERVICES
INFORMATION TECHNOLOGY
FY99 THIRD QUARTER FORECAST
ADOPTED AMENDED FY 1999 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)
Informedon Technology - Telephone Communications (675)
COMMENTS
OPERATING REVENUES.
Outside 2,524,212.00 1,527.803.00 1,103,847.76
Inside 1,527,803.00 2,524,212.00 2,454,853.04
OPERATING TRANSFERS IN
Total Fund:
(424,155.24)- (Unfav) due to lower income from investments and over-stated appropriation
(69,358.96)- (Unfav) due to over-slated appropriation
0.00
Total 4,052,015.00 4,052,015.00 3,558,500 80 (493,514 20).
OPERATING EXPENSES 3.582.540.00 4,117,540.00 3,594,798 95 522,741 05 - Fay. due to minimum operating expenses and purchase of future PBX equipment
OPERATING TRANSFERS (OUT) (535,000.00) 0.00
OPERATING INCOME (LOSS) (65,525.00) (65,525 00) (36,298.15) (29,226.85)
2 08/18/99 Prepared by Fiscal Services, Linda Pearson
ADOPTED
BUDGET
-Ni' witifttlA1501. AIRPORT III
AMENDED FY 11199 VARIANCE
BUDGET FORECAST FAVIUNFAV)
1
COMMENTS
$000 $2,694,821.00 $2,694,821 .00 $2894821.00 OPERATING REVENUE
000
$0.00
000
PP?
0.00
0.03
000
303,963.00 96,233.00
0.00 0.00
$1,300.0_0 1 300.00379 700.00 _ ,(1281 00,_02
0.00
0.00
$0 .00
0.00
$0.00 $477,038.00 $477,038.03 $477,038.00 REVENUES - OUTSIDE
1,249,569.00 1,245,043,00 , 1,345043.00
$1,726,607.00 $1,722,081.00 $1,822,081.00
893,248 00 1,762.488.00 1,362,488.00
$833,359.00 ($40,407.00) $459,593.00
REVENUES INSIDE
TOTAL
OPERATING EXPENSES
OPERATING INCOME (LOSS)
DEPARTMENT OF CENTRAL SERVICES
FY 1889 THIRD QUARTER REPORT
OPERATING EXPENSE
OPERATING INCOME (LOSS)
NON-OPERATING INCOME
INCOME (LOSS) BEFORE
OPERATING TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS OUT
ADD BACK DEPRECIATION CLOSED TO
CONTRIBUTED CAPITAL
NET INCOME (LOSS)
[MOTOR POOL eel
OPERATING REVENUE
OPERATING EXPENSES
OPERATING INCOME (LOSS)
NET NON-OPERATING REV (EXP)
NET INCOME(LOSS) BEFORE OPERATING
TRANSFERS
OPERATING TRANSFERS IN
OPERATING TRANSFERS OUT
NET INCOME (LOSS)
11"1"b"--- UNICATIONS 860
3 094 821.00 3 094 821.00 _ 34,821.O0
($400,00000) ($400,000.00) (1400,000.00)
400,000.00 400 000.00 400,000.00
$0.00 $omo $0.00
0,00 0.00 0.00
000 0.00 0.00
0.00 0.00
.00 .10 00
$4,162,263.00 $4,121,940.00 $3,894,940.00 ($227,000 00) Use of fund balance for compliance with A-87, ($130,091); unfav Insurance Reserve
revenue budgeted amount overestimated accidents with third party insured vehicles
($115,000)
(2.1spo.op) Urdav depreciation expense ($194,000) due to vehicles being purchased instead
of leased which is partially °NW by leased fay $107,000. Insurance charges unfav
($165,000) due to higher than expected insurance coat; lay. Gas. Oil and Grease
$95,000 due to overestimate of expense; Utiles Adjustment of Prior Years Revenue
($99,336) due to repurchase of CASH vehicles and unfav Depreciation-Equipment
($54, 437) due to one time accounting adjustment
($386,226.00) ($442,000.00)
61 000.00 Fair reduction in Interest expense from leased vehicles, $53,000; lair Gain on Sale of
Vehicles, $14,130; and unfav investment income, $6,000.
(U75,933 00) ($361,000.00)
0.00
4744,j9.00 4,496,166.00 428 166.00
($581.858 00) (1374,226.00)
279,3.00 279 293.00 340,293.00
($302,663.00) ($34,933.00)
100,000.00 Fax increased repair charges offset by uglily budgeted us* or fund balance
$100.000.00 for A-87 compliance
(400.000.00) Unfair ($100,000) depreciation due to one time wile-oft of assets under $1,000;
unfav, equipment repairs ($98,000), parts and accessories ($95,000), expendable
($300,000.00) equipment, ($22,500), smelt tools ($20,000), shop supplies ($10,000)
due to significant increase in repair requests; Info Tech Operations unfav.($20,000)
NET NON-OPERATING REV (EXP) 7,500 .00 7,..00 00 30,500.00 23,000.00 Fav Investment income due to larger than anticipated fund balance
INCOME(LOSS) BEFORE OPERATING
TRANSFERS
NET OPERATING TRANSFER 04f(OUT)
NET INCOME (LOSS)
1840,85900 ($32,907.00) $490,093.00 ($277,000.00)
_ 59.627.00 1,157.00 157.00 0.00
1 j5o i Thoo0.L00-
Interoffice
MEMORANDUM
to: Tim Soave, Fiscal Services
cc: Claudia Martell°, Reimbursement
from: Nancy L Wagner, Reimbursement rfr
re: Inmate Waived Report
date: August 3, 1999
Submitted for your review is the Inmate Report for 1999 for the Months of April, May, and June.
Amounts Amount Waived
April 99 013723 CZ 79 $ 144,684.00
May 99 014435 CZ 80 $ 146,161.60
June 99 015057 CZ 68 $ 140,413.00
TOTAL 227 $ 431,258.60
From the desk of .
Nancy L. Wagner
Reimbursement
1200 N Telegraph Road
Pontiac, Michigan 48343
te1:248-858-1459
fax:248-975-4288
Resolution #99228 September 9, 1999
Moved by Douglas supported by Galloway the resolution be adopted.
AYES: Colasanti, Coleman, Devine, Dingeldey, Douglas, Galloway, Garfield,
Gregory, Jensen, Law, McCulloch, McPherson, Melton, Millard, Moffitt, Obrecht,
Palmer, Patterson, Schmid, Sever, Suarez, Taub, Amos, Appel,
Causey-Mitchell. (25)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
L. Brooks Patte
THE FOREGOING RESOLUTION
/
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on September 9, 1999 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 9th day,pf September, 1999.
/1,14Led-ry,ft_
- William Caddell, County Clerk