Loading...
HomeMy WebLinkAboutStaff Report 1442City of Palo Alto (ID # 1442) Finance Committee Staff Report Report Type:Meeting Date: 3/15/2011 March 15, 2011 Page 1 of 19 (ID # 1442) Council Priority: City Finances Summary Title: FY 2011 Q2 Financial Results & Midyear BAO Title: Finance Committee Recommendation Regarding Adoption of: (1) Budget Amendment Ordinance Amending the Budget for Fiscal Year 2011 to Adjust Budgeted Revenues and Expenditures in Accordance with the Recommendations in the Midyear Report and (2) Resolution Amending the FY 2010-2011 Compensation Plan for Classified Personnel (SEIU) Adopted by Resolution No. 9088 to Correct the Compensation for One Existing SEIU Classification and Change the Titles of Two Classifications From:City Manager Lead Department: Administrative Services Recommendation Staff recommends that the Finance Committee recommend to the City Council adoption of the attached Budget Amendment Ordinance (BAO) (Attachment 1) which includes: a. Proposed midyear adjustments to the Fiscal Year 2011 Budget for the General Fund, Enterprise Funds, Special Revenue Funds, Internal Service Funds, and Capital Improvement Projects Fund (Exhibit A). b. Fiscal Year 2011 Midyear CIP Adjustments (Exhibit B). c. Amendments to the Fiscal Year 2011 Table of Organization (Exhibit C). d. Amendments to the Fiscal Year 2010-2011 Service Employees’ International Union (SEIU) Compensation Plan (Attachment 6) The following are attached as informational items; no action is required on these items. 1. General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 (Attachment 2) 2. FY 2011 Midyear Capital Improvement Program Projects Status report (Attachment 3) March 15, 2011 Page 2 of 19 (ID # 1442) 3. Continuous Capital Projects Expenditures for Fiscal Years 2007-2011 (Attachment 4) 4. Graph depicting General Fund Transfers to Infrastructure Reserve for Fiscal Years 2007-2016 (Attachment 5) 5. Police and Fire Departments Overtime Analysis for Fiscal Years 2006 through 2010 with Fiscal Year 2011 Data Through January 12, 2011 (Attachment 7) Executive Summary The documents attached summarize and outline changes to the City’s Fiscal Year 2011 budget. As revenues and expenditures may vary significantly from the original budget plan, changes become necessary. These require budget amendments to department budgets which Council must review and deny or approve. Midyear adjustments result in a $0.5 million contribution to the BSR which comprise of a $2.0 increase in revenue and a $1.6 million increase in expense. This addition to the BSR is offset by previously adopted BAOs of $0.9 million and results in a net BSR draw of $0.5 million. The BSR balance as of midyear is $26.9 million, or 19.3 percent of adopted expenditures. Background This report summarizes changes to the Fiscal Year 2011 Adopted Budget resulting from financial activity through December 31, 2010. Where possible, budget changes are held until the midyear report is presented to Council in an effort to consolidate information and streamline the Budget Amendment Ordinance (BAO) process. This report is organized by fund with a primary focus on major changes in the General Fund. Adjustments, as well as all fund summaries, are included in Attachment 1, 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, 2010. An update to the Long Range Financial Forecast (LRFF) was presented to the Finance Committee on February 1st. At this time, the LRFF FY 2011 expected revenue to be $1.5 million higher than the adopted budget. Despite this anticipated improvement in revenue, a $0.9 operating gap was expected at the end of FY 2011. In the LRFF, this operating gap is due to Council approved BAOs (see Table 1) and increased overtime budget for Public Safety departments. In light of this anticipated operating gap, departments were directed to maintain their current level of appropriations and carefully monitor their expense. Discussion General Fund -Midyear Financial Report The second quarter has shown improved General Fund revenues. In addition to the $1.5 million revenue improvement that was reflected in the LRFF (presented to Finance Committee on February 1st), staff has revised its revenue projections to recognize an additional General Fund revenue of $0.5 million. Table 1 summarizes major revenue and expenditure adjustments in the March 15, 2011 Page 3 of 19 (ID # 1442) General Fund (details for these changes are outlined in Attachment 1, Exhibit A) and a draw of $0.48 million from the BSR is expected at year end. The draw results from Council directed BAOs amounting to $0.93 million that are offset by staff proposed midyear contributions to the BSR of $0.45 million. The projected year-end BSR balance, therefore, is $26.9 million, or 19.3 percent of adopted budget expenditures. Description Council Action Date 000s Amount Auditied beginning BSR Balance,asof6/30/2010 $27,396 Adopted Budget - Net Surplus 33 Ord 5087 - Election costs for P alo Alto Professional Firefight ers'Initiative 07/26/10 (22) Ord 5091 - City Manager Home Loan 08/02/10 (125) Ord 5093 - Firefighters' Charter Amendment and even numbered Council Elections 09/13/10 (275) Ord 5094 - Transfer to Refuse Fund (Loan)- reversed in midyear proposal 09/20/10 (240) Ord 5106 - Airport Fund Loan 12/06/10 (300) Subtotal - Dra wdown from BSR (929) Proposedmidyear adjustments Revenue 2,111 Department Requests (1,275) Contingency Reimbursement s (194) Council Directed Expense (196) Subtotal- midyear adjustments 446 Net BSR Impact (483) Projected Year-End BSR Ba lance $26,913 BSR as a Percentage of Adopted Expenditu res 19.3% Table 1: FY 2011 Budget Stab ilizationReserve Impact Sales Tax FY 2011 sales tax revenue is estimated at $19.5 million, a $1.3 million increase above the FY 2011 Adopted Budget. $0.8 million of the increase is due to stronger sales tax performance in the 3rd calendar year quarter and indications of strong retail sales in the 4th quarter. The remaining increase results from the State’s “triple flip” underpayment in FY 2010 which will be remitted in FY 2011. Property Tax The property tax projection for FY 2011 is $25.3 million --$0.6 million below the FY 2011 adopted budget, and $0.7 million or 2.7 percent below FY 2010 receipts. This is due to the sizeable number of commercial property appeals on properties’ assessed values which the County has received. These appeals will be processed over the next 2-3 years, with a corresponding drag on City property tax revenues. Transient Occupancy Tax The FY 2011 estimate for Transient Occupancy Tax (TOT) is now $7.4 million, a $0.4 million March 15, 2011 Page 4 of 19 (ID # 1442) increase from the FY 2011 Adopted Budget amount. In FY 2010, TOT revenues ceased their prior downward trend and began to rise. Occupancy and daily rates increased from 66.2 percent and $145 per day in October 2009 to 80.5 percent and $150 per day in October 2010. These trends, along with the opening of the new Hotel Keen in May 2010, have led staff to forecast higher revenues in FY 2011. Interest Earnings Because of the Federal Open Market Committee’s (FOMC) outlook that the slow pace of the economic recovery requires maintenance of low interest rates for an extended period, projected interest income for FY 2011 must be adjusted downward by $0.3 million. The FOMC is expected to maintain the federal funds rate at historically low levels between zero and one- half percent and this will continue to negatively impact portfolio yields. Documentary Transfer Tax The Documentary Transfer Tax revenue projected for FY 2011 is $4.0 million, nearly $0.4 million above the Adopted Budget. Through the middle of this fiscal year, revenue results have been running nearly equal to those of the prior year. Staff believes, however, that property transaction activity may increase in the second half of this year and lead to slightly higher transfer taxes at year-end. Charges for Services The City is reimbursed for Fire and Communication services provided to Stanford University. Fiscal Year 2010 actual expenses came in significantly higher than what was billed to the University primarily due to Public Safety overtime costs exceeding budget. Reimbursement for this difference was billed to the university in the first quarter of Fiscal Year 2011. This results in a revenue increase of $0.41 million to the General Fund. Permits and Licenses Based on activity through mid-year, Planning and Community Environment Department revenues are expected to exceed Fiscal Year 2011 budget projections by approximately $1 million. The bulk of the revenue increase is due to fees generated at the Development Center for private development and construction activity. At the end of January, Building Division revenues were at 85 percent of budget targets due to a surge in Building Permit activity in the second quarter of FY 2011. Applications for plan checks were up 55 percent (1,161 vs. 749) from the same period last year, while the percentage of completed plan checks rose by more than 32 percent. Likewise, the number of Building Permits issued increased by 42 percent (2,132 vs. 1,501), which was reflected in a more than 62 percent increase in permit valuations ($152.6 million vs. $93.8 million). Overall, Building Division revenues totaled $3.21 million through January, up more than $1.25 million from last year, an increase of nearly 64 percent. The increased Planning & Community Environment Department revenues reflects a stabilizing and gradually improving economy bolstered by increased confidence in the local real estate market along with easing access to credit and financing. The strength of several large local employers (Facebook, VMware, Google, H-P, Apple, Tesla) likely helped fuel investments in March 15, 2011 Page 5 of 19 (ID # 1442) local residential real estate, while several smaller start-up firms located in the downtown area and completed renovations of commercial office space. Additionally, the transition to new Building Codes in January likely resulted in a number of applicants filing their Building Permit applications before the end of the calendar year so their projects could be processed under the prior codes. At midyear, the City has collected $0.62 million, or 40 percent, in parking violation revenues. The number of first and second quarter citations issued is 9 percent lower than the same quarter in the prior year due to staff vacancies (1.5 FTE) and disability or workers’ compensation leaves; the number of vehicles monitored has decreased 9 percent. Additionally, with the passage of Senate Bill 857, the State of California began taking an additional $3 per parking citation, raising the total fee assessment per parking citation by the State to $12.50. Based on historical trends and revenue recognized in the current year, year end parking violation revenue is projected to be $1.3 million, or $0.2 million short of budget. Rental Income Interdepartmental rental income is increased by $60 thousand to reflect payments from the Utilities Department to the General Fund for the use of a portion of the former Los Altos Treatment Plant site as a staging/storage area. Expense Highlights for Fiscal Year 2011 Midyear To align the budget with prior year actual expenditures and anticipated year end costs, budgets in the areas of overtime, health care, and Internal Service Fund departmental charges were increased. Below is a summary of the total General Fund Impact of these adjustments. (in millions) Public Safety Ove rtime ($0.815) Department Charges Current Employee Healthcare &Benefits (0.232) Retiree Benefits (0.118) Interest income decline (0.174) Total Impact ($1.339) General Fund Salaries and Benefits Savings and Overtime Analysis There are 579.5 full-time equivalents (FTEs) budgeted in the General Fund and, as of the beginning of January, 44.85 General Fund FTE were vacant. In combination with salary savings expected from employee retirements, net salary and benefits savings of $1.5 million is expected to be realized if the level of General Fund vacancies is maintained. Most of the General Fund departments are on track with or below their overtime budget, however the City Manager’s Office, Fire Department, and Police Department exceed their budgets for the reasons discussed below. Overtime budgets for the Police and Fire Departments are around $1 million each. These levels have not kept pace with historical March 15, 2011 Page 6 of 19 (ID # 1442) overtime activity and with contractual salary increases over the past several years. Trend and seasonal data analyzed for Fiscal Years 2007 through 2010 shows that the Police and Fire Departments will need an additional $1.6 million ($1.2 million for the Fire Department and $0.4 million for the Police Department) to align the budget with actual costs. Adopted Adjuste d Midyear Midyear % ofCategoriesBudgetBudgetBudgetChangesActualAdj Budget City Attorney - - - - - 0% City Auditor - - - - - 0% City Clerk 7 7 7 - - 0% City Council - - - - - 0% City Manager 3 3 3 - 10 333% Administrative Services 36 45 45 - 15 33% Community Services 105 105 105 - 51 49% Library 58 58 58 - 20 34% Fire 1,018 1,018 1,628 610 1,148 113% Human Resources 4 4 4 - - 0% Planning and Community Environment 67 67 67 - 32 48% Police 968 1,000 1,205 205 754 75% Public Works 113 113 113 - 94 83% Total Overtime 2,379 2,420 3,235 815 2,124 88% CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR FINANCIAL REPORT GENERAL FUND OVERTIME (in thousa nds of dollars) (a s o f 12/3 1/10) Table 2:General Fund Overtim e The City Manager’s Office exceeded its overtime budget by $7 thousand due to additional tasks related to the Emergency Preparedness program. These include: use of the Mobile Emergency Operations Center for Stanford football games and participation in Urban Shield, the largest, regional anti-terrorism exercise in the U.S., sponsored by the Bay Area Urban Security Initiative. Since the $7 thousand in overtime cost was not planned for in the City Manager’s Office, in the third quarter this amount will be transferred to the Police Department and offset with incoming grant funds. The Fire Department exceeded its adjusted budget by $0.13 million or 13 percent. In comparison with Fiscal Year 2010 midyear, the expense has been reduced by 25 percent or $0.3 thousand. At the end of December 2010, the department had zero employees on disability leave while in December 2009, the department had three employees on full disability leave, one employee on modified duty, two employees on light duty, and four employees on other disability leave. Actual overtime figures are a result of Station 8 staffing, Medic 1 staffing, and backfilling for minimum staffing requirements due to vacation, sick and other leaves, special assignments. As part of staff’s plan to align Public Safety overtime cost with contractual salary increases over the past five fiscal years, overtime budget in the Fire Department will be increased $0.6 million. The Police Department has used 75 percent of its annual overtime budget through December March 15, 2011 Page 7 of 19 (ID # 1442) 31st. The main factors contributing to overtime usage this quarter were staffing shortages due to disability leave, vacancies in patrol and the 9-1-1 dispatch center, traffic control services at Stanford football games, providing security during a Presidential visit, and participation in the Urban Shield Exercise. The Department receives partial reimbursement for overtime worked from Stanford, the Utilities Department for dispatch services, and from neighboring cities for animal control and care services. Traffic control services at Stanford football games and other events are partially offset by reimbursements from the University and other organizations. The Department also received reimbursement for it’s participation in the Urban Shield Exercise and for dispatcher training from a State grant. The Police Department’s overtime budget will be increased $0.2 million in midyear to align the department’s budget with contractual salary increases over the past five fiscal years. Department Charges Three months of savings equal $96 thousand citywide ($58 thousand for the General Fund) results from April 1st implementation of employee and future retiree medical premium contributions by miscellaneous employees (excludes sworn safety employees in Police and Fire Departments), also known as the 90/10 healthcare plan for miscellaneous employees. Although the implementation of the 90/10 healthcare plan for miscellaneous employee results in savings, a midyear budgetary increase of $0.22 million is needed in the General Fund to adjust for two assumptions that were made in the adopted budget. First, the adopted budget assumed five months of savings due to miscellaneous employee healthcare contributions. Since implementation of the 90/10 plan was deferred from February 1st to April 1st, an additional $39 thousand in benefit cost is needed in the General Fund. Second, the adopted budget assumed a 10 percent increase in medical costs for calendar year 2011. Actual medical cost increases were received subsequent to budget adoption and ranged from 12-17 percent. The budget impact of these medical cost increases that exceeded staff’s projection is $0.18 million. Projected interest earnings are used to balance department charges in the General Benefits, Workers’ Compensation Insurance Program, and General Liabilities Insurance Program Internal Service Funds. As a result of interest earning decline, these funds must increase department charges to break even at year end. Based on staff’s projections, the net expense increase to General Fund department is $0.2 million. Contingency Accounts The City Council, City Manager, and City Attorney Offices have contingency accounts. The changes and balances in those accounts are discussed below. City Council Contingency At midyear, the City Council contingency account is replenished $35 thousand for expenses related to the continued publication of Council and Standing Committee agenda ads in the newspaper. Council passed a motion in September 27, 2010 to reimburse the contingency account for this expense. The summary of changes to the Council contingency account is shown March 15, 2011 Page 8 of 19 (ID # 1442) below: Date Description Amount 7/1/10 City Council Contingency Beginning Balance $250,000 7/7/10 Balance Carried forward from FY 2010. Motion was approved in June 2010 $55,000 7/7/10 Transfer to the City Manager Office to cover staffing cost of HSR. Motion was approved in June 7, 2010. ($90,000) 8/2/10 Transfer to the PCE Department for Contract Services for on-call engineering services related to HSR. (CMR:310:10) ($120,000) 10/4/10 Transfer to the City Manager Office to reimburse contract services for legislative advocacy service for Capitol Advocates (CMR:357:10) ($15,000) 9/27/10 Transfer to the City Clerk Office to pay for continued publication of City Council and Standing Committees agenda in the newspaper to be reimbursed in midyear. Motion was approved in September 27, 2010. ($35,000) 10/4/10 Transfer to the PCE Department for contract services for additional months (until February 28, 2011) for Capitol Advocates (CMR:357:10) ($38,500) Midyear reimbursement $35,000 Balance after midyear reimbursement $41,500 City Manager Contingency The City Manager contingency account had a beginning balance of $0.25 million in FY 2011. Due to Council’s heavy agenda and rather than delaying the implementation of programs pending a BAO, staff used the City Manager’s contingency to expedite the implementation of certain programs. The proposed midyear changes replenish the City Manager’s contingency by $125,000 for these programs. After the contingency is replenished at midyear, the City Manager contingency account balance is $157,896. a. $80 thousand for the Urban Forest Master Plan through a transfer from the Community Services, Planning and Environment, Public Works and the Utilities Departments. Each department is contributing $20,000 to replenish the City Manager’s Contingency and results in no BSR impact. b. $45 thousand for the development of the City’s ethics development program replenishment from the BSR. City Attorney Contingency The City Attorney contingency account had a balance of $125,000 at the beginning of the fiscal year. The City Attorney determined that the contingency account is not needed for fiscal year 2011; therefore the whole amount is being returned to the BSR. This is a one-time adjustment March 15, 2011 Page 9 of 19 (ID # 1442) to the City Attorney’s budget. Department Budget Adjustments The following are recommended midyear changes to department budgets: City Manager The City Manager’s Office is requesting additional funds for temporary staffing costs associated with the coordination of important projects. The department requests $60 thousand in temporary salary budget at midyear, of which $31 thousand is related to additional work in support of high speed rail (HSR) activities and $29 thousand related support to Emergency Preparedness and the Infrastructure Blue Ribbon Commission. HSR activities include: preparing HSR Committee agendas and materials; working with the City’s legislative advocates on State HSR issues; managing contracts with professional consultants providing technical advice to the City; attending community meetings; writing City Council reports; making presentations to keep community informed about HSR; acting as a liaison to community groups and neighborhood associations; and assisting as needed with the rail corridor study and possible work on Caltrain matters.Staff will propose funds in the 2012 budget that match anticipated work load given changes in the HSR program. The City Manager’s Office has absorbed additional workload related to Council’s Emergency Preparedness priority. These activities include: improving the emergency operations plan and training; implementing the Foothills Fire Management Plan recommendations; conducting major community based exercises; and strengthening the Citizen Corps Council (CCC) role. Planning and Community Environment Planning & Community Environment is requesting an additional $0.3 million at mid-year to cover additional expenses related to: 1) processing an increased number of Planning entitlement and Building Permit applications; and 2) activities in connection with the Development Center restructuring (Blueprint) effort. These requests include: 1. $15 thousand for contract Planners to work on entitlement applications and backfill for regular Planning staff who are assigned to work on the DC Blueprint effort 2. $92 thousand for a limited hourly Management Specialist to serve as Project Manager for the DC Blueprint restructuring effort 3. $22 thousand for a limited hourly Administrative Specialist to support data compilation and development and implementation of new activities, services, and collateral material associated with the Green Building program 4. $50 thousand for contract Plan Check staff to work on Building Permit applications that warrant being reviewed in-house and to backfill for regular staff who are assigned to work on the DC Blueprint effort March 15, 2011 Page 10 of 19 (ID # 1442) 5. $50 thousand for a second contract Plan Checker to work on high priority cost recovery projects that require rapid turn-around and inter-departmental coordination. This position also will support piloting and implementation of recommendations associated with the DC Blueprint effort 6. $12 thousand for acquisition of code books and related materials for staff in connection with the adoption of new Building Codes 7. $8 thousand for miscellaneous supplies and materials needed to support the added hourly and contract staff working at the Development Center and piloting and implementation activities associated with the DC Blueprint effort 8. $42 thousand to cover the increase of bank fees due to the increase in the volume of business activities and credit card payments received at the Development Center Community Services Department (CSD) Expected reimbursement of $48 thousand from the Family Resources Foundation (Foundation) is removed as a revenue source in the CSD budget. The Foundation was to provide the funding for the Program Coordinator (0.5 FTE) that oversees the Family Resources Program. The Foundation has found it extremely challenging to raise funds to fully reimburse the City for the Program Coordinator. Staff is examining options to fund the Program Coordinator position and will be presenting the results of this analysis during the FY 2012 budget process. Vehicle Fund Charges In the General Fund, vehicle replacement funding for the City’s fleet/equipment purchases was reduced by $0.48 million in the FY 2011 Adopted Budget. A review of the City’s fleet is currently in progress to determine the extent to which this reduction will be realized in FY 2011. Printing and Mailing Fund As part of the FY 2011 budget process, staffing levels for printing and mailing services was reduced from 4.5 to 2.5 FTE to address the continued decline in program revenues and increased employee benefit costs. As of February 2011, the fund had a cash shortfall of $0.1 million. Additional costs will have to be allocated to departments by year end in order to bring this into balance. Temporary Salary Usage The Police Department has used temporary salaries to fill vacant, authorized regular positions to implement minimum staffing requirements, legal mandates, or revenue producing activities. The vacant positions include a Code Enforcement Officer, Property and Evidence Tech staff (2.0 FTE), a Police Records Specialist, and Public Safety Dispatchers (4.0 FTE). It is estimated that the department will save $0.17 million in overtime costs through use of temporary Public Safety Dispatch staff in the 9-1-1 Dispatch Center. March 15, 2011 Page 11 of 19 (ID # 1442) The Fire Department has required the use of temporary salaries to fill vacant authorized regular positions due to minimum staffing requirements, legal mandates, revenue producing and workload demands. The vacant positions backfilled with hourly employees include Deputy Chief of Support Services, OES Coordinator, Fire Inspector, and Plan Checker (4.0 FTE). Use of temporary salary is also required to partially replace an eliminated Hazardous Materials Specialist (1.0 FTE) position in order to maintain revenue production and alleviate workload demands. It is estimated that the Department will realize $61 thousand in overtime savings by using hourly employees. Enterprise Funds Discussed below are adjustments to the City’s Enterprise Funds. The Fiscal Year 2011 Midyear Budget Summaries (Attachment 1, Exhibit A) provides a financial report of the Enterprise Funds as of midyear. Electric Fund (Net reserve reduction of $0.334 million) -The Calaveras Reserve within the Electric Fund is reduced by $49 thousand to fund 25% of a feasibility study for a facility that would recover energy from methane from dry anaerobic digestion (approved by Council on August 2, 2010, CMR 333:10). A transfer of $0.117 million to the Electric Fund from the Capital Projects Fund is made to return funds for CIP PE-08005 MSC Resurfacing Project which is now complete. In addition, $0.135 million will be added to the Electric Fund, to cover expenditures for the Electric Vehicle Charging Infrastructure CIP (EL-11016). The purpose of this project is to pilot electric charging stations and to provide a charging location for electric vehicles that may use the Civic Center and businesses in Downtown Palo Alto. A grant of $35 thousand for this project has been received from the Bay Area Air Quality Management District. The Electric Fund Distribution Rate Stabilization Reserve will contribute $0.1 million. The Public Benefits Program Reserve within the Electric Fund is reduced by a transfer of $0.110 million to the Capital Projects Fund for CIP PE-09006 Mitchell Park Library for energy efficiency rebates. Fiber Optics Fund (Net reserve reduction of $11 thousand) -The Fiber Optics Fund reserve is increased by $1 thousand for the return of unused funds from closed CIP projects (EL-06005 Fiber Optic Network System Improvements and EL-06006 Fiber Optic Customer Connections). Gas Fund (Net reserve addition of $96 thousand) -The Gas Fund reserve is increased by $39 thousand for the return of unused funds from closed CIP projects (GS-03010 CNG Seq. Fuel System and GS-00011 Compressed Natural Gas). A transfer of $35 thousand to the Gas Fund from the Capital Projects Fund is made to return funds for CIP PE-08005 MSC Resurfacing Project which is now complete. March 15, 2011 Page 12 of 19 (ID # 1442) Also in the Gas Fund, interdepartmental communications expense is reduced by $47 thousand as a result of Utilities alarm monitoring being transitioned from the Police Department to an outside vendor. Water Fund (Net reserve addition of $23 thousand) -Interdepartmental communications expense is reduced by $19 thousand as a result of Utilities alarm monitoring being transitioned from the Police Department to an outside vendor. A transfer of $57 thousand to the Water Fund from the Capital Projects Fund is made to return funds for CIP PE-08005 MSC Resurfacing Project which is now complete. Wastewater Collection Fund (Net reserve addition of $58 thousand) -Interdepartmental communications expense is reduced by $18 thousand as a result of Utilities alarm monitoring being transitioned from the Police Department to an outside vendor. A transfer of $75 thousand to the Wastewater Collection Fund from the Capital Projects Fund is made to return funds for CIP PE-08005 MSC Resurfacing Project which is now complete. Refuse Fund (Net reserve reduction of $0.111 million) -A transfer of $0.24 million from General Fund is reversed. This transfer was originally approved by Council on September 20, 2010 (CMR 356:10) to ensure that the cash position of the Refuse would meet State landfill requirements. It has been determined that the cash balance is sufficient enough and that the transfer is no longer needed. A transfer of $0.139 million to the Refuse Fund from the Capital Projects Fund is made to return funds for CIP PE-08005 MSC Resurfacing Project which is now complete. For the eight months ended February 28, 2011, the Refuse Fund has a positive net income of $576 thousand. The Refuse Fund also has a positive cash balance of $8 million, which satisfies the state requirement of $6 million for post closure costs. Furthermore, given the positive position in the fund, staff is not recommending an increase to the current available loan from the General Fund to the Refuse Fund at this time. Staff is closely watching the Refuse Fund for indications that it may not finish the fiscal year in a positive position. Certain revenues vary from budget. Chief among these is commercial retail revenue, which is projected to be lower than budget by $1.9 million. With other revenues up and certain expenses down the drop in commercial retail revenue could be absorbed. Staff is still evaluating the causes for the drop in commercial retail revenue and will return to the Finance Committee soon with more details as well as a projection for fiscal year end. Storm Drainage Fund (Net reserve reduction of $0.163 million) -Funds totaling $0.151 million are added to various CIP projects (see Attachment 1, Exhibit B) for salaries and benefits not previously included. March 15, 2011 Page 13 of 19 (ID # 1442) Wastewater Treatment Fund (Net reserve addition of $10.5 million) -The Wastewater Treatment Fund reserve is increased by $0.62 million for the return of unused funds from a closed CIP project (WQ-04010 Replace Existing Reclaimed Water Pipeline). Also, CIP WQ-06014 Disinfection Facility Improvement Program is reduced by $10 million due to savings realized from lower bids. The RSR now negative $2.9 million. Capital Improvement Program Adjustments to the City’s 2011 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: 1) projects requiring additional appropriations: 2) projects having reductions in appropriations; and 3) projects with other adjustments such as transfer of funding between projects, closing completed projects or creating new projects. Highlights of CIP changes are as follows: General Fund · Street Maintenance -CIP PE-86070 -Increase funding by $0.164 million 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). · Mitchell Park Library -PE-09006 -Increase funding by $0.11 million and increase project cost by the same amount. The appropriation is increased due to revenues received from the Utilities Department regarding energy efficiency rebates. Another adjustment to this project in midyear is reducing the funding by $1,347,309 in order to adjust the budget to the new, lower cost estimates by the engineers. This project is funded by the Measure N Library Bond. · Main Library New Construction and Improvements -PE-11000 -Increase funding by $0.45 million to accelerate the design phase of the project to take advantage of the low construction bid environment. The design phase was planned for FY 2012 and is now moved to FY 2011. This project is funded by the Measure N Library Bond. · Temporary Facility for Main Library -PE-11012 -This is a new project with initial funding of $0.5 million. This project will renovate the Art Center auditorium to function as a temporary library during the construction of the adjacent Main Library. This project is to be funded by Measure N Library Bond. (Attachment 1, Exhibit B-1) · Downtown Library Improvements -PE-09005 -Increase funding by $1.3 million to adjust the preliminary estimate by the engineers. This project is funded by Measure N Library Bond. · California Avenue-Transit Hub Corridor Project -PL-11002 -This is a new project with initial funding of $0.55 million. This project funds the design and construction of streetscape enhancements along California Avenue between El Camino Real and the Caltrain -Park Blvd Plaza. A $1.18 million, grant was received in FY 2011 from the VTA - March 15, 2011 Page 14 of 19 (ID # 1442) Community Design & Transportation (CDT) program that requires a $0.55 million local match. (Infrastructure Reserve funding of $0.55 million is required). (Attachment 1, Exhibit B-2) · Palo Alto-Traffic Signal Central System Upgrade -CIP PL-11003 -This is a new project with initial funding of $0.4 million. This project funds the replacement of the City’s existing traffic signal central system and up to 35 traffic signal field controllers with associated communications gear. The new central system will improve field monitoring and better coordination between intersections. A $0.4 million federal earmark grant was received by the City to fund this project. (see Attachment 1, Exhibit B-3) · Alma Street -Traffic Signal Improvements -CIP PL-11004 -This is a new project with initial funding of $0.7 million. This project funds traffic signal modifications at the intersections of Alma St & Churchill Rd and Alma St & East Meadow Dr. The City will receive a Federal Section 130 grant for this project. (No reserve funding required). (see Attachment 1, Exhibit B-4) · Civic Center Infrastructure Improvements -PF-01002 -Reduce funding by $1.5 million due to savings realized from lower construction bids. This amount is returned to the Infrastructure Reserve. · JMZ New Bobcat Habitat -AC-10000 -Reduce funding of $0.45 million and close project. The Friends of the Junior Museum and Zoo paid for the cost of this project directly to the contractor; hence, the appropriation set aside for this project was not utilized. The funds from closure of this project will be returned to the Infrastructure Reserve. · Various Projects (See attached Exhibit B excluding projects identified in the preceding sections)-A total balance of $0.225 million 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 · Electric Vehicle Charging Infrastructure-CIP EL-11016 -This is a new project with initial funding of $0.135 million. This project will install five new generation electric vehicle charging stations at City Hall level A, Hamilton Ave in front of City Hall, and Bryant Street parking garage. Total grants of $35 thousand were received from the California Energy Commission (CEC) and the Bay Area Air Quality Management District (BAAQMD). The Electric Fund will provide the remaining needed amount of $0.1 million (Electric Fund Distribution RSR: $0.1 million reserve funding.) (Attachment 1, Exhibit B-5) · Replace Existing Reclaimed Water Pipes -WQ-04010 -Reduce funding by $0.824 million and close project. This amount will be returned to the Wastewater Treatment Fund March 15, 2011 Page 15 of 19 (ID # 1442) reserve balance. (No reserve funding required.) · Disinfection Facility Improvement Program -CIP WQ-08014 -Reduce funding by $10 million due to savings realized from lower construction bids received. (No reserve funding required.) Table of Organization Changes The proposed adjustments to the Table of Organization (Exhibit C) include the following: a. Planning and Community Environment: Title change from Arborist to Planning Arborist to more properly reflect the job title with duties performed. b. Police Department: Transfer 0.5 FTE Community Service Officer from the General Fund to the College Terrace Parking Program Special Revenue Fund to monitor parking in the College Terrace District. c. Utilities Department: Drop 1.0 FTE Utilities Installer Repairer and add 1.0 FTE Coordinator Utility Projects to handle regulatory reporting, tracking, and other work necessary to comply with State requirements related to the wastewater collection system. 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, 2010. The following graph summarizes all General Fund projects by project category and provides five years of actual expenditures. Information about individual projects within each project category is provided in Attachment 2. March 15, 2011 Page 16 of 19 (ID # 1442) General Fund Capital Improvement Program Expenditures Summarized by Project Category -Fiscal Years 2007-2011 (in thousands) $5,924 $30 $612 $1,387 $2,107 $7,926 $5,797 $2,654 $453 $2,977 $3,630 $5,859 $10,082 $2,503 $110 $440 $1,733 $6,227 $9,312 $2,353 $291 $7 $3,460 $5,855$7,179 $41 $0 $746 $1,143 $3,560 $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 FY2007 $5,924 $30 $612 $1,387 $2,107 $7,926 FY2008 $5,797 $2,654 $453 $2,977 $3,630 $5,859 FY2009 $10,082 $2,503 $110 $440 $1,733 $6,227 FY2010 $9,312 $2,353 $291 $7 $3,460 $5,855 FY2011 $7,179 $41 $0 $746 $1,143 $3,560 Totals $38,294 $7,581 $1,466 $5,557 $12,073 $29,427 Buildings & Facilities Land & Land Improvements Miscellaneous Non-Infrastructure Management Plan Parks & Open Space Streets & Sidewalks 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 2010, 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 of the project as of December 31, 2010, and illustrates how much progress was made. Three distinct phases are utilized, as follows: Phase Activities Pre-Design Preparation of a feasibility study Development of a master plan Definition of a project scope Preparation of an Environmental Impact Report Design Hiring a design consultant Completion of project design Soliciting bids or proposals Construction Acquisition of major equipment Installation Implementation of a project March 15, 2011 Page 17 of 19 (ID # 1442) 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 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, 2010 (Attachment 4). General Fund Infrastructure Backlog Update In April 2008, staff provided Council with an initial update of the General Fund infrastructure backlog for the next twenty years (CMR: 167:08). The infrastructure backlog report was subsequently updated in May, 2009 as part of the CIP budget process. In May 2010, staff added the Public Safety Building with an estimated cost of $60 million to the backlog list. The updated report is incorporated in the FY 2011 Adopted Capital Budget document (pages 297-298). The updated report indicated that $302 million (in 2009 dollars) is needed to address infrastructure repairs and renovations in the areas of streets, sidewalks, bridges, parks and open space, City buildings and facilities. Another $208 million (in 2009 dollars), which includes $60 million for the Public Safety Building, is needed to address future infrastructure needs at major City facilities such as building replacements at the Municipal Service Center (MSC), Fire Stations 3 and 4, the Animal Shelter, replacement of the Civic Center plaza deck, and completion of the Charleston Arastradero Corridor and Byxbee Park Phase II projects. Estimated infrastructure costs cited above total $510 million (in 2009 dollars). Of the $510 million, $70 million (Measure N Library Bond not included) has been identified in the City’s FY 2011-2015 Capital Improvement Plan. Funds for the first year of the Plan, FY 2011, have been appropriated by the Council, while funds for the remaining years are approved in concept and will be reviewed each year as part of the CIP budget process. To address the infrastructure backlog, the City Council created a new Infrastructure Blue Ribbon Commission (IBRC). This Commission is tasked by Council to identify and prioritize the City’s infrastructure needs and to determine funding sources and financing mechanisms to address the City’s backlog or new needs.Financing mechanisms could include public/private partnerships, new revenue sources, and various bond structures. At present, there is a significant funding gap between available General Fund resources and those needed to address the $510 million determined thus far. Staff met with the IBRC on November 18, 2010 to begin its work. Since then staff meet with IBRC twice each month. IBRC has a substantial challenge ahead and will likely be reaching out to the City’s Boards and Commissions and the community March 15, 2011 Page 18 of 19 (ID # 1442) in developing its final report or recommendation to Council. Resource Impact Adoption of the attached ordinance will allow for adjustments to the Fiscal Year 2011 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 $26.9 million. There is a increase of $0.45 million to the BSR balance which results in a BSR level of 19.3 percent of adopted expenditures. Staff has made revenue and expense estimates for the remainder of the year but results could vary and have further impacts to the BSR. Workers’ comp, general liability, and overtime costs are areas of continued concern; staff is continually monitoring these costs citywide and in the General Fund. The Capital Fund Infrastructure Reserve is projected to end with a balance of $3.8 million, an increase of $2.0 million. The projected ending Rate Stabilization Reserve total for all Enterprise funds increases by $10.0 million. 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 -Amendment Ordinance (PDF) ·Attachment 1, Exhibit A -Midyear Finanacial Reports and Proposed Budget Adjustments (PDF) ·Attachment 1, Exhibit B -Midyear CIP Adjustments (PDF) ·Attachment 1, Exhibit B1 -Temporary Main Library (PE-11012)(PDF) ·Attachment 1, Exhibit B2 -California Avenue (PL -11002)(PDF) ·Attachment 1, Exhibit B3 -Palo Alto -Traffic Signal Central System Upgrade (PL-11003) (PDF) ·Attachment 1, Exhibit B4 Alma Street -Traffic Signal Improvements (PL-11004)(PDF) ·Attachment 1, Exhibit B5 -Electric Vehicle Charging Infrastructure (EL-11016)(PDF) ·Attachment 1, Exhibit C -Amendments to Table of Organization (PDF) ·Attachment 2 -General Fund Capital Improvement Program Project Expenditures For Fiscal Years 2007-2011 (PDF) ·Attachment 3 -FY 2011 Mid-Year Capital Improvement Program Projects Status (PDF) ·Attachment 4 -Continuous Capital Projects Expenditures for Fiscal Years 2007-2011 (PDF) March 15, 2011 Page 19 of 19 (ID # 1442) ·Attachment 5 -General Fund Transfers To Infrastructure Reserve For Fiscal Years 2007-2016 (PDF) ·Attachment 6 -Resolution of the Council of the City of Palo Alto Amending the FY 2010- 2011 Compensation Plan for Classified Personnel (SEIU) Adopted by Resolution No. 9088 (PDF) ·Attachment 6, Exhibit A -Midyear SEIU Compensation Plan Changes -effective April 1, 2011 (PDF) ·Attachment 7 -Police and Fire Overtime Analysis for Fiscal Years 2009 through 2010 with Fiscal Year 2011 Data Through January 12, 2011(PDF) Prepared By:Christine Paras, Senior Financial Analyst Department Head:Lalo Perez, Director City Manager Approval: James Keene, City Manager Page 1 of 3 Attachment 1 ORDINANCE NO. _____ ORDINANCE OF THE COUNCIL OF THE CITY OF PALO ALTO AMENDING THE BUDGET FOR THE FISCAL YEAR 2011 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 28, 2010 did adopt a budget for fiscal year 2011, including a Table of Organization describing the staffing for each department; and B. After reviewing the current budgeted revenues and expenditures for fiscal year 2011, 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 reclassification of 1.0 Full Time Equivalent (FTE) Utilities Installer Repairer to Coordinator, Utility Projects in the Utilities Department; the addition of 0.5 FTE Senior Financial Analyst and drop of 1.0 FTE Manager, Energy Risk in the Utilities Department; the addition of 0.1 FTE Senior Financial Analyst in the Administrative Services Department; and the addition of 0.125 FTE Senior Financial Analyst in the Administrative Services Department. D. City Council authorization is needed to amend the fiscal year 2011 budget as hereinafter set forth. SECTION 2. The General Fund Budget Stabilization Reserve is hereby increased by the sum of Four Hundred Forty Five Thousand Six Hundred Eighty Six Dollars ($445,686), as described in Exhibit “A.” As a result of this change, the Budget Stabilization Reserve will increase to $26,913,000. SECTION 3. The Capital Fund Infrastructure Reserve is hereby increased by the sum of One Million Nine Hundred Thousand Sixty Two Three Hundred Seventy Three Dollars ($1,962,373), as described in Exhibit “A.” As a result of this change, the Infrastructure Reserve will increase from $1,845,909 to $3,808,282. SECTION 4. The Supply Rate Stabilization Reserve in the Electric Fund is hereby decreased by the sum of Forty-Two Page 2 of 3 Thousand Eight Hundred Thirty Dollars ($42,830) as described in Exhibit A. SECTION 5. The Distribution Rate Stabilization Reserve in the Electric Fund is hereby decreased by the sum of One Hundred Ninety-Two Thousand Two Hundred Seventy-Two Dollars ($192,272) as described in Exhibit A. SECTION 6. The Public Benefits Reserve in the Electric Fund is hereby decreased by the sum of One Hundred Nine Thousand Seven Hundred Fifty-Two Dollars ($109,752) as described in Exhibit A. SECTION 7. The Calaveras Reserve in the Electric Fund is hereby decreased by the sum of Forty-Nine Thousand Four Hundred Forty Dollars ($49,440) as described in Exhibit A. SECTION 8. The Rate Stabilization Reserve in the Fiber Optics Fund is hereby decreased by the sum of Thirteen Thousand Four Hundred Fifty-Eight Dollars ($13,458) as described in Exhibit A. SECTION 9. The Supply Rate Stabilization Reserve in the Gas Fund is hereby increased by the sum of Sixteen Thousand Three Hundred Ninety-One Dollars ($16,391) as described in Exhibit A. SECTION 10. The Distribution Rate Stabilization Reserve in the Gas Fund is hereby increased by the sum of Forty-Four Thousand Five Hundred Seventy-Seven Dollars ($44,577) as described in Exhibit A. SECTION 11. The Rate Stabilization Reserve in the Water Fund is hereby increased by the sum of Three Thousand Forty-Four Dollars ($3,044) as described in Exhibit A. SECTION 12. The Rate Stabilization Reserve in the Wastewater Collection Fund is hereby increased by the sum of Forty-Five Thousand Seven Hundred Dollars ($45,700) as described in Exhibit A. SECTION 13. The Rate Stabilization Reserve in the Refuse Fund is hereby decreased by the sum of One Hundred Eleven Thousand Three Hundred Eight-Four Dollars ($111,384) as described in Exhibit A. SECTION 14. The Rate Stabilization Reserve in the Storm Drainage Fund is hereby decreased by the sum of One Hundred Sixty-Three Thousand Two Hundred Five Dollars ($163,205) as described in Exhibit A. SECTION 15. The Rate Stabilization Reserve in the Wastewater Treatment Fund is hereby increased by the sum of Ten Million Five Hundred Thirty-Nine Thousand Seven Hundred Six Dollars ($10,539,706) as described in Exhibit A. Page 3 of 3 SECTION 16. 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 17. 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. SECTION 18. 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 19. 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 20. 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 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre % of Categories Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Revenues & Other Sources Sales Tax 18,218 18,218 19,507 1,289 - - 10,056 52% Property Tax 25,907 25,907 25,323 (584) - - 13,566 54% Transient Occupancy Tax 7,021 7,021 7,400 379 - - 3,361 45% Utility Users Tax 11,429 11,429 10,824 (605) - - 5,420 50% Other Taxes and Fines 5,943 5,943 6,139 196 - - 2,402 39% Charges for Services 20,008 20,008 20,924 916 - - 10,960 52% Permits & Licenses 4,593 4,593 5,102 509 - - 2,207 43% Return on Investment 1,646 1,646 1,337 (309) - - 599 45% Rental Income 13,716 13,716 13,776 60 - - 6,996 51% From Other Agencies 155 155 221 66 - - 120 54% Charges To Other Funds 10,622 10,622 10,681 59 - - 5,458 51% Other Revenues 1,490 1,490 1,584 94 - - 715 45% Total Revenues 120,748 120,748 122,818 2,070 - - 61,860 50% Operating Transfers-In 18,684 18,684 18,677 (7) - - 9,301 50% Encumbrances and Reappropriation 3,963 3,963 - - - From Infrastructure Reserve - - Total Sources of Funds 139,432 143,395 145,458 2,063 - - 71,161 50% Expenditures & Other Uses City Attorney 2,369 3,002 3,024 22 50 494 1,120 55% City Auditor 982 1,081 1,089 8 - 102 519 57% City Clerk 1,093 1,446 1,355 (91) - 21 569 44% City Council 142 173 174 1 - 19 81 57% City Manager 2,178 2,370 2,451 81 6 55 1,107 48% Administrative Services 6,293 6,593 6,643 50 59 126 2,888 46% Community Services 20,032 20,371 20,486 115 206 2,314 9,789 60% Fire 27,007 27,454 28,259 805 71 433 13,513 50% Human Resources 2,817 2,888 2,919 31 21 120 1,301 49% Library 6,609 6,845 6,910 65 - 380 3,172 51% Planning and Community Environment 9,320 10,361 10,689 328 68 1,103 4,601 54% Police 30,579 30,810 31,174 364 48 568 15,098 50% Public Works 13,084 13,956 13,999 43 47 1,088 5,957 51% Non-Departmental 5,970 5,510 5,545 35 - - 3,560 64% Total Expenditures 128,475 132,860 134,717 1,857 576 6,823 63,275 52% Operating Transfers-Out 10,924 11,464 11,224 (240) - - 5,861 52% Total Uses of Funds 139,399 144,324 145,941 1,617 576 6,823 69,136 52% Net Surplus (Deficit) 33 (929) (483) 446 Adjust intra-fund reserve transfer - - - - Transfer to Public Safety Building Reserve - - - - Year end savings from hiring freeze - - Net To (From) Reserves 33 (929) (483) 446 Beginning Reserves 27,396 27,396 27,396 - Projected Ending Reserves 27,429 26,467 26,913 446 BSR % of Total Use of Funds 19.7% 19.0% 19.3% - BUDGET (as of 12-31-10) CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR FINANCIAL REPORT GENERAL FUND (in thousands of dollars) Page 1 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 112,561 112,561 112,561 - - - 59,790 53% Interest Income 4,299 4,299 4,299 - - - 2,095 49% Other Income 11,719 11,719 11,871 152 - - 3,079 26% Reapprop/Encumbrances - 13,393 13,393 - - - 0% Total Sources 128,579 141,972 142,124 152 - - 64,964 50%** Uses of Funds Utility Purchases 74,078 74,130 74,130 - - 395 32,361 44% Salaries & Benefits 10,453 10,486 10,658 172 - - 4,948 46% Contract Services 4,283 7,321 7,350 29 33 2,210 1,077 45% Supplies and Materials 815 835 835 - 11 41 322 45% Facility and Equipment Purchases 84 84 84 - - - 3 3% General Expenses 3,174 4,163 4,163 - 60 439 677 28% Rent and Leases 3,755 3,801 3,846 45 - - 1,829 48% Allocated Charges 7,877 7,877 7,912 35 - - 2,741 35% Debt Service 8,949 8,949 8,949 - - - 3,710 41% Subtotal 113,468 117,646 117,927 281 104 3,085 47,669 43% Equity Transfer 11,195 11,195 11,195 - - - 5,598 50% Operating Transfers Out 866 866 996 130 - - 433 43% Capital Improvement Program 10,085 19,283 19,418 135 674 1,415 4,552 34% Total Uses 135,614 148,990 149,536 546 778 4,500 58,251 42% Net To (From) Reserves (7,035) (7,018) (7,412) (394) Beginning Reserves 108,923 119,991 119,991 - Projected Ending Reserves 101,888 112,973 112,579 (394) ** Excludes encumbrances and reappropriation BUDGET (in thousands of dollars) CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY ELECTRIC FUND (as of 12-31-10) Page 2 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 3,044 2,734 2,734 - - - 1,403 51% Interest Income 268 256 256 - - - 166 65% Other Income - - Reapprop/Encumbrances 920 920 - Total Sources 3,312 3,910 3,910 - - - 1,569 52%** Uses of Funds Salaries & Benefits 971 971 983 12 - - 460 47% Contract Services 165 165 165 - - 131 79 128% Supplies and Materials 18 18 18 - - - - 0% General Expenses 19 19 19 - - - - 0% Rent and Leases 15 16 16 - - - 7 45% Allocated Charges 568 567 570 3 - - 244 43% Subtotal 1,756 1,756 1,771 15 - 131 790 52% Operating Transfers Out 8 8 8 - - - 4 52% Capital Improvement Program 400 1,127 1,126 (1) - - 421 37% Total Uses 2,164 2,891 2,905 14 - 131 1,215 46% Net To (From) Reserves 1,148 1,019 1,005 (14) Beginning Reserves 8,831 9,270 9,270 - Projected Ending Reserves 9,979 10,289 10,275 (14) ** Excludes encumbrances and reappropriation CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY FIBER OPTICS FUND (as of 12-31-10)BUDGET (in thousands of dollars) Page 3 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 43,993 43,993 43,993 - - - 16,949 39% Interest Income 847 847 847 - - - 478 56% Other Income 811 811 846 35 - - 311 37% Reapprop/Encumbrances 10,039 10,039 - - - - - Total Sources 45,651 55,690 55,725 35 - - 17,738 39%** Uses of Funds Utility Purchases 24,595 24,619 24,619 - - 12,398 6,545 77% Salaries & Benefits 4,638 4,638 4,672 34 - - 2,128 46% Contract Services 1,021 1,510 1,510 - 19 697 214 62% Supplies and Materials 521 514 514 - 5 181 112 58% Facility and Equipment Purchases 63 63 63 - - - 4 6% General Expenses 658 826 826 - - 274 179 55% Rent and Leases 326 333 340 7 - 26 150 52% Allocated Charges 3,977 3,977 3,949 (28) - - 1,490 38% Debt Service 947 947 947 - - - 244 26% Subtotal 36,746 37,427 37,440 13 24 13,577 11,065 66% Equity Transfer 5,304 5,304 5,304 - - - 2,652 50% Operating Transfers Out 614 614 614 - - - 424 69% Capital Improvement Program 8,325 17,680 17,641 (39) 53 52 1,584 10% Total Uses 50,989 61,025 60,999 (26) 77 13,630 15,726 48% Net To (From) Reserves (5,338) (5,335) (5,274) 61 Beginning Reserves 15,925 20,571 20,571 - Projected Ending Reserves 10,587 15,236 15,297 61 CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY GAS FUND (in thousands of dollars) (as of 12-31-10)BUDGET ** Excludes encumbrances and reappropriation Page 4 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 28,803 28,803 28,803 - - - 15,768 55% Interest Income 1,050 1,050 1,050 - - - 633 60% Other Income 1,463 1,463 1,520 57 - - 1,207 79% Reapprop/Encumbrances 10,637 10,637 - - Total Sources 31,316 41,953 42,010 57 - - 17,608 56%** Uses of Funds Utility Purchases 12,043 12,043 12,043 - - 5,506 5,121 88% Salaries & Benefits 5,206 5,206 5,254 48 - - 2,379 46% Contract Services 754 1,009 1,009 - 79 355 175 60% Supplies and Materials 491 503 503 - 35 247 244 104% Facility and Equipment Purchases 6 6 6 - - 3 2 83% General Expense 359 381 381 - - - 165 43% Rents and Leases 2,207 2,215 2,223 8 - - 1,095 49% Allocated Charges 3,365 3,365 3,363 (2) - - 1,291 38% Debt Service 2,981 2,981 2,981 - - - 1,071 36% Subtotal 27,412 27,709 27,763 54 114 6,111 11,542 64% Equity Transfer - - - - - - - - Operating Transfers Out 441 441 441 - - - 321 73% Capital Improvement Program 8,848 47,913 47,913 - 54 5,001 4,373 20% Total Uses 36,701 76,063 76,117 54 168 11,112 16,236 36% Net To (From) Reserves (5,385) (34,110) (34,107) 3 Beginning Reserves 21,845 49,247 49,247 - Projected Ending Reserves 16,460 15,137 15,140 3 ** Excludes encumbrances and reappropriation CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY WATER FUND (in thousands of dollars) BUDGET (as of 12-31-10) Page 5 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 14,477 14,477 14,477 - - - 7,303 50% Interest Income 445 445 445 - - - 260 58% Other Income 1,002 1,002 1,076 74 - - 848 79% Reapprop/Encumbrances 8,789 8,789 - - - - Total Sources 15,924 24,713 24,787 74 - - 8,411 53%** Uses of Funds Utility Purchases 7,499 7,499 7,499 - - - 3,750 50% Salaries & Benefits 1,901 1,901 1,938 37 - - 879 45% Contract Services 208 252 252 - 25 12 51 35% Supplies and Materials 231 237 237 - 9 170 82 110% Facility and Equipment Purchases 1 1 1 - - - - 0% General Expenses 65 65 65 - - 1 22 36% Rent and Leases 210 210 210 - - - 76 36% Allocated Charges 1,970 1,970 1,962 (8) - - 647 33% Debt Service 129 129 129 - - - 32 25% Subtotal 12,214 12,264 12,293 29 34 183 5,538 47% Operating Transfers Out 567 567 567 - - - 300 53% Capital Improvement Program 4,130 12,831 12,831 - 56 2,202 1,295 28% Total Uses 16,911 25,662 25,691 29 90 2,385 7,134 37% Net To (From) Reserves (987) (949) (904) 45 Beginning Reserves 6,554 7,772 7,772 - Projected Ending Reserves 5,567 6,823 6,868 45 (as of 12-31-10) ** Excludes encumbrances and reappropriation BUDGET CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY WASTEWATER COLLECTION FUND (in thousands of dollars) Page 6 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 26,137 28,368 28,368 - - - 12,941 46% Interest Income 301 301 301 - - - 53 18% Other Income 3,458 5,129 5,027 (102) - - 2,831 56% Reapprop/Encumbrances 2,837 2,837 - Total Sources 29,896 36,635 36,533 (102) - - 15,825 47%** Uses of Funds GreenWaste Hauling Contract 14,797 13,205 13,205 - - 6 4,933 37% Salaries and Benefits 4,376 4,254 4,281 27 - - 1,955 46% Contract Services 6,547 6,608 6,608 - 13 1,174 2,740 59% Supplies and Materials 311 236 236 - - 13 50 27% Facility and Equipment Purchases 16 25 25 - - - 10 40% General Expenses 276 281 281 - - - 579 206% Rents and Leases 4,308 4,448 4,448 - - 6 2,152 49% Allocated Charges 3,674 3,675 3,668 (7) - - 1,779 49% Debt Service 608 608 608 - 0% Subtotal 34,913 33,340 33,360 20 13 1,199 14,199 46% Operating Transfers Out 338 338 327 (11) - - 169 52% Capital Improvement Program 1,650 3,669 3,669 - 44 205 152 11% Total Uses 36,901 37,347 37,356 9 57 1,404 14,520 43% Net (From) Landfill Closure Liab (475) (475) (566) (91) Net To (From) Reserves (6,530) (237) (257) (111) Beginning Reserves (2,911) (4,277) (4,277) - Projected Ending Reserves (9,441) (4,514) (4,534) (111) CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY REFUSE FUND (in thousands of dollars) BUDGET ** Excludes encumbrances and reappropriation (as of 12-31-10) Page 7 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 5,506 5,506 5,506 - - - 2,870 52% Interest Income 159 159 159 - - - 72 45% Other Income 68 68 68 - - - 3 4% Reapprop/Encumbrances 2,409 2,409 - - Total Sources 5,733 8,142 8,142 - - - 2,945 51%** Uses of Funds Salaries and Benefits 1,000 1,000 1,016 16 - - 432 43% Contract Services 379 440 440 - - 78 241 72% Supplies and Materials 99 111 111 - - 19 40 53% Facility and Equipment Purchases 12 12 12 - - - 12 97% General Expenses 151 782 782 - - - 4 1% Rents and Leases 6 6 6 - - - - 0% Allocated Charges 617 617 616 (1) - - 275 45% Debt Service 950 950 950 - - - 260 27% Subtotal 3,214 3,918 3,933 15 - 97 1,264 35% Operating Transfers Out 609 609 607 (2) - - 304 50% Capital Improvement Program 1,788 3,493 3,643 150 1,500 35 304 50% Total Uses 5,611 8,020 8,183 163 1,500 132 1,873 43% Net Surplus (Deficit) 122 122 (41) (163) Loan repayment to the General Fund - - Beginning Reserves 300 286 286 - Projected Ending Reserves 422 408 245 (163) ** Excludes encumbrances and reappropriation CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY STORM DRAINAGE FUND (in thousands of dollars) BUDGET (as of 12-31-10) Page 8 of 24 3/9/2011 Exhibit A ACTUALS Adopted Adjusted Midyear Midyear Pre- % of Budget Budget Budget Changes Encumbr Encumbr Actual Midyear Budget Sources of Funds Net Sales 20,095 20,095 20,095 - - - 9,974 50% Interest Income 422 422 422 - - - 290 69% Other Income 73 73 73 - - - 1,637 2242% Reapprop/Encumbrances 22,043 22,043 - Total Sources 20,590 42,633 42,633 - - - 11,901 58%** Uses of Funds Salaries and Benefits 9,213 9,213 9,309 96 - - 4,282 46% Contract Services 1,884 3,058 3,058 - 193 970 636 59% Supplies and Materials 1,838 2,016 2,016 - 92 675 651 70% Facility and Equipment Purchases 10 10 10 - - - - 0% General Expenses 404 405 405 - - - 379 93% Rents and Leases - - - - - - - 0% Allocated Charges 4,660 5,010 4,998 (12) - - 2,535 51% Debt Service 815 815 815 - - - - 0% Subtotal 18,824 20,527 20,611 84 284 1,644 8,484 51% Operating Transfers Out 9 9 9 - - - 4 49% Capital Improvement Program 2,500 23,191 12,567 (10,624) 9 3,298 1,371 37% Total Uses 21,333 43,727 33,187 (10,540) 293 4,943 9,859 45% Net To (From) Reserves (743) (1,094) 9,446 10,540 Beginning Reserves (12,003) (10,226) (10,226) - Projected Ending Reserves (12,746) (11,320) (780) 10,540 ** Excludes encumbrances and reappropriation CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY WASTEWATER TREATMENT FUND (in thousands of dollars) BUDGET (as of 12-31-10) Page 9 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description NON-DEPARTMENTAL 10200000 20520 (20,000) Transfer from Electric Fund to cover its share in the cost of the Urban Forest Management Plan 10200000 20250/60 (21,029) Increase to correct interfund transfers 10200000 118XX (1,289,000) Improvement in sales tax 10200000 11XXX 584,000 Property tax decline 10200000 11850 (379,000) Improvement transient occupancy tax 10300000 118XX 605,000 Utility users' tax decline 10200000 11800 (389,000) Improvement in documentary transfer tax 10200000 19780 (60,000) To record interdepartmental rental income from to the Utilities Department for use of a portion of the former Los Altos Treatment Plant site Various Various 309,000 Return on investment decline General Fund Revenue Changes (660,029) 10200000 37010 80,000 To reimburse City Manager's contingency account for the Urban Forest Management Plan 10200000 37010 45,000 To reimburse City Manager's contingency account for the development of City's ethics program 10200000 37020 35,000 To reimburse Council contingency account for the cost of continued publication of agenda and standing committees in the newspaper 10200000 37040 (125,000) To remove City Attorney's contingency (one-time) 80191004 40410 55,000 To transfer from Fund 191 – Public Donation Fund to Capital Project Fund. Donations from Friends of JMZ to contribute to the cost of the CIP project per CMR: 193:10 10200000 40550 (240,000) Reverse transfer to Refuse Fund; originally approved by Council on September 20, 2010 (CMR 356:10) to meet landfill cash requirements; transfer is no longer needed. Non-Departmental Other Expenses (150,000) Net Changes To (From) Reserves 810,029 CITY ATTORNEY various 30140 (328) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 14,455 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 5,602 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 2,853 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 22,582 18010001 39160 (961) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (961) Net Changes To (From) Reserves (21,621) CITY AUDITOR 16020002 30990 4,996 Increase in General Benefits charges due to Internal Service Fund interest allocation 16020002 30990 1,937 Increase in General Benefits charges due to deferral of employee healthcare contribution plan 16020002 30372 986 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 7,919 16020002 39160 (422) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (422) Net Changes To (From) Reserves (7,497) CITY CLERK various 30990 6,242 Increase in General Benefits charges due to Internal Service Fund interest allocation GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Page 10 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET various 30990 2,420 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 1,232 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 9,894 12010001 39160 (728) Reduction in General Liability charges due to Internal Service Fund interest allocation 12040003 33490 (100,000) Reduction in inter-agency expense due to the savings realized. The costs for the November 2010 election measures have come in less than what was estimated by the Registrar of Voters. Other Revenue and Expense (100,728) Net Changes To (From) Reserves 90,834 CITY COUNCIL 14020002 30990 734 Increase in General Benefits charges due to Internal Service Fund interest allocation 14020002 30990 285 Increase in General Benefits charges due to deferral of employee healthcare contribution plan 14020002 30372 145 Transfer allocated retiree medical reimbursement expense to department Other Revenue and Expense 1,164 Net Changes To (From) Reserves (1,164) CITY MANAGER 11010001 30030 60,000 Increase in temporary salaries 11010001 30140 (798) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 14,387 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 5,576 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 2,840 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 82,005 11010001 39160 (874) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (874) Net Changes To (From) Reserves (81,131) ADMINISTRATIVE SERVICES various 30140 (4,929) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 37,913 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 14,694 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 7,484 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 55,162 40010001 39160 (5,067) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (5,067) Net Changes To (From) Reserves (50,095) COMMUNITY SERVICES 80020210 18010 (44,908) To accept donations from Friends of Children’s Theatre. This is a one-time donation to cover the cost of contract services for summer productions. This is separate from the money received in-lieu of a participation fee. 80020210 31990 44,908 Expenditure associated with Friends of Children’s Theatre one-time donation to cover the cost of contract services for summer productions. This is separate from the money received in-lieu of a participation fee. Page 11 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET 80020210 15990 (12,013) To recognize revenues for the Children's Theatre. The Children’s Theatre has partnered with PAUSD and the Stevenson school to provide in-school dance and theatre classes. 80020210 31080 12,013 Expenditure associated with Children’s Theatre partnering with PAUSD and the Stevenson school to provide in-school dance and theatre classes. 80020211 15990 (2,925) To recognize revenues. Children’s Music & Dance has partnered Stevenson school to provide lunch time dance classes. 80020211 31990 2,925 Expenditure associated with Children’s Music & Dance partnering with Stevenson school to provide lunch time dance classes. 80060123 15990 (5,238) Grant received from the State Coastal Conservancy 80060123 31990 5,238 Expenditure associated grant received from the State of Coastal Conservancy Grant/Reimbursement Revenue and Expense - various 30140 (25,894) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 61,830 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 23,964 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 12,205 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 72,105 80040005 20650 47,941 Reduce revenue due to insufficient funding for the Family Resources Program from the Family Resources Foundation 80060312 31990 (10,000) To reimburse City Manager's contingency account for the Urban Forest Management Plan 80060120 31990 (10,000) To reimburse City Manager's contingency account for the Urban Forest Management Plan 80040003 31990 9,000 Transfer ADA budget from PCE to CSD 80010001 39160 (11,095) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense 25,846 Net Changes To (From) Reserves (97,951) FIRE Various 30040 610,000 Increase in overtime expense to align current budget with historical trends Various 30140 (176,753) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Various 30990 148,852 Increase in General Benefits charges due to Internal Service Fund interest allocation Various 30990 57,692 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Various 30372 29,383 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 669,174 75010001 12520 (365,000) Increase in revenue for Stanford Fire budget to actual billing 75030008 13370 (100,000) Revenue improvement due to increased activity at the Development Center 75010001 31990 80,000 Standards of coverage study 75010001 31990 22,500 OES study 75010001 31990 50,000 Fire Chief recruitment costs 75010001 39160 (16,424) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (328,924) Net Changes To (From) Reserves (340,250) HUMAN RESOURCES various 30140 (3,517) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 16,508 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 6,396 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Page 12 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET various 30372 3,258 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 22,645 various 30010 10,191 Reimbursement of salary appropriations that were used to cover purchase orders that were not correctly carried forward. 13010001 39160 (1,441) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense 8,750 Net Changes To (From) Reserves (31,395) LIBRARY 84010001 15300 (22,373) To accept receipt of Public Library Fund grant from the State 84010001 31990 3,000 To expend Other Contract Services funded by PLF grant 84030001 32230 14,373 To expend Book Purchases funded by PLF grant 84030001 32280 1,300 To expend Electronic Resources funded by PLF grant 84070002 35030 1,850 To expend Non-Capital Office Machinery funded by PLF grant 84070004 35030 1,850 To expend Non-Capital Office Machinery funded by PLF grant Grant/Reimbursement Revenue and Expense - various 30140 (5,217) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 33,405 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 12,947 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 6,594 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 47,729 84010001 39160 (4,747) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (4,747) Net Changes To (From) Reserves (42,982) PLANNING AND COMMUNITY ENVIRONMENT various 30140 (96) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 44,682 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 17,318 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 8,820 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 70,724 60020101 18990 (11,665) Increase in planning and transportation other miscellaneous revenue. 60020204 14890 (17,120) Increase in comprehensive plan fee revenue. 60020402 14670 (3,722) Increase in current planning-general use permit revenue. 60020403 12490 (7,000) Increase in code enforcement-fines, forfeitures, and penalties revenue. 60020404 13230 (76,500) Increase in zone change fee revenue. 60020405 14890 (20,000) Increase in current planning-individual review fee revenue. 60020406 14700 (17,750) Increase in green building fee revenue. 60020501 15990 (10,775) Increase in transportation revenue for VTA-Project Readiness Initiative. 60030001 13190 (11,500) Increase in special service fee revenue. 60030001 13370 (340,000) Increase in plan checking fee revenue due to increase in development activities 60030001 14570 (390,000) Increase in building permit revenue due to increase in development activities 60030001 19170 (143,557) Increase in interdepartmental revenue from various CIP projects. 60030002 31990 50,000 This request is for a Contract Plan Technician to pilot Blueprint recommendations at the DC front counter aimed at improving customer service and reducing applicant wait and permit processing times. 60030003 31070 50,000 This request is for a Contract Plan Checker to work at the Development Center on primarily high priority/cost-recovery projects that require rapid turnaround and limited inter-departmental coordination. The position will also support implementation of DC Blueprint piloting recommendations. Page 13 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET 60030001 32080 20,000 To cover the acquisition of a sufficient number of sets of the newly adopted 2010 Building Codes and related reference materials for plan check and inspection staff. 60020402 31990 15,000 This is for the Development Center Blueprinting/Restructuring Efforts project. The Planners are an integral part of this effort and consultants are being utilized to backfill on some of their projects. 60030002 30030 21,720 This temporary salary request is to fund a Limited Hourly Administrative Specialist to work at the Development Center front counter reception station. This is a critical front line customer service position that is being reviewed as part of the DC Blueprint/Restructuring effort. 60030002 30030 91,513 This temporary salary request is to fund a Management Specialist position that is working under the direction of the City Manager's Office in the capacity of System Improvement Manager for the DC Blueprinting/Restructuring effort. 60030005 31990 (9,000) Transfer ADA budget from PCE to CSD 60030001 33220 42,000 To increase bank fees due to the increase in the volume of business activities in the Development Center 60020201 31990 (20,000) To reimburse City Manager's contingency account for the Urban Forest Management Plan 60010001 39160 (5,329) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (793,686) Net Changes To (From) Reserves 722,962 Page 14 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET POLICE 70020002 15370 (20,899) 70020002 30040 20,899 70060004 15370 (470) 70060004 30040 470 70040002 15990 (7,310) 70040002 30040 7,310 70030003 15370 (22,770) 70030003 30040 22,770 Grant/Reimbursement Revenue and Expense - 70080002 30010 (44,629) Transfer 0.5 FTE CSU from General Fund to Special Revenue Fund - College Terrace Various 30040 205,000 Increase in overtime expense to align current budget with historical trends Various 30140 (121,746) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Various 30990 164,502 Increase in General Benefits charges due to Internal Service Fund interest allocation Various 30990 63,758 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Various 30372 32,472 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 299,357 70030003 19090 87,500 Decrease in interdepartmental communications revenue; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor 70080002 12030 200,000 Parking violation revenue decline 70030004 12520 (42,000) Increase in revenue for Stanford Communications budget to actual billing 70020001 30010 33,000 Reimbursement of salary appropriations used to cover extension of the Track Watch program 70010001 39160 (21,301) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense 257,199 Net Changes To (From) Reserves (556,556) PUBLIC WORKS various 30140 (8,597) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 51,266 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 19,870 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 30372 10,120 Transfer allocated retiree medical reimbursement expense to department Salary Related Revenue and Expense 72,659 50040006 13750 (33,750) Improvement in external street cut fee revenue due to increase in development activities 50040007 13370 (15,000) Improvement in plan checking fee revenue due to increase in development activities 50040007 14570 (4,000) Improvement in building- new construction permit revenue due to increase in development activities 50040007 14590 (6,000) Improvement in encroachment permit revenue due to increase in development activities 50040007 14660 (16,000) Improvement in street opening permit revenue due to increase in development activities 50020301 13370 34,300 Revenue reduction for Tree Inspection. PAD is working with Planning to ensure fees are being collected appropriately. 50020305 31270 (20,000) To reimburse City Manager's contingency account for the Urban Forest Management Plan 50010001 39160 (9,712) Reduction in General Liability charges due to Internal Service Fund interest allocation Other Revenue and Expense (70,162) Reimbursable expense related to Alameda County Sheriff's Office and Urban Shield Exercise conducted Fall 2010 Reimbursement from the FBI for overtime associated with the department's participation in the Silicon Valley Regional Computer Forensic Laboratory (SERF) Reimbursement from the State of California for overtime salaries for training and backfilling for dispatchers while training. Page 15 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description GENERAL FUND CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Net Changes To (From) Reserves (2,497) 10200000 38220 445,686 Budget Stabilization Reserve 19100000 38220 (55,000) Public Donations fund balance Total General Fund 390,686 Fund Balancing Entries Page 16 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description Revenue Technology Fund 40070603 20560 2,445 To reverse operating transfer from Refuse Fund for CIP Project TE-11005 (Implementation of New Utility Rates). Refuse Fund does not share in the cost of this project. Technology Fund 40070603 20550 11,439 To reverse operating transfer from Storm Drainage Fund for CIP Project TE- 11005(Implementation of New Utility Rates). Storm Drainage Fund does not share in the cost of this project. General Benefits 68700000 16010 1,013,200 Revenue adjustment (decrease) to allocate interest income to this fund General Benefits 68700000 18910 (1,013,200) Corresponding department charge increase related to interest income adjustment Workers' Comp Insurance Program 68800000 16010 (459,700) Revenue adjustment (increase) to allocate interest income to this fund Workers' Comp Insurance Program 68800000 18920 459,700 Corresponding department charge decrease related to interest income adjustment General Liabilities Insurance Program 68900000 16010 (145,600) Revenue adjustment (increase) to allocate interest income to this fund General Liabilities Insurance Program 68900000 19160 145,600 Corresponding department charge decrease related to interest income adjustment Retiree Health Benefit 69400000 18910 200,000 Transfer allocated retiree medical reimbursement expense to department 213,884 Expenditures Vehicle Replacement Fund 50080401 38790 (21,762) To close project and return balance to reserve Vehicle Replacement Fund 50080401 38790 25,000 To provide for the environmental testing for Foothills Park Fuel Station Vehicle Replacement Fund 50080402 38790 (367) To close project and return balance to reserve Vehicle Replacement Fund 50080310 39160 (2,082) Reduction in General Liability charges due to Internal Service Fund interest allocation Vehicle Replacement Fund 50080302 30140 (17,416) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Vehicle Replacement Fund various 30990 13,130 Increase in General Benefits charges due to Internal Service Fund interest allocation Vehicle Replacement Fund various 30990 5,089 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Vehicle Replacement Fund various 3037X 3,397 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Technology Fund 40070003 39160 (5,329) Reduction in General Liability charges due to Internal Service Fund interest allocation Technology Fund various 30140 (2,876) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Technology Fund various 30990 36,669 Increase in General Benefits charges due to Internal Service Fund interest allocation Technology Fund various 30990 14,213 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Technology Fund various 3037X 9,485 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Printing & Mailing Services 40030201 39160 (757) Reduction in General Liability charges due to Internal Service Fund interest allocation Printing & Mailing Services 40030202 30140 (231) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Printing & Mailing Services various 30990 906 Increase in General Benefits charges due to Internal Service Fund interest allocation Printing & Mailing Services various 30990 351 Increase in General Benefits charges due to deferral of employee healthcare contribution plan Printing & Mailing Services various 3037X 235 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Retiree Health Benefit 69400000 30372 (200,000) Transfer allocated retiree medical reimbursement expense to department (142,345) Net Internal Service Fund Adjustments (71,539) Fund Balancing Entries Technology Fund 40070001 38300 (66,046) Technology Fund Balance Printing & Mailing Services 40030001 38011 (504) Print & Mailing Services Fund Balance Vehicle Replacement Fund 50080001 38090 (4,989) Vehicle Replacement Fund Balance General Benefits 68700000 38011 0 General Benefits Fund Balance Workers' Comp Insurance Program 68800000 38XXX 0 Workers' Comp Insurance Program Fund Balance General Liabilities Insurance Program 68900000 38011 0 General Liabilities Insurance Program Fund Balance Retiree Health Benefit 69400000 38XXX 0 Retiree Health Benefit Fund Balance Revenue Law Enforcement Services 70248003 15370 (125,000) Revenue associated with COPS funds to be budgeted in the City's SLESF (125,000) Expenditures University Ave Parking Permits 23600000 30030 20,800 Increase in temporary salaries for Management Specialist (Parking Manager) to help analyze our existing parking strategies including permit distribution methods, time-limit allocations, and signage programs to help identify ways to better manager our parking inventory. 23600000 31990 20,111 Downtown Street Team Program outreach services and peer to peer counseling SPECIAL REVENUE FUNDS AND AGENCY FUNDS Net Special Revenue And Agency Revenue Adjustments Net ISF Expenditure Adjustments Net ISF Revenue Adjustments CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET INTERNAL SERVICE FUNDS Page 17 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Law Enforcement Services 70248003 35070 125,000 Expense associated with COPS funds to be budgeted in the City's SLESF Residential Parking Permit Program 60020506 30010 44,629 Transfer 0.5 FTE CSO from General Fund to Special Revenue Fund - College Terrace Family Resources Program 801850001 40110 (47,941) Reduce transfer to General Fund due to insufficient funding for the Family Resources Program from the Family Resources Foundation 162,599 Net Special Revenue and Agency Fund Adjustments (37,599) University Ave Parking Permits 23600000 38500 (40,911)University Ave Parking Permits Fund Balance Law Enforcement Services 70248003 38500 0 Law Enforcement Services Fund Balance Residential Parking Permit Program 60020506 38500 (44,629)Residential Parking Permit Program Fund Balance Family Resources Program 801850001 38500 47,941 Family Resources Program Fund Balance Revenue 50471010 20520 (109,752) Revenues from UTL Department regarding energy efficiency rebates 50471011 15370 (163,802) Allocation from the State of California (Proposition 42) - Traffic Congestion Relief 50471010 25010 (903,486) Measure N Library Bond 80471002 20150 (55,000) Transfer from Fund 191 – Public Donation Fund. Donations from Friends of JMZ to contribute to the cost of the project refer to CMR: 193:10 60471006 15010 (1,099,000) Federal grants for CIP Projects PL-11003 (Palo Alto-Traffic Signal Central System Upgrade) and PL-11004 (Alma Street-Traffic Signal Improvements) (2,331,040) Expenditures 50471010 38790 109,752 To increase appropriation due to revenues from UTL Department regarding energy efficiency rebates 50471011 38790 163,802 To increase appropriation due to allocation from the State of California (Proposition 42) - Traffic Congestion Relief 50471010 38790 2,250,944 Additional appropriation to cover library costs: (1) for temporary facility for the Main Library, (2) accelerate the design phase of the Main Library to take advantage of lower construction cost climate and (3) to revise preliminary cost estimate of the Downtown Library. 50471020 38790 125,000 Transfer to San Antonio Road CIP project for conduit work on San Antonio Road Phase 11 60471006 38790 550,000 This project funds the design and construction of streetscape enhancements along California Avenue between El Camino Real and the Caltrain – Park Blvd Plaza. A $1,175,200, grant was received in FY 2011 from the VTA – Community Design & Transportation (CDT) program that requires a $550,000 local match. 60471006 38790 400,000 This project funds the replacement of the City’s existing traffic signal central system and up to 35 traffic signal field controllers with associated communications gear. This is 100% reimbursable by federal earmark grant. 60471006 38790 699,000 This project funds traffic signal modifications at the intersections of Alma St & Churchill Rd and Alma St & East Meadow Dr. Federal grant provides fudning for this project. 80471002 38790 56,300 Transfer of 1%of the San Antonio Road project appropriation to Art in Public Places and to transfer the appropriation for the purchase of fountain for the California Avenue to Art in Public Places 60471005 38790 (45,816) This project funds the design and construction of streetscape enhancements along California Avenue between El Camino Real and the Caltrain – Park Blvd Plaza. A $1,175,200, grant was received in FY 2011 from the VTA – Community Design & Transportation (CDT) program that requires a $550,000 local match. 50471004 38790 (125,000) Transfer to San Antonio Road CIP project for conduit work on San Antonio Road Phase 11 80471002 38790 (481,763) To close project and return balance to reserve 50471005 38790 (1,500,000) To reduce appropriation due to savings realized from lower bids 80471006 38790 (2,788) To close project and return balance to reserve 50471010 38790 (1,347,458) To reduce budget to due to revised estimates by engineers 50471010 38790 (173,880) To close project and return balance to reserve 50471011 38790 (567,762) To close project and return balance to reserve 50471020 38790 (200,764) To close project and return balance to reserve 50471010 39170 143,557 To reallocate to cover inter-departmental charges 50471010 38790 (143,557) To reallocate to cover inter-departmental charges various 30140 (753) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 22,816 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 8,854 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 5,910 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution GENERAL FUND CIP Net CIP Revenue Adjustments Net Special Revenue and Agency Expenditure Adjustments Page 18 of 24 3/9/2011 Exhibit A Cost Comm FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET 50471011 40520 117,101 Return to Electric Fund due to closing and completion of CIP Project PE-08005 ( MSC Resurfacing ) 50471011 40530 35,485 Return to Gas Fund due to closing and completion of CIP Project PE-08005 ( MSC Resurfacing ) 50471011 40510 56,776 Return to Water Fund due to closing and completion of CIP Project PE-08005 ( MSC Resurfacing ) 50471011 40540 74,519 Return to Wastewater Collection Fund due to closing and completion of CIP Project PE- 08005 ( MSC Resurfacing ) 50471011 40550 138,392 Return to Refuse Fund due to closing and completion of CIP Project PE-08005 ( MSC Resurfacing ) 368,667 1,962,373Net CIP Adjustments To (From) Reserves Net CIP Expenditure Adjustments Page 19 of 24 3/9/2011 Exhibit A Cost Comm. FY 2011 Center Item Midyear Adj Description Electric Fund 20020202 15990 (35,083) Increase in grant revenue from Bay Area Air Quality Management District for CIP EL- 11016 Electric Vehicle Charging Infrastructure 20000020 20410 (117,101) Transfer from Capital Project Fund to return funding for CIP Project PE-08005 (MSC Resurfacing Project) due to the completion of the project Source Changes (152,184) 20020103 31990 (10,000) To reallocate to cover costs of Urban Forest Management Plan 20020102 31990 (5,000) To reallocate to cover costs of Urban Forest Management Plan 20000020 40110 15,000 Transfer to General Fund to cover the share in the cost of the Urban Forest Management Plan 20040102 31990 (5,000) To reallocate to cover costs of Urban Forest Management Plan 20000030 40110 5,000 Transfer to General Fund to cover the share in the cost of the Urban Forest Management Plan 20000031 39090 (228) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor 20000021 39090 (2,362) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor 20040102 31070 49,440 Increase in program and project consulting to fund 25% of feasibility study for anaerobic digestion facility approved by Council on August 2, 2010; CMR 333:10; funding from Calaveras reserve 20040102 30010 27,924 Increase in salaries to reallocate 1.0 FTE Resource Planner from Gas Fund 20020202 38790 135,083 Increase to establish CIP EL-11016 Electric Vehicle Charging Infrastructure 20000020 40410 109,752 Increase in transfer from Electric Public Benefits Reserve to Capital Projects Fund for CIP PE-09006 Mitchell Park Library for energy efficiency rebates various 39100 54,472 Increase in utilities administration charges for midyear adjustments to the Utilities Administration Fund 20020103 39780 45,000 To record interdepartmental rental payment to the General Fund for use of a portion of the former Los Altos Treatment Plant site 20000031 39160 (16,918) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (23,997) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 102,239 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 39,625 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 26,448 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution 546,478 (394,294) 20000020 38040 (192,272) Electric Distribution Rate Stabilization Reserve 20000020 38160 (109,752) Electric Public Benefits Reserve 20000030 38080 (49,440) Electric Supply Calaveras Reserve 20000030 38170 (42,830) Electric Supply Rate Stabilization Reserve (394,294) Fiber Optics Fund 20020611 38790 (1,422) To close CIP projects and return balance to reserve 20000081 39100 3,507 Increase in utilities administration charges for midyear adjustments to the Utilities Administration Fund 20000081 39160 (510) Reduction in General Liability charges due to Internal Service Fund interest allocation 20020611 30140 (68) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 7,260 Increase in General Benefits charges due to Internal Service Fund interest allocation Fund Balancing Entries CITY OF PALO ALTO ENTERPRISE FUNDS FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Total Electric Fund Net Changes To (From) Reserves Use Changes Page 20 of 24 3/9/2011 Exhibit A Cost Comm. FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO ENTERPRISE FUNDS FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET various 30990 2,813 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 1,878 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution 13,458 (13,458) 20000080 38040 (13,458) Fiber Optics Rate Stabilization Reserve (13,458) Gas Fund 20000040 20410 (35,485) Transfer from Capital Project Fund to return funding for CIP Project PE-08005 (MSC Resurfacing Project) due to the completion of the project Source Changes (35,485) 20000051 39090 (473) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor 20000041 39090 (46,812) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor various 30010 (2,998) Decrease in salaries to reclassify Utilities Installer Repairer to Coordinator Utility Project; reallocate 0.65 FTE to Wastewater Collection Fund 20040202 30010 (27,924) Decrease in salaries to reallocate 1.0 FTE Resource Planner to Electric Fund 20020703 30010 (894) Decrease in salaries to correct compensation for 0.43 FTE Restoration Lead 20020802 38790 (38,661) To close projects and return balance to reserve various 39100 27,435 Increase in utilities administration charges for midyear adjustments to the Utilities Administration Fund 20020702 39780 7,500 To record interdepartmental rental payment to the General Fund for use of a portion of the former Los Altos Treatment Plant site 20000051 39160 (8,474) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (8,171) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 44,944 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 17,419 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 11,626 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution (25,483) 60,968 20000050 38170 16,391 Gas Supply Rate Stabilization Reserve 20000040 38040 44,577 Gas Distribution Rate Stabilization Reserve 60,968 Water Fund 20000060 20410 (56,776) Transfer from Capital Project Fund to return funding for CIP Project PE-08005 (MSC Resurfacing Project) due to the completion of the project Source Changes (56,776) 20000061 39090 (19,250) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor various 30010 (1,614) Decrease in salaries to reclassify Utilities Installer Repairer to Coordinator Utility Project; reallocate 0.35 FTE to Wastewater Collection Fund 20020904 30010 (645) Decrease in salaries to correct compensation for 0.31 FTE Restoration Lead Fund Balancing Entries Use Changes Net Changes To (From) Reserves Fund Balancing Entries Total Fiber Optics Fund Net Changes To (From) Reserves Use Changes Total Gas Fund Page 21 of 24 3/9/2011 Exhibit A Cost Comm. FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO ENTERPRISE FUNDS FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET 20000061 39100 24,789 Increase in utilities administration charges for midyear adjustments to the Utilities Administration Fund 20020902 39780 7,500 To record interdepartmental rental payment to the General Fund for use of a portion of the former Los Altos Treatment Plant site 20000061 39160 (7,382) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (17,025) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 40,916 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 15,858 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 10,585 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution 53,732 3,044 20000060 38040 3,044 Water Rate Stabilization Reserve 3,044 Wastewater Collection Fund 52 20000070 20410 (74,519) Transfer from Capital Project Fund to return funding for CIP Project PE-08005 (MSC Resurfacing Project) due to the completion of the project Source Changes (74,519) 20000071 39090 (18,375) Decrease in interdepartmental communications expense; Utilities alarm monitoring is being transitioned from Police Dept. to outside vendor 20021103 30010 4,612 Increase in salaries to reclassify Utilities Installer Repairer to Coordinator Utility Project; reallocate 1.0 FTE from Gas and Water Funds 20021103 30010 (541) Decrease in salaries to correct compensation for 0.26 FTE Restoration Lead 20000071 39100 14,833 Increase in utilities administration charges for midyear adjustments to the Utilities Administration Fund 20000071 39160 (4,980) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (6,436) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 24,119 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 9,348 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 6,239 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Use Changes 28,819 Net Changes To (From) Reserves 45,700 Fund Balancing Entries 20000070 38040 45,700 Wastewater Collection Rate Stabilization Reserve Total Wastewater Collection Fund 45,700 Refuse Fund 50050001 20410 (138,392) Transfer from Capital Project Fund to return funding for CIP Project PE-08005 (MSC Resurfacing Project) due to the completion of the project 50050001 20110 240,000 Reverse transfer from General Fund; originally approved by Council on September 20, 2010 (CMR 356:10) to meet landfill cash requirements; transfer is no longer needed. Use Changes Total Water Fund Net Changes To (From) Reserves Fund Balancing Entries Page 22 of 24 3/9/2011 Exhibit A Cost Comm. FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO ENTERPRISE FUNDS FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET Source Changes 101,608 50050001 40600 (11,439) Reverse transfer to Technology Fund to correct error for CIP TE-11005 Implementation of Restructured Tiered Rates on Bills 50050002 39160 (6,581) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (22,786) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 30,725 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 11,909 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 7,948 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Use Changes 9,776 Net Changes To (From) Reserves (111,384) Fund Balancing Entries 50050001 38040 (111,384) Refuse Fund Rate Stabilization Reserve Total Refuse Fund (111,384) Storm Drainage Fund 50070001 40600 (2,445) Reverse transfer to Technology Fund to correct error for CIP TE-11005 Implementation of Restructured Tiered Rates on Bills 50070201 38790 150,563 Correction to restore appropriation related to staff salaries and benefits in 2010 50070002 39160 (1,194) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (230) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 10,029 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 3,887 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 2,595 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution 163,205 (163,205) 50070001 38040 (163,205) Storm Drainage Fund Reserve (163,205) Wastewater Treatment Fund 50060201 38790 (623,849) To close completed project and return balance to reserve 50060201 38790 (10,000,000) To reduce appropriation for CIP project due to savings realized from lower construction bids 50060002 39160 (11,692) Reduction in General Liability charges due to Internal Service Fund interest allocation various 30140 (11,858) Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation various 30990 65,416 Increase in General Benefits charges due to Internal Service Fund interest allocation various 30990 25,355 Increase in General Benefits charges due to deferral of employee healthcare contribution plan various 3037X 16,922 Transfer allocated retiree medical reimbursement expense to department and to fully budget for retiree medical ARC contribution Fund Balancing Entries Total Storm Drainage Fund Use Changes Net Changes To (From) Reserves Page 23 of 24 3/9/2011 Exhibit A Cost Comm. FY 2011 Center Item Midyear Adj Description CITY OF PALO ALTO ENTERPRISE FUNDS FISCAL YEAR 2011 MIDYEAR BUDGET SUMMARY DETAIL CHANGES TO THE ADJUSTED BUDGET (10,539,706) 10,539,706 50060001 38040 10,539,706 Wastewater Treatment Fund Reserve 10,539,706 Utilities Operating Administrative Fund 20010002 19100 (125,036) Increase in reimbursements from the Utilities Funds for midyear adjustments to the Utilities Administration Fund (125,036) Various 30990 14,230 Increase in General Benefits charges due to Internal Service Fund interest allocation Various 30990 5,515 Increase in General Benefits charges due to deferral of employee healthcare contribution plan 20010001 30140 8 Reduction in Workers' Compensation charges due to Internal Service Fund interest allocation Various 3037X 3,681 Transfer allocated retiree medical reimbursement expense to department 20000002 39160 1,602 Reduction in General Liability charges due to Internal Service Fund interest allocation 20010001 31990 100,000 Increase in contract services for organizational assessment of the Utilities Dept. 125,036 - Use Changes Net Changes To (From) Total Wastewater Treatment Fund Use Changes Net Changes To (From) Reserves Fund Balancing Entries Source Changes Page 24 of 24 3/9/2011 Exhibit B Project Funding Title Number Revenue Expense Source Comments ADDITIONAL APPROPRIATIONS Mitchell Park Library PE-09006 $ 109,752 $ 109,752 Utilities Public Benefits Program Revenues from UTL Department regarding energy efficiency rebates Main Library New Construction and Improvements PE-11000 $ 450,000 $ 450,000 Measure N Library Bond The design phase of the project was on the accelerated schedule to take advantage of the low construction bid trend due to the economy. Temporary Facility for Main Library (New Project) ( Exhibit B-1) PE-11012 $ 500,000 $ 500,000 Measure N Library Bond Temporary Facility for the Main Library while construction is in progress Downtown Library Improvements PE-09005 $ 1,300,944 $ 1,300,944 Measure N Library Bond To adjust Library projects to the revised engineers estimates; original budget was preliminary. Street Maintenance PE-86070 $ 163,802 $ 163,802 Proposition 42 Allocation from the State of California (Proposition 42) - Traffic Congestion Relief San Antonio Road Median Improvements PE-00104 125,000$ Infrastructure Reserve Transfer to San Antonio Road CIP project for conduit work on San Antonio Road Phase 11 Art in Public Places AC-86017 56,300$ Infrastructure Reserve Transfer of 1%of the San Antonio Road project appropriation to Art in Public Places California Avenue - Transit Hub Corridor Project (New Project) (Exhibit B-2) PL-11002 550,000$ Infrastructure Reserve This project funds the design and construction of streetscape enhancements along California Avenue between El Camino Real and the Caltrain – Park Blvd Plaza. A $1,175,200, grant was received in FY 2011 from the VTA – Community Design & Transportation (CDT) program that requires a $550,000 local match. Palo Alto-Traffic Signal Central System Upgrade (New Project) (Exhibit B-3) PL-11003 $ 400,000 400,000$ Federal Earmark Grant This project funds the replacement of the City’s existing traffic signal central system and up to 35 traffic signal field controllers with associated communications gear. This is 100% reimbursable by federal earmark grant. Alma Street - Traffic Signal Improvements (New Project) (Exhibit B-4) PL-11004 $ 699,000 699,000$ Federal Section 130 Grant This project funds traffic signal modifications at the intersections of Alma St & Churchill Rd and Alma St & East Meadow Dr. The project will be designed by Caltrain and constructed by the City as part of a coordination project to help improve operations at the project intersections. Total 3,623,498$ 4,354,798$ REDUCTION IN APPROPRIATIONS/TO CLOSE PROJECTS Street Lights Improvements PO-05054 $ (125,000) Infrastructure Reserve Transfer to San Antonio Road CIP project for conduit work on San Antonio Road Phase 11 Civic Center Infrastructure Improvements PF-01002 $ (1,500,000) Infrastructure Reserve To reduce appropriation due to savings realized from lower bids Community Center and Library Temporary Facilities PE-09010 $ (149) $ (149) Measure N Library Bond To adjust Library projects to the revised engineers estimates; original budget was preliminary. Mitchell Park Library and Community Center PE-09006 $ (1,347,309) $ (1,347,309) Measure N Library Bond To adjust Library projects to the revised engineers estimates; original budget was preliminary. Children's Library Improvements PE-04010 $ (170) Infrastructure Reserve To close project and return balance to reserve Animal Shelter Expansion PE-04014 $ (20,640) Infrastructure Reserve To close project and return balance to reserve Bridge Rail Repair, Abutment, and Deck Repairs PE-10006 $ (153,070) Infrastructure Reserve To close project and return balance to reserve Municipal Service Center Resurfacing Project PE-08005 $ (567,762) Infrastructure Reserve and various Enterprise Funds To close project and return balance to funding sources Cubberley Turf Renovation PE-07007 $ (144,464) Infrastructure Reserve To close project and return balance to reserve. FY 2011 CIP Mid-Year Adjustments CAPITAL PROJECT FUND 1 3/8/2011 Exhibit B Project Funding Title Number Revenue Expense Source Comments FY 2011 CIP Mid-Year Adjustments San Antonio Road Median Improvements PE-00104 $ (6,300) Infrastructure Reserve Transfer of 1%of the San Antonio Road project appropriation to Art in Public Places California Avenue Improvements PE-07005 $ (50,000) Infrastructure Reserve To transfer the appropriation pertaining to the purchase of a fountain to Art in Public Places Adobe Creek Bike Bridge Replacement PL-06001 $ (45,816) Infrastructure Reserve To close project and return balance to reserve JMZ New Bobcat Habitat AC-10000 $ (450,000) Infrastructure Reserve To close project and return balance to reserve Replacement of Gym B Bleachers CC-10000 $ (20,116) Infrastructure Reserve To close project and return balance to reserve Cubberley Gym Activity Room CC-11000 $ (11,647) Infrastructure Reserve To close project and return balance to reserve School Playing Field Irrigation PG-98001 $ (2,788) Infrastructure Reserve To close project and return balance to reserve Total $ (1,347,458) $ (4,445,231) TOTAL GENERAL FUND CIP MID-YEAR ADJUSTMENTS $ 2,276,040 $ (90,433) ADDITIONAL APPROPRIATIONS Electric Vehicle Charging Infrastructure (New) (Exhibit B-5) EL-11016 $ 35,083 $ 135,083 Electric Fund RSR/Grant This project will install five new generation electric vehicle charging stations at City Hall level A, Hamilton Ave in front of City Hall, and Bryant Street parking garage. TOTAL ELECTRIC FUND CIP MID-YEAR ADJUSTMENTS $ 35,083 $ 135,083 REDUCTION IN APPROPRIATIONS/TO CLOSE PROJECTS Fiber Optic Network EL-06005 (581)$ Fiber Optics Fund Distribution RSR To close project and return balance to reserve Fiber Optic Customer EL-06006 (841)$ Fiber Optics Fund Distribution RSR To close project and return balance to reserve TOTAL FIBER OPTICS FUND CIP MID-YEAR ADJUSTMENTS (1,422)$ REDUCTION IN APPROPRIATIONS/TO CLOSE PROJECTS CNG Seq Fuel System GS-03010 (35,715)$ Gas Fund Distribution RSR To close project and return balance to reserve Compressed Natural Gas GS-00011 (2,946)$ Gas Fund Distribution RSR To close project and return balance to reserve TOTAL GAS FUND CIP MID-YEAR ADJUSTMENTS (38,661)$ FIBER OPTICS FUND GAS FUND ELECTRIC FUND 2 3/8/2011 Exhibit B Project Funding Title Number Revenue Expense Source Comments FY 2011 CIP Mid-Year Adjustments ADDITIONAL APPROPRIATIONS Fuel Storage Tanks Upgrade VR-92006 20,499$ Vehicle Replacement Fund Correction to restore appropriation related to staff salaries and benefits in 2010 MSC Fuel Storage Tank Replacement VR-00001 (8,586)$ Vehicle Replacement Fund To close project and return balance to reserve MSC Equipment Maintenance Facility Mezzanine Storage Area VR-01000 (9,640)$ Vehicle Replacement Fund To close project and return balance to reserve New Vehicles for Utility Operations VR-08001 (24,035)$ Vehicle Replacement Fund To close project and return balance to reserve Fuel Storage Tanks Upgrade VR-92006 25,000$ Vehicle Replacement Fund For environmental testing for Foothills Park Fuel Station Field Service Truck VR-05001 (367)$ Vehicle Replacement Fund To close project and return balance to reserve Scheduled Vehicle and Equipment Replacements ( FY 2007) VR-07800 -$ Vehicle Replacement Fund To close completed project. There is no remaining balance. Vehicle Replacement VR-08000 -$ Vehicle Replacement Fund To close completed project. There is no remaining balance. TOTAL VEHICLE REPLACEMENT FUND CIP MID- YEAR ADJUSTMENTS 2,871$ REDUCTION IN APPROPRIATIONS Replace Existing Reclaimed Water Pipe WQ-04010 (623,849)$ Wastewater Treatment Fund RSR To close completed project and return balance to reserve Disinfection Facility Improvement Program WQ-06014 (10,000,000)$ Wastewater Treatment Fund RSR To reduce appropriation due to savings realized from lower bids TOTAL WASTEWATER TREATMENT FUND CIP MID-YEAR ADJUSTMENTS -$ (10,623,849)$ ADDITIONAL APPROPRIATIONS Alma Street Storm Drainage Improvement SD-08101 54,903$ Storm Drainage Fund RSR Correction to restore appropriation related to staff salaries and benefits in 2010 Storm Drain System Replacement SD-06101 58,214$ Storm Drainage Fund RSR Correction to restore appropriation related to staff salaries and benefits in 2010 San Francisquito Creek Storm Water Pump Station SD-06102 9,775$ Storm Drainage Fund RSR Correction to restore appropriation related to staff salaries and benefits in 2010 Channing Avenue/Lincoln Avenue Storm Drain Improvements SD-11101 27,671$ Storm Drainage Fund RSR Correction to restore appropriation related to staff salaries and benefits in 2010 Total 150,563$ TOTAL STORM DRAINAGE FUND CIP MID-YEAR ADJUSTMENTS $ - (150,563)$ STORM DRAINAGE FUND WASTEWATER TREATMENT FUND VEHICLE REPLACEMENT FUND 3 3/8/2011 Draft Revision: 174 User: ajavelo Timestamp: March 8, 2011 8:22 am Capital Budget FY 2011 City of Palo Alto 1 CIP FACTS: • New • Timeline: FY 2011 through FY 2012 • Overall Project Completion: 0% • Percent Spent: 0.00% • Managing Department: Public Works • Comprehensive Plan: Policy C-22, Program C- 20 • Potential Board/Commission Review: LAC, ARB(exterior signage) IMPACT ANALYSIS: • Environmental: None • Design Elements: Improved lighting, electrical and mechanical work • Operating: None • Telecommunications: Additional phone and data lines will be needed NEW TEMPORARY MAIN LIBRARY PROJECTS - (PE-11012) Description: This project will renovate the Art Center auditorium to function as a temporary library during the construction of the adjacent Main Library. Improvements will be made to lighting, storage areas, shelving, accessibility, ect., This will serve as a small library space for staff and patrons during the construction of the Main Library. Justification: The Main Library houses 130,000 items, including a historic collection. The new Mitchell Park branch will house a good portion of these items but a large percentage will be put into storage for the year- long construction phase on the Main Library. A temporary Main Library will allow current Main Library users to have access to a small, well-chosen variety of materials as well as a convenient place to pick up their holds. This will save automobile trips , reduce parking and use demands at the new MPL. Supplemental Information: Conceptual design was completed in December 2010 as part of the effort to identify a potential location for and cost of, a temporary library. The design will be completed in the spring of 2011. Due to limited staff availability, the services of a construction management firm will be needed. In order to reduce construction disruptions and allow for better pricing, the temporary Main Library will be included as part of the Art Center Electrical & Mechanical Improvements project (PF-07000). The historical collection may be moved into a future Palo Alto Historical Association at the Roth Building. Costs associated with this move are not included in this project. FUTURE FINANCIAL REQUIREMENTS FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 Total Funding Pre-Design Costs Design Costs Construction Costs 450,000 450,000 Other $ $ $ Total Budget Request $450,000 $$$450,000 Revenues: $450,000 $ $ $450,000 Source of Funds:Measure N Library Bond EXHBIT B1 Draft Revision: 174 User: ajavelo Timestamp: March 8, 2011 3:25 pm Capital Budget FY 2011 City of Palo Alto 1 CIP FACTS: • New • Timeline: FY 2010 - FY 2011 • Overall Project Completion: 0% • Percent Spent: 0% • Managing Department: Planning and Community Environment • Comprehensive Plan: Policies T-6, T-10, T-14, T-19, T-22, T-23, T-30, T-31, T-34 • Potential Board/Commission Review: IMPACT ANALYSIS: • Environmental: Negative Declaration approved on February 14, 2011. • Design Elements: This project may be subject to review by the ARB and PTC. • Operating: This project may have operations cost increases for landscape and street maintenance. • Telecommunications: None NEW CALIFORNIA AVENUE - TRANSIT HUB CORRIDOR PROJECT - (PL-11002) Description: This project funds the design and construction of streetscape enhancements along California Avenue between El Camino Real and the Caltrain - Park Blvd Plaza. Improvements include the installation of community identity markers; traffic calming treatments such as bulbs-outs and a 4-lane to 2-lane roadway reduction; enhanced mid-block pedestrian crosswalks; bicycle and pedestrian streetscape elements; and community- focused elements at the Park Blvd Plaza. Justification: The California Avenue - Transit Hub Corridor Project implements the City’s Comprehensive Plan vision for the corridor and is consistent with the Draft California Avenue District Specific Plan. Supplemental Information: Consultant and contract services will be used to implement this project including consultant services for the design and construction management of the project. A $1,175,200 grant was received in 2011 from the VTA - Community Design & Transportation (CDT) program that requires a $550,000 local match. FUTURE FINANCIAL REQUIREMENTS FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 Total Funding Pre-Design Costs Design Costs $550,000 $ Construction Costs $1,175,200 Other $ $ $ Total Budget Request $550,000 $1,175,200 $ Revenues: $0 $1,175,200 $ Source of Funds:VTA CDT Grant in the amount of $1,175,200 will be available beginning FY2011-12 for the construction phase of the project. EXHIBIT B2 Draft Revision: 174 User: ajavelo Timestamp: March 8, 2011 8:28 am Capital Budget FY 2011 City of Palo Alto 1 CIP FACTS: • New • Timeline: FY 2010 - FY 2011 • Overall Project Completion: 0% • Percent Spent: 0% • Managing Department: Planning and Community Environment • Comprehensive Plan: Policy T-38 • Potential Board/Commission Review: IMPACT ANALYSIS: • Environmental: This project is categorically exempt from CEQA under 15301. • Design Elements: None • Operating: None • Telecommunications: None NEW PALO ALTO - TRAFFIC SIGNAL CENTRAL SYSTEM UPGRADE - (PL-11003) Description: This project funds the replacement of the City’s existing traffic signal central system and up to 35 traffic signal field controllers with associated communications gear. The new central system will allow for improved field monitoring and better field coordination with between intersections. Justification: The existing central system and traffic signal field controllers were deployed prior to the development of current National Transportation Communications for ITS Protocol (NTCIP) and do not meet this standard. The new central system will comply with NTCIP standards and allow for the implementation of more modern traffic signal timing strategies that are not offered by the current system. Supplemental Information: Consultant and contract services will be used to identify a traffic signal controller vendor and central system integrator to help deploy the new system. A $400,000 federal earmark grant was recieved by the City to help the fund project. The grant is 100% reimbursable and no local match is required. FUTURE FINANCIAL REQUIREMENTS FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 Total Funding Pre-Design Costs Design Costs Construction Costs $400,000 $400,000 Other $ $ $ Total Budget Request $400,000 $$$400,000 Revenues: $400,000 $ $ $400,000 Source of Funds:100% reimbursable federal earmark grant. EXHIBIT B3 Draft Revision: 174 User: ajavelo Timestamp: March 8, 2011 8:30 am Capital Budget FY 2011 City of Palo Alto 1 CIP FACTS: • New • Timeline: FY 2010 - FY 2011 • Overall Project Completion: 0% • Percent Spent: 0% • Managing Department: Planning and Community Environment • Comprehensive Plan: Policies T-24, T-27, T-38 • Potential Board/Commission Review: IMPACT ANALYSIS: • Environmental: This project is categorically exempt from CEQA under 15301. • Design Elements: None • Operating: None • Telecommunications: None NEW ALMA STREET - TRAFFIC SIGNAL IMPROVEMENTS (PL-11004) Description: This project funds traffic signal modifications at the intersections of Alma Street and Churchill Road and Alma Street and East Meadow Drive. The project will be designed by Caltrain and constructed by the City as part of a coordination project to help improve operations at the project intersections. The project will provide improved railroad preemption through new traffic signal controllers and train detection, extinguishable railroad warning message signs, battery back-up equipment to operate the intersections in the event of a power failure, and new traffic signal poles standards for improved driver visibility. Justification: The project will help to provide more efficient traffic signal operations during railroad preemption activities and improve signal visibility for motorists and pedestrians. Supplemental Information: The City will be recieving a Federal Section 130 grant for this project in the amount of $1,109,644 of the grant will be used by Cal-Train for consultant design services and administration charges related to the track way improvements and the remaining $699,000 will be used by the City for construction services to implement the project FUTURE FINANCIAL REQUIREMENTS FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 Total Funding Pre-Design Costs Design Costs $50,000 $ $50,000 Construction Costs $550,000 $550,000 Other $99,000 $ $ $99,000 Total Budget Request $699,000 $$$699,000 Revenues: $699,000 $ $ $699,000 Source of Funds:Federal Section 130 Grant in the amount of $699,000 will be available beginning of Spring 2011 to do design and construction. EXHIBIT B4 Draft Revision: 174 User: ajavelo Timestamp: March 8, 2011 8:32 am Capital Budget FY 2011 City of Palo Alto 1 CIP FACTS: • New • Timeline: FY 2011 through FY 2012 • Overall Project Completion: 0% • Percent Spent: 0.00% • Managing Department: Utilities • Comprehensive Plan: Policies T-3, N-44 • Potential Board/Commission Review: IMPACT ANALYSIS: • Environmental: This project may have possible exemption from environmental review. • Design Elements: This project may have possi- ble exemption from Design review. • Operating: This project will improve operating efficiency. • Telecommunications: None NEW ELECTRIC VEHICLE CHARGING INFRASTRUCTURE - (EL-11016) Description: Install five (5) new generation electric vehicle charging stations at City Hall level A, Hamilton Ave in front of City Hall, and Bryant Street parking garage. Justification: As part of the City’s sustainability program the City applied for and received two matching grants from the Bay Area Air Quality Management District (BAAQMD) for the installation of electric vehicle charging stations. The purpose of this project is to pilot electric charging stations and to provide a charging location for electric vehicles that may use the Civic Center and businesses in Downtown Palo Alto. The grant requires that City match the $35,083 that was provided by BAAQMD Supplemental Information: Widespread adoption of EVs and greening of the City's electric supply will assist the community to achieve its green house gas (GHG) reduction goals for reducing 2020 emissions by 15% below 2005 levels. In 2005, the automobile based commute to, from, and within town is estimated to have generated 266 thousand metric tons of CO2 emissions, making up 32% of the community wide GHG emissions. Every fossil fueled car switches to 100% renewable electricity based EV charging will reduce GHG emissions by up to 5 tons/year. FUTURE FINANCIAL REQUIREMENTS FY 2011 FY 2012 FY 2013 FY 2014 FY 2015 Total Funding Pre-Design Costs Design Costs Construction Costs $135,083 $135,083 Other $ $ $ Total Budget Request $135,083 $$$135,083 Revenues: $135,083 $ $ $135,083 Source of Funds:Electric Fund with reimburment from a grant of $35,083 from BAAQMD EXHIBIT B5 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget GENERAL FUND Planning and Community Environment Department Administrative Assistant 1.00 1.00 1.00 - 1.00 Administrative Associate I 2.00 2.00 1.00 - 1.00 Administrative Associate II 4.80 3.80 3.80 - 3.80 Administrative Associate III 1.00 1.00 1.00 - 1.00 Administrator, Planning & Comm Envir 1.00 1.00 1.00 - 1.00 Assistant Building Official 1.00 1.00 1.00 - 1.00 Assistant Director, Planning & Comm Envir 1.00 - - - - Assistant Engineer - - - - - Assistant to City Manager - - 0.05 - 0.05 Associate Engineer 1.00 1.00 1.00 - 1.00 Building Inspector 4.00 4.00 4.00 - 4.00 Building Inspector Specialist 3.00 2.00 1.00 - 1.00 Building/Planning Technician 3.00 3.00 2.00 - 2.00 Chief Building Official 1.00 1.00 1.00 - 1.00 Chief Planning and Transportation Official 1.00 1.00 1.00 - 1.00 Chief Transportation Officer - - - - - Chief Transportation Official - - 1.00 - 1.00 City Traffic Engineer - - - - - Code Enforcement Officer 2.00 2.00 2.00 - 2.00 Coordinator, Transp Sys Mgmt 0.50 0.50 0.50 - 0.50 Deputy City Manager - 0.50 0.50 - 0.50 Director, Planning and Comm Envir 1.00 1.00 1.00 - 1.00 Engineer 1.00 1.00 1.00 - 1.00 Engineering Technician II 1.00 1.00 1.00 - 1.00 Manager, Economic Resources - - - - - Manager, Economic Devlpmt & Redevlpmt 1.00 1.00 1.00 - 1.00 Manager, Planning 2.00 2.00 2.00 - 2.00 Managing Arborist - - - - - Permit Specialist 1.00 - - - - Planner 6.00 6.05 5.75 - 5.75 Planning Arborist (1)1.00 1.00 1.00 - 1.00 Plan Checking Engineer 3.00 2.00 2.00 - 2.00 Project Engineer 1.00 1.00 1.00 - 1.00 Senior Planner 6.00 6.00 5.00 - 5.00 Supervisor, Building Inspection 1.00 1.00 1.00 - 1.00 Transportation Manager 1.00 1.00 - - - Transportation Project Manager - - - - - Total Planning & Community Environment 53.30 48.85 44.60 0.00 44.60 Footnotes: (1) Title change from Arborist to Planning Arborist 3/8/2011 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget GENERAL FUND Police Department Administrative Assistant 1.00 1.00 1.00 - 1.00 Administrative Associate II 3.00 3.00 3.00 - 3.00 Animal Attendant - - - - - Animal Control Officer 4.50 4.50 4.50 - 4.50 Animal Services Specialist 1.00 1.00 1.00 - 1.00 Animal Services Specialist II 1.00 1.00 1.00 - 1.00 Assistant Chief of Police 1.00 1.00 1.00 - 1.00 Business Analyst 1.00 1.00 1.00 - 1.00 Chief Communications Technician - - - - - Code Enforcement Officer 1.50 1.50 1.00 - 1.00 Communication Technician 1.00 1.00 1.00 - 1.00 Community Service Officer (1)9.00 9.00 9.00 (0.50) 8.50 Community Service Officer - Lead - - - - - Court Liaison Officer 1.00 1.00 1.00 - 1.00 Crime Analyst 1.00 2.00 1.00 - 1.00 Deputy Director Technical Services 1.00 1.00 1.00 - 1.00 Parking Enforcement Officer - - - - - Parking Enforcement Officer - Lead - - - - - Police Agent 19.00 19.00 19.00 - 19.00 Police Captain 2.00 2.00 2.00 - 2.00 Police Chief 1.00 1.00 1.00 - 1.00 Police Lieutenant 5.00 5.00 5.00 - 5.00 Police Officer 51.00 50.00 49.00 - 49.00 Police Officer Training - - - - - Police Records Specialist I - - - - - Police Records Specialist II 9.00 7.00 6.00 - 6.00 Police Records Specialist - Lead 1.00 1.00 1.00 - 1.00 Police Sergeant 14.00 14.00 14.00 - 14.00 Police Trainee - - - - - Program Assistant I 1.00 - - - - Program Assistant II 1.00 1.00 1.00 - 1.00 Program Coordinator - 1.00 - - - Property and Evidence Technician 2.00 2.00 2.00 - 2.00 Public Safety Dispatcher I 2.00 2.00 2.00 - 2.00 Public Safety Dispatcher II 14.00 14.00 14.00 - 14.00 Public Safety Dispatcher - Lead 5.00 5.00 5.00 - 5.00 Safety Officer - - - - - Senior Management Analyst 1.00 1.00 1.00 - 1.00 Superintendent, Animal Services 1.00 1.00 1.00 - 1.00 Supervisor, Animal Services 1.00 1.00 1.00 - 1.00 Supervisor, Police Services 3.00 3.00 3.00 - 3.00 Veterinarian 1.00 1.00 1.00 - 1.00 Veterinarian Technician 2.00 2.00 2.00 - 2.00 Volunteer Coordinator 1.00 0.50 0.50 - 0.50 Total Police Department 164.00 161.50 157.00 (0.50) 156.50 Footnotes: (1) Reallocate 0.5 FTE Community Service Officer to the College Terrace Parking Program Fund 3/8/2011 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Account Representatives 3.00 3.00 3.00 - 3.00 Accountant - 0.75 0.75 - 0.75 Accounting Specialist 1.00 2.50 2.50 - 2.50 Administrative Assistant 1.00 1.00 1.00 - 1.00 Administrative Associate I 2.00 2.00 2.00 - 2.00 Administrative Associate II 7.00 7.00 7.00 - 7.00 Assistant Power Engineer - - - - - Assistant Resource Planner - - - - - Associate Power Engineer - - - - - Associate Resource Planner 1.00 1.00 - - - Assistant Director Customer Support Services 1.00 1.00 1.00 - 1.00 Assistant Director Utilities/Admin Svc - - - - - Assistant Director Utilities/Engineering 1.00 1.00 1.00 - 1.00 Assistant Director Utilities/Operations 1.00 1.00 1.00 - 1.00 Assistant Director Utilities/Res Mgmt 1.00 1.00 1.00 - 1.00 Assistant to City Manager - - 0.35 - 0.35 Business Analyst 2.87 2.87 2.87 - 2.87 Cathodic Technician 1.00 1.00 1.00 - 1.00 Cathodic Protection Technician/Assistant - 1.00 1.00 - 1.00 Cement Finisher 1.00 1.00 1.00 - 1.00 Chief Electric Underground Inspector - - - - - Chief Inspector Water, Gas, Wastewater - - - - - Communications Manager - - 1.00 - 1.00 Contracts Administrator 1.00 1.00 1.00 - 1.00 Coordinator, Utility Safety & Security 1.00 1.00 1.00 - 1.00 Coordinator, Utility Projects (1)4.00 4.00 4.00 1.00 5.00 Customer Service Representative 5.00 5.00 5.00 - 5.00 Customer Service Specialist 2.00 2.00 2.00 - 2.00 Customer Service Specialist - Lead 1.00 2.00 2.00 - 2.00 Deputy Director, Administrative Services 0.20 0.20 0.20 - 0.20 Deputy Fire Chief/Fire Marshal 0.08 0.08 0.08 - 0.08 Director, Administrative Services 0.15 0.15 0.15 - 0.15 Director, Utilities 1.00 1.00 1.00 - 1.00 Electric Project Engineer 1.00 1.00 2.00 - 2.00 Electric Underground Inspector 2.00 2.00 2.00 - 2.00 Electric Underground Inspector Lead 1.00 1.00 1.00 - 1.00 Electrical Assistant I 5.00 5.00 5.00 - 5.00 Electrician 14.00 14.00 14.00 - 14.00 Electrician - Apprentice - - - - - Electrician - Lead 6.00 6.00 6.00 - 6.00 Engineer 4.00 4.00 4.00 - 4.00 Engineering Manager, Electric 1.00 1.00 1.00 - 1.00 Engineering Mgr, Water, Gas, Wastewater 1.00 1.00 1.00 - 1.00 Engineering Technician III 3.00 3.00 3.00 - 3.00 Equipment Operator 2.00 1.00 1.00 1.00 Equipment Operator - Lead - - - - - Field Service Person Water, Gas, Wastewater - - - - - Gas System Technician 2.00 1.00 2.00 - 2.00 3/8/2011 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Gas System Technician II - 1.00 1.00 - 1.00 Hazardous Materials Inspector 0.06 0.06 0.06 - 0.06 Hazardous Materials Specialist 0.03 0.03 - - - Heavy Equipment Operator 10.00 10.00 9.00 - 9.00 Inspector, Field Services 4.00 4.00 4.00 - 4.00 Lineperson/Cable Splicer 11.00 11.00 11.00 - 11.00 Lineperson/Cable Splicer - Apprentice - - - - - 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, Electric Operations 1.00 1.00 1.00 - 1.00 Manager, Energy Risk 1.00 1.00 1.00 - 1.00 Manager, Field and Customer Service 1.00 - - - - Mgr, Customer Svc and Meter Reading - 1.00 1.00 - 1.00 Manager, Utilities Marketing Services 1.00 1.00 1.00 - 1.00 Mgr, Util Operations Water, Gas, Wastewater 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 - - - Offset Equipment Operator - - 0.48 - 0.48 Planner - - 0.30 - 0.30 Power Engineer 2.00 2.00 3.00 - 3.00 Program Assistant I 3.00 3.00 3.00 - 3.00 Project Engineer 6.00 6.00 5.00 - 5.00 Project Manager 0.75 0.75 0.75 - 0.75 Resource Planner 4.00 4.00 5.00 - 5.00 Restoration Lead - 1.00 1.00 - 1.00 Senior Accountant - 0.75 0.75 - 0.75 Senior Business Analyst 1.00 1.00 2.00 - 2.00 Senior Deputy City Attorney - - 1.00 - 1.00 Senior Electrical Engineer 4.00 4.00 4.00 - 4.00 Senior Financial Analyst - 0.60 1.10 - 1.10 Senior Instrument Electrician - - - - - Senior Management Analyst 1.00 1.00 1.00 - 1.00 Senior Market Analyst 1.00 1.00 1.00 - 1.00 Senior Mechanic 1.00 1.00 1.00 - 1.00 Senior Performance Auditor - - 1.00 - 1.00 Senior Project Engineer 4.00 4.00 4.00 - 4.00 Senior Resource Originator 1.00 1.00 - - Senior Resource Planner 6.00 6.00 7.00 - 7.00 Senior Technologist 0.87 0.87 0.87 - 0.87 Senior Utilities Field Services Representative 1.00 1.00 1.00 - 1.00 Senior Utility System Technician - - - - - 3/8/2011 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget ENTERPRISE FUNDS Utilities Department Administration, Electric, Gas, Wastewater Collection and Water Senior Water System Operator 2.00 2.00 2.00 - 2.00 Storekeeper 2.00 2.00 2.00 - 2.00 Supervising Electric Operations & Programs - - - - - Supervising Electric Project Engineer 2.00 2.00 1.00 - 1.00 Supervising Project Engineer - - 1.00 - 1.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 - - - - - Technologist - - - - - Tree Maintenance Specialist 1.00 1.00 1.00 - 1.00 Utilities Accounting Technician - - - - - Utilities Compliance Manager - - 1.00 - 1.00 Utilities Credit/Collection Specialist 1.00 1.00 1.00 - 1.00 Utilities Engineer Estimator 5.00 5.00 5.00 - 5.00 Utilities Engineer Estimator - Lead 1.00 1.00 - - - Utilities Field Service Representative 7.00 5.00 5.00 - 5.00 Utilities Installer/Repairer (1)11.00 11.00 13.00 (1.00) 12.00 Utilities Installer/Repairer Assistant 1.00 1.00 1.00 - 1.00 Utilities Installer/Repairer - Welding 3.00 3.00 3.00 - 3.00 Utilities Installer/Repairer - Lead 5.00 5.00 5.00 - 5.00 Utilities Installer/Repairer - Lead Welding 2.00 2.00 2.00 - 2.00 Utilities Key Account Representative 3.00 3.00 3.00 - 3.00 Utilities Locator 3.00 3.00 3.00 - 3.00 Utilities Rate Analyst - - - - - Utilities Supervisor 5.00 5.00 5.00 - 5.00 Utilities System Operator 5.00 5.00 5.00 - 5.00 Utility Compliance Technician 2.00 2.00 2.00 - 2.00 Utility Compliance Technician - Lead 1.00 1.00 1.00 - 1.00 Utility Market Analyst - - - - - Utility System Technician - - - - - Warehouse Supervisor - - 0.50 - 0.50 Water Meter/Cross Connection Technician 2.00 2.00 3.00 - 3.00 Water Meter Representative Assistant - - - - - Water Meter Repairer - - - - - Water System Operator I - - - - - Water System Operator II 5.00 4.00 4.00 - 4.00 Total Utilities 238.01 241.61 250.71 0.00 250.71 Footnotes: (1) Drop 1.0 FTE Utility Installer/Repairer and add Coordinator Utility Projects 3/8/2011 Exhibit C FY 2011 Table of Organization FY 2009 Adjusted Budget FY 2010 Adjusted Budget FY 2011 Adopted Budget FY 2011 Mid-Year Budget Change FY 2011 Adjusted Budget Special Revenue Accounting Specialist - - 0.50 - 0.50 Administrative Associate II 0.20 0.20 0.20 - 0.20 CDBG Coordinator - - - - - Community Service Officer (1)- - - 0.50 0.50 Planner 1.00 0.95 0.95 - 0.95 Total Special Revenue 1.20 1.15 1.65 0.50 2.15 Footnotes: (1) Reallocate 0.5 FTE Community Service Officer from the General Fund 3/8/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category AC-02024 Children's Theatre Light & Sound Systems Upgrade Buildings and Facilities $4,978 AC-09001 Children's Theatre Replacement and Expansion Buildings and Facilities AC-09002 Community Theatre Sound System Replacement Buildings and Facilities CA-01014 Community Services Facilities Lighting Enhancements Buildings and Facilities 37,474 $30,760 $3,663 CC-09001 Dimmer Replacement and Lighting System Buildings and Facilities $995 $1,015 CC-10000 Replacement of Cubberley Gym B Bleachers Buildings and Facilities 6,739 29,495 CC-11000 Cubberley Gym Activity Room Buildings and Facilities 53,353 General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 Page 1 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 FD-08001 Fire Station #6 Improvements Buildings and Facilities 8,061 29,252 OS-07003 Foothills Park Maintenance Building Rehabilitation Buildings and Facilities 56,535 30,442 249,933 PE-03004 Roth Building Wings Demolition Buildings and Facilities 86,745 PE-04010 Children's Library Improvements & Expansion Buildings and Facilities 2,369,589 813,189 58,561 PE-04011 Cambridge Parking Structure Improvements Buildings and Facilities 59,105 287,034 PE-04012 Mitchell Park Library & Community Center Improvements Buildings and Facilities 15,018 1,162,429 179,071 123 PE-04014 Animal Shelter Expansion & Renovation Buildings and Facilities 96,231 144,610 762,057 61,539 Page 2 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-05002 Main Library Space Reconfiguration Buildings and Facilities 433,031 34,838 PE-05010 College Terrace Library Improvements Buildings and Facilities 39,277 273,077 337,154 1,545,763 635,779 PE-06001 San Antonio Bridge Structural Repairs & Maintenance Buildings and Facilities 2,702 2,338 494 82,782 PE-08005 Municipal Service Center Resurfacing Buildings and Facilities 11,323 752,021 326,898 PE-09003 City Facility Parking Lot Maintenance Buildings and Facilities PE-09005 Downtown Library Improvements Buildings and Facilities 78,162 562,707 814,523 PE-09006 Mitchell Park Library & Community Center (New Construction) Buildings and Facilities 509,024 3,278,486 3,533,868 Page 3 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-09010 Library & Community Center Temporary Facilities Buildings and Facilities 28,866 518,623 76,401 PE-10002 Ventura Community Center and Park Buildings and Facilities 13,283 PE-11000 Main Library New Construction and Improvements Buildings and Facilities 307,886 PE-89004 Yacht Harbor Improvements Buildings and Facilities 11,949 7,080 21,584 PE-98020 Public Safety Building Buildings and Facilities 623,270 1,093,208 1,000,414 175,289 28,882 PE-99006 MSC Feasibility Study Buildings and Facilities 542 PF-00006 Roofing Replacement Buildings and Facilities 76,769 256,831 21,073 251,344 25,029 Page 4 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PF-00020 Office Space Renovation and Reallocation Buildings and Facilities 19,647 PF-01002 Civic Center Infrastructure Improvements Buildings and Facilities 438,192 106,643 4,915,782 1,344,006 1,338,869 PF-01003 Building Systems Improvements Buildings and Facilities 64,312 34,304 114,152 36,098 55,558 PF-01004 Fire Station Improvements Buildings and Facilities 50,514 232,168 575,700 237,018 394 PF-01005 Lucie Stern Community Center Improvements Buildings and Facilities 1,010 980 PF-02022 Facility Interior Finishes Buildings and Facilities 10,579 65,797 47,116 11,076 560 PF-04000 Security System Improvements Buildings and Facilities 618 5,983 8,903 Page 5 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PF-04001 General Building Study Buildings and Facilities 4,825 170,312 PF-04010 Cubberley Mechanical & Electrical Upgrades Buildings and Facilities 960,596 165,456 5,218 9,369 PF-05002 Municipal Service Center Renovation Buildings and Facilities 115,025 18,316 12,057 3,530 8,243 PF-05003 Foothills Park Interpretive Center Improvements Buildings and Facilities 82,626 1,290 3,154 PF-06001 Ted Thompson Garage Improvements Buildings and Facilities PF-06002 Ventura Buildings' Improvements Buildings and Facilities PF-06003 Cubberley Community Center Fire Alarm System Buildings and Facilities 25,054 648,988 70,949 Page 6 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PF-06004 Cubberley Restroom Renovation Buildings and Facilities 895 PF-07000 Art Center Electrical & Mechanical Upgrades Buildings and Facilities 52,063 132,737 234,143 42,560 PF-07001 ADA Compliance - Cubberley Community Center Buildings and Facilities 37,815 13,512 205,388 PF-07003 Children's Theatre Fire/Life Safety Upgrade Buildings and Facilities 247 32,980 7,592 2,205 PF-07011 Roth Building Maintenance Buildings and Facilities 141,046 17,909 1,931 3,729 PF-08000 Art Center Kiln Hood Replacement Buildings and Facilities 10,076 60,654 14,570 PF-09000 Children's Theatre Improvements Buildings and Facilities Page 7 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PF-09002 Lucie Stern Community Center and Theatre Exterior Paint Buildings and Facilities 4,510 105,808 PF-10000 Civic Center Chiller Drive Replacement Buildings and Facilities 72,380 PF-10001 Rinconada Pool Plaster Buildings and Facilities 117,756 PF-10002 Lot "J" Cowper/Webster Structural Repairs Buildings and Facilities 23,682 596 PF-93009 ADA Compliance Buildings and Facilities 96,587 49,955 121,617 235,410 2,150 Total Buildings and Facilities $5,924,093 $5,796,904 $10,081,911 $9,311,891 $7,179,257 Page 8 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 AC-86017 Art in Public Places Land and Land Improvements $29,545 $64,410 $21,556 $17,256 $36,531 AS-08000 Acquisition of Los Altos Treatment Plant Land and Land Improvements 2,590,061 2,306,958 2,252,250 AS-09000 City of Palo Alto Municipal Airport Transition Project Land and Land Improvements 39,075 67,775 4,050 PE-09004 Los Altos Treatment Plant Master Plan Study Land and Land Improvements 135,905 15,468 Total Land and Land Improvements $29,545 $2,654,471 $2,503,494 $2,352,749 $40,581 Page 9 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 AS-10001 Sustainability Contingency Miscellaneous FD-09001 Fire Apparatus Equipment Replacement Miscellaneous $48,352 $261,283 FD-09002 Jaws of Life Hurst Tool Replacement Miscellaneous 60,905 LB-11000 Furniture & Technology for Measure N Project Miscellaneous LB-94018 Library Automation Service Miscellaneous $5,026 732 PD-04010 Fire Portable Radio Replacement Miscellaneous $1,695 112,526 PD-05010 Police Vehicle - Mounted Video Recording Miscellaneous 194,462 Page 10 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PD-07001 SWAT Van Replacement Miscellaneous 203,193 PD-08000 Crime Scene Evidence Collection Vehicle Miscellaneous PD-93012 Fire Communications Computer Systems Miscellaneous 2,705 6,812 PD-99013 Police Records Management System Miscellaneous 31,307 PE-95030 Downtown Parking Structure Industrial Cost Pool Miscellaneous 405,213 91,576 155 PL-02023 Master Schematic Design Miscellaneous 8,270 2,090 PO-10002 Downtown Tree Grates Miscellaneous 29,879 Total Miscellaneous $612,345 $452,530 $110,144 $291,162 $0 Page 11 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 FD-05000 Sixteen (16) ALS Monitors Non-Infrastructure Management Plan $214,734 $62,650 $434 PD-07000 Mobile Command Vehicle Non-Infrastructure Management Plan 695,337 PE-05001 Photovoltaic Design and Installations Non-Infrastructure Management Plan $578,740 2,184,597 325,978 $6,448 PE-07011 Library Service Model Analysis Non-Infrastructure Management Plan 266,912 1,478 PG-08001 Golf Course Driving Range Turf & Netting Non-Infrastructure Management Plan 511,921 PL-05002 Charleston/Arastradero Corridor Plan Non-Infrastructure Management Plan 529,889 32,076 50,094 Page 12 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PL-06001 Adobe Creek Bicycle Bridge Replacement Non-Infrastructure Management Plan 4,184 PL-06002 Comprehensive Parking Signage Plan Non-Infrastructure Management Plan 4,000 43,470 PL-06005 Installation of Ticket Machines Non-Infrastructure Management Plan 7,416 33,994 2,250 Total Non-Infrastructure Management Plan $1,386,957 $2,977,322 $440,010 $6,448 $745,865 AC-10000 Junior Museum & Zoo New Bobcat Habitat Parks and Open Space $101,790 $23,210 OS-00001 Open Space Trails and Amenities Parks and Open Space $184,333 $257,594 $123,193 97,766 26,946 Page 13 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 OS-00002 Open Space Lakes & Ponds Maintenance Parks and Open Space 42,399 41,462 35,909 63,263 6,940 OS-00003 Bayland Parking and Site Improvements Parks and Open Space 83,605 OS-07000 Foothills Park Road Improvements Parks and Open Space 225,000 25,000 OS-07002 Foothills Park Interpretive Center & Open Space Maintenance Yard Parking Parks and Open Space 26,120 258,253 2,302 OS-09001 Off-Road Pathway Resurfacing and Repair Parks and Open Space 25,463 24,719 OS-09002 Baylands Emergency Access Levee Repair Parks and Open Space PE-00101 Foothills Park - Vista Hill Parks and Open Space 18,720 Page 14 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-00107 Briones Park Improvements Parks and Open Space 760 PE-00110 College Terrace Park Improvements Parks and Open Space 32,914 97,998 154,927 522 PE-05300 Arastradero Preserve Gateway Parks and Open Space 89,118 1,519 9,156 PE-06004 Bowden Park Improvements Parks and Open Space 161,395 876 PE-06005 University Avenue Gateway Landscaping Improvements Parks and Open Space 16,624 27,324 166,612 6,709 PE-06007 Park Restroom Installation Parks and Open Space 13,042 41,134 100,096 41,654 PE-06008 Johnson Park Improvements Parks and Open Space 73,681 8,648 Page 15 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-07002 Hoover Park Improvements Parks and Open Space 20,020 696,240 67,053 PE-07003 Ramos Park Improvements Parks and Open Space 37,554 458,628 PE-07005 California Avenue Improvements Parks and Open Space 64,985 49,900 465,324 26,671 PE-07006 Boulware Park Improvements Parks and Open Space 25,520 298,717 3,799 PE-07007 Cubberley Turf Renovation Parks and Open Space 190,950 969,963 PE-07009 Baylands Athletic Center Fencing, Dugout & Trailhead Parking Parks and Open Space 241,891 46,164 PE-08002 Peers Park Improvements Parks and Open Space 250,622 301,383 Page 16 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-08004 Lytton Plaza Renovation Parks and Open Space 23,530 725,733 2,545 PE-09002 Greer Park Phase IV Parks and Open Space 1,134 168,231 515,091 813,609 PE-98003 Mitchell Park Facilities Parks and Open Space 214,148 196,655 24,962 PG-00010 Park Facilities Improvements Parks and Open Space 1,361 PG-04010 Stanford/Palo Alto Community Playing Field Parks and Open Space 843,591 2,050 869 PG-06001 Tennis and Basketball Court Resurfacing Parks and Open Space 130,069 46,881 107,117 100,159 57,210 PG-06003 Benches, Signage, Fencing, Walkways, and Perimeter Landscaping Parks and Open Space 106,156 76,788 85,766 73,480 30,090 Page 17 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PG-07000 Heritage Park Playground Parks and Open Space 243,546 PG-07700 Golf Course Irrigation Pump, Motors & Control Panel Replacement Parks and Open Space 63,315 PG-09002 Park and Open Space Emergency Repairs Parks and Open Space 73,190 50,883 77,700 PG-09003 Park Maintenance Shop Remodel Parks and Open Space 402 2,858 36,123 PG-11001 Cogswell Plaza Improvements Parks and Open Space PG-11002 Monroe Park Improvements Parks and Open Space Page 18 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PG-98001 School Site Irrigation Parks and Open Space 154 57,268 4,596 161,399 Total Parks and Open Space $2,106,881 $3,630,436 $1,732,969 $3,459,755 $1,142,698 PE-00103 Lucie Evans Center parking Lot Improvements Streets and Sidewalks $217 PE-00104 San Antonio Road Median Improvements Streets and Sidewalks 146,212 $153,112 $743,106 $239,404 $78,819 PE-00105 Embarcadero Road Median Improvements Streets and Sidewalks 178 1,191 PE-01013 El Camino Median Landscape Streets and Sidewalks 53,826 73,655 4,525 Page 19 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PE-01021 Homer Avenue Undercrossing Streets and Sidewalks 125,963 PE-06006 Alma Street Landscape Improvements Streets and Sidewalks 17,992 16,576 40,901 26,371 PE-10006 Bridge Rail, Abutment, and Deck Repair Streets and Sidewalks 167,062 PE-11011 Highway 101 Pedestrian / Bicycle Overcrossing Streets and Sidewalks 36,385 71,377 PE-86070 Street Improvements (Street Improvement Fund) Streets and Sidewalks 4,987,364 3,368,496 3,702,381 3,658,566 2,687,557 PL-00026 Safe Routes to School Streets and Sidewalks 4,472 105,802 30,000 20,750 PL-02005 El Camino Real/ Ventura Avenue Traffic Signal Streets and Sidewalks 110,000 Page 20 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PL-04010 Bicycle Transportation Plan Implementation Project Streets and Sidewalks 5,480 44,483 30,000 3,378 PL-05003 College Terrace Traffic Calming Streets and Sidewalks 125,372 17,088 545 PL-05030 Traffic Signal Upgrades Streets and Sidewalks 30,524 35,908 39,983 279,590 35,624 PL-07002 El Camino Real/ Stanford Intersection Streets and Sidewalks 2,490 4,790 31,984 PL-11001 Dinah SummerHill Pedestrian/Bicycle Path Streets and Sidewalks PL-98013 School Commute Safety Improvements (SIF) Streets and Sidewalks 2,490 PL-99023 Page Mill/Hanover Streets and Sidewalks 200 Page 21 of 22 2/17/2011 Attachment 2 FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Project Project Project Expenditures Expenditures Expenditures Expenditures Expenditures Number Title Category General Fund Capital Improvement Program Project Expenditures for Fiscal Years 2007-2011 PO-05054 Street lights Improvements Streets and Sidewalks 19,077 11,814 15,970 40,430 96,676 PO-11000 Sign Reflectivity Upgrade Streets and Sidewalks PO-11001 Thermoplastic Lane Marking and Striping Streets and Sidewalks 23,139 PO-89003 Sidewalk Improvements Streets and Sidewalks 2,299,543 2,030,796 1,675,527 1,341,916 510,886 Total Streets and Sidewalks $7,926,420 $5,858,921 $6,227,373 $5,855,059 $3,560,190 Page 22 of 22 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments AS-09000 City of Palo Alto Municipal Airport Transition Project Land and Land Improvements $130,000 $23,150 $4,050 $0 $0 $5,885 $13,215 90% Design Mar 11 This CIP will be moved to the Airport Fund once these funds have been used. AS-08000 Acquisition of Los Altos Treatment Plant Land and Land Improvements $7,223,394 $74,124 $0 $0 $0 $0 $74,124 100% Complete Remaining balance to be returned to Infrastructure Reserve. AS-10001 Sustainability Contingency Miscellaneous $400,000 $400,000 $0 $0 $0 $0 $400,000 0% Pre-Design TBD No projects have been identified to date that require contingency funds. The funds are available for capital projects where additional funds would allow the effort to be completed in a more sustainable fashion. Of the $400,000 remaining balance, $300,000 will be returned to Infrastructure Reserve. 2/17/2011 Main Body Font Size = 12 MULTI-YEAR PROJECTS FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND ADMINISTRATIVE SERVICES DEPARTMENT MINOR PROJECTS Page 1 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments AC-09001 Children's Theatre Replacement and Expansion Buildings and Facilities $100,000 $100,000 $0 $0 $0 $0 $100,000 0% Pre-Design Dec 11 Staff in initial planning and development of scope of contract. AC-09002 Community Theater Sound System Replacement Buildings and Facilities $200,000 $200,000 $0 $0 $0 $0 $200,000 0% Pre-Design Dec 11 Staff in initial planning and development of scope of contract. AC-10000 Junior Museum & Zoo New Bobcat Habitat Parks and Open Space $575,000 $473,210 $23,210 $0 $0 $0 $450,000 100% Complete Project is complete but cannot be officially closed until Building Inspector signs off on occupancy permit. No more expenditures are anticipated, and remaining balance will be returned to Infrastructure Reserve. CC-09001 Dimmer Replacement and Lighting System Buildings and Facilities $145,995 $145,000 $1,015 $0 $0 $10,600 $133,385 9% Design Jun 11 Scope of contract being developed, after which project will be out for Bid. CC-10000 Replacement of Cubberley Gym B Bleachers Buildings and Facilities $56,350 $49,611 $29,495 $0 $0 $0 $20,116 100% Complete Project completed and to be closed. Remaining balance to be returned to Infrastructure Reserve. CC-11000 Cubberley Gym Activity Room Buildings and Facilities $65,000 $65,000 $53,353 $0 $0 $0 $11,647 100% Complete Project completed and to be closed. Remaining balance to be returned to Infrastructure Reserve. PG-09003 Park Maintenance Shop Remodel Parks and Open Space $153,234 $149,974 $36,123 $0 $0 $20,642 $93,209 39% Design Dec 11 Since there is common shared space, this project will now be designed and constructed in- house by Public Works Facilities Management in conjunction with the Tree Division. PG-11001 Cogswell Plaza Improvements Parks and Open Space $150,000 $150,000 $0 $0 $0 $0 $150,000 0% Pre-Design TBD Staff in initial planning and development of scope of contract. PG-11002 Monroe Park Improvements Parks and Open Space $250,000 $250,000 $0 $0 $0 $0 $250,000 0% Pre-Design TBD Staff in initial planning and development of scope of contract. COMMUNITY SERVICES DEPARTMENT GENERAL FUND FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS MINOR PROJECTS Page 2 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments COMMUNITY SERVICES DEPARTMENT GENERAL FUND FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS OS-09002 Baylands Emergency Access Levee Repair Parks and Open Space $175,000 $175,000 $0 $0 $0 $0 $175,000 0% Pre-Design Jun 11 Survey work for levee done by Public Works Engineering. Tentative construction in 2012 in conjunction with JPA project. OS-00001 Open Space Trails & Amenities Parks and Open Space $1,862,343 $217,110 $26,946 $0 $0 $1,012 $189,152 90% Ongoing Various trail improvements at Arastradero, Foothills Park, and Baylands. Request for Bids currently out for three-year contract for trails. OS-00002 Open Space Lakes & Ponds Maintenance Parks and Open Space $364,471 $12,079 $6,940 $0 $0 $26,251 (21,112)$ 106% Ongoing Year three of three complete in Oct 10. Request for Bids for next three-year contract will be conducted Jul 11. Excess expenditures resulting in negative remaining balance will be transferred to OS-00001 Open Space Trails and Amenities. OS-07000 Foothills Park Road Improvements Parks and Open Space $375,000 $125,000 $0 $0 $0 $0 $125,000 67% Ongoing Phase 1 of road resurfacing from entrance to Foothills Interpretive Center completed. OS-09001 Off-Road Pathway Resurfacing and Repair Parks and Open Space $180,668 $130,486 $0 $0 $0 $0 $130,486 28% Ongoing Staff in initial planning and development of scope of contract. PG-06001 Tennis & Basketball Court Resurfacing Parks and Open Space $469,367 $76,375 $57,210 $0 $0 $0 $19,165 96% Ongoing Rinconada courts 1-6 completed. Request for Bids for Hopkins courts 1-3 and Terman Park tennis courts. PG-06003 Benches, Signage, Fencing, Walkways, and Perimeter Landscaping Parks and Open Space $498,544 $156,354 $30,090 $0 $0 $747 $125,517 75% Ongoing Projects completed in FY 2010: Site Amenities: Benches at Mitchell Park. Refinished benches/softball benches at Greer Park. Replacement bike rack at Greer Park. Signage: Hopkins Creekside Park, El Palo Alto Park. MULTI-YEAR PROJECTS Page 3 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments COMMUNITY SERVICES DEPARTMENT GENERAL FUND FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS PG-09002 Park and Open Space Emergency Repairs Parks and Open Space $225,000 $100,927 $77,700 $0 $0 $13,408 $9,819 96% Ongoing Projects completed in FY 2011: Hoover Park fire damage repairs: demolition, new play structure, new surfacing, age appropriate signs, playground safety inspection. Eleanor Park trees: Landscape design. Mitchell Park: playground equipment replacement. Heritage Park: Playground safety inspection. Johnson Park: Tire swing removal and reinstallation. Foothills Park: Irrigation system check. PG-98001 School Site Irrigation Parks and Open Space $960,137 $2,788 $0 $0 $0 $1 $2,787 100% Complete Agreement with PAUSD (Palo Alto Unified School District) has changed where City is no longer in a cost share for School Site Irrigation CIP PG- 98001. MULTI-YEAR PROJECTS Page 4 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FD-08001 Fire Station #6 Improvements Buildings and Facilities $60,000 $51,939 $29,252 $0 $0 $2 $22,685 62% Ongoing Mar 11 All construction work, painting and refinishing work has been completed. In process of replacing broken vertical window blinds. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND FIRE DEPARTMENT MINOR PROJECTS Page 5 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments LB-11000 Furniture & Technology for Library Measure N Project Miscellaneous $275,000 $275,000 $0 $0 $0 $0 $275,000 0% Ongoing Dec 13 Council approved this project in Dec 10. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND LIBRARY SERVICES DEPARTMENT MULTI-YEAR PROJECTS Page 6 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments PL-05002 Charleston/ Arastradero Corridor Plan Non- Infrastructure Management Plan $1,209,545 $428,761 $50,094 $0 $0 $80,571 $298,096 95% Construction Dec 10 Installation of Arastradero Road Trial Project Improvements between El Camino Real and Gunn High School was completed in Sep 10. Active improvements include traffic signal modification at Coulombe Drive, installation of enhanced pedestrian crosswalk at Clemo Drive, installation of speed signs at Hubbart Street, and a minor restriping correction near Alta Mesa-McKellar Lane. Staff is monitoring these improvements through the remainder of the trial project in the Summer 2011. PL-05003 College Terrace Traffic Calming Streets and Sidewalks $217,484 $74,055 $0 $0 $0 $1 $74,054 95% Construction Jun 11 A second phase traffic calming project on and along College Avenue, including median island chokers and traffic circles at Yale Street, have received positive support from the community. The City is currently soliciting a survey to determine whether the community wants to permanently retain these improvements. Traffic data shows a successful traffic calming project. PL-06001 Adobe Creek Bicycle Bridge Replacement Non- Infrastructure Management Plan $50,000 $45,816 $0 $0 $0 $0 $45,816 100% Complete City of Los Altos is lead agency for this inter-jurisdictional project. Construction was completed in summer 2009. City awaiting final accounting and invoicing from Los Altos for City's local match. PL-06005 Installation of Ticket Machines Non- Infrastructure Management Plan $94,900 $38,578 $0 $0 $0 $0 $38,578 100% Design Aug 11 Installation of the initial ticket machines is complete and revenues from the machine show active use by the community. Additional ticket machines were requested by the Chamber and will be installed in Summer 2011. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PLANNING AND COMMUNITY ENVIRONMENT DEPARTMENT MINOR PROJECTS Page 7 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PLANNING AND COMMUNITY ENVIRONMENT DEPARTMENT PL-07002 El Camino Real/ Stanford Intersection Streets and Sidewalks $1,800,030 $1,810,720 $31,984 $0 $0 $676 $1,778,060 1% Construction Aug 11 Design of this project is complete and a construction contract has been awarded. Construction will begin in the Spring 2011 and continue into the Summer. PL-11001 Dinah SummerHill Pedestrian Bicycle Path Streets and Sidewalks $300,000 $300,000 $0 $0 $0 $0 $300,000 0% Design Mar 12 This project is funded by the Summerhill Homes project and the City is responsible for the design and construction of a trail path to connect Wilkie Way with their development. Design will begin in the Spring 2011. PL-00026 Local and Neighborhood Collector Street Traffic Calming Program (SIF) Streets and Sidewalks $870,000 $351,502 $20,750 $0 $0 $0 $330,752 62% Ongoing This CIP will be closed at the end of the FY and funds transferred to a new CIP entitled Safe Routes to School that is partially grant-funded. PL-04010 Bicycle Boulevards Implementation Project Streets and Sidewalks $289,497 $201,014 $3,378 $0 $0 $20,159 $177,477 39% Ongoing This ongoing CIP implements project recommendations from the City's Bike Transportation Plan. Active projects include an update of the Bike Transportation Plan and include a new Pedestrian section. Other active projects include bike rack deployments, bike route signage deployment, and the design of bike boulevard facilities along Maybell and Park Boulevards. PL-06002 Comprehensive Parking Signage Plan Non- Infrastructure Management Plan $475,000 $427,530 $0 $0 $0 $0 $427,530 100% Ongoing The installation of color zone signage was completed in 2008. Current projects include hiring of a new Parking Manager to identify parking improvement strategies. At the end of FY 2011, the CIP will be closed and remaining funds transferred to a new CIP entitled Transportation and Parking Improvements. PL-98013 School Commute Safety Improvements (SIF) Streets and Sidewalks $150,000 $108,659 $0 $0 $0 $0 $108,659 100% Complete Dec 10 This CIP will be closed at the end of the FY and funds transferred to a new CIP entitled Safe Routes to School that is partially grant-funded. MINOR PROJECTS MULTI-YEAR PROJECTS Page 8 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments PD-07000 Mobile Command Vehicle Miscellaneous $700,000 $700,000 $695,337 $0 $0 $2 $4,661 99% Construction Jun 11 Vehicle construction completed and vehicle is now in service. Minor technology installations remain. PD-08000 Crime Scene Evidence Collection Vehicle Miscellaneous $180,000 $180,000 $0 $0 $0 $171,419 $8,581 95% Construction Jun 11 Vehicle has been ordered with expected delivery in June. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND POLICE DEPARTMENT MINOR PROJECTS Page 9 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments PE-00110 College Terrace Park Improvements Parks and Open Space $394,707 $5,341 $0 $0 $0 $0 $5,341 100% Complete Keep balance in the project until the warranty period ends in Fall of 2011 PE-06001 San Antonio Bridge Structural Repairs & Maintenance Buildings and Facilities $96,962 $91,429 $82,782 $0 $0 $0 $8,647 100% Complete Remaining balance to be returned to infrastructure reserve. PE-06005 University Avenue Gateway Landscaping Improvements Parks and Open Space $239,001 $4,212 $0 $0 $0 $1 $4,211 100% Complete Remaining balance to be returned to infrastructure reserve. PE-07005 California Avenue Improvements Parks and Open Space $803,477 $223,267 $25,259 $0 $1,412 $53,420 $143,176 82% Design Jun 11 Phase I: Tree replanting plan completed. Phase II: Planning is the lead division in the designing phase. PE-08004 Lytton Plaza Renovation Parks and Open Space $793,142 $43,879 $2,545 $0 $0 $25,606 $15,728 98% Complete Jul 11 CSD is still working with the Friends of Lytton Plaza on open items. PE-08005 Municipal Service Center Resurfacing Buildings and Facilities $1,658,003 $567,762 $0 $0 $0 $2 $567,760 100% Complete Project completed. Return funding to Infrastructure Reserve and Utilities. PE-09002 Greer Park Phase IV Parks and Open Space $1,966,114 $1,281,657 $813,609 $0 $0 $224,907 $243,141 88% Construction Jun 11 Pump and irrigation are underway. PE-09004 Los Altos Treatment Plant Master Plan Study Land and Land $175,750 $24,377 $0 $0 $0 $24,377 $0 100% Design TBD Consultant under contract. Preliminary design in progress. PE-10002 Ventura Community Center and Park Buildings and Facilities $346,913 $333,630 $0 $0 $0 $0 $333,630 4% Pre-Design TBD Project is in the pre-design phase. PE-10006 Bridge Rail, Abutment, and Deck Repair Streets and Sidewalks $320,132 $153,070 $0 $0 $0 $0 $153,070 52% Construction TBD Bridge guardrail has been completed by Public Works Operations. PE-11011 Highway 101 Pedestrian/Bicycle Overcrossing Streets and Sidewalks $412,366 $375,981 $71,377 $0 $0 $68,057 $236,547 43% Pre-Design May 11 Staff is meeting with Boards and Commissions and Community to gather feedback. FY 2011 YEAR-END CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT MINOR PROJECTS Page 10 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FY 2011 YEAR-END CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT PF-04000 Security System Improvements Buildings and Facilities $275,000 $63,349 $0 $0 $0 $1 $63,348 77% Construction Jun 11 Work will be completed in FY 2011 pending staff resources. PF-06001 Ted Thompson Garage Improvements Buildings and Facilities $67,000 $67,000 $0 $0 $0 $0 $67,000 0% Pre-Design Jun 11 Work to be completed in FY 2011. PF-06004 Cubberley Restroom Renovation Buildings and Facilities $300,000 $300,000 $895 $0 $0 $0 $299,105 0% Pre-Design Dec 11 Preliminary design in progress. PF-07003 Children's Theatre Fire/Life Safety Upgrade Buildings and Facilities $273,648 $232,830 $2,205 $0 $0 $0 $230,625 16% Design Dec 11 Project will be completed in FY 2012. PF-07011 Roth Building Maintenance Buildings and Facilities $424,395 $259,781 $0 $0 $0 $0 $259,781 39% Ongoing All initial work completed. Ongoing work to include roof and window repair to maintain integrity of structure. PF-09002 Lucie Stern Community Center and Theatre Exterior Paint Buildings and Facilities $84,510 $80,000 $76,550 $0 $3,450 $0 $0 100% Complete PF-10000 Civic Center Chiller Drive Replacement Buildings and Facilities $127,423 $55,043 $0 $0 $0 $0 $55,043 100% Complete Remaining balance to be returned to Infrastructure Reserve. PF-10001 Rinconada Pool Plaster Buildings and Facilities $206,126 $88,370 $0 $0 $0 $0 $88,370 100% Complete Remaining balance to be returned to Infrastructure Reserve. PF-10002 Lot "J" Cowper/Webster Structural Repairs Buildings and Facilities $81,182 $57,500 $596 $0 $0 $57,500 ($596)60% Design Dec 11 Consultant under contract. Preliminary design in progress. Negative balance is attributable to salaries and will be taken care of at fiscal year end when Budget makes its usual labor allocation adjustment. PO-10002 Downtown Tree Grates Miscellaneous $300,000 $270,121 $0 $0 $0 $8,136 $261,985 13% Construction Dec 15 Project is being done in conjunction with PO-89003 and tree replacement schedule. MINOR PROJECTS Page 11 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FY 2011 YEAR-END CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT PE-00104 San Antonio Road Median Improvements Streets and Sidewalks $1,991,854 $669,794 $78,819 $0 $0 $13,511 $577,464 71% Design Sep 11 Phase II: Tree removal/replacement, landscaping improvements, contaminated soil removal, street lights conduit replacement. Page 12 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FY 2011 YEAR-END CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT PE-04014 Animal Shelter Expansion & Renovation Buildings and Facilities $1,662,470 $20,640 $0 $0 $0 $1 $20,639 100% Complete Remaining balance to be returned to Infrastructure Reserve. PE-05010 College Terrace Library Improvements Buildings and Facilities $3,654,602 $1,447,253 $542,929 $0 $92,850 $358,827 $452,647 88% Construction May 11 Construction began FY 2010. PWE staff is still working with Library staff on open items. PE-06006 Alma Street Landscape Improvements Streets and Sidewalks $131,934 $18,841 $0 $0 $0 $1 $18,840 86% Construction Jun 11 Replanting of plants in progress. PE-06007 Park Restroom Installation Parks and Open Space $871,382 $717,111 $41,654 $0 $0 $171,363 $504,094 42% Construction Jun 11 Seal Park Restroom construction will commence in late FY 2011. PE-07007 Cubberley Turf Renovation Parks and Open Space $1,305,377 $144,464 $0 $0 $0 $0 $144,464 89% Construction Mar 11 Final phase of the project is expected to be completed in Mar 11. PE-09003 City Facility Parking Lot Maintenance Buildings and Facilities $330,000 $330,000 $0 $0 $0 $300,000 $30,000 91% Ongoing This is an annual project. Funding will be used for repaving the Cubberley Parking lot. PE-09005 Downtown Library Improvements Buildings and Facilities $5,368,515 $4,727,646 $807,293 $0 $7,230 $2,931,784 $981,339 65% Construction Jul 11 Construction started Apr 10. PE-09006 Mitchell Park Library & Community Center (New Construction) Buildings and Facilities $50,832,619 $47,045,109 $3,495,407 $0 $38,461 $28,448,575 $15,062,666 50% Construction Jul 12 Construction began Jun 10. PE-09010 Library & Community Center Temporary Facilities Buildings and Facilities $1,278,349 $730,861 $51,487 $0 $24,914 $52,569 $601,891 53% Construction Aug 11 After final invoices are received, project should remain open until warranty period is over. PE-11000 Main Library New Construction and Improvements Buildings and Facilities $1,850,000 $1,850,000 $307,886 $0 $0 $1,511,450 $30,664 10% Design Dec 12 Currently in design phase. Construction expected to begin Dec 12. PE-98020 Public Safety Building Buildings and Facilities $4,287,492 $428,267 $28,882 $0 $0 $2 $399,383 91% Design TBD Project currently on hold. MULTI-YEAR PROJECTS Page 13 of 31 2/17/2011 Attachment 3 Total Budget FY 2011 FY 2011 FY 2011 FY 2011 FY 2011 Estimated Project Project Project From Available Expenditures Labor Contingencies Encumbrances Remaining Percent Project Completion Number Title Category Inception Budget Adjustments Balance Complete Status Date Comments FY 2011 YEAR-END CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS GENERAL FUND PUBLIC WORKS DEPARTMENT PF-01002 Civic Center Infrastructure Improvements Buildings and Facilities $17,305,563 $7,997,902 $1,338,869 $0 $0 $3,753,358 $2,905,675 83% Construction Jun 11 Phase I of the major renovations completed in Aug 09. Phase II construction to be completed in Jun 11. PF-01004 Fire Station Improvements Buildings and Facilities $2,580,317 $46,308 $394 $0 $0 $1 $45,913 100% Complete Remaining balance to be returned to infrastructure reserve. PF-04010 Cubberley Mechanical & Electrical Upgrades Buildings and Facilities $1,614,695 $36,562 $0 $0 $0 $0 $36,562 98% Design TBD Project on hold due to staff vacancy and lack of capital funds. Construction phase to be rescheduled for a later fiscal year. PF-05002 Municipal Service Center Renovation Buildings and Facilities $864,838 $685,514 $8,243 $0 $0 $0 $677,271 22% Design Dec 11 Consultant has been selected for the design phase and contract is waiting for Council approval. PF-05003 Foothills Park Interpretive Center Improvements Buildings and Facilities $330,781 $210,000 $3,154 $0 $0 $0 $206,846 37% Construction Nov 11 Roof replacement contract to be bid and awarded in Jan 11. Design for electrical improvements has begun. PF-06002 Ventura Buildings Improvements Buildings and Facilities $90,000 $90,000 $0 $0 $0 $0 $90,000 0% Pre-Design TBD Developing scope of work. PF-07000 Art Center Electrical & Mechanical Upgrades Buildings and Facilities $4,400,267 $3,981,324 $40,571 $0 $1,989 $171,701 $3,767,063 14% Design Mar 12 Foundation's architect completing construction documents phase. Construction scheduled for FY 2012. PF-09000 Children's Theater Improvements Buildings and Facilities $100,000 $100,000 $0 $0 $0 $0 $100,000 0% Pre-Design TBD Developing scope of work. PO-11000 Sign Reflectivity Upgrade Streets and Sidewalks $100,000 $100,000 $0 $0 $0 $0 $100,000 0% Pre-Design Dec 17 Developing scope of work from notes left by retired personnel. State-mandated deadline is 2018. PO-11001 Thermoplastic Lane Marking & Striping Streets and Sidewalks $300,000 $300,000 $23,139 $0 $0 $165,861 $111,000 63% Ongoing Initial backlog and ongoing maintenance project is being done in conjunction with PE-86070. MULTI-YEAR PROJECTS Page 14 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS TECHNOLOGY FUND Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2010 Expenditures Adjustments Contingencies Encumbrances Balance Complete Status Date Comments TE-01006 Enterprise Backup Solution Minor $139,512 $68,627 $0 $0 $0 $1 $68,626 51% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-01012 IT Disaster Recovery Plan Minor $840,000 $509,711 $0 $0 $0 $1 $509,710 39% Construction Jun 11 A draft disaster recovery plan has been completed. Planning SAP Windows server backup strategy. TE-05003 Internet Site Upgrade Minor $240,000 $42,262 $0 $0 $0 $0 $42,262 82% Construction Jun 11 Implementation of the internet is complete. The portion of the contract dealing with the intranet is 50% complete. TE-06002 9-1-1 Emergency Phone System Upgrade Minor $324,000 $27,274 $0 $0 $0 $0 $27,274 92% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-07002 Police Auto- Citation System Minor $125,000 $67,191 $0 $0 $0 $0 $67,191 46% Pre-design Dec 11 A second RFP will be issued. TE-08000 Library Technology Plan Minor $75,000 $18,766 $0 $0 $0 $0 $18,766 75% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-08003 Fire Radio Communication s Equipment Minor $102,000 $7,179 $0 $0 $0 $0 $7,179 93% Complete Jun 11 Work is being finalized and CIP will be closed. TE-08004 Fire Mobile Data Computer Minor $250,000 $69,294 $95 $0 $0 $1 $69,198 72% Construction May 11 Work is being finalized and CIP will be closed. TE-09000 Public Safety Computer-Aided Dispatch Replacement Minor $1,300,000 $1,300,000 $0 $0 $0 $0 $1,300,000 0% Pre-design Dec 12 Vendor is selected and contract is being negotiated. MINOR PROJECTS INTERNAL SERVICE FUND ADMINISTRATIVE SERVICES DEPARTMENT Page 14 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS TECHNOLOGY FUND Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion INTERNAL SERVICE FUND ADMINISTRATIVE SERVICES DEPARTMENT TE-11002 Police Mobile In- Car Video System Replacement Minor $310,000 $310,000 $0 $0 $0 $0 $310,000 0% Pre-design Jun 11 Currently developing requirements. TE-11003 Recurring Credit Card Payment Minor $150,000 $150,000 $0 $0 $0 $0 $150,000 0% Pre-design Jun 11 Currently developing requirements. TE-95016 Permit Information Tracking System Multi-Year $980,050 $210,376 $22,616 $0 $0 $41,755 $146,005 85% Construction Jun 13 Performed upgrade to application 12/31/10. Next phase will include Accela Customer Access and possibly additional module implementation. TE-02013 Institutional Network (I-Net) Multi-Year $1,000,000 $724,311 $65,570 $0 $0 $99,845 $558,896 44% Construction Jun 12 All major facilities in the City have been connected via fiber optic cable. TE-02016 Enterprise Resource Planning Multi-Year $5,018,476 $102,526 $0 $0 $0 $0 $102,526 98% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-07006 SAP Continuous Improvement Project Multi-Year $7,000,000 $95,694 $6,686 $0 $0 $31,226 $57,782 99% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-99010 Acquisition of New Computers Multi-Year $362,350 $142,599 $0 $0 $0 $0 $142,599 61% Construction Jun 13 This is an ongoing project for the acquisition of new computers. TE-00010 / TE-00021 Telephone System Replacement Multi-Year $1,230,000 $1,213,152 $8,421 $0 $0 $85,916 $1,118,815 9% Pre-design Jun 12 The telecommunications consultant collected inventory information and interviewed representatives of each department. A vendor will be selected to provide Project Management for system selection and implementation. MINOR PROJECTS MULTI-YEAR PROJECTS Page 15 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS TECHNOLOGY FUND Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion INTERNAL SERVICE FUND ADMINISTRATIVE SERVICES DEPARTMENT TE-02015 Citywide GIS Data, Infrastructure and Applications Multi-Year $2,228,954 $615,229 $138,271 $0 $0 $103,094 $373,864 83% Construction May 11 Work is being finalized. TE-05000 Radio Infrastructure Replacement Multi-Year $2,430,980 $1,971,265 $45,749 $0 $0 $1 $1,925,515 21% Pre-design TBD This is a County-wide project. Awaiting project initiation from County. TE-06001 Library Radio Frequency Identification (RFID) Implementation Multi-Year $445,000 $427,414 $0 $0 $0 $400,001 $27,413 94% Construction Jun 13 The intent is to carry this funding over to FY 2012, add funding, and utilize for implementation per the upcoming Library Technology Plan. RFID implementation is being coordinated with the Library Construction/Remodeling Projects. TE-07000 Enterprise Application Infrastructure Upgrade Multi-Year $1,862,000 $755,859 $201,141 $0 $0 $2,126 $552,592 70% Construction 250K of this project is identified as a possible additional funding source for the Telephone System Replacement Project. Remaining dollars to be transferred to Application Maintenance Fund at FY2012 for support contract. TE-07003 Bill and Payment Processing Multi-Year $220,000 $23,450 $23,450 $0 $0 $0 $0 100% Complete Project will be closed. TE-08002 Electric Patient Care Report Multi-Year $65,000 $35,057 $0 $0 $0 $2 $35,055 46% Complete This project is identified as a possible additional funding source for the Telephone System Replacement Project. TE-10000 Collections Software Multi-Year $111,800 $111,800 $0 $0 $0 $100,000 $11,800 89% Pre-design Dec 11 Vendor is selected and contract is being negotiated. TE-10001 Utility Customer Billing System Multi-Year $350,000 $350,000 $0 $0 $0 $0 $350,000 0% Pre-design Jul 12 In planning stage. MULTI-YEAR PROJECTS Page 16 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS TECHNOLOGY FUND Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion INTERNAL SERVICE FUND ADMINISTRATIVE SERVICES DEPARTMENT TE-11004 Utility Bill Information Echancements Multi-Year $750,000 $750,000 $0 $0 $0 $0 $750,000 0% Pre-design Jul 12 In planning stage. TE-11005 Implementation of Restructured Tiered Rates on Bills Multi-Year $100,000 $100,000 $0 $0 $0 $0 $100,000 0% Pre-design Jul 12 In planning stage. MULTI-YEAR PROJECTS Page 17 of 31 2/17/2011 Attachment 3 Total Budget Available FY 2011 Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Adjustments* Contingencies Encumbrances Balance Complete Status Date Comments VR-00001 MSC Fuel Storage Tank Replacement Minor $225,000 $8,586 $0 $0 $0 $0 $8,586 96% Complete Project will be closed and remaining balance will be returned to reserves. VR-01000 MSC Equipment Maintenance Facility Mezzanine Storage Area Minor $275,000 $9,641 $0 $0 $0 $0 $9,641 96% Complete Project will be closed and remaining balance will be returned to reserves. VR-01001 MSC Fuel Storage Tank /Svc Island Replacement Minor $1,616,860 $127,500 $7,235 $0 $0 $39,185 $81,080 95% Construction Apr 11 Liquid and Compressed Natural Gas (CNG) facilities are complete and in service. Public CNG dispenser is complete, but compressor needs repairs, and a new retail CNG rate needs to be developed. VR-01002 MSC Equipment Washing Facility Upgrade Minor $681,394 $0 $0 $0 $0 $0 $0 100% On Hold TBD On hold pending funding. VR-05001 Field Service Truck Minor $125,000 $367 $0 $0 $0 $0 $367 100% Complete Project will be closed and remaining balance will be returned to reserves. VR-06801 Replace City-Wide Fuel Transaction and Inventory Management System Minor $285,000 $148,043 $11,981 $0 $0 $35,658 $100,404 65% Ongoing Apr 11 System has been installed at one site; site preparation in progress at remaining two sites. VR-07001 Automated Motor Pool Reservation and Vehicle Key Management System Minor $125,000 $98,398 $0 $0 $0 $1 $98,397 21% Ongoing Jun 11 System has been implemented at Municipal Service Center (MSC). Second phase will include Civic Center. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS INTERNAL SERVICE FUND VEHICLE REPLACEMENT AND MAINTENANCE FUND PUBLIC WORKS DEPARTMENT MINOR PROJECTS Page 18 of 31 2/17/2011 Attachment 3 Total Budget Available FY 2011 Budget Estimated Project Project Project From Budget FY 2011 Labor FY 2011 FY 2011 Remaining Percent Project Completion FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS INTERNAL SERVICE FUND VEHICLE REPLACEMENT AND MAINTENANCE FUND PUBLIC WORKS DEPARTMENT VR-08001 New Vehicles (2) For Utility Operations Minor $70,000 $24,035 $0 $0 $0 $0 $24,035 100% Complete Project will be closed and remaining balance will be returned to reserves. VR-09000 Vehicle Replacement Minor $2,545,000 $1,410,642 $754,939 $0 $0 $599,834 $55,869 98% Ongoing Jun 11 Awaiting purchase and delivery of several vehicles. VR-11000 Vehicle Replacement Minor $222,205 $222,205 $0 $0 $0 $152,030 $70,175 68% Ongoing Dec 11 Awaiting purchase and delivery of several vehicles. VR-04010 Vehicle Maintenance Facility Upgrades Multi-Year $610,000 $266,393 $3,533 $0 $0 $4 $262,856 57% Ongoing Jun 11 Ongoing, specifications need to be written for next phase of upgrades. VR-07002 Diesel Truck Engine Emissions Retrofits Multi-Year $685,000 $197,147 $42,619 $0 $0 $27,506 $127,022 81% Ongoing Dec 11 Ongoing. Several vehicles remain to be retrofitted. VR-92006 Fuel Tank Storage/Upgrade Multi-Year $341,000 $65,502 $3,953 $24,452 $0 $85,000 $1,001 100% Design Oct 11 Project scope reduced due to inadequate funding. Estimated Bid date Jan 11. MINOR PROJECTS MULTI-YEAR PROJECTS Page 19 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments EL-04010 Foothills System Rebuild Minor $850,050 $102,946 $79 $0 $0 $102,867 88% Pre-design Dec 11 Some preliminary design and scoping work has been done. No additional work at this time due to understaffing. EL-09004 W. Charleston/Wilkie Way to South City Limit 4/12 kV Conversion Minor $505,515 $127,210 $10,475 $0 $0 $116,735 77% Design Aug 11 Scope defined and preliminary design completed. Detailed design in progress. Bid package to be completed by Apr 11, followed by Request For Proposal (RFP). EL-10008 Advanced Metering Infrastructure System Minor $310,243 $307,567 $39,096 $0 $120,457 $148,014 52% Design Nov 11 Task 1: Smart Grid Assessment report by EnerNex Corporation to be completed Feb 11. Presentation to UAC planned for Mar 11, subsequently followed with presentation of recommendations to Council. Task 2: Implementation of recommendations that have been approved by Council will occur after the Council meeting and will involve assistance from EnerNex, already in the signed agreement. EL-11001 Torreya Court Rebuild Minor $100,000 $100,000 $0 $0 $0 $100,000 0% Dec 12 No work started due to staff vacancies. EL-11004 Hewlett Subdivision Rebuild Los Trancos Minor $400,000 $400,000 $0 $0 $0 $400,000 0% Mar 12 No work started due to staff vacancies. EL-11006 Rebuild UG District 18 Minor $350,000 $350,000 $0 $0 $0 $350,000 0% Dec 12 No work started due to staff vacancies. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND MINOR PROJECTS ELECTRIC FUND UTILITIES DEPARTMENT Page 20 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT MULTI-YEAR PROJECTS EL-02010 SCADA System Upgrades Multi-Year $711,144 $81,515 $11,056 $0 $18,554 $51,905 93% Construction Ongoing Purchase requisition to has been forwarded to Purchasing. This project involves upgrading the Supervisory Control & Data Acquisitions (SCADA) Portal and Master computer software and operating systems this year. EL-04012 Utility Site Security Improvements Multi-Year $908,854 $582,084 $60,830 $0 $13,150 $508,104 25% Design Jun 11 Construction completed at Colorado Substation and Boranda Reservoir. Design in progress for Corte Madera Booster/Reservoir, Quarry Booster, and Boronda Booster. EL-04014 Automated Meter Reading System Multi-Year $1,334,099 $296,157 $0 $0 $2 $296,155 78% Complete Pilot is completed, except for ongoing maintenance of installed system. Staff is analyzing installation and will use information during Smart Grid Feasibility Study (EL-10008). EL-05000 El Camino Underground Rebuild Multi-Year $1,609,376 $393,737 $152,039 $0 $2 $241,696 85% Design and Construction Jun 11 Portions of this project have been completed in conjunction with new business in the area of El Camino Real between Charleston and San Antonio roads. Construction Estimate package in progress. EL-11008 Rebuild UG District 19 Multi-Year $560,918 $509,963 $2,497 $0 $0 $507,466 10% Construction Mar 11 Substructure installation completed. Cable design and estimate pending crew availability. EL-06000 Park Blvd. 4/12kV Conversion Multi-Year $385,211 $48,556 $0 $0 $0 $48,556 87% Construction Mar 11 Final stages of construction in progress. Page 21 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT EL-06001 230 KV Electric Intertie Multi-Year $500,000 $134,813 $0 $0 $0 $134,813 73% Engineering feasibility study Ongoing Stanford Utilities has expressed interest in Stanford Linear Accelerator Center (SLAC) - Quarry Road Substation 60kV tie. Preliminary power flow and feasibility study complete. Interconnection at Quarry Substation appears feasible. Working with Stanford and DOE to encourage SLAC participation in this project. Page 22 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT EL-06002 Underground District 45 Multi-Year $3,580,726 $1,456,209 $982,862 $0 $0 $473,347 60% Construction Jan 12 Substructure complete. Line construction begins. EL-06003 Utility Control Center Upgrades Multi-Year $500,000 $53,374 $5,885 $39,500 $0 $7,989 98% Pre-design Ongoing Ergonomic and visual improvements for performance to operator environment. EL-08000 E. Charleston 4/12kV Conversion Multi-Year $651,907 $629,404 $1,505 $0 $0 $627,899 4% Design Jun 11 Preliminary design work started and is expected to be completed by Dec 10. EL-08002 E. Meadow/Alma/Loma 4/12kV Conversion Multi-Year $1,170,449 $991,303 $466,362 $0 $155,294 $369,647 68% Complete Awaiting final invoice to be paid. EL-09000 Middlefield Underground Rebuild Multi-Year $625,613 $75,613 $0 $0 $0 $75,613 88% Design Dec 11 Engineering design completed. Estimating in progress. EL-09002 Middlefield/Colorado 4/12 kV Conversion Multi-Year $170,830 $161,704 $11,321 $0 $0 $150,383 12% Design Jun 11 Engineering complete. Construction to be contracted. Bid package by Mar 11. Then Request for Proposal (RFP) for construction. EL-09003 Rebuild UG District 17 (Downtown) Multi-Year $1,216,153 $933,185 $110,852 $0 $38,861 $783,472 60% Construction Dec 11 Substructure complete. Line construction begins Jun 11. EL-10006 Rebuild UG District 24 Multi-Year $1,340,874 $1,131,403 $76,200 $0 $347,553 $707,650 47% Design Jun 11 Substructure installation complete. Electrical design work in progress. EL-10009 Street Light System Conversion Project Multi-Year $1,366,398 $1,314,128 $7,194 $639,033 $5 $667,896 51% Ongoing Jun 11 Evaluating various LED street light fixtures and developing specification for ordering street light fixtures to use in Palo Alto. MULTI-YEAR PROJECTS Page 23 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND ELECTRIC FUND UTILITIES DEPARTMENT EL-11000 Seale/Waverley 4/12 kV Conversion Multi-Year $40,000 $40,000 $0 $0 $0 $40,000 0% Jun 12 No work started due to staff vacancies. EL-11002 St. Francis/Oregon/Amarillo /Louis 4/12 kV Conversion Multi-Year $50,000 $50,000 $0 $0 $0 $50,000 0% Dec 12 No work started due to staff vacancies. EL-11003 Rebuild UG District 15 Multi-Year $80,000 $80,000 $0 $0 $0 $80,000 0% Dec 11 No work started due to staff vacancies. EL-11005 California Ave. Business District Rebuild (District 22) Multi-Year $2,332,099 $70,299 $0 $0 $0 $70,299 97% Complete Project to be closed and balance returned to reserves. EL-11007 Rebuild Greenhouse Condo Area Multi-Year $150,000 $150,000 $0 $0 $0 $150,000 0% Pre-design Dec 11 Design to start prior to end of fiscal year. Construction to be completed by end of calendar year. EL-11010 UG District 47 - Middlefield, Homer Avenue, Webster Street and Addison Avenue Multi-Year $150,000 $150,000 $3,864 $0 $0 $146,136 3% Design Aug 12 Preliminary design work started . EL-11014 Smart Grid Technology Installation Multi-Year $500,000 $500,000 $0 $0 $0 $500,000 0% Pre-design Jan 17 Pending results of Smart Grid Assessment and approval by Council. EL-11015 Reconductor 60kV Overhead Transmission System with ACCR conductor Multi-Year $450,000 $450,000 $1,473 $0 $0 $448,527 0% Design Jun 11 Engineering and estimating in progress. Project specs and Request for Proposal (RFP) for materials/construction by Mar 11. MULTI-YEAR PROJECTS Page 24 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments GS-03010 CNG Sequential Fuel System Minor $75,000 $35,715 $0 $0 $0 $35,715 52% Complete Project will be closed and balance returned to reserves. GS-08000 Gas Station 2 Rebuild Minor $207,000 $203,584 $0 $0 $1 $203,583 10% Design Oct 11 Repackaging Request for Proposal (RFP) out to Bid Feb 11. Construction to start in FY 2011. GS-09000 Gas Station 1 Rebuild Minor $201,052 $200,485 $0 $0 $0 $200,485 10% Design Oct 11 Repackaging Request for Proposal (RFP) out to Bid Feb 11. Construction to start in FY 2011. GS-10000 Gas Station 3 Rebuild Minor $207,007 $206,931 $0 $0 $0 $206,931 10% Design Oct 11 Repackaging Request for Proposal (RFP) out to Bid Feb 11. Construction to start in FY 2011. GS-10002 General Shop Tooling Minor $64,007 $63,931 $50,736 $0 $0 $13,195 79% Design Mar 11 Equipment purchased and installed. Awaiting final electric power wiring. GS-10003 Cathodic Current Interrupters Minor $300,007 $299,931 $0 $0 $0 $299,931 5% Design Jun 11 Drafting specifications. Out for Bid in Apr 11. GS-10004 Automating Test Station Minor $100,000 $100,000 $0 $0 $0 $100,000 5% Design Jun 11 Drafting specifications. Out for Bid in Apr 11. GS-11001 Gas Station 4 Rebuild Minor $337,000 $337,000 $0 $0 $0 $337,000 10% Design Oct 11 Repackaging Request for Proposal (RFP) out to Bid Feb 11. Construction to start in FY 2011. ENTERPRISE FUND MINOR PROJECTS GAS FUND UTILITIES DEPARTMENT Page 24 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments ENTERPRISE FUND GAS FUND UTILITIES DEPARTMENT GS-00011 Compress Natural Gas Station Multi-Year $440,000 $2,946 $0 $0 $0 $2,946 99% Complete Project will be closed and balance returned to reserves. GS-01019 Global Positioning System Multi-Year $381,000 $118,863 $0 $0 $0 $118,863 69% Construction Jun 11 Integrating field data into mapping system. Defining additional equipment needs. GS-08011 GMR - Project 18 Multi-Year $5,967,660 $4,975,097 $65,664 $0 $63,288 $4,846,145 19% Design Jul 11 Project is in design review stage. Out to Bid in Feb 11 with construction to start Apr 11. GS-09002 GMR - Project 19 Multi-Year $6,236,582 $6,186,117 $108,605 $0 $0 $6,077,512 3% Pre-design Jul 12 Portion of the project included in GMR 18 construction package. Remaining portion of GMR 19 to be combined with GMR 20. Combined project will be in design phase in Fall 2011. GS-10001 GMR - Project 20 Multi-Year $644,014 $643,863 $0 $0 $0 $643,863 0% Pre-design Jul 13 Design phase will start Jun 11 and include portions of GMR 19 to create a combined project GMR 19 and 20. Project out for Bid May 12. GS-11000 GMR - Project 21 Multi-Year $457,000 $457,000 $0 $0 $0 $457,000 0% Pre-design May 14 Design phase to start Jan 12 and construction to start Aug 13. GS-11002 Gas System Improvements Multi-Year $195,000 $195,000 $0 $0 $33,000 $162,000 17% Ongoing This project addresses ongoing capital system improvements. MULTI-YEAR PROJECTS Page 25 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments WS-09000 Seismic Water Tank Valve Minor $800,000 $799,858 $9,105 $0 $20,033 $770,720 4% Design Nov 11 Final report completed in Nov 10. Construction to start May 11. WS-11001 Vacuum Excavation Equipment Minor $275,000 $275,000 $0 $0 $0 $275,000 0% Pre-Design Jul 11 Working with fleet to create specification. WS-07000 Water Regulation Station Improvements Multi-Year $1,070,000 $1,050,438 $39,126 $0 $86,088 $925,224 14% Design Nov 11 Final report completed in Nov 10. Construction to start May 11. WS-07001 Water Recycling Facilities Multi-Year $1,100,122 $767,860 $62,979 $0 $309,021 $395,860 64% Pre-Design Jun 11 Recertifying Environmental Impact Report (EIR) to address water quality issues. WS-07004 Water System Portable Emergency Generators Multi-Year $466,000 $208,833 $0 $0 $1 $208,832 55% Construction Jul 11 Considering lease agreement. Remaining funds may be returned to reserves. WS-08001 Water Reservoir Coating Improvements Multi-Year $2,050,491 $2,044,809 $74,807 $0 $164,595 $1,805,407 12% Design Nov 11 Final report completed in Nov 10. Construction to start May 11. WS-08002 Emergency Water Supply Project Multi-Year $40,422,647 $32,519,443 $1,755,293 $0 $3,934,842 $26,829,308 34% Design Dec 12 90% of design submitted. Construction to start Jun 11. WS-08017 WMR - Project 22 Multi-Year $3,163,000 $1,554,159 $1,247,908 $148,476 $102,160 $55,615 98% Complete Notice of completion filed Dec 10. WATER FUND UTILITIES DEPARTMENT FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS MULTI-YEAR PROJECTS ENTERPRISE FUND MINOR PROJECTS Page 26 of 31 2/17/2011 Attachment 3 Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments WATER FUND UTILITIES DEPARTMENT FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS ENTERPRISE FUND WS-09001 WMR - Project 23 Multi-Year $3,100,826 $2,390,147 $71,041 $0 $59,814 $2,259,292 27% Design Apr 12 Design phase to begin during integration of WGW Mapping and GIS systems with estimated completion date of May 11. Construction to start Jul 11. Project combined with WMR 24. WS-10001 WMR - Project 24 Multi-Year $3,247,024 $3,191,765 $10,769 $0 $0 $3,180,996 2% Design Apr 12 Design phase to begin during integration of WGW Mapping and GIS systems with estimated completion date of May 11. Construction to start Jul 11. Project combined with WMR 24. WS-11000 WMR - Project 25 Multi-Year $292,000 $292,000 $0 $0 $0 $292,000 0% Pre-Design Nov 11 Project design to start Oct 11. WS-11003 Water Distribution System Improvements Multi-Year $200,000 $200,000 $16,216 $0 $68,183 $115,601 42% Ongoing TBD This project addresses ongoing capital distribution system improvements WS-11004 Water System Supply Improvements Multi-Year $200,000 $200,000 $6,113 $0 $1 $193,886 3% Ongoing TBD This project addresses ongoing capital supply system improvements MULTI-YEAR PROJECTS Page 27 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments WC-09002 Root Treatment, Sediment and Dewatering Container Minor $60,000 $60,000 $0 $0 $0 $60,000 0% Pre-design N/A Changing conditions no longer allow for this container, and this project should be cancelled. WC-11000 WC Reh/Aug. Prj 24 Multi-Year $290,000 $290,000 $0 $0 $0 $290,000 0% Pre-design Sep 13 This project will also include the WC Reh/Aug Prj 25, and the design effort will start May 12 with construction complete by Sep 13. WC-15002 Wastewater System Improvements Multi-Year $200,000 $200,000 $0 $0 $8,000 $192,000 4% Ongoing TBD This project addresses ongoing capital system improvements. ENTERPRISE FUND WASTEWATER COLLECTION FUND UTILITIES DEPARTMENT MULTI-YEAR PROJECTS MINOR PROJECTS Page 28 of 31 2/17/2011 Attachment 3 ENTERPRISE FUND REFUSE FUND PUBLIC WORKS DEPARTMENT Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments RF-09003 Recycling in Business District Minor $325,000 $325,000 $0 $0 $0 $325,000 5% Design Mar 11 A new Palo Alto-branded container design has been developed and is being routed through the design review process. RF-09004 LATP Site Development Preparation Minor $200,000 $47,900 $18,850 $0 $24,840 $4,210 98% Design TBD Consultant is performing environmental risk assessment for cleanup of site. Waiting for regulatory approvals for Areas A and B. Approval has been obtained for Area C. RF-10002 Flare Relocation Project Minor $700,000 $642,628 $11,718 $0 $50,002 $580,908 17% Design Mar 11 A consultant is currently working on the design and permitting of the new flare. Design is 95% complete. RF-07001 Relocation of Landfill Facilities Multi-Year $1,500,000 $1,217,962 $8,842 $0 $116,014 $1,093,106 27% Design Sep 11 The relocation of the Recycling Center and a permanent Household Hazardous Waste (HHW) facility will be placed at the end of Embarcadero Way on the wastewater treatment plant property. Final design and California Environmental Quality Act (CEQA) review for the project is now in progress. RF-10003 Drying Beds, Material Storage and Transfer Area Multi-Year $875,000 $835,913 $0 $0 $29,111 $806,802 8% Pre-Design Nov 11 These facilities are included in the Feasibility Study for the former Los Altos Treatment Plant (LATP) site. The results of the feasibility study for this site are to be presented to Council in early 2011. Funds for construction are budgeted for FY 2012. FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS MULTI-YEAR PROJECTS MINOR PROJECTS Page 29 of 31 2/17/2011 Attachment 3 ENTERPRISE FUND REFUSE FUND PUBLIC WORKS DEPARTMENT Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS RF-11001 Landfill Closure Multi-Year $600,000 $600,000 $28,967 $0 $28,351 $542,682 80% Design Feb 11 Consultant is finishing the design for the undergrounding of environmental control systems in the closed sections of the landfill and installing the remaining gas and leachate wells required by permit at the time of closure (expected late 2011). Page 30 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments SD-08101 Alma Street Storm Drain Improvements Minor $830,081 $121,349 $39,772 $0 $1 $81,576 100% Complete Remaining balance to be transferred to CIP SD-11101 in Jan 11 via Budget Amendment Ordinance. SD-06102 San Francisquito Creek Storm Water Pump Station Multi-Year $6,373,312 $108,207 $8,543 $15,986 $34,743 $48,935 99% Complete Jun 19 Required mitigation monitoring for 10 years (through FY 2019) is the only remaining task. SD-06104 Connect Clara Drive Storm Drains to Matadero Pump Station Multi-Year $953,480 $1 $0 $0 $0 $1 0% Pre-Design TBD On hold until project funding is identified. SD-11101 Channing Avenue/Lincoln Avenue Storm Drain Improvements Multi-Year $1,715,000 $1,686,098 $62,533 $0 $1,500,000 $123,565 100% Design Jun 11 Construction expected to begin Mar 11. MINOR PROJECTS ENTERPRISE FUND STORM DRAINAGE FUND PUBLIC WORKS DEPARTMENT MULTI-YEAR PROJECTS Page 30 of 31 2/17/2011 Attachment 3 FY 2011 MID-YEAR CAPITAL IMPROVEMENT PROGRAM PROJECTS STATUS Total Budget Available Budget Estimated Project Project Project From Budget FY 2011 FY 2011 FY 2011 Remaining Percent Project Completion Number Title Category Inception FY 2011 Expenditures Contingencies Encumbrances Balance Complete Status Date Comments WQ-10001 Plant Master Plan Minor $981,266 $981,266 $69,594 $0 $911,672 $0 100% Pre-Design Jun 12 Project on schedule. Stakeholder meetings commenced. Alternatives being developed. WQ-04010 Replacement of Existing Reclaimed Water Pipes Multi-Year $16,800,000 $623,849 $0 $0 $0 $623,849 100% Complete Project completed. All grant and loan funds received except final payment from Bay Area Clean Water Agencies (BACWA) of $6,941.87. WQ-04011 Facility Condition Assessment and Retrofit Multi-Year $4,300,000 $2,730,777 $69,871 $0 $319,845 $2,341,061 0% Design Jun 11 Ongoing retrofit projects. WQ-06014 Disinfection Facility Improvement Program Multi-Year $21,468,987 $15,136,607 $1,673,209 $0 $1,901,410 $11,561,988 80% Construction Mar 11 Closeout stage of construction. MINOR PROJECTS ENTERPRISE FUND WASTEWATER TREATMENT FUND PUBLIC WORKS DEPARTMENT MULTI-YEAR PROJECTS Page 31 of 31 2/17/2011 Attachment 4 Project Category Department/Fund Project Title FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Community Services : Land & Land Improvements AC-86017 Art in Public Places $29,545 $64,410 $21,556 $17,256 $36,531 Planning & Community Environment : Streets & Sidewalks PL-05030 Traffic Signal Upgrades 30,524 35,908 39,983 278,187 35,624 Public Works - General Fund : Streets & Sidewalks PE-86070 Street Improvements (Street Improvement Fund)4,987,364 3,368,496 3,702,381 3,323,063 2,687,557 Building & Facilities PF-00006 Roofing Replacement 76,769 256,831 21,073 227,495 25,029 Building & Facilities PF-01003 Building Systems Improvements 64,312 34,304 114,152 36,053 55,558 Building & Facilities PF-02022 Facility Interior Finishes 10,579 65,797 47,116 11,076 560 Building & Facilities PF-93009 ADA Compliance 96,587 49,955 121,617 216,133 2,150 Streets & Sidewalks PO-05054 Street lights Improvements 19,077 11,814 15,970 32,976 96,676 Streets & Sidewalks PO-89003 Sidewalk Improvements 2,299,543 2,030,796 1,675,527 952,503 510,886 Public Works - Storm Drainage Fund : SD-06101 Storm Drain System Replacement 202,652 675,832 445,582 81,878 426,861 Public Works - Wastewater Treatment Fund : WQ-80021 RWQCP Plant Equipment Replacement 238,280 1,156,156 2,544,261 403,293 15,430 WQ-80022 RWQCP System Flow Metering 180,000 0 56,245 0 16,060 Electric Fund : EL-02011 Electric Utility GIS 0 83,546 39,414 188,231 188,696 EL-06005 Fiber Optics Ring System Improvements 36,145 112,435 58,124 5,531 0 EL-06006 Fiber Optics Customer Design and Connection Services 131,930 134,498 195,808 17,203 0 EL-89028 Electric Customer Connections 3,402,213 1,982,607 1,467,233 1,702,232 445,157 EL-89031 Communications System Improvements $2,670 $50,458 $21,784 $0 $3,501 EL-89038 Substation Protection Improvements 46,187 423,904 94,411 133,185 36,546 EL-89044 Substation Facility Improvements 73,730 7,147 93,735 3,133 35,059 EL-98003 Electric Distribution System Reconstruction and Improvements 2,761,605 2,260,973 1,265,486 1,330,082 783,321 Fiber Optics Fund : FO-10000 Fiber Optic Customer Connections 0 0 0 68,373 37,399 FO-10001 Fiber Optic Network System Improvements 0 0 0 34,614 320,934 Continuous Capital Projects Expenditures for Fiscal Years 2007-2011 Page 1 of 2 2/17/2011 Attachment 4 Project Category Department/Fund Project Title FY 2007 FY 2008 FY 2009 FY 2010 FY 2011 Continuous Capital Projects Expenditures for Fiscal Years 2007-2011 Gas Fund : GS-02013 GS-03007 Directional Boring Equipment 0 63 59,410 0 0 GS-03002 GS-04003 GS-05002 Gas Main Replacements 1,858,052 433,894 38,121 87,706 11,681 GS-03008 Polyethylene Fusion Equipment Replacement 9,153 0 35,650 0 0 GS-03009 System Extensions-Unreimbursed 82,515 115 12,000 4,005 1,725 GS-06001 Gas Main Replacements, GMR-Project 16 344,176 2,256,296 2,423,677 89,180 104,444 GS-07002 Gas Main Replacements, GMR-Project 17 143,767 614,485 912,018 3,681,252 184,059 GS-80019 Gas Meters and Regulators 253,784 272,386 244,129 313,598 71,972 GS-80017 Gas System Extensions 675,874 609,566 356,666 347,412 159,999 Wastewater Collection Fund: WC-02002 WC-03003 WC-04002 Sewer System Rehabilitation and Augmentation, Project 15,16 and 17 3,374,976 1,394,506 8,840 27,141 31,882 WC-05003 WC-06003 WC-07004 Sewer System Rehabilitation and Augmentation, Project 18,19 and 20 3,048,500 1,378,862 2,154,931 1,761,725 26,903 WC-08012 WC-09001 WC-10002 Sewer System Rehabilitation and Augmentation, Project 21,22 and 23 0 126 285,858 543,313 248,658 WC-80020 Sewer System Extensions 493,863 561,620 370,253 251,152 50,551 WC-99013 Sewer Manhole Rehabilitation 441,705 116,173 48,227 168,722 203,839 Water Fund : WS-02003 Water Main Replacements, Project 16 81,310 4,629 19,695 0 0 WS-02014 Water-Gas Wastewater utilities GIS Data 216 0 33 204,583 224,408 WS-06002 Water Main Replacements, Project 20 595,117 1,830,359 93,554 349 10,092 WS-07003 Water Main Replacements, Project 21 3,328 57,923 226,559 1,383,427 1,428,937 WS-80014 Service and Hydrant Replacements 39,079 58,212 104,951 43,538 34,425 WS-80015 Water Meters 140,891 127,109 14,712 2,298 0 WS-80013 Water System Extensions 178,680 400,152 295,194 285,945 70,600 Page 2 of 2 2/17/2011 Attachment 5 Amount Transferred to Infrastructure Amount Returned to General Fund Net Amount Fiscal Year $(000) $(000) $(000) 2007 $8,736 $75 a $8,661 2008 $11,807 $117 $11,690 2009 $14,648 b $14,648 2010 $9,900 $3,243 $6,657 2011 $9,802 $9,802 2012 $10,438 $10,438 2013 $10,852 $10,852 2014 $11,294 $11,294 2015 $11,747 $11,747 2016 $12,217 $12,217 Total $111,441 $3,435 $108,006 Notes: a. Funds transferred to cover GF engineering costs for structures and grounds. b. Includes funding for the Public Safety Building $3,437K Sources: FY 2007 through 2010 are actual amounts FY 2011 based on projections FY 2012 through 2016 based on Long Range Financial Forecast General Fund Transfers to Infrastructure Reserve for Fiscal Years 2007-2016 $8,661 $14,648 $6,657 $11,690 $12,217 $11,747$11,294$10,852$10,438 $9,802 $5,000 $7,000 $9,000 $11,000 $13,000 $15,000 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Fiscal Year $0 0 0 Page 1 of 1 2/17/2011 ** NOT YET APPROVED ** 100218 sh 8261536 Resolution No. ________ Resolution of the Council of the City of Palo Alto Amending the 2010-2011 Compensation Plan for Classified Personnel (SEIU) Adopted by Resolution No. 9088 to Correct the Compensation for One Existing SEIU Classification and Change the Titles of Two Classifications 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. 9088, is hereby amended to correct the compensation for one existing SEIU classification and change the title of two classifications as set forth in Exhibit A, attached hereto and incorporated herein by reference, effective with the pay period including July 1, 2010. 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: ___________________________ ______________________________ Sr. Deputy City Attorney City Manager _____________________________ Director of Administrative Services ____________________________ Director of Human Resources EXHIBIT A Midyear SEIU Compensation Plan Changes - effective April 1, 2011 Job Code Classification Title Step Top Step Monthly Approx. Annual Hourly 366 Restoration Lead (to correct hrly rate typo error) 5 6,186 74,235 35.69 3470 Planning Arborist - S (title change from Arborist – S) 5 7,921 95,056 45.70 347 Planning Arborist (title change from Arborist) 5 7,921 95,056 45.70 Attachment 7 Police and Fire Departments' Overtime Analysis for Fiscal Years 2006 through 2010 With Fiscal Year 2011 Data Through January 12, 2011 thru 1/12 2006 2007 2008 2009 2010 2011 POLICE DEPARTMENT Overtime Expense Original Budget $981,862 $1,015,620 $1,036,815 $999,900 $999,900 $967,900 Current Budget 1,009,705 1,074,399 1,071,005 1,016,900 1,071,662 967,900 Net Overtime Cost - see below 780,647 1,025,718 1,096,894 886,568 932,960 66,789 Remaining Budget $229,058 $48,681 ($25,889) $130,332 $138,702 $901,111 Overtime Net Cost Actual Expense $1,405,155 $1,785,657 $2,009,542 $1,665,842 $1,466,226 $754,653 Less Reimbursements Stanford Communications 30,937 39,342 65,079 42,160 58,070 32,702 Utilities Communications Reimbursement 17,402 22,130 36,607 23,715 33,242 20,439 Local Agencies (A)34,565 36,457 41,770 37,413 33,930 16,706 State Grants (B)65,835 63,344 4,672 10,998 22,306 70,816 Police Service Fees 49,185 43,218 67,390 53,812 42,085 62,374 Other 12,447 18,157 15,982 3,830 27,998 Total Reimbursements 197,924 216,938 233,675 184,080 193,463 231,034 Less Department Vacancies 426,584 543,001 678,973 595,194 339,803 456,830 Net Overtime Cost $780,647 $1,025,718 $1,096,894 $886,568 $932,960 $66,789 Department Vacancies (number of days)1,733 2,280 2,766 2,402 1,368 1,702 FIRE DEPARTMENT Overtime Expense Original Budget $959,389 $1,032,674 $892,674 $1,017,674 $1,017,674 $1,017,674 Current Budget 959,389 1,032,674 996,674 1,353,058 1,017,674 1,017,674 Net Overtime Cost - see below 637,310 737,768 863,442 651,148 1,334,452 379,842 Remaining Budget $322,079 $294,906 $133,232 $701,910 ($316,778) $637,832 Overtime Net Cost Actual Expense $1,582,858 $1,860,757 $1,744,076 $1,591,261 $2,675,515 $1,151,439 Less Reimbursements Stanford Fire Services (D)479,606 563,809 528,455 482,152 810,681 348,886 Cal-Fire/FEMA (Strike Teams) 66,269 85,531 140,224 453,619 64,760 State Homeland Security Grant Program (SHSGP) (C)72,254 40,897 10,164 4,342 10,647 3,745 Urban Area Security Initiative (UASI) 26,782 1,150 Fire Service Fees 39,585 Other 2,100 Total Reimbursements 644,911 690,237 679,993 940,113 886,088 394,316 Less Department Vacancies 300,637 432,752 200,641 454,975 377,281 Net Overtime Cost $637,310 $737,768 $863,442 $651,148 $1,334,452 $379,842 Department Vacancies (number of days)1,230 1,740 810 780 1,455 1,186 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. Reimbursement from U.S. Department of Homeland Security for HazMat Continuing Challenge Training Conference (Sep 2009) (D)Stanford reimburses 30.3% of Fire expenditures. 2/23/2011