HomeMy WebLinkAboutTRI - County Audit FY2014 y�N S I V
Chris Swope
Lansing City Clerk
CHtCk�
January 9, 2015
President and Councilmembers
10th Floor City Hall
Lansing, MI 48933
Dear President and Councilmembers:
My office has received and placed on file:
Tri-County Regional Planning Commission Fiscal Year 2014 Audit Reports
This document is available for review at the office of the City Clerk or at
http://www.lansingmi.gov/clerk under the heading of Documents Placed on File.
Sincerely,
Ci"Al
Chris Swope, CIVIC
Lansing City Clerk
Lansing City Clerk's Office
Ninth Floor, City Hall, 124 W. Michigan Ave., Lansing, MI 48933-1695
517-483-4131 • TDD 517-483-4479. 517-377-0068 FAX
www.lansingmi.gov/clerk • clerk@lansingmi.gov
i
i
II
III
TRI-COUNTY REGIONAL PLANNING COMMISSION
Planning for People in the Greater Lansing Region Since 1956
2014 OFFICERS January 6, 2015
CHAIRPERSON
Brian McGraln,Ingham County _
Mr. Chris Swope
VICE-CHAIRPERSON City Clerk, City of Lansing . .
David Pohl,Clinton County City Hall
TREASURER 124 W. Michigan
Kenneth Fletcher,Eaton County Lansing, MI 48933
SECRETARY
Ralph Monsma,CATA
TRI-COUNTY COMMISSIONERS Dear Mr. Swope:
Daryl Baker Russel Bauerle In accordance with our Bylaws, we are submitting the audit report
Judi Brown Clarke for the fiscal year 2014 for the Tri-County Regional Planning
Roger Eakin Commission.
Kenneth Fletcher
Dianne Holman If you have any questions, please feel free to contact us.
Kara Hope
Denise Jackson
Dorothy Maxwell Sincerely,
Brian McGrain
Ralph Monsma
Jim Osieczonek
David Pohl reg Hoffman - '
Shirley M.Rodgers Adam Stacey Finance Director
-
Nathan Triplett '..
John Veenstra f'^
Carol Wood 1>
Jessica Yorko yr
Encl. C1
EX-OFFICIO
City of Lansing Mayor
Clinton,Eaton and Ingham
County Chairpersons AUDIT LTR 2014
r
EXECUTIVE DIRECTOR ( ( (
Susan M.C.Pigg,CEcD 1TI R1
3135 Pine Tree Road,Suite 2C
Lansing,MI 48911
(517)393-0342•Fax:393-4424
www.mitcroc.ora
receotion gDmitcrnc.orR
TCRPC is an Equal Opportunity Employer
I
I
Tri-County Regional Planning Commission
Lansing, Michigan
FINANCIAL STATEMENTS
September 30, 2014
[ �
f-
�,
II
I;
C ,i
�I
I i
I .
� .
� _
1 . ''
t .
l I
� : '
p
f .
� ;
� :
Tri-County Regional Planning Commission
TABLE OF CONTENTS
September 30, 2014
Paqe
INDEPENDENT AUDITOR'S REPORT i-ii
MANAGEMENT'S DISCUSSION AND ANALYSIS iii-v
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
I
OTHER SUPPLEMENTARY INFORMATION
Schedule of Commission Revenues and Expenditures (Unaudited) 17
Combining Schedule of Project Revenues and Expenditures (Unaudited) 18-22
Schedule of Project Revenues and Expenditures (Unaudited) 23-41
Analysis of Completed Projects (Unaudited) 42-44
Analysis of Local Match and Indirect Charges (Unaudited) 45
Analysis of Indirect Cost Rate (Unaudited) 46
Schedule of Fringe Benefits(Unaudited) 47
Transportation Summary of Expenditures(Unaudited) 48-52
i
� � II
( I
[ '�
I �,'I
9
6
[.
( �
fi,',
6 'I,
CI,
f . II
. [� II'I
� [
� ,
Principals 3511 Coolidge Road
Suite 100
Date.). East Lansing, M 148823
Abraham, CPA
Michael T.Gaffney, CPA v= )5 t 7) 3S 1-6836
Steven R. Kirinovic, CPA ABRAHAM &GAFIFN EY, P.C. FAX: )517) 351-6837
Aaron M.Stevens, CPA Certified Public Accountants
Eric J.Glashouwer, CPA
Alan D. Panter, CPA
William 1. Tucker IV, CPA
INDEPENDENT AUDITOR'S REPORT
To the Board of Commissioners
Tri-County Regional Planning Commission
Lansing, Michigan
i
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, 2014, 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.
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, 2014,
and the respective changes in financial position for the year ended in accordance with accounting principles
generally accepted in the United States of America.
East Lansing-Auburn Hills•St.Johns
- I -
[�
[ �
C �
'�
[ ',
I �'�
I �I
I !
C ,',
f �'I
6 '�
[ � �',
f '�
I '�
i �
i
� :
! � ''
� :
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 December 12, 2014,
on our consideration of the Commission's internal control over financial reporting and on our tests 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
December 12, 2014
i
_ ii _
i
� '
��
{ �
� ��
CI
f '�
l ��
�-
� ,
� !,
r .
� .
r
� � ��
i
� , �
r .
��
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2014
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, 2014. Please read it in conjunction with the attached financial statements.
Financial Highlights
Our FY 2014 financial status improved from the prior year. Net position increased by $58,538 compared to 2013
increases of $37,646 and 2012 increases of $34,180. Total Net Position is now $557,893 of which $35,033
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.
Table 1
Summarized Statements of Net Position
Governmental Activities
Fiscal Year Fiscal Year Fiscal Year
2014 2013 2012
Current Assets $ 992,206 $ 782,104 $ 730,118
Capital Assets, net 35,033 28,337 30,565
Total Assets 1,027,239 810,441 760,683
Current Liabilities 469,346 311,086 301,726
Net investment in Capital Assets 35,033 28,337 30,565
Unrestricted 522,860 471,018 428,392
Total Net Position $ 557,893 $ 499,355 $ 458,957
Table 2
Changes in Net Position
Governmental Activities
2014 2013 2012
Net position, October 1 $ 499,355 $ 458,957 $ 424,777
Results of operations 58,154 37,646 34,180
Prior period adjustments 384 2,752 -
Total changes in net position 58,538 40,398 34,180
Net position, September 30 $ 557,893 $ 499,355 $ 458,957
For 2014, 2013 and 2012 overall revenues were $2,902,843, $2,500,938, and $1,819,048 respectively and overall
expenses were$2,844,689,$2,463,292, and$1,784,868 respectively, as reported in the statements of activities.
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
f�
Year Ended September 30, 2014
Table 3
Summarized Statements of Activity
Governmental Activities f
Fiscal Year Fiscal Year Fiscal Year l
2014 2013 2012
Revenues
Federal, state and local funding $ 2,524,350 $ 2,114,636 $ 1,447,625
Local dues 377,850 377,850 370,440 f
Interest 643 462 708 l
Miscellaneous - 7,990 275
Total Revenues 2,902,843 2,500,938 1,819,048
Expenses 2,844,689 2,463,292 1,784,868 f
Change in Net Position $ 58,154 $ 37,646 $ 34,180 l
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 first two 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 f
The government wide statements report information about the Commission as a whole, using accounting I
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.
- iv- t '
Tri-County Regional Planning Commission
MANAGEMENT'S DISCUSSION AND ANALYSIS
Year Ended September 30, 2014
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, 2014 by$58,154.
Total unrestricted net position was $522,860 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 $158,260. This was due to increases in accounts payable
and deferred revenues.
Financial Analysis of the Commission's Fund
Amendments to our budget for the year ended September 30, 2014, were to add projects and cover changes in
certain operational expenditures.
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.
-v-
i '
I
I
1 I
l
I� �I'�
I
� . I
i
� �
f
� '
_ �I
� ,
'I
� :
. II
� :
''
i
BASIC FINANCIAL STATEMENTS
i
Tri-County Regional Planning Commission l
STATEMENT OF NET POSITION
September 30, 2014
ASSETS
Current assets
Cash and cash equivalents $ 436,230
Due from other governmental units 518,035
Prepaid expenses 37,941
Total current assets 992,206
Noncurrent assets
Capital assets, net 35,033 !�
TOTAL ASSETS 1,027,239
LIABILITIES
Current liabilities
Accounts payable 213,141
Accrued wages and related items 36,507 f
Compensated absences 32,920
Unearned revenue 186,778
Total current liabilities 469,346 I "
NET POSITION
Investment in capital assets 35,033
Unrestricted 522,860
TOTAL NET POSITION $ 557,893
� . I
See accompanying notes to financial statements.
- 1 -
i
Tri-County Regional Planning Commission
STATEMENT OF ACTIVITIES
Year Ended September 30, 2014
Net(Expense)
Operating Revenue and
Grants and Changes in
Functions/Programs Expenses Contributions Net Position
Governmental activities
Planning programs $ 2,844,689 $ 2,524,350 $ (320,339)
General revenues
Member allocations 377,850
Investment earnings 643
Total general revenues 378,493
_ Change in net position 58,154
Restated net position,
beginning of the year 499,739
Net position, end of the year $ 557,893
See accompanying notes to financial statements.
-2-
i
Tri-County Regional Planning Commission
Governmental Fund f
BALANCE SHEET I '
September 30, 2014
General f
ASSETS I
Cash $ 436,230
Due from other governmental units 518,035
Prepaids 37,941
TOTAL ASSETS $ 992,206
LIABILITIES
Accounts payable $ 213,141
Accrued wages and related items 69,427
Unearned revenue 186,778
TOTAL LIABILITIES 469,346
FUND BALANCE
Nonspendable- prepaids 37,941
Unassigned 484,919
TOTAL FUND BALANCE 522,860
TOTAL LIABILITIES AND FUND BALANCE $ 992,206 - L,
Ii
I I'
: III
1 II
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, 2014
Total fund balance -governmental fund $ 522,860
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 (156,022)
Capital assets, net 35,033
Net position of governmental activities $ 557,893
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, 2014
[
General
REVENUES [
Federal sources $ 2,101,879
State sources 58,117 [
Local sources 364,354
Member allocations 377,850
Interest 643
TOTAL REVENUES 2,902,843
EXPENDITURES [
Current
Community and Economic Development 2,851,385
NET CHANGE IN FUND BALANCE 51,458 [
Fund balance, beginning of year 471,018
Prior period adjustment 384
Fund balance, end of year $ 522,860
[
[
[
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, 2014
Net change in fund balance -governmental fund $ 51,458
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:
Capital outlay $ 15,070
Depreciation expense (8,374)
Excess of capital outlay over depreciation expense 6,696
Change in net position of governmental activities $ 58,154
i
i
See accompanying notes to financial statements.
6
Tri-County Regional Planning Commission 1
NOTES TO FINANCIAL STATEMENTS f
September 30, 2014
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,
under the 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. f
1. Reporting Entity
All funds (primary government) under direct control of Tri-County Regional Planning Commission are included in P
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 t
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. r(
FUND FINANCIAL STATEMENTS L
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
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, 2014
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.
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 which include furniture and equipment, are re reported in the governmental pp e g ernmental activities column in the
government-wide financial statements. Capital assets are defined by Tri-County Regional Planning Commission
as assets with an initial, individual cost of$100 or more and an estimated useful life in excess of one year.
All capital assets are valued at historical cost or estimated historical cost if actual cost is not available. Donated
capital assets are recorded at estimated fair market value on the date of donation.
The cost of normal maintenance and repairs that do not add to the value of the assets or materially extend
assets lives are not capitalized.
Capital assets are depreciated using the straight-line method over estimated useful lives of three (3)to ten (10)
years.
7. Cash
Cash consists of the Commission's checking and savings accounts.
-8 -
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2014
NOTE A: DESCRIPTION OF ORGANIZATION AND SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES f
-CONTINUED
8. Indirect Cost Allocations
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 li
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 r
be recognized as an outflow of resources (expense/expenditure)until that time. L
In addition to liabilities,the statement of net position and the balance sheet, when applicable,will report a separate r
section for deferred inflows of resources. This separate financial statement element, deferred inflows of resources, IE
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. 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.
I .
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 l
member of the Federal Deposit Insurance Corporation (FDIC) or a savings and loan association which is a l
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 I
not less than two (2) standard rating services and which matures not more than 270 days after the date of l
purchase.
9
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2014
NOTE B: CASH -CONTINUED
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, 2014, the carrying
amounts and bank balances for the accounts were as follows:
Carrying Bank
Account Type Amount Balance
Checking $ 18,740 $ 74,119
Savings 417,340 417,340
$ 436,080 $ 491,459
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, 2014, were insured by the
FDIC for $447,268 and the amount of $44,191 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, 2014, the Commission did not have
any investments that would be subject to rating.
Interest rate risk
The Commission has not adopted a policy that addresses interest rate risk, which is the risk that the market
value of securities in the portfolio will fall due to changes in market interest rates.
Concentration of credit risk
The Commission has not adopted a policy that addresses concentration of credit risk, which is the risk of loss
attributed to the magnitude of the Commission's investment in a single issuer.
Custodial credit risk
The Commission has not adopted a policy that indicates how 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.
10
i
Tri-County Regional Planning Commission
I
NOTES TO FINANCIAL STATEMENTS
September 30, 2014 �l
I
NOTE C: DUE FROM OTHER GOVERNMENTAL UNITS
Due from/to other governmental units at September 30, 2014, by grant type are as follows:
Federal
FHWA PL Funds 2012-0011/Z8 $ 103,258 ,
FTA Section 5303 Funds 2012-0011/Z7 34,691
Surface Transportation Program 2012-0011/Z9 and 2012-0011/Z10 49,113
HUD Sustainable Communities Regional Planning MIRIP 0056-011 188,259
Michigan Department of Transportation fr
Asset Management 2012-0022/Z7 5,396 I
Regional Transportation Contract 2012-0022/Z6 21,457
State Planning and Research MDOT/FHWA 2012-001629 5,457
Michigan Department of Environmental Quality
Synergy 7,605
Other Local Units
Lansing Board of Water and Light 8,530
East Lansing/Meridian Charter Township 65,628
Ingham County 400
MSU Water Research - Management Plan for Red Cedar 6,745
Mid Michigan Environmental Action Council 13,106
Village of Webberville 5,000
DeWitt Township Permit Assistance 1,755
Mid-Michigan Water Authority 1,635
$ 518,035
NOTED: CAPITAL ASSETS
Capital asset activity for the year ended September 30, 2014,was as follows: -
Balance Balance
Oct. 1, 2013 Additions Disposals Sept. 30, 2014
Capital assets being depreciated
Furniture and equipment $ 185,397 $ 15,070 $ (9,412) $ 191,055
Less accumulated depreciation for:
.Furniture and equipment (157,060) (8,374) 9,412 (156,022)
Net capital assets $ 28,337 $ 6,696 $ -0- $ 35,033 -
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2014
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, 2014.
Amount
Balance Balance Due Within
Oct. 1, 2013 Earned Used Sept. 30, 2014 One Year
Compensated absences $ 29,390 $ 133,169 $ (129,639) $ 32,920 $ 32,920
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
$64,058, covered payroll was $759,665, and total payroll was $760,579 during the fiscal year. Contribution to
the plan during the fiscal year was$64,058.
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.
12
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2014
NOTE I: LEASE COMMITMENTS
The Commission leases office space. The original lease term began November 1, 2011, and is for 123 months.
Rental expense for the year ended September 30, 2014,was$50,444. Future minimum payments are as follows:
Year Ending
September 30,
2015 $ 51,464
2016 52,492
2017 53,524
2018 54,548
2019 55,576
2020-2022 133,552
$ 401,156
NOTE J: RISK MANAGEMENT
The Commission is exposed to various risks of loss for workers' compensation for which the Commission carries
commercial insurance.
The Commission also participates in a pool, the Michigan Township Participating Plan, with other municipalities
for property, liability, auto, crime, in-land marine, equipment breakdown, public official wrongful acts, and EDP ` -
losses. The pool is organized under Public Act 138 of 1982, as amended. In the event the pool's claims and
expenses for a policy year exceed the total normal annual premiums for said years, all members of the specific '
pool's policy year may be subject to special assessment to make up the deficiency. The Commission has not
been informed of any special assessments being required. f
NOTE K: PRIOR PERIOD ADJUSTMENTS AND RESTATEMENT OF BEGINNING NET POSITION t -
The following prior period adjustment was made during the year to correct accounting errors. This adjustment
was reported as changes to the beginning fund balance. The effect on operations and other affected balances
for the current and prior year are as follows:
September 30,
2014 2013
General Fund
Accrued liabilities $ $ (384)
Revenues over(under) expenditures (384) .
Fund balance- beginning 384 -
The corrections of accounting errors reported in the funds resulted in a restatement of the beginning net position
of governmental activities. The beginning net position for governmental activities increased $384.
13 _ '','
Tri-County Regional Planning Commission
NOTES TO FINANCIAL STATEMENTS
September 30, 2014
NOTE L: 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:
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
i
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.
i
Fund Balance Classification Policies and Procedures
For committed fund balance, the Commission's highest level of decision-making authority is the Board. 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 resources if they are needed.
i
- 14 -
�, I
l
I
I
I III
I �I'
i ,
1 .
� �
� , II
II,
� . 'I
� ,
�.
. � '
��
i
j
REQUIRED SUPPLEMENTARY INFORMATION
Tri-County Regional Planning Commission `
General Fund r
BUDGETARY COMPARISON SCHEDULE 1
Year Ended September 30, 2014
Variance with f
Budgeted Amounts Final Budget I
Positive
Original Final Actual (Negative)
REVENUES
Federal sources $ 2,426,272 $ 2,369,246 $ 2,101,879 $ (267,367)
State sources 116,014 214,516 58,117 (156,399)
Local sources 281,093 293,383 364,354 70,971
Member allocations 377,850 377,850 377,850 -0- I
Interest - - 643 643
TOTAL REVENUES 3,201,229 3,254,995 2,902,843 (352,152)
EXPENDITURES
Current I
Community and economic development
Salaries 768,737 779,953 760,579 19,374
Fringe benefits 442,378 442,900 413,206 29,694 t
Discretionary fund 5,000 5,000 - 5,000 l
Recognition awards 250 250 250 -0-
Telephone 1,200 2,350 2,243 107 I
Postage 8,319 7,919 2,157 5,762 l
Printing and copying 17,000 19,000 7,802 11,198
Office supplies 11,000 11,200 6,554 4,646
Graphics supplies 2,050 2,050 1,964 86
Travel - in region 14,000 18,000 16,243 1,757
Travel -out region 19,275 19,275 19,250 25
Training 10,500 10,500 8,187 2,313
Commission meeting expenses 1,500 2,000 1,949 51
Commission travel 1,500 1,000 759 241
Rent- meeting facility 3,550 5,050 2,840 2,210 r
Rent-office 64,000 64,000 63,314 686 l
Rent- equipment 1,750 1,750 372 1,378
Equipment maintenance 5,000 5,000 1,618 3,382
Computer services 13,500 21,000 19,953 1,047
Computer software 32,000 32,000 26,650 5,350
Insurance 6,800 6,639 6,639 -0-
Bank service charges 1,000 1,200 693 507
Subscriptions 800 800 403 397
Publications 1,500 1,500 303 1,197
Advertising 4,100 6,100 1,537 4,563
Membership dues 16,000 16,000 11,909 4,091
i
Tri-County Regional Planning Commission
General Fund
BUDGETARY COMPARISON SCHEDULE - CONTINUED
Year Ended September 30, 2014
Variance with
Budgeted Amounts Final Budget
Positive
Original Final Actual (Negative)
EXPENDITURES- CONTINUED
Current-continued
Community and economic
development-continued
Special projects $ 103,100 $ 143,100 $ 105,876 $ 37,224
Consultant fee 351,814 337,409 189,846 147,563
Contractual services 73,300 90,250 21,662 68,588
Furniture/equipment purchases 10,100 15,100 15,070 30
Audit 8,900 8,900 8,900 -0-
Pass-through 1,201,306 1,177,800 1,132,657 45,143
TOTAL EXPENDITURES 3,201,229 3,254,995 2,851,385 403,610
EXCESS OF REVENUES OVER
(UNDER) EXPENDITURES -0- -0- 51,458 51,458
OTHER FINANCING SOURCES (USES)
Transfer for local match (277,771) (255,046) (191,450) 63,596
Operating transfers in local match 277,771 255,046 191,450 (63,596)
TOTAL OTHER FINANCING
SOURCES (USES) -0- -0- -0- -0-
NET CHANGE IN FUND BALANCE -0- -0- 51,458 51,458
Fund balance, beginning of year 471,018 471,018 471,018 -0-
Prior period adjustment - - 384 384
Fund balance, end of year $ 471,018 $ 471,018 $ 522,860 $ 51,842
I
' 16
� � ��,
��
f� '�
'I
f
f �
[ '�,
� ,,'
C �',
� '!
( . �
[ '.
L
f
� � '
f . ''�
� ;
L I',
i
OTHER SUPPLEMENTARY INFORMATION
i
f,
�� '�
f
[ I',
f �
��
I 'i
C
[ �
� � .
[ I,
6_
p : '
� ,
Tri-County Regional Planning Commission
SCHEDULE OF COMMISSION REVENUES AND EXPENDITURES (UNAUDITED)
Year Ended September 30, 2014
Special Projects
Operating Indirect Direct Total Eliminations Total
REVENUES
Federal sources $ - $ - $ 2,101,879 $ 2,101,879 $ - $ 2,101,879
State sources - - 58,117 58,117 - 58,117
Local sources - - 364,354 364,354 - 364,354
Member allocations 377,850 - - -0- - 377,850
Interest 643 - - -0- - 643
Operating transfers in local match - - 191,450 191,450 (191,450) -0-
Other 8,373 -0- (8,373) -0-
TOTAL REVENUES 386,866 -0- 2,715,800 2,715,800 (199,823) 2,902,843
EXPENDITURES
i Direct costs
Salaries and wages 47,734 172,320 540,525 712,845 - 760,579
Fringe benefits 26,065 94,029 293,112 387,141 - 413,206
Recognition awards 250 - - -0- - 250
Telephone - 2,156 87 2,243 - 2,243
Postage 546 812 799 1,611 - 2,157
Printing and copying 1,567 2,536 3,699 6,235 - 7,802
Office supplies 55 5,975 524 6,499 - 6,554
Graphic supplies - 1,381 583 1,964 - 1,964
Travel-in region 346 4,543 11,354 15,897 - 16,243
Travel-out region - 6,761 12,489 19,250 - 19,250
Training - 5,075 3,112 8,187 - 8,187
Commission meeting expenses 1,949 - - -0- - 1,949
Commission travel 759 - - -0- - 759
Rent-meeting facility - (372) 3,212 2,840 - 2,840
Rent-office - 63,314 - 63,314 - 63,314
Rent-equipment - 372 - 372 - 372
Equipment maintenance - 1,618 - 1,618 - 1,618
'. Computer services - 19,411 542 19,953 - 19,953
Computer software - 13,518 13,132 26,650 - 26,650
Insurance - 6,639 - 6,639 - 6,639
Bank service charges 693 - - -0- - 693
Subscriptions - 403 - 403 - 403
Publications - 63 240 303 - 303
Advertising - 420 1,117 1,537 - 1,537
Depreciation - 8,373 - 8,373 (8,373) -0-
Membership dues 565 9,420 1,924 11,344 - 11,909
Special projects 459 403 105,014 105,417 - 105,876
Consultants - - 189,846 189,846 - 189,846
Contractual services - 11,663 9,999 21,662 - 21,662
Furniture/equipment purchases 15,070 - - -0- - 15,070
Transfer for match 191,450 - - -0- (191,450) -0-
Pass-through - - 1,132,657 1,132.657 - 1,132,657
Audit - 8,900 - 8,900 - 8,900
Indirect costs 47,900 (439,733) 391,833 (47,900) - -0-
TOTAL EXPENDITURES 335,408 -0- 2,715,800 2,715,800 (199,823) 2,851,385
NET REVENUES OVER
EXPENDITURES $ 51,458 $ -0- $ -0- $ -0- $ -0- $ 51,458
,
- 17-
i
Tri-County Regional Planning Commission
COMBINING SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
Year Ended September 30, 2014 �l
GREATER l
MIDDLE GRAND LANSING
RIVER WELLHEAD: REGIONAL
ORGANIZATIONS DEWITT PERMIT DELTA COMMITTEE
OF WATERSHEDS ASSISTANCE TOWNSHIP (GLRC)2014
(30100) (30110) (30210) (30300)
REVENUES ` li
Federal sources $ - $ - $ - $ -
State sources I
Local sources 1,000 4,716 78,239 50,346
TOTAL REVENUES 1,000 4,716 78,239 50,346 t
OTHER FINANCING SOURCES C !!
Operating transfers in local match
TOTAL REVENUES AND r
OTHER FINANCING SOURCES 1,000 4,716 78,239 50,346 t
EXPENDITURES!
Direct costs
Salaries and wages 439 2,092 33,993 19,942
Fringe benefits 240 1,142 18,456 10,596
Telephone - - - -
Postage
Printing and copying 8 7 69 41
Office supplies - - 7 -
Graphic supplies - - fI
Travel-in region 477 26 1
Travel-out region - - 775 965
Training - - - -
Rent of facility - - - 36
Computer services - - - -
Computer software - - -
Publications - - -
Advertising - - - -
Membership dues - - - 20
Special projects - - - 4,334
Consultants - - - -
Contractual services ,
Pass-through - -
Indirect costs 313 1,475 24,462 14,386
TOTAL EXPENDITURES 1,000 4,716 78,239 50,346
NET REVENUES OVER
(UNDER)EXPENDITURES $ -0- $ -0- $ -0- $ -0-
18
' I
GREATER MID-
LANSING GROUNDWATER MICHIGAN
REGIONAL MANAGEMENT MID-MICHIGAN WATER
COMMITTEE BOARD (GMB) WATER AUTHORITY BY-PRODUCT
(GLRC)2013 2014 AUTHORITY 2014 2013 SYNERGY
(30310) (30400) (30700) (30800) (30900)
$ $ $ - $ $ 26,150
27,504 61,299 1,594 1,505 -
27,504 61,299 1,594 1,505 26,150
27,504 61,299 1,594 1,505 26,150
10,594 20,900 702 665 14,771
5,749 12,995 383 363 5,908
16 120 7 -
- 204 4 6
41 - -
233 2,082 116
- 2,040 99
1,469 1,119
- 664
3,365 7,703 - - -
7,547 12,970 498 471 4,137
27,504 61,299 1,594 1,505 26,150
$ -0- $ -0- $ -0- $ -0- $ -0-
' - 19-
Tri-County Regional Planning Commission t
I
COMBINING SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)- CONTINUED
Year Ended September 30, 2014
MSU WATER
RESEARCH j
MANAGEMENT REGIONAL
PLAN FOR RED PROSPERITY EDA PLANNING FHWA PL
CEDAR GRANT GRANT FUNDS
(31100) (31300) (31400) (32100) f
REVENUES 1
Federal sources $ $ $ 27,091 $ 415,655
State sources - -
Local sources 24,354 113,797 - -
TOTAL REVENUES 24,354 113,797 27,091 415,655
OTHER FINANCING SOURCES
Operating transfers in local match 27,091 92,170
TOTAL REVENUES AND I
OTHER FINANCING SOURCES 24,354 113,797 54,182 507,825
EXPENDITURES
Direct costs
Salaries and wages 11,068 22,805 23,031 210,365
Fringe benefits 5,571 12,453 12,518 114,871
Telephone - 10 - -
Postage - - - 183
Printing and copying 2 22 35 857
Office supplies - - - -
Graphic supplies - - - -
Travel-in region 99 411 735 1,475
Travel-out region - 280 653 2,146
Training - - 53
Rent of facility - - - 2,176
Computer services - - - 169
Computer software - - 9,879
Publications - - 79
Advertising - - 874
Membership dues 270 592
Special projects 35,450 -
Consultant fee - I
Contractual services 7,760
Pass-through - 26,000
Indirect costs 7,614 16,366 16,940 156,346
TOTAL EXPENDITURES 24,354 113,797 54,182 507,825 C -
NET REVENUES OVER
(UNDER)EXPENDITURES $ -0- $ -0- $ .0. $ -0-
20
MDOT GRANT: REGIONAL SURFACE FTA GRANT STATE
ASSET TRANSPORATION TRANSPORTATION SECTION 5303 PLANNING AND
MANAGEMENT CONTRACT PROGRAM GRANT FUNDS RESEARCH
(32300) (32400) (32800) (33000) (34000)
$ $ - $ 148,293 $ 122,545 $ 15,200
14,217 40,100 - - 3,800
14,217 40,100 148,293 122,545 19,000
- - 41,553 30,636 -
14,217 40,100 189,846 153,181 19,000
5,673 16,843 - 63,772 8,230
3,098 9,197 34,823 4,494
30 55 27
173 261 104
j - 253 - 445 202
30 406 - 637 -
- 10 - 16 -
- 27 - 601 -
- 7 - 46 -
- 421 - 2,721 -
- 14 - 23 3
- 3 - 240 -
- 112 - 176
- 189,846 -
- 97 - 2,142
1,412 - - -
4,004 12,507 - 47,223 5,940
14,217 40,100 189,846 163,181 19,000
$ -0- $ -0- $ -0- $ -0- $ -0-
21
Tri-County Regional Planning Commission
COMBINING SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)- CONTINUED
Year Ended September 30, 2014
HUD [
SUSTAINABLE
COMMUNITIES
REGIONAL
PLANNING GRANT
PROGRAM
(35000) TOTAL
REVENUES
Federal sources $ 1,346,945 $ 2,101,879 (((
State sources - 58,117
Local sources - 364,354
TOTAL REVENUES 1,346,945 2,524,350 r
OTHER FINANCING SOURCES f{
Operating transfers in local match - 191,450 ',
TOTAL REVENUES AND ,
OTHER FINANCING SOURCES 1,346,945 2,716,800
EXPENDITURES I[
Direct costs
Salaries and wages 74,640 540,625
Fringe benefits 40,255 293,112
Telephone 77 87
Postage 361 799
Printing and copying 1,906 3,699
Office supplies 476 524
Graphic supplies 583 583 .
Travel-in region 4,800 11,354
Travel-out region 4,458 12,489
Training 445 3,112 l
Rent of facility 372 3,212 l
Computer services 320 542
Computer software - 13,132
Publications 121 240
Advertising - 1,117
Membership dues 90 1,924
Special projects 54,162 105,014
Consultants 189,846
Contractual services - 9,999
Pass-through 1,105,245 1,132,657 r(g
Indirect costs 58,634 391,833 k
TOTAL EXPENDITURES 1,346,945 2,715,800 l
NET REVENUES OVER
(UNDER) EXPENDITURES $ -0- $ -0-
22
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MIDDLE GRAND RIVER ORGANIZATIONS OF WATERSHEDS
Project period October 1, 2013 through September 30, 2014
MGROW - Cash (30100)
REVENUES
Local
Cash received
EXPENDITURES
Direct costs
Salaries $ 439
Fringe benefits 240
Printing and copying g
Indirect costs 313
TOTAL EXPENDITURES $ 1,000
I
-23-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
DEWITT TOWNSHIP PERMIT ASSISTANCE
Project period January 1, 2013 through December 31, 2014 f li
DEWITT TOWNSHIP -Cash (30110) r !,
Jan. 1, 2013 Oct. 1,2013 Jan. 1, 2013 p
through through through ,
Sept. 30, 2013 Sept. 30 2014 Sept. 30 2014
REVENUES
Local
Accounts receivable- current year $ - $ 4,716 $ 4,716
Accounts receivable- prior year 3,772 3,772
TOTAL REVENUES $ 3,772 $ 4,716 $ 8,488 ,
EXPENDITURES
Direct costs
Salaries $ 1,660 $ 2,092 $ 3,752
Fringe benefits 857 1,142 1,999
Printing and copying 6 7 13
Travel -in region 30 - 30
Indirect costs 1,219 1,475 2,694
TOTAL EXPENDITURES $ 3,772 $ 4,716 $ 8,488 .
t
I
f . I
r � III
I
24 � '
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
WELLHEAD: DELTA TOWNSHIP
Project period October 1, 2013 through September 30, 2014
DELTA TOWNSHIP - Cash (30210)
REVENUES
Local
Cash received $ 1,470
Accounts receivable 76,769
TOTAL REVENUES $ 78,239
EXPENDITURES
Direct costs
Salaries $ 33,993
Fringe benefits 18,456
Printing and copying 69
Graphic supplies 7
Travel -in region 477
Travel -out region 775
Indirect costs 24,462
i
TOTAL EXPENDITURES $ 78,239
i
. I
i
-25-
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 (30300) [
Jan. 1, 2014
through
Sept. 30, 2014 [
REVENUES
Local
Cash received $ 118,710 I
Unearned revenue-current year (68,364)
TOTAL REVENUES $ 50,346
EXPENDITURES
Direct costs
Salaries $ 19,942
Fringe benefits 10,596
Printing and copying 41
Rent of facility 36
Travel - in region 26
Travel -out region 965
Membership dues 20 I
Special projects 4,334 l
Indirect costs 14,386
TOTAL EXPENDITURES $ 50,346 f
C '!
C : I
26 �_.
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
GREATER LANSING REGIONAL COMMITTEE (GLRC)2013
Project period January 1, 2013 through December 31, 2013
VARIOUS MUNICIPALITIES - Cash (30310)
Jan. 1, 2013 Oct. 1, 2013 Jan. 1, 2013
through through through
Sept. 30, 2013 Dec. 31, 2013 Dec. 31, 2013
REVENUES
Local
Cash received $ 95,767 $ - $ 95,767
Unearned revenue-prior year (44,342) 27,504 (16,838)
Accounts receivable- prior year 6,105 - 6,105
TOTAL REVENUES $ 57,530 $ 27,504 $ 85,034
EXPENDITURES
Direct costs
Salaries $ 24,825 $ 10,594 $ 35,419
Fringe benefits 12,809 5,749 18,558
Postage 12 16 28
Printing and copying 26 - 26
Travel - in region 716 233 949
Travel -out region 262 - 262
Membership dues 60 - 60
Special projects 333 3,365 3,698
Indirect costs 18,487 7,547 26,034
TOTAL EXPENDITURES $ 57,530 $ 27,504 $ 85,034
i
27
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
GROUNDWATER MANAGEMENT BOARD (GMB)2014
I
Project period October 1, 2013 through September 30, 2014
VARIOUS MUNICIPALITIES - Cash (30400) f
REVENUES l
Local
Cash received $ 101,600
Unearned revenue- prior year (40,301)
TOTAL REVENUES $ 61,299
EXPENDITURES l
Direct costs pr
Salaries $ 20,900 1
Fringe benefits 12,995
Postage 120 I
Printing and copying 204
Office supplies 41
Travel - in region 2,082
Travel -out region 2,040
Training 1,469
Computer software 111
Membership dues 664 l
Special projects 7,703 l
Indirect costs 12,970
TOTAL EXPENDITURES $ 61,299
l I'
fi
l : !
28
i
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
through
Sept. 30, 2014
REVENUES
Local
Accounts receivable-current year $ 1,594
TOTAL REVENUES $ 1,594
EXPENDITURES
Direct costs
Salaries $ 702
Fringe benefits 383
Postage 7
Printing and copying 4
Indirect costs 498
TOTAL EXPENDITURES $ 1,594
i
; I
i
-29-
Tri-County Regional Planning Commission 1
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MID-MICHIGAN WATER AUTHORITY 2013
Project period January 1, 2013 through December 31, 2013 I
VARIOUS MUNICIPALITIES - Cash (30800)
Jan. 1, 2013 Oct. 1, 2013 Jan. 1, 2013
through through through
Sept. 30, 2013 Dec. 31, 2013 Dec. 31, 2013 I
REVENUES
Local
Accounts receivable-current year $ - $ 1,505 $ 1,505
Accounts receivable-prior year 2,352 - 2,352
TOTAL REVENUES $ 2,352 $ 1,505 $ 3,857
I
EXPENDITURES
Direct costs
Salaries $ 1,026 $ 665 $ 1,691
Fringe benefits 532 363 895
Postage 25 - 25
Printing and copying 29 6 35 I
Indirect costs 740 471 1,211 l
TOTAL EXPENDITURES $ 2,352 $ 1,505 $ 3,857 I
I . I
I_.
i �
. I
I
30 �'
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
BY-PRODUCT SYNERGY
Project period February 1, 2012 through September 30, 2014
VARIOUS MUNICIPALITIES- Cash (30900)
Feb. 1, 2012 Oct. 1, 2013 Feb. 1, 2012
through through through
Sept. 30, 2013 Sept. 30, 2014 Sept. 30, 2014
REVENUES
Federal grant
Cash received $ 16,855 $ 18,545 $ 35,400
Accounts receivable- current year - 7,605 7,605
Accounts receivable- prior year 12,370 - 12,370
TOTAL REVENUES $ 29,225 $ 26,150 $ 55,375
EXPENDITURES
Direct costs
Salaries $ 17,018 $ 14,771 $ 31,789
Fringe benefits 6,808 5,908 12,716
Postage (3) - (3)
Printing and copying 86 - 86
Travel -in region 278 116 394
Travel -out region - 99 99
Training 275 1,119 1,394
Indirect costs 4,763 4,137 8,900
, i
TOTAL EXPENDITURES $ 29,225 $ 26,150 $ 55,375
31
Tri-County Regional Planning Commission 1
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
MSU WATER RESEARCH - MANAGEMENT PLAN FOR THE RED CEDAR
Project period February 1, 2012 through September 30, 2014 `
VARIOUS MUNICIPALITIES- Cash (31100) t
Feb. 1, 2012 Oct. 1, 2013 Feb. 1, 2012
through through through F ,
Sept. 30, 2013 Sept. 30, 2014 Sept. 30, 2014
REVENUES
Local
Cash received $ 12,972 $ 17,924 $ 30,896 t
Accounts receivable- current year - 6,430 6,430 1
Accounts receivable - prior year 9,766 - 9,766
TOTAL REVENUES $ 22,738 $ 24,354 $ 47,092
EXPENDITURES
Direct costs
Salaries $ 9,780 $ 11,068 $ 20,848 I'I
Fringe benefits 5,069 5,571 10,640
Printing and copying 47 2 49
Travel - in region 372 99 471
Indirect costs 7,470 7,614 15,084 I _
TOTAL EXPENDITURES $ 22,738 $ 24,354 $ 47,092 l
C .
LI
� ; II
- 32- 6 ;
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 (31300)
June 1, 2014
through
Sept. 30, 2014
REVENUES
Local
Cash received $ 155,300
Unearned revenue-current year (41,503)
TOTAL REVENUES $ 113,797
EXPENDITURES
Salaries $ 22,805
Fringe benefits 12,453
Telephone 10
Printing and copying 22
Travel -in region 411
Travel -out region 280
Special projects 35,450
Pass-through 26,000
Indirect costs 16,366
TOTAL EXPENDITURES _$ 113,797
33
Tri-County Regional Planning Commission t
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
EDA PLANNING GRANT
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, 2013 July 1, 2013
through through through
Sept. 30, 2013 Sept. 30, 2014 Sept. 30, 2014
REVENUES
Federal grant
Cash received $ - $ 60,503 $ 60,503
Accounts receivable- prior year 9,953 - 9,953
Unearned revenue- current year - (33,412) (33,412)
TOTAL REVENUES 9,953 27,091 37,044
OTHER FINANCING SOURCES
Operating transfers in
Local match 9,953 27,091 37,044
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 19,906 $ 54,182 $ 74,088
EXPENDITURES
Direct costs
Salaries $ 8,229 $ 23,031 $ 31,260 f
Fringe benefits 4,245 12,518 16,763
Printing and copying 48 35 83
Travel -in region 843 735 1,578
Travel -out region 107 653 760
Membership dues - 270 270
Indirect costs 6,434 16,940 23,374
TOTAL EXPENDITURES $ 19,906 $ 54,182 $ 74,088
II
34
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
FHWA PL FUNDS
Project period October 1, 2013 through September 30, 2014
FHWA CONTRACT NO. PL 2012-0011/Z8 (32100)
FHWA-$596,455 Cash
TCRPC-$132,263 Cash
i
REVENUES
Federal grant
Cash $ 312,397
Accounts receivable 103,258
TOTAL REVENUES 415,655
OTHER FINANCING SOURCES
Operating transfers in
Local match 92,170
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 507,825
EXPENDITURES
Direct costs
Salaries $ 210,365
Fringe benefits 114,871
Postage 183
Printing and copying 857
Travel - in region 1,475
Travel -out region 2,146
Training 53
Rent of facility 2,176
Computer services 169
Computer software 9,879
Publications 79
Advertising 874
Membership dues 592
Contractual services 7,760
Indirect costs 156,346
TOTAL EXPENDITURES $ 507,825
I
-35-
i
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) r
MDOT GRANT: ASSET MANAGEMENT I l
Project period October 1, 2013 through September 30, 2014 [
MDOT CONTRACT NO. 2012-0022IZ7 (32300)
MDOT- $33,786 Cash
REVENUES [
State of Michigan
Cash $ 8,821
Accounts receivable 5,396 j
TOTAL REVENUES $ 14,217 [ !'
I
EXPENDITURES
Direct costs [
Salaries $ 5,673
Fringe benefits 3,098 [
Travel -out region 30
Pass-through 1,412
Indirect costs 4,004
TOTAL EXPENDITURES $ 14,217 [
Lli
[ II
I , I
36 [,
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
REGIONAL TRANSPORTATION CONTRACT
Project period October 1, 2013 through September 30, 2014
MDOT CONTRACT NO. 2012-0022/Z6 (32400)
MDOT -$40,100 Cash
REVENUES
State of Michigan
Cash $ 18,643
Accounts receivable 21,457
TOTAL REVENUES $ 40,100
EXPENDITURES
Direct costs
Salaries $ 16,843
Fringe benefits 9,197
Postage 30
Printing and copying 173
Travel -in region 253
Travel -out region 406
Training 10
Rent of facility 27
Computer services 7
Computer software 421
Publications 14
Advertising 3
Membership dues 112
Contractual services 97
Indirect costs 12,507
TOTAL EXPENDITURES $ 40,100
I
-37-
i
I
Tri-County Regional Planning Commission I
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED) r j
SURFACE TRANSPORTATION PROGRAM GRANT I j
Project period October 1, 2013 through September 30, 2014 I
FHWA CONTRACT NO. 2012-0011/Z9 and 2012-0011IZ10 (32800)
FHWA- $400,000 Cash I
TCRPC-$116,525 Cash
REVENUES I
Federal grant
Cash received $ 99,180
Accounts receivable 49,113 I
TOTAL REVENUES 148,293
OTHER FINANCING SOURCES I .
Operating transfers in
Local match 41,553
TOTAL REVENUES AND I
OTHER FINANCING SOURCES $ 189,846
EXPENDITURES
Direct costs
Consultants $ 189,846
II
I '
I
. i
I !�
-38-
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
FEDERAL TRANSIT ADMINISTRATION -SECTION 5303 FUNDS
Project period October 1, 2013 through September 30, 2014
FTA CONTRACT NO. PL 2012-0011/Z7
FTA- $157,899 Cash
TCRPC-$39,475 Cash
REVENUES
Federal grant
Cash $ 87,854
Accounts receivable 34,691
i
TOTALREVENUES 122,545
OTHER FINANCING SOURCES
Operating transfers in
Local match 30,636
TOTAL REVENUES AND
OTHER FINANCING SOURCES $ 153,181
I
EXPENDITURES
Direct costs
Salaries $ 63,772
Fringe benefits 34,823
Postage 55
Printing and copying 261
Travel - in region 445
Travel -out region 637
Training 16
Rent of facility 601
Computer services 46
Computer software 2,721
Publications 23
Advertising 240
Membership dues 176
Contractual services 2,142
Indirect costs 47,223
TOTAL EXPENDITURES $ 153,181
-39 -
i
Tri-County Regional Planning Commission
SCHEDULE OF PROJECT REVENUES AND EXPENDITURES (UNAUDITED)
I
STATEWIDE PLANNING AND RESEARCH
Project period October 1, 2013 through September 30, 2014
MDOT CONTRACT NO. 2012-0016/Z9 (34000)
FHWA- $15,200 Cash f
MDOT -$3,800 Cash
REVENUES
Federal grant
Cash received $ 10,834
Accounts receivable-current year 4,366
State of Michigan
Cash received 2,709
Accounts receivable-current year 1,091
TOTAL REVENUES $ 19,000
EXPENDITURES
Direct costs
Salaries $ 8,230
Fringe benefits 4,494 'l,!
Postage 27 111
Printing and copying 104
Travel - in region 202
Publications 9 3
Indirect costs 5,940
TOTAL EXPENDITURES $ 19,000
. III
1 . I
t ;
1 ,
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 January 31, 2015
HUD COOPERATIVE AGREEMENT NO. MIRIP0056-11 (35000)
HUD -$3,000,000
July 1, 2012 Oct. 1, 2013 July 1, 2012
through through through
Sept. 30, 2013 Sept. 30, 2014 Sept. 30, 2014
REVENUES
Federal grant
Cash received - current year $ - $ 1,158,686 $ 1,158,686
Cash received - prior year 920,926 - 920,926
Accounts receivable- current year - 188,259 188,259
Accounts receivable- prior year 418,371 - 418,371
TOTAL REVENUES $ 1,339,297 $ 1,346,945 $ 2,686,242
EXPENDITURES
Direct costs
Salaries $ 86,523 $ 74,640 $ 161,163
Fringe benefits 44,981 40,255 85,236
Telephone 33 77 110
Postage 1,727 361 2,088
Printing and copying 1,405 1,906 3,311
Office supplies 3,457 476 3,933
Graphic supplies 135 583 718
Travel -in region 4,912 4,800 9,712
Travel-out region 4,923 4,458 9,381
Training 400 445 845
Rent of facility/equipment 2,837 372 3,209
Computer services 504 320 824
Subscriptions/publications 40 121 161
Advertising 241 - 241
Membership dues 463 90 553
Special projects 44,639 54,162 98,801
Pass-through 1,065,945 1,105,245 2,171,190
Indirect costs 76,132 58,634 134,766
TOTAL EXPENDITURES $ 1,339,297 $ 1,346,945 $ 2,686,242
-41 -
i
i
Tri-County Regional Planning Commission !
ANALYSIS OF COMPLETED PROJECTS (UNAUDITED)
Year Ended September 30,2014
MIDDLE GRAND GREATER t
RIVER LANSING GROUNDWATER WELLHEAD:
ORGANIZATIONS REGIONAL MANAGEMENT DELTA
OF WATERSHEDS COMMITTEE BOARD (GMB) TOWNSHIP
(MGROW)2014 (GLRC)2013 2014 2014
(30100) (30310) (30400) (30210)
I
Total expenditures $ 1,000 $ 85,034 $ 101,116 $ 78,239 I
Less: locally funded `
expenditures 1,000 85,034 101,116 78,239
Allowable expenditures -0- -0- -0- -0-
Grantor participation 0% 0% 0% 0% r
Grant revenues - - - - I
Grant receipts - - - -
Due from grantor $ -0- $ -0- $ -0- $ -0-
I .
-42 - � '
MID-MICHIGAN BY- MDOT GRANT: REGIONAL
WATER PRODUCT FHWA PL ASSET TRANSPORTATION
AUTHORITY2013 SYNERGY FUNDS MANAGEMENT CONTRACT
(30800) (30900) (32100) (32300) (32400)
$ 3,857 $ 55,375 $ 507,825 $ 14,217 $ 40,100
3,857 55,375 92,170
-0- -0- 415,655 14,217 40,100
0% 0% 82% 100% 100%
- - 415,655 14,217 40,100
- - 312,397 8,821 18,643
$ -0- $ -0- $ 103,258 $ 5,396 $ 21,457
, j
-43-
Tri-County Regional Planning Commission
I
ANALYSIS OF COMPLETED PROJECTS (UNAUDITED)- CONTINUED [
Year Ended September 30, 2014
SURFACE FTA GRANT STATE
TRANSPORATION SECTION 5303 PLANNING AND
PROGRAM GRANT FUNDS RESEARCH
(32800) (33000) (34000)
Total expenditures $ 189,846 $ 153,182 $ 19,000
Less: locally funded
expenditures 41,553 30,636 -
Allowable expenditures 148,293 122,546 19,000
Grantor participation 78% 80% 100% !
Grant revenues 148,293 122,546 19,000 !
1 . 1
Grant receipts 99,180 87,855 13,543
Due from grantor $ 49,113 $ 34,691 $ 5,457 I
1
1.
C I,
[ I
i '
44 IIII
i
Tri-County Regional Planning Commission
ANALYSIS OF LOCAL MATCH AND INDIRECT CHARGES (UNAUDITED)
Year Ended September 30, 2014
LOCAL MATCH
Commission Projects Total
EDA Planning Grant (31400) $ 27,091 $ $ 27,091
FHWA PL Funds (32100) 92,171 92,171
STP (32800) 41,552 41,552
FTA(33000) 30,636 30,636
i
$ 191,450 $ -0- $ 191,450
-45-
Tri-County Regional Planning Commission
ANALYSIS OF INDIRECT COST RATE (UNAUDITED) rr j
1 ,
Year Ended September 30, 2014
Indirect Base Indirect Base
Total Expenditures $ - $ 3,051,208 r
Direct expenditures 2,819,712 (2,819,712)
Less:
Recognition awards (250) -
Consultants (189,846) -
Contractual services (9,999) -
Special projects (105,473) -
Furniture and equipment purchases (15,070) -
Match (191,450) -
Pass-through (1,132,657)
$ 1,174,967 $ 231,496 fI
Indirect cost rate (indirect costs as a part of indirect base) 19.702% t
L ,
it
r I
1 ,
C �I
l :
1,
-46 - t,
Tri-County Regional Planning Commission
SCHEDULE OF FRINGE BENEFITS (UNAUDITED)
Year Ended September 30, 2014
Social security $ 57,649
Pension contribution 64,058
Unemployment taxes 1,400
Health insurance 253,256
Workers compensation 1,799
Group life insurance 8,181
Dental insurance 24,045
Employee assistance program 342
Fringe benefits miscellaneous 2,476
Total fringe benefits $ 413,206
Salaries and wages for the year ended September 30, 2014 $ 760,579
Fringe benefit rate-All employees 54.33%
I
I
i
47
Tri-County Regional Planning Commission
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED)
REGIONAL TRANSPORTATION
Year Ended September 30, 2014
FHWA PL 2012-00111Z8 (32100)
VARIANCE
FAVORABLE
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 366,458 $ 286,835 $ 69,623
II LONG RANGE PLANNING 216,947 108,146 108,801
III SHORT RANGE PLANNING 10,576 5,677 4,899 C
IV PROGRAM MANAGEMENT AND ` -
COORDINATION 111,284 68,060 43,224
V TRANSPORTATION PROGRAMMING
ACTIVITIES 33,460 39,107 (5,647)
� . I
VI OTHER RELATED ACTIVITIES - - -0-
GRAND TOTALS $ 728,725 $ 507,825 $ 220,900 1
. II
( I
48 ! .
FTA PL 2012-0011/Z7 (33000) MDOT#2012-0022/Z6 (32400)
VARIANCE VARIANCE
FAVORABLE FAVORABLE
BUDGET EXPENDED (UNFAVORABLE) BUDGET EXPENDED (UNFAVORABLE)
$ 90,811 $ 74,830 $ 15,981 $ 8,966 $ 8,723 $ 243
50,245 26,616 23,629 17,799 16,330 1,469
2,000 409 1,591 - - -0-
30,478 20,366 10,112 10,735 11,676 (941)
9,163 10,716 (1,553) 1,600 1,952 (352)
14,837 20,244 (5,407) 1,000 1,419 (419)
$ 197,534 $ 153,181 $ 44,353 $ 40,100 $ 40,100 $ -0-
i
I
I
49
i
Tri-County Regional Planning Commission
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED)- CONTINUED
REGIONAL TRANSPORTATION
I
Year Ended September 30, 2014
MDOT#2012-0022/Z7 (32300)
VARIANCE {
FAVORABLE fl
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 33,767 $ 14,217 $ 19,550
II LONG RANGE PLANNING - - -0-
III SHORT RANGE PLANNING -0-
IV PROGRAM MANAGEMENT AND
COORDINATION -0-
V TRANSPORTATION PROGRAMMING
ACTIVITIES -0-
VI OTHER RELATED ACTIVITIES - -0-
GRAND TOTALS $ 33,767 $ 14,217 $ 19,550 f
j
l . Ills
I,
50 � '
FHWA-STP#2012-001129, FHWA-STP#2012-
0011/Z10, and FHWA-STP#2012-0011/Z11 (32800) FHWA-SP&R#2012-00111Z9 (34000)
VARIANCE VARIANCE
FAVORABLE FAVORABLE
BUDGET EXPENDED (UNFAVORABLE) BUDGET EXPENDED (UNFAVORABLE)
$ 516,525 $ 189,846 $ 326,679 $ - $ - $ -0-
- - -0- 6,000 2,999 3,001
-0- -0-
-0- 6,000 6,453 (453)
-0- 7,000 9,548 (2,548)
- - -0- - - -0-
$ 516,525 $ 189,846 $ 326,679 $ 19,000 $ 19,000 $ -0-
I�
I'I
, I
-51 -
Tri-County Regional Planning Commission
TRANSPORTATION SUMMARY OF EXPENDITURES (UNAUDITED)-CONTINUED
REGIONAL TRANSPORTATION I
i
Year Ended September 30, 2014 I
I
TOTAL I _
VARIANCE
FAVORABLE
Task# TASK NAME BUDGET EXPENDED (UNFAVORABLE)
I DATA BASE MANAGEMENT $ 1,006,527 $ 574,451 $ 432,076
C ,
II LONG RANGE PLANNING 290,991 154,091 136,900
III SHORT RANGE PLANNING 12,576 6,086 6,490 f
IV PROGRAM MANAGEMENT AND
COORDINATION 158,497 106,555 51,942 f
V TRANSPORTATION PROGRAMMING
ACTIVITIES 51,223 61,323 (10,100)
VI OTHER RELATED ACTIVITIES 15,837 21,663 (5,826)
GRAND TOTALS $ 1,535,661 $ 924,169 $ 611,482
II
r .
t ,
l
-52-
Tri-County Regional Planning Commission
Lansing, Michigan
SUPPLEMENTARY INFORMATION
TO FINANCIAL STATEMENTS
(FEDERAL AWARDS)
September 30, 2014
I
. 'il II
[.
i
i '
[ �
�. �!
[ ' ,
[ � '
[ �
[ '�
C !,
[ '�
C �'I
[ : !�
III
I, '
�, i
t;
_,
��
Tri-County Regional Planning Commission
- i TABLE OF CONTENTS
September 30, 2014
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
GOVERNMENT AUDITING STANDARDS 5-6
i
SCHEDULE OF FINDINGS AND QUESTIONED COSTS 7-8
SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS g
, 'i
� I'
� ,
[ i
[ �I
[ �I
III'',
[ I',
I '
� �
i �
[ II
II
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 &GAFFNM 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 ON COMPLIANCE FOR EACH MAJOR FEDERAL PROGRAM
AND ON INTERNAL CONTROL OVER COMPLIANCE REQUIRED BY OMB CIRCULAR A-133
To the Board of Commissioners
Tri-County Regional Planning Commission
Lansing, Michigan
Report on Compliance for the 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 Circular A-133 Compliance Supplement that could have a direct
and material effect on the Commission's major federal program for the year ended September 30, 2014. The
Commission's major federal program is identified in the summary of auditor's results section of the accompanying
schedule of findings and questioned costs.
Management's Responsibility
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 program 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 the 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 its major federal
program for the year ended September 30, 2014.
East Lansing•Auburn Hills•St.Johns
- 1 -
[_
i
f
[�
[ �
l II,
l
l
I �I�i
I . !,
. ��
[ .
� , i
{ I
[ .
� .
I .
1 ,
� ,
� ,
Report on Internal Control Over Compliance
Management of the Commission is responsible for establishing and maintaining effective internal control over
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.
i
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, 2014, and the related notes to the financial statements, which
collectively comprise the Commission's basic financial statements. We issued our report thereon dated
December 12, 2014, 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
December 12, 2014
2
�,
[� �
[,
� ���
� �
�� !I
� I'
E �'
� �
� :
� �
l . III
'�
ICI
�_
� : '
' � ;
� �
i
N LO LO LD (M O O V co O D)
7
O Dom) is ((DD , N O N (CD r W
'O N V O Cl) ^ N O
a) M N
W 69
W M I� i i i i i i LO LO
LO O N aD -
O N O 0).
W Oi h
p C Cl) N I,Cl)a) .0 N 1- 1
a w en
LL) O O) LO O O O O d' LO -T
O) O O) U) O O O O LO I,- N
O O OD V ONOO Ln M O
Nm d) O ti (D O Ln O O O LLB
O coO LO O) O c- O O co LO d)
QE O �-- LO N Cl)
j Q (O' Cl)
'..
C > _
Q m O c- NNNN0 �
y p Cl) CA
m � Nc- (0NN
"t $ LO u)
E o f- c E o 0 0 0 0 0 CD 0
p w N m 3 0 a o 0 0
L N N N N
li U LL O Ln U� Z N N M
O aCC j
ONm
_ a O NNNN N NO EU)
m w Q a) N Cl) LO 00
LL p o M
3 T O (p
ED a) w -D C_J Z N O
a XaX w
W `m cc
O LL a) O
O O n O
- w 0 Z m
F m O
❑ f E
w
U E o
CD Z ` U) O S
H Z w W
Iii0) Cp W d Z O 0 CD O 0
H N Oow O Q O c r Q ('
OP cw OQ I- rWw E w LIJ o. a)c O Q O z a`�i E z Ucc O O ❑ aci
. p a O N m m :G Cl Q �.p QJ a 0) c J '.
m O n� D Cc: Q c= (a K Q E c
U m ❑ E c Q m0 w Z w
m w > a Q U 6 C c w w t ; ❑
❑ 0 N O 2 j [6 O LL 0) a) LL
LL a m ° O m m 0 L a p J Z p a J
E O U) 2 T� Q Q Q Q Q O O C 0
W U O ) O j rn m a) ra 222 '22 H Z a) N
❑ W 2 L) a w w =LL LL LLLLLLLL w N 0
LL
Tri-County Regional Planning Commission 9
NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS `
Year Ended September 30, 2014 I
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. l
(d) Of the federal expenditures presented in the schedule, the Commission provided federal awards to l
subrecipients as follows:
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 $ 156,655
Meridian Township 8,134
Michigan Energy Options 274,824
Michigan Fitness Foundation 11,523
Michigan State University 186,122
Mid-Michigan Environmental Action Council 113,588
National Charette Institute 234,948
TOTAL U.S. HOUSING AND URBAN DEVELOPMENT $ 985,794 —
-4 - 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. PAX: (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 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
To the Board of Commissioners
Tri-County Regional Planning Commission
Lansing, Michigan
We have audited, in accordance with the auditing standards generally accepted in the United States of America
and the standards applicable to financial audits contained in Governmental Auditing Standards issued by the
Comptroller General of the United States, the 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,
2014, and the related notes to the financial statements, which collectively comprise the Commission's basic
financial statements and have issued our report thereon dated December 12,2014.
Internal Control Over Financial Reporting
In planning and performing our audit of the financial statements, we considered the Commission's internal control
over financial reporting (internal control) to determine the audit procedures that are appropriate in the
circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of
expressing an opinion on the effectiveness of the Commission's internal control. Accordingly, we do not express
an opinion on the effectiveness of the Commission's internal control.
A deficiency in internal control exists when the design or operation of a control does not allow management or
employees, in the normal course of performing their assigned functions, to prevent, or detect and correct,
misstatements on a timely basis. A material weakness is a deficiency, or combination of deficiencies, in internal
control such that there is a reasonable possibility that a material misstatement of the entity's financial statements
will not be prevented, or detected and corrected, on a timely basis. A significant deficiency is a deficiency, or a
combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough
to merit attention by those charged with governance.
Our consideration of internal control was for the limited purpose described in the first paragraph of this section and
was not designed to identify all deficiencies in internal control that might be material weaknesses or significant
deficiencies. Given these limitations, during the audit we did not identify any deficiencies in internal control that we
consider to be material weaknesses. However, material weaknesses may exist that have not been identified.
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the Commission's financial statements are free of
material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts,
and grant agreements, noncompliance with which could have a direct and material effect on the determination of
financial statement amounts. However, providing an opinion on compliance with those provisions was not an
objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed an
instance of noncompliance or other matter that is required to be reported under Government Auditing Standards
and which is described in the accompanying schedule of findings and questioned costs as 2014-001.
East Lansing •Auburn Hills• St.Johns
- 5 -
[� I'i
I � �I
` '
fl
[ �I
( '
[ :
I �'
6 :
e
[ : I'
[ � !�
( : �
_ f : '
� ; '
�-
Tri-County Regional Planning Commission's Response to Findings
The Commission's response to the finding identified in our audit is described in the accompanying schedule of
findings and questioned costs. The Commission's response was not subjected to the auditing procedures applied
in the audit of the financial statements and, accordingly,we express no opinion on it.
Purpose of this Report
The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the
results of that testing, and not to provide an opinion on the effectiveness of the Commission's internal control or on
compliance. This report is an integral part of an audit performed in accordance with Government Auditing
Standards in considering the Commission's internal control and compliance. Accordingly, this communication is
not suitable for any other purpose.
ABRAHAM & GAFFNEY, P.C.
Certified Public Accountants
December 12, 2014
. i
l
-6 -
i ,
�,
�_
� '��
� '�
� �
r
� : ��
� ,'
Cu
!�
II'I
� ,
� � '
�. :
r , "'
�:
� :
�;
Tri-County Regional Planning Commission
SCHEDULE OF FINDINGS AND QUESTIONED COSTS
Year Ended September 30, 2014
Section I -Summary of Auditor's Results
Financial Statements
Type of auditor's report issued: Unmodified
Internal control over financial reporting:
Material weakness(es) identified? Yes X No
Significant deficiency(ies) identified? Yes X None reported
Noncompliance material to financial statements noted? Yes X No
Federal Awards
Internal control over major programs:
Material weakness(es)identified? Yes X No
Significant deficiency(ies)? Yes X None reported
Type of auditor's report issued on compliance for major programs: Unmodified
Any audit findings disclosed that are required to be reported with
Section 510(a)of Circular A-133? Yes X No
Identification of major programs:
i
CFDA Number(s) Name of Federal Program or Cluster
i
20.205 Highway Planning and Construction
Dollar threshold used to distinguish between Type A
and Type B programs: $ 300,000
, i
Auditee qualified as low-risk auditee? X Yes No
Section II-Financial Statement Findings
2014-001 POLICIES AND PROCEDURES
Condition: During the course of our audit, we noted that the Commission has not formally adopted written
procedures and policies for the following areas: capital assets policy, investment policy, fraud risk management
policy, business continuity plan, and electronic funds transfer policy.
Criteria: Documenting specific policies and procedures allows employees to have a clearer understanding of
management's expectations.
Cause: The Commission has not previously identified a need to adopt policies in these areas.
it
Tri-County Regional Planning Commission j
SCHEDULE OF FINDINGS AND QUESTIONED COSTS -CONTINUED
Year Ended September 30, 2014 [
I
Section II -Financial Statement Findings -Continued [ '
i
2014-001 POLICIES AND PROCEDURES-CONTINUED
Effect: Accounting is an essential function of the Commission. The Commission may have greater risk to this [
function being performed improperly if the related policies and procedures are not documented. Capital assets
represent a substantial amount of the Commission's net position. These resources are necessary for the delivery
of the Commission's services and programs. The Commission may have greater risk with these assets if a capital
asset policy is not adopted. Due to the Commission not developing a fraud risk management policy that would
include a monitoring program it is unable to assess the Commission's vulnerabilities to fraudulent activity whether
any of those exposures could result in material misstatement of financial statements. Due to the investment policy [
not addressing issues as required by GASB Statement 40, the Commission does not address risks that could have
an impact on the Commission's ability to meet obligations as they become due. By not having a business
continuation plan in place, the Commission has no formal plan in place if critical business processes were [
interrupted. Also, by not having an electronic fund transfer policy in place the Commission is not in compliance
with Public Act 738 of 2002 that requires local units of government that utilize electronic transactions to adopt a
written resolution.
Recommendation: We recommend that the Commission adopt and implement an accounting procedures manual [
which will describe and explain accounting policies and procedures.
Corrective Action Response: Management of the Commission has developed an accounting procedures manual ( :
and the policies noted above. The policies and procedures are currently with the Board for review and approval
and are expected to be approved during fiscal year 2015.
Section III -Federal Award Findings and Questioned Costs
None noted. [
- 8 -
[
Tri-County Regional Planning Commission
SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS
Year Ended September 30, 2014
FINDINGS/NONCOMPLIANCE
Control Deficiencies Related to Internal Controls Over the Financial Statements.
2013-2 POLICIES AND PROCEDURES
Condition: During the course of our audit, we noted that the Commission has not formally adopted written
procedures and policies for the following areas: capital assets policy, investment policy, fraud risk management
policy, business continuity plan, and electronic funds transfer policy.
Resolution: This issue was noted during the current audit and repeated in the schedule of findings and
questioned costs as Finding 2014-001. We do not consider this issue resolved.
Findings Related to Compliance with Requirements Applicable to the Financial Statements
2013-1 PAYROLL TIMESHEET APPROVAL PROCESS
Condition: During our testing of internal controls related to the payroll process, it was noted that four(4)out of forty
(40) payroll transactions tested did not have proper approval of timesheets, two (2) out of forty (40) had hours
charged that did not agree to the hours listed on timecards, and one (1) out of forty(40) requested timecards could
not be located by management for audit. While the disbursements appeared appropriate and allowable, this is a
control issue.
Resolution: This issue was not noted during the audit process and we consider this issue to be resolved
Findings Related to Compliance with Requirements Applicable to Federal Awards and Internal Control Over
Compliance in Accordance with OMB Circular A-133
No prior audit findings.
I
I
-9 -
[�
�:
�� 'i
[ , I�
[ ''
i
I �
II',I
f � �
[ '
I
C
[:
� '�
� �!
r � �'
� .
� ;
��
� - ��