image

6100 Southport Road

Portage, Indiana 46368

(219) 763-6060

www.nirpc.org


FINANCE AND PERSONNEL COMMITTEE

Meeting Agenda

Thursday, October 15, 2020 -- 8:00 a.m.


Google Meet Computer login Meeting ID: meet.google.com/jkh-vweq-pju If calling in, Phone Number: (US)+1 432-756-7168 PIN: 671 580 106#


  1. Call to Order


  2. Meeting Minutes of September 17, 2020


  3. Review of Financial Status – September 2020

    1. Bank Statement Reconciliation

    2. Expenses YTD September 2020 – Budget vs Actual

    3. Revenue YTD September 2020 – Budget vs Actual

      Pages 1-3


      Pages 4-12


  4. Approval of Claims Register General Fund– Sept 2020 Pages 13-15

    ACTION REQUESTED: Approval


  5. Approval of Claims Register – CARES Funds- Sept 2020 Pages 16

    ACTION REQUESTED: Approval


  6. Budget Amendment #4 Pages 17

    ACTION REQUESTED: Approval


  7. FY 2021 NIRPC preliminary budget Pages 18-28


  8. Personnel update


  9. Other Business


  10. Adjournment


The next meeting is scheduled for November 19, 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

September 17, 2020

Google Meet Virtual Meeting – 8:00 a.m.


Members Present

Richard Hardaway, Bob Carnahan, Justin Kiel, George Topoll Staff and Others Present

Ty Warner, Talaya Jones, Kathy Luther, Lisa Todd, Stephanie Kuziela, Gabrielle Biciunas, 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 July 16, 2020 meeting were presented. Bob Carnahan made motion and Justin Kiel seconded to approve the minutes. A roll call vote was taken with Bob Carnahan, Richard Hardaway and Justin Kiel voting in the affirmative, and no one voting in the negative. Motion passed 3-0. George Topoll was present, but was unable to vote due to technical difficulties.


Review of Financial Status – July 2020

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

$794,613.57 with a closing balance of $1,245,869.13 as of 7/31/2020. The RLF account beginning balance from 7/1/2020 was $127,940.23 with a closing balance of $131,429.57 as of 7/31/2020.


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

$750,895 has been expended of the $1,489,490 Salaries budget. $289,510 has been expended of the $574,817 Fringe Benefits budget. $159,485 has been expended of the $280,297 Occupancy budget. $33,903 has been expended of the $78,840 Maintenance budget. $68,890 has been expended of the $196,750 Departmental budget. $206,362 has been expended of the $884,465 Contractual budget. $350 has been expended of the $100,000 Capital Outlays budget. Total General Fund expenditures were $1,509,396 of the $3,604,659 budgeted. $200 has been expended of the

$85,000 LaPorte Revolving Loan Fund budget. $1,754,014 has been expended of the $2,440,988 Transit Capital Fund budget. $1,297,427 has been expended of the $4,389,036, 2019 Transit Operating Fund budget. Year to date, all categories are under budget, with total expenditures of

$4,561,036 of the $10,519,683 budgeted, $5,958,647 under budget.


Talaya presented the year to date July 2020 expended by category chart. 50% of the expended budget was salaries, 19% fringe benefits, 14% contractual, 11% occupancy, 4% departmental and 2% maintenance.


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

$540,271 county appropriations budget has been collected. $164,505 of the $869,119 federal agencies budget has been collected. $969,371 of the $1,935,395 state agencies budget has been collected. $15,181 of the $44,694 local agencies budget has been collected. $743 of the $135,318 non-governmental funds budget has been collected. $0 of the $70,000 Economic Development District budget has been collected. $4,294 of the $9,682 interest income budget has been collected. Justin Kiel questioned the timing of Economic Development District collections. Talaya indicated there will be collections in September.


Talaya presented the year to date revenue by funding source as of July 31. 64% of collected revenue has been from state agencies, 24% from county appropriations, 11% from federal agencies and 1% from local agencies.

Approval of Claims Register – July 2020

Talaya presented the July 2020 claims register totaling $372,818.96 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the claims register. Bob Carnahan questioned a $44.64 service fee payment. Talaya explained it was a bank service charge. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 4-0.


Review of Financial Status – August 2020

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

$1,245,869.13 with a closing balance of $1,582,046.34 as of 8/31/2020. The RLF account beginning balance from 8/1/2020 was $131,429.57 with a closing balance of $137,432.15 as of 8/31/2020.


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

$769,971 has been expended of the $1,489,490 Salaries budget. $334,783 has been expended of the $574,817 Fringe Benefits budget. $181,787 has been expended of the $280,297 Occupancy budget. $39,316 has been expended of the $78,840 Maintenance budget. $90,999 has been expended of the $196,750 Departmental budget. $214,162 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,637,755 of the $3,604,659 budgeted. $200 has been expended of the $85,000 LaPorte Revolving Loan Fund budget. $1,754,014 has been expended of the

$2,440,988 Transit Capital Fund budget. Year to date, all categories are under budget, with total expenditures of $4,561,036 of the $10,519,683 budgeted, $5,958,647 under budget.


Talaya presented the year to date August 2020 expended by category chart. 48% of the expended budget was salaries, 21% fringe benefits, 14% contractual, 11% occupancy, 6% departmental and 2% maintenance.


Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual expenditures year to date, August 2020. Per the State Board of Accounts, the CARES Act and general funds must be reported separately. $80,797 of the $236,733 has been expended of the Salaries budget. $0 of $5,000 contractual, RLF Services, budget has been expended. $0 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 General Fund Expenditures of $82,957 had been expended from the $431,733 budget. $0 for the $583,000 CARES Revolving Loan Fund budget has been expended. $2,065 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.


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

$540,271 county appropriations budget has been collected. $172,339 of the amended $539,733 federal agencies budget has been collected. $1,118,692 of the $1,935,395 state agencies budget has been collected. $15,181 of the $44,694 local agencies budget has been collected. $7,613 of the

$135,318 non-governmental funds budget has been collected. $0 of the $70,000 Economic Development District budget has been collected. $5,767 of the $9,682 interest income budget has been collected.


Talaya presented the year to date revenue by funding source chart as of August 31. 66% of collected revenue has been from state agencies, 22% from county appropriations, 10% from federal agencies and 1% from local agencies.


Talaya presented the Coronavirus Aid, Relief and Economic Securities (CARES) Act budget to actual revenue year to date, August 2020. All revenue is federal and is classified as Economic Development

District or FTA. $176,581 has been collected of the $604,229 total CARES Act revenue budget.


Approval of Claims Register – August 2020

Talaya presented the August 2020 claims register totaling $1,633,220.65 to the Committee for approval. Bob Carnahan made motion and Justin Kiel seconded to approve the August 2020 claims register of $1,633,220.65. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 4- 0.


NIRPC Resolution 20-25 Amending the Management Plan for the LaPorte County Revolving Loan Fund Gabrielle Biciunas presented Resolution 20-25 to amend the LaPorte County Revolving Loan Fund Management Plan. Under the CARES Act, the Economic Development Administration (EDA) is relaxing certain policies and providing greater flexibility to allow the RLF program to help address the COVID- 19 impact on small businesses. The changes were already approved by both the LaPorte County RLF Board and EDA. Justin Kiel asked which policies were being relaxed. Gabrielle explained the 2 requirements being temporarily waived until May 6, 2021 are the requirement to leverage additional capital and the requirement of evidence demonstrating credit is not otherwise available. Bob Carnahan motioned and Justin Kiel seconded to send a favorable recommendation of Resolution 20- 25 to the Executive Board for approval. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no one voting in the negative. Motion passed 4-0.


NIRPC Resolution 20-26 Adopting a Management Plan for a Regional Revolving Loan Fund for Lake, Porter and LaPorte Counties

Gabrielle Biciunas presented Resolution 20-26 to approve and adopt the Regional Revolving Loan Fund Management Plan for Lake, Porter and LaPorte Counties. NIRPC received $583k from the EDA CARES Act Recovery Assistance Grant to capitalize and administer a Revolving Loan Fund to make loans available to small businesses that have been impacted by the coronavirus. An approved RLF Management Plan is necessary for the Commission to administer the RLF. Bob Carnahan motioned and Justin Kiel seconded to recommend Resolution 20-26 to the NIRPC Executive Board for approval. A roll call vote was taken with Bob Carnahan, Richard Hardaway, Justin Kiel and George Topoll voting in the affirmative, and no on voting in the negative. Motion passed 4-0.


Personnel updates

Meredith Stilwell reported that NIRPC’s Transit Planner, James Winters’s, last day was September 4th. Leadership is assessing the position to determine how best to move forward before posting for the job. Ty stated that James was moving to the Economic Development Administration. The Director of Transportation will be posted, but a date for the posting has yet to be determined. NIRPC currently has 2 CARES Act grant funded Economic Development District positions open, the Economic development Specialist and Communications Specialist and the Programming and Grants Assistant position remains open.


Other Business

Ty reminded the Committee that the Executive Board meeting will be a Zoom call and will be accessed using a different link. Richard informed the Committee that there is an exit interview with the State Board of Accounts at 11:30 a.m.

Talaya stated that the 2021 preliminary budget will be presented at the next meeting. Adjournment

There being no further business, the meeting was adjourned.


image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/05/2020 @ 1:51 PM

Reconciliation - General

Page:



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

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

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

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

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

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

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

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

image

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


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

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

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

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


8/31/2020


9/10/2020

9/30/2020

9/30/2020


9/30/2020


1,582,046.34

421,573.98

690,947.65

0.00

0.00

46.60

170.70

1,312,796. 77 gQ_,

0.00


1,301,892.09

(10,904.68)

0.00

1,312,796.77


image

Date Reference Deposit Description

8/08/2019 8272335 1/2 August 2019 RLF payment

Date Reference Deposit Description

8/08/2019 8272335 1/2 August 2019 RLF payment

Total Unmarked Deposits: -269.64


Total Deposits:

- 26 9.64 v

image

Amount I

-269.64

Amount I

-269.64

Date 7/02/2019

Check 0002363

To

Kelly Tripp

Check Description

Refund fee for tree steward workshop

Amount

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/09/2020

0002648

Anthem BCBS

Life Insurance - Sept

502.84

9/23/2020

0002655

Auto-Owners Insurance

Workers Comp. Audit-Sept 2020

54.00

9/23/2020

0002659

Mile-X Equipment, Inc

Emerson Model TC-24A Filter Crusher

2,307.00

9/23/2020

0002660

Nat'I Assoc . of Regional Councils

2020 Executive Directors Confernece 10/5-

250.00


9/23/2020


0002663

Total Unmark


South Shore Clean Cities, Inc.

ed Checks: 10,635.04

6/2020

Publication/Billboard CMAQ - Aug 2020 ------2,2-00.00

Total Checks : 10,635.04

Date 7/02/2019

Check 0002363

To

Kelly Tripp

Check Description

Refund fee for tree steward workshop

Amount

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/09/2020

0002648

Anthem BCBS

Life Insurance - Sept

502.84

9/23/2020

0002655

Auto-Owners Insurance

Workers Comp. Audit-Sept 2020

54.00

9/23/2020

0002659

Mile-X Equipment, Inc

Emerson Model TC-24A Filter Crusher

2,307.00

9/23/2020

0002660

Nat'I Assoc . of Regional Councils

2020 Executive Directors Confernece 10/5-

250.00


9/23/2020


0002663

Total Unmark


South Shore Clean Cities, Inc.

ed Checks: 10,635.04

6/2020

Publication/Billboard CMAQ - Aug 2020 ------2,2-00.00

Total Checks : 10,635.04

I


image


image

Trial Balance - Cash

Run: 10,os,2020 at 1:s:fl'QRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 9/30/2020


Page: 1



All

1.1.001.0000.1010.0 Cash

Total


Balance

image

1,301,892.09

1,3 01,892 .09


image image


image

image


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

Run: 10/05/2020@ 1:50 PM

Reconciliation - Revolving Loan Fund

Page:

Run: 10/05/2020@ 1:50 PM

Reconciliation - Revolving Loan Fund

Page:



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

8/31/2020

137,432.15

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

4,581.24

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

0.00

O Adjustments Totaling.............................................................................................

0.00

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

0.00

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

0.00

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

9/30/2020

11.45

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

9/30/2020

142,024.84

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

0.00

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

9/30/2020

142,024.84

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

0.00

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

0.00

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

142,024.84


image


image


image

Trial Balance - Cash

Run: 1010512020 at 1:56"t'QRTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

For 9/30/2020


Page: 1



All

2.3.050.0000.1010.0 Cash

Total


Balance 142,024.84

image

·ti

·ti

142,024.84


sp

sp

s1t) 1? 1\.

JO


image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2020



Line Items


FY 2020 Budget

FY 20

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


Salaries

5020-1

Total Salaries

1,293,260

863,443 106,502 11% 33%

Salaries Sub-Total

1,293,260

image

863,443 106,502 11% 33%


Fringe Benefits

5121-9

FICA Contributions

104,321

70,557 7,684 10% 32%

5122-9

Workers Compensation

6,100

2,950 1,625 36% 52%

5123-9

Unemployment Compensation

1,650

1,092 146 12% 34%

5141-9

PERF Contributions

159,118

119,000 339 0% 25%

5142-9

Health Insurance

170,501

132,833 (4,958) -4% 22%

5143-9

Life & Disability Insurance

23,000

13,066 4,184 24% 43%

5145-9

ICMA

25,000

15,779 2,971 16% 37%

5146-9

Staff Development

20,000

3,471 11,529 77% 83%

Fringe Benefits Sub-Total

509,690

image

358,747 23,520 6% 30%


Occupancy

5221-9

Office Lease

225,500

168,977 148 0% 25%

5222-9

Property Insurance

6,500

4,901 (26) -1% 25%

5223-9

Building Maintenance

18,540

13,724 181 1% 26%

5224-9

Utilities

29,757

16,439 5,879 26% 45%

Occupancy Sub-Total

280,297

image

204,040 6,183 3% 27%


Maintenance

5241-9

Copier Leasing/Maintenance

19,400

1,895 12,655 87% 0%

5243-9

Computer Service/Maintenance

40,440

34,161 (3,831) -13% 0%

5244-9

Telephone Service/Maintenance

18,000

8,459 5,041 37% 0%

Combined Copier/IT/Phone Service/Maintenance

77,840

image

44,515 13,865 24% 43%

5249-9

Other Equipment Maintenance

1,000

image

214 536 71% 79%

Maintenance Sub-Total

78,840

image

44,729 14,401 24% 43%

image

Departmental

5410-1

Communications: Commission/Ex. Dir.

41,500

10,793 20,332 65% 74%

5410-2

Communications: Transportation

60,000

16,738 28,262 63% 72%

5410-4

Communications: Subgrantee Management

15,000

260 10,990 98% 98%

5410-5

Communications: Environmental Programs

28,650

16,343 5,144 24% 43%

5410-8

Communications: Partner Agency

1,000

716 34 5% 28%

5410-9

Communications: Allocated Functions

28,000

14,031 6,969 33% 50%

5420-5

Promotional Expenses: Environmental Programs

15,600

17,405 (5,705) -49% -12%

5430-9

General Use Supplies Expense

7,000

15,569 (10,319) -197% -122%

Departmental Sub-Total

196,750

image

91,855 55,708 38% 53%


Contractual

5602-9

Legal Services

19,800

14,850 0 0% 25%

5603-9

Audit and Accounting

22,000

0 16,500 100% 100%

5604-9

LaPorte RLF Services

2,000

0 1,500 100% 100%

5610-4

Transit Oversight

11,300

600 7,875 93% 95%

5610-5

Environmental Projects

569,374

237,292 189,738 44% 58%

5610-5

Alternative Fuel

70,991

0 53,243 100% 100%

5619-9

Organizational Dev.

2,000

0 1,500 100% 100%

5610-0

Board Development

2,000

0 1,500 100% 100%

5610-2

E-Tip

45,000

33,750 0 0% 25%

Economic Development District

140,000

0 105,000 100% 100%

Contractual Sub-Total

884,465

image

286,492 376,856 57% 68%


Capital Outlays

5910-0

Furniture and Equipment

100,000

6,736 68,264 91% 93%

Capital Outlays Sub-Total

100,000

image

6,736 68,264 91% 93%



TOTAL GENERAL FUND EXPENDITURES

3,343,302

1,856,042 651,435

26% 44%


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,216,483

Transit Capital Fund

2,440,988

2,216,483

224,505 9%


2019 Transit Operating Fund

4,389,036 1,624,977

2,764,059

63%

TOTAL EXPENDITURES

10,258,326 5,697,701

4,560,625

44%



image

YTD September 2020 Expenses Budget vs Actual


1,000,000


969,945

900,000CARES FUND EXPENDITU8R63E,S443

800,000

700,000

600,000

500,000

400,000

300,000

200,000

100,000

-


382,268


358,747


210,223


204,040


59,130


147,563

91,855

44,729


663,349


286,492


image

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

Salaries

Fringe Benefits Occupancy Maintenance Departmental

Contractuals

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

SALARIES

FRINGE BENEFITS

OCCUPANCY

MAINTENANCE

DEPARTMENTAL

CONTRACTUALS

YTD September Budget YTD September Expended


YTD September 2020 Expended by Category

YTD September 2020 Expended by Category


16%

16%


5%

2%

47%

5%

2%

47%


11%

11%


19%

19%


9

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL EXPENDITURES REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2020



Line Items


FY 2020 Budget


YTD September Expended

FY 20

Budget % balance

NIRPC CARES EXPENDITURES

Salaries

Salaries

236,733

92,504

61%

Salaries Sub-Total

236,733

92,504

-

61%


Contractual

RLF Services

5,000

-

Contractual Sub-Total

5,000

-

100%

100%

Contractual

RLF Services

5,000

-

Contractual Sub-Total

5,000

-

100%

100%


Departmental

Communications

500

103

PPE Supplies

25,000

-

Departmental Sub-Total

25,000

103

Capital Outlays

79%

100%

100%

Departmental

Communications

500

103

PPE Supplies

25,000

-

Departmental Sub-Total

25,000

103

Capital Outlays

79%

100%

100%


Furniture and Equipment

165,000

2,160

Capital Outlays Sub-Total

165,000

2,160

99%

99%

Furniture and Equipment

165,000

2,160

Capital Outlays Sub-Total

165,000

2,160

99%

99%



TOTAL NIRPC CARES FUND EXPENDITURES

431,733

94,766 78%


CARES Revolving Loan Fund

583,000

-


CARES Transit Capital Fund

1,219,972

6,437


image

image

CARES Transit Agency Fund 4,314,322 1,092,610


TOTAL EXPENDITURES

6,549,027

1,193,813



YTD September 2020 Expenses Budget vs Actual

YTD September 2020 Expenses Budget vs Actual


250,000

236,733

250,000

236,733


200,000

200,000


165,000

165,000


150,000

150,000


100,000

92,504

100,000

92,504


50,000

25,000

50,000

25,000


5,000

-

103

2,160

5,000

-

103

2,160


-

-


SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS

SALARIES

CONTRACTURAL

DEPARTMENTAL

CAPITAL OUTLAYS


Budget Expended

Budget Expended




Line Items


FY 2020

Budget

YTD FY 20

SEPTEMBER 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,246 (215,554) -53% 65%

1.1.4310

State Agencies

1,935,395

1,233,857 (217,689) -15% 36%

1.1.4410

Local Agencies

44,694

24,224 (9,297) -28% 46%

1.1.4610

Non-Governmental

135,318

11,051 (90,437) -89% 92%

1.3.4260

Economic Development District

70,000

13,288 (39,212) -75% 81%

1.1.4800

Interest Income

9,862

6,788 (609) -8% 31%

Revenue Total

3,275,273

image

1,845,122 (206,129) -10% 44%


image

image

image

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2020

NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2020

Revenue by Funding Source as of September 30, 2020


1%

1% 1% 0%


20%


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

10%


67%

CARES

Economic Development District

CARES

Economic Development District

image


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION

BUDGET TO ACTUAL REVENUE REPORT JANUARY 1 THROUGH SEPTEMBER 30, 2020



Line Items


FY 2020

Budget


YTD September Collected

FY 20

Budget % balance

CARES ACT FTA Revenue

Operating Revenue

419,386

202,943

52%

Capital Revenue

125,000

0

100%

CARES ACT EDA

Economic Development District

59,843

0

100%

Revenue Total

604,229

202,943

66%


Revenue by Funding Source as of September 31, 2020


0%


100%

Revenue by Funding Source as of September 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


09/012020


3572

Midwest Transit Equipment, INC

General Fund 5960.0


$ 196,125.00


$ 196,125.00


C3572

3 BOC buses- 8 ambulatory passenger seats+ 3 wheelchair positions--Opportunity Enterprises


9/1/2020


3835


Wex Bank

General Fund 5410.2


$ 51.66


$ 51.66


C3835


Vehicle Gas - August


9/2/2020


3932


De Lage Landen Fin.

General Fund 5243.9


$ 3,538.44


$ 3,538.44


C3932


IT Services - Aug


9/2/2020


3932


De Lage Landen Fin.

General Fund 5244.9


$ 741.83


$ 741.83


C3932


Telephone Services- Aug


9/2/2020


3932


De Lage Landen Fin.

General Fund 5241.9


$ 842.74


$ 842.74


C3932


Copier Services- Aug


9/8/2020


B-4716


Federal & Fica

General Fund 2140.0


$ 4,622.89


$ 4,622.89


C4716


Federal Tax Withholdings Payable


9/8/2020


B-4716


Federal & Fica

General Fund 2142.0


$ 7,241.76


$ 7,241.76


C4716


FICA Tax Withholdings Payable


9/8/2020


B-4719


Horizon Bank


General Fund


$ 365.38


$ 365.38


C4719


8/17-8/30/2020 pay period HAS


9/8/2020


B-4720


ICMA Retirement Fund-PR


General Fund


$ 805.00


$ 805.00


C4720


8/17-8/30/2020 -pay period - ICMA


9/8/2020


3892


ICMA Retirement Fund-PR


General Fund


$ 832.41


$ 832.41


C3892


ER paid for Ty Warner 8/17 thru 8/30/2020 - p/r


9/8/2020


Payroll


$ 36,357.14


$ 36,357.14


Pay period ending 8/30/2020


9/9/2020


3887


Anthem BCBS

General Fund 5143.9


$ 502.84


$ 502.84


2648


Life Insuranc - Sept


9/9/2020


3883

Blachy, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,650.00


$ 1,650.00


2649


Legal Services - Sept


9/9/2020


3886


Chicago Tribune

Gerneral Fund 5410.4


$ 27.72


$ 27.72


C3886


News Paper Subscription - Sept


9/9/2020


3884


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2650


Office Lease - Sept


9/9/2020


3885


City of Portage

General Fund 5224.9


$ 1,978.50


$ 1,978.50


2650


Sewer/Water/Gas/Electric Service -August


9/9/2020


3874


Engraveables

General Fund 5410.5


$ 198.00


$ 198.00


C3874


Laser Engraved Apex Seiers Clear Acrylic Awards- P4CA


9/9/2020


3838


Impact Networking LLC

General Fund 5430.9


$ 229.65


$ 229.65


2651


Office Supplies- Paper


9/9/2020


B-4626


IN Dept of Revenue

General Fund 2143.0


$ 1,494.67


$ 1,494.67


C4626


7/20-8/2/2020 pay period - LwtIN, SwtIN - State Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2144.0


$ 322.74


$ 322.74


C4626


7/20-8/2/2020 pay period - LwtIN, SwtIN - Local Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2143.0


$ 1,494.67


$ 1,494.67


C4652


8/3-8/16/2020 pay period - LwtIN, SwtIN - State Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2144.0


$ 322.74


$ 322.74


C4652


8/3-8/16/2020 pay period - LwtIN, SwtIN - Local Tax Withholdings Payable


9/9/2020


3891


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3891


Rounding Adjustment 8/17 thru 8/30/2020 - p/r


9/9/2020


B-4718


INPRS

General Fund 2149.0


$ 6,117.98


$ 6,117.98


C4718


8/17-8/30/2020 pay period - EmpPerf [NIRPC]


9/9/2020


3807

South Shore Clean Cities, Inc

General Fund 5610.5


$ 61,683.86


$ 61,683.86


2652


Reimbursement CMAQ Air Quality April 1-June 30th 2020


Date Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


09/012020


3572

Midwest Transit Equipment, INC

General Fund 5960.0


$ 196,125.00


$ 196,125.00


C3572

3 BOC buses- 8 ambulatory passenger seats+ 3 wheelchair positions--Opportunity Enterprises


9/1/2020


3835


Wex Bank

General Fund 5410.2


$ 51.66


$ 51.66


C3835


Vehicle Gas - August


9/2/2020


3932


De Lage Landen Fin.

General Fund 5243.9


$ 3,538.44


$ 3,538.44


C3932


IT Services - Aug


9/2/2020


3932


De Lage Landen Fin.

General Fund 5244.9


$ 741.83


$ 741.83


C3932


Telephone Services- Aug


9/2/2020


3932


De Lage Landen Fin.

General Fund 5241.9


$ 842.74


$ 842.74


C3932


Copier Services- Aug


9/8/2020


B-4716


Federal & Fica

General Fund 2140.0


$ 4,622.89


$ 4,622.89


C4716


Federal Tax Withholdings Payable


9/8/2020


B-4716


Federal & Fica

General Fund 2142.0


$ 7,241.76


$ 7,241.76


C4716


FICA Tax Withholdings Payable


9/8/2020


B-4719


Horizon Bank


General Fund


$ 365.38


$ 365.38


C4719


8/17-8/30/2020 pay period HAS


9/8/2020


B-4720


ICMA Retirement Fund-PR


General Fund


$ 805.00


$ 805.00


C4720


8/17-8/30/2020 -pay period - ICMA


9/8/2020


3892


ICMA Retirement Fund-PR


General Fund


$ 832.41


$ 832.41


C3892


ER paid for Ty Warner 8/17 thru 8/30/2020 - p/r


9/8/2020


Payroll


$ 36,357.14


$ 36,357.14


Pay period ending 8/30/2020


9/9/2020


3887


Anthem BCBS

General Fund 5143.9


$ 502.84


$ 502.84


2648


Life Insuranc - Sept


9/9/2020


3883

Blachy, Tabor, Bozik, Hartman, LLC

General Fund 5602.9


$ 1,650.00


$ 1,650.00


2649


Legal Services - Sept


9/9/2020


3886


Chicago Tribune

Gerneral Fund 5410.4


$ 27.72


$ 27.72


C3886


News Paper Subscription - Sept


9/9/2020


3884


City of Portage

General Fund 5221.9


$ 18,775.18


$ 18,775.18


2650


Office Lease - Sept


9/9/2020


3885


City of Portage

General Fund 5224.9


$ 1,978.50


$ 1,978.50


2650


Sewer/Water/Gas/Electric Service -August


9/9/2020


3874


Engraveables

General Fund 5410.5


$ 198.00


$ 198.00


C3874


Laser Engraved Apex Seiers Clear Acrylic Awards- P4CA


9/9/2020


3838


Impact Networking LLC

General Fund 5430.9


$ 229.65


$ 229.65


2651


Office Supplies- Paper


9/9/2020


B-4626


IN Dept of Revenue

General Fund 2143.0


$ 1,494.67


$ 1,494.67


C4626


7/20-8/2/2020 pay period - LwtIN, SwtIN - State Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2144.0


$ 322.74


$ 322.74


C4626


7/20-8/2/2020 pay period - LwtIN, SwtIN - Local Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2143.0


$ 1,494.67


$ 1,494.67


C4652


8/3-8/16/2020 pay period - LwtIN, SwtIN - State Tax Withholdings Payable


9/9/2020


B-4652


IN Dept of Revenue

General Fund 2144.0


$ 322.74


$ 322.74


C4652


8/3-8/16/2020 pay period - LwtIN, SwtIN - Local Tax Withholdings Payable


9/9/2020


3891


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3891


Rounding Adjustment 8/17 thru 8/30/2020 - p/r


9/9/2020


B-4718


INPRS

General Fund 2149.0


$ 6,117.98


$ 6,117.98


C4718


8/17-8/30/2020 pay period - EmpPerf [NIRPC]


9/9/2020


3807

South Shore Clean Cities, Inc

General Fund 5610.5


$ 61,683.86


$ 61,683.86


2652


Reimbursement CMAQ Air Quality April 1-June 30th 2020

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


9/9/2020


3888


Stamps

General Fund 5249.9


$ 24.99


$ 24.99


C3888


Stamps - Sept 2020


9/9/2020


B-4721

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


2653


8/17-8/30/20 pay period - United Way


9/10/2020


3889


Ecointeractive, Inc

General Fund 5610.2


$ 3,750.00


$ 3,750.00


C3889


TIP SAAS Monthly Services - Sept


9/10/2020


3890


Hammond, Allen

General Fund 5410.4


$ 102.60


$ 102.60


C3890

Mileage- Vehicle Inspections--

NT/ECT/LCCS/TransPorte/City of Valpo/PCACS/OE


09/10/202


Bank Service Fee


$ 46.60


$ 46.60


Monthly bank account service fee


9/10/2020


3896


Total Disposal

General Fund 5223.9


$ 74.00


$ 74.00


C3896


Recycle/Trash - Sept


9/10/2020


3895


Warner, Ty

General Fund 5244.9


$ 125.00


$ 125.00


C3895


Communication Expense - Sept


9/11/2020


3899


Comcast

General Fund 5244.9


$ 139.64


$ 139.64


C3899


Business Internet - Sept 2020


9/18/2020


3573

Midwest Transit Equipment, INC

General Fund 5960.0


$ 266,344.00


$ 266,344.00


C3573


4 BOC Buses 13+3 for SLCCS


9/22/2020


B-4738


Federal & Fica

General Fund 2140.0


$ 4,493.61


$ 4,493.61


C4738


8/31 - 9/13/2020 pay period - Federal Tax Withholdings Payable


9/22/2020


B-4738


Federal & Fica

General Fund 2142.2


$ 7,067.86


$ 7,067.86


C4738


8/31 - 9/13/2020 pay period - FICA Tax Withholdings Payable


9/22/2020


B-4741


Horizon Bank

General Fund 2150.0


$ 415.38


$ 415.38


C4741


8/31 - 9/13/2020 pay period- HAS


9/22/2020


B-4742


ICMA Retirement Fund-PR

General Fund 2146.0


$ 805.00


$ 805.00


C4742


8/31 - 9/13/2020 pay period - ICMA


9/22/2020


3905


ICMA Retirement Fund-PR

General Fund 5145.9


$ 832.41


$ 832.41


C3905


ER paid for Ty Warner 8/31 thru 9/13/2020- p/r


9/22/2020


Payroll


$ 35,479.08


$ 35,479.08


Pay period ending 9/13/2020


9/23/2020


3912


Adams Radio Group

General Fund 5610.5


$ 796.12


$ 796.12


2654


Weather Sponsorship/promoting behaviors that reduce air pollution emissions


9/23/2020


3912


Adams Radio Group

General Fund 5610.5


$ 1,254.78


$ 1,254.78


2654


Radio Ad Campaign/Region Man- It all adds up to cleaner air billboards


9/23/2020


3911


Adams Radio Group

General Fund 5610.5


$ 995.14


$ 995.14


2665


Weather Sponsorship/promoting behaviors that reduce air pollution emissions


9/23/2020


3900


Auto-Owners Insurance

General Fund 5122.9


$ 54.00


$ 54.00


2655


Workers Comp. Audit -Sept 2020


9/23/2020


3898


Bryco

General Fund 5223.9


$ 1,425.00


$ 1,425.00


2656


Office Cleaning - Sept 2020


9/23/2020


3909


Health Resources

General Fund 2153.0


$ 719.94


$ 719.94


2657


Dental Insuance - Oct 2020


9/23/2020


B-4740


INPRS

General Fund 2149.0


$ 5,963.71


$ 5,963.71


C4740


8/31- 9/13/2020 pay period - EmpPerf [NIRPC]


9/23/2020


3904


INPRS

General Fund 5141.9


$ (0.01)


$ (0.01)


C3904


Rounding Adjustment 8/31 thru 09/13/2020 - p/r


9/23/2020


3897

Kansas City Life Insurance Co.

General Fund 5143.9


$ 877.54


$ 877.54


2658


Life Insurance - Sept 2020


9/23/2020


3903

Nat'l Assoc. of Regional Councils

General Fund 5410.1


$ 250.00


$ 250.00


2660


2020 Executive Directors Confernece 10/5- 6/2020


9/23/2020


3908


Pulse Technology

General Fund 5430.9


$ 136.08


$ 136.08


2661


Office Supplies


9/23/2020


3913

South Shore Clean Cities, Inc

General Fund 5610.5


$ 2,200.00


$ 2,200.00


2664


Publication/Billboard CMAQ - Aug 2020


9/23/2020


B-4743

United Way of Porter County

General Fund 2147.0


$ 33.85


$ 33.85


C4743


8/31 - 9/13/2020 pay period - United Way


General Fund


$ -


General Fund


$ -


General Fund


$ -


General Fund


14


$ -

Total:

$ 680,762.96


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 $ 680,762.96


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


9/23/2020


3901


Routematch

CARES Fund 5960.0


$ 2,065.00


$ 2,065.00


2662


August- SLCCS/PCACS/NT Routematch


9/23/2020


3714


Pulse Technology

CARES Fund 5430.9


$ 14.48


$ 14.48


2661


Office Supplies - Covid-19


9/23/2020


3902


Mile-X Equipment, Inc

CARES Fund 5960.0


$ 2,307.00


$ 3,538.44


2659


Emerson Model TC-24 A Filter Crusher- City of Laporte


$ -


$ -


$ -

Date

Filed

Claim

Number


Name of Claimant


Fund


Fund Amount

Amount of

Claim


Check #


Notes


9/23/2020


3901


Routematch

CARES Fund 5960.0


$ 2,065.00


$ 2,065.00


2662


August- SLCCS/PCACS/NT Routematch


9/23/2020


3714


Pulse Technology

CARES Fund 5430.9


$ 14.48


$ 14.48


2661


Office Supplies - Covid-19


9/23/2020


3902


Mile-X Equipment, Inc

CARES Fund 5960.0


$ 2,307.00


$ 3,538.44


2659


Emerson Model TC-24 A Filter Crusher- City of Laporte


$ -


$ -


$ -

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


Total:

$ 5,617.92


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 $ 5,617.92


Dated this day of , 2020.


image


image

PROPOSED 2020 BUDGET AMENDMENT #4

To Transfer within Contractual category amount of $47,000


FROM:

Environmental Projects

TO:

Audit and Accounting


CATEGORY

Transferring funds from Environmentl line item to Audit and Accounting to cover the State Board of Accounts 2019 audit.


DETAILED BUDGET LINE Original Addition Amended

FROM:

Environmental Projects

TO:

Audit and Accounting


CATEGORY

Transferring funds from Environmentl line item to Audit and Accounting to cover the State Board of Accounts 2019 audit.


DETAILED BUDGET LINE Original Addition Amended

Purpose:


image


CONTRACTUAL


CONTRACTUAL

Expense:


Expense:

Audit and Accounting


Environmental Projects

22,000


569,374

CONTRACTUAL


CONTRACTUAL

Expense:


Expense:

Audit and Accounting


Environmental Projects

22,000


569,374

47,000 69,000


(47,000) 522,374

image


2021 BUDGET

DRAFT

DRAFT

10/15/2020


FY 2021 BUDGET

ATTACHMENT A


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2020 GENERAL FUND APPROPRIATIONS BUDGET



PERSONNEL - SALARIES


1,592,381


PERSONNEL - FRINGE BENEFITS

626,772


OCCUPANCY

286,690


EQUIPMENT SERVICE/MAINTENANCE

80,053


DEPARTMENTAL

211,455


CONTRACTUAL

2,088,100


image

CAPITAL OUTLAYS - Equipment & Furniture 180,000


TOTAL FUND BUDGET

5,065,451

image


ATTACHMENT B


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


DRAFT

DRAFT

2020 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


2020 TRANSIT OPERATING PROJECTS FUND APPROPRIATIONS BUDGET


image


OTHER SERVICES AND CHARGES 4,460,765

image

OTHER SERVICES AND CHARGES- CARES ACT 2,679,048


TOTAL FUND BUDGET

7,139,813

image


ATTACHMENT D


NORTHWESTERN INDIANA REGIONAL PLANNING COMMISSION


2020 LAPORTE COUNTY REVOLVING LOAN FUND APPROPRIATIONS BUDGET


image


image

image

OTHER SERVICES AND CHARGES 100,000


TOTAL FUND BUDGET

100,000



NIRPC FY 2021 Budget


FY 2020 Budget


FY 2021 Budget

REVENUES

COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

869,119

1,896,704

STATE AGENCIES

1,955,395

2,489,059

LOCAL AGENCIES

44,694

49,194

NON-GOVERNMENTAL

85,318

52,338

INTEREST INCOME

9,862

37,885

TOTAL REVENUES

3,504,659

5,065,451

Attachment A


Change %


31%

NIRPC FY 2021 Budget


FY 2020 Budget


FY 2021 Budget

REVENUES

COUNTY APPROPRIATIONS

540,271

540,271

FEDERAL AGENCIES

869,119

1,896,704

STATE AGENCIES

1,955,395

2,489,059

LOCAL AGENCIES

44,694

49,194

NON-GOVERNMENTAL

85,318

52,338

INTEREST INCOME

9,862

37,885

TOTAL REVENUES

3,504,659

5,065,451

Attachment A


Change %


31%


DRAFT

DRAFT

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,592,381

1,476,381

1,592,381

CONTRACTUAL

LEGAL SERVICES

AUDIT & ACCOUNTING

LA PORTE RLF SERVICES

TRANSIT OVERSIGHT

ENVIRONMENTAL CONTRACTS

PLANNING

ALTERNATIVE FUEL

BOARD DEVELOPMENT

ECONOMIC DEVELOPMENT DISTRICT

ECONOMIC DEVELOPMENT DISTRICT 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 DEVELOPMENT DISTRICT CARES ACT

ORGANIZATIONAL DEVELOPMENT

E-TIP

19,800

210,000

22,000

22,000

2,000

2,000

11,300

11,300

5%

529,374

837,300

-

400,000

70,991

-

2,000

2,000

70,000

550,000

2,000

2,000

45,000

51,500

774,465

2,088,100

63%

100,000

180,000

44%

3,504,658

5,065,451

31%

(0)

(0)

19,800

210,000

22,000

22,000

2,000

2,000

11,300

11,300

5%

529,374

837,300

-

400,000

70,991

-

2,000

2,000

70,000

550,000

2,000

2,000

45,000

51,500

774,465

2,088,100

63%

100,000

180,000

44%

3,504,658

5,065,451

31%

(0)

(0)

FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

FURNITURE & EQUIPMENT

TOTAL EXPENSES

FUND BALANCE - ENDING

7%


112,943

121,817

7,000

9,500

2,000

3,000

186,983

203,455

220,000

220,000

0%

24,000

24,000

25,000

25,000

20,000

20,000

597,926

626,772

5%


OCCUPANCY

OFFICE LEASE

PROPERTY INSURANCE

BUILDING MAINTENANCE

UTILITIES

225,500

231,000

2%

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

2%

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

19,400

40,440

41,653

18,000

18,000

1,000

1,000

78,840

80,053

EQUIPMENT SERVICE/MAINTENANCE

COPIER LEASING/MAINTENANCE

COMPUTER SERVICE

TELEPHONE & INTERNET SERVICE / MAIN.

OTHER EQUIPMENT MAINTENANCE

19,400

19,400

40,440

41,653

18,000

18,000

1,000

1,000

78,840

80,053


DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

GENERAL USE SUPPLIES

41,500

41,500

60,000

80,000

15,000

25,000

28,650

25,255

1,000

1,000

28,000

28,000

15,600

3,700

7,000

7,000

196,750

211,455

7%

DEPARTMENTAL

COMMISSION/EXECUTIVE DIRECTOR

PLANNING

SUBGRANTEE MANAGEMENT

ENVIRONMENTAL PROGRAMS

PARTNER AGENCIES

ALLOCATED FUNCTIONS

ENVIRONMENTAL PROMOTIONS

GENERAL USE SUPPLIES

41,500

41,500

60,000

80,000

15,000

25,000

28,650

25,255

1,000

1,000

28,000

28,000

15,600

3,700

7,000

7,000

196,750

211,455

7%


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

DRAFT

DRAFT

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 2021 TRANSIT CAPITAL PROJECTS FUND

Subrecipent

Grant

Project

Letting

Date

Total

Non-Federal

Funds

Federal Funds

NT

2020-039

Replace 2 Revenue Vehicles

$ 142,080

$ 23,680

$ 118,400

DRAFT

DRAFT

TOTAL BUDGET

$ 142,080

$ 118,400



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


DRAFT

DRAFT

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


DRAFT

DRAFT

Attachment B


CY 2020 CARES 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 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


DRAFT

DRAFT

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

16,189

Operating Assistance

382,145

16,189

382,145

Southlake Community Services

Preventative Maintenance

16,189

Operating Assistance

382,145

16,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,679,048 2,679,048



Attachment D


image

image

DRAFT

DRAFT

CY 2021 LAPORTE COUNTY REVOLVING LOAN FUND


2020 2021

Budget Budget


New Loans

85,000

100,000

TOTAL

85,000

100,000

TOTAL BUDGET

100,000


image


RLF 2021 Administration Budget


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

REVENUES

RLF INTEREST INCOME

7,800

CLOSING CHARGES

2,000

TOTAL REVENUES

9,800


EXPENDITURES

SALARY

FRINGE BENEFITS ALLOC

INDIRECT COST ALLOC

2,500

2,025

2,400

6,925

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


DRAFT

DRAFT

TOTAL EXPENSES 9,800


FUND BALANCE - ENDING -


RLF 2021 CARES ACT 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


DRAFT

DRAFT

TOTAL EXPENSES 582,085


FUND BALANCE - ENDING -