image

FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda

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

Zoom: Join HERE 1-312-626-6799

Meeting ID: 912 3224 9318 Passcode: 183340


  1. Call to Order


    6100 Southport Road

    Portage, Indiana 46368

    (219) 763-6060

    www.nirpc.org


  2. Meeting Minutes of November 19, 2020 Pages 1-3

  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

  4. Approval of General Fund Claims Register – November 2020 Pages 13-15

    ACTION REQUESTED: Approval

  5. Approval of CARES Act Claims Register - November 2020 Pages 16

    ACTION REQUESTED: Approval

  6. December Bank Statement Reconciliation Pages 17-20

  7. Approval of General Fund Claims Register – December 2020 Pages 21-23

    ACTION REQUESTED: Approval

  8. Approval of CARES Act Claims Register - December 2020 Pages 24

    ACTION REQUESTED: Approval

  9. Procurement #21-01 Pages 25

    ACTION REQUESTED: Recommendation

  10. CARES RLF Loan Committee Member Appointments Pages 26-28

    ACTION REQUESTED: Approval

  11. Kankakee River Basin and Yellow River Basin Development Commission Pages 29-31 support agreement

  12. Personnel update

  13. Other Business


  14. 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

image

image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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

Reconciliation - General

/s1( IJ/JJ IJo

I

I

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

1,190,240.13


image

image

image

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

image

7%

15%


Salaries Sub-Total

1,293,260

1,105,540

79,949

image

7%

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

image

77%

79%


Fringe Benefits Sub-Total

509,690

427,008

40,208

image

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

image

25%

32%


Occupancy Sub-Total

280,297

248,527

8,412

image

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

image

37%

0%


Combined Copier/IT/Phone Service/Maintenance

77,840

55,290

16,063

image

23%

29%

5249-9

Other Equipment Maintenance

1,000

364

553

image

60%

64%


Maintenance Sub-Total

78,840

55,654

16,616

image

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

image

83%

85%


Departmental Sub-Total

196,750

80,839

99,515

image

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

image

100%

100%


Contractual Sub-Total

884,465

359,668

451,091

image

56%

59%


Capital Outlays

5910-0

Furniture and Equipment

100,000

6,736

84,930

image

93%

93%


Capital Outlays Sub-Total

100,000

6,736

84,930

image

93%

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

image

image

image

84,600

100%

(173,866)

-7%

2,700,553

62%

3,670,617

36%

image

image


1,200,000

1,185,488



1,000,000


1,105,540

800,000


600,000

400,000

200,000

-



CARES FUND EXPENDITURES

image

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

image

YTD November 2020 Expended by Category


16%


4%

2%

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


image

image

image

image

Revenue by Funding Source as of November 30, 2020

1% 1%

1%

0%

18%

9%

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


image

image

image

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%


image

Revenue by Funding Source as of November 30, 2020


0%


100%

CARES

Economic Development District

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


11/3/2020



Payroll



$ 34,563.55


$ 34,563.55



Payroll 10/25/2020


11/3/2020


3946


DeLage Landen Fin. Serv.

General 5243.9

Fund


$ 3,538.44


$ 3,538.44


C3946


IT/Telephone/Copier Services


11/3/2020


3946


DeLage Landen Fin. Serv.

General 5244.9

Fund


$ 741.83


$ 741.83


C3946


IT/Telephone/Copier Services


11/3/2020


3946


DeLage Landen Fin. Serv.

General 5241.9

Fund


$ 842.74


$ 842.74


C3946


IT/Telephone/Copier Services


11/3/2020


B-4807


Federal & Fica

General 2140.0

Fund


$ 4,486.15


$ 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


$ 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


$ 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


$ 8,001.49


C4002


ER paid Insurance NOV


11/3/2020


4002

United HealthCare Srvcs, Inc

General 2152.0

Fund


$ 1,514.42


$ 1,514.42


C4002


EE w/h's Insurance NOV


11/4/2020


3976


Accufund

General 5146.9

Fund


$ 199.00


$ 199.00


2679


Training Accounts Payable- Marisol Manley


11/4/2020


3975


Accufund

General 5146.9

Fund


$ 199.00


$ 199.00


2679


Training Accounts Receivable - Stephanie Kuziela


11/4/2020


3929


Adams Radio Group

General 5610.0

Fund


$ 3,710.00


$ 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


$ 2,445.00


2681


Meeting/Training: How to Communicate with Diplomacy


11/4/2020


3973


Anthem Life

General 5143.9

Fund


$ 458.40


$ 458.40


2682


Life Insurance


NOV


11/4/2020


3964

Blachly, Tabor, Bozik & Hartman, LLC

General 5602.9

Fund


$ 1,650.00


$ 1,650.00


2685


Legal - NOV


11/4/2020


3965


City of Portage

General 5221.9

Fund


$ 18,775.18


$ 18,775.18


2684


Lease- NOV


11/4/2020


3974


City of Portage

General 5224.9

Fund


$ 1,965.92


$ 1,965.92


2684


Sewer/Water/Gas Electric Service-OCT


11/4/2020


3977


Fidelity EyeMed

General 2154.0

Fund


$ 70.91


$ 70.91


C3977


Vision Insurance - NOV


11/4/2020


3963


Health Resources

General 2153.0

Fund


$ 719.94


$ 719.94


2685


Dental Insurance - NOV


11/4/2020


B-4809


INPRS


General


Fund


$ 5,803.18


$ 5,803.18


C4809


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


11/4/2020


3971


INPRS


General


Fund


$ (0.01)


$ (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


$ 878.24


2687


Life Insurance - Disability- NOV


11/4/2020


3958


Pulse Technology

General 5430.9

Fund


$ 49.49


$ 49.49


2689


Office Supplies- Binders


11/4/2020


3979

Porter County Soil & Water Conservation District

General 5610.5

Fund


$ 3,980.98


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 20.47


C4762


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


11/5/2020


3980


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C3980


Recycle/Trash - NOV


11/6/2020


3981


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C3981


Comcast Business- NOV


11/6/2020


3998


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C3998


Communication Expense - NOV


11/9/2020


B-4811


ICMA Retirement Fund-PR

General Fund 2146.0


$ 805.00


$ 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


$ 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


$ 95.92



Horizon bank service fee


11/10/2020


3914


Amazon

General Fund 5430.9


$ 49.98


$ 49.98


C3914


Logitech USB Headset w/noise cancelling mic


11/10/2020


3914


Amazon

General Fund 5430.9


$ 14.58


$ 14.58


C3914


DYMO Authentic LW mailing address labels


11/10/2020


3969


Amazon

General Fund 5410.5


$ 72.75


$ 72.75


C3969


USB 3.0 flash Drive 64GB


11/10/2020


3967


Chicago Tribune

General Fund 5410.0


$ 27.72


$ 27.72


CC3967


News Paper Subscription -NOV


11/10/2020


3997


SQUARESPACE

General Fund 5410.1


$ 216.00


$ 216.00


C3997


Annually Subscription- Business website


11/10/2020


3968


Stamps.com

General Fund 5249.9


$ 100.00


$ 100.00


C3968


Stamps.com


11/10/2020


3966


Stamps.com

General Fund 5249.9


$ 24.99


$ 24.99


CC3966


Stamps.com


11/10/2020


3927


Survey Monkey

General Fund 5910.0


$ 384.00


$ 384.00


C3927


One Year Renewal Survey Monkey Subscription


11/16/2020


4001


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2692


Office Cleaning- NOV


11/16/2020


B-4846

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2695


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


11/17/2020



Payroll



$ 34,026.31


$ 34,026.31



Payroll 11/08/2020


11/17/2020


4006


Ecointeractive

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4006


TIP SAAS Service- NOV


11/17/2020


4003


Ecointeractive

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4003


TIP SAAS Service


11/17/2020


4004


Ecointeractive

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4004


TIP SAAS Service


11/17/2020


B-4841


Federal & Fica

General Fund 2140.0


$ 4,403.09


$ 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


$ 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


$ 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


$ 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


$ 805.00


C4845


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


11/18/2020


B-4843


INPRS

General Fund 2149.0


$ 5,704.89


$ 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

image


Dated this day of , 2021.


image


image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image


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


$ 479.88


2686


Kombi Motor/Blower Attach/Head Trimmer


11/5/2020


3956


City of Valpo

General Fund 5960.0


$ 96,043.22


$ 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


$ 444.99


C3936


Strongway 20-Ton Hydraulic Shop Press


11/10/2020


3937


Northern Tool & Equipment

General Fund 5960.0


$ 3,599.99


$ 3,599.99


C3937


Northstar hot water pressure washer with wet steam


11/16/2020


3983


SLCCS

General Fund 5960.0


$ 1,062.00


$ 1,062.00


2694


RouteMatch SLCCS - NOV


11/16/2020


3983


NT

General Fund 5960.0


$ 531.00


$ 531.00


2694


RouteMatch NT- NOV


11/16/2020


3983


PCACS

General Fund 5960.0


$ 472.00


$ 472.00


2694


RouteMatch PCACS- NOV


11/16/2020


3960


Pulse Technology

General Fund 5430.9


$ 39.99


$ 39.99


2693


Office Supplies-Lysol


11/20/2020


3984


Opportunity Enterprises

General Fund 5760.0


$ 121,653.00


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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


$ 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

image


Dated this day of , 2021.


image


image


16


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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

image


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 image

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


image

\-


/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

image

1,565,581.08


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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

image


image

image

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



image


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

0.00

160,280.91


image

(}'

\


image

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

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

image

160,280.91



image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


12/1/2020



Payroll



$ 2,089.28


$ 2,089.28



Pay period ending 11/22/2020


12/1/2020



Payroll



$ 34,857.64


$ 34,857.64



Pay period ending 11/22/2020


12/1/2020


B-4867


Federal & Fica

General Fund 2140.0


$ 4,316.48


$ 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


$ 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


$ 400.88


C4864


Edwards vacation payout- FWT,empfica, empficamed


12/1/2020


B-4864


Federal & Fica

General Fund 2142.00


$ 432.10


$ 432.10


C4864


Edwards vacation payout- FWT,empfica, empficamed


12/1/2020


B-4870


Horizon

General Fund 2150.0


$ 370.38


$ 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


$ 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


$ 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


$ 3,538.44


C4029


IT


12/2/2020


4029


De Lage Landen Financial

General Fund 5244.9


$ 741.83


$ 741.83


C4029


Telephone


12/2/2020


4029


De Lage Landen Financial

General Fund 5241.9


$ 842.74


$ 842.74


C4029


Copier Lesing Maintenance


12/2/2020


B-4869


INPRS

General Fund 2140.0


$ 5,819.68


$ 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


$ 401.04


C4866


Edwards vacation payout - EmpPerf [NIRPC}


12/2/2020


B-4012


INPRS

General Fund 5141.9


$ 0.01


$ 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


$ 9,017.06


C4042


ER Paid for DEC2020 Health Insurance


12/3/2020


4042


United Healthcare

General Fund 2152.0


$ 1,706.52


$ 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


$ 27.72


CC4024


News Paper Subscription


12/10/2020


3961


GoodHire

General Fund 5410.9


$ 54.99


$ 54.99


CC3961


Standard background check new hire


12/10/2020


4036


ICMA

General Fund 5146.9


$ 1,217.00


$ 1,217.00


CC4036


ICMA Membership Renewal 2021


12/10/2020


4015


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


CC4015


Stamps-DEC


12/10/2020


3978


Zoom

General Fund 5410.5


$ 119.92


$ 119.92


CC3978


Zoom Pro Subscription -Yearly until 10/29/21


12/11/2020


4028


Anthem Life

General Fund 5143.9


$ 467.94


$ 467.94


2696


Life Insrance


12/11/2020


4025

Blachly, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,650.00


$ 1,650.00


2697


Legal- DEC


12/11/2020


4035


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2698


Office Cleaning- DEC


12/11/2020


4027


City of Portage

General Fund 5221.9


$ 18,775.18


$ 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


$ 1,874.31


2700


Sewer/Water/Gas/Electric Service


12/11/2020


4019


Health Resources

General 2153.0

Fund


$ 336.33


$ 336.33


2701


Dental Insurance DEC


12/11/2020


4037

IN Assoc of Regional Councils

General 5410.0

Fund


$ 2,000.00


$ 2,000.00


2703


Annual Memebership Dues 2021


12/11/2020


4017

Kansas City Life Insurance Co.

General 5143.9

Fund


$ 733.17


$ 733.17


2705


Life Insrance


12/11/2020


4018


NWI Forum

General 5410.1

Fund


$ 1,100.00


$ 1,100.00


2706


2021 Membership Dues


12/11/2020


4032


Skulski Consulting

General 5610.4

Fund


$ 11,300.00


$ 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


$ 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


$ 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


$ 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


$ 3,791.60


2710


Purchase Trees fo rthe Communi Tree program


12/11/2020


4031


INRO Consultants

General 5410.2

Fund


$ 1,680.00


$ 1,680.00


2704


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


12/14/2020


4034


Comcast

General 5244.9

Fund


$ 139.64


$ 139.64


C4034


Business Internet- DEC


12/14/2020


4043


INBiz

General 5146.9

Fund


$ 21.50


$ 21.50


C4043


Online payment service


12/14/2020


4022


Total Disposal

General 5223.9

Fund


$ 74.00


$ 74.00


C4022


Recycle/Trash- DEC


12/15/2020



Payroll



$ 35,965.36


$ 35,965.36



Pay period ending 12/06/2020


12/15/2020


4873


Federal & Fica

General 2140.0

Fund


$ 4,375.58


$ 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


$ 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


$ 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


$ 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


$ 832.41


C4016


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




Account Service Fee



$ 125.00


$ 125.00



Service Fee


12/16/2020


4021


Ecointeractive

General 5610.2

Fund


$ 3,750.00


$ 3,750.00


C4021


TIP SAAS Service


12/16/2020


4023


Fidelity EyeMed

General 2154.0

Fund


$ 80.18


$ 80.18


C4023


Vision Insurance


12/16/2020


4875


INPRS

General 2149.0

Fund


$ 6,108.14


$ 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


$ 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


$ 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


$ 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


$ 313.23


C4808


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


12/16/2020


4026


Warner, Ty


General


Fund


$ 125.00


$ 125.00


C4026


Communication Expense - DEC


12/29/2020



Payroll


General


Fund


$ 37,643.28


$ 37,643.28



Payperiod 12/29/20


12/30/2020


B-4931


Federal & Fica

General 2140.0

Fund


$ 4,663.51


$ 4,663.51


C4931


Federal Tax Withholding Payable


12/30/2020


B-4931


Federal & Fica

General 2142.0

Fund


$ 6,696.14


$ 6,696.14


C4931


FICA Tax Withholding Payable


12/30/2020


B-4934


Horizon Bank

General 2150.0

Fund


$ 520.38


$ 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


$ 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


$ 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


$ 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

image


Dated this day of , 2021.


image


image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

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


$ 1,800.00


2699

Electrostatic Disinfection Guns

Hand Held


12/11/2020


3939


CCL Supply LLC

General Fund

5960.0


$ 98.10


$ 98.10


2699

Electrostatic Disinfection Guns

Hand Held


12/11/2020


4030


RouteMatch

General Fund

5960.0


$ 1,062.00


$ 1,062.00


2707


SLCC- DEC


12/11/2020


4030


RouteMatch

General Fund

5960.0


$ 531.00


$ 531.00


2707


NT- DEC


12/11/2020


4030


RouteMatch

General Fund

5960.0


$ 472.00


$ 472.00


2707


PCACS- DEC


12/11/2020


4014


Impact Networking LLC

General Fund

5910.0


$ 750.00


$ 750.00


2702

Installation & Configuration Fee to

set up NIRPC


12/16/202


4020


Todd, Lisa

General Fund

5410.4


$ 12.92


$ 12.92


C4020


Mileage- CARES


12/31/2020


4008


Porter County Aging and Community Services


General Fund 5960.0


$ 11,106.75


$ 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

$118,400.00 in federal funds.

image


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:


  1. Approve inaugural appointments of individuals who have agreed to serve on the Lake County RLF loan committee.


  2. Approve inaugural appointments of individuals who have agreed to serve on the Porter County RLF loan committee.


  3. Approve that the existing seven member LaPorte RLF Committee shall also serve as the loan committee for the CARES Regional RLF for LaPorte County.


  4. 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.)


  5. 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.


  6. 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:


  1. 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.


  2. 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.



  3. 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.


  4. NIRPC shall make available to the KRBYRBDC the use of its postage machine. Actual postage cost shall be billed to the KRBYRBDC.


  5. 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.


  6. 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.


  7. NIRPC shall provide itemized monthly billings for services performed. Payment shall be due within thirty (30) days after billing.


  8. This agreement may be amended by mutual agreement of the parties. Amendments shall be in writing.


  9. 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:


image

image

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

15

180

$ 5,544

$ 4,878

$ 4,878

$ 15,300


2022 Option


2022


15


180


$5,710


$ 5,024.50


$ 5024.50


$ 15,759