image

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org



FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda - Thursday, March 18, 2021 -- 8:00 a.m.

Join with Google Meet

Phone Number: (US) +1 414-909-4453 PIN: 407502875#


  1. Call to Order

  2. Meeting Minutes of January 21, 2021 Pages 1-3

  3. Review of 2020 Year End Financial Status Budget to Actual Pages 4-8

    1. General Fund Expenses YTD December 2020

    2. General Fund Revenue YTD December 2020

    3. CARES Expenses YTD December 2020

    4. CARES Revenue YTD December 2020


  4. Review of Financial Status – January 2021 Budget vs Actual Pages 9-17

    1. Bank Statement Reconciliations

    2. General Fund Expenses YTD January 2021

    3. General Fund Revenue YTD January 2021

    4. CARES Expenses YTD January 2021

    5. CARES Revenue YTD January 2021

  5. Approval of General Fund Claims Register – January 2021 Pages 18-20

    ACTION REQUESTED: Approval

  6. Approval of CARES Act Claims Register – January 2021 Pages 21

    ACTION REQUESTED: Approval

  7. Review of Financial Status – February 2021 Budget vs Actual Pages 22-30

    1. Bank Statement Reconciliations

    2. General Fund Expenses YTD February 2021

    3. General Fund Revenue YTD February 2021

    4. CARES Expenses YTD February 2021

    5. CARES Revenue YTD February 2021

  8. Approval of General Fund Claims Register – February 2021 Pages 31-33

    ACTION REQUESTED: Approval

  9. Approval of CARES Act Claims Register – February 2021 Pages 34

    ACTION REQUESTED: Approval

  10. Resolution 21-03 – Updating the Management Plan for the LaPorte Co. RLF Pages 35-40

    ACTION REQUESTED: Recommendation


  11. Resolution 21-04 – Regional RLF Management Plan Amendment Pages 41-44

    ACTION REQUESTED: Recommendation


    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

  12. Personnel update


  13. Other Business


  14. Adjournment


The next meeting is scheduled for April 15, 2021 at 8:00 a.m.


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

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

January 21, 2021 / Zoom Virtual Meeting – 8:00 a.m.


Members Present

Richard Hardaway, Bob Carnahan, Justin Kiel, George Topoll Staff and Others Present

Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Stephanie Kuziela, Meredith Stilwell, Gabrielle Biciunas, Denarie Kane, Greg Stinson, Wendy Mis, John Yelkich, David Hollenbeck


Call to Order

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

Approval of Minutes

The minutes of the November 19, 2020 meeting were presented. Bob Carnahan made motion and Richard Hardaway seconded to approve the minutes. A roll call vote was taken with Bob Carnahan, Richard Hardaway and Justin Kiel voting in the affirmative, and no one voting in the negative. Motion passed 3-0.


Review of Financial Status – November 2020

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

$1,068,601.49 with a closing balance of $1,195,830.97 as of 11/30/2020. The RLF account beginning balance from 11/1/2020 was $149,906.07 with a closing balance of $155,093.25 as of 11/30/2020.

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

$1,105,540 has been expended of the $1,293,260 Salaries budget. $427,008 has been expended of the

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

$55,654 has been expended of the $78,840 Maintenance budget. $80,839 has been expended of the

$196,750 Departmental budget. $359,668 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,283,972 of the $3,343,302 budgeted. $400 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. $1,688,483 has been expended of the $4,389.036 2019 Transit Operating Fund budget. Year to date, total expenditures of $6,587,709 of the $10,258,326 budgeted, $3,670,617 under budget.

Talaya presented the year-to-date November 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 year-to-date November 2020 budget vs. actual revenue report. $366,669 of the

$540,271 county appropriations budget has been collected. $189,348 of the $539,733 federal agencies budget has been collected. $1,414,667 of the $1,935,395 state agencies budget has been collected.

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


Talaya presented the year-to-date revenue by funding source chart as of November 30. 70% of collected revenue has been from state agencies, 18% 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 expenditures year to date, November 2020. $60,756 of the $236,733 has been expended of the Salaries budget. $0 of $5,000 contractual, RLF Services budget has been expended. $15,572 of the $25,000 departmental, PPE Supplies, budget has been expended. $2,544 of the $165,000 Capital Outlays, Furniture and Equipment, budget has been expended. Total NIRPC CARES Fund Expenditures of $78,870 had been

expended from the $431,733 budget. $0 of the $583,000 CARES Revolving Loan Fund budget has been expended. $137,057 of the $1,219,972 CARES Transit Capital Fund budget has been expended.

$2,171,324 of the $4,314,322 CARES Agency Fund has been expended. Total expenditures were

$2,387,253 of the $6,549,027 budgeted.

Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual revenue year to date, November 2020. All revenue is federal and is classified as Economic Development District or FTA. $268,895 has been collected of the $604,229 total CARES Act revenue budget.

Approval of Claims Register – November 2020

Talaya first presented the November 2020 regular claims register totaling $237,913.16 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 regular claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. The CARES Act expenditures register of claims totaling $1,181,387.07 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.


December 2020 Bank Statement Reconciliation

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

$1,195,830.97 with a closing balance of $1,572,482.28 as of 12/31/2020. The RLF account beginning balance from 12/1/2020 was $155,093.25 with a closing balance of $160,280.91 as of 12/31/2020.


Approval of Claims Register – December 2020

Talaya first presented the December 2020 regular claims register totaling $245,009.72 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 regular claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. The CARES Act expenditures register of claims totaling $15,832.77 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the December 2020 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. Talaya stated the preliminary financial reports for December will be brought to the next meeting.

Procurement Recommendation 21-01

Lisa Todd presented procurement recommendation 21-01 for the purchase of 2 replacement BOC vehicles for LaPorte TransPorte. 80% of the purchase will be paid with Federal Transit Administration Funds with 20% paid with LaPorte TransPorte local share, not to exceed $118,400 in federal funds. Justin Kiel made motion and Bob Carnahan seconded to approve Procurement Recommendation 21-01. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.

CARES RLF Loan Committee Member Appointments

NIRPC’s Economic Development District Coordinator, Gabrielle Biciunas, presented a memorandum to the committee to request approval of the appointment of CARES Regional Revolving Loan Fund Loan Committee Members. The Finance and Personnel Committee is responsible for appoint Loan Committee Members, who are required to represent a balanced mix of Economic Development, Chamber of Commerce, banks/commercial lenders, non-commercial lenders, business, lawyers, and others, for Lake, Porte, and LaPorte Counties. Gabrielle presented six items in the memorandum and the proposed Committee Members for approval by the Committee. Justin Kiel made motion and Richard Hardaway seconded to approve Procurement Recommendation 21-01. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.

Kankakee River Basin and Yellow River Basin Development Commission (KRBYRBDC) Support Agreement For informational purposes, Kathy Luther presented the new support agreement between NIRPC and the KRBYRBDC for general services from January 1 through December 31. 2021. The new agreements provides for a lesser monthly cost but allows for more hours to be spent for services.

Personnel updates

Meredith Stilwell reported that most staff are continuing to work remotely.

Other Business

Bob Carnahan pointed out that the agenda indicated the next meeting would be held March 18, 2020 and should be March 18, 2021.

Adjournment

There being no further business, the meeting was adjourned.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH DECEMBER 31, 2020



Line Items


FY 2020 Budget

FY 20

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


Salaries




5020-1

Total Salaries

1,293,260

1,154,561

138,699

image

11%

11%


Salaries Sub-Total

1,293,260

1,154,561

138,699

image

11%

11%


Fringe Benefits

5121-9

FICA Contributions

104,321

94,008

10,313

10%

10%

5122-9

Workers Compensation

6,100

2,950

3,150

52%

52%

5123-9

Unemployment Compensation

1,650

1,092

558

34%

34%

5141-9

PERF Contributions

159,118

159,177

(59)

0%

0%

5142-9

Health Insurance

170,501

160,889

9,612

6%

6%

5143-9

Life & Disability Insurance

23,000

17,736

5,264

23%

23%

5145-9

ICMA

25,000

21,606

3,394

14%

14%

5146-9

Staff Development

20,000

5,366

14,634

image

73%

73%


Fringe Benefits Sub-Total

509,690

462,823

46,867

image

9%

9%


Occupancy

5221-9

Office Lease

225,500

244,547

(19,047)

-8%

-8%

5222-9

Property Insurance

6,500

4,901

1,599

25%

25%

5223-9

Building Maintenance

18,540

18,221

319

2%

2%

5224-9

Utilities

29,757

22,252

7,505

image

25%

25%


Occupancy Sub-Total

280,297

289,920

(9,623)

image

-3%

-3%


Maintenance

5241-9

Copier Leasing/Maintenance

19,400

4,423

14,977

77%

0%

5243-9

Computer Service/Maintenance

40,440

44,776

(4,336)

-11%

0%

5244-9

Telephone Service/Maintenance

18,000

11,478

6,522

image

36%

0%


Combined Copier/IT/Phone Service/Maintenance

77,840

60,678

17,162

image

22%

22%

5249-9

Other Equipment Maintenance

1,000

389

611

image

61%

61%


Maintenance Sub-Total

78,840

61,067

17,773

image

23%

23%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

12,407

29,093

70%

70%

5410-2

Communications: Transportation

60,000

17,039

42,961

72%

72%

5410-4

Communications: Subgrantee Management

15,000

96

14,904

99%

99%

5410-5

Communications: Environmental Programs

28,650

16,636

12,014

42%

42%

5410-8

Communications: Partner Agency

1,000

716

284

28%

28%

5410-9

Communications: Allocated Functions

28,000

18,891

9,109

33%

33%

5420-5

Promotional Expenses: Environmental Programs

15,600

17,405

(1,805)

-12%

-12%

5430-9

General Use Supplies Expense

7,000

1,563

5,437

image

78%

78%


Departmental Sub-Total

196,750

84,753

111,997

image

57%

57%


Contractual

5602-9

Legal Services

19,800

19,800

0

0%

0%

5603-9

Audit and Accounting

69,000

15,680

53,320

77%

77%

5604-9

LaPorte RLF Services

2,000

0

2,000

100%

100%

5610-4

Transit Oversight

11,300

11,900

(600)

-5%

-5%

5610-5

Environmental Projects

522,374

267,637

254,737

49%

49%

5610-5

Alternative Fuel

70,991

0

70,991

100%

100%

5619-9

Organizational Dev.

2,000

0

2,000

100%

100%

5610-0

Board Development

2,000

0

2,000

100%

100%

5610-2

E-Tip

45,000

48,750

(3,750)

-8%

-8%


Economic Development District

140,000

0

140,000

image

100%

100%


Contractual Sub-Total

884,465

363,767

520,698

image

59%

59%


Capital Outlays

5910-0

Furniture and Equipment

100,000

6,736

93,264

image

93%

93%


Capital Outlays Sub-Total

100,000

6,736

93,264

image

93%

93%



TOTAL GENERAL FUND EXPENDITURES

3,343,302

2,423,628 919,674


28% 28%


LaPorte Revolving Loan Fund

85,000

400


Transit Capital Fund

2,440,988

2,573,834


2019 Transit Operating Fund


TOTAL EXPENDITURES

4,389,036 1,688,483


10,258,326 6,686,345

image

image

image

84,600

100%

(132,846)

-5%

2,700,553

62%

3,571,981

35%

image

image


1,400,000



1,200,000

1,293,260


1,154,561


1,000,000




800,000




600,000



509,690

400,000




200,000




-






CARES FUND EXPENDITURES

image

YTD December 2020 Expenses Budget vs Actual

884,465

462,823

363,767

280,297 289,920

196,750

78,840

61,067

84,753

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD December Budget YTD December Expended

image

YTD December 2020 Expended by Category


15%


3%

3%

48%

12%


19%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH DECEMBER 31, 2020



Line Items


FY 2020

Budget

FY 20

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

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

540,271

540,271

0%

0%

1.1.4210

Federal Agencies

539,733

222,660

(317,073)

-59%

59%

1.1.4310

State Agencies

1,935,395

1,240,861

(694,534)

-36%

36%

1.1.4410

Local Agencies

44,694

36,343

(8,351)

-19%

19%

1.1.4610

Non-Governmental

135,318

11,126

(124,192)

-92%

92%

1.3.4260

Economic Development District

70,000

34,969

(35,031)

-50%

50%

1.1.4800

Interest Income

9,862

9,773

(89)

-1%

1%


Revenue Total

3,275,273

2,096,002

(639,000)

-23%

36%


image

image

image

Revenue by Funding Source as of December 31, 2020

0%

0%

2% 2%

26%

11%

59%

County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District

Interest Income

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH DECEMBER 31, 2020



Line Items


FY 2020 Budget

YTD December

Expended

FY 20 Budget %

balance

NIRPC CARES EXPENDITURES




Salaries




Salaries-FTA

236,733

124,919

47%

Salaries-CARES EDD


-


Salaries Sub-Total

236,733

124,919

47%


Contractual




Contractural


17,385


RLF Services

5,000

-

100%

Contractual Sub-Total

5,000

17,385

-248%

Departmental





Communications


500

1,681

-236%

PPE Supplies & Office Supplies


25,000

14,973

40%

Capital Ou

Departmental Sub-Total

25,000

16,654

33%



Furniture and Equipment

165,000

3,294

98%

Capital Outlays Sub-Total

165,000

3,294

98%



TOTAL NIRPC CARES FUND EXPENDITURES

431,733

162,251

62%


CARES Revolving Loan Fund

583,000

-


CARES Transit Capital Fund

1,219,972

201,152


CARES Transit Agency Fund

4,314,322

2,171,324

TOTAL EXPENDITURES

6,549,027

2,534,727


image

image

image

250,000

YTD December 2020 Expenses Budget vs Actual

236,733

200,000

165,000

150,000

124,919

100,000


50,000

17,385

25,000 16,654

-

-

5,000

3,294

-

SALARIES-FTA

SALARIES-CARES

EDD

CONTRACTURAL

DEPARTMENTAL CAPITAL OUTLAYS

Budget Expended


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH DECEMBER 31, 2020




Line Items


FY 2020

Budget


YTD December Collected

FY 20

Budget % balance

CARES ACT FTA Revenue


Operating Revenue

419,386

368,309

12%


Capital Revenue

125,000

0

100%

CARES ACT EDA

Economic Development District

59,843

11,455

81%


RLF


3,095



Revenue Total

604,229

382,859

37%


CARES AGENCY

FTA Revenue

2,694,048

2,171,324

81%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

201,152

20%



4,307,009

2,755,335

64%


image

Revenue by Funding Source as of December 31, 2020


1%


3%


96%

CARES

Economic Development District RLF



image

image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 2/05/2021 @ 5:55 AM

Reconciliation - General

Page: 1

STK 2/5/21

02/5/2021

image

image

image

image

image

image

image

image

image

image

image

image

image

image

Closing Balance from Previous Statement........................................................................................... 12/31/2020 1,572,482.28


6

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


149,613.00

93

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


520,564.04

0

Adjustments Totaling..............................................................................................


0.00

0

Voids Totaling........................................................................................................


0.00


Service Charge.......................................................................................................

1/08/2021

94.12


Interest Earned.......................................................................................................

1/31/2021

118.61

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

1/31/2021

1,201,555.73

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


0.00

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

1/31/2021

1,125,657.26

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


(75,898.47)

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


0.00

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


1,201,555.73

Date

Check To

Check Description

Amount

7/02/2019

0002363 Kelly Tripp

Refund fee for tree steward workshop

28.83

8/27/2019

0002409 United Way of Porter County

8/5 - 8/18/2019 pay period - United Way

33.85

4/09/2020

0002545 Anthem Life

Life Ins for April 2020

490.75

6/02/2020

0002587 Anthem Life

Life Insurance June 2020

514.93

8/11/2020

0002624 Anthem Life

Life Insurance - August

502.84

12/15/2020

0002704 INRO Consultants

Renewal Software Agreement 7/1/20-

1,680.00


1/06/2021


0002725 Tennant Sales and Service Company

12/31/20

Tennant- Floor


39,949.00



Sweeper/Battery/Charger/Vaccum




Wand/Freight/Less discount


1/28/2021

0002727 BRYCO SERVICES

Recycle/Trash

1,425.00

1/28/2021

0002728 City of Portage, The

Sewer/Water/Gas/Electric Service

1,869.17

1/28/2021

0002729 Engravables

Yearly officer's plaque engraved plate/Gavel and laser engraved plate

53.00

1/28/2021

0002730 Nat'l Assoc. of Regional Councils

Invoices 4078, 4087

750.00

1/28/2021

0002731 Pulse Technology

Office Supplies-Covid 19/CARES-Lysol

39.99

1/28/2021

0002732 Quill Corporation

Office Supplies

183.53

1/28/2021

0002733 SME

Programmatic Support & Outreach-

28,343.73



Hazardous/Petroleum




Inventory & Prioritization-Petroleum




Site Assessment-Hazardous


1/28/2021

0002734 United Way of Porter County

1/4 - 1/17/2021 pay period - United Way

33.85


Total Unmarked Checks: 75,898.47

Total Checks:

75,898.47

Trial Balance - Cash

Run: 3/11/2021 at 11:07NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 1/31/2021


Page: 1



All Balance

1.1.001.0000.1010.0 Cash       1,125,657.26  

Total 1,125,657.26


image

STK 3/11/21



image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 2/04/2021 @ 1:03 PM

Reconciliation - Revolving Loan Fund

Page: 1

STK 2/4/21

02/5/2021

image

Closing Balance from Previous Statement........................................................................................... 12/31/2020 160,280.91


6

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


4,878.31

0

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


0.00

0

Adjustments Totaling..............................................................................................


0.00

0

Voids Totaling........................................................................................................


0.00


Service Charge.......................................................................................................


0.00


Interest Earned.......................................................................................................

1/29/2021

8.50

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

1/31/2021

165,167.72

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


0.00

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

1/31/2021

165,167.72

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


0.00

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


0.00

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


165,167.72


Date

Reference Deposit Description


Amount

1/06/2021

8272569 Bare Bones RLF Payment


1,197.07

1/12/2021

8272569 Hammer RLF Payment


1,381.24

1/12/2021

8272569 Heston Supper Club RLF Payment


300.00

1/25/2021

8272572 Heston Supper Club RLF Payment


300.00

1/28/2021

8272572 Wilsons RLF Payment


1,200.00

1/28/2021

8272572 Etropal Jan 2021 RLF Payment


500.00


Total Unmarked Deposits: 0.00

Total Deposits:

4,878.31

Date

Reference Adjustment Description


Amount

image 1/29/2021

Interest Earned


8.50


Total Unmarked Adjustments: 0.00

Total Adjustments:

8.50

Trial Balance - Cash

Run: 2/04/2021 at 1:18 PNMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 1/31/2021


Page: 1



All Balance

2.3.050.0000.1010.0 Cash          165,167.72  

Total 165,167.72


image STK 2/4/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021 Budget

FY 21

YTD January Budget % Expended balance


Salaries




5020-1

Total Salaries

1,565,254

88,138 94%


Salaries Sub-Total

1,565,254

88,138 94%


Fringe Benefits

5121-9

FICA Contributions

119,742

7,687

94%

5122-9

Workers Compensation

9,500

0

100%

5123-9

Unemployment Compensation

3,000

48

98%

5141-9

PERF Contributions

200,012

13,176

93%

5142-9

Health Insurance

230,000

28,990

87%

5143-9

Life & Disability Insurance

24,000

1,268

95%

5145-9

ICMA

23,000

1,712

93%

5146-9

Staff Development

20,000

0

100%


Fringe Benefits Sub-Total

629,254

52,880

92%


Occupancy

5221-9

Office Lease

231,000

19,245

92%

5222-9

Property Insurance

6,500

0

100%

5223-9

Building Maintenance

18,540

1,499

92%

5224-9

Utilities

30,650

3,614

88%


Occupancy Sub-Total

286,690

24,358

92%


Maintenance

5241-9

Copier Leasing/Maintenance

20,370

843

0%

5243-9

Computer Service/Maintenance

43,736

3,538

0%

5244-9

Telephone Service/Maintenance

18,900

1,006

0%


Combined Copier/IT/Phone Service/Maintenance

83,006

5,388

94%

5249-9

Other Equipment Maintenance

2,000

25

99%


Maintenance Sub-Total

85,006

5,413

94%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

1,755

96%

5410-2

Communications: Transportation

299,000

4,200

99%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

0

100%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

125

100%

5420-5

Promotional Expenses: Environmental Programs

3,700

0

100%

5410-3

Economic Development District

11,768

0

100%

5430-9

General Use Supplies Expense

7,000

184

97%


Departmental Sub-Total

442,223

6,264

99%


Contractual

5602-9

Legal Services

22,200

1,700

92%

5603-9

Audit and Accounting

38,000

0

100%

5604-9

LaPorte RLF Services

2,000

0

100%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,300

108,376

87%

5610-2

Planning

320,000

0

100%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

51,500

3,750

93%


Contractual Sub-Total

1,292,347

113,826

91%


Capital Outlays

5910-0

Furniture and Equipment

180,000

0 100%


Capital Outlays Sub-Total

180,000

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,480,774

290,878 94%


LaPorte Revolving Loan Fund

85,000

0


Transit Capital Fund

142,080

0


Transit Operating Fund

4,460,765

0

TOTAL EXPENDITURES

9,168,619

290,878

image

CARES FUND EXPENDITURES

image

YTD January 2021 Expenses Budget vs Actual

140,000

130,438

120,000

107,696

113,826

100,000

88,138

80,000


60,000

52,438 52,880

36,852

40,000

23,891 24,358

20,000

7,084

5,413

6,264

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD January Budget YTD January Expended

image

YTD January 2021 Expended by Category

30%

39%

2%2%

18%

9%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2020

Budget

FY 20

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

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

0

0

0%

100%

1.1.4210

Federal Agencies

869,119

0

(724,266)

-100%

100%

1.1.4310

State Agencies

1,955,395

0

(1,629,496)

-100%

100%

1.1.4410

Local Agencies

44,694

12,057

(25,188)

-68%

73%

1.1.4610

Non-Governmental

85,318

450

(70,648)

-99%

99%

1.3.4260

Economic Development District

70,000

0

(58,333)

-100%

100%

1.1.4800

Interest Income

9,862

798

(7,420)

-90%

92%


Revenue Total

3,574,659

13,305

(2,515,352)

-99%

100%


image

image

image

Revenue by Funding Source as of January 31, 2021

0%

0%

0%

0%

6%

3%

91%

County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District

Interest Income



Line Items


FY 2021 Budget

YTD January

Expended

FY 21 Budget %

balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

236,733

17,483

93%

Salaries Sub-Total

236,733

17,483

93%


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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

Contractual

5610-3

5610-3

RLF Services

5,000

-

100%

EDD- RLF CARES ACT

550,000


100%

EDD Insititutional CARES ACT

136,000


100%

Contractual Sub-Total

691,000

-

100%


Communications

500

-

100%

PPE Supplies & Office Supplies

25,000

80

100%

Departmental Sub-Total

25,000

80

100%

Departmental


image

YTD January 2021 Expenses Budget vs Actual

250,000

236,733

200,000

165,000

150,000

100,000

55,267

50,000

17,483

25,000

5,000

-

80

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

image

Capital Outlays

Furniture and Equipment

165,000

55,267

67%

Capital Outlays Sub-Total

165,000

55,267

67%


TOTAL NIRPC CARES FUND EXPENDITURES

1,117,733

72,830

93%


CARES Revolving Loan Fund

583,000

-


CARES Transit Capital Fund

1,219,972

58,816


CARES Transit Agency Fund

4,314,322

129,098

TOTAL EXPENDITURES

7,235,027

260,744


image



NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021

Budget


YTD January Collected

FY 21

Budget % balance

CARES ACT OPERATING




Operating Revenue

419,386

0

100%

Capital Revenue

125,000

0

100%


CARES ACT EDA Economic Development District

59,843

0

100%


604,229

0

100%


CARES AGENCY

FTA Revenue

2,694,048

2,065

100%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

129,098

87%


Revenue Total

4,307,009

131,163

97%


image

Revenue by Funding Source as of January 31, 2021


0%

CARES Operating

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


1/5/2021


4077

DeLage Landen Financial Service, Inc

General Fund 5243.9


$ 3,538.44


$ 3,538.44


C4077


IT Services


1/5/2021


4077

DeLage Landen Financial Service, Inc

General Fund 5244.9


$ 741.83


$ 741.83


C4077


Telephone Services


1/5/2021


4077

DeLage Landen Financial Service, Inc

General Fund 5241.9


$ 842.74


$ 842.74


C4077


Copier/Lease


1/5/2021


4051

United HealthCare Srvc, Inc

General Fund 5142.9


$ 8,989.67


$ 8,989.67


C4051


ER paid for JAN 2021-Health Insurance


1/5/2021


4051

United HealthCare Srvc, Inc

General Fund 2152.0


$ 1,706.52


$ 1,706.52


C4051


EE w/h's for JAN 2021- Health Insurance


1/6/2021


4047


Anthem

General Fund 5143.9


$ 476.41


$ 476.41


2712


Life Insurance -Jan 2021


1/6/2021


4050

Blachly,Tabor,Bozik & Hartman, LCC

General Fund 5602.9


$ 1,700.00


$ 1,700.00


2713


Legal - Jan 2021


1/6/2021


4064


City of Portage

General Fund 5224.9


$ 1,744.98


$ 1,744.98


2714


Utilities - DEC 2020


1/6/2021


4063


City of Portage

General Fund 5221.9


$ 19,244.56


$ 19,244.56


2714


Lease - Jan 2021


1/6/2021


4044

Council of Development Finance Agencies

General Fund 5410.3


$ 550.00


$ 550.00


2715


Annual member dues Jan-Dec 2021


1/6/2021


4039


ESRI, Inc

General Fund 5410.2


$ 4,200.00


$ 4,200.00


2717

ArcGIS Desktop Standard Concurrent

Use/Communication/Maintenance 2-1-21 to 1-31

22


1/6/2021


4054


Health Resources, Inc

General Fund 2153.0


$ 517.33


$ 517.33


2718


Dental Insruance Jan 2021


1/6/2021


4055


Kansas City Life Insruance

General Fund 5143.9


$ 791.93


$ 791.93


2720


Life Insurance -Jan 2021


1/6/2021


4062

Morneau Shepell BDA Limited

General Fund 2010.0


$ 750.00


$ 750.00


2721


Employee Assistant Program-Quarterly fee Jan Mar 2021


1/6/2021


4065

South Shore Clean Cities Inc

General Fund 5610.5


$ 80,032.00


$ 80,032.00


2724


July 1- Sept 30 2020-CMAQ Air Quallity Public Education Quarterly Invoice


1/6/2021


4936

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2726


12/7-12/20/2020 pay period - United Way


1/6/2021


4946

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2726


12/21/202-1/3/2021 pay period - United Way


1/7/2021


4056


Fidelity EyeMed

General Fund 2154.0


$ 108.57


$ 108.57


C4056


Vision Insuance


1/7/2021


4053


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C4053


Recycle/Trash


1/7/2021


4059


Warner,Ty

General Fund 5410.9


$ 46.98


$ 46.98


C4059


Mileage- 45th St Ribbon Cutting/Cline Ave Ribbon Cutting


1/7/2021


4052


Warner,Ty

General Fund 5244.9


$ 125.00


$ 125.00


C4052


Communication Expense - Jan 2021


1/8/2021


4061


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C4061


Business Internet


1/10/2021


4046


Chicago Tribune

General Fund 5410.1


$ 27.72


$ 27.72


CC4046


News Paper Subscription


1/10/2021


4007


GoodHire

General Fund 5410.9


$ 54.99


$ 54.99


CC4007


Standard Background Check


1/10/2021


4057

LAI-LAMBDA ALPHA INTERNATIONL

General Fund 5410.1


$ 285.00


$ 285.00


CC4057


International dues/Active- Ely Chapter


1/10/2021


4049


Modern Tribe

General Fund 5410.1


$ 89.00


$ 89.00


CC4049


Event Calendar Pro Web/Access-yearly Subscription

18

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


1/10/2021


4045


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


CC4045


Stamps


1/12/2021


B-4941


Federal & Fica

General Fund 2140.0


$ 4,456.60


$ 4,456.60


C4941


12/21/2020-1/3/2021 pay period- FWT,empfica, emficamed - Federal Tax Withholdings Payable


1/12/2021


B-4941


Federal & Fica

General Fund 2142.0


$ 7,327.08


$ 7,327.08


C4941

12/21/2020-1/3/2021 pay period -FWT,

empfica, emficamed- FICA Tax Withholdings Payable


1/12/2021


B-4944


Horizon Bank

General Fund 2150.0


$ 792.31


$ 792.31


C4944


12/21/2020-1/3/2021 pay period -HAS


1/12/2021


4060


ICMA Retirment Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4060


ER paid for Ty Warner 12/21/2020 thru 1/3/2021-p/r


1/12/2021


B-4945


ICMA Retirment Fund-PR

General Fund 2146.0


$ 1,554.25


$ 1,554.25


C4945


12/21/2020-1/3/2021 pay period - ICMA


1/12/2021



Payroll



$ 36,300.41


$ 36,300.41



Payroll ending 1/03/2021


1/13/2021


B-4943


INPRS

General Fund 2149.0


$ 6,273.93


$ 6,273.93


C4943


12/21/2020-1/3/2021 pay period - EmpPerf [NIRPC]


1/14/2021


B-4932


IN Dept of Revenue

General Fund 2143.0


$ 1,530.65


$ 1,530.65


C4932


12/7-12/20/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable


1/14/2021


B-4932


IN Dept of Revenue

General Fund 2144.0


$ 322.31


$ 322.31


C4932


12/7-12/20/2020 pay period -LwtIN, SwtIN Local Tax Withholdings Payable


1/14/2021


B-4874


IN Dept of Revenue

General Fund 2143.0


$ 1,469.90


$ 1,469.90


C4874


11/23-12/6/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable


1/14/2021


B-4874


IN Dept of Revenue

General Fund 2144.0


$ 307.19


$ 307.19


C4874


11/23-12/6/2020 pay period - LwtIN, SwtIN Local Tax Withholdings Payable


1/14/2021


B-4865


IN Dept of Revenue

General Fund 2143.0


$ 91.22


$ 91.22


C4865


Edwards vacation payout- LwtIN, SwtIN State Tax Withholdings Payable


1/14/2021


B-4865


IN Dept of Revenue

General Fund 2144.0


$ 26.83


$ 26.83


C4865


Edwards vacation payout- LwtIN, SwtIN Local Tax Withholdings Payable


1/14/2021


B-4868


IN Dept of Revenue

General Fund 2143.0


$ 1,435.80


$ 1,435.80


C4868


11/9-11/22/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable


1/14/2021


B-4868


IN Dept of Revenue

General Fund 2144.0


$ 306.26


$ 306.26


C4868


11/9-11/22/2020 pay period - LwtIN, SwtIN Local Tax Withholdings Payable


1/15/2021


4068


Horizon Bank

General Fund 5142.9


$ 20,000.00


$ 20,000.00


C4068


ER paid Health Savings- JAN 2021


1/26/2021


B-4977


Federal & Fica

General Fund 2140.0


$ 4,456.93


$ 4,456.93


C4977


1/4-1/17/2021 pay period - FWT, empfica, empficamed Federal Tax Withholdings Payable


1/26/2021


B-4977


Federal & Fica

General Fund 2142.0


$ 7,327.54


$ 7,327.54


C4977


1/4/-1/17/2021 pay period - FWt, empfica, empficamed FICA Tax Withholdindgs Payable


1/26/2021


B-4980


Horizon Bank

General Fund 2150.0


$ 792.31


$ 792.31


C4980


1/4-1/17/2021 pay period - HAS


1/26/2021


B-4981


ICMA Retirment Fund-PR

General Fund 2146.0


$ 1,554.25


$ 1,554.25


C4981


1/4 - 1/17/2021 pay period - ICMA


1/26/2021


4081


ICMA Retirment Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4081


ER paid for Ty Warner 1/4/2020 thru 1/17/2021-p/r


1/26/2021


4084


IN Dept of Workforce Dev

General Fund 5123.9


$ 48.01


$ 48.01


C4084


4th Quarter 2020 Unemploment Tax


1/26/2021



Payroll



$ 36,302.58


$ 36,302.58



Payroll ending 1/17/2021


1/27/2021


4082


INPRS

General Fund 5141.9


$ 0.01


$ 0.01


C4082


Rounding Adjustment 1/4/2021-1/17/2021 pr


1/27/2021


B-4979


INPRS

General Fund 2149.0


$ 6,274.33


$ 6,274.33


C4979


1/4-1/17/2021 pay period-EmpPerf [NIRPC]


1/28/2021


4074


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2727


Recycle/Trash


1/28/2021


4091


City of Portage

General Fund 5224.9


$ 1,869.17


$ 1,869.17


2728


Sewer/Water/Gas/Electric Service


1/28/2021


4090


Engravables

General Fund 5410.1


$ 12.00


$ 12.00


2729


Yearly officer's plaque engraved plate


1/28/2021


4090


Engravables

General Fund 5410.1


$ 41.00


$ 41.00


2729


Gavel and laser engraved plate


1/28/2021


4087

Nat'l Assoc of Regional Councils

General Fund 5410.0


$ 250.00


$ 250.00


2730


NARC 2021 Confernece Ty Warner


1/28/2021


4087

Nat'l Assoc of Regional Councils

General Fund 5410.1


$ 250.00


$ 250.00


2730


NARC 2021 Confernece Justin 1K9iel


1/28/2021


4078

Nat'l Assoc of Regional Councils

General Fund 5410.1


$ 250.00


$ 250.00


2730


NARC 2021 Confernece Geof Benson


1/28/2021


4073


Quill

General Fund 5430.9


$ 183.53


$ 183.53


2732


Office Supplies


1/28/2021


3982


SME

General Fund 5610.5


$ 28,343.73


$ 28,343.73


2733

Programmatic Support & Outreach-Programmatic

Hazardous/Petroleum Site Assessment- Hazardous Substance


1/28/2021


B-4982

United Way of Porter County


General Fund


$ 33.85


$ 33.85


2734


1/4-1/17/2021 pay period - United Way


1/28/2021


4080


Ecointeractive

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4080


TIP SAAS Service Mthly fee -DEC 2020


1/28/2021


4086


Ecklund, Candice

General Fund 5410.9


$ 23.40


$ 23.40


C4086


Mileage- Engrave Chair plaque and plate/drop off and pickup





General Fund



$ -




Total:

$ 303,964.20


Allowance of Claims


We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the

register such claims are hereby allowed in the total amount of $ 303,964.20

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


1/6/2021


4038


ADOBE

CARES Fund 5910.0


$ 8,049.00


$ 8,049.00


2711


Adobe Standar DC Licenses


1/6/2021


4000


ERS Wireless

CARES Fund 5960.0


$ 16,802.27


$ 16,802.27


2716


Motorola XPR7550e UHF Portable Radios


1/6/2021


3928


Impact Networking LLC

CARES Fund 5910.0


$ 47,217.86


$ 47,217.86


2719


ZFIREFLY/Lenovo ThinkPads/RAM Chips/DOCKS/Installatiion & Configuration


1/6/2021


3960


Pulse Technology

CARES Fund 5430.9


$ 39.99


$ 39.99


2722


Office Supplies- Lysol- COVID 19


1/6/2021


4058


Routhmatch

CARES Fund 5960.0


$ 2,065.00


$ 2,065.00


2723


SLCCS/NT/PCACS


1/6/2021


3952

Tennant Sales and Service Company

CARES Fund 5960.0


$ 39,949.00


$ 39,949.00


2725


Tennant-Floor Sweeper/Battery/Charger/Vacuum Wand.Freight/Less Discount


1/11/2021


3994


North Township

CARES Fund 5760.0


$ 118,851.00


$ 118,851.00


C3994


NT Reimb for OA Apr-Jun2020 DRAW 24-CARES20


1/11/2021


3995


North Township

CARES Fund 5760.0


$ 10,247.00


$ 10,247.00


C3995


NT Reimb for PM Apr-Jun2020 DRAW 23-CARES20


1/11/2021


4009


North Township

CARES Fund 5760.0


$ 42,336.00


$ 42,336.00


C4009


2nd and 3rd Quarter PMTF Reimbursement


1/28/2021


3960


Pulse Technology

CARES Fund 5430.9


$ 39.99


$ 39.99


2731


Office Supplies- Lysol- COVID 19





CARES Fund



$ -



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


Total:

$285,597.11



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 $ 285,597.11

image



Dated this                           day of              , 2021.


image


image



image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 3/04/2021 @ 10:42 AM

Reconciliation - General

Page: 1

STK 3/4/21

03/12/2021

image

image

image

image

image

image

image

image

image

image

image

image

Closing Balance from Previous Statement........................................................................................... 1/31/2021 1,201,555.73


15

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


337,831.91

98

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


426,944.65

0

Adjustments Totaling..............................................................................................


0.00

1

Voids Totaling........................................................................................................


1,425.00


Service Charge.......................................................................................................

2/10/2021

94.40


Interest Earned.......................................................................................................

2/26/2021

89.66

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

2/28/2021

1,113,863.25

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


0.00

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

2/28/2021

1,091,474.54

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


(22,388.71)

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


0.00

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


1,113,863.25

Date

Check To

Check Description

Amount

7/02/2019

0002363 Kelly Tripp

Refund fee for tree steward workshop

28.83

8/27/2019

0002409 United Way of Porter County

8/5 - 8/18/2019 pay period - United Way

33.85

4/09/2020

0002545 Anthem Life

Life Ins for April 2020

490.75

6/02/2020

0002587 Anthem Life

Life Insurance June 2020

514.93

8/11/2020

0002624 Anthem Life

Life Insurance - August

502.84

12/15/2020

0002704 INRO Consultants

Renewal Software Agreement 7/1/20-

1,680.00


1/28/2021


0002730 Nat'l Assoc. of Regional Councils

12/31/20

Invoices 4078, 4087


750.00

2/09/2021

0002743 Nat'l Assoc. of Regional Councils

NARC 2021 Conference- George Topoll

250.00

2/09/2021

0002747 United Way of Porter County

1/18 - 1/31/2021 pay period - United Way

33.85

2/23/2021

0002750 City of Portage, The

Sewer/Water Service/Gas/Electric-FEB

2,094.35

2/23/2021

0002751 Health Resources,Inc

Invoices 4121, 4123

1,984.20

2/23/2021

0002752 SME

Invoices 111466, 112299, 114252, 115066,

13,991.26



115067


2/23/2021

0002753 United Way of Porter County

2/1 - 2/14 pay period - United Way

33.85


Total Unmarked Checks: 22,388.71

Total Checks:

22,388.71

Trial Balance - Cash

Run: 3/04/2021 at 10:54NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 2/28/2021


Page: 1



All Balance

1.1.001.0000.1010.0 Cash       1,091,474.54  

Total 1,091,474.54



image

STK 3/4/21



image

Closing Balance from Previous Statement........................................................................................... 1/31/2021 165,167.72


4

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


3,178.31

0

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


0.00

0

Adjustments Totaling..............................................................................................


0.00

0

Voids Totaling........................................................................................................


0.00


Service Charge.......................................................................................................


0.00


Interest Earned.......................................................................................................

2/26/2021

6.43

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

2/28/2021

168,352.46

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


0.00

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

2/28/2021

168,352.46

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


0.00

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


0.00

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


168,352.46

image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 3/03/2021 @ 1:43 PM

Reconciliation - Revolving Loan Fund

Page: 1

STK 3/3/21

03/12/2021

Trial Balance - Cash

Run: 3/04/2021 at 11:06NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 2/28/2021


Page: 1



All Balance

2.3.050.0000.1010.0 Cash          168,352.46  

Total 168,352.46


image STK 3/4/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021



Line Items


FY 2021 Budget

FY 21

YTD February Budget % Expended balance


Salaries




5020-1

Total Salaries

1,565,254

171,663 89%


Salaries Sub-Total

1,565,254

171,663 89%


Fringe Benefits

5121-9

FICA Contributions

119,742

15,003

87%

5122-9

Workers Compensation

9,500

0

100%

5123-9

Unemployment Compensation

3,000

48

98%

5141-9

PERF Contributions

200,012

25,724

87%

5142-9

Health Insurance

230,000

43,031

81%

5143-9

Life & Disability Insurance

24,000

2,742

89%

5145-9

ICMA

23,000

3,424

85%

5146-9

Staff Development

20,000

0

100%


Fringe Benefits Sub-Total

629,254

89,971

86%


Occupancy

5221-9

Office Lease

231,000

37,550

84%

5222-9

Property Insurance

6,500

100

98%

5223-9

Building Maintenance

18,540

2,998

84%

5224-9

Utilities

30,650

5,709

81%


Occupancy Sub-Total

286,690

46,357

84%


Maintenance

5241-9

Copier Leasing/Maintenance

20,370

1,685

0%

5243-9

Computer Service/Maintenance

43,736

7,077

0%

5244-9

Telephone Service/Maintenance

18,900

2,013

0%


Combined Copier/IT/Phone Service/Maintenance

83,006

10,775

87%

5249-9

Other Equipment Maintenance

2,000

50

98%


Maintenance Sub-Total

85,006

10,825

87%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

2,050

95%

5410-2

Communications: Transportation

299,000

4,200

99%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

0

100%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

388

99%

5420-5

Promotional Expenses: Environmental Programs

3,700

0

100%


Economic Development District

11,768

0

100%

5430-9

General Use Supplies Expense

7,000

226

97%


Departmental Sub-Total

442,223

6,864

98%


Contractual

5602-9

Legal Services

22,200

3,400

85%

5603-9

Audit and Accounting

38,000

0

100%

5604-9

LaPorte RLF Services

2,000

0

100%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,300

129,568

85%


Planning

320,000

0

100%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

51,500

4,250

92%


Contractual Sub-Total

1,292,347

137,218

89%


Capital Outlays

5910-0

Furniture and Equipment

180,000

0 100%


Capital Outlays Sub-Total

180,000

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,480,774

462,898 90%


LaPorte Revolving Loan Fund

85,000

0


Transit Capital Fund

142,080

0


Transit Operating Fund

4,460,765

127,010

TOTAL EXPENDITURES

9,168,619

589,908

image


CARES FUND EXPENDITURES

image

YTD February 2021 Expenses Budget vs Actual

300,000

260,876

250,000

215,391

200,000

171,663

150,000

137,218

104,876

89,971

100,000

73,704

47,782 46,357

50,000

14,168 10,825

6,864

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD February Budget YTD February Expended

image

YTD February 2021 Expended by Category


30%

37%


2%

2%

10%

19%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021


image

image

image

image

Revenue by Funding Source as of February 28, 2021

0%

0%

0%

0%

31%

69%

0%

County Appropriations

Federal Agencies State Agencies Local Agencies

Non-Governmental

Economic Development District

Interest Income

FY 20


Line Items


FY 2020 Budget

YTD February YTD Variance YTD % Budget %

Collected (Under)/Over Variance balance

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

0

0

0%

100%

1.1.4210

Federal Agencies

869,119

0

(724,266)

-100%

100%

1.1.4310

State Agencies

1,955,395

0

(1,629,496)

-100%

100%

1.1.4410

Local Agencies

44,694

0

(37,245)

-100%

100%

1.1.4610

Non-Governmental

85,318

600

(70,498)

-99%

99%

1.3.4260

Economic Development District

70,000

0

(58,333)

-100%

100%

1.1.4800

Interest Income

9,862

1,317

(6,902)

-84%

87%


Revenue Total

3,574,659

1,917

(2,526,740)

-100%

100%


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021



Line Items


FY 2021 Budget

YTD February

Expended

FY 21 Budget %

balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

236,733

34,379

85%

Salaries Sub-Total

236,733

34,379

85%


Contractual




RLF Services

5,000

-

100%

EDD- RLF CARES ACT

550,000


100%

EDD Insititutional CARES ACT

136,000


100%

Contractual Sub-Total

691,000

-

100%


Departmental




Communications

500

-

100%

PPE Supplies & Office Supplies

25,000

120

100%

Departmental Sub-Total

25,000

120

100%

Capital Outlays





Furniture and Equipment

165,000

56,009

66%

Capital Outlays Sub-Total

165,000

56,009

66%


TOTAL NIRPC CARES FUND EXPENDITURES

1,117,733

90,507

92%


CARES Revolving Loan Fund

583,000

-


CARES Transit Capital Fund

1,219,972

154,827


CARES Transit Agency Fund

4,314,322

129,098

TOTAL EXPENDITURES

7,235,027

374,432


image


image

image

YTD February 2020 Expenses Budget vs Actual

250,000

236,733

200,000

165,000

150,000

100,000

56,009

50,000

34,379

25,000

5,000

-

120

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

image


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021



Line Items


FY 2021 Budget


YTD February Collected

FY 21

Budget % balance

CARES ACT OPERATING




Operating Revenue

419,386

2,725

99%

Capital Revenue

125,000

0

100%


CARES ACT EDA Economic Development District

59,843

0

100%


604,229

2,725

100%


CARES AGENCY

FTA Revenue

2,694,048

108,377

96%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

129,098

87%


Revenue Total

4,307,009

240,200

94%


image

Revenue by Funding Source as of February 28, 2021


0%


100%

CARES Operating

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


2/2/2021


4099


DeLage Landen Financial

General Fund 5243.9


$ 5,329.26


$ 5,329.26


C4099


IT/Telephone/Copier/Maint.Office


2/3/2021


4105


United HealthCare

General Fund 5142.9


$ 14,040.97


$ 14,040.97


C4105


ER paid for FEB Health Insurance


2/3/2021


4105


United HealthCare

General Fund 2152.0


$ 2,593.64


$ 2,593.64


C4105


EE paid for FEB Health Insurance


2/9/2021



Payroll



$ 36,172.35


$ 36,172.35



Pay period ending 1/31/2021


2/9/2021



Payroll



$ 156.32


$ 156.32



Pay period ending 1/31/2021


2/9/2021


4115


Adams Radio Group

General Fund 5610.5


$ 952.00


$ 952.00


2735


60 second commercials Mon-Sat for 1wk 20% match funded with Deferred Revenue


2/9/2021


4108


Adams Radio Group

General Fund 5610.5


$ 1,188.74


$ 1,188.74


2735


Weather Sponsorship


2/9/2021


4106


Anthem Life

General Fund 5143.9


$ 511.80


$ 511.80


2737


Life Insurance FEB


2/9/2021


4110

Blachly, Tabor Bozak & Hartman

General Fund 5602.9


$ 1,700.00


$ 1,700.00


2737


Legal Services


2/9/2021


4113


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2748


Office Cleaning- FEB


2/9/2021


4109


City of Portage

General Fund 5241.9


$ 18,305.80


$ 18,305.80


2739


Lease- FEB


2/9/2021


4088


ESRI, Inc

General Fund 5610.2


$ 500.00


$ 500.00


2740


ERSI Credits-online storage of shapefile/maps etc.


2/9/2021


B-5006


Federal & Fica

General Fund 2142.0


$ 27.00


$ 27.00


C5006


Warner retro pay for 2020 (under paid by

$176.40) empfica, empficamed


2/9/2021


B-5000


Federal & Fica

General Fund 2140.0


$ 4,358.07


$ 4,358.07


C5000

1/18-1/31/2021 pay period-FWT, empfica,

empfica med--Federal Tax Withholdings Payable


2/9/2021


B-5000


Federal & Fica

General Fund 2142.0


$ 7,286.28


$ 7,286.28


C5000


1/18-1/31/2021 pay period-FWT, empfica, empfica med--FICA Tax Withholdings Payable


2/9/2021


B-5003


Horizon Bank

General Fund 2150.0


$ 792.31


$ 792.31


C5003


1/18-1/31/2021 pay period-HAS


2/9/2021


B-5004


ICMA Retirement Fund-PR

General Fund 2146.0


$ 1,554.25


$ 1,554.25


C5004


1/18-1/31/2021-pay period ICMA


2/9/2021


4096


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4096


ER paid for Ty Warner 1/18/2021 thru 1/31/2021-p/r


2/9/2021


4100


Kansas City Life

General Fund 5143.9


$ 962.26


$ 962.26


2741


Life Insurance FEB


2/9/2021


4114


Liberty Mutual Ins.

General Fund 5222.9


$ 100.00


$ 100.00


2742


Public Offical Bond NIRPC Treasure


2/9/2021


4112

Nat'l Assoc. Of Regional Councils

General Fund 5410.1


$ 250.00


$ 250.00


2743


NARC-2021 Conference- George Topoll


2/9/2021


4089

Premier Graphics &n Promotions

General Fund 5610.5


$ 5,060.00


$ 5,060.00


2744


Printing Service for Bicycle Maps-25,0000


2/9/2021


4092


Pulse Technology

General Fund 5430.9


$ 42.18


$ 42.18


2745


Office Supplies


2/9/2021


B-5005

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2747


1/18-1/31/2021 pay period- United Way


2/10/2021



Account Service Fee



$ 94.40


$ 94.40




2/10/2021


B-5002


INPRS

General Fund 2149.0


$ 6,273.93


$ 6,273.93


C5002


1/18-1/31/2021 pay period -EmpPerf {NIRPC}

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


2/10/2021


4101


Eklund, Candice

General Fund 5410.9


$ 7.80


$ 7.80


C4101


Mileage-Deliver plaque for M. Griffin - roundtrip


2/10/2021


4107


Fidelity EyeMed Vision

General Fund 2154.0


$ 99.01


$ 99.01


C4107


Vision Insurance


2/10/2021


4111


Warner,Ty

General Fund 5254.9


$ 125.00


$ 125.00


C4111


Commuincation Fee


2/10/2021


4102


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C4102


Recycle/Trash


2/11/2021


4104


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C4104


Business Internet


2/17/2021


B-4978


IN Dept of Revenue

General Fund 2143.0


$ 1,491.74


$ 1,491.74


C4978


1/4-1/17/2021 pay period- LwtIN, SwtIN-- State Tax Withholdings Payable


2/17/2021


B-4978


IN Dept of Revenue

General Fund 2144.0


$ 314.95


$ 314.95


C4978


1/4-1/17/2021 pay period- LwtIN, SwtIN-- Local Tax Withholding Payable


2/17/2021


B-4942


IN Dept of Revenue

General Fund 2143.0


$ 1,491.65


$ 1,491.65


C4942


12/21/2020-1/3/2021 pay period- LwtIN, SwtIN

-State Tax Withholdings Payable


2/17/2021


B-4942


IN Dept of Revenue

General Fund 2144.0


$ 314.93


$ 314.93


C4942


12/21//2020-1/3/2021 pay period-LwtIN, SwtIN

-Local Withholding Payable


2/23/2021



Payroll



$ 36,291.51


$ 36,291.51



Pay period ending 2/14/2021


2/23/2021


4128


City of Portage

General Fund 5224.9


$ 2,094.35


$ 2,094.35


2750


Sewer/Water/Electrical- FEB


2/23/2021


B-5030


Federal & Fica

General Fund 2140.0


$ 4,398.03


$ 4,398.03


C5030


2/1-2/14 pay period - FWT, empfica, empficamed Federal Tax Withholdings Payable


2/23/2021


B-5030


Federal & Fica

General Fund 2142.0


$ 7,314.08


$ 7,314.08


C5030


2/1-2/14 pay period - FWT, empfica, empficamed FICA Tax Withholdings Payable


2/23/2021


4121


Health Resources

General Fund 2153.0


$ 1,041.14


$ 1,041.14


2751


Dental Insurance- FEB


2/23/2021


4123


Health Resources

General Fund 2153.0


$ 943.06


$ 943.06


2751


Dental Insurance- March


2/23/2021


B-5033


Horizon Bank

General Fund 2150.0


$ 792.31


$ 792.31


C5033


2/1-2/14 pay period- HAS


2/23/2021


B-5034


ICMA Retirement Fund-PR

General Fund 2146.0


$ 1,554.25


$ 1,554.25


C5034


2/1-2/14 pay period- ICMA


2/23/2021


4119


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4119


ER paid for Ty Warner 2/1/2021 thru 2/14/2021-p/r


2/23/2021


3982


SME

General Fund 5610.5


$ 100.00


$ 100.00


C3982


Professional Services from Nov23-Dec20, 2020 Programmatic Support & Outreach Petroleum


2/23/2021


3982


SME

General Fund 5610.5


$ 7,557.51


$ 7,557.51


C3982


Professional Services from Nov23-Dec20, 2020 Programmatic Support & Outreach Hazardous


2/23/2021


3982


SME

General Fund 5610.5


$ 2,423.75


$ 2,423.75


C3982

Professional Services from Oct 26-Nov 22,

2020 Programmatic Support & Outreach Hazardous


2/23/2021


3982


SME

General Fund 5610.5


$ 485.00


$ 485.00


C3982

Professional Services from Aug 24-Sept 20,

2020 Programmatic Support & Outreach Petroleum


2/23/2021


3982


SME

General Fund 5610.5


$ 3,425.00


$ 3,425.00


C5035

Profssional Services from July 27-Aug23,

2020 Programmatic Support & Outreach Petroleum


2/23/2021


B-5035

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


C5035


2/1-2/14-pay period- United Way


2/24/2021


4122


IN Dept of Revenue

General Fund 5481.0


$ 310.00


$ 310.00


C4122


Penalty Tax Due for period ending 12/31/2019


2/24/2021


4118


INPRS

General Fund 5141.9


$ 0.01


$ 0.01


C4118


Rounding Adjustment 2/1/2021-2/14/2021 pr


2/24/2021


B-5032


INPRS

General Fund 2149.0


$ 6,273.93


$ 6,273.93


C5032


2/1-2/14 pay period - EmpPerf [NIRPC]





General Fund



$ -




Total:

$ 190,518.73


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 $ 190,518.73

image

Dated this                           day of              , 2021.


image


image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image image

image

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


2/9/2021


3960


Pulse Technology

CARES Fund 5430.9


$ 39.99


$ 39.99


2745


Lysol Membership- Covid 19


2/9/2021


4097


RouteMatch

CARES Fund 5960.0


$ 2,065.00


$ 2,065.00


2746


SLCCS/NT/PCACS- FEB Monthly SaaS and Notificaiton Module(NM)pkg- 35 Vehicles


2/17/2021


4095


Opportunity Enterprises

CARES Fund 5960.0


$ 48,610.00


$ 48,610.00


C4095


Construction Wrork/Installation of transit facility


2/23/2021


3955


Bosak Ford

CARES Fund 5960.0


$ 34,209.00


$ 34,209.00


2749


2020 F-150 4x4 Regaular Cab Styleside 8" box


2/26/2021


4069


City Of Valpo, The

CARES Fund 5960.0


$ 5,780.00


$ 5,780.00


C4069

Replace of gate opener at transit

facility/Install walk gate next to existing gate at transit facility


2/26/2021


4132

Lake County Community Services, Inc

CARES Fund 5760.0


$ 41,014.00


$ 41,014.00


C4132


PMTF Reimbursement for 4th Quarter 2020


2/26/2021


4130


North Township

CARES Fund 5760.0


$ 21,170.00


$ 21,170.00


C4130


PMTF Reimbursement for 4th Quarter 2020


2/26/2021


4070


Opportunity Enterprises

CARES Fund 5960.0


$ 5,346.59


$ 5,346.59


C4070

Laser/Monitors/Dell OptiPlex 3070 Desktop

Computers/HP202A toner Cartridges, Color and Black/Cable Matters 3-pack high speed HDMI


2/26/2021


4131

Porter County Aging and Community Services

CARES Fund 5760.0


$ 22,490.00


$ 22,490.00


C4131


PMTF Reimbursement for 4th Quarter 2020





CARES Fund



$ -







CARES Fund



$ -



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


Total:

$ 180,724.58


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 $ 180,724.58

image


Dated this                           day of              , 2021.


image


image

image


MEMORANDUM


TO: NIRPC Finance & Personnel Committee and NIRPC Executive Board FROM: Denarie Kane, Economic Development Specialist, NIRPC

RE: Recommendation and Approval of Amendments to the La Porte County Revolving

Loan Fund Management Plan

DATE: February 18, 2021


The La Porte County Revolving Loan Fund (RLF) Board reviewed the attached summary of update recommendations prepared by Gabrielle Biciunas, Economic Development District Coordinator, and took approval action on February 3, 2021. This amendment process was initiated since a five year update of a RLF Management Plan is required by the Economic Development Administration (EDA).


Several of these amendments addressed items now required by EDA, and these are noted in the attached summary under Conflict of Interest, Allowable Cash Percentage, Audits, and Environmental Section. Under Economic Development Administration Reporting, the language was revised as suggested by EDA. In regard to Delinquency Management, the red edits are the additions that were made to the Management Plan’s existing language to address loan restructuring. The other changes (see page 1), reflect updates to Comprehensive Economic Development Strategy (CEDS), Economic Adjustment Overview, Application Fee, and Loan Servicing Procedures - Repayment.


The EDA subsequently approved and accepted all of these amendments on February 12, 2021. A request is now being made for the Finance and Personnel Committee to recommend that NIRPC’s Executive Board, acting on behalf of the Commission, also approve these amendments and adopt Resolution #21-03. Thank you.


Attachment: La Porte County RLF Management Plan - Update Recommendations (5 pages)

LaPorte County RLF Management Plan – Update Recommendations

Due by March 2021


Comprehensive Economic Development Strategy (CEDS)


Conflict of Interest (language added by EDA)

Replace existing language with EDA required language:

EDA requires inclusion of the following:

  1. Definitions.

    1. An “Interested Party” is any officer, employee or member of the board of directors or other governing board of Recipient, including any other parties that advise, approve, recommend or otherwise participate in the business decisions of Recipient, such as agents, advisors, consultants, attorneys, accountants or shareholders. An Interested Party also includes the Interested Party’s “Immediate Family” (defined as a person’s spouse or partner in a domestic relationship, parents, grandparents, siblings, children and grandchildren, but not distant relatives, such as cousins, unless the distant relative lives in the same household as the person) and other persons directly connected to the Interested Party by law or through a business arrangement.

    2. A conflict of interest generally exists when an Interested Party participates in a matter that has a direct and predictable effected on the Interested Party’s personal or financial interests or there is an appearance that an Interested Party’s objectivity in performing his or her responsibilities under the Project is impaired.

    3. An appearance of impairment of objectivity could result from an organizational conflict where, because of other activities or relationships with other persons or entities, a person is unable or potentially unable to render impartial assistance, services, or advice. It also could result from non-financial gain to the individual, such as benefit to reputation or prestige in a professional field.

  2. Conflicts of Interest Rules.

    Recipient must adhere to EDA conflicts of interest rules set forth at 13 CFR § 302.17, including the following rules specific to RLFs:

    1. An Interested Party of Recipient shall not receive, directly or indirectly, any personal or financial benefit resulting from the disbursement of RLF loans. A financial interest or benefit may include employment, stock ownership, a creditor or debtor relationship, or prospective employment with the organization selected or to be selected for a subaward.

    2. Recipient shall not lend RLF funds to an Interested Party.

    3. Former board members of Recipient and members of their Immediate Family shall not receive a loan from the RLF for a period of two years from the date that the board member last served on the board of directors.

  3. Duty to Disclose.

    Recipient must, in a timely fashion, disclose to EDA in writing any actual or potential conflict of interest.

  4. Written Standard of Conduct.

    1. Recipient must maintain written standards of conduct to establish safeguards to prohibit employees from using their positions for a purpose that constitutes or presents the appearance of a personal or organizational conflict of interest or personal gain in the administration of this RLF Award.

    2. Recipient must maintain written standards of conduct covering conflicts of interest and governing the performance of its employees engaged in the selection, award and administration of contracts. See Section K, Other EDA Requirements, Subsection 4. Codes of Conduct and Sub-Award, Contract and Subcontract Provisions, Subsection b), Competition and Codes of Conduct for Subawards.


Delinquency Management

If defaults have occurred and are not cured in a reasonable amount of time, actions can be taken prior to restructuring loan agreements and pursuing legal action to recover the investment. NIRPC staff and/or contracted service will stay in close contact with the business to monitor activity and be immediately aware of further deterioration. Possible activities include:



5

image image


RESOLUTION 21-03


A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION UPDATING THE MANAGEMENT PLAN FOR THE LAPORTE COUNTY REVOLVING LOAN FUND


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


Whereas, the Commission adopted certain updates to the Management Plan for the LaPorte County Revolving Loan Fund (hereafter referred to as “The LaPorte County RLF”) on May 19, 2016 in Resolution 16-19; and


Whereas, the Economic Development Administration (EDA) requires five-year updates to Management Plans for Revolving Loan Fund programs; and


Whereas, the LaPorte County RLF Board approved and adopted updates to the Plan at their meeting of February 3, 2021 by unanimous vote; and


Whereas, the EDA subsequently approved and accepted these updates to the Laporte County RLF Management Plan on February 12 , 2021;


Now, Therefore Be It Resolved that the Commission approves the required five-year update to the Management Plan for the LaPorte County Revolving Loan Fund, as attached to this resolution.


Duly adopted by the Northwestern Indiana Regional Planning Commission this 18th day of March 2021.


image

George Topoll Chairperson



ATTEST:


image

Richard Hardaway Secretary

image


MEMORANDUM

TO: NIRPC Finance & Personnel Committee and NIRPC Executive Board FROM: Denarie Kane, Economic Development Specialist, NIRPC

RE: Recommendation and Approval of Amendments to the Regional Revolving Loan Fund Management Plan for Lake, Porter, and La Porte Counties

DATE: February 25, 2021


The Regional Revolving Loan Fund Management Plan for Lake, Porter, and La Porte Counties, approved on September 17, 2020, is in need of amendment related to the application fee charged loan applicants. On pages 16 and 17 is a section titled Fees. There are also references to specific fee amounts on page 24 under a section titled Submittal Requirements from Each Applicant, on page 25 under a section titled Loan Closing Schedule, Fund and Close of Loan, and on page 27 under a section titled Loan Disbursement.


The two sections under Fees which are requested to be amended are duplicated below and noted as Current Language. The $200 amount collected for the Loan Application Fee is insufficient to cover the cost of preparing the Credit Memorandum and obtaining the Credit Reports. Based on a contract pending with the Regional Development Company to provide these two required services, an increase in the Application Fee is proposed. The proposed Application Fee would be $450, and the proposed Closing Fee would therefore be $550. In total, a $1,000 sum will be collected in fees for approved loans which is the same $1,000 sum as is currently collected. The proposed amendment is shown below and noted as Proposed Language.


Fees (Current Language on pages 16 & 17)


Loan Application Fee: A non-refundable loan application fee of two hundred dollars ($200) will be charged to all loan applicants. If the loan is approved, the fee will be applied to the loan processing fee.


Closing Fee: Borrowers will pay NIRPC one thousand dollars ($1,000) at the time of closing to provide for certain administrative and legal fees associated with loan preparation and closing.


Fees (Proposed Language)


Loan Application Fee: A non-refundable loan application fee of four hundred and fifty dollars ($450) will be charged to all loan applicants. If the loan is approved, this $450 fee will be applied to the $1,000 in total fees collected which includes the closing fee.


Closing Fee: Borrowers will pay NIRPC five hundred and fifty dollars ($550) remaining of the total fee of one thousand dollars ($1,000) at the time of closing to provide for certain administrative and legal fees associated with loan preparation and closing.

On page 24 under Submittal Requirements from Each Applicant, the $200 amount is part of a bulleted submittal requirement that reads “Application with $200 application fee”. This bulleted submittal requirement is proposed to read “Application with application fee”.


In addition, the dollar amount in the last sentence under the Loan Closing Schedule, Fund and Close of Loan section needs to be amended to reflect an application fee of $450 and the remaining amount of

$550 owed as a closing fee.


This sentence on page 25 currently reads as follows:


The applicant, prior to receiving the loan check, is required to pay in full the $1,000 loan closing fee less the application fee of $200.


This sentence is proposed to read as follows:


The applicant, prior to receiving the loan check, is required to pay in full the $550 loan closing fee.


Lastly, the dollar amount in the last sentence under the Loan Disbursement section needs to be amended to reflect the closing fee of $550.


This sentence on page 27 currently reads as follows:


The applicant must pay in full the $1,000 closing fee prior to the disbursement of any funds.


This sentence is proposed to read as follows:


The applicant must pay in full the $550 closing fee prior to the disbursement of any funds.


Upon inquiry made by EDD staff on February 11, 2021, the Economic Development Administration has informed NIRPC that loan application fee amounts are not within their purview. Therefore, the following items are requested to be approved by NIRPC’s Finance and Personnel Committee in accordance with their responsibilities outlined in the Regional RLF Management Plan for Lake, Porter, and La Porte Counties on page 21 :


  1. Approve the amendment to the Fee section as proposed (pages 16 & 17).


  2. Approve the amendment to the Submittal Requirements from Each Applicant section as proposed (page 24).


  3. Approve the amendment to the Loan Closing Schedule, Fund and Close of Loan section as proposed (page 25).


  4. Approve the amendment to the Loan Disbursement section as proposed (page 27).


Furthermore, a request is made for the Finance and Personnel Committee to recommend that NIRPC’s Executive Board, acting on behalf of the Commission, also approve these amendments and adopt Resolution #21-04. Thank you.

image


RESOLUTION 21-04


A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION AMENDING THE FEES IN THE MANAGEMENT PLAN FOR THE REGIONAL REVOLVING LOAN FUND FOR LAKE, PORTER, AND LA PORTE COUNTIES


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


Whereas, the Commission adopted a Management Plan (hereafter referred to as “The Plan”) for the Regional Revolving Loan Fund for Lake, Porter, and La Porte Counties on September 17, 2020, in Resolution 20-26; and


Whereas, the existing $200 application fee in the Plan was recommended to be increased to

$450 so there are sufficient dollars available to cover the costs of certain contracted services necessary to evaluate loan requests and the credit worthiness of the applicants; and


Whereas, the total amount of fees paid by an applicant for an approved loan will remain at

$1,000 with the balance of $550 paid at the time of loan closing prior to the disbursement of any loan funds; and


Whereas, the EDA advised Economic Development District staff on February 11, 2021, that the EDA does not regulate loan application fees so the EDA’s approval of the proposed fee amendments to the Plan is not required; and


Whereas, the Finance and Personnel Committee approved and adopted various amendments to the Plan related to the recommended increase in the application fee at their meeting of March 18, 2021, by unanimous vote; and


Now, Therefore Be It Resolved that the Commission approves the amended Management Plan for the Regional Revolving Loan Fund for Lake, Porter, and La Porte Counties as attached to this resolution.


Duly adopted by the Northwestern Indiana Regional Planning Commission this 18th day of March 2021.


image

ATTEST: George Topoll

Chairperson


image

Richard Hardaway