HomeMy WebLinkAboutResolutions - 1993.12.09 - 22318December 9, 1993
MISCELLANEOUS RESOLUTION #93270
BY: FINANCE COMMITTEE, JOHN P. MCCULLOCH, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - 1993 THIRD QUARTEL: 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 with the Oakland County General Appropriations Act Section 22, provides for budget
adjustments for variances between the budgeted revenue and actual revenue, and Section 23, provides
for budget adjustments for variances between estimated revenue and projected expenditures; and
WHEREAS the 1993 General Appropriations Act, Section 16, states that expenses will be
controlled within the categories of Salaries and Fringe Benefits, Overtime, and Operating, and at no time
shall the net expenditures exceed the total appropriations for such categories; and
WHEREAS on September 13, 1993 the Building Authority approved the defeasance of the Oakland
County Building Authority Revenue Bonds Series 1966 (East Wing Bonds) and returning the balance of
those funds to the Oakland County General Fund in the amount of $2,248,387.88 plus any additional
interest to be earned: and
WHEREAS the 1993 General Appropriation to the Building Authority did not contemplate the net
increase in principal and interest payments for refunding the Computer Center and Law Enforcement
Complex Bonds ($1,000,000); and
WHEREAS the Jury Commission and Drain Office are projected to exceed the total expenditure
appropriation at year end and need additional funding (Schedule A); and
WHEREAS the Circuit Court has requested funding for the conversion of one additional court
room to video; and
WHEREAS the Circuit Court/Friend of the Court, District Court, Prosecuting Attorney, County
Executive, Management and Budget, Public Works, Personnel, and Public Services are projected to be
within budget appropriations at year-end but not within control category appropriation, thus requiring a
transfer of funds between categories in order to comply with the General Appropriations Act (Schedule A);
and
WHEREAS the Sheriff's Department expenditure budget is projected to exceed the total
appropriation which is offset by favorable revenue; and
WHEREAS the 1993 Third Quarter Forecast Report has identified the need for specific other
budget amendments as subsequently described and also listed on Schedule A; and
WHEREAS Miscellaneous Resolution #93168, approving the 1993/1994 Waterford School District
Agreement, requires budget amendments be made with the Third Quarter forecast recognizing the
elimination of state aid revenue, ($685,600) and the capping of teacher services expenditures, $638,900,
as well as the County's share of the 1992/1993 contract closing cost, ($42,700); the unfavorable variance
to be covered by salary and fringe benefit savings in the Children's Village budget; and
WHEREAS through the efforts of the Medical Care Facility Task Force, additional revenue has
been generated by the Medical Care Facility through the assumption of tube feeding activities, $130,000,
reallocating of medicare/medicaid cost reports, $473,900, and increased per diem rate, $81,000; these
funds can be used to offset operating shortfalls in other areas; and
WHEREAS net child care expenses are estimated to exceed budget by approximately $1,100,000
due to higher occupancy rates at Children's Village, ($585,600) and Camp Oakland ($210,000), expanded
use of the Camp Oakland Boot Camp, ($181,000) and increasing lengths of stay and per diem cost at
state institutions, ($500,000); and
WHEREAS the Computer Services Operations allocation should be adjusted based on actual
charges anticipated through the year (see Schedule B); and
WHEREAS the State of Michigan does not allow interest expense to be included in the
reimbursement for Computer Services imaging costs and will result in unfavorable revenue to Computer
Services; and
WHEREAS the Sheriff's Department has requested to use $640 in Auto Theft Forfeiture Funds to
send two officers to a training seminar; and
WHEREAS in accordance with M. R. 93135, Revised Policy for Bad Debt Write Off, Accounting
Division submits a listing of all bad debt write offs occurring during the preceding three months and
requests authorization to write-off all bad debts in excess of $1,000.
NOW THEREFORE BE IT RESOLVED that the General Fund realize $2,348,387.88 plus any
additional interest earned and amend the 1993 General Fund Revenue Budget to reflect the East Wing
Bonds defeasance.
BE IT FURTHER RESOLVED the Oakland County Board of Commissioners approves amendments
increasing and adjusting the 1993 Governmental Fund Revenue and Expenditure Budget as detailed in
Schedule A.
BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners approves
amendments to the 1993 Computer Services Operations allocation as listed on Schedule B.
BE IT FURTHER RESOLVED the Oakland County Board of Commissioners appropriates $640
from the Sheriffs Department Auto Theft Prevention account (1-10100-201-055) and transfers the same
to the Sheriff's Department 1993 Budget as follows:
3-10100-431-01-00-2340 Misc Revenue $640
4-1 01 00-439-1 5-00-3752 Travel & Conference 640
$_Q
BE IT FURTHER RESOLVED that the Board accepts the Accounting Report on bad debt write offs
and approves those in excess of $1,000.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution,
FINANCE COMMITTEE
1:\LYND13QAMEND.MR
SCHEDULE A
1993
3RD QUARTER AMENDMENTS
NON-DEPARTMENTAL
Revenue
3-10100-904-01-00-5XXX
3-10100-906-01-00-2233
3-10100-901-01-00-9102
Expenditure
4-10100-901 -01 -00-8512
JURY COMMISSION
Expenditure
4-101 00-215-01 -00-4909
DRAIN COMMISSIONER
Revenue
3-10100-611-01-00-2529
3-10100-611-01-00-2513
Expenditures
4-10100-611-10-00-1001
4-10100-611-16-00-1002
4-10100-611-10-00-2070
4-10100-611-16-00-3574
4-10100-611-01-00-6670
Bldg. Authority East Wing
Income from Investments
Allowance for TIFA/DDA
Sub-Total
Building Authority
Postage
Drain Reimb. of Salaries
Drain Reimb. of Mileage
Sub-Total Drain Revenue
Drain - Salaries
Drain - Overtime
Drain - Fringe Benefits
Drain - Personal Mileage
Drain - Stationery Stock
Sub-Total Drain Exp
2,348,388
(1,150,000)
(788,208)
410,180
1,000,000
15,000
(117,000)
17,000
(100,000)
(136,000)
105,000
(32,000)
17,000
3,000
(43,000)
CIRCUIT COURT
Expenditures
4-10100-311-05-00-1001
4-1 01 00-311-05-00-2070
4-10100-311-05-00-3100
4-10100-311-05-00-3295
4-10100-311-05-00-4898
4-10100-311-05-00-3347
4-10100-311-05-00-8670
FRIEND OF THE COURT
Revenue
3-10100-312-01-00-2077
Expenditures
4-21500-312-01-00-1002
Salaries
Fringe Benefits
Juror Fees & Mileage
Court Reporter Services
Office Supplies
Expendable Equipment
Oper Transfer-Equipment Fund
Sub-Total Circuit
Friend of the Court-CRP
Overtime
Sub-Total FOC
(20,000)
(50,000)
50,000
20,000
(678)
678
80,000
80,000
25,000
25,000
I rill, I UlJUrt I
Division I-WALLED LAKE
Revenue
3-10100-322-01-00-2366
Expenditures
4-101.00-322-01-00-1002
4-10100-322-01-00-1001
4-10100-322-01-00-3100
4-10100-322-01-00-3777
Division ,IV-TROY
Revenue
3-10100-325-01-00-2366
Expenditures
4-10100-325-01-00-1002
4-10100-325-01-00-3658
PROSECUTING ATTORNEY
Expenditures
4-10100-411-01-00-1001
4-10100-411-01-00-3340
4-10100-411-01-00-3348
4-10100-411-01-00-3351
4-10100-411-01-00-3658
4-10100-411-01-00-6310
4-10100-411-05-00-3100
4-10100-411-05-00-3128
4-10100-411-05-00-3152
4-10100-411-05-00-3180
Ordinance Fines & Costs
Overtime
Salaries
Juror Fees & Mileage
Visiting Judges
Sub-Total
Ordinance Fines & Costs
Overtime
Rent
Sub-Total
Sub-Total District Court
Salaries-Regular
Equipment Rental
Extradition Expense
Filing Fees
Rent
Bldg. Space Cost
Juror Fees & Mileage
Professional Services
Reporter & Steno Svcs.
Witness Fees & Mileage
(40,000)
3,750
(3,750)
(20,000)
(20,000)
(40,000)
(155,000)
5,500
(160,500)
(155,000)
0
(200,000)
27,700
70,000
10,800
91,500
(50,000)
9,000
3,000
12,000
26,000
Sub-Total Prosecuting Att'y 0
SHERIFF
Revenue
3-10100-433-01-00-2036
3-10100-433-10-00-2101
3-10100-433-10-00-2379
3-10100-432-01-00-2531
Expenses
Radio Communications
4-10100-431-01-00-6600
4-10100-433-10-00-6600
4-10100-434-15-00-6600
4-10100-436-01-00-6600
4-10100-439-01-00-6600
Board & Care
Deferred Offender
0.LU.L. 3rd Offense
Reimbursement of Salaries
Sub-Total Sheriff Revenue
Radio Communications
Radio Communications
Radio Communications
Radio Communications
Radio Communications
50,000
50,000
195,000
155,000
450,000
20,000
23,000
15,000
75,000
(125,000)
8,000
4-67sCAJGU V I111,1t.7,0
4-10100-431-01-00-6610
4-10100-432-01-00-6610
4-10100-436-01-00-6610
Administrative Services
4-10100-432-01-00-3372
4-10100-432-01-00-6670
4-10100-432-01-00-6672
Corrective Services
4-101007433-10-00-1001
4-10100-433-10-00-2077
4-10100-433-10-00-2079
4-10100-433-11-00-1001
4-10100-433-11-00-2077
4-10100-433-11-00-2079
4-10100-433-10-00-1002
4-10100-433-11-00-1002
4-10100-433-10-00-3396
4-10100-433-10-00-3412
4-10100-433-10-00-3558
4-10100-433-10-00-4892
4-10100-433-10-00-6333
Corrective Services - Satellites
4-10100-433-15-00-1001
4-10100-433-15-00-1002
4-10100-433-1 5-00-1 001
4-10100-434-25-00-1002
Protective Services
4-10100-436-18-00-1002
Technical Services
4-10100-439-05-00-1002
4-10100-439-10-00-1001
4-10100-439-15-00-1001
4-10100-439-05-00-1002
4-10100-439-10-00-1002
4-10100-439-15-00-1002
4-10100-439-30-00-1002
Leased Vehicles
Leased Vehicles
Leased Vehicles
Uniform Cleaning
Stationery Stock
Print Shop
Salaries
Fringes-Retirement
Fringes-RCA
Salaries
Fringes-Retirement
Fringes-FICA
Overtime
Overtime
Hosp. of Prisoners
Insurance
Outside Prisoner Housing
Medical Supplies
Cent. Stores - Provision
Trusty Camp. - Salaries
Trusty Camp. - OT
Southfield - Salaries
Southfield - OT
Contracted Patrol - CT
Communications - Salaries
Operations - Salaries
Special Teams - Salaries
Communications - OT
Operations - OT
Special Teams - OT
Records - OT
Sub-Total Sheriff Expenses
Sub-Total Sheriff
15,000
(15,000)
(75,000)
(75,000)
30,000
40,000
35,000
--------
105,000
(145,000)
(33,000)
(11,000)
(82,000)
(21,000)
(7,000)
50,500
24,500
285,000
87,800
50,000
35,000
157,500
391,300
(33,500)
18,400
(17,600)
35,500
2,800
72,500
72,500
(26,000)
(28,700)
(72,000)
27,000
25,000
8,100
12,000
(54,600)
450,000
0
(685,600)
(190,500)
(876,100)
VU tiLIL' VV-Jr-UNO
Expenditures
4-10100-141-10-00-6300
4-10100-148-01-00-3128
4-10100-148-01-00-3464
4-10100-148-01-00-4909
4-10100-148-01-00-6610
4-10100-148-01-00-6670
PERSONNEL
Expenditures
4-101 00-1 51-01-00-2078
4-10100-154-01-00-3334
4-10100-154-01-00-3336
4-10100-154-01-00-3653
4-10100-154-01-00-3731
4-10100-154-02-00-1001
4-10100-155-10-00-1002
4-10100-155-10-00-2077
W & S Equipment
Professional Services
Licenses & Permits
Postage
Leased Vehicles
Stationery Stock
Sub-Total Public Works
Fringe Benefit-Hosp.
Employees In-Service Trng
Employees Medical Exams
Recruitment Expense
Tuition Reimbursement
Salaries-Reg,
Overtime
Fringe Benefits
(15,000)
6,500
4,250
500
2,500
1,250
(2,000)
(15,000)
(6,000)
(15,000)
36,000
(7,500)
7,500
2,000
PUBLIC SERVICES
COOPERATIVE EXTENSION
Expenditure:
4-10100-175-01-00-3128
CIRCUIT COUR r PROBATION
Expenditure .
4-10100-179-01-00-6641
4-10100-179-01-00-6750
COMPUTER SERVICES *
4)00(X 636X
4-10100-181-01-00-8615
* (See Schedule B)
CHILDREN'S VILLAGE FUND
Revenue
3-29230-165-01-00-2056
3-29230-165-01-00-2036
Sub-Total Personnel
Professional Services
Convenience Copier
Telephone Communications
Sub-Total Public Sys
Computer Services-Operations
Operating Transfer-Comp. Svc.
Sub-Total Computer Sys
State Aid
Board and Care
0
(22,000)
14,000
8,000
22,000
0
(394,410)
42,790
(351,620)
Miscellaneous
Daily Patient Services
Physical Therapy
Tube Feeding
SC Difference
Medicaid Audit
Reimb. Pharmacy
Dry Goods & Clothing
Overtime
Holiday Overtime
Equipemnt Rental
Salaries
Fringe Benefits
Nursing Salaries
Jail-Overtime
Jail-Holiday Overtime
Professional Services
34,800
81,000
120,000
130,000
257,700
216,200
29,900
869,600
(23,000)
4,400
5,300
13,500
23,200
(70,000)
(43,300)
(113,300)
(226,500)
15,000
5,000
114,200
(92,300)
(10,200)
10,200
0
JUVLNILL MAIN I LNANt....t 1-LJNIJ
Revenue
3-29260-343-01-00-2490 Refund-Prior Years 113,300
MEDICAL CARE FACILITY FUND
Revenue
3-52100-163-01-00-2340
3-521 00-1 62-02-00-2091
3-52100-163-02-00-2393
3-52100-163-02-00-2679
3-52100-163-04-00-2579
3-52100-163-08-00-2377
3-52100-163-70-00-2479
GENERAL FUND
Expenditures
SOCIAL SERVICES
4-10100-168-01-00-4832
MEDICAL EXAMIMER
4-10100-169-01-00-1002
4-10100-169-01-00-1004
4-10100-169-01-00-6640
PROBATE COURT
4-10100-341-03-00-1001
4-10100-341-03-00-2070
HEALTH FUND
4-22100-162-36-00-1001
4-22100-162-15-00-1002
4-22100-162-15-00-1004
4-221 00-1 62-01-00-3128
COMMUNITY MENTAL HEALTH FUND
4-22200-166-01-00-1001 Salaries
4-22200-1 66-01 -00-1002 Overtime
' r
Private Institutions
Salaries
Overtime
Holiday Overtime
Fringe Benefits
Teacher Services
Foster Boarding Homes
Private Int. - Res.
State Institutions
Nursing Salaries
Dietary Overtime
Housekeeping - Hdy. OT
Prov. -Tube Feeding
Laboratory Fees
210,000
-
(194,700)
22,000
27,000
(91,500)
(638,900)
-------
(876 ,100)
(117,900)
206,000
500,000
706,000
-------
(130,900)
1,600
8,400
30,000
90,900
0
U/A1V11-' UHLHINLJ I-UNU
4-2921 0-161-01 -00-3591
CHILDREN'S VILLAGE FUND
4-29230-165-01-00-1001
4-29230-165-01-00-1002
4-29230-165-01-00-1004
4-29230-165-01-00-2070
4-29230-165-55-00-3726
JUVENILE MAINTENANCE FUND
SOCIAL SERVICES
4-29260-168-01-00-3353
PROBATE COURT
4-29260-343-01-00-3589
4-29260-343-01-00-3711
MEDICAL CARE FACILITY FUND
4-521 00-1 63-35-00-1 001
4-52100-163-09-00-1002
4-52100-163-13-00-1004
4-52100-163-05-00-4914
4-521 00-1 63-1 2-00-3440
Account Number
------------------
41010010101006360
41010011101006360
4101001120100E3E0
41010011501005360
01010011801006350
4101001220100E360
41010012301006350
41010012401006360
41010012501005360
41010012701006360
41010013E03006350
41010014501006360
41010015401006360
41010013501005360
41010216101006360
4101031E301006260
41010017301006360
410103 7 7501006350
4101001790100E360
41010019101006360
4101001.9201006360
41010019E0100E350
41010021210006350
41010021301006360
41010321501006360
41010022101006360
410106'31101006360
41010332201006360
410100 -22205006350
41010032301005360
41010032305005360
41010032401006360
41010032405006360
41010022501006360
41010032503006350
47010024101005360
41010:24401006360
41010341101006360
4101004331000E360
4101005110100E360
41010251102006360
41010051301006360
41010051202006360
41010031101006360
42150012355006360
42150212355006366
421500312010063E0
42150031201006366
4221001520100E360
4221001E220006350
42210:16232006360
42210013234006360
42210016235006350
4221001623600E360
42210016244006360
42210017701006360
42210017801006360
02210017820006360
42220016501006360
42923015501006360
42923015555006360
45210016301006360
Account
Solid Waste
County Executive Adm
Auditino
Corporation Counsel
Cultural Affairs
Budget
Accounting
Purchasing
Equalization
Reimbursement
Record Retention
Facilities Engineering
Human Resources
Employee Relations
Instituticoa & Hum. Serv.
Medical Examiner
Vete -ran. F-,rvices
Cooperative Service
Circuit court Probation
Comm. & Econ. Dev. Adm.
Economic Development
Planning
County Clerk
Elections
jury Commission
Treasurer
Circuit Court
52/1 Dist.
52/1
52/2
52/2
52/3
52/3
52/4
52/4
Probate
Probate
Sheriff
Sheriff Corrective
Bd. of Conn. Admin.
Bd. of Comm. Prog. Eval.
Reference Library
Law Library
Drain Ccanissioner
Child Support Acctg.
Child Support Acctg.
Friend of the Court
Friend of the Court
Health Administration
Health-Environmental
Health-Dental
Health-Clinic
Health-TB Control
Health-Field Nursing
Health-Cancer Detection
EMS/Disaster Control
Animal Control
Animal Control
Community Mental Health
Children's Village Admin,
Children's Village School
Medical Care Facility
Dist.
Dist.
Dist.
Dist.
Dist.
Dist.
Dist. Probation
Court Judicial
Estates & Mental
Aclministration
Serv.
Ct.
Ct.
CS.
Ct.
Ct.
CS.
Ct.
Cf.
Admin.
Probation
Probation
Probation
1.3 TnL QUAKT.EK CUM&LIT UFEliATIONS REALLOCATION
1993
1992 Current : - .._,,L Actual Budget Forecast Awandment
$0 $4,300 $2,154 ($2,146)
12,611 17,650 17,660
9,658 17,997 10,060
20,644 24,270 16,415
2,225 780 2,400
113,694 130,800 101,350
361,609 351,680 361,660
47,569 54,420 80,150
222,725 332,320 225,246
173,230 214,510 174,569
142 6,504 , 6,504
13,521 13,460 13,450
56,074 67,430 52,987
114,742 120,690 124,956
99 320 370
7,116 6,750 6,834
20,587 23,940 22,424
10,579 27,770 8,734
60,612 56,520 55,520
0 0 1,500
175 170 3E9
1,197 1,720 2,057
625,147 703,020 675,096
13,694 15,000 9,355
68,9.16 37,260 59,216
152,809 167,890 159,032
264,496 272,600 269,297
113,995 119,885 125,197
6,676 7,152 16,234
79,450 63,851 65,143
1,182 o 2,364
122,827 99,592 125,053
5,135 7,464 11,645
101,505 109,862 93,574
0 0 6,365
138,709 110,866 150,277
69,384 72,590 66,230
335,127 306,230 260,426
461,226 545,825 493,769
7,027 6,588 6,288
3,628 4,510 3,559
1,020 1,390 1,140
4,480 6,870 4,824
22,740 15,050 23,087
165,075 146,040 155,385
• 0 2,049 45,000
• 244,601 231,370 259,811
210,780 407,944 248,700
195,153 220,970 189,997
6,752 6,240 6,444
2,936 930 2,674
2,094 1,650 2,034
2,760 2,160 1,364
477 360 410
66 0 50
4,642 5,190 7,073
8,643 9,130 12,616
2,114 1,070 0
116,262 98,000 98,000
62,838 95,460 76,243
780 800 1,266
4,421 4,640 7,435
(7,937)
(7,855)
1,620
(29,450)
15,740
(127,072)
(40,021)
0
(14,442)
4,296
0
(1,916)
(1,516)
(19,036)
0
1,500
219
337
(27,924)
(6,645)
21,956
(8,858)
(3,303)
5,312
9,082
2,282
2,354
28,461
4,184
(15,188)
6,366
39,411
(6,360)
(45,804)
(55,056)
(2,300)
(951)
(250)
(2,046)
8,037
10,345
42,951
28,441
(159,244)
(30,973)
204
1,744
384
(796)
50
50
1,883
3,486
(1,070)
0
(19,217)
466
2,795
TOTAL GOVERNMENTAL FUNDS $4,879,397 $5,431,639 $5,037,229 (394,410)
Prepared by Budget Division 29-Nov-93
OAKLAND COUNTY--
ER - DEPgRTMENTAL MEMO
FROM: Fred Poinsett 1
TO: Mr. Jeff Pardee
DATE: November 5, 1993
RE: Miscellaneous Resolution #93135 "Bad Debt" Write Off
Despite numerous attempts to collect, the following amounts are considered to be
uncollectible and are administratively written off by the Chief Fiscal Officer
(below $1,000.00):
-Vendor: Levenson, Disner, Ruby, Fruitman, P.C.,
copies of medical records 2/6/92 4.50
-Vendor: D. Feinberg, Attorney, transportation
charges for a prisoner (deputy cost and
mileage) 11/19/91 212.22
(Note: We are able to off-set these receivables against
payables since these vendors are not our usual vendors.)
-Vendor: Various - as authorized by the Airport Board
miscellaneous landing fees and late charges
deemed uncollectible 350.00
In compliance with resolution, the following requires specific Board action:
-Vendor: Attorney Grievance Commission - transportation
cost, room and board cost and deputy cost for
delivery of an inmate to a hearing. Since charges
were dismissed, State of Michigan Attorney Grievance
Commission denied reimbursement. Date of incident
8/29/91
Details of above are on file in the Accounting Division.
1,784.16
Resolution #93270 December 9, 1993
Moved by McCulloch supported by Kaczmar the resolution be adopted.
AYES: Schmid, Taub, Aaron, Crake, Dingeldey, Douglas, Garfield, Gosling,
Huntoon, Jensen, Johnson, Kaczmar, Kingzett, Law, McCulloch, McPherson, Miltner,
Moffitt, Oaks, Obrecht, Palmer, Pernick, Powers. (23)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on December 9th., 1993 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 of December, 1993
nn D. Allen, County Clerk