6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda - Thursday, September 16, 2021 -- 8:00 a.m.

Call to Order
Meeting Minutes of July 15, 2021 Pages 1 - 2
Review of Financial Status – June 2021 Budget vs Actual Pages 3 - 11
1. Bank Statement Reconciliations (pg. 3-7)
2. General Fund Expenses YTD June 2021 (pg. 7-8)
3. General Fund Revenue YTD June 2021 (pg. 9)
4. CARES Expenses YTD June 2021 (pg. 10)
5. CARES Revenue YTD June 2021 (pg. 11)
Approval of General Fund Claims Register – June 2021 Pages 12 - 13
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – June 2021 Pages 14
ACTION REQUESTED: Approval
Review of Financial Status – July 2021 Budget vs Actual Pages 15 - 23
1. Bank Statement Reconciliations (pg. 15-18)
2. General Fund Expenses YTD July 2021 (pg. 19-20)
3. General Fund Revenue YTD July 2021 (pg. 21)
4. CARES Expenses YTD July 2021 (pg. 22)
5. CARES Revenue YTD July 2021 (pg. 23)
Approval of General Fund Claims Register – July 2021 Pages 24 - 25
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – July 2021 Pages 26
ACTION REQUESTED: Approval
Economic Resiliency Plan Consultant Selection and Contract Pages 27 -28
ACTION REQUESTED: Recommendation for Approval
NIRPC Resolution 21-16: Requesting Release of the LaPorte County RLF from Pages 29 - 37 certain requirements of the Economic Development Administration (EDA)
ACTION REQUESTED: Recommendation for Approval
Personnel update
Other Business
Adjournment

The next meeting is scheduled for October 21, 2021 at 8:00 a.m.

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. Users may access the Relay Indiana Service by calling 711 or 1-800-743-3333. Requests for alternative formats may be made 72 hours in advance by contacting nirpc@nirpc.org .

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

July 15, 2021 / Google Meet Virtual Meeting – 8:00 a.m.

Members Present

Greg Stinson, Richard Hardaway, Bob Carnahan, George Topoll, Wendy Mis

Staff and Others Present

Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Meredith Stilwell, Denarie Kane, David Hollenbeck

Call to Order

Chairman Stinson called the meeting to order.

Approval of Minutes

The minutes of the May 20, 2021 meeting were presented. Bob Carnahan made motion and Richard Hardaway seconded to approve the minutes. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Greg Stinson, George Topoll and Wendy Mis voting in the affirmative motion passed 5-0.

Review of Financial Status – May 2021 Budget vs Actual

Talaya Jones presented the May 2021 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account.

Talaya Jones presented the May 2021 general fund financial reports. Total expenditures for the period ending May 31, 2021 were $1,839,097 of the $11,981,765 budgeted. Total general fund revenue for the period was $822,109 of the $3,574,659 budgeted.

Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act financial reports, year to date May 2021. Total NIRPC CARES fund expenditures for the period ending May 31, 2021, were

$153,899, with total CARES expenditures of $2,056,351 of the $4,717,013 budgeted. Total CARES revenue collected for the period is $2,100,963 of the $4,307,009 budgeted.

Approval of Claims Registers – May 2021

Talaya presented the May 2021 General Fund claims register totaling $433,296.75 to the Committee for approval. Bob Carnahan made motion and Richard Hardaway seconded to approve the May 2021 General Fund claims register. Bob Carnahan, Richard Hardaway, Greg Stinson, George Topoll and Wendy Mis voting in the affirmative motion passed 5-0. The CARES Act expenditures register of claims totaling

$1,087,350.07 was then presented for approval. Bob Carnahan made motion and Richard Hardaway seconded to approve the May 2021 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Greg Stinson, George Topoll and Wendy Mis voting in the affirmative motion passed 5-0.

NIRPC 2021 Budget Amendment #1

Talaya presented budget amendment #1 to reallocate $75,000 from Planning Communications to Planning contractual to cover a forthcoming contract. Bob Carnahan made motion and Richard Hardaway seconded to forward the resolution to the NIRPC Full Commission with a favorable recommendation. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Greg Stinson, George Topoll and Wendy Mis voting in the affirmative motion passed 5-0.

Amending the Regional and LaPorte County RLF Management Plans

Denarie Kane presented the edits to be made to the Regional and LaPorte County RLF Management Plans

and recommended the Finance and Personnel Committee approve the changes. Richard Hardaway made motion and Wendy Mis seconded to approve the amendments to the RLF Management Plans A roll call vote was taken with Bob Carnahan, Richard Hardaway, Greg Stinson and George Topoll voting in the affirmative motion passed 4-0.

South Shore Clean Cities Contract

Kathy Luther presented the new South Shore Clean Cities Contract for the provision of professional education and training services from July 1, 2021, through December 31, 2022. Bob Carnahan made motion and Richard Hardaway seconded to approve the South Shore Clean Cities contract. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Greg Stinson and George Topoll voting in the affirmative motion passed 4-0.

Personnel updates

Ty Warner reported on the hiring of the new Director of Transportation Thomas Dow.

Other Business None

Adjournment

There being no further business, the meeting was adjourned.

Closing Balance from Previous Statement........................................................................................... 5/31/2021 1,770,861.90 ‌

15	Deposits and Other Additions Totaling......................................................................		436,306.00
133	Checks and Other Withdrawls Totaling.....................................................................		513,600.41
0	Adjustments Totaling..............................................................................................		0.00
0	Voids Totaling........................................................................................................		0.00
	Service Charge.......................................................................................................	6/10/2021	95.60
	Interest Earned.......................................................................................................	6/30/2021	127.26
Closing Balance for this Statement.....................................................................................................		6/30/2021	1,693,599.15
Difference...............................................................................................................			0.00
Cash Balance from General Ledger....................................................................................................		6/30/2021	1,654,666.77
Open Activity from Bank Register.............................................................................			(38,932.38)
Adjustment for Service Charges and Interest.............................................................			0.00
General Ledger Reconciliation to Statement..............................................................................................			1,693,599.15
Date	Check To	Check Description	Amount
7/02/2019	0002363 Kelly Tripp	Refund fee for tree steward workshop	28.83
8/27/2019	0002409 United Way of Porter County	8/5 - 8/18/2019 pay period - United Way	33.85
4/09/2020	0002545 Anthem Life	Life Ins for April 2020	490.75
6/02/2020	0002587 Anthem Life	Life Insurance June 2020	514.93
8/11/2020	0002624 Anthem Life	Life Insurance - August	502.84
3/23/2021 5/25/2021	0002764 American of Metropolitan Planning Organization 0002795 Gov't Finance Officers Association	NIRPC-Job Posting Director of Transportaion Membership dues 5/1/21-4/30/22-Talaya	50.00 160.00
6/02/2021	0002809 Miovision	Jones traffic Counting Base Scouts/UPS Shipping	8,197.00
6/15/2021	0002816 Grainger	& Del. Item#426F19-Torque Wrench	2,549.44
6/29/2021	0002820 City of Portage, The	Item#489K24-Bulk Storage Rack Item#489K25-Bulk Storage Rack Item#2W273-Utility Cart Sewer/Water/Gas/Electric	1,960.31
6/29/2021 6/29/2021	0002821 Preferred Window and Door, Inc 0002822 Pulse Technology	Supply and install new storefront aluminum entrance Office supplies-Covid 19/CARES-Lysol	24,381.59 28.99
6/29/2021	0002823 United Way of Porter County	6/7 - 6/20/2021 pay period - United Way	33.85
	Total Unmarked Checks: 38,932.38	Total Checks:	38,932.38

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 7/07/2021 @ 8:49 AM

Reconciliation - General

Page: 1

STK 7/6/21

09/7/2021

Trial Balance - Cash

Run: 8/24/2021 at 9:16 ANMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 6/30/2021

Page: 1

All Balance

1.1.001.0000.1010.0 Cash 1,654,666.77

Total 1,654,666.77

STK 8/24/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 7/02/2021 @ 11:43 AM

Reconciliation - Revolving Loan Fund

Page: 1

STK 7/2/21

Closing Balance from Previous Statement........................................................................................... 5/31/2021 199,026.59

4	Deposits and Other Additions Totaling......................................................................		4,278.31
0	Checks and Other Withdrawls Totaling.....................................................................		0.00
0	Adjustments Totaling..............................................................................................		0.00
0	Voids Totaling........................................................................................................		0.00
	Service Charge.......................................................................................................		0.00
	Interest Earned.......................................................................................................	6/30/2021	8.27
Closing Balance for this Statement.....................................................................................................		6/30/2021	203,313.17
Difference...............................................................................................................			0.00
Cash Balance from General Ledger....................................................................................................		6/30/2021	203,313.17
Open Activity from Bank Register.............................................................................			0.00
Adjustment for Service Charges and Interest.............................................................			0.00
General Ledger Reconciliation to Statement..............................................................................................			203,313.17

Trial Balance - Cash

Run: 7/02/2021 at 11:45NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 6/30/2021

Page: 1

All Balance

2.3.050.0000.1010.0 Cash 203,313.17

Total 203,313.17

STK 7/2/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JUNE 30, 2021

Line Items

FY 2021 Budget

FY 21

YTD June Budget %

Expended balance

Salaries
5020-1	Total Salaries	1,328,521	531,443 60%
	Salaries Sub-Total	1,328,521	531,443 60%

Fringe Benefits
5121-9	FICA Contributions	119,742	46,773	61%
5122-9	Workers Compensation	9,500	6,429	32%
5123-9	Unemployment Compensation	3,000	986	67%
5141-9	PERF Contributions	200,012	79,480	60%
5142-9	Health Insurance	230,000	90,745	61%
5143-9	Life & Disability Insurance	24,000	8,197	66%
5145-9	ICMA	23,000	11,127	52%
5146-9	Staff Development	20,000	2,611	87%
	Fringe Benefits Sub-Total	629,254	246,349	61%

Occupancy
5221-9	Office Lease	231,000	112,631	51%
5222-9	Property Insurance	6,500	1,319	80%
5223-9	Building Maintenance	18,540	9,134	51%
5224-9	Utilities	30,650	13,793	55%
	Occupancy Sub-Total	286,690	136,877	52%

Maintenance
5241-9	Copier Leasing/Maintenance	20,370	5,056	75%
5243-9	Computer Service/Maintenance	43,736	21,261	51%
5244-9	Telephone Service/Maintenance	18,900	6,039	68%
	Combined Copier/IT/Phone Service/Maintenance	83,006	32,356	61%
5249-9	Other Equipment Maintenance	2,000	908	55%
	Maintenance Sub-Total	85,006	33,264	61%
Departmental
5410-1	Communications: Commission/Ex. Dir.	41,500	6,433	84%
5410-2	Communications: Transportation	299,000	20,822	93%
5410-3	Economic Development District	11,768	1,147	90%
5410-4	Communications: Subgrantee Management	25,000	0	100%
5410-5	Communications: Environmental Programs	25,255	18,227	28%
5410-8	Communications: Partner Agency	1,000	0	100%
5410-9	Communications: Allocated Functions	28,000	2,997	89%
5420-5	Promotional Expenses: Environmental Programs	3,700	0	100%
5430-9	General Use Supplies Expense	6,000	466	92%
	Departmental Sub-Total	441,223	50,092	89%

Contractual
5602-9	Legal Services	22,200	10,200	54%
5603-9	Audit and Accounting	33,000	54	100%
5604-9	LaPorte RLF Services	2,000	0	100%
5610-4	Transit Oversight	17,347	0	100%
5610-5	Environmental Projects	837,300	344,374	59%
5610-2	Planning	320,000	0	100%
5619-9	Organizational Dev.	2,000	0	100%
5610-0	Board Development	2,000	0	100%
5610-2	E-Tip	51,500	22,500	56%
	Contractual Sub-Total	1,287,347	377,127	71%

Capital Outlays
5910-0	Furniture and Equipment	80,000	0 100%
	Capital Outlays Sub-Total	80,000	0 100%

TOTAL GENERAL FUND EXPENDITURES

4,138,041

1,375,152 67%

LaPorte Revolving Loan Fund

85,000

Transit Capital Fund

3,297,959

147,305

Transit Operating Fund	4,460,765	580,653
TOTAL EXPENDITURES	11,981,765	2,103,110

YTD June 2021 Expenses Budget vs Actual

700000

664260.5

643673.5

600000 CARES FUND EXPENDITURES

531442.89

500000

400000

377127.27

314627

300000

246349.24

220611.5

200000

143345 136876.61

100000

42503

33264.43

50091.91

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD June Budget YTD June Expended

YTD June 2021 Expended by Category

27%

39%

10%

18%

Salaries

Fringe Benefits Occupancy Maintenance Departmental Contractuals

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JUNE 30, 2021

Line Items

FY 2021

Budget

FY 21

YTD June YTD Variance YTD % Budget % Collected (Under)/Over Variance balance

GENERAL FUND REVENUE

1.1.4110	County Appropriations	540,271	366,669	366,669	0%	32%
1.1.4210	Federal Agencies	869,119	58,345	(376,214)	-87%	93%
1.1.4310	State Agencies	1,955,395	722,105	(255,592)	-26%	63%
1.1.4410	Local Agencies	44,694	22,935	588	3%	49%
1.1.4610	Non-Governmental	85,318	4,655	(38,004)	-89%	95%
1.3.4260	Economic Development District	70,000	10,684	(24,316)	-69%	85%
1.1.4800	Interest Income	9,862	4,186	(745)	-15%	58%
	Revenue Total	3,574,659	1,189,579	(327,615)	-22%	67%

Revenue by Funding Source as of June 30, 2021

2% 0%

31%

61%

County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District Interest Income

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JUNE 30, 2021

Line Items	FY 2021 Budget	YTD June Expended	FY 21 Budget % balance
NIRPC CARES EXPENDITURES
Salaries
Salaries	236,733	106,438	55%
Salaries Sub-Total	236,733	106,438	55%

YTD June 2021 Expenses Budget vs Actual

250,000

236,733

200,000

150,000

146,000

106,438

100,000

60,996

50,000

5,000

1,500 452

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

Contractual

RLF Services	5,000	-	100%
Audit & Accounting	5,000	5,000	0%
EDD Insititutional CARES ACT	136,000	-	100%
Contractual Sub-Total	146,000	5,000	97%
Departmental
Communications	500	201	60%
PPE Supplies & Office Supplies	1,000	251	75%
Departmental Sub-Total	1,500	452	70%

Capital Outlays
Furniture and Equipment	100,000	60,996	39%
Capital Outlays Sub-Total	100,000	60,996	39%

TOTAL NIRPC CARES FUND EXPENDITURES

484,233

172,886

64%

CARES Revolving Loan Fund

530,000

CARES Transit Capital Fund

1,008,732

361,836

CARES Transit Agency Fund	2,694,048	1,620,128
TOTAL EXPENDITURES	4,717,013	2,154,851

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JUNE 30, 2021

Line Items	FY 2021 Budget	YTD June Collected	FY 21 Budget % balance
CARES ACT OPERATING
Operating Revenue	419,386	172,447	59%
Capital Revenue	125,000	0	100%

CARES ACT EDA Economic Development District	59,843	27,796	54%
	604,229	200,243	67%

CARES AGENCY	FTA Revenue	2,694,048	1,619,858	40%
CARES TRANSIT CAPITAL	FTA Revenue	1,008,732	361,686	64%
	Revenue Total	4,307,009	2,181,787	49%

Revenue by Funding Source as of June 30, 2021

14%

86%

CARES Operating

Economic Development District

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)

Date Filed	Claim Number	Name of Claimant	Fund	Fund Amount	Amount of Claim	Check #	Notes
6/1/2021	B-5210	Federal & Fica	General Fund 2140.0	$ 4,444.93	$ 4,444.93	C5210	5/10-5/23/2021 pay period- Federal Tax Withholdings Payable
6/1/2021	B-5210	Federal & Fica	General Fund 2142.0	$ 7,035.50	$ 7,035.50	C5210	5/10-5/23/2021 pay period-FICA Tax Withholdings Payable
6/1/2021	B-5213	Horizon Bank	General Fund 2150.0	$ 372.31	$ 372.31	C5213	5/10-5/23/2021 pay period- HSA
6/1/2021	B-5214	ICMA Retirement Fund-PR	General Fund 2146.0	$ 530.00	$ 530.00	C5214	5/10-5/23/2021 pay period-ICMA
6/1/2021	4289	ICMA Retirement Fund-PR	General Fund 5145.9	$ 855.91	$ 855.91	C4289	ER paid for Ty Warner 5/10/2021 thru 5/23/2021-p/r
6/1/2021		Payroll		$ 35,605.32	$ 35,605.32		Payroll
6/2/2021	4300	Anthem Life	General Fund 5143.9	$ 503.48	$ 503.48	C4300	Life Insurance-June
6/2/2021	4295	Blachly, Tabor, Bozik, Hartman, LLC	General Fund 5602.9	$ 1,700.00	$ 1,700.00	2803	Legal- June
6/2/2021	4294	City of Portage	General Fund 5221.9	$ 18,775.18	$ 18,775.18	2804	Office Lease-June
6/2/2021	4303	City of Portage	General Fund 5224.9	$ 2,081.81	$ 2,081.81	2804	Utilities-June
6/2/2021	4304	DeLage	General Fund 5243.9	$ 3,550.61	$ 3,550.61	C4304	IT
6/2/2021	4304	DeLage	General Fund 5244.9	$ 741.83	$ 741.83	C4304	TELE
6/2/2021	4304	DeLage	General Fund 5241.9	$ 842.74	$ 842.74	C4304	Copier
6/2/2021	4304	DeLage	General Fund 5910.0	$ 206.25	$ 206.25	C4304	MainOffice 365
6/2/2021	4301	Health Resources	General Fund 2153.0	$ 846.30	$ 846.30	2806	Dental Insurance-June
6/2/2021	B-5212	INPRS	General Fund 2149.0	$ 5,945.81	$ 5,945.81	C5212	5/10-5/23/2021 pay period- Emp Perf (NIRPC)
6/2/2021	4302	Kansas City Life	General Fund 5143.9	$ 824.90	$ 824.90	2807	Life Insurance-June
6/2/2021	4281	Miovision	General Fund 5410.2	$ 8,197.00	$ 8,197.00	2809	Traffic Counting Base Scouts/UPS Shipping & Del-NIRPC
6/2/2021	4290	Pulse Technology	General Fund 5430.9	$ 18.74	$ 18.74	2810	Office Supplies
6/2/2021	B-5215	United Way of Porter County	General Fund 2147.0	$ 33.85	$ 33.85	2812	5/10-5/23/2021 pay period
6/3/2021	4268	City of LaPorte	General Fund 5760.0	$ 48,415.00	$ 48,415.00	C4263	LaPorte Reimb for OA Oct-Dec 2020
6/3/2021	4284	Ecointeractive	General Fund 5610.2	$ 3,750.00	$ 3,750.00	C4284	TIP SAAS Service Monthly Service Fee
6/3/2021	4299	Fidelity EyeMed Vision Ins	General Fund 2154.0	$ 99.01	$ 99.01	C4299	Vision Insurance-June
6/3/2021	4305	Total Disposal	General Fund 5223.9	$ 74.00	$ 74.00	C4305	Recycle/Garbage-June
6/3/2021	4317	United HealthCare	General Fund 2152.00	$ 2,141.56	$ 2,141.56	C4317	EE paid for June Health Insurance
6/3/2021	4317	United HealthCare	General Fund 5142.9	$ 11,473.19	$ 11,473.19	C4317	ER paid for June Health Insurance
6/3/2021	4298	Warner, Ty	General Fund 5244.9	$ 125.00	$ 125.00	C4298	Communication Expense- June
6/10/2021		Account fee		$ 95.61	$ 95.61		Account Fee- Horizon
6/10/2021	4211	Amazon	General Fund 5430.9	$ 48.25	$ 48.25	CC4211	Office Supplies
6/10/2021	4243	Amazon	General Fund	$ 69.47	$ 69.47	CC4243	Office Supplies
6/10/2021	4326	Cardmember Services	General Fund 5410.9	$ 33.60	$ 33.60	CC4326	Foreign Transaction Fee- for INRO Consultant payment-NIRPC
6/10/2021	4316	Comcast	General Fund 5244.9	$ 139.64	$ 139.64	CC4316	Business Internet-June
6/10/2021	4296	Chicago Tribune	General Fund 5410.1	$ 27.72	$ 27.72	CC4296	News Paper Subscription
6/10/2021	4308	Chicago Tribune	General Fund 5410.1	$ 27.72	$ 27.72	CC4308	News Paper Subscription
6/10/2021	4220	GoDaddy	General Fund 5410.9	$ 21.17	$ 21.17	CC4220	1 year Renewal of Domain Name NIRPC.org
6/10/2021	4228	INRO Consultant	General Fund 5410.2	$ 1,680.00	$ 1,680.00	CC4228	Emme Software Maintenance Agreement Renewal of semi annual fees
6/10/2021	4297	Stamps.com	General Fund 5249.9	$ 24.99	$ 24.99	CC4297	Stamps
6/10/2021	4272	Walk Bike Place Conference	General Fund 5410.2	$ 337.50	$ 337.50	CC4272	Conference Registration and Fee's
6/15/2021	4315	Bryco	General Fund 5223	$ 1,565.30	$ 1,565.30	4315	Office Cleaning-June
6/15/2021	B-5271	Federal & Fica	General Fund 2140.0	$ 4,444.93	$ 4,444.93	C5271	5/24-6/6/2021 pay period- FWT, empfica, empficamed Federal Tax Withholdings Payable

6/15/2021	B-5271	Federal & Fica	General Fund 2142.0	$ 7,035.50	$ 7,035.50	C5271	5/24-6/6/2021 pay period- FWT, empfica, emficamed FICA Tax Withholdings Payable
6/15/2021	B-5274	Horizon Bank	General Fund 2150.0	$ 372.31	$ 372.31	C5274	5/24-6/6/2021 pay period - HAS
6/15/2021	B-5275	ICMA Retirement Fund-PR	General Fund 2146.0	$ 530.00	$ 530.00	C5275	5/24-6/6/2021 -pay period -ICMA
6/15/2021	4313	ICMA Retirement Fund-PR	General Fund 5145.9	$ 855.91	$ 855.91	C4313	ER paid for Ty Warner 5/24/2021 thru 6/6/2021- p/r
6/15/2021	4280	Onix Networking Corp	General Fund 5410.5	$ 72.00	$ 72.00	2817	Additional G-Suites Basic Licenses for Interns for 2021-NIRPC for interns
6/15/2021		Payroll		$ 35,605.30	$ 35,605.30		Payroll
6/15/2021	4275	Rigg's Outdoor Power Equip	General Fund 5410.5	$ 17,750.40	$ 17,750.40	2818	960 No Spill Gas Cans for Air Quality Public- CMAQ
6/15/2021	B-5276	United Way of Porter County	General Fund 2147.0	$ 33.85	$ 33.85	2819	5/24-6/6/2021 pay period -United Way
6/16/2021	4312	Ecointeractive	General Fund 5610.2	$ 3,750.00	$ 3,750.00	C4312	TIP SAAS Service Monthly Service Fee
6/17/2021	4328	Horizon Bank	General Fund 5410.1	$ 400.00	$ 400.00	C4328	Retirement Recognition Award- John Smith
6/16/2021	B-5273	INPRS	General Fund 2149.0	$ 5,945.81	$ 5,945.81	C5273	5/24-6/6/2021 pay period- EmpPerf [NIRPC]
6/16/2021	4323	Stilwell, Meredith	General Fund 5146.9	$ 34.97	$ 34.97	C4323	M365 SharePoint Training
6/16/2021	4321	Todd, Lisa	General Fund 5142.9	$ 1,000.00	$ 1,000.00	C4321	Early distribution HAS (July portion)
6/16/2021	4322	Warner, Ty	General Fund 5410.1	$ 129.99	$ 129.99	C4322	RARE Leadership Conf.. Aug12-13, 20201
6/17/2021	4325	DeLage	General Fund 5243.9	$ 6.25	$ 6.25	C4325	IT-Upgrade increase Business Standard Lic.
6/17/20212	B-5172	IN Dept of Revenue	General Fund 2143.0	$ 1,463.18	$ 1,463.18	C5172	4/12-4/25/2021 pay period-LtIN, SwtIN State Tax Withholdings Payable
6/17/2021	B-5172	IN Dept of Revenue	General Fund 2144.0	$ 309.85	$ 309.85	C5172	4/12-4/25/2021 pay period-LtIN, SwtIN Local Tax Withholdings Payable
6/17/2021	B-5193	IN Dept of Revenue	General Fund 2143.0	$ 1,463.18	$ 1,463.18	C5193	4/26-5/09/2021 pay period-LtIN, SwtIN State Tax Withholdings Payable
6/17/2021	B-5193	IN Dept of Revenue	General Fund 2144.0	$ 309.85	$ 309.85	C5193	4/26-5/09/2021 pay period-LtIN, SwtIN Local Tax Withholdings Payable
6/29/2021	4330	City of Portage	General Fund 5224.9	$ 1,960.31	$ 1,960.31	2820	Sewer/Water/Gas/Electric-June
6/29/2021	B-5300	Federal & Fica	General Fund 2140.0	$ 4,800.61	$ 4,800.61	C5300	6/7-6/20/2021 pay period-FWT,empfica, empficamed-Federal Tax Withholdings Payable
6/29/2021	B-5300	Federal & Fica	General Fund 2142.0	$ 7,343.42	$ 7,343.42	C5300	6/7-6/20/2021 pay period-FWT,empfica, empficamed-FICA Tax Withholdings Payable
6/29/2021	B-5306	Federal & Fica	General Fund 2140.0	$ 168.98	$ 168.98	C5306	Smith Vacation Payout-FWT,empfica, empficamed
6/29/2021	B-5306	Federal & Fica	General Fund 2142.0	$ 306.76	$ 306.76	C5306	FICA Tax Withholding Payable
6/29/2021	B-5303	Horizon Bank	General Fund 2150.0	$ 372.31	$ 372.31	C5303	6/7-6/2021 pay period- HAS
6/29/2021	4331	ICMA Retirement Fund-PR	General Fund 5145.9	$ 855.91	$ 855.91	C4331	ER paid for Ty Warner 6/7/2021 thru 6/20/2021- p/r
6/29/2021	B-5304	ICMA Retirement Fund-PR	General Fund 2146.0	$ 530.00	$ 530.00	C5304	6/7-6/20/2021 -pay period ICMA
6/29/2021	B-5308	INPRS	General Fund 2149.0	$ 284.15	$ 284.15	C5308	Smith Vacation Payout-EmpPerf [NIRPC]
6/29/2021	4332	INPRS	General Fund 5141.9	$ (0.01)	$ (0.01)	C4332	Rounding Adjustment 6/7/2021-6/20/2021-pr
6/29/2021	B-5302	INPRS	General Fund 2149.0	$ 6,012.41	$ 6,012.41	C5302	6/7-6/20/2021 pay period- EmpPerf [NIRPC]
6/29/2021		Payroll		$ 38,695.60	$ 38,695.60		Payroll
6/29/2021	B-5305	United Way of Porter County	General Fund 2147.0	$ 33.85	$ 33.85	2823	6/7-6/20/2021 pay period- United Way
6/29/2021	4333	Warner, Ty	General Fund 5410.9	$ 60.42	$ 60.42	C4333	NARC Executive Director Conference 9/26- 9/29/2021 Houston TX
				Total:	$ 306,199.20

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

Dated this day of

,2021.

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)

Date

Filed

Claim

Number

Name of Claimant

Fund

Fund Amount

Amount of

Claim

Check #

Notes

6/2/2021

4309

AccuFund

CARES Fund 5910.0

$ 1,284.00

2801

AccuFund Accounting Suite/Employee Portal (50 Hosted Employees)

6/2/2021

4202

Best Servers

CARES Fund 5960.0

$ 13,495.40

2802

Purchase a refurbished server for LCCS to upgrade

6/2/2021

4207

ERS Wireless

CARES Fund 5960.0

$ 58,484.11

2805

Avigilon Video Security System/5 yr extended warranty-City of LaPorte

6/2/2021

4216

Midwest Bus Corp

CARES Fund 5960.0

$ 2,648.00

2808

Item#129889 , Part #B4032DN 2 position S/S Bike racks-ECT

6/2/2021

4310

Routematch

CARES Fund 5960.0

$ 2,065.00

2811

SLCCS/NT/PCACS

6/4/2021

4292

East Chicago Transit

CARES Fund 5760.0

$ 270.00

C4292

ECT Reimb/OA Apr-Jun 2020-CARES (difference)

6/10/2021

4282

Amazon

CARES Fund 5910.0

$ 152.98

C4282

Bluetooth Speaker -NIRPC Security System Conf. Room Sound

6/15/2021

4319

Grainger

CARES Fund 5960.0

$ 2,549.44

2816

Torque Wrench/Bulk Storage Racks/Utility Cart

-ECT

6/29/2021

4214

Preferred Windows and Door, Inc

CARES Fund 5960.0

$ 24,381.59

2821

Supply and install new storefront aluminum entrance-LCCS

6/29/2021

3960

Pulse Technology

CARES Fund 5430.9

$ 28.99

2822

Office Supplies-Covid 19/CARES-Lysol

Total:

$ 105,359.51

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

Dated this day of , 2021.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

Run: 8/0512021 @ 7:28 AM Reconciliation - General

Closing Balance from Previous Statement............... ............................................................................

12 Deposits and Other Additions Totaling......................................................................

98 Checks and Other Withdrawls Totaling.....................................................................

Adjus tments Totaling..............................................................................................

O Voids Totaling.......................... ................................... ...........................................

200,777.00

323,038.55

960.00 / 0.00

Service Charge.......................................................................................................				7/13/2021	93.72
Interest Earned........................................................... ............................................				7/30 /2021	137.71
Closing Balance for this Statement.....................................................................................................				7/31/2021	1,572,341.59
Difference................................. ................ ..............................................................					0.00
Cash Balance from General Ledger................ ................................... .................................................				7/31/2021	1,527,548.17
Open Activity from Bank Register......... ............... .................................................. ...					(44,793.42)
Adjustment for Service Charges and Interest......................................... ....................					0.00
General Ledger Reconciliation to Statement................................... ...........................................................					1,572,341.59
	Date	Check To	Check Description	Amount
	7/02/2019	0002363 Kelly Tripp	Refund fee for tree steward workshop	28.83
	8/27/2019	0002409 United Way of Porter County	8/5 - 8/18/2019 pay period - United Way	33.85
	4/09/2020	0002545 Anthem Life	Life Ins for April 2020	490.75
	6/02/2020	0002587 Anthem Life	Life Insurance June 2020	514.93
	8/11/2020	0002624 Anthem Life	Life Insurance - August	502.84
	3/23/2021	0002764 Amer ican of Metropolitan Planning	NIRPC-Job Posting Director of Transportaion	50.00
	6/02/2021	Organization 0002809 Miovision	traffic Counting Base Scouts/UPS Shipping	8,197.00
	7/28/2021	0002833 Best Servers	& Del. Purchase a refurbished server for LCCS to	131.25
			upgrade
			Purchase a refurbished server for LCCS
	7/28/2021	0002834 Bosak Ford	upgrade F-150 Parts/Filters/Element Parts /Filter	1,499.76
			Parts /Screens
			F-250 Parts/F ilters/Element Parts /Filter
			Parts /Screens
	7/28/2021	0002835 City of Portage, The	Invoices 4395, 4397	20,823.82
	7/28/2021	0002836 Earth Charter Indiana Inc.	2021 Climate Fellow Stipend $1500 per	6,000.00
			student •4
	7/28/2021	0002837 Grainger	Invoice #9928416677 Black Tool drawer liner	97.81
			roll
			Invoice #9928416685 -Safley sign #471T26
			lnvoice #9928416685 Safely Sign #469281
	7/28/2021	0002838 Northwest Indiana Forum Foundation	Programmatic Support & Outreach	4,359.74
			Hazaradous
			Programmatic Support & Outreach-
			Petroleum
	7/28/2021	0002839 Pulse Technology	Office Supplies-Covid-19 /CARES- Lysol	28.99
	7/28/2021	0002840 Southshore Baseball, LLC	Half Page Program Advertisements /Clean Air	2,000.00
			Game Sponsorship/PFCA for Clean Air
			Event -Local Share
	7/28/2021	0002841 United Way of Porter County	7/5 - 7/18/2021 pay period - United Way	33.85
		Total Unmarked Checks: 44,793.42	Total Checks:	44,793.42

Trial Balance - Cash

Run: s1os12021 at 7:30 WRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 7/31/2021

Page: 1

All 1.1.001.0000.101o.o Cash

Total

Balance 1,527,548.17

1,527,548.17

sil '6 /<( d"I

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 010412021 @ B:54 AM Reconciliation - Revolving Loan Fund Page :

Closing Balance from Previous Statement........................ ................................................................. ..

6/30/2021

203,313.17

3	Deposits and Other Additions Totaling................... .................................................. .		3,778.31
0	Checks and Other Withdrawls Totaling.....................................................................		0.00
0	Adjustments Totaling..............................................................................................		0.00
0	Voids Totaling.......................... ............. ........................... .............................. ....... .		0.00
	Service Charge.................. ........ ...................... .......................................................		0.00
	Interest Earned........... ................. .........................................................................	7/30/2021	8.74

Closing Balance for this Statement.. .............................. .....................................................................

Difference..... ......................... .......................................................................... .......

7/31/2021

207,100.22

0.00

Cash Balance from General Ledger....................................................................................................

Open Activity from Bank Register....................... ............................... ............. ..........

Adjustment for Service Charges and Interest.............................................................

General Ledger Reconciliation to Statement.......................................................................... ....................

7/31/2021 207,100.22

0.00

207,100.22

1 (_\'\\3-\

- '

4;\0

Trial Balance - Cash

Run: s10412021at s:ss RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 7/31/2021

Page: 1

All

2.3.050.0000.1010.0 Cash

Total

Balance

207,100.22

/sil 1 /;1

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JULY 31, 2021

Line Items

FY 2021 Budget

FY 21

YTD July Budget %

Expended balance

Salaries
5020-1	Total Salaries	1,328,521	621,925 53%
	Salaries Sub-Total	1,328,521	621,925 53%

Fringe Benefits
5121-9	FICA Contributions	119,742	54,805	54%
5122-9	Workers Compensation	9,500	6,429	32%
5123-9	Unemployment Compensation	3,000	1,008	66%
5141-9	PERF Contributions	200,012	93,146	53%
5142-9	Health Insurance	230,000	121,269	47%
5143-9	Life & Disability Insurance	24,000	9,368	61%
5145-9	ICMA	23,000	12,839	44%
5146-9	Staff Development	20,000	1,651	92%
	Fringe Benefits Sub-Total	629,254	300,515	52%

Occupancy
5221-9	Office Lease	231,000	131,406	43%
5222-9	Property Insurance	6,500	1,319	80%
5223-9	Building Maintenance	18,540	10,633	43%
5224-9	Utilities	30,650	15,841	48%
	Occupancy Sub-Total	286,690	159,199	44%

Maintenance
5241-9	Copier Leasing/Maintenance	20,370	5,899	71%
5243-9	Computer Service/Maintenance	43,736	24,868	43%
5244-9	Telephone Service/Maintenance	18,900	7,045	63%
	Combined Copier/IT/Phone Service/Maintenance	83,006	37,812	54%
5249-9	Other Equipment Maintenance	2,000	933	53%
	Maintenance Sub-Total	85,006	38,745	54%
Departmental
5410-1	Communications: Commission/Ex. Dir.	41,500	7,451	82%
5410-2	Communications: Transportation	299,000	21,861	93%
5410-3	Economic Development District	11,768	1,997	83%
5410-4	Communications: Subgrantee Management	25,000	0	100%
5410-5	Communications: Environmental Programs	25,255	20,427	19%
5410-8	Communications: Partner Agency	1,000	0	100%
5410-9	Communications: Allocated Functions	28,000	4,186	85%
5420-5	Promotional Expenses: Environmental Programs	3,700	0	100%
5430-9	General Use Supplies Expense	6,000	522	91%
	Departmental Sub-Total	441,223	56,445	87%

Contractual
5602-9	Legal Services	22,200	11,900	46%
5603-9	Audit and Accounting	33,000	54	100%
5604-9	LaPorte RLF Services	2,000	190	91%
5610-4	Transit Oversight	17,347	0	100%
5610-5	Environmental Projects	837,300	354,733	58%
5610-2	Planning	320,000	0	100%
5619-9	Organizational Dev.	2,000	0	100%
5610-0	Board Development	2,000	0	100%
5610-2	E-Tip	51,500	26,250	49%
	Contractual Sub-Total	1,287,347	393,127	69%

Capital Outlays
5910-0	Furniture and Equipment	80,000	0 100%
	Capital Outlays Sub-Total	80,000	0 100%

TOTAL GENERAL FUND EXPENDITURES

4,138,041

1,569,956 62%

LaPorte Revolving Loan Fund

85,000

Transit Capital Fund

3,297,959

147,305

Transit Operating Fund	4,460,765	695,405
TOTAL EXPENDITURES	11,981,765	2,412,666

YTD July 2021 Expenses Budget vs Actual

800000

774970.5833

750952.4167

700000 CARES FUND EXPENDITURES

621924.97

600000

500000

392937.01

400000

367064.8333

300515.12

300000

257380.0833

167235.8333159199.43

200000

56444.61

100000

49586.8333338745.17

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD July Budget YTD July Expended

YTD July 2021 Expended by Category

25%

40%

10%

19%

Salaries

Fringe Benefits Occupancy Maintenance Departmental Contractuals

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JULY 31, 2021

Line Items

FY 2021

Budget

FY 21

YTD July YTD Variance YTD % Budget % Collected (Under)/Over Variance balance

GENERAL FUND REVENUE

1.1.4110	County Appropriations	540,271	366,669	366,669	0%	32%
1.1.4210	Federal Agencies	869,119	62,044	(372,516)	-86%	93%
1.1.4310	State Agencies	1,955,395	722,105	(255,592)	-26%	63%
1.1.4410	Local Agencies	44,694	24,210	1,863	8%	46%
1.1.4610	Non-Governmental	85,318	4,655	(38,004)	-89%	95%
1.3.4260	Economic Development District	70,000	10,684	(24,316)	-69%	85%
1.1.4800	Interest Income	9,862	4,836	(95)	-2%	51%
	Revenue Total	3,574,659	1,195,203	(321,991)	-21%	67%

Revenue by Funding Source as of July 31, 2021

2% 0%

31%

61%

County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District Interest Income

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JULY 31, 2021

Line Items	FY 2021 Budget	YTD July Expended	FY 21 Budget % balance
NIRPC CARES EXPENDITURES
Salaries
Salaries	236,733	125,230	47%
Salaries Sub-Total	236,733	125,230	47%

Contractual
RLF Services	5,000	-	100%
Audit & Accounting	5,000	5,000	0%
EDD Insititutional CARES ACT	136,000	-	100%
Contractual Sub-Total	146,000	5,000	97%
Departmental
Communications	500	201	60%
PPE Supplies & Office Supplies	1,000	280	72%
Departmental Sub-Total	1,500	481	68%

Capital Outlays
Furniture and Equipment	100,000	61,203	39%
Capital Outlays Sub-Total	100,000	61,203	39%

TOTAL NIRPC CARES FUND EXPENDITURES

484,233

191,913

60%

CARES Revolving Loan Fund

530,000

CARES Transit Capital Fund

1,008,732

374,383

CARES Transit Agency Fund	2,694,048	1,620,128
TOTAL EXPENDITURES	4,717,013	2,186,424

YTD July 2021 Expenses Budget vs Actual

250,000

236,733

200,000

150,000

146,000

125,230

100,000

61,203

50,000

5,000

1,500

481

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JULY 31, 2021

Line Items	FY 2021 Budget	YTD July Collected	FY 21 Budget % balance
CARES ACT OPERATING
Operating Revenue	419,386	281,375	33%
Capital Revenue	125,000	0	100%

CARES ACT EDA Economic Development District	59,843	27,796	54%
	604,229	309,171	49%

CARES AGENCY	FTA Revenue	2,694,048	1,619,858	40%
CARES TRANSIT CAPITAL	FTA Revenue	1,008,732	374,233	63%
	Revenue Total	4,307,009	2,303,262	47%

Revenue by Funding Source as of July 31, 2021

91%

CARES Operating

Economic Development District

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)

Date Filed	Claim Number	Name of Claimant	Fund	Fund Amount	Amount of Claim	Check #	Notes
7/2/2021	4339	Anthem Life	General Fund 5143.9	$ 345.48	$ 345.48	C4339	ER paid Life Insurance -JULY
7/2/2021	4339	Anthem Life	General Fund 2155.0	$ 158.00	$ 158.00	C4339	EE paid Life Insurance-JULY
7/2/2021	4347	DeLage	General Fund 5243.9	$ 3,556.86	$ 3,556.86	C4347	IT
7/2/2021	4347	DeLage	General Fund 5244.9	$ 741.83	$ 741.83	C4347	TELE
7/2/2021	4347	DeLage	General Fund 5241.9	$ 842.74	$ 842.74	C4347	Copier
7/2/2021	4347	DeLage	General Fund 5910.0	$ 206.25	$ 206.25	C4347	MainOffice 365
7/6/2021	4363	Barloga II, Mitchell	General Fund 5410.9	$ 119.34	$ 119.34	C4363	Roundtrip Mileage-Indianapolis to Dyer and back-Walk Bike Places Conf.
7/6/2021	4355	Inc	General Fund 2152.0	$ 2,141.56	$ 2,141.56	C4355	EE paid Life Insurance-JULY Medical Insurance Withholdings
7/6/2021	4335	Inc	General Fund 5142.9	$ 11,473.19	$ 11,473.19	C4355	ER paid Life Insurance -JULY Health Insurance
7/7/2021	4365	DeLage	General Fund 5243.9	$ 49.68	$ 49.68	C4365	Annual escalator clause increase
7/9/2021		Horizon Bank	General Fund	$ 93.72	$ 93.72		Bank Fee
7/12/2021	4283	Amazon	General Fund 5430.9	$ 49.98	$ 49.98	CC4283	Logitech Headset (2)-NIRPC
7/12/2021	4291	Amazon	General Fund 5430.9	$ 6.99	$ 6.99	CC4290	25ft. 5mm audio cable-NIRPC
7/12/2021	4336	Chicago Tribue	General Fund 5410.0	$ 27.72	$ 27.72	CC4336	News Paper Subscription
7/12/2021	4345	Comcast	General Fund 5244.9	$ 139.64	$ 139.64	C4345	Business Internet
7/12/2021	4307	Council of Development Finance Agencies	General Fund 5410.3	$ 550.00	$ 550.00	CC4307	Intro RLF Course-June 23-24,2021-Denaire Kane
7/12/2021	4306	Council of Development Finance Agencies	General Fund 5410.3	$ 300.00	$ 300.00	CC4306	Advanced RLF Course Aug 9010,2021- Denaire Kane
7/12/2021	B-5307	IN Dept of Revenue	General Fund 2143.00	$ 64.76	$ 64.76	C5307	Smith Vacation Payout-State Tax Withholdings
7/12/2021	B-5307	IN Dept of Revenue	General Fund 2144.0	$ 30.07	$ 30.07	C5307	Smith Vacation Payout-Local Tax Withholdings
7/12/2021	B-5301	IN Dept of Revenue	General Fund 2143.0	$ 1,528.20	$ 1,528.20	C5301	6/7-6/20/2021-pay period-State Tax Withholdings Payable
7/12/2021	B-5301	IN Dept of Revenue	General Fund 2144.0	$ 324.13	$ 324.13	C5301	6/7-6/20/2021-pay period-Local Tax Withholdings Payable
7/12/2021	B-5272	IN Dept of Revenue	General Fund 2143.0	$ 1,463.18	$ 1,463.18	C5272	5/24-6/6/2021 pay period - State Tax Withholdings Payable
7/12/2021	B-5272	IN Dept of Revenue	General Fund 2144.0	$ 309.85	$ 309.85	C5272	5/24-6/6/2021 pay period- Local Tax Withholdings Payable
7/12/2021	B-5211	IN Dept of Revenue	General Fund 2143.0	$ 1,463.18	$ 1,463.18	C5211	5/10-5/23/2021 pay period-State Tax Withholdings Payable
7/12/2021	B-5211	IN Dept of Revenue	General Fund 2144.0	$ 309.85	$ 309.85	C5211	5/10-5/23/2021 pay period-Local Tax Withholdings Payable
7/12/2021	4337	Stamps	General Fund 5249.9	$ 24.99	$ 24.99	CC4337	Stamps
7/12/2021	4343	Total Disposal	General Fund 5223.9	$ 74.00	$ 74.00	C4343	Garbage/Recycle-July
7/13/2021	4338	Blachly,Tabor,Bozik & Hartmarn, LLc	General Fund 5602.9	$ 1,700.00	$ 1,700.00	2824	Legal- July
7/13/2021	4359	Bryco	General Fund 5223.9	$ 1,425.00	$ 1,425.00	2825	Office Cleaning -July
7/13/2021	4341	Health Resource	General Fund 2153.0	$ 846.30	$ 846.30	2826	Dental Insurance- July
7/13/2021	B-5325	Horizon Bank	General Fund 2150.0	$ 372.31	$ 372.31	C5325	6/21-7/4/2021 pay period - HSA
7/13/2021	B-5326	ICMA Retirement Fund-PR	General Fund 2146.0	$ 530.00	$ 530.00	C5326	6/21-7/4/2021 pay period - ICMA
7/13/2021	4351	ICMA Retirement Fund-PR	General Fund 5145.9	$ 855.91	$ 855.91	C4351	ER paid for Ty Warner 6/21/2021 thru 7/4/2021 p/r
7/13/2021	B-5322	Federal & Fica	General Fund 2140.0	$ 4,534.96	$ 4,534.96	C5322	6/21-7/4/2021 pay period-FWT,empfica, empficamed-Federal Tax Withholdings Payable
7/13/2021	B-5322	Federal & Fica	General Fund 2142.0	$ 7,107.26	$ 7,107.26	C5322	6/21-7/4/2021 pay period-FWT,empfica, empficamed-FICA Tax Withholdings Payable
7/13/2021	4342	Wex Bank	General Fund 5410.0	$ 71.48	$ 71.48	C4342	Fuel Purchase- Kevin Polette for NIRPC Van
7/13/2021	4334	JM Web Designers Business Yeti	General Fund 5899.7	$ 190.00	$ 190.00	2827	Convert (7) PDF forms into digital forms on NIRPC Web Page
7/13/2021	4346	Co.	General Fund 5143.9	$ 824.90	$ 824.90	2828	Life Insurance
7/13/2021	4357	Nat'l Assoc. of Regional Councils	General Fund 5410.1	$ 750.00	$ 750.00	2830	2021 NARC Virtual Ann. Conf. 6/14-6/17/2021 Warner,Ty- Kiel, Justin-Topoll, George

7/13/2021		Payroll		$ 35,930.93	$ 35,930.93		Pay period ending 7/4/2021
7/13/2021	4348	South Shore Clean Cities	General Fund 5410.1	$ 240.00	$ 240.00	2831	2021 SSCC Annual Conf & Expo- 6ppl
7/13/2021	4349	South Shore Clean Cities	General Fund 5410.5	$ 200.00	$ 200.00	2831	2021 SSCC Air Golf Outing Hole Sponsorship- PCA
7/13/2021	B-5327	County	General Fund 2147.0	$ 33.85	$ 33.85	2832	6/21-7/4/2021 pay period
7/14/2021	4364	Barloga II, Mitchell	General Fund 5410.0	$ 967.39	$ 967.39	C4364	Walk Bike Place Conf.- Hotel and Expenses 6/15-6/18/2021-Indianapolis
7/14/2021	4344	Ecointerative	General Fund 5610.2	$ 3,750.00	$ 3,750.00	C4344	TIP SAAS Service-monthly service fee
7/14/2021	4340	Fidelity EyeMed	General Fund 2154.0	$ 99.01	$ 99.01	C4340	Vision Insurance
7/14/2021	B-5324	INPRS	General Fund 2149.0	$ 6,012.41	$ 6,012.41	C5324	6/21-7/4/2021 pay period- EmpPerf [NIRPC]
7/14/2021	4360	Warner,Tyson	General Fund 5244.9	$ 125.00	$ 125.00	C4360	Communication Expense-JULY
7/15/2021	4358	Horizon Bank	General Fund 5142.9	$ 19,000.00	$ 19,000.00	C4358	ER paid Health Savings- JULY
7/15/2021	4354	IN Dept of Workforce Dev.	General Fund 5123.9	$ 22.20	$ 22.20	C4354	SUTA Payment Q2 (APR-JUN) 2021
7/18/2021		Payroll	General Fund	$ 35,930.93	$ 35,930.93		Pay period ending 7/27/2021
7/27/2021	B-5350	Federal & Fica	General Fund 2140.0	$ 4,534.95	$ 4,534.95	C5350	7/5-7/18/201 pay period- FWT,empfica, empficamed Federal Tax withholding Payable
7/27/2021	B-5350	Federal & Fica	General Fund 2142.0	$ 7,107.26	$ 7,107.26	C5350	7/5-7/18/2021 pay period-FWT, empfica, empficamed-FICA Tax Withholdings Payable
7/27/2021	B-5353	Horizon Bank	General Fund 2150.0	$ 372.31	$ 372.31	C5353	7/5-7/18/2021 pay period-HSA
7/27/2021	4366	ICMA Retirement Fund-PR	General Fund 5145.9	$ 855.91	$ 855.91	C4366	ER paid for Ty Warner 7/5/2021 thru 7/18/2021 p/r
7/27/2021	B-5354	ICMA Retirement Fund-PR	General Fund 2146.0	$ 530.00	$ 530.00	C5354	7/5-7/18/2021 pay period-ICMA
7/28/2021	4397	City of Portage	General Fund 5221.9	$ 18,775.18	$ 18,775.18	2835	Lease-JULY
7/28/2021	4395	City of Portage	General Fund 5224.9	$ 2,048.64	$ 2,048.64	2835	Sewer/Water/Gas/Electric
7/28/2021	4356	Earth Charter Indiana Inc.	General Fund 5610.5	$ 6,000.00	$ 6,000.00	2836	2021 Climate Fellow Stipend $1500 per student *4
7/28/2021	B-5352	INPRS	General Fund 2149.0	$ 6,012.41	$ 6,012.41	C5352	7/5-7/18/2021 pay period-EmpPerf {NIRPC}
7/28/2021	3801	Northwest Indiana Forum Foundation	General Fund 5610.5	$ 4,359.74	$ 4,359.74	2838	Programmatic Support & Outreach-Hazardous and Petroleum
7/28/2021	4396	Southshore Baseball, LLC	General Fund 5410.5	$ 2,000.00	$ 2,000.00	2840	Half Page Program Advertisement/Clean Air Game Sponsorship/Partners for Clean Air Even-
7/28/2021	4367	United State Treasury	General Fund 5142.9	$ 50.54	$ 50.54	4367	Quarterly Federal Excise Tax Return- JULY
7/28/2021	B-5355	County	General Fund 2147.0	$ 33.85	$ 33.85	2841	7/5-7/18/201 pay period-United Way
7/29/2021	4388	Lake County Community Service, INC	General Fund 5760.0	$ 35,573.00	$ 35,573.00	C4388	2nd Quarter 2021 PMTF Reimbursement
7/29/2021	4385	North Township	General Fund 5760.0	$ 18,360.00	$ 18,360.00	C4385	2nd Quarter 2021 PMTF Reimbursement
7/29/2021	4386	Opportunity Enterprises	General Fund 5760.0	$ 41,311.00	$ 41,311.00	C4386	2nd Quarter 2021 PMTF Reimbursement
7/29/2021	4387	Porter County Aging Community Services	General Fund 5760.0	$ 19,508.00	$ 19,508.00	C4387	2nd Quarter 2021 PMTF Reimbursement
7/29/2021	4368	Warner,Tyson	General Fund 5410.9	$ 1,069.80	$ 1,069.80	C4368	Reginstration for ICMA Conference-Portland, OR Airfate for ICMA Conference- Portland,
				Total:	$ 316,417.62

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

Dated this day of

,2021.

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)

Date

Filed

Claim

Number

Name of Claimant

Fund

Fund Amount

Amount of

Claim

Check #

Notes

7/12/2021

4311

Ram Mounts

General Fund

5960.0

$ 718.08

CC4311

Ram Tab- Tite Spring Loaded Holder/Ram Stubby Holder Mount/Shipping-North Township

7/12/2021

4318

Weathertech

General Fund

5960.0

$ 237.90

CC4318

Front and Back- Floor Liners for F-150 and F- 250/Shipping-ECT

7/13/2021

4293

Morgan Birge & Associates

General Fund 5960.0

$ 7,796.90

2829

North Township Misc Equipment--Dell Monitors,

Desktop Computers, Lenovo ThinkPad, Canon Printer, Microsof Office 2019 Home and Business Box Pac, Cables, Labor Charges and Shipping

7/14/2021

4352

Routematch

General Fund

5960.0

$ 2,065.00

C4352

LCCS/NT/PC

7/28/2021

4202

Best Servers

General Fund

5960.0

$ 131.25

2833

Purchase a refurbished server for LCCS to

upgrade

7/28/2021

4335

Bosak Ford

General Fund

5960.0

$ 1,499.76

2834

F-150 Parts- Filters-Screens /F-250 Parts - Filters Screens- ECT

7/28/2021

4361

Grainger

General Fund

5960.0

$ 97.81

2837

Black Tool drawer liner roll/Safety Sign #471T26 and Safety Sign #469Z81 --ECT

7/28/2021

3960

Pulse Technology

General Fund

5430.9

$ 28.99

2839

Office Supplies- Covid 19/CARES

Total:

$ 12,575.69

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

Dated this day of ,2021.

MEMORANDUM

TO: NIRPC Finance & Personnel Committee and All Commission Members FROM: Denarie Kane, Economic Development District Coordinator, NIRPC

RE: ECONOMIC RESILIENCY PLAN CONSULTANT SELECTION and CONTRACT

DATE: September 8, 2021

A Request for Proposal (RFP) was solicited on August 23, 2021, from five economic development/planning consultants. The five consultants were chosen based on scores from a prior solicitation requesting responses to a Request for Qualifications (RFQ). The scope of the work required for the Economic Resiliency Plan includes:

Create and distribute a community needs survey regarding economic impact of the pandemic to be distributed to residents, businesses, and organizations in Lake, Porter, and La Porte counties.
Aggregate and analyze quantitative and qualitative data from the survey. Extrapolate data for use in a regional short-term economic endurance strategy.
Identify and contact relevant regional stakeholders.
Facilitate 15-30 community meetings, organized roughly by industry/sector, with stakeholders regarding pandemic’s impact on their respective organizations, industries, and communities.
Aggregate and analyze qualitative data from community meetings. Extrapolate data for use in a regional long-term economic recovery strategy and a regional long-term resiliency strategy.
Prepare written documents for a short-term economic endurance strategy, a long-term economic recovery strategy, and a long-term economic resiliency strategy which is to include broadband expansion to support economic development opportunities.
Present the Economic Resiliency Plan at a Spring 2022 event.

Responses to the RFP are due at noon on September 10, 2021. After the scoring of the RFP responses, interviews will be conducted with the two top scoring consultants on the morning of September 14, 2021. A decision will be known after the conclusion of the interviews and prior to the meeting on September 16, 2021. The Finance & Personnel Committee and Commission will be advised of the choice at the meeting.

A draft contract has been requested from each consultant. This draft contract may or may not be used to develop the final contract. A request is being made of the Finance & Personnel Committee to recommend that the Commission authorize the Executive Director to negotiate the final terms of the contract in coordination with NIRPC’s attorney. It is also requested that the Finance & Personnel Committee recommend that the Commission authorize the Executive Director to executive the final contract on behalf of the Commission in an amount not to exceed

$112,000.

RESOLUTION 21-16 ‌

A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION REQUESTING RELEASE OF THE LA PORTE COUNTY REVOLVING LOAN PROGRAM FROM CERTAIN REQUIREMENTS OF THE ECONOMIC DEVELOPMENT ADMINISTRATION (EDA).

Whereas, the Northwestern Indiana Regional Planning Commission (hereafter referred to as “The Commission”) operates a Revolving Loan Fund for La Porte County under the Economic Development Administration (EDA) of the U.S. Department of Commerce; and

Whereas, the Commission is in receipt of a letter dated February 2, 2021, from the EDA (attached to Resolution 21-16 as Exhibit “A”) inviting a request to release the EDA’s federal interest in an EDA revolving loan fund award; and

Whereas, the Revolving Loan Fund for La Porte County (hereafter referred to as “The RLF”) is potentially eligible to be released which will reduce the Commission’s administrative burdens and allow RLF award funds to be used for broader economic development purposes; and

Whereas, the La Porte County Revolving Loan Managing Board (hereinafter referred to as “The Board”) met on August 18, 2021, and recommends the release of the EDA’s federal interest in the RLF; and

Whereas, the Board recommends that the La Porte County revolving loan fund program continue operation upon approval by the Commission and EDA; and

Whereas, the Finance and Personnel Committee has reviewed the recommendations from the Board and recommends the same to the Commission; and

Whereas, the Commission supports the request to release EDA’s federal interest in the RLF as outlined in Exhibit “A”; and

Whereas, the Commission will consider execution of an Agreement, yet to be finalized, after the EDA makes a determination on the request to release EDA’s federal interest in the RLF.

Now, Therefore Be It Resolved that the Commission approves

the request to release the EDA’s federal interest in the La Porte revolving loan fund program, and
the continuation of the La Porte County revolving loan fund program.

Duly adopted by the Northwestern Indiana Regional Planning Commission this 16th day of September 2021.

George Topoll Chairperson

ATTEST:

Richard Hardaway Secretary

U.S. DEPARTMENT OF COMMERCE Economic Development Administration Chicago Regional Office

230 S. Dearborn Street, Suite 3280

Chicago, Illinois 60604

EXHIBIT A VIA EMAIL

February 2, 2021

Tyson Warner Executive Director

Northwestern Indiana Regional Planning Commission 6100 Southport Rd

Portage, IN 46368

Re: Invitation to request release of EDA’s federal interest in EDA revolving loan fund award

The recently enacted Reinvigorating Lending for the Future Act (the Act) authorizes EDA to release its federal interest in certain Revolving Loan Fund (RLF) awards that have operated satisfactorily for seven years beyond disbursement of grant funds. By authorizing EDA to release its federal interest in certain RLF awards, the Act will reduce RLF recipient administrative burden and allow RLF award funds to be used for broader economic development purposes.

To request that EDA release its federal interest in an RLF award, you must submit to EDA a written request for release that includes the information below. If you seek a release of EDA’s federal interest for more than one RLF award, this information must be submitted separately for each RLF award.

Your organization’s name and contact information;
Identifying information for the RLF award, including the award number, date of award, federal investment rate, and evidence that final disbursement occurred more than seven years ago (if available);
Value of the RLF award (including the capital base and any available administrative income);
Proposed use of RLF award funds for one or more activities that continue to carry out the economic development purposes of PWEDA, which may include continued operation of the RLF; and
Certification by your organization that it has complied with the terms and conditions of the RLF award.

Additionally, you must provide the following supplemental materials:
Resolution or letter from your organization’s Board of Directors, or agency leadership if your organization is a public entity or otherwise does not have a Board of Directors, supporting the request to release EDA’s federal interest and committing to using the RLF for one or more activities that continue to carry out the economic development purposes of PWEDA in compliance with on-going restrictions required by the Act as articulated in the release agreement;
Final RLF Financial Report (Form ED-209) for the RLF award; and
Most recent Single Audit for your organization, if available. If a recent Single Audit is not available, the most recent audit or audited financial statements for your organization, if available.

EDA will review and evaluate requests for release of EDA’s federal interest in an RLF award, and EDA may request additional information. If EDA determines that your RLF award is eligible for release of EDA’s federal interest, the next step would be for EDA and your organization to execute an agreement to release EDA’s federal interest in the RLF award. A sample release agreement is attached for your reference, although the exact terms of the agreement may vary based on the individual circumstances of your RLF award. Please review the terms of the agreement, including the requirement that any RLF award funds be used for one or more activities that continue to carry out the economic development purposes of PWEDA. Your request letter will be included as an attachment to the agreement.

EDA plans to hold a webinar to share information about the release of EDA’s federal interest in certain RLF awards. EDA will notify you of the event when scheduled. In the meantime, if you have any questions regarding this letter, please reach out to Catherine Canavan, EDA RLF Administrator, via email at ccanavan@eda.gov.

Regards,

Susan Brehm Regional Director

U.S. Department of Commerce Economic Development Administration Chicago Regional Office

AGREEMENT TO RELEASE THE EDA FEDERAL INTEREST IN A REVOLVING LOAN FUND AWARD

THIS AGREEMENT is between the United States Department of Commerce, Economic Development Administration (EDA) and [Recipient Name] (Recipient).

WHEREAS, EDA, pursuant to its authority under the Public Works and Economic Development Act of 1965 (PWEDA) (42 U.S.C. § 3121 et seq.), awarded to Recipient one or more grants to capitalize a Revolving Loan Fund (RLF) bearing EDA award number(s) [NUMBER(S)] (the Award).

WHEREAS, EDA retains a federal interest in the Award and Recipient has submitted a written request that EDA release its federal interest in the Award consistent with the requirements of the Reinvigorating Lending for the Future Act (Pub. L. 116-192), attached hereto as Appendix A (the Request).

WHEREAS, EDA and Recipient agree that the current value of the RLF capital base is

$[AMOUNT], the federal investment rate is [PERCENT]%, and the federal share of the RLF capital base is $[AMOUNT] (the Award Funds).

WHEREAS, EDA has determined that 1) more than seven years have passed since the final EDA disbursement to Recipient of funds under the Award, 2) Recipient has complied with the terms and conditions of the Award, and 3) Recipient proposes to use the Award Funds for one or more activities that continue to carry out the economic development purposes of PWEDA.

WHEREAS, EDA agrees herein to release its federal interest in the Award and Recipient agrees herein to use Award Funds for one or more activities that continue to carry out the economic development purposes of PWEDA.

NOW THEREFORE, EDA and Recipient agree as follows:

EDA’s Release. EDA agrees to release its federal interest in the Award. EDA’s reversionary interest in the Award will cease to exist as of the effective date of this agreement.
1. Recipient’s use of Award Funds no longer needs to comply with, among other things, the following authorities:
  1. OMB regulations at 2 CFR part 200, including the Compliance Supplement at Appendix XI.
  2. EDA regulations at 13 CFR chapter III, including the RLF-specific regulations at part 307, subpart B (including the requirement at 13 CFR
    § 307.14 to submit Form ED-209 RLF Financial Report to EDA).
  3. The terms and conditions attached to the Award, including the Department of Commerce’s Standard Terms & Conditions, the EDA RLF Standard Terms & Conditions, and any Special or Specific Award Conditions.
  4. The EDA-approved RLF plan or any related document governing administration of the Award.
2. This release of the EDA federal interest in the Award does not extend to or include a release of any other entity’s interest in the RLF capital base, including another federal agency’s interest in the RLF capital base. More specifically, if Community Development Block Grant funds from the U.S. Department of Housing and Urban Development (HUD) or funds from the U.S. Department of Agriculture (USDA) were used as local share under the Award, this release of the EDA federal interest does not extend to or include a release of any HUD or USDA federal interest in the RLF capital base. If Recipient seeks a release of another entity’s interest in the RLF capital base, including another federal agency’s interest in the RLF capital base, Recipient must negotiate such a release with the other entity and EDA will not participate in that negotiation.
Recipient’s Use of Award Funds. Recipient agrees to use Award Funds for one or more activities that continue to carry out the economic development purposes of PWEDA.
1. Recipient shall not use Award Funds to construct schools, community centers, municipal buildings, or otherwise use Award Funds to carry out activities outside of the economic development purposes of PWEDA, nor shall Recipient use Award Funds to pay general costs of government.
2. Recipient shall not transfer Award Funds to a natural person, for-profit entity, or other entity ineligible for award under sections 3(4) and 209 of PWEDA (42
  U.S.C. § 3122(4) and § 3149). For the sake of clarity, Award Funds may be used to contract with for-profit entities for goods and services for one or more activities that continue to carry out the economic development purposes of PWEDA and to operate an RLF that makes loans to for-profit organizations.
3. Award Funds must be used in a manner consistent with EDA’s non-relocation policy. Specifically, Recipient shall not use Award Funds to induce the relocation of existing jobs within the U.S. that are located outside of a jurisdiction to within that jurisdiction in competition with other U.S. jurisdictions for those same jobs.
4. Award Funds must be used in accordance with section 602 of PWEDA (42 U.S.C.
  § 3212). Specifically, Recipient shall ensure that all laborers and mechanics employed by contractors or subcontractors on projects assisted by Award Funds shall be paid wages at rates not less than those prevailing on similar construction in the locality as determined by the Secretary of Labor as provided by section 602 of PWEDA or as it may be amended in the future.
5. Recipient shall use Award Funds in accordance with applicable federal, state, and local law, including applicable non-discrimination law. Recipient may not use Award Funds for any purpose that would be prohibited by the Establishment Clause of the U.S. Constitution if the Award Funds were expended directly by the Federal Government.
6. Recipient is not required by the terms of this Agreement to seek EDA approval or permission to use Award Funds for one or more activities that continue to carry
  out the economic development purposes of PWEDA but that differ from the activities described in the Request, attached hereto as Appendix A.
7. Recipient shall provide timely and accurate responses to EDA inquiries regarding Recipient’s use of the Award Funds. Following the release of EDA’s federal interest, EDA remains interested in working with Recipient to promote Recipient’s RLF or other activities that continue to carry out the economic development purposes of PWEDA.
Enforcement. In the event that EDA determines that Award Funds have been used in a manner inconsistent with this agreement, EDA may require Recipient to return the misspent portion of the Award Funds to the Federal Government, which may include the establishment of a debt with the U.S. Department of the Treasury.
Indemnification. To the extent permitted by law, Recipient agrees to indemnify and hold the Federal Government harmless from and against all liabilities that the Federal Government may incur as a result of releasing EDA’s federal interest in the Award.
Governing Law; Severability. This Agreement is governed by applicable federal law, if any, and if there is no applicable federal law by state law. The terms of this Agreement do not limit the rights EDA, its designees, successors, or assigns are entitled to under applicable federal or state law. In the event that any provision or clause of this Agreement conflicts with applicable law, such conflict shall not affect other provisions of this Agreement that can be given effect without the conflicting provision, and to this end the provisions of this Agreement are declared to be severable.
Entire Agreement. This Agreement contains the entire understanding of EDA and Recipient with respect to the subject matter hereof and supersedes all prior agreements and understandings, oral or written, with respect to such matters.
Authority. Recipient represents that (a) it has the power and authority to execute and perform this Agreement, (b) the execution and performance of this Agreement by Recipient have been duly authorized by all necessary corporate or other actions, (c) Recipient has duly and validly executed this Agreement, and (d) this Agreement is a legal, valid and binding obligation, enforceable against Recipient.

[Remainder of this page intentionally left blank.]

IN WITNESS WHEREOF, EDA and Recipient have caused this Agreement to be duly executed by their respective officers as of the date indicated.

DEPARTMENT OF COMMERCE, ECONOMIC DEVELOPMENT ADMINISTRATION

[RECIPIENT NAME]

By:

[NAME]

Regional Director [CITY] Regional Office

By:

[Authorized Signatory Name] [Authorized Signatory Title]

Date Date

Appendix A

[Attach Recipient’s written request that EDA release its federal interest in the Award.]