HomeMy WebLinkAboutResolutions - 2011.05.19 - 18267May 19, 2011
MISCELLANEOUS RESOLUTION #11098
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND 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 Second
Quarter 2011 development charges to be $766,463.00 and the imaging development charge to
be $17,065.25 for the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$375,412.26, non-governmental imaging development are $10,320.20, and non-county agencies
are $14,092.50 for the Second 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 Second Quarter 2011 Development Report and approves the
Second 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 Vote:
Motion carried unanimously on a roll call vote with Crawford absent
CUST # FUND # ACCOUNT # DIVISION
1st Qtr 2011
Oct - Dec
2nd Qtr 2011
Jan - Mar Y.T.D.
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2011
540 101
550 101
560 101
530 101
630 101
005 101
725 101
440 101
410 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
163 101
775 101
481 101
510 101
145 101
690 101
637 101
650 101
195 101
191 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-5010101-180010-773630
10100-2010201-180000-773630
10100-2010301-185010-773630
10100-2010501-125000-773630
10100-2010210-125000-773630
10100-2010401-172190-773630
10100-201 0205-1 32300-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-4030901-115140-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
10100-4030601-110000-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 - Jury Commission
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 - Adnnin
Homeland Security
Human Resources
Medical Examiner
OCSO - CLEMIS Forensic Lab IMS
Planning & Economic Development
Probate-FD Judicial
Probate-Estates/Mental Health Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
$8,802.20 $9,060.99 $17,863.19
$8,802,20 $9,060.99 $17,863.19
$8,802.20 $9,060.99 $17,863.19
$8,802.20 $9,060.93 $17,863.13
$8,180.33 $13,409.86 $21,590.19
$488.00 $427.00 $915.00
$5,154.00 $0.00 $5,154.00
$3,611.50 $9,962.00 $13,573.50
$0.00 $122.00 $122.00
$18,995.00 $13,944.00 $32,939.00
$2,855.13 $2,664.86 $5,519.99
$5,805.33 $4,020.36 $9,825.69
$16,420.61 $19,632.62 $36,053.23
$1,891.00 $915.00 $2,806.00
$270.63 $408.12 $678.75
$667.33 $438.36 $1,105.69
$44,141.50 $50,040.00 $94,181.50
$541.28 $572.26 $1,113.54
$2,441.75 $2,580.05 $5,021.80
$3,479.00 $4,753.00 $8,232.00
$78,453.57 $88,956.69 $167,410.26
$44,811.32 $50,462.63 $95,273.95
$305.00 $5,076.50 $5,381.50
$21,769.02 $28,375.06 $50,144.08
$9,143.33 $5,380.36 $14,523.69
$0.00 $457.50 $457.50
$4,830.00 $5,192.00 $10,022.00
$196.00 $0.00 $196.00
$1,643.33 $2,329.36 $3,972.69
$21,529.33 $46,602.66 $68,131.99
$7,332.00 $7,474.00 $14,806.00
$1,620.00 $0.00 $1,620.00
$6,148.80 $549.00 $6,697.80
$65,004.13 $84,075.12 $149,079.25
$2,872.28 $2,671.26 $5,543.54
BOC Development Billing Report 2nd Qtr 2011 Page 1 Prepared by Information Technology; March 17, 2011
CUST # FUND #
445 101
600 101
730 101
ACCOUNT #
10100-1030803-184025-773630
10100-7010101-186040-773630
10100-6010101-155010-773630
Health Fund [2211
840 221 20221-1060201-133150-773630
843 221 20221-1060220-134390-773630
Juvenile Maintenance Fund [293)
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
1st Qtr 2011 2nd Qtr 2011
Oct - Dec Jan - Mar
$3,713.26 $2,232.81
$116,511.94 $79,192.96
$34,322.33 $41,196.86
$570,356.83 $610,358.16
Y.T.D.
$5,946.07
$195,704.90
$75,519.19
$1,180,714.99
$128,843.80
$272,047.08
$400,890.88
$14,823.00
$14,823.00
$829,965.87 $766,463.00 $1,596,428.87
$80,063.30 $48,780.50
$174,923.74 $97,123.34
$254,987.04 $145,903.84
$4,622.00 $10,201.00
$4,622.00 $10,201.00
$7,935.25 $11,905.15
$4,883.50 $5,160.10
$12,818.75 $17,065.25
$19,840.40
$10,043.60
$29,884.00
$342,784.62 $783,528.25 $1,626,312.87
::2184,6,21
1'83,528.25) •12.87)
$0.00 $0.00 $0.00
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2011
DIVISION
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:
669
652
055
056
659
661
NON-GOVERNMENTAL
DIRECT CHARGES
CAMS/CVT Data Conversion
CAMS/FMO (IT Implementation)
CLEMIS
CL.EMIS FUND 63500
Collaborative Asset Mgt Sys (CAMS)
Commun & Home Improvement
$1,518.00 $930,00 $2,448.00
$41,941.50 $59,973.00 $101,914.50
$72,412.97 $96,969.53 $169,377.50
$0.00 $0.00 $0.00
$112,644.50 $109,472.25 $222,116.75
$679.00 $97.50 $776.50
Prepared by Information Technology; March 11,2011 Page 2 BOG Development Billing Report 2nd Qtr 2011
CUST # FUND #
507
210
750
841
770
761
768
787
762
773
779
767
781
764
789
782
783
765
695
656
736
734
ACCOUNT #
63600-1080101-152000-631302
NON-GOVERNMENTAL IMAGING
63600-1080101-15200-630903
NON-COUNTY AGENCIES
63600-1 0801 01 -1 52000-635017
Prepared by Information Technology; March 17, 2011
471
1st Qtr 2011
Oct - Dec
$5,741.50
$667.33
$16,542.83
$12,092.00
$74,379.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
$4,149.28
$4,048.00
$539.50
1355,511.91
$9,767.00
$9,767.00
2nd Qtr 2011
Jan - Mar
$5,581.50
$682.36
$935.86
($12„092.00)
$105,758.50
$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
$915.00
$5,010,76
$962.00
$221.00
$375,412.26
$10,320.20
$10,320.20
Y.T.D,
$11,323.00
$1,349.69
$17,478.69
$0.00
$180,138.25
$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
$9,160.04
$5,010.00
$760.50
$730,924.17
$20,087.20
$20,087.20
$21,918.50 $14,092.50 $36,011.00
$1,229,982.03 $1,183,353.21 $2,413,335.24
BOG Development Billing Report 2nd Qtr 2011
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
2ND QUARTER 2011
DIVISION
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 Waterpark
P&R Rose Oaks
P&R Springfield Oaks Activity Center/Park
P&R Springfield Oaks Golf Course
Risk Management
Water & Sewer Accounting
WinCan Central Storage Solution
WRC - AMR Support
SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT
Courts-FOC Exp-CS Enforcement Image
TOTAL NON-GOVERNMENTAL IMAGING
DEVELOPMENT APPROPRIATION
TOTAL COUNTY DEVELOPMENT CHARGES
Non-County Agencies
TOTAL DEVELOPMENT CHARGES
Page 3
11,208,063.53 $1,169,260.71 $2,377,324.24
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
$438.36
2,007.50
10,964.00
$427.00
$10,201.00
$0.00
$9,962.00
$0.00
438.36
274.50
1,708.00
122.00
122.00
$0.00
11 905.15
$122.00
$13,944.00
$438.36
3582.00
$4,020.36
$13,409.86
$427.00
$10,201.00
$0.00
$9,962.00
$266486
$11,905.15
$122.00
$13,944.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control
95628 Web License Registration
95682 Dog System
Animal Control-Total
005 BD OF COMMISSIONER , BOC - Customer Support
BOC - Customer Support - Total
665 CHILDRENS VILLAGE 95665 Childrens Village
Childrens Village - Total
725 CLERK - ADMIN 72500 Clerk - Admin
Clerk - Admin - Total
440 CLERK - ELECTIONS 95443 Elections
Clerk - Elections - Total
720 CLERK! REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds 20%
24003 SQL Server Supp - ROD 3.5%
36510 GIS Implementation Support-ROD
36511 ROD Application - HNV Support
95493 Reg Deeds System Maintenance
95498 Clerk/Reg - ROD
Clerk/Reg of Deeds - Total
13001 Clerk - eFiling - 50%
95158 Clerk - Imaging
Clerk - Imaging - Total
95512 Clerk/Reg - Jury Commission
Clerk/Reg - Jury Commission - Total
95189 Circuit Court System
Clerk - Legal Records - Total
24015 SQL Server Supp - Vital Stets 3.5%
95161 Clerk Reg - Vital Statistics
Clerk - Vital Statistics - Total
Prepared by Information Technology; March 17, 2011 Page 4 BOC Development Billing Report 2nd Qtr 2011
$122.00
0.00
0.00
286.12
$408.12
$438.36
0.00
$438.36
$0.00
2,580.05
$2,580.05
493 CTS-JUDICIAL ADMIN 13002 CTS-eFiling - 50%
95174 CTS-Judicial Admin
CTS-Judicial Admin - Total
$312.00
4, 1.00
0.00
$4,753.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
522 COMMUNITY CORRECTIONS-ADMIN (CO)
430 CORPORATION COUNSEL
23003 Oracle Support-Comm Corr - 5.2% $572.26
24012 SQL Server Supp - Community Corr 3.5% 438.36
52200 Comm Corr-Admin (County) 18,622.00
52201 Comm Corr-DW Supp 0.00
Community Corrections - Total $19,632.62
95501 Corporation Counsel $915.00
Corporation Counsel - Total $915.00
495 CTS-BUSINESS DIVISION
483 CTS-FD-JUDICIAL SUPPORT-ADM
498 CTS-GEN JURIS-JUDICIAL SUPPT
12002 Circuit Ct-Courts/Criminal Warehouse 50%
14001 CTS-DW Support/Circuit Ct - 75%
15001 CTS-DW MainUCircuit Ct 75%
23010 Oracle Support-CCT/CTS Grim Whse 2.6%
CTS-Business Division - Total
24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%
95193 CTS-FD-Judicial Support-Adm
CTS-FD-Judicial Support-Mm - Total
95179 CTS-Gen Juris-Judicial Suppt $50,040.00
CTS-Gen Juris-Judicial Suppt - Total $50,040.00
502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations
CTS-GJ-Jury Operations - Total $572.26
$572.26
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev
36501 CEO Application - HMI Support
95785 Comm 8, Eco Developmt
Economic Development & Community Affairs - Total
Prepared by Information Technology; March 17, 2011 Page 5 BOC Development Billing Report 2nd Qtr 2011
$0.00
572.26
1,314.91
9,041.00
1,099.00
38,096.77
0.00
3,104.00
730.50
2,600.75
0.00
0.00
0.00
5,436.00
367.50
0.00
26,594.00
$1,716.77
572.26
219.20
5,823.00
0.00
756.00
0,00
0.00
0.00
0.00
0.00
27,583.60
13,791.80
$0.00
0.00
0.00
21,261.00
27,519.50
$88,956.69
$50,462.63
$48,780.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
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 ='[2nd Qtr 2011.xls]lst Qtr DetaillR[202]C[2]
36506 Equal Application - H/W Support
36507 Equal LAMS Support/Mice
36601 Land System Enhancements - Equal (50%)
36701 Land System Maintenance - Equal (50%)
36801 Land System Support - Equal (50%)
36902 BS&A Orion Twp - Equal (50%)
36912 BS&A Madison Heights - Equal (50%)
95559 User Support/Equal
95562 Equalization - DW Support
95570 Equalization - OW Maintenance
95693 Equal-System Maintenance
95699 BS&A Master Appraisal Sup/Maint
Equalization - Total
23001 Oracle Support - Fiscal Serv - 15.6%
23013 Oracle Support - HR-Acctg/Budget - 5.2%
24006 SQL Serv Supp HR-Acctg - 1.75%
44021 FS-System/Customer Support
44022 FS-System Maintenance
44023 FS-System Enhancements
44024 FS-New Development
44076 BUD-System/Customer Support
44077 BUD-System Maintenance
44079 FS - DW Support
44081 FS - DW Maintenance
96001 Human Res - Acct 40%
96003 Human Res - Budget 20%
Fiscal Services Admin - 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
Prepared by Information Technology; March 17, 2011 Page 6 BOC Development Billing Report 2nd Qtr 2011
23005 Oracle Support - EH Projects - 5.2%
24014 SQL Server Suppt - Ehealth 14%
37002 Environmental
84200 EH - Projects
84300 Ehealth Program
Health-Environmental - Total
36545 GIS Implementation Support Homeland Security
36546 Homeland Security Application H/VV Support
95479 Homeland Security Customer Support
98990 Homeland Security
Homeland Security - Total
23014 Oracle Support-HR/Personnel - 5.2%
24007 SQL Server Suppport-HR/Personnel - 1.75%
44041 PER-System/Customer Support
44042 HR-Systems Maintenance
44044 HR-New Development
95556 HR User Supt
96002 Human Res-Personnel 40%
Human Resources - Total
24002 SQL Server Support - Medical Exam - 3.5%
87202 Medical Examiner - Customer Support
Medical Examiner - Total
843 HEALTH - ENVIRONMENTAL
900 HOMELAND SECURITY
680 HUMAN RESOURCES
872 MEDICAL EXAMINER
163 OCSO-CLEMIS FORENSIC LAB IMS 16300 OCSO CLEMIS Forensic Lab
OCSO CLEMIS Forensic Lab IMS - Total
775 PLANNING & ECONOMIC DEVELOPMENT
481 PROB-FD JUDICIAL
512 PROB-ESTATES/MENTL HLTH IMAGE
510 PROB-ESTATES/MENTL HLTH SUPPORT
95600 PEDS-Customer/Systern Support
95786 PEDS - OW Support
95787 PEDS - DW Maintenance
PEDS - Total
95168 PC - Judicial Admin - Family
PC - Judicial Admin - Family - Total
95207 Prob-Est/Mntl Hlth Image
Prob-Est/Mntl Hlth Image - Total
24010 SQL Serv Supp-PCT-Est/Mental - 3.5%
92198 Prob-Est/Mntl Hlth Support
Prob-Est/Mntl Hlth Support - Total
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
$572.26
1,753.08
0.00
91,935.00
2,863.00
$4,430.00
646.50
0.00
0.00
$572.26
219.20
0.00
0.00
0.00
0.00
27,583.60
$438.36
4,942.00
$457.50
$5,19100
0.00
0.00
$0.00
$5,160.10
$438.36
1,891.00
$97,123.34
$5,076.50
$28,375.06
$5,380.36
$457.50
$5,192.00
$0.00
$5,160_10
$2,329.36
Prepared by Information Technology; March 17, 2011 Page 7 BOC Development Billing Report 2nd Qtr 2011
145 PROSECUTOR - GENERAL PROSECUTION
690 PURCHASING
637 RECORDS RETENTION
650 REIMBURSEMENT
195 SHERIFF
191 SHERIFF - CLEMIS
445 SUPPORT SERVICES
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
24016 SQL Server Supp - Proescutors 3.5% $438.36
95622 Prosecutor/Executive 6,954.00
97001 Prosecutor Data Proc 39,210.30
Prosecutor - Total
95663 Purchasing $0.00
44028 Purchasing System Enhancements 7,474.00
Purchasing - Total
44052 Rec-System Maintenance $0.00
44053 Rec-System Enhancements 0.00
44054 Rec-New Development 0.00
95636 Mail Room 1100
Records Retention - Total
95469 Reimbursement Division $0.00
95470 Reimbursement System 549.00
95542 Reimburse User Support 0.00
Reimbursement - Total
12001 OCSD-Courts/Criminal Warehouse $122.00
23009 Oracle Suppport OCSD/CTS Crim Whse - 2.6% 286.12
97163 Sheriff 77,447.00
97165 Sheriff-OW Support 6,220.00
97166 Sheriff-OW Maintenance 0.00
Sheriff - Total
23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% $572.26
96163 Sheriff - CLEMIS 2 099.00
Sheriff - CLEM'S - Total
23002 Oracle Support - Supp Serv - 5.2% $572.26
24011 SQL Server Supp - Suppt Services 7% 876.55
44500 Support Services 784.00
Support Services - Total
$46,602.66
$7,474.00
$0.00
$549.00
$84,075.12
$2,671.26
$2,232.81
Page 8 BOC Development Billing Report 2nd Qtr 2011 Prepared by Information Technology; March 17, 2011
600 TREASURER
730 WATER RESOURCE COMMISSIONER
540 62/1 DISTRICT COURT NOVI
550 52/2 DISTRICT COURT - CLARKSTON
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2011
23006 Oracle Support - Del Tax - 5.2% $572.26
23016 Oracle Support - Treasurer - 10.4% 1,144.53
36515 GIS Implementation Support-Treasurer 0.00
36516 Treasurer Application - MN Support 4,453.00
36602 Land System Enhancements - Trees (50%) 3,104.00
36702 Land System Maintenance - Treas (50%) 730.50
36802 Land System Support - Trees (50%) 2,600.75
44061 Tie-System/Customer Support 11,825.00
44062 Tie-System Maintenance 5,451.00
44063 Tre-System Enhancements 0,00
44064 Tie-New Development 354.00
44080 Tre-DW Support 6,026.00
44082 Tre-DW Maintenance 0.00
95008 Del Tax On Line 0.00
95303 Del Tax System Maintenance 12,024.92
95561 User Support/Del Tax 7,812.00
95615 BS&A Annual Tax Support 23,095.00
Treasurer - Total
24008 SQL Server Supp - WRC 3.5% $438.36
28007 Water Resource Commissioner 0.00
28010 WRC - Customer Support 16,094.00
28011 Water Resource Commissioner Application 8,372.50
36520 GIS Implementation Support WRC 7,386.00
36521 WRC Application - I-11W Support 8,906.00
Water Resource Commissioner - Total
14002 CTS-DW Support-52/1 - 6.25% $0.00
15002 CTS-DW Maint 52/1 - 6.25% 0.00
95527 DC Suprt- 52/1 - 25% 9,060.99
52/1 District Court - Total
14003 CTS-DW Support-52/2 - 6.25% $0.00
15003 CTS-DW Maint 52/2 - 6.25% 0.00
95528 DC Suprt- 52/2 - 25% 9,060.99
52/2 District Court - Total
$79,192.96
$41,196.86
$9,060.99
$9,060.99
Page 9 BCC Development Billing Report 2nd Qtr 2011 Prepared by Information Technology; March 17, 2011
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2011
560 52/3 DISTRICT COURT - ROCHESTER
530 5214 DISTRICT COURT - TROY
14004 CTS-DW Support-52/3 - 6.25%
15004 CTS-DW Main! 52/3 - 6.25%
95529 DC Suprt - 5213 - 25%
52/3 District Court - Total
14005 CTS-DW Support-52/4 - 6.25%
15005 CTS-DW Maint 52/4 - 6.25%
95530 DC Suprt- 52/4 - 25%
52/4 District Court - Total
$0.00
0.00
9,060.99
$0.00
0.00
906093
$9,060.99
$9,060.93
BOO Development Billing Report 2nd Qtr 2011 Page 10 Prepared by Information Technology; March 17, 2011
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2011
Gust # DIRECT FUNDS
055 CLEMIS 20003 IDMS Support - 20% $0.00
23004 Oracle Support - OakVideo CLEMIS 5.2% $572.26
23018 Oracle Support - Sheriff CLEMIS 5.2% 572.28
24004 SQL Server Support - 24.5% 3,067.99
90507 CAD Customer Support 0.00
90510 C LEMIS - OakVideo Support 34,452.00
95409 CRISNET/CLEMIS LRM 0.00
95410 CRISNET/CLEMIS LRMS 55,953.00
95411 CLEMIS LRMS UASI (NR)
95430 CLEMIS Maintenance 3,391.00
95431 CLEMIS Enhancements 0.00
95432 CLEMIS Adhoc Reports 0.00
98003 CLEMIS User Support 908.00
CLEMIS - Total $96,964.53
056 CLEMIS FUND 63500 63500 CLEMIS Fund $0.00
CLEMIS 63500 Fund - Total $0.00
669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion $930.00
CAMS/CVT Data Conversion - Total $930.00
652 CAMS/FM0 (IT IMPLEMENTATION) 65200 CAMS/FM0 (IT Implementation) $59,973.00
CAMS/FMO (IT Implementation) - Total $59,973.00
659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys $109,472.25
Collabortive Asset Mgt Sys - Total $109,472.25
661 COMMUN & HOME IMPROVEMENT 66103 Comm Dev User Support $97,50
Common & Home Improvement - Total $97.50
471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $10,320_20
CTS-FOC Exp-CS Enf-Image - Total $10,320.20
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $5,581.50
CTS-FOC Exp-CD Enforc-Dev - Total $5,581.50
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $244.00
24001 SQL Server Support - FRMS 3.5% 438.36
Fire Records Management System - Total $682.36
Prepared by Information Technology; March 17, 2011 Page 11 BOC Development Billing Report 2nd Qtr 2011
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2011
750 FM&O 21001 FM&O $656.00
24013 SQL Server Supp - FM&O 438.36
75503 FM&O Development
FM&O - Total $935.86
841 HEALTH - H1N1 GRANT 84100 Health - H1N1 Grant . . .
Health - H1N1 Grant Total ,•:1; z,tly2.;')C1'
770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $2,891.50
44066 PRADM-System/Customer Support 1,986.00
44068 PRADM-System Enhancements 426.00
76100 P&R Administrative Services 36,651.00
77010 PRADM-Technology Assessment 0.00
77100 Yr 1 - Program Management 0.00
77110 Yr 1 - Asset Theme Development 0.00
77120 Yr 1 - Network Connectivity 2,175.00
77130 Yr 1 - Hardware Refresh 78.00
77140 Yr 1 - Point of Sale System 744.00
77200 Yr 2 - Program Management 0.00
77220 Yr 2 - Asset Mgmt Implementation 51,234_50
77230 Yr 2 - Customer Info Mgmt Implementation 0.00
95419 PRADM-Administration 9,572.50
Parks & Recreation - Total $105,758.50
761 P&R ADMINISTRATIVE SERVICES 76100 P&R Administrative Services $0.00
P&R Administrative Services - Total $0_00
695 RISK retANAGEMENT 44036 Rsk-System Customer Support $915.00
Risk Management - Total $915.00
656 WATER & SEWER ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $572.26
95669 Water & Sewer Acct'g 4,438.50
Water & Sewer Acct'g - Total $5,010.76
736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution $962.00
WinCan Central Storage Solution - Total $962.00
734 WRC - AMR SUPPORT 73401 WRC - AMR Support $221.00
WRC - AMR Support - Total $221.00
Page 12 BOC Development Billing Report 2nd Qtr 2011 Prepared by Information Technology; March 17, 2011
Resolution #11098 May 19, 2011
Moved by Weipert supported by McGillivray the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
Commissioner Jackson addressed the Board to give a special thanks to the General Government
Committee for passing Miscellaneous Resolution #11081 entitled Board of Commissioners — Declaration
of May 25, 2011 as National Missing Child Day in Oakland County; she also wanted to give thanks to
Youth Assistance.
Vote on Consent Agenda:
AYES: Crawford, Dwyer, Gershenson, Gingell, Gosselin, Greimel, Hatchett, Hoffman, Jackson,
Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, Runestad, Scott, Taub,
Weipert, Woodward, Zack, Bosnic, Covey. (25)
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).
V APPROVE THE FOREGOING RESOLUTION
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 May 19,
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 19th day of May, 2011.
p„__LL e
Bill Bullard Jr., Oakland County