HomeMy WebLinkAboutResolutions - 1994.01.06 - 24088January 6, 1994
MISCELLANEOUS RESOLUTION 194002
BY: FINANCE COMMITTEE, JOHN P. MCCULLOCH, CHAIRPERSON
IN RE: COMPUTER SERVICES - OFFICE AUTOMATION/PERSONAL COMPUTING
PROJECTS
To the Oakland County Board of Commissioners
Chairperson, Ladies, and Gentlemen:
WHEREAS the Department of Computer Services is requesting
approval for 17 specific projects affecting twelve different
divisions; and
WHEREAS two projects require no additional funding, which are
for the Community Development Grant and the Drain Commissioner
enterprise funds; and
WHEREAS funding is requested for the remaining 15 projects,
which total $180,019 in capital costs and $40,358 in one-time
costs; and
WHEREAS additional start-up costs estimated at $33,100 will be
provided by Computer Services staff for training and installation,
which requires no additional funding; and
WHEREAS annual operating costs are-estimated to be $69,931 for
maintenance and depreciation; and
WHEREAS a loan is requested from the Delinquent Tax Revolving
Fund (DTRF) in the amount of $180,019 for the initial investment to
be repaid over a five-year period; and
WHEREAS interest expense is estimated to be $7,951 for 1994
and $6,151 for 1995; and
WHEREAS there are sufficient funds available in the 1994/95
Print Shop budget to absorb the one-time costs and annual operating
expense for its specified project; and
WHEREAS funds for the one-time initial costs, annual operating
costs, and interest expense for the remaining projects are
available in the non-departmental reserve account for office
automation; and
WHEREAS there is $161,277 remaining in the 1993 non-
departmental reserve account for office automation that is
requested to be carried forward into the 1994 Budget.
NOW THEREFORE BE IT FURTHER RESOLVED that the Oakland County
Board of Commissioners authorizes the Chairperson of the Board to
execute the attached Borrowing Agreement in the amount of $180,019
with the County Treasurer as agent of the DTRF.
BE IT FURTHER RESOLVED that principal and interest payments
made to the DTRF in repayment of this agreement will be accounted
for in the Computer Services Operations Fund, fund #63600.
BE IT FURTHER RESOLVED that the funds remaining in the 1993
non-departmental reserve account for office automation be carried
forward into the 1994 Budget and incorporated into the 1993
Year-end Report and Budget Amendments resolution.
1994 1995
$(116,765)
55,653
2,108
556
515
19,540
18,266
6,231
3,147
10,749
0
$(75,105)
38,473
2,108
60
84
4,480
13,674
4,619
2,281
9,326
$ 0
BE IT FURTHER RESOLVED that the 1994/1995 Biennial Budget is
amended as follows:
Governmental Funds
Expenditures
10100-909-01-00-9920 Office Automation
Allocation:
10100-181-01-00-6360 Computer Services
10100-111-05-00-6360 County Executive
52100-163-01-00-6360 Medical Care Fac.
22100-141-30-00-6360 EMS
10100 -148-01-00 -6360 Facilities Eng.
10100-433-10 -00-6360 Sheriff
10100 -411-01-00-6360 Prosecutor
10100-311-01-00-6360 Jury Clerk
10100-511-01-00-6360 Board of Comm.
TOTAL
Computer Services Fund (63600)
Revenue
181-01-00-2037 Gov't. Operations $ 116,765 $ 75,105
181-01-00-2355 Non-gov't. Operations 10,680 3,564
Subtotal $ 127,445 $ 78,669
Expense
184-01-00-3304 Depreciation $ 45,644 $ 45,644
184-01-00-3342 Maintenance 26,874 26,874
184-01-00-3418 Interest Expense 7,951 6,151
184-01-00-3701 Software 46,976 0
Subtotal $ 127,445 $ 78,669
TOTAL
Chairperson, on behalf of the Finance committee, I move the
adoption of the foregoing resolution.
FINANCE OMMITTEE
t , ,
REVOLVING FUND BORROWINGAGREEMENT
WHEREAS the County of Oakland is desirous of borrowing monies
from the Oakland County Delinquent Tax Revolving Fund, and
WHEREAS the Delinquent Tax Revolving Fund Agent has determined
sufficient monies are available to loan to the County,
THEREFORE, in consideration of agreements setforth below it is
hereby agreed by and between the parties as follows:
The County will borrow the principal sum of $180,019 from the
Delinquent Tax Revolving Fund to be paid back in annual
principal and interest payments not to exceed five (5) years.
Said payments shall be deducted from the annual Revolving Fund
distribution made to the County on or about June 1st of each
year. Interest on each payment will be based on the average
monthly rate paid during the term of this agreement by the
agent of the Delinquent Tax Revolving Fund for that year's
outstanding borrowing. The schedule of principal payments
will be:
Year Principal
1 $ 36,004
2 36,004
3 36,004
4 36,004
5 36,003
Total $ 180,019
It is further agreed that the County may pay off the loan at
any time plus accrued interest without penalty.
Agent for Revolving Fund Chairperson
Board of Commissioners
F
FINANCIAL ANALYSIS
OFFICE AUTOMATION PROJECTS
CAPITAL ONE-TIME START-UP ANNUAL OPERATING EXPENSE
COST EXPENSE COSTS* MAINT. DEPR. TOTAL
PROJECTS REQUIRING NO
ADDITIONAL FUNDING
Community Development Grant $16,190 $6,278 $3,080 $1,644 $0 $1,644
Drain Commissioner 2,520 340 240 312 631 943
GRAND TOTAL $18,710 $6,618 $3,320 $1,956 $631 $2,587
PROJECTS REQUIRING FUNDING
Print Shop $2,801 $498 $700 $276 $701 $977
Computer Services: -
Tech. Support 17,850 4,583 4,810 2,700 4,463 7,163
Training Services 27,300 1,690 3,120 3,588 6,825 10,413
Systems Development 38,247 9,107 5,330 5,184 9,562 14,746
Subtotal 83,397 15,380 13,280 11,472 20,850 32,322
County Executive 5,000 0 50 858 1,250 2,108
Medical s....pre Facility 0 496 40 60 0 60
EMS - Disaster Control 0 431 50 84 0 84
Facilities Engineering 12,830 15,060 3,900 1,272 3,208 4,480
Sheriff:
Records Unit 2,909 130 440 420 728 1,148
Administration 20,814 3,031 4,990 3,096 5,204 8,300
Traffic Unit 3,159 295 520 480 791 1,271
Dispatch 8,166 1,136 1,580 912 2,043 2,955
Subtotal 35,048 4,592 7,530 4,908 8,766 13,674
Prosecuting Attorney 11,850 1,612 2,020 1,656 2,963 4,619
Circuit Court-Jury Clerk 5,809 866 1,370 828 1,453 2,281
Board of Commissioners 23,284 1,423 4,160 3,504 5,822 9,326
GRAND SUBTOTAL $180,019 $40,358 $33,100 $24,918 $45,013 $69,931
Start-up costs arc estimated for training and installation, which are
provided by Computer Services and require no additional funding.
Prepared by Budget Division-LV I5-Dec-93
Prepared by Budget Division-IN I5-Dec-93
DTRF LOAN REPAYMENT
Principal Estimated
Payment interest** Balance
$180,019
1994 36,004 7,951 144,015
1995 36,004 6,151 108,011
1996 36,004 4,350 72,007
1997 36,004 2,550 36,003
1998 36,003 750 0
TOTAL $180,019 $21,752
•*Interest is calculated based on one principal payment made on June 1 of each year compounded at
5% annually. The actual rate will be determined annually based on the average monthly rate that
is paid by the DTRF, which currently is approximately 3.4%.
:REB PROVE E FOREGOING RESOLUTION
,... I-10-7e(
rooks PAtierson, County Executive Date
Resolution #94002 January 6, 1994
Moved by McCulloch supported by Powers the resolution be adopted.
Moved by Gosling supported by Wolf the resolution be amended to add the
following paragraph:
BE IT FURTHER RESOLVED that future submissions for approval of office
automation requests requires a review and recommendation from the Department of
Management and Budget prior to presentation to the Finance Committee.
A sufficient majority having voted therefor, the amendment carried.
Vote on resolution as amended:
AYES: Gosling, Huntoon, Jensen, Johnson, Kaczmar, Kingzett, Law,
McCulloch, McPherson, Miltner, Moffitt, Obrecht, Palmer, Pernick, Powers, Price,
Schmid, Taub, Wolf, Crake, Dingeldey, Douglas, Garfield. (23)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution, as amended,
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 January 6, 1994 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 6th day of lauary 1994.