HomeMy WebLinkAboutResolutions - 2011.02.17 - 10588MISCELLANEOUS RESOLUTION # 11038 February 17, 2011
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FIRST QUARTER 2011
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS all development cost is incorporated as a single appropriation within the non-
departmental budget and then an amount equal to the actual expense is transferred to the user
department with a summary report to the Finance Committee; and
WHEREAS the Department of Information Technology has determined the First Quarter
2011 development charges to be $829,965.87 and the imaging development charge to be
$12,818.75 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$355,511.91, non-governmental imaging development are $9,767.00, and non-county agencies
are $21,918.50 for the First Quarter 2011; and
WHEREAS an appropriation transfer to General Fund/General Purpose County
departments is needed to fund these development charges.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the First Quarter 9011 Development Report and approves the First
Quarter appropriation transfer as specified on the attached schedule.
BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2011 budgets
are to be amended as specified in the attached detail schedule
FINANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote.
CUST # FUND # ACCOUNT # DIVISION
1st Qtr 2011
Oct - Dec Y.T,D.
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2011
540 101
550 101
560 101
530 101
630 101
005 101
725 101
440 101
724 101
720 101
723 101
522 101
430 101
495 101
483 101
498 101
502 101
493 101
785 101
740 101
660 101
900 101
680 101
872 101
775 101
481 101
510 101
145 101
690 101
637 101
650 101
195 101
GOVERNMENTAL FUNDS
General Fund 11011
10100-3020201-121020-773630
10100-3020301-121020-773630
10100-3020401-121020-773630
10100-3020501-121020-773630
10100-1070801-114000-773630
10100-50'10101-180010-773630
10100-2010201-180000-773630
10100-2010301-185010-773630
10100-2010210-125000-773630
10100-2010401-172190-773630
10100-2010205-132300-773630
10100-1070401-113000-773630
10100-1010501-181020-773630
10100-3010201-121110-773630
10100-3010403-121100-773630
10100-3010301-121130-773630
10100-3010301-121180-773630
10100-3010101-121100-773630
10100-1090101-171000-773630
10100-1020501-173010-773630
10100-1020601-182020-773630
10100-1010115-115090-773630
10100-1050401-183010-773630
10100-1070601-132030-773630
10100-1090201-171000-773630
10100-3040101-121060-773630
10100-3040403-124010-773630
10100-4010101-122050-773630
10100-1020401-182090-773630
10100-1030803-184020-773630
10100-1020650-126020-773630
10100-4030301-112590-773630
52/1 - District Court
52/2 - District Court
52/3 - District Court
52/4 - District Court
Animal Control
Bd of Commissioners
Clerk - Admin
Clerk - Elections
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD-Judicial Support-Admin
Courts-GJ-Judicial Support
Courts-GJ-Jury Operations
Courts - Judical / Administration
Economic Development & Community Affairs
Equalization Division
Fiscal Services - Admin
Homeland Security
Human Resources
Medical Examiner
Planning & Economic Development
Probate-FD Judicial
Probate-Estates/Mental Health Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
$8,802.20 $8,802.20
$8,802.20 $8,802.20
$8,802.20 $8,802.20
$8,802.20 $8,802.20
$8,180.33 $8,180.33
$488.00 $488.00
$5,154.00 $5,154.00
$3,611.50 $3,611.50
$18,995.00 $18,995.00
$2,855.13 $2,855.13
$5,805.33 $5,805.33
$16,420.61 $16,420.61
$1,891.00 $1,891.00
$270.63 $270.63
$667.33 $667.33
$44,141.50 $44,141.50
$541.28 $541.28
$2,441.75 $2,441.75
$3,479.00 $3,479.00
$78,453.57 $78,453.57
$44,811.32 $44,811.32
$305,00 $305.00
$21,769.02 $21,769.02
$9,143.33 $9,143.33
$4,830.00 $4,830.00
$196.00 $196.00
$1,643.33 $1,643.33
$21,529.33 $21,529.33
$7,332.00 $7,332.00
$1,620.00 $1,620.00
$6,148.80 $6,148.80
$65,004.13 $65,004.13
Page 1 of 13 Prepared by, Information Technology; 12/14/2010 BOC Development Billing Report 1st Qtr 2011.xls
1st Qtr 2011
Oct - Dec Y.T.D. DIVISION
Health Fund [221.1
840 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
Juvenile Maintenance Fund f2931
665 293 20293-1060501-112090-773630
63600-1080101-152000-631365
GOVERNMENTAL IMAGING
722 101 10100-2010210-125000-773639
512 101 10100-3040403-124010-773639
63600-1080101-152000-630903
10100-9090101-196030-773630
CAMS/CVT Data Conversion
CAMS/FM° (IT Implementation)
$1,518.00
$41,941.50
$1,518.00
$41,941.50
669
652
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2011
CUST # FUND #
191 101
445 101
600 101
730 101
ACCOUNT #
10100-4030601-110000-773630
10100-1030803-184025-773630
10100-7010101-186040-773630
10100-6010101-155010-773630
Sheriff - CLEM'S
Support Services
Treasurer
Water Resource Commissioner
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
Children's Village
Sub-Total Fund 293
DEVELOPMENT FOR GOVERNMENTAL FUND
APPROPRIATION
Clerk Image
Probate-Estates/Mental Health Image
TOTAL GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
SUB-TOTAL GOVERNMENTAL / IMAGING
DEVELOPMENT APPROPRIATION:
Information Technology Development
TOTAL GOVERNMENTAL:
$2,872.28 $2,872.28
$3,713.26 $3,713.26
$116,511.94 $116,511.94
$34,322.33 $34,322.33
$570,356.83 $570,356.83
$80,063.30 $80,063.30
$174,923.74 $174.923.74
$254,987.04 $254,987.04
$4,622.00 11_622.00
$4,622.00 $4,622.00
$829,965.87 $829,966,87
$7,935.25 $7,935.25
$4,883.50 $4,883.50
$12,818.75 $12,818.75
$842,784.62 $842,784.62
L$842.784.62) ($842.784.62:)
$0.00 $0.00
NON-GOVERNMENTAL
DIRECT CHARGES
Page 2 of 13 Prepared by; Information Technology; 12/14/2010 BOC Development Billing Report 1st Qtr 2011.xls
CUST # FUND # ACCOUNT # DIVISION
1st Qtr 2011
Oct - Dec Y.T.D.
$72,412.97 $72,412.97
$0.00 $0.00
$112,644.50 $112,644.50
$679.00 $679.00
$5,741.50 $5,741.50
$667.33 $667.33
$16,542.83 $16,542.83
$12,092.00 $12,092,00
$74,379_75 $74,379.75
$8,155,75 $8,155.75
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$4,149.28 $4,149.28
$4,048.00 $4,048.00
.$539.50 $539.50
$355,511.91 $355,611.91
$9,767.00 $9,767.00
$9,767.00 $9,767.00
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2011
CLEMIS
CLEMIS FUND 63500
Collaborative Asset Mgt Sys (CAMS)
Commun & Home Improvement
Courts-FOC Exp-CS Enforcement
Fire Records Management System
F M & 0
Health - H1N1 Grant
Parks and Recreation - Administration
P&R Administrative Services
P&R Addison Oaks
P&R Catalpa Oaks
P&R Glen Oaks Golf Course
P&R Highland Oaks
P&R Independence Oaks
P&R Independence Oaks Nature Center
P&R Orion Oaks
P&R Red Oaks Golf Course
P&R Red Oaks VVaterpark
P&R Rose Oaks
P&R Springfield Oaks Activity Center/Park
P&R Springfield Oaks Golf Course
Water & Sewer Accounting
VVinCan Central Storage Solution
VVRO - AMR Support
63600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
NON-GOVERNMENTAL IMAGING
471 Courts-FOC Exp-CS Enforcement Image
63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
055
056
659
661
507
210
750
841
770
761
768
787
762
773
779
767
781
764
789
782
783
765
656
736
734
Page 3 of 13 BOC Development BillIng Report 1st Qtr 2011.xls Prepared by; Information Technology; 12/14/2010
Y.T.D.
1st Qtr 2011
Oct Dec CUST # FUND # ACCOUNT # DIVISION
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
1ST QUARTER 2011
TOTAL COUNTY DEVELOPMENT CHARGES $1,208,063.53 $1,208,063.53
NON-COUNTY AGENCIES
63600-1080101-152000-635017 Non-County Agencies $21,918.50 $21,918.50
TOTAL DEVELOPMENT CHARGES $1,229,982.03 $1,229,982.03
Page 4 of 13 BCC Development Billing Report 1st Qtr 2011.xis Prepared by Information Technology: 12/14/2010
722 CLERK - IMAGING 13001 Clerk - eFiling - 50%
95158 Clerk - Imaging
Clerk - Imaging - Total
$0.00
7,935.25
$7,935.25
$18,995.00
$18,995.00 724 CLERK -LEGAL RECORDS 95189 Circuit Court System
Clerk - Legal Records - Total
723 CLERK - VITAL STATISTICS 24015 SQL Server Stipp - Vital Slats 3.5%
95161 Clerk.Reg - Vital Statistics
Clerk - Vital Statistics - Total
$067.33
5,138.00
$5,805.33
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
cust # GOVERNMENTAL FUNDS
24017 SQL Server Stipp - Animal Control $667.33
95628 Web License Registration 49.00
95682 Dog System 7,464.00
Animal Control-lotal
005 BD OF COMMISSIONERS 91404 BOG - Customer Support $488.00
BOO - Customer Support - 'Total
665 CHILDRENS VILLAGE 95665 Childrens Village $4,622,00
Childrens Village - Total
725 CLERK - ADMIN 72500 Clerk - Admin $5,154.00
Clerk - Admin - Total
440 CLERK - ELECTIONS 95443 Elections $3.611.50
Clerk - Elections - Total
630 ANIMAL CONTROL
$8,180.33
$488.00
$4,622.00
$5,154.00
$3,611.50
720 CLERK !REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support-ROD
36511 ROD Application - HAN Support
95493 Reg Deeds System Maintenance
95498 Clerk/Reg - ROD
Clerk/Reg of Deeds -Total
$109.80
667.33
1,496.00
0,00
122.00
460.00
$2,855.13
930IN:vr..1c.pn-,:mt Ellinn.1-10par's Im Qtr 2011.xts Prepared by iniormntinn Technol•agy, 1211412010 Page 5 of 13
493 CTS-JUDICIAL ADMIN
502 CTS-GJ -JURY OPERATIONS
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT !SUPPORT DETAIL - FIRST QUARTER 2011
522 COMMUNITY„ CORRECTIONS-ADIVIIN {C01 23003 Oracle Support-Comm Corr - 5.2% $541,28
24012 SQL Server Stipp - Community Corr 3.5% 667.33
52200 Comm Corr-Admin (County) 15,212.00
52201 Comm Corr-OW Supp 0-00
Community Corrections - Total $16,420.61
95501 Corporation Counsel v:A91.o0
Corporation Counsel - Total 61,891.00
495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal VVaronouse 50% $0.00
14001 CTS-DVV Support/Circuit Ct - 75% 0.00
15001 CTS-DW MaintiCircuit Ct - 75% 0.00
23010 Oracle Support-CCT/CTS Crim Whse 2.6% 270,63
CTS-Business Division - Total $270.63
430 CORPORATION COUNSEL
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adrn - 3.5% $667.33
95193 CTS-FD-Judicial Support-Adm 0.00
CTS-FD-Judicial Support-Adm - Total $667.33
498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $44.141.50
CTS-Gen Juris-Judicial Suppt - Total $44,141.50
13002 CTS-eFiling - 50% $0.00
95174 CTS-Judicial Admin 2,441.75
CTS-Judicial Adrnin Total $2,441.75
23008 Oracle Support-CTS-GJ-Jury Operations $541,2q
CTS-GJ-Jury Operations - Total $541.28
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $196.50
36501 CEO Application - HMI Support 3,160.50
95785 Comm & Eco Developmt 122,00
Economic Development & Community Affairs - Total $3,479.00
SOS: Developmen, Bilfiro Report_ 1st Co 2011.xls Prepared by h7fora-,F!tion Too.hr-,0-,;;y; 1211412010 Page 6 of 13
$109.80
0_00
0_00
14,637.50
65,316.00
$80,063.39
23001 Oracle Support - Fiscal Sew - 15.6% $1,623.80
23013 Oracle Support - HR-Acctg/Budget - 5.2% 541.28
24006 SQL Serv Supp - HR-Acctg 1.75% 333.74
44021 FS-System/Customer Support 9,995.50
44022 FS-System Maintenance 0-00
44023 FS-System Enhancements 976.00
44024 FS-New Development 0.00
44076 BUD-System/Customer Support 0.00
44077 BUD-System Maintenance 0.00
44079 FS - OW Support 0.90
44081 FS - OW Maintenance 0.00
96001 Human Res - Acct 40% 20,894.00
06003 Human Res - Budget 20% 10.447.0Q
Fiscal Services Admin - Total
660 FISCAL SERVICES ADIVIIN
S44,811.32
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
740 EQUALIZATION
840 HEALTH DIVISION
20001 IDMS Support-Equalization 40%
23012 Oracle Support-Equalization - 5.2%
24005 SQL Server Supp-Equalization - 10.5%
31075 Equal - Development
36505 GIS Implementation Support Equalization
36506 Equal Application - HM/ Support
36507 Equal LAMS Support/Mtce
36601 Land System Enhancements - Equal (50%)
36701 Land System Maintenance - Equal (50%)
36801 Land System Support - Equal (50%)
36902 BS&A Orion Tvvp - Equal (50%)
36912 BS&A Madison Heights - Equal (50%)
95559 User Support! Equal
95562 Equalization - DVV Support
95570 Equalization - DVV Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal SupiMaint
Equalization - Total
20002 IDMS Support - CHAMPS - 20%
36525 GIS Implementation Support Health
37025 CHAMPS - P.O.P.
95563 User Support-Health
96842 Health Admin
Health - Total
$219.60
541.28
2,001.81
5,474.00
2,197.50
9,222.50
0.00
78.00
1,492.00
7,933.63
0.00
0.00
0.00
7,807.00
162.00
0,00
41,32425
$78,453.57
Prepared by: Informotion .rebhr,blny: 7.2/14/2015 BCC; Dcv0cemcnI BI. R ,aport 10 Qlr 2011,51$ Page 7 of 13
481 PROB-FD JUDICIAL
PROB-ESTATES/MENTL HLT
510 PROB-ESTATES/MENTL HLTH SUPPORT
512 AGE
$174,923,74
$305.00
$21,769.02
$9,143.33
$4,830.00
$196.00
$4.883.50
$1,643.33
521.529,33
INFORMATION TECHNOLOGY.. RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
843 HEALTH - ENVIRONMENTAL
900 HOMELAND SECURITY
680 HUMAN RESOURCES
872 MEDICAL EXAMINER
775 PLANNING & ECONOMIC DEVELOPMENT
145 PROSECUTOR - GENERAL PROSECUTION
23005 Oracle Support - EH Projects - 5.2% $541.28
24014 SQL Server Suppt - Ehealth 14% 2,668.96
37002 Environmental 0.00
84200 EH - Projects 163,632.00
84300 Ehealth Program 8081.50
Health-Environmental - Total
36545 GIS Implementation Support Homeland Security $61.00
36546 Homeland Security Application -1-I/VV Support 244.00
95479 Homeland Security Customer Support 0.00
98990 Homeland Security 0.00
Homeland Security - Total
23014 Oracle Support-FIR/Personnel - 5.2% $541.28
24007 SQL Server Suppport-HR/Personnel - 1.75% 333.74
44041 PER-System/Customer Support 0.00
44042 HR-Systems Maintenance 0.00
44044 HR-New Development 0.00
95556 HR User Suet 0.00
96002 Human Res-Personnel 40% 20,894.00
Human Resources - Total
24002 SQL Server Support - Medical Exam - 3.5% $667.33
87202 Medical Examiner - Customer Support 8,476.00
Medical Examiner - Total
95600 REDS-Customer/System Support $4,830.00
95786 PEDS - DIN Support 0.00
95787 REDS DW Maintenance 0.00
REDS - Total
95168 PC - Judicial Admin - Family $196.00
PC - Judicial Admin - Family - Total
95207 Prob.Est/Mntl Hlth Image $4,863.50
Prob-Est/Mnt1 Filth Image - Total
24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $667.33
92198 Prob-Est/MnIIHIth Support 97QPP
Prob-Est/Mntl Hlth Support - Total
24016 SQL Server Supp - Proescutors 3.5% $567.33
95622 Prosecutor/Executive 5,856.00
97001 Prosecutor Data Proc 15,006.00
Prosecutor - Total
HOC Devepment Report lst atr 2011.xjs Prepare,jbyInforilat,c,n Tec.hnotogy: 12114/2010 Page 8 of 13
690 PURCHASING
637 RECORDS RETENTION
$541.28
2,331.00
$6,148.80
$65,004.13
$2,872.25
$541.28
1,334.48
1,837.50
$3,713.26
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL. - FIRST QUARTER 2011
$7,332.00
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
95663 Purchasing
Purchasing - Total
95469 Reimbursement Division
95470 Reimbursement System
95542 Reimburse 1.1sor Support
Reimbursement - Total
23002 Oracle Support - Supp Ser./ - 5.2%
24011 SQL Server Supp - Suppt Services 7%
44500 Support Services
Support Services - Total
$7,332.00
$1,620.00
$0.00
3,806.40
2.342,40
$0.00
270.63
56,951.00
7,782.50
0.00
44052 Pee-System Maintenance $0.00
44053 Rec-System Enhancements 1,520.00
44054 Pee-New Development 0.00
95636 Mail Room 0.00
Records Retention - Total
12001 OCSD-Cour Is/Criminal Warehouse
23009 Oracle Suppport OCSD/CTS Grim Whse - 2.6%
97163 Sheriff
97165 Sheriff-OW Support
97166 Sheiiff-OW Maintenance
Sheriff - Total
191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff! OLEMIS - 5.2%
96163 Sheriff - CLEMIS
n-•—• Sheriff - CLE1v1IS - Total
Boc Dv p91 CH 'p P.ep,..,rt Is Qtr 2011.x9a F,,eva.,ect • •••.••••• 12/14/2C10 Page 9 of 13
23006 Oracle Support Del Tax - 5.2% $541.28
23016 Oracle Support - Treasurer 10.4% 1,082.54
36515 GIS Implementation Support-Treasurer 0.00
36516 Treasurer Application - HAN Support 6,954.00
36602 Land System Enhancements - Treas (50%) 78.00
36702 Land System Maintenance - Trees (50%) 1,492.00
36802 Land System Support - Trees (50%) 7,933.62
44061 Tre-System/Customer Support 15,605.75
44062 Tre-System Maintenance 2,553.00
44063 Tre-System Enhancements 978.00
44064 Tre-New Development 1,104.00
44080 Tre-DVV Support 18,410.50
44082 Tre-DVV Maintenance 486.00
95008 Del Tax On Line 244.00
95303 Del Tax System Maintenance 7,382.50
95561 User Support/Del Tax 16,946.50
95615 BS&A Annual Tax Support 21720.25
Treasurer - Total
600 TREASURER
$116,511.94
730 WATER RESOURCE COMMISStONER 24008 SQL Server Supp - WRC 3.5% $667,33
28007 Water Resource Commissioner 0.00
28010 VVRC - Customer Support 5,337.50
28011 Water Resource Commissioner Application 10,492.50
36520 GIS Implementation Support WRC 8,599.00
36521 WRC Application - H/VV Support 9,226.00
Water Resource Commissioner - Total $34,322.33
540 52t1 DISTRICT COURT NOVI
550 5212 DISTRICT COURT - CLARKSTON
$0.00
0.00
8,802,20
$8,802.20
$0.00
0.00
8,802.20
$8,802.20
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
14002 CTS-DW Support-52/1 - 6.25%
15002 CTS-DVV Maint 52/1 - 6.25%
95527 QC Suprt- 5211 - 25%
52/1 District Court. Total
14003 CTS-DW Support-5212 - 6.25%
15003 CTS-DW Maint 5212- 6.25%
95528 DC Suprt- 52/2 - 25%
52/2 District Court - Total
130C DevelopmeA1 Pang Ropczt 1s1 Qtr 2611.xls prepared by: Info— c! ...11-4r2010 Page 10 of 13
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2011
560 5213 DISTRICT COURT - ROCHESTER
530 52/4 DISTRICT COURT - TROY
14004 CTS-DVV Support-52/3 - 6,25%
15004 CTS-OW Maint 52/3 - 6.25%
95529 DC Suprt - 52/3 - 25%
52/3 District Court - Total
14005 CTS-DVV Support-52/4 - 6.25%
15005 CTS-OW Maint 52/4 - 6,25%
95530 DC Suprt- 52/4- 25%
52/4 District Court - Total
$0.00
0.00
8,802.20
80.00
0.00
8,802.20
$8,802.20
$8,802.20
Prepared by: inforrndbon Technoldy; 12/14/2010 110C Dev,-...loprndnt Ming Repod 151 QV 201 -1.xi.s Page 11 of 13
Gust* DIRECT FUNDS
055 CLEM
056 CLEMIS FUNO S3Soq
669 cAmsicvr DATA CONVERSION
652 CAMS/FM0 IT IMPLEM, NTA 0
659 COLLABORATIVE ASSET MGT SYS
661 COIVIMUN & HOME IMPROVEMENT
471 CTS-FOC-EXP-CS ENFORC-IMAGE
507 CTS-FOC EXP-CS ENFORCEMENT
210 FIRE RECORDS MANAGEMENT SYSTEM $0.00
667.33
$667,33
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
20003 IDMS Support - 5.6% $109.80
23004 Oracle Support - OakVideo CLEWS 5.2% $541.28
23018 Oracle Support - Sheriff CLEMIS 5.2% 541.12
24004 SQL Server Support - 24.5% 4,670.77
90507 CAD Customer Support 0.00
90510 C LEMIS - OakVideo Support 34,020.00
95409 CRISNET/CLEMIS LRM 0.00
95410 CRISNET/CLEMIS LRMS 14,335.00
95411 CLEMIS LRMS UASI (NR) 14,884.00
95430 CLEMIS Maintenance 1,786.00
95431 CLEMIS Enhancements 1,281.00
95432 CLEMIS Adhoc Reports 0.00
98003 CLEMIS User Support 244.00
CLEMIS - Total $72,412.97
63500 CLEMIS Fund $0.00
CLEWS 63500 Fund - Total $0.00
66901 CAMS/CVT Data Conversion $1,516.00
CAMS/CVT Data Conversion - Total $1,518.00
65200 CAMS/FM° (IT Implementation) $41,941.50
CAMS/FMO (IT Implementation) - Total $41,941.50
65901 Collabortive Asset Mgt Sys $112,644.50
Collabortive Asset Mgt Sys - Total $112,644.50
66103 Comm Dev User Support $679.00
Common & Home Improvement - Total $679.00
92194 CTS-FOC-Exp-CS Enf-Image $9,757.00
CTS-FOC Exp-CS Enf-Image - Total $9,767.00
92193 CTS-FOC Exp-CD Enforc-Dev $5,741.50
CTS-FOC Exp-CD Enterc-Dev - Total $5,741.50
21010 Fire Records Mgmt Fund 531
24001 SQL Server Support. FRMS 3.5%
Fire Records Management System Total
Prapared by IriforrnntiOn Isc1'e.ioirlg-y: 12/14/2010 BOG Devehprn€;nt Bi.ling Report 151 (lir 2011.xls Page 12 of 13
750 FM&O
841 HEALTH - H1N1 GRANT
770 PARKS AND RECREATION
761 P&R ADMINISTRATIVE SERVICES
656 WATER & SEWER ACCTG
736 WINCAN CENTRAL STORAGE SOLUT
$1,083.00
667.33
14,792.50
$12,092.00
$3,350.00
1,477.00
0.00
0.00
0.00
0.00
8,490.00
156.00
3,536.75
906.25
48,271.75
0.00
8,192.00
$8,155.75
$541.28
3,608.00
$4,048.00
$539.50
$16,542.83
$12,092.00
$74,379.75
$8,155.75
$4,149.28
$4,048.00
$539.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2011
21001 FM&O
24013 SQL Server Supp - FM&O
75503 FM&O Development
FM&O - Total
84100 Health - H1N1 Grant
Health - H1N1 Grant - Total
36530 GIS Implementation Support - Parks
44066 PRADM-Systern/Customer Support
44068 PRADM-System Enhancements
77010 PRADM-Technology Assessment
77100 Yr 1 - Program Management
77110 Yr 1 - Asset Theme Development
77120 Yr 1 - Network Connectivity
77130 Yr 1 - Hardware Refresh
77140 Yr 1 - Point of Sale System
77200 Yr 2 Program Management
77220 Yr 2 - Asset Mgmt Implementation
77230 Yr 2 - Customer Info Mgmt Implementation
95419 PRADM-Administration
Parks & Recreation - Total
76100 P&R Administrative Services
P&R Administrative Services - Total
23011 Oracle Supp - Water & Sewer Acorg - 52%
95669 VValer & Sewer Accfg
Water & Sewer Accfg - Total
73601 WinCen Central Storage Solution
Winean Central Storage Solution - Total
734 WRC - AMR SUPPORT 73401 VVRC - AMR Support
WRC - AMR Support - Total
Prepared by: Informatien Techedlogy; 12/14/2010 HOC Development BitHbo Report 1st Qtr 2011.xls Page 13 of 13
Resolution #11038 February 17, 2011
Moved by Middleton supported by Gershenson the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Crawford, Dwyer, Gershenson, Gingell, Gosselin, Greimel, Hatchett, Hoffman, Jackson,
Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, Runestad, Scott, Taub,
Weipert, Zack, Bosnic, Covey. (24)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
I HEREBY APPROVE THE FOREGOING RESOLUTION
ACTING PLRSUANT TO 1973 PA 139
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Bill Bullard Jr., 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 February
17, 2011, 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 17th day of February, 2011.
E,LL2_ (9,1.
Bill Bullard Jr., Oakland County