HomeMy WebLinkAbout2009-02-02 Ordinance 5026ORDINANCE NO. 5026
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
-----~E0r--t-fl-----i-Il___see_~i_0R-~2_8_;__8_'7_G-0-:E-t_fle-Pa-}_0-A-l__t_0__MtlR±_e_i_~a-l-Gede'-c-,------
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
Exhibi ts "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
Al to Municipal Code, the Ci ty 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
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. Council hereby re-appropriates
fiscal year 2008 appropriations in certain departments and
categories I as shown on the attached Exhibit "WI I which
were not encumbered by purchase order or contract, at year
end into the fiscal year 2009 budget.
SECTION 5. The scal year 2008 encumbered
balances for departments and categories shown on
Exhibi t "DII shall be carried forward and re-appropriated to
those same departments and categories in the fiscal year
A. To close the fiscal year 2008 budget accounts in
all funds and departments and I as required by the Charter
of the City Palo Altol to make such interdepartmental
transfers the 2008 budget as adopted or amended by
ordinance the Council; and
B. To close various completed Capital Improvement
Projects (CIP) as shown in Exhibit "c" and move the
balances of General Fund completed CIP into the
infrastructure reserve and all other completed CIP to
respective reserve funds indicated in Exhibit "G"; and
C. To establish reserves as shown in Exhibi ts "E" I
(1) A reserve for encumbrances and re-
appropriations in the various funds, the
(2 )
purpose of which is to carry forward
the fiscal year 2009 budget and continue I
the unexpended balance
appropriations for fiscal year 2008
departmental expenditures as shown
Exhibi ts "Ell and "FII; and
Reserves for Advances to
Stores InventorYI and other
accordance with ordinance
page 2 of 6
Other Funds I
reserves
and policy
guidel as shown in Exhibit "E"; and
(3) A reserve for general contingencies such
(4)
amount that the City Council has approvedi
and
Reserves for utilities plant
rate stabilizationl and other
accordance with Charter
guidel as shown Exhibit "Gil.
replacement I
reserves in
and policy
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-.-'Fe-f-1::ffia-tfle-BEl1:1*y--~::t:'an"&:ferSt-ab-i-l~i-za-1::-~CTn-Reserve
accordance with the General Fund Reserves Pol
SECTION 7 . The General Fund Equi ty Trans
Stabilization Reserve is hereby increased by the sum of
Sixty Two Thousand Nine Hundred and Thirty Dol
($62 /930) as shown in Exhibit "NII from the Stabili
Rate Reserves of the Utili es Department Funds as follow:
utilities Fund Amount
Electric Distribution $ 5,741
Electric Supply $38,300
Gas Distribution $ 4,539
Gas Supply $13,350
'T'nt:Rl g 6.2..,-9-3.0---................
General Fund Equity Trans Stabilization Reserve is
increased by $62,930 to $3 /528 /000.
SECTION 8. The General Fund Budget Stabilization
Reserve Rate Stabilization Reserve hereby increased by
the sum of One Hundred Seventeen Thousand Five Hundred
Ninety Nine Dollars ($117 1 599) as described in Exhibit "A".
transaction will change the balance in the General
Fund Budget Stabilization Reserve to $26,100,000.
SECTION
decreased by
9. The Emergency Preparedness Fund is hereby
Four Thousand Six Hundred Seventy Dollars
Page 3 of 6
($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,13'5) as described in Exhibi t "A" . This
transaction will change the Public Services Donation Fund
Balance to $674,000.
SECTION 11. The Local Law Enforcement Block Grant
Fund for is hereby decreased by Two 'rhousand Six Hundred
Dollars ($2,600) as described in Exhibit "A" . This
transaction will change the Local Law Enforcement Block
Grant Fund Balance to $901.
---------<+SEeT-:E0N-H . 'Phe-e-api-c-a-3.:--Prej-ee-t--F-tlnd-rn-r-ras-t-ruetu-r-e-------
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 Proj ects 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
Exhibi t "A". This transaction will change the balance in
the Electric Supply Rate Stabilization Reserve to
$47,309,000.
==================:s-,~-~E~e~~~:k:~Cl~1~~~J;~;) .---Th@ E~-t;:-l; i G n±s-t-r-t:tm-t i GIl Ra-t@
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
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
Exhibi t "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 Exhibi t "A". This transaction
will change the Gas Distribution Rate Stabilization Reserve
to $4,735,000.
SECTION 19. The Wastewater Collection Rate
------c--------iS.,;.:ta:Bi-l-i-z-a-1;-ieFl-Rese-F-ve---i-s-he-FeBy-i-nG-Fea-s-ea-13y--,±lweIl-~y-F-i-ve------
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 1S
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.
=================~S'.~Ee~~ ~'I::~j:~f}f~-if~~2:2~ . __ The-T_e:chno±-D~d=±s_here-hy incI_eas:ed=========
by One Hundred Thousand Dollars ($100,000) as described in
Exhibi t "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
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
Palo Alto Municipal Code,
effective upon adoption.
Section 2.04.330 of the
ordinance shall become
INTRODUCED AND PASSED: February 02, 2009
AYES: BARTON, BURT, DREKMEIER, ESPINOSA, KISHIMOTO,
ABSTENTIONS:
ABSENT:
Mayor
APPROVED:
Page 6 of 6
-
I
GENERAL F UN 0
Source Changes
Use Changes
f'liirCI1i:lnges'Io(FromfKeserves
Fund Balanclna Entries
Exhibit A
CITY OF PALO ALTO
FISCAL YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIL CHANGES TO THE ADJUSTED BUDGET
Costl Center
comm.,
Itam
2007-081
Yearend Adj Description
10200000 20520 45,041 GFTSR year-end transfer from Electric Fund.
10200000 20530 17,889 GFTSR year-end transfer from Gas Fund.
Unused balance of CIP Project PG·08001 (Golf Course Irrigation) returned to General
10200000 20410 117,599 Fund which was the funding source, of this project.
160,529
17300000 33060' 40 Transfer to fund travel & meetings.
17300000 33450 4.630 Transfer to fund emergency meals.
70191(l01 31220 1,081 Transfer to fund Instruction & training
70191001 33480 144 TraO/lter to fund special events & awards.
70191(l03 32070 5,866 Transfer to fund recreation and housekeeping
60191002 32990 2,902 Transfer to fund other supplies and materials.
80191(l03 31990 7,146 Transfer to fund other contract servlce$.
80191003 32990 7.990 Transfer to fund other supplies and materials.
29.805
1bO,724
10200000 . 38310 62,930 Transfer Stabilization Reserve -10200000 38220 117,599 Budget Stabilizallon Reserve
17300000 38500 (4,670) Change in fund balance
19100DOO 36500 (25,135) Change In fund balance
, RtiVf:NUE FUND -Loc,el Law EnlQrcement tslOCK litent
Source Changes 0
70249001 32990 1,160 Transfer to fund other supplies ana materials
70249001 33060 1,440 Transfer to fund traval and meetings.
Use Chanaes 2.600
Net Chanaes To (From1 Reserves (2,600)
Fund Balancln~ Entries
70249001 36500 (2,600) Change in fund ""'tence
CAPITAL PROJECT FUND
Source Changes .0
47100000 40110 117,599 To return unused balance cif CIP Project PG-0800f (Golt Course Irrigation) to General
Fund which was the funding source of this project.
60471009 36790 (117.599) To close CIP Project PG-08001 (Golf Course Irrlgalion) and relurn balance to General
Fund
50471001 38790 (75,916) To close CIP Projects PO·03003 (AddlUonal Fire Frequency) and PO·04011 (Civic
Center Parking-Security Upgrade) and return balance to Infrastructure Reserve
50471010 38790 (612) To close CIP ProJect PE·00107 (Briones Park Improvemenl) and retum balance 10
Infi'Mtructure Reserve
50471010 38790 (36,156) To close CIP ProJect PE·05002 (Main Library Configuration) and return balance to
Infrastructure Reserve
50471007 38790 (999) To close CIP ProJecl PF-90018 (Cubberley Building Code Modificallon) and return
balance to Infrastructure Reserve
Use Changes (11366S)
NEit Chanaes To (Froml Reserves 113.683
Fund Balanelna Entries
47100000 36490 113,663 Changes In Infrastructure. Reserve
-
TERP
Exhibit A
CITY OF PALO ALTO
FISCAL YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIl,. CHANGES TO THe ADJUSTED BUDGET
I costl comm.\ 20070081
Center Item Yearend Adj Doscription
20000030
20000020
20020202
20020202
20020202
20020611
20020403
20020403
20020202
20000060
20000040
20020802
20020802
20021202
20021202
40110
40110
38790
38790
31990
38790
38790
30010
40110
40110
36790
38790
38790
38790
38,300 GFTSR year-end transfer from Electric Fund
5,741 GFTSR year-end IransferfrOO\ Electric Fund
(134,297) 1'0 close various CIP ProJects (Exhibit C) and return balance to Electric Fund RSR
(3ta97,559) To reduce eppropriatlon of various GIP Projects (Exhibit H) and return balance to
Electric Fund RSR
(326,OOO) To reduce appropriation of various CIP ProJects (Exhibit H) and return balance to
ElectriC Fl.(nd RSR
(133,572) To reduce appropriation of CIP Project EL-Da011 (Fiber Optic Customer) and return
balance to Fiber OpUca Fund RSR .
(46,969) To reduce appropriation of CIP Project EL-89031 (Communications System) and return
balance to Electric Fund RSR
(4,913) To reduce appropriation of CIP Project EL-89031 (CommUnications System) and ratun:'!
balance to Etectrlc Fund RSR
13,350 GFTSR year-end transfer from Gas Fund.
4,539 GFTSR year-and transfer from Gas Fund.
(510,276) Various CIP ProJ~ year-end adjustments par Schedule H
(33,226) To close CIP Project 08.03002 (GMR PrOject 13) and return balance to reserve
(17,130) Various CIP Project yea;-end adjustments per Schedule H
(8,004) To close CIP Project We-00003 (Phase XII • we Sylllem}) and return balance to
Paoe:1 0/3
~ Source Chan 88
Exhibit A
CITY OF PALO ALTO
FISCAL YEAR ENDING JUNE 30, 2008 BUDGET SUMMARY
DETAIL CHANGES TO THe ADJUSTeD eUOGET
50070201 38190
50070001 38040
40070603 38190
40070001 38300
. 0
718.
718 Rate Stabilization Reserve
o
(100,000) To close CIP Project TE-07005 (Archive and Purge Record Management) and return
balance to reserve
100,000 Reserve for Technology
Exhibit B
FISCAL YEAR '2008 REAPPROPRIATION REQUESTS
$ COMMENTS JREASONS
AMOUNT INTENDED USE -FOR NOT COMPLETING IN FY 2008 ' STATUS .
City Manager's Office ..
,,$81,000· Climate Protection,Plan . This reappropriation is, being requested for .. RecommendedS81tOOO.There is
(CPP) additional project funding to assist departments sufficient balance in the Fiscal Year
ill achieving CPP goals as mandated by 2008 budget that can be
Council. The reques,t is also for a consultant I reappropriated.
department backfill for additional staff time to
help implement a 'plan for greenhouse gas
reductions within the community. In fiscal
year 2008, $}OO,OOO was budgeted for'a C08t-
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.
$30,919 Document Archiving This reappropriation is being requested for the Recommended $30,919. There is
-and :btb~-:I9anlPublie--f:::'doooment=Q611verSi6JH)f:eMR;tivhich-did-no~ -=suffieierlt baIatiCe::in::the::Eiscal::Year~ === Safety Building Project occur as planned in fiscal 20'08 due to 2008 budget that can be
unanticipated department priorities. The reappropriated.
request is also for outreach materials relating to
the I.;ibrary Plan/Public Safety Building Project
which overlaps two fiscal years.
Page 10f4
$ COMMENTS/REASONS
AMOUNT INTENDED USE FOR NOT COMPLETING IN FY 2008 STATUS
Planning Depm·tment
$60,800 Study of parking "This reappropriation is being requested for the Recommended $60,800. There is
t permit program for . study of a residential parking pennit program sufficient balance in the Fiscal Year
College Terrace in College Terrace. On October 25, 2001, as a 2008 budget that can be
condition of their General Use Penn it with reappropriated.
Santa Clara, Stanford University paid $100.000
to the City for study of a"residential parking
pennit program in College Terrace. Funds .
were held in Ii 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 spetifically for that
project to implement any recommendations
adopted by the City Council. Transportation
~n-willreport:baclrwlheCityCmm.c~
with the consultant's recommendations in late
SUmiMr ZOU8~Imple~enfationwilr6egin.at
that time if the City Council moves forward
• with the project. Implementation of a parking .
pennit program is n~t anticipated in the fiscal
year 2009 budget.
Non-Departmental .
$475,000 Salary Contingency This reappropriation is bemg requested for the Recommended $475,000. There is
Management and Professional group which sufficient balance in the Fiscal Year
includes the compensation study that will be 2008 budget that can be
completed in fiscal year 2009. In addition, the reappropriated.
Fire Chiefs Association will be receiving a
salary increase and two years of retroactive pay
in fiscal year 2009. per the negotiatf;}d contract
agreement. The contract was agreed upon after
the 2008-09 Proposed budget was prepared and
the amounts were not included.
Page 2 of4
Mobile
Command
Vehicle
This reappropriation is
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
Library Department -Technology Fund
TE~06001 $27,600 Library RPID
Implementation
This 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.
Police Department -Technology Fund
TE-07002 Police Auto
Citation System
reappropriation 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,OOO for this project.
Public Works -Vehicle Replacement Fund
YR-. Replace This reappropriation is to provide funds
06801 Citywide fuel for construction in Fiscal Year 2009.
management and Construction has been delayed during
tank inventory the construction ofilia new MSC fueling
system facUity.
Page 3 of4
Recommended $400,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Recommended There sufficient
balance in the Fiscal Year 2008 budget that
can be reappropriated.
Recommended $125~OOO. There
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Recommended $200,000. There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Planning Department
Transit Station
Planning Department
55,000
EI Camino
intersection
Planning Department
PL-98013
Commutes
Downtown
North Traffic
Circles-
Hardscape
Work is ongoing on and has
been for the last two years using grant
funds placed in the Genera] 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 2009.
Recommended There is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
had been delayed until is
Caltrans (April 2008). Staff just budget that can be reappropriated.
received fonnal 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 2008.
project meant
to fund projects that improve school
commutes. These funds will be used as
the City's local share match for gran~·
funding for the Stanford Ave / EI
Camino Streetscape Project PL·07002.
The funds will be used for the design
phase in fiscal year 2009 and the
20
2004,
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 staffmg
vacancies in the Planning and
Division.
Page 4 of4
KeC~OlJ1lme:ml~ad $11 is
sufficient balance in the Fiscal Year 2008
budget that can be reappropriated.
Recommended $60,000. is sufficient
balance ill the Fiscal Year 2008 budget that
can be reappropriated.
PROJECT NUMBER
Exhibit C
City of Palo Alto
CAPITAL IMPROVEMENT PROGRAM PROJECTS
ComP.leted and Closed in Fiscal Year 1008
Golf Course Irrigation Pump, Motors and Control Panel Replacement
'Golf Course briving Range Turf and Netting 117,599
75,497
419
612
36,156
Additional Fire Frequency
Civic Center Parking -Security Upgrade
Briones Park Improvement
Main Library Configuration
Cubberley Building Code Modiftcation
Mumford/Alma/Scripps
RossiE. Meadow 4/12kV Conversion
Louis East Charleston
Utlllty Print Design _
GMR Project 13
New Reservoir and Pump
Middlefield Road Well
Eleanor Pardee Park Well
Two (2) New Vehicles
Phase Xli WC System
Galilen/Blbblts Outfall
Archive and Purge Record Management
System Ml.magement
Total ---~~~'-I
Total -----'-...:.....:..!.:;;:;..:...::-{
Total ----==-{
Total ____ ..:;.;;;.=..:.t
Total
Total _____ .......::;.::.J
Total ___ ...!.~~~
.. Balance to return to reserve.
Page 1 of 1
Revenues
Property Taxes
Sales Taxes
UtilitY. Users Tax .'
2007-08
Adopted
Budget
22,034
22.045
, 9,402
2007-08
Adjusted
Budget
22.735
22,400
9,793
EXHIBIT 0
2007·08
CAFRBasis
Rev/Exp
23,107
22;622
10,285
Transient Occupancy Tax 6.985 7,700 7.976
2007-08
Allocated
Charges
2007-08
Encurn+
Reapprop
nla
nla
nla
nla
2007·08
Budgetary
RevlExp
23,107
22,622
10,285
7,976
Other Taxes. Fines & Penalties 8,18] 8,431 7.847 nla 7,841
Charges for Services 20.383 20,383 19,311 nla 19,311
. !'.errnits&Lh;en~es ~ ____ ~ .. _~_~6.M4 __ . __ ...1i,Q1..4---~ .. ~4,831-. -.. -~~~. ~---nla~:-··-· --~4,831-
Charges to Other Funds 10,650 10,650 10,9]3 n/a , ]0,913
l{enlii.rIricOme:-· --' -' ... _. "--.~ ... -"'--' .~ .. ~ .. ~ 13,()37 .. 13~031 nla 13,591
Other Revenues 3,742 4,452 7,899 (27) nla 7,872
Add: Operating Transfers In
Prior Year Encum & Reapprop
Expenditures
Administrative Departments
Community Services
17,786
3.558
19.108
21,872
17,133
16,256
]7,140
3,558
1,12]
4,112
nla
n/a
1,721
614
17,133
3,558
19.098
21,866
2007-08
Vl!.riance
372
222
492
276
(590)
(1,072)
"'~-(1:,243-)
263
554
3,420
(653)
11
6
Fire
17,342
21,212
22,868 24,27~ 21,643 2,343 291 24,277 2
Library
Planning
6,484
10,137
7,035
10,148
6,221 601
8,953 705
_"':_I.~_~ ____ --__ I~" .27,981 29.78L_ .. ~~§,~. __ 2,613
PutilicWOl'RS -~ ~--------13.2~ ----13;254
Non-Departmental/School Site 9,229
Add: Operating Trans Out 10,707
CAFR Reconciliation:
7,903 6.985 440
15,570 13.654
Current year encumbrance/reappropriations
Prior year encumbrance/reappropriations
Current year stores adjustment
Prior year stores adjustment
CAFR Net Income
212 7,033 2
487 10.145 3
335~._22.1Jl4_ ~~ __ --2.. ===
324 13,243 11
475 7,899
13,654
4,460
(3,558)
(37)
98
4
1,91,6,
Exhibit E
GENERAL. FUND RESERVE SUMMARY ($0005)
FISCAL YEAR 2008
Fund Balance
Encumbrances
Reappropriations
Budget Stabilization Reserve
Reserve For Infrastructure Improvements
Notes Receivable Reserve
Stores Inventory Reserve
wr,: .. ",'", 111'1 Reserve
InreallZE~d Investment Gain/Loss Reserve
Reserve For Equity Transfer Stablization
Reserve For Emergencies
for
Page 1 of 1
Balance
06/30/07
39,408
(3,390)
(71)
27,480
o
1,182
2,567
1,253
0'
3,465 o
Net From,
3,007
(426)
(577)
, (1.378)
o
1,073
432
779
1.035
63
o
61
Balance
06/30/08
42,415
(3,816)
(648)
26,102
o
2,255'
2.999
2,032
1,035
3,528
o
'.
Exhibit F
WATER FUND ($000)
REVENUE
Water sales
Other revenues
Reappropriatlons I Enc
~T9:t~~J~,!;V)g~·lJif.:~· 5
EXPENSES
Purchases
Other Expenses
TOTAL OPERATING EXPENSES
Capital Expenses
-
REVENUI;
Electric retail sales
E;lectrie wholesale sales
Other revenues
Bond Proceeds
Reappropriatlons f Ene
. TQr ~~:liEVENUI=: """
EXPENSES
Purchases
NCPA & TANC Debt Svc
Other Expenses
,
leTAI: ePERA'FIN<3-EXPENSES----
. Capital Expanses
Principal Payments
FY 2007
ActJEnc
23,Q4'4
3.227
13,044
7,806
10,736
18,542
8,565
FY2008
AdJu.t9d
eudget
26,528
2,151
3,666
.9,340
14,309
23,649
14,463
ELECTRIC FUND
FY2QQ7 FYiOOa
ActlEnc AcjJulltlld
RfllIPprop Budget
85,417 90,506 . .
25,584 20,848 . .
9,326 11,922
. :121);32~t ; '/. {: .,'1 ~I),~~'~
62,478 78,601
8.443 8,686
35,111 42,495
-,--"-.... ~. 106;032-129;982
18,730 13,642 . -
FY 2008
Reapprop
Actual/Ene
25,975
3,301
3,666
8,363
12,515
20,878
14,988
FV2008
Reapprop
ActuallEne
90,833 .
25,173
1,350
8,922
.: >126;~78
71,065
6.554
40,725
120;344
15,768
100
'.
$ Variance
(553)
1,150
977
1.794
2,771
(525)
$VarlancII
Favorable
(Unfavor.)
327 -
4.325
1,350 -
.. /::8.092
7,536
332
1.770
..
9;638-
(2,126)
(100)
:.fbTAI.,EXP.ENS~~· . :~ ~ , .... -1'24."62'· I;;':f; d·~3.~i4:..' :·::·;:t~6.21i_ .:.:~:~:::t.~J.4~2· .. .. "
: f.oi(F.~P·M). ~~SERVES'; /:. ;:;' .; ...... } .• ~.: ':'(4;43~) !':;:';'~~~(~#i348J:~·~;itm'f(9;934). :.'..:t3i41~·.
.
..
REVENUE
Gas retail sales
Gas wholesale sales
Other revenues
Reapproprlatlons I Ene
Exhibit F
GAS FUND
FY 2007
AclIEnc
Reapprop
41.457
1,490
4,620
FY 2008 I'Y 2008 $ Var1anca
Adjusted Reapprop Favorable
Eludest Actual/Ene /Unfavor.l
48,041 48.100 53
316 2,261 1,945
7.515 7,515
tt.p..T~.l.n~~'V~~tiE . :'('. ':~ /,' ~>!:;:'::,~'~t;~6.1~ ?+;:;:l:;51~;~j~":r/'{~t lii,Qi':~ ",': 'i;: f:: f:'~~~~
EXPENSES
Purchases
Other Expenses
TOTAL OPERATING EXPENSES
22,250
12,704
34,954
10,838-
28,003
14,259
42,262
~~;913
27,220 783
12,979 1,280
40,199 2,063
13,632 ;m 281
~~~~~~m ........ m~~~~=I~Wi;1CP,I!tt~e~~~~:~:'J~~s.*:'):~"1;~~~t.1j#:' ~~\ft{$(.tf$~~;::'?,,;?l![f~Ji8~~;?!."~~*f.t:l;#:al~~I-""""·~~-~~~·· ......... ~~.=m~
~i91(jjjQMtR§~i!i.i~,v.g'1i;~?~\Jf;~~};1FI~:~~1rj{lt~J: m~ik;~[f.*1\i(g~tb:;~7~i?!ii;(!4:!3.;{)~'·;~~~;~~~~::
WASTEWATER COLLECTION FUND
REVENUE
Revenues
Reapproprialion& I Ene
~f.~Tl~:,R~VENlJi:>·
EXPENSES
Sewer Trealment Exp.
Operating Expenses
TOTAL OPERATI"lG EXPENSES
===========.::::: ...... ::::: . ..:::::..:::::..:::::..:::::-:::::-=-=-=:::::tm~p:;~~~'::a~::~ts-~--·· ..
;J:Q;rA~,~~p~~.s{;~:;,:':· ,.
FY 2007 .
Act/Ene
15,726
9,587
6,142
3,181
9,923
1.3fi'89~
54
FY 2008
15,944
5,966
1,101
5,202
12;303
~_ 9,16~
55
FY 20G8
Reapprop
A.ctual/Ene
16,627
5,966
7,056
4,814
11,870
"Q~
55
.
$Varlanee
Favorable'
683
45
388
433
(4-;006)
2
Exhibit F
• _____________ • ___________ ~~ro~~_~ ___ ~~_~ _______ ~_~
WASTEWATER TREATMENT FUND
fY 2007
Act/Ene
REVENUE
Operating Revenues 17,717
Restricted Bond Proceeds 21
Loan Proceeds
Reapproprlalions I Enc 15,912
Sonded ReapprofEncum 64
" '".' :;··:.;·::::,:.~:·:~;3~i7U~
EXPENSeS
Operating Expenses
TOTAL OPERATING EXPENSES
REVENUE
Revenues
Reappropriation!! f Ene
16,406
16,406
FY2007
AoIJEnc
26,340
998
... '
FY 2008 FY 2008
Adjusted Reapprop
21,015 23,905
9 9
4,879
23,804 23,804
17 17
,:·:·,:~~;]'~2;6J4 ,
18,582 16,696
18,582 16,696
FY 20D8 I'V2006
Adjusted Reapprop
29,849 29,850 '
884 884
$ Variance
Favorable
2,890
4:879
,.:;:: ',:;:':1r.;tW
1,886
1,886
$Varlancl'l
Favorable
~,[Q.r~\l;:~E\I~.N,liE .<,.". ": ,,' '. ~;>:>.3M~.~,·:·,,,·s~·.30,,7~~·,,:·
EXPENSeS
Payments to PASCO 7.625 9.828 9.276 552
Other Expenses 18,198 21.772 20,994 778
TOTAL OPERATING EXPENSES 26.023 31,600 30,270 1,330
3
Exhibit F
STORM DRAINAGE FUND
FY 2007 FY2008 FY2008 $ Variance
ActlEnc AdJusled Reapprop Favorable
AclualiEllc
REVENUE
Revenues 6,346 8,307 5,346 (2,961)
Reappropriallons I Ene 2,379 2,295 2,295
Bonded ReapproJEncum
Restricted Bond Proceeds
i:\I;]ifK~~~E.~E"4Q Et t·:;: ;"; . /-, /".;;:'1; :;:~t\:,{~,£·:tiI~':: :'~i;':~~;~:1 !r.,~q,2f;;,/*~j'Et;:~~1':. :,: :': \ ;:(~;nn
EXPENSES
Operating. Expenses 2,118 2,344 2.379 (35)
TOTAL OPERATING EXPENSES 2.118 2,344 2.379 (35)
Capital, Expenses 3.801 9,885 8,472 1,413
·34()'-~ ~--~-............ ~ ..... ····~--~I~PrlnGlpaJ-Paymenta.~-~--~-~ ~60-·~·-···360
... ~~~~~~~~~ :iI'r-"'j{lrJCfiS.B§~SE$>~,.".i.);~,~;:;j')'::::~~:~':'~J~J'iI'';i<d':·t;!;';';:l:ir';'''ii.<i6'.:i!;:t~~i:!JJ.'A .. ::~~ .. :;:·,:::·:;-,··:::t:f·''-;';L .. ~~""~~'--~--.''''''l -.. :.:: .. ::: .... ~m.~: ~"~ ...... ":-~.:.~~.~ .... }tlO-.,......,.. ... ~1;4.!i.;'i.""'~Jft!~y~~.""~,.J •. :r~u.';,\" .. :.r~~~Id;;;"\~~··:I.7>t.· .. ~~ .• ;1-
EXTERNAL SERVICE FUND
REVENUE
Revenues
Reapproprlations I Ene
;.TO:r~VRE\(E~UE "
EXPENSES
Operating Expenses
TOTAL OPERATING EXPENSES
I'Y2007
Act/Ene.
792
806
'806
FY 2008
Adjusted
1,243
5
1,232
1,232
I'Y,20fl$ .
Rellpprop
ActuallEnc
919
5
928
928
$ Variance
Favorabl&
(324)
304
304
;,92~,,<::;:," ,;:.30~'
(4)::,~;;;,:?;i~,3~U;'~)
4-
Water
$17/630
(2,924)
Electric
Exhibit G
RESERVE SUMMARY ($000)
Gas wwc WWT Refuse
<:i;~; ~~;7g~:: :,~,," ~t;:S?;'l ::>'~~;~~~~l~;~~~1~p~t~,~!i~t~~?,P~:1~/~:;;.~~'fji~"t:/ fiiii.~)%~\~:::
General RSR
Supply RSR
Distribution RSR
RSR
tFrrIPrrll>n."V Plant Replace
Water Resources Board
Shasta rewind Loan
Central Valley Project
Public Benefit Program
External Service • IT
External Service • HR
19,200
$13/111
13,111
1/595
47,309
13/958
-61/277
3/057
70/397
709
22
2/109
7,399
4,734
12,133 6,027 (7/285) 3,832 (1,384)
1,328 881 2,583
635
$0
, ,~ttei:v~s:' ~:~. ,,,·:::i~;~9.6~·::'~~i37~71;; (::~3;4.i;~~:'1i;jQ~1:{;;,~H(~;Z~~)%S:4~'(;~,~; ,{~;~~;,~~:!:!;::~>;;);;~.
$15,276 $71,111 $8/405 $5,803 '($12/596) $4t'U4
(3,165) (9,834) 3/727 224 5,311 (582)
JX -;~,)i;#.~;\ ::;:,;:~~~~7ft~ .i2!:i~3,tj;l:f;!i~7\~;\~(!;~j,~j%i~( 3;Q3a'!:\:';, \ "i!'of.~:l'I:"f'"
$14/301
54,708
18,702
87;711
9,444
70,397
709
636
22
2,109
$95,604
(7,893) ,.;}";#;7#
Citv of Palo Alto
CAPITAL IMPROVEMENT PROGRAM PROJECTS
Fieal leaf 21)06 Year·EJld Adju$(meIlU
I Couree Irrigation Pump, Mof()($ snd PG-07700 13,316 General Fund To Iransfer approprlellon from PG.08001 to P(J.07700 10 cover
Conlrol Panel Replaeement expense ovor bUdget
80471009 Golf Course Driving Range Turf and PO·08001 (13,315) Genaral Fund To Iransfer approPrIation from PG·00001 10 PO·onoo 10 cover
Nelllng expense over lIullgel
50471011 Street Maintenance PE·Boo70 (2,614) (2,614) Proposilion 1S· Local Slreet and Road To ~dlust budget to aClO8l amounl received
ImQrovement
60471010 Mlichell Park Library 1>1:'04012 3,000 3.000 UlIlIlles CARE Program Increase revenue expense foo 10 addilionul revenue from Unilles
CARE Program (Consullenl Assistance fO! Resource EffiCiency
Program)
80471008 FoOlhilis InterpretiVe Cenler OS·0700Z 2,229 CIP ProJacrQS·00001 • Open Space To transfer approprlallon from 08,0000110 OS-07002 and OS·
Trails and AmenlUus 0700310 cover expense over bUdget
80471008 FoolhHls Park Maintenance 0$·07003 9,161 GIP ProjeCi 08-00001 • Open Space To transfer appropriation from 08·00001 to OS-07002 and OS·
Trails and AmenlUas 07003 10 cover &XPuns8 over budget
e0471000 Open Space Trails and Amenities 0$·00001 (11.390) Infrastructure Reserve To lransfer appropriation from OS·OOOOl to 08-07002 and OS·
386 388
20020202 Pat!< Blvd. SIlb. Bus. EL·OOO05 (13,000) Electric Rate Slablllzallol\ Reserve Return portion of the appropriation baCk 10 Eteclllo Rale
20020202 UG Oislllcl41 el·0300t (1.000,000) EI!ctI1C Rate Stabilization Reserve Retum po",on of the approprlaUon beCk 10 Electrlo Rate
SlalllII~aHon Reserve
20020202 UG 0;$trlcI39 EI.-03006 (00,000) eleoh10 Rille Stabilization Reserve Return portion altha appropriation bad( (0 efeoll1c Rate
SlebllltaUon Reserve
20020202 Colorado Sw St&lIon :1151< El.o&lOt (2,600,000) Elecli1c Reta SlebllllaUon Reserve Return portion of Ina appropdsllon badl to Elecirle Rate
20020202 Relocation· Alma Sub Station . el.·05003 43,1110 Etec!rIe Rate SlablazaHon Reserve
SlebllzaUoll Reserva
To provide additional appropriation to cover aelulll cosls
. 20020202 UG Dlalf1ct 46 El·!l8OO2 (172,677) Elec!dc Rate StabUi~ellon RalGrvs . Return portion 01 Ihe appropJlatton baCk to Etecl~c Raw
20020811 J'lber OpQc Customer EL.b5000 (133.1172) Elec\1Ie Raie SlabJIJetlon R~srve Retum portion ol!ha appropJlallo,; \jaCk to Elecl~c Rate
2002020Z E. Meadow/Alma Lorna EI.·00002 153,408 Elec!rIe Rale StabUizatlon Reserve To proVide addlUo"81 approprlatlon 10 eaver aclual costs
20020202 Rebuilt! UG Dlstrlet 22 El·11005 67,049 Elacille Rete Stablll~allon RG$erve To provfde additional appropriation 10 cover aClual costs
20020201 EleClJlc Cuatomer Connections El·6I!028 29&,379 Electric Rete StablllzsUon Reserve To provide additional appropliaUon to eaver actllal coalS
20020403 Commun1cations System EI.·89031 (61,872) eleCl~c Rate StablliUlllon Reserva Ratum portion of Ihe appropriation bae\< to Elect~c Rata
20020202 Substation ProtectIOn El·89035 (60,029) Elocl~c Rate Slebllllallon Ruerve Relum poltlon of Ule appropriallon back. to Eleclric Rala
StabHlzoUon ReServe
20020202 Sub$laUOI1 FaCility EL·89044 (327,853) Eleclf1c Rate $tablllzelion Reserve Retum portion of the approprleUon bee\< to Etect~c Rale
StabUlzaliOll Reserve
20020202 EIec1rJc System Improvements EI.-960oa 16,000 Electric Rale Stabilization Reserve To provide addlUonalapproprlallon to cover ac\ual easts
0 (3,833,010)
Compressed Natural Ga8 OS·00011 2,946 G88 Rate. Stablllzallon Resiw8 To provide addillonalappropnaUon fO! 8 purchases order
20020802 Syslem Extension Operallons· GS·03OO9 (305,409) G88 R~le Stablllzallon Reserve Retum portion of the approprlallon bae\< to Gas Rale
Unrelmburs9d Reserve
20020802 CNG Seq Fuel System OS·03010 31,766 Gas Rate SlaIIlllzllllon Reserve To provide additionalappfOpriation for a purChases order
20020802 Elwell Court Tunanllmprovemenls GS·07ooo 39,292 G8& Rate Slablllzatlon Reaerve To ptovlde addlUonal appropnallon 10 cover ecluel costs
20020802 GMR PtoJGel14 GS.()400l (78,800) Gas Rale Stablllzallon Reserve Return portion Of!ha apprOpri~tlon becIIlO G9$ Rate
Reserve 0 (610,276) ok
System RIlilabllllalion. Project 17 WC·04002 312,670 wwa Rate SI8b1l1zaUon Reserve To provide addltlonaillP.propnation for a purchases order
WC-05OO3 (30,000) wwa Rete Slablllza/lon ReseMil Relurn portion of Ihe appropr!8l1on becIIto wwa Rate
SlablllzaUon Reserve
WC-990~3 (300,000) wwa Rata Slablllz8ll0n Reservs Retum portion of the epproPrl8\lon back 10 wwa Rate
StablUUllion Reserve
0 (17,130) ok
V\fS·01010 (94,460) water Rala Stablllz8uon ReseNe Return portion oflhe approprtaUon baCk to Water Rata
StablRzeuon Reserve
20021002 DlstobuUon System WalerQualey V\fS·Ol011 (41,690) water Rete Steblll~allon ReseNe Ratum porllon of Ule eppropnaUon b~Ck io Waler Rale
Steblllzalloo Reserve
20021002 Booster Station Improvement V\fS·01012 WeIer 1«118 Sleb1li~etlon Reser.oo Return portion of 1I1e approprtallon baCk 10 Waler Rate
(17,668) StllblVzaUon Ruerve
20021002 ~R ProJeot16 WS·02003 (69.961) Waler Rille Stabilization Reserve Retum portIOn 0/ the approprlaUon back to Waler Rete
Stablllzalion Reserve ,
20021002 Exls6ng Well Rehabilitalion V\fS·02004 (6,891) Water Rete Stabilization Reserve Relum POrtion of !he appropliaUon back to waler Rele
Stabllzallon Reserve
20021002 Wal~r System Sampling WS·0600?' (13,948) Water Role Slablllzatlon Reserve Retum pOlllr.>n 01 the approprtaUon back to ,Water Rate
'SlablPzaUon Reserve
20021002 Wetar Service Hydrant WS·80014 (150,000) waler Rate slabjll~allon Reserve Return pOlllon of !he appropr1allon back. to water Rate
20021002 Waler Meters V\fS·80015 (100.000) WilIer Rate Stabllizallon Resel'll) Relum portion of the epproprlaUon back. 10 water Rate
20021002 WMR Pro)ecl19 V\fS.05001 (807) water Rala Stablnz.allon Reserve Relurn pOlllon 01 the epproprisllon back. 10 Waler Rala
0 (495,:W5) 01<
page 1 of 1