HomeMy WebLinkAboutResolutions - 2013.05.09 - 20793MISCELLANEOUS RESOLUTION #13091
May 9,2013
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND QUARTER 2013
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 2013 development charges to be $921.892.32 for the General Fund/General Purpose
County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments are
$241,963.38 and non-county agencies are $32,279.50 for the Second Quarter 2013; 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 2013 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 2013 budgets
are to be amended as specified in the attached detail schedule.
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Long absent.
I haat APPROVE THE FORMING RESOLUTION
/0)
Resolution #13091 May 9, 2013
Moved by Long supported by Quarles the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted and appointments being
confirmed).
AYES: Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson, Long, Matis,
McGillivray, Middleton, Quarles, Runestad, Scott, Taub, Weipert, Woodward, Zack, Bosnic,
Crawford. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying reports being accepted and appointments being
confirmed).
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, 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 9, 2013,
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 9 th day of May, 2013.
Lisa Brown, Oakland County
540 550 560 530 630 005 725 722 440 410 724 720 723 522 620 430 015 495 483 498 502 493 785 740 660 900 680 907 565 872 710 775 512 510 145 637 650 195 191 445 600 910 730 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners Clerk/Reg - Admin Clerk.Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Register of Deeds Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - Auditing Corporation Counsel County Executive 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 Library - Library Admin Marketing & Communcations Medical Examiner MSU Extension - Oakland Planning & Economic Development Probate-Estates/Mental Health - EDMS (Imaging) Probate-Estates/Mental Health Support Prosecuting Attorney - General Prosecution Records Retention Reimbursement Division Sheriff Sheriff - CLEMIS Support Services Treasurer Veterans Services Water Resource Commissioner Sub-Total Fund 101 $12,414.04 $12,414.04 $12,414.04 $12,413.88 $20,796.26 $0.00 $1,860.50 $2,637.60 $1,220.00 $0.00 $23,249.00 $1,637.76 $2,858.76 $33,185.65 $183.00 $176.00 $486.00 $940.26 $1,062.26 $99,498.00 $1,270.39 $2,307.90 $16,993.50 $85,366.46 $48,366.01 $518.75 $14,008.30 $122.00 $6,167.00 $8,969.26 $0.00 $4,554.50 $2,307.90 $7,225.26 $16,911.76 $9,828.00 $5,794.00 $71,943.26 $9,038.39 $6,739.73 $114,021.76 $0.00 $60.864.01 $732,765.19 $7,607.41 $7,607.41 $7,607.41 $7,607.27 $84,655.25 $54.00 $2,940.50 $4,631.20 $6,644.00 $122.00 $34,952.50 $3,762.50 $41,085.00 $93,627.06 $244.00 $476.00 $864.00 $1,508.88 $2,127.50 $196,772.25 $2,407.56 $6,463.80 $39,826.50 $227,123.19 $102,027.44 $2,314.75 $31,164.60 $122.00 $8,163.00 $12,732.50 6108.00 $5,564.50 $4,052.30 $9,844.00 $41,140.50 $14,258.00 $13,293.50 $129,491.38 $17,632.81 $13,707.24 $222,885.86 $118 049.75 $0.00 $1,527,993.57 $63,858.99 $54.00 $1,080.00 $1,993.60 $5,424.00 $122.00 $11,703.50 $2,124.74 $38,226.24 $60,441.41 $61.00 $300.00 $378,00 $568.62 $1,065.24 $97,274.25 $1,137.17 $4,155.90 $22,833.00 $141,756.73 $53,661.43 $1,796.00 $17,156.30 $0.00 $1,996.00 $3,763.24 $108.00 $1,010.00 $1,744.40 $2,618.74 $24,228.74 $4,430.00 $7,499.50 $57,548.12 $8,594.42 $6,967.51 $108,864.10 $724.25 $57,185.74 $795,228.38 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2013 CUST # FUND # ACCOUNT # DIVISION 1st Qtr 2013 Oct - Dec 2nd Qtr 2013 Jan - Mar 3rd Qtr 2013 Apr - Jun 4th Qtr 2013 Jul - Sep Y.T.D. GOVERNMENTAL FUNDS General Fund [1011 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-2010210-125000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010401-172190-773630 10100-2010205-132300-773630 10100-1070401-113000-773630 10100-1010201-181010-773630 10100-1010501-181020-773630 10100-1010101-181000-773630 10100-3010201-121110-773630 10100-3010403-121100-773630 10100-3010301-121130-773630 10100-3010301-121180-773630 101 00-3010101-121 100-773630 10100-1090101-171000-773630 10100-1020501-173010-773630 10100-1020601-182020-773630 10100-1010115-115090-773630 10100-1050401-183010-773630 10100-5010303-165040-773630 10100-1090108-171030-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-1090201-171000-773630 10100-3040403-124010-773630 10100-3040403-124010-773630 10100-4010101-122050-773630 10100-1030803-184020-773630 10100-1020650-126020-773630 10100-4030301-112590-773630 10100-4030601-110000-773630 10100-1030803-184025-773630 10100-7010101-186040-773630 10100-1070301-132050-773630 10100-6010101-155010-773630 Prepared by; Information Technology; 4/15/2013 Page 1 of 12 BOC Development Billing Report 2nd Quarter 2013.xlsx
$52,366.00 $0.00 $18,881.81 $488.00 $14,866.00 $37.50 $2,307.90 $22,674.00 $15,875.25 $1,428.26 $9,592.76 $0.00 $0.00 $23,083.00 $599.00 $599.00 $4,927.00 $0.00 $2,116.89 $0.00 $15,617.50 $0.00 $1,066.20 $1,413.30 $112,300.50 $1,450.50 $12,959.33 $0.00 $18,239.00 $3,957.25 $1,744.40 $23,171.50 $14,330.75 $1,065.24 $8,824.49 $15.00 $650.50 $19,692.75 $378.00 $378.00 $4,252.50 $385.00 $1,743.67 $0.00 $0.00 $0.00 $3,800.15 $5,037.35 $164,666.50 $1,450.50 $31,841.14 $488.00 $33,105.00 $3,994.75 $4,052.30 $45,845.50 $30,206.00 $2,493.50 $18,417.25 $15.00 $650.50 $42,775.75 $977.00 $977.00 $9,179.50 $3,860.56 $0.00 $15,617.50 $0.00 $4,866.35 $6,450.65 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2013 CUST # FUND # ACCOUNT # DIVISION 1st Qtr 2013 Oct - Dec 2nd Qtr 2013 Jan - Mar 3rd Qtr 2013 Apr - Jun 4th Qtr 2013 Jul - Seta Y.T.D. Health Fund (2211 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Juvenile Maintenance Fund 12931 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 Health $72,060.50 $52,632.00 $124,692.50 Health Environmental $90,976.69 $67 410.94 $158,387.63 Sub-Total Fund 221 $163,037.19 $120,042.94 $0.00 $0.00 $283,080.13 Children's Village $9,460.00 $6,590.50 $16,050.50 Children's Village Admin $0.00 $30.50 $30.50 Sub-Total Fund 293 $9,460.00 $6,621.00 $0.00 $0.00 $16,081.00 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $905,262.38 ;921.892.32 $0.00 $0.00 $1,827,154.70 APPROPRIATION SUI3-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $905,262.38 $921,892.32 $0.00 $0.00 $1,827,154.70 10100-9090101-196030-773630 Information Technology Development $0.00 $0.00 TOTAL GOVERNMENTAL: $0.00 $0.00 $0.00 $0.00 $0.00 672 669 055 699 056 659 471 507 837 210 750 751 653 770 747 748 791 695 656 850 670 745 728 729 NON-GOVERNMENTAL DIRECT CHARGES Assessment & Tax CAMS/CVT Data Conversion CLEMIS CLEMIS-CAD CLEMIS FUND 63500 Collaborative Asset Mgt Sys (CAMS) Courts-FOC Exp-CS Enforcement- EDMS (Imaging) Courts-FOC Exp-CS Enforcement EDCA - MITradeSchooforg Grant Fire Records Management System F M&O IT Telepone Communications O.C. International Airport Parks and Recreation - Administration Pontiac - Water Pontiac - Sewer Radio Communications - E911 Risk Management Water Resources Accounting Workforce Dev Division WRC Acctg - Crowder Prjct WRC - COSDA Meter Replacement WRC - CO SDS SewMet WRC - EF SDS SevvMet Prepared by; Information Technology; 4/1512013 Page 2 of 12 BCC Development Billing Report 2nd Quarter 2013.xlsx
INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2013 GUST # FUND # ACCOUNT A! 737 671 739 738 DIVISION WRC - Data Application Pilot Poject WRC - Infrastructure Op Ar WRC - SCADA Common WR:C - SCADA Engineering Assessment 1st Qtr 2013 Oct - Dec $798.00 $608.00 $920.00 $928.00 2nd Qtr 2013 Jan - Mar $1,518.50 $4,273.50 $1,795.50 $0.00 3rd Qtr 2013 Apr - Jun 4th Qtr 2013 Jul - Sep Y.T.D. $2,316.50 $4.881.50 $2,715.50 $928.00 63600-1080101-152000-631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $191,193.37 $241,963.38 $0.00 $0.00 $433,156.75 TOTAL COUNTY DEVELOPMENT CHARGES $1,096,455.75 i,163,855.70 $0.00 $0.00 $2,260,311.45 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $39,063.00 $32,279.50 $71,342.50 TOTAL DEVELOPMENT CHARGES $1,135,518.75 $1,196,135.20 $0.00 $0.00 $2,331,653.95 Prepared by; Information lechnolegy: 4;15/2013 Page 3 of 12 BOC Development Billing Report 2nd Quarter 2013.xlsx
$1,065.24 36,408.25 26 385.50 $54.00 $6 590.50 $30.50 $1,080.00 $5,424.00 $1,065.24 $0.00 $724.00 $335.50 0.00 $1.993.60 $122.00 $11,703.50 $1,065.24 37,161.00 $63,858.99 $54.00 $6,590.50 $30.50 $1,080.00 $5,424.00 $2,124.74 $1,993.60 $122.00 $11,703.50 $38,226.24 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 Gust # GOVERNMENTAL FUNDS 24017 SQL Server Supp - Animal Control 95628 Web License Registration 95682 Dog System Animal Control-Total 91404 BOO - Customer Support Bd of Commissioners - Total 95665 Childrens Village Childrens Village - Total 97668 Childrens Village Admin Childrens Village Admin - Total 72500 Clerk - Admin Clerk/Reg - Admin - Total 95443 Elections Clerk/Reg - Elections Division - Total 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - HAN Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Clerk/Reg of Deeds - Total 95158 Clerk/Reg - EDMS SupporMaintneance/Upgrades Clark/Peg - EDMS (Imaging) - Total 95512 Clerk/Reg - Jury Commission ClerkiReg - Jury Commission - Total 95189 Circuit Court System Clerk/Reg - Legal Records - Total 24015 SQL Server Supp - Vital Stets 3.5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDRENS VILLAGE ADMIN 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 720 CLERK! REGISTER OF DEEDS 722 CLERK/REG - EDMS (IMAGING) 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS Prepared b Information T ec hnology; BOG Development Billing Report 2nd Quarter 2013.xlsx
INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL SECOND QUARTER 2013 522 COMMUNITY CORRECTIONS-ADMIN (CO) 620 COMPLIANCE OFFICE - AUDITING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 495 CTS-BUSINESS DIVISION 483 CTS-FD-JUDICIAL SUPPORT-ADM 498 CTS-GEN JURIS-JUDICIAL 'SUPPT 502 CTS-GJ-JURY OPERATIONS 493 CTS-JUDICIAL ADMIN 23003 Oracle Support Comm Corr - 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Admin (County) 52201 Comm Corr OW Support Community Corrections - Total 95468 Auditing Internal Srv - Cust Sup Compliance Office - Auditing - Total 95501 Corporation Counsel Corporation Counsel - Total 95656 County Executive Support County Executive - Total 12002 CCT-CourtsiCriminal 23010 Oracle Support-CCT/CTS Cdm Whse 2.6% CTS-Business Division - Total 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% CTS-FD-Judicial Support-Adm - Total 95179 CTS-Gen June-Judicial Suppt CTS-Gen juris-Judicial Suppt - Total 23008 Oracle Suppoit-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total 95174 CTS-Judicial Acirnin CTS-Judicial Admin - Total $1,137.17 1,065.24 24,220.00 34,019.00 $61.00 $300.00 $378.00 $0.00 $568.62 $1.065.24 $97,274.25 $1,137.17 $4.155.90 $60,441.41 $61.00 $300.00 $378.00 $568.62 $1,065.24 $97,274.25 $1,137.17 $4,155.90 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $351.00 36501 CEO Application - H/W Support 16.230.50 95785 Comm & Eco Dev.elopmt 6.251.50 Economic Development & Community Affairs - Total $22,833.00 Prepared by Information Technology: 4/152013 Pago 5 of 12 BOC Development Billing Report 2nd Quarter 2013.xlsx
INFORMATION TECHNOLOGY RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 23012 Oracle Support-Equalization - 5.2% 24005 SQL Server Supp-Equalization 10.5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application - HNV Support 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (50%) 95562 Equalization - INV Support 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-Ac,ctg - 1.75% 44021 FS-System/Customer Support 44023 FS - System Enhancements 96001 Human Res - Acct 40% 96003 Human Res - Budget 20% Fiscal Services Adrnin - Total 36525 GIS Implementation Support Health 95563 User Support-Health 96842 Health Admin Health - Total 23005 Oracle aipport - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 84200 EH - Projects 84300 Ehealth Program Health-Environmental - Total 36545 GIS Implementation Support Homeland Security 36546 Homeland Security Application - HAN Support 98990 Homeland Security Homeland Security - Total 23014 Oracle Support-FIR/Personnel - 5.2% 24007 SQL Server Suppporl-HR/Personnel - 1.75% 96002 Human Res-Personnel 40% Human Resources - Total 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES $1,137.17 3,195.56 55,719.75 233.50 22,128.00 7,948.50 448.50 2,305.75 560.00 48,080.00 $141,756.73 $3,411.53 1,137.17 532.73 27,662.00 305.00 13,742.00 6,871.00 $53,661.43 $354.00 22,131.25 30,146.75 $52,632.00 $1,137.17 4,260.62 54,706.15 7,307.00 $67,410.94 $75.00 30.50 1,690.50 $1,796.00 $1,137.17 532.73 15,486.40 $17.156.30 Prepared by: Information Technology; 4/15;2013 BOC Development Billing Report 2nd Quarter 2013 xlsx
$0.00 $1,996.00 $1,065.24 2. 698.00 $108.00 $1,010.00 $1,744.40 $1,065.24 1553.50 $1,065.24 17,231.50 5,932.00 $4,430.00 $6,599.50 900.00 $0.00 $568.62 122.00 0.00 4.458.00 52.399.50 $0.00 $1,996.00 $3,763.24 $108.00 $1,010.00 $1,744.40 $2,618.74 $24,228.74 $4,430.00 $7,499.50 $57,548.12 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 91405 Library Board Library - Library Admin - Total 56500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 95600 PEDS Cust/System Support Planning & Eco Development - Total 95207 PC-E/MH EDMS Support & Mtce Prob-Est/Mntl Hlth EDMS (Img) 24010 SQL Serv Supp-PCT-EstMental - 3.5% 92198 Prob-Est/Mntl HIM Support Preb-Est/Mnfl I-11th Support - Total 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor - Total 44053 REC - System Enhancements Records Retention - Total 95470 ReirnburSement System 95542 Reimburse User Support Reimbursement - Total 12001 OCSD-Courts/Criminal - 50% 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6% 97163 Sheriff 97164 Sheriff - Development 97165 Sheriff-DVV Support 98164 CLEMIS-Sheriff SheriU -1-0 907 LIBRARY - LIBRARY ADMIN 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 775 PLANNING & ECO DEVELOPMENT 512 PROB-ESTATES/MENTL HUTH EDMS (IMG) 510 PROB-ESTATES/MENTL HLTH SUPPORT 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF Prepared by: Information Technology; 4115/2013 0112 BOO Development Billing Report 2nd Quarter 2013.xlsx
INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 600 TREASURER 445 SUPPORT SERVICES 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 23002 Oracle Support - Stipp Serv - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support - Treasurer - 10.4% 36516 Treasurer Application - H/W Support 36602 Land System Enhancements - Treas (50%) 36702 Land System Maintenance - Trees (50%) 36802 Land System Support - Treas (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44063 Tie-System Enhancements 44080 Tre-DVV Support 44082 Tre-DW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 BS&A Annual Tax Support Treasurer- Total 95651 Veterans Customer Support Veterans Services - Total 24008 SQL Server Supp - WRC 3.5% 28010 VVRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support WRC 36521 WRC Application - HAN Support Water Resource Commissioner - Total 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 191 SHERIFF - CLEMIS $1,137.17 7,457.25 $8,594.42 $1,137.17 2,130.34 3,700.00 $6,967.51 $1,137.17 2,274.28 5,346.00 7,948.50 448.50 2,305.75 20,690.40 2,476.00 18,003.00 1,136.00 0.00 244.00 1,299.00 23,318.50 22,237.00 $108,864.10 $724.25 $724.25 $1,065.24 17,355.75 20,831.00 3,486.75 14,447.00 $57,185.74 540 5211 DISTRICT COURT - NOVI 95527 DC Surirt- 52/1 - 25% 52/1 District Court - Total -$4,806.63 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total -$4,806.63 Prepared by: Information Technology: 4/15/2013 BOO Development Billing Report 2nd Quarter 2013.xlex Page 2
INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2013 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 $0.00 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total ($4,806.63) 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 5214 - 25% 52/4 District Court - Total -$4,806.61 ($4,9,06.61) Prepared by: Information 1ace ooh o: IOC Development Billing Report 2nd Quarter 2013.xlsx
$112,300.50 $112,300.50 $1,137.17 1,136.98 7,456.18 2,294.00 0.00 874.00 61.00 $0.00 $18,239.00 $1,450.50 $3,957,25 $1 744.40 $23 171.50 $14,330.75 $0.00 1,065.24 $12,959.33 $0.00 $18,239.00 $1,450.50 $3,957.25 $1,744.40 $23,171.50 $14,330.75 $1,065.24 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 Gust # DIRECT FUNDS 67200 Assessmenet & Tax Assessmenet & Tax - Total 23004 Oracle Support - OakVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 95430 CLEWS Maintenance 95431 CLI1/1S Enhancements 98003 CLEMIS User Support 98005 CLEMIS - E911 Support CLEMIS - Total 98006 CLEMIS - CAD Development CLEWS - CAD Total 63500 CLEMIS Fund CLEMIS 63500 Fund - Total 66901 cArostc VT Data Conversion CAMS/CVT Data Conversion - Total 65901 Coili,bortive Asset Mgt Sys ASSet Fvigt Sys - Total 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades CTS-FOC Exp-CS Enforc-EDMS (frig) - Total 92193 CTS-FOC Exp-CD Enforc-Dev CTS-FOC Exp-CD Enforc-Dev - Total 33700 EDCA - MITRADESCHOOL EDC.A -MD adeSchool.org Grant - Total 21010 Fire Record-, Mgmt Fund 531 2,1001 SQL Server S'irpport - FRMS 3.5% Fire i,gement System 'Total 672 ASSESSMENT & TAX 055 CLEMIS 699 CLEMIS - CAD 056 CLEMIS FUND 63500 669 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGI SYS 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 507 CTS-FOC EXP-CS ENFORCUIENT 837 EDCA - MITRADESCHOOL.ORG GRANT 210 FIRE RECORDS MANAGEMENT SYSTEM Prepared by: information Torhnology; 411'.3!?01 ROC Development Billing Report 2nd Quarter 2013.xlsx
$243.75 1,065.24 7,515.50 $15.00 $650.50 $2,640.50 180.50 93.75 132.00 2,365.00 14 281.00 $378.00 $378.00 $4,252.50 $385.00 $1,137.17 606.50 $8,824.49 $15.00 $650.50 $19,692.75 $378.00 $378.00 $4,252.50 $385.00 $1,743.67 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 21001 Facilities Maintenance & Operations 24013 SQL Server Supp - FM&O 75503 FM&O Development Frvi&O - Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 65301 Airport User Support 0.C. Intn1 Airport - Total 36530 GIS Implementation Support - Parks 44066 PRADM-System/Customer Support 44068 PRADN1-System Enhancements 76100 P&R Administrative Services 95413 PRADM•Customer Support 95419 PRADM-Administration Parks & Ren,eation - Total 74701 Pontiac BSA to WRC - Water Pontiac Water - Total 74702 Pontiac BSA to WRC - Sewer Pontiac Sewer - Total 79101 Radio Communications - E911 Radio Communications - E911 - Total 41036 Rsk_svstenn cs.,!storner Support Risk IVtong. ••v.•; - Total 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting water Resources Accounting - Total 750 FM&O 791 IT - TELEPHONE COMMUNICATIONS 653 O.C. INTNL AIRPORT 770 PARKS AND RECREATION 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 656 WATER RESOURCES ACCOUNTING 850 WORKFORCE DEV DIVIS 95670 Employment & Training Workforce Dos' Division - Total $0.00 $0.00 670 WRC ACCTG - CROWDER PRJCT 67000 WP,C - Crowder IletBase Project $0.00 WRC AccIg Crovvrier Prject - Total $0.00 745 WRC - COSDA METER REPLACE E 74500 wpn cOr.- !-•- Replacement $0.00 Replacement - Total $0.00 Prepared by: Information TerhnoIogy: 4/152013 Page 1 of !. POC Development Billing Report 2nd Quarter 2013.xlsx
INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2013 728 WRC - CO SOS SEWMET 729 WRC - EF SOS SEWMET 737 WRC - DATA APPLICATION PILOT PRJ 671 WRC - INFRASTRUCTURE OP AR 739 WRC - SCADA COMMON 738 WRC - SCADA ENGINEERING ASSESSMT 72201 MARS Enhancements - WRC C-0 1A/RC - CO SOS SewMet - Total 72202 MARS Enhancements - WRC E-F WRC - EF SOS SewMet - Total 73700 WRC Data Application Pilot Project 73710 WRC - Data Appl Prj VVR0 - Data Application Pilot Prj - Total 67100 VVRC -10 AR VVRC - Infrastructure Op Ar - Total 73900 'A/RC - SCADA Common WRC - SCADA Common - Total 73800 WRC SCADA Engineering Assesmnt WRC - SCADA Engineering Assesmt - Total $3,800.15 $3,800.15 $5.037.35 $5,037.35 $0.00 1,518.50 $1,518.50 $4,273.50 54.273.50 $1,795.50 $1,795.50 $0.00 $0.00 Prepared by: Information Tca;hnology; 4/15201:3 2 BOG Development Billing Report 2nd Quarter 2013.xlsx