FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda

Thursday, January 21, 2021 -- 8:00 a.m.

Meeting ID: 912 3224 9318 Passcode: 183340

Call to Order

6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
www.nirpc.org
Meeting Minutes of November 19, 2020 Pages 1-3
Review of Financial Status – November 2020 Pages 4-12
1. Bank Statement Reconciliation
2. General Fund Expenses YTD November 2020 – Budget vs Actual
3. General Fund Revenue YTD November 2020 – Budget vs Actual
4. CARES Expenses YTD November 2020 - Budget to Actual
5. CARES Revenue YTD November 2020 - Budget to Actual
Approval of General Fund Claims Register – November 2020 Pages 13-15
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register - November 2020 Pages 16
ACTION REQUESTED: Approval
December Bank Statement Reconciliation Pages 17-20
Approval of General Fund Claims Register – December 2020 Pages 21-23
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register - December 2020 Pages 24
ACTION REQUESTED: Approval
Procurement #21-01 Pages 25
ACTION REQUESTED: Recommendation
CARES RLF Loan Committee Member Appointments Pages 26-28
ACTION REQUESTED: Approval
Kankakee River Basin and Yellow River Basin Development Commission Pages 29-31 support agreement
Personnel update
Other Business
Adjournment

The next meeting is scheduled for March 18, 2020 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

November 19, 2020 / Zoom Virtual Meeting – 8:00 a.m.

Members Present

Richard Hardaway, Jan Bapst, Bob Carnahan, Justin Kiel, George Topoll, John Yelkich Staff and Others Present

Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Stephanie Kuziela, Meredith Stilwell, David Hollenbeck

Call to Order

Richard Hardaway called the meeting to order with the Pledge of Allegiance.

Approval of Minutes

The minutes of the October 15, 2020 meeting were presented. Jan Bapst made motion and George Topoll seconded to approve the minutes.

Review of Financial Status – October 2020

Talaya Jones presented the October 2020 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account. The general account beginning balance from 10/1/2020 was

$1,312,796.77 with a closing balance of $1,048,472.95 as of 10/31/2020. The RLF account beginning balance from 9/1/2020 was $142,024.84 with a closing balance of $149,906.07 as of 10/31/2020.

Talaya presented the financial status report for category expenditures year to date, October 2020.

$1,017,467 has been expended of the $1,293,260 Salaries budget. $395,592 has been expended of the

$509,690 Fringe Benefits budget. $226,287 has been expended of the $280,297 Occupancy budget.

$55,264 has been expended of the $78,840 Maintenance budget. $77,964 has been expended of the

$196,750 Departmental budget. $339,077 has been expended of the $884,465 Contractual budget.

$6,736 has been expended of the $100,000 Capital Outlays budget. Total General Fund expenditures totaled $2,118,387 of the $3,343,302 budgeted. $200 has been expended of the $85,000 LaPorte Revolving Loan Fund budget. $2,614,854 has been expended of the $2,440,988 Transit Capital Fund budget. Year to date, total expenditures of $6,358,418 of the $10,258,326 budgeted, $3,899,908 under budget.

Talaya presented the year-to-date October 2020 expended by category chart. 48% of the expended budget was salaries, 19% fringe benefits, 16% contractual, 11% occupancy, 4% departmental and 2% maintenance.

Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual expenditures year to date, October 2020. Per the State Board of Accounts, the CARES Act and general funds must be reported separately. $47,819 of the $236,733 has been expended of the Salaries budget. $0 of

$5,000 contractual, RLF Services budget has been expended. $15,532 of the $25,000 departmental, PPE Supplies, budget has been expended. $2,160 of the $165,000 Capital Outlays, Furniture and Equipment, budget has been expended. Total NIRPC CARES Fund Expenditures of $65,511 had been expended from the $431,733 budget. $0 of the $583,000 CARES Revolving Loan Fund budget has been expended.

$30,825 of the $1,219,972 CARES Transit Capital Fund budget has been expended. $1,092,610 of the

$4,314,322 CARES Agency Fund has been expended. Total expenditures were $1,188,946 of the

$6,549,027 budgeted.

Talaya presented the year-to-date October 2020 budget vs. actual revenue report. $366,669 of the

$540,271 county appropriations budget has been collected. $184,337 of the $539,733 federal agencies budget has been collected. $1,337,675 of the $1,935,395 state agencies budget has been collected.

$24,224 of the $44,694 local agencies budget has been collected. $11,051 of the $135,318 non- governmental funds budget has been collected. $13,288 of the $70,000 Economic Development District budget has been collected. $8,391 of the $9,682 interest income budget has been collected.

Talaya presented the year-to-date revenue by funding source chart as of October 31. 69% of collected revenue

has been from state agencies, 19% from county appropriations, 9% from federal agencies, 1% from local agencies, 1% from Economic Development District, and 1% from interest income.

Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual revenue year to date, October 2020. All revenue is federal and is classified as Economic Development District or FTA.

$172,446 has been collected of the $604,229 total CARES Act revenue budget. The State quarterly reimbursement has not been received yet and some money collected is not recognized yet because the programs have not started yet.

Approval of Claims Register – October 2020

Talaya first presented the October 2020 regular claims register totaling $611,057.94 to the Committee for approval. Bob Carnahan made motion and Jan Bapst seconded to approve the October 2020 regular claims register. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0. The CARES Act expenditures register of claims totaling $25,171.25 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the October 2020 CARES Act claims register. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.

Executive Director Contract – 2021 Employee Agreement Addendum

This agreement was signed in 2018 and provides that Ty meets with the NIRPC chair for a review of performance and expectation of goals, with the Chairman then making a recommendation for salary for each calendar year. The recommended increase for 2021 is 3%. NIRPC is incorporating a 3% increase for all employees for 2021 as well. This addendum, which only addresses compensation, to be extended into the third and final contract year must go before the NIRPC Full Commission to be approved upon recommendation from the Finance and Personnel Committee. Justin Kiel questioned if last year’s increase was 3% and it was noted that it was 4.5%. Jan Bapst made motion and Justin Kiel seconded to recommend the addendum to the Executive Director Contract for a salary increase of 3% for 2021 to the NIRPC Full Commission for approval. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.

NIRPC Budget – Calendar Year 2021 – NIRPC Resolution #20-29

Talaya presented and explained the finalized 2021 budget, noting changes from the preliminary budget presented at the September 2020 meeting. When the budget for CY 2021 CARES ACT 2020 Transit Capital Projects Fund, which are 100% funds, with no match, was presented Jan Bapst questioned why the City of Gary was not on the list and it was explained that GPTC and Michigan City are direct recipients and are not NIRPC subrecipients. Justin Kiel asked how the capital projects fit into CARES ACT funds and Ty Warner explained that the FTA rational was that transit would be hit hard overall and did not restrict the expenditure of the funds. Jan Bapst made motion and Justin Kiel seconded to approve the budget as presented with recommendation to the NIRPC Full Commission for approval. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.

Vehicle Disposition Sales

Lisa Todd presented information regarding 2 vehicles disposition sales, one held at NIRPC on November 18 and one to be held at East Chicago Transit on November 19. The vehicles have met what is considered their useful life by FTA requirements in number of miles or years. The sales were both advertised. All 14 vehicles at the sales located at NIRPC were sold and the bid opening was livestreamed and recorded.

Personnel updates

Meredith Stilwell reported that the 2 open EDA CARES ACT funded positions for a Communications Specialist and Economic Development Specialist have bene filled. The new Communications Specialist, Lucas Ecklund- Baker, started November 9 and the new Economic Development Specialist, Denarie Kane, will be starting on November 23.

Other Business

Bob Carnahan reported that Cedar Lake purchased 5 ultraviolet sanitizers with CRES ACT money. They were

$3,500 each and can be set for a timing period to sanitize rooms.

Adjournment

There being no further business, the meeting was adjourned.

32	Deposits and Other Additions Totaling................................................. .....................		1,560,973.03
108	Checks and Other Withdrawls Totaling.................................................................. ...		1,437,341.01
0	Adjustments		0.00
	Voids		3,599.00
	Service	11/10/2020	95.92
	Interest	11/30/2020	94.38
Closing Balance for this Statement..................................................................................................		11/30/2020	1,195,830.97
Difference............................................................................. ..................................			0.00
Cash Balance from General		11/30/2020	1,190,240.13
Open Activity from Bank Register..................... ........................................................			(5,590.84)
Adjustment for Service Charges and Interest.............................................................			0.00
General Ledger Reconciliation to Statement..............................................................................................			1,195,830.97
Date Reference Deposit Description			Amount
8/08/2019 8272335 1/2 August 2019 RLF payment			-269.64

Total Unmarked Deposits:	-269.64	Total Deposits:	-269.64
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	B/5 - 8/18/2019 pay period - United Way	33.85
2/25/2020 0002572 Ecointeractive , Inc . 4/09/2020 0002545 Anthem Life		TIP SAAS SERVICE- monthly srvc fee ending 2/29/20 Life Ins for April 2020	3,750.00 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
Total Unmarked Checks:	5,321.20	Total Checks:	5,321.20

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 12/22/2020@ 8:55 AM

Reconciliation - General

/s1( IJ/JJ IJo

Page:

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

10/31/2020

12/30/2020

1,068,601.49

‌

Trial Balance - Cash

Run: 1212212020 at 9:3:/,1.QRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 11/30/2020

Page: 1

All

1.1.001.0000.1010.0 Cash

Total

Balance

1,190,240.13

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 12/22/2020@ 9:36 AM

Reconciliation - Revolving Loan Fund

Page:

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

10/31/2020

149,906.07

7	Deposits and Other Additions Totaling.....................................................................		5,178.31
O	Checks and Other Withdrawls Totaling.....................................................................		0.00
0	Adjustments Totaling..............................................................................................		0.00
0	Voids		0.00
	Service		0.00
	Interest	11/30/2020	8.87
Closing Balance for this Statement.....................................................................................................		11/30/2020	155,093.25
Difference.................... ...........................................................................................			0.00
Cash Balance from General Ledger....................................................................................................		11/30/2020	155,093.25
Open Activity from Bank Register.............................................................................			0.00
Adjustment for Service Charges and Interest.............................................................			0.00
General Ledger Reconciliation to Statement.............................................................................................			155,093.25

\J.

/s l)aJ/Jo

Trial Balance - Cash

Run: 1212212020 at 9:3!NQRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 11/30/2020

Page: 1

All

2.3.050.0000.1010.0 Cash

Total

Balance 155,093.25

155,093.25

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ‌

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020

Line Items

FY 2020 Budget

FY 20

YTD November YTD Variance YTD % Budget % Expended (Over)/Under Variance balance

Salaries

5020-1

Total Salaries

1,293,260

1,105,540

79,949

15%

Salaries Sub-Total

1,293,260

1,105,540

79,949

15%

Fringe Benefits
5121-9	FICA Contributions	104,321	86,018	9,610	10%	18%
5122-9	Workers Compensation	6,100	2,950	2,642	47%	52%
5123-9	Unemployment Compensation	1,650	1,092	421	28%	34%
5141-9	PERF Contributions	159,118	145,284	574	0%	9%
5142-9	Health Insurance	170,501	151,872	4,421	3%	11%
5143-9	Life & Disability Insurance	23,000	16,535	4,548	22%	28%
5145-9	ICMA	25,000	19,108	3,808	17%	24%
5146-9	Staff Development	20,000	4,149	14,184	77%	79%
	Fringe Benefits Sub-Total	509,690	427,008	40,208	9%	16%

Occupancy
5221-9	Office Lease	225,500	206,527	181	0%	8%
5222-9	Property Insurance	6,500	4,901	1,058	18%	25%
5223-9	Building Maintenance	18,540	16,722	273	2%	10%
5224-9	Utilities	29,757	20,377	6,900	25%	32%
	Occupancy Sub-Total	280,297	248,527	8,412	3%	11%

Maintenance
5241-9	Copier Leasing/Maintenance	19,400	3,581	14,203	80%	0%
5243-9	Computer Service/Maintenance	40,440	41,238	(4,168)	-11%	0%
5244-9	Telephone Service/Maintenance	18,000	10,472	6,028	37%	0%
	Combined Copier/IT/Phone Service/Maintenance	77,840	55,290	16,063	23%	29%
5249-9	Other Equipment Maintenance	1,000	364	553	60%	64%
	Maintenance Sub-Total	78,840	55,654	16,616	23%	29%
Departmental
5410-1	Communications: Commission/Ex. Dir.	41,500	11,280	26,762	70%	73%
5410-2	Communications: Transportation	60,000	16,761	38,239	70%	72%
5410-4	Communications: Subgrantee Management	15,000	260	13,490	98%	98%
5410-5	Communications: Environmental Programs	28,650	16,516	9,746	37%	42%
5410-8	Communications: Partner Agency	1,000	716	201	22%	28%
5410-9	Communications: Allocated Functions	28,000	16,836	8,830	34%	40%
5420-5	Promotional Expenses: Environmental Programs	15,600	17,405	(3,105)	-22%	-12%
5430-9	General Use Supplies Expense	7,000	1,066	5,350	83%	85%
	Departmental Sub-Total	196,750	80,839	99,515	55%	59%

Contractual
5602-9	Legal Services	19,800	18,150	0	0%	8%
5603-9	Audit and Accounting	69,000	33,065	30,185	48%	52%
5604-9	LaPorte RLF Services	2,000	0	1,833	100%	100%
5610-4	Transit Oversight	11,300	600	9,758	94%	95%
5610-5	Environmental Projects	522,374	259,103	219,740	46%	50%
5610-5	Alternative Fuel	70,991	0	65,075	100%	100%
5619-9	Organizational Dev.	2,000	0	1,833	100%	100%
5610-0	Board Development	2,000	0	1,833	100%	100%
5610-2	E-Tip	45,000	48,750	(7,500)	-18%	-8%
	Economic Development District	140,000	0	128,333	100%	100%
	Contractual Sub-Total	884,465	359,668	451,091	56%	59%

Capital Outlays

5910-0

Furniture and Equipment

100,000

6,736

84,930

93%

Capital Outlays Sub-Total

100,000

6,736

84,930

93%

TOTAL GENERAL FUND EXPENDITURES

3,343,302

2,283,972 780,721

25% 32%

LaPorte Revolving Loan Fund

85,000

400

Transit Capital Fund

2,440,988

2,614,854

2019 Transit Operating Fund

TOTAL EXPENDITURES

4,389,036 1,688,483

10,258,326 6,587,709

84,600

100%

(173,866)

-7%

2,700,553

62%

3,670,617

36%

1,200,000	1,185,488
1,000,000		1,105,540
800,000
600,000
400,000
200,000
-

CARES FUND EXPENDITURES

YTD November 2020 Expenses Budget vs Actual

810,760

467,216

427,008

359,668

256,939 248,527

180,354

72,270

55,654

80,839

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD November Budget YTD November Expended

YTD November 2020 Expended by Category

16%

48%

11%

19%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020

Revenue by Funding Source as of November 30, 2020

1% 1%

18%

70%

County Appropriations

Federal Agencies State Agencies Local Agencies

Non-Governmental

Economic Development District Interest Income

FY 20

Line Items

FY 2020 Budget

YTD November 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	539,733	189,348	(260,429)	-58%	65%
1.1.4310	State Agencies	1,935,395	1,414,667	(198,162)	-12%	27%
1.1.4410	Local Agencies	44,694	24,286	(12,959)	-35%	46%
1.1.4610	Non-Governmental	135,318	11,126	(101,639)	-90%	92%
1.3.4260	Economic Development District	70,000	13,288	(45,046)	-77%	81%
1.1.4800	Interest Income	9,862	9,299	1,081	13%	6%
	Revenue Total	3,275,273	2,028,683	(250,485)	-11%	38%

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020

Line Items	FY 2020 Budget	YTD November Expended	FY 20 Budget % balance
NIRPC CARES EXPENDITURES
Salaries
Salaries-FTA	236,733	57,543	76%
Salaries-CARES EDD		3,213
Salaries Sub-Total	236,733	60,756	76%

Contractual
RLF Services	5,000	-	100%
Contractual Sub-Total	5,000	-	100%

Departmental
Communications	500	103	79%
PPE Supplies & Office Supplies	25,000	15,469	38%
Departmental Sub-Total	25,000	15,572	38%
Capital Outlays

Furniture and Equipment	165,000	2,544	98%
Capital Outlays Sub-Total	165,000	2,544	98%

TOTAL NIRPC CARES FUND EXPENDITURES

431,733

78,872

82%

CARES Revolving Loan Fund

583,000

CARES Transit Capital Fund

1,219,972

137,057

CARES Transit Agency Fund	4,314,322	2,171,324
TOTAL EXPENDITURES	6,549,027	2,387,253

250,000

YTD November 2020 Expenses Budget vs Actual

236,733

200,000

165,000

150,000

100,000

57,543

50,000

25,000 15,572

3,213

5,000

2,544

SALARIES-FTA

SALARIES-CARES

EDD

CONTRACTURAL

DEPARTMENTAL CAPITAL OUTLAYS

Budget Expended

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020

	Line Items	FY 2020 Budget	YTD November Collected	FY 20 Budget % balance
CARES ACT FTA Revenue
	Operating Revenue	419,386	268,895	36%
	Capital Revenue	125,000	0	100%
CARES ACT EDA	Economic Development District	59,843	0	100%
	Revenue Total	604,229	268,895	55%

Revenue by Funding Source as of November 30, 2020

100%

CARES

Economic Development District

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

Date Filed

Claim

Number

Name of Claimant

Fund

Fund Amount

Amount of

Claim

Check #

Notes

11/3/2020

Payroll

$ 34,563.55

Payroll 10/25/2020

11/3/2020

3946

DeLage Landen Fin. Serv.

General 5243.9

Fund

$ 3,538.44

C3946

IT/Telephone/Copier Services

11/3/2020

3946

DeLage Landen Fin. Serv.

General 5244.9

Fund

$ 741.83

C3946

IT/Telephone/Copier Services

11/3/2020

3946

DeLage Landen Fin. Serv.

General 5241.9

Fund

$ 842.74

C3946

IT/Telephone/Copier Services

11/3/2020

B-4807

Federal & Fica

General 2140.0

Fund

$ 4,486.15

C4807

10/12-10/25/2020 pay period- FWT,empfica, empficamed - Federal Tax Withholdings payable

11/3/2020

B-4807

Federal & Fica

General 2142.0

Fund

$ 6,908.46

C4807

10/12-10/25/2020 pay period- FWT,empfica, empficamed FICA tax Withholdings Payable

11/3/2020

B-4810

Horizon Bank

General 2150.0

Fund

$ 395.38

C4810

10/12-10/25/2020 pay period -HSA

11/3/2020

4002

United HealthCare Srvcs, Inc

General 5142.9

Fund

$ 8,001.49

C4002

ER paid Insurance NOV

11/3/2020

4002

United HealthCare Srvcs, Inc

General 2152.0

Fund

$ 1,514.42

C4002

EE w/h's Insurance NOV

11/4/2020

3976

Accufund

General 5146.9

Fund

$ 199.00

2679

Training Accounts Payable- Marisol Manley

11/4/2020

3975

Accufund

General 5146.9

Fund

$ 199.00

2679

Training Accounts Receivable - Stephanie Kuziela

11/4/2020

3929

Adams Radio Group

General 5610.0

Fund

$ 3,710.00

2680

Live Radio Remote-Air Quality Gas Can

Excahnge at the Porter County Household Hazardous Waste Collection Event

11/4/2020

3848

American Management Association

General 5410.9

Fund

$ 2,445.00

2681

Meeting/Training: How to Communicate with Diplomacy

11/4/2020

3973

Anthem Life

General 5143.9

Fund

$ 458.40

2682

Life Insurance

NOV

11/4/2020

3964

Blachly, Tabor, Bozik & Hartman, LLC

General 5602.9

Fund

$ 1,650.00

2685

Legal - NOV

11/4/2020

3965

City of Portage

General 5221.9

Fund

$ 18,775.18

2684

Lease- NOV

11/4/2020

3974

City of Portage

General 5224.9

Fund

$ 1,965.92

2684

Sewer/Water/Gas Electric Service-OCT

11/4/2020

3977

Fidelity EyeMed

General 2154.0

Fund

$ 70.91

C3977

Vision Insurance - NOV

11/4/2020

3963

Health Resources

General 2153.0

Fund

$ 719.94

2685

Dental Insurance - NOV

11/4/2020

B-4809

INPRS

General

Fund

$ 5,803.18

C4809

10/12/2020-10/25/2020 pay period - EmpPerf [NIRPC]

11/4/2020

3971

INPRS

General

Fund

$ (0.01)

C3971

Rounding Adjustment 10/12 thru 10/25/2020- p/r

11/4/2020

3962

Kansas City Life

General 5143.9

Fund

$ 878.24

2687

Life Insurance - Disability- NOV

11/4/2020

3958

Pulse Technology

General 5430.9

Fund

$ 49.49

2689

Office Supplies- Binders

11/4/2020

3979

Porter County Soil & Water Conservation District

General 5610.5

Fund

$ 3,980.98

2688

Contractual -Lake Michigan Coastal Grants Program/Match

11/4/2020

3907

Purdue University Northwest NWI SBDC

General 5899.7

Fund

$ 200.00

2690

Technical Assistance for credit analysis - LaPorte

11/4/2020

B-4812

United Way of Porter County

General 2147.0

Fund

$ 33.85

2691

10/12-10/25/2020- pay period- United Way

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

11/5/2020

B-4786

IN Dept of Revenue

General Fund 2143.0

$ 1,429.02

C4786

9/28-10/11/2020 pay period -LwtIN, SwtIN

11/5/2020

B-4786

IN Dept of Revenue

General Fund 2144.0

$ 312.58

C4786

9/28-10/11/2020 pay period -LwtIN, SwtIN

11/5/2020

B-4765

IN Dept of Revenue

General Fund 2143.0

$ 1,428.37

C4765

9/14-9/27/2020 pay period - LwtIN, SwtIN- State Tax Withholdings Payable

11/5/2020

B-4765

IN Dept of Revenue

General Fund 2144.0

$ 312.48

C4765

9/14-9/27/2020 pay period -LwtIN, SwtIN- Loal Tax Withholdings Payable

11/5/2020

B-4762

IN Dept of Revenue

General Fund 2143.0

$ 132.22

C4762

Winters vacation payout - LwtIN, SwtIN- State Tax Wtihholdings Payable

11/5/2020

B-4762

IN Dept of Revenue

General Fund 2144.0

$ 20.47

C4762

Winters vacation payout - LwtIN, SwtIN- Local Tax Wtihholdings Payable

11/5/2020

3980

Total Disposal

General Fund 5223.9

$ 74.00

C3980

Recycle/Trash - NOV

11/6/2020

3981

Comcast

General Fund 5244.9

$ 139.64

C3981

Comcast Business- NOV

11/6/2020

3998

Warner, Ty

General Fund 5244.9

$ 125.00

C3998

Communication Expense - NOV

11/9/2020

B-4811

ICMA Retirement Fund-PR

General Fund 2146.0

$ 805.00

C4811

10/12-10/25/2020 pay period - ICMA

11/9/2020

3970

ICMA Retirement Fund-PR

General Fund 5145.9

$ 832.41

C3970

ER paid for Ty Warner 10/12-thru10/25/2020 - p/r

11/10/2020

Account Service Fee

General Fund

$ 95.92

Horizon bank service fee

11/10/2020

3914

Amazon

General Fund 5430.9

$ 49.98

C3914

Logitech USB Headset w/noise cancelling mic

11/10/2020

3914

Amazon

General Fund 5430.9

$ 14.58

C3914

DYMO Authentic LW mailing address labels

11/10/2020

3969

Amazon

General Fund 5410.5

$ 72.75

C3969

USB 3.0 flash Drive 64GB

11/10/2020

3967

Chicago Tribune

General Fund 5410.0

$ 27.72

CC3967

News Paper Subscription -NOV

11/10/2020

3997

SQUARESPACE

General Fund 5410.1

$ 216.00

C3997

Annually Subscription- Business website

11/10/2020

3968

Stamps.com

General Fund 5249.9

$ 100.00

C3968

Stamps.com

11/10/2020

3966

Stamps.com

General Fund 5249.9

$ 24.99

CC3966

Stamps.com

11/10/2020

3927

Survey Monkey

General Fund 5910.0

$ 384.00

C3927

One Year Renewal Survey Monkey Subscription

11/16/2020

4001

Bryco

General Fund 5223.9

$ 1,425.00

2692

Office Cleaning- NOV

11/16/2020

B-4846

United Way of Porter County

General Fund 2147.0

$ 33.85

2695

10/26-11/8/2020 PAY PERIOD- UNITED WAY

11/17/2020

Payroll

$ 34,026.31

Payroll 11/08/2020

11/17/2020

4006

Ecointeractive

General Fund 5610.2

$ 3,750.00

C4006

TIP SAAS Service- NOV

11/17/2020

4003

Ecointeractive

General Fund 5610.2

$ 3,750.00

C4003

TIP SAAS Service

11/17/2020

4004

Ecointeractive

General Fund 5610.2

$ 3,750.00

C4004

TIP SAAS Service

11/17/2020

B-4841

Federal & Fica

General Fund 2140.0

$ 4,403.09

C4841

10/26-11/8/2020 pay period- FWT, empfica, empficamed Federal Tax Withholddings

11/17/2020

B-4841

Federal & Fica

General Fund 2142.0

$ 6,802.56

C4841

10/26 -11/18/2020 pay period-FWT, empfica, empficamed FICA Tax Withhldings

11/17/2020

B-4844

Horizon Bank

General Fund 2150.0

$ 395.38

C4844

10/26-11/08/2020 pay period HAS

11/17/2020

4005

ICMA Retirement Fund-PR

General Fund 5145.9

$ 832.41

C4005

ER paid for Ty Warner 10/26-thru11/082020 - p/r

11/17/2020

B-4845

ICMA Retirement Fund-PR

General Fund 2146.0

$ 805.00

C4845

10/26-11/08/2020 pay period- HSA

11/18/2020

B-4843

INPRS

General Fund 2149.0

$ 5,704.89

C4843

10/26-11/08/2020 pay period - EmpPerf [NIRPC]

11/23/2020	4010	Porter County Aging and Community Services	General Fund 5760.0	$ 22,492.00	$ 22,492.00	C4010	3rd Quarter PMTF Reimbursement
11/23/2020	4011	South Lake County community Services	General Fund 5760.0	$ 41,014.00	$ 41,014.00	C4011	3rd Quarter PMTF Reimbursement
			General Fund		$ -
			General Fund		$ -

Total:

$ 237,913.16

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 allowed in the total amount of:

$ 237,913.16

Dated this day of , 2021.

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

Date Filed

Claim

Number

Name of Claimant

Fund

Fund Amount

Amount of

Claim

Check #

Notes

11/4/2020

3939

Kabelin Commerical Supply

General Fund 5960.0

$ 479.88

2686

Kombi Motor/Blower Attach/Head Trimmer

11/5/2020

3956

City of Valpo

General Fund 5960.0

$ 96,043.22

C3956

Valpo Dash & V-Line Facility /Mobilization and Demobilization

11/10/2020

3936

Northern Tool & Equipment

General Fund 5960.0

$ 444.99

C3936

Strongway 20-Ton Hydraulic Shop Press

11/10/2020

3937

Northern Tool & Equipment

General Fund 5960.0

$ 3,599.99

C3937

Northstar hot water pressure washer with wet steam

11/16/2020

3983

SLCCS

General Fund 5960.0

$ 1,062.00

2694

RouteMatch SLCCS - NOV

11/16/2020

3983

General Fund 5960.0

$ 531.00

2694

RouteMatch NT- NOV

11/16/2020

3983

PCACS

General Fund 5960.0

$ 472.00

2694

RouteMatch PCACS- NOV

11/16/2020

3960

Pulse Technology

General Fund 5430.9

$ 39.99

2693

Office Supplies-Lysol

11/20/2020

3984

Opportunity Enterprises

General Fund 5760.0

$ 121,653.00

C3984

OE Reimb for OA Jul-Sept 2020 Draw 34- CARES20

11/20/2020

3985

East Chicago Transit

General Fund 5760.0

$ 54,323.00

C3985

ECT Reimb for PM Jul- Sept 2020 Draw 33- CARES20

11/20/2020

3986

East Chicago Transit

General Fund 5760.0

$ 62,299.00

C3986

ECT Reimb for Paratransit Jul-Sept 2020 Draw32-CARES20

11/20/2020

3987

City of Valpo

General Fund 5760.0

$ 95,105.00

C3987

Valpo Reimb for CCC Jul-Sept 2020 Dash Draw 31-CARES20

11/20/2020

3988

City of Valpo

General Fund 5760.0

$ 166,974.00

C3988

Valpo Reimb for CCC Jul-Sept 2020 V-Line Draw 30-CARES20

11/20/2020

3989

City of Valpo

General Fund 5760.0

$ 54,786.00

C3989

Valpo Reimb for OA Jul-Sept 2020 Draw 29- CARES20

11/20/2020

3990

South Lake County Community Services

General Fund 5760.0

$ 28,280.00

C3990

SLCCS Reimb for PM Jul-Sept 2020 Draw 28- CARES20

11/20/2020

3991

South Lake County Community Services

General Fund 5760.0

$ 145,478.00

C3991

SLCCS Reimb for OA Jul-Sept 2020 Draw 27- CARES20

11/20/2020

3992

Porter County Aging and Community Services

General Fund 5760.0

$ 102,230.00

C3992

PCACS Reimb for OA Jul-Sept 2020 Draw 26- CARES20

11/20/2020

3993

City of LaPorte

General Fund 5760.0

$ 162,373.00

C3993

LaPorte Reimb for OA Jul-Sept 2020 Draw 25- CARES20

11/20/2020

3996

East Chicago Transit

General Fund 5760.0

$ 85,213.00

C3996

ECT Reimb for OA Jul- Sept 2020 Draw 20- CARES20

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

Total:

$ 1,181,387.07

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 allowed in the total amount of: $ 1,181,387.07

Dated this day of , 2021.

‌

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 1/12/2021 @ 2:27 PM Reconciliation - General Page:

Closing Balance from Previous Statement............................................. .............. ..............................	11/30/ 2020	1,195,830.97
14 Deposits and Other Additions Totaling........ .............................................................		631,789.82
112 Checks and Other Withdrawls Totaling....... ........ ..................... ................................		259,137.49
Adjustments Totaling..............................................................................................		269.64
Voids Totaling................... .... ...................................... ..........................................		3,750.00
Service	12/10/2020	125.00
Interest Earned. .............. ............................................. ................ .......... ..........	12/31/2020	104.34
Closing Balance for this Statement .....................................................................................................	12/31/2020	1,572,482.28
Difference.............................. ................ .... ...... ..... ....... .................. ............. .......... ..		0.00
Cash Balance from General Ledger........ ............... ...... ............. ...... ....... ..... ............. ........ .... ..............	12/31/2020	1,565,581.08
Open Activity from Bank Register............................. ............................................... .		(6,901.20)
Adjustment for Service Charges and Interest.............................................................		0.00
General Ledger Reconciliation to Statement..............................................................................................		1,572,482.28

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	B/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
12/15/2020	0002697 Blachly, Tabor, Bozik & Hartman. LLC	Legal- DEC	1,650.00
12/15/2020	0002703 IN Assoc of Regional Councils	A.nnual Membership Dues 2021	2,000.00
12/15/2020	0002704 INRO Consultants	Renewal Software Agreement 7/1/20-	1,680.00
	Total Unmarked Checks : 6,901.20	12/31/20 Total Checks :	6,901.20

/4\l

,)1ilJJ

Trial Balance - Cash

Run: 111212021 at 2:2e NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 12/31/2020

Page : 1

All

1.1.001.0000.1010.0 Cash

Total

Balance 1,565,581.08

1,565,581.08

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 1/12/2021@ 11:12 AM Reconciliation - Revolving Loan Fund Page:

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

11/30/2020

155.093.25

7	Deposits and Other Additions Totaling.......... ............................................................	5,178.31
0	Checks and Other Withdrawls Totaling.....................................................................	0.00
O	Adjustments Totaling............. ..................... ............................... ............................	0.00
O	Voids	0.00
		0.00
Interest Earned.............. ........ ....... ............... ...................... ..................... ....... .........		12/31/2020	9.35
Closing Balance for this Statement................................. .................... ....................... .........................		12/31/2020	160,280.91
Difference....................... .................................. ................... ...................................			0.00

Cash Balance from General

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

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

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

/s11L

1/11/JI

12/31/2020 160,280.91

0.00

160,280.91

(}'

....... ,,_..

Trial Balance - Cash

Run: 111212021 at 11:1J,l. RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 12/31/2020

Page : 1

All

2.3.050.0000.1010.0 Cash

Total

Balance

160,280.91

NORTHWESTERN INDIANA REGIONAL ‌

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

Date Filed

Claim

Number

Name of Claimant

Fund

Fund Amount

Amount of

Claim

Check #

Notes

12/1/2020

Payroll

$ 2,089.28

Pay period ending 11/22/2020

12/1/2020

Payroll

$ 34,857.64

Pay period ending 11/22/2020

12/1/2020

B-4867

Federal & Fica

General Fund 2140.0

$ 4,316.48

C4867

11/9 -11/22/2020 pay period- FWT, empfica, emficamed

12/1/2020

B-4867

Federal & Fica

General Fund 2142.0

$ 6,930.08

C4867

11/9-11/22/2020 pay period-FWT, empfica, emficamed

12/1/2020

B-4864

Federal & Fica

General Fund 2140.0

$ 400.88

C4864

Edwards vacation payout- FWT,empfica, empficamed

12/1/2020

B-4864

Federal & Fica

General Fund 2142.00

$ 432.10

C4864

Edwards vacation payout- FWT,empfica, empficamed

12/1/2020

B-4870

Horizon

General Fund 2150.0

$ 370.38

C4870

11/09-11/22/2020 pay period - HAS

12/1/2020

B-4871

ICMA Retirement Fund-PR

General Fund 2146.00

$ 805.00

C4871

11/9-11/22/2020-pay oeruid - ICMA

12/1/2020

4013

ICMA Retirement Fund-PR

General Fund 5145.9

$ 832.41

C4013

ER paid for Ty Warner 11/9 thru 11/22/20-p/r

12/2/2020

4029

De Lage Landen Financial

General Fund 5243.9

$ 3,538.44

C4029

12/2/2020

4029

De Lage Landen Financial

General Fund 5244.9

$ 741.83

C4029

Telephone

12/2/2020

4029

De Lage Landen Financial

General Fund 5241.9

$ 842.74

C4029

Copier Lesing Maintenance

12/2/2020

B-4869

INPRS

General Fund 2140.0

$ 5,819.68

C4869

11/9-11/22/2020 pay period-EmpPerf [NIRPC]

12/2/2020

B-4866

INPRS

General Fund 2149.0

$ 401.04

C4866

Edwards vacation payout - EmpPerf [NIRPC}

12/2/2020

B-4012

INPRS

General Fund 5141.9

$ 0.01

C4012

Rounding Adjustment 11/9- 11/22/2020 pr 12/01/2020

12/3/2020

4042

United Healthcare

General Fund 51429

$ 9,017.06

C4042

ER Paid for DEC2020 Health Insurance

12/3/2020

4042

United Healthcare

General Fund 2152.0

$ 1,706.52

C4042

EE w/h's for DEC Health Insurance

12/10/2020

4024

Chicago Tribune Media Group

General Fund 5410.1

$ 27.72

CC4024

News Paper Subscription

12/10/2020

3961

GoodHire

General Fund 5410.9

$ 54.99

CC3961

Standard background check new hire

12/10/2020

4036

ICMA

General Fund 5146.9

$ 1,217.00

CC4036

ICMA Membership Renewal 2021

12/10/2020

4015

Stamps

General Fund 5249.9

$ 24.99

CC4015

Stamps-DEC

12/10/2020

3978

Zoom

General Fund 5410.5

$ 119.92

CC3978

Zoom Pro Subscription -Yearly until 10/29/21

12/11/2020

4028

Anthem Life

General Fund 5143.9

$ 467.94

2696

Life Insrance

12/11/2020

4025

Blachly, Tabor, Bozik, Hartman, LLC

General Fund 5602.9

$ 1,650.00

2697

Legal- DEC

12/11/2020

4035

Bryco

General Fund 5223.9

$ 1,425.00

2698

Office Cleaning- DEC

12/11/2020

4027

City of Portage

General Fund 5221.9

$ 18,775.18

2700

Lease- DEC

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

12/11/2020

4033

City of Portage

General 5224.9

Fund

$ 1,874.31

2700

Sewer/Water/Gas/Electric Service

12/11/2020

4019

Health Resources

General 2153.0

Fund

$ 336.33

2701

Dental Insurance DEC

12/11/2020

4037

IN Assoc of Regional Councils

General 5410.0

Fund

$ 2,000.00

2703

Annual Memebership Dues 2021

12/11/2020

4017

Kansas City Life Insurance Co.

General 5143.9

Fund

$ 733.17

2705

Life Insrance

12/11/2020

4018

NWI Forum

General 5410.1

Fund

$ 1,100.00

2706

2021 Membership Dues

12/11/2020

4032

Skulski Consulting

General 5610.4

Fund

$ 11,300.00

2708

ADA Compliance Review 2020-Consulting

12/11/2020

B-4872

United Way of Porter County

General 2147.0

Fund

$ 33.85

2709

11/09-11/22/2020 pay period - United Way

12/11/2020

B-4878

United Way of Porter County

General 2147.0

Fund

$ 33.85

2709

11/23-12/6/2020 pay period - United Way

12/11/2020

3906

Woody Warehouse Nursery, Inc

General 5610.5

Fund

$ 4,742.28

2710

Purchase Trees fo rthe Communi Tree program

12/11/2020

3497

Woody Warehouse Nursery, Inc

General 5610.5

Fund

$ 3,791.60

2710

Purchase Trees fo rthe Communi Tree program

12/11/2020

4031

INRO Consultants

General 5410.2

Fund

$ 1,680.00

2704

Renewal Software Agreement 7/1/20-12/31/2020

12/14/2020

4034

Comcast

General 5244.9

Fund

$ 139.64

C4034

Business Internet- DEC

12/14/2020

4043

INBiz

General 5146.9

Fund

$ 21.50

C4043

Online payment service

12/14/2020

4022

Total Disposal

General 5223.9

Fund

$ 74.00

C4022

Recycle/Trash- DEC

12/15/2020

Payroll

$ 35,965.36

Pay period ending 12/06/2020

12/15/2020

4873

Federal & Fica

General 2140.0

Fund

$ 4,375.58

C4873

11/23-12/06/2020 pay period - FWT, empfica, emficamed

12/15/2020

4873

Federal & Fica

General 2142.0

Fund

$ 6,868.84

C4873

11/23-12/06/2020 pay period - FWT, empfica, emficamed

12/15/2020

4876

Horizon Bank

General 2150.0

Fund

$ 520.38

C4876

11/23-12/06/2020- pay period HAS

12/15/2020

4877

ICMA Retirement Fund-PR

General 2146.00

Fund

$ 805.00

C4877

11/23-12/6/2020 pay period ICMA

12/15/2020

4016

ICMA Retirement Fund-PR

General 5145.9

Fund

$ 832.41

C4016

ER paid for Ty Warner 11/23 thru 12/6/2020- p/r

Account Service Fee

$ 125.00

Service Fee

12/16/2020

4021

Ecointeractive

General 5610.2

Fund

$ 3,750.00

C4021

TIP SAAS Service

12/16/2020

4023

Fidelity EyeMed

General 2154.0

Fund

$ 80.18

C4023

Vision Insurance

12/16/2020

4875

INPRS

General 2149.0

Fund

$ 6,108.14

C4875

11/23-12/6/2020 pay period- EmpPerf [NIRPC]

12/16/2020

4842

IN Dept of Revenue

General 2143.0

Fund

$ 1,408.88

C4842

10/26-11/08/2020 pay period - LwIN, SwtIN State Tax Withholdings Payable

12/16/2020

4842

IN Dept of Revenue

General 2144.0

Fund

$ 306.66

C4842

10/26- 11/08/2020 pay period -LwIN, SwtIN Local Tax Withholdings Payable

12/16/2020

4808

IN Dept of Revenue

General 2143.0

Fund

$ 1,431.23

C4808

10/12-10/25/2020 pay period - State Tax Withholdings Payable

12/16/2020

4808

IN Dept of Revenue

General 2144.0

Fund

$ 313.23

C4808

10/12-10/25/2020 pay period - Local Tax Withholdings Payable

12/16/2020

4026

Warner, Ty

General

Fund

$ 125.00

C4026

Communication Expense - DEC

12/29/2020

Payroll

General

Fund

$ 37,643.28

Payperiod 12/29/20

12/30/2020

B-4931

Federal & Fica

General 2140.0

Fund

$ 4,663.51

C4931

Federal Tax Withholding Payable

12/30/2020

B-4931

Federal & Fica

General 2142.0

Fund

$ 6,696.14

C4931

FICA Tax Withholding Payable

12/30/2020

B-4934

Horizon Bank

General 2150.0

Fund

$ 520.38

C4934

12/7-12/20/2020

pay

period-

HAS

12/30/2020

B-4935

ICMA Retirement Fund-PR

General 2146.0

Fund

$ 805.00

C4935

12/7-12/20/2020 pay period

-ICMA

12/30/2020

4041

ICMA Retirement Fund-PR

General 5145.9

Fund

$ 832.54

C4041

ER paid for Ty Warner 12/7 thru 12/20/2020- p/r

12/30/2020

B-4933

INPRS

General 2149.0

Fund

$ 6,108.14

C4933

12/7-12/20/2020 pay period -EmpPerf[NIRPC]

General

Fund

$ -

Total:

$ 245,009.72

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 allowed in the total amount of: $ 245,009.72

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

12/11/2020

3938

CCL Supply LLC

General Fund

5960.0

$ 1,800.00

2699

Electrostatic Disinfection Guns

Hand Held

12/11/2020

3939

CCL Supply LLC

General Fund

5960.0

$ 98.10

2699

Electrostatic Disinfection Guns

Hand Held

12/11/2020

4030

RouteMatch

General Fund

5960.0

$ 1,062.00

2707

SLCC- DEC

12/11/2020

4030

RouteMatch

General Fund

5960.0

$ 531.00

2707

NT- DEC

12/11/2020

4030

RouteMatch

General Fund

5960.0

$ 472.00

2707

PCACS- DEC

12/11/2020

4014

Impact Networking LLC

General Fund

5910.0

$ 750.00

2702

Installation & Configuration Fee to

set up NIRPC

12/16/202

4020

Todd, Lisa

General Fund

5410.4

$ 12.92

C4020

Mileage- CARES

12/31/2020

4008

Porter County Aging and Community Services

General Fund 5960.0

$ 11,106.75

C4008

computers/DVD- RAM/WirelessCombos/LED monitors/Mounting

Total:

$ 15,832.77

Allowance of Claims

Procurement Recommendations January 21, 2021

Two (2) Replacement BOC Vehicles – Procurement #21-01

Purchase of:
o Two (2) vehicle replacements for LaPorte TransPorte - $118,400.00
Vehicles being replaced will have met their useful life of 4 years or 100,000 miles at the time of delivery.
Paid with Federal Transit Administration funds (80%) out of grant IN-2020- 039 and local share coming from the above listed agencies.
Recommendation to approve purchase of replacement vehicles not to exceed

$118,400.00 in federal funds.

MEMORANDUM

TO: NIRPC Finance & Personnel Committee

FROM: Gabrielle Biciunas, Economic Development District Coordinator NIRPC

RE: Appointment of CARES Regional Revolving Loan Fund Loan Committee Members DATE: January 21, 2021

NIRPC received funds from the Economic Development Administration (EDA) CARES Act Recovery Assistance Grant totaling $583,000 to capitalize and administer a Revolving Loan Fund (RLF) to make loans available to small businesses in Lake, Porter, and LaPorte counties that have been impacted by the coronavirus. Financing of $530,000 will assist businesses in recovering and responding to the impacts of the pandemic while $53,000 is used for administration of the program. In accordance with the CARES Regional Revolving Loan Fund Management Plan approved on September 17, 2020, the Finance and Personnel Committee is responsible for appointing Loan Committee Members to serve on the CARES Regional Revolving Loan Fund For Lake, Porter, and Laporte Counties.

The members of the new Lake County and Porter County loan committees are required to “represent a balanced mix of Economic Development, Chamber of Commerce, banks/commercial lenders, non-commercial lenders, businesses, lawyers, and others.” The LaPorte County loan committee for CARES Regional funds are planned to consist of the current members of the existing LaPorte County RLF loan committee.

The following items are therefore requested to be approved by NIRPC’s Finance and Personnel Committee:

Approve inaugural appointments of individuals who have agreed to serve on the Lake County RLF loan committee.
Approve inaugural appointments of individuals who have agreed to serve on the Porter County RLF loan committee.
Approve that the existing seven member LaPorte RLF Committee shall also serve as the loan committee for the CARES Regional RLF for LaPorte County.
Authorize the Executive Director to be the responsible appointing party to replace any loan committee member in the future in accordance with the Management Plan of the LaPorte County RLF. (NIRPC only appoints the citizen members on the loan committee according to the current LaPorte County RLF Management Plan.)
Agree that appointment or replacement of any loan committee member for Lake and Porter counties may be done in the future by the Executive Director as the responsible appointing party for circumstances related to lack of attendance without reasonable cause or for lack of eligibility due to no longer working in or representing the specific county.
Agree that notification of an actual or potential conflict of interest is to be directed in writing to the Executive Director and copied to the EDD Coordinator a minimum of three working days prior to a loan committee meeting date.

Lake County Loan Committee Members:

Bank Representatives

Monica Garcia	Chase Bank	VP, Relationship Manager III
Kevin Crosse	Peoples Bank	VP, Business Banker
LEDO Representative
Karen Lauerman	Lake County Economic Alliance	President & CEO
Business Representatives
Sheleita Miller	Gatekeeper Accounting	Owner CPA
Edward Garza	El Popular, Inc	President

Porter County Loan Committee Members:

Bank Representatives

Caleb Walma	1st Source Bank	Business Banker II
Tim Warner	Centier Bank	VP, Business Banking

LEDO Representative

Amy Parker Portage EDC Executive Director

LaPorte County Loan Committee Members (Existing Members):

Bank Representatives

Steve Kring Horizon Bank Regional President

Sandra Smith PNC Bank VP, Branch Manager

LEDO Representative

Bert Cook LaPorte Economic Advancement Partnership Ex. Director Clarence Hulse Economic Development Corporation Michigan City Ex. Director

Business Representatives

John Kaylor Schmitt & Kaylor CPAs CPA

Jessica Romine Parkison & Hinton, Inc., PC Partner, CPA

LaPorte County Resident

Mike Schultz LaPorte Co. Assessor

AGREEMENT BETWEEN THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION AND THE KANKAKEE RIVER BASIN AND YELLOW RIVER BASIN DEVELOPMENT COMMISSION FOR THE PROVISIONS OF GENERAL SERVICES

BY AGREEMENT MADE AND ENTERED INTO, on the date of January 1, 2021, by and between the NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION,

hereinafter referred to as “NIRPC” and the KANKAKEE RIVER BASIN AND YELLOW RIVER BASIN DEVELOPMENT COMMISSION: hereinafter referred to as “KRBYRBDC” under the terms and conditions hereinafter set forth, the following is hereby agreed:

NIRPC shall provide the KRBYRBDC with accounting services and assistance as is required by the KRBYRBDC to carry out its purposes under its enabling statute.
1. KRBYRBDC will purchase and maintain, at its own expense, a subscription to QuickBooks Online Payroll Premium for three (3) users through the duration of the contract for NIRPC’s use in providing KRBYRBDC with accounting services and assistance.
In conjunction with the above, NIRPC shall provide the following financial management assistance to the KRBYRBDC and shall be compensated for such service by the KRBYRBDC at the monthly rate of one thousand two hundred and seventy-five dollars per month ($1,275) for a total annual base cost of $15,300. The minimum monthly rate is based on fifteen hours of accounting services per month. Additional hours required above 15 will be billed at a rate of $85/hour. See Exhibit A. To the extent identified in this agreement, NIRPC shall:
1. Aid the KRBYRBDC in preparation of its budget, and provide accounting services for the receipt, investment and disbursal of its funds, all in accordance with applicable State Board of Accounts guidelines, statute, and the internal control policy and guidelines set out by the Commission herein or otherwise.
2. Deposit KRBYRBDC funds in the name of the KRBYRBDC and in depositories designated by the KRBYRBDC.
3. Disburse KRBYRBDC funds only upon authorization to do so by the KRBYRBDC and presentation of a State Board of Accounts standard claim form signed by at least two (2) Commission members and approved by the KRBYRBDC. Checks shall be drawn from an account in the KRBYRBDC’s name and shall be signed by two authorized officials. Standard turn around time for check production is 3 days. Checks required in less time may result in additional hourly fees.
NIRPC shall be reimbursed for reasonable travel expenses, at the state of Indiana mileage reimbursement rate of $0.38 per mile. (https://www.in.gov/idoa), incurred in connection with attending KRBYRBDC board and committee meetings, as well as travel on other KRBYRBDC business at the request of Director of the Kankakee River Basin Commission.
NIRPC shall make available to the KRBYRBDC the use of its postage machine. Actual postage cost shall be billed to the KRBYRBDC.
NIRPC shall make available the use of its copy machines. Use of this equipment will be billed at the rate of $5.00 per month plus $.06 per black & white copies and $.20 per copy for color copies.
NIRPC may make available additional space or other services to the KRBYRBDC on a direct charge basis. NIRPC shall bill the KRBYRBDC for such services on a basis that is mutually agreed to by the parties.
NIRPC shall provide itemized monthly billings for services performed. Payment shall be due within thirty (30) days after billing.
This agreement may be amended by mutual agreement of the parties. Amendments shall be in writing.
This agreement shall be effective January 1, 2021 and terminate December 31, 2021. However, either party may terminate the agreement at an earlier date by providing a written notice of intent at least sixty (60) days prior to an effective termination date, which shall coincide with the last day of a calendar month.

KRBYRBDC shall have the option to extend this agreement for the period of one year with monthly base rate increased to $1,313.25 and hourly overage rate of $87.55

NORTHWESTERN INDIANA REGIONAL KANKAKEE RIVER BASIN YELLOW PLANNING COMMISSION RIVER BASIN DEVELOPMENT

COMMISSION

By: By:

Tyson Warner

Executive Director Chair

Date: Date:

EXHIBIT A

STAFF COSTS

Staff costs are estimated as follows below:

Staff Accountant @

$30.80/hr Salary

Monthly hours

Annual hours

Salary

Fringe

Indirect (Overhead)

Total

2021

180

$ 5,544

$ 4,878

$ 15,300

2022 Option

2022

180

$5,710

$ 5,024.50

$ 5024.50

$ 15,759