Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Staff Report 150-10
TO: HONORABLE CITY COUNCIL ATTN: FINANCE COMMITTEE FROM: CITY MANAGER DEPARTMENT: ADMINISTRATIVE SERVICES DATE: MARCH 2, 2010 CMR: 150:10 SUBJECT: Consideration of Recommendation for City Council Adoption of the Fiscal Year 2010 Adjusted Budget -- Second Quarter (Q2) Financial Results, Midyear Amendments, and Capital Improvement Program Status EXECUTIVE SUMMARY The documents attached summarize and outline changes to the City's fiscal year 2010 budget necessary during the normal course of business, and require budget amendments as the City appropriates funds at the department level. Additionally, revenue declines drive further expenditure reductions. RECOMMENDATION Staff recommends that the Finance Committee recommend to the City Council adoption of the attached Budget Amendment Ordinance (BAO). (Attachment 1) and Resolution (Attachment 6), which includes: a. Proposed midyear adjustments to the Fiscal Year 2010 Budget for the General Fund, Enterprise Funds, Special Revenue Funds, Internal Service Funds, and Capital Improvement Projects Fund (Exhibit A). b. Fiscal Year 2010 Midyear CIP Adjustments (Exhibit B). c. Amendments to the Fiscal Year 2010 Table of Organization (Exhibit C). d. Amendments to the Fiscal Years 2006-2009 Service Employees' International Union (SEIU) Compensation Plan (Attachment 6). The following are attached as informational items; no action is required on these items. • Graph depicting General Fund Capital Improvement Program Expenditures Summarized by Project Category -Five Years (Attachment 2) • General Fund Capital Improvement Program Project Expenditures -Five Years (Exhibit A) • Fiscal year 2009 midyear Capital Improvement Program Projects Status Report (Attachment 3) • Continuous Capital Projects -Five Years of Expenditures (Attachment 4) • Graph depicting General Fund Transfers to Infrastructure Reserve -Ten years CMR: 150:10 Page 1 of 14 (Attachment 5) • Police and Fire Departments Overtime Analysis for Fiscal Years 2005 through 2009 with Fiscal Year 2010 Data Through January 30, 2010 (Attachment 7) • Summary of California State Municipal Finance Officers (CSMFO) Group List Budget Gap Survey (Attachment 8) Staff also recommends the Finance Committee review and comment on the preliminary FY 2010 budget condition of the City as of January 29, 2010 (Exhibit A to BAO). BACKGROUND This report summarizes the changes to the Fiscal Year 2010 Adopted Budget necessary as part of the normal course of business through January 29, 2010. Where possible, adjustments are held until this midyear report is brought to Council in an effort to consolidate changes and streamline the Budget Amendment Ordinance (BAO) process. The discussion in this report is organized 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 Program Project Status Report (Attachment 3) provides the Finance Committee with information on the status of the City's CIP projects as of December 31, 2009. Due to the effects of the current recession on key City revenues, staff is proposing expenditure reductions at midyear. The current projected budget gap in the General Fund for Fiscal Year 2010 is $6.3 million. The increase in the budget gap from earlier estimates is largely the result of steeper declines in sales taxes, program fees, plan check fees, and other revenues. As can be seen in Attachment 8, cities across California are experiencing similar midyear budget gaps. DISCUSSION General Fund — Midyear Financial Report The following is a summary of major revenue and expenditure adjustments in the General Fund as detailed in Exhibit A. General Fund revenues have continued the downward trend from FY 2009 into FY 2010. High unemployment, the lack of growth in wage income, low consumer confidence, and credit restrictions have eroded economically sensitive revenue sources such as sales and transient occupancy taxes and planning and permit fee revenues. With the exception of documentary transfer taxes, there has been little evidence to date of a turnaround in key income sources. Sales Tax Sales taxes are expected to drop by $2.5 million, or 12.5 percent, below the adopted budget at year end. Third quarter results for 2009 showed a 9.0 percent decline compared to the prior year quarter and this has followed mid -double digit declines for the prior 3 quarters. Department, apparel and electronic stores have had noticeable declines as have auto dealers and restaurants. Another contributing factor to the midyear adjustment is the significant downward adjustment the state has made in its "triple flip" payment that is not reconciled until Fiscal Year 2011. Staff will not know the critical fourth quarter sales tax results until the middle of March. Property Tax CMR:150:10 Page 2 of 14 Property taxes are expected to be in -line with budgeted revenue estimates at year-end. Unlike other, less fortunate jurisdictions in the Bay Area, property values have remained relatively stable. There are, however, a few troubling signs. The County is receiving an overwhelming number of appeals from commercial properties to adjust their assessed values downward. It is not known how many of these appeals are coming from Palo Alto businesses and it is unlikely the County can address all of the appeals within the next two years. Staff projects property taxes to remain flat (compared to FY 2009 results) for this year and next. The FY 2011 roll will, in fact, be adjusted by a negative 0.26 percent based on the California CPI. This most likely will effectively nullify any growth in this revenue source. Transient Occupancy Tax Compared to the adopted budget, Transient Occupancy Tax (TOT) revenue estimates are being decreased by $360,000 to $6.6 million. Occupancy rates through the first quarter were below those of the prior quarter by 17 percent and would have been close to 20 percent lower without the August senior games. Occupancy and daily room rates have averaged 65 percent and $131 per day, respectively, through December 2009. While these rates are low and have caused the downward revision, staff is hopeful that bookings generated by the Destination Palo Alto Program will stabilize and lead to higher revenues. Interest Earnings Because of the duration of the Federal Open Market Committee's (FOMC) monetary policy decisions to stimulate the economy with low interest rates, projected interest income for FY 2010 must be adjusted downward by $238,000. Until there is evidence of an economic uptick, the FOMC is expected to maintain the federal funds rate at historically low levels between zero and one-half percent. Documentary Transfer Tax Documentary transfer tax revenues are being increased from $2.80 million to $3.25 million. Through the month of January, cumulative receipts are 10 percent above the same prior year period. From anecdotal and actual residential transaction data, it appears that this revenue source will continue to perform well. Other Fees and Permits Revenues for plan check and building permit fees are being decreased by about $900,000 from the adopted budget. This reflects the downward trend in housing starts and construction activity. Parking violation revenues decreased by $500,000 in part due to decreased retail traffic throughout the commercial business district. Decreases in revenue from other fees include: golf green fees - $213,000; and class program fee revenue of $355,000. Transfers from Other Funds A total of $3.2 million is being returned to the General Fund from the Capital Projects Fund. This amount includes $2.7 million that had been earmarked for the design of the Public Safety Building. The remaining amount represents unused funds from capital projects that have now been dosed. CMR:150:10 Page 3 of 14 Expense Highlights for Fiscal Year 2010 Midyear The table below summarizes the total proposed midyear budget revenue and expenditure changes and the impact to the Budget Stabilization Reserve (BSR). Table 1: FY 2010 Proposed Budget Balancing Plan General Fund Revenue Reductions Operating Transfers from CIP Net Decrease in Non -salary Reductions Net Increase due to Loan Repayment to Technology Fund and Other Net General Fund Expenses Operating Transfers Out Net Shortfall Transfer from Equity Transfer Stabilization Reserve Salary and Benefit Savings Midyear change to Budget Stabilization Reserve $ (4,308) 3,243 1,250 (2,841) (3,537) (6,193) 3,636 1,704 (853) Staff presented the tentative plan to balance the FY 2010 budget at midyear to the Finance Committee on December 1, 2009 (CMR 434:09). The Finance Committee approved the plan in - concept. Expenditure Reductions At midyear, City departments have provided the City Manager with expenditure reduction recommendations to offset the revenue decrease and to balance the General Fund budget for Fiscal Year 2010. Approximately $1.7 million of the recommended reductions are salary and benefit related savings, and $1.25 million is the result of non -salary expenditure reductions. A draw on the Budget Stabilization Reserve of $853,000 is required. This draw is less than the previously estimated amount of $1.8 million which had been reported in the Long Range Financial Forecast in February (CMR:143:10). This lower figure is the result of a lower than anticipated amount in temporary salaries and overtime requests ($100,000); increased salary and benefits savings ($500,000); additional non -salary reductions ($250,000); and net increase in revenue ($100,000). In order to balance the budget, the City will need to make systemic expenditure reductions in the upcoming Fiscal Year 2011 budget process that will have significant adverse impacts on programs and services. This is necessary given an expected weaker economy and a larger, growing gap of approximately $6.3 million. A detailed narrative of the departmental expenditure reductions and potential service impacts are listed below. CMR:150:10 Page 4 of 14 City Attorney The City Attorney's office has identified $47,000 in expenditure reductions for outside counsel services. This may have some effect on services to departments. City Auditor The City Auditor's office has identified $12,000 in expenditure reductions. The reduction was achieved primarily through negotiating a one-time Cost Price Index (CPI) savings on a vendor contract and Peer Review savings. Additionally, the City Auditor's Office has generated $123,000 in new revenues, which resulted from Alternative Fuel Tax recoveries, and absorbed the recovery cost within the department's Fiscal Year 2010 adopted budget. City Clerk The City Clerk's office has identified $6,000 in non -salary expenditure reductions for Instruction/Training and Travel/Meeting. City Manager The City Manager's Office has identified a total of $34,000 in non -salary expenditure reductions. Reductions include Program/Projects and Advertising/Publishing. Administrative Services Department The. Administrative Services Department has identified $55,000 in non -salary expenditure reductions. This was achieved primarily through the reduction of Contract Services, Instruction/ Training, and Travel/Meetings. Administrative Services Department — Information Technology Fund The Information Technology Internal Service Fund will receive increased reimbursement for the repayment of FY 2009 allocated charges deferred from the General Fund. This will result in a $1.2 million increase in revenues to the Technology Fund, offset by an increase in allocated charge expenses to various General Fund departments. Community Services Department The Community Services Department has identified $283,000 in non -salary expenditure reductions. CSD also reduced its budgeted revenues by $819,000. Significant reduction in revenues includes $213,000 in golf green fees and $355,000 in class registration fees. The economic condition is projected to affect the golf rounds played from the originally projected of 76,000 to 72,000 thus reducing revenues. CSD also experienced a 6 percent decline in program and camp registrations this summer. It is clear that the down -turn in the economy has significantly impacted classes and programs. Fire Department The Fire Department has identified $60,000 in non -salary savings. Reimbursement revenues declined by $200,000 due to decreased expenditures throughout all departments that allocate costs to the Fire Department. The Fiscal Year 2009 budget to actual year end reconciliation fell shorter than projected due to the Technology Fund transfer reversal needed to close Fiscal Year 2009. The General Fund will repay the Technology Fund over four years. At midyear, $1.2 million of the fiscal year 2010 CMR:150:10 Page 5 of 14 repayment was allocated to the Fire Department. Human Resources Department The Human Resources Department has identified $51,000 in non -salary savings. The department cancelled the annual Employee Recognition Picnic for $6,000 (substituting a different recognition event) and cancelled non -mandatory employee training for $45,000. Library Department The Library Department has identified $124,917 in non -salary expenditure reductions. Significant reductions include reduction of $89,778 in online data base collections, and serial and book purchases. The Library also received a grant of $22,840 from the California Public Library Fund which will be used to purchases books. Planning and Community Environment The Planning and Community Environment Department has identified $180,000 in non -salary expenditure reductions. Significant expenditure reductions include $102,000 from various contract services and $42,000 in general office/administration. There is a $25,000 reduction in the Advance Planning — General Other contract services budget which will reduce housing contracts. In Current Planning -- General Other contract services is also being reduced by $16,000, this will reduce the consultants who can work on cost recovery projects. There is also $61,000 in smaller contracts that have been reduced or eliminated. PCE reduced revenues by $181,000 primarily due to decreased permit revenues and plan checking fees. Police Department The Police Department identified $164,000 in non -salary savings. City staff recently spoke with the County and the County is currently being reimbursed by the State for booking fees. Booking fees were reduced $120,000 and it is anticipated that the State will continue reimbursing the County in Fiscal Year 2011. In addition, the department identified $44,000 in unused crossing guard funds. These savings are accrued from the multi -year contract due to less than anticipated use of crossing guards during summer school sessions. Public Works Department The Public Works Department has identified $199,000 in non -salary expenditure reductions primarily in contract services, supplies, and materials. In addition, revenue has been reduced mainly due to a decline in plan checking fees. A state grant of $120,000 for the Urban Forestry Inventory Grant Program will enable the City to complete an inventory of trees on parkland and an update of the street tree inventory. This program will require a cash contribution of $39,000 from the City ($29,000 from the existing operating budget, and $10,000 added at midyear). General Fund Salaries and Benefit Savings, and Overtime Analysis While it is recognized that total overtime has increased due to seasonality and backfilling due to departmental vacancies, net salaries and benefits savings attributable to the vacancies ($3.458 million) exceeds the excess overtime ($1.906 million) (see Table 2). Table 3 illustrates that total CMR:150:10 Page 6 of 14 overtime expenditures equal 110 percent of the mid -year budget. Table 2: General Fund Salary and Benefits Savings General Fund Salary Savings As of February 15, 2010 (in thousands) Overtime Active Exceeding Recruitments Budget Net Savings Salary savings Benefits savings Subtotal $3,660 2,280 ($358) ($1,906) $1,396 (218) 2,062 5,940 (576) (1,906) 3,458 Workers' Compensation and General Liability Incurred but not Reported (IBNR) Liability* (1,320) Changed in Accrued Compensated Absences (434) Net Savings After Adjustments $4,186 (1,320) (434) $1,704 Categories Table 3: General Fund Overtime CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR FINANCIAL REPORT GENERAL, FUND OVERTIME (In Thousands of dollars) Adopted Budget Adjusted Budget Midyear Budget oi:=ss�ra Midyear % of. Changes Actual Adj Budget City Attorney City Auditor City Clerk City Council City Manager Administrative Services Community Services Library Fire Human Resources Planning and Community Environment Police Public Works 7 3 45 105 58 1,018 4 67 1,000 113 7 3 45 105 58 1,018 4 67 1,000 113 72 0 0% 1 14% 0 0%, 21 47% 61 58% 32 55% 1,502 148% 0% 27 40% 899 90% 107 95% ,050 Although most of the General Fund departments are on track or below their overtime budget, the Fire, Police, and Public Works Departments are exceeding their budgets for the reasons identified below. CMR:150:10 Page 7 of 14 • The Fire Department has used 148 percent of its annual overtime budget through the end of January 2010. This is due to Station #8 staffing ($190,000) and Medic -1 staffing ($245,000). The remaining $1.1 million resulted from backfill for minimum staffing requirements due to sick leave (personal and family sick leave), vacations, other leaves (military, bereavement, jury duty), out -of -county Strike Team Deployment, workers' compensation light duty assignments and workers compensation for employees on full disability. The number of employees on full disability has been extraordinarily higher in Fiscal Year 2010. • The Police Department's has used 90 percent of its annual overtime budget but has reduced overtime spending by 9 percent from the previous year. The main factors contributing to overtime usage are staffing shortages due to disability leave, vacancies in patrol and the 9-1-1 dispatch center, and academy and field training programs. Also, overtime was incurred in watching the train tracks prior to enlisting a private security services. Traffic control services at Stanford football games and other events are partially offset by reimbursements from the university and organizations. • The Public Works department has used 95 percent of its annual overtime budget. Due to vacancies, the department has had limited staffing in custodial and facilities maintenance areas and has used overtime to maintain minimum service levels. During the first half of FY 2010 the department used limited hourly personnel to assist with custodial and facilities maintenance services. Overtime costs are expected to rise further as the temporary salary budget is exhausted and vacancies are left unfilled. Enterprise Funds Please refer to the detailed fund summaries in Exhibit A for more information on Enterprise Fund midyear changes and to the CIP section of this report. • Electric Fund (Net reserve reduction of $235,000) — The Electric Fund reserve is increased by $2.7 million for the return of the Equity Transfer Stabilization Reserve from the General Fund. Funded from Gas and Electric Fund revenues, this reserve within the General Fund was established by Council in April 2000 to buffer the Utilities Equity Transfers from the volatility of gas and electric prices. During the FY 2010 budget process, Council approved a change to the equity transfer methodology. Under the new equity transfer methodology, the Equity Transfer Stabilization Reserve is no longer needed and the balance in the reserve will be returned to the Gas (25%) and Electric Funds (75%). Also in the Electric Fund, $563,000 in federal stimulus funds will cover expenditures for the LED streetlight project EL --10009 ($463,000) and for expenditures related to a home energy report consultant ($100,000). The Calaveras Reserve within the Electric Fund is reduced by $2.0 million to fund the Electric Efficiency Financing Program, which aims to assist businesses to install energy efficient equipment (approved by Council on December 7, 2009, CMR 430:09). The Public Benefits Program Reserve within the Electric Fund is reduced by $500,000 to fund additional electric efficiency rebates and third party implementation programs. CMR:150:10 Page 8 of 14 • Fiber Optics Fund (Net reserve reduction of $50,000) — The Fiber Optics Fund reserve is reduced by $50,000 to fund contract services related to telecommunications engineering evaluation and system design. These services are necessary to assist the City in preparing a business plan for its fiber optics operations. • Gas Fund (Net reserve addition of $896,000) — The Gas Fund reserve is increased by $909,000 for the return of the Equity Transfer Stabilization Reserve from the General Fund. Also in the Gas Fund, $100,000 in federal stimulus funds will cover expenditures related to a home energy report consultant. Capital Improvement Program Adjustments to the City's 2010 Capital Plan are noted in Exhibit A, with specific project adjustments described in Exhibit B. All of the CIP changes fall into three basic categories: projects requiring additional appropriations, projects having reductions in appropriations, and other miscellaneous adjustments such as transfer of funding between projects. Highlights of C]P changes are as follows: General Fund • Street Maintenance — CIP PE -86070 — Increase funding by $457,149 and increase project cost by the same amount. This adjustment is made to reflect revenue received from the State of California Proposition 42 (Traffic Congestion Relief Fund) and grant approved by the American Recovery and Reinvestment Act (ARRA). (No reserve funding required.) • Thermoplastic Marking and Striping — CIP P0-11001— Initial appropriation of $ 250,000 to come from a transfer of appropriation from the Street Maintenance C]P Project (PE - 86070). This is a new project created to cover the cost of thermoplastic lane markings to pave roadways. Thermoplastic takes the place of water based paint that has been typically used for street marking/striping. Thermoplastic outlasts paint by three to five years depending on the road condition. (No reserve funding required.) • Crime Scene Evidence Collection Vehicle —PD-08000 — Net increase in funding by $20,000 bringing total appropriation to $150,000. In FY 2009 it was anticipated that Stanford would contribute $30,000 toward this project. Stanford has since informed the City that they will not be able to fund this project. The Citizens Options for Public Safety (COPS) has provided $50,000 both to replace Stanford funding and to increase the project by another $20,000. (No reserve funding required) • College Terrace Library — PE -05010 — Return appropriation of $1.4 million to the Infrastructure Reserve. Savings was generated due to lower than anticipated construction bid. (No reserve funding required). • Police Building Project — PE -98020 — Return appropriation of $2.7 million to the General Fund Budget Stabilization Reserve since this project is on hold. (No reserve funding CMR:150:10 Page 9 of 14 required). • Intermodal Transit Center — CIP PL -07001 — Return funding to the Infrastructure Reserve ($655,341) and to the General Fund ($182,039). This project is temporarily on hold. (No reserve funding required). • Mitchell Park Library Improvements — CIP PE -04012 — Close project and return amount of $254,743 to the Infrastructure Reserve. A new project for the Mitchell Park Library and Community Center (PE -09006) funded by Measure N Library bond had been created and replaces this project. (No reserve funding required). • Lot S/L Garage Project — PE -95030 - This project was funded by the Certificates of Participation bonds. The project is now complete and closed. The balance of $383,406 will be applied against debt service payments thereby reducing the assessment to the parking district. (No reserve funding required). • Various Projects (See attached Exhibit 13 excluding projects identified in the preceding sections) — A total balance of $874,483 of various completed and closed CIP projects will be returned to various funding sources. The amount returned will be made available to other CIP projects needing funding. (No reserve funding required.) Enterprise Funds • East Meadow/Alma/Loma 4/12kV Conversion — CIP EL -08002 — Increase funding by $500,000. Appropriation is moved from FY 2011 to FY 2010 to take advantage of the lower contract construction costs due to the present economy. Combining the project into one instead of two as originally budgeted will also help reduce the engineering, inspection and contract administration costs. (Electric Fund Distribution RSR: $500,000 reserve funding.) • Street Light System Conversion Project —CIP EL -10009 — Increase funding by $463,000. This project will be funded by the 2009 Stimulus Application under the Energy Efficiency Community Block Grant (EECBG). (No reserve funding required.) • Water Main Replacement Project 22— CIF WS -08017— Increase funding by $200,000. The additional appropriation will cover the cost of the street cut fees payable to the City's General Fund (Waster Fund RSR: $200,000 reserve funding.) Table of Organization Changes The proposed adjustments to the Table of Organization (Exhibit D) include one title change and the following Add/drop: 2.0 FTE • Utilities Department: Add 1.0 FTE Assistant Cathodic Protection Technician and drop 1.0 Ft Water Systems Operator II to maintain compliance with Department of Transportation requirements. CMR:150:10 Page 10 of 14 • Utilities Department: Add 1.0 FTE Gas Systems Tech 11 and drop 1.0 FTE Utility Field Services Representative to maintain compliance with Department of Transportation requirements. Fiscal Year 2010 Midyear Capital Improvement Program Protects Status Report This report provides the Finance committee with information on the status of the City's Capital Improvement Program (CIP) projects as of December 31, 2009. The attached graph summarizes all General Fund projects by project category and provides five years of actual expenditures (Attachment 2). Information about individual projects within each project category is provided in Exhibit A. In the attached matrix (Attachment 3), the 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. The report is intended to update Council on the progress of all CIP projects opened at the beginning of FY 2009, and on those that were added or completed during the fiscal year. The matrix categorizes CIP projects into minor projects (projects that can be completed within a one- year period) and multi -year projects (projects that have multi -year budgets and/or complex implementation schedules with identifiable phases). The project status portion of the matrix identifies the phase in which the project was at fiscal year-end, and illustrates how much progress was made. Three distinct phases are utilized, as follows: Phase Activities Pre -Design Design Construction • 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 In the attached matrix, projects are listed by department for the General Fund and by fund for the Enterprise and Internal Service Funds. The matrix also includes information on the total budget of the project from inception, available budget as of the beginning of the fiscal year, fiscal year expenditures, and fiscal year contingencies, fiscal year encumbrances through December 31, remaining balance in the project budget as of mid -year, and the percentage of completion for the project. 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 continuing CMR:150:10 Page 11of14 replacement cycles or commitments. Continuous projects are listed by responsible department and fund and include five years of actual expenditures including the current fiscal year through December 31, 2009 (Attachment 4). General Fund Infrastructure Backlog Update The current rate of funding from the General Fund and Infrastructure Reserve, which is around $10 million per year, is about $5 million less than what is required to fund the $302 million 20 -year infrastructure backlog. This amount includes backlogged work carried over from prior years as well as future, required work to maintain the City's streets, sidewalks, parks, open space, buildings, and other facilities. In addition, the report identified another $148 million (this figure does not include the Public Safety Building estimated at $60 million) to replace existing facilities that have exceeded their useful life or need substantial improvements. These include, for example, the replacement/improvement of the Municipal Services Center, two fire stations, the animal shelter, and the Junior Museum. The staggering estimate of $510 million (including the Public Safety Building) in infrastructure rehabilitation and replacement needs reinforces the severity of the City's "structural" gap. The current rate of funding from the General Fund and Infrastructure Reserve, which is around $10 million per year, is inadequate to meet the annual $15 million needed to offset the $302 million backlog in any predictable or reliable way. The Infrastructure Reserve balance currently stands at $6.4 million and is expected to decline to $2.7 million in FY 2011. Without any expected replenishment from General Fund surpluses over the next few years, the ability to sustain $9-$10 million of annual General Fund infrastructure work is unlikely. New revenues or a reallocation of expenses will be necessary. RESOURCE IMPACT Adoption of the attached ordinance will allow for adjustments to the Fiscal Year 2010 budget, along with amendments to the Table of Organization, and General Fund CIP projects. With the approval of this ordinance, the projected ending balance of the General Fund Budget Stabilization Reserve is $23.9 million. There is a reduction of $852,916 to the BSR balance. This results in a BSR level of 16 percent of budgeted expenditures. The Capital Fund Infrastructure Reserve is projected to end with a balance of $9.0 million, an increase of $2.6 million. The projected ending Rate Stabilization Reserve total for all Enterprise funds increases by $455,000. POLICY IMPLICATIONS These recommendations are consistent with existing City policies. ENVIRONMENTAL ASSESSMENT This is not a project under Section 21065 for purposes of the California Environmental Quality Act (CEQA). ATTACHMENTS Attachment 1: Budget Amendment Ordinance with the following exhibits: Exhibit A Fund Summaries and detail changes to the General Fund, Enterprise Funds, CMR:150:10 Page 12 of 14 Exhibit B Exhibit C Special Revenue Funds, Internal Service Funds, and. Capital Improvement Fund Fiscal Year 2010 Midyear CEP Adjustments Amendments to the Fiscal Year 2010 Table of Organization Attachment 2: General Fund Capital Improvement Program Expenditures Summarized by Project Category -Five Years Exhibit A: General Fund Capital Improvement Program Project Expenditures -Five Years Attachment 3: Fiscal Year 2010 Midyear Capital Improvement Program Projects Status Attachment 4: Continuous Capital Projects -Five Years of Expenditures Attachment 5: General Fund Transfers to Infrastructure Reserve -Ten Years Attachment 6: Resolution of the Council of the City of Palo Alto Amending the FY 2006-2009 Compensation Plan for Classified Personnel (SEIU) Adopted by Resolution No. 8658 to Add One New. Classification, Change the Compensation for One Existing SEIU Classification and Change the Title of One Classification Exhibit A: Fiscal Year 2010 Compensation Plan Changes for Service Employees International Union Attachment 7: Police and Fire Departments Overtime Analysis for Fiscal Years 2005 through 2009 with Fiscal Year 2010 Data Through January 30, 2010. Attachment 8: Summary of California State Municipal Finance Officers (CSMFO) Group List Budget Gap Survey CMR:150:10 Page 13 of 14 PREPARED BY: DEPARTMENT HEAD APPROVAL: CITY MANAGER APPROVAL: , ZAZ. '4/ DALE WONG Senior Financial Anal LALO P Director, Administr, tive Services CMR:150:10 Page 14 of 14 Attachment 1 ORDINANCE NO. ORDINANCE OF THE COUNCIL OF THE CITY OF PALO ALTO AMENDING THE BUDGET FOR THE FISCAL YEAR 2010 TO ADJUST BUDGETED REVENUES AND EXPENDITURES IN ACCORDANCE WITH THE RECOMMENDATIONS IN THE MIDYEAR REPORT The City Council of the City of Palo Alto does ordain as follows: SECTION 1. The City 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, the Council on June 15, 2009 did adopt a budget for fiscal year 2010, including a Table of Organization describing the staffing for each department; and B. After reviewing the current budgeted revenues and expenditures for fiscal year 2010, adjustments to the budget are recommended to more accurately reflect year-end projections; and C, Various staffing adjustments require an amendment to the Table of Organization including one classification title change as reflected in Exhibit "C"; the addition of 1.0 Full Time Equivalent (FTE) Cathodic Protection Technician Assistant and drop of 1.0 FTE Water Systems Operator II in the Utilities Department; and the addition of 1.0 FTE Gas Systems Technician II and drop of 1.0 FTE Utility Field Service Representative in the Utilities Department. D. City Council authorization is needed to amend the fiscal year 2010 budget as hereinafter set forth. SECTION 2. The General Fund Budget Stabilization Reserve is hereby decreased by the sum of Eight Hundred Fifty -Two Thousand Nine Hundred Sixteen Dollars ($852,916), as described in Exhibit "A." As a result of this change, the Budget Stabilization Reserve will decrease to $23,943,084. SECTION 3. The Equity Transfer Stabilization Reserve in the General Fund is hereby decreased by the sum of Three Million Six Hundred Thirty -Five Thousand Eight Hundred Sixty Dollars ($3,635,860), as described in Exhibit "A." As a result of this change, the Equity Transfer Stabilization Reserve will be eliminated and returned to the Electric and Gas Funds. SECTION 4. The Capital Fund Infrastructure Reserve is hereby increased by the sum of Two Million Five Hundred Ninety Four Thousand Four Hundred Twenty -One Dollars ($2,594,421), as described in Exhibit "A." As a result of this change, the Page 1 of 3 Infrastructure Reserve will increase from $6,398,758 to $8,993,179. SECTION 5. The Supply Rate Stabilization Reserve in the Electric Fund is hereby increased by the sum of One Million Three Hundred Sixty -Three Thousand Four Hundred Nine Dollars ($1,363,409) as described in Exhibit A. SECTION 6. The Distribution Rate Stabilization Reserve in the Electric Fund is hereby increased by the sum of Nine Hundred One Thousand Three Hundred Thirty -Three Dollars ($901,333) as described in Exhibit A. SECTION 7. The Public Benefits Reserve in the Electric Fund is hereby decreased by the sum of Five Hundred Thousand Dollars ($500,000) as described in Exhibit A. SECTION 8. The Calaveras Reserve in the Electric Fund is hereby decreased by the sum of Two Million Dollars ($2,000,000) as described in Exhibit A. SECTION 9. The Rate Stabilization Reserve in the Fiber Optics Fund is hereby decreased by the sum of Fifty Thousand Dollars ($50,000) as described in Exhibit A. SECTION 10. The Supply Rate Stabilization Reserve in the Gas Fund is hereby increased by the sum of Four Hundred Fifty - Four Thousand Four Hundred Three Dollars ($454,403) as described in Exhibit A. SECTION 11. The Distribution Rate Stabilization Reserve in the Gas Fund is hereby increased by the sum of Four Hundred Forty -One Thousand One Hundred Eight Dollars ($441,108) as described in Exhibit A. SECTION 12. The Rate Stabilization Reserve in the Water Fund is hereby decreased by the sum of One Hundred Seventy Thousand Seven Hundred Eighty -Six Dollars ($170,786) as described in Exhibit A. SECTION 13. The Rate Stabilization Reserve in the Wastewater Collection Fund is hereby increased by the sum of Fifteen Thousand Six Hundred Eighty Dollars ($15,680) as described in Exhibit A. SECTION 14. Adjustments to other funds are made as shown in Exhibit A. These changes impact Special Revenue, Internal Service, and other Funds Reserves as indicated in Exhibit A. SECTION 15. Adjustments to decrease or increase amounts allocated to various Capital Improvement Projects are made as shown in Exhibit B. These changes impact the General Fund Budget Stabilization Reserve and the Infrastructure Reserve and are reflected in the adjustments as shown in Exhibit A. Page 2 of 3 SECTION 16. The Table of Organization is hereby amended to reflect the changes shown in Exhibit C, which is attached hereto and incorporated herein by reference. These changes impact Reserves and are accounted for in the changes shown in Exhibit A. SECTION 17. As specified in Section 2.28.080 of the Palo Alto Municipal. Code, a two-thirds vote of the City Council is required to adopt this ordinance. SECTION 18. The Council of the City of Palo Alto hereby finds that this midyear adjustment is not a project under Section 21065 of the California Environmental Quality Act and, therefore, no environmental impact assessment is necessary. Capital improvement projects described in this ordinance will be assessed individually as appropriate. INTRODUCED: PASSED: AYES: NOES: ABSENT: ABSTENTIONS: ATTEST: City Clerk Mayor APPROVED AS TO FORM: APPROVED: Sr. Asst. City Attorney City Manager Director of Admin. Services Page 3 of 3 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR FINANCIAL REPORT GENERAL FUND (in thousands of dollars) Categories.: Adopted Budget. BUDGET Adjusted Budget . . . ,. Midyear:. Budget -- Midyear Changes.. Revenues & Other Sources 19,650 19,650 25,752 25,752 7,000 7,000 11,250 11,250 5,633 5,633 20,238 20,238 5,056 5,056 1,900 1,900 13,655 13,655 92 92 10,643 10,643 1,605 1,605 313. 25,778 ,,,,.:',0,0$9' 11,417:: 5,584'; 19,017: 4,511.-_ 1,662'; 13,606:: 324: 10,575; ;°': , #:1,740' (2,337) 26 (361) 167 (49) (1,221) (545) (238) (49) 232 (68) 135 Sales Tax Property Tax Transient Occupancy Tax Utility Users Tax Other Taxes and Fines Charges for Services Permits & Licenses Return on Investment Rental Income From Other Agencies Charges To Other Funds Other Revenues Total Revenues . .. _ ... : :122,474:- 12474. :'1:18,166:1 :....(4,3.08) Operating Transfers -In 19,664 19,664 Encumbrances and Reappropriation 5,924 From Infrastructure Reserve .19,664 5,924' 3,243,` 3,243 :Total_Source"s of Funds_. . „-142,138._:..148,062 146,997 (1,065) Expenditures & Other Uses 2,569 3,343 999 1,107 1,512 1,524 296 309 2,395 2,664 6,761 6,907 21,876 22,535 25,166 25,534 2,837 2,955 6,385 6,669 9,858 10,492 29,998 30,207 13,484 14,040 6,925 8,699 - ; 3,298: :x1,096 1,519 - 309;; := 2,631 ! ;_6,359 ;:':;::.22,348_: -•26,621= 2,906 .6,649 10,31x';: ;' -':. 0,219 :13,9821; ':_:';':;;:_9;822: (45) (11) (5) (33) (48) (187) 1,087 (49) (20) (175) 12 (58) 1,123 City Attorney City Auditor City Clerk City Council City Manager Administrative Services Community Services Fire Human Resources Library Planning and Community Environment Police Public Works Non -Departmental 'i:otai Expenditures . r _. . . . . ; , . 1:31,061:..; _1.36,985 - . ,138,576::: '1:,591. Operating Transfers -Out 11,028 11,028 14,565; 3,537 .Tataf Uses -of Funds ',4? -;,; ,2,g-, 142,089 4;7_,'148,013 '153,141._ . .-- 5,128. Net,Surplus-.(1 eflclt) ; ;, , . ' ,:.- .. ....7;1:7g.;. ?, 9 ;-s ;:;49 :.;(6,'144) >.::.(6193) - 3,636 1,704 Adjust intra-fund reserve transfer - Transfer from Equity Tsf Stabilization Resv - Year end savings from hiring freeze 3,636 , '1,704'. Net To. (From ':Reserves,. _. .. : - 49. :... 49 ,.. ::: (804) ',,,,.-(403) Beginning Reserves 22,176 24,747 24,747: - ` ,($53) _Prolected Ending lip, servas ,. x 22,225;_; 24;79.6 ,. .- 3•,943; _- BSR % of Total Use of Funds 16% 17% 16% Adopted Budget was approved by Council on June 15, 2009 Adjusted Budget includes encumbrance carryforwards and budget amendments Midyear Budget to be submitted for Council approval on April 5, 2010 <AcrLAL$ Pre Encumbr (as ofar 2s Encumbr ra) Actual %of . ., . Midyear Budget-. - - 9,200 53% - - 14,152 55% - - 2,912 44% - - 6,554 57% - - 2,946 53% - - 8,405 44% - - 2,364 52% - - 844 51% - - 7,993 59% - - 161 50% - - 6,315 60% - 1,157 66% •-63,003 5°ln - - 11,711 60% .:. . . . . : . .:7014:1: 1'_;-:-:':•54% 50 567 1,476 63% 18 135 551 64% 6 15 896 60% - 31 148 58% 6 55 1,282 51% - 140 3,687 56% 62 1,970 11,934 62% 73 . 584 14,753 58% 13 80 1,519 55% 512 53 3,461 61% 163 907 5,365 62% - 547 16,291 56% 296 971 7,609 63% - - 3,866 39% �_ - 1,199! i 6,0$5, 72,838, i. `- ._. 58% - - 6,380 44% 'j-,, 1,199. _. ; 6,055 _79f218 7.-'7.:M.56% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY ELECTRIC FUND (fn thousands of dollars) Adopted [ Adjusted Midyear Budget I Budget Budget Midyear Changes Sources of Funds _ 113,765' :»_� u5 024 ?14,570: _`-10;9:00.= - - 3,415 - Net Sales 113,765 113,765 Interest Income 5,024 5,024 Other Income 11,155 11,155 Reapprop/Encumbrances - 10,900 Total Sources _ ': ... ,.129,944`; :140;844 144,259 '; -3;415.: Uses of Funds 77759. .11,574" =; 5;738= 825= `` - ._; 9- 7,801': "::3712; :7, 298= w... 7,859; - (5) 320 - - 2,405 - (33) - Utility Purchases 77,697 77,759 Salaries & Benefits 11,343 11,579 Contract Services 4,274 5,418 Supplies and Materials 776 825 Faciiity and Equipment Purchases 99 99 General Expenses 3,592 5,396 Rent and Leases 3,761 3,712 Allocated Charges 7,331 7,331 Debt Service 7,859 7,859 Subtotal :.,.. . . : .-116,732 =< 1;19;978 f,142'2;6$5?; ,` ,..,,,22;60T1 Equity Transfer 11,120 11,120 Operating Transfers Out 692 785 Capital Improvement Program 8,535 17,873 r1�1;1.20 . 785' >=: = 18,,836`; - - 963 Total Uses5k...:...;_ - ..137,079 ;` 149,756. 1.53,406.. ..3,650 Net,To(Frorn) Reserves . ..---- _ -. .. ;(7,'1.35),>, :::(8,912) ,. :(9,147) -' (235) Beginning Reserves 108,923 118,468 . { 1<18 468' - Prbjeeted Ending Reserves 101,788 :: 109 556 _.,109,321 (235 ** Excludes encumbrances and reappropriatlon ACTt)ALS • Pre- Encumbr Encumbr : (as of 01 294Q) % of Actual Midyear Budget - - 69,387 61% - - 2,267 45% - - 4,147 28% - - 0% ;75,801. - -:.;•::.•••:• ,t,57% - 827 42,897 56% - - 5,824 50% 1,539 6,498 1,510 166% 245 671 334 152% - - 5 5% 1 503 1,413 25% - 4 2,146 58% - 2,334 32% - - 4,198 53% ;1,785; ; ' $;503 � __;661i _ e -'.'-_-."•;',.'I;':-:,-. 58%0 - - 6,487 58% - - 396 50% 1,388 5,170 5,931 65% 301.3' 13;676 ..,73,475: ._: ..._., :59% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY FIBER OPTICS FUND (In thousands of dollars) Sources of Funds Net Sales Interest Income Other Income Reapprop/Encumbrances TeterSources: Uses of Funds Salaries & Benefits Contract Services Supplies and Materials General Expenses Rent and Leases Allocated Charges Sub#otap Adopted I Adjusted Budget I Budget Midyear Midyear Budget Changes 2,734 2,734 256 256 607 2,990" :Fi3;597 635 115 18 19 15 363 675 239 18 14 15 363 Operating Transfers Out Capital Improvement Program Total Uses... _. 11 400 13 811 48 3,597:' 50 5o: Net To(Froni)Reserves Beginning Reserves rsrojec"�ed �r1dl.ig. Reserrr`e _:..1,414;: ;1.449 7,314 7,436 _:{50) ** Excludes encumbrances and reapproprlatfon ACTUAL5 Pre- Encumbr Encumbr Actual Midyear Budget (a"safaOi 29.i °loof 1,813 156 66% 61% :'1t969. ;66%0 11 228 4 400 88 5 13 157 59% 113% 0% 36% 113% 43% 1 232 3-- 86%c 120 7 128 54% 30% ** Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY GAS FUND (in thousands of dollars) . -, - 4, ;. BUDGET '" . . .,:. . . _-, ACT1.4t;S _,.,; ' (asor al-zs 10 :- ...> Adopted Adjusted Midyear ":Midyear Pre-' . %of I Budget Budget Budget Changes , Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 44,222 44,222 , „! .x-44,222=. - - 22,915 52% Interest income 1,010 1,010 1,010- - 472 47% Other income 693 693 =: 1,702: 1,009 - 303 18% Reapprop/Encumbrances 12,064 12,064; - - - TofaE_Sources...: , .., -. .., 1. 45,925 .r - , ,_ 57.;989 - I.56.;99_01: .1,009 .,.23;690: i ....,.50%0 Uses of Funds Utility Purchases 26,859 26,891 26,891- - - 10,771 10,105 78% Salaries & Benefits 4,370 4,466 - 4 483r 17 - - 2,192 49% Contract Services 802 1,141 . _ 1,241: 100 100 577 198 71% Supplies and Materials 520 529 ,. . ,.;. _,,..529- - 17 192 101 59% Facility and Equipment Purchases 62 62 .. ::; :•' ,.,_ y62 - - 13 12 40% General Expenses 595 784 704 - - 176 1,076 160% Rent and Leases 326 326 326=*' - - 6 183 58% Allocated Charges 3,316 3,316 3,312 (4) - - 1,141 34% Debt Service 947 947 947: - - - 252 27% Subtotal- . , .: : : } ,:..:.: . ._ r . :: •,: 37,797..::, 38;462 `:' 36,.575^ ....::. .ill: ;:117; :. `_,15,^60 > _._:::_:. 70.%Q Equity Transfer 5,300 5,300 : ` ;i;300,. - - - 3,092 58% Operating Transfers Out 367 407 407 - - - 253 62% Capital Improvement Program 2,389 13,879 13,879: - - 1,255 3,404 34% '17.0.411„140M-,: •: 45,853 .:, .. 58;048 ;T 58,1.611. ,, , : 113 - ... .917 x ,12,990 22,009. . % Net To::(Frain)rReserves ` , ..........................72 :: 4?_:{59) :.....:837,` 898: Beginning Reserves 15,127 15,266 _.:.,=1.5;2t6.6 - PYblec1ed_Ending Rsser.vos :_ __.3.._ ....<:15,199:..,.'x. ,':15°207 :::.116,'103.: . .-:-:.896', '" Excludes encumbrances and reapproprlatlon Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY WATER FUND (In thousands of dollars) i-, . .. , : ,::BUDGET_-, .-. - : .. .,:,. I Adopted : 'Adjusted Midyear Midyear Budget Budget • Budget. Changes : Sources of Funds Net Sales 28,948 28,948 28,948 - Interest Income 1,265 1,265 1,265, - Olher Income 814 814 _ 1,073:; 259 Bond Proceeds 35,000 35,000 35,DODe - Reapprop/Encumbrances 20,111 201.111`_ - Total -Sources." . , .- :-: - .; 66,027 °. .._.86,138 .. .. 86,397. .... - -259' Uses of Funds Utility Purchases 10,354 10,354 ' ,:10,3..0', - Salaries & Benefits 5,411 5,516 5,503- (13) Contract Services 593 671 "' ' = _'f671 : - Supplies and Materials 490 496 < '; 's 496` - Facility and Equipment Purchases - 10 10 ;- _ <:::;10 ` - General Expense 330 330 - - Rents and Leases 2,193 2,193 , - ., 2,.193; - Allocated Charges 2,992 2,992 2,9767 (16) Debt Service 775 775 7751 - Subtotal __ _ - .. . . _ `. .:-23,1,48, _; 23;337 �' :23,308- -"(29) Equity Transfer - - - - Operating Transfers Out 258 282 282. - Capltal Improvement Program 27,414 47,710 a 48,189- 459 Total,Uses :.,. . -:_ .... ._._:0: _..:_50.820Z1__..:_71,329 .._.:•. 71,759: 430 ,;, NetTo_(Fr`om)Reserves. - _,_::15,207, = ,:,1:4;809 :; 14,638. .. `- .(1:71) Beginning Reserves 4,887 7,288 _ T".- - - Projected ding.ReservBs.._.: ; En .,..;20,094..- ..-_ :3. .22;09?- ;1.-::.'gii- 21',92¢ , _.__:_ :(171) .. Excludes encumbrances and reapproprlatlon 4GT_ItALS Pre Encumbr , .. . - (as of'Ot 29 10} -,__ _ .' % of Encumbr Actual Midyear Budget - - 17,012 59% - - 562 44% - - 623 58% ;,- :- - :. 18;197 z.; ....-,27% - 4,172 4,926 88% - - 2,619 47% 9 246 168 63% 88 198 185 95% - 4 1 50% - - 188 57% - 4 1,286 59% - - 1,133 38% - 206 27% :..97_ -::;4;624::- 10',712? .__ o t-,130% - - 184 65% 40 12,530 2,741 32% _ g _7.07 17,154; -�L'13,637-. ._.:_. : ;43°!0 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY WASTEWATER COLLECTION FUND (In thousands of dollars) Sources of Funds Net Sales Interest Income Other Income Reapprop/Encumbrances Total;$0 rces Adopted Budget vaggT Adjusted Midyear Midyear. Budget Budget Changes 14,443 14,443 551 551 994 994 7,122 $,98a - •,23;1"1,0_ Uses of Funds Utility Purchases 7,933 7,933 Salaries & Benefits 1,791 1,822 Contract Services 246 368 Supplies and Materials 228 242 Facility and Equipment Purchases 5 5 General Expenses 59 59 Rent and Leases 210 211 Allocated Charges 1,737 1,737 Debt Service 129 129 Operating Transfers Out Capital Improvement Program 'iotaLU$ 2;338H,.— 12 5nfi] 97 108 3,946 10,925 6,361» 23,534;; Subtotal 12,522= 16 Net To (Froilit) Retertres; =. Beginning Reserves Projected Ending Re ery es _. 5,267_.: _6;57 (393) : 0429) 5,660 7,001 ** Excludes encumbrances and reappropriatlon (445) Ot)1 6) Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY REFUSE FUND (In thousands of dollars) ' I Adopted : Adjusted Budget .. .._.- _BUDGET Midyear Budget • .Budget Midyear Changes Sources of Funds Net Sales 32,415 32,415 w 41;5: - Interest Income 487 487 487 - Other Income 4,181 4,181 >_` ;4,181' - ReapproplEncumbrances 3,021 3,021' Total Sources . .>-'37,083 -40;104 ". .40,104` Uses of Funds Utility Purchases 15,047 . 15,070 15,0.70-.. - Salaries and Benefits 4,586 4,676 ',_ 4,676: - Contract Services 6,931 7,554 =. 7,554' - Supplies and Materials 460 524 , s _ 52 : - Facility and Equipment Purchases 19 22 22 - General Expenses 385 391 391:;: - Rents and Leases 4,310 4,310 4,310:: - Allocated Charges 3,817 3,817 3,817_ - Debt Service 607 607 r 807 - Subtotal _.. 36,162.:-. _'36,971 :;36,971:':' P g Transfers Out 333 354 •Operating T-- 384; - Capital Improvement Program - 2,292 2 292, - Tofal Uses': _,,. _ .,36,495, 39,617 _39,617- = -, Net T o' (From) Reserves.i... . ..: ,- ., ---y:1.-g,5 88 } .. _ 487. .,..... 489._ ; _ . _-. Beginning Reserves (100) (2,194) ' (2 194) - Projected.Enclng'Reserves, .. ,, -. . .- 488 - .. (1,707) 2.? ;..: 1,707) -, •* Excludes encumbrances and reapproprlatlon AC.7UALS, :._:. Pre- Encumbr; Encumbr [as of ia1 za o� Actual % of Midyear Budget 14,936 186 1,407 46% • 38% 34% 6,529. 72 4 25 1,126 24 5,828 39% 2,385 51% 2,925 55% 125 29% 2 14% 582 149% 2,507 58% 2,144 56% 0%P 76' 195 16,49.8= 48% 194 55% 148 15% 16,840; 46%a 1 Exhibit A •CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY STORM DRAINAGE FUND (In thousands of dollars) BUDGET , : -. j Adopted Adjusted Midyear Midyear , I Budget Budget Budget Changes. Sources of Funds Net Sales 5,366 5,366 - Interest Income 217 217 217; - Other Income 68 68 _ ;68: - Reapprop/Encumbrances 2,306 X2,306 - TotalSources x;5,651 :: , .::.7;957 .-7,957 -: -. Uses of Funds Salaries and Benefits 1,034 1,032 , .1,032. - Contract Services 374 575 ;= _;:575;` - Supplies and Materials 99 108 -, 108; - Facility and Equipment Purchases 12 14 -. 14= - General Expenses 148 658 =' 'wBs6:'. - Rents and Leases 6 6 .._ _ ; ; 6 - Allocated Charges 619 619 . ,. 619; - Debt Service 949 949 .= _ =°.949 - Subtotal` :: _..x:: ._ . - ::3,241 .; ..--',3;961T:, -73,961 = . ; Operating Transfers Out 683 688 688 - Capital Improvement Program 1,700 3,417 3,417< - Total Uses • .. ,: ;5,624. ; 8,066. f" -'e,';!0.:13,066, ; _ .. ... _ .:•-. •NiitSurplug:(Oeficit). > : :- , . .: :_ . . > - 27: ::_... ,(i.09) k109) - Loan repayment to the General Fund 674 :-= , 674 - Beginning Reserves 400 (1,098) (1,098) - Projected Ending Reserves.. 427 e: _ 533) t . - (533) 5 **Excludes encumbrances and reapproprlatlon ACTUAL Pre- (as of o1-29.10) _. % of Encumbr Encumbr Actua Midyear Budget 3,207 74 2 60% 34% 3% 3,283 72 20 510 493 262 45 5 13 271 272 48% 58% 60% 36% 79% 0% 44% 29% 510 92 ::x1;36.1:_, 1,017 668 439 • 97% 43% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY WASTEWATER TREATMENT FUND (in thousands of dollars) Sources of Funds Net Sales Interest Income Other Income Reapprop/Encumbrances TotarSottrces Adopted Budget :BUf,1GE7 Adjusted Budget 21,484 423 80 21,484 423 80 26,298 .21,987:: Uses of Funds Salaries and Benefits Contract Services Supplies and Materials Facility and Equipment Purchases General Expenses Rents and Leases Allocated Charges Debt Service Subtota 9,363 9,476 1,978 3,154 1,755 1,943 10 10 251 251 18 4,432 4,432 816 816 20;101) . Operating Transfers Out Capital Improvement Program Total06:64 .'0 153 134 1,700 . 26,612 --;4018.46') 46,846: 48;285',: Net TO1F'rOM)ftesery S Beginning Reserves (4,295) (13,442) ** Excludes encumbrances and reapproprlation ;442) AGTUAL _S Pre= Encurbr S. as of 01 Encumbr Actual 29-90) _ % of Midyear Budget; - - 13,276 62% - - 205 48% - - 263 329% _. 13,744;' . 63% - - 4,865 51% 629 1,123 523 72% 25 317 910 64% - - 8 80% - - 428 171% - - 0% - - 2,284 52% - - - 0% _.s54; 1-;44Q ,;==9,018; - 155% - - 89 66% - 7,547 2,330 37% 654. 8;987, ;111,437_ ,..: ,. _.:45% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj Descri.iion N.N-'E• "TMENT•L 10200000 various 2,460,000 Decline in sales tax 10200000 various `26,000) Improvement in properly tax 10300000 11860 (167,000) Improvement in utility user tax 10200000 11850 361,000 Decline in transient occupancy tax 10200000 11800 (450,000) Improvement In documentary transfer tax 10200000 16010 238,000 Decline in interest earnings 10200000 20410 (3,243,395) To return funding from Capital Prefect Fund 10300000 16030 27,207 Decrease property rental revenue to match budget to actual IGeneraLFunii ReliOnui Changes =i ' .::(800,188) 10300000 10200000 10200000 31990 40520 40530 1,000,000 2,726,895 908,965 Reverse $1 M negative placeholder in non -departmental Return of Equity Transfer Stabilization Reserve to Electric Fund Return of Equity Transfer Stabilization Reserve to Gas Fund Decrease in transfer to Debt Service Fund; reserve in Debt Service is sufficient to make current year payment for Golf Course related debt Adjustment to cover 2.6% CPI adjustment for payment to PAUSD 10200000 40310 (99,000) 10300000 33490 123,369 jNon?Departme►ital.01her-Expenses . 4,660,229, NOVVItittiati:01.41 (CITY ATTORNEY Fr4i11) Ri serves 18030003 18010001 31010 various (46,558) Reduction in outside counsel services Repayment of FY 2009 Technology Fund allocated charges jdtFier Revenue aihd Fa;pertse-;�- ,...- 1,257 Nbt Os-.761FitriiY. Reserves CITY AUDITOR 16020002 16020002 16020002 16020002 16020002 11810 31060 32260 32100 various (123,366) Increase in Alternative Fuel Tax recoveries Reduction in Audit & Financial Reduction in Electrical Reduction in Computer Software Repayment of FY 2009 Technology Fund allocated charges (11,867) (15) (27) 444 IOthet RRvenue antl:Esipense Net4EhangesTo (From) Re;erves .. ..._ ..._. CITY CLERK 12010001 12030006 12010001 31220 33060 various IOther,Reve ue and Expense INKOhen esl (r'rom) Reserves (3,800) Reduction in instruction & Training (2,000) Reduction in Travel & Meeting 745 Repayment of FY 2009 Technology Fund allocated charges CITY MANAGER various various 11030002 11010001 31070 33060 31200 variotis (15,000) (4,038) (15,000) 1,103 Reduction in Program & Project Consultants Reduction in Travel & Meeting Reduction In Advertising and Publication Repayment of FY 2009 Technology Fund allocated charges Mite; Revanue6111UVense' .. _:::r __.__.-.. _..._..__ NO#,Atian-des `o,(i tori1)14esoblea >._:ri Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj Description ADMINISTRATIVE SERVICES various 31050 (5,533) Reduction in Real Estate 40050009 31210 (1,500) Reduction in Contract Agency Personnel various 31220 (6,547) Reduction In Instruction & Training 40040002 31260 (410) Reduction in Facility Maintenance & Security various 31 990 (31,300) Reduction in Other Contract Services 40020002 32010 (2,000) Reduction in Office Supplies various 33060 (7,256) Reduction in Travel & Meeting_s 40010001 various 6,640 Repayment of FY 2009 TechnologyFund allocated charges lOtIrkir Revenue: and l3xpense. (47,906) Net Changes TOAF ohi) Resolves -- COMMUNITY SERVICES various 12220 (1,000) Increase In administrative citation various 12530 9,000 Reduction in Santa Clara County reimbursement various 13220 (2,384) Increase in zone change fee various 13320 (500) Increase in reservation fees various 13420 (17,456) Increase revenues in children registration fees various 13430 38,450 Reduction in adult registration lees various 13440 (15,922) Increase in admission drop in fees various 13450 (16,436) Increase in attendant fees various 13460 60,555 Reduction in special event fees various 13470 4,293 Reduction In seminar fees various 13480 354,569 Reduction in class program fees various 13490 1,082 Reduction in Golf Course tournament league fees ' various 13500 212,808 Reduction in Golf Course green fees various 13510 10,000 Reduction in Golf Course monthly play cards various 13540 (69,173) increase In Golf Course entry fees various 13720 9,793 Reduction in Golf Course cart/club fees various 13760 85,150 Reduction in lee subsidy various 13980 (1,693) Increase in overage/shorlages various 13990 50,201 Reduction in other fees various 15540 27,510 Reduction in community threatre revenues various 15550 16,000 Reduction In outreach revenues various 15570 (4,313) Increase in Wingspread program revenues various 15990 (32,654) Increase In reimbursements from other agency various 16030 (82,250) Increase revenues In Cubberley property rental various 16050 78,616 Reduction in facilities rental revenues various 16060 1,040 Reductlon in locker rental revenues various 16070 (1,927) Increase in equipment rental revenues various 16080 2,518 Reduction in Golf Course Pro Shop lease revenues various 16090 23,389 Reduction in Golf Course restaurant lease revenues various 16110 6,480 Reduction in Golf Course restaurant reimbursement on utilities various 16120 525 Reduction in concession revenues various 17990 9,043 Reduction in other sales various 18010 3,500 Reduction in donations/contributions various 18990 65,134 Reduction in other miscellaneous revenues various 31110 (25,000) Reduction in contract contingency various 31070 (21,569) Reduction in program/project consultants various 31080 (9,305) Reduction in cultural presentation various 31200 (6,545) Reduction in advertisement/publication various 31210 (1,000) Reduciton in contract agency personnel various 31220 (2,000) Reduction in training various 31250 (1,250) Reduction in equipment and maintenance repair various 31990 (31,249) Increase in other contract services various 32010 (2,300) Reduction in office supplies various 32030 (3,279) Reduction In art and photo supplies various 32070 (22,051) Reduction In reacreation and housekeeping supplies various 32130 (1,500) Reduction In uniforms various 32240 (4,000) Reduciton In building material supplies various 33020 (14,750) Reduction in City membership various 33050 (721) Reduction in transportation and drayage various 33060 (1,000) Reduction in travel and meetings various 33470 (4,389) Reduction in board and commission expenses various _ 33480 _ (22,081) Reduction in special event awards Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj ❑escri.tien ;GENERAL FUN, various various various various 80010001 33990 35030 35040 35050 various (57,000) (500) (2,500) (3,450) 10,736 Reduction In other general expenses Reduction in non capital office machine Reduciton in non capital computer Reduction in non capital tools Repayment of FY 2009 Technology Fund allocated charges Other Revenge ahifEateehse . 598,244 80020115 80020115 80020210 80020210 18010 30030 18990 33990 (18,000) 18,000 (1,642) Grant from Art Center Foundation Increase hourly salaries -funded by grant from Art Center Foundation Reimbursement form the Boy Scouts Increase budget • funded by the Boy Scouts Grant from the Santa Clara County Arts Council for the Visual Arts program To expend grant from SC Arts Council To expend grant from SC Arts Council Reimbursements from PAUSD for the in -school residency programs 80020110 80020112 80020113 15280 32030 31990 1,642 (5,546) 2,546 3,000 80020211 80020211 80020210 80020210 15990 31080 15990 31990 (5,000) 5,000 (10,000) 10,000 Instruction costs for the in -school residency program at PAUSD Grant from the the National Endowment for the Arts To expend grant from the the National Endowment for the Arts GraritiReimbursement Revenue and`Expense NetGFfariges T4 Frern) Reserfes .. :x(598;244) :. ,..: FIRE 75030002 75030002 18010 32060 �Gj'antlReimFiursemerit Revert�iQ antl'Ezpense ,,= - (2,500) 2,500 Training expense donation Training expense associated with donation 70030008 30030 20,000 Increase In temporary salaries various various various various 75010001 75010001 75010001 75010001 various various various various 14550 15990 12670 (36,460) (12,965) (12,185) (30,926) 15,000 41,353 Reduction in contract expense Reduction in tools, equipment, and supplies Reduction in travel, meeting, and membership Reduction In office equipment Reduction in Fire permit revenue Department of Homeland Security grant that is no longer received Reduction in reimbursement from Stanford Repayment of FY 2009 Technology Fund allocated charges 200,000 various 1,156,713 Quiet' Re+veriue and Expense ` . , . Net Chile es`To.(From):Reserves .,- - -; HUMAN RESOURCES 13040003 13040002 13010001 33480 31070 various (5,730) (44, 970) 1,832 Cancel annual Employee Recognition Picnic Cancel non -mandatory employee training Repayment of FY 2009 Technology Fund allocated charges Oth er Revenue and Expense:.u... µ :: 148,868) . lJet;Changes�'Tu.(Fj`ijm) Reserves_.. :.: Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj Descri.tion Salary feliated Revenue arfd'-Experise-v IOthe Reven1ueand'Expert§e 76;000 various 31220 (1,550) Reduction in training various various various various various various various various various various various 31990 32010 32210 32220 32230 32280 33020 33040 33060 33470 34030 various (9,224) Reduction in Other contract services Reduction in office supplies Reduction in microfilm Reduction In serial purchases Reduction in book purchases Reduction in electronic resources Reduction in city membership Reduction telephone - none city utilities Reduction in travel and meetings Reduction in board and commissions Reduction in rent - office machine and equipment Repayment of FY 2009 Technology Fund allocated charges (11,800) (4,885) (14,500) (30,599) (44,679) 84010001 (1,230) (400) (4,500) (50) (1,590) 5,831 (119;086) 84010001 84030001 15300 32230 (22,840) 22,840 CA Public Library Fund grant Increase In arts and photo Grrant/Relmbursement Reverlu'e and Expense Net Changes'To (Frog 1) Rese►ves .43;086`, PLANNING AND COMMUNITY ENVIRONMENT 60020404 60020402 60030001 60020501 60030001 60020406 60020405 60020405 60020502. 13230 13290 13370 14500 14570 14700 14890 31020 31040 31070 31200 31220 31250 31260 31990 32010 32100 33020 33050 33060 33470 33490 33990 35040 various 40,000 40,000 Reduction In Zoning Plan Check revenues. Reduction in Architectural Review Board revenues. Reduction in Plan Checking revenues. Reduction in Valet Parking revenues. Reduction in Building New Construction revenues. Reduction in Green Building revenues. Reduction in Other Permit revenues. Reduction in Planning 200,000 43,500 400,000 15,000 80,000 (4,500) various 60020406 various 60020208 60030001 various (10,000) Reduction In Engineering (14,573) (4,999) (7,916) (987) (155) (102,445) Reduction In Program & Project Consultants Reduction in Advertising & Publishing Reduction in Instruction & Training Reduction in Equipment Maintenance & Repair Reduction in Facility Maintenance & Security Reduction in Other Contract Services Reduction in Office Supplies Reduction in Computer Software Reduction In City Membership Reduction in Transportation and Drayage Reduction in Travel & Meetings Reduction in Boards & Commissions Reduction in Inter -Agency Reduction in Other General Expense Reduction in Non -Capital Computer Equipment Repayment of FY 2009 Technology Fund allocated charges 60020101 60020208 60020101 60020101 60060002 60020103 60020201 60020504 60020208 60010001 (13,000) (5,410) (6,800), (364) (1,606) (3,000) (3,783) (110) (810) 5,828 Otfie? Revenuoand Expensf 43;87Q:::: Ndk=Changes To (Frog i) 1leset;vee _(643;870)' Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj Descri.tian • . LICE 70020002 18010 (55,000) Train Track Watch donations 70020002 33490 55,000 Expense associated with Train Track Watch security 70020002 15990 (10,521) Bulletproof Vest Partnership 2009 reimbursement 70020002 32130 10,521 Expense associated with Bulletproof Vest reimbursement 70050002 15370 (46,465) Office of Traffic Safety (OTS) STEP grant 70050002 various 46,465 Overtime and other non -salary epxense associated with OTS STEP grant 70050002 15370 (27,997) OTS Click it or Ticket grant 70050002 30040 27,997 Overtime expense associated with Click it or Ticket grant 70060004 15370 (8,623) POST reimbursement for Police management retreat 70060004 31220 8,623 Reimburseable expense associated with Police management retreat 70040002 15990 (160,000) NCRIC reimbursement GrantfRelmbursement:Revenue and Expense:.- . L1,:-•-•-•.-,• (160;000) 70020002 70050002 70080002 70060002 70010001 70080002 33490 31990 31260 31990 30010 12030 (120,000) (44,000) 4,680 8,400 (8,400) Reduction in booking fees expense Reduction in unused crossing guard funds Private security cost associated with 1 -day SEIU labor action Cost associated with Police Chief recruitment Police Chief salary savings used for recruitment Parking violation revenue decline Adjustment to dispatch and alarm service monitoring provided to Utilities Repayment of FY 2009 Technology Fund allocated charges 500,000 70030003 70030001 various various (14,624) 22,579 QuietFroverit antiExpense 348,635% NriCCltringes lTo: From ReseCfres 188,635 50020305 50020305 15370 31070 (120,000) Urban Forestry Inventory Grant from Cal Fire 130,000 Urban Forestry Inventory Grant Program Grant/Reimi ursement Revenue grill Expense lot,hel'13evertiie ant(;Expens 10;OU0 various various various 5,700 Net decrease in other revenue Decrease in revenue from plan checking fee Increase in revenue from street cut fees- external Decrease in revenue from permit fees 50040006 50040007 13370 13750 102,500 (150,000) various various various various 50030004 50010001 various various 31200-31990 32290-32990 33020-33060 31990 various 56,500 83,000 (119,747) (75,500) (4,000) 4,000 6,987 Decrease in revenue from interdepartmental reimbursements Reduction in contract service expense Reduction in supplies and materials expense Reduction in general expense Increase In contract services for installation of Council Conference Room card reader Repayment of FY 2009 Technology Fund allocated charges r�(90560) Net)C anges To (Frorn).Reserves ...: Fund;Barbetcirig Etaries- ':'s;,`:; 10200000 10200000 various 38220 38310 various (852, 916) (3,635,860) (1,704,000) Projected Year End Salary and Benefit savings 6,192 776 Budget Stabilization Reserve Equity Transfer Stabilization Reserve Total General Fund Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm Item FY 2010 Midyear Adj Descry • tion INT RNAL;SERVICE FUNI Revenue Technology Fund 40070001 19440 40070102 40070103 40070202 40070203 40070302 40070303 19370 19380 19420 19430 19510 19520 Net !SF Revenue Adlustrients (822,127} (91,464) (50,652) (21,547) (24,433) (93,188) (117,283) Expenditures INet ISF,Ekpendlture Adjusaneme -'-. Repayment from the General Fund - Year 1 of FY2009 allocated charges Repayment from the General Fund - Year 1 Repayment from the General Fund - Year 1 of FY2009 allocated charges Repayment from the General Fund - Year 1 of FY2009 allocated charges Repayment from the General Fund - Year 1 of FY2009 allocated charges Repayment from the General Fund - Year 1 Repayment from the General Fund - Year 1 of FY2009 allocated charges of FY2009 allocated charges of FY2009 allocated charges Net)nternal:Service Fund Adjustments 2'20;694 .. SPECIAL REVENUE F Revenue Law Enforcement Special Assessment District (Agency Fund) Gas Tax Fund Development Impact Fees Fund - Parks Debt Service Fund 70248003 15370 (100,000) 2010 COPS allocation 77500000 20410 (383,406) To return funding from Capital Project Fund re PE -95030 (Lot SIL Garage) 23100000 80210001 20410 20410 (50,000) (249,098) To return funding from Capital Project Fund for CEP Project PL -00026 (Safe Routes to School and Parks) To return funding from Capital Project Fund for PE -07007 (Cubberley Turf Renovation) 35400000 20110 99,000 Decrease in transfer from General Fund; reserve In Debt Service is sufficient to make current year payment for Golf Course related debt fetSpectal:Rene»ue. Retieiue`Adjtistlittsnts :,- _...r ,_ (683;504) , Expenditures Local Law Enforcement I 70248003 I 35070 50,000 fNetSpeelal;gevenGe ExptmditureAdjustmetits= 5D;ODos 2010 COPS allocation equipment purchases Nat•SpectahRa4eriue'Fund=Adjdstmeifs . .. _� � - _ ;;.. _.. _ _.; :733;504;: . _-�.. _, - ': General Fund Details - 1 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Comm FY 2010 Center Item Midyear AdJ Descr€ tion Revenue 50471020 70471001 50471011 18100 15990 15060 (20,526) (50,000), (209,000) To receive funding by the Friends of Lytton Plaza, LLC for the Lytton Plaza CIP Project (PE•08004) To receive revenueu from COPS grant To recognize ARRA funding for Street Maintenance CIP protect NeVCtP`ReventY AditisttfientC =(279;528) Expenditures 50471004 50471004 50471004 50471005 50471007 50471010 50471010 50471010 40110 38790 39300 38790 38790 38790 40110 40270 254,069 (281,569) 27,500 9,722 2,127 (4,775,350) 2,700,000 383,406 To reduce funding and return balance to the General Fund (PO-05054/Street Lights) To reduce funding and return balance to the General Fund (P0-05054/Street Lights) To reimburse Electric for services done on City's street lights To provide additional appropriations to cover costs and closed project To provide additional appropriations to cover costs and closed protect To reduce funding of various projects and return funding to reserve To reduce funding for CIP PO -98020 (Police Building) and return to the General Fund Budget Stablllization Reserve (BSR) To close CIP Project PE -95030 and return balance to Special Assessment District (Fund 775) To close CIP Project PE -and return baalance to Electric Fund Distribution fund (Fund 523) To provide additional appropriation to various CIP projects To provide additional appropriation to various CIP protects To reduce funding of various projects and return funding to reserve To reduce funding and return balance to the Development Impact Fees Fund - Parks 50471010 50471011 50471014 50471020 50471020 40510 38790 38790 38790 40160 125,393 207,149 250,000 (604,974) 249,098 50471020 40510 259,266 (50,000) 50,000 To close CIP Projects and return balance to Electric Fund Distribution fund (Fund 523) 60471002 60471002 60471005 60471006 60471006 60471006 70471001 70471001 75471001 75471001 80471006 80471008 80471009 80471009 84471000 38790 40110 38790 38790 40110 40210 38790 40110 38790 40110 38790 38790 38790 40110 38790 (150,000) (887,380) 182,039 50,000 13,973 6,027 (4,095) 4,095 To partially return appropriation to IR To partially return appropriation to GF To partially return appropriation to IR , To partially return appropriation to GF and IR To part€ally return appropriation 10 GF To partially return appropriation to Gas Tax Fund To incease appropriation To close protect and return appropriation to GF To close project and return appropriation to GF To close project and return appropriation to GF (209,864)LTo close project and return appropriation to IR (1,718) (170,814) 47,165 (160) To close project and return appropriation to IR To partially return appropriation to GF To partially return appropriation to GF To close project and return appropriation to IR Net;CPiExpemliture,-AilJtistriienti Net cIP Adjustor is ,9 From) Reserves':: • as' General Fund Details - 2 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Comm. FY 2010 Center Item Midyear Adj Description Electric Fund ISoriyce Chanle IUseChangeS: . 20000030 20110 (1,363,447) Return of General Fund Equity Transfer Stabilization Reserve, which is no longer needed under the new equity transfer methodology 20000020 20110 (1,363,448), Return of General Fund Equity Transfer Stabilization Reserve, which is no longer needed undepthe new equity transfer methodology 20020401 15060 (463,000) Increase in funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20030202 15060 (100,000) Increase In funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20000020 20410 (125,393), Return excess funding of GF CEP Project PE -05001 (Photovoltaic Design) -, ' (3,415i288 -,,, 20030202 33100 500,000 Increase in expense to pay for electric efficiency rebates 20020401 38790 463,000 To add appropriation for LED streetliglit project (EL -10009); funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20030202 31070 100,000 Increase in program and protect consultants for home energy report; funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20040105 31070 200,000 Increase in program and project consultants for administration fees for the Electric Efficiency Financing Program for businesses funded by Calaveras-Reserves over four years - approved by Council CMR 430:09 20040105 33115 1,800,000 Increase In expense for electric efficiency Incentives; Electric Efficiency Financing Program for businesses funded by Calaveras Reserves over four years - approved by Council CMR 430:09 20020202 38790 500,000 To moved planned appropriation from FY 2011 to FY 2010 for E. Meadow/Alma/Loma Verde 4 kV to 12 kV conversion project (EL -08002) 20030205 31990 20,000 Increase appropriation for Public Benefits other contract servcles 20030205 33990 2,000 Increase appropriation for Public Benefits - other expenses 20030205 33100 103,393 Increase appropriation for Public Benefits - Incentives 20020202 39220 (18,750) Decrease interdepartmental charges from Public Works Dept. for engineering and inspection services 20020105 39250 (15,000) Decrease interdepartmental charges from Public Works Dept. for electric line clearing services 20020103 30010 (4,530) Drop 0.24 FTE Water System Operator II various 39090 433 Adjustment to dispatch and alarm service monitoring provided by Police ,, , ..,.,%: .:: 3,850546 '; IE�e1�Chango��;Ta (�ei;,iZ) lles�r:�es 35858}. Fund Balanc ng E=ntries , , : :: ITotat.,Electric:.F 20000020 38160 (500,000) Electric Public Benefits Reserve 20000020 38040 901,333 Electric Distribution Rate Stabilization Reserve 20000030 38080 (2,000,000) Electric Supply Calaveras Reserve 20000030 38170 1,363,409 Electric Supply Rate Stabilization Reserve . =(235,258) '.: .N. . Enterprise Fund Details -1 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm. Item FY 2010 Midyear Adj Description Fiber Optics Fund [Source char ges �,Y: -= ruse Changes 20021312 31990 50,000 Increase in other contract services; to provide telecommunications engineering evaluation and system design services. These services are necessary to assist the City in preparing a business plan for its fiber optics operations , e `Changes:To'(From) Reserves , _ -c (5D 000) Furil B,eleneing �IttCEas_ 1 20000080 1 38040 ITotal Fiber Optfcs:Fund (50,000)IFiber Optics Rate Stabilization Reserve =:(50,0.00 Gas Fund 20000050 20110 (454,483) Return of General Fund Equity Transfer Stabilization Reserve, which is no longer needed under the new equity transfer methodology 20000040 20110 (454,482) Return of General Fund Equity Transfer Stabilization Reserve, which is no longer needed under the new equity transfer methodology 20030402 15060 (100,000) Increase in funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20030402 31070 100,000 Increase in program and project consultants for home energy report; funding from Energy Efficiency Community Block Grant- 2009 Stimulus 20020802 39220 (11,250) Decrease interdepartmental charges from Public Works Dept. for engineering and Inspection services 20020703 30010 (7,173) Drop 0.38 FTE Water System Operator 11 various 30010 . 18,491 Add 1.0 FTE Assistant Cathodic Protection Technician various 30010 (10,178) Drop 0.57 FTE Utility Field Services Rep various 30010 . 15,032 Add 0.9 FTE Gas Systems Tech II various 30010 628 Compensation adjustment for 1.0 FTE Cathodic Tech various 39090 7,904 Adjustment to dispatch and alarm service monitoring provided by Police 1uS@..changes: MF `�:,-. ... .. ... . . .7L_ 1i3,45C .. ._ ... .r , s .. ... .. .. .,.. ,,r FOTO.13alarl.Qing Etitcl.W.., 20000050 20000040 38170 38040 454,403 441,108 ITotai Gas Gas Supply Rate Stabilization Reserve Gas Distribution Rate Stabilization Reserve Enterprise Fund Details -2 Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Cost Center Comm. Item FY 2010 Midyear Adj Description 'ERPF{I�SE Water Fund 20000060 20410 (259,266) Return excess funding of GF CIP Project PE -07007 (Cubberley Turf Renovation ) funded by emergency Water CIP ISource Changes . -- . . _ .-:.... ? :, j,--. (259,266 :?......, 20021002 38790 259,266 To provide additional appropriations to CIP Project WS -08002 (Emergency Water Supply) 20021002 38790 200,000 To provide additional appropriations for street cut fees for CIP Project WS -08017 (Water Main Replacement Project 22) 20021002 39220 (11,250)! Decrease interdepartmental charges from Public Works Dept. for engineering and inspection services 20021002 39260 (8,000) Decrease interdepartmental charges from Public Works Dept. for surveying services 20020904 30010 (7,173) Drop 0.38 FTE Water System Operator II various 30010 (7,678) Drop 0.43 FTE Utility Field Services Rep 20020101 30010 1,670 Add 0.1 FTE Gas Systems Tech 11 20000061 39090 3,217 Adjustment to dispatch and alarm service monitoring provided by Police . .:.:i. _- ._.. -,. . .. 430,052.-...=-.. ... ': ' i .. ::>° Net;Changes-To (From) Reserves ;.' Fundi3alancing hritt•fes I 20000060 I 38040 I (170,786)IWater Rate Stabilization Reserve Wastewater Collection Fund LUee;Chartge : 20021202 39220 (18,750) Decrease interdepartmental charges from Public Works Dept. for engineering and inspection services 20000071 39090 3,070 Adjustment to.dispatch and alarm service monitoring provided by Police _(15,680) . -__-,.,1:,,,÷ r Net phange5 To Fr6Cn Fur5dC13elQneing Eritrie:§ 1 20000070 1 38040 ! 15,680 !Wastewater Collection Rate Stabilization Reserve ITotalWasfewater Collection€Fund Enterprise Fund Details - 3 Exhibit 8 FY 2010 CIP Mid -Year Adjustments - " a - _ - S ai ,1 -`` x Mile -- 5z : a ., Prof ecP = Num r i t - Ff9yei s r �... a;y u ' j - r Ex o K- : Ne a Funding' ,:. _ - b`51UyiC9 .. _- a x 4'omm91f4.-,-. .: 'APITAL PROJECT FUND ADD)TIQNAI:'AppROPRIATIOhNS,__ Crime Scene Evidence Collection Vehicle PD -08000 $ 50,000.00 $ 20,000.00 COPS To provide additional appropriation Lytton Plaza Renovation PE'B004 $ 20,525.72 $ 20,025.72 Friandeof Lytton Plaza To provide additional appropriation Floe Apparatus Equipment FO -09001 $ 5,455.00 FD.05000 To rovide additional appropriation's. p sever remaining eigieMtureaand to close project. Funding will coma from a transfer from CiP Proejcl FD -05000 (Sixteen ALS MorrtorslDefOr5latora) Skeet Maintenance PE -88070 $ - 248,149.00 Stela Prop. 42 To provide addabrtei appropriation Funding were received in FY 2009- Street Maintenance PE -86070 $ 209,000.00 $ 209,000.00 ARRA To provide additional appropriation Thermoplastic Marking and Striping P0.11001 $ 250,000.00 PE -88070 To provide Initial appropdation for the new Prolecl. Highway 101 Overerossing PE -11011 $ 100,000.00 PL -11000 Transfer to CIP Project PE-11011(1lghway 101 Ouereroesirg), The Public Works Department assumed marragem0N of this project from the Flaming and Environmental Deperimenl- Ctbbedey Wing I Elevator Upgrade PE -07001 $ 2,127.00 lrtrosI clue Reserve Toprovkla additional appropriation to cover remaining expenditures and 10 close project. Al Center Kiln Hood Replacement PE -08000 $ 0,722.00 Infrastructure Reserve To provide addtbnal appropriation to cover remaining expenditures and to dose project. ,TOtal r $ 279,525.72 $ 864,988.72 :RRDllCTIOfy:II)1 APPROPRIATIONSIYO.CLOSE - Lbrary Automated Service LB -94018 $ (180.00) IMmt:boaters, Reserve To close protect and returnbalarcs to reserve Jaws for GM Hurst FD -09002 $ (4,095.00) General Fund To close project and return balance to reserve Fool Mb Park Maintenance 0547003 $ (1,718.00) Irtrastnchre Reserve To close project and return balance to reserve Ponce Records Management System PD -89013 $ (6,027.00) General Fund To close protect and return balance to reserve Emcee dere Read Median Improvements P060105 $ (2,973,00) Infras ruoltxe Reserve To close project and return balance lo reserve College Terrace Park PE -00110 $ (980.00) Infrastructure Reserve To close project and return balance to reserve El Camino Median Lane Improvements PE -01013 $ (512601 Infrastructure Reserve To close protect and return balance to reserve Mitchell Park LA mry Improvements PE -04012 $ (254,743.00) Infrastructure Reserve To dose project and return balance lo reserve. There is a new CIP project for Mlddnall Park Mel is funded by Measure N Lbroiy bonds Photovoltaic Design PE -05001 $ (125,393.50) Federal GranuEledrio Fad To close project and return balance to reserve Amstradero Preserve PE -05300 $ (844.00) Infra§lruclue Reserve To dose project and return balance to reserve Ctrbbndey Tun! Renovation PE -07007 $ (508,384.00) Irtraskuo ire Reserve/Water Fund OP Project WS -08002 Tocbse prof act and return balance to reserve Baydands Alhielic Center PE -07009 $ (38,404,00) I04raslruc ire Reserve To close project and return balance to reserve Vetch Harbor Improvements PE -89004 $ (12,167.00) Infrastructure Reserve To dose project and return balance to reserve Mitchell Park Facilities PE -86003 PG -08901 PL -07001 $ (75,084.00) Irtrastn1Mue Reserve To cbse,project and return balance to reserve Golf Course Driving Range $ (47,165.00) General Fund To close project and return balance to reserve Irdermodal Transit $ (837,380.00) General Furndrlrfrasirticttre Reserve To close project and return balance to reserve College Terrace Library PE -05010 $ (1,400,000.00) Infrastructure Reserve To redtxe apropdatbn due to savings generated as a resNl of lowerbid price on ooistrttdion and return the balance to reserve. Police Building Project PE -98020 $ (2,700,00000) General Ford to To reduce apptopdatlon due to change in project scope and return the bah ntce reserve. Terris and Basketban Court PG -08001 $ (123,649.00) Iniraslntclue Reserve to To reduce appropriation due to change In project scope and return the balance reserve. The new contract 859 PAUSD does not io oude mainteoanoe of PAUSD fadlties by the City. School She Irrigation P0-98001 $ (209,86400) Infrastructure Reserve to To reduce appropriation due le change in project scope and return the balance reserve. The new contract with PAUSD deesmr iokude maintenance of PAUSD 'edibles by the City. S0teen ALS Monitor! Dellbdlblors ED -05000 $ (5,485.00) General Fund To close protect and transfer remaining balance to CIP Project ED -09001( Flre Apparatus Egtapmeri) Lot Sit Garage PE -55030 $ (363,405.00) COPg To close project and transfer remaining balance to Rte Deb! Service Fund. Street Maintenance PE -86070 $ (250,000.00) Gas Tax Fund Transfer funding to PO -11001 Street LIghle P005054 $ (254,06900) General' Fund To reduce hording and return balance to reserve. Page 1 Exhibit B ApP(TIONAL'APPROPRIATIONS 7 East Meadow/Alma8oma 4l12kV Con ranebn FY 2010 CIP Mid -Year Adjustments Highway 101 Overcrosstng Bicycle Boulevards Implementation ;PY9legI 51-11000 PL -04010 $ (50,000.00) $ (100,[00.00) Infraslruclre Reserve Transfer la CIP Project 56-11011(Highway 101 Over010001ng). The Pbno Works Department assumed management of project from the Planning and Environmental Department, To reduce funding and return balance to reserve. Infrastructure Reserve Safe Routes To School PL -00029 $ (50,000.00) Gas Tax Fund To reduce fuming and return balance to reserve. Trent Signal Upgrades P1-05030 $ (50,000.00) General Fund To reduce lording and return balance to reserve. ?otst r 3 3 (7,490,442.00) 279,52$.72, ELECTRIC FUND EL -0&002 500,060.00 Ebdrio Fund RSR Street Light System Conversion Project EL -10009 483,000.00 $ 463,000.00 Energy Efficiency Commuvly Block Grart- 2009 Stimulus 5.00,000.00: TOTAL ELECT111C: FUNDGIPM.ID-YEAR-. ADJU&IMEC$TS Approprialion Is moved from FY 201110 FY 2010 to take a vergagod the lower contract oorslruclon costs due to the present e0onomy. Untiring the project Into one Instead of two ea originally budgeted will also help reducing the engineering, Inspeclbn and contract administration costa 2009 Stimulus App(catbn under the Energy Efficiency Cornrow -By Block Grant (EECBG); $463,000 In EECBG money would go to LED streellig15 reimbursed by EECBG WATER FUND "ADarTICI.NA4-APPROPHIATIONS `_ Emergency Water Suypty Project Water Mein Replacement - Project 22 WS -08002 WS -08017 $ 259,266.00 Revenue bards $ 206,000.00 Water Fund RSR To increase approprlalbn es a resin of return of excess funding from CIP Project 5E07007 (Cubbodey Turf Renovation) 7o increase appropriation to cover the cost of street cut fees TOTAL - WATER FUND CIP MIDYEAR AOJUSTME9fl8 . 00,000.00'. FIBER OPTICS FUND APOp(TIOt Jji 'APPR0RR(ATION Fiber Optics customer Connections F0-10006 $ 81,57800 Fiber Optics Fnrtd To close Project EL06005 and trarter balarce le F0.10000 Fber Optics Network Syalem Impravementa FO -10001 $ 188,621.00 Fber Optics Fund To close Project EL -06005 and 'Banter 5,1000010 FO -10001. Tats $ 270,199.00 AEDLf1TIONIN 1PPROFRIATIONSFTO CLOSE PROJECTS ' . . .. Fiber Optics customer Connections EL08008 S (81,578.00) Fiber Opllcs Furd To dose Project EL -06000 and tranfer balance to FO -10000. Fiber Optics Network System Improvements ELA6106 $ (186,621.00) Fiber Optics Ford To close Project EL -06005 and trader balance to FO -10001. �dt $ (270,199.00) RNA: F)DER.OPTICS FUHD.CIP. MIELY,EAR-3-r: ADJUSTMENTS -, $ Page 2 Exhibit C hY 20'1Q1eb.leof Orga SizatiOn-! FY 2010 FY 2008 FY 2009 FY 2010 Mid -Year FY 2010 Adjusted Adjusted Adopted Budget Adjusted Budget Budget Budget Change Budget GENERAL FUND Public Works Department Accounting Specialist - - 0.04 0.04 Administrative Assistant 1.00 1.00 1.00 1.00 Administrative Associate I 3.50 3.50 1.70 1.70 Administrative Associate!! 2.00 2.00 1.80 1.80 Administrative Associate III 1.00 1.00 - Administrator, Public Works 1.00 1.00 - Assistant Director Public Works 1.10 1.10 1.10 1.10 Associate Engineer 0.10 0.10 0.10 0.10 Building Serviceperson 4.00 4.00 4.00 4.00 Building Serviceperson - Lead 2.00 2.00 2.00 2.00 Coordinator, Public Works Projects - Deputy Director, Public Works Operations - - Director, Public Works/City Engineer 1.00 1.00 1.00 1.00 Electrician 1.00 1.00 1.00 1.00 Engineer • 1.20 1.20 0.30 0.30 Engineering Technician Ill 4.20 4.20 3.30 3.30 Equipment Operator 3.46 3.46 3.46 3.46 Equipment Parts Technician Facilities Assistant Facilities Carpenter 1.00 1.00 1.00 1.00 Facilities Electrician Facilities Maintenance - Lead 2.00 2.00 2.00 2.00 Facilities Mechanic 6.00 6.00 6.00 6.00 Facilities Painter 2.00 2.00 2.00 2.00 Heavy Equipment Operator 1.90 1.90 1.90 1.90 Heavy Equipment Operator - Lead 0.85 0.85 0.85 0.85 Inspector, Field Services 1.00 1.00 1.00 1.00 instrument Electrician - - Manager, Facilities Maintenance 0.80 0.80 0.80 0.80 Manager, Maintenance Operations 0.12 0.12 0.12 0.12 Managing Arborist 1.00 1.00 1.00 1.00 Project Engineer 1.20 0.20 0.20 0.20 Project Manager 1.75 1.75 1.75 1.75 Senior Accountant - - 0.02 0.02 Senior Administrator 0.90 0.90 0.90 0.90 Senior Engineer 0.30 0.30 0.30 0.30 Senior Financial Analyst - - 0.16 0.16 Senior Project Manager 1.00 1.00 1.00 - 1.00 Staff Accountant - - 0.02 0.02 Superintendent, Public Works Operations 0.60 0.60 0.60 0.60 Supervising Project Engineer - 1.00 1.00 - 1.00 Supervisor, Building Services - - .. Supervisor, Facilities Management 1.95 1.95 1.95 1.95 Supervisor, Inspec/Surveying, Public Works 0.80 0.80 0.80 0.80 Surveying Assistant 0.78 0.78 0.78 0.78 Surveyor, Public Works 0.78 0.78 0.78 0.78 Traffic Control Maintainer - Lead 1.00 1.00 1.00 1.00 Traffic Control Maintenance 1 1.94 1.94 1.94 1.94 Traffic Control Maintenance II 3.00 3.00 3.00 3.00 (continued) Exhibit C FY 2010Table :oi Organizatibtt FY 2010 FY 2008 FY 2009 FY 2010 Mld-Year FY 2010 Adjusted Adjusted Adopted Budget Adjusted Budget Budget Budget Change Budget GENERAL FUND Public Works Department Tree Maintenance Assistant (1) Tree Maintenance Person (1) Tree Maintenance Specialist Tree Trimmer/Line Clearer Tree Trimmer/Line Clearer Assistant Tree Trimmer/Line Clearer - Lead 1.00 2.00 2.00 (2.00) - - - 2.00 8.00 7.00 7.00 - 1.00 1.00 1.00 2.00 7.00 1.00 MOT= UTILITIE; 69 23 69 23.:.• ..... _ 63.67. `: 63 67.< Footnotes: (1) Title change from Tree Maintenance Person to Tree Maintenance Specialist Exhibit C FY2010-Table or Organization FY 2010 FY 2008 FY 2009 FY 2010 Mid -Year FY 2010 Adjusted Adjusted Adopted Budget Adjusted Budget Budget Budget Change Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Account Representatives Accounting Specialist Administrative Assistant Administrative Associate I Administrative Associate it Assistant Power Engineer Assistant Resource Planner Associate Power Engineer Associate Resource Planner Asst. Director Customer Support Services Asst. Director Utilities/Admin Svc Asst. Director Utilities/Engineering Asst. Director Utilities/Operations Asst. Director Utilities/Resource Management Business Analyst Cathodic Technician Catholic Protection Technician/Assistant (1) Cement Finisher Chief Electric Underground Inspector Chief Inspector Water, Gas, Wastewater Communications Specialist Contracts Administrator Coordinator, Utils. Safety & Security Coordinator, Utility Projects (3) Customer Service Representative Customer Service Specialist Customer Service Specialist -Lead Deputy Director, Administrative Services (5) ' Deputy Fire Chief/Fire Marshal Director, Administrative Services Director, Utilities Electric Project Engineer Electric Underground Inspector Electric Underground Inspector Lead Electrical Assistant I Electrician Electrician -Apprentice Electrician -Lead Engineer Engineering Manager, Electric Engineering Manager, WGW Engineering Technician III Equipment Operator Equipment Operator -Lead Field Service Person Water, Gas, Wastewater Gas System Technician Gas System Technician II (2) Hazardous Materials Inspector 3.00 1.00 1.00 3.00 7.00 3.00 1.00 1.00 2.00 7.00 3.00 2.50 1.00 2.00 7.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.87 2.87 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 3.00 4.00 4.00 5.00 5.00 5.00 2.00 2.00 2.00 1.00 1.00 2.00 - 0.20 0.20 0.08 0.08 0.15 0.15 0.15 1.00 1.00 1.00 3.00 1.00 1.00 2.00 2.00 2.00 1.00 1.00 1.00 4.00 5.00 5.00 14.00 14.00 14.00 6.00 6.00 6.00 4.00 4.00 4.00 1.00 1.00 1.00 1.00 1.00 1.00 3.00 3.00 3.00 2.00 2.00 1.00 2.00 2.00 1.00 0.06 0.06 1.00 1.00 3.00 2.50 1.00 2.00 7.00 1.00 1.00 1.00 1.00 1.00 2.87 1.00 1.00 1.00 1.00 1.00 4.00 5.00 2.00 2.00 0.20 0.08 0.15 1.00 1.00 2.00 1.00 5.00 14.00 6.00 4.00 1.00 1.00 3.00 1.00 1.00 1.00 0.06 (continued) Exhibit C Y 201.© Table; of Organlzatiori FY 2010 FY 2008 FY 2009 FY 2010 Mid -Year FY 2010 Adjusted Adjusted Adopted Budget Adjusted Budget Budget Budget Change Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Hazardous Materials Specialist Heavy Equipment Operator Inspector, Field Services Lineperson/Cable Splicer Lineperson/Cable Splicer -Apprentice - 0.03 0.03 0.03 10.00 10.00 10.00 10.00 4.00 4.00 4.00 4.00 10.00 11.00 11.00 11.00 Lineperson/Cable Splicer -Lead 4.00 4.00 . 4.00 4.00 Lineperson/Cable Splicer -Lead Trainee - Lineperson/Cable Splicer -Trainee Maintenance Mechanic 1.00 1.00 1.00 1.00 Maintenance Mechanic - Welding 1.00 1.00 1.00 1.00 Manager Utilities Telecommunication 1.00 1.00 1.00 1.00 Manager, Customer Service and Meter Reading 1.00 1.00 Manager, Electric Operations 1.00 1.00 1.00 1.00 Manager, Energy Risk 0.75 1.00 1.00 1.00 Manager, Field and Customer Service 1.00 1.00 Manager, Utilities Marketing Services 1.00 1.00 1.00 - 1.00 Manager, Utilities Operations WGW 1.00 1.00 1.00 1.00 Manager, Utilities Rates Marketing Engineer 1.00 1.00 1.00 1.00 Meter Reader 6.00 6.00 6.00 6.00 Meter Reader -Lead 1.00 1.00 1.00 1.00 Meter Shops -Lead - 1.00 1.00 Power Engineer 2.00 2.00 2.00 2.00 Program Assistant 1 3.00 3.00 3.00 3.00 Project Engineer 6.00 6.00 6.00 6.00 Project Manager 1.75 0.75 0.75 0.75 Resource Planner 3.00 4.00 4.00 4.00 Restoration Lead - - 1.00 1.00 Senior Accountant - - 0.75 0.75 Senior Administrator 1.00 1.00 1.00 1.00 Senior Business Analyst 1.00 1.00 1.00 1.00 Senior Electric Project Engineer 4.00 4.00 4.00 4.00 Senior Financial Analyst - - 0.60 0.60 Senior Instrument Electrician - - - Senior Market Analyst 3.00 1.00 1.00 1.00 Senior Mechanic 1.00 1.00 1.00 1.00 Senior Project Engineer 4.00 4.00 4.00 4.00 Senior Resource Originator 1.00 1.00 1.00 1.00 Senior Resource Planner 6.00 6.00 6.00 6.00 Senior Technologist - 0.87 0.87 0.87 Senior Utilities Field Services Representative 1.00 1.00 1.00 1.00 Senior Utility System Technician - - - Senior Water System Operator 2.00 2.00 2.00 2.00 Staff Accountant - 0.75 0.75 Storekeeper 2.00 2.00 2.00 2.00 Supervising Electric Operations & Programs - - Supervising Electric Project Engineer - 2.00 2.00 2.00 Supervisor Electric Systems 5.00 5.00 5.00 5.00 Supervisor, Utility Construction Inspector - - - - Supervisor, Util Meter Readers & Field Service - - - Supervisor, Water, Gas, Wastewater 5.00 5.00 5.00 5.00 Supervisor, Water Transmission 1.00 1.00 1.00 1.00 System Operator Scheduler - - - (continued) Exhibit C 2010 Table 0% Oi=gan nation .:.:: FY2010 FY 2008 FY 2009 FY 2010 Mid -Year FY 2010 Adjusted Adjusted Adopted Budget Adjusted Budget Budget Budget Change Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Technologist - - - Tree Maintenance Person 1.00 1.00 1.00 Utilities Accounting Technician 1.00 - - Utilities Credit/Collection Specialist 1.00 1.00 1.00 Utilities Engineer Estimator 5.00 5.00 5.00 Utilities Engineer Estimator - Lead 1.00 1.00 1.00 Utilities Field Service Representative (2) 7.00 7.00 6.00 Utilities Installer/Repairer 11.00 11.00 11.00 Utilities Installer/Repairer Assistant 1.00 1.00 1.00 Utilities Installer/Repairer-Welding 3.00 3.00 3.00 Utilities Installer/Repairer-Lead 5.00 5.00 5.00 Utilities Installer/Repairer-Lead Welding 2.00 2,00 2.00 Utilities Key Account Representative 3.00 3.00 3.00 Utilities Locator 3.00 3.00 3.00 Utilities Rate Analyst 1.00 - - Utilities System Operator 5.00 5.00 5.00 Utility Compliance Technician 2.00 2,00 2.00 Utility Compliance Tech. -Lead 1.00 1.00 1.00 Utility Market Analyst Utility System Technician Water Meter/Cross Connection Technician Water Meter Representative Assistant Water Meter Repairer Water System Operator 'Water System Operator II (1) 2.00 2.00 2.00 (1.00) 1.00 1.00 5.00 1.00 5.00 11.00 1.00 3.00 5.00 2.00 3.00 3.00 5.00 2.00 1.00 2.00 5.00 5.00 5.00 (1.00) 4.00 ...:..' �.--.:..;235 t'I, __._�..r 0.111,5i274,,TY _ s-,, 1.61..! Footnotes: (1) Drop 1.0 FTE Water System Operator Ii; add 1.0 FTE Cathodic Protection Technician/Assistant (2) Drop 1.0 FTE Utility Field Service Representative; add 1.0 FTE Gas Systems Technician II Atta chm ent 2 General Fund Capital Improvement Program Expenditues Summarized by Project Category -Five Years Fiscal Years 20062010 (in thousands) $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $o ® FY 2006 ® FY 2007 D FY 2008 ® FY 2009 012131 /2010 Totals Buildings & Facilities $3,974 $6,144 $5,786 $10,083 $5,011 $30,998 Land & Land Improvements $112 $30 $2,654 $2,503 $60 $5,359 Miscellaneous $272 $424 $453 $110 $0 $1,259 Non - Infrastructure Management $707 $1,457 $2,977 $440 $6 $5,587 Parks & Open Space $1,413 $2,135 $3,630 $1,660 $2,018 $10,856 Streets & Sidewalks $5,743 $7,944 $5,859 $6,227 $2,245 $28,018 Page 1 of 1 Exhibit A General Fund C apital Improvement Program Project Expenditures - Five Years Protect _ - Project Number Title Project Category FY 2010 Expenditures 12131/2009 , FY 2009 FY 2008 FY 2007 Expenditures Expenditures Expenditures FY 2006 Expenditures AC -02024 Children 's Theatre Light & Soun d Systems Upgrade AC -04010 Cubberley & Children's theatre Stage Floor Replacement AC -09001 Children 's Theatre Replacement an d Ex pansio n CA -01014 Co mmun ity Service s Facilities Lighting En hancemen ts CC -09001 D imme r Replacement and Lighting System CC -10000 R eplacement of Cubberley Gym B Bleac hers FD -08001 Fire Station #6 Improvemen ts OS -07003 Foothills Park Maintenance Bu ilding Rehabilitation PD -04011 Civ ic Cen ter Parkin g PE -03004 Roth Bu ilding Wings De molition Buildings and F acilities Buildings and Facilities B uildi ngs and Facilities Buildings and Facilities Bu ildin gs and Facilities Buildings and Facilities Buildings and Facilities Bu ildin gs and Facilities Bu ildings an d Facilities 0 0 0 0 3,663 249,933 4,978 30,760 37,474 30,442 61,580 74,581 Buildings 86,745 12,613 and Facilities Page 1 of 18 E xhibit A General Fund . Capital Improvement Progra m Project Expenditures - Five Years FY '010 . Project. - Project Project Expenditures Number Title Category 12/31/2009 FY 2009 FY 2008 FY 2007 fl 2006 E xpenditures Expenditures Expenditures Expenditures - PE -04010 Children's Library Improv ements & Expa nsion Buildi ngs and Facilities PE -04011 Cambridge Parking Structure Buildings Improvements a nd Facilities PE -04012 Mitchell Park Library & B uildings Commun ity Cente r a nd Improvemen ts Facilities PE -04013 Fire Station s 3 & 4 Buildings Replace ment: Feasibility Study and Fa cilities PE -04014 Animal Shelter Expan sion & Buildings Ren ovation and Facilities PE -05002 Main Library Space Bu ildings Reconfiguration an d Facilities PE -05003 Foothills Park Interpretive Bu ildin gs Center improv ements an d Facilities PE -05010 College Terrace Library Buildings Impro vements and Facilities PE -06001 San A ntonio Bridge Structural Bu ildings R epairs & Ma intenan ce and Facilities 0 58,560 813,189 2,369,589 770,608 287,034 59,105 58,201 66 179,071 1,162,429 15,018 91,354 16 58,832 762,056 144,610 96,231 305,523 34,838 462,024 133,339 413,743 337,154 273,077 80,006 12,077 263 2,338 2,702 Pa ge 2 of 18 Exhibit A General Fund Capit al Improvement rovem .ent Program Project Expenditures --Five Years P Project \unibc r Project Title Project -.. Category FY 2010 Expenditures 12/31/2009 FY 2009 E xpe ndit ures FY . 2008 Expenditures FY 2007 Expendit ures FY 2006 E xpenditures PE -08005 Mu nicipal Service Center R esurfacing PE -09003 City Facility Pa rkin g Lot Maintenance PE -09005 Downtown Library Improv emen ts PE -09006 Mitchell Park Library & Commu nity Center (New Construction) PE -09010 Library & Co mmun ity Cen ter Temporary Facilities PE -10002 Ventura Co mmu nity Cen ter and Park PE -89004 Yacht H arbor Improvements PE -95012 Civic Cente r Plaza Waterproofing PE -98020 Public Safe ty Building Buildings and Facilities Buildi ngs a nd Facilities Buildings and Facilities Buildings an d Facilities Bu ildin gs and Facilities Buildings and Facilities Bu ildin gs and Facilities Buildings an d Facilities Bu ildin gs an d Facilities 325,651 0 330,799 1,845,621 141,937 7,712 0 752,020 78,163 509,024 28,866 21,584 7,080 11,949 1,698 12,238 111,836 1,000,414 1,093,208 768,234 205,790 Pa ge 3 of 18 Exhibit A General Fund Capital Improvement Program Project Expenditures - Five Years FY 2010 Project Project Project Expenditures Number Title Category : 12/31/2009 Flt 2009 FY: 2008 EY:2007 :.: Expenditures Expenditu res Expe nditures FY1006. Expendit ures. PE -99006 MSC Feasibility Study PF-00006 R oofing Replacemen t Buildings and Facilities B uildings a nd Facilities PF-00020 Office space ren ovation an d Buildings Rea llocation and Facilities 542 4,640 164,983 21,073 256,831 76,769 37,914 19,647 85 PF-01002 Civic Cen ter Infrastru cture Buildings 710,520 4,915,782 106,643 438,192 1,065,297 Improv emen ts an d Facilities PF-01003 Buildin g Syste ms Improvemen ts Buildin gs - and Facilitie s 2,086 114,152 34,304 64,312 54,902 PF-01004 Fire Station Improvemen ts Buildings 226,421 575,700 232,168 50,514 48,981 and Facilities PF-01005 Lu cie Stern Commun ity Cen ter Bu ildin gs Improvements and Facilities PF-02022 Facility Interio r F in ishes Buildin gs an d Facilities 980 1,010 459,885 3,250 47,116 65,797 10,579 47,029 PF-04000 Security System Improv emen ts Bu ildin gs 0 8,903 5,983 618 193,637 and Facilities Page 4 of 18 Exhibit A PF-04001 General Building Study B uildi ngs and Facilities General Fund Capital Improvement Program Project Expenditures Five Years PF-04010 Cubberley Me chan ical & Electrical Upgrades Buildi ngs a nd Facilities PF-05002 Mun icipal Service Center -B uildings Renovation a nd Facilities PF-05003 Foothills Park In terpretive Buildings Center Improv ements an d Facilities PF-06000 Ba ylan ds Athletic Center R oof Bu ildin gs and Bleachers and Facilities PF-06001 Ted Thompson Garage Buildings Improvemen ts and Facilities PF-06003 Cu bberIey Community Cen ter Bu ildings Fire Alarm System and Facilities PF-07000 Art Center Electrica l & Buildin gs Mechan ical Upgrades and Facilities PF-07001 Cu bberley Win g I Elev ator Bu ildin gs Upgrade and Facilities FY 2010 F Y "2009 FY 2008 Expenditures Ex endttures Expenditures 12/31/2009 4,825 170,312 n 2007 FY 2006 Expendit ures -E xpenditures 9,369 5,218 165,456 960,596 79,779 0 12,057 18,316 115,025 29,435 82,626 36,865 1,240 0 202,176 203,435 70,949 648,988 158,494 52,063 13,511 37,815 25,054 141,046 Page 5 of 18 Exhibit A Children's Theatre Fire/Life Safety Upgrade Buildings and Facilities General Fund Capital Imp rove ment Program Project Expenditures Five Years PF-07003 PF-07011 Roth Bu ildin g Maintenance Buildings and Facilities FY 2008 FY 2007 FY ;006 Expenditures Expe nditures Expenditures' 0 0 1,931 17,909 PF-08000 Art Center Kiln Hood Buildi ngs 14,570 34,897 Replacemen t a nd Facilities PF-08000 Lytton Plaza Ren ovation Buildings an d Facilities PF-09002 Lucie Stern Community Cen ter Buildings 1,880 and Theatre Exterior Paint an d Facilitie s PF-10000 Civic Center Chiller Driv e Buildin gs 803 Replaceme nt an d Facilities PF-10001 Rincon ada Pool Plaster Buildin gs 114,100 and Facilities PF -10002 Lot " 1" Cowper/Webster Buildin gs 19,065 Structural Repairs and Facilities 32,980 10,076 247 Page 6 of 18 Exhibit A eneral Fund Capital Improveme nt Program Project Expenditures'-- Five Years FY2010. Project Project , Project Expe nditu res Number Title . C ategory 12/31/2009 FY 2009 FY 2008. FY en2007 FY .2006. E xpenditures Ex . .: -. -. EExpendit ures1 , Expenditur es E xpenditures PF-93009 PG -00010 PG -09003 ADA Compliance Park Facilities Improvement Park Mainten an ce Sho p Remodel B uildings and Facilities Buildi ngs and Facilities B uildings a nd Facilities 100,571 121,617 1,208 0 402 49,955 96,587 204,495 33,078 $5,010,929 $10,083,518 $5,785,581 $6,143,824 $3,974,060 AC -86017 Art in Public Places Lan d and Land Improvements 12,272 21,556 64,410 29,545 112,256 AS -08000 Acquisition of Los A ltos Land and Land Improv ements 0 2,306,958 2,590,061 Treatment Plan t AS -09000 City of Palo Alto Municipal Land an d Lan d Improvements 43,675 39,075 Airport Transitio n Project PE -09004 Los Altos Treatment Plan t Land an d Lan d Improve ments 3,803 135,905 Master Plan Stu dy $59,750 $2,503,494 $2,654,471 $29,545 $112,256 Page7of 18 Exhibit A FD -09001 Fire apparatus Equipme nt Replaceme nt General Fund Capital Improvement Expenditures J Pro Program j - Five Years Program FD -09002 Jaws of Life Hurst Tool R eplacement LB -94018 Library Automation Service PD -03003 Addition al F ire Frequ ency PD -04010 Fire Portable Ra dio Replacement PD -05010 Po lice Vehicle - Mou nted Video R ecordin g PD -07001 SWAT Van Replacement PD -08000 Crime Scene Evidence Collection Vehicle PD -93012 Fire Communica tion s Computer Systems PD -99013 Police Rec ords Management System FY2010 Expenditures 12/31/2009 Miscella ne ous Miscellaneous Miscellaneo us 0 Miscellaneo us Miscellaneous 0 Miscellan eous 0 Miscellaneou s Miscellaneou s 0 Miscellan eous 0 Miscellaneou s 0 48,352 FY 2008 F'Y:2007: FY 2006 Expenditures Expe nditures Expenditures 60,905 732 5,026 112,526 203,193 6,812 31,307 85,563 19,503 1,607 PE -95030 Do wntown Parkin g Structu re Miscellaneous 0 155 91,576 416,171 146,192 Indu stria l Cost Pool Page 8 of 18 Exhibit A General Fund Capital Improvement- Program Project Expenditures - .Five, Years Project Number. Project Title FY 2010 Project Expenditures Category_ 12131/2009 FY 2009 :. -Expenditures FY 2QQS� FY:2oo7. .: _ Fi' U6 Expenditures Expendhtures . Expenditures PE -96008 D owntown Urban Desig n Improve men ts PL -02023 Master Schematic Design Miscellane ous PO -10002 Do wn town Tree Grates Miscellane ous Miscellaneo us 2,090 8,270 0 19,537 $0 $110,144 $452,530 $424,441 $272,402 FD -05000 Sixteen (16) A LS Mon ito rs No n -In frastru cture 62,650 214,734 192,815 Man agemen t Plan PD -07000 Mobile Command Vehicle Non -In frastructure 0 Man agement Plan PE -05001 Photovoltaic De sign an d Non -Infrastructu re 6,367 325,977 2,184,597 648,951 282,376 In stallations Ma nagement Plan PE -07011 Library Service Model Analysis N on -Infrastructure 1,478 266,912 Management Plan Page 9 of 18 Exhibit A general Fund Capital ImprovementProgram Project Expenditures - Five Years Project Number Project Title FY 2010 Project . E xpenditures Category 12/31/2009 FY .2009 FY 2008 FY 2007 FY 2006 E xpe ndit ures Expenditures Expenditures Expenditures .: PG -08001 Golf Course Driving Ra ng e Turf & Nettin g N on -I nfrastr uctur e Management Plan PL -05002 Charleston/ Arastradero Non -Infrastructure Management Plan Corrido r Plan 0 0 PL -06001 Adobe Creek Bicycle Bridge Non -Infrastr ucture 0 Replacement Management Plan 4,184 PL -06002 Comprehensive Pa rking Non -Infrastructure 0 43,470 Signage Plan Management Plan 511,921 32,076 PL -06005 Installation of Ticket Machines Non -In frastructu re 0 2,250 33,994 Management Plan PL -07001 In termodal Tran sit Cente r No n -Infrastructure 0 Management Pla n 529,889 4,000 218,819 7,416 12,662 PL -07003 Palo A lto Caltrain Station Non -Infrastructure 0 Con nectivity Improvements Man agement PIan $6,367 $440,009 $2,977,322 $1,457,168 $706,672 Page 10 of 18 Exhibit A General Fund Capital ImProveme nt. Program Pro ect Ex enditures - Five ,Years Project Number 2010FY - FY 2009 :' FY 2008 FY 2007 FY 2006 Project Project Expenditures Expenditures Expenditu res Expenditures Expenditures' Title Category .. • 12/3113009 AC -10000 Jun io r Museu m & Zoo New Bobcat Habitat OS -00001 Open Space Trails an d Amenities OS -00002 Open Space Lakes & Ponds Ma intenance OS -00003 Baylan d Parking and Site Improvemen ts Parks and Open Space Parks and Open Space Parks a nd Open Space Parks and Open Space 0 29,836 123,193 257,594 184,333 5,848 35,909 41,462 42,399 82,674 OS -07000 Fo othills Park Road Parks 0 25,000 225,000 Improv emen ts an d Open Space OS -07002 Foothills Park Interpretive Parks 2,302 Cen te r & Open Space and Mainten ance Y ard Parking O pen Space OS -09001 O ff -Road Pathway Re surfacing Parks 24,719 25,463 and Repair a nd Open Space OS -09002 Baylands Emergen cy Acce ss Pa rks Lev ee Re pa ir and Open Space 0 258,253 26,120 82,716 24,063 83,761 PE -00101 Foothills Park - V ista Hill Parks 18,720 30,852 an d O pen Space Page 11 of 18 E xhibit A eneral Fund Capital Improveme nt Program Project Expenditures - Five Years FY 2 .010 Project Project Project Expendit ures Nu mber Title Category 12/31/2009 FY 2009 FY 2008 FY 2007 FY 2006 ... Expenditures E xpenditures Expenditures Expenditures. . PE -00106 Eleanor/H oover Park Improvements Parks a nd Ope n Space PE -00107 Briones Park Improvements Parks and Open Space PE -00108 Baylands Lighting Parks Improvements and Open Space PE -00110 College Terrace Park Parks Improvements an d Open Space PE -05300 Arastradero Preserve Gateway Parks and Open Space 2,698 760 578,780 62,535 521 154,928 97,998 32,914 18,524 0 9,156 1,519 89,118 230,051 PE -06004 Bowde n Park Improvements Parks 876 161,395 20,864 and Open Space PE -06005 Univ ersity Av enue Gateway Parks 5,612 166,612 27,324 16,624 17,521 Landscapin g Improvements and Open Space Page 12 of 18 Exhibit A General Fund Capital Improvement . _. pProgramProject Expenditures - Fi ve Years FY 201.0 Project Project Project . E xpenditures Number Title._ Category 12/31/2009 FY 2009:. FY 2008 . .. . FY 2007 FY 2006 Expenditures . Expendit ures Expenditures: E xpenditures PE -06007 PE -06008 PE -07002 PE -07003 Park R estroom Installation Johnson Pa rk Impro vements Hoover Park Improvements Ramo s Park Improvemen ts PE -07005 California Avenue Improvements PE -07006 Bou Iware Park Improve ments PE -07007 Cu bberley Turf Ren ovation PE -07009 Baylan ds Athletic Center Fencing, Dugout & Trailhead Parking PE -08002 Peers Park Improvemen ts PE -08004 Lytton Plaza R eno vation Parks 17,570 41,134 and Ope n Space Parks and Open Space Parks a nd Open Space Parks and Open Space Parks 137,685 49,899 and Open Space Parks and O pen Space Parks 865,771 190,949 an d Open Space Parks 0 46,165 and Open Space Parks 0 301,382 an d Open Space Parks 589,013 23,530 an d O pen Space 13,042 8,648 696,240 458,628 64,985 298,717 241,891 250,622 0 73,681 39,041 37,554 25,520 146 Page 13 of 18 Exhibit A General Fund Capital Improvement Program. Project Expenditures - Five Years it 1 2010 Project Project Project Expe nditures Number Title Category, • 12/31/2009 FY 2009 FY 2008. FY 2007 FY 2006 • _ Expendit ures E xpenditures Expe nditure s; Expenditures-.:: PE -09002 PE -98003 PG -04010 PG -06001 Tenn is and Basketball Court R esurfacing Greer Park Phase IV Mitchell Park Facilities Stan ford/Palo Alto Commun ity Playing F ield PG -06003 Benches, Signage, Fen cin g, Walkways, and Perimeter Lan dscaping PG -07000 Heritage Park Playground Parks and Open Space PG -07700 Golf Cou rse irrigation Pump, Parks Motors & Control pan el and Replacemen t Open Space PG -09002 Park and Open Space Emergency Repairs PG -98001 Schoo l Site Irrigatio n Parks a nd Open Space Parks a nd Open Space Parks and Open Space Parks and Open Space Parks an d Open Space Parks an d Open Spa ce Parks and Open Space 68,827 168,231 0 24,962 196,655 224,247 869 2,050 843,591 74,788 107,117 46,881 130,069 27,989 85,766 76,788 106,156 14,292 73,190 155,778 4,596 1,134 243,546 63,315 57,268 173,045 8,635 8,766 0 154 70,328 $2,018,249 $1,660,353 $3,630,436 $2,135,070 $1,413,285 Page 14 of 18 Exhibit A General Fund Capital Improvement, Program Project Expe nditures - Five Years FY 2010 FY 2009 FY 2008 FY 2007 FY 2006 Projec t Project Project Expenditures Expenditures E xpe nditures E xpenditures Expenditures Number '. Title Category 12131/2009 Page 15 of 18 Exhibit A eneraI Fund Capital Improvement Program Project Expenditures Five Years Project . Number - Project Title Project Categ ory FY 201.0 FY 2009 FY . 2008 Expenditures Expenditures . Expenditures 12/31/2009 FY 2007 Expenditures FY 2006 E xpenditures PE -00018 San d Hill Road Bridge Streets and Sidew alks PE -00103 Lucie E vans Center parking Lot Streets and Sidewalks Improv emen ts 2,970 217 235,179 PE -00104 San Anto nio Road Median Streets 179,796 743,106 153,112 146,212 Improve ments a nd Sidewalks PE -00105 Embarcadero Road Median Streets 0 1,191 178 Improv ements an d Sidewalks PE -01013 El Camin o Median Landscape Streets 0 4,525 73,655 53,826 292,402 and Sidewalks PE -01021 H omer Av enue Un dercrossin g Streets an d Sidewalks PE -03005 Wildho rse Valley Vehicle Streets Bridge Replacement and Sidewalks PE -06006 Alma Street Lan dscape Streets 26,035 40,901 16,576 17,992 11,253 Improvements and Sidewalks PE -10006 Bridge Rail, Abutment, and Stree ts 156,516 Deck Repair an d Sidewalks PE -86070 Street Improvemen ts (Street Streets 1,529,000 3,702,381 3,368,496 4,987,364 2,304,729 Improvement Fun d) and Sidewalks 125,963 450,060 Page 16 of 18 Exhibit A General Fund Capital Improvement'Program Project Expenditures Frve,:Yeaars -- y 2010 Project . ' Project ' Project Expe nditures Number Title Category 12/31/2009 FY 2009 FY 2008. ; FY 2007 Expenditures Expenditures E xpendituures FY 2006 Expenditures PE -93010 PF-00104 San A nto nio Median s PL -00026 Safe Rou tes to School Embarcadero Pedestria n Bike Bridge Path Extension (SIF) PL -02005 El Camin o Real/ Ve ntura A venue Traffic Signal Streets and Sidewalks Streets and Sidewalks Streets a nd Sidewalks Streets and Sidewalks PL -02006 Traffic signal San Streets A ntonio /Hwy 101 an d Sidewallcs PL -04010 Bicycle Tran sportation Plan Streets Implemen ta tion Pro ject and Sidewalks PL -05003 College Te rra ce Traffic Streets Calming an d Sidewa lks PL -05030 Traffic Signal U pgrades Streets and Sidewalks PL -07000 Downtown N orth Traffic Circle Streets Hardscape and Sidewalks 18,196 32,552 9,744 0 105,802 4,472 35,251 0 10,483 0 44,483 0 17,088 1,986 39,983 35,908 0 110,000 5,480 142,460 30,524 8,520 425 60,142 Page 17 of 18 E xhibit A General Fund Capital Improvement Program Project Expendit ures - Five Years Project Nu mber Project Title Project Category FY 2010 FY 2009 FY 2008 FY . 2007 FY 2006 Expenditures Expenditu res: Expenditures Expenditures Expenditures. 12/31/2009 PL -07002 El Camin o Real/ Stanford Intersection PL -11000 Highway 101 Pedestrian / Bicycle Overcrossin g Streets a nd Sid ewalks Streets and Sid ewalks 10,034 7,694 2 ,490 PL -98013 Scho ol Commute Safety Streets 0 2,490 5,721 Improvemen ts (SIF) and Sidewalks PL -99023 Page Mill/Ha nover Streets 200 3,330 and Sidewalks PO -05054 Street lights Improvements Streets 3,122 15,970 11,814 19,077 84,785 an d Sidewalks PO -89003 Sidewalk Improvements Streets 310,889 1,675,527 2,030,796 2,299,543 2,197,218 an d Sidewalks $2,245,299 $6,227,373 $5,858,921 $7,943,508 $5,742,733 Page 18 of 18 Attachment 3 FY 2010 MID -YEAR CAPI TAL EVIP ROVEMENT PRO GRAM P ROJECTS ST ATUS GENERAL FUND A DMINISTRATIVE SERVICES DEPARTMENT Total IR ud„et P rnje Ct . • P roject P roject. Froui;. Number Title Categ ory I nception ..%X2010 A vailable Budget F Y2010. .. Expenditures. FY .2010 FY2010 FY 2010 Labor _ - Co nti nge ncies E ncumbrances Remaini ng djmtroe nts Balance Percent Complete P roject, Status Estim ated: Completion, Hate AS -09000 City of Palo Alto Mu nicipal Airport Tran sitio n Project Land and Land Improvements $130,000 $7,223394 590 ,925 52,326,375 $43,675 50 $0 $29 ,035 518,215 $2,326,375 86% Desig n 68% Design u n2010 Airport Plan to be presented to C ouncil for re view and approval in first quarter 2010. Jan 2010 3rd and final payment of $2,166,667 (plus interest based on the City's portfolio rate) was paid 01/05/2010 . Pagel FY 2010 MID -YE AR C APITAL IMPROVEMENT PROGRAM PROJECTS ST ATUS Attachment 3 GENERAL FUND COMMUNITY SER VICES DEPA RTMENT Project l Number Project J -Remam Title -- Project 1 C ategor y" Total Budget from -Inception-:-; FY .2010. Av ailable :Budget FY 2010 .. FY 2010. FY 2010 FY 2010 Expenditures . Labor.. Coittinsen ctes' Encumb ra nces ng adjustments Bal ance percent Complete Pro ' ct.Completion .Stat us. Estimated . Dat Comrneats AC -09001 Children's Theatre R eplacement and Expansion Buildings and Facilities $100,000 $100,000 $0 $0 SO $0 $100,000 0% Staff in initial pla nni ng and development of scope of co ntract . AC -10000 Junior Museum & Zoo New Bobcat Habitat Parks and Open Space $575,000 $575,000 $0 $0 $0 $0 $575,000 0% Desig n Jun 2010 Ground breaking scheduled f or February 2010. CC -09001 D immer Replacement and lighting System Buildings and Facilities $145,000 $145,000 $0 $0 $0 $0 $145,000 0% Desig n Dec 2010 Scope of contract being developed, after which project will be Out for Bid. CC -10000 Replac ement of Cu bberley Gym B Bleachers Bu ildings and Facilities 556,350 $56,350 50 $0 $0 50 556 ,350 0% Desig n May 2010 Out for Bid Jan uary 2010. PG -09003 Park Main ten an ce Shop Remodel Bu ildin gs and Facilities 5150,402 $150,000 $0 50 SO 50 5150,000 0% Desig n J un 2010 Since there is common shared space, this project will now be designed and constructed in- house by Public Works Facilities Management in co nj unction with Tree Division. OS -07003 Fo othills Park Mainten an ce Building R ehabilitatio n Buildings an d Facilities 5338,630 $1,719 $0 $0 $0 $1 51,718 99 % C omplete Remaining balance to be ret urned to infrastr ucture reserve at mid - year. OS -09002 Bayla nds Emergency Access Levee Repair Parks an d O pen Space 5175,000 $175,000 50 $0 50 $0 5175,000 0% Staff in initial planni ng and development of scope of c ontr act. _. _... _ ' _ <1 _ .. OS -0000I O pen Space Trails & Amenities Parks and Open Space 51,721,121 $173,654 529,836 50 50 563,200 $80,618 95 % Ongoing Various trail improvements at Arastradero, Foothills Park, and Baylands. Currently in final year of 3 -year co ntract with Northwest Woodla nd Services and repair to Baylands boardwalk 0S-00002 Open Space Lakes & Ponds Maintenan ce Parks an d Open Spa ce 5339,236 $50,107 $5,848 50 50 537,600 $6,659 98% Complete Remaining batanre to be returned to infrastructure reserve. OS -07000 Foothills Park Road improvements Parks an d Open Spa ce 5375, 000 5125,000 $0 50 50 50 5125,000 67%n Ongoing Phase 1 of road resurfacing from entrance to Foothills Interpretive Ce nter completed. OS -09001 O ff -Roa d Pathway Resurfa cing and Repair Parr and Open Space 580,668 555,205 524,719 50 $0 $1,721 528,765 64% O ng oing Byxbee Park trail repairs were completed in FY 2009 . PG - 06001 Tennis & Basketball Court Resurfacing Parks and Open Space 5533,653 $233,320 $74,788 50 50' $0 5158,532 70% O ngoi ng Projects pla nned for FY 2010: Basketball court resurfacing at Ten nan School a nd Greer, Peers, Boulware, and Briones Parks . Page 2 FY 2010 MID -YE AR CAPITAL IMPR OVEMENT PROGRAM P ROJECTS ST ATUS Attachment 3 GENERAL F UN D COMMUNITY SERVICES DEPA RTME NT Project Number PG -06003 Project Title Benches, Sig nage, Fen cing, Walkways, and Perimeter I andsra ping Project Category. . Parks and Open Spar. Total Budget Front .. I nceptio n $373,358 FY 2010 Available Budget $104,648 FY 2010 Expenditures $27 ,989 FY 2010 Labor . Adj ust ments $0 FY 2010 Con tingenc s $0 FY 2010 Encumbrances $3,953 Remai ning Bala nce $72,706 Perce nt Complete: Project St atus Estimated £ompletion Date . Comments '_ 81% Ongoing Pr ojects completed in FY 2010: Site Amenities: Children's Theater benches for courtyard and Foothills Park benches. Sien age: Bowden Park, Magic Forest, Bayla nds , and Mitchell Park Pathways: Arastradero concrete. PG -08001 Golf Course Driving Ran ge Tu rf & Netting Non - In frastructure Management Plan $559,086 $47,165 50 $0 $0 $0 $47,165 92% Complete Remaining bala nce to be returned to i nfrastructure reserve. PG -09002 Park and O pen Space Emergency Repairs Parks and Open Space $150,000 $76,810 $14.292 $0 $0 S8,437 $54,081 64% Ongoi ng Pr ojects completed in FY 2010: Entrance gate at Bayla nds; P ump repair at the Pal o Alto Golf Course; Rinconada regai ning wall repair; Emergency asphalt repair at Briones school. Playgro und repair at Bol Park (swi ng post rep air), Eleanor Park (water circuit), and Rinc onada (tu nnel slide). PG -98001 School Site Irrigation Parks an d O pen Space $1,170,000 $374,050 $155,778 $0 $0 $14,466 $203,806 83% Ongoing Nix on Eleme ntary School projects completed Aug ust 2009. Addis on Elementary School irrigation completed September 2009. Page 3 Atta chm ent 3 FY 2010 MID -YEAR CAPITAL IMPROV EMENT PR OGRAM P ROJECTS STATUS GENERAL FUN D FIRE DEPA RTM ENT Project Project Project Number Title • Category y Total Budget From Inception FY 2010 Available: `B udget f 2010 FY 2010 1:2010 -. . fl 2010 Expenditures .- Labor Co nti nge ncies E nctimbrances Adjustme nts 56,251 Percent - Complete Project Status Estitnated-: : • Completion_; Date Stanford Uni versity's proj ect ma nager is worki ng with the Fire Departme nt on completi ng the pr oject . Fire Sta tion #6 Improv emen ts Buildi ngs and Facilities $60,000 $60,000 $0 $0 $o $3 ,749 6% Design Ian 2010 Fire Apparatus Equipment Replacemen t Miscellan eous $309,635 $255,818 $261,283 $0 $0 (5,465) I00 % Complete Project is overspe nt . Remai ning bala nce of FD - 05000 will be tra nsferred to this project to co ver deficit. Jaws of Life Hurst T ool Replacemen t Miscellan eou s $65,000 $4,095 $a $0 4,095 94 % Complete Remai ni ng bala nce to be retur ned to infrastructure reserve at mid -year . Remai ning balance will be transferred to FD -09001 to cover deficit spending on that project. Page 4 Project Ptiojett . FY 2010 MID -YEAR CAPIT AL IMP ROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PLANNING DEPARTMENT Tot al. .: 13 ud ct,' ,.._ :.- Inception- -. zaz0, � Arailable FS'2010 .: :Expe nditunes. FY:Tolo- Labor _4ojustrne nts: c tit CnpCS 2010'_ E ncuatbra nces Rem aining. c Percent:, •- Balanc e complete: . Project Status. Estimated...-.. Completion -. • Date C airrans compl et ed this project in the winter of 2008. C ancans final accou nting has now been received, and project can be cl osed. PL -02005 El Canino Rea l/ Ventura Avenu e Traffic Sign al Sects and Sidewalks $121,001 $11,001 $0 SO SO SO $11,001.00 100% Complete PL -05002 Charleston/ Arastradero Corridor Plan Non- In frastrucnue Management Pla n $1 ,209,545 $428,761 50 $0 SO 584,003 2344,758.00 71 % Constr uction Sep 2010 Inst allation of the Phase 1 trial pr oject (Gu nn High Scho ol sig nal and right turn lane a nd Charleston C orridor restriping) was completed in Aug 2006 . The City C ouncil approved the perma nent retention of the Charlesto n Phase I plan in April 2008 . The pla n f or the Phase 2 ( Ar estrndero Road trial stripi ng) was approv ed by th e City Couaol in July 2009 . Project will be implemented in the summer of 2010. PL -05003 PL -06001 PL -06005 PLO7000 College T erra ce Traffic Cviming Adobe Cree k Bicycle Bridge Repla ce ment Installation of Ticket Machines Downtown North Traffic Circle H andscape PL -07001 intermodal Transit Center Streets an d Sidewalks Non- Infrastrnc mre Mana gement Plan $234,573 $50,000 574,600 $45.816 $0 $0 $0 50 SO 30 31 50 $74,599.00 $45,816 .00 68% 899 Construction Construction Sun 2010 Dec 2009 City C ouncil appr oved traffic calrtting plan in Nov 2004. I nstallation of the trial plan t raffic cahning measures was completed in Nov 2006 , incl uding 6 speed tables and 5 traffic titles. The Planning and Transportatio n Commission reviewed the trial evaluation r esults and approved staffs recommended changes to the plan for a seco nd 6 -month trial of n ew traffic cal ving features in July 2009. Staff will provide an evaluation r eport on the s econd tri al in spring of 2010. City of Los Altos is lead agency f or this i nter - jurisdictional project Construction completed in summer 2009: City awaiting fin al acc ounting and i nvoici ng from Los Altos for City's local match. No n - Infrastructure Management Plan Streets and Side walks N on - In frastru ti tre Management Plan $94,900 260,000 $837,380 538,578 $60.000 5837,380 50 SO So $0 50 SO $0 $0 SO 56,894 $0 SO $31 ,684.00 $60,000.00 3837 ,380 .00 6798 0% 090 Complete Pre -design Pre -design TBD TBD TBD Before closing project, st all' will consult with Chamber of Commerce Downtow n Parki ng Committe e regarding the need for additional ticket m ach' Project will be impleme nted by Public Works Operations in conjunction with sidewalk replacement project The i nitial technical snvlies and work pr ogram for the next phases of the pr oject were completed in 2007. However, this project is on hold due to the appro val of the Califor nia High Speed Rail project bo nd measure in 2008 . This project is curre ntly being co nsidered to be removed from th e CIP. Staff is working with VTA regardi ng deferring this proj ect to a future 5 -ye ar CIP. Page 5 FY 2010 MID - YEAR CAPITAL IMPR OVEMENT PR OGR AM PROJECTS STATUS GENERAL F UND PLANNING DEP ARTMENT . __...._.;.�_-.� PL - 07002 - -Project .. ..« ..._...,...._.. ..._.. ._ ... .._-�,._. . Total _- _ „ - Bedl ,,t- . .e ..... ..�.. .._._, . 3155,000 .. _.:- _ FY 2010 Available ..., .__. ... . 3152,5I0 22 22. 4 -L1"010 .. .. .._< _.v :., :.,. 310,034 _ FY 2010 Labor ........t:. 2: 22.2 30 ._ .. . - F1 2010 Goad cncets" 30 . - F`Y 2010' .Proj ectProject, Encumbranc es $97,506 - _ Rem ai ning Ba!ance .. - Percent Complete P - - - ' Estimated Status. ' -Date.,_ _ -- . .: - .. . Comments_ El Camino Real' Stan fo rd Intersection Streets and Sidewal ks $44,970 .00 71% Design J un 2011 ., ,.�.. s __. ..... .:.... .: ,: C ou ncil accepted gent funding from the VTA for this project in Apr 2007. Funding ' agreements with C alTrans were executed in Apr 2008. The design and environnwrttnl c onsuka nts were h ived in April 2009 . Proje ct f unds and approval by CalTrans m ust be secured by June 2010. PL -07003 Palo Alto Colo -s in Station Conn ec tiv ity Improvements N on- Infrastructure Man ageme nt Pla n $30,000 330,000 s0 50 $0 $0 130,000.00 0% Pre -design TED No activity to date. PL -11000 Highway 101 Pedestrian / Bicycle Streets and Sidewalks 3100,000 $100,000 37 ,694 30 $0 1100,000 ($7,694 .00) 1084£ Project to be take n over by Public Works. New pr oject nr,m.irr is PE-11011 . expenditures to be t ransferred to new proje ct m mid -year, 1'b'.Tli ' tea yr.-..Lar }%[ ;:k1i .,. `iiilii^,J�i 0.6.,:tt. PL -00026 Loca l and Neighbo rhood Collecto r Street Truffle Calmin g Progr am (SIF) Stre ets and Sidewalks $920,000 $431502 $9 ,744 30 30 $0 $421,758 5455 C onstru ction Ongoing The Planning and Transportation Commissio n recommended — and the Pls nni e00 Director approved -- the permane nt retentio n of the 11_,p -r A venue traffic calming trial in Jan 2008. Lincoln Avenue trial traffic calmi ng plan was iniriated in fall 2008 a nd eval uation will be completed in e arly 2010 . Pla nni ng st udy f or Safe Routes to School project on North California is under way. PL -04010 Bicycle Bouleva rds Implementation Projec t Stree ts an d Sidewalks $339,497 $281,014 110,483 s0 • s0 30 3270,531 20% D esign Ongoing MaybelliDonald Bicycle Bo ule vard trial plan was c ompleted in Aug 2007. The trial E valuatio n it -punt was reviewed by the Pla nni ng and Transportation Commission in May 2009 . The PIC r ecomme nded rete ntion of the pr oject on a permanent basis . Staff i nitiated the design for the Park B oul evard brine boulevard in summer 2009; first comm unity mating held November 2009 . PL -06002 Compre hensive Parking Signage Plan Non - Infrastructure Man agement Plan $475,000 3427,530 10 $0 30 39,002 $418528 12 % Constr uction km 2010 Bid d octmtents compl et ed in Dec 2007. Contract awarded in Jun 2008. Installation of color zo ne signs was compl et ed in Nov 2008. Fu rther signage, kiosks , etc.. will be p ursued' 2010. PL -99013 School Commute Safety Improvemen ts (SIP) Streets and Sidewalks 3150,000 $108,659 $0 $0 r 30 SO 3108,659 28% Design Dec 2010 Funding from this pr oj ect will he used as the l ocal mat ch funding f or the Stanford Av en ue/El Camino Real Str eA-.—p c Project in 2010. Page 6 Attachment 3 FY 2010 MID -YEAR CAPITAL IMPR OVEMENT PROGRAM P ROJECTS STATUS GENERAL FUND POLICE DEPA RTMENT Fire Portable Radio Replacemen t Project ... • -=Project Title - Category ..Budget FS" 2010-`. From Available inception _ .Budget fy 2030 .: Expenditures FY 2010 .. .J.db0[ '. ..... Adjustments FY;2t 10 = _ Conti ngencies k iremib rruees . --- .. kstanated.: .. . Remai ning -,-• Percent ' • Project • Completion i B alance .Cnoplete_ "Stat us • Date' Re mai ning balance to be returned to reserve. PD -04010 Mis cellaneous $245,584 $724 $0 SO SO 5O 5724 100% Complete PD -05010 Police Vehicle - Molmted Video Recording Miscellaneous $200,000 53 ,931 $0 $0 50 $1 53,930 100% Complete Remaining balance to be returned to res erve . PD -07000 Mobile Command Vehic le Non - Infrastru cture Management Plan $700,000 5700,000 S0 $0 $0 50 $700,000 0% Consuructio n J un 2010 Vehicle currently under c onstruction. PD -08000 Crime Scene Evidence Co llection Vehicle Miscellaneous $130,000 5130,000 50 $0 $0 50 5130,000 0% Design Dec 2010 Received appro val for additional funding of $50,000 from Citizens Opti ons for Public Safety (COPS) to be reflected in FY 2010 mid -year b udget. PD -93012 Fire Commu nication s Computer Systems Miscellaneous $531,287 $1,645 50 $0 50 $1 51,644 100% Complete Remaining balance to be returned to reserve . PD -99013 Police Records Man agement System Misce llaneou s $526,435 56, 028 S0 50 $0 31 56,027 100% Complete Ren,inivg balance to be returned to infr astructure res erve at mid -year. Pagel Attachment 3 FY 2010 MI D -YEAR CAPITAL IMPROVEMENT PRO GRAM P ROJECTS STATUS GENERAL FUND PUBLIC WO RKS DEPA RTMENT Project Number Project Tale Project . - .. C atenary Tpfal , . Budget From I ueeptton F1 2010 A' atlable . 10ud ct FY 2010 Etpendtttutes FY 2010 FY 2010 P8? 2010 1 Labor .: . Cont wgeueies Lntiumbrarius 1Lensumn„ Percintt Adyustments Balance Compl ete : ` Project _ St atus Estimated - Completio n Date . Comments PE -00105 Embarca dero Road Median Improvemen ts Streets and Sid ewalks $126,502 $2,973 50 50 50 $0 $2,973 100% Complete Retraini ng balan ce will be retur ned to i nfrastructure reserve. PE -0O110 Co llege Terrace Park Improv ements Parks and Ope n Space 5395,687 56,842 5521 50 $0 55,340 5981 100 % Constr uction Oct 2010 C urre ntly in constructio n phase PE -01013 El Camin o Median Landscape Streets and Sidewalks 5445,003 $512 50 $0 $0 50 5512 10091 Complete Remaining bala nce will be retu rned to infrastructure reserve. PE -06001 San Antonio Bridge Structural Repairs & Main tenance Buildings and Facilities 596,469 - 591,429 $263 50 50 50 591,166 591 Constructio n starts Feb 2010 TBD City of P alo Alto Mai ntenance Agreeme nt . City of Mount ain Vi ew is the lead. PE -06005 U niversity Avenue Gatewa y Lan dscaping Improvemen ts Parks and Open Space 5237,217 59,136 5688 50 54,924 5266 $3,258 100% C omplete Waiti ng f or fi nal invoices. PE -07005 California Avenue Improv emen ts Parks an d Open Spa ce 5633, 226 $518,341 5137,685 50 $0 $268,909 $111,747 82% Design Jun 2010 Phase I: Tree repla nting plan is underway. Phase II: RFP to hire consultant in Feb 2410. PE -08004 Lytton Plaza Renov ation Parks an d Open Spac e 5748,800 5725 270 5589,013 $0 $0 5155,704 (519,447) 10391 C omplete Additional appropriation of $20,525.72 s ubmitted with mid -year CM R. Additio nal funding was received from the Friends of Lytton Plaza, LLC . PE -08005 Municipal Service Ce nter Resu rfacing Buildings and Fac ilitie s 51,655,336 5891,992 ' $307,144 $0 518,507 55,030 5561,311 66 % Complete Waiting for final in voices. PE -09002 Greer Park PhaseEV Parks and Open Space 51,891,017 51,721,652 554,825 $0 514,002 51.356,106 $296,719 84% Constructi on No v2010 PE -09004 Los A ltos Treatmen t Plan t Master Plan Study Land and Land Improv ements $160, 300 $28,195 $3,803 $0 50 524,392 50 100% Desigt TBD Consulta nt under contract. Preliminary design in progess . P1 X10002 V entura Community Cen ter and Park . Buildings and Facilities 5200,000 5200,000 57, 712 $0 50 535,000 $157,288 21 % CSD will take o ver the project with a new project PE -10006 Bridge Rail. A butment, and Deck Repair Streets and Sidewalks 5300,000 5300,000 5152.546 $0 53,970 511,905 5131,579 56% Complete Waiting for final in voices. Page 8 Attachment 3 FY 2010 MID -YEAR C APIT AL IMP ROVEMENT PROG RAM PROJECTS ST ATUS GENERAL FUND PUBLIC WORKS DEPARTMENT Project . .. Project. Project � Total Budget FY 2010 :. ELY 2010 FY 2010 FY 2010. FY 2010 Estimated' From _ Available Eape nditurts Labor Contingencies ...Entimbrances . Rentaining,,., . Percent -::Project. . Completion. ,:. . .. ,... .. ._. .0t .jAll II i •, p.`,41.�':i :',TP4"y ,. . 4ial,SEI +�t�l {fie X' ii X 141 i{1'{' PF-04000 Security System Improvements Buildi ngs and Facilities 5275,000 $63,349 $0 $0 $0 $0 $63,349 77% Constructio n Jun 2010 Work will be completed in FY 2010. PF-06001 Ted Thompson Garage Improvements Buildings a nd Facilities 567,000 567,000 $0 $0 50 50 567,000 0% Work to be compl eted in FY 2030. PF-07001 Cubberley Wing 1 Elevator Upgrade Buildings and Fac ilities $251,445 $201,308 $194,600 50 58,835 $0 (82,127) 101% C omplete Additional appropriation was pro vided to co ver salaries a nd be nefits. Actual allocation will be made at year end. PF-07003 Children's Theatre Fire/Life Safety 1Jpgrade Bu ildings and Facilities 5266,057 5232 ,830 50 $0 50 $15355 5217,475 18% Design J ut, 2010 Proje ct was on hold due to staff vacancy. Will be completed FY 2010. PF-07011 Roth Building Maintenan ce Buildings and Facilities $424,396 5263,510 $0 $0 $0 $0 5263,510 3896 O ngoi ng All i nitial work completed. Ongoi ng work to include roof and window repair to maintain i nt e'ity of struct ure. PF-08000 Art Cen ter K iln Hood Replacement Buildings an d Facilities $49,821 54,848 514,570 $0 SO $0 (59,722) 120 % Complete Additional appropriatio n will be made t0 cover project overspe nding . PF-09002 Lucie Stem Community Center and Theatre Ex terio r Paint Bu ildin gs and Facilitie s 580, 000 580,000 51,880 $0 $0 $0 578.120 2% Construction Ju n 2010 Construction to be completed FY 2010. PF-10000 Civ ic Cen ter Chiller D riv e Replacemen t Buildings an d Facilities 5125,000 $125,863 $803 $0 50 5125,000 $60 100 % Co nstructi on Jun 2010 Constr uction to be completed FY 20I0 , PF-10001 Rinconada Pool Plaster Bu ildings and Facilities 5200,000 5200,000 $103,828 $0 $10,272 55,704 580,196 60% Constr uctio n Oct 2009 Project is complete. Awaiting fi nal invoices . PP -10002 1 -o r "J" Cowper/Webster Stru ctural Repairs Bu ildings and Facilities 575. 000 575,000 $19,065 $0. $0 50 $55,935 25% Design Apr 2010 PO -10002 Downtown Tree Grates Miscellaneous $300,000 $300,000 $0 50 $0 SO $300,000 0% Page 9 Attachment 3 FY 2010 MID -YEAR CAPITAL IMP ROVEMENT PROGRAM PROJECTS ST ATUS GENERAL FUND PUBLIC WOR KS DEPARTMENT Project Project - :... J Total B udget FY 2010 FY 2010 FY 2010 FY 2010 FY 2019 Estimated Pro ecc From _Av ailable Expe ndit ure's.. Labor C antiogeucie: Encumbra nces Rem{' J p .. _ . Remai ning .Perce n# - ��Prodect,- � �Cwnpletlb n. 1. Pe r. . +Er}eF , �y� {pW� gg ^ tl``, .., ia}t .41dxT4 PE -00104 San A nto nio Road Median Improvements Streets a nd Sidewalks 51,302,275 $219,619 $179,796 50 $0 33,192 536 ,631 97 % C onstruction Ju n 2010 Phase I of the major renovations completed in Aug 2009. Phase 11 scheduled for FY 2010. PE -04010 Children 's Library Improv ements & Expansio n Buildings and Fa ciliti es 34,383,532 $170 $0 30 SO $1 $169 100 % C omplete Remai ni ng balance will be retur ned to i nfrastr ucture reserve. PE -04012 Mitchell Park Library & Community Center Improv emen ts Buildings and Facilities 51,817,994 $254,811 $66 $0 SO $2 $254,743 100% Complete Completed . Balance of $254,743 will be ret urned to i nfrastructure reserve . PE -04014 A nimal Shelter Expansion & Renovation Bu iIdings and Facilities 51,658 ,070 $77.780 $42,307 $0 316 .525 $11,840 $7,108 100% Complete Construction complete. Awaiting final project in voices . PE -05001 Photovoltaic Design and Installatio ns Non Infrastructure Man agemen t Plan 53,632,637 $131,843 $6,367 $0 $0 $83 3125,393 100% Complete Construction and warranty period has been completed. Remaini ng bala nce will be returned to infrastruct ure reserve. PE -05010 College Terrace Library Improvements Buildin gs an d Facilities $3,496, 823 52,777,776 $410,349 30 $3,394 $1,895,120 3468,913 87% Constructio n Oct 2010 Construction bega n Oct 19, 2009 . PE -05300 Arastradero Preserve Gateway Parks and Open Space $810, 052 5847 $0 $0 $0 $3 5844 100% Complete Retraining balance will be returned to infrastructure reserve. PE -06006 Alma Street Lav+«ape Improvements Streets and Sidewalks $131,217 $44,494 526,035 30 30 513,324 $5,135 9651 Complete Project complete. Awaiting fi nal project i nvoic es . PE -06007 Park Restroom Installation Parks and Open Space 5589,322 $535,147 $17,570 $0 $0 $58 $517,519 12% Design Dec 2010 Se al Park Restroom construction will comme nce the winter of 2009/2010 . PE -07007 Cu bbe riey Tu rf Renov ation Par ks and Open Space 51,809,936 51,618,986 5863504 30 $2,267 $244 ,851 $508,364 100% Complete Con stru ctio n complete. Project still under warra nty period. PE -09003 City Facility Parking Lo t Maintenance Buildings and Facilities 5330,000 5330,000 $0 $0 30 50 3330,000 0% Ong oi ng PE -09005 Downtown Library Impro vements Buildings • and Fac ilities $3,940,607 $3,862,445 $330,799 $O $0 $108246 $3.423,400 13% Design Mar 2010 Construction will start AprMay 2010. Page 10 Attachment 3 FY 2010 MID - YEAR CAPITAL IMPRO VEME NT PRO GRAM P ROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPA RTMENT -. Project J Project �,] _ . Budget2010- FY 2010 FY' 2010 . .. F1 2010 FY 2010 Project. . e J From Available E xpe nditures T.abar Cvnti ntiencies . -�; ncwubri n[x; Reunatinin=n. PerccnY .: Pro.tcct Estimated^:. Coxn tra a PE - 09006 Mitchell Park Library & Comm unity Cen ter (New Co nstruction) Building and Facilities $50,417,683 $49,908,659 $1,845,621 $O $0 $1,255,725 $46,807,513 7% Desi gn Sep 2012 Constructio n to begi n June 2010. PE -09010 Library & Commun ity Center Temporary Facilities Building and Facilities $663 ,866 $635.000 $141,817 $0 $120 $87,416 $405,647 39% Construction May 2010 Co ntraction wi11 start Feb 2010. PE -89004 Yacht Ha rbor Improv ements Buildings and Facilities $2 .103,106 $12,167 SO $0 $0 $2 .151 $10,016 100 % - Complete Remaini ng balance will be returned to i nfrastructure reserve. PE -95030 Downtown Pa rking Structu re Industrial Cost Pool Miscellan eous $33,425,251 $383 ,406 SO $0 $0 $0 $383,406 100 % Complete Remaining balanc e will be refunded to property owners through an abatement on property tax statements. PE•98003 Mitchell Park Facilities Parks and O pen Space $3,037,331 $75.064 $0 $0 $0 $0 $75,064 100 91 Complete R emaining balance will be returned to inf rastructure reserve. PE -98020 Public Safety Bu ildin g Bu ildings and Facilities $6,920,018 $3.236,082 $111,836 $0 SO $2,950,917 $173 ,329 97 % Design TBD Project currently on hold. PF-01002 Civic Ce nter Infrastructu re Impro vements Buildin gs and Facilities $14,228, 644 $6,264,988 $599,289 $0 $111,231 $1 ,010 .964 $4,543504 68% Design Mar 2010 Phase one of the major renov ations c ompleted in Aug 2009. Phase two to be bid a nd awarded FY2010 with co nstructio n completed in 2011 . PF•01004 Fire Station Improve me nts Buildings and Facilities $2,566,322 $269,330 $67,430 $0 $153,991 $18,969 $23.940 99% Complete Remai ni ng balance to be returned to infrastr uct ure reserve. PF-04010 Cubberley Mechanical & Electrical U pgrades Building and Facilities $1,614,695 $45.931 $9,369 $0 $0 SO $36.562 98% Desi gn Proje ct on hold due to staff vacancy a nd lack of capital funds. C onstruction phase to be rescheduled for a later fiscal year. PF-05002 Municipal Servic e Center Ren ovation Buildin gs and Facilities $561,308 $385,514 $0 $0 $0 $0 $385514 31 % Design Jun 2010 Design a nd bid phases to be completed FY 2010. PF-07000 A rt Center Electrical & Mechanical U pgrades Buildings and Facilities $1,787,046 $1,576,489 $185,663 $0 $16,513 $3,270— $1,371,043 23 %Design Dec2011 Fotndationsarchitect completi ng construction documents phase. C onstruction s ch eduled f or FY 2011 . Page 11 Attachm ent 3 FY 2010 MID -YEAR CAPI TAL IMPRO VEM ENT PROGR AM P ROJECTS ST ATUS INTERNAL SERVICE FUND TECHNOLOGY FUN D AD MINISTRATI'V'E SERVICES DEPORTMENT Project -, .Nu mber Project. �Project_ T itle ' Catego ry > Total Budget .: m r ` From : . - Inception ; Available et - Budget FY 2010_ .. -- FY 2010- : _ Expenditures L abor - .'djnstlge nts : FY 2010 Coutu�ettcies :,FY 2010 .Encumbrances -� Renoir' ling Balance B udget Percent- - Project 3 ct Complete Sttiis Estimated.: Completion Date Comme nts.._ TE 01006 Enterprise Backup Solution Minor $139,512 $69,512 $8S5 SO $0 $1 $68.626 51% Pre -design Dec 2010 Work delayed due to workload issues. TE-0I012 IT Disaster Recove ry Plan Minor $840,000 $509,897 $186 50 $0 $1 $509 ,710 39% Construction Dec 2010 A draft dicaet er reco very pl an has bee n completed. Th-05003 In ternet Site Upgrade Minor $240,000 $74,107 531,845 50 $0 $0 842,262 82% Constructio n Dec 2010 Implementation of the i nternet is complete. Th e p ortion of the contr act dealing with the intraaet is 50 % complete . T E-06002 9-1-1 Emergency Phone System Upgade Min or 5324,000 527,274 SO 80 $0 $3 $27,271 92% Complete Fu nds will be ret urned to funding so urce, after all invoices ha ve be en p aid. CIP will be closed at the e nd of the fiscal year . TE-07001 Emergency Notification System Mino r 5150,000 550,000 $50,000 $0 $0 50 $0 100% C omplete Project is complete a nd will be closed. Page 12 FY 2010 MID - YE AR CAPIT AL IMP ROVEMENT PROGRAM PROJECTS STAT US INTERNAL SERVICE FUND TECHNOLOG Y FUN D ADMINISTRATIVE SERVICES DEPARTMENT Attachment 3 Project - Project _;:Ct Project - aors Total_ ._ Budget Available From • Budget inception1. 2010 • FY 2010 J xpenditures Labor &diime nts _ FY 2010 Cont nces FY 2010 " 'En cumbrnces1 -._ _._._ Remai ning • ----Balane_ _ .,-._ .. _ ._-. m .� .______ Budget........ .... • Percent Project•Ttie Cmplete Status fon mraetits TE-07002 Police Auto- Citation System Minor $125,000 $125,000 $57,809 SO SO $5,780 $61,411 51% Pre -design Jun 2010 A ve ndor has bee n selected and hardware is being configu red and tested. T E08000 Library Techn ology Plan Mino r $75,000 $22.766 $4,000 $0 $0 $0 $18.766 75% Complete Funds will be returned to funding source, after all invoices have been paid. CEP will be cl osed at the end of the fiscal year . TE-08003 F ire Radio Communication s Equ ipment Minor $102,000 $7,179 SO SO $0 $0 $7,179 93% Complete Work is being finalized a nd OP will be closed at the e nd of the fiscal year. TE-08004 Fire Mobile D ata Computer Minor $250, 000 $70 ,702 $1 .042 $0 SO $366 $69,292 72% Constructio n Dec 2010 TT is working with Fire Departm ent a nd Fleet Ma nagement to install mobile data computers. '1'E-09000 Public Safety Computer -Aided Dispatch Replacement Minor 81, 300. 000 51,300,000 50 $0 50 SO 51,300,000 0% Pre -desig n Jun 2011 A vendor has been selected and negotiations are in progress. TE-09001 Fiber Optic r n,nm,mic atio ns to Remo te Radio Sites Minor 5153,000 $0 $0 $0 $0 $0 $0 100% Complete Project is c omplete a nd will be cl osed. Page 13 FY 2010 MID -YEAR. CAPITAL IMPROVEMENT P ROGRAM PROJECTS ST AT US INTERNAL SER VICE FU NII TECHNOLOGY FUND ADMINISTRATIV E SE RVICES DEPARTMENT Attachment 3 Project Number;::.;.... Project __. Title _ Project: Category Total Budget From _ I nceptio n Available Bridget 1," Y2010 fl 2010 i:apenditures.._ - Labor I 2010 :_4diu ipen1s ,,. _Coutingencse,.: FY 2010 _Encumbrance~ 1, Rernar nma — — Budget Perce nt ' Complete_ Project ::Stat us___; Esirrnatc�l";. Comgletiou'' „ Pal e,, _ _Co n}menti _,Aalance._.: TE-95016 Pe rmit Information Tracldn g System Multi - Yea: - 5980,050 $213,291 $2,915 $0 $0 $41,051 $169,325 83 % Co nstru cti on Dec 2010 Fire Razmat p ermits h ave been implemented. T E-02013 Institution al Network (1 -Net) Multi -Year $1 ,000,000 $824,311 $35,100 $0 s0 $95,100 $694,1I1 31% Co nstr uctio n Dec 2010 All major facilities in the City have bee n co nnected via fiber optic cable. TE-02016 Enterprise Resource Plann ing Multi -Year $5,018,476 $102,526 $0 $0 s0 $0 $102,526 98 % C omplete Funds will be retur ned to funding so urce, after all invoices have been paid. ClP will be closed at the end of the fiscal year. TE-07006 SAP Con tin uou s Impro vement Project Multi -Year $7,000,000 $1,353,675 $886 ,765 s0 $0 $416,193 $50 .717 99% Complete Fu nds will be ret urned to f unding source, after all i nvoices ha ve been paid. CIP will be closed at the end of the fiscal y ear . TE-99010 Acquisition of N ew Computers Mu lti -Y ear $287,350 $142,599 $0 50 $0 50 $142,599 50% Construction Dec 2010 This is an o ng oi ng fund for the acq uisition of new comp uters . TE-00010ITE-00021 Telephone System Replacement Mu lti -Year $1,130,000 $1,123,969 5308 50 $0 $20,846 51,102,815 2% Pre -design De c 2010 The telecommu nicati ons consultant has been collecting inventory i nform atio n and is in the prw of inter viewing represe ntatives of each department. TE-02015 Citywide G IS D ata, Infr astructure and Applica tions Multi -Y ear 51,770,322 $822,144 $102,199 $0 $0 $138,743 $581,202 67% Construction Dec 2010 Work co ntinuing on i ncorporati ng new mappi ng applicatio ns. TE-05000 Radio In frastructure Re placement Multi -Year $1,180,980 $723,191 $0 $0 $0 $79,633 $643,558 46% Co nstru ctio n De c 2010 This proje ct is o ngoing. TE-06001 Libr ary Radio Frequen cy Identification (RFID) Implemen tation Multi -Year $45,000 527,600 $186 $0 $0 $1 $27,413 39% Construction Jun 2013 The inte nt is to carry this f unding o ver to FY 2011, add fundi ng and utili ze for implementation per Library Technology Pla n. eRPID�g implementation it being coordinated with the Library Construction/Rem odeli ng Projects. Page 14 FY 2010 MID -YE AR CAPITAL IMPRO VEMENT P ROGRAM PROJECTS STATUS INTERNAL SERVICE FU ND TECHNOLOG Y FUND AD MINISTRATIVE SER VICES DEPA RTMENT Atta chment 3 Total Budget .4 .yailable... B udget Estimrtted Project l>oject Project From Budget FY 2010 L abor FY 2010 FY 2010 Remaining Percent Project Completion N umber TitleCategors- Inception . _ Fl 2010 Eveudit ures , _._A ustmeuts Contingent* E ncumbra nces._ __Balance m � Compleie____._ Stat us _u __. Pates. TE-07000 En terprise Application Infrastructure Upgrade Multi -Year 11,787,000 1726,362 $45,503 $0 10 12,126 1678,733 62% C onstructi on Dec 2010 Merged with TE-02014. Conti nuing enhancements to the user i nterface for Utility Billi ng System. TE-07003 Bill and Payment Processing Multi -Year 1220 ,000 $23,450 SO $0 10 123,450 $0 100% C omplete Fu nds will be returned to fundi ng source, after all i nvoices have been paid . CIP will be closed at the e nd of the fiscal year. TE 08002 Electric Patient Care Report Multi -Y ear 165,000 139,943 19,158 10 SO $497 $30.288 53 % Complete Fu nds will be returned to funding source. after all i nvoices ha ve been paid . CIP will be closed at the end of the fiscal year. T E-10000 Collections Software Multi -Y ea r $79,800 179,800 10 SO 10 10 $79.800 0% Pre -desig n Jun 2011 RFP is being prepared . Page 15 FY 201011 -YEAR C APIT AL IMPROVEMENT PROG RAM P ROJECTS STATUS IN TERNAL SER VICE FUND V EHICLE REPLACEME NT AND MAINT ENANCE FUND PUBLIC WORSS DEPARTMENT Attachment 3 ' ... Project '. Number l'ny`'.i .. _ ... .. .. - -.. '. . .._ .;.: ... ,. _ -. .. . `. ..: Project . ; _. . �:^ 0 ' 1 -t t.jir I.'. r A Le : ,jt - oxipuj? is 71/7777j: R' rn . -. .. .. Project C ategory - ..Total-. Budget - .. .: From --Inception " A vailable. Folded - FY.2010 .. FT 7010 L pendillrr e5 • .:re 201U . - i_abor. 1-Adjusiments 2 - - _Budget FT 22010 _ FY '010 Reinattnn ' Percent ConUnencies - .I F.ncurubranoes I. :-lit ai'Ince.,.'-. ' COmtslete ': .. A oJecl ... Status �' Ltinrtnd CompIrate) - Date. _ - Comment s VR -0000I MSC Fuel Stor age Tank Replacement Min or $225,000 $9,900 $1 .315 $0 $0 $0 $8585 96% Complete Funds will be returned to funding source, after all i nvoices have been paid VR-01000 MSC Equipment Maintenan ce Facility Mezza nine St orage Area Minor $275,000 $16,478 $0 $0 $0 00 016 ,478 94% Com plete - Funds will be retur ned to f unding source, after all invoices have been p aid . VR-0I001 MSC Furl Stora ge Tan k /Svc Island Replacement Minor 01,616,860 9327,888 $144,716 ' $0 $0 $182,426 0746 100% Construction Jun 2010 Liquid and Compressed Natural G as (CNG) faciliti es ate complete and in service. Public CNG dispenser is complete, but compressor needs repairs, and a new sn ail CNG r at e ,Keels to be d eveloped VR- 01002 MSC Equipment Washing Facility U pgr ade Minor 0681.394 $0 SO $0 SO $0 $0 100 90 On Hold TBD On hold P-.tin2 funding . V R-05001 Fuld Service Truck Mino r $125,000 0367 $0 $0 00 01 0366 I00%C o mplete Funds well be returned to funding source, after all invoices have been paid VR-06801 Replace City -Wide Fuel Transaction an d In ventory Manage ment System Minor $285,000 $285,000 911.9,248 SO 00 $43,225 5122,527 57 % Ongoing J un 2010 Site hardware has been delivered , and softwar e upgrades have been installed V R-07001 Au tomated Mola r Po ol Reservatio n and Vehicle K ey Management System Minor 9105,000 080,258 $0 SO . $0 $0 $80,258 24 % O ngoing b un 2010 System has bee n impl eme nted at M unicipal Servic e C enter (MSC). Second phase will include Ci vic Center . VR-07300 Scheduled Ve hic le and Equipment Replantin g= Minor $3.784. 000 $611,145 $539,406 $0 $0 $53,700 318 .042 100 % Complete F unds will be returned to funding source, aft er all i nvoices have be en p aid. VR-08000 V hiclr Replacement Minor 02,500,000 $1,052, 700 $847,726 $0 $0 319,612 $185,362 93 % Complete Funds will be returned to f undi ng s ecre t after all i nvoices ha ve been paid VR -08001 New Vehicles (2) For U tility Operations M inor 970,000 $24,035 $0 00 $0 30 $24,035 66% Compl ete Funds will be returned to f unding so urce. after all invoices have b ee n paid. Page 16 FY 2010 MID -YEAR CAPITAL IMPROVEMENT PROGRAM P ROJECTS ST ATUS INTERNAL SE RVICE FUN D VEWCLE REPLACEME NT AND MAINTENA NCE FU ND PUBLIC WORKS D EPARTMENT Attachment 3 Project Nhmnbcr Project Category - Toted Budget Front 1neeliRon - A vailable F'Y2010 - Budget • - , Estimated , Budgei EY 2010 -L abor -. FY 2010 -FY 2010 &e nr:siLang Percent - Prnjest. . -Chmpletion - Pr 2020 Expeactitures,ud,itfi inerd5^' Contirutencics E ncumbrinces E8eluntr, -: . Coal bin $tatt6-.:. .. Da e - 51,793,844 C a i V R-09000 Vthiele Replacement Min or $2.545,000 $272,603 $79.682 $1,441,559 43% O ug oies 7 2010 Awaiting purchase and deli very of se veral vehicles. V R-04010 Vehicle Mnintenance Facility Upgr ades Multi -Year $610,000 9288,794 $10,229 $0 122,864 9255.701 5S% O ngoing Jun 2010 Ongoi ng, awaiting delivery of equipme nt . VR -07002 Diesel T ruck Eo gin c Emissio ns Retrofits M ulti -Year 9685,000 $513,692 $292,291 $221,401 68% Mar 2010 Ongoi ng, retrofit of next group of vehicles is nearly c omplete . VR-92006 Fad Tan k Storage1Upgrade M ulti -Year 9341 ,000 $87 .351 $16 ,113 $135 171,103 799 6 Design Dec 2010 Project soopc seduced den to imd gmrc fwrling . Esti mat ed hid d ate Spring 2010. Page 17 FY 2010 MIDYE AR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FU ND ELECTRIC FUND UTILITIES DEPARTME NT Attachment 3 Proj ect J Number Project J Title ' - . Proj ect J Category- < font. ' - ._, _.. .. B udget acsl1apie Budget Estimated Fr om B _ .. :: Percent Proje ct Completion Budget FY %S 2010 1 42410 Rem aining J p ' Inception FY 2010 Expenditures Continaenciea Encumbrances . Bstlance; Cotnplet e = Status Date -: Comme nts -" EL -04010 Foothills System Rebuild Minor $850,000 $103,450 $0 $0 $0 $103,450 88% Pre -design Ju n 2010 Scoping and preliminary design work in progress. EL -09004 W. Charlesto n/Wiilde Way to Sou th City Limit 41I2 kV Co nversion Minor 3500,000 $498,206 $23,217 30 $243 $474,746 5% Design Dec 2010 Scope defi ned , p relimin ary design completed. This pr oject is being engineered a nd co nstructed in concurre nce with the Park Bl vd 4/12 kV Conversion (EL -06000) and El Cami no Undergr ound R ebuild (EL -05000) pr ojects . EL -10008 Advanced Metering In frastru cture System Minor 3210,000 $210,000 3145 30 $100,000 3109,855 48% Design Ju n 2011 Request for Proposal (RFP) was iss ued for a consultant to assist with analysis of the feasibility of implementati on of smart grid technology in Palo Alto. Bids are being evaluated. , EL -02010 SCADA System Upgrades Multi -Y ear $670,000 $119,914 $74,451 $0 $104 $45,359 93 % Construction J un 2012 In constructi on. This project in volves upgradi ng Supervisory Control & Data Acquisitions (SCA DA) computer hardware and software. It is being do ne in phases and in conjunctio n with EL - 06003 Upgrading Utilities Control Center (UCC). SCADA Commissioni ng of WGW i ntegration nearly complete. EL -03001 Un dergroun d District 4! Multi -Year 33,800,000 3261,880 30 30 $0 3261,880 93% Complete Project is completed and the electric lines have been remo ved a nd the poles toped above the telephone lines. AT&T will be remo vi ng the p oles once they have transferred the telephone services. Funds will be retur n to reserves at year- e nd EL -03005 Sherman/E! Ca mino/Page Mill/Park UG Con version District 439 Multi -Year $3,095,000 354,987 $0 S0 $0 354,987 98% Complete Funds will be return to reserves at year- end_ EL -03013 U tilities Estimating System Multi -Y ear $325,000 $15,094 $0 30 $0 $15, 094 95% C omplete System i nstalled . F unds will be retur n to reserves at year-end. Page 18 FY 2010 MID -YEAR CAPITAL IMPRO VEMENT PRO GRAM PROJECTS ST ATUS ENTERP RISE FU ND ELECTRIC FUN D UTILITIES DEPA RTMENT 'rural Budget A vailabl e.... , ., ..... Pr oject "Protect From I ud et F t 2010 FY 2010 :: F4" 010 Rem arrnii TitEe Category,. Inception YI 2010 Expenditures Co nti ngencies- E nCumbra nces .Bala nce 1rt [ern a;.f{` i. »;""" ,n7.<..` r., Atta chme nt 3 Budget Pe rcent . Estimated Completion- _. Date Comme nts EL -04012 Utility Site Security Improv emen ts Multi -Year $890,000 $776,811 $84,690 $0 $154 ,516 $537 ,605 40 % Co nstructio n Feb 2010 Co nduit and equipment installation complete. Testing and commissioni ng in progress . EL - 040I4 A utomated Meter Reading System M ulti -Year 51,334,000 $297,142 50 $0 $3 $297,139 78% C omplete Pilot is completed, except f or ongoing mai nte na nce of installed system Staff is analyzing install ation and will use information during Sma rt Grid Feasibility Study (EL -10008) EL -05000 El Camino Un derground Rebuild Multi -Year 51,600,000 $691,077 $210,443 50 $32,643 5447,991 72% Desig n and Dec 2010 Construction The project has bee n divided i nto phases. Phase I constructi on is completed and Phase 2 constr uction is in progress a nd engineeri ng on phases 3-6 are c ompl eted. The remaini ng phases of the pr oject are being coordin ated with the development projects at Elks Lodge and PA BowL T his project is bei ng engi neered and co nstructed in concurrence with the Park Blvd 4/12 kV Con versio n (EL -06000) a nd W. Charlest on/Wilkie Way 4/12 kV C onversion (EL -09004) projects. EL -05001 Colorado Switch Station 115kV Bu s Installation Mu lti -Year $3,780,000 $1,143,983 $0 $0 $0 $1,143,983 70 % Complete Power E ngineers' estimated project cost is $5.4 milli on f or substation work plus $1 millio n for PG&E 115kV line rearrangement work. C ost/benefit ratio of pr oposed work is n ot favorable and project will not be pursued_ Incorporated into 230kV Intertie Study EL -06001_ EL -05003 Relocation - Alma Substatio n Multi -Year 52,435,000 $2,067 SO $0 $2,067 100% Complete Funds will be return to reserves at year- end. Page 19 FY 2010 MID -YEAR CAPITAL IMPROVEMENT PR OGRAM PR OJE CTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT Attachment 3 Project 1 Number -Pr oject J '''' Title P Total Budget, I. ailable . Project .: T roi m. J Budget .'. FY 2010 I Y 2010: Catego ry , Inceptio n EY 2010 Expe nditures Contingenci es : FY 2010 Fnc unibra nces Remai ning ::Bala nce Budget Percent Complete Estimated Project Completion Status Date Contine nts EL -06000 Park Blvd. 4/12kV Co nversion Multi -Yea r $385,000 $50,661 $4,893 $0 $0 $45 ,768 88% Co nstructio n Jun 2010 Design is completed for about 80 % and construction is in pr ogress . Remai ni ng design w ork is in progress and construction is scheduled for completi on in J un 2010 . EL -06001 230 KV Electric Intertie Multi -Year 5500,000 $134,813 50 50 $0 3134,813 73% Complete Feasibility study c ompleted. Department of Energy has written a letter to City stating that SLAG will not participate in the i ntercon nectio n, therefore the project is not feasible . EL -06002 Undergro un d D istrict 45 Mu lti -Year 53,200,000 $2,776,091 5639,624 50 51,907,373 5229,094 93% Construction Dec 2010 District formed. Substructure design complete . Constr uctio n begins No v 2009 through Ju n 2010 . Cable design and estimate in progress . EL -06003 Utility Control Cen ter Upgrades Mu lti -Year 5500,000 5391,264 5234,681 50 5148,594 $7,989 98% Design J un 2010 Contract awarded. Implementatio n on - gam& EL -08000 E. Charleston 4/12kV Conversion Mu lti -Year 5200, 000 5198,474 $14,998 50 $0 $183,476 8% Design Jun 2010 Pr eliminary design work started and is expected to be completed by Jun 2010. EL -08002 E. Meadow/A lma/Loma 4/12kV Con version Mu lti -Year $660,000 $595,787 $19,801 $0 S913,000 (5337,014) 15I% Design Jun 2010 Design complete . Invitati on for bids (IFB) to be issued pending legal review. Construction to start Mar 2010 . Requested additional funding of $500 K and i ncluded as a mid -year adjustment .. EL -09000 Middlefield Un dergro und Rebu ild Mu lti -Year 575,000 575,000 $0 $0 50 $75,000 0% Desig n Jun 2010 Preliminary design work started and is expected to be completed by Ju n 2010. EL -09002 Middlefield/Colorado 4/12 kV Conversion Multi -Year $20;000 520,000 50 $0 50 520,000 0% Design J un 2011 Preliminary design work to start in lan 2010. EL -09003 Rebu ild UG District 17 (Downtown) Multi -Y ear 51.100,000 51,086,050 530,725 50 $538,388 5516,937 53% Construction Jun 2010 S ubstruct ure in progress. EL -10006 Rebuild UG District 24 Mu lti -Year 5585,000 5582,526 $28,513 30 5484,442 569.571 88% C onstructio n Oct 2010 Substructure installation complete. Electrical design work in progress . Page 20 FY 2010 MID -YE AR CAPITAL IMPR OVEMENT PROGRAM PROJECTS ST ATUS ENTERPRISE FUND ELECTRI C FUND UTILITIES DEPA RTMENT Project Number' Project • Project Category Total IYurlget Available ' .. From Budget I nception FY .2010. Attachment 3 FY 2010 FY 2010 FY 2010 Expenditures Carotin n&es Enctmiliz'aaecs Budget Remaini ng Percent ' „Bala:nee_,.,.. Complete Project Estimated Cnmptetian . Construction is 99% completed. EL -11005 California Ave. Business Distric t Rebuild (District 22) M ulti -Year $2,300,000 $40I ,889 $272,810 $0 $25,988 $103,091 96 % Constr uctio n Feb 20/0 EL -1'. 1008 Re build UG D istrict 19 M ulti - Year $560,000 $559,372 $876 $0 $147,672 $410,824 27% Constructio n Dec 2010 Substructure installatio n completed. Cable design and estimate on hold . EL -10009 Street Light System Conversion Project Multi -Year $100,000 $100,000 $6 ,553 $0 $5,047 $88,400 12 91 Ongoing Ju n 2011 Eval uating various LED street light fixtures and developing specificatio n for ordering stre et light fixt ures to use in Palo Alto. Page 21 GS -00011 GS -01019 FY 2010 MID -YEAR C APITAL IMPROVEMENT PROGRAM P ROJECTS STATUS ENTERPRISE FU ND GAS FUND UTILITIES DEP ARTME NT GS -03010 GS -07000 GS -08000 GS -09000 GS -10000 GS -10002 GS -10003 GS -08011 GS -09002 GS -10001 CNG Sequential Fuel System Elwell Cou rt T en ant Improv ements Gas Station 2 Rebuild Gas Station 1 Rebuild Gas Station 3 Rebu ild Gen era l Shop Toolin g Cathodic Cu rrent In terrupters Compress Natural G as Station l'otat B udget Project From Cateory Ittce ti on 375,000 Minor $50,000 Multi -Y ear Global Position in g System Multi -Year GMR - Project 18 G MR - Project 19 GMR - Project 20 Multi -Year Multi -Year Multi -Year $207,000 $201,000 5207,000 $381,000 $5,928,000 Available. Budget FY 1010- 335,715 3203,584 3201,000 364,000 3300,000 $118,863 $5,447,844 5431,932 3181,564 Attachment 3 FY 201.0 FY 2010 Conti nge ncies Encumbrances 335,715 $203,001 5201,000 3207,000 $2,946 330,251 Budget Estimated Remaini ng P erce nt Project Completion Completion; _Bal ance Complete Statu s Date :_ . $44,619 100% C omplete 11 % Complete 100% Desig n $0 100 % Desig n $0 100% Desig n $300,000 $118,863 35,236,029 $431,542 5644,000 5% Desig n Complete Co nstr uctio n 35% Desig n 0% Pre -design 0% Pre -desig n Funds will be ret urn to reserves at year-end . Repackaging Request for Proposal (RFP) out to bid J un 2010, constructio n FY 2011. Repack aging Request for Proposal (RFP) o ut to bid J un 2010, constructio n FY 2011 . Repackaging Req uest f or Proposal (RFP) o ut to bid Jun 2010, constr uction FY 2011 . Integrating field data into mappi ng system, defini ng additio nal equipme nt needs . Aug 2011 Aug 2011 Aug 2011 Ju n 2010 J un 2010 J un 2010 Jul 2011 J ul 2012 Desig n will start upon completio n of Gas Main Replacement (GMR) 18 design. Jul 2013 Design will start upo n completion of Gas Main Replaceme nt ( GMR) 19 design . Page 22 FY 2010 MID -Y EA R CAPIT AL IMPROVEMENT P ROGR AM P ROJECTS STATUS ENTERPRISE FUN D WATER FUN D UTILITIES DEP ARTMENT Attachment 3 Total ,. . B udget':. ' . _ �rail ahleB udget Estirpiated J J 3B udget _::. FY 2010 FY 2010 FY2010 Remaini ng- Percent Project : ; Completion Pro-fCf - . � '. Project �= "- :PTO Project ... � From.� . .. N umber Title Category Inception FY 2010 .r Expendit ures Conti nge ncies Encumbrances Balance Complete .. Status::,: Date Cott -talents WS -01014 Lan d Acqu isition for a reservo ir, a we ll an d pump station . Minor $2,000,000 $62 $0 $0 $0 $62 100% C omplete Fu nds will be return to reserves at year-e nd . WS -09000 Seismic Water Tan k Valve Minor $800,000 $799,858 $142 $0 SO $799,716 0% Design . No v 2010 Desig n co nsulta nt selected . Co nstruction to start May 2010. WS -01010 Reservoir Bo oster Improvemen ts Mu lti -Year $5,214,015 $24,644 SO $0 $0 $24,644 100 % Complete Fu nds will be retur n to reser ves at year-e nd. WS -07000 Water Regulation Station Improve ments Multi -Year 51,070,000 $1,050,438 $15,850 50 $0 $1,034,588 3% D esig n No v 2010 Design co nsulta nt selected . C onstr ucti on to start May 2010 . WS -07001 Water Recyclin g Facilities Mu lti -Ye ar 5600,000 5278,728 $1,345 SO 8105 5277,278 54% Pre -Desig n Ju n 2010 The pre -desig n planning of a recl aimed water pipeli ne to cust omers in the Sta nford Research Park is in progress. WS -07004 Water Syste m Portable Emergen cy Gen erato rs Multi -Year 5466,000 8208,833 SO SO 52 5208,831 55 % Co nstructio n Ju12010 Purchasing additional generators . WS -08001 Water Reservoir Co ating Improvemen ts Mu lti -Year 52,050,000 52,049,716 8284 SO 50 52,049,432 0% Desig n Nov 2010 Design consultant selected. Co nstructio n to start May 2010. WS -08002 Emergen cy Water Supply Project Mu lti -Y ear 836,650,000 531,797,171 $3,952,829 574,313 $7,179,644 $20,590,385 44% Design Dec 2012 Design consultant desig nated with design acti vity starti ng in Dec 2009. Construction to start No v 2010. Page 23 FY 2010 MID -YEA R CAPITAL IMP ROVEMENT PROGRAM P ROJECTS STATUS ENTERPRISE FU ND WATER FUND UTILITIES DEPARTM ENT Attachment 3 Project Project::, Number .. Titl e . ..B udget ,'i;iailable' . Project 7 From '. Budget "` I Y 2010 Category. .Inception FY: 2010 E xpenditures.. B udget Estimated IN- 2010'; FY 2010 Reneu nin Percent . Protect Completio n C ontingencies Encumb rances B alance Cotiipl ete =Status, lYatO Comrtiettts_::` WS -08017 WMR - Project 22 M u1d-Year $2 ,963,000 $2,742,483 $312,390 $0 $2,550 ,879 (5120,786) 104% Construction Oct 2010 S ubmitt ed b udget nb ange request for additio nal fu nding of $200K to be included as mid -year adjustme nt WS -0900I WMR - Project 23 Multi -Year $3,085,000 $3,076,982 $283,123 $0 $60,000 $2,733,859 5% Design Oct 2011 Project to be designed duri ng integratio n of WGW Mappi ng and GIS systems . Co nstruction to start 3rd q uarter 2010 . WS-I000I WMR - Project 24 Multi -Year $292,000 $292,000 $14,538 $0 $0 $277,462 5% Design Oct 2011 Project to be designed duri ng i ntegratio n of WGW Mapping a nd GIS systems . Co nstructi on to start 3rd q ua rter 2010 . Page 24 Yrgject Project Project Number Title Category FY 2010 IMO -YEAR C APITAL IMPROVEMENT P ROG RAM PR OJ ECTS STATUS ENTERPRISE FUND WASTEWATER C OLLECTION FUND UTILITIES DEPARTMENT B udget From Inceptio n Attachment 3 Budget Percent Complete ' Page 25 FY 2010 MW - YEAR CAPIT AL IMPROV EMENT PR OGRAM PROJECTS STATUS ENTERP RISE FUND REFUSE FUN D PUBLIC WO RKS DEPA RTMENT RF' -09002 Byxbee Park Gas Collectio n Systems Upgrade RF-09003 Recycling in Bu siness D istrict RF-09004 LATP Site Dev elopmen t Preparation R F-10002 Flare Relocation Project RF-07001 Re locatio n of Landfill Facilities RF-10003 Dryin g Beds, Material Storage and Transfer Area Attachment 3 Total .B udget A' .uLtb1e B udget Pr oject. b rom ' y 2010t E xpe nditures Cgmm, tits" 1 Y 2010 Remaining - Percent M 1+ Y'201t3 F� 2010 Categorti �. Incept on F Ype Encumbrances B al ance .-`: . Complete i nor Mi n Min or Mu lti -Year Mu lti -Y ear 5500,000 $325,000 $200,000 $400,000 $1,500,000 5125,000 $61,749 50 $0 SO $61,749 88% Estirrrated • • Project - { orrtpletion Status • .. D ale_ Co ua uaents`'; Complete Funds will be return to reserves at ye ar- e nd. $325,000 $0 $0 $0 $325,000 5% Desig n Ju n 2010 A new Palo Alto -branded co ntai ner desig n has bee n de veloped a nd is being ro uted thr ough the design review process . $74,891 $23,705 $0 $50,654 $532 100 % Design TB D Consulta nt is perf orming e nviro nme nt al risk assessme nt for clean up of site . Waiti ng for regulat ory approvals. $399,907 $31 ,540 $0 $87,460 $280,907 30% Desig n Dec 2010 A consulta nt is curre ntly worki ng on the desig n and permitting of the new flare. Req uested an additio nal $200,000 for co nstructio n phase in FY 2010 . 81,355,613 $85,913 $106,349 $0 $0 $0 $48,882 $8,613 $1,200,382 $77 ,300 20% Desig n TBD 38 % Pre -Design TB D The relocatio n of th e landfill scale, tollbooth a nd offic e has bee n completed. The relocation of the Recycling Center and a permane nt Ho useh old Hazardous Waste (IIHW) facility are i ncluded in the Feasibility Study for the former Los Altos Treatme nt Plant (LATP) site . The results of the feasibility study are to be presented to C ouncil in Mar 2010. These facilities are incl uded in the Fe asibility Study f or the former Los Altos Treatme nt Pla nt (LATP) site. The results of the feasibility study are to be presented to Cou ncil in Mar 2010. Page 26 SD -08101 Alma Street Storm Drain Improvemen ts Mi nor FY 2010 MID- Y EA R CAPITAL IMPR OVEMENT PROGRAM P ROJECTS STAT US ENTERPRISE FUND STORM DRAINAGE FUND PUBLIC WORKS DEPARTMENT 'total. Budget. From . Inceptio n $784,859 $128,850 $0 $540 ,624 $115,385 86% $830,081 Attachment 3 FY. 2010 EY 2010, Co ntinge ncies .E ncumbrances Estimated . Project Co mpletion'. Sfatns; =. Date, Constr uction Feb 2010 Design performed by in-ho use staff . Constructi on c ontract awarded to Peak F ngineering, Inc. in Sep 2009. SD -06102 San Fr an cisgn ito Creek Storm Water Pump Station Multi -Year $6,373,312 $404,696 $227,726 $46,507 $81,645 $45,818 99% Post - constructio n mainte nance & mo nit ori ng Tu n 2010 La ndscape mai ntena nce a nd mitigatio n m onit ori ng are the o nly remaini ng tasks . SD -06104 Conn ect Clara Drive Storm Drains to Matadero Pump Station Mu lti -Year $953,480 $1 $0 80 SO $1 100% Pre -D esign On h old. SD -11101 Char ming Aven ue/Lin coln Avenu e Multi -Year Storm Drain Improv emen ts $820,000 5$20,000 $85 $0 $0 5819,915 0% Desig n Nov 2010 Desig n being performed by i n-house staff. Page 27 FY 2010 MID -YE AR CAPITAL IMPROVEMENT PROGRAM P ROJECTS STAT US ENTERPRISE FU ND WASTEWATE R TREATMENT FUND PUBLIC WOR KS DEPARTMENT Atta chment 3 Total .. Budget Availabl e: Budget 1 Project Project .. Pro ect Frot n Budget l' 2010 FY 2010 FY 2010 Remaining Percent ',nmbcr litic Categ ory I nception !r'1; 20 .10 Expenditures E;orrti ngenctes E ncumbrances Balance C omplete Planni ng &tirnated Completion Date Goal to issue Request for Proposal (RFP) in Spring 2009 . WQ-10001 Plan t Master Plan Mi nor $500,000 $500,000 $0 $0 $0 $500 ,000 0% J un 2012 Ka�a 'ria-3„y rr'A, WQ-04010 Replacement ofEyistimt Reclaimed Water Pipes Multi -Year $16,800,000 $1,119,612 $14,497 $0 $738,159 $366,956 98 % Complete Construction completed, 99.2% reimbursed from state on gra nts a nd loa n; waiti ng to sign Title XVI federal agreement with United States Bureau of Reclamation (USBR) for another $4.5 millio n grant for City of Palo Alto and City of Mo untain View. E ncumbrances are unused continge ncy accounts which will be close. WQ-04011 Facility Con dition Assessmen t and Retrofit Mu lti -Year $3,250,000 $1,879,047 $84 ,087 $0 $128,711 $1,666,249 49% Design Dec 2010 Ongoing retrofit projects . WQ-06014 Disinfection Facility Improv ement Program Multi -Year $21,468,987 $20,395,091 $1,993.962 $0 $6,843 ,965 $11,557 ,164 46% Co nstructio n Dec 2010 Page 28 Attachment 4 Continuous Capital Projects - Five Years' of Expenditures Project Category FY 2010 Department/Fund Protect Title 12/31/09 FY 2009 FY 2008 FY 2007 FY 2006 Community Services : Land & Land Improvements AC -86017 Art in Public Places Streets & Sidewalks Planning & Community Environment : PL -05030 Traffic Signal Upgrades $12,272 $21,556 $64,410 $29,545 $112,256 1,986 39,983 35,908 30,524 60,142 Public Works - General Fund : Street Improvements (Street Improvement Streets & Sidewalks PE -86070 Fund) 1,529,000 3,702,381 3,368,496 4,987,364 2,304,729 Building & Facilities PF-00006 Rooting Replacement 164,983 21,073 256,831 76,769 37,914 Building & Facilities PF-01003 Building Systems Improvements 2,086 114,152 34,304 64,312 54,902 Building & Facilities PF-02022 Facility Interior Finishes 3,250 47,116 65,797 10,579 47,029 Building & Facilities PF-93009 ADA Compliance 100,571 121,617 49,955 96,587 204,495 Streets & Sidewalks PO -05054 Street lights Improvements 3,122 15,970 11,814 19,077 84,785 Streets & Sidewalks PO -89003 Sidewalk Improvements 310,889 1,675,527 2,030,796 2,299,543 2,197,218 Public Works - Storm Drainage Fund : SD -06101 Storm Drain System Replacement Public Works - Wastewater Treatment Fund : WQ-80021 RWQCP Plant Equipment Replacement 47,855 445,582 675,832 202,652 190,315 380,408 2,544,261 1,156,156 238,280 267,356 WQ-80022 RWQCP System Flow Metering 0 56,245 0 180,000 363,538 Electric Fund : EL -02011 Electric utility GIS 18,475 39,414 83,546 0 0 EL -06005 Fiber Optics Ring System Improvements 4,553 58,124 112,435 36,145 22,294 Fiber Optics Customer Design and EL -06006 Connection Services 17,080 195,808 134,498 131,930 42,721 EL -89028 Customer Design 642,744 1,467,233 1,982,607 3,402,213 1,861,108 EL -89031 Communications System Improvements $0 $21,784 $50,458 $2,670 $2,392 EL -89038 Substation Protection Improvements 117,654 94,411 423,904 46,187 0 EL -89044 Substation Facility Improvements 0 93,735 7,147 73,730 20,870 Electric Distribution System Reconstruction EL -98003 and Improvements 739,157 1,265,486 2,260,973 2,761,605 1,129,804 Fiber Optics Fund : FO.10000 Fiber Optic Customer Connections 11,839 0 0 0 0 FO -10001 Fiber Optic Network System Improvements 8,557 0 0 0 0 Page 1 of 2 Attachment 4 Continuous Capital Projects - Five Years' of Expenditures Project Category FY 2010 Department/Fund Project Title 12/31/09 FY 2009 FY 2008 FY 2007 FY 2006 Gas Fund : GS -02013 GS -03007 Directional Boring Equipment 0 59,410 63 0 0 GS -03002 GS -04003 GS -05002 Gas Main Replacements 19,691 38,121 433,894 1,858,052 2,075,281 Polyethylene Fusion Equipment GS -03008 Replacement 0 35,650 0 9,153 0 GS -03009 System Extensions-Unreimbursed 0 12,000 115 82,515 229,963 GS -06001 Gas Main Replacements, GMR-Project 16 26,381 2,423,677 2,256,296 344,176 229,370 GS -07002 Gas Main Replacements, GMR-Protect 17 2,281,714 912,018 614,485 143,767 0 GS -80019 Gas Meters and Regulators 115,358 244,129 272,386 253,784 194,432 GS -80017 Gas System Extensions 129,951 356,666 609,566 675,874 535,822 Wastewater Collection Fund: WC -02002 WC -03003 Sewer System Rehabilitation and WC -04002 Augmentation, Project 15,16 and 17 WC -05003 WC -06003 Sewer System Rehabilitation and WC -07004 Augmentation, Project 18,19 and 20 1,405,665 2,154,931 1,378,862 3,048,500 168,026 WC -08012 WC -09001 Sewer System Rehabilitation and WC -10002 Augmentation; Project 21,22 and 23 102,147 285,858 126 0 0 5,385 8,840 1,394,506 3,374,976 1,395,355 WC -8Q020 Sewer System Extensions 101,525 370,253 561,620 493,863 214,613 WC -99013 Sewer Manhole Rehabilitation 53,660 48,227 116,173 441,705 551,648 Water Fund : WS -02003 Water Main Replacements, Project 16 0 19,695 4,629 81,310 31,050 WS -02014 Water -Gas Wastewater utilities GIS Data 7,859 33 0 216 0 WS -06002 Water Main Replacements, Project 20 312 93,554 1,830,359 595,117 32 WS -07003 Water Main Replacements, Project 21 319,405 226,559 57,923 3,328 0 WS -80014 Service and Hydrant Replacements 0 104,951 58,212 39,079 75,768 WS -80015 Water Meters 0 14,712 127,109 140,891 163,633 WS -80013 Water System Extensions 134,592 295,194 400,152 178,680 328,524 Page 2 of 2 Attachment 5 General Fund Transfers to Infrastructure Reserve Projected in Long Range Financial Forecast $15,000 $13,000 c $11,000 O to $9,000 $7,000 $5,000 $14,648 $13,800 $13,300 $11,690 $11,500 $12,900 9,900 $10,200 $8,661 $6,162 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Fiscal Year Amount Amount Returned Transferred to to General Net Infrastructure Fund Amount Fiscal Year $(000) $(000) $(000) 2006 $6,212 $50 a $6,162 2007 $8,736 $75 b $8,661 2008 $11,807 $117 a $11,690 2009 $14,648 c $14,648 2010 $9,900 $9,900 2011 $10,200 $10,200 2012 $11,500 $11,500 2013 $12,900 $12,900 2014 $13,300 $13,300 2015 $13,800 $13,800 Total $113,003 $242 $112,761 Notes: a. Project completed and unused balance returned to funding source. b. Funds transferred to cover GF engineering costs for structures and grounds. c. Includes funding for the Public Safety Building $3,437K Sources: FY 2006 through 2009 are actual amounts FY 2010 is adopted budget FY 2011 through 2015 Long Range Financial Forecast Page 1 of 1 Attachment 6 * * * NOT YET APPROVED Resolution No. Resolution of the Council of the City of Palo Alto Amending the 2006-2009 Compensation Plan for Classified Personnel (SEZU) Adopted by Resolution No. 8658 to Add One New Classification, Change the Compensation for One Existing SEIU Classification and Change the Title of One Classification The Council of the City of Palo Alto does RESOLVE as follows: SECTION 1. Pursuant to the provisions of Section 12 of Article III of the Charter of the City of Palo Alto, the Compensation Plan for Classified Personnel (SEZU), adopted by Resolution No. 8658, is hereby amended to add one new classification, change the compensation for one existing SERI classification and change the title of one classification as set forth in Exhibit A, attached hereto and incorporated herein by reference, effective with the pay period including July 1, 2009. SECTION 2. The Director of Administrative Services is authorized to implement the amended Compensation Plan as set forth in Section 1. SECTION 3. The Council finds that this is not a project under the California Environmental Quality Act and, therefore, no environmental impact assessment is necessary. INTRODUCED AND PASSED: AYES: NOES: ABSENT: ABSTENTIONS: ATTEST: City Clerk Mayor APPROVED AS TO FORM: APPROVED: Deputy City Attorney City Manager Director of Administrative Services Director of Human Resources 100218 sli 8261263 Attachment 6 * * * NOT YET APPROVED EXHIBIT A 2010 Mid -Year SEIU Compensation Plan Changes Job Code TBD 536 434 ClassificationTitle Cathodic Protection Tech Assistant (new position) Cathodic Technician (rate change) Tree Maintenance Specialist (title change from Tree Maintenance Person) 5 5 5 Top Step Monthly 6,163.73 7,189.85 5,274.53 Approx. Annual 73,965 86,274 63,294.40 35.56 41.48 30.43 100218 sh 8261263 Attachment 7 Police and Fire Departments Overtime Analysis for Fiscal Years 2005 through 2009 With Fiscal Year 2010 Data Through January 31, 2010 Fiscal Year Ending June 30 unaudited 2005 2008 2007 2008 2009 thru 1/31 2010 POLICE DEPARTMENT Overtime Expense Original Budget 5974,426 5981,862 $1,015,620 51,036,815 $999,900 5999,900 Current Budget 1,028,337 1,009,705 1,074,399 1,071,005 1,016,900 999,900 Net Overtime Cost - see below 1,096,077 780,647 1,025,718 1,096,894 886,568 584,877 Remaining Budget (567,740) 5229,058 548,681 (525,889) 5130,332 $415,023 Overtime Net Cost Actual Expense 51,229,851 51,405,155 $1,785,657 $2,009,542 51,665,842 5951,889 Less Reimbursements Stanford Communications 30,941 30,937 39,342 65,079 42,160 39,587 Utilities Communications Reimbursement 17,404 17,402 22,130 36,607 23,715 22,574 Local Agencies (A) 32,617 34,565 36,457 41,770 37,413 27,680 Federal Grants State Grants (8) 8,135 65,835 63,344 4,672 10,998 18,370 Police Service Fees 37,188 49,185 43,218 67,390 53,812 56,983 Other 7,489. 12,447 18,157 15,982 - Total Reimbursements 133,774 197,924 216,938 233,675 184,080 165,174 Less Department Vacancies 375,515 426,584 543,001 678,973 595,194 201,838 Net Overtime Cost $1,096,077 5780,647 51,025,718 $1,096,894 $886,568 5584,877 Department Vacancies (number of days) FIRE DEPARTMENT Overtime Expense Original Budget 1,642 1,733 2,280 2,766 2,402 760 5982,674 5959,389 $1,032,674 5892,074 51,017,674 81,017,874 Current Budget 982,674 959,389 1,032,674 996,674 1,353,058 1,017,674 Net Overtime Cost - see below 877,892 637,310 737,768 863,442 416,610 858,715 Remaining Budget 5104,782 $322,079 5294,906 $133,232 5936,448. $158,959 Overtime Net Cost Actual Expense $1,956,529 $1,582,858 $1,860,757 $1,744,076 $1,591,261 $1,567,019 Less Reimbursements Stanford Fire Services (D) Cat-Fire1FEMA (Strike Teams) State Homeland Security Grant Program (SHSGP) (C) 17,203 72,254 40,897 10,164 4,342 Urban Area Security Initiative (UASI) 26,782 1,150 Department of Homeland Security (E) 5,800 Total Reimbursements 610,031 644,911 690,237 679,993 940,113 539,567 592,828 479,606 563,809 528,455 482,152 474,807 66,269 85,531 140,224 453,619 64,760 Less Department Vacancies 468,606 300,637 432,752 200,641 234,538 168,737 Net Overtime Cost Department Vacancies (number of days) $877,892 5637,310 5737,768 5863,442 $416,610 $858,715 1,980 1,230 1,740 810 780 638 . 'es of 11/20/09 NOTES: (A) Includes Animal Services contract with Los Altos, Mountain View and Los Altos Hills. (B) State Office of Traffic Safety and ABC grants. (C) Included In the SHSGP and UASI reimbursements is a small amount of per diem reimbursement. (D) Stanford reimburses 30.3% of Fire expenditures. (E) Reimbursement from U.S. Department of Homeland Security for HazMat Continuing Challenge Training Conference (Sep 2009) 2/24/2010 Attachment 8 Summ ary of CSMFO Gro up List Budget Gap Survey Dated: February 20, 2010 City FY 2010 G .F. Budget Projected Deficit FY 2010 % FY 2011 G.F. Budget Projected Deficit FY 2011 % Town of Paradise 10,938,911 164,000 1 .50% 11,097,020 651,000 5.87% Pinole 11,993,089 227,000 1.89% 470,000 N/A Cotati 4,013,560 370,000 9.22% 320,000 N/A Watsonville 32,781,873 372,000 1.13% 34,874,683 1,900,000 5 .45% Davis 39,706,757 800,000 2 .01% 500,000 N/A La Verne 25,541,923 1,000,000 3 .92% 1,000,000 N/A Lake Forest 31,990,800 1,100,000 3.44% unknown N/A Healdsburg 50,776,104 1,280,000 2 .52% unknown N/A Milpitas 67,348,540 1,300,000 1.93% 11,500,000 N/A Union City 38,678,132 1,500,000 3.88% 38,731,383 2,000,000 5.16% Fountain Valley 37,362,969 1,700,000 4 .55% 2,500,000 N/A Campbell 33,357,479 2,000,000 6 .00% unknown N/A Calexico 20,095,079 2,288,000 11.39% 3,800,000 N/A Dana Point 28,679,204 3,100,000 10.81 % 28,855,386 2,300,000 7.97% Redwood 82,578,000 3,600,000 4.36% 85,071,000 5,900,000 6 .94% Vic to rville 53,741,095 4,300,000 8 .00% . unknown N/A Oceanside 125,327,685 4,400,000 3.51% 8,000,000 N/A Long Beach 387,978,750 6,000,000 1.55% 11,000,000 N/A Sa nta Monica 254,806,384 7,700,000 3.02% 6,900,000 N/A Sa nta Rosa 119,037,000 10,000,000 8.40% 10,000,000 N/A Oakland 421,018,710 15,260,000 3 .62% 426,834,240 32,720,000 7 .67% Diamond Bar 31,574,217 has no deficit has no deficit N/A La Ha bra Heights 2,994,462 has no deficit has no deficit N/A Menlo Park 38,204,520' 976,401 2.56% unknown N/A Sunnyvale 129,813,334 7,582,803 5.84% unknown N/A Mountain View 90,900,000 2,300,000 2.53% unknown N/A Danville 19,675,253 has no deficit h as no deficit N/A Palo Alto 142,089,000 6,300,000 4.43% 146,846,000 6,351,000 4 .32%