Loading...
RPVCCA_CC_SR_2012_02_21_E_FY11-12_Midyear_Financial_ReportCrTYOF MEMORANDUM RANCHO PALOS VERDES TO: FROM: DATE: SUBJECT: REVIEWED: Project Manager: HONORABLE MAYOR &CITY COUNCIL MEMiRS DENNIS McLEAN,DIRECTOR OF FINANCE & INFORMATION TECHNOLOGY FEBRUARY 21,2012 FY11·12 MIDYEAR FINANCIAL REPORT CAROLYN LEHR,CITY MANAGER ~ Kathryn Downs,Deputy Director of Finance &Information Technology RECOMMENDATION 1)Receive and file the FY11-12 Midyear Financial Report;and 2)ADOPT RESOLUTION NO.2012-, A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF RANCHO PALOS VERDES,AMENDING RESOLUTION 2011-44,THE BUDGET APPROPRIATION FOR FY11-12,TO ADJUST THE BUDGET IN VARIOUS FUNDS OF THE CITY. EXECUTIVE SUMMARY The City of Rancho Palos Verdes continues to experience a stable financial condition.The City has established a prudent reserve level,while it continues to experience one of the lowest expenditure levels per capita in the South Bay.The City is receiving a significant amount of transient occupancy tax (TOT)from Terranea Resort,sales tax revenue has increased,and property tax revenue remains stable. If City Council adopts the attached resolution,the revised estimate of excess General Fund Reserves would be $1,300,481 at June 30,2012. A summary of the FY11-12 General Fund budget follows. E-1 FY11·12 Midyear Financial Report February 21,2012 Page 2 of 10 Current Proposed FY11·12 Budget Revised §@sJj,mjs,§gn~~~~I~@::t11:;~I§;7§1:-:·:jj;~§l7§j? Revenues 23,198,200 23,622,300 Expenditures (19,439,496)(19,332,496) Net Transfers (4,378,336)(4,674,336) litigitffiij!I:::I_i.:::::::::::::::11~1111It:::::::~:~i'11:~I' Reserve Policy 9,719,748 9,666,248 lliig:::R.II:.:':::::::::::::::::j~II.Mj::I.::jl.iR,~:} A summary of revised estimated fund balances as of June 30,2012 has been prepared (see Attachment A -"FY11-12 Combined Summary of Funds -Midyear Financial Report"). During the 2012 budget process,Staff will consider impacts discussed in this report,the accompanying proposed FY11-12 budget adjustments,and revenue trends and changes. BACKGROUND The Municipal Code of the City of Rancho Palos Verdes requires that a midyear review of the annual budget be presented to the City Council.Based upon Staff's analysis of the City's financial activities during the first half of FY11-12,there are a number of items for which the operating budget should be adjusted,as described in this report.Like previous years,midyear adjustments are a routine practice in conjunction with this report.If the activity of a particular fund,department or program is not discussed,there is nothing significant to report and revenues and expenditures are not expected to materially deviate from the amounts budgeted. The Summary Schedule of General Fund Revenue is presented below.It is important to understand that these revenue estimates are based upon Staff's analysis using trend comparisons with previous years,and reports provided by state,county and local agencies. It should be noted that future economic activity,legislation and policy decisions,as well as any other unforeseen circumstances could affect the City's revenue stream for the remainder of FY11-12. The midyear financial report also includes discussion and analysis of anticipated expenditure variances and other relevant developments related to the FY11-12 budget. Staff has included the "FY11-12 Combined Summary of Funds -Midyear Financial Report" (Attachment A)to summarize the estimated FY11-12 activity and ending fund balances for all funds within the City.The schedule includes revised revenue and expenditure estimates based on the adjustments proposed in this report. DISCUSSION General Fund Revenue Some revenue sources are difficult to estimate such as utility users'taxes and permit fees. These types of revenues are predicated on conditions outside the City's control.As an example,planning and building permit revenues will fluctuate with the economy and E-2 FY11·12 Midyear Financial Report February 21,2012 Page 3 of 10 housing activity,as well as other conditions such as the weather.Additionally,several significant franchise tax revenues are received annually after preparation of the midyear report.For these revenues,Staff has either reported FY11-12 estimated revenues as the budgeted amount or a conservative figure based on the amount of information currently available. Summary Schedule of General Fund Revenue: """'AIII"'~Property tax $5,979,684 $6,172,700 $6,149,200 $(23,500) Property tax in lieu of vehicle license fees 3,511,629 3,599,400 3,605,510 6,110 Property tax in lieu of sales tax 431,487 440,000 541,720 101,720 Property transfer tax 229,816 209,100 248,800 39,700 Sales tax 1,518,291 1,543,300 1,624,918 81,618 Transient occupancy tax 2,640,368 2,830,000 3,226,500 396,500 Franchise taxes 1,824,891 1,811,700 1,825,000 13,300 Utility user taxes 2,406,833 2,520,700 2,432,300 (88,400) Business license tax 581,141 593,300 600,300 7,000 Golf tax 363,402 338,600 386,000 47,400 Planning,building &safety,and other permits 1,932,844 2,043,600 2,030,300 (13,300) Fines and forfeitures 209,778 154,900 223,900 69,000 Interest earnings 60,077 50,800 60,100 9,300 Other use of money and property (rents &leases)530,750 380,900 388,500 7,600 Charges for services 224,319 221,100 238,300 17,200 Intergovernmental (grants &vehicle license fees)226,803 151,900 15,000 (136,900) Other revenue 249,705 136,200 69,800 (66,400) matil:::Qjiji.ffQa~ib'."iftij'.~~)::~~~~:~:~:::::··,~:t~~~~:~$):~::~li$IMS!t:a~:~::$::13;1Iai.:~$:~$;'6$.$;'~MP~$Lt.7~I4~t Overall,General Fund revenue is expected to exceed the current FY11-12 budget by nearly $0.5 million,primarily attributable to an increase of TOT revenue from Terranea Resort beyond budgeted expectations.Discussion and analysis regarding General Fund revenues is presented below. Staff does not recommend budget adjustments for immaterial anticipated variances.If a particular revenue source is not discussed,there is nothing significant to report and anticipated revenues are not expected to materially deviate from the FY11-12 budget. Sales Tax and Property Tax in-lieu of Sales Tax When comparing 2011 sales tax revenue with 2010,there has been a 9.6%increase in revenue primarily driven by increased sales among the group of restaurants at the Terranea Resort.With few exceptions,sales tax revenue generated by other businesses remained fairly consistent with 2010 levels.Staff recommends increasing the General Fund revenue budget by $82,000 for Sales Tax and $102,000 for Property Tax in-lieu of Sales Tax. Transient Occupancy Tax (TOT) The Terranea Resort is the primary source of TOT revenue for the City.Staff used a 7% growth assumption when preparing the FY11-12 budget.Based on information received E-3 FY11·12 Midyear Financial Report February 21,2012 Page 4 of 10 through January,Staff expects that FY11-12 TOT revenue will likely exceed $3.2 million. Staff recommends increasing the General Fund revenue budget by $396,000. Utility Users'Tax (UUT) While preparing the FY11-12 budget,Staff did not have sufficient information about the actual FY10-11 UUT revenue trends.Actual FY1 0-11 UUT revenue was only 0.5%more than FY09-10.Based on fiscal year to date trends and discussion with providers,Staff requests that the revenue budget be reduced by $88,000 to reflect a conservative 1% growth from FY1 0-11 to FY11-12. Fines &Forfeitures The City's fines &forfeitures revenue is primarily derived from traffic tickets.At the time that the FY11-12 budget was prepared,the fiscal year-to-date trend for this revenue was greatly reduced from the prior year.However,at the end of FY1 0-11,fine revenue departed from the trend and significantly increased.The current fiscal year trend is more consistent with actual prior year revenue,and Staff requests an adjustment of $69,000 to increase this revenue budget. Intergovernmental Revenue Upon adoption of the FY11-12 budget,the state eliminated Citizens Options for Public Safety (COPS)funding of $100,000 and had kept intact the sharing of Vehicle License Fees (VLF)with cities.The City adopted its FY11-12 budget prior to the State's adoption, based upon the expectation that COPS funding would be eliminated,but more than offset by VLF revenue.Subsequently,the state reinstated the COPS funding and eliminated the VLF funding.Staff requests an adjustment to eliminate the $151 ,900 of VLF funding from the City's revenue budget.The request for inclusion of COPS revenue is described later in this report. Staff expects to receive $15,000 of grant revenue forthe Safe Routes to Schools program, which was not previously budgeted.Staff requests an adjustment for this additional revenue source. Revenue Adjustment Summary Staff recommends revenue adjustments totaling $424,100,which would increase the General Fund revenue budget to $23.6 million (a 1.8%increase to the budget,and a 3.1 % increase from FY1 0-11).The additional revenue is primarily driven by activity at the Terranea Resort. General Fund Expenditures &Transfers Per the City's Municipal Code (section 3.32.080),budgetary compliance is determined by program.There are 30 expenditure programs in the General Fund budget.As there are a number of programs with expenditures that fluctuate with unforeseen circumstances (e.g. weather,claims and litigation),there has been a long-standing practice to prepareE-4 FY11-12 Midyear Financial Report February 21,2012 Page 5 of 10 conservative expenditure budgets and minimize the burden of numerous immaterial budget adjustments to ensure budgetary compliance. For the last 12 fiscal years,the City has experienced total General Fund favorable expenditure variances ranging from about $0.4 million to $1 million.When spread across 30 expenditure programs,favorable variances have averaged from about $14,000 to $35,000 per program or about 0.2%of the total General Fund expenditure budget. It is Finance Staff's opinion that conservative budgeting is best management practice,and in the best interest of the City.Staff has analyzed FY11-12 General Fund expenditures to date,and has determined that a number expenditure budgets warrant adjustment.A discussion of proposed adjustments follows. Salaries &Personnel The Senior Information Technician and Assistant Engineer positions have been vacant for the entire fiscal year.Management Staff does not expect to fill these positions before the start of the new fiscal year.Therefore,Staff recommends decreasing the General Fund expenditure budget by $235,300 for the salary and benefits savings. Due to the impact of the economy on the activity level of the Community Development Department,the City Manager reduced staffing by 2 positions in August 2011.Staff requests salary and benefit account budget reductions totaling $98,000. In September 2011 ,the City Manager reorganized 3 director positions resulting in a net savings of $27,000.Staff requests salary and benefit account adjustments to reflect the savings. On September 20,2011,the City Council approved a 5%increase of employee salaries in exchange for the employees paying an additional 6.5%pension contribution,effective September 23,2011.As a result of the pension reform action,Staff requests salary and benefit account budget adjustments to reflect partial fiscal year savings of $56,600. The City has been required to make unemployment payments using the pay-as-you-go option,totaling about $13,400 to date during FY11-12.These payments are not budgeted, and Staff requests an adjustment. City Manager Program (Risk Management) The City received a credit of nearly $240,000 for its general liability insurance premium for FY10-11.When the FY11-12 budget was prepared,it was expected that the credit would be applied to its FY11-12 insurance payment consistent with the accounting practice of past years.Based upon discussions with the City's auditors,the credit was applied to FY10-11.Therefore,Staff requests an adjustment to increase the FY11-12 general liability insurance budget accordingly. E-5 FY11-12 Midyear Financial Report February 21,2012 Page 6 of 10 City Manager Program (Defaulted Tax Property Purchase) The City expects to complete the purchase of a tax-defaulted property on Cherry Hill prior to the close of the fiscal year.The total cost of this purchase is estimated at $22,000 and was not anticipated during the preparation of the FY11-12 budget;Therefore,Staff requests a FY11-12 budget adjustment. Community Development Building &Safety Program The FY10-11 budget included a $29,000 appropriation for a geologic review related to potential future development of Gateway Park,which was not performed during FY10-11. On February 7,2012,the City Council authorized Staff to proceed with the California Coastal Trail project.A component of this project includes a geologic review at Gateway Park;and Staff requests that the $29,000 unspent budget from FY1 0-11 be re-appropriated for FY11-12. Recreation Special Events Program Due to the new community banner policy that became effective in October 2011,the Recreation Department has needed to re-order most of the City's event banners at a total cost of about $5,500.Staff requests an adjustment to increase the General Fund appropriation in the Special Events program. General Fund Transfers to Other Funds Per the City Council's Reserve Policy,Staff recommends an adjustment to increase the transfer amount from the General Fund Reserve to the Capital Improvement Projects (CIP) Reserve for future capital projects by $396,000,to coincide with the additional expected Transient Occupancy Tax noted above. Summary of Proposed General Fund Adjustments Revenue adjustments $424,100 Salary &personnel expenditure adjustments 416,900 Other expenditure adjustments (309,900) Increase of transfer to CIP Reserve (396,000) Transfer of COPS revenue to General Fund 100,000 lit·i.jI2t:liltrl'§,inl~Rt9Iiiil;~:$.;~~~111 OTHER FUNDS OF THE CITY This section discusses other revenues and expenditures ofthe City.Each of the following recommended adjustments has been incorporated in the FY11-12 Combined Summary of Funds -Midyear Financial Report (see Attachment A),which includes the revised fund balance estimates for June 30,2012.Again,if the activity of a particular fund is not discussed,there is nothing significant to report and actual activity is expected to approximate the FY11-12 budget. E-6 FY11-12 Midyear Financial Report February 21,2012 Page 7 of 10 Public Safety Grants As noted above,the state had eliminated Citizens Options for Public Safety (COPS) funding of $100,000,yet reinstated it since adoption of the City's FY11-12 budget.Staff requests budget adjustments to reflect the COPS revenue in the Public Safety Grants Fund and the related operating transfer to the General Fund. Special Assessments Funds Staff requests adjustments for both the 1972 Act Landscape and Lighting District Fund and the Abalone Cove Sewer District Fund.As part of the special assessment process, preparation of an annual Engineer's Report is required.Due to the consultant engineer's billing error,the City was not charged for the FY1 0-11 Engineer's Reports.Staff requests adjustments of $2,000 each for these funds to provide for the FY1 0-11 invoices paid during FY11-12. Ginsburg Cultural Arts Building Fund Dr.Allen and Charlotte Ginsburg authorized a distribution of $25,000 to the Palos Verdes Peninsula Land Conservancy from their donation previously made to the City.Staff recommends an adjustment to increase the Ginsburg fund expenditures for the distribution. Community Development Block Grant (CDBG) City Council authorized a $26,848 continuing appropriation from FY1 0-11 to FY11-12 for the Miraleste Plaza improvements to comply with the Americans with Disabilities Act (ADA).The Community Development Commission has requested that the project be accounted for in a separate budgetary program.Staff requests a housekeeping adjustment to move the budget from the first ADA program within the CDBG fund to second ADA program within the CDBG fund,and to record the associated grant revenue. As another housekeeping item,Staff requests a $111 adjustment to increase the CDBG budget for the actual amount of the funding transfer from Rolling Hills to the City's Home Improvement Program for low and moderate income property owners. Status of Major Capital Improvement Projects Hawthorne Pedestrian Improvements and Traffic Signal Synchronization Projects (total combined budget of $2,208,113) These projects are funded with more than $1.8 million of grant funding through Caltrans. Staff is currently soliciting proposals for project design,and is in process of obtaining clearances from Caltrans to proceed.The design effort is expected to begin in March. Palos Verdes Drive South Bikeway Safety Improvements (budget of $794,245) Staff is currently obtaining right-of-way clearances,and expects that design will begin in April.This project is partially funded with $630,000 of transportation grant money. E-7 FY11-12 Midyear Financial Report February 21,2012 Page 8 of 10 Palos Verdes Drive East Early Action Traffic Safety Improvements (budget of $273,114) This project includes installation of guardrails,signs and other traffic safety improvements. The project is currently in the design phase,and Staff expects to solicit bids in May. Arterial Median Improvements (budget of $500,500) This project includes the Palos Verdes Drive West Median from the Palos Verdes Estates city limit to a point near Pt.Vicente Interpretive Center.The project is currently in the design phase,and Staff expects to solicit bids in March with construction starting in April. FY09-10 Arterial Pavement Project (budget of $2,349,949) This project includes Palos Verdes Drive West/South from Hawthorne to Conqueror Drive (excluding the landslide area).The project is currently in construction,and is expected to be completed in March. FY11-12 Arterial Pavement Project (budget of $2,380,000) This project includes Palos Verdes Drive East from Miraleste to the City's northern border. Staff expects the project to be in the design phase in April. FY10-11 and FY11-12 Residential Pavement Projects (total combined budget of $3,120,000) The Request for Proposals is currently being written,and Staff expects that the combined project will be in the design phase in March. Lower Hesse/Grandview Park Improvements (budget of $1,990,836) This project is in the environmental review process,with completion targeted for May.This project appropriation will need to be carried forward to FY11-12,subject to City Council approval. Eastview Park Playground Improvements (budget of $240,000) Staff expects that construction will begin as early as April,and completed in August.This project is partially funded with a $150,000 Measure A grant from County Supervisor Knabe's office,which requires that the project be completed in November 2012. California Coastal Trail (budget of $280,000) This project will be in the design phase by March.Staff expects that construction will begin by fall 2012.The FY11-12 budget is for the first half of the total $560,000 project.This project is funded by a $500,000 grant from the Coastal Conservancy Board with a $60,000 City match. Gateway Park Development (budget of $200,000) This project is currently on hold pending a geological review that will likely be completed in summer 2012,if the professional services appropriation request noted above is approved. Abalone Cove Shoreline Park Improvements (budget of $100,000) It was originally expected that this project would be phased,and the FY11-12 budget only reflects Phase I of the project.The City has received award notification for a Land and Water Conservation Fund grant of $332,588,which requires a matching contribution.Staff will make a recommendation to City Council under separate cover on this same agenda.E-8 FY11-12 Midyear Financial Report February 21,2012 Page 9 of 10 The following projects have been completed: ~Crestridge/Crenshaw Traffic Signal; ~Palos Verdes Drive East Sewer Relocation;and ~Hesse Park Drop Ceiling. Grant Funded Projects Several street related capital improvement projects to be partially funded with state grants were carried forward from FY10-11 to FY11-12.Staff requests corresponding revenue budget adjustments in the CIP Fund for the following: ~Metro Transportation Improvement Program (TIP)grant of $630,000 for the Palos Verdes Drive South Bikeway Safety project; ~Metro TIP grant of $1,141,600 for the Pedestrian improvements on Hawthorne; ~Highway Safety Improvements Program (HSIP)grant of $212,400 for the Crestridge/Crenshaw Traffic Signal project;and ~HSIP grant of $252,000 for the Palos Verdes Drive East Early Action Safety Improvements (guardrails)project. Funding Transfers for Projects Continued From FY10-11 With City Council approval on September 20,2011,a number of FY10-11 projects were carried forward to FY11-12 as a matter of routine.Some of these projects are to be funded with restricted monies transferred from other funds.Staff recommends the following housekeeping adjustments to the FY11-12 transfer budget to reflect the sources associated with each project. ~Increase Street Maintenance fund transfers to CIP by $52,661 for a matching contribution to the Pedestrian improvements on Hawthorne. ~Increase Beautification fund transfers to CIP by $500,500 for median improvements in the City's right-of-way. ~Increase Waste Reduction fund transfers to CIP by $70,000 for the portion of the FY09-10 arterial pavement project funded with a Rubberized Asphalt grant. ~Increase Proposition C fund transfers to CIP by $240,000 for partial funding of the FY09-10 arterial pavement project. ~Increase Measure R fund transfers to CIP by $628,212 for partial funding of the FY09-10 arterial pavement project. RESERVE POLICIES A comprehensive discussion of the City's reserve policies,including a summary of the reserve balances,is included under separate cover on this same agenda.In the interest of fiscal accountability,Staff has prepared a reconciliation of the sources of funds, expenditures and appropriation of the CIP Reserve since its inception. E-9 (419,087) $3,000,000 1,954,507 2,619,479 3,226,500 FY11·12 Midyear Financial Report February 21,2012 Page 10 of 10 FY08-09 General Fund Contribution Actual FY09-10 TOT Revenue Actual FY1 0-11 TOT Revenue Expected FY11-12 TOT Revenue Contribution to Upper Filiorum Open Space Purchase (authorized by City Council on September 15,2009) Funding for Lower Hesse/Grandview Park Improvements (appropriated by City Council on June 15,2010)(2,004,095)• FISCAL iMPACT Except as discussed above,all other estimated revenues and expenditures are expected to approximate the budget in all funds of the City for FY11-12.The estimated fund balances presented in the FY11-12 Combined Summary of Funds -Midyear Financial Report (attachment A)includes the effects of the budget adjustments recommended within this report. Attachments: Resolution No.2012- A -FY11-12 Combined Summary of Funds -Midyear Financial Report B -FY11-12 Statement of Estimated General Fund Reserves E-10 RESOLUTION NO.2012- A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF RANCHO PALOS VERDES,AMENDING RESOLUTION 2011-44,THE BUDGET APPROPRIATION FOR FY11-12,TO ADJUST THE BUDGET IN VARIOUS FUNDS OF THE CITY , WHEREAS,on June 21,2011,the City Council of the City of Rancho Palos Verdes adopted Resolution 2011-44,approving a spending plan and authorizing a budget appropriation for FY11-12:and WHEREAS,certain FY11-12 revenues,expenditures and operating transfers,as described in the Midyear Financial Analysis and identified below,are expected to deviate from the amount budgeted;and WHEREAS,the City Council desires that the FY11-12 budget be adjusted. BE IT,THEREFORE,RESOLVED BY THE CITY COUNCIL OF THE CITY OF RANCHO PALOS VERDES: The following adjustments are made to the FY11-12 budget: General Fund Revenue Sales Tax 101-6000-313-10-00 Property Tax in-lieu of Sales Tax 101-6000-312-20-00 Transient Occupancy Tax 101-6000-314-10-00 Utility Users Tax 101-6000-315-XX-00 Fines &Forfeitures 101-1021-351-10-00 Vehicle License Fees 101-6000-335-10-00 Traffic Safe Grants 101-3006-334-10-00 Total General Fund Revenue Increases General Fund Expenditures &Transfers -Salaries &Benefits 82,000 102,000 396,000 (88,000) 69,000 (151,900) 15,000 424,100 Information Technology Information Technology Public Works Administration Public Works Administration Vacant Position Savin s 101-2030-411.11-00 Full-Time Salaries 101-2030-411.29-00 Employee Benefits Charges 101-3001-431.11-00 Full-Time Salaries 101-3001-431.29-00 Em 10 ee Benefits Char es 101-4002-441.11-00 Full-Time Salaries 101-4002-441.29-00 Employee Benefits Charges 101-4002-441-12-00 Part-Time Wages 101-4001-441.11-00 Full-Time Salaries 101-4001-441.29-00 Em 10 ee Benefits Char es E-11 Public Works Administration Recreation Administration Finance Finance Planning Planning Public Works Administration Recreation Administration Public Works Administration Public Works Administration 1Reorganization Savings City Manager City Clerk Personnel Emergency.Preparedness Finance Public Works Administration Planning Building &Safety Code Enforcement View Restoration Recreation Administration Recreation Facilities Pt.Vicente Interpretive Center REACH Beautification Waste Reduction Abalone Cove Sewer District Water Quality Flood Protection City Manager City Clerk Personnel Emergency Preparedness Finance Public Works Administration Planning Building &Safety Code Enforcement View Restoration Recreation Administration Recreation Facilities Pt.Vicente Interpretive Center REACH Beautification Waste Reduction Abalone Cove Sewer District Water Qualit Flood Protection Pension Reform Savin s 101-3001-431.11-00 Full-Time Salaries 101-5010-451.11-00 Full-Time Salaries 101-2020-451.11-00 Full-Time Salaries 101-2020-451.29-00 Employee Benefits Charges 101-4001-441.11-00 Full-Time Salaries 101-4001-441.29-00 Employee Benefits Charges 101-3001-431.29-00 Employee Benefits Charges 101-5010-451.29-00 Employee Benefits Charges 101-3001-431-12-00 Part-Time Wages 101-3001-431-32-00 Professional Services 101-1002-411.11-00 Full-Time Salaries 101-1004-411.11-00 Full-Time Salaries 101-1011-411.11-00 Full-Time Salaries 101-1026-421.11-00 Full-Time Salaries 101-2020-411.11-00 Full-Time Salaries 101-3001-431.11-00 Full-Time Salaries 101-4001-441.11-00 Full-Time Salaries 101-4002-441.11-00 Full-Time Salaries 101-4003-441.11-00 Full-Time Salaries 101-4004-441.11-00 Full-Time Salaries 101-5010-451.11-00 Full-Time Salaries 101-5030-451.11-00 Full-Time Salaries 101-5060-451.11-00 Full-Time Salaries 101-5070-451.11-00 Full-Time Salaries 212-3012-431.11-00 Full-Time Salaries 213-3013-431.11-00 Full-Time Salaries 225-3025-431.11-00 Full-Time Salaries 501-3052-431.11-00 Full-Time Salaries 101-1002-411.29-00 Employee Benefits Charges 101-1004-411.29-00 Employee Benefits Charges 101-1011-411.29-00 Employee Benefits Charges 101-1026-421.29-00 Employee Benefits Charges 101-2020-411.29-00 Employee Benefits Charges 101-3001-431.29-00 Employee Benefits Charges 101-4001-441.29-00 Employee Benefits Charges 101-4002-441.29-00 Employee Benefits Charges 101-4003-441.29-00 Employee Benefits Charges 101-4004-441.29-00 Employee Benefits Charges 101-5010-451.29-00 Employee Benefits Charges 101-5030-451.29-00 Employee Benefits Charges 101-5060-451.29-00 Employee Benefits Charges 101-5070-451.29-00 Employee Benefits Charges 212-3012-431.29-00 Employee Benefits Charges 213-3013-431.29-00 Employee Benefits Charges 225-3025-431.29-00 Employee Benefits Charges 501-3052-431.29-00 Em 10 ee Benefits Char es (44,000) (118,000) (17,900) (11,500) 17,900 11,500 23,000 (50,500) 129,000 33,500 (27,000)1 24,500 9,300 5,800 800 27,500 43,200 30,600 11,800 5,100 7,000 7,000 5,900 3,600 200 400 1,800 300 3,600 (31,900) (12,100) (7,500) (1,100) (35,700) (56,200) (39,800) (15,400) (6,600) (9,100) (9,100) (7,600) (4,700) (300) (500) (2,300) (400) 4,700 E-12 Related Employee Benefits Fund Adjustments Employee Benefits Charges 685-1015-381-30-00 Charge Revenue Employee Benefits 685-1015-499-23-00 PERS Retirement Employee Benefits 685-1015-499-22-00 FICA/Medicare Employee Benefits 685-1015-499-28-00 Retirement Healthcare Savings Em 10 ee Benefits 685-1015-499-21-00 Health Insurance Em 10 ee Benefits Ex enditure Ad"ustments General Fund Expenditures &Transfers -Other Items City Manager 101-1002-411-52-00 Insurance City Manager 101-1002-411-71-00 Land Purchase Personnel 101-1011-411-69-00 Unemployment Claims Building &Safety 101-4002-441-32-00 Professional Services Recreation Special Events 101-5040-451-61-00 Operating Supplies General Fund 101-6000-491-91-00 Transfer to CIP Reserve Capital Improvement Projects Fund 330-3030-391-10-00 Transfer from General Fund OTHER FUNDS OF THE CITY (369,400) 240,000 22,000 13,400 29,000 5,500 396,000 396,000 Public Safety Grants Public Safety Grants Public Safety Grants Sheriff Special Assessments Funds 1972 Act Landscape &Lighting Abalone Cove Sewer District 217-1027-334-10-00 COPS Revenue 217-1027-491-91-00 Transfer to General Fund 101-1021-391-10-00 Transfer from COPS 203-3010-431-32-00 Professional Services 225-3025-431-32-00 Professional Services 100,000 100,000 100,000 2,000 2,000 Ginsburg Cultural Arts Building Fund Ginsburg Cultural Arts Building Fund 227-3027-431-69-00 Misc Exp -PVPLC Disburse Community Development Block Grant ADA Improvements 310-3093-461-73-00 Improvements ADA Improvements 2 310-3097-461-73-00 Improvements ADA Improvements 2 310-3097-331-10-00 Federal Grants Home Improvement Program 310-3092-461-32-00 Professional Services Home Improvement Program 310-3092-331-10-00 Federal Grants 25,000 (26,848) 26,848 26,848 111 111 Grant Funded Projects Street Improvements Street Improvements Street Improvements Street Improvements 330-3031-334-10-00 State Grants 330-3031-334-10-00 State Grants 330-3031-334-10-00 State Grants 330-3031-334-10-00 State Grants 630,000 1,141,600 212,400 252,000 E-13 Funding Transfers for Projects Continued from FY10·11 Street Maintenance 202-3003-491-91-00 Transfer to CIP Street Improvements 330-3031-391-10-00 Transfer from Street Maint Beautification 212-3012-491-91-00 Transfer to CIP Street Improvements 330-3031-391-10-00 Transfer from Beautification Waste Reduction 213-3013-491-91-00 Transfer to CIP Street Improvements 330-3031-391-10-00 Transfer from Waste Reduction Proposition C 215-3015-491-91-00 Transfer to CIP Street Improvements 330-3031-391-10-00 Transfer from Proposition C Measure R 220-3020-491-91-00 Transfer to CIP Street Improvements 330-3031-391-10-00 Transfer from Measure R PASSED,APPROVED,AND ADOPTED THE 21 st DAY OF FEBRUARY 2012. ATTEST: CITY CLERK State of California ) County of Los Angeles )ss City of Rancho Palos Verdes ) 52,661 52,661 500,500 500,500 70,000 70,000 240,000 240,000 628,212 628,212 MAYOR I,CARLA MORREALE,City Clerk of The City of Rancho Palos Verdes,hereby certify that the above Resolution No.2012-was duly and regularly passed and adopted by the said City Council at regular meeting thereof held on February 21,2012. CITY CLERK CITY OF RANCHO PALOS VERDES E-14 Attachment A {::(({,,;::/@')::::,.:.::'::::::,{::::\,:1::,:,:::;:;.::::·,.·,:,.,•...:.·.,.,•..,.,:.•.::•.:.'.e.:.:.·,.:•.•.:.•.•..•fitlm.'.·.'.~.•.','.:,:,.~.:.•.:,:.•.:..~.,..,..ti..•,'.•,'.','.·.~.•.ati.~,·.:":.•.'.·.~,,•.•,:.'ft,'.:,Jt.,:,:.:,_.•.:.:.•..,::.'.•...'.•.:..,.,:.•.::•.,i:.,•..,.::.·.,.:•.•.::•.,::.,:.",,:.'.,·.,•.,·,;.•.',•.::•.,:.;:•.,::•.:.,•.,i,:.·,:.•::.•.•,•.,,•.,•..:;...•..,:.:,•.,.,..•,:.;:..•:•.:,:,:.:::.•.,•.::.,·.•::.'.:,:.:.,:..'::.:,:.·:.,:.:::.:.,·.,i.::•.,!.:,.,:.•,:..,:.:,:.:,:.'.:".,•.,:.•,.,:.•,:.:.,.'.,•.,!.',:.,•.',•.,...,•.:,•.::.,:.•::..,:.•..::,:.:,:.•.:::.'::::,:,:,.,:,.,:::".,',.":,,":".,•.::.,,.•,:.:.'::.:,.,:.•,•.:.','.:,:.,.'.,:.,•.".".'."::.•::..,:..,.::.,'\,:,,'.·.:,,'.,::,:::'.:.:.,:.,.·.:.·::.i.•.:,:.:,,'.·,:,:.,.:.;.:.:·.::.·'.i:.'.:::.,:.:::.,·.i·.:.•,...:.•,:,.,:.,.",:.'.,:,.,....•...::.:...,.:.:..::.i·i:i:·:·t,,:;:':;::r::.::.?:::::I:I:It.::::@:::lliijl~l:? .:j!!:•.•::.:::::::@((f:........:m )):",:"'~*~Qj;g_._·.::::'::::@:.:I::::::::::::II:@::@:::::::f::E@n~t:§i'=!n!t:::\::::){{:::'9@.,.:':i':::::·"::'.W,g9!1@@(t~ijgitffltijfi«@"::~"m§'*ji~~mJji ':mr~iff::t.'-::@A~::It:~I~"lt: Unrestricted Restricted by Council Action BEAUTIFICATION 916,782 281,600 170,400 616,500 411,482 CIP 11,649,780 3,823,579 8,521,253 15,528,466 8,466,146 EQUIP REPLACEMENT 2,601,028 488,600 1,347,511 1,742,117 BLDG REPLACEMENT 991,323 3,200 26,687 145,000 822,836 EMPLOYEE BENEFITS 450,351 1,823,220 1,885,884 340,000 47,687 §g~.::::::::::I:::::@:::::I:::::::::::::::::@mt:@:::I ::I::::t::::::I::::::t;:::.:I:1~IH@,IU:::::::::::::::~;,#gli:~m~n:::::'::::::::~l~:~:~giit:::i:::::::t':1:1~.lm~::::::,:::::::::.!::::::,jl~11iilll:::i::tt::l:1:i!IJ~§':i Restricted by Law or External Agencies STREET MAINTENANCE 1972 ACT EL PRADO LIGHTING CDBG 1911 ACT WASTE REDUCTION AIR QUALITY MANAGEMENT PROPOSITION C PROPOSITION A PUBLIC SAFETY GRANTS MEASURE R HABITAT RESTORATION SUBREGION 1 MAINT MEASURE A MAINT AB COVE SEWER DISTRICT GINSBURG CULTURAL ARTS BLDG DONOR RESTRICTED CONTRIB QUIMBY AFFORD HOUSING IN-LIEU EET MEASURE A CAPITAL BIKEWAYS WATER QUALITY/FLOOD PROTECl RDA -HOUSING SET ASIDE RDA -DEBT SERVICE RDA -PORTUGUESE BEND RDA -ABALONE COVE IMPROV AUTH -PORT BEND IMPROV AUTH -AB COVE 915,145 94,037 14,781 1,652,646 308,433 48,607 1,570,675 125,603 19,932 630,132 263,058 776,007 26,805 96,678 182,947 405,519 29,328 4,152 415,398 7,440 51 3,365,616 603,786 617,187 324,658 6,216 302,330 1,292,777 1,160,810 258,180 1,970 263,408 447,600 204,175 50,260 495,230 586,380 100,170 364,600 1,300 3,800 100,170 46,860 920 2,020 150 330,010 410 150,000 25,000 1,279,800 234,600 1,608,500 1,370 1,220 6,200 1,074,400 90,000 60,000 10,700 60,000 2,466,339 73,800 1,000 263,408 444,400 182,650 614,592 19,600 129,000 80,000 87,900 25,000 29,000 2,000 61,800 4,152,371 12,500 1,554,250 156,781 143,350 49,750 52,661 200,000 202,000 122,000 2,063,327 100,000 992,212 100,000 150,000 25,000 631,355 78,417 15,751 1,453,846 207,958 98,867 2,578 97,391 502 2,520 225,358 759,807 26,975 66,338 158,867 407,539 478 332,162 354,008 7,440 51 493,045 825,886 671,437 169,247 6,216 220,200 1 ?.d.Q ??7 E-15 FY11-12 Statement of Estimated General Fund Reserves Attachment B Adjustments: Beginning Ending Reserves Revenues Expenditures Net Transfers Reserves :'::?·:{iil'459'i$:$$':'"':::?2$"1~$~qQ:':):'{:{::1:$i$,1.Q:lle:&:',:"",.,....::$$;1\2i /'::"::'::::':}:~M6\';l':11'7 Unclaimed Deposits Skate &Dog Park Analysis Year-End Adjustments Continuing Appropriations FY1 0-11 Final Results Midyear Financial Report 8/2/2011 9/20/2011 9/20/2011 9/20/2011 N/A 2/21/2012 9,641 629,431 1,586,854 424,100 (629,431) 107,000 33,317 (24,400) (296,000) Column Headin Definitions Action Date is he date City Council ado ted the budget or approved an adjustment to the budget Be innin Reserves are the budgeted 7/1/11 General fund reserves at the time of budget adoption. Revenues include the originally adopted revenue budget and subsequent adjustments.When staff becomes aware that revenues are expected to significantly deviate from the adopted budget,an ad·ustment is resented to the City Council for approval. Expenditures include the originally adopted expenditure budget and subsequent adjustments.When staff becomes aware that expenditures of a program are ex ected to significantl deviate from the adopted bud et,an adjustment is presented to the City Council for ap roval. Net Transfers include both operating transfers from and to the General fund.Originally budgeted Net Transfers are adjusted when staff becomes aware that an additional operating transfer is needed to satisfy an unantici ated shortfall within another fund;and that shortfall must be funded with General fund monies. Ending Reserves are the estimated 6/30/12 General fund reserves at the time of budget adoption.Adjusted Ending Reserves is a calculation based on subse uent ad·ustments to Be innin Reserves,Revenues,Ex enditures and Net Transfers. E-16