FINANCE AND PERSONNEL COMMITTEE
Meeting Agenda - Thursday, January 20, 2022 -- 8:00 a.m.
6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
Call to Order
Meeting Minutes of December 16, 2021 Pages 1
Review of Financial Status – November 2021 Budget vs Actual Pages 2 - 12
Bank Statement Reconciliations (pg. 2-7)
General Fund Expenses YTD November 2021 (pg. 8-9)
General Fund Revenue YTD November 2021 (pg. 10)
CARES Expenses YTD November 2021 (pg. 11)
CARES Revenue YTD November 2021 (pg. 12)
Approval of General Fund Claims Register – November 2021 Pages 13 - 16
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – November 2021 Pages 17
ACTION REQUESTED: Approval
Approval of RLF Claims Register – November 2021 Pages 18
ACTION REQUESTED: Approval
Resolution 22-01 Calendar Year 2022 NIRPC Budget Pages 19 - 30
ACTION REQUESTED: Recommendation for Approval
New three-year Executive Director Employment Agreement Pages 31 - 34
ACTION REQUESTED: Recommendation for Approval
RDG Planning & Design Contract for 2050 Metropolitan Transportation Plan – Active Transportation Element
ACTION REQUESTED: Recommendation for Approval
Personnel update
Other Business
Adjournment
The next meeting is scheduled for March 21, 2022 at 8:00 a.m.
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE
December 16, 2021 / Zoom Virtual Meeting – 9:00 a.m.
Members Present
Denise Ebert, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson, George Topoll
Staff and Others Present
Talaya Jones, Meredith Stilwell, Ty Warner, Lisa Todd, Stephanie Kuziela, Sue Lynch, Scott Kingan, Mary Tanis, Geof Benson, David Hollenbeck,
Call to Order
Chairman Stinson called the meeting to order.
Approval of Minutes
The minutes of the November 18, 2021 meeting were presented. Justin Kiel made motion and George Topoll seconded to approve the minutes. A roll call vote was taken with Denise Ebert, Richard Hardaway, Justin Kiel, Wendy Mis, Greg Stinson and George Topoll. Motion passed 6-0.
NIRPC FY 2022 Preliminary Budget
Talaya Jones presented the preliminary budget. The final budget will go before the Finance & Personnel Committee at the January 20th meeting and, if given a favorable recommendation, be presented to the NIRPC Commission for approval.
The Revenue, Departmental and Contractual budgets were all decreased due to the depletion and end of CARES Act funds. Salary and Fringe benefits budgets were increased due to the possibility of open positions being filled and Executive Director and staff salary increases. Salary increases will be factored using employee evaluations. The Occupancy budget was increased to accommodate an increase in NIRPC’s lease. Portage allowed the 2020 rate to be held throughout 2021, but an increase for 2022 is expected. The Equipment Service/Maintenance budget was decreased after budget to actuals for 2021 were reviewed.
Talaya noted she was able to find some cost savings from 2021, but to compete in the salary market and achieve budget sustainability, NIRPC needs to obtain more local share.
A short discussion was held regarding the pay for subrecipient bus drivers and Talaya noted a grant is being written.
Other Business
Ty reported on the triennial and certifications reviews and noted the certification review deadline is December 20th and is expected to be finished any day.
George Topoll inquired on the status of the State Board of Accounts audit and Talaya reported that the contractors hired by the SBOA to complete the audits were backlogged due to the number of audits. The timeframe looks to have the audit wrapping up around the end of January.
Adjournment
There being no further business, the meeting was adjourned.
Closing Balance from Previous Statement........................................................................................... | 10/31/2021 | 1,462,403.46 | |||
42 Deposits and Other Additions Totaling...................................................................... | 1.159,712.27 | ||||
157 Checks and Other Withdrawls Totaling..................................................................... | 1,259,716.27 | ||||
Adjustments Totaling.............................................................................................. | 33,634.43 | ||||
Voids Totaling........................................................................................................ | 108.57 | ||||
Service Charge....................................................................................................... | 11/10/2021 | 121.60 | |||
Interest Earned....................................................................................................... | 11/30/2021 | 72.93 | |||
Closing Balance for this Statement..................................................................................................... | 11/30/2021 | 1,396,093.79 | |||
Difference............................................................................................................... | 0.00 | ||||
Cash Balance from General Ledger.................................................................................................... | 11/30/2021 | 1,329,830.11 | |||
Open Activity from Bank Register............................................................................. | (66,263.68) | ||||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||||
General Ledger Reconciliation to Statement.............................................................................................. | 1,396,093.79 | ||||
Date | Check To | Check Description | Amount | ||
7/02/2019 | 0002363 Kelly Tripp | Refund fee for tree steward workshop | 28.83 | ||
8/27/2019 | 0002409 United Way of Porter County | 8/5 - 8/18/2019 pay period - United Way | 33.85 | ||
4/09/2020 | 0002545 Anthem Life | Life Ins for April 2020 | 490.75 | ||
6/02/2020 | 0002587 Anthem Life | Life Insurance June 2020 | 514.93 | ||
8/11/2020 | 0002624 Anthem Life | Life Insurance - August | 502.84 | ||
3/23/2021 11/16/2021 | 0002764 American of Metropolitan Planning Organization 0002907 United Way of Porter County | NIRPC-Job Posting Director of Transportaion 10/25 - 11/7/2021 pay period - United Way | 50.00 33.85 | ||
11/30/2021 | 0002908 City of Portage, The | Sewer/Water/Gas/Electric-NOV | 1,876.79 | ||
11/30/2021 | 0002909 ESRI, INC. | ESRI Software renewal for ArcGIS | 4,200.00 | ||
11/30/2021 | 0002910 SME | Programmatic support & Outreach Haz/lnventory and Prioritization Haz/Clean | 58,497.99 | ||
11/30/2021 | 0002911 United Way of Porter County | up Haz/Site Assess Haz 11/8 - 11/21/2021 pay period - United Way | 33.85 | ||
Total Unmarked Checks: 66,263.68 | Total Checks: | 66,263.68 | |||
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 12/29/2021 @ 12:49 PM
5
Reconciliation - General
IJ./d9/J-I
Page:
01/12/2022
Trial Balance - Cash
Run: 1212912021 at 12:ltJ THWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 11/30/2021
Page: 1
All
1.1.001.0000.1010.0 General Cash Total
Balance
1,329,830.11
1,329,830.11
s l
1J-/dq Ji\
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 1210112021 @ 9:11 AM Reconciliation - CARES RLF Bank Account Page:
Closing Balance from Previous Statement...........................................................................................
11/01/2021
0.00
2 | Deposits and other Additions Totaling...................................................................... | 83,634.43 | |
Checks and other Withdrawls Totaling..................................................................... | 50,000.00 | ||
2 | Adjustments Totaling.............................................................................................. | -31,734.43 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | ||
Interest Earned....................................................................................................... | 11/30/2021 | 0.42 | |
Closing Balance for this Statement..................................................................................................... 11/30/2021 | 1,900.42 | ||
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... 11/30/2021 | 1,241.67 | ||
Open Activity from Bank Register............................................................................. | (658.75) | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement.............................................................................................. | 1,900.42 | ||
Date Check To Check Description | Amount | ||
11/17/2021 0010001 Regional Development Co. Underwriting Services for J's Breakfast Club | 658.75 | ||
Total Unmarked Checks: 658.75 Total Checks: | 658.75 | ||
\/ '51(
11/1/JGJI
\1'
\\ \
Trial Balance - Cash
Run: 1210112021 at 9:scN.QRTHWESTERN IN DIANA REGIONAL PLANNING COMMISSION
For 11/30/2021
Page: 1
All
4.3.050.0000.1010.0 CARES ALF Cash
Total
Balance
1,241.67
1,241.67
/s l I dJoJ\
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 1210112021 @ e:1a AM Reconciliation - Revolving Loan Fund Page:
Closing Balance from Previous Statement...........................................................................................
10/31/2021
266,936.27
4 | Deposits and Other Additions Totaling...................................................................... | 2,881.24 | |
0 | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
Adjustments Totaling.............................................................................................. | -1,900.00 | ||
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | ||
Interest Earned....................................................................................................... | 11/30/2021 | 8.83 | |
Closing Balance for this Statement..................................................................................................... | 11/30/2021 | 267,926.34 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 11/30/2021 | 267,926.34 | |
Open Activity from Bank Register............................................................................. | 0.00 | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement.............................................................................................. | 267,926.34 | ||
/s\\li\ \\ a \
Trial Balance - Cash
Run: 1210112021 at 9:3cN..0RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 11/30/2021
Page: 1
All
2.3.050.0000.1010.0 LaPorte Cash
Total
Balance 267,926.34
267,926.34
Js i\ ,
IJ,\ I B
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2021 |
Line Items | FY 2021 Budget | FY 21 YTD November Budget % Expended balance |
Salaries | |||
5020-1 | Total Salaries | 1,328,521 | 1,052,426 21% |
Salaries Sub-Total | 1,328,521 | 1,052,426 21% |
Fringe Benefits | ||||
5121-9 | FICA Contributions | 119,742 | 88,769 | 26% |
5122-9 | Workers Compensation | 9,500 | 6,429 | 32% |
5123-9 | Unemployment Compensation | 3,000 | 1,059 | 65% |
5141-9 | PERF Contributions | 200,012 | 150,725 | 25% |
5142-9 | Health Insurance | 230,000 | 168,205 | 27% |
5143-9 | Life & Disability Insurance | 24,000 | 14,830 | 38% |
5145-9 | ICMA | 23,000 | 20,542 | 11% |
5146-9 | Staff Development | 20,000 | 2,885 | 86% |
Fringe Benefits Sub-Total | 629,254 | 453,444 | 28% | |
Occupancy | ||||
5221-9 | Office Lease | 231,000 | 206,507 | 11% |
5222-9 | Property Insurance | 6,500 | 1,319 | 80% |
5223-9 | Building Maintenance | 18,540 | 17,080 | 8% |
5224-9 | Utilities | 30,650 | 25,231 | 18% |
Occupancy Sub-Total | 286,690 | 250,136 | 13% | |
Maintenance | ||||
5241-9 | Copier Leasing/Maintenance | 20,370 | 9,270 | 54% |
5243-9 | Computer Service/Maintenance | 43,736 | 39,466 | 10% |
5244-9 | Telephone Service/Maintenance | 18,900 | 12,659 | 33% |
Combined Copier/IT/Phone Service/Maintenance | 83,006 | 61,395 | 26% | |
5249-9 | Other Equipment Maintenance | 2,000 | 1,133 | 43% |
Maintenance Sub-Total | 85,006 | 62,528 | 26% | |
Departmental | ||||
5410-1 | Communications: Commission/Ex. Dir. | 41,500 | 11,079 | 73% |
5410-2 | Communications: Transportation | 299,000 | 23,067 | 92% |
5410-3 | Economic Development District | 11,768 | 2,116 | 82% |
5410-4 | Communications: Subgrantee Management | 25,000 | 0 | 100% |
5410-5 | Communications: Environmental Programs | 25,255 | 23,227 | 8% |
5410-8 | Communications: Partner Agency | 1,000 | 0 | 100% |
5410-9 | Communications: Allocated Functions | 28,000 | 11,239 | 60% |
5420-5 | Promotional Expenses: Environmental Programs | 3,700 | 7,500 | -103% |
5430-9 | General Use Supplies Expense | 6,000 | 1,909 | 68% |
5411-3 | Grant/Contract Funds Return | 3687 | ||
Departmental Sub-Total | 441,223 | 83,823 | 81% | |
Contractual | ||||
5602-9 | Legal Services | 22,200 | 18,700 | 16% |
5603-9 | Audit and Accounting | 33,000 | 54 | 100% |
5604-9 | LaPorte RLF Services | 2,000 | 649 | 68% |
5610-4 | Transit Oversight | 17,347 | 0 | 100% |
5610-5 | Environmental Projects | 837,300 | 671,288 | 20% |
5610-2 | Planning | 320,000 | 0 | 100% |
5619-9 | Organizational Dev. | 2,000 | 0 | 100% |
5610-0 | Board Development | 2,000 | 0 | 100% |
5610-2 | E-Tip | 51,500 | 41,478 | 19% |
Contractual Sub-Total | 1,287,347 | 732,169 | 43% | |
Capital Outlays | |||
5910-0 | Furniture and Equipment | 80,000 | 0 100% |
Capital Outlays Sub-Total | 80,000 | 0 100% | |
TOTAL GENERAL FUND EXPENDITURES | 4,138,041 | 2,634,527 36% |
LaPorte Revolving Loan Fund | 85,000 | 0 |
Transit Capital Fund | 3,297,959 | 147,305 |
Transit Operating Fund | 4,460,765 |
1,733,185
11,981,765
4,515,016
TOTAL EXPENDITURES
8
CARES FUND EXPENDITURES
1,400,000
1,200,000
1,217,811
1,180,068
1,052,426
1,000,000
800,000
732,169
576,816
600,000
453,444
404,454
400,000
262,799 250,136
200,000
77,922 62,528
83,823
-
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD November Budget YTD November Expended
28%
40%
3%
2%
10%
17%
Salaries
Fringe Benefits Occupancy Maintenance Departmental
Contractuals
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2021 |
Line Items | FY 2021 Budget | YTD November Collected FY 21 Budget % balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 540,271 | 0% |
1.1.4210 | Federal Agencies | 869,119 | 314,340 | 64% |
1.1.4310 | State Agencies | 1,955,395 | 1,122,254 | 43% |
1.1.4410 | Local Agencies | 44,694 | 29,310 | 34% |
1.1.4610 | Non-Governmental | 85,318 | 9,100 | 89% |
1.3.4260 | Economic Development District | 70,000 | 31,462 | 55% |
1.1.4800 | Interest Income | 9,862 | 6,705 | 32% |
Revenue Total | 3,574,659 | 2,053,441 | 43% |
2%
0%
1% 1%
26%
55%
15%
County Appropriations Federal Agencies State Agencies
Local Agencies Non-Governmental
Economic Development District
Interest Income
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2021 |
Line Items | FY 2021 Budget | YTD November Expended | FY 21 Budget % balance |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries | 236,733 | 156,058 | 34% |
Salaries Sub-Total | 236,733 | 156,058 | 34% |
YTD November 2021 Expenses Budget vs Actual
250,000
236,733
200,000
156,058
150,000
146,000
100,000
100,000
70,873
50,000
5,659
1,500 643
-
SALARIES
CONTRACTURAL
DEPARTMENTAL
CAPITAL OUTLAYS
Budget Expended
Contractual
RLF Services | 5,000 | 659 | 87% |
Audit & Accounting | 5,000 | 5,000 | 0% |
EDD Insititutional CARES ACT | 136,000 | - | 100% |
Contractual Sub-Total | 146,000 | 5,659 | 96% |
Departmental | |||
Communications | 500 | 276 | 45% |
PPE Supplies & Office Supplies | 1,000 | 367 | 63% |
Departmental Sub-Total | 1,500 | 643 | 57% |
Capital Outlays | |||
Furniture and Equipment | 100,000 | 70,873 | 29% |
Capital Outlays Sub-Total | 100,000 | 70,873 | 29% |
TOTAL NIRPC CARES FUND EXPENDITURES | 484,233 | 233,232 | 52% |
CARES Revolving Loan Fund | 530,000 | 50,000 |
CARES Transit Capital Fund | 1,008,732 | 425,407 |
CARES Transit Agency Fund | 2,694,048 | 2,142,998 |
TOTAL EXPENDITURES | 4,717,013 | 2,851,637 |
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2021 |
Line Items | FY 2021 Budget | YTD November Collected | FY 21 Budget % balance |
CARES ACT OPERATING | |||
Operating Revenue | 419,386 | 383,873 | 8% |
Capital Revenue | 125,000 | 0 | 100% |
6%
14%
80%
CARES Operating
Economic Development District
CARES Act RLF
CARES ACT RLF Oversight Revenue 30,540
CARES ACT EDA Economic Development District | 59,843 | 67,426 | -13% |
604,229 | 481,838 | 20% |
CARES ACT RLF | Loan Proceeds | 50,000 | ||
CARES ACT RLF | Loan Application Fees & Interest | 1,900 | ||
CARES AGENCY | FTA Revenue | 2,694,048 | 2,142,998 | 20% |
CARES TRANSIT CAPITAL | FTA Revenue | 1,008,732 | 425,405 | 58% |
Revenue Total | 4,307,009 | 3,102,142 | 28% |
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
11/1/2021 | 4523 | DeLage | General Fund 5243.9 | $ 3,723.91 | $ 3,723.91 | C4523 | IT |
11/1/2021 | 4523 | DeLage | General Fund 5243.9 | $ 842.74 | $ 842.74 | C4523 | Copier |
11/1/2021 | 4523 | DeLage | General Fund 5243.9 | $ 206.25 | $ 206.25 | C4523 | MainOffice365 |
11/2/2021 | 4531 | Anthem Life | General Fund 5143.9 | $ 549.76 | $ 549.76 | C4531 | Life Insurance- NOV |
11/2/2021 | 4641 | Economic Development Administration | General Fund 5411.3 | $ 3,686.59 | $ 3,686.59 | C4641 | Refund 2020 Partnership Grant due to overdraw |
11/2/2021 | B-5567 | Federal & Fica | General Fund 2140.0 | $ 4,570.54 | $ 4,570.54 | C5567 | 10/11-10/24/2021 pay period- FWT, empfica, empficamed- Federal Tax Withholdings Payable |
11/2/2021 | B-5567 | Federal & Fica | General Fund 2142.0 | $ 7,900.30 | $ 7,900.30 | C5567 | 10/11-10/24/2021 pay period- FWT, empfica, empficamed- FICA Tax Withholdings Payable |
11/2/2021 | B-5570 | Horizon Bank | General Fund 2150.0 | $ 522.31 | $ 522.31 | C5570 | 10/11-10/24/2021 pay period- HSA |
11/2/2021 | 4524 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4524 | ER paid for Ty Warner 10/11/2021 thru 10/24/2021 -p/r |
11/2/2021 | B-5571 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 780.00 | $ 780.00 | C5571 | 10/11-10/24/2021 pay period - ICMA |
11/2/2021 | Payroll | $ 40,212.04 | $ 40,212.04 | Pay period ending 11/2/2021 | |||
11/3/2021 | 4545 | Adams Radio Group | General Fund 5610.5 | $ 3,144.00 | $ 3,144.00 | 2898 | 3 Hour Live Broadcast Oct 9, 2021-Pay Federal Share of Radio Promotion of Porter County Gas Can Exchange event |
11/3/2021 | 4526 | Blachly, Tabor. Bozik & Hartman | General Fund 5602.9 | $ 1,700.00 | $ 1,700.00 | 2899 | Legal- NOV |
11/3/2021 | 4543 | City of Portage | General Fund 5224.9 | $ 2,378.85 | $ 2,378.85 | 2900 | Sewer-OCT/Water-OCT/Gas/electric-Sept/OCT |
11/3/2021 | 4525 | City of Portage | General Fund 5221.9 | $ 18,775.18 | $ 18,775.18 | 2900 | Lease- NOV |
11/3/2021 | B-5569 | INPRS | General Fund 2149.0 | $ 6,766.26 | $ 6,766.26 | C5569 | 10/11-10/24/2021 pay period-EmpPerf{NIRPC} |
11/3/2021 | 4533 | Kansas City Life | General Fund 5143.9 | $ 917.40 | $ 917.40 | 2902 | S-T Disability/L-T Disability Insurance- NOV |
11/3/2021 | 4539 | One Region | General Fund 5410.3 | $ 75.00 | $ 75.00 | 2903 | One Region Luncheon- Matthew Paskash |
11/3/2021 | 4538 | One Region | General Fund 5410.3 | $ 75.00 | $ 75.00 | 2903 | One Region Luncheon- Denarie Kane |
11/3/2021 | 4528 | Paramount Dental | General Fund 2153.0 | $ 921.04 | $ 921.04 | 2904 | Dental Insurance-NOV |
11/3/2021 | 4553 | United HealthCare | General Fund 5142.9 | $ 11,515.32 | $ 11,515.32 | C4553 | ER paid NOV 2021 Health Insurance |
11/3/2021 | 4553 | United HealthCare | General Fund 2152.0 | $ 2,150.08 | $ 2,150.08 | C4553 | EE paid NOV 2021 Health Insurance |
11/3/2021 | B-5572 | United Way | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2905 | 10/11-10/24/2021 pay period-United Way |
11/4/2021 | 4534 | Dialpad | General Fund 5244.9 | $ 582.38 | $ 582.38 | C4534 | Telephone Service-NOV |
11/4/2021 | 4546 | Fidelity EyeMed | General Fund 2154.0 | $ 108.57 | $ 108.57 | C4546 | Vision Insurance- NOV |
11/4/2021 | 4544 | Hammond, Allen | General Fund 5410.2 | $ 16.38 | $ 16.38 | C4544 | Mileage-Nirpc to ECT -RT |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
11/4/2021 | 4514 | Lake County Community Services, Inc | General Fund 5760.0 | $ 35,573.00 | $ 35,573.00 | C4514 | 3rd Quarter 2021 PMTF Reimbursement-LCCS |
11/4/2021 | 4520 | North Township | General Fund 5760.0 | $ 18,360.00 | $ 18,360.00 | C4520 | 3rd Quarter 2021 PMTF Reimbursement-NT |
11/4/2021 | 4515 | Porter County Aging and Community Services | General Fund 5760.0 | $ 19,508.00 | $ 19,508.00 | C4515 | 3rd Quarter 2021 PMTF Reimbursement- PCACS |
11/4/2021 | 4541 | Total Disposal | General Fund 5223.9 | $ 74.00 | $ 74.00 | C4541 | Garbage/Recycle-NOV |
11/4/2021 | 4527 | Warner, Ty | General Fund 5244.9 | $ 125.00 | $ 125.00 | C4527 | Communication Fee- NOV |
11/5/2021 | 4542 | Comcast | General Fund 5244.9 | $ 139.64 | $ 139.64 | C4542 | Business Internet- NOV |
11/9/2021 | B-5524 | IN Dept of Revenue | General Fund 2143.0 | $ 1,636.43 | $ 1,636.43 | C5524 | 9/13-9/26/2021 pay period -LwtIN, SwtIN- State Tax Withholdings Payable |
11/9/2021 | B-5524 | IN Dept of Revenue | General Fund 2144.0 | $ 374.23 | $ 374.23 | C5524 | 9/13-9/26/2021 pay period -LwtIN, SwtIN- Local Tax Withholdings Payable |
11/9/2021 | B-5537 | IN Dept of Revenue | General Fund 2143.0 | $ 1,636.43 | $ 1,636.43 | C5537 | 9/27-10/10/2021 pay period- LwtIN, SWtIN- State Tax Withholdings Payable |
11/9/2021 | B-5537 | IN Dept of Revenue | General Fund 2144.0 | $ 374.23 | $ 374.23 | C5537 | 9/27-10/10/2021 pay period- LwtIN, SWtIN- Local Tax Withholdings Payable |
11/10/2021 | 4530 | Chicago Tribune | General Fund 5410.1 | $ 27.72 | $ 27.72 | CC4530 | News Paper Subscription |
11/10/2021 | 4472 | Amazon | General Fund 5430.9 | $ 65.97 | $ 65.97 | CC4472 | Logitech USB Headset H390 with Noise Cancelling |
11/10/2021 | 4497 | One Region | General Fund 5410.9 | $ 75.00 | $ 75.00 | CC4497 | One Region 2021 In-Person Luncheon- Ty Warner |
11/10/2021 | Service Fee | $ 121.60 | $ 121.60 | Service Fee | |||
11/10/2021 | 4536 | Squarespace | General Fund 5410.1 | $ 216.00 | $ 216.00 | CC4536 | Annual Subscription- Business website 9/17/21-9/17/2022 |
11/10/2021 | 4529 | Stamps | General Fund 540.9 | $ 24.99 | $ 24.99 | CC4529 | Stamps |
11/10/2021 | 4488 | SurveyMonkey | General Fund 5410.2 | $ 384.00 | $ 384.00 | CC4488 | Survey Monkey Renewal - Advantage Annual Plan |
11/16/2021 | 4555 | Bryco | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 2906 | Office Cleaning- NOV 2021 |
11/16/2021 | B-5605 | Federal & Fica | General Fund 2140.0 | $ 4,231.80 | $ 4,231.80 | C5605 | 10/25-111/7/2021 pay period - FWT,empfica, empficamed-Federal Tax Withholdings Payable |
11/16/2021 | B-5626 | Federal & Fica | General Fund 2142.0 | $ 7,500.28 | $ 7,500.28 | C5605 | 10/25/-11/7/2021 pay period - FWT, empfica, empficamed-FICA Tax Withholdings Payable |
11/16/2021 | B-5624 | Federal & Fica | General Fund 2140.0 | $ 206.69 | $ 206.69 | C5626 | Exl vacation payout w/PERF- FWT,empfica, empficamed-Federal Tax Withholdings Payable |
11/16/2021 | B-5608 | Federal & Fica | General Fund 2142.0 | $ 306.00 | $ 306.00 | C5626 | Exl vacation payout w/PERF- FWT,empfica, empficamed-FICA Tax Withholdings Payable |
11/16/2021 | B-5609 | Federal & Fica | General Fund 2140.0 | $ 515.76 | $ 515.76 | C5624 | Exl vacation payout w/out PERF-FWT,empfica, empficamed-Federal Tax Withholdings Payable |
11/16/2021 | 4567 | Federal & Fica | General Fund 2142.0 | $ 520.96 | $ 520.96 | C5624 | Exl vacation payout w/out PERF-FWT,empfica, empficamed-FICA Tax Withholdings Payable |
11/16/2021 | B-5610 | Horizon Bank | General Fund 2150.0 | $ 761.06 | $ 761.06 | C5608 | 10/25-11/7/2021 pay period- HSA |
11/16/2021 | B-5609 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 780.00 | $ 780.00 | C5609 | 10/25-11/7/2021 pay period- ICMA |
11/16/2021 | 4567 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4567 | ER paid for Ty Warner 10/25/2021 thru 11/7/2021-p/r |
11/16/2021 | Payroll | $ 38,233.77 | $ 38,233.77 | Payroll period ending 11/16/2021 | |||
11/16/2021 | Payroll-Vacation Payout | $ 4,067.50 | $ 4,067.50 | Exl Vacation Payout- Term Date 10/15/2021 | |||
11/16/2021 | B-5610 | United Way | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2907 | 10/25-11/7/20212 pay period-United Way |
11/17/2021 | 4569 | Ecointeractive | General Fund 5610.2 | $ 3,978.00 | $ 3,978.00 | C4569 | TIP SAAS Service-monthly fee NOV |
11/17/2021 | B-5628 | INPRS | General Fund 2149.0 | $ 14 284.01 | $ 284.01 | C5628 | Exl vacation payout w/PERF-EmpPerf [NIRPC] |
11/17/2021 | B-5607 | INPRS | General Fund 21490 | $ 6,428.90 | $ 6,428.90 | C5607 | 10/25-11/7/2021 pay period- EmpPerf [NIRPC] |
11/17/2021 | 4560 | Kiel, Justin | General Fund 5410.1 | $ 667.19 | $ 667.19 | C4560 | Flight/Lyft/Hotel/Uber/Per Diem/Parking-NARC Board of Directors Meeting in Galveston |
11/17/2021 | 4556 | Kiel, Justin | General Fund 5410.1 | $ 60.06 | $ 60.06 | C4556 | Mileage-RT LaCrosse to Midway Airport-NARC- RT |
11/17/2021 | 4550 | Warner, Ty | General Fund 5410.1 | $ 44.80 | $ 44.80 | C4550 | Mileage- NIRPC to Chicago RT Link Dinner: Atlanta |
11/17/2021 | 4551 | Warner, Ty | General Fund 5410.1 | $ 52.01 | $ 52.01 | C4551 | Parking Link Dinner w/Atlanta Regional Commissioner/Tolls RT Chicago/Breakfast Meeting w. NIRPC Chair |
11/22/2021 | 4566 | City of LaPorte | General Fund 5760.0 | $ 59,791.00 | $ 59,791.00 | C4566 | LaPorte Reimb for OA IN-2019-030 Draw 44--21 |
11/22/2021 | 4565 | East Chicago Transit | General Fund 5760.0 | $ 39,703.00 | $ 39,703.00 | C4565 | ECT Reimb for PM IN-2018 -026 Draw 43-21 |
11/22/2021 | 4564 | East Chicago Transit | General Fund 5760.0 | $ 10,500.00 | $ 10,500.00 | C4564 | ECT Reimb for OA IN-2019-030 Draw 40-21 |
11/26/2021 | 4579 | City of Valparaiso | General Fund 5760.0 | $ 49,186.00 | $ 49,186.00 | C4579 | Valpo Reimb for CCC V-Line July-Sept 2021 |
11/26/2021 | 4577 | City of Valparaiso | General Fund 5760.0 | $ 45,934.00 | $ 45,934.00 | C4577 | Valpo Reimb for Shuttle July-Sept 2021 |
11/26/2021 | 4591 | East Chicago Transit | General Fund 5760.0 | $ 14,593.00 | $ 14,593.00 | C4591 | ECT Reimb for OA |
11/26/2021 | 4592 | East Chicago Transit | General Fund 5760.0 | $ 46,433.00 | $ 46,433.00 | C4592 | ECT Reimb for Paratransit July-Sept 2021 |
11/26/2021 | 4573 | Lake County Community Services, Inc | General Fund 5760.0 | $ 34,625.00 | $ 34,625.00 | C4573 | LCCS Reimb for EM OA |
11/26/2021 | 4578 | Lake County Community Services, Inc | General Fund 5760.0 | $ 45,469.00 | $ 45,469.00 | C4578 | LCCS Reimb for EM OA July- Sept 2021 |
11/26/2021 | 4586 | Lake County Community Services, Inc | General Fund 5760.0 | $ 9,772.00 | $ 9,772.00 | C4586 | LCCS Reimb for EMOA July-Sept 2021 |
11/26/2021 | 4584 | Lake County Community Services, Inc | General Fund 5760.0 | $ 22,949.00 | $ 22,949.00 | C4584 | LCCS Reimb for PM July-Sept 2021 |
11/26/2021 | 4590 | North Township | General Fund 5760.0 | $ 35,443.00 | $ 35,443.00 | C4590 | NT Reimb for OA July-Sept 2021 |
11/26/2021 | 4589 | North Township | General Fund 5760.0 | $ 1,541.00 | $ 1,541.00 | C4589 | NT Reimb for OA Jan-March 2020 |
11/26/2021 | 4588 | North Township | General Fund 5760.0 | $ 15,094.00 | $ 15,094.00 | C4588 | NT Reimb for OA Jul-Sept 2020 |
11/26/2021 | 4587 | North Township | General Fund 5760.0 | $ 39,632.00 | $ 39,632.00 | C4587 | NT Reimb for OA April-June 2021 |
11/26/2021 | 4574 | North Township | General Fund 5760.0 | $ 13,201.00 | $ 13,201.00 | C4574 | NT Reimb for PM July-Sept 2021 |
11/26/2021 | 4576 | North Township | General Fund 5760.0 | $ 8,589.00 | $ 8,589.00 | C4576 | NT Reimb for PM Jan-March 2020 |
11/26/2021 | 4575 | North Township | General Fund 5760.0 | $ 6,106.00 | $ 6,106.00 | C4575 | NT Reimb for PM April -June 2021 |
11/26/2021 | 4583 | Opportunity Enterprises | General Fund 5760.0 | $ 21,295.00 | $ 21,295.00 | C4583 | OE Reimb for PM July-Sept 2021 |
11/26/2021 | 4582 | Porter County Aging and Community Services | General Fund 5760.0 | $ 31,039.00 | $ 31,039.00 | C4582 | PCACS Reimb for EMOA July-Sept 2021 |
11/26/2021 | 4581 | Porter County Aging and Community Services | General Fund 5760.0 | $ 2,384.00 | $ 2,384.00 | C4581 | PCACS Reimb for OA July-Sept 2021 |
11/30/2021 | 4597 | City of Portage | General Fund 5224.9 | $ 1,876.79 | $ 1,876.79 | 2908 | Sewer/Water/Gas/Electric-NOV |
11/30/2021 | 4547 | ESRI | General Fund | $ 4,200.00 | $ 4,200.00 | 2909 | Software renewal for ArcGIS 2/1/2022- 1/31/23 |
11/30/2021 | B-5646 | Federal & Fica | General Fund 2140.0 | $ 4,539.85 | $ 4,539.85 | C5646 | 11/8-11/21/2021 pay period- FWT, empfica, empficamed-Federal Tax Withholdings Payable |
11/30/2021 | B-5646 | Federal & Fica | General Fund 2142.0 | $ 7,789.14 | $ 7,789.14 | C5646 | 11/18-11/21/2021 pay period- FWT, empfica, empficamed-FICA Tax Withholdings Payable |
11/30/2021 | B-5649 | Horizon Bank | General Fund 2150.0 | $ 392.31 | $ 392.31 | C5649 | 11/8-11/21/2021 pay period- HSA |
11/30/2021 | 4593 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 15 855.91 | $ 855.91 | C4593 | ER paid for Ty Warner 11/8/2021-11/21/2021 p/r |
11/30/2021 | B-5650 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 780.00 | $ 780.00 | C5650 | 11/8-11/21/2021 pay period - ICMA |
11/30/2021 | Payroll | $ 39,672.25 | $ 39,672.25 | Payroll period ending 11/30/2021 | |||
11/30/2021 | 3982 | SME | General Fund 5610.5 | $ 58,497.99 | $ 58,497.99 | 2910 | Hazardous/Inventory and Prioritization - Hazardous/Site Assessment-Hazardous Sub/Site Clean Up Planning-Hazardous Sub |
11/30/2021 | B-5651 | United Way | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2911 | 11/8-11/21/2021 pay period- United Way |
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - |
Total: | $ 934,596.54 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 934,596.54
|
Dated this day of , 2021.
16
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
11/17/2021 | 4505 | RouteMatch | CARES Fund 5960.0 | $ 1,062.00 | $ 1,062.00 | C4505 | LCCS RouteMatch Year 1-2021 DEC |
11/17/2021 | 4506 | RouteMatch | CARES Fund 5960.0 | $ 472.00 | $ 472.00 | C4506 | NT RouteMatch Year 1- 2021 DEC |
11/19/2021 | 4557 | City of Valpo | CARES Fund 5760.0 | $ 215.00 | $ 215.00 | C4557 | Valpo Reimb for CCC JUL-SEPT V-Line 1 or 3 |
11/19/2021 | 4559 | City of Valpo | CARES Fund 5760.0 | $ 17,804.00 | $ 17,804.00 | C4559 | Valpo Reimb for CCC JUL-SEPT V-Line 3or 3 |
11/19/2021 | 4554 | City of Valpo | CARES Fund 5760.0 | $ 108,425.00 | $ 108,425.00 | C4554 | Valpo Reimb for CCC JUL_SEPT DASH |
11/19/2021 | 4558 | City of Valpo | CARES Fund 5760.0 | $ 5,830.00 | $ 5,830.00 | C4558 | Valp Reimb for CCC JUL-SEPT V-Line 2 of 3 |
11/19/2021 | 4563 | North Township | CARES Fund 5760.0 | $ 5,162.00 | $ 5,162.00 | C4563 | NT Reimb for PM APRIL-JUN 2021 |
11/19/2021 | 4562 | North Township | CARES Fund 5760.0 | $ 11,057.00 | $ 11,057.00 | C4562 | NT Reimb for PM JULY-SEPT 2020 |
11/19/2021 | 4561 | North Township | CARES Fund 5760.0 | $ 94,030.00 | $ 94,030.00 | C4561 | NT Reimb for OA JULY-SEPT 2020 |
CARES Fund | $ - | ||||||
CARES Fund | $ - | ||||||
CARES Fund | $ - | ||||||
CARES Fund | $ - |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $ 244,057.00 |
Allowance of Claims
We have examined the claims listed on the foregoing CARES Register of Claims, and except for claims not allowed as shown on the register such claims are hereby allowed in the total amoun $ 244,057.00
Dated this day of , 2022.
Chairperson
Treasurer
17
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
11/17/2021 | 4570 | Divine Strategy LLC | CARES Fund 1950.0 | $ 50,000.00 | $ 50,000.00 | 10000 | Divine Strategy dba J's Breakfast Club- Working Capital Loan Disbursement 50% loan |
11/17/2021 | 4552 | Regional Development Co. | CARES Fund 1950.0 | $ 658.75 | $ 658.75 | 10001 | Underwriting Services for J's Breakfast Club 9/22/21 |
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - | ||||||
RLF Fund | $ - |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $ 50,658.75 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 50,658.75
|
Dated this day of , 2022.
Chairperson
Treasurer
6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ADOPTING THE YEAR 2022 APPROPRIATION BUDGETS FOR THE COMMISSION’S GOVERNMENTAL FUNDS
WHEREAS, a budget is required for governmental funds; and
WHEREAS, it is anticipated that sufficient revenues and other financing sources will be available to support the budgets herein proposed; and
WHEREAS, it is the responsibility of the Commission, as a whole, to approve the appropriations budget of the Commission;
NOW THEREFORE BE IT RESOLVED, that the Commission adopt as its Year 2022 budget for the General Fund for the budget identified in Attachment A to this resolution; and
BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Transit Capital Projects Funds the budget identified in Attachment B to this resolution; and
BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Transit Operating Projects Funds the budget identified in Attachment C to this resolution; and
BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2022 budget for the Revolving Loan Funds the budget identified in Attachment D to this resolution; and
BE IT FURTHER RESOLVED, that the Finance and Personnel Committee of the Commission be designated to oversee the administration of these budgets within the framework of more detailed budget guidelines it might establish.
Duly adopted by the Northwestern Indiana Regional Planning Commission this 20th day of January 2022.
Secretary
FY 2022 BUDGET | ATTACHMENT A |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2022 GENERAL FUND APPROPRIATIONS BUDGET
PERSONNEL - SALARIES | 1,590,648 |
PERSONNEL - FRINGE BENEFITS | 637,853 |
OCCUPANCY | 292,398 |
EQUIPMENT SERVICE/MAINTENANCE | 82,636 |
DEPARTMENTAL | 403,483 |
CONTRACTUAL | 1,931,718 |
CAPITAL OUTLAYS - Equipment & Furniture 180,000
TOTAL FUND BUDGET | 5,118,736 |
ATTACHMENT B
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2022 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET
CAPITAL OUTLAYS - TRANSIT EQUIPMENT 3,578,506
CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT 501,999
TOTAL FUND BUDGET | 4,080,505 |
ATTACHMENT C
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2022 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET
OTHER SERVICES AND CHARGES 4,438,881
OTHER SERVICES AND CHARGES- CARES ACT 2020 -
TOTAL FUND BUDGET | 4,438,881 |
ATTACHMENT D
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2022 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET
OTHER SERVICES AND CHARGES 200,000
TOTAL FUND BUDGET | 200,000 |
2022 CARES ACT 2020 REVOLVING LOAN FUND APPROPRIATIONS BUDGET
OTHER SERVICES AND CHARGES | 461,648 |
. | |
TOTAL FUND BUDGET | 461,648 |
TOTAL BUDGET OF | 14,299,770 |
Attachment A
NIRPC FY 2022 Budget | ||
FY 2021 Budget | FY 2022 Budget Change % | |
REVENUES | ||
COUNTY APPROPRIATIONS | 540,271 | 540,271 |
FEDERAL AGENCIES | 1,994,419 | 1,748,928 |
STATE AGENCIES | 2,504,813 | 2,668,379 |
LOCAL AGENCIES | 37,050 | 76,760 |
NON-GOVERNMENTAL | 52,338 | 46,513 |
INTEREST INCOME | 37,885 | 37,885 |
TOTAL REVENUES | 5,166,775 | 5,118,736 -1% |
EXPENDITURES |
SALARY |
FRINGE BENEFITS |
FICA CONTRIBUTIONS |
WORKERS COMPENSATION |
UNEMPLOYMENT COMPENSATION |
PERF CONTRIBUTIONS |
HEALTH INSURANCE |
LIFE & DISABILITY INSURANCE |
ICMA CONTRIBUTIONS |
STAFF DEVELOPMENT |
1,565,254 | 1,590,648 |
CONTRACTUAL |
LEGAL SERVICES |
AUDIT & ACCOUNTING |
LA PORTE RLF SERVICES |
TRANSIT OVERSIGHT |
ENVIRONMENTAL CONTRACTS |
PLANNING |
BOARD DEVELOPMENT |
ECONOMIC DEVEL DISTRICT RLF-CARES ACT |
ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT |
ORGANIZATIONAL DEVELOPMENT |
E-TIP |
22,200 | 23,400 | |
38,000 | 70,000 | |
2,000 | 2,000 | |
17,347 | 17,347 | |
837,300 | 837,314 | |
320,000 | 320,000 | |
2,000 | 2,000 | |
550,000 | 461,648 | |
136,000 | 101,000 | |
2,000 | 2,000 | |
51,500 | 95,009 | |
1,978,347 | 1,931,718 | -2% |
180,000 | 180,000 | 0% |
5,166,774 | 5,118,736 | -1% |
0 | 0 |
FURNITURE & EQUIPMENT |
TOTAL EXPENSES |
FUND BALANCE - ENDING |
2%
119,742 | 121,685 | |
9,500 | 5,000 | |
3,000 | 3,000 | |
200,012 | 199,688 | |
230,000 | 240,000 | |
24,000 | 24,000 | |
23,000 | 24,480 | |
20,000 | 20,000 | |
629,254 | 637,853 | 1% |
OCCUPANCY |
OFFICE LEASE |
PROPERTY INSURANCE |
BUILDING MAINTENANCE |
UTILITIES |
231,000 | 236,708 | |
6,500 | 6,500 | |
18,540 | 18,540 | |
30,650 | 30,650 | |
286,690 | 292,398 | 2% |
EQUIPMENT SERVICE/MAINTENANCE |
COPIER LEASING/MAINTENANCE |
COMPUTER SERVICE |
TELEPHONE & INTERNET SERVICE / MAIN. |
OTHER EQUIPMENT MAINTENANCE |
20,370 | 18,000 | |
43,736 | 43,736 | |
18,900 | 18,900 | |
2,000 | 2,000 | |
85,006 | 82,636 | -3% |
DEPARTMENTAL |
COMMISSION/EXECUTIVE DIRECTOR |
PLANNING |
SUBGRANTEE MANAGEMENT |
ENVIRONMENTAL PROGRAMS |
PARTNER AGENCIES |
ALLOCATED FUNCTIONS |
ENVIRONMENTAL PROMOTIONS |
ECONOMIC DEVELOPMENT DISTRICT |
GENERAL USE SUPPLIES |
41,500 | 35,000 | |
299,000 | 239,000 | |
25,000 | 25,000 | |
25,255 | 28,947 | |
1,000 | 1,000 | |
28,000 | 25,000 | |
3,700 | 14,953 | |
11,768 | 29,583 | |
7,000 | 5,000 | |
442,223 | 403,483 | -10% |
Attachment A page 2
NIRPC FY 2022 Revenue Detail
347,204 |
115,040 |
78,027 |
540,271 |
357,000 |
141,700 |
142,176 |
225,502 |
852,545 |
30,005 |
1,748,928 |
500,000 |
150,000 |
1,408,810 |
86,679 |
95,009 |
31,119 |
216,762 |
180,000 |
2,668,379 |
1,800 |
15,300 |
16,000 |
750 |
42,910 |
76,760 |
42,676 |
1,837 |
2,000 |
46,513 |
COUNTY APPROPRIATIONS |
LAKE COUNTY |
PORTER COUNTY |
LA PORTE COUNTY |
TOTAL |
FEDERAL AGENCIES |
FTA OVERSIGHT |
FTA CAPITAL |
USDA FOREST SVC |
BROWNFIELD GRANT |
EDD |
CAWS GLC |
TOTAL |
STATE AGENCIES |
INDOT PL 2020 |
INDOT PL 2021 |
INDOT PL 2022 |
INDOT PL 2023 |
STBG |
CMAQ 2020 |
CMAQ 2022 |
CMAQ 2023 |
TOTAL |
LOCAL AGENCIES |
CITY of PORTAGE |
KRBC |
PARTNERS for CLEAN AIR |
FORUM |
ONE REGION ONE TRAIL |
TOTAL |
NON-GOVERNMENTAL |
CALUMET LAND CONSERVATION PARTN. |
ROOM RENTAL INCOME |
SHARED ETHICS ADVISORY COMMISSION |
TOTAL |
INTEREST INCOME |
BANK INTEREST INCOME |
RLF INTEREST INCOME |
TOTAL FY 2022 REVENUE |
3,000
34,885
5,118,736
Attachment B
NIRPC FY 2022 Budget
35,000 |
31,353 |
3,500 |
55,000 |
24,000 |
345,000 |
220,000 |
792,500 |
- |
100,000 |
79,809 |
275,000 |
4,500 |
3,500 |
6,500 |
619,965 |
- |
60,000 |
3,399 |
150,000 |
125,000 |
82,000 |
140,000 |
130,000 |
Grant Federal Req. Match Total
Architectual Services |
Ticket Kiosks and On-Board fare boxes |
Security Cameras |
Vehicles (2) |
Security Camera & Lighting |
TOD Ground Improvements |
Support Vehicle |
Computers/Sound System |
Support Equipment |
Support Vehicle |
Rehab/Renovate - Admin Facility |
Replace 3 Revenue Vehicles |
Replace 2 Revenue Vehicles |
Replace 1 Communter Vehicle |
Replace 2 Revenue Vehicles |
Replace Staff Computers |
Replace 4 Communter Vehicle |
Associated Transit Improv |
Tablets and Vehicle Devices |
Office Computer Equipment |
Office Computer Equipment |
Replace ChicaGO Dash |
Replace 2 Vehicle |
Replace 1 Vehicle |
Computers |
Replace Bus Stop Signs |
Transit Improvements |
Buy Replacement |
Buy Replacement |
Buy Replacement |
X012 | |
X012 | |
X667 | 16,320 |
X667 | 110,500 |
2016-033 | |
2016-033 | |
2016-033 | 28,000 |
2016-033 | 25,082 |
2016-033 | 2,800 |
2017-028 | 44,000 |
2017-028 | 19,200 |
2018-026 | 276,000 |
2018-026 | 176,000 |
2018-026 | 637,500 |
2019-029 | - |
2019-029 | 80,000 |
2019-029 | 59,857 |
2019-029 | 220,000 |
2019-029 | 3,600 |
2019-029 | 2,800 |
2019-029 | 5,200 |
2019-029 | 495,966 |
2019-030 | |
2019-030 | 48,000 |
2019-030 | 2,700 |
2019-030 | 120,000 |
2019-030 | 100,000 |
2020-054 | 65,600 |
2020-054 | 112,000 |
2020-054 | 104,000 |
- |
- |
4,080 |
19,500 |
- |
- |
7,000 |
6,271 |
700 |
11,000 |
4,800 |
69,000 |
44,000 |
155,000 |
- |
20,000 |
19,952 |
55,000 |
900 |
700 |
1,300 |
123,999 |
20,400 |
130,000 |
12,000 |
699 |
30,000 |
25,000 |
16,400 |
28,000 |
26,000 |
TOTAL 2,755,125 681,301 3,436,426
Contingency -
TOTAL BUDGET 3,436,426
** | new projects for 2021 not included |
** | no grant written for 2021 |
Attachment B
CY 2021 TRANSIT CAPITAL PROJECTS FUND | ||||||
Subrecipent | Grant | Project | Letting Date | Total | Non-Federal Funds | Federal Funds |
NT | 2020-039 | Replace 2 Revenue Vehicles | $ 142,080 | $ 23,680 | $ 118,400 | |
TOTAL BUDGET
$ 142,080
$ 118,400
Attachment B
CY 2021 CARES ACT 2020 TRANSIT CAPITAL PROJECTS FUND | ||||
Subrecipent | Grant | Project | Total | Federal Funds |
OE | CARES Act 2020-014 | Bus Rolling Stock (3) | $ 202,008 | $ 202,008 |
Valpo | CARES Act 2020-014 | Parking lot repair | $ 3,957 | $ 3,957 |
ECT | CARES Act 2020-014 | Support Vehicle (2) | $ 8,594 | $ 8,594 |
NT | CARES Act 2020-014 | Misc Support Equipment | $ 41,485 | $ 41,485 |
OE | CARES Act 2020-014 | Misc Support Equipment | $ 9,544 | $ 9,544 |
PC | CARES Act 2020-014 | Misc Support Equipment | $ 36,502 | $ 36,502 |
Valpo | CARES Act 2020-014 | Misc Support Equipment | $ 1,897 | $ 1,897 |
ECT | CARES Act 2020-014 | Misc Support Equipment | $ 39,421 | $ 39,421 |
City of LaPorte | CARES Act 2020-014 | Bus Replacements (2) | $ 143,200 | $ 143,200 |
City of LaPorte | CARES Act 2020-014 | Misc Support Equipment | $ 15,391 | $ 15,391 |
TOTAL BUDGET
$ 501,999
$ 501,999
Attachment C
CY 2022 TRANSIT OPERATING PROJECTS FUND
Federal Req. Match Total
City of East Chicago | |
Preventative Maintenance | 287,064 |
Complementary Paratransit | 368,794 |
Operating Assistance | 186,437 |
Existing Grants | 423,388 |
57,787 |
92,198 |
186,437 |
423,388 |
344,851 |
460,992 |
372,874 |
846,776 |
City of LaPorte | |
Operating Assistance | 259,890 |
Existing Grants |
259,890 519,780
City of Valparaiso | |
Capital Cost of Contracting | 1,055,330 |
263,888 1,319,218
North Township | |
Preventative Maintenance | 28,000 |
Operating Assistance | 190,000 |
Existing Grants | 116,282 |
7,000 |
190,000 |
116,282 |
35,000 |
380,000 |
232,564 |
Opportunity Enterprises | |
Preventative Maintenance | 102,000 |
Existing Grants | 77,615 |
20,400 |
15,523 |
122,400 |
93,138 |
Porter County Community Services | |
Preventative Maintenance | |
Operating Assistance | 75,000 |
Existing Grants | 335,850 |
- |
75,000 |
154,000 |
- |
150,000 |
489,850 |
Southlake Community Services | |
Preventative Maintenance | 101,102 |
Operating Assistance | 194,960 |
Existing Grants | 114,488 |
20,220 |
194,960 |
89,000 |
121,322 |
389,920 |
203,488 |
PMTF Funds (NT,SLCS,PCCS, OE & CV) | |
Public Mass Transportation Fund | 522,681 |
- |
522,681 |
TOTAL | 4,438,881 2,165,973 6,604,854 |
Attachment D
CY 2021 LAPORTE COUNTY REVOLVING LOAN FUND
2021 2022 |
Budget Budget |
New Loans | 85,000 | 200,000 | ||
TOTAL | 85,000
| 200,000
| ||
TOTAL BUDGET | 200,000 |
Attachment D
LaPorte RLF 2022 Administration Budget |
Per RLF Management Plan 50% of interest can be used for Administrative Cost |
REVENUES |
RLF INTEREST INCOME 7,800 |
CLOSING CHARGES 2,000 |
TOTAL REVENUES 9,800 |
EXPENDITURES |
SALARY |
FRINGE BENEFITS ALLOC |
INDIRECT COST ALLOC |
2,500 |
2,025 |
2,400 |
6,925 |
DEPARTMENTAL |
COMMUNICATION |
GENERAL USE SUPPLIES |
365
510
CONTRACTUAL |
LA PORTE RLF SERVICES |
875
2,000
2,000
TOTAL EXPENSES 9,800
FUND BALANCE - ENDING -
Attachment D | |
CARES ACT RLF 2022 Administration Budget | |
Per RLF Management Plan 50% of interest can be used for Administrative Cost | |
REVENUES | |
EDD CARES ACT 2020 | 461,648 |
RLF INTEREST INCOME | 25,085 |
CLOSING CHARGES | 7,000 |
TOTAL REVENUES | 493,733 |
EXPENDITURES |
SALARY |
FRINGE BENEFITS ALLOC |
INDIRECT COST ALLOC |
11,900 |
7,854 |
9,163 |
28,917 |
DEPARTMENTAL |
COMMUNICATION |
GENERAL USE SUPPLIES- AF Loan |
368
2,800
CONTRACTUAL |
LA PORTE RLF SERVICES |
3,168
461,648
461,648
TOTAL EXPENSES 493,733
FUND BALANCE - ENDING -
BY AGREEMENT ENTERED INTO the 20th day of January 2022, by and between the NORTHWESTER:\! INDIANA REGIO AL PLA I G COMMISSION, hereinafter referred to as "NIRPC", and MR. TYSON WARNER, hereinafter referred to as "Executive Director", the following is hereby agreed to:
WHEREAS, IRPC is desirous of securing the services of an Executive Director to assist in implementation of its statutory role and function including that of a metropolitan planning organization for Northwest lndi.ma; and
WHEREAS, Tyscn Warner has served as the Executive Director of TRPC since January I, 2013, and the parties to thi agreement are desirous of renewing and otherwise extending his serving as the Executive Director ofNIRPC.
NOW, THEREFORE, BE TT RESOLVED that the parties to this agreement hereby do mutually agree as follows:
The term of this agreement shall commence on January l, 2022, and shall terminate as of December 31, 2024 unless otherwise terminated pursuant to the provisions of this agreement.
Mr. Tyson Warner shall pe1form the function and serve in the role of the Executive Director of NIKPC during the term of this agreement. In addition to those matters which may from time to time be assigned to him by NIRPC, Mr. Warner's role and responsibility as Executive Direct(>r for NIRPC are more particularly described and identified in the Job Description attachf:d hereto and made a part hereof as Exhibit "A" to this agreement.
The Executive Director shall meet with the Chairman of the NIRPC Commission following the Chainnan's appointment in 2022 2023 and 2024, for purposes of establishing goals for each of the years of this Employment Agreement. The Executive Director and Chairman, togeth r with other NlRPC appointed officers as may desire, shall meet mid-year and near end-of year to discuss progress, provide feedback on performance, and to make such other adjustrnent and course correction to goals as may be necessary or beneficial.
During the first year of this agreement, NlRPC agrees to pay to its Executive Director the stun of One Hundred Sixty-Four Thousand Five Hundred Fifty Dollars ($164,500.00) to be paid in the same manner and fashion as payments are made to other IRPC employees during the course of the calendar year. The Executive Director salary for the second year and third years c·if this agreement shall be determined through discussions with the Executive Director and ar.y salary increases shall be predicated upon positiv performance evaluations, the availability of funding and the approval of the Full lRPC Commission. Additionally, the followi.ng benefits of employment shall be available to the Executive Director:
l. . Insurance: The same health insurance and benefit programs provided to NIRPC employees shall be available to the Executive Director.
: Vehicle: The Executive Director will be reimbursed for mileage at the applicable IRS rate for use of his personal vehicle in conducting JR.PC business. The
· Executive Director may have use of a NIRPC owned or NIRPC leased vehicle as
. may be authorized by the Chairman of the Full NIRPC Commission.
Professional Memberships: NIRPC will maintain membership for its Executive Director in ICMA, APA and the Congress of New Urbanism and their respective state chapters and will either pay for, or reimburse, the Executive Director for pa11icipation in these organizations annual conferences.
Retirement Benefit: The Executive Director will participate in ICMA-RC 457 Plan. NIRPC will contribute to that plan in the same amount as would have been paid on the Executive Director's behalf to PERF.
NARC Participation: NIRPC shall pay for or reimburse the Executive Director to participate in events and activities of the National Association of Regional Councils (NARC) on behalf of NIRPC.
Vacation: The Executive Director shall be entitled to four (4) weeks of paid vacation
· during each calendar year of employment under this agreement. While vacation is intended to be used throughout the course of year, vacation shall be allowed to accrue within the same limits allowed to other NIRPC employees as long as the Executive Director is employed by NJRPC. Should any accrued vacation remain upon termination of this agreement, the Executive Director shall be paid in accordance with Section E below.
Expense Reimbursement: The Executive Director shall be entitled to reimbursement for business related expenses pursuant to the guidelines and procedures established by NIRPC. In addition thereto, the Executive Director shall be paid the sum of
$150.00 per month as reimbursement for his job related use of communication technology. This reimbursement shall not preclude the use of data connected equipment as may be issued and paid for by NIRPC.
This agreement may be terminated upon the agreement of the parties or upon a showing of just ca11se:
In the event the Executive Director is terminated pursuant to this Agreement, NIRPC agrees to pay the Executive Director a severance payment equal to twelve (12) weeks base salary, plus accrued and unused vacation days; provided, however, that in the event the Executive Director is terminated because of his conviction of any illegal act, then in that event, NIRPC shall have no obligation to pay the severance pay sum designated in this paragraph.
In the event the Executive Director voluntarily resigns his position with NIRPC, he shall give NIRPC at least sixty (60) day notice of such resignation prior to the cessation of the performance of his duties hereunder unless otherwise agreed to by TRPC. If the Executive Director resigns, he shall not be paid the severance pay above but shall receive accrued and unused vacation days; provided, however, the
Executive Director shall be paid his base sala1y during said 60 day notice period.
This agreement shall be deemed as superseding and replacing the terms and conditions of the prior employment agreements entered into by NIRPC and the Executive Director.
For tlK purpose of interpreting the terms and conditions of this agreement, the laws of the State of Indiana shall apply.
ALL OF WHTCH HA YING BEEN AGREED to by these parties and memorialized by the signatures affixed hereto:
NORTHWESTERN INDIANA REGIONAL PLANNTNG COMMISSION
By: _ Chairperson
ATTEST:
Tyson Warner
Exhibit A
Job Description
Job Title: Executive Director
Agency: Northwestern Indiana Regional Planning Commission
Reports to: orthwestern Indiana Regional Planning Commission
The Executive Dir1:,ctor is the Chief Administrative Officer and regular Technical dvisor of the Commission. The s-1bject of the supervision by the Commission and in furtherance of the purpose of the Commission, the Executive Director role and responsibilities are that which are identified in IC 36-7-7.6-1l(Executive Director; Powers and Duties). All of which is intended to facilitate fulfillment of NIRPC's overall purpose as defined in IC 36-7-7.6-12.
