HomeMy WebLinkAboutIndep Accnts Rprt - Measure A FYE 06-30-2018cc 3T J
STAFF REPORT
CITY OF PALM DESERT
FINANCE DEPARTMENT
MEETING DATE: January 24, 2019
PREPARED BY: Jose Luis Espinoza, CPA, Assistant Finance Director
REQUEST: Receive and file the Independent Accountants' Report on Agreed -Upon
Procedures Performed on the Measure A Transportation Fund for the fiscal
year ended June 30, 2018
Recommendation
By Minute Motion, that the City Council receive and file the Independent
Accountants' Report on Agreed -Upon Procedures Performed on the Measure A
Transportation Fund for the fiscal year ended June 30, 2018.
Strategic Plan Obiective
Not applicable.
Committee Recommendation
The Audit, Investment and Finance Committee received the Independent Accountants' Report at
their January 22, 2019 meeting, and recommended that the report be received and filed by the
City Council.
Backqround
The Measure A fund is a special revenue fund that was created to keep track of funds received by
the Riverside County Transportation Commission. In 1988, Riverside County voters approved a
half cent sales tax, known as Measure A, to fund a variety of highway improvements, local streets
and roads maintenance, commuter assistance and specialized transit projects.
Conrad LLP performed the procedures which were agreed to by the Riverside County
Transportation Commission, Riverside, California (RCTC) solely to assist RCTC with respect to
an evaluation of the City of Palm Desert's Measure A Transportation Fund and degree of the
City's compliance with RCTC requirements for the year ended June 30, 2018.
Staff requests that the Council receive and file the Independent Accountants' Report on
Agreed -Upon Procedures Performed on the Measure A Transportation Fund for the fiscal year
ended June 30, 2018.
\\srv-fil2k3\groups\Finance\Niamh Ortega\Staff Reports\Audit staff reports\Audit Staff Reports 2018\SR - Council audit 2018 Measure
A.docx
Staff Report
Approval of Report on Procedures for Measure A Fund for Fiscal Year ended June 30, 2018
January 24, 2019
Page 2 of 2
Fiscal Impact
There is no fiscal impact associated with this action.
LEGAL REVIEW DEPT. REVIEW FINANCIAL REVIEW CITY MANAGER
N/A
Robert W. Hargreaves Ja t M. Moore Jangt M. Moore Lauri Aylaian
City Attorney Director of Finance Director of Finance City Manager
ATTACHMENTS: Independent Accountants' Report on Agreed -Upon Procedures
JLE:nmo
\\srv-fil2k3\groups\Finance\Niamh Ortega\Staff Reports\Audit staff reports\Audit Staff Reports 2018\SR - Council audit 2018 Measure
A.docx
CITY OF PALM DESERT CALIFORNIA
Report on Agreed -Upon Procedures
Applied to Measure A — Local Streets and Roads
Fiscal Year Ended June 30, 2018
"Om
"'I
Conrad
CERTIFIED PUBLIC ACCOUNTANTS
Independent Accountant's Report
On Applying Agreed -Upon Procedures
The Board of Commissioners
Riverside County Transportation Commission
Riverside, California
We have performed the procedures enumerated below, which were agreed to by Riverside
County Transportation Commission ("RCTC"), solely to assist RCTC in determining whether the
City of Palm Desert, California ("City") was in compliance with the Measure A — Local Streets and
Roads Program grant terms and conditions for the year ended June 30, 2018. The City's
management is responsible for the accounting records. This agreed -upon procedures
engagement was conducted in accordance with attestation standards established by the
American Institute of Certified Public Accountants. The sufficiency of these procedures is solely
the responsibility of those parties specified in the report. Consequently, we make no
representation regarding the sufficiency of the procedures described below, either for the purpose
for which this report has been requested, or for any other purpose.
Our procedures and related findings are as follows:
Obtain the 2009 Measure A (Ordinance 02-001) compliance requirements. Western
County jurisdictions are required to participate in the Transportation Uniform Mitigation
Fee ("TUMF") program and in the Multi -Species Habitat Conservation Plan ("MSHCP")
which are administered by the Western Riverside Council of Governments ("WRCOG")
and the Western Riverside County Regional Conservation Authority ("RCA"), respectively.
Coachella Valley jurisdictions are required to participate in the TUMF program
administered by the Coachella Valley Association of Governments ("CVAG"). Indicate
participation in TUMF and/or MSHCP programs.
Finding: No exceptions were noted as a result of applying this procedure. The City
participates in the TUMF program administered by CVAG.
Obtain the City's approved 5-Year Capital Improvement Plan ("CIP") from RCTC for the
fiscal year ended June 30, 2018.
Finding: No exceptions were noted as a result of applying this procedure.
3. Obtain a detailed general ledger and balance sheet from the City for the fiscal year ended
June 30, 2018.
a. Identify the amount of Measure A cash and investments recorded at June 30, 2018.
Compare amount to Measure A fund balance and provide an explanation for any
difference greater than 25% fund balance.
Finding: Measure A cash and investments were $36,702,635 (which includes cash
with fiscal agent in the amount of $15,393,231) at June 30, 2018. The difference
23161 Lake Center Drive, Suite 200. Lake Forest, CA 92630 • T: (949) 552.7700 • www.conradilp.com
1
Board of Commissioners
Riverside County Transportation Commission
Riverside, California
between Measure A cash and investments of $36,702,635 and fund balance of
$21,970,019 is $14,732,616 or 67% of the fund balance. The variance is due to
unearned revenue of $15,393,231, accounts payable of $130, and due from other
governments of $660,745.
Cash with fiscal agent in the amount of $15,393,231 is for the CVAG-Portola
Interchange project, which is held in CVAG's California Asset Management Program
(CAMP) account. These funds are RDA bond funds for an approved project with no
repayment expected from Measure A.
b. Identify amounts due from other funds.
Finding: There were no amounts due from other funds at June 30, 2018.
c. Identify the components of ending fund balance for Measure A activity.
Finding: Ending fund balance for Measure A activity was restricted in the amount of
$21,970,019 at June 30, 2018.
d. Identify the existence of any restatement of Measure A fund balance and inquire of
management as to the reason for any restatement.
Finding: We noted no restatement of Measure A fund balance at June 30, 2017.
4. Obtain an operating statement for Measure A activity for the fiscal year ended June 30,
2018 (see Exhibit A), including budget amounts.
a. Review the revenues in the operating statement.
i. Inquire of management as to what fund was used to record Measure A revenues
received from RCTC and document total revenues for the fiscal year ended June
30, 2018.
Finding: The City accounts for Measure A revenues in its Measure A Fund (Fund
#213). The City recorded total revenues in the amount of $3,295,835 for the fiscal
year ended June 30, 2018.
ii. Obtain a listing of Measure A payments made from RCTC to the City. Compare
the Measure A revenues recorded by the City to the listing of payments made by
RCTC.
Finding: We identified the following variances between the Measure A revenues
recorded by the City and the RCTC Measure A payment schedule.
2
Board of Commissioners
Riverside County Transportation Commission
Riverside, California
City of
RCTC Palm Desert
Measure A revenue recorded $ 2,665,356 $ 2,765,692
2017 clean up adjustment payment - (100.336)
Measure A revenue reconciled $ 2,665,356 $ 2,665,356
The difference is due to a fiscal year 2017 clean up adjustment payment from
RCTC in the amount of $100,336 recorded by the City in fiscal year 2018.
iii. Determine the amount of interest allocated to Measure A activity for the fiscal year
ended June 30, 2018.
Finding: The City allocated interest in the amount of $254,693 to the Measure A
activity for the fiscal year ended June 30, 2018.
b. Review the expenditures in the operating statement.
i. Inquire of management as to what fund is used to record Measure A expenditures
and document total expenditures for the fiscal year ended June 30, 2018.
Finding: The City accounts for Measure A expenditures in its Measure A Fund
(Fund #213). The City recorded total expenditures in the amount of $2,871,083 for
the fiscal year ended June 30, 2018.
ii. Select expenditures for testing that comprise at least 20% of total Measure A
expenditures.
Finding: The City recorded Measure A expenditures in the amount of $2,871,083.
We selected $706,689 or 25% for testing.
1. For the expenditures selected for testing, compare the dollar amount recorded
in the general ledger to the supporting documentation.
Finding: No exceptions were noted as a result of applying this procedure.
2. For the expenditures selected for testing, review the 5-Year CIP and note
whether the projects claimed were included in the 5-Year CIP and whether they
constitute allowable costs.
Finding: Expenditures selected for testing were included in the 5-Year CIP and
were allowable costs. No exceptions were noted as a result of applying this
procedure.
iii. Inquire of management as to the nature of any transfers (in and out) recorded in
the Measure A Fund. For any transfers out, determine if nature of transfer out was
included in the 5-Year CIP.
3
Board of Commissioners
Riverside County Transportation Commission
Riverside, California
Finding: There were no transfers recorded in the Measure A Fund that were noted
as a result of applying this procedure.
iv. Inquire of management as to the amount of general or non -project -related costs, if
any, included in expenditures. If indirect costs exceed 8% of Measure A revenue,
inquire of management as to the basis for indirect costs charged to Measure A. If
indirect costs are identified, determine if such costs are included in the 5-Year CIP.
Finding: Per discussion with management, there were no indirect costs recorded
for the fiscal year ended June 30, 2018.
v. Inquire of management as to the amount of debt service expenditures recorded in
the Measure A fund.
Finding: There were no debt service expenditures recorded in the Measure A Fund
that were noted as a result of applying this procedure.
1. For cities with advance funding agreements with RCTC, compare debt service
expenditures to Measure A payments withheld by RCTC.
Finding: There was no advance funding agreement with RCTC noted.
2. For cities with other indebtedness, determine if such costs are included in the
5-Year CIP.
Finding: There were no debt service expenditures recorded in the Measure A
Fund that were noted as a result of applying this procedure.
5. Compare budgeted expenditures to actual amounts and inquire of management as to the
nature of significant budget variances.
Finding: The following schedule compares budgeted expenditures to actual amounts.
Budget Actual Variance
Construction and maintenance $ 29,986,596 $ 2.871,083 $ 27,115,513
Total expenditures $ 29,986,596 $ 2,871,083 $ 27,115,513
Per discussion with City management, the construction and maintenance variance is due
to projects not commencing as anticipated, and was mainly attributed to the Portola
Interchange at 1-10, Cook Street Improvements, and San Pablo Street Improvements
projects not being started or in the beginning stages at June 30, 2018.
6. Obtain from RCTC a listing of jurisdictions that participate in the Western County or
Coachella Valley TUMF programs.
4
Board of Commissioners
Riverside County Transportation Commission
Riverside, California
a. If the jurisdiction is a participant in the TUMF program, select at least one
disbursement for validation as to the amount remitted to WRCOG or CVAG, as
applicable.
Finding: We selected one disbursement of $40,236 for validation. The payment
selected for testing indicated that the TUMF is collected and remitted to CVAG as
required.
b. Indicate the total amount of TUMF fees collected and remitted during the fiscal year
ended June 30, 2018.
Finding: The total amount of TUMF fees collected and remitted during fiscal year
ended June 30, 2018 were $236,191 and $198,931, respectively. The $37,260
variance between TUMF fees collected and remitted was due to a June 2018 TUMF
payment remitted in July 2018.
7. Obtain from RCTC a listing of jurisdictions that participate in the Western County MSHCP
program.
a. If the jurisdiction is a participant in the Western County MSHCP program, select at
least one disbursement for validation as to the amount remitted to RCA.
Finding: The City is not a participant in the Western County MSHCP program.
b. Inquire of management as to the existence of any fees collected in prior years that
were not remitted to RCA by the end of this fiscal year.
Finding: The City is not a participant in the Western County MSHCP program.
c. Indicate the total amount of Western County MSHCP fees collected and remitted
during the fiscal year.
Finding: The City is not a participant in the Western County MSHCP program.
8. Obtain from RCTC the Maintenance of Effort ("MOE") base year requirement, including its
supporting detail calculations for the City, and the carryover amount allowed as of the
beginning of the fiscal year.
a. Obtain from the City a calculation of its current year MOE amount in a format similar
to its base year calculation. See Exhibit B.
Finding: No exceptions were noted as a result of applying this procedure.
b. Compare the current year MOE amounts from the General Fund to the general ledger.
Finding: No exceptions were noted as a result of applying this procedure.
5
Board of Commissioners
Riverside County Transportation Commission
Riverside, California
c. Scan the General Fund general ledger to determine if there were any transfers in to
fund any MOE amounts.
Finding: No transfers in were noted as a result of applying this procedure.
d. Compare the amount of current year MOE expenditures to the MOE base requirement
and add any excess to, or subtract any deficiency from, the carryover amount.
Finding: We noted that current year MOE expenditures of $3,431,622 were greater
than the MOE base requirement of $2,398,146 resulting in an excess of $1,033,476
for fiscal year ended 2018.
e. If the amount of discretionary funds spent is less than the MOE base requirement
("MOE deficiency"), determine the amount of any prior year MOE carryover using the
information obtained from RCTC and reduce the MOE deficiency by any available
MOE carryover to determine an adjusted current year expenditure amount.
Finding: No exceptions were noted as result of applying this procedure. The City's
discretionary funds spent in the fiscal year ended June 30, 2018 exceeded the MOE
base year requirement. The City's MOE carryover at June 30, 2018 is calculated as
follows:
MOE excess at July 1, 2017 $ 8,445,638
Current year MOE expenditures 3,431,622
Less: MOE base requirement (2.398.146)
Excess MOE for fiscal year ended June 30, 2018 1.033.476
MOE excess at June 30, 2018 $ 9,479,114
We were not engaged to, and did not, conduct an examination, the objective of which would be
the expression of an opinion on the accounting records. Accordingly, we do not express such an
opinion. Had we performed additional procedures, other matters might have come to our attention
that would have been reported to you.
This report is intended solely for the information and use of the Board of Commissioners and
management of RCTC and the City Council and management of the City of Palm Desert and is
not intended to be, and should not be, used by anyone other than these specified parties.
i
Lake Forest, California
November 15, 2018
0
CITY OF PALM DESERT, CALIFORNIA
Measure A Operating Statement
Fiscal Year Ended June 30, 2018
(Unaudited)
Revenues:
Measure A
Reimbursements from other agencies
Reimbursements from SARDA
Interest income
Other revenue
Total revenues
Expenditures:
Construction and maintenance
Total expenditures
Excess of revenues
over expenditures
EXHIBIT A
Variance From
Final Budget
Favorable
Budget Actual (Unfavorable)
$ 2,660,000 $ 2,765,692 $ 105,692
- 200,450 200,450
3,165,000 - (3,165,000)
73,000 254,693 181,693
- 75,000 75,000
5,898,000 3,295,835 (2,602,165)
29,986,596 2,871,083 27,115,513
29,986,596 2,871,083 27,115,513
$ (24,088,596) $ 424,752 $ 24,513,348
7
n N
O N
O (D m
O O OO
N
W
LLY� ONO 01
N
O N
N
O
10
O
2
O
U
E
Q
w
N
y
N
a coON O OO
3 W 7 n fD m OD O
04 OD
LL i07 R 0) O)
> N
in
y
m
y�
U
�
N
0
�
ro
t
C
�
Oct
a
OO
v
N
V
Y
N
N
N
N
N
c
N
R
m
N
x
W
m
'
O7
C
v
a
c
LL
0 m
LL
N
>
t
mnnci_
mN m �n
COO,
c
pp
iri �
a
Di of c•i o
v c4
n
�
0
O
M Na)
N
N
a
05
N
0
05
Q
O
N
Z m
CV)9
N O n n m m
m
OO
tD m
00 CD N tD CD
w O
O N
d
C
c
O O O O O—
N fD 7 tD ID
0 In
V
N
t0
OD
j
V V
N N
1D Y N n
OO Cl! fD V
LL O
LL
M w n
m tD 0 n 1D O9
NV)
OD
A
U.
N N
m m
M N OO M
OD M O) to
_
O7
W
lr N O
N
N
N
h
`)
N N
N N
n N Y O7 O
iD N <7 N
V =
U
0
C
m
10
U1
w
N
w
w w;
N O W
m O O n n 0 �A n N
O C
O
n N ao ao Of N O m
O N n n n tD m a0 O
O) W O m O M n
N N N V N N Of LD
N
N
N N
Go
Q C
N iD OV 00
bi tD Oi In fD O m 0
N
h
N N-
G
N
OD 0)W
N N
m P.- 00 m m
h OD N N N
OD
N
m
OO
co m
N (14
N
N �Q
N <
N
—
N N
y�
di
a.
LL
U
9 C
LL
m
CC
p
w
O
C)1
.p�
E
ULL
C
~
u p
LL p a
N
0.
a
j
"0
o
w
�
w
N
w
i i
m
o)
>
>
J
°L
C
Q
C
c
C
L
m
Q
O
C
N
L
Z
W
4
N
Im
m
r`
`w E d
E d
d
>
W
m
a 0 E
°A
0�
c
U m
m
H
c E a o
c
O
w c V
m E E
Rp
�
ci
q d
d o m d
E °° u
n
A
c
'E
5
c
'-
y
ti
00 C
Y
c o E
7
>
�°
A m A o7} d
6 c q i mom' m
Q
ai o
w
p u p
ei
Q
a
N
p
u
.[per
r
C
W y O C C C lJ r>? E
�+ y 2
N C W 6 C g d
C N? C L
C q Y (D m m d
7,
N
iA
ca 9 A 3� �^
�j
�i¢yl
}
CC
m c m m o 'o
LL
O
WCA
CQ U
i
WH
m