FINANCE AND PERSONNEL COMMITTEE
Meeting Agenda –
Thursday, October 20, 2022 -- 8:00 a.m.
Dune Room – NIRPC Office
Call to Order & Pledge of Allegiance
6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
Meeting Minutes of September 15, 2022 Pages 1 – 2
ACTION REQUESTED: Approval
Review of Financial Status – September 2022 Budget vs Actual Pages 3 - 14
Bank Statement Reconciliations (pg. 3-9)
General Fund Expenses YTD September 2022 (pg. 10-11)
General Fund Revenue YTD September 2022 (pg. 12)
CARES Expenses YTD September 2022 (pg. 13)
CARES Revenue YTD September 2022 (pg. 14)
Approval of General Fund Claims Register – September 2022 Pages 15 - 18
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – September 2022 Pages 19
ACTION REQUESTED: Approval
NIRPC 2022 Budget Amendment #1 Pages 20
ACTION REQUESTED: Approval
Eco-Interactive Contract Addendum III Pages 21
ACTION REQUESTED: Recommendation for Approval
NIRPC 2023 Preliminary Budget
Personnel update
Other Business
Adjournment
The next meeting is scheduled for December 8, 2022 at 8:00 a.m.
Pages 22 - 32
The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program. Users may access the Relay Indiana Service by calling 711 or 1-800-743-3333. Requests for alternative formats may be made 72 hours in advance by contacting nirpc@nirpc.org.
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE
September 15, 2022 / NIRPC Dune Room – 8:00 a.m.
Members present in-person
Bob Carnahan, Don Craft, Tom Dermody, Denise Ebert, Justin Kiel, Wendy Mis, George Topoll
Staff and others present in-person
Talaya Jones, Meredith Stilwell, Ty Warner, Stephanie Kuziela, Kathy Luther, David Hollenbeck
Call to Order
Chairperson Dermody called the meeting to order with the Pledge of Allegiance.
Approval of Minutes
The minutes of the July 21, 2022 meeting were presented. On motion by Bob Carnahan, second by George Topoll and no opposition, the minutes were approved.
Review of Financial Status – July 2022 Budget vs Actual
Talaya Jones presented the July 2022 bank reconciliations for the NIRPC general account, the CARES Revolving Loan Fund account, and the Revolving Loan Fund Account.
Talaya presented the July 2022 general fund financial reports. Total expenditures for the period ending July 31, 2022, were $3,710,453 of the $9,201,349 budgeted. Total general fund revenue for the period was $1,014,182 of the $4,311,106 budgeted.
Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act financial reports, year to date July 2022. Total NIRPC CARES fund expenditures for the period ending July 31, 2022, was
$304,737 of the $1,153,515 budgeted. Total CARES revenue collected for the period was $294,970 of the $1,352,229 budgeted.
Approval of Claims Registers – July 2022
Talaya presented the July 2022 General Fund claims register totaling $441,021.35 to the Committee for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the General Fund register claims in the amount of $441,021.35 was approved. The CARES Act register of claims totaling
$30,396.79 was presented for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the CARES Act register of claims in the amount of $30,396.79 was approved. The CARES RLF register of claims totaling $50,000.00 was presented for approval. On motion by Bob Carnahan, second by George Topoll and no opposition, the CARES RLF register of claims in the amount of
$50,000.00 was approved. The RLF register of claims totaling $70,284.75 was presented for approval. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the RLF register of claims in the amount of $70,284.75 was approved.
Review of Financial Status – August 2022 Budget vs Actual
Talaya presented the August 2022 bank reconciliations for the NIRPC general account, the CARES Revolving Loan Fund account, and the Revolving Loan Fund Account.
Talaya presented the August 2022 general fund financial reports. Total expenditures for the period ending August 31, 2022, were $4,241,777 of the $9,201,349 budgeted. Total general fund revenue for the period was $1,154,868 of the $4,311,106 budgeted.
Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act financial reports, year to date August 2022. Total NIRPC CARES fund expenditures for the period ending August 31, 2022, was
$313,816 of the $1,153,515 budgeted. Total CARES revenue collected for the period was $325,733 of the $1,352,229 budgeted.
Approval of Claims Registers – August 2022
Talaya presented the August 2022 General Fund claims register totaling $544,972.29 to the Committee for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the General Fund register of claims in the amount of $544,972.29 was approved. The CARES Act register of claims totaling $7,953.57 was presented for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the CARES Act Register of claims in the amount of $7,953.57 was approved. The RLF
register of claims totaling $25.48 was presented for approval. On motion by Wendy Mis, second by Bob Carnahan and no opposition, the RLF Register claims in the amount of $25.48 was approved.
December 2021 Financials
Talaya presented the January - December 2021 general fund financial reports. Total expenditures were
$4,810,681 of the $11,981,765 budgeted. Total general fund revenue for the period was $3,046,474 of the $3,574,659 budgeted.
Talaya presented the January – December 2021 Coronavirus Aid, Relief and Economic Securities (CARES) Act financial reports. Total NIRPC CARES fund expenditures were $2,882,332 of the
$4,717,013 budgeted. Total CARES revenue collected for the period was $3,162,330 of the
$4,307,009 budgeted.
NIRPC Resolution 22-18 – Approval of a Comprehensive Conflict of Interest Policy
Lisa Todd presented Resolution 22-18 for approval of a comprehensive conflict of interest policy. NIRPC was awarded a grant from the United States Department of Transportation under the Rebuilding American Infrastructure with Sustainability and Equity (RAISE) program for several major portions of the Marquette Greenway Trail. The Trail extends from Chicago, Illinois to New Buffalo, Michigan, through many scenic parts of Northwest Indiana. NIRPC needs to put out several RFQs and RFPs for professional services, and the hired firms must follow a code of ethics and disclose if there is or will be any conflict of interest. As the direct recipient of the grant funds, NIRPC needs to adopt a conflict-of-interest policy.
INDOT already has a policy which NIRPC would like to copy and adopt. Attorney Hollenbeck as already reviewed the policy and given his blessing. On motion by George Topoll and Second by Bob Carnahan and no opposition, the Committee approved Resolution 22-18 to adopt the comprehensive conflict of interest policy.
SME Contract Amendment 1
Kathy Luther presented SME contract Amendment 1. NIRPC entered into an agreement on March 19, 2020 with SME to provide technical and professional environmental services under a Brownfield Coalition Assessment Grant. Since SME is already conducting assessment work, the Coalition and the City of Hammond would like to utilize them to assess a parcel which is not eligible for use of federal grant funds. NIRPC has entered into an MOU with Hammond and is adding funds to pay the contractor, for which Hammond will reimburse NIRPC. The new task shall not exceed $21,925, unless all parties agree in writing on an additional scope of work and cost up to $60K. On motion by Bob Carnahan, second by Richard Hardaway and no opposition, the Committee approved SME contract amendment 1 to be forwarded with a favorable recommendation to the NIRPC Board for approval.
Personnel updates
NIRPC now has 4 open positions. In addition to the already open positions, Ty announced that NIRPC’s Regional Planner/Spatial Analyst (GIS mapping), Peter Kimball, has left NIRPC. Ty held an exit interview with Peter and indicated he had nothing bad to say about NIRPC and is going to the Grand Rapids MPO where he will be paid more. NIRPC’s Accountant, Stephanie Kuziela will be leaving in December.
Stephanie stated she has an opportunity to take over a tax business and will be a business owner. Mayor Dermody stated that Cities and Councils are also struggling to keep people. Ty noted that a couple of the current openings meshed more than one position and possibly weren’t the best mashups. Discussion followed regarding the need for an increase in local share which could work toward raises and new positions. All of the local share is used every year and while there are more federal funds to be tapped, there is not enough local share for match. Previously Michael Griffin drafted legislature asking to right size the local share based on current value and add with increases based on the consumer price index so NIRPC would not have to keep coming back. NIRPC’s Chair, Justin Kiel, has taken up the cause. Bob Carnahan stated Cedar Lake is hiring within for their Planning Director position.
Other Business None
Adjournment
There being no further business, the meeting was adjourned.
10-13-2022 | |||
Closing Balance from Previous Statement........................................................................................... | 8/31/2022 | 949,948.55 | |
28 | Deposits and Other Additions Totaling...................................................................... | 1,543,898.94 | |
128 | Checks and Other Withdrawls Totaling..................................................................... | 1,163,927.47 | |
1 | Adjustments Totaling.............................................................................................. | 25.48 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 9/09/2022 | 120.25 | |
Interest Earned....................................................................................................... | 9/30/2022 | 62.91 | |
Closing Balance for this Statement..................................................................................................... | 9/30/2022 | 1,329,888.16 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 9/30/2022 | 1,284,035.45 | |
Open Activity from Bank Register............................................................................. | (45,852.71) | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement.............................................................................................. | 1,329,888.16 | ||
Date | Reference | Deposit Description | Amount |
9/02/2022 | 8272900 | PMTF April-June 2022 | 111,608.00 |
9/07/2022 | 8272901 | Portage EDC August Sublet | 150.00 |
9/09/2022 | 8272902 | NIRPC CARES DeLage April-June 2022 | 619.00 |
9/09/2022 | 8272903 | CARES REIMB AF Sept-Dec 2022 | 1,361.00 |
9/09/2022 | 8272904 | Draw 52-22 Valpo Operating Assistance CMAQ Apr-Jun 2022 IN-2019-029 | 52,339.00 |
9/09/2022 | 8272905 | Draw 53-22 Valpo CCC-VLine Apr-Jun 2022 IN-2019-030 | 64,081.00 |
9/09/2022 | 8272906 | Draw 54-22 Valpo CCC- DASH Apr-Jun 2022 IN-2017-027 | 54,632.00 |
9/09/2022 | 8272907 | Draw 55-22 PCACS Preventative Maintenance Apr-Jun 2022 IN-2018-026 | 5,806.00 |
9/09/2022 | 8272908 | Draw 56-22 PCACS Operating Assistance Apr-Jun 2022 IN-2019-030 | 2,576.00 |
9/09/2022 9/09/2022 | 8272909 8272910 | Draw 57-22 PCACS Enhanced Mobility Operating Assistance Apr-Jun 2022 IN-2019- 030 Draw 58-22 Laporte Operating Assistance Apr-Jun 2022 IN-2020-039 | 32,044.00 42,224.00 |
9/09/2022 | 8272912 | Draw 61-22 LCCS Preventative Maintenance Apr-Jun 2022 IN-2020-039 | 15,495.00 |
9/09/2022 | 8272913 | Draw 62-22 ECT Preventative Maintenance Apr-Jun 2022 IN-2019-030 | 51,331.00 |
9/09/2022 | 8272914 | Draw 63-22 ECT Paratransit Apr-Jun 2022 IN-2020-039 | 57,691.00 |
9/09/2022 | 8272915 | Draw 64-22 ECT Operating Assistance Apr-Jun 2022 IN-2020-039 | 37,808.00 |
9/09/2022 | 8272916 | Draw 65-22 OE Preventative Maintenance Apr-Jun 2022 IN-2020-039 | 19,540.00 |
9/09/2022 | 8272917 | NIRPC REIMB 2020 FTC AUDIT REIMB IN-2018-026 | 10,227.00 |
9/14/2022 | 8272911 | Draw 60-22 LCCS Enhanced Mobility Operating Assistance Apr-Jun 2022 IN-2020-039 | 101,024.00 |
9/14/2022 | 8272918 | 4th Quarter 2022 PL Reimbursement | 708,952.13 |
9/19/2022 | 8272924 | FTA CARES REIMB ROUTEMATCH OCT 2022 | 1,534.00 |
9/20/2022 | 8272921 | Hobart Trail Counter Local Share | 723.00 |
9/20/2022 | 8272922 | Highland Trail Counter Local Share | 723.00 |
9/21/2022 | 8272919 | LaPorte Trail Counter | 723.00 |
9/22/2022 | 8272920 | PCA Membership Fees | 2,000.00 |
9/26/2022 | 8272923 | FTA Reimb for Valpo TOD Lighting Project | 91,657.00 |
9/29/2022 | 8272926 | Merrillville Local Share 2 Trail Counters | 1,446.00 |
9/29/2022 | 8272927 | Portage Local Share 2 Trail Counters | 1,446.00 |
9/30/2022 | 8272925 | Brownfield Reimbursement Jan-Aug 2022 | 74,138.81 |
Total Deposits: | 1,543,898.94 | ||
Date | Check | To Check Description | Amount |
7/02/2019 | 0002363 | Kelly Tripp Refund fee for tree steward workshop | 28.83 |
8/27/2019 | 0002409 | United Way of Northwest Indiana 8/5 - 8/18/2019 pay period - United Way | 33.85 |
3/23/2021 4/07/2022 | 0002764 0002975 | American of Metropolitan Planning NIRPC-Job Posting Director of Transportaion Organization City of Portage, The Lease-APR | 50.00 19,725.67 |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 10/07/2022 @ 10:54 AM
Reconciliation - General
Page: 1
Date | Check To Check Description | Amount |
7/21/2022 | 0003046 Quill Corporation Logitech wireless mouse/toilet paper/8.5x11 | 160.14 |
9/07/2022 | paper,canary, coupon 0003072 Vantage Point Consulting Inc Invoices 4996, 5070 | 5,625.00 |
9/14/2022 | 0003075 BRYCO SERVICES Office Cleaning-SEPT | 1,425.00 |
9/29/2022 | 0003095 Accelerate Indiana Municipalities Invoices 5166, 92437 | 690.00 |
9/29/2022 | 0003096 BASIC Monthly Fee for COBRA Admin Annually | 480.00 |
9/29/2022 | 9/1/22 0003097 Drive Clean Indiana, Inc Drive Clean IN 2022 Golf Outing Hole | 750.00 |
9/29/2022 | Sponsorship/Local-Federal Share 0003098 TIP Strategies, Inc. Pymt 8 of 8 Economic Resilency Plan- | 16,850.37 |
9/29/2022 | FINAL/Airfare/Ground Trans/Lodging/Meals 0003099 United Way of Northwest Indiana Pay period ending 9/11/2022,United Way | 33.85 |
Total Unmarked Checks: 45,852.71 Total Checks: | 45,852.71 | |
Date | Reference Adjustment Description | Amount |
9/01/2022 | 0000040 Correct ACH payment to D. Kane for mileage reimb s/b from RLF | 25.48 |
9/09/2022 | Service Charge | -120.25 |
9/30/2022 | Interest Earned | 62.91 |
Total Adjustments: | -31.86 |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 10/07/2022 @ 10:54 AM
Reconciliation - General
Page: 2
Trial Balance - Cash
Run: 10/07/2022 at 10:5N7 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 9/30/2022
Page: 1
All Balance
1.1.001.0000.1010.0 General Cash 1,284,035.45
Total 1,284,035.45
STK 10/7/22
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION Run: 10/03/2022 @ 2:30 PM Reconciliation - Revolving Loan Fund Page: 1 | ||
STK 10/3/22 | 10/14/2022 | |
Closing Balance from Previous Statement........................................................................................... | 8/31/2022 | 219,972.65 |
2 Deposits and Other Additions Totaling...................................................................... | 2,581.24 | |
0 Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
1 Adjustments Totaling.............................................................................................. | -25.48 | |
0 Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | |
Interest Earned....................................................................................................... | 9/30/2022 | 5.46 |
Closing Balance for this Statement..................................................................................................... | 9/30/2022 | 222,533.87 |
Difference............................................................................................................... | 0.00 | |
Cash Balance from General Ledger.................................................................................................... | 9/30/2022 | 222,533.87 |
Open Activity from Bank Register............................................................................. | 0.00 | |
Adjustment for Service Charges and Interest............................................................. | 0.00 | |
General Ledger Reconciliation to Statement.............................................................................................. | 222,533.87 | |
Date | Reference | Deposit Description | Amount |
9/13/2022 | 8272889 | Hammer RLF Sept Loan Payment | 1,381.24 |
9/16/2022 | 8272890 | September 2022 RLF Payment | 1,200.00 |
Total Deposits: | 2,581.24 | ||
Date | Reference | Adjustment Description | Amount |
9/01/2022 | 0000040 | -25.48 | |
9/30/2022 | Interest Earned | 5.46 | |
Total Adjustments: | -20.02 |
Trial Balance - Cash
Run: 10/06/2022 at 10:3N3 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 9/30/2022
Page: 1
All Balance
2.3.050.0000.1010.0 LaPorte Cash 222,533.87
Total 222,533.87
STK 10/6/22
Deposits and Other Additions Totaling...................................................................... | 1,311.48 | ||
0 | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | ||
Interest Earned....................................................................................................... | 9/30/2022 | 0.13 | |
Closing Balance for this Statement..................................................................................................... | 9/30/2022 | 8,408.28 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 9/30/2022 | 8,408.28 | |
Open Activity from Bank Register............................................................................. | 0.00 | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement.............................................................................................. | 8,408.28 | ||
Date | Reference | Deposit Description | Amount | |
9/07/2022 | 8272868 | Divine Strategy CARES RLF Payment | 506.23 | |
9/07/2022 | 8272869 | Healthy Smiles CARES RLF Aug Payment | 805.25 | |
Total Deposits: | 1,311.48 | |||
Date | Reference | Adjustment Description | Amount | |
9/30/2022 | Interest Earned | 0.13 | ||
Total Adjustments: | 0.13 |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 10/03/2022 @ 2:31 PM
STK 10/3/22
Reconciliation - CARES RLF Bank Account
Page: 1
Closing Balance from Previous Statement...........................................................................................
10-13-2022
8/31/2022 7,096.67
Trial Balance - Cash
Run: 10/06/2022 at 10:3N8 AOMRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 9/30/2022
Page: 1
All Balance
4.3.050.0000.1010.0 CARES RLF Cash 8,408.28
Total 8,408.28
STK 10/6/22
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022 |
Line Items | FY 2022 Budget | YTD September FY 22 Budget % Expended balance |
Salaries | |||
5020-1 | Total Salaries | 1,530,748 | 987,195 36% |
Salaries Sub-Total | 1,530,748 | 987,195 36% |
Fringe Benefits | ||||
5121-9 | FICA Contributions | 121,685 | 74,306 | 39% |
5122-9 | Workers Compensation | 5,000 | 2,679 | 46% |
5123-9 | Unemployment Compensation | 3,000 | 1,002 | 67% |
5141-9 | PERF Contributions | 199,688 | 124,966 | 37% |
5142-9 | Health Insurance | 240,000 | 141,611 | 41% |
5143-9 | Life & Disability Insurance | 24,000 | 8,321 | 65% |
5145-9 | ICMA | 24,480 | 16,818 | 31% |
5146-9 | Staff Development | 20,000 | 4,185 | 79% |
Fringe Benefits Sub-Total | 637,853 | 373,889 | 41% | |
Occupancy | ||||
5221-9 | Office Lease | 236,708 | 177,531 | 25% |
5222-9 | Property Insurance | 6,500 | 4,980 | 23% |
5223-9 | Building Maintenance | 18,540 | 13,792 | 26% |
5224-9 | Utilities | 30,650 | 3,456 | 89% |
Occupancy Sub-Total | 292,398 | 199,759 | 32% | |
Maintenance | ||||
5241-9 | Copier Leasing/Maintenance | 18,000 | 8,530 | 53% |
5243-9 | Computer Service/Maintenance | 43,736 | 37,239 | 15% |
5244-9 | Telephone Service/Maintenance | 18,900 | 8,619 | 54% |
Combined Copier/IT/Phone Service/Maintenance | 80,636 | 54,388 | 33% | |
5249-9 | Other Equipment Maintenance | 2,000 | 525 | 74% |
Maintenance Sub-Total | 82,636 | 54,913 | 34% | |
Departmental | ||||
5410-1 | Communications: Commission/Ex. Dir. | 35,000 | 11,861 | 66% |
5410-2 | Communications: Transportation | 239,000 | 120,314 | 50% |
5410-3 | Economic Development District | 29,583 | 212 | 99% |
5410-4 | Communications: Subgrantee Management | 25,000 | 0 | 100% |
5410-5 | Communications: Environmental Programs | 28,947 | 5,078 | 82% |
5410-8 | Communications: Partner Agency | 1,000 | 0 | 100% |
5410-9 | Communications: Allocated Functions | 25,000 | 22,556 | 10% |
5420-5 | Promotional Expenses: Environmental Programs | 14,953 | 9,951 | 33% |
5430-9 | General Use Supplies Expense | 5,000 | 3,115 | 38% |
Departmental Sub-Total | 403,483 | 173,086 | 57% | |
Contractual | ||||
5602-9 | Legal Services | 23,400 | 15,750 | 33% |
5603-9 | Audit and Accounting | 70,000 | 9,347 | 87% |
5604-9 | LaPorte RLF Services | 2,000 | 670 | 66% |
5610-4 | Transit Oversight | 17,347 | 12,784 | 26% |
5610-5 | Environmental Projects | 837,314 | 457,935 | 45% |
5610-2 | Planning | 320,000 | 312,300 | 2% |
5619-9 | Organizational Dev. | 2,000 | 0 | 100% |
5610-0 | Board Development | 2,000 | 0 | 100% |
5610-2 | E-Tip | 95,009 | 24,846 | 74% |
Contractual Sub-Total | 1,369,070 | 833,632 | 39% | |
Capital Outlays | |||
5910-0 | Furniture and Equipment | 154,200 | 0 100% |
Capital Outlays Sub-Total | 154,200 | 0 100% | |
TOTAL GENERAL FUND EXPENDITURES | 4,470,388 | 2,622,474 41% |
LaPorte Revolving Loan Fund | 150,000 | 69,640 |
Transit Capital Fund | 142,080 | 524,239 |
Transit Operating Fund | 4,438,881 |
2,098,523
TOTAL EXPENDITURES | 9,201,349 | 5,314,876 | |
1,200,000
1,148,061
1,026,803
1,000,000
987,195
833,632
800,000
600,000
478,390
373,889
400,000
302,612
219,299
199,759
173,086
200,000
61,977 54,913
-
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD September Budget YTD September Expended
Contractuals
32%
Salaries
38%
Departmental
6%
Fringe
Benefits 14%
Maintenance
2%
Occupancy
8%
Salaries
Fringe Benefits Occupancy Maintenance Departmental Contractuals
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022 |
Line Items | FY 2022 Budget | YTD September YTD Variance FY 22 Budget % Collected (Under)/Over balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 540,271 | 0 | 0% |
1.1.4210 | Federal Agencies | 896,383 | 269,429 | 626,954 | 70% |
1.1.4310 | State Agencies | 2,668,379 | 1,085,062 | 1,583,317 | 59% |
1.1.4410 | Local Agencies | 76,760 | 11,819 | 64,941 | 85% |
1.1.4610 | Non-Governmental | 48,513 | 23,572 | 24,941 | 51% |
1.3.4260 | Economic Development District | 70,000 | 36,013 | 33,987 | 49% |
1.1.4800 | Interest Income | 10,800 | 4,613 | 6,187 | 57% |
Revenue Total | 4,311,106 | 1,970,779 | 2,340,327 | 54% |
Local Agencies
State Agencies
55%
1%
Non-Governmental 1%
Interest Income
0%
Economic Development
District
2%
County Appropriations
27%
Federal Agencies
14%
County Appropriations Federal Agencies State Agencies
Local Agencies
Non-Governmental
Economic Development District Interest Income
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022 |
Line Items | FY 2022 Budget | YTD September Expended | FY 22 Budget % balance |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries | 59,900 | 28,762 | 52% |
Salaries Sub-Total | 59,900 | 28,762 | 52% |
120,000
104,634
100,000
101,000
80,000
59,900
60,000
40,000
28,762
25,800
15,711
20,000
3,168
999
-
SALARIES
CONTRACTURAL
DEPARTMENTAL
CAPITAL OUTLAYS
Budget Expended
Contractual
EDD Institutional CARES ACT | 101,000 | 104,634 | -4% |
Contractual Sub-Total | 101,000 | 104,634 | -4% |
Departmental | |||
Communications | 3,168 | 858 | 73% |
PPE Supplies & Office Supplies | 141 | 0% | |
Departmental Sub-Total | 3,168 | 999 | 68% |
Capital Outlays | |||
Furniture and Equipment | 25,800 | 15,711 | 39% |
Capital Outlays Sub-Total | 25,800 | 15,711 | 39% |
TOTAL NIRPC CARES FUND EXPENDITURES | 189,868 | 150,105 | 21% |
CARES Revolving Loan Fund | 461,648 | 100,709 |
CARES Transit Capital Fund | 491,999 | 80,102 |
CARES Transit Agency Fund | 10,000 | 10,000 |
TOTAL EXPENDITURES | 1,153,515 | 340,916 |
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2022 |
Line Items | FY 2022 Budget | YTD September Collected | FY 22 Budget % balance |
CARES ACT OPERATING | |||
Operating Revenue | 25,800 | 15,175 | 41% |
EDD RLF Revenue | 477,992 |
3,910 | 99% |
CARES ACT RLF
CARES Operating
5%
CARES Transit Capital
24%
CARES Transit
Agency
3%
NWI Recover RLF (CARES
RLF)
18%
Economic Development
District 50%
CARES Operating
Economic Development District
NWI Recover RLF (CARES RLF)
CARES Transit Agency CARES Transit Capital
Economic Development District | 304,553 | 165,952 | 46% |
808,345 | 185,037 | 77% |
CARES ACT EDA
CARES ACT RLF | Loan Proceeds | 32,085 | 50,000 | -56% |
CARES ACT RLF | Loan Application Fees & Interest | 9,800 | 3,852 | 61% |
CARES AGENCY | FTA Revenue | 10,000 | 10,000 | 0% |
CARES TRANSIT CAPITAL | FTA Revenue | 491,999 | 80,102 | 84% |
Revenue Total | 1,352,229 | 328,992 | 76% |
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
9/2/2022 | 5137 | Anthem Life | General Fund 2155.0 | $ 96.50 | $ 96.50 | C5137 | EE for Life Insurance-SEPT |
9/2/2022 | 5137 | Anthem Life | General Fund 5143.9 | $ 355.11 | $ 355.11 | C5137 | ER for Life Insurance-SEPT |
9/2/2022 | 5088 | Dialpad | General Fund 5244.9 | $ 656.00 | $ 656.00 | C5088 | Telephone Service-Sept |
9/6/2022 | B-6328 | HSA | General Fund 2150.0 | $ 1,250.53 | $ 1,250.53 | C6328 | Pay period ending 8/28/2022-HSA |
9/6/2022 | 5115 | MissionSquare Retirement | General Fund 5145.9 | $ 934.36 | $ 934.36 | C5115 | ER paid for Ty Warner 8/15/2022-8/28/2022 |
9/6/2022 | B-6326 | MissionSquare Retirement | General Fund 2146.0 | $ 830.00 | $ 830.00 | C6326 | Pay period ending 8/28/200-ICMA |
9/6/2022 | Payroll | $ 35,064.81 | $ 35,064.81 | Payroll | |||
9/6/2022 | 5126 | United HealthCare Srvcs, Inc. | General Fund 2152.0 | $ 2,116.74 | $ 2,116.74 | C5126 | EE paid for SEPT Health Insurance |
9/6/2022 | 5126 | United HealthCare Srvcs, Inc. | General Fund 5142.9 | $ 11,994.85 | $ 11,994.85 | C5126 | ER paid for SEPT Health Insurance |
9/7/2022 | B-6323 | Federal & Fica | General Fund 2140.0 | $ 4,784.85 | $ 4,784.85 | C6323 | Pay period ending 8/28/2022, FWT, empfica, empficamed, fica ficamed-Federal Tax Withholdings Payable |
9/7/2022 | B-6323 | Federal & Fica | General Fund 2142.0 | $ 7,052.88 | $ 7,052.88 | C6323 | Pay period ending 8/28/2022, FWT, empfica, empficamed, fica ficamed-FICA Tax Withholdings Payable |
9/7/2022 | 5114 | INPRS | General Fund 5141.9 | $ 0.03 | $ 0.03 | C5114 | 8/15 Thru 8/28/22-p/r 9/3/22-ER rounding adj. |
9/7/2022 | B-6325 | INPRS | General Fund 2149.0 | $ 5,984.58 | $ 5,984.58 | C6325 | Pay period ending 8/28/2022-EmpPerf [NIRPC] |
9/9/2022 | 5138 | DeLage | General Fund 5243.9 | $ 3,723.91 | $ 3,723.91 | C5138 | IT |
9/9/2022 | 5138 | DeLage | General Fund 5241.9 | $ 842.74 | $ 842.74 | C5138 | Copier |
9/9/2022 | 5138 | DeLage | General Fund 5910.0 | $ 206.25 | $ 206.25 | C5138 | M365 |
9/9/2022 | 5118 | Lake County Community Services, Inc. | General Fund 5760.0 | $ 41,499.00 | $ 41,499.00 | C5118 | Apr-Jun 2022 PMTF Reimb |
9/9/2022 | 5116 | Opportunity Enterprises | General Fund 5760.0 | $ 47,351.00 | $ 47,351.00 | C5116 | Apr-Jun 2022 PMTF Reimb |
9/9/2022 | 5117 | Porter County Aging and Community Services | General Fund 5760.0 | $ 22,758.00 | $ 22,758.00 | C5117 | Apr-Jun 2022 PMTF Reimb |
9/12/2022 | 5098 | Casey's General Store | General Fund 5410.1 | $ 7.68 | $ 7.68 | CC5098 | Small bag of ice/24pk Casey's water |
9/12/2022 | 5130 | Chicago Tribune Media | General Fund 5410.1 | $ 27.72 | $ 27.72 | CC5130 | Newspaper Subscription-Sept |
9/12/2022 | 5082 | Indiana Licensing Enterprise | General Fund 5410.9 | $ 75.00 | $ 75.00 | CC5082 | Notary Public Commission Renewal- Todd, L |
9/12/2022 | 5054 | Panera Bread | General Fund 5410.1 | $ 674.60 | $ 674.60 | CC5054 | Lunch Order EDD 7/25-7/26/2022 |
9/12/2022 | 5128 | Stamps | General Fund 5249.9 | $ 24.99 | $ 24.99 | CC5128 | Stamps |
9/13/2022 | 5106 | City of LaPorte | General Fund 5760.0 | $ 42,224.00 | $ 42,224.00 | C5106 | LaPorte Operating Assistance Apr-Jun 2022 |
9/13/2022 | 5100 | City of Valpo | General Fund 5760.0 | $ 52,339.00 | $ 52,339.00 | C5100 | Valpo OA CMAQ Apr-Jun 2022 IN-2019-029 |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
9/13/2022 | 5101 | City of Valpo | General Fund 5760.0 | $ 64,081.00 | $ 64,081.00 | C5101 | Valpo CCC Vline Apr-Jun 2022 IN -2019-030 |
9/13/2022 | 5102 | City of Valpo | General Fund 5760.0 | $ 54,632.00 | $ 54,632.00 | C5102 | Valpo CCC-DASH Apr-Jun 2022 IN-2017-027 |
9/13/2022 | 5110 | East Chicago Transit | General Fund 5760.0 | $ 51,331.00 | $ 51,331.00 | C5110 | ECT Preventative Maintenance Apr-Jun 2022 |
9/13/2022 | 5111 | East Chicago Transit | General Fund 5760.0 | $ 57,691.00 | $ 57,691.00 | C5111 | ECT Paratransit Apr-Jun 2022 |
9/13/2022 | 5112 | East Chicago Transit | General Fund 5760.0 | $ 37,808.00 | $ 37,808.00 | C5112 | ECT Operating Assistance Apr-Jun 2022 |
9/13/2022 | 5108 | Lake County Community Services, Inc. | General Fund 5760.0 | $ 101,024.00 | $ 101,024.00 | C5108 | LCCS Enhanced Mobility Operating Assistance Apr-Jun 2022 |
9/13/2022 | 5109 | Lake County Community Services, Inc. | General Fund 5760.0 | $ 15,495.00 | $ 15,495.00 | C5109 | LCCS Preventative Maintenance Apr-Jun 2022 |
9/13/2022 | 5113 | Opportunity Enterprises | General Fund 5760.0 | $ 19,540.00 | $ 19,540.00 | C5113 | OE Preventative Maintenance Apr-Jun 2022 |
9/13/2022 | 5103 | Porter County Aging and Community Services | General Fund 5760.0 | $ 5,806.00 | $ 5,806.00 | C5103 | PCACS Preventative Maintenance Apr-Jun 2022 |
9/13/2022 | 5104 | Porter County Aging and Community Services | General Fund 5760.0 | $ 2,576.00 | $ 2,576.00 | C5104 | PCACS Operating Assistance Apr-Jun 2022 |
9/13/2022 | 5105 | Porter County Aging and Community Services | General Fund 5760.0 | $ 32,044.00 | $ 32,044.00 | C5105 | PCACS Enhanced Mobility Operating Assistance Apr-Jun 2022 |
9/14/2022 | 5125 | Auto-Owners Insurance | General Fund 5122.9 | $ 140.00 | $ 140.00 | 3073 | Worker's Comp Audit |
9/14/2022 | 5127 | Blachy, Tabor, Bozik & Hartman, LLC | General Fund 5602.9 | $ 1,750.00 | $ 1,750.00 | 3074 | Legal-Sept |
9/14/2022 | 5121 | Bryco Services | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 3075 | Office Cleaning- Sept |
9/14/2022 | 5135 | City of Portage | General Fund 5221.9 | $ 19,725.67 | $ 19,725.67 | 3076 | Lease-SEPT |
9/14/2022 | 5157 | Drive Clean Indiana | General Fund 5610.5 | $ 91,898.00 | $ 91,898.00 | 3077 | CMAQ Air Quality Public Air Quarterly April 1, 2022 |
9/14/2022 | 5136 | Kansas City Life | General Fund 5143.9 | $ 812.17 | $ 812.17 | 3078 | S-T Disability Insurance-Sept/ L-T Disability Insurance-Sept |
9/14/2022 | 5093 | Liberty Mutual Ins. Co. | General Fund 5222.9 | $ 100.00 | $ 100.00 | 3079 | $15,000 Public Official Bond for Treasurer |
9/14/2022 | 5152 | Nat'l Assoc. of Regional Councils | General Fund 5410.1 | $ 510.00 | $ 510.00 | 3080 | 2022 Exe. Dir. Conf. Kansas City- Registration-Warner, T |
9/14/2022 | 5151 | NWI Forum | General Fund 5410.1 | $ 40.00 | $ 40.00 | 3081 | 2022 Ignite lunch Sept.27th-Warner, T |
9/14/2022 | 5131 | Paramount Dental | General Fund 2153.0 | $ 878.92 | $ 878.92 | 3082 | Dental Insurance-Sept |
9/14/2022 | 5094 | Pulse Technology | General Fund 5430.9 | $ 95.36 | $ 95.36 | 3083 | Office Supplies |
9/14/2022 | 5158 | RDG Planning & Design, Inc. | General Fund 5610.2 | $ 6,610.08 | $ 6,610.08 | 3085 | Northwestern Indiana 2050 Metropolitan Transportation Plan --Finding Meaning-Land Use |
9/14/2022 | 5156 | RDG Planning & Design, Inc. | General Fund 5610.2 | $ 5,903.94 | $ 5,903.94 | 3084 | Northwestern Indiana 2050 Metropolitan Transportation Plan --Creating Purpose- Transportation |
9/14/2022 | 5095 | Reid's Fire & Safety Equip. | General Fund 5223.9 | $ 259.85 | $ 259.85 | 3086 | Service- portable fire extinguishers/Inspection/Tamper Seals/Service vehicle |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 601.68 | $ 601.68 | 3092 | Site Assessment-Hazardous Substance |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 3,132.39 | $ 3,132.39 | 3091 | Site Assessment-Hazardous Substance |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 2,792.50 | $ 2,792.50 | 3087 | Programmatic Support & Outreach-Petroleum/- Site Assessment-Petroleum |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 2,592.59 | $ 2,592.59 | 3088 | Site Assessment-Petroleum |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 9,031.70 | $ 9,031.70 | 3089 | Programmatic Support & Outreach-Petroleum/- Site Assessment-Petroleum |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 5,107.45 | $ 5,107.45 | 3090 | Programmatic Support & Outreach-Petroleum/- Site Assessment-Petroleum/-Site Clean Up Planning-Petroleum |
9/14/2022 | 3982 | SME | General Fund 5610.5 | $ 1,561.25 | $ 1,561.25 | 3039 | Site Assessment-Petroleum/-Site Clean Up Planning- Petroleum |
9/14/2022 | B-6327 | United Way | General Fund 2147.0 | $ 33.85 | $ 33.85 | 3094 | Pay period ending 8/28/2022 |
9/15/2022 | B-6272 | IN Dept of Revenue | General Fund 2143.0 | $ 1,485.98 | $ 1,485.98 | C6272 | Pay period ending 8/14/2022, LwtIN, SwtIN- State Tax Withholdings Payable |
9/15/2022 | B-6272 | IN Dept of Revenue | General Fund 2144.0 | $ 356.41 | $ 356.41 | C6272 | Pay period ending 8/14/2022, LwtIN, SwtIN- Local Tax Withholdings Payable |
9/15/2022 | B-6278 | IN Dept of Revenue | General Fund 2143.0 | $ 60.88 | $ 60.88 | C6278 | Pay period ending 8/14/2022, LwtIN, SwtIN- State Tax Withholdings Payable |
9/15/2022 | B-6278 | IN Dept of Revenue | General Fund 2144.0 | $ 9.42 | $ 9.42 | C6278 | Pay period ending 8/14/2022, LwtIN, SwtIN,- Local Tax Withholdings Payable |
9/15/2022 | B-6254 | IN Dept of Revenue | General Fund 2143.0 | $ 490.82 | $ 490.82 | C6254 | Pay period ending 7/31/2022 ,LwtIN, SwtIN- State Tax Withholdings Payable |
9/15/2022 | B-6254 | IN Dept of Revenue | General Fund 2144.0 | $ 145.87 | $ 145.87 | C6254 | Pay period ending 7/31/2022 ,LwtIN, SwtIN- Local Tax Withholdings Payable |
9/15/2022 | B-6248 | IN Dept of Revenue | General Fund 2143.0 | $ 1,483.93 | $ 1,483.93 | C6248 | Pay period ending 7/31/2022, LwtIN, SwtIN- State Tax Withholdings Payable |
9/15/2022 | B-6248 | IN Dept of Revenue | General Fund 2144.0 | $ 354.79 | $ 354.79 | C6248 | Pay period ending 7/31/2022, LwtIN, SwtIN- Local Tax Withholdings Payable |
9/16/2022 | 5124 | Total Disposal | General Fund 5223.9 | $ 79.92 | $ 79.92 | C5124 | Garbage/Recycle-SEPT |
9/19/2022 | 5153 | Barloga II, M | General Fund 5410.2 | $ 381.36 | $ 381.36 | C5153 | Mileage-NIRPC to Minneapolis, MN-APBP Conference (RT) |
9/19/2022 | 5155 | Barloga II, M | General Fund 5410.2 | $ 776.20 | $ 776.20 | C5155 | Travel-MN-Hotel The Graduate 3nts/Per Diem first and last nights/ Breakfast/Lunch/Dinner 2days-Barloga, M |
9/19/2022 | 5154 | Barloga II, M | General Fund 5146.9 | $ 130.00 | $ 130.00 | C5154 | Association of Pedestrian & Bicycle Professionals (APBP) Membership-Professional Membership through 8/8/2023 |
9/19/2022 | 5141 | Bradsky III, Charles | General Fund 5410.2 | $ 56.84 | $ 56.84 | C5141 | LaPorte Parks Dept TROC meeting (RT)/NIRPC to Highland meeting w/various emergency agencies |
9/19/2022 | 5122 | Comcast | General Fund 5244.9 | $ 196.30 | $ 196.30 | C5122 | Business Internet and Add'l Services-SEPT |
9/19/2022 | 5132 | Ecointeractive, Inc | General Fund 5610.2 | $ 3,978.00 | $ 3,978.00 | C5132 | TIP SAAS Service for monthly service fee AUG for SEPT |
9/19/2022 | 5134 | Fidelity EyeMed | General Fund 2154.0 | $ 85.25 | $ 85.25 | C5134 | Vision Insurance-SEPT |
9/19/2022 | 5143 | Kane, D | General Fund 5140.3 | $ 17.64 | $ 17.64 | C5143 | Mileage-NIRPC to PNW Hammond (RT) |
9/19/2022 | 5142 | Kimball, P | General Fund 5410.2 | $ 26.06 | $ 26.06 | C5142 | Mileage-VALPO to Lake Co. Fair (RT) |
9/19/2022 | 5149 | Warner, T | General Fund 5410.9 | $ 195.30 | $ 195.30 | C5149 | Mileage- NIRPC to Carmel, IN/Carmel, IN to Burns Harbor |
9/19/2022 | 5140 | Warner, T | General Fund 5410.9 | $ 18.90 | $ 18.90 | C5140 | Mileage- Morgan TWP to Hammond- One Region TOD Bus Tour (RT) |
9/19/2022 | 5139 | Warner, T | General Fund 5410.9 | $ 158.13 | $ 158.13 | C5139 | Mileage- Burns Harbor to INDI- MOP Council (RT) |
9/19/2022 | 5129 | Warner, T | General Fund 5244.9 | $ 150.00 | $ 150.00 | C5129 | Communication Expense-SEPT |
9/19/2022 | 5150 | Warner, T | General Fund 5410.9 | $ 219.09 | $ 219.09 | C5150 | Travel-Carmel, IN/Hotel-Springhill Suited/Per Diem first day/ Per Diem last day Breakfast & Lunch |
9/19/2022 | 5144 | Warner, T | General Fund 5410.9 | $ 269.43 | $ 269.43 | C5144 | Travel-Hotel INDI MPO Council/Per Deim INDO 1st & last day/Parking |
9/20/2022 | B-6331 | Federal & Fica | General Fund 2140.0 | $ 4,774.83 | $ 4,774.83 | C6331 | Pay period ending 9/11/2022, FWT, empfica, empficamed, fica, ficamed-Federal Tax Withholdings Payable |
9/20/2022 | B-6331 | Federal & Fica | General Fund 2142.0 | $ 7,022.68 | $ 7,022.68 | C6331 | Pay period ending 9/11/2022, FWT, empfica, empficamed, fica, ficamed-FICA Tax Withholdings Payable |
9/20/2022 | B-6336 | HSA | General Fund 2150.0 | $ 1,100.53 | $ 1,100.53 | C6336 | Pay period ending 9/11/2022-HAS |
9/20/2022 | 5159 | MissionSquare Retirement | General Fund 5145.9 | $ 934.36 | $ 934.36 | C5159 | ER paid for Ty Warner 8/29/2022-9/11/2022 |
9/20/2022 | B-6334 | MissionSquare Retirement | General Fund 2146.0 | $ 830.00 | $ 830.00 | C6334 | Pay period ending 9/11/2022-ICMA |
9/20/2022 | Payroll | General Fund | $ 34,897.95 | $ 34,897.95 | Payroll | ||
9/21/2022 | 5160 | INPRS | General Fund 5141.9 | $ 0.03 | $ 0.03 | C5160 | 8/29 thru 9/11/22-p/r 9/20/22-ER rounding adj. |
9/21/2022 | B-6333 | INPRS | General Fund 2149.0 | $ 5,984.58 | $ 5,984.58 | C6333 | Pay period ending 9/11/2022, EmpPerf [NIRPC] |
9/29/2022 | 5165 | Accelerate Indiana Municipalities | General Fund 5410.1 | $ 345.00 | $ 345.00 | 3095 | 2022 AIM Ideas Summit: Corp Membership - Warner,T |
9/29/2022 | 5164 | Basic | General Fund 5410.9 | $ 480.00 | $ 480.00 | 3096 | Monthly Fee for COBRA Admin Annually |
9/29/2022 | 4540 | City of Valpo | General Fund 5960.0 | $ 95,721.00 | $ 95,721.00 | C4540 | TOD Parking Lot lighting project |
9/29/2022 | 5096 | Drive Clean Indiana | General Fund 5410.5 | $ 750.00 | $ 750.00 | 3097 | Drive Clean IN 2022 Golf Outing Hole Sponsorship/Local-Federal Share |
9/29/2022 | B-6335 | United Way | General Fund 2147.0 | $ 33.85 | $ 33.85 | 3099 | Pay period ending 9/11/2022-United Way |
9/30/2022 | 5172 | Kane, D | General Fund 5410.3 | $ 14.21 | $ 14.21 | C5172 | Mileage- Various |
9/30/2022 | 5171 | Kane, D | General Fund 5410.3 | $ 3.43 | $ 3.43 | C5171 | Mileage-NIRPC to Portage (RT) |
9/30/2022 | 5174 | Warner, T | General Fund 5410.1 | $ 314.97 | $ 314.97 | C5174 | Travel- Parking: LAI Chataqua Panel Discussion (Chicago) / Airbnb March 2023 Purdue Road School / Lunch meeting w/ Indiana Dunes Tourism |
9/30/2022 | 5173 | Warner, T | General Fund 5410.9 | $ 209.79 | $ 209.79 | C5173 | Mileage- Various |
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - | ||||||
General Fund | $ - |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 1,044,449.26 |
Dated this day of , 2022.
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
9/7/2022 | 5119 | AccuFund, Inc | CARES Fund 5910.0 | $ 1,361.04 | $ 1,361.04 | C5119 | AccuFund Account Suite 5 hosted users Employee Portal (50 Hosted Employees) |
9/7/2022 | 5070 | Vantage Point Consulting, Inc | CARES Fund 5610.3 | $ 2,812.50 | $ 2,812.50 | 3072 | July Emergency Mgmt. Plan Review & Revision |
9/7/2022 | 4996 | Vantage Point Consulting, Inc | CARES Fund 5610.3 | $ 2,812.50 | $ 2,812.50 | 3072 | June Emergency Mgmt. Plan Review & Revision |
9/20/2022 | 5161 | Routematch | CARES Fund 5960.0 | $ 1,534.00 | $ 1,534.00 | C5161 | Oct 2022 LCCS Routematch/ Oct 2022 NT Routematch |
9/29/2022 | 5166 | Accelerate Indiana Municipalities | CARES Fund 5410.3 | $ 345.00 | $ 345.00 | 3095 | 2022 AIM Ideas Summit Corp Membership-Kane, D |
9/29/2022 | 5038 | TIP Strategies, Inc | CARES Fund 5610.3 | $ 16,850.37 | $ 16,850.37 | 3098 | Pymt 8 of 8 Economic resiliency Plan- Final/Airfare/Ground transportation/Meals/Lodging |
CARES Fund | $ - |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $ 25,715.41 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 25,715.41 |
Dated this day of , 2020.
PROPOSED 2022 BUDGET AMENDMENT #1
To transfer within revolving loan fund and contractual amount of $25,000
FROM: | CARES Revolving Loan Fund |
TO: | EDD Contractual Services |
Purpose: CATEGORY | Transferring funds from CARES RLF line item to EDD contractual services to cover the reminder of a contract. DETAILED BUDGET LINE Original Addition Amended |
CARES RLF services | Expense: | Revolving Loan Fund | 461,648 |
(25,000) 436,648
Contractual | Expense: | EDD Contractual Services | 101,000 25,000 126,000 |
ADDENDUM TO THE BASIC AGREEMENT BETWEEN THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION AND ECO-INTERACTIVE, INC. FOR ELECTRONIC TRANSPORTATION IMPROVEMENT PROGRAM (eTIP) SYSTEM PROCURED UNDER RFP 17-15-01. UNDER CFDA: 20.205
The parties to an agreement by and between Eco-Interactive Inc. (Contractor) and the Northwestern Indiana Regional Planning Commission (Commission) hereby agree to a contract extension as follows:
Compensation:
Effective October 1, 2022, the Contractor shall provide customized Project Tracker Software as a Service as noted in Part II of the original agreement, for a cost not to exceed $50,600.00 for year 6 billed at a rate of $4,216.66 per month.
Option Extension Year 7 billed at $53,130.00 per year.
Payment for services provided by the Contractor will be on a reimbursement basis and in accordance with procedures provided for in the Terms of Agreement Section of this Agreement.
Terms of the Agreement:
The Contractor shall continue providing ongoing Project Tracker SaaS for the Commission. Ongoing services included in the monthly subscription rate are: Software maintenance, SaaS hosting, help desk support, and up to 120 support hours annually for enhancement commencing the first day of October 2022 through and including the 30th day of September, 2023. NIRPC will notify Contractor within 3 months of the end of agreement of intent to continue with option year extension.
Agreement:
It is hereby agreed and understood by the party’s signatory hereto that these changes made to the Agreement become executed when the appropriate signatures are affixed hereto, and the date of contract award is established as of the 1st day of October 2022.
NORTHWESTERN INDIANA REGIONAL ECO-INTERACTIVE INC. PLANNING COMMISSION
By: By:
Tyson Warner Jessie Yu
Executive Director CEO
Date Date
Attest:
Talaya Jones Contracting Officer
Draft
ATTACHMENT A |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2023 GENERAL FUND APPROPRIATIONS BUDGET
PERSONNEL - SALARIES | 1,601,890 |
PERSONNEL - FRINGE BENEFITS | 639,827 |
OCCUPANCY | 292,398 |
EQUIPMENT SERVICE/MAINTENANCE | 82,636 |
DEPARTMENTAL | 153,386 |
CONTRACTUAL | 1,183,589 |
CAPITAL OUTLAYS - Equipment & Furniture 180,000
TOTAL FUND BUDGET | 4,133,726 |
ft
ATTACHMENT B
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2023 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET
Dra
CAPITAL OUTLAYS - TRANSIT EQUIPMENT 3,986,016
CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT 62,354
TOTAL FUND BUDGET | 4,048,370 |
ATTACHMENT C
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2023 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET
OTHER SERVICES AND CHARGES 7,221,696
TOTAL FUND BUDGET | 7,221,696 |
ATTACHMENT D
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
2023 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET
OTHER SERVICES AND CHARGES 220,000
TOTAL FUND BUDGET | 220,000 |
TOTAL BUDGET OF | 15,625,792 |
NIRPC FY 2023 Budget | ||
FY 2022 Budget | FY 2023 Budget Change % | |
REVENUES | ||
COUNTY APPROPRIATIONS | 540,271 | 540,271 |
FEDERAL AGENCIES | 1,769,676 | 506,000 |
STATE AGENCIES | 2,300,581 | 3,007,841 |
LOCAL AGENCIES | 72,760 | 44,800 |
NON-GOVERNMENTAL | 14,828 | 17,000 |
INTEREST INCOME | 37,885 | 17,814 |
TOTAL REVENUES | 4,736,001 | 4,133,726 -15% |
Draft
EXPENDITURES |
SALARY |
FRINGE BENEFITS |
FICA CONTRIBUTIONS |
WORKERS COMPENSATION |
UNEMPLOYMENT COMPENSATION |
PERF CONTRIBUTIONS |
HEALTH INSURANCE |
LIFE & DISABILITY INSURANCE |
ICMA CONTRIBUTIONS |
STAFF DEVELOPMENT |
1,590,648 | 1,601,890 |
CONTRACTUAL |
LEGAL SERVICES |
AUDIT & ACCOUNTING |
LA PORTE RLF SERVICES |
TRANSIT OVERSIGHT |
ENVIRONMENTAL CONTRACTS |
PLANNING |
BOARD DEVELOPMENT |
ECONOMIC DEVEL DISTRICT RLF-CARES ACT |
ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT |
ORGANIZATIONAL DEVELOPMENT |
E-TIP |
23,400 | 25,000 | |
38,000 | 21,000 | |
2,000 | 2,000 | |
17,347 | 22,000 | |
545,325 | 401,932 | |
320,000 | 50,000 | |
2,000 | 2,000 | |
461,648 | 461,648 | |
101,000 | 101,000 | |
2,000 | 2,000 | |
53,045 | 95,009 | |
1,565,765 | 1,183,589 | -32% |
180,000 | 180,000 | 0% |
4,736,000 | 4,133,726 | -15% |
0 | 0 |
FURNITURE & EQUIPMENT |
TOTAL EXPENSES |
FUND BALANCE - ENDING |
1%
121,685 | 122,545 | |
5,000 | 5,000 | |
3,000 | 3,000 | |
199,688 | 200,802 | |
240,000 | 240,000 | |
24,000 | 24,000 | |
24,480 | 24,480 | |
20,000 | 20,000 | |
637,853 | 639,827 | 0% |
OCCUPANCY |
OFFICE LEASE |
PROPERTY INSURANCE |
BUILDING MAINTENANCE |
UTILITIES |
236,708 | 236,708 | |
6,500 | 6,500 | |
18,540 | 18,540 | |
30,650 | 30,650 | |
292,398 | 292,398 | 0% |
EQUIPMENT SERVICE/MAINTENANCE |
COPIER LEASING/MAINTENANCE |
COMPUTER SERVICE |
TELEPHONE & INTERNET SERVICE / MAIN. |
OTHER EQUIPMENT MAINTENANCE |
18,000 | 18,000 | |
43,736 | 43,736 | |
18,900 | 18,900 | |
2,000 | 2,000 | |
82,636 | 82,636 | 0% |
DEPARTMENTAL |
COMMISSION/EXECUTIVE DIRECTOR |
PLANNING |
SUBGRANTEE MANAGEMENT |
ENVIRONMENTAL PROGRAMS |
PARTNER AGENCIES |
ALLOCATED FUNCTIONS |
ENVIRONMENTAL PROMOTIONS |
ECONOMIC DEVELOPMENT DISTRICT |
GENERAL USE SUPPLIES |
35,000 | 35,000 | |
239,000 | 38,000 | |
25,000 | 25,000 | |
23,418 | 7,500 | |
1,000 | 1,000 | |
25,000 | 25,000 | |
3,700 | 14,953 | |
29,583 | 3,183 | |
5,000 | 3,750 | |
386,701 | 153,386 | -152% |
NIRPC FY 2023 Revenue Detail
347,204 |
115,040 |
78,027 |
540,271 |
250,000 |
210,000 |
46,000 |
506,000 |
183,341 |
480,000 |
1,861,500 |
61,000 |
62,000 |
360,000 |
3,007,841 |
1,800 |
13,000 |
30,000 |
44,800 |
Draft
COUNTY APPROPRIATIONS |
LAKE COUNTY |
PORTER COUNTY |
LA PORTE COUNTY |
TOTAL |
FEDERAL AGENCIES |
FTA OVERSIGHT |
FTA CAPITAL |
USDA FOREST SVC |
TOTAL |
STATE AGENCIES |
INDOT PL 2021 |
INDOT PL 2022 |
INDOT PL 2023 |
STBG |
CMAQ 2022 |
CMAQ 2023 |
TOTAL |
LOCAL AGENCIES |
CITY of PORTAGE |
PARTNERS for CLEAN AIR |
ONE REGION ONE TRAIL |
TOTAL |
NON-GOVERNMENTAL |
CALUMET LAND CONSERVATION PARTN. |
SHARED ETHICS ADVISORY COMMISSION |
TOTAL |
INTEREST INCOME |
BANK INTEREST INCOME |
RLF INTEREST INCOME |
TOTAL FY 2022 REVENUE |
15,000
2,000
17,000
3,000
14,814
4,133,726
NIRPC FY 2023 Budget
Grant Federal Req. Match Total
Support Vehicle |
Computers/Sound System |
Support Equipment |
Support Vehicle |
Rehab/Renovate - Admin Facility |
Replace 3 Revenue Vehicles |
Replace 2 Revenue Vehicles |
Replace 1 Communter Vehicle |
Replace Staff Computers |
Replace 4 Communter Vehicle |
Associated Transit Improv |
Tablets and Vehicle Devices |
Office Computer Equipment |
Office Computer Equipment |
Replace ChicaGO Dash |
Replace 1 Vehicle |
Computers |
Replace Bus Stop Signs |
Transit Improvements |
Buy Replacement |
Buy Replacement |
Buy Replacement |
2016-033 | 28,000 |
2016-033 | 25,082 |
2016-033 | 2,800 |
2017-028 | 44,000 |
2017-028 | 19,200 |
2018-026 | 276,000 |
2018-026 | 176,000 |
2018-026 | 637,500 |
2019-029 | 80,000 |
2019-029 | 59,857 |
2019-029 | 220,000 |
2019-029 | 3,600 |
2019-029 | 2,800 |
2019-029 | 5,200 |
2019-029 | 495,966 |
2019-030 | 48,000 |
2019-030 | 2,700 |
2019-030 | 120,000 |
2019-030 | 100,000 |
2020-054 | 65,600 |
2020-054 | 112,000 |
2020-054 | 104,000 |
7,000 |
6,271 |
700 |
11,000 |
4,800 |
69,000 |
44,000 |
155,000 |
20,000 |
19,952 |
55,000 |
900 |
700 |
1,300 |
123,999 |
12,000 |
699 |
30,000 |
25,000 |
16,400 |
28,000 |
26,000 |
35,000 |
31,353 |
3,500 |
55,000 |
24,000 |
345,000 |
220,000 |
792,500 |
100,000 |
79,809 |
275,000 |
4,500 |
3,500 |
6,500 |
619,965 |
60,000 |
3,399 |
150,000 |
125,000 |
82,000 |
140,000 |
130,000 |
Draft
TOTAL 2,755,125 681,301 3,436,426
Contingency -
TOTAL BUDGET 3,436,426
** | new projects for 2022 not included |
CY 2023 TRANSIT CAPITAL PROJECTS FUND | ||||||
Subrecipent | Grant | Project | Letting Date | Total | Non-Federal Funds | Federal Funds |
ECT | 2022-020 | BUY REPLACEMENT 35-FT BUS | $ 549,590 | $ 91,598 | $ 457,992 | |
Draft
TOTAL BUDGET
$ 549,590
$ 457,992
CY 2021 CARES ACT 2020 TRANSIT CAPITAL PROJECTS FUND | ||||
Subrecipent | Grant | Project | Total | Federal Funds |
ECT | CARES Act 2020-014 | Support Vehicle (2) | $ 50,561 | $ 50,561 |
NT | CARES Act 2020-014 | Misc Support Equipment | $ 9,896 | $ 9,896 |
Valpo | CARES Act 2020-014 | Misc Support Equipment | $ 1,897 | $ 1,897 |
Draft
TOTAL BUDGET
$ 62,354
$ 62,354
CY 2022 TRANSIT OPERATING PROJECTS FUND
Draft
Federal Req. Match Total
City of East Chicago 2023 | |
Preventative Maintenance | 375,511 |
Complementary Paratransit | 285,164 |
Operating Assistance | 384,060 |
Existing Grants | 607,267 |
93,878 |
71,291 |
384,060 |
374,493 |
469,389 |
356,455 |
768,120 |
981,760 |
City of LaPorte 2023 | |
Operating Assistance | 259,890 |
Existing Grants | 103,120 |
259,890 |
103,120 |
519,780 |
206,240 |
City of Valparaiso 2023 | |
Capital Cost of Contracting | 1,025,081 |
Dash Expansion | 269,600 |
Shuttle Connect Expansion | 332,000 |
Existing Grants | 991,210 |
256,271 |
67,400 |
83,000 |
247,803 |
1,281,352 |
337,000 |
415,000 |
1,239,013 |
North Township 2023 | |
Preventative Maintenance | 43,200 |
Operating Assistance | 259,175 |
Existing Grants | 183,232 |
10,800 |
259,175 |
162,179 |
54,000 |
518,350 |
345,411 |
Opportunity Enterprises 2023 | |
Preventative Maintenance | 204,800 |
Existing Grants | 68,689 |
51,200 |
17,172 |
256,000 |
85,861 |
Porter County Community Services 2023 | |
Operating Assistance (Enhanced Mobility) | 133,761 |
Existing Grants | 268,528 |
133,761 |
174,849 |
267,522 |
443,376 |
Southlake Community Services 2023 | |
Preventative Maintenance | 101,102 |
Operating Assistance | 400,000 |
Ehnaced Mobility | 125,000 |
Existing Grants | 259,623 |
25,276 |
400,000 |
125,000 |
216,543 |
126,378 |
800,000 |
250,000 |
476,166 |
PMTF Funds (NT,SLCS,PCCS, OE & CV) | |
Public Mass Transportation Fund | 541,683 |
- |
541,683 |
TOTAL | 7,221,696 3,517,160 10,738,856 |
Draft
CY 2023 LAPORTE COUNTY REVOLVING LOAN FUND
2022 2023 |
Budget Budget |
New Loans | 150,000 | 220,000 | ||
TOTAL | 150,000 | 220,000 | ||
TOTAL BUDGET | 220,000 |
LaPorte RLF 2023 Administration Budget |
Per RLF Management Plan 50% of interest can be used for Administrative Cost |
REVENUES |
RLF INTEREST INCOME 7,800 |
CLOSING CHARGES 2,000 |
TOTAL REVENUES 9,800 |
EXPENDITURES |
SALARY |
FRINGE BENEFITS ALLOC |
INDIRECT COST ALLOC |
2,500 |
2,025 |
2,400 |
6,925 |
DEPARTMENTAL |
COMMUNICATION |
GENERAL USE SUPPLIES |
365 |
510 |
875 |
CONTRACTUAL |
LA PORTE RLF SERVICES |
2,000 |
2,000 |
Draft
TOTAL EXPENSES 9,800
FUND BALANCE - ENDING -
CARES ACT RLF 2023 Administration Budget | |
Per RLF Management Plan 50% of interest can be used for Administrative Cost | |
REVENUES | |
RLF INTEREST INCOME | 5,014 |
CLOSING CHARGES | 3,000 |
TOTAL REVENUES | 8,014 |
EXPENDITURES |
SALARY |
FRINGE BENEFITS ALLOC |
INDIRECT COST ALLOC |
1,900 |
1,368 |
1,748 |
5,016 |
DEPARTMENTAL |
COMMUNICATION |
GENERAL USE SUPPLIES- AF Loan |
368 |
630 |
998 |
CONTRACTUAL |
LA PORTE RLF SERVICES |
2,000 |
2,000 |
Draft
TOTAL EXPENSES 8,014
FUND BALANCE - ENDING -