image

FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda - Thursday, January 20, 2022 -- 8:00 a.m.


6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org



  1. Call to Order

  2. Meeting Minutes of December 16, 2021 Pages 1

  3. Review of Financial Status – November 2021 Budget vs Actual Pages 2 - 12

    1. Bank Statement Reconciliations (pg. 2-7)

    2. General Fund Expenses YTD November 2021 (pg. 8-9)

    3. General Fund Revenue YTD November 2021 (pg. 10)

    4. CARES Expenses YTD November 2021 (pg. 11)

    5. CARES Revenue YTD November 2021 (pg. 12)

  4. Approval of General Fund Claims Register – November 2021 Pages 13 - 16

    ACTION REQUESTED: Approval

  5. Approval of CARES Act Claims Register – November 2021 Pages 17

    ACTION REQUESTED: Approval

  6. Approval of RLF Claims Register – November 2021 Pages 18

    ACTION REQUESTED: Approval

  7. Resolution 22-01 Calendar Year 2022 NIRPC Budget Pages 19 - 30

    ACTION REQUESTED: Recommendation for Approval

  8. New three-year Executive Director Employment Agreement Pages 31 - 34

    ACTION REQUESTED: Recommendation for Approval

  9. RDG Planning & Design Contract for 2050 Metropolitan Transportation Plan – Active Transportation Element

    ACTION REQUESTED: Recommendation for Approval

  10. Personnel update

  11. Other Business

  12. Adjournment


The next meeting is scheduled for March 21, 2022 at 8:00 a.m.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

December 16, 2021 / Zoom Virtual Meeting – 9:00 a.m.


Members Present

Denise Ebert, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson, George Topoll


Staff and Others Present

Talaya Jones, Meredith Stilwell, Ty Warner, Lisa Todd, Stephanie Kuziela, Sue Lynch, Scott Kingan, Mary Tanis, Geof Benson, David Hollenbeck,


Call to Order

Chairman Stinson called the meeting to order.

Approval of Minutes

The minutes of the November 18, 2021 meeting were presented. Justin Kiel made motion and George Topoll seconded to approve the minutes. A roll call vote was taken with Denise Ebert, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll. Motion passed 6-0.


NIRPC FY 2022 Preliminary Budget

Talaya Jones presented the preliminary budget. The final budget will go before the Finance & Personnel Committee at the January 20th meeting and, if given a favorable recommendation, be presented to the NIRPC Commission for approval.


The Revenue, Departmental and Contractual budgets were all decreased due to the depletion and end of CARES Act funds. Salary and Fringe benefits budgets were increased due to the possibility of open positions being filled and Executive Director and staff salary increases. Salary increases will be factored using employee evaluations. The Occupancy budget was increased to accommodate an increase in NIRPC’s lease. Portage allowed the 2020 rate to be held throughout 2021, but an increase for 2022 is expected. The Equipment Service/Maintenance budget was decreased after budget to actuals for 2021 were reviewed.


Talaya noted she was able to find some cost savings from 2021, but to compete in the salary market and achieve budget sustainability, NIRPC needs to obtain more local share.


A short discussion was held regarding the pay for subrecipient bus drivers and Talaya noted a grant is being written.

Other Business

Ty reported on the triennial and certifications reviews and noted the certification review deadline is December 20th and is expected to be finished any day.


George Topoll inquired on the status of the State Board of Accounts audit and Talaya reported that the contractors hired by the SBOA to complete the audits were backlogged due to the number of audits. The timeframe looks to have the audit wrapping up around the end of January.

Adjournment

There being no further business, the meeting was adjourned.


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

10/31/2021

1,462,403.46

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


1.159,712.27

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


1,259,716.27

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


33,634.43

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


108.57

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

11/10/2021

121.60

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

11/30/2021

72.93

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

11/30/2021

1,396,093.79

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


0.00

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

11/30/2021

1,329,830.11

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


(66,263.68)

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


0.00

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


1,396,093.79


Date

Check To

Check Description

Amount


7/02/2019

0002363 Kelly Tripp

Refund fee for tree steward workshop

28.83


8/27/2019

0002409 United Way of Porter County

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

33.85


4/09/2020

0002545 Anthem Life

Life Ins for April 2020

490.75


6/02/2020

0002587 Anthem Life

Life Insurance June 2020

514.93


8/11/2020

0002624 Anthem Life

Life Insurance - August

502.84


3/23/2021


11/16/2021

0002764 American of Metropolitan Planning Organization

0002907 United Way of Porter County

NIRPC-Job Posting Director of Transportaion


10/25 - 11/7/2021 pay period - United Way

50.00


33.85


11/30/2021

0002908 City of Portage, The

Sewer/Water/Gas/Electric-NOV

1,876.79


11/30/2021

0002909 ESRI, INC.

ESRI Software renewal for ArcGIS

4,200.00


11/30/2021

0002910 SME

Programmatic support & Outreach Haz/lnventory and Prioritization Haz/Clean

58,497.99



11/30/2021


0002911 United Way of Porter County

up Haz/Site Assess Haz

11/8 - 11/21/2021 pay period - United Way


33.85



Total Unmarked Checks: 66,263.68

Total Checks:

66,263.68

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 12/29/2021 @ 12:49 PM

5

Reconciliation - General

IJ./d9/J-I

Page:

01/12/2022

Trial Balance - Cash

Run: 1212912021 at 12:ltJ THWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 11/30/2021


Page: 1



All

1.1.001.0000.1010.0 General Cash Total


Balance

1,329,830.11

1,329,830.11


s l

image

1J-/dq Ji\

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 1210112021 @ 9:11 AM Reconciliation - CARES RLF Bank Account Page:


image

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

11/01/2021

0.00


2

Deposits and other Additions Totaling......................................................................


83,634.43


Checks and other Withdrawls Totaling.....................................................................


50,000.00

2

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


-31,734.43

0

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


0.00


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


0.00


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

11/30/2021

0.42

Closing Balance for this Statement..................................................................................................... 11/30/2021

1,900.42

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

0.00

Cash Balance from General Ledger.................................................................................................... 11/30/2021

1,241.67

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

(658.75)

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

0.00

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

1,900.42

Date Check To Check Description

Amount

11/17/2021 0010001 Regional Development Co. Underwriting Services for J's Breakfast Club

658.75

Total Unmarked Checks: 658.75 Total Checks:

658.75


\/ '51(

11/1/JGJI


\1'

\\ \

Trial Balance - Cash

Run: 1210112021 at 9:scN.QRTHWESTERN IN DIANA REGIONAL PLANNING COMMISSION

For 11/30/2021


Page: 1



All

4.3.050.0000.1010.0 CARES ALF Cash

Total


Balance

             1,241.67  

1,241.67


/s l I dJoJ\


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 1210112021 @ e:1a AM Reconciliation - Revolving Loan Fund Page:

image



image

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

10/31/2021

266,936.27


4

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


2,881.24

0

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


0.00


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


-1,900.00

0

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


0.00


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


0.00


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

11/30/2021

8.83

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

11/30/2021

267,926.34

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


0.00

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

11/30/2021

267,926.34

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


0.00

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


0.00

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


267,926.34


image

/s\\li\ \\ a \

Trial Balance - Cash

Run: 1210112021 at 9:3cN..0RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 11/30/2021


Page: 1



All

2.3.050.0000.1010.0 LaPorte Cash

Total


Balance 267,926.34

267,926.34


Js i\ ,

IJ,\ I B

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021 Budget

FY 21

YTD November Budget % Expended balance


Salaries




5020-1

Total Salaries

1,328,521

1,052,426 21%


Salaries Sub-Total

1,328,521

1,052,426 21%


Fringe Benefits

5121-9

FICA Contributions

119,742

88,769

26%

5122-9

Workers Compensation

9,500

6,429

32%

5123-9

Unemployment Compensation

3,000

1,059

65%

5141-9

PERF Contributions

200,012

150,725

25%

5142-9

Health Insurance

230,000

168,205

27%

5143-9

Life & Disability Insurance

24,000

14,830

38%

5145-9

ICMA

23,000

20,542

11%

5146-9

Staff Development

20,000

2,885

86%


Fringe Benefits Sub-Total

629,254

453,444

28%


Occupancy

5221-9

Office Lease

231,000

206,507

11%

5222-9

Property Insurance

6,500

1,319

80%

5223-9

Building Maintenance

18,540

17,080

8%

5224-9

Utilities

30,650

25,231

18%


Occupancy Sub-Total

286,690

250,136

13%


Maintenance

5241-9

Copier Leasing/Maintenance

20,370

9,270

54%

5243-9

Computer Service/Maintenance

43,736

39,466

10%

5244-9

Telephone Service/Maintenance

18,900

12,659

33%


Combined Copier/IT/Phone Service/Maintenance

83,006

61,395

26%

5249-9

Other Equipment Maintenance

2,000

1,133

43%


Maintenance Sub-Total

85,006

62,528

26%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

11,079

73%

5410-2

Communications: Transportation

299,000

23,067

92%

5410-3

Economic Development District

11,768

2,116

82%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

23,227

8%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

11,239

60%

5420-5

Promotional Expenses: Environmental Programs

3,700

7,500

-103%

5430-9

General Use Supplies Expense

6,000

1,909

68%

5411-3

Grant/Contract Funds Return


3687


Departmental Sub-Total

441,223

83,823

81%


Contractual

5602-9

Legal Services

22,200

18,700

16%

5603-9

Audit and Accounting

33,000

54

100%

5604-9

LaPorte RLF Services

2,000

649

68%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,300

671,288

20%

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

41,478

19%


Contractual Sub-Total

1,287,347

732,169

43%


Capital Outlays

5910-0

Furniture and Equipment

80,000

0 100%


Capital Outlays Sub-Total

80,000

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,138,041

2,634,527 36%


LaPorte Revolving Loan Fund

85,000

0


Transit Capital Fund

3,297,959

147,305


Transit Operating Fund

4,460,765


image

1,733,185

11,981,765

4,515,016

TOTAL EXPENDITURES

8


CARES FUND EXPENDITURES

image

YTD November 2021 Expenses Budget vs Actual

1,400,000


1,200,000

1,217,811

1,180,068

1,052,426

1,000,000


800,000

732,169

576,816

600,000

453,444

404,454

400,000

262,799 250,136

200,000

77,922 62,528

83,823

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD November Budget YTD November Expended

image

YTD November 2021 Expended by Category

28%

40%

3%

2%

10%

17%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

9


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021 Budget


YTD November

Collected FY 21 Budget % balance

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

540,271

0%

1.1.4210

Federal Agencies

869,119

314,340

64%

1.1.4310

State Agencies

1,955,395

1,122,254

43%

1.1.4410

Local Agencies

44,694

29,310

34%

1.1.4610

Non-Governmental

85,318

9,100

89%

1.3.4260

Economic Development District

70,000

31,462

55%

1.1.4800

Interest Income

9,862

6,705

32%


Revenue Total

3,574,659

2,053,441

43%


image

Revenue by Funding Source as of November 30, 2021

2%

0%

1% 1%


26%


55%

15%

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 NOVEMBER 30, 2021



Line Items


FY 2021 Budget


YTD November Expended


FY 21 Budget % balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

236,733

156,058

34%

Salaries Sub-Total

236,733

156,058

34%


image

image

YTD November 2021 Expenses Budget vs Actual

250,000

236,733

200,000

156,058

150,000

146,000

100,000

100,000

70,873

50,000

5,659

1,500 643

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

Contractual

RLF Services

5,000

659

87%

Audit & Accounting

5,000

5,000

0%

EDD Insititutional CARES ACT

136,000

-

100%

Contractual Sub-Total

146,000

5,659

96%

Departmental




Communications

500

276

45%

PPE Supplies & Office Supplies

1,000

367

63%

Departmental Sub-Total

1,500

643

57%


Capital Outlays




Furniture and Equipment

100,000

70,873

29%

Capital Outlays Sub-Total

100,000

70,873

29%



TOTAL NIRPC CARES FUND EXPENDITURES

484,233

233,232

52%


CARES Revolving Loan Fund

530,000

50,000


CARES Transit Capital Fund

1,008,732

425,407


CARES Transit Agency Fund

2,694,048

2,142,998


TOTAL EXPENDITURES

4,717,013

2,851,637



NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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


image



Line Items


FY 2021 Budget

YTD November

Collected

FY 21 Budget %

balance

CARES ACT OPERATING




Operating Revenue

419,386

383,873

8%

Capital Revenue

125,000

0

100%


image

Revenue by Funding Source as of November 30, 2021


6%

14%


80%

CARES Operating

Economic Development District

CARES Act RLF

CARES ACT RLF Oversight Revenue 30,540


CARES ACT EDA Economic Development District

59,843

67,426

-13%


604,229

481,838

20%


CARES ACT RLF

Loan Proceeds


50,000


CARES ACT RLF

Loan Application Fees & Interest


1,900


CARES AGENCY

FTA Revenue

2,694,048

2,142,998

20%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

425,405

58%


Revenue Total

            4,307,009              

3,102,142                                    

28%


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/1/2021


4523


DeLage

General Fund 5243.9


$ 3,723.91


$ 3,723.91


C4523


IT


11/1/2021


4523


DeLage

General Fund 5243.9


$ 842.74


$ 842.74


C4523


Copier


11/1/2021


4523


DeLage

General Fund 5243.9


$ 206.25


$ 206.25


C4523


MainOffice365


11/2/2021


4531


Anthem Life

General Fund 5143.9


$ 549.76


$ 549.76


C4531


Life Insurance- NOV


11/2/2021


4641

Economic Development Administration

General Fund 5411.3


$ 3,686.59


$ 3,686.59


C4641


Refund 2020 Partnership Grant due to overdraw


11/2/2021


B-5567


Federal & Fica

General Fund 2140.0


$ 4,570.54


$ 4,570.54


C5567


10/11-10/24/2021 pay period- FWT, empfica, empficamed- Federal Tax Withholdings Payable


11/2/2021


B-5567


Federal & Fica

General Fund 2142.0


$ 7,900.30


$ 7,900.30


C5567


10/11-10/24/2021 pay period- FWT, empfica, empficamed- FICA Tax Withholdings Payable


11/2/2021


B-5570


Horizon Bank

General Fund 2150.0


$ 522.31


$ 522.31


C5570


10/11-10/24/2021 pay period- HSA


11/2/2021


4524


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4524


ER paid for Ty Warner 10/11/2021 thru 10/24/2021 -p/r


11/2/2021


B-5571


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5571


10/11-10/24/2021 pay period - ICMA


11/2/2021



Payroll



$ 40,212.04


$ 40,212.04



Pay period ending 11/2/2021


11/3/2021


4545


Adams Radio Group

General Fund 5610.5


$ 3,144.00


$ 3,144.00


2898

3 Hour Live Broadcast Oct 9, 2021-Pay

Federal Share of Radio Promotion of Porter County Gas Can Exchange event


11/3/2021


4526

Blachly, Tabor. Bozik & Hartman

General Fund 5602.9


$ 1,700.00


$ 1,700.00


2899


Legal- NOV


11/3/2021


4543


City of Portage

General Fund 5224.9


$ 2,378.85


$ 2,378.85


2900


Sewer-OCT/Water-OCT/Gas/electric-Sept/OCT


11/3/2021


4525


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2900


Lease- NOV


11/3/2021


B-5569


INPRS

General Fund 2149.0


$ 6,766.26


$ 6,766.26


C5569


10/11-10/24/2021 pay period-EmpPerf{NIRPC}


11/3/2021


4533


Kansas City Life

General Fund 5143.9


$ 917.40


$ 917.40


2902


S-T Disability/L-T Disability Insurance- NOV


11/3/2021


4539


One Region

General Fund 5410.3


$ 75.00


$ 75.00


2903


One Region Luncheon- Matthew Paskash


11/3/2021


4538


One Region

General Fund 5410.3


$ 75.00


$ 75.00


2903


One Region Luncheon- Denarie Kane


11/3/2021


4528


Paramount Dental

General Fund 2153.0


$ 921.04


$ 921.04


2904


Dental Insurance-NOV


11/3/2021


4553


United HealthCare

General Fund 5142.9


$ 11,515.32


$ 11,515.32


C4553


ER paid NOV 2021 Health Insurance


11/3/2021


4553


United HealthCare

General Fund 2152.0


$ 2,150.08


$ 2,150.08


C4553


EE paid NOV 2021 Health Insurance


11/3/2021


B-5572


United Way

General Fund 2147.0


$ 33.85


$ 33.85


2905


10/11-10/24/2021 pay period-United Way


11/4/2021


4534


Dialpad

General Fund 5244.9


$ 582.38


$ 582.38


C4534


Telephone Service-NOV


11/4/2021


4546


Fidelity EyeMed

General Fund 2154.0


$ 108.57


$ 108.57


C4546


Vision Insurance- NOV


11/4/2021


4544


Hammond, Allen

General Fund 5410.2


$ 16.38


$ 16.38


C4544


Mileage-Nirpc to ECT -RT

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


11/4/2021


4514

Lake County Community Services, Inc

General Fund 5760.0


$ 35,573.00


$ 35,573.00


C4514


3rd Quarter 2021 PMTF Reimbursement-LCCS


11/4/2021


4520


North Township

General Fund 5760.0


$ 18,360.00


$ 18,360.00


C4520


3rd Quarter 2021 PMTF Reimbursement-NT


11/4/2021


4515

Porter County Aging and Community Services

General Fund 5760.0


$ 19,508.00


$ 19,508.00


C4515


3rd Quarter 2021 PMTF Reimbursement- PCACS


11/4/2021


4541


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C4541


Garbage/Recycle-NOV


11/4/2021


4527


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C4527


Communication Fee- NOV


11/5/2021


4542


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C4542


Business Internet- NOV


11/9/2021


B-5524


IN Dept of Revenue

General Fund 2143.0


$ 1,636.43


$ 1,636.43


C5524


9/13-9/26/2021 pay period -LwtIN, SwtIN- State Tax Withholdings Payable


11/9/2021


B-5524


IN Dept of Revenue

General Fund 2144.0


$ 374.23


$ 374.23


C5524


9/13-9/26/2021 pay period -LwtIN, SwtIN- Local Tax Withholdings Payable


11/9/2021


B-5537


IN Dept of Revenue

General Fund 2143.0


$ 1,636.43


$ 1,636.43


C5537


9/27-10/10/2021 pay period- LwtIN, SWtIN- State Tax Withholdings Payable


11/9/2021


B-5537


IN Dept of Revenue

General Fund 2144.0


$ 374.23


$ 374.23


C5537


9/27-10/10/2021 pay period- LwtIN, SWtIN- Local Tax Withholdings Payable


11/10/2021


4530


Chicago Tribune

General Fund 5410.1


$ 27.72


$ 27.72


CC4530


News Paper Subscription


11/10/2021


4472


Amazon

General Fund 5430.9


$ 65.97


$ 65.97


CC4472


Logitech USB Headset H390 with Noise Cancelling


11/10/2021


4497


One Region

General Fund 5410.9


$ 75.00


$ 75.00


CC4497


One Region 2021 In-Person Luncheon- Ty Warner


11/10/2021



Service Fee



$ 121.60


$ 121.60



Service Fee


11/10/2021


4536


Squarespace

General Fund 5410.1


$ 216.00


$ 216.00


CC4536


Annual Subscription- Business website 9/17/21-9/17/2022


11/10/2021


4529


Stamps

General Fund 540.9


$ 24.99


$ 24.99


CC4529


Stamps


11/10/2021


4488


SurveyMonkey

General Fund 5410.2


$ 384.00


$ 384.00


CC4488


Survey Monkey Renewal - Advantage Annual Plan


11/16/2021


4555


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2906


Office Cleaning- NOV 2021


11/16/2021


B-5605


Federal & Fica

General Fund 2140.0


$ 4,231.80


$ 4,231.80


C5605


10/25-111/7/2021 pay period - FWT,empfica, empficamed-Federal Tax Withholdings Payable


11/16/2021


B-5626


Federal & Fica

General Fund 2142.0


$ 7,500.28


$ 7,500.28


C5605


10/25/-11/7/2021 pay period - FWT, empfica, empficamed-FICA Tax Withholdings Payable


11/16/2021


B-5624


Federal & Fica

General Fund 2140.0


$ 206.69


$ 206.69


C5626


Exl vacation payout w/PERF- FWT,empfica, empficamed-Federal Tax Withholdings Payable


11/16/2021


B-5608


Federal & Fica

General Fund 2142.0


$ 306.00


$ 306.00


C5626


Exl vacation payout w/PERF- FWT,empfica, empficamed-FICA Tax Withholdings Payable


11/16/2021


B-5609


Federal & Fica

General Fund 2140.0


$ 515.76


$ 515.76


C5624


Exl vacation payout w/out PERF-FWT,empfica, empficamed-Federal Tax Withholdings Payable


11/16/2021


4567


Federal & Fica

General Fund 2142.0


$ 520.96


$ 520.96


C5624


Exl vacation payout w/out PERF-FWT,empfica, empficamed-FICA Tax Withholdings Payable


11/16/2021


B-5610


Horizon Bank

General Fund 2150.0


$ 761.06


$ 761.06


C5608


10/25-11/7/2021 pay period- HSA


11/16/2021


B-5609


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5609


10/25-11/7/2021 pay period- ICMA


11/16/2021


4567


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4567


ER paid for Ty Warner 10/25/2021 thru 11/7/2021-p/r


11/16/2021



Payroll



$ 38,233.77


$ 38,233.77



Payroll period ending 11/16/2021


11/16/2021



Payroll-Vacation Payout



$ 4,067.50


$ 4,067.50



Exl Vacation Payout- Term Date 10/15/2021


11/16/2021


B-5610


United Way

General Fund 2147.0


$ 33.85


$ 33.85


2907


10/25-11/7/20212 pay period-United Way


11/17/2021


4569


Ecointeractive

General Fund 5610.2


$ 3,978.00


$ 3,978.00


C4569


TIP SAAS Service-monthly fee NOV


11/17/2021


B-5628


INPRS

General Fund 2149.0


$ 14 284.01


$ 284.01


C5628


Exl vacation payout w/PERF-EmpPerf [NIRPC]


11/17/2021


B-5607


INPRS

General Fund 21490


$ 6,428.90


$ 6,428.90


C5607


10/25-11/7/2021 pay period- EmpPerf [NIRPC]


11/17/2021


4560


Kiel, Justin

General Fund 5410.1


$ 667.19


$ 667.19


C4560


Flight/Lyft/Hotel/Uber/Per Diem/Parking-NARC Board of Directors Meeting in Galveston


11/17/2021


4556


Kiel, Justin

General Fund 5410.1


$ 60.06


$ 60.06


C4556


Mileage-RT LaCrosse to Midway Airport-NARC- RT


11/17/2021


4550


Warner, Ty

General Fund 5410.1


$ 44.80


$ 44.80


C4550


Mileage- NIRPC to Chicago RT Link Dinner: Atlanta


11/17/2021


4551


Warner, Ty

General Fund 5410.1


$ 52.01


$ 52.01


C4551

Parking Link Dinner w/Atlanta Regional

Commissioner/Tolls RT Chicago/Breakfast Meeting w. NIRPC Chair


11/22/2021


4566


City of LaPorte

General Fund 5760.0


$ 59,791.00


$ 59,791.00


C4566


LaPorte Reimb for OA IN-2019-030 Draw 44--21


11/22/2021


4565


East Chicago Transit

General Fund 5760.0


$ 39,703.00


$ 39,703.00


C4565


ECT Reimb for PM IN-2018 -026 Draw 43-21


11/22/2021


4564


East Chicago Transit

General Fund 5760.0


$ 10,500.00


$ 10,500.00


C4564


ECT Reimb for OA IN-2019-030 Draw 40-21


11/26/2021


4579


City of Valparaiso

General Fund 5760.0


$ 49,186.00


$ 49,186.00


C4579


Valpo Reimb for CCC V-Line July-Sept 2021


11/26/2021


4577


City of Valparaiso

General Fund 5760.0


$ 45,934.00


$ 45,934.00


C4577


Valpo Reimb for Shuttle July-Sept 2021


11/26/2021


4591


East Chicago Transit

General Fund 5760.0


$ 14,593.00


$ 14,593.00


C4591


ECT Reimb for OA


11/26/2021


4592


East Chicago Transit

General Fund 5760.0


$ 46,433.00


$ 46,433.00


C4592


ECT Reimb for Paratransit July-Sept 2021


11/26/2021


4573

Lake County Community Services, Inc

General Fund 5760.0


$ 34,625.00


$ 34,625.00


C4573


LCCS Reimb for EM OA


11/26/2021


4578

Lake County Community Services, Inc

General Fund 5760.0


$ 45,469.00


$ 45,469.00


C4578


LCCS Reimb for EM OA July- Sept 2021


11/26/2021


4586

Lake County Community Services, Inc

General Fund 5760.0


$ 9,772.00


$ 9,772.00


C4586


LCCS Reimb for EMOA July-Sept 2021


11/26/2021


4584

Lake County Community Services, Inc

General Fund 5760.0


$ 22,949.00


$ 22,949.00


C4584


LCCS Reimb for PM July-Sept 2021


11/26/2021


4590


North Township

General Fund 5760.0


$ 35,443.00


$ 35,443.00


C4590


NT Reimb for OA July-Sept 2021


11/26/2021


4589


North Township

General Fund 5760.0


$ 1,541.00


$ 1,541.00


C4589


NT Reimb for OA Jan-March 2020


11/26/2021


4588


North Township

General Fund 5760.0


$ 15,094.00


$ 15,094.00


C4588


NT Reimb for OA Jul-Sept 2020


11/26/2021


4587


North Township

General Fund 5760.0


$ 39,632.00


$ 39,632.00


C4587


NT Reimb for OA April-June 2021


11/26/2021


4574


North Township

General Fund 5760.0


$ 13,201.00


$ 13,201.00


C4574


NT Reimb for PM July-Sept 2021


11/26/2021


4576


North Township

General Fund 5760.0


$ 8,589.00


$ 8,589.00


C4576


NT Reimb for PM Jan-March 2020


11/26/2021


4575


North Township

General Fund 5760.0


$ 6,106.00


$ 6,106.00


C4575


NT Reimb for PM April -June 2021


11/26/2021


4583


Opportunity Enterprises

General Fund 5760.0


$ 21,295.00


$ 21,295.00


C4583


OE Reimb for PM July-Sept 2021


11/26/2021


4582

Porter County Aging and Community Services

General Fund 5760.0


$ 31,039.00


$ 31,039.00


C4582


PCACS Reimb for EMOA July-Sept 2021


11/26/2021


4581

Porter County Aging and Community Services

General Fund 5760.0


$ 2,384.00


$ 2,384.00


C4581


PCACS Reimb for OA July-Sept 2021


11/30/2021


4597


City of Portage

General Fund 5224.9


$ 1,876.79


$ 1,876.79


2908


Sewer/Water/Gas/Electric-NOV


11/30/2021


4547


ESRI


General Fund


$ 4,200.00


$ 4,200.00


2909


Software renewal for ArcGIS 2/1/2022- 1/31/23


11/30/2021


B-5646


Federal & Fica

General Fund 2140.0


$ 4,539.85


$ 4,539.85


C5646


11/8-11/21/2021 pay period- FWT, empfica, empficamed-Federal Tax Withholdings Payable


11/30/2021


B-5646


Federal & Fica

General Fund 2142.0


$ 7,789.14


$ 7,789.14


C5646


11/18-11/21/2021 pay period- FWT, empfica, empficamed-FICA Tax Withholdings Payable


11/30/2021


B-5649


Horizon Bank

General Fund 2150.0


$ 392.31


$ 392.31


C5649


11/8-11/21/2021 pay period- HSA


11/30/2021


4593


ICMA Retirement Fund-PR

General Fund 5145.9


$ 15 855.91


$ 855.91


C4593


ER paid for Ty Warner 11/8/2021-11/21/2021 p/r


11/30/2021


B-5650


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5650


11/8-11/21/2021 pay period - ICMA


11/30/2021



Payroll



$ 39,672.25


$ 39,672.25



Payroll period ending 11/30/2021


11/30/2021


3982


SME

General Fund 5610.5


$ 58,497.99


$ 58,497.99


2910

Hazardous/Inventory and Prioritization -

Hazardous/Site Assessment-Hazardous Sub/Site Clean Up Planning-Hazardous Sub


11/30/2021


B-5651


United Way

General Fund 2147.0


$ 33.85


$ 33.85


2911


11/8-11/21/2021 pay period- United Way





General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -




Total:

$ 934,596.54


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 $ 934,596.54

image


Dated this                           day of              , 2021.


image


image



16

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/17/2021


4505


RouteMatch

CARES Fund 5960.0


$ 1,062.00


$ 1,062.00


C4505


LCCS RouteMatch Year 1-2021 DEC


11/17/2021


4506


RouteMatch

CARES Fund 5960.0


$ 472.00


$ 472.00


C4506


NT RouteMatch Year 1- 2021 DEC


11/19/2021


4557


City of Valpo

CARES Fund 5760.0


$ 215.00


$ 215.00


C4557


Valpo Reimb for CCC JUL-SEPT V-Line 1 or 3


11/19/2021


4559


City of Valpo

CARES Fund 5760.0


$ 17,804.00


$ 17,804.00


C4559


Valpo Reimb for CCC JUL-SEPT V-Line 3or 3


11/19/2021


4554


City of Valpo

CARES Fund 5760.0


$ 108,425.00


$ 108,425.00


C4554


Valpo Reimb for CCC JUL_SEPT DASH


11/19/2021


4558


City of Valpo

CARES Fund 5760.0


$ 5,830.00


$ 5,830.00


C4558


Valp Reimb for CCC JUL-SEPT V-Line 2 of 3


11/19/2021


4563


North Township

CARES Fund 5760.0


$ 5,162.00


$ 5,162.00


C4563


NT Reimb for PM APRIL-JUN 2021


11/19/2021


4562


North Township

CARES Fund 5760.0


$ 11,057.00


$ 11,057.00


C4562


NT Reimb for PM JULY-SEPT 2020


11/19/2021


4561


North Township

CARES Fund 5760.0


$ 94,030.00


$ 94,030.00


C4561


NT Reimb for OA JULY-SEPT 2020





CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -



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


Total:

$ 244,057.00



Allowance of Claims


We have examined the claims listed on the foregoing CARES Register of Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amoun $ 244,057.00

image


Dated this                           day of                            , 2022.


image

Chairperson


image

Treasurer


17

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/17/2021


4570


Divine Strategy LLC

CARES Fund 1950.0


$ 50,000.00


$ 50,000.00


10000

Divine Strategy dba J's Breakfast Club- Working Capital Loan Disbursement 50% loan


11/17/2021


4552


Regional Development Co.

CARES Fund 1950.0


$ 658.75


$ 658.75


10001

Underwriting Services for J's Breakfast Club 9/22/21





RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -







RLF Fund



$ -



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


Total:

$ 50,658.75



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 $ 50,658.75

image


Dated this                           day of              , 2022.


image

Chairperson



image

Treasurer



image

RESOLUTION 22-01

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org


A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ADOPTING THE YEAR 2022 APPROPRIATION BUDGETS FOR THE COMMISSION’S GOVERNMENTAL FUNDS

WHEREAS, a budget is required for governmental funds; and


WHEREAS, it is anticipated that sufficient revenues and other financing sources will be available to support the budgets herein proposed; and


WHEREAS, it is the responsibility of the Commission, as a whole, to approve the appropriations budget of the Commission;


NOW THEREFORE BE IT RESOLVED, that the Commission adopt as its Year 2022 budget for the General Fund for the budget identified in Attachment A to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Transit Capital Projects Funds the budget identified in Attachment B to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Transit Operating Projects Funds the budget identified in Attachment C to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Revolving Loan Funds the budget identified in Attachment D to this resolution; and


BE IT FURTHER RESOLVED, that the Finance and Personnel Committee of the Commission be designated to oversee the administration of these budgets within the framework of more detailed budget guidelines it might establish.


Duly adopted by the Northwestern Indiana Regional Planning Commission this 20th day of January 2022.


image


Chairperson


ATTEST:


image


Secretary


2022 BUDGET

12/15/2021

FY 2022 BUDGET

ATTACHMENT A


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 GENERAL FUND APPROPRIATIONS BUDGET


image


PERSONNEL - SALARIES

1,590,648


PERSONNEL - FRINGE BENEFITS

637,853


OCCUPANCY

292,398


EQUIPMENT SERVICE/MAINTENANCE

82,636


DEPARTMENTAL

403,483


CONTRACTUAL

1,931,718


CAPITAL OUTLAYS - Equipment & Furniture 180,000


TOTAL FUND BUDGET

5,118,736


ATTACHMENT B


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET


image


CAPITAL OUTLAYS - TRANSIT EQUIPMENT 3,578,506

CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT 501,999


TOTAL FUND BUDGET

4,080,505


ATTACHMENT C


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES 4,438,881

OTHER SERVICES AND CHARGES- CARES ACT 2020 -


TOTAL FUND BUDGET

4,438,881


ATTACHMENT D


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES 200,000


TOTAL FUND BUDGET

200,000


2022 CARES ACT 2020 REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES

461,648


.

TOTAL FUND BUDGET

461,648


TOTAL BUDGET OF

14,299,770


Attachment A


NIRPC FY 2022 Budget




FY 2021 Budget


FY 2022 Budget Change %

REVENUES



COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

1,994,419

1,748,928

STATE AGENCIES

2,504,813

2,668,379

LOCAL AGENCIES

37,050

76,760

NON-GOVERNMENTAL

52,338

46,513

INTEREST INCOME

                                       37,885

                                    37,885

TOTAL REVENUES

5,166,775

5,118,736 -1%


EXPENDITURES

SALARY

FRINGE BENEFITS

FICA CONTRIBUTIONS

WORKERS COMPENSATION

UNEMPLOYMENT COMPENSATION

PERF CONTRIBUTIONS

HEALTH INSURANCE

LIFE & DISABILITY INSURANCE

ICMA CONTRIBUTIONS

STAFF DEVELOPMENT

1,565,254

1,590,648

CONTRACTUAL

LEGAL SERVICES

AUDIT & ACCOUNTING

LA PORTE RLF SERVICES

TRANSIT OVERSIGHT

ENVIRONMENTAL CONTRACTS

PLANNING

BOARD DEVELOPMENT

ECONOMIC DEVEL DISTRICT RLF-CARES ACT

ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT

ORGANIZATIONAL DEVELOPMENT

E-TIP

22,200

23,400


38,000

70,000


2,000

2,000


17,347

17,347


837,300

837,314


320,000

320,000


2,000

2,000


550,000

461,648


136,000

101,000


2,000

2,000


                                       51,500

                                    95,009


1,978,347

1,931,718

-2%

180,000

180,000

0%

                                 5,166,774

                               5,118,736

-1%

                                                0

                                              0


FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

2%


119,742

121,685


9,500

5,000


3,000

3,000


200,012

199,688


230,000

240,000


24,000

24,000


23,000

24,480


                                       20,000

                                    20,000


629,254

637,853

1%


OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

231,000

236,708


6,500

6,500


18,540

18,540


                                       30,650

                                    30,650


286,690

292,398

2%

EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

20,370

18,000


43,736

43,736


18,900

18,900


                                         2,000

                                      2,000


85,006

82,636

-3%


DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

ECONOMIC DEVELOPMENT DISTRICT

GENERAL USE SUPPLIES

41,500

35,000


299,000

239,000


25,000

25,000


25,255

28,947


1,000

1,000


28,000

25,000


3,700

14,953


11,768

29,583


                                         7,000

                                      5,000


442,223

403,483

-10%

Attachment A page 2

NIRPC FY 2022 Revenue Detail


347,204

115,040

                  78,027

540,271


357,000

141,700

142,176

225,502

852,545

                  30,005

1,748,928


500,000

150,000

1,408,810

86,679

95,009

31,119

216,762

                  180,000  

2,668,379


1,800

15,300

16,000

750

                  42,910

76,760


42,676

1,837

                    2,000

46,513


COUNTY APPROPRIATIONS

LAKE COUNTY

PORTER COUNTY

LA PORTE COUNTY

TOTAL

FEDERAL AGENCIES

FTA OVERSIGHT

FTA CAPITAL

USDA FOREST SVC

BROWNFIELD GRANT

EDD

CAWS GLC

TOTAL

STATE AGENCIES

INDOT PL 2020

INDOT PL 2021

INDOT PL 2022

INDOT PL 2023

STBG

CMAQ 2020

CMAQ 2022

CMAQ 2023

TOTAL

LOCAL AGENCIES

CITY of PORTAGE

KRBC

PARTNERS for CLEAN AIR

FORUM

ONE REGION ONE TRAIL

TOTAL

NON-GOVERNMENTAL

CALUMET LAND CONSERVATION PARTN.

ROOM RENTAL INCOME

SHARED ETHICS ADVISORY COMMISSION

TOTAL

INTEREST INCOME

BANK INTEREST INCOME

RLF INTEREST INCOME

TOTAL FY 2022 REVENUE

3,000

34,885

             5,118,736

Attachment B

NIRPC FY 2022 Budget


image

35,000

31,353

3,500

55,000

24,000

345,000

220,000

792,500

-

100,000

79,809

275,000

4,500

3,500

6,500

619,965

-

60,000

3,399

150,000

125,000

82,000

140,000

130,000

Grant Federal Req. Match Total

image


Architectual Services

Ticket Kiosks and On-Board fare boxes

Security Cameras

Vehicles (2)

Security Camera & Lighting

TOD Ground Improvements

Support Vehicle

Computers/Sound System

Support Equipment

Support Vehicle

Rehab/Renovate - Admin Facility

Replace 3 Revenue Vehicles

Replace 2 Revenue Vehicles

Replace 1 Communter Vehicle

Replace 2 Revenue Vehicles

Replace Staff Computers

Replace 4 Communter Vehicle

Associated Transit Improv

Tablets and Vehicle Devices

Office Computer Equipment

Office Computer Equipment

Replace ChicaGO Dash

Replace 2 Vehicle

Replace 1 Vehicle

Computers

Replace Bus Stop Signs

Transit Improvements

Buy Replacement

Buy Replacement

Buy Replacement

X012


X012


X667

16,320

X667

110,500

2016-033


2016-033


2016-033

28,000

2016-033

25,082

2016-033

2,800

2017-028

44,000

2017-028

19,200

2018-026

276,000

2018-026

176,000

2018-026

637,500

2019-029

-

2019-029

80,000

2019-029

59,857

2019-029

220,000

2019-029

3,600

2019-029

2,800

2019-029

5,200

2019-029

495,966

2019-030


2019-030

48,000

2019-030

2,700

2019-030

120,000

2019-030

100,000

2020-054

65,600

2020-054

112,000

2020-054

104,000

-

-

4,080

19,500

-

-

7,000

6,271

700

11,000

4,800

69,000

44,000

155,000

-

20,000

19,952

55,000

900

700

1,300

123,999

20,400

130,000


image image image

12,000

699

30,000

25,000

16,400

28,000

26,000

TOTAL         2,755,125             681,301                  3,436,426  


Contingency -


image

TOTAL BUDGET                  3,436,426  


image


**

new projects for 2021 not included

**

no grant written for 2021

Attachment B


CY 2021 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Letting

Date

Total

Non-Federal

Funds

Federal Funds

NT

2020-039

Replace 2 Revenue Vehicles


$ 142,080

$ 23,680

$ 118,400















TOTAL BUDGET

$           142,080

$           118,400

Attachment B


CY 2021 CARES ACT 2020 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Total

Federal Funds

OE

CARES Act 2020-014

Bus Rolling Stock (3)

$ 202,008

$ 202,008

Valpo

CARES Act 2020-014

Parking lot repair

$ 3,957

$ 3,957

ECT

CARES Act 2020-014

Support Vehicle (2)

$ 8,594

$ 8,594

NT

CARES Act 2020-014

Misc Support Equipment

$ 41,485

$ 41,485

OE

CARES Act 2020-014

Misc Support Equipment

$ 9,544

$ 9,544

PC

CARES Act 2020-014

Misc Support Equipment

$ 36,502

$ 36,502

Valpo

CARES Act 2020-014

Misc Support Equipment

$ 1,897

$ 1,897

ECT

CARES Act 2020-014

Misc Support Equipment

$ 39,421

$ 39,421

City of LaPorte

CARES Act 2020-014

Bus Replacements (2)

$ 143,200

$ 143,200

City of LaPorte

CARES Act 2020-014

Misc Support Equipment

$ 15,391

$ 15,391





















TOTAL BUDGET

$               501,999

$           501,999

Attachment C

CY 2022 TRANSIT OPERATING PROJECTS FUND


image

Federal Req. Match Total

image


City of East Chicago


Preventative Maintenance

287,064

Complementary Paratransit

368,794

Operating Assistance

186,437

Existing Grants

423,388

57,787

92,198

186,437

423,388

344,851

460,992

372,874

846,776


City of LaPorte


Operating Assistance

259,890

Existing Grants


259,890 519,780


City of Valparaiso


Capital Cost of Contracting

1,055,330

263,888 1,319,218


North Township


Preventative Maintenance

28,000

Operating Assistance

190,000

Existing Grants

116,282

7,000

190,000

116,282

35,000

380,000

232,564


Opportunity Enterprises


Preventative Maintenance

102,000

Existing Grants

77,615

20,400

15,523

122,400

93,138


Porter County Community Services


Preventative Maintenance


Operating Assistance

75,000

Existing Grants

335,850

-

75,000

154,000

-

150,000

489,850


Southlake Community Services


Preventative Maintenance

101,102

Operating Assistance

194,960

Existing Grants

114,488

20,220

194,960

89,000

121,322

389,920

203,488


PMTF Funds (NT,SLCS,PCCS, OE & CV)


Public Mass Transportation Fund

522,681

-

522,681


TOTAL

             4,438,881              2,165,973               6,604,854

Attachment D



CY 2021 LAPORTE COUNTY REVOLVING LOAN FUND


2021 2022

Budget Budget


New Loans


85,000


200,000


TOTAL

85,000

image


200,000

image







TOTAL BUDGET



200,000


image



Attachment D

LaPorte RLF 2022 Administration Budget


Per RLF Management Plan 50% of interest can be used for Administrative Cost

REVENUES

RLF INTEREST INCOME 7,800

CLOSING CHARGES                      2,000  

TOTAL REVENUES 9,800


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

2,500

2,025

                                       2,400  

6,925


DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES

365

                                        510

CONTRACTUAL

LA PORTE RLF SERVICES

875


                                       2,000  

2,000


TOTAL EXPENSES 9,800


FUND BALANCE - ENDING                                           -    


Attachment D

CARES ACT RLF 2022 Administration Budget


Per RLF Management Plan 50% of interest can be used for Administrative Cost


REVENUES


EDD CARES ACT 2020

461,648

RLF INTEREST INCOME

25,085

CLOSING CHARGES                                         

7,000  

TOTAL REVENUES

493,733


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

11,900

7,854

                                       9,163  

28,917


DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES- AF Loan

368

                                     2,800

CONTRACTUAL

LA PORTE RLF SERVICES

3,168


                                   461,648  

461,648


TOTAL EXPENSES 493,733


FUND BALANCE - ENDING                                           -    

EMPLOYMENT AGREEMENT


BY AGREEMENT ENTERED INTO the 20th day of January 2022, by and between the NORTHWESTER:\! INDIANA REGIO AL PLA I G COMMISSION, hereinafter referred to as "NIRPC", and MR. TYSON WARNER, hereinafter referred to as "Executive Director", the following is hereby agreed to:


WHEREAS, IRPC is desirous of securing the services of an Executive Director to assist in implementation of its statutory role and function including that of a metropolitan planning organization for Northwest lndi.ma; and


WHEREAS, Tyscn Warner has served as the Executive Director of TRPC since January I, 2013, and the parties to thi agreement are desirous of renewing and otherwise extending his serving as the Executive Director ofNIRPC.


NOW, THEREFORE, BE TT RESOLVED that the parties to this agreement hereby do mutually agree as follows:


  1. The term of this agreement shall commence on January l, 2022, and shall terminate as of December 31, 2024 unless otherwise terminated pursuant to the provisions of this agreement.

  2. Mr. Tyson Warner shall pe1form the function and serve in the role of the Executive Director of NIKPC during the term of this agreement. In addition to those matters which may from time to time be assigned to him by NIRPC, Mr. Warner's role and responsibility as Executive Direct(>r for NIRPC are more particularly described and identified in the Job Description attachf:d hereto and made a part hereof as Exhibit "A" to this agreement.

  3. The Executive Director shall meet with the Chairman of the NIRPC Commission following the Chainnan's appointment in 2022 2023 and 2024, for purposes of establishing goals for each of the years of this Employment Agreement. The Executive Director and Chairman, togeth r with other NlRPC appointed officers as may desire, shall meet mid-year and near end-of year to discuss progress, provide feedback on performance, and to make such other adjustrnent and course correction to goals as may be necessary or beneficial.

  4. During the first year of this agreement, NlRPC agrees to pay to its Executive Director the stun of One Hundred Sixty-Four Thousand Five Hundred Fifty Dollars ($164,500.00) to be paid in the same manner and fashion as payments are made to other IRPC employees during the course of the calendar year. The Executive Director salary for the second year and third years c·if this agreement shall be determined through discussions with the Executive Director and ar.y salary increases shall be predicated upon positiv performance evaluations, the availability of funding and the approval of the Full lRPC Commission. Additionally, the followi.ng benefits of employment shall be available to the Executive Director:

    l. . Insurance: The same health insurance and benefit programs provided to NIRPC employees shall be available to the Executive Director.

    1. : Vehicle: The Executive Director will be reimbursed for mileage at the applicable IRS rate for use of his personal vehicle in conducting JR.PC business. The

      · Executive Director may have use of a NIRPC owned or NIRPC leased vehicle as

      . may be authorized by the Chairman of the Full NIRPC Commission.

    2. Professional Memberships: NIRPC will maintain membership for its Executive Director in ICMA, APA and the Congress of New Urbanism and their respective state chapters and will either pay for, or reimburse, the Executive Director for pa11icipation in these organizations annual conferences.

    3. Retirement Benefit: The Executive Director will participate in ICMA-RC 457 Plan. NIRPC will contribute to that plan in the same amount as would have been paid on the Executive Director's behalf to PERF.

    4. NARC Participation: NIRPC shall pay for or reimburse the Executive Director to participate in events and activities of the National Association of Regional Councils (NARC) on behalf of NIRPC.

    5. Vacation: The Executive Director shall be entitled to four (4) weeks of paid vacation

      · during each calendar year of employment under this agreement. While vacation is intended to be used throughout the course of year, vacation shall be allowed to accrue within the same limits allowed to other NIRPC employees as long as the Executive Director is employed by NJRPC. Should any accrued vacation remain upon termination of this agreement, the Executive Director shall be paid in accordance with Section E below.

    6. Expense Reimbursement: The Executive Director shall be entitled to reimbursement for business related expenses pursuant to the guidelines and procedures established by NIRPC. In addition thereto, the Executive Director shall be paid the sum of

    $150.00 per month as reimbursement for his job related use of communication technology. This reimbursement shall not preclude the use of data connected equipment as may be issued and paid for by NIRPC.


  5. This agreement may be terminated upon the agreement of the parties or upon a showing of just ca11se:

    1. In the event the Executive Director is terminated pursuant to this Agreement, NIRPC agrees to pay the Executive Director a severance payment equal to twelve (12) weeks base salary, plus accrued and unused vacation days; provided, however, that in the event the Executive Director is terminated because of his conviction of any illegal act, then in that event, NIRPC shall have no obligation to pay the severance pay sum designated in this paragraph.

    2. In the event the Executive Director voluntarily resigns his position with NIRPC, he shall give NIRPC at least sixty (60) day notice of such resignation prior to the cessation of the performance of his duties hereunder unless otherwise agreed to by TRPC. If the Executive Director resigns, he shall not be paid the severance pay above but shall receive accrued and unused vacation days; provided, however, the

      Executive Director shall be paid his base sala1y during said 60 day notice period.


  6. This agreement shall be deemed as superseding and replacing the terms and conditions of the prior employment agreements entered into by NIRPC and the Executive Director.


  7. For tlK purpose of interpreting the terms and conditions of this agreement, the laws of the State of Indiana shall apply.


ALL OF WHTCH HA YING BEEN AGREED to by these parties and memorialized by the signatures affixed hereto:


NORTHWESTERN INDIANA REGIONAL PLANNTNG COMMISSION


By:                                                           _ Chairperson


ATTEST:


image image

image

Tyson Warner

Exhibit A

Job Description



Job Title: Executive Director


Agency: Northwestern Indiana Regional Planning Commission


Reports to: orthwestern Indiana Regional Planning Commission


The Executive Dir1:,ctor is the Chief Administrative Officer and regular Technical dvisor of the Commission. The s-1bject of the supervision by the Commission and in furtherance of the purpose of the Commission, the Executive Director role and responsibilities are that which are identified in IC 36-7-7.6-1l(Executive Director; Powers and Duties). All of which is intended to facilitate fulfillment of NIRPC's overall purpose as defined in IC 36-7-7.6-12.