HomeMy Public PortalAbout02 February 14, 2007 Budget & Implementation(.1
79686
RIVERSIDE COUNTY TRANSPORTATION COMMISSION
BUDGET AND IMPLEMENTATION COMMITTEE
AUDIT AD HOC COMMITTEE
AGENDA
Wednesday, February 14, 2007
11:30 a.m. (following Commission meeting)
COUNTY OF RIVERSIDE ADMINISTRATIVE CENTER
4080 Lemon Street, 3' Floor
Riverside, California
Conference Room B
1) TDA and Measure A Audit Results
Overview
This item is for the Committee to:
1) Receive and file the TDA and Measure A Audit Results
Report;
2) Forward to the Budget and Implementation Committee,
and
3) Forward to the Commission for final action.
2) Postretirement Health Benefits Liability and Funding
Overview
This item is for the Committee to:
1) Receive and file a report on the status of the calculation
of the Commission's postretirement health benefits
liability and related funding issues.
11.36.06
AGENDA ITEM 1
J
i
RIVERSIDE COUNTY TRANSPORTATION COMMISSION
DATE:
February 14, 2007
TO:
Audit Ad Hoc Committee
FROM:
Theresia Trevino, Chief Financial Officer
THROUGH:
Anne Mayer, Deputy Executive Director
SUBJECT:
Fiscal Year 2005/06 TDA and Measure A Audit Results
STAFF RECOMMENDATION:
This item is for the Committee to:
1) Receive and file the Transportation Development Act (TDA) and
Measure A. audit results report for the Fiscal Year 2005/06•
2) Forward to the Budget and Implementation Committee, and
3) Forward to the Commission for final action.
BACKGROUND INFORMATION:
In April 2003, Caporicci & Larson (C&L) was selected to perform the audits of
Riverside . County's TDA claimants and Measure A recipients, except for the
Riverside Transit Agency which elected to select its audit firm. This is the fourth
year that C&L has performed these audits for the Commission; however, it: did not .
perform the audit for the city of Beaumont. In October 2005, the city of Beaumont
was notified by the Commission to engage an audit firm to _perform the financial
and compliance audits of its transit and transportation funds commencing with
fiscal year (FY) 2003/04. C&L has completed the audits of and issued the audit
reports for most of the local governments, non-profit agencies, and transit agencies
that received TDA and Measure A funds.
Professional auditing standards require the auditors to communicate to the audit
committee, or an equivalent group, to ensure additional information is provided
regarding the scope and results of the audit that may assist in overseeing
management's financial reporting and disclosure process related to the TDA
claimants and. Measure A recipients. Such communications related to C&L's
responsibilities and approach, summary of results, and preliminary findings will be
discussed by Caporicci & Larson. Following are highlights of the presentation:
Of the $1' 27,052,000 distributed related to Measure' A, State 'Transit
-Assistance, and Transportation Development. Act, $84,494; 000, or :66.5 %,
was audited by C&L. This comprised 33 recipients who received fundsfor
transit, local streets and roads, and bicycle and pedestrian project purposes.
$42,540, or 33.5%`, was not audited. The majority of these disbursements
were related to TDA planning and administration funds :to agencies, including
the Commission.
As .of February 7, 2007, 33 .reports were issued. Issuance of two reports
was -pending- approval bythe cities of Hemet and;, Moreno Valley., .Fieldwork
was substantially completed for one additionaltioreci;pients; issuance of -this
final . report for Care -A -Van was pending resolution of open items and
completion of quality review procedures.
Findings and observations will be discussed.
Attached is the summary of transportation and transit fund operations ;and related
audit results for the various types of TDA (Articles 3, 4, and 8) .and Measure :A'
`(specialized transit and local streets and roads) funding. Each schedule provides
information for each claimant and recipient regarding the revenues,
expenditures/expenses, and change in fund balance/net assets for the year ended
June 30, 2006; other financial and compliance information; summary of
observations and findings; and other information pertaining to .the status or scope
of work performed.
Attachments:
1) Transportation Development Act Article 3 Schedule
2) Transportation Development Act Article 4 Schedule
3) Transportation Development Act Article 8 Schedule
4) Measure A Specialized Transit Schedule
5) Measure A Local Streets and Roads Schedule and. Comments'
•
Transportation Development Act Article 3 Schedule
Year Ended June 30, 2006
Cathedral Desert Hot Moreno Palm County of
Banning City .Corona Springs Hemet Indio La Quinta Valley Springs : Perris Riverside Riverside Temecula
DRAFT DRAFT
Revenues:.
Intergovernmental allocations:
Article 3 $ 202,500 $ 59,258 $107,1.83 $ 30,000 $ 16,707 $ - $ 62,991 $ . 21,550 $ 72,897 $ - $ 186,227 $ 88,973 $ 34,873
Other - - , - - - 100,000 - - .
Other revenues 214,411 - - 9,604 - 235 - 100,000 - -
Interest income 490 (194) - - - 6,973 - - - 477 583
Total revenues 417,401 _ 59,064 107,183 30,000 26,311 62,991 128,758. 72,897 100,000 186,227 89,450 35,456
Total expenditures 416,911 64,639 107,183 30,000 156,945 62,991 21,550 72,897 186,227 89,450 35,456
Excess (deficiency) of revenues over
(under) expenditures _ 490 (5,575) (130,634) 107,208 100,000
Fund balances at beginning of year 4,881 - 167,944 - (53,475)
Fund balances at end of year $ 5,371 $ (5,575) $ $ - $ (130,634) $ - $ - $ 275,152 $ - $ 46,525 $ $ - $
Deferred revenues at end of year $ - $ - $ $ 130,634 $ 1,465 $ - $ 43,668 $ - $ $ 98,607 $1.53,858 $
Source: 2006 Financial Statements
Summary of Observations (Article 3 allocations are for specific bicycle and pedestrian proiects approved by the Commission)
1 Banning fund balance relates to excess transfers from other city funds as a match for grant funds.
2 Cathedral City deficit fund balance to be funded by transfer from other city funds, per city disclosure in financial statements.
3 Desert Hot Springs Audit Finding 2006-1 related to City not spending Article 3 interest on Article 3 expenditures of 2005 carryover funds:
4 Hemet deficit fund balance is related to deferred revenue balance. Amounts result from revenue recognition policy that revenues not received within 60 days after year end are not recognized
as current year revenues. .
5 Indio retumed $1,357 to RCTC on 10/20/06. Difference relates to interest which may be used on future Article 3 projects.
6 Moreno Valley -fund balance is related to accumulation of transfers from city's Measure A fund. Audit Finding 2006-1 related to City not spending Article 3 interest on Article 3 expenditures as
interest eamed is recorded in Measure A fund since most of cash is related to excess Measure A transfers.
7 Perris has a fund balance of $46,525, which city has indicated will be paid back to city's Measure`A funds in fiscal year 2007. Amount relates to Measure A transfer in excess of 2005 deficit
fund balance.
8 Moreno Valley, Riverside, and County will be requested .to provide details on projects that such unexpended funds. are related to.
Section 99234 2/8/2007
Total operating revenues
Operating expenses:
Depreciation and amortization.
Other operating expenses
Total operating expenses
Operating loss
Nonoperating revenues (expenses):
Grants:
Transportation Development Act Article 4 Schedule
Year Ended June 30, 2006
(Note 1) (Note 2)
Banning Beaumont Corona Riverside PVVTA SunLine_ . RTA
$ 125,736 $ 243,334 $ 238,118 $ 63,051 $ 3,192,357 $ 7,145,886
236,909 147,242 406,450 90,828 1,863,234 6,730,744
1,044,316 1,516,339 2,511,251 775,187 18,487,874 41,489,354
1,281,225 1,663,581 2,917,701 866,015 20,351,108 48,220,098
(1,155,489) (1,420,247) (2,679,583) ' (802,964) (17,158,751) (41,074,212)
Local: Transportation Funds 925,578
State Transit Assistance 9,430
Federal
Measure A specialized transit
Other .
Interest income
Interest expense (6,734)
Settlement of lawsuit (Note 9)
Transfers in (out) -
Gain (loss) on sale of property 796
Recovery of bad debt to affiliate
Other
Total nonoperating revenue (expense) 929,070 1,598,592 2,785,622 777,115 20,562,017 44,336,072
Net increase (decrease) (226,419) 178,345 106,039 (25,849) 3,403,266 3,261,860
Net assets at beginning of year 816,823 1,278,071 692,645 362,024 7,978,330 34,797,119
Net assets at end of year $ 590,404 $ $ 1,456,416 $ 798,684 $ 336,175 $11,381,596 $ 38,058,979
1,105,834 2,249,481 710,886 10,359,699 28,926,373
106,500 93,032 72,269 808,595 1,316,130
348,069 440,586 5,152,361 11,896,259
- 3,764,919 -
10,000 - 1,069,632
12,902 '`` 5,302 147,831 444,913
- (32,519) (457,300)
- - 522,456
20,134 - 12,800 - -
5,153 (205) (152,202) 1,501
(9,123)
2,728 (34,142) - 1,138,564
Deferred revenue at end of year:
Operating $ .44,717 $ 157,883 $ 103,928 $ 11,202 $ 892,415 $ 707,428
Capital 106,531 112,991 125,278 69,755 5,510,474 2,177,048
Total deferred revenue at end of year $ 151,248 $ - $ 270,874 $ 229,206 $ 80,957 $ 6,402,889 $ 2,884,476
Required fare ratio 10.00% 20.00% 10.00% 10.00% 17.22% 17.73%
Actual fare ratio 12.10% 20.30% 10.00% 11.00% 21.97% 19.34%
Fare ratio compliance status Met Met Met Met Met Met
Source: 2006 Financial Statements
Note 1 Beaumont's 2005 and 2006 audits have not been completed by city's auditors.
Note 2 RTA elected to select its independent public accounting firm, which met the requirements set forth by.the Commission in January 1998.
Summary of Findings:
1 Banning incurred interest expense and Riverside recorded no interest income due to timing in filing of TDA claims.
2 Riverside Audit Finding 2006-1 was related to $90,102 of prior years' excess operating expenditures being applied against deferred operating revenue balances without SRTP amendment and RCTC
approval. City is in process of requesting amendment and approval,
3 PVVTA had two audit findings. Finding 2006-1 was related to receipt of capital funds in excess of capital and debt service requirements. Finding 2006-2 was related to Agency's inability to segregate
revenues and expenses for new and altered routes that qualify for exclusions from the fare ratio calculation. It wee determined that lack of segregation of revenues and expenses would not have
affected compliance with the fare ratio requirement.
Section 99260 2/8/2007
"
T r a n s p o r t a t i o n D e v e l o p m e n t A c t A r t i c l e 8 S c h e d u l e
Y e a r e n d e d J u n e 3 0 , 2 0 0 6
C o u n t y o f
B l y t h e R i v e r s i d e
R e v e n u e s :
I n t e r g o v e r n m e n t a l a l l o c a t i o n s :
A r t i c l e 8 $ , $
O t h e r r e v e n u e s 2 0 5 , 2 9 6
I n t e r e s t i n c o m e 1 6 , 6 4 4
T o t a l r e v e n u e s 2 0 5 , 2 9 6 1 6 , 6 4 4
T o t a l e x p e n d i t u r e s 4 9 1 , 9 9 7 1 6 1 , 2 5 2
E x c e s s ( d e f i c i e n c y ) o f r e v e n u e s o v e r ( u n d e r ) e x p e n d i t u r e s ( 2 8 6 , 7 0 1 ) ( 1 4 4 , 6 0 8 )
F u n d b a l a n c e s a t b e g i n n i n g o f y e a r ( 5 4 4 , 1 7 3 ) 5 5 5 , 5 6 5
F u n d b a l a n c e s a t e n d o f y e a r $ ( 8 3 0 , 8 7 4 ) $ 4 1 0 , 9 5 7
S o u r c e : 2 0 0 6 F i n a n c i a l S t a t e m e n t s
S u m m a r y o f O b s e r v a t i o n s ( A r t i c l e 8 a l l o c a t i o n s f o r W e s t e r n C o u n t y a n d C o a c h e l l a V a l l e y e n d e d i n 1 9 9 3 a n d 1 9 8 7 , r e s p e c t i v e l y , a s a v a i l a b l e L T F f u n d s a r e .
n o w u s e d t o m e e t t r a n s i t n e e d s . A r t i c l e 8 a l l o c a t i o n s f o r P a l o V e r d e V a l l e y a r e s u b j e c t t o a n a n n u a l u n m e t n e e d s h e a r i n g . )
1 B l y t h e h a s h a d s i g n i f i c a n t n e g a t i v e f u n d b a l a n c e f o r a f e w y e a r s . E x p e n d i t u r e s w e r e n o t b u d g e t e d f o r . N o d i s b u r s e m e n t s o f A r t i c l e 8 r e v e n u e t o B l y t h e h a v e b e e n m a d e t h r o u g h 2 0 0 6 d u e
t o u n m e t n e e d s i n P a l o V e r d e V a l l e y . A t 9 / 1 4 / 0 6 C o m m i s s i o n m e e t i n g , R C T C a p p r o v e d a l l o c a t i o n o f a v a i l a b l e P a l o V e r d e V a l l e y T D A m o n i e s f o r l o c a l s t r e e t s a n d r o a d s f o r B l y t h e a n d
C o u n t y . B l y t h e '