6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
FINANCE AND PERSONNEL COMMITTEE
Meeting Agenda - Thursday, March 18, 2021 -- 8:00 a.m.
Phone Number: (US) +1 414-909-4453 PIN: 407502875#
Call to Order
Meeting Minutes of January 21, 2021 Pages 1-3
Review of 2020 Year End Financial Status Budget to Actual Pages 4-8
General Fund Expenses YTD December 2020
General Fund Revenue YTD December 2020
CARES Expenses YTD December 2020
CARES Revenue YTD December 2020
Review of Financial Status – January 2021 Budget vs Actual Pages 9-17
Bank Statement Reconciliations
General Fund Expenses YTD January 2021
General Fund Revenue YTD January 2021
CARES Expenses YTD January 2021
CARES Revenue YTD January 2021
Approval of General Fund Claims Register – January 2021 Pages 18-20
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – January 2021 Pages 21
ACTION REQUESTED: Approval
Review of Financial Status – February 2021 Budget vs Actual Pages 22-30
Bank Statement Reconciliations
General Fund Expenses YTD February 2021
General Fund Revenue YTD February 2021
CARES Expenses YTD February 2021
CARES Revenue YTD February 2021
Approval of General Fund Claims Register – February 2021 Pages 31-33
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register – February 2021 Pages 34
ACTION REQUESTED: Approval
Resolution 21-03 – Updating the Management Plan for the LaPorte Co. RLF Pages 35-40
ACTION REQUESTED: Recommendation
Resolution 21-04 – Regional RLF Management Plan Amendment Pages 41-44
ACTION REQUESTED: Recommendation
The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program. Users may access the Relay Indiana
Personnel update
Other Business
Adjournment
The next meeting is scheduled for April 15, 2021 at 8:00 a.m.
The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE
January 21, 2021 / Zoom Virtual Meeting – 8:00 a.m.
Members Present
Richard Hardaway, Bob Carnahan, Justin Kiel, George Topoll Staff and Others Present
Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Stephanie Kuziela, Meredith Stilwell, Gabrielle Biciunas, Denarie Kane, Greg Stinson, Wendy Mis, John Yelkich, David Hollenbeck
Call to Order
Richard Hardaway called the meeting to order with the Pledge of Allegiance.
Approval of Minutes
The minutes of the November 19, 2020 meeting were presented. Bob Carnahan made motion and Richard Hardaway seconded to approve the minutes. A roll call vote was taken with Bob Carnahan, Richard Hardaway and Justin Kiel voting in the affirmative, and no one voting in the negative. Motion passed 3-0.
Review of Financial Status – November 2020
Talaya Jones presented the November 2020 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account. The general account beginning balance from 11/1/2020 was
$1,068,601.49 with a closing balance of $1,195,830.97 as of 11/30/2020. The RLF account beginning balance from 11/1/2020 was $149,906.07 with a closing balance of $155,093.25 as of 11/30/2020.
Talaya presented the financial status report for category expenditures year to date, November 2020.
$1,105,540 has been expended of the $1,293,260 Salaries budget. $427,008 has been expended of the
$509,690 Fringe Benefits budget. $248,527 has been expended of the $280,297 Occupancy budget.
$55,654 has been expended of the $78,840 Maintenance budget. $80,839 has been expended of the
$196,750 Departmental budget. $359,668 has been expended of the $884,465 Contractual budget.
$6,736 has been expended of the $100,000 Capital Outlays budget. Total General Fund expenditures totaled $2,283,972 of the $3,343,302 budgeted. $400 has been expended of the $85,000 LaPorte Revolving Loan Fund budget. $2,614,854 has been expended of the $2,440,988 Transit Capital Fund budget. $1,688,483 has been expended of the $4,389.036 2019 Transit Operating Fund budget. Year to date, total expenditures of $6,587,709 of the $10,258,326 budgeted, $3,670,617 under budget.
Talaya presented the year-to-date November 2020 expended by category chart. 48% of the expended budget was salaries, 19% fringe benefits, 16% contractual, 11% occupancy, 4% departmental and 2% maintenance.
Talaya presented the year-to-date November 2020 budget vs. actual revenue report. $366,669 of the
$540,271 county appropriations budget has been collected. $189,348 of the $539,733 federal agencies budget has been collected. $1,414,667 of the $1,935,395 state agencies budget has been collected.
$24,286 of the $44,694 local agencies budget has been collected. $11,288 of the $135,318 non- governmental funds budget has been collected. $13,288 of the $70,000 Economic Development District budget has been collected. $9,299 of the $9,682 interest income budget has been collected.
Talaya presented the year-to-date revenue by funding source chart as of November 30. 70% of collected revenue has been from state agencies, 18% from county appropriations, 9% from federal agencies, 1% from local agencies, 1% from Economic Development District, and 1% from interest income.
Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual expenditures year to date, November 2020. $60,756 of the $236,733 has been expended of the Salaries budget. $0 of $5,000 contractual, RLF Services budget has been expended. $15,572 of the $25,000 departmental, PPE Supplies, budget has been expended. $2,544 of the $165,000 Capital Outlays, Furniture and Equipment, budget has been expended. Total NIRPC CARES Fund Expenditures of $78,870 had been
expended from the $431,733 budget. $0 of the $583,000 CARES Revolving Loan Fund budget has been expended. $137,057 of the $1,219,972 CARES Transit Capital Fund budget has been expended.
$2,171,324 of the $4,314,322 CARES Agency Fund has been expended. Total expenditures were
$2,387,253 of the $6,549,027 budgeted.
Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual revenue year to date, November 2020. All revenue is federal and is classified as Economic Development District or FTA. $268,895 has been collected of the $604,229 total CARES Act revenue budget.
Approval of Claims Register – November 2020
Talaya first presented the November 2020 regular claims register totaling $237,913.16 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 regular claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. The CARES Act expenditures register of claims totaling $1,181,387.07 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.
December 2020 Bank Statement Reconciliation
Talaya Jones presented the December 2020 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account. The general account beginning balance from 12/1/2020 was
$1,195,830.97 with a closing balance of $1,572,482.28 as of 12/31/2020. The RLF account beginning balance from 12/1/2020 was $155,093.25 with a closing balance of $160,280.91 as of 12/31/2020.
Approval of Claims Register – December 2020
Talaya first presented the December 2020 regular claims register totaling $245,009.72 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the November 2020 regular claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. The CARES Act expenditures register of claims totaling $15,832.77 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the December 2020 CARES Act claims register. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0. Talaya stated the preliminary financial reports for December will be brought to the next meeting.
Procurement Recommendation 21-01
Lisa Todd presented procurement recommendation 21-01 for the purchase of 2 replacement BOC vehicles for LaPorte TransPorte. 80% of the purchase will be paid with Federal Transit Administration Funds with 20% paid with LaPorte TransPorte local share, not to exceed $118,400 in federal funds. Justin Kiel made motion and Bob Carnahan seconded to approve Procurement Recommendation 21-01. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.
CARES RLF Loan Committee Member Appointments
NIRPC’s Economic Development District Coordinator, Gabrielle Biciunas, presented a memorandum to the committee to request approval of the appointment of CARES Regional Revolving Loan Fund Loan Committee Members. The Finance and Personnel Committee is responsible for appoint Loan Committee Members, who are required to represent a balanced mix of Economic Development, Chamber of Commerce, banks/commercial lenders, non-commercial lenders, business, lawyers, and others, for Lake, Porte, and LaPorte Counties. Gabrielle presented six items in the memorandum and the proposed Committee Members for approval by the Committee. Justin Kiel made motion and Richard Hardaway seconded to approve Procurement Recommendation 21-01. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no negative votes. Motion passed 4-0.
Kankakee River Basin and Yellow River Basin Development Commission (KRBYRBDC) Support Agreement For informational purposes, Kathy Luther presented the new support agreement between NIRPC and the KRBYRBDC for general services from January 1 through December 31. 2021. The new agreements provides for a lesser monthly cost but allows for more hours to be spent for services.
Personnel updates
Meredith Stilwell reported that most staff are continuing to work remotely.
Other Business
Bob Carnahan pointed out that the agenda indicated the next meeting would be held March 18, 2020 and should be March 18, 2021.
Adjournment
There being no further business, the meeting was adjourned.
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH DECEMBER 31, 2020 |
Line Items | FY 2020 Budget | FY 20 YTD December YTD Variance YTD % Budget % Expended (Over)/Under Variance balance |
Salaries | ||||||
5020-1 | Total Salaries | 1,293,260 | 1,154,561 | 138,699
| 11% | 11% |
Salaries Sub-Total | 1,293,260 | 1,154,561 | 138,699
| 11% | 11% | |
Fringe Benefits | ||||||
5121-9 | FICA Contributions | 104,321 | 94,008 | 10,313 | 10% | 10% |
5122-9 | Workers Compensation | 6,100 | 2,950 | 3,150 | 52% | 52% |
5123-9 | Unemployment Compensation | 1,650 | 1,092 | 558 | 34% | 34% |
5141-9 | PERF Contributions | 159,118 | 159,177 | (59) | 0% | 0% |
5142-9 | Health Insurance | 170,501 | 160,889 | 9,612 | 6% | 6% |
5143-9 | Life & Disability Insurance | 23,000 | 17,736 | 5,264 | 23% | 23% |
5145-9 | ICMA | 25,000 | 21,606 | 3,394 | 14% | 14% |
5146-9 | Staff Development | 20,000 | 5,366 | 14,634
| 73% | 73% |
Fringe Benefits Sub-Total | 509,690 | 462,823 | 46,867
| 9% | 9% | |
Occupancy | ||||||
5221-9 | Office Lease | 225,500 | 244,547 | (19,047) | -8% | -8% |
5222-9 | Property Insurance | 6,500 | 4,901 | 1,599 | 25% | 25% |
5223-9 | Building Maintenance | 18,540 | 18,221 | 319 | 2% | 2% |
5224-9 | Utilities | 29,757 | 22,252 | 7,505
| 25% | 25% |
Occupancy Sub-Total | 280,297 | 289,920 | (9,623)
| -3% | -3% | |
Maintenance | ||||||
5241-9 | Copier Leasing/Maintenance | 19,400 | 4,423 | 14,977 | 77% | 0% |
5243-9 | Computer Service/Maintenance | 40,440 | 44,776 | (4,336) | -11% | 0% |
5244-9 | Telephone Service/Maintenance | 18,000 | 11,478 | 6,522
| 36% | 0% |
Combined Copier/IT/Phone Service/Maintenance | 77,840 | 60,678 | 17,162
| 22% | 22% | |
5249-9 | Other Equipment Maintenance | 1,000 | 389 | 611
| 61% | 61% |
Maintenance Sub-Total | 78,840 | 61,067 | 17,773
| 23% | 23% | |
Departmental | ||||||
5410-1 | Communications: Commission/Ex. Dir. | 41,500 | 12,407 | 29,093 | 70% | 70% |
5410-2 | Communications: Transportation | 60,000 | 17,039 | 42,961 | 72% | 72% |
5410-4 | Communications: Subgrantee Management | 15,000 | 96 | 14,904 | 99% | 99% |
5410-5 | Communications: Environmental Programs | 28,650 | 16,636 | 12,014 | 42% | 42% |
5410-8 | Communications: Partner Agency | 1,000 | 716 | 284 | 28% | 28% |
5410-9 | Communications: Allocated Functions | 28,000 | 18,891 | 9,109 | 33% | 33% |
5420-5 | Promotional Expenses: Environmental Programs | 15,600 | 17,405 | (1,805) | -12% | -12% |
5430-9 | General Use Supplies Expense | 7,000 | 1,563 | 5,437
| 78% | 78% |
Departmental Sub-Total | 196,750 | 84,753 | 111,997
| 57% | 57% | |
Contractual | ||||||
5602-9 | Legal Services | 19,800 | 19,800 | 0 | 0% | 0% |
5603-9 | Audit and Accounting | 69,000 | 15,680 | 53,320 | 77% | 77% |
5604-9 | LaPorte RLF Services | 2,000 | 0 | 2,000 | 100% | 100% |
5610-4 | Transit Oversight | 11,300 | 11,900 | (600) | -5% | -5% |
5610-5 | Environmental Projects | 522,374 | 267,637 | 254,737 | 49% | 49% |
5610-5 | Alternative Fuel | 70,991 | 0 | 70,991 | 100% | 100% |
5619-9 | Organizational Dev. | 2,000 | 0 | 2,000 | 100% | 100% |
5610-0 | Board Development | 2,000 | 0 | 2,000 | 100% | 100% |
5610-2 | E-Tip | 45,000 | 48,750 | (3,750) | -8% | -8% |
Economic Development District | 140,000 | 0 | 140,000
| 100% | 100% | |
Contractual Sub-Total | 884,465 | 363,767 | 520,698
| 59% | 59% | |
Capital Outlays | ||||||
5910-0 | Furniture and Equipment | 100,000 | 6,736 | 93,264
| 93% | 93% |
Capital Outlays Sub-Total | 100,000 | 6,736 | 93,264
| 93% | 93% | |
TOTAL GENERAL FUND EXPENDITURES | 3,343,302 | 2,423,628 919,674 | 28% 28% |
LaPorte Revolving Loan Fund | 85,000 | 400 |
Transit Capital Fund | 2,440,988 | 2,573,834 |
2019 Transit Operating Fund TOTAL EXPENDITURES | 4,389,036 1,688,483 10,258,326 6,686,345 |
84,600
100%
(132,846)
-5%
2,700,553
62%
3,571,981
35%
1,200,000 | 1,293,260 | 1,154,561 | |
1,000,000 | |||
800,000 | |||
600,000 | 509,690 | ||
400,000 | |||
200,000 | |||
- | |||
CARES FUND EXPENDITURES
884,465
462,823
363,767
280,297 289,920
196,750
78,840
61,067
84,753
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD December Budget YTD December Expended
15%
3%
3%
48%
12%
19%
Salaries
Fringe Benefits Occupancy Maintenance Departmental
Contractuals
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH DECEMBER 31, 2020 |
Line Items | FY 2020 Budget | FY 20 YTD December YTD Variance YTD % Budget % Collected (Under)/Over Variance balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 540,271 | 540,271 | 0% | 0% |
1.1.4210 | Federal Agencies | 539,733 | 222,660 | (317,073) | -59% | 59% |
1.1.4310 | State Agencies | 1,935,395 | 1,240,861 | (694,534) | -36% | 36% |
1.1.4410 | Local Agencies | 44,694 | 36,343 | (8,351) | -19% | 19% |
1.1.4610 | Non-Governmental | 135,318 | 11,126 | (124,192) | -92% | 92% |
1.3.4260 | Economic Development District | 70,000 | 34,969 | (35,031) | -50% | 50% |
1.1.4800 | Interest Income | 9,862 | 9,773 | (89) | -1% | 1% |
Revenue Total | 3,275,273 | 2,096,002 | (639,000) | -23% | 36% |
0%
0%
2% 2%
26%
11%
59%
County Appropriations Federal Agencies State Agencies
Local Agencies
Non-Governmental
Economic Development District
Interest Income
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH DECEMBER 31, 2020 |
Line Items | FY 2020 Budget | YTD December Expended | FY 20 Budget % balance |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries-FTA | 236,733 | 124,919 | 47% |
Salaries-CARES EDD | - | ||
Salaries Sub-Total | 236,733 | 124,919 | 47% |
Contractual | |||
Contractural | 17,385 | ||
RLF Services | 5,000 | - | 100% |
Contractual Sub-Total | 5,000 | 17,385 | -248% |
Departmental |
Communications | 500 | 1,681 | -236% | |
PPE Supplies & Office Supplies | 25,000 | 14,973 | 40% | |
Capital Ou | Departmental Sub-Total | 25,000 | 16,654 | 33% |
Furniture and Equipment | 165,000 | 3,294 | 98% |
Capital Outlays Sub-Total | 165,000 | 3,294 | 98% |
TOTAL NIRPC CARES FUND EXPENDITURES | 431,733 | 162,251 | 62% |
CARES Revolving Loan Fund | 583,000 | - |
CARES Transit Capital Fund | 1,219,972 | 201,152 |
CARES Transit Agency Fund | 4,314,322 | 2,171,324 |
TOTAL EXPENDITURES | 6,549,027 | 2,534,727 |
250,000
YTD December 2020 Expenses Budget vs Actual
236,733
200,000
165,000
150,000
124,919
100,000
50,000
17,385
25,000 16,654
-
-
5,000
3,294
-
SALARIES-FTA
SALARIES-CARES
EDD
CONTRACTURAL
DEPARTMENTAL CAPITAL OUTLAYS
Budget Expended
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH DECEMBER 31, 2020 |
Line Items | FY 2020 Budget | YTD December Collected | FY 20 Budget % balance | |
CARES ACT FTA Revenue | ||||
Operating Revenue | 419,386 | 368,309 | 12% | |
Capital Revenue | 125,000 | 0 | 100% | |
CARES ACT EDA | Economic Development District | 59,843 | 11,455 | 81% |
RLF | 3,095 | |||
Revenue Total | 604,229 | 382,859 | 37% | |
CARES AGENCY | FTA Revenue | 2,694,048 | 2,171,324 | 81% |
CARES TRANSIT CAPITAL | FTA Revenue | 1,008,732 | 201,152 | 20% |
4,307,009 | 2,755,335 | 64% |
Revenue by Funding Source as of December 31, 2020
1%
3%
96%
CARES
Economic Development District RLF
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 2/05/2021 @ 5:55 AM
Reconciliation - General
Page: 1
STK 2/5/21
02/5/2021
Closing Balance from Previous Statement........................................................................................... 12/31/2020 1,572,482.28
6 | Deposits and Other Additions Totaling...................................................................... | 149,613.00 | |
93 | Checks and Other Withdrawls Totaling..................................................................... | 520,564.04 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 1/08/2021 | 94.12 | |
Interest Earned....................................................................................................... | 1/31/2021 | 118.61 | |
Closing Balance for this Statement..................................................................................................... | 1/31/2021 | 1,201,555.73 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 1/31/2021 | 1,125,657.26 | |
Open Activity from Bank Register............................................................................. | (75,898.47) | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement................................................................................................. | 1,201,555.73 | ||
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 |
12/15/2020 | 0002704 INRO Consultants | Renewal Software Agreement 7/1/20- | 1,680.00 |
1/06/2021 | 0002725 Tennant Sales and Service Company | 12/31/20 Tennant- Floor | 39,949.00 |
Sweeper/Battery/Charger/Vaccum | |||
Wand/Freight/Less discount | |||
1/28/2021 | 0002727 BRYCO SERVICES | Recycle/Trash | 1,425.00 |
1/28/2021 | 0002728 City of Portage, The | Sewer/Water/Gas/Electric Service | 1,869.17 |
1/28/2021 | 0002729 Engravables | Yearly officer's plaque engraved plate/Gavel and laser engraved plate | 53.00 |
1/28/2021 | 0002730 Nat'l Assoc. of Regional Councils | Invoices 4078, 4087 | 750.00 |
1/28/2021 | 0002731 Pulse Technology | Office Supplies-Covid 19/CARES-Lysol | 39.99 |
1/28/2021 | 0002732 Quill Corporation | Office Supplies | 183.53 |
1/28/2021 | 0002733 SME | Programmatic Support & Outreach- | 28,343.73 |
Hazardous/Petroleum | |||
Inventory & Prioritization-Petroleum | |||
Site Assessment-Hazardous | |||
1/28/2021 | 0002734 United Way of Porter County | 1/4 - 1/17/2021 pay period - United Way | 33.85 |
Total Unmarked Checks: 75,898.47 | Total Checks: | 75,898.47 | |
Trial Balance - Cash
Run: 3/11/2021 at 11:07NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 1/31/2021
Page: 1
All Balance
1.1.001.0000.1010.0 Cash 1,125,657.26
Total 1,125,657.26
STK 3/11/21
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 2/04/2021 @ 1:03 PM
Reconciliation - Revolving Loan Fund
Page: 1
STK 2/4/21
02/5/2021
6 | Deposits and Other Additions Totaling...................................................................... | 4,878.31 | |
0 | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | ||
Interest Earned....................................................................................................... | 1/29/2021 | 8.50 | |
Closing Balance for this Statement..................................................................................................... | 1/31/2021 | 165,167.72 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 1/31/2021 | 165,167.72 | |
Open Activity from Bank Register............................................................................. | 0.00 | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement................................................................................................. | 165,167.72 | ||
Date | Reference Deposit Description | Amount | |
1/06/2021 | 8272569 Bare Bones RLF Payment | 1,197.07 | |
1/12/2021 | 8272569 Hammer RLF Payment | 1,381.24 | |
1/12/2021 | 8272569 Heston Supper Club RLF Payment | 300.00 | |
1/25/2021 | 8272572 Heston Supper Club RLF Payment | 300.00 | |
1/28/2021 | 8272572 Wilsons RLF Payment | 1,200.00 | |
1/28/2021 | 8272572 Etropal Jan 2021 RLF Payment | 500.00 | |
Total Unmarked Deposits: 0.00 | Total Deposits: | 4,878.31 | |
Date | Reference Adjustment Description | Amount | |
| Interest Earned | 8.50 | |
Total Unmarked Adjustments: 0.00 | Total Adjustments: | 8.50 |
Trial Balance - Cash
Run: 2/04/2021 at 1:18 PNMORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 1/31/2021
Page: 1
All Balance
2.3.050.0000.1010.0 Cash 165,167.72
Total 165,167.72
STK 2/4/21
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JANUARY 31, 2021 |
Line Items | FY 2021 Budget | FY 21 YTD January Budget % Expended balance |
Salaries | |||
5020-1 | Total Salaries | 1,565,254 | 88,138 94% |
Salaries Sub-Total | 1,565,254 | 88,138 94% |
Fringe Benefits | ||||
5121-9 | FICA Contributions | 119,742 | 7,687 | 94% |
5122-9 | Workers Compensation | 9,500 | 0 | 100% |
5123-9 | Unemployment Compensation | 3,000 | 48 | 98% |
5141-9 | PERF Contributions | 200,012 | 13,176 | 93% |
5142-9 | Health Insurance | 230,000 | 28,990 | 87% |
5143-9 | Life & Disability Insurance | 24,000 | 1,268 | 95% |
5145-9 | ICMA | 23,000 | 1,712 | 93% |
5146-9 | Staff Development | 20,000 | 0 | 100% |
Fringe Benefits Sub-Total | 629,254 | 52,880 | 92% | |
Occupancy | ||||
5221-9 | Office Lease | 231,000 | 19,245 | 92% |
5222-9 | Property Insurance | 6,500 | 0 | 100% |
5223-9 | Building Maintenance | 18,540 | 1,499 | 92% |
5224-9 | Utilities | 30,650 | 3,614 | 88% |
Occupancy Sub-Total | 286,690 | 24,358 | 92% | |
Maintenance | ||||
5241-9 | Copier Leasing/Maintenance | 20,370 | 843 | 0% |
5243-9 | Computer Service/Maintenance | 43,736 | 3,538 | 0% |
5244-9 | Telephone Service/Maintenance | 18,900 | 1,006 | 0% |
Combined Copier/IT/Phone Service/Maintenance | 83,006 | 5,388 | 94% | |
5249-9 | Other Equipment Maintenance | 2,000 | 25 | 99% |
Maintenance Sub-Total | 85,006 | 5,413 | 94% | |
Departmental | ||||
5410-1 | Communications: Commission/Ex. Dir. | 41,500 | 1,755 | 96% |
5410-2 | Communications: Transportation | 299,000 | 4,200 | 99% |
5410-4 | Communications: Subgrantee Management | 25,000 | 0 | 100% |
5410-5 | Communications: Environmental Programs | 25,255 | 0 | 100% |
5410-8 | Communications: Partner Agency | 1,000 | 0 | 100% |
5410-9 | Communications: Allocated Functions | 28,000 | 125 | 100% |
5420-5 | Promotional Expenses: Environmental Programs | 3,700 | 0 | 100% |
5410-3 | Economic Development District | 11,768 | 0 | 100% |
5430-9 | General Use Supplies Expense | 7,000 | 184 | 97% |
Departmental Sub-Total | 442,223 | 6,264 | 99% | |
Contractual | ||||
5602-9 | Legal Services | 22,200 | 1,700 | 92% |
5603-9 | Audit and Accounting | 38,000 | 0 | 100% |
5604-9 | LaPorte RLF Services | 2,000 | 0 | 100% |
5610-4 | Transit Oversight | 17,347 | 0 | 100% |
5610-5 | Environmental Projects | 837,300 | 108,376 | 87% |
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 | 3,750 | 93% |
Contractual Sub-Total | 1,292,347 | 113,826 | 91% | |
Capital Outlays | |||
5910-0 | Furniture and Equipment | 180,000 | 0 100% |
Capital Outlays Sub-Total | 180,000 | 0 100% | |
TOTAL GENERAL FUND EXPENDITURES | 4,480,774 | 290,878 94% |
LaPorte Revolving Loan Fund | 85,000 | 0 |
Transit Capital Fund | 142,080 | 0 |
Transit Operating Fund | 4,460,765 | 0 |
TOTAL EXPENDITURES | 9,168,619 | 290,878 |
140,000
130,438
120,000
107,696
113,826
100,000
88,138
80,000
60,000
52,438 52,880
36,852
40,000
23,891 24,358
20,000
7,084
5,413
6,264
-
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD January Budget YTD January Expended
30%
39%
2%2%
18%
9%
Salaries
Fringe Benefits Occupancy Maintenance Departmental
Contractuals
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JANUARY 31, 2021 |
Line Items | FY 2020 Budget | FY 20 YTD January YTD Variance YTD % Budget % Collected (Under)/Over Variance balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 0 | 0 | 0% | 100% |
1.1.4210 | Federal Agencies | 869,119 | 0 | (724,266) | -100% | 100% |
1.1.4310 | State Agencies | 1,955,395 | 0 | (1,629,496) | -100% | 100% |
1.1.4410 | Local Agencies | 44,694 | 12,057 | (25,188) | -68% | 73% |
1.1.4610 | Non-Governmental | 85,318 | 450 | (70,648) | -99% | 99% |
1.3.4260 | Economic Development District | 70,000 | 0 | (58,333) | -100% | 100% |
1.1.4800 | Interest Income | 9,862 | 798 | (7,420) | -90% | 92% |
Revenue Total | 3,574,659 | 13,305 | (2,515,352) | -99% | 100% |
0%
0%
0%
0%
6%
3%
91%
County Appropriations Federal Agencies State Agencies
Local Agencies
Non-Governmental
Economic Development District
Interest Income
FY 2021 Budget | YTD January Expended | FY 21 Budget % balance | |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries | 236,733 | 17,483 | 93% |
Salaries Sub-Total | 236,733 | 17,483 | 93% |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION |
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH JANUARY 31, 2021 |
Contractual
5610-3 |
5610-3 |
RLF Services | 5,000 | - | 100% |
EDD- RLF CARES ACT | 550,000 | 100% | |
EDD Insititutional CARES ACT | 136,000 | 100% | |
Contractual Sub-Total | 691,000 | - | 100% |
Communications | 500 | - | 100% |
PPE Supplies & Office Supplies | 25,000 | 80 | 100% |
Departmental Sub-Total | 25,000 | 80 | 100% |
Departmental
YTD January 2021 Expenses Budget vs Actual
250,000
236,733
200,000
165,000
150,000
100,000
55,267
50,000
17,483
25,000
5,000
-
80
-
SALARIES
CONTRACTURAL
DEPARTMENTAL
CAPITAL OUTLAYS
Budget Expended
Capital Outlays
Furniture and Equipment | 165,000 | 55,267 | 67% |
Capital Outlays Sub-Total | 165,000 | 55,267 | 67% |
TOTAL NIRPC CARES FUND EXPENDITURES | 1,117,733 | 72,830 | 93% |
CARES Revolving Loan Fund | 583,000 | - |
CARES Transit Capital Fund | 1,219,972 | 58,816 |
CARES Transit Agency Fund | 4,314,322 | 129,098 |
TOTAL EXPENDITURES | 7,235,027 | 260,744 |
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH JANUARY 31, 2021 |
Line Items | FY 2021 Budget | YTD January Collected | FY 21 Budget % balance |
CARES ACT OPERATING | |||
Operating Revenue | 419,386 | 0 | 100% |
Capital Revenue | 125,000 | 0 | 100% |
CARES ACT EDA Economic Development District | 59,843 | 0 | 100% |
604,229 | 0 | 100% |
CARES AGENCY | FTA Revenue | 2,694,048 | 2,065 | 100% |
CARES TRANSIT CAPITAL | FTA Revenue | 1,008,732 | 129,098 | 87% |
Revenue Total | 4,307,009 | 131,163 | 97% |
0%
CARES Operating
Economic Development District
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 |
1/5/2021 | 4077 | DeLage Landen Financial Service, Inc | General Fund 5243.9 | $ 3,538.44 | $ 3,538.44 | C4077 | IT Services |
1/5/2021 | 4077 | DeLage Landen Financial Service, Inc | General Fund 5244.9 | $ 741.83 | $ 741.83 | C4077 | Telephone Services |
1/5/2021 | 4077 | DeLage Landen Financial Service, Inc | General Fund 5241.9 | $ 842.74 | $ 842.74 | C4077 | Copier/Lease |
1/5/2021 | 4051 | United HealthCare Srvc, Inc | General Fund 5142.9 | $ 8,989.67 | $ 8,989.67 | C4051 | ER paid for JAN 2021-Health Insurance |
1/5/2021 | 4051 | United HealthCare Srvc, Inc | General Fund 2152.0 | $ 1,706.52 | $ 1,706.52 | C4051 | EE w/h's for JAN 2021- Health Insurance |
1/6/2021 | 4047 | Anthem | General Fund 5143.9 | $ 476.41 | $ 476.41 | 2712 | Life Insurance -Jan 2021 |
1/6/2021 | 4050 | Blachly,Tabor,Bozik & Hartman, LCC | General Fund 5602.9 | $ 1,700.00 | $ 1,700.00 | 2713 | Legal - Jan 2021 |
1/6/2021 | 4064 | City of Portage | General Fund 5224.9 | $ 1,744.98 | $ 1,744.98 | 2714 | Utilities - DEC 2020 |
1/6/2021 | 4063 | City of Portage | General Fund 5221.9 | $ 19,244.56 | $ 19,244.56 | 2714 | Lease - Jan 2021 |
1/6/2021 | 4044 | Council of Development Finance Agencies | General Fund 5410.3 | $ 550.00 | $ 550.00 | 2715 | Annual member dues Jan-Dec 2021 |
1/6/2021 | 4039 | ESRI, Inc | General Fund 5410.2 | $ 4,200.00 | $ 4,200.00 | 2717 | ArcGIS Desktop Standard Concurrent Use/Communication/Maintenance 2-1-21 to 1-31 22 |
1/6/2021 | 4054 | Health Resources, Inc | General Fund 2153.0 | $ 517.33 | $ 517.33 | 2718 | Dental Insruance Jan 2021 |
1/6/2021 | 4055 | Kansas City Life Insruance | General Fund 5143.9 | $ 791.93 | $ 791.93 | 2720 | Life Insurance -Jan 2021 |
1/6/2021 | 4062 | Morneau Shepell BDA Limited | General Fund 2010.0 | $ 750.00 | $ 750.00 | 2721 | Employee Assistant Program-Quarterly fee Jan Mar 2021 |
1/6/2021 | 4065 | South Shore Clean Cities Inc | General Fund 5610.5 | $ 80,032.00 | $ 80,032.00 | 2724 | July 1- Sept 30 2020-CMAQ Air Quallity Public Education Quarterly Invoice |
1/6/2021 | 4936 | United Way of Porter County | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2726 | 12/7-12/20/2020 pay period - United Way |
1/6/2021 | 4946 | United Way of Porter County | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2726 | 12/21/202-1/3/2021 pay period - United Way |
1/7/2021 | 4056 | Fidelity EyeMed | General Fund 2154.0 | $ 108.57 | $ 108.57 | C4056 | Vision Insuance |
1/7/2021 | 4053 | Total Disposal | General Fund 5223.9 | $ 74.00 | $ 74.00 | C4053 | Recycle/Trash |
1/7/2021 | 4059 | Warner,Ty | General Fund 5410.9 | $ 46.98 | $ 46.98 | C4059 | Mileage- 45th St Ribbon Cutting/Cline Ave Ribbon Cutting |
1/7/2021 | 4052 | Warner,Ty | General Fund 5244.9 | $ 125.00 | $ 125.00 | C4052 | Communication Expense - Jan 2021 |
1/8/2021 | 4061 | Comcast | General Fund 5244.9 | $ 139.64 | $ 139.64 | C4061 | Business Internet |
1/10/2021 | 4046 | Chicago Tribune | General Fund 5410.1 | $ 27.72 | $ 27.72 | CC4046 | News Paper Subscription |
1/10/2021 | 4007 | GoodHire | General Fund 5410.9 | $ 54.99 | $ 54.99 | CC4007 | Standard Background Check |
1/10/2021 | 4057 | LAI-LAMBDA ALPHA INTERNATIONL | General Fund 5410.1 | $ 285.00 | $ 285.00 | CC4057 | International dues/Active- Ely Chapter |
1/10/2021 | 4049 | Modern Tribe | General Fund 5410.1 | $ 89.00 | $ 89.00 | CC4049 | Event Calendar Pro Web/Access-yearly Subscription 18 |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
1/10/2021 | 4045 | Stamps | General Fund 5249.9 | $ 24.99 | $ 24.99 | CC4045 | Stamps |
1/12/2021 | B-4941 | Federal & Fica | General Fund 2140.0 | $ 4,456.60 | $ 4,456.60 | C4941 | 12/21/2020-1/3/2021 pay period- FWT,empfica, emficamed - Federal Tax Withholdings Payable |
1/12/2021 | B-4941 | Federal & Fica | General Fund 2142.0 | $ 7,327.08 | $ 7,327.08 | C4941 | 12/21/2020-1/3/2021 pay period -FWT, empfica, emficamed- FICA Tax Withholdings Payable |
1/12/2021 | B-4944 | Horizon Bank | General Fund 2150.0 | $ 792.31 | $ 792.31 | C4944 | 12/21/2020-1/3/2021 pay period -HAS |
1/12/2021 | 4060 | ICMA Retirment Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4060 | ER paid for Ty Warner 12/21/2020 thru 1/3/2021-p/r |
1/12/2021 | B-4945 | ICMA Retirment Fund-PR | General Fund 2146.0 | $ 1,554.25 | $ 1,554.25 | C4945 | 12/21/2020-1/3/2021 pay period - ICMA |
1/12/2021 | Payroll | $ 36,300.41 | $ 36,300.41 | Payroll ending 1/03/2021 | |||
1/13/2021 | B-4943 | INPRS | General Fund 2149.0 | $ 6,273.93 | $ 6,273.93 | C4943 | 12/21/2020-1/3/2021 pay period - EmpPerf [NIRPC] |
1/14/2021 | B-4932 | IN Dept of Revenue | General Fund 2143.0 | $ 1,530.65 | $ 1,530.65 | C4932 | 12/7-12/20/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable |
1/14/2021 | B-4932 | IN Dept of Revenue | General Fund 2144.0 | $ 322.31 | $ 322.31 | C4932 | 12/7-12/20/2020 pay period -LwtIN, SwtIN Local Tax Withholdings Payable |
1/14/2021 | B-4874 | IN Dept of Revenue | General Fund 2143.0 | $ 1,469.90 | $ 1,469.90 | C4874 | 11/23-12/6/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable |
1/14/2021 | B-4874 | IN Dept of Revenue | General Fund 2144.0 | $ 307.19 | $ 307.19 | C4874 | 11/23-12/6/2020 pay period - LwtIN, SwtIN Local Tax Withholdings Payable |
1/14/2021 | B-4865 | IN Dept of Revenue | General Fund 2143.0 | $ 91.22 | $ 91.22 | C4865 | Edwards vacation payout- LwtIN, SwtIN State Tax Withholdings Payable |
1/14/2021 | B-4865 | IN Dept of Revenue | General Fund 2144.0 | $ 26.83 | $ 26.83 | C4865 | Edwards vacation payout- LwtIN, SwtIN Local Tax Withholdings Payable |
1/14/2021 | B-4868 | IN Dept of Revenue | General Fund 2143.0 | $ 1,435.80 | $ 1,435.80 | C4868 | 11/9-11/22/2020 pay period - LwtIN, SwtIN State Tax Withholdings Payable |
1/14/2021 | B-4868 | IN Dept of Revenue | General Fund 2144.0 | $ 306.26 | $ 306.26 | C4868 | 11/9-11/22/2020 pay period - LwtIN, SwtIN Local Tax Withholdings Payable |
1/15/2021 | 4068 | Horizon Bank | General Fund 5142.9 | $ 20,000.00 | $ 20,000.00 | C4068 | ER paid Health Savings- JAN 2021 |
1/26/2021 | B-4977 | Federal & Fica | General Fund 2140.0 | $ 4,456.93 | $ 4,456.93 | C4977 | 1/4-1/17/2021 pay period - FWT, empfica, empficamed Federal Tax Withholdings Payable |
1/26/2021 | B-4977 | Federal & Fica | General Fund 2142.0 | $ 7,327.54 | $ 7,327.54 | C4977 | 1/4/-1/17/2021 pay period - FWt, empfica, empficamed FICA Tax Withholdindgs Payable |
1/26/2021 | B-4980 | Horizon Bank | General Fund 2150.0 | $ 792.31 | $ 792.31 | C4980 | 1/4-1/17/2021 pay period - HAS |
1/26/2021 | B-4981 | ICMA Retirment Fund-PR | General Fund 2146.0 | $ 1,554.25 | $ 1,554.25 | C4981 | 1/4 - 1/17/2021 pay period - ICMA |
1/26/2021 | 4081 | ICMA Retirment Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4081 | ER paid for Ty Warner 1/4/2020 thru 1/17/2021-p/r |
1/26/2021 | 4084 | IN Dept of Workforce Dev | General Fund 5123.9 | $ 48.01 | $ 48.01 | C4084 | 4th Quarter 2020 Unemploment Tax |
1/26/2021 | Payroll | $ 36,302.58 | $ 36,302.58 | Payroll ending 1/17/2021 | |||
1/27/2021 | 4082 | INPRS | General Fund 5141.9 | $ 0.01 | $ 0.01 | C4082 | Rounding Adjustment 1/4/2021-1/17/2021 pr |
1/27/2021 | B-4979 | INPRS | General Fund 2149.0 | $ 6,274.33 | $ 6,274.33 | C4979 | 1/4-1/17/2021 pay period-EmpPerf [NIRPC] |
1/28/2021 | 4074 | Bryco | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 2727 | Recycle/Trash |
1/28/2021 | 4091 | City of Portage | General Fund 5224.9 | $ 1,869.17 | $ 1,869.17 | 2728 | Sewer/Water/Gas/Electric Service |
1/28/2021 | 4090 | Engravables | General Fund 5410.1 | $ 12.00 | $ 12.00 | 2729 | Yearly officer's plaque engraved plate |
1/28/2021 | 4090 | Engravables | General Fund 5410.1 | $ 41.00 | $ 41.00 | 2729 | Gavel and laser engraved plate |
1/28/2021 | 4087 | Nat'l Assoc of Regional Councils | General Fund 5410.0 | $ 250.00 | $ 250.00 | 2730 | NARC 2021 Confernece Ty Warner |
1/28/2021 | 4087 | Nat'l Assoc of Regional Councils | General Fund 5410.1 | $ 250.00 | $ 250.00 | 2730 | NARC 2021 Confernece Justin 1K9iel |
1/28/2021 | 4078 | Nat'l Assoc of Regional Councils | General Fund 5410.1 | $ 250.00 | $ 250.00 | 2730 | NARC 2021 Confernece Geof Benson |
1/28/2021 | 4073 | Quill | General Fund 5430.9 | $ 183.53 | $ 183.53 | 2732 | Office Supplies |
1/28/2021 | 3982 | SME | General Fund 5610.5 | $ 28,343.73 | $ 28,343.73 | 2733 | Programmatic Support & Outreach-Programmatic Hazardous/Petroleum Site Assessment- Hazardous Substance |
1/28/2021 | B-4982 | United Way of Porter County | General Fund | $ 33.85 | $ 33.85 | 2734 | 1/4-1/17/2021 pay period - United Way |
1/28/2021 | 4080 | Ecointeractive | General Fund 5610.2 | $ 3,750.00 | $ 3,750.00 | C4080 | TIP SAAS Service Mthly fee -DEC 2020 |
1/28/2021 | 4086 | Ecklund, Candice | General Fund 5410.9 | $ 23.40 | $ 23.40 | C4086 | Mileage- Engrave Chair plaque and plate/drop off and pickup |
General Fund | $ - |
Total: | $ 303,964.20 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 303,964.20
|
Dated this day of , 2021.
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 |
1/6/2021 | 4038 | ADOBE | CARES Fund 5910.0 | $ 8,049.00 | $ 8,049.00 | 2711 | Adobe Standar DC Licenses |
1/6/2021 | 4000 | ERS Wireless | CARES Fund 5960.0 | $ 16,802.27 | $ 16,802.27 | 2716 | Motorola XPR7550e UHF Portable Radios |
1/6/2021 | 3928 | Impact Networking LLC | CARES Fund 5910.0 | $ 47,217.86 | $ 47,217.86 | 2719 | ZFIREFLY/Lenovo ThinkPads/RAM Chips/DOCKS/Installatiion & Configuration |
1/6/2021 | 3960 | Pulse Technology | CARES Fund 5430.9 | $ 39.99 | $ 39.99 | 2722 | Office Supplies- Lysol- COVID 19 |
1/6/2021 | 4058 | Routhmatch | CARES Fund 5960.0 | $ 2,065.00 | $ 2,065.00 | 2723 | SLCCS/NT/PCACS |
1/6/2021 | 3952 | Tennant Sales and Service Company | CARES Fund 5960.0 | $ 39,949.00 | $ 39,949.00 | 2725 | Tennant-Floor Sweeper/Battery/Charger/Vacuum Wand.Freight/Less Discount |
1/11/2021 | 3994 | North Township | CARES Fund 5760.0 | $ 118,851.00 | $ 118,851.00 | C3994 | NT Reimb for OA Apr-Jun2020 DRAW 24-CARES20 |
1/11/2021 | 3995 | North Township | CARES Fund 5760.0 | $ 10,247.00 | $ 10,247.00 | C3995 | NT Reimb for PM Apr-Jun2020 DRAW 23-CARES20 |
1/11/2021 | 4009 | North Township | CARES Fund 5760.0 | $ 42,336.00 | $ 42,336.00 | C4009 | 2nd and 3rd Quarter PMTF Reimbursement |
1/28/2021 | 3960 | Pulse Technology | CARES Fund 5430.9 | $ 39.99 | $ 39.99 | 2731 | Office Supplies- Lysol- COVID 19 |
CARES Fund | $ - |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $285,597.11 |
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 $ 285,597.11
|
Dated this day of , 2021.
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 3/04/2021 @ 10:42 AM
Reconciliation - General
Page: 1
STK 3/4/21
03/12/2021
Closing Balance from Previous Statement........................................................................................... 1/31/2021 1,201,555.73
15 | Deposits and Other Additions Totaling...................................................................... | 337,831.91 | |
98 | Checks and Other Withdrawls Totaling..................................................................... | 426,944.65 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
1 | Voids Totaling........................................................................................................ | 1,425.00 | |
Service Charge....................................................................................................... | 2/10/2021 | 94.40 | |
Interest Earned....................................................................................................... | 2/26/2021 | 89.66 | |
Closing Balance for this Statement..................................................................................................... | 2/28/2021 | 1,113,863.25 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 2/28/2021 | 1,091,474.54 | |
Open Activity from Bank Register............................................................................. | (22,388.71) | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement................................................................................................. | 1,113,863.25 | ||
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 |
12/15/2020 | 0002704 INRO Consultants | Renewal Software Agreement 7/1/20- | 1,680.00 |
1/28/2021 | 0002730 Nat'l Assoc. of Regional Councils | 12/31/20 Invoices 4078, 4087 | 750.00 |
2/09/2021 | 0002743 Nat'l Assoc. of Regional Councils | NARC 2021 Conference- George Topoll | 250.00 |
2/09/2021 | 0002747 United Way of Porter County | 1/18 - 1/31/2021 pay period - United Way | 33.85 |
2/23/2021 | 0002750 City of Portage, The | Sewer/Water Service/Gas/Electric-FEB | 2,094.35 |
2/23/2021 | 0002751 Health Resources,Inc | Invoices 4121, 4123 | 1,984.20 |
2/23/2021 | 0002752 SME | Invoices 111466, 112299, 114252, 115066, | 13,991.26 |
115067 | |||
2/23/2021 | 0002753 United Way of Porter County | 2/1 - 2/14 pay period - United Way | 33.85 |
Total Unmarked Checks: 22,388.71 | Total Checks: | 22,388.71 | |
Trial Balance - Cash
Run: 3/04/2021 at 10:54NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 2/28/2021
Page: 1
All Balance
1.1.001.0000.1010.0 Cash 1,091,474.54
Total 1,091,474.54
STK 3/4/21
4 | Deposits and Other Additions Totaling...................................................................... | 3,178.31 | |
0 | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
0 | Voids Totaling........................................................................................................ | 0.00 | |
Service Charge....................................................................................................... | 0.00 | ||
Interest Earned....................................................................................................... | 2/26/2021 | 6.43 | |
Closing Balance for this Statement..................................................................................................... | 2/28/2021 | 168,352.46 | |
Difference............................................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 2/28/2021 | 168,352.46 | |
Open Activity from Bank Register............................................................................. | 0.00 | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement................................................................................................. | 168,352.46 | ||
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 3/03/2021 @ 1:43 PM
Reconciliation - Revolving Loan Fund
Page: 1
STK 3/3/21
03/12/2021
Trial Balance - Cash
Run: 3/04/2021 at 11:06NAOM RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 2/28/2021
Page: 1
All Balance
2.3.050.0000.1010.0 Cash 168,352.46
Total 168,352.46
STK 3/4/21
BUDGET TO ACTUAL EXPENDITURES REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021 |
Line Items | FY 2021 Budget | FY 21 YTD February Budget % Expended balance |
Salaries | |||
5020-1 | Total Salaries | 1,565,254 | 171,663 89% |
Salaries Sub-Total | 1,565,254 | 171,663 89% |
Fringe Benefits | ||||
5121-9 | FICA Contributions | 119,742 | 15,003 | 87% |
5122-9 | Workers Compensation | 9,500 | 0 | 100% |
5123-9 | Unemployment Compensation | 3,000 | 48 | 98% |
5141-9 | PERF Contributions | 200,012 | 25,724 | 87% |
5142-9 | Health Insurance | 230,000 | 43,031 | 81% |
5143-9 | Life & Disability Insurance | 24,000 | 2,742 | 89% |
5145-9 | ICMA | 23,000 | 3,424 | 85% |
5146-9 | Staff Development | 20,000 | 0 | 100% |
Fringe Benefits Sub-Total | 629,254 | 89,971 | 86% | |
Occupancy | ||||
5221-9 | Office Lease | 231,000 | 37,550 | 84% |
5222-9 | Property Insurance | 6,500 | 100 | 98% |
5223-9 | Building Maintenance | 18,540 | 2,998 | 84% |
5224-9 | Utilities | 30,650 | 5,709 | 81% |
Occupancy Sub-Total | 286,690 | 46,357 | 84% | |
Maintenance | ||||
5241-9 | Copier Leasing/Maintenance | 20,370 | 1,685 | 0% |
5243-9 | Computer Service/Maintenance | 43,736 | 7,077 | 0% |
5244-9 | Telephone Service/Maintenance | 18,900 | 2,013 | 0% |
Combined Copier/IT/Phone Service/Maintenance | 83,006 | 10,775 | 87% | |
5249-9 | Other Equipment Maintenance | 2,000 | 50 | 98% |
Maintenance Sub-Total | 85,006 | 10,825 | 87% | |
Departmental | ||||
5410-1 | Communications: Commission/Ex. Dir. | 41,500 | 2,050 | 95% |
5410-2 | Communications: Transportation | 299,000 | 4,200 | 99% |
5410-4 | Communications: Subgrantee Management | 25,000 | 0 | 100% |
5410-5 | Communications: Environmental Programs | 25,255 | 0 | 100% |
5410-8 | Communications: Partner Agency | 1,000 | 0 | 100% |
5410-9 | Communications: Allocated Functions | 28,000 | 388 | 99% |
5420-5 | Promotional Expenses: Environmental Programs | 3,700 | 0 | 100% |
Economic Development District | 11,768 | 0 | 100% | |
5430-9 | General Use Supplies Expense | 7,000 | 226 | 97% |
Departmental Sub-Total | 442,223 | 6,864 | 98% | |
Contractual | ||||
5602-9 | Legal Services | 22,200 | 3,400 | 85% |
5603-9 | Audit and Accounting | 38,000 | 0 | 100% |
5604-9 | LaPorte RLF Services | 2,000 | 0 | 100% |
5610-4 | Transit Oversight | 17,347 | 0 | 100% |
5610-5 | Environmental Projects | 837,300 | 129,568 | 85% |
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 | 4,250 | 92% |
Contractual Sub-Total | 1,292,347 | 137,218 | 89% | |
Capital Outlays | |||
5910-0 | Furniture and Equipment | 180,000 | 0 100% |
Capital Outlays Sub-Total | 180,000 | 0 100% | |
TOTAL GENERAL FUND EXPENDITURES | 4,480,774 | 462,898 90% |
LaPorte Revolving Loan Fund | 85,000 | 0 |
Transit Capital Fund | 142,080 | 0 |
Transit Operating Fund | 4,460,765 | 127,010 |
TOTAL EXPENDITURES | 9,168,619 | 589,908 |
300,000
260,876
250,000
215,391
200,000
171,663
150,000
137,218
104,876
89,971
100,000
73,704
47,782 46,357
50,000
14,168 10,825
6,864
-
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD February Budget YTD February Expended
30%
37%
2%
2%
10%
19%
Salaries
Fringe Benefits Occupancy Maintenance Departmental
Contractuals
BUDGET TO ACTUAL REVENUE REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021 |
0%
0%
0%
0%
31%
69%
0%
County Appropriations
Federal Agencies State Agencies Local Agencies
Non-Governmental
Economic Development District
Interest Income
FY 20
Line Items | FY 2020 Budget | YTD February YTD Variance YTD % Budget % Collected (Under)/Over Variance balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 0 | 0 | 0% | 100% |
1.1.4210 | Federal Agencies | 869,119 | 0 | (724,266) | -100% | 100% |
1.1.4310 | State Agencies | 1,955,395 | 0 | (1,629,496) | -100% | 100% |
1.1.4410 | Local Agencies | 44,694 | 0 | (37,245) | -100% | 100% |
1.1.4610 | Non-Governmental | 85,318 | 600 | (70,498) | -99% | 99% |
1.3.4260 | Economic Development District | 70,000 | 0 | (58,333) | -100% | 100% |
1.1.4800 | Interest Income | 9,862 | 1,317 | (6,902) | -84% | 87% |
Revenue Total | 3,574,659 | 1,917 | (2,526,740) | -100% | 100% |
BUDGET TO ACTUAL EXPENDITURES REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021 |
Line Items | FY 2021 Budget | YTD February Expended | FY 21 Budget % balance |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries | 236,733 | 34,379 | 85% |
Salaries Sub-Total | 236,733 | 34,379 | 85% |
Contractual | |||
RLF Services | 5,000 | - | 100% |
EDD- RLF CARES ACT | 550,000 | 100% | |
EDD Insititutional CARES ACT | 136,000 | 100% | |
Contractual Sub-Total | 691,000 | - | 100% |
Departmental | |||
Communications | 500 | - | 100% |
PPE Supplies & Office Supplies | 25,000 | 120 | 100% |
Departmental Sub-Total | 25,000 | 120 | 100% |
Capital Outlays |
Furniture and Equipment | 165,000 | 56,009 | 66% |
Capital Outlays Sub-Total | 165,000 | 56,009 | 66% |
TOTAL NIRPC CARES FUND EXPENDITURES | 1,117,733 | 90,507 | 92% |
CARES Revolving Loan Fund | 583,000 | - |
CARES Transit Capital Fund | 1,219,972 | 154,827 |
CARES Transit Agency Fund | 4,314,322 | 129,098 |
TOTAL EXPENDITURES | 7,235,027 | 374,432 |
YTD February 2020 Expenses Budget vs Actual
250,000
236,733
200,000
165,000
150,000
100,000
56,009
50,000
34,379
25,000
5,000
-
120
-
SALARIES
CONTRACTURAL
DEPARTMENTAL
CAPITAL OUTLAYS
Budget Expended
BUDGET TO ACTUAL REVENUE REPORT FEBRUARY 1 THROUGH FEBRUARY 28, 2021 |
Line Items | FY 2021 Budget | YTD February Collected | FY 21 Budget % balance |
CARES ACT OPERATING | |||
Operating Revenue | 419,386 | 2,725 | 99% |
Capital Revenue | 125,000 | 0 | 100% |
CARES ACT EDA Economic Development District | 59,843 | 0 | 100% |
604,229 | 2,725 | 100% |
CARES AGENCY | FTA Revenue | 2,694,048 | 108,377 | 96% |
CARES TRANSIT CAPITAL | FTA Revenue | 1,008,732 | 129,098 | 87% |
Revenue Total | 4,307,009 | 240,200 | 94% |
0%
100%
CARES Operating
Economic Development District
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 |
2/2/2021 | 4099 | DeLage Landen Financial | General Fund 5243.9 | $ 5,329.26 | $ 5,329.26 | C4099 | IT/Telephone/Copier/Maint.Office |
2/3/2021 | 4105 | United HealthCare | General Fund 5142.9 | $ 14,040.97 | $ 14,040.97 | C4105 | ER paid for FEB Health Insurance |
2/3/2021 | 4105 | United HealthCare | General Fund 2152.0 | $ 2,593.64 | $ 2,593.64 | C4105 | EE paid for FEB Health Insurance |
2/9/2021 | Payroll | $ 36,172.35 | $ 36,172.35 | Pay period ending 1/31/2021 | |||
2/9/2021 | Payroll | $ 156.32 | $ 156.32 | Pay period ending 1/31/2021 | |||
2/9/2021 | 4115 | Adams Radio Group | General Fund 5610.5 | $ 952.00 | $ 952.00 | 2735 | 60 second commercials Mon-Sat for 1wk 20% match funded with Deferred Revenue |
2/9/2021 | 4108 | Adams Radio Group | General Fund 5610.5 | $ 1,188.74 | $ 1,188.74 | 2735 | Weather Sponsorship |
2/9/2021 | 4106 | Anthem Life | General Fund 5143.9 | $ 511.80 | $ 511.80 | 2737 | Life Insurance FEB |
2/9/2021 | 4110 | Blachly, Tabor Bozak & Hartman | General Fund 5602.9 | $ 1,700.00 | $ 1,700.00 | 2737 | Legal Services |
2/9/2021 | 4113 | Bryco | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 2748 | Office Cleaning- FEB |
2/9/2021 | 4109 | City of Portage | General Fund 5241.9 | $ 18,305.80 | $ 18,305.80 | 2739 | Lease- FEB |
2/9/2021 | 4088 | ESRI, Inc | General Fund 5610.2 | $ 500.00 | $ 500.00 | 2740 | ERSI Credits-online storage of shapefile/maps etc. |
2/9/2021 | B-5006 | Federal & Fica | General Fund 2142.0 | $ 27.00 | $ 27.00 | C5006 | Warner retro pay for 2020 (under paid by $176.40) empfica, empficamed |
2/9/2021 | B-5000 | Federal & Fica | General Fund 2140.0 | $ 4,358.07 | $ 4,358.07 | C5000 | 1/18-1/31/2021 pay period-FWT, empfica, empfica med--Federal Tax Withholdings Payable |
2/9/2021 | B-5000 | Federal & Fica | General Fund 2142.0 | $ 7,286.28 | $ 7,286.28 | C5000 | 1/18-1/31/2021 pay period-FWT, empfica, empfica med--FICA Tax Withholdings Payable |
2/9/2021 | B-5003 | Horizon Bank | General Fund 2150.0 | $ 792.31 | $ 792.31 | C5003 | 1/18-1/31/2021 pay period-HAS |
2/9/2021 | B-5004 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 1,554.25 | $ 1,554.25 | C5004 | 1/18-1/31/2021-pay period ICMA |
2/9/2021 | 4096 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4096 | ER paid for Ty Warner 1/18/2021 thru 1/31/2021-p/r |
2/9/2021 | 4100 | Kansas City Life | General Fund 5143.9 | $ 962.26 | $ 962.26 | 2741 | Life Insurance FEB |
2/9/2021 | 4114 | Liberty Mutual Ins. | General Fund 5222.9 | $ 100.00 | $ 100.00 | 2742 | Public Offical Bond NIRPC Treasure |
2/9/2021 | 4112 | Nat'l Assoc. Of Regional Councils | General Fund 5410.1 | $ 250.00 | $ 250.00 | 2743 | NARC-2021 Conference- George Topoll |
2/9/2021 | 4089 | Premier Graphics &n Promotions | General Fund 5610.5 | $ 5,060.00 | $ 5,060.00 | 2744 | Printing Service for Bicycle Maps-25,0000 |
2/9/2021 | 4092 | Pulse Technology | General Fund 5430.9 | $ 42.18 | $ 42.18 | 2745 | Office Supplies |
2/9/2021 | B-5005 | United Way of Porter County | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2747 | 1/18-1/31/2021 pay period- United Way |
2/10/2021 | Account Service Fee | $ 94.40 | $ 94.40 | ||||
2/10/2021 | B-5002 | INPRS | General Fund 2149.0 | $ 6,273.93 | $ 6,273.93 | C5002 | 1/18-1/31/2021 pay period -EmpPerf {NIRPC} |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
2/10/2021 | 4101 | Eklund, Candice | General Fund 5410.9 | $ 7.80 | $ 7.80 | C4101 | Mileage-Deliver plaque for M. Griffin - roundtrip |
2/10/2021 | 4107 | Fidelity EyeMed Vision | General Fund 2154.0 | $ 99.01 | $ 99.01 | C4107 | Vision Insurance |
2/10/2021 | 4111 | Warner,Ty | General Fund 5254.9 | $ 125.00 | $ 125.00 | C4111 | Commuincation Fee |
2/10/2021 | 4102 | Total Disposal | General Fund 5223.9 | $ 74.00 | $ 74.00 | C4102 | Recycle/Trash |
2/11/2021 | 4104 | Comcast | General Fund 5244.9 | $ 139.64 | $ 139.64 | C4104 | Business Internet |
2/17/2021 | B-4978 | IN Dept of Revenue | General Fund 2143.0 | $ 1,491.74 | $ 1,491.74 | C4978 | 1/4-1/17/2021 pay period- LwtIN, SwtIN-- State Tax Withholdings Payable |
2/17/2021 | B-4978 | IN Dept of Revenue | General Fund 2144.0 | $ 314.95 | $ 314.95 | C4978 | 1/4-1/17/2021 pay period- LwtIN, SwtIN-- Local Tax Withholding Payable |
2/17/2021 | B-4942 | IN Dept of Revenue | General Fund 2143.0 | $ 1,491.65 | $ 1,491.65 | C4942 | 12/21/2020-1/3/2021 pay period- LwtIN, SwtIN -State Tax Withholdings Payable |
2/17/2021 | B-4942 | IN Dept of Revenue | General Fund 2144.0 | $ 314.93 | $ 314.93 | C4942 | 12/21//2020-1/3/2021 pay period-LwtIN, SwtIN -Local Withholding Payable |
2/23/2021 | Payroll | $ 36,291.51 | $ 36,291.51 | Pay period ending 2/14/2021 | |||
2/23/2021 | 4128 | City of Portage | General Fund 5224.9 | $ 2,094.35 | $ 2,094.35 | 2750 | Sewer/Water/Electrical- FEB |
2/23/2021 | B-5030 | Federal & Fica | General Fund 2140.0 | $ 4,398.03 | $ 4,398.03 | C5030 | 2/1-2/14 pay period - FWT, empfica, empficamed Federal Tax Withholdings Payable |
2/23/2021 | B-5030 | Federal & Fica | General Fund 2142.0 | $ 7,314.08 | $ 7,314.08 | C5030 | 2/1-2/14 pay period - FWT, empfica, empficamed FICA Tax Withholdings Payable |
2/23/2021 | 4121 | Health Resources | General Fund 2153.0 | $ 1,041.14 | $ 1,041.14 | 2751 | Dental Insurance- FEB |
2/23/2021 | 4123 | Health Resources | General Fund 2153.0 | $ 943.06 | $ 943.06 | 2751 | Dental Insurance- March |
2/23/2021 | B-5033 | Horizon Bank | General Fund 2150.0 | $ 792.31 | $ 792.31 | C5033 | 2/1-2/14 pay period- HAS |
2/23/2021 | B-5034 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 1,554.25 | $ 1,554.25 | C5034 | 2/1-2/14 pay period- ICMA |
2/23/2021 | 4119 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 855.91 | $ 855.91 | C4119 | ER paid for Ty Warner 2/1/2021 thru 2/14/2021-p/r |
2/23/2021 | 3982 | SME | General Fund 5610.5 | $ 100.00 | $ 100.00 | C3982 | Professional Services from Nov23-Dec20, 2020 Programmatic Support & Outreach Petroleum |
2/23/2021 | 3982 | SME | General Fund 5610.5 | $ 7,557.51 | $ 7,557.51 | C3982 | Professional Services from Nov23-Dec20, 2020 Programmatic Support & Outreach Hazardous |
2/23/2021 | 3982 | SME | General Fund 5610.5 | $ 2,423.75 | $ 2,423.75 | C3982 | Professional Services from Oct 26-Nov 22, 2020 Programmatic Support & Outreach Hazardous |
2/23/2021 | 3982 | SME | General Fund 5610.5 | $ 485.00 | $ 485.00 | C3982 | Professional Services from Aug 24-Sept 20, 2020 Programmatic Support & Outreach Petroleum |
2/23/2021 | 3982 | SME | General Fund 5610.5 | $ 3,425.00 | $ 3,425.00 | C5035 | Profssional Services from July 27-Aug23, 2020 Programmatic Support & Outreach Petroleum |
2/23/2021 | B-5035 | United Way of Porter County | General Fund 2147.0 | $ 33.85 | $ 33.85 | C5035 | 2/1-2/14-pay period- United Way |
2/24/2021 | 4122 | IN Dept of Revenue | General Fund 5481.0 | $ 310.00 | $ 310.00 | C4122 | Penalty Tax Due for period ending 12/31/2019 |
2/24/2021 | 4118 | INPRS | General Fund 5141.9 | $ 0.01 | $ 0.01 | C4118 | Rounding Adjustment 2/1/2021-2/14/2021 pr |
2/24/2021 | B-5032 | INPRS | General Fund 2149.0 | $ 6,273.93 | $ 6,273.93 | C5032 | 2/1-2/14 pay period - EmpPerf [NIRPC] |
General Fund | $ - |
Total: | $ 190,518.73 |
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 $ 190,518.73
|
Dated this day of , 2021.
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 |
2/9/2021 | 3960 | Pulse Technology | CARES Fund 5430.9 | $ 39.99 | $ 39.99 | 2745 | Lysol Membership- Covid 19 |
2/9/2021 | 4097 | RouteMatch | CARES Fund 5960.0 | $ 2,065.00 | $ 2,065.00 | 2746 | SLCCS/NT/PCACS- FEB Monthly SaaS and Notificaiton Module(NM)pkg- 35 Vehicles |
2/17/2021 | 4095 | Opportunity Enterprises | CARES Fund 5960.0 | $ 48,610.00 | $ 48,610.00 | C4095 | Construction Wrork/Installation of transit facility |
2/23/2021 | 3955 | Bosak Ford | CARES Fund 5960.0 | $ 34,209.00 | $ 34,209.00 | 2749 | 2020 F-150 4x4 Regaular Cab Styleside 8" box |
2/26/2021 | 4069 | City Of Valpo, The | CARES Fund 5960.0 | $ 5,780.00 | $ 5,780.00 | C4069 | Replace of gate opener at transit facility/Install walk gate next to existing gate at transit facility |
2/26/2021 | 4132 | Lake County Community Services, Inc | CARES Fund 5760.0 | $ 41,014.00 | $ 41,014.00 | C4132 | PMTF Reimbursement for 4th Quarter 2020 |
2/26/2021 | 4130 | North Township | CARES Fund 5760.0 | $ 21,170.00 | $ 21,170.00 | C4130 | PMTF Reimbursement for 4th Quarter 2020 |
2/26/2021 | 4070 | Opportunity Enterprises | CARES Fund 5960.0 | $ 5,346.59 | $ 5,346.59 | C4070 | Laser/Monitors/Dell OptiPlex 3070 Desktop Computers/HP202A toner Cartridges, Color and Black/Cable Matters 3-pack high speed HDMI |
2/26/2021 | 4131 | Porter County Aging and Community Services | CARES Fund 5760.0 | $ 22,490.00 | $ 22,490.00 | C4131 | PMTF Reimbursement for 4th Quarter 2020 |
CARES Fund | $ - | ||||||
CARES Fund | $ - |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $ 180,724.58 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the |
register such claims are hereby allowed in the total amount of $ 180,724.58
|
Dated this day of , 2021.
TO: NIRPC Finance & Personnel Committee and NIRPC Executive Board FROM: Denarie Kane, Economic Development Specialist, NIRPC
RE: Recommendation and Approval of Amendments to the La Porte County Revolving
Loan Fund Management Plan
DATE: February 18, 2021
The La Porte County Revolving Loan Fund (RLF) Board reviewed the attached summary of update recommendations prepared by Gabrielle Biciunas, Economic Development District Coordinator, and took approval action on February 3, 2021. This amendment process was initiated since a five year update of a RLF Management Plan is required by the Economic Development Administration (EDA).
Several of these amendments addressed items now required by EDA, and these are noted in the attached summary under Conflict of Interest, Allowable Cash Percentage, Audits, and Environmental Section. Under Economic Development Administration Reporting, the language was revised as suggested by EDA. In regard to Delinquency Management, the red edits are the additions that were made to the Management Plan’s existing language to address loan restructuring. The other changes (see page 1), reflect updates to Comprehensive Economic Development Strategy (CEDS), Economic Adjustment Overview, Application Fee, and Loan Servicing Procedures - Repayment.
The EDA subsequently approved and accepted all of these amendments on February 12, 2021. A request is now being made for the Finance and Personnel Committee to recommend that NIRPC’s Executive Board, acting on behalf of the Commission, also approve these amendments and adopt Resolution #21-03. Thank you.
Attachment: La Porte County RLF Management Plan - Update Recommendations (5 pages)
LaPorte County RLF Management Plan – Update Recommendations
Due by March 2021
Comprehensive Economic Development Strategy (CEDS)
Update to include Economic Development District designation.
Economic Adjustment Overview
Added more information from Bert and Clarence.
Application Fee
Updated language to: “will be determined based on contracted costs for the preparation of Credit Memo and Credit Report.” Removed the $200 application fee requirement. (page 16)
Loan Servicing Procedures
Repayment
Added language: If partial payment is received, the payment will first be applied to the interest.
Add language in Loan Closing Agreement Letter - Repayment section.
Conflict of Interest (language added by EDA)
Replace existing language with EDA required language:
EDA requires inclusion of the following:
Definitions.
An “Interested Party” is any officer, employee or member of the board of directors or other governing board of Recipient, including any other parties that advise, approve, recommend or otherwise participate in the business decisions of Recipient, such as agents, advisors, consultants, attorneys, accountants or shareholders. An Interested Party also includes the Interested Party’s “Immediate Family” (defined as a person’s spouse or partner in a domestic relationship, parents, grandparents, siblings, children and grandchildren, but not distant relatives, such as cousins, unless the distant relative lives in the same household as the person) and other persons directly connected to the Interested Party by law or through a business arrangement.
A conflict of interest generally exists when an Interested Party participates in a matter that has a direct and predictable effected on the Interested Party’s personal or financial interests or there is an appearance that an Interested Party’s objectivity in performing his or her responsibilities under the Project is impaired.
An appearance of impairment of objectivity could result from an organizational conflict where, because of other activities or relationships with other persons or entities, a person is unable or potentially unable to render impartial assistance, services, or advice. It also could result from non-financial gain to the individual, such as benefit to reputation or prestige in a professional field.
Conflicts of Interest Rules.
Recipient must adhere to EDA conflicts of interest rules set forth at 13 CFR § 302.17, including the following rules specific to RLFs:
An Interested Party of Recipient shall not receive, directly or indirectly, any personal or financial benefit resulting from the disbursement of RLF loans. A financial interest or benefit may include employment, stock ownership, a creditor or debtor relationship, or prospective employment with the organization selected or to be selected for a subaward.
Recipient shall not lend RLF funds to an Interested Party.
Former board members of Recipient and members of their Immediate Family shall not receive a loan from the RLF for a period of two years from the date that the board member last served on the board of directors.
Duty to Disclose.
Recipient must, in a timely fashion, disclose to EDA in writing any actual or potential conflict of interest.
Written Standard of Conduct.
Recipient must maintain written standards of conduct to establish safeguards to prohibit employees from using their positions for a purpose that constitutes or presents the appearance of a personal or organizational conflict of interest or personal gain in the administration of this RLF Award.
Recipient must maintain written standards of conduct covering conflicts of interest and governing the performance of its employees engaged in the selection, award and administration of contracts. See Section K, Other EDA Requirements, Subsection 4. Codes of Conduct and Sub-Award, Contract and Subcontract Provisions, Subsection b), Competition and Codes of Conduct for Subawards.
Delinquency Management
If defaults have occurred and are not cured in a reasonable amount of time, actions can be taken prior to restructuring loan agreements and pursuing legal action to recover the investment. NIRPC staff and/or contracted service will stay in close contact with the business to monitor activity and be immediately aware of further deterioration. Possible activities include:
Increase financial reporting
Require monthly cash flow reconciliation, such as:
The borrower shall submit financial statements for the business and any individuals providing a personal guarantee for the loan. Financial statements should be dated within 90 days of the payment default.
The financial statements should be analyzed to determine the borrower’s ability to repay the debt based on its current financial condition. The cash flow of the business is the primary source of repayment; however, the liquidity of the business, excess cash flow of the personal guarantors, and liquidity of the personal guarantors should also be considered.
If the cash flow of the business, cash flow of the personal guarantors, or liquidity of the business or personal guarantors are determined to be sufficient to make ongoing loan payments, no additional alterations should need to be done to the loan agreement and repayment schedule.
If the cash flow of the business, cash flow of the personal guarantors, or liquidity of the business or personal guarantors is determined to be insufficient to continue with the current debt repayment schedule, further action should be taken.
Hold monthly meetings with management
Attend meetings of the board of directors
Default Loans: Any loan that is in arrears up to 90 days is considered to be a defaulted loan. Late penalty requirements will follow what is stated in the promissory note and/or loan agreement. Under default all loan proceeds must be immediately repaid or default proceedings will be initiated.
Security items will be sold, and proceeds used to recover loan amounts outstanding, legal fees, and other costs of recovery.
If a loan should become delinquent, the following procedures will occur: Telephone contact will be made 10 days after the due date.
First notice of delinquent payment will be sent 15 days after the due date.
Second notice will be sent 30 days after the due date.
Third notice will be sent 60 days after the due date.
Fourth notice will be sent 75 days after the due date. A certified, return receipt notice will be sent. During the first 75 days of delinquency, written and oral communication, as well as site visits, will be utilized to resolve the delinquency. Every effort will be made through personal contact to resolve the delinquency.
After 90 days of delinquency, a loan due demand notice will be sent by legal counsel. If after 90 days a delinquency still exists, and the loan has not been renegotiated or brought current, the loan may be declared in default. NIRPC may immediately commence procedures to recover the borrower's security. No loan modification will be approved unless it can be demonstrated that modification will improve the borrower’s ability to repay the loan.
Any recipient proven guilty of discrimination in employment practices or determined to have used discriminatory practices in hiring shall be in default and subject to repay all loan funds immediately. Illegal business transactions or illegal business practices by the recipient may be cause for immediate recall of loan funds.
Restructuring of Loans: If the cash flow of the business is inadequate to make the scheduled payments, it may be necessary to alter the terms of the note in order to cure defaults. If there is no need to formally cure defaults, payment terms may be reached without amending the notes.
Restructuring of loans include but are not limited to interest rate amendments, maturity date extensions, or added balloon payment. The following steps can be taken into consideration:
Determine if the cash flow problem is a short-term issue or a long-term issue affecting the viability of the company. If it is determined that the cash flow issue is a long-term situation, liquidation of the collateral should be considered. If the issue is determined to be short-term in nature, loan modification is appropriate.
Determine a solution that best resolves the short-term cash flow situation. These solutions include but are not limited to the following:
Re-amortizing the note over a longer period of time to decrease the monthly payment amounts
Allowing a deferral of principal or principal and interest for a period of time to allow the borrower reprieve from payments. At the end of the deferral period, the note would be re-amortized over the original term of the note or over a longer term if deemed necessary for repayment
A reduction of interest rate can be considered, though this is unlikely to resolve a cash flow issue
If allowed in the original note, a default interest rate may be enforced during the loan modification
Once the appropriate course of action is determined, a modification of the note should be prepared and executed. All collateral documents, including mortgages, UCC filings, and personal guarantees should be extended to match the new maturity date, if applicable. A new amortization schedule for the note should be provided to the borrower.
The borrower should be required to submit quarterly financial statements so ongoing repayment ability can be monitored.
All loan modifications must be reviewed and approved by the LaPorte County RLF Managing Board. Terms and repayment schedules will be defined and agreed upon by the Board.
Economic Development Administration Reporting (Revised with EDA language)
NIRPC will comply with all EDA reporting requirements. As part of this reporting NIRPC will certify to EDA that the Regional RLF is operating in accordance with the applicable Regional RLF Management Plan.
Sections added by EDA:
Allowable Cash Percentage
Effective Jan. 2, 2018, EDA replaced the Capital Utilization Rate of 25 percent with region-specific Allowable Cash Percentage (ACP) that is updated annually. The ACP is the average cash available for RLFs in the Chicago EDA region and is used for risk rating RLFs according to the Risk Analysis System.
Lending activity will be managed so that the cash available for lending is less than the current ACP in effect for the Chicago Region. However, if the Cash Available for Lending is greater than 50% of the RLF Capital Base for 24 consecutive months, EDA may take action to disallow the persistent excess cash.
Audits
NIRPC is required to obtain an annual audit of its RLF program in accordance with 2 CFR Subpart F and the Compliance Supplement, which is appendix XI to 2 CFR part 200, as applicable.
NEW - Environmental Section
The RLF Administrator with the assistance of appropriate staff, shall assess the significance of all environmental impacts of activities to be financed in compliance with the National Environmental Policy Act of 1969 and other Federal environmental mandates, as per the Assurances (SF 424D as revised) executed with the Economic Development
Administration. No activity shall be financed which would result in a significant adverse environmental impact unless the impact is to be mitigated to the point of
insignificance. When necessary to ensure compliance, any required mitigation shall be made part of the loan conditions.
No project shall be approved which would result in the alteration of or have an adverse impact on any wetland without prior consultation with the U.S. Department of the Interior, Fish and Wildlife Service, and, if applicable, obtaining a section 404 permit from the Army Corps of Engineers.
Consistent with E.O. 11988, no project shall be approved which would result in new above ground development in a 100-year flood plain. This determination will be made by reviewing the proposed development against FEMA Flood Insurance Rate Maps.
The State Historic Preservation Officer, (SHPO) shall be notified of each loan proposal that involves significant new construction or expansion and asked to submit comments on the effect of the proposed activity on historic and archaeological resources. The RLF Administrator shall work with the SHPO and EDA in cases where the SHPO has recommended actions or has been determined an adverse impact.
All loan applicants shall be requested to provide information indicating whether or not there was hazardous materials such as EPA listed (see 40 CFR 300), hazard substances, leaking underground storage tanks, asbestos, polychlorinated biphenyls (PCB), or other hazardous materials on site that have been improperly handled and have the potential of endangering public health. If deemed necessary, loan applicants may be required to perform or provide evidence of a Phase I site assessment to identify possible sources of contamination, a Phase II site assessment to test soil and/or groundwater samples, and a Phase III site remediation involving mitigation of applicable contaminants. In cases where there are unresolved site contamination issues, the RLF Administrator shall work with the loan applicant and the appropriate state environmental agency office to resolve these outstanding issues.
5
A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION UPDATING THE MANAGEMENT PLAN FOR THE LAPORTE COUNTY REVOLVING LOAN FUND
Whereas, the Northwestern Indiana Regional Planning Commission (hereafter referred to as “The Commission”) operates a Revolving Loan Fund for La Porte County under the Economic Development Administration (EDA) of the U.S. Department of Commerce; and
Whereas, the Commission adopted certain updates to the Management Plan for the LaPorte County Revolving Loan Fund (hereafter referred to as “The LaPorte County RLF”) on May 19, 2016 in Resolution 16-19; and
Whereas, the Economic Development Administration (EDA) requires five-year updates to Management Plans for Revolving Loan Fund programs; and
Whereas, the LaPorte County RLF Board approved and adopted updates to the Plan at their meeting of February 3, 2021 by unanimous vote; and
Whereas, the EDA subsequently approved and accepted these updates to the Laporte County RLF Management Plan on February 12 , 2021;
Now, Therefore Be It Resolved that the Commission approves the required five-year update to the Management Plan for the LaPorte County Revolving Loan Fund, as attached to this resolution.
Duly adopted by the Northwestern Indiana Regional Planning Commission this 18th day of March 2021.
George Topoll Chairperson
ATTEST:
Richard Hardaway Secretary
TO: NIRPC Finance & Personnel Committee and NIRPC Executive Board FROM: Denarie Kane, Economic Development Specialist, NIRPC
RE: Recommendation and Approval of Amendments to the Regional Revolving Loan Fund Management Plan for Lake, Porter, and La Porte Counties
DATE: February 25, 2021
The Regional Revolving Loan Fund Management Plan for Lake, Porter, and La Porte Counties, approved on September 17, 2020, is in need of amendment related to the application fee charged loan applicants. On pages 16 and 17 is a section titled Fees. There are also references to specific fee amounts on page 24 under a section titled Submittal Requirements from Each Applicant, on page 25 under a section titled Loan Closing Schedule, Fund and Close of Loan, and on page 27 under a section titled Loan Disbursement.
The two sections under Fees which are requested to be amended are duplicated below and noted as Current Language. The $200 amount collected for the Loan Application Fee is insufficient to cover the cost of preparing the Credit Memorandum and obtaining the Credit Reports. Based on a contract pending with the Regional Development Company to provide these two required services, an increase in the Application Fee is proposed. The proposed Application Fee would be $450, and the proposed Closing Fee would therefore be $550. In total, a $1,000 sum will be collected in fees for approved loans which is the same $1,000 sum as is currently collected. The proposed amendment is shown below and noted as Proposed Language.
Fees (Current Language on pages 16 & 17)
Loan Application Fee: A non-refundable loan application fee of two hundred dollars ($200) will be charged to all loan applicants. If the loan is approved, the fee will be applied to the loan processing fee.
Closing Fee: Borrowers will pay NIRPC one thousand dollars ($1,000) at the time of closing to provide for certain administrative and legal fees associated with loan preparation and closing.
Fees (Proposed Language)
Loan Application Fee: A non-refundable loan application fee of four hundred and fifty dollars ($450) will be charged to all loan applicants. If the loan is approved, this $450 fee will be applied to the $1,000 in total fees collected which includes the closing fee.
Closing Fee: Borrowers will pay NIRPC five hundred and fifty dollars ($550) remaining of the total fee of one thousand dollars ($1,000) at the time of closing to provide for certain administrative and legal fees associated with loan preparation and closing.
On page 24 under Submittal Requirements from Each Applicant, the $200 amount is part of a bulleted submittal requirement that reads “Application with $200 application fee”. This bulleted submittal requirement is proposed to read “Application with application fee”.
In addition, the dollar amount in the last sentence under the Loan Closing Schedule, Fund and Close of Loan section needs to be amended to reflect an application fee of $450 and the remaining amount of
$550 owed as a closing fee.
This sentence on page 25 currently reads as follows:
The applicant, prior to receiving the loan check, is required to pay in full the $1,000 loan closing fee less the application fee of $200.
This sentence is proposed to read as follows:
The applicant, prior to receiving the loan check, is required to pay in full the $550 loan closing fee.
Lastly, the dollar amount in the last sentence under the Loan Disbursement section needs to be amended to reflect the closing fee of $550.
This sentence on page 27 currently reads as follows:
The applicant must pay in full the $1,000 closing fee prior to the disbursement of any funds.
This sentence is proposed to read as follows:
The applicant must pay in full the $550 closing fee prior to the disbursement of any funds.
Upon inquiry made by EDD staff on February 11, 2021, the Economic Development Administration has informed NIRPC that loan application fee amounts are not within their purview. Therefore, the following items are requested to be approved by NIRPC’s Finance and Personnel Committee in accordance with their responsibilities outlined in the Regional RLF Management Plan for Lake, Porter, and La Porte Counties on page 21 :
Approve the amendment to the Fee section as proposed (pages 16 & 17).
Approve the amendment to the Submittal Requirements from Each Applicant section as proposed (page 24).
Approve the amendment to the Loan Closing Schedule, Fund and Close of Loan section as proposed (page 25).
Approve the amendment to the Loan Disbursement section as proposed (page 27).
Furthermore, a request is made for the Finance and Personnel Committee to recommend that NIRPC’s Executive Board, acting on behalf of the Commission, also approve these amendments and adopt Resolution #21-04. Thank you.
A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION AMENDING THE FEES IN THE MANAGEMENT PLAN FOR THE REGIONAL REVOLVING LOAN FUND FOR LAKE, PORTER, AND LA PORTE COUNTIES
Whereas, the Northwestern Indiana Regional Planning Commission (hereafter referred to as “The Commission”) operates a Regional Revolving Loan Fund for Lake, Porter, and La Porte Counties under the Economic Development Administration (EDA) of the U.S. Department of Commerce; and
Whereas, the Commission adopted a Management Plan (hereafter referred to as “The Plan”) for the Regional Revolving Loan Fund for Lake, Porter, and La Porte Counties on September 17, 2020, in Resolution 20-26; and
Whereas, the existing $200 application fee in the Plan was recommended to be increased to
$450 so there are sufficient dollars available to cover the costs of certain contracted services necessary to evaluate loan requests and the credit worthiness of the applicants; and
Whereas, the total amount of fees paid by an applicant for an approved loan will remain at
$1,000 with the balance of $550 paid at the time of loan closing prior to the disbursement of any loan funds; and
Whereas, the EDA advised Economic Development District staff on February 11, 2021, that the EDA does not regulate loan application fees so the EDA’s approval of the proposed fee amendments to the Plan is not required; and
Whereas, the Finance and Personnel Committee approved and adopted various amendments to the Plan related to the recommended increase in the application fee at their meeting of March 18, 2021, by unanimous vote; and
Now, Therefore Be It Resolved that the Commission approves the amended Management Plan for the Regional Revolving Loan Fund for Lake, Porter, and La Porte Counties as attached to this resolution.
Duly adopted by the Northwestern Indiana Regional Planning Commission this 18th day of March 2021.
ATTEST: George Topoll
Chairperson
Richard Hardaway
