southeast iowa regional planning commission full board...2017/09/28 · southeast iowa regional...
TRANSCRIPT
Southeast Iowa Regional Planning Commission September 28, 2017 12:00 PM 211 N. Gear Ave., Suite 100 West Burlington, IA 52655
Meeting Type Full Board
----- Agenda ----- CALL TO ORDER Schleisman
Agenda Approval Board Action
Consent Agenda (Director’s Report, Minutes, Financial Report, Claims, Correspondence)
Board Action
OLD BUSINESS
1. Department Reports 2. Housing, Inc. (Southeast Iowa Housing, Inc.) Update 3. CEDS (Comprehensive Economic Development Study)
Update
Various Norris
James
Board Update Board Update
Board Update
New Business 1. Building Remediation Grant Update
Norris
Board Update
MATTERS FROM THE FLOOR
Consent A
genda C
onsent Agenda
1
DIRECTOR’S REPORT To: SEIRPC Board
From: Mike Norris, Executive Director
Date: September 22, 2017
BUILDING UPDATE
Goose deterrents are in place on the pond. These nighttime strobes will disturb sleeping patters of visiting geese, hopefully reducing their ongoing presence. Carpet quotes for the atrium and entry stairs have been received, a low responsive quote identified, and work will commence in the next 30 days. The SEIRPC building carpet is now around 16 years old; phased replacement will be necessary over the next few years as needed.
MISCELLANEOUS
I met with other representatives of the Iowa DOT, county engineers and public works officials and RPAs and MPOs as part of the federal/state transportation fund swap process. The Iowa Legislature passed swap legislation in 2017, now the DOT is taking steps to inform the Iowa Transportation Commission about how to implement it. Essentially, Iowa RPAs (like SEIRPC) and MPOs will program transportation projects as is the case now; any swapping will take place at the DOT Program Management level. The idea is for local sponsors to do less work and have fewer federal requirements (environmental, Davis Bacon, etc) to increase available dollars for projects. Iowa DOT will then spend more federal money on fewer projects and more efficiently complete required processes. The swap is $1:$1 federal:state funds. More will be presented to the SEIRPC board as information is available.
Director’s Report July 28, 2017 Page 2
CONSENT AGENDA
June, July, August financials are presented. You will see SEIRPC in a solid financial position. Please keep in mind Federal Transit subsidy funds will be withheld until a solution is found with US DOT/Iowa DOT due to Chapter 20 potentially conflicting with federal rules. SEIRPC will cashflow this deficit until a resolution is found.
AGENDA ITEMS – OLD BUSINESS
1. Housing, Inc. Update, Board Information: Happenings and upcoming projects for
Housing, Inc.
2. Comprehensive Economic Development Strategy (CEDS) Update, Board Update: Update for the board on CEDS progress and upcoming events.
AGENDA ITEMS – NEW BUSINESS
1. Community Catalyst Building Remediation Fund Update, Board Update: A new state grant program is highlighted for vacant, blighted or underused buildings.
July 27, 2017 Full Bd Minutes.doc Page 1 of 3
Southeast Iowa Regional Planning Commission Full Board Minutes 211 N. Gear Avenue, West Burlington, IA 52655 July 27, 2017 Members Present: Brent Schleisman, Dr. Michael Ash, Hans Trousil, Mark Huston, Gary Folluo, Greg Moeller, David Varley, Bob Beck, Ron Sadler, Richard Taylor, Tom Richardson, Bob Fleming (in place of Jim Davidson), and Aaron Burnett Members Absent: Paula Buckman, Klay Edwards, Bob Hesler, Brad Quigley, and Dr. Steve Titus Staff Present: Mike Norris, Debbie Laughlin, Jeff Hanan, Roger Keller, Zach James, and Lori Gilpin Guest Present: Sue Frice (past SEIRPC Board Member) Call to order at 12:06 p.m. Agenda Approval Motion by Sadler to approve the July 27, 2017 agenda, second by Moeller. All Ayes, motion carried. Presentation: Mike Norris welcomed Sue Frice to the board meeting. She had served on the SEIRPC board of directors from July 2006 through January 2017. She also served on the SEIRPC Executive Board Meeting since January 2007. Frice was presented with a plaque to show appreciation for all of her time and dedication to the SEIRPC Board. Norris mentioned some things to remember during her tenure: 2008 Floods and accompanying 7-year recovery and funding process; Purchasing of the IPC Building in 2010, moving the offices, renovations, and leasing to three tenants; Expanding SEIBUS to all four counties; Starting Great River Housing, Inc. (of which Sue Frice continues to serve on their board of directors) and Southeast Iowa Housing, Inc.; and expansion of regional RLF capital base. Sue Frice thanked the board for the framed certificate and stated that she has loved serving on the SEIRPC Board all of these years. Consent Agenda Approval Norris stated that building caulking is now complete. New pond warning signs will be going in for insurance reasons. A meeting will be set up in the next 4-6 weeks with Governor Reynolds’ office, Department of Corrections, and other stakeholders about the prison housing project and options to jumpstart the operation. June Financials are delayed due to continued year end work. Staff does plan to follow through on the budget recommendation to continue to pay down the building loan principle beginning with FY2018 in the amount of $50,000. Motion by Moeller to accept the consent agenda, second by Ash. All Ayes, motion passed. Old Business
1. Department Reports: Hanan highlighted the Development Department report stating
that RLF will soon be working on a project in Mount Pleasant. The South 9th St. project is Burlington is now complete. After the Southeast Iowa Housing, Inc.
July 27, 2017 Full Bd Minutes.doc Page 2 of 3
meeting today, immediately following this meeting, we will be touring the 9th Street project, and invite any of the SEIRPC board to go along. The next Housing Inc. project will be in Keokuk. The Mount Pleasant upper-story redevelopment project is nearing completion. CDBG funds were awarded for Keokuk sewer project in the amount of $600,000. James stated that SEIRPC staff sent out a notice in June that regional Transportation Alternative Funding (TAP) applications would be accepted. However, since then, Iowa DOT has informed us of additional changes to the TAP program, putting funding on hold once again. SEIRPC will keep everyone up to date with the changes to TAP funding and when applications will be accepted. Planning staff is nearly completed with mapping of Columbus Junction water and sewer utilities, which will allow Columbus Junction to view the data through an online mapping service. The Keokuk Impervious Surface Mapping project has been completed to assist in the creation of a storm water utility. Keller stated that SEIBUS has successfully renewed and implemented FY2018 Regional Transit Authority contracts with: City of Keokuk, City of Fort Madison, INPROPCO, Great River Health Systems, Hope Haven, and Midwest Old Threshers. Chris Crowner (former SEIBUS driver on the DMC1 route) was hired recently to train as Transit Scheduler in anticipation of Carolyn Lees retirement. A SEIBUS Drivers training and informational meeting will be held on August 22nd. Keller went over the rider statistics noting that overall rides were up 5% in FY2017. No action necessary.
2. Public Hearing: Resolution No. 125-2017: A Resolution Adopting the FY2018 – 2021 Transportation Improvement Program (TIP): Schleisman opened the Public Hearing at 12:29 p.m. James stated that TIP includes all transportation projects that are receiving federal transportation dollars, and must be included in order to be eligible to receive the funding. James highlighted the Regional Surface Transportation Program Target Dollars (STBG) and Transportation Alternative Program Dollars (TAP) anticipated to be received from Iowa DOT for FFY2021. James stated that 3 City STBG applications were received of which Burlington – Washington Street HMA Resurfacing Project was ranked #1 with an anticipated award of $867,274. Ranked #2 is West Burlington – Mount Pleasant Street Rehabilitation Project that could be awarded $405,554. The West Burlington City Council recently decided to use the funds, and complete the project as described in their application, as required, in order to receive the funds. Only one County STBG application was received from Lee County – J20 Resurfacing, which is anticipated to receive $2,342,428. TAP applications will be taken at a later date as the Iowa DOT is making changes to the program. Schleisman asked if there were any questions from the public. There were none. Folluo made a motion to close the Public Hearing: Resolution No. 125-2017: A Resolution Adopting the FY2018 – 2021 Transportation Improvement Program (TIP) at 12:32 p.m., second by Beck. A roll call vote was taken. All Ayes, motion carried. Burnett made a motion to approve Resolution No. 125-2017: A Resolution Adopting the FY2018 – 2021 Transportation Improvement Program (TIP), second by Folluo. A roll call vote was taken. All Ayes, motion carried.
New Business
1. SEIRPC Auditor Selection: Norris stated that SEIRPC recently sent a Request for Proposal for Audit Services. Staff followed procurement policies and sent RFP documents to four firms, including SEIRPC’s current auditor, John Morrow, CPA. John
July 27, 2017 Full Bd Minutes.doc Page 3 of 3
Morrow was the only proposal respondent with two firms refusing, and one did not answer the RFP. The engagement for Audit Services proposal is for $55,100 for 3 years, and does not include any other related entities. This would be an average increase of 3.67% per year, and would be a market rate proposal. Moeller made a motion to approve the proposal from John Morrow to prepare SEIRPC’s Annual Audit for FY2017 through FY2019 in the amount of $55,100, second by Fleming. All ayes, motion carried.
MATTERS FROM THE FLOOR: Norris stated that the Annual SEIRPC Golf Outing/Fund Raiser for Great River Housing, Inc. will be held on Thursday, October 5th at Flint Hills Municipal Golf Course. This is a 4-person best ball event, and the proceeds will go directly to Great River Housing, Inc. to be used toward the local match to bring in dollars to the Housing Trust Fund. Lunch and registration are at 11:00 a.m., and tee off is 12:15 p.m. Motion to adjourn meeting by Sadler, second by Folluo. All Ayes Meeting adjourned at 12:38 p.m. Submitted by Debbie Laughlin
_________________________________ ______________________________ Mike Norris, Executive Director Mark Huston, Secretary Date: ___________________________ Date: ________________________
Financial Report June 2017
Dear SEIRPC Board: The accompanying Balance Sheet of Southeast Iowa Regional Planning Commission, as of June 30, 2017, and the related Statements of Income and Changes in Financial Position for the year ended June 30, 2017. A compilation is limited to presenting, in the form of financial statements, information that is the representation of management. The statements have not been audited.
Lori Gilpin Finance Director
Completed August 15, 2017
TO: SEIRPC Board
FROM: Lori Gilpin
DATE: 8/14/2017
RE: Financial Summary for the month of June 2017
June 2017 YTD
TOTAL REVENUES : 493,965 5,997,800
TOTAL EXPENSES : 501,560 5,927,631
Excess of revenues over expenditures (7,595) 70,169
June 2017 YTD
TOTAL REVENUES : 100,779 1,559,905
TOTAL EXPENSES : 179,510 1,350,535
Excess of revenues over expenditures (78,731) 209,370
CASH BALANCE UNRESTRICTED RESTRICTED
Gen'l Government Chkng 857,866 -
IRP Government Chkng 378,946
Ft. Madison RLF Government Chkng 174,531
Henry County RLF Government Chkng 162,003
Henry County RTA Government Chkng 55,212
Keokuk RLF Regular Chkng 95,890
EDA RLF Government Chkng 405,470
Mediapolis HTF Government Chkng 104,853
GRHTF Government Chkng 316,050
TOTAL 913,078 1,637,743 2,550,821
CUSTOMER ACCOUNTS RECEIVABLE BALANCE
Current 1-45 46-90 >90 TOTAL
308,814 117,179 37,850 5,035 468,878
VENDOR ACCOUNTS PAYABLE BALANCE
Current 1-45 46-90 >90 TOTAL
155,159 307 (128) 15,000 170,337
PROFIT & LOSS ALL CLASSES
PROFIT & LOSS REGIONAL TRANSIT AUTHORITY
ASSETS
Current Assets
Checking/Savings
General Government Checking 857,865.64
IRP Government Checking 378,946.11
Ft. Madison RLF Checking 174,531.16
Henry County RLF Checking 162,002.59
Henry County RTA Checking 55,211.57
Keokuk RLF Checking 95,889.53
EDA RLF Government Checking 405,469.80
Mediapolis HTF Checking 104,853.42
GRHTF Checking 316,050.48
Total Checking/Savings 2,550,820.30
Accounts Receivable
Accounts Receivable 468,877.31
Other Current Assets
Petty Cash Account 302.00
13 Month CD 302,520.12
Interest Receivable 92.83
Ft. Madison RLF Receivable 18,927.53
Henry County RLF Receivable 32,184.55
Our Home Rehab Receivable 13,250.05
Mediapolis HTF Receivable 28,917.77
EDA RLF I Receivable 685,137.62
IRP I Loan Receivable 450,407.79
IRP II Loan Receivable 238,995.27
Keokuk RLF Receivable 69,532.30
GRHTF Receivable 25,131.98
EDA RLF II Receivable 636,392.09
Prepaid Expenses 731.90
Prepaid Insurance 111,910.90
Total Other Current Assets 2,614,434.70
Total Current Assets 5,634,132.31
Other Assets
Agency Vehicle/Equipment 99,760.92
A/D Agency Vehicle/Equipment (56,320.01)
Transit Vehicle 924,052.65
A/D Transit Vehicle (647,707.01)
Program Equipment 38,262.97
A/D Program Equipment (26,514.22)
Building/Bldg. Improvements 1,298,269.96
A/D Building/Bldg. Improvements (106,520.50)
Land 103,440.00
Pension Related Deferred Outflow 247,158.00
Total Other Assets 1,873,882.76
TOTAL ASSETS 7,508,015.07
Southeast Iowa Regional Planning Commission
Balance Sheet
June 30, 2017
Southeast Iowa Regional Planning Commission
Balance Sheet
June 30, 2017
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable 170,337.35
Payroll Liabilities 72,949.09
Rent Income Deposits 2,035.33
Deferred Revenue - Other (GRHTF) 600.00
Deferred Revenue - Per Capita 3,442.00
Speed Indicators Maintenance 3,202.78
Custodial Fund Liability 209.55
Accrued Interest Payable 9,881.00
Accrued Vacation 16,520.73
Short Term Notes Payable 6,560.86
Total Current Liabilities 285,738.69
Long Term Liabilities
Long Term Notes Payable 974,797.65
Pension Related Dererred Inflow 177,993.00
Net Pension Liability 764,423.00
Total Liabilities 2,202,952.34
Equity
Unreserved local net Assets 641,559.95
Non-spendable Reserve for Loans 1,505,238.20
Assigned to Revolving loan 2,017,662.48
Pension Net Asset (774,574.00)
Investment in property & equipment 1,583,283.86
GRHTF Net Assets 261,722.95
Net Income (Loss) to date 70,169.29
Total Equity 5,305,062.73
TOTAL LIABILITIES & EQUITY 7,508,015.07
Jun-2017 Year-to-Date FY17 Budget FY16 Actual FY15 Actual FY14 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 4,695.98 45,000.50 67,500 72,017 66,758 51,127
411.00 · Local Contracts 21,087.47 96,999.97 85,000 81,325 67,100 102,063
Total 4100 · Bus Fares 25,783.45 142,000.47 152,500 153,342 133,858 153,190
4500 · Federal/State Revenues
450.00 · EDA Planning Grant - 66,000.00 66,000 61,000 91,500 54,900
450.01 · Marketing Grant - - - - - (2,525)
450.04 · EDA Facility Grant - - - - - -
450.05 · EDA RLF Grant - - - - - -
451.00 · IDED COG Assistance - 11,176.47 - 11,765 11,765 10,294
453.00 · PDM (Pre-Disaster Mitigation) - - - 19,400 11,900 5,532
455.00 · IDOT Planning 60,732.00 196,241.00 225,604 187,177 165,267 203,082
456.00 · State Transit Assistance (RTA) 27,723.68 300,888.85 295,437 285,844 257,780 247,848
457.00 · Federal Transit Assistance (RTA) - 555,526.00 309,055 327,865 288,460 367,431
458.00 · Housing Draws 150,376.00 2,424,888.89 - 5,480,818 2,905,347 2,053,675
459.00 · State Medicaid 39,720.83 461,526.42 385,000 412,393 403,906 434,092
Total 4500 · Federal/State Revenues 278,552.51 4,016,247.63 1,281,096 6,786,262 4,135,924 3,374,329
4600 - Principle on Loans
461.00 - Principal on Loans 21,944.36 748,638.72 334,209 456,963 296,053
4700 · Local Revenues
470.00 · Per Capita Revenue - 172,776.00 174,927 170,335 165,603 159,407
471.00 · Cities/Counties 7,500.00 62,805.00 - 11,994 26,424 7,250
472.00 · Other Contracts 17,758.00 163,677.50 199,913 371,173 309,495 84,440
473.00 · Grant Administration - 125,572.17 - 103,696 64,595 192,193
474.00 · CDGB Housing Administration - - - 1,026 13,775 16,075
475.00 · Other Contributions - 12,500.00 - - - -
475.01 · Homeowner Contributions - 12,284.00 - 3,859 12,489 22,733
476.00 · HOME Administration 12,500.00 30,000.00 - - - -
478.00 · SIREPA Administration - 5,000.00 - - - -
479.00 · RLF Administration 37,540.39 37,540.39 11,393 30,483 37,081 44,050
481.00 · Housing Soft Costs 33,275.00 51,025.00 - 164,697 152,416 107,588
482.00 · Lead Abatement - - - - - 9,970
488.00 · Vehicle Reimbursements 1,329.45 11,915.60 14,800 13,703 10,992 11,830
489.00 · Housing Administration 25,425.61 154,014.17 222,056 121,345 203,467 119,177
Total 4700 · Local Revenues 135,328.45 839,109.83 623,089 992,311 996,336 774,713
4900 · Miscellaneous Revenues
492.00 · Lease Income 9,452.29 114,177.48 116,000 116,312 112,729 111,889
494.00 · Vehicle Cost Recovery 7,141.00 7,341.00
496.00 · Interest Income (Bank) 1,407.08 8,360.61 4,215 5,756 6,760 8,721
497.00 · Miscellaneous Revenues-Other 6,860.00 24,071.50 5,000 32,660 20,402 13,973
498.00 · Matching Funds - - 122,401 113,117 - 99,844
Total 4900 · Miscellaneous Revenues 24,860.37 153,950.59 247,616 267,844 139,891 234,427
5000-52 RLF Income
507.00 · Late Payment Fees 75.00 411.88 - 285 700 1,343
508.00 · Loan Closing Fees 700.00 19,661.76 - 6,779 16,392 12,252
509.00 · FM RLF Loan Interest Income 39.63 492.72 533 550 420 146
510.00 · Henry Co. RLF Interest Income 138.34 1,782.90 2,096 2,280 2,917 3,739
511.01 · EDA RLF I Interest Income 1,918.43 23,523.45 20,000 25,485 21,856 22,440
512.00 · Mediapolis HTF Interest Income 124.57 1,162.03 1,650 1,137 1,359 1,484
513.00 · EDA RLF II Interest Income 2,131.20 23,529.30 18,370 20,179 22,289 23,407
515.00 · IRP I Loan Interest Income 1,295.77 16,469.33 11,748 17,192 9,157 1,819
516.00 · IRP II Loan Interest Income 823.75 8,321.87 4,100 7,843 7,583 6,792
518.00 · Keokuk RLF Loan Interest Income 238.80 2,390.00 654 1,097 1,028 2,004
520.00 · GRHTF-Loan Interest 10.19 107.49 - 238 475 737
Total 5000-52 RLF Income 7,495.68 97,852.73 59,151 83,065 84,176 76,163
Total Income 493,964.82 5,997,799.97 2,363,451 8,617,033 5,947,149 4,908,875
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year Ended June 30, 2017
Jun-2017 Year-to-Date FY17 Budget FY16 Actual FY15 Actual FY14 Actual
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year Ended June 30, 2017
Expenditures:
701.00 · Salaries 124,055.46 1,050,399.68 1,109,899 1,144,949 1,091,362 1,041,129
702.00 · FICA - Employer's Share 8,803.86 76,312.85 80,312 83,352 78,602 74,420
703.00 · IPERS - Employer's Share 10,361.01 91,585.31 98,600 100,826 95,173 91,656
704.00 · Unemployment - 17,073.00 500 - 9,906 1,932
705.00 · Employee Benefits 16,844.40 162,500.15 157,021 164,830 176,293 191,614
706.00 · Physicals 282.00 2,841.00 1,500 1,676 2,038 2,019
707.00 · Uniform Expense 59.02 1,935.84 3,000 2,914 3,665 950
708.00 · Drug Testing 120.00 1,310.00 1,250 1,005 939 604
709.00 · Personnel Expenses-Other 120.00 1,315.00 1,500 439 2,342 1,009
710.00 · Payroll services 346.66 4,721.92 5,000 4,974 4,758 4,330
712.00 · Advertising 45.27 6,221.12 7,000 7,665 9,015 5,390
717.00 · Audit - 20,350.00 16,000 19,925 18,650 15,250
726.00 · Contractual Expenses-Other 9,250.05 29,007.69 19,500 66,486 36,686 28,433
728.00 · Information Technology 7,241.24 24,359.38 14,250 15,017 9,894 9,847
729.00 · Copier Expense - 4,251.92 5,000 6,522 5,273 4,836
730.00 · Legal Expense - 3,846.00 2,500 3,741 28,599 7,464
738.00 · Depreciation Expense 825.48 9,905.98 - 10,605 17,504 -
740.00 · Dues/Subscriptions/Conferences 1,150.00 19,768.12 27,850 16,961 15,388 16,648
741.00 · Public Notices 749.74 2,104.68 1,600 1,123 1,219 1,838
746.00 · Leased Equipment 152.00 608.00 1,000 760 456 640
747.00 · Equipment under $5000 - 25,806.60 18,000 17,687 12,936 17,528
748.00 · Capital Equipment 73,170.00 361,840.00 40,000 65,731 - 106,641
749.00 · Principal Expense - 34,673.87 65,400 34,331 39,949 45,219
750.00 · Lead Testing - 2,856.70 2,000 2,977 2,199 2,173
751.00 · Housing 136,134.00 2,101,343.09 - 5,360,445 2,715,266 1,510,203
752.00 · Admin. Expense 22,164.00 100,401.17 - 52,874 160,677 27,058
754.00 · Insurance 7,749.67 95,130.96 116,500 104,443 101,517 127,406
756.00 · Mortgage Filing Fees 7.00 1,068.00 500 549 746 1,450
757.00 · Interest Expense 9,900.91 21,384.97 22,720 12,517 22,009 38,957
759.00 · Credit Report Exp. - - - - - 16
766.00 · Bldg. Maintenance & Repair 15,012.76 40,236.67 20,000 9,075 13,585 20,296
767.00 · Vehicle Maintenance & Repair 8,390.45 126,177.49 126,200 110,674 115,504 115,818
768.00 · Marketing 300.00 7,286.95 13,000 5,386 3,389 4,931
769.00 · Meeting Expense 761.78 2,910.08 4,100 2,868 4,096 3,346
782.00 · Printing/Postage 745.08 5,658.60 7,510 4,400 5,707 6,115
791.00 · Rent 1,100.00 7,580.00 18,500 9,980 7,830 7,830
806.00 · Supplies 497.26 10,379.59 16,000 12,493 11,453 9,152
807.00 · Bank Charges (5.00) 0.83 - 103 38 (5)
808.00 · Fuel/Oil 7,673.49 84,212.97 113,800 80,946 108,521 155,930
810.00 · Telecommunications 2,095.71 24,067.63 28,650 27,563 24,711 28,215
811.00 - Utilities Expense 2,646.65 37,138.16 36,000 34,354 34,737 37,737
813.00 - Real Estate Taxes - 10,802.00 13,000 12,632 16,166 18,774
815.00 · Mileage Expense 441.00 3,427.63 1,400 1,232 2,417 2,877
816.00 · Travel/Training 1,039.31 6,753.48 11,500 10,739 9,612 4,954
820.00 · Use Allowance 1,329.45 11,915.60 15,950 13,703 10,890 11,830
825.00 · Bad Debt Expense - - - - 580 -
829.00 · Down Payment Assistance 30,000.00 273,377.00 - 131,933 203,750 351,677
830.00 · Participant Loans & Grants - 1,000,783.00 - 105,446 807,634 723,271
850.00 · Marketing Grant Expenditure - - - - - -
890.00 · Matching Expenditures - - 122,401 113,117 - 99,844
900.00 · Indirect Costs - - - - - -
Total Expenditures 501,559.71 5,927,630.68 2,366,413 7,991,968 6,043,679 4,979,252
Excess (deficiency) of revenues over (under)
expenditures (7,594.89) 70,169.29 (2,962) 625,065 (96,530) (70,377)
Schedule 1
Jun-2017 Year-to-Date FY17 Budget FY16 Actual FY15 Actual FY14 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 4,695.98 45,000.50 67,500 72,017 66,758 51,127
411.00 · Local Contracts 21,087.47 96,999.97 85,000 81,325 67,100 102,063
Total 4100 · Bus Fares 25,783.45 142,000.47 152,500 153,342 133,858 153,190
4500 · Federal/State Revenues
456.00 · State Transit Assistance 27,723.68 300,888.85 295,437 285,844 257,780 247,848
457.00 · Federal Transit Assistance - 555,526.00 309,055 327,865 288,460 367,431
459.00 · State Medicaid 39,720.83 461,526.42 385,000 412,393 403,906 434,092
Total 4500 · Federal/State Revenues 67,444.51 1,317,941.27 989,492 1,026,102 950,146 1,049,371
4700 · Local Revenues
470.00 · Per Capita Revenue - 86,467.00 86,467 84,359 82,301 79,904
472.00 · Other Contracts - - - - - -
Total 4700 · Local Revenues - 86,467.00 86,467 84,359 82,301 79,904
4900 · Miscellaneous Revenues
494.00 · Cost Recovery 7,141.00 7,341.00 - - - -
496.00 · Interest Income (Bank) 9.96 118.11 85 110 96 86
497.00 · Miscellaneous Revenues 400.00 6,037.50 5,000 4,207 4,577 4,900
498.00 · Matching Funds - - - - - -
Total 4900 · Miscellaneous Revenues 7,550.96 13,496.61 5,085 4,318 4,673 4,986
Total Revenues 100,778.92 1,559,905.35 1,233,544 1,268,121 1,170,978 1,287,451
Expenditures:
701.00 · Salaries 44,773.36 377,981.01 409,638 393,742 390,756 399,237
702.00 · FICA - Employer's Share 3,321.61 28,814.22 30,774 29,607 29,267 29,677
703.00 · IPERS - Employer's Share 3,875.38 33,406.37 36,580 35,117 34,961 35,553
- 11,136.00 500 - 9,906 -
705.00 · Employee Benefits 4,923.77 57,272.28 51,069 57,750 62,646 68,465
706.00 · Physicals 282.00 2,841.00 1,500 1,676 2,038 2,019
707.00 · Uniform Expense 59.02 1,760.12 1,500 1,421 2,978 835
708.00 · Drug Testing 120.00 1,310.00 1,250 1,005 939 604
709.00 · Personnel Expenses-Other 80.00 805.00 1,500 419 1,980 605
712.00 · Advertising 44.07 4,739.93 2,000 2,287 7,775 4,632
726.00 · Contractual Expenses 6,294.00 13,503.01 500 25,593 6,595 9,101
728.00 · Information Technology 71.25 3,186.44 500 2,257 1,313 2,117
730.00 · Legal Expense - 210.00 2,500 2,436 28,047 600
738.00 · Depreciation Expense - - - - - -
740.00 · Dues/Subscriptions/Conferences - 2,552.95 6,000 4,196 2,531 3,471
741.00 · Public Notices 400.84 418.94 - 18 16 20
747.00 · Equipment Under $5000 - 5,181.60 1,500 5,454 470 354
748.00 · Capital Equipment 73,170.00 348,020.00 40,000 58,802 - 58,702
754.00 · Insurance 3,927.06 47,124.39 75,000 65,285 61,046 63,838
757.00 · Interest Expense - - - - - 660
766.00 · Bldg. Maintenance & Repairs - - - - - -
767.00 · Vehicle Maintenance & Repair 7,553.10 123,994.71 125,000 109,804 115,183 112,561
768.00 · Marketing 300.00 3,653.00 3,000 775 750 -
769.00 · Meeting Expense - 182.98 500 351 440 132
782.00 · Printing/Postage 414.00 447.00 1,800 (52) 938 3
791.00 · Rent 1,100.00 7,550.00 18,500 9,950 7,800 7,800
806.00 · Supplies 115.82 1,214.66 1,100 818 802 671
807.00 · Bank Charges (5.00) 0.83 - 5 - (5)
808.00 · Fuel/Oil 7,347.26 81,563.51 110,000 78,082 104,313 150,075
810.00 · Telecommunications 1,023.90 11,736.96 12,000 10,437 9,001 8,610
811.00 · Utilities - 438.64 - - - -
815.00 · Mileage Expense 441.00 3,172.75 500 667 1,234 2,786
816.00 · Travel/Training (56.77) 407.36 1,000 191 192 825
820.00 · Use Allowance 400.84 1,394.07 2,500 1,115 2,262 2,210
825.00 · Bad Debt Expense - - - 2,531 580 -
- - 10,000 10,000 - 10,000
900.00 · Indirect Costs 19,533.62 174,515.47 178,432 172,560 184,649 178,081
Total Expenditures 179,510.13 1,350,535.20 1,126,643 1,084,300 1,071,408 1,154,239
Fund Balance (78,731.21) 209,370.15 106,901 183,821 99,570 133,212
704.00 - Unemployment
890.00 - Matching Expenditures
Regional Transit Authority
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year Ended June 30, 2017
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Year Ending
June 30, 2017
10 Company
Vehicles 20 EDA PG 22 Facility 47 Housing
48 Great
River
Housing
Trust
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues 0.00 0.00 0.00 0.00 0.00
4500 · Federal/State Revenues 0.00 66,000.00 0.00 1,901,664.89 523,224.00
461.00 · Principal on Loans 0.00 0.00 0.00 8,825.19 20,811.32
4700-48 · Local Revenues 11,915.60 0.00 0.00 202,585.59 141,054.17
4900 · Miscellaneous Revenues 0.00 0.00 114,177.48 224.55 15,900.15
5000-52 · RLF Income 0.00 0.00 0.00 1,862.03 4,344.12
11,915.60 66,000.00 114,177.48 2,115,162.25 705,333.76
Expense
700.00 · Personnel Expenses 0.00 97,041.18 5,183.35 129,443.40 27,470.20
704.00 · Unemployment 0.00 0.00 0.00 5,937.00 0.00
706.00 · Physicals 0.00 0.00 0.00 0.00 0.00
707.00 · Uniform Expense 0.00 0.00 0.00 0.00 0.00
708.00 · Drug Testing 0.00 0.00 0.00 0.00 0.00
709.00 · Personnel Expenses-Other 0.00 0.00 0.00 0.00 0.00
710.00 · Payroll Services 0.00 0.00 0.00 0.00 0.00
712.00 · Advertising 0.00 0.00 0.00 0.00 0.00
717.00 · Audit 0.00 0.00 0.00 0.00 3,100.00
726.00 · Contractual Expenses 0.00 0.00 10,305.58 975.00 750.00
728.00 · Information Technology 0.00 213.75 0.00 1,069.75 0.00
729.00 · Copier Expense 0.00 0.00 0.00 0.00 0.00
730.00 · Legal Expense 0.00 487.50 0.00 0.00 320.00
738.00 · Depreciation Expense 6,399.20 0.00 0.00 0.00 0.00
740.00 · Dues/Subscriptions/Conference 0.00 1,991.00 0.00 475.00 200.00
741.00 · Public Notices 0.00 48.66 0.00 363.15 13.08
746.00 · Leased Equipment 0.00 0.00 0.00 0.00 0.00
747.00 · Equipment under $5000 0.00 0.00 0.00 0.00 0.00
748.00 · Capital Equipment 0.00 0.00 0.00 0.00 0.00
749.00 · Principal Expense 0.00 0.00 0.00 0.00 0.00
750.00 · Lead Testing 0.00 0.00 0.00 2,746.70 0.00
751.00 · Housing 0.00 0.00 0.00 1,738,247.89 363,095.20
752.00 · Admin. Expense 0.00 0.00 0.00 6,966.00 78,237.17
754.00 · Insurance 1,142.76 0.00 10,731.19 0.00 2,049.85
756.00 · Mortgage Filing Expenses 0.00 0.00 0.00 208.00 250.00
757.00 · Interest Expense 341.39 0.00 14,069.45 0.00 0.00
760.00 · Housing Relocation Expense 0.00 0.00 0.00 0.00 0.00
766.00 · Bldg. Maintenance & Repairs 0.00 0.00 40,236.67 0.00 0.00
767.00 · Vehicle Maintenance & Repair 2,182.78 0.00 0.00 0.00 0.00
768.00 · Marketing 0.00 0.00 0.00 20.00 1,426.00
769.00 · Meeting Expense 0.00 0.00 0.00 32.90 262.89
782.00 · Printing/Postage 0.00 0.00 0.00 1,158.61 0.00
791.00 · Rent 0.00 0.00 0.00 0.00 0.00
806.00 · Supplies 0.00 0.00 468.55 14.95 0.00
807.00 · Bank Charges 0.00 0.00 0.00 0.00 0.00
808.00 · Fuel/Oil 2,649.46 0.00 0.00 0.00 0.00
810.00 · Telecommunications 0.00 0.00 0.00 0.00 0.00
811.00 · Utilities Expense 0.00 0.00 36,699.52 0.00 0.00
812.00 · Bldg Operation Allocation 0.00 0.00 (66,183.32) 0.00 0.00
813.00 · Real Estate Taxes 0.00 0.00 10,802.00 0.00 0.00
815.00 · Mileage Expense 0.00 0.00 0.00 254.88 0.00
816.00 · Travel/Training 0.00 1,983.96 0.00 965.15 186.92
820.00 · Use Allowance 58.14 856.61 0.00 1,282.93 640.19
829.00 · Down Payment Assistance 0.00 0.00 0.00 0.00 95,500.00
830.00 · Participant Loans 0.00 0.00 0.00 177,877.00 0.00
825.00 · Bad Debt Expense 0.00 0.00 0.00 0.00 0.00
850.00 · Marketing Grant Expenditure 0.00 0.00 0.00 0.00 0.00
900.00 · INDIRECT COSTS 0.00 33,768.15 1,830.77 46,011.94 9,611.29
12,773.73 136,390.81 64,143.76 2,114,050.25 583,112.79
(858.13) (70,390.81) 50,033.72 1,112.00 122,220.97
- - 24,431.17 6,746.81 - SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Year Ending
June 30, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment
749.00 · Principal Expense
750.00 · Lead Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Marketing Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
60 IDOT 71 EDA RLF 72 IRP-I
73.00
FM/KK/HC
RLF 76 IRP-II
0.00 0.00 0.00 0.00 0.00
196,241.00 0.00 0.00 0.00 0.00
0.00 435,559.71 144,497.52 28,376.63 110,568.35
0.00 0.00 0.00 9,796.97 0.00
0.00 1,059.19 391.22 735.41 625.93
0.00 55,824.51 19,214.33 5,540.87 11,066.87
196,241.00 492,443.41 164,103.07 44,449.88 122,261.15
161,965.15 37,012.69 12,905.64 12,907.28 10,116.76
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
120.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
549.39 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
4,535.50 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 393.24 565.88 0.00 78.38
0.00 0.00 0.00 0.00 0.00
2,717.00 25.00 0.00 0.00 0.00
111.37 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
15,076.96 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 21,294.08 0.00 13,379.79
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 15,198.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 317.50 105.00 130.00 57.50
0.00 0.00 3,990.92 0.00 2,983.21
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
307.46 0.00 0.00 0.00 0.00
60.20 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
369.41 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
625.60 0.00 0.00 0.00 0.00
2,396.69 0.00 16.15 27.78 0.00
0.00 0.00 0.00 0.00 0.00
0.00 584,805.00 182,989.00 50,000.00 182,989.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
56,469.14 12,930.90 4,524.76 4,528.55 3,526.96
245,303.87 635,484.33 226,391.43 82,791.61 213,131.60
(49,062.87) (143,040.92) (62,288.36) (38,341.73) (90,870.45)
(49,062.87) 6,204.37 (2,502.80) - (5,070.01)
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Year Ending
June 30, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment
749.00 · Principal Expense
750.00 · Lead Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Marketing Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
80 Indirect
Cost Center 85 RTA 90 LOCAL TOTAL
0.00 142,000.47 0.00 142,000.47
0.00 1,317,941.27 11,176.47 4,016,247.63
0.00 0.00 0.00 748,638.72
0.00 86,467.00 387,290.50 839,109.83
0.00 13,496.61 7,340.05 153,950.59
0.00 0.00 0.00 97,852.73
0.00 1,559,905.35 405,807.02 5,997,799.97
255,246.02 497,473.88 134,032.44 1,380,797.99
0.00 11,136.00 0.00 17,073.00
0.00 2,841.00 0.00 2,841.00
175.72 1,760.12 0.00 1,935.84
0.00 1,310.00 0.00 1,310.00
390.00 805.00 0.00 1,315.00
4,721.92 0.00 0.00 4,721.92
931.80 4,739.93 0.00 6,221.12
17,250.00 0.00 0.00 20,350.00
3,216.10 13,503.01 258.00 29,007.69
14,903.94 3,186.44 450.00 24,359.38
4,251.92 0.00 0.00 4,251.92
0.00 210.00 1,791.00 3,846.00
3,506.78 0.00 0.00 9,905.98
5,432.12 2,552.95 6,375.05 19,768.12
897.88 418.94 251.60 2,104.68
608.00 0.00 0.00 608.00
5,548.04 5,181.60 0.00 25,806.60
0.00 348,020.00 13,820.00 361,840.00
0.00 0.00 110.00 34,783.87
0.00 0.00 0.00 2,746.70
0.00 0.00 0.00 2,101,343.09
0.00 0.00 0.00 100,401.17
34,082.77 47,124.39 0.00 95,130.96
0.00 0.00 0.00 1,068.00
0.00 0.00 0.00 21,384.97
0.00 0.00 0.00 0.00
0.00 0.00 0.00 40,236.67
0.00 123,994.71 0.00 126,177.49
1,812.95 3,653.00 375.00 7,286.95
2,083.12 182.98 40.73 2,910.08
3,943.10 447.00 49.69 5,658.60
30.00 7,550.00 0.00 7,580.00
7,798.11 1,214.66 513.91 10,379.59
0.00 0.83 0.00 0.83
0.00 81,563.51 0.00 84,212.97
12,372.66 11,736.96 (41.99) 24,067.63
0.00 438.64 0.00 37,138.16
66,183.32 0.00 0.00 0.00
0.00 0.00 0.00 10,802.00
0.00 3,172.75 0.00 3,427.63
1,864.23 407.36 720.26 6,753.48
2,498.11 1,394.07 2,744.93 11,915.60
0.00 0.00 0.00 95,500.00
0.00 0.00 0.00 1,178,660.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
(394,467.56) 174,515.47 46,749.63 0.00
55,281.05 1,350,535.20 208,240.25 5,927,630.68
(55,281.05) 209,370.15 197,566.77 70,169.29
- 209,370.15 197,566.77 387,683.59
Schedule 3
Type Date Num Name Amount
Bill Pmt -Check 06/05/2017 270041 Hoglund Bus Co. Inc. 177.27
Bill Pmt -Check 06/08/2017 270042 Card Center 4,560.49
Bill Pmt -Check 06/12/2017 270043 Shafer Construction LLC. 1,805.60
Bill Pmt -Check 06/12/2017 270044 Brad Holtkamp Automotive, Inc. 283.56
Bill Pmt -Check 06/12/2017 270045 Cheyanna Jones & Two Rivers Bank & Trust 30,000.00
Bill Pmt -Check 06/12/2017 270046 City of Keokuk. 1,844.73
Bill Pmt -Check 06/12/2017 270047 City of Mount Pleasant 1,727.77
Bill Pmt -Check 06/12/2017 270048 City of West Burlington. 165.14
Bill Pmt -Check 06/12/2017 270049 Craftsman Press 414.00
Bill Pmt -Check 06/12/2017 270050 Dan Eberhardt 31.18
Bill Pmt -Check 06/12/2017 270051 Deery Brothers Ford Lincoln Inc 3,016.95
Bill Pmt -Check 06/12/2017 270052 Des Moines County News 35.00
Bill Pmt -Check 06/12/2017 270053 Des Moines County Recorder's Office 14.00
Bill Pmt -Check 06/12/2017 270054 Dex Media East Inc 14.50
Bill Pmt -Check 06/12/2017 270055 Family Medicine of Mt. Pleasant 185.00
Bill Pmt -Check 06/12/2017 270056 Farmers Elevator & Exchange, Inc. 704.10
Bill Pmt -Check 06/12/2017 270057 Federal Home Loan Bank of Des Moines 1,040.00
Bill Pmt -Check 06/12/2017 270058 Great River Business Health 188.00
Bill Pmt -Check 06/12/2017 270059 Huffman Welding and Machine Inc 15.99
Bill Pmt -Check 06/12/2017 270060 i connect you. 981.91
Bill Pmt -Check 06/12/2017 270061 Integrated Technology Partners 19.95
Bill Pmt -Check 06/12/2017 270062 Iowa Illinois Office Solutions 187.12
Bill Pmt -Check 06/12/2017 270063 Jack Callas 98.00
Bill Pmt -Check 06/12/2017 270064 Kempker's True Value 3.06
Bill Pmt -Check 06/12/2017 270065 Luckenbill Appraisal Service Inc 300.00
Bill Pmt -Check 06/12/2017 270066 Martin Wiegard 49.00
Bill Pmt -Check 06/12/2017 270067 Mt. Pleasant Tire & Service 670.72
Bill Pmt -Check 06/12/2017 270068 NADO 2,000.00
Bill Pmt -Check 06/12/2017 270069 Pauwels Lawn Care 560.00
Bill Pmt -Check 06/12/2017 270070 Pep Stop 6.00
Bill Pmt -Check 06/12/2017 270071 Shafer Construction LLC. 7,857.07
Bill Pmt -Check 06/12/2017 270072 Shottenkirk Superstore 1,025.20
Bill Pmt -Check 06/12/2017 270073 Sue Ballew 73.50
Bill Pmt -Check 06/12/2017 270074 Telin Transportation Group 182.97
Bill Pmt -Check 06/12/2017 270075 The Burlington Hawk Eye 830.50
Bill Pmt -Check 06/12/2017 270076 The Democrat Company 534.81
Bill Pmt -Check 06/12/2017 270077 Titan Broadcasting LLC. 428.00
Bill Pmt -Check 06/12/2017 270078 Truck Country of Iowa 724.68
Bill Pmt -Check 06/12/2017 270079 Truck Repair Inc. 286.38
Bill Pmt -Check 06/12/2017 270080 Verizon Wireless 1,019.92
Bill Pmt -Check 06/12/2017 270081 Wapello Auto Parts 1.29
Bill Pmt -Check 06/12/2017 270082 Waterworks Car Wash 5.00
Bill Pmt -Check 06/12/2017 270083 Wemiga Waste Inc 30.00
Bill Pmt -Check 06/12/2017 270084 Wex Bank 558.55
Bill Pmt -Check 06/12/2017 270085 Wolf Decals 725.00
Bill Pmt -Check 06/20/2017 270086 Iowa Department of Transportation 2,400.00
Bill Pmt -Check 06/22/2017 270087 Accident Fund 30,800.00
Bill Pmt -Check 06/22/2017 270088 Hoglund Bus Co. Inc. 70,570.00
Southeast Iowa Regional Planning Commission
Check Register
June 30, 2017
Schedule 3
Type Date Num Name Amount
Southeast Iowa Regional Planning Commission
Check Register
June 30, 2017
Bill Pmt -Check 06/22/2017 270089 ICAP 79,890.90
Bill Pmt -Check 06/22/2017 270090 Shafer Construction LLC. 2,421.46
Bill Pmt -Check 06/22/2017 270091 City of Burlington, Iowa 2,578.82
Bill Pmt -Check 06/22/2017 270092 Dave Ewinger 24.50
Bill Pmt -Check 06/22/2017 270093 Deni McClinton 21.27
Bill Pmt -Check 06/22/2017 270094 Drake Hardware & Software 5,768.74
Bill Pmt -Check 06/22/2017 270095 Ebert Supply Company 86.78
Bill Pmt -Check 06/22/2017 270096 Gerald Huebner 250.48
Bill Pmt -Check 06/22/2017 270097 Greater Burlington Partnership 125.00
Bill Pmt -Check 06/22/2017 270098 Hope Haven Area Dev Center 425.00
Bill Pmt -Check 06/22/2017 270099 Hy-Vee, Inc 743.11
Bill Pmt -Check 06/22/2017 270100 Iowa Illinois Office Solutions 28.08
Bill Pmt -Check 06/22/2017 270101 Iowa Prison Industries 178.20
Bill Pmt -Check 06/22/2017 270102 Jack Callas 98.00
Bill Pmt -Check 06/22/2017 270103 Martin Wiegard 73.50
Bill Pmt -Check 06/22/2017 270104 Mediacom 89.90
Bill Pmt -Check 06/22/2017 270105 Mt. Pleasant News 224.74
Bill Pmt -Check 06/22/2017 270106 Pitney Bowes Global Financial Svcs. LLC 152.00
Bill Pmt -Check 06/22/2017 270107 Shafer Construction LLC. 4,656.80
Bill Pmt -Check 06/22/2017 270108 Sue Ballew 73.50
267,062.69
Electronic Payment 06/01/2017 MetLife (dental ins.) 879.18
Electronic Payment 06/01/2017 Principal Financial (life ins.) 914.30
Electronic Payment 06/01/2017 Welmark 11,892.78
Electronic Payment 06/01/2017 IPERS 11,351.58
Electronic Payment 06/15/2017 Alliant Energy 2,481.51
Electronic Payment 06/20/2017 Two Rivers Bank - Vehicle loan payment 520.94
Electronic Payment 06/30/2017 Payroll 58,821.57
Electronic Payment 06/30/2017 Payroll Taxes 21,768.47
Electronic Payment 06/30/2017 Payroll Processing Fees 346.66
Electronic Payment 06/01/2017 Advantage fees 104.95
109,081.94
TOTAL EXPENDITURES 376,144.63
Schedule 4
BANCARD Services Credit Card Statement
STATEMENT DATE: 6/28/2017
PAYMENT DUE DATE: 7/22/2017
CHECK# 270109
DATE PAID 7/6/2017
Date Transaction Description Account# Type Class# Class Name Amount Receipt
MIKE NORRIS
08-Jun-17 Davids Milwaukee Diner Perry IA 816 Travel/Training 80 Indirect 23.32 Yes
12-Jun-17 CTC Constantcontact.com 740 Dues/Conferences 80 Indirect 45.00 Yes
13-Jun-17 Chili's St Louis MO 816 Travel/Training 80 Indirect 18.08 Yes
14-Jun-17 Taxi Svc Washington DC 816 Travel/Training 80 Indirect 16.68 Yes
15-Jun-17 Georgetown Market Arlington VA 816 Travel/Training 80 Indirect 9.30 Yes
15-Jun-17 Schlafly's St Louis MO 816 Travel/Training 80 Indirect 22.54 Yes
15-Jun-17 The Liaison Capital Hill Washington DC 816 Travel/Training 80 Indirect 649.92 Yes
TOTAL 784.84
DEBORAH LAUGHLIN
30-May-17 Occuscreen (background checks) 709 Personnel Expense 85 RTA 40.00 Yes
01-Jun-17 Occuscreen (background checks) 709 Personnel Expense 85 RTA 40.00 Yes
05-Jun-17 Jimmy Johns 769 Meeting Expense 80 Indirect 18.13 Yes
14-Jun-17 Occuscreen (background checks) 709 Personnel Expense 80 Indirect 40.00 Yes
TOTAL 138.13
ZACH JAMES
06-Jun-17 NADO 740 Dues/Conferences 60 IDOT 325.00 Yes
08-Jun-17 Amtrak 816 Travel/Training 60 IDOT 312.00 Yes
23-Jun-17 Register@FAA 740 Dues/Conferences 60 IDOT 5.00 Yes
27-Jun-17 Salvaggio's Denver CO 816 Travel/Training 60 IDOT 13.06 Yes
TOTAL 655.06
JEFF HANAN
31-May-17 Air Check Inc. 806 Supplies 47.012 WOO 14.95 Yes
23-Jun-17 Clara's Garden 806 Supplies 80 Indirect 48.15 Yes
credit carryforward (refund of conference fee) (63.10) Yes
TOTAL 0.00
LORI GILPIN
TOTAL 0.00
ROGER KELLER
07-Jun-17 Lowe's Burlington (orange cones) 806 Supplies 85 RTA 99.83 Yes
13-Jun-17 Expedia.com 85 RTA 100.80 Yes
16-Jun-17 National Safety 85 RTA 19.95 Yes
TOTAL 220.58
BOB KUSKOWSKI
TOTAL 0.00
TOTAL 1,798.61
ClassExpense
Hans Trousil Mike Norris
Schedule 5
Current 1 - 45 46 - 90 > 90 TOTAL
Local:
City of Columbus City - - - 539.00 539.00
City of Fort Madison 2,024.71 - - - 2,024.71
City of Keokuk 3,759.00 - - - 3,759.00
City of Mediapolis - - 1,250.00 - 1,250.00
Henry County Auditor 4,013.26 - - - 4,013.26
IARC - - 500.00 - 500.00
Iowa DOT 60,732.00 - - - 60,732.00
Iowa Economic Development Authority 4,558.00 - - - 4,558.00
JK Homes - - - 550.00 550.00
Low Rent Housing Agnecy 8,900.00 - - - 8,900.00
SCC Bob Ryan 3,750.00 - - - 3,750.00
SEIRPC - Keokuk RLF 2,390.00 - - - 2,390.00
Southeastern Community College - - 6,000.00 - 6,000.00
90,126.97 - 7,750.00 1,089.00 98,965.97
Housing:
City of Burlington 9,400.00 2,500.00 - - 11,900.00
City of Mediapolis 5,579.42 - - - 5,579.42
City of New London 3,745.00 - - - 3,745.00
City of Wayland 16,731.00 3,544.00 - - 20,275.00
ECIA - 25,449.00 - - 25,449.00
Historic Tama LLC 11,750.00 - - - 11,750.00
IFA 2,500.00 34,656.00 30,000.00 1,918.00 69,074.00
49,705.42 66,149.00 30,000.00 1,918.00 147,772.42
Great River Housing Trust Fund:
IFA 105,530.00 - - - 105,530.00
Lowe Holdings LLC - 10,000.00 - - 10,000.00
105,530.00 10,000.00 - - 115,530.00
RTA:
A2C 859.20 - - - 859.20
AHC AmeriHealth Caritas 37,972.50 38,147.50 - 271.00 76,391.00
Billie Driggers - 25.00 - - 25.00
Blair House 20.00 30.00 - - 50.00
Carrie Moore - 25.00 25.00 - 50.00
Christina Mazza - 25.00 25.00 - 50.00
City of Fort Madison 2,500.00 - - - 2,500.00
City of Keokuk 2,125.00 - - - 2,125.00
Great River Health Systems 5,000.00 - - - 5,000.00
Healthy Henry County Communities 5,000.00 - - - 5,000.00
Hope Haven 3,919.98 - - - 3,919.98
Inpropco 2,500.00 - - - 2,500.00
Iowa DOT 228.00 - - - 228.00
Iowa Medicaid Enterprise 288.21 - - - 288.21
James Mitchell 25.00 - - - 25.00
Lee County Payee Services North 90.00 - - - 90.00
Logisticare 600.92 - - - 600.92
Milestones Area Agency on Aging 1,212.47 2,137.50 - - 3,349.97
New London Comm. Child Care - 590.00 - - 590.00
New London Specialty Care 1,110.00 - - - 1,110.00
Priscilla Jensen - - - 50.00 50.00
Rebecca Shibley - - - 140.75 140.75
Ruth Boyd. - - - 1,535.89 1,535.89
Stacey Kitman - - - 5.00 5.00
Steve Anderson - 25.00 50.00 25.00 100.00
Tiffany Butler - 25.00 25.00 - 50.00
Tyrone Seay - - (25.00) - (25.00)
63,451.28 41,030.00 100.00 2,027.64 106,608.92
Total 308,813.67 117,179.00 37,850.00 5,034.64 468,877.31
Southeast Iowa Regional Planning Commission
Accounts Receivable Aging Summary
June 30, 2017
Schedule 6
Current 1 - 45 46 - 90 > 90 TOTAL
Ability Network Inc 294.00 - - - 294.00
Alliant Energy - 42.97 (128.12) - (85.15)
Card Center 1,798.61 - - - 1,798.61
Carquest Auto Parts 38.96 - - - 38.96
City of Burlington, Iowa 2,228.42 - - - 2,228.42
City of Keokuk. 2,597.39 - - - 2,597.39
City of Mount Pleasant 1,619.22 - - - 1,619.22
Clear Falls Bottled Water 68.50 14.50 - - 83.00
Collision Center 382.30 - - - 382.30
Commercial Contracting Services LLC 25,000.00 - - - 25,000.00
Craftsman Press 33.00 - - - 33.00
Daily Gate City 33.15 - - - 33.15
Deery Brothers Ford Lincoln Inc 3,505.95 - - - 3,505.95
Drake Hardware & Software 1,472.50 - - - 1,472.50
Embellishments & Designs Inc 37.75 - - - 37.75
Farmers Elevator & Exchange, Inc. 859.62 - - - 859.62
Fedex 180.15 - - - 180.15
Great River Business Health 94.00 - - - 94.00
Hope Haven Area Dev Center 440.00 - - - 440.00
Hy-Vee, Inc 0.54 - - - 0.54
IARC. 650.00 - - - 650.00
Integrated Technology Partners 145.00 - - - 145.00
Jeffrey Greiner 1,100.00 - - - 1,100.00
Lee County Recorder/Registrar 14.00 - - - 14.00
Lowell Gaulke 690.00 - - - 690.00
Lowes 94.98 - - - 94.98
Lyle Manning 27,800.00 - - - 27,800.00
Midwest Best Waterproofing 14,162.50 - - - 14,162.50
Midwest Old Threshers 6,000.00 - - - 6,000.00
Mutual Wheel Co. 232.95 - - - 232.95
Napa Auto Parts - (0.98) - - (0.98)
Norm's Koestner Electric Inc 523.06 - - - 523.06
O'Keefe Elevator Company 149.00 - - - 149.00
O'Reilly Automotive, Inc. 302.33 - - - 302.33
Pep Stop 7.00 - - - 7.00
Pitney Bowes - Purchase Power 110.98 - - - 110.98
Shafer Construction LLC. 55,265.07 - - - 55,265.07
Shottenkirk-Fort Madison 73.32 - - - 73.32
Shottenkirk Superstore 2,152.19 250.26 - - 2,402.45
Swailes Auto Supply Inc. 196.72 - - - 196.72
Team Staffing Solutions, Inc 1,466.10 - - - 1,466.10
The Burlington Hawk Eye 491.85 - - - 491.85
The Democrat Company 45.27 - - - 45.27
The Ivy 54.50 - - - 54.50
Titan Broadcasting LLC. 300.00 - - - 300.00
Todd Schneider dba Schoolhouse Apts - - - 15,000.00 15,000.00
Truck Country of Iowa 770.40 - - - 770.40
UnityPoint Clinic 120.00 - - - 120.00
Verizon Wireless 1,023.90 - - - 1,023.90
Waterworks Car Wash 5.00 - - - 5.00
Wemiga Waste Inc 30.00 - - - 30.00
Wex Bank 376.84 - - - 376.84
Winners Circle 114.75 - - - 114.75
Zachary James 6.95 - - - 6.95
155,158.72 306.75 (128.12) 15,000.00 170,337.35
Accounts Payable Aging Summary
Southeast Iowa Regional Planning Commission
June 30, 2017
Schedule 7
June 2017
TOTAL REVENUES : 1,000
TOTAL EXPENSES : 5,116
Excess of revenues over expenditures- note this is cash basis (4,116)
CASH BALANCE
Connection Bank 3,271
ACCOUNTS RECEIVABLE BALANCE
1-45 46-90 >90 TOTAL
City of Fort Madison - 4,500 - 4,500
City of Keokuk - 1,000 - 1,000
Lee County - 1,000 - 1,000
ACCOUNTS PAYABLE BALANCE
1-45 46-90 >90 TOTAL
none 0 0 0 0
CASH RECEIPTS - life to date
Alliant Energy 12/2/2013 FY14 5,000
State of Iowa 7/24/2014 FY15 2,500
Lee County Auditor 4/25/2016 FY16 1,000
City of Keokuk 8/29/2016 FY16 1,000
CASH DISBURSEMENTS - life to date
SEIRPC 7/25/2014 #1001 5,000
University of Iowa 7/25/2014 #1002 2,500
Delux 8/6/2014 electronic 131
SEIRPC 6/30/2015 #1003 2,694
service fee 10/31/2016 electronic 4
service fee 11/30/2016 electronic 4
service fee 12/31/2016 electronic 4
service fee 1/31/2017 electronic 4
service fee 2/28/2017 electronic 4
service fee 3/31/2017 electronic 4
SEIRPC 4/12/2017 #1004 5,080
service fee 4/30/2017 electronic 4
service fee 5/31/2017 electronic 4
service fee 6/30/2017 electronic 4
PROFIT & LOSS ALL CLASSES
Southeast Iowa Regional Economic and Port Authority
Financial Summary
June 30, 2017
Financial Report
July 2017
Dear SEIRPC Board: The accompanying Balance Sheet of Southeast Iowa Regional Planning Commission, as of July 31, 2017, and the related Statements of Income and Changes in Financial Position for the one month ended July 31, 2017. A compilation is limited to presenting, in the form of financial statements, information that is the representation of management. The statements have not been audited.
Lori Gilpin Finance Director
Completed August 31, 2017
TO: SEIRPC Board
FROM: Lori Gilpin
DATE: 8/29/2017
RE: Financial Summary for the month of July 2017
July 2017 YTD
TOTAL REVENUES : 359,080 359,080
TOTAL EXPENSES : 211,405 211,405
Excess of revenues over expenditures 147,675 147,675
July 2017 YTD
TOTAL REVENUES : 154,746 154,746
TOTAL EXPENSES : 60,663 60,663
Excess of revenues over expenditures 94,083 94,083
CASH BALANCE UNRESTRICTED RESTRICTED
Gen'l Government Chkng 883,734 -
IRP Government Chkng 342,726
Ft. Madison RLF Government Chkng 174,799
Henry County RLF Government Chkng 162,564
Henry County RTA Government Chkng 55,402
Keokuk RLF Regular Chkng 96,396
EDA RLF Government Chkng 421,371
Mediapolis HTF Government Chkng 105,226
GRHTF Government Chkng 407,755
TOTAL 939,136 1,710,837 2,649,973
CUSTOMER ACCOUNTS RECEIVABLE BALANCE
Current 1-45 46-90 >90 TOTAL
40,511 231,249 55,669 5,660 333,089
VENDOR ACCOUNTS PAYABLE BALANCE
Current 1-45 46-90 >90 TOTAL
79,468 8,245 17 14,872 102,603
PROFIT & LOSS ALL CLASSES
PROFIT & LOSS REGIONAL TRANSIT AUTHORITY
ASSETS
Current Assets
Checking/Savings
General Government Checking 883,733.73
IRP Government Checking 342,726.44
Ft. Madison RLF Checking 174,798.95
Henry County RLF Checking 162,563.65
Henry County RTA Checking 55,401.91
Keokuk RLF Checking 96,395.76
EDA RLF Government Checking 421,371.30
Mediapolis HTF Checking 105,225.96
GRHTF Checking 407,755.13
Total Checking/Savings 2,649,972.83
Accounts Receivable
Accounts Receivable 333,088.72
Other Current Assets
Petty Cash Account 302.00
13 Month CD 302,520.12
Ft. Madison RLF Receivable 18,729.23
Henry County RLF Receivable 31,782.08
Our Home Rehab Receivable 13,250.05
Mediapolis HTF Receivable 28,628.56
EDA RLF I Receivable 679,721.22
IRP I Loan Receivable 448,002.52
IRP II Loan Receivable 237,955.11
Keokuk RLF Receivable 69,357.19
GRHTF Receivable 24,148.06
EDA RLF II Receivable 630,080.30
Prepaid Insurance 104,528.33
Total Other Current Assets 2,589,004.77
Total Current Assets 5,572,066.32
Other Assets
Agency Vehicle/Equipment 99,760.92
A/D Agency Vehicle/Equipment (57,145.51)
Transit Vehicle 924,052.65
A/D Transit Vehicle (653,966.85)
Program Equipment 38,262.97
A/D Program Equipment (26,759.97)
Building/Bldg. Improvements 1,298,269.96
A/D Building/Bldg. Improvements (107,872.58)
Land 103,440.00
Pension Related Deferred Outflow 247,158.00
Total Other Assets 1,865,199.59
TOTAL ASSETS 7,437,265.91
Southeast Iowa Regional Planning Commission
Balance Sheet
July 31, 2017
Southeast Iowa Regional Planning Commission
Balance Sheet
July 31, 2017
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable 102,602.97
Payroll Liabilities 20,424.18
Speed Indicators Maintenance 3,202.78
Custodial Fund Liability 209.55
Accrued Vacation 16,520.73
Short Term Notes Payable 6,059.06
Total Current Liabilities 149,019.27
Long Term Liabilities
Long Term Notes Payable 883,152.91
Pension Related Dererred Inflow 177,993.00
Net Pension Liability 764,423.00
Total Liabilities 1,974,588.18
Equity
Unreserved local net Assets 589,508.27
Non-spendable Reserve for Loans 1,523,036.18
Assigned to Revolving loan 2,017,662.48
Pension Net Asset (774,574.00)
Investment in property & equipment 1,575,426.19
GRHTF Net Assets 383,943.92
Net Income (Loss) to date 147,674.69
Total Equity 5,462,677.73
TOTAL LIABILITIES & EQUITY 7,437,265.91
Jul-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 3,884.31 3,884.31 67,500 45,001 72,017 66,758
411.00 · Local Contracts 1,681.25 1,681.25 85,000 97,000 81,325 67,100
Total 4100 · Bus Fares 5,565.56 5,565.56 152,500 142,000 153,342 133,858
4500 · Federal/State Revenues
450.00 · EDA Planning Grant - - 70,000 66,000 61,000 91,500
450.01 · Marketing Grant - - - - - -
450.04 · EDA Facility Grant - - - - - -
450.05 · EDA RLF Grant - - - - - -
451.00 · IDED COG Assistance - - - 11,176 11,765 11,765
453.00 · PDM (Pre-Disaster Mitigation) - - - - 19,400 11,900
455.00 · IDOT Planning - - 234,748 196,241 187,177 165,267
456.00 · State Transit Assistance (RTA) 24,664.18 24,664.18 318,453 300,889 285,844 257,780
457.00 · Federal Transit Assistance (RTA) - - 298,175 555,526 327,865 288,460
458.00 · Housing Draws 29,399.00 29,399.00 - 2,424,889 5,480,818 2,905,347
459.00 · State Medicaid 35,477.33 35,477.33 385,000 461,526 412,393 403,906
Total 4500 · Federal/State Revenues 89,540.51 89,540.51 1,306,376 4,016,248 6,786,262 4,135,924
4600 - Principle on Loans
461.00 - Principal on Loans 17,212.41 17,212.41 748,639 334,209 456,963
4700 · Local Revenues
470.00 · Per Capita Revenue 182,018.00 182,018.00 174,927 172,776 170,335 165,603
471.00 · Cities/Counties - - - 62,805 11,994 26,424
472.00 · Other Contracts 28,045.00 28,045.00 263,925 163,678 371,173 309,495
473.00 · Grant Administration 1,250.00 1,250.00 - 140,572 103,696 64,595
474.00 · CDGB Housing Administration - - - - 1,026 13,775
475.00 · Other Contributions - - - 12,500 - -
475.01 · Homeowner Contributions - - - 12,284 3,859 12,489
476.00 · HOME Administration - - - 30,000 - -
478.00 · SIREPA Administration - - - 5,000 - -
479.00 · RLF Administration - - 15,198 37,540 30,483 37,081
481.00 · Housing Soft Costs - - - 51,025 164,697 152,416
482.00 · Lead Abatement 10,000.00 10,000.00 - - - -
488.00 · Vehicle Reimbursements 1,046.85 1,046.85 10,800 11,916 13,703 10,992
489.00 · Housing Administration - - 154,373 132,114 121,345 203,467
Total 4700 · Local Revenues 222,359.85 222,359.85 619,223 832,210 992,311 996,336
4900 · Miscellaneous Revenues
492.00 · Lease Income 9,452.29 9,452.29 115,000 114,177 116,312 112,729
494.00 · Vehicle Cost Recovery - - 7,341
496.00 · Interest Income (Bank) 362.45 362.45 3,855 8,361 5,756 6,760
497.00 · Miscellaneous Revenues-Other 7,300.00 7,300.00 5,000 24,072 32,660 20,402
498.00 · Matching Funds - - 128,687 - 113,117 -
Total 4900 · Miscellaneous Revenues 17,114.74 17,114.74 252,542 153,951 267,844 139,891
5000-52 RLF Income
507.00 · Late Payment Fees 50.00 50.00 - 412 285 700
508.00 · Loan Closing Fees 350.00 350.00 - 19,662 6,779 16,392
509.00 · FM RLF Loan Interest Income 36.69 36.69 400 493 550 420
510.00 · Henry Co. RLF Interest Income 127.86 127.86 1,500 1,783 2,280 2,917
511.01 · EDA RLF I Interest Income 2,121.15 2,121.15 20,000 23,523 25,485 21,856
512.00 · Mediapolis HTF Interest Income 63.44 63.44 1,650 1,162 1,137 1,359
513.00 · EDA RLF II Interest Income 1,974.71 1,974.71 21,000 23,529 20,179 22,289
515.00 · IRP I Loan Interest Income 1,464.75 1,464.75 15,000 16,469 17,192 9,157
516.00 · IRP II Loan Interest Income 759.54 759.54 7,000 8,322 7,843 7,583
518.00 · Keokuk RLF Loan Interest Income 331.12 331.12 2,600 2,390 1,097 1,028
520.00 · GRHTF-Loan Interest 7.21 7.21 - 107 238 475
Total 5000-52 RLF Income 7,286.47 7,286.47 69,150 97,853 83,065 84,176
Total Income 359,079.54 359,079.54 2,399,791 5,990,900 8,617,033 5,947,149
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date July 31, 2017
Jul-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date July 31, 2017
Expenditures:
701.00 · Salaries 43,150.35 43,150.35 1,081,935 1,050,400 1,144,949 1,091,362
702.00 · FICA - Employer's Share 3,046.95 3,046.95 79,120 76,313 83,352 78,602
703.00 · IPERS - Employer's Share 3,673.87 3,673.87 95,186 91,585 100,826 95,173
704.00 · Unemployment 7,064.00 7,064.00 500 17,073 - 9,906
705.00 · Employee Benefits 5,182.32 5,182.32 140,679 162,500 164,830 176,293
706.00 · Physicals 244.00 244.00 3,000 2,841 1,676 2,038
707.00 · Uniform Expense 204.17 204.17 3,500 1,936 2,914 3,665
708.00 · Drug Testing 120.00 120.00 1,700 1,310 1,005 939
709.00 · Personnel Expenses-Other 80.00 80.00 1,500 1,315 439 2,342
710.00 · Payroll services 373.54 373.54 5,000 4,722 4,974 4,758
712.00 · Advertising 64.50 64.50 7,000 6,221 7,665 9,015
717.00 · Audit - - 16,000 20,350 19,925 18,650
726.00 · Contractual Expenses-Other 1,304.95 1,304.95 15,000 29,008 66,486 36,686
728.00 · Information Technology - - 35,150 24,359 15,017 9,894
729.00 · Copier Expense 415.30 415.30 5,000 4,252 6,522 5,273
730.00 · Legal Expense - - 500 3,846 3,741 28,599
738.00 · Depreciation Expense 825.50 825.50 - 9,906 10,605 17,504
740.00 · Dues/Subscriptions/Conferences 6,964.68 6,964.68 28,000 19,768 16,961 15,388
741.00 · Public Notices 50.83 50.83 1,525 2,105 1,123 1,219
746.00 · Leased Equipment - - 1,000 608 760 456
747.00 · Equipment under $5000 788.00 788.00 14,000 25,807 17,687 12,936
748.00 · Capital Equipment/Improvements - - 115,000 361,840 65,731 -
749.00 · Principal Expense 35,020.61 35,020.61 67,087 34,674 34,331 39,949
750.00 · Lead Testing 520.00 520.00 2,000 2,857 2,977 2,199
751.00 · Housing 27,471.60 27,471.60 - 2,101,343 5,360,445 2,715,266
752.00 · Admin. Expense 15,000.00 15,000.00 - 100,401 52,874 160,677
754.00 · Insurance 8,585.57 8,585.57 97,500 95,131 104,443 101,517
756.00 · Mortgage Filing Fees 418.00 418.00 500 1,068 549 746
757.00 · Interest Expense 450.40 450.40 21,120 21,385 12,517 22,009
759.00 · Credit Report Exp. - - - - - -
766.00 · Bldg. Maintenance & Repair - - 35,000 40,237 9,075 13,585
767.00 · Vehicle Maintenance & Repair 17,521.17 17,521.17 125,500 126,177 110,674 115,504
768.00 · Marketing 325.02 325.02 13,000 7,287 5,386 3,389
769.00 · Meeting Expense 248.05 248.05 4,000 2,910 2,868 4,096
782.00 · Printing/Postage 57.02 57.02 6,100 5,659 4,400 5,707
791.00 · Rent 550.00 550.00 6,600 7,580 9,980 7,830
806.00 · Supplies 1,284.61 1,284.61 13,600 10,380 12,493 11,453
807.00 · Bank Charges - - - 1 103 38
808.00 · Fuel/Oil 7,333.11 7,333.11 112,500 84,213 80,946 108,521
810.00 · Telecommunications 2,086.27 2,086.27 28,650 24,068 27,563 24,711
811.00 - Utilities Expense 3,190.68 3,190.68 39,500 37,138 34,354 34,737
813.00 - Real Estate Taxes - - 11,000 10,802 12,632 16,166
815.00 · Mileage Expense 392.00 392.00 3,550 3,428 1,232 2,417
816.00 · Travel/Training 1,350.93 1,350.93 7,850 6,753 10,739 9,612
820.00 · Use Allowance 1,046.85 1,046.85 12,900 11,916 13,703 10,890
825.00 · Bad Debt Expense - - - - - 580
829.00 · Down Payment Assistance 15,000.00 15,000.00 - 273,377 131,933 203,750
830.00 · Participant Loans & Grants - - - 1,000,783 105,446 807,634
850.00 · Marketing Grant Expenditure - - - - - -
890.00 · Matching Expenditures - - 128,687 - 113,117 -
900.00 · Indirect Costs - - - - - -
Total Expenditures 211,404.85 211,404.85 2,386,939 5,927,631 7,991,968 6,043,679
Excess (deficiency) of revenues over (under)
expenditures 147,674.69 147,674.69 12,852 63,269 625,065 (96,530)
Schedule 1
Jul-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 3,884.31 3,884.31 67,500 45,001 72,017 66,758
411.00 · Local Contracts 1,681.25 1,681.25 85,000 97,000 81,325 67,100
Total 4100 · Bus Fares 5,565.56 5,565.56 152,500 142,000 153,342 133,858
4500 · Federal/State Revenues
456.00 · State Transit Assistance 24,664.18 24,664.18 318,453 300,889 285,844 257,780
457.00 · Federal Transit Assistance - - 298,175 555,526 327,865 288,460
459.00 · State Medicaid 35,477.33 35,477.33 385,000 461,526 412,393 403,906
Total 4500 · Federal/State Revenues 60,141.51 60,141.51 1,001,628 1,317,941 1,026,102 950,146
4700 · Local Revenues
470.00 · Per Capita Revenue 88,629.00 88,629.00 86,467 86,467 84,359 82,301
472.00 · Other Contracts - - - - - -
Total 4700 · Local Revenues 88,629.00 88,629.00 86,467 86,467 84,359 82,301
4900 · Miscellaneous Revenues
494.00 · Cost Recovery - - - 7,341 - -
496.00 · Interest Income (Bank) 10.34 10.34 85 118 110 96
497.00 · Miscellaneous Revenues 400.00 400.00 5,000 6,038 4,207 4,577
498.00 · Matching Funds - - - - - -
Total 4900 · Miscellaneous Revenues 410.34 410.34 5,085 13,497 4,318 4,673
Total Revenues 154,746.41 154,746.41 1,245,680 1,559,905 1,268,121 1,170,978
Expenditures:
701.00 · Salaries 14,960.43 14,960.43 380,693 377,981 393,742 390,756
702.00 · FICA - Employer's Share 1,140.84 1,140.84 28,767 28,814 29,607 29,267
703.00 · IPERS - Employer's Share 1,331.07 1,331.07 33,996 33,406 35,117 34,961
486.00 486.00 500 11,136 - 9,906
705.00 · Employee Benefits 2,360.98 2,360.98 45,157 57,272 57,750 62,646
706.00 · Physicals 244.00 244.00 3,000 2,841 1,676 2,038
707.00 · Uniform Expense 196.67 196.67 2,000 1,760 1,421 2,978
708.00 · Drug Testing 120.00 120.00 1,700 1,310 1,005 939
709.00 · Personnel Expenses-Other 80.00 80.00 1,500 805 419 1,980
712.00 · Advertising 64.50 64.50 2,000 4,740 2,287 7,775
726.00 · Contractual Expenses - - 1,000 13,503 25,593 6,595
728.00 · Information Technology - - 20,000 3,186 2,257 1,313
730.00 · Legal Expense - - 500 210 2,436 28,047
738.00 · Depreciation Expense - - - - - -
740.00 · Dues/Subscriptions/Conferences 2,364.00 2,364.00 5,000 2,553 4,196 2,531
741.00 · Public Notices - - - 419 18 16
747.00 · Equipment Under $5000 - - - 5,182 5,454 470
748.00 · Capital Equipment/Improvements - - 115,000 348,020 58,802 -
754.00 · Insurance 3,714.72 3,714.72 50,000 47,124 65,285 61,046
757.00 · Interest Expense - - - - - -
766.00 · Bldg. Maintenance & Repairs - - - - - -
767.00 · Vehicle Maintenance & Repair 16,905.01 16,905.01 125,000 123,995 109,804 115,183
768.00 · Marketing 300.00 300.00 3,000 3,653 775 750
769.00 · Meeting Expense 16.40 16.40 500 183 351 440
782.00 · Printing/Postage - - - 447 (52) 938
791.00 · Rent 550.00 550.00 6,600 7,550 9,950 7,800
806.00 · Supplies 279.12 279.12 1,100 1,215 818 802
807.00 · Bank Charges - - - 1 5 -
808.00 · Fuel/Oil 7,156.19 7,156.19 110,000 81,564 78,082 104,313
810.00 · Telecommunications 1,020.55 1,020.55 12,000 11,737 10,437 9,001
811.00 · Utilities 43.62 43.62 - 439 - -
815.00 · Mileage Expense 392.00 392.00 2,500 3,173 667 1,234
816.00 · Travel/Training - - 2,000 407 191 192
820.00 · Use Allowance 73.32 73.32 2,500 1,394 1,115 2,262
825.00 · Bad Debt Expense - - - - 2,531 580
- - 10,000 - 10,000 -
900.00 · Indirect Costs 6,863.84 6,863.84 172,603 174,515 172,560 184,649
Total Expenditures 60,663.26 60,663.26 1,138,616 1,350,535 1,084,300 1,071,408
Fund Balance 94,083.15 94,083.15 107,064 209,370 183,821 99,570
704.00 - Unemployment
890.00 - Matching Expenditures
Regional Transit Authority
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date July 31, 2017
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the One Month Ending
July 31, 2017
10 Company
Vehicles 20 EDA PG 22 Facility 47 Housing
48 Great
River
Housing
Trust
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues 0.00 0.00 0.00 0.00 0.00
4500 · Federal/State Revenues 0.00 0.00 0.00 29,399.00 0.00
461.00 · Principal on Loans 0.00 0.00 0.00 289.21 973.70
4700-48 · Local Revenues 1,046.85 0.00 0.00 10,000.00 0.00
4900 · Miscellaneous Revenues 0.00 0.00 9,452.29 19.89 6,966.52
5000-52 · RLF Income 0.00 0.00 0.00 63.44 407.21
1,046.85 0.00 9,452.29 39,771.54 8,347.43
Expense
700.00 · Personnel Expenses 0.00 3,592.67 0.00 3,738.30 825.40
704.00 · Unemployment 0.00 0.00 0.00 6,578.00 0.00
706.00 · Physicals 0.00 0.00 0.00 0.00 0.00
707.00 · Uniform Expense 0.00 0.00 0.00 0.00 0.00
708.00 · Drug Testing 0.00 0.00 0.00 0.00 0.00
709.00 · Personnel Expenses-Other 0.00 0.00 0.00 0.00 0.00
710.00 · Payroll Services 0.00 0.00 0.00 0.00 0.00
712.00 · Advertising 0.00 0.00 0.00 0.00 0.00
717.00 · Audit 0.00 0.00 0.00 0.00 0.00
726.00 · Contractual Expenses 0.00 0.00 1,304.95 0.00 0.00
728.00 · Information Technology 0.00 0.00 0.00 0.00 0.00
729.00 · Copier Expense 0.00 0.00 0.00 0.00 0.00
730.00 · Legal Expense 0.00 0.00 0.00 0.00 0.00
738.00 · Depreciation Expense 533.27 0.00 0.00 0.00 0.00
740.00 · Dues/Subscriptions/Conference 0.00 45.00 0.00 0.00 0.00
741.00 · Public Notices 0.00 0.00 0.00 0.00 26.70
746.00 · Leased Equipment 0.00 0.00 0.00 0.00 0.00
747.00 · Equipment under $5000 0.00 0.00 788.00 0.00 0.00
748.00 · Capital Equipment/Improvements 0.00 0.00 0.00 0.00 0.00
749.00 · Principal Expense 0.00 0.00 0.00 0.00 0.00
750.00 · Lead Testing 0.00 0.00 0.00 416.00 104.00
751.00 · Housing 0.00 0.00 0.00 3,170.00 24,301.60
752.00 · Admin. Expense 0.00 0.00 0.00 0.00 15,000.00
754.00 · Insurance 676.87 0.00 921.09 0.00 -655.84
756.00 · Mortgage Filing Expenses 0.00 0.00 0.00 104.00 14.00
757.00 · Interest Expense 13.14 0.00 110.87 0.00 0.00
760.00 · Housing Relocation Expense 0.00 0.00 0.00 0.00 0.00
766.00 · Bldg. Maintenance & Repairs 0.00 0.00 0.00 0.00 0.00
767.00 · Vehicle Maintenance & Repair 616.16 0.00 0.00 0.00 0.00
768.00 · Marketing 0.00 0.00 0.00 0.00 0.00
769.00 · Meeting Expense 0.00 0.00 0.00 0.00 0.00
782.00 · Printing/Postage 0.00 0.00 0.00 50.07 0.00
791.00 · Rent 0.00 0.00 0.00 0.00 0.00
806.00 · Supplies 0.00 0.00 0.00 2.34 0.00
807.00 · Bank Charges 0.00 0.00 0.00 0.00 0.00
808.00 · Fuel/Oil 168.07 0.00 8.85 0.00 0.00
810.00 · Telecommunications 0.00 0.00 3,147.06 0.00 0.00
811.00 · Utilities Expense 0.00 0.00 0.00 0.00 0.00
812.00 · Bldg Operation Allocation 0.00 0.00 0.00 0.00 0.00
813.00 · Real Estate Taxes 0.00 0.00 0.00 0.00 0.00
815.00 · Mileage Expense 0.00 0.00 0.00 0.00 0.00
816.00 · Travel/Training 0.00 0.00 0.00 200.00 210.51
820.00 · Use Allowance 19.06 0.00 0.00 29.39 66.22
829.00 · Down Payment Assistance 0.00 0.00 0.00 0.00 15,000.00
830.00 · Participant Loans 0.00 0.00 0.00 0.00 0.00
825.00 · Bad Debt Expense 0.00 0.00 0.00 0.00 0.00
850.00 · Marketing Grant Expenditure 0.00 0.00 0.00 0.00 0.00
900.00 · INDIRECT COSTS 0.00 1,244.39 0.00 1,290.50 286.48
2,026.57 4,882.06 6,280.82 15,578.60 55,179.07
(979.72) (4,882.06) 3,171.47 24,192.94 (46,831.64)
- - (53,452.66) (2,325.27) - SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the One Month Ending
July 31, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment/Improvements
749.00 · Principal Expense
750.00 · Lead Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Marketing Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
60 IDOT 71 EDA RLF 72 IRP-I
73.00
FM/KK/HC
RLF 76 IRP-II
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 11,728.19 2,405.27 775.88 1,040.16
0.00 0.00 0.00 0.00 0.00
0.00 77.45 67.61 63.53 0.00
0.00 4,095.86 1,464.75 495.67 759.54
0.00 15,901.50 3,937.63 1,335.08 1,799.70
7,810.54 1,676.48 513.08 879.57 366.49
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
111.00 0.00 0.00 0.00 0.00
12.32 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 21,507.02 0.00 13,513.59
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 18.50 29.00 0.00 3.50
0.00 0.00 97.98 0.00 228.41
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
25.02 0.00 0.00 0.00 0.00
10.00 0.00 0.00 0.00 0.00
6.95 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
189.78 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
643.50 0.00 0.00 0.00 0.00
73.65 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
2,719.02 581.22 177.94 307.50 124.63
11,601.78 2,276.20 22,325.02 1,187.07 14,236.62
(11,601.78) 13,625.30 (18,387.39) 148.01 (12,436.92)
(11,601.78) 1,897.11 714.36 - 36.51
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the One Month Ending
July 31, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment/Improvements
749.00 · Principal Expense
750.00 · Lead Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Marketing Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
80 Indirect
Cost Center 85 RTA 90 LOCAL TOTAL
0.00 5,565.56 0.00 5,565.56
0.00 60,141.51 0.00 89,540.51
0.00 0.00 0.00 17,212.41
0.00 88,629.00 122,684.00 222,359.85
0.00 410.34 57.11 17,114.74
0.00 0.00 0.00 7,286.47
0.00 154,746.41 122,741.11 359,079.54
11,371.64 19,793.32 4,486.00 55,053.49
0.00 486.00 0.00 7,064.00
0.00 244.00 0.00 244.00
7.50 196.67 0.00 204.17
0.00 120.00 0.00 120.00
0.00 80.00 0.00 80.00
373.54 0.00 0.00 373.54
0.00 64.50 0.00 64.50
0.00 0.00 0.00 0.00
0.00 0.00 0.00 1,304.95
0.00 0.00 0.00 0.00
415.30 0.00 0.00 415.30
0.00 0.00 0.00 0.00
292.23 0.00 0.00 825.50
4,364.68 2,364.00 80.00 6,964.68
0.00 0.00 11.81 50.83
0.00 0.00 0.00 0.00
0.00 0.00 0.00 788.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 35,020.61
0.00 0.00 0.00 520.00
0.00 0.00 0.00 27,471.60
0.00 0.00 0.00 15,000.00
3,928.73 3,714.72 0.00 8,585.57
0.00 0.00 249.00 418.00
0.00 0.00 0.00 450.40
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 16,905.01 0.00 17,521.17
0.00 300.00 0.00 325.02
221.65 16.40 0.00 248.05
0.00 0.00 0.00 57.02
0.00 550.00 0.00 550.00
800.33 279.12 13.04 1,284.61
0.00 0.00 0.00 0.00
0.00 7,156.19 0.00 7,333.11
1,065.72 1,020.55 0.00 5,233.33
0.00 43.62 0.00 43.62
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 392.00 0.00 392.00
0.00 0.00 296.92 1,350.93
388.90 73.32 396.31 1,046.85
0.00 0.00 0.00 15,000.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
(15,148.54) 6,863.84 1,553.02 0.00
8,081.68 60,663.26 7,086.10 211,404.85
(8,081.68) 94,083.15 115,655.01 147,674.69
- 94,083.15 115,655.01 145,006.43
Schedule 3
Type Date Num Name Amount
Bill Pmt -Check 07/06/2017 270109 Card Center 1,798.61
Bill Pmt -Check 07/06/2017 270110 Carquest Auto Parts 38.96
Bill Pmt -Check 07/06/2017 270111 City of West Burlington. 190.15
Bill Pmt -Check 07/06/2017 270112 Clear Falls Bottled Water 49.75
Bill Pmt -Check 07/06/2017 270113 Collision Center 382.30
Bill Pmt -Check 07/06/2017 270114 Commercial Contracting Services LLC 20,000.00
Bill Pmt -Check 07/06/2017 270115 Craftsman Press 33.00
Bill Pmt -Check 07/06/2017 270116 Daily Gate City 33.15
Bill Pmt -Check 07/06/2017 270117 Deery Brothers Ford Lincoln Inc 3,505.95
Bill Pmt -Check 07/06/2017 270118 Deni McClinton 114.44
Bill Pmt -Check 07/06/2017 270119 Dex Media East Inc 14.50
Bill Pmt -Check 07/06/2017 270120 Drake Hardware & Software 1,472.50
Bill Pmt -Check 07/06/2017 270121 Embellishments & Designs Inc 37.75
Bill Pmt -Check 07/06/2017 270122 i connect you. 975.82
Bill Pmt -Check 07/06/2017 270123 Integrated Technology Partners 145.00
Bill Pmt -Check 07/06/2017 270124 Jack Callas 110.25
Bill Pmt -Check 07/06/2017 270125 Lyle Manning 22,240.00
Bill Pmt -Check 07/06/2017 270126 Martin Wiegard 85.75
Bill Pmt -Check 07/06/2017 270127 Mutual Wheel Co. 232.95
Bill Pmt -Check 07/06/2017 270128 Norm's Koestner Electric Inc 523.06
Bill Pmt -Check 07/06/2017 270129 Pauwels Lawn Care 375.00
Bill Pmt -Check 07/06/2017 270130 Pitney Bowes - Purchase Power 110.98
Bill Pmt -Check 07/06/2017 270131 Shafer Construction LLC. 6,177.20
Bill Pmt -Check 07/06/2017 270132 Shottenkirk-Fort Madison 73.32
Bill Pmt -Check 07/06/2017 270133 Shottenkirk Superstore 2,361.98
Bill Pmt -Check 07/06/2017 270134 Sue Ballew 73.50
Bill Pmt -Check 07/06/2017 270135 Swailes Auto Supply Inc. 196.72
Bill Pmt -Check 07/06/2017 270136 Team Staffing Solutions, Inc 980.10
Bill Pmt -Check 07/06/2017 270137 The Burlington Hawk Eye 491.85
Bill Pmt -Check 07/06/2017 270138 The Ivy 54.50
Bill Pmt -Check 07/06/2017 270139 United States Treasury 40.68
Bill Pmt -Check 07/06/2017 270140 Verizon Wireless 1,023.90
Bill Pmt -Check 07/06/2017 270141 Waterworks Car Wash 5.00
Bill Pmt -Check 07/06/2017 270142 Commercial Contracting Services LLC 5,000.00
Bill Pmt -Check 07/06/2017 270143 Lyle Manning 5,560.00
Bill Pmt -Check 07/06/2017 270144 Shafer Construction LLC. 18,246.40
Bill Pmt -Check 07/06/2017 270145 Shafer Construction LLC. 22,617.47
Bill Pmt -Check 07/06/2017 270146 Shafer Construction LLC. 8,224.00
Bill Pmt -Check 07/19/2017 270147 Hope Haven Area Dev Center 100.00
Bill Pmt -Check 07/19/2017 270148 Ability Network Inc 294.00
Bill Pmt -Check 07/19/2017 270149 Brad Holtkamp Automotive, Inc. 1,094.12
Bill Pmt -Check 07/19/2017 270150 Brozene Hydraulic Services 63.06
Bill Pmt -Check 07/19/2017 270151 Burlington Kiwanis 120.00
Bill Pmt -Check 07/19/2017 270152 Carquest Auto Parts 91.99
Bill Pmt -Check 07/19/2017 270153 City of Burlington, Iowa 2,228.42
Bill Pmt -Check 07/19/2017 270154 City of Keokuk. 2,597.39
Bill Pmt -Check 07/19/2017 270155 City of Mount Pleasant 1,619.22
Bill Pmt -Check 07/19/2017 270156 Ebert Supply Company 195.75
Bill Pmt -Check 07/19/2017 270157 Farmers Elevator & Exchange, Inc. 859.62
Bill Pmt -Check 07/19/2017 270158 Great River Business Health 94.00
Southeast Iowa Regional Planning Commission
Check Register
July 31, 2017
Schedule 3
Type Date Num Name Amount
Southeast Iowa Regional Planning Commission
Check Register
July 31, 2017
Bill Pmt -Check 07/19/2017 270159 Hope Haven Area Dev Center 340.00
Bill Pmt -Check 07/19/2017 270160 Hy-Vee, Inc 0.54
Bill Pmt -Check 07/19/2017 270161 Integrated Technology Partners 19.95
Bill Pmt -Check 07/19/2017 270162 Iowa Illinois Office Solutions 234.54
Bill Pmt -Check 07/19/2017 270163 Jack Callas 49.00
Bill Pmt -Check 07/19/2017 270164 Lee County Recorder/Registrar 78.00
Bill Pmt -Check 07/19/2017 270165 Lowell Gaulke 690.00
Bill Pmt -Check 07/19/2017 270166 Lowes 94.98
Bill Pmt -Check 07/19/2017 270167 M & H Construction 3,170.00
Bill Pmt -Check 07/19/2017 270168 Martin Wiegard 36.75
Bill Pmt -Check 07/19/2017 270169 Mediacom 89.90
Bill Pmt -Check 07/19/2017 270170 Midwest Best Waterproofing 14,162.50
Bill Pmt -Check 07/19/2017 270171 Mt. Pleasant Glass 10.90
Bill Pmt -Check 07/19/2017 270172 O'Reilly Automotive, Inc. 302.33
Bill Pmt -Check 07/19/2017 270173 Pep Stop 7.00
Bill Pmt -Check 07/19/2017 270174 Sara Hecox 421.02
Bill Pmt -Check 07/19/2017 270175 Sue Ballew 36.75
Bill Pmt -Check 07/19/2017 270176 Team Staffing Solutions, Inc 486.00
Bill Pmt -Check 07/19/2017 270177 The Democrat Company 45.27
Bill Pmt -Check 07/19/2017 270178 Titan Broadcasting LLC. 300.00
Bill Pmt -Check 07/19/2017 270179 Truck Country of Iowa 770.40
Bill Pmt -Check 07/19/2017 270180 UnityPoint Clinic 120.00
Bill Pmt -Check 07/19/2017 270181 Wemiga Waste Inc 30.00
Bill Pmt -Check 07/19/2017 270182 Wex Bank 376.84
Bill Pmt -Check 07/19/2017 270183 Winners Circle 61.00
Bill Pmt -Check 07/19/2017 270184 Zachary James 6.95
154,894.68
Electronic Payment 07/01/2017 MetLife (dental ins.) 879.18
Electronic Payment 07/01/2017 Principal Financial (life ins.) 914.30
Electronic Payment 07/01/2017 Welmark 11,892.78
Electronic Payment 07/03/2017 IPERS 11,457.32
Electronic Payment 07/17/2017 Alliant Energy 2,956.91
Electronic Payment 07/20/2017 Two Rivers Bank - vehicle loan payment 520.94
Electronic Payment 07/03/2017 Two Rivers Bank - quarterly facility payment 10,000.00
Electronic Payment 07/28/2017 Two Rivers Bank - principal only facility payment 50,000.00
Electronic Payment 07/31/2017 Payroll 60,703.48
Electronic Payment 07/31/2017 Payroll Taxes 22,466.40
Electronic Payment 07/31/2017 Payroll Processing Fees 373.54
Electronic Payment 07/31/2017 Advantage fees 109.85
172,274.70
TOTAL EXPENDITURES 327,169.38
Schedule 4
BANCARD Services Credit Card Statement
STATEMENT DATE: 7/28/2017
PAYMENT DUE DATE: 8/22/2017
CHECK# 270225
DATE PAID 8/16/2017
Date Transaction Description Account# Type Class# Class Name Amount Receipt
MIKE NORRIS
12-Jul-17 Constant Contact.Com 740 Dues/Subscriptions 20 EDA 45.00 Yes
TOTAL 45.00
DEBORAH LAUGHLIN
28-Jun-17 Target - card for Roger 806 Supplies 85 RTA 4.27 Yes
28-Jun-17 Funeral Home Web - Roger's Dad 806 Supplies 85 RTA 87.14 Yes
29-Jun-17 Pizza Ranch - Exec Board 769 Meeting Expense 80 Indirect 60.96 Yes
03-Jul-17 HyVee Aisles 806 Supplies 80 Indirect 100.55 Yes
11-Jul-17 Occuscreen 709 Personnel expense 85 RTA 40.00 Yes
11-Jul-17 Occuscreen 709 Personnel expense 85 RTA 40.00 Yes
24-Jul-17 Target - card for Carolyn 806 Supplies 85 RTA 4.27 Yes
26-Jul-17 Happy Joes Pizza - SEIRPC Board 769 Meeting Expense 80 Indirect 113.19 Yes
TOTAL 450.38
ZACH JAMES
28-Jun-17 Larkburger - Denver CO 816 Travel/Training 60 IDOT 14.22 Yes
30-Jun-17 Los Cabos - Denver CO 816 Travel/Training 60 IDOT 16.50 Yes
01-Jul-17 Magnolia Hotel - Denver CO 816 Travel/Training 60 IDOT 612.78 Yes
11-Jul-17 McConnell Café - Burlington 769 Meeting Expense 60 IDOT 10.00 Yes
17-Jul-17 Lowes 806 Supplies 60 IDOT 130.79 Yes
21-Jul-17 USPS 782 Printing/Postage 60 IDOT 6.95 Yes
23-Jul-17 Facebook 768 Marketing 60 IDOT 25.02 Yes
25-Jul-17 Lowes - return 806 Supplies 60 IDOT (23.52) Yes
26-Jul-17 Wix.com 740 Dues/Subscriptions 60.07 SIREPA 111.00 Yes
TOTAL 903.74
JEFF HANAN
30-Jun-17 IFA Housing Conference 816 Travel/Training 47.00 Housing 200.00 Yes
06-Jul-17 Accurate Analytical (lead testing) 750 Lead Testing 47.082 HOME 104.00 Yes
10-Jul-17 Accurate Analytical (lead testing) 750 Lead Testing 47.012 WOO 312.00 Yes
11-Jul-17 Accurate Analytical (lead testing) 750 Lead Testing 47.012 WOO 104.00 Yes
25-Jul-17 ASFPM - webinar 740 Dues/Conferences 90 Local 40.00 Yes
25-Jul-17 ASFPM - webinar 740 Dues/Conferences 90 Local 40.00 Yes
26-Jul-17 Iowa Secretary of State 756 Mortgage filing expense 71.01 EDA I 15.00 Yes
26-Jul-17 Iowa Secretary of State 756 Mortgage filing expense 72.00 IRP I 15.00 Yes
Previous Balance (731.90)
TOTAL 98.10
LORI GILPIN
TOTAL 0.00
ROGER KELLER
12-Jul-17 Phillips 66 808 Fuel/Oil 85 RTA 13.35 Yes
TOTAL 13.35
BOB KUSKOWSKI
03-Jul-17 Casey's 808 Fuel/Oil 22 Facility 8.85 Yes
13-Jul-17 Away with Geese 747 Equip under $5000 22 Facility 788.00 Yes
TOTAL 796.85
TOTAL 2,307.42
ClassExpense
Hans Trousil Mike Norris
Schedule 5
Current 1 - 45 46 - 90 > 90 TOTAL
Local:
City of Burlington - 19,754.00 - - 19,754.00
City of Columbus City - 547.00 - 539.00 1,086.00
City of Fort Madison - 2,024.71 - - 2,024.71
City of Franklin - 359.00 - - 359.00
City of Fredonia - 435.00 - - 435.00
City of Hillsboro - 387.00 - - 387.00
City of Keokuk - 3,759.00 - - 3,759.00
City of Letts - 542.00 - - 542.00
City of Mediapolis 1,250.00 - - - 1,250.00
City of Middletown - 492.00 - - 492.00
City of Morning Sun - 885.00 - - 885.00
City of Olds - 424.00 - - 424.00
City of Salem - 541.00 - - 541.00
City of St. Paul - 348.00 - - 348.00
City of Westwood - 335.00 - - 335.00
Henry County Auditor - 4,013.26 - - 4,013.26
IARC - - - 500.00 500.00
Iowa DOT - 60,732.00 - - 60,732.00
Iowa Economic Development Authority. - 4,558.00 - - 4,558.00
JK Homes - - - 550.00 550.00
Low Rent Housing Agnecy - 8,900.00 - - 8,900.00
SEIRPC - Keokuk RLF - 2,390.00 - - 2,390.00
1,250.00 111,425.97 - 1,589.00 114,264.97
Housing:
City of Burlington - 9,400.00 - - 9,400.00
City of Mediapolis - 5,579.42 - - 5,579.42
City of New London - 3,745.00 - - 3,745.00
City of Wayland - 46,130.00 - - 46,130.00
ECIA - - 25,449.00 - 25,449.00
Historic Tama LLC - 11,750.00 - - 11,750.00
IFA - 2,500.00 30,000.00 1,918.00 34,418.00
- 79,104.42 55,449.00 1,918.00 136,471.42
RTA:
A2C 876.40 100.00 - - 976.40
AHC AmeriHealth Caritas 33,868.50 37,780.50 120.00 271.00 72,040.00
Billie Driggers - 25.00 25.00 - 50.00
Blair House 20.00 20.00 - - 40.00
Carrie Moore - 25.00 25.00 25.00 75.00
Christina Mazza - 25.00 25.00 25.00 75.00
Hope Haven 717.36 - - - 717.36
Inpropco - 2,500.00 - - 2,500.00
Iowa Medicaid Enterprise 362.11 118.24 - - 480.35
James Mitchell - 25.00 - - 25.00
John Buttgen - 25.00 - - 25.00
Logisticare 444.08 - - - 444.08
Milestones Area Agency on Aging 1,681.25 - - - 1,681.25
New London Comm. Child Care 677.50 - - - 677.50
New London Specialty Care 588.75 - - - 588.75
Pleasant Manor Care Center 25.00 - - - 25.00
Priscilla Jensen - - - 50.00 50.00
Rebecca Shibley - - - 140.75 140.75
Ruth Boyd. - - - 1,535.89 1,535.89
Stacey Kitman - - - 5.00 5.00
Steve Anderson - 25.00 25.00 75.00 125.00
Tiffany Butler - 25.00 - 25.00 50.00
Travis Spitznogle - 25.00 - - 25.00
39,260.95 40,718.74 220.00 2,152.64 82,352.33
Total 40,510.95 231,249.13 55,669.00 5,659.64 333,088.72
Southeast Iowa Regional Planning Commission
Accounts Receivable Aging Summary
July 31, 2017
Schedule 6
Current 1 - 45 46 - 90 > 90 TOTAL
Access Systems 415.30 - - - 415.30
Alliant Energy 43.62 24.58 18.39 (128.12) (41.53)
American Planning Association 354.00 - - - 354.00
Anna Dobson and Connection Bank 7,500.00 - - - 7,500.00
Brad Holtkamp Automotive, Inc. 2,321.15 - - - 2,321.15
Burlington True Value 8.59 - - - 8.59
C-CAT, Inc. 100.00 - - - 100.00
Card Center 2,307.42 - - - 2,307.42
Chets Carpentry 13,000.00 - - - 13,000.00
City of Burlington, Iowa 1,866.50 - - - 1,866.50
City of Keokuk. 2,023.95 - - - 2,023.95
City of Mount Pleasant 2,107.99 - - - 2,107.99
Clear Falls Bottled Water 60.25 33.25 - - 93.50
Dave's Lock & Key 36.00 - - - 36.00
Deery Brothers Ford Lincoln Inc 5,127.95 - - - 5,127.95
Des Moines County Recorder's Office 21.00 - - - 21.00
Dex Media East Inc 50.00 - - - 50.00
Embellishments & Designs Inc 7.50 - - - 7.50
Farmers Elevator & Exchange, Inc. 871.73 - - - 871.73
Federal Home Loan Bank of Des Moines 1,170.00 - - - 1,170.00
Fedex 50.07 180.15 - - 230.22
Fullenkamp Insurance Agency 1,913.95 - - - 1,913.95
Great River Business Health 94.00 - - - 94.00
Henry County Recorders Office 7.00 - - - 7.00
Hope Haven Area Dev Center 340.00 - - - 340.00
Hy-Vee, Inc 50.00 - - - 50.00
IARC. 3,850.00 650.00 - - 4,500.00
ICAP 206.05 - - - 206.05
Iowa Illinois Office Solutions 333.80 - - - 333.80
Iowa Workforce Development - Tax Bureau 7,064.00 - - - 7,064.00
IPTA 2,364.00 - - - 2,364.00
JLG Properties 550.00 1,100.00 - - 1,650.00
Kempker's True Value 12.68 - - - 12.68
Lee County Recorder/Registrar - 14.00 - - 14.00
Louisa County Recorder's Office 228.00 - - - 228.00
Lowell Gaulke 1,137.00 - - - 1,137.00
Marilyn Hunter 85.41 - - - 85.41
Midwest Old Threshers - 6,000.00 - - 6,000.00
Mt. Pleasant Tire & Service 1,259.82 - - - 1,259.82
Napa Auto Parts - - (0.98) - (0.98)
O'Keefe Elevator Company - 149.00 - - 149.00
O'Reilly Automotive, Inc. 911.20 - - - 911.20
Pauwels Lawn Care 470.00 - - - 470.00
Pep Stop 6.00 - - - 6.00
Petty Cash 213.17 - - - 213.17
Precison Repair 44.40 - - - 44.40
Quincy Medical Group 150.00 - - - 150.00
Shottenkirk-Fort Madison 160.14 - - - 160.14
Shottenkirk Superstore 2,494.59 40.47 - - 2,535.06
Southeast Iowa Housing Inc. 11,301.60 - - - 11,301.60
Stephanie Lathrop. 10.22 - - - 10.22
Swailes Auto Supply Inc. 543.47 - - - 543.47
The Burlington Hawk Eye 50.83 - - - 50.83
The Ivy 111.50 - - - 111.50
Thomas Bus Sales 605.00 - - - 605.00
Titan Broadcasting LLC. 300.00 - - - 300.00
Todd Schneider dba Schoolhouse Apts - - - 15,000.00 15,000.00
UnityPoint Clinic 120.00 - - - 120.00
Verizon Wireless 1,020.55 - - - 1,020.55
Waterworks Car Wash 10.00 - - - 10.00
WB Collision Center Inc 1,501.03 - - - 1,501.03
Wemiga Waste Inc 30.00 - - - 30.00
Wex Bank 371.30 - - - 371.30
Winners Circle 104.75 53.75 - - 158.50
79,468.48 8,245.20 17.41 14,871.88 102,602.97
Accounts Payable Aging Summary
Southeast Iowa Regional Planning Commission
July 31, 2017
Schedule 7
July 2017
TOTAL REVENUES : -
TOTAL EXPENSES : 4
Excess of revenues over expenditures- note this is cash basis (4)
CASH BALANCE
Connection Bank 3,267
ACCOUNTS RECEIVABLE BALANCE
1-45 46-90 >90 TOTAL
City of Fort Madison - 4,500 - 4,500
City of Keokuk - 1,000 - 1,000
Lee County - 1,000 - 1,000
ACCOUNTS PAYABLE BALANCE
1-45 46-90 >90 TOTAL
none 0 0 0 0
CASH RECEIPTS - life to date
Alliant Energy 12/2/2013 FY14 5,000
State of Iowa 7/24/2014 FY15 2,500
Lee County Auditor 4/25/2016 FY16 1,000
City of Keokuk 8/29/2016 FY16 1,000
CASH DISBURSEMENTS - life to date
SEIRPC 7/25/2014 #1001 5,000
University of Iowa 7/25/2014 #1002 2,500
Delux 8/6/2014 electronic 131
SEIRPC 6/30/2015 #1003 2,694
service fee 10/31/2016 electronic 4
service fee 11/30/2016 electronic 4
service fee 12/31/2016 electronic 4
service fee 1/31/2017 electronic 4
service fee 2/28/2017 electronic 4
service fee 3/31/2017 electronic 4
SEIRPC 4/12/2017 #1004 5,080
service fee 4/30/2017 electronic 4
service fee 5/31/2017 electronic 4
service fee 6/30/2017 electronic 4
service fee 7/31/2017 electronic 4
PROFIT & LOSS ALL CLASSES
Southeast Iowa Regional Economic and Port Authority
Financial Summary
July 31, 2017
Financial Report
August 2017
Dear SEIRPC Board: The accompanying Balance Sheet of Southeast Iowa Regional Planning Commission, as of August 31, 2017, and the related Statements of Income and Changes in Financial Position for the two months ended August 31, 2017. A compilation is limited to presenting, in the form of financial statements, information that is the representation of management. The statements have not been audited.
Lori Gilpin Finance Director
Completed September 20, 2017
TO: SEIRPC Board
FROM: Lori Gilpin
DATE: 9/20/2017
RE: Financial Summary for the month of August 2017
August 2017 YTD
TOTAL REVENUES : 287,740 646,819
TOTAL EXPENSES : 370,886 582,313
Excess of revenues over expenditures (83,146) 64,506
August 2017 YTD
TOTAL REVENUES : 69,991 224,737
TOTAL EXPENSES : 78,273 138,936
Excess of revenues over expenditures (8,282) 85,801
CASH BALANCE UNRESTRICTED RESTRICTED
Gen'l Government Chkng 996,624 -
IRP Government Chkng 348,461
Ft. Madison RLF Government Chkng 175,067
Henry County RLF Government Chkng 163,124
Henry County RTA Government Chkng 55,705
Keokuk RLF Regular Chkng 97,585
EDA RLF Government Chkng 437,276
Mediapolis HTF Government Chkng 105,711
GRHTF Government Chkng 360,932
TOTAL 1,052,329 1,688,155 2,740,484
CUSTOMER ACCOUNTS RECEIVABLE BALANCE
Current 1-45 46-90 >90 TOTAL
44,516 167,030 47,911 31,079 290,536
VENDOR ACCOUNTS PAYABLE BALANCE
Current 1-45 46-90 >90 TOTAL
176,472 66 78 14,889 191,506
PROFIT & LOSS ALL CLASSES
PROFIT & LOSS REGIONAL TRANSIT AUTHORITY
ASSETS
Current Assets
Checking/Savings
General Government Checking 996,623.53
IRP Government Checking 348,460.72
Ft. Madison RLF Checking 175,066.63
Henry County RLF Checking 163,124.42
Henry County RTA Checking 55,704.80
Keokuk RLF Checking 97,585.43
EDA RLF Government Checking 437,275.69
Mediapolis HTF Checking 105,710.50
GRHTF Checking 360,931.72
Total Checking/Savings 2,740,483.44
Accounts Receivable
Accounts Receivable 290,535.94
Other Current Assets
Petty Cash Account 302.00
13 Month CD 302,520.12
SE Iowa Housing Inc. Receivable 25.00
Ft. Madison RLF Receivable 18,534.31
Henry County RLF Receivable 31,391.07
Our Home Rehab Receivable 13,250.05
Mediapolis HTF Receivable 28,343.79
EDA RLF I Receivable 674,403.14
IRP I Loan Receivable 445,694.40
IRP II Loan Receivable 236,989.89
Keokuk RLF Receivable 68,458.87
GRHTF Receivable 23,404.54
EDA RLF II Receivable 623,951.30
Prepaid Insurance 95,025.76
Total Other Current Assets 2,562,294.24
Total Current Assets 5,593,313.62
Other Assets
Agency Vehicle/Equipment 99,760.92
A/D Agency Vehicle/Equipment (57,971.01)
Transit Vehicle 924,052.65
A/D Transit Vehicle (660,226.69)
Program Equipment 38,262.97
A/D Program Equipment (27,005.72)
Building/Bldg. Improvements 1,298,269.96
A/D Building/Bldg. Improvements (109,224.66)
Land 103,440.00
Pension Related Deferred Outflow 247,158.00
Total Other Assets 1,856,516.42
TOTAL ASSETS 7,449,830.04
Southeast Iowa Regional Planning Commission
Balance Sheet
August 31, 2017
Southeast Iowa Regional Planning Commission
Balance Sheet
August 31, 2017
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable 191,505.72
Payroll Liabilities 21,254.56
Deferred Revenue - RTA 31,676.90
Speed Indicators Maintenance 3,117.83
Custodial Fund Liability 209.55
Accrued Vacation 16,520.73
Short Term Notes Payable 5,556.97
Total Current Liabilities 269,842.26
Long Term Liabilities
Long Term Notes Payable 883,152.91
Pension Related Dererred Inflow 177,993.00
Net Pension Liability 764,423.00
Total Liabilities 2,095,411.17
Equity
Unreserved local net Assets 589,508.27
Non-spendable Reserve for Loans 1,505,803.22
Assigned to Revolving loan 2,017,662.48
Pension Net Asset (774,574.00)
Investment in property & equipment 1,567,568.52
GRHTF Net Assets 383,943.92
Net Income (Loss) to date 64,506.46
Total Equity 5,354,418.87
TOTAL LIABILITIES & EQUITY 7,449,830.04
Aug-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 3,769.26 7,653.57 67,500 45,001 72,017 66,758
411.00 · Local Contracts 1,987.50 3,668.75 85,000 97,000 81,325 67,100
Total 4100 · Bus Fares 5,756.76 11,322.32 152,500 142,000 153,342 133,858
4500 · Federal/State Revenues
450.00 · EDA Planning Grant - - 70,000 66,000 61,000 91,500
450.01 · Marketing Grant - - - - - -
450.04 · EDA Facility Grant - - - - - -
450.05 · EDA RLF Grant - - - - - -
451.00 · IDED COG Assistance - - - 11,176 11,765 11,765
453.00 · PDM (Pre-Disaster Mitigation) - - - - 19,400 11,900
455.00 · IDOT Planning - - 234,748 196,241 187,177 165,267
456.00 · State Transit Assistance (RTA) 22,467.51 47,131.69 318,453 300,889 285,844 257,780
457.00 · Federal Transit Assistance (RTA) - - 298,175 555,526 327,865 288,460
458.00 · Housing Draws 164,715.00 194,114.00 - 2,424,889 5,480,818 2,905,347
459.00 · State Medicaid 41,231.34 76,708.67 385,000 461,526 412,393 403,906
Total 4500 · Federal/State Revenues 228,413.85 317,954.36 1,306,376 4,016,248 6,786,262 4,135,924
4600 - Principle on Loans
461.00 - Principal on Loans 17,243.18 34,455.59 748,639 334,209 456,963
4700 · Local Revenues
470.00 · Per Capita Revenue - 182,018.00 174,927 172,776 170,335 165,603
471.00 · Cities/Counties - - - 62,805 11,994 26,424
472.00 · Other Contracts 30.00 28,075.00 263,925 163,678 371,173 309,495
473.00 · Grant Administration 15,000.00 16,250.00 - 140,572 103,696 64,595
474.00 · CDGB Housing Administration - - - - 1,026 13,775
475.00 · Other Contributions - - - 12,500 - -
475.01 · Homeowner Contributions - - - 12,284 3,859 12,489
476.00 · HOME Administration - - - 30,000 - -
478.00 · SIREPA Administration - - - 5,000 - -
479.00 · RLF Administration - - 15,198 37,540 30,483 37,081
481.00 · Housing Soft Costs 1,500.00 1,500.00 - 51,025 164,697 152,416
482.00 · Lead Abatement - 10,000.00 - - - -
488.00 · Vehicle Reimbursements 1,062.41 2,109.26 10,800 11,916 13,703 10,992
489.00 · Housing Administration - - 154,373 132,114 121,345 203,467
Total 4700 · Local Revenues 17,592.41 239,952.26 619,223 832,210 992,311 996,336
4900 · Miscellaneous Revenues
492.00 · Lease Income 9,452.29 18,904.58 115,000 114,177 116,312 112,729
494.00 · Vehicle Cost Recovery - - 7,341
496.00 · Interest Income (Bank) 483.50 845.95 3,855 8,361 5,756 6,760
497.00 · Miscellaneous Revenues-Other 1,275.00 8,575.00 5,000 24,072 32,660 20,402
498.00 · Matching Funds - - 128,687 - 113,117 -
Total 4900 · Miscellaneous Revenues 11,210.79 28,325.53 252,542 153,951 267,844 139,891
5000-52 RLF Income
507.00 · Late Payment Fees 75.00 125.00 - 412 285 700
508.00 · Loan Closing Fees - 350.00 - 19,662 6,779 16,392
509.00 · FM RLF Loan Interest Income 40.07 76.76 400 493 550 420
510.00 · Henry Co. RLF Interest Income 139.32 267.18 1,500 1,783 2,280 2,917
511.01 · EDA RLF I Interest Income 2,219.47 4,340.62 20,000 23,523 25,485 21,856
512.00 · Mediapolis HTF Interest Income 180.06 243.50 1,650 1,162 1,137 1,359
513.00 · EDA RLF II Interest Income 2,157.50 4,132.21 21,000 23,529 20,179 22,289
515.00 · IRP I Loan Interest Income 1,561.90 3,026.65 15,000 16,469 17,192 9,157
516.00 · IRP II Loan Interest Income 834.48 1,594.02 7,000 8,322 7,843 7,583
518.00 · Keokuk RLF Loan Interest Income 291.35 622.47 2,600 2,390 1,097 1,028
520.00 · GRHTF-Loan Interest 23.78 30.99 - 107 238 475
Total 5000-52 RLF Income 7,522.93 14,809.40 69,150 97,853 83,065 84,176
Total Income 287,739.92 646,819.46 2,399,791 5,990,900 8,617,033 5,947,149
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date August 31, 2017
Aug-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Southeast Iowa Regional Planning Commission
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date August 31, 2017
Expenditures:
701.00 · Salaries 89,985.89 133,136.24 1,081,935 1,050,400 1,144,949 1,091,362
702.00 · FICA - Employer's Share 6,333.47 9,380.42 79,120 76,313 83,352 78,602
703.00 · IPERS - Employer's Share 7,657.25 11,331.12 95,186 91,585 100,826 95,173
704.00 · Unemployment - 7,064.00 500 17,073 - 9,906
705.00 · Employee Benefits 11,662.79 16,845.11 140,679 162,500 164,830 176,293
706.00 · Physicals 94.00 338.00 3,000 2,841 1,676 2,038
707.00 · Uniform Expense 81.70 285.87 3,500 1,936 2,914 3,665
708.00 · Drug Testing 235.00 355.00 1,700 1,310 1,005 939
709.00 · Personnel Expenses-Other - 80.00 1,500 1,315 439 2,342
710.00 · Payroll services 376.78 750.32 5,000 4,722 4,974 4,758
712.00 · Advertising 84.00 148.50 7,000 6,221 7,665 9,015
717.00 · Audit - - 16,000 20,350 19,925 18,650
726.00 · Contractual Expenses-Other 269.95 1,574.90 15,000 29,008 66,486 36,686
728.00 · Information Technology 4,602.28 4,602.28 35,150 24,359 15,017 9,894
729.00 · Copier Expense 141.57 556.87 5,000 4,252 6,522 5,273
730.00 · Legal Expense - - 500 3,846 3,741 28,599
738.00 · Depreciation Expense 825.50 1,651.00 - 9,906 10,605 17,504
740.00 · Dues/Subscriptions/Conferences 904.90 7,869.58 28,000 19,768 16,961 15,388
741.00 · Public Notices 253.53 326.88 1,525 2,105 1,123 1,219
746.00 · Leased Equipment - - 1,000 608 760 456
747.00 · Equipment under $5000 - 788.00 14,000 25,807 17,687 12,936
748.00 · Capital Equipment/Improvements - - 115,000 361,840 65,731 -
749.00 · Principal Expense - 35,020.61 67,087 34,674 34,331 39,949
750.00 · Lead/Radon Testing 125.00 645.00 2,000 2,857 2,977 2,199
751.00 · Housing 208,893.80 236,365.40 - 2,101,343 5,360,445 2,715,266
752.00 · Admin. Expense - 15,000.00 - 100,401 52,874 160,677
754.00 · Insurance 9,502.57 18,088.14 97,500 95,131 104,443 101,517
756.00 · Mortgage Filing Fees 40.00 458.00 500 1,068 549 746
757.00 · Interest Expense 18.85 469.25 21,120 21,385 12,517 22,009
759.00 · Credit Report Exp. - - - - - -
766.00 · Bldg. Maintenance & Repair - - 35,000 40,237 9,075 13,585
767.00 · Vehicle Maintenance & Repair 5,623.48 23,144.65 125,500 126,177 110,674 115,504
768.00 · Marketing 1,049.98 1,375.00 13,000 7,287 5,386 3,389
769.00 · Meeting Expense 176.13 424.18 4,000 2,910 2,868 4,096
782.00 · Printing/Postage 503.50 560.52 6,100 5,659 4,400 5,707
791.00 · Rent 550.00 1,100.00 6,600 7,580 9,980 7,830
806.00 · Supplies 467.40 1,752.01 13,600 10,380 12,493 11,453
807.00 · Bank Charges 5.00 5.00 - 1 103 38
808.00 · Fuel/Oil 8,138.79 15,471.90 112,500 84,213 80,946 108,521
810.00 · Telecommunications 2,101.81 4,188.08 28,650 24,068 27,563 24,711
811.00 - Utilities Expense 4,143.97 7,334.65 39,500 37,138 34,354 34,737
813.00 - Real Estate Taxes - - 11,000 10,802 12,632 16,166
815.00 · Mileage Expense 551.00 943.00 3,550 3,428 1,232 2,417
816.00 · Travel/Training 1,340.83 2,691.76 7,850 6,753 10,739 9,612
820.00 · Use Allowance 1,062.41 2,109.26 12,900 11,916 13,703 10,890
825.00 · Bad Debt Expense - - - - - 580
829.00 · Down Payment Assistance - 15,000.00 - 273,377 131,933 203,750
830.00 · Participant Loans & Grants - - - 1,000,783 105,446 807,634
850.00 · Grant Expenditures 3,082.50 3,082.50 - - - -
890.00 · Matching Expenditures - - 128,687 - 113,117 -
900.00 · Indirect Costs - - - - - -
Total Expenditures 370,885.63 582,313.00 2,386,939 5,927,631 7,991,968 6,043,679
Excess (deficiency) of revenues over (under)
expenditures (83,145.71) 64,506.46 12,852 63,269 625,065 (96,530)
Schedule 1
Aug-2017 Year-to-Date FY18 Budget FY17 Actual FY16 Actual FY15 Actual
Revenues:
4100 · Bus Fare Revenues
410.00 · General Public 3,769.26 7,653.57 67,500 45,001 72,017 66,758
411.00 · Local Contracts 1,987.50 3,668.75 85,000 97,000 81,325 67,100
Total 4100 · Bus Fares 5,756.76 11,322.32 152,500 142,000 153,342 133,858
4500 · Federal/State Revenues
456.00 · State Transit Assistance 22,467.51 47,131.69 318,453 300,889 285,844 257,780
457.00 · Federal Transit Assistance - - 298,175 555,526 327,865 288,460
459.00 · State Medicaid 41,231.34 76,708.67 385,000 461,526 412,393 403,906
Total 4500 · Federal/State Revenues 63,698.85 123,840.36 1,001,628 1,317,941 1,026,102 950,146
4700 · Local Revenues
470.00 · Per Capita Revenue - 88,629.00 86,467 86,467 84,359 82,301
472.00 · Other Contracts - - - - - -
Total 4700 · Local Revenues - 88,629.00 86,467 86,467 84,359 82,301
4900 · Miscellaneous Revenues
494.00 · Cost Recovery - - - 7,341 - -
496.00 · Interest Income (Bank) 10.39 20.73 85 118 110 96
497.00 · Miscellaneous Revenues 525.00 925.00 5,000 6,038 4,207 4,577
498.00 · Matching Funds - - - - - -
Total 4900 · Miscellaneous Revenues 535.39 945.73 5,085 13,497 4,318 4,673
Total Revenues 69,991.00 224,737.41 1,245,680 1,559,905 1,268,121 1,170,978
Expenditures:
701.00 · Salaries 32,813.72 47,774.15 380,693 377,981 393,742 390,756
702.00 · FICA - Employer's Share 2,474.25 3,615.09 28,767 28,814 29,607 29,267
703.00 · IPERS - Employer's Share 2,920.46 4,251.53 33,996 33,406 35,117 34,961
- 486.00 500 11,136 - 9,906
705.00 · Employee Benefits 3,330.90 5,691.88 45,157 57,272 57,750 62,646
706.00 · Physicals 94.00 338.00 3,000 2,841 1,676 2,038
707.00 · Uniform Expense 81.70 278.37 2,000 1,760 1,421 2,978
708.00 · Drug Testing 235.00 355.00 1,700 1,310 1,005 939
709.00 · Personnel Expenses-Other - 80.00 1,500 805 419 1,980
712.00 · Advertising 84.00 148.50 2,000 4,740 2,287 7,775
726.00 · Contractual Expenses - - 1,000 13,503 25,593 6,595
728.00 · Information Technology 128.25 128.25 20,000 3,186 2,257 1,313
730.00 · Legal Expense - - 500 210 2,436 28,047
738.00 · Depreciation Expense - - - - - -
740.00 · Dues/Subscriptions/Conferences - 2,364.00 5,000 2,553 4,196 2,531
741.00 · Public Notices - - - 419 18 16
747.00 · Equipment Under $5000 - - - 5,182 5,454 470
748.00 · Capital Equipment/Improvements - - 115,000 348,020 58,802 -
754.00 · Insurance 3,714.72 7,429.44 50,000 47,124 65,285 61,046
757.00 · Interest Expense - - - - - -
766.00 · Bldg. Maintenance & Repairs - - - - - -
767.00 · Vehicle Maintenance & Repair 5,536.31 22,441.32 125,000 123,995 109,804 115,183
768.00 · Marketing 1,025.00 1,325.00 3,000 3,653 775 750
769.00 · Meeting Expense 44.79 61.19 500 183 351 440
782.00 · Printing/Postage - - - 447 (52) 938
791.00 · Rent 550.00 1,100.00 6,600 7,550 9,950 7,800
806.00 · Supplies 207.72 486.84 1,100 1,215 818 802
807.00 · Bank Charges - - - 1 5 -
808.00 · Fuel/Oil 7,785.40 14,941.59 110,000 81,564 78,082 104,313
810.00 · Telecommunications 1,020.55 2,041.10 12,000 11,737 10,437 9,001
811.00 · Utilities 22.65 66.27 - 439 - -
815.00 · Mileage Expense 551.00 943.00 2,500 3,173 667 1,234
816.00 · Travel/Training 817.02 817.02 2,000 407 191 192
820.00 · Use Allowance 291.04 364.36 2,500 1,394 1,115 2,262
825.00 · Bad Debt Expense - - - - 2,531 580
- - 10,000 - 10,000 -
900.00 · Indirect Costs 14,544.53 21,408.37 172,603 174,515 172,560 184,649
Total Expenditures 78,273.01 138,936.27 1,138,616 1,350,535 1,084,300 1,071,408
Fund Balance (8,282.01) 85,801.14 107,064 209,370 183,821 99,570
704.00 - Unemployment
890.00 - Matching Expenditures
Regional Transit Authority
Statement of Revenues, Expenditures and Changes in Fund Balance
For the One Month and Year-to-Date August 31, 2017
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Two Months Ending
August 31, 2017
10 Company
Vehicles 20 EDA PG 22 Facility 47 Housing
48 Great
River
Housing
Trust
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues 0.00 0.00 0.00 0.00 0.00
4500 · Federal/State Revenues 0.00 0.00 0.00 194,114.00 0.00
461.00 · Principal on Loans 0.00 0.00 0.00 573.98 1,727.44
4700-48 · Local Revenues 2,109.26 0.00 0.00 11,500.00 15,000.00
4900 · Miscellaneous Revenues 0.00 0.00 18,904.58 39.60 7,790.16
5000-52 · RLF Income 0.00 0.00 0.00 243.50 505.99
2,109.26 0.00 18,904.58 206,471.08 25,023.59
Expense
700.00 · Personnel Expenses 0.00 11,417.11 145.33 10,829.42 2,602.24
704.00 · Unemployment 0.00 0.00 0.00 6,578.00 0.00
706.00 · Physicals 0.00 0.00 0.00 0.00 0.00
707.00 · Uniform Expense 0.00 0.00 0.00 0.00 0.00
708.00 · Drug Testing 0.00 0.00 0.00 0.00 0.00
709.00 · Personnel Expenses-Other 0.00 0.00 0.00 0.00 0.00
710.00 · Payroll Services 0.00 0.00 0.00 0.00 0.00
712.00 · Advertising 0.00 0.00 0.00 0.00 0.00
717.00 · Audit 0.00 0.00 0.00 0.00 0.00
726.00 · Contractual Expenses 0.00 0.00 1,574.90 0.00 0.00
728.00 · Information Technology 0.00 0.00 0.00 80.75 0.00
729.00 · Copier Expense 0.00 0.00 0.00 0.00 0.00
730.00 · Legal Expense 0.00 0.00 0.00 0.00 0.00
738.00 · Depreciation Expense 1,066.54 0.00 0.00 0.00 0.00
740.00 · Dues/Subscriptions/Conference 0.00 384.00 0.00 20.00 0.00
741.00 · Public Notices 0.00 0.00 0.00 0.00 26.70
746.00 · Leased Equipment 0.00 0.00 0.00 0.00 0.00
747.00 · Equipment under $5000 0.00 0.00 788.00 0.00 0.00
748.00 · Capital Equipment/Improvements 0.00 0.00 0.00 0.00 0.00
749.00 · Principal Expense 0.00 0.00 0.00 0.00 0.00
750.00 · Lead/Radon Testing 0.00 0.00 0.00 541.00 104.00
751.00 · Housing 0.00 0.00 0.00 197,295.00 39,070.40
752.00 · Admin. Expense 0.00 0.00 0.00 0.00 15,000.00
754.00 · Insurance 1,353.74 0.00 1,842.18 0.00 -394.68
756.00 · Mortgage Filing Expenses 0.00 0.00 0.00 104.00 14.00
757.00 · Interest Expense 31.99 0.00 110.87 0.00 0.00
760.00 · Housing Relocation Expense 0.00 0.00 0.00 0.00 0.00
766.00 · Bldg. Maintenance & Repairs 0.00 0.00 0.00 0.00 0.00
767.00 · Vehicle Maintenance & Repair 703.33 0.00 0.00 0.00 0.00
768.00 · Marketing 0.00 0.00 0.00 0.00 0.00
769.00 · Meeting Expense 0.00 0.00 0.00 0.00 97.34
782.00 · Printing/Postage 0.00 0.00 0.00 50.07 0.00
791.00 · Rent 0.00 0.00 0.00 0.00 0.00
806.00 · Supplies 0.00 0.00 115.41 2.34 -33.95
807.00 · Bank Charges 0.00 0.00 0.00 0.00 5.00
808.00 · Fuel/Oil 441.10 0.00 8.85 0.00 0.00
810.00 · Telecommunications 0.00 0.00 7,268.38 0.00 0.00
811.00 · Utilities Expense 0.00 0.00 0.00 0.00 0.00
812.00 · Bldg Operation Allocation 0.00 0.00 0.00 0.00 0.00
813.00 · Real Estate Taxes 0.00 0.00 0.00 0.00 0.00
815.00 · Mileage Expense 0.00 0.00 0.00 0.00 0.00
816.00 · Travel/Training 0.00 0.00 0.00 200.00 210.51
820.00 · Use Allowance 19.06 137.60 0.00 81.74 118.86
829.00 · Down Payment Assistance 0.00 0.00 0.00 0.00 15,000.00
830.00 · Participant Loans 0.00 0.00 0.00 0.00 0.00
825.00 · Bad Debt Expense 0.00 0.00 0.00 0.00 0.00
850.00 · Grant Expenditure 0.00 0.00 0.00 0.00 0.00
900.00 · INDIRECT COSTS 0.00 3,963.22 51.33 3,751.47 907.27
3,615.76 15,901.93 11,905.25 219,533.79 72,727.69
(1,506.50) (15,901.93) 6,999.33 (13,062.71) (47,704.10)
- - (49,624.80) (10,455.69) - SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Two Months Ending
August 31, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment/Improvements
749.00 · Principal Expense
750.00 · Lead/Radon Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
60 IDOT 71 EDA RLF 72 IRP-I
73.00
FM/KK/HC
RLF 76 IRP-II
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 23,175.27 4,713.39 2,260.13 2,005.38
30.00 0.00 0.00 0.00 0.00
0.00 157.79 132.17 126.66 0.00
0.00 8,472.83 3,026.65 966.41 1,594.02
30.00 31,805.89 7,872.21 3,353.20 3,599.40
25,277.86 4,950.63 1,520.18 2,606.01 1,085.86
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
1,697.29 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
138.90 0.00 0.00 0.00 0.00
12.32 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 21,507.02 0.00 13,513.59
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 18.50 29.00 0.00 3.50
0.00 0.00 97.98 0.00 228.41
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
50.00 0.00 0.00 0.00 0.00
10.00 0.00 0.00 0.00 0.00
6.95 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
189.78 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
902.62 0.00 0.00 0.00 0.00
405.07 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
8,817.46 1,726.73 530.37 914.13 373.90
37,508.25 6,695.86 23,684.55 3,520.14 15,205.26
(37,478.25) 25,110.03 (15,812.34) (166.94) (11,605.86)
(37,478.25) 1,934.76 981.29 - (97.65)
Schedule 2 Southeast Iowa Regional Planning Commission
Statement of Revenues and Expenses by Class
For the Two Months Ending
August 31, 2017
Ordinary Income/Expense
Income
4100 · Bus Fare Revenues
4500 · Federal/State Revenues
461.00 · Principal on Loans
4700-48 · Local Revenues
4900 · Miscellaneous Revenues
5000-52 · RLF Income
Expense
700.00 · Personnel Expenses
704.00 · Unemployment
706.00 · Physicals
707.00 · Uniform Expense
708.00 · Drug Testing
709.00 · Personnel Expenses-Other
710.00 · Payroll Services
712.00 · Advertising
717.00 · Audit
726.00 · Contractual Expenses
728.00 · Information Technology
729.00 · Copier Expense
730.00 · Legal Expense
738.00 · Depreciation Expense
740.00 · Dues/Subscriptions/Conference
741.00 · Public Notices
746.00 · Leased Equipment
747.00 · Equipment under $5000
748.00 · Capital Equipment/Improvements
749.00 · Principal Expense
750.00 · Lead/Radon Testing
751.00 · Housing
752.00 · Admin. Expense
754.00 · Insurance
756.00 · Mortgage Filing Expenses
757.00 · Interest Expense
760.00 · Housing Relocation Expense
766.00 · Bldg. Maintenance & Repairs
767.00 · Vehicle Maintenance & Repair
768.00 · Marketing
769.00 · Meeting Expense
782.00 · Printing/Postage
791.00 · Rent
806.00 · Supplies
807.00 · Bank Charges
808.00 · Fuel/Oil
810.00 · Telecommunications
811.00 · Utilities Expense
812.00 · Bldg Operation Allocation
813.00 · Real Estate Taxes
815.00 · Mileage Expense
816.00 · Travel/Training
820.00 · Use Allowance
829.00 · Down Payment Assistance
830.00 · Participant Loans
825.00 · Bad Debt Expense
850.00 · Grant Expenditure
900.00 · INDIRECT COSTS
SEIRPC Adjusted Balance
Excess (deficiency) of revenues over
(under) expenditures
80 Indirect
Cost Center 85 RTA 90 LOCAL TOTAL
0.00 11,322.32 0.00 11,322.32
0.00 123,840.36 0.00 317,954.36
0.00 0.00 0.00 34,455.59
0.00 88,629.00 122,684.00 239,952.26
0.00 945.73 228.84 28,325.53
0.00 0.00 0.00 14,809.40
0.00 224,737.41 122,912.84 646,819.46
36,451.22 61,332.65 12,474.38 170,692.89
0.00 486.00 0.00 7,064.00
0.00 338.00 0.00 338.00
7.50 278.37 0.00 285.87
0.00 355.00 0.00 355.00
0.00 80.00 0.00 80.00
750.32 0.00 0.00 750.32
0.00 148.50 0.00 148.50
0.00 0.00 0.00 0.00
0.00 0.00 0.00 1,574.90
2,353.99 128.25 342.00 4,602.28
556.87 0.00 0.00 556.87
0.00 0.00 0.00 0.00
584.46 0.00 0.00 1,651.00
4,902.68 2,364.00 80.00 7,889.58
115.44 0.00 172.42 326.88
0.00 0.00 0.00 0.00
0.00 0.00 0.00 788.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 35,020.61
0.00 0.00 0.00 645.00
0.00 0.00 0.00 236,365.40
0.00 0.00 0.00 15,000.00
7,857.46 7,429.44 0.00 18,088.14
0.00 0.00 289.00 458.00
0.00 0.00 0.00 469.25
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 22,441.32 0.00 23,144.65
0.00 1,325.00 0.00 1,375.00
255.65 61.19 0.00 424.18
503.50 0.00 0.00 560.52
0.00 1,100.00 0.00 1,100.00
978.55 486.84 13.04 1,752.01
0.00 0.00 0.00 5.00
80.36 14,941.59 0.00 15,471.90
2,146.98 2,041.10 0.00 11,456.46
0.00 66.27 0.00 66.27
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 943.00 0.00 943.00
-194.29 817.02 735.90 2,671.76
473.53 364.36 509.04 2,109.26
0.00 0.00 0.00 15,000.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 3,082.50 3,082.50
(46,789.21) 21,408.37 4,344.96 0.00
11,035.01 138,936.27 22,043.24 582,313.00
(11,035.01) 85,801.14 100,869.60 64,506.46
- 85,801.14 100,869.60 91,930.40
Schedule 3
Type Date Num Name Amount
Bill Pmt -Check 08/02/2017 270185 Henry County Recorders Office 7.00
Bill Pmt -Check 08/02/2017 270186 Midwest Old Threshers 6,000.00
Bill Pmt -Check 08/02/2017 270187 Shafer Construction LLC. 23,528.00
Bill Pmt -Check 08/02/2017 270188 Access Systems 415.30
Bill Pmt -Check 08/02/2017 270189 American Planning Association 354.00
Bill Pmt -Check 08/02/2017 270190 Brad Holtkamp Automotive, Inc. 2,321.15
Bill Pmt -Check 08/02/2017 270191 Clear Falls Bottled Water 60.25
Bill Pmt -Check 08/02/2017 270192 Crescent Electric Supply Co 0.00
Bill Pmt -Check 08/02/2017 270193 Dave's Lock & Key 36.00
Bill Pmt -Check 08/02/2017 270194 Dave Ewinger 12.25
Bill Pmt -Check 08/02/2017 270195 Des Moines County Recorder's Office 21.00
Bill Pmt -Check 08/02/2017 270196 Dex Media East Inc 50.00
Bill Pmt -Check 08/02/2017 270197 Embellishments & Designs Inc 7.50
Bill Pmt -Check 08/02/2017 270198 Federal Home Loan Bank of Des Moines 1,170.00
Bill Pmt -Check 08/02/2017 270199 Fedex 230.22
Bill Pmt -Check 08/02/2017 270200 Gary McPherson 24.50
Bill Pmt -Check 08/02/2017 270201 i connect you. 991.36
Bill Pmt -Check 08/02/2017 270202 IARC. 4,500.00
Bill Pmt -Check 08/02/2017 270203 Iowa Illinois Office Solutions 333.80
Bill Pmt -Check 08/02/2017 270204 Iowa Workforce Development - Tax Bureau 7,064.00
Bill Pmt -Check 08/02/2017 270205 IPTA 2,364.00
Bill Pmt -Check 08/02/2017 270206 Jack Callas 73.50
Bill Pmt -Check 08/02/2017 270207 Jim Sholl 49.00
Bill Pmt -Check 08/02/2017 270208 Ken Marang 74.20
Bill Pmt -Check 08/02/2017 270209 Lee County Recorder/Registrar 14.00
Bill Pmt -Check 08/02/2017 270210 Louisa County Recorder's Office 0.00
Bill Pmt -Check 08/02/2017 270211 O'Keefe Elevator Company 149.00
Bill Pmt -Check 08/02/2017 270212 Petty Cash 213.17
Bill Pmt -Check 08/02/2017 270213 Precison Repair 44.40
Bill Pmt -Check 08/02/2017 270214 Quincy Medical Group 150.00
Bill Pmt -Check 08/02/2017 270215 Shafer Construction LLC. 5,882.00
Bill Pmt -Check 08/02/2017 270216 Shottenkirk-Fort Madison 82.51
Bill Pmt -Check 08/02/2017 270217 Shottenkirk Superstore 2,395.45
Bill Pmt -Check 08/02/2017 270218 Sue Ballew 73.50
Bill Pmt -Check 08/02/2017 270219 Terry Heckenberg 12.25
Bill Pmt -Check 08/02/2017 270220 Verizon Wireless 1,020.55
Bill Pmt -Check 08/02/2017 270221 Wemiga Waste Inc 30.00
Bill Pmt -Check 08/16/2017 270222 Access Systems 141.57
Bill Pmt -Check 08/16/2017 270223 Burlington True Value 8.59
Bill Pmt -Check 08/16/2017 270224 C-CAT, Inc. 100.00
Bill Pmt -Check 08/16/2017 270225 Card Center 2,307.42
Bill Pmt -Check 08/16/2017 270226 City of Keokuk. 2,023.95
Bill Pmt -Check 08/16/2017 270227 City of Mount Pleasant 2,107.99
Bill Pmt -Check 08/16/2017 270228 City of West Burlington. 157.15
Bill Pmt -Check 08/16/2017 270229 Dan Eberhardt 100.00
Bill Pmt -Check 08/16/2017 270230 Deery Brothers Ford Lincoln Inc 5,127.95
Bill Pmt -Check 08/16/2017 270231 Drake Hardware & Software 2,333.25
Bill Pmt -Check 08/16/2017 270232 Embellishments & Designs Inc 7.50
Bill Pmt -Check 08/16/2017 270233 Farmers Elevator & Exchange, Inc. 871.73
Bill Pmt -Check 08/16/2017 270234 Fort Madison Partners 3,082.50
Bill Pmt -Check 08/16/2017 270235 Gerald Huebner 129.55
Bill Pmt -Check 08/16/2017 270236 hibu Inc. - West 34.00
Bill Pmt -Check 08/16/2017 270237 ICAP 206.05
Bill Pmt -Check 08/16/2017 270238 Integrated Technology Partners 19.95
Bill Pmt -Check 08/16/2017 270239 Iowa Illinois Office Solutions 123.90
Bill Pmt -Check 08/16/2017 270240 Kempker's True Value 12.68
Bill Pmt -Check 08/16/2017 270241 Lee County Recorder/Registrar 7.00
Bill Pmt -Check 08/16/2017 270242 Louisa County Recorder's Office 33.00
Bill Pmt -Check 08/16/2017 270243 Marilyn Hunter 85.41
Bill Pmt -Check 08/16/2017 270244 Mt. Pleasant Tire & Service 1,259.82
Bill Pmt -Check 08/16/2017 270245 O'Reilly Automotive, Inc. 911.20
Bill Pmt -Check 08/16/2017 270246 Pep Stop 6.00
Bill Pmt -Check 08/16/2017 270247 Swailes Auto Supply Inc. 543.47
Bill Pmt -Check 08/16/2017 270248 The Burlington Hawk Eye 50.83
Bill Pmt -Check 08/16/2017 270249 The Democrat Company 163.00
Southeast Iowa Regional Planning Commission
Check Register
August 31, 2017
Schedule 3
Type Date Num Name Amount
Southeast Iowa Regional Planning Commission
Check Register
August 31, 2017
Bill Pmt -Check 08/16/2017 270250 The Ivy 47.50
Bill Pmt -Check 08/16/2017 270251 Thomas Bus Sales 605.00
Bill Pmt -Check 08/16/2017 270252 Titan Broadcasting LLC. 300.00
Bill Pmt -Check 08/16/2017 270253 Waterworks Car Wash 10.00
Bill Pmt -Check 08/16/2017 270254 WB Collision Center Inc 1,501.03
Bill Pmt -Check 08/16/2017 270255 Wex Bank 371.30
Bill Pmt -Check 08/16/2017 270256 Wolf Decals 585.00
Bill Pmt -Check 08/16/2017 270257 Louisa County Recorder's Office 228.00
Bill Pmt -Check 08/16/2017 270258 Winners Circle 104.75
Bill Pmt -Check 08/16/2017 270259 Henry County Recorders Office 0.00
Bill Pmt -Check 08/31/2017 270260 City of Burlington, Iowa 1,866.50
Bill Pmt -Check 08/31/2017 270261 Clear Falls Bottled Water 47.75
Bill Pmt -Check 08/31/2017 270262 Des Moines County Treasurer 5,427.00
Bill Pmt -Check 08/31/2017 270263 Drake Hardware & Software 871.99
Bill Pmt -Check 08/31/2017 270264 Great River Business Health 94.00
Bill Pmt -Check 08/31/2017 270265 Hope Haven Area Dev Center 340.00
Bill Pmt -Check 08/31/2017 270266 Huffman Welding and Machine Inc 41.84
Bill Pmt -Check 08/31/2017 270267 Hy-Vee, Inc 99.90
Bill Pmt -Check 08/31/2017 270268 Iowa League of Cities 375.00
Bill Pmt -Check 08/31/2017 270269 Jack Callas 159.25
Bill Pmt -Check 08/31/2017 270270 Jarred Lassiter 15.84
Bill Pmt -Check 08/31/2017 270271 Jim Sholl 61.25
Bill Pmt -Check 08/31/2017 270272 JLG Properties 2,750.00
Bill Pmt -Check 08/31/2017 270273 Ken Marang 24.50
Bill Pmt -Check 08/31/2017 270274 Keokuk Area Chamber of Commerce. 450.00
Bill Pmt -Check 08/31/2017 270275 Lowell Gaulke 1,137.00
Bill Pmt -Check 08/31/2017 270276 Mediacom 89.90
Bill Pmt -Check 08/31/2017 270277 Mt. Pleasant Glass 154.00
Bill Pmt -Check 08/31/2017 270278 O'Keefe Elevator Company 149.00
Bill Pmt -Check 08/31/2017 270279 Pauwels Lawn Care 470.00
Bill Pmt -Check 08/31/2017 270280 Pitney Bowes - Purchase Power 503.50
Bill Pmt -Check 08/31/2017 270281 Precison Repair 29.60
Bill Pmt -Check 08/31/2017 270282 Shottenkirk-Fort Madison 216.08
Bill Pmt -Check 08/31/2017 270283 Shottenkirk Superstore 308.68
Bill Pmt -Check 08/31/2017 270284 Sue Ballew 73.50
Bill Pmt -Check 08/31/2017 270285 The Ivy 64.00
Bill Pmt -Check 08/31/2017 270286 Tracey Lamm 151.59
Bill Pmt -Check 08/31/2017 270287 Turbo Wash Inc 50.00
Bill Pmt -Check 08/31/2017 270288 UnityPoint Clinic 120.00
Bill Pmt -Check 08/31/2017 270289 Verizon Wireless 1,020.55
Bill Pmt -Check 08/31/2017 270290 Zachary James 173.28
102,797.40
Electronic Payment 08/01/2017 MetLife (dental ins.) 1,105.63
Electronic Payment 08/01/2017 Principal Financial (life ins.) 975.57
Electronic Payment 08/01/2017 Welmark 12,361.11
Electronic Payment 08/01/2017 IPERS 11,928.89
Electronic Payment 08/15/2017 Alliant Energy 3,964.17
Electronic Payment 08/21/2017 Two Rivers Bank - vehicle loan payment 520.94
Electronic Payment 07/03/2017 Two Rivers Bank - quarterly facility payment 0.00
Electronic Payment 07/28/2017 Two Rivers Bank - principal only facility payment 0.00
Electronic Payment 08/31/2017 Payroll 64,189.29
Electronic Payment 08/31/2017 Payroll Taxes 24,033.78
Electronic Payment 08/31/2017 Payroll Processing Fees 376.78
Electronic Payment 08/31/2017 Advantage fees 114.75
119,570.91
TOTAL EXPENDITURES 222,368.31
Schedule 4
BANCARD Services Credit Card Statement
STATEMENT DATE: 8/28/2017
PAYMENT DUE DATE: 9/22/2017
CHECK# 270292
DATE PAID 9/13/2017
Date Transaction Description Account# Type Class# Class Name Amount Receipt
MIKE NORRIS
31-Jul-17 Hardrock Main & Abbey Sioux City 816 Travel/Training 80 RPC 13.20 Yes
01-Aug-17 McDonald's Shelby IA 816 Travel/Training 80 RPC 3.17 Yes
01-Aug-17 Stoney Creek Inn Sioux City 816 Travel/Training 80 RPC 120.91 Yes
08-Aug-17 IA Secretary of State 740 Dues/Subscriptions 47.00 Housing 20.00 Yes
11-Aug-17 Parking Ramps Des Moines 816 Travel/Training 80 RPC 6.00 Yes
12-Aug-17 ConstantContact.Com 740 Dues/Subscriptions 20 EDA 45.00 Yes
TOTAL 208.28
DEBORAH LAUGHLIN
22-Aug-17 Hy-Vee Aisles Online 806 Supplies 80 RPC 84.83 Yes
TOTAL 84.83
ZACH JAMES
31-Jul-17 Facebook 768 Marketing 60 IDOT 24.98 Yes
04-Aug-17 ESRI Redlands CA 728 Information Technology 60 IDOT 1,469.04 Yes
09-Aug-17 La Tavola Italian Eatery 816 Travel/Training 60 IDOT 28.00 Yes
10-Aug-17 Wix.Com 740 Dues/Subscriptions 60 IDOT 27.90 Yes
11-Aug-17 Amtrak.Com 816 Travel/Training 60 IDOT 42.00 Yes
TOTAL 1,591.92
JEFF HANAN
04-Aug-17 Hilton Garden Inn Sioux City 816 Travel/Training 90 LOCAL 389.76 Yes
04-Aug-17 Lowes 806 Supplies 48.02 GRHTF 16.05 Yes
10-Aug-17 Happy Joe's Pizza 769 Meeting Expense 48.02 GRHTF 97.34 Yes
14-Aug-17 Air Chek, Inc 750 Lead/Radon Testing 47.082 HOME 42.00 Yes
14-Aug-17 Air Chek, Inc 750 Lead/Radon Testing 47.032 NLOO 42.00 Yes
14-Aug-17 Java River Coffee House Keokuk 816 Travel/Training 90 LOCAL 49.22 Yes
18-Aug-17 APA Membership Online 740 Dues/Subscriptions 20 EDA 294.00 Yes
TOTAL 930.37
LORI GILPIN
TOTAL 0.00
ROGER KELLER
31-Jul-17 National Security Council 816 Travel/Training 85 RTA 19.95 Yes
12-Aug-16 Hampton Inn and Suites 816 Travel/Training 85 RTA 333.76 Yes
17-Aug-16 Hampton Inn and Suites 816 Travel/Training 85 RTA 333.76 Yes
17-Aug-16 Casey's 769 Meeting Expense 85 RTA 44.79 Yes
TOTAL 732.26
BOB KUSKOWSKI
TOTAL 0.00
TOTAL 3,547.66
ClassExpense
Hans Trousil Mike Norris
Schedule 5
Current 1 - 45 46 - 90 > 90 TOTAL
Local:
City of Columbus City - - 547.00 539.00 1,086.00
City of Franklin - - 359.00 - 359.00
City of Fredonia - - 435.00 - 435.00
City of Keokuk - - 3,759.00 - 3,759.00
City of Letts - - 542.00 - 542.00
City of Middletown - - 492.00 - 492.00
City of Morning Sun - - 885.00 - 885.00
City of Salem - - 541.00 - 541.00
City of St. Paul - - 348.00 - 348.00
City of Westwood - - 335.00 - 335.00
IARC - - - 500.00 500.00
JK Homes - - - 550.00 550.00
- - 8,243.00 1,589.00 9,832.00
Housing:
City of Burlington - - 6,900.00 - 6,900.00
City of Fort Madison - 164,715.00 - - 164,715.00
City of Wayland - 1,500.00 - - 1,500.00
ECIA - - - 25,449.00 25,449.00
IFA - - 32,500.00 1,918.00 34,418.00
- 166,215.00 39,400.00 27,367.00 232,982.00
RTA:
A2C 931.60 100.00 100.00 - 1,131.60
AHC AmeriHealth Caritas 39,530.50 - - 391.00 39,921.50
Billie Driggers - 25.00 - - 25.00
Blair House 112.50 - - - 112.50
Carrie Moore - 25.00 25.00 25.00 75.00
Christina Mazza - 25.00 25.00 25.00 75.00
Hope Haven 1,016.26 - - - 1,016.26
Iowa Medicaid Enterprise 243.87 184.75 118.24 - 546.86
James Mitchell - 25.00 - - 25.00
John Buttgen - 25.00 - - 25.00
Logisticare 444.08 - - - 444.08
Milestones Area Agency on Aging 1,987.50 - - - 1,987.50
Nathan Morris 25.00 - - - 25.00
New London Comm. Child Care - 330.00 - - 330.00
New London Specialty Care 325.00 - - - 325.00
Rebecca Shibley - - - 140.75 140.75
Ruth Boyd. - - - 1,535.89 1,535.89
Stacey Kitman - - - 5.00 5.00
Steve Anderson (100.00) - - - (100.00)
Tammy Wheeler - 25.00 - - 25.00
Travis Spitznogle - 25.00 - - 25.00
Tyrone Seay - 25.00 - - 25.00
44,516.31 814.75 268.24 2,122.64 47,721.94
Total 44,516.31 167,029.75 47,911.24 31,078.64 290,535.94
Southeast Iowa Regional Planning Commission
Accounts Receivable Aging Summary
August 31, 2017
Schedule 6
Current 1 - 45 46 - 90 > 90 TOTAL
Alliant Energy 22.65 43.62 24.58 (109.73) (18.88)
Barker Financial LLC 164,715.00 - - - 164,715.00
Card Center 3,547.66 - - - 3,547.66
City of Burlington, Iowa 2,249.91 - - - 2,249.91
City of Keokuk. 2,628.57 - - - 2,628.57
City of Mount Pleasant 2,152.10 - - - 2,152.10
Daily Gate City 36.48 - - - 36.48
Deery Brothers Ford Lincoln Inc 820.51 - - - 820.51
Des Moines County Treasurer (5,427.00) - - - (5,427.00)
Dex Media East Inc 50.00 - - - 50.00
Ebert Supply Company 115.41 - - - 115.41
Farmers Elevator & Exchange, Inc. 685.82 - - - 685.82
Great River Business Health 94.00 - - - 94.00
Huffmans Farm & Home 32.97 - - - 32.97
JLG Properties (550.00) - - - (550.00)
Lowell Gaulke 712.00 - - - 712.00
Mediapolis News 101.61 22.52 - - 124.13
Mt. Pleasant Tire & Service 1,983.88 - - - 1,983.88
Napa Auto Parts - - - (0.98) (0.98)
O'Keefe Elevator Company (149.00) - - - (149.00)
O'Reilly Automotive, Inc. 472.16 - - - 472.16
Pauwels Lawn Care 275.00 - - - 275.00
Pep Stop 33.00 - - - 33.00
Swailes Auto Supply Inc. 108.80 - - - 108.80
The Burlington Hawk Eye 115.44 - - - 115.44
Thomas Bus Sales 343.61 - - - 343.61
Titan Broadcasting LLC. 575.00 - - - 575.00
Todd Schneider dba Schoolhouse Apts - - - 15,000.00 15,000.00
Traffic Logix Corporation 84.95 - - - 84.95
UnityPoint Clinic 235.00 - - - 235.00
Valley Safety Services Associates, Inc. 41.00 - - - 41.00
Waterworks Car Wash 15.00 - - - 15.00
Wemiga Waste Inc 30.00 - - - 30.00
Wex Bank 320.43 - - - 320.43
Winners Circle - - 53.75 - 53.75
176,471.96 66.14 78.33 14,889.29 191,505.72
Accounts Payable Aging Summary
Southeast Iowa Regional Planning Commission
August 31, 2017
Schedule 7
August 2017
TOTAL REVENUES : -
TOTAL EXPENSES : 8
Excess of revenues over expenditures- note this is cash basis (8)
CASH BALANCE
Connection Bank 3,263
ACCOUNTS RECEIVABLE BALANCE
1-45 46-90 >90 TOTAL
City of Fort Madison - 4,500 - 4,500
City of Keokuk - 1,000 - 1,000
Lee County - 1,000 - 1,000
ACCOUNTS PAYABLE BALANCE
1-45 46-90 >90 TOTAL
none 0 0 0 0
CASH RECEIPTS - life to date
Alliant Energy 12/2/2013 FY14 5,000
State of Iowa 7/24/2014 FY15 2,500
Lee County Auditor 4/25/2016 FY16 1,000
City of Keokuk 8/29/2016 FY16 1,000
CASH DISBURSEMENTS - life to date
SEIRPC 7/25/2014 #1001 5,000
University of Iowa 7/25/2014 #1002 2,500
Delux 8/6/2014 electronic 131
SEIRPC 6/30/2015 #1003 2,694
service fee 10/31/2016 electronic 4
service fee 11/30/2016 electronic 4
service fee 12/31/2016 electronic 4
service fee 1/31/2017 electronic 4
service fee 2/28/2017 electronic 4
service fee 3/31/2017 electronic 4
SEIRPC 4/12/2017 #1004 5,080
service fee 4/30/2017 electronic 4
service fee 5/31/2017 electronic 4
service fee 6/30/2017 electronic 4
service fee 7/31/2017 electronic 4
service fee 8/31/2017 electronic 4
PROFIT & LOSS ALL CLASSES
Southeast Iowa Regional Economic and Port Authority
Financial Summary
August 31, 2017
OB #1 C
onsent Agenda
Departm
ent Reports
1
Memo To: Mike Norris, Executive Director
From: Jeff Hanan, Assistant Director
Date: September 2017
Re: Departmental Updates
Following are updates from the Development Department:
RLF:
• Continue to work on potential project in Mount Pleasant.
• Finishing up servicing with USDA
HOUSING:
• South 9th project completed in Burlington and we have the house listed for sale. Asking price is $79,000. Next SIHI project in Keokuk.
• Continuing to market owner-occupied rehabilitation program in New London. Need 6 homeowners.
• Four units of upper-story renovation on line in Mount Pleasant. The developer received money through the GRHTF.
• Currently securing local match for next round of funding from IFA for GRHTF. Applying for $312,000 and need local match of $78,000.
• Submitted four Pilot Projects to IEDA for potential upper-story development – one in Keokuk, one in Fort Madison, one in Burlington and one in Mount Pleasant.
MISC
• SEIRPC staff will continue to provide community outreach during the month of October. Susan Coffey and Tracey Lamm will present information to interested communities regarding funding opportunities for projects. The second in a series of community outreach activities will be held on Tuesday, Oct. 2, 2017, at 10 a.m. at the Columbus Junction Civic Center, 232 2nd Street, Columbus Junction. This informative presentation will highlight the CDBG program and how it works in conjunction with other state and federal funding sources to make projects feasible and affordable.
Memo To: Mike Norris, Executive Director
From: Zach James, Planning Director
Date: September 25, 2017
Re: Planning Department Projects Update
Below are updates on projects in the Planning Department. Transportation Alternative Funding
At our most recent Iowa DOT quarterly meeting on September 19, Iowa DOT informed us that they have developed a process to satisfy the Federal Highway Administration. Not all the details have been finalized, but we will likely be sending out a notice that we will be accepting applications sometime in October. More information will be provided as we learn more from Iowa DOT.
Iowa Department of Public Health – Complete Streets Education Iowa Department of Public Health staff reached out to see if SEIRPC would be interested in assisting them with Complete Streets Education efforts. Over the past 3 years, IDPH has worked with the Des Moines MPO, Davenport MPO, and Cedar Rapids MPO on complete streets education. They would like to start working with some of the smaller communities in Iowa and thought SEIRPC would be a good fit. Education efforts will likely start early 2018.
Grant Applications in Process/Submitted Entity Project Grant Program Request Amount Fort Madison Connecting Fort Madison Phase 3 Federal Recreational Trails $444,192 Louisa County Hoover Nature Trail Federal Recreational Trails $234,000 Burlington North Gorge Trail Resource Enhancement and Protection $148,625 Fort Madison 20th and 24th Street Signals TSIP $81,518 Keokuk 2nd Street Signals TSIP $192,400 Keokuk 13th and 14th Street Signals TSIP $484,900 Keokuk 7th Street Intersection Improvements TSIP $370,560 Keokuk Mississippi River Rail Bridge TIGER Program TBD
Funded Grants
Entity Project Grant Program Amount Awarded Middletown School Asbestos Removal Derelict Building Grant Program $34,995 Louisa County Hoover Nature Trail Statewide Recreational Trails $250,000 SEIRPC Complete Streets Education Iowa Department of Public Health $10,000 Partners for Conservation Putting Obesity in Park Wellmark SMALL Match Grant $25,000 Mount Pleasant 5-2-1-0 Components Iowa Department of Public Health $18,000
Upcoming Grant Opportunities Grant Program Entity Due Date Federal Recreational Trails Program Iowa Department of Transportation October 1st, 2017 TIGER Program US Department of Transportation October 16th, 2017 Community Catalyst Building Remediation Program Iowa Economic Development TBD
Memo To: SEIRPC Board of Directors
From: Roger Keller, Transit Director
Date: 9/21/2017
Re: SEIBUS Updates
• SEIBUS provided shuttle service at the 2017 Mt. Pleasant Old Threshers Reunion with a 104% increase of 7,016 rides on buses driven by SEIBUS vs. 3,441 in 2016. We are expecting overall 2017 Old Threshers riders to be greater than the 2016 rides of 26,483 once all numbers have been finalized. Plans are to continue this service in 2018.
• SEIBUS also provided shuttle service at the 2017 Tri- State Rodeo in Fort Madison with
a 76% increase for shuttle rides of 1,330 rides vs. 753 in 2016. Plans are also to continue this service in 2018.
• Beginning September 7th, SEIBUS expanded its Henry County services to included
providing Wayland Iowa residents transportation to shop and run errands in Mt Pleasant on an every other Thursday basis.
• Two additional Substitute Drivers have completed their initial training and are now
functioning as backup drivers for our current Full & Part Time drivers. SEIBUS is continuing to identify additional good qualified substitute drivers to add to our driver workforce.
• A 3rd 2017 SEIBUS Drivers Training & Informational Meeting will be held October 10th to
train & recertify all drivers on proper methods to secure for transport clients who utilize wheelchairs.
Year End / 2017 Stats: FY/2015 FY/2016 FY/2017
Total Rides 142,912
138,275
144,966
General Public
18,680
18,250
17,072 C.P.C. / Medicaid
49,235
46,188
41,723 Contracted / Other
74,997
73,837
86,171
OB #2 C
onsent Agenda
Housing, Inc. U
pdate
1
Memo To: SEIRPC Board of Directors
From: Mike Norris, Executive Director
Date: September 22, 2017
Re: Housing, Inc. Update
SEIRPC incorporated a non-profit entity with the express purpose of developing housing in 2012. Since that time, various development milestones have been met to bring the corporation into productivity and usefulness. In the past 12 months, Housing, Inc. has completed or initiated the following projects:
• Mount Pleasant, new home built and sold (2016) • Burlington, home acquired, rehabbed, for sale (2017) • Keokuk, lot acquired, bids released for new home (2017) • Donnellson, meetings with Central Lee Schools and Donnellson to build
homes (2017) • Morning Sun, early discussions to build on city-owned lots (2017)
The role of a non-profit developer is finding traction in southeast Iowa. Very common themes in each of our cities and counties are: Lack of housing options for range of incomes; Lack of quality housing; Lack of new housing. Schools and cities are also intersecting at the housing issue. Schools need new families to support the district and are rebuilding their trade programs. Cities need to sustain their populations and address nuisance properties and vacant lots. Please be on the lookout in your areas for new partnerships. SEIRPC and Housing, Inc. is only one part of the equation; schools, cities and counties each have roles to play in changing our housing inventory. Prototypical Housing, Inc./School/City Development Model:
• Housing, Inc. serves as developer and general contractor; • Cities secure lots/homes for redevelopment; • Schools provide parts of the bid scope as learning opportunities for
students
OB #4
CE
DS
Plan U
pdate
Memo To: SEIRPC Board of Directors From: Mike Norris, Executive Director Date: April 27, 2017 Re: CEDS Update
What is the CEDS?
The Great River Region CEDS is the long-range plan for Des Moines, Henry, Lee, and Louisa Counties developed by the Southeast Iowa Regional Planning Commission. It is a regional effort to identify strengths, weaknesses and priorities to move the region forward on shared strategies regarding economic development, community development, and transportation. The CEDS is important for several reasons including:
1. Maintains Economic Development District Status for Southeast Iowa; 2. Serves as the Long-Range Transportation Plan; 3. Provides regional weight to ideas, strategies and projects for funding
opportunities; 4. Creates opportunities for cross-pollenating ideas among groups and people
who do not typically work together. 5. Creates opportunities for discussion of big ideas, which may not happen in
a funding or otherwise constrained atmosphere.
CEDS Steering Committee Meetings • April 18, 2017 – Kickoff meeting for CEDS update process. SEIRPC staff
presented the ins and outs of the CEDS, including a timeline for the project. Most importantly, the question of ‘How do we use the CEDS?’ was described, explored and questioned.
• August 28, 2017 – This was the second steering committee meeting. The focus of the meeting was to review public input (survey and interview feedback), provide a overview of southeast Iowa population, demographic, and transportation trends, and discuss next steps in the CEDS process.
Regional Input
As part of the CEDS process, SEIRPC worked to gather input from stakeholders throughout the region via a region wide survey and one on one interviews. Staff received 300 survey responses and interviewed approximately 16 people/groups (4 in each county) focusing on the healthcare industry, education, private industry, and local governments. The focus of both the survey and interviews was to learn about regional strengths, weaknesses, and priorities in Southeast Iowa related to transportation, community development, and economic development.
Next Steps
• October 2017 - Develop regional priorities, goals and objectives based on data and input received
• October – November 2017 - Hold subcommittee meetings on the three topics of transportation, economic development, and community development to review priorities, goals, and objectives
• October 2017 to January 2018 - Begin development of a draft CEDS document
NB #1
Building R
emediation G
rant U
pdate
1
Memo To: SEIRPC Board of Directors
From: Mike Norris, Executive Director
Date: September 22, 2017
Re: Community Catalyst Building Remediation Program
In 2017, the Iowa Legislature adopted legislation creating a “Community Catalyst Building Remediation Program” to be operated by the Iowa Economic Development Authority. The essence of the program is to provide grants to cities to help remediate underutilized buildings that will serve as catalysts for new development in the city. Funds will be available this year, and rules are presently under consideration by the IEDA board. Highlights of the program are below:
• Total funding: $1 million • Each city restricted to $100,000 per fiscal year • $400,000 (or 40%) allocated to cities 1,500 population or less • Some match is required (cash or in-kind) • The project must implement a community plan or goals in the plan • Underutilized means vacant or mostly vacant, a nuisance, or heavily
blighted • Emergency grants can be applied for at any time of the year; emergency
means building condition requiring immediate attention due to unexpected structural failure or acts of God.
• IEDA will publicize grant application periods. • Pre-application is required; Up to $5,000 technical assistance is
available from IEDA to assist in project development. As you know, SEIRPC writes grants for free (up to some practical limit) for dues-paying members. Please let us know if you are interested in a project.