Finance Personnel Agenda 9-21-17HTML

::J:D Northwestern Indiana
MRPC
Regional Planni g Commission

FINANCE AND PERSONNEL COMMITTEE
Meeting Agenda Thursday September 21, 2017
8:00 a.m.
NIRPC Office Portage, Indiana
1. Call to Order
2. Meeting Minutes of July 20, 2017 (Page 1-2)
3. Review of Financial Status
4. Approval of Claims Register
5. NIRPC Credit Card Policy Revision
6. 2017 Budget Amendment 5
7. Procurement Recommendations
  - Procurement #17-14
  - Procurement #17-18

Contracts for Approval
- Ecolnteractive Contract for ProjectTracker Software (E-TIP) - Procurement #17-15

(Page 3-6 )

(Page 7-26 )

(Page 27)

(Page 28)

(Page 29)

(Page 30-53)

Attorney Contract Proposals Review Process Discussion
Other Business
Adjournment

The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability , marital status, familial status, parental status, sexual orientation , genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program.

Requests for alternate formats please contact Angie Hayes at (219) 763-6060 extension 104 or ahayes@nirpc .org. Individuals with hearing impairments may contact us through the Indiana Relay 711 service by calling 711 or (800) 743-3333.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

July 20, 2017

NIRPC Dune Room Portage, Indiana

Members Present

Karen Freeman-Wilson, Chair Robert Carnahan

Richard Hardaway Diane Noll

Dave Shafer

Staff and Others Present Ty Warner

Angie Hayes Kathy Luther Meredith Stilwell Dave Hollenbeck

Call to Order

The meeting was called to order at 8:05 a.m. by Dave Shafer.

Approval of Minutes

Dave Shafer presented the minutes of the May 18, 2017 meeting. Upon a motion by Bob Carnahan, seconded by Greg Stinson, the Committee approved the minutes.

Review of Financial Status

Angie Hayes reported that Kelly Wenger is no longer employed with NIRPC and has gone to work for NICTD. The Financial reports were reviewed. Angie reported she has had issues with some vendors in regard to receiving billings in a timely manner which resulted in the reports only being through May 31 instead of June 30. NIRPC has received all 2017 county distributions . The Indiana State Board of Accounts audit of NIRPC has been completed with no audit findings or comments. A link to the 2016 Comprehensive Annual Financial Report (CAFR) will be sent by email.

Approval of Claims Register

Dave Shafer presented the claims register to the Committee for approval. Upon a motion by Bob Carnahan, seconded by Greg Stinson, the Committee approved the claims register.

Attorney Contract Scope of Work Discussion

Angie Hayes presented the scope of work and evaluation criteria for procuring an attorney for NIRPC. Upon a motion by Greg Stinson, seconded by Richard Hardaway, the Committee accepted the Scope of Work and evaluation criteria as presented. An RFP will be released by August 1, 2017 with responses due by September 1, 2017. The RFPs will be reviewed at the

September Finance and Personnel Committee meeting unless a special meeting is requested by the Committee based on number of responses received.

NIRPC Meeting Room Rental Policy Discussion

Angie Hayes initiated a discussion regarding how NIRPC should handle the renting out of meeting rooms. A suggestion was made to set a fee and use the amount as in-kind for non profit/governmental use of the rooms and charge for-profit entities for use. Dave Hollenbeck will look into how the building lease reads.

Accufund Contract Extension

Angie Hayes presented contract Amendment 4, to extend the contract between Accufund, Inc. and NIRPC until December 31, 2017. The extension would allow for dashboarding reports to be set up. There is a cost savings for extending the contract rather than entering into a new contract. Upon motion by Bob Carnahan, seconded by Greg Stinson, the Committee approved the contract extension with Accufund, Inc.

2017 Budget Amendment

Karen Freeman-Wilson presented 2017 budget Amendment 4 to transfer $22,500 from salaries to contractual for the purchase and implementation of new E-TIP software for the Transportation Improvement Program (TIP}. Upon motion by Bob Carnahan, seconded by Greg Stinson, the Committee approved budget amendment 4.

Other Business

Ty Warner announced that NIRPC's certification review, which takes place every four years, is underway. A public meeting was held in Gary on July 19 and another public meeting will be held on July 20 at 11:00 a.m. after the NIRPC commission meeting.

Bob Carnahan, who is on the Advisory Board of Lakeshore Public Media, announced that they are $96m in the red and are looking for ways to attract money. They are also looking to move their antennae from Lake Dale to Merrillville for better reception for the Chicago area which hopefully could encourage Chicago sponsors.

Ty Warner announced that the positions of Director of Transportation and Regional Planner/Policy Analyst have been posted with closing dates at the end of July. These positions are to replace Steve Strains who retired and J ames Winters who changed positions and is now the Transit Planner for NIRPC.

Adjournment

There being no further business, the meeting adjourned at 8:35 a.m.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH AUGUST 31, 2017

Linc Items Budget Expondod Balanco 0/o Expended

GENERAL FUND EXPENDITURES

Salaries

5020-1	Total Salaries		1,487,243.00	886, 127.83 601,115.17		59.58%
		Salarfos Sub-Total	1,487,243.00	886,127.83 601.115.17		59.58%
Fringe Benofits
5121·9	FICA Conlributions		113.815.00	64,012.43	49,802.57	56.24%
5122-9	Workers Compensation		7,000.00	4,234.00	2,766.00	60,49%
5123·9	Unemployment Compensation		1,600 00	1,094.71	505.29	68.42%
5141-9	PERF Contributions		185,100.00	108,775.81	76,324.19	58.77%
5142-9	Health lnsuranco		290,000.00	189,197.00	100,803.00	65,24%
5143-9	Life & Disability Insurance		21,000 .00	13,102.16	7,897.84	62.39%
5145-9	ICMA		19,880.00	12,995.00	6,885,00	65 37%
5146-9	Staff Development		18,000 00	7,160.64	10,839.36	39.78%
Frlngo Bonefits Sub-Total 656,395.00 400,571.75 255,823.25 61.03%
Occupancy
5221-9	Office Lease	209,220.00		139,476.96	69,743.04	66.67%
5222-9	Property Insurance	9,000.00		4,850.43	4,149.57	53,89%
5223-9	Building Maintenance	18,000.00		11,348.80	6,651.20	63.05%
5224-9	Utilities	23,000.00		16,068.63	6,931.37	69.86%
		Occupancy Sub-Total 259,220 .00		171,744.82	87,475.18	66.25%
Maintenance
5241-9	Copier Leasing/Maintenance		21,000.00	12,752.17	8,247.83	60.72%
5243-9	Compuler Service/Mainlenance		28,000.00	14,494.00	13,506.00	51 76%
5244-9	Telephone Service/Maintenance		23,000.00	12,375,17	10,624.83	53.81%

5249-9 Other Equipment Maintenance 500_00 199.92 300.08 39.98%

Maintonanco Sub-Total 72,500.00 39,821.26 32,678.74 54.93%

Departmental 5410-1	Communications: Commission/Ex. Dir. 36,500 .00	19,389.84	17,110.16	53.12%
5410-2	Communications: Transportation 40,500 .00	20,396.52	20,103.48	50.36%
5410-4	Communications: Subgrantee Managomenl 14,000.00	4,076.33	9,123.67	34.83%
5410-5	Communications: Environmental Programs 11,000.00	39,597.76	(28,597,76)	359.98%
5410-8	Communications: Partner Agency 2,500.00	4,122.05	(1,622.05)	164.00%
5410-9	Communications: Allocaled Functions 41.490 .00	5.39	41,484.61	0 01%
5420-5	Promotional Expenses: Environmental Programs 79,500.00	27,522.75	51,977.25	34.62%
5430-9	General Use Supplies Expense 10,016.00	35.37	9,980.63	0.35%
	Departmental Sub-Total 235,506.00	115,946.01	119,559.99	49.23%
Contractual
5602-9	Legal Services 18,000.00	12,000,00	6,000.00	66.67%
5603-9	Audit and Accounting 16,000.00	10,845.00	5, 155.00	67.78%
5604-9	LaPorte RLF Servicos 1,000.00		1,000.00	0.00%
5605-9	Human Rasources 10,000.00	6,625.00	3.375.00	66.25%
5610-4	Transil Oversighl 13,000.00		13,000.00	0.00%
5610-5	Environmenlal Projects 714,399 .00	128,863.06	585,535 94	18.04%
5610-5	Alternative Fuel 40,000.00		40,000.00	0.00%
5619-9	Organizational Dev. 16,000.00		16,000.00	0.00%
5610-5	Cornucopia Contractual 3,000.00		3,000.00	0.00%
5610-2	Hobart Faasibility Study 28,000.00	19.100.11	8,899.09	68.21%
5610-2	165 & Rt. 30 Planning Study 238,000.00	210,754.30	27.245.70	88.55%
5610-2	Household Travel Survey 184,190.00		184,190,00	0.00%
5610-2	Indiana Trails Study 25,000 .00	25,000.00		100.00%
	Contractual Sub-Total 1,306.589.00	413,187.47	893,401.53	31.62%
Capital Outlays 5910-1	Furniture and Equipment 101,000.00	18,732. 03	82,267.17	18.55%
	Capita/ Outlays Sub·Total 101,000.00	18,732.83	82,267.17	18 55%
	TOTAL GENERAL FUND EXPENDITURES 4, 118,453.00	2,046,131.97	2,072,321.03	49,68%
	LaPorto Rovolvlng Loan Fund 200,000 .00	94.69	199,905.31	0.05%
	Transit C<Jpltal Fund 2,375,452.00	578,626.27	1,796,025.73	24,36%
	Transit Operating Fund 3.764.616 .00	2,235,552.00	1,529,064.00	59.38%
	TOTAL EXPENDITURES 10,458,521.00	4,860,404 .93	5,598,116.07	46.47%

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 911312017 @ 10:54 AM Reconciliation - General Page:

Closing Balance from Previous Statement.......••....................•.,............:........, ................. 17 Deposits and Other Additions Totaling ....................,..,,.,•.........,,,.,...	713112017	1,432,261 .80 V 1,458,979.18
185 Checks and Other Withdrawls Totaling ...,.;.. .,...,...............................		1,100,222.34
0 Adjustments Totaling ...............................,........,:,.............,.,...,................		0.00
Voids Totaling....................................................... :.................,,.......		57,456.00
Service Charge.......,.......,...,...........................,••:..··:.••.........,..:..·..• .........	8/31/2017	50.80 ,/
Interest Earned........................................... ......:..............·:..,,......,,.,....	8131/2017	198.48 ,,/
Closing Balance for this StatemenL ...............................................................".,..............	8/31/2017	1,848,622.32 ,/
Difference.................................................,..... ..,........:·:.,..........:........,.,,..		0.00
Cash Balance from General Ledger.........................................................,.....,.-:.:........	8131/2017	1,793,705 .14
Open Activity from Bank Register...........,....•...:.........................:...;.:,,		(54, 769.50)
Adjustment for Service Charges and Interest..................,.................		147.68
General Ledger Reconciliation to Statement.................................,....,...,.,,.........................,..•,.,......		1,848,622.32

Total Unmarked Deposits:

8/15/2017	0001681 [0067] Diversified Marketing Strategies	2017 AQ Educ. & Outreach ads in	1,320:00 725.00
		Building Magazine
8/15/2017	0001690 [0236] United Way of Porter County	7/24/17 to 8106117 pay period - United Way	49.85
8/29/2017	0001691 [0003] AccuFund, Inc	renewal of support thru Sept 2018	5,962.50
8/29/2017	0001692 [0068] Adams Radio Group	Invoices 1170820017, 1170820018	7,000.00
8/29/2017	0001693 [0203] BASIC	Annual fee for COBRA adm.	360.00
8/29/2017	0001694 [0018] Blachly, Tabor, Bozik & Hartman,	Legal Services for Sept 2017	1, 500.00
8/29/2017	LLC 0001695 [0032] City of Portage, The	Office lease for Sept. 2017	17,434.62
8/29/2017	0001696 [0032] City of Portage, The	August 2017 Utilities	2,362.30
8/29/2017	0001697 [0067] Diversified Marketing Strategies	Lunch totes w/ Northwest Indiana Clean	5,418.74
		Air Logo on front pocket
8/29/2017	0001698 [0031] Health Resources.Inc	Dental Ins for Sept. 2017	1, 001 .60
8/29/2017	0001699 [0009] IN Assoc of Regional Councils	Regional Academy for TY Warner	35.00
		regional fee
8/29/2017	0001700 [0026] INS-CCU	817/17 to 8/20/17 pay period - Child Support	68.00
8/29/2017	0001701 [0012] Kansas City Insurance	Disability Ins for Sept 2017	637.04
8/29/2017	0001702 [0049] Treasurer of State	Annual Audit for 2016	10,845.00
8/29/2017	0001703 [0236] United Way of Porter County	8/7/17 to 8/20117 pay period - United	49.85
		Way
	Total Unmarked Checks:.' 54,769.50	Total Checks:	54,769.50

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run:911212011@ 3:50 PM Reconciliation - Revolving Loan Fund Page:

Closing Balance from Previous Statement.. .........,.•.,..,.•... .·: ···. ;,,.,.:....;...;,.:,........;;:,..•;,. ,. ,,

7/31/2017 35,023.41 v'

2	Deposits and Other Additions Totaling.....:.......,............,..:....-,,.;,..;;..,		1,476.25 y
O	Checks and Other Withdrawls Totaling,,,.........,..,. ,:;"'"'''...r,,,;.:;,.......,,.....,....,;		0.00
O	Adjustments Totaling.................................................................... .		0.00
O	Voids Totaling.............................................................................		0.00
	Service Charge.............................. ............................................... .		0.00
	Interest Earned..............................................................................	8/31/2017	1.54
Closing Balance for this Statement.,.,..c .........,•••;;................,••••••..,.,.,..........;..,,,,,._...,,.,,,,.,....		8/31/2017	36,501 .20
Difference......................................................................................,.			0.00
Cash Balance from General edger...........................................................................		8/31/2017	36,499.66
Open Activity from Bank Register.......,.;..;:...;,...;;;;.; ,-:. ............:.-..;', Adjustment for Service Charges and Interest..........,..........;,,;.; ,..........			0.00 1.54 v
General edger Reconciliation to Statement. ......................................................................,			36,501 .20 v

0122120

9/11/2017 0000000

Total Unmarked Deposits:

276.25

1,000.00

1,200.00

2,476.25 Total Deposits.: 2,476.2'5

f..r!l un••

T'otal Cl;lecks. 0.0.0

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: s11212017 @ 3:55 PM Reconciliation - Sequestered Revolving Loan Fund · Page:

Closing Balance from Previous Statement...........................................................................................	7/31/2017	159,842.09 ,/
O Deposits and Other Additions Totaling ......................... ................:............................		0.00
O Checks and Other Withdrawls Totaling .....................................................................		0.00
O Adjustments Totaling.................................................... ..........................................		0.00
O Voids Totaling........................................................................................................		0.00
Service Charge.......................................................................................................		0.00
Interest Earned.......................................................................................................	8/31/2017	13.58 /
Closing Balance for this Statement ....................................................................................................	8/31/2017	159,655.67 ./
Difference ...............................................................................................................		0.00
Cash Balance from General Ledger...................................................................................................·.	8/31/2017	159,655.67
Open Activity from Bank Register...........................,,•.:....,.,·..:····,········"·""···"···'···'·;'··		0.00
Adjustment for Service Charges and Interest.•.••..:...:.·....:;........,.........,,,.........,....,......,.		0.00
General Ledger Reconciliation to Statement.. .............................................................................................		159,655.67

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road Portage, IN 46368 (219) 763-6060

This fonn approved by the Stae Board of Accounts for use by

the Northwestern Indiana Regional -P·h.mn rng Commission-(T98SJ /

Date Claim Fund Amount

Filed Number Na me of Claimant Fund Amount of Claim Check # Notes

General Fund

7/18/201.7.

::-:"":'-":"'-: Net Pay roll - net payro.11 s 37, 095.84 $ 37,095.84 ---- 6-26- .thru 7-9-17 paid 7-18-2017

'General Fund p/r 6-26 th ru 7-9-17 pa1d 7-18-2017

7/18/2017 B-1565 Federal Taxes 2140, ,0 - s 5 ,849.07 s 5 , 849.07 C691378 Federal Taic withholdings

General Fund

7/18/2017 B-1565 FICA Taxes 2142 .0 s 7 , 589.46 s 7 , 589 .46 C691378 FICA T"/< w/h ' s & ER Pa1d FICA

General Fund p/r 6-26 thru 7-9-17 paid 7-18-2017

7/18/2017 81569 ICMA Reti. rement Ful)d 2146.0 s 610.00 s 610.00 C536442 payro.11 wi thholdin.9•

·General Fund 'p/ r 6-26 thru 7-9-17 paid 7-18-2017

,7/18/2017 . 149 ICMA Reti rement Fund 51.45 ,9 s 765.00 s 765.00 C536442 ER Paid for TY \o/aner -

General Fund p/r 6-26 thru 7-9-17 paid 7-18-2017

7/18/2017 8-15.68 Horizon Bank ' 2150.0 - s 1, 041.15 s 1,041.15 C530635 p/r w1thhold ings

.....

7/18/2017

-8-1567 INPR5

General Fu nd pf r

2149.0 $ 6,255.80 s 6 , 255.80 C858714 PERF

6-26

thru 7-9-17 paid 7-18-2017

General Fund p/r 6-26 thru 7-9-17 pa i d 7-18-2017

7/18/2017 1494 INPl\S 5141.9 1 0.02 s 0.02 C8S8714 roundi ng adjustment

teii'eral Fund

7/18/2017 1490 Smith , lohn -· S.410.9 s 11.40 s - 11.40. 539667 i le:01.9e

General Fund ·

7/18/2017 1473 Wi nters , James SAlO ., ?_ s 172.00 s 172.0D C530662 JTA. Board Meeting upe:nsc:s --

General Fund

7/18/2017 1473 Wi nters, J ames 54,10.2 - s 13.0.;12 s 130.72 CS.30662 i:nileage -

General Fund

7/18/2017 1478 Warner , Tyson 52.44.9. s 125 .00 s 125. 00 C5306S4 caruiuni cati on expc."se per agreeme:nt

General Fund J't:ib posti ng for a Rtgh:u'll Planner/Pol icy An•

7/18/2017 1492 Luther, I<athy 5410.9 s 55.00 s SS .DO C1530669 ·Ckfutn ia:- I

General Fu nd Jo posting for a l!c9ion•l Planner/Policy An.•

7/18/2017 1487 Warner , Tyson 5410_.9 s 594.90 s 594 . 90 CS0786 .,l_ -ApA "" Pl.ln,oti on- oxpn•

General Fund

:7/18/2017 1468 Comcast Internet 5244.9 s 140.64 . - s 140.64 ' C68256J,_ Internet Servi ces for luJ.y 2017

General Fund p/r 6-26 thru 7-9-17 paid 7-18-2017

7/18/2017 B -1564 INS-CCU 2145.0 L- 6 .QO s 68.00 1638 Child Support withhol.d fog

. eneral Fund

7/18/2017 1433 Stapl es 3430.9 $ 169.29 . s 169 .29 1639 offi ce supplies

General Fund

7/18/2017 1434 SVT , LLC 5430.9 s 5 .9.8 s S .98 1640 'supp.li es f.o r.}i. RPC 's ..1t...•n

General Fund

7/18/2017 1456 SVT , LLC 5430.9 s 4.98 s 4.98 1640 NIRPC meeting coffee

General Fund

7/ 18/2017 1418 Times 5410.4 s 19 .72 s 19 .72 1641 legal not ice for June 2017 vehicle d.f<110i.tlc

General Fund p/r 6-26 thru 7-9-17 paid 7-18-2017

7/ 18/2017 B-1570 United Way of Porter Co., 2147.0 s 49.85 s 49 . 85 1642 payroll withholdi ngs

General Fund

7/18/2017 1484 U .S . Bank Equi p Lease 5410.8 s 2.34 s 2.34 C374706 KRBC-J une copies

General Fund

7/18/2017 1484 u. s . Bank Equi p Lease ,5410. 5 s 2 .00 s 2 .00 C374706 Donnelly-June copies

General Fund

7/18/2017 1484 U .S. Bank Equi p Lease 5410 .4 s 28. 20 s 28 .20 074706 Subgr11ntee-)une copies

---

General Fund

7/18/2017 1484 U.S. Bank Eq ui p Lease 5410.2 $ 62 .80 s 62.80 C374706 Plilnni ng Dept-June cop1es

General Fund

7/18/2017 1483 U.S . Ban k Eq uip Lease 5241. 9 $ 1,629.83 s 1,629.83 C374706 Adnli ni stra.tion-Copier lease-July 2017

General Fund

7/18/2017 1486 Anthem BCBS 5142 .9 s 16, 288.25 s 16,288.25 C726879 August fflth Insurance ER paid

I General Fund

7/18/2017 1486 Anthem BCBS 2152.0 s 2 ,876.68 s 2,876.68 C726879 August Hlth Insurance-payroll withholdings

Gene ral Fund

7/18/2017 1477 Accu Fund

... ....

5910. 0 s 165.00 s 165.00 1643 )une EFT & Securi ty Ooc.umenta.tion Provi ded

f:jeneral Fund

/18/2017 1495 Anthem Life 5143.9 s 369 . 76 s 369.76 1644 Life Ins for J uly-ER paid
I - General Fund
7/18/20_17 1495 Anthem Lif e 2155.0 s 211.45 s 211.45 1644 life Ins for July - p/r withholdings
General Fund
7/18/2017 1485 BRYCO 5223.9 1, 320. • 00 s 1,320.00 1645 Cleaning servi ces for July 2017
·-- · ..
General Fu nd
I 7/18/2017 J,.054 Diversif i ed a,r!<eti n9 5610.5 J. 725. OD $ 725.00 1646 (<Q Advertising
General Fund
7/18/2017 1474 On-Si te Computer_ - 5243.9 s 1,733.DO $ 1,733 .00 1647 IT service & support for June 2017
' General Fund
7/18/2017 1472 Petty Cash 5430.9 s 21.36 $ 21. 36 1648 supplies for NIRPC
General Fund
7/18/2017 1472 Petty Cash 5410.2 s 21.60 s 11.60 - 1648 pp.1.t.>go . 11.urcl1.u<:.d at po·st office for over si r
General Fund
7/,18/2017 1472 Petty Cash 5410.2 s s.oo s 5.00 1648 NIRPC van wash
General Fund
7/18/2017 1426 Responsive Management 5610.5 s 18,000.00 s 18,000.00 1649 Ai r Qu.:ili ty Survey Services
General Fund I
7/18/2017 1308 South Shore Cl ean Ci ti es ' 5610. 5 $ 20, 925.QO 1 20, 925.00 1650 Professional Educ. And Training Servi ces
General Fund
7/18/2017 1104 Times 5610. 5 s 300.00 s 300.00 1651 l)Q Educ & Outreach Mobil• Ads
General Fund
7/18/2017 1 7.5 Total O.is.posa 1 522;1.9 s 72.40 s 72.40 1652 garbage srvc..s for July 2017 .
General Fund I
) /l_!IL2017 1489 Bar) oga. Mi tch 5410.2 1 134 ,H $ 132 .24 . C530663 mileage General Fund
' 7/18/20l.7 1489 Ba rloga, Mi tch 5146 .9 s 305 .80 s 305.80 C530663 mil eage
- General Fund
7/18/2017 1489 Barl oga, M.itch 5410. 2 s 868.35 s 868.35 C530663 APBP Pr.o.f.e.ssi.on..al v . expenses
General Fund
7/18/2017 1489 Barloga, Mitch 4982 .0 s 90.16 s 90.16 : C530663 rui1 age
Total : $ 126,910.04

Allowa nce of Claims

We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the
register such claims are hereby allowed in the total amount of _$.; 1_2_6.:,..9..:..I.._O._O'I".""
-----

Dated this day of-=----- 2017.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
6100 Southport Road
Portage, IN 46368
(219) 763-6060
'This fonn approved by the Sllle Bonrd of Accounts for use by
l h"Nonhwcstern lndinno Regional Planning Commlssion{l 9&1)
Regist.er of Claims
Date Claim Fu nd Amount
FH d -
Num ber Name of Claimant I Fund Amoun t of Clnim Check # Notes
General Fund
-
7/22 2017. 1427 Ci)j c0\90 Tri byne Medi a Grou 5.4:J.0 .l s 93.08 s 93.08 (72217 1 yr ubscri ption renew"l
-
I General Fund
7/22/20l7 1407 Stamps.com 5410.2 1 7.99 s 7.99 C72217 Planning Dept. M•y post•ge
General Fund
7/22/2017 1407 Stamps.com 5410.8 s 7.61 s 7.61(72217 RBC Moy pos•ge
I General Fund
. 7/2.i/2017 1407 Stamps.com 5410.4 s 66.70 ' s 66.70 (72217 Subgrantee May postago
I
I General Fund
7/22/-201? _140.7. Stam_p .com 5410.9 s 19.70 s 19.70 C72217 AdrJ!inistrtin M.!lY postige
General Fund
7/22/2017 1093 ' 5.tamps. com 5249.9 $ 24.99 s 24.99(72217 Monthly administrati.on fe
-

I
7/31/2017

'
General Fund
s s ...-
......_
Horizon Ban k Serv.i c.-e_ F.ee Servi ce F.ee-J u1' 4.8..l.6 48.16
s -
s -
Serv).cc Fee for Jly 017 /
/
/
-
'
/
'
I - /
I
v
S. -
I
/
I s -

v
I
s
-

/. -
s -
_/ s - -· -
·
/" s -
- s -
/ s - - . - -
/. s -
/ I -
v·
-
v/ - s -
.) s- -
/ I .

s - /
/
s - /
/
s -
-

-
s
-
s - /
s - I/
s - /
[/"
s -:/
I
- - - ·- . . -- 7 .. . --
- --
·-- - - vs
- /
: /
'
s -
-

' - i -
/ v
v/
s - .
s -
· -
s -
/'
- s -
./ s -
s -
/.
s -
I/. . .
v/ s
· " --
/
"
s - .
s -
Total ; $ 26&.23 -

Allowance of Claims

We have examined the claims listed on the foregoing Register ot Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amount of -=$-_ 2_5_8_.2_3 _

Dated this _ day of .,, 2017..

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
6100 Southport Road
Portage, IN 46368
(219) 763-6060
This form approved by the Stae Board of Accounts for use by
the Nonh we stcrn l ndinn• . Rcti oml Plnnni n& CQmmi ssion ( 1985)
Reg.ister of ·:cfaims
Date Claim Fund Amount
Filc:.d . Nurpbcr N11, me of Clai1T1anJ Fuml An::u;iunt .. of Claim Check # Notes
General Fund 7/10 thru 7/ll/2017 payroll period

8/1/2017

8/1/2017
_._ ..._ _ _
_ _ ... ._
Net Payroll net p/r s 3Q., v:.s.64 i 36, 278.6.4 --- net p•yroll
General Fund 7i10 thru 7/23/2017 poyrol l peri od
Net Payroll net p/r s 4 ,01.7 - ,Q s 4., DF.80 , .....--- net wroll-f inal va_ t oo
- - -
General Fund
8/1/2017 lSlS Bi ci unas 1 Gabri ell e 5410.2 s 5.3 .20
General Fund
,s 53.20 (55273 mi leage -
8/1/2017 1507 Comcast 5244 . 9 .s 1,297.54 s 1,297.54 C7420S4 Voi<o bil 1 for July 2017
General Fund '7/10 thru 7/23 payroll period p•id 8-1-17 8/1/2017 B1624 Federal Taxes 2140.0 s 5 , 730. 33 s 5 , 730.33 Cl74036 "Federal Tax w1thholdings
General Fund 7/10 thru 7/23 payroll period p•id 8-1-17 8/1/2017 Bl624 FICA Taxes 2142 .0 : s 7 , 437 .32 s 7 , 437.32 Cl74036 FICA w/h ' s and ER FICA
General Fu nd 7/10 thru 7/2) p•yroll period paid 8-1-17
8/1/201 B-1630 Federal Taxes 2140.0 s l, 377 .05 s 1,377.05 Cl74036 Fedoral Tax withholdings-Final Vac. Pay
.
General Fu nd 7/10 th ru 7/23 payroll peri od paid 8-1-17 8/1/2017 8-1630 FICA Taxes 2142 .0 s 937 .32 s 937.32 074036 FICA w/h ' s and ER FICA-Final Vac. Pay
'
General Fund
8/1/2017 1519 EyeMed Vi sion Insu rance 2154.0 s 13S.46 s 135 .46 CS5268 \lision Ins for August 2017
General Fund ·,/10 thru 7/23 payroll period paid 8-l-17 8/1/2017 81627 Hori zon 8ank-HSA 21SO.O s 891.15 s 891.15 CH442 HSA w/h 's
General Fu nd I
8/1/2017 1514 Ibrahim, Eman 5410.2 s 76.76 s 76 .76 C55279 inilegc
General Fund 7/10 thru 7/23 payroll period paid 8-l-17 ' 8/lj2Ql7 81628 ICMA Reti rement Trust Fund 2146.0 s 610.00 s 610.00 C55393 ICMA wi thho1di ngs
General Fund 7/10 thru 7/23 payroll period paid 8-1-17 8/1/2017 1522 ICMA Reti rement _Trust Fund Sl45.9 s 765.00 i s 765 .DO CSS393 ER paid ICMA contri bution for TY Warner
General Fund 6/12 th ru 6/25 p•id 7/J/2017 pay roll per iod 8/1/2017 81541 IN Dept of Revenue-State 2143.0 s l, 600.49 s 1,600.49 06654 State Tax Wi thholdings
' General Fund 6/12 thru 6/25 .1id 7/)/2017 payroll period 8/1/2017 61541 lll Dep t of llev(!n u e-Coun t:y 2144.0 s 397 .20 s 397.20 06654 County Tax Wi thho ldi ngs
General Fund 6/26 thru 7/9/ payroll period paid 7/18/2017 8/:1,/2017 81566 IN Dept of Revene-State 2143.0 $ l, 616.81 ! 1, 616.81 C36654 State Tax Wi thholdi ngs
General Fu nd 6/26 th ru 7/9/ payroll period paid 7/18/2017
8/l/2Ql7 81566 IN Dept of Revenue-Cou nty 2144 .0 s 414.22 s 414. 22 06654 Coun ty T•X Withholdings
· -
General Fund
7/10 th ru 7/23 payroll period paid 8-1-17
8/1/2017
8··1626 INPRS
2149.0 s 6 , 039 .SO s 6 , 039.SO C90052 I
General Fund 7/10 thru 7/2) payrol l period paid 8-1-17
8/1/2017 1.524 INPRS - - 514],.9 s 0 .01 s 0 .01 C90052 !?P.loy.er paid r:oun4.ing ;ac:fjstment
General Fu nd 7/10 th ru 7/2) payroll period paid 8-1-17 8/1/201! 8-1632 INPRS _ , 2149.0 s 869 .94 s 69.94 C90052 Fi na} Va.C P_ayroll rERF
General Fu nd
8/1/201.7 1349 Mi ke Russell 5605 .9 - . s 450.00 s 450 , QO C55282 HR Consulting Servi ce.s- June 2017
General Fund ,xo ·• for job postings w/ MPO's job board
- /1/2017
lSOO
i>fld
Stilwel l , Meredi th 5410.9 s lSO. 00 s 150 .00 C55302 I
APA-tM job· boord .
I Gene ral Fund
8/1/2017 1595 Warner, Ty son 5410.9 $ 75.44 s 75.44 . (55285 011le>go
General Fund C!Xpcnses-.ucenJed Fe:J . llighw.:ay Ad11tfn .
I
/1/2017 1506 Weber , scott 5410.2 s

342 .48

s 34 2 .48 (55288 Transportati on Perfonn;incc Mgmt Worksho

8/1/2017	1387	Herald Argus	General 5410 , 4	Fund	s	19.83	s	19,83	1654	Legal Noti ce for the June Vehi cl e Di sp9si ;or:-i Sa.l e
			General	Fund
8/1/2017	1496	1st Source Bank	5410.9		s	SO.OD	s	50.00	165.5	Ano.ual Safa Box RentaJ
8/1/2017	1501	American Pl anning Assoc . - Illinois Chapter	General 5410.9	Fund	s	0 .00		300.00	1656	Job posting_s
8/1/2017	- 1512	Anthem Life Insurance	General 5143.9	Fund	s	36.9.76	s	369 .76	1657	ER paid Life Ins for Au9ust 2017
			General	Fund
8/1/2017	1512	Anthem Life Insurance	2155.0		s	Ul.45	s	211.45	1657	EE W/H' s for Opt Life Ins. for August 2011
		Blachly, Tabor,	General	Fund
8/1/2017	1481	Bozik & Hartman, LLC	5602.9		I s	1,500.00	s	+ ,509 .00	165..8	log•l services fo.r August, 2017
		Chicago Tribune	General	Fund						Legal Notice for the June Vehicle
8/1/2017	1395	Media Group	5410.4		s	19.46	s	19.46	1659	Di sp.os.i ti on Sa.l c
			General	Fund
8/1/2017	1503	City of Portage	5224.9		s	2,404.36	s	2,404.36	1660	Utilities for July 2017
		' '	General	Fund
8/1/2017	1480	City of Portage	5221.9		' s	17,434.62	s	17,434 .62	1660	office lease for Au9ust 2017
			General	Fund						us transport'a ti on for NIRPC Cert1fic11.tion
8/1/2017	1498	Dunes .L.earning Center	,5410.9		s	174.00	s	174.00	1661	Review Toi.Ir
			General	Fund
8/1/2017	1498	Dunes Larning Center	5410.9		s	176.00	s	176.00	1661	lunch for tour parti cipants
			General	Fund						Barracuda Fi rewal l with 3 yeilr w.uranty and
B/1/2017	1378	GovConnection, Inc,	5910.0		s	2,173.60	s	2,173.60	1662	ProSafe 48-Port GB Sm>rt Switch
			General	Fund
8/1/2017	1504	Health Resources, Inc.,	2153.0		s	1,130.20	$	1,130.20	1663	Ocntal Insurance for August 2017
			General	Fund
8/1/2017 1287 Indiana Un1versity 5610.2 - : --					s	10.773.67	s	10,773.67	1664	Indfana Trai ls Research Study

- - .

'General Fund 7/10 thru 7/23 payroll period paid 8-1-17 8/l/2017 1665 INS-CCU I 2145 ,0 s 68.00 s 68.00 1665 Chi 1d Support

- ;

General Fund

8/1/2017 1523 -

INCCU-ASFE 2145.0 s 55 .DO s 55.00 1666 2017 Annual Child Support Fee

General Fund I

I 8/1/2017 1513_ Kansas City Insurance 5143.9 s 893 .01 s 893 .01 1667 Disability Ins for August 2017-ER paid

General Fund All -Access Trai ni ng Pass

8/1/2017 1518 Lorman Education Servi ces 5146.9 s 489.30 > 489.30 1672 for Meredi th Stilwell

General Fund

8/1/2017 1463 Numer1dex 5430.9 s 530.16 li 530.16 1668 Plotter paper offi ce suppl i es

General Fund Profession;il Servi ce Coni:ract

8/1/2017 968 atio Architects, Inc, 5610 .2 ! 72,138.59 s 72,138. 59 1669 NIRPC US-30 I-65 Safety Planning Proj_cct.

South Shore Leadershi p General Fund Tui ti on for Li sa Todd to attend

8/1/2017 1488 tenter, Inc. 5410.9 s 1,650 .00 s l,650.00 1670 LNI4Z Program

General Fund 7/10 thru 7/23 payroll period paid 8-1-17 8/1/2017 B1629 United Way-Porter co. 2147.0 J 49.85 s 49.85 1671 poyroll withholdings

Total : $ 184,204.52

Allowance of Claims

We have examined the claims listed on the foregoi ng Register a t Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amount of _$_1_8_4 ,2_04_._5_2_ _

Dated this ------ day of _, 2017.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This rorm approved by the Stac Board of Accounts for use by

the Northwestern Indiana Regional Planning Commission ( 1985)

Da te Claim Fund

Filed Number Name of Claima nt Fu nd Amount

General Fund

Amount

of C.laim :Cbc<;Jc -

Notes

.6L1120l7 1529 Wex Bank 5410.2 s 40.22 s

General Fund

B/l/2017 1499 ,Gov' t Finance Offi cers As.. 5146. 9 s. 160,, QO s

40. 22 #C812Ql7. as purchased for NIRPC Y•n in July

160.00 11673 Homt?.•rshi p ren•"". l thro.u.oh 6/30/20_18

I s - /

s - /

' 1

I I s - /

s - _/

- -

I s -

s ./

/ s

/ s -

./ s -

s - ..

s -

s •'!-

/ s -

s - -

../' s -

/ s -

s - /

1 -C s

' s - . -- - - / :

' - /

-· - -

-·

s - .

s -

I '/'

- s -·! ./ - ..

s ./"'

s _/ _

- -- I :

- - -

/v .. '

s - ·-

/ s .

/ s -

/ s - .. -

/ s -

s -

/ s - ' ·

/ s -

v s .

/ s -

/ s ---- -- .

/ . s . - - -

Total : $ 200.22

Allowance of Claims

We have examined the claims listed on the foregoing Register of Claims, and except tor claims not allowed as shown on the register such claims are hereby allowed in the total amount of -'$- 2_0..Q..o_.2_2 _

Dated this _ day of __ 20 l7.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the Sine Board of Accounts for use by

the Northwestern lndiona l'lccioriiil Plnnnhil'.:.Co 111111issio n (I 985)

Date Claim Fu nd Amount

Filed Number Nan:i of c:Iaiman.t Fu nd Amou nt of Claim Check # Notes

General Fu nd 7/24 th ru B/02/2011 not payroll

8/15/201.7 -.---- Net Pxrol l net .l'R i 606 .. 35 J 606 .35 -·_;:..:...:.:..:. net payrol l -

J!/1. /2017

.,._ _

i'.;eneral Fu nd 7/2 th ru 8/02/2017 net payroll

Ne1: Pay ro]] 'n.('!t PR J 34 ,785 .57 J 34 ,785.57 --·-- net payrol 1

: General Fu nd

8/15/2017 B-1664 INPRS . 219.D s 5 , 916, 64 s 5 , 916.64 (919189 7/24 thru 8/02/2017 net payro 11

i:;eneral Fund

8/15/2017 B-1670 INPRS 2.149...0 s 102.38 J 102 .38 (919189 ,7124 thru 8/02/20ll net payr 11

General Fund 7/14 thru 8/02/1017 net payroll

.8/15/2017 1562 INPRS 5141. 9 J. 0.01 s 0.01 (919189 ounding adjustment paid by ER

General Fund 7/14 thru 8/02/2017 ne< payroll

,8/15/2017 B-1662 Federal Taxes 2140.0 J 5,540.85 J 5 , 540.85 C9.3928 fed. Tax wi thholdi ngs

General Fund 7/24 thru 8/02/2017 net payroll

8/15/2017 B-1662 FICA Taxes 2142 .0 J 7 ,136.60 J 7 , 136 .60 (93928 ER & W/h FICA uxes

· General Fu nd 7/H thru 3/02/2017 net poyro11

8/15/2017 . B-1668 Federal Taxes ·2140. D s 32 .10 s 32 .10 (69793 Fed . Tax wi thholding.s

· General Fund 7/2< th ru 3/02/2017 net payroll

8/15/2017 B-1668 FICA Taxes 142 .0 s 110. 30 s 110.30 (69793 ER & W/h FICA taxes

; General Fund 7 /24 thru 8/02/2017 net payro 11

8/15/2017 B-1665 Horizon Bank · ;21so J 891. 15 s 891.15 (76553 HSA payroll wi thholdings

;

Gneral Fund 7/24 th ru 8/02/2017 net payroll

8/15/2017 B-1666 ICMA Reti rement Fund i2146 .D s 610. DO s 610.00 (576563 ICMA P/R W/H ' s -

General Fund 7/2 thru 3/01/2017 net payroll

8/15/2017 1469 ICMA Reti rement Fund f5145 ,9 s 765 .00 l 765.00 (576563 ER pai d for TY Wa.rner

enerai Fu nd

8/15/2017 1349 Mi ke Russel l 15606.9 s 2 , 025 .00 s 2 , 025 .00 (576573 Consul ti ng Servi ces-2017

·.General Fund

8/15/2017 1560 Bi ci unas, Gabri elle i54l0. 2 s 19 .00 J 19 .0D (576570 NICrD South Shore expenses

' General Fund

8/15/2017 1559 Gei nosky, Sarah !5410. 2 s 19.76 J 19 .76 (576572 mi leagc

General Fund Wage & Hour Law Seminar

8/15/2017 1538 Stilwell , Meredi th

15•110.9 s 26.DO J 26.00 (576579 expense

. General Fund Wage & Hour Law Seminar

8/15/2017 1539 Stil well , Meredi th 5410, 9 s 122 . 36 s 122 .36 (576584 xpcnsc

- ·

General Fund

8/15/2017 1545 Warner , Tyson is244 .9 s 125 .00

125.00 (576589 (ollW!lunic.ilt.ion expense per agrce11c11t
. eneral
Fund
8/15/2017 1545 Warner, Tyson i5410 .1 s 30.63 J 30.63 (576589 Lunch Mee'ti ng
: General Fund MPO Council expenses and
8/15/2017 1534 Wrner , Tyson 54].D. 9 J 180 . 1) s 180.15 (576590 mi1e:ag
- General Fu nd Ind. Mode1 Users Group Exepnse

8/15/2017 1558 . Weber , Scott • 54.10. 2 J 142 .34 s 142 . 34 (576597 and mi 1 eage

General Fu nd

8,115/2017 1520 Comcast 5244.9 s 140. 65 s 140 .65 (604572 Internet scrvi ccs for Au9usc 2017

Gcnl!ra l Fu nd

8/15/2017 ! 1394 News Di spatch 5'110.4 s 21. 71 s 21. 71 #1675 Legal for June vehicl e di sposi tion Slllc

' General Fund Radi D ads - Hebron Schools

8/15/2017 1164 Adams Radio Group 5610.5 s 3, 710.00 J 3, 710.00 U676 Gas Can Exchange

General Fund

6/15/2017 1544 BRYCO 5223.9 s 1,320.00 s 1,320.00 111677 C_hani ng servi ces far August 2017

General Fund Return of 1ocal match for

8/15/2017 1543 Ci ty of Hobart nlo, o i; 1,863 ,03 1 1,863.03 ns1a Tr.a.nsit Feasi. bi 1i t y Study

' Genera 1 Fund RC?turn of 1ocal match for

8/15/2017 1542 Ci ty of Portage 2210.0 s 7,744.49 s 7,744·4-!! #1679 Transi t Feasi bili tt Srudy

General Fund

8/15/2017 l528 Cl ver Art & Frame Co 5430.9 s .l!..84. s 366.84 #1680 off i ce suppl i.cs-Fo<1m Core o.il rds

General Fund AQ AdvC! rtisi ng i n Buil di ng

/15/2017 1054 Diversif i ed Mar)< ti n.9 5610.5 ' s 725.00 s (25 .00 #1681 Indiana m g.1zi ne

General Fu nd Ii 7/l th ru 8/0l/2017 Mt p•yroll

8/15/2017 .B-1661 INS-CCU 2145.0 s 68.00 s 68.00 #1682 Ch1ld Support w/h

Genera 1 Fund

8/15/2017 1541 On-S.i te ComR.uter 5243.9 1: s 1,733.00 s 1,733,00 #1683 IT sorvioos for July l017

General Fund

8/15/2017 15AP _Petty Cash - 5410.9 s 7.80 l 7.80 #1684 postJge purch sed :it post offi ce

General Fund

8/l,_S/20.17 _ 1540 P!:tY Ca.sh 5430.9 s 12.08 s 12.0B 116.8.4 pff.i ce suppli es

General Fund

8/lli2017 1516 SRf Cqn uJti.ng Group 5610..2 ll.•_574.41 s 11,574.41 11685 Hobart Transi t Feolsibi l i ty Scutly

General Fund '

1'8/15/2017 1479 Stapl es Busi ness Advantage 5430.9 i; 52.ll s 52.11 #1686 Office supplies

p General Fund

8/.lS/2017, 1491 svr. In.c... 5410.1 s 40..15 s 40.15 #1687 Cake purchased for rt!ti rcinnt

I General Fund AQ education & Outreach

8/15/20lZ_ 1104 The Times_ 5610.5 1. 300.00 1 30Q.OO #1688 Mob.i l o Ads -J uly 2017

eneral Fund

!8/15/2012 1537 'l"Q.tal Disposal 5223 .9 I s 72.40 ! s 72.40 #1689 Garb.s.gc pi ckup services for August 2.0.P

General Fund I I 7/H thru 8/02/2017 net payroll

i!/15/2017 1667 United Way of Porter Co 2147.0 s 49.85 s 49.85 #1690 p/r wi thholdi ngs

-l---

-..

Total : $ 88,988.71

Allow:mce of Claims

We have examined the claims listed on the toregoing Register ot'Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amount of _$__8_ ,9_&8_._7_1 _

Dated this _ day of_ __--'.1 2017 .

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, I N 46368

(219) 763-6060

This form oppro,•cd by the Stac Board of Accounts for use by

Date Filed

Claim

Nu mber

··-

Na me of Claimant

Fund

Fund Amo.unt

Amount of Claim

Check

# Notes

8/14/2017

1548

City of LaPorte

Agency Fund

5760.0

54,168.00

57832

1 Apr-June 2017 OA

8/14/2017

1547

Opportunity Enterprises

Agency Fund

5760.0

C578316

7/24 thru 8/02/2017 net payroll

net p1yroll

s 25,568.00 . s 25,568.00

8/14/2017

1549

South Lake County

Community Servi .es

Agency Fund

5760.0

34,489.00

CS78324

Apr-June 2017 OA

8/14/2017

1550

south Lake co ty

Communi ty Services

Agency Fund

5760.0

16,255.00

C578328

.Apr-J une PH

8/14/2017

1551

South Lake County

Community Services

Agency Fund

5760.0

32,207.00

C578330

Apr-June NF

8/15/2017

1625

Hori z"-1)_ Bank Stop Pymt Cha

General Fund

'bank fee

37.00

C584305

_ .5op payment bank fee

8/16/2017

1552

City of Va.l araiso, The

Agency Fund

5760.0

93,939.00

C583390

Apr-June 2017 CCC - V-Line

Apr-J une 2017 C<; .- Valpo Dash CCC

8/16/2017

1553

City _of Val parais.9, The

Agency Fund

5760.9

29,873.00

(583393

NJr-June Z017 CCC/ CMllQ

B/16/20.V

1554

City of Val paraiso, The

Agency Fund

5760.0'

59,566.00

C58399

V01lparai so Milrkt1ng

8/l/2017 I

1563

North Town.ship

Agency Fund

5760.0

123.854.00

123,854 .00

(583407

Apr-June 2017 0 OA

8/16/Wl7

1564

North Townshi.P

Agency Fund

5760.0

7,010.00

(583409

Apr-J. zo:i.r .f'fol

8/16/2017

1565

North Township

/'ogency Fund

$760.0

24,17§.00

24,176.00

C483402

Apr-June 2017 DA -

8/17/2017

1674

Porter County

Agency Fund

5760.0

5,045.00

5 ,045.00

C585200

Apr-J une Z017 ESM

8/17/2017

1557

Porter County

Agency Fund

5760.0

11,239.00

11.239.00 (

585196

Apr-J uc 2017 PM

8/17/2017

1555

Porter County ..

Agency Fund

5760 .0

41,172.00

41,172.00(

58°5192

!\pr-June ZDl7 PC QA

.._

, .,

- L

..-----

·- -

·"

thu Nor1hw st•rn lndiuna nelo-nal l'ln11n 1ng Commission (1985)

.. - -

s - /

s ,_ /

s - /

- - .. s - ./ -

s - /

s - v

I I

-- - s -

./ ·

- -

I - s /_

./ - -

I s - I

s -

I /

I / s -

s -

I ./ -

/• s -

/ - - s -

/ I

I s -

/ - s - -

/ s -

/. I

s -

- s - -

Allowance of Claims

We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the register such claims are hereby al lowed i n the total amount of _$_5_.5_8_,5_9_8._o_o__ _

Dated this ·- · day of .,)017.

N9RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060 '

This form approved by the Stae Boord of Accounts for use by

the Nort h western Indiana Rcnhin I Plannini;.Commission (1985)

Date Filed

Claim Number

Na me of Claimant

Fund

.Genera 1 Fund

Fund Amount .

Amount

of Claim

Check # 1

Notes

.8/2/20l.7 145.8

8/21/,2017 1461

(;ov' t Fi nance Off i cer_s ,o>.ssoc. 5410.9

General Fund Gov ' t Fi nance Off i cers Ass_oc 5410.9

General Fund

s 370.00! s .370.00 (82117 016 CAFR application fee

s 150 .00 s lS0.00 (82117 Job Posting fur Chief Accountant

8/21/2017

Stamps.com

5410.9

General Fund

s 39 .96 s 39.96 (82117 lune Admini stration postayc

8/21/20l7 1471 Stamps. cam_

81_2_112011 1471 .5 tamps. com

5410. 8 ·--· .

General Fund

5410.2

'General Fund

s 1.61 s

s 3. 43 :. . s

1.61,

(82117

3. 43

(82117

BC June postage

Plan!)ing Dept J4nC posta:gc

8/21/2017 1093 San1ps. com

8/2112011 I 1502 ZIP Recrui te.r 8;25;2011 i 1532 U .S. Bank Equi p Lease 8/ 25/20,1,7 1532 u.s. Bank Eq ui p L!!ase

- /25/2017 ' 1533 U.S. Bank Equi p _Lease

8/25/?.9.lJ.,': 1533 U.S. Bank Equi p Lease

8/25/2017 1533 U.S. Bank Equip Lease

I f

8/25/2017 1533 U.S. Bank Equi p Lease

5249. 9

General Fund

5410.9

General Fund

5241. 9

General Fund

5241. 9

General Fund

. 410.8

Gene ral Fund

5410.4

General Fund

.5410. 2

General Fund

.5no.s

s 24 .99 s 24.99 (82:1)7 ta0nthly 1;;srati on he- )uly 2017

1 month subscription -St<>.rtcr Plan ta

$ 249 .00 ' s 249.00 (82117 post three job posti nos

I 570.00 s 570.00 (393889 .4dini nis.tration co lor copi es for July 2017

I 1,044. 64 s 1,044.64 093889 Adm i 11istrJtior1 August 2017 copier lease

s o. 54 s 0.54 C393889 kROC-J uly Bl ack copies

s 2.80 s 2.80 C393889 Subgrantee Jul y color copi s

I 103.20 s 103.20 093889 Pl anning Oeot-Jul y color copies

s 0 .06 s 0 .06 . 093889 SEAC-Block copy for Jul y Z017

s - -

s - ./"

'; s - -

- I -·

._/. I -

s - I

s -

-- - s .

I ' s -

s -

-·

s - /

I /

- - s -

- s - I /

1 - /

- · ' /

- s -

v·

s - / /

s .-

.. s

- . '/

.. / s ·- -

s -

I ./ '

v·

/ s -

·-

/' s

s -

/ '

s -

/'·-

- -

,/ I s -

./ s -

/ s -

./ s -

/ s -

/ - - s -

/ I

.. - ..

s -

Total : s 2,560.23

Allowance of Claims

We have examined the claims listed on the toregoing Register of Claims, and except tor claims not allowed as shown on the register such claims are hereby allowed in the total amount of _S 2=,5-_6_0_-2_J_ __

Dated this _ _ day of

.:2017.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the Stae Board of Accounts for use by

the Northwestern Indiana Regional l'l•lll:li ll Commission (l985)

Register of Claims

Date Claim Fund Amount

Filed_ Number Name of Claimant Fund Amount of Claim Check # Notes

General Fund pay period 8/7 - 8/20/17 paid 8/29/2017

.a/29ao17 '1t .P/r Net Pay:.oll net p/ r s 35, 520 . 48 s 35 , 520.48 -·--·- hot payroll

General Fund I pay period 8/7 - 8/20/17 paid 8/29/2017 8/29/2017 net 11/r Net Pay ro.D net p/r s 3, 079.34 s 3' 0]9,34 -·-·- riet vacat.ion P.ay for A. o1J. rd

General Fund

8/29/2017 1546 Anthem BCBS 5142.9 s 15, 000.25 s 15 , 00D.25 (785404 ER paid Hlth for Sept 2017

General Fund

8/29/2017 1546 Anthem BCBS 5142.9 s (971.00) s (971. 00) C7.8.5404 R Paid adj fo.r K. Wenger 's Aug Premium

- General Fund

8/29/2017 1546 Anthem BCBS 2152 .0 s 2' 64.9 .12 s 2 .649.12 C785404 •Pt Hlth Ins o/r .withholdings

' . , General Fu nd

8/29/2017 1546 An them BCBS 2152. 0 s (171.28) s {171, ?8) C7854P4 \tithho)ding Aug premiwo odj for .el.1Y \longer

General Fund pay period 8/7 - 8/20/17 p._id 8/29/2017

B/29/2017 B-1709 Federal Taxes 2140.0 s 5 , 637.35 s 5, 637.35 Cl4109 Federal Tax withholdings

General Fund pay period 8/7 - 8/20/17 paid 8/29/2017

8/29/2017 8-1709 I FICA Taxes 2142 .0 s 7 , 264.66 s 7 , 264.66

General Fund

--(14109 FICA Taxes paid

FED Ta.>C Fi nal vacilti on pay for Anlahd.a Pollart

B/29/2017 . B-1715 Federal Taxes 2140.0 s 992 .99 s 992 .99 C32123 pay period 817 - 8/20/t7 pa id -i1,29no1z

General Fund FICA Fi nal vacati on pay for Amanda roll.a.rd

B/29/2017 B-1715 FICA Txes 2142.0 s 703.62 s 703 .62 C32123 pay period 8/7 - 8/20/17 paid 8/29/2017

General Fund ll SJ\ w/h Final vacuion pay for Amonda Poll arc 8/29/2017 8-1718 Hori zon Bank - HSA 2150.0 s 30.00 s 30.00 (600161 py period 8/7 - 8/20/17 paid 8/29/2017

General Fund pay period 8/7 - 8/20/17 p•i d 8/29/2017

/29/2017 B-1712 Ho ri zon Bank - HSA 2150.0 s 861.15 s 861.15 (600424 ttSA p/r withholdings

General Fund pay period 8/7 - 8/20/17 paid 8/29/2017

8/29/2017 1585 ICMA Reti rement Fund 5145.9 ! 765 . 00 s 765 .00 (600215 ER paid for TY Warner

General Fund pay period 8/7 - 8/20/17 p•id 8/29/2017

B/29/2017 8-713 ICMA Ret1 rement Fund 2146.0 s 610.00 s 610.00 (600215 ICMA p/r withholdi ngs

General Fund pay period B/7 - 6/20/11 paid 8/29/2017

B/29/2017 8-717 NPRS 2149.0 s 657.30 s 657. 30 (53527 PERF

General Fund pay pari od 8/7 - 8/20/17 paid 8/29/2017

8/29/2017 1588 INPRS 5141. 9 s 0.04 s 0.04 C53527 ER pid roundi ng adjustment

General Fund p._y period 8/7 - 8/20/17 paid 8/29/2017

B/29/2017 B-1711 INPRS 2149.0 s 5, 708.04 s 5 , 708.04 (53527 ER paid PERF

General Fund

8/29/2017 1586 Sostari c, Stephen 5410.2 ' s 60, 80 s 60 .80 (600398 lnileae

General Fund Eec. Di r. Conf Registr;r.ti on and

8/29/2017 1580 Warner 1 TY 410.9 s 472 . 70 s 472 .70 (600402 Pariag Chamber of Commerce Luncheon 4:'°p·e.nscf

General Fund South Shore to Cal umet Col laborative

8/29/2017 1580 Warner, T'(

15410. 5 s 17. 00 s 17 .00 (600402 Bo.ird Meeting expense

I General Fund

8/29/2017. 1580 WB:-rner , TY 5410.9_ s 29.96 s 29.96 (600402 mi leage

General Fund I i

B/29/2017 1580 Warner , TY 5410.5 s 2 .14 s 2. 14 (600402 mileage

General Fund RC!newal of support

B/29/2017 1587 AccuFund , Inc·. 5910.0 s 5, 962 .50 s 5 , 962.50 #1691 contract throllgh September 2018

General Fund NJ. Commercial s duri ng

.B/29/2017 1579 Adams Radio G roup 5610.5 s 7 , 000.00 s 7, 000.00 #1579 lake County Fai r

. .

(:>eneral Fund

8/29/2017 1571 BASIC 5410. 9 s 360.00 s 360 .00 #1693 Mnual fee for COBRA adininistration

Bl achl y , Tabor , General Fund

8/29/2017 1574 Bozi k & Hartman , LLC 5602.9 s 1,500.00 s 1, 500 .00 #1694 legal Servi ens for Sepcembor 2017

Ci ty of Portage for General Fund

_8/29/2017 1573 NIRPC offi ce space 5221. 9 s 17 ,434.62 s 17 , 434.62 #1695 Offi ce space lease for Se,ptember 2017 Ci ty of Portage for General Fund

8/29/2017 !_577 month..l y uti 1. i ti es 5224.9 s 2 , 362 . 30 s 2 , 362 . 30 #1696 August 2017 Uti 1i tios

·-

Diversified Marketing General Fund Lunch totes w/ Northwest Indi.lna Cl ean Ai r

8/29/2017 1482 Strateg i es 5420.S $ S , 418.74 s S , 418.74 #1697 Logo -

General Fund D@ntal Insurance

8/29/2017 1582 Heal th Resou rces, Inc-. 2153 '0 s 1,001.60 s 1,001. 60 #1698 for September 2017 wi thholdings IN Assoc of Regional General Fund .Regi onal Academy registration fee

8/29/201.7 1566 <;ounci l s 5146.9 . s 35 .00 s 35 .00 #1699 for TY \lfrner

General Fund pay period 8/7 - 8/20/17 paid 8/Z9/2017

_8/29/2017 81708 INS-\:;CU 214 .o s 68.00 s 68 .00 #1700 Child Support wi thholding

General Fund

8/29/2017 l.S,3 Ka.nsas City Insu ra,n,ce 5143.9 s _(;37 .04 s 637 .04 #1701 Pi sobi 1i ty Insurance f .or September 2017

General Fund

8/29/2017 1576 Treasurer of State 5603.9 s 10,845.00 s 10,845 .00 #1702 Annu•l Audi t for 2016

General Fund pay poriod 8/7 - 8/20/17 paid 8/29/2017

.B/29/2017 B-1714 United Way of Porter Co 2147.0 $ 49.85 s 49 .85 #1703 Uni ted Way wi thholdings

Agency Fund

8/30/2017 1510 Opportunity Enterprises 5760 .0 s 45.• 783. 00 s 45,783 .00 #C6P4975 PMTF Apr-June 2017 Port er County Agi ng Agency Fund

8/30/2017 1509 .and Community Servi ces 5760.0 s 22, 19.2 .00 s 22,192 .00 #(604951 PMTF Apr-June 2017

Agency Fund

B/30/2017 1511 North Towoshi p 5760.0 s 20, 000 .0Q I I $ 20, 000.00 IC604957 PMTF Apr-June 2017

South Lake County Agency Fund

8/30/2017 1508 Communi ty Servi ces 576.0.0 s 3.9, 475 .00 s 39,475.00 1(604958 PMTF Agr-J une 2017

General Fund

B/31/2017 ·.,;..'""' t;torizon Ban k Bank Fee-Aug s 50.80 s 50.80 ....... "-:-I:""< . Bank Jcrvi cc fee for Aug_ust 2017

. s : -

s - L--

..--

------

. s -

- . s -

.. .. s -

...----"' L----"' s

Total : $ 259, 095.11

Allowance of Claims

Dated this ____ day of __ , 2017.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the Stae Board of Accounts for use by

the Northwestern lndiana Regiona l PhinnT.n.g.Commi$sion (1985)

1Regi·ster :of Claims

Date Claim Fund Amount

Filed Num ber Name of Claimant Fund ' Amount of - Claim Check # Notes

General 9/12/2017 ----- Net Paryoll -V;>_cati,on PaY net p/ r

Fund I

I s

3, 333 .72 s 3, 333 .72 ----- !'.!et Final Vacation Pay-A.Hayes

9/12/2017

_ _ _ .,,_

General Fund i B/21/2017 th ru 9/l/2017

Net P<!yroll net _ p/ r s 32 , 216 .87 $ 32 , 216 .87 ...-:- ....- Net Payroll

General Fund ' S/21/2017 th ru 9/3/2017

9/12/2017 B-1760 Horizon Bank-HSA 2150.0 s 861.15 s 861.15 C622705 HSA deposits

General Fund I

I 9/12/2017

#1591 . EyeMed Vision Insu rance 2154.0 I s 116 .92 s 116 .92 C622754 Vision Ins for September 2.\)17

General Fund :

9/12/2017 #1616. ICMA Reti rement Fund 5145.9 s 765 .00 s 765. .00 C622738 . ER paid IOIA for TY Worner ---

General Fund B/21/2017 thru 9/l/2017

9/12/2017 8-1761 ICMA Reti remen1; Fun.d 2146_.0 1. s 610.00 s 610.00 !=622738 [CM w/h 's

General Fund

9/12/2017 11614 Ibrahim , Eman 5410. 2 s 25 .84 s 25 . 84 C62Z806 mi l eage

Ceneral Fund i

9/12/2017 #1615 Sostaric, Stephen ' .5410.2 s 60.80 s 60.80 C622790 . mi lea.ge

General Fund Registrati on for AccuFund Conference

9/12/2017 #1617 Luther , Kathy .· 5410. 9 I. S 95 ,00 s 895 .00 C622785 l!JCP.ense

General Fund '

9/12/2017 #1603 Hammond, Al l en 5410.4 . 106 .40 s 106.40 Clin779 mJlea9e

General Fund

9/12/2017 #1601 Bi ci u nas , Gabriel l e 5.41.Q. 2 ' s 9 . 50 s 9 . 50 CR277§ iJ . g:

General Fund

9/12/2017 ;1!1602 Warner, TY 5410.1 I S 17 .12 s 17.12 C622766 l'l!i leage

I General Fund

9/12/2017 #1602 Warner. TY 5244.9 s 125 .00 S, 125.00 C622766 Septber Connunications per co(\trcc

General Fund

9/12/2017 #1602 Warner, TY 5410.l . s 36 .67 l 3.6 .67 C622766 Lunch meeting

General Fund

9/12/2017 !!1595 Warner, TY 5410.9 s 333.31 33,3. 31 C622.764 _111ilea.9e

Genera 1 Fund

9/12/2017 #1595 Warner . TY 5410.9 t 40,5 .86 .s 405,6 C622764 c;!. P- .!1. . s

General Fund 7 10 thr 7-23-17 ·p;.yroll paid 8-1-2017

9/12/2017 8-1625 IN Dept of Revenue-State 2143.0 s 1, 584 .0.0 s 1, 584.00 C642026 t;.>• w/h ' s

Generl Fund · 7-10 thru 7-2317 payroil paid 8-1-2017 9/12/2017 B-1625 IN Dept of Revenue-County 2144.0 s 41).. 39 4ll,, 642026 tax w/h ' s

General Fund final Vac Payroll for K. Wengor

9/12/2017 B-1631 IN Dept of Revenue-State 2143.0 ' $ 202 .17 s 202 .17 C642026 : t•x w/h ' S--

General Fund I Final Vac Payroll for K . Wenger 9/12/2017 8-1631 IN Dept of Revenue-County 2144.0 I S 30.63 .s 30 .63 C642026 tax w/h 1 s

General Fund va.rone si f i rst f uli-timo pay week - 8-ll-ZOli 9/12/2017 B-1669 IN Dept of Revenue-State 2143.0 s 23. 79 s 23 .79 C642026 ;ii< w/ h 's I

General Fund Verones i fi rst full-ti•>< pay week - 8-15-lOli 9/12/2017 B-1669 IN Dept of RevE!_nue-County 2144.0 . s 3.61 s 3. 61 C642026 t.lx w/h ' s

Generl Fund I 7-24 tn ru 8-6-2017 paid a-15-1017 9/12/2017 B-1663 IN Dept of Revenue-State 2143.0 n s l, 519.13 s 1, 519.13 C642026 tax w/h 's

Generl Fund 7-24 thru 8-6-2017 paid &-15-1017

9/12/2017 8-1663 ' IN Dept of Revenue-County . 2144.0 s 398.57 $ 398. 57 C642026 til.X W/h' s

I General				Fund							8-7 th ru S-20·2Ql1 poid on 8-H-10 17
9/12/2017 B-1710 IN Dept of Revenue-State 2143.0					s	1, 546.75	s	1,546 .75	(642026		ca.x W/h ' s
General				Fund							8-7 thru 8·20-2017 paid on 8-29·2017
9/12/2017 I B-1710 IN Dept of Revenue-.t;:ounty 2144 .0					s	416 .50	s	416. 50	(642026		tax w/h 's
General				Fu nd							0 F in>l Vacati on Pay for Amanda Pol hrd-p/r 8-i
,9/12/2017. 8.-1716 IN Dept of Revenue-State 2143 ,. 0					s	151. 76	s	151.76	(642026 w/h 's I
I General				Fund					Final Vacotion Pay for Amanda Pollard-p/r 8-i
9/12/2017	B-1716	IN Dept of Revenue-Couri .ty 2144 .0			s	22 .99 -	s	22 . 99 I	C642026		t ' w/h 's
				Gene ral	Fund
9/12/2017	#1605	I Comcast Internet		5244.9		s	140.65	s	140.65	Cl31311	Internet Se.r\li ces for September 2017
				General	Fund						8/21/2017 thru 9/3/2017
9/12/2017	8-1759	IPRS		2149.0		1	5 , 546,70	s	5 , 516. 70	(988577	EmpPerf - payro 11 poi d 9-12 -2017
				General	Fu nd				'		Final Vac. pay for A. Hayes
9/12/2017	B-1765	INPRS		2149 .0		s	671. 78	s	671. 78	(988577	EropPerf • payroll paid 9-12-2017
				General	Fund						8/21/2017 th ru 9/3/2017
. 9/12/2017	#1618	INPRS		5141. 9 -		s	0.03	1 -·· 0.03 (88577 1 ER paid roundi ng adjustment
				General	Fund			Finol Vac. pay for A . Hayes
' 9/12/2Dl7	8-1763	Federal	Taxes	2140.0		$	855.48	s 855.48 (676523 tox w/h 's
				General	Fund						Fi n•l Vac. pay for A. H<1ycs
9/12/2017	8-1763	. FICA Taxes		2142 .0		s	723 .82	s	.723.82	(676523	FICA tax ER & EE
9/12/2017	B-1757	Federal Ta•es		General 2140.0	Fund	s	5 , 070. 57	s	5 ,070. 57	C80Z905	8/21/2017 th ru 9/3/2017 t•• w/h's
				General	Fu nd						8/21/2017 thru 9/3/2017
9/12/2017	B-1757	FICA Taxes		2142,,_0 General	Fund	s	6 ,60 .os	s	6,6Qg.O_	C802905 1	FICA tox ER & EE -
9/12/2017	1526	185 Heral d Argus		5410.		s	lJ.26	s	11.26	1704	Legal notice for Legal $. rvi ces
				General	Fund
9/12/2017	1594	AEAP		5146,.9		$	39.00	s	39.00	1705	1 yr embership for Mary Thorne
				General	Fu nd
9/12/2D17	1608	An hem Li.fe		5143.9		s	346.20	s	346. 2Q_	1706	Life Ins for September 2017 -
				General	Fund
9/12/2017	1608	An them L.if e		2155 .0		s	196.25 .	s	196.25	1706 Opt Life Ins for September p/r wi thholdings
				General	Fund
9/12/2017	1607	BRYCO		5f 23. 9		s	1,320.00	s	1,320.00	1707 leaning srvc.s for Scpteinber 2017
				General	Fu nd					:f hink Server, License:s , Gen5-powc.r
9/12/2017	1497	CDW-G		5910.0		$	6, 936 .92	s	6 ' 936. 92	1708 Hard ._?rive , etc.
				- General	Fund
9/lZ/2017	1054	Diversif i"'d Mar keti ng		5610.5		s	725 .oo	s	725.00	1709 ftlJ. Adverti si ng i n Bui lding Magazi nc
				General	Fund
9/12/2017	1525	Dunes Learni ng Cen ter		561D.S		s	830 . 26	s	830.26	1710 Propane fuel Reinbursemcnt thru 6/30/2017
		Indi ana T ranspor tati on		General	Fund
9/12/2017	1609	As:sociation, Inc .		5410.2		s	50.00	s	250 .DO	1711 onferenc Reg . for Ja11es Vii ntcrs
				General	Fund					8/11/2017 th ru 9/3/2017
9/12/2017	B- 1756	INS-CCU	2145.0		l s	68.00	s	68.00	1712	Child	Support
					Total :		$	76, 571. 45

Allowance of Claims

We have examined the claims l isted on the foregoing Register ot' Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amount of _$_-'-7-6-''5-_7_1.4__5 _ _

Dated this _ day of

2017.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219} 763-6060

This form npprovcd by the Stae Board of Accounts for use by

the Northwestern Indiana Regfph· 1 Planning Commission ( 1985)

Date Cl a im Fund Amount

!Filed

- _ 1'fum(!cr Name of Claimant Fund Amount of Claim Check # .Notes

I General Fund

:9/12/2017 1536 McShanes Busi ness Prod.ucts 5430.9 s 70.4.• 24 s 704.24 1713 i nk car:-..tridges for plotter

General Fund

9/12/Q.17 1604 On-site Computer ,5243. 9 $ l,_733. 00 s 1,733.00 1714 IT Support •orvi ces for Aug 20V

General Fund G Suite Business lic.ense Subscri tfon Renewal

9/12/2017 1517 ONIX Networki ng Corp . 5910 .0 $ 1,450.80 s 1,450.80 1715 to Us.c Gmai 1 and various G Suite •RP .

Gene ral Fund

9/12/2017 ..

1606 - P.et.ty. Cash 5410.1 s 48.00 s 48,0.0 1716 Hoos.ie.I'.' B for MPO Conference

Ge-;;eral Fund

9/12/2017 1613 'stapl es Busi ness... Acly ;:'!Jl 5.43.o. 9. $ 78.60 s 78.60 1717 of fice supplies

' General Fund

9/12/2017 1567 Stapl es Business Advantage 5430.9 $ 851.11 s 851.11 1717 office suppl.1es.

General Fund

9/12/2017 1535 Stapl es Business Advantage 5430. 9 s 180.18 s 180.18 1717 Offi ce suppli es

General Fund

I .

9/12/2017 1530 The Times 5410. 9 s 11.57 s 11.57 1718 L:egal not1 ce for lega.1 Sarvi ces

General Fund

9/12/2017 1600 Total Disposal 5223.9 s 72.40 s 72 .40 1719 Sept services for garbage pickup

United Way General Fund S/21/2017 th ru 9/3/2017 9/12/2017 8-1762 of Porter County 2147.0 s 49.85 s 49.85 1720 p/r withholdings

USA Muffl er General Fund Brakes servi ce and part.s

9/12/2017 1596 and Brakes 5410.2 s 1,670.57 $ 1,670. 57 1721 for NIRPC' s \/an

General Fund Travel expense reimbursement

9/12/2017 1622 Wadsworth , Trey Joseph 5410.1 $ 419.14 s 419.14 1722 for job interview with NIRPG

General Fu nd

.9/12/2017 1584 :Comcast 5244 .9 s 1, 297.54 s 1,297.54 CS52054 1 voi ca edge. sa.rv1 ces for August 2017

s -

$ - -

I s - -

s ;/'"

J/ _

./. ·

.,,.,...,. . -

s -

s - I

s -

- - - /

s - /

), - /

s - ./

s -

- /'.

' s - /

s /

s /_

/' s -

,/ s -

...

- / s -

.. /-

v s

s -

/ - -

.. s -

s -

/ I s -

- -

s -

I v

- ·

/ s

/ '

s -

Total: 8,567.00

Allowance of Claims

Dated this day of ,,-- ,, 2017.

Credit 'ard l"olicv rev 08/ 14/2017 KJL

Authorization for the Issuance of a Corporate Credit Card for NIRPC

The Northwestern Indiana Regional Planning Commission (NIRPC) authorizes the .Chief Financial Officer to apply for a corporate credit card for legitimate.;;._. official Commission use only. .

_..-

Deleted: Director of Finance and Administration

Specific purposes for which this card may b.e used Include making Commissioner and employee travel plans, such as airline tickets, hotel reservations and

conference registrations, as well as other limited Commission purposes for which it is deemed desirable or financially advantageous to utilize the card. The card may not be used to bypass the accounting system.

The board designates the issuance of two cards under this corporate account to

the following NIRPC employees: The.Office Manager and the Chief Financial --- Deleted: Administrative Assistant to lhe Executive

Officec Director

}'- -<

--- Deleted: Director of Finance and Administration

The credit cards are to be kept in the office of the Northwestern Indiana Regional Planning Commission at all times unless specia l authorization I s given by the Executive Dire.ctor In adva nce for a s pecific da te and purpose. The credit cards will be secured in the business office at all times when they are not in use.

All charges placed on the credit card must be pre-approved by the Executive

Director (or.Chief of Staff in his or her absence) in writing on the request to order --{ Deleted: Deputy Director

goods and services form. ---- ----------

Documentation to support paying the credit card invoice must be as detailed as any other purchase on behalf of NIRPC.

PROPOSED 2017 BUDGET AMENDMENT

Additional Funds

Amendment 5: To add new revenue

TO: Commission/Ex. Director Communications and Contractual

Purpose: To add new funds to the 2017 budget.

These funds are revenue generated through registrations and sponsorships for the 2017 Indiana MPO Conference.

DETAILED BUDGET LINE	Original	Addition	Amended
Revenue: 2017 MPO Conference		27,000	27,000
Expenses: Communication	36,500	2,000	38,500
Expenses: Contractual		25,000	25,000

Procurement Recommendations September 21st, 2017

NIRPC Computers & Sound System - Procurement #17-14

Purchase computers, hardware and software upgrades, and a sound system for Northwestem Indiana Regional Planning Commission
Paid with Federal Transit Administration Funds (80%) out of grant IN-2016- 033 and the local share coming from the above listed agency (20%)
Recommendation to purchase computers hardware and software upgrades and a sound system not to exceed $120,000.00 in federal funds

NIRPC 2017 MPO Conference - Procurement #17-18
Secure a contract for the supply of food and audio visual equipment with the Stardust Event Center in Michigan City, the venue where the 2017 MPO Conference will be held. Procure items necessary for holding the conference including miscellaneous supplies, swag, awards, and bus rental for the mobile tours.
Recommendation to award a contract and procure required items for the 2017 MPO Conference in an amount not-to-exceed $30,000 .

PART I. BASIC AGREEMENT BETWEEN THE NORTHWESTERN INDIANA

REGIONAL PLANNING COMMISSION AND Eco-Interactive, Inc FOR Electronic Transportation Improvement Program (eTIP) System PROCURED UNDER RFP

#17-15.01

By agreement entered into by and between the Northwestern Indiana Regional Planning Commission, hereinafter referred to as the Commission, and Ecolnteractive , Inc. hereinafter referred to as the Contractor, the following is hereby mutually agreed to:

Construction of Agreement:
This agreement consists of four parts: (1) the basic agreement, (2) scope of work, (3) required forms, and
(4) any and all general terms and conditions required by the Indiana Department of Transportation and Federal Highway Administration . Each of these parts is hereby made a part of this agreement. The Commission shall be governed by and the Contractor shall comply with all terms and conditions set forth within all parts of the Agreement.
Description of Services provided by the Contractor:
The Contractor shall provide the following: Customized Project Tracker Software as a Service. The Contractor shall perform the services to the satisfaction of the Commission as provided for in the scope of work which is described in Part 2 of this Agreement.

The Commission requires prior approval of the use of any Sub-Contractors for this agreement and a copy of the executed agreement between the Contractor and Sub-Contractor.
Compensation:
The Contractor shall provide the identified goods and services as noted in Part 2 of this Agreement, for a cost not to exceed $135,000, at a cost of $45,000 per year for 3 years.

Optional Extension Year 4 billed at $46,344 per year Optlonal Extension Year 5 billed at $47,736 per year.

Payment for services provided by the Contractor will be on a reimbursement basis and in accordance with procedures provided for in the Terms of Agreement section of this Agreement.
Terms of Agreement:
The Contractor shall commence service hereunder on the October 1, 2017. ProjectTracker Saas features will be available based on scheduled outlined in scope of work. NIRPC will notify contractor within 3 months of the end of contract of intent to continue with optional year extensions .
Payment Procedures:
The Commission shall make periodic payments to the Contractor for services rendered in conjunction with this Agreement in the following manner:
1. The Contractor shall submit monthly invoices in the amount of $3,750 to the Commission, which are sent the last week of the month for services rendered for that month.
2. Following its approval of the invoice submitted by the Contractor, the Commission shall make payment. Payment will normally be made within thirty days after said approval.
3. All invoices shall be submitted to: Accounts Payable
  
  Page 1 of 3
  
  Northwestern Indiana Regional Planning Commission 6100 Southport Road
  Portage, Indiana 46368
Modification Provisions:
This Agreement shall not be modified except in writing, signed by both parties to this Agreement. Further, the parties hereby agree that the Commission may hereby modify Part 2 to this Agreement by adding, deleting or modifying tasks, subtasks, schedules or the content or quantity of products to be produced by the contractor to the extent that such modifications result in no upward or downward cost adjustment.
Termination:
Either party may terminate the agreement by providing a written notice at least thirty (30) days prior to an effective termination date, which shall coincide with the last day of a calendar month. In the event of termination, the Commission shall be obligated to pay the Contractor only for services rendered and expenses incurred through the date of termination .
Agreement:

It is hereby agreed and understood by the party's signatory hereto that this Agreement becomes executed when the appropriate signatures are affixed hereto and the date of contract award is established as the twenty-first (2Pl) day of Septe mber, 2017 .

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

By: By:

Tyson Warner Executive Director

NAME

Date: Date:

Attest:

Kathy Luther Chief of Staff

Page 2 of 3

PART II. SCOPE OF WORK

Page 3 of 3

Ecolnteractive

I N N O V A T I V E D A T A S O L U T I O N S

Fee Schedule
Eco Interactive will provide the ProjectTracker Saas solution for the NIRPC to access over the Internet for use by NIRPC and their member agencies/stakeholders to manage TIP transportation projects. NIRPC is requesting Ecolnteractive's standard level of service. This proposal is for services only (NIRPC receives no deliverables for this project and no professional services or works for hire are included) . No subcontractors, DBEs, or travel are included or will be utilized in this scope of work.

Phase 1: One-time customizations for N IRPC's specific needs
Ecolnteractive will invest up to 200 hours over the first six months for customizations, data import, and initial start-up services . Ecolnteractive is committed to a long-term relationship with NIRPC and it is important for this process to meet your requirements. Ecolnteractive considers these one-time costs as an Ecolnteractive investment in the ProjectTracker Saas solution for NIRPC. Ecolnteractive is offering NIRPC an annual ProjectTracker Saas package that includes:
- TIP & LRTP Project Modules (includes amendment/adoption process)
- Obligation tracking module,
- Document management module,
- GIS module,
- Flexible, dynamic reporting module,
- Public web site module
- Call For Projects Module

A fixed monthly subscription fee will be billed at the end of each month following contract initiation. During the first few weeks, Ecolnteractive will give access to the new ProjectTracker Saas established for NIRPC. Following the software installation and web site creation, Ecolnteractive will import NIRPC data and NIRPC will begin to review the functionality of the ProjectTracker Saas. During weekly online meetings, NIRPC will identify needed customizations to adapt the software to NIRPC business processes. Implementation and scheduling is discussed below.

Phase 1: Tasks & Milestones

Ecolnteractive has proposed the following 6-month timeline. NIRPC may adjust or reprioritize the order in which modules are implemented. On-going Saas will begin immediately following the completion of the Phase l.

7 1 P a g e

Ecolnteractive

I N N O V A T I V E D A T A S O L U T I O N S

Re$ponsive and userfriendly search tools Profect M anagement Screens

Electronic 71P/Profect Submission

Review & NohJlcation of Electronic Submiss'ion

Automated data sharing

LRTP screens

Historical Data Import

This is a standard part of the six-month customization process for ProjectTracker Saas. Ecolnteractive will utilize internal tool sets and our extensive experience and talented staff to support this data conversion and migration from multiple disparate data systems. Ecolnteractive has implemented the ProjectTracker Saas solution for many customers in less than six months. This includes migration of

B l P a g e

Ecolnteractive

I N N O V A T I V E D A T A S O L U T I O N S

historical data from disparate sources into the new ProjectTracker Saas. Ecolnteractive has worked with many historical datasets as well as successfully integrated data from other internal databases and external sources. Ecolnteractive's extensive knowledge of transportation data helps insure that our staff can quickly understand and use internal tools to import data into the ProjectTracker Saas to meet the NIRPC's unique needs. Ecolnteractive is uniquely qualified for this project as Ecolnteractive has routinely completed many other similar projects for transportation agencies with great success. Ecolnteractive expects to establish the NIRPC's ProjectTracker Saas infrastructure in the first 4 weeks. An initial customized version of ProjectTracker Saas, including the upload of NIRPC data, will be up and running within the first 12 - 16 weeks of contract award.

Phase 2: Provide Ongoing ProjectTracker Saas for NIRPC

Ecolnteractive is committed to providing long-term ProjectTracker Saas to NIRPC. Ecolnteractive will continue to bill the same fixed monthly subscription fee as it did in Phase 1for Phase 2. The monthly Saas subscription fee will cover Software maintenance, Saas hosting, help desk support, and include a package of up to 120 support hours annually that can be used to make enhancements to the system including (but not limited to) new reports, help desk support, tracking new values, or modifying business rules. The help desk allows clients to meet changing user requirements for the duration of the contract. The help desk provides fast response and quick turnaround technical support.

Cost

-.:Y.. .ea ActMw Cost
Year 1	12 months ProjectTracker SaaS* Ecolnteractive will invoice $3,750 monthly (for year 1service following contract award)	$45,000*
Year 2	12 months ProjectTracker Saas Ecolnteractive will invoice $3,750 monthly	$45,000
Year 3	12 months ProjectTracker Saas Ecolnteractive will invoice $3,750 monthly	$45,000
Total		$135,000

The annual fee is expected to be a complete package covering secure site, public portal, maintenance, helpdesk support, hosting, security, business rule changes, and software changes/enhancements. The annual fee includes up to 120 hours per year for additional technical support. Future annual pricing shall include a small increase in Saas fees (similar to CPI) to offset the rate of inflation.

*This incl u des the ProjectTracker Saas i n iti a l 6-month startu p where Eco Interactive invests u p to 200 ho u rs to com plete im plementation and customization.

Optional Year 4

12 months ProjectTracker Saas Ecolnteractive will invoice $3,862 monthly

Optional 12 months ProjectTracker Saas

Year 5 Ecolnteractive will invoice $3,978 monthly

$47,736

9 I P a g e

Ecolnteractive

I N N O V A T I V E D A T A S O L U T I O N S

* * Includes a small increase in Saas fees (similar to CPI) to offset the rate of inflation.

Assumptions for this fee schedule:

Software Ownership - Ecolnteractive will provide the ProjectTracker Saas solution for the NIRPC as a service over the Internet for use by NIRPC and their member agencies/stakeholders to manage eTIP transportation projects. This proposal is for services only (NIRPC receives no deliverables for this project). To the extent that Ecolnteractive, Inc. utilizes any of its property (including, without limitation, the Eco Interactive, Inc Technology, ProjectTracker software, or any hardware or software of Ecolnteractive, Inc) in connection with the performance of services hereunder, such property shall remain the property of Ecolnteractive, Inc. and, except for the use expressly granted in this engagement, the NIRPC and their member agencies, shall acquire no right or interest in such property. Nothing in this Agreement or proposal shall be construed as precluding or limiting in any way the right of Ecolnteractive, Inc. to provide services of any kind or nature whatsoever to any person or entity as Ecolnteractive, Inc. in its sole discretion deems appropriate. In addition, and notwithstanding anything in this Agreement or proposal to the contrary, the parties acknowledge and agree that (a) Ecolnteractive, Inc will own all right, title, and interest, including, without limitation, all rights under all copyright, patent and other intellectual property laws, in and to the Ecolnteractive, Inc. Technology and (b) Ecolnteractive, Inc may employ, modify, disclose, and otherwise exploit the Ecolnteractive, Inc. Technology (including, without limitation, providing services or creating programming or materials for other clients).
NIRPC will own and be responsible for the quality of data in the customized ProjectTracker Saas application at all times.
NIRPC will identify in writing any confidential information or data .
NIRPC will not enter or track medical records; personnel records, home addresses and phone numbers of any person, social security numbers, credit card numbers, bank account numbers or any other Personal Credit Information or Personally Identifiable Information in the ProjectTracker Saas.
NIRPC will be responsible for authorizing access to the ProjectTracker Saas system for their staff, member agencies, and other users.
NIRPC will provide a key point of contact to act as the interface between Ecolnteractive and NIRPC.
At end of the contract period, if the Saas fees are not renewed, or the contract is terminated, Ecolnteractive will transfer all data files to NIRPC (in MS Access, DBF or other standard data format), and the ProjectTracker Saas web site will be taken offline .
ProjectTracker Saas will provide access to an electronic street map GIS interface. NIRPC will provide other GIS map data (and any licenses required), which NIRPC wants to use in the ProjectTracker Saas online mapping/database applications.
Ecolnteractive's liability for damages to NIRPC for any cause whatsoever, and regardless of the form of action, whether in Contract or in tort, shall be limited to 12 months of service fees.

J . Copies of relevant certifications and qualifications

None Applicable .

lO I P a g e

EcoInteractive

I N N O V A T I V E D A T A S O L U T I O N S

Appendix A. Staff Resumes

Dr. Anne M. Happel

DIRECTOR

Dr. Happel has more than 23 years of information technology management and scientific experience . She led the development of the ProjectTracker solution. She has significant experience understanding transportation business processes and dataflow between the local agencies, MPOs, state and federal agencies.

She is a leader in re-engineering government processes to effectively use the Internet to save resources and streamline data sharing. She uses advanced innovative information technology and geographic information system solutions to build new Internet-based solutions for government and private industry. She has consistent success in implementing creative solutions and developing products that exceed customer expectations.

Dr, Happel has worked with MPOs, DOTs, Federal agencies, and local agencies to streamline the tracking and integration of transportation data for over 12 years. Her extensive understanding of the full life cycle of the transportation business process and the complexities of the roles of DOT programs, local agencies, the MPO, State and Federal agencies has greatly contributed to the success of Ecolnteractive's ProjectTracker Sa as.

Example Relevant Experience

Provided project management and completed the requirements for the customization of all customized ProjectTracker Saas systems.
Completes facilitated JAD sessions, requirements analysis, business planning, project management, system design, and implementation tasks supporting new customizations of ProjectTracker. Manages software functional development to support customer applications.
Key point of contact for Ecolnteractive ProjectTracker Saas. Manages the ProjecTracker Saas helpdesk and programming team .

EDUCATION
BS - PURDUE UNIVERSITY
PhD - Harvard University

EXPERTISE
Management Consulting
+ Information
Technology
Environmental Management Systems
+ Strategic Planning
+ Large System Development and Integration
Data Warehouse

+ Project Management

+ Knowledge Management

+ Business Process Reengineering

+ Internet Strategy

+ Data Conversion

+ Software

Manages Ecolnteractive team's customization process. Development
Reviews ProjectTracker Saas user testing results and electronic data sharing • System processes to ensure that ProjectTracker Saas is meeting or exceeding client's Implementations

needs.

Lead and managed multiple large scale complex systems developments .

YEARS OF EXPERIENCE

Established the help desk processes, prepared documentation and training . _ J

materials, and conducted statewide training sessions for thousands of regulated businesses and hundreds of regulators.

Lead and managed FMIS 5.0 integration effort including advanced obligation/expenditure reports.
Lead and managed development and integration of pavement condition module that acts as a repository and analysis tool for agencies across the MPO.

11 I P a g e
Ecolnteractive
I N N O V A T I V E D A T A S O L U T I O N S

Michael Legg
TECHNICAL DIRECTOR

EDUCATION
BSE - Computer Science and Engineering,
University of California at Davis

EXPERTISE
Mr. Legg has managed and developed major, multi-year application system development projects providing enterprise wide solutions supporting government organizations and private sector companies in the environmental industry for over 23 years. He has consistent success in implementing creative solutions and developing products that exceed customer expectations. For example, he was the technical force in creating the ProjectTracker software.

+

+

+

+

+
+

+
+
+

+
Large System
Integration Information Technology Business Process Reengineering System Architecture Internet Strategy Project Management Database Design Data Conversion Software Development System
Implementations
He manages contractual relationships with clients; manages statewide implementation and Software as a Service; defines the project approach, methods and staffing; conducts quality assurance over key project deliverables; resolves issues with staff, tools, and methods; and participates in project status and steering committee meetings to resolve all technical issues.

RELEVANT EXPERIENCE
Designed, developed, and customized the ProjectTracker software. Directed
programmers and staff in the programming, testing, data migration, and implementation of the solution.
Manages Ecolnteractive's Software as a Service infrastructure and ongoing
maintenance projects for multiple applications. Leads the technical team for database, GIS, Internet security, capacity planning and other Saas services .
Managed and led the technical development of multiple large scale complex
projects.
YEARS OF EXPERIENCE
23
- Architected, designed and help develop statewide system which provides services for 1000s of secured users and has receives more than 100 million hits annual. The system processes millions of electronic submittals annually and contains more than 500 million records. Designed and developed electronic compliance submission system which at the time was the largest electronic reporting program of its kinds
  nationally and continues to serve as a national model of a robust, large-scale, successful e-government program .
- Led development of system to integrate intelligence data into GIS system. System houses billions of data elements and responds to queries in less than 1second. Integrates data from multiple data systems, creating a single decisions support system that allows users to create rules governing data integration

Developed comprehensive auditing system controls infrastructure to allow for DevOps environment while creating controls to support AICPA audits.

TECHNICAL SUMMARY

Oracle, Microsoft SQL Server, ESRI Products, ProjectTracker technology, Visual Basic, Access, Paradox, Sybase, Powerbuilder, ERwin, FoxPro, SQL, HTML, ASP, ASP .NET, JSP,Java, Novell 3.X, 4.X, Windows 2000 / 2003 / 2008, C, Pascal, Delphi, Solaris, Linux, Internet Security, network communications, individual component selection and integration, performance analysis, data conversion and migration.

12 I P a g e

EcoInteractive

I N N O V A T I V E C A T A S O L U T I O N S

Vo Tran

SENIOR SOFTWARE DEVELOPMENT ENGINEER

Mr. Tran constructs interfaces, conversion, screens, reporting, and/or application programs. Implements project plans. He supports all phases of the software development life cycle. Analyzes information requirements; develops appropriate corrective support actions. He designs, programs, tests, and implements software solutions for our clients.

He has experience working with EcoTracker technology and supporting ProjectTracker-based Internet-based Saas solutions. He has consistent success in implementing creative solutions and is committed to developing products that exceed customer expectations.

EDUCATION

BSE - Computer Science and Engineering,

University of California at Los Angeles

(UCLA)

EXPERTISE

+ Large System Integration

Manages software development and maintenance for the EcoInteractive

Information

RELEVANT EXPERIENCE

ProjectTracker Saas solutions supporting for example: large MPOs like Los Angeles County Metropolitan Transportation Authority (Metro), San Diego Association of Governments (SANDAG), the Orange County Transportation Authority (OCTA), and Chicago Metropolitan Agency for Planning (CMAP) as well as DOTs like the Nevada Department of Transportation (NIRPC) and other ProjectTracker customers.

Leads/Manages helpdesk support for Ecolnteractive's ProjectTracker Saas.

Has insight into TIP and LRTP transportation project business processes to answer user questions and to meet user needs.

Leads the development of a ProjectTracker financial application for the San Diego Association of Governments and Orange County Transportation

Agency. This application interfaces with ProjectTracker, which is a Saas solution.

Developed FASS data system for CalTrans to manage RTIP data uploads from

agencies state-wide for CalTrans CTIPS data system.

Technology

System Architecture
Internet Strategy
Project

Management

Database Design

Data Conversion
Software
Development
System Implementations

YEARS OF EXPERIENCE

Developed automated data exchange system between ProjectTracker Saas and Southern California
Association of Governments (SCAG) data system, including business rules, error checks, and import of data into SCAG data system.
Developed GIS mapping applications for mapping of project locations - street segment(s) and node(s) - and

integrated, flexible GIS reports. Created GIS real-time downloads in multiple formats.

Developed flexible tracking system for financial constraints reporting, tracking of revenue and fund balance.

Developed customized payment module for managing billions of dollars in payments to local agencies for project expenditures. Includes electronic receiving system, automated email notification, and integration with business process and institutional financial management systems.

TECHNICAL SUMMARY

Oracle, Microsoft SQL Server, ESRI Products, ProjectTracker technology, Visual Basic, Access, Paradox, Sybase, Powerbuilder, ERwin, FoxPro, SQL, HTML, ASP, ASP .NET, JSP, Java, Novell 3.X, 4.X, Windows 2000 / 2003 / 2008, C, Pascal, Delphi, Solaris, Linux, Internet Security, network communications, individual component selection and integration, performance analysis, data conversion and migration.

13 J P a g e

Ecolnteractive

I N N O V A T I V E D A T A S O L U T I O N S

Evan Scarisbrick

SENIOR SOFTWARE DEVELOPMENT ENGINEER

Mr. Scarisbrick constructs interfaces, conversion, reporting, and/or application programs. Implements project plans. He has significant experience directing all phases of the software development life cycle. He led multiple project development efforts to successful implementation.

Releva nt Experience:

Supports software development and maintenance for the Ecolnteractive ProjectTracker Saas solutions supporting for example: large MPOs like Los Angeles County Metropolitan Transportation Authority (Metro), San Diego Association of Governments (SANDAG), the Orange County Transportation Authority {OCTA), and Chicago Metropolitan Agency for Planning (CMAP) as well as DOTs like the Nevada Department of Transportation (NIRPC) and other ProjectTracker Saas customers.

Supports helpdesk for Ecolnteractive's ProjectTracker Saas solutions supporting

multiple customers.

Has significant knowledge and insight into TIP and LRTP transportation project business processes to answer user questions and to meet user needs.

Managed the development of several major subsystems, complex reports, robust data entry processes, and implemented the solutions using the State of California

standards and procedures.

EDUCATION

BSE - Computer Engineering,

University of California at Davis

EXPERTISE

+ Large System Integration

Information
Technology
Business Process Reengineering
Internet Strategy

Database Design

Data Conversion
Software

Development

System Implementations

Customized and enhanced ProjectTracker software to support statewide YEARS OF EXPERIENCE
applications to manage electronic reporting and receiving on a massive scale. 17
Led development for statewide system that automated electronic reporting of
local governments to the state. This system streamlined what was a paper process and saved countless hours of manual review.
Led development team to create pavement management system integrating mobile, desktop, and GIS systems
to report and manage pavement quality data to support better decision making.
Developed and deployed comprehensive data validation and data management solutions for multiple customers, improving data quality, information security, and data integrity.

Increased efficiency and data quality for multiple organizations by automating complex, multi-step processes.

Tech nical Sum ma ry

Oracle, .NET, C#, CSS, Java Script, JQUERY, Crystal Reports, JDeveloper, CVS, Visual Basic, SQL and PL/SQL, HTML as a SQL client, Crystal Reports, EcoTracker technology, Microsoft Access and other Microsoft tools, Microsoft Application Server Pages (VBScript), C, C++, Perl, Windows NT, C, UNIX, Internet Security, network communications, individual component selection and integration.

14 I P a g e

Part III. Required Forms

Form Pl02

CERTIFICATION OF COMPLIANCE WITH GOVERNMENT-WIDE DEBARMENT, SUSPENSION, INELIGIBLITIY AND VOLUNTARY EXCLUSION PROVISIONS - LOWER TIER COVERED TRANSACTIONS

In regard to 49 CFR Part 29 and Executive Order 12549

By signing and submitting this bid or proposal, the prospective lower tier participant is providing the signed certification set out below in accordance with the following instructions:

l. The certification in this clause is a material representation of fact upon which reliance was placed when this transaction was entered into. If it is later detennined that the prospective lower tier participant knowingly rendered an erroneous ce1iification, in addition to other remedies available to the Federal Government, NIRPC may pursue available remedies, including suspension and/or debarment.

The prospective lower tier participant shall provide immediate written notice to NIRPC if at any time the prospective lower tier paiiicipant learns that its certification was erroneous when submitted or has become erroneous by reason of changed circumstances.
The te1ms "covered transaction," "debarred," "suspended," "ineligible," "lower tier covered transaction," :"participant," "persons," "lower tier covered transaction," "principal," "proposal," and "voluntarily excluded," as used in this clause, have the meanings set out in the Definitions and Coverage sections of rules implementing Executive Order 12549 [49 CFR Part 29]. You may contact NIRPC for assistance in obtaining a copy of those regulations.
The prospective lower tier pa1iicipant agrees by submitting this proposal that should the proposed covered transaction be entered into, it shall not knowingly enter into any lower tier covered transaction with a person who is debarred, suspended, declared ineligible, or voluntarily excluded from participation in this covered transaction, unless authorized in writing by NIRPC.
The prospective lower tier participant further agrees by submitting this proposal that it will include the clause titled "Certification Regarding Debannent, Suspension, Ineligibility and Voluntary Exclusion - Lower Tier Covered Transaction", without modification, in all lower tier covered transactions and in all solicitations for lower tier covered transactions.
A participant in a covered transaction may rely upon a certification of a prospective participant in a lower tier covered transaction that it is not debarred, suspended, ineligible, or voluntarily excluded from the covered transaction, unless it knows that the certification is erroneous. A participant may decide the method and frequency by which it determines the eligibility of its principals. Each participant may, but is not required to, check the Nonprocurement List issued by U.S. General Service Ad.ministration.
Nothing contained in the foregoing shall be constrned to require establishment of system ofrecords in order to render in good faith the certification required by this clause. The lmowledge and information of a participant is not required to exceed that which is normally possessed by a prudent person in the ordinary course of business dealings.
Except for transactions authorized under Paragraph 5 of these instructions, if a participant in a covered transaction knowingly enters into a lower tier covered transaction with a person who is suspended, debarred, ineligible, or voluntarily excluded from participation in this transaction, in addition to all remedies available to the Federal Government, NIRPC may pursue available remedies including suspension and/or debannent.

Pu rsuant to the above instructions:

(l) The prospective lower tier participant certifies, by submission of this bid or proposal, that neither it nor its "principals" [as defined at 49 C.F.R. § 29.105(p)] is presently debarred, suspended, proposed for debaiment, declared ineligible, or voluntarily excluded from participation in this transaction by any Federal department or agency.

(2) When the prospective lower tier participant is unable to certify to the statements in this certification, such prospective participant shall attach an explanation to this proposal.

Signature of Contractor's Authorized Official

Name and Title of Contractor's Authorized Official

Da te

CERTIFICATION REGARDING LOBBYING

49 CFR Part 20 - Appendix A

Certification For Contracts, Grants, Loans, And Cooperative Agreements The undersigned certifies, to the best of his or her knowledge and belief, that:

Form P109

No Federal appropriated funds have been paid or will be paid, by or on behalf of the undersigned, to any person for influencing or attempting to influence an officer or employee of an agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with the awarding of any Federal contract, the making of any Federal grant, the making of any Federal loan, the entering into of any cooperative agreement, and the extension, continuation, renewal, amendment, or modification of any Federal contract, grant, loan, or cooperative agreement.
If any funds other than Federal appropriated funds have been paid or will be paid to any person for influencing or attempting to influence an officer or employee of any agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with this Federal contract, grant, loan, or cooperative agreement, the undersigned shall complete and submit Standard Form-LLL, ''Disclosure Form to Report Lobbying," in accordance with its instructions.
The undersigned shall require that the language of this certification be included in the award documents for all subawards at all tiers (including subcontracts, subgrants, and contracts under grants, loans, and cooperative agreements) and that all subrecipients shall certify and disclose accordingly.

This certification is a material representation of fact upon which reliance was placed when this transaction was made or entered into. Submission of this certification is a prerequisite for making or entering into this transaction imposed by section 1352, title 31, U.S. Code. Any person who fails to file the required certification shall be subject to a civil penalty of not less than $10,000 and not more than $100,000 for each such failure.

Signature of Contractor's Authorized Official

Name and Title of Contractor's Authorized Official

Date

NON-COLLUSION AFFIDAVIT

The u ndersigned Proposer, bei ng d uly sworn on oath, says that he has not, nor has a ny other mem be r, representative, or agent of the firm, com pa ny, corporation or pa rtnershi p represented by him, entered i nto any com bination, collusion or agreement with any person from Proposi ng not to i nd uce a nyone to refrai n from Proposing, and that this Proposal is mad e without reference to any other Proposa l and

without any agreement, u ndersta nd ing or com bination wit h any other person i n reference to such Proposi ng. He f u rther says that no person or pe rsons, firms, or corporation has, have or wi ll receive d irectl y or indi rectly, a ny rebate, fee, gift, com mission or t hing of va lue on accou nt of such sa le.

Proposer

Signature of Proposer

Part IV. General Terms and Conditions

Part 4. GENERAL PROVISIONS.

Access to Records. The CONTRACTOR shall maintain all books, documents, papers, accounting records and other evidence pertaining to the cost incurred and shall make such materials available, at their respective offices at all reasonable times during the period of the Agreement and for three years from the date of final payment of federal funds, to INDOT for inspection by INDOT, FHWA, or any other authorized representative of the federal and state government and copies thereof shall be furnished at no cost if requested.
Assignment; Successors. The CONTRACTOR binds its successors and assignees to all the terms and conditions of this Agreement. Except as otherwise specifically provided herein, the CONTRACTOR shall not assign or subcontract the whole or any part of this Agreement without the Commission's prior written consent. The CONTRACTOR may assign its right to receive payments, if any, to such third parties as the CONTRACTOR may desire without the prior written consent of Commission, provided that the CONTRACTOR gives written notice (including evidence of such assignment) to Commission thirty (30) days in advance of any payment so assigned. The assignment shall cover all unpaid amounts under this Agreement and shall not be made to more than one party.
Audits. The CONTRACTOR acknowledges that it may be required to submit to an audit of funds paid through this Agreement. Any such audit shall be conducted in accordance with IC §5-11- 1, et seq., and audit guidelines specified by the State.
Authority to Bind the CONTRACTOR. The signatory for the CONTRACTOR represents that he/she has been duly authorized to execute this Agreement on behalf of the CONTRACTOR and has obtained all necessary or applicable approvals to make this Agreement fully binding upon the CONTRACTOR when his/her signature is affixed, and accepted by the State.
Certification for Federal-Aid Contracts Lobbying Activities. The CONTRACTOR certifies, by signing and submitting this Agreement, to the best of its knowledge and belief that the CONTRACTOR has complied with Section 1352, Title 31, U.S. Code, and specifically, that:

A. No federal appropriated funds have been paid or will be paid, by or on behalf of the CONTRACTOR, to any person for influencing or attempting to influence an officer or employee of any federal agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with the awarding of any federal agreements, the making of any federal grant, the making of any federal loan, the entering into of any cooperative agreement, and the extension, continuation, renewal, amendment, or modification of any federal agreement, grant, loan, or cooperative agreement.
1. If any funds other than federal appropriated funds have been paid or will be paid to any person for influencing or attempting to influence an officer or employee of any federal agency, a Member of Congress, an officer or employee of Congress, or an employee of a Member of Congress in connection with such federal agreement, grant, loan, or cooperative agreement, the undersigned shall complete and submit Standard Form-LLL, "Disclosure Form to Report Lobbying," in accordance with its instructions.
2. The CONTRACTOR also agrees by signing this Agreement that it shall require that the language of this certification be included in all contractor agreements including lower tier subcontracts, which exceed $100,000, and that all such sub recipients shall certify and disclose accordingly. Any person who fails to sign or file this required certification shall be subject to a civil penalty of not less than
l
$10,000 and not more than $100,000 for each failure.
Compliance with Laws.

A. The CONTRACTOR shall comply with all applicable federal, state, and local laws, rules, regulations, and ordinances, and all provisions required thereby to be included herein are hereby incorporated by reference. The enactment or modification of any applicable state or federal statute or the promulgation of rules or regulations thereunder after execution of this Agreement shall be reviewed by the State and the CONTRACTOR to determine whether the provisions of this Agreement require formal modification .

The CONTRACTOR and its agents shall abide by all ethical requirements that apply to persons who have a business relationship with the State as set forth in IC §4-2-6 , et seq., IC §4-2-7, et seq. and the regulations promulgated thereunder. If the CONTRACTOR has knowledge, or would have acquired knowledge with reasonable inquiry, that a state officer, employee, or special state appointee, as those terms are defined in IC 4-2-6-1, has a financial interest in the Agreement, the CONTRACTOR shall ensure compliance with the disclosure requirements in IC 4-2-6-10.5 prior to the execution of this contract. If the CONTRACTOR is not familiar with these ethical
requirements, the CONTRACTOR should refer any questions to the Indiana State Ethics Commission, or visit the Inspector General's website at htt p ://www .in.g ov/ig/. If the CONTRACTOR or its agents violate any applicable ethical standards, the Commission may, in its sole discretion, terminate this Agreement immediately upon notice to the CONTRACTOR. In addition , the CONTRACTOR may be subject to penalties under IC §§4-2-6 , 4-2-7, 35-44.1-1-4, and under any other applicable laws.
The CONTRACTOR warrants that the CONTRACTOR and its subcontractors, if any, shall obtain and maintain all required permits, licenses, registrations, and approvals, and shall comply with all health, safety, and environmental statutes, rules, or regulations in the performance of work activities for the State. Failure to do so may be deemed a material breach of this Agreement and grounds for immediate termination.
The CONTRACTOR affirms that, if it is an entity described in IC Title 23 , it is properly registered and owes no outstanding reports to the Indiana Secretary of State.

As required by IC §5-22-3-7:
1. The CONTRACTOR and any principals of the CONTRACTOR certify that:
  1. the CONTRACTOR, except for de minimis and nonsystematic violations, has not violated the terms of:
    1. IC §24-4.7 [Telephone Solicitation Of Consumers];
    2. IC §24-5-12 [Telephone Solicitations]; or
    3. IC §24-5-14 [Regulation of Automatic Dialing Machines];
      in the previous three hundred sixty-five (365) days, even if IC §24-4.7 is preempted by federal law; and
  2. the CONTRACTOR will not violate the terms of IC §24-4.7 for the duration of the Agreement, even if IC §24-4 .7 is preempted by federal law.
2. The CONTRACTOR and any principals of the CONTRACTOR certify that an affiliate or principal of the CONTRACTOR and any agent acting on behalf of the CONTRACTOR or on behalf of an affiliate or principal of the CONTRACTOR, except for de minimis and nonsystematic violations,
  
  2
  1. has not violated the terms of IC §24-4.7 in the previous three hundred sixty-five
    (365) days, even if IC §24-4.7 is preempted by federal law; and
  2. will not violate the terms of IC §24-4 .7 for the duration of the Agreement , even if IC §24-4.7 is preempted by federal law.

Debarment and Suspension .
1. The CONTRACTOR certifies by entering into this Agreement that neither it nor its principals nor any of its subcontractors are presently debarred, suspended, proposed for debarment, declared ineligible or voluntarily excluded from entering into this Agreement by any federal agency or by any department, agency or political subdivision of the State of Indiana. The term "principal" for purposes of this Agreement means an officer, director, owner, partner, key employee or other person with primary management or supervisory responsibilities, or a person who has a critical influence on or substantive control over the operations of the CONTRACTOR.
2. The CONTRACTOR certifies that it has verified the state and federal suspension and debarment status for all subcontractors receiving funds under this Agreement and shall be solely responsible for any recoupment, penalties or costs that might arise from use of a suspended or debarred subcontractor. The CONTRACTOR shall immediately notify the Commission if any subcontractor becomes debarred or suspended, and shall, at the Commission's request, take all steps required to terminate its contractual relationship with the subcontractor for work to be performed under this Agreement.
Drug-Free Workplace Certification.

As required by Executive Order No. 90-5 dated April 12, 1990, issued by the Governor of Indiana, the CONTRACTOR hereby covenants and agrees to make a good faith effort to provide and maintain a drug-free workplace . The CONTRACTOR will give written notice to the Commission within ten (10) days after receiving actual notice that the CONTRACTOR, or an employee of the CONTRACTOR in the State of Indiana, has been convicted of a criminal drug violation occurring in the workplace. False certification or violation of this certification may result in sanctions including, but not limited to, suspension of contract payments, termination of this Agreement and/or debarment of contracting opportunities with the State for up to three (3) years .

In addition to the provisions of the above paragraph, if the total amount set forth in this Agreement is in excess of $25,000.00, the CONTRACTOR certifies and agrees that it will provide a drug-free workplace by:
1. Publishing and providing to all of its employees a statement notifying them that the unlawful manufacture, distribution, dispensing, possession or use of a controlled substance is prohibited in the CONTRACTOR's workplace, and specifying the actions that will be taken against employees for violations of such prohibition; ·
2. Establishing a drug-free awareness program to inform its employees of (1) the dangers of drug abuse in the workplace; (2) the CONTRACTOR's policy of maintaining a drug-free workplace; (3) any available drug counseling, rehabilitation and employee assistance programs; and (4) the penalties that may be imposed upon an employee for drug abuse violations occurring in the workplace;
  
  3
3. Notifying all employees in the statement required by subparagraph (A) above that as a condition of continued employment, the employee will (1) abide by the terms of the statement; and (2) notify the CONTRACTOR of any criminal drug statute conviction for a violation occurring in the workplace no later than five (5) days after such conviction;
4. Notifying the Commission in writing within ten (10) days after receiving notice from an employee under subdivision (C)(2) above, or otherwise receiving actual notice of such conviction;
5. Within thirty (30) days after receiving notice under subdivision (C)(2) above of a conviction, imposing the following sanctions or remedial measures on any employee who is convicted of drug abuse violations occurring in the workplace: (1) taking appropriate personnel action against the employee, up to and including termination; or (2) requiring such employee to satisfactorily participate in a drug abuse assistance or rehabilitation program approved for such purposes by a federal, state or local health, law enforcement , or other appropriate agency; and
6. Making a good faith effort to maintain a drug-free workplace through the implementation of subparagraphs (A) through (E) above.
Employment Eligibility Verification. As required by IC §22-5-1.7, the CONTRACTOR swears or affirms under the penalties of perjury that the CONTRACTOR does not knowingly employ an unauthorized alien. The CONTRACTOR further agrees that:
1. The CONTRACTOR shall enroll in and verify the work eligibility status of all his/her/its newly hired employees through the E-Verify program as defined in IC §22-5-1.7-3 . The CONTRACTOR is not required to participate should the E-Verify program cease to exist. Additionally, the CONTRACTOR is not required to participate if the CONTRACTOR is self-employed and does not employ any employees.
2. The CONTRACTOR shall not knowingly employ or contract with an unauthorized alien. The CONTRACTOR shall not retain an employee or contract with a person that the CONTRACTOR subsequently learns is an unauthorized alien.
3. The CONTRACTOR shall require his/her/its subcontractors, who perform work under this Agreement, to certify to the CONTRACTOR that the subcontractor does not knowingly employ or contract with an unauthorized alien and that the subcontractor has enrolled and is participating in the E-Verify program. The CONTRACTOR agrees to maintain this certification throughout the duration of the term of a contract with a subcontractor.
Force Majeure. In the event that any Party is unable to perform any of its obligations under this Agreement or to enjoy any of its benefits because of natural disaster or decrees of governmental bodies not the fault of the affected Party (hereinafter referred to as a "Force Majeure Event"), the Party who has been so affected shall immediately or as soon as is reasonably possible under the circumstances give notice to the other Parties and shall do everything possible to resume performance. Upon receipt of such notice, all obligations under this Agreement shall be immediately suspended. If the period of nonperformance exceeds thirty (30) days from the receipt of notice of the Force Majeure Event, the Party whose ability to perform has not been so affected may, by giving written notice, terminate this Agreement.
Funding Cancellation Clause. When the Director of the State Budget Agency makes a written determination that funds are not appropriated or otherwise available to support continuation of performance of this Agreement, this Agreement shall be canceled. A determination by the Director of