HomeMy WebLinkAboutStaff Report 471-08TO:
ATTENTION:
FROM:
DATE:
HONORABLE CITY COUNCIL .
FINANCE COMMITTEE
CITY MANAGER DEPARTMENT: ADMINISTRATIVE
SERVICES
DECEMBER 16, 2008 CMR: 471:08
REPORT TYPE: Recommendation
SUBJECT:
Recommendation Regarding Adoption of Ordinance Authorizing
Closing of the Budget for the Fiscal Year Ending June 30, 2008,
including Reappropriation requests, Closing completed capital
improvement projects, Authorizing transfers to reserves and
Approval of Comprehensive Annual Financial Report (CAFR)
RECOMMENDATION
Staff recommends that the Finance Committee review, provide input, and forward the attached
ordinance (Attachment A) and associated exhibits to the City Council for its approval to: close
the 2008 Budget; authorize re -appropriation of 2008 funds into the 2009 Budget (Exhibits A &
B); close completed capital improvement projects (Exhibit C); and transfer remaining balances to
the appropriate reserves (Exhibits D & E for General Fund and Exhibits F & G for Enterprise
Funds). In addition, staff recommends the Finance Committee review and forward to the City
Council for its approval the City's Comprehensive Annual Financial Report (CAFR)
(Attachment B).
BACKGROUND
The attachments to this report provide the necessary documents for closing the 2008 fiscal year
budgets and reauthorizing 2008 funds for the current fiscal year 2009. In addition, they provide
detailed information on the City's financial activities for 2008. This report highlights the key
fiscal issues impacting the City of Palo Alto and identifies where the reader can find more
comprehensive explanations for these issues. The Management Discussion and Analysis
(MD&A) chapter of the CAFR (Attachment B) also provides an easy -to -read, thorough
discussion and analysis of the City's current fiscal health. It includes financial statements,
performance information that is compared to the prior year, and capital asset and debt
administration data.
CMR: 471:08 Page 1 of 5
DISCUSSION
Overall, the following summarizes changes to the City's reserves:
• The General Fund Budget Stabilization Reserve (BSR) is 18 percent of budgeted
expenditures. This percentage is within the Council approved guidelines of 15 to 20
percent and shows a closing balance of $26.1 million, a decrease of $1.4 million from the
prior year.
• The Infrastructure Reserve has a final balance of $17.9 million at the end of 2008.
• Budget transactions included in the attached ordinance increased General Fund reserves
by $0.2 million (Exhibit A).
• The City provides medical coverage for retirees and their spouses. In 2008, the City of
Palo Alto was required (Government Accounting Standards Board Statement 45) to
recognize in its financial statements any unfunded, earned retiree medical costs including
those for current active employees. The Citywide liability for retiree medical costs is
$102.2 million. Staff received City Council approval to establish an irrevocable trust with
California Employers Retirees Benefit Trust (CERBT) and fund the Trust with
contributions of $33.8 million, lowering the liability to $68.4 million. The annual
contribution for 2008 was $9.3 million. The actuarial study estimates a reduced annual
contribution of $7.7 million for future years after consideration of the contributions made
to the trust (CAFR Note 12).
Economy
The U.S. economy is facing critical challenges; a weakening economy, a tight credit market,
rising unemployment, declines in taxes and a loss of consumer confidence. During 2008, the
local economy was somewhat immune from these challenges, however this is not expected to
continue.
Expected declines in sales tax, transient occupancy taxes and other sources of revenue combined
with potential increases in expenditures will present financial challenges for the City in 2009.
Additional details on future revenues and expenditures can be found in the updated Long Range
Financial Forecast 2009-19. The City has been proactive in the past in dealing with these
challenges. Currently, it is working with Stanford Shopping Center to expand its retail space and
to build a new hotel on its premises. The City increased the transient occupancy tax rate from 10
to 12 percent in January 2008 and is considering a Business License Tax. The City will continue
to remain vigilant to maintain its sound financial practices. (MD&A pp 3-4 Transmittal Letter p.
vi)
Results by Fund
General Fund
For 2008, the General Fund had a net gain of $3.0 million compared to a net gain of $5.2 million
the prior year. Increases were primarily due to revenue increases in property taxes, utility user
tax, transient occupancy tax, rental income and the year-end adjustment to the carrying value of
investments. At fiscal year-end, the fund balance for the General Fund totaled $42.4 million.
This was comprised of: $12.2 million reserved for encumbrances, notes, prepaid expenses,
CMR: 471:08 Page 2 of 5
unrealized gain and inventory; $26.1 million for the Budget Stabilization Reserve; $3.5 million
for the Equity Transfer Stabilization Reserve; and $0.6 for re -appropriations. (Exhibit E)
(MD&A pp. 14-16).
Capital Projects Fund
For fiscal year 2008, the Capital Projects Fund reported $21.7 million in expenditures and other
uses, an increase of $4.5 million from prior year. This level of expenditures is consistent with the
City's effort to rehabilitate and maintain its existing infrastructure. The Capital Projects fund
balance totaled $38.3 million, a decrease of $2.8 million. As of June 30, 2008, the Infrastructure
Reserve balance was $17.9 million, an increase of $2.1 million from prior year. A number of
completed and closed projects with remaining balances at the end of fiscal year 2008 totaling
$231,282 (Exhibit C) were returned to the Infrastructure Reserve. This provided an additional
source of revenues to the IR. (MD&A p. 16)
Enterprise Funds
The Rate Stabilization Reserves (RSRs) for the combined Enterprise Funds decreased by a net
$7.9 million. Major changes include a $9.8 million decrease in the Electric Fund, primarily due
to an $8.6 million increase for utility purchases. The reason for this was the low hydroelectric
generation caused by the dry weather season causing the City to purchase power at market rates.
The Gas Fund had a $3.7 million increase primarily due to a 9.5 percent rate increase.
Wastewater Treatment Fund had an increase of $5.3 million, which brought the ending RSR
balance to a negative $7.3 million compared to a negative $12.6 million the prior year. The
negative balance is due to construction costs for the reclaimed water pipeline project.
Construction costs will be offset by future grant and partner revenues. Once the revenues are
received the reserve should continue to increase and return to a positive balance by the end of
2009. The Storm Drain Fund had a decrease of $3.6 million. The reserve has been negatively
impacted by the start up of storm drain improvement projects. The additional increase in income
in future years should return the reserve to a positive level. Exhibit G provides the balance
changes for all reserve categories for the Enterprise Funds. (MD&A p.17)
At the end of fiscal year 2008, a number of Enterprise Fund CIP projects were completed and
closed (Exhibit C). The remaining balances of these projects reverted back to their respective
reserves. Likewise, there were also other Enterprise Fund CIP projects that, though still
outstanding and continuing, returned a portion of their project balance to the reserve because the
project managers deemed that the remaining balances were sufficient to complete the projects
(Exhibit H).
RESOURCE IMPACT
Adoption of the attached budget -closing ordinance (Attachment A) allows for the re -
appropriation and carryover of funding from the 2008 budget so that specific operating programs
and capital projects can be completed in the current fiscal year (Exhibit B). In addition, by
closing completed capital improvement projects, balances (Exhibit C) are returned to the original
funding source for future appropriation. Exhibits D and F summarize financial results for the
General Fund and Enterprise Funds, respectively, by providing an analysis of the performance of
these funds in comparison to the budget as adopted and adjusted by Council. Certain capital
projects that still exist and are continuing have returned a portion of their budget balance to
CMR: 471:08 Page 3 of 5
reserves (Exhibit H), These returns have increased the respective, reserve balance. Exhibit E
reflects the changes to and status of major reserves.
POLICY IMPLICATIONS
This recommendation is consistent with existing City policies.
ENVIRONMENTAL REVIEW
The action recommended is not a project for the purposes of the California Environmental
Quality Act,
CMR: 471:08 Page 4 of 5
PREPARED BY:
TRUDY EIKENBERRY
Accounting Manager, Administrative Services
Assistant Director, Administrative Services
DEPARTMENT HEAD APPROVAL:
CITY MANAGER APPROVAL:
LALO PEREZ
Director, Administrative Services
S KEENE
Manager
ATTACHMENTS
Attachment A: Budget Closing Ordinance
Exhibit A — Detailed Changes to the Adjusted Budget
Exhibit B — Fiscal Year 2008 Re -Appropriation Requests
Exhibit C — Capital Improvement Projects Completed and Closed in Fiscal
Year 2008
Exhibit D — General Fund Summary
Exhibit E — General Fund Reserve Summary
Exhibit F — Enterprise Summaries
Exhibit G — Enterprise Reserve Summary
Exhibit H — Capital Improvement Program Projects Fiscal Year 2008 Year -
End Adjustments
Attachment B: CAFR
CMR: 471:08 Page 5 of 5
ATTACHMENT A
ORDINANCE NO.
ORDINANCE OF THE COUNCIL OF THE CITY OF PALO ALTO
AUTHORIZING CLOSING OF THE BUDGET FOR THE
FISCAL YEAR ENDING JUNE 30, 2008
The Council of the City of Palo Alto does ordain as
follows:
SECTION 1. The Council of the City of Palo Alto finds
and determines as follows:
A. Pursuant to the provisions of Section 12 of Article
III of the Charter of the City of Palo Alto and as set
forth in Section 2.28.070 of the Palo Alto Municipal Code,
the Council on June 11, 2007 did adopt a budget for fiscal
year 2008; and
B. Fiscal year 2008 has ended and the financial
results, although subject to post -audit adjustment, are now
available and are herewith reported in summarized financial
Exhibits "A", "B", "C", "D", "E", "F", "G" and "H" prepared
by the Director, Administrative Services, which are
attached hereto, and by reference made a part hereof.
SECTION 2. Pursuant to Section 2.28.080 of the Palo
Alto Municipal Code, the City Manager during fiscal year
2008 did amend the budgetary accounts of the City of Palo
Alto to reflect:
A. Additional appropriations authorized by ordinance
of the City Council.
B. Amendments to employee compensation plans adopted
by the City Council.
C. Transfers of appropriations from the contingent
account as authorized by the City Manager.
D. Redistribution of appropriations between
divisions, cost centers, and objects within various
departments as authorized by the City Manager.
E. Fiscal Year 2008 appropriations which on July 1,
2007 were encumbered by properly executed, but uncompleted,
purchase orders or contracts.
Page 1 of 6
ATTACHMENT A
SECTION 3. The Council hereby approves adjustments
to the fiscal year 2008 budget for Fund Balancing Entries
as shown on attached Exhibit "A".
SECTION 4. The Council hereby re -appropriates
fiscal year 2008 appropriations in certain departments and
categories, as shown on the attached Exhibit "B", which
were not encumbered by purchase order or contract, at year
end into the fiscal year 2009 budget.
SECTION 5. The fiscal year 2008 encumbered
balances for the departments and categories shown on
Exhibit "D" shall be carried forward and re -appropriated to
those same departments and categories in the fiscal year
2009 budget.
SECTION 6. The City Manager is authorized and
directed:
A. To close the fiscal year 2008 budget accounts in
all funds and departments and, as required by the Charter
of the City of Palo Alto, to make such interdepartmental
transfers in the 2008 budget as adopted or amended by
ordinance of the Council; and
B. To close various completed Capital Improvement
Projects (CIP) as shown in Exhibit "C" and move the
balances of the General Fund completed CIP into the
infrastructure reserve and all other completed CIP to their
respective reserve funds indicated in Exhibit "G"; and
C. To establish reserves as shown in Exhibits
F" and "G" for all Funds as necessary to provide for:
WE„
(1) A reserve for encumbrances and re -
appropriations in the various funds, the
purpose of which is to carry forward into
the fiscal year 2009 budget and continue, in
effect, the unexpended balance of
appropriations for fiscal year 2008
departmental expenditures as shown in
Exhibits "E" and "F"; and
(2) Reserves for Advances to Other Funds,
Stores Inventory, and other reserves in
accordance with ordinance and policy
Page 2 of 6
ATTACHMENT A
guidelines as shown in Exhibit "E"; and
(3) A reserve for general contingencies of such
amount that the City Council has approved;
and
(4) Reserves for utilities plant replacement,
rate stabilization, and other reserves in
accordance with Charter and policy
guidelines as shown Exhibit "G".
D. To fund the Budget Stabilization Reserve and the
Infrastructure Reserve in accordance with the General Fund
Reserves Policy adopted by the City Council; and
E. To fund the Equity Transfer Stabilization Reserve
in accordance with the General Fund Reserves Policy adopted
by the City Council.
SECTION 7. The General Fund Equity Transfer
Stabilization Reserve is hereby increased by the sum of
Sixty Two Thousand Nine Hundred and Thirty Dollars
($62,930) as shown in Exhibit "A", from the Stabilization
Rate Reserves of the Utilities Department Funds as follow:
Utilities Fund
Amount
Electric Distribution
$ 5,741
Electric Supply
$38,300
Gas Distribution
$ 4,539
Gas Supply
$13,350
Total
$62,930
The General Fund Equity Transfer Stabilization Reserve is
increased by $62,930 to $3,528,000.
SECTION 8. The General Fund Budget Stabilization
Reserve Rate Stabilization Reserve is hereby increased by
the sum of One Hundred Seventeen Thousand Five Hundred
Ninety Nine Dollars ($117,599) as described in Exhibit "A".
This transaction will change the balance in the General
Fund Budget Stabilization Reserve to $26,100,000.
SECTION 9. The Emergency Preparedness Fund is hereby
decreased by Four Thousand Six Hundred Seventy Dollars
Page 3 of 6
ATTACHMENT A
($4,670) as described in Exhibit "A". This transaction will
change the Emergency Preparedness Fund Balance to $20,000.
SECTION 10. The Public Services Donation Fund is
hereby decreased by Twenty Five Thousand One Hundred Thirty
Dollars ($25,135) as described in Exhibit "A". This
transaction will change the Public Services Donation Fund
Balance to $674,000.
SECTION 11. The Local Law Enforcement Block Grant
Fund is hereby decreased by Two Thousand Six Hundred
Dollars ($2,600) as described in Exhibit "A". This
transaction will change the Local Law Enforcement Block
Grant Fund Balance to $901.
SECTION 12. The Capital Project Fund Infrastructure
Reserve is hereby increased by One Hundred Thirteen
Thousand Six Hundred Eighty Three Dollars ($113,683) as
described in Exhibit "A". This transaction will change the
Capital Project Fund Infrastructure Reserve to $17,894,000.
SECTION 13. Adjustments
to various Capital
Improvement Projects are made as shown in Exhibit "H".
These changes have impact on the reserve balances and these
impacts are included in Exhibit "A".
SECTION 14. The Electric Supply Rate Stabilization
Reserve is hereby decreased by the sum of Thirty Eight
Thousand Three Hundred Dollars ($38,300), as described in
Exhibit "A". This transaction will change the balance in
the Electric Supply Rate Stabilization Reserve to
$47,309,000.
SECTION 15. The Electric Distribution Rate
Stabilization Reserve is hereby increased by the sum of
Three Million Eight Hundred Twenty Seven Thousand Nine
Hundred Ninety Four Dollars ($3,827,994) as described in
Exhibit "A". This transaction will change the Electric
Distribution Rate Stabilization Reserve to $8,110,000.
SECTION 16. The Electric Fiber Optics Sub -fund Rate
Stabilization Reserve is hereby increased by the sum of One
Hundred Thirty Three Thousand Five Hundred Seventy Two
Dollars ($133,572) as described in Exhibit "A". This
transaction will change the Electric Fiber Optics Sub -fund
Rate Stabilization Reserve to $5,331,000.
Page 4 of 6
ATTACHMENT A
SECTION 17. The Gas Supply Rate Stabilization
Reserve is hereby decreased by the sum of Thirteen Thousand
Three Hundred Fifty Dollars ($13,350) as described in
Exhibit "A". This transaction will change the Gas Supply
Rate Stabilization Reserve to $7,399,000.
SECTION 18. The Gas Distribution Rate Stabilization
Reserve is hereby increased by the sum of Five Hundred
Thirty Eight Thousand Nine Hundred Sixty Three Dollars
($538,963) as described in Exhibit "A". This transaction
will change the Gas Distribution Rate Stabilization Reserve
to $4,735,000.
SECTION 19. The Wastewater Collection Rate
Stabilization Reserve is hereby increased by Twenty Five
Thousand One Hundred Thirty Four Dollars ($25,134) as
described in Exhibit "A". This transaction will change the
Wastewater Collection Rate Stabilization Reserve to
$6,027,000.
SECTION 20. The Water Rate Stabilization Reserve is
hereby increased by the sum of Seven Hundred Forty Five
Thousand Three Hundred Thirty Four Dollars ($745,334) as
described in Exhibit "A". This transaction will change the
Water Rate Stabilization Reserve to $13,111,000.
SECTION 21. The Storm Drainage Rate Stabilization
Reserve is hereby increased by the sum of Seven Hundred
Eighteen Dollars ($718) as described in Exhibit "A". This
transaction will change the Storm Drainage Rate
Stabilization Reserve to $1,383,000.
SECTION 22. The Technology Fund is hereby increased
by One Hundred Thousand Dollars ($100,000) as described in
Exhibit "A". This transaction will change the Technology
Fund Balance to $19,593,000.
SECTION 23. Upon completion of the independent audit,
detailed financial statements reflecting the changes made
by the Sections 7 through 19 of this ordinance shall be
published as part of the annual financial report of the
City as required by Article III, Section 16, of the Charter
of the City of Palo Alto and in accordance with generally
accepted accounting principles.
SECTION 24. As specified in Section 2.28.080(a) of
Page 5 of 6
ATTACHMENT A
the Palo Alto Municipal Code, a two-thirds vote of the City
Council is required to adopt this ordinance.
SECTION 25. The Council of the City of Palo Alto
hereby finds that the enactment of this ordinance is not a
project under the California Environmental Quality Act and,
therefore, no environmental impact assessment is necessary.
SECTION 26. As provided in Section 2.04.330 of the
Palo Alto Municipal. Code, this ordinance shall become
effective upon adoption.
INTRODUCED AND PASSED:
AYES:
NOES:
ABSTENTIONS:
ABSENT:
ATTEST:
City Clerk Mayor
APPROVED AS TO FORM: APPROVED:
City Attorney City Manager
Director of Administrative
Services
Page 6 of 6
Exhibit A
CITY OF PALO ALTO
FISCAL YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIL CHANGES TO THE ADJUSTED BUDGET
Cost Comma 2007-08
Center Item Yearend Adj Description
: ..
GENERAL:FUND
10200000 20520
10200000 20530
10200000 20410
45,041 GFTSR year-end transfer from Electric Fund.
17,889 GFTSR year-end transfer from Gas Fund.
Unused balance of CIP Project PG -08001 (Golf Course Irrigation) returned to General
117,599 Fund which was the funding source of this project.
Source;Changes
180,529:.." . ... ,. .
17300000 33060
17300000 33450
70191001 31220
70191001 33480
70191003 32070
80191002 32990
80191003 31990
80191003 32990
40 Transfer to fund travel & meetings.
4,630 Transfer to fund emergency meals.
1,087 Transfer to fund instruction & training
144 Transfer to fund special events & awards.
5,866 Transfer to fund recreation and housekeeping
2,902 Transfer to fund other supplies and materials.
7,146 Transfer to fund other contract services.
7,990 Transfer to fund other supplies and materials.
Use Changes
29,B0 .' ;
Net Chatiges'.To (From) Reeri,tes
1a5Q,724,:; ;; _ .
Fund. Balancing,Et1trles
10200000 38310
10200000 38220
17300000 36500
19100000 38500
62,930 Transfer Stabilization Reserve
117,599 Budget Stabilization Reserve
(4,670) Change in fund balance
(25,135) Change in fund balance
SPECIAL REVENUE FUND ,LocalLaw:EnfgrcamentBlock,Grant. .
SoUrce Ch"ariges :
0::_.
70249001 32990
70249001 33060
1,160 Transfer to fund other supplies and materials
1,440 Transfer to fund travel and meetings.
Usti! Mangos
2.600':"'.
Net Changes To (FromiReseries
(2,600)
Fund "Bala ncinp"Entries
70249001 38500
(2,600) Change in fund balance
CAPITAL PROJECT FUND
„.
Souree-Changes
,Q:.,
47100000 40110
80471009 38790
50471001 38790
50471010 38790
50471010 38790
50471007 38790
117,599 To return unused balance of CIP Project PG -08001 (Golf Course Irrigation) to General
Fund which was the funding source of this project.
(117,599) To close CIP Protect PG -08001 (Golf Course Irrigation) and return balance to General
Fund
(75,916) To close CIP Projects PD -03003 (Additional Fire Frequency) and PD -04011 (Civic
Center Parking -Security Upgrade) and return balance to Infrastructure Reserve
(612) To close CIP Project PE -00107 (Briones Park Improvement) and return balance to
Infrastructure Reserve
(36,156) To Close CIP Project PE -05002 (Main Library Configuration) and return balance to
Infrastructure Reserve
(999) To close CIP Project PF-90018 (Cubberley Building Code Modification) and return
balance to Infrastructure Reserve
Use`Changes-:
NetGhangesTo (Froth) Reserves.. " � ; ..
:113,683.;:`
Fund Balancing E=ntries
47100000 38490
113,683 Changes in Infrastructure Reserve
Page 1 of 3
FISCAL
Cost
Canter
E TERPRI E FUNDS; ..
Exhibit A
CITY OF PALO ALTO
YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIL CHANGES TO THE ADJUSTED BUDGET
Comm. 2007-08
item I Yearend Adj Description
ry
Eleetria,Frll ft ! 1 P m. ., k.c-. i;�lr�7 V .`:. - f t.,.t. l�ff son t S 11 �, i�w s:6 1 t S l > ggi i s r l rl ` M 3 ,
. ., , � r _.z - ,. ,� �e�Ls J,m��fiJ 'Y;:,, .. E -� ,_�: k , t� �,- . ..,: 1 ._ �•t _;�+ '',a n _.
Source Chargos.,
20000030 40110 38,300 GFTSR year-end transfer from Electric Fund
20000020 40110 5,741 GFTSR year-end transfer from Electric Fund
20020202 38790 (134,297) To close various CIP Projects (Exhibit C) and return balance to Electric Fund RSR
20020202 38790 (3,897,559) To reduce appropriation of various CIP Projects (Exhibit H) and return balance to
Electric Fund RSR
20020202 31990 (326,000) To reduce appropriation of various CIP Projects (Exhibit H) and return balance to
Electric Fund RSR
20020611 38790 (133,572) To reduce appropriation of CIF Project EL -06011 (Fiber Optic Customer) and return
balance to Fiber Optics Fund RSR
20020403 38790 (46,959) To reduce appropriation of CIP Project EL -89031 (Communications System) and return
balance to Electric Fund RSR
20020403 30010 (4,913) To reduce appropriation of CIP Project EL -89031 (Communications System) and return
balance to Electric Fund RSR
20020202 38790 279,614 To provide additional appropriation to various CIP Projects (Exhibit H)
20020201 38790 296,379 To provide additional appropriation to CIP Project EL -89028 (Electric Customer
Connection)
U's'e Changes. ..(3,823;2661:
Net_Changer.Yo(Fr4ifl)'Res9PVes. -., .-3,923,266:;.
Flinn Balaneitrg Entries . .: .
20000020 38040 3,827,994 Increase in Distribution RSR - Electric
20000030 38170 (38,300) Decrease in Supply RSR - Electric
20000080 38040 133,572 Increase in RSR - Fiber Optics
y -*x1 jj] �.,x
Gas;FunU��,., a 3Y:,dI�`! S :: F � a.• ��.:r f ....' �ARx�b,Av. r, 1{'ki� fS{ '1• � � �:itif f fi �I �h xV� � } ? �+! Snle .1, akWR.,tS. M1 1 , i SI:i
Source Chariges' . . _ 0'
20000050 40110 13,350 GFTSR year-end transfer from Gas Fund.
20000040 40110 4,539 GFTSR year-end transfer from Gas Fund.
20020802 38790 (510,276) Various CIP Project year-end adjustments per Schedule H
20020802 38790 (33,226) To close CIP Project GS -03002 (GMR Project 13) and return balance to reserve
Use Changes :(520;648): ,.:
Net-Chrike's.To (From) Re`ser5es.:. - .. .:, 525-,6I3'.,:-.; .. .
kind 'Balanc)ng Entries ,
20000050 38170 (13,350) Decrease in Supply RSR - Gas
20000040 38040 538,963 Increase in Distribution RSR - Gas
W��(flOC.t{EpM99{{ '9/1 07.01f4fi tti "�A.'.i £ .N i % . t k# i ii,! r.i i:. 11:5 l kri i il3..�Gy i '�p1.- P{ Z ,3RD'. .,. Ii , �0, , .'�:,.:O r. 5:-, 1 f:l „ _�',+`!li , ,':' i
R'-Y:FT�„,MA�k]� I. . - .FYI,-,; k'.�R!:23_-:.. �f tt . .,_, +1.a� nr'�1}�.::-1:.4},,..:{I,.,. :� .< ,.;%�:�,n,:..1,L4i ^r��.: J�c�::�:�: j'y�+����.V�a�. 1�,����3':=1�,=,��FbAE�,i�'Mrvxl x. E�, ::, ��- E�..nl �:. LY. ::,.i �xtl:?� � 3.... :: �Fh�,f� �'fS�, Y.,.,:� :r4 ..� :�
oiiTce , ."angel , ',
20021202 38790 (17,130) Various CIP Project year-end adjustments per Schedule H
20021202 38790 (8,004) To close CIP Project WC -00003 (Phase XII - WC System)) and return balance to
reserve
UseChanpes.. (25,134)."`
Net.Chafiges ,To.:(F.roni)Resefves : .25,'i34,
Fund'BaianCin9 Entries„ . : '_ ;. ... .`. .
20000070 38040 25,134 Rate Stabilization Reserve
- 5 -3 _ :� !: 1 I .,1 I ME i �9 l!ie 911 ' Fie i4F-i7 4 'l '§FTF M€ 'I ' 0, ,' - .. ! i d
Water 1"cind �� ,,:'., � � � ,,,.; � 1x ? �- �, .: «-: ti� ,_,�. .Q .. � , x, .. . L,n . . �, , . , ,a � �; J! ,. � . r � �„ , i?
Source Change i .0, . _ ;: . .
20021002 38790 (495,205) Various CIP Project year-end adjustments per Schedule H
20021002 38790 (250,129) To close various CIP Projects at year-end per Schedule C
..
Ilse Changes i (?45,33.4`.
Net' (Fronr) }#egeYve . .:' . .. . .:;" , =' 745,334::`. ._. ..... ,
Fiifttl114iiiklif Enfi'i95
20000060 38040 745,334 Rate Stabilization Reserve
Page 2 of 3
Exhibit A
CITY OF PALO ALTO
FISCAL YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIL CHANGES TO THE ADJUSTED BUDGET
Cost
Center
CoIt m' Yearend Adj2007-08l
eY it t r �r i;3ifi p , 10 #" ' t _.y h'ss "Y
w,�:, ., �^ °- , t;71..1041S-0%
Description
AU_-,-,... ,ri... YI2�-�'H.,LOV,.ViJ3Aiid...-Y�-,..Y.
S Ou rC e.0 h:a n g e s.
50070201 38790 (718) To close CIP Project SD -06103 (Gailen/Bibbits) and return balance to reserve
Use.Changes::'"
NetChanges.To (From)Reserves
7;
Fund;Balancfnj Entries.':
50070001
38040
718 Rate Stabilization Reserve
'i"e�. .. ..-,. 9 i, g 7�1 or I---�. P r rR t-ss .M - :r . f 1 FK �. . ' r 3 , } -,-,re ,i�4 i i,P-�ilit.P v..�. , "�- ? .p : -1 fl * . �i _ r A
hnOlogy.,�Gng`, ;�,,. �`. .�.1{:.�,: �. i..N3� t,� ,..�: .��#ki.X74,�?'��.,<?�,!„�i,:r,��r��i��'�kx.�,r'� �r'r;.z�d�r�#s�,c�,��������bt¢�ia,�+�d�..�� ,�i- �r;.'?; _zrka.�_�x�<� , ��,,�:y�fit�.?,.:::,���y�,r�isFt ;,.E.i
Source Changes.
40070603 38790 (100,000) To close CIP Project TE-07005 (Archive and Purge Record Management) and return
balance to reserve
Use Changes..
(,100 r500)';i
Net ChantlesTo {From) Reserves !.
;100 000''_s
40070001 38300 100,000 Reserve for Technology
Page 3 of 3
Exhibit B
FISCAL YEAR 2008 REAPPROPRIATION REQUESTS
SUMMARY OF REQUESTS
Total Requests
Total Recommended
$ 647,719
$ 647,719
$0
$0
$ 1,916,129
$ 1,916,129
$ 2,563,848
$ 2,563,848
AMOUNT
INTENDED USE
COMMENTS/REASONS
FOR NOT COMPLETING IN FY 2008
STATUS
City Manager's Office
$81,000
$30,919
Climate Protection Plan
(CPP)
Document Archiving
and Library Plan/Public
Safety Building Project
This reappropriation is being requested for
additional project funding to assist departments
in achieving CPP goals as mandated by
Council. The request is also for a consultant /
department backfill for additional staff time to
help implement a plan for greenhouse gas
reductions within the community. In fiscal
year 2008, $100,000 was budgeted for a cost -
benefit analysis of CPP recommendations, and
staff has managed to complete it for much less.
These savings can be applied in fiscal year
2009 to implement the plan.
This reappropriation is being requested for the
document conversion of CMRs which did not
occur as planned in fiscal 2008 due to
unanticipated department priorities. The
request is also for outreach materials relating to
the Library Plan/Public Safety Building Project
which overlaps two fiscal years.
Recommended $81,000. There is
sufficient balance in the Fiscal Year
2008 budget that can be
reappropriated.
Recommended $30,919. There is
sufficient balance in the Fiscal Year
2008 budget that can be
reappropriated.
Page 1 of 4
$
AMOUNT
INTENDED USE
COMMENTS /REASONS
FOR NOT COMPLETING IN FY 2008
STATUS
Planning Department
$60,800
Study of parking
permit program for
College Terrace
This reappropriation is being requested for the
study of a residential parking permit program
in College Terrace. On October 25, 2001, as a
condition of their General Use Permit with
Santa Clara, Stanford University paid $100,000
to the City for study of a residential parking
permit program in College Terrace. Funds
were held in a deposit account until they were
ready for use. City Council authorized moving
the funds into the Transportation Section
budget and proceeding with the study at the
fiscal year 2008 mid -year. The $60,800
remaining is reserved specifically for that
project to implement any recommendations
adopted by the City Council. Transportation
Section will report back to the City Council
with the consultant's recommendations in late
Summer 2008. Implementation will begin at
that time if the City Council moves forward
with the project. Implementation of a parking
permit program is not anticipated in the fiscal
year 2009 budget.
Recommended $60,800. There is
sufficient balance in the Fiscal Year
2008 budget that can be
reappropriated.
Non Departmental
$475,000
Salary Contingency
This reappropriation is being requested for the
Management and Professional group which
includes the compensation study that will be
completed in fiscal year 2009. In addition, the
Fire Chiefs Association will be receiving a
salary increase and two years of retroactive pay
in fiscal year 2009, per the negotiated contract
agreement. The contract was agreed upon after
the 2008-09 Proposed budget was prepared and
the amounts were not included.
Recommended $475,000. There is
sufficient balance in the Fiscal Year
2008 budget that can be
reappropriated.
Page 2 of 4
CAPITAL
;f-, :Y} I }'..- } -
:Y:1 c 't{IJ4 �.., Vii.
IMPROVEMENT
i {i', C" �} ll
d7 -j -E.
,
` y,�
_
�I�,I�T �
PROJECTS
��,�, i
',R 41
+
� �3y�
�, li-.-�' .( e�K. i�- ' �
1 C•)I�vt z 'YI
;; hi RyW}G
'}. .K'�' � . ' ..
c l�iT�N Qr�Dt�l�5.. �
(CIP)
- (� ,5r 2 f€ zits - 1:- !' fi: •€ d'M xy 5
4,
,A' E;' % F }aD 4 -' j fir. eF. i�.
� � hT.:�� � �� = 3 i.. li.3 3 '-F:� ,�
silai !} "_ �d1: �'�j'I �
iyi � - {'�,FPP-,�� - Fi': S••U ". 3 ,-i� �4. A TY_i •. #.�. �%. 3Y rq.. ��
fs-si S �' 2iI1�Y111,.i �4�.� : - �� V it y '[
1,�]r
5k:
S��a"' i7 .
�".� 3 `. `s . { - ,�. f p
.�r��4.I�;NO��k�:�?M�;EPI[�G��N.�F���`�4Q,8£..F�
1>:. - -e€ 4'S, i. _ _
Cara :xE,�yL q. t�,a�.vi j=�•;s°�.;1,`��'„4 ,�;;{�}`, + �:M�:E!r:.. i I:rx(['
�:�5.� R• i � � F.E1y. l�l �t�i. }- ;.I{.:i���.[.�� •-
�435�' � t 3'� l �it� i:t R�IS-.i t � T,}},5, �F n 3 _,.} f
1 r i 1 4 M '+C ` it i, i } 31 44 I{ i
s -
€`,'- 1; k It f .,ei 1 €iii}-'.t:`i
G. ,,!_ , I . .. : {, � QI�.::.,�TA�'U.St.
Police Department
PD -07000
$400,000
Mobile
Command
Vehicle
This reappropriation is being requested
because staff has concluded that a
mobile command vehicle could be
designed to act as a back-up 911 center
during a major disaster and could be
used as a regional asset but the cost is
$350,000 more than the current budget.
Staff is seeking federal funding to
augment the budget. If additional
funding is not identified, staff will
purchase a less expensive vehicle within
the existing budget.
Recommended $400,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Library Department — Technology Fund
TE-06001
$27,600
Library RFID
Implementation
This reappropriation is being requested
to implement radio frequency
technology for use in circulating and
managing library collections. This CIP
should remain open because an
expenditure of $800,000 may occur in
fiscal year 2010 to implement this
project.
Recommended $27,600. There is sufficient
balance in the Fiscal Year 2008 budget that
can be reappropriated.
Police Department — Technology Fund
TE-07002
$125,000
Police Auto
Citation System
This reappropriation is to provide funds
to upgrade the handheld automated
parking citation system. Purchase orders
for this project are currently out, and the
department is in the midst of selecting
the vendor. There is a commitment
balance of $125,000 for this project.
Recommended $125,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Public Works — Vehacle Replacement Fund
VR-
06801
$200,000
Replace
Citywide fuel
management and
tank inventory
system
This reappropriation is to provide funds
for construction in Fiscal Year 2009.
Construction has been delayed during
the construction of the new MSC fueling
facility.
Recommended $200,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Page 3 of 4
CAPITAL
5:,.,:i ZfJ__ E YS -
}
G�JR =i
IMPROVEMENT
tt..., 41. � . -:G
}} _ 4
AMOUNT `
PROJECTS
Ya�'ey1 :i �:s' lrr f `et
$ �r '�Y�.'i$ 15v ` f i,
:.�7'
rINT�":N EMI r
. _ _.. 4+ ..
11(CIP) . e. if ., yi--T.11, ,k)i -. .
r_3 , �F LF,S}�Fi . l7
! r. 4.:.r ^h7 [F �s
Ll;. ffl.::1`-5�#... .}1•A -.9•V,` .��i,.. <:. ..Fv ...�'`�a kwi ..
_.,Y_ �� �µi�i4£ f3�'F. �'�_2;�EF::
'i "'
TC; !Fn qua
}? ',-5 [I{ ���•'S .,. V I.ili�l ..13r�F,{.
po �._ F 9 i �a...e {Y iR3^F'- 1 ..I < e}e
`` O N T'C. ,i P i , Ns;, i `�20Q84 ''
�:e,..., !1l.._..,� s, _..�_. :�_, .. � _. ,�!�,.,. r. #�, _. . , .. . . . t..�
1 F t,{r �. __ l _ � .
' �,; , ` :IFi t ST q'
'i:.,. �,.7�„ ..... ... ... . . .. `, [:, .. ,.
Planning Department
PL -07001
$837,380
Intermodal
Transit Station
Work is ongoing on this project, and has
been for the last two years using grant
funds placed in the General Fund,
Transportation Section budget. This
capital project has been inactive because
funds had to be budgeted early in order
to qualify for Federal transportation
grants. The department will be ready to
use the funds in fiscal year 2009.
Recommended $837,830. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Planning Department
PL -07002
$155,000
Redesign
Stanford Ave /
El Camino
intersection
This project had been delayed until a
cooperative agreement was executed
with Caltrans (April 2008). Staff just
received formal authorization from
Caltrans to proceed with design work
using these Caltrans grant funds.
Caltrans approval was required by June
30, 2008. Staff will initiate RFP process
for consultant services in July 2008.
Recommended $155,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Planning Department
PL -98013
$111,149
Improve School
Commutes
This previously annual project is meant
to fund projects that improve school
commutes. These funds will be used as
the City's local share match for grant
funding for the Stanford Ave / El
Camino Streetscape Project PL -07002.
The funds will be used for the design
phase in fiscal year 2009 and the
construction phase in fiscal year 2011.
Recommended $111,149. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Planning Department
PL -07000
$60,000
Traffic Calming-
Downtown
North Traffic
Circles-
Hardscape
In 2004, the City installed traffic
calming measures in the Downtown
North. In 2005, after an evaluation of
the measures, the City Council accepted
them as a permanent installation, with
the additional direction that hardscape
be installed on the traffic circles. This
project was delayed due to staffing
vacancies in the Planning and
Transportation Division.
Recommended $60,000. There is sufficient
balance in the Fiscal Year 2008 budget that
can be reappropriated.
Page 4 of 4
Exhibit C
City of Palo Alto
CAPITAL IMPROVEMENT PROGRAM PROJECTS
Completed and Closed in Fiscal Year 2008
General Fund
PG -07700
PG -08001
PD -03003
PD -04011
PE -00107
PE -05002
PE -90018
Electric Fund
EL -04006 Welch Road Underground
EL -04007 Embarcadero Rebuild
EL -05020 Mumford/Alma/Scripps
EL -05021 Ross/E. Meadow 4/12kV Conversion
EL -05022 Louis East Charleston
EL -99005 Utility Print Design
Golf Course Irrigation Pump, Motors and Control Panel Replacement
Golf Course Driving Range Turf and Netting
Additional Fire Frequency
Civic Center Parking - Security Upgrade
Briones Park Improvement
Main Library Configuration
Cubberley Building Code Modification
Gas: Fund
GS -03002
Water Fund
WS -02005 New Reservoir and Pump
WS -02007 Middlefield Road Well
WS -02008 Eleanor Pardee Park Well
WS -05000 Two (2) New Vehicles
GMR Project 13
Wastewater Collection Fund
WC -00003 Phase X11 WC System
SD -06103 Gaillen/Bibbits Outfall
Vehlcfe';Replacement Fund
VR-01004 New Vehicles
Archive and Purge Record Management
System Management
Storm. Drainage Fund
Technology Fund.
TE-07005
TE-01008
* Balance to return to reserve.
117,599
75,497
419
612
36,156
999
Total 231,282
Total
Total
Total
Total
Total
Total
Total
20,000
82,951
20,440
2,130
7,633
1,143
134,297
33,226
33,226
167,069
63,567
20,683
(1,1901
$250,129
8,004
$8,004
$718
$718
100,000
$100,000
Page 1 of 1
EXHIBIT D
-k'•v "frf>Vf ) . f .. e4t X:PI:-': tt l a6 -' i' FYI '
T rv.�. 3 if ( .. . $. -L �E -.4 A. '..;Y,. •.9„` e•..'^J'
- ( r : k� k. J fy*-n�k:,L.:rf .•,: �1.7r �� 1i x Sr.,..�
l: rl'l {' '
T E- S.I 0 b. J , !T i
�t r :. . N . :t� > �,. E SG.E .. R L
,4:` k - ;y:. '. �n'J--2I, ].t„f�.,..•
. , -F , 33���. rr. Jlyyri_ 3!{J: `..ryS t.:,lc i..19�•.�g1,:5{
}��.�I i{l - nlr �.4-.:�51 - I.N.?'irft!' - %}}rF: {: �. 3. .5 .. `I',.-:
'.k.: 1 i"..-.': .,N..3:r__yrl i.,.n ,.ti k. - :1 .�- ... .. '2 .+"- , - : 1 " ,f,
- FI Si.+ ,,## nl r: t .�. fI._Y.Y} ..Xa..1. :I } i. .I.. � 4 �1. ' Yb �. � .r r t 31 k i,l E. .
. -.;z-:`Yr: f-,.�ir:.�C:rl -�w';!': }:., ,, Bk�.:, r'jr . 1 Z ',- v ?:r3 rr;r-, t.l�f: -? i �}` :,� j. �1 :s �t ] �! 7
E1...J 1 f� mF i 7 '3 � �.t .� t`` N ti r�i.. :
f', 'b f ir{SH . 1':i 11 �-Pit l ,, 3 if 4. k} i Fji -S �
S:: AR 0. sl r.�,�} 4 .s}!r.:� . 4> }J ,y iF :� ,
wr7.fl. �'_. �":I..r a; l: , e a �. s. }r,s;;,. L`i �qrYrYYi;j:. �. -, . _4 1 ¢y tY. S
-:h jir'}{7 �..i 3y �1... 1r ;d!{�3(�fN:¢ F t} Y'J.: ry'U' 1`:lu - � .Y)1-..
d3�.:_,i..x3 � .J+G.r�:}_ rr.� i rSs?ui[fr?.. r�".Yi.:rl. } -.: �,.lf: i....ri.:.
}.. : :FI
is k� t
-ji I E .
h li'.!
y '- tf .lit _"�
r:.1 f}: :]7 1
y j _eF.-v,
i SI N�._..
}��f.. v... {i
2007-08
2007-08
2007-08
2007-08
2007-08
2007-08
2007-08
Adopted
Adjusted
CAFR Basis
Allocated
Encum+
Budgetary
Budget
Budget
Rev/Exp
Charges
Reapprop
RevfExp
Variance
Revenues
Property Taxes
22,034
22,735
23,107 nla 23,107
372
Sales Taxes
22,045
22,400
22,622 n/a 22,622
222
Utility Users Tax
9,402
9,793
10,285 nla 10,285
492
Transient Occupancy Tax
6,985
7,700
7,976 n/a 7,976
276
Other Taxes, Fines & Penalties
8,181
8,437
7,847 n/a 7,847
(590)
Charges for Services
20,383
20,383
19,311 n/a 19,311
(1,072)
Permits & Licenses
6,044
6,074
4,831 n/a 4,831
(1,243)
Charges to Other Funds
10,650
10,650
10,913 n/a 10,913
263
Rental Income
13,037
13,037
13,591 n/a 13,591
554
Other Revenues
3,742
4,452
7,899 (27) nla 7,872
3,420
(r'm.: [; 1 k 1_ S S 3 - :P{-£ fi,
G y� tG.?.:ji S=r-r.t '] S '
To�alR Ve S!..'si' %1 F 4..` I�
�.. ee i.l.: ,. r _
ir.�: E: .r !- rlti-
u 3 .� +;
4 5
:.: ! 2 , fl3r .
t U
a71 -!,F, lr�'r--'j.:.
i i2 011rY
J . � f f.sr .. F..-
fE 4"IV.7ii t' ii ,s i 7. J.. 3k ;::Sf. Pje: f '4: p',..:. p' S ?'T
x s� % , ,r e } v . s p
t z �f 5 5: :8 {i !f k i s. O'
. e =,.t ra-uf, - 1 J'., ,;:.� { J Q ,, ', fl s nla i , r=iz : :
s,: :fi5'
v:}! A `'�,
l: { ,tj
; r... ,, ,69 ;
Add: Operating Transfers In
17,207
17,786
17,133 n/a 17,133
(653)
Prior Year Encum & Reapprop
3,558
3,558 n/a 3,558
-
q-: ; :.fr4. ,r7
'y'�c 5.. !t� :.4%r„1'k ea; � (fla 3 :I! ��av �Jti j �k
a �#S e•.;o¢ z4' t. J
. �!�� 914T'9 l i3•,l4#CC.IIrr�� [['f`�in ! iy
kni...,.r:a Jin,l;.i�. s:e, r . .I, ...l,:+>`. ;1.1k,�f7..+fr:�. .� �.1.�,17
'"3J= •!�;r
mil , d �' ' t
it 9 ,11 J
l ! ��� - A
�iF ,r!7.,..,:rrr,..rn1 l.3�i
� -f . "r F: �,,t • ':
E'r1:t4 n
�S �� ''. l�ln1p/�
��x i,.,.,..-.>�.�u r.7�Y.,
4 -. P:,.1t : �,1� zF it n,- S.,, r * ,
! {� -I�ve 1 i, �. , r ti�}f?i' s' r a;: � h F j5 `ttil! 3 �€{i �
�f: � x.51 .Y >` ;� Sr� �� � rl._ a. 1�, t-! ��r . U..
rr t ° ` }6 1!` fir- "' r "'r �n ,, , , ,
r.,��..kr;i,7#3a3xtiE:f:�.£I:3„r.1.w�N4�4,+a�i`.�..'�.u4.r-.e�<.r..r!.-: ,%..k.�r,. _: `5 . +i ..,.. :�rr ;4<..%,,.,�,r..J.
is •
) . ). Y s'I
J E� tX"l�F�
. F
Expenditures
Administrative Departments
17,342
19,108
16,256 1,121 1,721 19,098
11
Community Services
21,212
21,872
17,140 4,112 614 21,866
6
Fire
22,868
24,279
21,643 2,343 291 24,277
2
Library
6,484
7,035
6,221 601 212 7,033
2
Planning
10,137
10,148
8,953 705 487 10,145
3
Police
27,981
29,787
26,839 2,613 335 29,784
2
Public Works
13,225
13,254
10,074 2,845 324 13,243
11
Non-Departmental/School Site
9,229
7,903
6,985 440 475 7,899
4
3. ...r- '� f�_I fr, rlyY �sl tyti'.i�i
'a#al-1{ r'.' J-,) f - -: r 7 _aa, i.., , '. G -:
_ z a d�fu n 5J=� - ]pp s s.�
r.i!_s:�. � F .... �...� .,..-.£?.: r.: pr .a r_.:: ,.Sh. :,;l ..c:l'�
S.#'T ..�i'. � ...}{
11 4e[r'-..FMS `i'
„ : {A/ `1.
l�Y .}. r.�K•t t..�!.?f.��,v
�r .:st: �(C}Gx
L .'i--. rr: .!�
K F 1 j.,m :'-s
..:<:.,S.fyfN.�.i(i :•f F�.&h.
{, ' i#R5n b .'14-4 r -'1? tt,1 11Tfr�7. ,"?, ray ..
���.E1 e,n��� '-5 ��^3i.,F .�: - 7, : - [}S. ' e I'•LJ.
> �}k i t 1 ,� it ,o 779 ,I r (d6 is I � .
.i:.!trt. r.2!J TA >�?�' ._..:.:]r1:1,'i!1. r.... J: F_;:.1..1�5. rlr-.:.t5 .Vf�. .r i�.,�,?:IIvr.R.l r]
r�l.i 'it
{ r ' i;5{ } 4,..
., .�1.:.. (5 C'.iF�v: �...
Add: Operating Trans Out
10,707
15,570
13,654 - 13,654
1,916
=r J r. r{r ,3. {i'''' ,,:i0.% tt
t �1al use �fT+u11(]s{ <;} ,
�e.. b..r `..... .. r. ,..r V�rv.,r IeiS:i.: •f�fJ., 3S: af'�
;13 �$5
06-S5. 4`I
�, }.�u.r:. rGf.?,.:_r. tP
5� fie: 2 S
! Ili$ 97,
r. -.r r-.:. ..,-,. �. s.,,u
]J.,(. ,,. /c4
3f7.Ai �; 5 - iid j:'f kl �'I r E T!�Sj
<�-! �7 �65� 14 T179 � IFF 46Q 47 Q�0
rL!..;.,r.,. }a ��rj.,-.lr'1: r..,6s.�_....Y.i..., ...i }�...-r-.l J ,a.7 a..; � _r : r;( : .. �r. a.
3f g
� 1 S�i
.. _.,xr. i #r..�.. r.,. .:
.\1`:£ ,k,,,,,.. .,4,-;.,,,.....: ,.. +3 - •:... . .1. ].. . v.
I 3.Jf{ i
r
1V�t�,�uriplus(A��c�t� � � � � f'
,t .1 .r' 3!{3Ri G:
'.It fk 1} ! ,�
.�� � i;�S,
A��F E'.YaH.:
E iJ ! I •9
4 lU..:'?..t,1-1,..;:.
� �; �r.r. !t(�,�5?,r)
ftAf s,? IIS t I,s V1 .."1 2 45---. .r 1-,N,' , :,:p:11 -S- -i d.l-.4
N rN}'ti.c •L1i.,•? �'.' £ ;P'-',4.-01:1.1i(..%i i R.", .1i({. . ] , f'
r �dS:. :gk �b,8�6 . 3 6)�f� ,l,(4, , N , �
f od4�
- - -. 1
'V {
��i. {�;.:: �������
CAFR Reconciliation:
Current year encumbrance/reappropriations
Prior year encumbrance/reappropriations
Current year stores adjustment
Prior year stores adjustment
4,460
(3,558)
(37)
98
CAFR Net Income
3,007
Page 1 of 1
Exhibit E
GENERAL FUND RESERVE
FISCAL YEAR
SUMMARY ($000s)
2008
Balance
Net From Balance
lj 4J {�[�y l'y y -}) 1 y'y �J11YFy �Jd■{r� '(
f.
@ 06/30/07
Operations @ 06/30/08
CAFR Fund Balance
39,408
3,007
42,415
Less: Encumbrances
(3,390)
(426)
(3,816)
Reappropriations
(71)
(577)
(648)
Adjustment for Stores Operations
(98)
61
(37)
6udge' NZ. i5 'LY Sf TS S, .��T^1-
ta.ry IFund:Bai4nae ` . � .,'..E. . '.: I, ,, v,'-:;:`,iii ,..'��.i ; .,
'._ .°;
. 35;849 , :,
..
,: 1f._,
2,065.; . ...,F.:
37,914,
27,480
(1,378)
26,102
Budget Stabilization Reserve
Reserve For Infrastructure Improvements
0
0
0
Notes Receivable Reserve
1,182
1,073
2,255
Stores Inventory Reserve
2,567
432
2,999
Prepaid Reserve
1,253
779
2,032
Unrealized Investment Gain/Loss Reserve
0
1,035
1,035
Reserve For Equity Transfer Stablization
3,465
63
3,528
Reserve For Emergencies
0
0
0
Adjustment for Stores Operations
(98)
61
(37)
+ a.� a r 1 ¢ e 4 a k s 1 1 '
�
r
1 1 �5
4 i'
13� 76e a:ry.�E ON..al-119:C.< x ,f.,'I ,.'. Fi`f'° ...;i, 1
., ...'. I ,? 35, 9....
. .:,;
X46$: � E, ...,.
37,9; 44'
Adjustment for Stores Inventory Encumbrance
0
Adjustment for Stores Operations
(37)
4; x i i s 1 1M S 1 g a y
W,
j E y
h
.111'41114.4.4P% ,: ?it
1 of 1
Exhibit F
WATER FUND ($000)
REVENUE
Water sales
Other revenues
Reappropriations / Enc
AO 1300
EXPENSES
Purchases
Other Expenses
TOTAL OPERATING EXPENSES
Capital Expenses
`FO1f1�L EX�ENSES.,
TQI(��?oM) RE5�R11
FY 2007
Act/Enc
Reapprop
23,044
3,227
13,044
7,806
10,736
18,542
8,565
FY 2008
Adjusted
Budget
26,528
2,151
3,666
FY 2008
Reapprop
ActuallEnc
25,975
3,301
3,666
9,340 8,363
14,309 12,515
23,649 20,878
14,463 14,988
. ,.'..:t'.(5,
$ Varlance
Favorable
(Unfavor.)
(553)
1,150
977
1,794
2,771
(525)
`35,8$6 2,246
ELECTRIC FUND
REVENUE
Electric retail sales
Electric wholesale sales
Other revenues
Bond Proceeds
Reappropriations 1 Enc
bT.4Ll14.090
EXPENSES
Purchases
NCPA & TANC Debt Svc
Other Expenses
TOTAL OPERATING EXPENSES
Capital Expenses
Principal Payments
To!>•AL•EXPENSE
i d1(F�t¢�Vl), RES RUES
FY 2007
Act!Enc
Reapprop
FY 2008
Adjusted
Budget
FY 2008
Reapprop
Actual/Enc
85,417 90,506 90,833
25,584 20,848 25,173
1,350
9,328 8,922 8,922
62,478
8,443
35,111
106,032
18,730
1'14,762
78,601 71,065
8,886 8,554
42,495 40,725
129,982 120,344
$ Variance
Favorable
(Unfavor.)
327
4,325
1,350
7,536
332
1,770
9,638
13,642 15,768 (2,126)
100
X624 :, ,�a6i2
(100)
2'
x,433) 6i t _`,.(333,
Exhibit F
GAS FUND
FY 2007 FY 2008 FY 2008 $ Variance
ActlEnc Adjusted Reapprop Favorable
Rea.. rop Budget Actual/Enc Unfavor.
REVENUE
Gas retail sales
Gas wholesale sales
Other revenues
Reappropriations t Enc
41,457 48,047 48,100 53
1,490 316 2,261 1,945
4,620 7,515 7,515 -
5,7876
EXPENSES
Purchases
Other Expenses
22,250
12,704
TOTAL OPERATING EXPENSES 34,954
Capital Expenses
10,838
3XFEN
} 14f
28,003 27,220 783
14,259 12,979 1,280
42,262 40,199 2,063
13,913 13,632
281
WASTEWATER COLLECTION FUND
REVENUE
Revenues
Reappropriations / Enc
FY 2007 FY 2008 FY 2008 $ Variance
ActlEnc Adjusted Reapprop Favorable
Rea • ro . Budget Actual/Enc Unfavor.)
15,726 15,944 16,627
9,587
5,966 5,966
683
TAL'REVENU.E
EXPENSES
Sewer Treatment Exp.
Operating Expenses
6,142
3,781
TOTAL OPERATING EXPENSES 9,923
Capital Expenses
Principal Payments
XPEN§I
13,789
54
7,101 7,056 45
5,202 4,814 388
12,303 11,870 433
9,164 10,229 (1,065)
55
52W= F, i t22
55
32
11:0013b-
I� �1
2
Exhibit F
WASTEWATER TREATMENT FUND
FY 2007 FY 2008 FY2008 $ Variance
Act/Enc AdJusted Reapprop Favorable
Reapprop Budget Actual/Eno (Untavor,
REVENUE
Operating Revenues
Restricted Bond Proceeds
Loan Proceeds
Reappropriations / Enc
Bonded Reappro/Encum
'":41110 .010.
EXPENSES
Operating Expenses 16,406
TOTAL OPERATING EXPENSES 16,406
17,717 21,015 23,905 2,890
21 9 9 -
- - 4,879 4,879
15,912 23,804 23,804
64 17 17
Capital Expenses
Principal Payments
24,578
341
18,582 16,696 1,886
18,582 16,696 1,886
26,288 30,252 (3,964)
355 355
2
rO70
V.
REFUSE FUND
REVENUE
Revenues
Reappropriations / Enc
EXPENSES
Payments to PASCO
Other Expenses
FY 2007
Act/Enc
Reapprop
FY 2008 FY 2008 $ Variance
AdJusted Reapprop Favorable
Budget ActuallEnc (Untavor.)
26,340
998
7,825
18,198
TOTAL OPERATING EXPENSES 26,023
Capital Expenses
r TOTAL,-0XP01SES
r... 26O3.
29,849 29,850 1
884
884
9,828 9,276 552
21,772 20,994 778
31,600 30,270 1,330
836 1,000 (164)
3
Exhibit F
STORM DRAINAGE FUND
REVENUE
Revenues
Reappropriations 1 Enc
Bonded Reappro/Encum
Restricted Bond Proceeds
FY 2007
Act/Enc
Reapprop
5,346
2,379
EXPENSES
Operating Expenses 2,118
TOTAL OPERATING EXPENSES 2,118
Capital Expenses
Principal Payments
FRQInikEdERVE
3,801
340
FY 2008 FY 2008 $ Variance
AdJusted Reapprop Favorable
Budget Actual/Eno (Unfavor.)
8,307 5,346 (2,961)
2,295 2,295
2,344 2,379 (35)
2,344 2,379 (35)
9,885 8,472 1,413
360 360
EXTERNAL SERVICE FUND
REVENUE
Revenues
Reappropriations / Enc
FY 2007 FY 2008 FY 2008 $ Variance
AcUEnc Adjusted Reapprop Favorable
Reapprop Budget ActuallEnc (Unfavor.)
792
1,243 919
5 5
(324)
;TOTAL REVENUE
EXPENSES
Operating Expenses
TOTAL OPERATING EXPENSES 806
Capital Expenses
Ebb l ;EXI ,Et SES
806
$
1,232
1,232
928
304
928 304
TQ[(FROM)TRESERV
4
Exhibit G
RESERVE SUMMARY ($000)
FISCAL YEAR 2008
Water Electric Gas WWC WWT Refuse Storm Ext Svc
Total
Beginning Reserves
$17,630 $147,505 $9,416 $6,469 ($10,013) $5,004 $2,186 $4
$178,201
To (From) Reserves
(2,924). (9,934) 4,045 439 5,311 (536) (3,570) (4)
(7,173)
nd ng ResehteS; .
'
ii �7O6, ;'37 . r i b ''''''7,E , ,(•v 4'� `. . . ° ' '2411.',:,,,' (1,384) ,.. . , Q
r''24:..
Adj Budgeted Reserves
19,200 137,890 10,312 6,369 15,066 4,455 2,180 4
195,472
% of Budgeted Reserves
77% 100% 131% 108% -31% 100% -63% 0%
87%
RESERVE DETAIL
FISCAL YEAR 2008
Water Electric Gas WWC WWT Refuse Storm Ext Svc
Total
Rate Stabilization
General RSR
$13,111 $6,027 ($7,285) $3,832 ($1,384) $0
$14,301
Supply RSR
47,309 7,399
54,708
Distribution RSR
13,968 4,734
18,702
Total RSR
13,111 61,277 12,133 6,027 (7,285) 3,832 (1,384)
87,711
Emergency Plant Replace
1,595 3,057 1,328 881 2,583
9,444
Calaveras
70,397
70,397
Underground Loan
709
709
Conservation Loan
-
Water Resources Board
636
636
Shasta rewind Loan
-
Central Valley Project
22
22
Public Benefit Program
2,109
2,109
External Service - IT
-
-
External Service - HR
-
Ending Reserves ;
: -,
4,7OG ' 3 ,5 3' ... i r f? 48 ..(4; ', 'I,,:' 468 ` , 384. c' „` ... . ,
. .. 4,04.e.:,
RATE STABILIZATION RESERVE
FISCAL YEAR 2008
Water Electric Gas WWC WWT Refuse Storm Ext Svc
Total
Beginning RSR
$16,276 $71,111 $8,406 $5,803 ($12,596) $4,414 $2,186 $4
$95,604
To(from) RSR
(3,165) (9,834) 3,727 224 5,311 (582) (3,570) (4)
(7,893)
1[i� RStt � ;
E11t1. . = .,.
:: , l ,I ., : 133 '6 " I , '41:1: 8. 3 ' 1438'4 r -.
r � �:. :. ._ .r..� .. .: � , .� ,. ,� . ,.... �: , . r8... , . , ...r �:,.,� 1 .
, , ... .. ,t*
RSR Minimum
4,942 35,913 13,150 2,737 2,898 2,507 N/A N/A
62,147
RSR Maximum
12,356 75,147 29,606 6,844 5,795 5,014 N/A N/A
134,762
RSR % of Maximum
106% 82% 41% 88% -126% 76% N/A N/A
65%
Exhibit H
City of Palo Alto
CAPITAL IMPROVEMENT PROGRAM PROJECTS
Fleal Year 2008 Year -End Adjustments
Capital Project Fund
80471009 Golf Course Irrigation Pump, Motors end
Control Panel Replacement
80471009 Golf Course Driving Range Turf and
Netting
50471011 Street Maintenance
50471010 Mitchell Park Library
80471008 Foothills Interpretive Center 05-07002
80471008 Foothills Park Maintenance 0S-07003
80471008 Open Space Trails and Amenities OS -00001
Eleclr-ldFund.
20020202 Park Blvd. Sub. Bus.
20020202 UG District 41
20020202 UG District 39
20020202 Colorado Sw Station 115k
20020202 Relocation - Alma Sub Station
20020202 UG District 45
20020611 Fiber Optic Customer
20020202 E. Meadow/Alma Loma
20020202 Rebuild UG District 22
20020201 Electric Customer Connections
20020403 Communications System
20020202 Substation Protection
20020202 Substation Facility
20020202 Electric System improvements
Gas'Fuddi --I
20020802 Compressed Natural Gas
20020802 System Extension Operations -
Unreimbursed
20020802 CNG Seq Fuel System
20020802 Elwell Court Tenant Improvements
20020802 Gas Meters and Regulators
20020802 GMR Project 14
mic,Fund :.
20021202 WC System Rehabilitation - Project 17
20021202 WC System Rehabilitation - Project 18
20021202 Sewer Manhole Rehabilitation
PG -07700
PG -08001
PE -86070
PE -04012
EL -00006
EL -03001
EL -03005
EL -05001
EL -05003
EL -06002
EL -08006
EL -08002
EL -11005
EL -89028
EL -89031
EL -89038
EL -89044
EL -98003
G5-00011
GS -03009
GS -03010
GS -07000
GS -80019
GS -04003
WC -04002
WC -05003
WC -99013
Water.Funj1; :1
20021002 Reservoir Booster Station WS -01010
20021002 Distribution System Water Quality WS -01011
20021002 Booster Station Improvement WS -01012
20021002 WMR Protect 18 WS -02003
20021002 Existing Well Rehabilitation WS -02004
20021002 Water System Sampling WS -05002
20021002 Water Service Rydranl
20021002 Water Meters
20021002 WMR Project 19
WS -80014
WS -80016
WS -05001
13,315 General Fund
(13,315) General Fund
(2,614) (2,614) Proposition 16 - Local Street and Road
improvement
3,000 3,000 Utilities CARE Program
2,229 CIP Project 0S-00001 - Open Space
Trails and Amenities
9,161 CIP Project OS -00001 - Open Space
Trails and Amenities
(11,390) Infrastructure Reserve
386
386
(13,000) Electric Rate Stabilization Reserve
(1,000,000) Electric Rate Stabilization Reserve
(60,000) Electric Rate Stabilization Reserve
(2,600,000) Electric Rate Stabilization Reserve
43,160 Electric Rate Stabilization Reserve
(172,677) Electric Rate Stabilization Reserve
(133,572) Electric Rate Stabilization Reserve
153,406 Electric Rale Stabilization Reserve
67,048 Electric Rate Stabilization Reserve
296,379 Electric Rate Stabilization Reserve
(51,872) Electric Rate Stabilization Reserve
(60,029) Electric Rate Stabilization Reserve
(327,853) Electric Rate Stabilization Reserve
16,000 Electric Rate Stabilization Reserve
O (3,833,010)
2,945 Gas Rate Stabilization Reserve
(305,408) Gas Rale Stabilization Reserve
31,765 Gas Rate Stabilization Reserve
39,292 Gas Rate Stabilization Reserve
(200,000) Gas Rate Stabilization Reserve
(78,869) Gas Rate Stabilization Reserve
O (510,276)
312,870 WWC Rate Stabilization Reserve
(30,000) W VC Rate Stabilization Reserve
(300,000) VVWC Rate Stabilization Reserve
0
(17,130)
(94,450) Water Rate Stabilization Reserve
(41,690) Water Rate Stabilization Reserve
Water Rate Stabilization Reserve
(17,568)
(69,951) Water Rate Stabilization Reserve
(6,691) Water Rate Stabilization Reserve
(13,848) Water Rate Stabilization Reserve
(160,000) Water Rate Stabilization Reserve
(100,000) Water Rate Stabilization Reserve
(807) Water Rate Stabilization Reserve
To provide additional appropriation for a purchases order
Return portion of the appropriation back to Gas Rate Stabilization
Reserve
To provide additional appropriation for a purchases order
To provide addilional appropriation 1,0 over actual costs
Return portion of the appropriation back to Gas Rate Stabilization
Reserve
Return portion of the appropriation back to Gas Rate Stabilization
Reserve
ok
ok
Refum potion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back to Water Rate
Stabilization Reserve
Return portion of the appropriation back l0 Water Rate
Return portion of the appropriation back to Water Rate
Return portion of the appropriation back to Water Rate
To transfer appropriation from PG -08001 to PG -07700 to cover
expense over budget
To transfer appropriation from PG -08001 to PG -07700 to cover
expense over budget
To adjust budget to actual amount received
Increase revenue expense fue to additional revenue from Utilities
CARE Program (Consultant Assistance for Resource Efficiency
Program)
To transfer appropriation from OS -00001 to 0S-07002 and OS -
07003 to cover expense over budget
To transfer appropriation from 0S-00001 10 0S-07002 and OS -
07003 to cover expense over budget
To transfer appropriation from 05-00001 to OS•07002 and OS -
07003 to cover expense over budget
Return portion of the appropriation back to Electric Rate
Return portion of the appropriation back to Electric Rate
Stabilization Reserve
Return portion of the appropriation back to Electric Rate
Stabilization Reserve
Return portion of the appropriation back to Electric Rate
Stabilization Reserve
To provide additional appropriation to cover actual costs
Return portion of the appropriation back to Electric Rate
Return portion of the appropriation back to Electric Rate
To provide additional appropriation to cover actual costa
To provide additional appropriation to cover actual costs
To provide additional appropriation to cover actual costs
Refum portion of the appropriation hack to Electric Rate
Return portion of the appropriation back 10 Electric Rate
Stabilization Reserve
Return portion of the appropriation back 10 Electric Rate
Stabilization Reserve
To provide additional appropriation to cover actual costs
To provide additional appropriation for a purchases order
Return portion of the appropriation back to WWC Rate
Stabilization Reserve
Return portion of the appropriation back to WWC Rate
Stabilization Reserve
O (495,206)
Page1of1
ok