image

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org


FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda – Thursday, July 21, 2022 -- 8:00 a.m.

Dune Room – NIRPC Office


  1. Call to Order

  2. Meeting Minutes of May 19, 2022 Pages 1 - 2

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

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

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

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

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

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

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

    ACTION REQUESTED: Approval

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

    ACTION REQUESTED: Approval

  6. Approval of RLF Claims Register – May 2022 Pages 20

    ACTION REQUESTED: Approval

  7. Review of Financial Status – June 2022 Budget vs Actual Pages 21 - 31

    1. Bank Statement Reconciliations (pg. 21-26)

    2. General Fund Expenses YTD June 2022 (pg. 27-28)

    3. General Fund Revenue YTD June 2022 (pg. 29)

    4. CARES Expenses YTD June 2022 (pg. 30)

    5. CARES Revenue YTD June 2022 (pg. 31)

  8. Approval of General Fund Claims Register – June 2022 Pages 32 - 34

    ACTION REQUESTED: Approval

  9. Approval of CARES Act Claims Register – June 2022 Pages 35

    ACTION REQUESTED: Approval

  10. December 2021 Draft Financials Pages 36 - 40

  11. NIRPC FY 2022 Budget Amendment #1 Pages 41

    ACTION REQUESTED: Approval

  12. Procurement #21-05.04 Pages 42

    ACTION REQUESTED: Recommendation

  13. SME Contract Amendment 1 Pages 43 – 58

    ACTION REQUESTED: Recommendation


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

  14. Drive Clean Indiana 2022 (SFY2023) Contract Pages 59 – 67

    ACTION REQUESTED: Recommendation

  15. Personnel update

  16. Other Business

  17. Adjournment


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


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

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

May 19, 2022 / NIRPC Dune Room – 8:00 a.m.


Members present in-person

Bob Carnahan, Joshleen Denham, Tom Dermody, Denise Ebert, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson, George Topoll


Staff and others present in-person

Talaya Jones, Denarie Kane, Meredith Stilwell, Ty Warner, Lisa Todd, Stephanie Kuziela, Mary Tanis, David Hollenbeck


Call to Order

Chairperson Dermody called the meeting to order.

Approval of Minutes

The minutes of the April 21, 2022 meeting were presented. On motion by Bob Carnahan, second by Greg Stinson and no opposition, the minutes were approved.

Review of Financial Status – April 2022 Budget vs Actual

Stephanie Kuziela presented the April 2022 bank reconciliations for the NIRPC general account, the CARES Revolving Loan Fund account, and the Revolving Loan Fund Account.


Stephanie presented the April 2022 general fund financial reports. Total expenditures for the period ending April 30, 2022, were $2,033,335 of the $9,201,349 budgeted. Total general fund revenue for the period was $11,340 of the $4,311,106 budgeted.


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

$183,765 of the $1,153,515 budgeted. Total CARES revenue collected for the period was $186,531 of the $1,352,229 budgeted.


Approval of Claims Registers – April 2022

Stephanie presented the April 2022 General Fund claims register totaling $224,949.30 to the Committee for approval. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the General Fund claims in the amount of $224,949.30 were approved. The CARES Act register of claims totaling

$52,945.00 was presented for approval. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the CARES Act register of claims in the amount of $52,945.00 were approved. The RLF register of claims totaling $50,000.00 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 $50,000.00 were approved.


NIRPC Resolution 22-14: Regulatory Financial Year-End Reporting

Talaya presented resolution 22-14 which would allow NIRPC to revert to regulatory reporting for State Board of Accounts (SBOA) auditors. NIRPC has been voluntarily reporting GAAP financial statements to SBOA, however it is a lot of data for the agency to compile and submit and is costly. On motion by Greg Stinson, second by Richard Hardaway and no opposition, the Committee favorably recommended Resolution 22-14 to the NIRPC Board for approval.


Addendum to the LaPorte County Revolving Loan Fund Management Plan

Denarie Kane presented an addendum to the LaPorte County Revolving Loan Fund Management Plan for the Committee’s approval. The addendum allows for flexibilities provided by EDA for recipients of EDA- funded RLF awards in light of the impact of COVID-19 on small businesses to be implemented through June 30, 2022. The addendum was reviewed and recommended by the LaPorte County Revolving Loan Fund Management Board on May 18, 2022. On motion by Wendy Mis, second by George Topoll and no

opposition, the Committee approved the addendum to the LaPorte County Revolving Loan Fund Management Plan.


Personnel updates

Ty Warner announced that Allen Hammond, NIRPC’s Compliance Manager, will no longer be working for NIRPC. The Accountant, Public Transit and Engagement Planner, and Economic Development Specialist positions are still posted and open, noting that the Economic Development Specialist position is funding the CARES act grants funds that are expiring June 30, 2022. Ty indicated that in his discussions with other agencies, NIRPC is not unique in struggling to find candidates for the open positions. A discussion was held regarding the reason why individuals are choosing to leave and why open positions are not filled.

Other Business None


Adjournment

There being no further business, the meeting was adjourned.


33

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


1,040,424.16

146

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


932,316.31

2

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


209.96

0

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


0.00


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

5/11/2022

124.90


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

5/31/2022

62.17

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

5/31/2022

1,206,704.35

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


0.00

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

5/31/2022

1,166,911.58

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


(39,792.77)

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


0.00

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


1,206,704.35

Date

Reference

Deposit Description

Amount

5/05/2022

8272864

EDA Institutional March 2022 Reimbursement

21,131.51

5/05/2022

8272865

2021 Partnership Reimb Jan-Mar 2022

19,077.99

5/05/2022

8272866

CARES RLF Oversight March 2022

1,249.56

5/11/2022

8272867

2022 Partner's for Clean Air Silver Linde

1,000.00

5/16/2022

8272868

May 2022 Sublet

150.00

5/18/2022

8272862

3rd Quarter 2022 PL Reimbursement

376,110.10

5/24/2022

8272862

NIRPC Oversight Jan-Mar 2022 Draw 26-22CARES

72.00

5/24/2022

8272862

Oversight for the period of Jan-Mar 2022 from Grant IN-2018-026

52,366.00

5/24/2022

8272862

Oversight-Delage for the period of Jan-Mar 2022 from Grant IN-2020-014

825.00

5/25/2022

8272862

RouteMatch June 2022 Reimb

1,534.00

5/25/2022

8272862

RouteMatch Annual Tech Support & Maint

5,100.00

5/25/2022

8272862

Best Servers Reimb NT & LCCS RouteMatch Server set up

69.00

5/25/2022

8272862

CDW-G Reimb for Ty's Laptop

1,842.00

5/25/2022

8272862

Valpo OA CMAQ Jan-Mar 2022 Draw 30-22

49,066.00

5/25/2022

8272862

Valpo CCC-VLine Jan-Mar 2022 Draw 31-22

60,814.00

5/25/2022

8272862

Valpo CCC- DASH Jan-Mar 2022 Draw 32-22

52,452.00

5/25/2022

8272862

PCACS PM Jan-Mar 2022 Draw 33-22

3,064.00

5/25/2022

8272862

PCACS OA Jan-Mar 2022 Draw 34-22

1,038.00

5/25/2022

8272862

PCACS EM OA Jan-Mar 2022 Draw 35-22

5,689.00

5/25/2022

8272862

PCACS EM OA Jan-Mar 2022 Draw 36-22

15,829.00

5/25/2022

8272862

NT OA Jan-Mar 2022 Draw 37-22

41,953.00

5/25/2022

8272862

NT PM Jan-Mar 2022 Draw 38-22

9,829.00

5/25/2022

8272862

Laporte OA Jan-Mar 2022 Draw 39-22

6,872.00

5/25/2022

8272862

Laporte OA Jan-Mar 2022 Draw 40-22

60,196.00

5/25/2022

8272862

LCCS EM OA Jan-Mar 2022 Draw 41-22

81,927.00

5/25/2022

8272862

LCCS PM Jan-Mar 2022 Draw 42-22

17,779.00

5/25/2022

8272862

ECT PM Jan-Mar 2022 Draw 43-22

42,463.00

5/25/2022

8272862

ECT PARA Jan-Mar 2022 Draw 44-22

55,414.00

5/25/2022

8272862

ECT OA Jan-Mar 2022 Draw 45-22

31,059.00

5/25/2022

8272862

OE PM Jan-Mar 2022 Draw 46-22

8,259.00

5/25/2022

8272862

OE PM Jan-Mar 2022 Draw 47-22

14,171.00

5/26/2022

8272862

LCCS 2021 Lease Equip

23.00

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 6/09/2022 @ 9:41 AM

Reconciliation - General

Page: 1

STK 6/9/22

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

4/30/2022

7/12/2022

1,098,449.27

image


Date

Reference Deposit Description


Amount

image 5/26/2022

8272862 NIPSCO 2022 Partners for Clean Air


2,000.00



Total Deposits:

1,040,424.16

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

0002764 American of Metropolitan Planning

NIRPC-Job Posting Director of Transportaion

50.00


4/07/2022

Organization

0002975 City of Portage, The


Lease-APR


19,725.67

5/19/2022

0002994 City of Portage, The

Lease-MAY

19,725.67

5/19/2022

0002996 Gov't Finance Officers Association

Membership Renewal 5/1/22-4/30/23-Jones,

160.00


5/26/2022


0003004 Best Servers LLC

T

RouteMatch server assistance for North


68.75



Township



Total Unmarked Checks: 39,792.77

Total Checks:

39,792.77

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 6/09/2022 @ 9:41 AM

Reconciliation - General

Page: 2

image

image

Trial Balance - Cash

Run: 6/09/2022 at 9:59 ANMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 5/31/2022


Page: 1



All Balance

1.1.001.0000.1010.0 General Cash  1,166,911.58

Total 1,166,911.58


image

STK 6/9/22


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 610112022@ 7:44 AM Reconciliation - CARES RLF Bank Account Page:

image



image

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

4/30/2022

6,190.28


2

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


1,818.25

O

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


0.00

O

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


0.00

0

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


0.00


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


0.00


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

5/31/2022

0.14


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

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

5/31/2022

8,008.67

0.00


image


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

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

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

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

5/31/2022 8,008.67

0.00

0.00

8,008.67


image

[ Date Reference Deposit Description Amount

image

ti 5/03/2022 8272860

ti 5/11/2022 8272861

Healthy Smiles RLF Loan Payment

Divine Strategy CARES RLF Loan Payment

805.25

1,013.00

image

Total Deposits: 1,818.25


viSit

image

/1/J2

Trial Balance - Cash

Run: s10112022 at 7:45 RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 5/31/2022


Page: 1



All 4.3.050.0000.1010.0 CARES RLF Cash

Total


Balance

8,008.67

8,008.67


ls)1il

image

i/1/ J.1


image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 610112022@ 12:27 PM Reconciliation - Revolving Loan Fund Page:

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

4/30/2022

268,292.44


6

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


10,727.35

O

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


0.00

O

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


0.00

O

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


0.00


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


0.00


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

5/31/2022

9.31

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

5/31/2022

279,029.10

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


0.00

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

5/31/2022

279,029.10

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


0.00

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


0.00

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


279,029.10


image

Dat!3 Reference Deposit Description

image

image

-,/. 5/05/2022 8272859 Hammer's RLF Payment

· 5/11/2022 8272860 Wilson's Barbershop May 2022 RLF Payment

.,,. 5/16/2022 8272861 Bombats RLF Final Payment

tf 5/16/2022 8272862 Etropal May 2022 RLF Payment

,t

. 5/17/2022 8272863 Blucker's Market RLF Payment 5/31/2022 8272864 Downtown Delights RLF Application


ls1IL

&/,Ii

Amount

1,381.24

1,200.00

6,396.11

1,000.00

300.00

450.00

image

Total Deposits: 10,727.35


-({·YY

Trial Balance - Cash

Run: s10112022 at 12:21i'ORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 5/31/2022


Page: 1



All

2.3.050.0000.1010.0 LaPorte Cash

Total


Balance

279,029.10

279,029.10


ls-1i

/,/:

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH MAY 31, 2022


image



Line Items FY 2022 Budget

YTD May Expended

FY 22 Budget % balance

image


Salaries

5020-1 Total Salaries 1,530,748 534,596 65%

image

Salaries Sub-Total 1,530,748 534,596 65%

image


Fringe Benefits

5121-9

FICA Contributions


121,685

40,272

67%

5122-9

Workers Compensation


5,000

2,539

49%

5123-9

Unemployment Compensation


3,000

956

68%

5141-9

PERF Contributions


199,688

68,468

66%

5142-9

Health Insurance


240,000

73,570

69%

5143-9

Life & Disability Insurance


24,000

6,125

74%

5145-9

ICMA


24,480

9,344

62%

5146-9

Staff Development


20,000

2,237

89%



Fringe Benefits Sub-Total

637,853

203,510

68%


Occupancy






5221-9

Office Lease


236,708

98,628

58%

5222-9

Property Insurance


6,500

4,880

25%

5223-9

Building Maintenance


18,540

7,513

59%

5224-9

Utilities


30,650

3,456

89%



Occupancy Sub-Total

292,398

114,477

61%


Maintenance




5241-9 Copier Leasing/Maintenance

18,000

5,056

72%

5243-9 Computer Service/Maintenance

43,736

22,343

49%

5244-9 Telephone Service/Maintenance

18,900

4,613

76%

Combined Copier/IT/Phone Service/Maintenance

80,636

32,013

60%

5249-9 Other Equipment Maintenance

2,000

225

89%

Maintenance Sub-Total

82,636

32,238

61%

Departmental




5410-1

Communications: Commission/Ex. Dir.

35,000

9,645

72%

5410-2

Communications: Transportation

239,000

13,732

94%

5410-3

Economic Development District

29,583

40

100%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

28,947

2,254

92%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

25,000

14,273

43%

5420-5

Promotional Expenses: Environmental Programs

14,953

2,206

85%

5430-9

General Use Supplies Expense

5,000

1,204

76%


Departmental Sub-Total

403,483

43,354

89%


Contractual






5602-9

Legal Services


23,400

8,750

63%

5603-9

Audit and Accounting


70,000

63

100%

5604-9

LaPorte RLF Services


2,000

0

100%

5610-4

Transit Oversight


17,347

0

100%

5610-5

Environmental Projects


837,314

289,719

65%

5610-2

Planning


320,000

28,882

91%

5619-9

Organizational Dev.


2,000

0

100%

5610-0

Board Development


2,000

0

100%

5610-2

E-Tip


95,009

15,912

83%



Contractual Sub-Total

1,369,070

343,326

75%


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

1,271,500

72%


LaPorte Revolving Loan Fund


150,000


0


Transit Capital Fund

142,080

332,521


Transit Operating Fund

4,438,881

1,317,297


TOTAL EXPENDITURES

9,201,349

2,921,319


image

                                  10                 


CARES FUND EXPENDITURES

image

YTD May 2022 Expenses Budget vs Actual

700,000

637,812

600,000

570,446

534,596

500,000


400,000

343,326

300,000

265,772

203,510

168,118

200,000

121,833 114,477

100,000

34,432

32,238

43,354

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD May Budget YTD May Expended

image

YTD May 2022 Expended by Category

Salaries

Fringe Benefits Occupancy

Departmental

3%

Maintenance

Departmental Contractuals

Occupancy 9%

Fringe Benefits 16%

Maintenance 3%

Salaries 42%

Contractuals 27%

11

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH MAY 31, 2022



YTD May

YTD Variance

FY 22 Budget %

Line Items FY 2022 Budget

Collected

(Under)/Over

balance

image

Revenue by Funding Source as of May 31, 2022


Interest Income 1%

County Appropriations 0%


County Appropriations Federal Agencies

State Agencies Local Agencies Non‐Governmental

Economic Development District Interest Income

Federal Agencies 12%

State Agencies 82%

Economic Development District

4%

Local Agencies 1%

Non‐Governmental 0%

GENERAL FUND REVENUE


1.1.4110

County Appropriations

540,271

0

540,271

100%

1.1.4210

Federal Agencies

896,383

56,335

840,048

94%

1.1.4310

State Agencies

2,668,379

376,110

2,292,269

86%

1.1.4410

Local Agencies

76,760

5,253

71,507

93%

1.1.4610

Non-Governmental

48,513

1,480

47,033

97%

1.3.4260

Economic Development District

70,000

19,078

50,922

73%

1.1.4800

Interest Income

10,800

2,378

8,422

78%


Revenue Total

4,311,106

460,635

3,850,471

89%


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH MAY 31, 2022



Line Items FY 2022 Budget

YTD May

Expended

FY 22 Budget %

balance

NIRPC CARES EXPENDITURES

Salaries



Salaries


59,900

16,685

72%


Salaries Sub-Total

59,900

16,685

72%


image

image

YTD May 2022 Expenses Budget vs Actual

120,000

100,000

101,000

80,000

59,900

60,000

53,500

40,000

25,800

16,685

20,000

3,168

5,648

410

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

Contractual

EDD Institutional CARES ACT 101,000

53,500

47%

Contractual Sub-Total 101,000

53,500

47%

Departmental


Communications


3,168


269


92%


PPE Supplies & Office Supplies


141

0%


Departmental Sub-Total

3,168

410

87%


Capital Outlays

Furniture and Equipment

25,800

5,648

78%

Capital Outlays Sub-Total

25,800

5,648

78%





TOTAL NIRPC CARES FUND EXPENDITURES

189,868

76,242

60%


CARES Revolving Loan Fund


461,648


50,709


CARES Transit Capital Fund

491,999

73,858


CARES Transit Agency Fund

10,000

10,000


TOTAL EXPENDITURES

1,153,515

210,809



NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH MAY 31, 2022




Line Items


FY 2022 Budget

YTD May

Collected

FY 22 Budget %

balance

CARES ACT OPERATING






Operating Revenue

25,800

5,307

79%

CARES ACT RLF

EDD RLF Revenue

477,992

1,250

100%

CARES ACT EDA

Economic Development District

304,553

91,641

70%



808,345

98,198

88%

CARES ACT RLF

Loan Proceeds

32,085

50,000

-56%

CARES ACT RLF

Loan Application Fees & Interest

9,800

2,391

76%

CARES AGENCY

FTA Revenue

10,000

10,000

0%

CARES TRANSIT CAPITAL

FTA Revenue

491,999

73,858

85%

image

Revenue by Funding Source as of May 31, 2022


CARES Operating

Economic Development District NWI Recover RLF (CARES RLF)

CARES Transit Agency CARES Transit Capital

CARES Transit Agency 4%

NWI Recover RLF (CARES RLF)

23%

Economic Development District

39%

CARES Transit Capital 32%

CARES Operating 2%

Revenue Total    1,352,229       234,447         83%   


NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

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

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


5/3/2022


4849


Anthem Life

General Fund 5143.9


$ 395.23


$ 395.23


C4849


ER paid Life Insurance-MAY


5/3/2022


4849


Anthem Life

General Fund 2155.0


$ 122.50


$ 122.50


C4849


EE paid Life Insurance- MAY


5/3/2022


4852


Dialpad

General Fund 5244.9


$ 654.33


$ 654.33


C4852


Telephone Service-MAY


5/3/2022


6004


Federal & FICA

General Fund

2140.0


$ 4,869.50


$ 4,869.50


C6004

FWT, empfica, empficamed, fica, ficamed-

Federal Tax Withholdings Payable


5/3/2022


6004


Federal & FICA

General Fund

2142.0


$ 7,581.54


$ 7,581.54


C6004

FWT, empfica, empficamed, fica, ficamed- FICA

Tax Withholdings Payable


5/3/2022


6010


Federal & FICA

General Fund

2142.0


$ 22.18


$ 22.18


C6010


emfica,empficamed,fica,ficamed


5/3/2022


6007


Horizon Bank

General Fund

2150.0


$ 1,100.53


$ 1,100.53


C6007


HSA


5/3/2022


6008


MissionSquare Retirement

General Fund

2146.0


$ 830.00


$ 830.00


C6008


ICMA


5/3/2022


4859


MissionSquare Retirement

General Fund

5145.9


$ 934.36


$ 934.36


C4859


ER paid for Ty Warner 4/11/22-4/24/2022


5/3/2022



Payroll



$ 38,041.58


$ 38,041.58



Payroll-Staff


5/3/2022



Payroll



$ 133.95


$ 133.95



Payroll- Paskash, Matthew


5/3/2022


4872


United HealthCare Srvcs

General Fund

2152.0


$ 2,116.74


$ 2,116.74


C4872


EE paid for MAY


5/3/2022


4872


United HealthCare Srvcs

General Fund

5142.9


$ 11,994.85


$ 11,994.85


C4872


ER paid for MAY


5/4/2022


6006


INPRS

General Fund

2149.0


$ 6,503.95


$ 6,503.95


C6006


EmpPerf[NIRPC]


5/4/2022


4860


INPRS

General Fund

5141.9


$ (0.01)


$ (0.01)


C4860


Rounding Adjustment 4/11/2022


5/10/2022


4820


Amazon

General Fund

5420.5


$ 399.00


$ 399.00


C4820

Kulana Lua Single Speed Tandem Cruiser Bike

26"-Partners for clean Air Luncheon Giveaway


5/10/2022


4821


Amazon

General Fund

5420.5


$ 339.15


$ 339.15


C4821

Greenworks 40V 20" Cordless (2-in-1) Push

Lawnmower-Partners for Clean Air


5/10/2022


4903


Cardmember Services

General Fund 5410.9


$ 359.96


$ 359.96


C4903

Southwest Airlines- NY-Luther, Kathy-Serve on

Workshop Panel on preparing Climate Change Driven population growth


5/10/2022


4857


Chicago Tribune


General Fund


$ 55.44


$ 55.44


C4857


Newspaper Subscription


5/10/2022


4793


Eventbrite

General Fund

5410.1


$ 22.85


$ 22.85


C4793

LAI Ely member registration-April 2022 Monthly

Program- Warner, Ty


5/10/2022


4777

Gov't Finance Officers

Association

General Fund

5146.9


$ 85.00


$ 85.00


C4777

Intro to Gov Accounting for Accounts Virtual

3/24/22- Kuziela/Stephanie


5/10/2022


4851


Hootsuite

General Fund

5410.2


$ 588.00


$ 588.00


C4851

Renewal- Professional Plan Annual-

Hootsuite's


5/10/2022


4856


Purdue University Parking

General Fund

5410.2


$ 10.00


$ 10.00


C4856


Parking-Purdue Road School-Luther, Kathy


5/10/2022


4858


Stamps

General Fund

5259


$ 24.99


$ 24.99


C4858


Stamps


5/12/2022


5929


IN Dept Revenue

General Fund

2143.0


$ 1,565.25


$ 1,565.25


C5929


LwtIN, SwtIN-State Tax Withholdings Payable



5/12/2022


5929


IN Dept Revenue

General Fund

2144.0


$ 366.64


$ 366.64


C5929


LwtIN, SwtIN-Local Tax Withholdings Payable


5/12/2022


5935


IN Dept Revenue

General Fund

2143.0


$ 2.42


$ 2.42


C5935


LwtIN, SwtIN State Tax Withholdings Payable


5/12/2022


5935


IN Dept Revenue

General Fund

2144.0


$ 0.38


$ 0.38


C5935


LwtIN, Local Tax Withholdings Payable


5/12/2022


5975


IN Dept Revenue

General Fund

2143.0


$ 1,567.55


$ 1,567.55


C5975


LwtIN, SwtIN-State Tax Withholdings Payable


5/12/2022


5975


IN Dept Revenue

General Fund

2144.0


$ 367.71


$ 367.71


C5975


LwtIN, SwtIN-Local Tax Withholdings Payable


5/17/2022


6011


Federal & FICA

General Fund

2140.0


$ 4,943.10


$ 4,943.10


C6011

FWT, empfica, empficamed, fica, ficamed-

Federal Tax Withholdings Payable


5/17/2022


6011


Federal & FICA

General Fund

2142.0


$ 7,658.88


$ 7,658.88


C6011

FWT, empfica, empficamed,fica,ficamed-FICA

Tax Withholdings Payable


5/17/2022


6014


Horizon Bank

General Fund

2150.0


$ 700.53


$ 700.53


C6014


HSA


5/17/2022


4871


INPRS

General Fund

5141.9


$ (0.01)


$ (0.01)


C4871


Rounding Adjustment 4/25/2022


5/17/2022


4873


MissionSquare Retirement

General Fund

5145.9


$ 934.36


$ 934.36


C4873


ER paid for Ty Warner 4/25/2022-5/8/2022


5/17/2022


6015


MissionSquare Retirement

General Fund

2146.0


$ 830.00


$ 830.00


C6015


ICMA


5/17/2022



Payroll



$ 38,410.36


$ 38,410.36



Payroll


5/17/2022


4863


Total Disposal

General Fund

5223.9


$ 79.92


$ 79.92


C4863


Recycle/Garbage-MAY


5/18/2022


4876


DeLage

General Fund

5243.9


$ 3,723.91


$ 3,723.91


C4876


IT


5/18/2022


4876


DeLage

General Fund

5241.9


$ 842.74


$ 842.74


C4876


Copier


5/18/2022


4876


DeLage

General Fund

5910.0


$ 206.25


$ 206.25


C4876


M365


5/18/2022


6013


INPRS

General Fund

2149.0


$ 6,503.95


$ 6,503.95


C6013


INPRS


5/19/2022


4854

Blachy, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,750.00


$ 1,750.00


2992


Legal-MAY


5/19/2022


4897


Bryco Services

General Fund

5223.9


$ 1,425.00


$ 1,425.00


2993


Office Cleaning-MAY


5/19/2022


4844


City of Portage

General Fund

5221.9


$ 19,725.67


$ 19,725.67


2994


Lease-MAY


5/19/2022


4866


Comcast

General Fund

5244.9


$ 156.25


$ 156.25


C4866


Business Internet-MAY


5/19/2022


4902


Drive Clean Indiana, Inc.

General Fund

5610.5


$ 77,982.00


$ 77,982.00


2995

CMAQ Air Quality public ed QRTLY Jan 1-Mar

31, 2022


5/19/2022


4850

Gov't Finance Officers

Association

General Fund

5146.9


$ 160.00


$ 160.00


2996

Membership Renewal 5/1/22-4/30/23-

Jones,Talaya


5/19/2022


4845


Kansas City Life Insurance Co.

General Fund

5143.9


$ 1,024.18


$ 1,024.18


2997

S-T Disability Insurance/ L-T Disability

Insurance


5/19/2022


4875


Paramount Dental

General Fund

2153.0


$ 751.05


$ 751.05


2998


Dental Insurance-MAY


5/19/2022


4815


Possibility Place Nursery

General Fund

5610.5


$ 15,547.50


$ 15,547.50


2999

through the US Forestry Grant Spring 2022

planting


5/19/2022


4814


TIP Strategies, Inc

General Fund

5610.3


$ 13,375.00


$ 13,375.00


3000

Consulting Services for Economic Resiliency

Plan


5/19/2022


6016


United Way of NWI

General Fund

2147.0


$ 33.85


$ 33.85


3001


United Way


5/19/2022


6009


United Way of NWI

General Fund

2147.0


$ 33.85


$ 33.85


3001


United Way


5/19/2022


4864


Valpo Chamber of Commerce

General Fund

5410.1


$ 20.00


$ 20.00


3002


VEDC Breakfast-Warner, Ty


5/19/2022


4817


Woody Warehouse Nursery, Inc

General Fund

5610.5


$ 31,975.25


$ 31,975.25


3003

through the US Forestry Grant Spring 2022

planting



5/20/2022


4870


Birchfield, Jennifer

General Fund

5410.5


$ 111.24


$ 111.24


C4870

Supplies-Wood and Supplies for tree unloading

ramp for Communi Tree Grant


5/20/2022


4865


Ecointeractive, Inc

General Fund

5610.5


$ 3,978.00


$ 3,978.00


C4865


TIP SAAS service monthly


5/20/2022


4861


Fidelity EyeMed

General Fund

2154.0


$ 85.25


$ 85.25


C4861


Vision Insurance


5/20/2022


4900


Hammond, Allen

General Fund

5410.2


$ 99.96


$ 99.96


C4900


Mileage-Various-Vehicle Inspections


5/20/2022


4855


Kane, Denarie

General Fund

5410.3


$ 54.94


$ 54.94


C4855

Mileage-Various Locations 4/1-4/21/22

Distributing Loan flyers


5/20/2022


4901


Todd, Lisa

General Fund

5410.2


$ 99.96


$ 99.96


C4901


Mileage-Various-Vehicle Inspections


5/20/2022


4853


Warner, Ty

General Fund

5244.9


$ 150.00


$ 150.00


C4853


Communication Expense -May


5/20/2022


4847


Warner, Ty

General Fund

5410.9


$ 280.74


$ 280.74


C4847


Flights to Buffalo NY for NY SeaGrant Panel


5/20/2022


4868


Warner, Ty

General Fund

5410.9


$ 50.74


$ 50.74


C4868


Mileage-NIRPC to Midway RT-Buffalo Trip


5/20/2022


4869


Warner, Ty

General Fund

5410.9


$ 2,056.25


$ 2,056.25


C4869

Livable Communities Forum/RARE Leadership

registration


5/20/2022


4846


Warner, Ty

General Fund

5410.9


$ 70.80


$ 70.80


C4846

Mileage-NIRPC to CHI- LAI Program/Clean Air

Partnership


5/27/2022


4886


City of LaPorte

General Fund

5760.0


$ 6,872.00


$ 6,872.00


C4886


LaPorte Reimb for OA Jan-Mar 2022


5/27/2022


4906


City of LaPorte

General Fund

5760..0


$ 60,196.00


$ 60,196.00


C4906


OA Jan-Mar 2022 Draw 40-22


5/27/2022


4878


City of Valparaiso

General Fund

5760.0


$ 60,814.00


$ 60,814.00


C4878


Valpo Reimb for CCC-VLine Jan-Mar 2022


5/27/2022


4877


City of Valparaiso

General Fund

5760.0


$ 49,066.00


$ 49,066.00


C4877


Valpo Reimb for CMAQ Jan-Mar 2022


5/27/2022


4879


City of Valparaiso

General Fund

5760.0


$ 52,452.00


$ 52,452.00


C4879


Valpo Reimb for CCC-DASH Jan-Mar 2022


5/27/2022


4889


East Chicago Transit

General Fund

5760.0


$ 42,463.00


$ 42,463.00


C4889


ECT Reimb for PM Jan-Mar 2022


5/27/2022


4890


East Chicago Transit

General Fund

5760.0


$ 55,414.00


$ 55,414.00


C4890


ECT Reimb for Paratransit Jan-Mar 2022


5/27/2022


4891


East Chicago Transit

General Fund

5760.0


$ 31,059.00


$ 31,059.00


C4891


ECT Reimb for OA Jan-Mar 2022


5/27/2022


4888

Lake County Community

Services, Inc.

General Fund

5760.0


$ 17,779.00


$ 17,779.00


C4888


SLCCS Reimb for PM Jan-Mar 2022


5/27/2022


4887

Lake County Community

Services, Inc.

General Fund

5760.0


$ 81,927.00


$ 81,927.00


C4887


SLCCS Reimb for EMOA Jan-Mar 2022


5/27/2022


4885


North Township

General Fund

5760.0


$ 9,829.00


$ 9,829.00


C4885


NT Reimb for PM Jan-Mar 2022


5/27/2022


4884


North Township

General Fund

5760.0


$ 41,953.00


$ 41,953.00


C4884


NT Reimb for OA Jan-Mar 2022


5/27/2022


4893


Opportunity Enterprise

General Fund

5760.0


$ 14,171.00


$ 14,171.00


C4893


OE Reimb for PM Jan-Mar 2022


5/27/2022


4892


Opportunity Enterprise

General Fund

5760.0


$ 8,259.00


$ 8,259.00


C4892


OE Reimb for PM Jan-Mar 2022


5/27/2022


4881

Porter County Aging and

Community Services

General Fund

5760.0


$ 1,038.00


$ 1,038.00


C4881


PCACS Reimb for OA Jan-Mar 2022


5/27/2022


4880

Porter County Aging and

Community Services

General Fund

5760.0


$ 3,064.00


$ 3,064.00


C4880


PCACS Reimb for PM Jan-Mar 2022


5/27/2022


4883

Porter County Aging and

Community Services

General Fund

5760.0


$ 15,829.00


$ 15,829.00


C4883


PCACS Reimb for EMOA Jan-Mar 2022


5/27/2022


4882

Porter County Aging and

Community Services

General Fund

5760.0


$ 5,689.00


$ 5,689.00


C4882


PCACS Reimb for EMOA Jan-Mar 2022


5/31/2022


6033


Federal & FICA

General Fund

2140.0


$ 5,163.60


$ 5,163.60


C6033

FWT, empfica, empficamed, fica, ficamed-

Federal Tax Withholdings Payable


5/31/2022


6033


Federal & FICA

General Fund

2142.0


$ 7,862.28


$ 7,862.28


C6033

FWT, empfica, empficamed, fica, ficamed-FICA

Tax Withholdings Payable



5/31/2022


6036


Horizon Bank

General Fund

2150.0


$ 700.53


$ 700.53


C6036


HSA


5/31/2022


4904


MissionSquare Retirement

General Fund

5145.9


$ 934.36


$ 934.36


C4904


ER paid for Ty Warner 5/9/2022-5/22/2022


5/31/2022


C6037


MissionSquare Retirement

General Fund

2146.0


$ 830.00


$ 830.00


C6037


ICMA


5/31/2022



Payroll


General Fund


$ 39,421.49


$ 39,421.49



Payroll


Total:

$ 929,673.30


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 $ 929,673.30

image


Dated this         day of          , 2022.


image

Chairperson


image

Treasurer

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

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

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


5/10/2022


4783


Fry Specialty Inc

CARES Fund 5430.9


$ 140.70


$ 140.70


C4783


Automatic Hand Sanitizer Dispenser


5/26/2022


4867


Best Servers

CARES Fund 5960.0


$ 68.75


$ 68.75


3004


RouteMatch server assistance for NT


5/27/2022


4836


CDW-G

CARES Fund 5910.0


$ 1,842.27


$ 1,842.27


C4836

Microsoft Surface Pro 8-13"/Microsoft complete extended warranty/Microsoft Pro Signature Keyboard


5/27/2022


4894


RouteMatch

CARES Fund 5960.0


$ 5,100.00


$ 5,100.00


C4894


LCCS 18 Licenses/NT 8 Licenses


5/27/2022


4895


RouteMatch

CARES Fund 5960.0


$ 1,534.00


$ 1,534.00


C4895


LCCS 18 Licenses/NT 8 Licenses


Total:


$ 8,685.72



Allowance of Claims:

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

register such claims are hereby allowed in the total amount of $ 8,685.72

image


Dated this         day of          , 2022.


image

Chairperson


image

Treasurer

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

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


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


5/19/2022


4814


TIP Strategies, Inc

RLF Fund

5610.3


$ 13,375.00


$ 13,375.00


3000

Consulting Services for Economic Resiliency

Plan


Total:

$ 13,375.00


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 $ 13,375.00

image


Dated this         day of          , 2022.


image

Chairperson


image

Treasurer


image


Closing Balance from Previous Statement........................................................................................... 5/31/2022 279,029.10

3

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


3,131.24

-

0

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


0.00


0

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


0.00


O

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


0.00



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


0.00



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

6/30/2022

9.24


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

6/30/2022

282,169.58

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


0.00

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

6/30/2022

282,169.58

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


0.00

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


0.00

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


282,169.58


image

"6/08/2022

8272865

Hammer RLF Loan Payment



1,381.24


lf.6/08/2022

8272866

Wilson's Barbershop loan payment



1,200.00

"·6/29/2022

8272867

Downtown Delights Closing Fees



550.00




Total Deposits:


3,131.24

---


I

Reference

Adjustment Description



Amount


.,. 6/30/2022


Interest Earned








Total Adjustments:


9.24


I Date' Reference Deposit Description

-

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 7/0612022@ 12:45 PM Reconciliation - Revolving Loan Fund Page:

image

Amount


Date


1Y

511(

7/&/JJ /\

Trial Balance - Cash

Run: 710612022 at 12:41!'0RTHWESTERN IN DIANA REGIONAL PLANNING COMMISSION

For 6/30/2022


Page: 1



All 2.3.050.0000.1010.0 LaPorte Cash

Total


Balance 282,169.58

282,169.58


/21(

7/t/JJ

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 7/0612022@ 12:43 PM Reconciliation - CARES RLF Bank Account


Page:

image

---



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


5/31/2022

---

image

8,008.67


3

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


46,970.87

O

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


0.00

O

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


0.00

0

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


0.00


Service Charge.................................•.....................................................................


0.00


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

6/30/2022

0.18


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

image

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


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

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

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

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


image

image

[ Date Reference Deposit Description

6/30/2022


6/30/2022

54,979.72

0.00


54,979.72

0.00

0.00

54,979.72


Amount

rf..6/08/2022

8272863

Healthy Smiles June '22 RLF Payment


805.25

,1: 6/09/2022

8272862

Divine Strategy June 2022 CARES RLF payment


1,013.00

i 6/29/2022

8272864

Divine Strategy Repayment of Loan


45,152.62




Total Deposits:

46,970.87

---

[ Date Reference Adjustment Description

image

rf. 6/30/2022 Interest Earned


Total Adjustments:

Amount

0.18

image

0.18



image

s1,i/d;i

I\!\f

Trial Balance - Cash

Run: 11os12022 at 12:4J'i'QRTHWESTERN IN DIANA REGIONAL PLANNING COMMISSION

For 6/30/2022


Page: 1



All 4.3.050.0000.1010.0 CARES RLF Cash

Total


Balance

  54,979.72

54,979.72


151/c

1/t/rJJ



image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 7/06/2022@ 1:28 PM Reconciliation - General Page:

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

5/31/2022

1,206,704.35


9

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


401,936.88

112

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


222,748.49

0

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


0.00


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


395.00


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

6/10/2022

120.85


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

6/30/2022

57.20

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

6/30/2022

1,386,224.09 '?i..

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


0.00

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

6/30/2022

1,299,280.02

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


(86,944.07)

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


0.00

General Ledger Reconciliation 10 Statement..............................................................................................


1,386,224.09


image

I·,Date

Reference

image

- 'f ,,jc'

Qeposit Description Amount

v

.• 6/03/2022 8272869

610812022 8272870

V·•610812022 8272871

V••611312022 8272872

V 612112022 8272873

V. 6/24/2022 8272875

.•6/24/2022 8272876

,.6/27/2022 8272874

·•6/29/2022 8272877

CARES Reimb for NIRPC Hand santizer OE Support Equip Lease Payment

Porter County solid waste Gas Can Payment 2021 Valpo Lease Equip Payment

KRBC Accounting Services April FTA Reimb Rou1eMa1ch July 2022

FTA Reimb AccuFund July-Sept 2022 Lake County 2022 Distributions Institutional Grant Reimb April-May 2022

141.00

23.00

1,596.00

18.00

1,428.00

1,534.00

1,361.00

347,204.00

48,631.88

image

Total Deposits: 401,936.88


image

, Date Ctieck To Check Description Amount


image

7/02/2019 0002363

8/27/2019 0002409

3/23/2021 0002764


4/07/2022 0002975

5/19/2022 0002994

5/19/2022 0002996


6/08/2022 0003008

6/22/2022 0003014

Kelly Tripp

United Way of Northwest Indiana

American of Metropolitan Planning Organization

City of Portage, The City of Portage, The

Gov't Finance Officers Association


City of Portage, The Depauw University

Refund fee for tree steward workshop 8/5 - 8/18/2019 pay period - United Way

NIRPC-Job Posting Director of Transportaion


Lease-APR Lease-MAY

Membership Renewal 5/1/22-4/30/23-Jones, T

Lease-June

2022 Partners for Clean Air Scholarship­ Bognar

28.83

33.85

50.00


19,725.67

19,725.67 /

160.00


19,725.67

2,500.00

6/22/2022 0003015

6/22/2022 0003017

6/22/2022 0003019

6/22/2022 0003021

Drive Clean Indiana, Inc One Region

ROG Planning & Design, Inc. United Way of Northwest Indiana

CMAQ Air quality Public ED- April 26, 2022 10,374.00 , 2 Day T.O.D Bus Trio -Aug 2022-Warner, T 285.00

Invoices 50869, 51126, 51127 14,301.53

Pay period ending 6/05/2022,United Way 33.85

image

Total Unmarked Checks: 86,944.07 Total Checks: 86,944.07

Date Reference Adjustment 9escription Amount

image

v··611012022

V 6/3012022

Service Charge Interest Earned

-120.85

57.20

image

Total Adjustments: -63.65


\' S-1JL 7/l/JJ

iV

I\'.\

Trial Balance - Cash

Run: 11os12022 at 1:3o NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 6/30/2022


Page: 1



All

1.1.001.0000.1010.0 General Cash

Total


Balance

1,299,280.02

1,299,280.02


v/5i /l

7/i/J1

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2022 Budget


YTD June FY 22 Budget % Expended balance


Salaries




5020-1

Total Salaries

1,530,748

644,985 58%


Salaries Sub-Total

1,530,748

644,985 58%


Fringe Benefits

5121-9

FICA Contributions

121,685

49,111

60%

5122-9

Workers Compensation

5,000

2,539

49%

5123-9

Unemployment Compensation

3,000

956

68%

5141-9

PERF Contributions

199,688

82,360

59%

5142-9

Health Insurance

240,000

85,565

64%

5143-9

Life & Disability Insurance

24,000

7,040

71%

5145-9

ICMA

24,480

11,212

54%

5146-9

Staff Development

20,000

2,237

89%


Fringe Benefits Sub-Total

637,853

241,022

62%


Occupancy

5221-9

Office Lease

236,708

118,354

50%

5222-9

Property Insurance

6,500

4,880

25%

5223-9

Building Maintenance

18,540

9,018

51%

5224-9

Utilities

30,650

3,456

89%


Occupancy Sub-Total

292,398

135,708

54%


Maintenance

5241-9

Copier Leasing/Maintenance

18,000

5,899

67%

5243-9

Computer Service/Maintenance

43,736

26,067

40%

5244-9

Telephone Service/Maintenance

18,900

5,574

71%


Combined Copier/IT/Phone Service/Maintenance

80,636

37,540

53%

5249-9

Other Equipment Maintenance

2,000

250

88%


Maintenance Sub-Total

82,636

37,790

54%

Departmental

5410-1

Communications: Commission/Ex. Dir.

35,000

9,792

72%

5410-2

Communications: Transportation

239,000

17,523

93%

5410-3

Economic Development District

29,583

40

100%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

28,947

2,373

92%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

25,000

15,938

36%

5420-5

Promotional Expenses: Environmental Programs

14,953

9,733

35%

5430-9

General Use Supplies Expense

5,000

1,353

73%


Departmental Sub-Total

403,483

56,751

86%


Contractual

5602-9

Legal Services

23,400

10,500

55%

5603-9

Audit and Accounting

70,000

63

100%

5604-9

LaPorte RLF Services

2,000

0

100%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,314

336,718

60%

5610-2

Planning

320,000

50,973

84%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

95,009

15,912

83%


Contractual Sub-Total

1,369,070

414,165

70%


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

1,530,420 66%


LaPorte Revolving Loan Fund

150,000

0


Transit Capital Fund

142,080

332,521


Transit Operating Fund

4,438,881


image

1,317,297

9,201,349

3,180,238

TOTAL EXPENDITURES


image

27



image

YTD June 2022 Expenses Budget vs Actual

800,000

765,374

700,000 CARES FUND EXPENDITU64R4E,9S85

600,000

684,535

500,000

414,165

400,000

318,927

300,000

241,022

201,742

200,000

146,199

135,708

56,751

100,000

41,318 37,790

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD June Budget YTD June Expended

image

YTD June 2022 Expended by Category

Contractuals

27%

Salaries

42%

Departmental

4%

Maintenance 2%

Fringe Benefits

16%

Occupancy

9%

Salaries

Fringe Benefits Occupancy Maintenance Departmental Contractuals

28

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2022 Budget

YTD June 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

56,335

840,048

94%

1.1.4310

State Agencies

2,668,379

376,110

2,292,269

86%

1.1.4410

Local Agencies

76,760

6,566

70,194

91%

1.1.4610

Non-Governmental

48,513

3,226

45,287

93%

1.3.4260

Economic Development District

70,000

19,078

50,922

73%

1.1.4800

Interest Income

10,800

3,634

7,166

66%


Revenue Total

4,311,106

1,005,221

3,305,885

77%


image

Revenue by Funding Source as of June 30, 2022

Local Agencies

1%

State Agencies

37%

Non-Governmental

0%

Federal

Agencies 6%

Economic

Development District 2%

Interest Income 0%

County Appropriations

54%

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



Line Items


FY 2022 Budget

YTD June

Expended

FY 22 Budget %

balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

59,900

26,504

56%

Salaries Sub-Total

59,900

26,504

56%


image

image

YTD June 2022 Expenses Budget vs Actual

120,000

100,000

101,000

80,000

59,900

60,000

53,500

40,000

26,504

25,800

20,000

7,215

3,168

636

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

Contractual

EDD Institutional CARES ACT

101,000

53,500

47%

Contractual Sub-Total

101,000

53,500

47%

Departmental




Communications

3,168

496

84%

PPE Supplies & Office Supplies


141

0%

Departmental Sub-Total

3,168

636

80%


Capital Outlays




Furniture and Equipment

25,800

7,215

72%

Capital Outlays Sub-Total

25,800

7,215

72%


TOTAL NIRPC CARES FUND EXPENDITURES

189,868

87,855

54%


CARES Revolving Loan Fund

461,648

50,709


CARES Transit Capital Fund

491,999

75,392


CARES Transit Agency Fund

10,000

10,000


TOTAL EXPENDITURES

1,153,515

223,956


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2022 Budget

YTD June

Collected


FY 22 Budget % balance

CARES ACT OPERATING




Operating Revenue

25,800

6,809

74%


EDD RLF Revenue

477,992

2,600

99%

CARES ACT RLF


image

Revenue by Funding Source as of June 30, 2022

CARES Operating

2%

CARES Transit Capital

28%

Economic Development

District 45%

CARES Transit

Agency 4%

NWI Recover RLF (CARES

RLF) 21%

CARES Operating

Economic Development District NWI Recover RLF (CARES RLF)

CARES Transit Agency

CARES Transit Capital

Economic Development District

304,553

122,564

60%


808,345

131,973

84%

CARES ACT EDA


CARES ACT RLF

Loan Proceeds

32,085

50,000

-56%

CARES ACT RLF

Loan Application Fees & Interest

9,800

2,917

70%

CARES AGENCY

FTA Revenue

10,000

10,000

0%

CARES TRANSIT CAPITAL

FTA Revenue

491,999

75,392

85%


Revenue Total

     1,352,229    

270,282      

80%    


NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

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

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


6/1/2022


4905


INPRS

General Fund 5141.9


$ 0.01


$ 0.01


C4905


Rounding Adjustment 5/9-5/22/2022 pr 5/31/2022


6/1/2022


6035


INPRS

General Fund

2149.0


$ 6,498.00


$ 6,498.00


C6035


EmpPerf [NIRPC]


6/2/2022


4914


Anthem Life

General Fund

2155.0


$ 122.50


$ 122.50


C4914


EE paid for Life Insurance June


6/2/2022


4914


Anthem Life

General Fund

5143.9


$ 395.23


$ 395.23


C4914


ER paid for Life Insurance June


6/3/2022


4924


United HealthCare Srvcs.

General Fund

5142.9


$ 11,994.85


$ 11,994.85


C4924


ER paid for Health Insurance June


6/3/2022


4924


United HealthCare Srvcs.

General Fund

2152.0


$ 2,116.74


$ 2,116.74


C4924


EE paid for Health Insurance June


6/6/2022


4932


Dialpad

General Fund

5244.9


$ 654.33


$ 654.33


C4932


Telephone Services- JUNE


6/8/2022


4898


Adams Radio Group

General Fund

5610.5


$ 3,144.00


$ 3,144.00


3005


Radio Remote including 3hr live 4/20-9am to 12n


6/8/2022


4922

Blachly, Tabor, Bozik & Hartman,

LCC

General Fund

5602.9


$ 1,750.00


$ 1,750.00


3006


Legal-June


6/8/2022


4916


Breitenfeldt, Charles


General Fund 5420.5


$ 27.00


$ 27.00


3007

Reimbursement for the expense of replacing a leaky tire tube on the Tandem Bike purchased by NIRPC for the Partners for Clean Air Luncheon.


6/8/2022


4920


City of Portage

General Fund

5221.9


$ 19,725.67


$ 19,725.67


3008


Lease- June


6/8/2022


4941


Geosyntec Consultants


General Fund 5610.5


$ 15,467.63


$ 15,467.63


3009

Technical Green Infrastructure Guidelines for

Transportation Project/Stormwater Performance Standard/MEP Worksheet/Develop and Design Manual/Add'l Cost


6/8/2022


4913


Kansas City Life Insurance Co.

General Fund

5143.9


$ 895.42


$ 895.42


3010


S-T Disability Insurance/L-T Disability Insurance


6/8/2022


4923


Paramount Dental

General Fund

2153.0


$ 751.05


$ 751.05


3011


Dental Insurance- June


6/8/2022


6038


United Way

General Fund

21470


$ 33.85


$ 33.85


3012


United Way


6/9/2022


4937


Barloga, Mitchell

General Fund

5410.2


$ 140.28


$ 140.28


C4937


Mileage-NIRPC to Valpo (RT)/NIRPC to Carmel, IN (RT)


6/9/2022


4934


Barloga, Mitchell


General Fund 5410.2


$ 3,112.87


$ 3,112.87


C4934


Travel-Hotel, Hampton Inn Carmel, IN/Per Diem-Carmel, IN/Hotel 4nights OMNI/Airfare-including Thomas Dow

/Registration /Orientation Tour/Workshop/Per Diem San

Diego first and last night/Breakfast/Lunch/Dinner/Transport to hotel via Lyft


6/9/2022


4926


Eklund, Candice

General Fund

5410.0


$ 22.68


$ 22.68


C4926


Mileage- TROC LaPorte Committee Meeting (RT)


6/9/2022


4917


Fidelity EyeMed Vision Ins.

General Fund

2154.0


$ 85.25


$ 85.25


C4917


Vision Insurance-June


6/9/2022


4936


Kane, Denarie

General Fund

5410.3


$ 13.02


$ 13.02


C4936


Mileage-NIRPC to Valpo (RT)


6/9/2022


4935


Kane, Denarie


General Fund 5410.3


$ 94.50


$ 94.50


C4935


Mileage-Various NIRPC to US 30 area east of SR 49 (RT)/NIRPC to Hebron (RT)/NIRPC to Kouts/Morgan/ Pleasant TWP (RT) NIRPC to areas on US 30 Sturdy Rd. South/NIRPC to W US 6 Portage & SR 49 areas


6/9/2022


4927


Warner, Ty

General Fund

5410.9


$ 205.32


$ 205.32


C4927


Mileage-NIRPC to Chicago (RT)/Morgan TWP to INDI (RT)


6/9/2022


4918


Warner, Ty

General Fund

5244.9


$ 150.00


$ 150.00


C4918


Communication Expense-June


6/9/2022


4928


Warner, Ty

General Fund 5410.9


$ 288.79


$ 288.79


C4928

Travel- Tolls University of Chicago (Speaking)/Per Diem

INDI 1st day /last day travel/Hotel MPO Council/Hotel Parking


6/10/2022


4848


ARPA-Audit Readiness for Auditees

General Fund 5410.9


$ 249.00


$ 249.00


CC4848


2022 Single Audit Readiness for Auditees (ARPA) Jones, T


6/10/2022


4919


Chicago Tribune

General Fund

5410.1


$ 27.72


$ 27.72


CC4919


Newspaper Subscription


6/10/2022


4939


Comcast

General Fund

5244.9


$ 156.25


$ 156.25


C4939


Business Internet


6/10/2022


4947


Constant Contact, Inc.

General Fund

5410.2


$ 714.00


$ 714.00


CC4947


4-Email Plus Subscriptions


6/10/2022


4925


DeLage

General Fund

5243.9


$ 3,723.91


$ 3,723.91


C4925


IT


6/10/2022


4925


DeLage


General Fund 5241.9


$ 842.74


$ 842.74


C4925


Copier

32



6/10/2022


4925


DeLage

General Fund

5910.0


$ 206.25


$ 206.25


C4925


M365


6/10/2022


4912


GoDaddy

General Fund

5410.9


$ 0.18


$ 0.18


CC4912

1 year Renewal of Domain Name NIRPC.ORG-price

increase .18cents


6/10/2022


4842


GoDaddy

General Fund

5410.9


$ 20.99


$ 20.99


CC4842


1 year Renewal of Domain Name NIRPC.ORG


6/10/2022


4739


Gov't Finance Officers Association

General Fund

5146.9


$ 150.00


$ 150.00


CC4739


Membership dues 2/1/22-1/31/2023-Kuziela/S


6/10/2022


4943


My City Bikes

General Fund

5610.2


$ 1,539.00


$ 1,539.00


C4943


Annual Maintenance Fee- June


6/10/2022


4921


Stamps

General Fund

5249.9


$ 24.99


$ 24.99


CC4921


Stamps


6/10/2022


4830


USflagstore.com

General Fund

5430.9


$ 149.38


$ 149.38


CC4830


Indiana State Flags


6/14/2022


6086


Federal & Fica


General Fund 2140.0


$ 4,935.43


$ 4,935.43


C6086

Pay period ending 6/5/2022-FWT,empfica, empficamed, fica, ficamed-Federal Tax Withholdings Payable


6/14/2022


6086


Federal & Fica

General Fund 2142.0


$ 7,632.98


$ 7,632.98


C6086

Pay period ending 6/5/2022-FWT,empfica, empficamed, fica, ficamed-FICA Tax Withholdings Payable


6/14/2022


6089


Horizon Bank

General Fund

2150.0


$ 700.53


$ 700.53


C6089


Pay period ending 6/5/2022-HSA


6/14/2022


6090


MissionSquare Retirement


General Fund 2146.0


$ 830.00


$ 830.00


C6090


Pay period ending 6/5/2022-ICMA


6/14/2022


4942


MissionSquare Retirement

General Fund

5145.9


$ 934.36


$ 934.36


C4942


ER paid for Ty Warner 5/23/2022-6/5/2022

6/14/2022


Payroll

General Fund

$ 38,283.69

$ 38,283.69


Payroll


6/15/2022


6088


INPRS

General Fund

2149.0


$ 6,503.94


$ 6,503.94


C6088


Pay period ending 6/5/200, EmpPerf [NIRPC]


6/16/2022


4950


Total Disposal

General Fund

5223.9


$ 79.92


$ 79.92


C4950


Recycle- Garbage-June


6/17/2022


6034


IN Dept of Rev

General Fund

2143.0


$ 1,626.81


$ 1,626.81


C6034


LwtIN, SwtIN-State Tax Withholding Payable


6/17/2022


6034


IN Dept of Rev

General Fund

2144.0


$ 380.49


$ 380.49


C6034


LwtIN, SwtIN-Local Tax Withholding Payable


6/17/2022


6012


IN Dept of Rev

General Fund

2143.0


$ 1,580.47


$ 1,580.47


C6012


LwtIN, SwtIN-State Tax Withholding Payable


6/17/2022


6012


IN Dept of Rev


General Fund 2144.0


$ 369.71


$ 369.71


C6012


LwtIN, SwtIN-Local Tax Withholding Payable


6/17/2022


6005


IN Dept of Rev

General Fund

2143.0


$ 1,567.55


$ 1,567.55


C6005


LwtIN, SwtIN-State Tax Withholding Payable


6/17/2022


6005


IN Dept of Rev

General Fund

2144.0


$ 367.71


$ 367.71


C6005


LwtIN, SwtIN-Local Tax Withholding Payable


6/22/2022


4946


Bryco

General Fund

5223.9


$ 1,425.00


$ 1,425.00


3013


Office Cleaning-Jun


6/22/2022


4962


Depauw University

General Fund

5420.5


$ 2,500.00


$ 2,500.00


3018


2022 Partners for Clean Air Scholarship-Bognar, M


6/22/2022


4955


Drive Clean Indiana, Inc

General Fund

5610.5


$ 10,374.00


$ 10,374.00


3015


CMAQ Air quality Public Ed April 26, 2022


6/22/2022


4963


Geosyntec Consultants


General Fund 5610.0


$ 13,639.72


$ 13,639.72


3016

Technical Green Infrastructure Guidelines for

Transportation Project/Stormwater Performance Standard/MEP Worksheet/Develop and Design Manual/Add'l Cost


6/22/2022


4956


One Region

General Fund

5410.9


$ 285.00


$ 285.00


3017


2 Day T.O.D. Bus Trip-Warner, Ty


6/22/2022


4960


Purdue University West Lafayette

General Fund

5420.5


$ 2,500.00


$ 2,500.00


3023


2022 Partners for Clean Air Scholarship-Lemmons, G


6/22/2022


4961


Purdue University West Lafayette

General Fund

5420.5


$ 2,500.00


$ 2,500.00


3018


2022 Partners for Clean Air Scholarship-Osbourn, N


6/22/2022


4952


RDG

General Fund

5610.2


$ 2,960.10


$ 2,960.10


3019


Land use-Finding Meaning-APR


6/22/2022


4953


RDG

General Fund

5610.2


$ 2,960.10


$ 2,960.10


3019


Land use-Finding Meaning-May


6/22/2022


4954


RDG

General Fund

5610.2


$ 8,381.33


$ 8,381.33


3019


Trans-Finding Meaning/Reimbursable Expense-May


6/22/2022


4938


The Arsh Group Inc

General Fund

5610.2


$ 6,250.00


$ 6,250.00


3020

E-Commerce Subarea Plan for Gary, IN-Task 1-Existing

Conditions/Task 2- Market Study


6/22/2022


6091


United Way

General Fund

2147.0


$ 33.85


$ 33.85


3021


United Way


6/23/2022


4948


Bradsky III, Charles

General Fund 5410.2


$ 39.48


$ 39.48


C4948

Mileage-NIRPC to LaPorte TROC meeting (RT) NIRPC to Highland Meeting w/various Fire Dept.


6/23/2022


4959


Dow, Thomas

General Fund

5410.2


$ 60.00


$ 60.00


C4959


Canopy for pop-up Events-NIRPC Transportation


6/23/2022


4951


Ecointeractive, Inc

General Fund

5610.5


$ 3,978.00


$ 3,978.00


C4951


TIP SAAS Service-June


6/23/2022


4949


Polette, Keven


General Fund 5410.2


$ 57.96


$ 57.96


C4949


Mileage-Various NIRPC to LaPorte County TROC meeting, NIRPC to Joliet RD and US 30-INDOT Road Safety/Joliet and US 30 to US 6/US and Old Suman to US 35 and 250S/US 35 and 250S to NIRPC


6/23/2022


4964


Warner, Ty

General Fund 5410.9


$ 271.00


$ 271.00


C4964

Travel-Columbus, OH Per Diem 1st day of travel, M & IE,

Less Breakfast & Lunch, Incidentals only, Last day of travel, Parking, Hilton Downtown Columbus, OH


6/23/2022


4965


Warner, Ty

General Fund

5410.9


$ 365.80


$ 365.80


C4965


Mileage-Morgan TWP to Columbus, OH (RT)



6/28/2022


6106


Federal & Fica


General Fund 2140.0


$ 926.70


$ 926.70


C6106


Pay period ending 6/19/2022, FWT,empfica, empficamed, fica, ficamed-Federal Tax Withholdings Payable


6/28/2022


6106


Federal & Fica

General Fund 2142.0


$ 1,056.66


$ 1,056.66


C6106

Pay period ending 6/19/2022, FWT,empfica, empficamed, fica, ficamed-FICA Tax Withholdings Payable


6/28/2022


6103


Federal & Fica

General Fund 2140.0


$ 83.77


$ 83.77


C6103

Pay period ending 6/19/2022, FWT, empfica,empficamed, fica, ficamed-Federal Tax Withholdings Payable


6/28/2022


6103


Federal & Fica

General Fund 2142.0


$ 304.70


$ 304.70


C6103

Pay period ending 6/19/2022, FWT, empfica,empficamed, fica, ficamed-FICA Tax Withholdings Payable


6/28/2022


6125


Federal & Fica

General Fund 2140.0


$ 4,793.70


$ 4,793.70


C6125

Pay period ending 6/19/2022, FWT, empfica, empficmed, fica, ficamed-Federal Tax Withholdings Payable


6/28/2022


6125


Federal & Fica

General Fund 2142.0


$ 7,339.54


$ 7,339.54


C6125

Payable ending 6/19/2022, FWT, empfica, empficamed, fica, ficamed-FICA Tax Withholdings Payable


6/28/2022


6128


Horizon Bank

General Fund

2150.0


$ 500.53


$ 500.53


C6128


Pay period ending 6/19/2022, HSA


6/28/2022


4958


MissionSquare Retirement

General Fund

5145.9


$ 934.36


$ 934.36


C4958


ER paid for Ty Warner 6/6/2022-6/19/2022


6/28/2022


6129


MissionSquare Retirement

General Fund

2146.0


$ 830.00


$ 830.00


C6129


Pay period ending 6/19/2022, ICMA

6/28/2022


Payroll

General Fund

$ 36,730.01

$ 36,730.01


Payroll

6/28/2022


Payroll

General Fund

$ 5,193.68

$ 5,193.68


Payroll- Hammond, Allen Final Payout

6/28/2022


Payroll

General Fund

$ 1,680.99

$ 1,680.99


Payroll-Hammond, Allen Final Payout


6/30/2022


6127


INPRS

General Fund

2149.0


$ 6,082.78


$ 6,082.78


C6127


Pay period ending 6/19/2022, EmpPerf[NIRPC]


6/30/2022


6105


INPRS

General Fund

2149.0


$ 282.78


$ 282.78


C6105


Pay period ending 6/19/2022, EmpPerf[NIRPC]


6/30/2022


4966


INPRS

General Fund

5141.9


$ 1.22


$ 1.22


C4966


Rounding Adjustment Hammond vacation payout





Total:

$ 266,609.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 $ 266,609.75

image


Dated this          day of          , 2022.


image

Chairperson


image

Treasurer

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


6/27/2022


4896


AccuFund

CARES Fund 5910.0


$ 1,361.04


$ 1,361.04


C4896

users/employee Portal (50 Hosted Employees)


6/27/2022


4945


RouteMatch

CARES Fund 5960.0


$ 1,534.00


$ 1,534.00


C4945

July 2022 LCCS RouteMatch/July 2022 NT RouteMatch

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


Total:

$ 2,895.04



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 $ 2,895.04

image


Dated this          day of          , 2022.


image

Chairperson


image

Treasurer

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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


image


Line Items FY 2021 Budget


YTD December Expended

FY 21

Budget % balance

image


Salaries

5020-1 Total Salaries 1,328,521 1,165,556 12%

image

Salaries Sub-Total 1,328,521 1,165,556 12%

image


Fringe Benefits

5121-9

FICA Contributions


119,742

96,834

19%

5122-9

Workers Compensation


9,500

6,429

32%

5123-9

Unemployment Compensation


3,000

1,059

65%

5141-9

PERF Contributions


200,012

165,082

17%

5142-9

Health Insurance


230,000

179,720

22%

5143-9

Life & Disability Insurance


24,000

15,325

36%

5145-9

ICMA


23,000

22,254

3%

5146-9

Staff Development


20,000

3,385

83%



Fringe Benefits Sub-Total

629,254

490,089

22%


Occupancy






5221-9

Office Lease


231,000

225,282

2%

5222-9

Property Insurance


6,500

1,319

80%

5223-9

Building Maintenance


18,540

18,579

0%

5224-9

Utilities


30,650

25,349

17%



Occupancy Sub-Total

286,690

270,529

6%


Maintenance




5241-9 Copier Leasing/Maintenance

20,370

10,113

50%

5243-9 Computer Service/Maintenance

43,736

43,190

1%

5244-9 Telephone Service/Maintenance

18,900

13,936

26%

Combined Copier/IT/Phone Service/Maintenance

83,006

67,239

19%

5249-9 Other Equipment Maintenance

2,000

1,158

42%

Maintenance Sub-Total

85,006

68,397

20%

Departmental




5410-1

Communications: Commission/Ex. Dir.

41,500

11,153

73%

5410-2

Communications: Transportation

299,000

23,615

92%

5410-3

Economic Development District

11,768

2,215

81%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

23,379

7%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

13,361

52%

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


3,687



Departmental Sub-Total

441,223

86,817

80%


Contractua


l





5602-9

Legal Services


22,200