image

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org


FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda - Thursday, October 21, 2021 -- 9:00 a.m.

ZOOM Virtual Meeting


  1. Call to Order

  2. Meeting Minutes of September 16, 2021 Pages 1-2

    ACTION REQUESTED: Approval

  3. Review of Financial Status – August 2021 Budget vs Actual Pages 3-11

    1. Bank Statement Reconciliations (pgs. 3-6)

    2. General Fund Expenses YTD August 2021 (pgs.7- 8)

    3. General Fund Revenue YTD August 2021 (pg. 9)

    4. CARES Expenses YTD August 2021 (pg. 10)

    5. CARES Revenue YTD August 2021 (pg. 11)

  4. Approval of General Fund Claims Register – August 2021 Pages 12-14

    ACTION REQUESTED: Approval

  5. Approval of CARES Act Claims Register – August 2021 Pages 15

    ACTION REQUESTED: Approval

  6. Review of Financial Status – September 2021 Budget vs Actual Pages 16-24

    1. Bank Statement Reconciliations (pgs. 16-19)

    2. General Fund Expenses YTD September 2021 (pgs. 20-21)

    3. General Fund Revenue YTD September 2021 (pg. 22)

    4. CARES Expenses YTD September 2021 (pg. 23)

    5. CARES Revenue YTD September 2021 (pg. 24)

  7. Approval of General Fund Claims Register – September 2021 Pages 25-26

    ACTION REQUESTED: Approval

  8. Approval of CARES Act Claims Register – September 2021 Pages 27

    ACTION REQUESTED: Approval

  9. Approval of RLF Claims Register – September 2021 Pages 28

    ACTION REQUESTED: Approval

  10. NIRPC 2022 Preliminary Budget Pages 29-31

  11. Personnel update

  12. Other Business

  13. Adjournment


The next meeting is scheduled for November 18, 2021 at 8:00 a.m.


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

September 16, 2021 / Zoom Virtual Meeting – 8:00 a.m.


Members Present

Greg Stinson, Richard Hardaway, Bob Carnahan, George Topoll, Wendy Mis, Joshleen Denham, Justin Kiel


Staff and Others Present

Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Meredith Stilwell, Denarie Kane, Stephanie Kuziela, David Hollenbeck


Call to Order

Chairman Stinson called the meeting to order.

Approval of Minutes

The minutes of the July 15, 2021 meeting were presented. Bob Carnahan made motion and Justin Kiel seconded to approve the minutes. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel, Greg Stinson and George Topoll voting in the affirmative. Wendy Mis abstained from voting since she had just joined the meeting. Motion passed 5-0.

Review of Financial Status – June 2021 Budget vs Actual

Talaya Jones presented the June 2021 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account.


Talaya Jones presented the June 2021 general fund financial reports. Total expenditures for the period ending June 30, 2021 were $2,103,110 of the $11,981,765 budgeted. Total general fund revenue for the period was $1,189,579 of the $3,574,659 budgeted.


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

$2,154,851 of the $4,717,013 budgeted. Total CARES revenue collected for the period is $2,181,787 of the $4,307,009 budgeted.


Approval of Claims Registers – June 2021

Talaya presented the June 2021 General Fund claims register totaling $306,199.20 to the Committee for approval. Richard Hardaway made motion and Justin Kiel seconded to approve the June 2021 General Fund claims register. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0. The CARES Act expenditures register of claims totaling $105,359.51 was presented for approval. Richard Hardaway made motion and Justin Kiel seconded to approve the June 2021 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0.


Review of Financial Status – July 2021 Budget vs Actual

Talaya Jones presented the July 2021 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account.


Talaya Jones presented the July 2021 general fund financial reports. Total expenditures for the period ending July 31, 2021 were $2,412,666 of the $11,981,765 budgeted. Total general fund revenue for the

period was $1,195,203 of the $3,574,659 budgeted.


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

$2,186,424 of the $4,717,013 budgeted. Total CARES revenue collected for the period is $2,303,262 of the $4,307,009 budgeted.


Approval of Claims Registers – July 2021

Talaya presented the July 2021 General Fund claims register totaling $316,417.62 to the Committee for approval. Richard Hardaway made motion and Bob Carnahan seconded to approve the July 2021 General Fund claims register. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0. The CARES Act expenditures register of claims totaling $12,575.69 was presented for approval. Richard Hardaway made motion and Justin Kiel seconded to approve the June 2021 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0.


Economic Resiliency Plan Consultant Selection and Contract

Denarie Kane presented a memorandum on the Economic Resiliency Plan consultant selection process and contract. An RFP was solicited from five consultants were chosen based on scores from a prior RFQ. Three proposals were received and two chosen for interviews. The decision was made to award the contract to TIP Strategies and Denarie asked the Finance & Personnel Committee to forward a recommendation for approval of the Executive Board to authorize the Executive Committee to allow NIRPC Executive Director Ty Warner to execute the contract paperwork and NIRPC attorney, Dave Hollenbeck, to work with Ty on the contract and scope of work. Wendy Mis motioned and Bob Carnahan seconded to forward the recommendation for approval. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0.


NIRPC Resolution 21-16: Requesting the Release of the LaPorte County RLF from certain requirements of the Economic Development Administration

Denarie Kane presented Resolution 21-16 and asked the Finance & Personnel Committee to forward the resolution with a recommendation for approval to the NIRPC Executive Board. Defederalizing the LaPorte County RLF would remove future reporting requirements. After a brief discussion regarding the possibility of the RLF being discontinued in the future, Richard Hardaway made motion and Wendy Mis seconded to recommend Resolution 21-16 to the NIRPC Executive Board for approval. A roll call vote was taken with Bob Carnahan, Joshleen Denham, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll voting in the affirmative. Motion passed 7-0.


Personnel updates

Ty Warner reported on the hiring of the new Economic Development Specialist, Matthew Paskash.

Other Business None

Adjournment

There being no further business, the meeting was adjourned.


33

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


823,726.18

119

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


989,180.29

0

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


0.00

1

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


92,891.00


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

8/10/2021

93.72


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

8/31/2021

137.29

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

8/31/2021

1,499,822.05 image

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


0.00

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

8/31/2021

1,389,719.86

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


(110,102.19)

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


0.00

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


1,499,822.05

Date

Check To

Check Description

Amount

7/02/2019

0002363 Kelly Tripp

Refund fee for tree steward workshop

28.83

8/27/2019

0002409 United Way of Porter County

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

33.85

4/09/2020

0002545 Anthem Life

Life Ins for April 2020

490.75

6/02/2020

0002587 Anthem Life

Life Insurance June 2020

514.93

8/11/2020

0002624 Anthem Life

Life Insurance - August

502.84

3/23/2021


6/02/2021

0002764 American of Metropolitan Planning Organization

0002809 Miovision

NIRPC-Job Posting Director of Transportaion


traffic Counting Base Scouts/UPS Shipping

50.00


8,197.00


8/24/2021


0002858 AccuFund, Inc

& Del.

AccuFund Accounting Suite (5 Pro


6,386.25


8/24/2021


0002859 BASIC

users/Accounts Receivable/Budget

Development/Fixed Assets/Purchase Orders/Payroll/Employee Portal (50 Pro One Time ARPA Admin Fee-ARPA Notices,


150.00


8/24/2021


0002862 Quill Corporation

Tax Credit

Self- sealing, window, security envelopes/8-


152.74


8/31/2021


0002865 South Shore Clean Cities, Inc.

1/2x11 copy paper/11x17 copy paper/Black

dual monitor stand Invoices 4441, 4442


93,595.00


Total Unmarked Checks: 110,102.19

Total Checks:

110,102.19

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 9/02/2021 @ 7:37 AM

Reconciliation - General

Page: 1

STK 9/2/21

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

09/2/2021

7/31/2021 1,572,341.59

image

Trial Balance - Cash

Run: 9/02/2021 at 7:44 ANMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 8/31/2021


Page: 1



All Balance

1.1.001.0000.1010.0 Cash       1,389,719.86  

Total 1,389,719.86


image STK 9/2/21


4

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


52,693.54

0

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


0.00

0

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


0.00

0

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


0.00


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


0.00


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

8/31/2021

9.02

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

8/31/2021

259,802.78 image

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


0.00

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

8/31/2021

259,802.78

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


0.00

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


0.00

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


259,802.78

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 9/02/2021 @ 7:42 AM

Reconciliation - Revolving Loan Fund

Page: 1

STK 9/2/21

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

9/2/2021

207,100.22

7/31/2021

image

Trial Balance - Cash

Run: 9/02/2021 at 7:45 ANMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 8/31/2021


Page: 1



All Balance

2.3.050.0000.1010.0 Cash          259,802.78  

Total 259,802.78


image STK 9/2/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021 Budget

FY 21

YTD August Budget %

Expended balance


Salaries




5020-1

Total Salaries

1,328,521

716,552 46%


Salaries Sub-Total

1,328,521

716,552 46%


Fringe Benefits

5121-9

FICA Contributions

119,742

62,862

48%

5122-9

Workers Compensation

9,500

6,429

32%

5123-9

Unemployment Compensation

3,000

1,008

66%

5141-9

PERF Contributions

200,012

106,840

47%

5142-9

Health Insurance

230,000

132,742

42%

5143-9

Life & Disability Insurance

24,000

10,508

56%

5145-9

ICMA

23,000

14,550

37%

5146-9

Staff Development

20,000

1,651

92%


Fringe Benefits Sub-Total

629,254

336,590

47%

image

1,087,648

`

Occupancy

5221-9

Office Lease

231,000

150,181

35%

5222-9

Property Insurance

6,500

1,319

80%

5223-9

Building Maintenance

18,540

12,583

32%

5224-9

Utilities

30,650

18,718

39%


Occupancy Sub-Total

286,690

182,801

36%


Maintenance

5241-9

Copier Leasing/Maintenance

20,370

6,742

67%

5243-9

Computer Service/Maintenance

43,736

28,441

35%

5244-9

Telephone Service/Maintenance

18,900

8,052

57%


Combined Copier/IT/Phone Service/Maintenance

83,006

43,235

48%

5249-9

Other Equipment Maintenance

2,000

958

52%


Maintenance Sub-Total

85,006

44,193

48%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

7,479

82%

5410-2

Communications: Transportation

299,000

21,861

93%

5410-3

Economic Development District

11,768

1,997

83%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

20,625

18%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

7,367

74%

5420-5

Promotional Expenses: Environmental Programs

3,700

7,500

-103%

5430-9

General Use Supplies Expense

6,000

1,101

82%


Departmental Sub-Total

441,223

67,930

85%


Contractual

5602-9

Legal Services

22,200

13,600

39%

5603-9

Audit and Accounting

33,000

54

100%

5604-9

LaPorte RLF Services

2,000

190

91%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,300

448,328

46%

5610-2

Planning

320,000

0

100%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

51,500

30,000

42%


Contractual Sub-Total

1,287,347

492,172

62%


Capital Outlays

5910-0

Furniture and Equipment

80,000

0 100%


Capital Outlays Sub-Total

80,000

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,138,041

1,840,238 56%


LaPorte Revolving Loan Fund

85,000

0


Transit Capital Fund

3,297,959

147,305


Transit Operating Fund

4,460,765


TOTAL EXPENDITURES

11,981,765

3,075,190

CARES FUND EXPENDITURES

image

YTD August 2021 Expenses Budget vs Actual

900,000

885,681

858,231

800,000

716,552

700,000

600,000

492,172

500,000

419,503

400,000

336,590

294,149

300,000

191,127 182,801

200,000

56,671

44,193

67,930

100,000

-

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD August Budget YTD August Expended

image

YTD August 2021 Expended by Category

27%

39%

4%

2%

10%

18%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021

Budget

FY 21

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

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

366,669

366,669 0%

32%

1.1.4210

Federal Agencies

869,119

135,731

(298,829) -69%

84%

1.1.4310

State Agencies

1,955,395

722,105

(255,592) -26%

63%

1.1.4410

Local Agencies

44,694

25,485

3,138 14%

43%

1.1.4610

Non-Governmental

85,318

5,055

(37,604) -88%

94%

1.3.4260

Economic Development District

70,000

10,684

(24,316) -69%

85%

1.1.4800

Interest Income

9,862

5,475

544 11%

image

44%


Revenue Total

    3,574,659             

1,271,204  

               (245,990)                -16%              

64%


image

image

Revenue by Funding Source as of August 31, 2021


1%

0%

2%

0%

29%

57%

11%

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 AUGUST 31, 2021


Line Items


FY 2021 Budget

YTD August

Expended

FY 21 Budget %

balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

236,733

140,364

41%

Salaries Sub-Total

236,733

140,364

41%


Contractual




RLF Services

5,000

-

100%

Audit & Accounting

5,000

5,000

0%

EDD Insititutional CARES ACT

136,000

-

100%

Contractual Sub-Total

146,000

5,000

97%

Departmental




Communications

500

201

60%

PPE Supplies & Office Supplies

1,000

338

66%

Departmental Sub-Total

1,500

539

64%


Capital Outlays




Furniture and Equipment

100,000

68,195

32%

Capital Outlays Sub-Total

100,000

68,195

32%

image

image

image

250,000

YTD August 2021 Expenses Budget vs Actual

236,733

200,000


150,000

140,364

146,000

100,000

100,000

68,195

50,000

5,000

1,500 539

-

SALARIES

CONTRACTUAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

TOTAL NIRPC CARES FUND EXPENDITURES 484,233 214,098 56%


CARES Revolving Loan Fund

530,000

-


CARES Transit Capital Fund

1,008,732

378,640


CARES Transit Agency Fund

2,694,048

1,900,475


TOTAL EXPENDITURES

4,717,013

2,493,212



10


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021

Budget


YTD August Collected

FY 21

Budget % balance

CARES ACT OPERATING




Operating Revenue

419,386

288,190

31%

Capital Revenue

125,000

0

100%


CARES ACT EDA Economic Development District

59,843

27,796

54%


604,229

315,986

48%


CARES AGENCY

FTA Revenue

2,694,048

1,900,205

29%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

378,282

62%


Revenue Total

4,307,009

2,594,473

40%


image

Revenue by Funding Source as of August 31, 2021


9%


91%

CARES Operating

Economic Development District

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


8/3/2021


4409


Anthem Life

General Fund 5143.9


$ 314.80


$ 314.80


C4409


ER paid for August Insurance


8/3/2021


4409


Anthem Life

General Fund 5143.9


$ 156.44


$ 156.44


C4409


EE paid for August Insurance


8/3/2021


4411


DeLage

General Fund 5243.9


$ 3,573.42


$ 3,573.42


C4411


IT


8/3/2021


4411


DeLage

General Fund 5244.9


$ 741.83


$ 741.83


C4411


TELE


8/3/2021


4411


DeLage

General Fund 5241.9


$ 842.74


$ 842.74


C4411


COPIER


8/3/2021


4411


DeLage

General Fund 5910.0


$ 206.25


$ 206.25


C4411


MainOffice365


8/3/2021


4412


United HealthCare

General Fund 2152.0


$ 2,141.56


$ 2,141.56


C4412


EE paid for August Health Insurance


8/3/2021


4412


United HealthCare

General Fund 5142.9


$ 11,473.19


$ 11,473.19


C4412


ER paid for August Health Insurance


8/4/2021


4378


City of LaPorte

General Fund 5760.0


$ 79,377.00


$ 79,377.00


C4378


LaPorte OA IN-2019-030 Apr-Jun 2021


8/4/2021


4377


City of Valparaiso

General Fund 5760.0


$ 45,272.00


$ 45,272.00


C4377


Valpo CMAQ IN-2019-029 Apr-Jun 2021


8/4/2021


4390


East Chicago Transit

General Fund 5760.0


$ 39,366.00


$ 39,366.00


C4390


ECT OA IN-2019-030 Apr-Jun 2021


8/4/2021


4391


East Chicago Transit

General Fund 5760.0


$ 48,351.00


$ 48,351.00


C4391


ECT PM IN-2018-026 Apr-Jun 2021


8/4/2021


4392


East Chicago Transit

General Fund 5760.0


$ 58,012.00


$ 58,012.00


C4392


ECT Para IN-2019-030 Apr-Jun 2021


8/4/2021


4373


Lake County Community Svc

General Fund 5760.0


$ 18,155.00


$ 18,155.00


C4373


SLCCS EM OA IN-2018-026 Apr-Jun 2021


8/4/2021


4374


Lake County Community Svc

General Fund 5760.0


$ 19,832.00


$ 19,832.00


C4374


SLCCS OA IN-2018-026 Apr-Jun 2021


8/4/2021


4375


Lake County Community Svc

General Fund 5760.0


$ 13,382.00


$ 13,382.00


C4375


SLCCS PM IN-2018-026 Apr-Jun 2021


8/4/2021


4393


Lake County Community Svc

General Fund 5760.0


$ 26,751.00


$ 26,751.00


C4393


SLCC EM OA IN-2018-026 Apr-Jun 2021


8/4/2021


4380


Opportunity Enterprises

General Fund 5760.0


$ 16,295.00


$ 16,295.00


C4380


OE PM IN -2019-030 Apr-Jun 2021


8/4/2021


4371

Porter County Aging and Community Svs

General Fund 5760.0


$ 22,159.00


$ 22,159.00


C4371


PCACS EM OA IN-2017-027 Apr-Jun


8/4/2021


4376

Porter County Aging and Community Svs

General Fund 5760.0


$ 5,218.00


$ 5,218.00


C4376


PCACS EM IN-2018-026 Apr-Jun 2021


8/4/2021


4379

Porter County Aging and Community Svs

General Fund 5760.0


$ 73.00


$ 73.00


C4379


PCACS OA IN-2019-030 Apr-Jun 2021


8/10/2021


5390


Federal & Fica

General Fund 2140.0


$ 4,534.95


$ 4,534.95


C5390

7/19-8/1/2021 pay period-

FWT,empfica,empficamed Federal Tax Withholdings Payable


8/10/2021


5390


Federal & Fica

General Fund 2142.0


$ 7,626.48


$ 7,626.48


C5390

7/19-8/1/2021 pay period-

FWT,empfica,empficamed State Tax Withholdings Payable


8/10/2021


5394


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5394


7/19-8/1/2021 pay period- ICMA


8/10/2021


5393


Horizon Bank

General Fund 2150.0


$ 372.31


$ 372.31


C5393


7/19-8/1/2021 pay period- HAS


8/10/2021


5392


INPRS

General Fund 2149.0


$ 6,504.04


$ 6,504.04


C5392


7/19-8/1/2021 pay period- EmpPerf [NIRPC]


8/10/2021


4408


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4408


ER paid for Ty Warner 7/19/2021 thru 8/1/2021-p/r

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


8/10/2021



Payroll



$ 38,649.04


$ 38,649.04



Pay period ending 8/1/2021


8/10/2021



Account Fee


General Fund


$ 93.72


$ 93.72



Horizon Bank


8/10/2021


4327


Amazon

General Fund 5960.0


$ 207.66


$ 207.66


CC4327

SentrySafe SFW 123 GDC Fireproof and

WaterproofSafe with digital keypad -LaPorte TransPorte


8/10/2021


4401


Chicago Tribune

General Fund 5410.1


$ 27.72


$ 27.72


CC4401


News Paper Subscription


8/10/2021


4350


GoodHire

General Fund 5410.9


$ 54.99


$ 54.99


CC4350


Standard background check


8/10/2021


4353

JM2 Webdesigners LLC DBA Business YETI

General Fund 5410.9


$ 360.00


$ 360.00


CC4353


Annual Website Hosting-NIRPC


8/10/2021


4400


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


CC4400


Stamps


8/11/2021


4402

Blachly,Tabor,Bozik & Hartman, LLC

General Fund 5602.9


$ 1,700.00


$ 1,700.00


2843


Legal


8/11/2021


4423


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2844


Office Cleaning- Aug


8/11/2021


4403


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2845


Lease-August


8/11/2021


4405


Health Resources, Inc

General Fund 2153.0


$ 846.30


$ 846.30


2847


Dental Insurance-Aug


8/11/2021


4419

Indiana University Bloomingtion

General Fund 5420.5


$ 2,500.00


$ 2,500.00


2849


Partners for Clean Air Scholarship Award- Adelaide Young Brust


8/11/2021


4410


INPRS

General Fund 5141.9


$ 0.01


$ 0.01


C4410


Rounding Adjustment 7/19/2021-8/1/2021 pr


8/11/2021


4407


Kansas City Life Insurance

General Fund 5143.9


$ 824.90


$ 824.90


2850


STD/LTD Disability Insurance- Aug


8/11/2021


4314


Quill Corporation

General Fund 5430.9


$ 425.93


$ 425.93


2852


Office Supplies


8/11/2021


4414


Ried's Fire & Safety Equip.

General Fund 5223.9


$ 450.70


$ 450.70


2854


Annual portable fire extinguishers inspecitons


8/11/2021


5395


United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2855


7/19-8/1/2021 pay period- United Way


8/11/2021


4421


Valparaiso University

General Fund 5420.5


$ 2,500.00


$ 2,500.00


2856


Partners for Clean Air Scholarship Award- Lucia Otten


8/11/2021


4420


Williams College

General Fund 5420.5


$ 2,500.00


$ 2,500.00


2857


Partners for Clean Air Scholarship Award- Quentin Funderburg


8/12/2021


4416


Ecointeractive

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4416


TIP SaaS Service-monthly service fee


8/12/2021


4413


Warner, Tyson

General Fund 5410.9


$ 53.76


$ 53.76


C4413


Mileage-Roundtrip Morgan TWP to Joliet- Dialougues on Future of food


8/12/2021


4404


Warner, Tyson

General Fund 5244.9


$ 125.00


$ 125.00


C4404


Communication Expense-Aug


8/12/2021


4406


Fidelity EyeMed

General Fund 2154.0


$ 99.01


$ 99.01


C4406


Vision Insurance-Aug


8/13/2021


4415


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C4415


Business Internet- Aug


8/17/2021


4432


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C4432


Recycle/Garbage -Aug


8/18/2021


B-5323


IN Dept of Revenue

General Fund 2143.0


$ 1,478.32


$ 1,478.32


C5323


6/21-7/4/2021 pay period - LwtIN, SwtIN State Tax Withholdings Payable


8/18/2021


B-5323


IN Dept of Revenue

General Fund 2144.0


$ 312.20


$ 312.20


C5323


6/21-7/4/2021 pay period - LwtIN, SwtIN Local Tax Withholdings Payable


8/18/2021


B-5351


IN Dept of Revenue

General Fund 2143.0


$ 1,478.32


$ 1,478.32


C5351


7/5-7/18/2021 pay period- LwtIN, SwtIN State Tax Withholdings Payable


8/18/2021


B-5351


IN Dept of Revenue

General Fund 2144.0


$ 312.20


$ 312.20


C5351


7/15-7/18/2021 pay period - LwtIN, SwtIN Local Tax Withholdings Payable


8/24/2021


4436


Basic

General Fund 5410.9


$ 150.00


$ 150.00


2859


One Time ARPA Admin Fee-ARPA Notices, Tax Credit


8/24/2021


4434


City of Portage

General Fund 5224.9


$ 2,876.59


$ 2,876.59


2860


Sewer/Water/Gas/Electric service-Aug


8/24/2021


4433


Engravables

General Fund 5410.5


$ 198.00


$ 198.00


2861


Laser Engraved Apex Series Clear Acrylic Award-Partner for Clean Air


8/24/2021


B-5434


Federal & Fica

General Fund 2140.0


$ 4,534.96


$ 4,534.96


C5434


8/2-8/15/2021 pay period-FWT, empfica, empficmed Federal Tax Withholdings Payable


8/24/2021


B-5434


Federal & Fica

General Fund 2142.0


$ 7,626.48


$ 7,626.48


C5434


8/2-8/15/2021 pay period-FWT, empfica, empficmed FICA Tax Withholdings Payable


8/24/2021


B-5437


Horizon Bank

General Fund 2150.0


$ 372.31


$ 372.31


C5437


8/2-8/15/2021 pay period- HSA


8/24/2021


B-5438


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5438


8/2-8/15/2021 pay period- ICMA


8/24/2021


4431


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4431


ER paid for Ty Warner 8/2/2021 thru 8/15/2021-p/r




Payroll



$ 38,649.04


$ 38,649.04




8/24/2021


4418


Quill Corporation

General Fund 5430.9


$ 152.74


$ 152.74


2862


Office supplies-Self-sealing envelopes/copy paper/black dual monitor stand


8/24/2021


5439


United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2864


8/2-8/15/2021 pay period-United Way


8/25/021


5436


INPRS

General Fund 2149.0


$ 6,504.04


$ 6,504.04


C5436


8/2-8/15/2021 pay period- EmpPerf [NIRPC]


8/25/2021


4430


INPRS

General Fund 5141.9


$ 0.01


$ 0.01


C4430


Rounding Adjustment 8/2/2021-8/15/2021 pr


8/26/2021


4435


Dow, Thomas

General Fund 5410.9


$ 2,546.61


$ 2,546.61


C4435


Moving Reimbursement -Thomas Dow


8/26/2021


4428


Warner, Tyson

General Fund 5410.9


$ 15.68


$ 15.68


C4428

Mileage-Morgan TWP to Michigan City-SSCC

Annual Meeting/ Michigan city to NIRPC Return


8/31/2021


4441


South Shore Clean Cities

General Fund 5610.5


$ 2,904.00


$ 2,904.00


2865


CMAQ Air Quality Public Ed-Aug 11. 2020- Billboard


8/31/2021


4442


South Shore Clean Cities

General Fund 5610.5


$ 90,691.00


$ 90,691.00


2865


CMAQ Air Quality Public Ed-April 1, 2021-Jun 30, 2021


Total: $ 670,480.58


Allowance of Claims


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

register such claims are hereby allowed in the total amount of

$ 670,480.58

image


Dated this

21 day of

image

October

,2021.


image

image

George Topoll, Chairman


image

Greg Stinson, 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


8/4/2021


4382


City of Valparaiso

CARES Fund 5960.0


$ 100,288.00


$ 100,288.00


C4382


Valpo CCC-Dash IN-2020-014 Apr-Jun 2021


8/4/2021


4383


City of Valparaiso


CARES Fund 5960.0


$ 171,997.00


$ 171,997.00


C4383


Valpo CCC-V-Line IN-2020-014 Apr-Jun 2021


8/4/2021


4389


East Chicago Transit


CARES Fund 5960.0


$ 4,142.00


$ 4,142.00


C4389


ECT OA IN 2020-014 Apr-Jun 2021


8/4/2021


4384


Opportunity Enterprises


CARES Fund 5960.0


$ 3,595.00


$ 3,595.00


C4384


OE OA IN-2020-014 Apr-Jun 2021


8/4/2021


4381


Porter County Aging Community Services


CARES Fund 5960.0


$ 325.00


$ 325.00


C4381


PCACS OA IN-2020-014 Apr-Jun


8/11/2021


4426


Best Server

CARES Fund 5960.0


$ 506.25


$ 506.25


2842


Purchase a refurbished server for LCCS to upgrade


8/11/2021


4426


Best Server

CARES Fund 5960.0


$ 137.50


$ 137.50


2842


Purchase a refurbished server for LCCS to upgrade


8/11/2021


4399

H & T Electrical Services, LLC

CARES Fund 5960.0


$ 1,813.21


$ 1,813.21


2846

Labor Hours-Install Updated Electrical

Panel/Materials/Daily Truck Rate-City of LaPorte


8/11/2021


4324


Impact Networking LLC

CARES Fund 5910.0


$ 400.00


$ 400.00


2848


Installation & Congiguration fee to setup NIRPC


8/11/2021


3960


Pulse Technology

CARES Fund 5430.9


$ 28.99


$ 28.99


2851


Office Supplies-Covid 19/Cares-Lysol


8/11/2021


4329


Rask Fire Life Safety LLC

CARES Fund 5960.0


$ 1,592.00


$ 1,592.00


2853


Labor Cost/Parts Cost-Outdated dialer & sprinkler system - NIRPC


8/24/2021


4427


AccuFund, Inc

CARES Fund 5910.0


$ 6,386.25


$ 6,386.25


2858

users)Accounts Receivable/Budget

Development/Fixed Assets/Purchase Orders/Paytoll/Emp Portal/Self Service and

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


Total:

$ 291,211.20


Allowance of Claims


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

register such claims are hereby allowed in the total amount of $ 291,211.20

image


Dated this 21 day of October

image

,2021.


image

image

George Topoll, Chairman


image

Greg Stinson, Treasurer

image

image

image

image

image

STK10/1/21


image image


image



image


image



image


image


image


image

image STK 10/1/21

image

image

image

image

image

S T K 1 0 /1 / 2 1


image image



image



image


image



image

image

STK 10/1/21

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021 Budget

FY 21

YTD September Budget % Expended balance


Salaries




5020-1

Total Salaries

1,328,521

822,416 38%


Salaries Sub-Total

1,328,521

822,416 38%


Fringe Benefits

5121-9

FICA Contributions

119,742

71,058

41%

5122-9

Workers Compensation

9,500

6,429

32%

5123-9

Unemployment Compensation

3,000

1,008

66%

5141-9

PERF Contributions

200,012

120,823

40%

5142-9

Health Insurance

230,000

144,716

37%

5143-9

Life & Disability Insurance

24,000

11,928

50%

5145-9

ICMA

23,000

16,262

29%

5146-9

Staff Development

20,000

1,651

92%


Fringe Benefits Sub-Total

629,254

373,874

41%

image

1,106,465

`

Occupancy

5221-9

Office Lease

231,000

168,957

27%

5222-9

Property Insurance

6,500

1,319

80%

5223-9

Building Maintenance

18,540

14,082

24%

5224-9

Utilities

30,650

18,718

39%


Occupancy Sub-Total

286,690

203,075

29%


Maintenance

5241-9

Copier Leasing/Maintenance

20,370

7,585

63%

5243-9

Computer Service/Maintenance

43,736

32,178

26%

5244-9

Telephone Service/Maintenance

18,900

9,058

52%


Combined Copier/IT/Phone Service/Maintenance

83,006

48,821

41%

5249-9

Other Equipment Maintenance

2,000

1,083

46%


Maintenance Sub-Total

85,006

49,904

41%

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

7,773

81%

5410-2

Communications: Transportation

299,000

21,861

93%

5410-3

Economic Development District

11,768

1,997

83%

5410-4

Communications: Subgrantee Management

25,000

0

100%

5410-5

Communications: Environmental Programs

25,255

23,065

9%

5410-8

Communications: Partner Agency

1,000

0

100%

5410-9

Communications: Allocated Functions

28,000

9,197

67%

5420-5

Promotional Expenses: Environmental Programs

3,700

7,500

-103%

5430-9

General Use Supplies Expense

6,000

1,101

82%


Departmental Sub-Total

441,223

72,494

84%


Contractual

5602-9

Legal Services

22,200

15,300

31%

5603-9

Audit and Accounting

33,000

54

100%

5604-9

LaPorte RLF Services

2,000

649

68%

5610-4

Transit Oversight

17,347

0

100%

5610-5

Environmental Projects

837,300

448,328

46%

5610-2

Planning

320,000

0

100%

5619-9

Organizational Dev.

2,000

0

100%

5610-0

Board Development

2,000

0

100%

5610-2

E-Tip

51,500

33,750

34%


Contractual Sub-Total

1,287,347

498,081

61%


Capital Outlays

5910-0

Furniture and Equipment

80,000

0 100%


Capital Outlays Sub-Total

80,000

0 100%



TOTAL GENERAL FUND EXPENDITURES

4,138,041

2,019,844 51%


LaPorte Revolving Loan Fund

85,000

0


Transit Capital Fund

3,297,959

147,305


Transit Operating Fund

4,460,765


TOTAL EXPENDITURES

11,981,765

3,273,614


CARES FUND EXPENDITURES

image

YTD September 2021 Expenses Budget vs Actual

1,000,000

900,000

800,000

700,000

600,000

500,000

400,000

300,000

200,000

100,000

-

996,391

965,510

822,416

471,941

498,081

373,874

330,917

215,018

203,075

63,755

49,904

72,494

SALARIES FRINGE BENEFITS OCCUPANCY MAINTENANCE DEPARTMENTAL CONTRACTUALS

YTD September Budget YTD September Expended

image

YTD September 2021 Expended by Category


25%


41%


4%


2%

10%


18%

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021

Budget

YTD FY 21

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

GENERAL FUND REVENUE




1.1.4110

County Appropriations

540,271

366,669

366,669

0%

32%

1.1.4210

Federal Agencies

869,119

145,936

(288,623)

-66%

83%

1.1.4310

State Agencies

1,955,395

1,122,254

144,556

15%

43%

1.1.4410

Local Agencies

44,694

25,485

3,138

14%

43%

1.1.4610

Non-Governmental

85,318

5,205

(37,454)

-88%

94%

1.3.4260

Economic Development District

70,000

10,684

(24,316)

-69%

85%

1.1.4800

Interest Income

9,862

6,126

1,195

image

24%

38%


Revenue Total

    3,574,659             

1,682,359  

                165,165  

               11%              

53%


image

image

Revenue by Funding Source as of September 30, 2021


1%

0%

0%

1%

22%

9%

67%

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



Line Items


FY 2021 Budget

YTD

September Expended


FY 21 Budget % balance

NIRPC CARES EXPENDITURES




Salaries




Salaries

236,733

146,338

38%

Salaries Sub-Total

236,733

146,338

38%


image

Contractual

RLF Services

5,000

-

100%

Audit & Accounting

5,000

5,000

0%

EDD Insititutional CARES ACT

136,000

-

100%

Contractual Sub-Total

146,000

5,000

97%

Departmental




Communications

500

201

60%

PPE Supplies & Office Supplies

1,000

367

63%

Departmental Sub-Total

1,500

568

62%


Capital Outlays




Furniture and Equipment

100,000

70,460

30%

Capital Outlays Sub-Total

100,000

70,460

30%


TOTAL NIRPC CARES FUND EXPENDITURES

484,233

222,367

54%


CARES Revolving Loan Fund

530,000

-


CARES Transit Capital Fund

1,008,732

422,339


CARES Transit Agency Fund

2,694,048

1,900,475


TOTAL EXPENDITURES

4,717,013

2,545,181



image

YTD August 2021 Expenses Budget vs Actual

250,000

236,733

200,000


150,000

146,338

146,000

100,000

100,000

70,460

50,000

5,000

1,500 568

-

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

Budget Expended

23


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

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



Line Items


FY 2021

Budget

YTD

September Collected

FY 21

Budget % balance

CARES ACT OPERATING




Operating Revenue

419,386

290,278

31%

Capital Revenue

125,000

0

100%


CARES ACT EDA Economic Development District

59,843

27,796

54%


604,229

318,074

47%



CARES ACT RLF

Loan Application Fees


450


CARES AGENCY

FTA Revenue

2,694,048

1,900,205

29%

CARES TRANSIT CAPITAL

FTA Revenue

1,008,732

422,337

58%


Revenue Total

4,307,009

2,641,066

39%


image

Revenue by Funding Source as of September 30, 2021


9%


91%

CARES Operating

Economic Development District

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


9/2/2021


4450


Anthem Life

General Fund 5143.9


$ 534.57


$ 534.57


C4450


Life Insurance -SEPT


9/2/2021


4464


DeLage

General Fund 5243.9


$ 3,736.86


$ 3,736.86


C4464


IT


9/2/2021


4464


DeLage

General Fund 5244.9


$ 741.83


$ 741.83


C4464


Tele


9/2/2021


4464


DeLage

General Fund 5241.9


$ 842.74


$ 842.74


C4464


Copier


9/2/2021


4464


DeLage

General Fund 5910.0


$ 206.25


$ 206.25


C4464


MainOffice365


9/7/2021


5464


Federal & Fica

General Fund 2140.0


$ 4,534.95


$ 4,534.95


C5464


8/16-8/29/2021 pay period -FWT, empfica, empficamed-Federal Tax Withholdings Payable


9/7/2021


5464


Federal & Fica

General Fund 2142.0


$ 7,603.52


$ 7,603.52


C5464

8/16-8/29/2021 pay period- FWT,

empfica,empficamed-FICA Tax Withholdings Payable


9/7/2021


5467


Horizon Bank

General Fund 2150.0


$ 522.31


$ 522.31


C5467


8/16-8/29/2021 pay period- HSA


9/7/2021


5468


ICMA Retirement Fund-PR

General Fund 2146.0


$ 780.00


$ 780.00


C5468


8/16-8/29/2021 pay period- ICMA


9/7/2021


4439


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4439


ER paid for Ty Warner 8/16/2021 thru 8/29/2021-p/r




Payroll



$ 38,517.61


$ 38,517.61



Pay period ending 8/29/21


9/7/2021


4460


United Healthcare Srvcs.

General Fund 2152.0


$ 2,236.62


$ 2,236.62


C4460


EE paid for August Health Insurance


9/7/2021


4460


United Healthcare Srvcs.

General Fund 5142.9


$ 11,973.69


$ 11,973.69


C4460


ER paid for August Health Insurance


9/8/2021


4469


American Red Cross

General Fund 5410.9


$ 1,780.00


$ 1,780.00


2867


Adult First Aid/CPR/AED training-NIRPC


9/8/2021


4456

Blachly, Tabor, Bozik, Hartman

General Fund 5602.9


$ 1,700.00


$ 1,700.00


2869


Legal-Sept


9/8/2021


4465


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2870


Office Cleaning-Sept


9/8/2021


4455


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2872


Lease-Sept


9/8/2021


5466


INPRS

General Fund 2149.0


$ 6,504.04


$ 6,504.04


C5466


8/16-8/29/2021 pay period- EmpPerf [NIRPC]


9/8/2021


4449


Kansas City Life Insurance

General Fund 5143.9


$ 885.46


$ 885.46


2875


STD/LTD Disability Insurance -SEPT


9/8/2021


4451


Paramount Dental

General Fund 2153.0


$ 883.67


$ 883.67


2876


Dental Insurance-Sept


9/8/2021


4461


South Shore Clean Cities

General Fund 5410.5


$ 400.00


$ 400.00


2878


2021 Clean Air Gold Outing (staff foursome)


9/8/2021


5469


United Way

General Fund 2147.0


$ 33.85


$ 33.85


C5469


8/16-8/29/2021 pay period- United Way


9/9/2021


4457


Ecointeractive Inc

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C4457


TIP SAAS Service-monthly service fee


9/9/2021


4459


Fidelity EyeMed

General Fund 2154.0


$ 103.79


$ 103.79


C4459


Vision Insurance-Sept


9/9/2021


4467


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C4467


Garbage/Recycle-Sept

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


9/9/2021


4463


Warner, Ty

General Fund 5410.1


$ 175.00


$ 175.00


C4463


Sinai Forum Lecture Series, PNW


9/9/2021


4462


Warner, Ty

General Fund 5410.1


$ 28.56


$ 28.56


C4462

Mileage One way NIRPC to Michigan City

Mileage RT NIRPC to Merrillville- Time Hall of Fame


9/9/2021


4453


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C4453


Communication Expense-Sept


9/10/2021


4398


Amazon

General Fund 5410.5


$ 2,039.92


$ 2,039.92


CC4398

4 Boy Bikes-Steering Comm. Bike give away-

PFCA 4 Girl Bikes Steering Comm-Bike give away -PFCA


9/10/2021


4452


Chicago Tribune Media

General Fund 5410.1


$ 27.72


$ 27.72


CC4452


News Paper Subscription


9/10/2021


4458


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C4458


Business Internet-Sept


9/10/2021


4424

Council of Development Finance Agencies

General Fund 5410.1


$ 63.00


$ 63.00


CC4424


Practitioner's Guide to Eco Dev.Fin 3rd Edition Book- Ty Warner


9/10/2021


4470


NWI Times

General Fund 5410.9


$ 50.00


$ 50.00


CC4470


NWI Times Business & Industry Hall of Fame 2021 luncheon- Ty Warner


9/10/2021


4454


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


CC4454


Stamps


9/10/2021


4425


Stamps

General Fund 5249.9


$ 100.00


$ 100.00


CC4425


Stamps


9/15/2021


5391


IN Dept of Revenue

General Fund 2143.0


$ 1,578.62


$ 1,578.62


C5391


7/19-8/1/2021 pay period- LwtIN, SwtIN- State Withholdings Payable


9/15/2021


5391


IN Dept of Revenue

General Fund 2144.0


$ 358.78


$ 358.78


C5391


7/19-8/1/2021 pay period- LwtIN, SwtIN- Local Withholdings Payable


9/15/2021


5435


IN Dept of Revenue

General Fund 2143.0


$ 1,578.62


$ 1,578.62


C5435


8/2-8/15/2021 pay period- LwtIN, SwtIN- State Tax Withholdings Payable


9/15/2021


5435


IN Dept of Revenue

General Fund 2144.0


$ 358.78


$ 358.78


C5435


8/2-8/15/2021 pay period- LwtIN, SwtIN- Local Tax Withholdings Payable


9/21/2021


5499


Federal & Fica

General Fund 2140.0


$ 4,534.95


$ 4,534.95


C5499


8/30-9/12/2021 pay period-FWT, empfica, empficamed- Federal Tax Withholdings Payable


9/21/2021


5499


Federal & Fica

General Fund 2142.0


$ 7,716.54


$ 7,716.54


C5499


8/30-9/12/2021 pay period-FWT, empfica, empficamed- Local Tax Withholdings Payable


9/21/2021


5502


Horizon Bank

General Fund 2150.0


$ 522.31


$ 522.31


C5502


8/30-9/12/2021 pay period- HAS


9/21/2021


5503


ICMA Retirement Fund-PR

General Fund2146.0


$ 780.00


$ 780.00


C5503


8/30-9/12/2021 pay period- ICMA


9/21/2021


4471


ICMA Retirement Fund-PR

General Fund 5145.9


$ 855.91


$ 855.91


C4471


ER paid for Ty Warner 8/30 thru 9/12/2021-p/r




Payroll



$ 39,168.87


$ 39,168.87



Pay period ending 9/12/2021


9/21/2021


5504


United Way

General Fund 2147.0


$ 33.85


$ 33.85


2881


8/30-9/12/2021 pay period- United Way


9/22/2021


5501


INPRS

General Fund 2149.0


$ 6,608.94


$ 6,608.94


C5501


8/30-9/12/2021 pay period - EmpPerf[NIRPC]


9/22/2021


4369

South Lake County Community Service

General Fund 5760.0


$ 111.00


$ 111.00


C4369


SLCCS EM OA IN-2016-015 Apr-Jun 2021 Draw 23


9/22/2021


4370

South Lake County Community Service

General Fund 5760.0


$ 13,330.00


$ 13,330.00


C4370


SLCCS EM OA IN-2017-027 Apr-Jun 2021 Draw 24


9/27/2021


4372

Porter County Aging and Community Service

General Fund 5760.0


$ 5,376.00


$ 5,376.00


C4372


PCACS PM IN-2018-026 Apr-Jun 2021 DRAW 26-21



Total:

$ 195,088.85


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 $ 195,088.85

image


Dated this 21

image

day of _October

image

, 2021.


image

George Topoll, Chairman


image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


9/8/2021


4444


AccuFund, Inc

CARES Fund 5910.0


$ 1,284.00


$ 1,284.00


2866


AccuFund Accounting Suite-Cloud /Employee Portal (50 Hosted employees)NIRPC


9/8/2021


4443


Best Servers

CARES Fund 5960.0


$ 68.75


$ 68.75


2868


Labor charges for server set up w/ RouteMatch-Lacke County Community


9/8/2021


4448


City of LaPorte

CARES Fund 5960.0


$ 1,876.65


$ 1,876.65


2871

Lite 6ft DisplayPort to HDMI Adapter cable/

Lenovo ThinkVision T27p-10 27" 4K UHD WLED LCD/ Shipping- City of LaPorte


9/8/2021


4429


Great Lakes Hotsy

CARES Fund 5960.0


$ 6,230.00


$ 6,230.00


2873

Hotsy Hot Water Pressure Washer/ trade

Allowance for Customer's Lesson Hot/Cold- East Chicago


9/8/2021


4320


Impact Newworking, LLC

CARES Fund 5910.0


$ 775.00


$ 775.00


2874

Purchase Bit Titan Uer Migration Bundle for

MSO365/ Installation & configuration Fee to set up NIRPC


9/8/2021


4445


RouteMatach Software, Inc

CARES Fund 5960.0


$ 1,534.00


$ 1,534.00


C4445


LCCS RouthMatch/ NT RouteMatch


9/8/2021


4446


RouteMatach Software, Inc

CARES Fund 5960.0


$ 22,196.95


$ 22,196.95


C4446


LCCS/ PCACS/ NT


9/8/2021


4447


RouteMatach Software, Inc

CARES Fund 5960.0


$ 1,534.00


$ 1,534.00


C4447


LCCS RouthMatch/ NT RouteMatch


9/21/2021


4394

Overhead Door Company of Northwest Indiana Inc

CARES Fund 5960.0


$ 10,259.04


$ 10,259.04


2879


Install new overhead garage door & remove old door-ECT


9/21/2021


3960


Pulse Technology

CARES Fund 5430.9


$ 28.99


$ 28.99


2880


Office Supplies-Covid-19/Lysol





CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -







CARES Fund



$ -



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


Total:

$ 45,787.38


Allowance of Claims


image

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 $ 45,787.38


Dated this 21

image

day of

October

, 2021.


image

image

George Topoll, Chairman


image

Greg Stinson, 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


9/16/2021


4468


Regional Development Com

RLF Fund 5899.7


$ 458.75


$ 458.75


1165


Underwriting services to Bucklers Market Loan/Credit Report







$ -









$ -



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


Total:

$ 458.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 $ 458.75

image


Dated this 21

image


day of

October

image


, 2021.


image

George Topoll, Chairman


image

Greg Stinson, Treasurer


2022 BUDGET

10/21/2022

FY 2022 BUDGET

ATTACHMENT A


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 GENERAL FUND APPROPRIATIONS BUDGET


image


PERSONNEL - SALARIES

1,568,480


PERSONNEL - FRINGE BENEFITS

629,069


OCCUPANCY

286,690


EQUIPMENT SERVICE/MAINTENANCE

85,006


DEPARTMENTAL

428,223


CONTRACTUAL

1,623,883


CAPITAL OUTLAYS - Equipment & Furniture

180,000


TOTAL FUND BUDGET

4,801,352


image


ATTACHMENT B


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET


image


CAPITAL OUTLAYS - TRANSIT EQUIPMENT

2,897,205

CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT

501,999


TOTAL FUND BUDGET

3,399,204


image


ATTACHMENT C


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES

4,438,881

OTHER SERVICES AND CHARGES- CARES ACT 2020

-


TOTAL FUND BUDGET

4,438,881


image


ATTACHMENT D


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2022 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES

150,000


TOTAL FUND BUDGET

150,000


2022 CARES ACT 2020 REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES

530,000


.

image


Attachment A


NIRPC FY 2022 Budget




FY 2021 Budget


FY 2022 Budget Change %

REVENUES



COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

1,994,419

1,778,953

STATE AGENCIES

2,504,813

2,399,555

LOCAL AGENCIES

37,050

28,350

NON-GOVERNMENTAL

52,338

16,338

INTEREST INCOME

                                     37,885

                                   37,885

TOTAL REVENUES

5,166,775

4,801,352 -8%


EXPENDITURES

SALARY

FRINGE BENEFITS

FICA CONTRIBUTIONS

WORKERS COMPENSATION

UNEMPLOYMENT COMPENSATION

PERF CONTRIBUTIONS

HEALTH INSURANCE

LIFE & DISABILITY INSURANCE

ICMA CONTRIBUTIONS

STAFF DEVELOPMENT

1,565,254

1,568,480

550,000

530,000


136,000

136,000


2,000

2,000


                                     51,500

                                   53,045


1,978,347

1,623,883

-22%

180,000

180,000

0%

                                5,166,774

                              4,801,352

-8%

                                               0

                                           (0)


FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

0%


119,742

119,989


9,500

9,500


3,000

3,000


200,012

199,580


230,000

230,000


24,000

24,000


23,000

23,000


                                     20,000

                                   20,000


629,254

629,069

0%

OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

231,000

231,000


6,500

6,500


18,540

18,540


                                     30,650

                                   30,650


286,690

286,690

0%


EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

20,370

20,370


43,736

43,736


18,900

18,900


                                       2,000

                                     2,000


85,006

85,006

0%

DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

ECONOMIC DEVELOPMENT DISTRICT

GENERAL USE SUPPLIES

41,500

35,000


299,000

299,000


25,000

25,000


25,255

22,755


1,000

1,000


28,000

25,000


3,700

3,700


11,768

11,768


                                       7,000

                                     5,000


442,223

428,223

-3%

CONTRACTUAL

LEGAL SERVICES

AUDIT & ACCOUNTING

LA PORTE RLF SERVICES

TRANSIT OVERSIGHT

ENVIRONMENTAL CONTRACTS

PLANNING

ALTERNATIVE FUEL

BOARD DEVELOPMENT

ECONOMIC DEVELOPMENT DISTRICT

ECONOMIC DEVEL DISTRICT RLF-CARES ACT

ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT

ORGANIZATIONAL DEVELOPMENT

E-TIP

22,200

23,400

38,000

38,000

2,000

2,000

17,347

17,347

837,300

500,091

320,000

320,000

-

-

2,000

2,000