FINANCE AND PERSONNEL COMMITTEE
Meeting Agenda
Thursday, January 21, 2021 -- 8:00 a.m.
Zoom: Join HERE 1-312-626-6799
Meeting ID: 912 3224 9318 Passcode: 183340
Call to Order
6100 Southport Road
Portage, Indiana 46368
(219) 763-6060
Meeting Minutes of November 19, 2020 Pages 1-3
Review of Financial Status – November 2020 Pages 4-12
Bank Statement Reconciliation
General Fund Expenses YTD November 2020 – Budget vs Actual
General Fund Revenue YTD November 2020 – Budget vs Actual
CARES Expenses YTD November 2020 - Budget to Actual
CARES Revenue YTD November 2020 - Budget to Actual
Approval of General Fund Claims Register – November 2020 Pages 13-15
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register - November 2020 Pages 16
ACTION REQUESTED: Approval
December Bank Statement Reconciliation Pages 17-20
Approval of General Fund Claims Register – December 2020 Pages 21-23
ACTION REQUESTED: Approval
Approval of CARES Act Claims Register - December 2020 Pages 24
ACTION REQUESTED: Approval
Procurement #21-01 Pages 25
ACTION REQUESTED: Recommendation
CARES RLF Loan Committee Member Appointments Pages 26-28
ACTION REQUESTED: Approval
Kankakee River Basin and Yellow River Basin Development Commission Pages 29-31 support agreement
Personnel update
Other Business
Adjournment
The next meeting is scheduled for March 18, 2020 at 8:00 a.m.
The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program. Users may access the Relay Indiana Service by calling 711 or 1-800-743-3333. Requests for alternative formats may be made 72 hours in advance by contacting nirpc@nirpc.org.
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE
November 19, 2020 / Zoom Virtual Meeting – 8:00 a.m.
Members Present
Richard Hardaway, Jan Bapst, Bob Carnahan, Justin Kiel, George Topoll, John Yelkich Staff and Others Present
Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Stephanie Kuziela, Meredith Stilwell, David Hollenbeck
Call to Order
Richard Hardaway called the meeting to order with the Pledge of Allegiance.
Approval of Minutes
The minutes of the October 15, 2020 meeting were presented. Jan Bapst made motion and George Topoll seconded to approve the minutes.
Review of Financial Status – October 2020
Talaya Jones presented the October 2020 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account. The general account beginning balance from 10/1/2020 was
$1,312,796.77 with a closing balance of $1,048,472.95 as of 10/31/2020. The RLF account beginning balance from 9/1/2020 was $142,024.84 with a closing balance of $149,906.07 as of 10/31/2020.
Talaya presented the financial status report for category expenditures year to date, October 2020.
$1,017,467 has been expended of the $1,293,260 Salaries budget. $395,592 has been expended of the
$509,690 Fringe Benefits budget. $226,287 has been expended of the $280,297 Occupancy budget.
$55,264 has been expended of the $78,840 Maintenance budget. $77,964 has been expended of the
$196,750 Departmental budget. $339,077 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,118,387 of the $3,343,302 budgeted. $200 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. Year to date, total expenditures of $6,358,418 of the $10,258,326 budgeted, $3,899,908 under budget.
Talaya presented the year-to-date October 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 Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual expenditures year to date, October 2020. Per the State Board of Accounts, the CARES Act and general funds must be reported separately. $47,819 of the $236,733 has been expended of the Salaries budget. $0 of
$5,000 contractual, RLF Services budget has been expended. $15,532 of the $25,000 departmental, PPE Supplies, budget has been expended. $2,160 of the $165,000 Capital Outlays, Furniture and Equipment, budget has been expended. Total NIRPC CARES Fund Expenditures of $65,511 had been expended from the $431,733 budget. $0 of the $583,000 CARES Revolving Loan Fund budget has been expended.
$30,825 of the $1,219,972 CARES Transit Capital Fund budget has been expended. $1,092,610 of the
$4,314,322 CARES Agency Fund has been expended. Total expenditures were $1,188,946 of the
$6,549,027 budgeted.
Talaya presented the year-to-date October 2020 budget vs. actual revenue report. $366,669 of the
$540,271 county appropriations budget has been collected. $184,337 of the $539,733 federal agencies budget has been collected. $1,337,675 of the $1,935,395 state agencies budget has been collected.
$24,224 of the $44,694 local agencies budget has been collected. $11,051 of the $135,318 non- governmental funds budget has been collected. $13,288 of the $70,000 Economic Development District budget has been collected. $8,391 of the $9,682 interest income budget has been collected.
Talaya presented the year-to-date revenue by funding source chart as of October 31. 69% of collected revenue
has been from state agencies, 19% 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 revenue year to date, October 2020. All revenue is federal and is classified as Economic Development District or FTA.
$172,446 has been collected of the $604,229 total CARES Act revenue budget. The State quarterly reimbursement has not been received yet and some money collected is not recognized yet because the programs have not started yet.
Approval of Claims Register – October 2020
Talaya first presented the October 2020 regular claims register totaling $611,057.94 to the Committee for approval. Bob Carnahan made motion and Jan Bapst seconded to approve the October 2020 regular claims register. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0. The CARES Act expenditures register of claims totaling $25,171.25 was then presented for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the October 2020 CARES Act claims register. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.
Executive Director Contract – 2021 Employee Agreement Addendum
This agreement was signed in 2018 and provides that Ty meets with the NIRPC chair for a review of performance and expectation of goals, with the Chairman then making a recommendation for salary for each calendar year. The recommended increase for 2021 is 3%. NIRPC is incorporating a 3% increase for all employees for 2021 as well. This addendum, which only addresses compensation, to be extended into the third and final contract year must go before the NIRPC Full Commission to be approved upon recommendation from the Finance and Personnel Committee. Justin Kiel questioned if last year’s increase was 3% and it was noted that it was 4.5%. Jan Bapst made motion and Justin Kiel seconded to recommend the addendum to the Executive Director Contract for a salary increase of 3% for 2021 to the NIRPC Full Commission for approval. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.
NIRPC Budget – Calendar Year 2021 – NIRPC Resolution #20-29
Talaya presented and explained the finalized 2021 budget, noting changes from the preliminary budget presented at the September 2020 meeting. When the budget for CY 2021 CARES ACT 2020 Transit Capital Projects Fund, which are 100% funds, with no match, was presented Jan Bapst questioned why the City of Gary was not on the list and it was explained that GPTC and Michigan City are direct recipients and are not NIRPC subrecipients. Justin Kiel asked how the capital projects fit into CARES ACT funds and Ty Warner explained that the FTA rational was that transit would be hit hard overall and did not restrict the expenditure of the funds. Jan Bapst made motion and Justin Kiel seconded to approve the budget as presented with recommendation to the NIRPC Full Commission for approval. A roll call vote was taken with Jan Bapst, Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 5-0.
Vehicle Disposition Sales
Lisa Todd presented information regarding 2 vehicles disposition sales, one held at NIRPC on November 18 and one to be held at East Chicago Transit on November 19. The vehicles have met what is considered their useful life by FTA requirements in number of miles or years. The sales were both advertised. All 14 vehicles at the sales located at NIRPC were sold and the bid opening was livestreamed and recorded.
Personnel updates
Meredith Stilwell reported that the 2 open EDA CARES ACT funded positions for a Communications Specialist and Economic Development Specialist have bene filled. The new Communications Specialist, Lucas Ecklund- Baker, started November 9 and the new Economic Development Specialist, Denarie Kane, will be starting on November 23.
Other Business
Bob Carnahan reported that Cedar Lake purchased 5 ultraviolet sanitizers with CRES ACT money. They were
$3,500 each and can be set for a timing period to sanitize rooms.
Adjournment
There being no further business, the meeting was adjourned.
32 | Deposits and Other Additions Totaling................................................. ..................... | 1,560,973.03 | |
108 | Checks and Other Withdrawls Totaling.................................................................. ... | 1,437,341.01 | |
0 | Adjustments | 0.00 | |
Voids | 3,599.00 | ||
Service | 11/10/2020 | 95.92 | |
Interest | 11/30/2020 | 94.38 | |
Closing Balance for this Statement.................................................................................................. | 11/30/2020 | 1,195,830.97 | |
Difference............................................................................. .................................. | 0.00 | ||
Cash Balance from General | 11/30/2020 | 1,190,240.13 | |
Open Activity from Bank Register..................... ........................................................ | (5,590.84) | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement.............................................................................................. | 1,195,830.97 | ||
Date Reference Deposit Description | Amount | ||
8/08/2019 8272335 1/2 August 2019 RLF payment | -269.64 |
Total Unmarked Deposits: | -269.64 | Total Deposits: | -269.64 | |
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 | B/5 - 8/18/2019 pay period - United Way | 33.85 | |
2/25/2020 0002572 Ecointeractive , Inc . 4/09/2020 0002545 Anthem Life | TIP SAAS SERVICE- monthly srvc fee ending 2/29/20 Life Ins for April 2020 | 3,750.00 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 | ||
Total Unmarked Checks: | 5,321.20 | Total Checks: | 5,321.20 |
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 12/22/2020@ 8:55 AM
Reconciliation - General
/s1( IJ/JJ IJo
I
I
Page:
Closing Balance from Previous Statement............................... ............ ...................................... ..........
10/31/2020
12/30/2020
1,068,601.49
Trial Balance - Cash
Run: 1212212020 at 9:3:/,1.QRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 11/30/2020
Page: 1
All
1.1.001.0000.1010.0 Cash
Total
Balance
1,190,240.13
1,190,240.13
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 12/22/2020@ 9:36 AM
Reconciliation - Revolving Loan Fund
Page:
Closing Balance from Previous Statement...........................................................................................
10/31/2020
149,906.07
7 | Deposits and Other Additions Totaling..................................................................... | 5,178.31 | |
O | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
0 | Adjustments Totaling.............................................................................................. | 0.00 | |
0 | Voids | 0.00 | |
Service | 0.00 | ||
Interest | 11/30/2020 | 8.87 | |
Closing Balance for this Statement..................................................................................................... | 11/30/2020 | 155,093.25 | |
Difference.................... ........................................................................................... | 0.00 | ||
Cash Balance from General Ledger.................................................................................................... | 11/30/2020 | 155,093.25 | |
Open Activity from Bank Register............................................................................. | 0.00 | ||
Adjustment for Service Charges and Interest............................................................. | 0.00 | ||
General Ledger Reconciliation to Statement............................................................................................. | 155,093.25 |
\J.
/s l)aJ/Jo
Trial Balance - Cash
Run: 1212212020 at 9:3!NQRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 11/30/2020
Page: 1
All
2.3.050.0000.1010.0 Cash
Total
Balance 155,093.25
155,093.25
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020 |
Line Items | FY 2020 Budget | FY 20 YTD November YTD Variance YTD % Budget % Expended (Over)/Under Variance balance |
Salaries | ||||||
5020-1 | Total Salaries | 1,293,260 | 1,105,540 | 79,949 | 7% | 15% |
Salaries Sub-Total | 1,293,260 | 1,105,540 | 79,949 | 7% | 15% |
Fringe Benefits | ||||||
5121-9 | FICA Contributions | 104,321 | 86,018 | 9,610 | 10% | 18% |
5122-9 | Workers Compensation | 6,100 | 2,950 | 2,642 | 47% | 52% |
5123-9 | Unemployment Compensation | 1,650 | 1,092 | 421 | 28% | 34% |
5141-9 | PERF Contributions | 159,118 | 145,284 | 574 | 0% | 9% |
5142-9 | Health Insurance | 170,501 | 151,872 | 4,421 | 3% | 11% |
5143-9 | Life & Disability Insurance | 23,000 | 16,535 | 4,548 | 22% | 28% |
5145-9 | ICMA | 25,000 | 19,108 | 3,808 | 17% | 24% |
5146-9 | Staff Development | 20,000 | 4,149 | 14,184 | 77% | 79% |
Fringe Benefits Sub-Total | 509,690 | 427,008 | 40,208 | 9% | 16% |
Occupancy | ||||||
5221-9 | Office Lease | 225,500 | 206,527 | 181 | 0% | 8% |
5222-9 | Property Insurance | 6,500 | 4,901 | 1,058 | 18% | 25% |
5223-9 | Building Maintenance | 18,540 | 16,722 | 273 | 2% | 10% |
5224-9 | Utilities | 29,757 | 20,377 | 6,900 | 25% | 32% |
Occupancy Sub-Total | 280,297 | 248,527 | 8,412 | 3% | 11% |
Maintenance | ||||||
5241-9 | Copier Leasing/Maintenance | 19,400 | 3,581 | 14,203 | 80% | 0% |
5243-9 | Computer Service/Maintenance | 40,440 | 41,238 | (4,168) | -11% | 0% |
5244-9 | Telephone Service/Maintenance | 18,000 | 10,472 | 6,028 | 37% | 0% |
Combined Copier/IT/Phone Service/Maintenance | 77,840 | 55,290 | 16,063 | 23% | 29% | |
5249-9 | Other Equipment Maintenance | 1,000 | 364 | 553 | 60% | 64% |
Maintenance Sub-Total | 78,840 | 55,654 | 16,616 | 23% | 29% | |
Departmental | ||||||
5410-1 | Communications: Commission/Ex. Dir. | 41,500 | 11,280 | 26,762 | 70% | 73% |
5410-2 | Communications: Transportation | 60,000 | 16,761 | 38,239 | 70% | 72% |
5410-4 | Communications: Subgrantee Management | 15,000 | 260 | 13,490 | 98% | 98% |
5410-5 | Communications: Environmental Programs | 28,650 | 16,516 | 9,746 | 37% | 42% |
5410-8 | Communications: Partner Agency | 1,000 | 716 | 201 | 22% | 28% |
5410-9 | Communications: Allocated Functions | 28,000 | 16,836 | 8,830 | 34% | 40% |
5420-5 | Promotional Expenses: Environmental Programs | 15,600 | 17,405 | (3,105) | -22% | -12% |
5430-9 | General Use Supplies Expense | 7,000 | 1,066 | 5,350 | 83% | 85% |
Departmental Sub-Total | 196,750 | 80,839 | 99,515 | 55% | 59% |
Contractual | ||||||
5602-9 | Legal Services | 19,800 | 18,150 | 0 | 0% | 8% |
5603-9 | Audit and Accounting | 69,000 | 33,065 | 30,185 | 48% | 52% |
5604-9 | LaPorte RLF Services | 2,000 | 0 | 1,833 | 100% | 100% |
5610-4 | Transit Oversight | 11,300 | 600 | 9,758 | 94% | 95% |
5610-5 | Environmental Projects | 522,374 | 259,103 | 219,740 | 46% | 50% |
5610-5 | Alternative Fuel | 70,991 | 0 | 65,075 | 100% | 100% |
5619-9 | Organizational Dev. | 2,000 | 0 | 1,833 | 100% | 100% |
5610-0 | Board Development | 2,000 | 0 | 1,833 | 100% | 100% |
5610-2 | E-Tip | 45,000 | 48,750 | (7,500) | -18% | -8% |
Economic Development District | 140,000 | 0 | 128,333 | 100% | 100% | |
Contractual Sub-Total | 884,465 | 359,668 | 451,091 | 56% | 59% |
Capital Outlays | ||||||
5910-0 | Furniture and Equipment | 100,000 | 6,736 | 84,930 | 93% | 93% |
Capital Outlays Sub-Total | 100,000 | 6,736 | 84,930 | 93% | 93% |
TOTAL GENERAL FUND EXPENDITURES | 3,343,302 | 2,283,972 780,721 | 25% 32% |
LaPorte Revolving Loan Fund | 85,000 | 400 |
Transit Capital Fund | 2,440,988 | 2,614,854 |
2019 Transit Operating Fund TOTAL EXPENDITURES | 4,389,036 1,688,483 10,258,326 6,587,709 |
84,600
100%
(173,866)
-7%
2,700,553
62%
3,670,617
36%
1,185,488 | ||
1,000,000 | 1,105,540 | |
800,000 | ||
600,000 | ||
400,000 | ||
200,000 | ||
- |
CARES FUND EXPENDITURES
810,760
467,216
427,008
359,668
256,939 248,527
180,354
72,270
55,654
80,839
SALARIES
FRINGE BENEFITS
OCCUPANCY
MAINTENANCE
DEPARTMENTAL
CONTRACTUALS
YTD November Budget YTD November Expended
16%
4%
2%
48%
11%
19%
Salaries
Fringe Benefits Occupancy Maintenance Departmental
Contractuals
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020 |
1% 1%
1%
0%
18%
9%
70%
County Appropriations
Federal Agencies State Agencies Local Agencies
Non-Governmental
Economic Development District Interest Income
FY 20
Line Items | FY 2020 Budget | YTD November YTD Variance YTD % Budget % Collected (Under)/Over Variance balance |
GENERAL FUND REVENUE |
1.1.4110 | County Appropriations | 540,271 | 366,669 | 366,669 | 0% | 32% |
1.1.4210 | Federal Agencies | 539,733 | 189,348 | (260,429) | -58% | 65% |
1.1.4310 | State Agencies | 1,935,395 | 1,414,667 | (198,162) | -12% | 27% |
1.1.4410 | Local Agencies | 44,694 | 24,286 | (12,959) | -35% | 46% |
1.1.4610 | Non-Governmental | 135,318 | 11,126 | (101,639) | -90% | 92% |
1.3.4260 | Economic Development District | 70,000 | 13,288 | (45,046) | -77% | 81% |
1.1.4800 | Interest Income | 9,862 | 9,299 | 1,081 | 13% | 6% |
Revenue Total | 3,275,273 | 2,028,683 | (250,485) | -11% | 38% |
BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020 |
Line Items | FY 2020 Budget | YTD November Expended | FY 20 Budget % balance |
NIRPC CARES EXPENDITURES | |||
Salaries | |||
Salaries-FTA | 236,733 | 57,543 | 76% |
Salaries-CARES EDD | 3,213 | ||
Salaries Sub-Total | 236,733 | 60,756 | 76% |
Contractual | |||
RLF Services | 5,000 | - | 100% |
Contractual Sub-Total | 5,000 | - | 100% |
Departmental | |||
Communications | 500 | 103 | 79% |
PPE Supplies & Office Supplies | 25,000 | 15,469 | 38% |
Departmental Sub-Total | 25,000 | 15,572 | 38% |
Capital Outlays |
Furniture and Equipment | 165,000 | 2,544 | 98% |
Capital Outlays Sub-Total | 165,000 | 2,544 | 98% |
TOTAL NIRPC CARES FUND EXPENDITURES | 431,733 | 78,872 | 82% |
CARES Revolving Loan Fund | 583,000 | - |
CARES Transit Capital Fund | 1,219,972 | 137,057 |
CARES Transit Agency Fund | 4,314,322 | 2,171,324 |
TOTAL EXPENDITURES | 6,549,027 | 2,387,253 |
250,000
YTD November 2020 Expenses Budget vs Actual
236,733
200,000
165,000
150,000
100,000
57,543
50,000
25,000 15,572
-
3,213
5,000
-
2,544
-
SALARIES-FTA
SALARIES-CARES
EDD
CONTRACTURAL
DEPARTMENTAL CAPITAL OUTLAYS
Budget Expended
BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH NOVEMBER 30, 2020 |
Line Items | FY 2020 Budget | YTD November Collected | FY 20 Budget % balance | |
CARES ACT FTA Revenue | ||||
Operating Revenue | 419,386 | 268,895 | 36% | |
Capital Revenue | 125,000 | 0 | 100% | |
CARES ACT EDA | Economic Development District | 59,843 | 0 | 100% |
Revenue Total | 604,229 | 268,895 | 55% |
Revenue by Funding Source as of November 30, 2020
0%
100%
CARES
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 | ||
11/3/2020 | Payroll | $ 34,563.55 | $ 34,563.55 | Payroll 10/25/2020 | |||||
11/3/2020 | 3946 | DeLage Landen Fin. Serv. | General 5243.9 | Fund | $ 3,538.44 | $ 3,538.44 | C3946 | IT/Telephone/Copier Services | |
11/3/2020 | 3946 | DeLage Landen Fin. Serv. | General 5244.9 | Fund | $ 741.83 | $ 741.83 | C3946 | IT/Telephone/Copier Services | |
11/3/2020 | 3946 | DeLage Landen Fin. Serv. | General 5241.9 | Fund | $ 842.74 | $ 842.74 | C3946 | IT/Telephone/Copier Services | |
11/3/2020 | B-4807 | Federal & Fica | General 2140.0 | Fund | $ 4,486.15 | $ 4,486.15 | C4807 | 10/12-10/25/2020 pay period- FWT,empfica, empficamed - Federal Tax Withholdings payable | |
11/3/2020 | B-4807 | Federal & Fica | General 2142.0 | Fund | $ 6,908.46 | $ 6,908.46 | C4807 | 10/12-10/25/2020 pay period- FWT,empfica, empficamed FICA tax Withholdings Payable | |
11/3/2020 | B-4810 | Horizon Bank | General 2150.0 | Fund | $ 395.38 | $ 395.38 | C4810 | 10/12-10/25/2020 pay period -HSA | |
11/3/2020 | 4002 | United HealthCare Srvcs, Inc | General 5142.9 | Fund | $ 8,001.49 | $ 8,001.49 | C4002 | ER paid Insurance NOV | |
11/3/2020 | 4002 | United HealthCare Srvcs, Inc | General 2152.0 | Fund | $ 1,514.42 | $ 1,514.42 | C4002 | EE w/h's Insurance NOV | |
11/4/2020 | 3976 | Accufund | General 5146.9 | Fund | $ 199.00 | $ 199.00 | 2679 | Training Accounts Payable- Marisol Manley | |
11/4/2020 | 3975 | Accufund | General 5146.9 | Fund | $ 199.00 | $ 199.00 | 2679 | Training Accounts Receivable - Stephanie Kuziela | |
11/4/2020 | 3929 | Adams Radio Group | General 5610.0 | Fund | $ 3,710.00 | $ 3,710.00 | 2680 | Live Radio Remote-Air Quality Gas Can Excahnge at the Porter County Household Hazardous Waste Collection Event | |
11/4/2020 | 3848 | American Management Association | General 5410.9 | Fund | $ 2,445.00 | $ 2,445.00 | 2681 | Meeting/Training: How to Communicate with Diplomacy | |
11/4/2020 | 3973 | Anthem Life | General 5143.9 | Fund | $ 458.40 | $ 458.40 | 2682 | Life Insurance | NOV |
11/4/2020 | 3964 | Blachly, Tabor, Bozik & Hartman, LLC | General 5602.9 | Fund | $ 1,650.00 | $ 1,650.00 | 2685 | Legal - NOV | |
11/4/2020 | 3965 | City of Portage | General 5221.9 | Fund | $ 18,775.18 | $ 18,775.18 | 2684 | Lease- NOV | |
11/4/2020 | 3974 | City of Portage | General 5224.9 | Fund | $ 1,965.92 | $ 1,965.92 | 2684 | Sewer/Water/Gas Electric Service-OCT | |
11/4/2020 | 3977 | Fidelity EyeMed | General 2154.0 | Fund | $ 70.91 | $ 70.91 | C3977 | Vision Insurance - NOV | |
11/4/2020 | 3963 | Health Resources | General 2153.0 | Fund | $ 719.94 | $ 719.94 | 2685 | Dental Insurance - NOV | |
11/4/2020 | B-4809 | INPRS | General | Fund | $ 5,803.18 | $ 5,803.18 | C4809 | 10/12/2020-10/25/2020 pay period - EmpPerf [NIRPC] | |
11/4/2020 | 3971 | INPRS | General | Fund | $ (0.01) | $ (0.01) | C3971 | Rounding Adjustment 10/12 thru 10/25/2020- p/r | |
11/4/2020 | 3962 | Kansas City Life | General 5143.9 | Fund | $ 878.24 | $ 878.24 | 2687 | Life Insurance - Disability- NOV | |
11/4/2020 | 3958 | Pulse Technology | General 5430.9 | Fund | $ 49.49 | $ 49.49 | 2689 | Office Supplies- Binders | |
11/4/2020 | 3979 | Porter County Soil & Water Conservation District | General 5610.5 | Fund | $ 3,980.98 | $ 3,980.98 | 2688 | Contractual -Lake Michigan Coastal Grants Program/Match | |
11/4/2020 | 3907 | Purdue University Northwest NWI SBDC | General 5899.7 | Fund | $ 200.00 | $ 200.00 | 2690 | Technical Assistance for credit analysis - LaPorte | |
11/4/2020 | B-4812 | United Way of Porter County | General 2147.0 | Fund | $ 33.85 | $ 33.85 | 2691 | 10/12-10/25/2020- pay period- United Way |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
11/5/2020 | B-4786 | IN Dept of Revenue | General Fund 2143.0 | $ 1,429.02 | $ 1,429.02 | C4786 | 9/28-10/11/2020 pay period -LwtIN, SwtIN |
11/5/2020 | B-4786 | IN Dept of Revenue | General Fund 2144.0 | $ 312.58 | $ 312.58 | C4786 | 9/28-10/11/2020 pay period -LwtIN, SwtIN |
11/5/2020 | B-4765 | IN Dept of Revenue | General Fund 2143.0 | $ 1,428.37 | $ 1,428.37 | C4765 | 9/14-9/27/2020 pay period - LwtIN, SwtIN- State Tax Withholdings Payable |
11/5/2020 | B-4765 | IN Dept of Revenue | General Fund 2144.0 | $ 312.48 | $ 312.48 | C4765 | 9/14-9/27/2020 pay period -LwtIN, SwtIN- Loal Tax Withholdings Payable |
11/5/2020 | B-4762 | IN Dept of Revenue | General Fund 2143.0 | $ 132.22 | $ 132.22 | C4762 | Winters vacation payout - LwtIN, SwtIN- State Tax Wtihholdings Payable |
11/5/2020 | B-4762 | IN Dept of Revenue | General Fund 2144.0 | $ 20.47 | $ 20.47 | C4762 | Winters vacation payout - LwtIN, SwtIN- Local Tax Wtihholdings Payable |
11/5/2020 | 3980 | Total Disposal | General Fund 5223.9 | $ 74.00 | $ 74.00 | C3980 | Recycle/Trash - NOV |
11/6/2020 | 3981 | Comcast | General Fund 5244.9 | $ 139.64 | $ 139.64 | C3981 | Comcast Business- NOV |
11/6/2020 | 3998 | Warner, Ty | General Fund 5244.9 | $ 125.00 | $ 125.00 | C3998 | Communication Expense - NOV |
11/9/2020 | B-4811 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 805.00 | $ 805.00 | C4811 | 10/12-10/25/2020 pay period - ICMA |
11/9/2020 | 3970 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 832.41 | $ 832.41 | C3970 | ER paid for Ty Warner 10/12-thru10/25/2020 - p/r |
11/10/2020 | Account Service Fee | General Fund | $ 95.92 | $ 95.92 | Horizon bank service fee | ||
11/10/2020 | 3914 | Amazon | General Fund 5430.9 | $ 49.98 | $ 49.98 | C3914 | Logitech USB Headset w/noise cancelling mic |
11/10/2020 | 3914 | Amazon | General Fund 5430.9 | $ 14.58 | $ 14.58 | C3914 | DYMO Authentic LW mailing address labels |
11/10/2020 | 3969 | Amazon | General Fund 5410.5 | $ 72.75 | $ 72.75 | C3969 | USB 3.0 flash Drive 64GB |
11/10/2020 | 3967 | Chicago Tribune | General Fund 5410.0 | $ 27.72 | $ 27.72 | CC3967 | News Paper Subscription -NOV |
11/10/2020 | 3997 | SQUARESPACE | General Fund 5410.1 | $ 216.00 | $ 216.00 | C3997 | Annually Subscription- Business website |
11/10/2020 | 3968 | Stamps.com | General Fund 5249.9 | $ 100.00 | $ 100.00 | C3968 | Stamps.com |
11/10/2020 | 3966 | Stamps.com | General Fund 5249.9 | $ 24.99 | $ 24.99 | CC3966 | Stamps.com |
11/10/2020 | 3927 | Survey Monkey | General Fund 5910.0 | $ 384.00 | $ 384.00 | C3927 | One Year Renewal Survey Monkey Subscription |
11/16/2020 | 4001 | Bryco | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 2692 | Office Cleaning- NOV |
11/16/2020 | B-4846 | United Way of Porter County | General Fund 2147.0 | $ 33.85 | $ 33.85 | 2695 | 10/26-11/8/2020 PAY PERIOD- UNITED WAY |
11/17/2020 | Payroll | $ 34,026.31 | $ 34,026.31 | Payroll 11/08/2020 | |||
11/17/2020 | 4006 | Ecointeractive | General Fund 5610.2 | $ 3,750.00 | $ 3,750.00 | C4006 | TIP SAAS Service- NOV |
11/17/2020 | 4003 | Ecointeractive | General Fund 5610.2 | $ 3,750.00 | $ 3,750.00 | C4003 | TIP SAAS Service |
11/17/2020 | 4004 | Ecointeractive | General Fund 5610.2 | $ 3,750.00 | $ 3,750.00 | C4004 | TIP SAAS Service |
11/17/2020 | B-4841 | Federal & Fica | General Fund 2140.0 | $ 4,403.09 | $ 4,403.09 | C4841 | 10/26-11/8/2020 pay period- FWT, empfica, empficamed Federal Tax Withholddings |
11/17/2020 | B-4841 | Federal & Fica | General Fund 2142.0 | $ 6,802.56 | $ 6,802.56 | C4841 | 10/26 -11/18/2020 pay period-FWT, empfica, empficamed FICA Tax Withhldings |
11/17/2020 | B-4844 | Horizon Bank | General Fund 2150.0 | $ 395.38 | $ 395.38 | C4844 | 10/26-11/08/2020 pay period HAS |
11/17/2020 | 4005 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 832.41 | $ 832.41 | C4005 | ER paid for Ty Warner 10/26-thru11/082020 - p/r |
11/17/2020 | B-4845 | ICMA Retirement Fund-PR | General Fund 2146.0 | $ 805.00 | $ 805.00 | C4845 | 10/26-11/08/2020 pay period- HSA |
11/18/2020 | B-4843 | INPRS | General Fund 2149.0 | $ 5,704.89 | $ 5,704.89 | C4843 | 10/26-11/08/2020 pay period - EmpPerf [NIRPC] |
11/23/2020 | 4010 | Porter County Aging and Community Services | General Fund 5760.0 | $ 22,492.00 | $ 22,492.00 | C4010 | 3rd Quarter PMTF Reimbursement |
11/23/2020 | 4011 | South Lake County community Services | General Fund 5760.0 | $ 41,014.00 | $ 41,014.00 | C4011 | 3rd Quarter PMTF Reimbursement |
General Fund | $ - | ||||||
General Fund | $ - |
Total: | $ 237,913.16 |
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: | $ 237,913.16 |
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 |
11/4/2020 | 3939 | Kabelin Commerical Supply | General Fund 5960.0 | $ 479.88 | $ 479.88 | 2686 | Kombi Motor/Blower Attach/Head Trimmer |
11/5/2020 | 3956 | City of Valpo | General Fund 5960.0 | $ 96,043.22 | $ 96,043.22 | C3956 | Valpo Dash & V-Line Facility /Mobilization and Demobilization |
11/10/2020 | 3936 | Northern Tool & Equipment | General Fund 5960.0 | $ 444.99 | $ 444.99 | C3936 | Strongway 20-Ton Hydraulic Shop Press |
11/10/2020 | 3937 | Northern Tool & Equipment | General Fund 5960.0 | $ 3,599.99 | $ 3,599.99 | C3937 | Northstar hot water pressure washer with wet steam |
11/16/2020 | 3983 | SLCCS | General Fund 5960.0 | $ 1,062.00 | $ 1,062.00 | 2694 | RouteMatch SLCCS - NOV |
11/16/2020 | 3983 | NT | General Fund 5960.0 | $ 531.00 | $ 531.00 | 2694 | RouteMatch NT- NOV |
11/16/2020 | 3983 | PCACS | General Fund 5960.0 | $ 472.00 | $ 472.00 | 2694 | RouteMatch PCACS- NOV |
11/16/2020 | 3960 | Pulse Technology | General Fund 5430.9 | $ 39.99 | $ 39.99 | 2693 | Office Supplies-Lysol |
11/20/2020 | 3984 | Opportunity Enterprises | General Fund 5760.0 | $ 121,653.00 | $ 121,653.00 | C3984 | OE Reimb for OA Jul-Sept 2020 Draw 34- CARES20 |
11/20/2020 | 3985 | East Chicago Transit | General Fund 5760.0 | $ 54,323.00 | $ 54,323.00 | C3985 | ECT Reimb for PM Jul- Sept 2020 Draw 33- CARES20 |
11/20/2020 | 3986 | East Chicago Transit | General Fund 5760.0 | $ 62,299.00 | $ 62,299.00 | C3986 | ECT Reimb for Paratransit Jul-Sept 2020 Draw32-CARES20 |
11/20/2020 | 3987 | City of Valpo | General Fund 5760.0 | $ 95,105.00 | $ 95,105.00 | C3987 | Valpo Reimb for CCC Jul-Sept 2020 Dash Draw 31-CARES20 |
11/20/2020 | 3988 | City of Valpo | General Fund 5760.0 | $ 166,974.00 | $ 166,974.00 | C3988 | Valpo Reimb for CCC Jul-Sept 2020 V-Line Draw 30-CARES20 |
11/20/2020 | 3989 | City of Valpo | General Fund 5760.0 | $ 54,786.00 | $ 54,786.00 | C3989 | Valpo Reimb for OA Jul-Sept 2020 Draw 29- CARES20 |
11/20/2020 | 3990 | South Lake County Community Services | General Fund 5760.0 | $ 28,280.00 | $ 28,280.00 | C3990 | SLCCS Reimb for PM Jul-Sept 2020 Draw 28- CARES20 |
11/20/2020 | 3991 | South Lake County Community Services | General Fund 5760.0 | $ 145,478.00 | $ 145,478.00 | C3991 | SLCCS Reimb for OA Jul-Sept 2020 Draw 27- CARES20 |
11/20/2020 | 3992 | Porter County Aging and Community Services | General Fund 5760.0 | $ 102,230.00 | $ 102,230.00 | C3992 | PCACS Reimb for OA Jul-Sept 2020 Draw 26- CARES20 |
11/20/2020 | 3993 | City of LaPorte | General Fund 5760.0 | $ 162,373.00 | $ 162,373.00 | C3993 | LaPorte Reimb for OA Jul-Sept 2020 Draw 25- CARES20 |
11/20/2020 | 3996 | East Chicago Transit | General Fund 5760.0 | $ 85,213.00 | $ 85,213.00 | C3996 | ECT Reimb for OA Jul- Sept 2020 Draw 20- CARES20 |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Total: | $ 1,181,387.07 |
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,181,387.07 |
Dated this day of , 2021.
16
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 1/12/2021 @ 2:27 PM Reconciliation - General Page:
Closing Balance from Previous Statement............................................. .............. .............................. | 11/30/ 2020 | 1,195,830.97 |
14 Deposits and Other Additions Totaling........ ............................................................. | 631,789.82 | |
112 Checks and Other Withdrawls Totaling....... ........ ..................... ................................ | 259,137.49 | |
Adjustments Totaling.............................................................................................. | 269.64 | |
Voids Totaling................... .... ...................................... .......................................... | 3,750.00 | |
Service | 12/10/2020 | 125.00 |
Interest Earned. .............. ............................................. ................ .......... .......... | 12/31/2020 | 104.34 |
Closing Balance for this Statement ..................................................................................................... | 12/31/2020 | 1,572,482.28 |
Difference.............................. ................ .... ...... ..... ....... .................. ............. .......... .. | 0.00 | |
Cash Balance from General Ledger........ ............... ...... ............. ...... ....... ..... ............. ........ .... .............. | 12/31/2020 | 1,565,581.08 |
Open Activity from Bank Register............................. ............................................... . | (6,901.20) | |
Adjustment for Service Charges and Interest............................................................. | 0.00 | |
General Ledger Reconciliation to Statement.............................................................................................. | 1,572,482.28 |
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 | B/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 | 0002697 Blachly, Tabor, Bozik & Hartman. LLC | Legal- DEC | 1,650.00 | |
12/15/2020 | 0002703 IN Assoc of Regional Councils | A.nnual Membership Dues 2021 | 2,000.00 | |
12/15/2020 | 0002704 INRO Consultants | Renewal Software Agreement 7/1/20- | 1,680.00 | |
Total Unmarked Checks : 6,901.20 | 12/31/20 Total Checks : |
6,901.20 |
\-
/4\l
,)1ilJJ
Trial Balance - Cash
Run: 111212021 at 2:2e NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 12/31/2020
Page : 1
All
1.1.001.0000.1010.0 Cash
Total
Balance 1,565,581.08
1,565,581.08
NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
Run: 1/12/2021@ 11:12 AM Reconciliation - Revolving Loan Fund Page:
Closing Balance from Previous Statement............ .............. ..........,.....................................................
11/30/2020
155.093.25
7 | Deposits and Other Additions Totaling.......... ............................................................ | 5,178.31 | |
0 | Checks and Other Withdrawls Totaling..................................................................... | 0.00 | |
O | Adjustments Totaling............. ..................... ............................... ............................ | 0.00 | |
O | Voids | 0.00 | |
0.00 | |||
Interest Earned.............. ........ ....... ............... ...................... ..................... ....... ......... | 12/31/2020 | 9.35 | |
Closing Balance for this Statement................................. .................... ....................... ......................... | 12/31/2020 | 160,280.91 | |
Difference....................... .................................. ................... ................................... | 0.00 |
Cash Balance from General
Open Activity from Bank Register.......... ................................. .................................
Adjustment for Service Charges and Interest.............................................................
General Ledger Reconciliation to Statement..............................................................................................
/s11L
1/11/JI
12/31/2020 160,280.91
0.00
0.00
160,280.91
(}'
\
....... ,,_..
Trial Balance - Cash
Run: 111212021 at 11:1J,l. RTHWESTERN INDIANA REGIONAL PLANNING COMMISSION
For 12/31/2020
Page : 1
All
2.3.050.0000.1010.0 Cash
Total
Balance
160,280.91
160,280.91
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 |
12/1/2020 | Payroll | $ 2,089.28 | $ 2,089.28 | Pay period ending 11/22/2020 | |||
12/1/2020 | Payroll | $ 34,857.64 | $ 34,857.64 | Pay period ending 11/22/2020 | |||
12/1/2020 | B-4867 | Federal & Fica | General Fund 2140.0 | $ 4,316.48 | $ 4,316.48 | C4867 | 11/9 -11/22/2020 pay period- FWT, empfica, emficamed |
12/1/2020 | B-4867 | Federal & Fica | General Fund 2142.0 | $ 6,930.08 | $ 6,930.08 | C4867 | 11/9-11/22/2020 pay period-FWT, empfica, emficamed |
12/1/2020 | B-4864 | Federal & Fica | General Fund 2140.0 | $ 400.88 | $ 400.88 | C4864 | Edwards vacation payout- FWT,empfica, empficamed |
12/1/2020 | B-4864 | Federal & Fica | General Fund 2142.00 | $ 432.10 | $ 432.10 | C4864 | Edwards vacation payout- FWT,empfica, empficamed |
12/1/2020 | B-4870 | Horizon | General Fund 2150.0 | $ 370.38 | $ 370.38 | C4870 | 11/09-11/22/2020 pay period - HAS |
12/1/2020 | B-4871 | ICMA Retirement Fund-PR | General Fund 2146.00 | $ 805.00 | $ 805.00 | C4871 | 11/9-11/22/2020-pay oeruid - ICMA |
12/1/2020 | 4013 | ICMA Retirement Fund-PR | General Fund 5145.9 | $ 832.41 | $ 832.41 | C4013 | ER paid for Ty Warner 11/9 thru 11/22/20-p/r |
12/2/2020 | 4029 | De Lage Landen Financial | General Fund 5243.9 | $ 3,538.44 | $ 3,538.44 | C4029 | IT |
12/2/2020 | 4029 | De Lage Landen Financial | General Fund 5244.9 | $ 741.83 | $ 741.83 | C4029 | Telephone |
12/2/2020 | 4029 | De Lage Landen Financial | General Fund 5241.9 | $ 842.74 | $ 842.74 | C4029 | Copier Lesing Maintenance |
12/2/2020 | B-4869 | INPRS | General Fund 2140.0 | $ 5,819.68 | $ 5,819.68 | C4869 | 11/9-11/22/2020 pay period-EmpPerf [NIRPC] |
12/2/2020 | B-4866 | INPRS | General Fund 2149.0 | $ 401.04 | $ 401.04 | C4866 | Edwards vacation payout - EmpPerf [NIRPC} |
12/2/2020 | B-4012 | INPRS | General Fund 5141.9 | $ 0.01 | $ 0.01 | C4012 | Rounding Adjustment 11/9- 11/22/2020 pr 12/01/2020 |
12/3/2020 | 4042 | United Healthcare | General Fund 51429 | $ 9,017.06 | $ 9,017.06 | C4042 | ER Paid for DEC2020 Health Insurance |
12/3/2020 | 4042 | United Healthcare | General Fund 2152.0 | $ 1,706.52 | $ 1,706.52 | C4042 | EE w/h's for DEC Health Insurance |
12/10/2020 | 4024 | Chicago Tribune Media Group | General Fund 5410.1 | $ 27.72 | $ 27.72 | CC4024 | News Paper Subscription |
12/10/2020 | 3961 | GoodHire | General Fund 5410.9 | $ 54.99 | $ 54.99 | CC3961 | Standard background check new hire |
12/10/2020 | 4036 | ICMA | General Fund 5146.9 | $ 1,217.00 | $ 1,217.00 | CC4036 | ICMA Membership Renewal 2021 |
12/10/2020 | 4015 | Stamps | General Fund 5249.9 | $ 24.99 | $ 24.99 | CC4015 | Stamps-DEC |
12/10/2020 | 3978 | Zoom | General Fund 5410.5 | $ 119.92 | $ 119.92 | CC3978 | Zoom Pro Subscription -Yearly until 10/29/21 |
12/11/2020 | 4028 | Anthem Life | General Fund 5143.9 | $ 467.94 | $ 467.94 | 2696 | Life Insrance |
12/11/2020 | 4025 | Blachly, Tabor, Bozik, Hartman, LLC | General Fund 5602.9 | $ 1,650.00 | $ 1,650.00 | 2697 | Legal- DEC |
12/11/2020 | 4035 | Bryco | General Fund 5223.9 | $ 1,425.00 | $ 1,425.00 | 2698 | Office Cleaning- DEC |
12/11/2020 | 4027 | City of Portage | General Fund 5221.9 | $ 18,775.18 | $ 18,775.18 | 2700 | Lease- DEC |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
12/11/2020 | 4033 | City of Portage | General 5224.9 | Fund | $ 1,874.31 | $ 1,874.31 | 2700 | Sewer/Water/Gas/Electric Service |
12/11/2020 | 4019 | Health Resources | General 2153.0 | Fund | $ 336.33 | $ 336.33 | 2701 | Dental Insurance DEC |
12/11/2020 | 4037 | IN Assoc of Regional Councils | General 5410.0 | Fund | $ 2,000.00 | $ 2,000.00 | 2703 | Annual Memebership Dues 2021 |
12/11/2020 | 4017 | Kansas City Life Insurance Co. | General 5143.9 | Fund | $ 733.17 | $ 733.17 | 2705 | Life Insrance |
12/11/2020 | 4018 | NWI Forum | General 5410.1 | Fund | $ 1,100.00 | $ 1,100.00 | 2706 | 2021 Membership Dues |
12/11/2020 | 4032 | Skulski Consulting | General 5610.4 | Fund | $ 11,300.00 | $ 11,300.00 | 2708 | ADA Compliance Review 2020-Consulting |
12/11/2020 | B-4872 | United Way of Porter County | General 2147.0 | Fund | $ 33.85 | $ 33.85 | 2709 | 11/09-11/22/2020 pay period - United Way |
12/11/2020 | B-4878 | United Way of Porter County | General 2147.0 | Fund | $ 33.85 | $ 33.85 | 2709 | 11/23-12/6/2020 pay period - United Way |
12/11/2020 | 3906 | Woody Warehouse Nursery, Inc | General 5610.5 | Fund | $ 4,742.28 | $ 4,742.28 | 2710 | Purchase Trees fo rthe Communi Tree program |
12/11/2020 | 3497 | Woody Warehouse Nursery, Inc | General 5610.5 | Fund | $ 3,791.60 | $ 3,791.60 | 2710 | Purchase Trees fo rthe Communi Tree program |
12/11/2020 | 4031 | INRO Consultants | General 5410.2 | Fund | $ 1,680.00 | $ 1,680.00 | 2704 | Renewal Software Agreement 7/1/20-12/31/2020 |
12/14/2020 | 4034 | Comcast | General 5244.9 | Fund | $ 139.64 | $ 139.64 | C4034 | Business Internet- DEC |
12/14/2020 | 4043 | INBiz | General 5146.9 | Fund | $ 21.50 | $ 21.50 | C4043 | Online payment service |
12/14/2020 | 4022 | Total Disposal | General 5223.9 | Fund | $ 74.00 | $ 74.00 | C4022 | Recycle/Trash- DEC |
12/15/2020 | Payroll | $ 35,965.36 | $ 35,965.36 | Pay period ending 12/06/2020 | ||||
12/15/2020 | 4873 | Federal & Fica | General 2140.0 | Fund | $ 4,375.58 | $ 4,375.58 | C4873 | 11/23-12/06/2020 pay period - FWT, empfica, emficamed |
12/15/2020 | 4873 | Federal & Fica | General 2142.0 | Fund | $ 6,868.84 | $ 6,868.84 | C4873 | 11/23-12/06/2020 pay period - FWT, empfica, emficamed |
12/15/2020 | 4876 | Horizon Bank | General 2150.0 | Fund | $ 520.38 | $ 520.38 | C4876 | 11/23-12/06/2020- pay period HAS |
12/15/2020 | 4877 | ICMA Retirement Fund-PR | General 2146.00 | Fund | $ 805.00 | $ 805.00 | C4877 | 11/23-12/6/2020 pay period ICMA |
12/15/2020 | 4016 | ICMA Retirement Fund-PR | General 5145.9 | Fund | $ 832.41 | $ 832.41 | C4016 | ER paid for Ty Warner 11/23 thru 12/6/2020- p/r |
Account Service Fee | $ 125.00 | $ 125.00 | Service Fee | |||||
12/16/2020 | 4021 | Ecointeractive | General 5610.2 | Fund | $ 3,750.00 | $ 3,750.00 | C4021 | TIP SAAS Service |
12/16/2020 | 4023 | Fidelity EyeMed | General 2154.0 | Fund | $ 80.18 | $ 80.18 | C4023 | Vision Insurance |
12/16/2020 | 4875 | INPRS | General 2149.0 | Fund | $ 6,108.14 | $ 6,108.14 | C4875 | 11/23-12/6/2020 pay period- EmpPerf [NIRPC] |
12/16/2020 | 4842 | IN Dept of Revenue | General 2143.0 | Fund | $ 1,408.88 | $ 1,408.88 | C4842 | 10/26-11/08/2020 pay period - LwIN, SwtIN State Tax Withholdings Payable |
12/16/2020 | 4842 | IN Dept of Revenue | General 2144.0 | Fund | $ 306.66 | $ 306.66 | C4842 | 10/26- 11/08/2020 pay period -LwIN, SwtIN Local Tax Withholdings Payable |
12/16/2020 | 4808 | IN Dept of Revenue | General 2143.0 | Fund | $ 1,431.23 | $ 1,431.23 | C4808 | 10/12-10/25/2020 pay period - State Tax Withholdings Payable |
12/16/2020 | 4808 | IN Dept of Revenue | General 2144.0 | Fund | $ 313.23 | $ 313.23 | C4808 | 10/12-10/25/2020 pay period - Local Tax Withholdings Payable |
12/16/2020 | 4026 | Warner, Ty | General | Fund | $ 125.00 | $ 125.00 | C4026 | Communication Expense - DEC |
12/29/2020 | Payroll | General | Fund | $ 37,643.28 | $ 37,643.28 | Payperiod 12/29/20 | ||
12/30/2020 | B-4931 | Federal & Fica | General 2140.0 | Fund | $ 4,663.51 | $ 4,663.51 | C4931 | Federal Tax Withholding Payable |
12/30/2020 | B-4931 | Federal & Fica | General 2142.0 | Fund | $ 6,696.14 | $ 6,696.14 | C4931 | FICA Tax Withholding Payable |
12/30/2020 | B-4934 | Horizon Bank | General 2150.0 | Fund | $ 520.38 | $ 520.38 | C4934 | 12/7-12/20/2020 | pay | period- | HAS |
12/30/2020 | B-4935 | ICMA Retirement Fund-PR | General 2146.0 | Fund | $ 805.00 | $ 805.00 | C4935 | 12/7-12/20/2020 pay period | -ICMA | ||
12/30/2020 | 4041 | ICMA Retirement Fund-PR | General 5145.9 | Fund | $ 832.54 | $ 832.54 | C4041 | ER paid for Ty Warner 12/7 thru 12/20/2020- p/r | |||
12/30/2020 | B-4933 | INPRS | General 2149.0 | Fund | $ 6,108.14 | $ 6,108.14 | C4933 | 12/7-12/20/2020 pay period -EmpPerf[NIRPC] | |||
General | Fund | $ - |
Total: | $ 245,009.72 |
Allowance of Claims
We have examined the claims listed on the foregoing Register of Claims, and except for claims not allowed as shown on the register such claims |
are hereby allowed in the total amount of: $ 245,009.72 |
Dated this day of , 2021.
PLANNING COMMISSION |
6100 Southport Road |
Portage, IN 46368 |
(219) 763-6060 |
This form approved by the State Board of Accounts for use by the Northwestern Indiana Regional Planning Commission (1985)
Date Filed | Claim Number | Name of Claimant | Fund | Fund Amount | Amount of Claim | Check # | Notes |
12/11/2020 | 3938 | CCL Supply LLC | General Fund 5960.0 | $ 1,800.00 | $ 1,800.00 | 2699 | Electrostatic Disinfection Guns Hand Held |
12/11/2020 | 3939 | CCL Supply LLC | General Fund 5960.0 | $ 98.10 | $ 98.10 | 2699 | Electrostatic Disinfection Guns Hand Held |
12/11/2020 | 4030 | RouteMatch | General Fund 5960.0 | $ 1,062.00 | $ 1,062.00 | 2707 | SLCC- DEC |
12/11/2020 | 4030 | RouteMatch | General Fund 5960.0 | $ 531.00 | $ 531.00 | 2707 | NT- DEC |
12/11/2020 | 4030 | RouteMatch | General Fund 5960.0 | $ 472.00 | $ 472.00 | 2707 | PCACS- DEC |
12/11/2020 | 4014 | Impact Networking LLC | General Fund 5910.0 | $ 750.00 | $ 750.00 | 2702 | Installation & Configuration Fee to set up NIRPC |
12/16/202 | 4020 | Todd, Lisa | General Fund 5410.4 | $ 12.92 | $ 12.92 | C4020 | Mileage- CARES |
12/31/2020 | 4008 | Porter County Aging and Community Services | General Fund 5960.0 | $ 11,106.75 | $ 11,106.75 | C4008 | computers/DVD- RAM/WirelessCombos/LED monitors/Mounting |
Total: | $ 15,832.77 |
Allowance of Claims
Two (2) Replacement BOC Vehicles – Procurement #21-01
Purchase of:
o Two (2) vehicle replacements for LaPorte TransPorte - $118,400.00
Vehicles being replaced will have met their useful life of 4 years or 100,000 miles at the time of delivery.
Paid with Federal Transit Administration funds (80%) out of grant IN-2020- 039 and local share coming from the above listed agencies.
Recommendation to approve purchase of replacement vehicles not to exceed
$118,400.00 in federal funds.
TO: NIRPC Finance & Personnel Committee
FROM: Gabrielle Biciunas, Economic Development District Coordinator NIRPC
RE: Appointment of CARES Regional Revolving Loan Fund Loan Committee Members DATE: January 21, 2021
NIRPC received funds from the Economic Development Administration (EDA) CARES Act Recovery Assistance Grant totaling $583,000 to capitalize and administer a Revolving Loan Fund (RLF) to make loans available to small businesses in Lake, Porter, and LaPorte counties that have been impacted by the coronavirus. Financing of $530,000 will assist businesses in recovering and responding to the impacts of the pandemic while $53,000 is used for administration of the program. In accordance with the CARES Regional Revolving Loan Fund Management Plan approved on September 17, 2020, the Finance and Personnel Committee is responsible for appointing Loan Committee Members to serve on the CARES Regional Revolving Loan Fund For Lake, Porter, and Laporte Counties.
The members of the new Lake County and Porter County loan committees are required to “represent a balanced mix of Economic Development, Chamber of Commerce, banks/commercial lenders, non-commercial lenders, businesses, lawyers, and others.” The LaPorte County loan committee for CARES Regional funds are planned to consist of the current members of the existing LaPorte County RLF loan committee.
The following items are therefore requested to be approved by NIRPC’s Finance and Personnel Committee:
Approve inaugural appointments of individuals who have agreed to serve on the Lake County RLF loan committee.
Approve inaugural appointments of individuals who have agreed to serve on the Porter County RLF loan committee.
Approve that the existing seven member LaPorte RLF Committee shall also serve as the loan committee for the CARES Regional RLF for LaPorte County.
Authorize the Executive Director to be the responsible appointing party to replace any loan committee member in the future in accordance with the Management Plan of the LaPorte County RLF. (NIRPC only appoints the citizen members on the loan committee according to the current LaPorte County RLF Management Plan.)
Agree that appointment or replacement of any loan committee member for Lake and Porter counties may be done in the future by the Executive Director as the responsible appointing party for circumstances related to lack of attendance without reasonable cause or for lack of eligibility due to no longer working in or representing the specific county.
Agree that notification of an actual or potential conflict of interest is to be directed in writing to the Executive Director and copied to the EDD Coordinator a minimum of three working days prior to a loan committee meeting date.
Lake County Loan Committee Members:
Bank Representatives
Monica Garcia | Chase Bank | VP, Relationship Manager III |
Kevin Crosse | Peoples Bank | VP, Business Banker |
LEDO Representative | ||
Karen Lauerman | Lake County Economic Alliance | President & CEO |
Business Representatives | ||
Sheleita Miller | Gatekeeper Accounting | Owner CPA |
Edward Garza | El Popular, Inc | President |
Porter County Loan Committee Members:
Bank Representatives
Caleb Walma | 1st Source Bank | Business Banker II |
Tim Warner | Centier Bank | VP, Business Banking |
LEDO Representative
Amy Parker Portage EDC Executive Director
LaPorte County Loan Committee Members (Existing Members):
Bank Representatives
Steve Kring Horizon Bank Regional President
Sandra Smith PNC Bank VP, Branch Manager
LEDO Representative
Bert Cook LaPorte Economic Advancement Partnership Ex. Director Clarence Hulse Economic Development Corporation Michigan City Ex. Director
Business Representatives
John Kaylor Schmitt & Kaylor CPAs CPA
Jessica Romine Parkison & Hinton, Inc., PC Partner, CPA
LaPorte County Resident
Mike Schultz LaPorte Co. Assessor
BY AGREEMENT MADE AND ENTERED INTO, on the date of January 1, 2021, by and between the NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION,
hereinafter referred to as “NIRPC” and the KANKAKEE RIVER BASIN AND YELLOW RIVER BASIN DEVELOPMENT COMMISSION: hereinafter referred to as “KRBYRBDC” under the terms and conditions hereinafter set forth, the following is hereby agreed:
NIRPC shall provide the KRBYRBDC with accounting services and assistance as is required by the KRBYRBDC to carry out its purposes under its enabling statute.
KRBYRBDC will purchase and maintain, at its own expense, a subscription to QuickBooks Online Payroll Premium for three (3) users through the duration of the contract for NIRPC’s use in providing KRBYRBDC with accounting services and assistance.
In conjunction with the above, NIRPC shall provide the following financial management assistance to the KRBYRBDC and shall be compensated for such service by the KRBYRBDC at the monthly rate of one thousand two hundred and seventy-five dollars per month ($1,275) for a total annual base cost of $15,300. The minimum monthly rate is based on fifteen hours of accounting services per month. Additional hours required above 15 will be billed at a rate of $85/hour. See Exhibit A. To the extent identified in this agreement, NIRPC shall:
Aid the KRBYRBDC in preparation of its budget, and provide accounting services for the receipt, investment and disbursal of its funds, all in accordance with applicable State Board of Accounts guidelines, statute, and the internal control policy and guidelines set out by the Commission herein or otherwise.
Deposit KRBYRBDC funds in the name of the KRBYRBDC and in depositories designated by the KRBYRBDC.
Disburse KRBYRBDC funds only upon authorization to do so by the KRBYRBDC and presentation of a State Board of Accounts standard claim form signed by at least two (2) Commission members and approved by the KRBYRBDC. Checks shall be drawn from an account in the KRBYRBDC’s name and shall be signed by two authorized officials. Standard turn around time for check production is 3 days. Checks required in less time may result in additional hourly fees.
NIRPC shall be reimbursed for reasonable travel expenses, at the state of Indiana mileage reimbursement rate of $0.38 per mile. (https://www.in.gov/idoa), incurred in connection with attending KRBYRBDC board and committee meetings, as well as travel on other KRBYRBDC business at the request of Director of the Kankakee River Basin Commission.
NIRPC shall make available to the KRBYRBDC the use of its postage machine. Actual postage cost shall be billed to the KRBYRBDC.
NIRPC shall make available the use of its copy machines. Use of this equipment will be billed at the rate of $5.00 per month plus $.06 per black & white copies and $.20 per copy for color copies.
NIRPC may make available additional space or other services to the KRBYRBDC on a direct charge basis. NIRPC shall bill the KRBYRBDC for such services on a basis that is mutually agreed to by the parties.
NIRPC shall provide itemized monthly billings for services performed. Payment shall be due within thirty (30) days after billing.
This agreement may be amended by mutual agreement of the parties. Amendments shall be in writing.
This agreement shall be effective January 1, 2021 and terminate December 31, 2021. However, either party may terminate the agreement at an earlier date by providing a written notice of intent at least sixty (60) days prior to an effective termination date, which shall coincide with the last day of a calendar month.
KRBYRBDC shall have the option to extend this agreement for the period of one year with monthly base rate increased to $1,313.25 and hourly overage rate of $87.55
NORTHWESTERN INDIANA REGIONAL KANKAKEE RIVER BASIN YELLOW PLANNING COMMISSION RIVER BASIN DEVELOPMENT
COMMISSION
Tyson Warner
Executive Director Chair
Date: Date:
EXHIBIT A
Staff costs are estimated as follows below:
Staff Accountant @ $30.80/hr Salary | Monthly hours | Annual hours | Salary | Fringe | Indirect (Overhead) | Total |
2021 | 15 | 180 | $ 5,544 | $ 4,878 | $ 4,878 | $ 15,300 |
2022 Option | ||||||
2022 | 15 | 180 | $5,710 | $ 5,024.50 | $ 5024.50 | $ 15,759 |