The URL can be used to link to this page

Home My WebLink About2003-03-04 City Council (2)of PaRo Alto C ty Manager’s Report TO:HONORABLE CITY COUNCIL ATTN: FROM: FINANCE COMMITTEE CITY MANAGER DEPARTMENT: ADMINISTRATIVE SERVICES DATE: SUBJECT: MARCH 4, 2003 CMR:160:03 2002-03 ADJUSTED BUDGET - MIDYEAR AMENDMENTS AND CAPITAL IMPROVEMENT PROGRAM STATUS RECOMMENDATION Staff recommends that the City Council adopt the attached Budget Amendment Ordinance (BAO) (Attachment 1), which includes: a. Proposed midyear adjustments to the 2002-03 Budget for the General Fund, Enterprise Funds, Special Revenue Funds, Internal Service Funds, Debt Service Fund, and Capital Improvement Fund (Exhibit A). b. New or amended 2002-03 CIP Project Descriptions (Exhibit B). c. Amendments to the 2002-03 Adopted Municipal Fee Schedule (Exhibit C). d. Amendments to the 2002-03 Table of Organization (Exhibit D). The 2002-03 midyear Capital Improvement Program Projects Status Report is attached as an informational item (Attachment 2). A list of continuous projects follows this summary (Attachment3). No action is required on these two items. BACKGROUND This report summarizes the changes to the 2002-03 Adopted Budget as part of the normal course of business from July 2002 through January 2003. Where possible, adjustments are held until this mid-year report is brought to Council in an effort to streamline the BAO process year-round. This discussion is categorized by fund with a primary focus on major changes in the General Fund. Details of these changes, as well as all fund summaries, are included in Exhibit A. The midyear CIP project status report (Attachment 2) provides the Finance Committee with information on the status of the City’s CIP projects as of November 30,2002. CMR:160:03 Page 1 of 9 DISCUSSION General Fund The following is a summary of major revenue and expenditure adjustments as detailed in Exhibit A. All comparisons are made from the 2002-03 Adopted Budget. Revenues: (reduced $1.1 million) City revenues continue to show significant weakness. Sales taxes in the second and third calendar quarters (receipts fall into current fiscal year) compared to prior year quarters, show declines of 12.0 and 6.2 percent, respectively. Preliminary information from the Stanford Shopping Center and Downtown merchants indicates a particularly soft fourth quarter with sales either fiat or down compared to last year. Transient occupancy taxes (TOT) also continue to be very soft. Negative revenue adjustments in this report are higher than those initially anticipated. This results from having actual fiscal year data that shows no improvement and an economy that has not reached bottom. While many economists and business leaders believe the economy is near bottom and expect conditions to improve, there is no evidence in the economically-sensitive revenue generators of such a turnaround. Based on this information, staff believes that the City’ s revenue picture will not improve until fiscal 2004-05. Sales and Use Tax (reduced $1.5 million, 7%) The projected shortfall in sales tax revenues results from the continued softening of the Silicon Valley economy. Layoffs in high technology, the dramatic decline in consumer confidence, and the elimination of dot- com firms have led to a cutback in new automobile, electronic equipment, computer, and other retail purchases. Consumers appear reluctant to spend in light ot~ layoffs, declining equity values, and the uncertain international environment. In addition, staff believes competition from "big-box" stores on the City’s boundaries, "high-end" malls in San Jose, and Internet purchases may be eroding the City’s sales tax base. Property Tax (increased $0.1 million, 1%) Property taxes are expected to exceed budget based on the continued marginal appreciation of appraised property values. These receipts are negatively affected only when residential and commercial property owners successfully appeal the assessed value of the property upon which they are taxed. The County has reassessed higher-valued properties in Palo Alto downward, but this has been more than offset by increases in other residential properties. At this time, staff is not aware of rising commercial property tax appeals, but is aware o.f a high vacancy rate that could affect values and next fiscal year revenues. Transient Occupancy Tax (TOT)(reduced $0.4 million, 5.7%) The local business and tourist downturn has led to low occupancy and reduced average-room-rates. This trend has seriously eroded hotel tax receipts. Occupancy and room rates this year have fa!len below the already low averages of 58 percent and $135 seen during the first half of 2001- 02. Adjustments to the current budget are necessary in light of the weak local economy CMR: 160:03 Page 2 of 9 and poor performance from the TOT. Annual TOT revenues for 2002-03 are expected to be near previous year levels of $6.6 million. Other Taxes and Fines (increased $0.5 million, 7%) This increase primarily results from two main sources: $405,000 in Documentary Transfer Tax revenue and $132,000 in Motor Vehicle in-lieu Tax revenue. Transfer tax revenues are related to continued high levels of local property sales activities. While threatened by the State budget crisis, staff anticipates the State to continue full funding for the Motor Vehicle In-Lieu Tax in the current year ($3.4 million). This revenue will be adjusted during the 2003-05 budget cycle if action by the State Legislature warrants it. Other Revenue (increased $0.2 million, 2%) This increase is made of various one-time grants and small increases in ongoing revenues as detailed in Exhibit A. Expenditures: (reduced $1.0 million) Salaries & Benefits (net reduction $45,522) Savings in the Administrative Services Department overtime and temporary salary costs ($67,630) is partially offset by gant- funded temporary salary expense in the Community Services Department (CSD). The General Fund currently has 38 frozen positions with approximately $0.7 million in funding already removed from the budget related to 12 of these. This report does not further adjust this budget category for the additional 26 frozen positions, however this cost savings should approximate $1.4 million by year-end. Contract Sen, ices (increased $265,218) Approximately half of this increase is related to one-time gant revenues; $80,718 is related to start-up costs for the funding the Friends of the Palo Alto Library modular facility at Cubberley Community Center (CMR:406:02, 10/21/02); $42,500 is a one-time expense related to enacting the new golf-pro ageement. General Expense (increased $67, 600) Funding for the City’s assessment related to the new parking structures was inadvertently omitted from the 2002-03 Adopted Budget and is now added as an ongoing General Fund expense. Operating Transfers-Out (reduced $1.2 million, 5%) This net savings is comprised of two main elements: (See the CIP section for more information on these transactions.) 1. $0.9 million net reduction in Capital Fund transfer: This reduction is the result of an approximate $1.2 million reduction in project spending in two projects: Civic Center Infrastructure Improvements--CIP 10102, and Roofing Replacement--CIP 10006. New funding of $0.3 million is also being proposed in four projects. 2. $0.1 million reduction in Debt Service Fund transfers: A one-time reduction in General Fund transfers to debt service results from closing CIP 19624 Golf Course Improvements, using proceeds to pay debt service as well as reimburse reserves for the 2001-02 golf operating shortfall of $0.1 million. CMR:160:03 Page 3 of 9 Enterprise Funds Major operating fund issues are discussed below. Please refer to the detail fund summaries in Exhibit A for more information on these midyear changes and to the CIP section for a discussion of the changes in Enterprise CIP project funding. Electric Fund (Net reserve increase of $7.5 million) Revenues (reduced $0.5 million) The fund experienced a drop in projected wholesale revenue ($480,000) primarily due to Dynergy and Enron no longer participating in shared transmission services. A $41,000 decrease in revenue indicates a geater participation in the Utilities Residential Rate Assistance Progam (RAP) servicing low-income residents. Expenditures (reduced $7. 9 million) The fund has reductions ($8.2 million) in commodity purchase expense due to budgeted contract settlement obligations with NCPA being settled in fiscal 2001-02. This reduction is partially offset by additional expense in capital projects ($225,000). Gas Fund (Net reserve reduction of $0.6 million) Revenues (reduced $0.6 million) The fund experienced a drop in projected net sales revenues due to a reduction in estimated gas sales to the electric backup generator (COBUG). An additional $32,000 revenue decrease is due to increased participation in the RAP for low-income residents. Water Fund (Net reserve reduction of $28,000) Revenues (reduced $28,000) Additional revenue reduction of $28,000 indicates increased participation in the City’s RAP, lowering utility costs for low-income residents. Wastewater Collection Fund (Net reserve reduction of $70,000) Expenditures (increased $70,000) Additional equipment funding for necessary sewer pumps. Wastewater Treatment Fund (Net reserve reduction of $141,706) Expenses (increased $I41,706) Increased CIP 9707 Wastewater Solids Disposal Project funding from restricted bond proceeds to be used in rehabilitation project. Capital Improvement Program Adjustments to the City’s-2002-03 Capital Plan are noted in Exhibit A, with two specific project adjustments described in Exhibit B. All of the CIP changes fall into two basic categories: projects requiring additional appropriations (including new projects), and other miscellaneous adjustments such as reducing or transferring project appropriations. CMR: 160:03 Page 4 of 9 New Projects or Increased Appropriations MSC Feasibility Study--CIP 19906: Project title change from MSC Permanent Seismic Retrofit Study along with a change of project scope. Community Theatre RenovationsJCIP 19910: Change in project scope. Light board being purchased for the Community Theatre. ($45,708 CIP 19910 and $21,292 transferred from Arts and Culture Functional Area budget.) Traffic Signal at San Antonio--CIP 10206: Additional appropriation to fund this Caltrans project. ($46,800 IR funding) ~ Roth Building Wings Demolition--CIP 10304: Additional revenue and appropriation of that revenue. ($30,350 Summerhill Homes Revenue) ~ Enterprise Resource Planning--CIP 10216: While this multi-year project size and scope remain unchanged, additional appropriation is necessary for 2002-03 to accommodate current-year expense for hardware and other associated implementation costs. This amount will be reduced from future-year expense projections. ($500,000 Technology Fund Reserve transfer) Projects with Transfers or Budget Reductions Civic Center Infrastructure Improve~nents--CIP 10102: Project is still in the design phase and construction funding is being returned to the Infrastructure Reserve (IR) to be re-funded in 2003-04. ($940,000 returned to IR) Roofing Replacement--CIP 10006: There is accumulated savings from various roofing projects and this amount is not being anticipated for spending this year. ($212,500 returned to IR) ~Street Maintenance--CIP 18670: Transfer of budget from CIP 10208 - Miranda Avenue Street Improvement to CIP 18670 where the Miranda Avenue constructions costs were encumbered. The Miranda Avenue improvements were completed in December 2001. ($100,000 inter-project transfer) Golf Course Improvements--CIP 19624: This project is complete and slated for closure in 2002-03. Of the $336,000 in project financed bond proceeds remaining, $144,508 is applied to the next debt service payment for 2002-03. As the 2001-02 Golf Course pro-forma indicated a $102,000 General Fund subsidy at year-end, this transaction reimburses the General Fund by reducing debt service expense as reflected in Exhibit A. The remaining savings of $42,500 will be appropriated to the Community Services Department, Golf Services Functional Area to offset additional expenses associated with the new Golf Professional Management agreement. CMR: 160:03 Page 5 of 9 Enterprise Resource PlanningJCIP 10216: Consolidation ofvarious technology project funds is being centralized as part of the RAF-FS implementation plan. These transactions do not increase the total appropriation approved by Council on July 22, 2002. This amount will be reduced from future-year expense projections. Transfer of $459,250 in ERP-related budget from the following technology CIP projects to CIP 10216: 1.Financial Applications Development--CIP 19808 ($64,850) 2.Citywide Network Improvements--CIP 19711 ($26,900) 3.Citywide Network Hardware Redundancy--CIP 10107 ($57,500) 4.IT Systems Management--CIP 10108 ($110,000) 5.Permit Tracking--CIP 19516 ($200,000) Enterprise Fund Capital Projects Increased Appropriatiom o Traffic Signal Upgrade - Homer/Alma--CIP 8930: Additional appropriation by the Electric Fund to this project ($225,000 Electric Fund Rate Stabilization Reserve). Wastewater Disposal Solids--CIP 9707: Bond funds transferred in to appropriate part of the Incinerator Rehabilitation project ($141,706 Agency Funds). Other Funds ~ Special Revenue Fund: Attachment A indicates increased spending ($250,000) for predevelopment, relocation and acquisition costs of a new Opportunity Center providing social service and affordable housing as presented to Council on May 13, 2002. (CMR:253:02). $50,000 additional funding is also proposed to fund professional services expense related to the City’s Below-Market Rate Ownership Program. o Internal Service Fund (ISF): The Technology Fund is transferring $500,000 from its reserve balance to fund CIP 10216 Enterprise Resource Planning. As part of the RAFTS implementation plan approved by Council on July 22, 2002, staff is drawing down funding to cover additional implementation, hardware and other associated costs needed in 2002-03. The reserve was created to fund legacy system and other technology needs and has an approximate balance of $6.3 million after this transaction. Amendments to the 2002-03 Adopted Municipal Fee Schedule Staff is proposing to amend the 2002-03 Municipal Fee Schedule (Exhibit C) to include one new fee and two existing fee adjustments. These changes have little revenue impact on the General Fund in 2002-03, due mainly to the 60-day delay in implementing development- related fee changes. The new fee is a Temporary Discharge Fee in the Storm Drainage Fund. The fee adjustments affect the tiers for Building Inspection fees and the cost-recovery abilities of Major Project Architectural Review. Table of Organization Changes The three proposed adjustments to the Table of Organization (Exhibit D) inctude: a reallocation of 0.25 Full Time Equivalent (FTE) Office Specialist within the Community CMR: 160:03 Page 6 of 9 Services Department to fix an error in the original distribution; an add/drop within Planning and Community Environment of 1.0 FTE Planner to an Engineering Tech II,.with annual savings of $27,108, to fill a vacancy for an employee charged with the Zoning Ordinance and Single-Family Review activities; the removal of 3.0 F-rE within the Public Works Department due to the November 2002 rejection of Measure D by the voters. These last three positions were not included in the 2002-03 Adopted Budget, therefore no budget adjustment is required. 2002-03 Midyear Capital Improvement Program Projects Status Report This report provides the Finance Committee with information on the status of the City’s Capital Improvement Progam (CIP) projects as of November 30, 2002. In the attached matrix (Attachment 2), all City departments have submitted information on their projects and commented on any issues that might cause a change in the scope or timing of the projects. Information in this report is intended to keep Council abreast of progress on all CIP projects that were open at the beginning of the 2002-03 fiscal year and on those projects, which were added or completed during the current year. The attached matrix categorizes CIP projects into minor projects (projects which can be completed within a one-year period) and multi-year projects (projects which have multi- year budgets and/or complex implementation schedules with identifiable phases). The projects status portion of the matrix identifies the phase the project was in as of November 30, 2002. Information on phases is intended to give Council a perspective on how much progress was made on a project. Three distinct phases are utilized, as follows: Phase: Pre-Design Design Construction Activities: Preparation of a feasibility study Development of a master plan Definition of a project scope Preparation of an Environmental Impact Report Hiring a design consultant Completion of project design Soliciting bids or proposals Acquisition of major equipment Installation Implementation of a project The comment section of the matrix provides Council with information clarifying the status of certain projects. In the attached matrix, projects are listed by department for the General Fund and by fund for the Enterprise and Internal Service Funds. Within each department or fund, the projects are ordered by project number, which includes the year of Council approval (year CMR: 160:03 Page 7 of 9 of approval is shown by the second two digits of the 5-digit project number or the first two digits of a 4-digit project number). The matrix also includes information on the total or accumulated budget for projects, the remaining budget as of the beginning of the fiscal year, the fiscal year expenditures through November 30, 2002, including commitments (encumbrances), and the remaining balance in the project budget as of midyear. The matrix does not include "continuous" projects. These projects, such as water meter replacement, have no definitive beginning or end dates and receive ongoing funding to reflect the continuing replacement cycles or commitments. During the first half of 2002-03, progress was made on all of the "continuous" projects (Attachment 3). RESOURCE IMPACT Adoption of the attached ordinance will allow for adjustments to the fiscal year 2002-03 budget, along with the establishment of one new and two amended General Fund CIP project descriptions. With the approval of this ordinance, the projected ending balance of the General Fund BSR is $21.3 million, a reduction of $1.2 million. The General Fund Infrastructure Reserve is projected to end with a balance of $28.3 million, an increase of $1.1 million. The projected ending Rate Stabilization Reserve total for all Enterprise funds combined, increases by $6.7 million mainly due to reduced commodity expense in the Electric Fund. POLICY IMPLICATIONS These recommendations are consistent with existing City policies. ENVIRONMENTAL ASSESSMENT This is not a project for purposes of the California Environmental Quality Act (CEQA). ATTACHMENTS Attachment 1: Exhibit A Exhibit B Exhibit C Exhibit D Attachment 2: Attachment 3: Budget Amendment Ordinance with the following exhibits: Fund Summaries and detail changes to the General Fund, Enterprise Funds, Special Revenue Funds, Interna! Service Funds, Debt Service Fund and Capital Improvement Funds 2002-03 CIP Project Descriptions Amendments to the 2002-03 Adopted Municipal Fee Schedule Amendments to the 2002-03 Table of Organization 2002-03 Midyear Capital Improvement Projects Status List of Continuous Capital Projects CMR: 160:03 Page 8 of 9 PREPARED BY: CHARLES PERL Budget Manager DEPARTMENT HEAD APPROVAL: Director, ~/dministrative Services CITY MANAGER APPROVAL: EMILY HARRISON Assistant City Manager CMR: 160:03 Page 9 of 9 Attachment 1 ORDINANCE NO. ORDINANCE OF THE COUNCIL OF THE CITY OF PAL0 ALTO AKENDING THE BUDGET FOR THE FISCAL YEAR 2002-03 TO ADJUST BUDGETED REVENUES AND EXPENDITURES IN ACCORDANCE WITH THE RECOMMENDATIONS IN THE MIDYEAR REPORT WHEREAS, pursuant to the provisions of Section 12 of Article III of the Charter of the City of Palo Alto, the Counci! on June 17, 2002 did adopt a budget for fiscal year 2002-03; and WHEREAS, after reviewing the current budgeted revenues and expenditures for fiscal year 2002-03, adjustments to the budget are recommended to more accurately reflect year-end projections; and WHEREAS, the 2002-03 Adopted Municipal Fee Schedule needs to be amended to increase certain fees and to implement other miscellaneous changes; and WHEREAS, the 2002-03 Table of Organization needs to be amended to remove staffing that was contingent upon the passage of the library bond measure; to add 1 Engineering Tech II and eliminate 1 Planner; and to correct a publication error; and WHEREAS, adjustments in the Golf Course Improvement Debt Service Fund im_macting reserve balances are recommended; and WHEREAS, City Council authorization is needed to amend the 2002-03 budget as hereinafter set forth. NOW, THEREFORE, the Council of the City of Palo Alto does ORDAIN as follows: SECTION i. The General Fund Budget Stabilization Reserve is hereby reduced by the sum of One Million Two Hundred Three Thousand, Eight Hundred One Dollars ($1,203,801), as described in Exhibit "A", which is incorporated herein by this reference. As a result of this change, the Budget Stabilization Reserve wil! decrease from $22,527,000 to $21,323,199. SECTION 2. The General Fund Infrastructure Reserve is hereby increased by the sum of One Million One Hundred Five Thousand, Seven Hundred Dollars ($i,i05,700), as described in Exhibit "A". As a result of this change, the Infrastructure Reserve wil! increase from $27,162,000 to $28,267,700. SECTION 3. The City Council hereby authorizes the adjustments indicated to various Capita! Improvement Projects as shown in Exhibit A. SECTION 4. The sum of Four Hundred Fifty-Nine Thousand, Two Hundred Fifty Dollars ($459,250) is hereby transferred from the capital projects ~hereinafter described, to the appropriation for Capita! Improvement Project (CIP) 10216 (Enterprise Resource Planning). The amounts so transferred are from the following capital projects, which will be reduced by the amount listed: Financial Applications Development $64,850 (19808) Citywide Network Improvements (19711)$26,900 City Network Hardware Redundancy (10107)$57,500 IT Systems Management (10108)$ii0,000 Permit Tracking (19516)$200,000 Total $459,250 SECTION 5. The sum of Five Hundred Thousand Dollars ($500,000) is hereby appropriated to Capita! Improvement Project Number 10216 (Enterprise Resource Planning). This transfer will reduce the balance in the Technology Fund Reserve to 6,283,473. SECTION 6. The sum of Twenty-0ne Thousand, Two Hundred Ninety- Two Dollars ($21,292) is hereby transferred from the Community Services Department Arts and Culture Functiona! Area and appropriated to Capital Improvement Project Number 19910, Community Theatre Renovations. SECTION 7. The scope of Capital Improvement Project (CIP) 19910, Community Theatre Renovations, is hereby changed as shown in Exhibit B. SECTION 8. The sum of Forty-Six Thousand, Eight Hundred Dollars ($46,800) is hereby appropriated to Capital Improvement Project Number 10206, Traffic Signal at San Antonio Road/Highway i01 Off-Ramp, and the Infrastructure Reserve is correspondingly reduced. SECTION 9. Revenue and expense in the sum of Thirty Thousand, Three Hundred Fifty Dollars ($30,350) is hereby appropriated to Capital Improvement Project Number 10304, Roth Building Wings Demolition, for receipt of funds from Summerhill Homes. This transaction will have no impact on reserves. SECTION i0. Capital Improvement Project Number 10102, Civic Center Infrastructure Improvements, is hereby reduced by the sum of Nine Hundred Forty Thousand Dollars ($940,000) and the Infrastructure Reserve is correspondingly increased. SECTION ii. Capital Improvement Project Number 10006, Roofing Replacements, is hereby reduced by the sum of TWo Hundred Twelve Thousand, Five Hundred Dollars ($212,500) and the Infrastructure Reserve is correspondingly increased. SECTION 12. The sum of One Hundred Thousand Dollars ($i00,000) is hereby transferred from Capital Improvement Project (CIP) 10208 (Miranda Avenue Street Improvement) to the appropriation of Capital Improvement Project~(CIP) 9630 (Street Maintenance). SECTION 13. The title and scope of Capital Improvement Project (CIP) 19906, MSC Permanent Seismic Retrofit Study, is hereby changed to "MSC Feasibility Study" as shown in Exhibit B. SECTION 14. Capital Improvement Project Number 8930, Traffic Signa! Upgrade, is hereby increased by the sum of Two Hundred Twenty-Five Thousand Dollars ($225,000) and the Electric Fund Rate Stabilization Reserve is correspondingly reduced. SECTION 15. Capital Improvement Project Number 9707, Wastewater Solids Disposal Project, is hereby increased by the sum of One Hundred Forty-One Thousand, Seven Hundred Six Dollars ($141,706) and the Wastewater Treatment balance of Restricted Bond Proceeds is correspondingly reduced. SECTION 16. The Municipal Fee Schedule is hereby amended to reflect the changes shown in Exhibit C, which is attached hereto and incorporated herein by reference. These changes wil! not impact the General Fund Budget Stabilization Reserve. SECTION 17. The Supply Rate Stabilization Reserve in the Electric Fund is hereby increased by the sum of Seven Million Seven Hundred Nineteen Thousand Dollars ($7,719,000) to reflect increased revenues in the Electric Fund as described in Exhibit A. SECTION 18. The Distribution Rate Stabilization Reserve in the Electric Fund is hereby reduced by the sum of Two Hundred Fifty-Five Thousand, Eight Hundred Eighty Dollars ($255,880) to reflect reduced revenues in the Electric Fund as described in Exhibit A. SECTION 19. The Supply Rate Stabilization Reserve in the Gas Fund is hereby reduced by the sum of Six Hundred Thousand Dollars ($600,000) to reflect reduced revenues in the Gas Fund as described in Exhibit A. SECTION 20. The Distribution Rate Stabilization Reserve in the Gas Fund is hereby reduced by the sum of Thirty-Two Thousand Dollars ($32,000) to reflect reduced revenues in the Gas Fund as described in Exhibit A. SECTION 21. The Rate Stabilization Reserve in the Water Fund is hereby reduced by the sum of Twenty Eight Thousand ($28,000) to reflect reduced revenues in the Water Fund as are described in Exhibit A. SECTION 22. The Rate Stabilization Reserve in the Wastewater Collection Fund is hereby decreased by the sum of Seventy Thousand Dollars ($70,000) to reflect increased expenditures in the Wastewater Collection Fund as are described in Exhibit A. SECTION 23. The Rate Stabilization Reserve in the Wastewater Treatment Fund is hereby decreased by the sum of One Hundred Forty- One Thousand, Seven Hundred Six Dollars ($141,706) to reflect increased expenditures in the Wastewater Treatment Fund as are described in Exhibit A. SECTION 24. The Rate Stabilization Reserve in the Storm Drainage Fund is hereby increased by the sum of One Thousand Seven Hundred Fifty Dollars ($1,750) to reflect increased revenues in the Storm Drainage Fund as are described in Exhibit A. SECTION 25. The Housing In-Lieu Reserve is hereby reduced by the sum of Fifty Thousand Dollars ($50,000) to reflect increased expenditures as are described in Exhibit A. This transaction will reduce the balance in the Housing in Lieu Reserve to $9,801,000. SECTION 26. The Community Development Block Grant Project 01078, Community Working Group - Opportunity Center, is hereby increased by the sum of Two Hundred Fifty Thousand Dollars ($250,000) to reflect increased revenues as are described in Exhibit A. This transaction will have no impact on reserves. SECTION 27. The Table of Organization as amended to reflect changes shown in the attached Exhibit D is hereby approved. SECTION 28. As specified in Section 2.28.080(a) of the Palo Alto Hunicipal Code, a two-thirds vote of the City Counci! is required to adopt this ordinance. SECTION 29. The Council of the City of Palo Alto hereby finds that this midyear adjustment is not a project under the California Environmental Quality Act and, therefore, no environmental impact assessment is necessary. However, projects described in this ordinance will be assessed individually as appropriate. SECTION 30. As provided in Section 2.04.375 of the Palo Alto Hunicipal Code, this ordinance shall become effective upon adoption; provided that all new Planning Department fees, more specifically described in Exhibit "C," shall become effective sixty (60) days from the date of adoption. /! !! !! !! !! !! !! INTRODUCED AND PASSED: AYES: NOES: ABSTENTIONS: ~_BSENT: ATTEST: City Clerk APPROVED AS TO FORM: City Attorney APPROVED: Mayor City Manager Director of Administrative Services Exhibit A CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY GENERAL FUND (in thousands of dollars) 21,035 21,035 13,536 13,536 7,000 7,000 7,370 7,370 7,903 7,903 17,730 17,730 11,827 11,946 13,008 13,008 9,079 9,217 19,542 3,644 6,600 Revenues & Other Sources Sales Tax (1,493) Property Tax 108 Transient Occupancy Tax (400) Utility Users Tax Other Taxes, Fines & Penalties Charges for Services Charges to Other Funds Rental Income Other Revenues Total Revenues 108,488 108~745 ~ 07,695 ! Operating Transfers-In 14,335 14,335 Encumbrances & Reapprop 3,780 - From Infrastructure Reserve 3,346 3,346 Total Sources of Funds ........126,169 130,206 ; ~29,156 (1,050) Expenditures & Other Uses City Attorney 2,517 3,204 City Auditor 804 927 City Clerk 767 798 City Council 247 249 City Manager 1,647 1,776 Administrative Services 10,974 11,454 Community Services 24,530 25,120 Fire 19,055 19,228 Human Resources 2,344 2,459 Planning and Community Environment 8,359 9,487 Police 21,888 22,251 Public Works 14,327 14,632 i Non-Departmental 6,870 6,870 Total Expenditures 114,329 118,455 Operating Transfers-Out 11,579 11,579 Total Uses o~Funds 125,908 130,034 Net Surplus (Deficit) ....261 172 Adjust intra-fund reserve transfer (3,346)(3,346) Net To (From) Reserves ....(3,085)(3;174) 129i082 74 (3,2721 64~082 537 198 ,050) (64) 128 12 18 115 (1,229 (962 (98 (98 Beginning Reserves 64,082 64,082 Projected Ending Reserves ....60,997 60,908 60,810 (98 iBudget Stabilization Infrastructure Emergencies Encumbrance & Reappropriation Notes Receivable Unrealized Gain on Investment Inventory of Supplies & Materials Equity Transfer Stabilization Total 22,680 22,527 n.a.27,162 n.a.5,665 n.a.1,293 n.a.1,520 n.a.1,985 756 n.a 60,908 756 60,810 ~l (1,204) 1,106 (98: Fund Summaries - 1 Exhibit A CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY ENTERPRISE FUNDS (in thousands of dollars) Sources of Funds Net Sales Interest Income Bond Proceeds(restricted) Other Income Reapprop/Encumbrances Total Sources 72,766 15,383 7,240 496 31,566 11,299 18,603 18,659 2,124 395 836 678 921 21 14,369 690 656 530 3,040 993 61 1,043 13,896 3,973 6,876 9,187 2,550 581 3,854 3 108,27136,62419,667 28,998 25,170 3,719~ 19,794~1,051 21,382 243,294 8;045 745 27~192 65 54 864 166,271, 12;622! -10,557 5 Uses of Funds iUtility Purchases Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits Other Expenses Allocated Charges Debt Service Subtotal 44,505 16,721 6,000 -5,682 - 9,342 13,153 6,560 5,880 -8,045 3,039 1,269 2,848 2,754 786 6,409 1,455 758 1,424 7,154 725 6,183 3,073 1,401 2,092 2,009 633 1,495 948 129 775 396 948 816 ~79,440!25,236 9,23913,139 20,358 3,092 14,903 Equity Transfer Rent Other Transfers Capital Improvement Total Uses 7,762 2,626 2,234 3,405 277 183 1,403 5,289 4,947 645 208 439 486 45 158 23,637 8,666 11,257 13,834 1,991 617 4,580 ~119,191~i~37,450 20,887~ 31,049 28,124 3,7541!!19,641!!iii869 Net To (From) Reserves (10,920)(826) iBeginning Reserves 124,580 22,990 Projected Ending Rsrvs 113,660 22,164 (1,220) (2,051) (2,954)(35) ....153 182 5,619 14,160 10,557 484 7,634 33 4,399 12,109 7,603 449 7,787 215 ~roiected Endinq Reserves Emerg Plant Replace 2,393 858 Distrib Rate Stabilization 8,397 6,567 Supply Rate Distribution 33,978 11,139 Rate Stabilization Calaveras 67,965 =ublic Benefit Program 110 Central Valley O & M 118 - Undergroung Loan 635 - Conservation Loan 34 Shasta Rewind Loan 64 518 1,054 1,631 3,881 8,552 7,013 369 6,136 Restricted Bond Proceeds Water Resources Board Debt Service Total Current Adjusted Budget Midyr Reserve Changes 2,616 1,725 80 20 590 -- 950 778 113,660 22,164 4,399 12,109 7,603 449 106,197 22,796 4,469 12,137 7,603 447 7,463 (632)(70)~ (28)2 RSRs Midyr Adj Budget RSRs Curr Adi Budget Midyr Change in RSRs 42,375 17,706 3,881 8,552 7,013 369 34,912 18,338 3,951 8,580 7,013 367 7,463! (632)(70)(28)-2 7,787 215 7,929 215 (142) ..... 6,136 215 6,136 215 260,965 (17,671) 186,057 168,386 6,454 4’964 45,117 215 26,166 67,965 -110 -118 -635 -34 64 4,441 -590 1,728 168,386 161,793 6,593 86,247 79,512 6,735 Fund Summaries - 2 Exhibit A CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY ELECTRIC FUND (in thousands of dollars) Sources of FundsI"I Net Sales 73,221 73,221 Interest Income 7,240 7,240 Other Income 14,369 14,369 Reapprop/Encumbrances 13,896 Total Sources 94,830 108,726 Uses of Funds Utility Purchases 52,704 52,704 Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits 9,310 9,342 Other Expenses 10,444 13,097 Allocated Charges 6,560 6,560 Debt Service 5,880 5,880 Equity Transfer 7,762 7,762 Rent 3,405 3,405 Other Transfers 4,947 4,947 Capital Improvement 12,169 23,412 Total Uses 113,181 127;109 I Net To (FrOm) Resewes (18,351)(18,383) Beginning Reserves 124,580 124,580 (455) (8,199) 56 225 Emerg Plant Replace Distrib Rate Stabilization Supply Rate Distribution Rate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board 4,850 4,509-9,018 20122-40,244 67,779 2,393 8,653 26,259 67,965 110 118 635 64 67,965 1~8 (256) 7,719 Fund Summaries - 3 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY GAS FUND (in thousands of dollars) Sources of Funds Net Sales Interest Income Bond Proceeds(restricted) Other Income Reapprop/Encumbrances 32,198 32,198 395 395 690 3,973 31,566 Uses of Funds Utility Purchases 16,721 16,721 Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits 3,052 3,039 Other Expenses 1,210 1,455 Allocated Charges 3,073 3,073 Debt Service 948 948 (632) Equity Transfer 2,626 2,626 Rent 277 277 Other Transfers 645 645 Capital Improvement 4,938 8,666 Tota! Uses 33,490 37,450 Net To (From) Reserves;;;(207) ........(194) Beginning Reserves 22,990 22,990 Projected Ending Reserves 22,783 22,796 Emerg Plant Replace Distrib Rate Stabilization Supply Rate Distribution Rate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan :~estricted Bond Proceeds Water Resources Board Debt Service 1,838 858 2,191-4,382 6,599 3,344-6,688 11,739 34 2,616 950 2,616 (32) (600) (632) Fund Summaries - 4 Sources of Funds CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY WASTEWATER COLLECTION FUND (in thousands of dollars) Net Sales 11,299 11,299 Interest Income 836 836 Other Income 656 656 Reapprop/Encumbrances 6,876 Total Sources 12,791 19,667 19;667, Uses of Funds Utility Purchases Treatment Plant Chgs 5,682 5,682 Refuse Collections Svcs Salaries & Benefits 1,269 1,269 Other Expenses 408 688 Allocated Charges 1,401 1,401 Debt Service 129 129 Subtotal 8,889;:9,169 70 Equity Transfer Rent 183 183 Other Transfers 208 208 Capital Improvement 4,661 11,257 Total Uses 13,941 20,817 Beginning Reserves 5,619 5,619 Emerg Plant Replace -518 Distrib Rate Stabilization - iSupply Rate Distribution - Rate Stabilization 3,458-6,916 3,951 Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board - Total n.a 4,469 4,399 (70)i (70) Fund Summaries - 5 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY WATER FUND (in thousands of dollars) Sources of Funds Net Sales 18,631 18,631 Interest Income 678 678 Bond Proceeds (restricted) Other Income 530 530 I Reapprop/Encumbrances 9,187 Total Sources 19,839 29,026 Uses of Funds Utility Purchases 6,000 Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits 2,858 Other Expenses 1,145 Allocated Charges 2,092 Debt Service 775 6,000 2,848 1,424 2,092 775 12,870 13,139 Equity Transfer 2,234 2,234 Rent 1,403 1,403 Other Transfers 439 439 Capital Improvement 4,926 13,834 Total Uses 21,872 31 ~049 iNet To (From) Reserves:(2,033)(2,023) Beginning Reserves 14,160 14,160 (28) (28) 2,305 1,054Emerg Plant Replace Distrib Rate Stabilization Supply Rate Distribution Rate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board Debt Service Total 5,866-11,733 n.a 8,580 _ 1,725 1,725 778 12,137 12,109 (28) (28) Fund Summaries - 6 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY REFUSE FUND (in thousands of dollars) Sources of Funds Net Sales 18,659 Interest Income 921 Other Income 3,040 Reapprop/Encumbrances Total Sources 22,620 Uses of Funds Utility Purchases ’Treatment Plant Chgs Refuse Collections Svcs 8,033 8,045 Salaries & Benefits 2,754 2,754 Other Expenses 6,607 7,154 Allocated Charges 2,009 2,009 Debt Service 396 396 Subtotal ....19,799 20,358 Equity Transfer Rent Other Transfers 18,659 921 3,040 2,550 25,170 25,170 i 5,289 5,289 486 486 Capital Improvement 1,991 Total Uses::25,574 28i124 20,358 = Beginning Reserves 10,557 10,557 Projected Ending Reserves 7,6037,603; Emerg Plant Replace ,Distrib Rate Stabilization Supply Rate Distribution Rate Stabilization Calaveras Public Benefit Program Central Valley 0 & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board Total 1,862-3,725 7,013 ! 590 n.a 7,603 7,603 Fund Summaries - 7 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY STORM DRAINAGE FUND (in thousands of dollars) Interest Income 21 Other Income 991 Reapprop/Encumbrances Total Sources .....3,136 Uses of Funds Utility Purchases Treatment Plant Chgs :{efuse Collections Svcs Salaries & Benefits 786 Other Expenses 595 Allocated Charges 633 Debt Service 948 Subtotal 2,962 Equity Transfer Rent Other Transfers 45 Capital Improvement 166 Total Uses 3,173 581 3,717 3,719 786 725 633 633 948 &092 3,092 2 Net To (From) Reserves (37) .......(37) Emerg Plant Replace Distrib Rate Stabilization Supply Rate Distribution Rate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board Total n~a 367 369 -I = 80 447 449 Fund Summaries - 8 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY WASTEWATER TREATMENT FUND (in thousands of dollars) Interest Income Other Income Reapprop/Encumbrances Total Sources 15,383 15,383 496 496 61 61 3,854 19,794 Uses of Funds Utility Purchases Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits Other Expenses Allocated Charges Debt Service Subtotal Equity Transfer Rent 6,409 6,409 4,887 6,183 1,495 1,495 816 816 Other Transfers 158 158 iCapital Improvement 1,880 4,438 142 19,641 142 Net To (From) Reserves 295:295 Beginning Reserves 7,634 7,634 Projected Ending Reserves 7,929 7~929 !(142~ Emerg Plant Replace Distrib Rate Stabilization Supply Rate Distribution iRate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground Loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board 1,421 1,631 2,094-4,188 6,136 162 20 (142) Total n.a 7,929 7,787 (142) Fund Summaries - 9 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY EXTERNAL SERVICES FUND (in thousands of dollars) Sources of Funds Net Sales Interest Income 5 5 Other Income 1,043 1,043 Reapprop/Encumbrances 3 Total Sources 1,048 1,051 1,051 Uses of Funds Utility Purchases Treatment Plant Chgs Refuse Collections Svcs Salaries & Benefits Other Expenses Allocated Charges Debt Service Subtotal 745 745 62 65 54 54 Equity Transfer Rent Other Transfers 5 5 Capital Improvement Total Uses 866 869 Beginning Reserves 33 Rate Stabilization Calaveras Public Benefit Program Central Valley O & M Underground loan Conservation loan Shasta Rewind Loan Restricted Bond Proceeds Water Resources Board 215 -!-’ " I Fund Summaries-10 Exhibit A CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET I Key I°bi I 2002 3 II coae; ICode I iid~/earAdi I Description GENERALFUND 02000000 1180 405,000 02000000 1183 132,000 02000000 1181 (1,493,000) 02000000 1185 (400,000) Source Changes (1,248,000) increase in Property Tax Revenue Increase in Documentary Transfer Tax Revenue ncrease in Motor Vehicle In Ueu Tax Revenue Decrease in Sales Tax Revenue Decrease in Transient Occupancy Tax Revenue 02000000 3342 67,600 Increase in the City’s Assessment for the new Downtown Parking Structures 02000000 4031 (144,508) Decrease in debt service funding 02000000 4041 (1,084,408) Decrease transfer to capital fund Use Changes (1,161,316) Net Changes To (From) Reserves (86,684) 02432100 3908 820 Increase in vehicle equipment maintenance service 02432100 3977 3,300 Increase in vehicle equipment replacement allocation 02413180 3003 (43,354) Decrease in Overtime Salaries 02413180 3004 (24,276) Decrease in Temporary Salaries Use Changes (63,509) Net Changes To (From) Reserves 63,5019 ..... 02811115 1399 20,000 Increase in grant revenue associated with Arts and Culture 02811110 1527 02811110 1528 02811115 1801 Source ChangeS ! ! !: 10,278 Increase in grant revenue associated with Arts and Culture 4,330 Increase in grant revenue associated with Arts and Culture 18 000 ncrease in grant revenue associated with Arts and Culture 52i608 02811114 3003 4,108 02811115 3003 18,000 02810010 3107 3,950 02811112 3108 500 02811114 3120 6,000 02813000 3199 42,500 02813180 3977 (10,000) 02812170 3199 79,768 02811112 3305 4,000 Increase in temporary salary expense (offset by grant revenue) Increase in temporary salary expense (offset by grant revenue) Increase for lease and installation of modular building for Finds of the Lib. (CMR406:02) Increase in Cultural Presentations (offset by grant revenue) Increase in Advertising and Publishing (offset by grant revenue) Increase in Cntrct. Srvcs. for additional expenses associated with the new Golf Pro agreement Decrease in vehicle equipment replacement allocation Increase for lease and installation of modular building for Frnds of the Lib. (CMR406:02 Increase in Transportation (offset by grant revenue) 02811152 3599 (21 292) Decrease in Other Facility and Equipment Purchases Use Changes 127,534’ Net Changes To IFrom) Reserves (74~926) ................... ..... 0275113o 1537 02750010 1801 02752100 1801 Source Changes ~ ~, 50,000 tncrease in Stanford Fire and Communications Revenue 9,009 Increase in State of California revenue 2,500 Increase in Donations 954 Increase in Donations 62,463 ~;f.~ ~,~i ’/~ ~!!:i~i ~!i ~i’. 027521003200 02752210 3200 02751130 3505 Ise Changes Net Changes To (From) Reserves 954 Increase in Supplies and Materials (offset by revenue) 2,500 Increase in Supplies and Materials (offset by revenue) 9,009 Increase in Tools and Equipment (offset by revenue) 12,463 50,000 .... ....... CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Key Code Source Changes lObjCode I 2002-03Mid,/ear Adi !Description 1599 17,500 Increase in Other Revenue From Other Agencies 17,500 Use Changes Net Changes To (From) Reserves 3199 17.500 !ncreasein Contract Services 17,500 0 Source Changes 1537 115.000 Increasein State of Californiarevenue 115,000 Jse Changes 115,000 Net Changes To (From) Reserves 0 Source Changes (50,000) Decrease in VTA contract revenues due inadvedent inclusion in 2002-03 budget Net Changes To (From) Reserves (50~000) ......; ...... Total Source Changes (1,050~429) Total Use Changes (952~328) ..... Total Net Changes To(From) Reserves (98,101) Balancing Entries:02000000 3822 (1,203,801) Budget Stabilization Reserve Funding 02000000 3849 1,105,700 Infrastructure Reserve Funding of IMP CIP projects Total Reserve Funding for Midyear (98~101) rehicle Replacement 81533750 1977 (10,000) Decrease in vehicle equipment replacement allocation ~ource Changes {10,000): Technology Fund 82000000 4041 Vehicle Replacement 81533750 3550 Use Changes Balancing Entries: 82000000 Total ISF Reserve Funding for Midyear 38O9 500,000 Operating Transfer to CIP 10216 (Enterprise Resource Planning) (10,000) Decrease in vehicle equipment replacement allocation 490,000 (500,000) Technology Fund Reserve (500,000) 54000000 2011 54000000 2065 Subtotal (144,508) Decrease Operating Transfer From General Fund 144,508 Increase Transfer from Agency 0 32000000 1502 250,000 Increase in Community Development Block Grant 250,000Source Changes 33615280 3107 50,000 Increase in Program and Project Consultants for Below Market Rate Ownership Program 32000000 3879 250,000 Increase in Job Ledger project expenditure for CDBG Opportunity Center Jse Changes 300,000 3alancing Entries:33000000 3850 (50,000) Decrease in Residential In-Lieu Fund Reserve Net Special Revenue Adjustments (50,000) ........ CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Key I°bi I 200243 I Code ~ Description 71514281 1329 39,350 71000000 2011 ,940,000) 71000000 2011 (212,500) 71000000 2011 21,292 71000000 2011 46.800 71000000 2060 500 000 Net CIP Revenue Adjustments (554.058) CIP 10304 (Roth Building Wings demolition) - Increase revenue from Summerhill Homes Decrease ~ransfer from General Fund Decrease transfer from General Fund Increase transfer from General Fund Increase transfer from General Fund Increas=~ transfer from Technolog? Fund 71000000 3879 30,350 CIP 10304 (Roth Building Wings demolition} - Additional expense offset by revenue 71000000 3879 (940,000) CIP 10102 [Civic Center Infrastructure Improvements) - Decrease in pro!ect 71000000 3879 (212,500) CIP 10006 [Roofing Replacement) - Decrease in project 71000000 3879 21,292 CIP 19910 (Community Theatre Renovations) - Addl. exp for lights, offset w~ operating funds 71000000 3879 46,800 ClP 10206 (Traffic Signal at San Antonio) - Additional expense 71000000 3879 500,000 CtP 10216 (Enterprise Resource Planning) - Additional expense Net ClP Expenditure Adjustments (554,058) Exhibit A CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET CodeKey II ObJc°de !1 Midyear2002"03Adj IDescripti~n 13000000 1722 (480,000) Decrease in wholesale revenue that did not materialize. 23000000 1719 (41,000) Decrease in utility billing discount revenue 23260280 1735 66,000 Increase in fiber optical revenue -~ource Changes (455,000) 13231160 3611 (6,949,000) 13231160 3611 (1,250,000) 23220230 3908 (820) 23220230 3977 (3,300) 23260280 3100 60,000 23220760 3879 225,000 Decrease to transf, budget for contract obligation settlements with NCPA to FY 01-02 Decrease in transmission cost Decrease estimated vehicle equipment maintenance Decrease estimated vehicle replacement maintenance Increase contract expenses assoc, with the FTTH (offset by revenues) CIP 8930 (Traffic Signal Upgrade) - Increase project expense Use Changes ......(7,918,120) Net Changes To {From) Reserves 7,463,120 Fund Balancing Entries 13000000 3817 7,719,000 23000000 3804 (255,880) Total Electric Fund ~;7,463,120 Electric Supply Rate Stabilization Reserve Electric Distribution Rate Stabilization Reserve 14000000 1962 (600,000) 24000000 1719 (32,000) iource Changes (632,000) Net Changes To (From) Reserves {632,000) Decrease gas sales to COBUG Decrease utility billing discounts due to Rate Assistance Program Fund Balancing Entries ............. 14000000 3817 (600,000) 24000000 3804 (32,000) Total Gas Fund ~ .....(632,000) Gas Supply Rate Stabilization Reserve Gas Distribution Rate Stabilization Reserve 22000000 1719 (28,000) Decrease utility billing discounts due to Rate Assistance Program Source Changes (28,000) 4et Changes To (From) Reserves (28,ooo) Fund Balancing Entries 22000000 3804 Total Water Fund (28,000) Water Distribution Rate Stabilization Reserve (28,000) 28000000 1399 Source Changes : Net Changes To (From) Reserves Fund Balancing Entries ........... 38000000 3804 Total Storm Drainage Fund 1,750 Increase revenue from temporary construction dewatedng fees 1,750 1,750 Storm Drain Rate Stabilization Reserve 1,750 1,750 CITY OF PALO ALTO 2002-03 MIDYEAR BUDGET SUMMAR~ DETAIL CHANGES TO THE ADJUSTED BUDGE.l CodeKey I CodeObj IMidyear2002"03Adj IDescription 26561790 3879 Use Changes Net Changes To (From) Reserves =und Balancing Entries 26000000 3805 Total WWT Fund 141,706 CIP 9707 (Wastewater Solids Disposal Project) - Increase expense 141,706 (141,706) (141,706) (141,706) Wastewater Treatment Rate Stabilization Reserve 27250290 3500 70,000 Increase Facility and Equipment Purchases Use Changes 70,000 Net Changes To (From) Reserves (70,000) Fund Balancing Entries 27000000 3804 (70,000) Total WWC Fund (70,000) Wastewater Collection Rate Stabilization Reserve °Exhibit B MSC Feasibility Study (19906) Continuing --Infrastructure PROJECT DESCRIPTION This project, formally titled the MSC Permanent Seismic Retrofit Study, funds a feasibility study of the Municipal Ser- vice Center (MSC) site. The study, currently in progress, includes analyzing many issues and needs that exist at the MSC including seismic requirements, ADA compliance, future pro~ammatic and space needs and FEMA floodplain requirements. Upon completion of the study, the findings and associated recommendations will be presented to Council for consideration and direction. PROd ECT JUSTIFICATION The MSC Buildings A, B and C were constructed in 1965 and were designed to meet the standards of the 1961 Uniform Building Code. In 1997, it was determined that the buildings were seismically deficient. Construction of seismic brac- ing was determined to be the most timely and cost effective m, ethod to address the deficiency. The bracing was com- pleted in 1998. Along with structural issues, the buildings require ADA compliant renovations. Lighting, mechanical, and electrical equipment at the MSC is outdated and inefficient. Due to progressive changes in activities performed by staff and changes in the functionality at the facility, work and shop areas are not adequately equipped nor efficient in their design. The MSC while not required to meet essential building standards, houses equipment and staff that would be crucial dur- ing and after a major emergency or disaster event. It is important that this facility and it’s condition be maintained and in good functioning order to provide the support and response that would be necessary during such a time. FUTURE FINANCIAL REQUIREMENTS FISCAL YEAR AMOUNT PY Budget $200,000 2002-03 2003-04 2004-05 2005 -06 2006-07 Sources of Funding: General Fund COMPONENTS CiP MSC Feasibility Study (19906) continued IMPACT AND SUPPORT ANALYSIS Environmental: Design Elements: Operating: Telecommunications: An environmental analysis may be required based on the results of the study. May be subject to review by the ARB. None None COMPREHENSIVE PLAN This project furthers Policy C-24 and Program C-19 of the Comprehensive Plan. Exh[M Community Theatre Renovations (19910) Continuing --Infrastructure: Buildings and Facilities PROJECT DESCRIPTION This project will replace an existing, but malfunctioning light board at the Community Theatre. Funding for this project will come from the $45,708 balance in CIP 19910 Community Theatre Renovations to help with the cost of replace- ment for the failing light board. The new light board will cost approximately $67,000. The Arts Division will make up the difference with operating dollars identified in their budget for equipment replacement. The original scope of ser- vices for CIP project 19910 was to refurbish the auditorium seats at the Lucie Stem Community Theatre and to add air conditioning to the theatre. Both of those projects are complete leaving a $45,708 balance in this CIP. PROJECT JUSTIFICATION The light board at the Lucie Stem Community Theatre has failed and cannot be repaired. As an interim measure we are renting a temporary light board in order to continue providing scheduled performances at the theatre. The permanent light board, an analog system, was installed in 1980. Since then light board technology has advanced and all new sys- tems are digital. As a result replacement parts to repair the existing permanent light board are not available. Amending the scope of services of CIP 19910 to include the purchase and installation of a new permanent light board is in keeping with the intent of the original CIP. This is to provide a satisfactory and comfortable theatre experience for the users of the Community Theatre. FUTURE FINANCIAL REQUIREMENTS COMPONENTSFISCAL YEAR AMOUNT PY Budget 2002-03 $67,000 2003-04 2004-05 2005-06 2006-07 Sources of Funding: Genera! Fund and Infrastructure Reserve (Consists of $21,292 from Arts and Culture Functional Area budget and a $45,708 balance from this CIP 19910.) Community Theatre Renovations (199!0) continued IMPACT AND SUPPORT ANALYSIS Environmental:None Design Elements:None Operating:None Telecommunications:None COMPREHENSIVE PLAN This project furthers Policy C-24 and Program C-9 of the Comprehensive Plan. Exhibit C n 0 0 Exhibit D 2002:03 TABLE OF ORGANIZATION : 2002-03 2000-01 2001-02 Adopted-in-2001-02 2002-03 2002-03 2002-03 Actual Adjusted Concept BAO Adopted BAO Adjusted Budget Budget Budget Changes Changes Changes Budget Public Works Department Accounting Specialist 1.00 1.00 1.00 Administrator, Public Works 1.00 1.00 1.00 Administrative Assistant 1.00 1.00 1.00 Assistant Engineer 1.50 1.50 1.50 Assistant Director Public Works 0.75 0.75 0.75 Building Serviceperson 5.00 5.00 5.00 Building Serviceperson-Lead 2.00 2.00 2.00 Cement Finisher 2.00 2.00 2.00 Cement Finisher- Lead 1.00 1.00 1.00 Coordinator, Public Works Projects 3.00 1.00 1.00 Deputy Director, Public Works Operations 0.40 0.40 0.40 Director, Public Works/City Engineer 1.00 1.00 1.00 Electrician 1.00 1.00 1.00 Engineer 6.90 2.90 2.90 Engineering Technician III (1)4.53 4.60 5.60 Equipment Operator 2.55 2.55 2.55 Facilities Carpenter 1.00 1.00 1.00 Facilities Maintenance-Lead 2.00 2.00 2.00 Facilities Mechanic 5.00 6.00 6.00 Facilities Painter "2.00 2.00 2.00 Heavy Equipment Operator-Lead 1.05 1.05 1.05 Heavy Equipment Operator 1.90 1.90 1.90 Inspector, Field Services 1.00 1.00 1.00 Manager, Facilities Maintenance and Project 1.00 1.00 1.00 Managing Arborist 1.00 1.00 1.00 Manager, Maintenance Operations 0.50 0.50 0.50 Office Assistant 1.00 0.00 0.00 Office Specialist ( 1 )2.50 3.50 3.50 Program Assistant 1.00 1.00 1.00 Project Engineer 0.00 5.00 4.00 Project Manager 1.00 2.00 2.00 Senior Project Manager (1)1.00 1.00 1.00 Senior Engineer 3.55 3.55 3.55 Staff Secretary 2.00 2.00 2.00 Superintendent, Public Works Operations 0.80 0.80 0.80 Supervisor, Building Services 1.00 1.00 1.00 Supervisor, Facilities Management 0.00 1.00 1.00 Supervisor, Facilities Project 1.00 1.00 1.00 Supervisor, Inspection/Surveying, P.W.0.90 0.90 0.90 Supervisor, Public Works 1.00 1.00 1.00 Surveying Assistant 0.80 0.80 0.80 Surveyor, Public Works 0.80 0.80 0.80 Traffic Control Maintenance I 1.70 1.70 1.70 Traffic Control Maintenance II 2.00 2.00 3.00 Traffic Control Maintainer- Lead 1.00 1.00 1.00 Tree Maintenance Person 1.00 1.00 2.00 Tree Trimmer/Line Clearer 9.00 9.00 9.00 Tree Trimmer!Line Clearer-Lead 1.00 1.00 1.00 Truck Driver 0.85 0.85 0.85 2.00 - 1.00 1.00 1.00 1.00 1.50 0.75 5.00 2.00 2.00 1.00 -l.00 1.00 1.00 0.40 1.00 1.00 2.90 5.60 2.55 1.00 2.00 6.00 2.00 1.05 1.90 1.00 t .00 1.00 0.50 0.00 3~50 1.00 5.00 2.00 1.00 -1.00 1.00 3.55 2.00 0.80 1.00 1.00 1.00 0.90 1.00 0.80 0.80 1.70 1.00 3.00 1.00 1.00 9.00 1.00 0.85 [TOTAL PUBLIC WORKS 85.98 88,05 90.05 0.00 5.00 -3.001 90.05I (I) Remov’ed of position as placeholder pending November 2002 voter approval of community facility bond measure. I 2002-03 2000-01 2001-02 Adopted-in-2001-02 2002-03 2002-03 2002-03 Actual Adjusted Concept BAO Adopted BAO Adjusted Budget Budget Budget Changes Changes Changes Budget Planning Administrator, Zoning Administrator. Planning & Community Environment Administrative Assistant Assistant Building Official Assistant Planning Official Building Inspector Building Inspector Specialist Building/Planning Technician Chief Building Official Chief Planning Official Chief Transportation Officer City Traffic Engineer Code Enforcement Officer Coordinator, Transportation System Management Director, Planning and Community Environment Engineer Engineering Tech II (1) Executive Secretary Manager, Planning Managing Arborist Office Specialist Planner (1) Plans Checking Engineer Senior Planner Staff Secretary Supervisor, Building Inspection Transportation Projects Manager 1.00 1.00 1.00 - 1.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 - 1.00 0.00 3.00 4.00 4.00 4.00 3.00 3.00 3.00 3.00 4.00 4.00 4.00 4.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 3.00 1.00 t .00 1.00 1.00 6.00 6.00 6.00 4.00 7.50 8.00 6.50 7.00 3.00 3.00 3.00 3.00 8.00 9.00 9.00 8.00 2.00 2.00 2.00 5.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 1.00 59.001 2.00 -2.00 1.50 -1.00 -1.00 3.00 1.00 [TOTAL PLANNING AND COMMUNITY ENVIRONMENT 54.50 58.00 56.50 1.50 1.00 0.00 (1) Removal from 2002-03 Adopted Budget of 1.0 Planner and Addition of 1.0 Engineering Tech II 2002-03 TABLE OF ORGANIZATION 2000-01 2001-02 2002-03 Adopted-2002-03 2002-03 Actual Adjusted in-Concept 2001-02 BA0 Adopted 2002-03 BA0 Adjusted Budget Budget Budget Changes Changes Changes Budget Community Services Department Administrative Assistant Administrator, Human Services Administrator Special Events Building Serviceperson Building Serviceperson-Lead Coordinator, Child Care Coordinator, Libra-D’ Circulation Coordinator, Library Programs Coordinator, Recreation Programs Deputy Director, Community Services Director, Arts and Culture Director, Community Services Director, Human Services Director. Libraries Director, Parks and Golf Course Director, Recreation and Open Space Executive Assistant Facilities Assistant Golf Course Equipment Mechanic Golf Course Maintenance Person Inspector, Field Services Librarian LibraD’ Associate LibraD’ Assistant Library Specialist Management Assistant Manager, Arts Manager, Main LibraD’ Services Manager, Community Services Facilities Office Specialist (1) Park Maintenance Person Park Ranger Parks Crew-Lead Parks and Open Space Assistant Park Planner, Architect Producer ArtslScience Programs Pro~am Assistant (1) Project Manager Sprinkler System Repairer Senior Librarian Senior Ranger Staff Secretary Superintendent, Golf Course Superintendent, Parks Superintendent, Recreation Superintendent, Open Space and Sciences Supe~’isor, Golf Course Supervisor, Junior Museum Supervisor, Open Space Supervisor, Recreation Program Supervisor, Librarian ¯ Supervisor, Parks Theater Specialist Volunteer Coordinator 1.00 1.00 1.00 4.00 2.00 1.00 1.00 2.00 5.00 1.00 1.00 1.00 0.00 1.00 1.00 1.00 1.00 0.50 2.00 7.00 2.00 8.75 3.00 3.00 6.50 1.00 2.00 t .00 1.00 8.75 12.50 5.00 2.00 0.75 1.00 10.50 7.00 1.00 5.00 11.00 2.00 4.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 5.00 4.00 2.00 1.00 0.75 1.00 1.00 1.00 0.00 0.00 0.00 1.00 1.00 1.00 4.00 4.00 4.00 2.00 2.00 2.00 t .00 1.00 1.00 1.00 1.00 1.00 2.00 2.00 2.00 4.00 4.00 4.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1,00 1.00 1.00 1.00 1.00 t .00 0.50 0.50 0.50 2.00 2.00 2.00 7.00 7.00 7.00 2.00 2.00 2.00 8.75 8.75 8.75 3.00 3.00 3.00 4.00 5.00 4.00 6.50 6.50 6.50 1.00 1.00 1.00 2.00 2.00 2.00 1.00 1.00 1.00 1.00 1.00 1.00 7.75 7.75 0.25 8.00 12.50 12.50 12.50 5.00 5.00 5.00 2.00 2.00 2.00 0.75 0.75 0.75 1.00 1.00 1.00 10.50 10.50 10.50 7.00 7.00 -0.25 6.75 1.00 1.00 1.00 5.00 5.00 5.00 11.00 11.00 11.00 2.00 1.00 - 1.00 1.00 5.00 5.00 5.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 1.00 1.00 1.00 6.00 6.00 6.00 4.00 4.00 4.00 2.00 2.00 2.00 1.00 1.00 1.00 0.75 0.75 0.75 tTOTAL COMMUNITY SERVICES 152.00 153.00 154.00 0.00 0.00 0.00 153.00 (1) Reclassification of 0.75 Office Specialist to 0.75 Program Assistant. Attachment 2 FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND ADMINISTRATIVE SERVICES DEPARTMENT As of November 30, 2002 10106 Enterprise Backup Minor Solution $70,000 $70,000 50 570,000 City Network Hardware Redundancy 10107 Minor $57,500 Pre-design Dec 03 $0 Complete 10108 Systems Minor $320,000 5149,294 539,949 $109,346 Construction Dec 03 Management 10109 Acquisition Crime Minor $75,000 $45,173 S45,150 $23 Complete Analysis Software 10110 Map Printing Plotter Minor $50.000 $2,414 $2,200 S214 Complete 10111 Vehicle Routing Minor 550,000 $26,050 $26,050 $0 Complete Application 10112 IT Disaster Minor 5270.000 $270,000 $0 $270.000 ~ Desi~n~Jun 04 Recover’ Plan Minor $50,000 $36,014 52.346 $33,668 Construction Jun 0310225Cable Television Broadcasting Equipment Evaluating vendor solutions and awaiting the completion of the Computer Room remodelling. Total budget of $57,500 wil! be transferred to CIP #10216 thru a FY 02-03 BAO that will be presented to Counci! in Feb 03. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND ADMINISTRATIVE SERVICES DEPARTMENT As of November 30, 2002 19711 Permit Information Multi-Year Tracking System Citywide Network Multi-Year Improvements $410,000 S01 S187,315i Construction $O $0 Complete Jun 05 Adjusted budget of $26,901 will be transferred to CIP #10216 thru a FY 02-03 BAO that will be presented to Council in Feb 03. 10021 / New Phone System Multi-Year S730,000 $728,968 S2,285 S726,683 Pre-desQma Jun 04 82201 10027 Renovations and Multi-Year $800,000 $754,004 $7’44,629 $9 376 Construction Feb 03 Upgrades to Data Mana~_ement 10212 Desktop Multi-Year S55,000 $55,000 $0 S55,000 Ongoing Jun 03 Automation 10213 Institutional Multi-Year $!,000,000 $1.000,000 $0 S1,000,000 Construction Network (I-Net) 10214 eGov - Web Multi-Year Infrastructure and 10215 Application Citywide GIS Data, Multi-Year Infrastructure and Applications 10216 Enterprise Resource Multi-Year Planning 82200 ,kcquisition of New Multi-Year Computers S400,000 $354,166 SO S768,530i $625,248!$54,662i $3.059,726 $2,966,908 $2.941,842 $150,000 5150,000 $95,363 . 5354,166 Design 5570,586 Ongoing S25 066 Construction S54 637 Pre-design Apr 05 Jun 06 Jun 04 Jun 04 Feb 03 A number of the City’s remote facilities have been connected via fiber connect- ions and will continue to connect remote facilities via fiber. The City connection to the I-Net will begin once the I-Net is completed by AT&T in 2003. Currently laying the foundation for eGov with ERP and some other relatec projects. There wil! be a mid-year adjustment to the budget involving transfers from other related CIPs which will be presented to Council in Feb 03. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND COMMUNITY SERVICES DEPARTMENT As of November 30, 2002 19901 Robles Park Minor Irrigation Improvements 19905 Cubberley Athletic Minor Field Irrigation 10113 iEl CaminoMedian!Minor iLandscape 10224 Children’s Theatre Minor Ligd-lt & Sound Systems Upgrade 10301 Wildhorse Valley Minor Vehicle Bridge Replacement 10305 Lucie Stem Minor Community Theatre Stage Floor Replacement [ $10,000 ; S30,000 $1.527.000 S210,000 S160,000 S45.000 $649~ S16.267~ 5tA49,000 $210,000 S160,000~ $45,000 S649 ! Sll,993 ~ $1,099 S1,500 so so $o $4,275 S1 ’447901 i $208,500! !$!60,0001 $45.000 Complete Complete Design Design Desi~ma Design Dec 03 Jun 03 Aug 03 Jul 03 Phase 1 median landscaping. 19414 19418 19801 19803 19812 19910 19911 Park Imgauon and iMulu-Year Backflow Improvements Library Multi-Year Automation Service S1,708,000 S1,286,751 School Site Irrigation Mitchell Park Facilities Arastradero Preserve Gateway Multi-Year S691.000, Multi-Year $2,382,644 Multi-Year S339,800 Community Multi-Year S891,000 Theater Renovation Cubberley Theater Multi-Year Improvement S t 20,000 Sl12,43ti S712,5t9! S203,491~ i S1,350,141 : i $261,897~ $48,642~ S3,280 ~ S102,871 i $3,153 $44,704 S487,974 St9,8tl S2,934! $3,279’ S9,560 $709,366 S158,787i S862,1671 $242,086i S45,708 S1 Construction Construction Design Design Construction Complete ’ Dec 03 Dec 04 i Sep 03 Dec 03 Dec 03 Jun 03 Jordan Elementary School Phase 2 Final construction drawing are being prepared. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND COMMUNITY SERVICES DEPARTMENT As of November 30, 2002 i 0001 Park Trails Multi-Year 10002 Open Space Lakes Multi-Year & Ponds Maintenance 10003 and Site Improvements $881,000 Bayland Parking Multi -Year $648,433 S110,000 $21,739 $328,191 i S320,241 Constructlon ,aa-astradero Creek Trail and Arastradero Preserve de Anza Bridge were completed Oct 02; Arastradero Trails will be completed Jul 03; Bay Trail will be completed Nov 02 and Foothills Park amenities will be completed May 03. S897,000 10009 Medians, Islands Multi-Year $468,000 and Planters Renovation Projects 10010 Park Facilities Muhi-Year Improvements Community Services Facilities Lighting Enhancements Muhi-Year 10218 [Palo Alto SOFA Multi-Year Park S1,755,450 $334,000 $500,255~ S439,466 $646,989 S319,217 S0i $21,739 $32,198i $468,058 $5.732 $433,734i S132.468} $514,521 $217 $319,000 Construction Construction Design Design Desi~ Dec 02 City of Palo Alto Site and Design Review ongoing. Byxbee Park Lot and Sa ling Station Lot will be completed May 03; Harbor Road widening and Nature Center Parking Lot will be completed Jul 04. Jul 03 [New play~ounds at three parks and design of Baylands Athletic Center electricals. Nov 03 Main Library and Art Center construction expected to take place S236,000 S221,616 S550 $221,066 Pre-design Apr05 Designer proposals are being accepted. Summer 03. Lucie Stem or hold until new parking lot confizuration is determined Dec 04 Re-landscaping all medians and island on San Antonio Road. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND FIRE DEPARTMENT As of November 30, 2002 9821 Emergency Minor Notification System S172,000 $73,194 $0 S73,194 Construction Jun 03 10211 New Air Minor Compressor for SCBA 10302 Apparatus Floor Lockers for Fire Stations #1,3,4,5,7 &s 10303 Additional Fire Frequency Minor Minor $40,000 $40,000 S95,000 S40,000 $40,000 $95,000 $40,000 SO S0 SO $40,000 S95,000 Complete Design Design Jul 03 Jul 03 19312 Fire Multi-Year Communications Computer Systems Fire Station Multi-Year Driveway Modification and, Installation of Oil/Water Separator System S485,050 S171,000 St96,383 $3,975 S185,223 $3,857 S11,161 S119 Construction Construction Jun 03 Jun 04 Project deferred until FY 03-04 due to the bottom line expenditure reduction plan. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND NAME: GENERAL FUND/STREET IMPROVEMENT FUND (SIF) PLANNING DEPARTMENT As of November 30, 2002 Bikeway System Minor Improvement (SIF) 19524 10116 Sheridan Sidewalks Minor 10205 E1 Camino Real/ Minor Ventura Avenue Traffic Signal ]Traffic Signal San Minor Antonio/Hwy 101 10206 Master Schematic Minor Design 10223 S51,200 $31.000 s~l,ooo $234.000 $288,000 $600 $31,000 SO $0 S234,000 SO S150,333 $49,000 $150,333 $31,000 S61,000 Design S234.000 Desig-n Pre-design Design Pre-design Mar 04 TBD Dec 05 Dec 03 Mar 03 Reappropriation in the mount of $49,000 was approved by Counci on January 13, 2003. Projects wil!~ be implemented in conjunction with Bicycle Plan recommendations. Project is being implemented by Public Works. Calwans is the lead agency for this project. Caltrans indicated that they will fund the project in FY 04-05. Staffhas requested that Caltrans move the project forward and fund it in FY 03-04. City is awaiting Caltran’s response. Cattrans is the lead agency for this project. City’s share for thi! project is estimated to be $280,800. Staff will be requesting an additional $46,80( as mid-year budget adjustment. Following Council approval of the additional funds, City will execute cooperative agreement with Caltrans in 4th Quarter for FY 02-03 who will implement t i-t is project. Memorandum of Understandin~. with Caltrans is being prepared. Schematic Design will be presented to the Planning & Transportation Commission an~ City Council in the first quarter 2003. 19310 19523 Embarcadero Multi-Year Pedestrian Bike Bridge Path Extension (SIF) E1 Camino Real Multi-Year Intersection Improvements (SIF) St,526.770 $1 243,606 $212.750 [S17,745 $104,385 $1,139,221 S17.504 $241 Design Pre-design Dec 03 Jun 03 Staff will bid the project in earl 2003 and will commence construction in Spring 03. Project is being implemented b CSD. Construction bids recelv Oct 02. Project will be comple by Spring 03. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND NAME: GENERAL FUND/STREET IMPROVEMENT FUND (SIF) PLANNING DEPARTMENT As of November 30, 2002 19813 19814 10026 10117 SchooICommute. Multi-Year $300,000 Safety lmprovemems (SIF) Residential .amerial Multi-Year Traffic Calming (SIF) Local and Multi-Year Neighborhood Collector Street Traffic Calming Program El Camino Real/Churchill Avenue Multi-Year S125,000 $320,000 $ 100,000 S141,364 $!6.029 $287,451i S 100,000 $74,415 $16,029 $172,491i $66,949! $114,960i Design SlO0.O00 Complete Ongoing Design ! Jun 04 TBD TBD The remaining projects include intersection modifications at Stanford Avenue and El Camino Real which must be coordinated with Caltrans. Project pending response from Caltrans. Since the formal start of the -- Neighborhood Traffic Calming Program in Apr 0t, six projects have been started. The Louis Road project was implemented for a trial period but was remove~ [and a design for a second trial is being pursued. The Churchill Avenue project ended with no action. The IndiardMoreno trial will be implemented Jan 03. The Ross Road education/enforcement trial has concluded and is awaiting evaluation. The Moreno Avenue proposed trial project is awaiting the outcome of the resident survey. A trial plan for the Waverley Street project is still under development. A seventh project will be started in January’ or February. Several other qualified projects are on the waiting list to start. Project has been postponed indefinitely’ due to the bottom lit expenditure reduction plan. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND POLICE DEPARTMENT As of November 30, 2002 10217 Public Safer?,Minor $75,000 $75,000 $0 $75,000 Design Mar 03 Mobile Data Computer 9109 Police Computer Multi-Year $1 133,762 $34,004 $0 $34.004 Complete Systems ’, 19913 Police Records Multi-Year $526,435 $375,518 $334,944 $40,574 Construction Mar 03 Management FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT As of November 30, 2002 19820 Public Safety Minor $765,028 $343,158 5341,910 $1,249 Design Jun 03 Continuing site, seismic and environmental assessments forBuildingpreferred option. 10004 Downtown Library Minor SI03,000 $24.680 $0 $24,680 Complete Roof Replacement and Exterior ~005 MSC Building A,Minor $100,000 $89.803 S74.935 $14.868 Complete Emergency Generator Replacement 10007 ,-M-t Center Plumbing Minor $32,000 $31,966 $5,150 $26,8t5 Complete Replacements 10008 Mezzanine Heating -Minor S 100,000 S84,494 SO $84,494 Complete Ventilation-Air Condition (HVAC) ~017 Minor S100,000 S93,446 $0 S93,446 Complete System Improvements Adobe Creek Pedestrian/Bike Undercrossing and Highway 101 Pedestrian/Bike Overpass Lighting Improvements Sand Hilt Road Bridge 10018 Minor S83,000 S75,981 $2,000 $73,981 Planning Feb 03 Caltran reviewing plans and once approved ",,,’ill go out to bid. 10101 Children Theater Minor S45,000 $44,931 $21,426 S23,505 Complete Exterior 10119 Baylands Bike Trail Minor $t00,000 S100,000 $0 $100,000 Construction Jan 03 Bike trail currently under Replacement construction. 10204 Libra,’ Master Plan Minor $977.550 $157,162 $152,909 $4.253 Pre-design Project failed bond measure, staff is proposing individualProject Definition projects durin,, 03-05 bud,,etStudy~~ process. 10208 Miranda Avenue Minor $100,000 $100,000 $0 $100,000 Complete ;There will be a mid-year ¯adjustment to the budget toStreet Improvements move it to CIP #18670. 102"19 Fire Station Seismic Minor $125,000 $105.818 $46,619 S59,!99 Pre-design Mar03 Seismic study being finalized. Evaluation 10220 Golf Course Minor $60,000 $58,559 $53.350 $5,209 Construction Jun 03 Maintenance Shop Improvements FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT As of November 30, 2002 Minor0226 Mitchell Park Library Expansion 0304 Roth Building Minor Win,,s Demolition 10306 Animal Service Minor Protective Holding Kennels S85,000 ~ $930,0001 S160,000i $83,2501 $930.000: S160,000 S76,789i $6,461 $5,225i $924,775i S160,000 Planning Pre-design Jan 03 Dec 04 The City is currently negotiatin8 an agreement with Summerhill Homes whereby Surnmerhill will take the lead in the design and potentially demolition of the Roth Building wings. 18508 / Public Buildings 19906 Structural: Current Projects are College Terrace and Children’s Librar3’, MSC Study Multi-Year 56.958.297 Harbor Improvements Amstradero Lake Rinconada Pool Site Improvements Revenue Collection Civic Center Plaza Waterproofing S563.992 $23,592 $540,400 Ongoing Staff has requested that CIP #18508 be closed and has requested a new project be opened for College Terrace in 03-05 budget process to begin design phase. Children’s Librar to begin design phase pending approval of FY 02-03 mid-year BAO. CIP #19906 is in pre- design phase with an estimated completion date Dec 03. Feasibility study is in progress and once the study is complete, findings and recommendations will be presented to Council. 18918 Multi-Year $2,t39,000 $115.093 $43,758 571,335 Complete Mandatory monitoring required. 19102 Multi-YeA S280,000 S35,313 S514 S34,799 Complete 19406 Multi-Year $1,755,000 S44,599 $35,004 $9,595 Complete -~-505 Multi-Year $85.000 $57,470 $56,727 $743 Jan 03 19512 Multi-Year S250.000 $178,084 $24.667 $153,417 Jun 03 $174,299 S0 $174.299Multi-Year S1,128.000 Construction Design Complete19514Facilities Roof Replacements: Mitchell Park Comm. Cm & Librars,, Station 5 Staff will hire additional consultant to conduct further investigation and analysis in order to make recommendations for future repair and seek alternatives to a costly replacement. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT As of November 30, 2002 19608 19624 19704 Garage and Non- Parking Downtown Urban Design Improvements Golf Course Improvements Traffic Control Safety Devices Multi-Year $1.220,349 Multi-Year 56.284.228 Multi-Year 5320,000 19707 Fire Station Multi-Year Emergency Generator Replacement 19815 Arastradero Rd. Bike Multi-Year Lane Improvements (SIF) i 19907 19922 iSanMateo Drive iMulti-Year iBddges , 3rd Fir - Civic Center Multi-Year i S415,000 ! $455,000 5118,000 S481,934 ! $105.149 $105,257 $284,161 $369,148 S353.349 S104,567 $65,413} 530,654 50 S356.480 5351,740 50 $1,000 S74.495 5105.257 i 5284,161 i s12,668 S 1.609 S104.567 ¯Ongoing Complete Design Complete Construction Design S64,413 Complete Dec 04 Apt 03 i JunO3 i TBD Staff has requested funding for Phase 2 design in FY 03-04. Reappropriation of S284,161 approved by’ Council on Januar 13, 2003 Reappropriation of S 1 04,567 approved by Council on Januar 13.2003. F’Y 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT As of November 30, 2002 Jun 04 10006 Roofing Multi-Year $392,500 $296,067 $0 $296,067 Ongoing Multiple projects. Replacement 10019 Inspection and Multi-Year S75,000 $10,377 $0 $10,377 Complete Testing for Hazardous Materials 10020 Office Space Multi-Year S882,934 S143.052 $74.542 $68,510 Construction Jun 03 Renovation Realtocation 10102 Civic Center Multi-Year $2.312,000 S2,257,986 $188.442 S2,069,544 Design Dec 04 Infrastructure Improvements ~-~Elec~cal Systerr~ Multi-Year $115,000 $114.697 $105,668 59,030 Construction Ongoing projects. Improvements "~104 Fire Station "Multi-Year S174.000 $174,000 54,000 5170,000 Design Jun 04 Improvements 10105 Lucie Stern Multi-Year $51,000 $50,975 $0 $50,975 Design Jun 03 RFP will go out in Feb 03, design to begin in Mar 03. Com_munity Center Improvements 10121 Homer Avenue Multi-Year 52,800,000 $2,396.958 $2,085,185 Design Mar03 Staff is currently finalizing 100% design. Undercrossing 10210 New VebAcles Multi-Year $190,000 S29,823 $12,942 Complete On~_oing projects. 10222 Facility Interior Multi-Year $ t 00,000 599,100 $64.400 Design Finishes 10300 Multi-Year $20.O00 520,000 $20,000 Design Jun 05Foott~ills Park Interpretive Center Mechanical Upgrades $311,773 S16.881 $34,700 $0 FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS INTERNAL SERVICE FUND GENERAL FUND PUBLIC WORKS DEPARTMENT As of November 30, 2002 10o22 / 81101 10023 / 81102 81100 81105 81106 MSC Fuel Minor Storage/Svc Island { Replacement MSC Equipment Minor Washing Facility Upgrade MSC Equipment Minor Maintenance Facility Mezzanine Storage Area Wireless Vehicle Minor Management System Fuel Storage Tanks Minor Upgrade i $900,000 S300,O00i $85,000i $25,000i S25,000 ~ S740,350i $14,668i S274,214i S35,4621 S78,000 ~S65.740i S25,000 $25,000 $565 S725,682 Desizn Jun 03 S238,752 Design Jun 03 S 12,260 Desi-°n Jun03 S24,435 Construction ;;J~n 03 S25,000 Design Jun 03 Design 90% complete. Will bid for construction Jan 03. Desizn 50% complete. Will bid for construction Jan 03. Construction will commence Feb 03. Stationary infrastructure will be in place by Feb 03. Vehicle outfitting is ongoing. Design for Foothills Park facility complete. Construction will commence Mar 03. 19205 19521 81104 Fuel Tank Multi-Year Storage/Upgrade [Wireless Vehicle Multi-Year Management System $291,000 $205,000 $50,062 $27,711 S50,000 $20,734 $62 Design Jun 03 $6,978 Construction Jun 03 Golf Course Multi-Year Equipment Replacement New Vehicles Multi-Year 5145,000 $208.000 $81,849 $208.000 S401 $32.746 S81,448 Ongoing Jun 03 $175.254 Construction Jun 03 Design for Foothills Park facility complete. Construction will commence Mar 03. Stationary infrastructure will be in place by Feb 03. Vehicle outfitting is on,,oin,,. Bids will be issued by Feb 03. Two vehicles have been delivered, and two more are on order. Final unit will be ordered by Feb 03. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: ELECTRIC FUND DEPARTMENT NAME: UTILITIES DEPARTMENT As of November 30, 2002 0008 Adobe Crk Subst Minor Cable Replacement 0125 Nexv Vehicles Minor 0121 Natural Gas Back- Minor Up Generator 0216 New Vehicles Minor S350.000 $20,761 SO $149.600 S521 $3 54.982.739 $605,431 S342.730 $30,000 S1,080 S0 $20,761 Complete $518 Complete $262.701 Complete $1,080 Construction Jul 03 9250 Alma St 12KV Multi-Year $1.640.000 Addition 9904 East Meadow UG Multi-Year 5400 000 Systems Rebuild 9916 Fiber to Home Trial Multi-Year 51.005,000 9611 Embarcadero/Middle Multi-Year 55,360.000 field UG Conversion District #37 9804 OregordColorado/Co Multi-Year $2,790.000 wper UG Conversio~ District #38 9901 Stanford West Underground Extension Multi-Year 9902 Stanford Shopping Multi-Year Ctr 4-12kV Conversion $1.700.000 $500.00~ 549,376 $298[ S6,933 $0 $19,537 S1,260 S582.180 S8.836 S2,554,677 S302,35~- 5214.336 $93,105 549.078 Desi~ S6,933 Complete $18.277 Complete $573,3~44 Construction $...b~,319 Construction 5120 $2t4.216 Construction $0 $93,105 Complete TBD IVlar 03 Dec. 04 Jul 03 Project is on hold. Waiting for pole removal from Pac Bell. Design complete. Construction complete except for the senior housing complex. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: ELECTRIC FUND DEPARTMENT NAME: UTILITIES DEPARTMENT As of November 30, 2002 9903 0006 Stanford Park UG Multi-Year $4’.075,000 $1.695,552 Cable Rebuild $75,676 $1.619.876 Construction Jul 04 Park Boulevard Multi-Year Substation Bus Re- arrangement $2.755,000 $2.618,083 $148.620 S2,469.463 Design Dec 03 First two phases are complete. Third phase begins construction Jul 02. Design complete. Construction bidding will occur in Jan 03. 0010 CitylFacs/Svst Multi-Year S 190,000 $163.748 S0 $163,748 Complete Upgrade Electric 1 Vehicles 0103 Under_qround Multi-Year S1 000.000 S975.486 S142.299 S833,187 Design Mar 03 Contract out to bid.~Construction will be Cable/Equipment complete by Mar 03.Replacement 0115 West Bayshore UG Multi-Year 5450.000 S109.336 $105.’447 Construction Jul 03 System Rebuild 0116 S579.000 S94,676 Construction Mar 03Downtown Street Multi-Year Light System Upgrade Upgrade Traffic Multi-Year Signal Control System North/South Multi-Year Hampton UG System Rebuild Baylands Multi-Year Underground ~Multi-YearSCACA System Upgrades Electric Utility GIS Multi-Year S214,783~ S511,233[ $1,878,9541 S416,5571 $199.7191 S1,679.235 Construction S1,560.422 Construction Jun040117 Data ShermardE1 Camino/Page MillfPark UG Conversion District #39 S1.905,000 Construction complete by Jul 03. Design complete. Construction beginning in Nov 02. {Construction complete by Jun 04. Edgewood Drive Multi-Year Underground Conversion District #40 0313 Utilities Estimating Multi-Year S250.000 S250,000 SO S250,000 Design Jut 03 Bid packageis being System prepared. 0314 S50,000 S50,000 S0 S50.000 Design Dec 03 Design will start in Jan 03. 0102 S1 700.000 S1 578,491[S18,069 Jul 03 Test construction complete. Final design in progress. 0209 S500.000 S499.866 S13,855 $486.011 Design Jul 03 Design in progress. 0210 $400.000 S200,370 S44.539 S155.831 Design Jul 03 Installation complete. 0211 S162.500 $146.625 S43,903 S102.722 Design Jut 03 Contract has to be signed to create layering standards. 0305 Multi-Year $95,000 S95.000 S0 $95.000 Design Dec 05 Formation of the District will start in Apr 03. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: GAS FUND DEPARTMENT NAME : UTILITIES DEPARTMENT As of November 30, 2002 0118 All Weather Minor Arastradero I 0120 Gas Main Minor Directional 0213 Directional Boring Minor Machine 0310 CNG Sequential Fuel System 0311 New VebScle Minor Nlinor $70,000 S275,000 $47,500 S126,000 $75,000 $27,000 S55,548 S42,012 S251,575 $237,979 S2,725 $2,699 $47,094 S700 $75,000 S27,000 $0 $22,706 $13,536 $13,596 Construction Jun 03 $26 Complete S46,394 Construction Jun 03 $75,000 Design Oct 03 S4,294 Constraction Jun 03 Contract work will be completed after the rainy season is over. Equipment delivered, specifying auxillary parts and conducting training. Planning permits approved, preliminary plans completed. Project to bid in Mar 03. 0011 Compress Natural 1Multi-Year S440,000 Gas Station { 0119 -Global Positioning Multi-Year S381.000 System $379,929 S320,157 $0 $80,132 5379,929 $240.025 Desi~mn Oct 03 Construction Jun 03 Project integrated with MSC liquid fuel station project. Project will go out for bids in Mar 03. Construction starts Jul 03. GPS Base Station installed on top of City Hall. Roving data 0307 Directional Boring Equipment 0308 Polyethylene Fusion Equipment vlulti-Year Multi-Year S47,500 $47,500 S25,000 S25,000 so so $47,500 $25,000 Pre-Design Jun 03 Pre-Design Jun 03 collection unit purchased. Three more on order. Staff training in { FeblMar 03. Settin_o up blanket order with local equipment supplier. Setting up blanket order with local equipment supplier. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: WATER FUND DEPARTMENT NAME : UTILITIES DEPARTMENT As of November 30, 2002 0109 Mayfield Reser-,’oir Minor Roof Repairs 0113 Irrigation Meter Minor Installation Program 0114 0217 0312 Land Acquistion for Minor a resetstit, a well and pump station. Water Botding Equip Minor 5290,000 $16,908 S0 S60,000 $59,335 S0 $2.000,000 S1,999,055 S1.466.948 $25,000 S24,430 S0 $16,908 Complete $59,335 Pre-Design $532,t07 Pre-Design $24,430 Pre-Design ; TBD Jan 05 Jun 04 Havin~ difficulty with customers taking advantage of pro=m-am benefits. The Carollo contract encumbered under this MPN should be encumbered under MPN 0205. MinorNew Vehicles ,S50,000 $50,000 $43 855[$6,145 Construction Jun 03 Vehicles purchased. Final vehicle configuration in progress. 8749 9704 0108 0110 0111 Water Reser’,’oir Multi-Year lmpmv. Water System Study Multi-Year Foothills PRV [Multi-Year Installation Reservoir Booster Multi-Year Improvements Distribution System Multi-Year Water Quality Enhancement Noti $63.294i $49.453i Available $275,0001 $40,5981 $39,705i S236.0001 S235,150 $1.360.000 $1.359.055 5407.210 $457.000 S456.055 S121.041~ S13,841 Complete $893 Complete $235,150 Design S951,845 Design 5335,014 Design i Sep 03 Sep 03 Sep 03 Carollo is designing the PRV station improvements. Four additional receiving station PRV installations were added. Design contract awarded to Carollo En~ineerinz. Desi-n of booster station improvements has started. }Design contract awarded to Carollo Engineering. Design of reservoir water mixing systems has started. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: WATER FUND DEPARTMENT NAME : UTILITIES DEPARTMENT As of November 30, 2002 0112 O2O4 0205 0206 ;Booster Station Multi-Year Existing Well Rehab Multi-Year E1Camino Park Multi-Year Resep,oir and Pump Station E1 Camino Park Well Multi-Year 0207 Middlefield Road Well Site 0208 Eleanor Pardee Park Well Multi-Year Multi-Year S205,000{ S950,000 S 1,700.000 $280,000~ S280,000 $280.000 S2040551 S949,400! S1 699,810 S279,737i $279,737 $279,452! S628!6! SO $0~ $266,622i S141,239 Desi=ma $949.400 Pre-Design S 1 699 810 Design $13,115 Design S0 S279,737i Pre-Design S0 S279,452 Pre-Design Oct 03 Jan 04 Jan 04 Jan04 Jan 04 Jan 04 Design contract awarded to Carollo Engineering. Design of booster station pump systems has started. Contract awarded to Carollo Engineering for Phase II Water Study Design. Design contact awarded to Carollo Engineering. Siting of new reserwoir and pump station systems has started. Design contract awardedto -- Carollo Engineering. Design of new wel! will start after the new resep,,oir is sited. Contract awarded to Carollo Engineering for Phase II Water Study Design. Contract awarded to Carollo Engineering for Phase II Water Study Design. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: WASTEWATER COLLECTION FUND DEPARTMENT NAME : UTILITIES DEPARTMENT As of November 30, 2002 0122 Wastewater Minor Collection System Master Plan 9173 Wastewater Rehab/Augment $400.000 $233,755i $233.533!$222 Desi~ma Aug 03 iMulti-Year i$2.119,390 $541.688i $146.806 $394,882 Construction Jun 03 Hydraulic Model calibration is in pro~ess. Contractor working on punch list items to finish out project. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: MULTI FUNDS DEPARTMENT NAME: UTILITIES/PUBLIC WORKS As of November 30, 2002 9905 Ut lities Bill Print Minor DesLma S4,666,553 $900,029 $36,228 S863,801 Construction Jun 07 DOC1 application, eBPP functionality is now being researched. 9357 Utilities Customer Multi-Year Info. System Major upgrade of software was completed in Apr 02. The TCP contract is being upgraded to a 7x24 support contract, This will be completed before the end of 02-03. New server upgrades are in the plan for 03-04. The CWA project is underway and will completed in 02-03. Further Banner upgrades are being planned. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: REFUSE FUND DEPARTMENT NAME: PUBLIC WORKS DEPARTMENT As of November 30, 2002 0219 FuelTruck Minor $115,000 $115,000 9701 Multi-Year $2,287,722 $1,876,t72 $381.661 $1,494,511Pre-Design May 10Environmental Sen, ices Center Project delayed until completion of study to discover all existing Baylands Policies. FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: STORM DRAINAGE FUND DEPARTMENT NAME: PUBLIC WORKS DEPARTMENT As of November 30, 2002 FY 02-03 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS FUND TYPE: ENTERPRISE FUND NAME: WASTEWATER TREATMENT FUND DEPARTMENT NAME: PUBLIC WORKS DEPARTMENT As of November 30, 2002 9805 Effluent Line Minor $150.000 $43,784 $0 Modification 0215 500 KW Minor $150,000 $41,181 Emergency Generator $43,784 Complete $4t,181 Complete 9504 Interceptor Multi-Year S1.750,000 $105,796 $48,913 S56,883 Construction Sep 03 F nal contract is planned for Maintenance Apr 03. Cleanin~ and Repair 9707 Wastewater Solids Multi-Year S7 500,000 $136,246 $151,793 ($15,547) Construction}Jun 03 Disposal Project Checklist items and warranty work still needs to be done. Mid-year BAO submitted for $141.706. Attachment 3 ADMINISTRATIVE SERVICES 18614 19618 19808 19914 Financial Database Upgrade GIS Application Financial Applications Development New Computer Acquisitions COMMUNITY SERVlCES 18617 19415 Art in Public Places Park Facilities Improvements PUBLIC WORKS General Fund 18903 18971 18670 19018 19101 19309 8870 8021 8022 Sidewalk Improvements Street Improvements (Utility Users Tax) Street Improvements (Street Improvement Fund) Cubberley Building Code Modification Tank Investigation and Removal ADA Compliance Storm Drainage Fund Collection System Improvements Wastewater Treatment Fund RWQCP Plant Equipment Replacement RWQCP System Flow tvletering UTILITIES 8928 8930 8931 8938 8944 9354 9703 9801 9802 9803 Electric Fund Customer Design and Connection Sere’ices Traffic Signals Upgrade Communication System Improvements Substation Protection Improvements Substation Facility Improvements Street Light Replacements Underground Cable and Equipment Replacement Fiber Optics Ring System Improvements Fiber Optics Customer Design and Connection Services Electric Distribution System Reconstruction and Improvements Gas Fund 8017 8019 9230 8018/9912/0002/0104/0201/0302 0309 Gas System Extensions Gas Meters and Regulators Natural Gas Vehicle Conversions and Purchases Gas Main Replacements Unreimbursed System Extensions Wastewater Collection Fund 8020 Sewer System Extensions 9913/9914/0003/0105/0202/0303Sewer System Rehabilitation and Augmentation Water Fund 8013 8014 8015 8016/9915/0004/0106/0203 0214/0304 Water System Extensions Sere’ice and Hydrant Replacements Water Meters Water Main Replacements Water-Gas-Wastewater Utilities GIS Data