Loading...
HomeMy WebLinkAboutCity Council Agenda Item No. 14CITY OF LASE LSI110R,E DREAM EXTREME REPORT TO CITY COUNCIL TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL FROM: PAT KILROY INTERIM CITY MANAGEA DATE: APRIL 10, 2012 SUBJECT: MID-YEAR STATUS REPORT ON THE FISCAL YEAR 2011-12 BUDGET [ #LAT9J The City on a quarterly basis reviews the status of the budget. On Tuesday, April 3, 2012, the City Council held a study session to review the mid-year status of the fiscal year 2011-12 General Fund budget and to provide direction to staff. This report reflects the direction and recommendations provide by the City Council. This mid-year fiscal year 2011-12 budget report includes the following schedules: Schedule of Revenue, Expenditure and Changes in Fund Balance o Fiscal year 2011-12 adopted budget, current budget through February 29, 2012, mid-year budget adjustment recommendations and the fiscal year 2011-12 mid-year adjusted budget including the recommended budget adjustments, o Fund Balance activity and reserve balances before and after recommended budget adjustments. • Fiscal Year 2011-12 Revenue recommendations for mid-year budget adjustments. • Fiscal Year 2011-12 Department Expenditure recommendations for mid-year budget adjustments. • Detail of Fiscal Year 2011-12 Expenditure recommendations for mid-year budget adjustments. Also included in this mid-year report is the job description for the Management Analyst position. This position will replace the Redevelopment Agency Analyst position. The change is recommended due to the elimination of all Redevelopment Agencies in California effective February 1, 2012. AGENDA ITEM NO. 14 Report on the Mid-Year Status of the Fiscal Year 2011-12 Budget April 10, 2012 Page 2 1116*411*-biW4 V W - 1.9#111TO I-"- At mid-year, the City is anticipating a net increase in operating revenues of $556,539. Explanation of significant revenue increases are noted below: Sales Tax Based upon the continued recovery in the economy, sales tax in the 3rd Quarter 2011 compared to 3rd Quarter 2010 increased 5.2% in the City of Lake Elsinore. In the year over year comparison (October 2010 — September 2011 vs. October 2009 — September 2010), the City shows an increase of 4.7%. Based upon our review and the information we received from our sales tax consultants, we are projecting an increase in our sales tax revenue for fiscal year 2011-12 of $133,000. Property Tax The City staff also met with our property tax consultant to discuss our property tax revenue projections. The City of Lake Elsinore experienced a net taxable value decrease of -0.1 % for the 2011/12 tax roll, which was slightly less the decrease experienced countywide at -1.2%. Based on the revised information we received from our consultants, we are projecting a slight decrease of $203,263 in our fiscal year 2011- 12 budget. M N Building activity has been slow through the first eight months of fiscal year 2011-12. As a result, we are projecting a decrease in building permits issued, which translates to a projected decrease in building permit fees in our FY 2011-12 budget of $100,000. Municipal Code Violations (Fines and Forfeitu The City has continued to receive an increase in payments from banks for municipal code violations related to foreclosed property. As a result, over $800,000 in violation fees has been received by the City as of February 29, 2012. Therefore, staff recommends that a budget increase of $650,000 be made to Municipal Code Violations. Page 2 of 21 Report on the Mid-Year Status of the Fiscal Year 2011-12 Budget April 10, 2012 Page 3 A net increase in operating expenditures of $864,939 is being recommended. The detail and explanations for these adjustments are included in the attached schedules. However, the significant expenditure increases are as follows: 1. Contribution to Lake Maintenance Fund for Supplemental Water: $350,000 2. Severance for City Manager Termination: $195,389 In addition, $135,000 is being recommended in transfers out to the General Fund Capital Fund (CIP) for three capital projects: 1. LERA Campground Improvements — Trees: $ 70,000 2. Storage Area Network (SANS) Replacement $ 60,000 3. Kitchen Remodel Fire Station 10 (CAL Fire contribution match) 5,000 The General Fund Balance Reserves would reflect the following balances if these requests for budget adjustment are approved: 1. Unallocated Revenue: $1,943,401 2. Computer Replacement Reserve: 20,000 3. Building Repair Reserve 35,000 4. Vehicle Replacement Reserve 75,000 5. RDA Advance Reserve 750,000 6. Catastrophic Reserve Balance 31641,400 7. Budget Stabilization Reserve 22149,,919 Total General Fund Balance Reserves $8 *614,720 Percent of General Fund Expenditures 34.5% Page 3 of 21 Report on the Mid-Year Status of the Fiscal Year 2011-12 Budget April 10, 2012 Page 4 FISCAL IMPACT The fiscal impact of the mid-year budget recommendations would be as follows: 1. Operating Revenue vs. Operating Expenditures: ($173,400) 2. Transfers to General Fund CIP (Fund 105): ($1352000) 1. It is recommended that the City Council approve the Fiscal Year 2011-12 mid- year budget adjustments. Prepared by: James R. Rile Director of Ad i Vistratfive Services Approved by: Pat Kilroy Interim City Manager Page 4 of 21 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Schedule of Revenue, Expenditures and Changes in Unallocated Revenue and Reserve Balances April 10, 2012 Revenues: Major Revenues: Sales Tax Property Tax Franchise Tax Building Permit Fee Property Transfer Tax Other Taxes Other Licenses & Permits State and County Intergov. Rev. Fees Fines and Forfeitures Fire Service Tax Credit Investment Earnings Reimbursements from RDA RDA Lease Payments (LERA) RDA SB211 Pass Through Other Miscellaneous Revenue Total Revenues Before Operating Transfers In & RDA Loan Principal Repayment Operating Transfers In RDA Loan Principal Repayment-Regular RDA Loan Principal Repayment-Add'I Total Revenues Expenditures: City Council/ PSAC City Treasurer City Attorney City Manager/ Information Systems/ Econ Dev City Clerk Administrative Services General Law Enforcement Fire Community Development Public Works Lake, Parks and Recreation Animal Shelter Operating Non-Departmental - Operating Total Operating Exp. Revenues Over (Under) Exp. Unallocated Revenue Allocation: Decrease /(Increase) RDA Advance Reserve Allocation Budget Stabilization Reserve Allocation Adjusted Revenue Over (Under) Exp. FY 2010-11 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 First Qtr Bud Budget Adj by Current Mid-Yr Budget Mid-Year Audited Adopted Adjustment CC/ Other Budget at Adjustment Adjusted Actuals Budget (A) (B) YTD 2-29-12 YTD 2-29-12 Recommendations Budget (C (A+B+C) General General General Fund General Fund General Fund General Fund Fund General Fund Fund Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 1 7,160,511 7,075,000 7,075,000 133,000 7,208,000 5,438,551 5,745,000 5,745,000 (2039263) 52541,737 1,913,807 1,875,000 1,875,000 1,875,000 815,884 750,000 750,000 (100,000) 650$000 208,434 200,000 200,000 200,000 275,122 227,000 227,000 227000 967,529 915,050 915,050 42$977 958:027 294,486 284,307 (195,000) 89,307 36,150 125457 1,383,934 1,601,490 225 1,601,715 28,800 1,628:515 648,643 462,000 175,000 637,000 664,000 19297$000 1,887,908 1,894,000 1,894,000 (659000) 1,829,000 245,583 267,375 267,375 287,375 492,600 492,600 492,600 492,600 676,500 704,000 704,000 704,000 - 80,000 80,000 - 801,000 878,715 338,000 200,000 538,000 25,875 583,875 23,288,205 22,910,822 (20,000) 200,225 23,091,047 556,539 23,647,588 51,752 50,000 50,000 - 50,000 332,700 144,600 144,600 144,600 3,750,000 1,250,000 (20,000) - 200,225 1,250,000 1,250.,000 27,422,657 24,355,422 24,535,647 556,539 250092,186 257,272 258,602 258,602 1,100 259,702 362,821 300,000 300,000 300,000 1,188,557 1,181,796 1,181,796 202,790 1,384,588 287,893 216,248 8,484 224,732 5,000 229,732 1,744,283 1,745,368 (544) 1,744,824 40,000 1,784,824 7,058,585 7,801,003 (100,000) 7,701,003 14,832 7,715,835 3,601,049 3,895,564 3,895,564 12,750 3,908,314 1,337,689 1,469,004 36,820 1,505,824 78,753 1,584,578 1,716,863 1,551,514 1,551,514 23,390 1,574,904 3,072,063 3,466,402 29,364 3,495,766 351,324 30847;089 246,456 399,000 399,000 399$000 2,336,963 1,991,500 - 1,991,500 1,991,500 23,210,494 24,276,001 (33,816) 13,816 7,940 729,939 2499809063 4,212,163 79,421 192,285 .24,250,125 285,522 (1733,400) 112,123 (2j212v163) (79,421) (13,816) (192,285) (285,522) 173s400 (112,123) (210009000) Page 5 of 21 41412012,jff Page 1 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Schedule of Revenue, Expenditures and Changes in Unallocated Revenue and Reserve Balances April 10, 2012 Fund Balance Activity & Detail: Beginning Unallocated Revenue Increase (Decrease) to Unallocated Revenue Adjusted Unallocated Revenue before Allocations Allocations : Encumbrance Carryover /Adjustment Allocation of Encumbrance Carryover in Current Year Per City Council Approval Transfers Out to Gen. Fund CIP (Fund 105) Transfers Out to LLMD Citywide (Fund 130) Allocation to Computer Replacement Reserve Allocation to Building Repair Reserve Allocation to Vehicle Replacement Reserve Allocation to Budget Reserve Allocation to Catastrophic Reserve Total Allocations Changes to Various Fund Balance Reserves Decreases/ (increases) from Prior Year Encumbrance Reserve Specific Projects Prepaid expenditures Fixed assets for resale Total Changes to Various Fund Balance Reserves Ending Unallocated Revenue FY 2010-11 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 Audited Adopted First Qtr Bud Budget Adj by CC/ Other Current Budget at Mid-Yr Budget Mid-Year I Actuals Budget (A) Adjustment YTD 2-29-12 YTD 2-29-12 Adjustment Adjusted (13) (C ) (A+B+C) Recommendations Budget General General General Fund General Fund General Fund General Fund Fund General Fund Fund Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 673,882 3,138,684 3,076,704 2,059,516 3,138,684 2,251,801 3,138,684 2,212,163 79,421 13,816 192,285 285,522 (1739400) 112,123 2,886,045 3,218,104 3,090,521 2,251,801 3,424,206 20078$401 3,250,806 (231,001) (901,005) (901,005) (135,000) (1v036$005) (20,000) (20,000) (200000) (35,000) (35,000) (359000) (75,000) (75,000) (75,000) (141,400) (141 , 400) (141,400) (141,400) (231,001) 1,031,005) 11,172,405) (135$000) (193079405) 23,725 129,669 326,450 3,795 483,639 - - - 3,138,684 3,076,704 2,059,516 2,251,801 2,251,801 1g9439401 1,943,401 41412012,jff Page 2 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Schedule of Revenue, Expenditures and Changes in Unallocated Revenue and Reserve Balances April 10, 2012 Designated Reserve Balance: Computer Replacement Reserve Beginning Balance Increase in Computer Replacement Reserve Allocation of Computer Replacement Reserve Ending Bal. Computer Replacement Reserve Building Repair Reserve Beginning Balance Increase in Building Repair Reserve Allocation of Building Repair Reserve Ending Bal. Building Repair Reserve Vehicle Replacement Reserve Beginning Balance Increase in Vehicle Replacement Reserve Allocation of Vehicle Replacement Reserve Ending Bal. Vehicle Replacement Reserve RDA Advance Reserve Balance: Beginning Balance Increase in RDA Advance Reserve Allocation of RDA Advance Reserve Ending Bal. RDA Advance Reserve Catastrophic Reserve Balance -15% Beginning Balance Increase in Catastrophic Reserve Allocation of Catastrophic Reserve Ending Bal. Catastrophic Reserve Budget Stabilization Reserve Balance: Beginning Balance Increase in Budget Stabilization Reserve Allocation of Budget Stabilization Reserve Ending Bal. Budget Stabilization Reserve Total Designated Reserve Balance Total General Fund Balance- Designated & Unallocated FY 2010-11 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 FY 2011-12 Audited Adopted First Qtr Bud Budget Adj by CC/ Other Current Budget at Mid-Yr Budget Mid-Year Actuals Budget (A) Adjustment YTD 2-29-12 YTD 2-29-12 Adjustment Adjusted (B) (C (A+B+C) ' Recommendations Budget General General General Fund General Fund General Fund General Fund Fund General Fund Fund Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 Fund 100 - 20,000 - 20,000 - 20,000 20,0001 20,000 20,000 20,000 20,000 20,000 20,000 - 35,000 - 35,,000 - 35,000 35,000 35,000 35,000 35,000 35,000 35,000 35,000 - 75,000 - 75,000 - 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 - 2,000,000 750,000 750,000 2,000,000 750,000 2,000,000 2,000,000 - - - (1,250,000) - - - (1,250,000) ---- (1,250,000) 2,000,000 750,000 750,000 750,000 750,000 750,000 750,000 3,500,000 3,500,000 3,641,400 3,641,400 3,500,000 3,16410400 3,500,000 141,400 141,400 141,400 3,500,000 3,641,400 3,641,400 3,641,400 3,641,400 3,641,400 3,641,400 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2,149,919 2;149s919 7,649,919 6,541,319 6,671,319 6,671,319 6,671,319 6,671,319 61671,319 10,788,603 9,618,023 8,730,835 8,923,120 8,923,120 8.,614v720 8,6149720 Page 7 of 21 41412012,jff Page 3 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Revenue Budget Adjustment Recommendations April 10, 2012 Account Number Element Object Description 11-12 Mid-Yr Budget Adjustments Recommended 100-0000-312.21 -00 TOTAL SALES TAX� ■. r�� ® 1„1, 11 IN 11..,. 100-0000-310.10-00 100-0000-310.20-00 I ItURRENTYEAR-SECURED PROP TAX IN LIEU OF VLF TOTAL PROPERTY TAXES (60,0001 (1431263�j (203;263,li 100-0000-320.20-00 �,�BUILDING PERMIT FEE TOTAL BUILDING PERMIT FEEi: , 111 (1009000,111 100-0000-320.10-00 "'BUSINESS 111 0101 ! 1 �100-0000-320.30-10 LICENSE 1 PERMIT FEE ENCROACHMENT PERMIT ��ENCH.PMT.SUBDIVISON ABANDONEDPRPRTYRGSTRTN TOTAL LICENSES, PERMITSFEESi (42,023 51000 8090001 „�� 1111 ii1111 -00 100-0000-336.02-00 STATE MTR VEHICLE I LIEU EMERGENCY SVC GRANT REV 269150 1010001 ■ ■,■. 11,1 - ---------- - '100-0000-340.01-00 i!GRADING 100-0000-340.07-00 �100-0000-340.13-02 100-0000-340.20-28 PLAN PERMIT LANDSCAPE REVIEW 110ENSE REVIEW FEE ABATEMENT FEES ADMINISTRATIVE FEES STRUCTURE ABATEMENT FEES ADMIN. FEE-ENG INEERING DPT 41.00OA 11300 500 h 1 1000 20:0001, �,� to] r-111 Wei: F.1 zici*3101 100-0000-350.10-40 100-0000-350.13-0.0 LOCAL ORDINANCE FINES MUNICPAL CODE VIOLATIONS LAKE CITATIONS/VIOLATIONS 10,000 650,0001 TOTAL FINES, FORFEITURE& 111ilm !'OTHER REVENUE "FIRE SERVICE TAX CREDITS, TOTAL FIRE SERVICE TAX CREDIT off 1111111 '100-0000-360.20-02 ,REVENUE ,100-0000-360.60-10 100-0000-360.60-13 FROM RENT/LEASE RECOVERABLE EXPENDITURES [Advertising/ RECOVERABLE EXPENDITURES RENTALS-PARKS Tourism R` FEMA DISASTER RELIEF 215001 75 TOTAL MISCELLANEOUS TOTAL REVENUE Page 8 of 21 2011-12 Mid-Year Budget Report 4-10-12.xls,41412012,jrr Page 4 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Expenditure Budget Adjustment Recommendations April 10, 2012 Division Description Account Number Object 11-12 Mid-Yr Budget Adjustment Recommendations CITY COUNCIL 100-4110-413.20-22 100-4110-413.30-33 TRAVEL & MEETING EXPENSE SPECIAL DEPARTMENT SUPPLY 1,000 100 Total City Council igloo PUB.SFTY.ADV. COMMITTEE 100-4112-413.20-01 1100-4112-413.20-02 100-4112-413.20-20 ADVERTISING 1COMMUNITY PROMOTION PROFESS.-TECH.&OTHER SVCS Total PSAC TOTAL CITY COUNCIL! PSAC 1,100 185,000 3,907 2,690 3,793 CITY MANAGER 100-4120-413.10-10 1100-4120-413.10-65 100-4120-413.10-66 100-4120-413.10-70 100-4120-413.20-01 100-4120-413.20-20 100-4120-413.20-22 100-4120-413.30-33 REGULAR EMPLOYEES 1 RETIREMENT - FICA MEDICARE WORKERS COMPENSATION Total Personnel ADVERTISING PROFESS.-TECH.&OTHER SVCS TRAVEL& MEETING EXPENSE SPECIAL DEPARTMENT SUPPLY Total Contracts & Materials 195,390 100 2,000 1,000 100 3,200 Total 2Lty Manager 198l590 ECONOMIC DEVELOPMENT 1100-4352-413.30-30 1100-4352-413.30-33 100-4352-413.20-22 1OFFICE TRAVEL & MEETING EXPENSE SUPPLY(INCL. PRINT) SPECIAL DEPARTMENT SUPPLY 1,200 100 2,900 Total Economic De!2!2pment 4,200 TOTAL CITY MANAGER /ECON DEV, 202,790 (2,720) 2,000 720 5,000 180 (180) CITY CLERK 1100-4117-411.10-30 100-4117-411.10-10 1OVERTIME 100-4117-411.10-37 100-4117-411.20-05 100-4117-411.20-19 100-4117-411.30-33 REGULAR EMPLOYEES CELL PHONE ALLOWANCE ELECTIONS RENT OF PROPERTY & EQUIPT Special Dept. Supplies TOTAL CITY CLERK 5,000 FINANCE DEPARTMENT 100-4131-415.10-20 100-4131-415.20-17 100-4131-415.20-18 100-4131-415.20-20 100-4131-415.20-22 100-4131-415.20-23 100-4131-415.30-30 TEMP/PART-TIME EMPLOYEE POSTAGE & FREIGHT-UPS/FDX PUBLICATIONS & MEMBERSHIP PROFESS.-TECH.&OTHER SVCS TRAVEL & MEETING EXPENSE TRAINING & EDUCATION OFFICE SUPPLY (INCL. PRINT) (2,800) 300 500 41,500 300 500 (300) TOTAL ADMINISTRATIVE SERVICES 40,000 GENERAL LAW ENFORCEMENJ 100-4211-421.20-78 1 LAW ENF-RECORDS MGT SYSTM 14,832 TOTAL GENERAL LAW ENFORCEMENT IFIRE 14,832 1 SERVICES 7100-4221-422.30-33 ISPECIAL DEPT. SUPPLIES 12,750 TOTAL FIRE SERVICES1 1 12,750 1 Page 9 of 21 2011-12 Mid-Year Budget Report 4-10-12.xls,41412012,jrr Page 5 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Expenditure Budget Adjustment Recommendations April 10, 2012 Page 1© of 21 2011-12 Mid-Year Budget Report 4-10-12.xls,41412012,jrr Page 6 11-12 Mid-Yr Budget Adjustment Division Description Account Number Object Recommendations PLANNING & ZONIING 100-4310-4710-10 REGULAR EMPLOYEES 2,016 100-4310-419.10-40 EMPLOYEE INSURANCE 478 100-4310-419.10-60 RETIREMENT - PERS 474 100-4310-419.10-65 RETIREMENT - FICA 121 100-4310-419.10-66 MEDICARE 28 100-4310-419.10-70 WORKERS COMPENSATION 24 100-4310-419.10-80 S.D.I. 21 100-4310-419.10-81 S.U.I. - Total Personnel 3,163 1,600 100-4310-419.10-30 OVERTIME 100-4310-419.10-37 CELL PHONE ALLOWANCE 450 100-4310-419.20-20 PROFESS.-TECH.&OTHER SVCS 40,000 42y050 Total Contracts & Materials Materials 11n Total Planning 45$213 BUILDING & SAFETY 100-4320-424.10-10 1100-4320-424.20-20 REGULAR EMPLOYEES 40940 PROFESS.-TECHAOTHER SVCS 5 28,600 Total Bufloft & Safe 339540 CODE ENFORCEMENT 1100-4330-424.40-50 MACHINERY & EQUIP.-OTHER - Total Code Enforcement - TOTAL COMMUNITY DEVELOPMEN1 78,753 ENGINEERING 100-4412-431.10-10 REGULAR EMPLOYEES 1100-4412-431.10-20 ITEMP /PART -TIME 2,617 Total Engineering 2,617 GRAFITTI MAINTENANCE 1100-4422-434.10-38 100-4422-434.10-10 1 REGULAR EMPLOYEES 10,509 BI-LINGUAL ALLOWANCE 150 100-4422-434.10-40 EMPLOYEE INSURANCE 1,665 100-4422-434.10-60 RETIREMENT - PERS 2,958 100-4422-434.10-65 RETIREMENT - FICA 652 100-4422-434.10-66 MEDICARE 152 100-4422-434.10-70 WORKERS COMPENSATION 1,024 100-4422-434.10-80 S.D.[. 126 Total Graritti Maintenance 17y237 VEHICLE & EQUIP. MAINT. 1100-4451-439.10-20 100-4451-439.10-10 ITEMP. REGULAR EMPLOYEES 1,700 &PART TIME EMPLOYEE 435 100-4451-439.10-30 OVERTIME 74 100-4451-439.10-38 BI-LINGUAL ALLOWANCE 27 100-4451-439.10-40 EMPLOYEE INSURANCE 484 100-4451-439.10-60 RETIREMENT - PERS, 525 100-4451-439.10-65 RETIREMENT - FICA 133 100-4451-439.10-66 MEDICARE 31 100-4451-439.10-70 WORKERS COMPENSATION 104 100-4451-439.10-80 S.D.I. 24 Total Vehicle & Maintenance 3,536 23,394 1 TOTAL PUBLIC WORKS_ Page 1© of 21 2011-12 Mid-Year Budget Report 4-10-12.xls,41412012,jrr Page 6 CITY OF LAKE ELSINORE FY 2011-12 Mid-Year Operating Budget Report Expenditure Budget Adjustment Recommendations April 10, 2012 Division Description Account Number Object 11-12 Mid-Yr Budget Adjustment Recommendations 844 194 206 52 12 5 9 ADMINISTRATION 100-4510-450.10-10 REGULAR EMPLOYEES 100-4510-450.10-40 EMPLOYEE INSURANCE 100-4510-450.10-60 RETIREMENT - PERS 100-4510-450.10-65 RETIREMENT - FICA 100-4510-450.10-66 MEDICARE 100-4510-450.10-70 WORKERS COMPENSATION 100-4510-450.10-80 S.D.[. Totai Parks & Recreation Administration 1,324 LAKE WATER OP 100-4518-457.20-28 JLAKE WATER PURCHASE 350,000 Total Lake Water Operations 3509000 TOTAL LAKE, PARKS & RECREATION 351 p324 I TOTAL OPERATING EXPENDITURES iTransfer 729,939 NONDEP-OPERATING 1100-4990-499.90-98 to Fund #105 135,000 TOTAL TRANSFERS OUT 135$000 TOTAL EXPENDITURES 864,939 Page 11 of 21 2011-12 Mid -Year Budget Report 4-10-12. x1s, 41412012,jrr Page 7 City of Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures General Other Identify Fund/ Fund Funds Comments Personnel Positions: New/ Promotions/ Reclassifications/ Retirement New positions Public Works 1. New Graffiti Technician - 1/4 year in 2011-12 Graffiti Technician (Step 3) $ 17,236.71 2. New Office Specialist (Part Time-25 hrs/wk) - 1/4 year in 2011-12 Office Specialist I-Part Time (Step 3) $ 2,616.80 $ 29616.80 Gas Tax/ NPDES Subtotal $ 199853.52 $ 29616.80 Page 12 of 21 2011-12 Mid -Year Budget Report 4-10-12.xis,41412012,jrr Page 8 City of Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures Promotions/ Reclassifications Lake, Parks & Recreation (LPR): 1. Reclassify LPR Analyst to Acting LPR Manager - 1/4 year in 2011-12 Acting LPR Manager (5% increase over current position) LPR Analyst (Step 5) Net Amount Public Works: 1. Promote Mechanic to Chief Mechanic - 1/4 year in 2011-12 Chief Mechanic (Step 1) Mechanic (Step 4) Net Amount General Other Identify Fund/ Fund Funds Comments $ 32t046.01 $ (309722.31) $ 11323.70 $ 27,462.98 $ (209390.65) $ 3,536.17 3,536.17 Gas Tax/ Measure A Planning 1. Reclass Planning Manager to Acting Community Development Director - 1/4 year in 2011-12 Acting Comm. Dev. Director (5% increase over current position) $ 439647.83 Planning Manager (Step 2) $ (419886.05) Net Amount $ 19761.79 2. Reclass Senior Building Inspector to Acting Building Official- 1/4 year in 2011-12 Acting Building Official (5% increase over current position) $ 329537.99 Sr. Bldg Inspector (Step 5) $ (31,136.71) Net Amount $ 19401.28 City Manager's Office 1. Change RDA Analyst title to Management Analyst No amount or salary grade change $ Subtotal $ 89022.93 $ 3,536.17 Page 13 of 21 2011-12 Mid -Year Budget Report 4-10-12.xls,41412012,jrr Page 9 City of Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures Retirement Building & Safety 1. Payment for Retirement of Bldg & Safety Mgr Pay out Budgeted for the position for May & June 2012 Net Amount General Other Identify Fund/ Fund Funds Comments $ 249701.88 $ (19v761.52) $ 49940.36 Subtotal $ Total Requests-Personnel Positions $ City Manag-er Termination 1 Severance for City Manager (12 months) Payout of Salary 49940.36 329816.81 $ 69152.97 1959389.85 Total City Manager Termination $ 195,389.85 Lake Maintenance Fund 1. Contribution to Lake Maintenance Fund for Supplemental Water $ Total Lake Maintenace Fund Contribution $ 2011-12 Mid -Year Budget Report 4-10-12. x1s, 41412012,jrr Page 10 3509000.00 3509000.00 Page 14 of 21 City of Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures Page 15 of 21 2011-12 Mid -Year Budget Report 4-10-12.x1s,41412012Jff Page 11 General Other Identify Fund/ F_ und Funds Comments Contracts and Consultants City Council 1. Travel & Meetings $ 19000.00 2. Special Department Supplies $ 100.00 Total City Council 19100.00 City Manager Office 1. Advertising $ 100-00 2. Professional & Tech. Services $ 29000.00 3. Travel & Meetings $ 19000.00 4. Special Department Supplies $ 100.00 $ 39200.00 Economic Development 1. Travel & Meetings $ 19200.00 ICSC Conference 2. Special Department Supplies $ 39000.00 Flash Drives for ICSC 49200.00 Administrative Services 1. Actuarial Study for Other Post-Employment Benefits (OPEB) $ 10,000.00 2. Contract Senior Accountant/ Budget Analyst $ 30,000.00 $ 40v000.00 Page 15 of 21 2011-12 Mid -Year Budget Report 4-10-12.x1s,41412012Jff Page 11 City of Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures Fire: 1. Supplies Police 1. RIVIS Increase 2. Supplies/ Equipment Planning 1. Overtime 2. Cell Phone Allowance 3. Contract Planners Building & Safety 1. Contract Building Inspector City Clerk 1. Elections General Other Identify Fund/ Fund Funds Comments $ 129750.00 $ 14,832.00 28,600.00 $ 239651.00 Fund 104-TOF 149832.00 $ 239651.00 $ $ 1,600.00 450.00 40,000.00 _$ $ 42,050.00 $ 28,600.00 $ 59000.00 Total Contracts and Consultants $ 151,732.00 $ 239651.00 Page 16 of 21 2011-12 Mid -Year Budget Report 4-10-12. x1s, 414120 1 2,jrr Page 12 City • Lake Elsinore 2011-12 Mid-Year Budget Adjustment Recommendations April 10, 2012 Expenditures General Other Identify Fund/ Fund Funds Comments CIP Projects Fire: 1. Kitchen Remodel (CALFire to match Contribution) $ 50000.00 Information Technology: 1. Storage Area Network (SANS) Replacement $ 60,000.00 60,000.00 Lake, Parks & Recreation: 1. LERA Campground Improvements-Trees $ 70,000.00 Total CIP Projects $ 135,000.00 Grand Total-All Expenditure Requests -$ 8649938.66 $ 299803.97 Page 17 of 21 2011-12 Mid— Year Budget Report 4-10-12.xis,41412012,jrr Page 13 Management Analyst Class specifications are only intended to present a descriptive summary of the range of duties and responsibilities associated with specified positions. Therefore, specifications may not include all duties performed by individuals within a classification. In addition, specifications are intended to outline the minimum qualifications necessary for entry into the class and do not necessarily convey the qualifications within the position. I '11:1 2EMfiff6-M Under general supervision, performs varied professional administrative functions in the City Managers office, including coordination of special programs and projects, financial analysis, the development and preparation studies and reports, resolving citizen complaints and inquiries, provides administrative support to the City Manager, and other duties in support of the former Redevelopment Agency, Public Safety Advisory Commission, and the City's Community Development Block Grant Program, the Economic Development Department. This is a journey level class in the professional Management Analyst series. Employees assigned to this level perform the full range of duties within the City Managers Office, the former Redevelopment Agency, the Public Safety Advisory Commission, the Community Development Block Grant Program, and the Economic Development Department. Employees at this level receive only occasional instruction or assistance as new or unusual situation arise, and are fully aware of the operating procedures and policies of the work unit. IN vqpIlii 1 1114 oil mlilw 4 6:6Q Receives general supervision from the City Manager. ESSENTIAL FUNCTIONS: (Include but are not limited to the following) • Provide skilled, highly responsible administrative support to assist upper level administrative staff in the completion of their duties and responsibility; participate and take part for special projects assigned. • Provide highly responsible support to the City Council, the City Manager, and the Public Safety Advisory Commission. Page 18 of 21 Schedule and participate in various activities, operations, projects, and meetings in regards to the City Manager's office, the Public Safety Advisory Commission, the former Redevelopment Agency, the Community Development Block Grant Program, and the Economic Development Department. Participate in the development and implementation of the guidelines, procedures, and operations associated with the Public Safety Advisory Commission, the Community Development Block Grant program, and the Economic Development Department. • Attend various programs, meetings and social functions to represent the City, the Public Safety Advisory Commission, the Community Development Block Grant program, and the Economic Development Department; take and prepare minutes where appropriate, prepare agendas and associated materials. • Conduct complex administrative research, studies and surveys and prepares reports recommending appropriate course of action. • Assists with the reporting functions of the City Manager's Office, the Public Safety Advisory Commission, the City's Community Development Block Grant program, and the Economic Development Department. • Prepares written communications to the City Council, Public Safety Advisory Commission, private and public organizations, boards and commissions and outside agencies' management staff. • Assists in the management of citizen participation and public relations inclusive of the owner participation process. • Coordinates with federal, state, and local agencies on the funding of City and Community Development Block Grant projects which include grant writing and monitoring of grant administrative programs to ensure contract compliance. • Performs related duties as required by the City Manager, the Public Safety Advisory Commission, the Community Development Block Grant program, and the Economic Development Department. • This is an exempt position. Page 19 of 21 P00"6HYSICAL, MENTAL, AND ENVIRONMENTAL WORKING CONDITIONS: Employee accommodations for physical and mental disabilities will be considered on a case-by-case basis. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Positions in this class normally are required to use hands for finger movement manipulation, handling, or carrying objects and documents; required to reach with hands and arms; required to talk, hear and comprehend; required to stand, walk, sit, stoop, kneel, or crouch; subject to occasional lift, push, and/or pull objects up to 25 pounds; subject to inside and outside environmental conditions; maybe required to use personal and/or City vehicle in the course of employment; maybe required to attend periodic evening meetings and/or travel within and out of City boundariesto attend meetings; maybe required to occasionally work evenings or weekends; required to use personal computer and office equipment; required to respond to heavy, continual workload. Some of these requirements maybe accommodated for otherwise qualified individuals requiring and requesting such accommodations. QUALIFICATIONS: (the following are minimal qualifications necessary for entry into the classification.) Education and/or Experience: Any combination of education and experience that has provided the knowledge, skills, and abilities necessary for a Management Analyst. A typical way of obtaining the required qualifications is to possess a bachelor's degree in economics, business or public administration, urban planning, finance or related field and three (3) years increasingly responsible professional redevelopment, economic development, affordable housing, project management, and Community Development Block Grant experience. A graduate degree in business, public administration, planning, economics, or related field may substitute for one (1) year of related experience. Experience and/or education in a related field may substituted on a year for year basis. License/Certificate: Possession of a valid California Class C driver's license. Page 20 of 21 KNOWLEDGE/ABILITIES: (The following are a representative sample of KSA's necessary to perform essential duties of the position.) •11 =*# ; Principles, practices and techniques of redevelopment; relevant to federal and state regulations; knowledge of the Community Development Block Grant process; methods of report preparation and presentation; applicable real estate laws; codes; regulations; policies and procedures; basic research, and statistical methods and procedures; quantitative and management analysis techniques; Microsoft Word, Excel, and Power Point. Ability to: Develop, implement and administer a wide range of programs and projects; communicate effectively both orally and in writing; ability to compile analytical and financial reports and conduct real estate economic analysis using Excel software; establish and maintain cooperative and effective working relationships with others; analyze situations accurately and recommend an effective course of action; provide effective customer service. Skill to: Operate an office computer and a variety of word processing and software application. Page 21 of 21