image

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org


FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda

Thursday, November 19, 2020 -- 8:00 a.m.

Zoom Meeting: https://zoom.us/j/97016869662?pwd=RHNNNE40NmNMQ09ySmh6NlllMXJJdz09 Meeting ID: 970 1686 9662 Passcode: 206448 / Phone In: (312) 626-6799


  1. Call to Order


  2. Meeting Minutes of October 15, 2020 Pages 1-2


  3. Review of Financial Status – October 2020 Pages 3-11

    1. Bank Statement Reconciliation

    2. Expenses YTD October 2020 – Budget vs Actual

    3. Revenue YTD October 2020 – Budget vs Actual


  4. Approval of Claims Register General Fund– October 2020 Pages 12-14

    ACTION REQUESTED: Approval

  5. Approval of Claims Register – CARES Funds- October 2020 Pages 15

    ACTION REQUESTED: Approval


  6. Executive Director Contract Pages 16

    1. 2021 Addendum Employment Agreement

      ACTION REQUESTED: Recommendation


  7. NIRPC budget – Calendar year 2021 Pages 17-28

    1. NIRPC Resolution #20-29

      ACTION REQUESTED: Recommendation


  8. Vehicle Disposition Sales Pages 29-36

    INFORMATIONAL


  9. Personnel update


  10. Other Business


  11. Adjournment


The next meeting is scheduled for January 21, 2021 at 8:00 a.m.



The Northwestern Indiana Regional Planning Commission (NIRPC) prohibits discrimination in all its programs and activities on the basis of race, color, sex, religion, national origin, age, disability, marital status, familial status, parental status, sexual orientation, genetic information, political beliefs, reprisal, or because all or part of an individual's income is derived from any public assistance program. Users may access the Relay Indiana Service by calling 711 or 1-800-743-3333. Requests for alternative formats may be made 72 hours in advance by contacting nirpc@nirpc.org.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION FINANCE AND PERSONNEL COMMITTEE

October 15, 2020 / Google Meet Virtual Meeting – 8:00 a.m.


Members Present

Richard Hardaway, Justin Kiel, George Topoll 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 September 17, 2020 meeting were presented. George Topoll made motion and Richard Hardaway seconded to approve the minutes. A roll call vote was taken with Richard Hardaway and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 2-0. Justin Kiel joined the meeting after the vote and also gave his vote in the affirmative and making the motion passing at 3-0.

Review of Financial Status – September 2020

Talaya Jones presented the September 2020 bank reconciliations for the NIRPC general account and the Revolving Loan Fund (RLF) account. The general account beginning balance from 9/1/2020 was

$1,582,046.34 with a closing balance of $1,312,796,77 as of 9/30/2020. The RLF account beginning balance from 9/1/2020 was $137,432.15 with a closing balance of $142,024.84 as of 9/30/2020.

Talaya presented the financial status report for category expenditures year to date, September 2020.

$863,443 has been expended of the $1,293,260 Salaries budget. $358,747 has been expended of the

$509,690 Fringe Benefits budget. $204,040 has been expended of the $280,297 Occupancy budget.

$44,729 has been expended of the $78,840 Maintenance budget. $91,855 has been expended of the

$196,750 Departmental budget. $286,492 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 $1,856,042 of the $3,343,302 budgeted. $200 has been expended of the $85,000 LaPorte Revolving Loan Fund budget. $2,216,483 has been expended of the $2,440,988 Transit Capital Fund budget. Year to date, all categories are under budget, with total expenditures of $5,697,701 of the

$10,258,326 budgeted, $4,560,625 under budget.

Talaya presented the year to date September 2020 expended by category chart. 47% of the expended budget was salaries, 19% fringe benefits, 16% contractual, 11% occupancy, 5% departmental and 2% maintenance.

Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual expenditures year to date, September 2020. Per the State Board of Accounts, the CARES Act and general funds must be reported separately. $92,504 of the $236,733 has been expended of the Salaries budget.

$0 of $5,000 contractual, RLF Services, budget has been expended. $103 of the $25,000 departmental, PPE Supplies, budget has been expended. Talaya noted funds have been expended in the PPE Supplies budget, but they are still reflected in the general funds supply budget and have not been transferred yet.

$2,160 of the $165,000 Capital Outlays, Furniture and Equipment, budget has been expended. Total NIRPC CARES Fund Expenditures of $94,766 had been expended from the $431,733 budget. $0 of the $583,000 CARES Revolving Loan Fund budget has been expended. $6,437 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,193,813 of the $6,549,027 budgeted.

Talaya presented the year to date September 2020 budget vs. actual revenue report. $366,669 of the

$540,271 county appropriations budget has been collected. $189,246 of the $539,733 federal agencies budget has been collected. $1,233,857 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. $6,788 of the $9,682 interest income budget has been collected. All categories are currently under collected. George Topoll questioned the under collection in the categories and Talaya explained that it is the end of the quarter and reporting has to be submitted for reimbursement.

Talaya presented the year to date revenue by funding source chart as of September 30. 67% of collected revenue has been from state agencies, 20% from county appropriations, 10% 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, September 2020. All revenue is federal and is classified as Economic Development District or FTA. $202,943 has been collected of the $604,229 total CARES Act revenue budget.

Approval of Claims Register – September 2020

Talaya informed the committee that there are two registers to approve due to the specifications from the State Board of Accounts that CARES Act expenditures must be separate. Talaya first presented the September 2020 regular claims register totaling $680,762.96 to the Committee for approval. George Topoll made motion and Justin Kiel seconded to approve the September 2020 claims register. A roll call vote was taken with Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 3-0. The CARES Act expenditures register of claims was totaling $5,617.92 was then presented for approval. George Topoll made motion and Justin Kiel seconded to approve the September 2020 claims register. A roll call vote was taken with Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 3-0.

Budget Amendment #4

Talaya presented 2020 budget amendment #4 to the committee for approval. The amendment is a transfer of $47,000 between Environmental Projects and Audit and Accounting within the contractual category. George Topoll made motion and Justin Kiel seconded to approve the September 2020 claims register. A roll call vote was taken with Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 3-0.

FY2021 NIRPC Preliminary Budget

Talaya presented the 2021 preliminary budget. She explained the budget includes CARES act funds and PL carryover and there will be an increase and change before the final budget is brought before the Committee at the November meeting.

Personnel updates

Meredith Stilwell reported interviews were held for the Economic Development Specialist and Communication Specialist positions and NIRPC staff continues to work a staggered in-office and remote schedule, with the entire office working remotely on Fridays. Ty reminded the Committee the 2 positions interviewed for are CARES Act funded, EDA positions which are temporary and last until July 2022. Everything appears to be set to make offers to candidates and both positions should be filled shortly, dependent upon candidate availability. After that, the focus will be on the three remaining openings for Director of Transportation, Transit Planner, and Programming and Grant Assistant. Ty indicated he was thankful staff for helping make the staggered scheduling work and indicated he is not planning to deviate from that anytime real soon.

Other Business None.

Adjournment

There being no further business, the meeting was adjourned.


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 11/03/2020@ 3:39 PM

Reconciliation - General

Page:

image

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

9/30/2020

1,312,796.77


11

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

382,699.51

94

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

626,911.65

O

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

0.00

O

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

0.00

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

10/09/2020

93.68

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

10/31/2020

110.54


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

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

10/31/2020

1,068,601.49

0.00


image


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

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

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

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

10/31/2020 1,048,472.95

(20,128.54) ck.)

0.00

image

image

1,068,601.49


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.

TIP SAAS SERVICE- monthly srvc fee

3,750 .00


4/09/2020


0002545 Anthem Life

ending 2/29/20

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'

9/23/2020

0002660 Nat'I Assoc. of Regional Councils

2020 Executive Directors Confernece 10/5-

250.00

6/2020

10/21/2020

0002674 Possibility Place Nursery

Purchase Trees for Communi Tree program

14,120.00

10/21/2020

0002675 RailCats Baseball

Nightly promotion-golf event

100.00

10/21/2020

0002678 United Way of Porter County

Invoices 2020-20, 2020-21

67.70

Total Unmarked Checks: 19,858.90

Total Checks :

19,858.90

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Trial Balance - Detail by e1 e2 e3

Run: 11/04/2020 at 8:20 AM

For 10/31/2020 Page: 1


1 1 001 Operating

1.1.001.0000.1010.0 Cash

Total

Debits 1,048,472.95

image

1,048,472.95

Credits

0.00

0.00


image



image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 11/04/2020@ 8:19 AM

Reconciliation - Revolving Loan Fund

Page:



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

9/30/2020

142,024.84

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

7,872.45

0 Checks and Other WithdrawlsTotaling.....................................................................

0.00

0 Adjustments Totaling..............................................................................................

0.00

0 Voids Totaling........................................................................................................

0.00

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

0.00

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

10/30/2020

8.78

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

10/31/2020

149,906.07

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

0.00

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

10/31/2020

149,906.07

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

0.00

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

0.00

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

149,906.07



image image



image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Trial Balance - Detail by e1 e2 e3

Run: 11/03/2020 at 2:38 PM

For 10/31/2020 Page: 1


2 3 050 Revolving Load

2.3.050.0000.1010.0 Cash

Total

Debits

149 906.07

149,906.07

Credits

image

000

0.00



image



image


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH OCTOBER 31, 2020



Line Items


FY 2020 Budget

FY 20

YTD October YTD Variance YTD % Budget % Expended (Over)/Under Variance balance


Salaries

5020-1

Total Salaries

1,293,260

1,017,467 60,250 6% 21%

Salaries Sub-Total

1,293,260

image

1,017,467 60,250 6% 21%


Fringe Benefits

5121-9

FICA Contributions

104,321

78,650 8,284 10% 25%

5122-9

Workers Compensation

6,100

2,950 2,133 42% 52%

5123-9

Unemployment Compensation

1,650

1,092 283 21% 34%

5141-9

PERF Contributions

159,118

132,637 (38) 0% 17%

5142-9

Health Insurance

170,501

143,870 (1,786) -1% 16%

5143-9

Life & Disability Insurance

23,000

15,199 3,968 21% 34%

5145-9

ICMA

25,000

17,443 3,390 16% 30%

5146-9

Staff Development

20,000

3,751 12,915 77% 81%

Fringe Benefits Sub-Total

509,690

image

395,592 29,150 7% 22%


Occupancy

5221-9

Office Lease

225,500

187,752 165 0% 17%

5222-9

Property Insurance

6,500

4,901 516 10% 25%

5223-9

Building Maintenance

18,540

15,223 227 1% 18%

5224-9

Utilities

29,757

18,411 6,386 26% 38%

Occupancy Sub-Total

280,297

image

226,287 7,294 3% 19%


Maintenance

5241-9

Copier Leasing/Maintenance

19,400

3,581 12,586 78% 0%

5243-9

Computer Service/Maintenance

40,440

41,238 (7,538) -22% 0%

5244-9

Telephone Service/Maintenance

18,000

10,207 4,793 32% 0%

Combined Copier/IT/Phone Service/Maintenance

77,840

image

55,026 9,841 15% 29%

5249-9

Other Equipment Maintenance

1,000

image

239 595 71% 76%

Maintenance Sub-Total

78,840

image

55,264 10,436 16% 30%

image

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

11,036 23,548 68% 73%

5410-2

Communications: Transportation

60,000

16,761 33,239 66% 72%

5410-4

Communications: Subgrantee Management

15,000

260 12,240 98% 98%

5410-5

Communications: Environmental Programs

28,650

16,443 7,432 31% 43%

5410-8

Communications: Partner Agency

1,000

716 118 14% 28%

5410-9

Communications: Allocated Functions

28,000

14,391 8,942 38% 49%

5420-5

Promotional Expenses: Environmental Programs

15,600

17,405 (4,405) -34% -12%

5430-9

General Use Supplies Expense

7,000

952 4,881 84% 86%

Departmental Sub-Total

196,750

image

77,964 85,994 52% 60%


Contractual

5602-9

Legal Services

19,800

16,500 0 0% 17%

5603-9

Audit and Accounting

69,000

33,065 24,435 42% 52%

5604-9

LaPorte RLF Services

2,000

0 1,667 100% 100%

5610-4

Transit Oversight

11,300

600 8,817 94% 95%

5610-5

Environmental Projects

522,374

251,412 183,899 42% 52%

5610-5

Alternative Fuel

70,991

0 59,159 100% 100%

5619-9

Organizational Dev.

2,000

0 1,667 100% 100%

5610-0

Board Development

2,000

0 1,667 100% 100%

5610-2

E-Tip

45,000

37,500 0 0% 17%

Economic Development District

140,000

0 116,667 100% 100%

Contractual Sub-Total

884,465

image

339,077 397,977 54% 62%


Capital Outlays

5910-0

Furniture and Equipment

100,000

6,736 76,597 92% 93%

Capital Outlays Sub-Total

100,000

image

6,736 76,597 92% 93%



TOTAL GENERAL FUND EXPENDITURES

3,343,302

2,118,387 667,698

24% 37%


image

image

image

image

image

image

image

LaPorte Revolving Loan Fund

85,000

200

LaPorte Revolving Loan Fund

85,000

200

84,800 100%


image

image

image

image

Transit Capital Fund

2,440,988

2,614,854

Transit Capital Fund

2,440,988

2,614,854

(173,866) -7%


2019 Transit Operating Fund

4,389,036 1,624,977

2,764,059

63%

TOTAL EXPENDITURES

10,258,326 6,358,418

3,899,908

38%





YTD October 2020 Expenses Budget vs Actual

YTD October 2020 Expenses Budget vs Actual


CAR1E,S20F0U,0N00D EXPENDITURES

1,077,717

1,017,467

1,000,000


800,000

737,054

CAR1E,S20F0U,0N00D EXPENDITURES

1,077,717

1,017,467

1,000,000


800,000

737,054


600,000

600,000


424,742

395,592

400,000

339,077

424,742

395,592

400,000

339,077


200,000

65,700

55,264

77,964

200,000

65,700

55,264

77,964


-

-


SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS


YTD October Budget YTD October Expended

YTD October Budget YTD October Expended


YTD October 2020 Expended by Category


16%


4%

2%

48%

11%


19%

YTD October 2020 Expended by Category


16%


4%

2%

48%

11%


19%


image

image

233,581 226,287

233,581 226,287

163,958

163,958

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

8



Line Items


FY 2020 Budget

YTD October Expended

FY 20 Budget % balance

NIRPC CARES EXPENDITURES

Salaries

Salaries

236,733

47,819

80%

Salaries Sub-Total

236,733

47,819

80%


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH OCTOBER 31, 2020

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH OCTOBER 31, 2020

Contractual

RLF Services 5,000 - 100%

Contractual Sub-Total

5,000

-

100%


Departmental

Communications

500

103

79%

PPE Supplies & Office Supplies

25,000

15,429

38%

Departmental Sub-Total

25,000

15,532

38%

Capital Outlays


Furniture and Equipment


165,000


2,160


99%

image

image

15,532

15,532

5,000

5,000

-

-

2,160

2,160

Capital Outlays Sub-Total 165,000 2,160 99%

TOTAL NIRPC CARES FUND EXPENDITURES

431,733

65,511

85%


CARES Revolving Loan Fund

583,000

-


CARES Transit Capital Fund

1,219,972

30,825


CARES Transit Agency Fund

4,314,322

1,092,610

TOTAL EXPENDITURES

6,549,027

1,188,946


YTD October 2020 Expenses Budget vs Actual

YTD October 2020 Expenses Budget vs Actual


250,000

236,733

250,000

236,733


200,000

200,000


165,000

165,000


150,000


100,000

150,000


100,000


47,819

47,819


50,000

25,000

50,000

25,000


-

-


SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS


Budget Expended

Budget Expended


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH OCTOBER 31, 2020



Line Items


FY 2020

Budget

FY 20

YTD October 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

184,337 (265,441) -59% 66%

1.1.4310

State Agencies

1,935,395

1,337,675 (275,154) -17% 31%

1.1.4410

Local Agencies

44,694

24,224 (13,021) -35% 46%

1.1.4610

Non-Governmental

135,318

11,051 (101,714) -90% 92%

1.3.4260

Economic Development District

70,000

13,288 (45,046) -77% 81%

1.1.4800

Interest Income

9,862

8,391 173 2% 15%

Revenue Total

3,275,273

image

1,945,634 (333,534) -15% 41%


image

image

Revenue by Funding Source as of October 31, 2020


1% 1%

1% 0%


19%


County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District

Interest Income

County Appropriations Federal Agencies State Agencies

Local Agencies

Non-Governmental

Economic Development District

Interest Income

9%


69%

CARES

Economic Development District

CARES

Economic Development District

image

image


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH OCTOBER 31, 2020



Line Items

FY 2020

Budget

YTD October Collected

FY 20 Budget % balance

CARES ACT FTA Revenue

Operating Revenue

419,386

172,446

59%

Capital Revenue

125,000

0

100%

CARES ACT EDA

Economic Development District

59,843

0

100%

Revenue Total

604,229

172,446

71%


Revenue by Funding Source as of October 31, 2020


0%


100%

Revenue by Funding Source as of October 31, 2020


0%


100%

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


10/1/2020


3608

Midwest Transit Equipment, Inc

General Fund 5960.0


$ 127,524.00


$ 127,524.00


C3608


2 BOC's 13 Ambulatory & 3 Wheel chairs-PCACS


10/1/2020


3607

Midwest Transit Equipment, Inc

General Fund 5960.0


$ 191,286.00


$ 191,286.00


C3607


3 BOC's 13 Ambulatory & 3 Wheel Chairs- PCACS


10/5/2020


B-4763


INPRS

General Fund 2149.0


$ 581.26


$ 581.26


C4763


Winters vacation payout - EmpPerf [NIRPC]


10/5/2020


3930


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3930


Rounding Adjustment 9/14 thru 9/27/2020-p/r


10/5/2020


3959

United HealthCare Srvc, Inc

General Fund 5142.9


$ 11,036.65


$ 11,036.65


C3959


ER paid Insurance - OCT


10/5/2020


3959

United HealthCare Srvc, Inc

General Fund 2152.0


$ 2,088.74


$ 2,088.74


C3959


EE w/h's Insurance - OCT


10/6/2020


Payroll


$ 34,495.61


$ 34,495.61


Pay period ending 9/27/2020


10/6/2020


Payroll


$ 3,260.68


$ 3,260.68


Pay period ending 9/27/2020- pay out James Winters


10/6/2020


B-4761


Federal & Fica

General Fund 2140.0


$ 366.84


$ 366.84


C4761


Winters vacation payout - FWT,empfica, empficamed-Federal Tax Withholdings Payable


10/6/2020


B-4761


Federal & Fica

General Fund 2142.0


$ 626.28


$ 626.28


C4761


Winters vacation payout - FWT, empfica, empficamed -Fica Tax Withholdings Payable


10/6/2020


B-4764


Federal & Fica

General Fund 2140.0


$ 4,475.51


$ 4,475.51


C4764


9/14-9/27 pay period -FWT,empfica, empficamed -Federal Tax Withholdings Payable


10/6/2020


B-4764


Federal & Fica

General Fund 2142.0


$ 6,894.90


$ 6,894.90


C4764


9/14-9/27 pay period -FWT,empfica, empficamed -FicaTax Withholdings Payable


10/6/2020


3920


Fidelity EyeMed Vision Ins

General Fund 2154.0


$ 99.01


$ 99.01


C3920


Vision Insurance


10/6/2020


B-4767


Horizon Bank

General Fund 2150.0


$ 415.38


$ 415.38


C4767


9/14-9/27 pay period - HAS


10/6/2020


B-4768


ICMA Retirement Fund-PR

General Fund 2146.0


$ 805.00


$ 805.00


C4768


9/14-9/27 pay period - ICMA


10/6/2020


3931


ICMA Retirement Fund-PR

General Fund 5145.9


$ 832.41


$ 832.41


C3931


ER paid for Ty Warner 9/14 thru 9/27/2020- p/r


10/6/2020


3933


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C3933


Recycle/Trash/Bldg. Maint. - OCT


10/7/2020


B-4766


INPRS

General Fund 2149.0


$ 5,803.18


$ 5,803.18


C4766


9/14-9/27 pay period - EmpPerf [NIRPC]


10/8/2020


3919


Anthem

General Fund 5143.9


$ 505.54


$ 505.54


2666


Life Insruance


10/8/2020


3923

Blachly, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,650.00


$ 1,650.00


2667


Legal Services


10/8/2020


3915


City of Portage

General Fund 5224.9


$ 1,972.68


$ 1,972.68


2668


Sewer/Water/Gas/Electric Utilities - Sept


10/8/2020


3922


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2668


Lease - OCT


10/8/2020


3916

Kansas City Life Insurance Co.

General Fund 5143.9


$ 877.54


$ 877.54


2669


Life & Disability Insurance


10/9/2020


Service Fee


$ 93.68


$ 93.68


Horizon Bank


10/9/2020


3925


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C3925


Communication Expense - OCT


10/13/2020


3941


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C3941


Business Internet Oct- 2020


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


10/1/2020


3608

Midwest Transit Equipment, Inc

General Fund 5960.0


$ 127,524.00


$ 127,524.00


C3608


2 BOC's 13 Ambulatory & 3 Wheel chairs-PCACS


10/1/2020


3607

Midwest Transit Equipment, Inc

General Fund 5960.0


$ 191,286.00


$ 191,286.00


C3607


3 BOC's 13 Ambulatory & 3 Wheel Chairs- PCACS


10/5/2020


B-4763


INPRS

General Fund 2149.0


$ 581.26


$ 581.26


C4763


Winters vacation payout - EmpPerf [NIRPC]


10/5/2020


3930


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3930


Rounding Adjustment 9/14 thru 9/27/2020-p/r


10/5/2020


3959

United HealthCare Srvc, Inc

General Fund 5142.9


$ 11,036.65


$ 11,036.65


C3959


ER paid Insurance - OCT


10/5/2020


3959

United HealthCare Srvc, Inc

General Fund 2152.0


$ 2,088.74


$ 2,088.74


C3959


EE w/h's Insurance - OCT


10/6/2020


Payroll


$ 34,495.61


$ 34,495.61


Pay period ending 9/27/2020


10/6/2020


Payroll


$ 3,260.68


$ 3,260.68


Pay period ending 9/27/2020- pay out James Winters


10/6/2020


B-4761


Federal & Fica

General Fund 2140.0


$ 366.84


$ 366.84


C4761


Winters vacation payout - FWT,empfica, empficamed-Federal Tax Withholdings Payable


10/6/2020


B-4761


Federal & Fica

General Fund 2142.0


$ 626.28


$ 626.28


C4761


Winters vacation payout - FWT, empfica, empficamed -Fica Tax Withholdings Payable


10/6/2020


B-4764


Federal & Fica

General Fund 2140.0


$ 4,475.51


$ 4,475.51


C4764


9/14-9/27 pay period -FWT,empfica, empficamed -Federal Tax Withholdings Payable


10/6/2020


B-4764


Federal & Fica

General Fund 2142.0


$ 6,894.90


$ 6,894.90


C4764


9/14-9/27 pay period -FWT,empfica, empficamed -FicaTax Withholdings Payable


10/6/2020


3920


Fidelity EyeMed Vision Ins

General Fund 2154.0


$ 99.01


$ 99.01


C3920


Vision Insurance


10/6/2020


B-4767


Horizon Bank

General Fund 2150.0


$ 415.38


$ 415.38


C4767


9/14-9/27 pay period - HAS


10/6/2020


B-4768


ICMA Retirement Fund-PR

General Fund 2146.0


$ 805.00


$ 805.00


C4768


9/14-9/27 pay period - ICMA


10/6/2020


3931


ICMA Retirement Fund-PR

General Fund 5145.9


$ 832.41


$ 832.41


C3931


ER paid for Ty Warner 9/14 thru 9/27/2020- p/r


10/6/2020


3933


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C3933


Recycle/Trash/Bldg. Maint. - OCT


10/7/2020


B-4766


INPRS

General Fund 2149.0


$ 5,803.18


$ 5,803.18


C4766


9/14-9/27 pay period - EmpPerf [NIRPC]


10/8/2020


3919


Anthem

General Fund 5143.9


$ 505.54


$ 505.54


2666


Life Insruance


10/8/2020


3923

Blachly, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,650.00


$ 1,650.00


2667


Legal Services


10/8/2020


3915


City of Portage

General Fund 5224.9


$ 1,972.68


$ 1,972.68


2668


Sewer/Water/Gas/Electric Utilities - Sept


10/8/2020


3922


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2668


Lease - OCT


10/8/2020


3916

Kansas City Life Insurance Co.

General Fund 5143.9


$ 877.54


$ 877.54


2669


Life & Disability Insurance


10/9/2020


Service Fee


$ 93.68


$ 93.68


Horizon Bank


10/9/2020


3925


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C3925


Communication Expense - OCT


10/13/2020


3941


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C3941


Business Internet Oct- 2020

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


10/14/2020


B-4717


IN Dept of Revenue

General Fund 2143.0


$ 1,501.60


$ 1,501.60


C4717


8/17-8/30/2020 pay period - LwtIN, SwtIN


10/14/2020


B-4739


IN Dept of Revenue

General Fund 2144.0


$ 323.81


$ 323.81


C4717


8/17-8/30/2020 pay period - LwtIN, SwtIN


10/14/2020


B-4739


IN Dept of Revenue

General Fund 2143.0


$ 1,464.88


$ 1,464.88


C4739


8/31-9/13/2020 pay period - LwtIN, SwtIN


10/14/2020


B-4739


IN Dept of Revenue

General Fund 2144.0


$ 318.35


$ 318.35


C4739


8/31/-9/13/2020 pay period - LwtIN, SwtIN


10/15/2020


3893


Amazon

General Fund 5430.9


$ 29.64


$ 29.64


C3893


Office Supplies


10/15/2020


3917


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


C3917


Stamps


10/15/2020


3918


Chicago Tribune

General Fund 5410.1


$ 27.72


$ 27.72


C3918


News paper subscription


10/15/2020


3921

Indiana Chapter of the American Planning Assoc.

General Fund 5410.3


$ 50.00


$ 50.00


C3921


APA-IN Economic Dev. Specialist /Job posting


10/15/2020


3924


Eventbrite

General Fund 5410.3


$ 40.00


$ 40.00


C3924


Ignite the Region 2 tickets


10/19/2020


3574

Midwest Transit Equipment, Inc

General Fund 5960.0


$ 69,788.00


$ 69,788.00


C3574


BOC buses 13+3 for NT


10/20/2020


Payroll


$ 34,510.91


$ 34,510.91


Pay period ending 10/11/2020


10/20/2020


B-4785


Federal & Fica

General Fund 2140.0


$ 4,477.92


$ 4,477.92


C4785


9/28-10/11/2020 pay period - Federal Tax Withholdings Pyable


10/20/2020


B-4785


Federal & Fica

General Fund 2142.0


$ 6,897.96


$ 6,897.96


C4785


9/28-10/11/2020 pay period - FICA Tax Withholdings Payable


10/20/2020


B-4788


Horizon Bank

General Fund 2150.0


$ 395.38


$ 395.38


C4788


9/28-10/11/2020 pay period -HAS


10/20/2020


B-4789


ICMA Retirement Fund-PR

General Fund 2146.0


$ 805.00


$ 805.00


C4789


9/28-10/11/2020 pay period - ICMA


10/20/2020


B-3947


ICMA Retirement Fund-PR

General Fund 5145.9


$ 832.41


$ 832.41


C3947


ER paid for Ty Warner 9/28 thru 10/11/2020- p/r


10/21/2020


3949


Basic

General Fund 5410.9


$ 360.00


$ 360.00


2672


Annually COBRA Administration


10/21/2020


3940


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2673


Office Cleaning - OCT


10/21/2020


3942

DeLage Landen Financial Service, Inc

General Fund 5243.9


$ 3,538.44


$ 3,538.44


C3942


IT-COMPUTER SERVICE/MAINT-SEPT


10/21/2020


3942

DeLage Landen Financial Service, Inc

General Fund 5244.9


$ 741.83


$ 741.83


C3942


TELEPHONE -SEPT


10/21/2020


3942

DeLage Landen Financial Service, Inc

General Fund 5241.9


$ 842.74


$ 842.74


C3942


COPIER-SEPT


10/21/2020


B-4787


INPRS

General Fund 2149.0


$ 5,803.18


$ 5,803.18


C4787


9/28-10/11/2020 pay period - EmpPerf [NIRPC]


10/21/2020


3948


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3948


Rounding Adjustment 9/28 thru 10/11/2020-pr


10/21/2020


3522


Possibiity Place Nursery

General Fund 5610.5


$ 14,120.00


$ 14,120.00


2674


Purchase Trees fro Communi Tree program


10/21/2020


3951


RailCats Baseball

General Fund 5410.5


$ 100.00


$ 100.00


2675


Nightly promotion -golf event


10/21/2020


3945


The Times of NW Indiana

General Fund 5410.1


$ 124.99


$ 124.99


2676


News paper subscription - Renewal


10/21/2020


3953


Treasurer of State

General Fund 5603.9


$ 33,065.00


$ 33,065.00


2677


SBOA Examinations 9/10-10/08/2020


10/21/2020


B-4769

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2678


9/14-9/27 pay period - United Way


10/21/2020


B-4790

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2678


9/28 -10/11/2020 pay period United Way


10/22/2020


3926


Edwards, Dominique

General Fund 5146.9


$ 280.00


$ 280.00


C3926


American Planning Association Expense


10/22/2020


3944


Hammond, Allen

General Fund 5410.2


$ 22.80


$ 22.80


C3944


Mileage-ADA perparation


10/22/2020


3943

Morneau Shepell BDA Limited

General Fund 5413.9


$ 750.00


$ 750.00


C3943


Emp. Assist. Program-Quarterly OCT/NOV/DEC

13


10/28/2020


3950


Ecointeractive

General 5610.2

Fund


$ 3,750.00


$ 3,750.00


C3950


TIP SAAS Service - OCT


10/30/2020


3972


City of Valparaiso

General 5960.0

Fund


$ 9,773.00


$ 9,773.00


C3972

Reimbursement for purchase of DoubleMap

Replacement Tablets for the GPS Fleet Tracking System


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


General


Fund


$ -


Total:

$ 611,057.94


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 $ 611,057.94



Dated this day of , 2020.


image


image

NORTHWESTERN INDIANA REGIONAL

PLANNING COMMISSION

6100 Southport Road

Portage, IN 46368

(219) 763-6060

image


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 74.75


$ 74.75


C3910


Ethyl Alcohol Wipes-CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 33.99


$ 33.99


C3910


Mutifold paper towels -CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 49.90


$ 49.90


C3910


Alcohol Wipes -CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ (20.00)


$ (20.00)


C3910


Coupon- Discount-CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 1,062.00


$ 1,062.00


2671


SLCCS - SEPT -CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 531.00


$ 531.00


2671


NT - SEPT-CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 472.00


$ 472.00


2671


PCACS - SEPT-CARES


10/14/2020


3935


City of Valparaiso

General Fund 5960.0


$ 15,423.00


$ 15,423.00


C3935

AeroClave Room Decontamination

System/Portable Applicator -Hand Sprayer/Misc. Equip


10/15/2020


3894


Amazon

General Fund 5430.9


$ 67.90


$ 67.90


C3894


Gel hand sanitizer-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 115.18


$ 115.18


C3894


T-Sign pedestal poster stand-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 19.99


$ 19.99


C3894


Rubber door stops-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 29.99


$ 29.99


C3894


Retractable ball point pens-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 399.90


$ 399.90


C3894


Standing automatic sanitizer-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 11.65


$ 11.65


C3894


Multi-purpose storage-CARES


10/22/2020


3957


City of Valparaiso

General Fund 5960.0


$ 6,900.00


$ 6,900.00


C3957


Liftmaster 14ft. HD MT5011 Commerical Trolley


General Fund


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 74.75


$ 74.75


C3910


Ethyl Alcohol Wipes-CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 33.99


$ 33.99


C3910


Mutifold paper towels -CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ 49.90


$ 49.90


C3910


Alcohol Wipes -CARES


10/8/2020


3910


Quill Corportation

General Fund 5430.9


$ (20.00)


$ (20.00)


C3910


Coupon- Discount-CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 1,062.00


$ 1,062.00


2671


SLCCS - SEPT -CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 531.00


$ 531.00


2671


NT - SEPT-CARES


10/8/2020


3934


RouteMatch Software, Inc

General Fund 5960.0


$ 472.00


$ 472.00


2671


PCACS - SEPT-CARES


10/14/2020


3935


City of Valparaiso

General Fund 5960.0


$ 15,423.00


$ 15,423.00


C3935

AeroClave Room Decontamination

System/Portable Applicator -Hand Sprayer/Misc. Equip


10/15/2020


3894


Amazon

General Fund 5430.9


$ 67.90


$ 67.90


C3894


Gel hand sanitizer-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 115.18


$ 115.18


C3894


T-Sign pedestal poster stand-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 19.99


$ 19.99


C3894


Rubber door stops-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 29.99


$ 29.99


C3894


Retractable ball point pens-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 399.90


$ 399.90


C3894


Standing automatic sanitizer-CARES


10/15/2020


3894


Amazon

General Fund 5430.9


$ 11.65


$ 11.65


C3894


Multi-purpose storage-CARES


10/22/2020


3957


City of Valparaiso

General Fund 5960.0


$ 6,900.00


$ 6,900.00


C3957


Liftmaster 14ft. HD MT5011 Commerical Trolley


General Fund

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


Total:

$ 25,171.25


Allowance of Claims


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

register such claims are hereby allowed in the total amount of $ 25,171.25


Dated this day of , 2020.


image


image

ADDENDUM TO EXECUTIVE DIRECTOR

EMPLOYMENT AGREEMENT


This addendum to the Executive Director Employment Agreement is entered into the 19th day of November, 2020, by and between the NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION,

hereinafter referred to as "NIRPC", and MR. TYSON WARNER, hereinafter referred to as "Executive Director", for purposes of establishing salary for the Executive Director during the third year (2021) of the current three year executive director employment agreement.

WHEREAS, NIRPC and the Executive Director entered into a three year employment agreement on the 15th day of November, 2018 which established the salary for the first year (2019) of the Executive Director Employment Agreement; and


WHEREAS, NIRPC and the Executive Director are desirous of establishing the Executive Director salary for the third year (2021) of the current Executive Director Employment Agreement.


NOW, THEREFORE, BE IT RESOLVED that the parties to this addendum hereby do mutually agree as follows:

  1. This addendum is intended by the parties so as to establish the Executive Director salary for the third year (2021) of the of the Executive Director Employment Agreement and in so doing comply with Section D of the current Executive Director Employment Agreement which provides that the Executive Director salary for the third year of the agreement shall be determined through discussions with the Executive Director and any salary increases shall be predicated upon positive performance evaluations, availability of funding and the approval of the Full NIRPC Commission

  2. That upon completion of the evaluation and performance criteria, NIRPC and Executive Director have mutually agreed to a 3% salary increase resulting in a 2021 calendar year salary of One Hundred Fifty-Six Thousand Seven Hundred Sixteen Dollars and 56/100 ($156,716.52). The Executive Director salary increase shall be effective as of January 1, 2021.

  3. Any and all other provisions of the current Executive Director Employment Agreement shall remain in full force and effect unless and until subsequent written modification.

This Addendum establishing an Executive Director salary for calendar year 2021 is approved by the Full Commission of the Northwestern Indiana Regional Planning Commission on this the 19th day of November, 2020.

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


By: Chairperson


ATTEST:


image image

Tyson Warner

image

RESOLUTION 20-29


A RESOLUTION OF THE NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION ADOPTING THE YEAR 2021 APPROPRIATION BUDGETS FOR THE COMMISSION’S GOVERNMENTAL FUNDS

WHEREAS, a budget is required for governmental funds; and


WHEREAS, it is anticipated that sufficient revenues and other financing sources will be available to support the budgets herein proposed; and


WHEREAS, it is the responsibility of the Commission, as a whole, to approve the appropriations budget of the Commission;


NOW THEREFORE BE IT RESOLVED, that the Commission adopt as its Year 2021 budget for the General Fund for the budget identified in Attachment A to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2021 budget for the Transit Capital Projects Funds the budget identified in Attachment B to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2021 budget for the Transit Operating Projects Funds the budget identified in Attachment C to this resolution; and


BE IT FURTHER RESOLVED, that the Commission adopt as its Year 2021 budget for the Revolving Loan Funds the budget identified in Attachment D to this resolution; and


BE IT FURTHER RESOLVED, that the Finance and Personnel Committee of the Commission be designated to oversee the administration of these budgets within the framework of more detailed budget guidelines it might establish.


Duly adopted by the Northwestern Indiana Regional Planning Commission this 19th day of November 2020.


image

Michael Griffin Chairperson


ATTEST:


image

Justin Kiel Secretary

FY 2021 BUDGET

ATTACHMENT A


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2021 GENERAL FUND APPROPRIATIONS BUDGET



PERSONNEL - SALARIES


1,565,254


PERSONNEL - FRINGE BENEFITS

629,254


OCCUPANCY

286,690


EQUIPMENT SERVICE/MAINTENANCE

85,006


DEPARTMENTAL

442,223


CONTRACTUAL

1,978,347


image

CAPITAL OUTLAYS - Equipment & Furniture 180,000


TOTAL FUND BUDGET

5,166,775

image


ATTACHMENT B


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2021 TRANSIT CAPITAL PROJECTS FUND APPROPRIATIONS BUDGET


image


CAPITAL OUTLAYS - TRANSIT EQUIPMENT 3,297,959

image

CARES ACT 2020 CAPITAL OUTLAYS - TRANSIT EQUIPMENT 1,008,732


TOTAL FUND BUDGET

4,306,691

image


ATTACHMENT C


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2021 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES 4,460,765

image

OTHER SERVICES AND CHARGES- CARES ACT 2020 2,694,048


TOTAL FUND BUDGET

7,154,813

image


ATTACHMENT D


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2021 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


image

OTHER SERVICES AND CHARGES 100,000


TOTAL FUND BUDGET

100,000


2021 CARES ACT 2020 REVOLVING LOAN FUND APPROPRIATIONS BUDGET



OTHER SERVICES AND CHARGES


530,000

.


NIRPC FY 2021 Budget


FY 2020 Budget


FY 2021 Budget

REVENUES

COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

869,119

1,994,419

STATE AGENCIES

1,955,395

2,504,813

LOCAL AGENCIES

44,694

37,050

NON-GOVERNMENTAL

85,318

52,338

INTEREST INCOME

9,862

37,885

TOTAL REVENUES

3,504,659

5,166,775

Attachment A


Change %


32%

NIRPC FY 2021 Budget


FY 2020 Budget


FY 2021 Budget

REVENUES

COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

869,119

1,994,419

STATE AGENCIES

1,955,395

2,504,813

LOCAL AGENCIES

44,694

37,050

NON-GOVERNMENTAL

85,318

52,338

INTEREST INCOME

9,862

37,885

TOTAL REVENUES

3,504,659

5,166,775

Attachment A


Change %


32%


EXPENDITURES

SALARY

FRINGE BENEFITS

FICA CONTRIBUTIONS

WORKERS COMPENSATION

UNEMPLOYMENT COMPENSATION

PERF CONTRIBUTIONS

HEALTH INSURANCE

LIFE & DISABILITY INSURANCE

ICMA CONTRIBUTIONS

STAFF DEVELOPMENT

EXPENDITURES

SALARY

FRINGE BENEFITS

FICA CONTRIBUTIONS

WORKERS COMPENSATION

UNEMPLOYMENT COMPENSATION

PERF CONTRIBUTIONS

HEALTH INSURANCE

LIFE & DISABILITY INSURANCE

ICMA CONTRIBUTIONS

STAFF DEVELOPMENT

1,476,381

1,565,254

1,476,381

1,565,254

CONTRACTUAL

LEGAL SERVICES

AUDIT & ACCOUNTING

LA PORTE RLF SERVICES

TRANSIT OVERSIGHT

ENVIRONMENTAL CONTRACTS

PLANNING

ALTERNATIVE FUEL

BOARD DEVELOPMENT

ECONOMIC DEVELOPMENT DISTRICT

ECONOMIC DEVEL DISTRICT RLF-CARES ACT

ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT

ORGANIZATIONAL DEVELOPMENT

E-TIP

CONTRACTUAL

LEGAL SERVICES

AUDIT & ACCOUNTING

LA PORTE RLF SERVICES

TRANSIT OVERSIGHT

ENVIRONMENTAL CONTRACTS

PLANNING

ALTERNATIVE FUEL

BOARD DEVELOPMENT

ECONOMIC DEVELOPMENT DISTRICT

ECONOMIC DEVEL DISTRICT RLF-CARES ACT

ECONOMIC DEVEL DISTRICT INSTITUT- CARES ACT

ORGANIZATIONAL DEVELOPMENT

E-TIP

19,800

22,200

22,000

38,000

2,000

2,000

11,300

17,347

529,374

837,300

-

320,000

70,991

-

2,000

2,000

70,000

550,000

136,000

2,000

2,000

45,000

51,500

774,465

1,978,347

61%

100,000

180,000

44%

3,504,658

5,166,775

32%

(0)

0

19,800

22,200

22,000

38,000

2,000

2,000

11,300

17,347

529,374

837,300

-

320,000

70,991

-

2,000

2,000

70,000

550,000

136,000

2,000

2,000

45,000

51,500

774,465

1,978,347

61%

100,000

180,000

44%

3,504,658

5,166,775

32%

(0)

0

FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

6%


112,943

119,742

7,000

9,500

2,000

3,000

186,983

200,012

220,000

230,000

24,000

24,000

25,000

23,000

20,000

20,000

597,926

629,254

5%

OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

225,500

231,000

6,500

6,500

18,540

18,540

29,757

30,650

280,297

286,690

2%

OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

225,500

231,000

6,500

6,500

18,540

18,540

29,757

30,650

280,297

286,690

2%


EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

19,400

20,370

40,440

43,736

18,000

18,900

1,000

2,000

78,840

85,006

7%

EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

19,400

20,370

40,440

43,736

18,000

18,900

1,000

2,000

78,840

85,006

7%

DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

ECONOMIC DEVELOPMENT DISTRICT

GENERAL USE SUPPLIES

41,500

41,500

60,000

299,000

15,000

25,000

28,650

25,255

1,000

1,000

28,000

28,000

15,600

3,700

-

11,768

7,000

7,000

196,750

442,223

56%

DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

ECONOMIC DEVELOPMENT DISTRICT

GENERAL USE SUPPLIES

41,500

41,500

60,000

299,000

15,000

25,000

28,650

25,255

1,000

1,000

28,000

28,000

15,600

3,700

-

11,768

7,000

7,000

196,750

442,223

56%

347,204

115,040

78,027

540,271

347,204

115,040

78,027

540,271

Attachment A page 2

NIRPC FY 2019 Revenue Detail

NIRPC FY 2019 Revenue Detail


COUNTY APPROPRIATIONS

LAKE COUNTY

PORTER COUNTY

LA PORTE COUNTY

TOTAL

FEDERAL AGENCIES

FTA OVERSIGHT

FTA CAPITAL

USDA FOREST SVC

BROWNFIELD GRANT

HOBART ZONING PROJECT

EDD

CAWS GLC

TOTAL

STATE AGENCIES

INDOT PL 2020

INDOT PL 2021

INDOT PL 2022

STBG

CMAQ 2021

CMAQ - FUEL

COUNTY APPROPRIATIONS

LAKE COUNTY

PORTER COUNTY

LA PORTE COUNTY

TOTAL

FEDERAL AGENCIES

FTA OVERSIGHT

FTA CAPITAL

USDA FOREST SVC

BROWNFIELD GRANT

HOBART ZONING PROJECT

EDD

CAWS GLC

TOTAL

STATE AGENCIES

INDOT PL 2020

INDOT PL 2021

INDOT PL 2022

STBG

CMAQ 2021

CMAQ - FUEL

357,000

141,700

55,000

429,517

30,000

917,822

63,380

1,994,419

357,000

141,700

55,000

429,517

30,000

917,822

63,380

1,994,419

559,000

768,000

766,313

51,500

360,000

-

559,000

768,000

766,313

51,500

360,000

-

TOTAL

LOCAL AGENCIES

CITY of PORTAGE

KRBC

PARTNERS for CLEAN AIR

FORUM

TOTAL

NON-GOVERNMENTAL

CALUMET LAND CONSERVATION PARTN.

ROOM RENTAL INCOME

SHARED ETHICS ADVISORY COMMISSION

TOTAL

INTEREST INCOME

BANK INTEREST INCOME

RLF INTEREST INCOME

TOTAL FY 2020 REVENUE

TOTAL

LOCAL AGENCIES

CITY of PORTAGE

KRBC

PARTNERS for CLEAN AIR

FORUM

TOTAL

NON-GOVERNMENTAL

CALUMET LAND CONSERVATION PARTN.

ROOM RENTAL INCOME

SHARED ETHICS ADVISORY COMMISSION

TOTAL

INTEREST INCOME

BANK INTEREST INCOME

RLF INTEREST INCOME

TOTAL FY 2020 REVENUE

2,504,813


1,800

24,000

10,500

750

37,050


48,500

1,838

2,000

52,338


3,000

34,885

5,166,775

Attachment B

NIRPC FY 2021 Budget


image


4,000

3,480

4,080

19,500

25,000

25,000

7,000

6,271

700

11,000

4,800

69,000

44,000

155,000

35,200

20,000

19,952

55,000

900

700

1,300

159,375

42,000

12,000

1,200

30,000

25,000


4,000

3,480

4,080

19,500

25,000

25,000

7,000

6,271

700

11,000

4,800

69,000

44,000

155,000

35,200

20,000

19,952

55,000

900

700

1,300

159,375

42,000

12,000

1,200

30,000

25,000

Grant Federal Req. Match Total

image


X012

16,000

X012

13,920

X667

16,320

X667

110,500

2016-033

100,000

2016-033

100,000

2016-033

28,000

2016-033

25,082

2016-033

2,800

2017-028

44,000

2017-028

19,200

2018-026

276,000

2018-026

176,000

2018-026

637,500

2019-029

140,800

2019-029

80,000

2019-029

59,857

2019-029

220,000

2019-029

3,600

2019-029

2,800

2019-029

5,200

2019-029

637,500

2019-030

168,000

2019-030

48,000

2019-030

4,800

2019-030

120,000

2019-030

100,000

X012

16,000

X012

13,920

X667

16,320

X667

110,500

2016-033

100,000

2016-033

100,000

2016-033

28,000

2016-033

25,082

2016-033

2,800

2017-028

44,000

2017-028

19,200

2018-026

276,000

2018-026

176,000

2018-026

637,500

2019-029

140,800

2019-029

80,000

2019-029

59,857

2019-029

220,000

2019-029

3,600

2019-029

2,800

2019-029

5,200

2019-029

637,500

2019-030

168,000

2019-030

48,000

2019-030

4,800

2019-030

120,000

2019-030

100,000

20,000

17,400

20,400

130,000

125,000

125,000

35,000

31,353

3,500

55,000

24,000

345,000

220,000

792,500

176,000

100,000

79,809

275,000

4,500

3,500

6,500

796,875

210,000

60,000

6,000

150,000

125,000

20,000

17,400

20,400

130,000

125,000

125,000

35,000

31,353

3,500

55,000

24,000

345,000

220,000

792,500

176,000

100,000

79,809

275,000

4,500

3,500

6,500

796,875

210,000

60,000

6,000

150,000

125,000

Architectual Services

Ticket Kiosks and On-Board fare boxes Security Cameras

Vehicles (2)

Security Camera & Lighting TOD Ground Improvements Support Vehicle Computers/Sound System Support Equipment

Support Vehicle

Rehab/Renovate - Admin Facility Replace 3 Revenue Vehicles Replace 2 Revenue Vehicles Replace 1 Communter Vehicle Replace 2 Revenue Vehicles Replace Staff Computers

Replace 4 Communter Vehicle Associated Transit Improv Tablets and Vehicle Devices Office Computer Equipment Office Computer Equipment Replace ChicaGO Dash Replace 2 Vehicle

Replace 1 Vehicle Computers

Replace Bus Stop Signs Transit Improvements


image image image

TOTAL 3,155,879 781,458 3,937,337

image image image


Contingency -


3,937,337

**

3,937,337

**

TOTAL BUDGET


image


**

new projects for 2021 not included

Attachment B


CY 2020 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Letting

Date

Total

Non-Federal

Funds

Federal Funds

NT

2020-039

Replace 2 Revenue Vehicles

$ 142,080

$ 23,680

$ 118,400

TOTAL BUDGET

$ 142,080

$ 118,400

Attachment B


CY 2021 CARES ACT 2020 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Total

Federal Funds

OE

CARES Act 2020-014

Bus Rolling Stock (3)

$ 202,008

$ 202,008

ECT

CARES Act 2020-014

Bus Washer

$ 10,000

$ 10,000

OE

CARES Act 2020-014

Garage Doors

$ 40,000

$ 40,000

Valpo

CARES Act 2020-014

Parking lot repair

$ 100,000

$ 100,000

ECT

CARES Act 2020-014

Support Vehicle (2)

$ 110,000

$ 110,000

NT

CARES Act 2020-014

Misc Support Equipment

$ 50,000

$ 50,000

OE

CARES Act 2020-014

Misc Support Equipment

$ 23,500

$ 23,500

PC

CARES Act 2020-014

Misc Support Equipment

$ 50,000

$ 50,000

Valpo

CARES Act 2020-014

Misc Support Equipment

$ 14,577

$ 14,577

ECT

CARES Act 2020-014

Misc Support Equipment

$ 99,525

$ 99,525

LCCS

CARES Act 2020-014

Misc Support Equipment

$ 15,000

$ 15,000

City of LaPorte

CARES Act 2020-014

Bus Replacements (2)

$ 143,200

$ 143,200

City of LaPorte

CARES Act 2020-014

Misc Support Equipment

$ 150,922

$ 150,922

TOTAL BUDGET

$ 1,008,732

$ 1,008,732

Attachment C

CY 2021 TRANSIT OPERATING PROJECTS FUND

image

image

Federal Req. Match Total


City of East Chicago

Preventative Maintenance

231,146

Complementary Paratransit

274,662

Operating Assistance

186,437

Existing Grants

337,216

57,787

68,665

186,437

337,216

288,933

343,327

372,874

674,431


City of East Chicago

Preventative Maintenance

231,146

Complementary Paratransit

274,662

Operating Assistance

186,437

Existing Grants

337,216

57,787

68,665

186,437

337,216

288,933

343,327

372,874

674,431


City of LaPorte

Operating Assistance

238,190

Existing Grants

204,640

238,190

204,640

476,380

409,279

City of LaPorte

Operating Assistance

238,190

Existing Grants

204,640

238,190

204,640

476,380

409,279


City of Valparaiso

Capital Cost of Contracting

764,584

City of Valparaiso

Capital Cost of Contracting

764,584

185,000 949,584


North Township

Preventative Maintenance

28,000

Operating Assistance

190,000

Existing Grants

116,282

7,000

190,000

116,282

35,000

380,000

232,564

North Township

Preventative Maintenance

28,000

Operating Assistance

190,000

Existing Grants

116,282

7,000

190,000

116,282

35,000

380,000

232,564


Opportunity Enterprises

Preventative Maintenance

102,000

Existing Grants

77,615

20,400

15,523

122,400

93,138

Opportunity Enterprises

Preventative Maintenance

102,000

Existing Grants

77,615

20,400

15,523

122,400

93,138


Porter County Community Services

Preventative Maintenance

95,000

Operating Assistance

82,936

Existing Grants

280,719

19,000

82,936

280,719

114,000

165,872

561,438

Porter County Community Services

Preventative Maintenance

95,000

Operating Assistance

82,936

Existing Grants

280,719

19,000

82,936

280,719

114,000

165,872

561,438


Southlake Community Services

Preventative Maintenance

115,000

Operating Assistance

194,960

Existing Grants

418,699

23,000

194,960

418,699

138,000

389,920

837,397

Southlake Community Services

Preventative Maintenance

115,000

Operating Assistance

194,960

Existing Grants

418,699

23,000

194,960

418,699

138,000

389,920

837,397


PMTF Funds (NT,SLCS,PCCS, OE & CV)

Public Mass Transportation Fund

522,681

-

522,681

PMTF Funds (NT,SLCS,PCCS, OE & CV)

Public Mass Transportation Fund

522,681

-

522,681


TOTAL

4,460,765 2,646,452 7,107,218

Attachment C

CY 2021 CARES ACT TRANSIT OPERATING PROJECTS FUND

image

image

Federal Total


City of East Chicago

Preventative Maintenance

10,000

Complementary Paratransit

30,000

Operating Assistance

66,403

10,000

30,000

66,403


City of East Chicago

Preventative Maintenance

10,000

Complementary Paratransit

30,000

Operating Assistance

66,403

10,000

30,000

66,403


City of LaPorte

Operating Assistance

52,204

City of LaPorte

Operating Assistance

52,204

52,204


City of Valparaiso

Capital Cost of Contracting

1,008,529

Operating

89,729

1,008,529

89,729

City of Valparaiso

Capital Cost of Contracting

1,008,529

Operating

89,729

1,008,529

89,729


North Township

Preventative Maintenance

10,000

Operating Assistance

50,000

10,000

50,000

North Township

Preventative Maintenance

10,000

Operating Assistance

50,000

10,000

50,000


Opportunity Enterprises

Operating Assistance

244,669

Preventative Maintenance

244,669

-

Opportunity Enterprises

Operating Assistance

244,669

Preventative Maintenance

244,669

-


Porter County Community Services

Preventative Maintenance

Operating Assistance

196,499

-

196,499

Porter County Community Services

Preventative Maintenance

Operating Assistance

196,499

-

196,499


Southlake Community Services

Preventative Maintenance

31,189

Operating Assistance

382,145

31,189

382,145

Southlake Community Services

Preventative Maintenance

31,189

Operating Assistance

382,145

31,189

382,145


PMTF Funds (NT,SLCS,PCCS, OE & CV)

Public Mass Transportation Fund

522,681

-

522,681

PMTF Funds (NT,SLCS,PCCS, OE & CV)

Public Mass Transportation Fund

522,681

-

522,681


TOTAL

2,694,048 2,694,048

Attachment D


image

image

CY 2021 LAPORTE COUNTY REVOLVING LOAN FUND


2019 2020

Budget Budget


New Loans

85,000

100,000

TOTAL

85,000

100,000

TOTAL BUDGET

100,000


image


Attachment D

t


7,800

2,000

9,800

Attachment D

t


7,800

2,000

9,800

LaPorte RLF 2020 Administration Budge


Per RLF Management Plan 50% of interest can be used for Administrative Cost

REVENUES

RLF INTEREST INCOME CLOSING CHARGES TOTAL REVENUES


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

2,500

2,025

2,400

6,925

EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

2,500

2,025

2,400

6,925


DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES

365

510

875

DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES

365

510

875

CONTRACTUAL

LA PORTE RLF SERVICES

2,000

2,000

CONTRACTUAL

LA PORTE RLF SERVICES

2,000

2,000


TOTAL EXPENSES 9,800


FUND BALANCE - ENDING -


Attachment D

CARES ACT RLF 2021 Administration Budget


Per RLF Management Plan 50% of interest can be used for Administrative Cost

REVENUES

EDD CARES ACT 2020

550,000

RLF INTEREST INCOME

25,085

CLOSING CHARGES

7,000

TOTAL REVENUES

582,085


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

18,000

14,580

16,380

48,960

EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

18,000

14,580

16,380

48,960


DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES

325

2,800

3,125

DEPARTMENTAL

COMMUNICATION

GENERAL USE SUPPLIES

325

2,800

3,125

CONTRACTUAL

LA PORTE RLF SERVICES

530,000

530,000

CONTRACTUAL

LA PORTE RLF SERVICES

530,000

530,000


TOTAL EXPENSES 582,085


FUND BALANCE - ENDING -

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles to be Disposed of at the 11/19/20 Vehicle Disposition Sale for ECT


NIRPC ID – EC016, AGENCY ID – EC2006A

Model & Year – 2006 Gillig 35’ Low Floor, diesel

Vehicle Type – 30 seat + 2 wheelchair positions, body on chassis bus Identification Number – 15GGB291861076416

Useful Life – 12 YEARS Met Useful life? - Yes

Purchase Payment Date – 6/12/06

Date Placed In Revenue Service – 6/12/06

Date Removed from Revenue Service – 5/18/20 FTA Grant Number – IN-90-X446

Purchase Price/Cost of each vehicle - $280,132.00 Federal Percentage – $224,106.00 (80%)

Local Percentage – $56,026.00 (20%)

Mileage when removed from revenue service – 381,429


NIRPC ID – EC017, AGENCY ID – EC2006B

Model & Year – 2006 Gillig 35’ Low Floor, diesel

Vehicle Type – 30 seat + 2 wheelchair positions, body on chassis bus Identification Number – 15GGB291X61076417

Useful Life – 12 YEARS Met Useful life? - Yes

Purchase Payment Date – 6/12/06

Date Placed In Revenue Service – 6/12/06

Date Removed from Revenue Service – 5/18/20 FTA Grant Number – IN-90-X467

Purchase Price/Cost of each vehicle - $280,132.00 Federal Percentage – $224,106.00 (80%)

Local Percentage – $56,026.00 (20%)

Mileage when removed from revenue service – 403,177


NIRPC ID – EC018, AGENCY ID – EC2007A

Model & Year – 2007 Gillig 35’ Low Floor, diesel

Vehicle Type – 30 seat + 2 wheelchair positions, body on chassis bus Identification Number – 15GGB291871077681

Useful Life – 12 YEARS Met Useful life? - Yes

Purchase Payment Date – 4/11/07

Date Placed In Revenue Service – 4/11/07

Date Removed from Revenue Service – 5/18/20 FTA Grant Number – IN-90-X489

Purchase Price/Cost of each vehicle - $281,967.00

P a g e 1 | 2

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles to be Disposed of at the 11/19/20 Vehicle Disposition Sale for ECT


Federal Percentage – $225,573.60 (80%) Local Percentage – $56,393.40 (20%)

Mileage when removed from revenue service – 383,908


NIRPC ID – EC019, AGENCY ID – EC2007B

Model & Year – 2007 Gillig 35’ Low Floor, diesel

Vehicle Type – 30 seat + 2 wheelchair positions, body on chassis bus Identification Number – 15GGB291X71077682

Useful Life – 12 YEARS Met Useful life? - Yes

Purchase Payment Date – 4/11/07

Date Placed In Revenue Service – 4/11/07

Date Removed from Revenue Service – 5/18/20 FTA Grant Number – IN-90-X489

Purchase Price/Cost of each vehicle - $281,967.00 Federal Percentage – $225,573.60 (80%)

Local Percentage – $56,393.40 (20%)

Mileage when removed from revenue service – 378,019


P a g e 2 | 2

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


NIRPC ID – SC112, AGENCY ID - 437

Model & Year – 2015 Ford E450, gasoline

Vehicle Type – 16 seats + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS6FDA00688

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 2/27/15

Date Placed In Revenue Service – 2/4/15

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X609

Purchase Price/Cost of each vehicle –$53,694.00 Federal Percentage – $42,955.00 (80%)

Local Percentage – $10,739.00 (20%)

Mileage when removed from revenue service – 116,812


NIRPC ID – SC113, AGENCY ID - 438

Model & Year – 2015 Ford E450, gasoline

Vehicle Type – 16 seats + 2 wheelchair positions, body on chassis van Identification Number – 1FDFE4FS4FDA00687

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 2/27/15

Date Placed In Revenue Service – 2/4/15

Date Removed from Revenue Service – 1/21/20 FTA Grant Number – IN-90-X609

Purchase Price/Cost of each vehicle –$53,694.00 Federal Percentage – $42,955.00 (80%)

Local Percentage – $10,739.00 (20%)

Mileage when removed from revenue service – 137,041


NIRPC ID – SC440, AGENCY ID – 440

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 13 seats + 3 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS0GDC55077

Useful Life – 4 YEARS Met Useful life? – Yes

Purchase Payment Date – 7/8/16

Date Placed In Revenue Service – 6/30/16

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle –$60,585.50

P a g e 1 | 6

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


Federal Percentage – $51,498.00 (85%) Local Percentage – $9,087.50 (15%)

Mileage when removed from revenue service – 92,958


NIRPC ID – SC441, AGENCY ID – 441

Model & Year – 2016 Ford E450, propane

Vehicle Type – 13 seat + 3 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS2GDC55078

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 7/8/16

Date Placed In Revenue Service – 6/30/16

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle –$60,585.50 Federal Percentage – $51,498.00 (85%)

Local Percentage – $9,087.50 (15%)

Mileage when removed from revenue service – 80,451


NIRPC ID – OE100, AGENCY ID – 01

Model & Year – 2012 Ford E450, propane

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS6CDA29166

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 11/3/11

Date Placed In Revenue Service – 10/13/11 Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X609

Purchase Price/Cost of each vehicle - $57,673.00 Federal Percentage – $46,139.00 (80%)

Local Percentage – $11,535.00 (20%)

Mileage when removed from revenue service – 201,992


NIRPC ID – OE101, AGENCY ID – 03

Model & Year – 2013 Ford E450, gasoline

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS7DDA40002

Useful Life – 4 YEARS Met Useful life? - Yes

P a g e 2 | 6

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


Purchase Payment Date – 5/17/13

Date Placed In Revenue Service – 4/9/13

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X636

Purchase Price/Cost of each vehicle - $58,479.00 Federal Percentage – $46,783.00 (80%)

Local Percentage – $11,696.00 (20%)

Mileage when removed from revenue service – 176,726


NIRPC ID – OE08, AGENCY ID – 08

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS4GDC55096

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 8/29/16

Date Placed In Revenue Service – 8/11/16

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle - $60,124.50 Federal Percentage – $51,106.00 (80%)

Local Percentage – $9,018.50 (20%)

Mileage when removed from revenue service – 214,702


NIRPC ID – PC057, AGENCY ID – 57

Model & Year – 2008 Chevy Braun Passenger Van, gasoline Vehicle Type – 6 seat + 2 wheelchair positions, minivan Identification Number – 1GBDV13W28D211752

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 2/18/09

Date Placed In Revenue Service – 2/18/09

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X547

Purchase Price/Cost of each vehicle - $33,283.00 Federal Percentage – $26,626.00 (80%)

Local Percentage – $6,657.00 (20%)

Mileage when removed from revenue service – 86,961



P a g e 3 | 6

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


NIRPC ID – PC105, AGENCY ID – 72

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS5GDC04190

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 8/21/15

Date Placed In Revenue Service – 8/16/15

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle - $53,679.20 Federal Percentage – $45,627.00 (85%)

Local Percentage – $8,052.20 (15%)

Mileage when removed from revenue service – 120,098


NIRPC ID – PC106, AGENCY ID – 73

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS7GDC04191

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 8/21/15

Date Placed In Revenue Service – 8/6/15

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle - $53,679.20 Federal Percentage – $45,627.00 (85%)

Local Percentage – $8,052.20 (15%)

Mileage when removed from revenue service – 109,778


NIRPC ID – PC107, AGENCY ID – 74

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 12 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS9GDC04192

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 8/21/15

Date Placed In Revenue Service – 8/6/15

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle - $53,697.20

P a g e 4 | 6

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


Federal Percentage – $45,627.00 (85%) Local Percentage – $8,052.20 (15%)

Mileage when removed from revenue service – 123,660


NIRPC ID – PC75, AGENCY ID – 75

Model & Year – 2016 Ford E450, gasoline

Vehicle Type – 13 seat + 3 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS7GDC55108

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 8/2/16

Date Placed In Revenue Service – 7/13/16

Date Removed from Revenue Service – 11/3/20 FTA Grant Number – IN-90-X667

Purchase Price/Cost of each vehicle - $62,565.50 Federal Percentage – $53,180.00 (85%)

Local Percentage – $9,385.50 (15%)

Mileage when removed from revenue service – 110,745


NIRPC ID – NT019, AGENCY ID – 19

Model & Year – 2015 Ford E450, gasoline

Vehicle Type – 16 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS8FDA02944

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 2/27/15

Date Placed In Revenue Service – 2/6/15

Date Removed from Revenue Service – 9/15/20 FTA Grant Number – IN-90-X035

Purchase Price/Cost of each vehicle - $53,470.00 Federal Percentage – $53,470.00 (100%)

Local Percentage – $0.00 (0%)

Mileage when removed from revenue service – 77,450


NIRPC ID – NT020, AGENCY ID – 20

Model & Year – 2015 Ford E450, gasoline

Vehicle Type – 16 seat + 2 wheelchair positions, body on chassis bus Identification Number – 1FDFE4FS3FDA02947

Useful Life – 4 YEARS Met Useful life? - Yes

Purchase Payment Date – 2/27/15

P a g e 5 | 6

F & P Committee Meeting – November 19, 2020 Northwestern Indiana Regional Planning Commission (NIRPC)


List of Vehicles Disposed of at the 11/18/20 Vehicle Disposition Sale


Date Placed In Revenue Service – 2/6/15

Date Removed from Revenue Service – 10/23/20 FTA Grant Number – IN-90-X035

Purchase Price/Cost of each vehicle - $53,470.00 Federal Percentage – $53,470.00 (100%)

Local Percentage – $0.00 (0%)

Mileage when removed from revenue service – 79,514


P a g e 6 | 6