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 closed. 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 Midyear Budget Budget i of 0f=29-1 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% 65 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 CIP 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— CIP 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 FIE 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 Projects 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: , Z.4.4. '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; Adjusted Budget Midyear . Budget Midyear Changes.. Revenues & Other Sources Sales Tax 19,650 19,650 ,313; (2,337) Property Tax 25,752 25,752 25,778.' 26 Transient Occupancy Tax 7,000 7,000 6,639!' (361) Utility Users Tax 11,250 11,250 11,417: 167 Other Taxes and Fines 5,633 5,633 5,584' (49) Charges for Services 20,238 20,238 19,017.x. (1,221) Permits & Licenses 5,056 5,056 4,51 :-_ 1 (545) Return on Investment 1,900 1,900 1,662:; (238) Rental Income 13,655 13,655 13,606: (49) From Other Agencies 92 92 324: 232 Charges To Other Funds 10,643 10,643 .10,575; (68) Other Revenues 1,605 1,605 1,740' 135 Total=Revenues . _ ... `122,474 _ , 122;474. : "-,;. 66: ;:....(4;3.08) Operating Transfers -In 19,664 19,664 .19,664 Encumbrances and Reappropriation 5,924 .5,924: From Infrastructure Reserve ,243:' 3,243 .J,.otal_Sourc'es of Funds_. ... :.. . 142,138.:..148,062 =146,997 (1,065) Expenditures & Other Uses City Attorney 2,569 3,343 3,2984 (45) City Auditor 999 1,107 : x,096;: (11) City Clerk 1,512 1,524 1,51:9' (5) City Council 296 309 309_; City Manager 2,395 2,664 := 2,631 ! (33) Administrative Services 6,761 6,907 ;_6,859_: (48) Community Services 21,876 22,535 ;':;: ;:.22,348_: (187) Fire 25,166 25,534 ;26,621x' 1,087 Human Resources 2,837 2,955 =2,906 (49) Library 6,385 6,669 ;6,6149;, (20) Planning and Community Environment 9,858 10,492 '10,312; (175) Police 29,998 30,207 ,219 12 Public Works 13,484 14,040 13,9821; (58) Non -Departmental 6,925 8,699 :_ :';a_9822< 1,123 Total Expentfatures . .•. . ; .v . .-!1:31,06 t.: -.1.36,985 . ,. ,138,576::: 1:,591. Operating Transfers -Out 11,028 11,028 ;14,865 3,537 .Tptal Uses of Funds , ; :, : ._ 142,08.9,-1T-41 i, ... 153,141_ . . ... . 5,128. Net,Surplus.(Deflclt) .` :.... . • ... . .. .. . . ...:. .. . 49-- .:., ° .::,49 :(6,'144) s:::.(6,193) Adjust intra-fund reserve transfer - - Transfer from Equity Tsf Stabilization Resv - 3,636: 3,636 Year end savings from hiring freeze ; '1,704'; 1,704 Net To.(Frotlj'_Reserves ...: _ . . . 49. :... 48 ,.. :: (804) -'(853) Beginning Reserves 22,176 24,747 24• ,747s _Projected Ending Reserves_ 22,225;,_; 24,79.6 ,.;.. 23•,943; . .(✓353) 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 :ACriiAL Pre . Encumbr (aso or29lo),`. Encurnbr Actual %of E. : 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 , 3.04 - - 11,711 60% ::. , . . - 17:-;!.';',.:'.,.: ; . f _:;74,714 $4% 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!' 6;1)55 72,8.38• ;-:-i-,--:,.- 585%; - - 6,380 44% , 11,199._. ;6,055 796218 56°Yp0. 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' :> _: •5 a24= ?14,570 = x`.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 $:o0ces c ._ .:: . -129,944': _:140;844 1'44,259 - 3;415. Uses of Funds _ .." 7775$. .11,574 =; 5;738: 825_ 2 99:, `, - =;:7,801_: -3,712; =?'- 7,298 w. 7859 - (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,73Z- 4419;9:79:1. 119,978_ ...,.122 6(i5 2,667_ Equity Transfer 11,120 11,120 Operating Transfers Out 692 785 Capital Improvement Program 8,535 17,873 1.20 `. 785 >= = 16 836` 153,406,'... - - 963 3,860 TotalUses .::...._. :137,079_. 149,756. Net,To(From)Reserves .. .. ` ;(7,135),. .:.(8,912)-'."--4147.),_;. := (235) Beginning Reserves 108,923 118,468 .{1<18468' - Projected Ending Reserves 101,788 .::.109;556 _.,109,321 _ _ _,...(235) ** Excludes encumbrances and reappropriatlon ,ACT{!A(.S.: Pre- • Encumbr Encumbr :(asof 0f 970) % of Actual Midyear Budget - - 69,387 61% - - 2,267 45% - - 4,147 28% - - 0% _. . _ -75,801_ - ---1.: ".-:..;•:::•:.7:•,::`,t9.1% - 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.: 8503 _6O,661 : _. . '56% - - 6,487 58% - - 396 50% 1,388 5,170 5,931 65% 3123 r 13,673 . _ ...73,475: .._: .__ Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY FIBER OPTICS FUND (fn thousands of dollars) Sources of Funds Net Sales Interest income Other Income Reapprop/Encumbrances Tt taf Sources: Uses of Funds Salaries & Benefits Contract Services Supplies and Materials General Expenses Rent and Leases Allocated Charges Subfotaj=° Adopted Budget Adjusted :: Midyear Midyear Budget Budget Changes 2,734 2,734 256 256 607 2,990:.. 3;597 635 115 18 19 15 363 675 239 18 14 15 363 1,324_ Operating Transfers Out Capital Improvement Projram Totai-_Uses .. _. 11 400 13 811 48 :1,399„ 3,597_: 50 Net Tg(Frorrt)Reserves, Beginning Reserves F►0104:d Erfdfrig eserr; "44;414.,t2';' 7,314 7,436 400) ** Excludes encumbrances and reapproprlatlon ACTUAL5`' Pre- Eneumbr Ertoumbr Actual Midyear Budget (a"sot Oi 29-10) % of 1,813 156 66% 61% (.1,969 11 228 4 400 88 5 13 157 663 59% 113% 0% 36% 113% 43% 1 120 7 126 54% 30% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY GAS FUND (in thousands of dollars) rBUDGET . - Adopted Adjusted Midyear Midyear Budget Budget Budget Changes Sources of Funds Net Sales 44,222 44,222 -.-44,222: - Interest income 1,010 1,010 1,010 - Other income 693 693 1,702: 1,009 Reapprop/Encumbrances 12,064 12,064; - TotaE_Sources:; „ , 45,925 =r:°,, x.57.,969 ' 5$ 9913 x:..1,009 Uses of Funds Utility Purchases 26,859 26,891 26,891- - Salaries & Benefits 4,370 4,466 4'483x 17 Contract Services 802 1,141 -1: 1,24]`:' 100 Supplies and Materials 520 529 529;: - Facility and Equipment Purchases 62 62 62 - General Expenses 595 784 ... 704' - Rent and Leases 326 326 :: :- 826*' - Allocated Charges 3,316 3,316 ... 3,3 j.2:x (4) Debt Service 947 947 947- - Subtotal-...::. , } �..:.:- .. .- , i . '. •,._ 37,797,..::.. 36;462 --: 38,575^ :' _1.13- .. . . . . . . . . . . . . Equity Transfer 5,300 5,300 Transfers Out 367 407 ` ;' 5;3100. 407 ..Operating - Capital Improvement Program 2,389 13,879 13,879; - Totaf Uses , ,e , .., _ .. .. .;45,853 -9 F 5;04!V .,.",r.,50.-1,6t, .. .-.. 113' Net Tal(Froin)Reserves;-, E ; .t '._- _.. _.; -. . -'. 72 .. _ ;(59) - - 837,. , ,x:_:.8:96:. Beginning Reserves 15,127 15,266 °r-._ `:; X1.5;26.6<; - Pt'olecled Entting Reserves . ,_-.3.._ ....;.. X5,199 . j5 207 ,.;: )6,103._ .. ,:,-::.896', .; Excludes encumbrances and reappropriatlon AGTfIA;tS _ . 10,771 100 17 577 192 13 176 6 A EMIKEHEll 1,255 2,990; 22,915 472 303 10,105 2,192 198 101 12 1,076 183 1,141 252 '',Z,15;160:_ 3,092 253 3,404 % of Midyear Budget 52% 47% 18% 78% 49% 71% 59% 40% 160% 58% 34% 27% 58% 62% 34% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY WATER FUND (In thousands of dollars) -. __s. ..; ..- BUDGET' ...:....., r ..:.:: .. .7..:-.:: 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` - Other Income 814 814 _ 1,073=, 259 Bond Proceeds 35,000 35,000 35,000; - Reapprop/Encumbrances 20,111 20,11;1'_ - Total'Sources:. .: -; - , : :•:•_66,027 ;°% 1.._.86,138 .. . ' :86,397. .... •,•,:459"..i Uses of Funds Utility Purchases 10,354 10,354 ' 4 ,:_10,35 - Salaries & Benefits 5,411 5,516 5,503' (13) Contract Services 593 671 ' 671:: - Supplies and Materials 490 496 < -=;`x496` - Facility and Equipment Purchases • 10 10 :-- _ <:::;10_ - - General Expense 330 330 - -_.,.. 330 - Rents and Leases 2,193 2,193 - . 2,.193; - Allocated Charges 2,992 2,992 2,976; (16) Debt Service 775 775 • '.775 - SUbtotal __ . . .. _ -:-: ; -23,1,48, _. : 23,337 =:.23,308- ': :(29) Equity Transfer - -- - Operating Transfers Out 258 282 2822 - Capital Improvement Program 27,414 47,710 ; 48,169- 459 Total Uses ... ..., . .. .... .' _.:.:.50,82Q_..rr._ ...x_71,329 .._.. 71,759# , -. ::-..:x430` Nef,To,(From)Reserves. ,:::- .-- 15,207 = ,a 1.4;809, 14,638.. ..� , :(:1:X1 ) Beginning Reserves 4,887 7,288 7,288_ - Protected Ending. Reserve ; , .:,,20,094: _._-_.22,09? -._;.' 21-=,926 _.__._ ..(171) **Excludes encumbrances and reappropriatlon 74CT-tlALS Pre Encumbr =. _, Encumbr „r,. (aso1Ot 2910} %of Actual Midyear Budget - - 17,012 59% - - 562 44% - - 623 58% :-. . . : 18;197: .. : ...-2.=,,-,.-,..,..:.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_. 4624 :: .:- 10,712- 69% -:',,-.60% - - 184 65% 40 12,530 2,741 32% _ : _1.37 ;.?17,154_ -,.'5L.,.1 3637.: ._.._ .. . 43% Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY WASTEWATER COLLECTION FUND (1n thousands of dollars) Adopted Budget VaggT Adjusted Midyear Midyear Budget Budget Changes Sources of Funds Net Sales Interest Income Other Income Reapprop/Encumbrances TotarS;ources-_ 14,443 14,443 551 551 994 994 7,122 23;110i 3,t'10 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 Subtota Operating Transfers Out Capital Improvement Program Total:Ll :°,12 338.;:f 12,506 97 108 3,946 6,381 23,539_ 10,925 'L522` 011- 16 Net To_(From):Reserves -.. Beginning Reserves Projected Ending Reserve& _. _. 5,267'_.: ;6;57 5,660 7,001 ** Excludes encumbrances and reapproprlatlon ;x(16) Exhibit A CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY REFUSE FUND (In thousands of dollars) I Adopted Budget,. ;,BUDGET ` Adjusted Midyear Budget I, :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' - Reapprop/Encumbrances 3,021 s = < 21:= Total Sources ' > 37,083 40;104 ' 40,104: Uses of Funds Utility Purchases 15,047 15,070 ;F==" .15,070 - Salaries and Benefits 4,586 4,676 _ 4,676: - Contract Services 6,931 7,554 7,554, - Supplies and Materials 460 524 524 - Facility and Equipment Purchases 19 22 = -= 22; - General Expenses 385 391 = 1,- - 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:::.' Operating Transfers Out 333 354 ,. . - 354> - Capital Improvement Program - 2,292 2 292; - Total"Uses _,...,. ; 36,495 -' 9;61.T -_39,617 - - Net TO (From)=Ffes sk.46 ; ; ;; , ;: 588 _"_« .487. ....... 489. ; ,,-, Beginning Reserves (100) (2,194) ' (2 194 Projected.Encl ng'Reserves - .. - 488 - .. (1;707 ,..-,f11;707) - - •* Excludes encumbrances and reapproprlatlon AC.TUALS, :._:,:.: Pre- Encumbr: Encumbr Actual asofic129-1O) _.z % of Midyear Budget 14,936 186 1,407 46% • 38% 34% 72 4 25 1,126 24 -.16,529. 45% 5,828 39% 2,385 51% 2,925 55% 125 29% 2 14% 582 149% 2,507 58% 2,144 56% 0% 6,498- ;1;176: 195 194 55% 148 15% 76: 16,840; 46% 1 Exhibit A _CITY OF PALO ALTO FISCAL YEAR 2010 MIDYEAR BUDGET SUMMARY STORM DRAINAGE FUND (In thousands of dollars) BUDGET=g -. I Adopted Budget Adjusted Midyear Midyear , Budget Budget Changes. Sources of Funds Net Sales 5,366 5,366 ;�_;:;_ .;:5,366 - Interest Income 217 217 _ 217' - Other Income 68 68 68 - Reapprop/Encumbrances 2,306 _ .,,7- 306=' - Total Sources :" `:5,651 -: ".7;957 .-7,957 ': Uses of Funds Salaries and Benefits 1,034 1,032 , '`1,032_ - Contract Services 374 575 :`. - 5 ` - Supplies and Materials 99 108 108; - Facility and Equipment Purchases 12 14 _. ,.14 - General Expenses 148 658 =':658:' - Rents and Leases 6 6 ._ _ ..;,;:9 - Allocated Charges 619 619 . ;.. 61.9; - Debt Service 949 949 We=;.;`.549: - Subtotal" . _ x:.._.._ .__ : .:.3,241 .;: ,. .k 3,961 ----; 3,961.. �< .. .. :. Operating Transfers Out 683 688 .. fist8 - Capital Improvement Program 1,700 3,417 .3,417` - �. : . :$,066. TotalUses .-._,_._. . .. . :-. , ! 5,624 '' .. , _5,066, \ _. ... .- NetSurplus:(Deficit). > ::-: -. ;t H;...:.-, > - 27.::.-:: :.".(1.09) ;..,f!-:(109) : Loan repayment to the General Fund 674 = ; 674 - Beginning Reserves 400 (1,098) (1,098) - ProjectedEnding Reser es.. _,. .. 427 ,-k,..„_...{538) (533) --:.,f,;:."- ** Excludes encumbrances and reapproprlatlon :ACTUALS:. Pre - of 01:29;10) % of Eneuinbr Encumbr Actual 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% 1 �36.ii 1,017 668 439 X468 51 % • 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 TotaISo4�rces Adopted Budget Adjusted Midyear. Budget Budget 21,484 423 80 21,484 423 80 26,298 ;21,987; :,;x}8;285 Uses of Funds Salaries and Benefits Contract Services Supplies and Materials Facility and Equipment Purchases General Expenses Rents and Leases Allocated Charges Debt Service SUbtatar 9,363 9,476 1,978 3,154 1,755 1,943 10 10 251 251 18 4,432 4,432 816 816 ..... .::20,100. Operating Transfers Out Capital Improvement Program 7otai}11t3e� - s 153 1,700 134 26,612 46;84 46,846: Midyear Changes Net TOIFrorr) Re8errie Beginning Reserves Projected E�siEng Reser.►tes . : - --.-.:.:x(2,766);=;.. ..(1?,OQ 1,529 7;439 (4,295) (13,442) ** Excludes encumbrances and reapproprlation -1e ;442) ACTUA S Pre=_ Encumbr -(as of 01 Encunnbr Actual 2940): - '/oof Midyear Budget - - 13,276 62% - - 205 48% - - 263 329% 13,744. -83:%s - - 4,865 51% 629 1,123 523 72% 25 317 910 64% - - 8 80% - - 428 171% - - 0% - - 2,284 52% - - - 0% --TZ6547. 79,018; -' . .. 55%0 - - 89 66% - 7,547 2,330 37% .654. i. -;:11.,437:. ,.;';-„7„,.;8987, ,, _.: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.tion 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 Project Fund 10300000 16030 27,207 Decrease property rental revenue to match budget to actual - GeneraLFurid ReverSGe Chariges -'>(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 INo i Departmantal iher Expenses -.... • 4,660,229 Nef Changes Tq (Fr4ij1).ROServes_ CITY ATTORNEY 18030003 18010001 31010 various (46,558) Reduction in outside counsel services Repayment of FY 2009 Technology Fund allocated charges �d#Fier.Reveriue aihd Fa;pertse-;- ,...- 1,257 (45,301) Nt:t_Changes To (From) Rewrites: 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 lother R<}vetiue and Expense (,1.34,1333).::: Net°_EhangasTo (From) Re ewes CITY CLERK 12010001 12030006 12010001 31220 33060 various IOtkiefiFleVeilOtanc{ Expense (3,800) Reduction in instruction & Training (2,000) Reduction in Travel & Meeting 745 Repayment of FY 2009 Technology Fund allocated charges (5,055) .. Net:Chpnggslo From Reserves CITY MANAGER LOttie Re .eiiikai1ci<meoiinse'. various various 11030002 11010001 31070 33060 31200 various (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 N . 32935 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 'MfNIST' 'TINE 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 & Meetings 40010001 various 6,640 Repayment of FY 2009 TechnologyFund allocated charges lOther Revenue: end E*Ain:e. (47,906) Net:Changes TOAFIohi):Reeefves - 47;$06 ........... 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 fees 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 fee subsidy various 13980 (1,693) Increase in overage/shortages 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.tion various various various various 80010001 33990 35030 35040 35050 various (57,000) (500) 12,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 R@Ventre tills -Expense . 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 GraritiRelmbursement Revenue and'E=xperisi3, Net;GFfijriges To- !x(598;244) FIRE 75030002 75030002 18010 32060 (2,500) 2,500 Training expense donation Training expense associated with donation �Gj'aiitlReimFiursemerit Revert�iEZ antl°:Expense "r;= ,..,=. 70030008 30030 20,000 Increase In temporary salaries Safary.R_elalsti Revenue-ariil;Expense::? 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+veiiue and Expense ` . `, x1,320,530 .. Not Ctinnges`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 Net;Gh 110ei d,(Frat Resefires_... 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 GENEW various 30030 76,000 Increase in hourly salaries Salaryfelated Revenue arfd'-Experise-v IOthat Revenue and'Ezperlse 76,000 various various various various various various various various various various various various 31220 31990 32010 32210 32220 32230 32280 33020 33040 33060 33470 34030 various (1,550) (9,224) Reduction in training 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 (1.19,086) 84010001 84030001 15300 32230 (22,840) 22,840 CA Public Library Fund grant Increase In arts and photo Grant/Relmbursement Revenue and Expense :' NatChanges'To {Front) Reierves= 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 Other Revertueiand;Expense-, 43;87O Ndk=ChangesTo (Frori) (reserves (643870)'. 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 GrarivRelmbursem R - - d . ent "venue :Re and>EXpenss:.- . -::(1ti0,1S00) _ .. .- - 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 lees 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 �Qtlet #�eltAnut� anti Expense, 70030003 70030001 various various (14,624) 22,579 348,635% Net Citrtngeslro: From Reserfre§ 188;635 PUBLIC WORKS 50020305 50020305 15370 31070 (120,000) 130,000 Urban Forestry Inventory Grant from Cal Fire Urban Forestry Inventory Grant Program Grant/Reimbursement Revenue and Expense -10:,"0"0 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 lfnliet'13evertiie anO,Expense.=....... NelgChanges T.OAFroi*Reserves 80,560.'_ FunH; f talenel ng'Eiitrles-; 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 Descri . tion INTERNAL SERVICE FUN[ Revenue Technology Fund Net !SF AdJ usfinents 40070001 19440 40070102 40070103 40070202 40070203 40070302 40070303 19370 19380 19420 19430 19510 19520 (822,127) (91,464) (50,652) (21,547) (24,433) (93,188) (117,283) 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 Expenditures INet ISF.6kpenditure Adjustments • Net)nte'rifal Service -Feted 1, 0,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 S/L Garage) 23100000 80210001 20410 20410 (50,000) (249,098) To return funding from Capital Project Fund for CIF 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 f etSptelatiRevenue, ReVei ue`Adjustittdnts , _: .. .. Expenditures Local Law Enforcement I 70248003 I 35070 50,000 Net s peiaal;gevenue Expr3ndituregdlustmetits�= __. . ... 2010 COPS allocation equipment purchases Nat•SpectahRa4eriuE`Fund=Adjdi;tmeifs . .. _� �. _ _-, :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 NetCIP:ReVenue Adjtittttients (279;526) 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 Stabllltzation Reserve (BSR) To close CIP Protect 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 40180 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 partially 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 ;C1 R- Eiipc li d l to re, -Ail j tie Ertl a rite° Net CIp Adjustments To (f=rom) Reserves 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 ARISE FUr Electric Fund ISorirce 411aii I J Qhanges: . 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;415,288i,) .r: - _ 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 ‘;PA.6•464. _, ._.:, , ':':;-!ZE. 3,850,546 ;;;'; 5 INocctianosli: (Fenn) E1es rvea; ?3.5;258) ,11 FundBalancng E=ntries , , �, ITota Etectric:.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} ... . . 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 ;Changes I _ , . rt1se 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 , Kittangeiro (Fiiim} Reserves _ (50;004) Fund_Balartefng .Sjltrles 1 20000080 1 38040 Total Flber.Optfcs:Fund (50,000)IFiber Optics Rate Stabilization Reserve (50,001)1 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 iSource Cftanges -_ . K . : . .. - . ,,,, . -(1;048,985) 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 11 various 30010 628 Compensation adjustment for 1.0 FTE Cathodic Tech various 39090 7,904 Ad ustment to dispatch and alarm service monitorin rovided b Police Use.Ghangea cA. ...., 113;454,1.:. r , :._ i ... _ -- .. ._, Net Changes Ta (From) Reserves. . ° } 20000050 20000040 38170 38040' 454,403 441,108 I-rota:14a*.Fund __... -3.':•085i0. - 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 Water Fund - . 20000060 20410 (259,266) Return excess funding of GF CIP Project PE -07007 (Cubberley Turf Renovation ) funded by emergency Water CIP ISource Chenges -::., -�. . . . :..:. . .. •.:.'.."-; (259,266 :?......, x, 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 lus. eChenges'::.... :.... ..s . , -::- .- ii',.': .. . .. 430,052. .. = ..e... : : ; i ",--,4::2-----:; NetChanges-To: (From) Ffe§styes Fundi3alancing i~ntt•fe� .',. 20000060 I 38040 I (170 786)lWater Rate Stabilization Reserve ITotelWater Fund r <..';__. ::.:.,(1;70786 Wastewater Collection Fund l Use; Ghantes 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 _,._ .-..i_.: .. ... `:.ifin ;::3f.4-.-1:-. ..... 15',5.( 80) _=.__... : [Netphanges:TOAFr6rn) Reserves Fund l lalQi cing Er telee 1 20000070 ! 38040 ! 15,680 !Wastewater Collection Rate Stabilization Reserve; (Total_ Wastewater Gollectlon_Fund Enterprise Fund Details - 3 Exhibit 8 FY 2010 CIP Mid -Year Adjustments a -. -i - - 1;i:proJeclt,- - - S j*r -1 --`: ,Mile = s..M..�._$4z-, r--` a' ,,,,.;.....,-.2j_2. SK if.Nam .... 1.( -- Ff9yen •�. I -s Eg Ogg"' pe _ , .E 'din - - S urea -r R G - - - _. x (,'amBl9lilb, 7.'1:_.,:',_,.,,,... _ APITAL PROJECT FUND .... ADD(T(ONAI AP.FROPF I_ATIONS -.::- Crime Scene Evdarce Co9eclbn Vehicle PD -08000 $ 50,000.00 $ 20,000.00 COPS To provide additional appropriation Lytton Plaza Renovation PE -00004 $ 20,525.72 $ 20,525.72 Friends of Lyllon Plaza To provide addilIona! appropriation Floe Apparatus Equipment FO -09001 $ 5,455.00 FO.05000 To rovide additional appropriation's. p cover remaining expend-rums and to close project. Funding will coma from a transfer from COP Proejcl FD -05000 (Bodeen ALS MorrtorslDefrTlUlatora) Street Maintenance PE -88070 $ - 248,149.00 Stela Prop. 42 To prev,de addabrtal appropriarbnFuding were received in FY 2009_ StreetMaintenance PE -85070 $ 209,000.00 $ 209,000.00 ARRA To provide additional approprial-iort Thernnplaslic Marking and Striping P0.11001 $ 250,000.00 PE -88070 To provide Initial approprlatbn for the new project. Highway 101 Overcrossing PE -11011 $ 100,000.00 PL -11000 Transfer to CIP Project PE-11011(Hlghway 101 Cvereroasirg), The Public Works Department assumed management of IIin project from the Piercing and Environmental Depedment- Ctbbedey Wing I Elevator Upgrade PF-07001 $ 2,127.00 trdrashuGtve Reserve Toprovkda additional appropriation to cover remaining expenditures and 10 close project. Ad Center Kiln Hood Replacement PF-08000 $ 9,722.00 Infrastructure Reserve To provide addtbna! appropriation to cover remaking expendituea and to dose project. TOtal - - $ 279,525.72 $ 854,988.72 REU)CT(QNII APPROPRIATIONS!TOCLOSE,:; - Lbrary Antomaled Service LB -94018 $ (180.00) Infrastructure Reserve To close project end returnbalanes to reserve Jaws for UM Hurst FD -09002 $ (4,095.00) General Fund To close project and return balance to reserve FoolhMls Park Maintenance 05-07003 $ (1,718.00) Infrastructure Reserve To close project and return balance to reserve Police Records Management System PD -09013 $ (8,027.00) General Fund To close project and return balance to reserve Erncaredero Road Median Improvements PE -00105 $ (2,97300) Infraslnxlure Reserve To close project and return balance to reserve Collage Terrace Park 00-00110 $ paoDO) Infrastructure Reserve To close prof act and relurn balance to reserve El Camino Median Lane Improvements PE -010I 3 $ (512001 Infrastructure Reserve To close project and reuro balance to reserve Mitchell Park Lbmry Improvements, PE -04012 $ (254,743.00) htmdroclure Reserve To dose projecl and return balance lo reserve. There is a new CIP project for Mitchell Park that is funded by Measure N Lbraryy bonds Pholovollab Design PE -05001 $ (125,393.00) Federal Grant/Electric Fund To close project and return balance to reserve Arastradero Preserve PE -05300 $ (844.00) Intreatr uclue Reserve To oboe project and return balance to reserve Crtbbedey Tut Renovation PE -07007 $ (508,3&1.00) Irtraalntouture Reserve/Water Fund OP Project WS -08002 To close project end relum balance to reserve Bay4ands Alhfelic Center PE -07009 $ (28,404,00) Infrastructure Reserve To close project and return balance to reserve Vetch Harbor Improvements PE -89004 $ (12,157.00) Irtra5ruclure Reserve To dose protect and return balance to reserve Mitchell Park Facilities PE -08003 PG -08001 PL -07001 $ (75,084.00) trtrastructure Reserve To cbse,project and relwn balance to reserve Golf Course Driving Range $ (47,185.00) General Furl To close project and return balance to reserve Informoda! Transit $ (837,380.00) General Full W resiruch re Reserve To Hose project and return balance to reserve College Terrace Library PE -05010 $ (1,400,00000) Infrastructure Reserve To reduce apropdatbn due to savage generated as a resutl of lower bid price on ooisrntdion and return the balance to reserve. Police BHkdng Project PE -98020 $ (2,700,00000) General Ford to To reduce appropriation due to change in project scope and return the balance reserve. Terris and BasketbaH Court PG -08001 $ (123',849.60) Irtireslruclue Reserve to To reduce appropriation due to change in project scope and return the balance reserve. The new conked with PAUSD does not inloude maintenance of PAUSD fad9lon by the City. School She Irrigation P0.98001 $ (209,86400) Infrastructure Reserve to To reduce appropriation due to change In project scope and return the balance reserve. The new cerdraul with PAUSD dresent intrude maintenance of PAUSD 'edibles by the City- Stxteen ALS Monitor! Dehbdllators FD -05000 $ (5,485.00) General Fund To close prefect and transfer remaining balance to CIP Project Fa -09001( Flre Apparatus Egrapmenl) Lot Sit Garage PE -55030 $ (363,405.00) COPn To Class project and transfer remaining balance to the Debt Service Fund. Street Maintenance 'Street PE -88070 $ (250,000.00) Gas Tax Fund Transfer funding to PO -11001 LIgnte PO -05054 $ (254,069.00) Genera) Firm! To reduce funing and return balance to reserve. Page 1 Exhibit B FY 2010 CIP Mid -Year Adjustments Highway 101 Overcr000Tog Bicycle Boulevards Implementation tPr ix 15Ni PL -11000 PL -04010 $ (100,000.00) Infrastructure Reserve Transfer to CIP Project PE-11011(Highway 101 Overcressing). The Pub%c Works Department assumed management of project from the Planning and ErMrormertal Deparment. To reduce funding and return balance to reserve. $ (50,000.00) Irlrastructure Reserve Safe Routes To School PL -00029 $ (50.000.00) Gas Tax Fund To reduce funding and return balance to reserve. Tragic Signal Upgrades PL -05030 $ (50,000.00) General Fund To reduce funding and return balance to reserve. 7ofef 3 9 (7,490,442.00) TOTAL .QENERALFUND.CIP MIDYEAR At2:14sTMENT$ == _279,52$.7$ ELECTRIC FUND AOPFTIONAL'$PPROPRIATIONS East Meadow/AlmaAoma 4l12kV Conwerslon EL -06002 $ 500,000.00 Electric Fund RSR Street Light System Conversion Project FL -10009 403,000.00 $ 463,000.00 Energy Efficiency Community Block Grant - 2009 Stimulus 500,000.00: TOTAL ELECTSRG: FUND CIP_MID-YEAR ADJUSTMENTS j,d�� , ,, _. Appropdalion Is moved from FY 2011 to FY 2010 to take advantage o11he lower contract construction costs due to the present economy. Combining the project Into one instead of two as originally budgeted will also help reducing the engineering, Inspeclbn and contract administration costa 2009 Stimulus App1catbn under the Energy Efficiency Commixby Block Grant (EECBG); $1133,00010 EECBG money would go to LED streelligNst reimbursed by EECBG WATER FUND 'APO( Q.NA4-APPROPRIA7IONS;'t-a:=-=;,!: Emergency Water SuppyProjooi Water Main Replacement - Project 22 WS -08002 WS -08017 259,256.00 200,000.00 Revenue bonds Water Fund RSR To increase appropriation as a resuh of return of excess 10 ng from CIP Project PE -07007 (Cubborloy Turf Renovation) 7o increase appropriation to cover the cost of street nit fees TOTAL WATER FUND CIP MID YE4R ADJUSTME 00,000.00'. FIBER OPTICS FUND `A O P (T JQ N 1jL'A P P R O P R )AT I O N s5 Fiber Optics customer Conneclbris FO -10000 01.57800 Fiber Optics Fnrd To close Project EL -05005 and trader balance to F0.10000. Fber Optics Network System Improvements FO -10001 $ 188,62190 Fber Optics Fund To close Project EL -06005 andlrerter balance to FO -10001. Toter $ 270,199.00 •}TEDUCTIONIN 1PPROPRIATIONsFro;CLOSE. IWNOTC Fiber Optics customer Connections EL06006 $ (81,578.00) Fiber Opllcs Fund To close Project EL -06005 and trailer balance to FO -10000. Fiber Optics Network System Improvements EL -06005 $ (188,621.00) Fiber Optics Fund To cbse Project EL -06005 and tranter balance to FO -10001. .7idtal: $ (270,199.00) 7¢TAL� FIBER.OP77CS:F.UND.01P.MIDiV,EAA?`:`_F ADJUSTMENTS-ri . .. Page 2 Exhibit C ..FY �bf0';Yable�oi OrgaSizaiiari=. 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 111 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 2019 Table oi t]rgaitizatii* 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 r11» UT:tL lE Footnotes: (1) Title change from Tree Maintenance Person to Tree Maintenance Specialist Exhibit C PY 2010:.Table" of;Organlzation 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 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 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 trOTAQUTfI:ITIE.S :; s ., `,_` _.W_:.__.. .:. - ,.235 ti5_:._,:.r.1-2 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 C CV ( Streets & Sidewalks $5,743 $7,944 $5,859 $6,227 $2,245 $28,018 Page 1 of 1 Exhibit A al Fund Capital Improvement Program Project Expenditures - -Years- Ge nes ditFi ve FY 2010 Project . - Project Project Expenditures er bTitle Number. T _ - � _ Category 1213112009, FY 2009 FY 2008 FY 2007 FY 2006 Expenditures Expenditures Expenditures 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 Building Rehabilitation PD -04011 Civ ic Cen ter Parkin g PE -03004 Roth Bu ilding Wings De molition Buildings and F acilities Buildings and Facilities Buildi ngs and Facilities Buildings and Facilities Bu ildin gs and Facilities Buildings and Facilities Buildings and Facilities Buildin gs and Facilities Bu ildings and 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 Program; Project . Expenditures - Five Years FY 2010 Project. Project Project Expenditures Number ' Title Category 12/31/2009 FY 2009 E xpenditures FY 2008 FY 2007 Expenditures Expenditures FY 2006 . Expenditures PE -04010 Children's Library Improv emen ts & Expa nsion Buildi ngs and Facilities PE -04011 Cambridge Parking Structure Buildings Improvements a nd Facilities PE -04012 Mitchell Park Library & B uildi ngs 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 An imal 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 a nd Facilities PE -05010 College Terrace Library Buildings Impro vemen ts and Facilities PE -06001 San Antonio Bridge Structural Bu ildings Repairs & Maintenance and Facilities 0 58,560 813,189 2,369,589 287,034 59,105 66 179,071 1,162,429 15,018 58,832 762,056 144,610 96,231 34,838 462,024 770,608 58,201 91,354 16 305,523 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 Capital, Improvement Program Project Expenditures Five Years - FY 2010 Project Project Project:.: Expenditures Number Title Category 12/31/2009 FY 2009 . FY .:2008 FY 2007 I2 es: E xpe ndit ures Expe nditures _. Ex endctures FY-2006.. .__ E xpenditures PE -08005 Mu nicipal Service Center R esurfacing PE -09003 City Facility Parkin g Lot Maintenance Buildings and Facilities Buildi ngs a nd Facilities 325,651 0 752,020 PE -09005 Downtown Library Buildings 330,799 78,163 Improv emen ts and Facilities PE -09006 Mitchell Park Library & Buildings 1,845,621 509,024 Commu nity Center an d (New Construction) Facilities PE -09010 Library & Co mmun ity Cen ter Bu ildin gs 141,937 28,866 Temporary Facilities and Facilities PE -10002 Ventura Commu nity Cen ter Buildings 7,712 and Park and Facilities PE -89004 Yacht H arbor Improvements - Bu ildin gs 0 21,584 7,080 11,949 1,698 and Facilities PE -95012 Civic Cente r Plaza Buildings Waterproofing an d Facilities PE -98020 Public Safe ty Building 12,238 Bu ildin gs 111,836 1,000,414 1,093,208 768,234 205,790 an d Facilities Pa ge 3 of 18 Exhibit A Gener al Fund Capital Improvement Program Project Expenditures - Five Years FY 201€3 Project Project Project Expenditures Number : Title .. Category 12/31/2009 FY 2009 FY 2008 Expenditures Expenditures FY 2007 FY2006.. ,. Expenditures E xpendit 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 Center 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 Project Number PF-04001 General Building Study General Fund Capital Improvement Program Project Expendit ures Five Years FY 2010 Project Expenditures Category 12/31/2009 FY 2009 FY 2008 FY 2007 FY 2006 Expenditures Expenditu res Expendit ures -Expenditures PF-04010 Cubberley Me chan ical & Electrical Upgrades B uildi ngs and Facilities 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 a nd 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 & Bu ildin gs Mechan ical Upgrades and Facilities PF-07001 Cu bberley Win g I Elev ator Bu ildin gs Upgrade and Facilities 170,312 4,825 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 U pgrade Buildings and Facilities General Fund Capital Improve ment Program Project Expenditures Five Years PF-07003 PF-07011 Roth Bu ildin g Maintenance Buildings and Facilities FY 2010 FY 2009 E xpenditures Expe nditures 12/31/2009 0 0 FY 2008 .. FY 2007 FY 2006 E xpenditures Expenditures Expenditures' 32,980 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 Buildin gs 1,880 and Theatre Exterior Paint and Facilitie s PF-10000 Civic Center Chiller Drive Buildin gs 803 Replacemen t 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 10,076 247 Page 6 of 18 Exhibit A General Fund Capital Improvenient Program Project E xpenditures --.Five Years FY 2010 Pr oject Project , Project Expe nditu res Number Title C ategory 12/31/2009 FY 2009 FY 2008 . FY 2007 FY 2006 Expendit ures E xpenditures Expenditures •E xpenditures PF-93009 PG -00010 PG -09003 ADA Compliance Park Facilities Improvement Park Mainten an ce Sho p Remodel AC -86017 Art in Public Places AS -08000 Acquisition of Los A ltos Treatment Plan t AS -09000 City of Palo Alto Municipal Airport Transitio n Project 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 Lan d and Lan d Improvements 12,272 21,556 64,410 29,545 112,256 Land and Land Improv ements 0 2,306,958 2,590,061 Land an d Lan d Improvements 43,675 39,075 PE -09004 Los Altos Treatment Plan t Land an d Lan d Improve ments Master Plan Stu dy 3,803 135,905 $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 Improveme nt Program Project Expenditures --Fi ve Years FD -09002 Jaws of Life Hu rst 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 Police Vehicle - Mou nted Video R ecordin g PD -07001 SWAT Van Replacement PD -08000 Crime Scen e Evidence Collection Vehicle PD -93012 Fire Communica tion s Computer Systems PD -99013 Police Rec ords Management System F Y2010 Expenditures 12/31/2009. Miscella ne ous Miscellaneous Miscellaneo us 48,352 0 Miscellaneo us Miscellaneous 0 Miscellan eous 0 Miscellaneou s Miscellaneou s 0 Miscellan eous 0 Miscellaneou s 0 60,905 732 5,026 112,526 203,193 6,812 31,307 FY 2007: FY 2006 Expenditures Expenditures 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 7-7 General Fund Capital Improvement -Program Project Expenditures Five Years Project Project Nuptber . -Title FY. 2010:: . Project Expenditures Category=_ 12131/2009 FY 2009. FY 2005_ FY: 2007..: Expenditures Expenditures Expenditures . Expenditures: PE -96008 D owntown Urban Desig n Improve men ts Miscellaneo us PL -02023 Master Schematic Design Miscellane ous PO -10002 Do wn town Tree Grates Miscellane ous 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 Installations 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 Improvement Progra m Project Expenditures - Five Years Project Number Project Title FY 2010 Project .. . .. E xpenditures Category 12/31/2009 FY 2009 FY2008FY 2007 FY 2006 E xpe ndit ures Expenditures Expenditures " Expenditures .: PG -08001 Golf Course Driving Ra ng e Tu rf & Nettin g N on -I nfrastr uctur e Management Plan PL -05002 Charleston/ Arastradero Non -Infrastructure Corrido r Plan Management Plan 0 0 PL -06001 Adobe Creek Bicycle Bridge Non -Infrastr ucture 0 4,184 Replacement Management Plan PL -06002 Comprehensive Pa rking Non -Infrastructure Signage Plan Management Plan PL -06005 Installation of Ticket Machines Non -Infrastructu re Management Plan PL -07001 In termodal Tran sit Cente r No n -Infrastructure Management Pla n PL -07003 Palo Alto Caltrain Station Non -Infrastructure Con nectivity Improvements Man agement Plan 0 0 0 0 511,921 32,076 529,889 218,819 43,470 4,000 2,250 33,994 7,416 12,662 $6,367 $440,009 $2,977,322 $1,457,168 $706,672 Page 10 of 18 Exhibit A General Fund Capital Improveme nt . Program Project Expenditures - Five Years , s Project Number FY 2010 FY 2009 FY 2008 FY 2007 -FY 2006 Project Project Expenditures Expenditures Expenditu res Expendit uresExpenditures Title Category 12/31/2009 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 Off -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 ntProgram Project Expendit ures- Five Years- -• Project Project Pr FY 2 .010 Proj ' Project Expendit ures Nu mber Title Catego ry 12/31/2009 FY 2009 FY 2008 FY 2007 ' FY 2006 . .. Expenditures E xpenditures Expenditure. 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 Program =Project Expenditures - Five Years Project Number Project Title FY 201.0 Project . E xpenditures 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 PE -07005 PE -07006 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 Park R estroom Installation Johnson Pa rk Impro vements Hoover Park Improvements Ramo s Park Improvemen ts California Avenue Improvements Bou Iware Park Improve ments Parks and Ope n Space Parks and Open Space Parks a nd Open Space Parks and Open Space 17,570 41,134 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 0 146 Page 13 of 18 Exhibit A General Fund Capital Improvement Program. Project Expendit ures Five Years FY2010 Project Project Project Expe nditures Number Title Category 12/31/2009 FY 2009 FY 2008 FY 2007 FY 2006 Expendit ures E xpenditures Expenditure s; Expenditures ,. PE -09002 PE -98003 PG -04010 Greer Park Phase IV Mitchell Park Facilities Stan ford/Palo Alto Commun ity Playing F ield PG -06001 Tenn is and Basketball Court R esurfacing 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 Category 12/31/2009- Number Title _... General Fund Capital Improvement Program Project Expenditures - Five Years FY 2010 FY. 2009 " FY 2008 FY . 2007 FY 2006 Project Project Expenditures Expenditures E xpenditures Expe ndit ures � � , > es Expenditures .. Projec t Pro' Page 15 of 18 Exhibit A General Fund Capital Improvement Program Project Expenditures Five Years Project . ... Project Project,. Number Title. .. Category FY 2010 FY 2009 FY 2008 =FY 2007 F\ 2006 Expenditures Expenditures . Expenditures Expenditures E xpenditures 12/31/2009 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 La ndscape 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 Five Years . FY 2010 Project Project ` Project Expe nditures Number Title Category 12/31/2009 FY 2009 FY 2008 FY 2007 Expenditures Expenditures E xpenditiri-es FY2006 Expenditures PE -93010 PF-00104 San Anto 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 Sidewalls PL -04010 Bicycle Tran sportation Plan Streets Implemen ta tion Pro ject and Sidewalks PL -05003 College Te rra ce Traffic Streets Calmin g 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 Fu ndCapital Improvement Program Project Expendit ures - Five Years Project Nu iriber Project Title Project Category FY 2010 FY . 2009 FY 2008 Expenditures Expenditu res: Expe nditures 12/31/2009 FY 2007 FY 2006 Expenditures Expe nditures PL -07002 El Camin o Real/ Stanford Intersection PL -11000 Highway 101 Pedestrian / Bicycle Overcrossin g Streets and 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 (SW) 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 IMP ROVEMENT PRO GRAM P ROJECTS ST ATUS GENERAL FUND A DMINISTRATIVE SERVICES DEPARTM ENT P roje ct . • Project Project._ Number • Title Category . Total B udget F ruur I nception _FY 2010 A vailable Budget F' Y 2010: Expenditures . FY 2010 FY 2010 FY 2010 Labor Y;o nti nge ncies E ncumbrances Remaini ng Adju.sd ne nts Balance Percent Complete P roject. Estimated Completion Date AS -09000 City of Palo Alto Mu nicipal Airport Tran sitio n Project Land and La nd Improvements $130,000 $7,223394 $90 ,925 $2326375 $43,675 $0 $0 $29 ,035 $18,215 $2,326,375 Design 68% Design J un 2010 Jan 2010 Airport Plan to be presented to C ouncil for re view and approval in first quarter 2010. 3rd and final payment of $2,166,667 (pl us i nterest 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 Number Project Title - Project C ategory Total . . Budget Fromi - . :- Inception - : FY2010. Available, -, :Budget FY 2010 .. .. FY 2010. FY 2010 . .FY 2010 Expenditures . Labor.. Coittinaenczest Encumb ra nces. .7djustments ltemaw rig Bal ance ' P • ent . Complete Project.Completion _St atus . . Date; Com ments AG09001 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% Design 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 SO 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 S0 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 $338,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 $0 $0 $0 $0 $175,000 0% Staff in initial planni ng and development of scope of c ontr act. OS -0000I O pen Space Trails & Amenities Parks and Open Space 51,721,121 $173,654 529,836 $0 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 $339,236 550,107 $5,848 50 50 837,600 $6,659 98% Complete Remaining baianre to be returned to infrastructure reserve. OS -07000 Foothills Park Road improvements Parks an d Open Spa ce $375, 000 5125,000 $0 50 $0 50 5125,000 67% 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 Parks and Open Space 580,668 855,205 $24,719 50 $0 $1,721 $28,765 64% O ng oing Byxbee Park trail repairs were completed in FY 2009 . PG - 06001 Tennis & Basketball Court Resurfacing Parks and Open Space $533,653 5233,320 $74,788 50 50- $0 $158,532 70% O ngoi ng Projects pla nned for FY 2010: Basketball court resurfacing at Terman 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, Sigaage, Fen cing, Walkways, and Perimeter I andsra ping Project Categor Parks and Open Spar. Totah. Budget Tram .. I nceptio n $373,358 FY 2010 Available Budget $104,648 FY 2010 Expenditures $27 ,989 FY 2010 Labor - Adj ustments $0 FY 2010 C.ontingencies $0 FY 2014 Encumbrances 93,953 Remai ning Bala nce $72,706 Perce nt Complete:, Project Status Estimated Completion 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 90 $0 $0 $0 $47,165 92% Complete Remaining bala nce to be returned to i nfrastructure reserve. PG -09002 Park an d 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: Pump 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 repair), Eleanor Park (water circuit), and Rinconada (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 $2 03,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 Total Budget From Inception FY 2010 Available .: Budget FI 2010 Fe 2010 F:: 2010. . fl 201E :r Expenditures . - - Labor Co ntinge ncies .-E nctimbrances Adjustments 56,251 Percen t: Complete Project Status -Estitnated;.: • Completion. Date Stanford U ni versity's proj ect ma nager is worki ng with the Fire Departme nt on completi ng the pr oject. Comments"' FD -08001 Fire Station #6 Improv emen ts Buildi ngs and Facilities $60,000 $60,000 $0 $0 $o $3,749 6% Design Ian 2010 FD -09001 FD -09002 Fire Apparatus Equipment Replacemen t Jaws of Life Hurst T ool Replacemen t Miscellan eous Miscellan eou s $309,635 $65,000 $255,818 $4,095 56,651 $261,283 $0 $0 $0 50 $0 $0 $0 $1,186 (5,465) 4,095 5,465 I00 % Complete 94 % 99 % Complete Complete Project is overspe nt . Remai ning bala nce of FD - 05000 will be tra nsferred to this project to co ver deficit. 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 lueuiter. FY 2010 MID -YEAR CAPIT AL IMP ROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PLANNING DEPARTMENT Project $121,001 Available Bridget FS'201 a - Expe nditures.- F'Y .2010 - Lalfor . Adjustments: FS;2010 Contine.enaci FIr 2010: J.xtctintbrances . Retna nun - Percent:: . Balanc e - Complete,. .Project Status C urran$ compl et ed this project in the winter of 2008. C aII'mas final accamtmg has now been r eceived, and project can be cl osed. PL -02005 El Camino Rea l/ Ventura Avenu e Traffic Sign al Str eets and Sidewalks 511,001 SO $0 SO SO 211,001.00 100% Complet e PL -05002 Charleston/ Non- ArastaderoCorridor Infrastructure Plan Management Pla n $1 ,209,545 5428,761 $0 $0 S0 584,003 $344,758.00 71 % Constr uction Sep 2010 Inst allation of the Phase 1 trial pr oject (Gu nn High Scho ol sign al a nd 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 (Aresttadero Road trial stripi ng) was appr ov ed by th e City Cotmcl in J uly 2009 . Project will be implemented in the s ummer of 2010. PL -05003 (College T erra ce Traffic Cvlming Streets an d Sidewalks $234,573 $74,600 $0 30 SO $1 $74,599.00 68% Construction Sun 2010 City C ouncil appr oved traffic calming plan in Nov 2004. I nstallation of the trial plan traffic cahni ng measures was completed in Nov 2006 , in cl uding 6 speed tables and 5 t raffic titles. The Planni ng and Transportatio n Commission reviewed the dial 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. PL -06001 I Adobe Cree k Bicycle Non - Bridge Replac --ant Infrastruc ture Mana gement Plan $50,000 $45,816 $0 SO $0 $45,816 .00 891 Construction Dec 2009 City of Los Altos is lead agency f or this i nter - jurisdictional project. Co nstruction kunrpletcd in summer 2009: City awaiti ng fin al acc ounting and i nvoici ng from Los Altos for City's local match. PL -06005 IInsta llation of Ticket No n- $94,900 Machines In frastructu re Management Plan $38,578 50 $0 $0 $6,894 $31 ,684.00 6798 Complete TBD PL -07000 (Downtown North Streets $60.000 Traffic Circle and H ardscape Side walks PL -07001 IntemodalTransit ` N on - $837,380 Center I In sysru cture Man agement Plan 260.000 $837,380 SO SO $0" SO 20 $0 20 So $60,000.00 $837,380 .00 0% 090 Pre -design Pre -design TBD TBD Before closing project, st aff will consult with Chamber of Commerce Downtow n Parki ng Committee regarding the need for additi onal ticket mach' Project will be impleme nted by Public Works Operations in conjunction with sidewalk repbs<'nt project. The i nitial teclnical sm,t+ 'es and work pr ogram for the next phases of the project 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 me asure 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 OGRAM PROJECTS STATUS GENERAL F UN D PLANNING DEP ARTMENT .. . _ . Project Number PL -07002 _,. ._..-- . - .:. Proj ect .- fille - .' -Proje ct ... . . Catczors Total - B udget- . fr om . `; 1' nceptlnr)-- $155,000 F 2010 -_ Available ; -Su¢get $152,510 . , -FY 2010.. - _. Expe nditures .-.; -' $10,034 F' 2010 . Labor .. - Adjustments'.. $0 FY 2010 Covtingencie§ :- $0 9 Y 2010.:. Encumbrances $97506 - Rem aining ..B alance .. $44 ,970 .00 Percent . Complete 71% Project ...,_Statics ' Estimated _ . Coniplefton: ., -Date : .. . Comr ntnt El Camino Real/ Stanfo rd Intersection Streets and Sid ewalks Design J un 2011 C ou ncil accepted grant finding from the VTA for this project in Apr 2007. Funding . agreements with C alTrans were executed in Apr 2008. The design and environmental c onsulta nts were hired in April 2009 . Proje ct f unds and approval by CalTrans m ust be secured by June 2010. PL -07003 Palo Alto Caltr ab Sta tion Conn ec tiv ity Improvements N on- In frastructure Man ageme nt Pla n $30,000 $30,000 S0 $0 80 $0 330,000.00 0% Pre -desig n TED No activity to date. PL -11000 Highway 101 Pedestrian / Bicycle Streets and Sidewalks 5100,000 5100,000 57 ,694 $0 $0 $100,000 ($7,694 .00) 108% Project to be take n over by Public Works. New pr oject nornirr is PE-11011 . expenditures to be b oasferred to new proje ct at mid -year, FL -00026 Loca l and Neighborhood Collecto r Street Truffle Calmin g Pro gr am (SIF) Stre ets and Sidewalks $920,000 $431502 59 ,744 $0 $0 SO $421,758 54 % C onstru ction Ongoing The Planning and Tra nsportation Commissio n recommended — and the PLs eei ug Director approved -- the permane nt retentio n of the P L,p_r A venu e trafEc calming trial in Jan 2008. Lincoln Avenue trial traffic calmi ng plan was initiated in fall 2008 a nd eval uation will be completed ;nearly 2010 . Pla nning 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 and Sidewalks $339,497 $281,014 $10,483 SO $0 50 5270,53! 20% D esign Ongoing MaybelliDonald Bicycle Bo ule vard trial plan was c ompleted in Aug 2007. The trial E valuatio n it -alt was reviewed by the Pl anning and Transportation Commission in May 2009 . The PTC recomme nded rete ntio n of the pr oject on a permanent basis . Staff , i nitiated the design for the Park B oule vard btlte boulevard in summer 2009; first community -meeting held November 2009 . PL -06002 Comprehensiv e Parking Signage Plan Non - Infrastructure Man agement Plan $475,000 $427,530 $0 50 $0 $9,002 $418528 12 % Constr uction Jun 2010 Bid d ocume nts compl et ed is Dec 2007. Contract awarded in Jun 2008. Installation of Dolor zo ne signs was compl et ed in Nov 2008. Further sgnage, kiosks , etc.. will be p ursued in 2010. 1'7.-98013 School Commute Safety Improvemen ts (SIF) Streets and Sidewalks 5150,000 $108,659 $0 $0 $0 $0 8108,659 28% Design Dec 2010 Funding from this pr oj ect will be used as the l ocal match finding f or the Stanford Av en ue/El Camino Real Stree scap c Project in 2010. Page 6 Attachment 3 FY 2010 MID -YEAR CAPITAL IMPR OVEMENT PROGRAM P ROJECTS ST ATUS GENERAL FUND POLICE DEPA RTMENT TataL. Budget Project Project . ..Project - From '. Nmu her Title - Category inception FY2010 :trail sle' . 2030. . FY 2010 FY 2010 NY 2010 kshunates1 Expenditures :...Labor ' Conti ngencies r . ;ntumb rsuees - `. Renrti nin„ - Percent " Project Cor aplehion.'- Adjustments'- _ - - B ala nce Complete " 'Stat us Date Remaining balance to be ret urned to reserve. PD -04010 Fire Portable Radio Replacemen t Misc ell aneous $245,584 $724 $0 $0 SO 50 $724 100% Complete PD -05010 Police Vehicle - Motmted Video Recording Miscellaneous $200,000 53 ,931 so $0 $0 $1 $3,930 100% Complete Remaining balance to be return ed to res erve . PD -07000 Mobile Command Vehic le Non - Infrastru cture Management Plan $700,000 5700,000 S0 SO $0 $0 $700,000 Constructio n J un 2010 Vehicle curre ntly under c onstmction. PD -03000 Crime Scene Evidence Co llection Vehicle Miscellaneous $130,000 $130,000 50 $0 50 50 $130,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 nicatio ns Computer Systems Miscellaneous $531,287 51,645 SO $0 $0 $1 $1,644 100% Complete Remaining balance to be retu rned to reserve . PD -99013 Police Records Man agement System Misce llaneou s $526, 435 $4, 023 S0 $0 S0 $1 $6,027 100% Complete Rem aining balance to be retur ned to infr astructure res erve at mid -year. Page 7 Attachme nt 3 FY 2010 MI D -YEA R CAPITAL IMPROVEMENT PRO GRAM P ROJECTS STATUS GENERAL FUND PUBLIC WO RKS DEP ARTMENT Project Number -Pro 'ed -" v" Title -_. . Project . . , C ategory T otal Budget , l From I nception F1 2010 FY 2010 Available . Evpendttutes Buctd FY 2010 kY 2010 .- ..Labor Contingeueres Adjustments 1"Y 2010 I Laeumbr,rn es I ern min„ .1 . Percent Balance Complete _ Projet t ^. . St atus Estimated Completio n Dante .. Comme nts 5-CiV7,U:.54 Stir 41.;iii IFgc7 rlN`*t 7 !;',1:1t414! '!IM PE -00105 Embarea dera Road Median Improvemen ts Streets and Sid ewalks $126,502 $2,973 50 $0 50 $0 $2,973 10091 Complete Remaining balan ce will be retur ned to i nfrastructure reserve. PE -00110 Co llege Terrace Park Improv ements Parks and Ope n Space $395,687 $6,842 $521 $0 50 55,340 $981 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 $0 $512 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 $0 $0 591,166 5% 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 dscapin g Improvemen ts Parks and Open Space $237,217 $9,136 $688 50 $4,924 $266 $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 $633, 226 $518,341 $137,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 $725, 270 5589,013 $0 $0 5155,704 (519,447) 10391 C omplet e Additional appropriation of 520,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 Gree r Park Phase IV Parks and Open Space 51,891,017 $1,721,652 $54,825 $0 $14,002 51,356,106 $296,719 84% Constructi on No v 2010 PE -09004 Los A ltos Treatment Plan t Master Plan Study Land and Land Improv emen ts 5160, 300 $28,195 $3,803 50 $0 524,392 $0 100% Desig n TBD Consulta nt under contract Preliminary design in progress . PE -10002 V entura Community Cen ter and Park . Bu ilding and Facilities 5200,000 8200,000 $7,712 $0 $0 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 $131,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)5 . Total Budget FY 2010 .' FY 2010 FY 2010 FY 2010. FY 2010 . Estimated' From _ Available-rEape ndituri Labor Contingencies : ...Ew a ibrances . Retuai4ing.. . Perce nt ::. Project . . Cempleuon. Co nti nge ncies ... ,,... _ �. � {M t � I.SFI.� . �t=e{l,{lWM I { k PF-04000 Security System Improvements Buildi ngs and Facilities 5275,000 $63,349 50 $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 Facilities 5251,445 $201,308 5194,600 50 $8,835 50 ($2,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 Upgra de Bu ildings and Facilities 5266,057 5232 ,830 50 $0 $0 $15355 5217,475 18% Design J un 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 $263,510 $0 $0 50 $0 5263,510 38% O ngoi ng All i nitial work completed. Ongoi ng work to include roof and window repair to maintain i nt egrity of struct ure. PF-08000 Art Cen ter K iln Hood Replacement Buildings an d Faciites $49,821 $4,848 514,570 $0 50 $0 (59,722) 12056 Complete Additional appropriation will be made t0 cover project overspe nding . PF-09002 Lucie Stem Community Center and Theatre Ex terio r Paint Bu ildin gs and Facilite s 580, 000 580,000 51,880 50 $0 50 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 5803 $0 $0 5125,000 $60 100 % Co nstructi on Jun 2010 Construction 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 . PF-10002 Lot "J" Cowper/Webster Structural 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 5300,000 $0 50 $0 $0 5300,000 0% Page 9 Attachment 3 FY 2010 MID -YEAR CAPITAL IMP RO VEMENT PROGRAM PROJECTS ST ATUS GENERAL FUND PUBLIC WOR KS DEPARTMENT Project Project Tot al B udget FY 2010. . FY 2010 FY 2010 IA' 2010 FY 2019 Estimated Project From Available Expe ndit ure's Labor C antingencie: Encumbra nces J Remaining Perce nt 5 Project, Completio n u r ti.4j�t-t_r ;, ,. „ ,, ,,cA'i 1 °`-' ; ;;'4' dam `tY'g , PE -00104 San A nto nio Road Median improvements Streets a nd Sidewalks 51,302,275 5219,619 $179,796 50 50 53,192 $36 ,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 Building and Fa ciliti es $4,383,532 $170 $0 $0 50 $1 $169 100 % C omplete Remai ni ng balance will be retur ned to i nfrastructure reserve. PE -04012 Mitchell Park Library & Community Center Impro vemen ts Buildings and Facilities 51,817,994 $254,811 566 $0 SO $2 5254,743 100% Complete Completed . Balance of 5254,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 $16525 511,840 57,108 100% Complete Construction complete. Awaiting final project in voices . PE -05001 Photovoltaic Design and Installatio ns Non Infrastructure Managemen t Plan 53,632,637 5131,843 56,367 $0 $0 $83 $125,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 53,496. 823 52,777,776 5410,349 $0 53,394 $1,895,120 $468,913 87% Constructio n Oct 2010 Construction bega n Oct 19, 2009 . PE -05300 Arastradero Preserve Gateway Parks and Open Space 5810, 052 $847 50 $0 $0 $3 5844 100% Complete Retraining balance will be returned to infrastructure reserve. PE -06006 Alma Street Lamr1«ape Improvements Streets and Sidewalks $131,217 544,494 526,035 $0 $0 513,324 $5,135 9641 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 558 $517,519 12% Design Dec 2010 Se al Park Restroom construction will comme nce the winter of 2009/2010 . PE -07007 Cu bberiey Tu rf Renov ation Par ks and Open Space 51,809,936 51,618,986 5863,504 $0 52,267 $244 ,851 $508,364 100% Complete Con stru ctio n complete. Project still under warra nty period. PE -09003 City Facility Parking Lot Maintenance Buildings and Facilities 5330,000 5330,000 $0 $0 $0 $0 $330,000 0% Ong oi ng PE -09005 Downtown Library Impro vemen ts Buildings and Fac ilities $3,940,607 $3,862,445 $330,799 $0 $0 5108,246 $3,423,400 13% Design Mar 2010 Construction will start AprMay 2010. Page 10 Attachment 3 FY 2010 MID -Y EAR CAPIT AL IMPROVEME NT P RO GRAM P ROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPA RTMENT - Project' -Project F 1' 2010 .,. BudnetFY 2010 FY 2010 _ FY 2010 Project.. From . 'Available:: Lape nditures Labor Contingenci es . FY 2010 J, nen.mbrances Rem ai ni ng. Perce nt e .: Project .. Completio n PE 09006 Mitchell Park Library & Comm unity Cen ter (New Co nstruction) Building and Facilities $50,417,683 $49,908 ,659 $L845,621 $0 $0 11,255,725 $46,807,3I3 7% Desi gn Sep 2012 Constructio n to begin June 2010. PE -09010 Library & Commun ity Center Temporary Facilities Buildings and Facilities $663 ,866 $635,000 1141,817 $0 $120 $87,416 5405,647 39% Construction May 2010 Co ntraction wi11 start Feb 2010. PE -89004 Yacht Harbo r Improv ements Buildings and Facilities $2 ,103,106 $12,167 50 $0 $0 12,151 $10,016 100% - Complete Remaini ng balance will be returned to i nfrastructure reserve. PE -95030 Downtown Pa rking Str uctu re Industrial Cost Pool Miscellan eous $33,425,251 $383 ,406 $0 $0 $0 $0 $383,406 100 % Complete Remaining balanc e will be refunded to property ow ners 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 % 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 6890 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 $158,991 $18,969 $23,940 99% Complete Remaini ng balance to be returned to i nfrastruct ure reserve. PF-04010 Cubberley Mechanical & Electrical U pgrades Buildings and Facilities $1,614, 695 $45,931 $9,369 $0 $0 $O $36,562 98% Desi gn Proje ct on hold due to staff vacancy a nd lack of capital funds. C onst riction phase to be rescheduled for a later fiscal year. PF-05002 Municipal Se rvic 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 V pgtades Buildings and Facilities $1,787,046 $1,576,489 $185,663 10 $16,513 $3,270— $1,371,043 23 %Design Dec2011 Foundations architect completi ng construction do cuments phase. C onstruction sch eduled f or FY 2011 . Page 11 Attachment 3 FY 2010 MID -YEAR CAPI TAL IMPRO VEMENT PROG RAM P ROJECTS ST ATUS INTERNAL SER VICE FUND TECHNOLOGY FUN D ADMINISTRATIVE SERVICES DEPARTMENT Told r Budget Av ailable Pr oject Project Project From Budget _, .N tunlxr„-'- .:.. ....Title _ Catego ry_.- ingeptio n_ ,. .. Ty.2010 FY2010 Expenditures B udget Estimated L abor FY 2010 FY 2010 Rema ining Percent Project Completion Adjustments Contingencies .Enc umbrances Balance Complete j Stains Date .. T E-01006 Enterprise Backup Solution Minor $139,512 $69,512 $885 So $0 si $68.626 51% Pre -design Dec 2010 Work delayed due to workload issues. 1'E -0I012 IT Disaster Rec ove ry Plan Minor $840,000 $509,897 $186 $0 $0 51 $509 ,710 39% Construction Dec 2010 A draft dic'tter reco very pl an has bee n completed. TE05003 In ternet Site Upgrade Minor 5240,000 $74,107 53L845 50 50 $0 $42,262 82% Construction Dec 2010 Implementation of the intera ct is complete. Th e p ortion of the contr act de aling with the int raaet is 50 % complete . T E.06002 9-1-1 Emergency Phone System Upgrade Min or 5324,000 527,274 SO 50 50 53 $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 end of the fiscal year. 1'E-07001 Emergenc y Notification System Mino r 5150,000 550,000 $50,000 $0 $o $0 $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 F UN D ADMINISTRATIVE SERVICES DEPARTMENT Attachment 3 Proect Title • Project -• Cate ors . _ Total Budget - Available T nc�oa , -,� I'] X070 ,..-... FY 2010 �Iaxpndilureb Atlyuime nhsW .;F7i 2010 C4uticec - • FY 2010 Enamb rnces1----Ea]anec Rmuting,' _. .-_ BudgetProct Cntplet ........ .... • Perent Project St vtu.} ComretitsA ... .�. ., ...--. ,.. ..�.. -. . M..-..... ..,... .. TE-07002 Police Auto- Citation System Minor $125,000 $125,000 $57,809 SO $0 $5,780 $61,411 51% Pre -design Jun 2010 A ve ndor has bee n selected a nd hardware is being configu red and tested- T E-08000 Library Techn ology Plan Min or $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 $0 $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,044 $0 $0 $366 $69,292 72% Constructio n Dec 2010 IT is working with Fire Dep artm ent a nd Fleet Ma nagement to install mobile data computers. '1'E-09000 Public Safety Computer -Aided Dispatch Replacement Minor $1,300,000 $1,300,000 $0 $0 $0 SO $1,300,000 0% Pre -desig n Jun 2011 A vendor has been selected and negotiations are in progress. TE-09001 Fiber Optic COm,n,mic atio ns to Remote Radio Sites Minor $153,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 PROGRAM PROJECTS ST AT US INTERNAL SER VICE FU NII TECHNOLOGY FtJND ADMINISTRATIV E SE RVICES DEPARTMENT Attachment 3 Project .. Number ;.... `AF �,is;rcx_'u°o j ; Project .W LLTitle _ i4g aw ,I ',. Project : (ategory Total Budget From I nceptio n Available ' I:ndget fl 2010 FY 2010 is endrtures L abor 4d uslmenis FY 2010 Co nti genies FY 2010 1 Renaming 1 Encumbrances Balance Budget Perce nt ' Co fete Project. Stat us Estimated ' Completion Date Co nuaents TE-95016 Pe rmit Information Tracldn g System Multi - Year - 5980 ,050 52 .13,291 $2,915 $0 $0 $41,051 5169,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 535,100 30 SO $95,100 5694,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 -Yea r $5,018,476 5102,526 S0 $0 30 $0 $102,526 98 % C omplete Funds will be returned to finding source, 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 57,000,000 $1,353,675 $886 ,765 $0 50 $416,193 550 .717 99% Complete Fu nds will be ret urned to funding 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 $0 $0 $0 5142,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 51,130,000 $1,123,969 5308 30 $0 520,846 51,102,815 2% Pre -design De c 2010 The telecommunicati ons consultant has been collecting inventory i nform atio n and is in the paw of inter viewing represe ntatives of each department. TE-02015 Citywide G lS D ata, Infr astructure and Applica tions Multi -Year 51,770,322 $822,144 $102,199 $0 $0 5138,743 5581,202 67% Construction Dec 2010 Work co ntinuing on i ncorporati ng new mappi ng applicatio ns. TE-05000 Radio In fra structure Re placement Multi -Year $1,180,980 $723,191 50 SO $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 (R�) Implementation Multi -Year $45,000 527,600 $186 $0 $0 $1 $27,413 , 39% Construction Jun 2013 The intent is to carry this funding o ver to FY 2011, add fundi ng and utili ze for implementation per Library Techn Pla n. eRFID�g ogy implementation is being coordinated with the Library Construction/Rem odeli ng Projects. Page 14 FY 2010 MID -YE AR CAPITAL IMPRO VEMENT P ROG RAM PROJECTS STATUS INTERNAL SERVICE FU ND TECITNOLOG Y FUND AD MINISTRATIVE SER VICES DEPA RTMENT Total Budget Available Project loject Project . From , Budget FY 2010 ? umbe r Title C,ttegOrs- Inception - _y_, - F7i 2010; Expendit ures.. TE-07000 En terprise Application Infrastructure Upgrade Multi -Year 11,787,000 $726,362 $45,503 Atta chment 3 L abor FY 2010 Mjastments Continge ncies $0 10 B udget: Estimrtted FY 2010 Remaining .Percent Project Completion E ncumbra nces ' Balance Complete . Stat us:_ Date $2,126 $678,733 Merged with TE-02014. Conti nuing enhancements to the user i nterface for Utility Billi ng System. 62% C onstructi on Dec 2010 TF 07003 Bill and Payment Processing Multi -Year $220 .000 $23,450 SO $0 $0 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-118002 Electric Patient Care Report Multi -Y ear $65,000 $39,943 89,158 $0 50 $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. TE-10000 Collections Software Multi -Y ea r $79,800 $79,800 $0 $0 SO $79,800 0% Pre -desig n Jon 2011 RFP is being prepared . Page 15 FY 201011 -YEAR CAPIT AL EVFPR0VEMENT PROG RAM P ROJECTS STATUS IN TERNAL SER VICE FUND V EHICLE REPLACEME NT AND MAINT ENANCE FUND PUBLIC WORSS DEPARTMENT Attachment 3 .. Project N umber 7511si- -" .;.: ... . - .. -. . :. ..: .' Project - ... .. .. -. l�:^ — tt - 4ilr I.'.. 'Sl t',e : ,le - i 'o.ipu� 9 "1 7 : a7' ,r�. .„ 'u3}r 41411 Project C.ttegory Total Budget - .. .: . From . : - Inception " Available- Eu1ge1- F' 010 -_. FY2010 1 pendiltrr es kY 2010 .-Libor. 1 ': Af1juannents. - _Budget FY 2010 _ FY 2010 Remai ning Percent Conlin lock s - .1 F.at:urubrances -1 :. :- '13 .118nce. '. ' Cnminlete ' .. Aojecl :.. ; Status �' Ltin oced ComplrtWil - 1}ate. ' Comments VR -0000I MSC Fu el Stor age Tank Replacement Min or $225,000 59 .900 51 ,315 $0 50 $0 58585 96% Complete Funds will be reamed to funding source, after all invoices have been paid VR-01000 MSC Equipment Maintenan ce Facility Me zzanine St orage Area Minor $275,000 $16,478 50 50 $0 50 516,478 9400 Complete - 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 Repla cement Mrmr 51,616,860 $327,888 $144,716 ' 00 - 50 $182,426 0746 100% Construction Jun 2010 Liquid and Compressed Natural Gas (CNG) faciliti es arc complete and in service. Public CNG dispenser is complete, but compressor needs repairs, and a new ret ail CNG r ate ,Keds to be d eveloped. VR -01002 MSC Equipm ent Washing Facility U pgrade Mmar 5681,304 00 $O 50 50 $0 $0 100 90 Oilfield TBO On hold P -.-ling funding . V R-05001 Fuld Service Truck Min or 5125,000 5367 50 $0 50 51 $366 I00%C o mplete Funds se; be returned to funding source, after all invoices have been paid VR-06801 Replace City -Wide Fuel Transaction an d In venaory Manageme nt System Minor 5285,000 $285,000 511.9,248 $O $0 $43,225 5122,527 57% Ongoing J an 2010 Site hardware has been delivered, and softwar e upgrades have been installed V R-07001 Au tomated Motor Po ol Reservatio n and Vehicle 1Cey Management System Minor $105,000 580,258 50 $0 . $0 50 $80,258 24 % O ngoing J 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-07800 Scheduled Ve hic le and Equipme nt Replacaonoto Mumr $3,784,000 $611,148 5539,406 $0 $0 053,700 518,042 100%lCo mpletc F unds will be returned to funding source, after all i nvoices have be en p aid. VR-08000 V hide Replaecmrat Minor 52,500,000 51,052, 700 8847,726 $0 50 519,612 9185,362 93 % Complete Fu nds will be returned to f undi ng source, after all i nvoices ha ve beak paid VR •08001 New Vehicles ('2) For U tility Operations M inor $70,000 $24,035 50 50 5O 00 524,035 66% Compl ete Funds will be renamed 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 SERVICE FUND VEWCLE REPLACEME NT AND MAINTENA NCE FUND PUBLIC WORKS DEPART MENT Attachment 3 Project • Numhcr PntjnY - ... Title • Project • Oiteti ry • Total Budget From inception saliuble FY 2010 - Budget Cpilmaird . Budget EY 2010 - '-Labor -. FY 21110 -FY 2010 Re ncsirrirg;.. Percent Prue. i .. Completion .. - .. n FY 201es- 0 - Fspendiiur, ,Lrf,itctinN nis+' Contin;xitricp E ncumbrmr cc Paluntr: -` ". C.omi(•IC . - Statts-. -Dee - .0 ii. $1,793 ,844 V R-09000 Vaide Replacement $2545 ,000 $272 ,603 $0 $0 $79.682 $1,441,559 43% °ag ei ng - 7 2010 Awaiting purchase and deli very of se veral vehicles. V RA1010 Vehicle Maintena nce Facility Upgrades Multi -Year $610,000 9288,794 $10,229 00 $0 122,864 9255.701 58% Ongoing Ion 2010 Ongoi ng, awaiting delivery of equipm ent VR -07002 Diesel T ruck Engine Emissio ns Retrofits M ulti -Year 9685,000 9513,692 $0 $0 $292,291 $221,401 68% Mar 2010 Ongoi ng, retrofit of next gr oup of vehicles is early c omplete . VR-92006 Fad Tank Storage/Upgrade Multi -Year 9341,000 $87 ,351 $16 ,113 90 $0 $135 $71,103 79% Design Dec 2010 Project scope reduced due to imdequ arc funding . Estimat ed hid d ate Spring 2010. Page 17 FY 2010 MIDYE AR CAPITAL IMPRO'V'EMENT PROGRAM PROJECTS STATUS ENTERPRISE FU ND ELECTRIC FU ND UTILITIES DEPARTME NT Attachment 3 Project Project Number Title ' :. Protect :; Gateau rY ` :Torah.'' B udget apailable Budget :. Estzzuated Fr om B udget r 2010 FS 2010 1 \ 2016 Rem aining Percent Project Completion Inception'ures Co n: - Comme nts -- FY 201U Expenditures Co ntingencies Encumbr ances B alance Complete Status Date = EL -04010 Foothills System Rebuild Minor $850,000 3103,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 $0 $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 Rebuild (EL -05000) pr ojects . EL -10008 Advanced Metering Infrastru cture System Min or $210,000 $210,000 $145 $0 3100,000 3109,855 489E 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 co nstructi on. This project in volves upgradi ng Supervisory Control & Data Acquisiti ons (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 $3,800,000 $261,880 $0 $0 $0 $261,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 rem ovi 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 33,095,000 $. 54,987 $0 $0 $0 $54,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 $0 $0 $15, 094 95% C omplete System i nstalled . F unds will be retur n to reserves at year-end. Pa ge 18 FY 2010 MID -YEAR CAPITAL IMPRO VEMENT PROGRAM PROJECTS ST ATUS ENTERP RISE FU ND ELECTRIC FUN D UTILITIES DEPA RTMENT Pmiect Pr otect \umber Title Protect Category,. Atta chme nt 3 Budget A vailable' b:rvm Eud et F t"2010 '`Y 2010 :: F 4'2010 Rernaiw ng Inception "..FY 2010 Expe nditures 'Co nti ngencies l^ ucumhranees • .Bala nce Budget Percent Complete Estimated Project `.; Cow Ietion _. St rt us 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 ongoi ng 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 $1,600,000 $691,077 $210,443 50 $32,643 5447,991 72% Desig n and Construction Dec 2010 The project has bee n divided i nto phases. Phase I constr ucti 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 4112 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 Interbe Study EL -O6001_ EL -05003 Relocation - Alma Substatio n Multi -Year 52,435,000 $2,067 SO $0 50 $2,067 100% Complete Funds will be return to reserves at year- end. Page 19 FY 2010 MID -YEAR CAPITAL IMPROVEMENT PR OGRAM PROJE CTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT Attachment 3 Project Number Pr oject - 1 - .... Title Total Budget Project .: Froirt J Catego ry Inceptio n k ailable . Budget .. FY 2010 EY 2010 Expe nditures 1' Y 2010 Conti ngencies: FY 2410 Fne unibra nces Remai ning, Bala nce: Budget Percent Complete , Estimated Project' " Completion, Stat us Date Comme 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 c ompleti on in J un 2010 . EL -06001 230 KV Electric Intertie Multi -Year $500,000 $134,813 $0 50 $0 S134,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 nterconnectio n, therefore the project is not feasible . 11.06002 Undergro un d D istrict 45 Mu lti -Year $3,200,000 $2,776,091 $639,624 $0 $1,907,373 $229,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 $500,000 $391,264 $234,681 $0 5148,594 $7,989 98% Design J un 2010 Contract awarded. Implementatio n on - 86-137 ,• EL -08000 E. Charleston 4/12kV Conversion Mu lti -Year 5200, 000 $198,474 $14,998 $0 $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 $913,000 ($337,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 .. 1309000 Middlefield Un dergro und Rebu ild Mu lti -Year $75,000 $75,000 30 $0 $0 575,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 C onversion Multi -Year $20;000 $20,000 50 50 $0 $20,000 0% Design J un 2011 Preliminary design work to start in J an 2010. EL -09003 Rebu ild UG District 17 (Downtown) Multi -Y ear $1,100,000 $1,086,050 530,725 $0 3538,388 $516,937 53% Construction Jun 2010 Substruct ure in progress. EL -10006 Rebuild UG District 24 Mu lti -Year $585,000 $582,526 $28,513 30 $484,442 369,571 88% C onstruction Oct 2010 Substructure inst allatio n complete. Electrical design work in progress . Page 20 FY 2010 MID - YEAR CAPITAL IMPR OVEMENT PROGRAM PROJECTS ST ATUS ENTERPRISE FUND ELECTRI C FUND UTILITIES DEPA RTMENT Project Project Number' 'roudgta` . Bet A vail able' ..`: Budget Estimated' Project From Budget FY 2010 FY 2010 FY 2010 Remaini ng Percent Project- Cn mptet1oLr_ Catego - I aceptton FY 2010. .. Expenditures Conti ngencies Encrmib noes. . Ba3d nte Complete St atus D ate Comme nts Attachment 3 Construction is 99% completed. EL -11005 CAfifornia Ave. Business Distric t Rebuild (District 22) M ulti -Year 52,300,000 $40I ,889 $272,810 $0 $25,988 5103,091 96 % Constructio n Feb 20/0 EL -I1008 Re build UG D istrict 19 M ulti - Year 5560,000 5559,372 $876 $0 $147,672 $410,824 27% Constructio n Dec 2010 Substructure installatio n completed. Cable design and estimate on hold . EL -10009 Stree t Light System Conversion Project Multi -Year $100,000 $100,000 $6 ,553 $0 $5,047 588,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 FY 2010 MID -YEAR C APITAL IMPROVEMENT PR OGRAM P ROJECTS STATUS ENTERPRISE FU ND GAS FUND UTILITIES DEP ARTME NT Project Number ;y am GS -03010 CNG Sequential Fuel System Min or I ota1 B udget Available. Project From . Budget FY 2010 Category Incepti on FY 2010 E xpe nditures Attachment 3 FY 2010 FY 2010 . Remaini ng ConWt,ena:ies Encumbrances - Bal ance Budget Esti mated P erce nt ' Pr oject-. Completion; Complete_ Status' Date Continents .'-"r $75,000 $35,715 $0 $0 $35,715 $0 100% C omplete GS -07000 Elwell Cou rt T en ant Improv ements Minor 550,000 $44,620 $0 $0 $1 $44,619 II% Complete Funds will be ret urn to reserves at year-end . GS -08000 Gas Station 2 Rebuild Minor 3207,000 3203,584 $0 $0 $203,001 $583 100% Desig n Aug 2011 Repackaging Request for Proposal (RFP) out to bid J un 2010, constructio n FY 2011. GS -09000 Gas Station 1 Rebuild Minor $201,000 $201,000 SO $0 5201,000 $0 100 % Desig n Aug 2011 Repack aging Request for Proposal (RFP) o ut to bid T un 2010, constructio n FY 2011 . GS -10000 Gas Station 3 Rebu ild Minor 3207,000 $207,000 $0 $0 $207,000 $o 100% Desig n Aug 2011 Repackaging Req uest f or Proposal (RFP) o ut to bid Jun 2010, co nstr uction FY 2011 . GS -10002 Gen era l Shop Toolin g Minor 564,000 $64,000 $0 $0 $0 $64,000 5% Desig n Ju n 2010 GS -10003 Cathodic Cu rrent In terrupters Minor $300,000 $300,000 $0 $0 $0 $300,000 5% Design J un 2010 GS -00011 Compress Natural G as Station Mu lti -Year $440,000 $2,946 SO $0 $2,946 $0 100% Complete GS -01019 Global Position in g System Multi -Year $381,000 $118,863 $0 $0 $0 $118,863 75% Co nstructio n J un 2010 Integrating field data into mappi ng system, defini ng additio nal equipme nt needs . GS -08011 GMR - Project 18 Multi -Year $5,928,000 $5,447,844 $181,564 $0 $30,251 $5,236,029 35% Desig n Jul 2011 Project is in desig n pla nning stage. GS -09002 G MR - Project 19 Multi -Year $432,000 $431,932 $390 $0 $0 $431,542 0% Pre -design J u12012 Desig n will start upon completio n of Gas Main Replacement (GMR) 18 design. Page 22 FY 2010 MID -Y EA R CAPITAL IMPROVEMENT P ROGRAM P ROJECTS ST ATUS ENTERPRISE FUN D WATER FUN D UTILITIES DEPARTMENT Attachment 3 Total B udget' .Avail able :. B udget ." Estimated J J 3B udget - .. FY 1� Y2010 - FY2010 Remaini ng- : Percent Project:; Co mpletion Pro ject - � � '. Project ' "" :PTO Project - -.: From ��. �: ... '' N umber Title Category Inception FY 2010 .r Expendit ures Conti nge ncies Encumbrances Balance Complete .. Status::, : Date Coinments: 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 $0 $799,716 0% Desig n 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 $1,070,000 51,050,438 515,850 50 $0 51,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 $278,728 $1,345 $0 $105 $277,278 54% Pre -Desig n J un 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 $208,833 50 SO $2 5208,831 55 % Co nstructio n Ju12010 Purchasing additional generators . WS -08001 Water Reservoir Co ating Improvemen ts Mu lti -Year $2,050,000 $2,049,716 5284 $O $0 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 536,650,000 $31,797,171 53,952,829 $74,313 $7,179,644 $20,590,385 44% Design Dec 2012 Design consultant desig nated with design acti vity starti ng in Dec 2009. Co nstruction to start No v 2010. Page 23 FY 2010 MID -YEA R CAPIT AL IMP ROVEMENT PROGRAM P ROJECTS STATUS ENTERPRISE FU ND WATER FUND UTILITIES DEPARTM ENT Attachment 3 Total .. .B udget :Available . Proje ct From Budget • FY201 g © Category. Inception _. FY 2010 ..:: .Expenditures $2 ,963,000 Budget Estimated Fe 2010 FY2010 Rencunng Percent Protect 'Completio n Contingencies Eoetimbrauces . .; .Balance.:_ Cornp] et e =Status: Rafe .. Co mments_::` WS -08017 WMR - Project 22 M ulti -Year $2 ,742,483 $312,390 $0 52,550,879 (5120,786) 104% Construction Oct 2010 S ubmitt ed b udget ch ange request for additio nal fu ndi ng 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 S60,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 -1000I WMR - Project 24 Mu lti -Year $292.000 $292,000 S14,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 FY 2010 MID -YEAR C APITAL IMPROVEMENT P ROG RAM PR OJ ECTS STATUS ENTER PRISE FUND WASTEWATER C OLLECTION FUND UTILITIES DEPARTMENT 'rot: B udget From �Inceptio n Available Budget F Y'NI0 Attachment 3 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 Prepara tion 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 B udget Available B udget Bstimated'. Project prom Budget Y '2010 F] 2010 1 Y 2010RemainingRemaung FY Percent Project_ ti orripletion (ategorti Inceptio n FY 2010 Expenditures Continue ncies, Eiteur branecs••-"B at anee .; Complete Status 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 $325,000 $74,891 5399,907 51,355,613 $55,913 50 50 $23,705 $31 ,540 5106,349 $0 $0 $0 50 SO 50 $0 5a 50 $50,654 587,460 $48,882 $8,613 $61,749 5325,000 $532 5280,907 51,200,382 $77 ,300 88% Complete 5% 100 % Design Design 30% Desig n 20% Desig n Ju n 2010 Funds will be return to reserves at ye ar- e nd. 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 . 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. 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 . 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 a nd 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 Feasibility 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 IMPROVEMENT PROGRAM P ROJECTS STATUS ENTERPRISE FUND STORM DRAINAGE FUND PUBLIC WORKS DEPARTMENT dotal.. • Budget. From inceptio n Available Budget FY 2010 Attachment 3 B udget .. FY 2010 FY 2010 FY 2010 Remai ning Percent Project Expenditures Co ntinge ncies .E ncumbrances -Balance Complete -,Status Estimated Co mpletion D ate -- $830,081 5784,859 $128,850 50 $540 ,624 $115,385 86% Constructio n Feb 2010 Design performed by in-ho use staff . Constructi on c ontract awarded to Peak E 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 $48,818 99% Post - constructio n maintenance & mo nit ori ng Jim 2010 La ndscape mai ntena nce a nd mitigatio n m onitori ng are the o nly re maini ng tasks . SD -06104 Conn ect Clara Drive Storm Drains to Matadero Pump Station Mu lti -Year $953,480 $1 $0 50 SO $1 100% Pre -D esign On h old. SD -11101 Char ming Aven ue/Un coln Avenu e Storm Dra in Improv emen ts Multi -Year 5820,000 $820,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 PROJECTS STAT US ENTERPRISE FUND WASTEWATE R TREATMENT F UND PUBLIC WOR KS DEPARTMENT Total Budget Project Project Project From., Number .Title Categ ory I nception Availabl e Budget F]i 20 .10 Atta chment 3 k Y 2Remaini ng eProject Budget X]st unated . 2010 FY 2010 FY 030 ' Rmini n'- Prcent ` . a o(U ntpleti�m Expenditures Co nti ngencies Enc umbrances Balance - Complete Status -' 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% Planni ng J un 2012 WQ-04010 Replacement ofFristin g Reclaimed Water Pipes Multi -Year $16,800,000 $1,119,612 $14,497 $0 $738,159 $366,956 98 % Complete Constructio n 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 Alt o 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 53,250,000 $1,879,047 584 ,087 $0 $128,711 51,666,249 49% Design Dec 2010 Ongoing retrofit projects . WQ-06014 Disinfection Facility Improvement Program Mir Multi -Year 521,468,987 520,395,091 $1,993,962 50 $6,843 ,965 $11,557 ,164 46% Constructio 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,906 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 20,381 2,423,677 2,256,296 344,176 229,370 GS -07002 Gas Main Replacements, GMR-Project 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 $1,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 (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 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 (SEIU), adopted by Resolution No. 8658, is hereby amended to add one new classification, change the compensation for one existing SEIU 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 ClassficatirnTitle Cathodic Protection Tech Assistant (new position) Cathodic Technician (rate change) Tree Maintenance Specialist (title change from Tree Maintenance Person) 5 5 5 TopStep 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 $974,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 52,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 51,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 $104,782 $322,079 5294,906 $133,232 5936,448. 5158,959 Overtime Net Cost Actual Expense $1,956,529 $1,582,858 $1,860,757 $1,744,076 $1,591,261 51,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 Pa rk 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%