$208,938.49: TOTAL TAXPAYER EXPENDITURES TO PUBLIC CONSULTING GROUP (May 2013-July 2014)

ABSTRACT: Prior to the 9 September 2014 City Council Agenda Items related to Public Consulting Group (PCG), namely, Consent Calendar Item 7.E: Consideration of a Resolution Authorizing the City Administrator to Enter into a Contract with Grancius Inc. For Agenda and Legislative Management Services in an Amount Not to Exceed $39,168 for a Period September 15, 2014 through March 15, 2016 and a Contract for Project Management Oversight Services with Public Consulting Group in an Amount not to Exceed $20,800 and Consent Calendar Item 7.F: Consideration of a Resolution Authorizing the City Administrator to Enter into a Contract with Springbrook Software for a New Financial, Human Resources and payroll System in an Amount not to Exceed $190,683 for the Period of September 30, 2014 through September 30, 2018 and a Contract for related Project Management Oversight Services with Public Consulting Group in an Amount not to Exceed $73,200 (both pulled from the Agenda), the City Council approved unanimously a Resolution authorizing the City Administrator to amend an existing contract with Public Consulting Group (PCG) for services related to the finalization of the City's 2013 key initiatives; the development of the strategic information technology plan and interactive government projects and related information technology consulting services at the City Council Meeting on August 6, 2013. “The total price for the work performed under this Amendment, which may not be exceeded without the City's prior written approval, is $48,800.” Later, the City Council approved unanimously a Resolution authorizing the City Administrator to Enter into a Professional Services Consulting Agreement with Public Consulting Group, Inc. to Provide IT Strategic Plan Implementation Support and Project Management Services for the Implementation of Year One of the Information Technology Strategic Plan in an amount not to exceed $75,000 at the February 4, 2014 City Council Meeting. Moreover, Sally W.Nagy, Senior Consultant, PUBLIC CONSULTING GROUP (PCG) Technology Consulting, was to “provide CIO Advisory, Project Management, and related services to the City” at a hourly compensation rate of $160. Based on the City’s Check Registers, the City has compensated Public Consulting Group at total of $208,938.49.  BY MONTH, City’s Check Register Entries for PUBLIC CONSULTING GROUP Table, CONTRACT FOR PROFESSIONAL CONSULTING SERVICES (Term: February 2014 – January 2015) Table, EXISTING CONTRACT & AMENDMENT NO. 1 PROFESSIONAL CONSULTING SERVICES (March 2013 – January 2014) Table and City’s Check Register Entries for PUBLIC CONSULTING GROUP are presented.

BY MONTH, City’s Check Register Entries for PUBLIC CONSULTING GROUP CONTRACTUAL SERVICES, CONTRACTUAL SERVICES-TECH ASSESSMENT, CONTRAL SERVICES IT SUPPORT SVCS, CONTRACTUAL SERVICES-IT CONSULTING, CONTRACTUAL SERVICES-SYSTEM AMIN SERVICES

MONTH OF CHECK ISSUANCE	TOTAL MONTHLY EXPENDITURE TO PUBLIC CONSULTING GROUP
June 2014	$18,261.51
May 2014	$38,881.69
March 2014	$     300.00
February 2014	$  4,600.00
December 2014	$22,406.51
October 2013	$35,667.90
September 2013	$18,500.00
August 2013	$18,817.17
June 2013	$42,019.21
May 2013	$  9,484.50
TOTAL EXPENDITURE	$208,938.49

CONTRACT FOR PROFESSIONAL CONSULTING SERVICES
Executed 5th day of February 2014
Term: February 2014 – January 2015

MONTH SERVICES PROVIDED	TOTAL MONTHLY EXPENDITURE TO PUBLIC CONSULTING GROUP
February 2014	$  5,406.51
March 2014	$19,940.06
April 2014	$18,941.63
May 2014	$ 12,855.00
June 2014	$15,410.00
Total	$72,553.20

Source: INVOICES, PURCHASE ORDERS, CHECKS

EXISTING CONTRACT & AMENDMENT NO. 1 PROFESSIONAL CONSULTING SERVICES (March 2013 – January 2014)

MONTH SERVICES PROVIDED	TOTAL MONTHLY EXPENDITURE TO PUBLIC CONSULTING GROUP
March 2013	$  9,484.50
April 2013	$11,983.25  $30,035.96
June 2013	$18,817.17
July 2013	$  9,100.00
August 2013	$18,500.00
September 2013	$26,567.90
October 2013	$17,400.00
November  2013	$  5,006.51
December 2013	$2,300.00   $  300.00
Total	$149,495.29

Source: INVOICES, PURCHASE ORDERS, CHECKS
Note: Subtotal March 2013-July 2013 $79,420.88

City’s Check Register Entries for PUBLIC CONSULTING GROUP CONTRACTUAL SERVICES, CONTRACTUAL SERVICES-TECH ASSESSMENT, CONTRAL SERVICES IT SUPPORT SVCS, CONTRACTUAL SERVICES-IT CONSULTING, CONTRACTUAL SERVICES-SYSTEM AMIN SERVICES (May 2013-June 2014)

126298 5/8/2013 PUBLIC CONSULTING GROUP $ 9,484.50 01 67053 CONTRACTUAL SERVICES
Vendor Total -----> $9,484.50 (For Services Performed March 5 – 31, 2013)

126450 6/5/2013 PUBLIC CONSULTING GROUP $ 11,983.25 01 67053 CONTRACTUAL SERVICES
Vendor Total----->$11,983.25 (For Services Performed April 1 – 30, 2013)

126629 6/19/2013 PUBLIC CONSULTING GROUP $6,612.71 01 67053 CONTRACTUAL SERVICES (For Services Performed May 1 – 31, 2013)
126629 6/19/2013 PUBLIC CONSULTING GROUP $8,338.34 01 67053 CONTRACTUAL SERVICES (For Services Performed May 1 – 31, 2013)
126629 6/19/2013 PUBLIC CONSULTING GROUP $15,084.91 01 67053 CONTRACTUAL SERVICES (For Services Performed April 1 – 30, 2013)
Vendor Total----->$30,035.96

126830 8/2/2013 PUBLIC CONSULTING GROUP $12,801.05 01 67053 CONTRAL SERVICES IT TECH ASSESMENT
126830 8/2/2013 PUBLIC CONSULTING GROUP $6,016.12 01 67053 CONTRAL SERVICES IT SUPPORT SVCS
Vendor Total -----> $18,817.17 (For Services Performed June 1 – 30, 2013)

127102 9/26/2013 PUBLIC CONSULTING GROUP $ 1,100.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT
127102 9/26/2013 PUBLIC CONSULTING GROUP $ 4,700.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT
127102 9/26/2013 PUBLIC CONSULTING GROUP $ 9,400.00 01 67053 CONTRACTUAL SERVICES-IT CONSULTING
127102 9/26/2013 PUBLIC CONSULTING GROUP $ 3,300.00 01 67053 CONTRACTUAL SERVICES-SYSTEM AMIN SERVICES
Vendor Total ---> $18,500.00 (For Services Performed August 1 – 31, 2013)

127131 10/4/2013 PUBLIC CONSULTING GROUP $6,000.00 01 670S3 CONTRACTUAL SERVICES-IT CONSULTANT
127131 10/4/2013 PUBLIC CONSULTING GROUP $3,100.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES
Subtotal: $9,100.00 (For Services Performed July 1 – 31, 2013)
127263 10/23/2013 PUBLIC CONSULTING GROUP $2,000.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES
127263 10/23/2013 PUBLIC CONSULTING GROUP $18,730.S6 01 670S3 CONTRACTUAL SERVICES-IT CONSULTANT
127263 10/23/2013 PUBLIC CONSULTING GROUP $5,837.34 01 67053 CONTRACTUAL SERVICES-SYSTEM ADMIN SERVICES
Subtotal: $26,567.90 (For Services Performed September 1 – 30, 2013)
Vendor Total-> $35,667.90

127468 12/6/2013 PUBLIC CONSULTING GROUP $2,200.00 01 67053 CONTRACT SRVC-TECH ASSESSMENT SERVICES
127468 12/6/2013 PUBLIC CONSULTING GROUP $12,600.00 01 67053 CONTRACT 5RVC-IT CONSULTANT
127468 12/6/2013 PUBLIC CONSULTING GROUP $2,600.00 01 67053 CONTRACT SRVC-TECH ASSESSMENT SERVICES
Subtotal: $17,400.00 (For Services Performed October 1 – 31, 2013)
127585 12/20/2013 PUBLIC CONSULTING GROUP $600.00 01 67053 CONTRACT SRVC-TECH ASSESSMENT SERVICES
127585 12/20/2013 PUBLIC CONSULTING GROUP $2,506.51 01 670S3 CONTRACT SRVC-SYSTEM ADMIN SERVICES
127585 12/20/2013 PUBLIC CONSULTING GROUP $1,900.00 01 67053 CONTRACT SRVC-SYSTEM ADMIN SERVICES
Subtotal: $5,006.51 (For Services Performed October 1 – 31, 2013)
Vendor Total --> $22,406.51

127810 2/5/2014 PUBLIC CONSULTING GROUP $200.00 01 67053 CONTRACT SRVCS-TECH ASSESSMENT SERVICES
127810 2/5/2014 PUBLIC CONSULTING GROUP $2,100.00 01 67053 CONTRACTUAL SERVICES-IT CONSULTANT
Subtotal: $2,300.00 (For Services Performed December 1 – 31, 2013)
127907 2/21/2014 PUBLIC CONSULTING GROUP $300.00 01 67053 CONTRACT SRVCS-TECH ASSESSMENT SERVICES
127907 2/21/2014 PUBLIC CONSULTING GROUP $200.00 01 67053 CONTRACT SRVCS-TECH ASSESSMENT SERVICES
127907 2/21/2014 PUBLIC CONSULTING GROUP $1,800.00 01 67053 CONTRACT SRVCS-TECH ASSESSMENT SERVICES
Subtotal: $2,300.00 (For Services Performed January 1 – 31, 2014)
Vendor Total -- -> $4,600.00

128062 3/20/2014 PUBLIC CONSULTING GROUP $300.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES
Vendor Total -·-··> $300.00 (For Services Performed December 1 – 31, 2013)

128343 5/9/2014 PUBLIC CONSULTING GROUP $1,400.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICE
128343 5/9/2014 PUBLIC CONSULTING GROUP $500.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICE
128343 5/9/2014 PUBLIC CONSULTING GROUP $17,340.06 01 67053 CONTRACTUAL SERVICES-IT CONSULTANT
128343 5/9/2014 PUBLIC CONSULTING GROUP $700.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICE
Subtotal: $19,940.06 (For Services Performed March 1 – 31, 2014)
128450 5/30/2014 PUBLIC CONSULTING GROUP $1,600.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICE
128450 5/30/2014 PUBLIC CONSULTING GROUP $16,841.63 01 67053 CONTRACTUAL SERVICES-IT CONSULTANT
128450 5/30/2014 PUBLIC CONSULTING GROUP $500.00 01 67053CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICE
Subtotal: $18,941.63 (For Services Performed April 1 -30, 2014)
Vendor Total - >$38,881.69

128535 6/13/2014 PUBLIC CONSULTING GROUP $5,406.51 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES (For Services Performed February 1 – February 28, 2014)
128622 6/27/2014 PUBLIC CONSULTING GROUP $600.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES
128622 6/27/2014 PUBLIC CONSULTING GROUP $1,400.00 01 67053 CONTRACTUAL SERVICES-TECH ASSESSMENT SERVICES
128622 6/27/2014 PUBLIC CONSULTING GROUP $10,855.00 01 67053 CONTRACTUAL SERVICES-IT CONSULTANT
Subtotal: $12,855.00 (For Services Performed May 1 – 30, 2014)
Vendor Total -----> $18,261.51