FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda –

Thursday, October 20, 2022 -- 8:00 a.m.

Dune Room – NIRPC Office


  1. Call to Order & Pledge of Allegiance


    6100 Southport Road

    Portage, Indiana 46368

    (219) 763-6060

    www.nirpc.org


  2. Meeting Minutes of September 15, 2022 Pages 1 – 2

    ACTION REQUESTED: Approval


  3. Review of Financial Status – September 2022 Budget vs Actual Pages 3 - 14

    1. Bank Statement Reconciliations (pg. 3-9)

    2. General Fund Expenses YTD September 2022 (pg. 10-11)

    3. General Fund Revenue YTD September 2022 (pg. 12)

    4. CARES Expenses YTD September 2022 (pg. 13)

    5. CARES Revenue YTD September 2022 (pg. 14)


  4. Approval of General Fund Claims Register – September 2022 Pages 15 - 18

    ACTION REQUESTED: Approval


  5. Approval of CARES Act Claims Register – September 2022 Pages 19

    ACTION REQUESTED: Approval


  6. NIRPC 2022 Budget Amendment #1 Pages 20

    ACTION REQUESTED: Approval


  7. Eco-Interactive Contract Addendum III Pages 21

    ACTION REQUESTED: Recommendation for Approval


  8. NIRPC 2023 Preliminary Budget


  9. Personnel update


  10. Other Business


  11. Adjournment


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

Pages 22 - 32


The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program. Users may access the Relay Indiana Service by calling 711 or 1-800-743-3333. Requests for alternative formats may be made 72 hours in advance by contacting [email protected].

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

September 15, 2022 / NIRPC Dune Room – 8:00 a.m.

Members present in-person

Bob Carnahan, Don Craft, Tom Dermody, Denise Ebert, Justin Kiel, Wendy Mis, George Topoll

Staff and others present in-person

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

Call to Order

Chairperson Dermody called the meeting to order with the Pledge of Allegiance.

Approval of Minutes

The minutes of the July 21, 2022 meeting were presented. On motion by Bob Carnahan, second by George Topoll and no opposition, the minutes were approved.

Review of Financial Status – July 2022 Budget vs Actual

Talaya Jones presented the July 2022 bank reconciliations for the NIRPC general account, the CARES Revolving Loan Fund account, and the Revolving Loan Fund Account.

Talaya presented the July 2022 general fund financial reports. Total expenditures for the period ending July 31, 2022, were $3,710,453 of the $9,201,349 budgeted. Total general fund revenue for the period was $1,014,182 of the $4,311,106 budgeted.

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

$304,737 of the $1,153,515 budgeted. Total CARES revenue collected for the period was $294,970 of the $1,352,229 budgeted.

Approval of Claims Registers – July 2022

Talaya presented the July 2022 General Fund claims register totaling $441,021.35 to the Committee for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the General Fund register claims in the amount of $441,021.35 was approved. The CARES Act register of claims totaling

$30,396.79 was presented for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the CARES Act register of claims in the amount of $30,396.79 was approved. The CARES RLF register of claims totaling $50,000.00 was presented for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the CARES RLF register of claims in the amount of

$50,000.00 was approved. The RLF register of claims totaling $70,284.75 was presented for approval. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the RLF register of claims in the amount of $70,284.75 was approved.

Review of Financial Status – August 2022 Budget vs Actual

Talaya presented the August 2022 bank reconciliations for the NIRPC general account, the CARES Revolving Loan Fund account, and the Revolving Loan Fund Account.

Talaya presented the August 2022 general fund financial reports. Total expenditures for the period ending August 31, 2022, were $4,241,777 of the $9,201,349 budgeted. Total general fund revenue for the period was $1,154,868 of the $4,311,106 budgeted.

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

$313,816 of the $1,153,515 budgeted. Total CARES revenue collected for the period was $325,733 of the $1,352,229 budgeted.

Approval of Claims Registers – August 2022

Talaya presented the August 2022 General Fund claims register totaling $544,972.29 to the Committee for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the General Fund register of claims in the amount of $544,972.29 was approved. The CARES Act register of claims totaling $7,953.57 was presented for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the CARES Act Register of claims in the amount of $7,953.57 was approved. The RLF

register of claims totaling $25.48 was presented for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the RLF Register claims in the amount of $25.48 was approved.

December 2021 Financials

Talaya presented the January - December 2021 general fund financial reports. Total expenditures were

$4,810,681 of the $11,981,765 budgeted. Total general fund revenue for the period was $3,046,474 of the $3,574,659 budgeted.

Talaya presented the January – December 2021 Coronavirus Aid, Relief and Economic Securities (CARES) Act financial reports. Total NIRPC CARES fund expenditures were $2,882,332 of the

$4,717,013 budgeted. Total CARES revenue collected for the period was $3,162,330 of the

$4,307,009 budgeted.

NIRPC Resolution 22-18 – Approval of a Comprehensive Conflict of Interest Policy

Lisa Todd presented Resolution 22-18 for approval of a comprehensive conflict of interest policy. NIRPC was awarded a grant from the United States Department of Transportation under the Rebuilding American Infrastructure with Sustainability and Equity (RAISE) program for several major portions of the Marquette Greenway Trail. The Trail extends from Chicago, Illinois to New Buffalo, Michigan, through many scenic parts of Northwest Indiana. NIRPC needs to put out several RFQs and RFPs for professional services, and the hired firms must follow a code of ethics and disclose if there is or will be any conflict of interest. As the direct recipient of the grant funds, NIRPC needs to adopt a conflict-of-interest policy.

INDOT already has a policy which NIRPC would like to copy and adopt. Attorney Hollenbeck as already reviewed the policy and given his blessing. On motion by George Topoll and Second by Bob Carnahan and no opposition, the Committee approved Resolution 22-18 to adopt the comprehensive conflict of interest policy.

SME Contract Amendment 1

Kathy Luther presented SME contract Amendment 1. NIRPC entered into an agreement on March 19, 2020 with SME to provide technical and professional environmental services under a Brownfield Coalition Assessment Grant. Since SME is already conducting assessment work, the Coalition and the City of Hammond would like to utilize them to assess a parcel which is not eligible for use of federal grant funds. NIRPC has entered into an MOU with Hammond and is adding funds to pay the contractor, for which Hammond will reimburse NIRPC. The new task shall not exceed $21,925, unless all parties agree in writing on an additional scope of work and cost up to $60K. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the Committee approved SME contract amendment 1 to be forwarded with a favorable recommendation to the NIRPC Board for approval.

Personnel updates

NIRPC now has 4 open positions. In addition to the already open positions, Ty announced that NIRPC’s Regional Planner/Spatial Analyst (GIS mapping), Peter Kimball, has left NIRPC. Ty held an exit interview with Peter and indicated he had nothing bad to say about NIRPC and is going to the Grand Rapids MPO where he will be paid more. NIRPC’s Accountant, Stephanie Kuziela will be leaving in December.

Stephanie stated she has an opportunity to take over a tax business and will be a business owner. Mayor Dermody stated that Cities and Councils are also struggling to keep people. Ty noted that a couple of the current openings meshed more than one position and possibly weren’t the best mashups. Discussion followed regarding the need for an increase in local share which could work toward raises and new positions. All of the local share is used every year and while there are more federal funds to be tapped, there is not enough local share for match. Previously Michael Griffin drafted legislature asking to right size the local share based on current value and add with increases based on the consumer price index so NIRPC would not have to keep coming back. NIRPC’s Chair, Justin Kiel, has taken up the cause. Bob Carnahan stated Cedar Lake is hiring within for their Planning Director position.

Other Business None

Adjournment

There being no further business, the meeting was adjourned.


STK 10/7/22


10-13-2022

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

8/31/2022

949,948.55

28

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


1,543,898.94

128

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


1,163,927.47

1

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


25.48

0

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


0.00


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

9/09/2022

120.25


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

9/30/2022

62.91

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

9/30/2022

1,329,888.16

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


0.00

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

9/30/2022

1,284,035.45

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


(45,852.71)

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


0.00

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


1,329,888.16

Date

Reference

Deposit Description

Amount

9/02/2022

8272900

PMTF April-June 2022

111,608.00

9/07/2022

8272901

Portage EDC August Sublet

150.00

9/09/2022

8272902

NIRPC CARES DeLage April-June 2022

619.00

9/09/2022

8272903

CARES REIMB AF Sept-Dec 2022

1,361.00

9/09/2022

8272904

Draw 52-22 Valpo Operating Assistance CMAQ Apr-Jun 2022 IN-2019-029

52,339.00

9/09/2022

8272905

Draw 53-22 Valpo CCC-VLine Apr-Jun 2022 IN-2019-030

64,081.00

9/09/2022

8272906

Draw 54-22 Valpo CCC- DASH Apr-Jun 2022 IN-2017-027

54,632.00

9/09/2022

8272907

Draw 55-22 PCACS Preventative Maintenance Apr-Jun 2022 IN-2018-026

5,806.00

9/09/2022

8272908

Draw 56-22 PCACS Operating Assistance Apr-Jun 2022 IN-2019-030

2,576.00

9/09/2022


9/09/2022

8272909


8272910

Draw 57-22 PCACS Enhanced Mobility Operating Assistance Apr-Jun 2022 IN-2019- 030

Draw 58-22 Laporte Operating Assistance Apr-Jun 2022 IN-2020-039

32,044.00


42,224.00

9/09/2022

8272912

Draw 61-22 LCCS Preventative Maintenance Apr-Jun 2022 IN-2020-039

15,495.00

9/09/2022

8272913

Draw 62-22 ECT Preventative Maintenance Apr-Jun 2022 IN-2019-030

51,331.00

9/09/2022

8272914

Draw 63-22 ECT Paratransit Apr-Jun 2022 IN-2020-039

57,691.00

9/09/2022

8272915

Draw 64-22 ECT Operating Assistance Apr-Jun 2022 IN-2020-039

37,808.00

9/09/2022

8272916

Draw 65-22 OE Preventative Maintenance Apr-Jun 2022 IN-2020-039

19,540.00

9/09/2022

8272917

NIRPC REIMB 2020 FTC AUDIT REIMB IN-2018-026

10,227.00

9/14/2022

8272911

Draw 60-22 LCCS Enhanced Mobility Operating Assistance Apr-Jun 2022 IN-2020-039

101,024.00

9/14/2022

8272918

4th Quarter 2022 PL Reimbursement

708,952.13

9/19/2022

8272924

FTA CARES REIMB ROUTEMATCH OCT 2022

1,534.00

9/20/2022

8272921

Hobart Trail Counter Local Share

723.00

9/20/2022

8272922

Highland Trail Counter Local Share

723.00

9/21/2022

8272919

LaPorte Trail Counter

723.00

9/22/2022

8272920

PCA Membership Fees

2,000.00

9/26/2022

8272923

FTA Reimb for Valpo TOD Lighting Project

91,657.00

9/29/2022

8272926

Merrillville Local Share 2 Trail Counters

1,446.00

9/29/2022

8272927

Portage Local Share 2 Trail Counters

1,446.00

9/30/2022

8272925

Brownfield Reimbursement Jan-Aug 2022

74,138.81



Total Deposits:

1,543,898.94

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 Northwest Indiana 8/5 - 8/18/2019 pay period - United Way

33.85

3/23/2021


4/07/2022

0002764


0002975

American of Metropolitan Planning NIRPC-Job Posting Director of Transportaion Organization

City of Portage, The Lease-APR

50.00


19,725.67

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/07/2022 @ 10:54 AM

Reconciliation - General

Page: 1


Date

Check To Check Description

Amount

7/21/2022

0003046 Quill Corporation Logitech wireless mouse/toilet paper/8.5x11

160.14


9/07/2022

paper,canary, coupon

0003072 Vantage Point Consulting Inc Invoices 4996, 5070


5,625.00

9/14/2022

0003075 BRYCO SERVICES Office Cleaning-SEPT

1,425.00

9/29/2022

0003095 Accelerate Indiana Municipalities Invoices 5166, 92437

690.00

9/29/2022

0003096 BASIC Monthly Fee for COBRA Admin Annually

480.00


9/29/2022

9/1/22

0003097 Drive Clean Indiana, Inc Drive Clean IN 2022 Golf Outing Hole


750.00


9/29/2022

Sponsorship/Local-Federal Share

0003098 TIP Strategies, Inc. Pymt 8 of 8 Economic Resilency Plan-


16,850.37


9/29/2022

FINAL/Airfare/Ground Trans/Lodging/Meals

0003099 United Way of Northwest Indiana Pay period ending 9/11/2022,United Way


33.85


Total Unmarked Checks: 45,852.71 Total Checks:

45,852.71

Date

Reference Adjustment Description

Amount

9/01/2022

0000040 Correct ACH payment to D. Kane for mileage reimb s/b from RLF

25.48

9/09/2022

Service Charge

-120.25

9/30/2022

Interest Earned

62.91


Total Adjustments:

-31.86

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/07/2022 @ 10:54 AM

Reconciliation - General

Page: 2

Trial Balance - Cash

Run: 10/07/2022 at 10:5N7 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 9/30/2022


Page: 1



All Balance

1.1.001.0000.1010.0 General Cash  1,284,035.45

Total 1,284,035.45


STK 10/7/22

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/03/2022 @ 2:30 PM Reconciliation - Revolving Loan Fund Page: 1

STK 10/3/22


10/14/2022

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

8/31/2022

219,972.65

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


2,581.24

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


0.00

1 Adjustments Totaling..............................................................................................


-25.48

0 Voids Totaling........................................................................................................


0.00

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


0.00

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

9/30/2022

5.46

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

9/30/2022

222,533.87

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


0.00

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

9/30/2022

222,533.87

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


0.00

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


0.00

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


222,533.87


Date

Reference

Deposit Description

Amount

9/13/2022

8272889

Hammer RLF Sept Loan Payment

1,381.24

9/16/2022

8272890

September 2022 RLF Payment

1,200.00




Total Deposits:

2,581.24

Date

Reference

Adjustment Description

Amount

9/01/2022

0000040


-25.48

9/30/2022


Interest Earned

5.46




Total Adjustments:

-20.02

Trial Balance - Cash

Run: 10/06/2022 at 10:3N3 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 9/30/2022


Page: 1



All Balance

2.3.050.0000.1010.0 LaPorte Cash  222,533.87

Total 222,533.87


STK 10/6/22


2

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


1,311.48

0

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


0.00

0

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


0.00

0

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


0.00


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


0.00


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

9/30/2022

0.13

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

9/30/2022

8,408.28

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


0.00

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

9/30/2022

8,408.28

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


0.00

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


0.00

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


8,408.28


Date

Reference

Deposit Description


Amount

9/07/2022

8272868

Divine Strategy CARES RLF Payment


506.23

9/07/2022

8272869

Healthy Smiles CARES RLF Aug Payment


805.25





Total Deposits:

1,311.48

Date

Reference

Adjustment Description


Amount

9/30/2022


Interest Earned


0.13





Total Adjustments:

0.13

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/03/2022 @ 2:31 PM

STK 10/3/22

Reconciliation - CARES RLF Bank Account

Page: 1

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

10-13-2022

8/31/2022 7,096.67

Trial Balance - Cash

Run: 10/06/2022 at 10:3N8 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 9/30/2022


Page: 1



All Balance

4.3.050.0000.1010.0 CARES RLF Cash  8,408.28

Total 8,408.28


STK 10/6/22

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022



Line Items


FY 2022 Budget


YTD September FY 22 Budget % Expended balance


Salaries




5020-1

Total Salaries

1,530,748

987,195 36%


Salaries Sub-Total

1,530,748

987,195 36%


Fringe Benefits

5121-9

FICA Contributions

121,685

74,306

39%

5122-9

Workers Compensation

5,000

2,679

46%

5123-9

Unemployment Compensation

3,000

1,002

67%

5141-9

PERF Contributions

199,688

124,966

37%

5142-9

Health Insurance

240,000

141,611

41%

5143-9

Life & Disability Insurance

24,000

8,321

65%

5145-9

ICMA

24,480

16,818

31%

5146-9

Staff Development

20,000

4,185

79%


Fringe Benefits Sub-Total

637,853

373,889

41%


Occupancy

5221-9

Office Lease

236,708

177,531

25%

5222-9

Property Insurance

6,500

4,980

23%

5223-9

Building Maintenance

18,540

13,792

26%

5224-9

Utilities

30,650

3,456

89%


Occupancy Sub-Total

292,398

199,759

32%


Maintenance

5241-9

Copier Leasing/Maintenance

18,000

8,530

53%

5243-9

Computer Service/Maintenance

43,736

37,239

15%

5244-9

Telephone Service/Maintenance

18,900

8,619

54%


Combined Copier/IT/Phone Service/Maintenance

80,636

54,388

33%

5249-9

Other Equipment Maintenance

2,000

525

74%


Maintenance Sub-Total

82,636

54,913

34%

Departmental

5410-1

Communications: Commission/Ex. Dir.

35,000

11,861

66%

5410-2

Communications: Transportation

239,000

120,314

50%

5410-3

Economic Development District

29,583

212

99%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

28,947

5,078

82%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

25,000

22,556

10%

5420-5

Promotional Expenses: Environmental Programs

14,953

9,951

33%

5430-9

General Use Supplies Expense

5,000

3,115

38%


Departmental Sub-Total

403,483

173,086

57%


Contractual

5602-9

Legal Services

23,400

15,750

33%

5603-9

Audit and Accounting

70,000

9,347

87%

5604-9

LaPorte RLF Services

2,000

670

66%

5610-4

Transit Oversight

17,347

12,784

26%

5610-5

Environmental Projects

837,314

457,935

45%

5610-2

Planning

320,000

312,300

2%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

95,009

24,846

74%


Contractual Sub-Total

1,369,070

833,632

39%


Capital Outlays

5910-0

Furniture and Equipment

154,200

0 100%


Capital Outlays Sub-Total

154,200

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,470,388

2,622,474 41%


LaPorte Revolving Loan Fund

150,000

69,640


Transit Capital Fund

142,080

524,239


Transit Operating Fund

4,438,881

2,098,523


TOTAL EXPENDITURES

9,201,349

5,314,876






CARES FUND EXPENDITURES

YTD September 2022 Expenses Budget vs Actual

1,200,000

1,148,061

1,026,803

1,000,000

987,195

833,632

800,000


600,000

478,390

373,889

400,000

302,612

219,299

199,759

173,086

200,000

61,977 54,913

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD September Budget YTD September Expended

YTD September 2022 Expended by Category

Contractuals

32%

Salaries

38%

Departmental

6%

Fringe

Benefits 14%

Maintenance

2%

Occupancy

8%

Salaries

Fringe Benefits Occupancy Maintenance Departmental Contractuals

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022



Line Items


FY 2022 Budget

YTD September YTD Variance FY 22 Budget %

Collected (Under)/Over balance

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

540,271

0

0%

1.1.4210

Federal Agencies

896,383

269,429

626,954

70%

1.1.4310

State Agencies

2,668,379

1,085,062

1,583,317

59%

1.1.4410

Local Agencies

76,760

11,819

64,941

85%

1.1.4610

Non-Governmental

48,513

23,572

24,941

51%

1.3.4260

Economic Development District

70,000

36,013

33,987

49%

1.1.4800

Interest Income

10,800

4,613

6,187

57%


Revenue Total

4,311,106

1,970,779

2,340,327

54%


Revenue by Funding Source as of September 30, 2022

Local Agencies

State Agencies

55%

1%

Non-Governmental 1%

Interest Income

0%

Economic Development

District

2%

County Appropriations

27%

Federal Agencies

14%

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 SEPTEMBER 30, 2022



Line Items


FY 2022 Budget


YTD September Expended


FY 22 Budget % balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

59,900

28,762

52%

Salaries Sub-Total

59,900

28,762

52%


YTD September 2022 Expenses Budget vs Actual

120,000

104,634

100,000

101,000

80,000

59,900

60,000

40,000

28,762

25,800

15,711

20,000

3,168

999

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

Contractual

EDD Institutional CARES ACT

101,000

104,634

-4%

Contractual Sub-Total

101,000

104,634

-4%

Departmental




Communications

3,168

858

73%

PPE Supplies & Office Supplies


141

0%

Departmental Sub-Total

3,168

999

68%


Capital Outlays




Furniture and Equipment

25,800

15,711

39%

Capital Outlays Sub-Total

25,800

15,711

39%


TOTAL NIRPC CARES FUND EXPENDITURES

189,868

150,105

21%


CARES Revolving Loan Fund

461,648

100,709


CARES Transit Capital Fund

491,999

80,102


CARES Transit Agency Fund

10,000

10,000


TOTAL EXPENDITURES

1,153,515

340,916


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022



Line Items


FY 2022 Budget

YTD September

Collected


FY 22 Budget % balance

CARES ACT OPERATING




Operating Revenue

25,800

15,175

41%


EDD RLF Revenue

477,992

3,910

99%

CARES ACT RLF


Revenue by Funding Source as of September 30, 2022

CARES Operating

5%

CARES Transit Capital

24%

CARES Transit

Agency

3%

NWI Recover RLF (CARES

RLF)

18%

Economic Development

District 50%

CARES Operating

Economic Development District

NWI Recover RLF (CARES RLF)

CARES Transit Agency CARES Transit Capital

Economic Development District

304,553

165,952

46%


808,345

185,037

77%

CARES ACT EDA


CARES ACT RLF

Loan Proceeds

32,085

50,000

-56%

CARES ACT RLF

Loan Application Fees & Interest

9,800

3,852

61%

CARES AGENCY

FTA Revenue

10,000

10,000

0%

CARES TRANSIT CAPITAL

FTA Revenue

491,999

80,102

84%


Revenue Total

     1,352,229    

328,992      

76%    


NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


9/2/2022


5137


Anthem Life

General Fund 2155.0


$ 96.50


$ 96.50


C5137


EE for Life Insurance-SEPT


9/2/2022


5137


Anthem Life

General Fund 5143.9


$ 355.11


$ 355.11


C5137


ER for Life Insurance-SEPT


9/2/2022


5088


Dialpad

General Fund 5244.9


$ 656.00


$ 656.00


C5088


Telephone Service-Sept


9/6/2022


B-6328


HSA

General Fund 2150.0


$ 1,250.53


$ 1,250.53


C6328


Pay period ending 8/28/2022-HSA


9/6/2022


5115


MissionSquare Retirement

General Fund 5145.9


$ 934.36


$ 934.36


C5115


ER paid for Ty Warner 8/15/2022-8/28/2022


9/6/2022


B-6326


MissionSquare Retirement

General Fund 2146.0


$ 830.00


$ 830.00


C6326


Pay period ending 8/28/200-ICMA


9/6/2022



Payroll



$ 35,064.81


$ 35,064.81



Payroll


9/6/2022


5126

United HealthCare Srvcs, Inc.

General Fund 2152.0


$ 2,116.74


$ 2,116.74


C5126


EE paid for SEPT Health Insurance


9/6/2022


5126

United HealthCare Srvcs, Inc.

General Fund 5142.9


$ 11,994.85


$ 11,994.85


C5126


ER paid for SEPT Health Insurance


9/7/2022


B-6323


Federal & Fica

General Fund 2140.0


$ 4,784.85


$ 4,784.85


C6323

Pay period ending 8/28/2022, FWT, empfica,

empficamed, fica ficamed-Federal Tax Withholdings Payable


9/7/2022


B-6323


Federal & Fica

General Fund 2142.0


$ 7,052.88


$ 7,052.88


C6323

Pay period ending 8/28/2022, FWT, empfica,

empficamed, fica ficamed-FICA Tax Withholdings Payable


9/7/2022


5114


INPRS

General Fund 5141.9


$ 0.03


$ 0.03


C5114


8/15 Thru 8/28/22-p/r 9/3/22-ER rounding adj.


9/7/2022


B-6325


INPRS

General Fund 2149.0


$ 5,984.58


$ 5,984.58


C6325


Pay period ending 8/28/2022-EmpPerf [NIRPC]


9/9/2022


5138


DeLage

General Fund 5243.9


$ 3,723.91


$ 3,723.91


C5138


IT


9/9/2022


5138


DeLage

General Fund 5241.9


$ 842.74


$ 842.74


C5138


Copier


9/9/2022


5138


DeLage

General Fund 5910.0


$ 206.25


$ 206.25


C5138


M365


9/9/2022


5118

Lake County Community Services, Inc.

General Fund 5760.0


$ 41,499.00


$ 41,499.00


C5118


Apr-Jun 2022 PMTF Reimb


9/9/2022


5116


Opportunity Enterprises

General Fund 5760.0


$ 47,351.00


$ 47,351.00


C5116


Apr-Jun 2022 PMTF Reimb


9/9/2022


5117

Porter County Aging and Community Services

General Fund 5760.0


$ 22,758.00


$ 22,758.00


C5117


Apr-Jun 2022 PMTF Reimb


9/12/2022


5098


Casey's General Store

General Fund 5410.1


$ 7.68


$ 7.68


CC5098


Small bag of ice/24pk Casey's water


9/12/2022


5130


Chicago Tribune Media

General Fund 5410.1


$ 27.72


$ 27.72


CC5130


Newspaper Subscription-Sept


9/12/2022


5082

Indiana Licensing Enterprise

General Fund 5410.9


$ 75.00


$ 75.00


CC5082


Notary Public Commission Renewal- Todd, L


9/12/2022


5054


Panera Bread

General Fund 5410.1


$ 674.60


$ 674.60


CC5054


Lunch Order EDD 7/25-7/26/2022


9/12/2022


5128


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


CC5128


Stamps


9/13/2022


5106


City of LaPorte

General Fund 5760.0


$ 42,224.00


$ 42,224.00


C5106


LaPorte Operating Assistance Apr-Jun 2022


9/13/2022


5100


City of Valpo

General Fund 5760.0


$ 52,339.00


$ 52,339.00


C5100


Valpo OA CMAQ Apr-Jun 2022 IN-2019-029

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


9/13/2022


5101


City of Valpo

General Fund 5760.0


$ 64,081.00


$ 64,081.00


C5101


Valpo CCC Vline Apr-Jun 2022 IN -2019-030


9/13/2022


5102


City of Valpo

General Fund 5760.0


$ 54,632.00


$ 54,632.00


C5102


Valpo CCC-DASH Apr-Jun 2022 IN-2017-027


9/13/2022


5110


East Chicago Transit

General Fund 5760.0


$ 51,331.00


$ 51,331.00


C5110


ECT Preventative Maintenance Apr-Jun 2022


9/13/2022


5111


East Chicago Transit

General Fund 5760.0


$ 57,691.00


$ 57,691.00


C5111


ECT Paratransit Apr-Jun 2022


9/13/2022


5112


East Chicago Transit

General Fund 5760.0


$ 37,808.00


$ 37,808.00


C5112


ECT Operating Assistance Apr-Jun 2022


9/13/2022


5108

Lake County Community Services, Inc.

General Fund 5760.0


$ 101,024.00


$ 101,024.00


C5108


LCCS Enhanced Mobility Operating Assistance Apr-Jun 2022


9/13/2022


5109

Lake County Community Services, Inc.

General Fund 5760.0


$ 15,495.00


$ 15,495.00


C5109


LCCS Preventative Maintenance Apr-Jun 2022


9/13/2022


5113


Opportunity Enterprises

General Fund 5760.0


$ 19,540.00


$ 19,540.00


C5113


OE Preventative Maintenance Apr-Jun 2022


9/13/2022


5103

Porter County Aging and Community Services

General Fund 5760.0


$ 5,806.00


$ 5,806.00


C5103


PCACS Preventative Maintenance Apr-Jun 2022


9/13/2022


5104

Porter County Aging and Community Services

General Fund 5760.0


$ 2,576.00


$ 2,576.00


C5104


PCACS Operating Assistance Apr-Jun 2022


9/13/2022


5105

Porter County Aging and Community Services

General Fund 5760.0


$ 32,044.00


$ 32,044.00


C5105


PCACS Enhanced Mobility Operating Assistance Apr-Jun 2022


9/14/2022


5125


Auto-Owners Insurance

General Fund 5122.9


$ 140.00


$ 140.00


3073


Worker's Comp Audit


9/14/2022


5127

Blachy, Tabor, Bozik & Hartman, LLC

General Fund 5602.9


$ 1,750.00


$ 1,750.00


3074


Legal-Sept


9/14/2022


5121


Bryco Services

General Fund 5223.9


$ 1,425.00


$ 1,425.00


3075


Office Cleaning- Sept


9/14/2022


5135


City of Portage

General Fund 5221.9


$ 19,725.67


$ 19,725.67


3076


Lease-SEPT


9/14/2022


5157


Drive Clean Indiana

General Fund 5610.5


$ 91,898.00


$ 91,898.00


3077


CMAQ Air Quality Public Air Quarterly April 1, 2022


9/14/2022


5136


Kansas City Life

General Fund 5143.9


$ 812.17


$ 812.17


3078


S-T Disability Insurance-Sept/ L-T Disability Insurance-Sept


9/14/2022


5093


Liberty Mutual Ins. Co.

General Fund 5222.9


$ 100.00


$ 100.00


3079


$15,000 Public Official Bond for Treasurer


9/14/2022


5152

Nat'l Assoc. of Regional Councils

General Fund 5410.1


$ 510.00


$ 510.00


3080


2022 Exe. Dir. Conf. Kansas City- Registration-Warner, T


9/14/2022


5151


NWI Forum

General Fund 5410.1


$ 40.00


$ 40.00


3081


2022 Ignite lunch Sept.27th-Warner, T


9/14/2022


5131


Paramount Dental

General Fund 2153.0


$ 878.92


$ 878.92


3082


Dental Insurance-Sept


9/14/2022


5094


Pulse Technology

General Fund 5430.9


$ 95.36


$ 95.36


3083


Office Supplies


9/14/2022


5158

RDG Planning & Design, Inc.

General Fund 5610.2


$ 6,610.08


$ 6,610.08


3085

Northwestern Indiana 2050 Metropolitan

Transportation Plan --Finding Meaning-Land Use


9/14/2022


5156

RDG Planning & Design, Inc.

General Fund 5610.2


$ 5,903.94


$ 5,903.94


3084

Northwestern Indiana 2050 Metropolitan

Transportation Plan --Creating Purpose- Transportation


9/14/2022


5095

Reid's Fire & Safety Equip.

General Fund 5223.9


$ 259.85


$ 259.85


3086

Service- portable fire

extinguishers/Inspection/Tamper Seals/Service vehicle


9/14/2022


3982


SME

General Fund 5610.5


$ 601.68


$ 601.68


3092


Site Assessment-Hazardous Substance


9/14/2022


3982


SME

General Fund 5610.5


$ 3,132.39


$ 3,132.39


3091


Site Assessment-Hazardous Substance


9/14/2022


3982


SME

General Fund 5610.5


$ 2,792.50


$ 2,792.50


3087


Programmatic Support & Outreach-Petroleum/- Site Assessment-Petroleum


9/14/2022


3982


SME

General Fund 5610.5


$ 2,592.59


$ 2,592.59


3088


Site Assessment-Petroleum


9/14/2022


3982


SME

General Fund 5610.5


$ 9,031.70


$ 9,031.70


3089


Programmatic Support & Outreach-Petroleum/- Site Assessment-Petroleum


9/14/2022


3982


SME

General Fund 5610.5


$ 5,107.45


$ 5,107.45


3090

Programmatic Support & Outreach-Petroleum/-

Site Assessment-Petroleum/-Site Clean Up Planning-Petroleum


9/14/2022


3982


SME

General Fund 5610.5


$ 1,561.25


$ 1,561.25


3039


Site Assessment-Petroleum/-Site Clean Up Planning- Petroleum


9/14/2022


B-6327


United Way

General Fund 2147.0


$ 33.85


$ 33.85


3094


Pay period ending 8/28/2022


9/15/2022


B-6272


IN Dept of Revenue

General Fund 2143.0


$ 1,485.98


$ 1,485.98


C6272


Pay period ending 8/14/2022, LwtIN, SwtIN- State Tax Withholdings Payable


9/15/2022


B-6272


IN Dept of Revenue

General Fund 2144.0


$ 356.41


$ 356.41


C6272


Pay period ending 8/14/2022, LwtIN, SwtIN- Local Tax Withholdings Payable


9/15/2022


B-6278


IN Dept of Revenue

General Fund 2143.0


$ 60.88


$ 60.88


C6278


Pay period ending 8/14/2022, LwtIN, SwtIN- State Tax Withholdings Payable


9/15/2022


B-6278


IN Dept of Revenue

General Fund 2144.0


$ 9.42


$ 9.42


C6278


Pay period ending 8/14/2022, LwtIN, SwtIN,- Local Tax Withholdings Payable


9/15/2022


B-6254


IN Dept of Revenue

General Fund 2143.0


$ 490.82


$ 490.82


C6254


Pay period ending 7/31/2022 ,LwtIN, SwtIN- State Tax Withholdings Payable


9/15/2022


B-6254


IN Dept of Revenue

General Fund 2144.0


$ 145.87


$ 145.87


C6254


Pay period ending 7/31/2022 ,LwtIN, SwtIN- Local Tax Withholdings Payable


9/15/2022


B-6248


IN Dept of Revenue

General Fund 2143.0


$ 1,483.93


$ 1,483.93


C6248


Pay period ending 7/31/2022, LwtIN, SwtIN- State Tax Withholdings Payable


9/15/2022


B-6248


IN Dept of Revenue

General Fund 2144.0


$ 354.79


$ 354.79


C6248


Pay period ending 7/31/2022, LwtIN, SwtIN- Local Tax Withholdings Payable


9/16/2022


5124


Total Disposal

General Fund 5223.9


$ 79.92


$ 79.92


C5124


Garbage/Recycle-SEPT


9/19/2022


5153


Barloga II, M

General Fund 5410.2


$ 381.36


$ 381.36


C5153


Mileage-NIRPC to Minneapolis, MN-APBP Conference (RT)


9/19/2022


5155


Barloga II, M

General Fund 5410.2


$ 776.20


$ 776.20


C5155

Travel-MN-Hotel The Graduate 3nts/Per Diem

first and last nights/ Breakfast/Lunch/Dinner 2days-Barloga, M


9/19/2022


5154


Barloga II, M

General Fund 5146.9


$ 130.00


$ 130.00


C5154

Association of Pedestrian & Bicycle

Professionals (APBP) Membership-Professional Membership through 8/8/2023


9/19/2022


5141


Bradsky III, Charles

General Fund 5410.2


$ 56.84


$ 56.84


C5141

LaPorte Parks Dept TROC meeting (RT)/NIRPC

to Highland meeting w/various emergency agencies


9/19/2022


5122


Comcast

General Fund 5244.9


$ 196.30


$ 196.30


C5122


Business Internet and Add'l Services-SEPT


9/19/2022


5132


Ecointeractive, Inc

General Fund 5610.2


$ 3,978.00


$ 3,978.00


C5132


TIP SAAS Service for monthly service fee AUG for SEPT


9/19/2022


5134


Fidelity EyeMed

General Fund 2154.0


$ 85.25


$ 85.25


C5134


Vision Insurance-SEPT


9/19/2022


5143


Kane, D

General Fund 5140.3


$ 17.64


$ 17.64


C5143


Mileage-NIRPC to PNW Hammond (RT)


9/19/2022


5142


Kimball, P

General Fund 5410.2


$ 26.06


$ 26.06


C5142


Mileage-VALPO to Lake Co. Fair (RT)


9/19/2022


5149


Warner, T

General Fund 5410.9


$ 195.30


$ 195.30


C5149


Mileage- NIRPC to Carmel, IN/Carmel, IN to Burns Harbor


9/19/2022


5140


Warner, T

General Fund 5410.9


$ 18.90


$ 18.90


C5140


Mileage- Morgan TWP to Hammond- One Region TOD Bus Tour (RT)


9/19/2022


5139


Warner, T

General Fund 5410.9


$ 158.13


$ 158.13


C5139


Mileage- Burns Harbor to INDI- MOP Council (RT)


9/19/2022


5129


Warner, T

General Fund 5244.9


$ 150.00


$ 150.00


C5129


Communication Expense-SEPT


9/19/2022


5150


Warner, T

General Fund 5410.9


$ 219.09


$ 219.09


C5150

Travel-Carmel, IN/Hotel-Springhill

Suited/Per Diem first day/ Per Diem last day Breakfast & Lunch


9/19/2022


5144


Warner, T

General Fund 5410.9


$ 269.43


$ 269.43


C5144


Travel-Hotel INDI MPO Council/Per Deim INDO 1st & last day/Parking


9/20/2022


B-6331


Federal & Fica

General Fund 2140.0


$ 4,774.83


$ 4,774.83


C6331

Pay period ending 9/11/2022, FWT, empfica,

empficamed, fica, ficamed-Federal Tax Withholdings Payable


9/20/2022


B-6331


Federal & Fica

General Fund 2142.0


$ 7,022.68


$ 7,022.68


C6331

Pay period ending 9/11/2022, FWT, empfica,

empficamed, fica, ficamed-FICA Tax Withholdings Payable


9/20/2022


B-6336


HSA

General Fund 2150.0


$ 1,100.53


$ 1,100.53


C6336


Pay period ending 9/11/2022-HAS


9/20/2022


5159


MissionSquare Retirement

General Fund 5145.9


$ 934.36


$ 934.36


C5159


ER paid for Ty Warner 8/29/2022-9/11/2022


9/20/2022


B-6334


MissionSquare Retirement

General Fund 2146.0


$ 830.00


$ 830.00


C6334


Pay period ending 9/11/2022-ICMA


9/20/2022



Payroll


General Fund


$ 34,897.95


$ 34,897.95



Payroll


9/21/2022


5160


INPRS

General Fund 5141.9


$ 0.03


$ 0.03


C5160


8/29 thru 9/11/22-p/r 9/20/22-ER rounding adj.


9/21/2022


B-6333


INPRS

General Fund 2149.0


$ 5,984.58


$ 5,984.58


C6333


Pay period ending 9/11/2022, EmpPerf [NIRPC]


9/29/2022


5165

Accelerate Indiana Municipalities

General Fund 5410.1


$ 345.00


$ 345.00


3095


2022 AIM Ideas Summit: Corp Membership - Warner,T


9/29/2022


5164


Basic

General Fund 5410.9


$ 480.00


$ 480.00


3096


Monthly Fee for COBRA Admin Annually


9/29/2022


4540


City of Valpo

General Fund 5960.0


$ 95,721.00


$ 95,721.00


C4540


TOD Parking Lot lighting project


9/29/2022


5096


Drive Clean Indiana


General Fund 5410.5


$ 750.00


$ 750.00


3097


Drive Clean IN 2022 Golf Outing Hole Sponsorship/Local-Federal Share


9/29/2022


B-6335


United Way

General Fund 2147.0


$ 33.85


$ 33.85


3099


Pay period ending 9/11/2022-United Way


9/30/2022


5172


Kane, D

General Fund 5410.3


$ 14.21


$ 14.21


C5172


Mileage- Various


9/30/2022


5171


Kane, D

General Fund 5410.3


$ 3.43


$ 3.43


C5171


Mileage-NIRPC to Portage (RT)


9/30/2022


5174


Warner, T


General Fund 5410.1


$ 314.97


$ 314.97


C5174

Travel- Parking: LAI Chataqua Panel Discussion (Chicago) / Airbnb March 2023 Purdue Road School / Lunch meeting w/ Indiana Dunes Tourism


9/30/2022


5173


Warner, T

General Fund 5410.9


$ 209.79


$ 209.79


C5173


Mileage- Various





General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -







General Fund



$ -





Allowance of Claims


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

register such claims are hereby allowed in the total amount of $ 1,044,449.26


Dated this         day of          , 2022.



NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


9/7/2022


5119


AccuFund, Inc

CARES Fund 5910.0


$ 1,361.04


$ 1,361.04


C5119


AccuFund Account Suite 5 hosted users Employee Portal (50 Hosted Employees)


9/7/2022


5070

Vantage Point Consulting, Inc

CARES Fund 5610.3


$ 2,812.50


$ 2,812.50


3072


July Emergency Mgmt. Plan Review & Revision


9/7/2022


4996

Vantage Point Consulting, Inc

CARES Fund 5610.3


$ 2,812.50


$ 2,812.50


3072


June Emergency Mgmt. Plan Review & Revision


9/20/2022


5161


Routematch

CARES Fund 5960.0


$ 1,534.00


$ 1,534.00


C5161


Oct 2022 LCCS Routematch/ Oct 2022 NT Routematch


9/29/2022


5166

Accelerate Indiana Municipalities

CARES Fund 5410.3


$ 345.00


$ 345.00


3095


2022 AIM Ideas Summit Corp Membership-Kane, D


9/29/2022


5038


TIP Strategies, Inc

CARES Fund 5610.3


$ 16,850.37


$ 16,850.37


3098

Pymt 8 of 8 Economic resiliency Plan-

Final/Airfare/Ground transportation/Meals/Lodging





CARES Fund



$ -



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


Total:

$ 25,715.41


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 $ 25,715.41


Dated this         day of          , 2020.



PROPOSED 2022 BUDGET AMENDMENT #1

To transfer within revolving loan fund and contractual amount of $25,000



FROM:

CARES Revolving Loan Fund

TO:

EDD Contractual Services

Purpose:


CATEGORY

Transferring funds from CARES RLF line item to EDD contractual services to cover the reminder of a contract.


DETAILED BUDGET LINE Original Addition Amended


CARES RLF services

Expense:

Revolving Loan Fund

461,648

(25,000) 436,648


Contractual

Expense:

EDD Contractual Services

101,000 25,000 126,000

ADDENDUM III:

ADDENDUM TO THE BASIC AGREEMENT BETWEEN THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION AND ECO-INTERACTIVE, INC. FOR ELECTRONIC TRANSPORTATION IMPROVEMENT PROGRAM (eTIP) SYSTEM PROCURED UNDER RFP 17-15-01. UNDER CFDA: 20.205

The parties to an agreement by and between Eco-Interactive Inc. (Contractor) and the Northwestern Indiana Regional Planning Commission (Commission) hereby agree to a contract extension as follows:

  1. Compensation:

    Effective October 1, 2022, the Contractor shall provide customized Project Tracker Software as a Service as noted in Part II of the original agreement, for a cost not to exceed $50,600.00 for year 6 billed at a rate of $4,216.66 per month.

    Option Extension Year 7 billed at $53,130.00 per year.

    Payment for services provided by the Contractor will be on a reimbursement basis and in accordance with procedures provided for in the Terms of Agreement Section of this Agreement.

  2. Terms of the Agreement:

The Contractor shall continue providing ongoing Project Tracker SaaS for the Commission. Ongoing services included in the monthly subscription rate are: Software maintenance, SaaS hosting, help desk support, and up to 120 support hours annually for enhancement commencing the first day of October 2022 through and including the 30th day of September, 2023. NIRPC will notify Contractor within 3 months of the end of agreement of intent to continue with option year extension.

Agreement:

It is hereby agreed and understood by the party’s signatory hereto that these changes made to the Agreement become executed when the appropriate signatures are affixed hereto, and the date of contract award is established as of the 1st day of October 2022.

NORTHWESTERN INDIANA REGIONAL ECO-INTERACTIVE INC. PLANNING COMMISSION


By: By:


Tyson Warner Jessie Yu

Executive Director CEO


Date Date


Attest:


Talaya Jones Contracting Officer


2023 PRELIM BUDGET

Draft

10/20/2022

FY 2023 BUDGET

ATTACHMENT A


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2023 GENERAL FUND APPROPRIATIONS BUDGET



PERSONNEL - SALARIES

1,601,890


PERSONNEL - FRINGE BENEFITS

639,827


OCCUPANCY

292,398


EQUIPMENT SERVICE/MAINTENANCE

82,636


DEPARTMENTAL

153,386


CONTRACTUAL

1,183,589


CAPITAL OUTLAYS - Equipment & Furniture 180,000


TOTAL FUND BUDGET

4,133,726


ft

ATTACHMENT B


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2023 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET



Dra

CAPITAL OUTLAYS - TRANSIT EQUIPMENT 3,986,016

CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT 62,354


TOTAL FUND BUDGET

4,048,370


ATTACHMENT C


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2023 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET



OTHER SERVICES AND CHARGES 7,221,696


TOTAL FUND BUDGET

7,221,696


ATTACHMENT D


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2023 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET



OTHER SERVICES AND CHARGES 220,000


TOTAL FUND BUDGET

220,000


TOTAL BUDGET OF

15,625,792

Attachment A


NIRPC FY 2023 Budget




FY 2022 Budget


FY 2023 Budget Change %

REVENUES



COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

1,769,676

506,000

STATE AGENCIES

2,300,581

3,007,841

LOCAL AGENCIES

72,760

44,800

NON-GOVERNMENTAL

14,828

17,000

INTEREST INCOME

         37,885

        17,814

TOTAL REVENUES

4,736,001

4,133,726 -15%


Draft

EXPENDITURES

SALARY

FRINGE BENEFITS

FICA CONTRIBUTIONS

WORKERS COMPENSATION

UNEMPLOYMENT COMPENSATION

PERF CONTRIBUTIONS

HEALTH INSURANCE

LIFE & DISABILITY INSURANCE

ICMA CONTRIBUTIONS

STAFF DEVELOPMENT

1,590,648

1,601,890

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

23,400

25,000


38,000

21,000


2,000

2,000


17,347

22,000


545,325

401,932


320,000

50,000


2,000

2,000


461,648

461,648


101,000

101,000


2,000

2,000


        53,045

       95,009


1,565,765

1,183,589

-32%

180,000

180,000

0%

      4,736,000

      4,133,726

-15%

          0

          0


FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

1%


121,685

122,545


5,000

5,000


3,000

3,000


199,688

200,802


240,000

240,000


24,000

24,000


24,480

24,480


         20,000

        20,000


637,853

639,827

0%


OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

236,708

236,708


6,500

6,500


18,540

18,540


        30,650

       30,650


292,398

292,398

0%

EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

18,000

18,000


43,736

43,736


18,900

18,900


        2,000

        2,000


82,636

82,636

0%


DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

ECONOMIC DEVELOPMENT DISTRICT

GENERAL USE SUPPLIES

35,000

35,000


239,000

38,000


25,000

25,000


23,418

7,500


1,000

1,000


25,000

25,000


3,700

14,953


29,583

3,183


        5,000

        3,750


386,701

153,386

-152%

Attachment A page 2

NIRPC FY 2023 Revenue Detail


347,204

115,040

    78,027

540,271


250,000

210,000

46,000

506,000


183,341

480,000

1,861,500

61,000

62,000

    360,000

3,007,841


1,800

13,000

    30,000

44,800


Draft

COUNTY APPROPRIATIONS

LAKE COUNTY

PORTER COUNTY

LA PORTE COUNTY

TOTAL

FEDERAL AGENCIES

FTA OVERSIGHT

FTA CAPITAL

USDA FOREST SVC

TOTAL

STATE AGENCIES

INDOT PL 2021

INDOT PL 2022

INDOT PL 2023

STBG

CMAQ 2022

CMAQ 2023

TOTAL

LOCAL AGENCIES

CITY of PORTAGE

PARTNERS for CLEAN AIR

ONE REGION ONE TRAIL

TOTAL

NON-GOVERNMENTAL

CALUMET LAND CONSERVATION PARTN.

SHARED ETHICS ADVISORY COMMISSION

TOTAL

INTEREST INCOME

BANK INTEREST INCOME

RLF INTEREST INCOME

TOTAL FY 2022 REVENUE

15,000

     2,000

17,000


3,000

14,814

   4,133,726

Attachment B

NIRPC FY 2023 Budget


Grant Federal Req. Match Total


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 Staff Computers

Replace 4 Communter Vehicle

Associated Transit Improv

Tablets and Vehicle Devices

Office Computer Equipment

Office Computer Equipment

Replace ChicaGO Dash

Replace 1 Vehicle

Computers

Replace Bus Stop Signs

Transit Improvements

Buy Replacement

Buy Replacement

Buy Replacement

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

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

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

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

12,000

699

30,000

25,000

16,400

28,000

26,000

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


Draft

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


Contingency -


TOTAL BUDGET  3,436,426



**

new projects for 2022 not included

Attachment B


CY 2023 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Letting

Date

Total

Non-Federal

Funds

Federal Funds

ECT

2022-020

BUY REPLACEMENT 35-FT BUS


$ 549,590

$ 91,598

$ 457,992















Draft

TOTAL BUDGET

$   549,590

$   457,992

Attachment B


CY 2021 CARES ACT 2020 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Total

Federal Funds

ECT

CARES Act 2020-014

Support Vehicle (2)

$ 50,561

$ 50,561

NT

CARES Act 2020-014

Misc Support Equipment

$ 9,896

$ 9,896

Valpo

CARES Act 2020-014

Misc Support Equipment

$ 1,897

$ 1,897






Draft

TOTAL BUDGET

$    62,354

$   62,354

Attachment C

CY 2022 TRANSIT OPERATING PROJECTS FUND


Draft

Federal Req. Match Total


City of East Chicago 2023


Preventative Maintenance

375,511

Complementary Paratransit

285,164

Operating Assistance

384,060

Existing Grants

607,267

93,878

71,291

384,060

374,493

469,389

356,455

768,120

981,760


City of LaPorte 2023


Operating Assistance

259,890

Existing Grants

103,120

259,890

103,120

519,780

206,240


City of Valparaiso 2023


Capital Cost of Contracting

1,025,081

Dash Expansion

269,600

Shuttle Connect Expansion

332,000

Existing Grants

991,210

256,271

67,400

83,000

247,803

1,281,352

337,000

415,000

1,239,013


North Township 2023


Preventative Maintenance

43,200

Operating Assistance

259,175

Existing Grants

183,232

10,800

259,175

162,179

54,000

518,350

345,411


Opportunity Enterprises 2023


Preventative Maintenance

204,800

Existing Grants

68,689

51,200

17,172

256,000

85,861


Porter County Community Services 2023


Operating Assistance (Enhanced Mobility)

133,761

Existing Grants

268,528

133,761

174,849

267,522

443,376


Southlake Community Services 2023


Preventative Maintenance

101,102

Operating Assistance

400,000

Ehnaced Mobility

125,000

Existing Grants

259,623

25,276

400,000

125,000

216,543

126,378

800,000

250,000

476,166


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


Public Mass Transportation Fund

541,683

-

541,683


TOTAL

   7,221,696  3,517,160  10,738,856

Draft

Attachment D



CY 2023 LAPORTE COUNTY REVOLVING LOAN FUND


2022 2023

Budget Budget


New Loans


150,000


220,000


TOTAL

150,000


220,000







TOTAL BUDGET



220,000



Attachment D

LaPorte RLF 2023 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

875

CONTRACTUAL

LA PORTE RLF SERVICES

        2,000

2,000


Draft

TOTAL EXPENSES 9,800


FUND BALANCE - ENDING  -




Attachment D

CARES ACT RLF 2023 Administration Budget


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

REVENUES


RLF INTEREST INCOME

5,014

CLOSING CHARGES

         3,000

TOTAL REVENUES

8,014


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

1,900

1,368

        1,748

5,016


DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES- AF Loan

368

         630

998

CONTRACTUAL

LA PORTE RLF SERVICES

        2,000

2,000


Draft

TOTAL EXPENSES 8,014


FUND BALANCE - ENDING  -