4.4. Waive the right to perform and complete, arrange for completion, or obtain a new Franchisee and with reasonable promptness under the circumstances:
(1) After investigation, determine the amount for which it may be liable to the 258
90 City and, as soon as practicable after the amount is determined, tender payment therefore to the City; or
(2) Deny liability in whole or in part and notify the City citing reasons therefore
5. If the Surety does not proceed as provided in Paragraph 4 with reasonable promptness (and in any event within the 45-day period commencing on the receipt by the Surety of the notice referred to in subparagraph 3.2 hereof), the Surety shall be deemed to be in default on this Bond and without further notice the City shall be entitled to enforce any remedy available to the City, including without limitation arranging for the work under the Operation Contract to be completed by a qualified Franchisee or Franchisees selected by the City and seeking compensatory damages from the Surety. If the Surety proceeds as provided in subparagraph 4.4, and the City refuses the payment tendered or the Surety has denied liability, in whole or in part, without further notice the City shall be entitled to enforce any remedy available to the City, including without limitation arranging for the work under the Operation Contract to be completed by a qualified Franchisee or Franchisees selected by the City and seeking compensatory damages from the Surety.
6. After the City has terminated the Company’s right to complete the Operation Contract, and if the Surety elects to act under Subparagraph 4.1, 4.2, or 4.3 above, then the responsibilities of the Surety to the City shall not be greater than those of the Company under the Operation Contract, and the responsibilities of the City to the Surety shall not be greater than those of the City under the Operation Contract. To the limit of the amount of this Bond, but subject to commitment by the City of the Balance of the Contract Price to mitigation of costs and damages on the Operation Contract, the Surety is obligated without duplication for:
6.1. The responsibilities of the Company for the collection of Franchise Materials in accordance with the Operation Contract;
6.2. Additional legal, design, professional, and delay costs resulting from the Company Default, and resulting from the actions or failure to act of the Surety under Paragraph 4; and
6.3. Liquidated damages, or if no liquidated damages are specified in the Operation Contract, actual damages caused by delayed performance or nonperformance of the Company.
7. The Surety shall not be liable to the Company or others for obligations of the Company that are unrelated to the Operation Contract, and the Balance of the Contract Price shall not be reduced or set off on account of any such unrelated obligations. No right of action shall accrue on this Bond to any person or entity other than the City or its heirs, executors, administrators or successors.
8. The Surety hereby waives notice of any change, including changes of time, to the operation Contract or to related subcontracts, purchase orders and other obligations.
9. Any proceeding, legal or equitable, under this Bond may be instituted in any court of 259
91 competent jurisdiction in the location in which the work or part of the work is located and shall be instituted within two years after Company Default or within two years after the Company ceased working or within two years after the Surety refuses or fails to perform its obligations under this Bond, whichever occurs first. If the provisions of this Paragraph are void or prohibited by law, the minimum period of limitation available to sureties as a defense in the jurisdiction of the suit shall be applicable.
10. Notice to the Surety, the City, or the Company shall be mailed or delivered to the address shown on the signature page.
11. When this Bond has been furnished to comply with a statutory or other legal requirement in the location where the construction was to be performed, any provision in this Bond conflicting with said statutory or legal requirement shall be deemed deleted here from and provisions conforming to such statutory or other legal requirement shall be deemed incorporated herein.
12. DEFINITIONS
12.1. Balance of the Contract Price: The total amount due and payable by the City to the Company under the Operation Contract after all proper adjustments have been made, including allowance to the Company of any amounts received or to be received by the City in settlement of insurance or other claims for damages to which the Company is entitled, reduced by all valid and proper payments made to or on behalf of the Company under the Operation Contract.
12.2. Operation Contract: The Franchise Services Agreement between the Company and the City, effective July1, 2025.
12.3. Company Default: Failure of the Company, which has neither been remedied nor waived, to perform or otherwise to comply with the terms of the Operation Contract, including, without.
12.4. City Default: Failure of the City, which has neither been remedied nor waived, to pay the Company as required by the Operation Contract to perform and complete or comply with the other terms thereof, which failure must be sufficiently serious to justify a termination of the Operation Contract, including, without limitation, an Event of Default of the City, as defined in the Co-Operation Agreement. 260
92 MODIFICATIONS TO THIS BOND ARE AS FOLLOWS:
This Bond has been entered into to bind the Surety and the Company, as principal, unto City of King, City of Greenfield, City of Gonzales, and City of Soledad, it successors and assigns, in the penal sum of ONE MILLION DOLLARS($1,000,000), lawful money of the United States of America, for the payment of which said sum of money well and truly to be made, the Surety and the Company bind themselves, their successors and assigns in such sum “jointly and severally” and well as “severally only” for the purpose of allowing a joint action or actions against any or all of them and for all other purposes, each bindsitself, its successors and assigns, jointly and severally to the City, its successors and assigns for the payment of such sums as to which the Company or the Surety may become obligated to pay under this Performance Bond. (Space is provided below for additional signatures or added parties, other than those appearing on the cover page.)
COMPANY AS PRINCIPAL SURETY
Name:____________________________ Name:____________________________ (Corporate Seal) (Corporate Seal)
Signature:_________________________ Signature:_________________________ Name and Title:____________________ Name and Title:____________________ 261
93 APPENDIX H
Reporting Requirements
The Franchisee shall comply with the following reporting requirements for the duration of the Franchise Term.
• Prior to the initial preparation of the reports required by this Agreement Franchisee shall consult with the City to establish the format and data definitions for each report that best meets the City’s needs.
• All reports shall be submitted electronically unless otherwise specified. • Electronic reports shall be in a PC-based Excel, or Excel-compatible format or any other mutually agreed upon format.
• Reports shall be submitted by the 25th of each month following the reporting period unless otherwise specified.
• Franchisee shall provide the City with on-request reports within thirty (30) working days of request; provided such reports do not result in additional costs to Franchisee. • All reports shall be on a Calendar Year (January 1 – December 31) basis.
A. Solid Waste Data
1. Residential Collection Services:
Monthly
a. Total Tons collected and delivered to Disposal facilities.
Quarterly
a. Total number of service accounts by service classification level.
Upon Request
a. By route: number of daily setouts,
b. By route: Tons Collected and delivered to Disposal facilities, c. Truck identification number for each daily route,
d. By route: number of service accounts by service classification level, e. By route: number of Collection Containers distributed by size, f. Total number of Collection Containers distributed by size.
2. Commercial Collection Services
Monthly
a. Total Tons collected and delivered to Disposal facilities. 262
94 Quarterly
a. Total number of service accounts by service classification level.
Upon Request
a. By route: Tons Collected and delivered to Disposal facilities, b. Truck identification number for each daily route,
c. By route: number of service accounts by service classification level (size & frequency),
d. By route: number of Collection Containers distributed by size, e. Total number of Collection Containers distributed by size.
3. City Services (Cities Facilities / Public Containers / Cleanup Events) Monthly
a. By location: Tons Collected from Roll-off Bins and delivered to Disposal facilities, and
b. Number of Collection Containers serviced by size, location and route.
B. Organic Waste Data
1. Residential Collection Services
Monthly
a. Total Tons collected and delivered to Disposal facilities.
Quarterly
a. Total number of service accounts by service classification level.
Upon Request
a. By route: number of daily setouts,
b. By route: gross Tons Collected daily,
c. Truck identification number for each daily route,
d. By route: weekly participation Rates in terms of weekly set out counts, e. Monthly participation Rates based on a methodology to be agreed upon by the City and Franchisee,
f. Total setouts and tonnages, monthly by route and total monthly, g. By route: number of service accounts by service classification level, and h. Number of Collection Containers distributed by size and Customer type (Cart/Bin), including home Composting and worm bins.
263
95 2. Commercial Collection Services
Monthly
a. Total Tons Collected and delivered to Disposal facilities.
Quarterly
a Commercial Cart Customers (w/Organic Waste) included with residential Cart customer reporting.
Upon Request
a. By route: number of service accounts by Container size, b. By route: number of daily setouts (Collected by cart Collection vehicle - Organic Waste not offered as part of franchise Bin service), c. Method for separate tracking of quantities from Bin Customers with Organic Waste service to be determined.
C. Recycling Data
1. Residential Collection Services
Monthly
a. Total Tons Collected by material type and delivered to Recycling facilities.
Quarterly
a. Total number of service accounts by Container type.
Upon Request
a. By route: number of daily setouts,
b. By route: gross Tons Collected daily,
c. Truck identification number for each daily route,
d. By route: weekly participation rates in terms of weekly set out counts, e. Monthly participation Rates based on a methodology to be agreed upon by the City and Franchisee,
f. Total setouts and tonnages, by material category, monthly by route and total monthly,
g. By route: number of service accounts by Container type (Cart/Bin), and h. Number of Collection containers distributed by size and Customer type (Cart/Bin).
264
96 2. Commercial Collection Services
Monthly
a. Total Tons Collected by material type and delivered to Recycling facilities.
Quarterly
a. Total number of service accounts by service classification level service, and b. AB 341, SB 1383 and AB 1826 reporting shall include participation rates for all Commercial, Industrial and Multi-Family Dwelling accounts. See example below:
AB 341, AB 1826, & SB
1383Compliance Reports
Total Number of Businesses
Customers
Businesses with 4CY+/Week
With Recycling
W/O Recycling
Business Compliance Rate
Businesses with 2CY+/Week
With Organic Waste
W/O Organic Waste
Business Compliance Rate
Multiple Dwelling 5+ Units
With Recycling
W/O Recycling
With Organic Waste
W/O Organic Waste
Multiple Dwelling
Compliance Rate
Education and Outreach
Report
Number of waste
assessments
Number of phone calls and
letters
Number and type of other Ed
& Outreach
265
97 Upon Request
a. By route: gross tons Collected daily by material category/type (single stream and commingled),
b. Truck identification number for each daily route,
c. Total tonnages, by material type, monthly by route and total monthly, d. By route: number of service accounts by service classification level service, e. Number of Collection Containers distributed by size and customer type (Cart/Bin).
3. City Services / Public Recycling Containers / Cleanup Events - Collection City
Quarterly (for each sector listed above)
a. By location: Tons Collected by material category/type (single stream and commingled) and delivered to processing facility,
b. Number of Recycling Collection Containers serviced by size, material type and location.
4. Processing and Marketing Services - Monthly
a. By material type (and grade where appropriate): monthly totals of quantities processed,
b. By material type (and grade where appropriate): monthly totals of quantities sold; specify purchaser name and location, price received per ton and total payment,
c. By material type: quantities donated or otherwise disbursed without compensation,
d. Monthly quantity of processing Residue and characterize (in manner defined by the City),
e. Describes and quantify any contamination problems, reject loads, etc., f. Method for tracking separately- by collection origin- quantities processed and sold, by material type.
5. Summary Report Format – Monthly
a. Summary reports should be separated by line of business (residential, Commercial, Multi-Family, industrial/drop box) and should include calculated recovery rates, including residuals, and an overall recovery rate of services. See example below:
D. Praises, Complaints, Missed Pickups and Resolutions - Quarterly a. Summarize any praises and complaints received in such month b. Complaints which require the payment by the Franchisee of liquidated damages 266
98 pursuant to this Agreement, and
c. Written record of all calls related to missed pickups and responses to such calls E. Public Education and Information – Quarterly
a. Summary description of public education and information activities undertaken b Distribution of individual Customer literature, Collection notification tags, community information and events, tours and other activities as identified in Appendix F of this Franchise, and
c. Describes any perceived needs for publicity or public education.
F. Problems and Actions Taken – Quarterly
a. Summary narrative of problems encountered with Collection and processing activities and actions taken,
b. Type and number of notification tags left at Customer accounts, c. Instances of and responses to property damage or injury, poaching or scavenging, significant changes in operation, market factors, and
d. Description of processed material loads rejected for sale, reason for rejection and disposition of load after rejection.
G. Annual Report Submittals
Annual reports shall be submitted no later than ninety (90) days following the end of the Franchise Year.
I. Annual Report Contents
a. Summarizes the numerical information contained in the monthly and/or quarterly reports,
b. Complete inventory of Collection and major processing equipment including stationary, and rolling stock, Collection Containers by type and size, c. Discuss public awareness activities and their impact on Recycling and Organic Waste participation and recovered amounts,
d. Analysis of Collection, processing and marketing problems or conditions (participation, set outs, contamination, market trends, etc.) and possible solutions, e. Summarize Customer complaints or comments to convey any trends or developing situations.
H. Additional Reports.
a. Monthly- Overage-fees charged to all Customer types for Solid Waste and Organic Waste overage Collection per Section 4.1 B.5,
b. Monthly- Drop Box Charges- fees charged to all Customer types for Drop-Box services per Section 4.1 C.3,
c. Monthly- Bulky Item Fees- fees charged to all Customer types for the Collection 267
99 of Bulky Items and excess amounts of Franchise Materials, and d. Financial reports pursuant to Section 6.3 and any additional monthly or annual reports as may be required to set forth all information required under the Act or otherwise by the City pertaining to the Recycling and Diversion of Franchise Materials which is Collected and/or processed by the Franchisee. Said reports shall be in the form required by the City and shall categorize Recycling and Diversion activity in the manner required by the City.
268
100
APPENDIX I
STREET SWEEPING
In accordance with Section 5.09.K, it is the responsibility of the Franchisee to provide street sweeping services to the Cities upon request. If street sweeping is provided to the Cities’ by the Franchisee, the Cities will provide a dedicated water supply, sufficient space for Drop-Box storage and payment of all fees for disposal of debris produced by street sweeping activities. Accordingly, the following minimum requirements must be met by the Franchisee:
1. Equipment:
a. Street Sweeping service shall be provided, by Franchisee with Franchisee equipment and personnel. The Franchisee shall have the right to subcontract this service with the approval by the City Manager(s) or their designee(s).
b. Water from the sweeper’s water system shall be used during all sweeping to provide dust suppression and prevent unnecessary wear to moving parts or vacuum apparatus. c. Street Sweepers used as part of this Franchise must meet California Air Resources Board requirements, as well as compliance with Article V of this Franchise.
2. Operations:
a. Establish and maintain a continuous level of cleanliness of Cities’ streets in order to assure protection of the health, safety and welfare of the community. b. Clean Cities’ streets in a systematic and coordinated manner that compliments solid waste collection and other Cities’ services, by use of a routing system that provides high-level street cleaning practices while maintaining acceptable costs. Routes shall be agreed upon and change as growth occurs. Appendix E shall include the residential, Commercial and industrial routes for each City. All Parties agree to work in good faith on changes to routes.
c. All streets shall be swept along paved surfaces for the full length and width of the shoulder where there is either a raised curb or gutter, median or median barrier to the end of the pavement.
d. Streets shall be maintained clean and free of debris commensurate with the number of parked cars and access to the curb and gutter for cleaning. This may require two passes of an area at the discretion of the operator if sufficient time is available for completion of the sweeping route.
e. When feasible, leave routes to sweep around schools and neighborhood areas where sweeping cannot be accomplished after school begins.
f. Emergency response (accidents/spills).
269
101
g. Additional limited sweeping support of facility parking lots upon request for parks/community center/libraries.
h. Disposal of debris from street sweeping shall be the responsibility of the Franchisee.
Franchisee agrees to work with Cities for sampling the material removed from streets if required or desired.
i. Cities may determine that some areas in their community should be swept more frequently in exchange for less frequently in another area. If the areas are approximately equal in, there shall be no changes for this exchange of frequency. j. The Cities may order the suspension of sweeping/cleaning operations whenever, in their judgment, current or impending weather conditions are such that sweeping/cleaning cannot be carried out in a safe and/or effective manner.
3. Schedule:
a. Residential streets shall be swept once every week between the hours of 5:00 am and 5:00 pm on the day of or the first Business Day after Solid Waste collection. b. Commercial streets shall be swept once every week between the hours of 5:00 am and 5:00 pm.
4. Records:
a. Records shall be maintained recording the daily cubic yards or Tons of debris Collected from each street sweeper.
b. Records shall be maintained recording the number of curb miles swept.
5. Customer Service:
a. The Franchisee maintains a 24-hour phone number to accept residential concerns or complaints regarding the street sweeping program.
b. Response to resident complaints or concerns shall, whenever possible, occur the same day.
6. Fees
The Franchisee shall, without charge or compensation, provide weekly street sweeping services to each City on the day of or the first working day following each Residential Collection route. If additional street sweeping services are required by any of the Cities, each City may negotiate an independent contract to compensate the Franchisee.
270
102
APPENDIX J
ANNUAL SERVICE RATE CAP ADJUSTMENT CALCULATIONS
271
103
APPENDIX K
COMPOSITION AUDITS
Composition Audits of the Franchise Recyclable Materials will determine the percentage of each category of material found in the Franchise Recyclable Materials Collected under the Agreement.
The protocol for conducting audits will consist of the following standards:
a) Franchisee will weigh each receptacle before the Composition Audit begins to establish an accurate tare weight for each receptacle before weighing each component sample. After the Collection vehicle empties the entire load onto the tip floor, a random sample will be selected from the pile, from which a minimum one hundred (100) pound (approximately 1.5 cubic yards), random sample will be removed. Five (5), one hundred (100) pound, random samples of Franchise Recyclable Materials (from different routes, different times of day, and different days of the week) will be segregated, sorted, and weighed (each, an “audit”). The samples will then be transported to the sorting area and hand sorted. Components will be sorted into Bins and/or carts based on the material type and size, and each material will be weighed to the nearest tenth of a pound. After all samples have been collected, weighed, and recorded, composition and quantity estimates of the Franchise Recyclable Materials are calculated and recorded. The results of the audits of such samples shall be averaged and used to calculate the inbound composition of the Franchise Recyclable Materials (the “Composition Audit”). b) Franchisee shall conduct a Composition Audit during the first thirty (30) days of the Agreement to establish the initial inbound composition of the Franchise Recyclable Materials, the results of which shall be retroactive to the first date Franchise Recyclable Materials are collected.
c) Additional Composition Audits will be undertaken as Franchisee reasonably deems necessary upon notice to the City. City may also request a Composition Audit not more than twice per twelve- (12-) month period during the Term.
d) Franchisee will notify City in advance of all prospective Composition Audit dates and times at least one (1) week prior to undertaking a Composition Audit. City may have a representative present at the Composition Audit.
272
CITY OF GREENFIELD
CITY COUNCIL MEETING
MARCH 14, 2023
BY R. PATRICK MATHEWS, GENERAL MANAGER/CAO
COLLECTIVE
REQUEST FOR PROPOSALS
FOR
PROCUREMENT OF
SOLID WASTE, RECYCLABLES,
AND ORGANIC WASTE
COLLECTION SERVICES
ON BEHALF OF
CITIES OF GONZALES, GREENFIELD,
SOLEDAD, AND KING CITY
273
INTENT AND PURPOSE
▪ New Franchise Services Procurement
▪ Current Contract Term Ends June 30, 2025
▪ Joint Effort to Solicit Competitive Bids
▪ Lead by Salinas Valley Solid Waste Authority
▪ On behalf of South County Cities
▪ Benefit from Increased Economies of Scale
▪ A Four-Cities Franchise Zone
▪ Flexible Contracting Structure (singular or joint
agreements)
▪ Update Contracts with new State regulations and City
Code
▪ Standardize Collection Services, Programs, and Rates
Costs
Compliance
Collection
274
KEY COLLECTION ELEMENTS
RESIDENTIAL 3-CART SERVICE
▪ Standard Color Carts & Labeling
▪ Unlimited Recycling & Organic Waste
Capacity at No Additional Cost
▪ Curbside Used Motor Oil and Filter Recycling
Program
▪ Curbside Used Battery Collection Program
▪ 3 Free Bulky Item Collections per Year
Used Motor Oil
Bulky Items
Used Household
Batteries
Unlimited
Diversion
275
KEY COLLECTION ELEMENTS
COMMERCIAL BIN SERVICE
▪ Standard Color Bins & Labeling
▪ Tracking and Reporting of Compliance with
Diversion Mandates
▪ 50/50 Recycling Capacity at No Additional Cost
▪ Recycling capacity equal to Solid Waste capacity.
Additional capacity at 30% or less of equivalent
solid waste service level rate.
▪ Organics Capacity as Requested to Comply
with AB1826 and SB1383 for an Added Cost
▪ 3 Free Bulky Item Collections per Year
Solid Waste Recyclables
Organics
276
KEY COLLECTION ELEMENTS
OTHER SERVICES
▪ 3 Annual Community Cleanup Events
per City
▪ 2 Annual Litter & Debris Removal Events
per City
▪ 6 Special Events Drop-Box Services
per City
277
OTHER PROPOSAL ELEMENTS
▪ Optional Street Sweeping on Collection Routes
▪ Optional Reimbursement for City Billing
▪ Reimbursement for Procurement Costs
▪ Not to exceed $125,000 amongst all parties
▪ Reimbursement for SB 1383 Regulatory Costs
▪ $25,000 per year per City
▪ Reimbursement for Franchise Agreement
Administration Costs
▪ $10,000 per year per City
▪ $20,000 per year for SVSWA
278
RFP TIMELINE
Formal issuance of RFP to proposers March 17, 2023
Receive letters of intent (mandatory)/initial written questions April 10, 2023 Pre-proposal conference (mandatory) April 21, 2023
Deadline for final Written Questions May 12, 2023
Cities/Authority issues written response to questions June 3, 2023 Proposal submission deadline June 30, 2023
Interviews & Shortlisting (if required) August 2023
Public presentation by selected proposers September 2023 Cities to receive recommended contractor selection & authorize negotiations September - October 2023 Franchise Agreement(s) negotiations completed January – March 2024 Final Franchise Agreement(s) to Cities for Deliberations/Public Comment/Approval March - June 2024 Estimated full implementation of services:
Incumbent(s) 1-2 months
New Contractor(s) 8-12 months, and no later than July 1, 2025 279
Selection Committee Composed of City Representatives
w/SVSWA in Administrative-Advisory Role
Evaluation Criteria Categories
• Company Qualifications
• Technical Capability
• Contractual Issues
• Financial Strength
• Costs
• Overall Goal Attainment and Conformity
EVALUATION AND SELECTION COST EFFECTIVNESS
QUALITY SERVICE
CONSERVE
RESOURCES/ASSETS
MAXIMUM COMMUNITY
BENEFITS
ADMINISTRATIVE
PERFORMANCE
COLLECTIONS &
PROCESSING
MAXIMIZE DIVERSION
CUSTOMER SUPPORT
280
QUESTIONS
COMMENTS
281
MEMORANDUM: March 10, 2023
AGENDA DATE: March 14, 2023
TO: Mayor and City Council
FROM: Fabiola Lopez
Community Engagement Coordinator
TITLE: CONSIDERATION OF A DONATION OF (A SPECIFIC AMOUNT OF MONEY) TO A.V.I.L.A. VICTORY BOXING, INC.
BACKGROUND:
Council will be deciding on A.V.I.L.A Victory Boxing Inc’s (AVB) request for funding. AVB has requested the city’s support of rent payment towards their program facility at 36 4th St #C for a minimum of 18 months and maximum of 24 months. Total rent payment will be $2,200 per month beginning June 2023. Sponsorship of future events (amt unknown at the moment) has also been requested.
A.V.I.L.A VICTORY BOXING, Inc (AVB) is a year-round program that provides children and youth an opportunity to develop new skills through the art of boxing and coaching. Program participants will be able to set personal goals, build confidence, learn self-defense techniques, respect, and engage in healthy relationships. One of the most important lessons children and youth may learn from boxing is discipline. AVB’s overall mission is to help children and youth meet their full potential by receiving quality 1:1 coaching, an opportunity for growth, and build meaningful peer relationships with individuals with the same goals and interests. AVB formally became an organization in January 2021 and a 501(c)(3) in September 2021. Prior to establishing the organization AVB was already a program operating out of a small garage for roughly 4 years, it has grown to about 300 youth members which led to the need of a larger facility.
City of Greenfield believes in the benefit and impact of the high-quality program that AVB offers to our youth. A serious issue Greenfield youth and their parents have faced for decades is a lack City Council Memorandum
599 El Camino Real Greenfield CA 93927 (831) 674-5591
www.ci.greenfield.ca.us
282
of more programs like AVB that helps decrease the number of youths getting involved in unhealthy and harmful activities.
Before AVB began to occupy the current facility, in an effort to support their(AVB’s) work, City of Greenfield shared two available spaces for them to use for their training at Patriot Park Community Center however this was not large enough and the locations did not meet their needs.
Fire Chief Langborg has offered emergency services if they meet requirements during events that are held at approved locations in Greenfield (ex. GVMH).
The Greenfield Police Department has sponsored a youth to be part of AVB and hopes to continue doing this in the future.
Fire Marshal Jim Dias has provided safety requirements to the City of Greenfield Building Official which has been relayed to AVB.
Historic issues that have created misunderstandings for both parties lay in the type of operations that would take place at the current location and the occupancy load (outlined below in staff recommendations). According to the Fire Code, due to fire and building safety concerns, at no time should there be more than 48 persons in the facility. Any additional persons over this limit will trigger the need for building improvements like fire sprinklers, additional exits, and much more. Exceeding the use load would also risk the consequence of closing the facility until improvements are made.
The City of Greenfield agrees with Karina Ramirez’ sentiments that AVB provides more than just training, it’s a safe place for youth. According to Ramirez, through communication with their peers and coaches who truly care about them, AVB becomes a place that supports the mental and emotional wellbeing of its participants. Although the City holds programs like these in high esteem, it cannot ignore the processes outlined below that ensure, first of all, building safety then compliance with ordinances.
BUDGET AND FINANCIAL IMPACT:
Monthly Rent: $2000.00- $2,200/month for 18 to 24 months plus sponsorship and emergency response.
Funding request for rent is a minimum of $39,600 (18 months) and a maximum of $52,800 (24 months)
Historical Funding Levels (last 8 years)
FY total FY
3/10/2015 Sober Grad Night $ 2,500
3/31/2016 Sober Grad Night $ 100
3/31/2016 Little League $ 500 $ 3,100 FY15-16
5/23/2017 Sober Grad Night $ 2,500 $ 2,500 FY16-17
5/7/2018 Sober Grad Night $ 2,500 $ 2,500 FY17-18
283
4/25/2019 Sober Grad Night $ 3,750 $ 3,750 FY18-19
1/13/2020 Ricky's Kids $ 2,000
6/25/2020 Sober Grad Night $ 3,750 $ 5,750 FY19-20
4/30/2021 Sober Grad Night $ 4,000 $ 4,000 FY20-21
4/27/2022
Lideres
Campesinas $ 1,500 $ 1,500 FY21-22
Eight Year total of
donations $ 23,100 $ 23,100
STAFF RECOMMENDATIONS:
In your decision making, city staff recommends that any sponsorship and/or rent support is contingent on the following to ensure that all activities meet safety standards, city ordinance and building standards:
Minimum needs to operate (occupants not exceeding 48):
Apply and Obtain a Business License for current location in Suite C (Title 5 Ordinance
5.04.020)
Apply and Obtain Building Permit which will establish the Occupancy Group, Occupancy use, Max Occupancy (48), Accessibility, etc, (once city has completed a building permit inspection, a certificate of occupancy can be issued) CBC 2022 105.1) Obtain a Certificate of Occupancy (CBC 2022, Sect. 304.1) Change of occupancy group and use (A-4; Events) will require building permits for “Tenant Improvements (T.I.)” for code and zoning compliance. (use that exceeds maximum capacity triggers more safety requirements)
Apply for and obtain a conditional use permit from planning commission. (3-6 month process)
Building improvement requirements are based on fire and building code; fire sprinkler installations, additional means of egress and exiting, etc.) Special Events Application must be submitted for each event (at approved locations ex. GVMH)
POTENTIAL MOTION:
I MOVE TO APPROVE/DENY A DONATION OF (A SPECIFIC AMOUNT OF MONEY) TO A.V.I.L.A. VICTORY BOXING, INC.
284
MEMORANDUM: March 10, 2023
AGENDA DATE: March 14, 2023
TO: Mayor and City Council
FROM: Jamie Tugel, Public Works Director
TITLE: RECEIVE A PRESENTATION ON THE SALINAS VALLEY SAFE
ROUTES TO SCHOOL PLAN AND THE GREENFIELD
PARTICIPATORY BUDGETING PROCESS AND RESULTS OF
THE COMMUNITY VOTE AND APPROVE RESOLUTION NO.
2023- XX PRIORITIZING THE PROJECTS BY THE GREENFIELD
STEERING COMMITTEE AND DIRECTING STAFF TO
SCHEDULE IMPLEMENTATION OF THESE PROJECTS
BACKGROUND:
In December 2022, Greenfield community members voted on a list of street projects that would make it safer and more comfortable for children to get to and from schools in the City. This voting process, known as “participatory budgeting” is intended to empower community members to help set priorities for public funding. The ballot was developed by a group of Greenfield community members and advocates and Greenfield public works staff. The Transportation Agency for Monterey County will provide a grant up to $250,000 to implement projects that come out of the participatory budgeting process.
DISCUSSION:
The participatory budgeting process was introduced to Greenfield as part of the Salinas Valley Safe Routes to School Plan which is in development and will include recommendations for all public K-12 schools in the cities of Gonzales, Soledad, Greenfield and King City. The Plan is funded through a Caltrans Sustainable Transportation Planning grant and Measure X Safe Routes to School funds and sponsored by the Transportation Agency for Monterey County. The planning team is made up of staff from the Transportation Agency, Ecology Action (non-profit organization), and Monterey County Health Department.
City Council Memorandum
599 El Camino Real Greenfield CA 93927 (831) 674-5591
www.ci.greenfield.ca.us
285
Since the planning effort kicked-off in February 2022, the team has reviewed existing planning documents relevant to safe routes to schools to ensure consistency with existing plans and projects. In order to find out how community members currently travel to and from school and what the major concerns and issues are the team collected parent survey data, collected and analyzed crash data, and distributed student travel mode surveys. The team also visited each of the school sites to observe the morning drop-off or afternoon pick-up and note any infrastructure deficiencies and/or dangerous behaviors. All of the input from community members and data collected were used to develop draft street safety recommendations for each of the cities in the Plan.
The draft recommendations were reviewed and vetted by the City of Greenfield staff, and then presented to community members for feedback and input.
Greenfield Participatory Budgeting Process:
1. Creating the Ballot - the Greenfield Safe Routes to School Steering Committee, made up of residents, students and community advocates worked with safe Routes to School program partners and the City of Greenfield to develop a list of projects for the community to vote on.
2. Town Hall Meeting - the Election kicked-off with a Town Hall meeting at City Hall on December 1 where the public had an opportunity to learn about the projects, ask questions, and cast their vote.
3. Voting - The public was able to vote for their favorite projects for a 2-week period (December 1 – December 15) at ballot drop-off sites or online.
4. Election Results - the winning projects will be announced at the March 14 Greenfield City Council meeting.
Election Results:
The ballot included 21 street safety projects, 3 projects for each public school in the city. During the 2-week voting period, a total of 244 community members voted for their favorite projects. Of those 244 ballots, 132 ballots were in Spanish, 156 were paper and 88 were submitted online.
After the ballots were collected and counted, the Steering Committee reviewed the election results and recommend to City Council that the following projects be funded to make the most of the $250,000 grant from the Transportation Agency:
(a full ranked list of the projects is attached)
Rank Project
Title
Description Estimated
Cost
School
1 12th Street
Sidewalk
Between
Oak and
Elm
Detail: Install 0.24 miles of
sidewalk on the south side of 12th
Street between Oak Avenue and
Elm Avenue. Install high visibility
crosswalk, curb ramp, and flashing
stop signs on 12th Street and Elm
Avenue when sidewalk is installed.
Benefits: Improve safety for
students walking along 12th Street
to Vista Verde Middle or Oak
$132,000 Vista Verde Middle
School
286
Avenue Elementary Schools.
3 Upgrade
Signs
around All
School
Campuses
Details: Upgrade 12 signs around
all school campuses.
Benefits: Better signage can
increase driver awareness and
pedestrian visibility.
$10,200 Citywide
7 12th Street
Sidewalk
Between
Cherry and
Harvest
Detail: Install a 0.12-mile sidewalk
on 12th Street between Cherry
Avenue and Harvest Way.
Benefit: Improve pedestrian safety
by providing dedicated space for
people to walk.
$60,000 Arroyo Seco
Academy
9 Heidi Drive
Crosswalk
and
Signage
Detail: Install high visibility
crosswalk across Heidi Drive on
Elm Avenue and install school
crossing signage.
Benefits: Improve safety and
visibility of pedestrians crossing
Heidi Drive.
$7,400 Vista Verde Middle
School
TOTAL $209,600
Projects funded through the participatory budgeting process will begin implementation as soon as the Salinas Valley Safe Routes to School Plan is adopted in Spring 2024, and the City will have 3 years to spend the funds.
BUDGET AND FINANCIAL IMPACT:
The Transportation Agency for Monterey County will grant the City of Greenfield up to $250,000 to implement projects that come out of the participatory budgeting process.
POTENTIAL MOTION:
APPROVE RESOLUTION NO. 2023-24 PRIORITIZING THE PROJECTS BY THE
GREENFIELD STEERING COMMITTEE AND DIRECTING STAFF TO SCHEDULE
IMPLEMENTATION OF THESE PROJECTS
287
CITY OF GREENFIELD CITY COUNCIL
RESOLUTION NO. 2023-24
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
GREENFIELD APPROVING A RESOLUTION PRIORITIZING THE
PROJECTS BY THE GREENFIELD STEERING COMMITTEE AND
DIRECTING STAFF TO SCHEDULE IMPLEMENTATION OF THESE
PROJECTS
WHEREAS, the planning effort for the participatory budgeting process kicked-off in February 2022 between Transportation Agency for Monterey County (TAMC) and City staff as a part of the Salinas Valley Safe Routes to School Plan ; and WHEREAS, In December 2022, Greenfield community members voted on a list of street projects that would make it safer and more comfortable for children to get to and from schools in the City; and
WHEREAS, the participatory budgeting process consisted of four elements:
creating the ballot, a town hall meeting, voting, and election results; and WHEREAS, the ballot included 21 street projects, 3 projects for each public school in the City, and a total of 244 community members voted for heir favorite projects; and WHEREAS, TAMC will provide a grant up to $250,000 to implement projects that come out of the participatory budgeting process, and have 3 years to spend the funds once the Salinas Valley Safe Routes to School Plan is adopted in Spring 2024; and NOW, THEREFORE, BE IT HEREBY RESOLVED by the City Council of the City of Greenfield does hereby authorizes the approval of the prioritized projects by the Greenfield Steering Committee and directs staff to schedule the implementation of these projects.
PASSED AND ADOPTED by the City Council of the City of Greenfield at a public meeting of the City Council held on the 14th day of March 2023 by the following vote:
AYES, and all in favor, therefore, Councilmembers:
NOES, Councilmembers:
ABSENT, Councilmembers:
Robert White, Mayor
Attest:
Ann F. Rathbun, City Clerk
288
Rank
Project
Number Title Description
Estimated
Cost Category
Total
Votes
1 4 12th Street Sidewalk Between Oak and Elm
Detail: Install 0.24 miles of sidewalk on the south side of 12th Street between Oak Avenue and Elm Avenue. Install high visibility crosswalk, curb ramp, and flashing stop signs on 12th Street and Elm Avenue when sidewalk is installed.
Benefits: Improve safety for students walking along 12th Street to Vista Verde Middle or Oak Avenue Elementary Schools. 132,000$ Vista Verde Middle School 107 2 1 Pedestrian Scramble at Elm Avenue and El Camino Real Detail: Install a pedestrian scramble signal head with striping across the intersection.
Benefits: Increases pedestrian safety by prohibiting any vehicle turning movements while people are crossing the street. 200,000$ Greenfield High School 84 3 19 Upgrade Signs around All School Campuses
Details: Upgrade 12 signs around all school campuses.
Benefits: Better signage can increase driver awareness and pedestrian visibility. 10,200$ City-wide 75 4 2 Conduct Roundabout Study at School Driveway Exit
Detail: Conduct Intersection Control Evaluation analysis to evaluate a roundabout at the school driveway exit. If roundabout is warranted, reduce El Camino Real to one lane between Tyler Avenue and US-101 entrance.
Benefits: Roundabouts can improve pedestrian and bicyclist safety and vehicle traffic flow. 30,000$ Greenfield High School 52
5 7 Oak Avenue Signage and Crosswalk
Detail: Install school crossing signage at Tom Rogers Circle, San Antonio Drive, Renfro Place, at the school driveways, and at 13th Street. Update the existing red paint in drop-off loop to be yellow for loading and move crosswalk and curb extension to be in line with the intersection at Tom Rogers Circle.
Benefits: Improve visibility of pedestrians walking along and across Oak Avenue. 112,700$ Oak Avenue Elementary School 51 6 18 Walnut Avenue and El Camino Real Pedestrian Improvements Detail: Install leading pedestrian intervals on all corners of the Walnut Avenue and El Camino Real intersection. Install or update school ahead of school crossing signage. Conduct an intersection sight distance analysis and consider a red curb to improve visibility at the school driveway exit Benefits: Increase pedestrian visibility and reduce conflicts with turning vehicles by permitting pedestrians to cross before vehicles can turn. 200,850$ Mary Chapa Academy 50 7 13 12th Street Sidewalk Between Cherry and Harvest
Detail: Install a 0.12-mile sidewalk on 12th Street between Cherry Avenue and Harvest Way.
Benefit: Improve pedestrian safety by providing dedicated space for people to walk. 60,000$ Arroyo Seco Academy 46
8 5 Bike Lane Feasibility Study
Detail: Study the feasibility of installing a 0.75-mile Class II bike lane on 12th Street between Elm Avenue and Walnut Avenue.
Benefits: Improve safety for bicyclists traveling on 12th Street by providing dedicated space to bicycle. 12,000$ Vista Verde Middle School 40 9 6 Heidi Drive Crosswalk and Signage
Detail: Install high visibility crosswalk across Heidi Drive on Elm Avenue and install school crossing signage.
Benefits: Improve safety and visibility of pedestrians crossing Heidi Drive. 7,400$ Vista Verde Middle School 38 10 8 11th Street Crosswalks and Curb Extensions
Detail: Install high visibility crosswalks and curb extensions on all corners of the Oak Avenue and 11th Street intersection.
Benefits: Improve visibility and safety for people crossing 11th Street. 216,000$ Oak Avenue Elementary School 38 11 16 Apple Avenue Crosswalk
Detail: Install a high visibility crosswalk on Apple Avenue at 8th Street and curb extensions on the northeast and northwest corners of the Apple Avenue and El Camino Real intersection.
Benefit: Improve pedestrian safety by increasing visibility of people crossing the street. 104,000$ Mary Chapa Academy 37
12 14 Apple Avenue and 12th Street Pedestrian Improvements Detail: Install high visibility crosswalks and curb extensions on all four legs of the Apple Avenue and 12th Street intersection. Install School Ahead or School Crossing signage.
Benefit: Improve safety for people crossing the Apple Avenue and 12th Street intersection. 216,850$ Arroyo Seco Academy 36
13 3 9th Street Pedestrian Improvements
Detail: Install high visibility crosswalks at 9th Street and Apple Avenue, Palm Avenue, Elm Avenue, and Maple Avenue. Install high visibility crosswalks at Elm Avenue and 8th Street. Install Americans with Disabilities Act compliant curb ramps at 9th Street. and Maple Avenue, 9th Street and Oak Avenue, and 9th Street and Palm Avenue.
Benefits: Improved safety and accessibility for pedestrians along 9th Street. 94,000$ Greenfield High School 34 14 20 Ciclovía Greenfield
Details: Ciclovías are free resident-led community events where streets are closed for a specific timeframe to traffic to allow the community a space to enjoy biking, walking, and free activities in a safe environment.
Benefit: Promote physical activity and healthy lifestyles and increase the safety and mobility of non-motorized users to encourage active transportation such as walking and biking. 35,000$ City-wide 34
15 10 3rd Street Pedestrian Improvements
Detail: Install 0.07 miles of sidewalk on the northwest and southeast corners of 3rd Street at Oak Avenue, install ADA compliant curb ramps, and install crosswalks on all four legs. Remove the crosswalk at 3rd Street and Palm Avenue when new crosswalk is installed.
Benefits: Improve safety for people walking along 3rd Street and improve accessibility for people with disabilities. 73,000$ Cesar Chavez Elementary School 26 16 15 Hicks Drive and 12th Street Crosswalks
Detail: Install high visibility crosswalks and Americans with Disabilities Act compliant curb ramps on all corners of the Hicks Drive and 12th Street intersection.
Benefit: Improve pedestrian safety by increasing visibility of people crossing at the intersection. 32,000$ Arroyo Seco Academy 26
17 17 Walnut Avenue Buffered Bike Lanes
Detail: In conjunction with the Walnut Avenue street widening project, add 0.57 miles of buffered bike lanes to both sides of the street between El Camino Real and the US-101 Entrance.
Benefit: A buffered bike lane can increase safety and comfort for people biking and walking along Walnut Avenue. ` 220,590$ Mary Chapa Academy 25 18 11 Apple Avenue School Signage
Detail: Install or update school ahead or school crossing signage on Apple Avenue at Thorp Avenue, Chardonnay Drive/Cordona Circle, and Burgundy Drive.
Paint arrows at the school driveway to reflect no left turn.
Benefits: Improve visibility of pedestrians walking along and across Apple Avenue. 12,650$ Cesar Chavez Elementary School 23
GREENFIELD PARTICIPATORY BUDGETING ELECTION RESULTS (DECEMBER 2022) 289
Rank
Project
Number Title Description
Estimated
Cost Category
Total
Votes
GREENFIELD PARTICIPATORY BUDGETING ELECTION RESULTS (DECEMBER 2022) 19 21 Walking School Bus
Details: Develop and Implement Elementary School Walking School Bus for 1 year. Coordinate and plan with school community, draft route maps, create program structure, implement program, recruit volunteers, promote participation, analyze results, and improve program. School to be determined.
Benefit: Encourages walking to school and improves safety by providing adultsupervision and increasing visibility of walkers. 50,000$ City-wide 19 20 9 9th Street Curb Ramps and Curb Extensions
Detail: Consider curb extensions at existing crosswalk at Oak Avenue and 9th Street and install curb ramps on either end of the midblock crosswalk.
Benefits: Improve visibility and safety for people crossing 9th Street. Benefits students at Oak Avenue Elementary and Greenfield High School. 60,000$ Oak Avenue Elementary School 15 21 12 Thorp Avenue Pedestrian Improvements
Detail: Install high visibility crosswalks across the north and east leg of the Thorp Avenue and Bianco Way intersection. Install curb extensions at Thorp Avenue and Bianco Way and curb ramps at the school driveway entrance and exit on Thorp Avenue. Install school crossing and school ahead signage.
Benefits: Improve safety by increasing visibility of pedestrians walk along and across Thorp Avenue. 78,100$ Cesar Chavez Elementary School 15 Steering Committee Recommendations
Greenfield Participatory Budgeting Voter Guide
https://tamcmonterey.sharepoint.com/:b:/g/EbMWK7-M-VRGldkAEABZVhkBgumVK1wprbZFAaG3YH7slA?e=T70F1s 290
MEMORANDUM: March 10, 2023
AGENDA DATE: March 14, 2023
TO: Mayor and City Council
FROM: Jamie Tugel, Public Works Director
TITLE: A RESOLUTION TO APPROVE AND APPROPRIATE $10,485 IN
CONTINGENCY FOR AN EXISTING CONTRACT WITH GRADE
BREAK ENGINEERING FOR WATER SERVICE REPAIRS,
PREVIOUSLY APPROVED BY RESOLUTION NO. 2022-97 IN
OCTOBER 2022
BACKGROUND:
On September 2, 2022, the City of Greenfield entered into a contract with Grade Break Engineering (GBE) for water system service repairs. This contract was entered into so the City could get caught up on water service repairs, with the intent the City staff would go back to conducting the repairs inhouse once GBE was complete. During the course of the work, more water service leaks were reported and some repairs were more extensive than originally planned for. GBE completed the water service repairs, and additional leaks were being reported daily. The number of leaks was more than staff could repair in house at the time.
Public Works has faced many challenges, including the lack of full time staff and lack of proper training.
DISCUSSION:
The original contract approved by City Council did not include to approve and appropriate a 15% contingency to set aside to cover any unexpected costs that can arise throughout a construction project. At the time of the original contract, the contingency would have been $14,250. This was an oversight, and staff is asking Council to approve and appropriate an 11%, or $10,485 contingency for the unexpected costs that arose during the course of the contract.
City Council Memorandum
599 El Camino Real Greenfield CA 93927 (831) 674-5591
www.ci.greenfield.ca.us
291
BUDGET:
The original contract approved and appropriated $95,000 to the contractor, with the City Manager approving additional work not to exceed $25,000, for a total contract of $120,000.
The funding for the contingency of $10,485 will be appropriated from the Water Enterprise Fund.
Amount Transfer From Transfer To
$10,485 504-44540.000 504-345-63700
PROPOSED MOTION:
I MOVE TO ADOPT RESOLUTION #2023-25, A RESOLUTION TO APPROVE AND APPROPRIATE $10,485 IN CONTINGENCY FOR AN EXISTING CONTRACT WITH
GRADE BREAK ENGINEERING FOR WATER SERVICE REPAIRS, PREVIOUSLY APPROVED BY RESOLUTION NO. 2022-97 IN OCTOBER 2022
292
RESOLUTION NO. 2023-25
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF GREENFIELD TO APPROVE AND APPROPRIATE $10,485 IN CONTINGENCY FOR AN
EXISTING CONTRACT WITH GRADE BREAK ENGINEERING FOR WATER SERVICE REPAIRS, PREVIOUSLY APPROVED BY RESOLUTION NO. 2022- 97 IN OCTOBER 2022
WHEREAS, on September 2, 2022, the City of Greenfield entered into a contract with Grade Break Engineering for water system service repairs; and WHEREAS, during the course of the work, more water service leaks were reported and some repairs were more extensive than originally planned for; and WHEREAS, the City Council of the City of Greenfield approved a contract with Grade Break Engineering in October 2022 in the amount of $95,000; and WHEREAS, the City Manager further approved additional work not to exceed $25,000, for a total contract of $120,000; and
WHEREAS, the department did not include to approve and appropriate a contingency of 15%, or $14,250; and
WHEREAS, to correct the oversight of not including contingency in the contract, staff is requesting approval and appropriation of 11%, or $10,485, in contingency be added to the contract.
NOW, THEREFORE, BE IT HEREBY RESOLVED by the City Council of the City of Greenfield approves the appropriation of 11%, or $10,485, in contingency for an existing contract with Grade Break Engineering for water service repairs, previously approved by Resolution No. 2022-97 in October 2022.
PASSED AND ADOPTED by the City Council of the City of Greenfield at a public meeting of the City Council held on the 14th day of March 2023 by the following vote:
AYES, and all in favor, therefore, Councilmembers:
NOES, Councilmembers:
ABSENT, Councilmembers:
Robert White, Mayor
Attest:
Ann F. Rathbun, City Clerk
293
1 City Council Memorandum 599 El Camino Real Greenfield CA 93937 831-674-5591 www.ci.greenfield.ca.us
MEMORANDUM: 03/04/2023
AGENDA DATE: 03/14/2023
TO: Mayor and City Council
FROM: Guillermo Mixer, Acting Chief of Police
TITLE: A RESOLUTION TO SUPPLEMENTALLY
APPROPRIATE FUNDS IN FISCAL YEAR 2022-
2023 OPERATING BUDGET IN THE AMOUNT OF
$225,000 FOR THE PURCHASE OF 3 POLICE
VEHICLES AND EMERGENCY EQUIPMENT TO
BE PAID FOR WITH THE SUPPLEMENTAL LAW
ENFORCEMENT SERVICES FUND
BACKGROUND
The Greenfield Police Department must replace 3 aged police vehicles. The vehicles have reached the end of their safe life, as they have over 130,000 miles and thorough inspections by Greenfield mechanics showed the urgent need to replace the 3 vehicles. The cost to repair and maintain these aged vehicles is counterproductive, as it would only be a temporary fix and a potential waste of funds.
In March 2022, the PD ordered 2 Ford Police Interceptors through Enterprise Fleet. However, 9 months after the order, Enterprise Fleet canceled the order, and sent a new more expensive proposal. The new proposal raised the price of each vehicle to over $57,000. Worse yet, Enterprise Fleet did not have a delivery time for the vehicles, and they projected a delivery for the end of 2023 or even early 2024. This is due to a nationwide shortage of police vehicles.
Public Works Superintendent Manuel Ayala located 3 Ford Police Interceptors at a dealership in Michigan at a competitive price of $52,068.64 per vehicle including delivery.
This staff proposal consists of 2 adjustments, to be deposited in account 200-205-81500:
1. Supplemental appropriation in the amount of $156,205.92 to purchase 3 Ford Police Interceptors.
294
2 2. Supplemental appropriation in the amount of $68,794.08 to outfit the 3 vehicles with emergency equipment, partitions, lighting, and safety equipment.
FINANCIAL IMPACT:
None, as the funds to buy the vehicles and equipment will come from the Supplemental Law Enforcement Services Fund (SLESF) balance, which is in excess of $270,000. These are grant funds from the Citizens Options for Public Safety (COPS) program from the state of California.
PROPOSED MOTION
I MOVE TO APPROVE RESOLUTION #2023-26, A RESOLUTION TO
SUPPLEMENTALLY APPROPRIATE FUNDS IN FISCAL YEAR 2022-2023 OPERATING BUDGET IN THE AMOUNT OF $225,000 FOR THE PURCHASE OF 3 POLICE VEHICLES AND EMERGENCY EQUIPMENT TO BE PAID FOR
WITH THE SUPPLEMENTAL LAW ENFORCEMENT SERVICES FUND
295
RESOLUTION NO. 2023-26
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
GREENFIELD TO APPROVE SUPPLEMENTALLY APPROPRIATE
FUNDS IN FISCAL YEAR 2022-2023 IN THE AMOUNT OF $225,000 TO
FUND EXPENDITURES TO BE PAID WITH SUPPLEMENTAL LAW
ENFORCEMENT SERVICES FUND (SLESF)
WHEREAS, the California state legislature created the Citizens Option for Public Safety/Supplemental Law Enforcement Services Account (COPS/SLESA) program; and WHEREAS, estimated funds available under the program total $225,000 and are required to be placed in a special revenue fund (SLESF); and shall be allocated for expenditures listed in the City’s 2022/2023 budget; and
WHEREAS, the Legislature mandated this money be spent for front line law enforcement purposes and may not be used to supplant any existing law enforcement services provided by the City.
NOW, THEREFORE, BE IT RESOLVED, by the City Council of the City of Greenfield approves the following supplemental appropriations:
1. Supplemental appropriation in the amount of $225,000 – Police Expenses PASSED AND ADOPTED by the City Council of the City of Greenfield, at a regular meeting of the City Council held on the 14th day of March 2023, by the following vote:
AYES, and all in favor, therefore, Councilmembers:
NOES, Councilmembers:
ABSENT, Councilmembers:
_______________________________
Robert White, Mayor
Attest:
___________________________
Ann F. Rathbun, City Clerk
296
f
MEMORANDUM: March 10, 2023
AGENDA DATE: March 14, 2023
TO: Mayor and City Council
FROM: Paul Wood, City Manager
TITLE: A RESOLUTION OF THE CITY COUNCIL OF THE CITY
OF GREENFIELD TO ADJUST CITYWIDE REVENUES
AND REALLOCATE EXPENDITURES FOR FY 2022-2023
THAT WILL RESULT IN A NET REVENUE TO THE
GENERAL FUND OF $284,757, A NET ADDITIONAL
REVENUE OF $63,040 TO OTHER FUNDS AND A NET
ADDITIONAL EXPENDITURE OF $26,000 TO THE
WATER FUND
PURPOSE:
The purpose of this item is to make budget adjustments that better reflect where the City is actually spending its revenues versus originally budgeted before the beginning of the fiscal year.
In most cities, at the midpoint of the fiscal year, the Finance Department reviews current spending to best forecast how the remainder of the fiscal year will look. Many times, this will include supplemental appropriations and revenue forecast adjustments. For us, this year is no exception.
BACKGROUND:
City staff has reviewed all funds and accounts and have determined that no NET supplemental expenditures are required. We are proposing adjustments (mostly upward) to certain revenues and movements between departmental expenditures in accordance with general guidelines that most cities follow.
These guidelines are usually set forth in a number of policies that the City Council approves that will ensure that there is appropriate oversight of staff by the City Council. The City of Greenfield City Council Memorandum 599 El Camino Real Greenfield CA 93937 831-674-5591 www.ci.greenfield.ca.us
297
has not adopted policies related to the movement of budgeted expenditures. City staff will address this in a future agenda item.
The specific ways that City staff will address the budget adjustments are two-fold:
• By increasing individual revenue items to better reflect what we expect to receive before the end of the fiscal year, and
• By utilizing unused personnel budget to supplementally appropriate (fund) other operational line items
It is this second point that is the subject of the budget policies mentioned previously. When in place, the appropriate budget policy will be that the Finance Director will not utilize excess budget from any personnel line items without getting the approval of City Council.
As mentioned previously, this policy is not currently a policy of the City, but I would like to present it to Council at an upcoming meeting.
As you will see on the attached spreadsheets, the revenue adjustments provide an additional $491,066 of budgeted revenues, added to expenditure savings of $234,348, yielding Fund 100 savings of $725,414. Fund 102, the Fire Fund, we request be supplementally appropriated to the tune of $409,100, and Fund 220, the Measures V & W Fund, supplementally appropriated $31, 557. These budget adjustments will result in an additional $284,757 in budgeted revenues.
Adjustments to the other funds will result in an additional $63,040 in budgeted revenues, and adjustments to the Water Fund will result in an additional expenditure of $26,000.
COUNCIL ACTION
I MOVE TO APPROVE/DENY A RESOLUTION OF THE CITY COUNCIL OF THE
CITY OF GREENFIELD APPROVING THE MID-YEAR OPERATING BUDGET ADJUSTMENTS FOR FY 2022-2023
298
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
Fund: 100 - GENERAL FUND
100-41110.000 Current Secured 407,178.00 437,790.23 433,778.00 447,791.24 442,454.00 271,341.65 61.3% 40,000 100-41120.000 Current Unsecured 14,676.00 16,703.37 14,662.00 21,051.76 14,956.00 20,699.94 138.4% 5,000 100-41130.000 Current Supplemental 22,865.00 21,592.95 18,851.00 26,516.79 19,228.00 12,745.64 66.3% 4,000 100-41140.000 Prior Year Secured and Unsecured 4,000.00 5,470.56 4,633.00 5,380.74 4,726.00 2,411.07 51.0% 100-41160.000 VLF In-Lieu 1,840,170.00 1,895,444.03 1,919,675.00 2,008,543.00 1,958,068.00 1,090,652.00 55.7% 40,000 100-41180.000 City Increment Pass-Through 250,000.00 - 130,229.00 - 132,834.00 - 0.0% (132,834) 100-41185.000 Property Transfer Tax 20,043.00 31,989.77 25,500.00 41,336.51 26,010.00 15,934.91 61.3% 100-41190.000 Homeowners Property Tax Relief 1,550.00 1,181.83 1,700.00 - 1,700.00 - 0.0% (1,700) 100-41200.000 Sales Tax - Prop 172 25,500.00 18,360.69 25,500.00 13,788.96 26,000.00 8,586.46 33.0% (13,000) 100-41210.000 Sales Tax 1,103,618.00 1,502,711.06 1,493,500.00 1,866,335.55 1,538,305.00 937,521.65 60.9% 100-41240.000 Cannabis Business Tax 3,100,000.00 1,297,822.77 2,060,000.00 2,027,259.15 2,358,382.00 74,596.10 3.2% 100-41250.000 Transient Occupancy Tax 22,000.00 13,445.77 10,200.00 170,913.25 10,404.00 58,807.86 565.2% 70,000 100-41260.000 Business License Tax 34,072.00 27,544.00 31,620.00 36,250.00 32,252.00 29,152.00 90.4% 100-41270.000 Utility User Tax 307,542.00 332,967.96 331,500.00 429,257.44 338,130.00 247,056.09 73.1% 100-41410.000 Cable Television Franchise Fee 14,800.00 34,704.18 16,830.00 32,986.67 17,167.00 16,177.55 94.2% 100-41420.000 Electricity Franchise Fee 72,000.00 88,960.57 66,300.00 99,937.35 67,626.00 - 0.0% 100-41425.000 Gas Franchise Fee 22,000.00 - 20,400.00 - 20,808.00 - 0.0% 100-41433.000 Recycling Franchise Fee 29,000.00 40,600.94 33,660.00 57,906.57 34,333.00 37,398.30 108.9% 100-41521.000 SB1186 ADA Fee 1,700.00 - - - - -
100-42105.000 Construction Permits 256,600.00 469,041.19 403,308.00 969,289.39 400,000.00 221,221.45 55.3% 100-42130.000 Encroachment Permits 7,200.00 17,569.75 13,056.00 16,819.85 13,000.00 8,182.00 62.9% 100-42131.000 Grading Permits - - - 7,329.10 - 1,494.00 2,000 100-42140.000 Medical Marijuana Permit Fee 234,923.00 161,733.00 132,600.00 49,647.00 130,000.00 - 0.0% 100-42160.000 Other Permits 6,000.00 581.00 408.00 200.00 500.00 - 0.0% 100-42170.000 Garbage Fee Revenue 1,431,712.00 1,462,551.38 1,468,800.00 1,521,514.66 1,498,176.00 1,081,494.15 72.2% 100,000 100-42174.000 Commercial Organic Solid Waste - - - - - 13,630.22 14,000 100-42180.000 Solid Waste Surcharge Revenue 1,176,585.00 1,222,515.20 1,234,200.00 1,316,056.45 1,258,884.00 885,306.77 70.3% 40,000 100-43101.000 Motor Vehicle License Fees 9,736.00 - - 21,258.99 - - 100-43310.000 State Mandated Costs 8,000.00 14.00 - 12,601.00 - - 100-43314.000 State Police Revenues- P.O.S.T 13,000.00 25,081.54 6,000.00 45,661.51 6,000.00 2,164.15 36.1% 100-43330.000 School Resource Officer 48,000.00 - - - - 102,429.54 150,000 100-43401.000 Rent/Utility Assistance Grant 399,762.50 199,426.18 - 806,327.87 900,000.00 294,003.40 32.7% 100-43420.000 Fines Received by County 11,330.00 40,935.52 36,516.00 46,447.08 37,246.00 8,905.24 23.9% 100-43440.000 Other City Fines 12,360.00 4,277.00 3,162.00 9,449.48 3,225.00 5,930.00 183.9% 100-43620.000 LEO Wellness and Mental Health Grant - - - - - 20,000.00 20,000 100-43687.000 CAL - OES Grants - - - - 1,225,744.00 - 0.0% 100-44120.000 Animal Impound Fee 38,760.00 760.00 612.00 1,440.00 624.00 360.00 57.7% 100-44121.000 Police Report Sales 74,460.00 66,190.29 46,002.00 76,572.70 46,922.00 47,990.41 102.3% 20,000 100-44122.000 Weed Abatement - - - 27,403.72 - 740.00 1,000 100-44129.000 Other Police Services 1,530.00 2,307.28 510.00 4,162.78 520.00 1,075.00 206.7% 1,000 100-44130.000 Animal License Fees 13,260.00 4,915.00 - 10,810.00 4,162.00 4,565.00 109.7% 100-44131.000 Animal Surrender Fees 2,040.00 - 4,080.00 1,600.00 - 1,000.00 1,000 100-44132.000 Animal Citation Fees 1,020.00 - - - - -
100-44210.000 Zoning Fees 30,600.00 17,968.18 32,640.00 205,905.28 33,293.00 94,443.09 283.7% 60,000 100-44235.000 CEQA / EIR / Specific Plans / Annexations - 7.84 - - - - 100-44260.000 Plan Check Fees- Planning 91,800.00 224,841.94 194,820.00 595,500.46 198,716.00 890,004.61 447.9% 100-44267.000 Plan Check Fees- Fire 27,650.00 136,529.22 121,655.00 336,018.22 124,089.00 56,733.09 45.7% 100-44275.000 Residential Registration 306.00 - - - - - 100-44280.000 Vehicle Abatement 7,140.00 16,500.49 9,180.00 12,345.37 9,364.00 6,420.44 68.6% 100-44285.000 AB717 Education Fee 4,590.00 9,257.59 7,803.00 14,696.40 7,959.00 3,927.92 49.4% 100-44287.000 Miscellaneous Building Fees - - 510.00 - 520.00 - 0.0% 100-44293.000 Business License Inspections 1,020.00 450.00 5,610.00 1,100.00 5,722.00 450.00 7.9% 100-44295.000 Business License Application Fees 10,200.00 7,100.00 - 8,600.00 - 8,514.00 8,500 299
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-44299.000 Admin Fees - 3,180.52 - 3,482.50 - 14,462.28 14,500 100-44308.000 Community Center Rental Fee 8,568.00 15,000.00 14,000.00 17,875.00 14,000.00 12,965.00 92.6% 100-44309.000 Field Rental Revenue 5,000.00 1,673.00 3,000.00 4,585.00 3,060.00 955.00 31.2% 100-44310.000 Vendor Fee Revenue - - - 40.00 - 20.00
100-44311.000 Zumba & Aerobics Revenue 5,000.00 3,525.00 5,000.00 6,763.00 5,100.00 4,499.00 88.2% 100-44312.000 Sports Program-Soccer 3,500.00 515.00 1,500.00 1,030.00 1,530.00 - 0.0% 100-44313.000 Sports Program-Basketball 8,500.00 2,700.00 5,000.00 4,430.00 5,100.00 6,390.00 125.3% 100-44314.000 Youth Camp 8,000.00 12,100.00 6,000.00 3,193.00 6,120.00 1,990.00 32.5% 100-44315.000 Facilities Rental Revenue 4,000.00 - 300,000.00 - 3,060.00 - 0.0% 100-44316.000 Sports Program-Football 1,500.00 3,950.00 1,000.00 3,075.00 1,020.00 95.00 9.3% 100-44317.000 Sports Program-Ballet 3,500.00 1,490.00 1,500.00 5,145.00 1,530.00 1,110.00 72.5% 100-44318.000 THe Market @ the Gazebo - 80.00 3,000.00 20,960.00 3,060.00 12,650.00 413.4% 9,000 100-44319.000 Teen and Adult Fitness - 692.00 - 1,812.50 - 180.00 500 100-44905.000 Parking Lot Fees 31,500.00 - 30,000.00 64,500.00 30,000.00 - 0.0% 100-44910.000 Copies 100.00 2.25 - 68.25 - 65.50 100
100-44931.000 Civic Center Rental Income 4,000.00 5,700.00 4,200.00 19,500.00 4,200.00 11,375.00 270.8% 15,000 100-44954.000 AT&T Lease Income 34,000.00 36,896.22 36,000.00 38,003.10 36,500.00 - 0.0% 100-44961.000 McDonald's Sign Easement 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00 100.0% 100-44995.000 Over / Short - (6,488.75) - (12.15) - 166.63 100-45241.000 Parking Citation Revenue 2,754.00 100.00 1,000.00 2,519.76 1,100.00 3,273.69 297.6% 3,000 100-45310.000 Asset Forfeiture Revenue 15,500.00 1,381.84 - - - - 100-45910.000 NSF Penalties 510.00 275.00 500.00 200.00 500.00 350.00 70.0% 100-45930.000 Business License Penalties 204.00 154.00 200.00 312.00 200.00 64.00 32.0% 100-45950.000 Miscellaneous Penalties 102.00 - - - - -
100-46110.000 Interest Income- Pooled Cash 11,220.00 11,042.16 11,000.00 15,497.10 12,000.00 567.88 4.7% 100-46115.000 Unrealized Gain/Loss - (2,656.09) 1,000.00 (40,932.63) 1,000.00 - 0.0% 100-47810.000 Insurance Reimbursements - 56,514.97 - - - - 100-47815.000 COVID Reimbursements - CARES Act - 225,755.00 - - - - 100-47816.000 2023 Storm FEMA Reimbursement - - - - 76,000.00 - 0.0% 100-47817.000 LEAP Grant Revenue - - - - 65,000.00 - 0.0% 100-47818.000 REAP Grant Revenue - - - - 65,000.00 - 0.0% 100-47894.000 Miscellaneous Revenue- Police 1,020.00 - - 14,243.85 - 8,157.90 100-47899.000 Miscellaneous Revenues- Other 10,000.00 89,832.25 20,000.00 62,427.31 25,000.00 49,880.15 199.5% 20,000 100-47900.000 Miscellaneous Donations 27,000.00 - - - - 500.00 100-49600.000 TRANSFER IN 541,200.00 - 500,000.00 - 500,000.00 - 0.0% 11,944,976.50 10,327,258.64 11,309,910.00 13,658,729.88 13,814,129.00 6,719,782.73 48.6% 491,066 100-101-51100.000 Salaries 23,100.00 23,100.48 23,100.00 23,100.48 23,100.00 14,437.68 62.5% 100-101-52110.000 Social Security 1,432.00 1,432.08 1,432.00 1,432.08 1,432.00 895.04 62.5% 100-101-52120.000 Medicare 335.00 335.40 335.00 335.40 335.00 209.62 62.6% 100-101-61200.000 Printing and Copying 75.00 - 75.00 - 75.00 - 0.0% 100-101-61400.000 Office Supplies 150.00 180.49 150.00 140.11 150.00 127.16 84.8% 100-101-63100.000 Administration Services 4,285.00 3,180.00 4,950.00 3,805.00 10,550.00 9,279.50 88.0% 100-101-64600.000 Cell Phone Charges 2,281.00 2,023.07 2,520.00 2,090.65 2,520.00 1,330.35 52.8% 100-101-65100.000 General Operating Supplies - - 860.00 945.65 360.00 - 0.0% 100-101-67100.000 Meetings & Conferences 13,760.00 2,000.00 12,770.00 5,628.65 3,470.00 2,780.89 80.1% 100-101-67300.000 Other Meals & Travel 650.00 20.00 600.00 31.73 600.00 - 0.0% 100-101-68200.000 Community Outreach 23,000.00 67,904.47 - 7,703.32 1,200.00 968.17 80.7% 100-101-68300.000 Memberships 32,950.00 32,841.16 23,100.00 33,403.74 27,350.00 26,771.17 97.9% 100-101-78100.000 General Community Funding 14,200.00 22,737.19 - 23,000.00 - 7,070.83 #DIV/0! 20,000 100-101-95620.000 IT Allocation 2,610.00 - 3,810.00 - 2,610.00 - 0.0% 118,828.00 155,754.34 73,702.00 101,616.81 73,752.00 63,870.41 86.6% 20,000 300
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-111-51100.000 Salaries 55,279.00 45,873.44 63,545.00 54,651.77 66,086.00 30,294.20 45.8% (9,000) 100-111-51105.000 Emergency Leave - 606.72 - - - - #DIV/0! 100-111-51300.000 Overtime - 799.14 - 2,072.44 - 769.44 #DIV/0! 2,000 100-111-51305.000 Emergency OT - 1,213.44 - - - - #DIV/0! 100-111-51410.000 Bilingual pay 624.00 - - 24.00 - 12.00 #DIV/0! 100-111-52110.000 Social Security 3,288.00 2,889.67 3,799.00 3,476.36 3,951.00 1,904.50 48.2% 100-111-52120.000 Medicare 769.00 675.80 889.00 813.08 924.00 445.39 48.2% 100-111-52300.000 Workers' Compensation 5,172.00 607.08 4,514.00 - 4,694.00 - 0.0% 100-111-52400.000 PERS 4,193.00 3,661.33 4,823.00 4,457.48 5,016.00 2,517.61 50.2% 100-111-52450.000 Unfunded Liability 49.00 - 162.00 - 168.00 - 0.0% 100-111-52510.000 Health Insurance 8,300.00 5,630.92 8,340.00 2,695.23 8,674.00 1,534.26 17.7% 100-111-52515.000 Dental/Vision Insurance 454.00 366.93 454.00 378.08 472.00 214.45 45.4% 100-111-52525.000 Self Insurance 5,600.00 - 5,600.00 - 5,824.00 65.00 1.1% 100-111-52530.000 Long-Term Disability Insurance 510.00 261.34 391.00 301.64 406.00 172.99 42.6% 100-111-52820.000 Deferred Comp Employer Match - - - - - 350.00 #DIV/0! 100-111-61100.000 Postage - 26,524.95 26,162.00 26,162.00 30,000.00 17,081.00 56.9% 5,000 100-111-61200.000 Printing and Copying 6,000.00 5,020.07 4,145.00 4,094.49 4,500.00 3,829.64 85.1% 100-111-63700.000 Public Works Services 18,000.00 6,935.10 3,400.00 3,368.92 19,247.00 15,274.90 79.4% 100-111-63900.000 General Services 2,000.00 1,020.00 8,000.00 5,097.00 1,000.00 951.31 95.1% 100-111-64100.000 Electricity 21,000.00 19,066.32 26,492.00 26,491.30 30,000.00 23,744.59 79.1% 4,000 100-111-64200.000 Gas Utility 5,000.00 7,064.36 7,000.00 5,883.10 8,000.00 5,276.78 66.0% 100-111-64300.000 Water Utility 5,500.00 4,732.26 5,000.00 4,020.39 6,000.00 2,611.98 43.5% 100-111-64400.000 Waste Disposal - - - - 2,300.00 148.64 6.5% 100-111-64500.000 Phone Charges 10,400.00 3,562.59 3,500.00 3,394.92 4,300.00 2,071.56 48.2% 100-111-64600.000 Cell Phone Charges - - 363.00 362.29 - - #DIV/0! 100-111-65000.000 Vehicle & Equip. Parts & Supplies 500.00 - 228.00 227.42 1,000.00 306.65 30.7% 100-111-65100.000 General Operating Supplies 3,000.00 724.36 1,500.00 1,493.50 1,800.00 971.00 53.9% 100-111-65200.000 Uniforms / Personnel Equipment 2,500.00 575.31 1,500.00 532.66 1,000.00 467.35 46.7% 100-111-65600.000 Janitorial Supplies 5,000.00 4,686.52 5,500.00 5,408.16 6,500.00 3,487.37 53.7% 100-111-65700.000 Public Works Supplies 1,000.00 83.09 500.00 90.24 1,500.00 204.53 13.6% 100-111-65800.000 Permits & Inspections 2,000.00 1,181.00 686.00 518.00 1,500.00 945.18 63.0% 100-111-65900.000 Building Maintenance Supplies 17,000.00 11,759.42 16,000.00 15,946.14 30,000.00 7,869.12 26.2% (2,000) 100-111-66100.000 Gasoline & Oil 1,000.00 427.67 1,586.00 1,585.32 2,000.00 957.43 47.9% 100-111-66200.000 Vehicle and Equipment Maintenance - - 238.00 - 500.00 34.17 6.8% 100-111-66300.000 General Operations Equipment 1,500.00 1,457.52 700.00 118.60 200.00 59.43 29.7% 100-111-68700.000 Property Taxes 100.00 244.37 100.00 71.54 120.00 75.14 62.6% 100-111-72200.000 Minor Building Projects 90,000.00 94,413.31 - 34,686.12 4,150.00 299.67 7.2% 100-111-95610.000 HR Allocation 2,269.00 - 2,030.00 - 2,269.00 - 0.0% 100-111-95620.000 IT Allocation 2,415.00 - 2,566.00 - 2,415.00 - 0.0% 100-111-95630.000 Fleet Allocation 4,371.00 - 2,940.00 - 4,371.00 - 0.0% 100-111-95680.000 Risk Management Allocation 5,603.00 - 4,745.00 - 5,603.00 - 0.0% 100-111-95690.000 Vehicle Replacement Allocation 110,000.00 - 6,000.00 - 12,000.00 - 0.0% 400,396.00 252,064.03 223,398.00 208,422.19 278,490.00 124,947.28 44.9% - 100-190-51100.000 Salaries 138,511.00 83,144.96 161,238.00 129,444.60 167,688.00 70,035.20 41.8% (12,000) 100-190-51105.000 Emergency Leave - 2,218.37 - 462.60 - - #DIV/0! 100-190-51300.000 Overtime 8,000.00 148.89 8,000.00 328.59 8,320.00 - 0.0% 100-190-51410.000 Bilingual Pay 1,560.00 1,560.00 1,560.00 1,560.00 1,622.00 210.00 12.9% 100-190-51415.000 Leave Payoff - - - 733.67 - - #DIV/0! 100-190-52110.000 Social Security 8,558.00 5,052.16 9,966.00 7,686.42 10,365.00 4,026.71 38.8% 100-190-52120.000 Medicare 2,002.00 1,181.51 2,331.00 1,797.59 2,424.00 941.73 38.9% 100-190-52300.000 Workers' Compensation 12,960.00 - 14,547.00 - 15,129.00 - 0.0% 301
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-190-52400.000 PERS 10,505.00 6,748.95 12,356.00 9,979.71 12,851.00 5,144.75 40.0% 100-190-52450.000 Unfunded Liability 122.00 - 411.00 - 427.00 - 0.0% 100-190-52510.000 Health Insurance 24,340.00 13,348.89 24,033.00 26,532.97 24,995.00 15,439.14 61.8% 100-190-52515.000 Dental/Vision Insurance 648.00 423.64 648.00 647.92 674.00 311.50 46.2% 100-190-52525.000 Self Insurance 8,000.00 - 8,000.00 - 8,320.00 522.41 6.3% 100-190-52530.000 Long-Term Disability Insurance 670.00 393.50 670.00 291.72 696.00 78.54 11.3% 100-190-52820.000 Deferred Comp Employer Match - - - - - 50.00 #DIV/0! 100-190-61100.000 Postage 500.00 234.26 500.00 270.54 500.00 - 0.0% 100-190-61200.000 Printing and Copying 650.00 986.77 650.00 257.68 650.00 309.94 47.7% 100-190-61400.000 Office Supplies 2,000.00 2,167.73 2,000.00 2,085.22 2,000.00 821.09 41.1% 100-190-63100.000 Administrative Services 3,000.00 - 1,000.00 - 2,000.00 - 0.0% 100-190-63300.000 Financial Services 72,550.00 62,339.55 73,000.00 69,360.89 69,535.00 49,892.26 71.8% 12,000 100-190-63900.000 General Services 2,100.00 - 2,100.00 297.87 2,100.00 - 0.0% 100-190-67100.000 Meetings & Conferences 4,850.00 - 4,850.00 - 5,000.00 - 0.0% 100-190-67200.000 Other Training 3,000.00 199.00 3,000.00 - 3,000.00 676.13 22.5% 100-190-67300.000 Other Meals & Travel 500.00 - 500.00 - 500.00 44.05 8.8% 100-190-67600.000 Publications 220.00 - 220.00 - 220.00 - 0.0% 100-190-68300.000 Memberships 400.00 - 400.00 190.00 400.00 340.00 85.0% 100-190-95610.000 HR Allocation 5,684.00 - 5,090.00 - 5,684.00 - 0.0% 100-190-95620.000 IT Allocation 9,128.00 - 13,909.00 - 9,128.00 - 0.0% 100-190-95680.000 Risk Management Allocation 14,040.00 - 11,895.00 - 14,040.00 - 0.0% 334,498.00 180,148.18 362,874.00 251,927.99 368,268.00 148,843.45 40.4% - 100-191-63300.000 Financial Services 3,275.00 - 3,180.00 - 3,307.00 - 0.0% 100-191-64400.000 Waste Disposal 1,903,440.00 2,045,652.05 2,050,000.00 2,132,622.12 2,132,000.00 1,224,554.17 57.4% 100-191-64401.000 SB 1383 Compliance - - - - 26,964.00 26,964.00 100.0% 1,906,715.00 2,045,652.05 2,053,180.00 2,132,622.12 2,162,271.00 1,251,518.17 57.9% - 100-201-51100.000 Salaries 718,061.00 612,483.20 627,868.00 553,561.55 652,982.00 375,005.78 57.4% 100-201-51105.000 Emergency Leave - 1,340.80 - - - - #DIV/0! 100-201-51200.000 Wages - 24,634.50 - 23,842.50 - 7,104.00 #DIV/0! 100-201-51300.000 Overtime 16,000.00 30.17 16,000.00 - 16,640.00 - 0.0% (15,000) 100-201-51305.000 Emergency OT - 804.48 - - - - #DIV/0! 100-201-51410.000 Bilingual Pay 8,267.00 5,900.14 6,240.00 9,545.72 6,490.00 7,030.86 108.3% 100-201-51415.000 Leave Payoff - 1,191.20 - 3,751.54 - 12,695.40 #DIV/0! 13,000 100-201-51457.000 Detective Pay 3,754.00 - 6,321.00 - 6,574.00 - 0.0% (6,574) 100-201-51467.000 Explorer Pay - - 6,321.00 - 6,574.00 - 0.0% (6,574) 100-201-51468.000 Education Pay - 4,018.72 14,529.00 2,426.40 15,110.00 6,225.04 41.2% 100-201-51470.000 Uniform Allowance 1,760.00 558.47 440.00 1,320.02 458.00 1,140.02 248.9% 100-201-51475.000 Holiday Payout 3,754.00 322.32 - - - 1,739.87 #DIV/0! 100-201-51480.000 Workers' Comp Pay - - - 115,107.48 - 83,227.58 #DIV/0! 100-201-52110.000 Social Security 41,848.00 36,552.72 37,225.00 31,026.36 38,714.00 21,592.57 55.8% 100-201-52120.000 Medicare 10,484.00 8,940.10 9,339.00 8,102.82 9,713.00 5,661.62 58.3% 100-201-52300.000 Workers' Compensation 67,187.00 - 56,646.00 - 58,912.00 - 0.0% 100-201-52400.000 PERS 77,863.00 57,344.61 62,834.00 104,430.78 65,348.00 46,555.42 71.2% 100-201-52450.000 Unfunded Liability 33,321.00 - 42,181.00 - 23,578.00 - 0.0% 100-201-52510.000 Health Insurance 92,724.00 93,222.06 91,118.00 104,679.52 94,763.00 59,275.20 62.6% 100-201-52515.000 Dental/Vision Insurance 2,268.00 1,857.40 1,944.00 1,943.54 2,022.00 1,270.92 62.9% 100-201-52525.000 Self Insurance 28,000.00 - 28,000.00 - 29,120.00 7,039.46 24.2% 100-201-52530.000 Long-Term Disability Insurance 2,745.00 2,169.21 2,220.00 1,964.57 2,309.00 1,211.76 52.5% 100-201-52820.000 Deferred Comp Employer Match 1,800.00 1,626.18 3,000.00 2,701.87 3,120.00 3,587.50 115.0% 100-201-61100.000 Postage 2,400.00 1,759.61 1,500.00 1,311.11 1,560.00 256.77 16.5% 302
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-201-61200.000 Printing and Copying 6,000.00 3,994.27 3,500.00 2,090.68 3,640.00 858.70 23.6% 100-201-61300.000 Advertising 3,000.00 - - - - - #DIV/0! 100-201-61400.000 Office Supplies 3,500.00 2,346.83 2,400.00 1,400.95 2,496.00 1,590.58 63.7% 100-201-63100.000 Administration Services 5,000.00 1,933.37 3,500.00 3,500.00 3,640.00 - 0.0% 100-201-63400.000 Police Services 2,500.00 1,302.28 1,300.00 1,197.17 1,352.00 517.46 38.3% 100-201-63900.000 General Services 13,000.00 12,491.56 5,000.00 4,999.18 5,200.00 817.16 15.7% (1,000) 100-201-64500.000 Phone Charges 1,300.00 588.85 900.00 652.36 936.00 418.11 44.7% 100-201-64600.000 Cell Phone Charges 3,700.00 3,277.41 2,500.00 2,474.38 2,600.00 796.21 30.6% 100-201-65000.000 Vehicle & Equip. Parts & Supplies - - - - - 130.84 #DIV/0! 500 100-201-65100.000 General Operating Supplies 12,450.00 10,010.61 4,000.00 3,993.24 4,160.00 1,244.65 29.9% 100-201-65200.000 Uniforms/Personnel Equipment 6,900.00 5,668.10 6,400.00 4,166.53 6,656.00 708.42 10.6% 100-201-65600.000 Janitorial Supplies 5,800.00 4,116.62 2,500.00 2,460.03 2,600.00 1,374.54 52.9% 100-201-65900.000 Building Maintenance Supplies 3,000.00 2,954.67 2,000.00 1,998.39 2,080.00 1,844.95 88.7% 500 100-201-66100.000 Gasoline & Oil 7,000.00 8,164.40 7,000.00 10,267.95 7,280.00 5,251.01 72.1% 100-201-66200.000 Vehicle and Equipment Maintenance 1,000.00 909.82 - 401.75 - - #DIV/0! 100-201-67100.000 Meetings & Conferences 6,000.00 8.85 - - 5,200.00 1,350.57 26.0% 100-201-67200.000 Other Training 10,000.00 8,483.35 12,000.00 11,769.54 7,280.00 566.25 7.8% 100-201-67600.000 Publications 150.00 24.82 150.00 49.70 156.00 - 0.0% 100-201-68100.000 Recruitment 6,000.00 32.00 - - - - #DIV/0! 100-201-68200.000 Community Outreach 10,000.00 2,752.63 2,200.00 2,025.27 2,288.00 2,287.85 100.0% 100-201-68300.000 Memberships 1,600.00 707.21 1,600.00 1,492.79 1,664.00 1,055.00 63.4% 100-201-95610.000 HR Allocation 29,468.00 - 26,756.00 - 29,468.00 - 0.0% 100-201-95620.000 IT Allocation 34,636.00 - 41,867.00 - 34,636.00 - 0.0% 100-201-95630.000 Fleet Allocation 7,887.00 - 7,979.00 - 7,887.00 813.24 10.3% 100-201-95680.000 Risk Management Allocation 72,786.00 - 62,530.00 - 72,786.00 - 0.0% 100-201-95690.000 Vehicle Replacement Allocation 77,000.00 8,539.56 8,000.00 6,949.07 17,889.43 11,820.34 66.1% 1,441,913.00 933,063.10 1,217,808.00 1,027,604.76 1,255,881.43 674,065.65 53.7% (15,148.00) 100-215-51100.000 Salaries 594,393.00 636,506.64 601,172.00 429,862.63 625,219.00 363,025.43 58.1% 100-215-51105.000 Emergency Leave - 4,901.80 - - - - #DIV/0! 100-215-51300.000 Overtime 58,000.00 125,042.02 58,000.00 91,809.89 60,320.00 100,304.72 166.3% 50,000 100-215-51305.000 Emergency OT 5,127.00 - - - - - #DIV/0! 100-215-51410.000 Bilingual Pay 6,182.00 11,457.70 8,135.00 9,571.06 8,460.00 5,852.36 69.2% 100-215-51415.000 Leave Payoff - 32,018.95 - 6,544.94 - 15,493.74 #DIV/0! 15,500 100-215-51425.000 POST Intermediate 7,858.00 666.54 3,455.00 211.96 3,593.00 1,929.86 53.7% 100-215-51430.000 POST Advanced 5,210.00 14,413.18 2,894.00 8,485.36 3,009.00 781.92 26.0% 100-215-51435.000 FTO Pay 10,421.00 9,538.16 17,504.00 4,228.76 18,204.00 514.32 2.8% (15,000) 100-215-51442.000 Traffic Officer Pay - - - 4,301.32 - 3,715.60 #DIV/0! 2,000 100-215-51457.000 Detective Pay - 2,845.92 - 1,642.56 - - #DIV/0! 100-215-51462.000 Gang Suppression Unit Pay 3,602.00 13,460.74 - 8,096.12 - 781.92 #DIV/0! 3,000 100-215-51467.000 Explorer Pay 7,649.00 7,006.56 6,910.00 6,964.52 7,187.00 781.92 10.9% 100-215-51468.000 Education Pay - 12,172.44 8,988.00 6,203.60 9,348.00 7,719.24 82.6% 3,000 100-215-51469.000 Armorer Pay - - - 1,123.08 - - #DIV/0! 100-215-51470.000 Uniform Allowance 8,360.00 8,674.73 2,200.00 3,833.18 2,288.00 1,947.79 85.1% 2,000 100-215-51475.000 Holiday Payout 22,645.00 24,079.44 6,910.00 23,112.88 7,187.00 19,727.44 274.5% 10,000 100-215-51480.000 Workers' Comp Pay - 270.69 - 112,575.58 - 49,236.82 #DIV/0! 100-215-52110.000 Social Security 44,090.00 53,503.40 41,627.00 33,963.74 43,292.00 31,636.44 73.1% 100-215-52120.000 Medicare 10,311.00 12,842.94 10,180.00 8,591.33 10,587.00 7,412.83 70.0% 100-215-52300.000 Workers' Compensation 55,616.00 - 54,238.00 - 56,407.00 - 0.0% 100-215-52400.000 PERS 103,114.00 115,061.92 90,229.00 95,026.67 93,839.00 57,444.17 61.2% 100-215-52450.000 Unfunded Liability 104,432.00 - 78,873.00 - 63,890.00 - 0.0% 100-215-52510.000 Health Insurance 49,574.00 54,638.68 43,061.00 45,805.63 44,784.00 25,584.57 57.1% 100-215-52515.000 Dental/Vision Insurance 2,268.00 2,009.76 1,944.00 1,574.10 2,022.00 1,305.82 64.6% 303
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-215-52525.000 Self Insurance 28,000.00 - 24,000.00 - 24,960.00 7,994.14 32.0% 100-215-52530.000 Long-Term Disability Insurance 2,733.00 2,075.94 2,241.00 1,303.48 2,331.00 419.72 18.0% 100-215-52820.000 Deferred Comp Employer Match 1,200.00 1,889.01 1,200.00 1,864.05 1,248.00 2,596.16 208.0% 2,000 100-215-61100.000 Postage 300.00 77.15 200.00 200.00 208.00 207.73 99.9% 100-215-61200.000 Printing and Copying 5,000.00 4,977.29 4,600.00 3,227.43 4,784.00 1,001.21 20.9% (1,000) 100-215-61300.000 Advertising 500.00 - - - - - #DIV/0!
100-215-61400.000 Office Supplies 6,000.00 4,308.81 3,000.00 2,867.70 3,120.00 1,329.15 42.6% 100-215-63400.000 Police Services 425,200.00 387,883.70 448,760.00 410,495.01 467,870.00 286,823.34 61.3% (32,000) 100-215-64500.000 Phone Charges 35,000.00 29,003.26 22,000.00 17,801.72 25,880.00 14,021.52 54.2% 100-215-64600.000 Cell Phone Charges 15,000.00 15,103.60 17,000.00 15,204.86 17,680.00 6,651.73 37.6% 100-215-64900.000 Other Utilities 4,800.00 3,792.56 4,800.00 3,385.50 4,992.00 1,511.77 30.3% 100-215-65000.000 Vehicle & Equip. Parts & Supplies 10,000.00 5,031.83 - 1,815.68 - 2,933.21 #DIV/0! 100-215-65100.000 General Operating Supplies 5,000.00 2,651.90 9,000.00 7,647.98 5,200.00 3,676.34 70.7% 100-215-65200.000 Uniforms/Personnel Equipment 20,200.00 9,595.82 10,000.00 9,741.31 10,400.00 9,779.13 94.0% 100-215-65400.000 Police Supplies 26,800.00 10,008.40 23,000.00 21,061.88 12,480.00 9,847.29 78.9% 100-215-66100.000 Gasoline & Oil 63,000.00 70,452.86 65,000.00 105,776.41 67,600.00 65,461.01 96.8% 100-215-66200.000 Vehicle and Equipment Maintenance 12,000.00 12,245.62 - 1,219.28 - 891.89 #DIV/0! 100-215-67200.000 Other Training 26,000.00 24,719.40 36,000.00 34,714.86 22,880.00 21,125.58 92.3% 100-215-67600.000 Publications 450.00 450.00 450.00 183.55 468.00 85.00 18.2% 100-215-71400.000 Police Equipment 21,950.00 20,659.80 15,000.00 18,704.03 119,690.53 117,703.04 98.3% 100-215-95610.000 HR Allocation 24,393.00 - 22,062.00 - 22,944.00 - 0.0% 100-215-95620.000 IT Allocation 31,054.00 - 56,060.00 - 58,303.00 - 0.0% 100-215-95630.000 Fleet Allocation 12,887.00 - 12,871.00 - 13,386.00 - 0.0% 100-215-95680.000 Risk Management Allocation 60,250.00 2.68 51,558.00 19,723.72 53,621.00 15,132.18 28.2% 100-215-95690.000 Vehicle Replacement Allocation 141,811.00 29,821.50 37,000.00 32,106.50 36,000.00 23,735.25 65.9% 2,078,380.00 1,775,863.34 1,902,122.00 1,612,573.86 2,035,681.53 1,288,123.30 63.3% 39,500.00 100-230-51100.000 Salaries 41,888.00 40,146.37 99,205.00 71,205.51 100,989.00 34,654.23 34.3% 100-230-51300.000 Overtime - - - 2,522.98 - 1,899.34 #DIV/0! 100-230-51410.000 Bilingual Pay - - - 600.00 - 1,200.00 #DIV/0! 100-230-51480.000 Worker's Comp Pay - 145.30 - - - - #DIV/0! 100-230-52110.000 Social Security 2,406.00 2,276.23 2,520.00 4,403.72 2,621.00 2,247.94 85.8% 100-230-52120.000 Medicare 563.00 532.33 589.00 1,029.95 613.00 525.75 85.8% 100-230-52300.000 Workers' Compensation 3,919.00 - 3,168.00 - 3,295.00 - 0.0% 100-230-52400.000 PERS 3,142.00 3,109.85 3,386.00 5,420.72 3,521.00 2,678.75 76.1% 100-230-52450.000 Unfunded Liability 36.00 - 113.00 - 118.00 - 0.0% 100-230-52510.000 Health Insurance 5,154.00 8,770.66 9,099.00 6,042.47 9,463.00 2,550.20 26.9% 100-230-52515.000 Dental/Vision Insurance 324.00 323.96 324.00 565.75 337.00 249.20 73.9% 100-230-52525.000 Self Insurance 4,000.00 - - - 4,160.00 383.00 9.2% 100-230-52530.000 Long-Term Disability Insurance 268.00 267.54 4,000.00 24.75 278.00 - 0.0% 100-230-61200.000 Printing and Copying 1,000.00 500.00 - - 520.00 354.78 68.2% 100-230-61300.000 Advertising 500.00 - - - - - #DIV/0!
100-230-61400.000 Office Supplies 600.00 - 1,100.00 663.68 - - #DIV/0! 100-230-63400.000 Animal Control Services 50,000.00 22,597.36 - - 41,600.00 22,337.74 53.7% (5,000) 100-230-63900.000 General Services - - 36,700.00 26,748.04 - - #DIV/0! 100-230-64600.000 Cell Phone Charges 1,000.00 487.40 1,300.00 1,297.81 2,134.00 715.57 33.5% 100-230-64700.000 Radios 800.00 - - - - - #DIV/0!
100-230-65000.000 Vehicle & Equip. Parts & Supplies - - - - 1,000.00 303.05 30.3% 100-230-65200.000 Uniforms / Personnel Equipment 1,000.00 666.56 400.00 385.81 416.00 416.00 100.0% 100-230-65400.000 Police Supplies 6,500.00 3,790.54 3,000.00 2,538.59 1,560.00 926.18 59.4% 100-230-65600.000 Janitorial Supplies 500.00 146.84 850.00 839.74 364.00 98.13 27.0% 100-230-65900.000 Building Maintenance Supplies 2,000.00 8.09 500.00 314.69 520.00 520.00 100.0% 100-230-66100.000 Gasoline & Oil 2,000.00 2,221.56 2,000.00 3,506.96 2,080.00 1,412.95 67.9% 304
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-230-66200.000 Vehicle and Equipment Maintenance - 32.00 - - 2,120.00 1,492.16 70.4% 100-230-66300.000 General Operations Equipment - - - 271.58 - - #DIV/0! 100-230-67200.000 Other Training 3,500.00 2,302.36 1,500.00 1,420.21 570.00 568.52 99.7% 100-230-68200.000 Community Outreach 200.00 - 200.00 200.00 208.00 208.00 100.0% 100-230-95610.000 HR Allocation 1,719.00 - 1,539.00 - 1,600.00 - 0.0% 100-230-95620.000 IT Allocation 2,184.00 - 2,298.00 - 2,390.00 - 0.0% 100-230-95630.000 Fleet Allocation 4,371.00 - 5,039.00 - 5,241.00 - 0.0% 100-230-95680.000 Risk Management Allocation 4,246.00 - 3,596.00 - 3,740.00 - 0.0% 100-230-95690.000 Vehicle Replacement Allocation 8,571.00 - 3,000.00 - - - #DIV/0! 152,391.00 88,324.95 185,426.00 130,002.96 191,458.00 75,741.49 39.6% (5,000.00) 100-310-51100.000 Salaries 36,657.00 37,717.66 126,091.00 43,059.33 125,624.00 65,507.93 52.1% 100-310-51300.000 Overtime - - - - - 2,457.60 #DIV/0! 3,000 100-310-51410.000 Bilingual Pay 780.00 780.00 - 780.00 - 336.00 #DIV/0! 800 100-310-51415.000 Leave Payoff - 1,389.52 - 756.32 - 11,965.26 #DIV/0! 12,000 100-310-51420.000 Certification Stipend 720.00 719.94 720.00 719.94 749.00 69.23 9.2% 100-310-52110.000 Social Security 2,255.00 2,353.06 2,277.00 2,611.26 2,368.00 4,771.62 201.5% 100-310-52120.000 Medicare 527.00 550.27 533.00 610.56 554.00 1,115.97 201.4% 100-310-52300.000 Workers' Compensation 3,430.00 - 2,723.00 - 2,832.00 - 0.0% 100-310-52400.000 PERS 3,392.00 3,598.72 3,500.00 4,069.49 3,640.00 5,192.78 142.7% 100-310-52450.000 Unfunded Liability 3,342.00 - 4,133.00 - 298.00 - 0.0% 100-310-52510.000 Health Insurance 7,445.00 8,523.66 8,863.00 9,958.46 9,217.00 9,088.28 98.6% 100-310-52515.000 Dental/Vision Insurance 162.00 162.14 162.00 173.70 168.00 221.84 132.0% 100-310-52525.000 Self Insurance 2,000.00 - 2,000.00 - 8,080.00 7,656.79 94.8% 100-310-52530.000 Long-Term Disability Insurance 175.00 175.01 175.00 175.39 182.00 66.88 36.7% 100-310-52820.000 Deferred Comp Employer Match 300.00 300.03 300.00 300.92 312.00 575.01 184.3% 100-310-61100.000 Postage 200.00 - 20.00 - 114.00 - 0.0% 100-310-61200.000 Printing and Copying - - 45.00 43.24 150.00 - 0.0% 100-310-61400.000 Office Supplies 700.00 413.00 545.00 542.99 1,000.00 512.55 51.3% 100-310-61500.000 Small Office Equipment - - - - 5,000.00 - 0.0% (3,000) 100-310-63700.000 Public Works Services 10,000.00 100.00 4,331.00 4,237.53 10,000.00 8,277.00 82.8% 100-310-63900.000 General Services 2,000.00 1,345.57 2,000.00 2,000.00 2,000.00 - 0.0% 100-310-63910.000 2023 Storm Emergency - - - - 95,000.00 9,361.49 9.9% (80,000) 100-310-64900.000 Other Utilities 300.00 222.84 300.00 224.06 300.00 95.00 31.7% 100-310-65000.000 Vehicle & Equip. Parts & Supplies 500.00 50.18 - - 1,500.00 - 0.0% 100-310-65100.000 General Operating Supplies 2,000.00 1,033.61 1,191.00 1,190.21 1,500.00 222.41 14.8% 100-310-65200.000 Uniforms/Personnel Equipment 600.00 - 300.00 236.08 750.00 194.63 26.0% 100-310-65300.000 Technology Supplies 1,200.00 - 800.00 716.10 1,000.00 - 0.0% 100-310-65600.000 Janitorial Supplies 200.00 203.79 - - - - #DIV/0! 100-310-66200.000 Vehicle and Equipment Maintenance 500.00 - - - 2,000.00 - 0.0% 100-310-67100.000 Meetings & Conferences - - - - 3,000.00 944.86 31.5% 100-310-67200.000 Other Training 1,500.00 433.92 348.00 745.00 1,000.00 518.84 51.9% 100-310-67300.000 Other Meals & Travel - - 200.00 43.71 208.00 23.66 11.4% 100-310-67400.000 Certifications 500.00 - - - 1,000.00 - 0.0% 100-310-68300.000 Memberships 1,000.00 192.00 10.00 - 1,000.00 216.00 21.6% 100-310-72000.000 Minor Projects 1,500.00 1,590.10 500.00 - 2,000.00 - 0.0% 100-310-95610.000 HR Allocation 1,504.00 - 1,565.00 - 1,627.00 - 0.0% 100-310-95620.000 IT Allocation 4,318.00 - 4,490.00 - 4,670.00 - 0.0% 100-310-95630.000 Fleet Allocation 4,189.00 - 4,356.00 - 4,530.00 - 0.0% 100-310-95680.000 Risk Management Allocation 3,716.00 - 3,864.00 - 4,019.00 - 0.0% 100-310-95690.000 Vehicle Replacement Allocation` 171,667.00 - - - - - #DIV/0! 269,279.00 61,855.02 176,342.00 73,194.29 297,392.00 129,391.63 43.5% (67,200.00) 305
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-320-51100.000 Salaries 168,216.00 183,153.59 246,939.00 191,395.04 254,966.00 93,650.87 36.7% (20,000) 100-320-51105.000 Emergency Leave - 698.43 - - - - #DIV/0! 100-320-51300.000 Overtime - 7,635.34 - 8,625.76 - 8,680.45 #DIV/0! 100-320-51410.000 Bilingual Pay 4,914.00 4,074.00 - 3,540.00 - 714.00 #DIV/0! 100-320-51415.000 Leave Payoff - 1,752.24 - 12,643.15 - 1,791.56 #DIV/0! 100-320-51420.000 Certification Pay 504.00 1,644.28 1,008.00 1,206.98 1,048.00 552.63 52.7% 100-320-51495.000 On-Call Pay - 53.99 - 61.70 - - #DIV/0! 100-320-52110.000 Social Security 10,169.00 11,781.11 11,975.00 12,730.09 12,454.00 6,279.17 50.4% 100-320-52120.000 Medicare 2,378.00 2,755.37 2,801.00 2,977.54 2,913.00 1,468.52 50.4% 100-320-52300.000 Workers' Compensation 15,739.00 887.78 14,254.00 41.15 14,824.00 - 0.0% 100-320-52400.000 PERS 14,854.00 17,082.85 17,757.00 16,756.16 18,467.00 6,523.99 35.3% 100-320-52450.000 Unfunded Liability 11,844.00 - 19,383.00 - 20,158.00 - 0.0% 100-320-52510.000 Health Insurance 33,421.00 24,442.49 26,608.00 36,837.18 27,673.00 15,739.77 56.9% 100-320-52515.000 Dental/Vision Insurance 1,020.00 1,040.49 1,020.00 914.41 1,061.00 381.90 36.0% 100-320-52525.000 Self Insurance 12,600.00 - 12,600.00 - 13,104.00 78.00 0.6% 100-320-52530.000 Long-Term Disability Insurance 1,060.00 987.42 1,020.00 840.73 1,061.00 192.69 18.2% 100-320-63700.000 Public Works Services 40,000.00 43,635.90 42,549.00 36,207.47 40,000.00 14,249.00 35.6% 100-320-63900.000 General Services 2,000.00 411.25 - - - - #DIV/0! 100-320-64300.000 Water Utility 2,000.00 9,385.17 5,000.00 4,557.91 6,000.00 2,932.29 48.9% 100-320-64400.000 Waste Disposal 15,000.00 14,887.21 15,940.00 11,186.24 20,750.00 10,364.31 49.9% 100-320-64600.000 Cell Phone Charges 300.00 523.68 610.00 443.60 800.00 271.32 33.9% 100-320-64900.000 Other Utilities 892.00 891.24 895.00 896.12 950.00 371.77 39.1% 100-320-65000.000 Vehicle & Equip. Parts & Supplies - 880.14 595.00 594.75 1,500.00 538.73 35.9% 100-320-65100.000 General Operating Supplies - - - - 1,000.00 18.06 1.8% 100-320-65200.000 Uniforms / Personnel Equipment 2,000.00 3,601.79 4,522.00 4,521.43 5,000.00 3,535.69 70.7% 100-320-65600.000 Jantorial Supplies 500.00 124.77 277.00 164.25 480.00 144.30 30.1% 100-320-65700.000 Public Works Supplies 20,000.00 12,119.94 5,000.00 4,334.96 4,300.00 1,999.18 46.5% 100-320-65800.000 Permits & Inspections 1,000.00 999.86 1,830.00 1,829.48 2,300.00 760.00 33.0% 100-320-65900.000 Building Maintenance Supplies - - - - 3,000.00 - 0.0% (1,000) 100-320-66100.000 Gasoline & Oil 6,000.00 6,179.09 11,595.00 11,594.67 11,300.00 6,644.61 58.8% 100-320-66200.000 Vehicle and Equipment Maintenance - 451.13 2,300.00 2,222.02 4,300.00 1,394.39 32.4% 100-320-66300.000 General Operations Equipment 5,000.00 7,284.24 11,081.00 11,080.92 10,000.00 3,699.55 37.0% 100-320-67200.000 Other Training 1,500.00 1,260.40 900.00 880.19 3,500.00 659.84 18.9% 100-320-67400.000 Certifications 1,000.00 358.00 150.00 150.00 300.00 151.65 50.6% 100-320-68300.000 Memberships - 192.00 - - - - #DIV/0!
100-320-68700.000 Property Taxes - 198.26 822.00 821.02 350.00 324.36 92.7% 100-320-71500.000 Parks/Public Works Equipment - - 4,800.00 4,800.00 3,000.00 - 0.0% 100-320-81500.000 Vehicles - 5,521.20 40.00 36.34 - - #DIV/0! 100-320-95610.000 HR Allocation 6,903.00 - 6,177.00 - 6,903.00 - 0.0% 100-320-95620.000 IT Allocation 7,561.00 - 8,491.00 - 7,561.00 - 0.0% 100-320-95630.000 Fleet Allocation 12,202.00 - 3,832.00 - 12,202.00 - 0.0% 100-320-95680.000 Risk Management Allocation 17,051.00 - 17,500.00 - 18,200.00 - 0.0% 100-320-95690.000 Vehicle Replacement Allocation 48,625.00 - 8,200.00 5,651.85 20,954.38 3,593.50 17.1% 466,253.00 366,894.65 508,471.00 390,543.11 552,379.38 187,706.10 34.0% (21,000.00) 100-550-51100.000 Salaries 180,560.00 153,246.36 266,496.00 160,740.63 274,512.00 86,559.68 31.5% (80,000) 100-550-51300.000 Overtime - 3,982.66 - 9,703.72 - 6,428.81 #DIV/0! 100-550-51410.000 Bilingual Pay 3,666.00 3,060.00 - 2,262.00 - 612.00 #DIV/0! 100-550-51415.000 Leave Payoff - - - 8,158.66 - 2,119.12 #DIV/0! 100-550-51420.000 Certification Pay 504.00 723.97 - 3,043.79 - 1,729.54 #DIV/0! 100-550-51480.000 Worker's Comp Pay - - - 10.29 - 582.82 #DIV/0! 100-550-52110.000 Social Security 10,781.00 9,390.53 11,638.00 10,813.85 12,103.00 5,783.22 47.8% 306
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-550-52120.000 Medicare 2,521.00 2,196.16 2,722.00 2,528.71 2,831.00 1,352.44 47.8% 100-550-52300.000 Workers' Compensation 16,895.00 - 14,235.00 - 14,804.00 - 0.0% 100-550-52400.000 PERS 16,178.00 15,744.15 16,906.00 14,678.26 17,583.00 7,090.53 40.3% 100-550-52450.000 Unfunded Liability 15,006.00 - 13,601.00 - 14,145.00 - 0.0% 100-550-52510.000 Health Insurance 38,729.00 38,906.91 58,634.00 35,537.34 60,980.00 16,218.27 26.6% (20,000) 100-550-52515.000 Dental/Vision Insurance 1,085.00 746.53 1,085.00 736.90 1,129.00 337.58 29.9% 100-550-52525.000 Self Insurance 13,400.00 - 13,400.00 - 13,936.00 32.50 0.2% 100-550-52530.000 Long-Term Disability Insurance 1,051.00 777.86 1,189.00 675.06 1,237.00 213.40 17.3% 100-550-63700.000 Public Works Services 13,000.00 20,583.92 21,932.00 20,862.49 20,000.00 5,124.00 25.6% 100-550-63900.000 General Services - - - 65,782.00 - - #DIV/0! 100-550-64100.000 Electricity 5,000.00 2,160.68 2,946.00 2,945.90 3,600.00 1,260.04 35.0% 100-550-64300.000 Water Utility 100,000.00 67,239.59 91,301.00 91,300.81 100,000.00 48,368.57 48.4% 100-550-64400.000 Waste Disposal 2,000.00 1,456.56 1,689.00 1,539.72 2,000.00 1,069.22 53.5% 100-550-64600.000 Cell Phone Charges 500.00 523.68 444.00 443.56 600.00 395.25 65.9% 100-550-64700.000 Radios - - - - 500.00 - 0.0%
100-550-64900.000 Other Utilities 446.00 445.68 469.00 448.13 500.00 190.00 38.0% 100-550-65000.000 Vehicle & Equip. Parts & Supplies - 394.43 2,001.00 2,000.30 2,000.00 1,128.14 56.4% 100-550-65100.000 General Operating Supplies - - 1,100.00 871.47 2,800.00 107.17 3.8% 100-550-65200.000 Uniforms/Personnel Equipment 1,000.00 2,428.42 3,514.00 3,513.18 4,500.00 2,546.31 56.6% 100-550-65600.000 Janitorial Supplies 3,500.00 607.94 1,021.00 1,020.58 5,000.00 919.00 18.4% 100-550-65700.000 Public Works Supplies 15,000.00 7,926.17 16,700.00 16,699.77 17,000.00 9,190.83 54.1% 100-550-65900.000 Building Maintenance Supplies 2,000.00 1,153.15 4,458.00 4,457.46 8,000.00 2,035.89 25.4% 100-550-66100.000 Gasoline & Oil 7,000.00 7,399.71 14,129.00 14,128.49 17,600.00 8,090.28 46.0% 100-550-66200.000 Vehicle and Equipment Maintenance - 339.69 30.00 30.00 7,000.00 760.65 10.9% 100-550-66300.000 General Operations Equipment 2,500.00 1,801.26 4,563.00 3,864.47 8,000.00 1,802.42 22.5% 100-550-67100.000 Meetings & Conferences - - - - 6,000.00 - 0.0% 100-550-67200.000 Other Training 1,000.00 1,134.99 443.00 442.46 1,500.00 - 0.0% 100-550-67400.000 Certifications 1,000.00 - 719.00 718.40 1,500.00 240.20 16.0% 100-550-68300.000 Memberships 500.00 180.00 200.00 185.00 700.00 191.00 27.3% 100-550-68700.000 Property Taxes - 1,900.10 1,935.00 1,934.42 2,000.00 2,163.74 108.2% 100-550-71500.000 Parks/Public Works Equipment - - 3,100.00 3,100.00 - - #DIV/0! 100-550-95610.000 HR Allocation 7,410.00 - 6,633.00 - 7,410.00 - 0.0% 100-550-95620.000 IT Allocation 8,155.00 - 9,122.00 - 8,155.00 - 0.0% 100-550-95630.000 Fleet Allocation 5,463.00 - 2,520.00 - 5,463.00 - 0.0% 100-550-95680.000 Risk Management Allocation 18,302.00 - 15,502.00 - 18,302.00 - 0.0% 100-550-95690.000 Vehicle Replacement Allocation 34,000.00 - 8,200.00 - 24,200.00 - 0.0% 528,152.00 346,451.10 614,577.00 485,177.82 687,590.00 214,642.62 31.2% (100,000.00) 100-551-51100.000 Salaries - - - 6,940.00 - 3,680.00 #DIV/0! 10,000 100-551-52110.000 Social Security - - - 430.28 - 228.16 #DIV/0! 100-551-52120.000 Medicare - - - 100.63 - 53.36 #DIV/0! 100-551-61200.000 Printing and Copying 1,500.00 - 1,000.00 - 1,040.00 569.45 54.8% 100-551-61400.000 Office Supplies 500.00 - 300.00 - 2,312.00 528.19 22.8% 100-551-61500.000 Small Office Equipment 350.00 - - - - - #DIV/0! 100-551-63500.000 Recreation Services 37,400.00 23,978.30 53,000.00 36,357.95 57,280.00 21,639.42 37.8% 100-551-63700.000 Public Works Services 8,000.00 - - - - - #DIV/0! 100-551-63900.000 General Services 2,000.00 2,400.00 10,000.00 3,805.75 9,300.00 5,033.79 54.1% 100-551-63901.000 Grant Writing 62,233.00 84,666.02 - 4,160.00 - - #DIV/0! 100-551-64100.000 Electricity 5,000.00 5,484.72 6,500.00 7,790.41 6,760.00 5,987.57 88.6% 100-551-64200.000 Gas Utility 2,500.00 2,111.94 2,500.00 2,178.97 2,600.00 2,611.91 100.5% 100-551-64300.000 Water Utility - 2,290.63 3,000.00 2,932.76 3,120.00 1,430.86 45.9% 100-551-64400.000 Waste Disposal 2,500.00 2,378.20 2,500.00 2,039.31 2,600.00 1,516.83 58.3% 100-551-64500.000 Phone Charges - 1,880.28 2,000.00 1,880.28 2,380.00 978.06 41.1% 307
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-551-64600.000 Cell Phone Charges 1,200.00 910.39 2,500.00 1,493.19 1,840.00 1,026.02 55.8% 100-551-64900.000 Other Utilities 500.00 259.98 600.00 224.06 624.00 95.00 15.2% 100-551-65000.000 Vehicle & Equip. Parts & Supplies - - - - - 71.51 #DIV/0! 100-551-65100.000 General Operating Supplies 2,000.00 1,000.00 1,000.00 38.48 1,040.00 421.35 40.5% 100-551-65600.000 Jantorial Supplies 2,500.00 376.12 1,500.00 - 1,560.00 273.53 17.5% 100-551-65900.000 Building Maintenance Supplies - 241.40 - 660.99 - 49.49 #DIV/0! 100-551-66100.221 Gasoline & Oil 1,500.00 1,099.38 - 1,585.18 1,560.00 989.83 63.5% 100-551-66200.000 Vehicle and Equipment Maintenance - - - - - 12.00 #DIV/0! 100-551-67200.000 Other Training - - 2,500.00 - - - #DIV/0! 2,500 100-551-68700.000 Property Taxes - 1,639.24 2,000.00 1,665.24 2,080.00 1,615.66 77.7% 100-551-81500.000 Vehicles - 5,521.20 - 5,688.19 5,651.85 3,681.16 65.1% 129,683.00 136,237.80 90,900.00 79,971.67 101,747.85 52,493.15 51.6% 12,500.00 100-601-51100.000 Salaries 347,528.00 334,244.07 573,045.00 279,181.70 587,960.00 237,072.67 40.3% (100,000) 100-601-51300.000 Overtime 3,500.00 1,725.19 3,500.00 1,085.62 3,640.00 1,216.51 33.4% 100-601-51410.000 Bilingual Pay 3,120.00 2,460.00 - 870.00 - 1,170.00 #DIV/0! 100-601-51415.000 Leave Payoff - 2,473.12 2,517.86 2,517.86 - 1,019.28 #DIV/0! 100-601-52110.000 Social Security 20,981.00 20,507.34 21,726.00 16,779.53 22,595.00 14,298.01 63.3% 100-601-52120.000 Medicare 4,949.00 4,810.37 5,297.00 4,058.31 5,509.00 3,428.90 62.2% 100-601-52300.000 Workers' Compensation 32,517.00 - 26,486.00 - 27,545.00 - 0.0% 100-601-52400.000 PERS 29,503.00 32,986.56 29,815.00 26,189.93 31,007.00 20,709.86 66.8% 100-601-52450.000 Unfunded Liability 20,881.00 - 26,456.00 - 27,515.00 - 0.0% 100-601-52510.000 Health Insurance 27,069.00 21,588.06 27,057.00 11,880.42 28,140.00 11,651.48 41.4% 100-601-52515.000 Dental/Vision Insurance 1,296.00 1,171.24 1,296.00 834.82 1,348.00 834.82 61.9% 100-601-52525.000 Self Insurance 16,000.00 - 16,000.00 - 16,640.00 599.62 3.6% 100-601-52530.000 Long-Term Disability Insurance 1,420.00 1,465.94 1,580.00 1,130.10 1,644.00 663.75 40.4% 100-601-52820.000 Deferred Comp Employer Match 1,200.00 900.00 1,200.00 1,200.00 1,248.00 1,350.00 108.2% 2,000 100-601-61100.000 Postage 500.00 - 500.00 - 515.00 - 0.0% 100-601-61200.000 Printing and Copying 1,000.00 139.10 143.00 132.29 1,950.00 - 0.0% 100-601-61300.000 Advertising 500.00 - - - 2.00 - 0.0%
100-601-61400.000 Office Supplies 1,500.00 1,287.33 901.00 937.79 1,803.00 1,222.23 67.8% 100-601-61500.000 Small Office Equipment 2,500.00 - - 607.24 1,030.00 332.16 32.2% 100-601-61600.000 Office Equipment Maint. & Repair 1,000.00 - - - - - #DIV/0! 100-601-63100.000 Adminstration Servicess 3,500.00 62,109.30 20,808.00 37,006.79 7,400.00 - 0.0% 100-601-63600.000 Community Development Services 150,000.00 1,139,579.01 852,106.92 994,392.88 461,362.50 217,426.85 47.1% 100-601-63700.000 General Engineering Services 2,000.00 22,343.75 31,200.00 30,961.77 31,200.00 7,400.00 23.7% 100-601-63900.000 General Services 1,500.00 - 40,053.00 41,052.87 2,382.50 2,382.50 100.0% 100-601-64500.000 Phone Charges 450.00 - - - - - #DIV/0! 100-601-64600.000 Cell Phone Charges 1,262.00 1,254.47 1,200.00 1,203.58 1,236.00 724.36 58.6% 100-601-64900.000 Ohter Utilitiies 187.00 185.70 250.00 227.35 250.00 95.00 38.0% 100-601-65100.000 General Operating Supplies 1,500.00 97.10 500.00 382.66 500.00 466.80 93.4% 100-601-65200.000 Uniforms / Personnel Equipment 750.00 - - - 750.00 - 0.0% 100-601-65300.000 Technology Supplies - - - - 22,500.00 - 0.0% 100-601-65800.000 Permits & Inspections 2,000.00 - - - 2,000.00 - 0.0% 100-601-65900.000 Building Maintenance Supplies 300.00 52.11 - - - - #DIV/0! 100-601-66100.000 Gasoline & Oil - 1,144.71 2,000.00 2,056.03 2,000.00 1,096.86 54.8% 100-601-66200.000 Vehicle and Equipment Maintenance 2,000.00 72.95 12.00 24.00 500.00 52.03 10.4% 100-601-67100.000 Meetings & Conferences 7,000.00 - - - 5,350.00 787.03 14.7% 100-601-67200.000 Other Training 4,500.00 3,172.53 4,257.00 4,257.00 6,500.00 2,866.02 44.1% 100-601-67300.000 Other Meals & Travel 1,000.00 - - - 500.00 82.00 16.4% 100-601-67400.000 Certifications 2,000.00 - 145.00 145.00 500.00 - 0.0% 100-601-67600.000 Publications 7,000.00 - - - 2,000.00 - 0.0% 100-601-68300.000 Memberships 1,500.00 145.00 348.00 348.00 1,500.00 - 0.0% 308
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
100-601-71100.000 Office Equipment / Furniture - - 1,000.00 - - - #DIV/0! 100-601-71300.000 Technology Equipment - - - - 25,000.00 - 0.0% 100-601-73710.000 Community Marketing Project - - 4,843.57 4,843.57 45,000.00 - 0.0% 100-601-73720.000 LEAP Grant Expenditure - - - - 65,000.00 - 0.0% 100-601-73721.000 REAP Grant Expenditure - - - - 65,000.00 - 0.0% 100-601-81500.000 Vehicles - 5,524.92 - 36.34 - - #DIV/0! 100-601-95610.000 HR Allocation 14,262.00 - 12,970.00 - 14,262.00 - 0.0% 100-601-95620.000 IT Allocation 18,244.00 - 22,896.00 - 18,244.00 - 0.0% 100-601-95630.000 Fleet Allocation 255.00 - 2,940.00 - 255.00 - 0.0% 100-601-95680.000 Risk Management Allocation 35,227.00 - 30,311.00 - 35,227.00 - 0.0% 100-601-95690.000 Vehicle Replacement Allocation 3,500.00 - 5,149.65 5,655.66 5,655.65 3,595.98 63.6% 776,901.00 1,661,439.87 1,770,510.00 1,469,999.11 1,582,165.65 532,544.72 33.7% (98,000.00) Fund: 102 - Fire General
102-41150.000 Property Tax 148,000.00 371,744.20 275,600.00 276,650.92 286,624.00 - 0.0% 102-41183.000 Measure C 765,000.00 803,027.67 - 834,855.53 843,648.00 480,467.32 57.0% 102-47815.000 COVID-19 Grant - - - 1,471.24 - - #DIV/0! 102-47899.000 Miscellaneous Revenues-Other - 11,653.60 1,040.00 27,197.98 1,082.00 396.72 36.7% 25,000 102-49600.000 Transfer IN - - - - 500,000.00 - 0.0%
913,000.00 1,186,425.47 276,640.00 1,140,175.67 1,631,354.00 480,864.04 29.5% 25,000 102-250-51100.000 Salaries 759,702.00 866,472.34 958,599.00 1,059,345.27 989,903.00 782,841.99 79.1% 180,000 102-250-51105.000 Emergency Leave - 5,262.88 - - - - #DIV/0! 102-250-51300.000 Overtime 41,500.00 245,971.47 41,500.00 316,032.58 43,160.00 229,268.49 531.2% 225,000 102-250-51410.000 Bilingual Pay - 8,725.43 - 7,698.14 - 5,515.50 #DIV/0! 102-250-51415.000 Leave Payoff - 31,531.70 - 34,779.56 - 24,352.67 #DIV/0! 102-250-51475.000 Holiday Payout 21,905.00 33,546.46 - 31,408.57 - 26,559.74 #DIV/0! 102-250-52110.000 Social Security 48,779.00 67,959.87 48,578.00 84,135.12 50,522.00 13,000.21 25.7% 102-250-52120.000 Medicare 11,615.00 16,961.51 11,661.00 20,640.46 12,127.00 15,243.07 125.7% 102-250-52300.000 Workers' Compensation 71,083.00 240.00 55,588.00 1,522.56 57,812.00 - 0.0% 102-250-52400.000 PERS 95,565.00 124,486.86 86,378.00 133,915.63 89,833.00 99,580.66 110.9% 102-250-52450.000 Unfunded Liability - - 15,931.00 - 16,568.00 - 0.0% 102-250-52510.000 Health Insurance 51,116.00 53,093.96 55,314.00 67,426.39 57,527.00 51,189.21 89.0% 102-250-52515.000 Dental/Vision Insurance 2,268.00 2,267.72 2,268.00 2,392.32 2,358.00 1,981.14 84.0% 102-250-52525.000 Self Insurance 28,000.00 - 28,000.00 - 29,120.00 1,631.58 5.6% 102-250-52530.000 Long- Term Disability Insurance 2,847.00 2,718.21 2,717.00 2,649.51 2,826.00 1,538.67 54.4% 102-250-52820.000 Deferred Comp Employer Match - - - - - 1,865.00 #DIV/0! 102-250-61100.000 Postage 1,200.00 47.46 200.00 130.94 250.00 66.42 26.6% 102-250-61200.000 Printing and Copying 2,500.00 1,848.21 500.00 253.57 500.00 - 0.0% 1,200 102-250-61300.000 Advertising 1,600.00 - - 74.41 - - #DIV/0! 102-250-61400.000 Office Supplies 3,200.00 2,103.49 1,500.00 1,035.30 1,500.00 56.01 3.7% 102-250-61500.000 Small Office Equipment 1,000.00 351.49 - - - - #DIV/0! 102-250-61600.000 Office Equipment Maint. & Repair 1,000.00 - - - - - #DIV/0! 102-250-63100.000 Administration Services 7,000.00 1,104.00 2,500.00 - 2,500.00 - 0.0% 102-250-63200.000 Technology Services 12,000.00 5,947.17 7,000.00 - 7,000.00 1,764.05 25.2% 102-250-63600.000 Community Development Services 25,000.00 20,125.00 25,000.00 28,775.00 25,000.00 16,350.00 65.4% 5,000 102-250-63700.000 Public Works Services 8,500.00 2,092.81 5,000.00 309.03 5,000.00 - 0.0% 102-250-63900.000 General Services 14,500.00 9,240.47 15,000.00 14,905.03 15,000.00 14,101.87 94.0% 102-250-64100.000 Electricity 8,300.00 10,694.31 11,000.00 10,786.50 11,000.00 7,466.78 67.9% 102-250-64200.000 Gas Utility 2,400.00 1,424.76 1,500.00 1,599.92 1,500.00 1,441.22 96.1% 102-250-64300.000 Water Utility 4,900.00 1,847.78 3,000.00 2,155.49 3,000.00 1,347.01 44.9% 309
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
102-250-64400.000 Waste Disposal 1,300.00 2,647.51 2,500.00 3,048.60 2,500.00 2,006.90 80.3% 1,500 102-250-64600.000 Cell Phone Charges 700.00 1,624.33 2,500.00 1,731.19 2,500.00 1,591.03 63.6% 102-250-64900.000 Other Utilities 34,500.00 43,399.35 50,000.00 35,895.00 50,000.00 41,860.00 83.7% 4,000 102-250-65000.000 Vehicle & Equip. Parts & Supplies - 1,724.37 - 1,421.92 3,272.82 1,714.61 52.4% 102-250-65100.000 General Operating Supplies 5,000.00 6,087.16 8,000.00 12,177.13 8,550.00 1,736.19 20.3% 102-250-65200.000 Uniforms/Personnel Equipment 22,000.00 22,515.12 30,000.00 32,084.89 30,000.00 4,080.22 13.6% 102-250-65400.000 Firefighter Supplies/Prevention 10,800.00 20,726.24 20,000.00 25,718.85 20,000.00 10,281.29 51.4% 7,400 102-250-65600.000 Jantorial Supplies 6,000.00 3,057.25 3,000.00 3,523.98 3,000.00 2,075.52 69.2% 102-250-65700.000 Public Works Supplies - 133.47 2,000.00 339.38 2,000.00 33.14 1.7% 102-250-65900.000 Building Maintenance Supplies 29,000.00 27,325.22 25,000.00 7,460.55 12,000.00 3,500.37 29.2% 102-250-66100.000 Gasoline & Oil 25,000.00 11,434.85 15,000.00 21,225.83 15,000.00 11,750.51 78.3% 10,000 102-250-66200.000 Vehicle and Equipment Maintenance 30,000.00 36,573.53 32,000.00 12,070.73 30,000.00 19,128.18 63.8% 102-250-66300.000 General Operations Equipment 9,000.00 12,166.15 10,000.00 8,887.52 10,000.00 1,425.06 14.3% 102-250-67100.000 Meetings & Conferences 13,500.00 480.44 5,000.00 3,926.99 5,000.00 475.30 9.5% 102-250-67200.000 Other Training 3,000.00 7,998.32 - 2,845.04 5,000.00 2,099.58 42.0% 102-250-67400.000 Certifications 6,500.00 2,306.66 5,000.00 5,205.32 3,000.00 560.00 18.7% 102-250-67600.000 Publications 1,200.00 564.00 3,000.00 - - - #DIV/0! 102-250-67800.000 Tuition Fees 5,000.00 2,190.00 - 1,675.00 6,000.00 500.00 8.3% 102-250-68200.000 Community Outreach 1,500.00 1,833.84 6,000.00 5,170.60 - - #DIV/0! 102-250-68300.000 Memberships 3,500.00 421.90 3,500.00 548.00 3,500.00 100.00 2.9% 102-250-68700.000 Property Taxes - 177.50 200.00 180.32 200.00 189.62 94.8% 102-250-72200.000 Weed Abatement Expenses - - - - 13,000.00 12,703.00 97.7% 102-250-79100.000 Covid-19 Expenses - 40,149.72 - - - - #DIV/0! 102-250-95600.000 Transfer Out 5,500.00 - - - - - #DIV/0! 102-250-95610.000 HR Allocation 31,177.00 - 31,177.00 - 31,177.00 - 0.0% 102-250-95620.000 IT Allocation 54,142.00 - 54,142.00 - 54,142.00 - 0.0% 102-250-95630.000 Fleet Allocation 3,047.00 - 3,047.00 - 3,047.00 - 0.0% 102-250-95680.000 Risk Management Allocation 77,007.00 - 77,007.00 - 77,007.00 - 0.0% 102-250-95690.000 Vehicle Replacement Allocation 242,925.00 1,641.36 6,000.00 6,720.76 6,720.80 4,377.38 65.1% 1,848,778.00 1,763,243.65 1,772,807.00 2,013,828.90 1,820,622.62 1,419,349.19 78.0% 434,100.00 Fund: 220 - Supplemental Transactions & Use Tax Fund (V & W) 220-41220.000 Transactions & Use Tax - Measure V / X 1,559,800.00 1,674,981.01 1,926,720.00 1,877,735.13 1,991,948.57 1,002,894.68 50.3% 220-41230.000 Transactions & Use Tax - Measure W 1,190,200.00 1,249,779.49 1,445,040.00 1,406,322.09 1,493,961.43 750,991.42 50.3% 220-46110.000 Interest Income - Pooled Cash - 3,452.12 - 2,187.25 - - #DIV/0! 220-46115.000 Unrealized Gain/Loss - (1,477.37) - (6,866.24) - - #DIV/0! 2,750,000.00 2,926,735.25 3,371,760.00 3,279,378.23 3,485,910.00 1,753,886.10 50.3% 220-215-51100.000 Salaries 1,235,135.00 1,414,890.53 1,454,029.00 1,295,381.38 1,512,191.00 757,814.01 50.1% (130,000) 220-215-51105.000 Emergency Leave - 4,518.56 - - - - #DIV/0! 220-215-51300.000 Overtime 165,000.00 329,826.02 165,000.00 533,251.25 171,600.00 258,112.57 150.4% 130,000 220-215-51305.000 Emergency OT - 2,734.80 - - - - #DIV/0! 220-215-51410.000 Bilingual Pay 3,609.00 8,155.42 7,800.00 15,309.00 8,112.00 8,210.49 101.2% 3,000 220-215-51415.000 Leave Payoff - 30,149.27 20,000.00 32,534.92 20,800.00 26,077.61 125.4% 7,000 220-215-51425.000 POST Intermediate 7,889.00 4,250.88 - 2,534.08 - 1,754.40 #DIV/0! 1,800 220-215-51430.000 POST Advanced 5,166.00 10,220.18 3,559.00 5,763.84 3,701.00 3,936.52 106.4% 2,000 220-215-51435.000 FTO Pay 15,920.00 18,196.40 16,000.00 23,711.20 16,640.00 13,193.20 79.3% 3,000 220-215-51442.000 Traffic Officer Pay 3,753.00 4,452.00 4,807.00 8,550.36 4,999.00 5,759.00 115.2% 3,000 220-215-51445.000 SRO Pay 3,899.00 4,106.80 4,807.00 1,977.60 4,999.00 3,508.80 70.2% 4,000 220-215-51457.000 Detective Pay - 11,074.49 17,024.00 23,099.88 17,704.00 15,321.28 86.5% 3,000 220-215-51462.000 Gang Suppression Unit Pay 15,784.00 6,243.60 - 19,956.24 - 14,354.12 #DIV/0! 17,000 220-215-51467.000 Explorer Pay 12,945.00 20,623.21 19,464.00 18,426.84 20,243.00 - 0.0% (20,243) 310
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
220-215-51468.000 Education Pay - 23,293.97 21,537.00 31,110.14 22,399.00 20,784.14 92.8% 5,000 220-215-51469.000 Armorer Pay - 9,621.24 11,717.00 8,303.08 12,185.00 9,444.04 77.5% 2,000 220-215-51470.000 Uniform Allowance 17,600.00 16,292.63 880.00 15,925.69 915.00 9,392.45 1026.5% 13,000 220-215-51475.000 Holiday Payout 54,528.00 57,778.29 55,000.00 64,130.76 57,200.00 45,674.44 79.9% (10,000) 220-215-51480.000 Workers' Comp Pay - - - 18,893.02 - 8,482.11 #DIV/0! 220-215-52110.000 Social Security 92,881.00 114,651.47 98,221.00 119,467.80 102,150.00 57,511.64 56.3% 220-215-52120.000 Medicare 21,722.00 27,815.93 23,754.00 29,636.00 24,704.00 16,835.24 68.1% 220-215-52300.000 Workers' Compensation 115,568.00 - 126,478.00 - 131,537.00 - 0.0% 220-215-52400.000 PERS 189,123.00 204,809.60 195,210.00 197,144.08 203,019.00 102,930.88 50.7% 220-215-52450.000 Unfunded Liability 72,436.00 - 87,791.00 - 91,302.00 - 0.0% 220-215-52510.000 Health Insurance 120,071.00 145,019.02 143,853.00 139,558.91 149,607.00 79,921.42 53.4% (20,000) 220-215-52515.000 Dental/Vision Insurance 4,859.00 5,048.01 4,211.00 4,356.50 4,380.00 2,389.06 54.5% 220-215-52525.000 Self Insurance 60,000.00 - 52,000.00 - 54,080.00 455.00 0.8% 220-215-52530.000 Long-Term Disability Insurance 5,768.00 5,781.08 5,120.00 4,622.27 5,325.00 2,520.22 47.3% 220-215-52820.000 Deferred Comp Employer Match 4,800.00 3,784.81 3,600.00 5,484.08 3,744.00 6,430.80 171.8% 220-215-63400.000 Police Services 37,800.00 12,900.19 - (82.00) - - #DIV/0! 220-215-64600.000 Cell Phone Charges - 68.24 75.00 75.00 - - #DIV/0! 220-215-65000.000 Vehicle & Equip. Parts & Supplies 10,000.00 5,665.68 6,000.00 5,865.72 6,000.00 7,780.75 129.7% 220-215-66200.000 Vehicle and Equipment Maintenance 13,000.00 12,794.72 13,000.00 10,932.32 13,000.00 11,595.24 89.2% 220-215-67800.000 Tuition Fees 3,000.00 - - - - - #DIV/0! 220-215-71400.000 Police Equipment 21,950.00 13,503.78 15,000.00 14,954.58 15,600.00 7,270.68 46.6% 220-215-95610.000 HR Allocation 50,689.00 - 52,717.00 - 54,825.00 - 0.0% 220-215-95620.000 IT Allocation 61,505.00 - 63,965.00 - 66,524.00 - 0.0% 220-215-95630.000 Fleet Allocation 31,273.00 - 32,524.00 - 33,825.00 - 0.0% 220-215-95680.000 Risk Management Allocation 125,199.00 - 130,207.00 - 135,415.00 - 0.0% 220-215-95690.000 Vehicle Replacement Allocation 221,582.00 12,368.08 20,800.00 18,203.87 9,632.00 4,658.29 48.4% 2,804,454.00 2,540,638.90 2,876,150.00 2,669,078.41 2,978,357.00 1,502,118.40 50.4% 13,557.00 220-250-51100.000 Salaries 215,699.00 165,925.48 155,000.00 76,279.08 215,699.00 41,276.76 19.1% (128,000) 220-250-51300.000 Overtime - 70,897.61 69,500.00 15,974.20 - 3,717.72 #DIV/0! 220-250-51410.000 Bilingual Pay - 33,809.85 35,000.00 1,090.97 - 932.45 #DIV/0! 220-250-51475.000 Holiday Payout 10,755.00 10,627.29 9,000.00 7,229.80 10,755.00 2,747.43 25.5% 220-250-52110.000 Social Security 13,460.00 17,237.23 17,000.00 6,063.00 13,460.00 0.80 0.0% 220-250-52120.000 Medicare 3,148.00 4,031.27 37,000.00 1,417.96 3,148.00 681.36 21.6% 220-250-52300.000 Workers' Compensation 20,182.00 - 20,182.00 - 20,182.00 - 0.0% 220-250-52400.000 PERS 29,666.00 27,440.33 25,000.00 11,106.32 29,666.00 5,745.48 19.4% 220-250-52510.000 Health Insurance 44,373.00 6,239.96 8,000.00 5,072.76 44,373.00 2,766.22 6.2% 220-250-52515.000 Dental/Vision Insurance 972.00 647.92 972.00 211.82 972.00 - 0.0% 220-250-52525.000 Self Insurance 12,000.00 - - - 12,000.00 - 0.0% 220-250-52530.000 Long-Term Disability Insurance 1,093.00 490.19 450.00 397.80 1,093.00 198.90 18.2% 220-250-95610.000 HR Allocation 8,852.00 - 7,927.00 - 8,852.00 - 0.0% 220-250-95620.000 IT Allocation 9,594.00 - - - 9,594.00 - 0.0% 220-250-95680.000 Risk Management Allocation 21,864.00 - 18,524.00 - 21,864.00 - 0.0% 391,658.00 337,347.13 403,555.00 124,843.71 391,658.00 58,067.12 14.8% (128,000.00) 220-551-51100.000 Salaries 125,293.00 164,814.87 163,889.00 266,199.81 170,445.00 230,102.67 135.0% 170,000 220-551-51105.000 Emergency Leave - 2,847.62 - - - - #DIV/0! 220-551-51410.000 Bilingual Pay - - - 1,140.00 - 3,000.00 #DIV/0! 220-551-51415.000 Leave Pay Off - 554.20 - 1,055.54 - 960.00 #DIV/0! 220-551-52110.000 Social Security 7,415.00 9,969.09 9,793.00 15,935.01 10,185.00 13,798.34 135.5% 220-551-52120.000 Medicare 1,734.00 2,331.54 2,290.00 3,726.81 2,382.00 3,226.94 135.5% 220-551-52300.000 Workers' Compensation 11,723.00 - 14,786.00 - 15,377.00 - 0.0% 311
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
220-551-52400.000 PERS 7,136.00 11,157.71 4,921.00 18,410.28 5,118.00 16,274.77 318.0% 15,000 220-551-52450.000 Unfunded Liability 83.00 - 163.00 - 170.00 - 0.0% 220-551-52510.000 Health Insurance 17,535.00 24,286.92 22,287.00 35,698.83 23,178.00 38,664.12 166.8% 220-551-52515.000 Dental/Vision Insurance 648.00 872.20 648.00 1,569.96 674.00 1,270.92 188.6% 220-551-52525.000 Self Insurance 8,000.00 - 1,500.00 - 1,560.00 386.19 24.8% 220-551-52530.000 Long-Term Disability Insurance 558.00 694.48 558.00 846.82 581.00 553.69 95.3% 220-551-52820.000 Deferred Comp Employer Match - - 1,200.00 - 1,248.00 350.00 28.0% 220-551-95610.000 HR Allocation 5,142.00 - 4,727.00 - 5,142.00 - 0.0% 220-551-95620.000 IT Allocation 10,382.00 - 15,078.00 - 10,382.00 - 0.0% 220-551-95680.000 Risk Management Allocation 12,700.00 - 11,047.00 - 12,700.00 - 0.0% 208,349.00 217,528.63 252,887.00 344,583.06 259,142.00 308,587.64 119.1% 185,000.00 220-605-51100.000 Salaries 140,107.00 53,421.09 182,479.00 76,372.38 189,778.00 84,219.83 44.4% (50,000) 220-605-51300.000 Overtime 10,000.00 - 10,000.00 4,594.19 10,400.00 10,284.96 98.9% 10,000 220-605-51410.000 Bilingual Pay 4,680.00 90.00 1,560.00 300.00 1,622.00 1,860.00 114.7% 220-605-52110.000 Social Security 9,072.00 3,208.49 11,491.00 4,828.19 11,950.00 5,816.78 48.7% 220-605-52120.000 Medicare 2,122.00 750.27 2,687.00 1,129.21 2,795.00 1,360.43 48.7% 220-605-52300.000 Workers' Compensation 13,109.00 - 16,463.00 - 17,122.00 - 0.0% 220-605-52400.000 PERS 10,859.00 4,152.06 13,969.00 6,151.89 14,527.00 6,349.35 43.7% 220-605-52450.000 Unfunded Liability 126.00 - 464.00 - 483.00 - 0.0% 220-605-52510.000 Health Insurance 35,203.00 5,501.69 36,271.00 7,421.00 37,722.00 5,099.68 13.5% (25,000) 220-605-52515.000 Dental/Vision Insurance 972.00 355.07 972.00 481.47 1,011.00 466.76 46.2% 220-605-52525.000 Self Insurance 12,000.00 - 12,000.00 - 12,480.00 65.00 0.5% (10,000) 220-605-52530.000 Long-Term Disability Insurance 1,043.00 265.06 1,043.00 54.58 1,085.00 - 0.0% 220-605-52820.000 Deferred Comp Employer Match - - - - - 123.04 #DIV/0! 220-605-61100.000 Postage 100.00 - - - 4.00 - 0.0%
220-605-61200.000 Printing and Copying 400.00 42.48 - - 620.00 577.07 93.1% 220-605-64600.000 Cell Phone Charges 1,100.00 751.36 1,200.00 1,200.00 624.00 582.80 93.4% 220-605-65200.000 Uniforms/Personnel Equipment 1,500.00 690.82 2,000.00 1,240.85 2,080.00 1,430.11 68.8% 220-605-65700.000 Public Works Supplies 100.00 - - - - - #DIV/0! 220-605-66100.000 Gasoline & Oil 500.00 212.84 200.00 118.38 208.00 207.50 99.8% 220-605-67100.000 Meetings & Conferences - - - - 1,040.00 991.25 95.3% 220-605-67200.000 Other Training 2,000.00 2,000.00 2,000.00 1,797.70 1,040.00 584.74 56.2% 220-605-95610.000 HR Allocation 5,750.00 - 5,144.00 - 5,349.00 - 0.0% 220-605-95620.000 IT Allocation 7,164.00 - 11,544.00 - 12,006.00 - 0.0% 220-605-95680.000 Risk Management Allocation 14,202.00 - 12,021.00 - 12,502.00 - 0.0% 272,109.00 71,441.23 323,508.00 105,689.84 336,448.00 120,019.30 35.7% (75,000.00) Fund: 100 - GENERAL FUND 725,414
Fund: 102 - Fire General (409,100)
Fund: 105 - Community Outreach -
Fund: 106 - American Recovery Plan Act (ARPA) -
Fund: 220 - Supplemental Transactions & Use Tax Fund (V & W) (31,557) Net Adjustments 284,757
Fund: 200 - SUPPLEMENTAL LAW ENFORCEMENT
200-43622.000 S.L.E.S.F. Grant 100,000.00 148,393.21 100,000.00 100,000.00 100,000.00 115,271.27 115.3% 30,000 200-46110.000 Interest Income- Pooled Cash - 1,349.72 - 564.64 - - #DIV/0! 200-46115.000 Unrealized Gain/Loss - (377.08) - (1,769.49) - - #DIV/0! 100,000.00 149,365.85 100,000.00 98,795.15 100,000.00 115,271.27 115.3% 30,000.00 312
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
200-205-61700.000 Software Maintenance Charges - 15,568.36 - - - - #DIV/0! 200-205-63900.321 General Services - - 17,921.98 17,921.98 - - #DIV/0! 200-205-65100.000 General Operating Supplies - - - - 20,000.00 6,683.40 33.4% 200-205-67200.000 Other Training - - 35,000.00 35,137.70 30,000.00 20,315.91 67.7% 200-205-71400.000 Police Equipment - - 72,078.02 67,189.81 50,000.00 23,035.88 46.1% 200-205-95600.000 Transfer Out 100,000.00 - - - 100,000.00 - 0.0% 100,000.00 15,568.36 125,000.00 120,249.49 200,000.00 50,035.19 25.0% Fund: 202 - Restricted CSA-74
202-41183.000 Restricted CSA-74 - 12,871.82 14,000.00 13,228.75 - 13,267.83 #DIV/0! 13,200 202-46110.000 Interest Income - Pooled Cash - 84.25 - 67.28 - - #DIV/0! 202-46115.000 Unrealized Gain/Loss - (20.17) - (193.35) - - #DIV/0! - 12,935.90 14,000.00 13,102.68 - 13,267.83 #DIV/0! 13,200.00 Fund: 230 - GAS TAX FUND
230-43203.000 Section 2103 Revenue- Prop. 42 Replacement 66,048.00 121,985.88 140,898.00 145,632.38 146,534.00 101,561.48 69.3% 230-43205.000 Section 2105 Revenue- Streets & Highways 100,015.00 93,150.69 103,504.00 102,255.17 107,644.00 66,665.07 61.9% 230-43206.000 Section 2106 Revenue- Construction 48,090.00 43,534.47 48,067.00 48,973.04 49,990.00 31,858.58 63.7% 230-43207.000 Section 2107 Revenue- Maintenance 130,627.00 126,048.67 131,638.00 122,286.68 136,904.00 92,410.70 67.5% 230-43208.000 Section 2107.5 Revenue- Engineering 4,000.00 4,000.00 4,000.00 4,000.00 4,160.00 4,000.00 96.2% (160) 230-43209.000 HUTA Loan Repayment 20,307.00 - - - - - #DIV/0! 230-43210.000 Road Maintenance Rehabilitation (SB 1) 284,826.00 310,232.35 351,241.00 369,885.07 365,291.00 248,876.32 68.1% 230-46110.000 Interest Income- Pooled Cash - 6,240.57 5,000.00 4,569.21 5,200.00 - 0.0% 230-46115.000 Unrealized Gain/Loss - (1,835.73) - (13,460.26) - - #DIV/0! 653,913.00 703,356.90 784,348.00 784,141.29 815,723.00 545,372.15 66.9% (160.00) 230-320-63700.000 Public Works Services 45,600.00 46,677.27 48,000.00 49,070.70 41,600.00 34,925.12 84.0% 230-320-63800.000 Sewer & Water Services - - 2,000.00 2,000.00 5,400.00 - 0.0% 230-320-64100.000 Electricity - 66,650.50 70,000.00 58,031.51 72,800.00 41,611.42 57.2% 230-320-64300.000 Water Utility 2,000.00 858.04 2,000.00 1,487.54 2,080.00 682.67 32.8% 230-320-65200.000 Uniforms / Personnel Equipment 2,000.00 - - - - - #DIV/0! 230-320-65700.000 Public Works Supplies 40,500.00 42,025.34 35,000.00 31,456.54 36,400.00 9,571.95 26.3% 230-320-65800.000 Permits & Inspections 2,900.00 2,848.00 3,000.00 3,326.00 3,120.00 3,120.00 100.0% 230-320-66100.000 Gasoline & Oil 1,000.00 - - - - - #DIV/0! 230-320-66300.000 General Operations Equipment - - 5,000.00 4,489.46 5,200.00 - 0.0% 230-320-67200.000 Other Training - - 1,500.00 - 1,560.00 - 0.0% 230-320-67400.000 Certifications - - 1,000.00 - 1,040.00 - 0.0% 230-320-95690.000 Vehicle Replacement Allocation 3,333.00 - - - - - #DIV/0! 97,333.00 159,059.15 167,500.00 149,861.75 169,200.00 89,911.16 53.1% Fund: 265 - SMD #1
265-41163.000 Street Maintenance District #1 37,000.00 37,473.98 37,925.00 38,327.04 38,873.00 20,090.09 51.7% 265-46110.000 Interest Income- Pooled Cash - 1,605.82 6,000.00 980.59 6,150.00 - 0.0% 265-46115.000 Unrealized Gain/Loss - (576.49) - (3,017.63) - - #DIV/0! 37,000.00 38,503.31 43,925.00 36,290.00 45,023.00 20,090.09 44.6% 265-360-51100.000 Salaries 21,032.00 17,349.62 - 14,020.39 - 10,849.90 #DIV/0! 23,500 265-360-51105.000 Emergency Leave - 49.89 - - - - #DIV/0! 265-360-51300.000 Overtime - 628.47 - 922.58 - 810.41 #DIV/0! 313
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
265-360-51410.000 Bilingual Pay 624.00 291.00 - 234.00 - 153.00 #DIV/0! 265-360-51415.000 Leave Payoff - 125.16 - - - 173.24 #DIV/0! 265-360-51420.000 Certification Stipend 72.00 117.28 - 39.00 - 19.55 #DIV/0! 265-360-51495.000 On-Call Pay - 3.86 - - - - #DIV/0!
265-360-52110.000 Social Security 1,271.00 1,097.16 - 903.05 - 716.99 #DIV/0! 265-360-52120.000 Medicare 297.00 256.64 - 211.25 - 167.66 #DIV/0! 265-360-52300.000 Workers' Compensation 1,968.00 390.66 - - - - #DIV/0! 265-360-52400.000 PERS 1,809.00 1,553.48 - 1,277.20 - 910.32 #DIV/0! 265-360-52450.000 Unfunded Liability 1,160.00 - - - - - #DIV/0! 265-360-52510.000 Health Insurance 4,798.00 2,386.33 - 2,379.58 - 1,627.43 #DIV/0! 265-360-52515.000 Dental/Vision Insurance 130.00 99.44 - 67.01 - 47.84 #DIV/0! 265-360-52525.000 Self Insurance 1,600.00 - - - 200.00 3.25 1.6% 265-360-52530.000 Long-Term Disability Insurance 140.00 87.10 - 67.63 - 42.21 #DIV/0! 265-360-61300.000 Advertising - 785.29 500.00 620.00 600.00 - 0.0% 265-360-63600.000 Assessment District Consultant Services 550.00 2,124.99 600.00 583.33 5,600.00 1,225.00 21.9% (2,000) 265-360-63700.000 Public Works Services - 587.50 - - - - #DIV/0! 265-360-68700.000 Property Taxes - 109.03 110.00 81.94 110.00 86.08 78.3% 265-360-95610.000 HR Allocation 863.00 - 772.00 - 863.00 - 0.0% 265-360-95620.000 IT Allocation 940.00 - 1,065.00 - 940.00 - 0.0% 265-360-95680.000 Risk Management Allocation 2,132.00 - 1,805.00 - 2,132.00 - 0.0% 39,386.00 28,042.90 4,852.00 21,406.96 10,445.00 16,832.88 161.2% 21,500.00 Fund: 266 - SMD #2
266-41164.000 Street Maintenance District #2 85,000.00 91,837.56 87,000.00 119,990.28 88,740.00 48,604.02 54.8% 266-46110.000 Interest Income- Pooled Cash - 2,099.48 5,000.00 1,410.76 5,100.00 - 0.0% 266-46115.000 Unrealized Gain/Loss - (711.51) - (4,258.14) - - #DIV/0! 85,000.00 93,225.53 92,000.00 117,142.90 93,840.00 48,604.02 51.8% 266-360-51100.000 Salaries 21,032.00 17,309.62 - 14,020.33 - 10,849.80 #DIV/0! 23,500 266-360-51105.000 Emergency Leave - 49.89 - - - - #DIV/0! 266-360-51300.000 Overtime - 628.41 - 922.48 - 810.39 #DIV/0! 266-360-51410.000 Bilingual Pay 624.00 213.00 - 144.00 - 90.00 #DIV/0! 266-360-51415.000 Leave Payoff - 125.16 - - - 173.24 #DIV/0! 266-360-51420.000 Certification Stipend 72.00 117.28 - 39.05 - 19.55 #DIV/0! 266-360-51495.000 On-Call Pay - 3.86 - - - - #DIV/0!
266-360-52110.000 Social Security 1,271.00 1,090.38 - 897.51 - 713.00 #DIV/0! 266-360-52120.000 Medicare 297.00 254.96 - 210.04 - 167.13 #DIV/0! 266-360-52300.000 Workers' Compensation 1,968.00 333.76 - - - - #DIV/0! 266-360-52400.000 PERS 1,809.00 1,540.48 - 1,269.60 - 905.08 #DIV/0! 266-360-52450.000 Unfunded Liability 1,160.00 - - - - - #DIV/0! 266-360-52510.000 Health Insurance 4,799.00 2,360.78 - 2,362.97 - 1,616.02 #DIV/0! 266-360-52515.000 Dental/Vision Insurance 130.00 98.56 - 66.48 - 47.37 #DIV/0! 266-360-52525.000 Self Insurance 1,600.00 - - - 200.00 3.25 1.6% 266-360-52530.000 Long-Term Disability Insurance 140.00 86.49 - 67.13 - 41.75 #DIV/0! 266-360-61300.000 Advertising - 953.20 600.00 747.50 915.00 - 0.0% 266-360-63600.000 Assessment District Consultant Services 550.00 2,125.01 1,000.00 583.33 6,025.00 1,225.00 20.3% (3,000) 266-360-63700.000 Public Works Services - 1,082.50 250.00 - 256.00 - 0.0% 266-360-68700.000 Property Taxes - 42.88 42.00 43.54 58.00 45.72 78.8% 266-360-95610.000 HR Allocation 863.00 - 885.00 - 907.00 - 0.0% 266-360-95620.000 IT Allocation 940.00 - 964.00 - 988.00 - 0.0% 266-360-95680.000 Risk Management Allocation 2,132.00 - 2,185.00 - 2,240.00 - 0.0% 39,387.00 28,416.22 5,926.00 21,373.96 11,589.00 16,707.30 144.2% 20,500.00 314
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
Fund: 267 - Vintage Meadows LLMD #3
267-41165.000 LLMD Assessment - - - 34,534.25 - 27,675.42 #DIV/0! 35,000 267-46110.000 Interest Income- Pooled Cash - - - 76.81 - - #DIV/0! 267-46115.000 Unrealized Gain/Loss - - - (204.47) - - #DIV/0! - - - 34,406.59 - 27,675.42 #DIV/0! 35,000.00
267-360-61300.000 Publications - 398.82 - 687.50 - - #DIV/0! 267-360-63600.000 Community Development Services - 1,575.01 - 583.33 - - #DIV/0! 267-360-64100.000 Electricity - 466.13 - 1,759.43 - 1,124.33 #DIV/0! 3,000 - 2,439.96 - 3,030.26 - 1,124.33 #DIV/0! 3,000.00
Fund: 268 - Vintage Meadows SMD #3
268-41166.000 SMD Assessment - - - 31,702.98 - 25,406.52 #DIV/0! 32,000 268-46110.000 Interest Income- Pooled Cash - - - 75.02 - - #DIV/0! 268-46115.000 Unrealized Gain/Loss - - - (199.71) - - #DIV/0! - - - 31,578.29 - 25,406.52 #DIV/0! 32,000.00
268-360-61300.000 Publications - 426.42 - 742.50 - - #DIV/0! 800 268-360-63600.000 Community Development Services - 1,575.00 - 583.33 - - #DIV/0! 600 - 2,001.42 - 1,325.83 - - #DIV/0! 1,400.00
Fund: 503 - SEWER FUND
503-44530.000 Sewer Charges 1,640,923.00 1,545,349.91 1,732,481.00 1,593,180.29 1,767,131.00 1,096,849.16 62.1% 503-46110.000 Interest Income- Pooled Cash - 4,456.76 20,000.00 2,276.28 20,000.00 - 0.0% 503-46115.000 Unrealized Gain/Loss - (1,849.03) - (7,365.82) - - #DIV/0! 503-47899.000 Misc. Revenues - - - 522.81 - - #DIV/0!
503-49600.000 TRANSFER IN - - - - 2,500,000.00 - 0.0%
1,640,923.00 1,547,957.64 1,752,481.00 1,588,613.56 4,287,131.00 1,096,849.16 25.6% 503-191-51100.000 Salaries 48,465.00 52,458.60 58,740.00 60,044.29 61,090.00 60,335.12 98.8% 503-191-51105.000 Emergency Leave - 655.56 - - - - #DIV/0! 503-191-51300.000 Overtime - 57.96 - 332.41 - 1,020.31 #DIV/0! 503-191-51410.000 Bilingual Pay 1,560.00 1,560.00 1,560.00 1,410.00 1,622.00 1,530.00 94.3% 503-191-52110.000 Social Security 2,837.00 3,049.60 3,337.00 3,474.83 3,471.00 3,667.45 105.7% 503-191-52120.000 Medicare 664.00 713.55 781.00 813.02 812.00 858.15 105.7% 503-191-52300.000 Workers' Compensation 4,535.00 - 4,172.00 - 4,339.00 - 0.0% 503-191-52400.000 PERS 4,463.00 5,072.21 5,267.00 5,575.06 5,478.00 4,655.01 85.0% 503-191-52450.000 Unfunded Liability 4,649.00 - 6,411.00 - 6,667.00 - 0.0% 503-191-52510.000 Health Insurance 13,924.00 14,999.62 16,227.00 15,762.44 16,876.00 9,794.93 58.0% 503-191-52515.000 Dental/Vision Insurance 324.00 324.33 324.00 324.33 337.00 212.15 63.0% 503-191-52525.000 Self Insurance 4,000.00 - 4,000.00 - 3,160.00 65.00 2.1% 503-191-52530.000 Long-Term Disability Insurance 279.00 279.69 279.00 259.12 290.00 95.34 32.9% 503-191-52820.000 Deferred Comp Employer Match - - - - - 175.06 #DIV/0! 503-191-61100.000 Postage 10,000.00 - 9,000.00 - 2,000.00 270.50 13.5% 503-191-61200.000 Printing and Copying 5,000.00 4,487.68 6,000.00 5,447.46 5,000.00 3,746.05 74.9% 503-191-61700.000 Software Maintenance Charges 2,500.00 - - - - - #DIV/0! 503-191-63300.000 Financial Services 15,000.00 31,610.21 15,000.00 38,047.74 24,000.00 25,498.74 106.2% 315
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
503-191-63800.000 Utility Bill Services 2,500.00 4,140.76 4,000.00 4,454.83 4,000.00 3,746.06 93.7% 503-191-95610.000 HR Allocation 1,989.00 - 1,780.00 - 1,989.00 - 0.0% 503-191-95620.000 IT Allocation 2,463.00 - 2,595.00 - 2,463.00 - 0.0% 503-191-95680.000 Risk Management Allocation 4,913.00 - 4,160.00 - 4,913.00 - 0.0% 130,065.00 119,409.77 143,633.00 135,945.53 148,507.00 115,669.87 77.9% 503-330-51100.000 Salaries 20,517.00 22,820.33 65,322.00 27,122.01 67,935.00 48,448.48 71.3% 503-330-51410.000 Bilingual Pay 546.00 546.00 - 546.00 568.00 357.00 62.9% 503-330-51415.000 Leave Payoff - 793.24 - - - 938.84 #DIV/0! 503-330-52110.000 Social Security 1,231.00 1,374.50 1,230.00 1,561.46 1,280.00 2,880.53 225.0% 503-330-52120.000 Medicare 288.00 321.61 288.00 365.22 299.00 673.70 225.3% 503-330-52300.000 Workers' Compensation 1,920.00 - 1,523.00 - 1,584.00 - 0.0% 503-330-52400.000 PERS 1,580.00 1,840.75 1,628.00 2,233.12 1,693.00 4,575.21 270.2% 503-330-52450.000 Unfunded Liability 18.00 - 55.00 - 57.00 - 0.0% 503-330-52510.000 Health Insurance 5,091.00 5,951.08 5,956.00 6,991.47 6,194.00 8,943.10 144.4% 503-330-52515.000 Dental/Vision Insurance 113.00 119.18 113.00 126.63 118.00 148.21 125.6% 503-330-52525.000 Self Insurance 1,400.00 - 1,400.00 - 1,456.00 22.75 1.6% 503-330-52530.000 Long-Term Disability Insurane 101.00 106.36 101.00 100.96 105.00 66.02 62.9% 503-330-52820.000 Deferred Comp Employer Match 210.00 209.96 210.00 209.96 218.00 647.51 297.0% 503-330-61100.000 Postage 50.00 - 51.00 43.29 353.00 - 0.0% 503-330-61200.000 Printing and Copying - - 6.00 - 563.00 - 0.0% 503-330-61300.000 Advertising - - 6.00 - 1,763.00 - 0.0% 503-330-61400.000 Office Supplies 100.00 25.95 103.00 69.50 605.00 18.06 3.0% 503-330-63300.000 Financial Services 5,000.00 4,890.77 4,670.00 4,668.86 5,463.00 4,439.97 81.3% 503-330-63700.000 Public Works Services 63,000.00 63,442.72 63,770.00 62,697.27 66,189.00 11,230.25 17.0% (20,000) 503-330-63800.000 Sewer & Water Services 20,000.00 19,992.72 8,289.00 8,287.74 21,013.00 8,320.30 39.6% (5,000) 503-330-63900.000 General Services 500.00 - 513.00 172,115.00 25,525.00 17,072.77 66.9% 503-330-64300.000 Water Utility 1,500.00 969.13 925.00 897.52 1,051.00 568.51 54.1% 503-330-64400.000 Waste Disposal 2,000.00 1,832.21 2,027.00 1,949.52 2,101.00 1,035.03 49.3% 503-330-64600.000 Cell Phone Charges 2,474.00 1,098.48 980.00 979.00 1,261.00 419.27 33.2% 503-330-64900.000 Other Utilities 1,169.00 668.40 718.00 672.07 735.00 285.00 38.8% 503-330-65000.000 Vehicle & Equip. Parts & Supplies - - - - 500.00 44.60 8.9% 503-330-65100.000 General Operating Supplies 1,000.00 18.34 63.00 61.81 525.00 - 0.0% 503-330-65200.000 Uniforms / Personnel Equipment - 40.49 - - - - #DIV/0! 503-330-65600.000 Janitorial Supplies 500.00 63.89 8.00 - 315.00 31.54 10.0% 503-330-65700.000 Public Works Supplies - 65.85 33.00 - 131.00 - 0.0% 503-330-65800.000 Permits & Inspections 1,000.00 221.36 24,035.00 24,035.00 25,368.00 24,687.00 97.3% 503-330-65900.000 Building Maintenance Supplies 1,000.00 1,247.98 38.00 - 1,576.00 - 0.0% 503-330-66100.000 Gasoline & Oil 12,500.00 13,818.72 24,018.00 24,001.65 25,343.00 14,311.56 56.5% 503-330-66200.000 Vehicle and Equipment Maintenance - - - - 1,000.00 - 0.0% 503-330-66300.000 General Operations Equipment 1,000.00 654.47 560.00 551.90 1,051.00 479.40 45.6% 503-330-67100.000 Meetings & Conferences 1,000.00 - 55.00 46.36 1,710.00 - 0.0% 503-330-67200.000 Other Training 1,000.00 195.00 58.00 50.00 2,315.00 240.20 10.4% 503-330-67400.000 Certifications 500.00 110.00 56.00 50.00 2,263.00 56.65 2.5% 503-330-67600.000 Publications 500.00 - 6.00 - 1,763.00 - 0.0% 503-330-68700.000 Property Taxes 6,200.00 6,206.24 6,310.00 6,304.86 6,524.00 6,619.48 101.5% 503-330-69100.000 Depreciation 300,000.00 566,772.49 445,875.00 579,217.80 457,022.00 - 0.0% 503-330-95610.000 HR Allocation 842.00 - 863.00 - 885.00 - 0.0% 503-330-95620.000 IT Allocation 1,013.00 - 1,038.00 - 1,064.00 - 0.0% 503-330-95680.000 Risk Management Allocation 2,080.00 - 2,132.00 - 2,185.00 - 0.0% 458,943.00 716,418.22 665,032.00 925,955.98 739,669.00 157,560.94 21.3% (25,000.00) 316
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
503-333-51100.000 Salaries 232,127.00 221,101.67 300,916.00 257,332.08 312,953.00 148,080.32 47.3% (50,000) 503-333-51105.000 Emergency Leave - 1,653.17 - - - - #DIV/0! 503-333-51300.000 Overtime 22,000.00 20,830.49 18,000.00 30,687.23 12,000.00 29,422.03 245.2% 30,000 503-333-51410.000 Bilingual Pay 4,914.00 3,585.00 4,914.00 3,564.00 5,111.00 1,530.00 29.9% 503-333-51415.000 Leave Payoff - 1,544.36 - 11,125.11 - 24,441.52 #DIV/0! 503-333-51420.000 Certification Stipend 2,232.00 2,585.49 2,594.00 2,368.82 2,697.00 492.91 18.3% 503-333-51495.000 On-Call Pay 4,000.00 1,765.09 4,000.00 2,407.03 4,160.00 1,530.00 36.8% 503-333-52110.000 Social Security 15,639.00 15,069.95 19,615.00 18,324.74 20,400.00 12,395.22 60.8% 503-333-52120.000 Medicare 3,657.00 3,525.47 4,587.00 4,286.26 4,771.00 2,899.05 60.8% 503-333-52300.000 Workers' Compensation 21,720.00 63.41 21,374.00 - 22,229.00 - 0.0% 503-333-52400.000 PERS 20,655.00 20,343.10 25,202.00 23,019.98 26,210.00 11,610.75 44.3% 503-333-52450.000 Unfunded Liability 17,468.00 - 17,248.00 - 17,938.00 - 0.0% 503-333-52510.000 Health Insurance 32,833.00 26,951.40 47,038.00 31,656.10 48,919.00 12,129.05 24.8% 503-333-52515.000 Dental/Vision Insurance 1,344.00 1,163.94 1,506.00 1,257.32 1,567.00 611.45 39.0% 503-333-52525.000 Self Insurance 16,600.00 - 10,000.00 - 10,400.00 217.75 2.1% 503-333-52530.000 Long-Term Disability Insurance 1,291.00 1,056.95 1,486.00 1,179.64 1,545.00 530.91 34.4% 503-333-52820.000 Deferred Comp Employer Match 240.00 240.02 240.00 240.00 250.00 336.07 134.4% 503-333-61700.000 Software Maintenance Charges - - - - 5,525.00 2,046.00 37.0% 503-333-63700.000 Wastewater Collection Services 7,000.00 5,707.44 2,485.00 2,485.00 11,025.00 7,197.01 65.3% 503-333-63800.000 Sewer Collection Services - 813.00 (20,000.00) 16,691.44 35,125.00 24,931.90 71.0% 503-333-64100.000 Electricity 4,500.00 5,931.55 7,760.00 7,758.09 9,113.00 4,477.72 49.1% 503-333-64500.000 Phone Charges 350.00 305.47 370.00 333.24 479.00 238.63 49.8% 503-333-65000.000 Vehicle & Equip. Parts & Supplies 1,200.00 1,494.75 1,323.00 1,322.04 1,500.00 733.20 48.9% 503-333-65100.000 General Operating Supplies - - 1,095.00 1,094.99 1,025.00 - 0.0% 503-333-65200.000 Uniforms/Personnel Equipment 2,500.00 1,869.15 2,665.00 2,664.10 3,038.00 1,628.97 53.6% 503-333-65700.000 Public Works Supplies 8,500.00 6,773.13 4,500.00 4,453.54 9,613.00 4,591.28 47.8% 503-333-65800.000 Permits & Inspections 2,000.00 1,888.00 560.00 553.00 1,025.00 1,387.36 135.4% 503-333-65900.000 Building Maintenance Supplies - - - - 1,000.00 - 0.0% 503-333-66200.000 Vehicle and Equipment Maintenance 600.00 425.53 220.00 219.75 3,000.00 1,209.20 40.3% 503-333-66300.000 General Equipment Operations 500.00 807.81 653.00 652.27 2,013.00 667.55 33.2% 503-333-67100.000 Meetings & Conferences 500.00 - - - 1,013.00 - 0.0% 503-333-67200.000 Other Training 1,000.00 953.44 190.00 119.00 1,525.00 - 0.0% 503-333-67400.000 Certifications 250.00 96.00 325.00 324.75 3,038.00 96.00 3.2% 503-333-67600.000 Publications 400.00 359.17 - - 1,025.00 361.38 35.3% 503-333-68300.000 Memberships 300.00 180.00 300.00 185.00 513.00 191.00 37.2% 503-333-68700.000 Property Taxes 300.00 - 50.00 - 666.00 - 0.0% 503-333-73600.000 Studies 7,521.00 57,377.85 - - - - #DIV/0! 503-333-95610.000 HR Allocation 9,526.00 - 8,526.00 - 8,739.00 - 0.0% 503-333-95620.000 IT Allocation 10,630.00 - 11,331.00 - 11,615.00 - 0.0% 503-333-95630.000 Fleet Allocation 18,519.00 - 21,352.00 - 21,886.00 - 0.0% 503-333-95680.000 Risk Management Allocation 23,529.00 - 19,925.00 - 20,423.00 - 0.0% 496,345.00 406,461.80 542,350.00 426,304.52 645,074.00 295,984.23 45.9% (20,000.00) 503-335-61400.000 Office Supplies 150.00 226.22 - - 500.00 197.04 39.4% 503-335-63700.000 Public Works Services 1,000.00 5,206.25 61,365.00 47,678.90 51,025.00 16,828.22 33.0% 503-335-63800.000 Sewer Treatment Services 255,000.00 256,060.50 374,800.00 367,592.81 416,250.00 146,872.21 35.3% 503-335-63900.000 General Services - 124.50 27.00 1,867.50 275,000.00 172,216.37 62.6% 503-335-64100.000 Electricity 75,000.00 64,691.53 70,000.00 113,849.40 121,750.00 148,687.23 122.1% 45,000 503-335-64500.000 Phone Charges 500.00 347.22 334.00 333.24 850.00 204.24 24.0% 503-335-64900.000 Other Utilities 2,700.00 1,974.03 - - 1,550.00 34.04 2.2% 503-335-65100.000 General Operating Supplies - 21.31 215.00 196.20 1,013.00 221.28 21.8% 503-335-65200.000 Uniforms / Personnel Equipment 3,100.00 2,051.87 700.00 669.25 3,038.00 1,343.18 44.2% 503-335-65600.000 Janitorial Supplies 700.00 395.41 700.00 651.46 1,218.00 437.77 35.9% 317
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
503-335-65700.000 Public Works Supplies 7,500.00 7,168.14 8,185.00 9,381.64 14,613.00 8,781.78 60.1% 503-335-65800.000 Permits & Inspections 6,800.00 6,793.00 435.00 316.00 6,663.00 329.00 4.9% 503-335-65900.000 Building Maintenance Supplies 2,500.00 2,313.99 500.00 436.92 12,563.00 2,044.45 16.3% 503-335-66200.000 Vehicle and Equipment Maintenance 1,000.00 761.53 1,040.00 1,039.08 1,025.00 833.20 81.3% 503-335-66300.000 General Equipment Operations 5,000.00 5,679.62 10,270.00 10,268.96 15,125.00 5,898.02 39.0% 503-335-66400.000 Sewer Operations Eqt Maint & Repair 10,500.00 10,044.86 15,795.00 15,535.95 15,375.00 12,711.12 82.7% 503-335-67200.000 Other Training 1,400.00 1,335.12 2,200.00 2,116.60 3,075.00 312.85 10.2% 503-335-67400.000 Certifications 1,500.00 224.00 1,046.00 1,045.29 2,025.00 280.00 13.8% 503-335-73600.000 Studies - 212,365.72 - - - - #DIV/0!
374,350.00 577,784.82 547,612.00 572,979.20 942,658.00 518,232.00 55.0% 45,000.00 503-390-81580.000 Sewer Vehicles 50,000.00 - - - - - #DIV/0! 503-390-81810.000 Tractor (150 hr) - - - - 22,000.00 20,514.19 93.2% 503-390-85805.000 Scada System - - - - - - #DIV/0!
503-390-85810.000 Larsen Lane Backwater Valve Repair 1,300.00 - - - - - #DIV/0! 503-390-85815.000 Replace Headworks 125,000.00 - - - - - #DIV/0! 503-390-89130.000 Sewer Plant Improvements (FY21-22/FY22-23) - - 317,500.00 - 195,000.00 26,705.59 13.7% 503-390-89131.000 WWTP Spray Fields Environmental 2022 - - - - 44,000.00 2,832.50 6.4% 503-390-89132.000 New WWTP Environmental 2022 - - - - 35,000.00 1,050.00 3.0% 503-390-89133.000 New WWTP Design 2022 - - - - 1,399,509.00 317,853.25 22.7% 503-900-91210.000 Principal 140,690.00 136,813.63 141,300.00 76,299.46 145,000.00 78,702.90 54.3% 503-900-91310.000 Interest Expense 82,091.00 86,938.50 85,000.00 47,821.36 83,000.00 45,380.07 54.7% 503-900-95600.000 Transfer Out 180,000.00 - 180,000.00 - 180,000.00 - 0.0% 579,081.00 223,752.13 723,800.00 124,120.82 2,103,509.00 493,038.50 23.4% Fund: 503 - SEWER FUND -
Fund: 504 - WATER FUND
504-44540.000 Water Charges 1,979,250.00 2,301,948.15 2,393,451.00 2,284,363.78 2,513,123.00 1,496,245.25 59.5% 504-44542.000 Water Charges - Contract - - - - - 392.84 #DIV/0! 504-44550.000 Meter & Connection Fees - 38,364.00 36,750.00 36,130.00 38,588.00 11,383.00 29.5% 504-44555.000 Backflow Testing - 750.00 788.00 750.00 827.00 625.00 75.6% 504-45960.000 SVBGSA Prop 68 Grant - - - - - 254,850.12 #DIV/0! 504-46110.000 Interest Income- Pooled Cash - 16,957.37 47,250.00 10,377.86 49,613.00 - 0.0% 504-46115.000 Unrealized Gain/Loss - (5,946.88) - (31,827.44) - - #DIV/0! 504-47899.000 Misc. Revenues - - - - - 84.68 #DIV/0!
1,979,250.00 2,352,072.64 2,478,239.00 2,299,794.20 2,602,151.00 1,763,580.89 67.8% 504-191-51100.000 Salaries 48,465.00 52,458.17 58,740.00 60,043.90 61,090.00 60,334.75 98.8% 30,000 504-191-51105.000 Emergency Leave - 655.55 - - - - #DIV/0! 504-191-51300.000 Overtime - 57.92 - 332.34 - 1,020.06 #DIV/0! 504-191-51410.000 Bilingual Pay 1,560.00 1,560.00 1,560.00 1,410.00 1,622.00 1,530.00 94.3% 504-191-52110.000 Social Security 2,837.00 3,048.76 3,337.00 3,474.01 3,471.00 3,666.32 105.6% 504-191-52120.000 Medicare 664.00 712.63 781.00 812.09 812.00 856.99 105.5% 504-191-52300.000 Workers' Compensation 4,535.00 - 4,172.00 - 2,339.00 - 0.0% 504-191-52400.000 PERS 4,463.00 5,071.49 5,267.00 5,574.33 5,478.00 4,654.14 85.0% 504-191-52450.000 Unfunded Liability 4,649.00 - 6,411.00 - 4,667.00 - 0.0% 504-191-52510.000 Health Insurance 13,924.00 14,998.68 16,227.00 15,761.39 16,876.00 9,793.91 58.0% 504-191-52515.000 Dental/Vision Insurance 324.00 323.59 324.00 323.59 337.00 211.49 62.8% 504-191-52525.000 Self Insurance 4,000.00 - 4,000.00 - 1,460.00 735.13 50.4% 504-191-52530.000 Long-Term Disability Insurance 279.00 278.79 - 258.24 - 95.06 #DIV/0! 318
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
504-191-52820.000 Deferred Comp Employer Match - - 279.00 - 290.00 174.94 60.3% 504-191-61100.000 Postage 500.00 - 500.00 - 500.00 270.50 54.1% 504-191-61200.000 Printing and Copying 6,000.00 4,487.62 4,500.00 4,454.83 4,613.00 3,746.06 81.2% 504-191-63300.000 Financial Services 20,000.00 36,206.02 18,000.00 37,972.65 25,150.00 25,498.71 101.4% 12,000 504-191-63800.000 Utility Bill Services 3,000.00 4,140.76 3,000.00 4,454.83 3,075.00 3,746.07 121.8% 504-191-95610.000 HR Allocation 1,989.00 - 2,039.00 - 2,090.00 - 0.0% 504-191-95620.000 IT Allocation 2,463.00 - 2,525.00 - 2,588.00 - 0.0% 504-191-95680.000 Risk Management Allocation 4,913.00 - 5,035.00 - 5,161.00 - 0.0% 124,565.00 123,999.98 136,697.00 134,872.20 141,619.00 116,334.13 82.1% 42,000.00 504-340-51100.000 Salaries 20,517.00 22,820.37 65,322.00 27,121.95 67,935.00 48,448.44 71.3% 5,000 504-340-51300.000 Overtime - 115.20 - - - - #DIV/0!
504-340-51410.000 Bilingual Pay 546.00 1,326.00 1,629.00 1,116.00 1,694.00 357.00 21.1% 504-340-51415.000 Leave Payoff - 793.24 - - - 938.84 #DIV/0! 1,000 504-340-52110.000 Social Security 1,231.00 1,426.67 1,230.00 1,594.73 1,280.00 2,880.32 225.0% 504-340-52120.000 Medicare 288.00 333.41 288.00 372.96 299.00 673.62 225.3% 504-340-52300.000 Workers' Compensation 1,920.00 - 1,523.00 - 1,584.00 - 0.0% 504-340-52400.000 PERS 1,580.00 1,925.36 1,628.00 2,285.79 1,693.00 4,575.37 270.3% 504-340-52450.000 Unfunded Liability 18.00 - 55.00 - 57.00 - 0.0% 504-340-52510.000 Health Insurance 5,091.00 6,095.80 5,956.00 7,085.17 6,194.00 8,942.93 144.4% 504-340-52515.000 Dental/Vision Insurance 113.00 122.83 113.00 128.27 118.00 148.34 125.7% 504-340-52525.000 Self Insurance 1,400.00 - 1,400.00 - 1,456.00 22.75 1.6% 504-340-52530.000 Long-Term Disability Insurance 101.00 110.06 101.00 103.20 105.00 66.03 62.9% 504-340-52820.000 Deferred Comp Employer Match 210.00 210.03 210.00 210.09 218.00 647.49 297.0% 504-340-61100.000 Postage 500.00 20.00 400.00 400.00 500.00 16.10 3.2% 504-340-61200.000 Printing and Copying - - 1,000.00 359.49 100.00 - 0.0% 504-340-63300.000 Financial Services 14,050.00 7,075.96 9,836.00 9,254.90 6,700.00 6,423.73 95.9% 504-340-63700.000 Public Works Services 13,000.00 23,407.43 30,989.00 32,804.13 22,300.00 18,263.94 81.9% 504-340-63800.000 Sewer & Water Services 16,000.00 12,416.06 9,009.00 8,789.55 15,300.00 16,233.90 106.1% 504-340-64100.000 Electricity 100.00 - 100.00 - 100.00 - 0.0% 504-340-64300.000 Water Utility - 1,373.16 3,560.00 3,559.48 3,875.00 876.45 22.6% 504-340-64400.000 Waste Disposal 1,500.00 1,456.56 1,540.00 1,539.72 2,000.00 922.56 46.1% 504-340-64600.000 Cell Phone Charges 2,274.00 1,098.49 1,000.00 978.98 1,500.00 419.26 28.0% 504-340-64900.000 Other Utilities 2,392.00 891.24 1,500.00 896.12 1,500.00 380.00 25.3% 504-340-65000.000 Vehicle & Equip. Parts & Supplies - - - - 1,000.00 623.76 62.4% 504-340-65100.000 General Operating Supplies 200.00 32.32 213.00 212.11 500.00 18.06 3.6% 504-340-65200.000 Uniforms / Personnel Equipment 500.00 500.00 500.00 364.81 1,500.00 60.37 4.0% 504-340-65700.000 Public Works Supplies - - - - 1,500.00 117.84 7.9% 504-340-65800.000 Permits & Inspections 15,000.00 2,550.35 3,419.00 1,900.99 3,000.00 2,356.19 78.5% 504-340-65900.000 Building Maintenance Supplies - 58.87 250.00 - 250.00 - 0.0% 504-340-66100.000 Gasoline & Oil 10,000.00 14,152.15 23,891.00 23,890.91 28,000.00 14,311.57 51.1% (4,000) 504-340-66200.000 Vehicle and Equipment Maintenance - - - - 1,500.00 589.66 39.3% 504-340-67200.000 Other Training - - - - 2,000.00 - 0.0% 504-340-67400.000 Certifications 1,000.00 - 680.00 160.00 1,780.00 56.65 3.2% 504-340-67600.000 Publications 500.00 - - - - - #DIV/0! 504-340-68300.000 Memberships 1,000.00 459.00 1,000.00 665.00 1,000.00 191.00 19.1% 504-340-68700.000 Property Taxes 950.00 947.92 980.00 969.20 1,050.00 1,005.84 95.8% 504-340-69100.000 Depreciation 300,000.00 587,467.93 530,000.00 610,421.62 530,000.00 - 0.0% 504-340-95610.000 HR Allocation 842.00 - 884.00 - 906.00 - 0.0% 504-340-95620.000 IT Allocation 1,013.00 - 1,064.00 - 1,090.00 - 0.0% 504-340-95680.000 Risk Management Allocation 2,080.00 - 2,184.00 - 2,238.00 - 0.0% 415,916.00 689,186.41 703,454.00 737,185.17 713,822.00 130,568.01 18.3% 2,000.00 319
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
504-345-51100.000 Salaries 249,936.00 283,406.38 364,283.00 289,836.57 378,854.00 163,139.31 43.1% (70,000) 504-345-51105.000 Emergency Leave - 1,653.16 - - - - #DIV/0! 504-345-51300.000 Overtime 22,000.00 36,078.84 22,000.00 30,738.89 22,880.00 25,081.43 109.6% 504-345-51305.000 Emergency OT - 78.89 - - - - #DIV/0!
504-345-51410.000 Bilingual Pay 6,474.00 4,365.00 4,349.00 4,344.00 4,523.00 1,902.00 42.1% 504-345-51415.000 Leave Payoff - 4,110.76 - 17,590.41 - 25,398.86 #DIV/0! 504-345-51420.000 Certification Stipend 2,232.00 2,597.70 2,594.00 2,199.01 2,697.00 865.50 32.1% 504-345-51495.000 On-Call Pay 4,000.00 2,253.43 4,000.00 2,478.99 4,160.00 1,530.00 36.8% 504-345-52110.000 Social Security 16,558.00 19,583.10 23,107.00 20,450.37 24,031.00 13,055.66 54.3% 504-345-52120.000 Medicare 3,872.00 4,578.60 5,404.00 4,782.13 5,620.00 3,053.10 54.3% 504-345-52300.000 Workers' Compensaton 23,386.00 63.43 25,875.00 - 26,910.00 - 0.0% 504-345-52400.000 PERS 23,821.00 26,390.86 31,754.00 25,241.09 33,025.00 12,743.79 38.6% 504-345-52450.000 Unfunded Liability 28,433.00 - 30,839.00 - 32,073.00 - 0.0% 504-345-52510.000 Health Insurance 46,518.00 45,599.95 66,297.00 43,349.03 68,949.00 17,373.37 25.2% 504-345-52515.000 Dental/Vision Insurance 1,344.00 1,386.83 1,830.00 1,322.64 1,904.00 700.11 36.8% 504-345-52525.000 Self Insurance 16,600.00 - 22,600.00 - 23,504.00 243.75 1.0% 504-345-52530.000 Long-Term Disability Insurance 1,349.00 1,341.53 1,776.00 1,091.76 1,847.00 407.63 22.1% 504-345-52820.000 Deferred Comp Employer Match 240.00 239.96 240.00 239.03 250.00 433.92 173.6% 504-345-61700.000 Software Maintenance Charges 16,100.00 18,155.98 8,300.00 9,420.70 15,308.00 12,704.83 83.0% 504-345-63700.000 Public Works Services 5,000.00 14,061.21 12,329.00 12,328.50 137,300.00 65,543.54 47.7% 504-345-63800.000 Water Production Services 75,000.00 76,940.75 61,504.00 60,971.27 52,525.00 12,453.80 23.7% 504-345-63900.000 General Services - - - - 250,000.00 78,579.97 31.4% 504-345-64100.000 Electricity 153,900.00 156,501.19 170,000.00 254,644.07 265,000.00 107,526.17 40.6% 504-345-64200.000 Gas Utility 200.00 57.36 200.00 57.65 205.00 16.51 8.1% 504-345-64500.000 Phone Charges 900.00 2,068.59 2,119.00 2,118.86 2,423.00 1,244.68 51.4% 504-345-64900.000 Other Utilities - - - - 1,025.00 - 0.0% 504-345-65000.000 Vehicle & Equip. Parts & Supplies 1,000.00 932.76 1,475.00 1,474.06 2,000.00 268.81 13.4% 504-345-65100.000 General Operating Supplies - - 500.00 - 513.00 - 0.0% 504-345-65200.000 Uniforms / Personnel Equipment 2,500.00 3,419.62 3,189.00 3,188.76 3,563.00 2,584.25 72.5% 504-345-65600.000 Janitorial Supplies - - 69.00 68.60 500.00 - 0.0% 504-345-65700.000 Public Works Supplies 75,000.00 64,661.54 60,000.00 62,583.07 91,500.00 46,687.46 51.0% 504-345-65800.000 Permits & Inspections 10,300.00 8,148.00 10,494.00 10,493.16 27,450.00 27,315.22 99.5% 504-345-65900.000 Building Maintenance Supplies 500.00 266.65 500.00 18.00 2,513.00 814.60 32.4% 504-345-66200.000 Vehicle and Equipment Maintenance 1,300.00 320.20 956.00 955.16 1,808.00 41.28 2.3% 504-345-66300.000 General Operations Equipment 2,700.00 2,431.26 7,081.00 7,080.87 9,563.00 5,116.88 53.5% 504-345-66500.000 Water Operations Equipment 10,000.00 10,604.45 6,333.00 4,462.84 10,250.00 10,250.00 100.0% 504-345-67200.000 Other Training 2,000.00 509.76 2,000.00 929.50 2,050.00 468.80 22.9% 504-345-67400.000 Certifications 500.00 140.00 817.00 816.00 1,513.00 370.00 24.5% 504-345-67600.000 Publications - - 500.00 198.53 1,013.00 361.39 35.7% 504-345-68200.000 Community Outreach - 3,500.00 - - - - #DIV/0! 504-345-68300.000 Memberships 1,000.00 680.00 750.00 685.00 769.00 - 0.0% 504-345-71800.000 Water Equipment - 24,697.04 27,752.00 27,041.34 35,000.00 18,029.05 51.5% 504-345-71903.000 Chlorine Free Analyzer - - - - 18,700.00 16,984.15 90.8% 504-345-73600.000 Studies 6,453.00 43,573.22 - - - - #DIV/0! 504-345-95610.000 HR Allocation 10,257.00 - 10,514.00 - 10,776.00 - 0.0% 504-345-95620.000 IT Allocation 11,635.00 - 11,926.00 - 12,224.00 - 0.0% 504-345-95630.000 Fleet Allocation 17,172.00 - 17,601.00 - 18,041.00 - 0.0% 504-345-95680.000 Risk Management Allocation 25,335.00 - 25,968.00 - 26,617.00 - 0.0% 875,515.00 865,398.00 1,049,825.00 903,199.86 1,631,376.00 673,289.82 41.3% (70,000.00) 504-390-72000.000 Minor Projects - - 3,300.00 - - - #DIV/0! 504-390-85805.000 Scada System - - - - - - #DIV/0!
320
2020-2021
Total Budget
2020-2021
Total Activity
2021-2022
Total Budget
2021-2022
Total Activity
2022-2023
Total Budget
2022-2023
YTD Activity
YTD % of
Budget
Budget
Adjustment
504-390-86200.000 Well #6 55,000.00 - 70,000.00 - - - #DIV/0! 504-390-86205.000 GSA - GSP Preparation 58,084.00 104,385.05 125,000.00 59,131.87 60,000.00 21,486.26 35.8% 504-390-86210.000 Apple Avenue Consolidation Project - - - - 307,776.00 - 0.0% 504-390-86801.000 Well Projects - - 500,000.00 - 3,375,000.00 17,423.75 0.5% 504-900-91210.000 Principal 339,139.00 327,523.14 359,200.00 462,934.57 365,000.00 296,217.10 81.2% 504-900-91310.000 Interest Expense 172,440.00 185,460.67 152,300.00 226,469.17 147,300.00 147,007.87 99.8% 504-900-95600.000 Transfer Out 180,000.00 - 180,000.00 - 180,000.00 - 0.0% 804,663.00 617,368.86 1,389,800.00 748,535.61 4,435,076.00 482,134.98 10.9% - Fund: 504 - WATER FUND (26,000)
321