Loading...
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