HomeMy WebLinkAbout2015 - Tri-County Regional Planning Commission - Audit Report FY2015 TRI-COUNTY REGIONAL PLAN vI�' ' hhAolI .ION
Planning for Peopte in the
2015 OFFICERS December 18, 2015 -
CHAIRPERSON -
David Pohl,Clinton County
VICE-CHAIRPERSON Mr. Chris Swope
Kenneth Fletcher,Eaton County City Clerk, City of Lansing
City Hall
TREASURER 124 W. Michigan
Shirley M.Rodgers,City of Lansing Lansing, MI 48W
SECRETARY
Brian McGrain,Ingham County
TRI-COUNTY COMMISSIONERS Dear Mr. Swope:
Kent Austin
Teri Banas In accordance with our Bylaws, we are submitting the audit report
Judi Brown Clarke Sharma Draheim for the fiscal year 2015 for the Tri-County Regional Planning
Roger Eakin Commission.
Kenneth Fletcher
Kara Hope If you have any questions, please feel free to contact us.
Denise Jackson
Robin Lewis Sincerely, -
Brian McGrain
David Pohl
Shirley M. Rodgers
Howard Spence
Adam Stacey 're offma
Chris Swope Finance Dire or
Darrell Tennis
John Veenstra
Gail Watkins
Jessica Yorko
EX-OFFICIO Encl.
City of Lansing Mayor -
Clinton,Eaton and Ingham County -
Chairpersons AUDIT LTR 2015
EXECUTIVE DIRECTOR
Susan M.C.Pigg,CEcD
313fn, ee Road,Suite 2C
Lansing,MI 48911 -
(517)393-0342•Fax:393-4424
www.mitcrpc.orQ
rece ption P m itc rpc.org
TCRPC is on Equal Opportunity Employer
i
Tri-County Regional Planning Commission
Lansing, Michigan
FINANCIAL STATEMENTS
September 30, 2015
, i
i
''
',
I�
�,
�_ ''
I
II
I'I
E
Tri-County Regional Planning Commission
TABLE OF CONTENTS
September 30, 2015
Page
INDEPENDENT AUDITOR'S REPORT i-ii
MANAGEMENT'S DISCUSSION AND ANALYSIS iii-vi
BASIC FINANCIAL STATEMENTS
Government-wide Financial Statements
Statement of Net Position 1
Statement of Activities 2
Governmental Fund Financial Statements
Balance Sheet 3
Reconciliation of the Governmental Fund Balance Sheet to the Statement of Net Position 4
Statement of Revenues, Expenditures, and Changes in Fund Balance 5
Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund
Balance of the Governmental Fund to the Statement of Activities 6
Notes to Financial Statements 7-14
REQUIRED SUPPLEMENTARY INFORMATION
General Fund
Budgetary Comparison Schedule 15-16
OTHER SUPPLEMENTARY INFORMATION
Schedule of Commission Revenues and Expenditures (Unaudited) 17
Combining Schedule of Project Revenues and Expenditures (Unaudited) 18-21
Schedule of Project Revenues and Expenditures (Unaudited) 22-41
Analysis of Completed Projects (Unaudited) 42-45
Analysis of Local Match (Unaudited) 46
Analysis of Indirect Cost Rate (Unaudited) 47
Schedule of Fringe Benefits (Unaudited) 48
Transportation Summary of Expenditures (Unaudited) 49-53
i
f , �,
i ��
� I�I
� �'��
� �',
� '
� I''
� '
� �'
Q �',
[ ,
� '
� '��
� I�I
Principals ���� 3511 Coolidge Road
Suite 100
Dale J.Abraham,CPA
East Lansing, MI 48823
Michael T.Gaffney, CPA -= --= (517( 351-6836
Steven R. Kirinovic, CPA ABRAHAM &GAFFNEY, P.C. FAX: (517( 351-6837
Aaron M.Stevens, CPA Certified Public Accountants
Eric J. Glashouwer, CPA
Alan D. Panter,CPA
William I. Tucker IV. CPA
INDEPENDENT AUDITOR'S REPORT
To the Board of Commissioners
Tri-County Regional Planning Commission
Lansing, Michigan
Report on the Financial Statements
_ We have audited the accompanying financial statements of the governmental activities and the major fund of Tri-
County Regional Planning Commission (the Commission) as of and for the year ended September 30, 2015, and
the related notes to the financial statements, which collectively comprise the Commission's basic financial
statements as listed in the table of contents.
Managements Responsibility for the Financial Statements
Management is responsible for the preparation and fair presentation of these financial statements in accordance
with accounting principles generally accepted in the United States of America; this includes the design,
implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial
statements that are free from material misstatement,whether due to fraud or error.
Auditor's Responsibility
Our responsibility is to express opinions on these financial statements based on our audit. We conducted our
audit in accordance with auditing standards generally accepted in the United States of America and the standards
applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of
the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance
about whether the financial statements are free from material misstatement.
An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the
financial statements. The procedures selected depend on the auditor's judgment, including the assessment of
the risks of material misstatement of the financial statements,whether due to fraud or error. In making those risk
assessments,the auditor considers internal control relevant to the entity's preparation and fair presentation of the
financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the
purpose of expressing an opinion on the effectiveness of the entity's internal control. Accordingly, we express no
such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the
reasonableness of significant accounting estimates made by management, as well as evaluating the overall
_ presentation of the financial statements.
We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit
opinions.
Auburn Hills• East Lansing• Grand Rapids -St.Johns
I
i
� .
i
III
� I�I
� ''
� '
� L
� :
�.
Opinions
In our opinion, the financial statements referred to above present fairly, in all material respects, the respective
financial position of the governmental activities and the major fund of the Commission as of September 30, 2015,
and the respective changes in financial position for the year then ended in accordance with accounting principles
generally accepted in the United States of America.
Other Matters
Required Supplementary Information
Accounting principles generally accepted in the United States of America require that the management's
discussion and analysis and budgetary comparison information,as identified in the table of contents, be presented
to supplement the basic financial statements. Such information, although not a part of the basic financial
statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential
part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or
historical context. We have applied certain limited procedures to the required supplementary information in
accordance with auditing standards generally accepted in the United States of America, which consisted of
inquiries of management about the methods of preparing the information and comparing the information for
consistency with management's responses to our inquiries, the basic financial statements, and other knowledge
we obtained during our audit of the basic financial statements. We do not express an opinion or provide any
assurance on the information because the limited procedures do not provide us with sufficient evidence to express
an opinion or provide any assurance.
Other Information
Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise
the Commission's basic financial statements. The accompanying other supplementary information, as identified in
the table of contents, is presented for purposes of additional analysis and is not a required part of the financial
statements. The accompanying other supplementary information has not been subjected to the auditing procedures
applied in the audit of the basic financial statements, and accordingly, we do not express an opinion or provide any
assurance on them.
Other Reporting Required by Government Auditing Standards
In accordance with Government Auditing Standards, we have also issued our report dated November 30, 2015,
on our consideration of the Commission's internal control over financial reporting and on ourtests of its compliance
with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of
that report is to describe the scope of our testing of internal control over financial reporting and compliance and
the results of that testing, and not to provide an opinion on internal control over financial reporting or on
compliance. That report is an integral part of an audit performed in accordance with Government Auditing
Standards in considering the Commission's internal control over financial reporting and compliance.
ABRAHAM & GAFFNEY, P.C.
Certified Public Accountants
November 30, 2015
- ii -
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2015
This is part of the Tri-County Regional Planning Commission(TCRPC)annual financial report. It presents discussion
and analysis of the Commission's financial performance during the fiscal year that ended September 30, 2015.
Please read it in conjunction with the attached financial statements.
Financial Highlights
Our FY 2015 financial status slightly improved from the prior year. Net position increased by $3,722 compared to
2014 increases of$58,538 and 2013 increases of$40,398. Total Net Position is now$561,615 of which $25,530
represents capital assets. This net position will be used for operating cash-flow, match for federal funding that was
not spent this year,future program shortfalls and capital asset purchases. See tables 1 and 2 below.
i
Table t
Summarized Statements of Net Position
Governmental Activities
Fiscal Year Fiscal Year Fiscal Year
2015 2014 2013
Current assets $ 1,071,410 $ 992,206 $ 782,104
Capital assets, net 25,530 35,033 28,337
Total assets 1,096,940 1,027,239 810,441
Current liabilities 535,325 469,346 311,086
Net investment in capital assets 25,530 35,033 28,337
Unrestricted 536,085 522,860 471,018
Total net position $ 561,615 $ 557,893 $ 499,355
Table 2
Changes in Net Position
Governmental Activities
2015 2014 2013
Net position, October 1 $ 557,893 $ 499,355 $ 458,957
Results of operations 3,722 58,154 37,646
Prior period adjustments - 384 2,752
Total changes in net position 3,722 58,538 40,398
Net position, September 30 $ 561,615 $ 557,893 $ 499,355
For 2015, 2014, and 2013 overall revenues were$1,836,652, $2,902,843, and $2,500,938 respectively and overall
expenses were$1,832,930, $2,844,689, and$2,463,292 respectively, as reported in the statements of activities.
Tri-County Regional Planning Commission F
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2015
Table 3
Summarized Statements of Activity
Governmental Activities
Fiscal Year Fiscal Year Fiscal Year
2015 2014 2013
Revenues
Federal, state, and local funding $ 1,457,734 $ 2,524,350 $ 2,114,636
Local dues 377,850 377,850 377,850
Interest 942 643 462
Miscellaneous 126 7,990
Total Revenues 1,836,652 2,902,843 2,500,938
Expenses 1,832,930 2,844,689 2,463,292
Change in Net Position $ 3,722 $ 58,154 $ 37,646
Overview of the Financial Statements
This annual report consists of three parts:the management discussion and analysis, the basic financial statements
and the required supplementary information. The basic financial statements include two different kinds of statements
that present different views of the Commission.
The firsttwo statements are government wide financial statements and provide both long and short-term information
about our overall financial status. These statements present government activities.
The remaining statements are fund financial statements. They focus on the detail of each of the Commission's fund
accounts. The notes to the financial statements explain information in the statements and provide a more detailed
explanation.
Required supplementary information further explains and supports the financial statement information with
budgetary comparisons.
Government Wide Statements
The government wide statements report information about the Commission as a whole, using accounting methods
and terms normally used by private companies. The statement of net position includes all the Commission's assets
and liabilities. The statement of activities records all of the current year revenues and expenses regardless of when
received or paid.
The two government wide statements report net position and how it has changed. Net position is the difference
between the Commission's assets and deferred outflows of resources, and its liabilities and deferred inflows of
resources,which is one method to measure the Commission's financial health. Over time, increases or decreases
in the Commission's net position is an indicator of whether the Commission's financial position is improving or
deteriorating.
I
- iv-
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2015
Fund Financial Statements
The fund financial statements provide more detailed information about the Commission's fund. Funds are established
to account for funding and spending of specific financial resources and to show proper expenditures of those
resources. Tri-County Regional Planning Commission has the following Governmental fund:
General Operating Fund-The Commission's activities are accounted for in the general fund.
This fund is presented on the modified accrual basis,which is designed to show short-term financial information. You
will note that differences between the government wide statements and the fund statements are disclosed in the
reconciling financial statements to explain the differences between them.
Financial Analysis of the Commission as a Whole
Net Position - The Commission's net position increased during the year ended September 30, 2015, by$3,722.
Total unrestricted net position was$536,085 at year end. The unrestricted net position will be used for operating
cash-flow, future program shortfalls, and capital asset purchases.
Liabilities - The Commission's liabilities increased by $65,979. This was due to increases in accounts payable
and unearned revenues.
Financial Analysis of the Commission's Fund
Amendments to our budget for the year ended September 30, 2015, were to add projects and cover changes in
certain operational expenditures.
General Fund Budgetary Highlights
The Commission adopts an annual budget for the General Fund. A budgetary comparison statement has been
provided as required supplementary information to demonstrate compliance with this budget.
j Federal source and state source revenue were $160,672 and $91,088 lower than anticipated, respectively and
local source revenue was$74,933 higher than anticipated. Although the final expenditure budget increased from
the original budget, the final budget exceeded actual expenditures by$167,938.
Capital Assets
The following is a summary of capital assets and the associated accumulated depreciation:
Fiscal Year Fiscal Year Fiscal Year
2015 2014 2013
Furniture and equipment $ 191,055 $ 191,055 $ 190,463
Less: Accumulated depreciation (165,525) (156,022) (162,126)
Net capital assets $ 25,530 $ 35,033 $ 28,337
The capital assets of the Commission consist exclusively of office furniture and equipment. The Commission has
implemented a capitalization policy consistent with MDOT and federal funding that require all items, other than
buildings, building improvements and land improvements, purchased having a useful life in excess of one year
and an individual cost of more than $5,000 be capitalized and depreciated. The capitalization threshold for
buildings and building improvements is $50,000 and $25,000 for land improvements. There were no additions to
capital assets purchased in the current fiscal year. Note D to the financial statements provides additional
information regarding capital assets.
-v-
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2015
I
Contacting Commission Management
This financial report is designed to provide a general overview of the Commission's finances and to demonstrate
the Commission's accountability for the revenues it receives. If you have any questions concerning the report,
please contact the Commission's office.
I'
I
A -
i
i
BASIC FINANCIAL STATEMENTS
Tri-County Regional Planning Commission
STATEMENT OF NET POSITION
September 30, 2015
ASSETS
Current assets
Cash $ 717,434
Due from other governmental units 346,830
Prepaid expenses 7,146
Total current assets 1,071,410
Noncurrent assets
Capital assets, net 25,530
TOTAL ASSETS 1,096,940
LIABILITIES
Current liabilities
Accounts payable 41,307
Accrued wages and related items 41,642
Compensated absences 32,744
Unearned revenue 419,632
Total current liabilities 535,325 p
NET POSITION E
Investment in capital assets 25,530
Unrestricted 536,085
TOTAL NET POSITION $ 561,615
See accompanying notes to financial statements.
_ 1 _
Tri-County Regional Planning Commission
STATEMENT OF ACTIVITIES
Year Ended September 30, 2015
Net (Expense)
Operating Revenue and
Grants and Changes in
Functions/Programs Expenses Contributions Net Position
Governmental activities
Planning programs $ 1,832,930 $ 1,457,734 $ (375,196)
i
General revenues
Member allocations 377,850
Investment earnings 942
Miscellaneous 126
Total general revenues 378,918
i
Change in net position 3,722
Net position, beginning of the year 557,893
Net position, end of the year $ 561,615
i
See accompanying notes to financial statements.
2
Tri-County Regional Planning Commission
Governmental Fund
BALANCE SHEET
September 30, 2015
General
ASSETS
Cash $ 717,434
Due from other governmental units 346,830
Prepaids 7,146
TOTAL ASSETS $ 1,071,410
LIABILITIES
Accounts payable $ 41,307
Accrued wages and related items 74,386
Unearned revenue 419,632
TOTAL LIABILITIES 535,325
FUND BALANCE p
Nonspendable- prepaids 7,146
Unassigned 528,939
TOTAL FUND BALANCE 536,085
TOTAL LIABILITIES AND FUND BALANCE $ 1,071,410
it
See accompanying notes to financial statements.
- 3-
Tri-County Regional Planning Commission
RECONCILIATION OF THE GOVERNMENTAL FUND BALANCE SHEET
TO THE STATEMENT OF NET POSITION
September 30, 2015
Total fund balance -governmental fund $ 536,085
Amounts reported for the governmental activities in the statement of net position are different because:
Capital assets used in governmental activities are not financial resources
and therefore are not reported as assets in the governmental fund.
The cost of capital assets is $ 191,055
Accumulated depreciation is (165,525)
Capital assets, net 25,530
Net position of governmental activities $ 561,615
I
See accompanying notes to financial statements.
-4 -
Tri-County Regional Planning Commission
Governmental Fund
STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE
Year Ended September 30, 2015
General
REVENUES
Federal sources $ 948,242
State sources 82,546
Local sources 426,946
Member allocations 377,850
Interest 942
Other 126
TOTAL REVENUES 1,836,652
EXPENDITURES
Current
Community and economic development
Planning programs 1,823,427
NET CHANGE IN FUND BALANCE 13,225 p
Fund balance, beginning of year 522,860
Fund balance, end of year $ 536,085
1 .
See accompanying notes to financial statements.
- 5 -
Tri-County Regional Planning Commission
RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES,
AND CHANGES IN FUND BALANCE OF THE GOVERNMENTAL
FUND TO THE STATEMENT OF ACTIVITIES
Year Ended September 30, 2015
Net change in fund balance -governmental fund $ 13,225
Amounts reported for governmental activities in the statement of activities are different because:
Capital outlays are reported as expenditures in the governmental fund. However, in the
statement of activities, the cost of capital assets is allocated over their estimated useful
lives as depreciation expense. In the current period, these amounts are:
Depreciation expense (9,503)
Change in net position of governmental activities $ 3,722
i
i
See accompanying notes to financial statements.
-6-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE A: DESCRIPTION OF ORGANIZATION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Tri-County Regional Planning Commission (the Commission) is a governmental unit established July 18, 1956,
underthe authority of Act 281 of Michigan Public Acts of 1945. The Commission is a voluntary organization joining
Clinton, Eaton, and Ingham Counties and the City of Lansing to foster a cooperative effort in identifying and
resolving various community planning issues in the Tri-County area. Primary financing is provided through various
agreements with state and federal agencies and local appropriations.
1. Reporting Entity
All funds (primary government) under direct control of the Commission are included in this report. These funds are
those which meet the criteria established by the Governmental Accounting Standards Board (GASB). The
Commission is considered a special purpose governmental unit operating governmental activities and account for
those activities in a single governmental fund.
2. Basis of Presentation
GOVERNMENT-WIDE FINANCIAL STATEMENTS -
The statement of net position and the statement of activities (the government-wide financial statements) present
information for the Commission as a whole.
The statement of activities presents the direct functional expenses of the Commission and the program revenues
that support them. Direct expenses are specifically associated with a service, program, or department and are
therefore clearly identifiable to a particular function. Program revenues are associated with specific functions and
include charges to recipients of goods or services and grants and contributions that are restricted to meeting the
operational or capital requirements of that function. Revenues that are not required to be presented as program
revenues are general revenues. This includes all member allocations, interest, and other general revenues and
shows how governmental functions are either self-financing or supported by the general revenues of the
Commission.
FUND FINANCIAL STATEMENTS _
The fund financial statements present the Commission's only fund. The General Fund is the Commission's
operating fund. It is used to account for all financial resources of the Commission. General Fund activities are
financed by revenue from governmental grants, member allocations, and other sources.
3. Measurement Focus i
The government-wide financial statements are presented using the economic resources measurement focus,
similar to that used by business enterprises or not-for-profit organizations. Because another measurement focus
is used in the governmental fund financial statements, reconciliations to the government-wide financial statements
are provided that explain the differences in detail.
All governmental funds are presented using the current financial resources measurement focus. With this
measurement focus, only current assets, deferred outflows of resources, current liabilities, and deferred inflows of
resources generally are included on the balance sheet. Operating statements of these funds present increases(i.e.,
revenues and other financing sources)and decreases(i.e., expenditures and other financing uses)in fund balance.
4. Basis of Accounting
Basis of accounting refers to the timing under which transactions are recognized for financial reporting purposes.
Governmental fund financial statements use the modified accrual basis of accounting. The government-wide
financial statements are prepared using the accrual basis of accounting.
-7-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE A: DESCRIPTION OF ORGANIZATION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
-CONTINUED
4. Basis of Accounting - continued
Under the accrual basis of accounting, revenue is recorded in the period in which it is earned and expenses are
recorded when incurred, regardless of the timing of related cash flows. Revenues for grants, entitlements, and
donations are recognized when all eligibility requirements imposed by the provider have been met. Unearned
revenue is recorded when resources are received by the Commission before it has legal claim to them, such as
when grant monies are received prior to the incurrence of qualified expenses.
i
Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when
they become both measurable and available). "Measurable" means the amount of the transaction can be
determined and "available" means collectible within the current period or soon enough thereafter to be used to
pay liabilities of the current period. The length of time used to define "available" for purposes of revenue
recognition in the governmental fund financial statements is sixty (60) days. Revenues susceptible to accrual
include property taxes, state aid, and interest revenue. Other revenues are not susceptible to accrual because
generally they are not measurable until received in cash. Expenditures are recorded when the related fund liability
is incurred, except for principal and interest on long-term debt which are recorded when due.
Resources are considered available if they are collected during the current fiscal year or soon enough afterward
to be used in payment of current year liabilities. Unavailable revenues arise when potential revenue does not
meet both the "measurable" and "available" criteria for recognition in the current period. Unavailable revenues
also arise when the Commission receives resources before it has a legal claim to them. In subsequent periods,
when both revenue recognition criteria are met, the liability for unavailable revenue is removed from the balance
sheet and revenue is recognized.
If/when both restricted and unrestricted resources are available for use, it is the Commission's practice to use
restricted resources first, then unrestricted resources as they are needed.
5. Budgets and Budgetary Accounting
The overall budget is based upon individual projects and the general operating fund budgets. Budgeted amounts
are as originally adopted, and may be amended by the Commission. Net individual budget amendments were not
material in relation to the originally approved amounts. Budgets lapse at the end of the fiscal year.
6. Capital Assets
Capital assets are recorded (net of accumulated depreciation, if applicable) and are those assets with an initial
individual cost of$50,000 for buildings and building improvements, $25,000 for land improvements, and $5,000
for all other assets and an estimated useful life of more than one year. All purchased capital assets are valued at
cost where historical records are available and at an estimated historical cost where no historical records exist.
Donated capital assets are valued at their estimated fair market value on the date received.
The cost of normal maintenance and repairs that do not add to the value of the asset or materially extend asset
lives are not capitalized. Depreciation is computed using the straight-line method over the following useful lives:
Infrastructure 20-100 years
Buildings and building improvements 20-50 years
Vehicles 4-15 years
Furniture and equipment 5-7 years
8
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE A: DESCRIPTION OF ORGANIZATION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
-CONTINUED -
7. Cash
Cash consists of the Commission's checking and savings accounts.
8. Indirect Cost Allocations
I
Indirect costs are allocated to all projects equally. Allocated indirect costs in excess of amounts that can be funded
by a contract or grant are absorbed by the Commission through indirect credits. The indirect cost rate percentage
is applied only against allowable direct costs in each project.
9. Deferred Outflows/Inflows of Resources
In addition to assets, the statement of net position and the balance sheet, when applicable, will report a separate
section for deferred outflows of resources. This separate financial statement element, deferred outflows of
resources, represents a consumption of net position/fund balance that applies to a future period(s) and so will not
be recognized as an outflow of resources (expense/expenditure) until that time.
In addition to liabilities, the statement of net position and the balance sheet, when applicable,will report a separate
section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources,
represents an acquisition of net position/fund balance that applies to a future period and so will not be recognized
as an inflow of resources(revenue) until that time.
Currently the Commission does not report any deferred outflows of resources or deferred inflows of resources.
10. Compensated Absences
Accumulated unpaid vacation benefit obligations are accrued when incurred; as such obligations are expected to
be paid within the ensuing year.
For governmental funds,the cost of accumulated vacation along with the related payroll taxes expected to be paid
with current expendable resources is recorded as a fund liability.
11. Federal Programs
Federal Programs are accounted for in the funds to which the program pertains. The Commission has not
integrated its Single Audit Report and financial data as a part of the financial statements. The Single Audit Report
and financial data will be issued under separate cover as supplementary information to the financial statements.
12. Comparative Data
Comparative data for the prior year has not been presented in the accompanying financial statements since their
inclusion would make the statements unduly complex and difficult to read.
- 9-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE B: CASH
` In accordance with Michigan Compiled Laws, the Commission is authorized to invest in the following investment
vehicles:
1. Bonds, securities, and other obligations of the United States or an agency or instrumentality of the United
States.
2. Certificates of deposit, savings accounts, deposit accounts, or depository receipts of a bank which is a member
of the Federal Deposit Insurance Corporation (FDIC)or a savings and loan association which is a member of
the Federal Savings and Loan Insurance Corporation (FSLIC)or a credit union which is insured by the National
Credit Union Administration, but only if the bank,savings and loan association, or credit union is eligible to be a
depository of surplus funds belonging to the State under Section 5 or 6 of Act No. 105 of the Public Acts of 1855,
as amended, being Section 21.145 and 21.146 of the Michigan Compiled Laws.
3. Commercial paper rated at the time of purchase within the three(3) highest classifications established by not
less than two (2) standard rating services and which matures not more than 270 days after the date of
purchase.
4. The United States government or Federal agency obligations repurchase agreements.
5. Bankers' acceptances of United States banks.
6. Mutual funds composed of investment vehicles, which are legal for direct investment by local units of
government in Michigan.
Deposits
There is a custodial risk as it relates to deposits. In the case of deposits,this is the risk that in the event of a bank
failure, the Commission's deposits may not be returned to it. As of September 30, 2015, the carrying amounts
and bank balances for the accounts were as follows:
Carrying Bank
Account Type Amount Balance
Checking $ 28,159 $ 26,674
Savings 689,125 689,125
$ 717,284 $ 715,799
Deposits of the Commission are at federally insured banks located in the State of Michigan with all accounts
maintained in the name of the Commission. The bank balances as of September 30, 2015,were federally insured
for$501,998 and the amount of$213,801 was uninsured and uncollateralized. The cash caption on the financial
statements includes$150 of imprest cash.
Credit risk
State law limits investments in certain types of investments to a prime or better rating issued by nationally
recognized statistical rating organizations (NRSRO's). As of September 30, 2015, the Commission did not have
any investments that would be subject to rating.
- 10-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015 1
NOTE B: CASH -CONTINUED
Custodial credit risk
The Commission will minimize custodial credit risk,which is the risk of loss due to the failure of the security issuer
or backer by diversifying its investments by security type and institution to ensure that potential losses on individual
securities do not exceed the income generated from the remainder of the portfolio, by limiting the investment types
to savings accounts and certificates of deposit, and by pre-qualifying the financial institutions, brokers/dealers,
intermediaries and advisers.
Concentration of credit risk
The Commission will minimize concentration of credit risk, which is the risk of loss attributed to the magnitude of
the Commission's investment in a single issuer, by diversifying the investment portfolio so that the impact of
potential losses from any one type of security or from any one individual issuer will be minimized.
Interest rate risk
The Commission will minimize interest rate risk,which is the risk that the market value of securities in the portfolio
will fall due to changes in the market interest rates by structuring the investment portfolio so that securities mature
to meet cash requirements for ongoing operations,thereby avoiding the need to sell securities on the open market
prior to maturity,and by investing operating funds primarily in shorter-term securities, money market mutual funds,
or similar investment pools and limiting the average maturity of the portfolio in accordance with this policy. f
1
NOTE C: DUE FROM OTHER GOVERNMENTAL UNITS
Due from other governmental units at September 30,2015, by grant type are as follows:
Federal
FHWA PL Funds 2015-0011/Z1 $ 137,545
FTA Section 5303 Funds 2015-001122 43,697
Surface Transportation Program 2015-0011/Z3 and 2015-001 VZ4 49,586
Michigan Department of Transportation
Asset Management 2015-0022/Z1 31,247
Regional Transportation Contract 2015-0022/Z2 20,166
State Planning and Research MDOT/FHWA 2015-0011/Z3 8,861
Mid-Michigan Water Authority 6,268
Other Local Units 49,460
$ 346,830
I
� . II
- 11 -
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTED: CAPITAL ASSETS
Capital asset activity for the year ended September 30,2015,was as follows:
Balance Balance
� Capital assets being depreciated
Oct. 1, 2014 Additions Disposals Sept. 30, 2015 '
Furniture and equipment $ 191,055 $ $ $ 191,055
Less accumulated depreciation for:
Furniture and equipment (156,022) (9,503) (165,525)
Net capital assets $ 35,033 $ (9,503) $ -0- $ 25,530
NOTE E: LONG-TERM OBLIGATIONS
The following is a summary of changes in long-term obligations (including current portion) of the Commission for
the year ended September 30, 2015.
Amount
Balance Balance Due Within
i
Oct. 1, 2014 Earned Used Sept. 30, 2015 One Year
Compensated absences $ 32,920 $ 128,902 $ (129,078) $ 32,744 $ 32,744
Vacation leave is earned in varying amounts depending on the number of years of service of an employee and is
made available on the anniversary date of the employee.
Upon termination, an employee receives payment for the balance of unused vacation leave, which is credited to
an employee each month.
NOTE F: RETIREMENT PLAN
The Commission provides pension benefits for all non-temporary employees through a defined contribution plan,
which was established by the Board of Commissioners and may be amended from time to time by the Board. This
plan is administered by the Michigan Municipal Employees Retirement System. In a defined contribution plan,
benefits depend solely on amounts contributed to the plan plus investment earnings. The Commission's
contributions are vested at a graded rate based on year of service.
Years of Vesting
Service Percentage
1 0%
2 20
3 40
4 60
5 80
6 100
The employer is required to contribute 9%of all covered payroll. Required contributions to the plan were$65,032,
covered payroll was $721,306, and total payroll was $721,306 during the fiscal year. Contributions to the plan
during the fiscal year were$65,032.
- 12-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE G: CONTINGENT LIABILITIES
Under the terms of various Federal and State grants, periodic compliance audits are required and certain costs
may be questioned,allowed,or disallowed,which could result in funds being returned and/or received from grantor
agencies.
NOTE H: ECONOMIC DEPENDENCY
The Commission receives substantially all of its support from federal, state, and local governments. A significant
reduction in the level of this support, if this were to occur,could have an effect on the Commission's activities.
NOTE I: LEASE COMMITMENTS
The Commission leases office space. The original lease term began November 1, 2011, and was for 123 months.
Rental expense for the year ended September 30, 2015,was$51,464. Future minimum payments are as follows:
Year Ending
September 30,
2016 $ 52,492
2017 53,524
2018 54,548 i[
2019 55,576
2020 56,600
2021-2022 76,952
$ 349,692
NOTE J: RISK MANAGEMENT
The Commission participates in the Michigan Township Participating Plan (the Plan),with other municipalities for
property, liability, auto, crime, equipment breakdown, public official wrongful acts, boiler and machinery, and EDP
losses. The Plan is organized under Public Act 138 of 1982, as amended. The Plan,while it operates under the
Michigan Legislation of Public Act 138,does not operate as a risk pool due to the transfer of risk to U.S. Specialty
Insurance Company ("USSIC") backing the Michigan Township Participating Plan under a master policy for the
period July 1, 2011 to July 1, 2019. Due to the Master Policy purchase, there is no pooling of risk between
members, but is instead considered commercial insurance. Settled claims relating to this insurance have not
exceeded the amount of insurance coverage in any of the past three (3)years.
The Commission carries commercial insurance for the risk of loss due to workers' compensation claims. Settled
claims relating to commercial insurance have not exceeded the amount of insurance coverage in any of the past
three (3)fiscal years. ,
NOTE K: DETAILS OF FUND BALANCE CLASSIFICATIONS
GASB Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions, established fund
balance classifications that comprise a hierarchy based primarily on the extent to which a government is bound
to observe constraints imposed upon the use of the resources reported in governmental funds. The following are
the five classifications of fund balance under this standard:
- 13-
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2015
NOTE K: DETAILS OF FUND BALANCE CLASSIFICATIONS -CONTINUED
Nonspendable - assets that are not available in a spendable form such as inventory, prepaid expenditures, and
long-term receivables not expected to be converted to cash in the near term. It also includes funds that are legally
or contractually required to be maintained intact such as the corpus of a permanent fund or foundation.
Restricted - amounts that are required by external parties to be used for a specific purpose. Constraints are
externally imposed by creditors, grantors, contributors or laws, regulations or enabling legislation.
Committed-amounts constrained on use imposed by formal action of the government's highest level of decision
making authority(i.e., Board, Council, etc.).
Assigned- amounts intended to be used for specific purposes. This is determined by the governing body, the
budget or finance committee or a delegated municipality official.
Unassigned-all other resources;the remaining fund balance after nonspendable, restrictions, commitments, and
assignments. This class only occurs in the General Fund, except for cases of negative fund balances. Negative
fund balances are always reported as unassigned, no matter which fund the deficit occurs in.
Fund Balance Classification Policies and Procedures
For committed fund balance, the Commission's highest level of decision-making authority is the Board of
Commissioners. The formal action that is required to be taken to establish, modify, or rescind a fund balance
commitment is a resolution by the Board of Commissioners.
For assigned fund balance, the Commission has not approved a policy indicating who is authorized to assign
amounts to a specific purpose. As a result,this authority is retained with the Board of Commissioners.
The Commission has not formally adopted a policy that determines when both restricted and unrestricted fund
balances are available which should be used first,therefore restricted resources will be used first,then unrestricted
i
resources if they are needed.
NOTE L: UPCOMING ACCOUNTING PRONOUNCEMENTS
In March 2015, the GASB issued Statement No. 72, Fair Value Measurement and Application. This Statement
addresses accounting and financial reporting issues related to fair value measurements. The definition of fair value
is the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between
market participants at the measurement date. This Statement provides guidance for determining a fair value
measurement for financial reporting purposes. This Statement also provides guidance for applying fair value to
certain investments and disclosures related to all fair value measurements. The Commission is currently evaluating
the impact this standard will have on the financial statements when adopted for the 2015-2016 fiscal year.
In June 2015, the GASB issued Statement No. 76, The Hierarchy of Generally Accepted Accounting Principles
for State and Local Governments. The statement supersedes Statement No. 55, The Hierarchy of Generally
Accepted Accounting Principles for State and Local Governments. The statement reduces the GAAP hierarchy
to two categories of authoritative GAAP and addresses the use of authoritative and nonauthoritative literature in
the event that the accounting treatment for a transaction or other event is not specified within a source of
authoritative GAAP. The Commission is currently evaluating the impact this standard will have on the financial
statements when adopted during the 2015-2016 fiscal year.
I '
- 14 -
E
III
ICI
�'
C
� .
� . II
� , II
� .
� :
I
REQUIRED SUPPLEMENTARY INFORMATION
i
Tri-County Regional Planning Commission
General Fund
BUDGETARY COMPARISON SCHEDULE
Year Ended September 30, 2015
Variance with
Budgeted Amounts Final Budget
Positive
Original Final Actual (Negative)
REVENUES
Federal sources $ 1,062,307 $ 1,108,914 $ 948,242 $ (160,672)
State sources 116,634 173,634 82,546 (91,088)
Local sources 377,045 352,013 426,946 74,933
Member allocations 377,850 377,850 377,850 -0-
Interest - - 942 942
Other - - 126 126
TOTAL REVENUES 1,933,836 2,012,411 1,836,652 (175,759)
EXPENDITURES
Current
Community and economic development
Salaries 787,272 733,848 721,306 12,542
Fringe benefits 456,954 425,632 402,142 23,490
Discretionary fund 5,000 5,000 4,936 64
Recognition awards 250 250 - 250
Telephone 2,400 2,650 3,188 (538)
Postage 7,840 4,100 2,706 1,394
Printing and copying 24,850 14,850 17,056 (2,206)
Office supplies 11,200 11,200 10,897 303
Graphics supplies 2,050 1,050 874 176
Travel -in region 13,950 18,450 16,861 1,589
Travel -out region 19,275 21,275 21,977 (702)
Training 11,500 11,500 8,832 2,668
Commission meeting expenses 2,250 1,950 1,887 63
Commission travel 1,500 500 75 425
Rent-meeting facility 2,300 1,300 232 1,068
Rent-office 66,000 66,000 65,722 278
Rent-equipment 1,750 750 750
Equipment maintenance 5,000 2,500 1,732 768
Computer services 40,000 32,750 31,579 1,171
Computer software 32,000 25,000 21,851 3,149
Insurance 7,000 7,833 7,833 -0-
Bank service charges 1,200 1,200 789 411
Subscriptions 800 550 454 96
Publications 1,600 500 104 396
Advertising 4,100 6,100 4,772 1,328
Membership dues 16,000 11,000 10,424 576
- 15-
Tri-County Regional Planning Commission
General Fund
BUDGETARY COMPARISON SCHEDULE- CONTINUED
Year Ended September 30, 2015
Variance with
Budgeted Amounts Final Budget
Positive
Original Final Actual (Negative)
EXPENDITURES-CONTINUED
Current-continued
Community and economic
development-continued
Special projects $ 109,100 $ 87,100 $ 67,674 $ 19,426
Consultant fee 75,868 125,868 123,082 2,786
Contractual services 116,300 66,300 2,500 63,800
Furniture/equipment purchases 15,100 15,100 14,774 326
Audit 9,500 9,200 9,200 -0-
Pass-through 84,027 280,059 247,968 32,091
` TOTAL EXPENDITURES 1,933,836 1,991,365 1,823,427 167,938
EXCESS OF REVENUES
OVER EXPENDITURES -0- 21,046 13,225 (7,821)
OTHER FINANCING SOURCES (USES)
Transfer for local match (238,439) (241,664) (202,312) 39,352
Operating transfers in local match 238,439 241,664 202,312 (39,352)
TOTAL OTHER FINANCING
SOURCES (USES) -0- -0- -0- -0-
NET CHANGE IN FUND BALANCE -0- 21,046 13,225 (7,821)
Fund balance, beginning of year 522,860 522,860 522,860 -0-
Fund balance, end of year $ 522,860 $ 543,906 $ 536,085 $ (7,821)
- 16 -
i
� �
��
� �
'!�
� �
� �!�
� ''
� '
. I'I
II
, I
OTHER SUPPLEMENTARY INFORMATION
f,
r
� I
C �
� ,'
� '
� I!
6 �'
f
� .
Tri-County Regional Planning Commission
SCHEDULE OF COMMISSION REVENUES AND EXPENDITURES (UNAUDITED)
i
Year Ended September 30, 2015
Special Projects
Operating Indirect Direct Total Eliminations Total
REVENUES
Federal sources $ - $ - $ 948,242 $ 948,242 $ - $ 948,242
State sources - - 82,546 82,546 - 82,546
Local sources - - 426,946 426,946 - 426,946
Member allocations 377,850 - - -0- - 377,850
Interest 942 - - -0- - 942
Operating transfers in local match - - 202,312 202,312 (202,312) -0-
Other 9,629 - -0- (9,503) 126
TOTAL REVENUES 388,421 -0- 1,660,046 1,660,046 (211,815) 1,836,652
EXPENDITURES
Direct costs
Salaries and wages 61,577 167,424 492,306 659,729 - 721,306
Fringe benefits 34,330 93,339 274,473 367,812 - 402,142
Discretionary funds 4,936 - - -0- - 4,936
Telephone - 3,188 - 3,188 - 3,188
Postage 867 1,000 839 1,839 - 2,706
Printing and copying 2,391 2,453 12,212 14,665 - 17,056
Office supplies 47 7,448 3,402 10,850 - 10,897
Graphic supplies 58 718 98 816 - 874
Travel-in region 62 5,336 11,463 16,799 - 16,861
Travel-out region 497 5,475 16,005 21,480 - 21,977
Training 1,552 5,254 2,026 7,280 - 8,832
Commission meeting expenses 1,887 - - -0- - 1,887
Commission travel 75 - - -0- - 75
Rent-meeting facility - - 232 232 - 232
Rent-office - 65,722 - 65,722 - 65,722
Equipment maintenance - 1,732 - 1,732 - 1,732
Computer services - 30,312 1,267 31,579 - 31,579
Computer software - 9,761 12,090 21,851 - 21,851
Insurance - 7,833 - 7,833 - 7,833
Bank service charges 763 26 - 26 - 789
Subscriptions - 432 22 454 - 454
Publications - 71 33 104 - 104
Advertising 25 3,180 1,567 4,747 - 4,772
Depreciation - 9,503 - 9,503 (9,50
Membership dues 395 6,419 3,610 10,029 - 10,424
Special projects - - 67,674 67,674 - 67,674
Consultant fee - - 123,082 123,082 - 123,082
Contractual services - - 2,500 2,500 - 2,500
Furniture/equipment purchases 14,774 - - -0- - 14,774
Audit - 9,200 - 9,200 - 9,200
Pass-through - - 247,968 247,968 - 247,968
Transfer for match 202,312 - - -0- (202,312) -0-
Indirect costs 48,648 (435,826) 387,178 (48,648) -0-
TOTAL EXPENDITURES 376,196 -0- 1,660,046 1,660,046 (211,815) 1,823,427
NET REVENUES OVER
EXPENDITURES $ 13,225 $ -0- $ -0- $ -0- $ -0- $ 13,225
- 17-
6
Tri-County Regional Planning Commission
COMBINING SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) R
Year Ended September 30, 2015 R
GREATER GREATER
LANSING LANSING GROUNDWATER
WELLHEAD: REGIONAL REGIONAL MANAGEMENT 6
MULTI- COMMITTEE COMMITTEE BOARD i
MUNICIPALITIES (GLRC)2014 (GLRC)2015 (GMB)2014
(30500) (30300) (30310) (30400)
REVENUES
Federal sources $ $ $ $
State sources
Localsources 47,399 38,073 92,777 92,214
TOTAL REVENUES 47,399 38,073 92,777 92,214 g
OTHER FINANCING SOURCES 68
Operating transfers in local match - - - -
TOTAL REVENUES AND
OTHER FINANCING SOURCES 47,399 38,073 92,777 92,214 @[
EXPENDITURES
Direct costs
Salaries and wages 20,760 13,898 38,370 37,063
Fringe benefits 11,574 7,749 21,392 20,664
Postage - 12 - 112
Printing and copying 8 26 65 199
Office supplies - - - 53
Graphic supplies - - - -
Travel-in region - 331 1,038 1,121
Travel-out region - - 634 1,489
Training - - - 576
Rent of facility - - - -
Computer services - - 2 269 p
Computer software - -
Publications - -
Subscriptions - -
Advertising - - - -
Membership dues - - 65 678
Special projects - 5,808 2,548 1,022
Consultants - - - -
Contractual services -
Pass-through - - - -
Indirect costs 15,057 10,249 28,663 28,968
TOTAL EXPENDITURES 47,399 38,073 92,777 92,214
NET REVENUES OVER
(UNDER) EXPENDITURES $ -0- $ -0- $ -0- $ -0-
- 18-
MSU WATER
RESEARCH-
" MID-MICHIGAN MID-MICHIGAN MANAGEMENT REGIONAL REGIONAL EDA
WATER WATER PLAN FOR PROSPERITY PROSPERITY PLANNING
AUTHORITY 2014 AUTHORITY 2015 RED CEDAR GRANT GRANT GRANT
(30700) (30800) (31100) (31300) (31310) (31400)
$ $ $ $ $ $ 58,429
2,112 2,522 6,656 41,422 41,503 -
2,112 2,522 6,656 41,422 41,503 58,429
- - - 58,429
2,112 2,522 6,656 41,422 41,503 116,858
I
925 1,098 2,914 12,327 354 45,018
516 612 1,625 6,872 198 25,098
2
6 3 14 2,285 93
5 121 134 2,769
- 59 - 4,895
- 500
- 232
443 -
22
- - 630
8,000 8,850 700
- 12,000 -
j - - - 5,000 15,650 -
671 801 2,114 9,029 1,589 36,899
I
i
2,112 2,522 6,656 41,422 41,503 116,858
$ -0- $ -0- $ -0- $ -0- $ -0- $ -0-
- 19 -
Tri-County Regional Planning Commission
COMBINING SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)- CONTINUED
Year Ended September 30, 2015 1
MDOT GRANT: REGIONAL
AERIAL FHWA PL ASSET TRANSPORTATION
PHOTOGRAPHY FUNDS MANAGEMENT CONTRACT
(312) (32100) (32300) (32400)
REVENUES
Federal sources $ $ 317,292 $ - $ -
State sources - 33,646 40,100
Localsources 62,268 - - -
TOTAL REVENUES 62,268 317,292 33,646 40,100 g
OTHER FINANCING SOURCES &
Operating transfers in local match - 70,375 - - 9
TOTAL REVENUES AND
OTHER FINANCING SOURCES 62,268 387,667 33,646 40,100
EXPENDITURES
Direct costs
Salaries and wages - 146,928 11,020 14,225
Fringe benefits - 81,916 6,144 7,931
Postage - 104 16
Printing and copying - 5,818 - 202
Office supplies - 224 1,988 37
Graphic supplies - - -
Travel- in region - 2,740 140 459
Travel -out region - 3,870 30 651
Training - 565 - 95
Rent of facility - - - -
Computer services - 324 - 62
Computer software - 7,376 - 903
Publications - 18 - 3
Subscriptions - - - -
Advertising - 1,037 - 24
Membership dues - 1,276 - 215
Special projects - 12,806 817 2,640
Consultants - 3,784 - 780
Contractual services - 1,455 - 300
Pass-through 62,268 - 4,512 -
Indirect costs - 117,426 8,995 11,557
TOTAL EXPENDITURES 62,268 387,667 33,646 40,100
NET REVENUES OVER
(UNDER) EXPENDITURES $ -0- $ -0- $ -0- $ -0-
-20-
- I,
HUD
SUSTAINABLE
COMMUNITIES
ASSISTANCE TO: REGIONAL
SURFACE FTA GRANT STATE MOOT OFFICE OF PLANNING
TRANSPORTATION SECTION 5303 PLANNING AND PASSENGER GRANT
PROGRAM GRANT FUNDS RESEARCH TRANSPORTATION PROGRAM
(32800) (33000) (34000) (34500) (35000) TOTAL
$ 73,562 $ 170,001 $ 15,200 $ - $ 313,758 $ 948,242
- - 3,800 5,000 - 82,546
- - - - 426,946
73,562 170,001 19,000 5,000 313,758 1,457,734
31,020 42,488 - - - 202,312
104,582 212,489 19,000 5,000 313,758 1,660,046
- 81,438 8,122 2,187 55,658 492,305
- 46,403 4,529 1,220 31,030 274,473
- 53 15 - 525 839
- 2,847 53 5 588 12,212
- 115 - - 985 3,402
- - - 98 98
1,410 242 - 953 11,463
1,990 - - 2,387 16,005
290 - 2,026
- - - 232
167 - - 1,267
3,811 - - - 12,090
9 3 - - 33
- - - - 22
506 - - - 1,567
656 - - 90 3,610
- 6,554 - - 17,929 67,674
104,582 1,936 - - - 123,082
- 745 - - - 2,500
- - - 160,538 247,968
- 64,559 6,036 1,588 42,977 387,178
104,582 212,489 19,000 5,000 313,758 1,660,046
$ -0- $ -0- $ -0- $ -0- $ -0- $ -0-
-21 -
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) [
DEWITT TOWNSHIP PERMIT ASSISTANCE i
Project period January 1, 2013 through December 31, 2014
DEW ITT TOWNSHIP - Cash (30110)
Jan. 1, 2014 Oct. 1,2014 Jan. 1, 2014
through through through
Sept. 30, 2014 Dec. 31, 2014 Dec. 31, 2014
REVENUES
Local
Cash received $ 6,733 $ $ 6,733
Accounts receivable- prior year 1,755 1,755
TOTAL REVENUES $ 8,488 $ -0- $ 8,488
EXPENDITURES
Direct costs
Salaries $ 3,752 $ - $ 3,752
Fringe benefits 1,999 - 1,999
Printing and copying 13 - 13
Travel -in region 30 - 30
Indirect costs 2,694 - 2,694
TOTAL EXPENDITURES $ 8,488 $ -0- $ 8,488
1
-22-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
WELLHEAD: MULTI - MUNICIPALITIES
Project period October 1, 2014 through September 30, 2015
MULTI - MUNICIPALITIES -Cash (30500)
REVENUES
Local
Cash received $ 47,399
EXPENDITURES
Direct costs
Salaries $ 20,760
Fringe benefits 11,574
Printing and copying g
Indirect costs 15,057
TOTAL EXPENDITURES $ 47,399
i
l
i
-23 -
� i
f
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
GREATER LANSING REGIONAL COMMITTEE (GLRC)2014
Project period January 1, 2014 through December 31, 2014
VARIOUS MUNICIPALITIES -Cash (30310)
Jan. 1, 2014 Oct. 1, 2014 Jan. 1, 2014
through through through
Sept. 30, 2014 Dec. 31, 2014 Dec. 31, 2014
REVENUES
Local
Cash received $ 118,710 $ - $ 118,710
Unearned revenue (68,364) 38,073 (30,291)
TOTAL REVENUES $ 50,346 $ 38,073 $ 88,419
EXPENDITURES
Direct costs
Salaries $ 19,942 $ 13,898 $ 33,840
Fringe benefits 10,596 7,749 18,345
Postage - 12 12
Printing and copying 41 26 67
Rent of facility 36 36
Travel -in region 26 331 357
Travel -out region 965 - 965
Membership dues 20 - 20 qqq
Special projects 4,334 5,808 10,142
Indirect costs 14,386 10,249 24,635
TOTAL EXPENDITURES $ 50,346 $ 38,073 $ 88,419 I'il
24
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
GREATER LANSING REGIONAL COMMITTEE (GLRC)2015
Project period January 1, 2015 through December 31, 2015
VARIOUS MUNICIPALITIES- Cash (30300)
Jan. 1, 2015
through
Sept. 30, 2015
REVENUES
Local
Cash received $ 101,873
Unearned revenue-current year (39,261)
Unearned revenue -prior year 30,165
TOTAL REVENUES $ g2,777
EXPENDITURES
Direct costs
Salaries $ 38,370
Fringe benefits 21,392
Printing and copying 65
Travel -in region 1,038
Travel -out region 634
Computer services 2
Membership dues 65
Special projects 2,548
Indirect costs 28,663
TOTAL EXPENDITURES $ 92,777
-25-
i
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
GROUNDWATER MANAGEMENT BOARD (GMB)2014
Project period October 1, 2014 through September 30, 2015
VARIOUS MUNICIPALITIES - Cash (30400)
REVENUES
Local
Cash received $ 92,500
Unearned revenue- prior year 40,301
Unearned revenue-current year (40,587)
TOTAL REVENUES $ 92,214
EXPENDITURES
Direct costs
Salaries $ 37,063
Fringe benefits 20,664
Postage 112
Printing and copying 199
Office supplies 53 {
Travel - in region 1,121
Travel -out region 1,489
Training 576 r
Computer software 269 `l
Membership dues 678
Special projects 1,022
Indirect costs 28,968
TOTAL EXPENDITURES $ 92,214
-26 -
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MID-MICHIGAN WATER AUTHORITY 2014
Project period January 1, 2014 through December 31,2014
VARIOUS MUNICIPALITIES- Cash (30700)
Jan. 1, 2014 Oct. 1, 2014 Jan. 1, 2014
through through through
Sept.30, 2014 Dec. 31, 2014 Dec. 31, 2014
REVENUES
Local
Accounts receivable-current year $ - $ 2,112 $ 2,112
Accounts receivable - prior year 1,594 - 1,594
TOTAL REVENUES $ 1,594 $ 2,112 $ 3,706
EXPENDITURES
Direct costs
Salaries $ 702 $ 925 $ 1,627
Fringe benefits 383 516 899
Postage 7 - 7
Printing and copying 4 - 4
Indirect costs 498 671 1,169
TOTAL EXPENDITURES $ 1,594 $ 2,112
I
i
-27 -
i
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) 6
MID-MICHIGAN WATER AUTHORITY 2015 1
Project period January 1, 2015 through December 31, 2015
VARIOUS MUNICIPALITIES -Cash (30800)
Jan. 1, 2015
through
Sept. 30, 2015
REVENUES
Local
Accounts receivable- current year $ 2,522
EXPENDITURES g
Direct costs i
Salaries $ 1,098
Fringe benefits 612
Printing and copying 6
Travel -in region 5
Indirect costs 801
TOTAL EXPENDITURES $ 2,522
-28-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MSU WATER RESEARCH - MANAGEMENT PLAN FOR THE RED CEDAR
Project period February 1, 2012 through January 31, 2015
VARIOUS MUNICIPALITIES -Cash (31100)
Feb. 1, 2012 Oct. 1, 2014 Feb. 1, 2012
through through through
Sept. 30, 2014 Jan. 31, 2015 Jan. 31, 2015
REVENUES
Local
Cash received $ 47,092 $ 6,656 $ 53,748
EXPENDITURES
Direct costs
Salaries $ 20,848 $ 2,914 $ 23,762
Fringe benefits 10,640 1,625 12,265
Printing and copying 49 3 52
Travel -in region 471 - 471
Indirect costs 15,084 2,114 17,198
TOTAL EXPENDITURES $ 47,092 $ 6,656 $ 53,748
i
-29 -
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
REGIONAL PROSPERITY GRANT
Project period March 1, 2015 through September 30, 2015
VARIOUS MUNICIPALITIES- Cash (31300) @
Mar. 1,2015 @
through p`
Sept. 30, 2015 Y
REVENUES
Local
Cash received $ 228,750
Unearned revenue-current year (187,328)
TOTAL REVENUES $ 41,422
EXPENDITURES
Salaries $ 12,327
Fringe benefits 6,872
Printing and copying 14
Travel -in region 121
Travel -out region 59
Special projects 8,000
Pass-through 5,000
Indirect costs 9,029
TOTAL EXPENDITURES $ 41,422 @
I
II�
- 30 -
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
REGIONAL PROSPERITY GRANT
Project period June 1, 2014 through December 31, 2014
VARIOUS MUNICIPALITIES - Cash (31310)
June 1, 2014 October 1, 2014 June 1, 2014
through through through
Sept. 30, 2014 Dec. 31, 2014 Dec. 31, 2014
REVENUES
Local
Cash received $ 155,300 $ - $ 155,300
I
Unearned revenue-current year (41,503) 41,503 -0-
TOTAL REVENUES $ 113,797 $ 41,503 $ 155,300
EXPENDITURES
Salaries $ 22,805 $ 354 $ 23,159
Fringe benefits 12,453 198 12,651
Telephone 10 - 10
Printing and copying 22 2,285 2,307
Travel- in region 411 134 545
Travel -out region 280 - 280
Computer service - 443 443
Special projects 35,450 8,850 44,300
Consultant fee - 12,000 12,000
Pass-through 26,000 15,650 41,650
Indirect costs 16,366 1,589 17,955
TOTAL EXPENDITURES $ 113,797 $ 41,503 $ 155,300
- 31 -
1
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) 1
EDA PLANNING GRANT I
Project period July 1, 2013 through June 30, 2016
EDA GRANT NO. 06-83-05565 (31400)
EDA-$169,095 Cash
TCRPC - $169,095 Cash
July 1, 2013 Oct. 1, 2014 July 1, 2013
through through through
Sept. 30, 2014 Sept. 30, 2015 Sept. 30, 2015
REVENUES
Federal grant
Cash received $ 60,503 $ 56,365 $ 116,868
Accounts receivable-prior year 9,953 - 9,953
Unearned revenue-current year - (31,348) (31,348)
Unearned revenue- prior year (33,412) 33,412 -0-
TOTAL REVENUES 37,044 58,429 95,473
OTHER FINANCING SOURCES
Operating transfers in
Local match 37,044 58,429 95,473
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 74,088 $ 116,858 $ 190,946
EXPENDITURES
Direct costs
Salaries $ 31,260 $ 45,018 $ 76,278
Fringe benefits 16,763 25,098 41,861
Postage - 2 2
Printing and copying 83 93 176
Travel -in region 1,578 2,769 4,347 r
Travel -out region 760 4,895 5,655 I
Training - 500 500
Rent of facility 232 232 r
Subscriptions - 22 22 El
Membership dues 270 630 900
Special projects - 700 700 ifp
Indirect costs 23,374 36,899 60,273 1
TOTAL EXPENDITURES $ 74,088 $ 116,858 $ 190,946 Y
-32-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
AERIAL PHOTOGRAPHY
Project period February 1, 2015 through December 31, 2015
VARIOUS MUNICIPALITIES -Cash (312)
Feb. 1, 2015
through
Sept. 30, 2015
REVENUES
Local
Cash received $ 169,266
Unearned revenue- current year (106,998)
TOTAL REVENUES $ 62,268
EXPENDITURES
Pass-through $ 62,268
i
i
I'
- 33-
II
f
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
FHWA PL FUNDS f
Project period October 1, 2014 through September 30, 2015
FHWA CONTRACT NO. PL 2015-0011/Z1 (32100)
FHWA-$480,181 Cash j
TCRPC - $106,479 Cash
REVENUES
Federal grant
Cash $ 179,747
Accounts receivable 137,545
TOTAL REVENUES 317,292
OTHER FINANCING SOURCES
Operating transfers in
Local match 70,375
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 387,667
EXPENDITURES
Direct costs
Salaries $ 146,928
Fringe benefits 81,916
Postage 104
Printing and copying 5,818
Office supplies 224
Travel -in region 2,740
Travel -out region 3,870
Training 565
Computer services 324
Computer software 7,376
Publications 18
Advertising 1,037
Membership dues 1,276
Special projects 12,806
Consultants 3,784
Contractual services 1,455
Indirect costs 117,426
TOTAL EXPENDITURES $ 387,667
34
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MDOT GRANT:ASSET MANAGEMENT
Project period October 1, 2014 through September 30, 2015
MDOT CONTRACT NO. 2015-0022/Z1 (32300)
MDOT-$33,786 Cash
REVENUES
State of Michigan
Cash $ 2,399
Accounts receivable 31,247
TOTAL REVENUES $ 33,646
EXPENDITURES
Direct costs
Salaries $ 11,020
Fringe benefits 6,144
Office supplies 1,988
Travel - in region 140
Travel - out region 30
Special projects 817
Pass-through 4,512
Indirect costs 8,995
TOTAL EXPENDITURES $ 33,646
-35 -
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
REGIONAL TRANSPORTATION CONTRACT
Project period October 1, 2014 through September 30, 2015
MDOT CONTRACT NO. 2015-0022/Z2 (32400)
MDOT-$40,100 Cash
REVENUES
State of Michigan
Cash $ 19,934
Accounts receivable 20,166
TOTAL REVENUES $ 40,100
EXPENDITURES
Direct costs
Salaries $ 14,225
Fringe benefits 7,931
Postage 16
Printing and copying 202
Office Supplies 37
Travel-in region 459
Travel-out region 651
Training 95
Computer services 62
Computer software 903
Publications 3 -
Advertising 24
Membership dues 215
Special projects 2,640
Consultants 780
Contractual services 300
Indirect costs 11,557
TOTAL EXPENDITURES $ 40,100
36
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
SURFACE TRANSPORTATION PROGRAM GRANT
Project period October 1, 2014 through September 30, 2015
' FHWA CONTRACT NO. 2015-001113 and 2015-0011/Z4 (32800)
FHWA-$273,968 Cash
TCRPC-$82,274 Cash
REVENUES
Federal grant
Cash received $ 23,976
Accounts receivable 49,586
TOTAL REVENUES 73,562
OTHER FINANCING SOURCES
Operating transfers in
Local match 31,020
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 104,582
EXPENDITURES
Direct costs
Consultants $ 104,582
i
-37-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
FEDERAL TRANSIT ADMINISTRATION -SECTION 5303 FUNDS
Project period October 1, 2014 through September 30, 2015
FTA CONTRACT NO. PL 2015-0011/Z2 (33000)
FTA-$219,711 Cash
TCRPC-$54,928 Cash
REVENUES
Federal grant
Cash $ 126,304
Accounts receivable 43,697
TOTAL REVENUES 170,001
OTHER FINANCING SOURCES
Operating transfers in
Local match 42,488
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 212,489
EXPENDITURES
Direct costs
Salaries $ 81,438
Fringe benefits 45,403
Postage 53
Printing and copying 2,847
Office supplies 115
Travel -in region 1,410
Travel -out region 1,990
Training 290
Computer services 167
Computer software 3,811 r
Publications 9 BI
Advertising 506
Membership dues 656
Special projects 6,554
Consultants 1,936
Contractual services 745
Indirect costs 64,559
TOTAL EXPENDITURES $ 212,489
-38-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
STATEWIDE PLANNING AND RESEARCH
Project period October 1, 2014 through September 30, 2015
MDOT CONTRACT NO. 2015-0022/Z3 (34000)
FHWA-$15,200 Cash
MDOT- $3,800 Cash
REVENUES
Federal grant
Cash received $ 8,111
Accounts receivable 7,089
State of Michigan
Cash received 2,028
Accounts receivable 1,772
TOTAL REVENUES $ 19,000
EXPENDITURES
Direct costs
Salaries $ 8,122
Fringe benefits 4,529
Postage 15
Printing and copying 53
Travel - in region 242
Publications 3
Indirect costs 6,036
TOTAL EXPENDITURES $ 19,000
i
- 39-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) 1
ASSISTANCE TO: MDOT OFFICE OF PASSENGER TRANSPORTATION i
Project period October 1, 2014 through September 30, 2015
MDOT CONTRACT NO. 2012-0013/Z6 (34500)
MDOT- $5,000 Cash
REVENUES
State of Michigan
Cash received $ 5,000
EXPENDITURES
Direct costs
Salaries $ 2,187
Fringe benefits 1,220
Printing and copying 5
Indirect costs 1,588
TOTAL EXPENDITURES $ 51000
1
I
l
t ,
-40-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
HUD SUSTAINABLE COMMUNITIES REGIONAL PLANNING GRANT PROGRAM
Project period February 1, 2012 through April 30, 2015
HUD COOPERATIVE AGREEMENT NO. MIRIP0056-11 (35000)
HUD-$3,000,000
Feb. 1, 2012 Oct. 1, 2014 Feb. 1, 2012
through through through
Sept. 30, 2014 April 30, 2015 April 30, 2015
REVENUES
Federal grant
Cash received -current year $ - $ 313,758 $ 313,758
Cash received - prior year 2,079,612 418,371 2,497,983
Accounts receivable -prior year 606,630 (418,371) 188,259
TOTAL REVENUES $ 2,686,242 $ 313,758 $ 3,000,000
EXPENDITURES
Direct costs
Salaries $ 161,163 $ 55,658 $ 216,821
Fringe benefits 85,236 31,030 116,266
Telephone 110 - 110
Postage 2,088 525 2,613
Printing and copying 3,311 588 3,899
Office supplies 3,933 985 4,918
Graphic supplies 718 98 816
Travel - in region 9,712 953 10,665
Travel -out region 9,381 2,387 11,768
Training 845 - 845
Rent of facility/equipment 3,209 - 3,209
Computer services 824 - 824
Subscriptions/publications 161 - 161
Advertising 241 - 241
Membership dues 553 90 643
Special projects 98,801 17,929 116,730
Pass-through 2,171,190 160,538 2,331,728
Indirect costs 134,766 42,977 177,743
TOTAL EXPENDITURES $ 2,686,242 $ 313,758 $ 3,000,000
I
-41 -
Tri-County Regional Planning Commission
ANALYSIS OF COMPLETED PROJECTS (UNAUDITED)
Year Ended September 30, 2015
GREATER
LANSING GROUNDWATER MID-
REGIONAL MANAGEMENT MICHIGAN
COMMITTEE BOARD (GMB) WATER
WELLHEAD 2015 (GLRC)2014 2014 AUTHORITY
(30500) (30300) (30400) 2014(30700)
i
Total expenditures $ 47,399 $ 88,419 $ 92,214 $ 3,706
Less: locally funded
expenditures 47,399 88,419 92,214 3,706
Allowable expenditures -0- -0- -0- -0-
Grantor participation 0% 0% 0% 0%
Grant revenues - - - - @g
Grant receipts - - - - t
Due from grantor $ -0- $ -0- $ -0- $ -0-
II
1 '
-42-
REGIONAL MDOT GRANT: REGIONAL
MSU WATER PROSPERITY FHWA PL ASSET TRANSPORTATION
RESEARCH GRANT2014 FUNDS MANAGEMENT CONTRACT
(31100) (31310) (32100) (32300) (32400)
i
$ 53,748 $ 155,300 $ 387,667 $ 33,646 $ 40,100
53,748 155,300 70,375
-0- -0- 317,292 33,646 40,100
0% 0% 82% 100% 100%
- - 317,292 33,646 40,100
- - 179,747 2,399 19,934
$ -0- $ -0- $ 137,545 $ 31,247 $ 20,166
I
I
-43-
Tri-County Regional Planning Commission
ANALYSIS OF COMPLETED PROJECTS (UNAUDITED) -CONTINUED
Year Ended September 30, 2015
ASSISTANCE
SURFACE TO: MDOT
TRANSPORATION FTA GRANT STATE OFFICE OF
PROGRAM SECTION 5303 PLANNING AND PASSENGER
GRANT FUNDS RESEARCH TRANSIT
(32800) (33000) (34000) (34500)
Total expenditures $ 104,582 $ 212,489 $ 19,000 $ 5,000
Less: locally funded
expenditures 31,020 42,488
Allowable expenditures 73,562 170,001 19,000 5,000
Grantor participation 70% 80% 100% 100%
Grant revenues 73,562 170,001 19,000 5,000
Grant receipts 23,976 126,304 10,139 5,000
Due from grantor $ 49,586 $ 43,697 $ 8,861 $ -0-
1 i
I i
44
i
HOUSING AND
URBAN
DEVELOPMENT
(35000)
$ 3,000,000
3,000,000
100%
3,000,000
2,811,741
$ 188,259
_45_
[
Tri-County Regional Planning Commission
ANALYSIS OF LOCAL MATCH (UNAUDITED)
Year Ended September 30, 2015
Commission
EDA Planning Grant(31400) $ 58,429
FHWA PL Funds (32100) 70,375 6
STP (32800) 31,020 l
FTA(33000) 42,488
[
$ 202,312
[ _ I
[
i
[ I
[
I
i
C
-46-
Tri-County Regional Planning Commission
ANALYSIS OF INDIRECT COST RATE (UNAUDITED)
Year Ended September 30, 2015
Indirect Base Indirect Base
Total expenditures $ - $ 2,035,242
Direct expenditures 1,599,416 (1,599,416)
Less:
Discretionary funds (4,936)
Special projects (67,674)
Consultant fee (123,082) -
Contractual services (2,500) -
Furniturelequipment purchases (14,774) -
Pass-through (247,968) -
Match (202,312)
i
$ 936,170 $ 435,826
Indirect cost rate (indirect costs as a part of indirect base) 46.55%
' I
-47-
i
i
i
it
I
I
R �
� _
III
� ,
1 '.
I
I
� :
l
� ,
f
Tri-County Regional Planning Commission
SCHEDULE OF FRINGE BENEFITS (UNAUDITED)
Year Ended September 30, 2015
Social security $ 54,455
Unemployment taxes 4,916
Pension contributions 68,643
Health insurance 242,177
Dental insurance 19,688
Group life insurance 7,694
Employee assistance program 342
Workers compensation insurance 3,134
Fringe benefits miscellaneous 1,093
Total fringe benefits $ 402,142
Salaries and wages for the year ended September 30, 2015 $ 721,306
Fringe benefit rate -All employees 55.75%
i
-48-
t
Tri-County Regional Planning Commission
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED)
REGIONAL TRANSPORTATION
Year Ended September 30, 2015
FHWA PL 2015-0011/Z1 (32100)
VARIANCE f
FAVORABLE t
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 218,604 $ 151,712 $ 66,892
II LONG RANGE PLANNING 231,624 151,180 80,444
III SHORT RANGE PLANNING 9,683 2,300 7,383
IV PROGRAM MANAGEMENT AND
COORDINATION 92,204 69,310 22,894
V TRANSPORTATION PROGRAMMING
ACTIVITIES 34,546 13,165 21,381
VI OTHER RELATED ACTIVITIES - - -0-
GRAND TOTALS $ 586,661 $ 387,667 $ 198,994
l
G ,
49
li
FTA PL 2015-0011/Z2 (33000) MDOT#2015-0022/Z2 (32400)
VARIANCE VARIANCE
FAVORABLE FAVORABLE
BUDGET EXPENDED (UNFAVORABLE) BUDGET EXPENDED (UNFAVORABLE)
$ 89,295 $ 69,703 $ 19,592 $ 5,000 $ 6,489 $ (1,489)
97,885 68,704 29,181 19,000 16,954 2,046
3,483 1,033 2,450 500 148 352
44,744 35 678 9 066 10 0, ,0 0 11,300 (1,300)
16,764 9,487 7,277 4,600 4,022 578
22,469 27,884 (5,415) 1,000 1,187 (187)
$ 274,640 $ 212,489 $ 62,151 $ 40,100 $ 40,100 $ -0-
- 50 -
Tri-County Regional Planning Commission k
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED)-CONTINUED
REGIONAL TRANSPORTATION i
Year Ended September 30, 2015
i
i
MDOT#2015-0022/Z1 (32300)
VARIANCE
FAVORABLE
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 33,767 $ 33,646 $ 121
II LONG RANGE PLANNING - - -0- E!
III SHORT RANGE PLANNING - - -0-
IV PROGRAM MANAGEMENT AND
COORDINATION - - -0-
V TRANSPORTATION PROGRAMMING E
ACTIVITIES - - -0-
VI OTHER RELATED ACTIVITIES - - -0-
GRAND TOTALS $ 33,767 $ 33,646 $ 121
III
illl
1 . II
III
� , II
51
FHWA-STP#2015-0011/Z3
FHWA-STP#2015-0011/Z4(32800) FHWA-SP&R#2015-0022/Z3 (34000)
` 1 VARIANCE VARIANCE
FAVORABLE FAVORABLE
BUDGET EXPENDED (UNFAVORABLE) BUDGET EXPENDED (UNFAVORABLE)
$ 274,639 $ 104,582 $ 170,057 $ $ $ -0-
- - -0- 6,000 6,000
-0- -0-
-0- 6,000 5,436 564
-0- 7,000 13,564 (6,564)
-0- -0-
$ 274,639 $ 104,582 $ 170,057 $ 19,000 $ 19,000 $ -0-
i
i
I
-52-
Tri-County Regional Planning Commission
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED) - CONTINUED i
REGIONAL TRANSPORTATION I
Year Ended September 30, 2015
TOTAL [
VARIANCE
FAVORABLE
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 621,305 $ 366,132 $ 255,173
11 LONG RANGE PLANNING 354,509 236,838 117,671
III SHORT RANGE PLANNING 13,666 3,481 10,185 ,
IV PROGRAM MANAGEMENT AND
COORDINATION 152,948 121,724 31,224
V TRANSPORTATION PROGRAMMING
ACTIVITIES 62,910 40,238 22,672
VI OTHER RELATED ACTIVITIES 23,469 29,071 (5,602)
GRAND TOTALS $ 1,228,807 $ 797,484 $ 431,323
III
II
III!
-53-
�I
Tri-County Regional Planning Commission
Lansing, Michigan
SUPPLEMENTARY INFORMATION
TO FINANCIAL STATEMENTS
(FEDERAL AWARDS)
September 30, 2015
I,
� I'�
� �
� �'
� ''�
� '
� '�
f
� . !,
� ,
� ,
�.
Tri-County Regional Planning Commission
TABLE OF CONTENTS
September 30, 2015
Page
INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE FOR EACH
MAJOR FEDERAL PROGRAM AND ON INTERNAL CONTROL OVER
COMPLIANCE REQUIRED BY OMB CIRCULAR A-133 1-2
SUPPLEMENTARY INFORMATION
Schedule of Expenditures of Federal Awards 3
Notes to Schedule of Expenditures of Federal Awards 4
INDEPENDENT AUDITOR'S REPORT ON INTERNAL CONTROL OVER FINANCIAL
REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN
AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH
GOVERNMENTAUDITING STANDARDS 5-6
SCHEDULE OF FINDINGS AND QUESTIONED COSTS 7
SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS g
i
� i
III
III
I,
��I
I,
E
� I''i
� I�
� '
[ I'�
� , �'�
� � ��
Principals ~ 3511 Coolidge Road
�e
Suite 100
Dale J.Abraham, CPA East Lansing, MI 48823
Michael T. Gaffney, CPA (517) 351-6836
Steven R. Kirinovic, CPA ABRAHAM &GAFFNEY, P.C. FAX: (517( 351-6837
Aaron M. Stevens, CPA Eric J. Glashouwer, CPA Certified Public Accountants
Alan D. Panter, CPA
William 1.Tucker IV, CPA
INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM
AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY OMB CIRCULAR A-133
i
it
To the Board of Commissioners
Tri-County Regional Planning Commission
Lansing, Michigan
i
Report on Compliance for Each Major Federal Program
We have audited Tri-County Regional Planning Commission's (the Commission) compliance with the types of
compliance requirements described in the OMB CircularA-133 Compliance Supplement that could have a direct
and material effect on the Commission's major federal programs for the year ended September 30, 2015. The
Commission's major federal programs are identified in the summary of auditor's results section of the
accompanying schedule of findings and questioned costs.
Management's Responsibility
I
Management is responsible for compliance with the requirements of laws, regulations, contracts, and grants
applicable to its federal programs.
Auditor's Responsibility
Our responsibility is to express an opinion on compliance for the Commission's major federal programs based on
our audit of the types of compliance requirements referred to above. We conducted our audit of compliance in
accordance with auditing standards generally accepted in the United States of America; the standards applicable
to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United
States; and OMB Circular A-133, Audits of States, Local Governments, and Nonprofit Organizations. Those
standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance
about whether noncompliance with the types of compliance requirements referred to above that could have a
direct and material effect on a major federal program occurred. An audit includes examining, on a test basis,
evidence about the Commission's compliance with those requirements and performing such other procedures as
we considered necessary in the circumstances.
We believe that our audit provides a reasonable basis for our opinion on compliance for each major federal
program. However, our audit does not provide a legal determination on the Commission's compliance.
Opinion on Each Major Federal Program
In our opinion, Tri-County Regional Planning Commission complied, in all material respects, with the types of
compliance requirements referred to above that could have a direct and material effect on each of its major federal
programs for the year ended September 30, 2015.
Auburn Hills• East Lansing • Grand Rapids-St.Johns
- 1 -
�'�
I��
� �',
I!
�I
III
I . II
E
� . 'I
� . ��''
l ��
� :
� .
Report on Internal Control Over Compliance
Management of the Commission is responsible for establishing and maintaining effective internal control over
compliance with the types of compliance requirements referred to above. In planning and performing our audit of
compliance, we considered the Commission's internal control over compliance with the types of requirements that
could have a direct and material effect on the major federal program to determine the auditing procedures that are
appropriate in the circumstances for the purpose of expressing an opinion on compliance for the major federal
program and to test and report on internal control over compliance in accordance with OMB Circular A-133, but not
for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we
do not express an opinion on the effectiveness of the Commission's internal control over compliance.
A deficiency in internal control over compliance exists when the design or operation of a control over compliance
does not allow management or employees, in the normal course of performing their assigned functions,to prevent,
or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely
basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in
internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type
of compliance requirement of a federal program will not be prevented, or detected and corrected on a timely basis.
A significant deficiency in internal control over compliance is a deficiency, or a combination of deficiencies, in
internal control over compliance with a type of compliance requirement of a federal program that is less severe
than a material weakness in internal control over compliance, yet important enough to merit attention by those
charged with governance.
Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of
! this section and was not designed to identify all deficiencies in internal control over compliance that might be
material weaknesses or significant deficiencies. We did not identify any deficiencies in internal control over
compliance that we consider to be material weaknesses. However, material weaknesses may exist that have not
been identified.
Report on Schedule of Expenditures of Federal Awards Required by OMB Circular A-133
We have audited the financial statements of the governmental activities and the major fund of the Commission
as of and for the year ended September 30, 2015, and the related notes to the financial statements, which
collectively comprise the Commission's basic financial statements. We issued our report thereon dated
November 30, 2015, which contained unmodified opinions on those financial statements. Our audit was
conducted for the purpose of forming opinions on the financial statements that collectively comprise the basic
financial statements. The accompanying schedule of expenditures of federal awards is presented for the
purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the basic
financial statements. Such information is the responsibility of management and was derived from and relates
directly to the underlying accounting and other records used to prepare the basic financial statements. The
information has been subjected to the auditing procedures applied in the audit of the financial statements and
certain additional procedures, including comparing and reconciling such information directly to the underlying
accounting and other records used to prepare the basic financial statements or to the basic financial statements
themselves, and other additional procedures in accordance with auditing standards generally accepted in the
United States of America. In our opinion, the schedule of expenditures of federal awards is fairly stated in all
material respects in relation to the basic financial statements as a whole.
The purpose of this report on internal control over compliance is solely to describe the scope of our testing of
internal control over compliance and the results of that testing based on the requirements of OMB Circular A-133.
Accordingly, this report is not suitable for any other purpose.
ABRAHAM &GAFFNEY, P.C.
Certified Public Accountants
November 30, 2015
-2 -
� � ��
� I
� ��
III
� '
[ I
� I'
� I
� '
�.
III
� .
� ,
' I
d N 0 0)OD 0 r 0 LO 7
tt O N (O 00 N O N
OIO Cq � (O'O U)
W
C (`M M LO T wN V
V 60
W N
T m L7 0 O
O CU 0 n
O O (M W N
E p O n
N .c X NI N
d W 603 G3
LO 0
0) 0 0 o La
r � r NN O ��-
M 6) O d1 0 N (O O) W
3 0 m 0 NODM00 rn N
o Q Q M d
I � �
c Q L
(0 rn ` co
rn .- � TNNN
E W L ° a 0 00000
E ❑ N F E m O 0 0 0 0 0
O W N i b co Ln LO N (n LN
�) LL O N U Z
M O O O O O O
Ol O d O g N N N N N
C W w E
m E
Cd O. Q N N Cl) LO M
o O~ (n ❑LL E r0 0 CD
i NN
a o
N W "00 U Z N
K a c
T X W
c W N
0 LL a
UO } V
W n0 Z
F QO
w o 0
K 2CL
w
(n Z_U Z m Cl)W
O N 2 Z o
IL
° a) w 0 O m O � � Q
•(a w o ~ E } U)
CD
a7 m m ❑ w CL
(~ a) 2 Q
o a U m 0) o,-o J QQ
O LL o E a. r m o K
z > a z o Q g 0 W W
W a) o Q U �, = to c o
W LL LL
❑LLI d
as
a Z � � 0 (7 oa a)
Q3Ea n3c = hminQQQQ H H
(LQ 0 0 D Q 'm c - a 3 Q O O
W c � O W@ O L 2 2 2 S
❑ (D 0 (n a: a) d W N =LLLL LL LL LL
(np lAp 0
7 7 LL
�_
� ��
� I
� 'i
� !�
[ ''
� �
� '��
( �''
� .
f .
� .
Tri-County Regional Planning Commission
NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS
Year Ended September 30, 2015
NOTE A: BASIS OF PRESENTATION
The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of the
Commission and is presented on the modified accrual basis of accounting. The information in this schedule is
presented in accordance with the requirements of OMB Circular A-133, Audits of States, Local Governments, and
Nonprofit Organizations.
NOTE B: SUMMARY OF SIGNIFICANT EXPLANATIONS OF SCHEDULE
The following descriptions identified below as (a) through (d) represent explanations that cross reference to
amounts on the Schedule of Expenditures of Federal Awards.
(a) The expenditures reported in this schedule are in agreement with the amounts reported in the financial
statements and financial reports. The financial reports tested, including claims for advances and
reimbursements, were materially correct, complete, accurate, and timely and contain information that is
supported by the books and records from which the financial statements have been prepared.
(b) Denotes program tested as"major program".
(c) Agrees to total revenues from Federal sources per financial statements.
(d) Of the federal expenditures presented in the schedule, the Commission provided federal awards to
subrecipients as follows:
i
Federal Grantor/ Pass-Through Grantor/ CFDA Current Year
Program Title and Subrecipient Number Expenditures
U.S. HOUSING AND URBAN DEVELOPMENT
Direct Award
Sustainable Communities Regional 14.703
Planning Grant Program
Greater Lansing Housing Coalition $ 14,340
Meridian Township 4,000
Michigan Energy Options 28,407
Michigan Fitness Foundation 15,661
Michigan State University 51,916
Mid-Michigan Environmental Action Council 13,274
NorthWest Initiative 4,515
Refugee Development Center 3,000
The Fenner Conservancy 4,000
Arts Council of Greater Lansing 2,500
Greater Lansing Food Bank 3,700
EagleVision Ministries 4,000
Greater Lansing Destination Development Foundation 1,200
Friends of East Lansing Schools 4,000
Westside Commercial Association 4,981
Michigan Recycling Coalition 5,000
Southside Community Center 1,000
TOTAL U.S. HOUSING AND URBAN DEVELOPMENT $ 165,494
4
�, i
� , '
� '
0
� '
� :
� �
� �'��
� !�
� '',