Loading...
HomeMy Public PortalAboutBudget/Audit Joint Workshop - 21 May 2018 - Agenda - Pdf Agenda City of Beaumont Joint Workshop Regular Session 6:00 PM Beaumont Financing Authority Beaumont Utility Authority Beaumont Successor Agency (formerly RDA) Beaumont Parking Authority Finance and Audit Committee 550 E 6th Street, Beaumont, Ca Monday, May 21, 2018 Materials related to an item on this agenda submitted to the City Council after distribution of the agenda packets are available for public inspection in the City Clerk’s office at 550 E. 6th Street during normal business hours Any Person with a disability who requires accommodations in order to participate in this meeting should telephone the City Clerk’s office at 951 769 8520, at least 48 hours prior to the meeting in order to make a request for a disability related modification or accommodation. Any one person may address the City Council on any matter not on this agenda. If you wish to speak, please fill out a “Public Comment Form” provided at the back table and give it to the City Clerk. There is a three (3) minute limit on public comments. There will be no sharing or passing of time to another person. State Law prohibits the Council from discussing or taking actions brought up by your comments. Page REGULAR SESSION CALL TO ORDER Mayor Carroll, Mayor Pro Tem Martinez, Council Member Lara, Council Member White, and Council Member Santos Finance and Audit Committee: Treasurer Sharon Geiser, Chairman Steve Cooley, Vice Chairman Richard Bennecke, Member Stephen Martino, Member Joann Roberts, Member Ana Olvera, Alternate Member Wendy Fuller, Alternate Member Andrew Forster Action on any requests for excused absence: Pledge of Allegiance: Approval/Adjustments to Agenda: Conflict of Interest Disclosure: PUBLIC COMMENT PERIOD (ITEMS NOT ON THE AGENDA) Any one person may address the City Council on any matter not on this agenda. If you wish to speak, please fill out a “Public Comment Form” provided at the back table and give to the City Clerk. There is a three (3) minute time limit on public comments. There will be no sharing or passing of time to another person. State Law prohibits the Council from discussing or taking actions brought up by your comments. ACTION ITEMS Approval of all Ordinances and Resolutions to be read by title only. 1. City of Beaumont Audit for FY16/17 - Update 3 - 11 Page 1 of 84 Auditor Presentation 2. City of Beaumont Draft Budget for FY18/19 Recommended Council Action(s): 1. Discussion and direction to staff. FY19 General Fund Budget Worksheet FY19 CFD Budget Worksheet FY19 WW Operations Fund Budget Worksheet FY19 Budget Presentation 13 - 84 3. Review CIP Budget for FY18/19 Recommended Council Action(s): 1. Discussion and direction to staff. Adjournment of the City Council of the May 21, 2018 Joint Workshop at ____ p.m. The next regular meeting of the Beaumont City Council, Beaumont Financing Authority, Beaumont Utility Authority, and the Beaumont Successor Agency (formerly RDA), is scheduled for Tuesday, June 5, 2018, at 5:00 p.m. or thereafter as noted on the posted Agenda for Closed Session items in the City Council Board Room No. 5, followed by the regular meeting at 6:00 p.m. or thereafter as noted on the post ed Agenda at City Hall. Beaumont City Hall – Online www.ci.beaumont.ca.us Page 2 of 84 A MEMBER OF CITY OF BEAUMONT City Council / Finance & Audit Committee Special Meeting, Agenda Item 1May 21, 2018 Status Report on Audit of Financial StatementsFor the year ended June 30, 2017Page 3 of 84 A MEMBER OF 2 Agenda •Introduction •Required Communications •Scope of Services •Typical Year End Financial Closing Timetable •Audit Timing •Status of Audit •Questions Page 4 of 84 A MEMBER OF 3 Required Communications to Those Charged with Governance Our Responsibilities under U.S. Generally Accepted Auditing Standards, Government Auditing Standards To express an opinion about whether the financial statements prepared by management with your oversight are fairly presented, in all material respects, in conformity with U.S. generally accepted accounting principles. •Our audit of the financial statements does not relieve City Council or management of their responsibilities. Consider internal control over financial reporting and compliance in order to determine our auditing procedures for the purpose of expressing our opinion on the financial statements and not to provide assurance on the internal control over financial reporting. As part of obtaining reasonable assurance about whether financial statements are free of material misstatement, we perform tests of its compliance with certain provisions of laws, regulations, contracts, and grants. •Providing an opinion on compliance with those provisions is not an objective of our audit. Page 5 of 84 A MEMBER OF 4 Required Communications to Those Charged with Governance (Continued) Planned Scope, Timing of the Audit, and Other Our audit will include obtaining an understanding of the entity and its environment, including internal control, sufficient to assess the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit procedures. Material misstatements may result from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the entity. •We will generally communicate our significant findings at the conclusion of the audit. Some matters could be communicated sooner, particularly if significant difficulties are encountered during the audit where assistance is needed to overcome the difficulties or if the difficulties may lead to a modified opinion. We will also communicate any internal control related matters that are required to be communicated under professional standards.Page 6 of 84 A MEMBER OF Scope of Services Perform an audit of all funds of the City in accordance with GAAS and GAGAS. Issue reports on the fair presentation of the financial statements as listed below: General Purpose Financial Statements for the City of Beaumont. If applicable, prepare a Single Audit Report. Perform agreed-upon auditing procedures pertaining to the City's GANN Limit (Appropriations Limit) and render a letter annually to the City regarding compliance. Issue a separate "management letter" that includes recommendations for improvements on internal control, accounting procedures and other significant observations that are not considered to be reportable conditions. Provide assistance in the implementation of applicable GASB pronouncements not yet in effect. The Engagement Partner and Manager will meet with City’s Management: Review City policies and procedures, establish any specific requirements. Develop the audit work plan for the engagement. Periodic update meetings will be held to communicate audit progress to management. The Engagement Team and City Management will hold an exit conference. 5Page 7 of 84 A MEMBER OF Typical Year End Financial Close/Audit Timetable Months 1-2 Close the Books (Cash to ccrual/Modified Accrual) Moths 2 Reconcile and Evaluate the Account Balances Month 3 Perform Internal Analytical Reviews and Manager Reviews Month 4 Financial Reporting Month 5 External Audit of Balances Beginds 6 City Responsibility: Auditor’s Responsibility: Initial Planning Meeting The Engagement Partner and Manager will meet with City’s Management to get up to speed with City policies and procedures, establish any specific requirements Management may have, identification of unique transactions, implementation of new GASB pronouncements, and develop the audit work plan for the engagement. Interim The Engagement Team —including the Engagement Partner—will assess accounting policies adopted by the City, obtain an understanding of the City and its operating environment, review internal controls on all significant transaction classes, perform walkthroughs and/or tests of internal control, perform preliminary analytical procedures, develop initial risk assessment, evaluate Single Audit compliance (if needed), identify any audit issues, and prepare confirmation correspondence. The Engagement Team and City Management will establish expectations including responsibilities and assignments for the year-end audit, and will hold a progress status meeting at the end of the Interim phase. Year-End The Engagement Team—including the Engagement Partner—will conduct audit procedures on account balances in the general ledger, finish confirmation procedures, perform preliminary analytical procedures, search for unrecorded liabilities, perform substantive analytical review procedures, complete work on compliance with Federal Assistance, and conclude fieldwork. The Engagement Team and City Management will hold an exit conference at the end of the Year-End phase. Periodic update meetings will be held to communicate audit progress to management. Reporting The Firm will review and prepare audit reports and perform quality control procedures in accordance with the Quality Control Standards issued by the AICPA. Any comments will be issued in a letter to Management. At the City’s request, the Engagement Partner and Manager will present the audit to the City’s governing body. The Firm will complete the audit fieldwork and issue all reports within the established timeframe, assuming no internal City circumstances causes delays in the audit.Page 8 of 84 A MEMBER OF 7 Phase Description Original Schedule Revised Schedule Pre-Fieldwork Initial Planning/Kick-Off Meeting January – February February 8 Phase I Detailed Planning 2/12-16 No Change Phase 2 Risk Based Review of Systems and Compliance 2/12-16 No Change Phase 3 Substantive Testing of Account Balances*2/19-3/9 No Change (*Except for Capital Assets) Phase 4 Reporting –Prepare and Review Financial Statements/Issue Audit Opinion 3/12-23 Revised to 4/16* Draft by May 15 (In progress / partner and management QC review) Completion Presentation to Finance Committee/City Council by March 31 3/31 Revised to 5/8* Final Report to: Finance & Audit Committee on 6/4 City Council on 6/5 Audit Timing *To accommodate capital asset projectPage 9 of 84 A MEMBER OF 8 Capital Asset Inventory and Valuation •Conduct an inventory of capital assets for all governmental and enterprise categories of assets Compile the inventory and determine value for each category (May/June 2017) •Coordination among public works, utilities, engineering, and finance departments to establish both a system and standard operating procedures to track capital-infrastructure assets •Where invoices or cost data were readily available, obtain from historical records •Where invoices or cost data are not readily available or is infrastructure, consultant has been engaged to prepare valuation in accordance with GASB 34 •Under original implementation of GASB 34, governments were given four years to implement and record their infrastructure assets •The minimum requirement: Report major infrastructure assets acquired in fiscal years ending after June 30, 1980 •Data requirements include: identification of what city owns and is responsible to maintain, old appraisal reports, prior reports of facilities and amenities, title records •Difficult to obtain and too broad in scope •Impact is material to both governmental and business type activities Page 10 of 84 A MEMBER OF QUESTIONS? 9Page 11 of 84 Page 12 of 84 5/17/2018 3:44:32 PM Page 1 of 42 Budget Worksheet City of Beaumont, CA Account Summary For Fiscal: 2017-2018 Period Ending: 06/30/2018 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Fund: 100 - GENERAL FUND Department: 0000 - NON-DEPARTMENTAL Category: 40 - TAXES SECURED PROPERTY TAX 3,400,000.00100-0000-4005-0000 3,309,000.00 4,031,383.523,124,894.00 3,679,760.22 _____________________________3,824,893.002,775,629.70 UNSECURED PROPERTY TAXES 0.00100-0000-4008-0000 0.00 0.000.00 0.00 _____________________________400,000.000.00 PROPERTY TRANSFER TAX 230,000.00100-0000-4010-0000 215,000.00 272,140.79225,000.00 206,606.89 _____________________________230,000.00267,113.60 STREET LIGHT ASSESSMENT (PR…488,000.00100-0000-4015-0000 465,000.00 548,737.54465,000.00 504,706.45 _____________________________500,000.00337,872.74 SALES & USE TAXES 5,083,630.00100-0000-4050-0000 4,600,000.00 4,697,561.194,635,000.00 4,853,238.70 _____________________________5,112,393.003,200,871.95 1/2% SALES TAX-PBLC SFTY 132,000.00100-0000-4055-0000 115,000.00 154,385.88139,972.00 113,091.91 _____________________________140,000.00107,383.61 TAX - MEASURE A 433,000.00100-0000-4057-0000 0.00 0.000.00 0.00 _____________________________921,000.00291,054.16 MOTOR VEH IN-LIEU TAXES 3,800,000.00100-0000-4060-0000 3,445,100.00 3,768,042.003,461,736.00 3,506,870.76 _____________________________4,100,000.002,050,677.00 VEH.LICENSE COLLECTION 0.00100-0000-4065-0000 0.00 20,212.240.00 77,162.96 _____________________________20,000.0024,307.84 UTILITY USERS TAX 1,500,000.00100-0000-4075-0000 1,600,000.00 1,545,893.241,450,000.00 1,804,096.04 _____________________________1,550,000.001,187,309.54 FRANCHISE FEES - EDISON 295,000.00100-0000-4080-0000 295,000.00 276,827.01300,000.00 292,159.90 _____________________________305,000.00308,407.52 FRANCHISE FEES - CABLE 143,000.00100-0000-4082-0000 145,000.00 120,396.26150,000.00 152,710.14 _____________________________200,000.00128,900.24 FRANCHISE FEES - VERIZON/FRO…304,180.00100-0000-4085-0000 285,000.00 319,746.26309,000.00 372,684.26 _____________________________225,000.00159,104.30 FRANCHISE FEES- GAS COMPANY 125,000.00100-0000-4087-0000 125,000.00 88,274.95150,000.00 111,707.19 _____________________________95,000.0094,406.45 TRANSIENT OCCUPANCY TAX 250,000.00100-0000-4090-0000 217,500.00 325,874.14235,000.00 283,999.26 _____________________________255,000.00268,902.12 16,183,810.00 11,201,940.77 0.00 17,878,286.0014,816,600.0015,958,794.6814,645,602.00 16,169,475.02Category: 40 - TAXES Total: Category: 41 - LICENSES BUSINESS LICENSES 210,000.00100-0000-4200-0000 210,000.00 231,688.31210,000.00 196,185.42 _____________________________212,100.0074,022.47 210,000.00 74,022.47 0.00 212,100.00210,000.00196,185.42210,000.00 231,688.31Category: 41 - LICENSES Total: Category: 42 - PERMITS BUILDING PERMITS AND INSPECT…850,000.00100-0000-4310-0000 0.00 1,991,374.791,048,910.00 968,656.08 _____________________________1,324,500.001,321,976.47 DEV SERVICE - PERMITS 0.00100-0000-4311-0000 0.00 17,214.790.00 0.00 __________________________________________________________0.00 YARD SALE 5,000.00100-0000-4315-0000 7,000.00 6,275.000.00 7,025.00 _____________________________5,000.005,480.00 TRANSPORTATION PERMITS 20,000.00100-0000-4318-0000 0.00 0.000.00 0.00 _____________________________5,000.003,779.00 MISC PERMITS 14,000.00100-0000-4320-0000 15,000.00 66,252.220.00 29,622.11 _____________________________14,000.0012,079.26 DRAFT Page 13 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 2 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets BUILDING PLAN CHECK 0.00100-0000-4330-0000 0.00 1,400.000.00 0.00 __________________________________________________________74,403.92 DEV SERVICE - SMIP 0.00100-0000-4335-0000 0.00 222.150.00 0.00 __________________________________________________________7,218.74 RAILCAR FEES 0.00100-0000-4551-0000 0.00 4,914.000.00 0.00 __________________________________________________________11,529.00 BUILDING AND SAFETY REVENUE 1,300,000.00100-0000-4554-0000 1,100,000.00 243,345.69280,000.00 261,047.15 __________________________________________________________232,023.61 PLANNING DEPARTMENT REVEN…0.00100-0000-4556-0000 0.00 153,774.720.00 162,462.16 _____________________________170,500.0087,973.03 PUBLIC WORKS-PERMITS 0.00100-0000-4566-0000 0.00 0.000.00 0.00 __________________________________________________________2,414.18 PUBLIC WORKS-PLAN CHECK 0.00100-0000-4567-0000 0.00 0.000.00 0.00 __________________________________________________________75,662.00 PUBLIC WORKS-INSPECTION 1,450,000.00100-0000-4568-0000 1,300,000.00 1,391,751.521,400,000.00 1,360,575.95 __________________________________________________________1,247,329.86 PUBLIC WORKS-ENGINEERING 0.00100-0000-4569-0000 0.00 490.000.00 0.00 _____________________________1,667,500.0040,722.99 FIRE DEPT FEES 99,000.00100-0000-4572-0000 105,000.00 138,283.00105,000.00 77,841.00 _____________________________113,850.00132,367.82 3,738,000.00 3,254,959.88 0.00 3,300,350.002,527,000.002,867,229.452,833,910.00 4,015,297.88Category: 42 - PERMITS Total: Category: 45 - INTERGOVERNMENTAL GRANTS 0.00100-0000-4460-0000 17,500.00 79,536.73101,200.00 11,855.99 __________________________________________________________0.00 GRANT-CALRECYCLE 7,288.00100-0000-4464-0002 0.00 11,545.000.00 17,931.92 _____________________________7,288.007,288.01 7,288.00 7,288.01 0.00 7,288.0017,500.0029,787.91101,200.00 91,081.73Category: 45 - INTERGOVERNMENTAL Total: Category: 47 - CHARGES FOR SERVICE ANIMAL LICENSE - BEAUMONT 90,000.00100-0000-4210-2000 92,000.00 32,057.1022,700.00 46,704.20 _____________________________90,000.0070,588.17 ANIMAL LICENSE - BANNING 0.00100-0000-4210-2100 0.00 -175.000.00 235.00 __________________________________________________________12,213.00 ANIMAL LICENSE - CALIMESA 0.00100-0000-4210-2150 0.00 3,466.000.00 6,560.00 __________________________________________________________6,963.00 ANIMAL LICENSE - LATE FEE BEA…0.00100-0000-4211-2000 0.00 544.000.00 595.00 __________________________________________________________1,439.00 ANIMAL LICENSE - LATE FEE BAN…0.00100-0000-4211-2100 0.00 11,525.000.00 20,608.00 __________________________________________________________5,245.00 ANIMAL LICENSE - LATE FEE CAL…0.00100-0000-4211-2150 0.00 125.000.00 95.00 __________________________________________________________425.00 ANIMAL LICENSE - REPLACEMENT…0.00100-0000-4212-2000 0.00 68.000.00 33.50 __________________________________________________________303.00 ANIMAL LICENSE - REPLACEMENT…0.00100-0000-4212-2100 0.00 52.000.00 8.00 __________________________________________________________271.00 ANIMAL LICENSE - REPLACEMENT…0.00100-0000-4212-2150 0.00 4.000.00 4.00 __________________________________________________________78.00 ENCROACHMENT PERMITS 5,000.00100-0000-4325-0000 25,000.00 21,983.8220,000.00 26,715.00 __________________________________________________________1,282.06 REFUSE COLLECTION - RESIDENT…4,340,000.00100-0000-4500-0000 4,030,000.00 3,956,389.784,030,800.00 5,659,390.03 _____________________________4,400,000.004,026,649.84 REFUSE COLLECTION - COMMERC…2,430,000.00100-0000-4501-0000 0.00 1,853,021.190.00 0.00 _____________________________2,500,000.001,803,541.43 LATE CHARGES - AR BILLING 0.00100-0000-4502-0000 0.00 311,212.060.00 0.00 __________________________________________________________0.00 ANIMAL CARE - MICRO CHIP 0.00100-0000-4505-2000 0.00 2,164.000.00 3,880.00 __________________________________________________________1,852.00 ANIMAL CARE - RETURN OF ANI…0.00100-0000-4507-2000 0.00 2,848.000.00 360.00 __________________________________________________________4,639.00 ANIMAL CARE - RETURN OF ANI…0.00100-0000-4507-2100 0.00 1,470.000.00 120.00 __________________________________________________________1,573.00 DRAFT Page 14 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 3 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets ANIMAL CARE - RETURN OF ANI…0.00100-0000-4507-2150 0.00 140.000.00 0.00 __________________________________________________________430.00 ANIMAL CARE - RETURN IMPOU…0.00100-0000-4509-2000 0.00 200.000.00 80.00 __________________________________________________________180.00 ANIMAL CARE - RETURN IMPOU…0.00100-0000-4509-2100 0.00 90.000.00 80.00 __________________________________________________________90.00 ANIMAL CARE - OWNER TURN IN 0.00100-0000-4513-2000 0.00 2,225.000.00 860.00 __________________________________________________________2,048.00 ANIMAL CARE - OWNER TURN IN 0.00100-0000-4513-2100 0.00 910.000.00 1,040.00 __________________________________________________________1,540.00 ANIMAL CARE - OWNER TURN IN 0.00100-0000-4513-2150 0.00 110.000.00 220.00 __________________________________________________________0.00 ANIMAL CARE - EUTHANASIA FEE 0.00100-0000-4515-2000 0.00 320.000.00 40.00 __________________________________________________________160.00 ANIMAL CARE - EUTHANASIA FEE 0.00100-0000-4515-2100 0.00 180.000.00 170.00 __________________________________________________________140.00 ANIMAL CARE - EUTHANASIA FEE 0.00100-0000-4515-2150 0.00 160.000.00 0.00 __________________________________________________________140.00 ANIMAL CARE - TRAP RENTAL FEE 0.00100-0000-4517-2000 0.00 120.000.00 60.00 __________________________________________________________65.00 ANIMAL CARE - TRAP RENTAL FEE 0.00100-0000-4517-2100 0.00 160.000.00 60.00 __________________________________________________________40.00 ANIMAL CARE CITATION 0.00100-0000-4521-2000 0.00 300.000.00 700.00 __________________________________________________________0.00 ANIMAL CARE CITATION 0.00100-0000-4521-2100 0.00 75.000.00 300.00 __________________________________________________________0.00 ANIMAL CARE CITATION 0.00100-0000-4521-2150 0.00 0.000.00 100.00 __________________________________________________________0.00 COST RECOVERY-ANIMAL CONT…135,000.00100-0000-4522-2100 0.00 133,980.600.00 123,272.61 _____________________________20,000.0032,356.75 COST RECOVERY-ANIMAL CONT…0.00100-0000-4522-2150 0.00 13,169.730.00 8,243.72 __________________________________________________________8,117.43 COST RECOVERY-ANIMAL CONT…0.00100-0000-4522-2200 0.00 1,617.270.00 22,167.95 __________________________________________________________910.32 CODE ENFORCEMENT-SUBSCRIPT…8,000.00100-0000-4524-0000 0.00 0.000.00 0.00 __________________________________________________________0.00 CODE ENFORCEMENT-WEED AB…70,000.00100-0000-4525-0000 88,919.00 20,921.590.00 87,378.29 _____________________________70,000.0012,850.06 CODE ENFORCEMENT-OTHER 35,000.00100-0000-4526-0000 400,000.00 29,089.280.00 63,577.15 _____________________________35,000.007,332.28 CODE ENFORCEMENT LIEN RECO…25,000.00100-0000-4527-0000 0.00 78,586.270.00 5,517.60 _____________________________25,000.0017,403.89 PROPERTY ABATEMENT 0.00100-0000-4528-0000 0.00 26,032.930.00 60,520.10 __________________________________________________________0.00 LIVE SCAN-FINGERPRINTING 10,000.00100-0000-4530-0000 100,323.00 24,575.000.00 20,173.00 _____________________________20,000.0027,264.00 NOTARY FEES 500.00100-0000-4535-0000 1,912.00 530.000.00 270.00 _____________________________500.00348.00 PASSPORT FEES 22,000.00100-0000-4540-0000 87,055.00 35,335.500.00 26,875.00 _____________________________35,000.0032,245.00 SALE OF MAPS & PUB 0.00100-0000-4545-0000 0.00 0.000.00 50.00 __________________________________________________________0.00 SWIMMING POOL-ADMISSIONS 14,000.00100-0000-4550-0000 29,071.00 22,518.3830,000.00 24,339.15 _____________________________22,000.0011,299.95 SWIMMING POOL-FOOD SALES 3,500.00100-0000-4552-0000 5,905.00 3,595.020.00 4,250.18 _____________________________3,500.002,410.15 SPORT PARK ACTIVITIES 0.00100-0000-4560-0000 0.00 0.000.00 800.00 __________________________________________________________0.00 SPECIAL POLICE SERVICES 85,000.00100-0000-4562-0000 63,716.00 126,329.69387,270.00 91,338.62 _____________________________90,000.00134,033.07 SCHOOL RESOURCE OFFICER PR…0.00100-0000-4565-0000 0.00 0.000.00 0.00 _____________________________137,000.0046,396.32 DRAFT Page 15 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 4 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets COMMUNITY PROGRAMS 0.00100-0000-4570-0000 0.00 4,486.004,000.00 1,920.00 _____________________________10,000.0014,020.00 DAY CAMP PROGRAM 56,000.00100-0000-4575-0000 44,501.00 66,605.0035,000.00 37,393.00 _____________________________60,000.0056,978.90 BOND ISSUANCE 0.00100-0000-4578-0000 0.00 0.000.00 0.00 __________________________________________________________279.00 BOND REDUCTION/EXONERATION 0.00100-0000-4579-0000 0.00 20,630.000.00 17,750.00 __________________________________________________________41,489.51 BUILDING RENTAL 120,000.00100-0000-4590-0000 120,490.00 122,705.5355,000.00 120,856.32 _____________________________125,000.00156,837.96 COMMUNITY SERVICE STAFF TI…0.00100-0000-4595-1550 0.00 22,821.500.00 3,605.00 __________________________________________________________25,582.50 SALE OF MISC COPIES 1,000.00100-0000-4599-0000 16,075.00 1,698.600.00 2,057.10 _____________________________1,900.002,544.19 ADMINISTRATIVE FEES 0.00100-0000-4820-0000 0.00 0.000.00 0.00 __________________________________________________________12,844.24 7,450,000.00 6,585,439.02 0.00 7,644,900.005,104,967.006,491,372.524,584,770.00 6,956,972.84Category: 47 - CHARGES FOR SERVICE Total: Category: 50 - FINES AND FORFEITURES ABANDONED VEHICLE PROGRAM 53,000.00100-0000-4640-0000 0.00 12,946.208,000.00 4,051.38 _____________________________5,000.002,950.23 GENERAL FINES 2,000.00100-0000-4641-0000 4,120.00 4,664.93140,000.00 4,765.04 _____________________________2,000.002,391.47 PARKING FINE REVENUE 5,000.00100-0000-4643-0000 11,265.00 8,067.500.00 11,269.87 _____________________________8,000.007,012.60 CA VEHICLE CODE FINES 88,000.00100-0000-4647-0000 104,615.00 102,326.0192,000.00 111,983.29 _____________________________95,000.0072,605.24 148,000.00 84,959.54 0.00 110,000.00120,000.00132,069.58240,000.00 128,004.64Category: 50 - FINES AND FORFEITURES Total: Category: 53 - COST RECOVERY COST RECOVERY 0.00100-0000-4450-0014 0.00 0.0065,000.00 57,241.92 __________________________________________________________0.00 COST RECOVERY 135,000.00100-0000-4685-0000 0.00 137,827.2320,000.00 31,014.39 __________________________________________________________148,377.22 COST RECOVERY-OES 0.00100-0000-4687-0003 0.00 0.000.00 5,039.00 __________________________________________________________0.00 INSURANCE RECOVERY 150,000.00100-0000-4693-0000 0.00 288,906.26425,000.00 299,631.12 __________________________________________________________176,020.56 285,000.00 324,397.78 0.00 0.000.00392,926.43510,000.00 426,733.49Category: 53 - COST RECOVERY Total: Category: 54 - MISCELLANEOUS REVENUES RELEASE OF LIEN 6,500.00100-0000-4600-0000 0.00 0.000.00 0.00 _____________________________6,500.0010,203.00 INTEREST 0.00100-0000-4650-0000 0.00 19,825.820.00 13,229.36 _____________________________15,000.004,397.40 COST RECOVERY - K9 PROGRAM 0.00100-0000-4685-00K9 0.00 4,880.000.00 0.00 __________________________________________________________3,660.00 CASH OVER/SHORT 0.00100-0000-4800-0000 0.00 -20.050.00 -993.55 __________________________________________________________-4.79 MISCELLANEOUS REVENUE 20,000.00100-0000-4825-0000 60,000.00 3,054,996.8190,000.00 16,113.62 _____________________________15,000.0012,635.55 26,500.00 30,891.16 0.00 36,500.0060,000.0028,349.4390,000.00 3,079,682.58Category: 54 - MISCELLANEOUS REVENUES Total: Category: 58 - OTHER FINANCING SOURCES SENIOR CENTER DONATIONS 0.00100-0000-4555-0000 33.00 0.000.00 20.00 __________________________________________________________0.00 DONATIONS - K9 UNIT 0.00100-0000-4815-0000 0.00 16,015.900.00 12,262.06 __________________________________________________________4,527.00 CHERRY FESTIVAL 0.00100-0000-4826-0000 0.00 2,090.000.00 0.00 __________________________________________________________0.00 DRAFT Page 16 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 5 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets FIREWORKS DONATIONS 0.00100-0000-4829-0000 0.00 8,500.000.00 0.00 __________________________________________________________0.00 SALE OF PROPERTY 0.00100-0000-4850-0000 15,000.00 42,236.730.00 0.00 __________________________________________________________5,341.50 DO NOT USE - PASIS FEES 0.00100-0000-4889-0000 0.00 0.000.00 7,197.20 __________________________________________________________0.00 0.00 9,868.50 0.00 0.0015,033.0019,479.260.00 68,842.63Category: 58 - OTHER FINANCING SOURCES Total: Category: 90 - TRANSFERS DO NOT USE - TRANSFERS 0.00100-0000-4893-0000 0.00 0.000.00 750,000.00 __________________________________________________________0.00 TRANSFERS 5,191,400.00100-0000-9950-0000 5,825,500.00 6,117,785.145,408,470.00 2,994,910.80 _____________________________5,332,745.00-145,380.00 5,191,400.00 -145,380.00 0.00 5,332,745.005,825,500.003,744,910.805,408,470.00 6,117,785.14Category: 90 - TRANSFERS Total: 33,239,998.00 21,428,387.13 0.00 34,522,169.0028,696,600.0029,861,105.4828,623,952.00 37,285,564.26Department: 0000 - NON-DEPARTMENTAL Total: DRAFT Page 17 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 6 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1050 - CITY COUNCIL Category: 60 - PERSONNEL SERVICES SALARIES 22,200.00100-1050-6010-0000 25,200.00 25,330.3025,500.00 25,456.13 _____________________________25,200.0020,337.02 HEALTH INSURANCE 0.00100-1050-6020-0000 23,908.00 -2,281.9118,890.00 8,791.80 __________________________________________________________-4,028.78 DENTAL INSURANCE 0.00100-1050-6021-0000 0.00 547.9212,952.00 1,095.84 __________________________________________________________0.00 WORKERS COMP 1,640.00100-1050-6022-0000 2,720.00 1,331.253,200.00 1,728.45 _____________________________1,638.001,026.97 P.E.R.S./P.E.P.R.A.3,240.00100-1050-6024-0000 350.00 2,434.94332.00 0.00 __________________________________________________________2,756.79 DEFERRED COMP 0.00100-1050-6026-0000 0.00 0.0014,444.00 7,641.20 __________________________________________________________0.00 VISION CARE 0.00100-1050-6027-0000 0.00 87.0687.00 174.12 __________________________________________________________0.00 LIFE INSURANCE 0.00100-1050-6028-0000 480.00 0.0096.00 27.88 __________________________________________________________0.00 MEDICARE 365.00100-1050-6034-0000 365.00 366.46290.00 349.75 _____________________________365.00297.61 FICA/PARS 328.00100-1050-6035-0000 0.00 328.770.00 365.34 _____________________________328.00241.91 RECRUITMENT AND HIRING COS…0.00100-1050-6050-0000 0.00 929.350.00 0.00 __________________________________________________________0.00 27,773.00 20,631.52 0.00 27,531.0053,023.0045,630.5175,791.00 29,074.14Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 1,900.00100-1050-7015-0000 700.00 0.00700.00 90.22 2,400.00_____________________________1,582.29 ADVERTISING 200.00100-1050-7020-0000 0.00 56.310.00 0.00 __________________________________________________________500.00 OFFICE SUPPLIES 500.00100-1050-7025-0000 400.00 136.62400.00 70.18 200.00 200.00370.67 LOCAL MEETINGS 9,000.00100-1050-7035-0000 5,000.00 4,394.345,000.00 1,131.39 9,000.00 9,000.007,032.20 UNIFORMS 78.00100-1050-7065-0000 0.00 262.800.00 0.00 __________________________________________________________77.58 CONTRACTUAL SERVICES 0.00100-1050-7068-0000 80,500.00 13,512.2080,500.00 52,745.47 __________________________________________________________0.00 SPECIAL DEPT SUPPLIES 0.00100-1050-7070-0000 0.00 100.64350.00 0.00 10,500.00 10,500.00888.35 COMPUTER SUPPLIES/MAINT 10,000.00100-1050-7072-0000 0.00 0.000.00 0.00 __________________________________________________________7,505.12 21,678.00 17,956.21 22,100.00 19,700.0086,600.0054,037.2686,950.00 18,462.91Category: 65 - OPERATING COSTS Total: 49,451.00 38,587.73 22,100.00 47,231.00139,623.0099,667.77162,741.00 47,537.05Department: 1050 - CITY COUNCIL Total: DRAFT Page 18 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 7 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1150 - CITY CLERK Category: 60 - PERSONNEL SERVICES SALARIES 82,500.00100-1150-6010-0000 85,995.00 75,570.41900.00 902.98 _____________________________91,865.0063,692.68 SICK LEAVE 0.00100-1150-6013-0000 0.00 0.000.00 0.00 __________________________________________________________1,027.07 HOLIDAY PAY 0.00100-1150-6014-0000 0.00 0.000.00 0.00 __________________________________________________________2,746.76 VACATION 0.00100-1150-6015-0000 0.00 0.000.00 0.00 __________________________________________________________2,218.32 ACCRUED TIME CASH OUT 1,530.00100-1150-6016-0000 0.00 4.370.00 0.00 _____________________________1,647.000.00 OTHER COMPENSATION 0.00100-1150-6018-0000 0.00 2,015.520.00 0.00 __________________________________________________________4,594.44 HEALTH INSURANCE 1,750.00100-1150-6020-0000 22,175.00 8,004.540.00 0.00 _____________________________18,000.0078.20 DENTAL INSURANCE 1,900.00100-1150-6021-0000 0.00 1,251.200.00 0.00 __________________________________________________________1,720.40 WORKERS COMP 5,675.00100-1150-6022-0000 3,265.00 4,557.39600.00 61.69 _____________________________5,971.003,171.47 DISABILITY 685.00100-1150-6023-0000 560.00 456.0012.00 0.00 _____________________________526.00583.84 P.E.R.S./P.E.P.R.A.13,400.00100-1150-6024-0000 14,960.00 17,308.690.00 0.00 _____________________________17,832.008,605.99 LIFE INSURANCE 85.00100-1150-6028-0000 195.00 90.000.00 0.00 _____________________________84.0077.00 MEDICARE 1,275.00100-1150-6034-0000 1,250.00 1,120.5713.00 13.50 _____________________________1,356.001,071.87 FICA/PARS 12.00100-1150-6035-0000 0.00 9.450.00 13.05 _____________________________12.009.00 108,812.00 89,597.04 0.00 137,293.00128,400.00991.221,525.00 110,388.14Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 200.00100-1150-7015-0000 0.00 475.000.00 0.00 __________________________________________________________75.00 ADVERTISING 300.00100-1150-7020-0000 1,200.00 39.001,200.00 474.37 300.00 300.000.00 OFFICE SUPPLIES 850.00100-1150-7025-0000 250.00 408.00250.00 45.64 1,600.00 800.00629.54 DUES & SUBSCRIPTIONS 0.00100-1150-7030-0000 0.00 130.000.00 0.00 670.00 670.0010,346.15 LOCAL MEETINGS 2,550.00100-1150-7035-0000 2,000.00 1,452.881,500.00 0.00 1,500.00 1,500.002,007.63 SPECIAL COMMUNITY EVENTS 0.00100-1150-7049-0000 44,694.93 44,694.930.00 0.00 __________________________________________________________0.00 UNIFORMS 0.00100-1150-7065-0000 0.00 283.680.00 0.00 __________________________________________________________0.00 TRAVEL, EDUCATION, TRAINING 1,150.00100-1150-7066-0000 0.00 0.000.00 0.00 1,150.00 1,150.00565.88 CONTRACTUAL SERVICES 20,000.00100-1150-7068-0000 11,500.00 0.000.00 0.00 7,250.00 15,250.0018,030.81 SPECIAL DEPT SUPPLIES 0.00100-1150-7070-0000 0.00 1,390.9225.00 0.00 __________________________________________________________0.00 SOFTWARE 10,000.00100-1150-7071-0000 0.00 9,900.000.00 0.00 10,000.00_____________________________0.00 EQUIPMENT SUPPLIES/MAINT 0.00100-1150-7090-0000 0.00 56.940.00 0.00 __________________________________________________________0.00 35,050.00 31,655.01 22,470.00 19,670.0059,644.93520.012,975.00 58,831.35Category: 65 - OPERATING COSTS Total: 143,862.00 121,252.05 22,470.00 156,963.00188,044.931,511.234,500.00 169,219.49Department: 1150 - CITY CLERK Total: DRAFT Page 19 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 8 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1200 - ADMINISTRATION Category: 60 - PERSONNEL SERVICES SALARIES 1,120,750.00100-1200-6010-0000 1,020,210.67 741,519.091,196,772.00 788,812.70 _____________________________905,156.00975,294.08 ADMIN TIME 0.00100-1200-6011-0000 0.00 1,761.540.00 0.00 __________________________________________________________9,028.20 OVERTIME 4,500.00100-1200-6012-0000 3,500.00 2,144.513,153.00 3,635.03 _____________________________2,500.00537.89 SICK LEAVE 0.00100-1200-6013-0000 0.00 7,417.340.00 125,441.37 __________________________________________________________12,532.55 HOLIDAY 0.00100-1200-6014-0000 0.00 19,133.480.00 83,692.08 __________________________________________________________47,527.60 VACATION 0.00100-1200-6015-0000 0.00 23,252.520.00 65,027.21 __________________________________________________________34,559.33 ACCRUED TIME CASH OUT 36,079.00100-1200-6016-0000 8,445.00 75.4213,990.00 74.70 _____________________________24,686.00127.25 OTHER COMPENSATION 0.00100-1200-6018-0000 0.00 9,151.420.00 0.00 __________________________________________________________33,803.48 HEALTH INSURANCE 173,567.00100-1200-6020-0000 149,982.33 105,854.06209,229.00 123,550.07 _____________________________162,000.00124,074.76 DENTAL INSURANCE 10,700.00100-1200-6021-0000 0.00 8,230.1436,135.00 10,462.14 __________________________________________________________11,014.82 WORKERS COMP 104,737.00100-1200-6022-0000 27,760.00 46,100.0751,990.00 79,708.96 _____________________________58,835.0046,254.86 DISABILITY 6,708.00100-1200-6023-0000 6,265.00 5,136.187,252.00 5,194.55 _____________________________4,734.006,811.20 P.E.R.S./P.E.P.R.A.176,105.00100-1200-6024-0000 193,183.00 151,276.66225,434.00 164,546.22 _____________________________91,318.00128,569.79 UNEMPLOYMENT 3,500.00100-1200-6025-0000 0.00 19,994.560.00 19,821.04 __________________________________________________________2,581.64 DEFERRED COMP 5,500.00100-1200-6026-0000 0.00 5,929.2345,380.00 42,529.48 __________________________________________________________20,758.24 VISION CARE 750.00100-1200-6027-0000 0.00 1,003.582,836.00 1,181.63 __________________________________________________________778.32 LIFE INSURANCE 694.00100-1200-6028-0000 1,056.00 1,059.591,279.00 819.13 _____________________________714.00765.76 MEDICARE 20,364.00100-1200-6034-0000 14,747.00 10,674.2117,586.00 16,259.03 _____________________________13,519.0015,619.86 FICA/PARS 12.00100-1200-6035-0000 0.00 9.580.00 1,066.05 _____________________________20.009.00 RECRUITMENT AND HIRING COS…4,000.00100-1200-6050-0000 0.00 32,257.960.00 0.00 __________________________________________________________20,486.64 1,667,966.00 1,491,135.27 0.00 1,263,482.001,425,149.001,531,821.391,811,036.00 1,191,981.14Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS ADMIN OVERHEAD -1,000,000.00100-1200-7001-0000 0.00 -700,000.000.00 -443,917.00 _____________________________-712,000.00-700,000.00 UTILITIES 55,000.00100-1200-7010-0000 60,000.00 36,666.0260,000.00 48,064.20 40,200.00_____________________________42,526.62 TELEPHONE 42,000.00100-1200-7015-0000 40,000.00 37,261.1140,000.00 42,956.79 36,550.00_____________________________26,793.36 ADVERTISING 3,000.00100-1200-7020-0000 3,500.00 1,298.403,500.00 2,595.12 11,210.00 11,210.001,849.53 OFFICE SUPPLIES 41,000.00100-1200-7025-0000 20,000.00 23,882.3120,000.00 46,411.40 23,925.00 32,175.0032,374.01 HEALTH/FITNESS 0.00100-1200-7027-0000 0.00 0.007,699.00 6,430.97 __________________________________________________________732.30 DUES & SUBSCRIPTIONS 24,000.00100-1200-7030-0000 8,800.00 29,449.8110,000.00 17,799.56 27,970.00 27,620.0035,339.23 LOCAL MEETINGS 10,000.00100-1200-7035-0000 2,000.00 3,014.302,300.00 5,749.47 12,675.00 3,500.0011,404.29 DRAFT Page 20 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 9 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets GRANT SPECIFIC COSTS (CalRecyc…6,500.00100-1200-7036-0000 0.00 17,863.680.00 0.00 8,500.00 8,500.006,762.64 VEHICLE MAINTENANCE 500.00100-1200-7037-0000 0.00 446.420.00 0.00 590.00 590.00150.00 FUEL 300.00100-1200-7050-0000 2,400.00 0.004,000.00 2,120.02 __________________________________________________________0.00 BANKING FEES 0.00100-1200-7051-0000 0.00 52,169.62297,140.00 112,246.05 __________________________________________________________6,417.16 CREDIT CARD FEES 91,000.00100-1200-7052-0000 46,500.00 79,068.800.00 35,350.58 __________________________________________________________50,571.82 PERMITS, FEES AND LICENSES 2,500.00100-1200-7053-0000 0.00 0.000.00 0.00 __________________________________________________________1,370.50 INTEREST AND PENALTIES 15.00100-1200-7055-0000 2,100.00 93.220.00 1,366.76 __________________________________________________________1,669.23 UNIFORMS 4,900.00100-1200-7065-0000 0.00 2,186.121,000.00 677.91 2,715.00 2,040.004,023.12 TRAVEL, EDUCATION, TRAINING 8,000.00100-1200-7066-0000 3,000.00 398.003,000.00 707.99 4,000.00 12,675.006,085.26 CONTRACTUAL SERVICES 1,328,798.00100-1200-7068-0000 280,750.00 1,003,916.641,556,165.00 1,478,477.45 897,725.00 218,400.00794,135.57 SPECIAL DEPT SUPPLIES 9,500.00100-1200-7070-0000 3,000.00 8,046.203,000.00 2,360.41 21,000.00 17,900.007,135.34 SOFTWARE 22,000.00100-1200-7071-0000 56,500.00 104,413.190.00 0.00 47,750.00_____________________________126,028.19 COMPUTER SUPPLIES/MAINT 6,000.00100-1200-7072-0000 3,000.00 9,831.600.00 69,474.61 11,850.00_____________________________19,110.41 EQUIPMENT LEASING/RENTAL 3,000.00100-1200-7075-0000 18,000.00 4,463.7720,000.00 13,261.78 12,250.00_____________________________2,712.21 BUILDING SUPPLIES/MAINT 20,000.00100-1200-7085-0000 11,250.00 15,198.8015,000.00 16,851.12 27,500.00_____________________________19,145.06 SECURITY SERVICES 1,800.00100-1200-7087-0000 0.00 360.000.00 0.00 1,800.00_____________________________1,860.00 EQUIPMENT SUPPLIES/MAINT 0.00100-1200-7090-0000 0.00 0.000.00 0.00 __________________________________________________________2,637.57 SPECIAL OCCASION 0.00100-1200-7095-0000 0.00 110.930.00 0.00 __________________________________________________________0.00 COMMUNITY PROGRAM 0.00100-1200-7096-0000 0.00 212.270.00 1,000.00 __________________________________________________________0.00 679,813.00 500,833.42 1,188,210.00 -377,390.00560,800.001,459,985.192,042,804.00 730,351.21Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS CONTINGENCY 71,620.00100-1200-7900-0000 258,284.07 0.000.00 0.00 _____________________________205,433.240.00 EQUIPMENT 2,000.00100-1200-8040-0000 0.00 42,179.060.00 83,546.00 __________________________________________________________0.00 FURNITURE & FIXTURES 19,000.00100-1200-8050-0000 0.00 0.000.00 0.00 __________________________________________________________19,609.05 92,620.00 19,609.05 0.00 205,433.24258,284.0783,546.000.00 42,179.06Category: 70 - CAPITAL IMPROVEMENTS Total: 2,440,399.00 2,011,577.74 1,188,210.00 1,091,525.242,244,233.073,075,352.583,853,840.00 1,964,511.41Department: 1200 - ADMINISTRATION Total: DRAFT Page 21 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 10 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1225 - FINANCE AND BUDGETING Category: 60 - PERSONNEL SERVICES SALARIES 0.00100-1225-6010-0000 0.00 0.000.00 0.00 _____________________________678,687.000.00 OVERTIME 0.00100-1225-6012-0000 0.00 0.000.00 0.00 _____________________________1,000.000.00 ACCRUED TIME CASH OUT 0.00100-1225-6016-0000 0.00 0.000.00 0.00 _____________________________15,245.000.00 HEALTH INSURANCE 0.00100-1225-6020-0000 0.00 0.000.00 0.00 _____________________________126,000.000.00 WORKERS COMP 0.00100-1225-6022-0000 0.00 0.000.00 0.00 _____________________________44,114.000.00 DISABILITY 0.00100-1225-6023-0000 0.00 0.000.00 0.00 _____________________________3,682.000.00 P.E.R.S./P.E.P.R.A.0.00100-1225-6024-0000 0.00 0.000.00 0.00 _____________________________92,034.000.00 LIFE INSURANCE 0.00100-1225-6028-0000 0.00 0.000.00 0.00 _____________________________588.000.00 MEDICARE 0.00100-1225-6034-0000 0.00 0.000.00 0.00 _____________________________10,076.000.00 RECRUITMENT AND HIRING COS…0.00100-1225-6050-0000 0.00 0.000.00 0.00 500.00_____________________________0.00 0.00 0.00 500.00 971,426.000.000.000.00 0.00Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS OFFICE SUPPLIES 0.00100-1225-7025-0000 0.00 0.000.00 0.00 650.00 650.000.00 DUES & SUBSCRIPTIONS 0.00100-1225-7030-0000 0.00 0.000.00 0.00 730.00 730.000.00 BANKING FEES 0.00100-1225-7051-0000 0.00 0.000.00 0.00 _____________________________6,500.000.00 CREDIT CARD FEES 0.00100-1225-7052-0000 0.00 0.000.00 0.00 _____________________________70,000.000.00 PERMITS, FEES AND LICENSES 0.00100-1225-7053-0000 0.00 0.000.00 0.00 150.00 150.000.00 UNIFORMS 0.00100-1225-7065-0000 0.00 0.000.00 0.00 180.00 180.000.00 TRAVEL, EDUCATION, TRAINING 0.00100-1225-7066-0000 0.00 0.000.00 0.00 1,800.00 1,800.000.00 CONTRACTUAL SERVICES 0.00100-1225-7068-0000 0.00 0.000.00 0.00 56,000.00 56,000.000.00 SPECIAL DEPT SUPPLIES 0.00100-1225-7070-0000 0.00 0.000.00 0.00 100.00 400.000.00 EQUIPMENT SUPPLIES/MAINT 0.00100-1225-7090-0000 0.00 0.000.00 0.00 930.00_____________________________0.00 0.00 0.00 60,540.00 136,410.000.000.000.00 0.00Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 0.00100-1225-8040-0000 0.00 0.000.00 0.00 2,750.00_____________________________0.00 FURNITURE & FIXTURES 0.00100-1225-8050-0000 0.00 0.000.00 0.00 200.00 200.000.00 0.00 0.00 2,950.00 200.000.000.000.00 0.00Category: 70 - CAPITAL IMPROVEMENTS Total: 0.00 0.00 63,990.00 1,108,036.000.000.000.00 0.00Department: 1225 - FINANCE AND BUDGETING Total: DRAFT Page 22 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 11 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1230 - I.T. Category: 60 - PERSONNEL SERVICES SALARIES 0.00100-1230-6010-0000 0.00 0.000.00 0.00 _____________________________122,148.000.00 OVERTIME 0.00100-1230-6012-0000 0.00 0.000.00 0.00 _____________________________500.000.00 ACCRUED TIME CASH OUT 0.00100-1230-6016-0000 0.00 0.000.00 0.00 _____________________________2,216.000.00 HEALTH INSURANCE 0.00100-1230-6020-0000 0.00 0.000.00 0.00 _____________________________18,000.000.00 WORKERS COMP 0.00100-1230-6022-0000 0.00 0.000.00 0.00 _____________________________7,940.000.00 DISABILITY 0.00100-1230-6023-0000 0.00 0.000.00 0.00 _____________________________526.000.00 P.E.R.S./P.E.P.R.A.0.00100-1230-6024-0000 0.00 0.000.00 0.00 _____________________________23,944.000.00 LIFE INSURANCE 0.00100-1230-6028-0000 0.00 0.000.00 0.00 _____________________________84.000.00 MEDICARE 0.00100-1230-6034-0000 0.00 0.000.00 0.00 _____________________________1,811.000.00 0.00 0.00 0.00 177,169.000.000.000.00 0.00Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 0.00100-1230-7015-0000 0.00 0.000.00 0.00 _____________________________147,910.000.00 OFFICE SUPPLIES 0.00100-1230-7025-0000 0.00 0.000.00 0.00 _____________________________800.000.00 DUES & SUBSCRIPTIONS 0.00100-1230-7030-0000 0.00 0.000.00 0.00 _____________________________200.000.00 FUEL 0.00100-1230-7050-0000 0.00 0.000.00 0.00 _____________________________2,500.000.00 TRAVEL, EDUCATION, TRAINING 0.00100-1230-7066-0000 0.00 0.000.00 0.00 _____________________________2,500.000.00 CONTRACTUAL SERVICES 0.00100-1230-7068-0000 0.00 0.000.00 0.00 _____________________________194,430.000.00 SOFTWARE 0.00100-1230-7071-0000 0.00 0.000.00 0.00 _____________________________264,725.000.00 COMPUTER SUPPLIES/MAINT 0.00100-1230-7072-0000 0.00 0.000.00 0.00 _____________________________20,150.000.00 EQUIPMENT LEASING/RENTAL 0.00100-1230-7075-0000 0.00 0.000.00 0.00 _____________________________76,510.000.00 SECURITY SERVICES 0.00100-1230-7087-0000 0.00 0.000.00 0.00 _____________________________9,334.000.00 EQUIPMENT SUPPLIES/MAINT 0.00100-1230-7090-0000 0.00 0.000.00 0.00 _____________________________1,930.000.00 0.00 0.00 0.00 720,989.000.000.000.00 0.00Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 0.00100-1230-8040-0000 0.00 0.000.00 0.00 _____________________________2,750.000.00 0.00 0.00 0.00 2,750.000.000.000.00 0.00Category: 70 - CAPITAL IMPROVEMENTS Total: 0.00 0.00 0.00 900,908.000.000.000.00 0.00Department: 1230 - I.T. Total: DRAFT Page 23 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 12 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1240 - RISK AND HUMAN RESOURCES Category: 60 - PERSONNEL SERVICES SALARIES 0.00100-1240-6010-0000 0.00 0.000.00 0.00 _____________________________239,286.000.00 OVERTIME 0.00100-1240-6012-0000 0.00 0.000.00 0.00 _____________________________500.000.00 ACCRUED TIME CASH OUT 0.00100-1240-6016-0000 0.00 0.000.00 0.00 _____________________________7,427.000.00 HEALTH INSURANCE 0.00100-1240-6020-0000 0.00 0.000.00 0.00 _____________________________36,000.000.00 WORKERS COMP 0.00100-1240-6022-0000 0.00 0.000.00 0.00 _____________________________15,554.000.00 DISABILITY 0.00100-1240-6023-0000 0.00 0.000.00 0.00 _____________________________1,052.000.00 P.E.R.S./P.E.P.R.A.0.00100-1240-6024-0000 0.00 0.000.00 0.00 _____________________________46,907.000.00 LIFE INSURANCE 0.00100-1240-6028-0000 0.00 0.000.00 0.00 _____________________________168.000.00 MEDICARE 0.00100-1240-6034-0000 0.00 0.000.00 0.00 _____________________________3,585.000.00 RECRUITMENT AND HIRING COS…0.00100-1240-6050-0000 0.00 0.000.00 0.00 _____________________________1,500.000.00 0.00 0.00 0.00 351,979.000.000.000.00 0.00Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS DUES & SUBSCRIPTIONS 0.00100-1240-7030-0000 0.00 0.000.00 0.00 _____________________________560.000.00 TRAVEL, EDUCATION, TRAINING 0.00100-1240-7066-0000 0.00 0.000.00 0.00 _____________________________4,000.000.00 CONTRACTUAL SERVICES 0.00100-1240-7068-0000 0.00 0.000.00 0.00 _____________________________85,500.000.00 SPECIAL DEPT SUPPLIES 0.00100-1240-7070-0000 0.00 0.000.00 0.00 _____________________________2,800.000.00 INSURANCE 0.00100-1240-7080-0000 0.00 0.000.00 0.00 _____________________________750,000.000.00 0.00 0.00 0.00 842,860.000.000.000.00 0.00Category: 65 - OPERATING COSTS Total: 0.00 0.00 0.00 1,194,839.000.000.000.00 0.00Department: 1240 - RISK AND HUMAN RESOURCES Total: DRAFT Page 24 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 13 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1300 - LEGAL Category: 60 - PERSONNEL SERVICES SALARIES 0.00100-1300-6010-0000 0.00 0.000.00 1,105.28 __________________________________________________________0.00 P.E.R.S./P.E.P.R.A.0.00100-1300-6024-0000 0.00 0.000.00 -1,712.22 __________________________________________________________0.00 LIFE INSURANCE 0.00100-1300-6028-0000 0.00 0.000.00 -8.00 __________________________________________________________0.00 MEDICARE 0.00100-1300-6034-0000 0.00 0.000.00 80.13 __________________________________________________________0.00 0.00 0.00 0.00 0.000.00-534.810.00 0.00Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS OFFICE SUPPLIES 0.00100-1300-7025-0000 0.00 0.000.00 3.59 __________________________________________________________0.00 LOCAL MEETINGS 0.00100-1300-7035-0000 0.00 4,146.980.00 0.00 __________________________________________________________0.00 CONTRACTUAL SERVICES 750,000.00100-1300-7068-000A 1,500,000.00 551,512.501,027,595.00 1,010,458.74 __________________________________________________________1,683.85 CONTRACTUAL SERVICES 0.00100-1300-7068-000B 375,000.00 2,667,474.460.00 0.00 750,000.00 750,000.00817,605.77 INSURANCE 745,045.00100-1300-7080-0000 425,000.00 177,766.62400,000.00 398,594.00 750,000.00_____________________________745,044.02 1,495,045.00 1,564,333.64 1,500,000.00 750,000.002,300,000.001,409,056.331,427,595.00 3,400,900.56Category: 65 - OPERATING COSTS Total: 1,495,045.00 1,564,333.64 1,500,000.00 750,000.002,300,000.001,408,521.521,427,595.00 3,400,900.56Department: 1300 - LEGAL Total:DRAFT Page 25 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 14 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1350 - COMMUNITY DEVELOPMENT Category: 60 - PERSONNEL SERVICES SALARIES 216,724.00100-1350-6010-0000 287,024.00 229,069.13207,830.00 178,197.16 _____________________________275,034.00131,668.11 OVERTIME 0.00100-1350-6012-0000 500.00 358.63335.00 786.53 __________________________________________________________0.00 SICK LEAVE 0.00100-1350-6013-0000 0.00 10,560.500.00 31,300.42 __________________________________________________________0.00 HOLIDAY 0.00100-1350-6014-0000 0.00 6,114.460.00 14,512.74 __________________________________________________________8,517.40 VACATION 0.00100-1350-6015-0000 0.00 15,268.860.00 19,503.90 __________________________________________________________6,659.95 ACCRUED TIME CASH OUT 8,250.00100-1350-6016-0000 0.00 0.0014,030.00 0.00 _____________________________7,870.000.00 OTHER COMPENSATION 0.00100-1350-6018-0000 0.00 0.000.00 0.00 __________________________________________________________4,979.13 HEALTH INSURANCE 9,000.00100-1350-6020-0000 43,560.00 32,205.8249,375.00 17,877.73 _____________________________36,000.00-446.30 DENTAL INSURANCE 850.00100-1350-6021-0000 0.00 1,523.166,318.00 1,271.75 __________________________________________________________709.23 WORKERS COMP 12,786.00100-1350-6022-0000 13,605.00 14,855.6111,770.00 16,477.39 _____________________________18,001.007,477.52 DISABILITY 1,337.00100-1350-6023-0000 1,924.00 1,794.121,560.00 1,158.69 _____________________________1,052.001,121.58 P.E.R.S./P.E.P.R.A.25,548.00100-1350-6024-0000 54,665.00 56,172.8346,834.00 41,783.89 _____________________________39,387.0017,364.87 UNEMPLOYMENT 0.00100-1350-6025-0000 0.00 1.500.00 87.51 __________________________________________________________0.00 DEFERRED COMP 5,300.00100-1350-6026-0000 0.00 5,839.879,821.00 7,091.61 __________________________________________________________4,163.50 VISION CARE 240.00100-1350-6027-0000 0.00 370.68469.00 244.93 __________________________________________________________196.18 LIFE INSURANCE 121.00100-1350-6028-0000 288.00 270.00256.00 158.97 _____________________________168.00106.87 MEDICARE 2,448.00100-1350-6034-0000 4,169.00 3,690.483,222.00 3,409.40 _____________________________4,102.002,146.90 FICA/PARS 39.00100-1350-6035-0000 0.00 38.100.00 42.60 _____________________________78.0029.10 RECRUITMENT AND HIRING COS…2,000.00100-1350-6050-0000 0.00 0.000.00 0.00 __________________________________________________________1,461.50 284,643.00 186,155.54 0.00 381,692.00405,735.00333,905.22351,820.00 378,133.75Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 700.00100-1350-7015-0000 1,200.00 925.00600.00 38.01 700.00_____________________________100.00 ADVERTISING 4,000.00100-1350-7020-0000 2,000.00 3,525.632,000.00 2,211.43 4,000.00 3,500.002,937.75 OFFICE SUPPLIES 1,500.00100-1350-7025-0000 1,500.00 1,819.201,630.00 902.25 750.00 325.00240.21 HEALTH/FITNESS 0.00100-1350-7027-0000 0.00 0.001,302.00 4,433.69 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 1,000.00100-1350-7030-0000 500.00 450.00660.00 425.00 1,224.00 1,084.00574.00 LOCAL MEETINGS 5,000.00100-1350-7035-0000 5,500.00 123.89635.00 509.50 10,500.00 10,500.002,842.21 PERMITS, FEES AND LICENSES 0.00100-1350-7053-0000 0.00 0.000.00 0.00 __________________________________________________________220.72 PLAN CHECK FEES 90,000.00100-1350-7063-0000 0.00 0.000.00 0.00 125,000.00 77,000.0028,054.25 UNIFORMS 1,250.00100-1350-7065-0000 1,000.00 852.61270.00 606.29 1,000.00 550.00749.93 DRAFT Page 26 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 15 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets CONTRACTUAL SERVICES 75,000.00100-1350-7068-0000 366,504.00 95,382.27255,330.00 88,465.22 215,000.00 38,500.0055,232.48 SPECIAL DEPT SUPPLIES 2,500.00100-1350-7070-0000 12,875.00 1,324.5312,875.00 10,292.92 2,000.00 2,000.00399.37 SOFTWARE 55,000.00100-1350-7071-0000 130,000.00 74,525.230.00 0.00 66,600.00_____________________________8,078.00 COMPUTER SUPPLIES/MAINT 0.00100-1350-7072-0000 0.00 233.270.00 583.17 1,000.00_____________________________112.78 EQUIPMENT LEASING/RENTAL 3,500.00100-1350-7075-0000 0.00 360.440.00 0.00 3,500.00_____________________________2,049.28 EQUIPMENT SUPPLIES/MAINT 1,000.00100-1350-7090-0000 0.00 0.000.00 0.00 1,000.00 1,000.00281.09 240,450.00 101,872.07 432,274.00 134,459.00521,079.00108,467.48275,302.00 179,522.07Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 2,000.00100-1350-8040-0000 15,000.00 3,375.000.00 1,694.86 __________________________________________________________0.00 FURNITURE & FIXTURES 0.00100-1350-8050-0000 0.00 0.000.00 0.00 1,200.00_____________________________0.00 2,000.00 0.00 1,200.00 0.0015,000.001,694.860.00 3,375.00Category: 70 - CAPITAL IMPROVEMENTS Total: 527,093.00 288,027.61 433,474.00 516,151.00941,814.00444,067.56627,122.00 561,030.82Department: 1350 - COMMUNITY DEVELOPMENT Total:DRAFT Page 27 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 16 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 1550 - COMMUNITY SERVICES Category: 60 - PERSONNEL SERVICES SALARIES 391,320.00100-1550-6010-0000 236,458.00 227,104.520.00 231,847.07 _____________________________420,768.00257,769.22 OVERTIME 500.00100-1550-6012-0000 500.00 1,784.16680.00 594.10 _____________________________500.003,889.17 SICK LEAVE 0.00100-1550-6013-0000 0.00 2,180.420.00 2,699.56 __________________________________________________________11,278.30 HOLIDAY 0.00100-1550-6014-0000 0.00 2,984.760.00 5,572.48 __________________________________________________________13,485.79 VACATION 0.00100-1550-6015-0000 0.00 5,588.270.00 8,527.60 __________________________________________________________13,722.43 ACCRUED TIME CASH OUT 11,125.00100-1550-6016-0000 0.00 147.1222,000.00 1,291.18 _____________________________14,108.001,241.33 OTHER COMPENSATION 0.00100-1550-6018-0000 0.00 5,717.650.00 0.00 __________________________________________________________9,042.60 FIRST AID 0.00100-1550-6019-0000 0.00 0.000.00 0.00 __________________________________________________________66.00 HEALTH INSURANCE 35,675.00100-1550-6020-0000 72,600.00 12,267.6019,385.00 25,057.28 _____________________________153,000.0019,758.95 DENTAL INSURANCE 1,720.00100-1550-6021-0000 0.00 1,122.606,502.00 2,138.57 __________________________________________________________1,569.26 WORKERS COMP 23,200.00100-1550-6022-0000 8,710.00 13,218.5615,960.00 19,515.56 _____________________________27,350.0013,162.44 DISABILITY 2,170.00100-1550-6023-0000 1,199.00 1,416.001,260.00 1,567.80 _____________________________6,838.001,633.97 P.E.R.S./P.E.P.R.A.47,400.00100-1550-6024-0000 35,729.00 47,305.1940,772.00 50,098.47 _____________________________57,262.0034,166.68 UNEMPLOYMENT 0.00100-1550-6025-0000 0.00 1,602.000.00 10,594.59 __________________________________________________________0.00 DEFERRED COMP 0.00100-1550-6026-0000 0.00 0.0014,583.00 6,869.28 __________________________________________________________0.00 VISION CARE 300.00100-1550-6027-0000 0.00 186.06209.00 290.10 __________________________________________________________260.59 LIFE INSURANCE 400.00100-1550-6028-0000 192.00 228.00227.00 264.00 _____________________________1,092.00308.00 MEDICARE 5,850.00100-1550-6034-0000 3,436.00 3,654.383,868.00 4,238.29 _____________________________6,313.004,515.73 FICA/PARS 831.00100-1550-6035-0000 0.00 846.520.00 739.43 _____________________________1,536.00614.13 RECRUITMENT AND HIRING COS…1,000.00100-1550-6050-0000 0.00 0.000.00 0.00 __________________________________________________________629.00 521,491.00 387,113.59 0.00 688,767.00358,824.00371,905.36125,446.00 327,353.81Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS UTILITIES 60,000.00100-1550-7010-0000 60,000.00 47,133.3260,000.00 49,606.17 4,525.00_____________________________36,840.68 TELEPHONE 15,000.00100-1550-7015-0000 9,000.00 12,086.249,000.00 11,429.60 15,000.00_____________________________11,917.58 ADVERTISING 3,750.00100-1550-7020-0000 0.00 0.000.00 0.00 2,000.00_____________________________1,545.00 OFFICE SUPPLIES 2,200.00100-1550-7025-0000 2,000.00 -24.062,000.00 751.14 5,000.00 2,000.00972.73 HEALTH/FITNESS 0.00100-1550-7027-0000 0.00 0.001,716.00 1,600.98 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 0.00100-1550-7030-0000 1,300.00 270.001,300.00 146.98 1,000.00 170.00170.00 VEHICLE MAINTENANCE 500.00100-1550-7037-0000 1,200.00 18.481,200.00 0.00 1,000.00 226.007.53 RECREATION PROGRAMS 65,000.00100-1550-7040-0000 40,000.00 28,266.8922,150.00 24,560.28 75,000.00 44,000.0064,958.41 DRAFT Page 28 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 17 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets PAGEANT PROGRAM 250.00100-1550-7041-0000 0.00 3,988.190.00 -1,878.69 __________________________________________________________1,901.35 SPECIAL COMMUNITY PROGRAMS 101,650.00100-1550-7046-0000 0.00 0.000.00 0.00 __________________________________________________________816.50 SPECIAL COMMUNITY EVENTS 0.00100-1550-7049-0000 0.00 0.000.00 -50.00 __________________________________________________________110,000.00 FUEL 3,400.00100-1550-7050-0000 8,400.00 4,857.229,000.00 5,966.94 6,000.00 2,000.001,852.22 PERMITS, FEES AND LICENSES 2,400.00100-1550-7053-0000 0.00 706.000.00 0.00 2,400.00 1,020.001,714.00 UNIFORMS 1,650.00100-1550-7065-0000 350.00 1,014.03350.00 337.18 2,000.00 1,320.001,216.98 CONTRACTUAL SERVICES 9,400.00100-1550-7068-0000 19,000.00 9,770.7819,000.00 11,809.19 12,000.00 5,168.005,655.31 SPECIAL DEPT SUPPLIES 2,000.00100-1550-7070-0000 2,000.00 4,161.262,000.00 1,326.31 5,500.00 1,500.003,291.11 COMPUTER SUPPLIES/MAINT 0.00100-1550-7072-0000 0.00 0.000.00 34.47 __________________________________________________________0.00 EQUIPMENT LEASING/RENTAL 2,200.00100-1550-7075-0000 0.00 4,463.770.00 2,016.47 2,200.00_____________________________2,385.92 BUILDING SUPPLIES/MAINT 22,000.00100-1550-7085-0000 20,000.00 18,446.7820,000.00 14,668.97 3,000.00 600.0019,674.70 SECURITY SERVICES 2,650.00100-1550-7087-0000 0.00 169.500.00 0.00 __________________________________________________________1,690.00 EQUIPMENT SUPPLIES/MAINT 1,010.00100-1550-7090-0000 0.00 0.000.00 0.00 2,000.00 2,000.003,231.79 295,060.00 269,841.81 138,625.00 60,004.00163,250.00122,325.99147,716.00 135,328.40Category: 65 - OPERATING COSTS Total: 816,551.00 656,955.40 138,625.00 748,771.00522,074.00494,231.35273,162.00 462,682.21Department: 1550 - COMMUNITY SERVICES Total:DRAFT Page 29 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 18 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2000 - ANIMAL CONTROL Category: 60 - PERSONNEL SERVICES SALARIES 292,875.00100-2000-6010-0000 279,641.00 246,821.43365,198.00 311,304.19 _____________________________140,773.00209,230.58 OVERTIME 3,000.00100-2000-6012-0000 3,000.00 2,179.884,330.00 4,304.41 _____________________________2,000.003,677.65 SICK LEAVE 0.00100-2000-6013-0000 0.00 6,223.500.00 12,182.16 __________________________________________________________10,287.13 HOLIDAY 0.00100-2000-6014-0000 0.00 17,676.820.00 16,581.74 __________________________________________________________21,674.46 VACATION 0.00100-2000-6015-0000 0.00 19,085.870.00 31,585.70 __________________________________________________________15,122.50 ACCRUED TIME CASH OUT 3,595.00100-2000-6016-0000 0.00 0.0024,000.00 0.00 _____________________________2,574.00321.70 OTHER COMPENSATION 0.00100-2000-6018-0000 0.00 0.000.00 0.00 __________________________________________________________2,666.37 FIRST AID 0.00100-2000-6019-0000 0.00 2,543.380.00 0.00 __________________________________________________________0.00 HEALTH INSURANCE 91,200.00100-2000-6020-0000 58,080.00 72,133.0364,325.00 70,158.53 _____________________________36,000.0071,758.52 DENTAL INSURANCE 4,400.00100-2000-6021-0000 0.00 3,916.967,722.00 4,529.42 __________________________________________________________4,001.47 WORKERS COMP 16,725.00100-2000-6022-0000 13,605.00 16,687.0019,380.00 26,650.60 _____________________________9,150.0011,939.33 DISABILITY 2,250.00100-2000-6023-0000 1,935.00 1,927.512,540.00 2,303.60 _____________________________1,052.001,958.25 P.E.R.S./P.E.P.R.A.36,700.00100-2000-6024-0000 55,560.00 46,808.3569,442.00 80,574.77 _____________________________27,595.0028,119.09 DEFERRED COMP 0.00100-2000-6026-0000 0.00 0.008,811.00 16,210.70 __________________________________________________________0.00 VISION CARE 185.00100-2000-6027-0000 0.00 275.29381.00 527.14 __________________________________________________________167.64 LIFE INSURANCE 340.00100-2000-6028-0000 384.00 408.68515.00 435.10 _____________________________168.00308.00 MEDICARE 4,100.00100-2000-6034-0000 4,098.00 4,276.965,706.00 5,643.58 _____________________________2,108.003,673.38 RECRUITMENT AND HIRING COS…0.00100-2000-6050-0000 0.00 0.000.00 0.00 __________________________________________________________1,196.25 455,370.00 386,102.32 0.00 221,420.00416,303.00582,991.64572,350.00 440,964.66Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 0.00100-2000-7015-0000 0.00 350.00500.00 162.66 480.00_____________________________0.00 OFFICE SUPPLIES 1,850.00100-2000-7025-0000 250.00 0.00250.00 147.40 500.00 2,733.00755.03 HEALTH/FITNESS 0.00100-2000-7027-0000 0.00 0.001,716.00 2,763.86 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 0.00100-2000-7030-0000 0.00 0.000.00 0.00 _____________________________100.000.00 LOCAL MEETINGS 180.00100-2000-7035-0000 0.00 0.00500.00 0.00 200.00_____________________________75.00 VEHICLE MAINTENANCE 0.00100-2000-7037-0000 700.00 0.00400.00 2,481.06 1,000.00 1,800.000.00 FUEL 12,000.00100-2000-7050-0000 18,840.00 10,647.5916,000.00 13,681.60 18,000.00 1,500.0012,527.05 PERMITS, FEES AND LICENSES 0.00100-2000-7053-0000 0.00 0.000.00 0.00 __________________________________________________________15,226.38 UNIFORMS 1,100.00100-2000-7065-0000 4,000.00 3,850.114,000.00 4,410.96 __________________________________________________________450.00 TRAVEL, EDUCATION, TRAINING 0.00100-2000-7066-0000 0.00 0.000.00 0.00 _____________________________1,945.000.00 DRAFT Page 30 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 19 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets CONTRACTUAL SERVICES 100,000.00100-2000-7068-0000 175,000.00 93,181.16150,000.00 102,646.43 147,100.00 66,000.0076,409.51 SPECIAL DEPT SUPPLIES 5,000.00100-2000-7070-0000 4,175.00 2,412.914,075.00 699.85 1,200.00 2,345.001,787.92 COMPUTER SUPPLIES/MAINT 0.00100-2000-7072-0000 0.00 0.000.00 0.00 __________________________________________________________0.00 EQUIPMENT LEASING/RENTAL 0.00100-2000-7075-0000 0.00 0.000.00 0.00 9,000.00_____________________________0.00 BUILDING SUPPLIES/MAINT 0.00100-2000-7085-0000 0.00 42.920.00 0.00 3,200.00_____________________________0.00 120,130.00 107,230.89 180,680.00 76,423.00202,965.00126,993.82177,441.00 110,484.69Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 35,000.00100-2000-8040-0000 0.00 0.000.00 0.00 __________________________________________________________0.00 35,000.00 0.00 0.00 0.000.000.000.00 0.00Category: 70 - CAPITAL IMPROVEMENTS Total: 610,500.00 493,333.21 180,680.00 297,843.00619,268.00709,985.46749,791.00 551,449.35Department: 2000 - ANIMAL CONTROL Total: DRAFT Page 31 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 20 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2030 - COMMUNITY ENHANCEMENT Category: 60 - PERSONNEL SERVICES SALARIES 92,050.00100-2030-6010-0000 67,748.00 55,914.760.00 0.00 _____________________________136,153.0048,407.39 OVERTIME 2,000.00100-2030-6012-0000 1,000.00 0.000.00 0.00 _____________________________2,000.000.00 SICK LEAVE 0.00100-2030-6013-0000 0.00 973.090.00 0.00 __________________________________________________________868.59 HOLIDAY 0.00100-2030-6014-0000 0.00 1,412.550.00 0.00 __________________________________________________________5,139.16 VACATION 0.00100-2030-6015-0000 0.00 5,689.440.00 0.00 __________________________________________________________4,696.82 ACCRUED TIME CASH OUT 2,340.00100-2030-6016-0000 0.00 0.000.00 0.00 _____________________________2,453.000.00 OTHER COMPENSATION 0.00100-2030-6018-0000 0.00 0.000.00 0.00 __________________________________________________________850.00 HEALTH INSURANCE 10,000.00100-2030-6020-0000 14,520.00 62.620.00 0.00 _____________________________36,000.00-546.00 DENTAL INSURANCE 210.00100-2030-6021-0000 0.00 190.410.00 0.00 __________________________________________________________190.41 WORKERS COMP 4,540.00100-2030-6022-0000 2,725.00 3,088.170.00 0.00 _____________________________8,850.002,324.08 DISABILITY 550.00100-2030-6023-0000 479.00 439.010.00 0.00 _____________________________1,052.00449.57 P.E.R.S./P.E.P.R.A.12,675.00100-2030-6024-0000 13,455.00 11,137.650.00 0.00 _____________________________26,690.006,583.75 VISION CARE 110.00100-2030-6027-0000 0.00 90.950.00 0.00 __________________________________________________________92.95 LIFE INSURANCE 170.00100-2030-6028-0000 96.00 82.000.00 0.00 _____________________________168.0077.00 MEDICARE 1,905.00100-2030-6034-0000 997.00 941.140.00 0.00 _____________________________2,039.00846.42 RECRUITMENT AND HIRING COS…1,000.00100-2030-6050-0000 0.00 0.000.00 0.00 __________________________________________________________300.00 127,550.00 70,280.14 0.00 215,405.00101,020.000.000.00 80,021.79Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 325.00100-2030-7015-0000 0.00 101.200.00 0.00 480.00_____________________________270.81 OFFICE SUPPLIES 0.00100-2030-7025-0000 0.00 22.970.00 0.00 700.00 2,038.000.00 DUES & SUBSCRIPTIONS 0.00100-2030-7030-0000 0.00 0.000.00 0.00 _____________________________190.0095.00 LOCAL MEETINGS 0.00100-2030-7035-0000 0.00 0.000.00 0.00 500.00 100.0028.00 VEHICLE MAINTENANCE 0.00100-2030-7037-0000 0.00 262.620.00 0.00 _____________________________500.000.00 CODE ENFORCEMENT 40,000.00100-2030-7039-0000 0.00 44,448.640.00 29,846.85 38,000.00 37,500.0012,251.60 FUEL 600.00100-2030-7050-0000 0.00 639.240.00 0.00 2,400.00 1,240.00416.45 UNIFORMS 360.00100-2030-7065-0000 0.00 1,268.790.00 0.00 __________________________________________________________150.00 TRAVEL, EDUCATION, TRAINING 0.00100-2030-7066-0000 0.00 0.000.00 0.00 _____________________________1,880.000.00 CONTRACTUAL SERVICES 15,000.00100-2030-7068-0000 0.00 11,340.970.00 0.00 730.00_____________________________6,481.63 SPECIAL DEPT SUPPLIES 500.00100-2030-7070-0000 0.00 31.900.00 0.00 1,900.00 550.00128.36 COMPUTER SUPPLIES/MAINT 3,000.00100-2030-7072-0000 0.00 0.000.00 0.00 __________________________________________________________0.00 DRAFT Page 32 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 21 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets EQUIPMENT LEASING/RENTAL 0.00100-2030-7075-0000 0.00 0.000.00 0.00 6,000.00_____________________________0.00 BUILDING SUPPLIES/MAINT 0.00100-2030-7085-0000 0.00 0.000.00 0.00 1,000.00_____________________________0.00 59,785.00 19,821.85 51,710.00 43,998.000.0029,846.850.00 58,116.33Category: 65 - OPERATING COSTS Total: 187,335.00 90,101.99 51,710.00 259,403.00101,020.0029,846.850.00 138,138.12Department: 2030 - COMMUNITY ENHANCEMENT Total: DRAFT Page 33 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 22 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2040 - PUBLIC SAFETY - OES Category: 65 - OPERATING COSTS GRANT SPECIFIC COSTS (OES)6,000.00100-2040-7036-0000 0.00 2,817.640.00 0.00 6,000.00 6,000.000.00 SPECIAL DEPT SUPPLIES 1,000.00100-2040-7070-0000 0.00 0.000.00 0.00 1,000.00 1,000.000.00 7,000.00 0.00 7,000.00 7,000.000.000.000.00 2,817.64Category: 65 - OPERATING COSTS Total: 7,000.00 0.00 7,000.00 7,000.000.000.000.00 2,817.64Department: 2040 - PUBLIC SAFETY - OES Total: DRAFT Page 34 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 23 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2050 - POLICE Category: 60 - PERSONNEL SERVICES SALARIES 4,405,026.00100-2050-6010-0000 4,172,296.00 3,228,609.863,789,324.00 3,023,802.68 _____________________________4,618,328.003,003,010.07 ADMIN TIME 0.00100-2050-6011-0000 0.00 885.400.00 0.00 __________________________________________________________0.00 OVERTIME 254,300.00100-2050-6012-0000 188,811.00 248,654.29190,722.00 252,494.71 _____________________________200,897.00238,932.91 SICK LEAVE 0.00100-2050-6013-0000 0.00 101,948.840.00 257,181.18 __________________________________________________________77,359.11 HOLIDAY 0.00100-2050-6014-0000 0.00 169,520.500.00 132,099.30 __________________________________________________________180,397.65 VACATION 0.00100-2050-6015-0000 0.00 229,023.900.00 286,874.78 __________________________________________________________196,875.86 ACCRUED TIME CASH OUT 147,750.00100-2050-6016-0000 64,740.00 145,008.80584,500.00 91,400.99 _____________________________307,516.00130,639.19 OTHER COMPENSATION 0.00100-2050-6018-0000 0.00 0.000.00 0.00 __________________________________________________________35,300.00 FIRST AID 18,250.00100-2050-6019-0000 0.00 6,858.590.00 2,472.00 __________________________________________________________9,107.45 HEALTH INSURANCE 704,500.00100-2050-6020-0000 566,282.00 513,936.29632,407.00 590,298.90 _____________________________774,000.00510,248.27 DENTAL INSURANCE 44,000.00100-2050-6021-0000 0.00 45,609.81101,533.00 60,208.36 __________________________________________________________40,262.52 WORKERS COMP 315,750.00100-2050-6022-0000 571,455.00 225,743.61610,200.00 270,325.90 _____________________________300,580.00161,574.40 DISABILITY 29,550.00100-2050-6023-0000 27,395.00 25,816.8225,997.00 25,419.64 _____________________________22,618.0026,558.33 P.E.R.S./P.E.P.R.A.1,591,025.00100-2050-6024-0000 1,405,120.00 1,567,706.461,486,969.00 1,397,624.88 _____________________________1,580,347.001,166,143.93 UNEMPLOYMENT 1,200.00100-2050-6025-0000 0.00 6,248.000.00 0.00 __________________________________________________________7,072.00 DEFERRED COMP 6,200.00100-2050-6026-0000 0.00 9,141.65167,651.00 69,213.42 __________________________________________________________4,137.40 VISION CARE 5,100.00100-2050-6027-0000 0.00 5,398.757,766.00 6,849.26 __________________________________________________________4,492.48 LIFE INSURANCE 3,550.00100-2050-6028-0000 3,744.00 3,444.004,512.00 3,127.11 _____________________________4,614.003,070.06 WORKERS COMP COST 0.00100-2050-6029-0000 0.00 182,931.450.00 208,994.74 __________________________________________________________186,214.86 MEDICARE 66,450.00100-2050-6034-0000 64,443.00 61,363.7366,094.00 60,862.65 _____________________________74,338.0054,577.02 FICA/PARS 300.00100-2050-6035-0000 0.00 98.670.00 806.65 __________________________________________________________127.50 RECRUITMENT AND HIRING COS…15,500.00100-2050-6050-0000 0.00 4,572.070.00 0.00 __________________________________________________________9,967.90 7,608,451.00 6,046,068.91 0.00 7,883,238.007,064,286.006,740,057.157,667,675.00 6,782,521.49Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS UTILITIES 102,000.00100-2050-7010-0000 65,000.00 62,813.1565,000.00 58,568.55 100,000.00_____________________________66,333.58 TELEPHONE 86,000.00100-2050-7015-0000 100,000.00 85,298.0175,000.00 80,523.53 90,000.00_____________________________69,499.38 ADVERTISING 600.00100-2050-7020-0000 0.00 56.310.00 0.00 _____________________________919.45214.93 OFFICE SUPPLIES 18,000.00100-2050-7025-0000 27,000.00 20,853.7230,000.00 26,103.86 18,500.00 21,222.0016,778.33 HEALTH/FITNESS 0.00100-2050-7027-0000 0.00 0.0022,500.00 26,616.13 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 24,400.00100-2050-7030-0000 10,000.00 2,691.8015,000.00 12,060.00 27,000.00 26,165.0029,767.51 DRAFT Page 35 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 24 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets LIVE SCAN-FINGERPRINTING 13,000.00100-2050-7031-0000 12,000.00 980.0024,000.00 3,112.00 22,000.00 22,000.0019,529.00 LOCAL MEETINGS 40,000.00100-2050-7035-0000 40,000.00 38,223.0250,000.00 27,838.07 _____________________________4,400.0026,269.93 VEHICLE MAINTENANCE 175,000.00100-2050-7037-0000 142,480.00 125,694.09200,000.00 113,386.14 140,000.00 44,250.00101,540.70 FUEL 165,000.00100-2050-7050-0000 120,000.00 120,952.21168,630.00 111,918.64 140,000.00 99,274.00112,763.39 PERMITS, FEES AND LICENSES 0.00100-2050-7053-0000 0.00 0.000.00 0.00 500.00 500.00505.74 ERICA 215,000.00100-2050-7057-0000 204,000.00 215,151.23225,000.00 137,512.43 234,500.00 234,500.00219,598.63 CLETS SYSTEM 40,000.00100-2050-7058-0000 36,736.00 36,376.0025,000.00 25,729.00 40,000.00 40,000.0025,960.00 UNIFORMS 45,200.00100-2050-7065-0000 25,000.00 66,917.7175,000.00 57,965.54 25,000.00 25,000.0027,385.20 TRAVEL, EDUCATION, TRAINING 18,000.00100-2050-7066-0000 0.00 6,557.0436,000.00 4,081.50 50,000.00 47,650.0010,835.12 CONTRACTUAL SERVICES 105,000.00100-2050-7068-0000 355,146.00 278,981.85353,034.00 246,434.24 86,100.00 85,100.00114,376.54 SPECIAL DEPT SUPPLIES 33,000.00100-2050-7070-0000 35,500.00 34,969.4935,500.00 15,590.48 25,000.00 6,500.0020,795.96 SOFTWARE 301,465.00100-2050-7071-0000 0.00 423.005,500.00 1,678.22 166,200.00_____________________________113,600.77 COMPUTER SUPPLIES/MAINT 6,500.00100-2050-7072-0000 30,000.00 30,405.1815,000.00 10,326.99 5,000.00_____________________________6,288.41 AUDIO VISUAL SUPPLIES/MAINT 0.00100-2050-7074-0000 0.00 0.000.00 676.55 __________________________________________________________0.00 EQUIPMENT LEASING/RENTAL 36,000.00100-2050-7075-0000 0.00 8,927.580.00 4,367.65 29,560.00_____________________________6,221.78 BUILDING SUPPLIES/MAINT 47,300.00100-2050-7085-0000 45,000.00 39,820.7330,000.00 43,587.76 40,000.00_____________________________26,852.57 SECURITY SERVICES 2,700.00100-2050-7087-0000 0.00 0.000.00 0.00 2,700.00_____________________________3,319.51 EQUIPMENT SUPPLIES/MAINT 0.00100-2050-7090-0000 50,000.00 30,850.1047,285.00 15,996.80 5,000.00 4,000.001,136.04 CAL-ID FEE 45,118.00100-2050-7091-0000 41,000.00 42,481.0040,000.00 40,876.00 47,000.00 47,000.0045,118.00 INTERNAL SERVICES 0.00100-2050-7160-0000 0.00 1,994.040.00 0.00 __________________________________________________________0.00 1,519,283.00 1,064,691.02 1,294,060.00 708,480.451,338,862.001,064,950.081,537,449.00 1,251,417.26Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 110,000.00100-2050-8040-0000 192,520.00 4,869.0356,000.00 2,020.00 __________________________________________________________54,898.63 FURNITURE & FIXTURES 0.00100-2050-8050-0000 0.00 1,366.000.00 0.00 __________________________________________________________0.00 VEHICLES 190,000.00100-2050-8060-0000 150,000.00 141,255.240.00 0.00 246,688.36 246,688.36272,666.32 300,000.00 327,564.95 246,688.36 246,688.36342,520.002,020.0056,000.00 147,490.27Category: 70 - CAPITAL IMPROVEMENTS Total: 9,427,734.00 7,438,324.88 1,540,748.36 8,838,406.818,745,668.007,807,027.239,261,124.00 8,181,429.02Department: 2050 - POLICE Total: DRAFT Page 36 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 25 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2080 - K-9 Category: 65 - OPERATING COSTS LOCAL MEETINGS 4,400.00100-2080-7035-0000 0.00 0.000.00 0.00 2,400.00 2,400.001,820.67 VEHICLE MAINTENANCE 0.00100-2080-7037-0000 0.00 0.000.00 0.00 1,300.00 1,300.000.00 CONTRACTUAL SERVICES 125.00100-2080-7060-0000 0.00 230.880.00 0.00 1,000.00 1,000.0042.00 TRAVEL, EDUCATION, TRAINING 1,500.00100-2080-7066-0000 0.00 500.000.00 0.00 1,500.00 1,500.001,250.00 SPECIAL DEPT SUPPLIES 625.00100-2080-7070-0000 0.00 4,467.160.00 0.00 500.00 500.00254.59 6,650.00 3,367.26 6,700.00 6,700.000.000.000.00 5,198.04Category: 65 - OPERATING COSTS Total: 6,650.00 3,367.26 6,700.00 6,700.000.000.000.00 5,198.04Department: 2080 - K-9 Total: DRAFT Page 37 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 26 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2090 - POLICE SUPPORT Category: 60 - PERSONNEL SERVICES SALARIES 987,310.00100-2090-6010-0000 837,680.00 682,251.64857,917.00 685,918.28 _____________________________993,466.00584,494.39 OVERTIME 90,500.00100-2090-6012-0000 22,500.00 84,130.3624,000.00 94,884.93 _____________________________20,500.00106,807.94 SICK LEAVE 0.00100-2090-6013-0000 0.00 15,000.640.00 40,331.80 __________________________________________________________18,564.61 HOLIDAY 0.00100-2090-6014-0000 0.00 34,476.330.00 37,703.85 __________________________________________________________20,392.91 VACATION 0.00100-2090-6015-0000 0.00 51,798.040.00 59,761.98 __________________________________________________________41,452.27 ACCRUED TIME CASH OUT 46,740.00100-2090-6016-0000 12,530.00 2,524.0655,000.00 6,478.13 _____________________________60,223.0011,758.98 OTHER COMPENSATION 0.00100-2090-6018-0000 0.00 5,471.490.00 0.00 __________________________________________________________16,103.57 HEALTH INSURANCE 175,400.00100-2090-6020-0000 188,761.00 146,395.97223,170.00 180,634.08 _____________________________234,000.00125,228.85 DENTAL INSURANCE 10,400.00100-2090-6021-0000 0.00 11,511.1533,092.00 16,632.63 __________________________________________________________9,604.98 WORKERS COMP 58,545.00100-2090-6022-0000 33,200.00 46,206.4842,400.00 66,269.27 _____________________________64,575.0031,865.09 DISABILITY 6,670.00100-2090-6023-0000 5,391.00 5,220.265,733.00 5,683.70 _____________________________6,838.004,717.25 P.E.R.S./P.E.P.R.A.112,610.00100-2090-6024-0000 141,291.00 123,018.54185,295.00 165,296.58 _____________________________170,522.0078,150.10 UNEMPLOYMENT 0.00100-2090-6025-0000 0.00 0.000.00 1,480.60 __________________________________________________________0.00 DEFERRED COMP 4,600.00100-2090-6026-0000 0.00 3,869.4438,565.00 30,910.49 __________________________________________________________2,215.44 VISION CARE 1,100.00100-2090-6027-0000 0.00 1,154.302,447.00 1,912.96 __________________________________________________________858.47 LIFE INSURANCE 1,100.00100-2090-6028-0000 1,152.00 1,055.201,184.00 1,055.45 _____________________________1,092.00869.35 MEDICARE 15,292.00100-2090-6034-0000 12,473.00 12,756.5013,121.00 14,386.50 _____________________________15,576.0011,404.34 FICA/PARS 1,606.00100-2090-6035-0000 0.00 538.200.00 600.30 _____________________________1,606.00776.75 UNIFORMS 0.00100-2090-6036-0000 0.00 0.001,596.00 14,900.00 __________________________________________________________0.00 RECRUITMENT AND HIRING COS…0.00100-2090-6050-0000 0.00 189.000.00 0.00 __________________________________________________________0.00 1,511,873.00 1,065,265.29 0.00 1,568,398.001,254,978.001,424,841.531,483,520.00 1,227,567.60Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 180.00100-2090-7015-0000 0.00 475.001,500.00 -433.19 __________________________________________________________75.00 HEALTH/FITNESS 0.00100-2090-7027-0000 0.00 0.007,398.00 5,796.51 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 0.00100-2090-7030-0000 0.00 0.00100.00 0.00 _____________________________470.000.00 LOCAL MEETINGS 0.00100-2090-7035-0000 0.00 0.00500.00 621.00 __________________________________________________________0.00 UNIFORMS 0.00100-2090-7065-0000 0.00 12,634.24500.00 187.83 __________________________________________________________1,650.00 TRAVEL, EDUCATION, TRAINING 50.00100-2090-7066-0000 0.00 0.005,000.00 5,023.16 _____________________________3,750.0020.00 CONTRACTUAL SERVICES 175.00100-2090-7068-0000 0.00 0.000.00 352.00 __________________________________________________________70.00 COMPUTER SUPPLIES/MAINT 425.00100-2090-7072-0000 0.00 0.000.00 0.00 __________________________________________________________174.56 DRAFT Page 38 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 27 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets BUILDING SUPPLIES/MAINT 0.00100-2090-7085-0000 0.00 52.790.00 0.00 __________________________________________________________0.00 830.00 1,989.56 0.00 4,220.000.0011,547.3114,998.00 13,162.03Category: 65 - OPERATING COSTS Total: 1,512,703.00 1,067,254.85 0.00 1,572,618.001,254,978.001,436,388.841,498,518.00 1,240,729.63Department: 2090 - POLICE SUPPORT Total: DRAFT Page 39 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 28 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2100 - FIRE Category: 65 - OPERATING COSTS UTILITIES 8,000.00100-2100-7010-0000 8,000.00 5,253.257,000.00 6,668.39 9,000.00_____________________________5,681.86 TELEPHONE 0.00100-2100-7015-0000 700.00 0.00600.00 93.12 __________________________________________________________0.00 HEALTH/FITNESS 0.00100-2100-7027-0000 0.00 0.000.00 477.00 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 0.00100-2100-7030-0000 0.00 0.00685.00 304.00 __________________________________________________________0.00 VEHICLE MAINTENANCE 900.00100-2100-7037-0000 0.00 40.752,750.00 0.00 1,000.00 1,000.0012,126.44 FUEL 1,500.00100-2100-7050-0000 0.00 1,156.892,500.00 939.24 1,500.00 1,500.001,235.18 CONTRACTUAL SERVICES 2,850,000.00100-2100-7068-0000 2,740,796.00 2,465,214.862,508,000.00 2,262,204.67 4,200,000.00 4,200,000.001,442,256.63 SPECIAL DEPT SUPPLIES 1,100.00100-2100-7070-0000 0.00 1,906.41500.00 0.00 2,000.00 2,000.001,230.61 SOFTWARE 0.00100-2100-7071-0000 0.00 535.005,000.00 2,597.09 __________________________________________________________2,300.00 MEDICAL/OEM SUPPLIES 1,200.00100-2100-7073-0000 0.00 3,138.250.00 2,834.36 5,000.00 5,000.001,266.60 INSURANCE 0.00100-2100-7080-0000 0.00 0.000.00 0.00 __________________________________________________________706.00 BUILDING SUPPLIES/MAINT 5,000.00100-2100-7085-0000 3,000.00 4,296.101,000.00 86.78 10,000.00_____________________________3,963.67 EQUIPMENT SUPPLIES/MAINT 700.00100-2100-7090-0000 2,000.00 2,000.432,100.00 0.00 500.00 500.001,497.37 2,868,400.00 1,472,264.36 4,229,000.00 4,210,000.002,754,496.002,276,204.652,530,135.00 2,483,541.94Category: 65 - OPERATING COSTS Total: 2,868,400.00 1,472,264.36 4,229,000.00 4,210,000.002,754,496.002,276,204.652,530,135.00 2,483,541.94Department: 2100 - FIRE Total:DRAFT Page 40 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 29 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 2150 - BUILDING AND SAFETY Category: 60 - PERSONNEL SERVICES SALARIES 304,387.00100-2150-6010-0000 248,286.00 230,265.11365,653.00 347,902.78 _____________________________307,057.00222,244.92 OVERTIME 500.00100-2150-6012-0000 0.00 0.000.00 0.00 _____________________________1,500.000.00 SICK LEAVE 0.00100-2150-6013-0000 0.00 3,415.500.00 17,666.68 __________________________________________________________2,997.37 HOLIDAY 0.00100-2150-6014-0000 0.00 6,647.410.00 10,516.77 __________________________________________________________11,514.64 VACATION 0.00100-2150-6015-0000 0.00 7,388.000.00 18,275.55 __________________________________________________________11,896.05 ACCRUED TIME CASH OUT 4,630.00100-2150-6016-0000 0.00 0.0029,000.00 0.00 _____________________________5,501.00173.64 OTHER COMPENSATION 0.00100-2150-6018-0000 0.00 0.000.00 0.00 __________________________________________________________2,787.95 HEALTH INSURANCE 70,923.00100-2150-6020-0000 43,560.00 49,390.6773,241.00 73,391.54 _____________________________72,000.0062,543.33 DENTAL INSURANCE 2,000.00100-2150-6021-0000 0.00 1,573.9211,691.00 4,883.30 __________________________________________________________2,118.50 WORKERS COMP 18,119.00100-2150-6022-0000 8,165.00 14,551.9016,100.00 25,578.26 _____________________________19,959.0011,370.26 DISABILITY 2,053.00100-2150-6023-0000 1,766.00 1,613.522,627.00 2,517.11 _____________________________2,104.001,889.48 P.E.R.S./P.E.P.R.A.49,487.00100-2150-6024-0000 47,842.00 56,538.0584,904.00 81,361.31 _____________________________60,192.0029,806.60 UNEMPLOYMENT 0.00100-2150-6025-0000 0.00 0.000.00 1,248.09 __________________________________________________________0.00 DEFERRED COMP 0.00100-2150-6026-0000 0.00 0.0018,137.00 11,184.80 __________________________________________________________0.00 VISION CARE 190.00100-2150-6027-0000 0.00 224.56909.00 714.87 __________________________________________________________167.64 LIFE INSURANCE 339.00100-2150-6028-0000 288.00 282.00416.00 376.80 _____________________________336.00627.18 MEDICARE 4,492.00100-2150-6034-0000 3,600.00 3,595.855,722.00 5,928.10 _____________________________4,554.003,556.05 UNIFORMS 0.00100-2150-6036-0000 1,200.00 0.001,800.00 170.53 __________________________________________________________0.00 457,120.00 363,693.61 0.00 473,203.00354,707.00601,716.49610,200.00 375,486.49Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 1,800.00100-2150-7015-0000 1,800.00 2,404.031,000.00 316.34 1,800.00_____________________________898.08 ADVERTISING 500.00100-2150-7020-0000 1,000.00 62.400.00 161.29 500.00 300.00228.60 OFFICE SUPPLIES 850.00100-2150-7025-0000 850.00 1,048.75850.00 466.07 850.00 240.00371.14 HEALTH/FITNESS 0.00100-2150-7027-0000 0.00 0.002,802.00 2,151.98 __________________________________________________________0.00 DUES & SUBSCRIPTIONS 450.00100-2150-7030-0000 850.00 275.00850.00 705.00 400.00 570.001,230.00 LOCAL MEETINGS 3,000.00100-2150-7035-0000 6,000.00 3,315.004,465.00 4,177.50 2,440.00 2,440.002,176.89 VEHICLE MAINTENANCE 5,600.00100-2150-7037-0000 4,500.00 4,516.437,500.00 3,580.54 5,000.00 5,000.003,789.07 FUEL 7,630.00100-2150-7050-0000 6,480.00 4,877.719,000.00 5,046.99 7,500.00 4,300.004,132.10 PERMITS, FEES AND LICENSES 0.00100-2150-7053-0000 0.00 0.000.00 0.00 __________________________________________________________25.73 PLAN CHECK FEES 205,000.00100-2150-7063-0000 0.00 178,725.66185,750.00 197,694.49 210,000.00 210,000.00229,178.41 DRAFT Page 41 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 30 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets UNIFORMS 1,600.00100-2150-7065-0000 0.00 3,701.442,010.00 2,744.99 1,600.00 300.00630.79 TRAVEL, EDUCATION, TRAINING 2,500.00100-2150-7066-0000 0.00 0.000.00 0.00 4,000.00 8,500.002,869.47 INSPECTIONS 162,000.00100-2150-7067-0000 0.00 28,395.000.00 0.00 170,000.00 95,000.00135,030.00 CONTRACTUAL SERVICES 0.00100-2150-7068-0000 251,000.00 53,603.281,000.00 248.00 22,000.00 98,000.003.00 SPECIAL DEPT SUPPLIES 3,000.00100-2150-7070-0000 3,500.00 579.663,500.00 3,131.46 4,000.00 3,730.00937.97 COMPUTER SUPPLIES/MAINT 450.00100-2150-7072-0000 0.00 0.000.00 2,496.74 500.00_____________________________780.24 EQUIPMENT SUPPLIES/MAINT 800.00100-2150-7090-0000 0.00 570.340.00 0.00 400.00 1,095.0090.03 395,180.00 382,371.52 430,990.00 429,475.00275,980.00222,921.39218,727.00 282,074.70Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS FURNITURE & FIXTURES 0.00100-2150-8050-0000 0.00 0.000.00 0.00 4,500.00_____________________________0.00 VEHICLES 0.00100-2150-8060-0000 0.00 0.000.00 0.00 32,500.00 34,000.000.00 0.00 0.00 37,000.00 34,000.000.000.000.00 0.00Category: 70 - CAPITAL IMPROVEMENTS Total: 852,300.00 746,065.13 467,990.00 936,678.00630,687.00824,637.88828,927.00 657,561.19Department: 2150 - BUILDING AND SAFETY Total:DRAFT Page 42 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 31 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 3100 - ENGINEERING AND PUBLIC WORKS Category: 60 - PERSONNEL SERVICES SALARIES 375,750.00100-3100-6010-0000 152,203.00 183,779.010.00 3,898.75 _____________________________252,089.00279,586.59 OVERTIME 2,875.00100-3100-6012-0000 0.00 1,683.650.00 0.00 _____________________________2,875.002,329.12 SICK LEAVE 0.00100-3100-6013-0000 0.00 237.690.00 0.00 __________________________________________________________9,255.07 HOLIDAY 0.00100-3100-6014-0000 0.00 950.760.00 0.00 __________________________________________________________14,010.04 VACATION 0.00100-3100-6015-0000 0.00 4,532.960.00 0.00 __________________________________________________________10,471.12 ACCRUED TIME CASH OUT 4,890.00100-3100-6016-0000 0.00 373.480.00 0.00 _____________________________5,518.00441.55 OTHER COMPENSATION 0.00100-3100-6018-0000 0.00 6,803.920.00 0.00 __________________________________________________________9,750.40 HEALTH INSURANCE 54,500.00100-3100-6020-0000 0.00 15,783.750.00 0.00 _____________________________67,500.0043,137.46 DENTAL INSURANCE 4,000.00100-3100-6021-0000 43,560.00 1,849.440.00 0.00 __________________________________________________________3,548.33 WORKERS COMP 16,500.00100-3100-6022-0000 16,325.00 11,095.160.00 139.28 _____________________________10,050.0012,002.31 DISABILITY 2,050.00100-3100-6023-0000 1,038.00 -224.690.00 0.00 _____________________________1,447.002,126.80 P.E.R.S./P.E.P.R.A.47,200.00100-3100-6024-0000 27,882.00 40,697.660.00 2,408.76 _____________________________37,215.0037,417.00 VISION CARE 480.00100-3100-6027-0000 0.00 140.460.00 0.00 __________________________________________________________441.21 LIFE INSURANCE 165.00100-3100-6028-0000 288.00 203.000.00 0.00 _____________________________315.00204.00 MEDICARE 5,010.00100-3100-6034-0000 2,207.00 2,788.800.00 267.20 _____________________________3,130.004,608.22 RECRUITMENT AND HIRING COS…1,000.00100-3100-6050-0000 0.00 1,250.000.00 0.00 1,000.00_____________________________343.50 514,420.00 429,672.72 1,000.00 380,139.00243,503.006,713.990.00 271,945.05Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS UTILITIES 0.00100-3100-7010-0000 0.00 -710.240.00 0.00 __________________________________________________________0.00 TELEPHONE 2,900.00100-3100-7015-0000 2,500.00 3,146.410.00 430.09 3,000.00_____________________________2,082.25 ADVERTISING 1,900.00100-3100-7020-0000 0.00 725.742,000.00 0.00 2,000.00 1,200.001,156.20 OFFICE SUPPLIES 3,800.00100-3100-7025-0000 4,000.00 1,341.39400.00 23.02 3,000.00 1,850.002,202.37 HEALTH/FITNESS 0.00100-3100-7027-0000 0.00 0.000.00 0.00 __________________________________________________________150.00 DUES & SUBSCRIPTIONS 8,500.00100-3100-7030-0000 500.00 158.8780.00 0.00 500.00_____________________________3,494.79 LOCAL MEETINGS 0.00100-3100-7035-0000 1,250.00 1,548.00500.00 15.00 2,000.00_____________________________1,071.02 VEHICLE MAINTENANCE 1,400.00100-3100-7037-0000 0.00 0.000.00 0.00 1,000.00 500.00239.03 FUEL 3,500.00100-3100-7050-0000 6,720.00 635.950.00 9,601.00 3,600.00 700.0037.36 PERMITS, FEES AND LICENSES 0.00100-3100-7053-0000 0.00 27,272.760.00 0.00 _____________________________24,500.0024,519.38 PLAN CHECK FEES 1,350,000.00100-3100-7063-0000 0.00 257,292.180.00 0.00 1,000,000.00 475,000.00349,081.35 STORM WATER INSPECTIONS 60,000.00100-3100-7064-0000 0.00 38,494.070.00 0.00 35,000.00 75,000.0054,958.48 DRAFT Page 43 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 32 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets UNIFORMS 3,000.00100-3100-7065-0000 2,400.00 706.911,200.00 0.00 3,000.00 900.001,578.54 TRAVEL, EDUCATION, TRAINING 0.00100-3100-7066-0000 0.00 0.000.00 0.00 _____________________________1,180.000.00 INSPECTIONS 350,000.00100-3100-7067-0000 0.00 259,179.760.00 0.00 500,000.00 436,800.00367,425.66 CONTRACTUAL SERVICES 290,000.00100-3100-7068-0000 1,250,000.00 517,534.742,575,897.00 4,138,061.73 550,000.00 58,500.00135,064.51 CONTRACTUAL SERVICES 0.00100-3100-7068-000A 2,600,000.00 285,427.221,253,000.00 970,486.91 __________________________________________________________0.00 SPECIAL DEPT SUPPLIES 1,000.00100-3100-7070-0000 4,500.00 130.580.00 0.00 _____________________________4,870.00606.88 SOFTWARE 575.00100-3100-7071-0000 0.00 0.000.00 0.00 __________________________________________________________1,302.84 COMPUTER SUPPLIES/MAINT 1,800.00100-3100-7072-0000 0.00 1,180.970.00 0.00 __________________________________________________________1,128.21 EQUIPMENT LEASING/RENTAL 3,600.00100-3100-7075-0000 0.00 360.330.00 0.00 __________________________________________________________2,048.77 EQUIPMENT SUPPLIES/MAINT 500.00100-3100-7090-0000 1,500.00 0.000.00 0.00 _____________________________3,050.001,161.55 2,082,475.00 949,309.19 2,103,100.00 1,084,050.003,873,370.005,118,617.753,833,077.00 1,394,425.64Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS BUILDING IMPROVEMENTS 0.00100-3100-8014-0000 0.00 11,950.000.00 0.00 __________________________________________________________0.00 VEHICLES 0.00100-3100-8060-0000 0.00 0.000.00 0.00 _____________________________500.00680.08 0.00 680.08 0.00 500.000.000.000.00 11,950.00Category: 70 - CAPITAL IMPROVEMENTS Total: 2,596,895.00 1,379,661.99 2,104,100.00 1,464,689.004,116,873.005,125,331.743,833,077.00 1,678,320.69Department: 3100 - ENGINEERING AND PUBLIC WORKS Total:DRAFT Page 44 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 33 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 3150 - REFUSE Category: 65 - OPERATING COSTS REFUSE COST - RESIDENTIAL 3,000,000.00100-3150-7060-0000 0.00 2,775,160.560.00 -107,164.93 3,000,000.00 3,000,000.002,487,814.64 REFUSE COST - COMMERCIAL 1,922,000.00100-3150-7061-0000 0.00 1,463,886.740.00 0.00 2,000,000.00 2,000,000.001,424,797.73 CONTRACTUAL SERVICES 57,080.00100-3150-7068-0000 0.00 0.000.00 0.00 60,000.00_____________________________28,479.12 4,979,080.00 3,941,091.49 5,060,000.00 5,000,000.000.00-107,164.930.00 4,239,047.30Category: 65 - OPERATING COSTS Total: 4,979,080.00 3,941,091.49 5,060,000.00 5,000,000.000.00-107,164.930.00 4,239,047.30Department: 3150 - REFUSE Total: DRAFT Page 45 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 34 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 3250 - STREET MAINTENANCE Category: 60 - PERSONNEL SERVICES SALARIES 200,325.00100-3250-6010-0000 111,595.00 109,829.71220,579.00 173,669.77 _____________________________295,131.00147,905.79 OVERTIME 10,000.00100-3250-6012-0000 4,000.00 8,470.073,482.00 1,884.00 _____________________________10,000.006,216.39 SICK LEAVE 0.00100-3250-6013-0000 0.00 1,375.360.00 12,878.06 __________________________________________________________2,132.76 HOLIDAY 0.00100-3250-6014-0000 0.00 6,132.060.00 10,287.15 __________________________________________________________8,097.00 VACATION 0.00100-3250-6015-0000 0.00 7,358.050.00 8,692.73 __________________________________________________________6,044.41 ACCRUED TIME CASH OUT 5,010.00100-3250-6016-0000 1,685.00 265.7919,065.00 1,027.15 _____________________________5,267.004,471.72 OTHER COMPENSATION 0.00100-3250-6018-0000 0.00 175.000.00 0.00 __________________________________________________________0.00 FIRST AID 0.00100-3250-6019-0000 0.00 66.000.00 0.00 __________________________________________________________132.00 HEALTH INSURANCE 53,615.00100-3250-6020-0000 29,040.00 22,037.9248,803.00 38,715.24 _____________________________90,000.0051,439.67 DENTAL INSURANCE 1,200.00100-3250-6021-0000 0.00 1,446.968,150.00 2,847.00 __________________________________________________________1,406.95 WORKERS COMP 12,550.00100-3250-6022-0000 21,770.00 7,207.1519,300.00 14,960.09 _____________________________19,184.007,830.63 DISABILITY 1,710.00100-3250-6023-0000 758.00 889.141,602.00 1,436.61 _____________________________2,630.001,134.76 P.E.R.S./P.E.P.R.A.34,175.00100-3250-6024-0000 25,468.00 28,539.8147,079.00 42,851.37 _____________________________43,485.0019,094.80 DEFERRED COMP 0.00100-3250-6026-0000 0.00 0.009,897.00 8,564.51 __________________________________________________________0.00 VISION CARE 0.00100-3250-6027-0000 0.00 0.00317.00 399.45 __________________________________________________________77.65 LIFE INSURANCE 320.00100-3250-6028-0000 192.00 228.00312.00 320.80 _____________________________420.00273.00 MEDICARE 3,140.00100-3250-6034-0000 1,676.00 1,926.393,414.00 2,936.14 _____________________________4,501.002,485.62 RECRUITMENT AND HIRING COS…750.00100-3250-6050-0000 0.00 0.000.00 0.00 __________________________________________________________576.00 322,795.00 259,319.15 0.00 470,618.00196,184.00321,470.07382,000.00 195,947.41Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS UTILITIES 885,000.00100-3250-7010-0000 660,000.00 609,669.77660,000.00 539,136.63 728,000.00_____________________________606,187.53 TELEPHONE 750.00100-3250-7015-0000 1,500.00 0.001,200.00 489.37 1,500.00_____________________________123.99 OFFICE SUPPLIES 200.00100-3250-7025-0000 0.00 0.000.00 268.25 1,000.00_____________________________21.19 HEALTH/FITNESS 0.00100-3250-7027-0000 0.00 0.002,598.00 4,164.92 __________________________________________________________0.00 LOCAL MEETINGS 0.00100-3250-7035-0000 500.00 0.000.00 0.00 10,200.00_____________________________2,222.11 VEHICLE MAINTENANCE 15,000.00100-3250-7037-0000 47,000.00 10,991.725,000.00 14,705.02 15,000.00 8,900.0013,484.54 FUEL 15,000.00100-3250-7050-0000 7,200.00 15,079.0021,000.00 16,355.04 20,000.00 30,000.0011,081.07 PERMITS, FEES AND LICENSES 0.00100-3250-7053-0000 0.00 0.000.00 0.00 _____________________________800.0025.72 UNIFORMS 2,500.00100-3250-7065-0000 2,500.00 1,642.373,000.00 2,185.14 5,000.00 1,460.002,863.40 TRAVEL, EDUCATION, TRAINING 0.00100-3250-7066-0000 0.00 0.000.00 0.00 _____________________________7,950.00125.00 DRAFT Page 46 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 35 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets CONTRACTUAL SERVICES 416,101.00100-3250-7068-0000 285,000.00 331,733.76250,748.00 166,794.14 500,000.00 527,000.00185,312.30 SPECIAL DEPT SUPPLIES 95,000.00100-3250-7070-0000 232,000.00 47,094.2832,000.00 19,605.42 150,000.00 127,585.0049,476.21 SPEC DEPT SUPPLIES-MOUNTAI…600.00100-3250-7070-5150 0.00 0.000.00 0.00 500.00 540.00218.20 EQUIPMENT LEASING/RENTAL 800.00100-3250-7075-0000 0.00 1,008.900.00 0.00 2,000.00 14,910.00888.43 BUILDING SUPPLIES/MAINT 400.00100-3250-7085-0000 0.00 0.000.00 0.00 1,000.00_____________________________161.53 SECURITY SERVICES 4,100.00100-3250-7087-0000 0.00 420.000.00 0.00 1,700.00_____________________________1,700.00 EQUIPMENT SUPPLIES/MAINT 1,000.00100-3250-7090-0000 1,000.00 11,874.880.00 0.00 2,000.00 2,000.00639.40 INTERNAL SERVICES 0.00100-3250-7160-0000 0.00 -849.490.00 0.00 __________________________________________________________0.00 1,436,451.00 874,530.62 1,437,900.00 721,145.001,236,700.00763,703.93975,546.00 1,028,665.19Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 0.00100-3250-8040-0000 0.00 52.380.00 439.18 165,000.00 120,000.000.00 VEHICLES 220,000.00100-3250-8060-0000 0.00 0.000.00 0.00 215,000.00 187,500.0082,467.31 220,000.00 82,467.31 380,000.00 307,500.000.00439.180.00 52.38Category: 70 - CAPITAL IMPROVEMENTS Total: 1,979,246.00 1,216,317.08 1,817,900.00 1,499,263.001,432,884.001,085,613.181,357,546.00 1,224,664.98Department: 3250 - STREET MAINTENANCE Total:DRAFT Page 47 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 36 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 6000 - BUILDING MAINTENANCE Category: 65 - OPERATING COSTS UTILITIES 0.00100-6000-7010-0000 0.00 0.000.00 0.00 _____________________________353,725.000.00 CONTRACTUAL SERVICES 0.00100-6000-7068-0000 0.00 0.000.00 0.00 _____________________________4,500.000.00 CONTRACTUAL SVC- POLICE DEPT 0.00100-6000-7068-6040 0.00 0.000.00 0.00 _____________________________10,000.000.00 BUILDING SUPPLIES/MAINT 0.00100-6000-7085-0000 0.00 0.000.00 0.00 _____________________________75,600.000.00 0.00 0.00 0.00 443,825.000.000.000.00 0.00Category: 65 - OPERATING COSTS Total: 0.00 0.00 0.00 443,825.000.000.000.00 0.00Department: 6000 - BUILDING MAINTENANCE Total: DRAFT Page 48 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 37 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 6050 - PARKS AND GROUNDS MAINT Category: 60 - PERSONNEL SERVICES SALARIES 1,024,075.00100-6050-6010-0000 838,922.00 700,410.02969,448.00 677,323.13 _____________________________1,020,309.00674,465.24 OVERTIME 14,400.00100-6050-6012-0000 26,000.00 10,120.4133,320.00 6,477.41 _____________________________14,400.0022,068.34 SICK LEAVE 0.00100-6050-6013-0000 0.00 38,049.570.00 60,585.68 __________________________________________________________48,904.03 HOLIDAY 0.00100-6050-6014-0000 0.00 40,925.720.00 38,540.12 __________________________________________________________46,250.26 VACATION 0.00100-6050-6015-0000 0.00 48,317.990.00 35,179.89 __________________________________________________________49,132.62 ACCRUED TIME CASH OUT 18,880.00100-6050-6016-0000 12,600.00 29,013.05103,600.00 4,270.86 _____________________________18,589.0029,358.94 OTHER COMPENSATION 0.00100-6050-6018-0000 0.00 9,219.860.00 0.00 __________________________________________________________10,110.94 FIRST AID 700.00100-6050-6019-0000 0.00 1,338.600.00 0.00 __________________________________________________________594.00 HEALTH INSURANCE 286,750.00100-6050-6020-0000 232,321.00 170,302.27208,785.00 232,531.50 _____________________________342,000.00170,097.49 DENTAL INSURANCE 12,000.00100-6050-6021-0000 0.00 9,642.6847,137.00 13,936.17 __________________________________________________________12,211.54 WORKERS COMP 68,750.00100-6050-6022-0000 43,540.00 61,538.9364,200.00 58,084.15 _____________________________66,320.0035,981.48 DISABILITY 9,550.00100-6050-6023-0000 5,737.00 5,679.007,287.00 5,964.90 _____________________________9,994.006,241.72 P.E.R.S./P.E.P.R.A.130,000.00100-6050-6024-0000 187,673.00 189,591.40216,975.00 178,919.16 _____________________________177,511.0082,357.95 UNEMPLOYMENT 0.00100-6050-6025-0000 0.00 -360.000.00 6,185.97 __________________________________________________________0.00 DEFERRED COMP 13,500.00100-6050-6026-0000 0.00 10,953.1346,128.00 49,862.62 __________________________________________________________9,775.74 VISION CARE 2,300.00100-6050-6027-0000 0.00 1,610.781,775.00 2,758.22 __________________________________________________________1,972.54 LIFE INSURANCE 1,600.00100-6050-6028-0000 1,536.00 1,311.001,663.00 1,433.38 _____________________________1,596.001,386.00 WORKERS COMP COST 2,000.00100-6050-6029-0000 0.00 6,533.170.00 25,986.99 __________________________________________________________929.81 MEDICARE 15,350.00100-6050-6034-0000 12,541.00 12,666.6916,042.00 12,494.66 _____________________________15,273.0012,396.09 FICA/PARS 100.00100-6050-6035-0000 0.00 70.430.00 0.00 __________________________________________________________45.13 RECRUITMENT AND HIRING COS…2,850.00100-6050-6050-0000 0.00 100.000.00 0.00 __________________________________________________________1,516.55 1,602,805.00 1,215,796.41 0.00 1,665,992.001,360,870.001,410,534.811,716,360.00 1,347,034.70Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS UTILITIES 650,000.00100-6050-7010-0000 275,000.00 206,703.33275,000.00 205,414.97 650,000.00 1,425,000.00221,748.92 UTILITIES IA 8A (SUNDANCE)0.00100-6050-7010-008A 0.00 23,005.450.00 10,657.09 __________________________________________________________52,697.94 UTILITIES IA 14A (OAK VALLEY)0.00100-6050-7010-014A 0.00 866.980.00 342.60 __________________________________________________________753.90 UTILITIES IA 17A (TOURNAMENT…0.00100-6050-7010-017A 0.00 2,353.970.00 976.27 __________________________________________________________2,742.40 UTILITIES, PARK (SENECA SPRING…0.00100-6050-7010-5300 0.00 1,202.470.00 347.65 __________________________________________________________2,130.95 UTILITIES, PARK (STEWART)0.00100-6050-7010-5500 0.00 19.510.00 0.00 __________________________________________________________0.00 UTILITIES 0.00100-6050-7010-6000 0.00 1,885.490.00 1,152.98 __________________________________________________________845.08 DRAFT Page 49 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 38 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets UTILITIES 0.00100-6050-7010-6001 0.00 2,346.810.00 2,061.22 __________________________________________________________2,764.16 UTILITIES - RYLAN 0.00100-6050-7011-2000 0.00 5,753.850.00 1,906.50 __________________________________________________________6,632.10 TELEPHONE 1,050.00100-6050-7015-0000 5,050.00 1,011.635,050.00 2,368.62 5,000.00_____________________________458.27 TELEPHONE - SPORTS PARK 1,125.00100-6050-7015-5400 0.00 397.240.00 839.25 __________________________________________________________826.58 HEALTH/FITNESS 0.00100-6050-7027-0000 0.00 0.0010,392.00 14,719.26 __________________________________________________________0.00 VEHICLE MAINTENANCE 70,000.00100-6050-7037-0000 31,000.00 40,163.5131,000.00 17,745.08 70,000.00 30,400.0047,982.98 FUEL 52,000.00100-6050-7050-0000 48,000.00 40,801.2748,000.00 33,067.27 55,000.00 45,000.0044,915.77 PERMITS, FEES, LICENSES 350.00100-6050-7053-5400 0.00 0.000.00 0.00 __________________________________________________________144.00 ERICA 0.00100-6050-7057-0000 0.00 0.000.00 0.00 __________________________________________________________7,406.92 CONTRACTUAL SERVICES (GEN)0.00100-6050-7060-0000 70,000.00 0.000.00 0.00 50,000.00_____________________________0.00 CONTRACT SVCS - LEMON AVE 0.00100-6050-7061-2000 0.00 0.000.00 586.50 __________________________________________________________0.00 CONTRACTS - OAK VALLEY 0.00100-6050-7062-014A 0.00 0.000.00 954.71 __________________________________________________________0.00 CONTRACT SVCS - CRYSTAL SPRI…0.00100-6050-7062-2000 0.00 0.000.00 -88.49 __________________________________________________________0.00 UNIFORMS 16,500.00100-6050-7065-0000 13,000.00 14,105.348,000.00 11,947.16 20,000.00 15,600.0012,560.08 TRAVEL, EDUCATION, TRAINING 1,000.00100-6050-7066-0000 0.00 0.000.00 334.00 2,500.00 395.00395.00 CONTRACTS - COUGAR RANCH 0.00100-6050-7067-010A 0.00 0.000.00 1,481.51 __________________________________________________________0.00 CONTRACTS - GOLF CLUB DRIVE 0.00100-6050-7067-014A 0.00 0.000.00 6,045.00 __________________________________________________________0.00 CONTRACTS - COUNTRY CROSSI…0.00100-6050-7067-015X 0.00 0.000.00 -88.49 __________________________________________________________0.00 CONTRACT SVC - PALMER PARK 0.00100-6050-7067-5200 0.00 0.000.00 4.72 __________________________________________________________0.00 CONTRACTUAL SERVICES 40,000.00100-6050-7068-0000 0.00 7,617.9970,000.00 29,303.02 65,000.00 44,740.9515,589.73 CONTRACT SVC - IA 8A 0.00100-6050-7068-008a 0.00 0.000.00 1,061.01 __________________________________________________________1,607.50 CPMTRACT SVC - IA 8D 0.00100-6050-7068-008D 0.00 0.000.00 0.00 __________________________________________________________1,607.50 CONTRACT SVC - IA 10A 0.00100-6050-7068-010A 0.00 0.000.00 0.00 __________________________________________________________1,256.20 CONTRACT SVC - IA 11A 0.00100-6050-7068-011A 0.00 0.000.00 0.00 __________________________________________________________1,256.20 CONTRACT SVC - IA 14B 0.00100-6050-7068-014B 0.00 0.000.00 0.00 __________________________________________________________1,142.00 CONTRACTUAL SERVICES 0.00100-6050-7068-017A 0.00 0.000.00 4,139.50 __________________________________________________________0.00 CONTRACT SVC - THREE RINGS R…0.00100-6050-7068-5000 0.00 0.000.00 3,912.71 __________________________________________________________500.00 CONTRACT SVC - RANGAL PARK 0.00100-6050-7068-5250 0.00 2,675.380.00 2,307.80 __________________________________________________________2,253.54 CONTRACT SVC - SENECA SPRIN…0.00100-6050-7068-5300 0.00 0.000.00 4.71 __________________________________________________________250.00 CONTRACT SVC - SHADOW HILLS…0.00100-6050-7068-5350 0.00 0.000.00 1,515.50 __________________________________________________________0.00 CONTRACT SVC - SPORTS PARK 0.00100-6050-7068-5400 0.00 1,148.300.00 0.00 __________________________________________________________4,108.02 DRAFT Page 50 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 39 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets CONTRACT SVC - STETSON PARK 0.00100-6050-7068-5450 0.00 0.000.00 2,176.72 __________________________________________________________0.00 CONTRACT SVC - STEWART PARK 0.00100-6050-7068-5500 0.00 1,383.680.00 3,220.20 __________________________________________________________2,493.60 CONTRACT SVC - SUNNY HILLS P…0.00100-6050-7068-5550 0.00 0.000.00 2,518.00 __________________________________________________________0.00 CONTRACT SVC - TREVINO PARK 0.00100-6050-7068-5600 0.00 0.000.00 4.72 __________________________________________________________100.00 CONTRACT SVC - ALL PARKS 0.00100-6050-7068-5999 0.00 1,149.000.00 2,348.01 __________________________________________________________0.00 SPECIAL DEPT SUPPLIES 169,000.00100-6050-7070-0000 125,000.00 31,129.56125,000.00 22,616.46 _____________________________140,400.0042,808.45 SPECIAL DEPT SUPPLIES 0.00100-6050-7070-000A 0.00 1,069.770.00 4,084.00 210,000.00_____________________________0.00 SPEC DEPT EXP - IA 8A 0.00100-6050-7070-008A 0.00 2,128.810.00 3,666.86 __________________________________________________________0.00 SPEC DEPT EXP - IA 10A 0.00100-6050-7070-010A 0.00 55.510.00 882.27 __________________________________________________________814.80 SPEC DEPT EXP - IA 14A 0.00100-6050-7070-014A 0.00 5,768.070.00 3,553.55 __________________________________________________________10.15 SPEC DEPT EXP - IA 15 0.00100-6050-7070-015X 0.00 25.880.00 547.97 __________________________________________________________0.00 SPEC DEPT EXP - IA 17A 0.00100-6050-7070-017A 0.00 379.090.00 2,108.63 __________________________________________________________0.00 SPEC DEPT EXP - CRYSTAL SPRIN…0.00100-6050-7070-2000 0.00 222.020.00 1,016.13 __________________________________________________________0.00 SPEC DEPT EXP - THREE RINGS R…0.00100-6050-7070-5000 0.00 665.480.00 6,271.37 __________________________________________________________1,720.17 SPEC DEPT EXP - DEFORGE PARK 0.00100-6050-7070-5050 0.00 105.010.00 0.00 __________________________________________________________4,449.56 SPEC DEPT EXP - FALLEN HEROES…0.00100-6050-7070-5100 0.00 4,026.590.00 0.00 __________________________________________________________1,229.03 SPEC DEPT EXP - MOUNTAINVIE…0.00100-6050-7070-5150 0.00 3,136.520.00 0.00 __________________________________________________________3,144.17 SPEC DEPT EXP - PALMER PARK 0.00100-6050-7070-5200 0.00 568.620.00 2,383.72 __________________________________________________________316.03 SPEC DEPT EXP - RANGAL PARK 0.00100-6050-7070-5250 0.00 215.950.00 989.89 __________________________________________________________394.35 SPEC DEPT EXP - SENECA SPRING…0.00100-6050-7070-5300 0.00 3,488.160.00 4,205.82 __________________________________________________________3,478.14 SPEC DEPT EXP - SHADOW HILLS …0.00100-6050-7070-5350 0.00 874.690.00 0.00 __________________________________________________________40.31 SPEC DEPT EXP - SPORTS PARK 0.00100-6050-7070-5400 0.00 8,249.410.00 0.00 __________________________________________________________5,900.45 SPEC DEPT EXP - STETSON PARK 0.00100-6050-7070-5450 0.00 2,660.840.00 2,130.95 __________________________________________________________882.83 SPEC DEPT EXP - STEWART PARK 0.00100-6050-7070-5500 0.00 867.570.00 4,020.01 __________________________________________________________502.31 SPEC DEPT EXP - SUNNY HILLS P…0.00100-6050-7070-5550 0.00 496.970.00 1,772.05 __________________________________________________________1,279.65 SPEC DEPT EXP - TREVINO PARK 0.00100-6050-7070-5600 0.00 409.090.00 2,240.43 __________________________________________________________555.53 SPEC DEPT EXP - WILD FLOWER …0.00100-6050-7070-5700 0.00 918.250.00 0.00 __________________________________________________________1,386.38 SPEC DEPT EXP - ALL PARKS 0.00100-6050-7070-5999 0.00 17,980.330.00 1,451.31 __________________________________________________________44,763.93 SUPPLIES - VICTORIA HOMES 0.00100-6050-7070-A12A 0.00 0.000.00 664.90 __________________________________________________________0.00 EQUIPMENT LEASING/RENTAL 2,300.00100-6050-7075-0000 0.00 0.000.00 0.00 12,000.00_____________________________930.94 BUILDING SUPPLIES/MAINT 2,500.00100-6050-7085-0000 5,000.00 974.585,000.00 35.91 8,500.00_____________________________3,500.41 DRAFT Page 51 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 40 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets SECURITY SERVICES 0.00100-6050-7087-0000 0.00 456.000.00 0.00 __________________________________________________________1,701.00 EQUIPMENT SUPPLIES/MAINT 1,800.00100-6050-7090-0000 0.00 650.130.00 20.00 5,500.00 5,500.0013,633.51 SPEC DEPT EXP - RANGAL PARK 0.00100-6050-7090-5250 0.00 0.000.00 0.00 __________________________________________________________252.85 SPEC DEPT EXP - SUNNY HILLS P…0.00100-6050-7090-5550 0.00 0.000.00 0.00 __________________________________________________________416.74 SPEC DEPT EXP - TREVINO PARK 0.00100-6050-7090-5600 0.00 0.000.00 0.00 __________________________________________________________699.75 INTERNAL SERVICES 0.00100-6050-7160-0000 0.00 -5,536.050.00 0.00 __________________________________________________________0.00 1,007,625.00 571,980.78 1,153,500.00 1,707,035.95572,050.00429,949.51577,442.00 436,578.05Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 44,000.00100-6050-8040-0000 0.00 1,151.270.00 0.00 55,000.00 52,200.0020,325.74 VEHICLES 6,000.00100-6050-8060-0000 145,000.00 0.000.00 0.00 __________________________________________________________4,037.09 50,000.00 24,362.83 55,000.00 52,200.00145,000.000.000.00 1,151.27Category: 70 - CAPITAL IMPROVEMENTS Total: 2,660,430.00 1,812,140.02 1,208,500.00 3,425,227.952,077,920.001,840,484.322,293,802.00 1,784,764.02Department: 6050 - PARKS AND GROUNDS MAINT Total:DRAFT Page 52 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 41 of 42 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Department: 6150 - CITY POOL Category: 60 - PERSONNEL SERVICES SALARIES 37,075.00100-6150-6010-0000 29,700.00 21,867.4826,003.00 22,997.20 _____________________________30,051.0023,644.98 OVERTIME 0.00100-6150-6012-0000 0.00 151.290.00 0.00 __________________________________________________________728.70 HOLIDAY 0.00100-6150-6014-0000 0.00 0.000.00 0.00 __________________________________________________________257.76 OTHER COMPENSATION 0.00100-6150-6018-0000 0.00 246.160.00 0.00 __________________________________________________________1,723.12 FIRST AID 0.00100-6150-6019-0000 0.00 132.000.00 0.00 __________________________________________________________45.00 WORKERS COMP 2,150.00100-6150-6022-0000 8,165.00 715.079,600.00 1,878.96 _____________________________1,953.001,161.05 P.E.R.S./P.E.P.R.A.0.00100-6150-6024-0000 386.00 0.00338.00 0.00 __________________________________________________________124.25 WORKERS COMP COST 0.00100-6150-6029-0000 0.00 537.570.00 362.88 __________________________________________________________0.00 MEDICARE 830.00100-6150-6034-0000 431.00 313.70377.00 390.92 _____________________________436.00381.05 FICA/PARS 430.00100-6150-6035-0000 0.00 273.450.00 398.58 _____________________________391.00255.75 RECRUITMENT AND HIRING COS…250.00100-6150-6050-0000 0.00 792.000.00 0.00 __________________________________________________________66.00 40,735.00 28,387.66 0.00 32,831.0038,682.0026,028.5436,318.00 25,028.72Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS TELEPHONE 1,000.00100-6150-7015-0000 1,000.00 690.401,000.00 579.10 1,000.00_____________________________719.84 OFFICE SUPPLIES 0.00100-6150-7025-0000 0.00 0.000.00 28.46 __________________________________________________________0.00 LOCAL MEETINGS 250.00100-6150-7035-0000 2,000.00 0.002,000.00 0.00 500.00_____________________________0.00 PERMITS, FEES AND LICENSES 0.00100-6150-7053-0000 0.00 0.000.00 0.00 _____________________________610.000.00 TRAVEL, EDUCATION, TRAINING 0.00100-6150-7066-0000 0.00 950.000.00 0.00 _____________________________250.00610.00 CONTRACTUAL SERVICES 0.00100-6150-7068-0000 0.00 0.002,000.00 498.00 __________________________________________________________0.00 SPECIAL DEPT SUPPLIES 13,300.00100-6150-7070-0000 11,300.00 17,269.209,300.00 12,022.91 11,000.00 11,000.006,281.80 BUILDING SUPPLIES/MAINT 0.00100-6150-7085-0000 19,000.00 4,488.6619,555.00 11,153.75 11,000.00_____________________________1,490.04 SECURITY SERVICES 0.00100-6150-7087-0000 0.00 336.000.00 0.00 __________________________________________________________336.00 EQUIPMENT SUPPLIES/MAINT 0.00100-6150-7090-0000 0.00 0.000.00 0.00 _____________________________1,400.003,613.97 14,550.00 13,051.65 23,500.00 13,260.0033,300.0024,282.2233,855.00 23,734.26Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS EQUIPMENT 2,500.00100-6150-8040-0000 2,500.00 0.002,500.00 0.00 3,500.00_____________________________0.00 2,500.00 0.00 3,500.00 0.002,500.000.002,500.00 0.00Category: 70 - CAPITAL IMPROVEMENTS Total: 57,785.00 41,439.31 27,000.00 46,091.0074,482.0050,310.7672,673.00 48,762.98Department: 6150 - CITY POOL Total: 21,539.00 -2,953,708.61 -20,070,197.36 0.00552,535.003,259,087.49-150,601.00 8,443,257.82Fund: 100 - GENERAL FUND Surplus (Deficit): 21,539.00 -20,070,197.36 0.00552,535.003,259,087.49-150,601.00 -2,953,708.618,443,257.82Report Surplus (Deficit): DRAFT Page 53 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:44:32 PM Page 42 of 42 Fund Summary Fund 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Budget 2015-2016 Total Budget Defined Budgets 2016-2017 Total Activity 2015-2016 Total Activity 2018-2019 2018-2019 2018-2019 REV 1 100 - GENERAL FUND 21,539.00 -20,070,197.36 0.00552,535.00-150,601.00 -2,953,708.613,259,087.49 8,443,257.82 Report Surplus (Deficit):21,539.00 -20,070,197.36 0.00552,535.00-150,601.00 -2,953,708.613,259,087.49 8,443,257.82 DRAFT Page 54 of 84 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 YTD Activity 4058307.41 24671992 236707.94 0 4058307.41 24671992 236707.94 0 8869.99 15000 0 63904.73 8869.99 15000 0 63,904.73 0 -209396 0 0 0 0 28789.85 0 0 0 9759.98 0 0 0 194691.36 86258.98 0 0 30000 0 0 0 30000 0 0 0 1670 1289.45 0 0 6608.95 0 0 0 191335.57 95507.63 0 0 117372.98 50451.65 0 0 145461.84 66279.64 0 0 108167.55 50087.25 0 0 85256.84 30084.32 0 0 89884.38 31820.73 0 0 250232.77 114867.35 0 0 119760.89 45589.43 0 0 93048.26 58345.62 0 0 0 8076.72 0 0 332394.41 163312 0 0 21239.91 6819.42 250-0000-4445-008X ALLOCATED ASSESSMENTS - IA 8 0 0_____________________________60000 250-0000-4445-009X ALLOCATED ASSESSMENTS - IA 9 0 0_____________________________12958 5/17/2018 6:26:19 PM Page 1 of 9 250-0000-4445-008D ALLOCATED ASSESSMENTS - IA 8D 0 0_____________________________39335 250-0000-4445-008E ALLOCATED ASSESSMENTS - IA 8E 0 0_____________________________41735 250-0000-4445-008F ALLOCATED ASSESSMENTS - IA 8F 0 0_____________________________31714 250-0000-4445-008A ALLOCATED ASSESSMENTS - IA 8A 0 0_____________________________35970 250-0000-4445-008B ALLOCATED ASSESSMENTS - IA 8B 0 0_____________________________36423 250-0000-4445-008C ALLOCATED ASSESSMENTS - IA 8C 0 0_____________________________53054 250-0000-4445-007B ALLOCATED ASSESSMENTS - IA 7B 0 0_____________________________39223 250-0000-4445-007C ALLOCATED ASSESSMENTS - IA 7C 0 0_____________________________42189 250-0000-4445-007D ALLOCATED ASSESSMENTS - IA 7D 0 0_____________________________39656 250-0000-4445-006A ALLOCATED ASSESSMENTS - IA 6A 0 0_____________________________3350 250-0000-4445-006B ALLOCATED ASSESSMENTS - IA 6B 0 0_____________________________30000 250-0000-4445-007A ALLOCATED ASSESSMENTS - IA 7A 0 0_____________________________47502 250-0000-4445-003X ALLOCATED ASSESSMENTS - IA 3 0 0_____________________________47366 250-0000-4445-004X ALLOCATED ASSESSMENTS - IA 4 0 0_____________________________30000 250-0000-4445-005X ALLOCATED ASSESSMENTS - IA 5 0 0_____________________________29958 Category: 58 - OTHER FINANCING SOURCES 250-0000-4441-0000 DELINQUENCIES 0 -219872__________________________________________________________ 250-0000-4445-001A ALLOCATED ASSESSMENTS - IA 1A 0 0_____________________________30000 250-0000-4445-002X ALLOCATED ASSESSMENTS - IA 2 0 0_____________________________20260 Category: 52 - SPECIAL ASSESSMENTS Total:0 4392075 0 0 Category: 54 - MISCELLANEOUS REVENUES 250-0000-4650-0000 INTEREST 0 0__________________________________________________________ Category: 54 - MISCELLANEOUS REVENUES Total:0 0 0 0 Budget Worksheet City of Beaumont, CA Account Summary For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets 2015-2016 Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Fund: 250 - COMMUNITY FAC DISTRICT (CFD) - ADMIN Category: 52 - SPECIAL ASSESSMENTS 250-0000-4440-0000 PROPERTY TAX ASSESSMENTS 0 4392075__________________________________________________________ DRAFT Page 55 of 84 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 YTD Activity 0 0 58346.97 15182.49 0 0 58971.82 16160.81 0 0 63981.9 18214.22 0 0 3759 0 0 0 30000 308967.2 0 0 30000 0 0 0 558725.39 2695.19 0 0 23967.46 12712.15 0 0 104032.75 38776.33 0 0 179732.62 83341.92 0 0 150933.72 64205.7 0 0 69243.13 35919.78 0 0 89292.18 31748.81 0 0 197913.42 91333.67 0 0 237067.56 107801.77 0 0 63064.1 17422.87 0 0 0 0 0 0 323828.15 154459.65 0 0 22757.52 9448.17 0 0 0 17011.54 0 0 0 16106.78 0 0 0 7250 0 -209396 4121293.23 1,857,549.24 0 0 91200 0 290332.84 1000000 175026.14 103037.91 245189.66 0 0 45922.61 0 0 0 3710.75 0 0 0 3710.75 0 0 0 4781.75 0 0 0 3710.75250-0000-7068-004X CONTRACTUAL SERVICE - IA 4 0 0_____________________________4948 5/17/2018 6:26:19 PM Page 2 of 9 250-0000-7068-001A CONTRACTUAL SERVICE - IA 1A 0 0_____________________________4948 250-0000-7068-002X CONTRACTUAL SERVICE - IA 2 0 0_____________________________4948 250-0000-7068-003X CONTRACTUAL SERVICE - IA 3 0 0_____________________________6376 Category: 65 - OPERATING COSTS 250-0000-7051-0000 TRUSTEE FEES 0 0__________________________________________________________ 250-0000-7068-0000 CONTRACTUAL SERVICES 0 0__________________________________________________________ 250-0000-7068-000A CONTRACTUAL SERVICES - SEC 0 0__________________________________________________________ 250-0000-4445-1604 ALLOCATED ASSESSMENTS - IA 2016-4 0 0_____________________________32921 250-0000-4825-0000 MISCELLANEOUS REVENUE 0 0__________________________________________________________ Category: 58 - OTHER FINANCING SOURCES Total:0 -219872 0 1391290 250-0000-4445-06A1 ALLOCATED ASSESSMENTS - IA 6A1 0 0_____________________________60000 250-0000-4445-1601 ALLOCATED ASSESSMENTS - IA 2016-1 0 0_____________________________31988 250-0000-4445-1602 ALLOCATED ASSESSMENTS - IA 2016-2 0 0_____________________________33508 250-0000-4445-019C ALLOCATED ASSESSMENTS - IA 19C 0 0_____________________________51984 250-0000-4445-020X ALLOCATED ASSESSMENTS - IA 20 0 0_____________________________33483 250-0000-4445-023X ALLOCATED ASSESSMENTS - IA 23 0 0_____________________________2454 250-0000-4445-017C ALLOCATED ASSESSMENTS - IA 17C 0 0_____________________________37364 250-0000-4445-018X ALLOCATED ASSESSMENTS - IA 18 0 0_____________________________36323 250-0000-4445-019A ALLOCATED ASSESSMENTS - IA 19A 0 0_____________________________47942 250-0000-4445-016X ALLOCATED ASSESSMENTS - IA 16 0 0_____________________________37855 250-0000-4445-017A ALLOCATED ASSESSMENTS - IA 17A 0 0_____________________________45905 250-0000-4445-017B ALLOCATED ASSESSMENTS - IA 17B 0 0_____________________________42711 250-0000-4445-014B ALLOCATED ASSESSMENTS - IA 14B 0 0_____________________________30000 250-0000-4445-014X ALLOCATED ASSESSMENTS - IA 14 0 0_____________________________60000 250-0000-4445-015X ALLOCATED ASSESSMENTS - IA 15 0 0_____________________________2512 250-0000-4445-012A ALLOCATED ASSESSMENTS - IA 12A 0 0_____________________________33613 250-0000-4445-013X ALLOCATED ASSESSMENTS - IA 13 0 0_____________________________3902 250-0000-4445-014A ALLOCATED ASSESSMENTS - IA 14A 0 0_____________________________30000 Defined Budgets 2015-2016 Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 250-0000-4445-010A ALLOCATED ASSESSMENTS - IA 10A 0 0_____________________________33027 250-0000-4445-011A ALLOCATED ASSESSMENTS - IA 11A 0 0_____________________________33105 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 DRAFT Page 56 of 84 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 YTD Activity 0 0 0 3710.75 0 0 0 6898.5 0 0 0 3710.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 1071 0 0 0 3710.75 0 0 0 3710.75 0 0 0 4781.75 0 0 0 1071 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 0 0 0 4781.75 5/17/2018 6:26:19 PM Page 3 of 9 250-0000-7068-019A CONTRACTUAL SERVICE - IA 19A 0 0_____________________________6376 250-0000-7068-019C CONTRACTUAL SERVICE - IA 19C 0 0_____________________________6376 250-0000-7068-020X CONTRACTUAL SERVICE - IA 20 0 0_____________________________6376 250-0000-7068-017B CONTRACTUAL SERVICE - IA 17B 0 0_____________________________6376 250-0000-7068-017C CONTRACTUAL SERVICE - IA 17C 0 0_____________________________6376 250-0000-7068-018X CONTRACTUAL SERVICE - IA 18 0 0_____________________________6376 250-0000-7068-015X COINTRACTUAL SERVICE - IA 15 0 0_____________________________1428 250-0000-7068-016X CONTRACTUAL SERVICE - IA 16 0 0_____________________________6376 250-0000-7068-017A CONTRACTUAL SERVICE - IA 17A 0 0_____________________________6376 250-0000-7068-014A CONTRACTUAL SERVICE - IA 14A 0 0_____________________________4948 250-0000-7068-014B CONTRACTUAL SERVICE - IA 14B 0 0_____________________________4948 250-0000-7068-014X CONTRACTUAL SERVICE - IA 14 0 0_____________________________6376 250-0000-7068-011A CONTRACTUAL SERVICE - IA 11A 0 0_____________________________6376 250-0000-7068-012A CONTRACTUAL SERVICE - IA 12A 0 0_____________________________6376 250-0000-7068-013X CONTRACTUAL SERVICE - IA 13 0 0_____________________________1428 250-0000-7068-008X CONTRACTUAL SERVICE - IA 8X 0 0_____________________________6376 250-0000-7068-009X CONTRACTUAL SERVICE - IA 9 0 0_____________________________6376 250-0000-7068-010A CONTRACTUAL SERVICE - IA 10A 0 0_____________________________6376 250-0000-7068-008D CONTRACTUAL SERVICE - IA 8D 0 0_____________________________6376 250-0000-7068-008E CONTRACTUAL SERVICE - IA 8E 0 0_____________________________6376 250-0000-7068-008F CONTRACTUAL SERVICE - IA 8F 0 0_____________________________6376 250-0000-7068-008A CONTRACTUAL SERVICE - IA 8A 0 0_____________________________6376 250-0000-7068-008B CONTRACTUAL SERVICE - IA 8B 0 0_____________________________6376 250-0000-7068-008C CONTRACTUAL SERVICE - IA 8C 0 0_____________________________6376 250-0000-7068-007B CONTRACTUAL SERVICE - IA 7B 0 0_____________________________6376 250-0000-7068-007C CONTRACTUAL SERVICE - IA 7C 0 0_____________________________6376 250-0000-7068-007D CONTRACTUAL SERVICE - IA 7D 0 0_____________________________6376 250-0000-7068-006A CONTRACTUAL SERVICE - IA 6A 0 0__________________________________________________________ 250-0000-7068-006B CONTRACTUAL SERVICE - IA 6B 0 0_____________________________4948 250-0000-7068-007A CONTRACTUAL SERVICE - IA 7A 0 0_____________________________6376 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets 2015-2016 Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 250-0000-7068-005X CONTRACTUAL SERVICE - IA 5 0 0_____________________________4948 DRAFT Page 57 of 84 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 YTD Activity 0 0 0 1071 0 0 0 1594 0 0 0 4781.75 0 0 0 5852.75 0 0 0 5852.75 535522.5 1000000 266226.14 322,672.27 0 17104509 0 -79326.98 0 0 0 5400 0 0 0 84445.94 0 -17104509 0 169,172.92 -2884855 -4100500 -2050250 -698440.33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -24109.64 0 0 0 -18859.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -24582.44 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0250-0000-9950-009X TRANSFERS - IA 9 0 0_____________________________-6582 5/17/2018 6:26:19 PM Page 4 of 9 250-0000-9950-008E TRANSFERS - IA 8E 0 0_____________________________-35359 250-0000-9950-008F TRANSFERS - IA 8F 0 0_____________________________-25338 250-0000-9950-008X TRANSFERS - IA 8 0 0_____________________________-53624 250-0000-9950-008B TRANSFERS - IA 8B 0 0_____________________________-30047 250-0000-9950-008C TRANSFERS - IA 8C 0 0_____________________________-46678 250-0000-9950-008D TRANSFERS - IA 8D 0 0_____________________________-32959 250-0000-9950-007C TRANSFERS - IA 7C 0 0_____________________________-35813 250-0000-9950-007D TRANSFERS - IA 7D 0 0_____________________________-33280 250-0000-9950-008A TRANSFERS - IA 8A 0 0_____________________________-29594 250-0000-9950-006B TRANSFERS - IA 6B 0 0_____________________________-25052 250-0000-9950-007A TRANSFERS - IA 7A 0 0_____________________________-41126 250-0000-9950-007B TRANSFERS - IA 7B 0 0_____________________________-32847 250-0000-9950-004X TRANSFERS - IA 4 0 0_____________________________-25052 250-0000-9950-005X TRANSFERS - IA 5 0 0_____________________________-25010 250-0000-9950-006A TRANSFERS - IA 6A 0 0_____________________________-3350 250-0000-9950-001A TRANSFERS - IA 1A 0 -4170000_____________________________-25052 250-0000-9950-002X TRANSFERS - IA 2 0 0_____________________________-15312 250-0000-9950-003X TRANSFERS - IA 3 0 0_____________________________-40990 250-0000-8925-0000 CFD PREPAYMENTS 0 0__________________________________________________________ Category: 80 - DEBT SERVICE Surplus (Deficit):0 0 0 0 Category: 90 - TRANSFERS 250-0000-9950-0000 TRANSFERS 0 0__________________________________________________________ Category: 65 - OPERATING COSTS Total:0 0 0 231628 Category: 80 - DEBT SERVICE 250-0000-8900-0000 DEBT SERVICE 0 0__________________________________________________________ 250-0000-8920-0000 CFD PREPAYMENT FEE 0 0__________________________________________________________ 250-0000-7068-1601 CONTRACTUAL SERVICE - IA 2016-1 0 0_____________________________6376 250-0000-7068-1602 CONTRACTUAL SERVICE - IA 2016-2 0 0_____________________________7804 250-0000-7068-1604 CONTRACTUAL SERVICE - IA 2016-4 0 0_____________________________7804 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets 2015-2016 Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 250-0000-7068-023X CONTRACTUAL SERVICE - IA 23 0 0_____________________________1428 250-0000-7068-06A1 CONTRACTUAL SERVICE - IA 6A1 0 0_____________________________11324 DRAFT Page 58 of 84 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 YTD Activity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -8358.56 0 0 0 0 0 0 0 -8535.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -2884855 -4100500 -2050250 -782,886.27 646799.9 2272587 2041525.03 985,068.35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 255-0000-4445-008A ALLOCATED ASSESSMENTS - IA 8A 0 0_____________________________53733 255-0000-4445-008B ALLOCATED ASSESSMENTS - IA 8B 0 0_____________________________57804 5/17/2018 6:26:19 PM Page 5 of 9 255-0000-4445-007B ALLOCATED ASSESSMENTS - IA 7B 0 0_____________________________83010 255-0000-4445-007C ALLOCATED ASSESSMENTS - IA 7C 0 0_____________________________109702 255-0000-4445-007D ALLOCATED ASSESSMENTS - IA 7D 0 0_____________________________86905 Fund: 250 - COMMUNITY FAC DISTRICT (CFD) - ADMIN Surplus (Deficit):0 2203 0 0 Fund: 255 - COMMUNITY FAC DISTRICT (CFD) - MAINT SERVICES Category: 58 - OTHER FINANCING SOURCES 255-0000-4445-003X ALLOCATED ASSESSMENTS - IA 3 0 0_____________________________156298 255-0000-4445-007A ALLOCATED ASSESSMENTS - IA 7A 0 0_____________________________157514 250-0000-9950-1602 TRANSFERS - IA 2016-2 0 0_____________________________-25704 250-0000-9950-1604 TRANSFERS - IA 2016-4 0 0_____________________________-25117 Category: 90 - TRANSFERS Total:0 -4170000 0 -1159662 250-0000-9950-023X TRANSFERS - IA 23 0 0_____________________________-1026 250-0000-9950-06A1 TRANSFERS - IA 6A1 0 0_____________________________-48676 250-0000-9950-1601 TRANSFERS - IA 2016-1 0 0_____________________________-25612 250-0000-9950-019A TRANSFERS - IA 19A 0 0_____________________________-41566 250-0000-9950-019C TRANSFERS - IA 19C 0 0_____________________________-45608 250-0000-9950-020X TRANSFERS - IA 20 0 0_____________________________-27107 250-0000-9950-017B TRANSFERS - IA 17B 0 0_____________________________-36335 250-0000-9950-017C TRANSFERS - IA 17C 0 0_____________________________-30988 250-0000-9950-018X TRANSFERS - IA 18 0 0_____________________________-29947 250-0000-9950-015X TRANSFERS - IA 15 0 0_____________________________-1084 250-0000-9950-016X TRANSFERS - IA 16 0 0_____________________________-31479 250-0000-9950-017A TRANSFERS - IA 17A 0 0_____________________________-39529 250-0000-9950-014A TRANSFERS - IA 14A 0 0_____________________________-25052 250-0000-9950-014B TRANSFERS - IA 14B 0 0_____________________________-25052 250-0000-9950-014X TRANSFERS - IA 14 0 0_____________________________-53624 250-0000-9950-011A TRANSFERS - IA 11A 0 0_____________________________-26729 250-0000-9950-012A TRANSFERS - IA 12A 0 0_____________________________-27237 250-0000-9950-013X TRANSFERS - IA 13 0 0_____________________________-2474 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets 2015-2016 Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 250-0000-9950-010A TRANSFERS - IA 10A 0 0_____________________________-26651 DRAFT Page 59 of 84 Total Activity Total Budget Total Activity 2017-2018 YTD Activity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0255-0000-9950-007C TRANSFERS - IA 7C 0 0_____________________________-109702 5/17/2018 6:26:19 PM Page 6 of 9 Category: 90 - TRANSFERS 255-0000-9950-003X TRANSFERS - IA 3 0 0_____________________________-156298 255-0000-9950-007A TRANSFERS - IA 7A 0 0_____________________________-157514 255-0000-9950-007B TRANSFERS - IA 7B 0 0_____________________________-83010 255-0000-4445-1602 ALLOCATED ASSESSMENTS - IA 2016-2 0 0_____________________________13756 255-0000-4445-1604 ALLOCATED ASSESSMENTS - IA 2016-4 0 0_____________________________3715 Category: 58 - OTHER FINANCING SOURCES Total:0 0 0 3268083 255-0000-4445-023X ALLOCATED ASSESSMENTS - IA 23 0 0_____________________________22084 255-0000-4445-06A1 ALLOCATED ASSESSMENTS - IA 6A1 0 0_____________________________279882 255-0000-4445-1601 ALLOCATED ASSESSMENTS - IA 2016-1 0 0_____________________________17895 255-0000-4445-019A ALLOCATED ASSESSMENTS - IA 19A 0 0_____________________________161476 255-0000-4445-019C ALLOCATED ASSESSMENTS - IA 19C 0 0_____________________________197852 255-0000-4445-020X ALLOCATED ASSESSMENTS - IA 20 0 0_____________________________31349 255-0000-4445-017B ALLOCATED ASSESSMENTS - IA 17B 0 0_____________________________114396 255-0000-4445-017C ALLOCATED ASSESSMENTS - IA 17C 0 0_____________________________66277 255-0000-4445-018X ALLOCATED ASSESSMENTS - IA 18 0 0_____________________________56904 255-0000-4445-015X ALLOCATED ASSESSMENTS - IA 15 0 0_____________________________22606 255-0000-4445-016X ALLOCATED ASSESSMENTS - IA 16 0 0_____________________________70691 255-0000-4445-017A ALLOCATED ASSESSMENTS - IA 17A 0 0_____________________________143141 255-0000-4445-012A ALLOCATED ASSESSMENTS - IA 12A 0 0_____________________________32513 255-0000-4445-013X ALLOCATED ASSESSMENTS - IA 13 0 0_____________________________35114 255-0000-4445-014X ALLOCATED ASSESSMENTS - IA 14 0 0_____________________________528159 255-0000-4445-009X ALLOCATED ASSESSMENTS - IA 9 0 0_____________________________12787 255-0000-4445-010A ALLOCATED ASSESSMENTS - IA 10A 0 0_____________________________27242 255-0000-4445-011A ALLOCATED ASSESSMENTS - IA 11A 0 0_____________________________27948 255-0000-4445-008E ALLOCATED ASSESSMENTS - IA 8E 0 0_____________________________105618 255-0000-4445-008F ALLOCATED ASSESSMENTS-IA8F 0 0_____________________________15426 255-0000-4445-008X ALLOCATED ASSESSMENTS - IA 8 0 0_____________________________284787 Defined Budgets Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 255-0000-4445-008C ALLOCATED ASSESSMENTS - IA 8C 0 0_____________________________207482 255-0000-4445-008D ALLOCATED ASSESSMENTS - IA 8D 0 0_____________________________84017 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 DRAFT Page 60 of 84 Total Activity Total Budget Total Activity 2017-2018 YTD Activity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Category: 90 - TRANSFERS Total:0 0 0 -3268083 Fund: 255 - COMMUNITY FAC DISTRICT (CFD) - MAINT SERVICES Total:0 0 0 0 5/17/2018 6:26:19 PM Page 7 of 9 255-0000-9950-1601 TRANSFERS - IA 2016-1 0 0_____________________________-17895 255-0000-9950-1602 TRANSFERS - IA 2016-2 0 0_____________________________-13756 255-0000-9950-1604 TRANSFERS - IA 2016-4 0 0_____________________________-3715 255-0000-9950-020X TRANSFERS - IA 20 0 0_____________________________-31349 255-0000-9950-023X TRANSFERS - IA 23 0 0_____________________________-22084 255-0000-9950-06A1 TRANSFERS - IA 6A1 0 0_____________________________-279882 255-0000-9950-018X TRANSFERS - IA 18 0 0_____________________________-56904 255-0000-9950-019A TRANSFERS - IA 19A 0 0_____________________________-161476 255-0000-9950-019C TRANSFERS - IA 19C 0 0_____________________________-197852 255-0000-9950-017A TRANSFERS - IA 17A 0 0_____________________________-143141 255-0000-9950-017B TRANSFERS - IA 17B 0 0_____________________________-114396 255-0000-9950-017C TRANSFERS - IA 17C 0 0_____________________________-66277 255-0000-9950-014X TRANSFERS - IA 14 0 0_____________________________-528159 255-0000-9950-015X TRANSFERS - IA 15 0 0_____________________________-22606 255-0000-9950-016X TRANSFERS - IA 16 0 0_____________________________-70691 255-0000-9950-011A TRANSFERS - IA 11A 0 0_____________________________-27948 255-0000-9950-012A TRANSFERS - IA 12A 0 0_____________________________-32513 255-0000-9950-013X TRANSFERS - IA 13 0 0_____________________________-35114 255-0000-9950-008X TRANSFERS - IA 8 0 0_____________________________-284787 255-0000-9950-009X TRANSFERS - IA 9 0 0_____________________________-12787 255-0000-9950-010A TRANSFERS - IA 10A 0 0_____________________________-27242 255-0000-9950-008D TRANSFERS - IA 8D 0 0_____________________________-84017 255-0000-9950-008E TRANSFERS - IA 8E 0 0_____________________________-105618 255-0000-9950-008F TRANSFERS - IA 8F 0 0_____________________________-15426 255-0000-9950-008A TRANSFERS - IA 8A 0 0_____________________________-53733 255-0000-9950-008B TRANSFERS - IA 8B 0 0_____________________________-57804 255-0000-9950-008C TRANSFERS - IA 8C 0 0_____________________________-207482 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 255-0000-9950-007D TRANSFERS - IA 7D 0 0_____________________________-86905 DRAFT Page 61 of 84 Total Activity Total Budget Total Activity 2017-2018 YTD Activity 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 646799.9 2272587 2041525.03 985,068.35 Fund: 260 - COMMUNITY FAC DISTRICT (CFD) - PUBLIC SAFETY Total:0 0 0 40387 Report Surplus (Deficit):0 2203 0 40387 5/17/2018 6:26:19 PM Page 8 of 9 Fund: 260 - COMMUNITY FAC DISTRICT (CFD) - PUBLIC SAFETY Category: 58 - OTHER FINANCING SOURCES 260-0000-4445-1602 ALLOCATED ASSESSMENTS - IA 2016-2 0 0_____________________________17818 260-0000-4445-1604 ALLOCATED ASSESSMENTS - IA 2016-4 0 0_____________________________22569 Category: 58 - OTHER FINANCING SOURCES Total:0 0 0 40387 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Defined Budgets Total Budget 2017-2018 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 DRAFT Page 62 of 84 646799.9 2272587 2041525.03 985,068.35 0 0 0 0 0 0 0 0 646799.9 2272587 2041525.03 985,068.35 260 - COMMUNITY FAC DISTRICT (CFD) - PUBLIC SAFETY 0 0 0 40387 Report Surplus (Deficit):0 2203 0 40387 5/17/2018 6:26:19 PM Page 9 of 9 2015-2016 Total Budget 2015-2016 Total Activity 2016-2017 Total Budget 2016-2017 Total Activity 2017-2018 Total Budget 2017-2018 YTD Activity 2018-2019 2018-2019 2018-2019 REV 1Fund 250 - COMMUNITY FAC DISTRICT (CFD) - ADMIN 0 2203 0 0 255 - COMMUNITY FAC DISTRICT (CFD) - MAINT SERVICES 0 0 0 0 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 Fund Summary Defined Budgets DRAFT Page 63 of 84 Page 64 of 84 5/17/2018 3:48:13 PM Page 1 of 4 Budget Worksheet City of Beaumont, CA Account Summary For Fiscal: 2017-2018 Period Ending: 06/30/2018 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets Fund: 700 - WASTEWATER FUND Category: 53 - COST RECOVERY COST RECOVERY 4,700.00700-0000-4685-0001 0.00 1,740.760.00 3,040.01 __________________________________________________________11,311.72 4,700.00 11,311.72 0.00 0.000.003,040.010.00 1,740.76Category: 53 - COST RECOVERY Total: Category: 54 - MISCELLANEOUS REVENUES INTEREST 0.00700-0000-4650-0000 1,900.00 0.000.00 920.50 __________________________________________________________0.00 REBATE REVENUE 0.00700-0000-4690-0000 0.00 0.000.00 20,000.00 __________________________________________________________0.00 0.00 0.00 0.00 0.001,900.0020,920.500.00 0.00Category: 54 - MISCELLANEOUS REVENUES Total: Category: 56 - PROPRIETARY REVENUES SEWER SERVICE FEES 7,850,000.00700-0000-4750-0000 7,005,000.00 7,351,961.516,600,929.00 7,043,813.35 _____________________________8,051,000.006,625,187.28 SEWER PERMITS/APPL.FEES 7,500.00700-0000-4752-0000 8,700.00 19,051.508,700.00 7,500.00 _____________________________10,000.009,292.50 SEWER CONNECTION FEES 15,000.00700-0000-4756-0000 0.00 0.00947,409.00 0.00 _____________________________8,000.008,344.44 SEWER STAND-BY FEE 56,000.00700-0000-4760-0000 70,000.00 52,161.1674,769.00 62,388.72 _____________________________64,620.0029,335.97 7,928,500.00 6,672,160.19 0.00 8,133,620.007,083,700.007,113,702.077,631,807.00 7,423,174.17Category: 56 - PROPRIETARY REVENUES Total: Category: 60 - PERSONNEL SERVICES GASB 68 PENSION ADJMT 0.00700-0000-6040-0000 0.00 -5,194.330.00 0.00 __________________________________________________________0.00 SALARIES 197,996.00700-4050-6010-0000 401,600.00 46,617.720.00 0.00 _____________________________673,222.00149,278.89 OVERTIME 2,000.00700-4050-6012-0000 0.00 0.000.00 0.00 _____________________________1,500.00207.90 SICK LEAVE 0.00700-4050-6013-0000 0.00 0.000.00 0.00 __________________________________________________________1,800.46 HOLIDAY 0.00700-4050-6014-0000 0.00 0.000.00 0.00 __________________________________________________________7,190.19 VACATION 0.00700-4050-6015-0000 0.00 0.000.00 0.00 __________________________________________________________2,182.95 ACCRUED TIME CASH OUT 2,000.00700-4050-6016-0000 0.00 0.000.00 0.00 _____________________________3,021.000.00 FIRST AID 0.00700-4050-6019-0000 0.00 25.000.00 0.00 __________________________________________________________0.00 HEALTH INSURANCE 30,892.00700-4050-6020-0000 0.00 8,570.700.00 0.00 _____________________________54,000.0024,325.81 DENTAL INSURANCE 1,400.00700-4050-6021-0000 0.00 242.300.00 0.00 __________________________________________________________1,108.30 WORKERS COMP 15,533.00700-4050-6022-0000 0.00 2,550.150.00 0.00 _____________________________39,550.006,159.37 DISABILITY 1,491.00700-4050-6023-0000 0.00 289.100.00 0.00 _____________________________3,814.001,167.98 P.E.R.S./P.E.P.R.A.18,793.00700-4050-6024-0000 75,620.00 8,910.790.00 0.00 _____________________________92,987.0019,052.02 DRAFT Page 65 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:48:13 PM Page 2 of 4 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets VISION CARE 80.00700-4050-6027-0000 0.00 0.000.00 0.00 __________________________________________________________57.74 LIFE INSURANCE 196.00700-4050-6028-0000 0.00 35.000.00 0.00 _____________________________252.00168.00 MEDICARE 1,842.00700-4050-6034-0000 5,816.00 666.790.00 0.00 _____________________________9,827.002,311.69 RECRUITMENT AND HIRING COS…500.00700-4050-6050-0000 0.00 1,029.500.00 0.00 __________________________________________________________210.00 272,723.00 215,221.30 0.00 878,173.00483,036.000.000.00 63,742.72Category: 60 - PERSONNEL SERVICES Total: Category: 65 - OPERATING COSTS ADMIN OVERHEAD 700,000.00700-4050-7001-0000 600,000.00 600,000.00777,000.00 370,417.00 900,000.00 612,000.00550,000.00 UTILITIES 800,000.00700-4050-7010-0000 859,400.00 713,594.15754,235.00 694,726.80 800,000.00 800,000.00530,235.85 TELEPHONE 4,500.00700-4050-7015-0000 2,500.00 4,630.8213,000.00 5,251.03 6,000.00 6,080.003,908.18 ADVERTISING 1,000.00700-4050-7020-0000 0.00 0.000.00 0.00 1,000.00 2,000.000.00 LICENSE, PERMITS, FEES 165,000.00700-4050-7022-0000 0.00 36,676.260.00 7,141.05 315,000.00_____________________________97,212.83 OFFICE SUPPLIES 2,500.00700-4050-7025-0000 4,000.00 572.291,000.00 427.28 4,000.00 1,080.00757.29 DUES & SUBSCRIPTIONS 3,000.00700-4050-7030-0000 500.00 37,421.0010,000.00 97,856.90 2,500.00_____________________________265.00 LOCAL MEETINGS 1,000.00700-4050-7035-0000 1,250.00 0.000.00 0.00 4,000.00_____________________________0.00 VEHICLE MAINTENANCE 25,000.00700-4050-7037-0000 14,600.00 0.0034,400.00 0.00 15,000.00 3,000.0010,886.80 FUEL 15,000.00700-4050-7050-0000 0.00 18,753.252,500.00 3,949.41 20,000.00 8,000.001,844.66 PERMITS, FEES AND LICENSES 0.00700-4050-7053-0000 0.00 958.420.00 0.00 3,000.00 97,215.000.00 TRAVEL, EDUCATION, TRAINING 0.00700-4050-7066-0000 0.00 0.000.00 0.00 _____________________________2,040.000.00 INSPECTIONS 0.00700-4050-7067-0000 0.00 23,100.000.00 0.00 __________________________________________________________0.00 CONTRACTUAL SERVICES 1,900,000.00700-4050-7068-0000 2,070,000.00 2,977,388.613,355,270.00 2,105,103.53 3,500,000.00 1,938,000.001,277,677.34 SPECIAL DEPT SUPPLIES 160,000.00700-4050-7070-0000 4,500.00 93,339.3830,000.00 192,842.12 230,000.00 290,000.00166,318.32 SOFTWARE 20,000.00700-4050-7071-0000 65,000.00 0.000.00 0.00 30,000.00 91,200.009,396.00 COMPUTER SUPPLIES/MAINT 0.00700-4050-7072-0000 0.00 0.000.00 0.00 3,000.00 1,400.000.00 EQUIPMENT LEASING/RENTAL 60,000.00700-4050-7075-0000 0.00 93,106.610.00 26,766.75 80,000.00 80,000.0012,277.70 BUILDING SUPPLIES/MAINT 0.00700-4050-7085-0000 0.00 0.002,500.00 3,904.79 2,000.00 1,000.000.00 SECURITY SERVICES 13,000.00700-4050-7087-0000 0.00 3,762.000.00 4,207.75 26,000.00 8,000.0014,431.00 EQUIPMENT SUPPLIES/MAINT 20,000.00700-4050-7090-0000 16,500.00 55,072.711,300,000.00 73,685.19 45,000.00_____________________________16,359.48 3,890,000.00 2,691,570.45 5,986,500.00 3,941,015.003,638,250.003,586,279.606,279,905.00 4,658,375.50Category: 65 - OPERATING COSTS Total: Category: 70 - CAPITAL IMPROVEMENTS MITIGATION COSTS - ADMIN 0.00700-4050-7920-0000 0.00 0.000.00 24,922.44 __________________________________________________________0.00 CAPITAL IMPROVEMENT 0.00700-4050-8030-0000 0.00 2,791.480.00 0.00 __________________________________________________________0.00 DRAFT Page 66 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:48:13 PM Page 3 of 4 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Activity 2016-2017 Total Budget 2015-2016 Total Activity 2015-2016 Total Budget 2018-2019 2018-2019 2018-2019 REV 1 Defined Budgets EQUIPMENT 0.00700-4050-8040-0000 0.00 3,547.880.00 0.00 100,000.00 89,750.000.00 0.00 0.00 100,000.00 89,750.000.0024,922.440.00 6,339.36Category: 70 - CAPITAL IMPROVEMENTS Total: Category: 90 - TRANSFERS TRANSFERS 0.00700-0000-9950-0000 0.00 -1,270,845.770.00 0.00 __________________________________________________________-3,600,000.00 TRANSFERS -1,200,000.00700-4050-9950-0000 0.00 0.000.00 0.00 __________________________________________________________0.00 -1,200,000.00 -3,600,000.00 0.00 0.000.000.000.00 -1,270,845.77Category: 90 - TRANSFERS Total: 2,570,477.00 176,680.16 -6,086,500.00 3,224,682.002,964,314.003,526,460.541,351,902.00 1,425,611.58Fund: 700 - WASTEWATER FUND Surplus (Deficit): 2,570,477.00 -6,086,500.00 3,224,682.002,964,314.003,526,460.541,351,902.00 176,680.161,425,611.58Report Surplus (Deficit): DRAFT Page 67 of 84 Budget Worksheet For Fiscal: 2017-2018 Period Ending: 06/30/2018 5/17/2018 3:48:13 PM Page 4 of 4 Fund Summary Fund 2017-2018 YTD Activity 2017-2018 Total Budget 2016-2017 Total Budget 2015-2016 Total Budget Defined Budgets 2016-2017 Total Activity 2015-2016 Total Activity 2018-2019 2018-2019 2018-2019 REV 1 700 - WASTEWATER FUND 2,570,477.00 -6,086,500.00 3,224,682.002,964,314.001,351,902.00 176,680.163,526,460.54 1,425,611.58 Report Surplus (Deficit):2,570,477.00 -6,086,500.00 3,224,682.002,964,314.001,351,902.00 176,680.163,526,460.54 1,425,611.58 DRAFT Page 68 of 84 DRAFT BUDGET FISCAL YEAR 2018-2019 Page 69 of 84 IMPROVE FISCAL SUSTAINABILITY MAXIMIZE BASIC RESOURCES ENHANCE PUBLIC SAFETY DEVELOP PUBLIC AFFAIRS CULTIVATE ECONOMIC DEVELOPMENT Where are we now?Page 70 of 84 FISCAL MODELING CAPITAL IMPROVEMENT PLAN POTRERO INTERCHANGE WASTEWATER PLANT EXPANSION WEST SIDE FIRE STATION DESIGN PUBLIC INFORMATION ECONOMIC DEVELOPMENT Continuous EffortsPage 71 of 84 FISCAL SUSTAINABILITY – ◦Enhance Multi-Year Fiscal Models ◦Community Investment Plan (5-Year) ◦Maintain Unobligated Reserve Balances MAXIMIZE BASIC RESOURCES – ◦Transportation Enhancements ◦Utility Capacity Expansion ◦Park Improvements/Upgrades ENHANCE PUBLIC SAFETY – ◦Paramedic Crew ◦West Side Fire Station –Design/Construction DEVELOP PUBLIC AFFAIRS – ◦Communications Strategic Plan ◦New/Improved Website ◦New Beaumont App CULTIVATE ECONOMIC DEVELOPMENT – ◦Economic Development Strategic Plan ◦Central City Beautification Concept PlanPage 72 of 84 FISCAL 2018-2019 BUDGET GENERAL FUND WASTEWATER FUND CFD FUNDS Page 73 of 84 6 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017MillionsSecured Property Tax Revenues 2008 to 2017 Residential Commercial Industrial VacantPage 74 of 84 -15.0% -10.0% -5.0% 0.0% 5.0% 10.0% 15.0% 20.0% 2009 2010 2011 2012 2013 2014 2015 2016 2017 Percent Change in Levy 2008 to 2017 Page 75 of 84 ENHANCEMENTS ◦Segregate Functions I.T., H.R. & Risk Management Finance & Budget Building Maintenance ◦Additional Staffing Finance Department ◦Equipment Streets Department ◦Contingency Ability to Manage Unexpected Costs ◦Reserves Capacity for the Future Page 76 of 84 50% 9% 23% 16% 2% FY2018 Budget Taxes Permits Charges for Service Transfers OtherPage 77 of 84 52% 10% 22% 15% 1% FY2019 Draft Budget Taxes Permits Charges for Service Transfers OtherPage 78 of 84 2016 2017 2018 2019 Actual Actual Budget Proposed Taxes $ 15,958,795 $ 16,169,475 $ 16,183,810 $ 17,878,286 Licenses $ 196,185 $ 231,688 $ 210,000 $ 212,100 Permits $ 2,867,229 $ 4,015,298 $ 3,738,000 $ 3,300,350 Intergovernmental $ 29,788 $ 91,082 $ 7,288 $ 7,288 Charges for Service $ 6,491,373 $ 6,956,973 $ 7,450,000 $ 7,644,900 Fines and Forfeitures $ 132,070 $ 128,005 $ 148,000 $ 110,000 Cost Recovery $ 392,926 $ 426,733 $ 285,000 - Miscellaneous $ 28,349 $ 3,079,683 $ 26,500 $ 36,500 Other $ 19,479 $ 68,843 - - TOTALS $26,116,195 $31,167,779 $28,048,598 $29,189,424 SOURCE Page 79 of 84 49%49% 2% FY17-18 (5/15/18) Personnel Operations Capital 49%49% 2% FY18-19 Proposed Personnel Operations Capital Page 80 of 84 Police Department Vehicle Replacements (4) Building Official Vehicle Replacement (1) Community Services Replace Mowers (3) Streets Department Equipment ◦Dump Truck (Shared w/Wastewater 75/25) ◦Backhoe (Shared w/Wastewater 50/50) ◦Paving Roller ◦Trailer ◦Stump Grinder Page 81 of 84 ENHANCEMENTS ◦Bringing Operations In-House ◦Allocations for Major System Repair/Replacement ◦Maintain Unobligated Reserve Funds RATE INCREASE NOT INCLUDED ◦Prop. 218 Rate Hearing –June 19, 2018 ◦Revenues Exceed Expenses $3.2 Million ◦Rate Increases Incorporated post June 19, 2018 Used Entirely for Debt Service Will Not Impact Operational AllocationsPage 82 of 84 18% 80% 2% FY18-19 Proposed Budget Personnel Operations CapitalPage 83 of 84 SPECIAL REVENUE FUNDS ◦Administrative Assessments ◦Maintenance Assessments ◦Public Safety Assessments ENHANCEMENTS ◦Detailed Reporting of Assessments by Subdivision ◦Detailed Reporting of Direct Costs by Subdivision Page 84 of 84